{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["定率法","定額法","(記載例)定率法","(記載例)定額法","（削除禁止）償却率"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[4,1,4,5],[27,1,27,5]]}
[]
["【残存簿価相当額・補助金相当額計算書】"]
[null,"決 算 月：",null,null,"償却額の端数処理："]
["１．残存簿価相当額計算"]
["財産名①："]
[null,"登録日：",null,null,"償却方法：",{"$f":"IF(C6<=DATE(2007,3,31),\"旧定率法\",\"定率法\")","v":"旧定率法"}]
[null,"処分時期：",null,null,"耐用年数："]
[null,"財産取得価格(税抜)：",null,null,"償却率：",{"$f":"IF(F7=\"\",\"\",IF(C6<=DATE(2007,3,31),VLOOKUP(F7,'（削除禁止）償却率'!A:J,4,FALSE),IF(C6>=DATE(2012,4,1),VLOOKUP(F7,'（削除禁止）償却率'!A:J,8,FALSE),VLOOKUP(F7,'（削除禁止）償却率'!A:J,5,FALSE))))","v":""}]
[null,"保証率：",{"$f":"IF(C6<=DATE(2007,3,31),\"\",IF(C6>=DATE(2012,4,1),VLOOKUP(F7,'（削除禁止）償却率'!A:J,10,FALSE),VLOOKUP(F7,'（削除禁止）償却率'!A:J,7,FALSE)))","v":""},null,"償却保証額：",{"$f":"IF(C9=\"\",\"\",C8*C9)","v":""}]
[null,null,null,null,"改定償却率：",{"$f":"IF(C6<=DATE(2007,3,31),\"\",IF(C6>=DATE(2012,4,1),VLOOKUP(F7,'（削除禁止）償却率'!A:J,9,FALSE),VLOOKUP(F7,'（削除禁止）償却率'!A:J,6,FALSE)))","v":""}]
["西暦",null,"か月",null,"償却額\n（端数処理後）","期末帳簿価格"]
[{"$f":"IF(C3=12,YEAR(C6),IF(C3<MONTH(C6),YEAR(C6),YEAR(C6)-1))","v":1900},1,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF($C$3=12,12-MONTH(C6)+1,IF($C$3<MONTH(C6),12+$C$3-MONTH(C6)+1,$C$3-MONTH(C6)+1)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",C8*F8*C12/12,IF(C8*F8>F9,C8*F8*C12/12,C8*F10*C12/12)))","v":""},null,{"$f":"C8-E12","v":0},null,{"$f":"IF(F9=\"\",IF(SUM(E12:E12)+(C8*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(C8*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[{"$f":"A12+1","v":1901},2,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C12)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C12)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F12*F8<=F12-C8*0.05,F12*F8*C13/12,IF(OFFSET(H13,-1,0)=1,(F12-C8*0.05)*C13/12,IF(F12-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F12-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C13/12))),IF(F12*F8>F9,F12*F8*C13/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C13/12,IF(OFFSET(I13,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,{"$f":"F12-E13","v":0},null,{"$f":"IF(F9=\"\",IF(SUM(E12:E12)+(F12*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F12*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[1902,3,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C13)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C13)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F13*F8<=F13-C8*0.05,F13*F8*C14/12,IF(OFFSET(H14,-1,0)=1,(F13-C8*0.05)*C14/12,IF(F13-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F13-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C14/12))),IF(F13*F8>F9,F13*F8*C14/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C14/12,IF(OFFSET(I14,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,{"$f":"F13-E14","v":0},null,{"$f":"IF(F9=\"\",IF(SUM(E12:E13)+(F13*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F13*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[1903,4,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C14)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C14)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F14*F8<=F14-C8*0.05,F14*F8*C15/12,IF(OFFSET(H15,-1,0)=1,(F14-C8*0.05)*C15/12,IF(F14-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F14-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C15/12))),IF(F14*F8>F9,F14*F8*C15/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C15/12,IF(OFFSET(I15,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,{"$f":"F14-E15","v":0},null,{"$f":"IF(F9=\"\",IF(SUM(E12:E14)+(F14*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F14*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[1904,5,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C15)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C15)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F15*F8<=F15-C8*0.05,F15*F8*C16/12,IF(OFFSET(H16,-1,0)=1,(F15-C8*0.05)*C16/12,IF(F15-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F15-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C16/12))),IF(F15*F8>F9,F15*F8*C16/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C16/12,IF(OFFSET(I16,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,{"$f":"F15-E16","v":0},null,{"$f":"IF(F9=\"\",IF(SUM(E12:E15)+(F15*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F15*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[1905,6,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C16)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C16)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F16*F8<=F16-C8*0.05,F16*F8*C17/12,IF(OFFSET(H17,-1,0)=1,(F16-C8*0.05)*C17/12,IF(F16-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F16-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C17/12))),IF(F16*F8>F9,F16*F8*C17/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C17/12,IF(OFFSET(I17,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,{"$f":"F16-E17","v":0},null,{"$f":"IF(F9=\"\",IF(SUM(E12:E16)+(F16*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F16*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[1906,7,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C17)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C17)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F17*F8<=F17-C8*0.05,F17*F8*C18/12,IF(OFFSET(H18,-1,0)=1,(F17-C8*0.05)*C18/12,IF(F17-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F17-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C18/12))),IF(F17*F8>F9,F17*F8*C18/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C18/12,IF(OFFSET(I18,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,0,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E17)+(F17*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F17*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[1907,8,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C18)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C18)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F18*F8<=F18-C8*0.05,F18*F8*C19/12,IF(OFFSET(H19,-1,0)=1,(F18-C8*0.05)*C19/12,IF(F18-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F18-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C19/12))),IF(F18*F8>F9,F18*F8*C19/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C19/12,IF(OFFSET(I19,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,0,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E18)+(F18*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F18*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[{"$f":"A19+1","v":1908},9,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C19)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C19)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F19*F8<=F19-C8*0.05,F19*F8*C20/12,IF(OFFSET(H20,-1,0)=1,(F19-C8*0.05)*C20/12,IF(F19-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F19-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C20/12))),IF(F19*F8>F9,F19*F8*C20/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C20/12,IF(OFFSET(I20,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,{"$f":"F19-E20","v":0},null,{"$f":"IF(F9=\"\",IF(SUM(E12:E19)+(F19*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F19*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[{"$f":"A20+1","v":1909},10,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C20)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C20)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F20*F8<=F20-C8*0.05,F20*F8*C21/12,IF(OFFSET(H21,-1,0)=1,(F20-C8*0.05)*C21/12,IF(F20-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F20-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C21/12))),IF(F20*F8>F9,F20*F8*C21/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C21/12,IF(OFFSET(I21,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,0,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E20)+(F20*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F20*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[{"$f":"A21+1","v":1910},11,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C21)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C21)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F21*F8<=F21-C8*0.05,F21*F8*C22/12,IF(OFFSET(H22,-1,0)=1,(F21-C8*0.05)*C22/12,IF(F21-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F21-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C22/12))),IF(F21*F8>F9,F21*F8*C22/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C22/12,IF(OFFSET(I22,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,0,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E21)+(F21*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F21*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[1911,12,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C22)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C22)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F22*F8<=F22-C8*0.05,F22*F8*C23/12,IF(OFFSET(H23,-1,0)=1,(F22-C8*0.05)*C23/12,IF(F22-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F22-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C23/12))),IF(F22*F8>F9,F22*F8*C23/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C23/12,IF(OFFSET(I23,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,0,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E22)+(F22*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F22*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[1912,13,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C23)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C23)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F23*F8<=F23-C8*0.05,F23*F8*C24/12,IF(OFFSET(H24,-1,0)=1,(F23-C8*0.05)*C24/12,IF(F23-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F23-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C24/12))),IF(F23*F8>F9,F23*F8*C24/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C24/12,IF(OFFSET(I24,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,0,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E23)+(F23*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F23*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[1913,14,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C24)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C24)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F24*F8<=F24-C8*0.05,F24*F8*C25/12,IF(OFFSET(H25,-1,0)=1,(F24-C8*0.05)*C25/12,IF(F24-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F24-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C25/12))),IF(F24*F8>F9,F24*F8*C25/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C25/12,IF(OFFSET(I25,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,0,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E24)+(F24*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F24*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[1914,15,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C25)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C25)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F25*F8<=F25-C8*0.05,F25*F8*C26/12,IF(OFFSET(H26,-1,0)=1,(F25-C8*0.05)*C26/12,IF(F25-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F25-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C26/12))),IF(F25*F8>F9,F25*F8*C26/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C26/12,IF(OFFSET(I26,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":""},null,0,"①",{"$f":"IF(F9=\"\",IF(SUM(E12:E25)+(F25*F8)<=C8*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F25*F8>F9,1,0)","v":{"$error":"#VALUE!"}}]
[]
["財産名②："]
[null,"登録日：",null,null,"償却方法：",{"$f":"IF(C29<=DATE(2007,3,31),\"旧定率法\",\"定率法\")","v":"旧定率法"}]
[null,"処分時期：",null,null,"耐用年数："]
[null,"財産取得価格(税抜)：",null,null,"償却率：",{"$f":"IF(F30=\"\",\"\",IF(C29<=DATE(2007,3,31),VLOOKUP(F30,'（削除禁止）償却率'!A:J,4,FALSE),IF(C29>=DATE(2012,4,1),VLOOKUP(F30,'（削除禁止）償却率'!A:J,8,FALSE),VLOOKUP(F30,'（削除禁止）償却率'!A:J,5,FALSE))))","v":""}]
[null,"保証率：",{"$f":"IF(C29<=DATE(2007,3,31),\"\",IF(C29>=DATE(2012,4,1),VLOOKUP(F30,'（削除禁止）償却率'!A:J,10,FALSE),VLOOKUP(F30,'（削除禁止）償却率'!A:J,7,FALSE)))","v":""},null,"償却保証額：",{"$f":"IF(C32=\"\",\"\",C31*C32)","v":""}]
[null,null,null,null,"改定償却率：",{"$f":"IF(C29<=DATE(2007,3,31),\"\",IF(C29>=DATE(2012,4,1),VLOOKUP(F30,'（削除禁止）償却率'!A:J,9,FALSE),VLOOKUP(F30,'（削除禁止）償却率'!A:J,6,FALSE)))","v":""}]
["西暦",null,"か月",null,"償却額\n（端数処理後）","期末帳簿価格"]
[{"$f":"IF(C3=12,YEAR(C29),IF(C3<MONTH(C29),YEAR(C29),YEAR(C29)-1))","v":1900},1,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF($C$3=12,12-MONTH(C29)+1,IF($C$3<MONTH(C29),$C$3-MONTH(C29)+12+1,$C$3-MONTH(C29)+1)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(AND(F29=\"定率法\",$C$31*$F$31<$F$32),$C$31*$F$33*$C35/12,$C$31*$F$31*$C35/12))","v":""},null,{"$f":"C31-E35","v":0},null,{"$f":"IF(F32=\"\",IF(SUM(E35:E35)+(C31*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(C31*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[{"$f":"A35+1","v":1901},2,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C35)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C35)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F35*$F$31<=$F35-$C$31*0.05,$F35*F31*$C36/12,IF(OFFSET($H36,-1,0)=1,($F35-$C$31*0.05)*$C36/12,IF($F35-OFFSET($F35,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F35-1,OFFSET($F35,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C36/12))),\nIF($F35*$F$31>$F$32,$F35*$F$31*$C36/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I36=0,$F$33,$F$31)>=$F35,($F35-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I36=0,$F$33,$F$31))*$C36/12)))","v":""},null,{"$f":"F35-E36","v":0},null,{"$f":"IF(F32=\"\",IF(SUM(E35:E35)+(F35*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F35*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[1902,3,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C36)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C36)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F36*$F$31<=$F36-$C$31*0.05,$F36*F32*$C37/12,IF(OFFSET($H37,-1,0)=1,($F36-$C$31*0.05)*$C37/12,IF($F36-OFFSET($F36,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F36-1,OFFSET($F36,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C37/12))),\nIF($F36*$F$31>$F$32,$F36*$F$31*$C37/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I37=0,$F$33,$F$31)>=$F36,($F36-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I37=0,$F$33,$F$31))*$C37/12)))","v":""},null,{"$f":"F36-E37","v":0},null,{"$f":"IF(F32=\"\",IF(SUM(E35:E36)+(F36*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F36*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[1903,4,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C37)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C37)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F37*$F$31<=$F37-$C$31*0.05,$F37*F33*$C38/12,IF(OFFSET($H38,-1,0)=1,($F37-$C$31*0.05)*$C38/12,IF($F37-OFFSET($F37,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F37-1,OFFSET($F37,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C38/12))),\nIF($F37*$F$31>$F$32,$F37*$F$31*$C38/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I38=0,$F$33,$F$31)>=$F37,($F37-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I38=0,$F$33,$F$31))*$C38/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E37)+(F37*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F37*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[1904,5,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C38)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C38)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F38*$F$31<=$F38-$C$31*0.05,$F38*F34*$C39/12,IF(OFFSET($H39,-1,0)=1,($F38-$C$31*0.05)*$C39/12,IF($F38-OFFSET($F38,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F38-1,OFFSET($F38,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C39/12))),\nIF($F38*$F$31>$F$32,$F38*$F$31*$C39/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I39=0,$F$33,$F$31)>=$F38,($F38-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I39=0,$F$33,$F$31))*$C39/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E38)+(F38*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F38*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[1905,6,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C39)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C39)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F39*$F$31<=$F39-$C$31*0.05,$F39*F35*$C40/12,IF(OFFSET($H40,-1,0)=1,($F39-$C$31*0.05)*$C40/12,IF($F39-OFFSET($F39,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F39-1,OFFSET($F39,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C40/12))),\nIF($F39*$F$31>$F$32,$F39*$F$31*$C40/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I40=0,$F$33,$F$31)>=$F39,($F39-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I40=0,$F$33,$F$31))*$C40/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E39)+(F39*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F39*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[1906,7,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C40)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C40)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F40*$F$31<=$F40-$C$31*0.05,$F40*F36*$C41/12,IF(OFFSET($H41,-1,0)=1,($F40-$C$31*0.05)*$C41/12,IF($F40-OFFSET($F40,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F40-1,OFFSET($F40,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C41/12))),\nIF($F40*$F$31>$F$32,$F40*$F$31*$C41/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I41=0,$F$33,$F$31)>=$F40,($F40-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I41=0,$F$33,$F$31))*$C41/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E40)+(F40*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F40*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[1907,8,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C41)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C41)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F41*$F$31<=$F41-$C$31*0.05,$F41*F37*$C42/12,IF(OFFSET($H42,-1,0)=1,($F41-$C$31*0.05)*$C42/12,IF($F41-OFFSET($F41,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F41-1,OFFSET($F41,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C42/12))),\nIF($F41*$F$31>$F$32,$F41*$F$31*$C42/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I42=0,$F$33,$F$31)>=$F41,($F41-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I42=0,$F$33,$F$31))*$C42/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E41)+(F41*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F41*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[1908,9,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C42)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C42)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F42*$F$31<=$F42-$C$31*0.05,$F42*F38*$C43/12,IF(OFFSET($H43,-1,0)=1,($F42-$C$31*0.05)*$C43/12,IF($F42-OFFSET($F42,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F42-1,OFFSET($F42,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C43/12))),\nIF($F42*$F$31>$F$32,$F42*$F$31*$C43/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I43=0,$F$33,$F$31)>=$F42,($F42-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I43=0,$F$33,$F$31))*$C43/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E42)+(F42*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F42*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[{"$f":"A43+1","v":1909},10,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C43)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C43)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F43*$F$31<=$F43-$C$31*0.05,$F43*F39*$C44/12,IF(OFFSET($H44,-1,0)=1,($F43-$C$31*0.05)*$C44/12,IF($F43-OFFSET($F43,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F43-1,OFFSET($F43,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C44/12))),\nIF($F43*$F$31>$F$32,$F43*$F$31*$C44/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I44=0,$F$33,$F$31)>=$F43,($F43-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I44=0,$F$33,$F$31))*$C44/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E43)+(F43*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F43*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[{"$f":"A44+1","v":1910},11,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C44)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C44)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F44*$F$31<=$F44-$C$31*0.05,$F44*F40*$C45/12,IF(OFFSET($H45,-1,0)=1,($F44-$C$31*0.05)*$C45/12,IF($F44-OFFSET($F44,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F44-1,OFFSET($F44,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C45/12))),\nIF($F44*$F$31>$F$32,$F44*$F$31*$C45/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I45=0,$F$33,$F$31)>=$F44,($F44-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I45=0,$F$33,$F$31))*$C45/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E44)+(F44*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F44*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[{"$f":"A45+1","v":1911},12,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C45)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C45)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F45*$F$31<=$F45-$C$31*0.05,$F45*F41*$C46/12,IF(OFFSET($H46,-1,0)=1,($F45-$C$31*0.05)*$C46/12,IF($F45-OFFSET($F45,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F45-1,OFFSET($F45,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C46/12))),\nIF($F45*$F$31>$F$32,$F45*$F$31*$C46/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I46=0,$F$33,$F$31)>=$F45,($F45-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I46=0,$F$33,$F$31))*$C46/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E45)+(F45*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F45*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[1912,13,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C46)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C46)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F46*$F$31<=$F46-$C$31*0.05,$F46*F42*$C47/12,IF(OFFSET($H47,-1,0)=1,($F46-$C$31*0.05)*$C47/12,IF($F46-OFFSET($F46,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F46-1,OFFSET($F46,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C47/12))),\nIF($F46*$F$31>$F$32,$F46*$F$31*$C47/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I47=0,$F$33,$F$31)>=$F46,($F46-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I47=0,$F$33,$F$31))*$C47/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E46)+(F46*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F46*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[1913,14,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C47)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C47)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F47*$F$31<=$F47-$C$31*0.05,$F47*F43*$C48/12,IF(OFFSET($H48,-1,0)=1,($F47-$C$31*0.05)*$C48/12,IF($F47-OFFSET($F47,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F47-1,OFFSET($F47,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C48/12))),\nIF($F47*$F$31>$F$32,$F47*$F$31*$C48/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I48=0,$F$33,$F$31)>=$F47,($F47-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I48=0,$F$33,$F$31))*$C48/12)))","v":""},null,0,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E47)+(F47*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F47*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[1914,15,{"$f":"IF(OR($C$3=\"\",$C$6=\"\"),0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C48)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C48)))","v":0},{"$f":"IF(F31=\"\",\"\",IF($F$29=\"旧定率法\",IF($F48*$F$31<=$F48-$C$31*0.05,$F48*F44*$C49/12,IF(OFFSET($H49,-1,0)=1,($F48-$C$31*0.05)*$C49/12,IF($F48-OFFSET($F48,MATCH(0,$H$35:$H$49,0)-1,0)/5<=0,$F48-1,OFFSET($F48,MATCH(0,$H$35:$H$49,0)-1,0)/5*$C49/12))),\nIF($F48*$F$31>$F$32,$F48*$F$31*$C49/12,\nIF(OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I49=0,$F$33,$F$31)>=$F48,($F48-1),OFFSET($F$35,MATCH(0,$I$35:$I$49,0)-2,0)*IF($I49=0,$F$33,$F$31))*$C49/12)))","v":""},null,0,"②",{"$f":"IF(F32=\"\",IF(SUM(E35:E48)+(F48*F31)<=C31*0.95,1,0),1)","v":{"$error":"#VALUE!"}},{"$f":"IF(F48*F31>F32,1,0)","v":{"$error":"#VALUE!"}}]
[]
["２．補助割合"]
["各年度の年度末中間検査、確定検査の経費発生調書に記載されている数字の転記(補助金の額が確定している場合)"]
[]
["補助期間\n（年度）","補助対象費用欄【e】の補助金額","補助対象費用欄【e】のⅣ-2学術機関等共同研究費","当年度発生額合計欄【b】の総計B","当年度発生学合計欄【b】のⅣ-2学術機関等共同研究費"]
[]
[]
[]
["合計額",{"$f":"SUM(B55:B57)","v":0},{"$f":"SUM(C55:C57)","v":0},{"$f":"SUM(D55:D57)","v":0},{"$f":"SUM(E55:E57)","v":0}]
[]
[]
["３．補助相当額"]
[null,"残存簿価相当額（合計）",{"$f":"F26+F49","v":0}]
[null,"補助割合",{"$f":"(B58-C58)/(D58-E58)","v":{"$error":"#DIV/0!"}}]
[]
[null,"補助金相当額",{"$f":"ROUNDDOWN(C62*C63,0)","v":{"$error":"#DIV/0!"}}]

{"sheet":"定額法","index":1,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[[4,1,4,5],[27,1,27,5]]}
[]
["【残存簿価相当額・補助金相当額計算書】"]
[null,"決 算 月：",null,null,"償却額の端数処理："]
["１．残存簿価相当額計算"]
["財産名①："]
[null,"登録日：",null,null,"償却方法：",{"$f":"IF(C6<=DATE(2007,3,31),\"旧定額法\",\"定額法\")","v":"旧定額法"}]
[null,"処分時期：",null,null,"耐用年数："]
[null,"財産取得価格(税抜)：",null,null,"償却率：",{"$f":"IF(F7=\"\",\"\",IF(C6<=DATE(2007,3,31),VLOOKUP(F7,'（削除禁止）償却率'!A:J,2,FALSE),VLOOKUP(F7,'（削除禁止）償却率'!A:J,3,FALSE)))","v":""}]
[]
[]
["西暦",null,"か月",null,"償却額\n（端数処理後）","期末帳簿価格"]
[{"$f":"IF(C3=12,YEAR(C6),IF(C3<MONTH(C6),YEAR(C6),YEAR(C6)-1))","v":1900},1,{"$f":"IF($C$3=\"\",0,IF($C$3=12,12-MONTH(C6)+1,IF($C$3<MONTH(C6),12+$C$3-MONTH(C6)+1,$C$3-MONTH(C6)+1)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",C8*F8*0.9*C12/12,C8*F8*C12/12))","v":""},null,{"$f":"C8-E12","v":0},null,{"$f":"IF(C8*F8*0.9>C8-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[{"$f":"A12+1","v":1901},2,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C12)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C12)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F12-C8*0.05,C8*F8*0.9*C13/12,IF(OFFSET(H13,-1,0)=1,(F12-C8*0.05)*C13/12,IF(F12-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F12-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C13/12))),IF(IF(F12-C8*F8*C13/12>0,C8*F8*C13/12,F12-1)>0,IF(F12-C8*F8*C13/12>0,C8*F8*C13/12,F12-1),0)))","v":""},null,{"$f":"F12-E13","v":0},null,{"$f":"IF(C8*F8*0.9>F12-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1902,3,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C13)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C13)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F13-C8*0.05,C8*F8*0.9*C14/12,IF(OFFSET(H14,-1,0)=1,(F13-C8*0.05)*C14/12,IF(F13-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F13-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C14/12))),IF(IF(F13-C8*F8*C14/12>0,C8*F8*C14/12,F13-1)>0,IF(F13-C8*F8*C14/12>0,C8*F8*C14/12,F13-1),0)))","v":""},null,{"$f":"F13-E14","v":0},null,{"$f":"IF(C8*F8*0.9>F13-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1903,4,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C14)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C14)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F14-C8*0.05,C8*F8*0.9*C15/12,IF(OFFSET(H15,-1,0)=1,(F14-C8*0.05)*C15/12,IF(F14-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F14-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C15/12))),IF(IF(F14-C8*F8*C15/12>0,C8*F8*C15/12,F14-1)>0,IF(F14-C8*F8*C15/12>0,C8*F8*C15/12,F14-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F14-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1904,5,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C15)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C15)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F15-C8*0.05,C8*F8*0.9*C16/12,IF(OFFSET(H16,-1,0)=1,(F15-C8*0.05)*C16/12,IF(F15-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F15-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C16/12))),IF(IF(F15-C8*F8*C16/12>0,C8*F8*C16/12,F15-1)>0,IF(F15-C8*F8*C16/12>0,C8*F8*C16/12,F15-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F15-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1905,6,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C16)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C16)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F16-C8*0.05,C8*F8*0.9*C17/12,IF(OFFSET(H17,-1,0)=1,(F16-C8*0.05)*C17/12,IF(F16-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F16-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C17/12))),IF(IF(F16-C8*F8*C17/12>0,C8*F8*C17/12,F16-1)>0,IF(F16-C8*F8*C17/12>0,C8*F8*C17/12,F16-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F16-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1906,7,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C17)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C17)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F17-C8*0.05,C8*F8*0.9*C18/12,IF(OFFSET(H18,-1,0)=1,(F17-C8*0.05)*C18/12,IF(F17-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F17-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C18/12))),IF(IF(F17-C8*F8*C18/12>0,C8*F8*C18/12,F17-1)>0,IF(F17-C8*F8*C18/12>0,C8*F8*C18/12,F17-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F17-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1907,8,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C18)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C18)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F18-C8*0.05,C8*F8*0.9*C19/12,IF(OFFSET(H19,-1,0)=1,(F18-C8*0.05)*C19/12,IF(F18-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F18-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C19/12))),IF(IF(F18-C8*F8*C19/12>0,C8*F8*C19/12,F18-1)>0,IF(F18-C8*F8*C19/12>0,C8*F8*C19/12,F18-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F18-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1908,9,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C19)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C19)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F19-C8*0.05,C8*F8*0.9*C20/12,IF(OFFSET(H20,-1,0)=1,(F19-C8*0.05)*C20/12,IF(F19-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F19-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C20/12))),IF(IF(F19-C8*F8*C20/12>0,C8*F8*C20/12,F19-1)>0,IF(F19-C8*F8*C20/12>0,C8*F8*C20/12,F19-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F19-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[{"$f":"A20+1","v":1909},10,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C20)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C20)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F20-C8*0.05,C8*F8*0.9*C21/12,IF(OFFSET(H21,-1,0)=1,(F20-C8*0.05)*C21/12,IF(F20-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F20-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C21/12))),IF(IF(F20-C8*F8*C21/12>0,C8*F8*C21/12,F20-1)>0,IF(F20-C8*F8*C21/12>0,C8*F8*C21/12,F20-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F20-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[{"$f":"A21+1","v":1910},11,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C21)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C21)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F21-C8*0.05,C8*F8*0.9*C22/12,IF(OFFSET(H22,-1,0)=1,(F21-C8*0.05)*C22/12,IF(F21-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F21-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C22/12))),IF(IF(F21-C8*F8*C22/12>0,C8*F8*C22/12,F21-1)>0,IF(F21-C8*F8*C22/12>0,C8*F8*C22/12,F21-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F21-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1911,12,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C22)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C22)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F22-C8*0.05,C8*F8*0.9*C23/12,IF(OFFSET(H23,-1,0)=1,(F22-C8*0.05)*C23/12,IF(F22-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F22-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C23/12))),IF(IF(F22-C8*F8*C23/12>0,C8*F8*C23/12,F22-1)>0,IF(F22-C8*F8*C23/12>0,C8*F8*C23/12,F22-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F22-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1912,13,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C23)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C23)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F23-C8*0.05,C8*F8*0.9*C24/12,IF(OFFSET(H24,-1,0)=1,(F23-C8*0.05)*C24/12,IF(F23-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F23-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C24/12))),IF(IF(F23-C8*F8*C24/12>0,C8*F8*C24/12,F23-1)>0,IF(F23-C8*F8*C24/12>0,C8*F8*C24/12,F23-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F23-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1913,14,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C24)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C24)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F24-C8*0.05,C8*F8*0.9*C25/12,IF(OFFSET(H25,-1,0)=1,(F24-C8*0.05)*C25/12,IF(F24-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F24-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C25/12))),IF(IF(F24-C8*F8*C25/12>0,C8*F8*C25/12,F24-1)>0,IF(F24-C8*F8*C25/12>0,C8*F8*C25/12,F24-1),0)))","v":""},null,0,null,{"$f":"IF(C8*F8*0.9>F24-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1914,15,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C25)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C25)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F25-C8*0.05,C8*F8*0.9*C26/12,IF(OFFSET(H26,-1,0)=1,(F25-C8*0.05)*C26/12,IF(F25-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F25-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C26/12))),IF(IF(F25-C8*F8*C26/12>0,C8*F8*C26/12,F25-1)>0,IF(F25-C8*F8*C26/12>0,C8*F8*C26/12,F25-1),0)))","v":""},null,0,"①",{"$f":"IF(C8*F8*0.9>F25-C8*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[]
["財産名②："]
[null,"登録日：",null,null,"償却方法：",{"$f":"IF(C29<=DATE(2007,3,31),\"旧定額法\",\"定額法\")","v":"旧定額法"}]
[null,"処分時期：",null,null,"耐用年数："]
[null,"財産取得価格(税抜)：",null,null,"償却率：",{"$f":"IF(F30=\"\",\"\",IF(C29<=DATE(2007,3,31),VLOOKUP(F30,'（削除禁止）償却率'!A:J,2,FALSE),VLOOKUP(F30,'（削除禁止）償却率'!A:J,3,FALSE)))","v":""}]
[]
[]
["西暦",null,"か月",null,"償却額\n（端数処理後）","期末帳簿価格"]
[{"$f":"IF(C3=12,YEAR(C29),IF(C3<MONTH(C29),YEAR(C29),YEAR(C29)-1))","v":1900},1,{"$f":"IF($C$3=\"\",0,IF($C$3=12,12-MONTH(C29)+1,IF($C$3<MONTH(C29),$C$3-MONTH(C29)+12+1,$C$3-MONTH(C29)+1)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",C31*F31*0.9*C35/12,C31*F31*C35/12))","v":""},null,{"$f":"C31-E35","v":0},null,{"$f":"IF(C31*F31*0.9>C31-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[{"$f":"A35+1","v":1901},2,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C35)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C35)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F35-C31*0.05,C31*F31*0.9*C36/12,IF(OFFSET(H36,-1,0)=1,(F35-C31*0.05)*C36/12,IF(F35-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F35-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C36/12))),IF(IF(F35-C31*F31*C36/12>0,C31*F31*C36/12,F35-1)>0,IF(F35-C31*F31*C36/12>0,C31*F31*C36/12,F35-1),0)))","v":""},null,{"$f":"F35-E36","v":0},null,{"$f":"IF(C31*F31*0.9>F35-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1902,3,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C36)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C36)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F36-C31*0.05,C31*F31*0.9*C37/12,IF(OFFSET(H37,-1,0)=1,(F36-C31*0.05)*C37/12,IF(F36-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F36-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C37/12))),IF(IF(F36-C31*F31*C37/12>0,C31*F31*C37/12,F36-1)>0,IF(F36-C31*F31*C37/12>0,C31*F31*C37/12,F36-1),0)))","v":""},null,{"$f":"F36-E37","v":0},null,{"$f":"IF(C31*F31*0.9>F36-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1903,4,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C37)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C37)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F37-C31*0.05,C31*F31*0.9*C38/12,IF(OFFSET(H38,-1,0)=1,(F37-C31*0.05)*C38/12,IF(F37-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F37-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C38/12))),IF(IF(F37-C31*F31*C38/12>0,C31*F31*C38/12,F37-1)>0,IF(F37-C31*F31*C38/12>0,C31*F31*C38/12,F37-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F37-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1904,5,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C38)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C38)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F38-C31*0.05,C31*F31*0.9*C39/12,IF(OFFSET(H39,-1,0)=1,(F38-C31*0.05)*C39/12,IF(F38-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F38-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C39/12))),IF(IF(F38-C31*F31*C39/12>0,C31*F31*C39/12,F38-1)>0,IF(F38-C31*F31*C39/12>0,C31*F31*C39/12,F38-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F38-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1905,6,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C39)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C39)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F39-C31*0.05,C31*F31*0.9*C40/12,IF(OFFSET(H40,-1,0)=1,(F39-C31*0.05)*C40/12,IF(F39-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F39-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C40/12))),IF(IF(F39-C31*F31*C40/12>0,C31*F31*C40/12,F39-1)>0,IF(F39-C31*F31*C40/12>0,C31*F31*C40/12,F39-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F39-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1906,7,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C40)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C40)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F40-C31*0.05,C31*F31*0.9*C41/12,IF(OFFSET(H41,-1,0)=1,(F40-C31*0.05)*C41/12,IF(F40-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F40-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C41/12))),IF(IF(F40-C31*F31*C41/12>0,C31*F31*C41/12,F40-1)>0,IF(F40-C31*F31*C41/12>0,C31*F31*C41/12,F40-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F40-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1907,8,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C41)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C41)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F41-C31*0.05,C31*F31*0.9*C42/12,IF(OFFSET(H42,-1,0)=1,(F41-C31*0.05)*C42/12,IF(F41-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F41-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C42/12))),IF(IF(F41-C31*F31*C42/12>0,C31*F31*C42/12,F41-1)>0,IF(F41-C31*F31*C42/12>0,C31*F31*C42/12,F41-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F41-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1908,9,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C42)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C42)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F42-C31*0.05,C31*F31*0.9*C43/12,IF(OFFSET(H43,-1,0)=1,(F42-C31*0.05)*C43/12,IF(F42-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F42-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C43/12))),IF(IF(F42-C31*F31*C43/12>0,C31*F31*C43/12,F42-1)>0,IF(F42-C31*F31*C43/12>0,C31*F31*C43/12,F42-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F42-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1909,10,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C43)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C43)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F43-C31*0.05,C31*F31*0.9*C44/12,IF(OFFSET(H44,-1,0)=1,(F43-C31*0.05)*C44/12,IF(F43-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F43-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C44/12))),IF(IF(F43-C31*F31*C44/12>0,C31*F31*C44/12,F43-1)>0,IF(F43-C31*F31*C44/12>0,C31*F31*C44/12,F43-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F43-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1910,11,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C44)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C44)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F44-C31*0.05,C31*F31*0.9*C45/12,IF(OFFSET(H45,-1,0)=1,(F44-C31*0.05)*C45/12,IF(F44-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F44-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C45/12))),IF(IF(F44-C31*F31*C45/12>0,C31*F31*C45/12,F44-1)>0,IF(F44-C31*F31*C45/12>0,C31*F31*C45/12,F44-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F44-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1911,12,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C45)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C45)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F45-C31*0.05,C31*F31*0.9*C46/12,IF(OFFSET(H46,-1,0)=1,(F45-C31*0.05)*C46/12,IF(F45-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F45-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C46/12))),IF(IF(F45-C31*F31*C46/12>0,C31*F31*C46/12,F45-1)>0,IF(F45-C31*F31*C46/12>0,C31*F31*C46/12,F45-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F45-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1912,13,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C46)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C46)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F46-C31*0.05,C31*F31*0.9*C47/12,IF(OFFSET(H47,-1,0)=1,(F46-C31*0.05)*C47/12,IF(F46-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F46-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C47/12))),IF(IF(F46-C31*F31*C47/12>0,C31*F31*C47/12,F46-1)>0,IF(F46-C31*F31*C47/12>0,C31*F31*C47/12,F46-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F46-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1913,14,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C47)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C47)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F47-C31*0.05,C31*F31*0.9*C48/12,IF(OFFSET(H48,-1,0)=1,(F47-C31*0.05)*C48/12,IF(F47-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F47-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C48/12))),IF(IF(F47-C31*F31*C48/12>0,C31*F31*C48/12,F47-1)>0,IF(F47-C31*F31*C48/12>0,C31*F31*C48/12,F47-1),0)))","v":""},null,0,null,{"$f":"IF(C31*F31*0.9>F47-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[1914,15,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C48)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C48)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F48-C31*0.05,C31*F31*0.9*C49/12,IF(OFFSET(H49,-1,0)=1,(F48-C31*0.05)*C49/12,IF(F48-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F48-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C49/12))),IF(IF(F48-C31*F31*C49/12>0,C31*F31*C49/12,F48-1)>0,IF(F48-C31*F31*C49/12>0,C31*F31*C49/12,F48-1),0)))","v":""},null,0,"②",{"$f":"IF(C31*F31*0.9>F48-C31*0.05,0,1)","v":{"$error":"#VALUE!"}}]
[]
["２．補助割合"]
["各年度の年度末中間検査、確定検査の経費発生調書に記載されている数字の転記(補助金の額が確定している場合)"]
[]
["補助期間\n（年度）","補助対象費用欄【e】の補助金額","補助対象費用欄【e】のⅣ-2学術機関等共同研究費","当年度発生額合計欄【b】の総計B","当年度発生学合計欄【b】のⅣ-2学術機関等共同研究費"]
[]
[]
[]
["合計額",{"$f":"SUM(B55:B57)","v":0},{"$f":"SUM(C55:C57)","v":0},{"$f":"SUM(D55:D57)","v":0},{"$f":"SUM(E55:E57)","v":0}]
[]
[]
["３．補助相当額"]
[null,"残存簿価相当額（合計）",{"$f":"F26+F49","v":0}]
[null,"補助割合",{"$f":"(B58-C58)/(D58-E58)","v":{"$error":"#DIV/0!"}}]
[]
[null,"補助金相当額",{"$f":"ROUNDDOWN(C62*C63,0)","v":{"$error":"#DIV/0!"}}]

