{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["お支払について","使い方","請求書（表紙）","請求明細","記入例（明細なし）","記入例（明細あり）","記入例（請求明細）","コード39","パターンデータ"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"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":"お支払について","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"請求書の提出及びお支払について"]
[null,"請求書締切日・提出日","毎月月末締切、翌月第３営業日必着 \n提出期限迄に請求書が未着の場合は、翌月処理になる場合がありますのでご注意下さい。"]
[null,"お支払日","締切日の翌月末日支払い（末日が休日の場合は前営業日）"]
[null,"お支払方法","当社所定の支払い条件による"]
[null,"*お支払に関するご不明点などについては、管理本部（03-5645-3232）までお問い合わせください。"]
[]
[null,"請求書のご提出先一覧"]
[null,"支店・事業所","住所","電話番号"]
[null,"東北支店","〒980-0804　宮城県仙台市青葉区大町1-3-2　仙台MDビル２F","022-221-2316"]
[null,"東京支店","〒103-0012　東京都中央区日本橋堀留町1-2-10　イトーピア日本橋SAビル３Ｆ","03-5645-3236"]
[null,"中部支店","〒464-0075　愛知県名古屋市千種区内山3-29-10　朝日生命千種AMビル４F","052-744-0717"]
[null,"西日本支店","〒541-0046　大阪府大阪市中央区平野町2－6－6　　ヒロセ平野町ビル５Ｆ","06-6233-5300 "]
[null,"九州支店","〒810-0011　福岡県福岡市中央区高砂1-11-1　福岡ゼネラルビル６Ｆ","092-534-8425"]
[null,"沖縄支店","〒900-0033　沖縄県那覇市久米2-4-16　三井生命那覇ビル５F","098-862-8306"]
[null,"本社機材センター","〒265-0066　千葉県千葉市若葉区多部田町７９０","043-226-0211 "]
[null,"奈良機材センター","〒636-0226　奈良県磯城郡田原本町唐古２９０","0744-33-6246"]
[null,"＊請求書ご提出にあたってのご不明点などについては各事業所へ直接お問い合わせ下さい。"]

{"sheet":"使い方","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"使い方"]
[null,null,"1.","入力は「請求書（表紙）」または「請求明細」の黄色の箇所のみおこなって下さい。"]
[null,null,null,"それ以外の箇所は変更しないでください。また、行・列の追加、削除や書式の変更はしないでください。"]
[null,null,"2.","請求書は工事コード毎に作成し、工事コードが異なる場合には請求書も分けて作成してください。"]
[null,null,"3.","「工事コード」、「工事・工種名」、「取引先コード」、「発注番号」を必ず記入してください。不明のときは工事部に照会してください。"]
[null,null,"4.","請求の内訳が請求書（表紙）に収まらない場合は請求明細を使用してください。"]
[null,null,null,"請求明細を利用する場合は請求明細に内訳を記載し、請求書（表紙）には合計金額を記入してください。"]
[null,null,"5.","請求書ご提出の際は印刷の上、「支店用」と「本社用」をご提出ください。請求明細を利用する場合は2部ご提出ください。"]

{"sheet":"請求書（表紙）","index":2,"n_rows":41,"n_cols":41,"rows_kept":41,"cut":false,"hidden":false,"merged":[[32,30,32,34],[33,29,36,29],[33,30,36,34],[33,35,36,35],[25,29,25,30],[26,29,30,30],[20,29,20,30],[21,29,21,30],[22,29,22,30],[23,29,23,30],[24,29,24,30],[2,29,2,30],[2,33,2,36],[4,29,5,29],[4,30,5,31],[4,34,4,36],[4,38,4,40],[5,34,5,36],[5,38,5,40],[2,38,3,40],[21,15,21,16],[10,15,10,16],[11,15,11,16],[12,15,12,16],[6,34,6,36],[6,38,6,40],[8,29,9,30],[8,31,8,34],[8,35,8,36],[8,37,8,38],[8,39,8,40],[15,29,15,30],[16,29,16,30],[17,29,17,30],[18,29,18,30],[19,29,19,30],[10,29,10,30],[11,29,11,30],[12,29,12,30],[13,29,13,30],[14,29,14,30],[4,24,4,26],[5,20,5,22],[5,24,5,26],[6,20,6,22],[6,24,6,26],[33,15,36,15],[33,16,36,20],[33,21,36,21],[2,5,2,8],[2,19,2,22],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,30,16],[32,16,32,20],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[8,21,8,22],[8,23,8,24],[8,25,8,26],[20,15,20,16],[19,1,19,2],[4,15,5,15],[4,16,5,17],[8,15,9,16],[8,17,8,20],[4,10,4,12],[5,6,5,8],[5,10,5,12],[15,1,15,2],[6,6,6,8],[6,10,6,12],[8,1,9,2],[8,3,8,6],[8,7,8,8],[8,9,8,10],[8,11,8,12],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,15,13,16],[14,15,14,16],[15,15,15,16],[4,20,4,22],[2,10,3,12],[1,5,1,8],[1,19,1,22],[1,33,1,36],[2,1,2,2],[2,24,3,26],[13,1,13,2],[32,5,32,6],[32,7,32,8],[4,1,5,1],[4,2,5,3],[4,6,4,8],[14,1,14,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,30,2],[2,15,2,16],[16,1,16,2],[17,1,17,2],[18,1,18,2]]}
["（請書請求用）",null,null,null,null,null,null,null,null,null,null,null,null,null,"（請書請求用）",null,null,null,null,null,null,null,null,null,null,null,null,null,"（請書請求用）"]
[null,null,null,null,null,"請　　求　　書",null,null,null,null,null,null,null,null,null,null,null,null,null,"請　　求　　書",null,null,null,null,null,null,null,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(K3=\"\",\"\",K3)","v":""},null,null,null,null,"成幸利根株式会社",null,"御中",null,null,null,null,null,"住所",{"$f":"IF(Y3=\"\",\"\",Y3)","v":""}]
[null,null,null,null,null,"月度",null,null,null,null,null,null,null,null,null,null,null,null,null,"月度",{"$f":"IF(G4=\"\",\"\",G4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"月度",{"$f":"U4","v":""}]
[null,"請求金額\n（税込）",{"$f":"IF(K31=0,\"\",K31)","v":""},null,null,"工事コード",null,null,null,"社名",null,null,null,null,null,"請求金額\n（税込）",{"$f":"C5","v":""},null,null,"工事コード",{"$f":"IF(G5=\"\",\"\",G5)","v":""},{"$f":"IF(H5=\"\",\"\",H5)","v":""},"","社名",{"$f":"IF(K5=\"\",\"\",K5)","v":""},null,null,null,null,"請求金額\n（税込）",{"$f":"Q5","v":""},null,null,"工事コード",{"$f":"IF(U5=\"\",\"\",U5)","v":""},{"$f":"IF(V5=\"\",\"\",V5)","v":""},{"$f":"IF(W5=\"\",\"\",W5)","v":""},"社名",{"$f":"IF(Y5=\"\",\"\",Y5)","v":""}]
[null,null,null,null,null,"工事・工種名",null,null,null,null,null,null,null,null,null,null,null,null,null,"工事・工種名","","","",null,{"$f":"IF(K6=\"\",\"\",K6)","v":""},null,null,null,null,null,null,null,null,"工事・工種名","","","",null,{"$f":"IF(Y6=\"\",\"\",Y6)","v":""}]
[null,null,null,null,null,"発注番号",null,null,null,"取引先コード",null,null,null,null,null,null,null,null,null,"発注番号",{"$f":"IF(G7=\"\",\"\",UPPER(ASC(G7)))","v":""},"","","取引先コード",{"$f":"IF(K7=\"\",\"\",K7)","v":""},null,null,null,null,null,null,null,null,"発注番号","","","","取引先コード",{"$f":"Y7","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":"SUM(H11,J11)","v":0},{"$f":"SUM(I11,K11)","v":0},null,null,{"$f":"IF(B11=\"\",\"\",B11)","v":""},null,{"$f":"IF(D11=\"\",\"\",D11)","v":""},{"$f":"IF(E11=\"\",\"\",E11)","v":""},{"$f":"IF(F11=\"\",\"\",F11)","v":""},{"$f":"IF(G11=\"\",\"\",G11)","v":""},{"$f":"IF(H11=\"\",\"\",H11)","v":""},{"$f":"IF(I11=\"\",\"\",I11)","v":""},{"$f":"IF(J11=\"\",\"\",J11)","v":""},{"$f":"IF(K11=\"\",\"\",K11)","v":""},{"$f":"IF(L11=\"\",\"\",L11)","v":0},{"$f":"IF(M11=\"\",\"\",M11)","v":0},null,null,{"$f":"IF(P11=\"\",\"\",P11)","v":""},null,{"$f":"IF(R11=\"\",\"\",R11)","v":""},{"$f":"IF(S11=\"\",\"\",S11)","v":""},{"$f":"IF(T11=\"\",\"\",T11)","v":""},{"$f":"IF(U11=\"\",\"\",U11)","v":""},{"$f":"IF(V11=\"\",\"\",V11)","v":""},{"$f":"IF(W11=\"\",\"\",W11)","v":""},{"$f":"IF(X11=\"\",\"\",X11)","v":""},{"$f":"IF(Y11=\"\",\"\",Y11)","v":""},{"$f":"IF(Z11=\"\",\"\",Z11)","v":0},{"$f":"IF(AA11=\"\",\"\",AA11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H12,J12)","v":0},{"$f":"SUM(I12,K12)","v":0},null,null,"",null,"","","","","","","","",0,0,null,null,{"$f":"IF(P12=\"\",\"\",P12)","v":""},null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(I19,K19)","v":0},null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(I23,K23)","v":0},null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(I25,K25)","v":0},null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,"備　　考",null,null,null,null,null,"出来高　計",{"$f":"SUM(I11:I25)-SUMIF(B11:C25,\"（　小　　　計　）\",I11:I25)","v":0},"出来高　計",{"$f":"SUM(K11:K25)-SUMIF(B11:C25,\"（　小　　　計　）\",K11:K25)","v":0},"出来高　計",{"$f":"SUM(I26,K26)","v":0},null,null,"備　　考",null,null,null,null,null,"出来高　計",{"$f":"IF(I26=\"\",\"\",I26)","v":0},"出来高　計",{"$f":"IF(K26=\"\",\"\",K26)","v":0},"出来高　計",{"$f":"IF(M26=\"\",\"\",M26)","v":0},null,null,"備　　考",null,null,null,null,null,"出来高　計",0,"出来高　計",0,"出来高　計",0]
[null,null,null,null,null,null,null,"保留金",null,"保留金",null,"保留金",{"$f":"SUM(I27,K27)","v":0},null,null,{"$f":"IF(B27=\"\",\"\",B27)","v":""},{"$f":"IF(C27=\"\",\"\",C27)","v":""},null,null,null,null,"保留金","","保留金","","保留金",0,null,null,{"$f":"IF(P27=\"\",\"\",P27)","v":""},{"$f":"IF(Q27=\"\",\"\",Q27)","v":""},null,null,null,null,"保留金","","保留金","","保留金",0]
[null,null,null,null,null,null,null,"保留金解除",null,"保留金解除",null,"保留金解除",0,null,null,"","",null,null,null,null,"保留金解除","","保留金解除","","保留金解除",0,null,null,"","",null,null,null,null,"保留金解除","","保留金解除","","保留金解除",0]
[null,null,null,"契約金額 (税抜)",null,null,{"$f":"SUM(G11:G25)-SUMIF(B11:C25,\"（　小　　　計　）\",G11:G25)","v":0},"請求金額(税抜)",{"$f":"SUM(I26:I28)","v":0},"請求金額(税抜)",{"$f":"SUM(K26:K28)","v":0},"請求金額(税抜)",0,null,null,"","","契約金額 (税抜)",null,null,{"$f":"IF(G29=\"\",\"\",G29)","v":0},"請求金額(税抜)",0,"請求金額(税抜)",0,"請求金額(税抜)",0,null,null,"","","契約金額 (税抜)",null,null,{"$f":"IF(U29=\"\",\"\",U29)","v":0},"請求金額(税抜)",0,"請求金額(税抜)",0,"請求金額(税抜)",0]
[null,null,null,"消費税",null,0.08,{"$f":"G29*F30","v":0},"消費税",{"$f":"I29*F30","v":0},"消費税",{"$f":"K29*F30","v":0},"消費税",{"$f":"SUM(I30,K30)","v":0},null,null,"","","消費税",null,{"$f":"$F$30","v":0.08},{"$f":"IF(G30=\"\",\"\",G30)","v":0},"消費税",0,"消費税",0,"消費税",0,null,null,"","","消費税",null,{"$f":"$F$30","v":0.08},{"$f":"IF(U30=\"\",\"\",U30)","v":0},"消費税",0,"消費税",0,"消費税",0]
[null,null,null,"契約金額 (税込)",null,null,{"$f":"SUM(G29:G30)","v":0},"請求金額(税込)",{"$f":"SUM(I29:I30)","v":0},"請求金額(税込)",{"$f":"SUM(K29:K30)","v":0},"請求金額(税込)",{"$f":"SUM(I31,K31)","v":0},null,null,"","","契約金額 (税込)",null,null,{"$f":"IF(G31=\"\",\"\",G31)","v":0},"請求金額(税込)",0,"請求金額(税込)",0,"請求金額(税込)",0,null,null,"","","契約金額 (税込)",null,null,{"$f":"IF(U31=\"\",\"\",U31)","v":0},"請求金額(税込)",0,"請求金額(税込)",0,"請求金額(税込)",0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"決裁","査定・承認",null,null,null,null,"受付",null,null,null,null,null,null,null,"決裁","査定・承認",null,null,null,null,"受付"]
[null,null,"※記入上の注意事項",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"伝票番号"]
[null,null,"1.　一現場一枚として記入し、二現場以上ある場合には現場別に請求書を作成してください。"]
[null,null,"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,"　"]

{"sheet":"請求明細","index":3,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,11,6,13],[5,3,5,5],[4,3,4,5],[5,11,5,13],[8,2,9,3],[8,4,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[13,2,13,3],[14,2,14,3],[11,2,11,3],[12,2,12,3],[10,2,10,3],[19,2,19,3],[20,2,20,3],[17,2,17,3],[18,2,18,3],[15,2,15,3],[16,2,16,3],[35,2,35,3],[23,2,23,3],[34,2,34,3],[21,2,21,3],[22,2,22,3]]}
[1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"( \"&A1&\" / \"&$N$40&\" )\"","v":"( 1 / 1 )"}]
[null,null,"（　請　求　明　細　）"]
[]
[null,null,"月度",{"$f":"IF('請求書（表紙）'!G4=\"\",\"\",'請求書（表紙）'!G4)","v":""}]
[null,null,"工事コード",{"$f":"IF('請求書（表紙）'!G5=\"\",\"\",'請求書（表紙）'!G5)","v":""}]
[null,null,"工事・工種名",{"$f":"IF('請求書（表紙）'!G6=\"\",\"\",'請求書（表紙）'!G6)","v":""},null,null,null,null,null,null,"社名",{"$f":"'請求書（表紙）'!K5 &\"　\"&'請求書（表紙）'!K6","v":"　"}]
[null,null,"発注番号",{"$f":"IF('請求書（表紙）'!G7=\"\",\"\",'請求書（表紙）'!G7)","v":""},null,null,null,null,null,null,"取引先コード",{"$f":"IF('請求書（表紙）'!K7=\"\",\"\",'請求書（表紙）'!K7)","v":""}]
[]
[null,null,"内　　　訳",null,"契　　　　約",null,null,null,"前回まで出来高",null,"今回出来高",null,"累計出来高"]
[null,null,null,null,"数量","単位","単価","金額","数量","金額","数量","金額","数量","金額"]
[1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I11,K11)","v":0},{"$f":"SUM(J11,L11)","v":0}]
[1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I12,K12)","v":0},{"$f":"SUM(J12,L12)","v":0}]
[1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I13,K13)","v":0},{"$f":"SUM(J13,L13)","v":0}]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"ページ　計",null,null,null,null,{"$f":"SUM(H11:H35)","v":0},null,{"$f":"SUM(J11:J35)","v":0},null,{"$f":"SUM(L11:L35)","v":0},null,{"$f":"SUM(N11:N35)","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,{"$f":"MAX(A:A)","v":1}]

