{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["购物清单","预算细目","待办事项列表","共享列表"],"not_rendered":{"charts":2,"images":2,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"购物清单","index":0,"n_rows":25,"n_cols":8,"rows_kept":25,"merged":[[2,1,2,7],[3,1,3,2]]}
[null,"返校","规划表"]
[]
[null,"根据在预算细目中输入的预算类别金额跟踪购物进度。"]
[null,"预算摘要",null,null,{"$f":"\"购买进度 (\"&COUNTIFS(清单[已购], \">0\")&\" ， \"&COUNTIFS(清单[待购], \">0\")&\")\"","v":"购买进度 (1 ， 6)"}]
[null,"预算",{"v":1500,"d":"¥1,500.00"},null,{"$f":"IFERROR(COUNTIFS(清单[待购],\">0\",清单[已购],\">0\")/SumItemsToBuy,0)","v":{"v":0.16666666666666666,"d":"17%"}}]
[null,"购物清单总计",{"$f":"IFERROR(SUM(ChecklistTotal), \"\")","v":{"v":365,"d":"¥365.00"}}]
[null,"剩余现金",{"$f":"IFERROR(C5-C6, \"\")","v":{"v":1135,"d":"¥1,135.00"}}]
[null,"购物清单"]
[null,"项目","类别","数量","待购","费用","已购","总费用"]
[null,"数学","教科书",1,1,{"v":55,"d":"¥55.00"},1,{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":{"v":55,"d":"¥55.00"}}]
[null,"英语","教科书",1,1,null,null,{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"背包","日用品",1,null,{"v":30,"d":"¥30.00"},null,{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":{"v":30,"d":"¥30.00"}}]
[null,"计算器","日用品",1,{"$nulls":3},{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"荧光笔","日用品",3,{"$nulls":3},{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"制服","服装",2,1,{"v":100,"d":"¥100.00"},null,{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":{"v":200,"d":"¥200.00"}}]
[null,"衬衫","服装",4,{"$nulls":3},{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"T 恤衫","服装",5,{"$nulls":3},{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"短裤","服装",2,{"$nulls":3},{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"运动鞋","服装",2,1,null,null,{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"短袜","服装",10,{"$nulls":3},{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"春季夹克","服装",1,1,{"v":80,"d":"¥80.00"},null,{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":{"v":80,"d":"¥80.00"}}]
[null,"毛衣","服装",1,{"$nulls":3},{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"运动衫","服装",1,{"$nulls":3},{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"内衣","服装",10,{"$nulls":3},{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]
[null,"冬季夹克","服装",1,1,null,null,{"$f":"IFERROR(清单[[#This Row],[数量]]*清单[[#This Row],[费用]], \"\")","v":0}]

{"sheet":"预算细目","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,"预算细目"]
[null,"添加类别和预算金额，据此在购物清单中进行跟踪。"]
[null,"类别","总费用"]
[null,"服装",{"$f":"IFERROR(SUMIFS(清单[总费用],清单[类别],类别[[#This Row],[类别]]), \"\")","v":{"v":280,"d":"¥280.00"}}]
[null,"日用品",{"$f":"IFERROR(SUMIFS(清单[总费用],清单[类别],类别[[#This Row],[类别]]), \"\")","v":{"v":30,"d":"¥30.00"}}]
[null,"教科书",{"$f":"IFERROR(SUMIFS(清单[总费用],清单[类别],类别[[#This Row],[类别]]), \"\")","v":{"v":55,"d":"¥55.00"}}]

{"sheet":"待办事项列表","index":2,"n_rows":22,"n_cols":3,"rows_kept":22}
[null,"待办事项列表"]
[null,"跟踪开学前需要完成的所有活动。"]
[null,"已完成","任务"]
[null,"x","完成所有的登记表格"]
[null,null,"如果需要，安排学校健康体检和视力检查"]
[null,null,"验证所有必需的免疫接种"]
[null,null,"从医师处获得所需药物的剂量说明等注意事项"]
[null,null,"查看学校着装要求"]
[null,null,"获得学校用品清单"]
[null,null,"与老师见面沟通"]
[null,null,"确定教师的首选交流方式（电话、电子邮件、书面说明）"]
[null,null,"带着孩子参观学校"]
[null,null,"帮助孩子记住你的住宅电话、工作电话和住宅地址"]
[null,null,"安排交通，指定一个安全的会面地点，并练习常规的交通方式"]
[null,null,"如果走路，陪孩子练习几次往返学校的路线"]
[null,null,"如果拼车，把孩子介绍给所有的拼车司机"]
[null,null,"如果乘公共汽车，确定时间和公共汽车站"]
[null,null,"安排儿童护理/校外护理"]
[null,null,"为早餐、学校零食、盒装午餐和校外零食制定菜单"]
[null,null,"确定家庭作业的地点和时间表"]
[null,null,"至少在开学前两周建立按时睡觉的习惯"]
[null,null,"准备包含所有学校事件和活动的日历"]

{"sheet":"共享列表","index":3,"n_rows":4,"n_cols":5,"rows_kept":4}
[null,"共享列表",null,null,"与他人共享此列表，让他们参与其中。选择右上角的“共享”，或者依次按 ALT、“Z”和“S”。将文件保存到 OneDrive，并将链接发送给好友。"]
[null,"姓名","电子邮件","共享?"]
[null,"Nikola Janu","nikola@example.com","是"]
[null,"Robert Anic","robert@example.com","否"]