{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["RSVP Tracker","RSVP Summary"],"not_rendered":{"charts":2,"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"RSVP Tracker","index":0,"n_rows":15,"n_cols":15,"rows_kept":15,"merged":[[0,3,0,4],[0,5,0,7],[1,3,1,14]]}
[{"$nulls":5},"RSVP SUMMARY"]
[null,"WEDDING DATE",null,"wedding invitation tracker"]
[null,{"$f":"TODAY()+283","v":"2019-06-23"},null,"GUEST NAME","SENT?","RSVP","PARTY","GUEST","RELATIONSHIP","ADDRESS","TOWN/CITY","COUNTY/REGION","POSTCODE","PHONE NUMBER","CONTACT EMAIL ADDRESS"]
[null,"DAYS REMAINING",null,"Name 1","Yes","Yes",1,"Spouse-to-be 1","Brother","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[null,{"$f":"DaysRemaining","v":283},null,"Name 2","Yes","No",3,"Spouse-to-be 1","Friend","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[null,"ATTENDING",null,"Name 3","Yes","Yes",1,"Other","Friend","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[null,{"$f":"TotalAttending","v":12},null,"Name 4","Yes","No",2,"Spouse-to-be 2","Friend","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[null,"NOT ATTENDING",null,"Name 5","Yes","Yes",2,"Spouse-to-be 2","Friend","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[null,{"$f":"TotalNotAttending","v":6},null,"Name 6","Yes","Tentative",null,"Other","Friend","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[null,"OUTSTANDING",null,"Name 7","Yes","Yes",2,"Spouse-to-be 2","Friend","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[null,{"$f":"OutstandingRSVP","v":1},null,"Name 8","Yes","No",1,"Other","Friend","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[{"$nulls":3},"Name 9","Yes","Yes",4,"Spouse-to-be 1","Friend","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[{"$nulls":3},"Name 10","Yes","Yes",2,"Spouse-to-be 1","Friend","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[{"$nulls":3},"Name 11","Yes",null,null,"Spouse-to-be 2","Brother","Address","Town/City","County/Region","POSTCODE","Phone number","someone@example.com"]
[{"$nulls":3},"TOTALS:",{"$f":"COUNTIF('RSVP Tracker'!$E$4:$E$14,\"Yes\")","v":11},{"$f":"COUNTA('RSVP Tracker'!$F$4:$F$14)","v":10},{"$f":"SUBTOTAL(109,tblInvites[PARTY])","v":18}]

{"sheet":"RSVP Summary","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"merged":[[0,3,0,4],[0,5,0,8],[1,3,1,11],[2,3,6,3],[2,4,6,4],[7,3,11,3],[7,4,11,4]]}
[{"$nulls":3},"RSVP TRACKER"]
[null,"WEDDING DATE",null,"rsvp summary",{"$nulls":10},"notes"]
[null,{"$f":"WeddingDate","v":"2019-06-23"},null,"YES","Clustered bar chart showing Guest types for Yes RSVPs is in this cell."]
[null,"DAYS REMAINING",{"$nulls":3},"OTHER",{"$f":"IFERROR(SUMIFS(tblInvites[PARTY],tblInvites[GUEST],\"=Other\",tblInvites[RSVP],\"Yes\"),0)","v":1},{"$f":"tblInvites[[#Totals],[SENT?]]","v":11}]
[null,{"$f":"DaysRemaining","v":283},{"$nulls":3},"SPOUSE-TO-BE 2",{"$f":"IFERROR(SUMIFS(tblInvites[PARTY],tblInvites[GUEST],\"=Spouse-to-be 2\",tblInvites[RSVP],\"Yes\"),0)","v":4},{"$f":"tblInvites[[#Totals],[SENT?]]","v":11}]
[null,"ATTENDING",{"$nulls":3},"SPOUSE-TO-BE 1",{"$f":"IFERROR(SUMIFS(tblInvites[PARTY],tblInvites[GUEST],\"=Spouse-to-be 1\",tblInvites[RSVP],\"Yes\"),0)","v":7},{"$f":"tblInvites[[#Totals],[SENT?]]","v":11}]
[null,{"$f":"TotalAttending","v":12}]
[null,"NOT ATTENDING",null,"NO","Clustered bar chart showing Guest types for No RSVPs is in this cell."]
[null,{"$f":"TotalNotAttending","v":6},{"$nulls":3},"OTHER",{"$f":"IFERROR(SUMIFS(tblInvites[PARTY],tblInvites[GUEST],\"=Other\",tblInvites[RSVP],\"No\"),0)","v":1},{"$f":"tblInvites[[#Totals],[SENT?]]","v":11}]
[null,"OUTSTANDING",{"$nulls":3},"SPOUSE-TO-BE 2",{"$f":"IFERROR(SUMIFS(tblInvites[PARTY],tblInvites[GUEST],\"=Spouse-to-be 2\",tblInvites[RSVP],\"No\"),0)","v":2},{"$f":"tblInvites[[#Totals],[SENT?]]","v":11}]
[null,{"$f":"OutstandingRSVP","v":1},{"$nulls":3},"SPOUSE-TO-BE 1",{"$f":"IFERROR(SUMIFS(tblInvites[PARTY],tblInvites[GUEST],\"=Spouse-to-be 1\",tblInvites[RSVP],\"No\"),0)","v":3},{"$f":"tblInvites[[#Totals],[SENT?]]","v":11}]