{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["変更内訳書","記入注意事項","変更内訳書(記入例)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"変更内訳書","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,9,2,11],[2,12,3,12],[2,6,2,8],[2,3,2,5]]}
["変　　更　　内　　訳　　書"]
[]
["名　　称","仕　　様","単位","今　回　見　積　金　額",null,null,"既　契　約　金　額",null,null,"累　計　金　額",null,null,"備　　考"]
[null,null,null,"数　量","単　価","金　　額","数　量","単　価","金　　額","数　量","単　価","金　　額"]
[null,null,null,null,null,{"$f":"IF(AND(E5=\"\",D5=\"\"),\"\",ROUNDDOWN(D5*E5,0))","v":""},null,null,{"$f":"IF(AND(H5=\"\",G5=\"\"),\"\",ROUNDDOWN(G5*H5,0))","v":""},{"$f":"IF(AND(D5=\"\",G5=\"\"),\"\",IF(C5=\"式\",1,SUM(D5,G5)))","v":""},{"$f":"IF(AND(D5=\"\",E5=\"\",G5=\"\",H5=\"\"),\"\",IF(C5=\"式\",SUM(E5,H5),IF(AND(E5<>\"\",H5<>\"\",E5<>H5),\"単価変更不可\",IF(AND(D5<0,G5=D5),H5-E5,IF(H5=\"\",E5,H5)))))","v":""},{"$f":"IF(AND(F5=\"\",I5=\"\"),\"\",SUM(F5,I5))","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(E6=\"\",D6=\"\"),\"\",ROUNDDOWN(D6*E6,0))","v":""},null,null,{"$f":"IF(AND(H6=\"\",G6=\"\"),\"\",ROUNDDOWN(G6*H6,0))","v":""},{"$f":"IF(AND(D6=\"\",G6=\"\"),\"\",IF(C6=\"式\",1,SUM(D6,G6)))","v":""},{"$f":"IF(AND(D6=\"\",E6=\"\",G6=\"\",H6=\"\"),\"\",IF(C6=\"式\",SUM(E6,H6),IF(AND(E6<>\"\",H6<>\"\",E6<>H6),\"単価変更不可\",IF(AND(D6<0,G6=D6),H6-E6,IF(H6=\"\",E6,H6)))))","v":""},{"$f":"IF(AND(F6=\"\",I6=\"\"),\"\",SUM(F6,I6))","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(E7=\"\",D7=\"\"),\"\",ROUNDDOWN(D7*E7,0))","v":""},null,null,{"$f":"IF(AND(H7=\"\",G7=\"\"),\"\",ROUNDDOWN(G7*H7,0))","v":""},"","",{"$f":"IF(AND(F7=\"\",I7=\"\"),\"\",SUM(F7,I7))","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(E8=\"\",D8=\"\"),\"\",ROUNDDOWN(D8*E8,0))","v":""},null,null,{"$f":"IF(AND(H8=\"\",G8=\"\"),\"\",ROUNDDOWN(G8*H8,0))","v":""},"","",{"$f":"IF(AND(F8=\"\",I8=\"\"),\"\",SUM(F8,I8))","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(E9=\"\",D9=\"\"),\"\",ROUNDDOWN(D9*E9,0))","v":""},null,null,{"$f":"IF(AND(H9=\"\",G9=\"\"),\"\",ROUNDDOWN(G9*H9,0))","v":""},"","",{"$f":"IF(AND(F9=\"\",I9=\"\"),\"\",SUM(F9,I9))","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(E10=\"\",D10=\"\"),\"\",ROUNDDOWN(D10*E10,0))","v":""},null,null,{"$f":"IF(AND(H10=\"\",G10=\"\"),\"\",ROUNDDOWN(G10*H10,0))","v":""},"","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]

{"sheet":"記入注意事項","index":1,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["記入注意事項"]
[]
["　　　　 １．黄色のセルに入力して下さい。"]
[]
["　　　　 ２．水色のセルは自動計算されますが、必要に応じて上書き修正できます。"]
[]
["　　　　 ３．変更内訳書は、当社指定様式と同様の内容が記載されていれば、任意の書式でもかまいせん。"]
[]
["　　　　 ４．白黒印刷設定をしていますので、そのまま印刷して提出して下さい。"]
[]
["　　　　 ５．弊社には１部提出して下さい。"]

{"sheet":"変更内訳書(記入例)","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,9,2,11],[2,12,3,12],[2,6,2,8],[2,3,2,5]]}
["変　　更　　内　　訳　　書"]
[]
["名　　称","仕　　様","単位","今　回　見　積　金　額",null,null,"既　契　約　金　額",null,null,"累　計　金　額",null,null,"備　　考"]
[null,null,null,"数　量","単　価","金　　額","数　量","単　価","金　　額","数　量","単　価","金　　額"]
["仮設工事",null,null,null,null,{"$f":"IF(AND(E5=\"\",D5=\"\"),\"\",ROUNDDOWN(D5*E5,0))","v":""},null,null,{"$f":"IF(AND(H5=\"\",G5=\"\"),\"\",ROUNDDOWN(G5*H5,0))","v":""},{"$f":"IF(AND(D5=\"\",G5=\"\"),\"\",IF(C5=\"式\",1,SUM(D5,G5)))","v":""},{"$f":"IF(AND(D5=\"\",E5=\"\",G5=\"\",H5=\"\"),\"\",IF(C5=\"式\",SUM(E5,H5),IF(AND(E5<>\"\",H5<>\"\",E5<>H5),\"単価変更不可\",IF(AND(D5<0,G5=D5),H5-E5,IF(H5=\"\",E5,H5)))))","v":""},{"$f":"IF(AND(F5=\"\",I5=\"\"),\"\",SUM(F5,I5))","v":""}]
["トップスラブ手摺","型枠上一次手摺","ｍ",null,null,"",123,987,121401,{"$f":"IF(AND(D6=\"\",G6=\"\"),\"\",IF(C6=\"式\",1,SUM(D6,G6)))","v":123},{"$f":"IF(AND(D6=\"\",E6=\"\",G6=\"\",H6=\"\"),\"\",IF(C6=\"式\",SUM(E6,H6),IF(AND(E6<>\"\",H6<>\"\",E6<>H6),\"単価変更不可\",IF(AND(D6<0,G6=D6),H6-E6,IF(H6=\"\",E6,H6)))))","v":987},121401]
["トップスラブ手摺","幅木・ネット貼り","ｍ",null,null,"",123,9876,1214748,123,9876,1214748]
["立駐基礎周り足場組払い",null,"式",null,null,"",1,5000000,5000000,1,5000000,5000000]
["小計",null,null,null,null,"",null,null,{"$f":"SUM(I6:I8)","v":6336149},"","",6336149]
["コンクリート工事",null,null,null,null,"",null,null,"","","",""]
["トップスラブコンクリート打設",null,"㎥",1000,1234,1234000,555.5,1234,685487,1555.5,1234,1919487]
["立駐基礎コン打設",null,"㎥",600,2345,1407000,1000,1234,1234000,1600,"単価変更不可",2641000]
["小計",null,null,null,null,{"$f":"SUM(F11:F12)","v":2641000},null,null,{"$f":"SUM(I11:I12)","v":1919487},"","",4560487]
["値引",null,"式",1,-4400,{"$f":"IF(AND(E14=\"\",D14=\"\"),\"\",ROUNDDOWN(D14*E14,0))","v":-4400},1,-55636,-55636,1,-60036,-60036]
["合計",null,null,null,null,{"$f":"SUM(F9,F13,F14)","v":2636600},null,null,{"$f":"SUM(I9,I13,I14)","v":8200000},"","",{"$f":"IF(AND(F15=\"\",I15=\"\"),\"\",SUM(F15,I15))","v":10836600}]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]
[null,null,null,null,null,"",null,null,"","","",""]