{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Dane potencjalnych klientów","Sprzedaż prognozowana ","Miesięczna prognoza ważona"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Dane potencjalnych klientów","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Nazwa firmy"]
[null,"Szczegółowe śledzenie potencjalnych klientów"]
[null,{"$f":"TODAY()","v":"2022-04-05"}]
[{"$nulls":8},{"$f":"Nazwa_firmy","v":"Nazwa firmy"},"POUFNE"]
[null,"Nazwa potencjalnego klienta","Osoba kontaktowa potencjalnego klienta","Potencjalny klient \nŹródło","Potencjalny klient \nRegion","Potencjalny klient \nTyp","Potencjalna szansa sprzedaży","Szansa \nsprzedaży","Prognoza \nZamknij","Ważona \nPrognoza"]
[null,"A. Datum Corporation",{"$nulls":3},"Strategiczny",{"v":300000,"d":"300,000.00 zł"},{"v":0.9,"d":"90%"},"Styczeń",{"$f":"IFERROR(IF(LeadData[[#This Row],[Szansa \nsprzedaży]]<>\"\",LeadData[[#This Row],[Szansa \nsprzedaży]]*LeadData[[#This Row],[Potencjalna szansa sprzedaży]],\"\"),\"\")","v":{"v":270000,"d":"270,000.00 zł"}}]
[null,"Adventure Works",{"$nulls":3},"Strategiczny",{"v":200000,"d":"200,000.00 zł"},{"v":0.1,"d":"10%"},"Luty",{"$f":"IFERROR(IF(LeadData[[#This Row],[Szansa \nsprzedaży]]<>\"\",LeadData[[#This Row],[Szansa \nsprzedaży]]*LeadData[[#This Row],[Potencjalna szansa sprzedaży]],\"\"),\"\")","v":{"v":20000,"d":"20,000.00 zł"}}]
[null,"Alpine Ski House",{"$nulls":3},"Taktyczny",{"v":100000,"d":"100,000.00 zł"},{"v":0.2,"d":"20%"},"Marzec",{"$f":"IFERROR(IF(LeadData[[#This Row],[Szansa \nsprzedaży]]<>\"\",LeadData[[#This Row],[Szansa \nsprzedaży]]*LeadData[[#This Row],[Potencjalna szansa sprzedaży]],\"\"),\"\")","v":{"v":20000,"d":"20,000.00 zł"}}]
[null,"Suma",{"$nulls":4},{"$f":"SUBTOTAL(109,LeadData[Potencjalna szansa sprzedaży])","v":{"v":600000,"d":"600,000.00 zł"}},null,null,{"$f":"SUBTOTAL(109,LeadData[Ważona \nPrognoza])","v":{"v":310000,"d":"310,000.00 zł"}}]

{"sheet":"Sprzedaż prognozowana ","index":1,"n_rows":21,"n_cols":14,"rows_kept":21,"merged":[[3,12,3,13]]}
[null,{"$f":"Nazwa_firmy","v":"Nazwa firmy"}]
[null,"Sprzedaż prognozowana"]
[null,{"$f":"TrackerDate","v":"2022-04-05"}]
[{"$nulls":11},{"$f":"Nazwa_firmy","v":"Nazwa firmy"},"POUFNE"]
[null,"Nazwa potencjalnego klienta","Styczeń \nPrognoza","Luty \nPrognoza","Marzec \nPrognoza","Kwiecień \nPrognoza","Maj \nPrognoza","Czerwiec \nPrognoza","Prognoza na lipiec","Sierpień \nPrognoza","Wrzesień \nPrognoza","Październik \nPrognoza","Listopad \nPrognoza","Grudzień \nPrognoza"]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":"A. Datum Corporation"},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":270000,"d":"270,000 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":"Adventure Works"},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":20000,"d":"20,000 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":"Alpine Ski House"},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":20000,"d":"20,000 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":{"v":0,"d":"0 zł"}}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(LeadData[[#This Row],[Nazwa potencjalnego klienta]] <> \"\", ROW(ForecastedSales[Nazwa potencjalnego klienta])<>Ostatni_wpis),LeadData[Nazwa potencjalnego klienta], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]]= \"Styczeń\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Luty\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Marzec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Kwiecień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Maj\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Czerwiec\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"July\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Sierpień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Wrzesień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Październik\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Listopad\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(LeadData[[#This Row],[Prognoza \nZamknij]] <>\"\",IF(LeadData[[#This Row],[Prognoza \nZamknij]] = \"Grudzień\",LeadData[Ważona \nPrognoza],0),\"\"),\"\")","v":""}]
[null,"Suma",{"$f":"SUBTOTAL(109,ForecastedSales[Styczeń \nPrognoza])","v":{"v":270000,"d":"270,000 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Luty \nPrognoza])","v":{"v":20000,"d":"20,000 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Marzec \nPrognoza])","v":{"v":20000,"d":"20,000 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Kwiecień \nPrognoza])","v":{"v":0,"d":"0 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Maj \nPrognoza])","v":{"v":0,"d":"0 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Czerwiec \nPrognoza])","v":{"v":0,"d":"0 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Prognoza na lipiec])","v":{"v":0,"d":"0 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Sierpień \nPrognoza])","v":{"v":0,"d":"0 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Wrzesień \nPrognoza])","v":{"v":0,"d":"0 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Październik \nPrognoza])","v":{"v":0,"d":"0 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Listopad \nPrognoza])","v":{"v":0,"d":"0 zł"}},{"$f":"SUBTOTAL(109,ForecastedSales[Grudzień \nPrognoza])","v":{"v":0,"d":"0 zł"}}]
[null,"Suma narastająca",{"$f":"C20","v":{"v":270000,"d":"270,000 zł"}},{"$f":"C21+D20","v":{"v":290000,"d":"290,000 zł"}},{"$f":"D21+E20","v":{"v":310000,"d":"310,000 zł"}},{"$f":"E21+F20","v":{"v":310000,"d":"310,000 zł"}},{"$f":"F21+G20","v":{"v":310000,"d":"310,000 zł"}},{"$f":"G21+H20","v":{"v":310000,"d":"310,000 zł"}},{"$f":"H21+I20","v":{"v":310000,"d":"310,000 zł"}},{"$f":"I21+J20","v":{"v":310000,"d":"310,000 zł"}},{"$f":"J21+K20","v":{"v":310000,"d":"310,000 zł"}},{"$f":"K21+L20","v":{"v":310000,"d":"310,000 zł"}},{"$f":"L21+M20","v":{"v":310000,"d":"310,000 zł"}},{"$f":"M21+N20","v":{"v":310000,"d":"310,000 zł"}}]

{"sheet":"Miesięczna prognoza ważona","index":2,"n_rows":3,"n_cols":2,"rows_kept":3}
[null,{"$f":"Nazwa_firmy","v":"Nazwa firmy"}]
[null,"Miesięczna prognoza ważona"]
[null," "]