{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["設定画面","記入例_設定画面","台帳","記入例_台帳","見積書","納品書","請求書","領収書"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,4,7,4]]}
["基本情報",null,null,null,"印刷設定"]
["社名",null,null,null,"表示番号"]
["郵便番号",null,null,null,"印刷開始番号"]
["住所１",null,null,null,"印刷終了番号"]
["住所2",null,null,null,"印刷帳票",null,false]
["電話番号",null,null,null,null,null,false]
["Fax/E-Mail/URLなど",null,null,null,null,null,false]
["振込先１",null,null,null,null,null,false]
["振込先２"]

{"sheet":"記入例_設定画面","index":1,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,4,7,4],[4,7,7,7]]}
["基本情報",null,null,null,"印刷設定"]
["社名","クラフト工房　IZUMI",null,null,"表示番号",10,null,"←帳票に表示させたいレコード番号（台帳シートのA列）を入力します"]
["郵便番号","〒xxx-xxxx",null,null,"印刷開始番号",3,null,"←印刷開始レコード（台帳シートのA列）を入力します"]
["住所１","○○県○○市〇〇1-2-3",null,null,"印刷終了番号",10,null,"←印刷終了レコード（台帳シートのA列）を入力します"]
["住所2","〇〇第1ビル2階",null,null,"印刷帳票",null,true,"←印刷したい帳票にチェックを入れます"]
["電話番号","TEL：",null,null,null,null,true]
["Fax/E-Mail/URLなど","FAX：",null,null,null,null,true]
["振込先１","〇〇銀行　○○支店　普通　xxxxxxx",null,null,null,null,true]
["振込先２","ｲｽﾞﾐ ﾀﾛｳ"]
[null,"↑",null,null,null,null,null,"←印刷プレビューしたい時に使用。Escキーで次のプレビューが見れます"]
[null,"ここに貴社の情報を入力します。",null,null,null,null,null,"　１レコード毎に「続行しますか」と聞いてくるのでY/Nで選択します"]
[null,"入力した情報が見積書、納品書、請求書、"]
[null,"領収書へ反映されます。",null,null,null,null,null,"←印刷開始レコードから印刷終了レコードまで、チェックを入れた"]
[null,null,null,null,null,null,null,"　帳票が印刷されます"]
[]
[null,null,null,null,null,null,null,"←印刷開始レコードから印刷終了レコードまで、チェックを入れた"]
[null,null,null,null,null,null,null,"　帳票がデスクトップにPDF出力されます"]
[]
[]
[null,null,null,null,null,null,null,"　"]

