{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Info für VK Kalk","Konzeptbilder","Entwicklung","Projekt-Management","HK Protot.","Materialkosten Protot.","HK Serie","Materialkosten Serie","Zusatzkosten Serie","Änderungshistorie Kalkulation","Änderungshistorie Template"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Info für VK Kalk","index":0,"n_rows":38,"n_cols":7,"rows_kept":38}
[]
[{"$nulls":3},"Projektkalkulation"]
[{"$nulls":3},"<name>","(Dieser Text ist mit allen Tabellen verknüpft)"]
[{"$nulls":3},"Diese Kalkulation zeigt die materiellen Aufwände für ...."]
[{"$nulls":3},"Weiterhin dient diese Kalkulation dem Vertrieb für eine Angebotserstellung."]
[{"$nulls":3},"Basis sind die Informationen seitens …"]
[]
[{"$nulls":3},"Diese Kalkulation ist nur für interne Zwecke zu verwenden."]
[null,null,"Auftrag (Kurzform):"]
[]
[]
[]
[]
[]
[]
[null,null,"Start des Projektes:","dd.mm.yyyy (frühestmöglich)"]
[null,null,"Laufzeit bis Freigabe:","x Wochen nach Auftragseingang"]
[null,null,"Prämissen:","Reisekosten werden nach Aufwand berechnet"]
[{"$nulls":3},"Kunde oder Auftraggeber nimmt die Funktionalität sowie alle zugehörige Dokumente ab"]
[]
[]
[]
[{"$nulls":3},"Position für Angebot (siehe Tabellen)","Anzahl","Kosten"]
[{"$nulls":3},"Entwicklung",1,{"$f":"Entwicklung!K65","v":0},"(siehe Tabelle Entwicklung)"]
[{"$nulls":3},"Projekt-Management",1,{"$f":"'Projekt-Management'!K24","v":0},"(siehe Tabelle Projekt-Management)"]
[{"$nulls":3},"Herstellkosten (HK) Prototyp",1,{"$f":"'HK Protot.'!I19*E26","v":0},"(siehe Tabelle HK Protot.)"]
[{"$nulls":3},"Materialkosten Prototyp",1,{"$f":"'Materialkosten Protot.'!G19*E27","v":0},"(siehe Tabelle Materialkosten Protot.)"]
[{"$nulls":3},"Herstellkosten (HK) Serie",1,{"$f":"'HK Serie'!I17*E28","v":0},"(siehe Tabelle HK Serie)"]
[{"$nulls":3},"Materialkosten Serie",1,{"$f":"'Materialkosten Serie'!G19*E29","v":0},"(siehe Tabelle Materialkosten Serie)"]
[{"$nulls":3},"Summe","-",{"$f":"SUM(F24:F29)","v":0}]
[]
[]
[{"$nulls":3},"Andere Kosten","Anzahl","Kosten"]
[{"$nulls":3},"DocuTrim Basis (muss hinzu, da diese Komponenten i m m e r eingebaut werden müssen um Varianten zu vermeiden)",1,{"$f":"'Zusatzkosten Serie'!G21*E34","v":0},"(siehe Tabelle Zusatzkosten Serie)"]
[]
[{"$nulls":3},"Summe","-",{"$f":"SUM(F34:F35)","v":0}]
[]
[null,null,"file:",{"$f":"MID(CELL(\"Dateiname\",C1),SEARCH(\"[\",CELL(\"Dateiname\",C1),1)+1,SEARCH(\"]\",CELL(\"Dateiname\",C1),1)-SEARCH(\"[\",CELL(\"Dateiname\",C1),1)-1)","v":"Projekt-Kalkulation-empty-.xlsx"}]

{"sheet":"Konzeptbilder","index":1,"n_rows":5,"n_cols":3,"rows_kept":5}
[]
[]
[null,"Projekt:",{"$f":"'Info für VK Kalk'!D3","v":"<name>"}]
[]
[null,null,"(Titel nicht ändern. Nur ändern in Tabelle \"Info…\")"]

