{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["月々の食費の予算","実際の支出"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"月々の食費の予算","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"merged":[[3,4,3,6],[5,1,5,3],[5,4,5,6],[7,1,7,2],[8,1,8,2],[9,1,9,2]]}
[{"$nulls":7}," "]
[]
[null,"予算対象月",null,null,{"$f":"\"既に使われた予算の割合:  \"&TEXT(E4,\"0%\")","v":"既に使われた予算の割合:  35%"}]
[null,{"$f":"TEXT(NOW(),\"m月\")","v":"5月"},null,null,{"$f":"E6/B6","v":0.3508695652173913}]
[null,"月々の食費の予算の合計",null,null,"支払済金額"]
[null,{"$f":"SUM(D9:G9)","v":{"v":575,"d":"¥575"}},null,null,{"$f":"SUM(D10:G10)","v":{"v":201.75,"d":"¥202"}}]
[]
[{"$nulls":3},"食料品","外食","軽食","その他"]
[null,"毎月の予算",null,{"v":325,"d":"¥325"},{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"v":50,"d":"¥50"}]
[null,"実際の支出",null,{"$f":"SUMIF(テーブル_実際の食費[カテゴリ],月々の食費の予算!D8,テーブル_実際の食費[コスト])","v":{"v":175,"d":"¥175"}},{"$f":"SUMIF(テーブル_実際の食費[カテゴリ],月々の食費の予算!E8,テーブル_実際の食費[コスト])","v":{"v":0,"d":"¥0"}},{"$f":"SUMIF(テーブル_実際の食費[カテゴリ],月々の食費の予算!F8,テーブル_実際の食費[コスト])","v":{"v":16.75,"d":"¥17"}},{"$f":"SUMIF(テーブル_実際の食費[カテゴリ],月々の食費の予算!G8,テーブル_実際の食費[コスト])","v":{"v":10,"d":"¥10"}}]

{"sheet":"実際の支出","index":1,"n_rows":6,"n_cols":6,"rows_kept":6}
[null,"実際の食費",{"$nulls":3}," "]
[null,"日付","コスト","カテゴリ","備考"]
[null,{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),F3)","v":"2022-05-01"},{"v":175,"d":"¥175.00"},"食料品",null,1]
[null,"2022-05-05",{"v":4.75,"d":"¥4.75"},"軽食",null,5]
[null,"2022-05-07",{"v":12,"d":"¥12.00"},"軽食",null,7]
[null,"2022-05-08",{"v":10,"d":"¥10.00"},"その他",null,8]