{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Summary","SW Development Costs","Config","Performance Levels","overview place of provision"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":2,"defined_names":20,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,12,0,13],[6,3,6,6],[7,3,7,6],[15,3,15,6],[2,8,2,13],[10,3,10,7],[11,8,11,13],[10,9,10,13],[5,8,5,13],[3,3,3,8],[5,3,5,6],[12,11,12,12],[13,11,13,12],[6,8,6,13],[7,8,7,13],[8,8,8,13],[9,8,9,13],[16,3,19,6],[20,3,21,6],[8,3,8,6],[9,3,9,6],[13,3,13,6],[14,3,14,6],[12,3,12,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"INTERNAL\nCBD template version 2.0\nFB-1, 05/2024"]
[]
[null,null,null,null,null,null,null,null,"Note: \n- The supplier is required to independently fill in all the light green cells.\n- The purple cells are prefilled by CARIAD. The grey cells fill automatically.\n- In-house/subcontracting, Performance/Qualification Level, Place of provision and Country need to be selected via Dropdown list.\n-  Nearshore & Offshore requires the disclosure of country and city of provision. Also the subcontracted company (if any) needs to be listed. Add these info in column \"Details on the place of provision\""]
[null,null,null,"Project Cost Split Summary"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v"]
[null,null,null,"RFQ-No. CARIAD & Title"]
[null,null,null,"Supplier"]
[null,null,null,"DUNS-No. "]
[null,null,null,"Offer-No."]
[null,null,null,"Offer-Date"]
[null,null,null,"Offer currency",null,null,null,null,"EUR"]
[]
[null,null,null,"∑ dev. services + add. Expenses + travel Expenses",null,null,null,null,{"$f":"'SW Development Costs'!X109+'SW Development Costs'!X112","v":0}]
[null,null,null,"∑ dev. services",null,null,null,null,{"$f":"'SW Development Costs'!X98","v":0}]
[null,null,null,"∑ add. expenses",null,null,null,null,{"$f":"'SW Development Costs'!X101","v":0}]
[null,null,null,"∑ travel expenses",null,null,null,null,{"$f":"'SW Development Costs'!X112","v":0}]
[null,null,null,"Place of provision",null,null,null,"Onsite",{"$f":"'SW Development Costs'!AH98","v":0}]
[null,null,null,null,null,null,null,"Onshore",{"$f":"'SW Development Costs'!AK98","v":0}]
[null,null,null,null,null,null,null,"Nearshore",{"$f":"'SW Development Costs'!AN98","v":0}]
[null,null,null,null,null,null,null,"Offshore",{"$f":"'SW Development Costs'!AQ98","v":0}]
[null,null,null,"In-house/Subcontracting",null,null,null,"In-house",{"$f":"'SW Development Costs'!AB98","v":0}]
[null,null,null,null,null,null,null,"Subcontracting",{"$f":"'SW Development Costs'!AE98","v":0}]

{"sheet":"SW Development Costs","index":1,"n_rows":176,"n_cols":43,"rows_kept":176,"cut":false,"hidden":false,"merged":[[78,10,78,15],[79,4,79,8],[80,4,80,8],[83,4,83,8],[75,4,75,8],[76,4,76,8],[77,4,77,8],[56,4,56,8],[57,4,57,8],[84,4,84,8],[85,4,85,8],[86,4,86,8],[68,4,68,8],[0,3,0,15],[2,3,2,4],[7,4,7,8],[8,4,8,8],[11,4,11,8],[6,10,6,15],[12,4,12,8],[13,4,13,8],[14,4,14,8],[33,10,33,15],[87,10,87,15],[15,10,15,15],[32,4,32,8],[58,4,58,8],[59,4,59,8],[60,10,60,15],[34,4,34,8],[35,4,35,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[26,4,26,8],[112,3,112,15],[100,14,100,15],[101,14,101,15],[102,14,102,15],[103,14,103,15],[104,14,104,15],[105,14,105,15],[111,3,111,4],[105,11,105,13],[102,11,102,13],[103,11,103,13],[104,11,104,13],[101,11,101,13],[4,32,4,33],[4,38,4,39],[4,41,4,42],[4,26,4,27],[4,29,4,30],[4,35,4,36],[24,10,24,15],[89,4,89,8],[92,4,92,8],[93,4,93,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[88,4,88,8],[65,4,65,8],[66,4,66,8],[67,4,67,8],[61,4,61,8],[62,4,62,8],[51,10,51,15],[53,4,53,8],[16,4,16,8],[17,4,17,8],[20,4,20,8],[23,4,23,8],[25,4,25,8],[21,4,21,8],[22,4,22,8],[96,4,96,8],[100,11,100,13],[42,10,42,15],[43,4,43,8],[44,4,44,8],[47,4,47,8],[48,4,48,8],[49,4,49,8],[50,4,50,8],[69,10,69,15],[70,4,70,8],[71,4,71,8],[74,4,74,8],[94,4,94,8],[95,4,95,8],[52,4,52,8]]}
[null,null,null,"Cost Split - Software Development Costs"]
[]
[null,null,null,"Time of delivery in months:",null,null,null,null,"XXX",null,"Start date:","XXX",null,null,"End date:","XXX"]
[]
[null,null,null,null,"Work Package",null,"Effort estimation unit",null,"Amount of WP",null,"In-house / subcontracting","Performance/Qualification Level","Place of provision","Details on the place of provision","Estimated amount of hours","Hourly\nrate",null,"Price per SP","SP estimation per WP","Total number of SP for the contract lifetime",null,"Calculated costs  for an hourly-WP",null,"Total estimated WP costs on contract lifetime","Total estimated  WP hours on contract lifetime",null,"In-house",null,null,"Subcontracting",null,null,"Onsite",null,null,"Onshore",null,null,"Nearshore ",null,null,"Offshore"]
[null,null,null,null,"The below described WPs have to be  consistent with the Specification",null,"Story Points or hours",null,"planned for the contract lifetime",null," - no mixed calculation!\n - always list in-house contribution & planned subcontracting separately"," - no mixed price calculation! \n - always list price/location within the same qualification separately\n","Onsite: on CARIAD premises in Germany\nOnshore (Offsite): in Germany\nNearshore (Offsite): in EU \nOffshore (Offsite): outside EU"," Nearshore & Offshore requires the disclosure of country and city of provision\nIf Subcontracting is used, please list the subcontracted company","Information needed for shoring split \nand\ncalculation of the costs for those WPs estimated in hours",{"$f":"\"[\"&Summary!I11&\"]/h\"","v":"[EUR]/h"},null,{"$f":"\"[\"&Summary!I11&\"]\"","v":"[EUR]"},"consistent with the Specification","SP per WP\n*\nAmount of WP",null,"∑ of costs per qualification and place of provision",null,{"$f":"\"∑ of costs for both SP- and h- based WPs\n[\"&Summary!I11&\"]\"","v":"∑ of costs for both SP- and h- based WPs\n[EUR]"},"hours per WP\n* \nAmount of WP",null,"∑In-house hours per WP in total","%-share",null,"∑Subcontracting hours per WP in total","%-share ",null,"∑Onsite hours per WP in total","%-share",null,"∑Onshore hours per WP in total","%-share",null,"∑Nearshore hours per WP in total","%-share",null,"∑Offshore hours per WP in total","%-share "]
[null,null,null,"WP 1",null,null,null,null,2,null,"â  The supplier is required to independently fill in all the light green cells! â",null,null,null,null,null,null,null,null,{"$f":"I7*S7","v":0},null,{"$f":"IF(G7=\"h\",SUMPRODUCT(O8:O15,P8:P15),0)","v":0},null,{"$f":"IF(G7=\"h\",V7*I7,T7*R7)","v":0},{"$f":"(SUM(O8:O15))*I7","v":0},null,{"$f":"(SUMIF(K8:K15, \"In-house\",O8:O15))*I7","v":0},{"$f":"IFERROR(AA7/Y7,0)","v":0},null,{"$f":"( SUMIF(K8:K15, \"Subcontracting\",O8:O15))*I7","v":0},{"$f":"IFERROR(AD7/Y7,0)","v":0},null,{"$f":"(SUMIF(M8:M15, \"Onsite\",O8:O15))*I7","v":0},{"$f":"IFERROR(AG7/Y7,0)","v":0},null,{"$f":"(SUMIF(M8:M15, \"Onshore (Offsite)\",O8:O15))*I7","v":0},{"$f":"IFERROR(AJ7/Y7,0)","v":0},null,{"$f":"(SUMIF(M8:M15, \"Nearshore (Offsite)\",O8:O15))*I7","v":0},{"$f":"IFERROR(AM7/Y7,0)","v":0},null,{"$f":"(SUMIF(M8:M15, \"Offshore (Offsite)\",O8:O15))*I7","v":0},{"$f":"IFERROR(AP7/Y7,0)","v":0}]
[]
[]
[null,null,null,null,"Near-/Offshore percentage"]
[null,null,null,null,"according to specification:"]
[]
[]
[]
[]
[null,null,null,"WP 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I16*S16","v":0},null,{"$f":"IF(G16=\"h\",SUMPRODUCT(O17:O24,P17:P24),0)","v":0},null,{"$f":"IF(G16=\"h\",V16*I16,T16*R16)","v":0},{"$f":"(SUM(O17:O24))*I16","v":0},null,{"$f":"(SUMIF(K17:K24, \"In-house\",O17:O24))*I16","v":0},{"$f":"IFERROR(AA16/Y16,0)","v":0},null,{"$f":"( SUMIF(K17:K24, \"Subcontracting\",O17:O24))*I16","v":0},{"$f":"IFERROR(AD16/Y16,0)","v":0},null,{"$f":"(SUMIF(M17:M24, \"Onsite\",O17:O24))*I16","v":0},{"$f":"IFERROR(AG16/Y16,0)","v":0},null,{"$f":"(SUMIF(M17:M24, \"Onshore (Offsite)\",O17:O24))*I16","v":0},{"$f":"IFERROR(AJ16/Y16,0)","v":0},null,{"$f":"(SUMIF(M17:M24, \"Nearshore (Offsite)\",O17:O24))*I16","v":0},{"$f":"IFERROR(AM16/Y16,0)","v":0},null,{"$f":"(SUMIF(M17:M24, \"Offshore (Offsite)\",O17:O24))*I16","v":0},{"$f":"IFERROR(AP16/Y16,0)","v":0}]
[]
[]
[null,null,null,null,"Near-/Offshore percentage"]
[null,null,null,null,"according to specification:"]
[]
[]
[]
[]
[null,null,null,"WP 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I25*S25","v":0},null,{"$f":"IF(G25=\"h\",SUMPRODUCT(O26:O33,P26:P33),0)","v":0},null,{"$f":"IF(G25=\"h\",V25*I25,T25*R25)","v":0},{"$f":"(SUM(O26:O33))*I25","v":0},null,{"$f":"(SUMIF(K26:K33, \"In-house\",O26:O33))*I25","v":0},{"$f":"IFERROR(AA25/Y25,0)","v":0},null,{"$f":"( SUMIF(K26:K33, \"Subcontracting\",O26:O33))*I25","v":0},{"$f":"IFERROR(AD25/Y25,0)","v":0},null,{"$f":"(SUMIF(M26:M33, \"Onsite\",O26:O33))*I25","v":0},{"$f":"IFERROR(AG25/Y25,0)","v":0},null,{"$f":"(SUMIF(M26:M33, \"Onshore (Offsite)\",O26:O33))*I25","v":0},{"$f":"IFERROR(AJ25/Y25,0)","v":0},null,{"$f":"(SUMIF(M26:M33, \"Nearshore (Offsite)\",O26:O33))*I25","v":0},{"$f":"IFERROR(AM25/Y25,0)","v":0},null,{"$f":"(SUMIF(M26:M33, \"Offshore (Offsite)\",O26:O33))*I25","v":0},{"$f":"IFERROR(AP25/Y25,0)","v":0}]
[]
[]
[null,null,null,null,"Near-/Offshore percentage"]
[null,null,null,null,"according to specification point :"]
[]
[]
[]
[]
[null,null,null,"WP 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I34*S34","v":0},null,{"$f":"IF(G34=\"h\",SUMPRODUCT(O35:O42,P35:P42),0)","v":0},null,{"$f":"IF(G34=\"h\",V34*I34,T34*R34)","v":0},{"$f":"(SUM(O35:O42))*I34","v":0},null,{"$f":"(SUMIF(K35:K42, \"In-house\",O35:O42))*I34","v":0},{"$f":"IFERROR(AA34/Y34,0)","v":0},null,{"$f":"( SUMIF(K35:K42, \"Subcontracting\",O35:O42))*I34","v":0},{"$f":"IFERROR(AD34/Y34,0)","v":0},null,{"$f":"(SUMIF(M35:M42, \"Onsite\",O35:O42))*I34","v":0},{"$f":"IFERROR(AG34/Y34,0)","v":0},null,{"$f":"(SUMIF(M35:M42, \"Onshore (Offsite)\",O35:O42))*I34","v":0},{"$f":"IFERROR(AJ34/Y34,0)","v":0},null,{"$f":"(SUMIF(M35:M42, \"Nearshore (Offsite)\",O35:O42))*I34","v":0},{"$f":"IFERROR(AM34/Y34,0)","v":0},null,{"$f":"(SUMIF(M35:M42, \"Offshore (Offsite)\",O35:O42))*I34","v":0},{"$f":"IFERROR(AP34/Y34,0)","v":0}]
[]
[]
[null,null,null,null,"Near-/Offshore percentage"]
[null,null,null,null,"according to specification point :"]
[]
[]
[]
[]
[null,null,null,"WP 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I43*S43","v":0},null,{"$f":"IF(G43=\"h\",SUMPRODUCT(O44:O51,P44:P51),0)","v":0},null,{"$f":"IF(G43=\"h\",V43*I43,T43*R43)","v":0},{"$f":"(SUM(O44:O51))*I43","v":0},null,{"$f":"(SUMIF(K44:K51, \"In-house\",O44:O51))*I43","v":0},{"$f":"IFERROR(AA43/Y43,0)","v":0},null,{"$f":"( SUMIF(K44:K51, \"Subcontracting\",O44:O51))*I43","v":0},{"$f":"IFERROR(AD43/Y43,0)","v":0},null,{"$f":"(SUMIF(M44:M51, \"Onsite\",O44:O51))*I43","v":0},{"$f":"IFERROR(AG43/Y43,0)","v":0},null,{"$f":"(SUMIF(M44:M51, \"Onshore (Offsite)\",O44:O51))*I43","v":0},{"$f":"IFERROR(AJ43/Y43,0)","v":0},null,{"$f":"(SUMIF(M44:M51, \"Nearshore (Offsite)\",O44:O51))*I43","v":0},{"$f":"IFERROR(AM43/Y43,0)","v":0},null,{"$f":"(SUMIF(M44:M51, \"Offshore (Offsite)\",O44:O51))*I43","v":0},{"$f":"IFERROR(AP43/Y43,0)","v":0}]
[]
[]
[null,null,null,null,"Near-/Offshore percentage"]
[null,null,null,null,"according to specification point:"]
[]
[]
[]
[]
[null,null,null,"WP 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I52*S52","v":0},null,{"$f":"IF(G52=\"h\",SUMPRODUCT(O53:O60,P53:P60),0)","v":0},null,{"$f":"IF(G52=\"h\",V52*I52,T52*R52)","v":0},{"$f":"(SUM(O53:O60))*I52","v":0},null,{"$f":"(SUMIF(K53:K60, \"In-house\",O53:O60))*I52","v":0},{"$f":"IFERROR(AA52/Y52,0)","v":0},null,{"$f":"( SUMIF(K53:K60, \"Subcontracting\",O53:O60))*I52","v":0},{"$f":"IFERROR(AD52/Y52,0)","v":0},null,{"$f":"(SUMIF(M53:M60, \"Onsite\",O53:O60))*I52","v":0},{"$f":"IFERROR(AG52/Y52,0)","v":0},null,{"$f":"(SUMIF(M53:M60, \"Onshore (Offsite)\",O53:O60))*I52","v":0},{"$f":"IFERROR(AJ52/Y52,0)","v":0},null,{"$f":"(SUMIF(M53:M60, \"Nearshore (Offsite)\",O53:O60))*I52","v":0},{"$f":"IFERROR(AM52/Y52,0)","v":0},null,{"$f":"(SUMIF(M53:M60, \"Offshore (Offsite)\",O53:O60))*I52","v":0},{"$f":"IFERROR(AP52/Y52,0)","v":0}]
[]
[]
[null,null,null,null,"Near-/Offshore percentage"]
[null,null,null,null,"according to specification point:"]
[]
[]
[]
[]
[null,null,null,"WP 7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I61*S61","v":0},null,{"$f":"IF(G61=\"h\",SUMPRODUCT(O62:O69,P62:P69),0)","v":0},null,{"$f":"IF(G61=\"h\",V61*I61,T61*R61)","v":0},{"$f":"(SUM(O62:O69))*I61","v":0},null,{"$f":"(SUMIF(K62:K69, \"In-house\",O62:O69))*I61","v":0},{"$f":"IFERROR(AA61/Y61,0)","v":0},null,{"$f":"( SUMIF(K62:K69, \"Subcontracting\",O62:O69))*I61","v":0},{"$f":"IFERROR(AD61/Y61,0)","v":0},null,{"$f":"(SUMIF(M62:M69, \"Onsite\",O62:O69))*I61","v":0},{"$f":"IFERROR(AG61/Y61,0)","v":0},null,{"$f":"(SUMIF(M62:M69, \"Onshore (Offsite)\",O62:O69))*I61","v":0},{"$f":"IFERROR(AJ61/Y61,0)","v":0},null,{"$f":"(SUMIF(M62:M69, \"Nearshore (Offsite)\",O62:O69))*I61","v":0},{"$f":"IFERROR(AM61/Y61,0)","v":0},null,{"$f":"(SUMIF(M62:M69, \"Offshore (Offsite)\",O62:O69))*I61","v":0},{"$f":"IFERROR(AP61/Y61,0)","v":0}]
[]
[]
[null,null,null,null,"Near-/Offshore percentage"]
[null,null,null,null,"according to specification point:"]
[]
[]
[]
[]
[null,null,null,"WP 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I70*S70","v":0},null,{"$f":"IF(G70=\"h\",SUMPRODUCT(O71:O78,P71:P78),0)","v":0},null,{"$f":"IF(G70=\"h\",V70*I70,T70*R70)","v":0},{"$f":"(SUM(O71:O78))*I70","v":0},null,{"$f":"(SUMIF(K71:K78, \"In-house\",O71:O78))*I70","v":0},{"$f":"IFERROR(AA70/Y70,0)","v":0},null,{"$f":"( SUMIF(K71:K78, \"Subcontracting\",O71:O78))*I70","v":0},{"$f":"IFERROR(AD70/Y70,0)","v":0},null,{"$f":"(SUMIF(M71:M78, \"Onsite\",O71:O78))*I70","v":0},{"$f":"IFERROR(AG70/Y70,0)","v":0},null,{"$f":"(SUMIF(M71:M78, \"Onshore (Offsite)\",O71:O78))*I70","v":0},{"$f":"IFERROR(AJ70/Y70,0)","v":0},null,{"$f":"(SUMIF(M71:M78, \"Nearshore (Offsite)\",O71:O78))*I70","v":0},{"$f":"IFERROR(AM70/Y70,0)","v":0},null,{"$f":"(SUMIF(M71:M78, \"Offshore (Offsite)\",O71:O78))*I70","v":0},{"$f":"IFERROR(AP70/Y70,0)","v":0}]
[]
[]
[null,null,null,null,"Near-/Offshore percentage"]
[null,null,null,null,"according to specification point:"]
[]
[]
[]
[]
[null,null,null,"WP 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I79*S79","v":0},null,{"$f":"IF(G79=\"h\",SUMPRODUCT(O80:O87,P80:P87),0)","v":0},null,{"$f":"IF(G79=\"h\",V79*I79,T79*R79)","v":0},{"$f":"(SUM(O80:O87))*I79","v":0},null,{"$f":"(SUMIF(K80:K87, \"In-house\",O80:O87))*I79","v":0},{"$f":"IFERROR(AA79/Y79,0)","v":0},null,{"$f":"( SUMIF(K80:K87, \"Subcontracting\",O80:O87))*I79","v":0},{"$f":"IFERROR(AD79/Y79,0)","v":0},null,{"$f":"(SUMIF(M80:M87, \"Onsite\",O80:O87))*I79","v":0},{"$f":"IFERROR(AG79/Y79,0)","v":0},null,{"$f":"(SUMIF(M80:M87, \"Onshore (Offsite)\",O80:O87))*I79","v":0},{"$f":"IFERROR(AJ79/Y79,0)","v":0},null,{"$f":"(SUMIF(M80:M87, \"Nearshore (Offsite)\",O80:O87))*I79","v":0},{"$f":"IFERROR(AM79/Y79,0)","v":0},null,{"$f":"(SUMIF(M80:M87, \"Offshore (Offsite)\",O80:O87))*I79","v":0},{"$f":"IFERROR(AP79/Y79,0)","v":0}]
[]
[]
[null,null,null,null,"Near-/Offshore percentage"]
[null,null,null,null,"according to specification point:"]
[]
[]
[]
[]
[null,null,null,"WP 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I88*S88","v":0},null,{"$f":"IF(G88=\"h\",SUMPRODUCT(O89:O96,P89:P96),0)","v":0},null,{"$f":"IF(G88=\"h\",V88*I88,T88*R88)","v":0},{"$f":"(SUM(O89:O96))*I88","v":0},null,{"$f":"(SUMIF(K89:K96, \"In-house\",O89:O96))*I88","v":0},{"$f":"IFERROR(AA88/Y88,0)","v":0},null,{"$f":"( SUMIF(K89:K96, \"Subcontracting\",O89:O96))*I88","v":0},{"$f":"IFERROR(AD88/Y88,0)","v":0},null,{"$f":"(SUMIF(M89:M96, \"Onsite\",O89:O96))*I88","v":0},{"$f":"IFERROR(AG88/Y88,0)","v":0},null,{"$f":"(SUMIF(M89:M96, \"Onshore (Offsite)\",O89:O96))*I88","v":0},{"$f":"IFERROR(AJ88/Y88,0)","v":0},null,{"$f":"(SUMIF(M89:M96, \"Nearshore (Offsite)\",O89:O96))*I88","v":0},{"$f":"IFERROR(AM88/Y88,0)","v":0},null,{"$f":"(SUMIF(M89:M96, \"Offshore (Offsite)\",O89:O96))*I88","v":0},{"$f":"IFERROR(AP88/Y88,0)","v":0}]
[]
[]
[null,null,null,null,"Near-/Offshore percentage"]
[null,null,null,null,"according to specification point:"]
[]
[]
[]
[]
[]
[null,null,null,"Development services in total:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X7:X96)","v":0},{"$f":"SUM(Y7:Y96)","v":0},null,{"$f":"SUM(AA7:AA96)","v":0},{"$f":"IFERROR(AA98/Y98,0)","v":0},null,{"$f":"SUM(AD7:AD96)","v":0},{"$f":"IFERROR(AD98/Y98,0)","v":0},null,{"$f":"SUM(AG7:AG96)","v":0},{"$f":"IFERROR(AG98/Y98,0)","v":0},null,{"$f":"SUM(AJ7:AJ96)","v":0},{"$f":"IFERROR(AJ98/Y98,0)","v":0},null,{"$f":"SUM(AM7:AM96)","v":0},{"$f":"IFERROR(AM98/Y98,0)","v":0},null,{"$f":"SUM(AP7:AP96)","v":0},{"$f":"IFERROR(AP98/Y98,0)","v":0}]
[]
[]
[null,null,null,"add. cost / metering equipment  / licensing / measurement resources / etc. ",null,null,null,null,null,null,"performance level","description",null,null,"Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(O102:P106)","v":0}]
[null,null,null,"add. expenses"]
[null,null,null,"add. expenses",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"add. expenses",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"add. expenses",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"T105*J105","v":0}]
[null,null,null,"add. expenses",null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,"Development services & additional expenses total:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X98+X101","v":0}]
[]
[]
[null,null,null,"travel expenses"]
[null,null,null,"Travel expenses are not billed as a lump sum, but in accordance with the travel expense policy. No travel expenses are billable for onsite presence or travel to CARIAD locations within Germany.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T113*J113","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"T122*J122","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"T131*J131","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"T140*J140","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"T149*J149","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"T158*J158","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"T167*J167","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"T176*J176","v":0}]

{"sheet":"Config","index":2,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Project Rolles",null,"Place of provision",null,"Beistellungsleistungen ",null,null,null,null,null,"Currencies"]
[]
[null,"A0 Special Topics",null,"Onsite",null,null,null,null,null,null,null,"EURO","EUR","€"]
[null,"A1 Multi project management",null,"Onshore (Offsite)",null,"cost for software",null,null,"In-house",null,null,"DOLLAR","USD","$"]
[null,"A2 Project Management",null,"Nearshore (Offsite)",null,"cost for test benches",null,null,"Subcontracting",null,null,"Renminbi (YEN)","RMB","¥"]
[null,"A2 Testmanagement",null,"Offshore (Offsite)"]
[null,"A3 Consulting complex"]
[null,"A3 Testanaylsis"]
[null,"A4 Consulting (standard)"]
[null,"A4 Testing"]
[null,"A5 Consulting (simple)"]
[null,"A6 Projekt Assistance"]
[null,"B1 Process analysis (complex)"]
[null,"B2 Process analysis (standard)"]
[null,"B3 Consulting (complex)"]
[null,"B4 Consulting (standard)"]
[null,"B5 Consulting (simple)"]
[null,"C2 Development Leadership"]
[null,"C3 Development (complex)"]
[null,"C4 Development (standard)"]
[null,"C5 Development (simple)"]
[null,"C6 Development documentation"]
[null,"D1 Operational Integration"]
[null,"D2 Service Management"]
[null,"D3 3rd Level Support"]
[null,"D4 2nd Level Support"]
[null,"D5 1st Level Support"]

{"sheet":"Performance Levels","index":3,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,1,34,2],[34,3,34,4],[35,1,35,2],[35,3,35,4],[31,1,31,2],[31,3,31,4],[32,1,32,2],[32,3,32,4],[33,1,33,2],[33,3,33,4],[30,0,30,2],[30,3,30,4],[24,1,24,2],[24,3,24,4],[25,1,25,2],[25,3,25,4],[26,1,26,2],[26,3,26,4],[27,1,27,2],[27,3,27,4],[28,1,28,2],[28,3,28,4],[29,0,29,5],[23,0,23,2],[23,3,23,4],[17,1,17,2],[17,3,17,4],[18,1,18,2],[18,3,18,4],[19,1,19,2],[19,3,19,4],[20,1,20,2],[20,3,20,4],[21,1,21,2],[21,3,21,4],[22,0,22,5],[16,0,16,2],[16,3,16,4],[10,0,10,2],[10,3,10,4],[11,0,11,2],[11,3,11,4],[12,0,12,2],[12,3,12,4],[13,0,13,2],[13,3,13,4],[14,0,14,2],[14,3,14,4],[15,0,15,5],[9,0,9,2],[9,3,9,4],[0,0,0,5],[1,0,1,5],[3,0,3,5],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[6,0,6,2],[6,3,6,4],[7,0,7,2],[7,3,7,4],[8,0,8,2]]}
["Classification of IT services in the new Performance levels"]
[]
[]
["Category A   IT Cross section subjects (Phase-overlapping)"]
["Performance level",null,null,"Tasks",null,"Responsibility/Competence"]
["A0   Special subjects",null,null,"- Top Management and CIO consulting in the IT environment\n- Corporate and technology strategy consulting in the IT environment\n- Strategies to improve the client’s competitiveness in the IT environment\n- Portfolio Management",null,"- Overall responsibility for the content and time of\norder Fulfillment\n- Responsibility for project success / results, quality and added value for the contractor"]
["A1   Multi-project Management",null,null,"- Safeguarding of the project management and quality assurance of several projects\n- Management and control of multiple project teams\n- Project leadership including analysis, risk management, and controlling in any projects\n- Planning, implementation and closure of projects\n- Coordination and presentation of the final project results\n- Independent order processing according to IT-PEP",null,"- Responsibility for contract contents, schedules and cost limits\n- Overall project management"]
["A2   Project Management",null,null,"- Safeguarding of the project management and quality assurance of several projects\n- Management and control of a project team\n- Project leadership including analysis, risk management and controlling of a project\n- Planning, implementation and closure of projects\n- Coordination and presentation of the final project results\n- Independent order processing according to IT-PEP",null,"- Responsibility for contract contents, schedules and cost limits\n- Overall project management"]
["A2   Test Management",null,null,"Superior and strategic tasks:\n- Test design\n- Test planning\n- Coordination of test case creation\n- Test control\n- Test completion\n- Reporting","Operational tasks in the testing process per test level or test type:\n- Test Level Planning\n- Test analysis and design\n- Test implementation and execution\n- Test evaluation and logging\n- Completion of the test level","- Responsibility for the management of the entire or part of the test project"]
["A3   Consulting (Complex)",null,null,"- Independent and detailed analysis of complex business requirements\n- Execution of workshops (including preparation and follow up)\n- Execution of complex process analysis of existing processes in cross-cutting issues\n- Optimization and development of complex processes in cross-cutting issues\n- Simulation and definition of complex target processes (as well as KPIs) in cross-cutting issues\n- Creation of complex feasibility and profitability analysis\n- Development of complex solutions, creation of complex organizational concepts\n- Independent order processing according to IT PEP",null,"- Sub-project Management, small-scale projects\n- Independent activities, subtasks"]
["A3   Test Analysis",null,null,"- Specialized or technically focused area of responsibility (test analysis or test automatization as well as load & performance testing)\n- Preparatory activities such as the analysis of technical requirements (technical concept) and design (IT concept, technical system design) for test relevant topics\n- Definition of test objects and test cases based on the functional and technical specifications\n- Support of the test management during the planning stage\n- Guidance of professional or technical testing teams, leadership in incident management test projects\n- Ensuring correct test documentation, provision of test infrastructure, and test execution\n- Creation of tools for automated analyses of test run results, test automatization for recurring test cases\n- Independent execution of non-functional tests (Implementation of load, performance, and security tests)",null,"- Responsibility for test planning and design\n- Responsibility for the automatization of recurring test cases for the purpose of resource and cost reductions"]
["A4    Consulting (Standard)",null,null,"- Independent and detailed analysis of business requirements\n- Execution of workshops (including preparation and follow-ups.)\n- Execution of process analysis of existing processes in cross-cutting issues\n- Optimization and development of processes in cross-cutting issues\n- Simulation and definition of target processes (as well as KPIs)\n- Preparation of feasibility and profitability analysis\n- Development of problem-solving approaches, creation of organizational concepts\n- Independent order processing according to IT PEP",null,"- Independent activities, subtasks\n- Supporting and advisory activities within projects"]
["A4   Testing",null,null,"- Technical testing that covers the entire range of tasks of operational testing, excluding test planning\n- Participation in the preparation of professional and / or technical test cases\n- Execution of functional and/or technical tests on the basis of prepared test cases\n- Evaluation of the results\n- Documentation of the results as well as any deviations from the expected result",null,"- Responsibility for the execution and documentation of test cases and results"]
["A5    Consulting (simple)",null,null,"- Support activities within projects, ranging from planning to implementation\n- Detailed analysis of business requirements in cross-cutting themes\n- Data structuring and analysis\n- Research activities\n- Assistance in the preparation of decision papers, presentations, reports, evaluations or other documentation\n- Support for workshop execution (including preparation and follow up)\n- Incorporation of requirements and processes in cross-cutting issues\n- Support for the development of problem-solving approaches\n- Order processing according to IT PEP",null,"- Activities, tasks to specification"]
["A6   Project Documentation",null,null,"- Coordination and organization of appointments\n- Maintenance and quality assurance of the data storage\n- Distribution of information and reporting\n- Project controlling",null,"- Activities, tasks to specification"]
["Category B   IT Requirements Management and Requirements Definition"]
["Performance level",null,null,"Tasks",null,"Responsibility/Competence"]
["B1","Process Analysis(Complex)",null,"- Independent analysis, planning and description of complex processes\n- Full responsibility for concept development\n- Independent order processing according to IT-PEP",null,"- Responsibility for project success / results,\nquality and added value for the customer"]
["B2","Process Analysis (Standard)",null,"- Independent analysis, planning and description of processes\n- Concept development\n- Independent order processing according to IT-PEP",null,"- Responsibility for project success / results, quality and added value for the customer"]
["B3","Consulting (Complex)",null,"- Independent Pre-Clarification, Order Clarification and Design of complex and connected application systems\n- Independent and detailed analysis of complex business requirements\n- Development of complex problem-solving approaches, organizational concepts, specifications books (requirement definition) and development specifications (rough)\n- Independent order processing according to IT-PEP",null,"- Independent activities, subtasks"]
["B4","Consulting (Standard)",null,"- Independent Pre-Clarification, Order Clarification and design of application systems\n- Independent and detailed analysis of technical requirements\n- Development of problem-solving approaches, organizational concepts, specification books (requirement definition), and development specifications (rough)\n- Independent order processing according to IT-PEP",null,"- Independent activities, subtasks"]
["B5","Consulting (Simple)",null,"- Pre-Clarification, Order Clarification and Design of application systems as per specification\n- Detailed analysis of specified technical requirements, support for supervised activities, and contribution to the project planning and execution of a project\n- Support for the development of organizational concepts, specification books (requirement definition) and development specifications (rough)\n- Data structuring and analysis, research activities\n- Order processing according to IT-PEP",null,"- Activities, subtasks as per specification"]
["Category C   IT System Development and Implementation"]
["Performance level",null,null,"Tasks",null,"Responsibility/Competence"]
["C2","Development Lead",null,"- Guidance and leadership of the development teams / Scrum teams\n- Ensuring functionality\n- Optimization of the team productivity\n- Monitoring project compliance with predefined specifications and milestones\n- Elimination of obstacles, protection of the team against disruptions, and representation of team interests\n- Independent order processing according to IT-PEP",null,"- Responsibility for project success / results,\nquality and added value for the customer\n- Responsibility for the goal-oriented and timely implementation of the requirements\n- Scrum Master is responsible for the compliance with Scrum values"]
["C3","Development (Complex)",null,"-Independent design, realization, implementation and stabilization of complex and connected application systems according to IT PEP\n- Independent processing of complex and definite development tasks in IT projects\n- Design responsibility\n- Independent order processing according to IT-PEP",null,"- Independent activities, subtasks"]
["C4","Development (Standard)",null,"- Independent design, realization, implementation and stabilization of application systems according to IT PEP\n- Independent processing of definite development tasks in IT projects\n- Coding with coding languages\n- Independent order processing according to IT-PEP",null,"- Independent activities, subtasks"]
["C5","Development (Simple)",null,"- Design, realization, implementation and stabilization of application systems as per specification and in accordance with IT PEP\n- Coding with coding languages\n- Support activities\n- Order processing as per specification and in accordance with IT-PEP",null,"- Activities, subtasks as per specification"]
["C6","Development Documentation",null,"- Layout creation and document maintenance, text collection with text detection systems as per specification\n- Usage of standard, customer and product Office Software",null,"- Activities, subtasks as per specification"]
["Category D   IT Application support and operations"]
["Performance level",null,null,"Tasks",null,"Responsibility/Competence"]
["D1","Operational Integration",null,"- Ensuring the ticket flow process throughout the entire life cycle of a ticket\n- Actions to prevent the occurrence of incidents\n- Actions to reduce / mitigate the negative impact of incidents that cannot be prevented\n- Information maintenance regarding known errors and workarounds",null,"- Responsibility for the ticket flow process\nthroughout the entire life cycle of a ticket"]
["D2","Service Management",null,"- Planning and allocation of all resources\n- Hedging operations in the 2nd or 3rd level support\n- Management and control of a support team\n- Planning, implementation and completion of the project\n- Monitoring, documentation and reporting of ticket flows",null,"- Independent activities, subtasks"]
["D3","3rd Level Support",null,"- Handling all problems throughout their entire life cycle\n- Solving problems that have been reported from the 2nd Level Support\n- Fastest possible restoration of a defined operating state of a service\n- Implementation of the reported changes\n- Implementation of the release management (service releases, etc.) including documentation.",null,"- Independent activities, subtasks"]
["D4","2nd Level Support",null,"- Adoption of unresolved fault messages from the 1st  level Support\n- Effective execution of the incident management process and processing of the relevant reporting\n- First level of escalation for incidents that cannot be solved within the agreed service levels\n- If necessary, requesting support from the 3rd  level support\n- Fastest possible restoration of a defined operating state of a service\n- Timely and reliably ensuring all operational routine tasks\n- Management of all problems throughout their entire life cycle\n- Creation of backups, scheduling of batch jobs, and installation of standard components\n- If causal troubleshooting is not possible, transfer of interference to the problem management (3rd  level) for further processing",null,"- Independent activities, subtasks"]
["D5","1st Level Support",null,"- Registration and classification of incoming failure reports\n- Immediate solution attempt to restore the defined operating status of a service as fast as possible\n- Creation of backups, scheduling of batch jobs, and installation of standard components\n- If solution does not succeed, forwarding of malfunction (incident) to special processing groups in the 2nd  level of support",null,"- Independent activities, subtasks"]

{"sheet":"overview place of provision","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}