{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Sheet1","Sheet1 (2)","Sheet1 (3)","請求書作成方法","入力シート","請求書(正)","請求書(控)"],"not_rendered":{"images":1,"macros":1,"defined_names":3,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"hidden":true}
["No.",null,null,"請求書",null,null,"年月日"]
[]
["朝陽電気株式会社御中",{"$nulls":3},"業者コード"]
["下記の通り請求致します",{"$nulls":3},"住所"]
[{"$nulls":4},"氏名"]
["作業所名",{"$nulls":3},"電話番号"]
[null,"消費税込み",null,null,"FAX番号"]
["金額",{"$nulls":3},"登録番号"]
[null,"摘要",null,"契約金額（税込み）",null,"出来高","金額","備考"]
{"$rows_empty":10}
[{"$nulls":3},"出来高金額",null,null,"工事コード"]
["支払査定",null,null,"前回迄領収金額",null,null,"注文番号"]
[{"$nulls":3},"差引"]
[{"$nulls":3},"今回請求金額"]
[{"$nulls":3},"消費税",{"v":0.1,"d":"10%"}]
[]
[{"$nulls":3},"社長","役員","総務部","担当部"]
[]
[]
[null,"毎月15日現在の出来高により締切り、ご提出下さい。",{"$nulls":5},"No."]

{"sheet":"Sheet1 (2)","index":1,"n_rows":89,"n_cols":73,"rows_kept":89,"hidden":true,"merged":[[1,24,3,50],[2,2,3,4],[2,5,3,14],[2,56,3,59],[2,60,3,63],[2,64,3,65],[2,66,3,67],[2,68,3,69],[2,70,3,71],[2,72,3,73],[5,2,7,25],[5,26,7,29],[6,46,8,54],[6,56,8,57],[6,58,8,59],[6,60,8,61],[6,62,8,63],[6,64,8,65],[6,66,8,67],[8,6,9,29],[9,45,10,48],[9,50,10,51],[9,52,10,53],[9,54,10,55],[9,56,10,57],[9,58,10,59],[9,60,10,61],[9,62,10,63],[9,64,10,65],[11,45,14,48],[11,50,14,73],[12,2,14,8],[12,9,14,31],[16,45,19,48],[16,50,19,73],[21,7,23,27],[21,45,23,47],[21,48,23,58],[21,60,23,62],[21,63,23,73],[24,2,27,6],[24,7,27,30],[25,45,27,48],[25,49,27,72],[29,2,31,30],[29,31,31,42],[29,43,31,47],[29,48,31,59],[29,60,31,72],[32,2,34,30],[32,31,34,42],[32,43,34,47],[32,48,34,59],[32,60,34,72],[35,2,37,30],[35,31,37,42],[35,43,37,47],[35,48,37,59],[35,60,37,72],[38,2,40,30],[38,31,40,42],[38,43,40,47],[38,48,40,59],[38,60,40,72],[41,2,43,30],[41,31,43,42],[41,43,43,47],[41,48,43,59],[41,60,43,72],[44,2,46,30],[44,31,46,42],[44,43,46,47],[44,48,46,59],[44,60,46,72],[47,2,49,30],[47,31,49,42],[47,43,49,47],[47,48,49,59],[47,60,49,72],[50,2,52,30],[50,31,52,42],[50,43,52,47],[50,48,52,59],[50,60,52,72],[53,2,55,30],[53,31,55,42],[53,43,55,47],[53,48,55,59],[53,60,55,72],[56,2,58,30],[56,31,58,42],[56,43,58,47],[56,48,58,59],[56,60,58,72],[59,2,61,30],[59,31,61,42],[59,43,61,47],[59,48,61,59],[59,60,61,72],[62,2,87,3],[62,31,64,42],[62,43,64,47],[62,48,64,59],[62,60,64,64],[62,65,64,72],[65,31,67,42],[65,43,67,47],[65,48,67,59],[65,60,67,64],[65,65,67,72],[68,31,70,42],[68,43,70,47],[68,48,70,59],[68,60,70,64],[68,65,70,72],[71,31,73,42],[71,43,73,47],[71,48,73,59],[71,60,73,64],[71,65,73,72],[74,31,76,42],[74,43,76,47],[74,48,76,59],[77,31,79,42],[77,43,79,47],[77,48,79,59],[81,31,82,37],[81,38,82,47],[81,48,82,58],[81,59,82,72],[83,31,87,37],[83,38,87,47],[83,48,87,58],[83,59,87,72]]}
[]
[{"$nulls":24},"請求書"]
[null,null,"No.",{"$nulls":53},"西暦",{"$nulls":7},"年",{"$nulls":3},"月",{"$nulls":3},"日"]
[]
[]
[null,null,"朝陽電気株式会社",{"$nulls":23},"御中"]
[{"$nulls":46},"業者コード"]
[]
[{"$nulls":6},"下記の通り請求致します"]
[{"$nulls":45},"〒",{"$nulls":10},"－"]
[]
[{"$nulls":45},"住所"]
[null,null,"作業所名"]
[]
[]
[]
[{"$nulls":45},"会社名"]
[]
[]
[]
[]
[{"$nulls":7},"消費税は含まれません",{"$nulls":37},"電話",{"$nulls":14},"FAX"]
[]
[]
[null,null,"金額"]
[{"$nulls":45},"登録番号"]
[]
[]
[]
[null,null,"摘要",{"$nulls":28},"契約金額",{"$nulls":11},"出来高",{"$nulls":4},"金額",{"$nulls":11},"備考"]
{"$rows_empty":32}
[null,null,"支払査定",{"$nulls":28},"出来高金額",{"$nulls":11},"税抜or込",{"$nulls":16},"工事コード"]
[]
[]
[{"$nulls":31},"支払率",{"$nulls":11},"90or100",{"$nulls":16},"注文番号"]
[]
[]
[{"$nulls":31},"既領収金額",{"$nulls":11},"税抜or込",{"$nulls":16},"契約注文金額"]
[]
[]
[{"$nulls":31},"今回請求金額",{"$nulls":11},"税抜or込",{"$nulls":16},"今回支払査定額"]
[]
[]
[{"$nulls":31},"消費税",{"$nulls":11},10]
[]
[]
[{"$nulls":31},"今回請求金額",{"$nulls":11},"税抜or込"]
[]
[]
[]
[{"$nulls":31},"社長",{"$nulls":6},"役員",{"$nulls":9},"総務部",{"$nulls":10},"担当部"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"毎月15日現在の出来高により締切り、ご提出下さい。",{"$nulls":56},"No."]

{"sheet":"Sheet1 (3)","index":2,"n_rows":87,"n_cols":73,"rows_kept":87,"hidden":true,"merged":[[1,24,3,50],[2,2,3,4],[2,5,3,14],[2,56,3,59],[2,60,3,63],[2,64,3,65],[2,66,3,67],[2,68,3,69],[2,70,3,71],[2,72,3,73],[6,44,8,52],[6,53,8,54],[6,55,8,56],[6,57,8,58],[6,59,8,60],[6,61,8,62],[6,63,8,64],[8,2,10,25],[8,26,10,29],[9,44,10,47],[9,49,10,50],[9,51,10,52],[9,53,10,54],[9,55,10,56],[9,57,10,58],[9,59,10,60],[9,61,10,62],[9,63,10,64],[11,6,12,29],[11,44,14,47],[11,49,14,72],[16,2,18,8],[16,9,18,31],[16,44,19,47],[16,49,19,72],[21,7,23,27],[21,44,23,46],[21,48,23,57],[21,59,23,61],[21,63,23,72],[24,2,27,6],[24,7,27,30],[25,44,27,47],[25,49,27,72],[29,2,31,30],[29,31,31,42],[29,43,31,47],[29,48,31,59],[29,60,31,72],[32,2,34,30],[32,31,34,42],[32,43,34,47],[32,48,34,59],[32,60,34,72],[35,2,37,30],[35,31,37,42],[35,43,37,47],[35,48,37,59],[35,60,37,72],[38,2,40,30],[38,31,40,42],[38,43,40,47],[38,48,40,59],[38,60,40,72],[41,2,43,30],[41,31,43,42],[41,43,43,47],[41,48,43,59],[41,60,43,72],[44,2,46,30],[44,31,46,42],[44,43,46,47],[44,48,46,59],[44,60,46,72],[47,2,49,30],[47,31,49,42],[47,43,49,47],[47,48,49,59],[47,60,49,72],[50,2,52,30],[50,31,52,42],[50,43,52,47],[50,48,52,59],[50,60,52,72],[53,2,55,30],[53,31,55,42],[53,43,55,47],[53,48,55,59],[53,60,55,72],[56,2,58,30],[56,31,58,42],[56,43,58,47],[56,48,58,59],[56,60,58,72],[59,2,84,3],[59,31,61,42],[59,43,61,47],[59,48,61,59],[59,60,61,64],[59,65,61,72],[62,31,64,42],[62,43,64,47],[62,48,64,59],[62,60,64,64],[62,65,64,72],[65,31,67,42],[65,43,67,47],[65,48,67,59],[65,60,67,62],[65,63,67,64],[65,65,67,72],[68,31,70,42],[68,43,70,47],[68,48,70,59],[68,60,70,64],[68,65,70,72],[71,31,73,42],[71,43,73,47],[71,48,73,59],[74,31,76,42],[74,43,76,47],[74,48,76,59],[78,31,79,37],[78,38,79,47],[78,48,79,58],[78,59,79,72],[80,31,84,37],[80,38,84,47],[80,48,84,58],[80,59,84,72],[86,3,87,32],[86,59,87,61],[86,62,87,72]]}
[]
[{"$nulls":24},"請求書"]
[null,null,"No.",null,null,{"$f":"+IF(入力シート!L33=\"\",\"\",+入力シート!L33)","v":""},{"$nulls":50},"西暦",{"$nulls":3},{"$f":"+IF(入力シート!P50=\"\",\"\",+入力シート!P50)","v":""},{"$nulls":3},"年",null,{"$f":"+IF(入力シート!Y50=\"\",\"\",+入力シート!Y50)","v":""},null,"月",null,{"$f":"+IF(入力シート!#REF!=\"\",\"\",+入力シート!#REF!)","v":{"$error":"#REF!"}},null,"日"]
[]
[]
[]
[{"$nulls":44},"業者コード",{"$nulls":8},{"$f":"+IF(入力シート!L6=\"\",\"\",+入力シート!L6)","v":""},null,{"$f":"+IF(入力シート!O6=\"\",\"\",+入力シート!O6)","v":""},null,{"$f":"+IF(入力シート!R6=\"\",\"\",+入力シート!R6)","v":""},null,{"$f":"+IF(入力シート!U6=\"\",\"\",+入力シート!U6)","v":""},null,{"$f":"+IF(入力シート!X6=\"\",\"\",+入力シート!X6)","v":""},null,{"$f":"+IF(入力シート!AA6=\"\",\"\",+入力シート!AA6)","v":""}]
[]
[null,null,"朝陽電気株式会社",{"$nulls":23},"御中"]
[{"$nulls":44},"〒",{"$nulls":4},{"$f":"+IF(入力シート!L9=\"\",\"\",+入力シート!L9)","v":""},null,{"$f":"+IF(入力シート!O9=\"\",\"\",+入力シート!O9)","v":""},null,{"$f":"+IF(入力シート!R9=\"\",\"\",+入力シート!R9)","v":""},null,"－",null,{"$f":"+IF(入力シート!X9=\"\",\"\",+入力シート!X9)","v":""},null,{"$f":"+IF(入力シート!AA9=\"\",\"\",+入力シート!AA9)","v":""},null,{"$f":"+IF(入力シート!AD9=\"\",\"\",+入力シート!AD9)","v":""},null,{"$f":"+IF(入力シート!AG9=\"\",\"\",+入力シート!AG9)","v":""}]
[]
[{"$nulls":6},"下記の通り請求致します",{"$nulls":37},"住所",{"$nulls":4},{"$f":"+IF(入力シート!L12=\"\",\"\",+入力シート!L12)","v":""}]
[]
[]
[]
[]
[null,null,"作業所名",{"$nulls":6},{"$f":"+IF(入力シート!L36=\"\",\"\",+入力シート!L36)","v":""},{"$nulls":34},"会社名",{"$nulls":4},{"$f":"+IF(入力シート!L15=\"\",\"\",+入力シート!L15)","v":""}]
[]
[]
[]
[]
[{"$nulls":7},"消費税は含まれております",{"$nulls":36},"電話",{"$nulls":3},{"$f":"+IF(入力シート!L18=\"\",\"\",+入力シート!L18)","v":""},{"$nulls":10},"FAX",{"$nulls":3},{"$f":"+IF(入力シート!L21=\"\",\"\",+入力シート!L21)","v":""}]
[]
[]
[null,null,"金額",{"$nulls":4},{"$f":"+IF(AW69=\"\",\"\",+AW69)","v":{"$error":"#REF!"}}]
[{"$nulls":44},"登録\n番号",{"$nulls":4},{"$f":"+IF(入力シート!L24=\"\",\"\",+入力シート!L24)","v":""}]
[]
[]
[]
[null,null,"摘要",{"$nulls":28},"契約金額",{"$nulls":11},"出来高",{"$nulls":4},"金額",{"$nulls":11},"備考"]
[]
[]
[null,null,{"$f":"+IF(入力シート!L39=\"\",\"\",+入力シート!L39)","v":""},{"$nulls":28},{"$f":"+IF(入力シート!L42=\"\",\"\",+入力シート!L42)","v":""},{"$nulls":11},{"$f":"+AW33/AF33","v":{"$error":"#REF!"}},{"$nulls":4},{"$f":"+AW63+AW66","v":{"$error":"#REF!"}},{"$nulls":11},{"$f":"+IF(入力シート!#REF!=\"\",\"\",+入力シート!#REF!)","v":{"$error":"#REF!"}}]
{"$rows_empty":26}
[null,null,"支払査定",{"$nulls":28},"出来高金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+IF(入力シート!#REF!=\"\",\"\",+入力シート!#REF!)","v":{"$error":"#REF!"}},{"$nulls":11},"工事\nコード"]
[]
[]
[{"$nulls":31},"支払率",{"$nulls":11},{"$f":"+IF(AW60+AW66=AF33,1,0.9)","v":{"$error":"#REF!"}},{"$nulls":4},{"$f":"+IF(AW60=\"\",\"\",AW60*AR63)","v":{"$error":"#REF!"}},{"$nulls":11},"注文番号",{"$nulls":4},{"$f":"+IF(入力シート!L45=\"\",\"\",+入力シート!L45)","v":""}]
[]
[]
[{"$nulls":31},"既領収金額",{"$nulls":11},"税込",{"$nulls":4},{"v":0,"d":"¥0"},{"$nulls":11},"契約注文",null,null,"金額",null,{"$f":"+IF(AF33=\"\",\"\",+AF33)","v":""}]
[]
[]
[{"$nulls":31},"今回請求金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+IF(AW63=\"\",\"\",AW63)","v":{"$error":"#REF!"}},{"$nulls":11},"今回支払\n査定額"]
[]
[]
[{"$nulls":31},"消費税",{"$nulls":11},{"v":0.1,"d":"10%"},{"$nulls":4},{"$f":"+IF(AW69=\"\",\"\",AW69/11)","v":{"$error":"#REF!"}}]
[]
[]
[{"$nulls":31},"今回請求金額",{"$nulls":11},"税抜",{"$nulls":4},{"$f":"+IF(AW72=\"\",\"\",AW69-AW72)","v":{"$error":"#REF!"}}]
[]
[]
[]
[{"$nulls":31},"社長",{"$nulls":6},"役員",{"$nulls":9},"総務部",{"$nulls":10},"担当部"]
{"$rows_empty":7}
[{"$nulls":3},"毎月15日現在の出来高により締切り、ご提出下さい。",{"$nulls":55},"No."]

