{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["お支払について","使い方","請求書 (表紙)","請求明細","記入例（請求明細なし）","記入例 （請求明細あり）","記入例（請求明細）","コード39","パターンデータ"],"not_rendered":{"charts":0,"images":4,"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":43,"n_cols":35,"rows_kept":43,"cut":false,"hidden":false,"merged":[[45,29,45,30],[39,25,39,26],[39,29,39,30],[40,25,40,26],[42,25,42,26],[42,29,42,30],[32,32,32,33],[34,25,34,26],[34,29,34,30],[35,25,35,26],[35,29,35,30],[43,25,43,26],[43,29,43,30],[44,25,44,26],[44,29,44,30],[7,32,7,34],[8,32,8,34],[5,32,6,34],[3,32,4,34],[5,31,6,31],[29,25,29,26],[29,27,29,30],[29,32,30,33],[29,34,30,34],[15,29,15,30],[16,29,16,30],[17,29,17,30],[18,29,18,30],[19,29,19,30],[20,29,20,30],[21,29,21,30],[22,29,22,30],[23,29,23,30],[24,29,24,30],[25,29,25,30],[17,27,17,28],[18,27,18,28],[19,27,19,28],[20,27,20,28],[45,13,45,14],[45,17,45,18],[39,13,39,14],[39,17,39,18],[40,13,40,14],[40,17,40,18],[42,13,42,14],[42,17,42,18],[4,27,4,29],[5,27,5,29],[7,25,8,26],[7,27,8,28],[21,27,21,28],[22,27,22,28],[23,27,23,28],[24,27,24,28],[25,27,25,28],[36,25,36,26],[36,29,36,30],[37,25,37,26],[37,29,37,30],[38,25,38,26],[38,29,38,30],[45,25,45,26],[26,17,26,18],[18,15,18,16],[19,15,19,16],[20,15,20,16],[24,15,24,16],[25,15,25,16],[32,20,32,21],[34,13,34,14],[34,17,34,18],[27,17,27,18],[28,17,28,18],[21,15,21,16],[22,15,22,16],[23,15,23,16],[25,17,25,18],[45,5,45,6],[45,1,45,2],[7,13,8,14],[7,15,8,16],[7,20,7,22],[8,20,8,22],[4,15,4,17],[5,15,5,17],[10,17,10,18],[11,17,11,18],[12,17,12,18],[13,17,13,18],[14,17,14,18],[15,17,15,18],[16,17,16,18],[17,17,17,18],[29,13,29,14],[29,15,29,18],[29,20,30,21],[29,22,30,22],[26,15,26,16],[27,15,27,16],[28,15,28,16],[18,17,18,18],[29,10,30,10],[29,8,30,9],[29,1,29,2],[29,3,29,6],[43,13,43,14],[43,17,43,18],[44,13,44,14],[44,17,44,18],[36,13,36,14],[36,17,36,18],[37,13,37,14],[37,17,37,18],[38,13,38,14],[38,17,38,18],[32,8,32,9],[41,1,41,2],[41,5,41,6],[35,13,35,14],[35,17,35,18],[35,1,35,2],[35,5,35,6],[42,1,42,2],[42,5,42,6],[1,1,1,3],[8,8,8,10],[7,8,7,10],[4,3,4,5],[5,3,5,5],[7,1,8,2],[7,3,8,4],[4,1,4,2],[3,1,3,2],[5,1,5,2],[5,7,6,7],[26,3,26,4],[26,5,26,6],[27,3,27,4],[22,5,22,6],[23,3,23,4],[23,5,23,6],[24,3,24,4],[24,5,24,6],[25,3,25,4],[25,5,25,6],[27,5,27,6],[22,3,22,4],[17,3,17,4],[17,5,17,6],[18,3,18,4],[18,5,18,6],[19,3,19,4],[15,3,15,4],[15,5,15,6],[16,3,16,4],[16,5,16,6],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[28,3,28,4],[28,5,28,6],[34,1,34,2],[34,5,34,6],[19,5,19,6],[20,3,20,4],[20,5,20,6],[10,3,10,4],[10,5,10,6],[11,3,11,4],[11,5,11,6],[12,3,12,4],[12,5,12,6],[13,3,13,4],[13,5,13,6],[14,3,14,4],[14,5,14,6],[21,3,21,4],[21,5,21,6],[15,15,15,16],[16,15,16,16],[17,15,17,16],[19,17,19,18],[20,17,20,18],[21,17,21,18],[22,17,22,18],[23,17,23,18],[24,17,24,18],[26,27,26,28],[26,29,26,30],[27,27,27,28],[27,29,27,30],[28,27,28,28],[28,29,28,30],[40,29,40,30],[10,29,10,30],[11,27,11,28],[11,29,11,30],[12,27,12,28],[12,29,12,30],[13,27,13,28],[13,29,13,30],[14,27,14,28],[14,29,14,30],[10,27,10,28],[15,27,15,28],[16,27,16,28],[1,13,1,15],[1,25,1,27],[3,13,3,14],[3,25,3,26],[3,8,4,10],[5,8,6,10],[3,20,4,22],[5,20,6,22],[5,19,6,19],[4,13,4,14],[5,13,5,14],[4,25,4,26],[5,25,5,26]]}
["（一般請求用）",null,null,null,null,null,null,null,null,null,null,null,"（一般請求用）",null,null,null,null,null,null,null,null,null,null,null,"（一般請求用）"]
[null,"成幸利根株式会社",null,null,"御中","請　求　書",null,null,null,null,null,null,null,"成幸利根株式会社",null,null,"御中","請　求　書",null,null,null,null,null,null,null,"成幸利根株式会社",null,null,"御中","請　求　書"]
[]
[null,"月度",null,null,null,null,null,"住所　",null,null,null,null,null,"月度",null,{"$f":"IF(D4=\"\",\"\",D4)","v":""},null,null,null,"住所　",{"$f":"IF(I4=\"\",\"\",I4)","v":""},null,null,null,null,"月度",null,{"$f":"P4","v":""},null,null,null,"住所　",{"$f":"U4","v":""}]
[null,"工事コード",null,null,null,null,null,null,null,null,null,null,null,"工事コード",null,{"$f":"IF(D5=\"\",\"\",D5)","v":""},null,null,null,null,null,null,null,null,null,"工事コード",null,{"$f":"P5","v":""}]
[null,"工事・工種名",null,null,null,null,null,"社名　",null,null,null,null,null,"工事・工種名",null,{"$f":"IF(D6=\"\",\"\",D6)","v":""},null,null,null,"社名　",{"$f":"IF(I6=\"\",\"\",I6)","v":""},null,null,null,null,"工事・工種名",null,{"$f":"P6","v":""},null,null,null,"社名　",{"$f":"U6","v":""}]
[]
[null,"請求金額\n（税込）",null,{"$f":"IF(K33=0,\"\",K33)","v":""},null,null,null,null,null,null,null,null,null,"請求金額\n（税込）",null,{"$f":"D8","v":""},null,null,null,null,{"$f":"IF(I8=\"\",\"\",I8)","v":""},null,null,null,null,"請求金額\n（税込）",null,{"$f":"P8","v":""},null,null,null,null,{"$f":"U8","v":""}]
[null,null,null,null,null,null,null,"取引先コード　",null,null,null,null,null,null,null,null,null,null,null,"取引先コード　",{"$f":"IF(I9=\"\",\"\",I9)","v":""},null,null,null,null,null,null,null,null,null,null,"取引先コード　",{"$f":"U9","v":""}]
[]
[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,1,{"$f":"IF(C12=\"\",\"\",C12)","v":""},"","","","","","","","",null,null,1,{"$f":"IF(O12=\"\",\"\",O12)","v":""},{"$f":"IF(P12=\"\",\"\",P12)","v":""},{"$f":"IF(Q12=\"\",\"\",Q12)","v":""},{"$f":"IF(R12=\"\",\"\",R12)","v":""},{"$f":"IF(S12=\"\",\"\",S12)","v":""},{"$f":"IF(T12=\"\",\"\",T12)","v":""},{"$f":"IF(U12=\"\",\"\",U12)","v":""},{"$f":"IF(V12=\"\",\"\",V12)","v":""},""]
[null,2,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(C13=\"\",\"\",C13)","v":""},{"$f":"IF(D13=\"\",\"\",D13)","v":""},{"$f":"IF(E13=\"\",\"\",E13)","v":""},{"$f":"IF(F13=\"\",\"\",F13)","v":""},{"$f":"IF(G13=\"\",\"\",G13)","v":""},{"$f":"IF(H13=\"\",\"\",H13)","v":""},{"$f":"IF(I13=\"\",\"\",I13)","v":""},{"$f":"IF(J13=\"\",\"\",J13)","v":""},{"$f":"IF(K13=\"\",\"\",K13)","v":""},null,null,2,"","","","","","","","",""]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"","","","","","","","","",null,null,3,"","","","","","","","",""]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4,"","","","","","","","","",null,null,4,"","","","","","","","",""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5,"","","","","","","","","",null,null,5,"","","","","","","","",""]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6,"","","","","","","","","",null,null,6,"","","","","","","","",""]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7,"","","","","","","","","",null,null,7,"","","","","","","","",""]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8,"","","","","","","","","",null,null,8,"","","","","","","","",""]
[null,9,null,null,null,null,null,null,null,null,null,null,null,9,"","","","","","","","","",null,null,9,"","","","","","","","",""]
[null,10,null,null,null,null,null,null,null,null,null,null,null,10,"","","","","","","","","",null,null,10,"","","","","","","","",""]
[null,11,null,null,null,null,null,null,null,null,null,null,null,11,"","","","","","","","","",null,null,11,"","","","","","","","",""]
[null,12,null,null,null,null,null,null,null,null,null,null,null,12,"","","","","","","","","",null,null,12,"","","","","","","","",""]
[null,13,null,null,null,null,null,null,null,null,null,null,null,13,"","","","","","","","","",null,null,13,"","","","","","","","",""]
[null,14,null,null,null,null,null,null,null,null,null,null,null,14,"","","","","","","","","",null,null,14,"","","","","","","","",""]
[null,15,null,null,null,null,null,null,null,null,null,null,null,15,"","","","","","","","","",null,null,15,"","","","","","","","",""]
[null,16,null,null,null,null,null,null,null,null,null,null,null,16,"","","","","","","","","",null,null,16,"","","","","","","","",""]
[null,17,null,null,null,null,null,null,null,null,null,null,null,17,"","","","","","","","","",null,null,17,"","","","","","","","",""]
[null,18,null,null,null,null,null,null,null,null,null,null,null,18,"","","","","","","","","",null,null,18,"","","","","","","","",""]
[null,"決　裁",null,"査定・承認",null,null,null,"受　付","請求金額　(税抜)",null,{"$f":"SUM(K12:K29)-SUMIF(D12:E29,\"（　小　　　計　）\",K12:K29)","v":0},null,null,"決　裁",null,"査定・承認",null,null,null,"受　付","請求金額　(税抜)",null,0,null,null,"決　裁",null,"査定・承認",null,null,null,"受　付","請求金額　(税抜)",null,{"$f":"IF(W30=\"\",\"\",W30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"消費税",0.08,{"$f":"K30*J32","v":0},null,null,null,null,null,null,null,null,null,"消費税",0.08,0,null,null,null,null,null,null,null,null,null,"消費税",{"$f":"IF(V32=\"\",\"\",V32)","v":0.08},0]
[null,null,null,null,null,null,null,null,"請求金額　(税込)",null,{"$f":"IF(AND(K30=\"\",K32=\"\"),\"\",SUM(K30:K32))","v":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,null,null,null,null,null,null,null,null,"工事コード",null,"科　　目","作業工程","名称/摘要",null,"金　　額","税率","消費税","税込み金額"]
[]
[null,null,"※記入上の注意事項"]
[null,null,"1.　一現場一枚として記入し、二現場以上ある場合には現場別に請求書を作成してください。"]
[null,null,"2.　工事コード、工事・工種名、取引先コードを必ず記入してください。不明のときは工事部に照会してください。"]
[null,null,"3.　請求書、請求明細は支店用と本社用の2部を提出してください。"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"工事コード",null,"立替先コード","立替先名","名称/摘要",null,"金　　額",null,"伝票番号"]

{"sheet":"請求明細","index":3,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":false,"merged":[[32,4,32,5],[32,6,32,7],[35,4,35,5],[35,6,35,7],[36,8,36,10],[29,4,29,5],[29,6,29,7],[30,4,30,5],[30,6,30,7],[31,4,31,5],[31,6,31,7],[19,4,19,5],[19,6,19,7],[20,4,20,5],[20,6,20,7],[21,4,21,5],[21,6,21,7],[16,4,16,5],[16,6,16,7],[17,4,17,5],[17,6,17,7],[18,4,18,5],[18,6,18,7],[13,4,13,5],[13,6,13,7],[14,4,14,5],[14,6,14,7],[15,4,15,5],[15,6,15,7],[10,4,10,5],[10,6,10,7],[11,4,11,5],[11,6,11,7],[12,4,12,5],[12,6,12,7],[7,4,7,5],[7,6,7,7],[8,4,8,5],[8,6,8,7],[9,4,9,5],[9,6,9,7],[3,2,3,3],[4,2,4,3],[4,4,4,6],[4,9,4,11],[5,2,5,3],[5,4,5,6],[5,9,5,11]]}
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"\"( \"&A1&\" / \"&$L$41&\" )\"","v":"( 1 / 1 )"}]
[null,null,"（　請　求　明　細　）"]
[]
[null,null,"月度",null,{"$f":"IF('請求書 (表紙)'!$D$4=\"\",\"\",'請求書 (表紙)'!$D$4)","v":""}]
[null,null,"工事コード",null,{"$f":"IF('請求書 (表紙)'!$D$5=\"\",\"\",'請求書 (表紙)'!$D$5)","v":""},null,null,null,"社名",{"$f":"SUBSTITUTE(SUBSTITUTE('請求書 (表紙)'!$I$7&\" \"&'請求書 (表紙)'!$I$8,\"株式会社\",\"㈱\"),\"有限会社\",\"㈲\")","v":" "}]
[null,null,"工事・工種名",null,{"$f":"IF('請求書 (表紙)'!$D$6=\"\",\"\",'請求書 (表紙)'!$D$6)","v":""},null,null,null,"取引先コード",{"$f":"IF('請求書 (表紙)'!$I$9=\"\",\"\",'請求書 (表紙)'!$I$9)","v":""}]
[]
[null,null,null,"日付","内　　　訳",null,"摘　　　要",null,"数　量","単位","単　価","金　　額"]
[1,null,1]
[1,null,2]
[1,null,3]
[1,null,4]
[1,null,5]
[1,null,6]
[1,null,7]
[1,null,8]
[1,null,9]
[1,null,10]
[1,null,11]
[1,null,12]
[1,null,13]
[1,null,14]
[1,null,15]
[1,null,16]
[1,null,17]
[1,null,18]
[1,null,19]
[1,null,20]
[1,null,21]
[1,null,22]
[1,null,23]
[1,null,24]
[1,null,25]
[1,null,26]
[1,null,27]
[1,null,28]
[null,null,null,null,null,null,null,null,"ページ　計",null,null,{"$f":"SUM(L9:L36)-SUMIF(E9:F36,\"（　小　　　計　）\",L9:L36)","v":0}]
[]
[]
[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}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L47:L74)-SUMIF(E47:F74,\"（　小　　　計　）\",L47:L74)","v":0}]

