{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Doku_Kontrolle","Präferenzmatrix","Kriterienkatalog","Beispiel Kriterienkatalog"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":2,"defined_names":4,"comments":2,"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":"Doku_Kontrolle","index":0,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[41,0,41,3],[42,0,42,3],[2,0,2,4],[28,0,28,2],[37,0,37,3],[38,0,38,3],[39,0,39,3],[40,0,40,3]]}
["Projekt XYZ"]
["Kriterienkatalog Beschaffung"]
["Im Kriterienkatalog werden die Auswahlkriterien für die Evaluation eines Produkts oder eines Lieferanten festgelegt."]
["Änderungsgeschichte"]
[]
["Version","Datum","Autor","Status","Bemerkungen / Änderungen"]
[null,null,null,null,"Initiale Version"]
[]
[]
[]
[]
[]
[]
[]
["(ausserhalb des Druckbereiches)"]
["Referenzierte Dokumente (exkl. eigentliche Anforderungsdokumente)"]
[]
["Version","Datum","Autor(en)","Status","Dokument"]
[]
[]
[]
[]
[]
[]
[]
[]
["Freigabe durch den Lenkungs-/Steuerungsausschuss"]
[]
["Name",null,null,"Datum"]
[]
[]
[]
[]
[]
[]
["Verteiler"]
[]
["Name",null,null,null,"Name"]

{"sheet":"Präferenzmatrix","index":1,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"Präferenzmatrix"]
[null,"für das Projekt",null,null,null,"\"Projektname\""]
[null,"Gewicht","Rang-","Anzahl"]
[null,null,"folge","Nen-",null,"Ziele"]
[null,null,null,"nungen"]
[null,{"$f":"(D6*100)/D45","v":100},{"$f":"RANK(D6,D6:D44)","v":1},{"$f":"COUNTIF(G7:Y43,\"a\")","v":1},"a","Anbieterbezogene Kriterien"]
[]
[null,{"$f":"(D8*100)/D45","v":0},{"$f":"RANK(D8,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"b\")","v":0},"b","Hardwarebezogene Kriterien",null,"a"]
[]
[null,{"$f":"(D10*100)/D45","v":0},{"$f":"RANK(D10,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"c\")","v":0},"c","Systemsoftwarebezogene Kriterien"]
[]
[null,{"$f":"(D12*100)/D45","v":0},{"$f":"RANK(D12,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"d\")","v":0},"d","Entwicklungstoolbezogene Kriterien"]
[]
[null,{"$f":"(D14*100)/D45","v":0},{"$f":"RANK(D14,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"e\")","v":0},"e","Kriterien bezüglich nicht funktionalen Anforderungen"]
[]
[null,{"$f":"(D16*100)/D45","v":0},{"$f":"RANK(D16,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"f\")","v":0},"f","Realisierungsbezogene Kriterien"]
[]
[null,{"$f":"(D18*100)/D45","v":0},{"$f":"RANK(D18,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"g\")","v":0},"g","Kostenbezogene Kriterien"]
[]
[null,{"$f":"(D20*100)/D45","v":0},{"$f":"RANK(D20,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"h\")","v":0},"h","Offertkriterien"]
[]
[null,{"$f":"(D22*100)/D45","v":0},{"$f":"RANK(D22,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"i\")","v":0},"i"]
[]
[null,{"$f":"(D24*100)/D45","v":0},{"$f":"RANK(D24,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"j\")","v":0},"j"]
[]
[null,{"$f":"(D26*100)/D45","v":0},{"$f":"RANK(D26,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"k\")","v":0},"k"]
[]
[null,{"$f":"(D28*100)/D45","v":0},{"$f":"RANK(D28,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"l\")","v":0},"l"]
[]
[null,{"$f":"(D30*100)/D45","v":0},{"$f":"RANK(D30,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"m\")","v":0},"m"]
[]
[null,{"$f":"(D32*100)/D45","v":0},{"$f":"RANK(D32,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"n\")","v":0},"n"]
[]
[null,{"$f":"(D34*100)/D45","v":0},{"$f":"RANK(D34,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"o\")","v":0},"o"]
[]
[null,{"$f":"(D26*100)/D45","v":0},{"$f":"RANK(D36,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"p\")","v":0},"p"]
[]
[null,{"$f":"(D38*100)/D45","v":0},{"$f":"RANK(D38,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"q\")","v":0},"q"]
[]
[null,{"$f":"(D40*100)/D45","v":0},{"$f":"RANK(D40,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"r\")","v":0},"r"]
[]
[null,{"$f":"(D42*100)/D45","v":0},{"$f":"RANK(D42,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"s\")","v":0},"s"]
[]
[null,{"$f":"(D44*100)/D45","v":0},{"$f":"RANK(D44,D6:D44)","v":2},{"$f":"COUNTIF(G7:Y43,\"t\")","v":0},"t"]
["Total",{"$f":"SUM(B6:B44)","v":100},null,{"$f":"SUM(D6:D44)","v":1}]