{"sheet":"請求書作成方法","index":3,"n_rows":59,"n_cols":57,"rows_kept":59,"hidden":true,"merged":[[1,1,3,52],[1,55,3,106],[4,2,6,15],[5,56,7,105],[7,3,9,12],[7,13,9,50],[9,56,11,105],[10,3,12,12],[10,13,27,50],[13,3,15,12],[13,56,15,105],[16,3,18,12],[17,56,19,105],[19,3,21,12],[21,56,23,105],[22,3,24,12],[25,3,27,12],[29,2,31,16],[32,3,34,12],[32,13,34,50],[35,3,37,12],[35,13,37,50],[38,3,40,12],[38,13,40,50],[41,3,43,12],[41,13,43,50],[44,3,46,12],[44,13,46,50],[48,3,50,12],[48,13,50,50],[52,2,54,17],[55,3,57,12],[55,13,57,50],[58,3,60,12],[58,13,60,50]]}
[]
[null,"請求書入力内容",{"$nulls":53},"請求書発行の注意事項"]
[]
[]
[null,null,"●基本項目"]
[{"$nulls":56},"1. 黄色セルは全て記入してください"]
[]
[{"$nulls":3},"取引先\nコード",{"$nulls":9},"注文書記載の「取引先コード」を入力"]
[]
[{"$nulls":56},"2. 請求書発行時、「正」・「控」一回ずつ印刷プレビューが表示されます\n    社印を押印し「正」のみご提出ください"]
[{"$nulls":3},"〒",{"$nulls":9},"会社の情報を入力"]
[]
[]
[{"$nulls":3},"住所",{"$nulls":52},"3. 工事未了の場合、請求金額は出来高金額の90%となります\n3. 工事完了後、出来高金額が100%となり、控除分と併せての支払いとなります"]
[]
[]
[{"$nulls":3},"会社名"]
[]
[]
[{"$nulls":3},"Tel"]
[]
[]
[{"$nulls":3},"Fax"]
[]
[]
[{"$nulls":3},"適格請求書発行\n事業者登録番号"]
[]
[]
[]
[null,null,"●契約内容"]
[]
[]
[{"$nulls":3},"請求書No.",{"$nulls":9},"任意の番号を入力"]
[]
[]
[{"$nulls":3},"現場名",{"$nulls":9},"作業所名を入力"]
[]
[]
[{"$nulls":3},"工事件名",{"$nulls":9},"工事件名を入力"]
[]
[]
[{"$nulls":3},"契約金額(税込)",{"$nulls":9},"注文書記載の「契約金額」を入力"]
[]
[]
[{"$nulls":3},"注文番号",{"$nulls":9},"注文書記載の「注文番号」を入力"]
[]
[]
[]
[{"$nulls":3},"右肩日付",{"$nulls":9},"毎月15日を記入\n（12月16日～20日に行った作業の請求書は12月20日を記入）"]
[]
[]
[]
[null,null,"●出来高請求実績"]
[]
[]
[{"$nulls":3},"日付",{"$nulls":9},"右肩日付と同日を入力"]
[]
[]
[{"$nulls":3},"出来高金額(税込)",{"$nulls":9},"当月の請求金額を入力\n（出来高２回目以降の請求は同じＥｘｃｅｌファイルを使用）"]