{"sheet":"台帳","index":2,"n_rows":101,"n_cols":68,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["No.","取引No.","見積日","納品日","請求日","領収日","顧客名","件名","納期","摘要1","数量1","単位1","単価1","摘要2","数量2","単位2","単価2","摘要3","数量3","単位3","単価3","摘要4","数量4","単位4","単価4","摘要5","数量5","単位5","単価5","摘要6","数量6","単位6","単価6","摘要7","数量7","単位7","単価7","摘要8","数量8","単位8","単価8","摘要9","数量9","単位9","単価9","摘要10","数量10","単位10","単価10","摘要11","数量11","単位11","単価11","摘要12","数量12","単位12","単価12","摘要13","数量13","単位13","単価13","摘要14","数量14","単位14","単価14","備考_見積書","備考_納品書","備考_請求書"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"記入例_台帳","index":3,"n_rows":101,"n_cols":68,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["No.","取引No.","見積日","納品日","請求日","領収日","顧客名","件名","納期","摘要1","数量1","単位1","単価1","摘要2","数量2","単位2","単価2","摘要3","数量3","単位3","単価3","摘要4","数量4","単位4","単価4","摘要5","数量5","単位5","単価5","摘要6","数量6","単位6","単価6","摘要7","数量7","単位7","単価7","摘要8","数量8","単位8","単価8","摘要9","数量9","単位9","単価9","摘要10","数量10","単位10","単価10","摘要11","数量11","単位11","単価11","摘要12","数量12","単位12","単価12","摘要13","数量13","単位13","単価13","摘要14","数量14","単位14","単価14","備考_見積書","備考_納品書","備考_請求書"]
[1,2024001,"2024-01-01","2024-01-10","2024-01-20","2023-01-30","サンプル１株式会社","Excel表作成１","2023-01-20","関数作成１",1,"式",1000,"グラフ作成１",1,"式",1000,"テーブル作成１",1,"式",1000,"シート作成１",1,"式",1000,"マクロ作成１",1,"式",1000,"デバッグ１",1,"式",1000,"動作確認１",1,"式",1000,"データベース作成１",1,"式",1000,"取扱説明書作成１",1,"式",1000,"3年間保証１",1,"式",1000,"らくらく立上げパック１",1,"式",1000,"メンテナンスパック１",1,"式",1000,"出張費１",1,"式",1000,"燃料費１",1,"式",1000,"この見積書はダミーです","この納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーです","この請求書はダミーです"]
[2,2024002,"2024-02-01","2024-02-10","2024-02-20","2023/2/30","サンプル２株式会社","Excel表作成２","2023-02-20","関数作成２",2,"式",2000,"グラフ作成２",2,"式",2000,"テーブル作成２",2,"式",2000,"シート作成２",2,"式",2000,"マクロ作成２",2,"式",2000,"デバッグ２",2,"式",2000,"動作確認２",2,"式",2000,"データベース作成２",2,"式",2000,"取扱説明書作成２",2,"式",2000,"3年間保証２",2,"式",2000,"らくらく立上げパック２",2,"式",2000,"メンテナンスパック２",2,"式",2000,"出張費２",2,"式",2000,"燃料費２",2,"式",2000,"この見積書はダミーです","この納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーです","この請求書はダミーです"]
[3,2024003,"2024-03-01","2024-03-10","2024-03-20","2023-03-30","サンプル３株式会社","Excel表作成３","2023-03-20","関数作成３",3,"式",3000,"グラフ作成３",3,"式",3000,"テーブル作成３",3,"式",3000,"シート作成３",3,"式",3000,"マクロ作成３",3,"式",3000,"デバッグ３",3,"式",3000,"動作確認３",3,"式",3000,"データベース作成３",3,"式",3000,"取扱説明書作成３",3,"式",3000,"3年間保証３",3,"式",3000,"らくらく立上げパック３",3,"式",3000,"メンテナンスパック３",3,"式",3000,"出張費３",3,"式",3000,"燃料費３",3,"式",3000,"この見積書はダミーです","この納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーです","この請求書はダミーです"]
[4,2024004,"2024-04-01","2024-04-10","2024-04-20","2023-04-30","サンプル４株式会社","Excel表作成４","2023-04-20","関数作成４",4,"式",4000,"グラフ作成４",4,"式",4000,"テーブル作成４",4,"式",4000,"シート作成４",4,"式",4000,"マクロ作成４",4,"式",4000,"デバッグ４",4,"式",4000,"動作確認４",4,"式",4000,"データベース作成４",4,"式",4000,"取扱説明書作成４",4,"式",4000,"3年間保証４",4,"式",4000,"らくらく立上げパック４",4,"式",4000,"メンテナンスパック４",4,"式",4000,"出張費４",4,"式",4000,"燃料費４",4,"式",4000,"この見積書はダミーです","この納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーです","この請求書はダミーです"]
[5,2024005,"2024-05-01","2024-05-10","2024-05-20","2023-05-30","サンプル５株式会社","Excel表作成５","2023-05-20","関数作成５",5,"式",5000,"グラフ作成５",5,"式",5000,"テーブル作成５",5,"式",5000,"シート作成５",5,"式",5000,"マクロ作成５",5,"式",5000,"デバッグ５",5,"式",5000,"動作確認５",5,"式",5000,"データベース作成５",5,"式",5000,"取扱説明書作成５",5,"式",5000,"3年間保証５",5,"式",5000,"らくらく立上げパック５",5,"式",5000,"メンテナンスパック５",5,"式",5000,"出張費５",5,"式",5000,"燃料費５",5,"式",5000,"この見積書はダミーです","この納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーです","この請求書はダミーです"]
[6,2024006,"2024-06-01","2024-06-10","2024-06-20","2023-06-30","サンプル６株式会社","Excel表作成６","2023-06-20","関数作成６",6,"式",6000,"グラフ作成６",6,"式",6000,"テーブル作成６",6,"式",6000,"シート作成６",6,"式",6000,"マクロ作成６",6,"式",6000,"デバッグ６",6,"式",6000,"動作確認６",6,"式",6000,"データベース作成６",6,"式",6000,"取扱説明書作成６",6,"式",6000,"3年間保証６",6,"式",6000,"らくらく立上げパック６",6,"式",6000,"メンテナンスパック６",6,"式",6000,"出張費６",6,"式",6000,"燃料費６",6,"式",6000,"この見積書はダミーです","この納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーです","この請求書はダミーです"]
[7,2024007,"2024-07-01","2024-07-10","2024-07-20","2023-07-30","サンプル７株式会社","Excel表作成７","2023-07-20","関数作成７",7,"式",7000,"グラフ作成７",7,"式",7000,"テーブル作成７",7,"式",7000,"シート作成７",7,"式",7000,"マクロ作成７",7,"式",7000,"デバッグ７",7,"式",7000,"動作確認７",7,"式",7000,"データベース作成７",7,"式",7000,"取扱説明書作成７",7,"式",7000,"3年間保証７",7,"式",7000,"らくらく立上げパック７",7,"式",7000,"メンテナンスパック７",7,"式",7000,"出張費７",7,"式",7000,"燃料費７",7,"式",7000,"この見積書はダミーです","この納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーです","この請求書はダミーです"]
[8,2024008,"2024-08-01","2024-08-10","2024-08-20","2023-08-30","サンプル８株式会社","Excel表作成８","2023-08-20","関数作成８",8,"式",8000,"グラフ作成８",8,"式",8000,"テーブル作成８",8,"式",8000,"シート作成８",8,"式",8000,"マクロ作成８",8,"式",8000,"デバッグ８",8,"式",8000,"動作確認８",8,"式",8000,"データベース作成８",8,"式",8000,"取扱説明書作成８",8,"式",8000,"3年間保証８",8,"式",8000,"らくらく立上げパック８",8,"式",8000,"メンテナンスパック８",8,"式",8000,"出張費８",8,"式",8000,"燃料費８",8,"式",8000,"この見積書はダミーです","この納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーです","この請求書はダミーです"]
[9,2024009,"2024-09-01","2024-09-10","2024-09-20","2023-09-30","サンプル９株式会社","Excel表作成９","2023-09-20","関数作成９",9,"式",9000,"グラフ作成９",9,"式",9000,"テーブル作成９",9,"式",9000,"シート作成９",9,"式",9000,"マクロ作成９",9,"式",9000,"デバッグ９",9,"式",9000,"動作確認９",9,"式",9000,"データベース作成９",9,"式",9000,"取扱説明書作成９",9,"式",9000,"3年間保証９",9,"式",9000,"らくらく立上げパック９",9,"式",9000,"メンテナンスパック９",9,"式",9000,"出張費９",9,"式",9000,"燃料費９",9,"式",9000,"この見積書はダミーです","この納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーです","この請求書はダミーです"]
[10,2024010,"2024-10-01","2024-10-10","2024-10-20","2023-10-30","サンプル１０株式会社","Excel表作成１０","2023-10-20","関数作成１０",10,"式",10000,"グラフ作成１０",10,"式",10000,"テーブル作成１０",10,"式",10000,"シート作成１０",10,"式",10000,"マクロ作成１０",10,"式",10000,"デバッグ１０",10,"式",10000,"動作確認１０",10,"式",10000,"データベース作成１０",10,"式",10000,"取扱説明書作成１０",10,"式",10000,"3年間保証１０",10,"式",10000,"らくらく立上げパック１０",10,"式",10000,"メンテナンスパック１０",10,"式",10000,"出張費１０",10,"式",10000,"燃料費１０",10,"式",10000,"この見積書はダミーです","この納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーですこの納品書はダミーです","この請求書はダミーです"]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"見積書","index":4,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,39,6],[16,0,16,2],[15,0,15,2],[14,0,14,2],[22,0,22,2],[21,0,21,2],[20,0,20,2],[19,0,19,2],[18,0,18,2],[17,0,17,2],[23,0,23,2],[32,0,32,6],[27,0,27,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[0,0,0,6],[1,0,2,3],[10,0,11,0],[10,1,11,3],[13,0,13,2]]}
["見　積　書",null,null,null,null,null,null,{"$f":"IF(設定画面!F2=\"\",\"\",設定画面!F2)","v":""}]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,7,0),\"\")&\"　御中\"","v":"　御中"},null,null,null,null,"No",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,2,0),\"\")","v":""}]
[null,null,null,null,null,"見積日",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,3,0),\"\")","v":""}]
[]
["下記のとおり、御見積もり申し上げます。",null,null,null,null,{"$f":"IF(設定画面!B2=\"\",\"\",設定画面!B2)","v":""}]
["件名",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,8,0),\"\")","v":""},null,null,null,{"$f":"IF(設定画面!B3=\"\",\"\",設定画面!B3)","v":""}]
["納期",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,9,0),\"\")","v":""},null,null,null,{"$f":"IF(設定画面!B4=\"\",\"\",設定画面!B4)","v":""}]
["支払条件","月末締翌月末払",null,null,null,{"$f":"IF(設定画面!B5=\"\",\"\",設定画面!B5)","v":""}]
["有効期限","御見積後2週間",null,null,null,{"$f":"IF(設定画面!B6=\"\",\"\",設定画面!B6)","v":""}]
[null,null,null,null,null,{"$f":"IF(設定画面!B7=\"\",\"\",設定画面!B7)","v":""}]
["合計",{"$f":"G31","v":0}]
[]
[]
["摘要",null,null,"数量","単位","単価","金額"]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:J,10,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:K,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:L,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:M,13,0),\"\")","v":""},{"$f":"IF(AND(D15<>\"\", F15<>\"\"),D15*F15,\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:N,14,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:O,15,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:P,16,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:Q,17,0),\"\")","v":""},{"$f":"IF(AND(D16<>\"\", F16<>\"\"),D16*F16,\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:R,18,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:S,19,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:T,20,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:U,21,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:V,22,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:W,23,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:X,24,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:Y,25,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:Z,26,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AA,27,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AB,28,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AC,29,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AD,30,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AE,31,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AF,32,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AG,33,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AH,34,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AI,35,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AJ,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AK,37,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AL,38,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AM,39,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AN,40,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AO,41,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AP,42,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AQ,43,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AR,44,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AS,45,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AT,46,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AU,47,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AV,48,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AW,49,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AX,50,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AY,51,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AZ,52,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BA,53,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BB,54,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BC,55,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BD,56,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BE,57,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BF,58,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BG,59,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BH,60,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BI,61,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BJ,62,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BK,63,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BL,64,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,65,0),\"\")","v":""},""]
[null,null,null,null,null,"小計",{"$f":"SUM(G15:G28)","v":0}]
[null,null,null,null,null,"消費税",{"$f":"G29*0.1","v":0}]
[null,null,null,null,null,"合計",{"$f":"G29+G30","v":0}]
[]
["備考"]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BN,66,0),\"\")","v":""}]

