{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["QR","工事請負用","【請求書入力例】"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"QR","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["請求書（表紙）"]
["パラメータ",{"$f":"IF(#REF!=#REF!,\"0\",\"1\")","v":{"$error":"#REF!"}}]
["仕入先CD",{"$f":"IF(D3=\"\",\"0000000\",TEXT(D3,\"0000000\"))","v":{"$error":"#REF!"}},null,{"$f":"#REF!&#REF!&#REF!&#REF!&#REF!&#REF!&#REF!","v":{"$error":"#REF!"}}]
["注文番号",{"$f":"IF(D4=\"\",\"00000000000\",TEXT(D4,\"00000000000\"))","v":{"$error":"#REF!"}},null,{"$f":"#REF! &#REF! &#REF! &#REF! &#REF! &#REF! &#REF! &#REF! &#REF! &#REF! &#REF!","v":{"$error":"#REF!"}}]
["累計出来高",{"$f":"TEXT(#REF!,\"0000000000\")","v":{"$error":"#REF!"}}]
["請求額",{"$f":"TEXT(#REF!,\"0000000000\")","v":{"$error":"#REF!"}}]
["結合",{"$f":"B2&B3&B4&B5&B6","v":{"$error":"#REF!"}}]
["結合",{"$f":"IF(B5=\"0000000000\",\"\",B2&B3&B4&B5&B6)","v":{"$error":"#REF!"}}]

{"sheet":"工事請負用","index":1,"n_rows":48,"n_cols":68,"rows_kept":48,"cut":false,"hidden":false,"merged":[[43,65,46,65],[43,3,46,4],[28,10,28,14],[28,15,28,18],[28,7,28,9],[40,3,40,8],[40,9,40,10],[40,13,40,17],[40,39,40,43],[29,2,31,3],[43,15,46,16],[43,31,46,32],[40,44,40,45],[40,46,40,48],[30,60,30,67],[26,2,28,3],[26,27,26,28],[26,29,26,32],[26,40,27,41],[30,68,31,68],[31,4,31,19],[31,20,31,37],[31,42,31,59],[31,60,31,67],[28,68,29,68],[29,4,29,38],[29,46,29,59],[29,60,29,67],[30,7,30,9],[30,10,30,14],[30,15,30,18],[30,40,31,41],[30,42,30,59],[26,42,29,45],[26,48,26,57],[27,46,27,59],[27,60,27,67],[28,20,28,37],[28,40,29,41],[28,48,28,57],[27,6,27,18],[26,6,26,18],[26,21,26,26],[23,60,23,67],[24,2,24,3],[24,13,24,15],[24,16,24,17],[24,20,24,37],[24,40,25,41],[24,48,24,57],[21,2,21,68],[22,2,22,38],[22,40,23,41],[22,42,25,45],[22,48,22,57],[22,68,23,68],[23,2,23,3],[23,6,23,18],[23,20,23,37],[23,47,23,58],[24,68,25,68],[25,2,25,3],[25,6,25,18],[25,20,25,37],[25,52,25,53],[25,60,25,67],[17,50,17,66],[19,3,19,9],[19,13,19,15],[19,16,19,18],[19,19,19,21],[19,46,19,47],[15,62,15,66],[16,3,16,9],[16,13,16,36],[16,43,16,49],[16,50,16,54],[16,55,16,61],[16,62,16,66],[6,43,7,66],[7,67,7,68],[8,3,9,24],[8,43,8,64],[9,27,9,33],[9,43,9,64],[14,3,14,9],[14,13,14,36],[15,3,15,9],[15,43,15,49],[15,50,15,55],[15,56,15,61],[10,43,10,46],[10,47,10,66],[11,43,11,46],[11,47,11,66],[12,3,12,9],[12,13,12,36],[12,43,12,58],[12,59,12,60],[12,61,12,66],[0,55,0,61],[1,0,1,69],[3,46,3,49],[3,51,3,53],[3,54,3,56],[5,43,5,45],[5,46,5,49],[5,51,5,55],[3,2,3,6],[3,7,3,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AU4&AY4&AZ4&BC4&BF4&BJ4&BM4&N20&Q20&T20&W20&Z20&AC20&AF20&AI20&AL20&AO20&AR20&BI32","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,{"$f":"+BI32","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,null,null,null,"電　話"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"担当者"]
[null,null,null,"工事名",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"金融機関：",null,null,null,null,null,null,null,null,null,null,null,null,"店名："]
[null,null,null,"工事場所",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"預金種別：",null,null,null,null,null,null,"当座",null,null,null,null,"口座番号："]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"口座名義："]
[]
[null,null,null,"発注番号"]
[]
[null,null,"今　　回　　請　　求　　額　　算　　定　　内　　訳"]
[null,null,"上 記 契 約 コ ー ド の 契 約 累 計 金 額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",null,"前回\nまで\n累計",null,null,null,null,null,"請求額（税抜）"]
[null,null,"A",null,null,null,"工事価格",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（前回のDの欄を転記）"]
[null,null,"B",null,null,null,"消費税等",null,null,null,"(A×",null,null,10,null,null,"％",null,")",null,{"$f":"ROUND(U24*10/100,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",null,null,null,null,null,null,null,"消費税額等"]
[null,null,"C",null,null,null,"契約額 ( A + B )",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(U24+U25),\"\",U24+U25)","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,"（E×",null,10,null,"％）",null,null,null,null,null,{"$f":"ROUND(BI24*10/100,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,"G",null,"今回",null,null,null,null,null,"請求額（税抜）"]
[null,null,null,null,null,null,"累計出来高(税抜)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D　-　E",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U29-BI24","v":0}]
[null,null,null,null,null,null,"Ａ","×",null,null,null,null,null,null,null,"％",null,null,null,null,{"$f":"TRUNC(U24*K29/100)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",null,null,null,null,null,null,null,"消費税額等"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（出来高払はG×Bの税率）",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(BI28*10/100,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,"I",null,"今　回　税　込　請　求　額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G　+　H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BI28+BI30","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"指定請求書　2023年8月1日作成"]

{"sheet":"【請求書入力例】","index":2,"n_rows":48,"n_cols":68,"rows_kept":48,"cut":false,"hidden":false,"merged":[[40,9,40,10],[40,13,40,17],[40,39,40,43],[40,44,40,45],[40,46,40,48],[30,42,30,59],[30,60,30,67],[24,68,25,68],[25,2,25,3],[25,6,25,18],[25,20,25,37],[25,52,25,53],[25,60,25,67],[30,68,31,68],[31,4,31,19],[31,20,31,37],[31,42,31,59],[31,60,31,67],[28,48,28,57],[28,68,29,68],[29,2,31,3],[29,4,29,38],[29,46,29,59],[29,60,29,67],[30,7,30,9],[30,10,30,14],[30,15,30,18],[30,40,31,41],[26,42,29,45],[26,48,26,57],[27,6,27,18],[16,3,16,9],[16,13,16,36],[16,43,16,49],[16,50,16,54],[16,55,16,61],[16,62,16,66],[15,56,15,61],[23,60,23,67],[24,2,24,3],[24,13,24,15],[24,16,24,17],[24,20,24,37],[24,40,25,41],[24,48,24,57],[21,2,21,68],[22,2,22,38],[22,40,23,41],[22,42,25,45],[22,48,22,57],[22,68,23,68],[23,2,23,3],[23,6,23,18],[23,20,23,37],[23,47,23,58],[43,65,46,65],[43,15,46,16],[43,31,46,32],[17,50,17,66],[19,3,19,9],[19,13,19,15],[19,16,19,18],[19,19,19,21],[19,46,19,47],[28,40,29,41],[26,2,28,3],[26,6,26,18],[26,21,26,26],[26,27,26,28],[26,29,26,32],[26,40,27,41],[27,46,27,59],[27,60,27,67],[28,7,28,9],[28,10,28,14],[28,15,28,18],[28,20,28,37],[43,3,46,4],[40,3,40,8],[0,55,0,61],[1,0,1,69],[3,2,3,6],[3,7,3,16],[3,46,3,49],[3,51,3,53],[3,54,3,56],[5,43,5,45],[5,46,5,49],[5,51,5,55],[6,43,7,66],[7,67,7,68],[8,3,9,24],[8,43,8,64],[9,27,9,33],[9,43,9,64],[14,3,14,9],[14,13,14,36],[15,3,15,9],[15,43,15,49],[15,50,15,55],[10,43,10,46],[10,47,10,66],[11,43,11,46],[11,47,11,66],[12,3,12,9],[12,13,12,36],[12,43,12,58],[12,59,12,66],[15,62,15,66]]}
[null,null,"<提出用>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,"年",null,10,"月",31,"日"]
["請　求　書　（工事請負）"]
[{"$f":"AU4&AY4&AZ4&BC4&BF4&BJ4&BM4&N20&Q20&T20&W20&Z20&AC20&AF20&AI20&AL20&AO20&AR20&BI32","v":"11110"},null,"フクダハウジング株式会社　御 中"]
[null,null,"担当者",null,null,null,null,"〇〇",null,null,null,null,null,null,null,null,null,null,null,null,null,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,"1","1",null,null,"1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〒",null,null,123,null,null,null,"-",3210]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+BI32","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,null,null,"代表取締役　〇〇　〇〇"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"電　話",null,null,null,"012-345-6789"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"担当者",null,null,null,"経理部　〇〇"]
[null,null,null,"工事名",null,null,null,null,null,null,null,null,null,"○○様邸新築工事",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"適格請求書発行事業者登録番号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T1234567890123"]
[]
[null,null,null,"工事内容",null,null,null,null,null,null,null,null,null,"木工事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"金融機関：",null,null,null,null,null,null,null,null,null,null,null,null,"店名："]
[null,null,null,"工事場所",null,null,null,null,null,null,null,null,null,"新潟市○○区△△",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"預金種別：",null,null,null,null,null,null,"当座",null,null,null,null,"口座番号："]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"口座名義："]
[]
[null,null,null,"発注番号"]
[]
[null,null,"今　　回　　請　　求　　額　　算　　定　　内　　訳"]
[null,null,"上 記 契 約 コ ー ド の 契 約 累 計 金 額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",null,"前回\nまで\n累計",null,null,null,null,null,"請求額（税抜）"]
[null,null,"A",null,null,null,"工事価格",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（前回のDの欄を転記）"]
[null,null,"B",null,null,null,"消費税等",null,null,null,"(A×",null,null,10,null,null,"％",null,")",null,{"$f":"ROUND(U24*10/100,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",null,null,null,null,null,null,null,"消費税額等"]
[null,null,"C",null,null,null,"契約額 ( A + B )",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(U24+U25),\"\",U24+U25)","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,"（E×",null,10,null,"％）",null,null,null,null,null,{"$f":"ROUND(BI24*10/100,0)","v":0}]
[null,null,"Ｄ",null,null,null,"出来高査定日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,null,null,null,null,null,"年",null,10,null,null,null,"月末",null,null,null,null,null,null,"G",null,"今回",null,null,null,null,null,"請求額（税抜）"]
[null,null,null,null,null,null,"累計出来高(税抜)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D　-　E",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U29-BI24","v":0}]
[null,null,null,null,null,null,"Ａ","×",null,null,null,null,null,null,null,"％",null,null,null,null,{"$f":"TRUNC(U24*K29/100)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",null,null,null,null,null,null,null,"消費税額等"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（出来高払はG×Bの税率）",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(BI28*10/100,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,"I",null,"今　回　税　込　請　求　額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G　+　H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BI28+BI30","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"指定請求書　2023年8月1日作成"]