{"sheet":"入力シート","index":4,"n_rows":54,"n_cols":76,"rows_kept":54,"merged":[[1,0,3,28],[1,55,3,82],[5,1,7,10],[5,11,7,13],[5,14,7,16],[5,17,7,19],[5,20,7,22],[5,23,7,25],[5,26,7,28],[5,56,7,61],[5,62,7,74],[5,75,7,90],[8,1,10,10],[8,11,10,13],[8,14,10,16],[8,17,10,19],[8,20,10,22],[8,23,10,25],[8,26,10,28],[8,29,10,31],[8,32,10,34],[8,56,10,61],[8,62,10,74],[8,75,10,90],[11,1,13,10],[11,11,13,50],[11,56,13,61],[11,62,13,74],[11,75,13,90],[14,1,16,10],[14,11,16,50],[14,56,16,61],[14,62,16,74],[14,75,16,90],[17,1,19,10],[17,11,19,28],[17,56,19,61],[17,62,19,74],[17,75,19,90],[20,1,22,10],[20,11,22,28],[20,56,22,61],[20,62,22,74],[20,75,22,90],[23,1,25,10],[23,11,25,34],[23,56,25,61],[23,62,25,74],[23,75,25,90],[26,56,28,61],[26,62,28,74],[26,75,28,90],[28,0,30,28],[29,56,31,61],[29,62,31,74],[29,75,31,90],[32,1,34,10],[32,11,34,21],[32,56,34,61],[32,62,34,74],[32,75,34,90],[35,1,37,10],[35,11,37,38],[35,56,37,61],[35,62,37,74],[35,75,37,90],[38,1,40,10],[38,11,40,50],[38,56,40,61],[38,62,40,74],[38,75,40,90],[41,1,43,10],[41,11,43,28],[41,56,43,61],[41,62,43,74],[41,75,43,90],[44,1,46,10],[44,11,46,28],[44,56,46,61],[44,62,46,74],[44,75,46,90],[47,56,49,61],[47,62,49,74],[47,75,49,90],[49,1,51,10],[49,11,51,14],[49,15,51,27],[50,56,52,61],[50,62,52,74],[50,75,52,90],[53,56,55,74],[53,75,55,90]]}
[]
["基本項目",{"$nulls":54},"出来高請求実績"]
[]
[]
[]
[null,"取引先\nコード",{"$nulls":60},"日付",{"$nulls":12},"出来高金額(税込)"]
[]
[]
[null,"〒",{"$nulls":18},"－",{"$nulls":35},"1回目"]
[]
[]
[null,"住所",{"$nulls":54},"2回目"]
[]
[]
[null,"会社名",{"$nulls":54},"3回目"]
[]
[]
[null,"Tel",{"$nulls":54},"4回目"]
[]
[]
[null,"Fax",{"$nulls":54},"5回目"]
[]
[]
[null,"適格請求書発行\n事業者登録番号",{"$nulls":54},"6回目"]
[]
[]
[{"$nulls":56},"7回目"]
[]
["契約内容"]
[{"$nulls":56},"8回目"]
[]
[]
[null,"請求書No.",{"$nulls":54},"9回目"]
[]
[]
[null,"現場名",{"$nulls":54},"10回目"]
[]
[]
[null,"工事件名",{"$nulls":54},"11回目"]
[]
[]
[null,"契約金額(税込)",{"$nulls":54},"12回目"]
[]
[]
[null,"注文番号",{"$nulls":54},"13回目"]
[]
[]
[{"$nulls":56},"14回目"]
[]
[null,"右肩日付",{"$nulls":9},"西暦"]
[{"$nulls":56},"15回目"]
[]
[]
[{"$nulls":56},"合計金額",{"$nulls":18},{"$f":"SUM(BX9:CM53)","v":{"v":0,"d":"¥0"}}]

