{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["説明シート (新書式) ","入力シート"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":40,"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":43,"n_cols":52,"rows_kept":43,"cut":false,"hidden":false,"merged":[[25,50,25,56],[23,50,23,56],[24,1,24,3],[24,4,24,26],[24,29,24,35],[24,36,24,42],[24,43,24,49],[24,50,24,56],[23,1,23,3],[23,4,23,13],[23,14,23,17],[23,18,23,26],[23,29,23,35],[23,36,23,42],[23,43,23,49],[32,1,34,13],[32,16,34,36],[25,1,25,3],[25,4,25,26],[25,29,25,35],[25,36,25,42],[25,43,25,49],[21,1,21,26],[21,29,21,35],[21,36,21,42],[21,43,21,49],[21,50,21,56],[22,1,22,3],[22,4,22,13],[22,14,22,17],[22,18,22,26],[22,29,22,35],[22,36,22,42],[22,43,22,49],[22,50,22,56],[17,29,17,32],[17,33,17,35],[17,36,17,42],[17,43,17,49],[17,50,17,56],[18,29,18,35],[18,36,18,42],[18,43,18,49],[18,50,18,56],[15,43,15,49],[15,50,15,56],[16,1,16,5],[16,6,16,21],[16,29,16,35],[16,36,16,42],[16,43,16,49],[16,50,16,56],[14,23,14,28],[14,29,14,35],[14,36,14,42],[14,43,14,49],[14,50,14,56],[15,1,15,5],[15,6,15,21],[15,23,15,28],[15,29,15,35],[15,36,15,42],[12,43,12,49],[12,50,12,56],[13,1,13,5],[13,6,13,21],[13,23,13,28],[13,29,13,35],[13,36,13,42],[13,43,13,49],[13,50,13,56],[9,1,9,5],[9,6,9,21],[9,23,9,28],[9,29,9,35],[9,36,9,42],[9,43,9,49],[9,50,9,56],[10,50,10,56],[11,1,12,5],[11,6,12,21],[11,23,11,28],[11,29,11,35],[11,36,11,42],[11,43,11,49],[11,50,11,56],[12,23,12,28],[12,29,12,35],[10,1,10,5],[10,6,10,21],[10,23,10,28],[10,29,10,35],[10,36,10,42],[10,43,10,49],[12,36,12,42],[8,1,8,5],[8,6,8,21],[8,23,8,26],[8,27,8,32],[8,33,8,36],[8,37,8,44],[8,45,8,46],[8,47,8,50],[8,51,8,56],[1,4,1,11],[2,4,2,11],[2,48,2,50],[2,51,2,56],[4,1,4,5],[4,6,4,21],[4,23,5,26],[4,27,5,56],[5,1,5,5],[5,6,7,21],[6,1,7,5],[6,23,7,26],[6,27,7,50],[6,51,7,51]]}
[]
[null,null,null,null,"←入力箇所"]
[null,null,null,null,"←計算式設定箇所"]
[]
[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-9-4-101"]
[null,"工事（物件）コード",null,null,null,null,"注文書・請書を交わしている場合は　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　「項番２．工事名称」に記載している内容等\nその他の場合は担当部署名を記載　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　"]
[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,null,null,"項目",null,null,null,null,null,"契約金額",null,null,null,null,null,null,"既請求金額",null,null,null,null,null,null," 今回請求額",null,null,null,null,null,null,"残金額"]
[null,"請求書番号",null,null,null,null,"（任意項目）請求書の発行管理番号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"契約金額",null,null,null,null,null,5000000,null,null,null,null,null,null,4000000,null,null,null,null,null,null,1000000,null,null,null,null,null,null,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,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,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,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,"支払サイト",null,null,null,null,"当社との取極支払サイト",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G17<>\"課税仕入５％内税\",\"税抜計\",\"税込計\")","v":"税抜計"},null,null,null,null,null,5000000,null,null,null,null,null,null,4000000,null,null,null,null,null,null,1000000,null,null,null,null,null,null,0]
[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($G$17<>\"課税仕入５％内税\",\"消費税等\",\"仕入控除税額\")","v":"消費税等"},null,null,null,null,null,500000,null,null,null,null,null,null,400000,null,null,null,null,null,null,100000,null,null,null,null,null,null,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,5500000,null,null,null,null,null,null,4400000,null,null,null,null,null,null,1100000,null,null,null,null,null,null,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,0.1,null,null,440000,null,null,null,null,null,null,110000,null,null,null,null,null,null,550000]
[null,null,null,null,null,null,null,null,null,null,null,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(AY16=0,AY18,0)","v":550000},null,null,null,null,null,null,"今回支払金額",null,null,null,null,null,null,{"$f":"AR16-AR18+AK19","v":1540000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※１．預り保留金は最終請求の支払に合わせてお支払いたします。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[今回請求額明細]　※適用税率毎に記載をお願い致します。"]
[null,"振　込　先　※振込先の手書き修正は不可といたします。再度発行してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"消費税区分",null,null,null,null,null,null,"税抜",null,null,null,null,null,null,"消費税等",null,null,null,null,null,null,"税込"]
[null,"金融機関",null,null,null,null,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,null,1000000,null,null,null,null,null,null,100000,null,null,null,null,null,null,1100000]
[null,"預金種別",null,null,null,null,null,null,null,null,null,null,null,null,"口座番号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8%対象"]
[null,"口座名義　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　（漢字）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"対象外"]
[null,"口座名義　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　（カナ）",null,null,null,null,null,null,null,null,null,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":"SUM(AK23:AQ25)","v":1000000},null,null,null,null,null,null,{"$f":"SUM(AR23:AX25)","v":100000},null,null,null,null,null,null,{"$f":"SUM(AY23:BE25)","v":1100000}]
[]
[]
[]
[]
[]
[]
[null,"既請求金額欄が更新され　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　今回請求金額欄が消去されます。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"請求書を４枚印刷します。\n社印は②と④に押印、②～④の担当者欄へ押印して\n②～④の３部を当社へ提出してください。"]
[]
[]
[]
[null,"※マクロ未使用版の場合は、上記のボタンは機能しません。"]
[]
[null,null,"（１）既請求金額欄は、手動で計算し入力してください。"]
[]
[null,null,"（２）印刷は、①～④を手動で出力してください。"]
[]
[null,null,"（３）入力チェック機能も外してあるので、印刷前に必須項目のチェックをしてください。"]

{"sheet":"入力シート","index":1,"n_rows":26,"n_cols":81,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,50,25,56],[23,50,23,56],[24,1,24,3],[24,4,24,26],[24,29,24,35],[24,36,24,42],[24,43,24,49],[24,50,24,56],[23,1,23,3],[23,4,23,13],[23,14,23,17],[23,18,23,26],[23,29,23,35],[23,36,23,42],[23,43,23,49],[25,1,25,3],[25,4,25,26],[25,29,25,35],[25,36,25,42],[25,43,25,49],[21,1,21,26],[21,29,21,35],[21,36,21,42],[21,43,21,49],[21,50,21,56],[22,1,22,3],[22,4,22,13],[22,14,22,17],[22,18,22,26],[22,29,22,35],[22,36,22,42],[22,43,22,49],[22,50,22,56],[17,29,17,32],[17,33,17,35],[17,36,17,42],[17,43,17,49],[17,50,17,56],[18,29,18,35],[18,36,18,42],[18,43,18,49],[18,50,18,56],[16,6,16,13],[16,18,16,21],[16,29,16,35],[16,36,16,42],[16,43,16,49],[16,50,16,56],[15,6,15,7],[15,23,15,28],[15,29,15,35],[15,36,15,42],[15,43,15,49],[15,50,15,56],[13,50,13,56],[14,23,14,28],[14,29,14,35],[14,36,14,42],[14,43,14,49],[14,50,14,56],[13,1,13,5],[13,6,13,7],[13,23,13,28],[13,29,13,35],[13,36,13,42],[13,43,13,49],[11,50,11,56],[12,23,12,28],[12,29,12,35],[12,36,12,42],[12,43,12,49],[12,50,12,56],[11,1,12,5],[11,6,12,21],[11,23,11,28],[11,29,11,35],[11,36,11,42],[11,43,11,49],[9,50,9,56],[10,1,10,5],[10,6,10,21],[10,23,10,28],[10,29,10,35],[10,36,10,42],[10,43,10,49],[10,50,10,56],[8,40,8,44],[8,45,8,46],[8,47,8,50],[8,51,8,56],[9,1,9,5],[9,6,9,21],[9,23,9,28],[9,29,9,35],[9,36,9,42],[9,43,9,49],[6,1,7,5],[6,6,7,21],[6,23,7,26],[6,27,7,50],[6,51,7,51],[8,1,8,5],[8,6,8,21],[8,23,8,26],[8,27,8,35],[8,36,8,39],[2,48,2,50],[2,51,2,56],[4,1,4,5],[4,6,4,8],[4,10,4,11],[4,23,5,26],[4,27,5,56],[5,1,5,5],[5,6,5,21]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"課税仕入５％外税",0.05]
[null,"請求年月",null,null,null,null,null,null,null,"年",null,null,"月分",null,null,null,null,null,null,null,null,null,null,"住所",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"課税仕入８％外税",0.08]
[null,"工事(物件)コード",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"非課税",0]
[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,"対象外",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,"消費税差額",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"契約金額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-500000,{"$f":"SUM(BK11:BL11)","v":-500000}]
[null,"請求内容",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変更増額",null,null,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":"AD12-AK12-AR12","v":0},null,null,null,null,null,null,null,null,null,null,null,0,null,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,0,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD13-AK13-AR13","v":0},null,null,null,null,null,null,null,null,null,null,null,0,null,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,{"$f":"SUM(AD11:AH13)","v":0},null,null,null,null,null,null,{"$f":"SUM(AK11:AO13)","v":0},null,null,null,null,null,null,{"$f":"SUM(AR11:AV13)","v":0},null,null,null,null,null,null,{"$f":"IF(AD14=0,0,AD14-AK14-AR14)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,-500000,-500000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AR26","v":0},null,null,null,null,null,null,{"$f":"IF(AD15=0,0,AD15-AK15-AR15)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,-50000,-50000]
[null,null,null,null,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":"SUM(AD14:AI15)","v":0},null,null,null,null,null,null,{"$f":"SUM(AK14:AP15)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD16=0,0,AD16-AK16-AR16)","v":0},null,null,null,null,null,null,null,null,null,null,null,0,-550000,-550000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※１　預り保留金",null,null,null,null,null,null,"前回迄の保留金",null,null,null,null,null,null,"今回保留金",null,null,null,null,null,null,"預り保留金累計",null,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(ISERROR(VLOOKUP($G$17,課税区分リスト,2,FALSE))=TRUE,0,(VLOOKUP($G$17,課税区分リスト,2,FALSE)))","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,{"$f":"IF(AH18=0,0,ROUND(AR16*AH18,0))","v":0},null,null,null,null,null,null,{"$f":"SUM(AK18,AR18)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,-55000,{"$f":"SUM(BK18:BL18)","v":-55000}]
[null,null,null,null,null,null,null,null,null,null,null,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(AY16=0,AY18,0)","v":0},null,null,null,null,null,null,"今回支払金額",null,null,null,null,null,null,{"$f":"AR16-AR18+AK19","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,"保留金解除",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,"前回まで保留金",-55000]
[null,"振　込　先　※振込先の手書き修正は不可といたします。再度発行してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"消費税区分",null,null,null,null,null,null,"税抜",null,null,null,null,null,null,"消費税等",null,null,null,null,null,null,"税込"]
[null,"金融機関",null,null,null,null,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,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(AK23*0.1,0)","v":0},null,null,null,null,null,null,{"$f":"AK23+AR23","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,"8%対象",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(AK24*0.08,0)","v":0},null,null,null,null,null,null,{"$f":"AK24+AR24","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,{"$f":"AK25+AR25","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,{"$f":"SUM(AK23:AQ25)","v":0},null,null,null,null,null,null,{"$f":"SUM(AR23:AX24)","v":0},null,null,null,null,null,null,{"$f":"SUM(AY23:BE25)","v":0}]