{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["rodzina"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"rodzina","index":0,"n_rows":59,"n_cols":23,"rows_kept":59,"cut":false,"hidden":false,"merged":[[7,8,7,9]]}
[]
[null,"WYDATKI RODZINY POSZEPSZYŃSKICH W LUTYM 1995 R."]
[null,null,null,null,null,null,null,null,null,null,null,"p.5",null,null,"Zadanie 11",null,null,null,"Zadanie 12"]
[null,"kto","szczegóły wydatków","rodzaj wydatków","data","kwota",null,null,null,null,{"$f":"SUM(kwota*((kto=\"mama\")+(kto=\"tata\")))","v":728.75},"data","kwota",null,"Daty","Ilość","Kwoty",null,"Dni kiedy tata nie robił zakupów",null,null,"1995-02-02",7]
[null,"tata","benzyna","samochód","1995-02-02",53,null,"p.1,2","wydatki dzieci","wydatki rodziców",null,"1995-02-01",{"$f":"dzienny_wydatek(L5,data,kwota)","v":0},{"$f":"zlicz_wydatki(L5,data)","v":0},"1995-02-01",0,0,null,"1995-02-01",null,null,"1995-02-04",6]
[null,"tata","benzyna","samochód","1995-02-14",72,null,null,{"$f":"wydatki_dzieci(kto,kwota)","v":287.33},{"$f":"wydatki_rodz(kto,kwota)","v":728.75},null,"1995-02-02",{"$f":"dzienny_wydatek(L6,data,kwota)","v":255},7,"1995-02-02",7,140.80000000000001,null,"1995-02-03",null,null,"1995-02-08",4]
[null,"Jola","bułki, kiełbasa","jedzenie","1995-02-02",5,null,null,null,null,null,"1995-02-03",2.5,1,"1995-02-03",1,2.5,null,"1995-02-05",null,null,"1995-02-09",3]
[null,"Adam","bułki, masło, ser","jedzenie","1995-02-02",25,null,"p.3,4","ilość wydatków",null,null,"1995-02-04",94.93,6,"1995-02-04",6,94.93,null,"1995-02-06",null,null,"1995-02-05",3]
[null,"Adam","bułki, pączki","jedzenie","1995-02-08",4.5,null,null,"dzieci",{"$f":"ile_dzieci(kto)","v":22},null,"1995-02-05",115.5,3,"1995-02-05",3,115.5,null,"1995-02-07"]
[null,"mama","buty dla Adama","odzież","1995-02-05",57,null,null,"rodzice",{"$f":"ile_rodzice(kto)","v":26},null,"1995-02-06",2.8,1,"1995-02-06",1,2.8,null,"1995-02-10"]
[null,"Jola","ciastka","jedzenie","1995-02-27",4.0999999999999996,null,null,null,null,null,"1995-02-07",82.3,2,"1995-02-07",2,82.3,null,"1995-02-11"]
[null,"mama","dentysta Adama","czystość","1995-02-21",50,null,null,null,{"$f":"SUMIF(kto,\"tata\",kwota)+SUMIF(kto,\"mama\",kwota)","v":728.75},null,"1995-02-08",31.5,4,"1995-02-08",4,31.5,null,"1995-02-12"]
[null,"Jola","gazety","rozrywka","1995-02-02",2,null,null,null,null,null,"1995-02-09",79.900000000000006,3,"1995-02-09",3,79.900000000000006,null,"1995-02-16"]
[null,"mama","jajka, mąka","jedzenie","1995-02-07",4.3,null,null,null,null,null,"1995-02-10",4.7,1,"1995-02-10",1,4.7,null,"1995-02-17"]
[null,"mama","jajka, mąka, sól itp","jedzenie","1995-02-14",4.5,null,null,"suma wydatków z grupy rozrywka",null,null,"1995-02-11",58.5,2,"1995-02-11",2,58.5,null,"1995-02-18"]
[null,"Adam","kasety","rozrywka","1995-02-04",24,null,null,{"$f":"SUMIF(rodzaj,\"rozrywka\",kwota)","v":208.3},null,null,"1995-02-12",0,0,"1995-02-12",0,0,null,"1995-02-19"]
[null,"Jola","kasety","rozrywka","1995-02-13",11,null,null,null,null,null,"1995-02-13",22,2,"1995-02-13",1,11,null,"1995-02-21"]
[null,"mama","kiełbasa, szynka, ciasto","jedzenie","1995-02-08",12.4,null,null,null,null,null,"1995-02-14",76.5,2,"1995-02-14",2,76.5,null,"1995-02-23"]
[null,"Adam","kino dla rodziny","rozrywka","1995-02-02",12,null,null,"p.6",null,null,"1995-02-15",22.05,2,"1995-02-15",2,22.05,null,"1995-02-24"]
[null,"Jola","ksiazki: Potop, Trędowata","rozrywka","1995-02-05",34,null,null,"mama",null,null,"1995-02-16",15,1,"1995-02-16",1,15,null,"1995-02-26"]
[null,"tata","kwiaty, prezent dla cioci Marty","rozrywka","1995-02-22",21,null,null,"mama",null,null,"1995-02-17",0,0,"1995-02-17",0,0,null,"1995-02-27"]
[null,"Adam","lody","jedzenie","1995-02-03",2.5,null,null,"Jola",null,null,"1995-02-18",4.3,1,"1995-02-18",2,15.3,null,{"$f":"COUNTIF(S5:S21,\">0\")","v":17}]
[null,"Adam","lody, woda mineralna","rozrywka","1995-02-09",1.2,null,null,null,null,null,"1995-02-19",6.8,1,"1995-02-19",1,6.8]
[null,"tata","mandat","samochód","1995-02-20",20,null,null,"p.7",null,null,"1995-02-20",20,1,"1995-02-20",1,20]
[null,"mama","mięso","jedzenie","1995-02-02",37,null,null,"1995-02-02",255,null,"1995-02-21",50,1,"1995-02-21",1,50]
[null,"mama","mięso, wędliny","jedzenie","1995-02-23",13,null,null,null,null,null,"1995-02-22",21,1,"1995-02-22",1,21]
[null,"Jola","mięso, wędliny, jajka","jedzenie","1995-02-15",9.75,null,null,"p.8",null,null,"1995-02-23",13,1,"1995-02-23",1,13]
[null,"Jola","mydło, pasta, proszek","czystość","1995-02-07",78,null,"buty dla Adama",null,null,null,"1995-02-24",0,0,"1995-02-24",0,0]
[null,"tata","naprawa pralki, pasek, wąż","dom","1995-02-15",12.3,null,"ksiazki: Potop, Trędowata",null,null,null,"1995-02-25",12,1,"1995-02-25",1,12]
[null,"Jola","obiady","jedzenie","1995-02-04",20,null,"obiady",null,null,null,"1995-02-26",8.6,1,"1995-02-26",1,8.6]
[null,"mama","obiady","jedzenie","1995-02-05",24.5,null,"proszki do prania, mydło, pasta",null,null,null,"1995-02-27",8.4,2,"1995-02-27",2,8.4]
[null,"tata","obiady swoje i Adama","jedzenie","1995-02-04",39.5,null,"środki higieny",null,null,null,"1995-02-28",8.8000000000000007,1,"1995-02-28",1,8.8000000000000007]
[null,"tata","papierosy","rozrywka","1995-02-08",3.6]
[null,"tata","perfumy dla mamy","rozrywka","1995-02-25",12]
[null,"tata","płyn do chłodnicy","samochód","1995-02-13",11]
[null,"mama","pomarańcze","jedzenie","1995-02-04",4.5,null,"niedziela"]
[null,"Jola","prezent dla Beaty","rozrywka","1995-02-10",4.7,null,"poniedziałek",null,null,null,"p.9",null,null,"Zadanie 10",null,"max","min"]
[null,"mama","proszek do piecz., keczup itp.","jedzenie","1995-02-09",4.7,null,"wtorek",null,null,null,"mama",{"$f":"wydatek_osoby(L38,kto,kwota)","v":279.3},null,"samochód",{"$f":"kwota_na_grupę(O38,rodzaj,kwota)","v":157.25},{"$f":"max_z_grupy(O38,rodzaj,kwota)","v":72},{"$f":"min_z_grupy(O38,rodzaj,kwota)","v":1.25}]
[null,"mama","proszki do prania, mydło, pasta","czystość","1995-02-26",8.6,null,"środa",null,null,null,"tata",{"$f":"wydatek_osoby(L39,kto,kwota)","v":449.45},null,"jedzenie",{"$f":"kwota_na_grupę(O39,rodzaj,kwota)","v":238.83},39.5,2.5]
[null,"tata","reflektor","samochód","1995-02-04",1.25,null,"czwartek",null,null,null,"Jola",{"$f":"wydatek_osoby(L40,kto,kwota)","v":189.53},null,"odzież",124,57,15]
[null,"Adam","rękawiczki, szalik","odzież","1995-02-16",15,null,"piątek",null,null,null,"Adam",{"$f":"wydatek_osoby(L41,kto,kwota)","v":97.8},null,"czystość",143.4,78,6.8]
[null,"mama","sweter dla Adama","odzież","1995-02-11",52,null,"sobota",null,null,null,null,null,null,"rozrywka",208.3,74,1.2]
[null,"tata","swiatło, gaz, mieszkanie","stałe","1995-02-02",121,null,null,null,null,null,null,null,null,"dom",23.3,12.3,11]
[null,"Jola","szklanki, spodki","dom","1995-02-08",11,null,null,null,null,null,null,null,null,"stałe",121,121,121]
[null,"Jola","rogaliki","jedzenie","1995-02-04",5.68]
[null,"Adam","bułki","jedzenie","1995-02-11",6.5,null,null,null,null,null,null,null,"tablicowo","Zadanie 10",null,"max"]
[null,"Jola","bagietki","jedzenie","1995-02-18",4.3,null,null,null,null,null,null,null,null,"samochód",{"$f":"suma_max_rodz(O47,rodzaj,kwota)","v":157.25},72]
[null,"Adam","cukier","jedzenie","1995-02-27",4.3,null,null,null,null,null,null,null,null,"jedzenie",{"$f":"suma_max_rodz(O48,rodzaj,kwota)","v":238.83},39.5]
[null,"Adam","płatki: mleko, bułki, masło","jedzenie","1995-02-06",2.8,null,null,null,null,null,null,null,null,"odzież",{"$f":"suma_max_rodz(O49,rodzaj,kwota)","v":124},57]
[null,"mama","środki higieny","czystość","1995-02-19",6.8,null,null,null,null,null,null,null,null,"czystość",{"$f":"suma_max_rodz(O50,rodzaj,kwota)","v":143.4},78]
[null,"tata","wino, piwo","rozrywka","1995-02-09",74,null,null,null,null,null,null,null,null,"rozrywka",{"$f":"suma_max_rodz(O51,rodzaj,kwota)","v":208.3},74]
[null,"tata","wino","rozrywka","1995-02-28",8.8000000000000007,null,null,null,null,null,null,null,null,"dom",{"$f":"suma_max_rodz(O52,rodzaj,kwota)","v":23.3},12.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"stałe",{"$f":"suma_max_rodz(O53,rodzaj,kwota)","v":121},121]
[null,null,"p.8 f.tabl"]
[null,null,1,2,3,4,5,6,7,null,null,null,null,null,"p.9","suma","max","min"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mama",{"$f":"wydatek_max_min_osoby(O56,kto,kwota)","v":279.3},57,4.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tata",{"$f":"wydatek_max_min_osoby(O57,kto,kwota)","v":449.45},121,1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jola",{"$f":"wydatek_max_min_osoby(O58,kto,kwota)","v":189.53},78,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adam",{"$f":"wydatek_max_min_osoby(O59,kto,kwota)","v":97.8},25,1.2]