{"sheet":"Kriterienkatalog","index":2,"n_rows":112,"n_cols":18,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,7,0,11]]}
["Kriterienhierarchie",null,null,null,null,"W","a","Relatives Gewicht in %",null,null,null,null,"max.","P","Offerte 1",null,"Offerte 2"]
["Stufe1","Stufe 2","Stufe 3","Stufe 4","Stufe 5",null,null,"E1","E2","E3","E4","E5","Nutzwert",null,"P1","eff.","P2","eff."]
["1 Applikationssoftware"]
[null,"11 Globale Anforderungen"]
[null,null,"111 Funktionale Leistung"]
[null,null,null,"1111 Applikatorische Integration"]
[null,null,null,"1112 Einheitlichkeit und Konsistenz"]
[null,null,"112 Uebrige Softwarequalität"]
[null,null,null,"1121 Benutzbarkeit"]
[null,null,null,"1122 Datenschutz / Sicherheit"]
[null,null,null,"1123 Wartbarkeit"]
[null,"12 Verkaufsabwicklung Fertigprodukte"]
[null,null,"121 Funktionale Leistung"]
[null,null,null,"1211 Verwaltung Stammdaten"]
[null,null,null,null,"12111 Mutationen Artikel"]
[null,null,null,null,"12112 Mutationen Kunden"]
[null,null,null,null,"12113 Mutationen übrige Daten"]
[null,null,null,null,"12114 Inhalt der Daten"]
[null,null,null,null,"12115 Kalkulation Preise"]
[null,null,null,null,"12116 Abfragen"]
[null,null,null,"1212 Offertabwicklung"]
[null,null,null,null,"12121 Erfassen Anfragen MAG"]
[null,null,null,null,"12122 Erfassen Anfragen Internet"]
[null,null,null,null,"12123 Verwaltung/Aendern"]
[null,null,null,null,"12124 Fristenkontrolle"]
[null,null,null,null,"12125 Druck der Offerte"]
[null,null,null,null,"12126 Web-Publishing"]
[null,null,null,null,"12127 Offertberichtswesen"]
[null,null,null,"1213 Auftragsbearbeitung"]
[null,null,null,null,"12131 Auftragserfassung MAG"]
[null,null,null,null,"12132 Auftragserfassung Kunde"]
[null,null,null,null,"12133 Auftragsverwaltung"]
[null,null,null,null,"12134 Druck Rüstpapiere"]
[null,null,null,null,"12135 Erfassung Aenderungen"]
[null,null,null,null,"12136 Druck Lieferscheine"]
[null,null,null,"1214 Garantieretourenbehandlung"]
[null,null,null,null,"12141 ............."]
[null,null,null,null,"12142 ................"]
[null,null,null,"1215 Auftragsabrechnung"]
[null,null,null,null,"12151 ................"]
[null,null,null,null,"12152 ................"]
[null,null,null,"1216 Verkaufsinformation"]
[null,null,null,null,"12161 ................"]
[null,null,null,null,"12162 ................"]
[null,null,null,"1217 Marketingunterstützung"]
[null,null,null,null,"12171 ..............."]
[null,null,null,null,"12172 ..............."]
[null,null,"122 Uebrige Softwarequalität"]
[null,null,null,"1221 Effizienz, Leistung"]
[null,null,null,"1222 Zuverlässigkeit, Robustheit"]
[null,"13 Ersatzteilabwicklung inkl. Lagerführung"]
[null,null,"131 Funktionale Leistung"]
[null,null,null,"1311 Ersatzteilverkauf"]
[null,null,null,null,"13111..........."]
[null,null,null,null,"13112 .........."]
[null,null,null,"1312 Ersatzteilbezug aus Kundendienst"]
[null,null,null,null,"13121 .................."]
[null,null,"132 Uebrige Softwarequalität"]
[null,null,null,"1321 Effizienz, Leistung"]
[null,null,null,"1322 Zuverlässigkeit, Robustheit"]
[null,"14 Kundendienstunterstützung inkl. Werkstatt"]
[null,"15 Einkaufsabwicklung"]
[null,"16 Finanz- und Rechnungswesen"]
[null,"17 Personalwirtschaft"]
[null,"18 Büromatik inkl. DMS"]
[null,null,"181 Funktionale Leistung"]
[null,null,null,"1811 Integration MS-Office-Produkte"]
[null,null,null,"1812 Dokumenten Management"]
[null,null,"182 Uebrige Softwarequalität"]
[null,null,null,"1821 Effizienz, Leistung"]
[null,null,null,"1822 Zuverlässigkeit, Robustheit"]
[null,"19 Datenkonversion"]
["2 Systemplattform"]
[null,"21 Systemkonzept"]
[null,"22 Hintergrundsysteme"]
[null,null,"221 Server, Datensicherung"]
[null,null,null,"2211 Leistung"]
[null,null,null,"2212 Zuverlässigkeit"]
[null,null,"222 Spezialgeräte, Ausgabesysteme"]
[null,"23 Arbeitsplatzsysteme"]
[null,null,"231 Neue Terminals"]
[null,null,"232 Integration bestehender Geräte"]
[null,null,"233 Neue Drucker"]
[null,null,"234 Scanner"]
[null,"24 Systemsoftware"]
[null,"25 Kommunikationsinfrastruktur"]
[null,null,"251 LAN/WAN"]
[null,null,"252 Internet"]
["3 Anbieterbezogene Anforderungen"]
[null,"31 Generelle Firmenmerkmale"]
[null,null,"311 Marktstellung und Perspektiven"]
[null,null,null,"3111 Systemintegrator"]
[null,null,null,"3112 Softwarehersteller"]
[null,null,null,"3113 Hardwarehersteller"]
[null,null,"312 Referenzen"]
[null,"32 Dienstleistungen"]
[null,null,"321 Realisierungsleistungen"]
[null,null,"322 Schulungsleistungen"]
[null,null,"323 Unterstüzung Betrieb"]
[null,null,"324 Wartungsleistungen"]
[null,"33 Projektorganisation"]
[null,null,"331 Methoden, Verfahren"]
[null,null,"332 Projektaufbauorganisation"]
[null,null,"333 Projektstruktur"]
[null,"34 Termine"]
[null,"35 Vertragliche Gewährleistungen"]
[null,null,"351 Vertragsgegenstand"]
[null,null,"352 Preise"]
[null,null,"353 Lieferungen und Zahlungsbedingungen"]
[null,null,"354 Gewährleistung/Haftung"]
[null,null,"355 ................"]
["Total"]