{"sheet":"記入例（請求明細なし）","index":4,"n_rows":43,"n_cols":35,"rows_kept":43,"cut":false,"hidden":false,"merged":[[45,1,45,2],[45,5,45,6],[45,13,45,14],[45,17,45,18],[45,25,45,26],[45,29,45,30],[43,13,43,14],[43,17,43,18],[43,25,43,26],[43,29,43,30],[44,13,44,14],[44,17,44,18],[44,25,44,26],[44,29,44,30],[42,1,42,2],[42,5,42,6],[42,13,42,14],[42,17,42,18],[42,25,42,26],[42,29,42,30],[40,13,40,14],[40,17,40,18],[40,25,40,26],[40,29,40,30],[41,1,41,2],[41,5,41,6],[38,13,38,14],[38,17,38,18],[38,25,38,26],[38,29,38,30],[39,13,39,14],[39,17,39,18],[39,25,39,26],[39,29,39,30],[36,13,36,14],[36,17,36,18],[36,25,36,26],[36,29,36,30],[37,13,37,14],[37,17,37,18],[37,25,37,26],[37,29,37,30],[35,1,35,2],[35,5,35,6],[35,13,35,14],[35,17,35,18],[35,25,35,26],[35,29,35,30],[32,8,32,9],[32,20,32,21],[32,32,32,33],[34,1,34,2],[34,5,34,6],[34,13,34,14],[34,17,34,18],[34,25,34,26],[34,29,34,30],[29,20,30,21],[29,22,30,22],[29,25,29,26],[29,27,29,30],[29,32,30,33],[29,34,30,34],[29,1,29,2],[29,3,29,6],[29,8,30,9],[29,10,30,10],[29,13,29,14],[29,15,29,18],[28,3,28,4],[28,5,28,6],[28,15,28,16],[28,17,28,18],[28,27,28,28],[28,29,28,30],[27,3,27,4],[27,5,27,6],[27,15,27,16],[27,17,27,18],[27,27,27,28],[27,29,27,30],[26,3,26,4],[26,5,26,6],[26,15,26,16],[26,17,26,18],[26,27,26,28],[26,29,26,30],[25,3,25,4],[25,5,25,6],[25,15,25,16],[25,17,25,18],[25,27,25,28],[25,29,25,30],[24,3,24,4],[24,5,24,6],[24,15,24,16],[24,17,24,18],[24,27,24,28],[24,29,24,30],[23,3,23,4],[23,5,23,6],[23,15,23,16],[23,17,23,18],[23,27,23,28],[23,29,23,30],[22,3,22,4],[22,5,22,6],[22,15,22,16],[22,17,22,18],[22,27,22,28],[22,29,22,30],[21,3,21,4],[21,5,21,6],[21,15,21,16],[21,17,21,18],[21,27,21,28],[21,29,21,30],[20,3,20,4],[20,5,20,6],[20,15,20,16],[20,17,20,18],[20,27,20,28],[20,29,20,30],[19,3,19,4],[19,5,19,6],[19,15,19,16],[19,17,19,18],[19,27,19,28],[19,29,19,30],[18,3,18,4],[18,5,18,6],[18,15,18,16],[18,17,18,18],[18,27,18,28],[18,29,18,30],[17,3,17,4],[17,5,17,6],[17,15,17,16],[17,17,17,18],[17,27,17,28],[17,29,17,30],[16,3,16,4],[16,5,16,6],[16,15,16,16],[16,17,16,18],[16,27,16,28],[16,29,16,30],[15,3,15,4],[15,5,15,6],[15,15,15,16],[15,17,15,18],[15,27,15,28],[15,29,15,30],[14,3,14,4],[14,5,14,6],[14,15,14,16],[14,17,14,18],[14,27,14,28],[14,29,14,30],[13,3,13,4],[13,5,13,6],[13,15,13,16],[13,17,13,18],[13,27,13,28],[13,29,13,30],[7,27,8,28],[7,32,7,34],[8,8,8,10],[8,20,8,22],[8,32,8,34],[10,27,10,28],[12,3,12,4],[12,5,12,6],[12,15,12,16],[12,17,12,18],[12,27,12,28],[12,29,12,30],[10,29,10,30],[11,3,11,4],[11,5,11,6],[11,15,11,16],[11,17,11,18],[11,27,11,28],[11,29,11,30],[10,3,10,4],[10,5,10,6],[10,15,10,16],[10,17,10,18],[4,3,4,5],[4,13,4,14],[4,15,4,17],[7,1,8,2],[7,3,8,4],[7,13,8,14],[7,15,8,16],[7,20,7,22],[7,25,8,26],[1,25,1,27],[3,25,3,26],[1,13,1,15],[3,13,3,14],[1,1,1,3],[3,1,3,2],[3,32,4,34],[5,32,6,34],[5,31,6,31],[3,20,4,22],[5,19,6,19],[5,20,6,22],[5,7,6,7],[5,8,6,10],[3,8,4,10],[4,25,4,26],[4,27,4,29],[5,1,5,2],[5,3,5,5],[5,13,5,14],[5,15,5,17],[5,25,5,26],[5,27,5,29],[4,1,4,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,"2016-07-01",null,null,null,"住所　","東京都○○区□□1-1",null,null,null,null,"月度",null,{"$f":"D4","v":"2016-07-01"},null,null,null,"住所　",{"$f":"I4","v":"東京都○○区□□1-1"},null,null,null,null,"月度",null,{"$f":"P4","v":"2016-07-01"},null,null,null,"住所　",{"$f":"U4","v":"東京都○○区□□1-1"}]
[null,"工事コード",null,"100001-0001",null,null,null,null,null,null,null,null,null,"工事コード",null,{"$f":"IF(D5=\"\",\"\",D5)","v":"100001-0001"},null,null,null,null,null,null,null,null,null,"工事コード",null,{"$f":"IF(P5=\"\",\"\",P5)","v":"100001-0001"}]
[null,"工事・工種名",null,"○○立坑SMW",null,null,null,"社名　","○○産業株式会社",null,null,null,null,"工事・工種名",null,{"$f":"IF(D6=\"\",\"\",D6)","v":"○○立坑SMW"},null,null,null,"社名　",{"$f":"I6","v":"○○産業株式会社"},null,null,null,null,"工事・工種名",null,{"$f":"IF(P6=\"\",\"\",P6)","v":"○○立坑SMW"},null,null,null,"社名　",{"$f":"U6","v":"○○産業株式会社"}]
[]
[null,"請求金額\n（税込）",null,{"$f":"K33","v":2678400},null,null,null,null,"□□支店",null,null,null,null,"請求金額\n（税込）",null,{"$f":"D8","v":2678400},null,null,null,null,{"$f":"IF(I8=\"\",\"\",I8)","v":"□□支店"},null,null,null,null,"請求金額\n（税込）",null,{"$f":"P8","v":2678400},null,null,null,null,{"$f":"IF(U8=\"\",\"\",U8)","v":"□□支店"}]
[null,null,null,null,null,null,null,"取引先コード　",5029800,null,null,null,null,null,null,null,null,null,null,"取引先コード　",{"$f":"I9","v":5029800},null,null,null,null,null,null,null,null,null,null,"取引先コード　",{"$f":"U9","v":5029800}]
[]
[null,null,"日付","内　　　訳",null,"摘　　　要",null,"数量","単位","単価","金　　額",null,null,null,"日付","内　　　訳",null,"摘　　　要",null,"数量","単位","単価","金　　額",null,null,null,"日付","内　　　訳",null,"摘　　　要",null,"数量","単位","単価","金　　額"]
[null,1,"2016-07-01","材料A",null,null,null,100,"kg",3000,{"$f":"H12*J12","v":300000},null,null,1,{"$f":"IF(C12=\"\",\"\",C12)","v":"2016-07-01"},"材料A","","","",100,"kg",3000,300000,null,null,1,{"$f":"IF(O12=\"\",\"\",O12)","v":"2016-07-01"},"材料A","","","",100,"kg",3000,300000]
[null,2,null,"材料B",null,null,null,200,"kg",2000,{"$f":"H13*J13","v":400000},null,null,2,"","材料B","","","",200,"kg",2000,400000,null,null,2,"","材料B","","","",200,"kg",2000,400000]
[null,3,null,"送料",null,null,null,1,"式",10000,{"$f":"H14*J14","v":10000},null,null,3,"","送料","","","",1,"式",10000,10000,null,null,3,"","送料","","","",1,"式",10000,10000]
[null,4,null,"（　小　　　計　）",null,null,null,null,null,null,{"$f":"SUM(K12:K14)","v":710000},null,null,4,"","（　小　　　計　）","","","","","","",710000,null,null,4,"","（　小　　　計　）","","","","","","",710000]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5,"","","","","","","","","",null,null,5,"","","","","","","","",""]
[null,6,"2016-07-10","材料A",null,null,null,150,"kg",3000,{"$f":"H17*J17","v":450000},null,null,6,"2016-07-10","材料A","","","",150,"kg",3000,450000,null,null,6,"2016-07-10","材料A","","","",150,"kg",3000,450000]
[null,7,null,"材料B",null,null,null,100,"kg",2000,{"$f":"H18*J18","v":200000},null,null,7,"","材料B","","","",100,"kg",2000,200000,null,null,7,"","材料B","","","",100,"kg",2000,200000]
[null,8,null,"送料",null,null,null,1,"式",10000,{"$f":"H19*J19","v":10000},null,null,8,"","送料","","","",1,"式",10000,10000,null,null,8,"","送料","","","",1,"式",10000,10000]
[null,9,null,"（　小　　　計　）",null,null,null,null,null,null,{"$f":"SUM(K17:K19)","v":660000},null,null,9,"","（　小　　　計　）","","","","","","",660000,null,null,9,"","（　小　　　計　）","","","","","","",660000]
[null,10,null,null,null,null,null,null,null,null,null,null,null,10,"","","","","","","","","",null,null,10,"","","","","","","","",""]
[null,11,"2016-07-20","材料C",null,"φ20×1000mm",null,100,"本",8000,{"$f":"H22*J22","v":800000},null,null,11,"2016-07-20","材料C","","φ20×1000mm","",100,"本",8000,800000,null,null,11,"2016-07-20","材料C","","φ20×1000mm","",100,"本",8000,800000]
[null,12,null,"材料D",null,"300×200×1000",null,20,"個",15000,{"$f":"H23*J23","v":300000},null,null,12,"","材料D","","300×200×1000","",20,"個",15000,300000,null,null,12,"","材料D","","300×200×1000","",20,"個",15000,300000]
[null,13,null,"送料",null,null,null,1,"式",10000,{"$f":"H24*J24","v":10000},null,null,13,"","送料","","","",1,"式",10000,10000,null,null,13,"","送料","","","",1,"式",10000,10000]
[null,14,null,"（　小　　　計　）",null,null,null,null,null,null,{"$f":"SUM(K22:K24)","v":1110000},null,null,14,"","（　小　　　計　）","","","","","","",1110000,null,null,14,"","（　小　　　計　）","","","","","","",1110000]
[null,15,null,null,null,null,null,null,null,null,null,null,null,15,"","","","","","","","","",null,null,15,"","","","","","","","",""]
[null,16,null,null,null,null,null,null,null,null,null,null,null,16,"","","","","","","","","",null,null,16,"","","","","","","","",""]
[null,17,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(C28=\"\",\"\",C28)","v":""},"","","","","","","","",null,null,17,"","","","","","","","",""]
[null,18,null,null,null,null,null,null,null,null,null,null,null,18,"","","","","","","","","",null,null,18,"","","","","","","","",""]
[null,"決　裁",null,"査定・承認",null,null,null,"受　付","請求金額　(税抜)",null,{"$f":"SUM(K12:K29)-SUMIF(D12:E29,\"（　小　　　計　）\",K12:K29)","v":2480000},null,null,"決　裁",null,"査定・承認",null,null,null,"受　付","請求金額　(税抜)",null,2480000,null,null,"決　裁",null,"査定・承認",null,null,null,"受　付","請求金額　(税抜)",null,{"$f":"IF(W30=\"\",\"\",W30)","v":2480000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"消費税",0.08,{"$f":"K30*J32","v":198400},null,null,null,null,null,null,null,null,null,"消費税",0.08,198400,null,null,null,null,null,null,null,null,null,"消費税",{"$f":"IF(V32=\"\",\"\",V32)","v":0.08},198400]
[null,null,null,null,null,null,null,null,"請求金額　(税込)",null,{"$f":"SUM(K30:K32)","v":2678400},null,null,null,null,null,null,null,null,null,"請求金額　(税込)",null,2678400,null,null,null,null,null,null,null,null,null,"請求金額　(税込)",null,2678400]
[null,null,null,null,null,null,null,null,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,"3.　請求書、請求明細は支店用と本社用の2部を提出してください。"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"工事コード",null,"立替先コード","立替先名","名称/摘要",null,"金　　額",null,"伝票番号"]

{"sheet":"記入例 （請求明細あり）","index":5,"n_rows":43,"n_cols":35,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,32,4,34],[4,1,4,2],[4,3,4,5],[4,13,4,14],[4,15,4,17],[4,25,4,26],[4,27,4,29],[1,1,1,3],[1,13,1,15],[1,25,1,27],[3,1,3,2],[3,8,4,10],[3,13,3,14],[3,20,4,22],[3,25,3,26],[5,27,5,29],[5,31,6,31],[5,32,6,34],[5,1,5,2],[5,3,5,5],[5,7,6,7],[5,8,6,10],[5,13,5,14],[5,15,5,17],[7,1,8,2],[7,3,8,4],[7,13,8,14],[7,15,8,16],[7,20,7,22],[7,25,8,26],[5,19,6,19],[5,20,6,22],[5,25,5,26],[7,27,8,28],[7,32,7,34],[8,8,8,10],[8,20,8,22],[8,32,8,34],[10,3,10,4],[10,5,10,6],[10,15,10,16],[10,17,10,18],[10,27,10,28],[12,3,12,4],[12,5,12,6],[12,15,12,16],[12,17,12,18],[12,27,12,28],[12,29,12,30],[10,29,10,30],[11,3,11,4],[11,5,11,6],[11,15,11,16],[11,17,11,18],[11,27,11,28],[11,29,11,30],[14,3,14,4],[14,5,14,6],[14,15,14,16],[14,17,14,18],[14,27,14,28],[14,29,14,30],[13,3,13,4],[13,5,13,6],[13,15,13,16],[13,17,13,18],[13,27,13,28],[13,29,13,30],[16,3,16,4],[16,5,16,6],[16,15,16,16],[16,17,16,18],[16,27,16,28],[16,29,16,30],[15,3,15,4],[15,5,15,6],[15,15,15,16],[15,17,15,18],[15,27,15,28],[15,29,15,30],[18,3,18,4],[18,5,18,6],[18,15,18,16],[18,17,18,18],[18,27,18,28],[18,29,18,30],[17,3,17,4],[17,5,17,6],[17,15,17,16],[17,17,17,18],[17,27,17,28],[17,29,17,30],[20,3,20,4],[20,5,20,6],[20,15,20,16],[20,17,20,18],[20,27,20,28],[20,29,20,30],[19,3,19,4],[19,5,19,6],[19,15,19,16],[19,17,19,18],[19,27,19,28],[19,29,19,30],[22,3,22,4],[22,5,22,6],[22,15,22,16],[22,17,22,18],[22,27,22,28],[22,29,22,30],[21,3,21,4],[21,5,21,6],[21,15,21,16],[21,17,21,18],[21,27,21,28],[21,29,21,30],[24,3,24,4],[24,5,24,6],[24,15,24,16],[24,17,24,18],[24,27,24,28],[24,29,24,30],[23,3,23,4],[23,5,23,6],[23,15,23,16],[23,17,23,18],[23,27,23,28],[23,29,23,30],[26,3,26,4],[26,5,26,6],[26,15,26,16],[26,17,26,18],[26,27,26,28],[26,29,26,30],[25,3,25,4],[25,5,25,6],[25,15,25,16],[25,17,25,18],[25,27,25,28],[25,29,25,30],[28,3,28,4],[28,5,28,6],[28,15,28,16],[28,17,28,18],[28,27,28,28],[28,29,28,30],[27,3,27,4],[27,5,27,6],[27,15,27,16],[27,17,27,18],[27,27,27,28],[27,29,27,30],[29,20,30,21],[29,22,30,22],[29,25,29,26],[29,27,29,30],[29,32,30,33],[29,34,30,34],[29,1,29,2],[29,3,29,6],[29,8,30,9],[29,10,30,10],[29,13,29,14],[29,15,29,18],[35,1,35,2],[35,5,35,6],[35,13,35,14],[35,17,35,18],[35,25,35,26],[35,29,35,30],[32,8,32,9],[32,20,32,21],[32,32,32,33],[34,1,34,2],[34,5,34,6],[34,13,34,14],[34,17,34,18],[34,25,34,26],[34,29,34,30],[38,13,38,14],[38,17,38,18],[38,25,38,26],[38,29,38,30],[39,13,39,14],[39,17,39,18],[39,25,39,26],[39,29,39,30],[36,13,36,14],[36,17,36,18],[36,25,36,26],[36,29,36,30],[37,13,37,14],[37,17,37,18],[37,25,37,26],[37,29,37,30],[42,1,42,2],[42,5,42,6],[42,13,42,14],[42,17,42,18],[42,25,42,26],[42,29,42,30],[40,13,40,14],[40,17,40,18],[40,25,40,26],[40,29,40,30],[41,1,41,2],[41,5,41,6],[45,1,45,2],[45,5,45,6],[45,13,45,14],[45,17,45,18],[45,25,45,26],[45,29,45,30],[43,13,43,14],[43,17,43,18],[43,25,43,26],[43,29,43,30],[44,13,44,14],[44,17,44,18],[44,25,44,26],[44,29,44,30]]}
["（一般請求用）",null,null,null,null,null,null,null,null,null,null,null,"（一般請求用）",null,null,null,null,null,null,null,null,null,null,null,"（一般請求用）"]
[null,"成幸利根株式会社",null,null,"御中","請　求　書",null,null,null,null,null,null,null,"成幸利根株式会社",null,null,"御中","請　求　書",null,null,null,null,null,null,null,"成幸利根株式会社",null,null,"御中","請　求　書"]
[]
[null,"月度",null,"2016-07-01",null,null,null,"住所　","東京都○○区□□1-1",null,null,null,null,"月度",null,{"$f":"D4","v":"2016-07-01"},null,null,null,"住所　",{"$f":"I4","v":"東京都○○区□□1-1"},null,null,null,null,"月度",null,{"$f":"P4","v":"2016-07-01"},null,null,null,"住所　",{"$f":"U4","v":"東京都○○区□□1-1"}]
[null,"工事コード",null,"100001-0001",null,null,null,null,null,null,null,null,null,"工事コード",null,{"$f":"IF(D5=\"\",\"\",D5)","v":"100001-0001"},null,null,null,null,null,null,null,null,null,"工事コード",null,{"$f":"IF(P5=\"\",\"\",P5)","v":"100001-0001"}]
[null,"工事・工種名",null,"○○立坑SMW",null,null,null,"社名　","○○産業株式会社",null,null,null,null,"工事・工種名",null,{"$f":"IF(D6=\"\",\"\",D6)","v":"○○立坑SMW"},null,null,null,"社名　",{"$f":"I6","v":"○○産業株式会社"},null,null,null,null,"工事・工種名",null,{"$f":"IF(P6=\"\",\"\",P6)","v":"○○立坑SMW"},null,null,null,"社名　",{"$f":"U6","v":"○○産業株式会社"}]
[]
[null,"請求金額\n（税込）",null,{"$f":"K33","v":3726000},null,null,null,null,"□□支店",null,null,null,null,"請求金額\n（税込）",null,{"$f":"D8","v":3726000},null,null,null,null,{"$f":"IF(I8=\"\",\"\",I8)","v":"□□支店"},null,null,null,null,"請求金額\n（税込）",null,{"$f":"P8","v":3726000},null,null,null,null,{"$f":"IF(U8=\"\",\"\",U8)","v":"□□支店"}]
[null,null,null,null,null,null,null,"取引先コード　",1234567,null,null,null,null,null,null,null,null,null,null,"取引先コード　",{"$f":"I9","v":1234567},null,null,null,null,null,null,null,null,null,null,"取引先コード　",{"$f":"U9","v":1234567}]
[]
[null,null,"日付","内　　　訳",null,"摘　　　要",null,"数量","単位","単価","金　　額",null,null,null,"日付","内　　　訳",null,"摘　　　要",null,"数量","単位","単価","金　　額",null,null,null,"日付","内　　　訳",null,"摘　　　要",null,"数量","単位","単価","金　　額"]
[null,1,"2016-07-31","材料一式",null,null,null,1,"式",3450000,{"$f":"H12*J12","v":3450000},null,null,1,{"$f":"IF(C12=\"\",\"\",C12)","v":"2016-07-31"},"材料一式","","","",1,"式",3450000,3450000,null,null,1,{"$f":"IF(O12=\"\",\"\",O12)","v":"2016-07-31"},"材料一式","","","",1,"式",3450000,3450000]
[null,2,null,null,null,null,null,null,null,null,null,null,null,2,"","","","","","","","","",null,null,2,"","","","","","","","",""]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"","","","","","","","","",null,null,3,"","","","","","","","",""]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4,"","","","","","","","","",null,null,4,"","","","","","","","",""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5,"","","","","","","","","",null,null,5,"","","","","","","","",""]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6,"","","","","","","","","",null,null,6,"","","","","","","","",""]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7,"","","","","","","","","",null,null,7,"","","","","","","","",""]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8,"","","","","","","","","",null,null,8,"","","","","","","","",""]
[null,9,null,null,null,null,null,null,null,null,null,null,null,9,"","","","","","","","","",null,null,9,"","","","","","","","",""]
[null,10,null,null,null,null,null,null,null,null,null,null,null,10,"","","","","","","","","",null,null,10,"","","","","","","","",""]
[null,11,null,null,null,null,null,null,null,null,null,null,null,11,"","","","","","","","","",null,null,11,"","","","","","","","",""]
[null,12,null,null,null,null,null,null,null,null,null,null,null,12,"","","","","","","","","",null,null,12,"","","","","","","","",""]
[null,13,null,null,null,null,null,null,null,null,null,null,null,13,"","","","","","","","","",null,null,13,"","","","","","","","",""]
[null,14,null,null,null,null,null,null,null,null,null,null,null,14,"","","","","","","","","",null,null,14,"","","","","","","","",""]
[null,15,null,null,null,null,null,null,null,null,null,null,null,15,"","","","","","","","","",null,null,15,"","","","","","","","",""]
[null,16,null,null,null,null,null,null,null,null,null,null,null,16,"","","","","","","","","",null,null,16,"","","","","","","","",""]
[null,17,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(C28=\"\",\"\",C28)","v":""},"","","","","","","","",null,null,17,"","","","","","","","",""]
[null,18,null,null,null,null,null,null,null,null,null,null,null,18,"","","","","","","","","",null,null,18,"","","","","","","","",""]
[null,"決　裁",null,"査定・承認",null,null,null,"受　付","請求金額　(税抜)",null,{"$f":"SUM(K12:K29)-SUMIF(D12:E29,\"（　小　　　計　）\",K12:K29)","v":3450000},null,null,"決　裁",null,"査定・承認",null,null,null,"受　付","請求金額　(税抜)",null,3450000,null,null,"決　裁",null,"査定・承認",null,null,null,"受　付","請求金額　(税抜)",null,{"$f":"IF(W30=\"\",\"\",W30)","v":3450000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"消費税",0.08,{"$f":"K30*J32","v":276000},null,null,null,null,null,null,null,null,null,"消費税",0.08,276000,null,null,null,null,null,null,null,null,null,"消費税",{"$f":"IF(V32=\"\",\"\",V32)","v":0.08},276000]
[null,null,null,null,null,null,null,null,"請求金額　(税込)",null,{"$f":"SUM(K30:K32)","v":3726000},null,null,null,null,null,null,null,null,null,"請求金額　(税込)",null,3726000,null,null,null,null,null,null,null,null,null,"請求金額　(税込)",null,3726000]
[null,null,null,null,null,null,null,null,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,"3.　請求書、請求明細は支店用と本社用の2部を提出してください。"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"工事コード",null,"立替先コード","立替先名","名称/摘要",null,"金　　額",null,"伝票番号"]

{"sheet":"記入例（請求明細）","index":6,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,2,3,3],[4,2,4,3],[4,4,4,6],[4,9,4,11],[5,2,5,3],[5,4,5,6],[5,9,5,11],[7,4,7,5],[7,6,7,7],[8,4,8,5],[8,6,8,7],[9,4,9,5],[9,6,9,7],[10,4,10,5],[10,6,10,7],[11,4,11,5],[11,6,11,7],[12,4,12,5],[12,6,12,7],[13,4,13,5],[13,6,13,7],[14,4,14,5],[14,6,14,7],[15,4,15,5],[15,6,15,7],[16,4,16,5],[16,6,16,7],[17,4,17,5],[17,6,17,7],[18,4,18,5],[18,6,18,7],[26,6,26,7],[32,4,32,5],[19,4,19,5],[19,6,19,7],[20,4,20,5],[20,6,20,7],[21,4,21,5],[21,6,21,7],[32,6,32,7],[35,4,35,5],[35,6,35,7],[36,8,36,10],[23,4,23,5],[23,6,23,7],[24,4,24,5],[24,6,24,7],[25,4,25,5],[29,4,29,5],[29,6,29,7],[30,4,30,5],[30,6,30,7],[31,4,31,5],[31,6,31,7],[25,6,25,7],[26,4,26,5]]}
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"\"( \"&A1&\" / \"&$L$41&\" )\"","v":"( 1 / 1 )"}]
[null,null,"（　請　求　明　細　）"]
[]
[null,null,"月度",null,{"$f":"'記入例 （請求明細あり）'!D4","v":"2016-07-01"}]
[null,null,"工事コード",null,{"$f":"'記入例 （請求明細あり）'!D5","v":"100001-0001"},null,null,null,"社名",{"$f":"SUBSTITUTE(SUBSTITUTE('記入例 （請求明細あり）'!I6&\" \"&'記入例 （請求明細あり）'!I8,\"株式会社\",\"㈱\"),\"有限会社\",\"㈲\")","v":"○○産業㈱ □□支店"}]
[null,null,"工事・工種名",null,{"$f":"'記入例 （請求明細あり）'!D6","v":"○○立坑SMW"},null,null,null,"取引先コード",{"$f":"'記入例 （請求明細あり）'!I9","v":1234567}]
[]
[null,null,null,"日付","内　　　訳",null,"摘　　　要",null,"数　量","単位","単　価","金　　額"]
[1,null,1,"2016-07-01","材料A",null,null,null,100,"kg",3000,{"$f":"I9*K9","v":300000}]
[1,null,2,null,"材料B",null,null,null,200,"kg",2000,{"$f":"I10*K10","v":400000}]
[1,null,3,null,"送料",null,null,null,1,"式",10000,{"$f":"I11*K11","v":10000}]
[1,null,4,null,"（　小　　　計　）",null,null,null,null,null,null,{"$f":"SUM(L9:L11)","v":710000}]
[1,null,5]
[1,null,6,"2016-07-10","材料A",null,null,null,150,"kg",3000,{"$f":"I14*K14","v":450000}]
[1,null,7,null,"材料B",null,null,null,100,"kg",2000,{"$f":"I15*K15","v":200000}]
[1,null,8,null,"送料",null,null,null,1,"式",10000,{"$f":"I16*K16","v":10000}]
[1,null,9,null,"（　小　　　計　）",null,null,null,null,null,null,{"$f":"SUM(L14:L16)","v":660000}]
[1,null,10]
[1,null,11,"2016-07-20","材料C",null,"φ20×1000mm",null,100,"本",8000,{"$f":"I19*K19","v":800000}]
[1,null,12,null,"材料D",null,"300×200×1000",null,20,"個",15000,{"$f":"I20*K20","v":300000}]
[1,null,13,null,"送料",null,null,null,1,"式",10000,{"$f":"I21*K21","v":10000}]
[1,null,14,null,"（　小　　　計　）",null,null,null,null,null,null,{"$f":"SUM(L19:L21)","v":1110000}]
[1,null,15]
[1,null,16,"2016-07-30","材料A",null,null,null,200,"kg",3000,{"$f":"I24*K24","v":600000}]
[1,null,17,null,"材料B",null,null,null,180,"kg",2000,{"$f":"I25*K25","v":360000}]
[1,null,18,null,"送料",null,null,null,1,"式",10000,{"$f":"I26*K26","v":10000}]
[1,null,19,null,"（　小　　　計　）",null,null,null,null,null,null,{"$f":"SUM(L24:L26)","v":970000}]
[1,null,20]
[1,null,21]
[1,null,22]
[1,null,23]
[1,null,24]
[1,null,25]
[1,null,26]
[1,null,27]
[1,null,28]
[null,null,null,null,null,null,null,null,"ページ　計",null,null,{"$f":"SUM(L9:L36)-SUMIF(E9:F36,\"（　小　　　計　）\",L9:L36)","v":3450000}]
[]
[]
[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":11,"n_cols":290,"rows_kept":11,"cut":false,"hidden":true,"merged":[[8,0,13,0],[8,1,13,1],[8,2,13,2],[11,5,11,289],[12,5,12,289],[1,3,1,291],[2,1,7,1],[2,2,7,2],[2,0,7,0],[5,5,5,289],[6,5,6,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.","名称","コード","バーコードイメージ"]
[null,null,{"$f":"IF(AND('請求書 (表紙)'!$AG$9=\"\",'請求書 (表紙)'!$AB$8=\"\"),\"\",'請求書 (表紙)'!$AG$9&\"-\"&'請求書 (表紙)'!$AB$8)","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":""},"","","","","","","","","","",""]
[]
[]
[]
[null,"記入例",{"$f":"'記入例（請求明細なし）'!AG9&\"-\"&'記入例（請求明細なし）'!AB8","v":"5029800-2678400"}]
[]
[null,null,null,null,null,{"$f":"IF($C9=\"\",\"\",Start39)","v":1},0,0,1,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C9,1,1)=\"\",\"\",INDEX(Area39,MATCH(MID($C9,1,1),Char39,0),0))","v":1},1,0,1,0,0,1,1,0,1,0,1,null,{"$f":"IF(MID($C9,2,1)=\"\",IF(LEN($C9)=1,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,2,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C9,3,1)=\"\",IF(LEN($C9)=2,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,3,1),Char39,0),0))","v":1},0,1,1,0,0,1,0,1,0,1,1,null,{"$f":"IF(MID($C9,4,1)=\"\",IF(LEN($C9)=3,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,4,1),Char39,0),0))","v":1},0,1,1,0,0,1,0,1,1,0,1,null,{"$f":"IF(MID($C9,5,1)=\"\",IF(LEN($C9)=4,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,5,1),Char39,0),0))","v":1},1,0,1,0,0,1,0,1,1,0,1,null,{"$f":"IF(MID($C9,6,1)=\"\",IF(LEN($C9)=5,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,6,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C9,7,1)=\"\",IF(LEN($C9)=6,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,7,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C9,8,1)=\"\",IF(LEN($C9)=7,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,8,1),Char39,0),0))","v":1},0,0,1,0,1,0,1,1,0,1,1,null,{"$f":"IF(MID($C9,9,1)=\"\",IF(LEN($C9)=8,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,9,1),Char39,0),0))","v":1},0,1,1,0,0,1,0,1,0,1,1,null,{"$f":"IF(MID($C9,10,1)=\"\",IF(LEN($C9)=9,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,10,1),Char39,0),0))","v":1},0,1,1,0,0,1,1,0,1,0,1,null,{"$f":"IF(MID($C9,11,1)=\"\",IF(LEN($C9)=10,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,11,1),Char39,0),0))","v":1},0,1,0,0,1,0,1,1,0,1,1,null,{"$f":"IF(MID($C9,12,1)=\"\",IF(LEN($C9)=11,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,12,1),Char39,0),0))","v":1},1,0,1,0,0,1,0,1,1,0,1,null,{"$f":"IF(MID($C9,13,1)=\"\",IF(LEN($C9)=12,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,13,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,0,1,1,null,{"$f":"IF(MID($C9,14,1)=\"\",IF(LEN($C9)=13,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,14,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C9,15,1)=\"\",IF(LEN($C9)=14,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,15,1),Char39,0),0))","v":1},0,1,0,0,1,1,0,1,1,0,1,null,{"$f":"IF(MID($C9,16,1)=\"\",IF(LEN($C9)=15,Start39,\"\"),INDEX(Area39,MATCH(MID($C9,16,1),Char39,0),0))","v":1},0,0,1,0,1,1,0,1,1,0,1,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":""},"","","","","","","","","","",""]

{"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"]