{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["その他CD","登録①-工事№","入力①→印刷①-合計請求書(出来高)","印刷②-工事別請求書(出来高)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":10,"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":"その他CD","index":0,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["追加分他"]
[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]

{"sheet":"登録①-工事№","index":1,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["工事№","工　　　事　　　名","担当者(任意入力)"]

{"sheet":"入力①→印刷①-合計請求書(出来高)","index":2,"n_rows":77,"n_cols":19,"rows_kept":77,"cut":false,"hidden":false,"merged":[[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[47,4,47,5],[57,4,57,5],[48,4,48,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[52,4,52,5],[75,4,75,5],[6,1,6,6],[13,5,13,6],[10,2,10,5],[17,4,17,5],[8,2,8,6],[9,2,9,6],[11,2,11,6],[12,2,12,6],[67,4,67,5],[68,4,68,5],[71,4,71,5],[62,4,62,5],[63,4,63,5],[64,4,64,5],[65,4,65,5],[11,8,13,8],[11,9,13,11],[72,4,72,5],[73,4,73,5],[74,4,74,5],[66,4,66,5],[58,4,58,5],[59,4,59,5],[60,4,60,5],[61,4,61,5],[70,4,70,5],[69,4,69,5],[53,4,53,5],[54,4,54,5],[55,4,55,5],[56,4,56,5],[0,2,1,6],[0,16,0,18],[0,9,0,11],[9,15,10,15],[9,16,10,16],[9,17,10,17],[7,2,7,3],[7,5,7,6],[2,16,5,16],[2,17,5,17],[2,18,5,18],[13,16,14,16],[13,17,14,17],[13,18,14,18],[7,15,8,15],[7,16,8,16],[7,17,8,17],[7,18,8,18],[11,15,12,15],[11,16,12,16],[11,17,12,17],[11,18,12,18],[9,18,10,18],[13,15,14,15]]}
[null,null,"合　 計　 請　 求　 書　（ 出　来　高 ）",null,null,null,null,null,null,"締　　　　日",null,null,null,null,null,null,"支　　払　　処　　理"]
[null,null,null,null,null,null,null,null,null,"令　　和",null,"年",null,null,null,null,"支払決裁者","ﾃﾞｰﾀ照合担当者","入力担当者"]
[null,null,null,null,null,null,null,null,null,null,null,"月"]
[null,null,null,null,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(C8=\"\",\"\",TEXT(C8,\"[<=9999]0000;[<=9999]0000;0000\"))","v":""},0.08,{"$f":"SUMIF($O$19:$O$76,\"8%\",$N$19:$N$76)","v":0},{"$f":"SUMIF($O$19:$O$76,\"8%\",$P$19:$P$76)","v":0},{"$f":"SUMIF($O$19:$O$76,\"8%\",$Q$19:$Q$76)","v":0},null,null,null,"支払金額\n出来高分"]
[null,"郵便番号",null,null,null,null,null,{"$f":"IF(C9=\"\",\"\",TEXT(C9,\"[<=9999]0000;[<=9999]0000;0000\"))","v":""},0.1,{"$f":"SUMIF($O$19:$O$76,\"10%\",$N$19:$N$76)","v":0},{"$f":"SUMIF($O$19:$O$76,\"10%\",$P$19:$P$76)","v":0},{"$f":"SUMIF($O$19:$O$76,\"10%\",$Q$19:$Q$76)","v":0}]
[null,"住　　　所",null,null,null,null,null,"","合 計",{"$f":"SUM($J$8:$J$9)","v":0},{"$f":"SUM($K$8:$K$9)","v":0},{"$f":"SUM($L$8:$L$9)","v":0},null,null,null,"支払金額\n材料・常用分"]
[null,"名　　　称",null,null,null,null,"印",""]
[null,"Ｔ　Ｅ　Ｌ",null,null,null,null,null,"","合計請求金額\n（税込）",{"$f":"SUM(Q18:Q75)","v":0},null,null,null,null,null,"相殺分など"]
[null,"Ｆ　Ａ　Ｘ",null,null,null,null,null,""]
[null,"消費税及び\n地方消費税",0.08,0.1,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,"①契約金額\n（税抜）","変更金額\n（税抜）","①契約金額\n【変更後】\n（税抜）","②累計出来高\n（税抜）","③保留金\n解除","④既受領金額\n（税抜）","③保留金額\n（税抜）","⑤当月出来高\n（税抜）","消費\n税率","⑥消費税及び\n地方消費税","⑦合計請求金額（税込）","⑧請求残高（税抜）","査定処理\n訂正金額\n（税込）"]
[{"$f":"IF(C19=\"\",\"\",CONCATENATE(TEXT(C19,\"[<=999]000;[<=999]000;000\"),\"-\",TEXT(D19,\"[<=99]00;[<=9999999]0000000-00;0000000-00\")))","v":""},null,null,null,{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,工事ﾘｽﾄ,2,FALSE))","v":""},null,null,null,{"$f":"IF(H19=\"\",\"\",G19+H19)","v":""},null,null,null,{"$f":"IF(K19=\"○\",\"\",ROUNDDOWN(J19*0.1,0))","v":0},{"$f":"IF(G19=\"\",\"\",IF(K19=\"○\",J19-L19,J19-(M19+L19)))","v":""},null,{"$f":"IF(N19=\"\",\"\",ROUND(N19*$O19,0))","v":""},{"$f":"IF(N19=\"\",\"\",N19+P19)","v":""},{"$f":"IF(AND(G19=\"\",Q19=\"\"),\"\",IF(G19=\"\",J19-N19,IF(H19=\"\",G19-L19-N19,I19-L19-N19)))","v":""}]
[{"$f":"IF(C20=\"\",\"\",CONCATENATE(TEXT(C20,\"[<=999]000;[<=999]000;000\"),\"-\",TEXT(D20,\"[<=99]00;[<=9999999]0000000-00;0000000-00\")))","v":""},null,null,null,"",null,null,null,{"$f":"IF(H20=\"\",\"\",G20+H20)","v":""},null,null,null,{"$f":"IF(K20=\"○\",\"\",ROUNDDOWN(J20*0.1,0))","v":0},{"$f":"IF(G20=\"\",\"\",IF(K20=\"○\",J20-L20,J20-(M20+L20)))","v":""},null,{"$f":"IF(N20=\"\",\"\",ROUND(N20*$O20,0))","v":""},{"$f":"IF(N20=\"\",\"\",N20+P20)","v":""},{"$f":"IF(AND(G20=\"\",Q20=\"\"),\"\",IF(G20=\"\",J20-N20,IF(H20=\"\",G20-L20-N20,I20-L20-N20)))","v":""}]
["",null,null,null,{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,工事ﾘｽﾄ,2,FALSE))","v":""},null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",0,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,{"$f":"IF(D29=\"\",\"\",VLOOKUP(D29,工事ﾘｽﾄ,2,FALSE))","v":""},null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,{"$f":"IF(D51=\"\",\"\",VLOOKUP(D51,工事ﾘｽﾄ,2,FALSE))","v":""},null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
["",null,null,null,"",null,null,null,"",null,null,null,0,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G77=\"\",Q77=\"\"),\"\",IF(G77=\"\",J77-N77,IF(H77=\"\",G77-L77-N77,I77-L77-N77)))","v":""}]

{"sheet":"印刷②-工事別請求書(出来高)","index":3,"n_rows":120,"n_cols":35,"rows_kept":120,"cut":false,"hidden":false,"merged":[[118,1,118,22],[119,3,119,9],[119,10,119,11],[119,12,119,13],[119,14,119,22],[114,8,114,9],[122,3,122,9],[122,10,122,11],[122,12,122,13],[115,8,115,13],[116,8,116,13],[114,2,114,6],[115,2,115,6],[116,2,116,6],[123,3,123,9],[123,10,123,11],[123,12,123,13],[120,3,120,9],[120,10,120,11],[120,12,120,13],[121,3,121,9],[121,10,121,11],[121,12,121,13],[111,8,111,13],[112,8,112,13],[113,8,113,13],[109,1,109,6],[109,8,109,13],[109,14,109,22],[110,2,110,6],[111,2,111,6],[112,2,112,6],[113,2,113,6],[109,26,109,34],[110,8,110,13],[103,33,103,34],[105,1,105,5],[105,26,105,28],[106,26,107,28],[106,29,107,30],[106,31,107,34],[103,1,104,5],[103,6,104,15],[103,26,103,28],[103,29,103,30],[103,31,103,32],[106,2,106,6],[107,2,107,6],[105,29,105,34],[102,1,102,5],[102,26,102,28],[102,29,102,30],[102,31,102,32],[102,33,102,34],[98,31,99,31],[98,32,99,32],[98,33,99,33],[98,34,99,34],[101,26,101,28],[101,29,101,30],[101,31,101,32],[101,33,101,34],[98,26,99,26],[98,27,99,27],[98,28,99,28],[98,29,99,29],[98,30,99,30],[97,1,97,3],[97,5,97,8],[97,9,97,11],[97,12,97,15],[97,26,97,34],[93,1,93,3],[93,5,93,15],[93,26,95,28],[93,29,95,31],[93,32,95,34],[94,1,94,3],[94,5,94,15],[95,1,96,3],[95,5,96,15],[91,1,91,3],[91,26,91,34],[92,26,92,28],[92,29,92,31],[92,32,92,34],[80,3,80,9],[80,10,80,11],[80,12,80,13],[81,3,81,9],[81,10,81,11],[81,12,81,13],[90,25,90,27],[84,3,85,22],[78,3,78,9],[78,10,78,11],[78,12,78,13],[79,3,79,9],[79,10,79,11],[79,12,79,13],[76,1,76,22],[77,3,77,9],[77,10,77,11],[77,12,77,13],[77,14,77,22],[72,8,72,9],[73,8,73,13],[74,8,74,13],[69,8,69,13],[70,8,70,13],[71,8,71,13],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[73,2,73,6],[74,2,74,6],[67,1,67,6],[67,8,67,13],[67,14,67,22],[67,26,67,34],[68,8,68,13],[61,33,61,34],[63,1,63,5],[63,26,63,28],[64,26,65,28],[64,29,65,30],[64,31,65,34],[61,1,62,5],[61,6,62,15],[61,26,61,28],[61,29,61,30],[61,31,61,32],[64,2,64,6],[65,2,65,6],[68,2,68,6],[63,29,63,34],[60,1,60,5],[60,26,60,28],[60,29,60,30],[60,31,60,32],[60,33,60,34],[56,31,57,31],[56,32,57,32],[56,33,57,33],[56,34,57,34],[59,26,59,28],[59,29,59,30],[59,31,59,32],[59,33,59,34],[56,26,57,26],[56,27,57,27],[56,28,57,28],[56,29,57,29],[56,30,57,30],[48,25,48,27],[14,31,15,31],[9,29,11,31],[17,26,17,28],[18,26,18,28],[19,26,19,28],[21,26,21,28],[17,33,17,34],[18,33,18,34],[21,29,21,34],[19,33,19,34],[55,1,55,3],[55,5,55,8],[55,9,55,11],[55,12,55,15],[55,26,55,34],[51,1,51,3],[51,5,51,15],[51,26,53,28],[51,29,53,31],[51,32,53,34],[52,1,52,3],[52,5,52,15],[53,1,54,3],[53,5,54,15],[42,5,43,19],[49,1,49,3],[49,26,49,34],[50,26,50,28],[50,29,50,31],[50,32,50,34],[20,17,20,23],[11,1,12,3],[13,1,13,3],[13,9,13,11],[13,5,13,8],[25,26,25,34],[14,32,15,32],[14,33,15,33],[14,34,15,34],[13,26,13,34],[14,26,15,26],[14,27,15,27],[14,28,15,28],[14,29,15,29],[14,30,15,30],[22,31,23,34],[22,26,23,28],[9,32,11,34],[0,5,1,19],[11,5,12,15],[10,5,10,15],[9,5,9,15],[13,12,13,15],[6,17,6,23],[22,29,23,30],[9,26,11,28],[6,25,6,27],[4,17,4,23],[5,17,5,23],[19,1,20,5],[18,1,18,5],[8,26,8,28],[8,29,8,31],[17,29,17,30],[17,31,17,32],[18,29,18,30],[18,31,18,32],[19,29,19,30],[19,31,19,32],[7,1,7,3],[8,32,8,34],[7,26,7,34],[39,10,39,11],[39,12,39,13],[36,3,36,9],[37,3,37,9],[38,3,38,9],[39,3,39,9],[36,10,36,11],[36,12,36,13],[37,10,37,11],[37,12,37,13],[35,14,35,22],[23,2,23,6],[22,2,22,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[46,17,46,23],[47,17,47,23],[48,17,48,23],[62,17,62,23],[9,1,9,3],[10,1,10,3],[25,8,25,13],[26,8,26,13],[27,8,27,13],[28,8,28,13],[29,8,29,13],[25,1,25,6],[31,8,31,13],[32,8,32,13],[21,1,21,5],[19,6,20,15],[25,14,25,22],[30,8,30,9],[34,1,34,22],[35,3,35,9],[35,10,35,11],[35,12,35,13],[38,10,38,11],[38,12,38,13]]}
[null,null,null,null,null,"工事別請求書（出来高）  【正】"]
[]
[]
[null,null,null,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('入力①→印刷①-合計請求書(出来高)'!$K$2=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$K$2)","v":""},"年",{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$K$3=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$K$3)","v":""},"月",{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$K$4=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$K$4)","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,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,1,1))","v":""},{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,2,1))","v":""},{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,3,1))","v":""},{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,4,1))","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('入力①→印刷①-合計請求書(出来高)'!$H$9=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$9)","v":""},null,null,null,null,null,null,null,null,null,null,null,"☆","請求書です。",null,null,null,null,"☆"]
[null,"住所",null,null,null,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$10=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$10)","v":""},null,null,null,null,null,null,null,null,null,null,null,"☆","工事番号ごとに請求書を",null,null,null,null,"☆"]
[null,"名称",null,null,null,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$11=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$11)","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,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$12=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$12)","v":""},null,null,null,"ＦＡＸ",null,null,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$13=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$13)","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,1,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,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-2,1)))","v":""},"－",{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2)),1)))","v":""},null,"☆","必ず提出してください。",null,null,null,null,"☆",null,null,"科目ｺｰﾄﾞ",null,null,111,null,"112-1",null,113]
[null,"工　　　事　　　名",null,null,null,null,{"$f":"IF($B$18=\"\",\"\",INDEX(発注CD材料,$B$18,3))","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,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-9<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-9,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1)),1)))","v":""},null,null,null,null,null,null,null,null,null,null,"科目",null,null,"経費（該当する科目番号を記入）"]
[null,"①","契約金額（税抜）",null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5)),1)))","v":""},null,null,null,null,null,null,null,null,null,null,"科目ｺｰﾄﾞ",null,null,"222～248"]
[null,null,"変更後契約金額（税抜）",null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7)),1)))","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($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8)),1)))","v":""}]
[null,"③","保留金額",null,null,null,null,"抜","②累計出来高×１０％",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11)),1)))","v":"0"}]
[null,"④","既受領金額",null,null,null,null,"抜",null,null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10)),1)))","v":""}]
[null,"⑤","当月出来高",null,null,null,null,"抜","②累計出来高－（③保留金額＋④既受領金）",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12)),1)))","v":""}]
[null,"⑥","消費税及び地方消費税",null,null,null,null,null,"⑤当月出来高×",null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13)),1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14)),1)))","v":""}]
[null,"⑦","合計請求金額",null,null,null,null,"込","⑤当月出来高＋⑥消費税及び地方消費税",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15)),1)))","v":""}]
[null,"⑧","請求残高",null,null,null,null,"抜","①契約金額－④既受領金－⑤当月出来高",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16)),1)))","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('入力①→印刷①-合計請求書(出来高)'!$K$2=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$K$2)","v":""},"年",{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$K$3=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$K$3)","v":""},"月",{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$K$4=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$K$4)","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,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,1,1))","v":""},{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,2,1))","v":""},{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,3,1))","v":""},{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,4,1))","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('入力①→印刷①-合計請求書(出来高)'!$H$9=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$9)","v":""},null,null,null,null,null,null,null,null,null,null,null,"☆","請求書です。",null,null,null,null,"☆"]
[null,"住所",null,null,null,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$10=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$10)","v":""},null,null,null,null,null,null,null,null,null,null,null,"☆","工事番号ごとに請求書を",null,null,null,null,"☆"]
[null,"名称",null,null,null,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$11=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$11)","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,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$12=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$12)","v":""},null,null,null,"ＦＡＸ",null,null,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$13=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$13)","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,1,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,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-2,1)))","v":""},"－",{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2)),1)))","v":""},null,"☆","必ず提出してください。",null,null,null,null,"☆",null,null,"科目ｺｰﾄﾞ",null,null,111,null,"112-1",null,113]
[null,"工　　　事　　　名",null,null,null,null,{"$f":"IF($B$18=\"\",\"\",INDEX(発注CD材料,$B$18,3))","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,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-9<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-9,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1)),1)))","v":""},null,null,null,null,null,null,null,null,null,null,"科目",null,null,"経費（該当する科目番号を記入）"]
[null,"①","契約金額（税抜）",null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5)),1)))","v":""},null,null,null,null,null,null,null,null,null,null,"科目ｺｰﾄﾞ",null,null,"222～248"]
[null,null,"変更後契約金額（税抜）",null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7)),1)))","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($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8)),1)))","v":""}]
[null,"③","保留金額",null,null,null,null,"抜","②累計出来高×１０％",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11)),1)))","v":"0"}]
[null,"④","既受領金額",null,null,null,null,"抜",null,null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10)),1)))","v":""}]
[null,"⑤","当月出来高",null,null,null,null,"抜","②累計出来高－（③保留金額＋④既受領金）",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12)),1)))","v":""}]
[null,"⑥","消費税及び地方消費税",null,null,null,null,null,"⑤当月出来高×",null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13)),1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14)),1)))","v":""}]
[null,"⑦","合計請求金額",null,null,null,null,"込","⑤当月出来高＋⑥消費税及び地方消費税",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15)),1)))","v":""}]
[null,"⑧","請求残高",null,null,null,null,"抜","①契約金額－④既受領金－⑤当月出来高",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16)),1)))","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,"令和",{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$K$2=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$K$2)","v":""},"年",{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$K$3=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$K$3)","v":""},"月",{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$K$4=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$K$4)","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,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,1,1))","v":""},{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,2,1))","v":""},{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,3,1))","v":""},{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$8=\"\",\"\",MID('入力①→印刷①-合計請求書(出来高)'!$H$8,4,1))","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,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$9=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$9)","v":""}]
[null,"住所",null,null,null,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$10=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$10)","v":""}]
[null,"名称",null,null,null,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$11=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$11)","v":""}]
[]
[null,"ＴＥＬ",null,null,null,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$12=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$12)","v":""},null,null,null,"ＦＡＸ",null,null,{"$f":"IF('入力①→印刷①-合計請求書(出来高)'!$H$13=\"\",\"\",'入力①→印刷①-合計請求書(出来高)'!$H$13)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"支払確定金額（税込）"]
[]
[]
[]
[null,2,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,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-2,1)))","v":""},"－",{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,2))<=0,\"\",MID(INDEX(発注CD材料,$B$18,2),LEN(INDEX(発注CD材料,$B$18,2)),1)))","v":""},null,null,null,null,null,null,null,null,null,null,"科目ｺｰﾄﾞ",null,null,111,null,"112-1",null,113]
[null,"工　　　事　　　名",null,null,null,null,{"$f":"IF($B$18=\"\",\"\",INDEX(発注CD材料,$B$18,3))","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,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-9<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-9,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,1))<=0,\"\",MID(INDEX(発注CD材料,$B$18,1),LEN(INDEX(発注CD材料,$B$18,1)),1)))","v":""},null,null,null,null,null,null,null,null,null,null,"科目",null,null,"経費（該当する科目番号を記入）"]
[null,"①","契約金額（税抜）",null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,5))<=0,\"\",MID(INDEX(発注CD材料,$B$18,5),LEN(INDEX(発注CD材料,$B$18,5)),1)))","v":""},null,null,null,null,null,null,null,null,null,null,"科目ｺｰﾄﾞ",null,null,"222～248"]
[null,null,"変更後契約金額（税抜）",null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,7))<=0,\"\",MID(INDEX(発注CD材料,$B$18,7),LEN(INDEX(発注CD材料,$B$18,7)),1)))","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($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,8))<=0,\"\",MID(INDEX(発注CD材料,$B$18,8),LEN(INDEX(発注CD材料,$B$18,8)),1)))","v":""}]
[null,"③","保留金額",null,null,null,null,"抜","②累計出来高×１０％",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,11))<=0,\"\",MID(INDEX(発注CD材料,$B$18,11),LEN(INDEX(発注CD材料,$B$18,11)),1)))","v":"0"}]
[null,"④","既受領金額",null,null,null,null,"抜",null,null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,10))<=0,\"\",MID(INDEX(発注CD材料,$B$18,10),LEN(INDEX(発注CD材料,$B$18,10)),1)))","v":""}]
[null,"⑤","当月出来高",null,null,null,null,"抜","②累計出来高－（③保留金額＋④既受領金）",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,12))<=0,\"\",MID(INDEX(発注CD材料,$B$18,12),LEN(INDEX(発注CD材料,$B$18,12)),1)))","v":""}]
[null,"⑥","消費税及び地方消費税",null,null,null,null,null,"⑤当月出来高×",null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,13))<=0,\"\",MID(INDEX(発注CD材料,$B$18,13),LEN(INDEX(発注CD材料,$B$18,13)),1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,14))<=0,\"\",MID(INDEX(発注CD材料,$B$18,14),LEN(INDEX(発注CD材料,$B$18,14)),1)))","v":""}]
[null,"⑦","合計請求金額",null,null,null,null,"込","⑤当月出来高＋⑥消費税及び地方消費税",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,15))<=0,\"\",MID(INDEX(発注CD材料,$B$18,15),LEN(INDEX(発注CD材料,$B$18,15)),1)))","v":""}]
[null,"⑧","請求残高",null,null,null,null,"抜","①契約金額－④既受領金－⑤当月出来高",null,null,null,null,null,{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-8<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-8,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-7<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-7,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-6<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-6,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-5<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-5,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-4<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-4,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-3<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-3,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-2<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-2,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))-1<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16))-1,1)))","v":""},{"$f":"IF($B$18=\"\",\"\",IF(LEN(INDEX(発注CD材料,$B$18,16))<=0,\"\",MID(INDEX(発注CD材料,$B$18,16),LEN(INDEX(発注CD材料,$B$18,16)),1)))","v":""}]
[]
[null,"請求内訳（税抜）"]
[null,"月","日","内　　　　　容",null,null,null,null,null,null,"数量",null,"単価",null,"金　　　　　　　　額"]