{"sheet":"Entwicklung","index":2,"n_rows":65,"n_cols":16,"rows_kept":65,"merged":[[3,1,3,5],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,4,10]]}
[]
[{"$nulls":3},"Projekt:",{"$f":"'Info für VK Kalk'!D3","v":"<name>"}]
[{"$nulls":4},"(Titel nicht ändern. Nur ändern in Tabelle \"Info…\")"]
[null,"Entwicklung",{"$nulls":4},"INPUT IN YELLOW FIELDS AND COLUMNS C;D;E"]
[null,"Gate\nRef:","Owner","Arbeitspaket","Aufgaben/Inhalte/Erwartungen/Ergebnisse\nALLGEMEIN, nicht im Angebot aufzunehmen","konkrete Ionformation um genannten Projekt.\nDiese Punkte können im Angebot mit aufgeführt werden.","Aufwand Stunden Kosten"]
[{"$nulls":6},"Dauer\n[h]","Stundensatz","Summen-Kosten\nEntwicklung","Pauschal-\nKosten","Gesamt-\nKosten"]
[null,"G1",null,"Idee/Vorhaben"]
[null,1,"DEV","Spezifikation HMI","Analyse Lastenheft \"was soll das System können?\"; Analyse vorliegender Anforderungen",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},{"$f":"H8*G8","v":0},0,{"$f":"J8+I8","v":0}]
[null,2,"DEV","Spezifikation Steuerung","Pflichtenheft \"wie werden die Anforderungen umgesetzt?\"",null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,3,"DEV","Risikobewertungen","komplettes System (2 Schleifen)",null,0,{"v":50,"d":"50.00 €"},{"$f":"H10*G10","v":0},0,{"$f":"J10+I10","v":0}]
[null,4,"DEV","Sicherheitsanforderungen und Konzept","komplettes System (Zeichnungen, Blockbilder)",null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,5,"DEV","Entwicklungsprozesse","Reviews, Freigaben, Änderungsmanagement, CS-AUF",null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,6,"DEV","Patentrecherche","externes Büro",null,0,{"v":50,"d":"50.00 €"},0,0,{"$f":"J13+I13","v":0}]
[null,7,"DEV","Entwicklung Konzept Smarte Technologien","Konzipierung und Partnerbetreuung (Smarte Techn. Dienstl. Software) Präventive/Prädiktive Maintenance, IoT",null,0,{"v":50,"d":"50.00 €"},0,0,{"$f":"J14+I14","v":0}]
[null,8,"DEV","Entwicklung Prüf- und Simulations-Software (EMV, Diagnose)","Umsetzung, Inbetriebnahmen, Prüfungen, Validierungen",null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,9,"DEV","Entwicklung Prüf-Equipment","Zeichnungen, Inbetriebnahmen, Prüfungen, Validierungen (z.B. Schnittstellen), Übernahme vorhandenen Prüfequipm.",null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,10,"DEV","Smarte Technologien Dienstleistung Software","z.B. ITQ, Holsten…IoT, Cloud, Mobile-Handbücher, Mobile-TK, Mobile Ersatzteile",null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,11,"DEV","-","-",null,0,{"v":50,"d":"50.00 €"},{"$f":"H18*G18","v":0},0,0]
[{"$nulls":10},{"$f":"SUM(K8:K18)","v":0}]
[null,"G2",null,"Konzept Entwicklung"]
[null,1,"DEV","Konzept Mechanik/Elektrik/Pneumatik/HMI/Schnittstellen/System","Erstellung Grobkonzepte / Feinkonzepte / Prinzipskizze / Komponentenermittlung (Dokumente) / Systembetrachtung",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},{"$f":"H21*G21","v":0},0,{"$f":"J21+I21","v":0}]
[null,2,"DEV","-","-",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},{"$f":"H22*G22","v":0},0,{"$f":"J22+I22","v":0}]
[{"$nulls":10},{"$f":"SUM(K21:K22)","v":0}]
[null,"G3",null,"Design Entwicklung Mechanische "]
[null,1,"DEV","Mechanische Konstruktion","Entwicklung Mechanik, Änderung Mechanik, Stücklisten, MTTR, MTBF, CS-AUF",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},{"$f":"H25*G25","v":0},0,{"$f":"J25+I25","v":0}]
[null,2,"DEV","Mechanische Konstruktion",null,null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,3,"DEV","Mechanische Konstruktion",null,null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,4,"DEV","Mechanische Konstruktion",null,null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,5,"DEV","Mechanische Konstruktion",null,null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,6,"DEV","Mechanische Konstruktion",null,null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,7,"DEV","Mechanische Konstruktion",null,null,0,{"v":50,"d":"50.00 €"},{"$f":"H31*G31","v":0},0,{"$f":"J31+I31","v":0}]
[null,8,"DEV","Mechanische Konstruktion",null,null,0,{"v":50,"d":"50.00 €"},{"$f":"H32*G32","v":0},0,{"$f":"J32+I32","v":0}]
[null,9,"DEV","Mechanische Konstruktion",null,null,0,{"v":50,"d":"50.00 €"},{"$f":"H33*G33","v":0},0,{"$f":"J33+I33","v":0}]
[{"$nulls":10},{"$f":"SUM(K25:K33)","v":0}]
[null,"G4",null,"Design Entwicklung EE/HW/SW"]
[null,1,"DEV","EE / HW Entwicklung (HARDWARE)","E-Pläne, Steuerungsintegration, Motor-Steuerungs-Integration, Vernetzung, Komponentenrecherche, Spezifikationen, Messungen, Nachweise, Steuerungsplatine überarbeiten, neue Klemmen, neue Komponenten",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},{"$f":"H36*G36","v":0},0,{"$f":"J36+I36","v":0}]
[null,2,"DEV","EE / SW Entwicklung (SOFTWARE)","Steuerungsintegration, Motor-Steuerungs-Integration, Spezifikationen, Parametrierungen, Revisionen, Steuerungs-Software",null,0,{"v":50,"d":"50.00 €"},0,0,{"$f":"J37+I37","v":0}]
[null,3,"DEV","Entwicklung HMI (SOFTWARE)","Umsetzung 8 Eingänge/8 Ausgänge, Inbetriebnahmen, Prüfungen, Validierungen",null,0,{"v":50,"d":"50.00 €"},0,0,0]
[null,4,"DEV","Integration ins System","IBN's / Validierung",null,0,{"v":50,"d":"50.00 €"},0,0,{"$f":"J39+I39","v":0}]
[null,5,"DEV","Temperatur Analyse","Nachweise / Messung",null,0,{"v":50,"d":"50.00 €"},0,0,{"$f":"J40+I40","v":0}]
[null,6,"DEV","-","-",null,0,{"v":50,"d":"50.00 €"},0,0,{"$f":"J41+I41","v":0}]
[{"$nulls":10},{"$f":"SUM(K36:K41)","v":0}]
[null,"G5",null,"Prüfung und Validierung"]
[null,1,"DEV","Entwicklungsbegleitende Prüfungen","Funktionen (SW), Mechanik, Papier, Elektrisch",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},0,0,0]
[null,2,"DEV","System-Prüfung und -Validierung","Funktionen (SW), Zuverlässigkeit, Leistungsmatrix, Dokumentation, SAFETY-Funktionalität",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},0,0,0]
[null,3,"DEV","-","-",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},{"$f":"H46*G46","v":0},0,0]
[{"$nulls":10},{"$f":"SUM(K44:K46)","v":0},{"$nulls":4}," "]
[null,"G6",null,"Zertifizierung Aktivitäten"]
[null,1,"DEV","UL- Aktivitäten","komplettes System inkl. CCL-Listen -> Annahme, dass UL hier nur ein Nachtrag ist.",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},0,0,0]
[null,2,"DEV","GS (MRL) - Aktivitäten","komplettes System (SiSteMA, Lärm, Sicherheit) inkl. Begleitung bei uns im Haus -> Annahme, dass Failsafe angefordert wird",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},0,0,0]
[null,3,"DEV","EMV - Aktivitäten","komplettes System (Mindestanforderungen für Europa) inkl. begleitende Prüfungen im Labor -> kein Einfluss zu erwarten",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},0,0,0]
[null,4,"DEV","-","-",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},0,0]
[{"$nulls":10},{"$f":"SUM(K49:K52)","v":0}]
[null,"G7",null,"Dokumentation"]
[null,1,"DEV","Technische Dokumentation ","BA's, SA's, TK's, andere, Schnittstellenbeschreibung zu Multigraf",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},0,0,0]
[null,2,"DEV","entwicklungsbegleitende Dokumentation","Messungen, Technische Informationen, Prüfanleitungen Schnittstelle",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},0,0,0]
[null,3,"DEV","-","-",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},{"$f":"H57*G57","v":0},0,0]
[{"$nulls":10},{"$f":"SUM(K55:K57)","v":0}]
[null,"G8",null,"t.b.d."]
[null,1,"DEV","-","-",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},0,0,0]
[null,2,"DEV","-","-",null,0,{"$f":"$C$65","v":{"v":50,"d":"50.00 €"}},{"$f":"H61*G61","v":0},0,{"$f":"J61+I61","v":0}]
[{"$nulls":10},{"$f":"SUM(K60:K61)","v":0}]
[]
[]
[null,null,{"v":50,"d":"50.00 €"},"Stundensatz",{"$nulls":5},"Summe",{"$f":"K19+K23+K34+K42+K47+K53+K58+K62","v":0}]

