{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["回覆追蹤工具","回覆摘要"],"not_rendered":{"charts":2,"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"回覆追蹤工具","index":0,"n_rows":15,"n_cols":15,"rows_kept":15,"merged":[[0,3,0,4],[0,5,0,7]]}
[{"$nulls":5},"回覆摘要"]
[null,"婚禮日期",null,"婚禮邀請追蹤工具"]
[null,{"$f":"TODAY()+283","v":"2023-05-21"},null,"來賓姓名","已寄出？","回覆","人數","來賓","關係","地址","縣/市","州/省","郵遞區號","電話","連絡電子郵件"]
[null,"剩餘天數",null,"姓名 1","是","是",1,"新人 1","兄弟","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[null,{"$f":"剩餘天數","v":283},null,"姓名 2","是","否",3,"新人 1","朋友","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[null,"出席人數",null,"姓名 3","是","是",1,"其他","朋友","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[null,{"$f":"出席總人數","v":12},null,"姓名 4","是","否",2,"新人 2","朋友","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[null,"無法出席人數",null,"姓名 5","是","是",2,"新人 2","朋友","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[null,{"$f":"無法出席總人數","v":6},null,"姓名 6","是","暫訂",null,"其他","朋友","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[null,"未回覆人數",null,"姓名 7","是","是",2,"新人 2","朋友","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[null,{"$f":"未回覆","v":1},null,"姓名 8","是","否",1,"其他","朋友","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[{"$nulls":3},"姓名 9","是","是",4,"新人 1","朋友","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[{"$nulls":3},"姓名 10","是","是",2,"新人 1","朋友","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[{"$nulls":3},"姓名 11","是",null,null,"新人 2","兄弟","地址","縣/市","州/省","郵遞區號","電話","someone@example.com"]
[{"$nulls":3},"總計：",{"$f":"COUNTIF(回覆追蹤工具!$E$4:$E$14,\"是\")","v":11},{"$f":"COUNTA(回覆追蹤工具!$F$4:$F$14)","v":10},{"$f":"SUBTOTAL(109,邀請表格[人數])","v":18}]

{"sheet":"回覆摘要","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"merged":[[0,3,0,4],[0,5,0,8],[2,3,6,3],[2,4,6,4],[7,3,11,3],[7,4,11,4]]}
[{"$nulls":3},"回覆追蹤工具"]
[null,"婚禮日期",null,"回覆摘要",{"$nulls":10},"附註"]
[null,{"$f":"婚禮日期","v":"2023-05-21"},null,"是","此儲存格為顯示答應出席之來賓類型的群組橫條圖。"]
[null,"剩餘天數",{"$nulls":3},"其他",{"$f":"IFERROR(SUMIFS(邀請表格[人數],邀請表格[來賓],\"=其他\",邀請表格[回覆],\"是\"),0)","v":1},{"$f":"邀請表格[[#Totals],[已寄出？]]","v":11}]
[null,{"$f":"剩餘天數","v":283},{"$nulls":3},"新人 2",{"$f":"IFERROR(SUMIFS(邀請表格[人數],邀請表格[來賓],\"=新人 2\",邀請表格[回覆],\"是\"),0)","v":4},{"$f":"邀請表格[[#Totals],[已寄出？]]","v":11}]
[null,"出席人數",{"$nulls":3},"新人 1",{"$f":"IFERROR(SUMIFS(邀請表格[人數],邀請表格[來賓],\"=新人 1\",邀請表格[回覆],\"是\"),0)","v":7},{"$f":"邀請表格[[#Totals],[已寄出？]]","v":11}]
[null,{"$f":"出席總人數","v":12}]
[null,"無法出席人數",null,"否","此儲存格為顯示無法出席之來賓類型的群組橫條圖。"]
[null,{"$f":"無法出席總人數","v":6},{"$nulls":3},"其他",{"$f":"IFERROR(SUMIFS(邀請表格[人數],邀請表格[來賓],\"=其他\",邀請表格[回覆],\"否\"),0)","v":1},{"$f":"邀請表格[[#Totals],[已寄出？]]","v":11}]
[null,"未回覆人數",{"$nulls":3},"新人 2",{"$f":"IFERROR(SUMIFS(邀請表格[人數],邀請表格[來賓],\"=新人 2\",邀請表格[回覆],\"否\"),0)","v":2},{"$f":"邀請表格[[#Totals],[已寄出？]]","v":11}]
[null,{"$f":"未回覆","v":1},{"$nulls":3},"新人 1",{"$f":"IFERROR(SUMIFS(邀請表格[人數],邀請表格[來賓],\"=新人 1\",邀請表格[回覆],\"否\"),0)","v":3},{"$f":"邀請表格[[#Totals],[已寄出？]]","v":11}]