{"sheet":"(記載例)定率法","index":2,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[4,1,4,5],[27,1,27,5]]}
[]
["【残存簿価相当額・補助金相当額計算書】"]
[null,"決 算 月：",3,null,"償却額の端数処理：","切り捨て"]
["１．残存簿価相当額計算"]
["財産名①：","AAAAAAAAA"]
[null,"登録日：","2006-03-15",null,"償却方法：",{"$f":"IF(C6<=DATE(2007,3,31),\"旧定率法\",\"定率法\")","v":"旧定率法"}]
[null,"処分時期：","2017-08-31",null,"耐用年数：",8]
[null,"財産取得価格(税抜)：",14429684,null,"償却率：",{"$f":"IF($F$7=\"\",\"\",IF(C6<=DATE(2007,3,31),VLOOKUP(F7,'（削除禁止）償却率'!A:J,4,FALSE),IF(C6>=DATE(2012,4,1),VLOOKUP(F7,'（削除禁止）償却率'!A:J,8,FALSE),VLOOKUP(F7,'（削除禁止）償却率'!A:J,5,FALSE))))","v":0.25}]
[null,"保証率：",{"$f":"IF(C6<=DATE(2007,3,31),\"\",IF(C6>=DATE(2012,4,1),VLOOKUP(F7,'（削除禁止）償却率'!A:J,10,FALSE),VLOOKUP(F7,'（削除禁止）償却率'!A:J,7,FALSE)))","v":""},null,"償却保証額：",{"$f":"IF(C9=\"\",\"\",C8*C9)","v":""}]
[null,null,null,null,"改定償却率：",{"$f":"IF(C6<=DATE(2007,3,31),\"\",IF(C6>=DATE(2012,4,1),VLOOKUP(F7,'（削除禁止）償却率'!A:J,9,FALSE),VLOOKUP(F7,'（削除禁止）償却率'!A:J,6,FALSE)))","v":""}]
["西暦",null,"か月",null,"償却額\n（端数処理後）","期末帳簿価格"]
[{"$f":"IF(C3=12,YEAR(C6),IF(C3<MONTH(C6),YEAR(C6),YEAR(C6)-1))","v":2005},1,{"$f":"IF($C$3=\"\",0,IF($C$3=12,12-MONTH(C6)+1,IF($C$3<MONTH(C6),12+$C$3-MONTH(C6)+1,$C$3-MONTH(C6)+1)))","v":1},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",C8*F8*C12/12,IF(C8*F8>F9,C8*F8*C12/12,C8*F10*C12/12)))","v":300618.41666666669},300618,{"$f":"C8-E12","v":14129066},null,{"$f":"IF(F9=\"\",IF(SUM(E12:E12)+(C8*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(C8*F8>F9,1,0)","v":0}]
[{"$f":"A12+1","v":2006},2,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C12)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C12)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F12*F8<=F12-C8*0.05,F12*F8*C13/12,IF(OFFSET(H13,-1,0)=1,(F12-C8*0.05)*C13/12,IF(F12-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F12-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C13/12))),IF(F12*F8>F9,F12*F8*C13/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C13/12,IF(OFFSET(I13,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":3532266.5},3532266,{"$f":"F12-E13","v":10596800},null,{"$f":"IF(F9=\"\",IF(SUM(E12:E12)+(F12*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(F12*F8>F9,1,0)","v":0}]
[2007,3,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C13)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C13)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F13*F8<=F13-C8*0.05,F13*F8*C14/12,IF(OFFSET(H14,-1,0)=1,(F13-C8*0.05)*C14/12,IF(F13-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F13-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C14/12))),IF(F13*F8>F9,F13*F8*C14/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C14/12,IF(OFFSET(I14,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":2649200},2649200,{"$f":"F13-E14","v":7947600},null,{"$f":"IF(F9=\"\",IF(SUM(E12:E13)+(F13*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(F13*F8>F9,1,0)","v":0}]
[2008,4,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C14)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C14)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F14*F8<=F14-C8*0.05,F14*F8*C15/12,IF(OFFSET(H15,-1,0)=1,(F14-C8*0.05)*C15/12,IF(F14-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F14-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C15/12))),IF(F14*F8>F9,F14*F8*C15/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C15/12,IF(OFFSET(I15,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":1986900},1986900,5960700,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E14)+(F14*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(F14*F8>F9,1,0)","v":0}]
[2009,5,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C15)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C15)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F15*F8<=F15-C8*0.05,F15*F8*C16/12,IF(OFFSET(H16,-1,0)=1,(F15-C8*0.05)*C16/12,IF(F15-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F15-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C16/12))),IF(F15*F8>F9,F15*F8*C16/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C16/12,IF(OFFSET(I16,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":1490175},1490175,4470525,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E15)+(F15*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(F15*F8>F9,1,0)","v":0}]
[2010,6,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C16)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C16)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F16*F8<=F16-C8*0.05,F16*F8*C17/12,IF(OFFSET(H17,-1,0)=1,(F16-C8*0.05)*C17/12,IF(F16-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F16-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C17/12))),IF(F16*F8>F9,F16*F8*C17/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C17/12,IF(OFFSET(I17,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":1117631.25},1117631,3352894,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E16)+(F16*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(F16*F8>F9,1,0)","v":0}]
[2011,7,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C17)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C17)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F17*F8<=F17-C8*0.05,F17*F8*C18/12,IF(OFFSET(H18,-1,0)=1,(F17-C8*0.05)*C18/12,IF(F17-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F17-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C18/12))),IF(F17*F8>F9,F17*F8*C18/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C18/12,IF(OFFSET(I18,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":838223.5},838223,2514671,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E17)+(F17*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(F17*F8>F9,1,0)","v":0}]
[2012,8,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C18)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C18)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F18*F8<=F18-C8*0.05,F18*F8*C19/12,IF(OFFSET(H19,-1,0)=1,(F18-C8*0.05)*C19/12,IF(F18-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F18-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C19/12))),IF(F18*F8>F9,F18*F8*C19/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C19/12,IF(OFFSET(I19,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":628667.75},628667,1886004,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E18)+(F18*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(F18*F8>F9,1,0)","v":0}]
[2013,9,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C19)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C19)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F19*F8<=F19-C8*0.05,F19*F8*C20/12,IF(OFFSET(H20,-1,0)=1,(F19-C8*0.05)*C20/12,IF(F19-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F19-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C20/12))),IF(F19*F8>F9,F19*F8*C20/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C20/12,IF(OFFSET(I20,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":471501},471501,1414503,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E19)+(F19*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(F19*F8>F9,1,0)","v":0}]
[{"$f":"A20+1","v":2014},10,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C20)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C20)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F20*F8<=F20-C8*0.05,F20*F8*C21/12,IF(OFFSET(H21,-1,0)=1,(F20-C8*0.05)*C21/12,IF(F20-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F20-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C21/12))),IF(F20*F8>F9,F20*F8*C21/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C21/12,IF(OFFSET(I21,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":353625.75},353625,1060878,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E20)+(F20*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(F20*F8>F9,1,0)","v":0}]
[{"$f":"A21+1","v":2015},11,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C21)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C21)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F21*F8<=F21-C8*0.05,F21*F8*C22/12,IF(OFFSET(H22,-1,0)=1,(F21-C8*0.05)*C22/12,IF(F21-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F21-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C22/12))),IF(F21*F8>F9,F21*F8*C22/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C22/12,IF(OFFSET(I22,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":265219.5},265219,795659,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E21)+(F21*F8)<=C8*0.95,1,0),1)","v":1},{"$f":"IF(F21*F8>F9,1,0)","v":0}]
[2016,12,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C22)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C22)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F22*F8<=F22-C8*0.05,F22*F8*C23/12,IF(OFFSET(H23,-1,0)=1,(F22-C8*0.05)*C23/12,IF(F22-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F22-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C23/12))),IF(F22*F8>F9,F22*F8*C23/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C23/12,IF(OFFSET(I23,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":74174.79999999993},74174,721485,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E22)+(F22*F8)<=C8*0.95,1,0),1)","v":0},{"$f":"IF(F22*F8>F9,1,0)","v":0}]
[2017,13,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C23)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C23)))","v":5},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F23*F8<=F23-C8*0.05,F23*F8*C24/12,IF(OFFSET(H24,-1,0)=1,(F23-C8*0.05)*C24/12,IF(F23-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F23-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C24/12))),IF(F23*F8>F9,F23*F8*C24/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C24/12,IF(OFFSET(I24,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":60123.75},60123,661362,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E23)+(F23*F8)<=C8*0.95,1,0),1)","v":0},{"$f":"IF(F23*F8>F9,1,0)","v":0}]
[2018,14,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C24)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C24)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F24*F8<=F24-C8*0.05,F24*F8*C25/12,IF(OFFSET(H25,-1,0)=1,(F24-C8*0.05)*C25/12,IF(F24-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F24-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C25/12))),IF(F24*F8>F9,F24*F8*C25/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C25/12,IF(OFFSET(I25,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":0},0,661362,null,{"$f":"IF(F9=\"\",IF(SUM(E12:E24)+(F24*F8)<=C8*0.95,1,0),1)","v":0},{"$f":"IF(F24*F8>F9,1,0)","v":0}]
[2019,15,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C25)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C25)))","v":0},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定率法\",IF(F25*F8<=F25-C8*0.05,F25*F8*C26/12,IF(OFFSET(H26,-1,0)=1,(F25-C8*0.05)*C26/12,IF(F25-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F25-1,OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5*C26/12))),IF(F25*F8>F9,F25*F8*C26/12,IF(OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10>0,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)*F10*C26/12,IF(OFFSET(I26,-1,0)=1,OFFSET(F12,MATCH(0,I12:I26,0)-2,0)-1,0)))))","v":0},0,661362,"①",{"$f":"IF(F9=\"\",IF(SUM(E12:E25)+(F25*F8)<=C8*0.95,1,0),1)","v":0},{"$f":"IF(F25*F8>F9,1,0)","v":0}]
[]
["財産名②：","BBBBBBBBBB"]
[null,"登録日：","2019-12-03",null,"償却方法：",{"$f":"IF(C29<=DATE(2007,3,31),\"旧定率法\",\"定率法\")","v":"定率法"}]
[null,"処分時期：","2021-11-01",null,"耐用年数：",4]
[null,"財産取得価格(税抜)：",10000000,null,"償却率：",0.5]
[null,"保証率：",0.12499,null,"償却保証額：",{"$f":"C31*C32","v":1249900}]
[null,null,null,null,"改定償却率：",1]
["西暦",null,"か月",null,"償却額\n（端数処理後）","期末帳簿価格"]
[{"$f":"IF(C3=12,YEAR(C29),IF(C3<MONTH(C29),YEAR(C29),YEAR(C29)-1))","v":2019},1,{"$f":"IF($C$3=\"\",0,IF($C$3=12,12-MONTH(C29)+1,IF($C$3<MONTH(C29),$C$3-MONTH(C29)+12+1,$C$3-MONTH(C29)+1)))","v":4},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",C31*F31*C35/12,IF(C31*F31>F32,C31*F31*C35/12,C31*F33*C35/12)))","v":1666666.6666666667},1666666,{"$f":"C31-E35","v":8333334},null,{"$f":"IF(F32=\"\",IF(SUM(E35:E35)+(C31*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(C31*F31>F32,1,0)","v":1}]
[{"$f":"A35+1","v":2020},2,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C35)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C35)))","v":12},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F35*F31<=F35-C31*0.05,F35*F31*C36/12,IF(OFFSET(H36,-1,0)=1,(F35-C31*0.05)*C36/12,IF(F35-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F35-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C36/12))),IF(F35*F31>F32,F35*F31*C36/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C36/12,IF(OFFSET(I36,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":4166667},4166667,{"$f":"F35-E36","v":4166667},null,{"$f":"IF(F32=\"\",IF(SUM(E35:E35)+(F35*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F35*F31>F32,1,0)","v":1}]
[2021,3,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C36)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C36)))","v":8},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F36*F31<=F36-C31*0.05,F36*F31*C37/12,IF(OFFSET(H37,-1,0)=1,(F36-C31*0.05)*C37/12,IF(F36-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F36-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C37/12))),IF(F36*F31>F32,F36*F31*C37/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C37/12,IF(OFFSET(I37,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":1388889},1388889,{"$f":"F36-E37","v":2777778},null,{"$f":"IF(F32=\"\",IF(SUM(E35:E36)+(F36*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F36*F31>F32,1,0)","v":1}]
[2022,4,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C37)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C37)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F37*F31<=F37-C31*0.05,F37*F31*C38/12,IF(OFFSET(H38,-1,0)=1,(F37-C31*0.05)*C38/12,IF(F37-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F37-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C38/12))),IF(F37*F31>F32,F37*F31*C38/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C38/12,IF(OFFSET(I38,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E37)+(F37*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F37*F31>F32,1,0)","v":1}]
[2023,5,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C38)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C38)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F38*F31<=F38-C31*0.05,F38*F31*C39/12,IF(OFFSET(H39,-1,0)=1,(F38-C31*0.05)*C39/12,IF(F38-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F38-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C39/12))),IF(F38*F31>F32,F38*F31*C39/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C39/12,IF(OFFSET(I39,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E38)+(F38*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F38*F31>F32,1,0)","v":1}]
[2024,6,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C39)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C39)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F39*F31<=F39-C31*0.05,F39*F31*C40/12,IF(OFFSET(H40,-1,0)=1,(F39-C31*0.05)*C40/12,IF(F39-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F39-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C40/12))),IF(F39*F31>F32,F39*F31*C40/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C40/12,IF(OFFSET(I40,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E39)+(F39*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F39*F31>F32,1,0)","v":1}]
[2025,7,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C40)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C40)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F40*F31<=F40-C31*0.05,F40*F31*C41/12,IF(OFFSET(H41,-1,0)=1,(F40-C31*0.05)*C41/12,IF(F40-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F40-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C41/12))),IF(F40*F31>F32,F40*F31*C41/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C41/12,IF(OFFSET(I41,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E40)+(F40*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F40*F31>F32,1,0)","v":1}]
[2026,8,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C41)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C41)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F41*F31<=F41-C31*0.05,F41*F31*C42/12,IF(OFFSET(H42,-1,0)=1,(F41-C31*0.05)*C42/12,IF(F41-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F41-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C42/12))),IF(F41*F31>F32,F41*F31*C42/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C42/12,IF(OFFSET(I42,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E41)+(F41*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F41*F31>F32,1,0)","v":1}]
[2027,9,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C42)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C42)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F42*F31<=F42-C31*0.05,F42*F31*C43/12,IF(OFFSET(H43,-1,0)=1,(F42-C31*0.05)*C43/12,IF(F42-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F42-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C43/12))),IF(F42*F31>F32,F42*F31*C43/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C43/12,IF(OFFSET(I43,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E42)+(F42*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F42*F31>F32,1,0)","v":1}]
[2028,10,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C43)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C43)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F43*F31<=F43-C31*0.05,F43*F31*C44/12,IF(OFFSET(H44,-1,0)=1,(F43-C31*0.05)*C44/12,IF(F43-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F43-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C44/12))),IF(F43*F31>F32,F43*F31*C44/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C44/12,IF(OFFSET(I44,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E43)+(F43*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F43*F31>F32,1,0)","v":1}]
[2029,11,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C44)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C44)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F44*F31<=F44-C31*0.05,F44*F31*C45/12,IF(OFFSET(H45,-1,0)=1,(F44-C31*0.05)*C45/12,IF(F44-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F44-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C45/12))),IF(F44*F31>F32,F44*F31*C45/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C45/12,IF(OFFSET(I45,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E44)+(F44*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F44*F31>F32,1,0)","v":1}]
[2030,12,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C45)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C45)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F45*F31<=F45-C31*0.05,F45*F31*C46/12,IF(OFFSET(H46,-1,0)=1,(F45-C31*0.05)*C46/12,IF(F45-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F45-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C46/12))),IF(F45*F31>F32,F45*F31*C46/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C46/12,IF(OFFSET(I46,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E45)+(F45*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F45*F31>F32,1,0)","v":1}]
[2031,13,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C46)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C46)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F46*F31<=F46-C31*0.05,F46*F31*C47/12,IF(OFFSET(H47,-1,0)=1,(F46-C31*0.05)*C47/12,IF(F46-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F46-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C47/12))),IF(F46*F31>F32,F46*F31*C47/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C47/12,IF(OFFSET(I47,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E46)+(F46*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F46*F31>F32,1,0)","v":1}]
[2032,14,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C47)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C47)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F47*F31<=F47-C31*0.05,F47*F31*C48/12,IF(OFFSET(H48,-1,0)=1,(F47-C31*0.05)*C48/12,IF(F47-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F47-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C48/12))),IF(F47*F31>F32,F47*F31*C48/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C48/12,IF(OFFSET(I48,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,null,{"$f":"IF(F32=\"\",IF(SUM(E35:E47)+(F47*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F47*F31>F32,1,0)","v":1}]
[2033,15,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C48)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C48)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定率法\",IF(F48*F31<=F48-C31*0.05,F48*F31*C49/12,IF(OFFSET(H49,-1,0)=1,(F48-C31*0.05)*C49/12,IF(F48-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F48-1,OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5*C49/12))),IF(F48*F31>F32,F48*F31*C49/12,IF(OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33>0,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)*F33*C49/12,IF(OFFSET(I49,-1,0)=1,OFFSET(F35,MATCH(0,I35:I49,0)-2,0)-1,0)))))","v":0},0,2777778,"②",{"$f":"IF(F32=\"\",IF(SUM(E35:E48)+(F48*F31)<=C31*0.95,1,0),1)","v":1},{"$f":"IF(F48*F31>F32,1,0)","v":1}]
[]
["２．補助割合"]
["＜各年度の年度末中間検査、確定検査の経費発生調書に記載されている数字の転記＞"]
[]
["補助期間\n（年度）","補助対象費用欄【e】の補助金額","補助対象費用欄【e】のⅣ-2学術機関等共同研究費","当年度発生額合計欄【b】の総計B","当年度発生学合計欄【b】のⅣ-2学術機関等共同研究費"]
[2017,1000000,200000,2000000,200000]
[2018,1000000,200000,2000000,200000]
[2019,1000000,200000,2000000,200000]
["合計額",{"$f":"SUM(B55:B57)","v":3000000},{"$f":"SUM(C55:C57)","v":600000},{"$f":"SUM(D55:D57)","v":6000000},{"$f":"SUM(E55:E57)","v":600000}]
[]
[]
["３．補助相当額"]
[null,"残存簿価相当額（合計）",{"$f":"F26+F49","v":3439140}]
[null,"補助割合",{"$f":"(B58-C58)/(D58-E58)","v":0.44444444444444442}]
[]
[null,"補助金相当額",{"$f":"ROUNDDOWN(C62*C63,0)","v":1528506}]