{"sheet":"記入例（明細なし）","index":4,"n_rows":41,"n_cols":41,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,5,1,8],[1,19,1,22],[1,33,1,36],[2,1,2,2],[2,5,2,8],[2,10,3,12],[2,15,2,16],[2,19,2,22],[2,24,3,26],[2,29,2,30],[2,33,2,36],[2,38,3,40],[4,1,5,1],[4,2,5,3],[4,6,4,8],[4,10,4,12],[4,15,5,15],[4,16,5,17],[4,20,4,22],[4,24,4,26],[6,6,6,8],[6,10,6,12],[6,20,6,22],[6,24,6,26],[6,34,6,36],[6,38,6,40],[4,29,5,29],[4,30,5,31],[4,34,4,36],[4,38,4,40],[5,6,5,8],[5,10,5,12],[5,20,5,22],[5,24,5,26],[5,34,5,36],[5,38,5,40],[8,35,8,36],[8,37,8,38],[8,39,8,40],[10,1,10,2],[10,15,10,16],[10,29,10,30],[8,17,8,20],[8,21,8,22],[8,23,8,24],[8,25,8,26],[8,29,9,30],[8,31,8,34],[8,1,9,2],[8,3,8,6],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,15,9,16],[13,1,13,2],[13,15,13,16],[13,29,13,30],[14,1,14,2],[14,15,14,16],[14,29,14,30],[11,1,11,2],[11,15,11,16],[11,29,11,30],[12,1,12,2],[12,15,12,16],[12,29,12,30],[17,1,17,2],[17,15,17,16],[17,29,17,30],[18,1,18,2],[18,15,18,16],[18,29,18,30],[15,1,15,2],[15,15,15,16],[15,29,15,30],[16,1,16,2],[16,15,16,16],[16,29,16,30],[21,1,21,2],[21,15,21,16],[21,29,21,30],[22,1,22,2],[22,15,22,16],[22,29,22,30],[19,1,19,2],[19,15,19,16],[19,29,19,30],[20,1,20,2],[20,15,20,16],[20,29,20,30],[25,1,25,2],[25,15,25,16],[26,1,30,2],[26,15,30,16],[23,1,23,2],[23,15,23,16],[23,29,23,30],[24,1,24,2],[24,15,24,16],[24,29,24,30],[25,29,25,30],[26,29,30,30],[33,35,36,35],[32,5,32,6],[32,7,32,8],[32,16,32,20],[32,30,32,34],[33,15,36,15],[33,16,36,20],[33,21,36,21],[33,29,36,29],[33,30,36,34]]}
["（請書請求用）",null,null,null,null,null,null,null,null,null,null,null,null,null,"（請書請求用）",null,null,null,null,null,null,null,null,null,null,null,null,null,"（請書請求用）"]
[null,null,null,null,null,"請　　求　　書",null,null,null,null,null,null,null,null,null,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,"住所",{"$f":"IF(K3=\"\",\"\",K3)","v":"東京都○○区□□1-1"},null,null,null,null,"成幸利根株式会社",null,"御中",null,null,null,null,null,"住所",{"$f":"IF(Y3=\"\",\"\",Y3)","v":"東京都○○区□□1-1"}]
[null,null,null,null,null,"月度","2016-08-01",null,null,null,null,null,null,null,null,null,null,null,null,"月度",{"$f":"IF(G4=\"\",\"\",G4)","v":"2016-08-01"},null,null,null,null,null,null,null,null,null,null,null,null,"月度",{"$f":"U4","v":"2016-08-01"}]
[null,"請求金額\n（税込）",{"$f":"IF(K31=0,\"\",K31)","v":9234000},null,null,"工事コード","1000001-0001",null,null,"社名","○○重機株式会社",null,null,null,null,"請求金額\n（税込）",{"$f":"Y31","v":9234000},null,null,"工事コード",{"$f":"IF(G5=\"\",\"\",G5)","v":"1000001-0001"},{"$f":"IF(H5=\"\",\"\",H5)","v":""},"","社名",{"$f":"IF(K5=\"\",\"\",K5)","v":"○○重機株式会社"},null,null,null,null,"請求金額\n（税込）",{"$f":"AM31","v":9234000},null,null,"工事コード",{"$f":"IF(U5=\"\",\"\",U5)","v":"1000001-0001"},"","","社名",{"$f":"IF(Y5=\"\",\"\",Y5)","v":"○○重機株式会社"}]
[null,null,null,null,null,"工事・工種名","○○ビル建設工事",null,null,null,"□□支店",null,null,null,null,null,null,null,null,"工事・工種名","○○ビル建設工事","","",null,{"$f":"IF(K6=\"\",\"\",K6)","v":"□□支店"},null,null,null,null,null,null,null,null,"工事・工種名","○○ビル建設工事","","",null,{"$f":"IF(Y6=\"\",\"\",Y6)","v":"□□支店"}]
[null,null,null,null,null,"注文番号","HCI150000201",null,null,"取引先コード",5007500,null,null,null,null,null,null,null,null,"注文番号","HCI150000201","","","取引先コード",{"$f":"IF(K7=\"\",\"\",K7)","v":5007500},null,null,null,null,null,null,null,null,"注文番号","HCI150000201","","","取引先コード",{"$f":"Y7","v":5007500}]
[]
["　　","内　　　訳",null,"契　　　　約",null,null,null,"前回まで出来高",null,"今回出来高",null,"累計出来高",null,null,null,"名　　称",null,"契　約　内　訳",null,null,null,"前回まで出来高",null,"今回出来高",null,"累計出来高",null,null,null,"名　　称",null,"契　約　内　訳",null,null,null,"前回まで出来高",null,"今回出来高",null,"累計出来高"]
[null,null,null,"数量","単位","単価","金額","数量","金額","数量","金額","数量","金額",null,null,null,null,"数量","単位","単価","金額","数量","金額","数量","金額","数量","金額",null,null,null,null,"数量","単位","単価","金額","数量","金額","数量","金額","数量","金額"]
[null,"SMW工事",null,null,null,null,null,null,null,null,null,{"$f":"SUM(H11,J11)","v":0},{"$f":"SUM(I11,K11)","v":0},null,null,{"$f":"IF(B11=\"\",\"\",B11)","v":"SMW工事"},null,{"$f":"IF(D11=\"\",\"\",D11)","v":""},"","","","","","","",0,0,null,null,{"$f":"IF(P11=\"\",\"\",P11)","v":"SMW工事"},null,{"$f":"IF(R11=\"\",\"\",R11)","v":""},"","","","","","","",0,0]
[null,"　施工費",null,3000,"m2",5000,{"$f":"D12*F12","v":15000000},1500,{"$f":"F12*H12","v":7500000},1500,{"$f":"F12*J12","v":7500000},{"$f":"SUM(H12,J12)","v":3000},15000000,null,null,"　施工費",null,3000,"m2",5000,15000000,1500,7500000,1500,7500000,3000,15000000,null,null,{"$f":"IF(P12=\"\",\"\",P12)","v":"　施工費"},null,3000,"m2",5000,15000000,1500,7500000,1500,7500000,3000,15000000]
[null,"　労務費",null,30,"日",25000,{"$f":"D13*F13","v":750000},20,{"$f":"F13*H13","v":500000},10,{"$f":"F13*J13","v":250000},30,750000,null,null,"　労務費",null,30,"日",25000,750000,20,500000,10,250000,30,750000,null,null,"　労務費",null,30,"日",25000,750000,20,500000,10,250000,30,750000]
[null,"　解体・搬出",null,2,"式",1500000,{"$f":"D14*F14","v":3000000},1,{"$f":"F14*H14","v":1500000},null,null,1,1500000,null,null,"　解体・搬出",null,2,"式",1500000,3000000,1,1500000,"","",1,1500000,null,null,"　解体・搬出",null,2,"式",1500000,3000000,1,1500000,"","",1,1500000]
[null,"　運搬費",null,1,"式",2000000,{"$f":"D15*F15","v":2000000},0.5,{"$f":"F15*H15","v":1000000},null,null,0.5,1000000,null,null,"　運搬費",null,1,"式",2000000,2000000,0.5,1000000,"","",0.5,1000000,null,null,"　運搬費",null,1,"式",2000000,2000000,0.5,1000000,"","",0.5,1000000]
[null,"（　小　　　計　）",null,null,null,null,{"$f":"SUM(G12:G15)","v":20750000},null,{"$f":"SUM(I11:I15)","v":10500000},null,{"$f":"SUM(K11:K15)","v":7750000},0,18250000,null,null,"（　小　　　計　）",null,"","","",20750000,"",10500000,"",7750000,0,18250000,null,null,"（　小　　　計　）",null,"","","",20750000,"",10500000,"",7750000,0,18250000]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,"杭工事",null,null,null,null,null,null,null,null,null,0,0,null,null,"杭工事",null,"","","","","","","","",0,0,null,null,"杭工事",null,"","","","","","","","",0,0]
[null,"　施工費",null,500,"ｍ",3000,{"$f":"D19*F19","v":1500000},null,{"$f":"F19*H19","v":0},340,{"$f":"F19*J19","v":1020000},340,{"$f":"SUM(I19,K19)","v":1020000},null,null,"　施工費",null,500,"ｍ",3000,1500000,"",0,340,1020000,340,1020000,null,null,"　施工費",null,500,"ｍ",3000,1500000,"",0,340,1020000,340,1020000]
[null,"　労務費",null,15,"日",25000,{"$f":"D20*F20","v":375000},null,0,10,{"$f":"F20*J20","v":250000},10,250000,null,null,"　労務費",null,15,"日",25000,375000,"",0,10,250000,10,250000,null,null,"　労務費",null,15,"日",25000,375000,"",0,10,250000,10,250000]
[null,"　段取替",null,1,"式",500000,{"$f":"D21*F21","v":500000},null,null,1,{"$f":"F21*J21","v":500000},1,500000,null,null,"　段取替",null,1,"式",500000,500000,"","",1,500000,1,500000,null,null,"　段取替",null,1,"式",500000,500000,"","",1,500000,1,500000]
[null,"（　小　　　計　）",null,null,null,null,{"$f":"SUM(G19:G21)","v":2375000},null,{"$f":"SUM(I17:I21)","v":0},null,{"$f":"SUM(K17:K21)","v":1770000},0,1770000,null,null,"（　小　　　計　）",null,"","","",2375000,"",0,"",1770000,0,1770000,null,null,"（　小　　　計　）",null,"","","",2375000,"",0,"",1770000,0,1770000]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(I23,K23)","v":0},null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,"値引調整",null,1,"式",-25000,{"$f":"D24*F24","v":-25000},null,0,null,-20000,0,-20000,null,null,"値引調整",null,1,"式",-25000,-25000,"",0,"",-20000,0,-20000,null,null,"値引調整",null,1,"式",-25000,-25000,"",0,"",-20000,0,-20000]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(I25,K25)","v":0},null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,"備　　考",null,null,null,null,null,"出来高　計",{"$f":"SUM(I11:I25)-SUMIF(B11:C25,\"（　小　　　計　）\",I11:I25)","v":10500000},"出来高　計",{"$f":"SUM(K11:K25)-SUMIF(B11:C25,\"（　小　　　計　）\",K11:K25)","v":9500000},"出来高　計",{"$f":"SUM(I26,K26)","v":20000000},null,null,"備　　考",null,null,null,null,null,"出来高　計",10500000,"出来高　計",9500000,"出来高　計",20000000,null,null,"備　　考",null,null,null,null,null,"出来高　計",10500000,"出来高　計",9500000,"出来高　計",20000000]
[null,null,null,null,null,null,null,"保留金",-1050000,"保留金",-950000,"保留金",{"$f":"SUM(I27,K27)","v":-2000000},null,null,{"$f":"IF(B27=\"\",\"\",B27)","v":""},{"$f":"IF(C27=\"\",\"\",C27)","v":""},null,null,null,null,"保留金",{"$f":"IF(I27=\"\",\"\",I27)","v":-1050000},"保留金",{"$f":"IF(K27=\"\",\"\",K27)","v":-950000},"保留金",{"$f":"IF(M27=\"\",\"\",M27)","v":-2000000},null,null,{"$f":"IF(P27=\"\",\"\",P27)","v":""},{"$f":"IF(Q27=\"\",\"\",Q27)","v":""},null,null,null,null,"保留金",{"$f":"IF(W27=\"\",\"\",W27)","v":-1050000},"保留金",{"$f":"IF(Y27=\"\",\"\",Y27)","v":-950000},"保留金",{"$f":"IF(AA27=\"\",\"\",AA27)","v":-2000000}]
[null,null,null,null,null,null,null,"保留金解除",null,"保留金解除",null,"保留金解除",0,null,null,"","",null,null,null,null,"保留金解除","","保留金解除","","保留金解除",0,null,null,{"$f":"IF(P28=\"\",\"\",P28)","v":""},"",null,null,null,null,"保留金解除","","保留金解除","","保留金解除",0]
[null,null,null,"契約金額 (税抜)",null,null,{"$f":"SUM(G11:G25)-SUMIF(B11:C25,\"（　小　　　計　）\",G11:G25)","v":23100000},"請求金額(税抜)",{"$f":"SUM(I26:I28)","v":9450000},"請求金額(税抜)",{"$f":"SUM(K26:K28)","v":8550000},"請求金額(税抜)",18000000,null,null,"","","契約金額 (税抜)",null,null,{"$f":"IF(G29=\"\",\"\",G29)","v":23100000},"請求金額(税抜)",9450000,"請求金額(税抜)",8550000,"請求金額(税抜)",18000000,null,null,"","","契約金額 (税抜)",null,null,{"$f":"IF(U29=\"\",\"\",U29)","v":23100000},"請求金額(税抜)",9450000,"請求金額(税抜)",8550000,"請求金額(税抜)",18000000]
[null,null,null,"消費税",null,0.08,{"$f":"G29*F30","v":1848000},"消費税",{"$f":"I29*F30","v":756000},"消費税",{"$f":"K29*F30","v":684000},"消費税",{"$f":"SUM(I30,K30)","v":1440000},null,null,"","","消費税",null,{"$f":"$F$30","v":0.08},{"$f":"IF(G30=\"\",\"\",G30)","v":1848000},"消費税",756000,"消費税",684000,"消費税",1440000,null,null,"","","消費税",null,{"$f":"$F$30","v":0.08},{"$f":"IF(U30=\"\",\"\",U30)","v":1848000},"消費税",756000,"消費税",684000,"消費税",1440000]
[null,null,null,"契約金額 (税込)",null,null,{"$f":"SUM(G29:G30)","v":24948000},"請求金額(税込)",{"$f":"SUM(I29:I30)","v":10206000},"請求金額(税込)",{"$f":"SUM(K29:K30)","v":9234000},"請求金額(税込)",{"$f":"SUM(I31,K31)","v":19440000},null,null,"","","契約金額 (税込)",null,null,{"$f":"IF(G31=\"\",\"\",G31)","v":24948000},"請求金額(税込)",10206000,"請求金額(税込)",9234000,"請求金額(税込)",19440000,null,null,"","","契約金額 (税込)",null,null,{"$f":"IF(U31=\"\",\"\",U31)","v":24948000},"請求金額(税込)",10206000,"請求金額(税込)",9234000,"請求金額(税込)",19440000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"決裁","査定・承認",null,null,null,null,"受付",null,null,null,null,null,null,null,"決裁","査定・承認",null,null,null,null,"受付"]
[null,null,"※記入上の注意事項",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"伝票番号"]
[null,null,"1.　一現場一枚として記入し、二現場以上ある場合には現場別に請求書を作成してください。"]
[null,null,"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,"　"]

{"sheet":"記入例（明細あり）","index":5,"n_rows":41,"n_cols":41,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,5,1,8],[1,19,1,22],[1,33,1,36],[2,1,2,2],[2,5,2,8],[2,10,3,12],[2,15,2,16],[2,19,2,22],[2,24,3,26],[2,29,2,30],[2,33,2,36],[2,38,3,40],[4,1,5,1],[4,2,5,3],[4,6,4,8],[4,10,4,12],[4,15,5,15],[4,16,5,17],[4,20,4,22],[4,24,4,26],[6,6,6,8],[6,10,6,12],[6,20,6,22],[6,24,6,26],[6,34,6,36],[6,38,6,40],[4,29,5,29],[4,30,5,31],[4,34,4,36],[4,38,4,40],[5,6,5,8],[5,10,5,12],[5,20,5,22],[5,24,5,26],[5,34,5,36],[5,38,5,40],[8,35,8,36],[8,37,8,38],[8,39,8,40],[10,1,10,2],[10,15,10,16],[10,29,10,30],[8,17,8,20],[8,21,8,22],[8,23,8,24],[8,25,8,26],[8,29,9,30],[8,31,8,34],[8,1,9,2],[8,3,8,6],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,15,9,16],[13,1,13,2],[13,15,13,16],[13,29,13,30],[14,1,14,2],[14,15,14,16],[14,29,14,30],[11,1,11,2],[11,15,11,16],[11,29,11,30],[12,1,12,2],[12,15,12,16],[12,29,12,30],[17,1,17,2],[17,15,17,16],[17,29,17,30],[18,1,18,2],[18,15,18,16],[18,29,18,30],[15,1,15,2],[15,15,15,16],[15,29,15,30],[16,1,16,2],[16,15,16,16],[16,29,16,30],[21,1,21,2],[21,15,21,16],[21,29,21,30],[22,1,22,2],[22,15,22,16],[22,29,22,30],[19,1,19,2],[19,15,19,16],[19,29,19,30],[20,1,20,2],[20,15,20,16],[20,29,20,30],[25,1,25,2],[25,15,25,16],[25,29,25,30],[26,1,30,2],[26,15,30,16],[26,29,30,30],[23,1,23,2],[23,15,23,16],[23,29,23,30],[24,1,24,2],[24,15,24,16],[24,29,24,30],[33,35,36,35],[32,5,32,6],[32,7,32,8],[32,16,32,20],[32,30,32,34],[33,15,36,15],[33,16,36,20],[33,21,36,21],[33,29,36,29],[33,30,36,34]]}
["（請書請求用）",null,null,null,null,null,null,null,null,null,null,null,null,null,"（請書請求用）",null,null,null,null,null,null,null,null,null,null,null,null,null,"（請書請求用）"]
[null,null,null,null,null,"請　　求　　書",null,null,null,null,null,null,null,null,null,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,"住所",{"$f":"IF(K3=\"\",\"\",K3)","v":"東京都○○区□□1-1"},null,null,null,null,"成幸利根株式会社",null,"御中",null,null,null,null,null,"住所",{"$f":"IF(Y3=\"\",\"\",Y3)","v":"東京都○○区□□1-1"}]
[null,null,null,null,null,"月度","2016-08-01",null,null,null,null,null,null,null,null,null,null,null,null,"月度",{"$f":"IF(G4=\"\",\"\",G4)","v":"2016-08-01"},null,null,null,null,null,null,null,null,null,null,null,null,"月度",{"$f":"U4","v":"2016-08-01"}]
[null,"請求金額\n（税込）",{"$f":"IF(K31=0,\"\",K31)","v":9234000},null,null,"工事コード","1000001-0001",null,null,"社名","○○重機株式会社",null,null,null,null,"請求金額\n（税込）",{"$f":"Y31","v":9234000},null,null,"工事コード",{"$f":"IF(G5=\"\",\"\",G5)","v":"1000001-0001"},{"$f":"IF(H5=\"\",\"\",H5)","v":""},"","社名",{"$f":"IF(K5=\"\",\"\",K5)","v":"○○重機株式会社"},null,null,null,null,"請求金額\n（税込）",{"$f":"AM31","v":9234000},null,null,"工事コード",{"$f":"IF(U5=\"\",\"\",U5)","v":"1000001-0001"},"","","社名",{"$f":"IF(Y5=\"\",\"\",Y5)","v":"○○重機株式会社"}]
[null,null,null,null,null,"工事・工種名","○○ビル建設工事",null,null,null,"□□支店",null,null,null,null,null,null,null,null,"工事・工種名","○○ビル建設工事","","",null,{"$f":"IF(K6=\"\",\"\",K6)","v":"□□支店"},null,null,null,null,null,null,null,null,"工事・工種名","○○ビル建設工事","","",null,{"$f":"IF(Y6=\"\",\"\",Y6)","v":"□□支店"}]
[null,null,null,null,null,"注文番号","HCI150000201",null,null,"取引先コード",1234567,null,null,null,null,null,null,null,null,"注文番号","HCI150000201","","","取引先コード",{"$f":"IF(K7=\"\",\"\",K7)","v":1234567},null,null,null,null,null,null,null,null,"注文番号","HCI150000201","","","取引先コード",{"$f":"Y7","v":1234567}]
[]
["　　","内　　　訳",null,"契　　　　約",null,null,null,"前回まで出来高",null,"今回出来高",null,"累計出来高",null,null,null,"名　　称",null,"契　約　内　訳",null,null,null,"前回まで出来高",null,"今回出来高",null,"累計出来高",null,null,null,"名　　称",null,"契　約　内　訳",null,null,null,"前回まで出来高",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(H11,J11)","v":0},{"$f":"SUM(I11,K11)","v":0},null,null,{"$f":"IF(B11=\"\",\"\",B11)","v":""},null,{"$f":"IF(D11=\"\",\"\",D11)","v":""},"","","","","","","",0,0,null,null,{"$f":"IF(P11=\"\",\"\",P11)","v":""},null,{"$f":"IF(R11=\"\",\"\",R11)","v":""},"","","","","","","",0,0]
[null,"SMW工事",null,1,"式",20750000,{"$f":"D12*F12","v":20750000},null,10500000,null,7750000,{"$f":"SUM(H12,J12)","v":0},18250000,null,null,"SMW工事",null,1,"式",20750000,20750000,"",10500000,"",7750000,0,18250000,null,null,{"$f":"IF(P12=\"\",\"\",P12)","v":"SMW工事"},null,1,"式",20750000,20750000,"",10500000,"",7750000,0,18250000]
[null,"杭工事",null,1,"式",2375000,{"$f":"D13*F13","v":2375000},null,null,null,1770000,0,1770000,null,null,"杭工事",null,1,"式",2375000,2375000,"","","",1770000,0,1770000,null,null,"杭工事",null,1,"式",2375000,2375000,"","","",1770000,0,1770000]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(I19,K19)","v":0},null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(I23,K23)","v":0},null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,"値引調整",null,1,"式",-25000,{"$f":"D24*F24","v":-25000},null,null,null,-20000,0,-20000,null,null,"値引調整",null,1,"式",-25000,-25000,"","","",-20000,0,-20000,null,null,"値引調整",null,1,"式",-25000,-25000,"","","",-20000,0,-20000]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(I25,K25)","v":0},null,null,"",null,"","","","","","","","",0,0,null,null,"",null,"","","","","","","","",0,0]
[null,"備　　考",null,null,null,null,null,"出来高　計",{"$f":"SUM(I11:I25)-SUMIF(B11:C25,\"（　小　　　計　）\",I11:I25)","v":10500000},"出来高　計",{"$f":"SUM(K11:K25)-SUMIF(B11:C25,\"（　小　　　計　）\",K11:K25)","v":9500000},"出来高　計",{"$f":"SUM(I26,K26)","v":20000000},null,null,"備　　考",null,null,null,null,null,"出来高　計",10500000,"出来高　計",9500000,"出来高　計",20000000,null,null,"備　　考",null,null,null,null,null,"出来高　計",10500000,"出来高　計",9500000,"出来高　計",20000000]
[null,null,null,null,null,null,null,"保留金",-1050000,"保留金",-950000,"保留金",{"$f":"SUM(I27,K27)","v":-2000000},null,null,{"$f":"IF(B27=\"\",\"\",B27)","v":""},"",null,null,null,null,"保留金",{"$f":"IF(I27=\"\",\"\",I27)","v":-1050000},"保留金",{"$f":"IF(K27=\"\",\"\",K27)","v":-950000},"保留金",{"$f":"IF(M27=\"\",\"\",M27)","v":-2000000},null,null,{"$f":"IF(P27=\"\",\"\",P27)","v":""},"",null,null,null,null,"保留金",{"$f":"IF(W27=\"\",\"\",W27)","v":-1050000},"保留金",{"$f":"IF(Y27=\"\",\"\",Y27)","v":-950000},"保留金",{"$f":"IF(AA27=\"\",\"\",AA27)","v":-2000000}]
[null,null,null,null,null,null,null,"保留金解除",null,"保留金解除",null,"保留金解除",0,null,null,"","",null,null,null,null,"保留金解除","","保留金解除","","保留金解除",0,null,null,"","",null,null,null,null,"保留金解除","","保留金解除","","保留金解除",0]
[null,null,null,"契約金額 (税抜)",null,null,{"$f":"SUM(G11:G25)-SUMIF(B11:C25,\"（　小　　　計　）\",G11:G25)","v":23100000},"請求金額(税抜)",{"$f":"SUM(I26:I28)","v":9450000},"請求金額(税抜)",{"$f":"SUM(K26:K28)","v":8550000},"請求金額(税抜)",18000000,null,null,"","","契約金額 (税抜)",null,null,{"$f":"IF(G29=\"\",\"\",G29)","v":23100000},"請求金額(税抜)",9450000,"請求金額(税抜)",8550000,"請求金額(税抜)",18000000,null,null,"","","契約金額 (税抜)",null,null,{"$f":"IF(U29=\"\",\"\",U29)","v":23100000},"請求金額(税抜)",9450000,"請求金額(税抜)",8550000,"請求金額(税抜)",18000000]
[null,null,null,"消費税",null,0.08,{"$f":"G29*F30","v":1848000},"消費税",{"$f":"I29*F30","v":756000},"消費税",{"$f":"K29*F30","v":684000},"消費税",{"$f":"SUM(I30,K30)","v":1440000},null,null,"","","消費税",null,{"$f":"$F$30","v":0.08},{"$f":"IF(G30=\"\",\"\",G30)","v":1848000},"消費税",756000,"消費税",684000,"消費税",1440000,null,null,"","","消費税",null,{"$f":"$F$30","v":0.08},{"$f":"IF(U30=\"\",\"\",U30)","v":1848000},"消費税",756000,"消費税",684000,"消費税",1440000]
[null,null,null,"契約金額 (税込)",null,null,{"$f":"SUM(G29:G30)","v":24948000},"請求金額(税込)",{"$f":"SUM(I29:I30)","v":10206000},"請求金額(税込)",{"$f":"SUM(K29:K30)","v":9234000},"請求金額(税込)",{"$f":"SUM(I31,K31)","v":19440000},null,null,"","","契約金額 (税込)",null,null,{"$f":"IF(G31=\"\",\"\",G31)","v":24948000},"請求金額(税込)",10206000,"請求金額(税込)",9234000,"請求金額(税込)",19440000,null,null,"","","契約金額 (税込)",null,null,{"$f":"IF(U31=\"\",\"\",U31)","v":24948000},"請求金額(税込)",10206000,"請求金額(税込)",9234000,"請求金額(税込)",19440000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"決裁","査定・承認",null,null,null,null,"受付",null,null,null,null,null,null,null,"決裁","査定・承認",null,null,null,null,"受付"]
[null,null,"※記入上の注意事項",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"伝票番号"]
[null,null,"1.　一現場一枚として記入し、二現場以上ある場合には現場別に請求書を作成してください。"]
[null,null,"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,"　"]

{"sheet":"記入例（請求明細）","index":6,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[15,2,15,3],[4,3,4,5],[5,3,5,5],[5,11,5,13],[6,3,6,5],[6,11,6,13],[8,2,9,3],[8,4,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[22,2,22,3],[23,2,23,3],[34,2,34,3],[35,2,35,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3]]}
[1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"( \"&A1&\" / \"&$N$40&\" )\"","v":"( 1 / 1 )"}]
[null,null,"（　請　求　明　細　）"]
[]
[null,null,"月度",{"$f":"IF('記入例（明細あり）'!G4=\"\",\"\",'記入例（明細あり）'!G4)","v":"2016-08-01"}]
[null,null,"工事コード",{"$f":"IF('記入例（明細あり）'!G5=\"\",\"\",'記入例（明細あり）'!G5)","v":"1000001-0001"}]
[null,null,"工事・工種名",{"$f":"IF('記入例（明細あり）'!G6=\"\",\"\",'記入例（明細あり）'!G6)","v":"○○ビル建設工事"},null,null,null,null,null,null,"社名",{"$f":"'記入例（明細あり）'!K5 &\"　\"&'記入例（明細あり）'!K6","v":"○○重機株式会社　□□支店"}]
[null,null,"注文番号",{"$f":"IF('記入例（明細あり）'!G7=\"\",\"\",'記入例（明細あり）'!G7)","v":"HCI150000201"},null,null,null,null,null,null,"取引先コード",{"$f":"IF('記入例（明細あり）'!K7=\"\",\"\",'記入例（明細あり）'!K7)","v":1234567}]
[]
[null,null,"内　　　訳",null,"契　　　　約",null,null,null,"前回まで出来高",null,"今回出来高",null,"累計出来高"]
[null,null,null,null,"数量","単位","単価","金額","数量","金額","数量","金額","数量","金額"]
[1,null,"SMW工事",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I11,K11)","v":0},{"$f":"SUM(J11,L11)","v":0}]
[1,null,"　施工費",null,3000,"m2",5000,{"$f":"E12*G12","v":15000000},1500,{"$f":"G12*I12","v":7500000},1500,{"$f":"G12*K12","v":7500000},{"$f":"SUM(I12,K12)","v":3000},{"$f":"SUM(J12,L12)","v":15000000}]
[1,null,"　労務費",null,30,"日",25000,{"$f":"E13*G13","v":750000},20,{"$f":"G13*I13","v":500000},10,{"$f":"G13*K13","v":250000},{"$f":"SUM(I13,K13)","v":30},750000]
[1,null,"　解体・搬出",null,2,"式",1500000,{"$f":"E14*G14","v":3000000},1,{"$f":"G14*I14","v":1500000},null,null,1,1500000]
[1,null,"　運搬費",null,1,"式",2000000,{"$f":"E15*G15","v":2000000},0.5,{"$f":"G15*I15","v":1000000},null,null,0.5,1000000]
[1,null,"（　小　　　計　）",null,null,null,null,{"$f":"SUM(H12:H15)","v":20750000},null,{"$f":"SUM(J11:J15)","v":10500000},null,{"$f":"SUM(L11:L15)","v":7750000},0,18250000]
[1,null,null,null,null,null,null,null,null,{"$f":"G17*I17","v":0},null,null,0,0]
[1,null,"杭工事",null,null,null,null,null,null,0,null,null,0,0]
[1,null,"　施工費",null,500,"ｍ",3000,{"$f":"E19*G19","v":1500000},null,0,340,{"$f":"G19*K19","v":1020000},340,1020000]
[1,null,"　労務費",null,15,"日",25000,{"$f":"E20*G20","v":375000},null,0,10,{"$f":"G20*K20","v":250000},10,250000]
[1,null,"　段取替",null,1,"式",500000,{"$f":"E21*G21","v":500000},null,null,1,{"$f":"G21*K21","v":500000},1,500000]
[1,null,"（　小　　　計　）",null,null,null,null,{"$f":"SUM(H19:H21)","v":2375000},null,{"$f":"SUM(J17:J21)","v":0},null,{"$f":"SUM(L17:L21)","v":1770000},0,1770000]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,"値引調整",null,1,"式",-25000,{"$f":"E24*G24","v":-25000},null,0,null,-20000,0,-20000]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[1,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"ページ　計",null,null,null,null,{"$f":"SUM(H11:H35)","v":46225000},null,{"$f":"SUM(J11:J35)","v":21000000},null,{"$f":"SUM(L11:L35)","v":19020000},null,{"$f":"SUM(N11:N35)","v":40020000}]
[]
[]
[null,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":"MAX(A:A)","v":1}]

{"sheet":"コード39","index":7,"n_rows":17,"n_cols":290,"rows_kept":17,"cut":false,"hidden":true,"merged":[[8,0,13,0],[8,1,13,1],[8,2,13,2],[12,5,12,289],[14,1,19,1],[14,2,19,2],[14,0,19,0],[17,5,17,289],[18,5,18,289],[2,0,7,0],[1,3,1,291],[2,1,7,1],[6,5,6,289],[2,2,7,2],[5,5,5,289]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1",null,null,null,null,null,null,null,null,null,null,null,null,"2",null,null,null,null,null,null,null,null,null,null,null,null,"3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,20]
["No.","名称","コード","バーコードイメージ"]
[1,"本社用",{"$f":"IF(AND('請求書（表紙）'!AM7=\"\",'請求書（表紙）'!AE5=\"\"),\"\",'請求書（表紙）'!AM7&\"-\"&'請求書（表紙）'!AE5)","v":""}]
[]
[null,null,null,null,null,{"$f":"IF($C3=\"\",\"\",Start39)","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,1,1)=\"\",\"\",INDEX(Area39,MATCH(MID($C3,1,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,2,1)=\"\",IF(LEN($C3)=1,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,2,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,3,1)=\"\",IF(LEN($C3)=2,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,3,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,4,1)=\"\",IF(LEN($C3)=3,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,4,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,5,1)=\"\",IF(LEN($C3)=4,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,5,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,6,1)=\"\",IF(LEN($C3)=5,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,6,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,7,1)=\"\",IF(LEN($C3)=6,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,7,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,8,1)=\"\",IF(LEN($C3)=7,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,8,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,9,1)=\"\",IF(LEN($C3)=8,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,9,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,10,1)=\"\",IF(LEN($C3)=9,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,10,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,11,1)=\"\",IF(LEN($C3)=10,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,11,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,12,1)=\"\",IF(LEN($C3)=11,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,12,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,13,1)=\"\",IF(LEN($C3)=12,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,13,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,14,1)=\"\",IF(LEN($C3)=13,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,14,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,15,1)=\"\",IF(LEN($C3)=14,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,15,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,16,1)=\"\",IF(LEN($C3)=15,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,16,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,17,1)=\"\",IF(LEN($C3)=16,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,17,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,18,1)=\"\",IF(LEN($C3)=17,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,18,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,19,1)=\"\",IF(LEN($C3)=18,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,19,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C3,20,1)=\"\",IF(LEN($C3)=19,Start39,\"\"),INDEX(Area39,MATCH(MID($C3,20,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(LEN(C3)=20,Start39,\"\")","v":""},"","","","","","","","","","",""]
[]
[]
[]
[2,"注文番号",{"$f":"'請求書（表紙）'!U7","v":""}]
[]
[null,null,null,null,null,{"$f":"IF($C9=\"\",\"\",Start39)","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,1,1)=\"\",\"\",INDEX(Area39,MATCH(MID($C9,1,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,2,1)=\"\",IF(LEN($C9)=1,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,2,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,3,1)=\"\",IF(LEN($C9)=2,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,3,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,4,1)=\"\",IF(LEN($C9)=3,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,4,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,5,1)=\"\",IF(LEN($C9)=4,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,5,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,6,1)=\"\",IF(LEN($C9)=5,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,6,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,7,1)=\"\",IF(LEN($C9)=6,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,7,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,8,1)=\"\",IF(LEN($C9)=7,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,8,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,9,1)=\"\",IF(LEN($C9)=8,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,9,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,10,1)=\"\",IF(LEN($C9)=9,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,10,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,11,1)=\"\",IF(LEN($C9)=10,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,11,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,12,1)=\"\",IF(LEN($C9)=11,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,12,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,13,1)=\"\",IF(LEN($C9)=12,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,13,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,14,1)=\"\",IF(LEN($C9)=13,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,14,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,15,1)=\"\",IF(LEN($C9)=14,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,15,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,16,1)=\"\",IF(LEN($C9)=15,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,16,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,17,1)=\"\",IF(LEN($C9)=16,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,17,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,18,1)=\"\",IF(LEN($C9)=17,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,18,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,19,1)=\"\",IF(LEN($C9)=18,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,19,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C9,20,1)=\"\",IF(LEN($C9)=19,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,20,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(LEN(C9)=20,Start39,\"\")","v":""},"","","","","","","","","","",""]
[]
[]
[]
[99,"記入例",{"$f":"'記入例（明細なし）'!$AM$7&\"-\"&'記入例（明細なし）'!$AE$5","v":"5007500-9234000"}]
[]
[null,null,null,null,null,{"$f":"IF($C15=\"\",\"\",Start39)","v":1},0,0,1,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C15,1,1)=\"\",\"\",INDEX(Area39,MATCH(MID($C15,1,1),Char39,0),0))","v":1},1,0,1,0,0,1,1,0,1,0,1,null,{"$f":"IF(MID($C15,2,1)=\"\",IF(LEN($C15)=1,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,2,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C15,3,1)=\"\",IF(LEN($C15)=2,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,3,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C15,4,1)=\"\",IF(LEN($C15)=3,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,4,1),Char39,0),0))","v":1},0,1,0,0,1,0,1,1,0,1,1,null,{"$f":"IF(MID($C15,5,1)=\"\",IF(LEN($C15)=4,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,5,1),Char39,0),0))","v":1},1,0,1,0,0,1,1,0,1,0,1,null,{"$f":"IF(MID($C15,6,1)=\"\",IF(LEN($C15)=5,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,6,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C15,7,1)=\"\",IF(LEN($C15)=6,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,7,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C15,8,1)=\"\",IF(LEN($C15)=7,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,8,1),Char39,0),0))","v":1},0,0,1,0,1,0,1,1,0,1,1,null,{"$f":"IF(MID($C15,9,1)=\"\",IF(LEN($C15)=8,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,9,1),Char39,0),0))","v":1},0,1,1,0,0,1,0,1,1,0,1,null,{"$f":"IF(MID($C15,10,1)=\"\",IF(LEN($C15)=9,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,10,1),Char39,0),0))","v":1},0,1,1,0,0,1,0,1,0,1,1,null,{"$f":"IF(MID($C15,11,1)=\"\",IF(LEN($C15)=10,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,11,1),Char39,0),0))","v":1},1,0,1,1,0,0,1,0,1,0,1,null,{"$f":"IF(MID($C15,12,1)=\"\",IF(LEN($C15)=11,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,12,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,0,1,1,null,{"$f":"IF(MID($C15,13,1)=\"\",IF(LEN($C15)=12,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,13,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C15,14,1)=\"\",IF(LEN($C15)=13,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,14,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C15,15,1)=\"\",IF(LEN($C15)=14,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,15,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C15,16,1)=\"\",IF(LEN($C15)=15,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,16,1),Char39,0),0))","v":1},0,0,1,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C15,17,1)=\"\",IF(LEN($C15)=16,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,17,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C15,18,1)=\"\",IF(LEN($C15)=17,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,18,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C15,19,1)=\"\",IF(LEN($C15)=18,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,19,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(MID($C15,20,1)=\"\",IF(LEN($C15)=19,Start39,\"\"),INDEX(Area39,MATCH(MID($C15,20,1),Char39,0),0))","v":""},"","","","","","","","","","","",null,{"$f":"IF(LEN(C15)=20,Start39,\"\")","v":""},"","","","","","","","","","",""]

