{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Założenia finansowe","Szacunkowe koszty odcinków","Kryteria"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Założenia finansowe","index":0,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[26,2,26,7],[26,1,27,1]]}
[]
[]
[]
[null,"Założenia odnośnie prac ziemnych"]
[null,null,"j.",null,"źródło danych o kosztach"]
[null,"Prace ziemne","zł/km2",82000,"Sekocenbud - BCA BCD BCP - broszura- III kw. 2022"]
[]
[]
[null,"Założenia do kosztów nawierzchni dla rowerzystów"]
[null,null,"j.","asfalt/bitumiczna","beton","kostka betonowa","gruntowa ulepszona","Płyty rowerowe","źródło danych o kosztach"]
[null,"koszt łączny","zł/km2",211000,204500,282000,134000,{"$f":"296000*C25","v":351894.4623408498},"Sekocenbud - BCA BCD BCP - broszura- III kw. 2022"]
[null,"koszt krawęźników","zł/km",124000,124000,124000,124000,0,"Sekocenbud - BCA BCD BCP - broszura- III kw. 2022"]
[]
[]
[null,"Założenia do kosztów oznakowania"]
[null,"Oznakowanie trasy ","j.",null,"Źródło danych o kosztach"]
[null,"Cena 1 oznakowania pionowego","zł",610,"Sekocenbud - BCA BCD BCP - broszura- III kw. 2022"]
[null,"Odległość między znakami","m",500,"Sekocenbud - BCA BCD BCP - broszura- III kw. 2022"]
[null,"Cena 1 oznakowania pionowego","zł/km",305,"Sekocenbud - BCA BCD BCP - broszura- III kw. 2022"]
[]
[]
[null,"Przeliczenie rowerowych płyt yomb"]
[null,"Koszt płyty yomb",65.19]
[null,"Koszt rowerowej płyty yomb",77.5]
[null,"wskaźnik przeliczeniowy",{"$f":"C24/C23","v":1.1888326430434115}]
[]
[null,"Przeliczniki na 1 km","Szerokość (m)"]
[null,null,2,2.5,3,3.5,4,5]
[null,"Prace ziemne",{"$f":"$D$6*C28","v":164000},{"$f":"$D$6*D28","v":205000},246000,287000,328000,410000]
[null,"Oznakowanie",{"$f":"$D$19","v":305},{"$f":"$D$19","v":305},305,305,305,305]
[null,"Nawierzchnia"]
[null,"asfalt/bitumiczna",{"$f":"$D$11*C28","v":422000},{"$f":"$D$11*D28","v":527500},633000,738500,844000,1055000]
[null,"beton",{"$f":"$E$11*C28","v":409000},{"$f":"$E$11*D28","v":511250},613500,715750,818000,1022500]
[null,"kostka betonowa",{"$f":"$F$11*C28","v":564000},{"$f":"$F$11*D28","v":705000},846000,987000,1128000,1410000]
[null,"gruntowa ulepszona",{"$f":"$G$11*C28","v":268000},{"$f":"$G$11*D28","v":335000},402000,469000,536000,670000]
[null,"Płyty rowerowe",{"$f":"$H$11*C28","v":703788.9246816996},{"$f":"$H$11*D28","v":879736.15585212456},1055683.3870225493,1231630.6181929742,1407577.8493633992,1759472.3117042491]
[null,"Krawęźniki"]
[null,"asfalt/bitumiczna",{"$f":"$D$12","v":124000},{"$f":"$D$12","v":124000},124000,124000,124000,124000]
[null,"beton",{"$f":"$E$12","v":124000},{"$f":"$E$12","v":124000},124000,124000,124000,124000]
[null,"kostka betonowa",{"$f":"$F$12","v":124000},{"$f":"$F$12","v":124000},124000,124000,124000,124000]
[null,"gruntowa ulepszona",{"$f":"$G$12","v":124000},{"$f":"$G$12","v":124000},124000,124000,124000,124000]
[null,"Płyty rowerowe",{"$f":"$H$12","v":0},{"$f":"$H$12","v":0},0,0,0,0]
[null,"Suma całkowita"]
[null,"asfalt/bitumiczna",{"$f":"C29+C30+C32+C38","v":710305},{"$f":"D29+D30+D32+D38","v":856805},1003305,1149805,1296305,1589305]
[null,"beton",{"$f":"C29+C30+C33+C39","v":697305},{"$f":"D29+D30+D33+D39","v":840555},983805,1127055,1270305,1556805]
[null,"kostka betonowa",{"$f":"C29+C30+C34+C40","v":852305},{"$f":"D29+D30+D34+D40","v":1034305},1216305,1398305,1580305,1944305]
[null,"gruntowa ulepszona",{"$f":"C29+C30+C35+C41","v":556305},{"$f":"D29+D30+D35+D41","v":664305},772305,880305,988305,1204305]
[null,"Płyty rowerowe",{"$f":"C29+C36+C30+C42","v":868093.9246816996},{"$f":"D29+D36+D30+D42","v":1085041.1558521246},1301988.3870225493,1518935.6181929742,1735882.8493633992,2169777.3117042491]