{"sheet":"(記載例)定額法","index":3,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[[4,1,4,5],[27,1,27,5]]}
[]
["【残存簿価相当額・補助金相当額計算書】"]
[null,"決 算 月：",3,null,"償却額の端数処理：","切り捨て"]
["１．残存簿価相当額計算"]
["財産名①：","AAAAAAAAAA"]
[null,"登録日：","2006-03-31",null,"償却方法：",{"$f":"IF(C6<=DATE(2007,3,31),\"旧定額法\",\"定額法\")","v":"旧定額法"}]
[null,"処分時期：","2020-10-01",null,"耐用年数：",8]
[null,"財産取得価格(税抜)：",10000000,null,"償却率：",{"$f":"IF(C6<=DATE(2007,3,31),VLOOKUP(F7,'（削除禁止）償却率'!A:J,2,FALSE),VLOOKUP(F7,'（削除禁止）償却率'!A:J,3,FALSE))","v":0.125}]
[]
[]
["西暦",null,"か月",null,"償却額\n（端数処理後）","期末帳簿価格"]
[{"$f":"IF(C3=12,YEAR(C6),IF(C3<MONTH(C6),YEAR(C6),YEAR(C6)-1))","v":2005},1,{"$f":"IF($C$3=\"\",0,IF($C$3=12,12-MONTH(C6)+1,IF($C$3<MONTH(C6),12+$C$3-MONTH(C6)+1,$C$3-MONTH(C6)+1)))","v":1},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",C8*F8*0.9*C12/12,C8*F8*C12/12))","v":93750},93750,{"$f":"C8-E12","v":9906250},null,{"$f":"IF(C8*F8*0.9>C8-C8*0.05,0,1)","v":1}]
[{"$f":"A12+1","v":2006},2,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C12)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C12)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F12-C8*0.05,C8*F8*0.9*C13/12,IF(OFFSET(H13,-1,0)=1,(F12-C8*0.05)*C13/12,IF(F12-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F12-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C13/12))),IF(IF(F12-C8*F8*C13/12>0,C8*F8*C13/12,F12-1)>0,IF(F12-C8*F8*C13/12>0,C8*F8*C13/12,F12-1),0)))","v":1125000},1125000,{"$f":"F12-E13","v":8781250},null,{"$f":"IF(C8*F8*0.9>F12-C8*0.05,0,1)","v":1}]
[2007,3,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C13)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C13)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F13-C8*0.05,C8*F8*0.9*C14/12,IF(OFFSET(H14,-1,0)=1,(F13-C8*0.05)*C14/12,IF(F13-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F13-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C14/12))),IF(IF(F13-C8*F8*C14/12>0,C8*F8*C14/12,F13-1)>0,IF(F13-C8*F8*C14/12>0,C8*F8*C14/12,F13-1),0)))","v":1125000},1125000,{"$f":"F13-E14","v":7656250},null,{"$f":"IF(C8*F8*0.9>F13-C8*0.05,0,1)","v":1}]
[2008,4,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C14)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C14)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F14-C8*0.05,C8*F8*0.9*C15/12,IF(OFFSET(H15,-1,0)=1,(F14-C8*0.05)*C15/12,IF(F14-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F14-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C15/12))),IF(IF(F14-C8*F8*C15/12>0,C8*F8*C15/12,F14-1)>0,IF(F14-C8*F8*C15/12>0,C8*F8*C15/12,F14-1),0)))","v":1125000},1125000,6531250,null,{"$f":"IF(C8*F8*0.9>F14-C8*0.05,0,1)","v":1}]
[2009,5,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C15)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C15)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F15-C8*0.05,C8*F8*0.9*C16/12,IF(OFFSET(H16,-1,0)=1,(F15-C8*0.05)*C16/12,IF(F15-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F15-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C16/12))),IF(IF(F15-C8*F8*C16/12>0,C8*F8*C16/12,F15-1)>0,IF(F15-C8*F8*C16/12>0,C8*F8*C16/12,F15-1),0)))","v":1125000},1125000,5406250,null,{"$f":"IF(C8*F8*0.9>F15-C8*0.05,0,1)","v":1}]
[2010,6,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C16)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C16)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F16-C8*0.05,C8*F8*0.9*C17/12,IF(OFFSET(H17,-1,0)=1,(F16-C8*0.05)*C17/12,IF(F16-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F16-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C17/12))),IF(IF(F16-C8*F8*C17/12>0,C8*F8*C17/12,F16-1)>0,IF(F16-C8*F8*C17/12>0,C8*F8*C17/12,F16-1),0)))","v":1125000},1125000,4281250,null,{"$f":"IF(C8*F8*0.9>F16-C8*0.05,0,1)","v":1}]
[2011,7,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C17)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C17)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F17-C8*0.05,C8*F8*0.9*C18/12,IF(OFFSET(H18,-1,0)=1,(F17-C8*0.05)*C18/12,IF(F17-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F17-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C18/12))),IF(IF(F17-C8*F8*C18/12>0,C8*F8*C18/12,F17-1)>0,IF(F17-C8*F8*C18/12>0,C8*F8*C18/12,F17-1),0)))","v":1125000},1125000,3156250,null,{"$f":"IF(C8*F8*0.9>F17-C8*0.05,0,1)","v":1}]
[2012,8,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C18)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C18)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F18-C8*0.05,C8*F8*0.9*C19/12,IF(OFFSET(H19,-1,0)=1,(F18-C8*0.05)*C19/12,IF(F18-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F18-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C19/12))),IF(IF(F18-C8*F8*C19/12>0,C8*F8*C19/12,F18-1)>0,IF(F18-C8*F8*C19/12>0,C8*F8*C19/12,F18-1),0)))","v":1125000},1125000,2031250,null,{"$f":"IF(C8*F8*0.9>F18-C8*0.05,0,1)","v":1}]
[2013,9,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C19)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C19)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F19-C8*0.05,C8*F8*0.9*C20/12,IF(OFFSET(H20,-1,0)=1,(F19-C8*0.05)*C20/12,IF(F19-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F19-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C20/12))),IF(IF(F19-C8*F8*C20/12>0,C8*F8*C20/12,F19-1)>0,IF(F19-C8*F8*C20/12>0,C8*F8*C20/12,F19-1),0)))","v":1125000},1125000,906250,null,{"$f":"IF(C8*F8*0.9>F19-C8*0.05,0,1)","v":1}]
[2014,10,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C20)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C20)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F20-C8*0.05,C8*F8*0.9*C21/12,IF(OFFSET(H21,-1,0)=1,(F20-C8*0.05)*C21/12,IF(F20-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F20-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C21/12))),IF(IF(F20-C8*F8*C21/12>0,C8*F8*C21/12,F20-1)>0,IF(F20-C8*F8*C21/12>0,C8*F8*C21/12,F20-1),0)))","v":406250},406250,500000,null,{"$f":"IF(C8*F8*0.9>F20-C8*0.05,0,1)","v":0}]
[2015,11,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C21)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C21)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F21-C8*0.05,C8*F8*0.9*C22/12,IF(OFFSET(H22,-1,0)=1,(F21-C8*0.05)*C22/12,IF(F21-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F21-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C22/12))),IF(IF(F21-C8*F8*C22/12>0,C8*F8*C22/12,F21-1)>0,IF(F21-C8*F8*C22/12>0,C8*F8*C22/12,F21-1),0)))","v":100000},100000,400000,null,{"$f":"IF(C8*F8*0.9>F21-C8*0.05,0,1)","v":0}]
[2016,12,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C22)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C22)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F22-C8*0.05,C8*F8*0.9*C23/12,IF(OFFSET(H23,-1,0)=1,(F22-C8*0.05)*C23/12,IF(F22-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F22-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C23/12))),IF(IF(F22-C8*F8*C23/12>0,C8*F8*C23/12,F22-1)>0,IF(F22-C8*F8*C23/12>0,C8*F8*C23/12,F22-1),0)))","v":100000},100000,300000,null,{"$f":"IF(C8*F8*0.9>F22-C8*0.05,0,1)","v":0}]
[2017,13,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C23)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C23)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F23-C8*0.05,C8*F8*0.9*C24/12,IF(OFFSET(H24,-1,0)=1,(F23-C8*0.05)*C24/12,IF(F23-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F23-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C24/12))),IF(IF(F23-C8*F8*C24/12>0,C8*F8*C24/12,F23-1)>0,IF(F23-C8*F8*C24/12>0,C8*F8*C24/12,F23-1),0)))","v":100000},100000,200000,null,{"$f":"IF(C8*F8*0.9>F23-C8*0.05,0,1)","v":0}]
[2018,14,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C24)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C24)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F24-C8*0.05,C8*F8*0.9*C25/12,IF(OFFSET(H25,-1,0)=1,(F24-C8*0.05)*C25/12,IF(F24-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F24-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C25/12))),IF(IF(F24-C8*F8*C25/12>0,C8*F8*C25/12,F24-1)>0,IF(F24-C8*F8*C25/12>0,C8*F8*C25/12,F24-1),0)))","v":100000},100000,100000,null,{"$f":"IF(C8*F8*0.9>F24-C8*0.05,0,1)","v":0}]
[2019,15,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C25)>=12,12,DATEDIF(DATE(YEAR(C6),MONTH(C6),1),DATE(YEAR(C7),MONTH(C7)+1,1),\"m\")-SUM(C12:C25)))","v":12},{"$f":"IF(F8=\"\",\"\",IF(F6=\"旧定額法\",IF(C8*F8*0.9<=F25-C8*0.05,C8*F8*0.9*C26/12,IF(OFFSET(H26,-1,0)=1,(F25-C8*0.05)*C26/12,IF(F25-OFFSET(F12,MATCH(0,H12:H26,0)-1,0)/5<=0,F25-1,(OFFSET(F12,MATCH(0,H12:H26,0)-1,0))/5*C26/12))),IF(IF(F25-C8*F8*C26/12>0,C8*F8*C26/12,F25-1)>0,IF(F25-C8*F8*C26/12>0,C8*F8*C26/12,F25-1),0)))","v":99999},99999,1,"①",{"$f":"IF(C8*F8*0.9>F25-C8*0.05,0,1)","v":0}]
[]
["財産名②：","BBBBBBBBBB"]
[null,"登録日：","2019-12-03",null,"償却方法：",{"$f":"IF(C29<=DATE(2007,3,31),\"旧定額法\",\"定額法\")","v":"定額法"}]
[null,"処分時期：","2021-11-01",null,"耐用年数：",4]
[null,"財産取得価格(税抜)：",10000000,null,"償却率：",{"$f":"IF(C29<=DATE(2007,3,31),VLOOKUP(F30,'（削除禁止）償却率'!A:J,2,FALSE),VLOOKUP(F30,'（削除禁止）償却率'!A:J,3,FALSE))","v":0.25}]
[]
[]
["西暦",null,"か月",null,"償却額\n（端数処理後）","期末帳簿価格"]
[{"$f":"IF(C3=12,YEAR(C29),IF(C3<MONTH(C29),YEAR(C29),YEAR(C29)-1))","v":2019},1,{"$f":"IF($C$3=\"\",0,IF($C$3=12,12-MONTH(C29)+1,IF($C$3<MONTH(C29),$C$3-MONTH(C29)+12+1,$C$3-MONTH(C29)+1)))","v":4},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",C31*F31*0.9*C35/12,C31*F31*C35/12))","v":833333.33333333337},833333,{"$f":"C31-E35","v":9166667},null,{"$f":"IF(C31*F31*0.9>C31-C31*0.05,0,1)","v":1}]
[{"$f":"A35+1","v":2020},2,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C35)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C35)))","v":12},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F35-C31*0.05,C31*F31*0.9*C36/12,IF(OFFSET(H36,-1,0)=1,(F35-C31*0.05)*C36/12,IF(F35-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F35-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C36/12))),IF(IF(F35-C31*F31*C36/12>0,C31*F31*C36/12,F35-1)>0,IF(F35-C31*F31*C36/12>0,C31*F31*C36/12,F35-1),0)))","v":2500000},2500000,{"$f":"F35-E36","v":6666667},null,{"$f":"IF(C31*F31*0.9>F35-C31*0.05,0,1)","v":1}]
[2021,3,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C36)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C36)))","v":8},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F36-C31*0.05,C31*F31*0.9*C37/12,IF(OFFSET(H37,-1,0)=1,(F36-C31*0.05)*C37/12,IF(F36-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F36-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C37/12))),IF(IF(F36-C31*F31*C37/12>0,C31*F31*C37/12,F36-1)>0,IF(F36-C31*F31*C37/12>0,C31*F31*C37/12,F36-1),0)))","v":1666666.6666666667},1666666,{"$f":"F36-E37","v":5000001},null,{"$f":"IF(C31*F31*0.9>F36-C31*0.05,0,1)","v":1}]
[2022,4,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C37)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C37)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F37-C31*0.05,C31*F31*0.9*C38/12,IF(OFFSET(H38,-1,0)=1,(F37-C31*0.05)*C38/12,IF(F37-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F37-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C38/12))),IF(IF(F37-C31*F31*C38/12>0,C31*F31*C38/12,F37-1)>0,IF(F37-C31*F31*C38/12>0,C31*F31*C38/12,F37-1),0)))","v":0},0,{"$f":"F37-E38","v":5000001},null,{"$f":"IF(C31*F31*0.9>F37-C31*0.05,0,1)","v":1}]
[2023,5,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C38)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C38)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F38-C31*0.05,C31*F31*0.9*C39/12,IF(OFFSET(H39,-1,0)=1,(F38-C31*0.05)*C39/12,IF(F38-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F38-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C39/12))),IF(IF(F38-C31*F31*C39/12>0,C31*F31*C39/12,F38-1)>0,IF(F38-C31*F31*C39/12>0,C31*F31*C39/12,F38-1),0)))","v":0},0,5000001,null,{"$f":"IF(C31*F31*0.9>F38-C31*0.05,0,1)","v":1}]
[2024,6,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C39)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C39)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F39-C31*0.05,C31*F31*0.9*C40/12,IF(OFFSET(H40,-1,0)=1,(F39-C31*0.05)*C40/12,IF(F39-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F39-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C40/12))),IF(IF(F39-C31*F31*C40/12>0,C31*F31*C40/12,F39-1)>0,IF(F39-C31*F31*C40/12>0,C31*F31*C40/12,F39-1),0)))","v":0},0,5000001,null,{"$f":"IF(C31*F31*0.9>F39-C31*0.05,0,1)","v":1}]
[2025,7,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C40)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C40)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F40-C31*0.05,C31*F31*0.9*C41/12,IF(OFFSET(H41,-1,0)=1,(F40-C31*0.05)*C41/12,IF(F40-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F40-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C41/12))),IF(IF(F40-C31*F31*C41/12>0,C31*F31*C41/12,F40-1)>0,IF(F40-C31*F31*C41/12>0,C31*F31*C41/12,F40-1),0)))","v":0},0,5000001,null,{"$f":"IF(C31*F31*0.9>F40-C31*0.05,0,1)","v":1}]
[2026,8,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C41)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C41)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F41-C31*0.05,C31*F31*0.9*C42/12,IF(OFFSET(H42,-1,0)=1,(F41-C31*0.05)*C42/12,IF(F41-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F41-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C42/12))),IF(IF(F41-C31*F31*C42/12>0,C31*F31*C42/12,F41-1)>0,IF(F41-C31*F31*C42/12>0,C31*F31*C42/12,F41-1),0)))","v":0},0,5000001,null,{"$f":"IF(C31*F31*0.9>F41-C31*0.05,0,1)","v":1}]
[2027,9,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C42)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C42)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F42-C31*0.05,C31*F31*0.9*C43/12,IF(OFFSET(H43,-1,0)=1,(F42-C31*0.05)*C43/12,IF(F42-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F42-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C43/12))),IF(IF(F42-C31*F31*C43/12>0,C31*F31*C43/12,F42-1)>0,IF(F42-C31*F31*C43/12>0,C31*F31*C43/12,F42-1),0)))","v":0},0,5000001,null,{"$f":"IF(C31*F31*0.9>F42-C31*0.05,0,1)","v":1}]
[2028,10,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C43)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C43)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F43-C31*0.05,C31*F31*0.9*C44/12,IF(OFFSET(H44,-1,0)=1,(F43-C31*0.05)*C44/12,IF(F43-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F43-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C44/12))),IF(IF(F43-C31*F31*C44/12>0,C31*F31*C44/12,F43-1)>0,IF(F43-C31*F31*C44/12>0,C31*F31*C44/12,F43-1),0)))","v":0},0,5000001,null,{"$f":"IF(C31*F31*0.9>F43-C31*0.05,0,1)","v":1}]
[2029,11,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C44)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C44)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F44-C31*0.05,C31*F31*0.9*C45/12,IF(OFFSET(H45,-1,0)=1,(F44-C31*0.05)*C45/12,IF(F44-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F44-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C45/12))),IF(IF(F44-C31*F31*C45/12>0,C31*F31*C45/12,F44-1)>0,IF(F44-C31*F31*C45/12>0,C31*F31*C45/12,F44-1),0)))","v":0},0,5000001,null,{"$f":"IF(C31*F31*0.9>F44-C31*0.05,0,1)","v":1}]
[2030,12,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C45)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C45)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F45-C31*0.05,C31*F31*0.9*C46/12,IF(OFFSET(H46,-1,0)=1,(F45-C31*0.05)*C46/12,IF(F45-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F45-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C46/12))),IF(IF(F45-C31*F31*C46/12>0,C31*F31*C46/12,F45-1)>0,IF(F45-C31*F31*C46/12>0,C31*F31*C46/12,F45-1),0)))","v":0},0,5000001,null,{"$f":"IF(C31*F31*0.9>F45-C31*0.05,0,1)","v":1}]
[2031,13,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C46)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C46)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F46-C31*0.05,C31*F31*0.9*C47/12,IF(OFFSET(H47,-1,0)=1,(F46-C31*0.05)*C47/12,IF(F46-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F46-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C47/12))),IF(IF(F46-C31*F31*C47/12>0,C31*F31*C47/12,F46-1)>0,IF(F46-C31*F31*C47/12>0,C31*F31*C47/12,F46-1),0)))","v":0},0,{"$f":"F46-E47","v":5000001},null,{"$f":"IF(C31*F31*0.9>F46-C31*0.05,0,1)","v":1}]
[2032,14,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C47)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C47)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F47-C31*0.05,C31*F31*0.9*C48/12,IF(OFFSET(H48,-1,0)=1,(F47-C31*0.05)*C48/12,IF(F47-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F47-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C48/12))),IF(IF(F47-C31*F31*C48/12>0,C31*F31*C48/12,F47-1)>0,IF(F47-C31*F31*C48/12>0,C31*F31*C48/12,F47-1),0)))","v":0},0,5000001,null,{"$f":"IF(C31*F31*0.9>F47-C31*0.05,0,1)","v":1}]
[2033,15,{"$f":"IF($C$3=\"\",0,IF(DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C48)>=12,12,DATEDIF(DATE(YEAR(C29),MONTH(C29),1),DATE(YEAR(C30),MONTH(C30)+1,1),\"m\")-SUM(C35:C48)))","v":0},{"$f":"IF(F31=\"\",\"\",IF(F29=\"旧定額法\",IF(C31*F31*0.9<=F48-C31*0.05,C31*F31*0.9*C49/12,IF(OFFSET(H49,-1,0)=1,(F48-C31*0.05)*C49/12,IF(F48-OFFSET(F35,MATCH(0,H35:H49,0)-1,0)/5<=0,F48-1,(OFFSET(F35,MATCH(0,H35:H49,0)-1,0))/5*C49/12))),IF(IF(F48-C31*F31*C49/12>0,C31*F31*C49/12,F48-1)>0,IF(F48-C31*F31*C49/12>0,C31*F31*C49/12,F48-1),0)))","v":0},0,5000001,"②",{"$f":"IF(C31*F31*0.9>F48-C31*0.05,0,1)","v":1}]
[]
["２．補助割合"]
["＜各年度の年度末中間検査、確定検査の経費発生調書に記載されている数字の転記＞"]
[]
["補助期間\n（年度）","補助対象費用欄【e】の補助金額","補助対象費用欄【e】のⅣ-2学術機関等共同研究費","当年度発生額合計欄【b】の総計B","当年度発生学合計欄【b】のⅣ-2学術機関等共同研究費"]
[2017,1000000,200000,2000000,200000]
[2018,1000000,200000,2000000,200000]
[2019,1000000,200000,2000000,200000]
["合計額",{"$f":"SUM(B55:B57)","v":3000000},{"$f":"SUM(C55:C57)","v":600000},{"$f":"SUM(D55:D57)","v":6000000},{"$f":"SUM(E55:E57)","v":600000}]
[]
[]
["３．補助相当額"]
[null,"残存簿価相当額（合計）",{"$f":"F26+F49","v":5000002}]
[null,"補助割合",{"$f":"(B58-C58)/(D58-E58)","v":0.44444444444444442}]
[]
[null,"補助金相当額",{"$f":"ROUNDDOWN(C62*C63,0)","v":2222223}]

