{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["見積書","見積内訳書","記入注意事項","見積書(記入例)","見積内訳書(記入例)","消費税率"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":49,"n_cols":53,"rows_kept":49,"cut":false,"hidden":false,"merged":[[11,6,13,16],[11,36,13,42],[48,43,49,52],[34,36,39,39],[34,40,39,52],[40,36,47,39],[40,40,41,42],[45,40,46,42],[15,24,17,26],[19,19,21,23],[19,24,21,26],[17,36,19,52],[25,24,28,27],[25,28,28,34],[11,43,13,52],[14,36,16,42],[31,37,32,39],[31,40,32,52],[47,0,47,5],[47,6,47,34],[44,23,46,23],[44,27,46,28],[44,26,46,26],[44,16,46,19],[44,13,46,14],[44,6,46,8],[44,15,46,15],[44,29,46,29],[44,0,46,5],[44,20,46,22],[44,9,46,9],[44,10,46,11],[44,12,46,12],[44,24,46,25],[25,13,28,16],[15,0,17,5],[0,0,2,52],[6,0,8,10],[4,41,5,45],[4,46,5,47],[4,48,5,48],[4,49,5,49],[4,50,5,50],[4,52,5,52],[4,51,5,51],[7,11,8,17],[11,0,13,5],[15,19,17,23],[15,6,17,16],[14,43,16,43],[14,44,16,52],[41,0,43,5],[38,0,40,5],[41,6,43,34],[33,1,36,5],[29,1,32,5],[29,25,32,27],[29,24,36,24],[33,17,36,23],[33,28,36,34],[33,25,36,27],[38,6,40,34],[29,28,32,34],[19,9,21,9],[23,0,23,5],[29,17,32,23],[29,0,36,0],[19,6,21,8],[29,6,32,12],[33,6,36,12],[19,10,21,16],[29,13,36,13],[33,14,36,16],[29,14,32,16],[25,6,28,12],[25,17,28,23],[23,6,23,11],[25,0,28,5],[19,0,21,5]]}
["見　　積　　書"]
[]
[]
[]
[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,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,"T"]
["※工事科目",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 枝　　番\n  (任意項目)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"郵便番号･住所・会社名・代表者名･電話･FAX"]
[]
["※注文番号",null,null,null,null,null,null,null,null,"－",null,null,null,null,null,null,null,null,null,"※変更回数"]
[]
[]
[]
["   消 費 税 率",null,null,null,null,null,"10%"]
[]
["今回見積金額",null,null,null,null,null,{"$f":"IF(AND(G30=\"\",G34=\"\"),\"\",SUM(G30:M34))","v":""},null,null,null,null,null,null,"既契約金額",null,null,null,{"$f":"IF(AND(R30=\"\",R34=\"\"),\"\",SUM(R30:X34))","v":""},null,null,null,null,null,null,"累計金額",null,null,null,{"$f":"IF(AND(G26=\"\",R26=\"\"),\"\",SUM(G26,R26))","v":""}]
[]
[]
[]
["内訳","税抜金額",null,null,null,null,null,null,null,null,null,null,null,"内訳","税抜金額",null,null,null,null,null,null,null,null,null,"内訳","税抜金額",null,null,{"$f":"IF(AND(G30=\"\",R30=\"\"),\"\",SUM(G30,R30))","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,{"$f":"IF(G30=\"\",\"\",IF(G24=\"\",\"消費税率を選択してください\",IF(OR(G24=\"10%\",G24=\"免税10％\"),ROUNDDOWN(G30*10%,0),IF(OR(G24=\"8％\",G24=\"免税8％\"),ROUNDDOWN(G30*8%,0),0))))","v":""},null,null,null,null,null,null,null,"消費税額等",null,null,{"$f":"IF(R30=\"\",\"\",IF(G24=\"\",\"消費税率を選択してください\",IF(OR(G24=\"10%\",G24=\"免税10％\"),ROUNDDOWN(R30*10%,0),IF(OR(G24=\"8％\",G24=\"免税8％\"),ROUNDDOWN(R30*8%,0),0))))","v":""},null,null,null,null,null,null,null,"消費税額等",null,null,{"$f":"IF(AND(G34=\"\",R34=\"\"),\"\",SUM(G34,R34))","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,"※工事所\n　押印欄",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,null,null,null,null,null,null,null,null,null,null,"（様式：全1800-03-01/26.04）"]

{"sheet":"見積内訳書","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["見　　積　　内　　訳　　書"]
[]
["※工種コード","名　　称","仕　　様\n(品質・形状・寸法等)","単位","数量","単　価","金　　額","備　　考\n(メーカー名)"]
[null,null,null,null,null,null,{"$f":"IF(AND(E4=\"\",F4=\"\"),\"\",ROUNDDOWN(E4*F4,0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(E5=\"\",F5=\"\"),\"\",ROUNDDOWN(E5*F5,0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(E6=\"\",F6=\"\"),\"\",ROUNDDOWN(E6*F6,0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(E7=\"\",F7=\"\"),\"\",ROUNDDOWN(E7*F7,0))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(E8=\"\",F8=\"\"),\"\",ROUNDDOWN(E8*F8,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,{"$f":"IF(AND(E21=\"\",F21=\"\"),\"\",ROUNDDOWN(E21*F21,0))","v":""}]
[null,"建退共掛金",null,"式","―","―","―"]
[null,null,null,null,null,null,""]

{"sheet":"記入注意事項","index":2,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["記入注意事項"]
[]
["　　　　 １．変更見積の場合は、見積内訳書に代えて変更内訳書を提出して下さい。"]
[]
["　　　　 ２．黄色のセルに入力して下さい。"]
[]
["　　　　 ３．水色のセルは自動計算されますが、必要に応じて上書き修正できます。"]
[]
["　　　　 ４．※欄は当社使用欄ですので、記入しないで下さい。"]
[]
["　　　　 ５．資機材（材工共工事の場合も含む）については、メーカー名を見積内訳書に記入して下さい。"]
[]
["　　　　 ６．施工条件等についての記載は、見積内訳書または別用紙に記入し、添付して下さい。"]
[]
["　　　　 ７．取引先コードのない業者は、弊社職員の指示に従って下さい。"]
[]
["　　　　 ８．見積内訳書は、当社指定様式と同様の内容が記載されていれば、任意の書式でもかまいせん。"]
[]
["　　　　 ９．白黒印刷設定をしていますので、そのまま印刷して提出して下さい。"]
[]
["　　　　１０．弊社には１部提出して下さい。"]
[]
["　　　　１１．インボイス登録事業者は必ず登録番号を記載して下さい。"]
[]
["　　　　１２．記入例を参考に材料費、労務費、法定福利費、安全衛生経費並びに建設業退職金共済契約に係る掛金を記入して下さい。"]

{"sheet":"見積書(記入例)","index":3,"n_rows":49,"n_cols":53,"rows_kept":49,"cut":false,"hidden":false,"merged":[[45,40,46,42],[40,36,47,39],[48,43,49,52],[44,16,46,19],[44,20,46,22],[44,23,46,23],[44,24,46,25],[44,26,46,26],[40,40,41,42],[17,36,19,52],[14,36,16,42],[14,43,16,43],[14,44,16,52],[29,17,32,23],[29,24,36,24],[29,28,32,34],[33,28,36,34],[29,25,32,27],[31,37,32,39],[31,40,32,52],[34,36,39,39],[34,40,39,52],[25,24,28,27],[47,0,47,5],[47,6,47,34],[44,9,46,9],[44,12,46,12],[41,6,43,34],[44,0,46,5],[44,27,46,28],[44,6,46,8],[44,10,46,11],[44,13,46,14],[44,15,46,15],[44,29,46,29],[41,0,43,5],[29,0,36,0],[29,1,32,5],[29,6,32,12],[38,0,40,5],[38,6,40,34],[33,1,36,5],[33,6,36,12],[33,14,36,16],[33,17,36,23],[33,25,36,27],[29,13,36,13],[29,14,32,16],[25,0,28,5],[25,6,28,12],[25,13,28,16],[25,17,28,23],[25,28,28,34],[15,0,17,5],[15,6,17,16],[15,19,17,23],[15,24,17,26],[19,0,21,5],[19,6,21,8],[19,9,21,9],[19,10,21,16],[19,19,21,23],[19,24,21,26],[23,0,23,5],[23,6,23,9],[11,0,13,5],[0,0,2,52],[6,0,8,10],[4,41,5,45],[4,46,5,47],[4,48,5,48],[4,49,5,49],[4,50,5,50],[4,52,5,52],[11,6,13,16],[11,36,13,42],[11,43,13,52],[4,51,5,51],[7,11,8,17]]}
["見　　積　　書"]
[]
[]
[]
[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,2023,null,"年",8,"月",1,"日"]
[]
["S．Kマンション"]
[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,30123456]
[]
[]
[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,"T"]
["※工事科目",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※ 枝　　番\n  (任意項目)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"郵便番号･住所・会社名・代表者名･電話･FAX"]
[]
["※注文番号",null,null,null,null,null,null,null,null,"－",null,null,null,null,null,null,null,null,null,"※変更回数"]
[]
[]
[]
["   消 費 税 率",null,null,null,null,null,"10%"]
[]
["今回見積金額",null,null,null,null,null,{"$f":"IF(AND(G30=\"\",G34=\"\"),\"\",SUM(G30:M34))","v":11000000},null,null,null,null,null,null,"既契約金額",null,null,null,{"$f":"IF(AND(R30=\"\",R34=\"\"),\"\",SUM(R30:X34))","v":0},null,null,null,null,null,null,"累計金額",null,null,null,{"$f":"IF(AND(G26=\"\",R26=\"\"),\"\",SUM(G26,R26))","v":11000000}]
[]
[]
[]
["内訳","税抜金額",null,null,null,null,10000000,null,null,null,null,null,null,"内訳","税抜金額",null,null,0,null,null,null,null,null,null,"内訳","税抜金額",null,null,{"$f":"IF(AND(G30=\"\",R30=\"\"),\"\",SUM(G30,R30))","v":10000000}]
[]
[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,{"$f":"IF(G30=\"\",\"\",IF(G24=\"\",\"消費税率を選択してください\",IF(OR(G24=\"10%\",G24=\"免税10％\"),ROUNDDOWN(G30*10%,0),IF(OR(G24=\"8％\",G24=\"免税8％\"),ROUNDDOWN(G30*8%,0),0))))","v":1000000},null,null,null,null,null,null,null,"消費税額等",null,null,{"$f":"IF(R30=\"\",\"\",IF(G24=\"\",\"消費税率を選択してください\",IF(OR(G24=\"10%\",G24=\"免税10％\"),ROUNDDOWN(R30*10%,0),IF(OR(G24=\"8％\",G24=\"免税8％\"),ROUNDDOWN(R30*8%,0),0))))","v":0},null,null,null,null,null,null,null,"消費税額等",null,null,{"$f":"IF(AND(G34=\"\",R34=\"\"),\"\",SUM(G34,R34))","v":1000000}]
[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,"※工事所\n　押印欄",null,null,null,"工事所長"]
["施工(納入)場所",null,null,null,null,null,"貴工事所"]
[]
[]
["工期（納期）",null,null,null,null,null,2023,null,null,"年",10,null,"月",1,null,"日","～",null,null,null,2023,null,null,"年",12,null,"月",31,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,"（様式：全1800-03-01/26.04）"]

{"sheet":"見積内訳書(記入例)","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["見　　積　　内　　訳　　書"]
[]
["※工種コード","名　　称","仕　　様\n(品質・形状・寸法等)","単位","数量","単　価","金　　額","備　　考\n(メーカー名等)"]
[null,"仮設工事",null,null,null,null,{"$f":"IF(AND(E4=\"\",F4=\"\"),\"\",ROUNDDOWN(E4*F4,0))","v":""}]
[null,"トップスラブ手摺","型枠上一次手摺","ｍ",150,1000,150000]
[null,"トップスラブ手摺","幅木・ネット貼り","ｍ",125,10000,1250000]
[null,"立駐基礎周り足場組払い",null,"空㎥",1,5000000,5000000]
[null,"小計",null,null,null,null,{"$f":"SUM(G5:G7)","v":6400000}]
[null,"コンクリート工事",null,null,null,null,""]
[null,"トップスラブコンクリート打設",null,"㎥",500,1200,600000]
[null,"立駐基礎コン打設",null,"㎥",1000,1200,1200000]
[null,"小計",null,null,null,null,{"$f":"SUM(G10:G11)","v":1800000}]
[null,"～",null,null,null,null,"～"]
[null,"諸経費",null,"式",1,1000000,1000000]
[null,"合計",null,null,null,null,10000000]
[null,null,null,null,null,null,{"$f":"IF(AND(E16=\"\",F16=\"\"),\"\",ROUNDDOWN(E16*F16,0))","v":""}]
[null,"うち、労務費等の経費",null,null,null,null,""]
[null,"材料費",null,"式",1,1014260,1014260]
[null,"労務費",null,"式",1,1573533,1573533]
[null,"法定福利費",null,"式",1,257585,257585]
[null,"安全衛生経費",null,"式",1,143117,{"$f":"IF(AND(E21=\"\",F21=\"\"),\"\",ROUNDDOWN(E21*F21,0))","v":143117}]
[null,"建退共掛金",null,"式","―","―","―"]
[null,null,null,null,null,null,""]

{"sheet":"消費税率","index":5,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["消費税率"]
["5％"]
["8％"]