{"sheet":"Beispiel Kriterienkatalog","index":3,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Kriterienhierarchie",null,null,null,null,"W","a","Relatives Gewicht in %",null,null,null,null,"max.","P","Offerte 1",null,"Offerte 2"]
["Stufe1","Stufe 2","Stufe 3","Stufe 4","Stufe 5",null,null,"E1","E2","E3","E4","E5","Nutzwert","max.","P1","eff.","P2","eff."]
["1 Applikationssoftware",null,null,null,null,null,null,45,null,null,null,null,45,{"$f":"SUM(6*M3)","v":270},null,{"$f":"SUM(P4:P21)","v":116.91}]
[null,"11 Globale Anforderungen",null,null,null,null,null,null,20,null,null,null,9,{"$f":"SUM(6*M4)","v":54}]
[null,null,"111 Funktionale Leistung",null,null,null,null,null,null,50,null,null,4.5,{"$f":"SUM(6*M5)","v":27}]
[null,null,null,"1111 Applikatorische Integration",null,null,null,null,null,null,70,null,3.15,{"$f":"SUM(6*M6)","v":18.899999999999999},4,{"$f":"SUM(M6*O6)","v":12.6}]
[null,null,null,"1112 Einheitlichkeit und Konsistenz",null,null,null,null,null,null,30,null,1.35,{"$f":"SUM(6*M7)","v":8.1000000000000014},2,{"$f":"SUM(M7*O7)","v":2.7}]
[null,null,"112 Uebrige Softwarequalität",null,null,null,null,null,null,50,null,null,4.5,{"$f":"SUM(6*M8)","v":27}]
[null,null,null,"1121 Benutzbarkeit",null,null,null,null,null,null,10,null,0.45,2.7,1,0.45]
[null,null,null,"1122 Datenschutz / Sicherheit",null,null,null,null,null,null,30,null,1.35,8.1000000000000014,5,6.75]
[null,null,null,"1123 Wartbarkeit",null,null,null,null,null,null,60,null,2.7,16.200000000000003,5,13.5]
[null,"12 Verkaufsabwicklung Fertigprodukte",null,null,null,null,null,null,30,null,null,null,13.5,81]
[null,null,"121 Funktionale Leistung",null,null,null,null,null,null,80,null,null,10.8,64.800000000000011]
[null,null,null,"1211 Verwaltung Stammdaten",null,null,null,null,null,null,100,null,10.8,64.800000000000011]
[null,null,null,null,"12111 Mutationen Artikel",null,null,null,null,null,null,40,4.32,25.92,2,8.64]
[null,null,null,null,"12112 Mutationen Kunden",null,null,null,null,null,null,60,6.48,38.880000000000003,4,25.92]
[null,null,"122 Uebrige Softwarequalität",null,null,null,null,null,null,20,null,null,2.7,16.200000000000003]
[null,null,null,"1221 Effizienz, Leistung",null,null,null,null,null,null,90,null,2.4300000000000002,14.580000000000002,0,0]
[null,null,null,"1222 Zuverlässigkeit, Robustheit",null,null,null,null,null,null,10,null,0.27,1.62,5,1.35]
[null,"13 Ersatzteilabwicklung inkl. Lagerführung",null,null,null,null,null,null,50,null,null,null,22.5,135,2,45]
["2 Systemplattform",null,null,null,null,null,null,20]
[null,"21 Systemkonzept",null,null,null,null,null,null,30]
[null,"22 Hintergrundsysteme",null,null,null,null,null,null,20]
[null,null,"221 Server, Datensicherung"]
[null,null,null,"2211 Leistung"]
[null,null,null,"2212 Zuverlässigkeit"]
[null,"23 Kommunikationsinfrastruktur",null,null,null,null,null,null,50]
[null,null,"231 LAN/WAN"]
[null,null,"232 Internet"]
["3 Anbieterbezogene Anforderungen",null,null,null,null,null,null,35]
[null,"31 Generelle Firmenmerkmale",null,null,null,null,null,null,40]
[null,null,"311 Marktstellung und Perspektiven"]
[null,null,null,"3111 Systemintegrator"]
[null,null,null,"3112 Softwarehersteller"]
[null,null,null,"3113 Hardwarehersteller"]
[null,null,"312 Referenzen"]
[null,"32 Dienstleistungen",null,null,null,null,null,null,60]
[null,null,"321 Realisierungsleistungen"]
[null,null,"322 Schulungsleistungen"]
[null,null,"323 Unterstüzung Betrieb"]
[null,null,"324 Wartungsleistungen"]
["Total",null,null,null,null,null,null,100]
[]
["Skalierung: 0 - 6 (Werte, die in P1 / P2 eingetragen werden)"]