{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["ごあいさつ","使い方","固定パラメタシート","パラメタシート","見積書","注文書（代理発行）","注文請書","納品書","請求書","領収書"],"not_rendered":{"defined_names":45,"comments":6},"read":"whole","date_system":"1900"}

{"sheet":"ごあいさつ","index":0,"n_rows":37,"n_cols":12,"rows_kept":37}
[]
[null,"見積書～領収書.xltx　について",{"$nulls":9},"2023/7/27版"]
[]
[null,"　このExcel表は、最初に固定値（自社名、屋号など）を入力しておき、それを元に見積表を作成すると、後は"]
[null,"ほぼ自動的に、発注書、納品書、請求書、領収書が発行できるというものです。"]
[]
[null,"ごあいさつ"]
[null,null,"私は事務作業のミスがめちゃくちゃ多いヒトです。"]
[null,null,"事務作業のミスはお客様に迷惑をかけますので、ミスを減らすためのExcel表がずっと欲しかったのです。"]
[]
[null,null,"ところが、世の皆さんは私のようにミスをしないせいか、そういった目的のフォーマットがありません。"]
[null,null,"なので、自分にとって便利でミスをせずにすむExcel表を作りました。"]
[]
[null,null,"皆さんの見積書、注文書、請求書、領収書といった書面発行業務の工数削減になるとすごく嬉しいです。"]
[]
[null,"使い方"]
[null,null,"このExcel表では、見積書・注文書（代理発行）・注文請書・納品書・請求書・受領書の６つの書式が"]
[null,null,"作成できます。基本的にはパラメタシート（と見積書の明細）を埋めれば後の書類はほぼ自動的に"]
[null,null,"作ってくれます。"]
[null,null,"詳しくは「使い方」のシートをご参照ください。"]
[]
[null,"動作確認済環境"]
[null,null,"2023年5月時点のOffice365（Microsoft365）で動作確認済です。"]
[null,null,"この表では、セル書式のカスタム形式、名前定義、条件付き書式といった機能を利用しています。"]
[null,null,"が、それ以外は大した機能は使っていません。マクロも使っていません。"]
[]
[null,"著作権など"]
[null,null,"本表の著作権は筆者（t.shimizu@egao-it.com）が保有しています。"]
[null,null,"本表はどなたでも（商用でも）無償でご利用いただけます。"]
[null,null,"また、カスタマイズにも制限はありません。"]
[null,null,"ただし、カスタマイズされたバージョンについては筆者と同様の条件で再配布をお願いします。"]
[null,null,"　１）原著作者がt.shimizu@egao-it.comであることを明記すること。"]
[null,null,"　２）あなたの改変版を第三者が改変することを筆者と同様に許可すること。"]
[null,null,"　３）その改変版の再配布についても筆者と同様に許可すること。"]
[null,null,"その他の再配布条件はGPLv2に従うものとします。"]
[null,null,"　公式版（英語）",null,null,"https://www.gnu.org/licenses/old-licenses/gpl-2.0.html"]
[null,null,"　非公式版（日本語）",null,null,"https://licenses.opensource.jp/GPL-2.0/gpl/gpl.ja.html"]

{"sheet":"使い方","index":1,"n_rows":75,"n_cols":3,"rows_kept":75}
[]
[null,"使い方"]
[]
[null,"最初の準備"]
[null,null,"最初に以下の作業を行ってください。"]
[null,null,"１）「固定パラメタシート」の内容（背景グレイ部分）を埋める"]
[null,null,"２）見積書などに社印や角印のイメージをあらかじめ貼っておくと便利かもしれません。"]
[null,null,"３）レイアウト変更が必要な場合は変更を加えてください。"]
[null,null,"　　※レイアウト変更については後述の「カスタマイズ」を参照してください。"]
[null,null,"上記の実施後にこのファイルを保存してください。ファイル形式は「Excelテンプレート」がオススメです。"]
[null,null,"Excelテンプレートにしておくと誤繰作での上書きを避けられます。詳しくはGoogleなどで検索してください。"]
[]
[null,"見積書の作成"]
[null,null,"見積書を発行する時は上記で作成したテンプレートを使って新規作成します。"]
[null,null,"１）「パラメタシート」の■見積り情報の項目（背景がピンク）を埋めてください。"]
[null,null,"　　※日付などで矛盾があるとパラメタシート上に赤文字の警告が表示されます。"]
[null,null,"２）「見積書」のシートの19行目以降に明細を手入力してください。入力必要項目は以下の通りです。"]
[null,null,"　・摘要：自由入力"]
[null,null,"　・数量：左側に数値、右側はドロップダウンリストから選択"]
[null,null,"　・単価：数値入力"]
[null,null,"　※上記以外の項目（通番、金額）は自動入力されます。"]
[null,null,"３）「見積書」シートを目視で確認してください。"]
[null,null,"　　※エラーのセルは、背景が赤で表示されます。"]
[null,null,"４）「見積書」シートを印刷またはPDF化してお客様にご提示ください。"]
[]
[null,"注文書の作成"]
[null,null,"注文書は本来お客様側で作成される書面ですが、発注先に作成依頼されることもあるため、"]
[null,null,"「注文書（代理発行）」シートを用意しています。"]
[null,null,"注文書を作成する場合は以下の手順で行ってください。"]
[null,null,"１）「パラメタシート」の■注文情報の項目（背景が紫色）を埋めてください。"]
[null,null,"２）「注文書（代理発行）」シートを目視で確認してください。"]
[null,null,"　　※エラーのセルは、背景が赤で表示されます。"]
[null,null,"３）「注文書（代理発行）」シートを印刷またはPDF化してお客様にご提示ください。"]
[]
[null,"注文請書の作成"]
[null,null,"注文書に対する注文請書を求められる場合にお使いください。"]
[null,null,"注文書発行済の場合は、パラメタ入力は要りません。そのまま印刷してご利用ください。"]
[null,null,"注文書未発行の場合は、以下の手順に従ってください。"]
[null,null,"１）「パラメタシート」の■注文情報の項目（背景が紫色）を埋めてください。"]
[null,null,"２）「注文請書」シートを目視で確認してください。"]
[null,null,"　　※エラーのセルは、背景が赤で表示されます。"]
[null,null,"３）「注文請書」シートを印刷またはPDF化してお客様にご提示ください。"]
[]
[null,"納品書の作成"]
[null,null,"納品書が必要な場合にご利用ください。"]
[null,null,"１）「パラメタシート」の■納品情報の項目（背景が青）を埋めてください。"]
[null,null,"　　※入力項目は納品日のみです。"]
[null,null,"２）「納品書」シートを目視で確認してください。"]
[null,null,"　　※エラーのセルは、背景が赤で表示されます。"]
[null,null,"３）「納品書」シートを印刷またはPDF化してお客様にご提示ください。"]
[]
[null,"請求書の作成"]
[null,null,"請求書の作成は以下の手順で行ってください。"]
[null,null,"１）「パラメタシート」の■請求情報の項目（背景が青）を埋めてください。"]
[null,null,"　　※入力項目は請求日のみです。"]
[null,null,"　　※支払期限は見積り時の支払い条件を元に自動計算されます。"]
[null,null,"２）「請求書」シートを目視で確認してください。"]
[null,null,"　　※エラーのセルは、背景が赤で表示されます。"]
[null,null,"３）「請求書」シートを印刷またはPDF化してお客様にご提示ください。"]
[]
[null,"領収書の作成"]
[null,null,"領収書の作成は以下の手順で行ってください。"]
[null,null,"１）「パラメタシート」の■領収情報の項目（背景が茶色）を埋めてください。"]
[null,null,"　　※入力項目は領収日（入金確認日）のみです。"]
[null,null,"２）「領収書」シートを目視で確認してください。"]
[null,null,"３）「領収書」シートを印刷またはPDF化してお客様にご提示ください。"]
[]
[null,"カスタマイズ"]
[null,null,"この表はExcel表ですので、自由にカスタマイズしていただけます。"]
[null,null,"ただし、初期状態ではあちこちのセルに保護をかけていて、セル内容が変更できないように"]
[null,null,"なっています。"]
[null,null,"これは、誤ってセル内容を変更してしまうことを防ぐための仕組みです。"]
[null,null,"保護の解除パスワードは「未設定」です。どなたでも解除していただけます。"]
[null,null,"また、パラメタシートのセルには名称定義機能を多用しています。使用している名称は"]
[null,null,"「数式」－「名前管理」のメニューから行えます。"]

