{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["入力","申告書"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[18,1,20,1],[19,2,19,3],[18,2,18,5],[19,4,19,5],[1,1,1,8],[9,1,11,1],[9,2,10,7],[9,8,11,8],[3,8,3,9],[4,8,7,9],[20,7,20,9]]}
[]
[null,"建退共証紙購入（当初・変更）申告書 購入金額チェックシステム"]
[]
[null,null,null,"金額欄","証紙購入額",null,null,null,"このシステムの使い方など"]
[null,null,"当初契約額",null,{"$f":"IF(D5=\"\",申告書!Z22,申告書!AB25)","v":""},null,null,null,"①　当初契約額に金額を入れます。\n②　舗装、橋梁等の工事種別ボタンを押します。\n③　変更増があれば変更増額欄に金額を入れます。\n④　終了したらクリアボタンを押してください。\n\n　ピンクの欄に購入額が表示されます。\n　申告書にも反映されますので、業者に渡すこともできます。"]
[null,null,"変更増額",null,{"$f":"IF(D6=\"\",\"\",申告書!AP25)","v":""}]
[null,null,"合計",{"$f":"IF(D5=\"\",\"\",IF(D5>1000000,SUM(D5:D6),\"１００万以下工事へ\"))","v":""},{"$f":"IF(E6=\"追加購入無し\",E5,IF(D6=\"\",申告書!Z22,IF(D5=\"\",\"\",E5+E6)))","v":""}]
[]
[]
[null,null,"土　木　　　　建退共購入率　（1000分の1）",null,null,null,null,null,"工事種別\n反映欄"]
[]
[null,null,"舗装","橋梁等","隧道","堰堤","浚渫・埋立","その他土木"]
[null,"100万～999万",3.5,3.5,4.5,4.0999999999999996,3.7,4.0999999999999996,4.0999999999999996,"←　種別（率）確認"]
[null,"1000万～4999万",3.3,3.2,3.6,3.8,2.8,3.6,3.6]
[null,"5000万～9999万",2.9,2.8,2.8,3.1,2.7,3.1,3.1]
[null,"1億～4億9999万",2.2999999999999998,2.1,2.1,2.5,1.9,2.2999999999999998,2.2999999999999998]
[null,"5億以上",1.7,1.6,1.9,1.8,1.7,1.8,1.8]
[]
[null,null,"建築　　建退共購入率　（1000分の1）"]
[null,null,"建　　築",null,"設　　備"]
[null,null,"住 宅・同設備","非住宅・同設備","屋外の電気等","機械器具設置",null,"★　　100万円以下の工事の場合　　★"]
[null,"100万～999万",4.8,3.2,2.9,2.2000000000000002,null,null,"金額欄","証紙購入額"]
[null,"1000万～4999万",2.9,3,2.1,1.7,null,"当初契約額",{"$f":"IF(D5=\"\",\"\",D5)","v":""},{"$f":"IF(D5=\"\",\"\",310*ROUNDUP(I23*I13/310,-3)/1000)","v":""}]
[null,"5000万～9999万",2.7,2.5,1.8,1.4,null,"変更増額",{"$f":"IF(D6=\"\",\"\",D6)","v":""},{"$f":"IF(D5=\"\",\"\",J25-J23)","v":""}]
[null,"1億～4億9999万",2.2000000000000002,2.1,1.4,1.1000000000000001,null,"合計",{"$f":"IF(I23=\"\",\"\",SUM(I23:I24))","v":""},{"$f":"IF(I23=\"\",\"\",310*ROUNDUP(I25*I13/310,-3)/1000)","v":""}]
[null,"5億以上",2,1.8,1.1000000000000001,1.1000000000000001]

