{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["花园预算","清单"],"not_rendered":{"charts":2,"images":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"花园预算","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[0,1,0,6],[0,8,3,8],[0,9,3,9],[1,3,6,6],[4,8,6,9]]}
[null,"花园预算",{"$nulls":6},"此单元格中是按类型筛选花园预算的切片器。","此单元格中是按植物筛选花园预算的切片器。"]
[null,"预算金额","此单元格中的饼图显示了预算金额与总成本的对比。植物费用图表位于右侧的单元格中。","此单元格中的柱形图显示植物费用。单元格 I1 和 J1 中是按类型和植物筛选花园预算的切片器，信息位于右侧的单元格 I5 中。"]
[null,{"v":290,"d":"¥290.00"}]
[null,"总成本",{"$f":"BudgetedAmount","v":{"v":290,"d":"¥290.00"}}]
[null,{"$f":"SUM(GardenBudget[总计])","v":{"v":231.94,"d":"¥231.94"}},{"$f":"TotalCosts","v":{"v":231.94,"d":"¥231.94"}},{"$nulls":5},"信息：若要在数据表中新增一行，请选择该表右下方的单元格（位于汇总行上方），然后按 Tab 键。"]
[null,"差额"]
[null,{"$f":"BudgetedAmount-TotalCosts","v":{"v":58.06,"d":"¥58.06"}}]
[null,"类型","植物","说明","数量","成本","总计"]
[null,"植物","杜鹃花","常青型生花植物",2,{"v":35,"d":"¥35.00"},{"$f":"GardenBudget[[#This Row],[数量]]*GardenBudget[[#This Row],[成本]]","v":{"v":70,"d":"¥70.00"}}]
[null,"花朵","矮牵牛花","一年开花一次，分紫色和白色",6,{"v":1.99,"d":"¥1.99"},{"$f":"GardenBudget[[#This Row],[数量]]*GardenBudget[[#This Row],[成本]]","v":{"v":11.94,"d":"¥11.94"}}]
[null,"树","日本枫树","多叶树",1,{"v":150,"d":"¥150.00"},{"$f":"GardenBudget[[#This Row],[数量]]*GardenBudget[[#This Row],[成本]]","v":{"v":150,"d":"¥150.00"}}]
[{"$nulls":6},{"$f":"GardenBudget[[#This Row],[数量]]*GardenBudget[[#This Row],[成本]]","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":6},{"$f":"GardenBudget[[#This Row],[数量]]*GardenBudget[[#This Row],[成本]]","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":6},{"$f":"GardenBudget[[#This Row],[数量]]*GardenBudget[[#This Row],[成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"植物总计",{"$nulls":4},{"$f":"SUBTOTAL(109,GardenBudget[总计])","v":{"v":231.94,"d":"¥231.94"}}]

{"sheet":"清单","index":1,"n_rows":13,"n_cols":2,"rows_kept":13}
[null,"园区"]
[null,"类型"]
[null,"植物"]
[null,"花朵"]
[null,"树"]
[null,"种子"]
[null,"肥料"]
[null,"土料"]
[null,"护根"]
[null,"肥料/堆肥"]
[null,"除草剂/杀虫剂"]
[null,"栅栏材料"]
[null,"设备/雕像"]