{"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,1,3,3],[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":"10月"},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":"2019-10-01"},{"v":175,"d":"¥175.00"},"日用杂货",null,1]
[null,{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),F4)","v":"2019-10-05"},{"v":4.75,"d":"¥4.75"},"零食",null,5]
[null,{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),F5)","v":"2019-10-07"},{"v":12,"d":"¥12.00"},"零食",null,7]
[null,{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),F6)","v":"2019-10-08"},{"v":10,"d":"¥10.00"},"其他",null,8]