{"sheet":"パターンデータ","index":8,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":true,"merged":[[1,2,1,13],[67,2,67,5],[60,2,60,5],[61,2,61,5],[62,2,62,5],[63,2,63,5],[57,2,57,5],[56,2,56,5],[58,2,58,5],[59,2,59,5],[48,2,48,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[53,2,53,5],[66,2,66,5],[65,2,65,5],[68,2,68,5],[54,2,54,5],[55,2,55,5],[64,2,64,5]]}
[null,"コード39の符号"]
[null,"文字","符号"]
[null,"0",1,0,1,0,0,1,1,0,1,1,0,1]
[null,"1",1,1,0,1,0,0,1,0,1,0,1,1]
[null,"2",1,0,1,1,0,0,1,0,1,0,1,1]
[null,"3",1,1,0,1,1,0,0,1,0,1,0,1]
[null,"4",1,0,1,0,0,1,1,0,1,0,1,1]
[null,"5",1,1,0,1,0,0,1,1,0,1,0,1]
[null,"6",1,0,1,1,0,0,1,1,0,1,0,1]
[null,"7",1,0,1,0,0,1,0,1,1,0,1,1]
[null,"8",1,1,0,1,0,0,1,0,1,1,0,1]
[null,"9",1,0,1,1,0,0,1,0,1,1,0,1]
[null,"A",1,1,0,1,0,1,0,0,1,0,1,1]
[null,"B",1,0,1,1,0,1,0,0,1,0,1,1]
[null,"C",1,1,0,1,1,0,1,0,0,1,0,1]
[null,"D",1,0,1,0,1,1,0,0,1,0,1,1]
[null,"E",1,1,0,1,0,1,1,0,0,1,0,1]
[null,"F",1,0,1,1,0,1,1,0,0,1,0,1]
[null,"G",1,0,1,0,1,0,0,1,1,0,1,1]
[null,"H",1,1,0,1,0,1,0,0,1,1,0,1]
[null,"I",1,0,1,1,0,1,0,0,1,1,0,1]
[null,"J",1,0,1,0,1,1,0,0,1,1,0,1]
[null,"K",1,1,0,1,0,1,0,1,0,0,1,1]
[null,"L",1,0,1,1,0,1,0,1,0,0,1,1]
[null,"M",1,1,0,1,1,0,1,0,1,0,0,1]
[null,"N",1,0,1,0,1,1,0,1,0,0,1,1]
[null,"O",1,1,0,1,0,1,1,0,1,0,0,1]
[null,"P",1,0,1,1,0,1,1,0,1,0,0,1]
[null,"Q",1,0,1,0,1,0,1,1,0,0,1,1]
[null,"R",1,1,0,1,0,1,0,1,1,0,0,1]
[null,"S",1,0,1,1,0,1,0,1,1,0,0,1]
[null,"T",1,0,1,0,1,1,0,1,1,0,0,1]
[null,"U",1,1,0,0,1,0,1,0,1,0,1,1]
[null,"V",1,0,0,1,1,0,1,0,1,0,1,1]
[null,"W",1,1,0,0,1,1,0,1,0,1,0,1]
[null,"X",1,0,0,1,0,1,1,0,1,0,1,1]
[null,"Y",1,1,0,0,1,0,1,1,0,1,0,1]
[null,"Z",1,0,0,1,1,0,1,1,0,1,0,1]
[null,"-",1,0,0,1,0,1,0,1,1,0,1,1]
[null,".",1,1,0,0,1,0,1,0,1,1,0,1]
[null," ",1,0,0,1,1,0,1,0,1,1,0,1]
[null,"$",1,0,0,1,0,0,1,0,0,1,0,1]
[null,"/",1,0,0,1,0,0,1,0,1,0,0,1]
[null,"+",1,0,0,1,0,1,0,0,1,0,0,1]
[null,"%",1,0,1,0,0,1,0,0,1,0,0,1]
[null,"*",1,0,0,1,0,1,1,0,1,1,0,1]
[]
[null,"NW-7の符号化パターン"]
[null,"文字","符号"]
[null,"0","101010011"]
[null,"1","101011001"]
[null,"2","101001011"]
[null,"3","110010101"]
[null,"4","101101001"]
[null,"5","110101001"]
[null,"6","100101011"]
[null,"7","100101101"]
[null,"8","100110101"]
[null,"9","110100101"]
[null,"-","101001101"]
[null,"$","101100101"]
[null,":","1101011011"]
[null,"/","1101101011"]
[null,".","1101101101"]
[null,"+","1011011011"]
[null,"A","1011001001"]
[null,"B","1001001011"]
[null,"C","1010010011"]
[null,"D","1010011001"]