{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["sh1マスター","sh2増加","sh3試算"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"sh1マスター","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["種類","区分",null,"増加事由","番号",null,"耐用年数","減価率 r","減価残存率前年中取得　A","減価残存率前年前取得　B"]
["構築物",1,null,"新品取得",1,null,2,0.68400000000000005,0.65800000000000003,0.316]
["機械及び装置",2,null,"中古品取得",2,null,3,0.53600000000000003,0.73199999999999998,0.46400000000000002]
["船舶",3,null,"移動による受入れ",3,null,4,0.438,0.78100000000000003,0.56200000000000006]
["航空機",4,null,"その他",4,null,5,0.36899999999999999,0.81499999999999995,0.63100000000000001]
["車両及び運搬具",5,null,null,null,null,6,0.31900000000000001,0.84,0.68100000000000005]
["工具、器具及び備品",6,null,null,null,null,7,0.28000000000000003,0.86,0.72]
[null,null,null,null,null,null,8,0.25,0.875,0.75]
[null,null,null,null,null,null,9,0.22600000000000001,0.88700000000000001,0.77400000000000002]
[null,null,null,null,null,null,10,0.20599999999999999,0.89700000000000002,0.79400000000000004]
[null,null,null,null,null,null,11,0.189,0.90500000000000003,0.81100000000000005]
[null,null,null,null,null,null,12,0.17499999999999999,0.91200000000000003,0.82499999999999996]
[null,null,null,null,null,null,13,0.16200000000000001,0.91900000000000004,0.83799999999999997]
[null,null,null,null,null,null,14,0.152,0.92400000000000004,0.84799999999999998]
[null,null,null,null,null,null,15,0.14199999999999999,0.92900000000000005,0.85799999999999998]
[null,null,null,null,null,null,16,0.13400000000000001,0.93300000000000005,0.86599999999999999]
[null,null,null,null,null,null,17,0.127,0.93600000000000005,0.873]
[null,null,null,null,null,null,18,0.12,0.94,0.88]
[null,null,null,null,null,null,19,0.114,0.94299999999999995,0.88600000000000001]
[null,null,null,null,null,null,20,0.109,0.94499999999999995,0.89100000000000001]
[null,null,null,null,null,null,21,0.104,0.94799999999999995,0.89600000000000002]
[null,null,null,null,null,null,22,9.9000000000000005E-2,0.95,0.90100000000000002]
[null,null,null,null,null,null,23,9.5000000000000001E-2,0.95199999999999996,0.90500000000000003]
[null,null,null,null,null,null,24,9.1999999999999998E-2,0.95399999999999996,0.90800000000000003]
[null,null,null,null,null,null,25,8.7999999999999995E-2,0.95599999999999996,0.91200000000000003]
[null,null,null,null,null,null,26,8.5000000000000006E-2,0.95699999999999996,0.91500000000000004]
[null,null,null,null,null,null,27,8.2000000000000003E-2,0.95899999999999996,0.91800000000000004]
[null,null,null,null,null,null,28,7.9000000000000001E-2,0.96,0.92100000000000004]
[null,null,null,null,null,null,29,7.5999999999999998E-2,0.96199999999999997,0.92400000000000004]
[null,null,null,null,null,null,30,7.3999999999999996E-2,0.96299999999999997,0.92600000000000005]
[null,null,null,null,null,null,31,7.1999999999999995E-2,0.96399999999999997,0.92800000000000005]
[null,null,null,null,null,null,32,6.9000000000000006E-2,0.96499999999999997,0.93100000000000005]
[null,null,null,null,null,null,33,6.7000000000000004E-2,0.96599999999999997,0.93300000000000005]
[null,null,null,null,null,null,34,6.6000000000000003E-2,0.96699999999999997,0.93400000000000005]
[null,null,null,null,null,null,35,6.4000000000000001E-2,0.96799999999999997,0.93600000000000005]
[null,null,null,null,null,null,36,6.2E-2,0.96899999999999997,0.93799999999999994]
[null,null,null,null,null,null,37,0.06,0.97,0.94]
[null,null,null,null,null,null,38,5.8999999999999997E-2,0.97,0.94099999999999995]
[null,null,null,null,null,null,39,5.7000000000000002E-2,0.97099999999999997,0.94299999999999995]
[null,null,null,null,null,null,40,5.6000000000000001E-2,0.97199999999999998,0.94399999999999995]
[null,null,null,null,null,null,41,5.5E-2,0.97199999999999998,0.94499999999999995]
[null,null,null,null,null,null,42,5.2999999999999999E-2,0.97299999999999998,0.94699999999999995]
[null,null,null,null,null,null,43,5.1999999999999998E-2,0.97399999999999998,0.94799999999999995]
[null,null,null,null,null,null,44,5.0999999999999997E-2,0.97399999999999998,0.94899999999999995]
[null,null,null,null,null,null,45,0.05,0.97499999999999998,0.95]
[null,null,null,null,null,null,46,4.9000000000000002E-2,0.97499999999999998,0.95099999999999996]
[null,null,null,null,null,null,47,4.8000000000000001E-2,0.97599999999999998,0.95199999999999996]
[null,null,null,null,null,null,48,4.7E-2,0.97599999999999998,0.95299999999999996]
[null,null,null,null,null,null,49,4.5999999999999999E-2,0.97699999999999998,0.95399999999999996]
[null,null,null,null,null,null,50,4.4999999999999998E-2,0.97699999999999998,0.95499999999999996]
[null,null,null,null,null,null,51,4.3999999999999997E-2,0.97799999999999998,0.95599999999999996]
[null,null,null,null,null,null,52,4.2999999999999997E-2,0.97799999999999998,0.95699999999999996]

{"sheet":"sh2増加","index":1,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"種類別明細書（増加資産・全資産用）","申告",2017,"年",null,null,null,null,null,"税率"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.4E-2]
[]
["行番号","資産の種類(ﾄｼﾞ)","資産の種類","資産コード（任意）","資産の名称等","数量","取得年月日","取得価額","耐用年数","残存価額","減価残存率","価額","課税標準","税額","増加事由(ﾄｼﾞ)","増加事由","摘要",{"$f":"sh3試算!BJ4","v":2018},{"$f":"sh3試算!BK4","v":2019}]
[1,"工具、器具及び備品",{"$f":"IF(ISERROR(VLOOKUP($B5,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B5,sh1マスター!$A$1:$B$7,2,0))","v":6},null,"工具、器具及び備品",1,20150801,1600000,4,null,null,null,null,{"$f":"sh3試算!BI5","v":9800},null,{"$f":"IF(ISERROR(VLOOKUP($O5,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O5,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ5","v":5500},{"$f":"sh3試算!BK5","v":3000}]
[2,"機械及び装置",{"$f":"IF(ISERROR(VLOOKUP($B6,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B6,sh1マスター!$A$1:$B$7,2,0))","v":2},null,"機械装置A",1,20160111,1600000,9,null,null,null,null,{"$f":"sh3試算!BI6","v":19800},null,{"$f":"IF(ISERROR(VLOOKUP($O6,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O6,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ6","v":11100},{"$f":"sh3試算!BK6","v":6200}]
[3,"機械及び装置",{"$f":"IF(ISERROR(VLOOKUP($B7,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B7,sh1マスター!$A$1:$B$7,2,0))","v":2},null,"機械装置B",1,20161226,1600000,9,null,null,null,null,{"$f":"sh3試算!BI7","v":19800},null,{"$f":"IF(ISERROR(VLOOKUP($O7,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O7,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ7","v":11100},{"$f":"sh3試算!BK7","v":6200}]
[4,null,{"$f":"IF(ISERROR(VLOOKUP($B8,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B8,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI8","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O8,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O8,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ8","v":""},{"$f":"sh3試算!BK8","v":""}]
[5,null,{"$f":"IF(ISERROR(VLOOKUP($B9,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B9,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI9","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O9,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O9,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ9","v":""},{"$f":"sh3試算!BK9","v":""}]
[6,null,{"$f":"IF(ISERROR(VLOOKUP($B10,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B10,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI10","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O10,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O10,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ10","v":""},{"$f":"sh3試算!BK10","v":""}]
[7,null,{"$f":"IF(ISERROR(VLOOKUP($B11,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B11,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI11","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O11,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O11,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ11","v":""},{"$f":"sh3試算!BK11","v":""}]
[8,null,{"$f":"IF(ISERROR(VLOOKUP($B12,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B12,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI12","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O12,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O12,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ12","v":""},{"$f":"sh3試算!BK12","v":""}]
[9,null,{"$f":"IF(ISERROR(VLOOKUP($B13,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B13,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI13","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O13,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O13,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ13","v":""},{"$f":"sh3試算!BK13","v":""}]
[10,null,{"$f":"IF(ISERROR(VLOOKUP($B14,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B14,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI14","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O14,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O14,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ14","v":""},{"$f":"sh3試算!BK14","v":""}]
[11,null,{"$f":"IF(ISERROR(VLOOKUP($B15,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B15,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI15","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O15,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O15,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ15","v":""},{"$f":"sh3試算!BK15","v":""}]
[12,null,{"$f":"IF(ISERROR(VLOOKUP($B16,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B16,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI16","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O16,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O16,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ16","v":""},{"$f":"sh3試算!BK16","v":""}]
[13,null,{"$f":"IF(ISERROR(VLOOKUP($B17,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B17,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI17","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O17,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O17,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ17","v":""},{"$f":"sh3試算!BK17","v":""}]
[14,null,{"$f":"IF(ISERROR(VLOOKUP($B18,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B18,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI18","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O18,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O18,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ18","v":""},{"$f":"sh3試算!BK18","v":""}]
[15,null,{"$f":"IF(ISERROR(VLOOKUP($B19,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B19,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI19","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O19,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O19,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ19","v":""},{"$f":"sh3試算!BK19","v":""}]
[16,null,{"$f":"IF(ISERROR(VLOOKUP($B20,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B20,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"sh3試算!BI20","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O20,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O20,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ20","v":""},{"$f":"sh3試算!BK20","v":""}]
[17,null,{"$f":"IF(ISERROR(VLOOKUP($B21,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B21,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($I21,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I21,sh1マスター!$G:$H,2,0))","v":""},null,null,{"$f":"sh3試算!BI21","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O21,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O21,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ21","v":""},{"$f":"sh3試算!BK21","v":""}]
[18,null,{"$f":"IF(ISERROR(VLOOKUP($B22,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B22,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($I22,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I22,sh1マスター!$G:$H,2,0))","v":""},null,null,{"$f":"sh3試算!BI22","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O22,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O22,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ22","v":""},{"$f":"sh3試算!BK22","v":""}]
[19,null,{"$f":"IF(ISERROR(VLOOKUP($B23,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B23,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($I23,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I23,sh1マスター!$G:$H,2,0))","v":""},null,null,{"$f":"sh3試算!BI23","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O23,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O23,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ23","v":""},{"$f":"sh3試算!BK23","v":""}]
[20,null,{"$f":"IF(ISERROR(VLOOKUP($B24,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B24,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($I24,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I24,sh1マスター!$G:$H,2,0))","v":""},null,null,{"$f":"sh3試算!BI24","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O24,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O24,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ24","v":""},{"$f":"sh3試算!BK24","v":""}]
[21,null,{"$f":"IF(ISERROR(VLOOKUP($B25,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B25,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($I25,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I25,sh1マスター!$G:$H,2,0))","v":""},null,null,{"$f":"sh3試算!BI25","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O25,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O25,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ25","v":""},{"$f":"sh3試算!BK25","v":""}]
[22,null,{"$f":"IF(ISERROR(VLOOKUP($B26,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B26,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($I26,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I26,sh1マスター!$G:$H,2,0))","v":""},null,null,{"$f":"sh3試算!BI26","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O26,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O26,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ26","v":""},{"$f":"sh3試算!BK26","v":""}]
[23,null,{"$f":"IF(ISERROR(VLOOKUP($B27,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B27,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($I27,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I27,sh1マスター!$G:$H,2,0))","v":""},null,null,{"$f":"sh3試算!BI27","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O27,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O27,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ27","v":""},{"$f":"sh3試算!BK27","v":""}]
[24,null,{"$f":"IF(ISERROR(VLOOKUP($B28,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B28,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($I28,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I28,sh1マスター!$G:$H,2,0))","v":""},null,null,{"$f":"sh3試算!BI28","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O28,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O28,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ28","v":""},{"$f":"sh3試算!BK28","v":""}]
[25,null,{"$f":"IF(ISERROR(VLOOKUP($B29,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B29,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($I29,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I29,sh1マスター!$G:$H,2,0))","v":""},null,null,{"$f":"sh3試算!BI29","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O29,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O29,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ29","v":""},{"$f":"sh3試算!BK29","v":""}]
[26,null,{"$f":"IF(ISERROR(VLOOKUP($B30,sh1マスター!$A$1:$B$7,2,0)),\"\",VLOOKUP($B30,sh1マスター!$A$1:$B$7,2,0))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP($I30,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I30,sh1マスター!$G:$H,2,0))","v":""},null,null,{"$f":"sh3試算!BI30","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($O30,sh1マスター!$D$2:$E$5,2,0)),\"\",VLOOKUP($O30,sh1マスター!$D$2:$E$5,2,0))","v":""},null,{"$f":"sh3試算!BJ30","v":""},{"$f":"sh3試算!BK30","v":""}]
[null,null,null,null,null,null,null,{"$f":"SUM(H5:H30)","v":4800000},null,null,null,null,null,{"$f":"SUM(N5:N30)","v":49400},null,null,null,{"$f":"SUM(R5:R30)","v":27700},15400]

{"sheet":"sh3試算","index":2,"n_rows":30,"n_cols":88,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"種類別明細書（増加資産・全資産用）","申告",{"$f":"sh2増加!G1","v":2017},"年","税率",{"$f":"sh2増加!N2","v":1.4E-2}]
[]
[]
["行番号","資産の種類(ﾄｼﾞ)","資産の種類","資産コード（任意）","資産の名称等","数量","取得年月日","取得価額","耐用年数","減価残存率",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,{"$f":"G1","v":2017},{"$f":"BI4+1","v":2018},{"$f":"BJ4+1","v":2019},2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,{"$f":"CA4+1","v":2036},2037,2038,2039,2040,2041,2042,2043,2044]
[{"$f":"sh2増加!A5","v":1},{"$f":"sh2増加!B5","v":"工具、器具及び備品"},{"$f":"sh2増加!C5","v":6},{"$f":"sh2増加!D5","v":0},{"$f":"sh2増加!E5","v":"工具、器具及び備品"},{"$f":"sh2増加!F5","v":1},{"$f":"sh2増加!G5","v":20150801},{"$f":"sh2増加!H5","v":1600000},{"$f":"sh2増加!I5","v":4},{"$f":"IF(ISERROR(VLOOKUP($I5,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I5,sh1マスター!$G:$H,2,0))","v":0.438},{"$f":"IF(ISERROR(ROUNDDOWN(H5*(1-J5/2),0)),\"\",ROUNDDOWN(H5*(1-J5/2),0))","v":1249600},{"$f":"IF(ISERROR(ROUNDDOWN(K5*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(K5*(1-$J$5),0),ROUNDDOWN(K5*(1-$J$5),0),$H$5*5%))","v":702275},{"$f":"IF(ISERROR(ROUNDDOWN(L5*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L5*(1-$J$5),0),ROUNDDOWN(L5*(1-$J$5),0),$H$5*5%))","v":394678},221809,124656,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,{"$f":"IF(ISERROR(HLOOKUP(MATCH(BI$4-VALUE(LEFT($G5,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A5+1,0)),\"\",ROUNDDOWN(ROUNDDOWN(HLOOKUP(MATCH(BI$4-VALUE(LEFT($G5,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A5+1,0),-3)*$J$1,-2))","v":9800},{"$f":"IF(ISERROR(HLOOKUP(MATCH(BJ$4-VALUE(LEFT($G5,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A5+1,0)),\"\",ROUNDDOWN(ROUNDDOWN(HLOOKUP(MATCH(BJ$4-VALUE(LEFT($G5,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A5+1,0),-3)*$J$1,-2))","v":5500},3000,1700,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,{"$f":"IF(ISERROR(HLOOKUP(MATCH(CB$4-VALUE(LEFT($G5,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A5+1,0)),\"\",ROUNDDOWN(ROUNDDOWN(HLOOKUP(MATCH(CB$4-VALUE(LEFT($G5,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A5+1,0),-3)*$J$1,-2))","v":1100},1100,1100,1100,1100,1100,1100,1100,1100]
[{"$f":"sh2増加!A6","v":2},{"$f":"sh2増加!B6","v":"機械及び装置"},{"$f":"sh2増加!C6","v":2},{"$f":"sh2増加!D6","v":0},{"$f":"sh2増加!E6","v":"機械装置A"},{"$f":"sh2増加!F6","v":1},{"$f":"sh2増加!G6","v":20160111},{"$f":"sh2増加!H6","v":1600000},{"$f":"sh2増加!I6","v":9},{"$f":"IF(ISERROR(VLOOKUP($I6,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I6,sh1マスター!$G:$H,2,0))","v":0.22600000000000001},{"$f":"IF(ISERROR(ROUNDDOWN(H6*(1-J6/2),0)),\"\",ROUNDDOWN(H6*(1-J6/2),0))","v":1419200},{"$f":"IF(ISERROR(ROUNDDOWN(K6*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(K6*(1-$J$5),0),ROUNDDOWN(K6*(1-$J$5),0),$H$5*5%))","v":797590},{"$f":"IF(ISERROR(ROUNDDOWN(L6*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L6*(1-$J$5),0),ROUNDDOWN(L6*(1-$J$5),0),$H$5*5%))","v":448245},251913,141575,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,{"$f":"IF(ISERROR(HLOOKUP(MATCH(BI$4-VALUE(LEFT($G6,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A6+1,0)),\"\",ROUNDDOWN(ROUNDDOWN(HLOOKUP(MATCH(BI$4-VALUE(LEFT($G6,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A6+1,0),-3)*$J$1,-2))","v":19800},11100,6200,3500,1900,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100]
[{"$f":"sh2増加!A7","v":3},{"$f":"sh2増加!B7","v":"機械及び装置"},{"$f":"sh2増加!C7","v":2},{"$f":"sh2増加!D7","v":0},{"$f":"sh2増加!E7","v":"機械装置B"},{"$f":"sh2増加!F7","v":1},{"$f":"sh2増加!G7","v":20161226},{"$f":"sh2増加!H7","v":1600000},{"$f":"sh2増加!I7","v":9},{"$f":"IF(ISERROR(VLOOKUP($I7,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I7,sh1マスター!$G:$H,2,0))","v":0.22600000000000001},1419200,797590,{"$f":"IF(ISERROR(ROUNDDOWN(L7*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L7*(1-$J$5),0),ROUNDDOWN(L7*(1-$J$5),0),$H$5*5%))","v":448245},251913,141575,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,19800,11100,6200,3500,1900,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100]
[{"$f":"sh2増加!A8","v":4},{"$f":"sh2増加!B8","v":0},{"$f":"sh2増加!C8","v":""},{"$f":"sh2増加!D8","v":0},{"$f":"sh2増加!E8","v":0},{"$f":"sh2増加!F8","v":0},{"$f":"sh2増加!G8","v":0},{"$f":"sh2増加!H8","v":0},{"$f":"sh2増加!I8","v":0},{"$f":"IF(ISERROR(VLOOKUP($I8,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I8,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L8*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L8*(1-$J$5),0),ROUNDDOWN(L8*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A9","v":5},{"$f":"sh2増加!B9","v":0},{"$f":"sh2増加!C9","v":""},{"$f":"sh2増加!D9","v":0},{"$f":"sh2増加!E9","v":0},{"$f":"sh2増加!F9","v":0},{"$f":"sh2増加!G9","v":0},{"$f":"sh2増加!H9","v":0},{"$f":"sh2増加!I9","v":0},{"$f":"IF(ISERROR(VLOOKUP($I9,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I9,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L9*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L9*(1-$J$5),0),ROUNDDOWN(L9*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A10","v":6},{"$f":"sh2増加!B10","v":0},{"$f":"sh2増加!C10","v":""},{"$f":"sh2増加!D10","v":0},{"$f":"sh2増加!E10","v":0},{"$f":"sh2増加!F10","v":0},{"$f":"sh2増加!G10","v":0},{"$f":"sh2増加!H10","v":0},{"$f":"sh2増加!I10","v":0},{"$f":"IF(ISERROR(VLOOKUP($I10,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I10,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L10*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L10*(1-$J$5),0),ROUNDDOWN(L10*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A11","v":7},{"$f":"sh2増加!B11","v":0},{"$f":"sh2増加!C11","v":""},{"$f":"sh2増加!D11","v":0},{"$f":"sh2増加!E11","v":0},{"$f":"sh2増加!F11","v":0},{"$f":"sh2増加!G11","v":0},{"$f":"sh2増加!H11","v":0},{"$f":"sh2増加!I11","v":0},{"$f":"IF(ISERROR(VLOOKUP($I11,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I11,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L11*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L11*(1-$J$5),0),ROUNDDOWN(L11*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A12","v":8},{"$f":"sh2増加!B12","v":0},{"$f":"sh2増加!C12","v":""},{"$f":"sh2増加!D12","v":0},{"$f":"sh2増加!E12","v":0},{"$f":"sh2増加!F12","v":0},{"$f":"sh2増加!G12","v":0},{"$f":"sh2増加!H12","v":0},{"$f":"sh2増加!I12","v":0},{"$f":"IF(ISERROR(VLOOKUP($I12,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I12,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L12*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L12*(1-$J$5),0),ROUNDDOWN(L12*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A13","v":9},{"$f":"sh2増加!B13","v":0},{"$f":"sh2増加!C13","v":""},{"$f":"sh2増加!D13","v":0},{"$f":"sh2増加!E13","v":0},{"$f":"sh2増加!F13","v":0},{"$f":"sh2増加!G13","v":0},{"$f":"sh2増加!H13","v":0},{"$f":"sh2増加!I13","v":0},{"$f":"IF(ISERROR(VLOOKUP($I13,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I13,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L13*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L13*(1-$J$5),0),ROUNDDOWN(L13*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A14","v":10},{"$f":"sh2増加!B14","v":0},{"$f":"sh2増加!C14","v":""},{"$f":"sh2増加!D14","v":0},{"$f":"sh2増加!E14","v":0},{"$f":"sh2増加!F14","v":0},{"$f":"sh2増加!G14","v":0},{"$f":"sh2増加!H14","v":0},{"$f":"sh2増加!I14","v":0},{"$f":"IF(ISERROR(VLOOKUP($I14,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I14,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L14*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L14*(1-$J$5),0),ROUNDDOWN(L14*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A15","v":11},{"$f":"sh2増加!B15","v":0},{"$f":"sh2増加!C15","v":""},{"$f":"sh2増加!D15","v":0},{"$f":"sh2増加!E15","v":0},{"$f":"sh2増加!F15","v":0},{"$f":"sh2増加!G15","v":0},{"$f":"sh2増加!H15","v":0},{"$f":"sh2増加!I15","v":0},{"$f":"IF(ISERROR(VLOOKUP($I15,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I15,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L15*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L15*(1-$J$5),0),ROUNDDOWN(L15*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A16","v":12},{"$f":"sh2増加!B16","v":0},{"$f":"sh2増加!C16","v":""},{"$f":"sh2増加!D16","v":0},{"$f":"sh2増加!E16","v":0},{"$f":"sh2増加!F16","v":0},{"$f":"sh2増加!G16","v":0},{"$f":"sh2増加!H16","v":0},{"$f":"sh2増加!I16","v":0},{"$f":"IF(ISERROR(VLOOKUP($I16,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I16,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L16*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L16*(1-$J$5),0),ROUNDDOWN(L16*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A17","v":13},{"$f":"sh2増加!B17","v":0},{"$f":"sh2増加!C17","v":""},{"$f":"sh2増加!D17","v":0},{"$f":"sh2増加!E17","v":0},{"$f":"sh2増加!F17","v":0},{"$f":"sh2増加!G17","v":0},{"$f":"sh2増加!H17","v":0},{"$f":"sh2増加!I17","v":0},{"$f":"IF(ISERROR(VLOOKUP($I17,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I17,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L17*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L17*(1-$J$5),0),ROUNDDOWN(L17*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A18","v":14},{"$f":"sh2増加!B18","v":0},{"$f":"sh2増加!C18","v":""},{"$f":"sh2増加!D18","v":0},{"$f":"sh2増加!E18","v":0},{"$f":"sh2増加!F18","v":0},{"$f":"sh2増加!G18","v":0},{"$f":"sh2増加!H18","v":0},{"$f":"sh2増加!I18","v":0},{"$f":"IF(ISERROR(VLOOKUP($I18,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I18,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L18*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L18*(1-$J$5),0),ROUNDDOWN(L18*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A19","v":15},{"$f":"sh2増加!B19","v":0},{"$f":"sh2増加!C19","v":""},{"$f":"sh2増加!D19","v":0},{"$f":"sh2増加!E19","v":0},{"$f":"sh2増加!F19","v":0},{"$f":"sh2増加!G19","v":0},{"$f":"sh2増加!H19","v":0},{"$f":"sh2増加!I19","v":0},{"$f":"IF(ISERROR(VLOOKUP($I19,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I19,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L19*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L19*(1-$J$5),0),ROUNDDOWN(L19*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A20","v":16},{"$f":"sh2増加!B20","v":0},{"$f":"sh2増加!C20","v":""},{"$f":"sh2増加!D20","v":0},{"$f":"sh2増加!E20","v":0},{"$f":"sh2増加!F20","v":0},{"$f":"sh2増加!G20","v":0},{"$f":"sh2増加!H20","v":0},{"$f":"sh2増加!I20","v":0},{"$f":"IF(ISERROR(VLOOKUP($I20,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I20,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L20*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L20*(1-$J$5),0),ROUNDDOWN(L20*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(HLOOKUP(MATCH(BJ$4-VALUE(LEFT($G20,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A20+1,0)),\"\",ROUNDDOWN(ROUNDDOWN(HLOOKUP(MATCH(BJ$4-VALUE(LEFT($G20,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A20+1,0),-3)*$J$1,-2))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A21","v":17},{"$f":"sh2増加!B21","v":0},{"$f":"sh2増加!C21","v":""},{"$f":"sh2増加!D21","v":0},{"$f":"sh2増加!E21","v":0},{"$f":"sh2増加!F21","v":0},{"$f":"sh2増加!G21","v":0},{"$f":"sh2増加!H21","v":0},{"$f":"sh2増加!I21","v":0},{"$f":"IF(ISERROR(VLOOKUP($I21,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I21,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L21*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L21*(1-$J$5),0),ROUNDDOWN(L21*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(HLOOKUP(MATCH(CB$4-VALUE(LEFT($G21,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A21+1,0)),\"\",ROUNDDOWN(ROUNDDOWN(HLOOKUP(MATCH(CB$4-VALUE(LEFT($G21,4)),$K$4:$BH$4,0),$K$4:$BH$30,$A21+1,0),-3)*$J$1,-2))","v":""},"","","","","","","",""]
[{"$f":"sh2増加!A22","v":18},{"$f":"sh2増加!B22","v":0},{"$f":"sh2増加!C22","v":""},{"$f":"sh2増加!D22","v":0},{"$f":"sh2増加!E22","v":0},{"$f":"sh2増加!F22","v":0},{"$f":"sh2増加!G22","v":0},{"$f":"sh2増加!H22","v":0},{"$f":"sh2増加!I22","v":0},{"$f":"IF(ISERROR(VLOOKUP($I22,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I22,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L22*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L22*(1-$J$5),0),ROUNDDOWN(L22*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A23","v":19},{"$f":"sh2増加!B23","v":0},{"$f":"sh2増加!C23","v":""},{"$f":"sh2増加!D23","v":0},{"$f":"sh2増加!E23","v":0},{"$f":"sh2増加!F23","v":0},{"$f":"sh2増加!G23","v":0},{"$f":"sh2増加!H23","v":0},{"$f":"sh2増加!I23","v":0},{"$f":"IF(ISERROR(VLOOKUP($I23,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I23,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L23*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L23*(1-$J$5),0),ROUNDDOWN(L23*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A24","v":20},{"$f":"sh2増加!B24","v":0},{"$f":"sh2増加!C24","v":""},{"$f":"sh2増加!D24","v":0},{"$f":"sh2増加!E24","v":0},{"$f":"sh2増加!F24","v":0},{"$f":"sh2増加!G24","v":0},{"$f":"sh2増加!H24","v":0},{"$f":"sh2増加!I24","v":0},{"$f":"IF(ISERROR(VLOOKUP($I24,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I24,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L24*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L24*(1-$J$5),0),ROUNDDOWN(L24*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A25","v":21},{"$f":"sh2増加!B25","v":0},{"$f":"sh2増加!C25","v":""},{"$f":"sh2増加!D25","v":0},{"$f":"sh2増加!E25","v":0},{"$f":"sh2増加!F25","v":0},{"$f":"sh2増加!G25","v":0},{"$f":"sh2増加!H25","v":0},{"$f":"sh2増加!I25","v":0},{"$f":"IF(ISERROR(VLOOKUP($I25,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I25,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L25*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L25*(1-$J$5),0),ROUNDDOWN(L25*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A26","v":22},{"$f":"sh2増加!B26","v":0},{"$f":"sh2増加!C26","v":""},{"$f":"sh2増加!D26","v":0},{"$f":"sh2増加!E26","v":0},{"$f":"sh2増加!F26","v":0},{"$f":"sh2増加!G26","v":0},{"$f":"sh2増加!H26","v":0},{"$f":"sh2増加!I26","v":0},{"$f":"IF(ISERROR(VLOOKUP($I26,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I26,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L26*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L26*(1-$J$5),0),ROUNDDOWN(L26*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A27","v":23},{"$f":"sh2増加!B27","v":0},{"$f":"sh2増加!C27","v":""},{"$f":"sh2増加!D27","v":0},{"$f":"sh2増加!E27","v":0},{"$f":"sh2増加!F27","v":0},{"$f":"sh2増加!G27","v":0},{"$f":"sh2増加!H27","v":0},{"$f":"sh2増加!I27","v":0},{"$f":"IF(ISERROR(VLOOKUP($I27,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I27,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L27*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L27*(1-$J$5),0),ROUNDDOWN(L27*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A28","v":24},{"$f":"sh2増加!B28","v":0},{"$f":"sh2増加!C28","v":""},{"$f":"sh2増加!D28","v":0},{"$f":"sh2増加!E28","v":0},{"$f":"sh2増加!F28","v":0},{"$f":"sh2増加!G28","v":0},{"$f":"sh2増加!H28","v":0},{"$f":"sh2増加!I28","v":0},{"$f":"IF(ISERROR(VLOOKUP($I28,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I28,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L28*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L28*(1-$J$5),0),ROUNDDOWN(L28*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A29","v":25},{"$f":"sh2増加!B29","v":0},{"$f":"sh2増加!C29","v":""},{"$f":"sh2増加!D29","v":0},{"$f":"sh2増加!E29","v":0},{"$f":"sh2増加!F29","v":0},{"$f":"sh2増加!G29","v":0},{"$f":"sh2増加!H29","v":0},{"$f":"sh2増加!I29","v":0},{"$f":"IF(ISERROR(VLOOKUP($I29,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I29,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L29*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L29*(1-$J$5),0),ROUNDDOWN(L29*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"sh2増加!A30","v":26},{"$f":"sh2増加!B30","v":0},{"$f":"sh2増加!C30","v":""},{"$f":"sh2増加!D30","v":0},{"$f":"sh2増加!E30","v":0},{"$f":"sh2増加!F30","v":0},{"$f":"sh2増加!G30","v":0},{"$f":"sh2増加!H30","v":0},{"$f":"sh2増加!I30","v":0},{"$f":"IF(ISERROR(VLOOKUP($I30,sh1マスター!$G:$H,2,0)),\"\",VLOOKUP($I30,sh1マスター!$G:$H,2,0))","v":""},"","",{"$f":"IF(ISERROR(ROUNDDOWN(L30*(1-$J$5),0)),\"\",IF($H$5*5%<ROUNDDOWN(L30*(1-$J$5),0),ROUNDDOWN(L30*(1-$J$5),0),$H$5*5%))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]