{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["開始","予算ホイール","Data"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"テンプレート情報"]
[null,"このテンプレートを使用して、毎月の費用と貯蓄を把握してください。"]
[null,"貯蓄を計算するには、テーブルに経費明細を入力し、月収を入力します。"]
[null,"経費と貯蓄を示すドーナツグラフは自動的に更新されます。"]
[null,"注意:"]
[null,"予算ホイールワークシートのA列に追加の説明があります。このテキストは意図的に非表示になっています。テキストを削除するには、A列を選択してから削除を選択します。テキストの表示を解除するには、A列を選択してからフォントの色を変更します。"]
[null,"テーブルの詳細については、テーブル内でShiftキーを押しながらF10キーを押し、テーブルオプションを選択してから代替テキストを選択します。"]

{"sheet":"予算ホイール","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[0,1,0,2],[0,3,0,6],[1,2,4,4]]}
["このワークシートに予算ホイールを作成します。ワークシートのタイトルは、セルD1内の右端および先端にあります。このワークシートの使用方法に関するその他の有益な指示は、この列のセルにあります。矢印を押して開始します。","予算ホイール",null,"このテンプレートのテーブルに記入してください。グラフはあなたの月収に関連してあなたの毎月の支出をグラフ化します。また、節約する/節約した度合いを示すパーセンテージも計算されます。"]
["月額収入ラベルは右のセルにあり、ドーナツグラフにはセルC2の費用と貯蓄額、セルG2の貯蓄額ラベルが表示されます。","月額収入","費用と貯蓄率を示すドーナツグラフがこのセルにあります。",{"$nulls":3},"貯蓄金額"]
["右のセルに月額収入を入力します。貯蓄金額はセルG3で自動的に計算されます。次の説明はセルA6にあります。",{"v":5738,"d":"¥5,738"},{"$nulls":4},{"$f":"Savings","v":{"v":2777,"d":"¥2,777"}}]
[{"$nulls":6},"自動的に計算さ\nれる値"]
[]
["費用テーブルの詳細をセルの右側から入力してください。","費用","カテゴリ","額","頻度","月額","合計に占め\nる割合 (%)"]
[null,"保険","運送",{"v":300,"d":"¥300"},"6ヶ月ごと",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":50,"d":"¥50"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.00871383757406762,"d":"1%"}}]
[null,"ガス","運送",{"v":25,"d":"¥25"},"週単位",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"¥100"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"自動車の支払い","運送",{"v":200,"d":"¥200"},"月次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":200,"d":"¥200"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.03485535029627048,"d":"3%"}}]
[null,"住宅ローン","自宅",{"v":1600,"d":"¥1,600"},"月次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":1600,"d":"¥1,600"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.27884280237016384,"d":"28%"}}]
[null,"ケーブル","自宅",{"v":60,"d":"¥60"},"月次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"¥60"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"映画の日","エンターテインメント",{"v":70,"d":"¥70"},"月次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"¥70"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.012199372603694667,"d":"1%"}}]
[null,"スニーカー","その他",{"v":300,"d":"¥300"},"年次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":25,"d":"¥25"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.00435691878703381,"d":"0%"}}]
[null,"ドッグフード","その他",{"v":60,"d":"¥60"},"月次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"¥60"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"ペット保険","その他",{"v":70,"d":"¥70"},"年次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":6,"d":"¥6"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":1.0456605088881143E-3,"d":"0%"}}]
[null,"食料品","食事",{"v":100,"d":"¥100"},"週単位",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":400,"d":"¥400"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.06971070059254096,"d":"7%"}}]
[null,"コーヒー","食事",{"v":25,"d":"¥25"},"週単位",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"¥100"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"登山用具","エンターテインメント",{"v":170,"d":"¥170"},"年次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":14,"d":"¥14"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":2.4398745207389336E-3,"d":"0%"}}]
[null,"ジムの会員資格","その他",{"v":60,"d":"¥60"},"月次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"¥60"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"ヘッドフォン","エンターテインメント",{"v":50,"d":"¥50"},"年次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":4,"d":"¥4"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":6.9710700592540956E-4,"d":"0%"}}]
[null,"散髪","その他",{"v":70,"d":"¥70"},"月次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"¥70"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.012199372603694667,"d":"1%"}}]
[null,"ビデオゲーム","エンターテインメント",{"v":100,"d":"¥100"},"月次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"¥100"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"被服","その他",{"v":500,"d":"¥500"},"年次",{"$f":"IF(Expenses[[#This Row],[額]]>0,IF(Expenses[[#This Row],[頻度]]<>\"\",ROUND(IF(Expenses[[#This Row],[頻度]]=\"月次\",Expenses[額],IF(Expenses[[#This Row],[頻度]]=\"週単位\",Expenses[[#This Row],[額]]*4,IF(Expenses[[#This Row],[頻度]]=\"四半期ごと\",Expenses[[#This Row],[額]]/3,IF(Expenses[[#This Row],[頻度]]=\"6ヶ月ごと\",Expenses[[#This Row],[額]]/6,IF(Expenses[[#This Row],[頻度]]=\"年次\",Expenses[[#This Row],[額]]/12,IF(Expenses[[#This Row],[頻度]]=\"一週おき\",Expenses[[#This Row],[額]]*2,IF(Expenses[[#This Row],[頻度]]=\"一月おき\",Expenses[[#This Row],[額]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":42,"d":"¥42"}},{"$f":"IF(Expenses[[#This Row],[月額]]<>\"\",Expenses[[#This Row],[月額]]/Income,\"\")","v":{"v":7.3196235622168E-3,"d":"1%"}}]

{"sheet":"Data","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"hidden":true}
["このシートは非表示のままにする"]
["カテゴリー","カテゴリーごとの金額","合計に占める割合 (%)","頻度","節約"]
["自宅",{"$f":"IF(SUMIF(Expenses[カテゴリ],\"自宅\",Expenses[月額])>0,SUMIF(Expenses[カテゴリ],\"自宅\",Expenses[月額]),NA())","v":{"v":1660,"d":"¥1,660"}},{"$f":"IF(B3>0,B3/Income,\"\")","v":{"v":0.289299407459045,"d":"29%"}},"週単位",{"$f":"Income-SUM(Expenses[月額])","v":{"v":2777,"d":"¥2,777"}}]
["エンターテインメント",{"$f":"IF(SUMIF(Expenses[カテゴリ],\"エンターテインメント\",Expenses[月額])>0,SUMIF(Expenses[カテゴリ],\"エンターテインメント\",Expenses[月額]),NA())","v":{"v":188,"d":"¥188"}},{"v":0.03276402927849425,"d":"3%"},"月次"]
["運送",{"$f":"IF(SUMIF(Expenses[カテゴリ],\"運送\",Expenses[月額])>0,SUMIF(Expenses[カテゴリ],\"運送\",Expenses[月額]),NA())","v":{"v":350,"d":"¥350"}},{"v":0.06099686301847333,"d":"6%"},"四半期ごと"]
["食事",{"$f":"IF(SUMIF(Expenses[カテゴリ],\"食事\",Expenses[月額])>0,SUMIF(Expenses[カテゴリ],\"食事\",Expenses[月額]),NA())","v":{"v":500,"d":"¥500"}},{"v":0.08713837574067619,"d":"9%"},"6ヶ月ごと"]
["その他",{"$f":"IF(SUMIF(Expenses[カテゴリ],\"その他\",Expenses[月額])>0,SUMIF(Expenses[カテゴリ],\"その他\",Expenses[月額]),NA())","v":{"v":263,"d":"¥263"}},{"v":0.04583478563959568,"d":"5%"},"年次"]
["節約",{"$f":"IF(E3>0,E3,NA())","v":{"v":2777,"d":"¥2,777"}},{"v":0.4839665388637156,"d":"48%"},"一週おき"]
[{"$nulls":3},"一月おき"]
[null,"合計：",{"$f":"SUM(C3:C8)","v":{"v":1,"d":"100%"}}]