{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["記入例","表紙","内訳明細書"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":3,"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":25,"n_cols":34,"rows_kept":25,"cut":false,"hidden":false,"merged":[[17,1,18,1],[17,2,18,2],[17,3,18,10],[19,3,19,10],[19,11,19,13],[1,2,1,3],[8,17,10,19],[8,20,10,30],[10,1,10,2],[10,3,10,5],[10,7,10,8],[10,10,10,11],[6,4,6,7],[7,4,7,11],[2,2,2,3],[4,4,4,7],[4,9,6,22],[5,4,5,7],[8,1,8,3],[1,24,3,30],[19,27,19,30],[17,24,17,30],[18,11,18,13],[18,14,18,16],[18,17,18,21],[18,24,18,26],[17,11,17,21],[17,22,18,23],[18,27,18,30],[13,1,15,2],[13,3,15,15],[14,17,15,19],[14,20,15,30],[11,17,13,19],[11,20,13,28],[11,29,13,30],[11,1,12,3],[11,4,12,5],[11,6,12,6],[11,7,12,8],[20,3,20,10],[20,11,20,13],[20,14,20,16],[20,17,20,21],[22,24,22,26],[22,11,22,13],[23,17,23,21],[23,14,23,16],[24,27,24,30],[24,3,24,10],[24,11,24,13],[24,14,24,16],[24,17,24,21],[24,24,24,26],[23,24,23,26],[23,27,23,30],[23,3,23,10],[23,11,23,13],[19,22,24,23],[20,24,20,26],[22,3,22,10],[19,14,19,16],[5,33,6,68],[3,33,3,68],[1,4,1,20],[2,4,2,20],[22,14,22,16],[22,17,22,21],[20,27,20,30],[21,3,21,10],[21,11,21,13],[21,14,21,16],[21,17,21,21],[21,24,21,26],[21,27,21,30],[22,27,22,30],[19,17,19,21],[19,24,19,26]]}
[]
[null,"※",null,null,"に入力お願いします。(入力すると色が消えるようになっています。)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"記入例",null,null,null,null,null,null,null,null,"※請求書の取扱注意点"]
[null,null,null,null,"には入力しないでください。(緑の欄を入力すると反映されるようになっています。)"]
[null,null,null,null,null,null,null,null,null,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,"②この請求書及び請求書内訳明細書は※毎月20日締め切り25日までに当社へ必着とします。遅れますと次月払いとなりますのでご注意願います。"]
[null,null,null,null,"登録番号"]
[]
[null," (業者控)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"③支払日は毎月17日(AM9:00～PM4:00)です。ただし17日が休日の場合は翌営業日とします。"]
[]
[null,"西暦",null,null,null,null,"年",null,null,"月",null,null,"日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"④請求年月日、工事名、工事番号は必ず記入してください。(工事名、工事番号は当社現場担当者に確認してください。)"]
[null,"工事番号",null,null,null,null,"―",null,null,null,null,null,null,null,null,null,null,"会社名",null,null,null,null,null,null,null,null,null,null,null,"印"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"⑤社印は必ず捺印してください。"]
[null,"工事名"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"⑥小数点以下切り捨てとなっているため各会社ごとに計算方法の指定がある場合は、手入力してください。"]
[]
[]
[null,"月","日","名称",null,null,null,null,null,null,null,"契約",null,null,null,null,null,null,null,null,null,null,"税率",null,"出来高",null,null,null,null,null,null,null,null,"⑦可能であれば印刷する際は緑の塗りつぶしのみを消してカラーコピーをしてください。"]
[null,null,null,null,null,null,null,null,null,null,null,"数量",null,null,"単価",null,null,"金額",null,null,null,null,null,null,"数量(％)",null,null,"金額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"⑧小計、消費税、合計は自動的に計算されないため金額を計算し内訳明細書と表紙に入力してください。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(ROUNDDOWN(L24*O24,0)=0,\"\",ROUNDDOWN(L24*O24,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUNDDOWN(L25*O25,0)=0,\"\",ROUNDDOWN(L25*O25,0))","v":""}]

{"sheet":"表紙","index":1,"n_rows":128,"n_cols":34,"rows_kept":128,"cut":false,"hidden":false,"merged":[[94,20,95,29],[95,5,97,8],[79,27,79,33],[78,27,78,33],[78,24,78,26],[78,21,78,23],[77,13,77,20],[78,13,78,20],[78,5,78,12],[79,1,79,26],[78,3,78,4],[78,1,78,2],[77,3,77,4],[77,1,77,2],[80,27,80,33],[81,27,81,33],[81,1,81,26],[80,1,80,26],[87,5,87,10],[77,27,77,33],[85,24,85,33],[84,24,84,33],[83,24,83,33],[87,12,89,22],[76,27,76,33],[77,24,77,26],[76,24,76,26],[77,21,77,23],[76,21,76,23],[76,3,76,4],[76,1,76,2],[75,13,75,20],[75,5,75,12],[75,27,75,33],[75,24,75,26],[75,21,75,23],[76,13,76,20],[77,5,77,12],[76,5,76,12],[75,3,75,4],[75,1,75,2],[74,13,74,20],[74,21,74,23],[74,24,74,26],[74,27,74,33],[64,1,65,7],[64,8,65,16],[64,17,65,23],[64,24,65,33],[57,1,58,5],[57,6,58,22],[57,23,58,27],[59,1,59,33],[60,1,61,7],[60,8,61,16],[60,17,61,23],[60,24,61,33],[62,1,63,7],[62,8,63,16],[62,17,63,23],[62,24,63,33],[57,28,58,29],[66,1,67,7],[66,8,67,16],[66,17,67,23],[55,15,55,19],[55,20,55,33],[45,12,47,22],[48,1,48,4],[48,22,48,23],[48,24,48,26],[48,28,48,29],[48,31,48,32],[49,15,51,19],[49,20,51,33],[53,1,55,4],[52,1,52,4],[52,5,52,8],[53,5,55,8],[66,24,67,33],[57,32,58,33],[68,1,71,7],[68,8,71,16],[68,17,71,23],[68,24,69,25],[68,26,69,33],[70,24,71,25],[70,26,71,33],[24,8,27,16],[20,17,21,23],[22,24,23,33],[13,6,14,22],[10,20,10,33],[10,15,10,19],[11,20,11,33],[11,15,11,19],[8,30,9,33],[8,20,9,29],[20,24,21,33],[13,28,14,29],[22,17,23,23],[1,12,3,22],[2,5,2,10],[1,5,1,10],[54,15,54,19],[54,20,54,33],[24,1,27,7],[4,24,4,26],[4,28,4,29],[4,31,4,32],[4,22,4,23],[15,1,15,33],[16,1,17,7],[16,8,17,16],[16,17,17,23],[16,24,17,33],[5,15,7,19],[5,20,7,33],[8,15,9,19],[13,32,14,33],[4,1,4,4],[13,30,14,31],[13,23,14,27],[13,1,14,5],[52,9,52,12],[73,1,73,33],[74,1,74,2],[74,3,74,4],[74,5,74,12],[22,8,23,16],[20,8,21,16],[18,8,19,16],[22,1,23,7],[20,1,21,7],[18,1,19,7],[18,17,19,23],[57,30,58,31],[18,24,19,33],[45,5,45,10],[46,5,46,10],[26,24,27,25],[24,24,25,25],[26,26,27,33],[53,9,55,12],[52,15,53,19],[52,30,53,33],[52,20,53,29],[24,26,25,33],[24,17,27,23],[101,1,101,33],[102,1,103,7],[102,8,103,16],[102,17,103,23],[102,24,103,33],[91,15,93,19],[91,20,93,33],[94,15,95,19],[96,15,96,19],[96,20,96,33],[97,15,97,19],[97,20,97,33],[99,28,100,29],[99,30,100,31],[94,9,94,12],[94,5,94,8],[94,1,94,4],[99,32,100,33],[99,1,100,5],[99,6,100,22],[99,23,100,27],[95,1,97,4],[95,9,97,12],[94,30,95,33],[104,1,105,7],[104,8,105,16],[104,17,105,23],[104,24,105,33],[106,1,107,7],[106,8,107,16],[106,17,107,23],[106,24,107,33],[108,1,109,7],[108,8,109,16],[108,17,109,23],[108,24,109,33],[110,1,113,7],[110,8,113,16],[110,17,113,23],[110,24,111,25],[110,26,111,33],[112,24,113,25],[112,26,113,33],[115,1,115,33],[116,1,116,2],[116,3,116,4],[116,5,116,12],[116,13,116,20],[116,21,116,23],[116,24,116,26],[116,27,116,33],[126,18,126,23],[126,24,126,33],[127,18,127,23],[127,24,127,33],[125,1,127,2],[125,3,127,17],[117,13,117,20],[117,21,117,23],[117,24,117,26],[117,27,117,33],[118,1,118,2],[118,3,118,4],[118,5,118,12],[118,13,118,20],[118,21,118,23],[118,24,118,26],[118,27,118,33],[117,1,117,2],[117,3,117,4],[117,5,117,12],[122,1,122,26],[122,27,122,33],[123,1,123,26],[123,27,123,33],[125,18,125,23],[125,24,125,33],[121,1,121,26],[121,27,121,33],[119,1,119,2],[119,3,119,4],[119,5,119,12],[119,13,119,20],[119,21,119,23],[119,24,119,26],[119,27,119,33],[120,1,120,2],[120,3,120,4],[120,5,120,12],[120,13,120,20],[120,21,120,23],[120,24,120,26],[120,27,120,33],[90,1,90,4],[90,22,90,23],[90,24,90,26],[90,28,90,29],[90,31,90,32],[88,5,88,10],[83,1,85,2],[83,3,85,17],[85,18,85,23],[84,18,84,23],[83,18,83,23]]}
[]
[null,null,null,null,null,"業者コード",null,null,null,null,null,null,"請求書"]
[null,null,null,null,null,{"$f":"IF(内訳明細書!E2=\"\",\"\",内訳明細書!E2)","v":""}]
[]
[null,"(業者控)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"西暦",null,{"$f":"IF(内訳明細書!D7=\"\",\"\",内訳明細書!D7)","v":""},null,null,"年",{"$f":"IF(内訳明細書!H7=\"\",\"\",内訳明細書!H7)","v":""},null,"月",{"$f":"IF(内訳明細書!K7=\"\",\"\",内訳明細書!K7)","v":""},null,"日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,null,null,null,{"$f":"IF(内訳明細書!U5=\"\",\"\",内訳明細書!U5)","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"会社名",null,null,null,null,{"$f":"IF(内訳明細書!U8=\"\",\"\",内訳明細書!U8)","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,"TEL",null,null,null,null,{"$f":"IF(内訳明細書!U11=\"\",\"\",内訳明細書!U11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"登録番号",null,null,null,null,{"$f":"IF(内訳明細書!E4=\"\",\"\",内訳明細書!E4)","v":""}]
[]
[null,"工事名",null,null,null,null,{"$f":"IF(内訳明細書!D10=\"\",\"\",内訳明細書!D10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"工事番号",null,null,null,null,{"$f":"IF(内訳明細書!E8=\"\",\"\",内訳明細書!E8)","v":""},null,"ー",null,{"$f":"IF(内訳明細書!H8=\"\",\"\",内訳明細書!H8)","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,{"$f":"IF(F3=0,\"\",F3)","v":""}]
[]
[null,"(現場控)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"西暦",null,{"$f":"IF(Y5=\"\",\"\",Y5)","v":""},null,null,"年",{"$f":"IF(AC5=\"\",\"\",AC5)","v":""},null,"月",{"$f":"IF(AF5=\"\",\"\",AF5)","v":""},null,"日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,null,null,null,{"$f":"IF(U6=\"\",\"\",U6)","v":""}]
[]
[]
[null,"承認",null,null,null,"所属長",null,null,null,"担当",null,null,null,null,null,"会社名",null,null,null,null,{"$f":"IF(U9=\"\",\"\",U9)","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,"TEL",null,null,null,null,{"$f":"IF(U11=\"\",\"\",U11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"登録番号",null,null,null,null,{"$f":"IF(U12=\"\",\"\",U12)","v":""}]
[]
[null,"工事名",null,null,null,null,{"$f":"IF(G14=\"\",\"\",G14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"工事番号",null,null,null,null,{"$f":"IF(AC14=\"\",\"\",AC14)","v":""},null,"ー",null,{"$f":"IF(AG14=\"\",\"\",AG14)","v":""}]
[]
[null,"今月分"]
[null,"契約金額(税抜)",null,null,null,null,null,null,{"$f":"IF(I17=\"\",\"\",I17)","v":""},null,null,null,null,null,null,null,null,"出来高査定金額"]
[]
[null,"前月までの請求金額",null,null,null,null,null,null,{"$f":"IF(I19=\"\",\"\",I19)","v":""},null,null,null,null,null,null,null,null,"消費税額"]
[]
[null,"請求金額Ⓐ",null,null,null,null,null,null,{"$f":"IF(I21=\"\",\"\",I21)","v":""},null,null,null,null,null,null,null,null,"立替払金額(税込)"]
[]
[null,"消費税額Ⓑ",null,null,null,null,null,null,{"$f":"IF(I23=\"\",\"\",I23)","v":""},null,null,null,null,null,null,null,null,"差引支払金額"]
[]
[null,"合計金額Ⓒ",null,null,null,null,null,null,{"$f":"IF(I25=\"\",\"\",I25)","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,{"$f":"IF(F3=0,\"\",F3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA3=\"\",\"\",AA3)","v":""}]
[]
[null,"(経理控)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"西暦",null,{"$f":"IF(Y5=\"\",\"\",Y5)","v":""},null,null,"年",{"$f":"IF(AC5=\"\",\"\",AC5)","v":""},null,"月",{"$f":"IF(AF5=\"\",\"\",AF5)","v":""},null,"日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,null,null,null,{"$f":"IF(U6=\"\",\"\",U6)","v":""}]
[]
[]
[null,"承認",null,null,null,"所属長",null,null,null,"担当",null,null,null,null,null,"会社名",null,null,null,null,{"$f":"IF(U9=\"\",\"\",U9)","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,"TEL",null,null,null,null,{"$f":"IF(U11=\"\",\"\",U11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"登録番号",null,null,null,null,{"$f":"IF(U12=\"\",\"\",U12)","v":""}]
[]
[null,"工事名",null,null,null,null,{"$f":"IF(G14=\"\",\"\",G14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"工事番号",null,null,null,null,{"$f":"IF(AC14=\"\",\"\",AC14)","v":""},null,"ー",null,{"$f":"IF(AG14=\"\",\"\",AG14)","v":""}]
[]
[null,"今月分"]
[null,"契約金額(税抜)",null,null,null,null,null,null,{"$f":"IF(I17=\"\",\"\",I17)","v":""},null,null,null,null,null,null,null,null,"出来高査定金額"]
[]
[null,"前月までの請求金額",null,null,null,null,null,null,{"$f":"IF(I19=\"\",\"\",I19)","v":""},null,null,null,null,null,null,null,null,"消費税額"]
[]
[null,"請求金額Ⓐ",null,null,null,null,null,null,{"$f":"IF(I21=\"\",\"\",I21)","v":""},null,null,null,null,null,null,null,null,"立替払金額(税込)"]
[]
[null,"消費税額Ⓑ",null,null,null,null,null,null,{"$f":"IF(I23=\"\",\"\",I23)","v":""},null,null,null,null,null,null,null,null,"差引支払金額"]
[]
[null,"合計金額Ⓒ",null,null,null,null,null,null,{"$f":"IF(I25=\"\",\"\",I25)","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,"(計)"]

{"sheet":"内訳明細書","index":2,"n_rows":104,"n_cols":31,"rows_kept":104,"cut":false,"hidden":false,"merged":[[102,26,102,31],[101,26,101,31],[100,26,100,31],[99,26,99,31],[98,26,98,31],[97,26,97,31],[96,26,96,31],[95,26,95,31],[94,26,94,31],[97,17,97,22],[96,17,96,22],[95,17,95,22],[94,17,94,22],[93,17,93,22],[92,17,92,22],[91,17,91,22],[90,17,90,22],[89,17,89,22],[97,23,97,25],[96,23,96,25],[95,23,95,25],[94,23,94,25],[93,23,93,25],[92,23,92,25],[91,23,91,25],[90,23,90,25],[89,23,89,25],[66,17,66,22],[67,17,67,22],[68,17,68,22],[66,23,68,25],[66,26,66,31],[67,26,67,31],[68,26,68,31],[84,17,84,22],[83,11,83,22],[83,23,83,31],[84,26,84,31],[84,23,84,25],[73,26,73,27],[73,23,73,24],[55,26,55,31],[54,26,54,31],[53,26,53,31],[52,26,52,31],[51,26,51,31],[50,23,50,25],[65,23,65,25],[64,23,64,25],[63,23,63,25],[62,23,62,25],[61,23,61,25],[60,23,60,25],[59,23,59,25],[58,23,58,25],[57,23,57,25],[56,23,56,25],[55,23,55,25],[54,23,54,25],[53,23,53,25],[52,23,52,25],[51,23,51,25],[65,26,65,31],[64,26,64,31],[62,26,62,31],[61,26,61,31],[60,26,60,31],[59,26,59,31],[58,26,58,31],[57,26,57,31],[68,1,68,16],[20,3,20,10],[28,14,28,16],[21,14,21,16],[22,11,22,13],[21,11,21,13],[31,1,31,16],[32,1,32,16],[33,1,33,16],[20,11,20,13],[20,14,20,16],[23,3,23,10],[23,11,23,13],[23,14,23,16],[26,3,26,10],[26,11,26,13],[26,14,26,16],[56,26,56,31],[65,17,65,22],[64,17,64,22],[63,17,63,22],[62,17,62,22],[61,17,61,22],[94,3,94,10],[94,11,94,13],[84,14,84,16],[85,3,85,10],[86,3,86,10],[86,11,86,13],[86,14,86,16],[77,1,78,3],[79,3,81,15],[85,11,85,13],[85,14,85,16],[80,17,81,19],[80,20,81,31],[74,6,75,8],[73,9,73,11],[73,6,73,8],[83,1,84,1],[83,2,84,2],[63,26,63,31],[85,23,85,25],[86,23,86,25],[88,23,88,25],[87,23,87,25],[85,17,85,22],[86,17,86,22],[87,17,87,22],[88,17,88,22],[93,26,93,31],[92,26,92,31],[91,26,91,31],[90,26,90,31],[89,26,89,31],[88,26,88,31],[87,26,87,31],[86,26,86,31],[85,26,85,31],[83,3,84,10],[84,11,84,13],[77,4,78,5],[77,6,78,6],[77,7,78,8],[17,3,17,10],[16,3,16,10],[16,17,16,22],[18,23,18,25],[17,23,17,25],[16,23,16,25],[21,23,21,25],[20,23,20,25],[19,23,19,25],[18,3,18,10],[18,11,18,13],[18,14,18,16],[19,3,19,10],[19,11,19,13],[19,14,19,16],[24,3,24,10],[24,11,24,13],[24,14,24,16],[27,14,27,16],[27,3,27,10],[7,30,9,31],[3,4,3,11],[6,1,6,2],[10,17,11,19],[10,20,11,31],[6,3,6,5],[4,17,6,19],[4,20,6,31],[6,7,6,8],[6,10,6,11],[7,20,9,29],[7,1,8,3],[7,4,8,5],[7,6,8,6],[7,7,8,8],[7,17,9,19],[25,3,25,10],[25,11,25,13],[25,14,25,16],[27,11,27,13],[13,23,13,31],[19,17,19,22],[18,17,18,22],[0,4,0,7],[15,3,15,10],[15,11,15,13],[15,14,15,16],[17,11,17,13],[17,14,17,16],[4,1,4,3],[13,1,14,1],[13,2,14,2],[13,3,14,10],[14,11,14,13],[14,14,14,16],[9,1,11,2],[9,3,11,15],[1,4,1,7],[2,4,2,7],[0,9,2,22],[16,11,16,13],[16,14,16,16],[17,17,17,22],[13,11,13,22],[15,17,15,22],[30,17,30,22],[29,17,29,22],[45,17,46,19],[45,20,46,31],[39,17,41,19],[39,1,39,3],[39,9,40,11],[39,6,40,8],[42,20,44,29],[42,17,44,19],[42,30,44,31],[28,3,28,10],[48,1,49,1],[48,2,49,2],[48,3,49,10],[49,11,49,13],[49,14,49,16],[42,1,43,3],[42,4,43,5],[42,6,43,6],[42,7,43,8],[44,1,46,2],[44,3,46,15],[29,14,29,16],[28,11,28,13],[38,9,38,11],[38,6,38,8],[30,3,30,10],[30,11,30,13],[30,14,30,16],[29,3,29,10],[29,11,29,13],[51,3,51,10],[51,11,51,13],[51,14,51,16],[50,3,50,10],[50,11,50,13],[50,14,50,16],[50,26,50,31],[53,3,53,10],[53,11,53,13],[53,14,53,16],[52,3,52,10],[52,11,52,13],[52,14,52,16],[53,17,53,22],[52,17,52,22],[51,17,51,22],[55,3,55,10],[55,11,55,13],[55,14,55,16],[54,3,54,10],[54,11,54,13],[54,14,54,16],[55,17,55,22],[54,17,54,22],[57,3,57,10],[57,11,57,13],[57,14,57,16],[56,3,56,10],[56,11,56,13],[56,14,56,16],[57,17,57,22],[56,17,56,22],[59,3,59,10],[59,11,59,13],[59,14,59,16],[58,3,58,10],[58,11,58,13],[58,14,58,16],[59,17,59,22],[58,17,58,22],[61,3,61,10],[61,11,61,13],[61,14,61,16],[62,3,62,10],[62,11,62,13],[60,3,60,10],[60,11,60,13],[60,14,60,16],[60,17,60,22],[91,14,91,16],[91,11,91,13],[90,11,90,13],[90,14,90,16],[89,11,89,13],[89,14,89,16],[88,14,88,16],[88,3,88,10],[88,11,88,13],[90,3,90,10],[89,3,89,10],[74,1,74,3],[73,19,73,21],[74,17,76,19],[74,20,76,31],[74,9,75,11],[73,17,73,18],[65,3,65,10],[93,3,93,10],[93,11,93,13],[93,14,93,16],[95,11,95,13],[95,14,95,16],[98,3,98,10],[98,11,98,13],[98,14,98,16],[99,3,99,10],[99,11,99,13],[99,14,99,16],[97,3,97,10],[97,11,97,13],[97,14,97,16],[96,3,96,10],[96,11,96,13],[96,14,96,16],[95,3,95,10],[99,23,99,25],[98,23,98,25],[99,17,99,22],[98,17,98,22],[100,3,100,10],[100,11,100,13],[100,14,100,16],[101,1,101,16],[103,1,103,16],[102,1,102,16],[100,23,100,25],[100,17,100,22],[103,17,103,22],[102,17,102,22],[101,17,101,22],[101,23,103,25],[103,26,103,31],[77,17,79,19],[77,30,79,31],[94,14,94,16],[22,3,22,10],[21,3,21,10],[22,14,22,16],[35,9,37,22],[70,9,72,22],[63,11,63,13],[63,14,63,16],[66,1,66,16],[67,1,67,16],[64,3,64,10],[64,11,64,13],[64,14,64,16],[62,14,62,16],[63,3,63,10],[77,20,79,29],[79,1,81,2],[92,3,92,10],[92,14,92,16],[92,11,92,13],[91,3,91,10],[65,11,65,13],[65,14,65,16],[87,3,87,10],[87,11,87,13],[87,14,87,16],[23,23,23,25],[22,23,22,25],[14,23,14,25],[14,26,14,31],[14,17,14,22],[24,26,24,31],[23,26,23,31],[22,26,22,31],[21,26,21,31],[20,26,20,31],[19,26,19,31],[18,26,18,31],[17,26,17,31],[30,23,30,25],[29,23,29,25],[28,23,28,25],[27,23,27,25],[26,23,26,25],[25,23,25,25],[28,17,28,22],[27,17,27,22],[26,17,26,22],[25,17,25,22],[24,17,24,22],[23,17,23,22],[22,17,22,22],[21,17,21,22],[20,17,20,22],[15,23,15,25],[15,26,15,31],[16,26,16,31],[30,26,30,31],[29,26,29,31],[28,26,28,31],[27,26,27,31],[26,26,26,31],[25,26,25,31],[24,23,24,25],[49,17,49,22],[49,23,49,25],[49,26,49,31],[50,17,50,22],[31,17,31,22],[32,17,32,22],[33,17,33,22],[33,26,33,31],[32,26,32,31],[31,26,31,31],[31,23,33,25],[48,11,48,22],[48,23,48,31],[38,23,38,24],[38,26,38,27],[38,17,38,18],[38,19,38,21],[39,20,41,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,null,"年",null,null,"月",null,null,"日"]
[null,"工事番号",null,null,null,null,"―",null,null,null,null,null,null,null,null,null,null,"会社名",null,null,null,null,null,null,null,null,null,null,null,null,"印"]
[]
[null,"工事名"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEL"]
[]
[]
[null,"月","日","名称",null,null,null,null,null,null,null,"契約",null,null,null,null,null,null,null,null,null,null,null,"出来高"]
[null,null,null,null,null,null,null,null,null,null,null,"数量",null,null,"単価",null,null,"金額",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(ROUNDDOWN(L16*O16,0)=0,\"\",ROUNDDOWN(L16*O16,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUNDDOWN(L17*O17,0)=0,\"\",ROUNDDOWN(L17*O17,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,{"$f":"SUM(R16:W31)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AA16:AF31)","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,{"$f":"IF(D7=\"\",\"\",D7)","v":""},null,null,"年",{"$f":"IF(H7=\"\",\"\",H7)","v":""},null,"月",{"$f":"IF(K7=\"\",\"\",K7)","v":""},null,"日"]
[null," (現場控)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,null,{"$f":"IF(U5=\"\",\"\",U5)","v":""}]
[]
[]
[null,"工事番号",null,null,{"$f":"IF(E8=\"\",\"\",E8)","v":""},null,"―",{"$f":"IF(H8=\"\",\"\",H8)","v":""},null,null,null,null,null,null,null,null,null,"会社名",null,null,{"$f":"IF(U8=\"\",\"\",U8)","v":""},null,null,null,null,null,null,null,null,null,"印"]
[]
[null,"工事名",null,{"$f":"IF(D10=\"\",\"\",D10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEL",null,null,{"$f":"IF(U11=\"\",\"\",U11)","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,{"$f":"IF(B16=\"\",\"\",B16)","v":""},{"$f":"IF(C16=\"\",\"\",C16)","v":""},{"$f":"IF(D16=\"\",\"\",D16)","v":""},null,null,null,null,null,null,null,{"$f":"IF(L16=\"\",\"\",L16)","v":""},null,null,{"$f":"IF(O16=\"\",\"\",O16)","v":""},null,null,{"$f":"IF(R16=\"\",\"\",R16)","v":""},null,null,null,null,null,{"$f":"IF(X16=\"\",\"\",X16)","v":""},null,null,{"$f":"IF(AA16=\"\",\"\",AA16)","v":""}]
[null,{"$f":"IF(B17=\"\",\"\",B17)","v":""},"","",null,null,null,null,null,null,null,{"$f":"IF(L17=\"\",\"\",L17)","v":""},null,null,{"$f":"IF(O17=\"\",\"\",O17)","v":""},null,null,{"$f":"IF(R17=\"\",\"\",R17)","v":""},null,null,null,null,null,{"$f":"IF(X17=\"\",\"\",X17)","v":""},null,null,{"$f":"IF(AA17=\"\",\"\",AA17)","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,{"$f":"IF(B22=\"\",\"\",B22)","v":""},"","",null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(B23=\"\",\"\",B23)","v":""},"","",null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(B24=\"\",\"\",B24)","v":""},"","",null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(B25=\"\",\"\",B25)","v":""},"","",null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(B26=\"\",\"\",B26)","v":""},"","",null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(B27=\"\",\"\",B27)","v":""},"","",null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(B28=\"\",\"\",B28)","v":""},"","",null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(B29=\"\",\"\",B29)","v":""},"","",null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(B30=\"\",\"\",B30)","v":""},"","",null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(B31=\"\",\"\",B31)","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,{"$f":"IF(R32=\"\",\"\",R32)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AA32=\"\",\"\",AA32)","v":0}]
[null,"消費税額Ⓑ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R33=\"\",\"\",R33)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AA33=\"\",\"\",AA33)","v":""}]
[null,"合計Ⓒ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R34=\"\",\"\",R34)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AA34=\"\",\"\",AA34)","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,{"$f":"IF(D7=\"\",\"\",D7)","v":""},null,null,"年",{"$f":"IF(H7=\"\",\"\",H7)","v":""},null,"月",{"$f":"IF(K7=\"\",\"\",K7)","v":""},null,"日"]
[null," (経理控)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,null,{"$f":"IF(U5=\"\",\"\",U5)","v":""}]
[]
[]
[null,"工事番号",null,null,{"$f":"IF(E8=\"\",\"\",E8)","v":""},null,"―",{"$f":"IF(H8=\"\",\"\",H8)","v":""},null,null,null,null,null,null,null,null,null,"会社名",null,null,{"$f":"IF(U8=\"\",\"\",U8)","v":""},null,null,null,null,null,null,null,null,null,"印"]
[]
[null,"工事名",null,{"$f":"IF(D10=\"\",\"\",D10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEL",null,null,{"$f":"IF(U11=\"\",\"\",U11)","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,{"$f":"IF(B16=\"\",\"\",B16)","v":""},{"$f":"IF(C16=\"\",\"\",C16)","v":""},{"$f":"IF(D16=\"\",\"\",D16)","v":""},null,null,null,null,null,null,null,{"$f":"IF(L16=\"\",\"\",L16)","v":""},null,null,{"$f":"IF(O16=\"\",\"\",O16)","v":""},null,null,{"$f":"IF(R16=\"\",\"\",R16)","v":""},null,null,null,null,null,{"$f":"IF(X16=\"\",\"\",X16)","v":""},null,null,{"$f":"IF(AA16=\"\",\"\",AA16)","v":""}]
[null,{"$f":"IF(B17=\"\",\"\",B17)","v":""},"","",null,null,null,null,null,null,null,"",null,null,{"$f":"IF(O17=\"\",\"\",O17)","v":""},null,null,{"$f":"IF(R17=\"\",\"\",R17)","v":""},null,null,null,null,null,{"$f":"IF(X17=\"\",\"\",X17)","v":""},null,null,{"$f":"IF(AA17=\"\",\"\",AA17)","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,{"$f":"IF(L20=\"\",\"\",L20)","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,{"$f":"IF(AA31=\"\",\"\",AA31)","v":""}]
[null,"小計Ⓐ(税抜)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R32=\"\",\"\",R32)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AA32=\"\",\"\",AA32)","v":0}]
[null,"消費税額Ⓑ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R33=\"\",\"\",R33)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AA33=\"\",\"\",AA33)","v":""}]
[null,"合計Ⓒ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R34=\"\",\"\",R34)","v":""},null,null,null,null,null,null,null,null,""]