{"sheet":"請求書(正)","index":5,"n_rows":87,"n_cols":73,"rows_kept":87,"merged":[[1,24,3,50],[2,2,3,4],[2,5,3,14],[2,54,3,57],[2,58,3,61],[2,62,3,63],[2,64,3,66],[2,67,3,68],[2,69,3,71],[2,72,3,73],[4,36,6,38],[6,44,8,52],[6,53,8,54],[6,55,8,56],[6,57,8,58],[6,59,8,60],[6,61,8,62],[6,63,8,64],[8,2,10,25],[8,26,10,29],[10,44,12,47],[10,49,12,50],[10,51,12,52],[10,53,12,54],[10,55,12,56],[10,57,12,58],[10,59,12,60],[10,61,12,62],[10,63,12,64],[11,6,12,29],[13,44,15,47],[13,49,15,72],[16,2,18,8],[16,9,18,31],[16,44,18,47],[16,49,18,68],[16,70,18,72],[19,44,21,47],[19,49,21,72],[21,7,23,27],[22,44,24,47],[22,49,24,72],[24,2,27,6],[24,7,27,30],[25,44,27,47],[25,49,27,72],[29,2,31,14],[29,15,31,43],[29,44,31,55],[29,56,31,60],[29,61,31,72],[32,2,34,14],[32,15,34,43],[32,44,34,55],[32,56,34,60],[32,61,34,72],[35,2,37,14],[35,15,37,43],[35,44,37,55],[35,56,37,60],[35,61,37,72],[38,2,40,14],[38,15,40,43],[38,44,40,55],[38,56,40,60],[38,61,40,72],[41,2,43,14],[41,15,43,43],[41,44,43,55],[41,56,43,60],[41,61,43,72],[44,2,46,14],[44,15,46,43],[44,44,46,55],[44,56,46,60],[44,61,46,72],[47,2,49,14],[47,15,49,43],[47,44,49,55],[47,56,49,60],[47,61,49,72],[50,2,52,14],[50,15,52,43],[50,44,52,55],[50,56,52,60],[50,61,52,72],[53,2,55,14],[53,44,55,72],[56,44,58,55],[56,56,58,60],[56,61,58,72],[59,44,61,55],[59,56,61,60],[59,61,61,72],[62,44,64,55],[62,56,64,60],[62,61,64,72],[65,44,66,55],[65,56,68,60],[65,61,68,72],[67,44,68,51],[67,52,68,55],[69,44,71,55],[69,56,71,60],[69,61,71,72],[72,44,74,55],[72,56,74,60],[72,61,74,72],[75,44,83,55],[75,56,77,60],[75,61,77,72],[77,2,78,8],[77,9,78,18],[77,19,78,29],[77,30,78,43],[78,56,80,60],[78,61,80,72],[79,2,83,8],[79,9,83,18],[79,19,83,29],[79,30,83,43],[81,56,83,60],[81,61,83,72],[86,3,87,32],[86,59,87,61],[86,62,87,72]]}
[]
[{"$nulls":24},"請求書"]
[null,null,"No.",null,null,{"$f":"+IF(入力シート!L33=\"\",\"\",+入力シート!L33)","v":""},{"$nulls":48},"西暦",{"$nulls":3},{"$f":"+YEAR(入力シート!P50)","v":1900},{"$nulls":3},"年",null,{"$f":"+MONTH(入力シート!P50)","v":1},null,null,"月",null,{"$f":"+DAY(入力シート!P50)","v":0},null,null,"日"]
[]
[{"$nulls":36},"㊣"]
[]
[{"$nulls":44},"業者コード",{"$nulls":8},{"$f":"+IF(入力シート!L6=\"\",\"\",+入力シート!L6)","v":""},null,{"$f":"+IF(入力シート!O6=\"\",\"\",+入力シート!O6)","v":""},null,{"$f":"+IF(入力シート!R6=\"\",\"\",+入力シート!R6)","v":""},null,{"$f":"+IF(入力シート!U6=\"\",\"\",+入力シート!U6)","v":""},null,{"$f":"+IF(入力シート!X6=\"\",\"\",+入力シート!X6)","v":""},null,{"$f":"+IF(入力シート!AA6=\"\",\"\",+入力シート!AA6)","v":""}]
[]
[null,null,"朝陽電気株式会社",{"$nulls":23},"御中"]
[]
[{"$nulls":44},"〒",{"$nulls":4},{"$f":"+IF(入力シート!L9=\"\",\"\",+入力シート!L9)","v":""},null,{"$f":"+IF(入力シート!O9=\"\",\"\",+入力シート!O9)","v":""},null,{"$f":"+IF(入力シート!R9=\"\",\"\",+入力シート!R9)","v":""},null,"－",null,{"$f":"+IF(入力シート!X9=\"\",\"\",+入力シート!X9)","v":""},null,{"$f":"+IF(入力シート!AA9=\"\",\"\",+入力シート!AA9)","v":""},null,{"$f":"+IF(入力シート!AD9=\"\",\"\",+入力シート!AD9)","v":""},null,{"$f":"+IF(入力シート!AG9=\"\",\"\",+入力シート!AG9)","v":""}]
[{"$nulls":6},"下記の通り請求致します"]
[]
[{"$nulls":44},"住所",{"$nulls":4},{"$f":"+IF(入力シート!L12=\"\",\"\",+入力シート!L12)","v":""}]
[]
[]
[null,null,"現場名",{"$nulls":6},{"$f":"+IF(入力シート!L36=\"\",\"\",+入力シート!L36)","v":""},{"$nulls":34},"会社名",{"$nulls":4},{"$f":"+IF(入力シート!L15=\"\",\"\",+入力シート!L15)","v":""},{"$nulls":20},"㊞"]
[]
[]
[{"$nulls":44},"電話",{"$nulls":4},{"$f":"+IF(入力シート!L18=\"\",\"\",+入力シート!L18)","v":""}]
[]
[{"$nulls":7},"消費税は含まれております"]
[{"$nulls":44},"FAX",{"$nulls":4},{"$f":"+IF(入力シート!L21=\"\",\"\",+入力シート!L21)","v":""}]
[]
[null,null,"金額",{"$nulls":4},{"$f":"+IF(BJ82=\"\",\"\",+BJ82)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":44},"登録\n番号",{"$nulls":4},{"$f":"+IF(入力シート!L24=\"\",\"\",+入力シート!L24)","v":""}]
[]
[]
[]
[null,null,"注文番号",{"$nulls":12},"摘要",{"$nulls":28},"契約金額",{"$nulls":11},"出来高",{"$nulls":4},"金額"]
[]
[]
[null,null,{"$f":"+IF(入力シート!L45=\"\",\"\",+入力シート!L45)","v":""},{"$nulls":12},{"$f":"+IF(入力シート!L39=\"\",\"\",+入力シート!L39)","v":""},{"$nulls":28},{"$f":"+IF(入力シート!L42=\"\",\"\",+入力シート!L42)","v":""},{"$nulls":11},{"$f":"+IF(AS33=\"\",\"\",BJ33/AS33)","v":""},{"$nulls":4},{"$f":"+IF(BJ57+BJ63=\"\",\"\",BJ57+BJ63)","v":{"v":0,"d":"¥0"}}]
{"$rows_empty":20}
[null,null,"朝陽電気使用欄",{"$nulls":41},"出来高関連情報"]
[]
[]
[{"$nulls":44},"前回迄出来高金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+SUMIF(入力シート!BK9:BK53,\"<\"&入力シート!P50,入力シート!BX9:CM53)","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":44},"既領収金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+SUMIF(入力シート!BK9:BK53,\"<\"&入力シート!P50,入力シート!BX9:CM53)*0.9","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":44},"当月出来高金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+SUMIF(入力シート!BK9:BK53,\"=\"&入力シート!P50,入力シート!BX9:CM53)","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":44},"支払率控除後出来高金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+IF(BJ63=\"\",\"\",BJ63*BA68)","v":{"v":0,"d":"¥0"}}]
[]
[{"$nulls":44},"支払率",{"$nulls":7},{"$f":"+IF(BJ63+SUMIF(入力シート!BK9:BK53,\"<\"&入力シート!P50,入力シート!BX9:CM53)=AS33,1,0.9)","v":{"v":0.9,"d":"90%"}}]
[]
[{"$nulls":44},"出来高控除額累計",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+IF(BA68=0.9,BJ33*0.1,IF(BA68=1,BJ57*0.1))","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":44},"出来高控除返金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"IF(BA68=0.9,0,IF(BA68=1,+SUMIF(入力シート!BK9:BK53,\"<\"&入力シート!P50,入力シート!BX9:CM53))*0.1)","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":44},"当月請求金額\n(支払率控除後出来高金額＋出来高控除返金額)",{"$nulls":11},"税抜",{"$nulls":4},{"$f":"+BJ82-BJ79","v":{"v":0,"d":"¥0"}}]
[]
[null,null,"社長",{"$nulls":6},"役員",{"$nulls":9},"総務部",{"$nulls":10},"担当部"]
[{"$nulls":56},"消  費  税\n10％",{"$nulls":4},{"$f":"+IF(BJ82=\"\",\"\",ROUNDDOWN(BJ82/11,0))","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":56},"税込",{"$nulls":4},{"$f":"+IF(BA68=0.9,BJ66,IF(BA68=1,BJ66+BJ73))","v":{"v":0,"d":"¥0"}}]
[]
[]
[]
[]
[{"$nulls":3},"毎月15日現在の出来高により締切り、ご提出下さい。",{"$nulls":55},"No."]

