{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["OTF ACTIVATION - TERMIN PREMISE"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"OTF ACTIVATION - TERMIN PREMISE","index":0,"n_rows":119,"n_cols":21,"rows_kept":119,"cut":false,"hidden":false,"merged":[[9,14,9,17],[9,18,9,20],[9,4,9,7],[9,8,9,10],[9,11,9,13]]}
[null,{"$f":"B7","v":"Activation of terminated premise"}]
[]
["<- Worksheet description"]
[null,{"$f":"\"This worksheet contains the costing of the service '\"&B7&\"'\"","v":"This worksheet contains the costing of the service 'Activation of terminated premise'"}]
[]
[null,"SERVICE"]
[null,"Activation of terminated premise"]
[]
[null,null,"COST CALCULATION - BOTTOM-UP APPROACH"]
[null,null,null,null,"OWN STAFF COSTS",null,null,null,"OUTSOURCED COSTS",null,null,"ADDITIONAL COSTS",null,null,"MATERIAL COSTS",null,null,null,"TOTAL COSTS"]
[null,null,"TASK","TYPE OF COST","HOURLY MAN COST\n[EUR/h]","WORK TIME\n[Minutes]","FREQUENCY OF EXECUTION - \nOWN STAFF\n[%]","TOTAL OWN STAFF COST\n[EUR]","OUTSOURCED UNITARY COST\n[EUR/item]","FREQUENCY OF EXECUTION - OUTSOURCED \n[%]","TOTAL OUTSOURCED COST\n[EUR]","ADDITIONAL UNITARY COST\n[EUR/item]","FREQUENCY OF EXECUTION - ADDITIONAL COST\n[%]","TOTAL ADDITIONAL COST\n[EUR]","MATERIAL UNITARY COST\n[EUR/item]","FREQUENCY OF EXECUTION - MATERIAL COST\n[%]","STORAGE AND HANDLING COSTS\n[%]","TOTAL MATERIAL COST\n[EUR]","TOTAL WORK COST\n[EUR]","TOTAL MATERIAL COST\n[EUR]","TOTAL COST\n[EUR]"]
[null,null,null,null,null,null,null,{"$f":"E12*F12*G12/60","v":0},null,null,{"$f":"I12*J12","v":0},null,null,{"$f":"L12*M12","v":0},null,null,null,{"$f":"O12*P12*(1+Q12)","v":0},{"$f":"H12+K12+N12","v":0},{"$f":"R12","v":0},{"$f":"S12+T12","v":0}]
[null,null,"Manual activities required for certain orders during the order validation (execute basic & admin checks, correct order content if possible, handle blocked orders, etc.)",null,null,null,null,{"$f":"E13*F13*G13/60","v":0},null,null,{"$f":"I13*J13","v":0},null,null,{"$f":"L13*M13","v":0},null,null,null,{"$f":"O13*P13*(1+Q13)","v":0},{"$f":"H13+K13+N13","v":0},{"$f":"R13","v":0},{"$f":"S13+T13","v":0}]
[null,null,"Activity 1 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[0-10]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 2 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[0-10]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 3 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[10-20]","[0-10]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 4 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[10-20]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 5 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[10-20]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 6 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[10-20]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 7 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[10-20]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,"Manual activities required for certain orders during the order execution (assign qualified technician, reserve and book technician, specific dispatch with particular characteristics, etc.)",null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,"Activity 1 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[10-20]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 2 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[50-60]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 3 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[50-60]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 4 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[50-60]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 5 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[10-20]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,"Installation & activation (work at end-user's premises)","Outsourced",null,null,null,0,"[50-75]",1,{"$error":"#VALUE!"},null,null,0,"[25-50]",1,"[0-10]%",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,"Support provided to the technician for certain orders during the order execution (when the technician contacts asking for specific help, verifications, manual configurations, feedback, etc.)",null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,"Activity 1 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[30-40]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 2 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[10-20]","[30-40]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 3 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[0-10]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 4 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[30-40]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 5 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[0-10]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,"Activity 6 (specific names are not provided for confidential reasons)","Own staff","[50-75]","[0-10]","[0-10]%",{"$error":"#VALUE!"},null,null,0,null,null,0,null,null,null,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"E77*F77*G77/60","v":0},null,null,{"$f":"I77*J77","v":0},null,null,{"$f":"L77*M77","v":0},null,null,null,{"$f":"O77*P77*(1+Q77)","v":0},{"$f":"H77+K77+N77","v":0},{"$f":"R77","v":0},{"$f":"S77+T77","v":0}]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DIRECT COST - STAFF COSTS",{"$f":"SUM(S12:S110)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL INDIRECT COST - TECHNICAL FIELD OPERATIONS","Mark-up of [10-20]% is applied on outsourced costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL INDIRECT COST - CUSTOMER CARE","Mark-up of [0-10]% is applied on all direct costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL DIRECT COST - MATERIAL COSTS",{"$f":"SUM(T12:T110)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL G&A COST","Mark-up of 5% is applied on all costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL IT COST","Mark-up of 7,5% is applied on all costs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL COST",{"$f":"SUM(U112:U117)","v":{"$error":"#VALUE!"}}]