{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Start","B Bericht","H Hochrechnung","L Leistungen und Kosten","C TN-Statistik Sprachkurs","C TN-Statistik Kurs allg.","C TN-Statistik Erstinfo","C TN-Statistik Beratung","AP","HT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":111,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,2,36,3],[34,2,34,3],[35,2,35,3],[18,9,19,9],[30,5,30,7],[34,5,34,7],[3,10,6,10],[33,5,33,7],[11,2,11,7],[14,2,14,4],[15,2,15,4],[9,2,9,7],[10,2,10,6],[27,2,27,3],[28,2,28,3],[21,2,21,4],[22,2,22,4],[29,2,29,3],[30,2,30,3],[33,2,33,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,"Bitte Makros einschalten.",null,null,null,null,"ja"]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Migrantinnen / Migranten"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M4=\"Migrantinnen / Migranten\", \"A\",\"Flü\")","v":"A"}]
[null,null,null,null,null,null,null,{"$f":"HT!C1","v":"2023-11-23"}]
[]
[null,{"$f":"IF(M18=FALSE,\"Reporting (KIP 2bis) - allgemeine Angaben zu LV-Nr.\",\"Hochrechnung (KIP 2bis) - allgemeine Angaben zu LV-Nr.\")","v":"Reporting (KIP 2bis) - allgemeine Angaben zu LV-Nr."},null,null,null,null,null,"(bitte auswählen)"]
[]
[null,"Jahr"]
[null,"Förderbereich"]
[null,"Angebotsname"]
[]
[null,"Formular-Optionen"]
[null,"Angebotsart"]
[null,"TN-Statistiken",null,null,false]
[null,"TN-Zufriedenheit erheben?",null,null,null,null,null,null,null,null,null,null,false]
[null,"Hochrechnung erfassen",null,null,null,null,null,null,null,null,null,null,false]
[]
[null,"Angaben zum Auftraggeber"]
[]
[null,"Gemeinde / Amt","Fachstelle Integration"]
[null,"Kontaktperson:"]
[]
[]
[null,"Angaben zum Anbieter","Bitte überprüfen und ggf. anpassen und ergänzen."]
[]
[null,"Organisation",null,null,null,"AOZ"]
[null,"Strasse & Nr.",null,null,"PLZ / Ort",null,null,null,"i"]
[null,"Telefon"]
[null,"E-Mail",null,null,"Internet"]
[]
[null,"Kontaktperson:"]
[null,"Name",null,null,"Vorname"]
[null,"Funktion",null,null,"Abteilung"]
[null,"Telefon"]
[null,"E-Mail"]