{"sheet":"請求書(控)","index":6,"n_rows":87,"n_cols":73,"rows_kept":87,"merged":[[1,24,3,50],[2,2,3,4],[2,5,3,14],[2,54,3,57],[2,58,3,61],[2,62,3,63],[2,64,3,66],[2,67,3,68],[2,69,3,71],[2,72,3,73],[4,36,6,38],[6,44,8,52],[6,53,8,54],[6,55,8,56],[6,57,8,58],[6,59,8,60],[6,61,8,62],[6,63,8,64],[8,2,10,25],[8,26,10,29],[10,44,12,47],[10,49,12,50],[10,51,12,52],[10,53,12,54],[10,55,12,56],[10,57,12,58],[10,59,12,60],[10,61,12,62],[10,63,12,64],[11,6,12,29],[13,44,15,47],[13,49,15,72],[16,2,18,8],[16,9,18,31],[16,44,18,47],[16,49,18,68],[16,70,18,72],[19,44,21,47],[19,49,21,72],[21,7,23,27],[22,44,24,47],[22,49,24,72],[24,2,27,6],[24,7,27,30],[25,44,27,47],[25,49,27,72],[29,2,31,14],[29,15,31,43],[29,44,31,55],[29,56,31,60],[29,61,31,72],[32,2,34,14],[32,15,34,43],[32,44,34,55],[32,56,34,60],[32,61,34,72],[35,2,37,14],[35,15,37,43],[35,44,37,55],[35,56,37,60],[35,61,37,72],[38,2,40,14],[38,15,40,43],[38,44,40,55],[38,56,40,60],[38,61,40,72],[41,2,43,14],[41,15,43,43],[41,44,43,55],[41,56,43,60],[41,61,43,72],[44,2,46,14],[44,15,46,43],[44,44,46,55],[44,56,46,60],[44,61,46,72],[47,2,49,14],[47,15,49,43],[47,44,49,55],[47,56,49,60],[47,61,49,72],[50,2,52,14],[50,15,52,43],[50,44,52,55],[50,56,52,60],[50,61,52,72],[53,2,55,14],[53,44,55,72],[56,44,58,55],[56,56,58,60],[56,61,58,72],[59,44,61,55],[59,56,61,60],[59,61,61,72],[62,44,64,55],[62,56,64,60],[62,61,64,72],[65,44,66,55],[65,56,68,60],[65,61,68,72],[67,44,68,51],[67,52,68,55],[69,44,71,55],[69,56,71,60],[69,61,71,72],[72,44,74,55],[72,56,74,60],[72,61,74,72],[75,44,83,55],[75,56,77,60],[75,61,77,72],[77,2,78,8],[77,9,78,18],[77,19,78,29],[77,30,78,43],[78,56,80,60],[78,61,80,72],[79,2,83,8],[79,9,83,18],[79,19,83,29],[79,30,83,43],[81,56,83,60],[81,61,83,72],[86,3,87,32],[86,59,87,61],[86,62,87,72]]}
[]
[{"$nulls":24},"請求書"]
[null,null,"No.",null,null,{"$f":"+IF(入力シート!L33=\"\",\"\",+入力シート!L33)","v":""},{"$nulls":48},"西暦",{"$nulls":3},{"$f":"+YEAR(入力シート!P50)","v":1900},{"$nulls":3},"年",null,{"$f":"+MONTH(入力シート!P50)","v":1},null,null,"月",null,{"$f":"+DAY(入力シート!P50)","v":0},null,null,"日"]
[]
[{"$nulls":36},"控"]
[]
[{"$nulls":44},"業者コード",{"$nulls":8},{"$f":"+IF(入力シート!L6=\"\",\"\",+入力シート!L6)","v":""},null,{"$f":"+IF(入力シート!O6=\"\",\"\",+入力シート!O6)","v":""},null,{"$f":"+IF(入力シート!R6=\"\",\"\",+入力シート!R6)","v":""},null,{"$f":"+IF(入力シート!U6=\"\",\"\",+入力シート!U6)","v":""},null,{"$f":"+IF(入力シート!X6=\"\",\"\",+入力シート!X6)","v":""},null,{"$f":"+IF(入力シート!AA6=\"\",\"\",+入力シート!AA6)","v":""}]
[]
[null,null,"朝陽電気株式会社",{"$nulls":23},"御中"]
[]
[{"$nulls":44},"〒",{"$nulls":4},{"$f":"+IF(入力シート!L9=\"\",\"\",+入力シート!L9)","v":""},null,{"$f":"+IF(入力シート!O9=\"\",\"\",+入力シート!O9)","v":""},null,{"$f":"+IF(入力シート!R9=\"\",\"\",+入力シート!R9)","v":""},null,"－",null,{"$f":"+IF(入力シート!X9=\"\",\"\",+入力シート!X9)","v":""},null,{"$f":"+IF(入力シート!AA9=\"\",\"\",+入力シート!AA9)","v":""},null,{"$f":"+IF(入力シート!AD9=\"\",\"\",+入力シート!AD9)","v":""},null,{"$f":"+IF(入力シート!AG9=\"\",\"\",+入力シート!AG9)","v":""}]
[{"$nulls":6},"下記の通り請求致します"]
[]
[{"$nulls":44},"住所",{"$nulls":4},{"$f":"+IF(入力シート!L12=\"\",\"\",+入力シート!L12)","v":""}]
[]
[]
[null,null,"現場名",{"$nulls":6},{"$f":"+IF(入力シート!L36=\"\",\"\",+入力シート!L36)","v":""},{"$nulls":34},"会社名",{"$nulls":4},{"$f":"+IF(入力シート!L15=\"\",\"\",+入力シート!L15)","v":""},{"$nulls":20},"㊞"]
[]
[]
[{"$nulls":44},"電話",{"$nulls":4},{"$f":"+IF(入力シート!L18=\"\",\"\",+入力シート!L18)","v":""}]
[]
[{"$nulls":7},"消費税は含まれております"]
[{"$nulls":44},"FAX",{"$nulls":4},{"$f":"+IF(入力シート!L21=\"\",\"\",+入力シート!L21)","v":""}]
[]
[null,null,"金額",{"$nulls":4},{"$f":"+IF(BJ82=\"\",\"\",+BJ82)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":44},"登録\n番号",{"$nulls":4},{"$f":"+IF(入力シート!L24=\"\",\"\",+入力シート!L24)","v":""}]
[]
[]
[]
[null,null,"注文番号",{"$nulls":12},"摘要",{"$nulls":28},"契約金額",{"$nulls":11},"出来高",{"$nulls":4},"金額"]
[]
[]
[null,null,{"$f":"+IF(入力シート!L45=\"\",\"\",+入力シート!L45)","v":""},{"$nulls":12},{"$f":"+IF(入力シート!L39=\"\",\"\",+入力シート!L39)","v":""},{"$nulls":28},{"$f":"+IF(入力シート!L42=\"\",\"\",+入力シート!L42)","v":""},{"$nulls":11},{"$f":"+IF(AS33=\"\",\"\",BJ33/AS33)","v":""},{"$nulls":4},{"$f":"+IF(BJ57+BJ63=\"\",\"\",BJ57+BJ63)","v":{"v":0,"d":"¥0"}}]
{"$rows_empty":20}
[null,null,"朝陽電気使用欄",{"$nulls":41},"出来高関連情報"]
[]
[]
[{"$nulls":44},"前回迄出来高金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+SUMIF(入力シート!BK9:BK53,\"<\"&入力シート!P50,入力シート!BX9:CM53)","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":44},"既領収金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+SUMIF(入力シート!BK9:BK53,\"<\"&入力シート!P50,入力シート!BX9:CM53)*0.9","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":44},"当月出来高金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+SUMIF(入力シート!BK9:BK53,\"=\"&入力シート!P50,入力シート!BX9:CM53)","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":44},"支払率控除後出来高金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+IF(BJ63=\"\",\"\",BJ63*BA68)","v":{"v":0,"d":"¥0"}}]
[]
[{"$nulls":44},"支払率",{"$nulls":7},{"$f":"+IF(BJ63+SUMIF(入力シート!BK9:BK53,\"<\"&入力シート!P50,入力シート!BX9:CM53)=AS33,1,0.9)","v":{"v":0.9,"d":"90%"}}]
[]
[{"$nulls":44},"出来高控除額累計",{"$nulls":11},"税込",{"$nulls":4},{"$f":"+IF(BA68=0.9,BJ33*0.1,IF(BA68=1,BJ57*0.1))","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":44},"出来高控除返金額",{"$nulls":11},"税込",{"$nulls":4},{"$f":"IF(BA68=0.9,0,IF(BA68=1,+SUMIF(入力シート!BK9:BK53,\"<\"&入力シート!P50,入力シート!BX9:CM53))*0.1)","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":44},"当月請求金額\n(支払率控除後出来高金額＋出来高控除返金額)",{"$nulls":11},"税抜",{"$nulls":4},{"$f":"+BJ82-BJ79","v":{"v":0,"d":"¥0"}}]
[]
[null,null,"社長",{"$nulls":6},"役員",{"$nulls":9},"総務部",{"$nulls":10},"担当部"]
[{"$nulls":56},"消  費  税\n10％",{"$nulls":4},{"$f":"+IF(BJ82=\"\",\"\",ROUNDDOWN(BJ82/11,0))","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$nulls":56},"税込",{"$nulls":4},{"$f":"+IF(BA68=0.9,BJ66,IF(BA68=1,BJ66+BJ73))","v":{"v":0,"d":"¥0"}}]
[]
[]
[]
[]
[{"$nulls":3},"毎月15日現在の出来高により締切り、ご提出下さい。",{"$nulls":55},"No."]