{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["記入例","請求書","2ページ目以降"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":46,"n_cols":65,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,1,20],[1,21,1,25],[1,26,1,29],[1,30,1,34],[3,10,3,14],[3,16,3,20],[3,21,3,22],[3,23,3,26],[3,27,3,28],[3,29,3,32],[9,10,9,34],[10,0,10,2],[10,3,10,7],[10,10,10,34],[12,0,12,1],[12,2,12,8],[12,10,12,32],[3,33,3,34],[5,0,5,6],[6,10,6,28],[6,29,6,34],[7,11,7,34],[8,11,8,34],[18,1,18,8],[18,9,18,10],[18,11,18,21],[18,22,18,34],[19,1,19,7],[19,11,19,21],[19,22,19,34],[13,0,14,1],[13,2,14,8],[13,10,13,15],[13,16,13,32],[14,10,14,15],[14,16,14,32],[22,1,22,7],[22,11,22,21],[22,22,22,34],[23,1,23,7],[23,11,23,21],[23,22,23,34],[20,1,20,7],[20,11,20,21],[20,22,20,34],[21,1,21,7],[21,11,21,21],[21,22,21,34],[24,1,24,7],[24,11,24,21],[24,22,24,34],[25,0,25,21],[25,22,25,34],[27,1,27,3],[27,4,27,7],[27,8,27,10],[27,11,27,21],[27,22,27,34],[30,4,30,7],[30,8,30,10],[30,11,30,21],[30,22,30,34],[31,4,31,7],[31,8,31,10],[31,11,31,21],[31,22,31,34],[28,4,28,7],[28,8,28,10],[28,11,28,21],[28,22,28,34],[29,4,29,7],[29,8,29,10],[29,11,29,21],[29,22,29,34],[41,2,41,7],[41,8,41,10],[41,11,41,22],[41,23,41,34],[42,2,42,7],[42,8,42,10],[42,11,42,22],[42,23,42,34],[35,2,38,3],[35,5,35,6],[35,11,37,18],[35,19,37,26],[35,27,37,34],[37,5,37,6],[37,7,37,9],[45,2,45,7],[45,8,45,10],[45,11,45,22],[45,23,45,34],[43,2,43,7],[43,8,43,10],[43,11,43,22],[43,23,43,34],[44,2,44,7],[44,8,44,10],[44,11,44,22],[44,23,44,34]]}
["御　請　求　書"]
[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,1]
[]
[null,null,null,null,null,null,null,null,null,null,"請求日",null,null,null,null,"：","0000",null,null,null,null,"年",null,"00",null,null,null,"月",null,"00",null,null,null,"日"]
[]
["大道産業株式会社 御中 "]
[null,null,null,null,null,null,null,null,null,"会社名","〇〇〇〇株式会社"]
[null,null,null,null,null,null,null,null,null,"登録番号","T","0000000000000"]
[null,null,null,null,null,null,null,null,null,"住所","〒","000-0000"]
[null,null,null,null,null,null,null,null,null,null,"○○県○○市○○区○○00-00-00○○ビル"]
["請求金額合計",null,null,{"$f":"W32","v":684000},null,null,null,null,null,"電話番号","00-0000-0000"]
[]
["工事件名",null,"令和00年 〇〇〇〇工事",null,null,null,null,null,null,null,"発注担当者"]
["施工場所",null,"○○県○○市○○区○○",null,null,null,null,null,null,null,"部署",null,null,null,null,null,"東京支店"]
[null,null,null,null,null,null,null,null,null,null,"氏名",null,null,null,null,null,"大道　太郎"]
[]
[null,null,null,null,null,null,null,null,"「※」","は軽減税率対象、「非」は消費税非課税"]
[]
["日付","項目",null,null,null,null,null,null,null,"数量",null,"単価",null,null,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/0","〇〇",null,null,null,null,null,null,null,50,"㎥",4000,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J20=\"\",\"\",J20*L20)","v":200000},null,null,null,null,null,null,null,null,null,null,null,null,null,"数量単位","区画",null,null,"式","組","人","ｍ","㎡","㎥","㎝","ｔ","㎏","㍑","缶","ｾｯﾄ","巻","個","本","箱","ｹｰｽ","枚","台","基","文字","箇所","か所","日","個口"]
["0/0","△△",null,null,null,null,null,null,"※",100,"個",500,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J21=\"\",\"\",J21*L21)","v":50000}]
["0/0","□□",null,null,null,null,null,null,"非",10,"区画",30000,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J22=\"\",\"\",J22*L22)","v":300000}]
["0/0","◇◇",null,null,null,null,null,null,null,1,"式",100000,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J23=\"\",\"\",J23*L23)","v":100000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J24=\"\",\"\",J24*L24)","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,{"$f":"SUM(W20:AI25)","v":650000}]
[]
[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,{"$f":"SUMIF(I20:I25,\"\",W20:W25)","v":300000},null,null,{"$f":"ROUNDDOWN(I29*10%,0)","v":30000},null,null,null,null,null,null,null,null,null,null,{"$f":"+I29+L29","v":330000}]
[null,null,null,null,"08％課税対象合計",null,null,null,{"$f":"SUMIF(I20:I25,\"※\",W20:W25)","v":50000},null,null,{"$f":"ROUNDDOWN(I30*8%,0)","v":4000},null,null,null,null,null,null,null,null,null,null,{"$f":"+I30+L30","v":54000}]
[null,null,null,null,"非課税合計",null,null,null,{"$f":"SUMIF(I20:I25,\"非\",W20:W25)","v":300000},null,null,"―",null,null,null,null,null,null,null,null,null,null,{"$f":"+I31","v":300000}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I29:K31)","v":650000},null,null,{"$f":"SUM(L29:V31)","v":34000},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W29:AI31)","v":684000}]
[]
["大道産業社内処理欄"]
[null,null,"受付印",null,null,null,null,null,null,null,null,"社内確認"]
[null,null,null,null,null,"工事番号",null,null,"―"]
[]
[null,null,null,null,null,"処理区分"]
[]
[]
[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,"消費税08％課税対象"]
[null,null,"非課税相当対象"]