{"sheet":"納品書","index":5,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,39,6],[27,0,27,2],[32,0,32,6],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[20,0,20,2],[0,0,0,6],[1,0,2,3],[10,0,11,0],[10,1,11,3],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2]]}
["納　品　書",null,null,null,null,null,null,{"$f":"IF(設定画面!F2=\"\",\"\",設定画面!F2)","v":""}]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,7,0),\"\")&\"　御中\"","v":"　御中"},null,null,null,null,"No",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,2,0),\"\")","v":""}]
[null,null,null,null,null,"納品日",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,4,0),\"\")","v":""}]
[]
["下記のとおり、納品致します。",null,null,null,null,{"$f":"IF(設定画面!B2=\"\",\"\",設定画面!B2)","v":""}]
["件名",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,8,0),\"\")","v":""},null,null,null,{"$f":"IF(設定画面!B3=\"\",\"\",設定画面!B3)","v":""}]
["納期",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,9,0),\"\")","v":""},null,null,null,{"$f":"IF(設定画面!B4=\"\",\"\",設定画面!B4)","v":""}]
["納品場所",null,null,null,null,{"$f":"IF(設定画面!B5=\"\",\"\",設定画面!B5)","v":""}]
["支払条件","月末締翌月末払",null,null,null,{"$f":"IF(設定画面!B6=\"\",\"\",設定画面!B6)","v":""}]
[null,null,null,null,null,{"$f":"IF(設定画面!B7=\"\",\"\",設定画面!B7)","v":""}]
["合計",{"$f":"G31","v":0}]
[]
[]
["摘要",null,null,"数量","単位","単価","金額"]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:J,10,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:K,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:L,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:M,13,0),\"\")","v":""},{"$f":"IF(AND(D15<>\"\", F15<>\"\"),D15*F15,\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:N,14,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:O,15,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:P,16,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:Q,17,0),\"\")","v":""},{"$f":"IF(AND(D16<>\"\", F16<>\"\"),D16*F16,\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:R,18,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:S,19,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:T,20,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:U,21,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:V,22,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:W,23,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:X,24,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:Y,25,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:Z,26,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AA,27,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AB,28,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AC,29,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AD,30,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AE,31,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AF,32,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AG,33,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AH,34,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AI,35,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AJ,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AK,37,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AL,38,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AM,39,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AN,40,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AO,41,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AP,42,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AQ,43,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AR,44,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AS,45,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AT,46,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AU,47,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AV,48,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AW,49,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AX,50,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AY,51,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AZ,52,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BA,53,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BB,54,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BC,55,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BD,56,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BE,57,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BF,58,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BG,59,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BH,60,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BI,61,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BJ,62,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BK,63,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BL,64,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,65,0),\"\")","v":""},""]
[null,null,null,null,null,"小計",{"$f":"SUM(G15:G28)","v":0}]
[null,null,null,null,null,"消費税",{"$f":"G29*0.1","v":0}]
[null,null,null,null,null,"合計",{"$f":"G29+G30","v":0}]
[]
["備考"]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BO,67,0),\"\")","v":""}]