{"sheet":"Projekt-Management","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"merged":[[3,1,3,4],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,4,10]]}
[]
[{"$nulls":3},"Projekt:",{"$f":"'Info für VK Kalk'!D3","v":"<name>"}]
[{"$nulls":4},"(Titel nicht ändern. Nur ändern in Tabelle \"Info…\")"]
[null,"Projekt-Management",{"$nulls":4},"INPUT IN YELLOW FIELDS"]
[null,"Gate\nRef:","Owner","Arbeitspaket","Aufgaben/Inhalte/Erwartungen/Ergebnisse\nALLGEMEIN, nicht im Angebot aufzunehmen","konkrete Ionformation um genannten Projekt.\nDiese Punkte können im Angebot mit aufgeführt werden.","Aufwand Stunden Kosten"]
[{"$nulls":6},"Dauer\n[h]","Stundensatz","Summen-Kosten\nEntwicklung","Pauschal-\nKosten","Gesamt-\nKosten"]
[null,"G1",null,"Aktivitäten"]
[null,1,"PMO","Overhead","Modellnummer, CS-AUF, Besprechungen intern/extern, Dokumentenaustausch, Stati","-",0,{"$f":"$C$24","v":{"v":50,"d":"50.00 €"}},{"$f":"H8*G8","v":0},0,{"$f":"J8+I8","v":0}]
[null,2,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,0]
[null,3,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,{"$f":"J10+I10","v":0}]
[null,4,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,{"$f":"J11+I11","v":0}]
[null,5,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,0]
[null,6,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,0]
[null,7,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,{"$f":"J14+I14","v":0}]
[null,8,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,{"$f":"J15+I15","v":0}]
[null,9,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,0]
[null,10,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,0]
[null,11,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,0]
[null,12,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},{"$f":"H19*G19","v":0},0,{"$f":"J19+I19","v":0}]
[null,13,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,0]
[null,14,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,0]
[null,15,"PMO","-","-","-",0,{"v":50,"d":"50.00 €"},0,0,0]
[]
[null,null,{"v":50,"d":"50.00 €"},"Stundensatz",{"$nulls":5},"Summe",{"$f":"SUM(K8:K19)","v":0}]