{"sheet":"固定パラメタシート","index":2,"n_rows":30,"n_cols":5,"rows_kept":30}
[null,"このシートのグレイ部分を最初に入力してください。"]
[null,"入力後（見積書作成前）に、この表をExcelテンプレートとして保存されることをおすすめします。"]
[null,"※テンプレート保存しておけば、誤って上書きすることがありません。"]
[]
[null,"■自社情報"]
[null,"　自社名","○○株式会社"]
[null,"　郵便番号","〒xxx-xxxx"]
[null,"　住所１","　○○県　○○市　○○町"]
[null,"　住所２","　　　　　１ー１ー１"]
[null,"　自社担当電話番号","0xx-xxx-xxxx"]
[null,"　自社担当者メール","xxx@example.com"]
[null,"　自社担当者名"]
[null,"　インボイス登録番号","T1","（空欄可）"]
[null,"■支払方法等の情報"]
[null,"　支払月（何ヶ月後）",1,null,"↓　支払条件の文面は以下になります。"]
[null,"　支払方法","現金払","→",{"$f":"\"ご請求日の\"&IF(支払期限=1,\"翌月末\",支払期限&\"月後の月末\")&\"に\"&支払方法&\"でお願いします\"","v":"ご請求日の翌月末に現金払でお願いします"}]
[null,"　振込先（金融機関名）","△△銀行　○○支店","（空欄可）"]
[null,"　振込先（口座番号）","普通　9999999","（空欄可）"]
[null,"　振込先（名義人等）","○○株式会社","（空欄可）"]
[null,"■管理情報（通常は変更不要）"]
[null,"　通番開始行",18]
[null,"　消費税率",{"v":0.1,"d":"10%"},null,"※このExcelブックでは10%と8%の混在した書面は作成できません。"]
[null,"■リストボックス用項目"]
[null,"数量単位（見積書Ｋ列）","個","←必要に応じて、単位の追加／削減を行ってください。"]
[null,null,"台"]
[null,null,"枚"]
[null,null,"回"]
[null,null,"部"]
[null,null,"式"]
[null,null,"往復"]

{"sheet":"パラメタシート","index":3,"n_rows":32,"n_cols":9,"rows_kept":32}
[null,"↓見積書発行時の入力項目"]
[null,null,"↓注文書（代行）、注文請書発行時の入力項目"]
[{"$nulls":3},"↓納品書、請求書書発行時の入力項目"]
[{"$nulls":4},"↓領収書書発行時の入力項目"]
[{"$nulls":5},"■お客様（見積先）情報"]
[null,"○",{"$nulls":3},"　お客様名１",null,"(空欄可)"]
[null,"○",{"$nulls":3},"　お客様名２"]
[null,"○",{"$nulls":3},"　敬称（様、御中など）"]
[null,"○",{"$nulls":3},"　お客様ご担当者名",null,"(空欄可)"]
[null,"○",{"$nulls":3},"　お客様ご担当者メール",null,"(空欄可)"]
[{"$nulls":5},"■見積り情報"]
[null,"○",{"$nulls":3},"　管理番号"]
[null,"○",{"$nulls":3},"　件名"]
[null,"○",{"$nulls":3},"　作成日",null,"（年月日）",{"$f":"IF(AND(見積日<TODAY(),NOT(ISBLANK(見積日))),\"作成日が過去日\",\"\")","v":""}]
[null,"○",{"$nulls":3},"　開始（予定）日",null,"（年月日）",{"$f":"IF(AND(開始日<見積日,NOT(ISBLANK(開始日))),\"開始日と作成日が矛盾\",\"\")","v":""}]
[null,"○",{"$nulls":3},"　納品（予定）日",null,"（年月日）",{"$f":"IF(AND(納品予定日<開始日,NOT(ISBLANK(納品予定日))),\"開始日と納品日が矛盾\",\"\")","v":""}]
[null,"○",{"$nulls":3},"　見積有効期限（日数）",null,"日"]
[{"$nulls":5},"■注文書情報（お客様の代筆をする場合に利用）"]
[null,null,"△",null,null,"　発注日",null,"（年月日）",{"$f":"IF(AND(発注日<見積日,NOT(ISBLANK(注文日))),\"納品日異常\",\"\")","v":""}]
[null,null,"△",null,null,"　お客様郵便番号"]
[null,null,"△",null,null,"　お客様所在地"]
[null,null,"△",null,null,"　お客様所在地（予備）",null,"(空欄可)"]
[null,null,"△",null,null,"　お客様Tel"]
[{"$nulls":5},"■注文請書情報（注文請書を作成する場合に利用）"]
[null,null,"△",null,null,"　注文請日（受注日）",null,"（年月日）",{"$f":"IF(AND(注文請日<発注日,NOT(ISBLANK(注文請日))),\"発注日と注文請日が矛盾\",\"\")","v":""}]
[{"$nulls":5},"■納品書情報"]
[{"$nulls":3},"○",null,"　作成日（納品日）",null,"（年月日）",{"$f":"IF(AND(納品日<発注日,NOT(ISBLANK(納品日))),\"納品日と発注日が矛盾\",\"\")","v":""}]
[{"$nulls":5},"■請求書情報"]
[{"$nulls":3},"○",null,"　作成日（請求日）",null,"（年月日）",{"$f":"IF(AND(請求日<発注日,NOT(ISBLANK(請求日))),\"請求日と発注日が矛盾\",\"\")","v":""}]
[{"$nulls":3},"－",null,"　支払期日（自動計算）",{"$f":"IF(請求日<>0,EOMONTH(請求日,支払期限),0)","v":"00:00:00"},null,{"$f":"IF(AND(支払期日<>0,支払期日<TODAY()),\"支払期日異常\",\"\")","v":""}]
[{"$nulls":5},"■領収書情報"]
[{"$nulls":4},"○","　入金確認日","未確認","（年月日）"]

