{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["請求書(手書き作成用)","請求書(ＰＣ作成用)","請求書(記入例)","出来高調書","内訳書(物品納品)","出面集計表"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":44,"n_cols":49,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,24,3,25],[4,22,6,23],[4,24,6,31],[7,24,8,31],[9,24,9,30],[10,24,10,25],[10,28,10,30],[0,0,0,31],[0,33,0,39],[1,0,2,6],[1,22,2,24],[1,25,2,26],[2,16,2,17],[7,0,8,1],[7,2,7,5],[7,6,7,8],[7,22,8,23],[8,2,8,5],[8,6,8,8],[8,18,8,20],[3,0,3,2],[3,3,3,5],[4,0,5,2],[4,3,5,8],[3,22,3,23],[10,0,10,1],[10,2,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,13],[9,0,9,1],[9,2,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,13],[9,22,9,23],[16,21,16,22],[17,0,19,1],[17,2,19,6],[17,7,19,7],[17,8,19,9],[17,10,19,11],[17,18,19,22],[12,0,12,2],[12,4,14,5],[12,6,14,10],[13,18,14,30],[16,0,16,1],[16,2,16,6],[16,8,16,9],[16,10,16,11],[16,12,16,16],[16,18,16,20],[17,23,19,25],[17,26,19,28],[17,29,19,31],[17,12,19,16],[17,33,18,34],[17,35,18,36],[20,0,22,1],[20,2,22,6],[20,8,22,9],[20,10,22,11],[20,12,22,16],[20,18,22,22],[20,23,22,25],[20,26,22,28],[20,29,22,31],[23,0,25,1],[23,2,25,6],[23,8,25,9],[23,10,25,11],[23,12,25,16],[23,18,25,22],[23,23,25,25],[23,26,25,28],[23,29,25,31],[26,0,28,1],[26,2,28,6],[26,8,28,9],[26,10,28,11],[26,12,28,16],[26,18,28,22],[26,23,28,25],[26,26,28,28],[26,29,28,31],[35,6,36,10],[29,0,31,1],[29,2,31,6],[29,7,31,7],[29,8,31,9],[29,10,31,11],[29,12,31,16],[29,26,31,28],[29,23,31,25],[32,0,33,11],[32,12,33,16],[29,18,31,22],[37,29,37,31],[38,1,38,4],[38,5,38,6],[38,8,38,9],[38,11,38,12],[38,13,38,14],[38,16,38,18],[38,25,38,28],[38,29,38,31],[37,1,37,4],[37,5,37,6],[37,8,37,9],[37,11,37,12],[37,13,37,14],[37,15,37,19],[37,20,37,22],[37,25,37,28],[39,1,39,4],[39,5,39,6],[39,8,39,9],[39,11,39,12],[39,13,39,14],[39,16,39,18],[39,25,39,28],[39,29,39,31],[40,25,40,28],[40,29,40,31],[41,1,41,4],[41,5,41,6],[41,8,41,9],[41,11,41,12],[41,13,41,14],[41,16,41,18],[41,25,41,28],[41,29,41,31],[40,1,40,4],[40,5,40,6],[40,8,40,9],[40,11,40,12],[40,13,40,14],[40,16,40,18],[42,25,42,28],[42,29,42,31],[43,8,43,9],[43,11,43,12],[43,13,43,14],[43,16,43,18],[42,1,42,4],[42,5,42,6],[42,8,42,9],[42,11,42,12],[42,13,42,14],[42,16,42,18]]}
["　請　　求　　書　",null,null,null,null,null,null,null,null,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（TEL 028-658-1609 管理部宛）"]
["小平興業株式会社　御中",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"取引先コード"]
[null,null,null,null,null,null,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枚作成して　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,"平成"]
["工　事　名\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,"未定"]
[]
[]
["振込\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,{"$f":"IF(J11=\"普通\",1,IF(J11=\"当座\",2,\"\"))","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,"1.普通 2.当座",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEL",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,null,null,null,null,null,null,null,null,null,null,"円（消費税込）"]
[]
["月日",null,"品 名 ・ 工 種",null,null,null,null,"単位","数量",null,"単価",null,"金　　額",null,null,null,null,null,"注文番号",null,null,null,null,null,"(金額は消費税込)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"契　　約",null,null,null,null,"累計出来高",null,null,"前回迄出来高",null,null,"今回出来高"]
[]
[]
[null,null,null,null,null,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(X21=\"\",AA21=\"\"),\"\",SUM(X21:AC21))","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,{"$f":"IF(AND(X24=\"\",AA24=\"\"),\"\",SUM(X24:AC24))","v":""}]
[]
[]
[null,null,"小　　計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"請求金額",null,null,null,null,{"$f":"IF(X21=\"\",\"\",X21-X24)","v":""},null,null,{"$f":"IF(AND(AA21=\"\",AA24=\"\"),\"\",AA21-AA24)","v":""},null,null,{"$f":"IF(AND(X27=\"\",AA27=\"\"),\"\",SUM(X27:AC27))","v":""},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,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(S21=\"\",\"\",S21-AD27)","v":""}]
[]
[]
["合　　計　"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(N34=#REF!,\"\",\"今回出来高と合わない！！\"))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,"ここから下は、当社記入欄です。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"税区分(税込=0 / 税なし=1)"]
["行","科目コード",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,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,"  .   ."]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  .   ."]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  .   ."]
[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,"計"]

{"sheet":"請求書(ＰＣ作成用)","index":1,"n_rows":44,"n_cols":49,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,33,0,39],[1,0,2,6],[1,22,2,24],[1,25,2,26],[2,16,2,17],[3,0,3,2],[3,3,3,5],[4,0,5,2],[4,3,5,8],[4,22,6,23],[4,24,6,31],[3,24,3,25],[3,22,3,23],[0,0,0,31],[7,24,8,31],[10,0,10,1],[10,2,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,13],[9,0,9,1],[9,2,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,13],[9,22,9,23],[9,24,9,30],[10,24,10,25],[10,28,10,30],[7,0,8,1],[7,2,7,5],[7,6,7,8],[7,22,8,23],[8,2,8,5],[8,6,8,8],[8,18,8,20],[16,21,16,22],[17,0,19,1],[17,2,19,6],[17,7,19,7],[17,8,19,9],[17,10,19,11],[17,12,19,16],[17,18,19,22],[12,0,12,2],[12,4,14,5],[12,6,14,10],[13,18,14,30],[16,0,16,1],[16,2,16,6],[16,8,16,9],[16,10,16,11],[16,12,16,16],[16,18,16,20],[17,23,19,25],[17,26,19,28],[17,29,19,31],[17,35,18,36],[20,0,22,1],[20,2,22,6],[20,8,22,9],[20,10,22,11],[20,12,22,16],[20,18,22,22],[20,26,22,28],[20,23,22,25],[20,29,22,31],[23,0,25,1],[23,2,25,6],[23,8,25,9],[23,10,25,11],[23,12,25,16],[23,18,25,22],[23,26,25,28],[23,23,25,25],[17,33,18,34],[23,29,25,31],[20,7,22,7],[23,7,25,7],[26,0,28,1],[26,2,28,6],[26,8,28,9],[26,10,28,11],[26,12,28,16],[26,18,28,22],[26,23,28,25],[26,26,28,28],[26,29,28,31],[35,6,36,10],[29,0,31,1],[29,2,31,6],[29,7,31,7],[29,8,31,9],[29,10,31,11],[29,12,31,16],[29,23,31,25],[32,0,33,11],[32,12,33,16],[29,18,31,22],[38,1,38,4],[38,5,38,6],[38,8,38,9],[38,11,38,12],[38,13,38,14],[38,16,38,18],[38,25,38,28],[38,29,38,31],[37,1,37,4],[37,5,37,6],[37,8,37,9],[37,11,37,12],[37,13,37,14],[37,15,37,19],[37,20,37,22],[37,25,37,28],[37,29,37,31],[40,1,40,4],[40,5,40,6],[40,8,40,9],[40,11,40,12],[40,13,40,14],[40,16,40,18],[39,1,39,4],[39,5,39,6],[39,8,39,9],[39,11,39,12],[39,13,39,14],[39,16,39,18],[42,1,42,4],[42,5,42,6],[42,8,42,9],[42,11,42,12],[42,13,42,14],[42,16,42,18],[41,1,41,4],[41,5,41,6],[41,8,41,9],[41,11,41,12],[41,13,41,14],[41,16,41,18],[42,25,42,28],[42,29,42,31],[43,8,43,9],[43,11,43,12],[43,13,43,14],[43,16,43,18],[41,25,41,28],[41,29,41,31],[39,25,39,28],[39,29,39,31],[40,25,40,28],[40,29,40,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,"取引先コード等が不明の場合はお問い合わせ下さい。\n（TEL 028-658-1609 工務部 宛）"]
["小平興業株式会社　御中",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"取引先コード"]
[null,null,null,null,null,null,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枚印刷し,現場と本社用２枚提出してください"]
["工 事 番 号",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,"住　所"]
[]
[]
["振込\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,{"$f":"IF(J11=\"普通\",1,IF(J11=\"当座\",2,\"\"))","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,"1.普通 2.当座",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEL",null,null,null,"FAX"]
[]
["整理番号",null,null,null,"今回請求額",null,{"$f":"IF(X21=\"\",M33,AD27)","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":"IF(X21=\"\",\"\",X21-AA21)","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,{"$f":"IF(X24=\"\",\"\",X24-AA24)","v":""}]
[]
[]
[null,null,"小　　計",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M18:Q26)","v":0},null,null,null,null,null,"請求金額",null,null,null,null,{"$f":"IF(X21=\"\",\"\",X21-X24)","v":""},null,null,{"$f":"IF(AA21=\"\",\"\",AA21-AA24)","v":""},null,null,{"$f":"IF(X27=\"\",\"\",IF(X24=\"\",AD21,AD21-AD24))","v":""},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,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,8,null,null,{"$f":"ROUND(M27*I30/100,0)","v":0},null,null,null,null,null,"契約残高",null,null,null,null,{"$f":"IF(S21=\"\",\"\",IF(ISERROR(S21-AD27),\"\",S21-X27))","v":""}]
[]
[]
["合　　計　",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M27+M30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(N34=#REF!,\"\",\"今回出来高と合わない！！\"))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,"ここから下は、当社記入欄です。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"税区分(税込=0 / 税なし=1)"]
["行","科目コード",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,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,"  .   ."]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  .   ."]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  .   ."]
[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,"計"]

{"sheet":"請求書(記入例)","index":2,"n_rows":44,"n_cols":49,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,5,41,6],[20,29,22,31],[23,29,25,31],[40,29,40,31],[41,29,41,31],[37,29,37,31],[38,29,38,31],[26,29,28,31],[40,13,40,14],[41,13,41,14],[26,18,28,22],[29,12,31,16],[32,12,33,16],[26,23,28,25],[26,26,28,28],[29,18,31,22],[29,23,31,25],[26,0,28,1],[42,29,42,31],[37,25,37,28],[38,25,38,28],[39,25,39,28],[40,25,40,28],[41,25,41,28],[42,25,42,28],[40,1,40,4],[37,15,37,19],[37,20,37,22],[42,13,42,14],[42,1,42,4],[42,5,42,6],[38,8,38,9],[39,8,39,9],[40,8,40,9],[41,8,41,9],[42,8,42,9],[37,8,37,9],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[9,7,9,8],[37,1,37,4],[38,1,38,4],[39,1,39,4],[40,11,40,12],[41,11,41,12],[39,11,39,12],[41,1,41,4],[12,0,12,2],[16,0,16,1],[20,2,22,6],[23,2,25,6],[20,8,22,9],[16,10,16,11],[23,8,25,9],[26,2,28,6],[29,2,31,6],[20,10,22,11],[17,0,19,1],[20,0,22,1],[23,0,25,1],[23,10,25,11],[32,0,33,11],[29,0,31,1],[7,22,8,23],[9,22,9,23],[10,24,10,25],[17,10,19,11],[10,28,10,30],[2,16,2,17],[1,22,2,24],[1,25,2,26],[7,6,7,8],[8,6,8,8],[9,9,9,10],[3,22,3,23],[3,24,3,25],[4,22,6,23],[4,24,6,31],[8,18,8,20],[7,24,8,31],[9,24,9,30],[1,0,2,6],[3,0,3,2],[4,0,5,2],[3,3,3,5],[4,3,5,8],[9,2,9,6],[10,9,10,10],[17,18,19,22],[16,18,16,20],[16,21,16,22],[10,2,10,6],[10,7,10,8],[12,4,14,5],[12,6,14,10],[17,29,19,31],[17,12,19,16],[17,7,19,7],[16,8,16,9],[17,8,19,9],[0,33,0,39],[43,13,43,14],[37,13,37,14],[39,29,39,31],[0,0,0,31],[43,11,43,12],[9,11,9,13],[10,11,10,13],[43,16,43,18],[43,8,43,9],[38,11,38,12],[42,11,42,12],[37,11,37,12],[38,16,38,18],[39,16,39,18],[40,16,40,18],[41,16,41,18],[17,35,18,36],[7,0,8,1],[17,33,18,34],[7,2,7,5],[8,2,8,5],[9,0,9,1],[10,0,10,1],[42,16,42,18],[38,13,38,14],[39,13,39,14],[13,18,14,30],[16,2,16,6],[17,2,19,6],[16,12,16,16],[17,23,19,25],[17,26,19,28],[20,18,22,22],[20,23,22,25],[20,26,22,28],[23,23,25,25],[23,26,25,28],[20,12,22,16],[23,18,25,22],[23,12,25,16],[26,8,28,9],[29,7,31,7],[29,8,31,9],[26,10,28,11],[29,10,31,11],[26,12,28,16],[35,6,36,10]]}
["　請　　求　　書　",null,null,null,null,null,null,null,null,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（TEL 028-658-1609 工務部 宛）"]
["小平興業株式会社　御中",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"取引先コード",null,null,11111]
[null,null,null,null,null,null,null,null,null,null,null,null,"2018","年",8,"月",31,null,"日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3枚印刷して　2枚提出してください"]
["工 事 番 号",null,null,54017,null,null,null,null,null,null," 検印",null,null,null,null,null,null,null,null,null,null,null,"〒",null,"321-1234",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,"未定"]
[]
[]
["振込\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,{"$f":"IF(J11=\"普通\",1,IF(J11=\"当座\",2,\"\"))","v":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,"1.普通 2.当座",null,"当座",null,12345,null,null,null,null,null,null,null,null,null,null,"TEL",null,null,null,"FAX"]
[]
["整理番号",null,null,null,"今回請求額",null,{"$f":"IF(X21=\"\",M33,AD27)","v":1944000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※請負契約の場合は下記も記入"]
[null,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,null,null,"(金額は消費税込)"]
["8/31",null,"別紙内訳書の通り",null,null,null,null,"式",1,null,null,null,2000000,null,null,null,null,null,"契　　約",null,null,null,null,"累計出来高",null,null,"前回迄出来高",null,null,"今回出来高"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10800000,null,null,null,null,5400000,null,null,3240000,null,null,{"$f":"IF(X21=\"\",\"\",X21-AA21)","v":2160000}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"保留金額",null,null,null,null,540000,null,null,324000,null,null,{"$f":"IF(X24=\"\",\"\",X24-AA24)","v":216000}]
[]
[]
[null,null,"小　　計",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M18:Q26)","v":2000000},null,null,null,null,null,"請求金額",null,null,null,null,{"$f":"IF(X21=\"\",\"\",X21-X24)","v":4860000},null,null,{"$f":"IF(AND(AA21=\"\",AA24=\"\"),\"\",AA21-AA24)","v":2916000},null,null,{"$f":"IF(X27=\"\",\"\",AD21-AD24)","v":1944000},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,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,8,null,null,{"$f":"ROUND(M27*I30/100,0)","v":200000},null,null,null,null,null,"契約残高",null,null,null,null,{"$f":"IF(S21=\"\",\"\",IF(ISERROR(S21-AD27),\"\",S21-X27))","v":5940000}]
[]
[]
["合　　計　",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M27+M30","v":2200000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(N34=#REF!,\"\",\"今回出来高と合わない！！\"))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,"ここから下は、当社記入欄です。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"税区分(税込=0 / 税なし=1)"]
["行","科目コード",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,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,"  .   ."]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  .   ."]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  .   ."]
[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,"計"]

{"sheet":"出来高調書","index":3,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,11,3,14],[0,0,0,13],[6,0,6,2],[1,0,1,14],[4,0,4,2],[4,3,4,7],[4,8,4,11],[4,12,4,14],[2,2,2,5],[3,4,3,5],[5,0,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14]]}
["　出　来　高　内　訳　書　"]
[" 第　　　回　　平成　　年　　月分 "]
[null,"工 事 名 ：",{"$f":"IF('請求書(ＰＣ作成用)'!D5=\"\",\"\",'請求書(ＰＣ作成用)'!D5)","v":""}]
[null,"工　　 期 ：",null,"～",null,null,null,null,null,null,"会社名 ：",{"$f":"IF('請求書(ＰＣ作成用)'!Y8=\"\",\"\",'請求書(ＰＣ作成用)'!Y8)","v":""}]
[]
["契　　　　　　　　　　　　　　　　　　約",null,null,null,null,null,null,"累計出来高金額",null,"前月迄出来高金額",null,"今月出来高金額",null,"残工事"]
["名称",null,null,"単位","数量","単価","金額","数量","金額","数量","金額","数量","金額","数量","金額"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I8-K8","v":0},null,{"$f":"G8-I8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"G9-I9","v":0}]
[null,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,0,null,0]
[null,"　　　　　　小　　　 計",null,null,null,null,{"$f":"SUM(G8:G11)","v":0},null,{"$f":"SUM(I8:I11)","v":0},null,{"$f":"SUM(K8:K11)","v":0},null,0,null,0]
[null,"　　　　　　消　費　税",null,null,null,0.08,{"$f":"ROUND(G12*F13,0)","v":0},null,{"$f":"ROUND(I12*$F13,0)","v":0},null,{"$f":"ROUND(K12*$F13,0)","v":0},null,0,null,0]
[null,"　　　　　　合　　　 計",null,null,null,null,{"$f":"G12+G13","v":0},null,{"$f":"I12+I13","v":0},null,{"$f":"K12+K13","v":0},null,0,null,0]

{"sheet":"内訳書(物品納品)","index":4,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
[" 内 訳 明 細 書 "]
["月","日","名　称","摘　要","単位","数　量","単　価","金　額","備　考"]

{"sheet":"出面集計表","index":5,"n_rows":50,"n_cols":35,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,34],[24,30,24,31],[24,32,24,33],[1,1,1,11],[2,31,2,34],[25,0,25,34],[26,1,26,11],[27,31,27,34],[49,30,49,31],[49,32,49,33]]}
["出　面　集　計　表"]
["工 事 名",{"$f":"IF('請求書(ＰＣ作成用)'!D5=\"\",\"\",'請求書(ＰＣ作成用)'!D5)","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,{"$f":"IF('請求書(ＰＣ作成用)'!Y8=\"\",\"\",'請求書(ＰＣ作成用)'!Y8)","v":""}]
["氏名",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,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,{"$f":"IF(SUM(B5:AF5)=0,\"\",SUM(B5:AF5))","v":""},null,{"$f":"IF(ISERROR(AH5*AG5),\"\",ROUND(AH5*AG5,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,{"$f":"IF(SUM(B6:AF6)=0,\"\",SUM(B6:AF6))","v":""},null,{"$f":"IF(ISERROR(AH6*AG6),\"\",ROUND(AH6*AG6,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,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(SUM(AI5:AI24)=0,\"\",SUM(AI5:AI24))","v":""}]
["出　面　集　計　表"]
["工 事 名",{"$f":"B2","v":""}]
[null,"平成",{"$f":"C3","v":0},"年",{"$f":"E3","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,{"$f":"AF3","v":""}]
["氏名",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,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,{"$f":"IF(SUM(B30:AF30)=0,\"\",SUM(B30:AF30))","v":""},null,{"$f":"IF(ISERROR(AH30*AG30),\"\",ROUND(AH30*AG30,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,{"$f":"IF(SUM(B31:AF31)=0,\"\",SUM(B31:AF31))","v":""},null,{"$f":"IF(ISERROR(AH31*AG31),\"\",ROUND(AH31*AG31,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,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(SUM(AI30:AI49)=0,\"\",SUM(AI30:AI49))","v":""}]