{"sheet":"HK Protot.","index":4,"n_rows":22,"n_cols":18,"rows_kept":22,"merged":[[5,2,5,3],[5,11,5,12],[5,14,5,15]]}
[]
[]
[null,null,"Projekt:",{"$f":"'Info für VK Kalk'!D3","v":"<name>"}]
[{"$nulls":3},"(Titel nicht ändern. Nur ändern in Tabelle \"Info…\")"]
[]
[null,null,"Herstellkosten (HK) Prototyp",null,"INPUT IN YELLOW FIELDS",{"$nulls":6},"Abschätzung\n als %",null,null,"Abschätzung\nEURO"]
[null,null,"Herstellung","Beschreibung","Std","€ ek pro Std","€ ek gesamt\nMontage","€ ek gesamt\nHT & KT","€ Summe EK\n+ Montage",null,null,"Kaufteil","Hausteil",null,"Kaufteil","Hausteil",null,"chk sum"]
[null,1,"Externe Box (Gehäuse), Montage","Versuchsträger, 1. System, Baugruppen, Teile,\nTeilebeschaffung, Kommissionierung, IF88-Baugruppe",0,{"$f":"$C$22","v":{"v":50,"d":"50.00 €"}},{"$f":"F8*E8","v":0},0,{"$f":"H8+G8","v":0},null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"I8*L8","v":0},{"$f":"I8*M8","v":0},null,{"$f":"O8+P8","v":0}]
[null,2,"Modulanpassung","1 System, z.B. Integration Stecker, Kabel, Leitungen, mechanische Ausbrüche",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"I9*L9","v":0},{"$f":"I9*M9","v":0},null,{"$f":"O9+P9","v":0}]
[null,3,"IBN und Prüfung","1 System",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,4,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,5,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,6,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,7,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,8,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,9,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,10,"Einkauf und Recherche","-",0,{"v":50,"d":"50.00 €"},{"$f":"F17*E17","v":0},0,{"$f":"H17+G17","v":0},null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"I17*L17","v":0},{"$f":"I17*M17","v":0},null,0]
[null,11,"Kommissionieren","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"I18*L18","v":0},{"$f":"I18*M18","v":0},null,0]
[null,null,"Summe Kosten (EK)",null,{"$f":"SUM(E8:E18)","v":0},null,{"$f":"SUM(G8:G18)","v":0},{"$f":"SUM(H8:H18)","v":0},{"$f":"SUM(I8:I18)","v":0},{"$nulls":5},{"$f":"SUM(O8:O18)","v":0},{"$f":"SUM(P8:P18)","v":0},null,{"$f":"SUM(R8:R18)","v":0}]
[]
[{"$nulls":14},"\"Blau\" Info für VK Kalk tab \"Info für VK Kalk\""]
[null,null,{"v":50,"d":"50.00 €"},"Stundensatz"]

{"sheet":"Materialkosten Protot.","index":5,"n_rows":19,"n_cols":15,"rows_kept":19,"merged":[[4,2,4,3],[4,8,4,9],[4,11,4,12]]}
[]
[]
[null,null,"Projekt:",{"$f":"'Info für VK Kalk'!D3","v":"<name>"}]
[{"$nulls":3},"(Titel nicht ändern. Nur ändern in Tabelle \"Info…\")"]
[null,null,"Materialkosten Prototyp",null,"INPUT IN YELLOW FIELDS",{"$nulls":3},"Abschätzung\n als %",null,null,"Abschätzung\nEURO"]
[null,null,"Bezeichnung / Teil / Material","Typ","Anzahl","Stückkosten","Gesamtkosten",null,"Kaufteil","Hausteil",null,"Kaufteil","Hausteil",null,"chk sum"]
[null,null,"Gehäuse","Alu, Hutschiene",0,0,{"$f":"E7*F7","v":0},null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"G7*I7","v":0},{"$f":"G7*J7","v":0},null,{"$f":"L7+M7","v":0}]
[null,null,"Klemmen (Scheiben), Relais","Beckhoff, Finder",0,0,{"$f":"E8*F8","v":0},null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"G8*I8","v":0},{"$f":"G8*J8","v":0},null,{"$f":"L8+M8","v":0}]
[null,null,"Stecker ","Sub-D, Einbau, Signale, Failsafe",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"Sicherung","Thermo-Sicherung",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"Kabel/Leitungen/Klemmen/Durchführungen","diverses Material für Montage",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"Typenschild","Typenschild",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"IF88","für DocuTrim 8/8",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"Stecker Power (24 Vdc)","in Modul",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"Stecker Netzwerk (für EtherCAT)","in Modul",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"Buskoppler (EtherCAT)","in Modul",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"Netzwerk-Leitung (EtherCAT)","in Modul",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[{"$nulls":6},{"$f":"SUM(G7:G18)","v":0},{"$nulls":4},{"$f":"SUM(L7:L18)","v":0},{"$f":"SUM(M7:M18)","v":0},null,{"$f":"SUM(O7:O18)","v":0}]

{"sheet":"HK Serie","index":6,"n_rows":20,"n_cols":18,"rows_kept":20,"merged":[[4,2,4,3],[4,11,4,12],[4,14,4,15]]}
[]
[null,null,"Projekt:",{"$f":"'Info für VK Kalk'!D3","v":"<name>"}]
[{"$nulls":3},"(Titel nicht ändern. Nur ändern in Tabelle \"Info…\")"]
[]
[null,null,"Herstellkosten (HK) Serie",null,"INPUT IN YELLOW FIELDS",{"$nulls":6},"Abschätzung\n als %",null,null,"Abschätzung\nEURO"]
[null,null,"Herstellung","Beschreibung","Std","€ ek pro Std","€ ek gesamt\nMontage","€ ek gesamt\nHT & KT","€ Summe EK\n+ Montage",null,null,"Kaufteil","Hausteil",null,"Kaufteil","Hausteil",null,"chk sum"]
[null,1,"Gehäuse 1 Stück",null,0,{"$f":"$C$20","v":{"v":50,"d":"50.00 €"}},{"$f":"F7*E7","v":0},0,{"$f":"H7+G7","v":0},null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"I7*L7","v":0},{"$f":"I7*M7","v":0},null,{"$f":"O7+P7","v":0}]
[null,2,"Montage 1 Stück",null,0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"I8*L8","v":0},{"$f":"I8*M8","v":0},null,{"$f":"O8+P8","v":0}]
[null,3,"IBN und Prüfung 1 Stück",null,0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,4,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,5,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,6,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,7,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,8,"-","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,9,"Beschaffung","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,10,"Kommissionieren","-",0,{"v":50,"d":"50.00 €"},0,0,0,null,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"I16*L16","v":0},{"$f":"I16*M16","v":0},null,{"$f":"O16+P16","v":0}]
[null,null,"Summe Kosten (EK)",null,{"$f":"SUM(E7:E16)","v":0},null,{"$f":"SUM(G7:G16)","v":0},{"$f":"SUM(H7:H16)","v":0},{"$f":"SUM(I7:I16)","v":0},{"$nulls":5},{"$f":"SUM(O7:O16)","v":0},{"$f":"SUM(P7:P16)","v":0},null,{"$f":"SUM(R7:R16)","v":0}]
[]
[{"$nulls":14},"\"Blau\" Info für VK Kalk tab \"Info für VK Kalk\""]
[null,null,{"v":50,"d":"50.00 €"},"Stundensatz"]

