{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Offertvergleich","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":21,"comments":1,"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":"Offertvergleich","index":0,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,2,28,16],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[24,3,24,4],[20,3,20,4],[21,3,21,4],[23,3,23,4],[22,3,22,4],[16,3,16,4],[2,18,3,19],[3,4,3,16],[17,3,17,4],[18,3,18,4],[19,3,19,4],[5,21,7,21],[6,2,6,4],[6,6,6,7],[6,9,6,10],[6,12,6,13],[6,15,6,16]]}
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[null,null,"Offertvergleich Submission Bau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VO_1200_22\nAuswertung_Bau_Off.xlt\n11.05.2005"]
[null,null,"Vorhaben:"]
[]
[null,null,null,null,null,"Angebot",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rang"]
[null,null,"Unternehmer",null,null,"Brutto","Nebenkosten",null,"Total ","Rabatt",null,"Total 1","Skonto",null,"Total 2","MwSt.",null,"Netto","Qualitäts-wert","Beurteilungs-\npreis"]
[null,null,"Nr.","Name",null,"Fr.","%","Fr.","Fr.","%","Fr.","Fr.","%","Fr.","Fr.","%","Fr.","Fr.","%","Fr."]
[null,null,1,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(F9),ROUND(F9*J9/100*2,1)/2,\"\")","v":""},{"$f":"IF(ISNUMBER(F9),F9-K9,K9)","v":""},null,{"$f":"IF(ISNUMBER(F9),ROUND(L9*M9/100*2,1)/2,\"\")","v":""},{"$f":"IF(ISNUMBER(F9),L9-N9,L9)","v":""},{"$f":"IF(ISNUMBER(F9),7.7,\"\")","v":""},{"$f":"IF(ISNUMBER(F9),ROUND(P9/100*O9*2,1)/2,\"\")","v":""},{"$f":"IF(ISNUMBER(F9),O9+Q9,\"\")","v":""},{"$f":"IF('1'!$N$43>0,'1'!$N$43,\"\")","v":""},{"$f":"IF(ISNUMBER(F9),IF(ISNUMBER(S9),ROUND(R9/(Faktor+(1-Faktor)*S9/100)*2,1)/2,R9),\"\")","v":""},null,{"$f":"IF(ISNUMBER(T9),RANK(T9,$T$9:$T$25,-1),\"\")","v":""}]
[null,null,2,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(F10),ROUND(F10*J10/100*2,1)/2,\"\")","v":""},{"$f":"IF(ISNUMBER(F10),F10-K10,K10)","v":""},null,{"$f":"IF(ISNUMBER(F10),ROUND(L10*M10/100*2,1)/2,\"\")","v":""},{"$f":"IF(ISNUMBER(F10),L10-N10,L10)","v":""},{"$f":"IF(ISNUMBER(F10),7.7,\"\")","v":""},{"$f":"IF(ISNUMBER(F10),ROUND(P10/100*O10*2,1)/2,\"\")","v":""},{"$f":"IF(ISNUMBER(F10),O10+Q10,\"\")","v":""},{"$f":"IF('2'!$N$43>0,'2'!$N$43,\"\")","v":""},{"$f":"IF(ISNUMBER(F10),IF(ISNUMBER(S10),ROUND(R10/(Faktor+(1-Faktor)*S10/100)*2,1)/2,R10),\"\")","v":""},null,""]
[null,null,3,null,null,null,null,null,null,null,"","",null,"","",{"$f":"IF(ISNUMBER(F11),7.7,\"\")","v":""},"",{"$f":"IF(ISNUMBER(F11),O11+Q11,\"\")","v":""},{"$f":"IF('3'!$N$43>0,'3'!$N$43,\"\")","v":""},"",null,""]
[null,null,4,null,null,null,null,null,null,null,"","",null,"","",{"$f":"IF(ISNUMBER(F12),7.7,\"\")","v":""},"","",{"$f":"IF('4'!$N$43>0,'4'!$N$43,\"\")","v":""},"",null,""]
[null,null,5,null,null,null,null,null,null,null,"","",null,"","","","","",{"$f":"IF('5'!$N$43>0,'5'!$N$43,\"\")","v":""},"",null,""]
[null,null,6,null,null,null,null,null,null,null,"","",null,"","","","","",{"$f":"IF('6'!$N$43>0,'6'!$N$43,\"\")","v":""},"",null,""]
[null,null,7,null,null,null,null,null,null,null,"","",null,"","","","","",{"$f":"IF('7'!$N$43>0,'7'!$N$43,\"\")","v":""},"",null,""]
[null,null,8,null,null,null,null,null,null,null,"","",null,"","","","","",{"$f":"IF('8'!$N$43>0,'8'!$N$43,\"\")","v":""},"",null,""]
[null,null,9,null,null,null,null,null,null,null,"","",null,"","","","","",{"$f":"IF('9'!$N$43>0,'9'!$N$43,\"\")","v":""},"",null,""]
[null,null,10,null,null,null,null,null,null,null,"","",null,"","","","","",{"$f":"IF('10'!$N$43>0,'10'!$N$43,\"\")","v":""},"",null,""]
[null,null,11,null,null,null,null,null,null,null,"","",null,"","","","","",{"$f":"IF('11'!$N$43>0,'11'!$N$43,\"\")","v":""},"",null,""]
[null,null,12,null,null,null,null,null,null,null,"","",null,"","","","","",{"$f":"IF('12'!$N$43>0,'12'!$N$43,\"\")","v":""},"",null,""]
[null,null,13,null,null,null,null,null,null,null,"","",null,"","","","","",{"$f":"IF('13'!$N$43>0,'13'!$N$43,\"\")","v":""},"",null,""]
[null,null,14,null,null,null,null,null,null,null,"","",null,"",{"$f":"IF(ISNUMBER(F22),L22-N22,L22)","v":""},"","",{"$f":"IF(ISNUMBER(F22),O22+Q22,\"\")","v":""},{"$f":"IF('14'!$N$43>0,'14'!$N$43,\"\")","v":""},"",null,""]
[null,null,15,null,null,null,null,null,null,null,"","",null,"",{"$f":"IF(ISNUMBER(F23),L23-N23,L23)","v":""},"","",{"$f":"IF(ISNUMBER(F23),O23+Q23,\"\")","v":""},{"$f":"IF('15'!$N$43>0,'15'!$N$43,\"\")","v":""},"",null,""]
[null,null,16,null,null,null,null,null,null,null,"","",null,"",{"$f":"IF(ISNUMBER(F24),L24-N24,L24)","v":""},"","",{"$f":"IF(ISNUMBER(F24),O24+Q24,\"\")","v":""},{"$f":"IF('16'!$N$43>0,'16'!$N$43,\"\")","v":""},"",null,""]
[null,null,17,null,null,null,null,null,null,null,"","",null,"",{"$f":"IF(ISNUMBER(F25),L25-N25,L25)","v":""},"","",{"$f":"IF(ISNUMBER(F25),O25+Q25,\"\")","v":""},{"$f":"IF('17'!$N$43>0,'17'!$N$43,\"\")","v":""},"",null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimalwert",null,{"$f":"IF(SUM(Angebot_netto)>0,MIN(Angebot_netto),\"\")","v":""},{"$f":"IF(SUM(S9:S25)>0,MIN(S9:S25),\"\")","v":""},{"$f":"IF(SUM(T9:T25)>0,MIN(T9:T25),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximalwert",null,{"$f":"IF(SUM(Angebot_netto)>0,MAX(Angebot_netto),\"\")","v":""},{"$f":"IF(SUM(S9:S25)>0,MAX(S9:S25),\"\")","v":""},{"$f":"IF(SUM(T9:T25)>0,MAX(T9:T25),\"\")","v":""}]
[null,null,{"$f":"CELL(\"dateiname\")","v":"H:\\BVTVO\\800_Vorlagen\\In Bearbeitung\\[Auswertung_Bau_Off.xlsm]1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum:"]

{"sheet":"1","index":1,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[40,12,40,13],[48,7,48,14],[9,7,9,10],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[35,7,35,10],[46,7,46,10],[39,12,39,13],[30,7,30,10],[34,7,34,10],[40,7,40,11],[39,7,39,11],[9,11,9,13],[48,2,48,6],[22,6,24,6],[25,5,26,5],[25,6,26,6],[19,4,26,4],[19,3,26,3],[19,6,21,6],[29,2,31,2],[29,3,31,3],[29,4,31,4],[29,5,30,5],[19,2,26,2],[42,2,42,5],[39,2,40,2],[39,3,40,3],[6,11,6,13],[29,6,30,6],[34,6,35,6],[29,7,29,10],[4,2,4,7],[6,2,7,5],[9,4,9,6],[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,5,35,5],[24,7,24,10],[25,7,25,10],[26,7,26,10],[31,7,31,10],[36,7,36,10]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",null,null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D9),\"\",Offertvergleich!D9)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R9","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",null,null,null,"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)",null,null,null,null,null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,null,"Referenz des Anbieters für vergleichbare Projekte",null,"Strassenbau",null,null,null,null,null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,null,null,null,"Kanalisationsbauwerke",null,null,null,null,null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,null,null,null,"Bauführer",null,null,null,null,null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,null,"Referenzen Schlüsselpersonal vergleichbare Projekte",null,"Polier",null,null,null,null,null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,null,null,null,"bei sehr grossen Baustellen auch Baustellenleiter",null,null,null,null,null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,null,"Baustellenbezogene Organisation (Organigramm)",null,"Angaben zu Schlüsselfunktionen ",null,null,null,null,null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,null,null,null,"Schnittstellen zu Dritten",null,null,null,null,null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",null,"Auftragsanalyse und Massnahmenplanung",null,"Auftragsanalyse",null,null,null,null,null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,null,null,null,"Massnahmenplanung mit Zuständigkeiten",null,null,null,null,null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",null,"Bauprogramm des Anbieters",null,"Bauzeit",null,null,null,null,null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,null,null,null,"Bauvorgang, Abläufe",null,null,null,null,null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,null,"Personaleinsatz",null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,0,null,null,null,"Summe der Beurteilungspunkte (max.",104," Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,1,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"2","index":2,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[31,7,31,10],[36,7,36,10],[9,11,9,13],[6,11,6,13],[9,7,9,10],[34,7,34,10],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[24,7,24,10],[25,7,25,10],[26,7,26,10],[29,7,29,10],[35,7,35,10],[30,7,30,10],[4,2,4,7],[6,2,7,5],[9,4,9,6],[29,6,30,6],[19,2,26,2],[19,3,26,3],[29,5,30,5],[25,5,26,5],[46,7,46,10],[48,2,48,6],[48,7,48,14],[19,4,26,4],[29,4,31,4],[34,4,36,4],[42,2,42,5],[34,5,35,5],[29,2,31,2],[29,3,31,3],[34,2,36,2],[19,6,21,6],[22,6,24,6],[25,6,26,6],[34,3,36,3],[34,6,35,6],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[39,12,39,13]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D10),\"\",Offertvergleich!D10)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R10","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,2,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"3","index":3,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,2,48,6],[48,7,48,14],[39,12,39,13],[42,2,42,5],[46,7,46,10],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,7,34,10],[35,7,35,10],[34,6,35,6],[34,5,35,5],[4,2,4,7],[6,2,7,5],[9,4,9,6],[29,3,31,3],[19,3,26,3],[19,2,26,2],[29,2,31,2],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[30,7,30,10],[24,7,24,10],[29,7,29,10],[29,4,31,4],[19,4,26,4],[22,6,24,6],[19,6,21,6],[25,6,26,6],[29,5,30,5],[25,5,26,5],[29,6,30,6],[31,7,31,10],[36,7,36,10],[9,11,9,13],[9,7,9,10],[6,11,6,13],[25,7,25,10],[26,7,26,10]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D11),\"\",Offertvergleich!D11)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R11","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,3,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"4","index":4,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[29,7,29,10],[30,7,30,10],[34,7,34,10],[35,7,35,10],[34,5,35,5],[29,6,30,6],[34,6,35,6],[29,5,30,5],[19,4,26,4],[48,2,48,6],[48,7,48,14],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[31,7,31,10],[36,7,36,10],[39,12,39,13],[42,2,42,5],[46,7,46,10],[29,3,31,3],[34,2,36,2],[34,3,36,3],[6,11,6,13],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[9,7,9,10],[9,11,9,13],[34,4,36,4],[29,4,31,4],[29,2,31,2],[4,2,4,7],[6,2,7,5],[9,4,9,6],[25,7,25,10],[26,7,26,10],[23,7,23,10],[24,7,24,10],[22,6,24,6],[19,6,21,6],[25,5,26,5],[25,6,26,6],[19,3,26,3],[19,2,26,2]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D12),\"\",Offertvergleich!D12)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R12","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,4,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"5","index":5,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,2,48,6],[48,7,48,14],[39,12,39,13],[42,2,42,5],[46,7,46,10],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,7,34,10],[35,7,35,10],[34,6,35,6],[34,5,35,5],[4,2,4,7],[6,2,7,5],[9,4,9,6],[29,3,31,3],[19,3,26,3],[19,2,26,2],[29,2,31,2],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[30,7,30,10],[24,7,24,10],[29,7,29,10],[29,4,31,4],[19,4,26,4],[22,6,24,6],[19,6,21,6],[25,6,26,6],[29,5,30,5],[25,5,26,5],[29,6,30,6],[31,7,31,10],[36,7,36,10],[9,11,9,13],[9,7,9,10],[6,11,6,13],[25,7,25,10],[26,7,26,10]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D13),\"\",Offertvergleich!D13)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R13","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,5,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"6","index":6,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[29,7,29,10],[30,7,30,10],[34,7,34,10],[35,7,35,10],[34,5,35,5],[29,6,30,6],[34,6,35,6],[29,5,30,5],[19,4,26,4],[48,2,48,6],[48,7,48,14],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[31,7,31,10],[36,7,36,10],[39,12,39,13],[42,2,42,5],[46,7,46,10],[29,3,31,3],[34,2,36,2],[34,3,36,3],[6,11,6,13],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[9,7,9,10],[9,11,9,13],[34,4,36,4],[29,4,31,4],[29,2,31,2],[4,2,4,7],[6,2,7,5],[9,4,9,6],[25,7,25,10],[26,7,26,10],[23,7,23,10],[24,7,24,10],[22,6,24,6],[19,6,21,6],[25,5,26,5],[25,6,26,6],[19,3,26,3],[19,2,26,2]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D14),\"\",Offertvergleich!D14)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R14","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,6,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"7","index":7,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,2,48,6],[48,7,48,14],[39,12,39,13],[42,2,42,5],[46,7,46,10],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,7,34,10],[35,7,35,10],[34,6,35,6],[34,5,35,5],[4,2,4,7],[6,2,7,5],[9,4,9,6],[29,3,31,3],[19,3,26,3],[19,2,26,2],[29,2,31,2],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[30,7,30,10],[24,7,24,10],[29,7,29,10],[29,4,31,4],[19,4,26,4],[22,6,24,6],[19,6,21,6],[25,6,26,6],[29,5,30,5],[25,5,26,5],[29,6,30,6],[31,7,31,10],[36,7,36,10],[9,11,9,13],[9,7,9,10],[6,11,6,13],[25,7,25,10],[26,7,26,10]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D15),\"\",Offertvergleich!D15)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R15","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,7,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"8","index":8,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[29,7,29,10],[30,7,30,10],[34,7,34,10],[35,7,35,10],[34,5,35,5],[29,6,30,6],[34,6,35,6],[29,5,30,5],[19,4,26,4],[48,2,48,6],[48,7,48,14],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[31,7,31,10],[36,7,36,10],[39,12,39,13],[42,2,42,5],[46,7,46,10],[29,3,31,3],[34,2,36,2],[34,3,36,3],[6,11,6,13],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[9,7,9,10],[9,11,9,13],[34,4,36,4],[29,4,31,4],[29,2,31,2],[4,2,4,7],[6,2,7,5],[9,4,9,6],[25,7,25,10],[26,7,26,10],[23,7,23,10],[24,7,24,10],[22,6,24,6],[19,6,21,6],[25,5,26,5],[25,6,26,6],[19,3,26,3],[19,2,26,2]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D16),\"\",Offertvergleich!D16)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R16","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,8,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"9","index":9,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,7,34,10],[35,7,35,10],[34,6,35,6],[34,5,35,5],[48,2,48,6],[48,7,48,14],[39,12,39,13],[42,2,42,5],[46,7,46,10],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[4,2,4,7],[6,2,7,5],[9,4,9,6],[29,3,31,3],[19,3,26,3],[19,2,26,2],[29,2,31,2],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[30,7,30,10],[24,7,24,10],[29,7,29,10],[29,4,31,4],[19,4,26,4],[22,6,24,6],[19,6,21,6],[25,6,26,6],[29,5,30,5],[25,5,26,5],[29,6,30,6],[31,7,31,10],[36,7,36,10],[9,11,9,13],[9,7,9,10],[6,11,6,13],[25,7,25,10],[26,7,26,10]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D17),\"\",Offertvergleich!D17)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R17","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,9,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"10","index":10,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[39,12,39,13],[42,2,42,5],[46,7,46,10],[48,2,48,6],[48,7,48,14],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[6,11,6,13],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[9,7,9,10],[9,11,9,13],[29,3,31,3],[34,2,36,2],[34,3,36,3],[29,7,29,10],[30,7,30,10],[34,7,34,10],[35,7,35,10],[34,5,35,5],[29,6,30,6],[34,6,35,6],[29,5,30,5],[34,4,36,4],[29,4,31,4],[29,2,31,2],[31,7,31,10],[36,7,36,10],[4,2,4,7],[6,2,7,5],[9,4,9,6],[25,7,25,10],[26,7,26,10],[23,7,23,10],[24,7,24,10],[22,6,24,6],[19,6,21,6],[25,5,26,5],[25,6,26,6],[19,3,26,3],[19,2,26,2],[19,4,26,4]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D18),\"\",Offertvergleich!D18)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R18","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,10,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"11","index":11,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,7,34,10],[35,7,35,10],[34,6,35,6],[34,5,35,5],[48,2,48,6],[48,7,48,14],[39,12,39,13],[42,2,42,5],[46,7,46,10],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[4,2,4,7],[6,2,7,5],[9,4,9,6],[29,3,31,3],[19,3,26,3],[19,2,26,2],[29,2,31,2],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[30,7,30,10],[24,7,24,10],[29,7,29,10],[29,4,31,4],[19,4,26,4],[22,6,24,6],[19,6,21,6],[25,6,26,6],[29,5,30,5],[25,5,26,5],[29,6,30,6],[31,7,31,10],[36,7,36,10],[9,11,9,13],[9,7,9,10],[6,11,6,13],[25,7,25,10],[26,7,26,10]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D19),\"\",Offertvergleich!D19)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R19","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,11,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"12","index":12,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[39,12,39,13],[42,2,42,5],[46,7,46,10],[48,2,48,6],[48,7,48,14],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[6,11,6,13],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[9,7,9,10],[9,11,9,13],[29,3,31,3],[34,2,36,2],[34,3,36,3],[29,7,29,10],[30,7,30,10],[34,7,34,10],[35,7,35,10],[34,5,35,5],[29,6,30,6],[34,6,35,6],[29,5,30,5],[34,4,36,4],[29,4,31,4],[29,2,31,2],[31,7,31,10],[36,7,36,10],[4,2,4,7],[6,2,7,5],[9,4,9,6],[25,7,25,10],[26,7,26,10],[23,7,23,10],[24,7,24,10],[22,6,24,6],[19,6,21,6],[25,5,26,5],[25,6,26,6],[19,3,26,3],[19,2,26,2],[19,4,26,4]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D20),\"\",Offertvergleich!D20)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R20","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,12,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"13","index":13,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,7,34,10],[35,7,35,10],[34,6,35,6],[34,5,35,5],[48,2,48,6],[48,7,48,14],[39,12,39,13],[42,2,42,5],[46,7,46,10],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[4,2,4,7],[6,2,7,5],[9,4,9,6],[29,3,31,3],[19,3,26,3],[19,2,26,2],[29,2,31,2],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[30,7,30,10],[24,7,24,10],[29,7,29,10],[29,4,31,4],[19,4,26,4],[22,6,24,6],[19,6,21,6],[25,6,26,6],[29,5,30,5],[25,5,26,5],[29,6,30,6],[31,7,31,10],[36,7,36,10],[9,11,9,13],[9,7,9,10],[6,11,6,13],[25,7,25,10],[26,7,26,10]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D21),\"\",Offertvergleich!D21)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R21","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,13,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"14","index":14,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[39,12,39,13],[42,2,42,5],[46,7,46,10],[48,2,48,6],[48,7,48,14],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[6,11,6,13],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[9,7,9,10],[9,11,9,13],[29,3,31,3],[34,2,36,2],[34,3,36,3],[29,7,29,10],[30,7,30,10],[34,7,34,10],[35,7,35,10],[34,5,35,5],[29,6,30,6],[34,6,35,6],[29,5,30,5],[34,4,36,4],[29,4,31,4],[29,2,31,2],[31,7,31,10],[36,7,36,10],[4,2,4,7],[6,2,7,5],[9,4,9,6],[25,7,25,10],[26,7,26,10],[23,7,23,10],[24,7,24,10],[22,6,24,6],[19,6,21,6],[25,5,26,5],[25,6,26,6],[19,3,26,3],[19,2,26,2],[19,4,26,4]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D22),\"\",Offertvergleich!D22)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R22","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,14,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"15","index":15,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,7,34,10],[35,7,35,10],[34,6,35,6],[34,5,35,5],[48,2,48,6],[48,7,48,14],[39,12,39,13],[42,2,42,5],[46,7,46,10],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[4,2,4,7],[6,2,7,5],[9,4,9,6],[29,3,31,3],[19,3,26,3],[19,2,26,2],[29,2,31,2],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[30,7,30,10],[24,7,24,10],[29,7,29,10],[29,4,31,4],[19,4,26,4],[22,6,24,6],[19,6,21,6],[25,6,26,6],[29,5,30,5],[25,5,26,5],[29,6,30,6],[31,7,31,10],[36,7,36,10],[9,11,9,13],[9,7,9,10],[6,11,6,13],[25,7,25,10],[26,7,26,10]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D23),\"\",Offertvergleich!D23)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R23","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,15,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"16","index":16,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[39,12,39,13],[42,2,42,5],[46,7,46,10],[48,2,48,6],[48,7,48,14],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[6,11,6,13],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[9,7,9,10],[9,11,9,13],[29,3,31,3],[34,2,36,2],[34,3,36,3],[29,7,29,10],[30,7,30,10],[34,7,34,10],[35,7,35,10],[34,5,35,5],[29,6,30,6],[34,6,35,6],[29,5,30,5],[34,4,36,4],[29,4,31,4],[29,2,31,2],[31,7,31,10],[36,7,36,10],[4,2,4,7],[6,2,7,5],[9,4,9,6],[25,7,25,10],[26,7,26,10],[23,7,23,10],[24,7,24,10],[22,6,24,6],[19,6,21,6],[25,5,26,5],[25,6,26,6],[19,3,26,3],[19,2,26,2],[19,4,26,4]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D24),\"\",Offertvergleich!D24)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R24","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,16,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]

{"sheet":"17","index":17,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,2,36,2],[34,3,36,3],[34,4,36,4],[34,7,34,10],[35,7,35,10],[34,6,35,6],[34,5,35,5],[48,2,48,6],[48,7,48,14],[39,12,39,13],[42,2,42,5],[46,7,46,10],[39,2,40,2],[39,3,40,3],[39,7,39,11],[40,7,40,11],[40,12,40,13],[4,2,4,7],[6,2,7,5],[9,4,9,6],[29,3,31,3],[19,3,26,3],[19,2,26,2],[29,2,31,2],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[30,7,30,10],[24,7,24,10],[29,7,29,10],[29,4,31,4],[19,4,26,4],[22,6,24,6],[19,6,21,6],[25,6,26,6],[29,5,30,5],[25,5,26,5],[29,6,30,6],[31,7,31,10],[36,7,36,10],[9,11,9,13],[9,7,9,10],[6,11,6,13],[25,7,25,10],[26,7,26,10]]}
[null,null,null,null,null,null,null,"Ja","Nein"]
[]
[null,null,"Amt für Verkehr und Tiefbau"]
[]
[null,null,{"$f":"IF(ISBLANK(Offertvergleich!E4),\"\",Offertvergleich!E4)","v":""}]
[]
[null,null,"Submission Bau",null,null,null,null,"Auswerter:",{"$f":"IF(ISBLANK('1'!I7),\"\",'1'!I7)","v":""},null,"Datum:",{"$f":"IF(ISNUMBER(Offertvergleich!$T$29),Offertvergleich!$T$29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Unterschrift:"]
[]
[null,null,"Anbieter:",null,{"$f":"IF(ISBLANK(Offertvergleich!D25),\"\",Offertvergleich!D25)","v":""},null,null,"Bereinigte Angebotssumme (CHF):",null,null,null,{"$f":"Offertvergleich!R25","v":""}]
[]
[null,null,"Eignungskriterium 1",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Eignungskriterium 2",null,null,"erfüllt",null,null,"nicht erfüllt"]
[]
[null,null,"Kriterien K",null,"gK","Teilkriterien TK","gTK","Unterkriterien",null,null,null,"gUTK","Pkt.","QW"]
[]
[null,null,"Zuschlagskriterien"]
[]
[null,null,"1.","Kompetenz",{"$f":"IF(ISBLANK('1'!E20),\"\",'1'!E20)","v":""},{"$f":"IF(ISBLANK('1'!F20),\"\",'1'!F20)","v":""},{"$f":"IF(ISBLANK('1'!G20),\"\",'1'!G20)","v":""},{"$f":"IF(ISBLANK('1'!H20),\"\",'1'!H20)","v":"Relevante Arbeitsgattungen z.B. Stahlbetonbauwerke(Brückenbau)"},{"$f":"IF(ISBLANK('1'!I20),\"\",'1'!I20)","v":""},{"$f":"IF(ISBLANK('1'!J20),\"\",'1'!J20)","v":""},{"$f":"IF(ISBLANK('1'!K20),\"\",'1'!K20)","v":""},{"$f":"IF(ISBLANK('1'!L20),\"\",'1'!L20)","v":""},null,{"$f":"IF(ISNUMBER(M20),$E$20*$G$20*L20*M20,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E21),\"\",'1'!E21)","v":""},{"$f":"IF(ISBLANK('1'!F21),\"\",'1'!F21)","v":"Referenz des Anbieters für vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G21),\"\",'1'!G21)","v":""},{"$f":"IF(ISBLANK('1'!H21),\"\",'1'!H21)","v":"Strassenbau"},{"$f":"IF(ISBLANK('1'!I21),\"\",'1'!I21)","v":""},{"$f":"IF(ISBLANK('1'!J21),\"\",'1'!J21)","v":""},{"$f":"IF(ISBLANK('1'!K21),\"\",'1'!K21)","v":""},{"$f":"IF(ISBLANK('1'!L21),\"\",'1'!L21)","v":""},null,{"$f":"IF(ISNUMBER(M21),$E$20*$G$20*L21*M21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E22),\"\",'1'!E22)","v":""},{"$f":"IF(ISBLANK('1'!F22),\"\",'1'!F22)","v":""},{"$f":"IF(ISBLANK('1'!G22),\"\",'1'!G22)","v":""},{"$f":"IF(ISBLANK('1'!H22),\"\",'1'!H22)","v":"Kanalisationsbauwerke"},{"$f":"IF(ISBLANK('1'!I22),\"\",'1'!I22)","v":""},{"$f":"IF(ISBLANK('1'!J22),\"\",'1'!J22)","v":""},{"$f":"IF(ISBLANK('1'!K22),\"\",'1'!K22)","v":""},{"$f":"IF(ISBLANK('1'!L22),\"\",'1'!L22)","v":""},null,{"$f":"IF(ISNUMBER(M22),$E$20*$G$20*L22*M22,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E23),\"\",'1'!E23)","v":""},{"$f":"IF(ISBLANK('1'!F23),\"\",'1'!F23)","v":""},{"$f":"IF(ISBLANK('1'!G23),\"\",'1'!G23)","v":""},{"$f":"IF(ISBLANK('1'!H23),\"\",'1'!H23)","v":"Bauführer"},{"$f":"IF(ISBLANK('1'!I23),\"\",'1'!I23)","v":""},{"$f":"IF(ISBLANK('1'!J23),\"\",'1'!J23)","v":""},{"$f":"IF(ISBLANK('1'!K23),\"\",'1'!K23)","v":""},{"$f":"IF(ISBLANK('1'!L23),\"\",'1'!L23)","v":""},null,{"$f":"IF(ISNUMBER(M23),$E$20*$G$23*L23*M23,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E24),\"\",'1'!E24)","v":""},{"$f":"IF(ISBLANK('1'!F24),\"\",'1'!F24)","v":"Referenzen Schlüsselpersonal vergleichbare Projekte"},{"$f":"IF(ISBLANK('1'!G24),\"\",'1'!G24)","v":""},{"$f":"IF(ISBLANK('1'!H24),\"\",'1'!H24)","v":"Polier"},{"$f":"IF(ISBLANK('1'!I24),\"\",'1'!I24)","v":""},{"$f":"IF(ISBLANK('1'!J24),\"\",'1'!J24)","v":""},{"$f":"IF(ISBLANK('1'!K24),\"\",'1'!K24)","v":""},{"$f":"IF(ISBLANK('1'!L24),\"\",'1'!L24)","v":""},null,{"$f":"IF(ISNUMBER(M24),$E$20*$G$23*L24*M24,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E25),\"\",'1'!E25)","v":""},{"$f":"IF(ISBLANK('1'!F25),\"\",'1'!F25)","v":""},{"$f":"IF(ISBLANK('1'!G25),\"\",'1'!G25)","v":""},{"$f":"IF(ISBLANK('1'!H25),\"\",'1'!H25)","v":"bei sehr grossen Baustellen auch Baustellenleiter"},{"$f":"IF(ISBLANK('1'!I25),\"\",'1'!I25)","v":""},{"$f":"IF(ISBLANK('1'!J25),\"\",'1'!J25)","v":""},{"$f":"IF(ISBLANK('1'!K25),\"\",'1'!K25)","v":""},{"$f":"IF(ISBLANK('1'!L25),\"\",'1'!L25)","v":""},null,{"$f":"IF(ISNUMBER(M25),$E$20*$G$23*L25*M25,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E26),\"\",'1'!E26)","v":""},{"$f":"IF(ISBLANK('1'!F26),\"\",'1'!F26)","v":"Baustellenbezogene Organisation (Organigramm)"},{"$f":"IF(ISBLANK('1'!G26),\"\",'1'!G26)","v":""},{"$f":"IF(ISBLANK('1'!H26),\"\",'1'!H26)","v":"Angaben zu Schlüsselfunktionen "},{"$f":"IF(ISBLANK('1'!I26),\"\",'1'!I26)","v":""},{"$f":"IF(ISBLANK('1'!J26),\"\",'1'!J26)","v":""},{"$f":"IF(ISBLANK('1'!K26),\"\",'1'!K26)","v":""},{"$f":"IF(ISBLANK('1'!L26),\"\",'1'!L26)","v":""},null,{"$f":"IF(ISNUMBER(M26),$E$20*$G$26*L26*M26,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E27),\"\",'1'!E27)","v":""},{"$f":"IF(ISBLANK('1'!F27),\"\",'1'!F27)","v":""},{"$f":"IF(ISBLANK('1'!G27),\"\",'1'!G27)","v":""},{"$f":"IF(ISBLANK('1'!H27),\"\",'1'!H27)","v":"Schnittstellen zu Dritten"},{"$f":"IF(ISBLANK('1'!I27),\"\",'1'!I27)","v":""},{"$f":"IF(ISBLANK('1'!J27),\"\",'1'!J27)","v":""},{"$f":"IF(ISBLANK('1'!K27),\"\",'1'!K27)","v":""},{"$f":"IF(ISBLANK('1'!L27),\"\",'1'!L27)","v":""},null,{"$f":"IF(ISNUMBER(M27),$E$20*$G$26*L27*M27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N28),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N20:N27)>0,SUM(N20:N27),\"\")","v":""}]
[]
[null,null,"2.","Qualität",{"$f":"IF(ISBLANK('1'!E30),\"\",'1'!E30)","v":""},{"$f":"IF(ISBLANK('1'!F30),\"\",'1'!F30)","v":"Auftragsanalyse und Massnahmenplanung"},{"$f":"IF(ISBLANK('1'!G30),\"\",'1'!G30)","v":""},{"$f":"IF(ISBLANK('1'!H30),\"\",'1'!H30)","v":"Auftragsanalyse"},{"$f":"IF(ISBLANK('1'!I30),\"\",'1'!I30)","v":""},{"$f":"IF(ISBLANK('1'!J30),\"\",'1'!J30)","v":""},{"$f":"IF(ISBLANK('1'!K30),\"\",'1'!K30)","v":""},{"$f":"IF(ISBLANK('1'!L30),\"\",'1'!L30)","v":""},null,{"$f":"IF(ISNUMBER(M30),$E$30*$G$30*L30*M30,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E31),\"\",'1'!E31)","v":""},{"$f":"IF(ISBLANK('1'!F31),\"\",'1'!F31)","v":""},{"$f":"IF(ISBLANK('1'!G31),\"\",'1'!G31)","v":""},{"$f":"IF(ISBLANK('1'!H31),\"\",'1'!H31)","v":"Massnahmenplanung mit Zuständigkeiten"},{"$f":"IF(ISBLANK('1'!I31),\"\",'1'!I31)","v":""},{"$f":"IF(ISBLANK('1'!J31),\"\",'1'!J31)","v":""},{"$f":"IF(ISBLANK('1'!K31),\"\",'1'!K31)","v":""},{"$f":"IF(ISBLANK('1'!L31),\"\",'1'!L31)","v":""},null,{"$f":"IF(ISNUMBER(M31),$E$30*$G$30*L31*M31,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E32),\"\",'1'!E32)","v":""},{"$f":"IF(ISBLANK('1'!F32),\"\",'1'!F32)","v":""},{"$f":"IF(ISBLANK('1'!G32),\"\",'1'!G32)","v":""},{"$f":"IF(ISBLANK('1'!H32),\"\",'1'!H32)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L32),\"\",'1'!L32)","v":""},null,{"$f":"IF(ISNUMBER(M32),$E$30*G32*M32,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N33),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N30:N32)>0,SUM(N29:N32),\"\")","v":""}]
[]
[null,null,"3.","Bauprogramm",{"$f":"IF(ISBLANK('1'!E35),\"\",'1'!E35)","v":""},{"$f":"IF(ISBLANK('1'!F35),\"\",'1'!F35)","v":"Bauprogramm des Anbieters"},{"$f":"IF(ISBLANK('1'!G35),\"\",'1'!G35)","v":""},{"$f":"IF(ISBLANK('1'!H35),\"\",'1'!H35)","v":"Bauzeit"},{"$f":"IF(ISBLANK('1'!I35),\"\",'1'!I35)","v":""},{"$f":"IF(ISBLANK('1'!J35),\"\",'1'!J35)","v":""},{"$f":"IF(ISBLANK('1'!K35),\"\",'1'!K35)","v":""},{"$f":"IF(ISBLANK('1'!L35),\"\",'1'!L35)","v":""},null,{"$f":"IF(ISNUMBER(M35),$E$35*$G$35*L35*M35,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E36),\"\",'1'!E36)","v":""},{"$f":"IF(ISBLANK('1'!F36),\"\",'1'!F36)","v":""},{"$f":"IF(ISBLANK('1'!G36),\"\",'1'!G36)","v":""},{"$f":"IF(ISBLANK('1'!H36),\"\",'1'!H36)","v":"Bauvorgang, Abläufe"},{"$f":"IF(ISBLANK('1'!I36),\"\",'1'!I36)","v":""},{"$f":"IF(ISBLANK('1'!J36),\"\",'1'!J36)","v":""},{"$f":"IF(ISBLANK('1'!K36),\"\",'1'!K36)","v":""},{"$f":"IF(ISBLANK('1'!L36),\"\",'1'!L36)","v":""},null,{"$f":"IF(ISNUMBER(M36),$E$35*$G$35*L36*M36,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK('1'!E37),\"\",'1'!E37)","v":""},{"$f":"IF(ISBLANK('1'!F37),\"\",'1'!F37)","v":"Personaleinsatz"},{"$f":"IF(ISBLANK('1'!G37),\"\",'1'!G37)","v":""},{"$f":"IF(ISBLANK('1'!H37),\"\",'1'!H37)","v":""},null,null,null,{"$f":"IF(ISBLANK('1'!L37),\"\",'1'!L37)","v":""},null,{"$f":"IF(ISNUMBER(M37),$E$35*G37*M37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(N38),\"Summe\",\"\")","v":""},{"$f":"IF(SUM(N35:N37)>0,SUM(N34:N37),\"\")","v":""}]
[]
[null,null,"4.","Zuschläge",null,"Lernendenausbildung",null,null,null,null,null,null,{"$f":"IF(ISTEXT(G40),IF(G40=\"Ja\",2,0),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK('1'!F41),\"\",'1'!F41)","v":""},null,null,null,null,null,null,{"$f":"IF(ISTEXT(G41),IF(G41=\"Ja\",2,0),\"\")","v":""}]
[]
[null,null,"Die Beurteilungspunkte werden mit dem Faktor P \nkorrigiert [Formel = K / (P +(1-P) * Q / 100)]             ",null,null,null,{"$f":"IF(ISBLANK('1'!G43),\"\",'1'!G43)","v":0},null,null,null,"Summe der Beurteilungspunkte (max.",{"$f":"'1'!L43","v":104},"Punkte)",{"$f":"IF(SUM(N28,N33,N38,M40,M41)>0,SUM(N28,N33,N38,M40,M41),\"\")","v":""}]
[]
[null,null,"Der Beurteilungspreis wird berechnet aus der bereinigten Angebotssumme dividiert durch die Summe der korrigierten Beurteilungspunkte."]
[]
[null,null,null,null,null,"    Beurteilungspreis   =","CHF",{"$f":"IF(ISNUMBER(L10),IF(ISNUMBER(N43),ROUND(L10/(G43+(1-G43)*N43/100)*2,1)/2,\"\"),\"\")","v":""}]
[]
[null,null,"Anbeiter",null,null,null,null,17,null,null,null,null,{"$f":"IF(ISNUMBER(Offertvergleich!T29),Offertvergleich!T29,\"\")","v":""}]