{"sheet":"申告書","index":1,"n_rows":72,"n_cols":68,"rows_kept":72,"cut":false,"hidden":false,"merged":[[31,27,31,40],[31,41,31,54],[24,13,24,26],[24,27,24,40],[24,41,24,54],[30,13,30,26],[30,27,30,40],[30,41,30,54],[31,13,31,26],[23,13,23,26],[23,27,23,40],[23,41,23,54],[26,3,26,4],[28,9,28,17],[28,18,28,24],[28,25,28,31],[28,32,28,48],[27,9,27,48],[20,9,20,48],[21,25,21,48],[17,1,17,2],[17,4,17,5],[19,3,19,4],[21,9,21,17],[21,18,21,24],[13,1,13,2],[13,4,13,5],[14,8,14,56],[15,34,15,56],[15,8,15,24],[15,25,15,33],[0,0,0,58],[4,2,4,20],[8,22,8,31],[9,22,9,31],[10,22,10,31],[8,33,8,58],[9,33,9,58],[10,33,10,58],[40,0,40,58],[42,3,43,58],[44,3,45,58],[46,3,49,58],[41,2,41,58],[42,1,42,2],[44,1,44,2],[46,1,46,2]]}
["建退共証紙購入（当初・変更）申告書"]
[]
[null,"（発注者）"]
[null,"大分県別府土木事務所長"]
[null,null,"　伊　藤　　義　明",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"殿"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（受注者）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"商号または名称"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者氏名"]
[]
[]
[null,null,null,null,1]
[null,null,null,null,null,null,null,null,"労働者延べ就労者数　×　３１０円　＝　所要額（掛金収納書金額と一致)"]
[]
[]
[null,"レ",null,null,2]
[]
[null,null,null,"レ",null,"（１）労働者の建退共加入率が把握できない場合"]
[null,null,null,null,null,null,null,null,null,"総工事費　×　基本率　＝　所要額（掛金収納書金額と一致）"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(入力!D5=\"\",\"\",入力!D7)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(J22=\"\",\"\",BJ35)","v":""},null,null,null,null,null,null,{"$f":"IF(J22=\"\",\"\",BJ43)","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,"当初工事費",{"$f":"入力!D5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力!D6=\"\",\"\",IF(J22=\"\",\"\",IF(BL24=\"\",\"\",BL60)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力!D6=\"\",\"\",IF(入力!D5=\"\",\"\",IF(BL24=\"\",\"\",BL72)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力!D6=\"\",\"\",IF(N25-AB25<=0,\"追加購入無し\",IF(入力!D6=\"\",\"\",IF(入力!D5=\"\",\"\",IF(BL24=\"\",\"\",N25-AB25)))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変更増額",{"$f":"入力!D6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BL24=\"\",\"\",SUM(BL24:BL25))","v":0}]
[null,null,null,null,null,"（２）労働者の建退共加入率が把握できる場合"]
[null,null,null,null,null,null,null,null,null,"総工事費　×　基本率　×　補正率　＝　所要額（掛金収納金額と一致）"]
[null,null,null,null,null,null,null,null,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(J29=\"\",\"\",BP29*310)","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,{"$f":"J29*S29*Z29/1000","v":0},{"$f":"ROUNDUP(BO29/310,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"変更後所要額（Ａ）",null,null,null,null,null,null,null,null,null,null,null,null,null,"当初所要額（Ｂ）",null,null,null,null,null,null,null,null,null,null,null,null,null,"追加購入額（Ａ）－（Ｂ）"]
[]
[]
[null,null,"※　参考"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MAX(BJ36:BJ40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"入力!I13","v":4.0999999999999996},{"$f":"IF(AND(J22<9999000,J22>=1000000),BI36,\"\")","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,{"$f":"入力!I14","v":3.6},{"$f":"IF(AND(J22<49999000,J22>=10000000),BI37,\"\")","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,{"$f":"入力!I15","v":3.1},{"$f":"IF(AND(J22<99999000,J22>=50000000),BI38,\"\")","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,{"$f":"入力!I16","v":2.2999999999999998},{"$f":"IF(AND(J22<499999000,J22>=100000000),BI39,\"\")","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,{"$f":"入力!I17","v":1.8},{"$f":"IF(BL24>=5000000000,BI40,\"\")","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,{"$f":"J22*BJ35/1000","v":{"$error":"#VALUE!"}}]
["　",null,"上記の１・２いずれかを選択し（□チェック）所要額を算定し、掛金収納書と併せて申告して下さい。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUNDUP(BJ41/310,0)","v":{"$error":"#VALUE!"}}]
[null,"・",null,"１を選択した場合は、建設現場ごとの対象労働者数及び当該労働者の就労日数を的確に把握し、必要な枚数を購入して下さい。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BJ42*310","v":{"$error":"#VALUE!"}}]
[]
[null,"・",null,"２を選択した場合は、労働者延べ就労者数の的確な把握が困難である等の場合で、対象工事における労働者の加入率把握の可否により（１）・（２）の区分で選択し、必要な枚数を購入して下さい。"]
[]
[null,"・",null,"　なお、上記の基本率とは「共済証紙購入の考え方について」に定める総工事ごとの率をいい、\n　補正率とは「対象工事における労働者の加入率（％）／70％」であり、\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,{"$f":"MAX(BL53:BL57)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BI36","v":4.0999999999999996},{"$f":"IF(AND(BL26<9999000,BL26>=1000000),BK53,\"\")","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,{"$f":"BI37","v":3.6},{"$f":"IF(AND(BL26<49999000,BL26>=10000000),BK54,\"\")","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,3.1,{"$f":"IF(AND(BL26<99999000,BL26>=50000000),BK55,\"\")","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,2.2999999999999998,{"$f":"IF(AND(BL26<499999000,BL26>=100000000),BK56,\"\")","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,1.8,{"$f":"IF(BL26>=5000000000,BK57,\"\")","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,{"$f":"BL26*BL52/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUNDUP(BL58/310,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BL59*310","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MAX(BL65:BL69)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BI36","v":4.0999999999999996},{"$f":"IF(AND(BL24<9999000,BL24>=1000000),BK65,\"\")","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,{"$f":"BI37","v":3.6},{"$f":"IF(AND(BL24<49999000,BL24>=10000000),BK66,\"\")","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,3.1,{"$f":"IF(AND(BL24<99999000,BL24>50000000),BK67,\"\")","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,2.2999999999999998,{"$f":"IF(AND(BL24<499999000,BL24>=100000000),BK68,\"\")","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,1.8,{"$f":"IF(BL24>=5000000000,BK69,\"\")","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,{"$f":"IF(BL24=\"\",\"\",BL24*BL64/1000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUNDUP(BL70/310,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BL71*310","v":0}]