{"sheet":"B Bericht","index":1,"n_rows":58,"n_cols":19,"rows_kept":58,"cut":false,"hidden":false,"merged":[[26,1,26,17],[1,20,2,21],[9,19,11,19],[18,2,18,17],[5,16,5,17],[1,16,2,16],[9,2,9,16],[11,2,11,16],[12,2,12,16],[13,2,13,16],[10,2,10,15],[20,19,22,19],[19,2,19,17],[24,1,24,17],[25,2,25,17],[23,2,23,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Start!H6","v":"2023-11-23"}]
[]
[null,"Reporting (KIP 2bis) - Bericht zu LV-Nr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Start!$H$8=\"(bitte auswählen)\",\"\",Start!$H$8)","v":""}]
[]
[null,"Jahr",{"$f":"IF(Start!C10=\"\",\"\",Start!C10)","v":""}]
[null,"Förderbereich",{"$f":"IF(Start!C11=\"\",\"\",Start!C11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Start!C11=\"\",\"\",Start!H11)","v":""}]
[null,"Angebotsname",{"$f":"IF(Start!C12=\"\",\"\",Start!C12)","v":""}]
[null,"Anbieter",{"$f":"IF(Start!C28=\"\",\"\",Start!C28)","v":""}]
[null,"Auftraggeber",{"$f":"IF(OR(Start!C22=\"\",Start!C22=\"(bitte auswählen)\"),\"\",Start!C22)","v":"Fachstelle Integration"}]
[]
[null,"1. Inhaltliche Angaben"]
[]
[null,"Ergebnis"]
[null,"Was hat im Zusammenhang mit dem Angebot gut funktioniert?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[null,"Was hat im Zusammenhang mit dem Angebot nicht so gut funktioniert? Warum nicht?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[null,"Zufriedenheit der Teilnehmenden","sehr gut",null,"gut",null,"genügend",null,"ungenügend"]
[null,"Anzahl Nennungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","i"]
[]
[null,"allgemeine Angaben hierzu"]
[null,"Vorgeschlagene Änderungen"]
[null,"Konzept, Aufbau, Struktur, Inhalte, Zielgruppe, Organisation, Kooperation, QS,…","     "]
[]
[null,"2. Leistungen gem. Angebotsart"]
[]
[null,"Realisierte Veranstaltungen, Anlässe (Info- / Begegnungs- / Vernetzungsangebote etc.)"]
[]
[null,null,"geplant",null,null,null,null,null,null,null,null,"effektiv"]
[null,"Anzahl Veranstaltungen",null,"mit total ",null,null,"Teilnehmenden",null,null,null,null,null,"mit total ",null,null,"Teilnehmenden"]
[]
[]
[null,"Realisierte Angebote für Einzelpersonen (Beratungen, Besuche bei aufsuchenden Projekten)"]
[]
[null,null,"geplant",null,null,null,null,null,null,null,null,"effektiv"]
[null,"Anzahl Beratungen/ Besuche",null,"mit total ",null,null,"beratenen Personen",null,null,null,null,null,"mit total ",null,null,"beratenen Personen"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No-shows"]
[]
[]
[null,"Realisierte Kurse"]
[]
[null,null,"geplant",null,null,null,null,null,null,null,null,"effektiv"]
[null,"Anzahl Kurse",null,"mit total ",null,null,"Teilnehmenden",null,null,null,null,null,"mit total ",null,null,"Teilnehmenden"]
[]
[null,"mit total",null,"Lektionen"]
[]
[]
[null,"Realisierte Arbeitsintegrationsprogramme"]
[]
[null,null,"geplant",null,null,null,null,null,null,null,null,"effektiv besetzt"]
[null,"Zur Verfügung stehende Plätze"]
[]
[]
[null,"Leistungserfassung entfällt."]

{"sheet":"H Hochrechnung","index":2,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":true,"merged":[[18,1,20,1],[18,16,18,17],[19,16,19,17],[19,18,19,19],[20,2,20,5],[20,16,20,17],[20,18,20,19],[0,5,4,17],[1,19,2,19],[5,19,5,20],[7,17,7,20],[9,2,9,20],[10,2,10,18],[10,19,10,20],[21,2,21,5],[21,16,21,17],[21,18,21,19],[22,2,22,5],[22,16,22,17],[22,18,22,19],[11,2,11,20],[12,2,12,20],[13,2,13,20],[25,2,25,5],[25,16,25,17],[25,18,25,19],[26,2,26,5],[26,16,26,17],[26,18,26,19],[23,2,23,5],[23,16,23,17],[23,18,23,19],[24,2,24,5],[24,16,24,17],[24,18,24,19],[29,2,29,5],[29,16,29,17],[29,18,29,19],[30,2,30,5],[30,16,30,17],[30,18,30,19],[27,2,27,5],[27,16,27,17],[27,18,27,19],[28,2,28,5],[28,16,28,17],[28,18,28,19],[33,2,33,5],[33,16,33,17],[33,18,33,19],[34,2,34,5],[34,16,34,17],[34,18,34,19],[31,2,31,5],[31,16,31,17],[31,18,31,19],[32,2,32,5],[32,16,32,17],[32,18,32,19],[37,2,37,5],[37,16,37,17],[37,18,37,19],[38,2,38,5],[38,16,38,17],[38,18,38,19],[35,2,35,5],[35,16,35,17],[35,18,35,19],[36,2,36,5],[36,16,36,17],[36,18,36,19],[41,2,41,5],[41,16,41,17],[41,18,41,19],[42,2,42,5],[42,16,42,17],[42,18,42,19],[39,2,39,5],[39,16,39,17],[39,18,39,19],[40,2,40,5],[40,16,40,17],[40,18,40,19],[45,2,45,5],[45,16,45,17],[45,18,45,19],[46,2,46,5],[46,16,46,17],[46,18,46,19],[43,2,43,5],[43,16,43,17],[43,18,43,19],[44,2,44,5],[44,16,44,17],[44,18,44,19],[49,2,49,5],[49,16,49,17],[49,18,49,19],[50,2,50,5],[50,16,50,17],[50,18,50,19],[47,2,47,5],[47,16,47,17],[47,18,47,19],[48,2,48,5],[48,16,48,17],[48,18,48,19],[59,7,59,14],[59,16,59,17],[59,18,59,19],[60,7,60,14],[60,16,60,17],[60,18,60,19],[52,16,52,17],[52,18,52,19],[56,16,56,17],[56,18,56,19],[58,16,58,17],[58,18,58,19],[68,2,68,20],[69,2,69,20],[63,16,63,17],[63,18,63,19],[64,16,64,17],[64,18,64,19],[66,16,66,17],[66,18,66,19],[61,7,61,14],[61,16,61,17],[61,18,61,19],[62,7,62,14],[62,16,62,17],[62,18,62,19]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Start!H6","v":"2023-11-23"}]
[]
[null,"Hochrechnung (KIP 2bis) - Leistungen und Kosten zu LV-Nr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Start!H8=\"(bitte auswählen)\",\"\",Start!H8)","v":""}]
[null,null,{"$f":"R8","v":""}]
[null,"Jahr",{"$f":"IF(Start!C10=\"\",\"\",Start!C10)","v":""}]
[null,"Förderbereich",{"$f":"IF(Start!C11=\"\",\"\",Start!C11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Start!C11=\"\",\"\",Start!H11)","v":""}]
[null,"Angebotsname",{"$f":"IF(Start!C12=\"\",\"\",Start!C12)","v":""}]
[null,"Anbieter",{"$f":"IF(Start!C28=\"\",\"\",Start!C28)","v":""}]
[null,"Auftraggeber",{"$f":"IF(OR(Start!C22=\"\",Start!C22=\"(bitte auswählen)\"),\"\",Start!C22)","v":"Fachstelle Integration"}]
[]
[null,"2. Hochrechnung zu Leistungen und Kosten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Für den Schlussbericht bitte die Lasche \"L Leistungen und Kosten\" ausfüllen. Hochrechnung ist nicht ausreichend."]
[]
[null,"Kosten"]
[null,"Leistungen gem. Leistungs-vereinbarung","Leistung",null,null,null,null,"Menge",null,null,null,null,"Kosten pro Einheit",null,null,null,"Gesamtkosten"]
[null,null,null,null,null,null,null,"geplant",null,"effektiv",null,null,"geplant",null,"effektiv",null,"geplant",null,"effektiv",null,null,null,{"$f":"COUNTA(C21:C51)+21","v":24},{"$f":"20+COUNTA(A21:A51)","v":51}]
["L",null,"Leistung",null,null,null," ",null,null,null,null," ",{"$f":"IF(H21=0,0,Q21/H21)","v":0},null,{"$f":"M21","v":0},null,null,null,{"$f":"IF(J21<>0,J21*O21,0)","v":0}]
["L",null,"Leistung",null,null,null," ",null,null,null,null," ",0,null,{"$f":"M22","v":0},null,null,null,0,null,null,"L"]
["L",null,"Leistung",null,null,null," ",null,null,null,null," ",0,null,0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,{"$f":"H24","v":0},null,{"$f":"J24","v":0},null,0,{"$f":"IF(I24=0,0,#REF!/I24)","v":0},{"$f":"M24","v":0},null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I25=0,0,#REF!/I25)","v":0},{"$f":"M25","v":0},null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I26=0,0,#REF!/I26)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I27=0,0,#REF!/I27)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I28=0,0,#REF!/I28)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I29=0,0,#REF!/I29)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I30=0,0,#REF!/I30)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I31=0,0,#REF!/I31)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I32=0,0,#REF!/I32)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I33=0,0,#REF!/I33)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I34=0,0,#REF!/I34)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I35=0,0,#REF!/I35)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I36=0,0,#REF!/I36)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I37=0,0,#REF!/I37)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I38=0,0,#REF!/I38)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I39=0,0,#REF!/I39)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I40=0,0,#REF!/I40)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I41=0,0,#REF!/I41)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I42=0,0,#REF!/I42)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I43=0,0,#REF!/I43)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I44=0,0,#REF!/I44)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I45=0,0,#REF!/I45)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I46=0,0,#REF!/I46)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I47=0,0,#REF!/I47)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I48=0,0,#REF!/I48)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I49=0,0,#REF!/I49)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(I50=0,0,#REF!/I50)","v":0},0,null,null,null,0,null,null,"L"]
["L",null,null,null,null,null," ",null,0,null,0," ",0,{"$f":"IF(I51=0,0,#REF!/I51)","v":0},0,null,null,null,0,null,null,"L"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(Q21:Q52)","v":0},null,{"$f":"SUM(S21:S52)","v":0},null,null,null,null,null,"Ausgewählte Zeile löschen."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zeile hinzufügen."]
[null,"Finanzierung"]
[]
[null,"Gesamtkosten","Gesamtkosten für das Angebot (evtl. höher als Kostendach gem. LV)"]
[]
[null,"Beiträge/Erlöse","Beitrag Fachstelle Integration gemäss Aufstellung unter Kosten/Leistungen)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q53","v":0},null,{"$f":"IF(S53>Q53,Q53,S53)","v":0},{"$f":"T53","v":0}]
[null,null,"weitere Beiträge der öffentlichen Hand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[]
[null,null,"zugesicherte Beiträge Dritter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[]
[null,null,"Beiträge von Teilnehmenden"]
[null,null,"Erlöse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[]
[null,null,{"$f":"\"Saldo\"&IF(Q67<>0,\" Planwerte prüfen, Saldo muss 0 ergeben\",\"\")","v":"Saldo"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q59:Q65)-Q57","v":0},null,{"$f":"SUM(S59:T65)-S57","v":0},null,null,"i"]
[]
[null,"Bemerkungen, Begründung für negativen Saldo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[null,"Begründung für Abweichungen von den geplanten Leistungen und  Kosten"]

{"sheet":"L Leistungen und Kosten","index":3,"n_rows":70,"n_cols":28,"rows_kept":70,"cut":false,"hidden":false,"merged":[[61,7,61,15],[59,7,59,15],[69,2,69,23],[60,17,60,18],[62,17,62,18],[60,20,60,21],[62,20,62,21],[50,17,50,18],[49,20,49,21],[50,2,50,5],[50,20,50,21],[52,20,52,21],[68,2,68,23],[63,20,63,21],[64,20,64,21],[66,20,66,21],[63,17,63,18],[64,17,64,18],[61,20,61,21],[61,17,61,18],[66,17,66,18],[59,20,59,21],[58,20,58,21],[56,20,56,21],[60,7,60,15],[59,17,59,18],[37,17,37,18],[37,20,37,21],[38,17,38,18],[38,20,38,21],[44,20,44,21],[48,20,48,21],[42,20,42,21],[43,20,43,21],[45,20,45,21],[46,20,46,21],[47,20,47,21],[32,17,32,18],[28,2,28,5],[25,2,25,5],[37,2,37,5],[52,17,52,18],[58,17,58,18],[48,2,48,5],[49,2,49,5],[49,17,49,18],[44,2,44,5],[44,17,44,18],[38,2,38,5],[46,2,46,5],[46,17,46,18],[47,2,47,5],[47,17,47,18],[48,17,48,18],[42,2,42,5],[42,17,42,18],[43,2,43,5],[43,17,43,18],[45,2,45,5],[45,17,45,18],[56,17,56,18],[34,17,34,18],[35,17,35,18],[35,20,35,21],[21,20,21,21],[22,20,22,21],[22,17,22,18],[30,17,30,18],[32,2,32,5],[33,2,33,5],[29,2,29,5],[31,2,31,5],[26,2,26,5],[27,2,27,5],[28,17,28,18],[24,20,24,21],[22,2,22,5],[30,2,30,5],[23,17,23,18],[23,20,23,21],[29,20,29,21],[25,20,25,21],[26,17,26,18],[26,20,26,21],[31,20,31,21],[18,1,20,1],[19,17,19,18],[20,2,20,5],[19,20,19,21],[40,2,40,5],[40,17,40,18],[40,20,40,21],[41,2,41,5],[41,17,41,18],[41,20,41,21],[18,17,18,18],[29,17,29,18],[27,17,27,18],[27,20,27,21],[39,2,39,5],[39,17,39,18],[39,20,39,21],[21,2,21,5],[21,17,21,18],[24,2,24,5],[24,17,24,18],[23,2,23,5],[20,20,20,21],[20,17,20,18],[62,7,62,15],[0,5,4,18],[1,21,2,21],[5,21,5,23],[10,2,10,20],[7,18,7,23],[9,2,9,23],[10,21,10,23],[11,2,11,23],[12,2,12,23],[13,2,13,23],[30,20,30,21],[25,17,25,18],[28,20,28,21],[35,2,35,5],[36,2,36,5],[31,17,31,18],[32,20,32,21],[33,17,33,18],[33,20,33,21],[34,20,34,21],[36,17,36,18],[34,2,34,5],[36,20,36,21]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Start!H6","v":"2023-11-23"}]
[]
[null,"Reporting (KIP 2bis) - Leistungen und Kosten zu LV-Nr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Start!H8=\"(bitte auswählen)\",\"\",Start!H8)","v":""}]
[null,null,{"$f":"S8","v":""}]
[null,"Jahr",{"$f":"IF(Start!C10=\"\",\"\",Start!C10)","v":""}]
[null,"Förderbereich",{"$f":"IF(Start!C11=\"\",\"\",Start!C11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Start!C11=\"\",\"\",Start!H11)","v":""}]
[null,"Angebotsname",{"$f":"IF(Start!C12=\"\",\"\",Start!C12)","v":""}]
[null,"Anbieter",{"$f":"IF(Start!C28=\"\",\"\",Start!C28)","v":""}]
[null,"Auftraggeber",{"$f":"IF(OR(Start!C22=\"\",Start!C22=\"(bitte auswählen)\"),\"\",Start!C22)","v":"Fachstelle Integration"}]
[]
[null,"2. Leistungen und Kosten"]
[null,null,null,null,null,null,null,null,"ggf. grüne",null,"ggf. grüne",null,null,null,null,"ggf. grüne",null,null,null,"ggf. grüne"]
[null,"Kosten",null,null,null,null,null,null,"Felder korrigieren",null,"Felder korrigieren",null,null,null,null,"Felder korrigieren",null,null,null,"Felder korrigieren"]
[null,"Leistungen gem. Leistungs-vereinbarung","Leistung",null,null,null,null,"Menge",null,null,null,null,"Kosten pro Einheit",null,null,null,null,"Beitrag FI"]
[null,null,null,null,null,null,null,"geplant","Plan gem. LV/BU","effektiv","Ist gem.Unterlagen",null,"geplant","Plan gem. LV/BU","effektiv","Ist. gem.Unterlagen",null,"geplant",null,"Plan gem. LV/BU","effektiv",null,"Ist. gem.Unterlagen",null,null,{"$f":"COUNTA(C21:C51)+21","v":24},{"$f":"20+COUNTA(A21:A51)","v":51}]
["L",null,"Leistung",null,null,null," ",null,{"$f":"H21","v":0},null,{"$f":"J21","v":0}," ",{"$f":"IF(H21=0,0,R21/H21)","v":0},{"$f":"IF(I21=0,0,T21/I21)","v":0},null,{"$f":"O21","v":0},null,null,null,{"$f":"R21","v":0},{"$f":"IF(J21<>0,ROUND(J21*O21/5,2)*5,0)","v":0},null,{"$f":"IF(J21<>0,ROUND(K21*P21/5,2)*5,0)","v":0}]
["L",null,"Leistung",null,null,null," ",null,{"$f":"H22","v":0},null,0," ",{"$f":"IF(H22=0,0,R22/H22)","v":0},{"$f":"IF(I22=0,0,T22/I22)","v":0},null,0,null,null,null,{"$f":"R22","v":0},{"$f":"IF(J22<>0,ROUND(J22*O22/5,2)*5,0)","v":0},null,{"$f":"IF(J22<>0,ROUND(K22*P22/5,2)*5,0)","v":0},null,"L"]
["L",null,"Leistung",null,null,null," ",null,{"$f":"H23","v":0},null,{"$f":"J23","v":0}," ",{"$f":"IF(H23=0,0,R23/H23)","v":0},{"$f":"IF(I23=0,0,T23/I23)","v":0},null,{"$f":"O23","v":0},null,null,null,{"$f":"R23","v":0},0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,{"$f":"H24","v":0},null,{"$f":"J24","v":0},null,{"$f":"IF(H24=0,0,R24/H24)","v":0},{"$f":"IF(I24=0,0,T24/I24)","v":0},null,0,null,null,null,{"$f":"R24","v":0},0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null,null,null,0,null,0,null,0,0,null,0,null,null,null,0,0,null,0,null,"L"]
["L",null,null,null,null,null," ",null,0,null,0," ",0,0,null,0,null,null,null,0,0,null,0,null,"L"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"ROUND(SUM(R21:R52),2)","v":0},null,{"$f":"ROUND(SUM(T21:T52),2)","v":0},{"$f":"ROUND(SUM(U21:U52),2)","v":0},null,{"$f":"ROUND(SUM(W21:W52),2)","v":0},null,null,null,null,"Ausgewählte Zeile löschen."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zeile hinzufügen."]
[null,"Finanzierung"]
[]
[null,"Gesamtkosten","Gesamtkosten für das Angebot (evtl. höher als Kostendach gem. LV)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R57","v":0},null,null,{"$f":"U57","v":0}]
[]
[null,"Beiträge/Erlöse","Beitrag Fachstelle Integration gemäss Aufstellung unter Kosten/Leistungen)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R53","v":0},null,{"$f":"T53","v":0},{"$f":"IF(U53>R53,R53,U53)","v":0},{"$f":"V53","v":0},{"$f":"IF(W53>T53,T53,W53)","v":0}]
[null,null,"weitere Beiträge der öffentlichen Hand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R60","v":0},null,null,{"$f":"U60","v":0},null,"i"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,"zugesicherte Beiträge Dritter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,"i"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,"Beiträge von Teilnehmenden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,"Erlöse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,"i"]
[]
[null,null,{"$f":"\"Saldo\"&IF(R67<>0,\" Planwerte prüfen, Saldo muss 0 ergeben\",\"\")","v":"Saldo"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R59:R65)-R57","v":0},null,{"$f":"SUM(T59:T65)-T57","v":0},{"$f":"SUM(U59:V65)-U57","v":0},null,{"$f":"SUM(W59:W65)-W57","v":0},null,"i"]
[]
[null,"Bemerkungen, Begründung für negativen Saldo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[null,"Begründung für Abweichungen von den geplanten Leistungen und  Kosten"]

{"sheet":"C TN-Statistik Sprachkurs","index":4,"n_rows":37,"n_cols":28,"rows_kept":37,"cut":false,"hidden":true,"merged":[[9,10,10,10],[9,12,9,13],[9,16,9,20],[6,25,7,25],[33,25,36,25],[11,25,16,25],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,6,10,6],[6,3,7,6],[6,9,7,14],[6,23,6,24],[9,8,10,8],[9,9,10,9],[9,7,10,7],[9,22,9,24],[9,11,10,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B:B)+12","v":32}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Start!$H$6","v":"2023-11-23"},"hellblau = Berichterstattung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"grün = Ankreuzen: Doppelklick"]
[null,{"$f":"\"Teilnehmerstatistik Sprachkurs zu LV-Nr.     \"&IF(Start!$H$8=\"(bitte auswählen)\",\"\",Start!$H$8)","v":"Teilnehmerstatistik Sprachkurs zu LV-Nr.     "}]
[]
[null,"Anbieter:",null,{"$f":"Start!C28&\"\"","v":""},null,null,null,null,"Kursname:",{"$f":"Start!C12&\"\"","v":""},null,null,null,null,null,"Niveau GER:",null,"-",null,"Bezeichnung:",null,null,null,null,null,"Wenn der Standort nicht eindeutig eine Gemeinde ist, dann leer lassen.\nAls Bezeichnung eine eindeutige Nummer angeben, z.B. \"N2014Q1K2\""]
[]
[]
[null,"TN","Name","Vorname","Geschlecht\n(F/M/D)","Alter","Wohnort","In der Schweiz seit\n(Jahr JJJJ)","Nationalität","Muttersprache","Aufenthaltsstatus","schulgewohnt","Kinder",null,"Bisher besuchte Deutschkurse*","Vom Kurs erfahren durch","Ergebnis",null,null,null,null,null,"eigene\n(intern)"]
[null,null,null,null,null,"Geburtsjahr (JJJJ) ",null,null,null,null,null,null,"Anzahl während Kurs in Kinder­\nbetreuung","Alter (Jahre)","(keine, \ngleicher Anbieter, anderer Anbieter)","(vorheriger Kurs, Behörde/Amt, Schule, Freunde,  Familie, Flyer, Internet,…)","Lernfortschritt **","Anmeldung für Folgekurs…","…oder andere Kursart/Schule","Kurs vorzeitig abgebrochen","TELC-Zertifikat\n(Test absolviert)",null,"Bezahlter TN-Beitrag in CHF","frei 1","frei 2"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Es ist nich erlaubt, Personendaten ohne Rechtsgrundlage weiterzugeben.\nDaten dürfen von Anbietern nur an Gemeinden weiteregegeben werden, wenn die Gemeinde diese zur Erfüllung ihrer Aufgaben benötigt.\nDie FI benötigt keine Personendaten.\n\nSiehe auch Merkblatt Datenschutz\n\nAuftraggeber entscheidet teilweise selber, was ausgefüllt wird"]
[null,2,null,null,null,null,null,null,null,null,""]
[null,3,null,null,null,null,null,null,null,null,""]
[null,4,null,null,null,null,null,null,null,null,""]
[null,5,null,null,null,null,null,null,null,null,""]
[null,6,null,null,null,null,null,null,null,null,""]
[null,7,null,null,null,null,null,null,null,null,""]
[null,8,null,null,null,null,null,null,null,null,""]
[null,9,null,null,null,null,null,null,null,null,""]
[null,10,null,null,null,null,null,null,null,null,""]
[null,11,null,null,null,null,null,null,null,null,""]
[null,12,null,null,null,null,null,null,null,null,""]
[null,13,null,null,null,null,null,null,null,null,""]
[null,14,null,null,null,null,null,null,null,null,""]
[null,15,null,null,null,null,null,null,null,null,""]
[null,16]
[null,17]
[null,18]
[null,19,null,null,null,null,null,null,null,null,""]
[null,20,null,null,null,null,null,null,null,null,""]
[null,"* Bei Übertritt aus dem letzten Kurs: \"gleicher Anbieter\" auswählen"]
[null,"** (0 = kein, 1 = geringer, 2 = guter, 3 = grosser Fortschritt)"]
[null,"Mittelwerte",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(N12:N33)=0,\"-\",AVERAGE(N12:N33))","v":"-"}]
[null,"Total",null,null,{"$f":"COUNTIF(E12:E34,\"F\")","v":0},"(F)",null,null,null,null,{"$f":"COUNTIF(K12:K34,\"X\")","v":0},{"$f":"COUNTIF(L12:L34,\"X\")","v":0},{"$f":"SUM(M12:M34)","v":0},null,null,null,null,{"$f":"COUNTIF(R12:R34,\"X\")","v":0},{"$f":"COUNTIF(S12:S34,\"X\")","v":0},{"$f":"COUNTIF(T12:T34,\"X\")","v":0},{"$f":"COUNTIF(U12:U34,\"X\")","v":0},null,{"$f":"SUM(W12:W34)","v":0},{"$f":"COUNTIF(X12:X34,\"X\")","v":0},{"$f":"COUNTIF(Y12:Y34,\"X\")","v":0}]
[null,null,null,null,{"$f":"COUNTIF(E12:E34,\"M\")","v":0},"(M)"]
[null,null,null,null,{"$f":"COUNTIF(E12:E34,\"D\")","v":0},"(D)"]

{"sheet":"C TN-Statistik Kurs allg.","index":5,"n_rows":37,"n_cols":28,"rows_kept":37,"cut":false,"hidden":true,"merged":[[6,25,7,25],[11,25,16,25],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,6,10,6],[6,23,6,24],[6,3,7,6],[6,9,7,14],[33,25,36,25],[9,7,10,7],[9,22,9,24],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,11,10,11],[9,12,9,13],[9,16,9,20]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B:B)+12","v":32}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Start!$H$6","v":"2023-11-23"},"hellblau = Berichterstattung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"grün = Ankreuzen: Doppelklick"]
[null,{"$f":"\"Teilnehmerstatistik Kurs zu LV-Nr.     \"&IF(Start!$H$8=\"(bitte auswählen)\",\"\",Start!$H$8)","v":"Teilnehmerstatistik Kurs zu LV-Nr.     "}]
[]
[null,"Anbieter:",null,{"$f":"Start!C28&\"\"","v":""},null,null,null,null,"Kursname:",{"$f":"Start!C12&\"\"","v":""},null,null,null,null,null,"Niveau GER:",null,"-",null,"Bezeichnung:",null,null,null,null,null,"Wenn der Standort nicht eindeutig eine Gemeinde ist, dann leer lassen.\nAls Bezeichnung eine eindeutige Nummer angeben, z.B. \"N2014Q1K2\""]
[]
[]
[null,"TN","Name","Vorname","Geschlecht\n(F/M/D)","Alter","Wohnort","In der Schweiz seit\n(Jahr JJJJ)","Nationalität","Muttersprache","Aufenthaltsstatus","schulgewohnt","Kinder",null,"Bisher besuchte Kurse*","Vom Kurs erfahren durch","Ergebnis",null,null,null,null,null,"eigene\n(intern)"]
[null,null,null,null,null,"Geburtsjahr (JJJJ) ",null,null,null,null,null,null,"Anzahl während Kurs in Kinder­\nbetreuung","Alter (Jahre)","(keine, \ngleicher Anbieter, anderer Anbieter)","(vorheriger Kurs, Behörde/Amt, Schule, Freunde,  Familie, Flyer, Internet,…)","Lernfortschritt **","Anmeldung für Folgekurs…","…oder andere Kursart/Schule","Kurs vorzeitig abgebrochen","frei",null,"Bezahlter TN-Beitrag in CHF","frei 1","frei 2"]
[null,1,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Es ist nich erlaubt, Personendaten ohne Rechtsgrundlage weiterzugeben.\nDaten dürfen von Anbietern nur an Gemeinden weiteregegeben werden, wenn die Gemeinde diese zur Erfüllung ihrer Aufgaben benötigt.\nDie FI benötigt keine Personendaten.\n\nSiehe auch Merkblatt Datenschutz\n\nAuftraggeber entscheidet teilweise selber, was ausgefüllt wird"]
[null,2,null,null,null,null,null,null,null,null,""]
[null,3,null,null,null,null,null,null,null,null,""]
[null,4,null,null,null,null,null,null,null,null,""]
[null,5,null,null,null,null,null,null,null,null,""]
[null,6,null,null,null,null,null,null,null,null,""]
[null,7,null,null,null,null,null,null,null,null,""]
[null,8,null,null,null,null,null,null,null,null,""]
[null,9,null,null,null,null,null,null,null,null,""]
[null,10,null,null,null,null,null,null,null,null,""]
[null,11,null,null,null,null,null,null,null,null,""]
[null,12,null,null,null,null,null,null,null,null,""]
[null,13]
[null,14,null,null,null,null,null,null,null,null,""]
[null,15,null,null,null,null,null,null,null,null,""]
[null,16,null,null,null,null,null,null,null,null,""]
[null,17,null,null,null,null,null,null,null,null,""]
[null,18,null,null,null,null,null,null,null,null,""]
[null,19]
[null,20]
[null,"*Bei Übertritt aus dem letzten Kurs: \"gleicher Anbieter\" auswählen"]
[null,"** (0 = kein, 1 = geringer, 2 = guter, 3 = grosser Fortschritt)"]
[null,"Mittelwerte",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(N12:N33)=0,\"-\",AVERAGE(N12:N33))","v":"-"}]
[null,"Total",null,null,{"$f":"COUNTIF(E12:E34,\"F\")","v":0},"(F)",null,null,null,null,{"$f":"COUNTIF(K12:K34,\"X\")","v":0},{"$f":"COUNTIF(L12:L34,\"X\")","v":0},{"$f":"SUM(M12:M34)","v":0},null,null,null,null,{"$f":"COUNTIF(R12:R34,\"X\")","v":0},{"$f":"COUNTIF(S12:S34,\"X\")","v":0},{"$f":"COUNTIF(T12:T34,\"X\")","v":0},{"$f":"COUNTIF(U12:U34,\"X\")","v":0},null,{"$f":"SUM(W12:W34)","v":0},{"$f":"COUNTIF(X12:X34,\"X\")","v":0},{"$f":"COUNTIF(Y12:Y34,\"X\")","v":0}]
[null,null,null,null,{"$f":"COUNTIF(E12:E34,\"M\")","v":0},"(M)"]
[null,null,null,null,{"$f":"COUNTIF(E12:E34,\"D\")","v":0},"(D)"]

{"sheet":"C TN-Statistik Erstinfo","index":6,"n_rows":117,"n_cols":28,"rows_kept":117,"cut":false,"hidden":true,"merged":[[6,3,7,6],[6,9,7,14],[6,23,6,24],[9,22,9,24],[9,7,10,7],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,6,10,6],[1,20,2,20],[9,8,10,8],[9,26,11,26],[113,25,116,25],[9,17,9,20],[9,10,10,10],[9,11,10,11],[9,12,10,12],[9,13,10,13],[6,25,7,25],[11,25,16,25]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B:B)+12","v":111}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Start!$H$6","v":"2023-11-23"},"hellblau = Berichterstattung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"grün = Ankreuzen: Doppelklick"]
[null,{"$f":"\"Gesprächsstatistik Erstinformationsgespräche zu LV-Nr.     \"&IF(Start!$H$8=\"(bitte auswählen)\",\"\",Start!$H$8)","v":"Gesprächsstatistik Erstinformationsgespräche zu LV-Nr.     "}]
[]
[null,"Anbieter:",null,{"$f":"Start!C28&\"\"","v":""},null,null,null,null,"Kursname:",{"$f":"Start!C12&\"\"","v":""},null,null,null,null,null,null,null,null,null,"Bezeichnung:",null,null,null,null,null,"Wenn der Standort nicht eindeutig eine Gemeinde ist, dann leer lassen.\nAls Bezeichnung eine eindeutige Nummer angeben, z.B. \"N2014Q1K2\""]
[]
[]
[null,"TN","Name","Vorname","Geschlecht\n(F/M/D)","Alter","Wohnort","In der Schweiz seit\n(Jahr JJJJ)","Nationalität","Muttersprache","Aufenthaltsstatus","Anzahl Familien-mitglieder\ndabei","Erst-/ Folgeberatung\n(E/F)","mit Interkulturellem Übersetzer (IKÜ)","Beratungs-sprache","Vom Angebot erfahren durch","Art","Ergebnis",null,null,null,null,"eigene\n(intern)"]
[null,null,null,null,null,"Geburtsjahr (JJJJ) ",null,null,null,null,null,null,null,null,null,"(Einwohnerkontrolle, Schule, Freunde,  Familie, Flyer, Internet,…)","persönlich / telefonisch / schriftlich","Dauer der Beratung","Beratungs-schwerpunkt","Infomaterial abgegeben","Empfehlung für Folgegespräch, Deutschkurs, …",null,"frei 1","frei 2","frei 3"]
[null,1,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Es ist nich erlaubt, Personendaten ohne Rechtsgrundlage weiterzugeben.\nDaten dürfen von Anbietern nur an Gemeinden weiteregegeben werden, wenn die Gemeinde diese zur Erfüllung ihrer Aufgaben benötigt.\nDie FI benötigt keine Personendaten.\n\nSiehe auch Merkblatt Datenschutz\n\nAuftraggeber entscheidet teilweise selber, was ausgefüllt wird"]
[null,2,null,null,null,null,null,null,null,null,""]
[null,3]
[null,4,null,null,null,null,null,null,null,null,""]
[null,5,null,null,null,null,null,null,null,null,""]
[null,6,null,null,null,null,null,null,null,null,""]
[null,7,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zu erfassen sind Beratungen ab 15min. Aufwand"]
[null,8,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wenn im Beratungsgespräch eine Begleitperson übersetzt, dann bite bei \"Beratungssprache\" auswählen: \"Deutsch mit Übersetzung\""]
[null,9,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mögliche Daten für eigene Zusatzfelder:"]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+ nachfassen nötig"]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76,null,null,null,null,null,null,null,null,""]
[null,77,null,null,null,null,null,null,null,null,""]
[null,78,null,null,null,null,null,null,null,null,""]
[null,79,null,null,null,null,null,null,null,null,""]
[null,80,null,null,null,null,null,null,null,null,""]
[null,81,null,null,null,null,null,null,null,null,""]
[null,82,null,null,null,null,null,null,null,null,""]
[null,83,null,null,null,null,null,null,null,null,""]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94,null,null,null,null,null,null,null,null,""]
[null,95,null,null,null,null,null,null,null,null,""]
[null,96,null,null,null,null,null,null,null,null,""]
[null,97,null,null,null,null,null,null,null,null,""]
[null,98,null,null,null,null,null,null,null,null,""]
[null,99,null,null,null,null,null,null,null,null,""]
[null,"100",null,null,null,null,null,null,null,null,""]
[]
[]
[null,"Mittelwerte",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(N12:N113)=0,\"-\",AVERAGE(N12:N113))","v":"-"}]
[null,"Total",null,null,{"$f":"COUNTIF(E12:E114,\"F\")","v":0},"(F)",null,null,null,null,{"$f":"COUNTIF(K12:K114,\"X\")","v":0},{"$f":"SUM(L12:L114)","v":0},null,null,null,null,{"$f":"SUM(Q12:Q114)","v":0},null,null,{"$f":"COUNTIF(T12:T114,\"X\")","v":0},null,null,{"$f":"SUM(W12:W114)","v":0},{"$f":"COUNTIF(X12:X114,\"X\")","v":0},{"$f":"COUNTIF(Y12:Y114,\"X\")","v":0}]
[null,null,null,null,{"$f":"COUNTIF(E12:E114,\"M\")","v":0},"(M)"]
[null,null,null,null,{"$f":"COUNTIF(E12:E114,\"D\")","v":0},"(D)"]

{"sheet":"C TN-Statistik Beratung","index":7,"n_rows":117,"n_cols":28,"rows_kept":117,"cut":false,"hidden":true,"merged":[[6,3,7,6],[6,9,7,14],[6,23,6,24],[9,22,9,24],[9,7,10,7],[6,25,7,25],[1,20,2,20],[9,8,10,8],[9,26,11,26],[9,10,10,10],[9,11,10,11],[9,12,10,12],[9,13,10,13],[11,25,16,25],[113,25,116,25],[9,17,9,20],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,6,10,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B:B)+12","v":111}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Start!$H$6","v":"2023-11-23"},"hellblau = Berichterstattung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"grün = Ankreuzen: Doppelklick"]
[null,{"$f":"\"Gesprächsstatistik Beratung zu LV-Nr.     \"&IF(Start!$H$8=\"(bitte auswählen)\",\"\",Start!$H$8)","v":"Gesprächsstatistik Beratung zu LV-Nr.     "}]
[]
[null,"Anbieter:",null,{"$f":"Start!C28&\"\"","v":""},null,null,null,null,"Kursname:",{"$f":"Start!C12&\"\"","v":""},null,null,null,null,null,null,null,null,null,"Bezeichnung:",null,null,null,null,null,"Wenn der Standort nicht eindeutig eine Gemeinde ist, dann leer lassen.\nAls Bezeichnung eine eindeutige Nummer angeben, z.B. \"N2014Q1K2\""]
[]
[]
[null,"TN","Name","Vorname","Geschlecht\n(F/M/D)","Alter","Wohnort","In der Schweiz seit\n(Jahr JJJJ)","Nationalität","Muttersprache","Aufenthaltsstatus",null,"Erst-/ Folgeberatung\n(E/F)","mit Interkulturellem Übersetzer (IKÜ)","Beratungs-sprache","Vom Angebot erfahren durch","Art","Ergebnis",null,null,null,null,"eigene\n(intern)"]
[null,null,null,null,null,"Geburtsjahr (JJJJ) ",null,null,null,null,null,null,null,null,null,"(Einwohnerkontrolle, Schule, Freunde,  Familie, Flyer, Internet,…)","persönlich / telefonisch / schriftlich","Dauer der Beratung","Beratungs-schwerpunkt","Infomaterial abgegeben","Empfehlung für Folgegespräch, Kurs, Massnahme, Triage an andere",null,"frei 1","frei 2","frei 3"]
[null,1,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Es ist nich erlaubt, Personendaten ohne Rechtsgrundlage weiterzugeben.\nDaten dürfen von Anbietern nur an Gemeinden weiteregegeben werden, wenn die Gemeinde diese zur Erfüllung ihrer Aufgaben benötigt.\nDie FI benötigt keine Personendaten.\n\nSiehe auch Merkblatt Datenschutz\n\nAuftraggeber entscheidet teilweise selber, was ausgefüllt wird"]
[null,2,null,null,null,null,null,null,null,null,""]
[null,3,null,null,null,null,null,null,null,null,""]
[null,4,null,null,null,null,null,null,null,null,""]
[null,5,null,null,null,null,null,null,null,null,""]
[null,6,null,null,null,null,null,null,null,null,""]
[null,7,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zu erfassen sind Beratungen ab 15min. Aufwand"]
[null,8,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wenn im Beratungsgespräch eine Begleitperson übersetzt, dann bite bei \"Beratungssprache\" auswählen: \"Deutsch mit Übersetzung\""]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mögliche Daten für eigene Zusatzfelder:"]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+ nachfassen nötig"]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85,null,null,null,null,null,null,null,null,""]
[null,86,null,null,null,null,null,null,null,null,""]
[null,87,null,null,null,null,null,null,null,null,""]
[null,88,null,null,null,null,null,null,null,null,""]
[null,89,null,null,null,null,null,null,null,null,""]
[null,90,null,null,null,null,null,null,null,null,""]
[null,91,null,null,null,null,null,null,null,null,""]
[null,92,null,null,null,null,null,null,null,null,""]
[null,93,null,null,null,null,null,null,null,null,""]
[null,94,null,null,null,null,null,null,null,null,""]
[null,95,null,null,null,null,null,null,null,null,""]
[null,96,null,null,null,null,null,null,null,null,""]
[null,97,null,null,null,null,null,null,null,null,""]
[null,98,null,null,null,null,null,null,null,null,""]
[null,99,null,null,null,null,null,null,null,null,""]
[null,"100",null,null,null,null,null,null,null,null,""]
[]
[]
[null,"Mittelwerte",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(N12:N113)=0,\"-\",AVERAGE(N12:N113))","v":"-"}]
[null,"Total",null,null,{"$f":"COUNTIF(E12:E114,\"F\")","v":0},"(F)",null,null,null,null,{"$f":"COUNTIF(K12:K114,\"X\")","v":0},{"$f":"SUM(L12:L114)","v":0},null,null,null,null,{"$f":"SUM(Q12:Q114)","v":0},null,null,{"$f":"COUNTIF(T12:T114,\"X\")","v":0},null,null,{"$f":"SUM(W12:W114)","v":0},{"$f":"COUNTIF(X12:X114,\"X\")","v":0},{"$f":"COUNTIF(Y12:Y114,\"X\")","v":0}]
[null,null,null,null,{"$f":"COUNTIF(E12:E114,\"M\")","v":0},"(M)"]
[null,null,null,null,{"$f":"COUNTIF(E12:E114,\"D\")","v":0},"(D)"]

{"sheet":"AP","index":8,"n_rows":277,"n_cols":21,"rows_kept":277,"cut":false,"hidden":true,"merged":[[206,1,206,3],[206,5,206,7],[206,8,206,10],[203,1,203,3],[203,5,203,7],[203,8,203,10],[204,1,204,3],[204,5,204,7],[204,8,204,10],[205,1,205,3],[205,5,205,7],[205,8,205,10],[200,1,200,3],[200,5,200,7],[200,8,200,10],[201,1,201,3],[201,5,201,7],[201,8,201,10],[202,1,202,3],[202,5,202,7],[202,8,202,10],[196,8,196,10],[197,1,197,3],[197,5,197,7],[197,8,197,10],[198,1,198,3],[198,5,198,7],[198,8,198,10],[199,1,199,3],[199,5,199,7],[199,8,199,10],[189,1,189,3],[189,5,189,7],[189,8,189,10],[189,19,206,19],[190,1,190,3],[190,5,190,7],[190,8,190,10],[191,1,191,3],[191,5,191,7],[191,8,191,10],[192,1,192,3],[192,5,192,7],[192,8,192,10],[193,1,193,3],[193,5,193,7],[193,8,193,10],[194,1,194,3],[194,5,194,7],[194,8,194,10],[195,1,195,3],[195,5,195,7],[195,8,195,10],[196,1,196,3],[196,5,196,7],[211,1,211,3],[211,9,211,10],[212,2,212,3],[212,9,252,10],[213,2,213,3],[236,2,236,3],[237,2,237,3],[238,2,238,3],[239,2,239,3],[240,2,240,3],[214,2,214,3],[215,2,215,3],[217,2,217,3],[222,2,222,3],[223,2,223,3],[224,2,224,3],[225,2,225,3],[226,2,226,3],[235,2,235,3],[218,2,218,3],[219,2,219,3],[220,2,220,3],[221,2,221,3],[216,2,216,3],[268,20,269,20],[269,5,269,10],[264,1,264,4],[265,1,265,4],[266,1,266,4],[267,1,267,4],[268,1,269,4],[268,5,268,10],[241,2,241,3],[242,2,242,3],[261,1,261,4],[262,1,262,4],[263,1,263,4],[227,2,227,3],[228,2,228,3],[229,2,229,3],[230,2,230,3],[231,2,231,3],[232,2,232,3],[233,2,233,3],[234,2,234,3],[110,2,110,3],[111,2,111,3],[112,2,112,3],[113,2,113,3],[114,2,114,3],[115,2,115,3],[116,2,116,3],[125,2,125,3],[126,2,126,3],[117,2,117,3],[118,2,118,3],[119,2,119,3],[120,2,120,3],[121,2,121,3],[122,2,122,3],[123,2,123,3],[187,1,187,3],[187,5,187,7],[187,8,187,10],[188,1,188,3],[188,5,188,7],[188,8,188,10],[175,1,175,3],[175,5,175,7],[175,8,175,10],[180,4,180,10],[181,4,181,10],[186,1,186,3],[186,5,186,7],[186,8,186,10],[173,1,173,3],[173,5,173,7],[173,8,173,10],[174,1,174,3],[174,5,174,7],[174,8,174,10],[171,1,171,3],[171,5,171,7],[171,8,171,10],[172,1,172,3],[172,5,172,7],[172,8,172,10],[169,1,169,3],[169,5,169,7],[169,8,169,10],[170,1,170,3],[170,5,170,7],[170,8,170,10],[167,1,167,3],[167,5,167,7],[167,8,167,10],[168,1,168,3],[168,5,168,7],[168,8,168,10],[165,5,165,7],[165,8,165,10],[166,1,166,3],[166,5,166,7],[166,8,166,10],[163,1,163,3],[163,5,163,7],[163,8,163,10],[164,1,164,3],[164,5,164,7],[164,8,164,10],[158,19,175,19],[159,1,159,3],[159,5,159,7],[159,8,159,10],[160,1,160,3],[160,5,160,7],[160,8,160,10],[156,1,156,3],[156,5,156,7],[156,8,156,10],[156,19,157,19],[157,1,157,3],[157,5,157,7],[157,8,157,10],[161,1,161,3],[161,5,161,7],[161,8,161,10],[162,1,162,3],[162,5,162,7],[162,8,162,10],[158,1,158,3],[158,5,158,7],[158,8,158,10],[165,1,165,3],[132,2,132,3],[134,2,134,3],[149,4,149,10],[150,4,150,10],[155,1,155,3],[155,5,155,7],[155,8,155,10],[104,2,104,3],[104,9,144,10],[127,2,127,3],[128,2,128,3],[129,2,129,3],[130,2,130,3],[131,2,131,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[124,2,124,3],[133,2,133,3],[97,1,97,3],[97,4,97,5],[97,7,97,8],[97,9,97,10],[98,1,98,3],[98,4,98,5],[98,7,98,8],[98,9,98,10],[95,1,95,3],[95,4,95,5],[95,7,95,8],[95,9,95,10],[96,1,96,3],[96,4,96,5],[96,7,96,8],[96,9,96,10],[93,1,93,3],[93,4,93,5],[93,7,93,8],[93,9,93,10],[94,1,94,3],[94,4,94,5],[94,7,94,8],[94,9,94,10],[91,1,91,3],[91,4,91,5],[91,7,91,8],[91,9,91,10],[92,1,92,3],[92,4,92,5],[92,7,92,8],[92,9,92,10],[89,1,89,3],[89,4,89,5],[89,7,89,8],[89,9,89,10],[90,1,90,3],[90,4,90,5],[90,7,90,8],[90,9,90,10],[87,1,87,3],[87,4,87,5],[87,7,87,8],[87,9,87,10],[88,1,88,3],[88,4,88,5],[88,7,88,8],[88,9,88,10],[86,4,86,5],[86,7,86,8],[86,9,86,10],[83,1,83,3],[83,4,83,5],[83,7,83,8],[83,9,83,10],[84,1,84,3],[84,4,84,5],[84,7,84,8],[84,9,84,10],[79,20,134,20],[80,1,80,3],[80,4,80,5],[80,7,80,8],[80,9,80,10],[81,1,81,3],[81,4,81,5],[81,7,81,8],[81,9,81,10],[81,19,98,19],[79,1,79,3],[79,4,79,5],[79,7,79,8],[79,9,79,10],[79,19,80,19],[82,1,82,3],[82,4,82,5],[82,7,82,8],[82,9,82,10],[85,1,85,3],[85,4,85,5],[85,7,85,8],[85,9,85,10],[86,1,86,3],[69,1,69,3],[69,5,69,8],[73,4,73,10],[78,4,78,5],[78,7,78,8],[78,9,78,10],[64,5,64,8],[65,1,65,3],[65,5,65,8],[66,1,66,3],[66,5,66,8],[67,1,67,3],[67,5,67,8],[60,5,60,8],[61,1,61,3],[61,5,61,8],[62,1,62,3],[62,5,62,8],[63,1,63,3],[63,5,63,8],[64,1,64,3],[68,1,68,3],[68,5,68,8],[42,2,42,3],[43,2,43,3],[45,2,45,3],[44,2,44,3],[46,2,46,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[103,1,103,3],[103,9,103,10],[0,9,0,10],[6,4,6,10],[4,4,4,10],[3,4,3,10],[7,5,7,10],[25,2,25,3],[26,2,26,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[11,4,11,10],[16,1,16,3],[17,2,17,3],[17,8,55,10],[18,2,18,3],[19,2,19,3],[36,2,36,3],[47,2,47,3],[40,2,40,3],[41,2,41,3]]}
[null,{"$f":"IF(E3=\"\",\"Abrechnungsprüfung...\",\"Abrechnungsprüfung Anbieter \"&HT!B1&\" (\"&K3&\")\")","v":"Abrechnungsprüfung..."},null,null,null,null,null,null,null,{"$f":"IF(B274=\"X\",\"Status: abgeschlossen\",\"Status: offen\")","v":"Status: offen"},null,"ausblenden",null,"ausblenden","ausblenden","ausblenden","ausblenden","ausblenden","ausblenden",null,"Anleitung:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- Farben:"]
[null,"Serie",null,null,{"$f":"IF(E6=\"\",\"\",CONCATENATE(HT!B1-2000,\"-\",MID(E6,4,1)))","v":""},null,null,null,null,null,{"$f":"IF(MID(E6,4,1)=\"3\",\"IFK\",IF(MID(E6,4,1)=\"4\",\"IP\",IF(MID(E6,4,1)=\"5\",\"RK\",\"?\")))","v":"?"},"Beitrag JI",null,null,null,null,null,null,null,null,"grau = nicht ändern"]
[null,"Anbieter",null,null,{"$f":"IF(E6=\"\",\"\",Start!C28)","v":""},null,null,null,null,null,null,"Beitrag JI2",null,null,null,null,null,null,null,null,"rosa = Hinweis, wenn Zusatzangabe fehlt"]
[null,"Angebotsname",null,null,{"$f":"IF(E6=\"\",\"\",Start!C12)","v":""},null,null,null,null,null,null,"Auszahlung",null,null,null,null,null,null,null,null,"weiss = muss ausgefüllt werden"]
[null,"LV-Nummer",null,null,{"$f":"IF(Start!H8=\"(bitte auswählen)\",\"\",Start!H8)","v":""}]
[null,"Förderbereich",null,null,{"$f":"IF(E6=\"\",\"\",LEFT(Start!C11,3))","v":""}]
[null,"Leisungsziel",null,null,{"$f":"IF(E6=\"\",\"\",Start!H11)","v":""},{"$f":"IF(E6=\"\",\"\",VLOOKUP(E8,HT!W18:Y78,3,))","v":""}]
[]
[]
[null,"1.   Abrechnungsprüfung"]
[null,null,"  Durchgeführt durch:",null,{"$f":"IF($E$6=\"\",\"\",Start!C23)","v":""}]
[]
[]
[null,"1.1.  Übersicht der vereinbarten Beiträge gemäss LV    (*) Falls Angaben nicht korrekt, Angaben in grünen Spalten auf dem Tabellenblatt L korrigieren",null,null,null,null,null,null,null,null,null,"Zähler"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(B18:B48,\"-\")+18","v":18}]
[null,"Leistung",null,null,"variabel/fix\n(*)","Menge\n(*)","Kosten pro Leistung","Kostendach\n(*)","Bemerkung zum Leistungskatalog",null,null,{"$f":"17+COUNTA(C18:D48)","v":48}]
[null,{"$f":"IF(C18=\"\",\"\",\"-\")","v":""},{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C21=\"\"),\"\",'L Leistungen und Kosten'!C21)","v":""},null,{"$f":"IF(F18=0,\"-\",IF(F18=1,\"fix\",\"variabel\"))","v":"-"},{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H21=\"\"),0,'L Leistungen und Kosten'!I21)","v":0},{"$f":"IF(F18=0,0,H18/F18)","v":0},{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R21=\"\"),0,'L Leistungen und Kosten'!T21)","v":0},null,null,null,null,{"$f":"IF(C18=\"\",\"\",C18)","v":""},null,null,null,null,null,null,null,"Angaben zum Leistungskatalog mit LV vergleichen"]
[null,{"$f":"IF(C19=\"\",\"\",\"-\")","v":""},{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C22=\"\"),\"\",'L Leistungen und Kosten'!C22)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H22=\"\"),0,'L Leistungen und Kosten'!I22)","v":0},{"$f":"IF(F19=0,0,H19/F19)","v":0},{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R22=\"\"),0,'L Leistungen und Kosten'!T22)","v":0},null,null,null,null,"",null,null,null,null,null,null,null,"inkl. Angaben über Menge und Kostendächer"]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C23=\"\"),\"\",'L Leistungen und Kosten'!C23)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H23=\"\"),0,'L Leistungen und Kosten'!I23)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R23=\"\"),0,'L Leistungen und Kosten'!T23)","v":0},null,null,null,null,"",null,null,null,null,null,null,null,"Bei LV's, bei denen nur Gesamtkostendach (kein Kostendach pro Leistung) vereinbart wurde: Menge = leer"]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C24=\"\"),\"\",'L Leistungen und Kosten'!C24)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H24=\"\"),0,'L Leistungen und Kosten'!I24)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R24=\"\"),0,'L Leistungen und Kosten'!T24)","v":0}]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C25=\"\"),\"\",'L Leistungen und Kosten'!C25)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H25=\"\"),0,'L Leistungen und Kosten'!I25)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R25=\"\"),0,'L Leistungen und Kosten'!T25)","v":0}]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C26=\"\"),\"\",'L Leistungen und Kosten'!C26)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H26=\"\"),0,'L Leistungen und Kosten'!I26)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R26=\"\"),0,'L Leistungen und Kosten'!T26)","v":0}]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C27=\"\"),\"\",'L Leistungen und Kosten'!C27)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H27=\"\"),0,'L Leistungen und Kosten'!I27)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R27=\"\"),0,'L Leistungen und Kosten'!T27)","v":0}]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C28=\"\"),\"\",'L Leistungen und Kosten'!C28)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H28=\"\"),0,'L Leistungen und Kosten'!I28)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R28=\"\"),0,'L Leistungen und Kosten'!T28)","v":0}]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C29=\"\"),\"\",'L Leistungen und Kosten'!C29)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H29=\"\"),0,'L Leistungen und Kosten'!I29)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R29=\"\"),0,'L Leistungen und Kosten'!T29)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C30=\"\"),\"\",'L Leistungen und Kosten'!C30)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H30=\"\"),0,'L Leistungen und Kosten'!I30)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R30=\"\"),0,'L Leistungen und Kosten'!T30)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C31=\"\"),\"\",'L Leistungen und Kosten'!C31)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H31=\"\"),0,'L Leistungen und Kosten'!I31)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R31=\"\"),0,'L Leistungen und Kosten'!T31)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C32=\"\"),\"\",'L Leistungen und Kosten'!C32)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H32=\"\"),0,'L Leistungen und Kosten'!I32)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R32=\"\"),0,'L Leistungen und Kosten'!T32)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C33=\"\"),\"\",'L Leistungen und Kosten'!C33)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H33=\"\"),0,'L Leistungen und Kosten'!I33)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R33=\"\"),0,'L Leistungen und Kosten'!T33)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C34=\"\"),\"\",'L Leistungen und Kosten'!C34)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H34=\"\"),0,'L Leistungen und Kosten'!I34)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R34=\"\"),0,'L Leistungen und Kosten'!T34)","v":0},null,null,null,null,{"$f":"IF(C31=\"\",\"\",C31)","v":""}]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C35=\"\"),\"\",'L Leistungen und Kosten'!C35)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H35=\"\"),0,'L Leistungen und Kosten'!I35)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R35=\"\"),0,'L Leistungen und Kosten'!T35)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C36=\"\"),\"\",'L Leistungen und Kosten'!C36)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H36=\"\"),0,'L Leistungen und Kosten'!I36)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R36=\"\"),0,'L Leistungen und Kosten'!T36)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C37=\"\"),\"\",'L Leistungen und Kosten'!C37)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H37=\"\"),0,'L Leistungen und Kosten'!I37)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R37=\"\"),0,'L Leistungen und Kosten'!T37)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C38=\"\"),\"\",'L Leistungen und Kosten'!C38)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H38=\"\"),0,'L Leistungen und Kosten'!I38)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R38=\"\"),0,'L Leistungen und Kosten'!T38)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C39=\"\"),\"\",'L Leistungen und Kosten'!C39)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H39=\"\"),0,'L Leistungen und Kosten'!I39)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R39=\"\"),0,'L Leistungen und Kosten'!T39)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C40=\"\"),\"\",'L Leistungen und Kosten'!C40)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H40=\"\"),0,'L Leistungen und Kosten'!I40)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R40=\"\"),0,'L Leistungen und Kosten'!T40)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C41=\"\"),\"\",'L Leistungen und Kosten'!C41)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H41=\"\"),0,'L Leistungen und Kosten'!I41)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R41=\"\"),0,'L Leistungen und Kosten'!T41)","v":0},null,null,null,null,{"$f":"IF(C38=\"\",\"\",C38)","v":""}]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C42=\"\"),\"\",'L Leistungen und Kosten'!C42)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H42=\"\"),0,'L Leistungen und Kosten'!I42)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R42=\"\"),0,'L Leistungen und Kosten'!T42)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C43=\"\"),\"\",'L Leistungen und Kosten'!C43)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H43=\"\"),0,'L Leistungen und Kosten'!I43)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R43=\"\"),0,'L Leistungen und Kosten'!T43)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C44=\"\"),\"\",'L Leistungen und Kosten'!C44)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H44=\"\"),0,'L Leistungen und Kosten'!I44)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R44=\"\"),0,'L Leistungen und Kosten'!T44)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C45=\"\"),\"\",'L Leistungen und Kosten'!C45)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H45=\"\"),0,'L Leistungen und Kosten'!I45)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R45=\"\"),0,'L Leistungen und Kosten'!T45)","v":0},null,null,null,null,{"$f":"IF(C42=\"\",\"\",C42)","v":""}]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C46=\"\"),\"\",'L Leistungen und Kosten'!C46)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H46=\"\"),0,'L Leistungen und Kosten'!I46)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R46=\"\"),0,'L Leistungen und Kosten'!T46)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C47=\"\"),\"\",'L Leistungen und Kosten'!C47)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H47=\"\"),0,'L Leistungen und Kosten'!I47)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R47=\"\"),0,'L Leistungen und Kosten'!T47)","v":0},null,null,null,null,{"$f":"IF(C44=\"\",\"\",C44)","v":""}]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C48=\"\"),\"\",'L Leistungen und Kosten'!C48)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H48=\"\"),0,'L Leistungen und Kosten'!I48)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R48=\"\"),0,'L Leistungen und Kosten'!T48)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C49=\"\"),\"\",'L Leistungen und Kosten'!C49)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H49=\"\"),0,'L Leistungen und Kosten'!I49)","v":0},{"$f":"IF(F46=0,0,H46/F46)","v":0},{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R49=\"\"),0,'L Leistungen und Kosten'!T49)","v":0},null,null,null,null,{"$f":"IF(C46=\"\",\"\",C46)","v":""}]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C50=\"\"),\"\",'L Leistungen und Kosten'!C50)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H50=\"\"),0,'L Leistungen und Kosten'!I50)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R50=\"\"),0,'L Leistungen und Kosten'!T50)","v":0},null,null,null,null,""]
[null,"",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!C51=\"\"),\"\",'L Leistungen und Kosten'!C51)","v":""},null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!H51=\"\"),0,'L Leistungen und Kosten'!I51)","v":0},0,{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!R51=\"\"),0,'L Leistungen und Kosten'!T51)","v":0},null,null,null,null,""]
[null,"Summe Beitrag JI",null,null,null,null,null,{"$f":"SUM(H18:H48)","v":0}]
[null,"Weitere Beiträge",null,null,null,null,null,{"$f":"SUM('L Leistungen und Kosten'!T60:T65)","v":0}]
[null,"Gesamtaufwände",null,null,null,null,null,{"$f":"'L Leistungen und Kosten'!T57","v":0}]
[null,"Gewinn",null,null,null,null,null,{"$f":"IF('L Leistungen und Kosten'!T67>0,'L Leistungen und Kosten'!T67,0)","v":0},null,null,null,"Gesamtko.",{"$f":"'L Leistungen und Kosten'!T57","v":0}]
[null,"Anteiliger Abzug",null,null,null,null,null,{"$f":"-(ROUND(H52*M53/5,2)*5)","v":0},null,null,null,"Anteil FI",{"$f":"IFERROR('L Leistungen und Kosten'!T59/SUM('L Leistungen und Kosten'!T59:T65),0)","v":0}]
[null,"Summe",null,null,null,null,{"$f":"IF(H49<>H56,\"Bitte Mengen und Kostendächer prüfen!   \",\"\")","v":""},{"$f":"SUM(H49:H50)","v":0}]
[null,"geplanter jährlicher Beitrag der JI gem. LV",null,null,null,null,null,{"$f":"IF(M3=\"\",0,M3)","v":0}]
[null,"jährlicher Beitrag der JI gem. GK-Tool (zugesprochener Betrag)",null,null,null,null,null,{"$f":"IF(M4=\"\",0,M4)","v":0}]
[]
[]
[null,"1.2 Formale Prüfung"]
[]
[null,"Dokumente / Beilagen",null,null,"vollständig","Bemerkung / weiteres Vorgehen",null,null,null,"Anfrage am","Abgabetermin"]
[null,"Reporting inkl. Formulare Leistung (L) und Bericht (B) ",null,null,null,{"$f":"IF(E62=\"nein\",\"bitte ausfüllen\",\"\")","v":""},null,null,null,{"$f":"IF(E62=\"nein\",\"tt.mm.jjjj\",\"\")","v":""},{"$f":"IF(E62=\"nein\",\"tt.mm.jjjj\",\"\")","v":""},null,{"$f":"IF(B62=\"\",\"\",B62)","v":"Reporting inkl. Formulare Leistung (L) und Bericht (B) "},null,null,null,{"$f":"IF(F62=\"\",\"\",F62)","v":""}]
[null,"Teilnehmerliste",null,null,null,{"$f":"IF(E63=\"nein\",\"bitte ausfüllen\",\"\")","v":""},null,null,null,"","",null,"Teilnehmerliste",null,null,null,""]
[null,"Erfolgsrechnung (ab Fr. 50 000 bei nicht-submittierten Angeboten) bzw. \nErklärung Leistungserbringer (bei submittierten Angeboten)",null,null,null,{"$f":"IF(E64=\"nein\",\"bitte ausfüllen\",\"\")","v":""},null,null,null,"","",null,"Erfolgsrechnung (ab Fr. 50 000 bei nicht-submittierten Angeboten) bzw. \nErklärung Leistungserbringer (bei submittierten Angeboten)",null,null,null,""]
[null,"Schlussbericht",null,null,null,"",null,null,null,"","",null,"Schlussbericht",null,null,null,""]
[null,null,null,null,null,"",null,null,null,"","",null,"",null,null,null,""]
[null,null,null,null,null,"",null,null,null,"","",null,"",null,null,null,""]
[null,null,null,null,{"$f":"IF(B68<>\"\",\"nein\",\"\")","v":""},"",null,null,null,"","",null,"",null,null,null,""]
[null,null,null,null,"","",null,null,null,"","",null,"",null,null,null,""]
[null,null,null,null,"","",null,null,null,"","",null,"",null,null,null,""]
[]
[null,{"$f":"IF(COUNTIFS(E62:E70,\"nein\")>=1,\"\",IF(COUNTIFS(E62:E70,\"ja\")+COUNTIFS(E62:E70,\"nicht relevant\")>=4,\"X\",\"\"))","v":""},null,"Alle relevanten Dokumente sind vorhanden.",null,null,null,null,null,"Datum:"]
[]
[null,"Bemerkung:"]
[]
[]
[null,"1.3 Inhaltliche Prüfung",null,null,{"$f":"IF($K$6=\"J\",\"Die LV ist ein submittiertes Angebot. Bitte die relevanten Prüfkriterien in den Zeilen 52-69 erfassen.\",\"\")","v":""}]
[]
[null,"Prüfkriterium",null,null,"Prüfvorgehen (Dokumente, Rechenwege etc.)",null,"Prüfergebnis","Bemerkungen",null,"Konsequenz"]
[null,"Überprüfung, ob die Leistungen gemäss Leistungskatalog Ziff. 3 LV erbracht worden  und nachvollziehbar sind (1)",null,null,null,null,null,{"$f":"IF($G80=\"nicht ok\", \"bitte ausfüllen\",\"\")","v":""},null,{"$f":"IF($G80=\"nicht ok\", \"bitte ausfüllen\",\"\")","v":""},null,null,{"$f":"IF(B80=\"\",\"\",B80)","v":"Überprüfung, ob die Leistungen gemäss Leistungskatalog Ziff. 3 LV erbracht worden  und nachvollziehbar sind (1)"},{"$f":"IF(E80=\"\",\"\",E80)","v":""},null,{"$f":"IF(H80=\"\",\"\",H80)","v":""},null,{"$f":"IF(J80=\"\",\"\",J80)","v":""},null,null,"\n"]
[null,"Überprüfung, ob  die Leistungserbringerin für die unter Ziff . 3 LV vereinbarten Leistungen geldwerte Vorteile von Dritten über das Gesamtbudget hinaus erlangt (falls diese Regelung in LV vorgesehen ist (Ziff. 3.1)) (2)",null,null,null,null,null,{"$f":"IF($G81=\"nicht ok\", \"bitte ausfüllen\",\"\")","v":""},null,{"$f":"IF($G81=\"nicht ok\", \"bitte ausfüllen\",\"\")","v":""},null,null,"Überprüfung, ob  die Leistungserbringerin für die unter Ziff . 3 LV vereinbarten Leistungen geldwerte Vorteile von Dritten über das Gesamtbudget hinaus erlangt (falls diese Regelung in LV vorgesehen ist (Ziff. 3.1)) (2)","",null,"",null,{"$f":"IF(J81=\"\",\"\",J81)","v":""}]
[null,null,null,null,{"$f":"IF(B82=\"keine weiteren Prüfkriterien erforderlich\",\"\",IF(B82<>\"\",\"bitte ausfüllen\",\"\"))","v":""},null,null,{"$f":"IF($G82=\"nicht ok\", \"bitte ausfüllen\",\"\")","v":""},null,{"$f":"IF($G82=\"nicht ok\", \"bitte ausfüllen\",\"\")","v":""},null,null,"","",null,"",null,""]
[null,null,null,null,{"$f":"IF(B83<>\"\",\"bitte ausfüllen\",\"\")","v":""},null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[null,null,null,null,"",null,null,"",null,"",null,null,"","",null,"",null,""]
[]
[]
[null,"1.4 Übersicht der effektiv erbrachten Leistungen    (*) Falls Angaben nicht korrekt, Angaben in grünen Spalten auf dem Tabellenblatt L korrigieren",null,null,null,null,null,null,null,null,null,"Zähler"]
[null,null,null,null," Kostendach ist bindend, darf nicht überschritten werden / Menge ist nur dann bindend, wenn \"fix\" ausgewählt",null,null,null,null,null,null,{"$f":"COUNTIFS(B105:B135,\"-\")+105","v":105}]
[null,"Leistung",null,null,"variabel / fix","Menge\n(effektiv)\n(*)","Menge\n(anrechenbar)","Kosten \npro Leistung\n(*)","Kosten\n(anrechenbar)\n(*)","Bemerkung zum Leistungskatalog",null,{"$f":"104+COUNTA(C105:C135)","v":135},null,"Menge anrechenbar \"variabel\"","Menge anrechenbar \"fix\""]
[null,{"$f":"IF(C105=\"\",\"\",\"-\")","v":""},{"$f":"IF(C18=\"\",\"\",C18)","v":""},null,{"$f":"IF(E18=\"\",\"\",E18)","v":"-"},{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J21=\"\"),0,'L Leistungen und Kosten'!K21)","v":0},{"$f":"IF(E105=\"variabel\",N105,O105)","v":0},{"$f":"IF(OR($E$6=\"\",C105=\"\"),0,'L Leistungen und Kosten'!P21)","v":0},{"$f":"IF(F105=\"\",H18,IF(E105=\"fix\",IF(G105*H105>H18,H18,G105*H105),IF('L Leistungen und Kosten'!W21>AP!H18,AP!H18,'L Leistungen und Kosten'!W21)))","v":0},null,null,{"$f":"F105*H105","v":0},{"$f":"IF(C105=\"\",\"\",C105)","v":""},{"$f":"IF(F105*H105>H18,H18/H105,F105)","v":0},{"$f":"IF(IF(F105*H105>H18,H18/H105,F105)>F18,F18,IF(F105*H105>H18,H18/H105,F105))","v":0}]
[null,{"$f":"IF(C106=\"\",\"\",\"-\")","v":""},"",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J22=\"\"),0,'L Leistungen und Kosten'!K22)","v":0},0,{"$f":"IF(OR($E$6=\"\",C106=\"\"),0,'L Leistungen und Kosten'!P22)","v":0},{"$f":"IF(F106=\"\",H19,IF(E106=\"fix\",IF(G106*H106>H19,H19,G106*H106),IF('L Leistungen und Kosten'!W22>AP!H19,AP!H19,'L Leistungen und Kosten'!W22)))","v":0},null,null,{"$f":"F106*H106","v":0},{"$f":"IF(C106=\"\",\"\",C106)","v":""},{"$f":"IF(F106*H106>H19,H19/H106,F106)","v":0},{"$f":"IF(IF(F106*H106>H19,H19/H106,F106)>F19,F19,IF(F106*H106>H19,H19/H106,F106))","v":0}]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J23=\"\"),0,'L Leistungen und Kosten'!K23)","v":0},0,{"$f":"IF(OR($E$6=\"\",C107=\"\"),0,'L Leistungen und Kosten'!P23)","v":0},{"$f":"IF(F107=\"\",H20,IF(E107=\"fix\",IF(G107*H107>H20,H20,G107*H107),IF('L Leistungen und Kosten'!W23>AP!H20,AP!H20,'L Leistungen und Kosten'!W23)))","v":0},null,null,{"$f":"F107*H107","v":0},"",0,0]
[null,{"$f":"IF(C108=\"\",\"\",\"-\")","v":""},"",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J24=\"\"),0,'L Leistungen und Kosten'!K24)","v":0},0,{"$f":"IF(OR($E$6=\"\",C108=\"\"),0,'L Leistungen und Kosten'!P24)","v":0},{"$f":"IF(F108=\"\",H21,IF(E108=\"fix\",IF(G108*H108>H21,H21,G108*H108),IF('L Leistungen und Kosten'!W24>AP!H21,AP!H21,'L Leistungen und Kosten'!W24)))","v":0},null,null,{"$f":"F108*H108","v":0},{"$f":"IF(C108=\"\",\"\",C108)","v":""},0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J25=\"\"),0,'L Leistungen und Kosten'!K25)","v":0},0,{"$f":"IF(OR($E$6=\"\",C109=\"\"),0,'L Leistungen und Kosten'!P25)","v":0},{"$f":"IF(F109=\"\",H22,IF(E109=\"fix\",IF(G109*H109>H22,H22,G109*H109),IF('L Leistungen und Kosten'!W25>AP!H22,AP!H22,'L Leistungen und Kosten'!W25)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J26=\"\"),0,'L Leistungen und Kosten'!K26)","v":0},0,{"$f":"IF(OR($E$6=\"\",C110=\"\"),0,'L Leistungen und Kosten'!P26)","v":0},{"$f":"IF(F110=\"\",H23,IF(E110=\"fix\",IF(G110*H110>H23,H23,G110*H110),IF('L Leistungen und Kosten'!W26>AP!H23,AP!H23,'L Leistungen und Kosten'!W26)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J27=\"\"),0,'L Leistungen und Kosten'!K27)","v":0},0,{"$f":"IF(OR($E$6=\"\",C111=\"\"),0,'L Leistungen und Kosten'!P27)","v":0},{"$f":"IF(F111=\"\",H24,IF(E111=\"fix\",IF(G111*H111>H24,H24,G111*H111),IF('L Leistungen und Kosten'!W27>AP!H24,AP!H24,'L Leistungen und Kosten'!W27)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J28=\"\"),0,'L Leistungen und Kosten'!K28)","v":0},0,{"$f":"IF(OR($E$6=\"\",C112=\"\"),0,'L Leistungen und Kosten'!P28)","v":0},{"$f":"IF(F112=\"\",H25,IF(E112=\"fix\",IF(G112*H112>H25,H25,G112*H112),IF('L Leistungen und Kosten'!W28>AP!H25,AP!H25,'L Leistungen und Kosten'!W28)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J29=\"\"),0,'L Leistungen und Kosten'!K29)","v":0},0,{"$f":"IF(OR($E$6=\"\",C113=\"\"),0,'L Leistungen und Kosten'!P29)","v":0},{"$f":"IF(F113=\"\",H26,IF(E113=\"fix\",IF(G113*H113>H26,H26,G113*H113),IF('L Leistungen und Kosten'!W29>AP!H26,AP!H26,'L Leistungen und Kosten'!W29)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J30=\"\"),0,'L Leistungen und Kosten'!K30)","v":0},0,{"$f":"IF(OR($E$6=\"\",C114=\"\"),0,'L Leistungen und Kosten'!P30)","v":0},{"$f":"IF(F114=\"\",H27,IF(E114=\"fix\",IF(G114*H114>H27,H27,G114*H114),IF('L Leistungen und Kosten'!W30>AP!H27,AP!H27,'L Leistungen und Kosten'!W30)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J31=\"\"),0,'L Leistungen und Kosten'!K31)","v":0},0,{"$f":"IF(OR($E$6=\"\",C115=\"\"),0,'L Leistungen und Kosten'!P31)","v":0},{"$f":"IF(F115=\"\",H28,IF(E115=\"fix\",IF(G115*H115>H28,H28,G115*H115),IF('L Leistungen und Kosten'!W31>AP!H28,AP!H28,'L Leistungen und Kosten'!W31)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J32=\"\"),0,'L Leistungen und Kosten'!K32)","v":0},0,{"$f":"IF(OR($E$6=\"\",C116=\"\"),0,'L Leistungen und Kosten'!P32)","v":0},{"$f":"IF(F116=\"\",H29,IF(E116=\"fix\",IF(G116*H116>H29,H29,G116*H116),IF('L Leistungen und Kosten'!W32>AP!H29,AP!H29,'L Leistungen und Kosten'!W32)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J33=\"\"),0,'L Leistungen und Kosten'!K33)","v":0},0,{"$f":"IF(OR($E$6=\"\",C117=\"\"),0,'L Leistungen und Kosten'!P33)","v":0},{"$f":"IF(F117=\"\",H30,IF(E117=\"fix\",IF(G117*H117>H30,H30,G117*H117),IF('L Leistungen und Kosten'!W33>AP!H30,AP!H30,'L Leistungen und Kosten'!W33)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J34=\"\"),0,'L Leistungen und Kosten'!K34)","v":0},0,{"$f":"IF(OR($E$6=\"\",C118=\"\"),0,'L Leistungen und Kosten'!P34)","v":0},{"$f":"IF(F118=\"\",H31,IF(E118=\"fix\",IF(G118*H118>H31,H31,G118*H118),IF('L Leistungen und Kosten'!W34>AP!H31,AP!H31,'L Leistungen und Kosten'!W34)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J35=\"\"),0,'L Leistungen und Kosten'!K35)","v":0},0,{"$f":"IF(OR($E$6=\"\",C119=\"\"),0,'L Leistungen und Kosten'!P35)","v":0},{"$f":"IF(F119=\"\",H32,IF(E119=\"fix\",IF(G119*H119>H32,H32,G119*H119),IF('L Leistungen und Kosten'!W35>AP!H32,AP!H32,'L Leistungen und Kosten'!W35)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J36=\"\"),0,'L Leistungen und Kosten'!K36)","v":0},0,{"$f":"IF(OR($E$6=\"\",C120=\"\"),0,'L Leistungen und Kosten'!P36)","v":0},{"$f":"IF(F120=\"\",H33,IF(E120=\"fix\",IF(G120*H120>H33,H33,G120*H120),IF('L Leistungen und Kosten'!W36>AP!H33,AP!H33,'L Leistungen und Kosten'!W36)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J37=\"\"),0,'L Leistungen und Kosten'!K37)","v":0},0,{"$f":"IF(OR($E$6=\"\",C121=\"\"),0,'L Leistungen und Kosten'!P37)","v":0},{"$f":"IF(F121=\"\",H34,IF(E121=\"fix\",IF(G121*H121>H34,H34,G121*H121),IF('L Leistungen und Kosten'!W37>AP!H34,AP!H34,'L Leistungen und Kosten'!W37)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J38=\"\"),0,'L Leistungen und Kosten'!K38)","v":0},0,{"$f":"IF(OR($E$6=\"\",C122=\"\"),0,'L Leistungen und Kosten'!P38)","v":0},{"$f":"IF(F122=\"\",H35,IF(E122=\"fix\",IF(G122*H122>H35,H35,G122*H122),IF('L Leistungen und Kosten'!W38>AP!H35,AP!H35,'L Leistungen und Kosten'!W38)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J39=\"\"),0,'L Leistungen und Kosten'!K39)","v":0},0,{"$f":"IF(OR($E$6=\"\",C123=\"\"),0,'L Leistungen und Kosten'!P39)","v":0},{"$f":"IF(F123=\"\",H36,IF(E123=\"fix\",IF(G123*H123>H36,H36,G123*H123),IF('L Leistungen und Kosten'!W39>AP!H36,AP!H36,'L Leistungen und Kosten'!W39)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J40=\"\"),0,'L Leistungen und Kosten'!K40)","v":0},0,{"$f":"IF(OR($E$6=\"\",C124=\"\"),0,'L Leistungen und Kosten'!P40)","v":0},{"$f":"IF(F124=\"\",H37,IF(E124=\"fix\",IF(G124*H124>H37,H37,G124*H124),IF('L Leistungen und Kosten'!W40>AP!H37,AP!H37,'L Leistungen und Kosten'!W40)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J41=\"\"),0,'L Leistungen und Kosten'!K41)","v":0},0,{"$f":"IF(OR($E$6=\"\",C125=\"\"),0,'L Leistungen und Kosten'!P41)","v":0},{"$f":"IF(F125=\"\",H38,IF(E125=\"fix\",IF(G125*H125>H38,H38,G125*H125),IF('L Leistungen und Kosten'!W41>AP!H38,AP!H38,'L Leistungen und Kosten'!W41)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J42=\"\"),0,'L Leistungen und Kosten'!K42)","v":0},0,{"$f":"IF(OR($E$6=\"\",C126=\"\"),0,'L Leistungen und Kosten'!P42)","v":0},{"$f":"IF(F126=\"\",H39,IF(E126=\"fix\",IF(G126*H126>H39,H39,G126*H126),IF('L Leistungen und Kosten'!W42>AP!H39,AP!H39,'L Leistungen und Kosten'!W42)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J43=\"\"),0,'L Leistungen und Kosten'!K43)","v":0},0,{"$f":"IF(OR($E$6=\"\",C127=\"\"),0,'L Leistungen und Kosten'!P43)","v":0},{"$f":"IF(F127=\"\",H40,IF(E127=\"fix\",IF(G127*H127>H40,H40,G127*H127),IF('L Leistungen und Kosten'!W43>AP!H40,AP!H40,'L Leistungen und Kosten'!W43)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J44=\"\"),0,'L Leistungen und Kosten'!K44)","v":0},0,{"$f":"IF(OR($E$6=\"\",C128=\"\"),0,'L Leistungen und Kosten'!P44)","v":0},{"$f":"IF(F128=\"\",H41,IF(E128=\"fix\",IF(G128*H128>H41,H41,G128*H128),IF('L Leistungen und Kosten'!W44>AP!H41,AP!H41,'L Leistungen und Kosten'!W44)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J45=\"\"),0,'L Leistungen und Kosten'!K45)","v":0},0,{"$f":"IF(OR($E$6=\"\",C129=\"\"),0,'L Leistungen und Kosten'!P45)","v":0},{"$f":"IF(F129=\"\",H42,IF(E129=\"fix\",IF(G129*H129>H42,H42,G129*H129),IF('L Leistungen und Kosten'!W45>AP!H42,AP!H42,'L Leistungen und Kosten'!W45)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J46=\"\"),0,'L Leistungen und Kosten'!K46)","v":0},0,{"$f":"IF(OR($E$6=\"\",C130=\"\"),0,'L Leistungen und Kosten'!P46)","v":0},{"$f":"IF(F130=\"\",H43,IF(E130=\"fix\",IF(G130*H130>H43,H43,G130*H130),IF('L Leistungen und Kosten'!W46>AP!H43,AP!H43,'L Leistungen und Kosten'!W46)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J47=\"\"),0,'L Leistungen und Kosten'!K47)","v":0},0,{"$f":"IF(OR($E$6=\"\",C131=\"\"),0,'L Leistungen und Kosten'!P47)","v":0},{"$f":"IF(F131=\"\",H44,IF(E131=\"fix\",IF(G131*H131>H44,H44,G131*H131),IF('L Leistungen und Kosten'!W47>AP!H44,AP!H44,'L Leistungen und Kosten'!W47)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J48=\"\"),0,'L Leistungen und Kosten'!K48)","v":0},0,{"$f":"IF(OR($E$6=\"\",C132=\"\"),0,'L Leistungen und Kosten'!P48)","v":0},{"$f":"IF(F132=\"\",H45,IF(E132=\"fix\",IF(G132*H132>H45,H45,G132*H132),IF('L Leistungen und Kosten'!W48>AP!H45,AP!H45,'L Leistungen und Kosten'!W48)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J49=\"\"),0,'L Leistungen und Kosten'!K49)","v":0},0,{"$f":"IF(OR($E$6=\"\",C133=\"\"),0,'L Leistungen und Kosten'!P49)","v":0},{"$f":"IF(F133=\"\",H46,IF(E133=\"fix\",IF(G133*H133>H46,H46,G133*H133),IF('L Leistungen und Kosten'!W49>AP!H46,AP!H46,'L Leistungen und Kosten'!W49)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J50=\"\"),0,'L Leistungen und Kosten'!K50)","v":0},0,{"$f":"IF(OR($E$6=\"\",C134=\"\"),0,'L Leistungen und Kosten'!P50)","v":0},{"$f":"IF(F134=\"\",H47,IF(E134=\"fix\",IF(G134*H134>H47,H47,G134*H134),IF('L Leistungen und Kosten'!W50>AP!H47,AP!H47,'L Leistungen und Kosten'!W50)))","v":0},null,null,0,"",0,0]
[null,"","",null,"-",{"$f":"IF(OR($E$6=\"\",'L Leistungen und Kosten'!J51=\"\"),0,'L Leistungen und Kosten'!K51)","v":0},0,{"$f":"IF(OR($E$6=\"\",C135=\"\"),0,'L Leistungen und Kosten'!P51)","v":0},{"$f":"IF(F135=\"\",H48,IF(E135=\"fix\",IF(G135*H135>H48,H48,G135*H135),IF('L Leistungen und Kosten'!W51>AP!H48,AP!H48,'L Leistungen und Kosten'!W51)))","v":0},null,null,0,"",0,0]
[null,"Summe Beitrag JI",null,null,null,null,null,null,{"$f":"SUM(I105:I135)","v":0}]
[null,"Weitere Beiträge",null,null,null,null,null,null,{"$f":"SUM('L Leistungen und Kosten'!W60:W65)","v":0}]
[null,"Gesamtkosten für das Angebot",null,null,null,null,null,null,{"$f":"'L Leistungen und Kosten'!W57","v":0}]
[null,"Gewinn (positiver Saldo)",null,null,null,null,null,null,{"$f":"IF('L Leistungen und Kosten'!W67>0,'L Leistungen und Kosten'!W67,0)","v":0}]
[null,"Anteiliger Abzug",null,null,null,null,null,null,{"$f":"-ROUND(I139*M140/5,2)*5","v":0},null,null,"Anteil FI",{"$f":"IFERROR('L Leistungen und Kosten'!W59/SUM('L Leistungen und Kosten'!W59:W65),0)","v":0}]
[null,"jährlicher Beitrag der JI gem. Abrechnungsprüfung",null,null,null,null,null,{"$f":"IF(I141>I142,\"Bitte anrechenbare Menge prüfen!   \",\"\")","v":""},{"$f":"SUM(I105:I135,I140)","v":0}]
[null,"geplanter jährlicher Beitrag der JI gem. LV (zugsprochener Betrag)",null,null,null,null,null,{"$f":"SUM(L105:L135)","v":0},{"$f":"IF(E5=\"\",0,H56)","v":0}]
[null,{"$f":"IF(I143<0,\"Beitragsreduktion\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(I141-I142>0,0,I141-I142)","v":0}]
[null,"bereits ausbezahlter Beitrag",null,null,null,null,null,null,{"$f":"IF(M5=\"\",0,M5)","v":0}]
[null,{"$f":"IF(I144>I141,\"Rückzahlung\",IF(I144<I141,\"2.Teilzahlung\",\"keine Rückzahlung / 2. Teilzahlung\"))","v":"keine Rückzahlung / 2. Teilzahlung"},null,null,null,null,null,null,{"$f":"-IF(I141>I142,I144-I142,I144-I141)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($E$4=\"\",I141=0),\"\",IF(I141<H56,\"Angaben im GK-Tool korrigieren!\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,"Zeitaufwand für Erstprüfung (h:mm):",null,null,null,null,null,null,null,null,null,null,"Beispiel für Eingabe des Aufwands: 1:45 -> wird angezeigt als 1.45 h"]
[]
[]
[null,"2.   Zweitprüfung",null,null,{"$f":"IF(H55>50000,\"relevant\",\"nicht relevant\")","v":"nicht relevant"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Prüfung ab Kostendach FI >= 50'000"]
[null,"      Prüfdatum","  Durchgeführt durch:"]
[]
[]
[null,"2.1 Inhaltliche Prüfung",null,null,{"$f":"IF($K$6=\"J\",\"Die LV ist ein submittiertes Angebot. Bitte die angewandten Prüfkriterien (Zeilen 97-116) prüfen.\",\"\")","v":""}]
[]
[null,"Prüfkriterium",null,null,"Prüfergebnis","Bemerkungen",null,null,"Konsequenz"]
[null,{"$f":"IF(B80=\"\",\"\",B80)","v":"Überprüfung, ob die Leistungen gemäss Leistungskatalog Ziff. 3 LV erbracht worden  und nachvollziehbar sind (1)"},null,null,null,{"$f":"IF(E157=\"nicht ok\",\"bitte ausfüllen\",\"\")","v":""},null,null,{"$f":"IF(E157=\"nicht ok\",\"bitte ausfüllen\",\"\")","v":""},null,null,null,{"$f":"IF(B157=\"\",\"\",B157)","v":"Überprüfung, ob die Leistungen gemäss Leistungskatalog Ziff. 3 LV erbracht worden  und nachvollziehbar sind (1)"},null,{"$f":"IF(F157=\"\",\"\",F157)","v":""},null,null,null,{"$f":"IF(I157=\"\",\"\",I157)","v":""},null,"wenn nicht ok, Felder Bemerkung,Konsequenz ausfüllen"]
[null,"Überprüfung, ob  die Leistungserbringerin für die unter Ziff . 3 LV vereinbarten Leistungen geldwerte Vorteile von Dritten über das Gesamtbudget hinaus erlangt (falls diese Regelung in LV vorgesehen ist (Ziff. 3.1)) (2)",null,null,null,{"$f":"IF(E158=\"nicht ok\",\"bitte ausfüllen\",\"\")","v":""},null,null,"",null,null,null,"Überprüfung, ob  die Leistungserbringerin für die unter Ziff . 3 LV vereinbarten Leistungen geldwerte Vorteile von Dritten über das Gesamtbudget hinaus erlangt (falls diese Regelung in LV vorgesehen ist (Ziff. 3.1)) (2)",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[]
[null,{"$f":"IF(E150=\"nicht relevant\",\"\",IF(COUNTIFS(E157:E176,\"nicht ok\")=0,\"X\",\"\"))","v":""},null,"Erstprüfung ist korrekt.",null,null,null,null,null,"Zeitaufwand für Zweitprüfung (h:mm):",null,null,null,null,null,null,null,null,null,null,"Beispiel für Eingabe des Aufwands: 1:45 -> wird angezeigt als 1.45 h"]
[]
[]
[null,"3.   Überarbeitung Erstprüfer:",null,null,{"$f":"IF(E150=\"nicht relevant\",\"nicht relevant\",IF(B178=\"\",\"relevant\",\"nicht relevant, da Erstprüfung korrekt ist.\"))","v":"nicht relevant"}]
[null,"      Prüfdatum","   Durchgeführt durch:",null,{"$f":"IF(OR(E181=\"nicht relevant\",B178=\"X\"),\"\",E12)","v":""}]
[]
[]
[null,"3.1 Inhaltliche Prüfung"]
[]
[null,"Prüfkriterien",null,null,"Prüfergebnis","Bemerkung",null,null,"Konsequenz"]
[null,"Überprüfung, ob die Leistungen gemäss Leistungskatalog Ziff. 3 LV erbracht worden  und nachvollziehbar sind (1)",null,null,null,{"$f":"IF(E188=\"nicht ok\",\"bitte ausfüllen\",\"\")","v":""},null,null,{"$f":"IF(E188=\"nicht ok\",\"bitte ausfüllen\",\"\")","v":""},null,null,null,{"$f":"IF(B188=\"\",\"\",B188)","v":"Überprüfung, ob die Leistungen gemäss Leistungskatalog Ziff. 3 LV erbracht worden  und nachvollziehbar sind (1)"},null,{"$f":"IF(F188=\"\",\"\",F188)","v":""},null,null,null,{"$f":"IF(I188=\"\",\"\",I188)","v":""}]
[null,"Überprüfung, ob  die Leistungserbringerin für die unter Ziff . 3 LV vereinbarten Leistungen geldwerte Vorteile von Dritten über das Gesamtbudget hinaus erlangt (falls diese Regelung in LV vorgesehen ist (Ziff. 3.1)) (2)",null,null,null,"",null,null,"",null,null,null,"Überprüfung, ob  die Leistungserbringerin für die unter Ziff . 3 LV vereinbarten Leistungen geldwerte Vorteile von Dritten über das Gesamtbudget hinaus erlangt (falls diese Regelung in LV vorgesehen ist (Ziff. 3.1)) (2)",null,"",null,null,null,""]
[null,{"$f":"IF(B159=\"\",\"\",B159)","v":""},null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,{"$f":"IF(B160=\"\",\"\",B160)","v":""},null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,""]
[]
[]
[null,"3.2. Übersicht der effektiv erbrachten Leistungen (nach allen relevanten Prüfungen)  (*) Falls Angaben nicht korrekt, Angaben direkt in Tabelle korrigieren",null,null,null,null,null,null,null,null,null,"Zähler"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(B213:B243,\"-\")+213","v":213}]
[null,"Leistung",null,null,"variabel / fix\n(*)","Menge\n(effektiv) (*)","Menge\n(anrechenbar)","Kosten \npro Leistung (*)","Kosten\n(anrechenbar)","Bemerkung zum Leistungskatalog",null,{"$f":"212+COUNTA(C213:C243)","v":243},null,"Menge anrechenbar \"variabel\"","Menge anrechenbar \"fix\""]
[null,{"$f":"IF(C213=\"\",\"\",\"-\")","v":""},{"$f":"IF(C105=\"\",\"\",C105)","v":""},null,{"$f":"IF(E105=\"\",\"\",E105)","v":"-"},{"$f":"IF(F105=\"\",\"\",IF(F105=0,0,F105))","v":0},{"$f":"IF(E213=\"variabel\",N213,O213)","v":0},{"$f":"IF(OR($E$6=\"\",C213=\"\"),0,'L Leistungen und Kosten'!P21)","v":0},{"$f":"G213*H213","v":0},null,null,null,{"$f":"IF(C213=\"\",\"\",C213)","v":""},{"$f":"IF(F213*H213>H18,H18/H213,F213)","v":0},{"$f":"IF(IF(F213*H213>H18,H18/H213,F213)>F18,F18,IF(F213*H213>H18,H18/H213,F213))","v":0}]
[null,{"$f":"IF(C214=\"\",\"\",\"-\")","v":""},"",null,"-",0,{"$f":"IF(E214=\"variabel\",N214,O214)","v":0},{"$f":"IF(OR($E$6=\"\",C214=\"\"),0,'L Leistungen und Kosten'!P22)","v":0},{"$f":"IF(F214=\"\",H19,IF(E214=\"fix\",IF(G214*H106>H19,H19,G214*H214),IF('L Leistungen und Kosten'!W22>AP!H19,AP!H19,'L Leistungen und Kosten'!W22)))","v":0},null,null,null,{"$f":"IF(C214=\"\",\"\",C214)","v":""},0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C215=\"\"),0,'L Leistungen und Kosten'!P23)","v":0},{"$f":"IF(F215=\"\",H20,IF(E215=\"fix\",IF(G215*H107>H20,H20,G215*H215),IF('L Leistungen und Kosten'!W23>AP!H20,AP!H20,'L Leistungen und Kosten'!W23)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C216=\"\"),0,'L Leistungen und Kosten'!P24)","v":0},{"$f":"IF(F216=\"\",H21,IF(E216=\"fix\",IF(G216*H108>H21,H21,G216*H216),IF('L Leistungen und Kosten'!W24>AP!H21,AP!H21,'L Leistungen und Kosten'!W24)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C217=\"\"),0,'L Leistungen und Kosten'!P25)","v":0},{"$f":"IF(F217=\"\",H22,IF(E217=\"fix\",IF(G217*H109>H22,H22,G217*H217),IF('L Leistungen und Kosten'!W25>AP!H22,AP!H22,'L Leistungen und Kosten'!W25)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C218=\"\"),0,'L Leistungen und Kosten'!P26)","v":0},{"$f":"IF(F218=\"\",H23,IF(E218=\"fix\",IF(G218*H110>H23,H23,G218*H218),IF('L Leistungen und Kosten'!W26>AP!H23,AP!H23,'L Leistungen und Kosten'!W26)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C219=\"\"),0,'L Leistungen und Kosten'!P27)","v":0},{"$f":"IF(F219=\"\",H24,IF(E219=\"fix\",IF(G219*H111>H24,H24,G219*H219),IF('L Leistungen und Kosten'!W27>AP!H24,AP!H24,'L Leistungen und Kosten'!W27)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C220=\"\"),0,'L Leistungen und Kosten'!P28)","v":0},{"$f":"IF(F220=\"\",H25,IF(E220=\"fix\",IF(G220*H112>H25,H25,G220*H220),IF('L Leistungen und Kosten'!W28>AP!H25,AP!H25,'L Leistungen und Kosten'!W28)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C221=\"\"),0,'L Leistungen und Kosten'!P29)","v":0},{"$f":"IF(F221=\"\",H26,IF(E221=\"fix\",IF(G221*H113>H26,H26,G221*H221),IF('L Leistungen und Kosten'!W29>AP!H26,AP!H26,'L Leistungen und Kosten'!W29)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C222=\"\"),0,'L Leistungen und Kosten'!P30)","v":0},{"$f":"IF(F222=\"\",H27,IF(E222=\"fix\",IF(G222*H114>H27,H27,G222*H222),IF('L Leistungen und Kosten'!W30>AP!H27,AP!H27,'L Leistungen und Kosten'!W30)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C223=\"\"),0,'L Leistungen und Kosten'!P31)","v":0},{"$f":"IF(F223=\"\",H28,IF(E223=\"fix\",IF(G223*H115>H28,H28,G223*H223),IF('L Leistungen und Kosten'!W31>AP!H28,AP!H28,'L Leistungen und Kosten'!W31)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C224=\"\"),0,'L Leistungen und Kosten'!P32)","v":0},{"$f":"IF(F224=\"\",H29,IF(E224=\"fix\",IF(G224*H116>H29,H29,G224*H224),IF('L Leistungen und Kosten'!W32>AP!H29,AP!H29,'L Leistungen und Kosten'!W32)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C225=\"\"),0,'L Leistungen und Kosten'!P33)","v":0},{"$f":"IF(F225=\"\",H30,IF(E225=\"fix\",IF(G225*H117>H30,H30,G225*H225),IF('L Leistungen und Kosten'!W33>AP!H30,AP!H30,'L Leistungen und Kosten'!W33)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C226=\"\"),0,'L Leistungen und Kosten'!P34)","v":0},{"$f":"IF(F226=\"\",H31,IF(E226=\"fix\",IF(G226*H118>H31,H31,G226*H226),IF('L Leistungen und Kosten'!W34>AP!H31,AP!H31,'L Leistungen und Kosten'!W34)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C227=\"\"),0,'L Leistungen und Kosten'!P35)","v":0},{"$f":"IF(F227=\"\",H32,IF(E227=\"fix\",IF(G227*H119>H32,H32,G227*H227),IF('L Leistungen und Kosten'!W35>AP!H32,AP!H32,'L Leistungen und Kosten'!W35)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C228=\"\"),0,'L Leistungen und Kosten'!P36)","v":0},{"$f":"IF(F228=\"\",H33,IF(E228=\"fix\",IF(G228*H120>H33,H33,G228*H228),IF('L Leistungen und Kosten'!W36>AP!H33,AP!H33,'L Leistungen und Kosten'!W36)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C229=\"\"),0,'L Leistungen und Kosten'!P37)","v":0},{"$f":"IF(F229=\"\",H34,IF(E229=\"fix\",IF(G229*H121>H34,H34,G229*H229),IF('L Leistungen und Kosten'!W37>AP!H34,AP!H34,'L Leistungen und Kosten'!W37)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C230=\"\"),0,'L Leistungen und Kosten'!P38)","v":0},{"$f":"IF(F230=\"\",H35,IF(E230=\"fix\",IF(G230*H122>H35,H35,G230*H230),IF('L Leistungen und Kosten'!W38>AP!H35,AP!H35,'L Leistungen und Kosten'!W38)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C231=\"\"),0,'L Leistungen und Kosten'!P39)","v":0},{"$f":"IF(F231=\"\",H36,IF(E231=\"fix\",IF(G231*H123>H36,H36,G231*H231),IF('L Leistungen und Kosten'!W39>AP!H36,AP!H36,'L Leistungen und Kosten'!W39)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C232=\"\"),0,'L Leistungen und Kosten'!P40)","v":0},{"$f":"IF(F232=\"\",H37,IF(E232=\"fix\",IF(G232*H124>H37,H37,G232*H232),IF('L Leistungen und Kosten'!W40>AP!H37,AP!H37,'L Leistungen und Kosten'!W40)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C233=\"\"),0,'L Leistungen und Kosten'!P41)","v":0},{"$f":"IF(F233=\"\",H38,IF(E233=\"fix\",IF(G233*H125>H38,H38,G233*H233),IF('L Leistungen und Kosten'!W41>AP!H38,AP!H38,'L Leistungen und Kosten'!W41)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C234=\"\"),0,'L Leistungen und Kosten'!P42)","v":0},{"$f":"IF(F234=\"\",H39,IF(E234=\"fix\",IF(G234*H126>H39,H39,G234*H234),IF('L Leistungen und Kosten'!W42>AP!H39,AP!H39,'L Leistungen und Kosten'!W42)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C235=\"\"),0,'L Leistungen und Kosten'!P43)","v":0},{"$f":"IF(F235=\"\",H40,IF(E235=\"fix\",IF(G235*H127>H40,H40,G235*H235),IF('L Leistungen und Kosten'!W43>AP!H40,AP!H40,'L Leistungen und Kosten'!W43)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C236=\"\"),0,'L Leistungen und Kosten'!P44)","v":0},{"$f":"IF(F236=\"\",H41,IF(E236=\"fix\",IF(G236*H128>H41,H41,G236*H236),IF('L Leistungen und Kosten'!W44>AP!H41,AP!H41,'L Leistungen und Kosten'!W44)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C237=\"\"),0,'L Leistungen und Kosten'!P45)","v":0},{"$f":"IF(F237=\"\",H42,IF(E237=\"fix\",IF(G237*H129>H42,H42,G237*H237),IF('L Leistungen und Kosten'!W45>AP!H42,AP!H42,'L Leistungen und Kosten'!W45)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C238=\"\"),0,'L Leistungen und Kosten'!P46)","v":0},{"$f":"IF(F238=\"\",H43,IF(E238=\"fix\",IF(G238*H130>H43,H43,G238*H238),IF('L Leistungen und Kosten'!W46>AP!H43,AP!H43,'L Leistungen und Kosten'!W46)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C239=\"\"),0,'L Leistungen und Kosten'!P47)","v":0},{"$f":"IF(F239=\"\",H44,IF(E239=\"fix\",IF(G239*H131>H44,H44,G239*H239),IF('L Leistungen und Kosten'!W47>AP!H44,AP!H44,'L Leistungen und Kosten'!W47)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C240=\"\"),0,'L Leistungen und Kosten'!P48)","v":0},{"$f":"IF(F240=\"\",H45,IF(E240=\"fix\",IF(G240*H132>H45,H45,G240*H240),IF('L Leistungen und Kosten'!W48>AP!H45,AP!H45,'L Leistungen und Kosten'!W48)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C241=\"\"),0,'L Leistungen und Kosten'!P49)","v":0},{"$f":"IF(F241=\"\",H46,IF(E241=\"fix\",IF(G241*H133>H46,H46,G241*H241),IF('L Leistungen und Kosten'!W49>AP!H46,AP!H46,'L Leistungen und Kosten'!W49)))","v":0},null,null,null,{"$f":"IF(C241=\"\",\"\",C241)","v":""},0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C242=\"\"),0,'L Leistungen und Kosten'!P50)","v":0},{"$f":"IF(F242=\"\",H47,IF(E242=\"fix\",IF(G242*H134>H47,H47,G242*H242),IF('L Leistungen und Kosten'!W50>AP!H47,AP!H47,'L Leistungen und Kosten'!W50)))","v":0},null,null,null,"",0,0]
[null,"","",null,"-",0,0,{"$f":"IF(OR($E$6=\"\",C243=\"\"),0,'L Leistungen und Kosten'!P51)","v":0},{"$f":"IF(F243=\"\",H48,IF(E243=\"fix\",IF(G243*H135>H48,H48,G243*H243),IF('L Leistungen und Kosten'!W51>AP!H48,AP!H48,'L Leistungen und Kosten'!W51)))","v":0},null,null,null,"",0,0]
[null,"Summe Beitrag JI",null,null,null,null,null,null,{"$f":"SUM(I213:I243)","v":0}]
[null,"Weitere Beiträge (bitte ggf. korrigieren)",null,null,null,null,null,null,{"$f":"SUM('L Leistungen und Kosten'!U60:V65)","v":0}]
[null,"Gesamtaufwände (bitte ggf. korrigieren)",null,null,null,null,null,null,{"$f":"'L Leistungen und Kosten'!W57","v":0},null,null,"Anteil FI",{"$f":"IFERROR(I244/(I244+I245),0)","v":0}]
[null,"Gewinn",null,null,null,null,null,null,{"$f":"IF((I244+I245-I246)>0,I244+I245-I246,0)","v":0}]
[null,"Anteiliger Abzug",null,null,null,null,null,null,{"$f":"-I247*M246","v":0}]
[null,"jährlicher Beitrag der JI gem. Abrechnungsprüfung",null,null,null,null,null,{"$f":"IF(I249>I250,\"Bitte anrechenbare Menge prüfen!   \",\"\")","v":""},{"$f":"I244+I248","v":0}]
[null,"geplanter jährlicher Beitrag der JI gem. LV",null,null,null,null,null,null,{"$f":"SUM(H18:H48)","v":0}]
[null,{"$f":"IF(I251<0,\"Beitragsreduktion\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(I249-I250>0,0,I249-I250)","v":0}]
[null,"bereits ausbezahlter Beitrag",null,null,null,null,null,null,{"$f":"IF(M5=\"\",0,M5)","v":0}]
[null,{"$f":"IF(I252>I249,\"Rückzahlung\",IF(I252<I249,\"2.Teilzahlung\",\"keine Rückzahlung / 2. Teilzahlung\"))","v":"keine Rückzahlung / 2. Teilzahlung"},null,null,null,null,null,null,{"$f":"-IF(I249>I250,I252-I250,I252-I249)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($E$4=\"\",I249=0),\"\",IF(I249<>H56,\"Angaben im GK-Tool korrigieren!\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,"Zeitaufwand für Überarbeitung durch Erstprüfer (h:mm):",null,null,null,null,null,null,null,null,null,null,"Beispiel für Eingabe des Aufwands: 1:45 -> wird angezeigt als 1.45 h"]
[]
[]
[null,"Prüfergebnis"]
[]
[null,"Effektive Beiträge"]
[]
[null,"Beitragskorrekturen",null,null,null,{"$f":"IF(I251<0,\"ja\",\"nein\")","v":"nein"}]
[null,"geplanter jährlicher Beitrag der JI gem. LV",null,null,null,{"$f":"IFERROR(I250,0)","v":0}]
[null,"jährlicher Beitrag der JI gem. Abrechnungsprüfung",null,null,null,{"$f":"IFERROR(IF(I249>I250,I250,I249),0)","v":0}]
[null,"ausbezahlter Beitrag (gemäss SAP)",null,null,null,{"$f":"I252","v":0}]
[null,"Höhe der Beitragskorrektur ",null,null,null,{"$f":"I251","v":0}]
[null,"Rückforderungsbetrag",null,null,null,{"$f":"IF(B253=\"Rückzahlung\",I253,0)","v":0}]
[null,"noch auszuzahlender Betrag",null,null,null,{"$f":"IF(B253=\"2.Teilzahlung\",I253,0)","v":0}]
[null,"wenn Beitragskorrektur, \nzusammenfassende Begründung: …",null,null,null,{"$f":"IF($F$262=\"ja\",\"bitte ausfüllen\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wenn Beitragskorrekturen, dann Feld Begründung ausfüllen"]
[]
[]
[]
[]
[null,null,null,{"$f":"\"Die Abrechnungsprüfung wurde durch \"&IF(E12=\"\",\"……\",IF(B178=\"X\",E151,E12))&\" abgeschlossen.\"","v":"Die Abrechnungsprüfung wurde durch …… abgeschlossen."},null,null,null,null,null,"Datum:"]
[]
[null,null,null,null,null,null,null,null,null,"Zeitaufwand gesamt:",{"$f":"K147+K178+K255","v":"00:00:00"}]
["Seitenumbruch prüfen!"]

{"sheet":"HT","index":9,"n_rows":74,"n_cols":37,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
["Jahr",2023,{"$f":"TODAY()","v":"2023-11-23"},null,null,null,null,null,9]
[]
["LV-Nr.","Leistungserbringer",null,"Sachb.","FB","FB mit Text","LZ","Leistungsziele","Anbieter","Strasse","Tel","Mail","PLZ","Ort","web","Kontakt Name","Kontakt Vname","Angebotsart","TN-Statistik","TN-Zufried.h.","Serie",null,"FB","Förderbereiche",null,"Angebotsart",null,"Auftraggeber",null,"MA","Name MA","variabel/fix","vollständig","ok","Beitragskorrektur","ankreuzen","Dialogfenster am Anfang"]
["(bitte auswählen)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(bitte auswählen)",null,null,null,"-"]
[{"$f":"LEFT(B5,10)","v":"22-3000-00"},"22-3000-00 Deutschberatung im Migrationsamt - AOZ Zürich",{"$f":"MID(B5,12,999)","v":"Deutschberatung im Migrationsamt - AOZ Zürich"},"KR",2.1,{"$f":"VLOOKUP(E5,$W$5:$X$12,2,)","v":"2.1 Sprache"},"LZ10",{"$f":"VLOOKUP(G5,$W$18:$X$78,2,)","v":"LZ10: Sprachangebote"},"AOZ","Eggbühlstrasse 15","044 415 65 00","aoz@aoz.ch",8050,"Zürich","www.aoz.ch","Rodriguez","Irene",null,null,null,{"$f":"IF(A5=\"\",\"\",CONCATENATE($B$1-2000,\"-\",MID(A5,4,1)))","v":"23-3"},null,1.1000000000000001,"1.1 Erstinformation und Integrationsförderbedarf",null,"Veranstaltung/Veranstaltungsreihe",null,null,null,"BS","Strebel Barbara","variabel","nicht relevant","ok","weniger Ausgaben als geplant (z.B. wegen geringerem Leistungsvolumen, günstigeren Konditionen etc.)","X","Migrantinnen / Migranten"]
[{"$f":"LEFT(B6,10)","v":"22-3001-00"},"22-3001-00 Sprache und Integration für Gehörlose und Hörbehinderte - DIMA Zürich",{"$f":"MID(B6,12,999)","v":"Sprache und Integration für Gehörlose und Hörbehinderte - DIMA Zürich"},"KR",2.1,{"$f":"VLOOKUP(E6,$W$5:$X$12,2,)","v":"2.1 Sprache"},"LZ10","LZ10: Sprachangebote","DIMA - Verein für Sprache und Integration","Oerlikonerstrasse 98","043 333 52 27","info@dima-glz.ch",8057,"Zürich","www.dima-glz.ch","Murk","Véronique ",null,null,null,"23-3",null,1.2,"1.2 Beratung",null,"Kurs",null,"Adlikon",null,"DS","Dominik Schmid","fix","ja","nicht ok","Kürzung der anrechenbaren Kosten (vgl. oben)",null,"vorläufig Aufgenommene / Flüchtlinge"]
["22-3002-00","22-3002-00 Schulung von Freiwilligen der HEKS Konversationskurse - HEKS Zürich","Schulung von Freiwilligen der HEKS Konversationskurse - HEKS Zürich","KR",2.1,"2.1 Sprache","LZ10","LZ10: Sprachangebote","HEKS - Regionalstelle Zürich/Schaffhausen","Seminarstrasse 28","044 360 89 60","info@heks.ch",8042,"Zürich","www.heks.ch","Chaher","Viola",null,null,null,"23-3",null,1.3,"1.3 Schutz vor Diskriminierung",null,"Angebot für Einzelpersonen (Beratung, Besuch,..)",null,"Adliswil",null,"DY","Yüksel Deniz",null,"nein"]
["22-3003-00","22-3003-00 Weiterbildung Schlüsselpersonen Frühe Sprachbildung","Weiterbildung Schlüsselpersonen Frühe Sprachbildung","FW",2.2000000000000002,"2.2 Frühe Kindheit","LZ14","LZ14: Zugang zu Angeboten Frühe Kindh.","Berufsfachschule Winterthur","Tösstalstrasse 26","052 268 14 11",null,8400,"Winterthur","www.bfs-winterthur.ch","Mirjam","Britschgi",null,null,null,"23-3",null,2.1,"2.1 Sprache",null,"Arbeitsintegrationsprogramm",null,"Aesch",null,"EK","El Khoury Ellen"]
["22-3004-00","22-3004-00 Vermittlungsstelle für interkulturelles Dolmetschen - AOZ Medios","Vermittlungsstelle für interkulturelles Dolmetschen - AOZ Medios","MG",3.1,"3.1 Interkulturelles Dolmetschen und Vermitteln","LZ18","LZ18: Angebot IKD sichern","AOZ Medios - Interkulturelles Dolmetschen","Albisriederstrasse 164 ","044 415 65 00","medios@aoz.ch",8003,"Zürich","www.aoz.ch/medios","Luthiger","Gabriela",null,null,null,"23-3",null,2.2000000000000002,"2.2 Frühe Kindheit",null,"Integrationsbegleitung",null,"Aeugst a.A.",null,"FW","Will Frank"]
["22-3005-00","22-3005-00 Medios interne Weiterbildungen - AOZ Medios","Medios interne Weiterbildungen - AOZ Medios","MG",3.1,"3.1 Interkulturelles Dolmetschen und Vermitteln","LZ19","LZ19: Qualifikat IKD fördern","AOZ Medios - Interkulturelles Dolmetschen","Albisriederstrasse 164 ","044 415 65 00","medios@aoz.ch",8003,"Zürich","www.aoz.ch/medios","Luthiger","Gabriela",null,null,null,"23-3",null,2.2999999999999998,"2.3 Arbeitsmarktfähigkeit",null,null,null,"Affoltern a.A.",null,"JK","Kramer Joy"]
["22-3006-00","22-3006-00 AOZ Infoline für Geflüchtete","AOZ Infoline für Geflüchtete","BS",1.1000000000000001,"1.1 Erstinformation und Integrationsförderbedarf","LZ10","LZ10: Sprachangebote","AOZ","Eggbühlstrasse 15","044 415 65 00","aoz@aoz.ch",8050,"Zürich","www.aoz.ch","Rodriguez","Irene",null,null,null,"23-3",null,3.1,"3.1 Interkulturelles Dolmetschen und Vermitteln",null,null,null,"Altikon",null,"II","Izzo Isabella"]
["22-3007-00","22-3007-00 MIRSAH ausländerrechtliche Beratung - SAH","MIRSAH ausländerrechtliche Beratung - SAH","DY",1.2,"1.2 Beratung","LZ04","LZ04: Info über Beratungsangebote RS","SAH Schweizerisches Arbeiterhilfswerk","Josefstrasse 84, Postfach 2215","044 446 50 00","sah.zuerich@sah-zh.ch ",8031,"Zürich","www.sah-zh.ch","Reisch","Michaela",null,null,null,"23-3",null,3.2,"3.2 Zusammenleben",null,null,null,"Andelfingen",null,"LH","Lorenza Hiltmann"]
["22-3008-00","22-3008-00 Zürcher Anlaufstelle Rassismus ZüRAS - AOZ","Zürcher Anlaufstelle Rassismus ZüRAS - AOZ","DY",1.3,"1.3 Schutz vor Diskriminierung","LZ09","LZ09: SvD - Beratungsangebote","AOZ Psychosozialer Dienst PSD","Eggbühlstrasse 15","044 415 66 99","psd@aoz.ch",8050,"Zürich","www.aoz.ch","Rauh","Martin",null,null,null,"23-3",null,null,null,null,null,null,"Bachenbülach",null,"LU","Sanja Lukic"]
["22-3500-00","22-3500-00 Facebook - Deutsch Lernen zu Hause - AOZ Zürich","Facebook - Deutsch Lernen zu Hause - AOZ Zürich","KR",2.1,"2.1 Sprache","LZ10","LZ10: Sprachangebote","AOZ","Eggbühlstrasse 15","044 415 65 00","aoz@aoz.ch",8050,"Zürich","www.aoz.ch","Sengupta","Samantha",null,null,null,"23-3",null,null,null,null,"TN-Statistik",null,"Bachs",null,"MG","Gstöhl Maria"]
["22-3501-00","22-3501-00 Begegnungs- und Bildungsveranstaltungen - Forum der Religionen","Begegnungs- und Bildungsveranstaltungen - Forum der Religionen","DY",1.3,"1.3 Schutz vor Diskriminierung","LZ07","LZ07: SvD - Öffentlichk. Sensibilisieren","Zürcher Forum der Religionen","Schienhutgasse 6","044 252 46 32","office@forum-der-religionen.ch",8001,"Zürich","www.forum-der-religionen.ch","Läubli","Mirjam ",null,null,null,"23-3",null,null,null,null,null,null,"Bäretswil",null,"NG","Gilgen Nina"]
["22-3502-00","22-3502-00 Beratungsnetzwerk - DoSyRa - Beratungsnetz für Rassismusopfer","Beratungsnetzwerk - DoSyRa - Beratungsnetz für Rassismusopfer","DY",1.3,"1.3 Schutz vor Diskriminierung","LZ09","LZ09: SvD - Beratungsangebote","DoSyRa - Beratungsnetz für Rassismusopfer - humanrights.ch","Hallerstrasse 23","031 301 92 75","beratungsnetz@humanrights.ch",3012,"Bern","http://www.network-racism.ch/","Vega","Gina ",null,null,null,"23-3",null,"LZ","LZ mit Text",null,"Kurs allgemein",null,"Bassersdorf",null,"NN","BL Flü"]
["22-3503-00","22-3503-00 JASS info - JASS-mit","JASS info - JASS-mit","DY",1.3,"1.3 Schutz vor Diskriminierung","LZ07","LZ07: SvD - Öffentlichk. Sensibilisieren","JASS ","Postfach","076 408 44 22","kontakt@jass-mit.ch",8952,"Schlieren","www.jass-mit.ch","Bühler","Judith",null,null,null,"23-3",null,null,null,null,"Sprachkurs",null,"Bauma",null,"NS","Sambuco Nadia"]
["22-3506-00","22-3506-00 HEKS neue Gärten - HEKS","HEKS neue Gärten - HEKS","MG",3.2,"3.2 Zusammenleben","LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)","HEKS - Regionalstelle Zürich/Schaffhausen","Seminarstrasse 28","044 360 89 60","info@heks.ch",8042,"Zürich","www.heks.ch","Teismann","Susanne",null,null,null,"23-3",null,"LZ01","LZ01: Erstinfo (Unterstützung Gemeinden)",{"$f":"MID(X18,SEARCH(\":\",X18)+2,999)","v":"Erstinfo (Unterstützung Gemeinden)"},"Erstinformationsgespräch",null,"Benken",null,"KR","Renate Kummer"]
["22-3507-00","22-3507-00 Common Threads - Social Fabric Association","Common Threads - Social Fabric Association","MG",3.2,"3.2 Zusammenleben","LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)","Social Fabric Association","Eichstrasse 29",null,null,8045,"Zürich",null,"Portenier","Justine",null,null,null,{"$f":"IF(A20=\"\",\"\",CONCATENATE($B$1-2000,\"-\",MID(A20,4,1)))","v":"23-3"},null,"LZ101","LZ101: Erstinfo VA/FL",{"$f":"MID(X19,SEARCH(\":\",X19)+2,999)","v":"Erstinfo VA/FL"},"Beratung",null,"Berg a.I."]
["22-3508-00","22-3508-00 z'Basi underwägs - Bassersdorf","z'Basi underwägs - Bassersdorf","MG",3.2,"3.2 Zusammenleben","LZ20","LZ20: Zusammenleben (Unterstützung Gem.)","Gemeinde Bassersdorf","Karl Hügin-Platz 1, Postfach","044 838 85 85","gemeinde@bassersdorf.ch",8303,"Bassersdorf","www.bassersdorf.ch","Lachnit","Jessica",null,null,null,"23-3",null,"LZ102","LZ102: Ressourcenabschätzung VA/FL","Ressourcenabschätzung VA/FL","keine Angaben",null,"Bertschikon"]
["22-3509-00","22-3509-00 Brockolino - Sichtbar","Brockolino - Sichtbar","MG",3.2,"3.2 Zusammenleben","LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)","Verein Sichtbar","Rapperswilerstrasse 7","078 681 55 88",null,8630,"Rüti ZH",null,"Carle","Anette",null,null,null,"23-3",null,"LZ201","LZ201: Prod.Info-Mat.u. Einbez.Regelstr.","Prod.Info-Mat.u. Einbez.Regelstr.",null,null,"Birmensdorf"]
["22-3510-00","22-3510-00 Im Quartier - About Us! ","Im Quartier - About Us! ","MG",3.2,"3.2 Zusammenleben","LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)","About Us!","Badener Strasse 409","079 794 46 49",null,8003,"Zürich",null,"Zeeb","Gunda",null,null,null,"23-3",null,"LZ04","LZ04: Info über Beratungsangebote RS","Info über Beratungsangebote RS",null,null,"Bonstetten"]
["22-3511-00","22-3511-00 Begegnungsprojekte - Solinetz","Begegnungsprojekte - Solinetz","MG",3.2,"3.2 Zusammenleben","LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)","Verein Solidaritätsnetz Zürich (solinetz)","Dienerstrasse 59",null,"info@solinetz.ch",8004,"Zürich","www.solinetz-zh.ch","Gerig","Hanna",null,null,null,"23-3",null,"LZ05","LZ05: Unterstützung Regelstrukturen","Unterstützung Regelstrukturen",null,null,"Boppelsen"]
["22-3515-00","22-3515-00 Im GartenParkTreff  - ZHAW","Im GartenParkTreff  - ZHAW","MG",3.2,"3.2 Zusammenleben","LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)","ZHAW","Grüental, Postfach",null,null,8820,"Wädenswil",null,"Hagen Hodgson","Petra",null,null,null,"23-3",null,"LZ06","LZ06: Information Öffentlichkeit","Information Öffentlichkeit",null,null,"Brütten"]
["22-3516-00","22-3516-00 Found in Translation - Expo Transkultur","Found in Translation - Expo Transkultur","MG",3.2,"3.2 Zusammenleben","LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)","Verein Expo Transkultur ","Im Isengrind 20",null,"expotransk_verein@hotmail.com",8046,"Zürich","www.expotranskultur-ch.org","Ledesma","Alba Chantico",null,null,null,"23-3",null,"LZ103","LZ103: Standortgespräche VA/FL","Standortgespräche VA/FL",null,null,"Bubikon"]
["22-3517-00","22-3517-00 We together","We together","MG",3.2,"3.2 Zusammenleben","LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)","NCBI Schweiz","Alte Landstrasse 93a","044 721 10 50","info@ncbi.ch",8800,"Thalwil","www.ncbi.ch","Brunner Thiam","Madleina",null,null,null,"23-3",null,"LZ104","LZ104: Schnittstellen&Koordination VA/FL","Schnittstellen&Koordination VA/FL",null,null,"Buch a.I."]
["22-3526-00","22-3526-00 Lauf gegen Rassismus - Verein Lauf gegen Rassismus","Lauf gegen Rassismus - Verein Lauf gegen Rassismus","DY",1.3,"1.3 Schutz vor Diskriminierung","LZ07","LZ07: SvD - Öffentlichk. Sensibilisieren","Gewerkschaftsbund des Kantons Zürich","Stauffacherstrasse 60","044 241 97 97","info@gbkz.ch",8004,"Zürich","www.gbkz.ch","Resener","Björn",null,null,null,"23-3",null,"LZ202","LZ202: Stärkung von Migrant.u.deren Org.","Stärkung von Migrant.u.deren Org.",null,null,"Buchs"]
[{"$f":"LEFT(B28,10)","v":"22-3527-00"},"22-3527-00 Zigeunerkultur - Verein Zigeunerkultur",{"$f":"MID(B28,12,999)","v":"Zigeunerkultur - Verein Zigeunerkultur"},"DY",1.3,"1.3 Schutz vor Diskriminierung","LZ07","LZ07: SvD - Öffentlichk. Sensibilisieren","Verein Zigeunerkultur","Hardturmstrasse 366",null,null,8005,"Zürich",null,"Prelicz-Huber","Katharina",null,null,null,{"$f":"IF(A28=\"\",\"\",CONCATENATE($B$1-2000,\"-\",MID(A28,4,1)))","v":"23-3"},null,"LZ07","LZ07: SvD - Öffentlichk. Sensibilisieren","SvD - Öffentlichk. Sensibilisieren",null,null,"Bülach"]
["23-3500-00","23-3500-00 Tag der Völker - Interkulturelles Forum Winterthur","Tag der Völker - Interkulturelles Forum Winterthur","MG",3.2,"3.2 Zusammenleben","LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)","Interkulturelles Forum Winterthur","Postfach 1954",null,"info@interkulturellesforum.ch",8401,"Winterthur","http://www.interkulturellesforum.ch/","Karadas","Ali S.",null,null,null,"23-3",null,"LZ08","LZ08: SvD - Unterstützung Verwaltung","SvD - Unterstützung Verwaltung",null,null,"Dachsen"]
["23-3501-00","23-3501-00 Vernetzungsanlass Expo Transkultur","Vernetzungsanlass Expo Transkultur","MG",3.2,"3.2 Zusammenleben","LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)","Verein Expo Transkultur ","Blumenfeldstrasse 80",null,"expotransk_verein@hotmail.com",8046,"Zürich","www.expotranskultur-ch.org","Ledesma","Alba Chantico",null,null,null,"23-3",null,"LZ09","LZ09: SvD - Beratungsangebote","SvD - Beratungsangebote"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A32=\"\",\"\",CONCATENATE($B$1-2000,\"-\",MID(A32,4,1)))","v":""},null,"LZ203","LZ203: Chnagengerechte Förderung v.VA/FL","Chnagengerechte Förderung v.VA/FL",null,null,"Dägerlen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ10","LZ10: Sprachangebote","Sprachangebote",null,null,"Dällikon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ105","LZ105: Sprachförderung VA/FL","Sprachförderung VA/FL",null,null,"Dänikon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ106","LZ106: Bildungsangebote VA/FL","Bildungsangebote VA/FL",null,null,"Dättlikon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ12","LZ12: Frühe Kindh. - Unterstützung Gem.","Frühe Kindh. - Unterstützung Gem.",null,null,"Dielsdorf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ13","LZ13: Vernetzung Angebote Frühe Kindh.",{"$f":"MID(X36,SEARCH(\":\",X36)+2,999)","v":"Vernetzung Angebote Frühe Kindh."},null,null,"Dietikon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ14","LZ14: Zugang zu Angeboten Frühe Kindh.","Zugang zu Angeboten Frühe Kindh.",null,null,"Dietlikon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ107","LZ107: Frühkindliche Sprachförd. VA/FL","Frühkindliche Sprachförd. VA/FL",null,null,"Dinhard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ15","LZ15: Arbeitsmarktfähigk. - ZusammenArb.","Arbeitsmarktfähigk. - ZusammenArb.",null,null,"Dübendorf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ108","LZ108: Einbindung Regelstrukturen VA/FL","Einbindung Regelstrukturen VA/FL",null,null,"Dorf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ109","LZ109: Vert. Potenzialabkl.&Praxisassess",{"$f":"MID(X41,SEARCH(\":\",X41)+2,999)","v":"Vert. Potenzialabkl.&Praxisassess"},null,null,"Dübendorf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"LZ110","LZ110: Jobcoaching","Jobcoaching",null,null,"Dürnten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LZ111","LZ111: Qualifizierungsprogramme","Qualifizierungsprogramme",null,null,"Egg"]
["(bitte auswählen)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LZ112","LZ112: Arbeitseinsätze","Arbeitseinsätze",null,null,"Eglisau"]
[{"$f":"LEFT(B45,10)","v":"21-4500-00"},"21-4500-00 Pilot Hochschulzugang für Geflüchtete - Universität Zürich","Pilot Hochschulzugang für Geflüchtete - Universität Zürich","JK",2.1,"2.1 Sprache","LZ106",{"$f":"VLOOKUP(G45,$W$18:$X$78,2,)","v":"LZ106: Bildungsangebote VA/FL"},"Universität Zürich","Rämistrasse 71",null,null,8006,"Zürich",null,"Marquart","Chantal",null,null,null,{"$f":"IF(A45=\"\",\"\",CONCATENATE($B$1-2000,\"-\",MID(A45,4,1)))","v":"23-4"},null,"LZ18","LZ18: Angebot IKD sichern",{"$f":"MID(X45,SEARCH(\":\",X45)+2,999)","v":"Angebot IKD sichern"},null,null,"Elgg"]
["22-4000-00","22-4000-00  Deutschkurse - AFK"," Deutschkurse - AFK","KH",2.1,"2.1 Sprache","LZ105","LZ105: Sprachförderung VA/FL","Ambulatorium für Folter- und Kriegsopfer AFK","Culmannstrasse 8","044 255 86 84",null,8091,"Zürich",null,"Schick","Matthis",null,null,null,"23-4",null,"LZ19","LZ19: Qualifikat IKD fördern",{"$f":"MID(X46,SEARCH(\":\",X46)+2,999)","v":"Qualifikat IKD fördern"},null,null,"Ellikon a.d.Th."]
["22-4001-00","22-4001-00  Informationsveranstaltungen und interkultureller Treffpunkt - AFK"," Informationsveranstaltungen und interkultureller Treffpunkt - AFK","KH",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Ambulatorium für Folter- und Kriegsopfer AFK","Culmannstrasse 8","044 255 86 84",null,8091,"Zürich",null,"Schick","Matthis",null,null,null,"23-4",null,"LZ20","LZ20: Zusammenleben (Unterstützung Gem.)",{"$f":"MID(X47,SEARCH(\":\",X47)+2,999)","v":"Zusammenleben (Unterstützung Gem.)"},null,null,"Elsau"]
["22-4002-00","22-4002-00 Förderprogramm Freiwilligenarbeit - Richterswil","Förderprogramm Freiwilligenarbeit - Richterswil","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Gemeinde Richterswil","Seestrasse 19",null,null,8805,"Richterswil","www.richterswil.ch","Weber","Kim",null,null,null,"23-4",null,"LZ21","LZ21: ZusLeben (Förderg. Migrationsbev.)",{"$f":"MID(X48,SEARCH(\":\",X48)+2,999)","v":"ZusLeben (Förderg. Migrationsbev.)"},null,null,"Embrach"]
["22-4502-00","22-4502-00 \"qualifiziert engagiert\" für Gemeinden - Neftenbach","\"qualifiziert engagiert\" für Gemeinden - Neftenbach","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Gemeinde Neftenbach","Schulstrasse 3/7",null,null,8413,"Neftenbach",null,"Moser","Claudia",null,null,null,"23-4",null,"LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL",{"$f":"MID(X49,SEARCH(\":\",X49)+2,999)","v":"Teiln. am gesellsch.Leben VA/FL"},null,null,"Erlenbach"]
["22-4503-00","22-4503-00 \"qualifiziert engagiert\" für Institutionen -  HiCoders","\"qualifiziert engagiert\" für Institutionen -  HiCoders","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Verein HiCoders","Schaffhauserstr. 470",null,null,8052,"Zürich",null,"Dogan","Mehmet",null,null,null,"23-4",null,null,null,null,null,null,"Fällanden"]
["22-4504-00","22-4504-00 \"qualifiziert engagiert\" für Institutionen - OFF Ort für Frauen","\"qualifiziert engagiert\" für Institutionen - OFF Ort für Frauen","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","OFF Ort für Frauen","Zollikerstrasse 76","079 724 87 74",null,8008,"Zürich",null,"Simonett-Marincek","Tanja",null,null,null,"23-4",null,null,null,null,null,null,"Wangen-Brüttisellen"]
["22-4505-00","22-4505-00 \"qualifiziert engagiert\" für Institutionen - Social Fabric Association","\"qualifiziert engagiert\" für Institutionen - Social Fabric Association","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Social Fabric Association","Eichstrasse 29",null,null,8045,"Zürich",null,"Portenier","Justine",null,null,null,"23-4",null,null,null,null,null,null,"Amt für Wirtschft und Arbeit"]
["22-4506-00","22-4506-00 \"qualifiziert engagiert\" für Institutionen - Solinetz","\"qualifiziert engagiert\" für Institutionen - Solinetz","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Verein Solidaritätsnetz Zürich (solinetz)","Dienerstrasse 59",null,"info@solinetz.ch",8004,"Zürich","www.solinetz-zh.ch","Gerig","Hanna",null,null,null,"23-4",null,null,null,null,null,null,"Sportamt"]
["22-4507-00","22-4507-00 \"qualifiziert engagiert\" für Gemeinden - Bülach","\"qualifiziert engagiert\" für Gemeinden - Bülach","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Stadt Bülach","Allmendstrasse 6","044 863 15 40",null,8180,"Bülach",null,"Perego","Nadine",null,null,null,"23-4"]
["22-4509-00","22-4509-00 \"qualifiziert engagiert\" für Gemeinden - Hinwil","\"qualifiziert engagiert\" für Gemeinden - Hinwil","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Gemeinde Hinwil","Dürntnerstrasse 8","044 938 55 11",null,8340,"Hinwil",null,"Diez Brodmann","Anabel",null,null,null,"23-4"]
["23-4001-00","23-4001-00 qualifiziert engagiert\" für Gemeinden - Zürich","qualifiziert engagiert\" für Gemeinden - Zürich","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Stadt Zürich","Werdstrasse 75","+41 44 412 70 00","via Kontaktformular",8036,"Zürich","https://www.stadt-zuerich.ch/sd/de/index.html","Radman","Lisa",null,null,null,"23-4"]
["23-4501-00","23-4501-00 \"qualifiziert engagiert\" für Institutionen - Sichtbar","\"qualifiziert engagiert\" für Institutionen - Sichtbar","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Verein Sichtbar","Rapperswilerstrasse 7","078 681 55 88",null,8630,"Rüti ZH",null,"Carle","Anette",null,null,null,"23-4"]
["23-4502-00","23-4502-00 \"qualifiziert engagiert\" für Institutionen - Von der Migration zur Integration","\"qualifiziert engagiert\" für Institutionen - Von der Migration zur Integration","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Von der Migration zur Integration","Binzalle 10","077 929 29 36","elena.inoks@gmail.com",8055,"Zürich","vmzi.ch","Oks","Elena",null,null,null,"23-4"]
["23-4503-00","23-4503-00  \"qualifiziert engagiert\" für Gemeinden - Aeugst a. A."," \"qualifiziert engagiert\" für Gemeinden - Aeugst a. A.","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Gemeinde Aeugst a.A.","Dorfstrasse 22","044 763 50 60","gemeinde@aeugst-albis.ch",8914,"Aeugst am Albis",null,"Styrsky","Vit",null,null,null,"23-4"]
["23-4504-00","23-4504-00 \"qualifiziert engagiert\" für Gemeinden - Affoltern a. A.","\"qualifiziert engagiert\" für Gemeinden - Affoltern a. A.","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Stadt  Affoltern am Albis","Marktplatz 1",null,null,8910,"Affoltern am Albis","www.affoltern-am-albis.ch","Ochsner","Regula",null,null,null,"23-4"]
["23-4505-00","23-4505-00 \"qualifiziert engagiert\" Expo Transkultur","\"qualifiziert engagiert\" Expo Transkultur","MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Verein Expo Transkultur ","Im Isengrind 20",null,"expotransk_verein@hotmail.com",8046,"Zürich","www.expotranskultur-ch.org","Ledesma","Alba Chantico",null,null,null,"23-4"]
["23-4506-00","23-4506-00 \"qualifiziert engagiert\" für Institutionen - plentii",{"$f":"MID(B62,12,999)","v":"\"qualifiziert engagiert\" für Institutionen - plentii"},"MG",3.2,{"$f":"VLOOKUP(E62,$W$5:$X$12,2,)","v":"3.2 Zusammenleben"},"LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","plentii","Müllerstrasse 67",763359830,"contact@plentii.ch",8004,"Zürich",null,"Züger","Ayana",null,null,null,"23-4"]
["23-4507-00","23-4507-00 \"qualifiziert engagiert\" für Institutionen -NCBI",{"$f":"MID(B63,12,999)","v":"\"qualifiziert engagiert\" für Institutionen -NCBI"},"MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","NCBI Schweiz","Alte Landstrasse 93a","044 721 10 50","info@ncbi.ch",8800,"Thalwil","www.ncbi.ch","Brunner Thiam","Madleina",null,null,null,"23-4"]
["23-4508-00","23-4508-00 \"qualifiziert engagiert\" für Gemeinden - Rümlang",{"$f":"MID(B64,12,999)","v":"\"qualifiziert engagiert\" für Gemeinden - Rümlang"},"MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Gemeinde Rümlang","Glattalstrasse 201",null,"gemeinde@ruemlang.zh.ch",8153,"Rümlang",null,"Baumgartner Kläy","Brigitte",null,null,null,"23-4"]
["23-4509-00","23-4509-00 \"qualifiziert engagiert\" für Gemeinden - Wetzikon",{"$f":"MID(B65,12,999)","v":"\"qualifiziert engagiert\" für Gemeinden - Wetzikon"},"MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Stadt Wetzikon","Bahnhofstrasse 167",null,"info@wetzikon.ch",8620,"Wetzikon ZH","www.wetzikon.ch","Hotz","Christoph",null,null,null,"23-4"]
["23-4510-00","23-4510-00 Pro Juventute",{"$f":"MID(B66,12,999)","v":"Pro Juventute"},"II",1.1000000000000001,"1.1 Erstinformation und Integrationsförderbedarf","LZ101","LZ101: Erstinfo VA/FL","Pro Juventute","Thurgauerstrasse 39","044 256 77 77","info@projuventute.ch",8050,"Zürich","www.projuventute.ch","Gähwiler-Wick","Paul",null,null,null,"23-4"]
["23-4511-00","23-4511-00 \"qualifiziert engagiert\" Gocal Roots",{"$f":"MID(B67,12,999)","v":"\"qualifiziert engagiert\" Gocal Roots"},"MG",3.2,{"$f":"VLOOKUP(E67,$W$5:$X$12,2,)","v":"3.2 Zusammenleben"},"LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Glocal Roots","Branschenkenstrasse 178","079 783 22 89","liska@glocalroots.org",8002,"Zürich","www.glocalroots.org","Bernet","Liska",null,null,null,"23-4"]
["23-4512-00","23-4512-00 \"qualifiziert engagiert\" AsyLex",{"$f":"MID(B68,12,999)","v":"\"qualifiziert engagiert\" AsyLex"},"MG",3.2,{"$f":"VLOOKUP(E68,$W$5:$X$12,2,)","v":"3.2 Zusammenleben"},"LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","AsyLex","Gotthardstrasse 52","079 467 04 80","operations@asylex.ch",8002,"Zürich","www.asylex.ch","Riedener","Lea",null,null,null,"23-4"]
["23-4513-00","23-4513-00 \"qualifiziert engagiert\" Bachenbülach",{"$f":"MID(B69,12,999)","v":"\"qualifiziert engagiert\" Bachenbülach"},"MG",3.2,{"$f":"VLOOKUP(E69,$W$5:$X$12,2,)","v":"3.2 Zusammenleben"},"LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Gemeinde Bachenbülach","Schulhausstrasse 1","044 864 34 80","info@bachenbuelach.ch",8184,"Bachenbülach","https://www.bachenbuelach.ch/","Burns","Daniel",null,null,null,"23-4"]
["23-4514-00","23-4514-00 \"qualifiziert engagiert\" Sportegration",{"$f":"MID(B70,12,999)","v":"\"qualifiziert engagiert\" Sportegration"},"MG",3.2,"3.2 Zusammenleben","LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Verein Sportegration","Steinhaldenstrasse 59",null,null,8002,"Zürich",null,"Largo","Annina",null,null,null,"23-4"]
["23-4515-00","23-4515-00 \"qualifiziert engagiert\" Pikett Asyl","\"qualifiziert engagiert\" Pikett Asyl","MG",3.2,{"$f":"VLOOKUP(E71,$W$5:$X$12,2,)","v":"3.2 Zusammenleben"},"LZ113","LZ113: Teiln. am gesellsch.Leben VA/FL","Pikett Asyl","Elsässerstrasse 7",null,"l.hoeft@pikett-asyl.ch",4056,"Basel",null,"Hoeft","Lara",null,null,null,"23-4"]
[""]
[""]
[""]