{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Kalkulator","Dane"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Kalkulator","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,3,1,9]]}
[]
[null,null,null,"KALKULATOR ILOŚCI NASADZANYCH DRZEW"]
[]
[null,"Lp.","Ilość usuwanych drzew","Klasa obwodów pnia drzewa usuwanego","Współczynnik dendrometryczny usuwanego drzewa","Rodzaj terenu zieleni z którego usuwane jest drzewo","Rodzaj terenu zieleni, na którym nasadzane jest drzewo","Współczynnik lokalizacji","Ilość drzew do nasadzeń","Bilans"]
[null,1,0,"20-25",{"$f":"IF(D5<>\"\",IF(F5=Dane!$D$18,1, VLOOKUP(D5,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G5=Dane!$E$15,VLOOKUP(F5,Dane!$D$16:$G$18,2,FALSE),      IF(G5=Dane!$F$15,VLOOKUP(F5,Dane!$D$16:$G$18,3,FALSE),      IF(G5=Dane!$G$15, VLOOKUP(F5,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},{"$f":"  ROUNDUP(     IFERROR(      H5*E5*C5,0),0)","v":0},{"$f":"IFERROR(IF(I5<>0,I5-C5,0),0)","v":0}]
[null,2,0,"20-25",{"$f":"IF(D6<>\"\",IF(F6=Dane!$D$18,1, VLOOKUP(D6,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G6=Dane!$E$15,VLOOKUP(F6,Dane!$D$16:$G$18,2,FALSE),      IF(G6=Dane!$F$15,VLOOKUP(F6,Dane!$D$16:$G$18,3,FALSE),      IF(G6=Dane!$G$15, VLOOKUP(F6,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,{"$f":"IFERROR(IF(I6<>0,I6-C6,0),0)","v":0}]
[null,3,0,"20-25",{"$f":"IF(D7<>\"\",IF(F7=Dane!$D$18,1, VLOOKUP(D7,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G7=Dane!$E$15,VLOOKUP(F7,Dane!$D$16:$G$18,2,FALSE),      IF(G7=Dane!$F$15,VLOOKUP(F7,Dane!$D$16:$G$18,3,FALSE),      IF(G7=Dane!$G$15, VLOOKUP(F7,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,4,0,"20-25",{"$f":"IF(D8<>\"\",IF(F8=Dane!$D$18,1, VLOOKUP(D8,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G8=Dane!$E$15,VLOOKUP(F8,Dane!$D$16:$G$18,2,FALSE),      IF(G8=Dane!$F$15,VLOOKUP(F8,Dane!$D$16:$G$18,3,FALSE),      IF(G8=Dane!$G$15, VLOOKUP(F8,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,5,0,"20-25",{"$f":"IF(D9<>\"\",IF(F9=Dane!$D$18,1, VLOOKUP(D9,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G9=Dane!$E$15,VLOOKUP(F9,Dane!$D$16:$G$18,2,FALSE),      IF(G9=Dane!$F$15,VLOOKUP(F9,Dane!$D$16:$G$18,3,FALSE),      IF(G9=Dane!$G$15, VLOOKUP(F9,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,6,0,"20-25",{"$f":"IF(D10<>\"\",IF(F10=Dane!$D$18,1, VLOOKUP(D10,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G10=Dane!$E$15,VLOOKUP(F10,Dane!$D$16:$G$18,2,FALSE),      IF(G10=Dane!$F$15,VLOOKUP(F10,Dane!$D$16:$G$18,3,FALSE),      IF(G10=Dane!$G$15, VLOOKUP(F10,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,7,0,"20-25",{"$f":"IF(D11<>\"\",IF(F11=Dane!$D$18,1, VLOOKUP(D11,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G11=Dane!$E$15,VLOOKUP(F11,Dane!$D$16:$G$18,2,FALSE),      IF(G11=Dane!$F$15,VLOOKUP(F11,Dane!$D$16:$G$18,3,FALSE),      IF(G11=Dane!$G$15, VLOOKUP(F11,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,8,0,"20-25",{"$f":"IF(D12<>\"\",IF(F12=Dane!$D$18,1, VLOOKUP(D12,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G12=Dane!$E$15,VLOOKUP(F12,Dane!$D$16:$G$18,2,FALSE),      IF(G12=Dane!$F$15,VLOOKUP(F12,Dane!$D$16:$G$18,3,FALSE),      IF(G12=Dane!$G$15, VLOOKUP(F12,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,9,0,"20-25",{"$f":"IF(D13<>\"\",IF(F13=Dane!$D$18,1, VLOOKUP(D13,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G13=Dane!$E$15,VLOOKUP(F13,Dane!$D$16:$G$18,2,FALSE),      IF(G13=Dane!$F$15,VLOOKUP(F13,Dane!$D$16:$G$18,3,FALSE),      IF(G13=Dane!$G$15, VLOOKUP(F13,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,10,0,"20-25",{"$f":"IF(D14<>\"\",IF(F14=Dane!$D$18,1, VLOOKUP(D14,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G14=Dane!$E$15,VLOOKUP(F14,Dane!$D$16:$G$18,2,FALSE),      IF(G14=Dane!$F$15,VLOOKUP(F14,Dane!$D$16:$G$18,3,FALSE),      IF(G14=Dane!$G$15, VLOOKUP(F14,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,11,0,"20-25",{"$f":"IF(D15<>\"\",IF(F15=Dane!$D$18,1, VLOOKUP(D15,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G15=Dane!$E$15,VLOOKUP(F15,Dane!$D$16:$G$18,2,FALSE),      IF(G15=Dane!$F$15,VLOOKUP(F15,Dane!$D$16:$G$18,3,FALSE),      IF(G15=Dane!$G$15, VLOOKUP(F15,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,12,0,"20-25",{"$f":"IF(D16<>\"\",IF(F16=Dane!$D$18,1, VLOOKUP(D16,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G16=Dane!$E$15,VLOOKUP(F16,Dane!$D$16:$G$18,2,FALSE),      IF(G16=Dane!$F$15,VLOOKUP(F16,Dane!$D$16:$G$18,3,FALSE),      IF(G16=Dane!$G$15, VLOOKUP(F16,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,13,0,"20-25",{"$f":"IF(D17<>\"\",IF(F17=Dane!$D$18,1, VLOOKUP(D17,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G17=Dane!$E$15,VLOOKUP(F17,Dane!$D$16:$G$18,2,FALSE),      IF(G17=Dane!$F$15,VLOOKUP(F17,Dane!$D$16:$G$18,3,FALSE),      IF(G17=Dane!$G$15, VLOOKUP(F17,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,14,0,"20-25",{"$f":"IF(D18<>\"\",IF(F18=Dane!$D$18,1, VLOOKUP(D18,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G18=Dane!$E$15,VLOOKUP(F18,Dane!$D$16:$G$18,2,FALSE),      IF(G18=Dane!$F$15,VLOOKUP(F18,Dane!$D$16:$G$18,3,FALSE),      IF(G18=Dane!$G$15, VLOOKUP(F18,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,15,0,"20-25",{"$f":"IF(D19<>\"\",IF(F19=Dane!$D$18,1, VLOOKUP(D19,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G19=Dane!$E$15,VLOOKUP(F19,Dane!$D$16:$G$18,2,FALSE),      IF(G19=Dane!$F$15,VLOOKUP(F19,Dane!$D$16:$G$18,3,FALSE),      IF(G19=Dane!$G$15, VLOOKUP(F19,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,16,0,"20-25",{"$f":"IF(D20<>\"\",IF(F20=Dane!$D$18,1, VLOOKUP(D20,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G20=Dane!$E$15,VLOOKUP(F20,Dane!$D$16:$G$18,2,FALSE),      IF(G20=Dane!$F$15,VLOOKUP(F20,Dane!$D$16:$G$18,3,FALSE),      IF(G20=Dane!$G$15, VLOOKUP(F20,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,17,0,"20-25",{"$f":"IF(D21<>\"\",IF(F21=Dane!$D$18,1, VLOOKUP(D21,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G21=Dane!$E$15,VLOOKUP(F21,Dane!$D$16:$G$18,2,FALSE),      IF(G21=Dane!$F$15,VLOOKUP(F21,Dane!$D$16:$G$18,3,FALSE),      IF(G21=Dane!$G$15, VLOOKUP(F21,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,18,0,"20-25",{"$f":"IF(D22<>\"\",IF(F22=Dane!$D$18,1, VLOOKUP(D22,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G22=Dane!$E$15,VLOOKUP(F22,Dane!$D$16:$G$18,2,FALSE),      IF(G22=Dane!$F$15,VLOOKUP(F22,Dane!$D$16:$G$18,3,FALSE),      IF(G22=Dane!$G$15, VLOOKUP(F22,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,19,0,"20-25",{"$f":"IF(D23<>\"\",IF(F23=Dane!$D$18,1, VLOOKUP(D23,Dane!$A$3:$B$10,2,FALSE)), 0  )","v":1},"wybierz ...","wybierz ...",{"$f":"  IFERROR(      IF(G23=Dane!$E$15,VLOOKUP(F23,Dane!$D$16:$G$18,2,FALSE),      IF(G23=Dane!$F$15,VLOOKUP(F23,Dane!$D$16:$G$18,3,FALSE),      IF(G23=Dane!$G$15, VLOOKUP(F23,Dane!$D$16:$G$18,4,FALSE),\"0\"))       ),0)","v":"0"},0,0]
[null,null,{"$f":"SUM(ILUsuwanychDrzew)","v":0},null,null,null,null,null,{"$f":"SUM(ILDoNasadzenia)","v":0},0]

{"sheet":"Dane","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1],[13,4,13,6],[15,2,17,2]]}
["Drzewo usuwane"]
["Obwód pnia drzewa usuwanego","Współczynnik dendrologiczny drzewa usuwanego"]
["20-25",1]
["26-50",1.1000000000000001]
["51-100",1.7]
["101-200",2.6]
["201-300",4]
["301-500",5.6]
["501-700",7.1]
[">700",9.3000000000000007]
[]
[]
[]
[null,null,null,null,"Rodzaj terenu zieleni, na którym nasadzane jest drzewo"]
[null,null,null,"wybierz ...","OBSZAR INWESTYCJI","OBRĘBY, NA KTÓRYCH ZLOKALIZOWANO INWESTYCJĘ","DALSZE OBRĘBY"]
[null,null,"Rodzaj terenu zieleni, na którym usuwane jest drzewo","POZA CENTRUM",1,1.1000000000000001,1.2]
[null,null,null,"CENTRUM",1.1000000000000001,1.2,1.3]
[null,null,null,"1:1 - UZASADNIONE",1,1,1]