{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["印刷及び基本項目入力","作成方法","表紙","現状分析および重点取組項目","経営改善計画書","入力シート№1","入力シート№2","補助シート№1（決算実績推移）","補助シート№2-1（部門別売上・粗利）","補助シート№2-2（部門別売上・粗利）","補助シート№3（人員計画）"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":2,"defined_names":58,"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":58,"n_cols":14,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,14],[31,4,31,8],[1,0,3,14],[25,4,25,8],[27,4,27,8],[29,4,29,8],[4,3,14,13],[19,4,21,8],[19,10,21,12]]}
["＜経営改善計画書（10ヵ年計画）＞"]
["印刷及び基本項目入力"]
[]
[]
[null,null,null,"＊ご利用の際の注意事項\n\n・ファイルを開くときには、「マクロを有効にする」を選択して使用してください。\n・Excelのバージョン及び設定によっては、このファイルを開くと『このブックにあるマクロはセキュリティレベルが高に設定されており・・・』というメッセージが画面に表示される場合があります。\n・この場合、以下の手順で設定を変更してください。一度変更すると以後そのパソコンでの変更は不要です。\n①「OK」をクリックしてメッセージを消します。　　　\n②Excelのメニューで「ツール」→「マクロ」→「セキュリティ」を選択します。\n③「セキュリティ」ダイアログボックスが表示されるので、「セキュリティレベル」タブの中の「中（M）コンピュータに損害を与える可能性があるマクロを実行する前に警告します」を選択して「OK」をクリックし、一旦ファイルを保存・終了し、再度ファイルを開きます。以後メッセージは表示されません。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"①",null,"経営改善計画書の「作成方法」及び「作成例」の印刷"]
[]
[null,null,null,null," 　「作成方法」",null,null,null,null,null,null,null,null,"千円"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"百万円"]
[]
[]
[null,"②",null,"基本項目の入力","～",null,"欄に入力してください。"]
[]
[null,null,null,"貴社名",null,null,null,null,null,"←","例：㈱○○工業"]
[]
[null,null,null,"取引支店名",null,null,null,null,null,"←","例：○○支店"]
[]
[null,null,null,"作成年月日",null,null,null,null,null,"←","例：2009/1/9（西暦/月/日）"]
[]
[null,null,null,"単位",null,null,null,null,null,"←","リストから選択してください（千円または百万円）"]
[]
[null,null,null,"前回決算年月",null,null,"年",null,"月期","←","リストから選択してください"]
[]
[]
[null,"③",null,"経営改善計画への入力"]
[null,null,null,"～上記①の「作成方法」、「作成例」ならびに「経営改善計画策定マニュアル」に従い入力してください。"]
[]
[]
[null,"④",null,"経営改善計画書の印刷",null,"～","印刷するシートをチェックし、印刷開始ボタンをクリックしてください。"]
[]
[]
[null,null,null,"【必須資料】"]
[]
[]
[]
[]
[null,null,null,"【補助資料】"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"⑤",null,"入力データの消去　　～　　入力したデータを一括消去する場合は、入力データ消去ボタンをクリックしてください。"]

{"sheet":"作成方法","index":1,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,0,1,22]]}
[]
["　　　『経営改善計画書』の作成（入力）方法"]
[]
[]
["Ⅰ．はじめに",null,null,null,null,null,null,null,null,null,null,null,"Ⅴ．経営改善計画書の提出方法について"]
[]
[1,".","本シートは「経営改善計画書」の作成（入力）方法をごく簡単に説明するものであり、作成にあたっては「経営",null,null,null,null,null,null,null,null,null,1,".","経営改善計画の策定が完了しましたら、全てのシートをご提出ください。"]
[null,null,"改善計画策定マニュアル（以下「マニュアル」）」をご参照願います。",null,null,null,null,null,null,null,null,null,2,".","弊行では、ご提出いただいた経営改善計画書を、実現可能性及び合理性等の観点から検証させて頂きます。"]
[2,".","また、今回お渡ししたシートのうち「補助シート№1～3」は、計画を策定する際の「補助的」な位置付けとして、",null,null,null,null,null,null,null,null,null,null,null,"その課程において、計画数値の調整等も想定されることから、極力電子メールもしくは電子記憶媒体でのご提出"]
[null,null,"入力結果が他のシートに反映する仕組みとはしておりません。最低限「入力シート№1・2」と「現状分析および",null,null,null,null,null,null,null,null,null,null,null,"をお願いいたします。"]
[null,null,"重点取組項目」を入力していただければ、「経営改善計画書」の策定は可能ですが、より合理的な計画策定"]
[null,null,"のために、補助シートを有効に活用していただくことをお勧めいたします。"]
[3,".","なお、すべてのシートにおいて「水色」に塗られた部分に入力してください。また印刷する場合には、必ず「印"]
[null,null,"刷及び基本項目入力」画面にて行ってください。"]
[]
["Ⅱ．決算実績の分析"]
[]
[1,".","「補助シート№１（決算実績推移）」の作成～マニュアル4ページ参照"]
[null,null,"経営改善計画を策定するに当たって、まずは長期的に決算実績推移を分析し、貴社の強み・弱みを把握する"]
[null,null,"ことが必要となります。10期分の損益計算書及び貸借対照表が入力できる「補助シート№1（決算実績推移）」"]
[null,null,"を活用してください。"]
[2,".","「入力シート№1・2」への入力（過去3期分の実績値入力）～マニュアル5～7ページ参照"]
[null,null,"「補助シート№1」で長期的かつ大まかに決算推移を把握した上で、過去3期分については詳細な分析を行い"]
[null,null,"ます。「入力シート№１・2」に実績数値3期分を入力すれば、「経営改善計画書」に反映されますので、現在の"]
[null,null,"経営状態に至る要因・背景を分析してください。"]
[null,null,"分析対象項目をより細分化することで、分析精度は向上します。計画策定上、重要と考えられる売上および販"]
[null,null,"管費（人件費）について、「補助シート№2（部門別粗利）」及び「補助シート№3（人員計画）」を活用してくださ"]
[null,null,"い。"]
[]
["Ⅲ．「現状分析および重点取組項目」の策定～マニュアル3～4・7～9ページ参照"]
[]
[1,".","貴社の現状を正しく把握するため、自社を取り巻く環境（外部環境）について、機会（ビジネスチャンス）と脅威"]
[null,null,"（ビジネスリスク）に分けて整理いただくと共に、貴社が保有する経営資源や収益構造（内部環境）について、"]
[null,null,"強みと弱みを列挙いただき、それぞれの要因を組合わせることで、貴社の採るべき戦略や到達を目指す目標、"]
[null,null,"今後の改善に向けての具体的な施策（重点取組項目）を決定します。"]
[2,".","重点取組項目については、計画数値（営業利益率計画値等）や実行時期・責任者を具体的に設定することで、"]
[null,null,"改善計画の合理性がより高まります。"]
[]
["Ⅳ．経営改善計画の策定～マニュアル9～14ページ参照"]
[]
[1,".","決定した重点取組項目を基に、今後10期間の計画を策定します。「入力シート№1・2」に売上（部門別）・売上"]
[null,null,"原価等の項目別に計画数値を入力すれば、「経営改善計画書」に反映されます。"]
[2,".","「入力シート№1・2」には売上総利益（率）以下の各利益（率）も表示（自動計算）されますので、過去の実績と"]
[null,null,"比較して妥当性のある計画数値となっているか、また重点取組項目で決定した売上・利益計画等と比較しながら"]
[null,null,"計画策定作業を進めてください。"]
[3,".","決算実績分析と同様に、計画策定においても「補助シート№2（部門別粗利）」及び「補助シート№3（人員計画）」"]
[null,null,"を使用することにより、精度の高い合理的な計画を策定することが可能となります。"]
[4,".","「入力シート№1・2」への入力が終われば、「経営改善計画書」は完成しますが、ご提出いただく前に、重点取組"]
[null,null,"項目との整合性や、実現可能性（過去の実績や業界動向等を踏まえたものとなっているか）について、最終確"]
[null,null,"認をしてください。"]

{"sheet":"表紙","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,5,13,9],[14,1,14,6],[9,2,9,4],[3,0,3,14],[9,6,9,8]]}
[]
[]
[]
["経 営 改 善 計 画 書"]
[]
[null,null,null,null,"（","計画期間",{"$f":"入力シート№1!G8","v":"1/期"},"～",{"$f":"入力シート№1!P8","v":"10/期"},"　　　）"]
[]
[]
[]
[null,null,null,null,null,"作成日",{"$f":"印刷及び基本項目入力!E30","v":"00:00:00"}]
[]
[]
[null,null,null,null,null,{"$f":"印刷及び基本項目入力!E26","v":0}]

{"sheet":"現状分析および重点取組項目","index":3,"n_rows":31,"n_cols":21,"rows_kept":31,"cut":false,"hidden":false,"merged":[[18,14,18,20],[11,14,11,20],[12,14,12,20],[13,14,13,20],[14,14,14,20],[15,14,15,20],[16,14,16,20],[17,14,17,20],[28,1,28,3],[28,4,28,6],[29,1,29,3],[29,4,29,6],[7,5,7,12],[8,5,8,12],[9,5,9,12],[10,5,10,12],[11,5,11,12],[12,5,12,12],[13,5,13,12],[14,5,14,12],[15,5,15,12],[16,5,16,12],[17,5,17,12],[18,5,18,12],[22,7,23,7],[24,1,24,3],[24,4,24,6],[25,1,25,3],[27,1,27,3],[27,4,27,6],[30,1,30,3],[30,4,30,6],[15,4,18,4],[0,0,0,2],[0,3,0,5],[4,0,4,12],[5,0,10,3],[5,4,7,4],[8,4,10,4],[11,0,18,3],[25,4,25,6],[26,1,26,3],[26,4,26,6],[22,4,23,6],[22,0,23,3],[22,8,23,8],[0,19,0,20],[1,0,1,2],[1,3,1,5],[2,0,2,20],[21,8,21,20],[21,0,21,7],[11,4,14,4],[4,14,4,20],[5,5,5,12],[6,5,6,12],[5,14,5,20],[6,14,6,20],[7,14,7,20],[8,14,8,20],[9,14,9,20],[10,14,10,20]]}
["会社名:",null,null,{"$f":"印刷及び基本項目入力!E26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"作成日：",{"$f":"印刷及び基本項目入力!E30","v":"00:00:00"}]
["取引支店名:",null,null,{"$f":"印刷及び基本項目入力!E28","v":0}]
["現状分析および重点取組項目"]
[]
["現状分析",null,null,null,null,null,null,null,null,null,null,null,null,null,"改善戦略・改善目標"]
["外部環境\n（自社にとっての\n機会・脅威）",null,null,null,"機会"]
[]
[]
[null,null,null,null,"脅威"]
[]
[]
["内部環境\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,null,null,null,null,null,"取組効果（数値計画等）"]
["項目",null,null,null,"具体的取組み",null,null,"実施\n時期","該当\n科目等",{"$f":"経営改善計画書!H9","v":"-1/期"},{"$f":"経営改善計画書!I9","v":"/期"},{"$f":"経営改善計画書!J9","v":"1/期"},{"$f":"経営改善計画書!K9","v":"2/期"},{"$f":"経営改善計画書!L9","v":"3/期"},{"$f":"経営改善計画書!M9","v":"4/期"},{"$f":"経営改善計画書!N9","v":"5/期"},{"$f":"経営改善計画書!O9","v":"6/期"},{"$f":"経営改善計画書!P9","v":"7/期"},{"$f":"経営改善計画書!Q9","v":"8/期"},{"$f":"経営改善計画書!R9","v":"9/期"},{"$f":"経営改善計画書!S9","v":"10/期"}]
[null,null,null,null,null,null,null,null,null,"実績","実績","計画1","計画2","計画3","計画4","計画5","計画6","計画7","計画8","計画9","計画10"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]

{"sheet":"経営改善計画書","index":4,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":false,"merged":[[30,0,35,1],[33,2,33,5],[39,2,39,5],[37,0,44,1],[30,2,30,5],[31,2,31,5],[32,2,32,5],[40,2,40,5],[34,2,34,5],[35,2,35,5],[44,2,44,5],[43,2,43,5],[42,2,42,5],[41,2,41,5],[38,2,38,5],[37,2,37,5],[10,0,28,1],[10,2,10,5],[12,2,12,5],[11,2,11,5],[14,2,14,5],[28,2,28,5],[27,2,27,5],[20,4,20,5],[13,4,13,5],[26,2,26,5],[25,2,25,5],[24,2,24,5],[23,2,23,5],[21,2,21,5],[1,6,1,9],[2,6,2,9],[1,17,1,18],[22,4,22,5],[19,2,19,5],[18,2,18,5],[15,4,15,5],[16,2,16,5],[5,10,6,12],[17,4,17,5]]}
[]
[null,null,null,null,null,"会社名：",{"$f":"印刷及び基本項目入力!E26","v":0},null,null,null,null,null,null,null,null,null,"作成日：",{"$f":"印刷及び基本項目入力!E30","v":"00:00:00"}]
[null,null,null,null,null,"取引支店名：",{"$f":"印刷及び基本項目入力!E28","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,"単位：",{"$f":"入力シート№1!P6","v":""}]
[null,null,null,null,null,null,{"$f":"+入力シート№1!D8","v":"-2/期"},{"$f":"+入力シート№1!E8","v":"-1/期"},{"$f":"+入力シート№1!F8","v":"/期"},{"$f":"+入力シート№1!G8","v":"1/期"},{"$f":"+入力シート№1!H8","v":"2/期"},{"$f":"+入力シート№1!I8","v":"3/期"},{"$f":"+入力シート№1!J8","v":"4/期"},{"$f":"+入力シート№1!K8","v":"5/期"},{"$f":"+入力シート№1!L8","v":"6/期"},{"$f":"+入力シート№1!M8","v":"7/期"},{"$f":"+入力シート№1!N8","v":"8/期"},{"$f":"+入力シート№1!O8","v":"9/期"},{"$f":"+入力シート№1!P8","v":"10/期"}]
[null,null,null,null,null,null,"実績","実績","実績","計画1","計画2","計画3","計画4","計画5","計画6","計画7","計画8","計画9","計画10"]
["損益計算書",null,"売上高",null,null,null,{"$f":"+入力シート№1!D10","v":0},{"$f":"+入力シート№1!E10","v":0},{"$f":"+入力シート№1!F10","v":0},{"$f":"+入力シート№1!G10","v":0},{"$f":"+入力シート№1!H10","v":0},{"$f":"+入力シート№1!I10","v":0},{"$f":"+入力シート№1!J10","v":0},{"$f":"+入力シート№1!K10","v":0},{"$f":"+入力シート№1!L10","v":0},{"$f":"+入力シート№1!M10","v":0},{"$f":"+入力シート№1!N10","v":0},{"$f":"+入力シート№1!O10","v":0},{"$f":"+入力シート№1!P10","v":0}]
[null,null,"売上原価",null,null,null,{"$f":"+入力シート№1!D16","v":0},{"$f":"+入力シート№1!E16","v":0},{"$f":"+入力シート№1!F16","v":0},{"$f":"+入力シート№1!G16","v":0},{"$f":"+入力シート№1!H16","v":0},{"$f":"+入力シート№1!I16","v":0},{"$f":"+入力シート№1!J16","v":0},{"$f":"+入力シート№1!K16","v":0},{"$f":"+入力シート№1!L16","v":0},{"$f":"+入力シート№1!M16","v":0},{"$f":"+入力シート№1!N16","v":0},{"$f":"+入力シート№1!O16","v":0},{"$f":"+入力シート№1!P16","v":0}]
[null,null,"売上総利益",null,null,null,{"$f":"入力シート№1!D29","v":0},{"$f":"入力シート№1!E29","v":0},{"$f":"入力シート№1!F29","v":0},{"$f":"入力シート№1!G29","v":0},{"$f":"入力シート№1!H29","v":0},{"$f":"入力シート№1!I29","v":0},{"$f":"入力シート№1!J29","v":0},{"$f":"入力シート№1!K29","v":0},{"$f":"入力シート№1!L29","v":0},{"$f":"入力シート№1!M29","v":0},{"$f":"入力シート№1!N29","v":0},{"$f":"入力シート№1!O29","v":0},{"$f":"入力シート№1!P29","v":0}]
[null,null,null,null,"（同利益率）",null,{"$f":"IF(G11>0,+G13/G11,\"\")","v":""},{"$f":"IF(H11>0,+H13/H11,\"\")","v":""},"","","","","","",{"$f":"IF(O11>0,+O13/O11,\"\")","v":""},{"$f":"IF(P11>0,+P13/P11,\"\")","v":""},{"$f":"IF(Q11>0,+Q13/Q11,\"\")","v":""},{"$f":"IF(R11>0,+R13/R11,\"\")","v":""},{"$f":"IF(S11>0,+S13/S11,\"\")","v":""}]
[null,null,"販売費及び一般管理費",null,null,null,{"$f":"+入力シート№1!D32","v":0},{"$f":"+入力シート№1!E32","v":0},{"$f":"+入力シート№1!F32","v":0},{"$f":"+入力シート№1!G32","v":0},{"$f":"+入力シート№1!H32","v":0},{"$f":"+入力シート№1!I32","v":0},{"$f":"+入力シート№1!J32","v":0},{"$f":"+入力シート№1!K32","v":0},{"$f":"+入力シート№1!L32","v":0},{"$f":"+入力シート№1!M32","v":0},{"$f":"+入力シート№1!N32","v":0},{"$f":"+入力シート№1!O32","v":0},{"$f":"+入力シート№1!P32","v":0}]
[null,null,null,null,"（うち人件費）",null,{"$f":"+入力シート№1!D37","v":0},{"$f":"+入力シート№1!E37","v":0},{"$f":"+入力シート№1!F37","v":0},{"$f":"+入力シート№1!G37","v":0},{"$f":"+入力シート№1!H37","v":0},{"$f":"+入力シート№1!I37","v":0},{"$f":"+入力シート№1!J37","v":0},{"$f":"+入力シート№1!K37","v":0},{"$f":"+入力シート№1!L37","v":0},{"$f":"+入力シート№1!M37","v":0},{"$f":"+入力シート№1!N37","v":0},{"$f":"+入力シート№1!O37","v":0},{"$f":"+入力シート№1!P37","v":0}]
[null,null,"営業利益",null,null,null,{"$f":"+G13-G15","v":0},{"$f":"+H13-H15","v":0},0,0,{"$f":"+K13-K15","v":0},0,0,0,{"$f":"+O13-O15","v":0},{"$f":"+P13-P15","v":0},{"$f":"+Q13-Q15","v":0},{"$f":"+R13-R15","v":0},{"$f":"+S13-S15","v":0}]
[null,null,null,null,"（同利益率）",null,{"$f":"IF(G11>0,+G17/G11,\"\")","v":""},{"$f":"IF(H11>0,+H17/H11,\"\")","v":""},"","","","","","",{"$f":"IF(O11>0,+O17/O11,\"\")","v":""},{"$f":"IF(P11>0,+P17/P11,\"\")","v":""},{"$f":"IF(Q11>0,+Q17/Q11,\"\")","v":""},{"$f":"IF(R11>0,+R17/R11,\"\")","v":""},{"$f":"IF(S11>0,+S17/S11,\"\")","v":""}]
[null,null,"営業外収益",null,null,null,{"$f":"+入力シート№2!E10","v":0},{"$f":"+入力シート№2!F10","v":0},{"$f":"+入力シート№2!G10","v":0},{"$f":"+入力シート№2!H10","v":0},{"$f":"+入力シート№2!I10","v":0},{"$f":"+入力シート№2!J10","v":0},{"$f":"+入力シート№2!K10","v":0},{"$f":"+入力シート№2!L10","v":0},{"$f":"+入力シート№2!M10","v":0},{"$f":"+入力シート№2!N10","v":0},{"$f":"+入力シート№2!O10","v":0},{"$f":"+入力シート№2!P10","v":0},{"$f":"+入力シート№2!Q10","v":0}]
[null,null,"営業外費用",null,null,null,{"$f":"+入力シート№2!E14","v":0},{"$f":"+入力シート№2!F14","v":0},{"$f":"+入力シート№2!G14","v":0},{"$f":"+入力シート№2!H14","v":0},{"$f":"+入力シート№2!I14","v":0},{"$f":"+入力シート№2!J14","v":0},{"$f":"+入力シート№2!K14","v":0},{"$f":"+入力シート№2!L14","v":0},{"$f":"+入力シート№2!M14","v":0},{"$f":"+入力シート№2!N14","v":0},{"$f":"+入力シート№2!O14","v":0},{"$f":"+入力シート№2!P14","v":0},{"$f":"+入力シート№2!Q14","v":0}]
[null,null,null,null,"（うち支払利息）",null,{"$f":"+入力シート№2!E15","v":0},{"$f":"+入力シート№2!F15","v":0},{"$f":"+入力シート№2!G15","v":0},{"$f":"+入力シート№2!H15","v":0},{"$f":"+入力シート№2!I15","v":0},{"$f":"+入力シート№2!J15","v":0},{"$f":"+入力シート№2!K15","v":0},{"$f":"+入力シート№2!L15","v":0},{"$f":"+入力シート№2!M15","v":0},{"$f":"+入力シート№2!N15","v":0},{"$f":"+入力シート№2!O15","v":0},{"$f":"+入力シート№2!P15","v":0},{"$f":"+入力シート№2!Q15","v":0}]
[null,null,"経常利益",null,null,null,{"$f":"+入力シート№2!E19","v":0},{"$f":"+入力シート№2!F19","v":0},{"$f":"+入力シート№2!G19","v":0},{"$f":"+入力シート№2!H19","v":0},{"$f":"+入力シート№2!I19","v":0},{"$f":"+入力シート№2!J19","v":0},{"$f":"+入力シート№2!K19","v":0},{"$f":"+入力シート№2!L19","v":0},{"$f":"+入力シート№2!M19","v":0},{"$f":"+入力シート№2!N19","v":0},{"$f":"+入力シート№2!O19","v":0},{"$f":"+入力シート№2!P19","v":0},{"$f":"+入力シート№2!Q19","v":0}]
[null,null,null,null,"（同利益率）",null,{"$f":"IF(G11>0,+G22/G11,\"\")","v":""},{"$f":"IF(H11>0,+H22/H11,\"\")","v":""},"","","","","","",{"$f":"IF(O11>0,+O22/O11,\"\")","v":""},{"$f":"IF(P11>0,+P22/P11,\"\")","v":""},{"$f":"IF(Q11>0,+Q22/Q11,\"\")","v":""},{"$f":"IF(R11>0,+R22/R11,\"\")","v":""},{"$f":"IF(S11>0,+S22/S11,\"\")","v":""}]
[null,null,"特別利益",null,null,null,{"$f":"+入力シート№2!E22","v":0},{"$f":"+入力シート№2!F22","v":0},{"$f":"+入力シート№2!G22","v":0},{"$f":"+入力シート№2!H22","v":0},{"$f":"+入力シート№2!I22","v":0},{"$f":"+入力シート№2!J22","v":0},{"$f":"+入力シート№2!K22","v":0},{"$f":"+入力シート№2!L22","v":0},{"$f":"+入力シート№2!M22","v":0},{"$f":"+入力シート№2!N22","v":0},{"$f":"+入力シート№2!O22","v":0},{"$f":"+入力シート№2!P22","v":0},{"$f":"+入力シート№2!Q22","v":0}]
[null,null,"特別損失",null,null,null,{"$f":"+入力シート№2!E26","v":0},{"$f":"+入力シート№2!F26","v":0},{"$f":"+入力シート№2!G26","v":0},{"$f":"+入力シート№2!H26","v":0},{"$f":"+入力シート№2!I26","v":0},{"$f":"+入力シート№2!J26","v":0},{"$f":"+入力シート№2!K26","v":0},{"$f":"+入力シート№2!L26","v":0},{"$f":"+入力シート№2!M26","v":0},{"$f":"+入力シート№2!N26","v":0},{"$f":"+入力シート№2!O26","v":0},{"$f":"+入力シート№2!P26","v":0},{"$f":"+入力シート№2!Q26","v":0}]
[null,null,"税引前当期利益",null,null,null,{"$f":"+G22+G24-G25","v":0},0,0,0,0,0,0,0,{"$f":"+O22+O24-O25","v":0},{"$f":"+P22+P24-P25","v":0},{"$f":"+Q22+Q24-Q25","v":0},{"$f":"+R22+R24-R25","v":0},{"$f":"+S22+S24-S25","v":0}]
[null,null,"法人税等",null,null,null,{"$f":"+入力シート№2!E33","v":0},{"$f":"+入力シート№2!F33","v":0},{"$f":"+入力シート№2!G33","v":0},{"$f":"+入力シート№2!H33","v":0},{"$f":"+入力シート№2!I33","v":0},{"$f":"+入力シート№2!J33","v":0},{"$f":"+入力シート№2!K33","v":0},{"$f":"+入力シート№2!L33","v":0},{"$f":"+入力シート№2!M33","v":0},{"$f":"+入力シート№2!N33","v":0},{"$f":"+入力シート№2!O33","v":0},{"$f":"+入力シート№2!P33","v":0},{"$f":"+入力シート№2!Q33","v":0}]
[null,null,"当期利益",null,null,null,{"$f":"+入力シート№2!E59","v":0},{"$f":"+入力シート№2!F59","v":0},{"$f":"+入力シート№2!G59","v":0},{"$f":"+入力シート№2!H59","v":0},{"$f":"+入力シート№2!I59","v":0},{"$f":"+入力シート№2!J59","v":0},{"$f":"+入力シート№2!K59","v":0},{"$f":"+入力シート№2!L59","v":0},{"$f":"+入力シート№2!M59","v":0},{"$f":"+入力シート№2!N59","v":0},{"$f":"+入力シート№2!O59","v":0},{"$f":"+入力シート№2!P59","v":0},{"$f":"+入力シート№2!Q59","v":0}]
[null,null,"（減価償却費）",null,null,null,{"$f":"+入力シート№1!D46+入力シート№1!D24","v":0},{"$f":"+入力シート№1!E46+入力シート№1!E24","v":0},{"$f":"+入力シート№1!F46+入力シート№1!F24","v":0},{"$f":"+入力シート№1!G46+入力シート№1!G24","v":0},{"$f":"+入力シート№1!H46+入力シート№1!H24","v":0},{"$f":"+入力シート№1!I46+入力シート№1!I24","v":0},{"$f":"+入力シート№1!J46+入力シート№1!J24","v":0},{"$f":"+入力シート№1!K46+入力シート№1!K24","v":0},{"$f":"+入力シート№1!L46+入力シート№1!L24","v":0},{"$f":"+入力シート№1!M46+入力シート№1!M24","v":0},{"$f":"+入力シート№1!N46+入力シート№1!N24","v":0},{"$f":"+入力シート№1!O46+入力シート№1!O24","v":0},{"$f":"+入力シート№1!P46+入力シート№1!P24","v":0}]
[]
["簡易CF",null,"償却前経常利益",null,null,null,{"$f":"+G22+G29","v":0},0,0,0,{"$f":"+K22+K29","v":0},0,0,0,{"$f":"+O22+O29","v":0},{"$f":"+P22+P29","v":0},{"$f":"+Q22+Q29","v":0},{"$f":"+R22+R29","v":0},{"$f":"+S22+S29","v":0}]
[null,null,"法人税等",null,null,null,{"$f":"+G27","v":0},0,0,0,{"$f":"+K27","v":0},0,0,0,{"$f":"+O27","v":0},{"$f":"+P27","v":0},{"$f":"+Q27","v":0},{"$f":"+R27","v":0},{"$f":"+S27","v":0}]
[null,null,"設備投資",null,null,null,{"$f":"+入力シート№2!E35","v":0},{"$f":"+入力シート№2!F35","v":0},{"$f":"+入力シート№2!G35","v":0},{"$f":"+入力シート№2!H35","v":0},{"$f":"+入力シート№2!I35","v":0},{"$f":"+入力シート№2!J35","v":0},{"$f":"+入力シート№2!K35","v":0},{"$f":"+入力シート№2!L35","v":0},{"$f":"+入力シート№2!M35","v":0},{"$f":"+入力シート№2!N35","v":0},{"$f":"+入力シート№2!O35","v":0},{"$f":"+入力シート№2!P35","v":0},{"$f":"+入力シート№2!Q35","v":0}]
[null,null,"資産売却/増資",null,null,null,{"$f":"入力シート№2!E39","v":0},{"$f":"入力シート№2!F39","v":0},{"$f":"入力シート№2!G39","v":0},{"$f":"入力シート№2!H39","v":0},{"$f":"入力シート№2!I39","v":0},{"$f":"入力シート№2!J39","v":0},{"$f":"入力シート№2!K39","v":0},{"$f":"入力シート№2!L39","v":0},{"$f":"入力シート№2!M39","v":0},{"$f":"入力シート№2!N39","v":0},{"$f":"入力シート№2!O39","v":0},{"$f":"入力シート№2!P39","v":0},{"$f":"入力シート№2!Q39","v":0}]
[null,null,"借入金増減",null,null,null,{"$f":"SUM(入力シート№2!E42,IF(入力シート№2!E43>0,-入力シート№2!E43,入力シート№2!E43),入力シート№2!E45,IF(入力シート№2!E46>0,-入力シート№2!E46,入力シート№2!E46),IF(入力シート№2!E47>0,-入力シート№2!E47,入力シート№2!E47))","v":0},{"$f":"SUM(入力シート№2!F42,IF(入力シート№2!F43>0,-入力シート№2!F43,入力シート№2!F43),入力シート№2!F45,IF(入力シート№2!F46>0,-入力シート№2!F46,入力シート№2!F46),IF(入力シート№2!F47>0,-入力シート№2!F47,入力シート№2!F47))","v":0},{"$f":"SUM(入力シート№2!G42,IF(入力シート№2!G43>0,-入力シート№2!G43,入力シート№2!G43),入力シート№2!G45,IF(入力シート№2!G46>0,-入力シート№2!G46,入力シート№2!G46),IF(入力シート№2!G47>0,-入力シート№2!G47,入力シート№2!G47))","v":0},{"$f":"SUM(入力シート№2!H42,IF(入力シート№2!H43>0,-入力シート№2!H43,入力シート№2!H43),入力シート№2!H45,IF(入力シート№2!H46>0,-入力シート№2!H46,入力シート№2!H46),IF(入力シート№2!H47>0,-入力シート№2!H47,入力シート№2!H47))","v":0},{"$f":"SUM(入力シート№2!I42,IF(入力シート№2!I43>0,-入力シート№2!I43,入力シート№2!I43),入力シート№2!I45,IF(入力シート№2!I46>0,-入力シート№2!I46,入力シート№2!I46),IF(入力シート№2!I47>0,-入力シート№2!I47,入力シート№2!I47))","v":0},{"$f":"SUM(入力シート№2!J42,IF(入力シート№2!J43>0,-入力シート№2!J43,入力シート№2!J43),入力シート№2!J45,IF(入力シート№2!J46>0,-入力シート№2!J46,入力シート№2!J46),IF(入力シート№2!J47>0,-入力シート№2!J47,入力シート№2!J47))","v":0},{"$f":"SUM(入力シート№2!K42,IF(入力シート№2!K43>0,-入力シート№2!K43,入力シート№2!K43),入力シート№2!K45,IF(入力シート№2!K46>0,-入力シート№2!K46,入力シート№2!K46),IF(入力シート№2!K47>0,-入力シート№2!K47,入力シート№2!K47))","v":0},{"$f":"SUM(入力シート№2!L42,IF(入力シート№2!L43>0,-入力シート№2!L43,入力シート№2!L43),入力シート№2!L45,IF(入力シート№2!L46>0,-入力シート№2!L46,入力シート№2!L46),IF(入力シート№2!L47>0,-入力シート№2!L47,入力シート№2!L47))","v":0},{"$f":"SUM(入力シート№2!M42,IF(入力シート№2!M43>0,-入力シート№2!M43,入力シート№2!M43),入力シート№2!M45,IF(入力シート№2!M46>0,-入力シート№2!M46,入力シート№2!M46),IF(入力シート№2!M47>0,-入力シート№2!M47,入力シート№2!M47))","v":0},{"$f":"SUM(入力シート№2!N42,IF(入力シート№2!N43>0,-入力シート№2!N43,入力シート№2!N43),入力シート№2!N45,IF(入力シート№2!N46>0,-入力シート№2!N46,入力シート№2!N46),IF(入力シート№2!N47>0,-入力シート№2!N47,入力シート№2!N47))","v":0},{"$f":"SUM(入力シート№2!O42,IF(入力シート№2!O43>0,-入力シート№2!O43,入力シート№2!O43),入力シート№2!O45,IF(入力シート№2!O46>0,-入力シート№2!O46,入力シート№2!O46),IF(入力シート№2!O47>0,-入力シート№2!O47,入力シート№2!O47))","v":0},{"$f":"SUM(入力シート№2!P42,IF(入力シート№2!P43>0,-入力シート№2!P43,入力シート№2!P43),入力シート№2!P45,IF(入力シート№2!P46>0,-入力シート№2!P46,入力シート№2!P46),IF(入力シート№2!P47>0,-入力シート№2!P47,入力シート№2!P47))","v":0},{"$f":"SUM(入力シート№2!Q42,IF(入力シート№2!Q43>0,-入力シート№2!Q43,入力シート№2!Q43),入力シート№2!Q45,IF(入力シート№2!Q46>0,-入力シート№2!Q46,入力シート№2!Q46),IF(入力シート№2!Q47>0,-入力シート№2!Q47,入力シート№2!Q47))","v":0}]
[null,null,"CF余力",null,null,null,{"$f":"+G31-G32-G33+G34+G35","v":0},{"$f":"+H31-H32-H33+H34+H35","v":0},0,0,0,{"$f":"+L31-L32-L33+L34+L35","v":0},0,0,{"$f":"+O31-O32-O33+O34+O35","v":0},{"$f":"+P31-P32-P33+P34+P35","v":0},{"$f":"+Q31-Q32-Q33+Q34+Q35","v":0},{"$f":"+R31-R32-R33+R34+R35","v":0},{"$f":"+S31-S32-S33+S34+S35","v":0}]
[]
["指標分析",null,"売上高増加率",null,null,null,null,{"$f":"IF(ISERROR(+H11/G11-1),\"\",+H11/G11-1)","v":""},"","",{"$f":"IF(ISERROR(+K11/J11-1),\"\",+K11/J11-1)","v":""},{"$f":"IF(ISERROR(+L11/K11-1),\"\",+L11/K11-1)","v":""},"","",{"$f":"IF(ISERROR(+O11/N11-1),\"\",+O11/N11-1)","v":""},{"$f":"IF(ISERROR(+P11/O11-1),\"\",+P11/O11-1)","v":""},{"$f":"IF(ISERROR(+Q11/P11-1),\"\",+Q11/P11-1)","v":""},{"$f":"IF(ISERROR(+R11/Q11-1),\"\",+R11/Q11-1)","v":""},{"$f":"IF(ISERROR(+S11/R11-1),\"\",+S11/R11-1)","v":""}]
[null,null,"売上高総利益率",null,null,null,{"$f":"+G14","v":""},{"$f":"+H14","v":""},"","",{"$f":"+K14","v":""},"","","",{"$f":"+O14","v":""},{"$f":"+P14","v":""},{"$f":"+Q14","v":""},{"$f":"+R14","v":""},{"$f":"+S14","v":""}]
[null,null,"売上高営業利益率",null,null,null,{"$f":"G18","v":""},{"$f":"H18","v":""},"","","","","","",{"$f":"O18","v":""},{"$f":"P18","v":""},{"$f":"Q18","v":""},{"$f":"R18","v":""},{"$f":"S18","v":""}]
[null,null,"売上高経常利益率",null,null,null,{"$f":"G23","v":""},{"$f":"H23","v":""},"","","","","","",{"$f":"O23","v":""},{"$f":"P23","v":""},{"$f":"Q23","v":""},{"$f":"R23","v":""},{"$f":"S23","v":""}]
[null,null,"売上高販管費比率",null,null,null,{"$f":"IF(G11>0,G15/G11,\"\")","v":""},{"$f":"IF(H11>0,H15/H11,\"\")","v":""},"","",{"$f":"IF(K11>0,K15/K11,\"\")","v":""},"","","",{"$f":"IF(O11>0,O15/O11,\"\")","v":""},{"$f":"IF(P11>0,P15/P11,\"\")","v":""},{"$f":"IF(Q11>0,Q15/Q11,\"\")","v":""},{"$f":"IF(R11>0,R15/R11,\"\")","v":""},{"$f":"IF(S11>0,S15/S11,\"\")","v":""}]
[null,null,"売上高人件費比率",null,null,null,{"$f":"IF(G11>0,(入力シート№1!D18+入力シート№1!D37)/G11,\"\")","v":""},{"$f":"IF(H11>0,(入力シート№1!E18+入力シート№1!E37)/H11,\"\")","v":""},{"$f":"IF(I11>0,(入力シート№1!F18+入力シート№1!F37)/I11,\"\")","v":""},{"$f":"IF(J11>0,(入力シート№1!G18+入力シート№1!G37)/J11,\"\")","v":""},{"$f":"IF(K11>0,(入力シート№1!H18+入力シート№1!H37)/K11,\"\")","v":""},{"$f":"IF(L11>0,(入力シート№1!I18+入力シート№1!I37)/L11,\"\")","v":""},{"$f":"IF(M11>0,(入力シート№1!J18+入力シート№1!J37)/M11,\"\")","v":""},{"$f":"IF(N11>0,(入力シート№1!K18+入力シート№1!K37)/N11,\"\")","v":""},{"$f":"IF(O11>0,(入力シート№1!L18+入力シート№1!L37)/O11,\"\")","v":""},{"$f":"IF(P11>0,(入力シート№1!M18+入力シート№1!M37)/P11,\"\")","v":""},{"$f":"IF(Q11>0,(入力シート№1!N18+入力シート№1!N37)/Q11,\"\")","v":""},{"$f":"IF(R11>0,(入力シート№1!O18+入力シート№1!O37)/R11,\"\")","v":""},{"$f":"IF(S11>0,(入力シート№1!P18+入力シート№1!P37)/S11,\"\")","v":""}]
[null,null,"一人当たり売上高",null,null,null,null,{"$f":"IF(ISERROR(+H11/(入力シート№2!F49+入力シート№2!E49)*2),\"\",+H11/(入力シート№2!F49+入力シート№2!E49)*2)","v":""},{"$f":"IF(ISERROR(+I11/(入力シート№2!G49+入力シート№2!F49)*2),\"\",+I11/(入力シート№2!G49+入力シート№2!F49)*2)","v":""},{"$f":"IF(ISERROR(+J11/(入力シート№2!H49+入力シート№2!G49)*2),\"\",+J11/(入力シート№2!H49+入力シート№2!G49)*2)","v":""},{"$f":"IF(ISERROR(+K11/(入力シート№2!I49+入力シート№2!H49)*2),\"\",+K11/(入力シート№2!I49+入力シート№2!H49)*2)","v":""},{"$f":"IF(ISERROR(+L11/(入力シート№2!J49+入力シート№2!I49)*2),\"\",+L11/(入力シート№2!J49+入力シート№2!I49)*2)","v":""},{"$f":"IF(ISERROR(+M11/(入力シート№2!K49+入力シート№2!J49)*2),\"\",+M11/(入力シート№2!K49+入力シート№2!J49)*2)","v":""},{"$f":"IF(ISERROR(+N11/(入力シート№2!L49+入力シート№2!K49)*2),\"\",+N11/(入力シート№2!L49+入力シート№2!K49)*2)","v":""},{"$f":"IF(ISERROR(+O11/(入力シート№2!M49+入力シート№2!L49)*2),\"\",+O11/(入力シート№2!M49+入力シート№2!L49)*2)","v":""},{"$f":"IF(ISERROR(+P11/(入力シート№2!N49+入力シート№2!M49)*2),\"\",+P11/(入力シート№2!N49+入力シート№2!M49)*2)","v":""},{"$f":"IF(ISERROR(+Q11/(入力シート№2!O49+入力シート№2!N49)*2),\"\",+Q11/(入力シート№2!O49+入力シート№2!N49)*2)","v":""},{"$f":"IF(ISERROR(+R11/(入力シート№2!P49+入力シート№2!O49)*2),\"\",+R11/(入力シート№2!P49+入力シート№2!O49)*2)","v":""},{"$f":"IF(ISERROR(+S11/(入力シート№2!Q49+入力シート№2!P49)*2),\"\",+S11/(入力シート№2!Q49+入力シート№2!P49)*2)","v":""}]
[null,null,"一人当たり人件費",null,null,null,null,{"$f":"IF(ISERROR(+(入力シート№1!E18+入力シート№1!E37)/(入力シート№2!F49+入力シート№2!E49)*2),\"\",+(入力シート№1!E18+入力シート№1!E37)/(入力シート№2!F49+入力シート№2!E49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!F18+入力シート№1!F37)/(入力シート№2!G49+入力シート№2!F49)*2),\"\",+(入力シート№1!F18+入力シート№1!F37)/(入力シート№2!G49+入力シート№2!F49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!G18+入力シート№1!G37)/(入力シート№2!H49+入力シート№2!G49)*2),\"\",+(入力シート№1!G18+入力シート№1!G37)/(入力シート№2!H49+入力シート№2!G49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!H18+入力シート№1!H37)/(入力シート№2!I49+入力シート№2!H49)*2),\"\",+(入力シート№1!H18+入力シート№1!H37)/(入力シート№2!I49+入力シート№2!H49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!I18+入力シート№1!I37)/(入力シート№2!J49+入力シート№2!I49)*2),\"\",+(入力シート№1!I18+入力シート№1!I37)/(入力シート№2!J49+入力シート№2!I49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!J18+入力シート№1!J37)/(入力シート№2!K49+入力シート№2!J49)*2),\"\",+(入力シート№1!J18+入力シート№1!J37)/(入力シート№2!K49+入力シート№2!J49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!K18+入力シート№1!K37)/(入力シート№2!L49+入力シート№2!K49)*2),\"\",+(入力シート№1!K18+入力シート№1!K37)/(入力シート№2!L49+入力シート№2!K49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!L18+入力シート№1!L37)/(入力シート№2!M49+入力シート№2!L49)*2),\"\",+(入力シート№1!L18+入力シート№1!L37)/(入力シート№2!M49+入力シート№2!L49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!M18+入力シート№1!M37)/(入力シート№2!N49+入力シート№2!M49)*2),\"\",+(入力シート№1!M18+入力シート№1!M37)/(入力シート№2!N49+入力シート№2!M49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!N18+入力シート№1!N37)/(入力シート№2!O49+入力シート№2!N49)*2),\"\",+(入力シート№1!N18+入力シート№1!N37)/(入力シート№2!O49+入力シート№2!N49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!O18+入力シート№1!O37)/(入力シート№2!P49+入力シート№2!O49)*2),\"\",+(入力シート№1!O18+入力シート№1!O37)/(入力シート№2!P49+入力シート№2!O49)*2)","v":""},{"$f":"IF(ISERROR(+(入力シート№1!P18+入力シート№1!P37)/(入力シート№2!Q49+入力シート№2!P49)*2),\"\",+(入力シート№1!P18+入力シート№1!P37)/(入力シート№2!Q49+入力シート№2!P49)*2)","v":""}]

{"sheet":"入力シート№1","index":5,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[[41,1,41,2],[40,1,40,2],[39,1,39,2],[49,1,49,2],[42,1,42,2],[46,1,46,2],[45,1,45,2],[44,1,44,2],[43,1,43,2],[1,14,1,15],[16,1,16,2],[18,1,18,2],[17,1,17,2],[3,0,3,1],[3,2,3,3],[1,3,1,5],[2,3,2,5],[29,1,29,2],[34,1,34,2],[33,1,33,2],[36,1,36,2],[38,1,38,2],[37,1,37,2],[32,1,32,2],[35,1,35,2],[19,1,19,2],[22,1,22,2],[26,1,26,2],[25,1,25,2],[24,1,24,2],[23,1,23,2],[21,1,21,2],[20,1,20,2]]}
[]
[null,null,"会社名：",{"$f":"印刷及び基本項目入力!E26","v":0},null,null,null,null,null,null,null,null,null,"作成日：",{"$f":"印刷及び基本項目入力!E30","v":"00:00:00"}]
[null,null,"取引支店名：",{"$f":"印刷及び基本項目入力!E28","v":0},null,null,null,null,"入力シート  №1"]
[]
[]
["【売上計画】",null,null,null,null,null,null,null,null,null,null,null,null,null,"単位：",{"$f":"IF(印刷及び基本項目入力!$E$32=0,\"\",印刷及び基本項目入力!$E$32)","v":""}]
[]
[null,null,null,{"$f":"印刷及び基本項目入力!$F$34-2&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-2/期"},{"$f":"印刷及び基本項目入力!$F$34-1&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-1/期"},{"$f":"印刷及び基本項目入力!$F$34&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"/期"},{"$f":"印刷及び基本項目入力!$F$34+1&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"1/期"},{"$f":"印刷及び基本項目入力!$F$34+2&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"2/期"},{"$f":"印刷及び基本項目入力!$F$34+3&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"3/期"},{"$f":"印刷及び基本項目入力!$F$34+4&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"4/期"},{"$f":"印刷及び基本項目入力!$F$34+5&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"5/期"},{"$f":"印刷及び基本項目入力!$F$34+6&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"6/期"},{"$f":"印刷及び基本項目入力!$F$34+7&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"7/期"},{"$f":"印刷及び基本項目入力!$F$34+8&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"8/期"},{"$f":"印刷及び基本項目入力!$F$34+9&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"9/期"},{"$f":"印刷及び基本項目入力!$F$34+10&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"10/期"}]
[null,null,null,"実績","実績","実績","計画1","計画2","計画3","計画4","計画5","計画6","計画7","計画8","計画9","計画10"]
["売上高",null,null,{"$f":"SUM(D11:D14)","v":0},0,0,0,{"$f":"SUM(H11:H14)","v":0},0,0,0,{"$f":"SUM(L11:L14)","v":0},{"$f":"SUM(M11:M14)","v":0},{"$f":"SUM(N11:N14)","v":0},{"$f":"SUM(O11:O14)","v":0},{"$f":"SUM(P11:P14)","v":0}]
[null,null,"部門"]
[null,null,"部門"]
[null,null,"部門"]
[null,null,"部門"]
["【売上原価計画】"]
["売上原価",null,null,{"$f":"SUM(D17:D27)","v":0},{"$f":"SUM(E17:E27)","v":0},0,0,{"$f":"SUM(H17:H27)","v":0},0,0,0,{"$f":"SUM(L17:L27)","v":0},{"$f":"SUM(M17:M27)","v":0},{"$f":"SUM(N17:N27)","v":0},{"$f":"SUM(O17:O27)","v":0},{"$f":"SUM(P17:P27)","v":0}]
[null,"材料費"]
[null,"労務費"]
[null,"外注加工費"]
[null,"燃料費・動力費"]
[null,"荷造運送費"]
[null,"賃借・リース料"]
[null,"租税公課"]
[null,"減価償却費"]
[null,"その他"]
[null,"仕入高"]
[null,"期首在庫-期末在庫"]
["【売上総利益】"]
["売上総利益",null,null,{"$f":"+売上高-売上原価","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"（同利益率）",null,{"$f":"IF(ISERROR(+売上総利益/売上高),\"\",+売上総利益/売上高)","v":""},"","","","","","","","","","","",""]
["【販売費及び一般管理費計画】"]
["販売費及び一般管理費",null,null,{"$f":"SUM(D37:D47)","v":0},{"$f":"SUM(E37:E47)","v":0},0,0,{"$f":"SUM(H37:H47)","v":0},0,0,0,{"$f":"SUM(L37:L47)","v":0},{"$f":"SUM(M37:M47)","v":0},{"$f":"SUM(N37:N47)","v":0},{"$f":"SUM(O37:O47)","v":0},{"$f":"SUM(P37:P47)","v":0}]
[null,"役員報酬"]
[null,"給料手当"]
[null,"賞与"]
[null,"その他人件費"]
[null,"人件費小計",null,{"$f":"SUM(D33:D36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(L33:L36)","v":0},{"$f":"SUM(M33:M36)","v":0},{"$f":"SUM(N33:N36)","v":0},{"$f":"SUM(O33:O36)","v":0},{"$f":"SUM(P33:P36)","v":0}]
[null,"荷造・運送費"]
[null,"外注費"]
[null,"販売手数料"]
[null,"広告宣伝費"]
[null,"賃借・リース料"]
[null,"租税公課"]
[null,"交際費"]
[null,"車輌・燃料費"]
[null,"減価償却費"]
[null,"その他"]
["【営業利益】"]
["営業利益",null,null,{"$f":"+売上総利益-販管費","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"（同利益率）",null,{"$f":"IF(ISERROR(+営業利益/売上高),\"\",+営業利益/売上高)","v":""},"","","","","","","",{"$f":"IF(ISERROR(+営業利益/売上高),\"\",+営業利益/売上高)","v":""},"","","",""]

{"sheet":"入力シート№2","index":6,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[15,2,15,3],[51,2,51,3],[50,2,50,3],[49,2,49,3],[38,1,38,3],[46,2,46,3],[45,2,45,3],[44,2,44,3],[41,2,41,3],[42,2,42,3],[3,1,3,2],[36,2,36,3],[3,3,3,4],[12,2,12,3],[11,2,11,3],[10,2,10,3],[22,2,22,3],[26,2,26,3],[28,2,28,3],[35,2,35,3],[24,2,24,3],[23,2,23,3],[27,2,27,3],[14,2,14,3],[19,2,19,3],[16,2,16,3],[2,4,2,6],[1,2,1,3],[2,2,2,3],[1,15,1,16],[1,4,1,6]]}
[]
[null,null,"会社名：",null,{"$f":"入力シート№1!D2","v":0},null,null,null,null,null,null,null,null,null,"作成日：",{"$f":"印刷及び基本項目入力!E30","v":"00:00:00"}]
[null,null,"取引支店名：",null,{"$f":"入力シート№1!D3","v":0},null,null,null,null,"入力シート  №2"]
[]
[]
[null,"【営業外損益計画】",null,null,null,null,null,null,null,null,null,null,null,null,null,"単位：",{"$f":"IF(印刷及び基本項目入力!$E$32=0,\"\",印刷及び基本項目入力!$E$32)","v":""}]
[]
[null,null,null,null,{"$f":"入力シート№1!D8","v":"-2/期"},{"$f":"入力シート№1!E8","v":"-1/期"},{"$f":"入力シート№1!F8","v":"/期"},{"$f":"入力シート№1!G8","v":"1/期"},{"$f":"入力シート№1!H8","v":"2/期"},{"$f":"入力シート№1!I8","v":"3/期"},{"$f":"入力シート№1!J8","v":"4/期"},{"$f":"入力シート№1!K8","v":"5/期"},{"$f":"入力シート№1!L8","v":"6/期"},{"$f":"入力シート№1!M8","v":"7/期"},{"$f":"入力シート№1!N8","v":"8/期"},{"$f":"入力シート№1!O8","v":"9/期"},{"$f":"入力シート№1!P8","v":"10/期"}]
[null,null,null,null,"実績","実績","実績","計画1","計画2","計画3","計画4","計画5","計画6","計画7","計画8","計画9","計画10"]
[null,"営業外収益",null,null,{"$f":"SUM(E11:E13)","v":0},0,0,0,{"$f":"SUM(I11:I13)","v":0},0,0,0,{"$f":"SUM(M11:M13)","v":0},{"$f":"SUM(N11:N13)","v":0},{"$f":"SUM(O11:O13)","v":0},{"$f":"SUM(P11:P13)","v":0},{"$f":"SUM(Q11:Q13)","v":0}]
[null,null,"受取利息・配当金"]
[null,null,"雑収入"]
[null,null,"その他"]
[null,"営業外費用",null,null,{"$f":"SUM(E15:E17)","v":0},0,0,0,{"$f":"SUM(I15:I17)","v":0},0,0,0,{"$f":"SUM(M15:M17)","v":0},{"$f":"SUM(N15:N17)","v":0},{"$f":"SUM(O15:O17)","v":0},{"$f":"SUM(P15:P17)","v":0},{"$f":"SUM(Q15:Q17)","v":0}]
[null,null,"支払利息"]
[null,null,"雑損失"]
[null,null,"その他"]
[null,"【経常利益】"]
[null,"経常利益",null,null,{"$f":"入力シート№1!D49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!E49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!F49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!G49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!H49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!I49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!J49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!K49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!L49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!M49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!N49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!O49+営業外収益-営業外費用","v":0},{"$f":"入力シート№1!P49+営業外収益-営業外費用","v":0}]
[null,null,"（同利益率）",null,{"$f":"IF(ISERROR(+経常利益/入力シート№1!D10),\"\",+経常利益/入力シート№1!D10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!E10),\"\",+経常利益/入力シート№1!E10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!F10),\"\",+経常利益/入力シート№1!F10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!G10),\"\",+経常利益/入力シート№1!G10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!H10),\"\",+経常利益/入力シート№1!H10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!I10),\"\",+経常利益/入力シート№1!I10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!J10),\"\",+経常利益/入力シート№1!J10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!K10),\"\",+経常利益/入力シート№1!K10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!L10),\"\",+経常利益/入力シート№1!L10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!M10),\"\",+経常利益/入力シート№1!M10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!N10),\"\",+経常利益/入力シート№1!N10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!O10),\"\",+経常利益/入力シート№1!O10)","v":""},{"$f":"IF(ISERROR(+経常利益/入力シート№1!P10),\"\",+経常利益/入力シート№1!P10)","v":""}]
[null,"【特別損益計画】"]
[null,"特別利益",null,null,{"$f":"SUM(E23:E25)","v":0},0,0,0,{"$f":"SUM(I23:I25)","v":0},0,0,0,{"$f":"SUM(M23:M25)","v":0},{"$f":"SUM(N23:N25)","v":0},{"$f":"SUM(O23:O25)","v":0},{"$f":"SUM(P23:P25)","v":0},{"$f":"SUM(Q23:Q25)","v":0}]
[null,null,"固定資産売却益"]
[null,null,"有価証券売却益"]
[null,null,"その他"]
[null,"特別損失",null,null,{"$f":"SUM(E27:E29)","v":0},0,0,0,{"$f":"SUM(I27:I29)","v":0},0,0,0,{"$f":"SUM(M27:M29)","v":0},{"$f":"SUM(N27:N29)","v":0},{"$f":"SUM(O27:O29)","v":0},{"$f":"SUM(P27:P29)","v":0},{"$f":"SUM(Q27:Q29)","v":0}]
[null,null,"固定資産売却損"]
[null,null,"固定資産除却損"]
[null,null,"その他"]
[null,"【税引前当期利益】"]
[null,"税引前当期利益",null,null,{"$f":"+経常利益+特別利益-特別損失","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"【法人税等】"]
[null,"法人税等"]
[null,"【設備投資計画】"]
[null,"設備投資",null,null,{"$f":"SUM(E36:E37)","v":0},{"$f":"SUM(F36:F37)","v":0},0,0,{"$f":"SUM(I36:I37)","v":0},0,{"$f":"SUM(K36:K37)","v":0},0,{"$f":"SUM(M36:M37)","v":0},{"$f":"SUM(N36:N37)","v":0},{"$f":"SUM(O36:O37)","v":0},{"$f":"SUM(P36:P37)","v":0},{"$f":"SUM(Q36:Q37)","v":0}]
[null,null,"維持更新投資"]
[null,null,"大型設備投資"]
[null,"【資産売却・増資計画】"]
[null,"資産売却/増資"]
[null,"【借入金計画】"]
[null,"短期借入金",null,null,null,{"$f":"E41+F42+IF(F43>0,-F43,F43)","v":0},{"$f":"F41+G42+IF(G43>0,-G43,G43)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"借入"]
[null,null,"返済"]
[null,"長期借入金",null,null,null,{"$f":"E44+F45+IF(F46>0,-F46,F46)+IF(F47>0,-F47,F47)","v":0},{"$f":"F44+G45+IF(G46>0,-G46,G46)+IF(G47>0,-G47,G47)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"借入"]
[null,null,"返済（約定分）"]
[null,null,"返済（約定外）"]
[null,"【人員計画】"]
[null,"総人員",null,null,{"$f":"+E50+E51","v":0},{"$f":"+F50+F51","v":0},{"$f":"+G50+G51","v":0},0,0,0,0,0,{"$f":"+M50+M51","v":0},{"$f":"+N50+N51","v":0},{"$f":"+O50+O51","v":0},{"$f":"+P50+P51","v":0},{"$f":"+Q50+Q51","v":0}]
[null,null,"役員"]
[null,null,"従業員"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"E31-E33","v":0},{"$f":"F31-F33","v":0},0,0,0,0,0,0,{"$f":"M31-M33","v":0},{"$f":"N31-N33","v":0},{"$f":"O31-O33","v":0},{"$f":"P31-P33","v":0},{"$f":"Q31-Q33","v":0}]

{"sheet":"補助シート№1（決算実績推移）","index":7,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,3,1,4],[2,3,2,4]]}
[]
[null,null,"会社名：",{"$f":"入力シート№1!D2","v":0},null,null,null,null,null,null,null,"作成日：",{"$f":"印刷及び基本項目入力!E30","v":"00:00:00"}]
[null,null,"取引支店名：",{"$f":"入力シート№1!D3","v":0},null,null,"補助シート　№1　（決算実績推移）"]
[]
["【損益計算書】",null,null,null,null,null,null,null,null,null,null,"単位：",{"$f":"入力シート№1!P6","v":""}]
[null,null,null,{"$f":"印刷及び基本項目入力!$F$34-9&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-9/期"},{"$f":"印刷及び基本項目入力!$F$34-8&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-8/期"},{"$f":"印刷及び基本項目入力!$F$34-7&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-7/期"},{"$f":"印刷及び基本項目入力!$F$34-6&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-6/期"},{"$f":"印刷及び基本項目入力!$F$34-5&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-5/期"},{"$f":"印刷及び基本項目入力!$F$34-4&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-4/期"},{"$f":"印刷及び基本項目入力!$F$34-3&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-3/期"},{"$f":"印刷及び基本項目入力!$F$34-2&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-2/期"},{"$f":"印刷及び基本項目入力!$F$34-1&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"-1/期"},{"$f":"印刷及び基本項目入力!$F$34&\"/\"&印刷及び基本項目入力!$H$34&\"期\"","v":"/期"}]
["売上高"]
[null,null,"（同増加率）",null,{"$f":"IF(D7=\"\",\"\",+E7/D7-1)","v":""},{"$f":"IF(E7=\"\",\"\",+F7/E7-1)","v":""},"","","","","","",""]
["売上総利益"]
[null,null,"（同利益率）",{"$f":"IF(D7>0,+D9/D7,\"\")","v":""},"","","","","","","","",""]
["販売費及び一般管理費"]
["営業利益",null,null,{"$f":"+D9-D11","v":0},{"$f":"+E9-E11","v":0},0,0,0,0,0,0,0,0]
[null,null,"（同利益率）",{"$f":"IF(D7>0,+D12/D7,\"\")","v":""},"","","","","","","","",""]
["経常利益"]
[null,null,"（同利益率）",{"$f":"IF(D7>0,+D14/D7,\"\")","v":""},"","","","","","","","",""]
["税引前当期純利益"]
["法人税等"]
["当期純利益",null,null,{"$f":"+D16-D17","v":0},{"$f":"+E16-E17","v":0},0,0,0,0,0,0,0,0]
["（減価償却費）"]
["従業員数"]
[]
[]
["【貸借対照表】"]
[null,null,null,{"$f":"+D6","v":"-9/期"},{"$f":"+E6","v":"-8/期"},{"$f":"+F6","v":"-7/期"},"-6/期","-5/期","-4/期","-3/期","-2/期","-1/期","/期"]
["流動資産",null,null,{"$f":"SUM(D26:D29)","v":0},{"$f":"SUM(E26:E29)","v":0},0,0,0,0,0,0,0,0]
[null,null,"現預金"]
[null,null,"売掛債権"]
[null,null,"棚卸資産"]
[null,null,"その他"]
["固定資産",null,null,{"$f":"SUM(D31:D33)","v":0},{"$f":"SUM(E31:E33)","v":0},0,0,0,0,0,0,0,0]
[null,null,"有形固定資産"]
[null,null,"無形固定資産"]
[null,null,"投資等"]
["繰延資産"]
["資産合計",null,null,{"$f":"+D25+D30+D34","v":0},{"$f":"+E25+E30+E34","v":0},0,0,0,0,0,0,0,0]
["流動負債",null,null,{"$f":"SUM(D37:D39)","v":0},{"$f":"SUM(E37:E39)","v":0},0,0,0,0,0,0,0,0]
[null,null,"仕入債務"]
[null,null,"短期借入金"]
[null,null,"その他"]
["固定負債",null,null,{"$f":"D41+D42","v":0},{"$f":"E41+E42","v":0},0,0,0,0,0,0,0,0]
[null,null,"社債・長期借入金"]
[null,null,"その他"]
["負債合計",null,null,{"$f":"+D36+D40","v":0},{"$f":"+E36+E40","v":0},0,0,0,0,0,0,0,0]
[null,null,"社債・借入金"]
["資本"]
[null,null,"（自己資本比率）",{"$f":"IF(D35>0,+D45/D35,\"\")","v":""},{"$f":"IF(E35>0,+E45/E35,\"\")","v":""},"","","","","","","",""]
["負債及び資本",null,null,{"$f":"+D43+D45","v":0},{"$f":"+E43+E45","v":0},0,0,0,0,0,0,0,0]

{"sheet":"補助シート№2-1（部門別売上・粗利）","index":8,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[16,1,16,2],[27,1,27,2],[23,2,24,2],[12,1,12,2],[11,1,11,2],[23,0,24,1],[21,1,21,2],[19,1,19,2],[18,1,18,2],[17,1,17,2],[15,1,15,2],[14,1,14,2],[13,1,13,2],[28,1,28,2],[39,1,39,2],[37,1,37,2],[36,1,36,2],[35,1,35,2],[34,1,34,2],[33,1,33,2],[32,1,32,2],[31,1,31,2],[30,1,30,2],[29,1,29,2],[5,2,6,2],[9,1,9,2],[10,1,10,2],[1,14,1,15],[5,0,6,1],[3,0,3,1],[3,2,3,3],[1,2,1,5],[2,2,2,5]]}
[]
[null,"会社名：",{"$f":"入力シート№1!D2","v":0},null,null,null,null,null,null,null,null,null,null,"作成日：",{"$f":"印刷及び基本項目入力!E30","v":"00:00:00"}]
[null,"取引支店名：",{"$f":"入力シート№1!D3","v":0},null,null,null,null,"補助シート　№2－1　（部門別粗利）"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"単位：",{"$f":"入力シート№1!P6","v":""}]
[{"$f":"IF(入力シート№1!$B$11=\"\",\"\",入力シート№1!$B$11)","v":""},null,"部門",{"$f":"+入力シート№1!D8","v":"-2/期"},{"$f":"+入力シート№1!E8","v":"-1/期"},{"$f":"+入力シート№1!F8","v":"/期"},{"$f":"+入力シート№1!G8","v":"1/期"},{"$f":"+入力シート№1!H8","v":"2/期"},{"$f":"+入力シート№1!I8","v":"3/期"},{"$f":"+入力シート№1!J8","v":"4/期"},{"$f":"+入力シート№1!K8","v":"5/期"},{"$f":"+入力シート№1!L8","v":"6/期"},{"$f":"+入力シート№1!M8","v":"7/期"},{"$f":"+入力シート№1!N8","v":"8/期"},{"$f":"+入力シート№1!O8","v":"9/期"},{"$f":"+入力シート№1!P8","v":"10/期"}]
[null,null,null,"実績","実績","実績","計画1","計画2","計画3","計画4","計画5","計画6","計画7","計画8","計画9","計画10"]
["売上高",null,null,{"$f":"+入力シート№1!D11","v":0},{"$f":"+入力シート№1!E11","v":0},{"$f":"+入力シート№1!F11","v":0},{"$f":"+入力シート№1!G11","v":0},{"$f":"+入力シート№1!H11","v":0},{"$f":"+入力シート№1!I11","v":0},{"$f":"+入力シート№1!J11","v":0},{"$f":"+入力シート№1!K11","v":0},{"$f":"+入力シート№1!L11","v":0},{"$f":"+入力シート№1!M11","v":0},{"$f":"+入力シート№1!N11","v":0},{"$f":"+入力シート№1!O11","v":0},{"$f":"+入力シート№1!P11","v":0}]
["売上原価",null,null,{"$f":"SUM(D10:D20)","v":0},{"$f":"SUM(E10:E20)","v":0},0,0,{"$f":"SUM(H10:H20)","v":0},0,0,0,{"$f":"SUM(L10:L20)","v":0},{"$f":"SUM(M10:M20)","v":0},{"$f":"SUM(N10:N20)","v":0},{"$f":"SUM(O10:O20)","v":0},{"$f":"SUM(P10:P20)","v":0}]
[null,"材料費"]
[null,"労務費"]
[null,"外注加工費"]
[null,"燃料費・動力費"]
[null,"荷造運送費"]
[null,"賃借・リース料"]
[null,"租税公課"]
[null,"減価償却費"]
[null,"その他"]
[null,"仕入高"]
[null,"期首在庫-期末在庫"]
["売上総利益",null,null,{"$f":"+D8-D9","v":0},{"$f":"+E8-E9","v":0},0,0,0,0,0,0,{"$f":"+L8-L9","v":0},{"$f":"+M8-M9","v":0},{"$f":"+N8-N9","v":0},{"$f":"+O8-O9","v":0},{"$f":"+P8-P9","v":0}]
[null,"（同利益率）",null,{"$f":"IF(D8>0,D21/D8,\"-\")","v":"-"},"-","-","-","-","-","-","-",{"$f":"IF(L8>0,L21/L8,\"-\")","v":"-"},{"$f":"IF(M8>0,M21/M8,\"-\")","v":"-"},{"$f":"IF(N8>0,N21/N8,\"-\")","v":"-"},{"$f":"IF(O8>0,O21/O8,\"-\")","v":"-"},{"$f":"IF(P8>0,P21/P8,\"-\")","v":"-"}]
[]
[{"$f":"IF(入力シート№1!$B$12=\"\",\"\",入力シート№1!$B$12)","v":""},null,"部門",{"$f":"+D6","v":"-2/期"},{"$f":"+E6","v":"-1/期"},"/期","1/期",{"$f":"+H6","v":"2/期"},"3/期","4/期","5/期",{"$f":"+L6","v":"6/期"},{"$f":"+M6","v":"7/期"},{"$f":"+N6","v":"8/期"},{"$f":"+O6","v":"9/期"},{"$f":"+P6","v":"10/期"}]
[null,null,null,"実績","実績","実績","計画1","計画2","計画3","計画4","計画5","計画6","計画7","計画8","計画9","計画10"]
["売上高",null,null,{"$f":"+入力シート№1!D12","v":0},{"$f":"+入力シート№1!E12","v":0},{"$f":"+入力シート№1!F12","v":0},{"$f":"+入力シート№1!G12","v":0},{"$f":"+入力シート№1!H12","v":0},{"$f":"+入力シート№1!I12","v":0},{"$f":"+入力シート№1!J12","v":0},{"$f":"+入力シート№1!K12","v":0},{"$f":"+入力シート№1!L12","v":0},{"$f":"+入力シート№1!M12","v":0},{"$f":"+入力シート№1!N12","v":0},{"$f":"+入力シート№1!O12","v":0},{"$f":"+入力シート№1!P12","v":0}]
["売上原価",null,null,{"$f":"SUM(D28:D38)","v":0},0,0,0,{"$f":"SUM(H28:H38)","v":0},0,0,0,{"$f":"SUM(L28:L38)","v":0},{"$f":"SUM(M28:M38)","v":0},{"$f":"SUM(N28:N38)","v":0},{"$f":"SUM(O28:O38)","v":0},{"$f":"SUM(P28:P38)","v":0}]
[null,"材料費"]
[null,"労務費"]
[null,"外注加工費"]
[null,"燃料費・動力費"]
[null,"荷造運送費"]
[null,"賃借・リース料"]
[null,"租税公課"]
[null,"減価償却費"]
[null,"その他"]
[null,"仕入高"]
[null,"期首在庫-期末在庫"]
["売上総利益",null,null,{"$f":"+D26-D27","v":0},0,0,0,0,0,0,0,{"$f":"+L26-L27","v":0},{"$f":"+M26-M27","v":0},{"$f":"+N26-N27","v":0},{"$f":"+O26-O27","v":0},{"$f":"+P26-P27","v":0}]
[null,"（同利益率）",null,{"$f":"IF(D26>0,D39/D26,\"-\")","v":"-"},"-","-","-","-","-","-","-",{"$f":"IF(L26>0,L39/L26,\"-\")","v":"-"},{"$f":"IF(M26>0,M39/M26,\"-\")","v":"-"},{"$f":"IF(N26>0,N39/N26,\"-\")","v":"-"},{"$f":"IF(O26>0,O39/O26,\"-\")","v":"-"},{"$f":"IF(P26>0,P39/P26,\"-\")","v":"-"}]

{"sheet":"補助シート№2-2（部門別売上・粗利）","index":9,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[17,2,17,3],[5,3,6,3],[9,2,9,3],[15,2,15,3],[16,2,16,3],[1,15,1,16],[5,1,6,2],[3,3,3,4],[31,2,31,3],[30,2,30,3],[29,2,29,3],[12,2,12,3],[11,2,11,3],[13,2,13,3],[14,2,14,3],[1,3,1,4],[2,3,2,4],[10,2,10,3],[28,2,28,3],[27,2,27,3],[21,2,21,3],[39,2,39,3],[37,2,37,3],[36,2,36,3],[35,2,35,3],[34,2,34,3],[19,2,19,3],[18,2,18,3],[23,1,24,2],[23,3,24,3],[33,2,33,3],[32,2,32,3]]}
[]
[null,null,"会社名：",{"$f":"入力シート№1!D2","v":0},null,null,null,null,null,null,null,null,null,null,"作成日：",{"$f":"印刷及び基本項目入力!E30","v":"00:00:00"}]
[null,null,"取引支店名：",{"$f":"入力シート№1!D3","v":0},null,null,null,null,"補助シート　№2－2　（部門別粗利）"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"単位：",{"$f":"入力シート№1!P6","v":""}]
[null,{"$f":"IF(入力シート№1!$B$13=\"\",\"\",入力シート№1!$B$13)","v":""},null,"部門",{"$f":"入力シート№1!D8","v":"-2/期"},{"$f":"入力シート№1!E8","v":"-1/期"},{"$f":"入力シート№1!F8","v":"/期"},{"$f":"入力シート№1!G8","v":"1/期"},{"$f":"入力シート№1!H8","v":"2/期"},{"$f":"入力シート№1!I8","v":"3/期"},{"$f":"入力シート№1!J8","v":"4/期"},{"$f":"入力シート№1!K8","v":"5/期"},{"$f":"入力シート№1!L8","v":"6/期"},{"$f":"入力シート№1!M8","v":"7/期"},{"$f":"入力シート№1!N8","v":"8/期"},{"$f":"入力シート№1!O8","v":"9/期"},{"$f":"入力シート№1!P8","v":"10/期"}]
[null,null,null,null,"実績","実績","実績","計画1","計画2","計画3","計画4","計画5","計画6","計画7","計画8","計画9","計画10"]
[null,"売上高",null,null,{"$f":"+入力シート№1!D13","v":0},{"$f":"+入力シート№1!E13","v":0},{"$f":"+入力シート№1!F13","v":0},{"$f":"+入力シート№1!G13","v":0},{"$f":"+入力シート№1!H13","v":0},{"$f":"+入力シート№1!I13","v":0},{"$f":"+入力シート№1!J13","v":0},{"$f":"+入力シート№1!K13","v":0},{"$f":"+入力シート№1!L13","v":0},{"$f":"+入力シート№1!M13","v":0},{"$f":"+入力シート№1!N13","v":0},{"$f":"+入力シート№1!O13","v":0},{"$f":"+入力シート№1!P13","v":0}]
[null,"売上原価",null,null,{"$f":"SUM(E10:E20)","v":0},{"$f":"SUM(F10:F20)","v":0},0,0,0,0,0,0,{"$f":"SUM(M10:M20)","v":0},{"$f":"SUM(N10:N20)","v":0},{"$f":"SUM(O10:O20)","v":0},{"$f":"SUM(P10:P20)","v":0},{"$f":"SUM(Q10:Q20)","v":0}]
[null,null,"材料費"]
[null,null,"労務費"]
[null,null,"外注加工費"]
[null,null,"燃料費・動力費"]
[null,null,"荷造運送費"]
[null,null,"賃借・リース料"]
[null,null,"租税公課"]
[null,null,"減価償却費"]
[null,null,"その他"]
[null,null,"仕入高"]
[null,null,"期首在庫-期末在庫"]
[null,"売上総利益",null,null,{"$f":"+E8-E9","v":0},0,0,0,0,0,0,0,{"$f":"+M8-M9","v":0},{"$f":"+N8-N9","v":0},{"$f":"+O8-O9","v":0},{"$f":"+P8-P9","v":0},{"$f":"+Q8-Q9","v":0}]
[null,null,"（同利益率）",null,{"$f":"IF(E8>0,E21/E8,\"-\")","v":"-"},"-","-","-","-","-","-","-",{"$f":"IF(M8>0,M21/M8,\"-\")","v":"-"},{"$f":"IF(N8>0,N21/N8,\"-\")","v":"-"},{"$f":"IF(O8>0,O21/O8,\"-\")","v":"-"},{"$f":"IF(P8>0,P21/P8,\"-\")","v":"-"},{"$f":"IF(Q8>0,Q21/Q8,\"-\")","v":"-"}]
[]
[null,{"$f":"IF(入力シート№1!$B$14=\"\",\"\",入力シート№1!$B$14)","v":""},null,"部門",{"$f":"E6","v":"-2/期"},{"$f":"F6","v":"-1/期"},{"$f":"G6","v":"/期"},{"$f":"H6","v":"1/期"},"2/期","3/期","4/期","5/期",{"$f":"M6","v":"6/期"},{"$f":"N6","v":"7/期"},{"$f":"O6","v":"8/期"},{"$f":"P6","v":"9/期"},{"$f":"Q6","v":"10/期"}]
[null,null,null,null,"実績","実績","実績","計画1","計画2","計画3","計画4","計画5","計画6","計画7","計画8","計画9","計画10"]
[null,"売上高",null,null,{"$f":"+入力シート№1!D14","v":0},{"$f":"+入力シート№1!E14","v":0},{"$f":"+入力シート№1!F14","v":0},{"$f":"+入力シート№1!G14","v":0},{"$f":"+入力シート№1!H14","v":0},{"$f":"+入力シート№1!I14","v":0},{"$f":"+入力シート№1!J14","v":0},{"$f":"+入力シート№1!K14","v":0},{"$f":"+入力シート№1!L14","v":0},{"$f":"+入力シート№1!M14","v":0},{"$f":"+入力シート№1!N14","v":0},{"$f":"+入力シート№1!O14","v":0},{"$f":"+入力シート№1!P14","v":0}]
[null,"売上原価",null,null,{"$f":"SUM(E28:E38)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(M28:M38)","v":0},{"$f":"SUM(N28:N38)","v":0},{"$f":"SUM(O28:O38)","v":0},{"$f":"SUM(P28:P38)","v":0},{"$f":"SUM(Q28:Q38)","v":0}]
[null,null,"材料費"]
[null,null,"労務費"]
[null,null,"外注加工費"]
[null,null,"燃料費・動力費"]
[null,null,"荷造運送費"]
[null,null,"賃借・リース料"]
[null,null,"租税公課"]
[null,null,"減価償却費"]
[null,null,"その他"]
[null,null,"仕入高"]
[null,null,"期首在庫-期末在庫"]
[null,"売上総利益",null,null,{"$f":"+E26-E27","v":0},0,0,0,0,0,0,0,{"$f":"+M26-M27","v":0},{"$f":"+N26-N27","v":0},{"$f":"+O26-O27","v":0},{"$f":"+P26-P27","v":0},{"$f":"+Q26-Q27","v":0}]
[null,null,"（同利益率）",null,{"$f":"IF(E26>0,E39/E26,\"-\")","v":"-"},"-","-","-","-","-","-","-",{"$f":"IF(M26>0,M39/M26,\"-\")","v":"-"},{"$f":"IF(N26>0,N39/N26,\"-\")","v":"-"},{"$f":"IF(O26>0,O39/O26,\"-\")","v":"-"},{"$f":"IF(P26>0,P39/P26,\"-\")","v":"-"},{"$f":"IF(Q26>0,Q39/Q26,\"-\")","v":"-"}]

{"sheet":"補助シート№3（人員計画）","index":10,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,16,1,17],[16,1,16,3],[5,0,6,1],[22,2,22,4],[1,0,1,2],[34,0,35,4],[2,0,2,2],[3,0,3,2],[3,3,3,5],[10,1,10,3],[12,1,12,3],[14,1,14,3],[21,2,21,4],[23,2,23,4]]}
[]
[null,null,null,null,"会社名：",{"$f":"入力シート№1!D2","v":0},null,null,null,null,null,null,null,null,null,"作成日：",{"$f":"印刷及び基本項目入力!E30","v":"00:00:00"}]
[null,null,null,null,"取引支店名：",{"$f":"入力シート№1!D3","v":0},null,null,null,null,"補助シート　№3　（人員計画）"]
[]
["【人員計画】",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"単位：",{"$f":"入力シート№1!P6","v":""}]
[null,null,null,null,null,{"$f":"+入力シート№1!D8","v":"-2/期"},{"$f":"+入力シート№1!E8","v":"-1/期"},{"$f":"+入力シート№1!F8","v":"/期"},{"$f":"+入力シート№1!G8","v":"1/期"},{"$f":"+入力シート№1!H8","v":"2/期"},{"$f":"+入力シート№1!I8","v":"3/期"},{"$f":"+入力シート№1!J8","v":"4/期"},{"$f":"+入力シート№1!K8","v":"5/期"},{"$f":"+入力シート№1!L8","v":"6/期"},{"$f":"+入力シート№1!M8","v":"7/期"},{"$f":"+入力シート№1!N8","v":"8/期"},{"$f":"+入力シート№1!O8","v":"9/期"},{"$f":"+入力シート№1!P8","v":"10/期"}]
[null,null,null,null,null,"実績","実績","実績","計画1","計画2","計画3","計画4","計画5","計画6","計画7","計画8","計画9","計画10"]
["売上高",null,null,null,null,{"$f":"入力シート№1!D10","v":0},{"$f":"入力シート№1!E10","v":0},{"$f":"入力シート№1!F10","v":0},{"$f":"入力シート№1!G10","v":0},{"$f":"入力シート№1!H10","v":0},{"$f":"入力シート№1!I10","v":0},{"$f":"入力シート№1!J10","v":0},{"$f":"入力シート№1!K10","v":0},{"$f":"入力シート№1!L10","v":0},{"$f":"入力シート№1!M10","v":0},{"$f":"入力シート№1!N10","v":0},{"$f":"入力シート№1!O10","v":0},{"$f":"入力シート№1!P10","v":0}]
["人件費合計額",null,null,null,null,{"$f":"+F10+F19","v":0},{"$f":"+G10+G19","v":0},0,{"$f":"+I10+I19","v":0},{"$f":"+J10+J19","v":0},0,0,0,{"$f":"+N10+N19","v":0},{"$f":"+O10+O19","v":0},{"$f":"+P10+P19","v":0},{"$f":"+Q10+Q19","v":0},{"$f":"+R10+R19","v":0}]
["労務費",null,null,null,null,{"$f":"SUM(F11,F13,F15,F17)","v":0},{"$f":"SUM(G11,G13,G15,G17)","v":0},{"$f":"SUM(H11,H13,H15,H17)","v":0},0,{"$f":"SUM(J11,J13,J15,J17)","v":0},0,0,0,{"$f":"SUM(N11,N13,N15,N17)","v":0},{"$f":"SUM(O11,O13,O15,O17)","v":0},{"$f":"SUM(P11,P13,P15,P17)","v":0},{"$f":"SUM(Q11,Q13,Q15,Q17)","v":0},{"$f":"SUM(R11,R13,R15,R17)","v":0}]
[null,{"$f":"IF(入力シート№1!B11=\"\",\"\",入力シート№1!B11)","v":""},null,null,"部門"]
[null,null,"（期末従業員数）"]
[null,{"$f":"IF(入力シート№1!B12=\"\",\"\",入力シート№1!B12)","v":""},null,null,"部門"]
[null,null,"（期末従業員数）"]
[null,{"$f":"IF(入力シート№1!B13=\"\",\"\",入力シート№1!B13)","v":""},null,null,"部門"]
[null,null,"（期末従業員数）"]
[null,{"$f":"IF(入力シート№1!B14=\"\",\"\",入力シート№1!B14)","v":""},null,null,"部門"]
[null,null,"（期末従業員数）"]
["人件費（販売・管理）",null,null,null,null,{"$f":"SUM(F20,F25,F27:F31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"役員報酬",null,null,null,{"$f":"SUM(F22:F24)","v":0},{"$f":"SUM(G22:G24)","v":0},0,0,{"$f":"SUM(J22:J24)","v":0},0,0,0,{"$f":"SUM(N22:N24)","v":0},{"$f":"SUM(O22:O24)","v":0},{"$f":"SUM(P22:P24)","v":0},{"$f":"SUM(Q22:Q24)","v":0},{"$f":"SUM(R22:R24)","v":0}]
[]
[]
[]
[null,null,"その他"]
[null,"従業員給与"]
[null,null,"（期末従業員数）"]
[null,"賞与等"]
[null,"法定福利費"]
[null,"福利厚生費"]
[null,"退職金等"]
[null,"その他"]
["期末従業員数",null,null,null,null,{"$f":"+F12+F14+F16+F18+F26","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["【人件費参考指標】"]
[null,null,null,null,null,{"$f":"+F6","v":"-2/期"},"-1/期","/期","1/期",{"$f":"+J6","v":"2/期"},"3/期","4/期","5/期",{"$f":"+N6","v":"6/期"},{"$f":"+O6","v":"7/期"},{"$f":"+P6","v":"8/期"},{"$f":"+Q6","v":"9/期"},{"$f":"+R6","v":"10/期"}]
[null,null,null,null,null,"実績","実績","実績","計画1","計画2","計画3","計画4","計画5","計画6","計画7","計画8","計画9","計画10"]
["売上高人件費比率",null,null,null,null,{"$f":"IF(ISERROR(+(F10+F19)/F8),\"\",+(F10+F19)/F8)","v":""},{"$f":"IF(ISERROR(+(G10+G19)/G8),\"\",+(G10+G19)/G8)","v":""},{"$f":"IF(ISERROR(+(H10+H19)/H8),\"\",+(H10+H19)/H8)","v":""},"","","","","",{"$f":"IF(ISERROR(+(N10+N19)/N8),\"\",+(N10+N19)/N8)","v":""},{"$f":"IF(ISERROR(+(O10+O19)/O8),\"\",+(O10+O19)/O8)","v":""},{"$f":"IF(ISERROR(+(P10+P19)/P8),\"\",+(P10+P19)/P8)","v":""},{"$f":"IF(ISERROR(+(Q10+Q19)/Q8),\"\",+(Q10+Q19)/Q8)","v":""},{"$f":"IF(ISERROR(+(R10+R19)/R8),\"\",+(R10+R19)/R8)","v":""}]
["一人当り売上高",null,null,null,null,null,{"$f":"IF(ISERROR(+G8/(F21+F32+G21+G32)*2),\"\",+G8/(F21+F32+G21+G32)*2)","v":""},"","","","","","","","","","",""]
["一人当り人件費",null,null,null,null,null,{"$f":"IF(ISERROR(+(G10+G19)/(F21+F32+G21+G32)*2),\"\",+(G10+G19)/(F21+F32+G21+G32)*2)","v":""},"","","","","","","","","","",""]