{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["開始","計画された費用","実際の費用","経費差異","費用の分析"],"not_rendered":{"charts":3,"images":4,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"このテンプレートについて"]
[null,"この業務経費予算ブックを使用すると、計画された費用と実際の費用の差異を追跡できます。"]
[null,"会社名を入力し、ロゴを追加します。"]
[null,"計画された費用ワークシートと実際の費用ワークシート内のテーブルの詳細を入力します。"]
[null,"経費差異ワークシートの表および費用の分析のワークシートのグラフが自動的に更新されます。"]
[null,"メモ: "]
[null,"各ワークシートの列 A に詳細な手順が記載されています。このテキストは意図的に表示されません。テキストを削除するには、列 A を選択し、[削除] を選択します。テキストを再表示するには、列 A を選択し、フォントの色を変更します。"]
[null,"表の詳細については、表内で Shift キーを押し、F10 キーを押して、[テーブル] オプションを選択し、[代替テキスト] を選択します。"]

{"sheet":"計画された費用","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[3,17,12,19],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["計画された人件費、オフィス賃貸料、マーケティング費用、トレーニング費用、交通費をこのワークシートのそれぞれの表に入力します。集計は、自動的に計算されます。このワークシートの役に立つ使用方法に関する説明がこの列のセルに表示されます。下向き矢印で開始します。",{"$nulls":14}," "]
["右のセルに会社名を入力し、セル N2 にロゴを入力します。このワークシートのタイトルはセル K2 に表示されます。","会社名",{"$nulls":8},"詳細経費見積",null,null,"このセルにはロゴのプレースホルダーが表示されます。"]
["ヒントはセル K3 に表示されます。",{"$nulls":9},"網掛けされているセルが計算されます。"]
["右のセルに計画された費用ラベルが表示され、セル C4 から N4 に月が、セル O4 に年が、セル R4 にこのテンプレートの使用方法が表示されます。","計画された費用","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年",null,null,"ヒント:このテンプレートの使用方法\n計画された費用と実際の費用のワークシートの空白のセルにデータを入力すると、経費差異と費用の分析が計算されます。1 つのシートに行を追加した場合、他のシートを一致させる必要があります。"]
["右のセルから始まる従業員計画の表に人件費を入力します。次の指示はセル A10 に表示されます。","人件費","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"給料",{"v":85000,"d":"¥85,000.00"},{"v":85000,"d":"¥85,000.00"},{"v":85000,"d":"¥85,000.00"},{"v":87500,"d":"¥87,500.00"},{"v":87500,"d":"¥87,500.00"},{"v":87500,"d":"¥87,500.00"},{"v":87500,"d":"¥87,500.00"},{"v":92400,"d":"¥92,400.00"},{"v":92400,"d":"¥92,400.00"},{"v":92400,"d":"¥92,400.00"},{"v":92400,"d":"¥92,400.00"},{"v":92400,"d":"¥92,400.00"},{"$f":"SUM(C6:N6)","v":{"v":1067000,"d":"¥1,067,000.00"}}]
[null,"利益",{"$f":"C6*0.27","v":{"v":22950,"d":"¥22,950.00"}},{"v":22950,"d":"¥22,950.00"},{"v":22950,"d":"¥22,950.00"},{"v":23625,"d":"¥23,625.00"},{"v":23625,"d":"¥23,625.00"},{"v":23625,"d":"¥23,625.00"},{"v":23625,"d":"¥23,625.00"},{"v":24948,"d":"¥24,948.00"},{"v":24948,"d":"¥24,948.00"},{"v":24948,"d":"¥24,948.00"},{"v":24948,"d":"¥24,948.00"},{"v":24948,"d":"¥24,948.00"},{"$f":"SUM(C7:N7)","v":{"v":288090,"d":"¥288,090.00"}}]
[null,"小計",{"$f":"SUBTOTAL(109,EmployeePlan[1 月])","v":{"v":107950,"d":"¥107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[2 月])","v":{"v":107950,"d":"¥107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[3 月])","v":{"v":107950,"d":"¥107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[4 月])","v":{"v":111125,"d":"¥111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[5 月])","v":{"v":111125,"d":"¥111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[6 月])","v":{"v":111125,"d":"¥111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[7 月])","v":{"v":111125,"d":"¥111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[8 月])","v":{"v":117348,"d":"¥117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[9 月])","v":{"v":117348,"d":"¥117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[10 月])","v":{"v":117348,"d":"¥117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[11 月])","v":{"v":117348,"d":"¥117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[12 月])","v":{"v":117348,"d":"¥117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[年])","v":{"v":1355090,"d":"¥1,355,090.00"}}]
[]
["右のセルから始まるオフィス計画の表にオフィス賃貸料を入力します。次の指示はセル A21 に表示されます。","オフィス賃貸料","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"オフィスの賃貸",{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"$f":"SUM(C11:N11)","v":{"v":117600,"d":"¥117,600.00"}}]
[null,"ガス",null,{"v":400,"d":"¥400.00"},{"v":400,"d":"¥400.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":400,"d":"¥400.00"},{"v":400,"d":"¥400.00"},{"v":2300,"d":"¥2,300.00"}]
[null,"電気",{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":300,"d":"¥300.00"},{"v":3600,"d":"¥3,600.00"}]
[null,"水道",{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":40,"d":"¥40.00"},{"v":480,"d":"¥480.00"}]
[null,"電話",{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":250,"d":"¥250.00"},{"v":3000,"d":"¥3,000.00"}]
[null,"インターネット アクセス",{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":2160,"d":"¥2,160.00"}]
[null,"事務用品",{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":2400,"d":"¥2,400.00"}]
[null,"セキュリティ",{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":7200,"d":"¥7,200.00"}]
[null,"小計",{"$f":"SUBTOTAL(109,OfficePlan[1 月])","v":{"v":11370,"d":"¥11,370.00"}},{"$f":"SUBTOTAL(109,OfficePlan[2 月])","v":{"v":11770,"d":"¥11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[3 月])","v":{"v":11770,"d":"¥11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[4 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[5 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[6 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[7 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[8 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[9 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[10 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[11 月])","v":{"v":11770,"d":"¥11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[12 月])","v":{"v":11770,"d":"¥11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[年])","v":{"v":138740,"d":"¥138,740.00"}}]
[]
["右のセルから始まるマーケティング計画の表にマーケティング費用を入力します。次の指示はセル A30 に表示されます。","マーケティング費用","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"Web サイト ホスティング",{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"$f":"SUM(C22:N22)","v":{"v":6000,"d":"¥6,000.00"}}]
[null,"Web サイトの更新",{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":1000,"d":"¥1,000.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":1000,"d":"¥1,000.00"},{"v":4000,"d":"¥4,000.00"}]
[null,"資料の準備",{"v":5000,"d":"¥5,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":5000,"d":"¥5,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":5000,"d":"¥5,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":5000,"d":"¥5,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":20000,"d":"¥20,000.00"}]
[null,"資料の印刷",{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":2400,"d":"¥2,400.00"}]
[null,"マーケティング イベント",{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":5000,"d":"¥5,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":5000,"d":"¥5,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":5000,"d":"¥5,000.00"},{"v":33000,"d":"¥33,000.00"}]
[null,"その他の経費",{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":2400,"d":"¥2,400.00"}]
[null,"小計",{"$f":"SUBTOTAL(109,MarketingPlan[1 月])","v":{"v":8100,"d":"¥8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[2 月])","v":{"v":3100,"d":"¥3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[3 月])","v":{"v":3100,"d":"¥3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[4 月])","v":{"v":11100,"d":"¥11,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[5 月])","v":{"v":3100,"d":"¥3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[6 月])","v":{"v":3900,"d":"¥3,900.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[7 月])","v":{"v":8100,"d":"¥8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[8 月])","v":{"v":6100,"d":"¥6,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[9 月])","v":{"v":3100,"d":"¥3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[10 月])","v":{"v":8100,"d":"¥8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[11 月])","v":{"v":3100,"d":"¥3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[12 月])","v":{"v":6900,"d":"¥6,900.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[年])","v":{"v":67800,"d":"¥67,800.00"}}]
[]
["右のセルから始まるトレーニングおよびトレーニング計画の表にトレーニングおよび交通費を入力します。次の指示はセル A35 に表示されます。","トレーニング/交通費","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"トレーニング クラス",{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"$f":"SUM(C31:N31)","v":{"v":24000,"d":"¥24,000.00"}}]
[null,"トレーニング関連の交通費",{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"$f":"SUM(C32:N32)","v":{"v":24000,"d":"¥24,000.00"}}]
[null,"小計",{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[1 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[2 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[3 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[4 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[5 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[6 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[7 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[8 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[9 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[10 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[11 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[12 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[年])","v":{"v":48000,"d":"¥48,000.00"}}]
[]
["集計は、右のセルから始まる計画された合計の表に自動的で計算されます。","集計","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"月ごとの計画された費用",{"$f":"TrainingAndTravelPlan[[#Totals],[1 月]]+MarketingPlan[[#Totals],[1 月]]+OfficePlan[[#Totals],[1 月]]+EmployeePlan[[#Totals],[1 月]]","v":{"v":131420,"d":"¥131,420.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[2 月]]+MarketingPlan[[#Totals],[2 月]]+OfficePlan[[#Totals],[2 月]]+EmployeePlan[[#Totals],[2 月]]","v":{"v":126820,"d":"¥126,820.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[3 月]]+MarketingPlan[[#Totals],[3 月]]+OfficePlan[[#Totals],[3 月]]+EmployeePlan[[#Totals],[3 月]]","v":{"v":126820,"d":"¥126,820.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[4 月]]+MarketingPlan[[#Totals],[4 月]]+OfficePlan[[#Totals],[4 月]]+EmployeePlan[[#Totals],[4 月]]","v":{"v":137695,"d":"¥137,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[5 月]]+MarketingPlan[[#Totals],[5 月]]+OfficePlan[[#Totals],[5 月]]+EmployeePlan[[#Totals],[5 月]]","v":{"v":129695,"d":"¥129,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[6 月]]+MarketingPlan[[#Totals],[6 月]]+OfficePlan[[#Totals],[6 月]]+EmployeePlan[[#Totals],[6 月]]","v":{"v":130495,"d":"¥130,495.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[7 月]]+MarketingPlan[[#Totals],[7 月]]+OfficePlan[[#Totals],[7 月]]+EmployeePlan[[#Totals],[7 月]]","v":{"v":134695,"d":"¥134,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[8 月]]+MarketingPlan[[#Totals],[8 月]]+OfficePlan[[#Totals],[8 月]]+EmployeePlan[[#Totals],[8 月]]","v":{"v":138918,"d":"¥138,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[9 月]]+MarketingPlan[[#Totals],[9 月]]+OfficePlan[[#Totals],[9 月]]+EmployeePlan[[#Totals],[9 月]]","v":{"v":135918,"d":"¥135,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[10 月]]+MarketingPlan[[#Totals],[10 月]]+OfficePlan[[#Totals],[10 月]]+EmployeePlan[[#Totals],[10 月]]","v":{"v":140918,"d":"¥140,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[11 月]]+MarketingPlan[[#Totals],[11 月]]+OfficePlan[[#Totals],[11 月]]+EmployeePlan[[#Totals],[11 月]]","v":{"v":136218,"d":"¥136,218.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[12 月]]+MarketingPlan[[#Totals],[12 月]]+OfficePlan[[#Totals],[12 月]]+EmployeePlan[[#Totals],[12 月]]","v":{"v":140018,"d":"¥140,018.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[年]]+MarketingPlan[[#Totals],[年]]+OfficePlan[[#Totals],[年]]+EmployeePlan[[#Totals],[年]]","v":{"v":1609630,"d":"¥1,609,630.00"}}]
[null,"合計の計画された費用",{"$f":"SUM($C$36:C36)","v":{"v":131420,"d":"¥131,420.00"}},{"$f":"SUM($C$36:D36)","v":{"v":258240,"d":"¥258,240.00"}},{"$f":"SUM($C$36:E36)","v":{"v":385060,"d":"¥385,060.00"}},{"$f":"SUM($C$36:F36)","v":{"v":522755,"d":"¥522,755.00"}},{"$f":"SUM($C$36:G36)","v":{"v":652450,"d":"¥652,450.00"}},{"$f":"SUM($C$36:H36)","v":{"v":782945,"d":"¥782,945.00"}},{"$f":"SUM($C$36:I36)","v":{"v":917640,"d":"¥917,640.00"}},{"$f":"SUM($C$36:J36)","v":{"v":1056558,"d":"¥1,056,558.00"}},{"$f":"SUM($C$36:K36)","v":{"v":1192476,"d":"¥1,192,476.00"}},{"$f":"SUM($C$36:L36)","v":{"v":1333394,"d":"¥1,333,394.00"}},{"$f":"SUM($C$36:M36)","v":{"v":1469612,"d":"¥1,469,612.00"}},{"$f":"SUM($C$36:N36)","v":{"v":1609630,"d":"¥1,609,630.00"}}]

{"sheet":"実際の費用","index":2,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["実際の人件費、オフィス賃貸料、マーケティング費用、トレーニング費用、交通費をこのワークシートのそれぞれの表に入力します。合計は、自動的に計算されます。このワークシートの役に立つ使用方法に関する説明がこの列のセルに表示されます。下向き矢印で開始します。",{"$nulls":14}," "]
["会社名は右のセルで自動的に更新されます。このワークシートのタイトルはセル K2 に表示されます。セル N2 にロゴを入力します。",{"$f":"計画された費用!B2:D3","v":"会社名"},{"$nulls":8},{"$f":"worksheet_title","v":"詳細経費見積"},null,null,"このセルにはロゴのプレースホルダーが表示されます。"]
["ヒントはセル K3 に表示されます。",{"$nulls":9},"網掛けされているセルが計算されます。"]
["右のセルに実際の費用のラベルが表示され、セル C4 から N4 に月が、O4 に年のラベルが表示されます。","実際の費用","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
["右のセルから始まる従業員の実際の費用の表に人件費を入力します。次の指示はセル A10 に表示されます。","人件費","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"給料",{"v":85000,"d":"¥85,000.00"},{"v":85000,"d":"¥85,000.00"},{"v":85000,"d":"¥85,000.00"},{"v":88000,"d":"¥88,000.00"},{"v":88000,"d":"¥88,000.00"},{"v":88000,"d":"¥88,000.00"},{"$nulls":6},{"$f":"SUM(C6:N6)","v":{"v":519000,"d":"¥519,000.00"}}]
[null,"利益",{"$f":"C6*0.27","v":{"v":22950,"d":"¥22,950.00"}},{"v":22950,"d":"¥22,950.00"},{"v":22950,"d":"¥22,950.00"},{"v":23760,"d":"¥23,760.00"},{"v":23760,"d":"¥23,760.00"},{"v":23760,"d":"¥23,760.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$f":"SUM(C7:N7)","v":{"v":140130,"d":"¥140,130.00"}}]
[null,"小計",{"$f":"SUBTOTAL(109,EmployeeActual[1 月])","v":{"v":107950,"d":"¥107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[2 月])","v":{"v":107950,"d":"¥107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[3 月])","v":{"v":107950,"d":"¥107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[4 月])","v":{"v":111760,"d":"¥111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[5 月])","v":{"v":111760,"d":"¥111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[6 月])","v":{"v":111760,"d":"¥111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[年])","v":{"v":659130,"d":"¥659,130.00"}}]
[]
["右のセルから始まるオフィスの実際の費用の表にオフィス賃貸料を入力します。次の指示はセル A21 に表示されます。","オフィス賃貸料","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"オフィスの賃貸",{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"v":9800,"d":"¥9,800.00"},{"$nulls":6},{"$f":"SUM(C11:N11)","v":{"v":58800,"d":"¥58,800.00"}}]
[null,"ガス",{"v":4,"d":"¥4.00"},{"v":430,"d":"¥430.00"},{"v":385,"d":"¥385.00"},{"v":230,"d":"¥230.00"},{"v":87,"d":"¥87.00"},{"v":88,"d":"¥88.00"},{"$nulls":6},{"v":1224,"d":"¥1,224.00"}]
[null,"電気",{"v":288,"d":"¥288.00"},{"v":278,"d":"¥278.00"},{"v":268,"d":"¥268.00"},{"v":299,"d":"¥299.00"},{"v":306,"d":"¥306.00"},{"v":290,"d":"¥290.00"},{"$nulls":6},{"v":1729,"d":"¥1,729.00"}]
[null,"水道",{"v":35,"d":"¥35.00"},{"v":33,"d":"¥33.00"},{"v":34,"d":"¥34.00"},{"v":36,"d":"¥36.00"},{"v":34,"d":"¥34.00"},{"v":36,"d":"¥36.00"},{"$nulls":6},{"v":208,"d":"¥208.00"}]
[null,"電話",{"v":224,"d":"¥224.00"},{"v":235,"d":"¥235.00"},{"v":265,"d":"¥265.00"},{"v":245,"d":"¥245.00"},{"v":245,"d":"¥245.00"},{"v":220,"d":"¥220.00"},{"$nulls":6},{"v":1434,"d":"¥1,434.00"}]
[null,"インターネット アクセス",{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"v":180,"d":"¥180.00"},{"$nulls":6},{"v":1080,"d":"¥1,080.00"}]
[null,"事務用品",{"v":256,"d":"¥256.00"},{"v":142,"d":"¥142.00"},{"v":160,"d":"¥160.00"},{"v":221,"d":"¥221.00"},{"v":256,"d":"¥256.00"},{"v":240,"d":"¥240.00"},{"$nulls":6},{"v":1275,"d":"¥1,275.00"}]
[null,"セキュリティ",{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"v":600,"d":"¥600.00"},{"$nulls":6},{"v":3600,"d":"¥3,600.00"}]
[null,"小計",{"$f":"SUBTOTAL(109,OfficeActual[1 月])","v":{"v":11387,"d":"¥11,387.00"}},{"$f":"SUBTOTAL(109,OfficeActual[2 月])","v":{"v":11698,"d":"¥11,698.00"}},{"$f":"SUBTOTAL(109,OfficeActual[3 月])","v":{"v":11692,"d":"¥11,692.00"}},{"$f":"SUBTOTAL(109,OfficeActual[4 月])","v":{"v":11611,"d":"¥11,611.00"}},{"$f":"SUBTOTAL(109,OfficeActual[5 月])","v":{"v":11508,"d":"¥11,508.00"}},{"$f":"SUBTOTAL(109,OfficeActual[6 月])","v":{"v":11454,"d":"¥11,454.00"}},{"$f":"SUBTOTAL(109,OfficeActual[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[年])","v":{"v":69350,"d":"¥69,350.00"}}]
[]
["右のセルから始まるマーケティングの実際の費用の表にマーケティング費用を入力します。次の指示はセル A30 に表示されます。","マーケティング費用","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"Web サイト ホスティング",{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"$nulls":6},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"¥3,000.00"}}]
[null,"Web サイトの更新",{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":1500,"d":"¥1,500.00"},{"$nulls":6},{"v":2500,"d":"¥2,500.00"}]
[null,"資料の準備",{"v":4800,"d":"¥4,800.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":5500,"d":"¥5,500.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"v":10300,"d":"¥10,300.00"}]
[null,"資料の印刷",{"v":100,"d":"¥100.00"},{"v":500,"d":"¥500.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":600,"d":"¥600.00"},{"v":180,"d":"¥180.00"},{"$nulls":6},{"v":1580,"d":"¥1,580.00"}]
[null,"マーケティング イベント",{"v":1800,"d":"¥1,800.00"},{"v":2200,"d":"¥2,200.00"},{"v":2200,"d":"¥2,200.00"},{"v":4700,"d":"¥4,700.00"},{"v":1500,"d":"¥1,500.00"},{"v":2300,"d":"¥2,300.00"},{"$nulls":6},{"v":14700,"d":"¥14,700.00"}]
[null,"その他の経費",{"v":145,"d":"¥145.00"},{"v":156,"d":"¥156.00"},{"v":123,"d":"¥123.00"},{"v":223,"d":"¥223.00"},{"v":187,"d":"¥187.00"},{"v":245,"d":"¥245.00"},{"$nulls":6},{"v":1079,"d":"¥1,079.00"}]
[null,"小計",{"$f":"SUBTOTAL(109,MarketingActual[1 月])","v":{"v":7545,"d":"¥7,545.00"}},{"$f":"SUBTOTAL(109,MarketingActual[2 月])","v":{"v":3556,"d":"¥3,556.00"}},{"$f":"SUBTOTAL(109,MarketingActual[3 月])","v":{"v":3123,"d":"¥3,123.00"}},{"$f":"SUBTOTAL(109,MarketingActual[4 月])","v":{"v":11223,"d":"¥11,223.00"}},{"$f":"SUBTOTAL(109,MarketingActual[5 月])","v":{"v":2987,"d":"¥2,987.00"}},{"$f":"SUBTOTAL(109,MarketingActual[6 月])","v":{"v":4725,"d":"¥4,725.00"}},{"$f":"SUBTOTAL(109,MarketingActual[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[年])","v":{"v":33159,"d":"¥33,159.00"}}]
[]
["右のセルから始まるトレーニングおよびトレーニングの実際の費用の表にトレーニングまたは交通費を入力します。次の指示はセル A35 に表示されます。","トレーニング/交通費","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"トレーニング クラス",{"v":1600,"d":"¥1,600.00"},{"v":2400,"d":"¥2,400.00"},{"v":1400,"d":"¥1,400.00"},{"v":1600,"d":"¥1,600.00"},{"v":1200,"d":"¥1,200.00"},{"v":2800,"d":"¥2,800.00"},{"$nulls":6},{"$f":"SUM(C31:N31)","v":{"v":11000,"d":"¥11,000.00"}}]
[null,"トレーニング関連の交通費",{"v":1200,"d":"¥1,200.00"},{"v":2200,"d":"¥2,200.00"},{"v":1400,"d":"¥1,400.00"},{"v":1200,"d":"¥1,200.00"},{"v":800,"d":"¥800.00"},{"v":3500,"d":"¥3,500.00"},{"$nulls":6},{"$f":"SUM(C32:N32)","v":{"v":10300,"d":"¥10,300.00"}}]
[null,"小計",{"$f":"SUBTOTAL(109,TrainingAndTravelActual[1 月])","v":{"v":2800,"d":"¥2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[2 月])","v":{"v":4600,"d":"¥4,600.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[3 月])","v":{"v":2800,"d":"¥2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[4 月])","v":{"v":2800,"d":"¥2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[5 月])","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[6 月])","v":{"v":6300,"d":"¥6,300.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[年])","v":{"v":21300,"d":"¥21,300.00"}}]
[]
["実際の費用の集計は、右のセルから始まる実際の費用の合計の表で自動的に計算されます。","合計の計画された費用","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"月ごとの実際の費用",{"$f":"TrainingAndTravelActual[[#Totals],[1 月]]+MarketingActual[[#Totals],[1 月]]+OfficeActual[[#Totals],[1 月]]+EmployeeActual[[#Totals],[1 月]]","v":{"v":129682,"d":"¥129,682.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[2 月]]+MarketingActual[[#Totals],[2 月]]+OfficeActual[[#Totals],[2 月]]+EmployeeActual[[#Totals],[2 月]]","v":{"v":127804,"d":"¥127,804.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[3 月]]+MarketingActual[[#Totals],[3 月]]+OfficeActual[[#Totals],[3 月]]+EmployeeActual[[#Totals],[3 月]]","v":{"v":125565,"d":"¥125,565.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[4 月]]+MarketingActual[[#Totals],[4 月]]+OfficeActual[[#Totals],[4 月]]+EmployeeActual[[#Totals],[4 月]]","v":{"v":137394,"d":"¥137,394.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[5 月]]+MarketingActual[[#Totals],[5 月]]+OfficeActual[[#Totals],[5 月]]+EmployeeActual[[#Totals],[5 月]]","v":{"v":128255,"d":"¥128,255.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[6 月]]+MarketingActual[[#Totals],[6 月]]+OfficeActual[[#Totals],[6 月]]+EmployeeActual[[#Totals],[6 月]]","v":{"v":134239,"d":"¥134,239.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[7 月]]+MarketingActual[[#Totals],[7 月]]+OfficeActual[[#Totals],[7 月]]+EmployeeActual[[#Totals],[7 月]]","v":{"v":0,"d":"¥0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[8 月]]+MarketingActual[[#Totals],[8 月]]+OfficeActual[[#Totals],[8 月]]+EmployeeActual[[#Totals],[8 月]]","v":{"v":0,"d":"¥0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[9 月]]+MarketingActual[[#Totals],[9 月]]+OfficeActual[[#Totals],[9 月]]+EmployeeActual[[#Totals],[9 月]]","v":{"v":0,"d":"¥0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[10 月]]+MarketingActual[[#Totals],[10 月]]+OfficeActual[[#Totals],[10 月]]+EmployeeActual[[#Totals],[10 月]]","v":{"v":0,"d":"¥0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[11 月]]+MarketingActual[[#Totals],[11 月]]+OfficeActual[[#Totals],[11 月]]+EmployeeActual[[#Totals],[11 月]]","v":{"v":0,"d":"¥0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[12 月]]+MarketingActual[[#Totals],[12 月]]+OfficeActual[[#Totals],[12 月]]+EmployeeActual[[#Totals],[12 月]]","v":{"v":0,"d":"¥0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[年]]+MarketingActual[[#Totals],[年]]+OfficeActual[[#Totals],[年]]+EmployeeActual[[#Totals],[年]]","v":{"v":782939,"d":"¥782,939.00"}}]
[null,"実際の費用の集計",{"$f":"SUM($C$36:C36)","v":{"v":129682,"d":"¥129,682.00"}},{"$f":"SUM($C$36:D36)","v":{"v":257486,"d":"¥257,486.00"}},{"$f":"SUM($C$36:E36)","v":{"v":383051,"d":"¥383,051.00"}},{"$f":"SUM($C$36:F36)","v":{"v":520445,"d":"¥520,445.00"}},{"$f":"SUM($C$36:G36)","v":{"v":648700,"d":"¥648,700.00"}},{"$f":"SUM($C$36:H36)","v":{"v":782939,"d":"¥782,939.00"}},{"$f":"SUM($C$36:I36)","v":{"v":782939,"d":"¥782,939.00"}},{"$f":"SUM($C$36:J36)","v":{"v":782939,"d":"¥782,939.00"}},{"$f":"SUM($C$36:K36)","v":{"v":782939,"d":"¥782,939.00"}},{"$f":"SUM($C$36:L36)","v":{"v":782939,"d":"¥782,939.00"}},{"$f":"SUM($C$36:M36)","v":{"v":782939,"d":"¥782,939.00"}},{"$f":"SUM($C$36:N36)","v":{"v":782939,"d":"¥782,939.00"}}]

{"sheet":"経費差異","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["人件費、オフィス賃貸料、マーケティング費用、トレーニング費用、交通費の経費差異がこのワークシートのそれぞれの表で自動的に計算されます。このワークシートの役に立つ使用方法に関する説明がこの列のセルに表示されます。下向き矢印で開始します。",{"$nulls":14}," "]
["会社名は右のセルで自動的に更新されます。このワークシートのタイトルはセル K2 に表示されます。セル N2 にロゴを入力します。",{"$f":"計画された費用!B2:D3","v":"会社名"},{"$nulls":8},{"$f":"worksheet_title","v":"詳細経費見積"},null,null,"このセルにはロゴのプレースホルダーが表示されます。"]
["ヒントはセル K3 に表示されます。",{"$nulls":9},"網掛けされているセルが計算されます。"]
["右のセルに経費差異のラベルが表示され、セル C4 から N4 に月が、O4 に年のラベルが表示されます。","経費差異","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
["人件費の差異は、右のセルから始まる従業員の差異の表で自動的に計算されます。次の指示はセル A10 に表示されます。","人件費","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"給料",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[1 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[1 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[1 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[1 月]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[2 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[2 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[2 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[2 月]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[3 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[3 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[3 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[3 月]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[4 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[4 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[4 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[4 月]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"(¥500.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[5 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[5 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[5 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[5 月]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"(¥500.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[6 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[6 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[6 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[6 月]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"(¥500.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[7 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[7 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[7 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[7 月]],EmployeeActual[#Headers],0))","v":{"v":87500,"d":"¥87,500.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[8 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[8 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[8 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[8 月]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"¥92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[9 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[9 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[9 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[9 月]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"¥92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[10 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[10 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[10 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[10 月]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"¥92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[11 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[11 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[11 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[11 月]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"¥92,400.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[12 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[12 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[12 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[12 月]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"¥92,400.00"}},{"$f":"SUM(EmployeeVariances[[#This Row],[1 月]:[12 月]])","v":{"v":548000,"d":"¥548,000.00"}}]
[null,"利益",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[1 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[1 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[1 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[1 月]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[2 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[2 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[2 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[2 月]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[3 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[3 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[3 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[3 月]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[4 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[4 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[4 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[4 月]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"(¥135.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[5 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[5 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[5 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[5 月]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"(¥135.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[6 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[6 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[6 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[6 月]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"(¥135.00)"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[7 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[7 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[7 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[7 月]],EmployeeActual[#Headers],0))","v":{"v":23625,"d":"¥23,625.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[8 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[8 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[8 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[8 月]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"¥24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[9 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[9 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[9 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[9 月]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"¥24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[10 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[10 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[10 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[10 月]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"¥24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[11 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[11 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[11 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[11 月]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"¥24,948.00"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[12 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[12 月]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[12 月]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[12 月]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"¥24,948.00"}},{"$f":"SUM(EmployeeVariances[[#This Row],[1 月]:[12 月]])","v":{"v":147960,"d":"¥147,960.00"}}]
[null,"小計",{"$f":"SUBTOTAL(109,EmployeeVariances[1 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[2 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[3 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[4 月])","v":{"v":-635,"d":"(¥635.00)"}},{"$f":"SUBTOTAL(109,EmployeeVariances[5 月])","v":{"v":-635,"d":"(¥635.00)"}},{"$f":"SUBTOTAL(109,EmployeeVariances[6 月])","v":{"v":-635,"d":"(¥635.00)"}},{"$f":"SUBTOTAL(109,EmployeeVariances[7 月])","v":{"v":111125,"d":"¥111,125.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[8 月])","v":{"v":117348,"d":"¥117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[9 月])","v":{"v":117348,"d":"¥117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[10 月])","v":{"v":117348,"d":"¥117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[11 月])","v":{"v":117348,"d":"¥117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[12 月])","v":{"v":117348,"d":"¥117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[年])","v":{"v":695960,"d":"¥695,960.00"}}]
[]
["オフィス賃貸料の差異は、右のセルから始まるオフィスの差異の表で自動的に計算されます。次の指示はセル A21 に表示されます。","オフィス賃貸料","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"オフィスの賃貸",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"¥9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"¥9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"¥9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"¥9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"¥9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"¥9,800.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1 月]:[12 月]])","v":{"v":58800,"d":"¥58,800.00"}}]
[null,"ガス",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficeActual[#Headers],0))","v":{"v":-4,"d":"(¥4.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficeActual[#Headers],0))","v":{"v":-30,"d":"(¥30.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficeActual[#Headers],0))","v":{"v":15,"d":"¥15.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficeActual[#Headers],0))","v":{"v":-130,"d":"(¥130.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficeActual[#Headers],0))","v":{"v":13,"d":"¥13.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficeActual[#Headers],0))","v":{"v":12,"d":"¥12.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficeActual[#Headers],0))","v":{"v":100,"d":"¥100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficeActual[#Headers],0))","v":{"v":100,"d":"¥100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficeActual[#Headers],0))","v":{"v":100,"d":"¥100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficeActual[#Headers],0))","v":{"v":100,"d":"¥100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficeActual[#Headers],0))","v":{"v":400,"d":"¥400.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficeActual[#Headers],0))","v":{"v":400,"d":"¥400.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1 月]:[12 月]])","v":{"v":1076,"d":"¥1,076.00"}}]
[null,"電気",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficeActual[#Headers],0))","v":{"v":12,"d":"¥12.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficeActual[#Headers],0))","v":{"v":22,"d":"¥22.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficeActual[#Headers],0))","v":{"v":32,"d":"¥32.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficeActual[#Headers],0))","v":{"v":1,"d":"¥1.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficeActual[#Headers],0))","v":{"v":-6,"d":"(¥6.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficeActual[#Headers],0))","v":{"v":10,"d":"¥10.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficeActual[#Headers],0))","v":{"v":300,"d":"¥300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficeActual[#Headers],0))","v":{"v":300,"d":"¥300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficeActual[#Headers],0))","v":{"v":300,"d":"¥300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficeActual[#Headers],0))","v":{"v":300,"d":"¥300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficeActual[#Headers],0))","v":{"v":300,"d":"¥300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficeActual[#Headers],0))","v":{"v":300,"d":"¥300.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1 月]:[12 月]])","v":{"v":1871,"d":"¥1,871.00"}}]
[null,"水道",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficeActual[#Headers],0))","v":{"v":5,"d":"¥5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficeActual[#Headers],0))","v":{"v":7,"d":"¥7.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficeActual[#Headers],0))","v":{"v":6,"d":"¥6.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficeActual[#Headers],0))","v":{"v":4,"d":"¥4.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficeActual[#Headers],0))","v":{"v":6,"d":"¥6.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficeActual[#Headers],0))","v":{"v":4,"d":"¥4.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficeActual[#Headers],0))","v":{"v":40,"d":"¥40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficeActual[#Headers],0))","v":{"v":40,"d":"¥40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficeActual[#Headers],0))","v":{"v":40,"d":"¥40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficeActual[#Headers],0))","v":{"v":40,"d":"¥40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficeActual[#Headers],0))","v":{"v":40,"d":"¥40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficeActual[#Headers],0))","v":{"v":40,"d":"¥40.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1 月]:[12 月]])","v":{"v":272,"d":"¥272.00"}}]
[null,"電話",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficeActual[#Headers],0))","v":{"v":26,"d":"¥26.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficeActual[#Headers],0))","v":{"v":15,"d":"¥15.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficeActual[#Headers],0))","v":{"v":-15,"d":"(¥15.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficeActual[#Headers],0))","v":{"v":5,"d":"¥5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficeActual[#Headers],0))","v":{"v":5,"d":"¥5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficeActual[#Headers],0))","v":{"v":30,"d":"¥30.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficeActual[#Headers],0))","v":{"v":250,"d":"¥250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficeActual[#Headers],0))","v":{"v":250,"d":"¥250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficeActual[#Headers],0))","v":{"v":250,"d":"¥250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficeActual[#Headers],0))","v":{"v":250,"d":"¥250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficeActual[#Headers],0))","v":{"v":250,"d":"¥250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficeActual[#Headers],0))","v":{"v":250,"d":"¥250.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1 月]:[12 月]])","v":{"v":1566,"d":"¥1,566.00"}}]
[null,"インターネット アクセス",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficeActual[#Headers],0))","v":{"v":180,"d":"¥180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficeActual[#Headers],0))","v":{"v":180,"d":"¥180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficeActual[#Headers],0))","v":{"v":180,"d":"¥180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficeActual[#Headers],0))","v":{"v":180,"d":"¥180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficeActual[#Headers],0))","v":{"v":180,"d":"¥180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficeActual[#Headers],0))","v":{"v":180,"d":"¥180.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1 月]:[12 月]])","v":{"v":1080,"d":"¥1,080.00"}}]
[null,"事務用品",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"(¥56.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficeActual[#Headers],0))","v":{"v":58,"d":"¥58.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficeActual[#Headers],0))","v":{"v":40,"d":"¥40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficeActual[#Headers],0))","v":{"v":-21,"d":"(¥21.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"(¥56.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficeActual[#Headers],0))","v":{"v":-40,"d":"(¥40.00)"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficeActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficeActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficeActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficeActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficeActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficeActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1 月]:[12 月]])","v":{"v":1125,"d":"¥1,125.00"}}]
[null,"セキュリティ",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[1 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[1 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[2 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[2 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[3 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[3 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[4 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[4 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[5 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[5 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[6 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[6 月]],OfficeActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[7 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[7 月]],OfficeActual[#Headers],0))","v":{"v":600,"d":"¥600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[8 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[8 月]],OfficeActual[#Headers],0))","v":{"v":600,"d":"¥600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[9 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[9 月]],OfficeActual[#Headers],0))","v":{"v":600,"d":"¥600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[10 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[10 月]],OfficeActual[#Headers],0))","v":{"v":600,"d":"¥600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[11 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[11 月]],OfficeActual[#Headers],0))","v":{"v":600,"d":"¥600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[12 月]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[12 月]],OfficeActual[#Headers],0))","v":{"v":600,"d":"¥600.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[1 月]:[12 月]])","v":{"v":3600,"d":"¥3,600.00"}}]
[null,"小計",{"$f":"SUBTOTAL(109,OfficeVariances[1 月])","v":{"v":-17,"d":"(¥17.00)"}},{"$f":"SUBTOTAL(109,OfficeVariances[2 月])","v":{"v":72,"d":"¥72.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[3 月])","v":{"v":78,"d":"¥78.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[4 月])","v":{"v":-141,"d":"(¥141.00)"}},{"$f":"SUBTOTAL(109,OfficeVariances[5 月])","v":{"v":-38,"d":"(¥38.00)"}},{"$f":"SUBTOTAL(109,OfficeVariances[6 月])","v":{"v":16,"d":"¥16.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[7 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[8 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[9 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[10 月])","v":{"v":11470,"d":"¥11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[11 月])","v":{"v":11770,"d":"¥11,770.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[12 月])","v":{"v":11770,"d":"¥11,770.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[年])","v":{"v":69390,"d":"¥69,390.00"}}]
[]
["マーケティング費用の差異は、右のセルから始まるマーケティングの差異の表で自動的に計算されます。次の指示はセル A30 に表示されます。","マーケティング費用","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"Web サイト ホスティング",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingActual[#Headers],0))","v":{"v":500,"d":"¥500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingActual[#Headers],0))","v":{"v":500,"d":"¥500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingActual[#Headers],0))","v":{"v":500,"d":"¥500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingActual[#Headers],0))","v":{"v":500,"d":"¥500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingActual[#Headers],0))","v":{"v":500,"d":"¥500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingActual[#Headers],0))","v":{"v":500,"d":"¥500.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1 月]:[12 月]])","v":{"v":3000,"d":"¥3,000.00"}}]
[null,"Web サイトの更新",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"(¥500.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingActual[#Headers],0))","v":{"v":1000,"d":"¥1,000.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1 月]:[12 月]])","v":{"v":1500,"d":"¥1,500.00"}}]
[null,"資料の準備",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"(¥500.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"¥5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"¥5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingActual[#Headers],0))","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1 月]:[12 月]])","v":{"v":9700,"d":"¥9,700.00"}}]
[null,"資料の印刷",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingActual[#Headers],0))","v":{"v":100,"d":"¥100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"(¥300.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingActual[#Headers],0))","v":{"v":100,"d":"¥100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingActual[#Headers],0))","v":{"v":100,"d":"¥100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingActual[#Headers],0))","v":{"v":-400,"d":"(¥400.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingActual[#Headers],0))","v":{"v":20,"d":"¥20.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1 月]:[12 月]])","v":{"v":820,"d":"¥820.00"}}]
[null,"マーケティング イベント",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"(¥200.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"(¥200.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingActual[#Headers],0))","v":{"v":300,"d":"¥300.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingActual[#Headers],0))","v":{"v":500,"d":"¥500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"(¥300.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"¥5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"¥5,000.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1 月]:[12 月]])","v":{"v":18300,"d":"¥18,300.00"}}]
[null,"その他の経費",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[1 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[1 月]],MarketingActual[#Headers],0))","v":{"v":55,"d":"¥55.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[2 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[2 月]],MarketingActual[#Headers],0))","v":{"v":44,"d":"¥44.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[3 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[3 月]],MarketingActual[#Headers],0))","v":{"v":77,"d":"¥77.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[4 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[4 月]],MarketingActual[#Headers],0))","v":{"v":-23,"d":"(¥23.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[5 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[5 月]],MarketingActual[#Headers],0))","v":{"v":13,"d":"¥13.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[6 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[6 月]],MarketingActual[#Headers],0))","v":{"v":-45,"d":"(¥45.00)"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[7 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[7 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[8 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[8 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[9 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[9 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[10 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[10 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[11 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[11 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[12 月]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[12 月]],MarketingActual[#Headers],0))","v":{"v":200,"d":"¥200.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[1 月]:[12 月]])","v":{"v":1321,"d":"¥1,321.00"}}]
[null,"小計",{"$f":"SUBTOTAL(109,MarketingVariances[1 月])","v":{"v":555,"d":"¥555.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[2 月])","v":{"v":-456,"d":"(¥456.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[3 月])","v":{"v":-23,"d":"(¥23.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[4 月])","v":{"v":-123,"d":"(¥123.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[5 月])","v":{"v":113,"d":"¥113.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[6 月])","v":{"v":-825,"d":"(¥825.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[7 月])","v":{"v":8100,"d":"¥8,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[8 月])","v":{"v":6100,"d":"¥6,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[9 月])","v":{"v":3100,"d":"¥3,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[10 月])","v":{"v":8100,"d":"¥8,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[11 月])","v":{"v":3100,"d":"¥3,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[12 月])","v":{"v":6900,"d":"¥6,900.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[年])","v":{"v":34641,"d":"¥34,641.00"}}]
[]
["トレーニングおよび交通費の差異は、右のセルから始まるトレーニングおよび交通費の差異の表で自動的に計算されます。次の指示はセル A35 に表示されます。","トレーニング/交通費","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"トレーニング クラス",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[1 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[1 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[1 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[1 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"¥400.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[2 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[2 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[2 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[2 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":-400,"d":"(¥400.00)"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[3 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[3 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[3 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[3 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"¥600.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[4 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[4 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[4 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[4 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"¥400.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[5 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[5 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[5 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[5 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"¥800.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[6 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[6 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[6 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[6 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":-800,"d":"(¥800.00)"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[7 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[7 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[7 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[7 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[8 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[8 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[8 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[8 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[9 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[9 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[9 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[9 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[10 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[10 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[10 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[10 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[11 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[11 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[11 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[11 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[12 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[12 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[12 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[12 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[1 月]:[12 月]])","v":{"v":13000,"d":"¥13,000.00"}}]
[null,"トレーニング関連の交通費",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[1 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[1 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[1 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[1 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"¥800.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[2 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[2 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[2 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[2 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":-200,"d":"(¥200.00)"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[3 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[3 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[3 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[3 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"¥600.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[4 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[4 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[4 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[4 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"¥800.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[5 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[5 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[5 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[5 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":1200,"d":"¥1,200.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[6 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[6 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[6 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[6 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":-1500,"d":"(¥1,500.00)"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[7 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[7 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[7 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[7 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[8 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[8 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[8 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[8 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[9 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[9 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[9 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[9 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[10 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[10 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[10 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[10 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[11 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[11 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[11 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[11 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[12 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[12 月]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[12 月]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[12 月]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[1 月]:[12 月]])","v":{"v":13700,"d":"¥13,700.00"}}]
[null,"小計",{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[1 月])","v":{"v":1200,"d":"¥1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[2 月])","v":{"v":-600,"d":"(¥600.00)"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[3 月])","v":{"v":1200,"d":"¥1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[4 月])","v":{"v":1200,"d":"¥1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[5 月])","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[6 月])","v":{"v":-2300,"d":"(¥2,300.00)"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[7 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[8 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[9 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[10 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[11 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[12 月])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[年])","v":{"v":26700,"d":"¥26,700.00"}}]
[]
["経費差異は、右のセルから始まる合計の差異の表で自動的に計算されます。","集計","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年"]
[null,"月ごとの実際の費用",{"$f":"TrainingAndTravelVariances[[#Totals],[1 月]]+MarketingVariances[[#Totals],[1 月]]+OfficeVariances[[#Totals],[1 月]]+EmployeeVariances[[#Totals],[1 月]]","v":{"v":1738,"d":"¥1,738.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[2 月]]+MarketingVariances[[#Totals],[2 月]]+OfficeVariances[[#Totals],[2 月]]+EmployeeVariances[[#Totals],[2 月]]","v":{"v":-984,"d":"(¥984.00)"}},{"$f":"TrainingAndTravelVariances[[#Totals],[3 月]]+MarketingVariances[[#Totals],[3 月]]+OfficeVariances[[#Totals],[3 月]]+EmployeeVariances[[#Totals],[3 月]]","v":{"v":1255,"d":"¥1,255.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[4 月]]+MarketingVariances[[#Totals],[4 月]]+OfficeVariances[[#Totals],[4 月]]+EmployeeVariances[[#Totals],[4 月]]","v":{"v":301,"d":"¥301.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[5 月]]+MarketingVariances[[#Totals],[5 月]]+OfficeVariances[[#Totals],[5 月]]+EmployeeVariances[[#Totals],[5 月]]","v":{"v":1440,"d":"¥1,440.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[6 月]]+MarketingVariances[[#Totals],[6 月]]+OfficeVariances[[#Totals],[6 月]]+EmployeeVariances[[#Totals],[6 月]]","v":{"v":-3744,"d":"(¥3,744.00)"}},{"$f":"TrainingAndTravelVariances[[#Totals],[7 月]]+MarketingVariances[[#Totals],[7 月]]+OfficeVariances[[#Totals],[7 月]]+EmployeeVariances[[#Totals],[7 月]]","v":{"v":134695,"d":"¥134,695.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[8 月]]+MarketingVariances[[#Totals],[8 月]]+OfficeVariances[[#Totals],[8 月]]+EmployeeVariances[[#Totals],[8 月]]","v":{"v":138918,"d":"¥138,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[9 月]]+MarketingVariances[[#Totals],[9 月]]+OfficeVariances[[#Totals],[9 月]]+EmployeeVariances[[#Totals],[9 月]]","v":{"v":135918,"d":"¥135,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[10 月]]+MarketingVariances[[#Totals],[10 月]]+OfficeVariances[[#Totals],[10 月]]+EmployeeVariances[[#Totals],[10 月]]","v":{"v":140918,"d":"¥140,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[11 月]]+MarketingVariances[[#Totals],[11 月]]+OfficeVariances[[#Totals],[11 月]]+EmployeeVariances[[#Totals],[11 月]]","v":{"v":136218,"d":"¥136,218.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[12 月]]+MarketingVariances[[#Totals],[12 月]]+OfficeVariances[[#Totals],[12 月]]+EmployeeVariances[[#Totals],[12 月]]","v":{"v":140018,"d":"¥140,018.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[年]]+MarketingVariances[[#Totals],[年]]+OfficeVariances[[#Totals],[年]]+EmployeeVariances[[#Totals],[年]]","v":{"v":826691,"d":"¥826,691.00"}}]
[null,"実際の費用の合計",{"$f":"SUM($C$36:C36)","v":{"v":1738,"d":"¥1,738.00"}},{"$f":"SUM($C$36:D36)","v":{"v":754,"d":"¥754.00"}},{"$f":"SUM($C$36:E36)","v":{"v":2009,"d":"¥2,009.00"}},{"$f":"SUM($C$36:F36)","v":{"v":2310,"d":"¥2,310.00"}},{"$f":"SUM($C$36:G36)","v":{"v":3750,"d":"¥3,750.00"}},{"$f":"SUM($C$36:H36)","v":{"v":6,"d":"¥6.00"}},{"$f":"SUM($C$36:I36)","v":{"v":134701,"d":"¥134,701.00"}},{"$f":"SUM($C$36:J36)","v":{"v":273619,"d":"¥273,619.00"}},{"$f":"SUM($C$36:K36)","v":{"v":409537,"d":"¥409,537.00"}},{"$f":"SUM($C$36:L36)","v":{"v":550455,"d":"¥550,455.00"}},{"$f":"SUM($C$36:M36)","v":{"v":686673,"d":"¥686,673.00"}},{"$f":"SUM($C$36:N36)","v":{"v":826691,"d":"¥826,691.00"}}]

{"sheet":"費用の分析","index":4,"n_rows":14,"n_cols":16,"rows_kept":14,"merged":[[1,1,2,3],[1,5,1,6],[2,4,2,6],[11,1,11,2],[11,3,11,5],[13,1,36,5]]}
["このワークシートの各経費カテゴリの年ごとの計画された費用と実際の費用、経費差異、および差異率は自動的に更新されます。このワークシートの役に立つ使用方法に関する説明がこの列のセルに表示されます。下向き矢印で開始します。 ",{"$nulls":5}," ",{"$nulls":8}," "]
["会社名は右のセルで自動的に更新されます。セル F2 にロゴを入力します。",{"$f":"計画された費用!B2:D3","v":"会社名"},{"$nulls":3},"このセルにはロゴのプレースホルダーが表示されます。"]
["このワークシートのタイトルは、セル E3 に表示されます。次の指示はセル A5 に表示されます。",{"$nulls":3},{"$f":"worksheet_title","v":"詳細経費見積"}]
[]
["計画された費用、実際の費用、経費差異、差異率が右のセルから始まる分析の表で自動的に計算されます。次の指示はセル A12 に表示されます。","経費カテゴリ","計画された費用","実際の費用","経費差異","差異率"]
[null,"人件費",{"$f":"EmployeePlan[[#Totals],[年]]","v":{"v":1355090,"d":"¥1,355,090.00"}},{"$f":"EmployeeActual[[#Totals],[年]]","v":{"v":659130,"d":"¥659,130.00"}},{"$f":"C6-D6","v":{"v":695960,"d":"¥695,960.00"}},{"$f":"E6/C6","v":{"v":0.5135895032802249,"d":"51%"}}]
[null,{"$f":"計画された費用!B10","v":"オフィス賃貸料"},{"$f":"OfficePlan[[#Totals],[年]]","v":{"v":138740,"d":"¥138,740.00"}},{"$f":"OfficeActual[[#Totals],[年]]","v":{"v":69350,"d":"¥69,350.00"}},{"$f":"C7-D7","v":{"v":69390,"d":"¥69,390.00"}},{"$f":"E7/C7","v":{"v":0.5001441545336601,"d":"50%"}}]
[null,{"$f":"計画された費用!B21","v":"マーケティング費用"},{"$f":"MarketingPlan[[#Totals],[年]]","v":{"v":67800,"d":"¥67,800.00"}},{"$f":"MarketingActual[[#Totals],[年]]","v":{"v":33159,"d":"¥33,159.00"}},{"$f":"C8-D8","v":{"v":34641,"d":"¥34,641.00"}},{"$f":"E8/C8","v":{"v":0.510929203539823,"d":"51%"}}]
[null,{"$f":"計画された費用!B30","v":"トレーニング/交通費"},{"$f":"TrainingAndTravelPlan[[#Totals],[年]]","v":{"v":48000,"d":"¥48,000.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[年]]","v":{"v":21300,"d":"¥21,300.00"}},{"$f":"C9-D9","v":{"v":26700,"d":"¥26,700.00"}},{"$f":"E9/C9","v":{"v":0.55625,"d":"56%"}}]
[null,{"$f":"計画された費用!B35","v":"集計"},{"$f":"計画された費用!O36","v":{"v":1609630,"d":"¥1,609,630.00"}},{"$f":"実際の費用!O36","v":{"v":782939,"d":"¥782,939.00"}},{"$f":"C10-D10","v":{"v":826691,"d":"¥826,691.00"}},{"$f":"E10/C10","v":{"v":0.5135907009685455,"d":"51%"}}]
[]
["計画された費用の円グラフが右のセルに表示され、実際の費用の円グラフがセル D12 に表示されます。次の指示はセル A14 に表示されます。","さまざまなカテゴリの計画された費用を示す円グラフがこのセルに表示されます。",null,"さまざまなカテゴリで発生した実際の費用を示す円グラフがこのセルに表示されます。"]
[]
["月ごとの計画された費用、実際の費用、および差異を示すグラフが右のセルに表示されます。"]