{"sheet":"請求書","index":6,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,39,6],[20,0,20,2],[0,0,0,6],[1,0,2,3],[10,0,11,0],[10,1,11,3],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[27,0,27,2],[32,0,32,6],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2]]}
["請　求　書",null,null,null,null,null,null,{"$f":"IF(設定画面!F2=\"\",\"\",設定画面!F2)","v":""}]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,7,0),\"\")&\"　御中\"","v":"　御中"},null,null,null,null,"No",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,2,0),\"\")","v":""}]
[null,null,null,null,null,"請求日",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,5),\"\")","v":""}]
[]
["下記のとおり、御請求申し上げます。",null,null,null,null,{"$f":"IF(設定画面!B2=\"\",\"\",設定画面!B2)","v":""}]
["件名",{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BN,8,0),\"\")","v":""},null,null,null,{"$f":"IF(設定画面!B3=\"\",\"\",設定画面!B3)","v":""}]
["支払期限",{"$f":"IFERROR(EOMONTH(G3,1),\"\")","v":""},null,null,null,{"$f":"IF(設定画面!B4=\"\",\"\",設定画面!B4)","v":""}]
["振込先",{"$f":"IF(設定画面!B8=\"\",\"\",設定画面!B8)","v":""},null,null,null,{"$f":"IF(設定画面!B5=\"\",\"\",設定画面!B5)","v":""}]
[null,{"$f":"IF(設定画面!B9=\"\",\"\",設定画面!B9)","v":""},null,null,null,{"$f":"IF(設定画面!B6=\"\",\"\",設定画面!B6)","v":""}]
[null,null,null,null,null,{"$f":"IF(設定画面!B7=\"\",\"\",設定画面!B7)","v":""}]
["合計",{"$f":"G31","v":0}]
[]
[]
["摘要",null,null,"数量","単位","単価","金額"]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:J,10,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:K,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:L,12,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:M,13,0),\"\")","v":""},{"$f":"IF(AND(D15<>\"\", F15<>\"\"),D15*F15,\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:N,14,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:O,15,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:P,16,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:Q,17,0),\"\")","v":""},{"$f":"IF(AND(D16<>\"\", F16<>\"\"),D16*F16,\"\")","v":""}]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:R,18,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:S,19,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:T,20,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:U,21,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:V,22,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:W,23,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:X,24,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:Y,25,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:Z,26,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AA,27,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AB,28,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AC,29,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AD,30,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AE,31,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AF,32,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AG,33,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AH,34,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AI,35,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AJ,36,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AK,37,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AL,38,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AM,39,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AN,40,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AO,41,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AP,42,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AQ,43,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AR,44,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AS,45,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AT,46,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AU,47,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AV,48,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AW,49,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AX,50,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AY,51,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:AZ,52,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BA,53,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BB,54,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BC,55,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BD,56,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BE,57,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BF,58,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BG,59,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BH,60,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BI,61,0),\"\")","v":""},""]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BJ,62,0),\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BK,63,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BL,64,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BM,65,0),\"\")","v":""},""]
[null,null,null,null,null,"小計",{"$f":"SUM(G15:G28)","v":0}]
[null,null,null,null,null,"消費税",{"$f":"G29*0.1","v":0}]
[null,null,null,null,null,"合計",{"$f":"G29+G30","v":0}]
[]
["備考"]
[{"$f":"IFERROR(VLOOKUP(H1,台帳!A:BP,68,0),\"\")","v":""}]