{"sheet":"（削除禁止）償却率","index":4,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":true,"merged":[[0,4,0,6],[0,7,0,9],[0,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,6],[1,7,1,9]]}
["耐用年数","平成19年3月31日以前取得","平成19年4月1日以降取得","平成19年3月31日以前取得","平成19年4月1日から平成24年3月31日までに取得",null,null,"平成24年4月1日以降に取得"]
[null,"旧定額法\n償却率","定額法\n償却率","旧定率法\n償却率","250％定率法",null,null,"200％定率法"]
[null,null,null,null,"償却率","改定償却率","保証率","償却率","改定償却率","保証率"]
[2,0.5,0.5,0.68400000000000005,1,1,0,1,1,0]
[3,0.33300000000000002,0.33400000000000002,0.53600000000000003,0.83299999999999996,1,2.7890000000000002E-2,0.66700000000000004,1,0.11089]
[4,0.25,0.25,0.438,0.625,1,5.2740000000000002E-2,0.5,1,0.12499]
[5,0.2,0.2,0.36899999999999999,0.5,1,6.2489999999999997E-2,0.4,0.5,0.108]
[6,0.16600000000000001,0.16700000000000001,0.31900000000000001,0.41699999999999998,0.5,5.7759999999999999E-2,0.33300000000000002,0.33400000000000002,9.9110000000000004E-2]
[7,0.14199999999999999,0.14299999999999999,0.28000000000000003,0.35699999999999998,0.5,5.4960000000000002E-2,0.28599999999999998,0.33400000000000002,8.6800000000000002E-2]
[8,0.125,0.125,0.25,0.313,0.33400000000000002,5.1110000000000003E-2,0.25,0.33400000000000002,7.9089999999999994E-2]
[9,0.111,0.112,0.22600000000000001,0.27800000000000002,0.33400000000000002,4.7309999999999998E-2,0.222,0.25,7.1260000000000004E-2]
[10,0.1,0.1,0.20599999999999999,0.25,0.33400000000000002,4.4479999999999999E-2,0.2,0.25,6.5519999999999995E-2]
[11,0.09,9.0999999999999998E-2,0.189,0.22700000000000001,0.25,4.1230000000000003E-2,0.182,0.2,5.9920000000000001E-2]
[12,8.3000000000000004E-2,8.4000000000000005E-2,0.17499999999999999,0.20799999999999999,0.25,3.8699999999999998E-2,0.16700000000000001,0.2,5.5660000000000001E-2]
[13,7.5999999999999998E-2,7.6999999999999999E-2,0.16200000000000001,0.192,0.2,3.6330000000000001E-2,0.154,0.16700000000000001,5.1799999999999999E-2]
[14,7.0999999999999994E-2,7.1999999999999995E-2,0.152,0.17899999999999999,0.2,3.3890000000000003E-2,0.14299999999999999,0.16700000000000001,4.854E-2]
[15,6.6000000000000003E-2,6.7000000000000004E-2,0.14199999999999999,0.16700000000000001,0.2,3.2169999999999997E-2,0.13300000000000001,0.14299999999999999,4.5650000000000003E-2]
[16,6.2E-2,6.3E-2,0.13400000000000001,0.156,0.16700000000000001,3.0630000000000001E-2,0.125,0.14299999999999999,4.2939999999999999E-2]
[17,5.8000000000000003E-2,5.8999999999999997E-2,0.127,0.14699999999999999,0.16700000000000001,2.9049999999999999E-2,0.11799999999999999,0.125,4.0379999999999999E-2]
[18,5.5E-2,5.6000000000000001E-2,0.12,0.13900000000000001,0.14299999999999999,2.7570000000000001E-2,0.111,0.112,3.884E-2]
[19,5.1999999999999998E-2,5.2999999999999999E-2,0.114,0.13200000000000001,0.14299999999999999,2.6159999999999999E-2,0.105,0.112,3.6929999999999998E-2]
[20,0.05,0.05,0.109,0.125,0.14299999999999999,2.5170000000000001E-2,0.1,0.112,3.4860000000000002E-2]
[21,4.8000000000000001E-2,4.8000000000000001E-2,0.104,0.11899999999999999,0.125,2.4080000000000001E-2,9.5000000000000001E-2,0.1,3.3349999999999998E-2]
[22,4.5999999999999999E-2,4.5999999999999999E-2,9.9000000000000005E-2,0.114,0.125,2.2960000000000001E-2,9.0999999999999998E-2,0.1,3.1820000000000001E-2]
[23,4.3999999999999997E-2,4.3999999999999997E-2,9.5000000000000001E-2,0.109,0.112,2.2259999999999999E-2,8.6999999999999994E-2,9.0999999999999998E-2,3.0519999999999999E-2]
[24,4.2000000000000003E-2,4.2000000000000003E-2,9.1999999999999998E-2,0.104,0.112,2.1569999999999999E-2,8.3000000000000004E-2,8.4000000000000005E-2,2.9690000000000001E-2]
[25,0.04,0.04,8.7999999999999995E-2,0.1,0.112,2.0580000000000001E-2,0.08,8.4000000000000005E-2,2.8410000000000001E-2]
[26,3.9E-2,3.9E-2,8.5000000000000006E-2,9.6000000000000002E-2,0.1,1.9890000000000001E-2,7.6999999999999999E-2,8.4000000000000005E-2,2.716E-2]
[27,3.6999999999999998E-2,3.7999999999999999E-2,8.2000000000000003E-2,9.2999999999999999E-2,0.1,1.9019999999999999E-2,7.3999999999999996E-2,7.6999999999999999E-2,2.6239999999999999E-2]
[28,3.5999999999999997E-2,3.5999999999999997E-2,7.9000000000000001E-2,8.8999999999999996E-2,9.0999999999999998E-2,1.866E-2,7.0999999999999994E-2,7.1999999999999995E-2,2.5680000000000001E-2]
[29,3.5000000000000003E-2,3.5000000000000003E-2,7.5999999999999998E-2,8.5999999999999993E-2,9.0999999999999998E-2,1.8030000000000001E-2,6.9000000000000006E-2,7.1999999999999995E-2,2.4629999999999999E-2]
[30,3.4000000000000002E-2,3.4000000000000002E-2,7.3999999999999996E-2,8.3000000000000004E-2,8.4000000000000005E-2,1.7659999999999999E-2,6.7000000000000004E-2,7.1999999999999995E-2,2.366E-2]
[31,3.3000000000000002E-2,3.3000000000000002E-2,7.1999999999999995E-2,8.1000000000000003E-2,8.4000000000000005E-2,1.6879999999999999E-2,6.5000000000000002E-2,6.7000000000000004E-2,2.2859999999999998E-2]
[32,3.2000000000000001E-2,3.2000000000000001E-2,6.9000000000000006E-2,7.8E-2,8.4000000000000005E-2,1.6549999999999999E-2,6.3E-2,6.7000000000000004E-2,2.2159999999999999E-2]
[33,3.1E-2,3.1E-2,6.7000000000000004E-2,7.5999999999999998E-2,7.6999999999999999E-2,1.585E-2,6.0999999999999999E-2,6.3E-2,2.1610000000000001E-2]
[34,0.03,0.03,6.6000000000000003E-2,7.3999999999999996E-2,7.6999999999999999E-2,1.532E-2,5.8999999999999997E-2,6.3E-2,2.0969999999999999E-2]
[35,2.9000000000000001E-2,2.9000000000000001E-2,6.4000000000000001E-2,7.0999999999999994E-2,7.1999999999999995E-2,1.532E-2,5.7000000000000002E-2,5.8999999999999997E-2,2.051E-2]
[36,2.8000000000000001E-2,2.8000000000000001E-2,6.2E-2,6.9000000000000006E-2,7.1999999999999995E-2,1.494E-2,5.6000000000000001E-2,5.8999999999999997E-2,1.9740000000000001E-2]
[37,2.7E-2,2.8000000000000001E-2,0.06,6.8000000000000005E-2,7.1999999999999995E-2,1.4250000000000001E-2,5.3999999999999999E-2,5.6000000000000001E-2,1.95E-2]
[38,2.7E-2,2.7E-2,5.8999999999999997E-2,6.6000000000000003E-2,6.7000000000000004E-2,1.393E-2,5.2999999999999999E-2,5.6000000000000001E-2,1.882E-2]
[39,2.5999999999999999E-2,2.5999999999999999E-2,5.7000000000000002E-2,6.4000000000000001E-2,6.7000000000000004E-2,1.37E-2,5.0999999999999997E-2,5.2999999999999999E-2,1.8599999999999998E-2]
[40,2.5000000000000001E-2,2.5000000000000001E-2,5.6000000000000001E-2,6.3E-2,6.7000000000000004E-2,1.3169999999999999E-2,0.05,5.2999999999999999E-2,1.7909999999999999E-2]
[41,2.5000000000000001E-2,2.5000000000000001E-2,5.5E-2,6.0999999999999999E-2,6.3E-2,1.306E-2,4.9000000000000002E-2,0.05,1.7409999999999998E-2]
[42,2.4E-2,2.4E-2,5.2999999999999999E-2,0.06,6.3E-2,1.261E-2,4.8000000000000001E-2,0.05,1.694E-2]
[43,2.4E-2,2.4E-2,5.1999999999999998E-2,5.8000000000000003E-2,5.8999999999999997E-2,1.248E-2,4.7E-2,4.8000000000000001E-2,1.6639999999999999E-2]
[44,2.3E-2,2.3E-2,5.0999999999999997E-2,5.7000000000000002E-2,5.8999999999999997E-2,1.21E-2,4.4999999999999998E-2,4.5999999999999999E-2,1.6639999999999999E-2]
[45,2.3E-2,2.3E-2,0.05,5.6000000000000001E-2,5.8999999999999997E-2,1.175E-2,4.3999999999999997E-2,4.5999999999999999E-2,1.634E-2]
[46,2.1999999999999999E-2,2.1999999999999999E-2,4.9000000000000002E-2,5.3999999999999999E-2,5.6000000000000001E-2,1.175E-2,4.2999999999999997E-2,4.3999999999999997E-2,1.601E-2]
[47,2.1999999999999999E-2,2.1999999999999999E-2,4.8000000000000001E-2,5.2999999999999999E-2,5.6000000000000001E-2,1.153E-2,4.2999999999999997E-2,4.3999999999999997E-2,1.532E-2]
[48,2.1000000000000001E-2,2.1000000000000001E-2,4.7E-2,5.1999999999999998E-2,5.2999999999999999E-2,1.1259999999999999E-2,4.2000000000000003E-2,4.3999999999999997E-2,1.499E-2]
[49,2.1000000000000001E-2,2.1000000000000001E-2,4.5999999999999999E-2,5.0999999999999997E-2,5.2999999999999999E-2,1.102E-2,4.1000000000000002E-2,4.2000000000000003E-2,1.4749999999999999E-2]
[50,0.02,0.02,4.4999999999999998E-2,0.05,5.2999999999999999E-2,1.072E-2,0.04,4.2000000000000003E-2,1.44E-2]
[51,0.02,0.02,4.3999999999999997E-2,4.9000000000000002E-2,0.05,1.0529999999999999E-2,3.9E-2,0.04,1.422E-2]
[52,0.02,0.02,4.2999999999999997E-2,4.8000000000000001E-2,0.05,1.0359999999999999E-2,3.7999999999999999E-2,3.9E-2,1.422E-2]
[53,1.9E-2,1.9E-2,4.2999999999999997E-2,4.7E-2,4.8000000000000001E-2,1.0279999999999999E-2,3.7999999999999999E-2,3.9E-2,1.37E-2]
[54,1.9E-2,1.9E-2,4.2000000000000003E-2,4.5999999999999999E-2,4.8000000000000001E-2,1.0149999999999999E-2,3.6999999999999998E-2,3.7999999999999999E-2,1.37E-2]
[55,1.9E-2,1.9E-2,4.1000000000000002E-2,4.4999999999999998E-2,4.5999999999999999E-2,1.0070000000000001E-2,3.5999999999999997E-2,3.7999999999999999E-2,1.337E-2]
[56,1.7999999999999999E-2,1.7999999999999999E-2,0.04,4.4999999999999998E-2,4.5999999999999999E-2,9.6100000000000005E-3,3.5999999999999997E-2,3.7999999999999999E-2,1.2880000000000001E-2]
[57,1.7999999999999999E-2,1.7999999999999999E-2,0.04,4.3999999999999997E-2,4.5999999999999999E-2,9.5200000000000007E-3,3.5000000000000003E-2,3.5999999999999997E-2,1.281E-2]
[58,1.7999999999999999E-2,1.7999999999999999E-2,3.9E-2,4.2999999999999997E-2,4.3999999999999997E-2,9.4500000000000001E-3,3.4000000000000002E-2,3.5000000000000003E-2,1.281E-2]
[59,1.7000000000000001E-2,1.7000000000000001E-2,3.7999999999999999E-2,4.2000000000000003E-2,4.3999999999999997E-2,9.3399999999999993E-3,3.4000000000000002E-2,3.5000000000000003E-2,1.24E-2]
[60,1.7000000000000001E-2,1.7000000000000001E-2,3.7999999999999999E-2,4.2000000000000003E-2,4.3999999999999997E-2,8.9499999999999996E-3,3.3000000000000002E-2,3.4000000000000002E-2,1.24E-2]
[61,1.7000000000000001E-2,1.7000000000000001E-2,3.6999999999999998E-2,4.1000000000000002E-2,4.2000000000000003E-2,8.9200000000000008E-3,3.3000000000000002E-2,3.4000000000000002E-2,1.201E-2]
[62,1.7000000000000001E-2,1.7000000000000001E-2,3.5999999999999997E-2,0.04,4.2000000000000003E-2,8.8199999999999997E-3,3.2000000000000001E-2,3.3000000000000002E-2,1.201E-2]
[63,1.6E-2,1.6E-2,3.5999999999999997E-2,0.04,4.2000000000000003E-2,8.4700000000000001E-3,3.2000000000000001E-2,3.3000000000000002E-2,1.1650000000000001E-2]
[64,1.6E-2,1.6E-2,3.5000000000000003E-2,3.9E-2,0.04,8.4700000000000001E-3,3.1E-2,3.2000000000000001E-2,1.1650000000000001E-2]
[65,1.6E-2,1.6E-2,3.5000000000000003E-2,3.7999999999999999E-2,3.9E-2,8.4700000000000001E-3,3.1E-2,3.2000000000000001E-2,1.1299999999999999E-2]
[66,1.6E-2,1.6E-2,3.4000000000000002E-2,3.7999999999999999E-2,3.9E-2,8.2799999999999992E-3,0.03,3.1E-2,1.1299999999999999E-2]
[67,1.4999999999999999E-2,1.4999999999999999E-2,3.4000000000000002E-2,3.6999999999999998E-2,3.7999999999999999E-2,8.2799999999999992E-3,0.03,3.1E-2,1.0970000000000001E-2]
[68,1.4999999999999999E-2,1.4999999999999999E-2,3.3000000000000002E-2,3.6999999999999998E-2,3.7999999999999999E-2,8.0999999999999996E-3,2.9000000000000001E-2,0.03,1.0970000000000001E-2]
[69,1.4999999999999999E-2,1.4999999999999999E-2,3.3000000000000002E-2,3.5999999999999997E-2,3.7999999999999999E-2,8.0000000000000002E-3,2.9000000000000001E-2,0.03,1.065E-2]
[70,1.4999999999999999E-2,1.4999999999999999E-2,3.2000000000000001E-2,3.5999999999999997E-2,3.7999999999999999E-2,7.7099999999999998E-3,2.9000000000000001E-2,0.03,1.034E-2]
[71,1.4E-2,1.4999999999999999E-2,3.2000000000000001E-2,3.5000000000000003E-2,3.5999999999999997E-2,7.7099999999999998E-3,2.8000000000000001E-2,2.9000000000000001E-2,1.034E-2]
[72,1.4E-2,1.4E-2,3.2000000000000001E-2,3.5000000000000003E-2,3.5999999999999997E-2,7.5100000000000002E-3,2.8000000000000001E-2,2.9000000000000001E-2,1.0059999999999999E-2]
[73,1.4E-2,1.4E-2,3.1E-2,3.4000000000000002E-2,3.5000000000000003E-2,7.5100000000000002E-3,2.7E-2,2.7E-2,1.0630000000000001E-2]
[74,1.4E-2,1.4E-2,3.1E-2,3.4000000000000002E-2,3.5000000000000003E-2,7.3800000000000003E-3,2.7E-2,2.7E-2,1.035E-2]
[75,1.4E-2,1.4E-2,0.03,3.3000000000000002E-2,3.4000000000000002E-2,7.3800000000000003E-3,2.7E-2,2.7E-2,1.0070000000000001E-2]
[76,1.4E-2,1.4E-2,0.03,3.3000000000000002E-2,3.4000000000000002E-2,7.26E-3,2.5999999999999999E-2,2.7E-2,9.7999999999999997E-3]
[77,1.2999999999999999E-2,1.2999999999999999E-2,0.03,3.2000000000000001E-2,3.3000000000000002E-2,7.26E-3,2.5999999999999999E-2,2.7E-2,9.5399999999999999E-3]
[78,1.2999999999999999E-2,1.2999999999999999E-2,2.9000000000000001E-2,3.2000000000000001E-2,3.3000000000000002E-2,7.1599999999999997E-3,2.5999999999999999E-2,2.7E-2,9.2899999999999996E-3]
[79,1.2999999999999999E-2,1.2999999999999999E-2,2.9000000000000001E-2,3.2000000000000001E-2,3.3000000000000002E-2,6.9300000000000004E-3,2.5000000000000001E-2,2.5999999999999999E-2,9.2899999999999996E-3]
[80,1.2999999999999999E-2,1.2999999999999999E-2,2.8000000000000001E-2,3.1E-2,3.2000000000000001E-2,6.9300000000000004E-3,2.5000000000000001E-2,2.5999999999999999E-2,9.0699999999999999E-3]
[81,1.2999999999999999E-2,1.2999999999999999E-2,2.8000000000000001E-2,3.1E-2,3.2000000000000001E-2,6.8300000000000001E-3,2.5000000000000001E-2,2.5999999999999999E-2,8.8400000000000006E-3]
[82,1.2999999999999999E-2,1.2999999999999999E-2,2.8000000000000001E-2,0.03,3.1E-2,6.8300000000000001E-3,2.4E-2,2.4E-2,9.2899999999999996E-3]
[83,1.2E-2,1.2999999999999999E-2,2.7E-2,0.03,3.1E-2,6.7299999999999999E-3,2.4E-2,2.4E-2,9.0699999999999999E-3]
[84,1.2E-2,1.2E-2,2.7E-2,0.03,3.1E-2,6.5300000000000002E-3,2.4E-2,2.4E-2,8.8500000000000002E-3]
[85,1.2E-2,1.2E-2,2.5999999999999999E-2,2.9000000000000001E-2,0.03,6.5300000000000002E-3,2.4E-2,2.4E-2,8.6400000000000001E-3]
[86,1.2E-2,1.2E-2,2.5999999999999999E-2,2.9000000000000001E-2,0.03,6.45E-3,2.3E-2,2.3E-2,8.8500000000000002E-3]
[87,1.2E-2,1.2E-2,2.5999999999999999E-2,2.9000000000000001E-2,0.03,6.2700000000000004E-3,2.3E-2,2.3E-2,8.6400000000000001E-3]
[88,1.2E-2,1.2E-2,2.5999999999999999E-2,2.8000000000000001E-2,2.9000000000000001E-2,6.2700000000000004E-3,2.3E-2,2.3E-2,8.4399999999999996E-3]
[89,1.2E-2,1.2E-2,2.5999999999999999E-2,2.8000000000000001E-2,2.9000000000000001E-2,6.1999999999999998E-3,2.1999999999999999E-2,2.1999999999999999E-2,8.6300000000000005E-3]
[90,1.2E-2,1.2E-2,2.5000000000000001E-2,2.8000000000000001E-2,2.9000000000000001E-2,6.0299999999999998E-3,2.1999999999999999E-2,2.1999999999999999E-2,8.4399999999999996E-3]
[91,1.0999999999999999E-2,1.0999999999999999E-2,2.5000000000000001E-2,2.7E-2,2.7E-2,6.4900000000000001E-3,2.1999999999999999E-2,2.1999999999999999E-2,8.2500000000000004E-3]
[92,1.0999999999999999E-2,1.0999999999999999E-2,2.5000000000000001E-2,2.7E-2,2.7E-2,6.3200000000000001E-3,2.1999999999999999E-2,2.1999999999999999E-2,8.0700000000000008E-3]
[93,1.0999999999999999E-2,1.0999999999999999E-2,2.5000000000000001E-2,2.7E-2,2.7E-2,6.1500000000000001E-3,2.1999999999999999E-2,2.1999999999999999E-2,7.9000000000000008E-3]
[94,1.0999999999999999E-2,1.0999999999999999E-2,2.4E-2,2.7E-2,2.7E-2,5.9800000000000001E-3,2.1000000000000001E-2,2.1000000000000001E-2,8.0700000000000008E-3]
[95,1.0999999999999999E-2,1.0999999999999999E-2,2.4E-2,2.5999999999999999E-2,2.7E-2,5.94E-3,2.1000000000000001E-2,2.1000000000000001E-2,7.9000000000000008E-3]
[96,1.0999999999999999E-2,1.0999999999999999E-2,2.4E-2,2.5999999999999999E-2,2.7E-2,5.7800000000000004E-3,2.1000000000000001E-2,2.1000000000000001E-2,7.7299999999999999E-3]
[97,1.0999999999999999E-2,1.0999999999999999E-2,2.3E-2,2.5999999999999999E-2,2.7E-2,5.6299999999999996E-3,2.1000000000000001E-2,2.1000000000000001E-2,7.5700000000000003E-3]
[98,1.0999999999999999E-2,1.0999999999999999E-2,2.3E-2,2.5999999999999999E-2,2.7E-2,5.4900000000000001E-3,0.02,0.02,7.7299999999999999E-3]
[99,1.0999999999999999E-2,1.0999999999999999E-2,2.3E-2,2.5000000000000001E-2,2.5999999999999999E-2,5.4900000000000001E-3,0.02,0.02,7.5700000000000003E-3]
[100,0.01,0.01,2.3E-2,2.5000000000000001E-2,2.5999999999999999E-2,5.4599999999999996E-3,0.02,0.02,7.4200000000000004E-3]