{"sheet":"Szacunkowe koszty odcinków","index":1,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["Numeracja PTR 2","Wnioskodawca","Zakres prac","Docelowa nawierzchnia","Długość (km)","Szerokość (m)","Prace ziemne","Nawierzchnia","Krawężniki","Oznakowanie","suma","na 1 km"]
["EV9_WTR_1-2","Gmina Gniew","Modernizacja drogi","Kruszywo",2.7,2,442800.00000000006,723600,334800,823.5,1502023.5,556305]
["EV9_WTR_3-4","Gmina Gniew","Modernizacja drogi","Asfalt",1.7,4,557600,1434800,210800,518.5,2203718.5,1296305]
["EV9_WTR_4a-5","Gmina Gniew","Budowa przejazdu rowerowego","Asfalt",0.1,3,24600.000000000004,63300.000000000007,12400,30.5,100330.50000000001,1003305.0000000001]
["EV9_WTR_5-6a","Gmina Gniew","Budowa ciągu pieszo-rowerowego","Asfalt",7.5,3,1845000,4747500,930000,2287.5,7524787.5,1003305]
["EV9_WTR_6a-6","Gmina Gniew","Modernizacja drogi","Asfalt",0.3,3,73799.999999999985,189899.99999999997,37200,91.5,300991.49999999994,1003304.9999999999]
["EV9_WTR_6-7","Gmina Gniew","Modernizacja drogi","Kostka niefazowana",0.4,3.5,114800.00000000001,394800.00000000006,49600,122,559322,1398305]
["EV9_WTR_7-8","Gmina Gniew","Modernizacja drogi","Kruszywo",0.8,3,196800.00000000003,321600.00000000006,99200,244,617844.00000000012,772305.00000000012]
["EV9_WTR_8-10a","Gmina Gniew","Modernizacja drogi","Asfalt",0.95,5,389500,1002250,117800,289.75,1509839.75,1589305]
["EV9_WTR_10a-10","Gmina Gniew","Budowa ciągu pieszo-rowerowego","Asfalt",1.4,3,344399.99999999994,886199.99999999988,173600,427,1404626.9999999998,1003304.9999999999]
["EV9_WTR_14-15","Gmina Subkowy ","Budowa drogi rowerowej","Asfalt",2.2000000000000002,2.5,451000,1160500,272800,671,1884971,856804.99999999988]
["EV9_WTR_67-68a","Gmina Sadlinki","Budowa ciągu pieszo-rowerowego ","Asfalt",1.35,3,332100.00000000006,854550.00000000012,167400,411.75,1354461.7500000002,1003305.0000000001]
["EV9_WTR_68a-68b","Gmina Sadlinki","Budowa ciągu pieszo-rowerowego ","Asfalt",2.41,3,592860,1525530,298840,735.05000000000007,2417965.0499999998,1003304.9999999999]
["EV9_WTR_68b-68c","Gmina Sadlinki","Budowa ciągu pieszo-rowerowego ","Asfalt",2.58,3,634680,1633140,319920,786.9,2588526.9,1003304.9999999999]
["EV9_WTR_68c-68","Gmina Sadlinki","Budowa ciągu pieszo-rowerowego ","Asfalt",1.48,3,364079.99999999994,936839.99999999988,183520,451.4,1484891.3999999997,1003304.9999999998]
["EV9_WTR_72-73","Gmina Kwidzyn","Modernizacja ciągu pieszo-rowerowego","Asfalt",4,3,984000,2532000,496000,1220,4013220,1003305]
["EV9_WTR_76a-76","Gmina Kwidzyn","Budowa ciągu pieszo-rowerowego ","Asfalt",3.1,3,762600.00000000012,1962300.0000000002,384400,945.5,3110245.5000000005,1003305.0000000001]
["EV9_WTR_76-77a","Gmina Ryjewo","Budowa ciągu pieszo-rowerowego ","Bitumiczna",1.8,3,442800.00000000006,1139400,223200,549,1805949,1003305]
["EV9_WTR_77a-77 ","Gmina Ryjewo","Budowa ciągu pieszo-rowerowego ","Bitumiczna",1.3,2.5,266500,685750,161200,396.5,1113846.5,856805]
["EV9_WTR_77-78","Gmina Sztum","Budowa drogi dla rowerów","Asfalt",2.9,2.5,594500,1529750,359600,884.5,2484734.5,856805]
["EV9_WTR_78a-78","Gmina Sztum","Budowa drogi dla rowerów","Asfalt",1.1000000000000001,2.5,225500,580250,136400,335.5,942485.5,856804.99999999988]
["EV9_WTR_78-79a","Gmina Miłoradz","Budowa drogi dla rowerów","beton",3.5,2.5,717500,1789375,434000,1067.5,2941942.5,840555]
["EV9_WTR_79a-79","Gmina Miłoradz","Budowa drogi dla rowerów","beton",4.7,2.5,963500,2402875,582800,1433.5,3950608.5,840555]
["EV9_WTR_81a-81","Gmina Miłoradz","Budowa drogi dla rowerów","beton",0.33,3,81180,202455,40920,100.65,324655.65000000002,983805]
["EV9_WTR_82-99","Gmina Miłoradz","Budowa ciągu pieszo-rowerowego","Asfalt",1.35,3,332100.00000000006,854550.00000000012,167400,411.75,1354461.7500000002,1003305.0000000001]
["EV9_WTR_83-84 ","Gmina Miłoradz","Budowa drogi dla rowerów","Asfalt",1.28,2.5,262400,675200,158720,390.40000000000003,1096710.3999999999,856804.99999999988]
["EV9_WTR_84-85a","Gmina Lichnowy ","Budowa ciągu pieszo-rowerowego","Asfalt",7.4,2.5,1517000,3903500,917600,2257,6340357,856805]
["EV9_WTR_85b-86 ","Gmina Lichnowy ","Budowa ciągu pieszo-rowerowego","Asfalt",1.2,2.5,246000,633000,148800,366,1028166,856805]
["EV9_WTR_88-89","Gmina Ostaszewo","Budowa drogi dla rowerów","Kostka niefazowana",1.5,2.5,307500,1057500,186000,457.5,1551457.5,1034305]
["EV9_WTR_90-91","Gmina Ostaszewo","Budowa drogi dla rowerów","Kostka niefazowana",4,2.5,820000,2820000,496000,1220,4137220,1034305]
["EV9_WTR_93-94a","Gmina Stegna","Budowa drogi dla rowerów","Bitumiczna",3.5,3,861000,2215500,434000,1067.5,3511567.5,1003305]
["EV9_WTR_94a-100","Powiat NDG","Budowa ciągu pieszo-rowerowego","kostka niefazowana",1.5,3,369000,1269000,186000,457.5,1824457.5,1216305]
["EV10_13_22-24","Gmina Ustka","Modernizacja drogi","Beton",1.1000000000000001,3,270600,674850,136400,335.5,1082185.5,983804.99999999988]
["EV10_13_24a-24b","Gmina Ustka","Modernizacja drogi","Beton",0.8,3,196800.00000000003,490800.00000000006,99200,244,787044.00000000012,983805.00000000012]
["EV10_13_26a-26","Gmina Ustka","Modernizacja drogi","Beton",0.95,3,233699.99999999997,582824.99999999988,117800,289.75,934614.74999999988,983804.99999999988]
["EV10_13_26-212","Gmina Ustka","Modernizacja drogi","Beton",0.95,3,233699.99999999997,582824.99999999988,117800,289.75,934614.74999999988,983804.99999999988]
["EV10_13_29-212","Gmina Ustka","Modernizacja drogi","Beton",3,3,738000,1840500,372000,915,2951415,983805]
["EV10_13_29a-29","SPN","Modernizacja drogi","Płyty yomb rowerowe",0.9,3,221400.00000000003,950115.04832029447,0,274.5,1171789.5483202946,1301988.3870225495]
["EV10_13_29-30","Gmina Smołdzino","Modernizacja drogi","Płyty yomb rowerowe",1.2,3,295199.99999999994,1266820.0644270591,0,366,1562386.0644270591,1301988.3870225493]
["EV10_13_33-34","Powiat Słupski","Modernizacja drogi","Beton",3.5,3.5,1004500,2505125,434000,1067.5,3944692.5,1127055]
["EV10_13_34-35a","Gmina Smołdzino ","Modernizacja drogi","Kruszywo",2.9,3,713399.99999999988,1165800,359600,884.5,2239684.5,772305]
["EV10_13_35a-35","SPN","Modernizacja drogi","Płyty yomb rowerowe",1.2,3,295199.99999999994,1266820.0644270591,0,366,1562386.0644270591,1301988.3870225493]
["EV10_13_38-37","Gmina Smołdzino","Modernizacja drogi","Asfalt",0.6,3,147599.99999999997,379799.99999999994,74400,183,601982.99999999988,1003304.9999999999]
["EV10_13_39-38","Gmina Smołdzino","Modernizacja drogi","Kruszywo",0.9,3,221400.00000000003,361800,111600,274.5,695074.5,772305]
["EV10_13_41a-42","Powiat Słupski ","Budowa ciągu pieszo-rowerowego","Asfalt",11.4,3,2804400.0000000005,7216200.0000000009,1413600,3477,11437677.000000002,1003305.0000000001]
["EV10_13_42-43","Powiat słupski ","Modernizacja drogi","Beton",2.1,3.5,602700,1503075,260400,640.5,2366815.5,1127055]
["EV10_13_44-45","SPN","Modernizacja drogi","Kruszywo",5.5,3,1353000,2211000,682000,1677.5,4247677.5,772305]
["EV10_13_63-64","Nadleśnictwo Choczewo ","Modernizacja drogi","Kruszywo",9,4,2952000,4824000,1116000,2745,8894745,988305]
["EV10_13_72-73a","Gmina Krokowa","Modernizacja drogi","Kostka niefazowana",7.0000000000000007E-2,4,22960.000000000004,78960.000000000015,8680,21.35,110621.35000000002,1580305.0000000002]
["EV10_13_73a-73","Gmina Krokowa","Modernizacja drogi","Kostka niefazowana",0.59,4,193520,665520,73160,179.95,932379.95,1580305]
["EV10_13_76-77a","Gmina Krokowa","Budowa ciągu pieszo-rowerowego","asfalt",0.35,3,86099.999999999985,221549.99999999997,43400,106.75,351156.74999999994,1003304.9999999999]
["EV10_13_77a-77","Gmina Krokowa","Modernizacja drogi","Kostka niefazowana",1.05,4,344400,1184400,130200,320.25,1659320.25,1580305]
["EV10_13_88-89","Gmina Puck miasto","Modernizacja drogi dla rowerów","Beton",1.2,2.5,246000,613500,148800,366,1008666,840555]
["EV10_13_89-90","Gmina Puck miasto","Modernizacja drogi dla rowerów","Beton",1,2.5,205000,511250,124000,305,840555,840555]
["EV10_13_92-93","Gmina Puck miasto","Modernizacja drogi dla rowerów","Beton",1,2.5,205000,511250,124000,305,840555,840555]
["EV10_13_97-98","Gmina Puck","Modernizacja drogi","Asfalt",0.15,4,49200,126600,18600,45.75,194445.75,1296305]
["EV10_13_101-102","Gmina Puck","Budowa ciągu pieszo-rowerowego","Asfalt",1.2,3,295199.99999999994,759599.99999999988,148800,366,1203965.9999999998,1003304.9999999999]
["EV10_13_102-103","Gmina Puck","Budowa drogi-rowerowej","Asfalt",2.5,2.5,512500,1318750,310000,762.5,2142012.5,856805]
["EV10_13_108a-108b","Gmina Kosakowo","Budowa drogi rowerowej","Bitumiczna",0.65,2,106600,274300,80600,198.25,461698.25,710305]
["EV10_13_108b-108","Gmina Kosakowo","Budowa pasa pieszo-jezdnego","Bitumiczna",0.18,5,73799.999999999985,189899.99999999997,22320,54.9,286074.89999999997,1589304.9999999998]
["EV10_13_108-316b","Gmina Kosakowo","Budowa pasa pieszo-jezdnego","Bitumiczna",0.10299999999999999,3.5,29561,76065.5,12772,31.414999999999999,118429.91499999999,1149805]
["EV10_13_190-191","Gmina Stegna","Budowa drogi rowerowej","Asfalt",0.23,3,113160.00000000001,145590,28520,70.150000000000006,287340.15000000002,1249305]
["EV10_13_216-217","Gmina Władysławowo","Modernizacja drogi dla rowerów","Asfalt",2.4,2.5,492000,1266000,297600,732,2056332,856805]
["EV10_13_217a-217","Gmina Władysławowo","Budowa drogi rowerowej","Asfalt",0.8,2.5,164000,422000,99200,244,685444,856805]
["EV10_13_217-218","Gmina Władysławowo","Modernizacja drogi dla rowerów","Asfalt",6.9,2.5,1414500,3639750,855600,2104.5,5911954.5,856805]
["EV10_13_221-222","Gmina Władysławowo","Modernizacja drogi dla rowerów","Asfalt",0.9,2.5,184500,474750,111600,274.5,771124.5,856805]
["EV10_13_222-223a","Gmina Jastarnia","Modernizacja drogi dla rowerów","Asfalt",1.54,2.5,315700,812350,190960,469.7,1319479.7,856805]
["EV10_13_223a-223b","Gmina Jastarnia","Modernizacja drogi dla rowerów","Asfalt",2.75,2.5,563750,1450625,341000,838.75,2356213.75,856805]
["EV10_13_223b-223c","Gmina Jastarnia","Modernizacja drogi dla rowerów","Asfalt",1.4,2.5,287000,738500,173600,427,1199527,856805]
["EV10_13_224-225a","Gmina Jastarnia","Modernizacja drogi dla rowerów","Asfalt",0.3,3,73799.999999999985,189899.99999999997,37200,91.5,300991.49999999994,1003304.9999999999]
["EV10_13_225a-225b","Gmina Jastarnia","Modernizacja drogi dla rowerów","Beton",0.95,3,233699.99999999997,582824.99999999988,117800,289.75,934614.74999999988,983804.99999999988]
["EV10_13_225b-225c","Gmina Jastarnia","Modernizacja drogi dla rowerów","Beton",0.18,2.5,36899.999999999993,92024.999999999985,22320,54.9,151299.89999999997,840554.99999999988]
["EV10_13_225c-225","Gmina Jastarnia","Budowa ciągu pieszo-rowerowego","kostka niefazowana",0.31,4.5,114390,393390,38440,94.55,546314.55000000005,1762305.0000000002]
["EV10_13_311-312","Gmina Pruszcz Gdański","Budowa ciągu pieszo-rowerowego","Bitumiczna",4.2750000000000004,3,1051650,2706075,530100,1303.875,4289128.875,1003304.9999999999]

{"sheet":"Kryteria","index":2,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Ranga"]
["\nrealizacja odcinka jest kluczowa z całościowego punktu widzenia obejmujacego w szczególności natężenie ruchu rowerowego, potrzeby, ciągłość i inne uwarunkowania w tym planowany rodzaj nawierzchni   \n\n\n"]
[" 1 punktów \n–  odcinek o niskim priorytecie globalnym  uwzględniając m.in natężenie ruchu rowerowego, potrzeby, ciągłość całkowitą i inne uwarunkowania;"]
[" 2 punkt \n– odcinek o średnim priorytecie globalnym uwzględniając m.in natężenie ruchu rowerowego, potrzeby, ciągłość całkowitą i inne uwarunkowania;"]
[" 3 punkty \n- odcinek o wysokim priorytecie globalnym uwzględniając m.in natężenie ruchu rowerowego, potrzeby, ciągłość całkowitą i inne uwarunkowania "]