{"sheet":"領収書","index":7,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,11,5,13],[5,2,5,4],[5,5,5,10],[11,5,11,7],[12,5,12,7],[9,5,9,9],[2,12,2,14],[3,12,3,14],[0,0,0,16],[2,0,2,6],[2,7,2,8],[13,5,13,9],[14,5,14,9],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[10,5,10,9],[16,10,16,11],[16,12,16,16],[15,10,15,11],[15,12,15,16],[15,0,15,1]]}
["領　収　書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(設定画面!F2=\"\",\"\",設定画面!F2)","v":""}]
[]
[{"$f":"IFERROR(VLOOKUP(R1,台帳!A:BM,7,0),\"\")&\"　御中\"","v":"　御中"},null,null,null,null,null,null,null,null,null,null,"No.",{"$f":"IFERROR(VLOOKUP(R1,台帳!A:BM,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O2,台帳!H:BT,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P2,台帳!I:BU,2,0),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"発行日",{"$f":"IFERROR(VLOOKUP(R1,台帳!A:BN,6,0),\"\")","v":""}]
[]
[null,null,"合計",null,null,{"$f":"請求書!B11","v":0}]
[null,null,null,"但"]
[null,null,null,"上記正に領収いたしました。"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(設定画面!B2=\"\",\"\",設定画面!B2)","v":""}]
[null,null,null,"内　　訳",null,null,null,null,null,null,null,{"$f":"IF(設定画面!B3=\"\",\"\",設定画面!B3)","v":""}]
[null,null,null,"税抜金額",null,{"$f":"請求書!G29","v":0},null,null,null,null,null,{"$f":"IF(設定画面!B4=\"\",\"\",設定画面!B4)","v":""}]
[null,null,null,"消費税等",null,{"$f":"請求書!G30","v":0},null,null,null,null,null,{"$f":"IF(設定画面!B5=\"\",\"\",設定画面!B5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(設定画面!B6=\"\",\"\",設定画面!B6)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(設定画面!B7=\"\",\"\",設定画面!B7)","v":""}]