{"sheet":"見積書","index":4,"n_rows":36,"n_cols":15,"rows_kept":36,"merged":[[0,0,0,16],[3,0,3,6],[3,7,3,8],[3,11,3,12],[3,13,3,16],[4,1,4,2],[4,3,4,5],[4,11,4,12],[4,13,4,16],[6,0,6,1],[6,2,6,8],[6,10,6,16],[7,1,7,9],[7,10,7,16],[8,1,8,9],[8,10,8,16],[9,10,9,16],[10,0,10,1],[10,2,10,4],[10,10,10,11],[10,12,10,16],[11,0,11,1],[11,2,11,4],[11,10,11,11],[11,12,11,16],[12,0,12,1],[12,10,12,11],[12,12,12,16],[15,0,15,2],[15,3,15,6],[15,7,15,8],[15,9,15,11],[15,12,15,16],[17,1,17,8],[17,9,17,10],[17,11,17,13],[17,14,17,16],[18,1,18,8],[18,11,18,13],[18,14,18,16],[19,1,19,8],[19,11,19,13],[19,14,19,16],[20,1,20,8],[20,11,20,13],[20,14,20,16],[21,1,21,8],[21,11,21,13],[21,14,21,16],[22,1,22,8],[22,11,22,13],[22,14,22,16],[23,1,23,8],[23,11,23,13],[23,14,23,16],[24,1,24,8],[24,11,24,13],[24,14,24,16],[25,1,25,8],[25,11,25,13],[25,14,25,16],[26,1,26,8],[26,11,26,13],[26,14,26,16],[27,1,27,8],[27,11,27,13],[27,14,27,16],[28,1,28,8],[28,11,28,13],[28,14,28,16],[29,1,29,8],[29,11,29,13],[29,14,29,16],[30,9,30,10],[30,11,30,16],[31,9,31,10],[31,11,31,12],[31,13,31,16],[32,9,32,10],[32,11,32,16],[35,0,42,1],[35,2,42,16]]}
["御見積書"]
[]
[{"$f":"肩書き","v":0}]
[{"$f":"お客様名","v":0},{"$nulls":6},{"$f":"敬称","v":0},{"$nulls":3},"管理No.",null,{"$f":"管理No","v":0}]
[null,{"$f":"IF(ISBLANK(ご担当),\"\",\"ご担当\")","v":""},null,{"$f":"ご担当","v":0},null,null,{"$f":"IF(ISBLANK(ご担当),\"\",\"様\")","v":""},{"$nulls":4},"作成日",null,{"$f":"見積日","v":"00:00:00"}]
[]
["件名：",null,{"$f":"件名","v":0},{"$nulls":7},{"$f":"自社名","v":"○○株式会社"}]
[{"$nulls":10},{"$f":"自社〒番号","v":"〒xxx-xxxx"}]
[null,"下記の通り、お見積り申し上げます。",{"$nulls":8},{"$f":"自社所在地1","v":"　○○県　○○市　○○町"}]
[{"$nulls":10},{"$f":"自社所在地2","v":"　　　　　１ー１ー１"}]
["作業開始日：",null,{"$f":"開始日","v":"00:00:00"},{"$nulls":7},"TEL：",null,{"$f":"自社担当電話","v":"0xx-xxx-xxxx"}]
["納品日：",null,{"$f":"納品予定日","v":"00:00:00"},{"$nulls":7},"E-Mail：",null,{"$f":"自社担当メール","v":"xxx@example.com"}]
["お支払条件：",null,{"$f":"支払条件","v":"ご請求日の翌月末に現金払でお願いします"},{"$nulls":7},"担当：",null,{"$f":"自社担当名","v":0}]
[]
[]
["合計金額",null,null,{"$f":"L33","v":{"v":0,"d":"¥0"}},{"$nulls":3},"（税込）",null,"有効期間：",null,null,{"$f":"見積有効期限","v":{"v":0,"d":"ご提示日から 0日"}}]
[]
["No.","摘要",{"$nulls":7},"数量",null,"単価",null,null,"金額"]
[{"$f":"IF(OR(ISBLANK(B19),B19=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},{"$f":"IF(AND(J19<>\"\",L19<>\"\"),J19*L19,\"\")","v":""}]
[{"$f":"IF(OR(ISBLANK(B20),B20=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},{"$f":"IF(AND(J20<>\"\",L20<>\"\"),J20*L20,\"\")","v":""}]
[{"$f":"IF(OR(ISBLANK(B21),B21=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},{"$f":"IF(AND(J21<>\"\",L21<>\"\"),J21*L21,\"\")","v":""}]
[{"$f":"IF(OR(ISBLANK(B22),B22=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},""]
[{"$f":"IF(OR(ISBLANK(B23),B23=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},""]
[{"$f":"IF(OR(ISBLANK(B24),B24=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},""]
[{"$f":"IF(OR(ISBLANK(B25),B25=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},""]
[{"$f":"IF(OR(ISBLANK(B26),B26=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},""]
[{"$f":"IF(OR(ISBLANK(B27),B27=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},""]
[{"$f":"IF(OR(ISBLANK(B28),B28=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},""]
[{"$f":"IF(OR(ISBLANK(B29),B29=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},""]
[{"$f":"IF(OR(ISBLANK(B30),B30=\"以下余白\"),\"\",ROW()-オフセット)","v":""},{"$nulls":13},""]
[{"$nulls":9},"小計",null,{"$f":"SUM(O19:Q30)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"消費税",null,{"$f":"消費税","v":{"v":0.1,"d":"(10%)"}},null,{"$f":"L31*消費税","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"合計",null,{"$f":"L31+N32","v":{"v":0,"d":"¥0"}}]
[]
[]
["備考"]

{"sheet":"注文書（代理発行）","index":5,"n_rows":36,"n_cols":15,"rows_kept":36,"merged":[[0,0,0,16],[3,0,3,6],[3,7,3,8],[3,11,3,12],[3,13,3,16],[4,11,4,12],[4,13,4,16],[6,0,6,1],[6,2,6,8],[6,10,6,16],[7,11,7,16],[8,10,8,16],[9,10,9,16],[10,10,10,16],[11,10,11,11],[11,12,11,16],[12,10,12,11],[12,12,12,16],[13,10,13,11],[13,12,13,16],[15,0,15,2],[15,3,15,6],[15,7,15,8],[17,1,17,8],[17,9,17,10],[17,11,17,13],[17,14,17,16],[18,1,18,8],[18,11,18,13],[18,14,18,16],[19,1,19,8],[19,11,19,13],[19,14,19,16],[20,1,20,8],[20,11,20,13],[20,14,20,16],[21,1,21,8],[21,11,21,13],[21,14,21,16],[22,1,22,8],[22,11,22,13],[22,14,22,16],[23,1,23,8],[23,11,23,13],[23,14,23,16],[24,1,24,8],[24,11,24,13],[24,14,24,16],[25,1,25,8],[25,11,25,13],[25,14,25,16],[26,1,26,8],[26,11,26,13],[26,14,26,16],[27,1,27,8],[27,11,27,13],[27,14,27,16],[28,1,28,8],[28,11,28,13],[28,14,28,16],[29,1,29,8],[29,11,29,13],[29,14,29,16],[30,9,30,10],[30,11,30,16],[31,9,31,10],[31,11,31,12],[31,13,31,16],[32,9,32,10],[32,11,32,16],[35,0,42,1],[35,2,42,16]]}
["注文書"]
[]
[{"$f":"肩書き","v":0}]
[{"$f":"自社名","v":"○○株式会社"},{"$nulls":6},"御中",{"$nulls":3},"管理No.",null,{"$f":"管理No","v":0}]
[{"$nulls":11},"注文日",null,{"$f":"発注日","v":"00:00:00"}]
[]
["件名：",null,{"$f":"件名","v":0},{"$nulls":7},{"$f":"肩書き","v":0}]
[{"$nulls":11},{"$f":"お客様名","v":0}]
[null,"下記の通り、注文いたします。",{"$nulls":8},{"$f":"〒番号","v":0}]
[{"$nulls":10},{"$f":"お客様所在地１","v":0}]
[{"$nulls":10},{"$f":"お客様所在地２","v":0}]
[{"$nulls":10},"TEL：",null,{"$f":"お客様Tel","v":0}]
[{"$nulls":10},"E-Mail：",null,{"$f":"ご担当者メール","v":0}]
[{"$nulls":10},"担当：",null,{"$f":"ご担当","v":0}]
[]
["合計金額",null,null,{"$f":"見積合計","v":{"v":0,"d":"¥0"}},{"$nulls":3},"（税込）"]
[]
["No.","摘要",{"$nulls":7},"数量",null,"単価",null,null,"金額"]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B19","v":0},{"$nulls":7},{"$f":"見積書!J19","v":0},{"$f":"見積書!K19","v":0},{"$f":"見積書!L19","v":0},null,null,{"$f":"見積書!O19","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B20","v":0},{"$nulls":7},{"$f":"見積書!J20","v":0},{"$f":"見積書!K20","v":0},{"$f":"見積書!L20","v":0},null,null,{"$f":"見積書!O20","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B21","v":0},{"$nulls":7},{"$f":"見積書!J21","v":0},{"$f":"見積書!K21","v":0},{"$f":"見積書!L21","v":0},null,null,{"$f":"見積書!O21","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B22","v":0},{"$nulls":7},{"$f":"見積書!J22","v":0},{"$f":"見積書!K22","v":0},{"$f":"見積書!L22","v":0},null,null,{"$f":"見積書!O22","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B23","v":0},{"$nulls":7},{"$f":"見積書!J23","v":0},{"$f":"見積書!K23","v":0},{"$f":"見積書!L23","v":0},null,null,{"$f":"見積書!O23","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B24","v":0},{"$nulls":7},{"$f":"見積書!J24","v":0},{"$f":"見積書!K24","v":0},{"$f":"見積書!L24","v":0},null,null,{"$f":"見積書!O24","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B25","v":0},{"$nulls":7},{"$f":"見積書!J25","v":0},{"$f":"見積書!K25","v":0},{"$f":"見積書!L25","v":0},null,null,{"$f":"見積書!O25","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B26","v":0},{"$nulls":7},{"$f":"見積書!J26","v":0},{"$f":"見積書!K26","v":0},{"$f":"見積書!L26","v":0},null,null,{"$f":"見積書!O26","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B27","v":0},{"$nulls":7},{"$f":"見積書!J27","v":0},{"$f":"見積書!K27","v":0},{"$f":"見積書!L27","v":0},null,null,{"$f":"見積書!O27","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B28","v":0},{"$nulls":7},{"$f":"見積書!J28","v":0},{"$f":"見積書!K28","v":0},{"$f":"見積書!L28","v":0},null,null,{"$f":"見積書!O28","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B29","v":0},{"$nulls":7},{"$f":"見積書!J29","v":0},{"$f":"見積書!K29","v":0},{"$f":"見積書!L29","v":0},null,null,{"$f":"見積書!O29","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B30","v":0},{"$nulls":7},{"$f":"見積書!J30","v":0},{"$f":"見積書!K30","v":0},{"$f":"見積書!L30","v":0},null,null,{"$f":"見積書!O30","v":""}]
[{"$nulls":9},"小計",null,{"$f":"見積小計","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"消費税",null,{"$f":"消費税","v":{"v":0.1,"d":"(10%)"}},null,{"$f":"見積消費税額","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"合計",null,{"$f":"見積合計","v":{"v":0,"d":"¥0"}}]
[]
[]
["備考"]

{"sheet":"注文請書","index":6,"n_rows":37,"n_cols":15,"rows_kept":37,"merged":[[0,0,0,16],[3,0,3,6],[3,7,3,8],[3,11,3,12],[3,13,3,16],[4,1,4,2],[4,3,4,5],[4,11,4,12],[4,13,4,16],[6,0,6,1],[6,2,6,8],[6,10,6,16],[7,10,7,16],[8,10,8,16],[9,10,9,16],[10,10,10,11],[10,12,10,16],[11,10,11,11],[11,12,11,16],[12,10,12,11],[12,12,12,16],[15,0,15,2],[15,3,15,6],[15,7,15,8],[17,1,17,8],[17,9,17,10],[17,11,17,13],[17,14,17,16],[18,1,18,8],[18,11,18,13],[18,14,18,16],[19,1,19,8],[19,11,19,13],[19,14,19,16],[20,1,20,8],[20,11,20,13],[20,14,20,16],[21,1,21,8],[21,11,21,13],[21,14,21,16],[22,1,22,8],[22,11,22,13],[22,14,22,16],[23,1,23,8],[23,11,23,13],[23,14,23,16],[24,1,24,8],[24,11,24,13],[24,14,24,16],[25,1,25,8],[25,11,25,13],[25,14,25,16],[26,1,26,8],[26,11,26,13],[26,14,26,16],[27,1,27,8],[27,11,27,13],[27,14,27,16],[28,1,28,8],[28,11,28,13],[28,14,28,16],[29,1,29,8],[29,11,29,13],[29,14,29,16],[30,9,30,10],[30,11,30,16],[31,9,31,10],[31,11,31,12],[31,13,31,16],[32,1,32,2],[32,9,32,10],[32,11,32,16],[36,0,42,1],[36,2,42,16]]}
["注文請書"]
[]
[{"$f":"肩書き","v":0}]
[{"$f":"お客様名","v":0},{"$nulls":6},{"$f":"敬称","v":0},{"$nulls":3},"管理No.",null,{"$f":"管理No","v":0}]
[null,{"$f":"IF(ISBLANK(ご担当),\"\",\"ご担当\")","v":""},null,{"$f":"ご担当","v":0},null,null,{"$f":"IF(ISBLANK(ご担当),\"\",\"様\")","v":""},{"$nulls":4},"作成日",null,{"$f":"注文請日","v":"00:00:00"}]
[]
["件名：",null,{"$f":"件名","v":0},{"$nulls":7},{"$f":"自社名","v":"○○株式会社"}]
[{"$nulls":10},{"$f":"自社〒番号","v":"〒xxx-xxxx"}]
[null,"ご注文ありがとうございます。",{"$nulls":8},{"$f":"自社所在地1","v":"　○○県　○○市　○○町"}]
[null,"下記の通り、ご注文をお請けいたします。",{"$nulls":8},{"$f":"自社所在地2","v":"　　　　　１ー１ー１"}]
[{"$nulls":10},"TEL：",null,{"$f":"自社担当電話","v":"0xx-xxx-xxxx"}]
[{"$nulls":10},"E-Mail：",null,{"$f":"自社担当メール","v":"xxx@example.com"}]
[{"$nulls":10},"担当：",null,{"$f":"自社担当名","v":0}]
[]
[]
["合計金額",null,null,{"$f":"見積合計","v":{"v":0,"d":"¥0"}},{"$nulls":3},"（税込）"]
[]
["No.","摘要",{"$nulls":7},"数量",null,"単価",null,null,"金額"]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B19","v":0},{"$nulls":7},{"$f":"見積書!J19","v":0},{"$f":"見積書!K19","v":0},{"$f":"見積書!L19","v":0},null,null,{"$f":"見積書!O19","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B20","v":0},{"$nulls":7},{"$f":"見積書!J20","v":0},{"$f":"見積書!K20","v":0},{"$f":"見積書!L20","v":0},null,null,{"$f":"見積書!O20","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B21","v":0},{"$nulls":7},{"$f":"見積書!J21","v":0},{"$f":"見積書!K21","v":0},{"$f":"見積書!L21","v":0},null,null,{"$f":"見積書!O21","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B22","v":0},{"$nulls":7},{"$f":"見積書!J22","v":0},{"$f":"見積書!K22","v":0},{"$f":"見積書!L22","v":0},null,null,{"$f":"見積書!O22","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B23","v":0},{"$nulls":7},{"$f":"見積書!J23","v":0},{"$f":"見積書!K23","v":0},{"$f":"見積書!L23","v":0},null,null,{"$f":"見積書!O23","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B24","v":0},{"$nulls":7},{"$f":"見積書!J24","v":0},{"$f":"見積書!K24","v":0},{"$f":"見積書!L24","v":0},null,null,{"$f":"見積書!O24","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B25","v":0},{"$nulls":7},{"$f":"見積書!J25","v":0},{"$f":"見積書!K25","v":0},{"$f":"見積書!L25","v":0},null,null,{"$f":"見積書!O25","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B26","v":0},{"$nulls":7},{"$f":"見積書!J26","v":0},{"$f":"見積書!K26","v":0},{"$f":"見積書!L26","v":0},null,null,{"$f":"見積書!O26","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B27","v":0},{"$nulls":7},{"$f":"見積書!J27","v":0},{"$f":"見積書!K27","v":0},{"$f":"見積書!L27","v":0},null,null,{"$f":"見積書!O27","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B28","v":0},{"$nulls":7},{"$f":"見積書!J28","v":0},{"$f":"見積書!K28","v":0},{"$f":"見積書!L28","v":0},null,null,{"$f":"見積書!O28","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B29","v":0},{"$nulls":7},{"$f":"見積書!J29","v":0},{"$f":"見積書!K29","v":0},{"$f":"見積書!L29","v":0},null,null,{"$f":"見積書!O29","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B30","v":0},{"$nulls":7},{"$f":"見積書!J30","v":0},{"$f":"見積書!K30","v":0},{"$f":"見積書!L30","v":0},null,null,{"$f":"見積書!O30","v":""}]
[{"$nulls":9},"小計",null,{"$f":"見積小計","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"消費税",null,{"$f":"消費税","v":{"v":0.1,"d":"(10%)"}},null,{"$f":"見積消費税額","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"合計",null,{"$f":"見積合計","v":{"v":0,"d":"¥0"}}]
[]
[]
[]
["備考"]

{"sheet":"納品書","index":7,"n_rows":37,"n_cols":15,"rows_kept":37,"merged":[[0,0,0,16],[3,0,3,6],[3,7,3,8],[3,11,3,12],[3,13,3,16],[4,1,4,2],[4,3,4,5],[4,11,4,12],[4,13,4,16],[6,0,6,1],[6,2,6,8],[6,10,6,16],[7,10,7,16],[8,10,8,16],[9,10,9,16],[10,10,10,11],[10,12,10,16],[11,10,11,11],[11,12,11,16],[12,10,12,11],[12,12,12,16],[15,0,15,2],[15,3,15,6],[15,7,15,8],[17,1,17,8],[17,9,17,10],[17,11,17,13],[17,14,17,16],[18,1,18,8],[18,11,18,13],[18,14,18,16],[19,1,19,8],[19,11,19,13],[19,14,19,16],[20,1,20,8],[20,11,20,13],[20,14,20,16],[21,1,21,8],[21,11,21,13],[21,14,21,16],[22,1,22,8],[22,11,22,13],[22,14,22,16],[23,1,23,8],[23,11,23,13],[23,14,23,16],[24,1,24,8],[24,11,24,13],[24,14,24,16],[25,1,25,8],[25,11,25,13],[25,14,25,16],[26,1,26,8],[26,11,26,13],[26,14,26,16],[27,1,27,8],[27,11,27,13],[27,14,27,16],[28,1,28,8],[28,11,28,13],[28,14,28,16],[29,1,29,8],[29,11,29,13],[29,14,29,16],[30,9,30,10],[30,11,30,16],[31,9,31,10],[31,11,31,12],[31,13,31,16],[32,1,32,2],[32,9,32,10],[32,11,32,16],[36,0,42,1],[36,2,42,16]]}
["納品書"]
[]
[{"$f":"肩書き","v":0}]
[{"$f":"お客様名","v":0},{"$nulls":6},{"$f":"敬称","v":0},{"$nulls":3},"管理No.",null,{"$f":"管理No","v":0}]
[null,{"$f":"IF(ISBLANK(ご担当),\"\",\"ご担当\")","v":""},null,{"$f":"ご担当","v":0},null,null,{"$f":"IF(ISBLANK(ご担当),\"\",\"様\")","v":""},{"$nulls":4},"作成日",null,{"$f":"納品日","v":"00:00:00"}]
[]
["件名：",null,{"$f":"件名","v":0},{"$nulls":7},{"$f":"自社名","v":"○○株式会社"}]
[{"$nulls":10},{"$f":"自社〒番号","v":"〒xxx-xxxx"}]
[null,"下記の通り、納品いたします。",{"$nulls":8},{"$f":"自社所在地1","v":"　○○県　○○市　○○町"}]
[null,"ご確認をよろしくお願いいたします。",{"$nulls":8},{"$f":"自社所在地2","v":"　　　　　１ー１ー１"}]
[{"$nulls":10},"TEL：",null,{"$f":"自社担当電話","v":"0xx-xxx-xxxx"}]
[{"$nulls":10},"E-Mail：",null,{"$f":"自社担当メール","v":"xxx@example.com"}]
[{"$nulls":10},"担当：",null,{"$f":"自社担当名","v":0}]
[]
[]
["合計金額",null,null,{"$f":"見積合計","v":{"v":0,"d":"¥0"}},{"$nulls":3},"（税込）"]
[]
["No.","摘要",{"$nulls":7},"数量",null,"単価",null,null,"金額"]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B19","v":0},{"$nulls":7},{"$f":"見積書!J19","v":0},{"$f":"見積書!K19","v":0},{"$f":"見積書!L19","v":0},null,null,{"$f":"見積書!O19","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B20","v":0},{"$nulls":7},{"$f":"見積書!J20","v":0},{"$f":"見積書!K20","v":0},{"$f":"見積書!L20","v":0},null,null,{"$f":"見積書!O20","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B21","v":0},{"$nulls":7},{"$f":"見積書!J21","v":0},{"$f":"見積書!K21","v":0},{"$f":"見積書!L21","v":0},null,null,{"$f":"見積書!O21","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B22","v":0},{"$nulls":7},{"$f":"見積書!J22","v":0},{"$f":"見積書!K22","v":0},{"$f":"見積書!L22","v":0},null,null,{"$f":"見積書!O22","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B23","v":0},{"$nulls":7},{"$f":"見積書!J23","v":0},{"$f":"見積書!K23","v":0},{"$f":"見積書!L23","v":0},null,null,{"$f":"見積書!O23","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B24","v":0},{"$nulls":7},{"$f":"見積書!J24","v":0},{"$f":"見積書!K24","v":0},{"$f":"見積書!L24","v":0},null,null,{"$f":"見積書!O24","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B25","v":0},{"$nulls":7},{"$f":"見積書!J25","v":0},{"$f":"見積書!K25","v":0},{"$f":"見積書!L25","v":0},null,null,{"$f":"見積書!O25","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B26","v":0},{"$nulls":7},{"$f":"見積書!J26","v":0},{"$f":"見積書!K26","v":0},{"$f":"見積書!L26","v":0},null,null,{"$f":"見積書!O26","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B27","v":0},{"$nulls":7},{"$f":"見積書!J27","v":0},{"$f":"見積書!K27","v":0},{"$f":"見積書!L27","v":0},null,null,{"$f":"見積書!O27","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B28","v":0},{"$nulls":7},{"$f":"見積書!J28","v":0},{"$f":"見積書!K28","v":0},{"$f":"見積書!L28","v":0},null,null,{"$f":"見積書!O28","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B29","v":0},{"$nulls":7},{"$f":"見積書!J29","v":0},{"$f":"見積書!K29","v":0},{"$f":"見積書!L29","v":0},null,null,{"$f":"見積書!O29","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B30","v":0},{"$nulls":7},{"$f":"見積書!J30","v":0},{"$f":"見積書!K30","v":0},{"$f":"見積書!L30","v":0},null,null,{"$f":"見積書!O30","v":""}]
[{"$nulls":9},"小計",null,{"$f":"見積小計","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"消費税",null,{"$f":"消費税","v":{"v":0.1,"d":"(10%)"}},null,{"$f":"見積消費税額","v":{"v":0,"d":"¥0"}}]
[null,{"$f":"IF(振込先１<>\"\",\"お振込先\",\"\")","v":"お振込先"},null,{"$f":"IF(振込先１<>\"\",振込先１,\"\")","v":"△△銀行　○○支店"},{"$nulls":5},"合計",null,{"$f":"見積合計","v":{"v":0,"d":"¥0"}}]
[{"$nulls":3},{"$f":"IF(振込先２<>\"\",振込先２,\"\")","v":"普通　9999999"}]
[{"$nulls":3},{"$f":"IF(振込先３<>\"\",振込先３,\"\")","v":"○○株式会社"}]
[]
["備考",null,"恐れ入りますが、振込手数料は貴社にてご負担ください。"]

{"sheet":"請求書","index":8,"n_rows":37,"n_cols":15,"rows_kept":37,"merged":[[0,0,0,16],[3,0,3,6],[3,7,3,8],[3,11,3,12],[3,13,3,16],[4,1,4,2],[4,3,4,5],[4,11,4,12],[4,13,4,16],[6,0,6,1],[6,2,6,8],[6,10,6,16],[7,10,7,16],[8,10,8,16],[9,10,9,16],[10,1,10,2],[10,3,10,6],[10,10,10,11],[10,12,10,16],[11,3,11,6],[11,10,11,11],[11,12,11,16],[12,3,12,6],[12,10,12,11],[12,12,12,16],[13,10,13,11],[13,12,13,16],[15,0,15,2],[15,3,15,6],[15,7,15,8],[15,9,15,11],[15,12,15,16],[17,1,17,8],[17,9,17,10],[17,11,17,13],[17,14,17,16],[18,1,18,8],[18,11,18,13],[18,14,18,16],[19,1,19,8],[19,11,19,13],[19,14,19,16],[20,1,20,8],[20,11,20,13],[20,14,20,16],[21,1,21,8],[21,11,21,13],[21,14,21,16],[22,1,22,8],[22,11,22,13],[22,14,22,16],[23,1,23,8],[23,11,23,13],[23,14,23,16],[24,1,24,8],[24,11,24,13],[24,14,24,16],[25,1,25,8],[25,11,25,13],[25,14,25,16],[26,1,26,8],[26,11,26,13],[26,14,26,16],[27,1,27,8],[27,11,27,13],[27,14,27,16],[28,1,28,8],[28,11,28,13],[28,14,28,16],[29,1,29,8],[29,11,29,13],[29,14,29,16],[30,9,30,10],[30,11,30,16],[31,9,31,10],[31,11,31,12],[31,13,31,16],[32,9,32,10],[32,11,32,16],[36,0,42,1],[36,2,42,16]]}
["御請求書"]
[]
[{"$f":"肩書き","v":0}]
[{"$f":"お客様名","v":0},{"$nulls":6},{"$f":"敬称","v":0},{"$nulls":3},"管理No.",null,{"$f":"管理No","v":0}]
[null,{"$f":"IF(ISBLANK(ご担当),\"\",\"ご担当\")","v":""},null,{"$f":"ご担当","v":0},null,null,{"$f":"IF(ISBLANK(ご担当),\"\",\"様\")","v":""},{"$nulls":4},"作成日",null,{"$f":"請求日","v":"00:00:00"}]
[]
["件名：",null,{"$f":"件名","v":0},{"$nulls":7},{"$f":"自社名","v":"○○株式会社"}]
[{"$nulls":10},{"$f":"自社〒番号","v":"〒xxx-xxxx"}]
[null,"下記の通り、ご請求申し上げます。",{"$nulls":8},{"$f":"自社所在地1","v":"　○○県　○○市　○○町"}]
[{"$nulls":10},{"$f":"自社所在地2","v":"　　　　　１ー１ー１"}]
[null,{"$f":"IF(振込先１<>\"\",\"お振込先：\",\"\")","v":"お振込先："},null,{"$f":"IF(振込先１<>\"\",振込先１,\"\")","v":"△△銀行　○○支店"},{"$nulls":6},"TEL：",null,{"$f":"自社担当電話","v":"0xx-xxx-xxxx"}]
[{"$nulls":3},{"$f":"IF(振込先２<>\"\",振込先２,\"\")","v":"普通　9999999"},{"$nulls":6},"E-Mail：",null,{"$f":"自社担当メール","v":"xxx@example.com"}]
[{"$nulls":3},{"$f":"IF(振込先３<>\"\",振込先３,\"\")","v":"○○株式会社"},{"$nulls":6},"担当：",null,{"$f":"自社担当名","v":0}]
[{"$nulls":10},{"$f":"IF(固定パラメタシート!C13<>\"\",\"登録番号：\",\"\")","v":"登録番号："},null,{"$f":"適格事業者番号","v":"T1"}]
[]
["合計金額",null,null,{"$f":"見積合計","v":{"v":0,"d":"¥0"}},{"$nulls":3},"（税込）",null,"お支払期限：",null,null,{"$f":"支払期日","v":"00:00:00"}]
[]
["No.","摘要",{"$nulls":7},"数量",null,"単価",null,null,"金額"]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B19","v":0},{"$nulls":7},{"$f":"見積書!J19","v":0},{"$f":"見積書!K19","v":0},{"$f":"見積書!L19","v":0},null,null,{"$f":"見積書!O19","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B20","v":0},{"$nulls":7},{"$f":"見積書!J20","v":0},{"$f":"見積書!K20","v":0},{"$f":"見積書!L20","v":0},null,null,{"$f":"見積書!O20","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B21","v":0},{"$nulls":7},{"$f":"見積書!J21","v":0},{"$f":"見積書!K21","v":0},{"$f":"見積書!L21","v":0},null,null,{"$f":"見積書!O21","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B22","v":0},{"$nulls":7},{"$f":"見積書!J22","v":0},{"$f":"見積書!K22","v":0},{"$f":"見積書!L22","v":0},null,null,{"$f":"見積書!O22","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B23","v":0},{"$nulls":7},{"$f":"見積書!J23","v":0},{"$f":"見積書!K23","v":0},{"$f":"見積書!L23","v":0},null,null,{"$f":"見積書!O23","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B24","v":0},{"$nulls":7},{"$f":"見積書!J24","v":0},{"$f":"見積書!K24","v":0},{"$f":"見積書!L24","v":0},null,null,{"$f":"見積書!O24","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B25","v":0},{"$nulls":7},{"$f":"見積書!J25","v":0},{"$f":"見積書!K25","v":0},{"$f":"見積書!L25","v":0},null,null,{"$f":"見積書!O25","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B26","v":0},{"$nulls":7},{"$f":"見積書!J26","v":0},{"$f":"見積書!K26","v":0},{"$f":"見積書!L26","v":0},null,null,{"$f":"見積書!O26","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B27","v":0},{"$nulls":7},{"$f":"見積書!J27","v":0},{"$f":"見積書!K27","v":0},{"$f":"見積書!L27","v":0},null,null,{"$f":"見積書!O27","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B28","v":0},{"$nulls":7},{"$f":"見積書!J28","v":0},{"$f":"見積書!K28","v":0},{"$f":"見積書!L28","v":0},null,null,{"$f":"見積書!O28","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B29","v":0},{"$nulls":7},{"$f":"見積書!J29","v":0},{"$f":"見積書!K29","v":0},{"$f":"見積書!L29","v":0},null,null,{"$f":"見積書!O29","v":""}]
[{"$f":"INDIRECT(\"見積書!A\"&ROW())","v":""},{"$f":"見積書!B30","v":0},{"$nulls":7},{"$f":"見積書!J30","v":0},{"$f":"見積書!K30","v":0},{"$f":"見積書!L30","v":0},null,null,{"$f":"見積書!O30","v":""}]
[{"$nulls":9},"小計",null,{"$f":"見積小計","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"消費税",null,{"$f":"消費税","v":{"v":0.1,"d":"(10%)"}},null,{"$f":"見積消費税額","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"合計",null,{"$f":"見積合計","v":{"v":0,"d":"¥0"}}]
[]
[]
[]
["備考",null,"恐れ入りますが、振込手数料は貴社にてご負担ください。"]

{"sheet":"領収書","index":9,"n_rows":37,"n_cols":15,"rows_kept":37,"merged":[[0,0,0,16],[3,0,3,6],[3,7,3,8],[3,11,3,12],[3,13,3,16],[4,1,4,2],[4,3,4,5],[4,11,4,12],[4,13,4,16],[6,0,6,1],[6,2,6,8],[6,10,6,16],[7,10,7,16],[8,10,8,16],[9,10,9,16],[10,10,10,11],[10,12,10,16],[11,10,11,11],[11,12,11,16],[12,10,12,11],[12,12,12,16],[15,0,15,2],[15,3,15,6],[17,1,17,8],[17,9,17,10],[17,11,17,13],[17,14,17,16],[18,1,18,8],[18,11,18,13],[18,14,18,16],[19,1,19,8],[19,11,19,13],[19,14,19,16],[20,1,20,8],[20,11,20,13],[20,14,20,16],[21,1,21,8],[21,11,21,13],[21,14,21,16],[22,1,22,8],[22,11,22,13],[22,14,22,16],[23,1,23,8],[23,11,23,13],[23,14,23,16],[24,1,24,8],[24,11,24,13],[24,14,24,16],[25,1,25,8],[25,11,25,13],[25,14,25,16],[26,1,26,8],[26,11,26,13],[26,14,26,16],[27,1,27,8],[27,11,27,13],[27,14,27,16],[28,1,28,8],[28,11,28,13],[28,14,28,16],[29,1,29,8],[29,11,29,13],[29,14,29,16],[30,9,30,10],[30,11,30,16],[31,9,31,10],[31,11,31,12],[31,13,31,16],[32,9,32,10],[32,11,32,16],[36,0,42,1],[36,2,42,16]]}
["領収書"]
[]
[{"$f":"肩書き","v":0}]
[{"$f":"お客様名","v":0},{"$nulls":6},{"$f":"敬称","v":0},{"$nulls":3},"管理No.",null,{"$f":"管理No","v":0}]
[null,{"$f":"IF(ISBLANK(ご担当),\"\",\"ご担当\")","v":""},null,{"$f":"ご担当","v":0},null,null,{"$f":"IF(ISBLANK(ご担当),\"\",\"様\")","v":""},{"$nulls":4},"作成日",null,{"$f":"入金確認日","v":"未確認"}]
[]
["件名：",null,{"$f":"件名","v":0},{"$nulls":7},{"$f":"自社名","v":"○○株式会社"}]
[{"$nulls":10},{"$f":"自社〒番号","v":"〒xxx-xxxx"}]
[null,"下記、正に領収いたしました。",{"$nulls":8},{"$f":"自社所在地1","v":"　○○県　○○市　○○町"}]
[{"$nulls":10},{"$f":"自社所在地2","v":"　　　　　１ー１ー１"}]
[{"$nulls":10},"TEL：",null,{"$f":"自社担当電話","v":"0xx-xxx-xxxx"}]
[{"$nulls":10},"E-Mail：",null,{"$f":"自社担当メール","v":"xxx@example.com"}]
[{"$nulls":10},"担当：",null,{"$f":"自社担当名","v":0}]
[]
[]
["合計金額",null,null,{"$f":"見積合計","v":{"v":0,"d":"¥0"}},{"$nulls":3},"（税込）"]
[]
["No.","摘要",{"$nulls":7},"数量",null,"単価",null,null,"金額"]
[{"$f":"請求書!A19","v":""},{"$f":"見積書!B19","v":0},{"$nulls":7},{"$f":"見積書!J19","v":0},{"$f":"見積書!K19","v":0},{"$f":"見積書!L19","v":0},null,null,{"$f":"見積書!O19","v":""}]
[{"$f":"請求書!A20","v":""},{"$f":"見積書!B20","v":0},{"$nulls":7},{"$f":"見積書!J20","v":0},{"$f":"見積書!K20","v":0},{"$f":"見積書!L20","v":0},null,null,{"$f":"見積書!O20","v":""}]
[{"$f":"請求書!A21","v":""},{"$f":"見積書!B21","v":0},{"$nulls":7},{"$f":"見積書!J21","v":0},{"$f":"見積書!K21","v":0},{"$f":"見積書!L21","v":0},null,null,{"$f":"見積書!O21","v":""}]
[{"$f":"請求書!A22","v":""},{"$f":"見積書!B22","v":0},{"$nulls":7},{"$f":"見積書!J22","v":0},{"$f":"見積書!K22","v":0},{"$f":"見積書!L22","v":0},null,null,{"$f":"見積書!O22","v":""}]
[{"$f":"請求書!A23","v":""},{"$f":"見積書!B23","v":0},{"$nulls":7},{"$f":"見積書!J23","v":0},{"$f":"見積書!K23","v":0},{"$f":"見積書!L23","v":0},null,null,{"$f":"見積書!O23","v":""}]
[{"$f":"請求書!A24","v":""},{"$f":"見積書!B24","v":0},{"$nulls":7},{"$f":"見積書!J24","v":0},{"$f":"見積書!K24","v":0},{"$f":"見積書!L24","v":0},null,null,{"$f":"見積書!O24","v":""}]
[{"$f":"請求書!A25","v":""},{"$f":"見積書!B25","v":0},{"$nulls":7},{"$f":"見積書!J25","v":0},{"$f":"見積書!K25","v":0},{"$f":"見積書!L25","v":0},null,null,{"$f":"見積書!O25","v":""}]
[{"$f":"請求書!A26","v":""},{"$f":"見積書!B26","v":0},{"$nulls":7},{"$f":"見積書!J26","v":0},{"$f":"見積書!K26","v":0},{"$f":"見積書!L26","v":0},null,null,{"$f":"見積書!O26","v":""}]
[{"$f":"請求書!A27","v":""},{"$f":"見積書!B27","v":0},{"$nulls":7},{"$f":"見積書!J27","v":0},{"$f":"見積書!K27","v":0},{"$f":"見積書!L27","v":0},null,null,{"$f":"見積書!O27","v":""}]
[{"$f":"請求書!A28","v":""},{"$f":"見積書!B28","v":0},{"$nulls":7},{"$f":"見積書!J28","v":0},{"$f":"見積書!K28","v":0},{"$f":"見積書!L28","v":0},null,null,{"$f":"見積書!O28","v":""}]
[{"$f":"請求書!A29","v":""},{"$f":"見積書!B29","v":0},{"$nulls":7},{"$f":"見積書!J29","v":0},{"$f":"見積書!K29","v":0},{"$f":"見積書!L29","v":0},null,null,{"$f":"見積書!O29","v":""}]
[{"$f":"請求書!A30","v":""},{"$f":"見積書!B30","v":0},{"$nulls":7},{"$f":"見積書!J30","v":0},{"$f":"見積書!K30","v":0},{"$f":"見積書!L30","v":0},null,null,{"$f":"見積書!O30","v":""}]
[{"$nulls":9},"小計",null,{"$f":"見積小計","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"消費税",null,{"$f":"消費税","v":{"v":0.1,"d":"(10%)"}},null,{"$f":"見積消費税額","v":{"v":0,"d":"¥0"}}]
[{"$nulls":9},"合計",null,{"$f":"見積合計","v":{"v":0,"d":"¥0"}}]
[]
[]
[]
["備考"]