{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["操控界面","有效性","辅助明细账","研发支出辅助账汇总表","研发支出辅助账模板"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"操控界面","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["项目序号","项目编号","项目名称","完成情况","支出类型",null,"会计主管："]
[{"$f":"IF(C2<>\"\",ROW()-1,\"\")","v":""},null,null,null,null,null,"录入人："]
[{"$f":"IF(C3<>\"\",ROW()-1,\"\")","v":""}]
[{"$f":"IF(C4<>\"\",ROW()-1,\"\")","v":""}]
[{"$f":"IF(C5<>\"\",ROW()-1,\"\")","v":""}]
[{"$f":"IF(C6<>\"\",ROW()-1,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(C17<>\"\",ROW()-1,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"有效性","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["费用类别","列次"]
["人员人工费用",7]
["直接投入费用",8]
["折旧费用",9]
["无形资产摊销",10]
["新产品设计费等",11]
["其他相关费用",12]
["委托境内机构或个人进行研发活动所发生的费用",13]
["委托境外机构进行研发活动所发生的费用",14]

{"sheet":"辅助明细账","index":2,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["项目名称","日期","种类","号数","摘要","会计凭证记载金额","税法规定的归集金额","费用类别"]

{"sheet":"研发支出辅助账汇总表","index":3,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,16],[4,11,4,12],[4,13,4,16],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[21,12,21,13],[4,0,6,0],[4,1,6,1],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10]]}
[]
["2021版研发支出辅助账汇总表"]
["纳税人识别号（统一社会信用代码）：",null,null,null,null,null,null,null,null,"纳税人名称：",null,null,null,"属期：",null,"金额单位：元"]
[]
["项目编号","项目名称","完成情况","支出类型 ","允许加计扣除金额合计","人员人工费用","直接投入费用","折旧费用","无形资产摊销","新产品\n设计费等","前五项 小计","其他相关费用及限额",null,"委托研发费用及限额"]
[null,null,null,null,null,null,null,null,null,null,null,"其他相关费用合计","经限额调整后的其他相关费用","委托境内机构或个人进行研发活动所发生的费用","允许加计扣除的委托境内机构或个人进行研发活动所发生的费用","委托境外机构进行研发活动所发生的费用","经限额调整后的委托境外机构进行研发活动所发生的费用"]
[null,null,null,null,null,"1","2","3","4","5","6","7.1","7.2",8.1,8.2,8.3,8.4]
[null,null,null,null,{"$f":"SUM(K8,M8,O8,Q8)","v":{"$error":"#DIV/0!"}},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B8,辅助明细账!$H:$H,F$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B8,辅助明细账!$H:$H,G$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B8,辅助明细账!$H:$H,H$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B8,辅助明细账!$H:$H,I$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B8,辅助明细账!$H:$H,J$5)","v":0},{"$f":"SUM(F8:J8)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B8,辅助明细账!$H:$H,\"其他相关费用\")","v":0},{"$f":"IF(D8=\"费用化\",\"\",ROUND($M$21/$L$21*L8,2))","v":{"$error":"#DIV/0!"}},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B8,辅助明细账!$H:$H,$N$6)","v":0},{"$f":"ROUND(N8*0.8,2)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B8,辅助明细账!$H:$H,$P$6)","v":0},{"$f":"IF(D8=\"费用化\",\"\",ROUND($Q$21/$P$21*P8,2))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"SUM(K9,M9,O9,Q9)","v":{"$error":"#DIV/0!"}},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B9,辅助明细账!$H:$H,F$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B9,辅助明细账!$H:$H,G$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B9,辅助明细账!$H:$H,H$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B9,辅助明细账!$H:$H,I$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B9,辅助明细账!$H:$H,J$5)","v":0},{"$f":"SUM(F9:J9)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B9,辅助明细账!$H:$H,\"其他相关费用\")","v":0},{"$f":"IF(D9=\"费用化\",\"\",ROUND($M$21/$L$21*L9,2))","v":{"$error":"#DIV/0!"}},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B9,辅助明细账!$H:$H,$N$6)","v":0},{"$f":"ROUND(N9*0.8,2)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B9,辅助明细账!$H:$H,$P$6)","v":0},{"$f":"IF(D9=\"费用化\",\"\",ROUND($Q$21/$P$21*P9,2))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B10,辅助明细账!$H:$H,F$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B10,辅助明细账!$H:$H,G$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B10,辅助明细账!$H:$H,H$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B10,辅助明细账!$H:$H,I$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B10,辅助明细账!$H:$H,J$5)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B10,辅助明细账!$H:$H,\"其他相关费用\")","v":0},{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B10,辅助明细账!$H:$H,$N$6)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B10,辅助明细账!$H:$H,$P$6)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B11,辅助明细账!$H:$H,F$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B11,辅助明细账!$H:$H,G$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B11,辅助明细账!$H:$H,H$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B11,辅助明细账!$H:$H,I$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B11,辅助明细账!$H:$H,J$5)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B11,辅助明细账!$H:$H,\"其他相关费用\")","v":0},{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B11,辅助明细账!$H:$H,$N$6)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B11,辅助明细账!$H:$H,$P$6)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B12,辅助明细账!$H:$H,F$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B12,辅助明细账!$H:$H,G$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B12,辅助明细账!$H:$H,H$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B12,辅助明细账!$H:$H,I$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B12,辅助明细账!$H:$H,J$5)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B12,辅助明细账!$H:$H,\"其他相关费用\")","v":0},{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B12,辅助明细账!$H:$H,$N$6)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B12,辅助明细账!$H:$H,$P$6)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B13,辅助明细账!$H:$H,F$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B13,辅助明细账!$H:$H,G$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B13,辅助明细账!$H:$H,H$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B13,辅助明细账!$H:$H,I$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B13,辅助明细账!$H:$H,J$5)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B13,辅助明细账!$H:$H,\"其他相关费用\")","v":0},{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B13,辅助明细账!$H:$H,$N$6)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B13,辅助明细账!$H:$H,$P$6)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B14,辅助明细账!$H:$H,F$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B14,辅助明细账!$H:$H,G$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B14,辅助明细账!$H:$H,H$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B14,辅助明细账!$H:$H,I$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B14,辅助明细账!$H:$H,J$5)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B14,辅助明细账!$H:$H,\"其他相关费用\")","v":0},{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B14,辅助明细账!$H:$H,$N$6)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B14,辅助明细账!$H:$H,$P$6)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B15,辅助明细账!$H:$H,F$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B15,辅助明细账!$H:$H,G$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B15,辅助明细账!$H:$H,H$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B15,辅助明细账!$H:$H,I$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B15,辅助明细账!$H:$H,J$5)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B15,辅助明细账!$H:$H,\"其他相关费用\")","v":0},{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B15,辅助明细账!$H:$H,$N$6)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B15,辅助明细账!$H:$H,$P$6)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B16,辅助明细账!$H:$H,F$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B16,辅助明细账!$H:$H,G$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B16,辅助明细账!$H:$H,H$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B16,辅助明细账!$H:$H,I$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B16,辅助明细账!$H:$H,J$5)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B16,辅助明细账!$H:$H,\"其他相关费用\")","v":0},{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B16,辅助明细账!$H:$H,$N$6)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B16,辅助明细账!$H:$H,$P$6)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B17,辅助明细账!$H:$H,F$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B17,辅助明细账!$H:$H,G$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B17,辅助明细账!$H:$H,H$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B17,辅助明细账!$H:$H,I$5)","v":0},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B17,辅助明细账!$H:$H,J$5)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B17,辅助明细账!$H:$H,\"其他相关费用\")","v":0},{"$error":"#DIV/0!"},{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B17,辅助明细账!$H:$H,$N$6)","v":0},0,{"$f":"SUMIFS(辅助明细账!$G:$G,辅助明细账!$A:$A,$B17,辅助明细账!$H:$H,$P$6)","v":0},{"$error":"#DIV/0!"}]
["资本化金额小计",null,null,null,{"$f":"K18+M18+O18+Q18","v":{"$error":"#DIV/0!"}},{"$f":"SUMIFS(F$8:F$17,$D$8:$D$17,\"资本化\")","v":0},{"$f":"SUMIFS(G$8:G$17,$D$8:$D$17,\"资本化\")","v":0},0,0,0,0,0,{"$f":"IF(D18=\"费用化\",\"\",$M$21/$L$21*L18)","v":{"$error":"#DIV/0!"}},0,0,0,{"$f":"IF(D18=\"费用化\",\"\",$Q$21/$P$21*P18)","v":{"$error":"#DIV/0!"}}]
["费用化金额小计",null,null,null,{"$f":"K19+M19+O19+Q19","v":{"$error":"#DIV/0!"}},{"$f":"SUMIFS(F$8:F$17,$D$8:$D$17,\"费用化\")","v":0},{"$f":"SUMIFS(G$8:G$17,$D$8:$D$17,\"费用化\")","v":0},0,0,0,0,0,{"$f":"$M$21-SUM(M8:M17)","v":{"$error":"#DIV/0!"}},0,0,0,{"$f":"$M$21-SUM(Q8:Q17)","v":{"$error":"#DIV/0!"}}]
["    其中：其他事项",null,null,null,{"$f":"K20+M20+O20+Q20","v":0}]
["金额合计",null,null,null,{"$f":"E18+E19","v":{"$error":"#DIV/0!"}},{"$f":"F18+F19","v":0},{"$f":"G18+G19","v":0},0,0,0,0,0,{"$f":"ROUND(MIN(K21/0.9*0.1,L21),2)","v":0},0,0,0,{"$f":"ROUND(MIN(P21*0.8,($K$21+$M$21+$O$21)*2/3),2)","v":0}]
["法定代表人（签章）："]

{"sheet":"研发支出辅助账模板","index":4,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,13],[2,1,2,2],[2,4,2,6],[3,6,3,13],[4,12,4,13],[20,0,20,3],[3,4,5,4],[3,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[3,0,4,3]]}
[]
["2021版研发支出辅助账"]
["项目编号：",null,null,"项目名称：",null,null,null,"完成情况：",null,"支出类型：",null,null,"金额单位：元"]
["凭证信息",null,null,null,"会计凭证记载金额","税法规定的归集金额","费用明细（税法规定）"]
[null,null,null,null,null,null,"人员人工费用","直接投入费用","折旧费用","无形资产摊销","新产品设计费等","其他相关费用","委托研发费用"]
["日期","种类","号数","摘要",null,null,null,null,null,null,null,null,"委托境内机构或个人进行研发活动所发生的费用","委托境外机构进行研发活动所发生的费用"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["合计金额",null,null,null,{"$f":"SUM(E7:E20)","v":0},{"$f":"SUM(F7:F20)","v":0},0,0,0,0,0,0,0,0]
["会计主管：",{"$f":"操控界面!H1","v":0},null,null,null,null,null,null,null,null,"录入人：",{"$f":"操控界面!H2","v":0}]