{"sheet":"Materialkosten Serie","index":7,"n_rows":19,"n_cols":15,"rows_kept":19,"merged":[[4,2,4,3],[4,8,4,9],[4,11,4,12]]}
[]
[]
[null,null,"Projekt:",{"$f":"'Info für VK Kalk'!D3","v":"<name>"}]
[{"$nulls":3},"(Titel nicht ändern. Nur ändern in Tabelle \"Info…\")"]
[null,null,"Materialkosten Serie",null,"INPUT IN YELLOW FIELDS",{"$nulls":3},"Abschätzung\n als %",null,null,"Abschätzung\nEURO"]
[null,null,"Bezeichnung / Teil / Material","Typ","Anzahl","Stückkosten","Gesamtkosten",null,"Kaufteil","Hausteil",null,"Kaufteil","Hausteil",null,"chk sum"]
[null,null,"Gehäuse","Alu",0,0,{"$f":"E7*F7","v":0},null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"G7*I7","v":0},{"$f":"G7*J7","v":0},null,{"$f":"L7+M7","v":0}]
[null,null,"Klemmen (Seheiben), Relais","Beckhoff, Finder",0,0,{"$f":"E8*F8","v":0},null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"G8*I8","v":0},{"$f":"G8*J8","v":0},null,{"$f":"L8+M8","v":0}]
[null,null,"Stecker","Sub-D, Einbau, Signale, Failsafe",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"Sicherung","Thermo-Sicherung",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"Kabel/Leitungen/Klemmen/Druchführungen","diverses Material für Montage",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"Typenschild","Typenschild",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"IF88","für DocuTrim 8/8",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[{"$nulls":6},{"$f":"SUM(G7:G18)","v":0},{"$nulls":4},{"$f":"SUM(L7:L16)","v":0},{"$f":"SUM(M7:M16)","v":0},null,{"$f":"SUM(O7:O18)","v":0}]

{"sheet":"Zusatzkosten Serie","index":8,"n_rows":23,"n_cols":15,"rows_kept":23,"merged":[[6,2,6,3],[6,8,6,9],[6,11,6,12]]}
[]
[]
[null,null,"Projekt:",{"$f":"'Info für VK Kalk'!D3","v":"<name>"}]
[{"$nulls":3},"(Titel nicht ändern. Nur ändern in Tabelle \"Info…\")"]
[]
[]
[null,null,"Zusatzkosten Serie",{"$nulls":5},"Abschätzung\n als %",null,null,"Abschätzung\nEURO"]
[null,null,"Bezeichnung / Teil / Material","Typ","Anzahl","Stückkosten","Gesamtkosten",null,"Kaufteil","Hausteil",null,"Kaufteil","Hausteil",null,"chk sum"]
[null,null,"-","-",0,0,{"$f":"E9*F9","v":0},null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,{"$f":"L9+M9","v":0}]
[null,null,"-","-",0,0,{"$f":"E10*F10","v":0},null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,{"$f":"G10*I10","v":0},{"$f":"G10*J10","v":0},null,{"$f":"L10+M10","v":0}]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,{"$f":"E18*F18","v":0},null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-","-",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[null,null,"-"," ",0,0,0,null,{"v":0,"d":"0.0%"},{"v":1,"d":"100.0%"},null,0,0,null,0]
[{"$nulls":6},{"$f":"SUM(G9:G20)","v":0},{"$nulls":4},{"$f":"SUM(L9:L18)","v":0},{"$f":"SUM(M9:M18)","v":0},null,{"$f":"SUM(O9:O20)","v":0}]
[]
[null,null,"Begündungen, warum sich in Serie noch Änderungen ergeben (haben):"]

{"sheet":"Änderungshistorie Kalkulation","index":9,"n_rows":5,"n_cols":5,"rows_kept":5,"merged":[[2,1,2,4]]}
[]
[]
[null,"KALKULATIONS- Historie"]
[null,"Datum","Name","Änderung / Beschreibung / Erklärung","Version"]
[null,"2022-04-01","GRZ","heute hier, morgen dort","V0"]

{"sheet":"Änderungshistorie Template","index":10,"n_rows":8,"n_cols":5,"rows_kept":8,"merged":[[2,1,2,4]]}
[]
[]
[null,"TEMPLATE- Historie"]
[null,"Datum","Name","Änderung / Beschreibung / Erklärung","Version"]
[null,"2021-09-09","DCA","Erstellung\nOriginal von Entwicklung zu-geordnet und dargestellt","1.0"]
[null,"2022-04-20","GRZ","Überarbeitung im Zuge der Kalkulation zusätzliche Schnittstelle 3rd Party in DocuTrim","2.0"]
[null,"2022-04-21","GRZ","Ergänzung der Prämissen auf Tabellenblatt \"Info….\".","3.0"]
[null,"2022-04-27","GRZ","überarbeitet und Summen-Fehler eliminiert.\nZus. Spalten für Texte für Angebote ergänzt.","4.0"]