{"sheet":"請求書","index":1,"n_rows":46,"n_cols":65,"rows_kept":46,"cut":false,"hidden":false,"merged":[[24,1,24,7],[24,11,24,21],[41,11,41,22],[41,23,41,34],[42,2,42,7],[42,8,42,10],[42,11,42,22],[42,23,42,34],[41,2,41,7],[41,8,41,10],[35,2,38,3],[35,5,35,6],[27,8,27,10],[29,4,29,7],[29,8,29,10],[27,11,27,21],[27,22,27,34],[37,5,37,6],[37,7,37,9],[30,4,30,7],[30,8,30,10],[30,11,30,21],[30,22,30,34],[31,4,31,7],[31,8,31,10],[31,11,31,21],[31,22,31,34],[28,4,28,7],[28,8,28,10],[28,11,28,21],[28,22,28,34],[29,11,29,21],[45,11,45,22],[45,23,45,34],[43,2,43,7],[43,8,43,10],[43,11,43,22],[43,23,43,34],[44,2,44,7],[44,8,44,10],[44,11,44,22],[44,23,44,34],[45,2,45,7],[45,8,45,10],[29,22,29,34],[5,0,5,6],[19,1,19,7],[19,11,19,21],[9,10,9,34],[10,10,10,34],[12,0,12,1],[12,2,12,8],[12,10,12,32],[13,0,14,1],[13,2,14,8],[13,10,13,15],[13,16,13,32],[14,10,14,15],[10,0,10,2],[10,3,10,7],[19,22,19,34],[0,0,1,20],[1,21,1,25],[1,26,1,29],[1,30,1,34],[3,10,3,14],[3,16,3,34],[8,11,8,34],[14,16,14,32],[6,10,6,28],[6,29,6,34],[7,11,7,34],[18,1,18,8],[35,11,37,18],[35,19,37,26],[35,27,37,34],[18,9,18,10],[18,11,18,21],[18,22,18,34],[24,22,24,34],[25,0,25,21],[25,22,25,34],[27,1,27,3],[27,4,27,7],[22,1,22,7],[22,11,22,21],[22,22,22,34],[23,1,23,7],[23,11,23,21],[23,22,23,34],[20,1,20,7],[20,11,20,21],[20,22,20,34],[21,1,21,7],[21,11,21,21],[21,22,21,34]]}
["御　請　求　書"]
[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,1,null,null,null,null,null,"ver　1.0.6","・日付の入力欄をまとめる"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・消費税欄を手入力可能に"]
["未記入（黄色セル）の項目があります",null,null,null,null,null,null,null,null,null,"請求日",null,null,null,null,"：",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"W32","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,{"$f":"J20*L20","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,{"$f":"J21*L21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J22*L22","v":0}]
[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,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J25*L25","v":0}]
["税抜請求金額合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W20:AI25)","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,"10％課税対象合計",null,null,null,{"$f":"SUMIF(I20:I25,\"\",W20:W25)","v":0},null,null,{"$f":"ROUNDDOWN(I29*10%,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"+I29+L29","v":0}]
[null,null,null,null,"08％課税対象合計",null,null,null,{"$f":"SUMIF(I20:I25,\"※\",W20:W25)","v":0},null,null,{"$f":"ROUNDDOWN(I30*8%,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"+I30+L30","v":0}]
[null,null,null,null,"非課税合計",null,null,null,{"$f":"SUMIF(I20:I25,\"非\",W20:W25)","v":0},null,null,"―",null,null,null,null,null,null,null,null,null,null,{"$f":"+I31","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I29:K31)","v":0},null,null,{"$f":"SUM(L29:V31)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W29:AI31)","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,"消費税10％課税対象"]
[null,null,"消費税08％課税対象"]
[null,null,"非課税相当対象"]

{"sheet":"2ページ目以降","index":2,"n_rows":46,"n_cols":31,"rows_kept":46,"cut":false,"hidden":true,"merged":[[43,1,43,7],[43,11,43,21],[43,22,43,34],[42,1,42,7],[42,11,42,21],[42,22,42,34],[44,0,44,21],[44,22,44,34],[45,0,45,21],[45,22,45,34],[41,1,41,7],[41,11,41,21],[41,22,41,34],[40,1,40,7],[40,11,40,21],[40,22,40,34],[39,1,39,7],[39,11,39,21],[39,22,39,34],[38,1,38,7],[38,11,38,21],[38,22,38,34],[37,1,37,7],[37,11,37,21],[37,22,37,34],[36,1,36,7],[36,11,36,21],[36,22,36,34],[35,1,35,7],[35,11,35,21],[35,22,35,34],[34,1,34,7],[34,11,34,21],[34,22,34,34],[33,1,33,7],[33,11,33,21],[33,22,33,34],[32,1,32,7],[32,11,32,21],[32,22,32,34],[31,1,31,7],[31,11,31,21],[31,22,31,34],[30,1,30,7],[30,11,30,21],[30,22,30,34],[29,1,29,7],[29,11,29,21],[29,22,29,34],[28,1,28,7],[28,11,28,21],[28,22,28,34],[27,1,27,7],[27,11,27,21],[27,22,27,34],[26,1,26,7],[26,11,26,21],[26,22,26,34],[25,1,25,7],[25,11,25,21],[25,22,25,34],[24,1,24,7],[24,11,24,21],[24,22,24,34],[23,1,23,7],[23,11,23,21],[23,22,23,34],[22,1,22,7],[22,11,22,21],[22,22,22,34],[21,1,21,7],[21,11,21,21],[21,22,21,34],[20,1,20,7],[20,11,20,21],[20,22,20,34],[19,1,19,7],[19,11,19,21],[19,22,19,34],[18,1,18,8],[18,9,18,10],[18,11,18,21],[18,22,18,34],[14,10,14,15],[14,16,14,32],[13,0,14,1],[13,2,14,8],[13,10,13,15],[13,16,13,32],[12,0,12,1],[12,2,12,8],[12,10,12,32],[0,0,1,20],[1,21,1,25],[1,26,1,29],[1,30,1,34],[10,10,10,34],[8,11,8,34],[9,10,9,34],[7,11,7,34],[6,10,6,28],[6,29,6,34],[5,0,5,6],[3,10,3,14],[3,16,3,34]]}
["御　請　求　書"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A45","v":0},null,null,null,null,"／",null,null,null,{"$f":"請求書!$AE$2","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,"請求日",null,null,null,null,"：",{"$f":"+請求書!$Q$4","v":"00:00:00"}]
[]
[{"$f":"請求書!$A$6","v":"大道産業株式会社 御中 "}]
[null,null,null,null,null,null,null,null,null,"会社名",{"$f":"IF(請求書!$K$7=0,\"\",請求書!$K$7)","v":""}]
[null,null,null,null,null,null,null,null,null,"登録番号","T",{"$f":"IF(請求書!$L$8=0,\"\",請求書!$L$8)","v":""}]
[null,null,null,null,null,null,null,null,null,"住所","〒",{"$f":"IF(請求書!$L$9=0,\"\",請求書!$L$9)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(請求書!$K$10=0,\"\",請求書!$K$10)","v":""}]
[null,null,null,null,null,null,null,null,null,"電話番号",{"$f":"IF(請求書!$K$11=0,\"\",請求書!$K$11)","v":""}]
[]
["工事件名",null,{"$f":"IF(請求書!$C$13=0,\"\",請求書!$C$13)","v":""},null,null,null,null,null,null,null,"発注担当者"]
["施工場所",null,{"$f":"IF(請求書!$C$14=0,\"\",請求書!$C$14)","v":""},null,null,null,null,null,null,null,"部署",null,null,null,null,null,{"$f":"IF(請求書!$Q$14=0,\"\",請求書!$Q$14)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"氏名",null,null,null,null,null,{"$f":"IF(請求書!$Q$15=0,\"\",請求書!$Q$15)","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,{"$f":"J20*L20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J21*L21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J22*L22","v":0}]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W20:AI44)","v":0}]
["税抜請求金額合計"]