{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Zusammenfassung","Materialkosten","Fertigungskosten","Werkzeugkosten","Summary","Material costs","Manufacturing costs","Tool costs"],"not_rendered":{"images":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Zusammenfassung","index":0,"n_rows":99,"n_cols":13,"rows_kept":99,"merged":[[5,4,5,6],[5,10,5,12],[6,4,6,6],[6,10,6,12],[7,4,7,6],[7,10,7,12],[8,4,8,6],[8,10,8,12],[9,4,9,6],[9,10,9,12],[10,4,10,6],[10,10,10,12],[11,4,11,6],[11,10,11,12],[12,4,12,6],[12,10,12,12],[100,1,104,12]]}
[null,"COST-BREAK-DOWN"]
[]
[null,"Anhang 4 - CLA Phase 3 / Version 1.1 / 10.01.2023 / ",{"$nulls":6},"beschreibbare Zellen"]
[]
[null,"ANGEBOTSDATEN"]
[null,"Projekt-/Vorgangs-Nr.",{"$nulls":5},"Lieferant"]
[null,"Anfragedatum",{"$nulls":5},"Produktionsstandort"]
[null,"Teilebenennung",{"$nulls":5},"DUNS-Nummer"]
[null,"Teilenummer (Handtmann / OEM)",{"$nulls":5},"Ansprechpartner Lieferant"]
[null,"Zeichnungsnummer / Stand",{"$nulls":5},"E-Mail"]
[null,"3D-Daten-Stand",{"$nulls":5},"Telefon"]
[null,"Liste Besonderer Merkmale vom",{"$nulls":5},"Angebotsstand"]
[null,"Lastenheft vom",{"$nulls":5},"Angebotsgültigkeit"]
[]
[null,"STÜCKZAHLKONZEPT"]
[]
[{"$nulls":4},"Jahr 1","Jahr 2","Jahr 3","Jahr 4","Jahr 5","Jahr 6","Jahr 7","Jahr 8"]
[]
[null,"Angefragte Stückzahlen:",{"$nulls":10},"St. / Jahr"]
[]
[null,"Verfügbare Kapazität:",{"$nulls":10},"St. / Jahr"]
[{"$nulls":12},"St. / Tag"]
[]
[null,"Losgröße ",null,null,"Arbeitstage pro Jahr ",null,null,"Arbeitstage pro Woche ",null,null,"Schichten pro Woche "]
[]
[null,"STÜCKPREIS",{"$nulls":5},"%",null,"EUR","% von SK"]
[]
[{"$nulls":3},"Rohmaterialkosten",{"$nulls":5},{"$f":"Materialkosten!M12","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Flexibler Rohmaterialanteil",{"$nulls":5},{"$f":"Materialkosten!T23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Kaufteilkosten",{"$nulls":5},{"$f":"Materialkosten!M37","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Ausschusskosten",{"$nulls":5},{"$f":"Materialkosten!O12+Materialkosten!O37","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Logistikkosten Kaufteile",{"$nulls":5},{"$f":"Materialkosten!P12+Materialkosten!P37","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Materialgemeinkosten",{"$nulls":3},{"$f":"J38/(J28+J32+J34+J36)","v":{"$error":"#DIV/0!"}},null,{"$f":"Materialkosten!R12+Materialkosten!R37","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"MATERIALKOSTEN",{"$nulls":5},{"$f":"J28+J30+J32+J38+J34+J36","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J40/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J41/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Maschinenkosten",{"$nulls":5},{"$f":"Fertigungskosten!G17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Arbeitskosten",{"$nulls":5},{"$f":"Fertigungskosten!J17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Ausschusskosten",{"$nulls":5},{"$f":"Fertigungskosten!N17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Rüstkosten",{"$nulls":5},{"$f":"Fertigungskosten!O17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Restfertigungsgemeinkosten",{"$nulls":3},{"$f":"Fertigungskosten!R17/Fertigungskosten!P17","v":{"$error":"#DIV/0!"}},null,{"$f":"Fertigungskosten!Q17+Fertigungskosten!R17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":10},{"$f":"IFERROR(J51/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"FERTIGUNGSKOSTEN",{"$nulls":5},{"$f":"J42+J44+J46+J48+J50","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J52/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J53/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J54/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"HERSTELLKOSTEN",{"$nulls":5},{"$f":"J40+J52","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J55/$J$78,0)","v":{"v":0,"d":"0%"}}]
[]
[{"$nulls":3},"Werkzeugumlage",{"$nulls":5},{"$f":"Werkzeugkosten!Q18","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Sonstige Umlagen (-> Bemerkung)"]
[{"$nulls":10},{"$f":"IFERROR(J60/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"UMLAGEN",{"$nulls":5},{"$f":"J57+J59","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J61/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J62/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Verwaltungsgemeinkosten auf MK",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H63*J40","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Verwaltungsgemeinkosten auf FK",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H65*J52","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Vertriebsgemeinkosten auf MK",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H67*J40","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Vertriebsgemeinkosten auf FK",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H69*J52","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Gewinn auf MK",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H71*J40","v":{"v":0,"d":"0.00"}}]
[{"$nulls":10},{"$f":"IFERROR(J72/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Gewinn auf FK",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H73*J52","v":{"v":0,"d":"0.00"}}]
[{"$nulls":10},{"$f":"IFERROR(J74/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"KOSTEN OVERHEAD",{"$nulls":5},{"$f":"J63+J65+J67+J69+J71+J73","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J75/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J76/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J77/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"SELBSTKOSTEN",{"$nulls":5},{"$f":"J55+J61+J75","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J78/$J$78,0)","v":{"v":0,"d":"0%"}}]
[]
[{"$nulls":3},"Transport"]
[]
[{"$nulls":3},"Zoll"]
[]
[{"$nulls":3},"Verpackung"]
[]
[{"$nulls":3},"LOGISTIKKOSTEN",{"$nulls":5},{"$f":"J80+J82+J84","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":3},"ANGEBOTSPREIS",{"$nulls":5},{"$f":"J78+J86","v":{"v":0,"d":"0.00"}}]
[]
[null,"EINMALKOSTEN",{"$nulls":7},"EUR"]
[]
[{"$nulls":3},"Werkzeuge",{"$nulls":5},{"$f":"Werkzeugkosten!Q33","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Sonstige Kosten"]
[]
[{"$nulls":3},"EINMALZAHLUNGEN",{"$nulls":5},{"$f":"J93+J95","v":{"v":0,"d":"0.00"}}]
[]
[null,"BEMERKUNG",{"$nulls":7},"EUR"]

{"sheet":"Materialkosten","index":1,"n_rows":38,"n_cols":20,"rows_kept":38,"merged":[[4,10,4,11],[4,13,4,14],[4,16,4,17],[14,13,14,14],[14,16,14,17],[24,13,24,14],[24,16,24,17]]}
[null,"MATERIALKOSTEN"]
[]
[{"$nulls":11},"beschreibbare Zellen"]
[]
[null,"ROHMATERIAL",{"$nulls":4},"Mengeneinheit","Preis",null,null,"Rückvergütung",null,"MEK","Ausschuss",null,"Vorlogistik","MGK",null,null,"Material-"]
[null,null,"Bezeichnung","Handelsname","Lieferant","Bezugsland","(ME)","[EUR/ME]","Einsatzmenge","Fertigmenge","[EUR/ME]","[EUR/St.]","[EUR/St.]","[%]","[EUR/St.]","[EUR/St.]","[%]","[EUR/St.]",null,"kosten"]
[null,"R1",{"$nulls":9},{"$f":"(I7-J7)*K7","v":{"v":0,"d":"0.00"}},{"$f":"H7*I7-L7","v":{"v":0,"d":"0.00"}},null,{"$f":"M7*(1/(1-N7)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q7*(H7*I7+P7+O7)","v":{"v":0,"d":"0.00"}},null,{"$f":"M7+O7+P7+R7","v":{"v":0,"d":"0.00"}}]
[null,"R2",{"$nulls":9},{"$f":"(I8-J8)*K8","v":{"v":0,"d":"0.00"}},{"$f":"H8*I8-L8","v":{"v":0,"d":"0.00"}},null,{"$f":"M8*(1/(1-N8)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q8*(H8*I8+P8+O8)","v":{"v":0,"d":"0.00"}},null,{"$f":"M8+O8+P8+R8","v":{"v":0,"d":"0.00"}}]
[null,"R3",{"$nulls":9},{"$f":"(I9-J9)*K9","v":{"v":0,"d":"0.00"}},{"$f":"H9*I9-L9","v":{"v":0,"d":"0.00"}},null,{"$f":"M9*(1/(1-N9)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q9*(H9*I9+P9+O9)","v":{"v":0,"d":"0.00"}},null,{"$f":"M9+O9+P9+R9","v":{"v":0,"d":"0.00"}}]
[null,"R4",{"$nulls":9},{"$f":"(I10-J10)*K10","v":{"v":0,"d":"0.00"}},{"$f":"H10*I10-L10","v":{"v":0,"d":"0.00"}},null,{"$f":"M10*(1/(1-N10)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q10*(H10*I10+P10+O10)","v":{"v":0,"d":"0.00"}},null,{"$f":"M10+O10+P10+R10","v":{"v":0,"d":"0.00"}}]
[null,"R5",{"$nulls":9},{"$f":"(I11-J11)*K11","v":{"v":0,"d":"0.00"}},{"$f":"H11*I11-L11","v":{"v":0,"d":"0.00"}},null,{"$f":"M11*(1/(1-N11)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q11*(H11*I11+P11+O11)","v":{"v":0,"d":"0.00"}},null,{"$f":"M11+O11+P11+R11","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"SUM(M7:M11)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(O7:O11)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":17},"Summe",null,{"$f":"SUM(T7:T11)","v":{"v":0,"d":"0.00"}}]
[]
[null,"PREISGLEITKLAUSEL",{"$nulls":3},"Mengeneinheit","Kurs/Notierung",{"$nulls":12},"Material-"]
[null,null,"Bezeichnung","Bezeichnung 2","Quelle","(ME)","[EUR/ME]","Bezugsmenge",{"$nulls":11},"kosten"]
[null,"P1",{"$nulls":17},{"$f":"G17*H17","v":{"v":0,"d":"0.00"}}]
[null,"P2",{"$nulls":17},{"$f":"G18*H18","v":{"v":0,"d":"0.00"}}]
[null,"P3",{"$nulls":17},{"$f":"G19*H19","v":{"v":0,"d":"0.00"}}]
[null,"P4",{"$nulls":17},{"$f":"G20*H20","v":{"v":0,"d":"0.00"}}]
[null,"P5",{"$nulls":17},{"$f":"G21*H21","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":17},"Summe",null,{"$f":"SUM(T17:T21)","v":{"v":0,"d":"0.00"}}]
[]
[null,"KAUFTEILE",{"$nulls":4},"Anzahl pro","Preis",{"$nulls":4},"MEK","Ausschuss",null,"Vorlogistik","MGK",null,null,"Material-"]
[null,null,"Bezeichnung","Teilenummer","Lieferant","Bezugsland","Zusammenbau","[EUR/St.]",{"$nulls":4},"[EUR/ZSB]","[%]","[EUR/St.]","[EUR/St.]","[%]","[EUR/St.]",null,"kosten"]
[null,"K1",{"$nulls":10},{"$f":"G27*H27","v":{"v":0,"d":"0.00"}},null,{"$f":"M27*(1/(1-N27)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q27*(M27+P27+O27)","v":{"v":0,"d":"0.00"}},null,{"$f":"M27+O27+P27+R27","v":{"v":0,"d":"0.00"}}]
[null,"K2",{"$nulls":10},{"$f":"G28*H28","v":{"v":0,"d":"0.00"}},null,{"$f":"M28*(1/(1-N28)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q28*(M28+P28+O28)","v":{"v":0,"d":"0.00"}},null,{"$f":"M28+O28+P28+R28","v":{"v":0,"d":"0.00"}}]
[null,"K3",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K4",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K5",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K6",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K7",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K8",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K9",{"$nulls":10},{"v":0,"d":"0.00"},null,{"$f":"M35*(1/(1-N35)-1)","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"},null,{"$f":"M35+O35+P35+R35","v":{"v":0,"d":"0.00"}}]
[null,"K10",{"$nulls":10},{"v":0,"d":"0.00"},null,{"$f":"M36*(1/(1-N36)-1)","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"},null,{"$f":"M36+O36+P36+R36","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"SUM(M27:M36)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(O27:O36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(P27:P36)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(R27:R36)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":17},"Summe",null,{"$f":"SUM(T27:T36)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Fertigungskosten","index":2,"n_rows":18,"n_cols":20,"rows_kept":18,"merged":[[4,12,4,13],[4,16,4,17]]}
[null,"FERTIGUNGSKOSTEN"]
[]
[{"$nulls":13},"beschreibbare Zellen"]
[]
[null,"FERTIGUNG",null,null,"Investition +","Maschinenstundensatz","Maschinenkosten","Arbeitskosten","Mitarbeiter","Arbeitskosten","Taktzeit","Teile","Ausschuss",null,"Rüstkosten","FEK","Rest-FGK",null,null,"Fertigungs-"]
[null,null,"Fertigungsschritt","Maschinentyp","Installation","[EUR/h]","[EUR/St.]","[EUR/h]","[Anzahl]","[EUR/St.]","[sec.]","[pro Takt]","[%]","[EUR/St.]","[EUR/St.]","[EUR/St.]","[%]","[EUR/St.]",null,"kosten"]
[null,"F1",{"$nulls":4},{"$f":"IFERROR(F7*K7/3600/L7,0)","v":0},null,null,{"$f":"IFERROR(H7*I7*K7/3600/L7,0)","v":0},{"$nulls":3},{"$f":"IFERROR((F7+H7*I7)*K7/3600/L7*(1/(1-M7)-1),0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR((F7+H7*I7)*K7/3600/L7+N7+O7,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"P7*Q7","v":{"v":0,"d":"0.00"}},null,{"$f":"P7+R7","v":{"v":0,"d":"0.00"}}]
[null,"F2",{"$nulls":4},0,null,null,0,{"$nulls":3},{"$f":"IFERROR((F8+H8*I8)*K8/3600/L8*(1/(1-M8)-1),0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR((F8+H8*I8)*K8/3600/L8+N8+O8,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"P8*Q8","v":{"v":0,"d":"0.00"}},null,{"$f":"P8+R8","v":{"v":0,"d":"0.00"}}]
[null,"F3",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F4",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F5",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F6",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F7",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F8",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F9",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F10",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"$f":"SUM(G7:G16)","v":0},null,null,{"$f":"SUM(J7:J16)","v":0},{"$nulls":3},{"$f":"SUM(N7:N16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(O7:O16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(P7:P16)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(R7:R16)","v":{"v":0,"d":"0.00"}},null,0]
[{"$nulls":17},"Summe",null,{"$f":"SUM(T7:T16)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Werkzeugkosten","index":3,"n_rows":33,"n_cols":17,"rows_kept":33}
[null,"WERKZEUGKOSTEN"]
[]
[{"$nulls":11},"beschreibbare Zellen"]
[]
[null,"WERKZEUGUMLAGE",{"$nulls":3},"Werkzeugauslegung","Maschinenkosten","Werkzeug-","Herstellzeit","Arbeitskosten",null,"Kapazität","Werkzeugkosten","Umlagebasis","Umlagezeitraum",null,"Umlage"]
[null,null,"Werkzeugart","Bauteilbenennung","Anzahl","[x-fach, Kavitäten]","[EUR/St.]","standzeit [St.]","[Wochen]","[EUR/St.]","Herstellland","[St. pro Jahr]","[EUR]","[St.]","[Monate]",null,"pro Stück"]
[null,"U1",{"$nulls":14},{"$f":"IFERROR(E7*M7/N7,0)","v":{"v":0,"d":"0.00"}}]
[null,"U2",{"$nulls":14},{"$f":"IFERROR(E8*M8/N8,0)","v":{"v":0,"d":"0.00"}}]
[null,"U3",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U4",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U5",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U6",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U7",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U8",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U9",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U10",{"$nulls":14},{"v":0,"d":"0.00"}]
[]
[{"$nulls":14},"Summe",null,{"$f":"SUM(Q7:Q16)","v":{"v":0,"d":"0.00"}}]
[]
[null,"WERKZEUGE EINMALKOSTEN",{"$nulls":3},"Werkzeugauslegung","Maschinenkosten","Werkzeug-","Herstellzeit","Arbeitskosten",null,"Kapazität","Werkzeugkosten",{"$nulls":3},"Werkzeug-"]
[null,null,"Werkzeugart","Bauteilbenennung","Anzahl","[x-fach, Kavitäten]","[EUR/St.]","standzeit [St.]","[Wochen]","[EUR/St.]","Herstellland","[St. pro Jahr]","[EUR]",{"$nulls":3},"kosten"]
[null,"W1",{"$nulls":14},{"$f":"E22*M22","v":{"v":0,"d":"0.00"}}]
[null,"W2",{"$nulls":14},{"$f":"E23*M23","v":{"v":0,"d":"0.00"}}]
[null,"W3",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W4",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W5",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W6",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W7",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W8",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W9",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W10",{"$nulls":14},{"v":0,"d":"0.00"}]
[]
[{"$nulls":14},"Summe",null,{"$f":"SUM(Q22:Q31)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Summary","index":4,"n_rows":99,"n_cols":13,"rows_kept":99,"merged":[[5,4,5,6],[5,10,5,12],[6,4,6,6],[6,10,6,12],[7,4,7,6],[7,10,7,12],[8,4,8,6],[8,10,8,12],[9,4,9,6],[9,10,9,12],[10,4,10,6],[10,10,10,12],[11,4,11,6],[11,10,11,12],[12,4,12,6],[12,10,12,12],[100,1,104,12]]}
[null,"COST-BREAK-DOWN"]
[]
[null,"Version 1.0 / 30.03.2021 / MJ",{"$nulls":6},"writable cells"]
[]
[null,"OFFER DETAILS"]
[null,"Project-/process-number",{"$nulls":5},"Supplier"]
[null,"Request date",{"$nulls":5},"Production location"]
[null,"Component name",{"$nulls":5},"DUNS-number"]
[null,"Component number (Handtmann / OEM)",{"$nulls":5},"Contact person supplier"]
[null,"Drawing number / status",{"$nulls":5},"Email"]
[null,"3D-data-status",{"$nulls":5},"Phone"]
[null,"List special properties of",{"$nulls":5},"Offer status"]
[null,"Specification sheet of",{"$nulls":5},"Ofer validity"]
[]
[null,"QUANTITY CONCEPTION"]
[]
[{"$nulls":4},"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8"]
[]
[null,"Inquired quantity:",{"$nulls":10},"Pieces / year"]
[]
[null,"Available capacity",{"$nulls":10},"Pieces / year"]
[{"$nulls":12},"Pieces / day"]
[]
[null,"Batch size",null,null,"Work days per year",null,null,"Work days per week",null,null,"Shifts per week"]
[]
[null,"UNIT PRICE",{"$nulls":5},"%",null,"EUR","% von SK"]
[]
[{"$nulls":3},"Raw material costs",{"$nulls":5},{"$f":"'Material costs'!M12","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Flexible raw material proportion",{"$nulls":5},{"$f":"'Material costs'!T23","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Purchased part costs",{"$nulls":5},{"$f":"'Material costs'!M37","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Reject costs",{"$nulls":5},{"$f":"'Material costs'!O12+'Material costs'!O37","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Logistics costs purchased parts",{"$nulls":5},{"$f":"'Material costs'!P12+'Material costs'!P37","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Material overheads",{"$nulls":3},{"$f":"J38/(J28+J32+J34+J36)","v":{"$error":"#DIV/0!"}},null,{"$f":"'Material costs'!R12+'Material costs'!R37","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"MATERIAL COSTS",{"$nulls":5},{"$f":"J28+J30+J32+J38+J34+J36","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J40/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J41/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Machine costs",{"$nulls":5},{"$f":"'Manufacturing costs'!G17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Labour costs",{"$nulls":5},{"$f":"'Manufacturing costs'!J17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Reject costs",{"$nulls":5},{"$f":"'Manufacturing costs'!N17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Setup costs",{"$nulls":5},{"$f":"'Manufacturing costs'!O17","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Remaining manufacturing overheads",{"$nulls":3},{"$f":"'Manufacturing costs'!R17/'Manufacturing costs'!P17","v":{"$error":"#DIV/0!"}},null,{"$f":"'Manufacturing costs'!Q17+'Manufacturing costs'!R17","v":{"v":0,"d":"0.00"}}]
[{"$nulls":10},{"$f":"IFERROR(J51/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"MANUFACTURING OVERHEADS",{"$nulls":5},{"$f":"J42+J44+J46+J48+J50","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J52/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J53/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J54/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"PRODUCTION COSTS",{"$nulls":5},{"$f":"J40+J52","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J55/$J$78,0)","v":{"v":0,"d":"0%"}}]
[]
[{"$nulls":3},"Tools apportionment",{"$nulls":5},{"$f":"'Tool costs'!Q18","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Other apportionments (-> note)"]
[{"$nulls":10},{"$f":"IFERROR(J60/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"APPORTIONMENT",{"$nulls":5},{"$f":"J57+J59","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J61/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J62/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Administrative overheads on material costs",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H63*J40","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Administrative overheads on manufacturing costs",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H65*J52","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Sales overheads on material costs",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H67*J40","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Sales overheads on manufacturing costs",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H69*J52","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Profit on material costs",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H71*J40","v":{"v":0,"d":"0.00"}}]
[{"$nulls":10},{"$f":"IFERROR(J72/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"Profit on manufacturing costs",{"$nulls":3},{"v":0,"d":"0.0%"},null,{"$f":"H73*J52","v":{"v":0,"d":"0.00"}}]
[{"$nulls":10},{"$f":"IFERROR(J74/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"OVERHEAD COSTS",{"$nulls":5},{"$f":"J63+J65+J67+J69+J71+J73","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J75/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J76/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":10},{"$f":"IFERROR(J77/$J$78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"PRIME COSTS",{"$nulls":5},{"$f":"J55+J61+J75","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(J78/$J$78,0)","v":{"v":0,"d":"0%"}}]
[]
[{"$nulls":3},"Transport"]
[]
[{"$nulls":3},"Duty"]
[]
[{"$nulls":3},"Package"]
[]
[{"$nulls":3},"LOGISTICS COSTS",{"$nulls":5},{"$f":"J80+J82+J84","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":3},"OFFER PRICE",{"$nulls":5},{"$f":"J78+J86","v":{"v":0,"d":"0.00"}}]
[]
[null,"One-time costs",{"$nulls":7},"EUR"]
[]
[{"$nulls":3},"Tools",{"$nulls":5},{"$f":"'Tool costs'!Q33","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Other costs"]
[]
[{"$nulls":3},"ONE-TIME PAYMENT",{"$nulls":5},{"$f":"J93+J95","v":{"v":0,"d":"0.00"}}]
[]
[null,"COMMENTS",{"$nulls":7},"EUR"]

{"sheet":"Material costs","index":5,"n_rows":38,"n_cols":20,"rows_kept":38,"merged":[[4,5,5,5],[4,8,5,8],[4,9,5,9],[4,10,4,11],[4,13,4,14],[4,16,4,17],[14,7,15,7],[14,13,14,14],[14,16,14,17],[24,5,25,5],[24,13,24,14],[24,16,24,17]]}
[null,"MATERIAL COSTS"]
[]
[{"$nulls":11},"Writable cells"]
[]
[null,"RAW MATERIAL",{"$nulls":3},"Reference country","Quantity unit","Price","Application quantity","Production quantity","Reimbursement",null,"MEK","Reject",null,"Pre logistics","MGK",null,null,"Material-"]
[null,null,"Name","Trade name","Supplier",null,"(ME)","[EUR/ME]",null,null,"[EUR/ME]","[EUR/St.]","[EUR/St.]","[%]","[EUR/St.]","[EUR/St.]","[%]","[EUR/St.]",null,"costs"]
[null,"R1",{"$nulls":9},{"$f":"(I7-J7)*K7","v":{"v":0,"d":"0.00"}},{"$f":"H7*I7-L7","v":{"v":0,"d":"0.00"}},null,{"$f":"M7*(1/(1-N7)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q7*(H7*I7+P7+O7)","v":{"v":0,"d":"0.00"}},null,{"$f":"M7+O7+P7+R7","v":{"v":0,"d":"0.00"}}]
[null,"R2",{"$nulls":9},{"$f":"(I8-J8)*K8","v":{"v":0,"d":"0.00"}},{"$f":"H8*I8-L8","v":{"v":0,"d":"0.00"}},null,{"$f":"M8*(1/(1-N8)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q8*(H8*I8+P8+O8)","v":{"v":0,"d":"0.00"}},null,{"$f":"M8+O8+P8+R8","v":{"v":0,"d":"0.00"}}]
[null,"R3",{"$nulls":9},{"$f":"(I9-J9)*K9","v":{"v":0,"d":"0.00"}},{"$f":"H9*I9-L9","v":{"v":0,"d":"0.00"}},null,{"$f":"M9*(1/(1-N9)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q9*(H9*I9+P9+O9)","v":{"v":0,"d":"0.00"}},null,{"$f":"M9+O9+P9+R9","v":{"v":0,"d":"0.00"}}]
[null,"R4",{"$nulls":9},{"$f":"(I10-J10)*K10","v":{"v":0,"d":"0.00"}},{"$f":"H10*I10-L10","v":{"v":0,"d":"0.00"}},null,{"$f":"M10*(1/(1-N10)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q10*(H10*I10+P10+O10)","v":{"v":0,"d":"0.00"}},null,{"$f":"M10+O10+P10+R10","v":{"v":0,"d":"0.00"}}]
[null,"R5",{"$nulls":9},{"$f":"(I11-J11)*K11","v":{"v":0,"d":"0.00"}},{"$f":"H11*I11-L11","v":{"v":0,"d":"0.00"}},null,{"$f":"M11*(1/(1-N11)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q11*(H11*I11+P11+O11)","v":{"v":0,"d":"0.00"}},null,{"$f":"M11+O11+P11+R11","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"SUM(M7:M11)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(O7:O11)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":17},"Total",null,{"$f":"SUM(T7:T11)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Price adjustment clause",{"$nulls":3},"Quantity unit","Rate/ notation","Reference  quantity",{"$nulls":11},"Material-"]
[null,null,"Name ","Name 2","Source","(ME)","[EUR/ME]",{"$nulls":12},"costs"]
[null,"P1",{"$nulls":17},{"$f":"G17*H17","v":{"v":0,"d":"0.00"}}]
[null,"P2",{"$nulls":17},{"$f":"G18*H18","v":{"v":0,"d":"0.00"}}]
[null,"P3",{"$nulls":17},{"$f":"G19*H19","v":{"v":0,"d":"0.00"}}]
[null,"P4",{"$nulls":17},{"$f":"G20*H20","v":{"v":0,"d":"0.00"}}]
[null,"P5",{"$nulls":17},{"$f":"G21*H21","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":17},"Total",null,{"$f":"SUM(T17:T21)","v":{"v":0,"d":"0.00"}}]
[]
[null,"PURCHASED PARTS",{"$nulls":3},"Reference country","Quantity per","Price",{"$nulls":4},"MEK","Reject",null,"Pre logistics","MGK",null,null,"Material-"]
[null,null,"Name","Part number","Supplier",null,"assembly","[EUR/St.]",{"$nulls":4},"[EUR/ZSB]","[%]","[EUR/St.]","[EUR/St.]","[%]","[EUR/St.]",null,"costs"]
[null,"K1",{"$nulls":10},{"$f":"G27*H27","v":{"v":0,"d":"0.00"}},null,{"$f":"M27*(1/(1-N27)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q27*(M27+P27+O27)","v":{"v":0,"d":"0.00"}},null,{"$f":"M27+O27+P27+R27","v":{"v":0,"d":"0.00"}}]
[null,"K2",{"$nulls":10},{"$f":"G28*H28","v":{"v":0,"d":"0.00"}},null,{"$f":"M28*(1/(1-N28)-1)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"Q28*(M28+P28+O28)","v":{"v":0,"d":"0.00"}},null,{"$f":"M28+O28+P28+R28","v":{"v":0,"d":"0.00"}}]
[null,"K3",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K4",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K5",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K6",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K7",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K8",{"$nulls":10},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"K9",{"$nulls":10},{"v":0,"d":"0.00"},null,{"$f":"M35*(1/(1-N35)-1)","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"},null,{"$f":"M35+O35+P35+R35","v":{"v":0,"d":"0.00"}}]
[null,"K10",{"$nulls":10},{"v":0,"d":"0.00"},null,{"$f":"M36*(1/(1-N36)-1)","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"},null,{"$f":"M36+O36+P36+R36","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"SUM(M27:M36)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(O27:O36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(P27:P36)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(R27:R36)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":17},"Total",null,{"$f":"SUM(T27:T36)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Manufacturing costs","index":6,"n_rows":18,"n_cols":20,"rows_kept":18,"merged":[[4,12,4,13],[4,16,4,17]]}
[null,"MANUFACTURING COSTS"]
[]
[{"$nulls":13},"Writable cells"]
[]
[null,"MANUFACTURING",null,null,"Investment +","Machine hourly wage","Maschinenkosten","Labour costs","Employees","Arbeitskosten","Cycle time","Pieces","Reject",null,"Setup costs","FEK","Remaining-FGK",null,null,"Manufacturing-"]
[null,null,"Manufacturing step","Machine type","installation","[EUR/h]","[EUR/St.]","[EUR/h]","[number]","[EUR/St.]","[sec.]","[per cycle]","[%]","[EUR/St.]","[EUR/St.]","[EUR/St.]","[%]","[EUR/St.]",null,"costs"]
[null,"F1",{"$nulls":4},{"$f":"IFERROR(F7*K7/3600/L7,0)","v":0},null,null,{"$f":"IFERROR(H7*I7*K7/3600/L7,0)","v":0},{"$nulls":3},{"$f":"IFERROR((F7+H7*I7)*K7/3600/L7*(1/(1-M7)-1),0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR((F7+H7*I7)*K7/3600/L7+N7+O7,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"P7*Q7","v":{"v":0,"d":"0.00"}},null,{"$f":"P7+R7","v":{"v":0,"d":"0.00"}}]
[null,"F2",{"$nulls":4},0,null,null,0,{"$nulls":3},{"$f":"IFERROR((F8+H8*I8)*K8/3600/L8*(1/(1-M8)-1),0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IFERROR((F8+H8*I8)*K8/3600/L8+N8+O8,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"P8*Q8","v":{"v":0,"d":"0.00"}},null,{"$f":"P8+R8","v":{"v":0,"d":"0.00"}}]
[null,"F3",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F4",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F5",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F6",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F7",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F8",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F9",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,"F10",{"$nulls":4},0,null,null,0,{"$nulls":3},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[{"$nulls":6},{"$f":"SUM(G7:G16)","v":0},null,null,{"$f":"SUM(J7:J16)","v":0},{"$nulls":3},{"$f":"SUM(N7:N16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(O7:O16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(P7:P16)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(R7:R16)","v":{"v":0,"d":"0.00"}},null,0]
[{"$nulls":17},"Total",null,{"$f":"SUM(T7:T16)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Tool costs","index":7,"n_rows":33,"n_cols":17,"rows_kept":33,"merged":[[4,10,5,10],[19,10,20,10]]}
[null,"TOOL COSTS"]
[]
[{"$nulls":11},"Writable cells"]
[]
[null,"TOOLS APPORTIONMENT",{"$nulls":3},"Die design","Maschinenkosten","Tools-","Production time","Arbeitskosten","Production country","Capacity","Tools costs","Apportionment basis","Apportionment period",null,"Apportionment"]
[null,null,"Type of tools","Component name","Number","[umpteen times, cavities]","[EUR/St.]","lifetime [St.]","[weeks]","[EUR/St.]",null,"[St. per year]","[EUR]","[St.]","[months]",null,"per piece"]
[null,"U1",{"$nulls":14},{"$f":"IFERROR(E7*M7/N7,0)","v":{"v":0,"d":"0.00"}}]
[null,"U2",{"$nulls":14},{"$f":"IFERROR(E8*M8/N8,0)","v":{"v":0,"d":"0.00"}}]
[null,"U3",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U4",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U5",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U6",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U7",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U8",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U9",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"U10",{"$nulls":14},{"v":0,"d":"0.00"}]
[]
[{"$nulls":14},"Total",null,{"$f":"SUM(Q7:Q16)","v":{"v":0,"d":"0.00"}}]
[]
[null,"TOOLS ONE-TIME COSTS",{"$nulls":3},"Die design","Maschinenkosten","Tools-","Production time","Arbeitskosten","Production country","Capacity","Tools costs",{"$nulls":3},"Tools-"]
[null,null,"Type of tools","Component name","Number","[umpteen times, cavities]","[EUR/St.]","lifetime [St.]","[weeks]","[EUR/St.]",null,"[St. per year]","[EUR]",{"$nulls":3},"costs"]
[null,"W1",{"$nulls":14},{"$f":"E22*M22","v":{"v":0,"d":"0.00"}}]
[null,"W2",{"$nulls":14},{"$f":"E23*M23","v":{"v":0,"d":"0.00"}}]
[null,"W3",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W4",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W5",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W6",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W7",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W8",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W9",{"$nulls":14},{"v":0,"d":"0.00"}]
[null,"W10",{"$nulls":14},{"v":0,"d":"0.00"}]
[]
[{"$nulls":14},"Total",null,{"$f":"SUM(Q22:Q31)","v":{"v":0,"d":"0.00"}}]