{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Osalemisvastuste jälgija","Osalemisvastuste kokkuvõte"],"not_rendered":{"charts":2,"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"Osalemisvastuste jälgija","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},"OSALEMISVASTUSTE KOKKUVÕTE\nOSALEMISVASTUSTE KOKKUVÕTE\n3"]
[null,"PULMA KUUPÄEV",null,"pulmakutsete jälgija"]
[null,{"$f":"TODAY()+283","v":"2020-01-10"},null,"KÜLALISE NIMI","SAADETUD?","RSVP","KAASLASED","KÜLALINE","SEOS","AADRESS","LINN","MAAKOND","SIHTNUMBER","TELEFON","MEILIAADRESS"]
[null,"PÄEVI JÄÄNUD",null,"Nimi 1","Jah","Jah",1,"Abikaasa/Elukaaslane 1","Vend","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[null,{"$f":"PäeviJäänud","v":283},null,"Nimi 2","Jah","Ei",3,"Abikaasa/Elukaaslane 1","Sõber","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[null,"OSALEB",null,"Nimi 3","Jah","Jah",1,"Muu","Sõber","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[null,{"$f":"OsalejadKokku","v":12},null,"Nimi 4","Jah","Ei",2,"Abikaasa/Elukaaslane 2","Sõber","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[null,"EI OSALE",null,"Nimi 5","Jah","Jah",2,"Abikaasa/Elukaaslane 2","Sõber","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[null,{"$f":"MitteosalejadKokku","v":6},null,"Nimi 6","Jah","Ebalev",null,"Muu","Sõber","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[null,"VASTAMATA",null,"Nimi 7","Jah","Jah",2,"Abikaasa/Elukaaslane 2","Sõber","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[null,{"$f":"SaamataOsalemisvastused","v":1},null,"Nimi 8","Jah","Ei",1,"Muu","Sõber","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[{"$nulls":3},"Nimi 9","Jah","Jah",4,"Abikaasa/Elukaaslane 1","Sõber","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[{"$nulls":3},"Nimi 10","Jah","Jah",2,"Abikaasa/Elukaaslane 1","Sõber","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[{"$nulls":3},"Nimi 11","Jah",null,null,"Abikaasa/Elukaaslane 2","Vend","Aadress","Linn","Maakond","SIHTNUMBER","Telefon","keegi@example.com"]
[{"$nulls":3},"KOKKU:",{"$f":"COUNTIF('Osalemisvastuste jälgija'!$E$4:$E$14,\"Jah\")","v":11},{"$f":"COUNTA('Osalemisvastuste jälgija'!$F$4:$F$14)","v":10},{"$f":"SUBTOTAL(109,tblKutsed[KAASLASED])","v":18}]

{"sheet":"Osalemisvastuste kokkuvõte","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},"OSALEMISVASTUSTE JÄLGIJA\n"]
[null,"PULMA KUUPÄEV",null,"Osalemisvastuste kokkuvõte",{"$nulls":10},"märkmed"]
[null,{"$f":"Pulmakuupäev","v":"2020-01-10"},null,"JAH","Selles lahtris on kobarlintdiagramm külalistega, kes on vastanud JAH."]
[null,"PÄEVI JÄÄNUD",{"$nulls":3},"MUU",{"$f":"IFERROR(SUMIFS(tblKutsed[KAASLASED],tblKutsed[KÜLALINE],\"=Muu\",tblKutsed[RSVP],\"Jah\"),0)","v":1},{"$f":"tblKutsed[[#Totals],[SAADETUD?]]","v":11}]
[null,{"$f":"PäeviJäänud","v":283},{"$nulls":3},"Abikaasa/Elukaaslane 2",{"$f":"IFERROR(SUMIFS(tblKutsed[KAASLASED],tblKutsed[KÜLALINE],\"=Abikaasa/Elukaaslane 2\",tblKutsed[RSVP],\"Jah\"),0)","v":4},{"$f":"tblKutsed[[#Totals],[SAADETUD?]]","v":11}]
[null,"OSALEB",{"$nulls":3},"Abikaasa/Elukaaslane 1",{"$f":"IFERROR(SUMIFS(tblKutsed[KAASLASED],tblKutsed[KÜLALINE],\"=Abikaasa/Elukaaslane 1\",tblKutsed[RSVP],\"Jah\"),0)","v":7},{"$f":"tblKutsed[[#Totals],[SAADETUD?]]","v":11}]
[null,{"$f":"OsalejadKokku","v":12}]
[null,"EI OSALE",null,"EI","Selles lahtris on kobarlintdiagramm külalistega, kes on vastanud EI."]
[null,{"$f":"MitteosalejadKokku","v":6},{"$nulls":3},"MUU",{"$f":"IFERROR(SUMIFS(tblKutsed[KAASLASED],tblKutsed[KÜLALINE],\"=Muu\",tblKutsed[RSVP],\"Ei\"),0)","v":1},{"$f":"tblKutsed[[#Totals],[SAADETUD?]]","v":11}]
[null,"VASTAMATA",{"$nulls":3},"Abikaasa/Elukaaslane 2",{"$f":"IFERROR(SUMIFS(tblKutsed[KAASLASED],tblKutsed[KÜLALINE],\"=Abikaasa/Elukaaslane 2\",tblKutsed[RSVP],\"Ei\"),0)","v":2},{"$f":"tblKutsed[[#Totals],[SAADETUD?]]","v":11}]
[null,{"$f":"SaamataOsalemisvastused","v":1},{"$nulls":3},"Abikaasa/Elukaaslane 1",{"$f":"IFERROR(SUMIFS(tblKutsed[KAASLASED],tblKutsed[KÜLALINE],\"=Abikaasa/Elukaaslane 1\",tblKutsed[RSVP],\"Ei\"),0)","v":3},{"$f":"tblKutsed[[#Totals],[SAADETUD?]]","v":11}]