{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Start","Overview","LifeCycle","Use","Infrastructure","Results","Comparision","Calculation","Data","About","History"],"not_rendered":{"charts":16,"images":14,"macros":1,"external_links":1,"defined_names":91,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Preface"]
[]
[null,"Excellent engineers use a systematic way of thinking. And in the field of energy and material efficient product design they are in need of a methodology to guide especially early planning and decision making steps in der product development process. One element of great importance is the so called \"life cycle thinking\" and a pragmatic and easy to handle evaluation of all energy and material impacts over all product life cycle. This tool offers such a planning frame work."]
[null,"Since more than 20 years, ecodesign experts in mechanical industry have been concerned with the question of how industrial products and especially machine tools can be improved in an ecological sense. As some products are often used in different ways by different customers, usage itself has to be hypothesized as a variable entity. Ecodesign therefore requires system knowhow. This is about more than just “filter & recycling“; much rather better products and production systems are required. Once you start looking at machines, respectively production systems, the complexity of the product increases enormously. \nFor ecodesign in the machine industry specific knowhow is essential - knowhow which is not yet or only partly available. "]
[null,"Ecodesign aims to achieve an improvement of products which particularly also fulfils eco-logical criteria. The challenge for product development is to see the product as a whole, to see it as a system, which is bonded in a relationship with the environment and which impacts the environment in different ways throughout all of its product life phases. The design process is crucial for this; the designer has to recognize when and where potentially significant impact on the environment could occur and how he / she can influence i.e. improve these. This process, therefore, entails a specific analysis of the “system and its environment“ as well as the search for solutions on the basis of identified or suspected specific ecological weaknesses. This is the only way to achieve real improvements. "]
[null,"This is where the following tool proves to be useful. The tool provides a framework; all information about an existing or planned product can be modelled. "]
[]
[null,"The calculation itself is based on energy consumption. The energy-profiles and some other calculations provide a first interpretation of significant and non-significant functions and components. This transparency is useful especially in the early stage of product development."]
[null,"The tool was mainly developed within a project which was endorsed by \"Swiss Electric Research\"; the main project partners have been ETH Zürich and Züst Engineering AG; five companies which are producing machine tools have been industrial partners - a big thank you to all project partners!"]
[]
[null,"Now, we wish you a successful application of this tool."]
[]
[null,"For the project team, Seegräben, 11th April 2013\nRainer Züst\nZüst Engineering AG"]

{"sheet":"Overview","index":1,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,7,1,10],[4,8,4,10],[13,8,13,10],[25,8,25,10],[37,8,37,10],[2,7,2,10],[25,1,25,3],[37,1,37,3],[4,1,4,3],[1,0,1,3],[13,1,13,3]]}
[null,null,null,{"$f":"Version","v":"ET-MTED-V3R1"}]
["Eco design of Machines:  Potential Estimation Tool",null,null,null,null,null,null,"Eco design of Machines:  Potential Estimation Tool"]
[null,null,null,null,null,null,null,"EXAMPLE"]
[]
["Overview","In this section, general information about the machine is collected. This information will later be used for a structured data input and the analysis of the machines energetic footprint",null,null,null,null,null,"Overview","In this section, general information about the machine is collected. This information will later be used for a structured data input and the analysis of the machines energetic footprint"]
[]
[]
["General","Name of the machine","Test",null,null,null,null,"General","Name of the machine","Test"]
[null,"Company","My Company",null,null,null,null,null,"Company","My Company"]
[null,"Price per unit",100000,null,null,null,null,null,"Price per unit",100000]
[null,"Units sold per year",12,null,null,null,null,null,"Units sold per year",12]
[]
[]
["Structure","The machine consists of a frame, which holds the following modules:",null,null,null,null,null,"Structure","The machine consists of a frame, which holds the following modules:"]
[null,"Module 1","Hauptspindel",null,null,null,null,null,"Module 1","Hauptspindel"]
[null,"Module 2","Achse X1",null,null,null,null,null,"Module 2","Achse X1"]
[null,"Module 3","Achse Y1",null,null,null,null,null,"Module 3","Achse Y1"]
[null,"Module 4","Achse Z1",null,null,null,null,null,"Module 4","Achse Z1"]
[null,"Module 5","Kabinett",null,null,null,null,null,"Module 5","Kabinett"]
[null,"Module 6","KSM Pumpe",null,null,null,null,null,"Module 6","KSM Pumpe"]
[null,"Module 7","Spindelkühlung",null,null,null,null,null,"Module 7","Spindelkühlung"]
[null,"Module 8","Sinumerik",null,null,null,null,null,"Module 8","Sinumerik"]
[null,null,{"$f":"COUNTA(C15:C22)&\" modules in total\"","v":"8 modules in total"},null,null,null,null,null,null,{"$f":"COUNTA(J15:J22)&\" modules in total\"","v":"8 modules in total"}]
[]
[]
["Tools","During the use phase of the machine, the following tools are installed and used in the machine:",null,null,null,null,null,"Tools","During the use phase of the machine, the following tools are installed and used in the machine:"]
[null,"Tool 1","Fräser 1",null,null,null,null,null,"Tool 1","Fräser 1"]
[null,"Tool 2","Fräser 2",null,null,null,null,null,"Tool 2","Fräser 2"]
[null,"Tool 3","Fräser 3",null,null,null,null,null,"Tool 3","Fräser 3"]
[null,"Tool 4","Bohrer 1",null,null,null,null,null,"Tool 4","Bohrer 1"]
[null,"Tool 5","Bohrer 2",null,null,null,null,null,"Tool 5","Bohrer 2"]
[null,"Tool 6","Bohrer 3",null,null,null,null,null,"Tool 6","Bohrer 3"]
[null,"Tool 7","Bohrer 4",null,null,null,null,null,"Tool 7","Bohrer 4"]
[null,"Tool 8","Gewindeschneider",null,null,null,null,null,"Tool 8","Gewindeschneider"]
[null,null,{"$f":"COUNTA(C27:C34)&\" tools in total\"","v":"8 tools in total"},null,null,null,null,null,null,{"$f":"COUNTA(J27:J34)&\" tools in total\"","v":"8 tools in total"}]
[]
[]
["Infrastructure","In order to operate proper, the machine requires the following infrastructure:",null,null,null,null,null,"Infrastructure","In order to operate proper, the machine requires the following infrastructure:"]
[null,"Air conditioning","yes",null,null,null,null,null,"Air conditioning","yes"]
[null,"Heating (fluid)","no",null,null,null,null,null,"Heating (fluid)","no"]
[null,"Cooling (fluid)","yes",null,null,null,null,null,"Cooling (fluid)","yes"]
[null,"Lubrication centre","yes",null,null,null,null,null,"Lubrication centre","yes"]
[null,null,{"$f":"COUNTIFS(C39:C42,\"yes\")&\" infrastructures in total\"","v":"3 infrastructures in total"},null,null,null,null,null,null,{"$f":"COUNTIFS(J39:J42,\"yes\")&\" infrastructures in total\"","v":"3 infrastructures in total"}]

{"sheet":"LifeCycle","index":2,"n_rows":178,"n_cols":20,"rows_kept":178,"cut":false,"hidden":false,"merged":[[1,0,1,7],[44,5,44,6],[50,3,50,6],[4,1,4,6],[47,3,47,6],[49,3,49,6],[52,3,52,6],[53,3,53,6],[54,3,54,6],[55,3,55,6],[56,3,56,6],[66,5,66,6],[46,0,66,0],[7,0,44,0],[68,0,88,0],[90,0,110,0],[88,5,88,6],[110,5,110,6],[63,3,63,6],[64,3,64,6],[65,3,65,6],[61,3,61,6],[62,3,62,6],[51,3,51,6],[60,3,60,6],[58,3,58,6],[59,3,59,6],[157,0,177,0],[128,2,128,6],[112,0,123,0],[123,5,123,6],[143,1,143,6],[125,0,155,0],[177,5,177,6],[119,2,119,6],[120,2,120,6],[121,2,121,6],[122,2,122,6],[155,5,155,6],[1,13,1,20],[4,14,4,19],[7,13,44,13],[44,18,44,19],[46,13,66,13],[47,16,47,19],[49,16,49,19],[50,16,50,19],[51,16,51,19],[52,16,52,19],[53,16,53,19],[54,16,54,19],[55,16,55,19],[56,16,56,19],[58,16,58,19],[59,16,59,19],[157,13,177,13],[177,18,177,19],[112,13,123,13],[119,15,119,19],[120,15,120,19],[121,15,121,19],[122,15,122,19],[123,18,123,19],[2,13,3,20],[125,13,155,13],[128,15,128,19],[143,14,143,19],[155,18,155,19],[65,16,65,19],[66,18,66,19],[68,13,88,13],[88,18,88,19],[90,13,110,13],[110,18,110,19],[60,16,60,19],[61,16,61,19],[62,16,62,19],[63,16,63,19],[64,16,64,19]]}
[null,null,null,null,null,null,null,{"$f":"Version","v":"ET-MTED-V3R1"}]
["Life-Cycle",null,null,null,null,null,null,null,null,null,null,null,null,"Life-Cycle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"EXAMPLE"]
[]
["Overview","During the life cycle analysis, information about each life phase of the machine are collected. Based on this information the primary energy required for the machine life time is calculated. This life time includes the following steps:\n\n    1. Raw materials\n    2. Purchasing & Production\n    3. Packaging\n    4. Transportation\n    5. Operation\n    6. Recycling\n \n(The additional infrastructures as the utilization by the customer are quantified the  sheets \"Infrastructure\" and \"Use\".)\n",null,null,null,null,null,null,null,null,null,null,null,"Overview","During the life cycle analysis, information about each life phase of the machine are collected. Based on this information the primary energy required for the machine life time is calculated. This life time includes the following steps:\n\n    1. Raw materials\n    2. Purchasing & Production\n    3. Packaging\n    4. Transportation\n    5. Operation\n    6. Recycling\n \n(The additional infrastructures as the utilization by the customer are quantified the  sheets \"Infrastructure\" and \"Use\".)\n"]
[]
[]
["Raw materials",null,"Material 1","Material 2","Material 3","Material 4","Material 5",null,null,null,null,null,null,"Raw materials",null,"Material 1","Material 2","Material 3","Material 4","Material 5"]
[null,"Machine structure","steel, iron","cast iron","aluminium, copper, brass","electronics",null,null,null,null,null,null,null,null,"Machine structure","steel, iron","cast iron","aluminium, copper, brass","electronics"]
[null,{"$f":"SUM(C10:G10)","v":4201},2000,2000,200,1,null,null,null,null,null,null,null,null,{"$f":"SUM(P10:T10)","v":4201},2000,2000,200,1]
[null,"Modules",null,null,null,null,null,null,null,null,null,null,null,null,"Modules"]
[null,{"$f":"IF(Module_1=\"\",\"-\",Module_1)","v":"Hauptspindel"},"steel, high-alloyed ","aluminium, copper, brass","electronics",null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_1_Examp=\"\",\"-\",Module_1_Examp)","v":"Hauptspindel"},"steel, high-alloyed ","aluminium, copper, brass","electronics"]
[null,{"$f":"IF(B12=\"-\",\"\",SUM(C13:G13))","v":120},30,80,10,null,null,null,null,null,null,null,null,null,{"$f":"IF(O12=\"-\",\"\",SUM(P13:T13))","v":120},30,80,10]
[null,{"$f":"IF(Module_2=\"\",\"-\",Module_2)","v":"Achse X1"},"steel, high-alloyed ","aluminium, copper, brass","electronics",null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_2_Examp=\"\",\"-\",Module_2_Examp)","v":"Achse X1"},"steel, high-alloyed ","aluminium, copper, brass","electronics"]
[null,{"$f":"IF(B14=\"-\",\"\",SUM(C15:G15))","v":61},50,10,1,null,null,null,null,null,null,null,null,null,{"$f":"IF(O14=\"-\",\"\",SUM(P15:T15))","v":61},50,10,1]
[null,{"$f":"IF(Module_3=\"\",\"-\",Module_3)","v":"Achse Y1"},"steel, high-alloyed ","aluminium, copper, brass","electronics",null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_3_Examp=\"\",\"-\",Module_3_Examp)","v":"Achse Y1"},"steel, high-alloyed ","aluminium, copper, brass","electronics"]
[null,{"$f":"IF(B16=\"-\",\"\",SUM(C17:G17))","v":61},50,10,1,null,null,null,null,null,null,null,null,null,{"$f":"IF(O16=\"-\",\"\",SUM(P17:T17))","v":61},50,10,1]
[null,{"$f":"IF(Module_4=\"\",\"-\",Module_4)","v":"Achse Z1"},"steel, high-alloyed ","aluminium, copper, brass","electronics",null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_4_Examp=\"\",\"-\",Module_4_Examp)","v":"Achse Z1"},"steel, high-alloyed ","aluminium, copper, brass","electronics"]
[null,{"$f":"IF(B18=\"-\",\"\",SUM(C19:G19))","v":35.5},30,5,0.5,null,null,null,null,null,null,null,null,null,{"$f":"IF(O18=\"-\",\"\",SUM(P19:T19))","v":35.5},30,5,0.5]
[null,{"$f":"IF(Module_5=\"\",\"-\",Module_5)","v":"Kabinett"},"steel, iron","electronics",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_5_Examp=\"\",\"-\",Module_5_Examp)","v":"Kabinett"},"steel, iron","electronics"]
[null,{"$f":"IF(B20=\"-\",\"\",SUM(C21:G21))","v":115},15,100,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O20=\"-\",\"\",SUM(P21:T21))","v":115},15,100]
[null,{"$f":"IF(Module_6=\"\",\"-\",Module_6)","v":"KSM Pumpe"},"steel, iron","aluminium, copper, brass","electronics",null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_6_Examp=\"\",\"-\",Module_6_Examp)","v":"KSM Pumpe"},"steel, iron","aluminium, copper, brass","electronics"]
[null,{"$f":"IF(B22=\"-\",\"\",SUM(C23:G23))","v":17.2},5,12,0.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(O22=\"-\",\"\",SUM(P23:T23))","v":17.2},5,12,0.2]
[null,{"$f":"IF(Module_7=\"\",\"-\",Module_7)","v":"Spindelkühlung"},"steel, iron","aluminium, copper, brass","electronics",null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_7_Examp=\"\",\"-\",Module_7_Examp)","v":"Spindelkühlung"},"steel, iron","aluminium, copper, brass","electronics"]
[null,{"$f":"IF(B24=\"-\",\"\",SUM(C25:G25))","v":11.2},3,8,0.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(O24=\"-\",\"\",SUM(P25:T25))","v":11.2},3,8,0.2]
[null,{"$f":"IF(Module_8=\"\",\"-\",Module_8)","v":"Sinumerik"},"steel, iron","PE, PP, PET, Polyester","electronics",null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_8_Examp=\"\",\"-\",Module_8_Examp)","v":"Sinumerik"},"steel, iron","PE, PP, PET, Polyester","electronics"]
[null,{"$f":"IF(B26=\"-\",\"\",SUM(C27:G27))","v":12},2,5,5,null,null,null,null,null,null,null,null,null,{"$f":"IF(O26=\"-\",\"\",SUM(P27:T27))","v":12},2,5,5]
[null,"Tools",null,null,null,null,null,null,null,null,null,null,null,null,"Tools"]
[null,{"$f":"IF(Tool_1=\"\",\"-\",Tool_1)","v":"Fräser 1"},"steel, iron",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_1_Examp=\"\",\"-\",Tool_1_Examp)","v":"Fräser 1"},"steel, iron"]
[null,{"$f":"IF(B29=\"-\",\"\",SUM(C30:G30))","v":0.4},0.4,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O29=\"-\",\"\",SUM(P30:T30))","v":0.4},0.4]
[null,{"$f":"IF(Tool_2=\"\",\"-\",Tool_2)","v":"Fräser 2"},"steel, iron",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_2_Examp=\"\",\"-\",Tool_2_Examp)","v":"Fräser 2"},"steel, iron"]
[null,{"$f":"IF(B31=\"-\",\"\",SUM(C32:G32))","v":0.3},0.3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O31=\"-\",\"\",SUM(P32:T32))","v":0.3},0.3]
[null,{"$f":"IF(Tool_3=\"\",\"-\",Tool_3)","v":"Fräser 3"},"steel, iron",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_3_Examp=\"\",\"-\",Tool_3_Examp)","v":"Fräser 3"},"steel, iron"]
[null,{"$f":"IF(B33=\"-\",\"\",SUM(C34:G34))","v":0.3},0.3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O33=\"-\",\"\",SUM(P34:T34))","v":0.3},0.3]
[null,{"$f":"IF(Tool_4=\"\",\"-\",Tool_4)","v":"Bohrer 1"},"steel, iron",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_4_Examp=\"\",\"-\",Tool_4_Examp)","v":"Bohrer 1"},"steel, iron"]
[null,{"$f":"IF(B35=\"-\",\"\",SUM(C36:G36))","v":0.2},0.2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O35=\"-\",\"\",SUM(P36:T36))","v":0.2},0.2]
[null,{"$f":"IF(Tool_5=\"\",\"-\",Tool_5)","v":"Bohrer 2"},"steel, iron",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_5_Examp=\"\",\"-\",Tool_5_Examp)","v":"Bohrer 2"},"steel, iron"]
[null,{"$f":"IF(B37=\"-\",\"\",SUM(C38:G38))","v":0.1},0.1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O37=\"-\",\"\",SUM(P38:T38))","v":0.1},0.1]
[null,{"$f":"IF(Tool_6=\"\",\"-\",Tool_6)","v":"Bohrer 3"},"steel, iron",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_6_Examp=\"\",\"-\",Tool_6_Examp)","v":"Bohrer 3"},"steel, iron"]
[null,{"$f":"IF(B39=\"-\",\"\",SUM(C40:G40))","v":0.1},0.1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O39=\"-\",\"\",SUM(P40:T40))","v":0.1},0.1]
[null,{"$f":"IF(Tool_7=\"\",\"-\",Tool_7)","v":"Bohrer 4"},"steel, iron",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_7_Examp=\"\",\"-\",Tool_7_Examp)","v":"Bohrer 4"},"steel, iron"]
[null,{"$f":"IF(B41=\"-\",\"\",SUM(C42:G42))","v":0.1},0.1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O41=\"-\",\"\",SUM(P42:T42))","v":0.1},0.1]
[null,{"$f":"IF(Tool_8=\"\",\"-\",Tool_8)","v":"Gewindeschneider"},"steel, iron",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_8_Examp=\"\",\"-\",Tool_8_Examp)","v":"Gewindeschneider"},"steel, iron"]
[null,{"$f":"IF(B43=\"-\",\"\",SUM(C44:G44))","v":0.1},0.1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O43=\"-\",\"\",SUM(P44:T44))","v":0.1},0.1]
[null,null,null,null,null,{"$f":"\"total product material: \"&IF(SUM(C9:G27)>1500,ROUND(SUM(C9:G27)/1000,1)&\" t\",SUM(C9:G27)&\" kg\")","v":"total product material: 4.6 t"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"total product material: \"&IF(SUM(P9:T27)>1500,ROUND(SUM(P9:T27)/1000,1)&\" t\",SUM(P9:T27)&\" kg\")","v":"total product material: 4.6 t"}]
[]
["Purchasing & production",null,"in-house production depth [%]","special production methods",null,null,null,null,null,null,null,null,null,"Purchasing & production",null,"in-house production depth [%]","special production methods"]
[null,{"$f":"B$9","v":"Machine structure"},0.4,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$9","v":"Machine structure"},0.4]
[null,{"$f":"B$11","v":"Modules"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$11","v":"Modules"}]
[null,{"$f":"IF(Module_1=\"\",\"-\",Module_1)","v":"Hauptspindel"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_1_Examp=\"\",\"-\",Module_1_Examp)","v":"Hauptspindel"},0]
[null,{"$f":"IF(Module_2=\"\",\"-\",Module_2)","v":"Achse X1"},0.1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_2_Examp=\"\",\"-\",Module_2_Examp)","v":"Achse X1"},0.1]
[null,{"$f":"IF(Module_3=\"\",\"-\",Module_3)","v":"Achse Y1"},0.1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_3_Examp=\"\",\"-\",Module_3_Examp)","v":"Achse Y1"},0.1]
[null,{"$f":"IF(Module_4=\"\",\"-\",Module_4)","v":"Achse Z1"},0.1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_4_Examp=\"\",\"-\",Module_4_Examp)","v":"Achse Z1"},0.1]
[null,{"$f":"IF(Module_5=\"\",\"-\",Module_5)","v":"Kabinett"},0.5,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_5_Examp=\"\",\"-\",Module_5_Examp)","v":"Kabinett"},0.5]
[null,{"$f":"IF(Module_6=\"\",\"-\",Module_6)","v":"KSM Pumpe"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_6_Examp=\"\",\"-\",Module_6_Examp)","v":"KSM Pumpe"},0]
[null,{"$f":"IF(Module_7=\"\",\"-\",Module_7)","v":"Spindelkühlung"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_7_Examp=\"\",\"-\",Module_7_Examp)","v":"Spindelkühlung"},0]
[null,{"$f":"IF(Module_8=\"\",\"-\",Module_8)","v":"Sinumerik"},0.6,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_8_Examp=\"\",\"-\",Module_8_Examp)","v":"Sinumerik"},0.6]
[null,{"$f":"B$28","v":"Tools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$28","v":"Tools"}]
[null,{"$f":"IF(Tool_1=\"\",\"-\",Tool_1)","v":"Fräser 1"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_1_Examp=\"\",\"-\",Tool_1_Examp)","v":"Fräser 1"},0]
[null,{"$f":"IF(Tool_2=\"\",\"-\",Tool_2)","v":"Fräser 2"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_2_Examp=\"\",\"-\",Tool_2_Examp)","v":"Fräser 2"},0]
[null,{"$f":"IF(Tool_3=\"\",\"-\",Tool_3)","v":"Fräser 3"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_3_Examp=\"\",\"-\",Tool_3_Examp)","v":"Fräser 3"},0]
[null,{"$f":"IF(Tool_4=\"\",\"-\",Tool_4)","v":"Bohrer 1"},1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_4_Examp=\"\",\"-\",Tool_4_Examp)","v":"Bohrer 1"},1]
[null,{"$f":"IF(Tool_5=\"\",\"-\",Tool_5)","v":"Bohrer 2"},1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_5_Examp=\"\",\"-\",Tool_5_Examp)","v":"Bohrer 2"},1]
[null,{"$f":"IF(Tool_6=\"\",\"-\",Tool_6)","v":"Bohrer 3"},1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_6_Examp=\"\",\"-\",Tool_6_Examp)","v":"Bohrer 3"},1]
[null,{"$f":"IF(Tool_7=\"\",\"-\",Tool_7)","v":"Bohrer 4"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_7_Examp=\"\",\"-\",Tool_7_Examp)","v":"Bohrer 4"},0]
[null,{"$f":"IF(Tool_8=\"\",\"-\",Tool_8)","v":"Gewindeschneider"},0.1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_8_Examp=\"\",\"-\",Tool_8_Examp)","v":"Gewindeschneider"},0.1]
[null,null,null,null,null,{"$f":"IFERROR(IF(AVERAGE(C48:C66)=1,\"complete in-house production\",IF(AVERAGE(C48:C66)=0,\"no in-house production\",\"avg. in-house prod. depth: \"&ROUND(AVERAGE(C48:C66)*100,0)&\"%\")),\"\")","v":"avg. in-house prod. depth: 29%"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AVERAGE(P48:P66)=1,\"complete in-house production\",IF(AVERAGE(P48:P66)=0,\"no in-house production\",\"avg. in-house prod. depth: \"&ROUND(AVERAGE(P48:P66)*100,0)&\"%\")),\"\")","v":"avg. in-house prod. depth: 29%"}]
[]
["Packaging",null,{"$f":"TRANSPOSE(KEA.Packaging.Name)","v":"wood"},"cardboard","plastic",null,null,null,null,null,null,null,null,"Packaging",null,{"$f":"TRANSPOSE(KEA.Packaging.Name)","v":"wood"},"cardboard","plastic"]
[null,{"$f":"B$9","v":"Machine structure"},100,10,10,null,null,null,null,null,null,null,null,null,{"$f":"O$9","v":"Machine structure"},100,10,10]
[null,{"$f":"B$11","v":"Modules"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$11","v":"Modules"}]
[null,{"$f":"IF(Module_1=\"\",\"-\",Module_1)","v":"Hauptspindel"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_1_Examp=\"\",\"-\",Module_1_Examp)","v":"Hauptspindel"}]
[null,{"$f":"IF(Module_2=\"\",\"-\",Module_2)","v":"Achse X1"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_2_Examp=\"\",\"-\",Module_2_Examp)","v":"Achse X1"}]
[null,{"$f":"IF(Module_3=\"\",\"-\",Module_3)","v":"Achse Y1"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_3_Examp=\"\",\"-\",Module_3_Examp)","v":"Achse Y1"}]
[null,{"$f":"IF(Module_4=\"\",\"-\",Module_4)","v":"Achse Z1"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_4_Examp=\"\",\"-\",Module_4_Examp)","v":"Achse Z1"}]
[null,{"$f":"IF(Module_5=\"\",\"-\",Module_5)","v":"Kabinett"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_5_Examp=\"\",\"-\",Module_5_Examp)","v":"Kabinett"}]
[null,{"$f":"IF(Module_6=\"\",\"-\",Module_6)","v":"KSM Pumpe"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_6_Examp=\"\",\"-\",Module_6_Examp)","v":"KSM Pumpe"}]
[null,{"$f":"IF(Module_7=\"\",\"-\",Module_7)","v":"Spindelkühlung"},20,1,1,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_7_Examp=\"\",\"-\",Module_7_Examp)","v":"Spindelkühlung"},20,1,1]
[null,{"$f":"IF(Module_8=\"\",\"-\",Module_8)","v":"Sinumerik"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_8_Examp=\"\",\"-\",Module_8_Examp)","v":"Sinumerik"}]
[null,{"$f":"B$28","v":"Tools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$28","v":"Tools"}]
[null,{"$f":"IF(Tool_1=\"\",\"-\",Tool_1)","v":"Fräser 1"},null,0.1,0.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_1_Examp=\"\",\"-\",Tool_1_Examp)","v":"Fräser 1"},null,0.1,0.2]
[null,{"$f":"IF(Tool_2=\"\",\"-\",Tool_2)","v":"Fräser 2"},null,0.1,0.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_2_Examp=\"\",\"-\",Tool_2_Examp)","v":"Fräser 2"},null,0.1,0.2]
[null,{"$f":"IF(Tool_3=\"\",\"-\",Tool_3)","v":"Fräser 3"},null,0.1,0.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_3_Examp=\"\",\"-\",Tool_3_Examp)","v":"Fräser 3"},null,0.1,0.2]
[null,{"$f":"IF(Tool_4=\"\",\"-\",Tool_4)","v":"Bohrer 1"},null,0.1,0.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_4_Examp=\"\",\"-\",Tool_4_Examp)","v":"Bohrer 1"},null,0.1,0.2]
[null,{"$f":"IF(Tool_5=\"\",\"-\",Tool_5)","v":"Bohrer 2"},null,0.1,0.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_5_Examp=\"\",\"-\",Tool_5_Examp)","v":"Bohrer 2"},null,0.1,0.2]
[null,{"$f":"IF(Tool_6=\"\",\"-\",Tool_6)","v":"Bohrer 3"},null,0.1,0.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_6_Examp=\"\",\"-\",Tool_6_Examp)","v":"Bohrer 3"},null,0.1,0.2]
[null,{"$f":"IF(Tool_7=\"\",\"-\",Tool_7)","v":"Bohrer 4"},null,0.1,0.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_7_Examp=\"\",\"-\",Tool_7_Examp)","v":"Bohrer 4"},null,0.1,0.2]
[null,{"$f":"IF(Tool_8=\"\",\"-\",Tool_8)","v":"Gewindeschneider"},null,0.1,0.2,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_8_Examp=\"\",\"-\",Tool_8_Examp)","v":"Gewindeschneider"},null,0.1,0.2]
[null,null,null,null,null,{"$f":"\"total packaging material: \"&IF(SUM(C70:E88)>1500,SUM(C70:E88)/1000&\" t\",SUM(C70:E88)&\" kg\")","v":"total packaging material: 144.4 kg"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"total packaging material: \"&IF(SUM(P70:R88)>1500,SUM(P70:R88)/1000&\" t\",SUM(P70:R88)&\" kg\")","v":"total packaging material: 144.4 kg"}]
[]
["Transportation",null,{"$f":"TRANSPOSE(KEA.Transportation.Name)","v":"lorry"},"ship","car","train","airplane",null,null,null,null,null,null,"Transportation",null,{"$f":"TRANSPOSE(KEA.Transportation.Name)","v":"lorry"},"ship","car","train","airplane"]
[null,{"$f":"B$9","v":"Machine structure"},100,12000,0,0,0,null,null,null,null,null,null,null,{"$f":"O$9","v":"Machine structure"},100,12000,0,0,0]
[null,{"$f":"B$11","v":"Modules"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$11","v":"Modules"}]
[null,{"$f":"IF(Module_1=\"\",\"-\",Module_1)","v":"Hauptspindel"},100,12000,0,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_1_Examp=\"\",\"-\",Module_1_Examp)","v":"Hauptspindel"},100,12000,0,0,0]
[null,{"$f":"IF(Module_2=\"\",\"-\",Module_2)","v":"Achse X1"},100,12000,0,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_2_Examp=\"\",\"-\",Module_2_Examp)","v":"Achse X1"},100,12000,0,0,0]
[null,{"$f":"IF(Module_3=\"\",\"-\",Module_3)","v":"Achse Y1"},100,12000,0,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_3_Examp=\"\",\"-\",Module_3_Examp)","v":"Achse Y1"},100,12000,0,0,0]
[null,{"$f":"IF(Module_4=\"\",\"-\",Module_4)","v":"Achse Z1"},100,12000,0,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_4_Examp=\"\",\"-\",Module_4_Examp)","v":"Achse Z1"},100,12000,0,0,0]
[null,{"$f":"IF(Module_5=\"\",\"-\",Module_5)","v":"Kabinett"},100,12000,0,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_5_Examp=\"\",\"-\",Module_5_Examp)","v":"Kabinett"},100,12000,0,0,0]
[null,{"$f":"IF(Module_6=\"\",\"-\",Module_6)","v":"KSM Pumpe"},100,12000,0,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_6_Examp=\"\",\"-\",Module_6_Examp)","v":"KSM Pumpe"},100,12000,0,0,0]
[null,{"$f":"IF(Module_7=\"\",\"-\",Module_7)","v":"Spindelkühlung"},100,12000,0,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_7_Examp=\"\",\"-\",Module_7_Examp)","v":"Spindelkühlung"},100,12000,0,0,0]
[null,{"$f":"IF(Module_8=\"\",\"-\",Module_8)","v":"Sinumerik"},100,0,0,0,10000,null,null,null,null,null,null,null,{"$f":"IF(Module_8_Examp=\"\",\"-\",Module_8_Examp)","v":"Sinumerik"},100,0,0,0,10000]
[null,{"$f":"B$28","v":"Tools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$28","v":"Tools"}]
[null,{"$f":"IF(Tool_1=\"\",\"-\",Tool_1)","v":"Fräser 1"},null,null,500,null,5000,null,null,null,null,null,null,null,{"$f":"IF(Tool_1_Examp=\"\",\"-\",Tool_1_Examp)","v":"Fräser 1"},null,null,500,null,5000]
[null,{"$f":"IF(Tool_2=\"\",\"-\",Tool_2)","v":"Fräser 2"},null,null,500,null,5000,null,null,null,null,null,null,null,{"$f":"IF(Tool_2_Examp=\"\",\"-\",Tool_2_Examp)","v":"Fräser 2"},null,null,500,null,5000]
[null,{"$f":"IF(Tool_3=\"\",\"-\",Tool_3)","v":"Fräser 3"},null,null,500,null,5000,null,null,null,null,null,null,null,{"$f":"IF(Tool_3_Examp=\"\",\"-\",Tool_3_Examp)","v":"Fräser 3"},null,null,500,null,5000]
[null,{"$f":"IF(Tool_4=\"\",\"-\",Tool_4)","v":"Bohrer 1"},null,12000,500,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_4_Examp=\"\",\"-\",Tool_4_Examp)","v":"Bohrer 1"},null,12000,500]
[null,{"$f":"IF(Tool_5=\"\",\"-\",Tool_5)","v":"Bohrer 2"},null,12000,500,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_5_Examp=\"\",\"-\",Tool_5_Examp)","v":"Bohrer 2"},null,12000,500]
[null,{"$f":"IF(Tool_6=\"\",\"-\",Tool_6)","v":"Bohrer 3"},null,12000,500,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_6_Examp=\"\",\"-\",Tool_6_Examp)","v":"Bohrer 3"},null,12000,500]
[null,{"$f":"IF(Tool_7=\"\",\"-\",Tool_7)","v":"Bohrer 4"},null,null,500,null,5000,null,null,null,null,null,null,null,{"$f":"IF(Tool_7_Examp=\"\",\"-\",Tool_7_Examp)","v":"Bohrer 4"},null,null,500,null,5000]
[null,{"$f":"IF(Tool_8=\"\",\"-\",Tool_8)","v":"Gewindeschneider"},null,12000,500,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_8_Examp=\"\",\"-\",Tool_8_Examp)","v":"Gewindeschneider"},null,12000,500]
[null,null,null,null,null,{"$f":"\"total transportation: \"&IF(SUM(C92:G92)<10000,SUM(C92:G92)&\" km\",ROUND(SUM(C92:G92)/40000,1)&\"x around the  globe\")","v":"total transportation: 0.3x around the  globe"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"total transportation: \"&IF(SUM(P92:T92)<10000,SUM(P92:T92)&\" km\",ROUND(SUM(P92:T92)/40000,1)&\"x around the  globe\")","v":"total transportation: 0.3x around the  globe"}]
[]
["Commissioning","Building materials",null,null,null,null,null,null,null,null,null,null,null,"Commissioning","Building materials"]
[null,"material","amount [kg]",null,null,null,null,null,null,null,null,null,null,null,"material","amount [kg]"]
[null,{"$f":"KEA.Construction.Name","v":"brick, concret"},100,null,null,null,null,null,null,null,null,null,null,null,{"$f":"KEA.Construction.Name","v":"brick, concret"},100]
[null,"cement",1000,null,null,null,null,null,null,null,null,null,null,null,"cement",1000]
[null,"sand, grevel",500,null,null,null,null,null,null,null,null,null,null,null,"sand, grevel",500]
[null,"steel, iron",1000,null,null,null,null,null,null,null,null,null,null,null,"steel, iron",1000]
[null,"type of infrastructure","specification",null,null,null,null,null,null,null,null,null,null,null,"type of infrastructure","specification"]
[null,{"$f":"IF(Infrastructure_1=\"\",\"-\",Infrastructure_1)","v":"Air conditioning"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Infrastructure_1=\"\",\"-\",Infrastructure_1)","v":"Air conditioning"}]
[null,{"$f":"IF(Infrastructure_2=\"\",\"-\",Infrastructure_2)","v":"Heating (fluid)"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Infrastructure_2=\"\",\"-\",Infrastructure_2)","v":"Heating (fluid)"}]
[null,{"$f":"IF(Infrastructure_3=\"\",\"-\",Infrastructure_3)","v":"Cooling (fluid)"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Infrastructure_3=\"\",\"-\",Infrastructure_3)","v":"Cooling (fluid)"}]
[null,{"$f":"IF(Infrastructure_4=\"\",\"-\",Infrastructure_4)","v":"Lubrication centre"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Infrastructure_4=\"\",\"-\",Infrastructure_4)","v":"Lubrication centre"}]
[null,null,null,null,null,{"$f":"\"additional material: \"&ROUND(SUM(C115:C118)/1000,1)&\"t\"","v":"additional material: 2.6t"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"additional material: \"&ROUND(SUM(P115:P118)/1000,1)&\"t\"","v":"additional material: 2.6t"}]
[]
["Operation","product lifetime [y]",5,null,null,null,null,null,null,null,null,null,null,"Operation","product lifetime [y]",2]
[]
[null,"Energy",null,null,null,null,null,null,null,null,null,null,null,null,"Energy"]
[null,null,"Rated / installed power and average consumption during machine states. The following state names are used:\n- Operation: The machine is processing one or multiple parts\n- Ready: The machine is not processing, but can start processing within \n           seconds.\n- Standby: The machine is in a reduced power state. Only basic modules\n           are running. A state transition into \"Ready\" is only possible within\n           minutes or hours (warm-up).\n- Off: The machine is shutdown (main switch off or power line \n           disconnected)",null,null,null,null,null,null,null,null,null,null,null,null,"Rated / installed power and average consumption during machine states. The following state names are used:\n- Operation: The machine is processing one or multiple parts\n- Ready: The machine is not processing, but can start processing within \n           seconds.\n- Standby: The machine is in a reduced power state. Only basic modules\n           are running. A state transition into \"Ready\" is only possible within\n           minutes or hours (warm-up).\n- Off: The machine is shutdown (main switch off or power line \n           disconnected)"]
[null,null,"installed power [W]","Operation [W]","Ready [W]","Standby [W]","Off [W]",null,null,null,null,null,null,null,null,"installed power [W]","Operation [W]","Ready [W]","Standby [W]","Off [W]"]
[null,{"$f":"B$9","v":"Machine structure"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$9","v":"Machine structure"},2000,2000,2000,2000,0]
[null,{"$f":"B$11","v":"Modules"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$11","v":"Modules"}]
[null,{"$f":"IF(Module_1=\"\",\"-\",Module_1)","v":"Hauptspindel"},70000,12000,1000,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_1_Examp=\"\",\"-\",Module_1_Examp)","v":"Hauptspindel"},70000,12000,1000,0,0]
[null,{"$f":"IF(Module_2=\"\",\"-\",Module_2)","v":"Achse X1"},10000,4000,200,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_2_Examp=\"\",\"-\",Module_2_Examp)","v":"Achse X1"},10000,4000,200,0,0]
[null,{"$f":"IF(Module_3=\"\",\"-\",Module_3)","v":"Achse Y1"},10000,4000,200,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_3_Examp=\"\",\"-\",Module_3_Examp)","v":"Achse Y1"},10000,4000,200,0,0]
[null,{"$f":"IF(Module_4=\"\",\"-\",Module_4)","v":"Achse Z1"},5000,800,200,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_4_Examp=\"\",\"-\",Module_4_Examp)","v":"Achse Z1"},5000,800,200,0,0]
[null,{"$f":"IF(Module_5=\"\",\"-\",Module_5)","v":"Kabinett"},5000,4000,2500,2500,0,null,null,null,null,null,null,null,{"$f":"IF(Module_5_Examp=\"\",\"-\",Module_5_Examp)","v":"Kabinett"},5000,4000,2500,2500,0]
[null,{"$f":"IF(Module_6=\"\",\"-\",Module_6)","v":"KSM Pumpe"},7000,7000,0,0,0,null,null,null,null,null,null,null,{"$f":"IF(Module_6_Examp=\"\",\"-\",Module_6_Examp)","v":"KSM Pumpe"},7000,7000,0,0,0]
[null,{"$f":"IF(Module_7=\"\",\"-\",Module_7)","v":"Spindelkühlung"},4000,2000,1800,1800,0,null,null,null,null,null,null,null,{"$f":"IF(Module_7_Examp=\"\",\"-\",Module_7_Examp)","v":"Spindelkühlung"},4000,2000,1800,1800,0]
[null,{"$f":"IF(Module_8=\"\",\"-\",Module_8)","v":"Sinumerik"},3000,200,200,200,100,null,null,null,null,null,null,null,{"$f":"IF(Module_8_Examp=\"\",\"-\",Module_8_Examp)","v":"Sinumerik"},3000,200,200,200,100]
[null,"Total Power",{"$f":"SUM(C131:C140)","v":114000},{"$f":"SUM(D131:D140)","v":34000},6100,4500,100,null,null,null,null,null,null,null,null,{"$f":"SUM(P131:P140)","v":116000},{"$f":"SUM(Q131:Q140)","v":36000},8100,6500,100]
[]
[null,"Resources (consumables)",null,null,null,null,null,null,null,null,null,null,null,null,"Consumables"]
[null,"In order to secure the process and machine conditions, operational materials are required. The requirement of materials may depend on the operational state of the machine.",null,null,null,null,null,null,null,null,null,null,null,null,"In order to secure the process and machine conditions, operational materials are required. The requirement of materials may depend on the operational state of the machine."]
[null,null,"Throughput","When",null,null,null,null,null,null,null,null,null,null,null,"Throughput","When"]
[null,{"$f":"KEA.Process.Name","v":"Oil (lubricant)"},1E-3,"Operation only","Lubricant required by the machine (no reuse)",null,null,null,null,null,null,null,null,null,{"$f":"KEA.Process.Name","v":"Oil (lubricant)"},1E-3,"Operation only"]
[null,"Pressured air",2,"Ready and higher","Compressed air flow rate at standard conditions (20°C, 1 bar)",null,null,null,null,null,null,null,null,null,"Pressured air",2,"If machine is on"]
[null,"Gas",null,null,"Process gas, e.g. nitrogen",null,null,null,null,null,null,null,null,null,"Gas"]
[null,"Water",60,"Operation only","Tap water consumed by the machine",null,null,null,null,null,null,null,null,null,"Water",60,"Operation only"]
[]
[null,"Services",null,null,null,null,null,null,null,null,null,null,null,null,"Services"]
[null,"Number of services",10,null,null,null,null,null,null,null,null,null,null,null,"Number of services",10]
[null,"Place","local",null,null,null,null,null,null,null,null,null,null,null,"Place","local"]
[null,"Transportation distance",200,null,null,null,null,null,null,null,null,null,null,null,"Transportation distance",200]
[null,"Transportation weight",{"$f":"IF(C153=\"local\",0.005*SUM(C10:G27),IF(C153=\"external\",SUM(C10:G27),\"\"))","v":23.169499999999999},{"$f":"IF(C153=\"local\",\"0.5% of total mass\",IF(C153=\"external\",\"Complete machine\",\"\"))","v":"0.5% of total mass"},null,null,null,null,null,null,null,null,null,null,"Transportation weight",{"$f":"IF(P153=\"local\",0.005*SUM(P10:T27),IF(P153=\"external\",SUM(P10:T27),\"\"))","v":23.169499999999999},{"$f":"IF(P153=\"local\",\"0.5% of total mass\",IF(P153=\"external\",\"Complete machine\",\"\"))","v":"0.5% of total mass"}]
[null,null,null,null,null,{"$f":"\"installed power: \"&IF(SUM(C131:C140)<1500,SUM(C131:C140)&\" W\",ROUND(SUM(C131:C140)/1000,0)&\" kW\")","v":"installed power: 114 kW"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"installed power: \"&IF(SUM(P131:P140)<1500,SUM(P131:P140)&\" W\",ROUND(SUM(P131:P140)/1000,0)&\" kW\")","v":"installed power: 116 kW"}]
[]
["Recycling",null,"recycling quota [%]",null,null,null,null,null,null,null,null,null,null,"Recycling",null,"recycling quota [%]"]
[null,{"$f":"B$9","v":"Machine structure"},0.9,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$9","v":"Machine structure"},0.9]
[null,{"$f":"B$11","v":"Modules"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$11","v":"Modules"}]
[null,{"$f":"IF(Module_1=\"\",\"-\",Module_1)","v":"Hauptspindel"},0.9,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_1_Examp=\"\",\"-\",Module_1_Examp)","v":"Hauptspindel"},0.9]
[null,{"$f":"IF(Module_2=\"\",\"-\",Module_2)","v":"Achse X1"},0.8,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_2_Examp=\"\",\"-\",Module_2_Examp)","v":"Achse X1"},0.8]
[null,{"$f":"IF(Module_3=\"\",\"-\",Module_3)","v":"Achse Y1"},0.8,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_3_Examp=\"\",\"-\",Module_3_Examp)","v":"Achse Y1"},0.8]
[null,{"$f":"IF(Module_4=\"\",\"-\",Module_4)","v":"Achse Z1"},0.8,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_4_Examp=\"\",\"-\",Module_4_Examp)","v":"Achse Z1"},0.8]
[null,{"$f":"IF(Module_5=\"\",\"-\",Module_5)","v":"Kabinett"},0.8,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_5_Examp=\"\",\"-\",Module_5_Examp)","v":"Kabinett"},0.8]
[null,{"$f":"IF(Module_6=\"\",\"-\",Module_6)","v":"KSM Pumpe"},0.9,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_6_Examp=\"\",\"-\",Module_6_Examp)","v":"KSM Pumpe"},0.9]
[null,{"$f":"IF(Module_7=\"\",\"-\",Module_7)","v":"Spindelkühlung"},0.9,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_7_Examp=\"\",\"-\",Module_7_Examp)","v":"Spindelkühlung"},0.9]
[null,{"$f":"IF(Module_8=\"\",\"-\",Module_8)","v":"Sinumerik"},0.6,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Module_8_Examp=\"\",\"-\",Module_8_Examp)","v":"Sinumerik"},0.6]
[null,{"$f":"B$28","v":"Tools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$28","v":"Tools"}]
[null,{"$f":"IF(Tool_1=\"\",\"-\",Tool_1)","v":"Fräser 1"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_1_Examp=\"\",\"-\",Tool_1_Examp)","v":"Fräser 1"},0]
[null,{"$f":"IF(Tool_2=\"\",\"-\",Tool_2)","v":"Fräser 2"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_2_Examp=\"\",\"-\",Tool_2_Examp)","v":"Fräser 2"},0]
[null,{"$f":"IF(Tool_3=\"\",\"-\",Tool_3)","v":"Fräser 3"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_3_Examp=\"\",\"-\",Tool_3_Examp)","v":"Fräser 3"},0]
[null,{"$f":"IF(Tool_4=\"\",\"-\",Tool_4)","v":"Bohrer 1"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_4_Examp=\"\",\"-\",Tool_4_Examp)","v":"Bohrer 1"},0]
[null,{"$f":"IF(Tool_5=\"\",\"-\",Tool_5)","v":"Bohrer 2"},1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_5_Examp=\"\",\"-\",Tool_5_Examp)","v":"Bohrer 2"},1]
[null,{"$f":"IF(Tool_6=\"\",\"-\",Tool_6)","v":"Bohrer 3"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_6_Examp=\"\",\"-\",Tool_6_Examp)","v":"Bohrer 3"},0]
[null,{"$f":"IF(Tool_7=\"\",\"-\",Tool_7)","v":"Bohrer 4"},0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_7_Examp=\"\",\"-\",Tool_7_Examp)","v":"Bohrer 4"},0]
[null,{"$f":"IF(Tool_8=\"\",\"-\",Tool_8)","v":"Gewindeschneider"},1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Tool_8_Examp=\"\",\"-\",Tool_8_Examp)","v":"Gewindeschneider"},1]
[null,null,null,null,null,{"$f":"IFERROR(IF(AVERAGE(C159:C177)=1,\"full recycling\",IF(AVERAGE(C159:C177)=0,\"no recycling\",ROUND(AVERAGE(C159:C177)*100,0)&\"% recycl.\")),\"\")","v":"55% recycl."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AVERAGE(P159:P177)=1,\"full recycling\",IF(AVERAGE(P159:P177)=0,\"no recycling\",ROUND(AVERAGE(P159:P177)*100,0)&\"% recycl.\")),\"\")","v":"55% recycl."}]

{"sheet":"Use","index":3,"n_rows":73,"n_cols":19,"rows_kept":73,"cut":false,"hidden":false,"merged":[[40,0,40,3],[42,1,42,3],[54,1,54,3],[67,1,67,3],[1,0,1,3],[4,1,4,2],[15,1,15,2],[20,1,20,2],[26,1,26,2],[31,1,31,2],[61,1,61,3],[1,10,1,13],[4,11,4,12],[15,11,15,12],[20,11,20,12],[26,11,26,12],[2,10,3,13],[2,14,3,14],[45,14,52,14],[56,14,59,14],[69,14,72,14],[31,11,31,12],[40,10,40,13],[42,11,42,13],[54,11,54,13],[67,11,67,13],[61,11,61,13]]}
[null,null,null,{"$f":"Version","v":"ET-MTED-V3R1"}]
["Machine Schedule",null,null,null,null,null,null,null,null,null,"Machine Schedule"]
[null,null,null,null,null,null,null,null,null,null,"EXAMPLE",null,null,null,"COMMENTS"]
[]
["Process time","General description of an intended process running on the machine",null,null,"Operation","Ready","Standby","Off",null,null,"Process time","General description of an intended process running on the machine",null,null,null,"Operation","Ready","Standby","Off"]
[null,null,null,null,{"$f":"C7","v":"00:04:30"},null,null,null,null,null,null,null,null,null,null,{"$f":"M7","v":"00:06:00"}]
[null,"Average cycle time [hh:mm:ss]",3.1249999999999997E-3,null,null,{"$f":"C8*C9","v":"00:00:10"},null,null,null,null,null,"Average cycle time [hh:mm:ss]","00:06:00",null,"Average cycle time is 6 minutes. This time does include the productive part of the cycle  only (no tool changes)",null,{"$f":"M8","v":"00:00:12"}]
[null,"Average time for one tool change [hh:mm:ss]",2.3148148148148147E-5,null,null,null,null,null,null,null,null,"Average tool change time  [hh:mm:ss]","00:00:12",null,"The tool changes for during one process take 1 minute of time, there are 5 tool changes in total"]
[null,"Number of tool changes per cycle",5,null,null,null,null,null,null,null,null,"Number of tool changes",5]
[null,"Batch size",200,null,null,null,null,null,null,null,null,"Batch size",200,null,"With one setting, a batch of 200 equal products is manufactured"]
[null,"Setting time [hh:mm:ss]",0.33333333333333331,null,{"$f":"IF($C12=E5,$C11/$C10,0)","v":"00:00:00"},{"$f":"IF($C12=F5,$C11/$C10,0)","v":"00:02:24"},"00:00:00","00:00:00",null,null,null,"Setting time [hh:mm:ss]","08:00:00",null,"To set up the machine for the batch, a day of work is required",{"$f":"IF($M12=P5,$M11/$M10,0)","v":"00:00:00"},{"$f":"IF($M12=Q5,$M11/$M10,0)","v":"00:02:24"},{"$f":"IF($M12=R5,$M11/$M10,0)","v":"00:00:00"},{"$f":"IF($M12=S5,$M11/$M10,0)","v":"00:00:00"}]
[null,"Machine state during setting","Ready",null,null,null,null,null,null,null,null,"Machine state during setting","Ready",null,"During the setting, the machine state is \"Ready\". So intermediate Operation is possible"]
[null,"Rework time",{"$f":"C65*C66","v":1.0416666666666666E-4}]
[null,"Part time",{"$f":"C7+C8*C9+IF(C10=0,0,C11/C10)+C13","v":5.0115740740740737E-3},null,{"$f":"E6+E11","v":"00:04:30"},{"$f":"F7+F11","v":"00:02:34"},{"$f":"G11","v":"00:00:00"},{"$f":"H11","v":"00:00:00"},null,null,null,"Part time",{"$f":"M7+M8+M11/M10","v":"00:08:36"},null,"Given the information above, an average part time of 9.5 minutes results",{"$f":"P6+P11","v":"00:06:00"},{"$f":"Q7+Q11","v":"00:02:36"},{"$f":"R11","v":"00:00:00"},{"$f":"S11","v":"00:00:00"}]
[]
["Day","Characterization of typical working day",null,null,null,null,null,null,null,null,"Day","Characterization of typical working day"]
[]
[null,"Number of shifts per day",2.5,null,{"$f":"8*$C18*(E14/$C14)","v":12.471131639722863},{"$f":"8*$C18*(F14/$C14)","v":7.1131639722863742},{"$f":"8*$C18*(G14/$C14)","v":0},0,null,null,null,"Number of shifts per day",2.5,null,"Two shifts per day take place. After the late shift, the machine runs until the job has finished (about 4 hours)",{"$f":"8*$M18*(P14/$M14)","v":13.953488372093021},{"$f":"8*$M18*(Q14/$M14)","v":6.0465116279069768},0,{"$f":"8*$M18*(S14/$M14)","v":0}]
[null,"Machine state during off duty","Standby",null,{"$f":"IF($C19=E$5,24-8*$C18,0)","v":0},{"$f":"IF($C19=F$5,24-8*$C18,0)","v":0},4,0,null,null,null,"Machine state during off duty","Ready",null,"After the machine finished the job, it stays in \"ready\" state",{"$f":"IF($M19=P$5,24-8*$M18,0)","v":0},{"$f":"IF($M19=Q$5,24-8*$M18,0)","v":4},0,0]
[null,null,null,null,{"$f":"SUM(E18:E19)","v":12.471131639722863},{"$f":"SUM(F18:F19)","v":7.1131639722863742},4,0,null,null,null,null,null,null,null,{"$f":"SUM(P18:P19)","v":13.953488372093021},{"$f":"SUM(Q18:Q19)","v":10.046511627906977},0,0]
["Week","Characterization of typical working week",null,null,null,null,null,null,null,null,"Week","Characterization of typical working week"]
[]
[]
[null,"Number of workdays",5,null,{"$f":"$C24*E20","v":62.355658198614314},{"$f":"$C24*F20","v":35.565819861431869},20,0,null,null,null,"Number of workdays",5,null,"The machine is only productive at workdays",{"$f":"$M24*P20","v":69.767441860465112},{"$f":"$M24*Q20","v":50.232558139534888},0,0]
[null,"Machine state during weekend","Off",null,{"$f":"IF($C25=E$5,(7-$C24)*24,0)","v":0},{"$f":"IF($C25=F$5,(7-$C24)*24,0)","v":0},0,48,null,null,null,"Machine state during weekend","Standby",null,"During the weekends the machine stays in the \"standby\" state",{"$f":"IF($M25=P$5,(7-$M24)*24,0)","v":0},{"$f":"IF($M25=Q$5,(7-$M24)*24,0)","v":0},48,0]
[null,null,null,null,{"$f":"SUM(E24:E25)","v":62.355658198614314},{"$f":"SUM(F24:F25)","v":35.565819861431869},{"$f":"SUM(G24:G25)","v":20},{"$f":"SUM(H24:H25)","v":48},null,null,null,null,null,null,null,{"$f":"SUM(P24:P25)","v":69.767441860465112},{"$f":"SUM(Q24:Q25)","v":50.232558139534888},48,0]
["Year","Characterisation of a typical year",null,null,null,null,null,null,null,null,"Year","Characterisation of a typical year"]
[]
[null,"Number of productive weeks",47,null,{"$f":"$C29*E26","v":2930.7159353348729},{"$f":"$C29*F26","v":1671.5935334872979},940,2256,null,null,null,"Number of productive weeks",47,null,"During 5 weeks per year, no operation takes place due to holyday",{"$f":"$M29*P26","v":3279.0697674418602},{"$f":"$M29*Q26","v":2360.9302325581398},{"$f":"$M29*R26","v":2256},0]
[null,"Machine state during holiday","Off",null,{"$f":"IF($C30=E$5,(52-$C29)*24*7,0)","v":0},{"$f":"IF($C30=F$5,(52-$C29)*24*7,0)","v":0},0,840,null,null,null,"Machine state during holiday","Off",null,"During this holyday, the machine is shut down",{"$f":"IF($M30=P$5,(52-$M29)*24*7,0)","v":0},{"$f":"IF($M30=Q$5,(52-$M29)*24*7,0)","v":0},0,{"$f":"IF($M30=S$5,(52-$M29)*24*7,0)","v":840}]
[null,null,null,null,{"$f":"SUM(E29:E30)","v":2930.7159353348729},{"$f":"SUM(F29:F30)","v":1671.5935334872979},{"$f":"SUM(G29:G30)","v":940},{"$f":"SUM(H29:H30)","v":3096},null,null,null,null,null,null,null,{"$f":"SUM(P29:P30)","v":3279.0697674418602},{"$f":"SUM(Q29:Q30)","v":2360.9302325581398},2256,840]
["Distribution","Resulting time distribution over the four machine states",null,null,null,null,null,null,null,null,"Distribution","Resulting time distribution over the four machine states"]
[]
[null,{"$f":"TRANSPOSE(E5:H5)","v":"Operation"},{"$f":"TRANSPOSE(E31:H31)*IF(SUM(E31:H31)=0,0,1/SUM(E31:H31))","v":0.33926961587942212},null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(P5:S5)","v":"Operation"},{"$f":"TRANSPOSE(P31:S31)/SUM(P31:S31)","v":0.37535139279325325}]
[null,"Ready",0.19350933646455928,null,null,null,null,null,null,null,null,"Ready",0.2702530028111424]
[null,"Standby",0.10881758790799242,null,null,null,null,null,null,null,null,"Standby",0.25824175824175827]
[null,"Off",0.35840345974802612,null,null,null,null,null,null,null,null,"Off",9.6153846153846159E-2]
[]
[]
[null,null,null,{"$f":"Version","v":"ET-MTED-V3R1"}]
["Machine Operation",null,null,null,null,null,null,null,null,null,"Machine Operation"]
[]
["Tools","Tools are required in a certain number dependent on the time in use and the holding time. Given on certain key values, the total number of tools required during machine use is calculated.",null,null,null,null,null,null,null,null,"Tools","Tools are required in a certain number dependent on the time in use and the holding time. Given on certain key values, the total number of tools required during machine use is calculated."]
[]
[null,"Name","Time fraction","holding time [min]","Fraction","Time",null,null,null,null,null,"Name","Time fraction","holding time [min]",null,"Fraction","Time"]
[null,{"$f":"Tools","v":"Fräser 1"},0.2,250,{"$f":"C46/SUM(C$46:C$53)","v":0.26666666666666661},{"$f":"MachineLifetime*365*24*60*C$34*C46","v":178320.11010622428},null,null,null,null,null,"Fräser 1",0.2,250,"During operation, different tools are used. The relative time distribution and holding times are estimated based on business statistics",{"$f":"M46/SUM(M$46:M$53)","v":0.26666666666666661},{"$f":"MachineLifetime*365*24*60*M$34*M46","v":197284.69205213393}]
[null,"Fräser 2",0.2,250,0.26666666666666661,178320.11010622428,null,null,null,null,null,"Fräser 2",0.2,250,null,0.26666666666666661,197284.69205213393]
[null,"Fräser 3",0.05,250,6.6666666666666652E-2,44580.02752655607,null,null,null,null,null,"Fräser 3",0.05,250,null,6.6666666666666652E-2,49321.173013033484]
[null,"Bohrer 1",0.1,250,0.1333333333333333,89160.055053112141,null,null,null,null,null,"Bohrer 1",0.1,250,null,0.1333333333333333,98642.346026066967]
[null,"Bohrer 2",0.05,250,6.6666666666666652E-2,44580.02752655607,null,null,null,null,null,"Bohrer 2",0.05,250,null,6.6666666666666652E-2,49321.173013033484]
[null,"Bohrer 3",0.05,250,6.6666666666666652E-2,44580.02752655607,null,null,null,null,null,"Bohrer 3",0.05,250,null,6.6666666666666652E-2,49321.173013033484]
[null,"Bohrer 4",0.05,250,6.6666666666666652E-2,44580.02752655607,null,null,null,null,null,"Bohrer 4",0.05,250,null,6.6666666666666652E-2,49321.173013033484]
[null,"Gewindeschneider",0.05,250,6.6666666666666652E-2,44580.02752655607,null,null,null,null,null,"Gewindeschneider",0.05,250,null,6.6666666666666652E-2,49321.173013033484]
[]
["Material","During the use phase, the machine processes materials. In general part of the input material are installed in the output product, where the rest becomes scrap. To calculate this mass flows, the following key values are required.",null,null,null,null,null,null,null,null,"Material","During the use phase, the machine processes materials. In general part of the input material are installed in the output product, where the rest becomes scrap. To calculate this mass flows, the following key values are required."]
[null,null,"Throughput","Mass in final prod.",null,null,null,null,null,null,null,null,"Throughput","Mass in final prod."]
[null,"steel, high-alloyed ",6,0.8,null,null,null,null,null,null,null,"steel, high-alloyed ",6,0.8,"The machine processes four materials at different rates. The mass installed in the product relative to the input mass is known from the amount of scrap material"]
[null,"aluminium, copper, brass",1,0.95,null,null,null,null,null,null,null,"aluminium, copper, brass",1,0.5]
[null,"steel, iron",10,0.95,null,null,null,null,null,null,null,"steel, iron",10,0.95]
[null,"PE, PP, PET, Polyester",2,0.99,null,null,null,null,null,null,null,"PE, PP, PET, Polyester",2,0.35]
[]
["Defects","Amount of non conformant parts, relative to the total number of parts produced. Defects are manufactured parts, which do not fullfill the requirements and are thus scraped. Reworked parts are products needing additional machine time in orter to statisfy the reuqirements.",null,null,null,null,null,null,null,null,"Defects","Amount of non conformant parts, relative to the total number of parts produced. Defects are manufactured parts, which do not fullfill the requirements and are thus scraped. Rework part are "]
[]
[null,"Defects (relative to the total number of parts)",5.0000000000000001E-3,null,null,null,null,null,null,null,null,"Defects (relative to the total number of parts)"]
[null,"Rework (relative to the total number of parts)",0.03]
[null,"Average re-work time per part",3.472222222222222E-3,null,null,null,null,null,null,null,null,"Average re-work time per part"]
[]
["Scrap","Scrap material can be post-process in various ways. Dependent on the path selected, different amounts of energy are required.",null,null,null,null,null,null,null,null,"Scrap","Scrap material can be post-process in various ways. Dependent on the path selected, different amounts of energy are required."]
[null,null,null,null,"Recycling","Burning","Land fill","Energy",null,null,null,null,null,null,null,"Recycling","Burning","Land fill","Energy"]
[null,{"$f":"IF(B57=\"\",\"\",B57)","v":"steel, high-alloyed "},"Recycling",null,{"$f":"IF(C70=E$69,INDEX(KEA.General.RawMaterial,MATCH(B70,KEA.General.Name,0))+INDEX(KEA.General.Recycling,MATCH(B70,KEA.General.Name,0)),0)","v":4.67},{"$f":"IF(C70=F$69,INDEX(KEA.General.RawMaterial,MATCH(B70,KEA.General.Name,0))-INDEX(KEA.General.Hu,MATCH(B70,KEA.General.Name,0)),0)","v":0},{"$f":"IF(C70=G$69,INDEX(KEA.General.RawMaterial,MATCH(B70,KEA.General.Name,0)),0)","v":0},{"$f":"SUM(E70:G70)","v":4.67},null,null,null,{"$f":"IF(L57=\"\",\"\",L57)","v":"steel, high-alloyed "},"Recycling",null,"The treatment of the scrap material depends on the raw material. A possible selection is shown.",{"$f":"IF(M70=P$69,INDEX(KEA.General.RawMaterial,MATCH(L70,KEA.General.Name,0))+INDEX(KEA.General.Recycling,MATCH(L70,KEA.General.Name,0)),0)","v":4.67},{"$f":"IF(M70=Q$69,INDEX(KEA.General.RawMaterial,MATCH(L70,KEA.General.Name,0))-INDEX(KEA.General.Hu,MATCH(L70,KEA.General.Name,0)),0)","v":0},{"$f":"IF(M70=R$69,INDEX(KEA.General.RawMaterial,MATCH(L70,KEA.General.Name,0)),0)","v":0},{"$f":"SUM(P70:R70)","v":4.67}]
[null,{"$f":"IF(B58=\"\",\"\",B58)","v":"aluminium, copper, brass"},"Recycling",null,{"$f":"IF(C71=E$69,INDEX(KEA.General.RawMaterial,MATCH(B71,KEA.General.Name,0))+INDEX(KEA.General.Recycling,MATCH(B71,KEA.General.Name,0)),0)","v":5.32},{"$f":"IF(C71=F$69,INDEX(KEA.General.RawMaterial,MATCH(B71,KEA.General.Name,0))-INDEX(KEA.General.Hu,MATCH(B71,KEA.General.Name,0)),0)","v":0},{"$f":"IF(C71=G$69,INDEX(KEA.General.RawMaterial,MATCH(B71,KEA.General.Name,0)),0)","v":0},{"$f":"SUM(E71:G71)","v":5.32},null,null,null,{"$f":"IF(L58=\"\",\"\",L58)","v":"aluminium, copper, brass"},"Recycling",null,null,{"$f":"IF(M71=P$69,INDEX(KEA.General.RawMaterial,MATCH(L71,KEA.General.Name,0))+INDEX(KEA.General.Recycling,MATCH(L71,KEA.General.Name,0)),0)","v":5.32},{"$f":"IF(M71=Q$69,INDEX(KEA.General.RawMaterial,MATCH(L71,KEA.General.Name,0))-INDEX(KEA.General.Hu,MATCH(L71,KEA.General.Name,0)),0)","v":0},{"$f":"IF(M71=R$69,INDEX(KEA.General.RawMaterial,MATCH(L71,KEA.General.Name,0)),0)","v":0},{"$f":"SUM(P71:R71)","v":5.32}]
[null,{"$f":"IF(B59=\"\",\"\",B59)","v":"steel, iron"},"Land fill",null,{"$f":"IF(C72=E$69,INDEX(KEA.General.RawMaterial,MATCH(B72,KEA.General.Name,0))+INDEX(KEA.General.Recycling,MATCH(B72,KEA.General.Name,0)),0)","v":0},{"$f":"IF(C72=F$69,INDEX(KEA.General.RawMaterial,MATCH(B72,KEA.General.Name,0))-INDEX(KEA.General.Hu,MATCH(B72,KEA.General.Name,0)),0)","v":0},{"$f":"IF(C72=G$69,INDEX(KEA.General.RawMaterial,MATCH(B72,KEA.General.Name,0)),0)","v":2.41},2.41,null,null,null,{"$f":"IF(L59=\"\",\"\",L59)","v":"steel, iron"},"Land fill",null,null,{"$f":"IF(M72=P$69,INDEX(KEA.General.RawMaterial,MATCH(L72,KEA.General.Name,0))+INDEX(KEA.General.Recycling,MATCH(L72,KEA.General.Name,0)),0)","v":0},{"$f":"IF(M72=Q$69,INDEX(KEA.General.RawMaterial,MATCH(L72,KEA.General.Name,0))-INDEX(KEA.General.Hu,MATCH(L72,KEA.General.Name,0)),0)","v":0},{"$f":"IF(M72=R$69,INDEX(KEA.General.RawMaterial,MATCH(L72,KEA.General.Name,0)),0)","v":2.41},2.41]
[null,{"$f":"IF(B60=\"\",\"\",B60)","v":"PE, PP, PET, Polyester"},"Burning",null,{"$f":"IF(C73=E$69,INDEX(KEA.General.RawMaterial,MATCH(B73,KEA.General.Name,0))+INDEX(KEA.General.Recycling,MATCH(B73,KEA.General.Name,0)),0)","v":0},{"$f":"IF(C73=F$69,INDEX(KEA.General.RawMaterial,MATCH(B73,KEA.General.Name,0))-INDEX(KEA.General.Hu,MATCH(B73,KEA.General.Name,0)),0)","v":2.91},{"$f":"IF(C73=G$69,INDEX(KEA.General.RawMaterial,MATCH(B73,KEA.General.Name,0)),0)","v":0},2.91,null,null,null,{"$f":"IF(L60=\"\",\"\",L60)","v":"PE, PP, PET, Polyester"},"Burning",null,null,{"$f":"IF(M73=P$69,INDEX(KEA.General.RawMaterial,MATCH(L73,KEA.General.Name,0))+INDEX(KEA.General.Recycling,MATCH(L73,KEA.General.Name,0)),0)","v":0},{"$f":"IF(M73=Q$69,INDEX(KEA.General.RawMaterial,MATCH(L73,KEA.General.Name,0))-INDEX(KEA.General.Hu,MATCH(L73,KEA.General.Name,0)),0)","v":2.91},{"$f":"IF(M73=R$69,INDEX(KEA.General.RawMaterial,MATCH(L73,KEA.General.Name,0)),0)","v":0},2.91]

{"sheet":"Infrastructure","index":4,"n_rows":35,"n_cols":22,"rows_kept":35,"cut":false,"hidden":false,"merged":[[17,19,17,21],[20,19,20,21],[26,19,26,21],[32,19,32,21],[36,2,36,4],[20,2,20,4],[26,2,26,4],[32,2,32,4],[1,0,1,4],[9,1,9,4],[4,1,4,4],[6,2,6,4],[17,2,17,4],[11,2,11,4],[12,1,14,1],[12,18,14,18],[11,19,11,21],[1,17,1,21],[4,18,4,21],[6,19,6,21],[9,18,9,21],[2,17,3,21]]}
[null,null,null,null,{"$f":"Version","v":"ET-MTED-V3R1"}]
["Infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infrastructure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXAMPLE"]
[]
["Energy supply","Characterizations about the electrical energy source used to supply the machine are required here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy supply","Characterizations about the electrical energy source used to supply the machine are required here"]
[]
[null,"Type of Energy source","EU-Mix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of Energy source","CH-Mix"]
[]
[]
["Infrastructures","Power demand and mode of operation for the infrastructure devices. As guideline, proposals for the power demand are given based on the machine parameters. Some of these proposals may require additional parameters.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infrastructures","Power demand and mode of operation for the infrastructure devices. As guideline, proposals for the power demand are given based on the machine parameters."]
[]
[null,"Building eff.-class","A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Building eff.-class","C"]
[null,"see: directive 2010/31/EU of the  European parliament ","COP Air cond.",{"$f":"IF(C12=\"\",0,INDEX(KEA.Building.COPAC,MATCH(C12,KEA.Building.Class,0)))","v":2.6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"see: directive 2010/31/EU of the  European parliament ","COP Air cond.",2.2999999999999998]
[null,null,"COP water cooling",{"$f":"IF(C12=\"\",0,INDEX(KEA.Building.COPWC,MATCH(C12,KEA.Building.Class,0)))","v":5.05},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP water cooling",4.45]
[null,null,null,null,null,null,null,null,null,"Operation only","Ready and higher","If machine is on","Always","Time"]
[null,null,"power","proposal","running",null,null,null,null,{"$f":"MachineLifetime*365*24*SUM(Calculation!$D115:D115)","v":14860.00917551869},{"$f":"MachineLifetime*365*24*SUM(Calculation!$D115:E115)","v":23335.718112666385},{"$f":"MachineLifetime*365*24*SUM(Calculation!$D115:F115)","v":28101.928463036456},{"$f":"MachineLifetime*365*24*SUM(Calculation!$D115:G115)","v":43800},null,null,null,null,null,null,"power","proposal","running"]
[null,{"$f":"Overview!B39","v":"Air conditioning"},4800,{"$f":"MAX(0,SUMPRODUCT(Calculation!D115:G115,Calculation!D114:G114)*1000-D28/60*3500*(-D29+D30))/D13","v":4756.189763036512},"Always",{"$f":"Overview!C39","v":"yes"},null,null,null,{"$f":"IF($E17=J$15,J$16,0)","v":0},{"$f":"IF($E17=K$15,K$16,0)","v":0},0,43800,{"$f":"SUM(J17:M17)","v":43800},null,null,null,null,{"$f":"Infrastructure_1","v":"Air conditioning"},500,512,"Always"]
[null,null,{"$f":"\"Assumption: All power supplied to the machine is transformed into heat. Heat released to the shop floor (i.e. by convection or by a water-air heat exchanger) must be removed by the shop floor climatization system. This process has typically an COP of \"&D13","v":"Assumption: All power supplied to the machine is transformed into heat. Heat released to the shop floor (i.e. by convection or by a water-air heat exchanger) must be removed by the shop floor climatization system. This process has typically an COP of 2.6"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumption: All power supplied to the machine is transformed into heat. Heat released to the shop floor (i.e. by convection or by a water-air heat exchanger) must be removed by the shop floor climatization system. This process has typically an COP of 2.5 (2015)."]
[]
[null,{"$f":"Overview!B40","v":"Heating (fluid)"},null,{"$f":"D22/60*3500*(D23-D24)/0.8","v":0},null,{"$f":"Overview!C40","v":"no"},null,null,null,{"$f":"IF($E20=J$15,J$16,0)","v":0},0,0,0,{"$f":"SUM(J20:M20)","v":0},null,null,null,null,{"$f":"Infrastructure_2","v":"Heating (fluid)"},null,{"$f":"U22/60*3500*(U23-U24)/0.8","v":0}]
[null,null,"Assumption: Glycol-Water heated with an efficiency of 80% to the desired inlet temperature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumption: Glycol-Water heated with an efficiency of 80% to the desired inlet temperature"]
[null,null,"Flow rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow rate",0]
[null,null,"Inlet Temperature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlet Temperature",30]
[null,null,"Outlet Temperature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outlet Temperature",25]
[]
[null,{"$f":"Overview!B41","v":"Cooling (fluid)"},200,{"$f":"-D28/60*3500*(D29-D30)/D14","v":173.26732673267324},"If machine is on",{"$f":"Overview!C41","v":"yes"},null,null,null,0,0,28101.928463036456,0,28101.928463036456,null,null,null,null,{"$f":"Infrastructure_3","v":"Cooling (fluid)"},200,218.74999999999997,"If machine is on"]
[null,null,{"$f":"\"Assumption:  Centralized cooling systems (glycol-water) have a COP in the region of \"&D14","v":"Assumption:  Centralized cooling systems (glycol-water) have a COP in the region of 5.05"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumption:  Centralized cooling systems (glycol-water) have a COP in the region of 4 (2015)"]
[null,null,"Flow rate",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow rate",5]
[null,null,"Inlet Temperature",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlet Temperature",20]
[null,null,"Outlet Temperature",23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outlet Temperature",23]
[]
[null,{"$f":"Overview!B42","v":"Lubrication centre"},350,{"$f":"D34/60/1000*D35*100000/0.5","v":333.33333333333331},"Operation only",{"$f":"Overview!C42","v":"yes"},null,null,null,14860.00917551869,0,0,0,14860.00917551869,null,null,null,null,{"$f":"Infrastructure_4","v":"Lubrication centre"},350,333.33333333333331,"Operation only"]
[null,null,"Assumption: A fluid is provided by a pump with 50% efficiency at the stated mass flow rate with the pressure indicated below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumption: Oil is provided by a pump with 50% efficiency at the stated mass flow rate with the pressure indicated below"]
[null,null,"Flow rate",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow rate",10]
[null,null,"Pressure",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressure",10]

{"sheet":"Results","index":5,"n_rows":103,"n_cols":25,"rows_kept":103,"cut":false,"hidden":false,"merged":[[80,5,90,8],[24,1,24,7],[1,0,1,8],[64,5,77,8],[14,2,14,3],[15,2,15,3],[16,2,16,3],[22,1,22,8],[3,1,3,7],[10,1,10,7],[80,15,90,18],[1,10,1,18],[14,12,14,13],[15,12,15,13],[16,12,16,13],[24,11,24,17],[64,15,77,18],[2,10,2,18],[22,11,22,18],[3,11,3,17],[10,11,10,17]]}
[null,null,null,null,null,null,null,null,{"$f":"Version","v":"ET-MTED-V3R1"}]
["Results",null,null,null,null,null,null,null,null,null,"Results"]
[null,null,null,null,null,null,null,null,null,null,"EXPAMLE"]
["Type","Select the frame of reference for the analysis (over the annual produced fleet, per machine or per part manufactured on a machine)",null,null,null,null,null,null,null,null,"Type","Select the frame of reference for the analysis (over the annual produced fleet, per machine or per part manufactured on a machine)"]
[null,"Results based on:","machine",null,null,null,null,null,null,null,null,"Results based on:","machine"]
[null,"factor",{"$f":"VLOOKUP(C5,$B$7:$C$9,2,FALSE)","v":1},null,null,null,null,null,null,null,null,"factor",{"$f":"VLOOKUP(M5,$B$7:$C$9,2,FALSE)","v":1}]
[null,"fleet",{"$f":"MachineUnitsSold","v":12},null,null,null,null,null,null,null,null,"fleet",{"$f":"MachineUnitsSold","v":12}]
[null,"machine",1,null,null,null,null,null,null,null,null,"machine",1]
[null,"part",{"$f":"1/Calculation!C154","v":8.0940581097305732E-6},null,null,null,null,null,null,null,null,"part",{"$f":"1/Calculation!M154","v":{"$error":"#DIV/0!"}}]
[]
["Unit","Select the desired unit for the analysis",null,null,null,null,null,null,null,null,"Unit","Select the desired unit for the analysis"]
[null,"Reference unit","kg CO2 eq.",null,null,null,null,null,null,null,null,"Reference unit","kg CO2 eq."]
[null,null,{"$f":"\"[\"&C12&\"]\"","v":"[kg CO2 eq.]"}]
[]
["General","Machine name",{"$f":"MachineName","v":"Test"},null,null,null,null,null,null,null,"General","Machine name",{"$f":"MachineName_Examp","v":"Test"}]
[null,"Company",{"$f":"MachineProducer","v":"My Company"},null,null,null,null,null,null,null,null,"Company",{"$f":"MachineProducer_Examp","v":"My Company"}]
[null,{"$f":"\"Impact [\"&C12&\"]\"","v":"Impact [kg CO2 eq.]"},{"$f":"SUM(C41:H41)","v":518766.75524165895},null,null,null,null,null,null,null,null,"Energy per machine",{"$f":"SUM(M41:R41)","v":257292.54823367935}]
[null,null,"Total","Share",null,null,null,null,null,null,null,null,"Total","Share"]
["Type","Passive Impact ",{"$f":"SUM(C41:F41,H41)","v":27329.358169503546},{"$f":"C19/SUM(C19:C20)","v":5.2681398515547928E-2},null,null,null,null,null,null,"Type","Passive Energy",{"$f":"SUM(M41:P41,R41)","v":27329.358169503546},{"$f":"M19/SUM(M19:M20)","v":0.10621900384259228}]
[null,"Active Impact",{"$f":"G41","v":491437.39707215538},{"$f":"C20/SUM(C19:C20)","v":0.94731860148445202},null,null,null,null,null,null,null,"Active Energy",{"$f":"Q41","v":229963.19006417581},{"$f":"M20/SUM(M19:M20)","v":0.8937809961574078}]
[]
[]
[null,{"$f":"IF(D20<0.25,\"Passive product\",IF(D20<0.5,\"Product with passive characteristics\",IF(D20<0.75,\"Product with active characteristics\",\"Active Product\")))","v":"Active Product"},null,null,null,null,null,null,null,null,null,{"$f":"IF(N20<0.25,\"Passive product\",IF(N20<0.5,\"Product with passive characteristics\",IF(N20<0.75,\"Product with active characteristics\",\"Active Product\")))","v":"Active Product"}]
[]
["Life-Cycle","Results of the life-cycle analysis. For each machine life phase, the demand for primary energy is given in MJ. If available, the life phase specific consumption is split into different consumers",null,null,null,null,null,null,null,null,"Life-Cycle","Results of the life-cycle analysis. For each machine life phase, the demand for primary energy is given in MJ. If available, the life phase specific consumption is split into different consumers"]
[]
[null,null,"Raw Material","Purchasing & Production","Transportation & Packaging","Commissioning","Operation","Recycling",null,null,null,null,"Raw Material","Purchasing & Production","Transportation & Packaging","Commissioning","Operation","Recycling"]
[null,"Raw material",{"$f":"Calculation!L8*$C$6","v":17584.911},null,null,null,null,null,null,null,null,"Raw material",17584.911]
[null,"Production",null,{"$f":"Calculation!L30*$C$6","v":2122.0912500000004},null,null,null,null,null,null,null,"Production",null,2122.0912500000004]
[null,"Purchasing",null,{"$f":"Calculation!L31*$C$6","v":3600.6545833333339},null,null,null,null,null,null,null,"Purchasing",null,3600.6545833333339]
[null,"Packaging",null,null,{"$f":"Calculation!L53*$C$6","v":115.21893617021277},null,null,null,null,null,null,"Packaging",null,null,115.21893617021277]
[null,"Transportation",null,null,{"$f":"Calculation!L76*$C$6","v":782.4824000000001},null,null,null,null,null,null,"Transportation",null,null,782.4824000000001]
[null,"Commissioning",null,null,null,{"$f":"Calculation!L97*$C$6","v":3124},null,null,null,null,null,"Commissioning",null,null,null,3124]
[null,"Energy",null,null,null,null,{"$f":"Calculation!L112*$C$6","v":255182.35169442315},null,null,null,null,"Energy",null,null,null,null,64346.291208791205]
[null,"Tools",null,null,null,null,{"$f":"Calculation!L128*$C$6","v":10936.907313145055},null,null,null,null,"Tools",null,null,null,null,11070.269505494507]
[null,"Infrastructure",null,null,null,null,{"$f":"Calculation!L137*$C$6","v":97267.011117777103},null,null,null,null,"Infrastructure",null,null,null,null,29788.211538461535]
[null,"Resources",null,null,null,null,{"$f":"Calculation!L142*$C$6","v":17344.074353783617},null,null,null,null,"Resources",null,null,null,null,17459.053021978016]
[null,"Scrap material",null,null,null,null,{"$f":"Calculation!L147*$C$6","v":110699.63835302647},null,null,null,null,"Scrap material",null,null,null,null,107291.95054945054]
[null,"Services",null,null,null,null,{"$f":"Calculation!L152*$C$6","v":7.4142399999999995},null,null,null,null,"Services",null,null,null,null,7.4142399999999995]
[null,"Recycling",null,null,null,null,null,{"$f":"Calculation!L159*$C$6","v":0},null,null,null,"Recycling",null,null,null,null,null,0]
[null,"Total",{"$f":"SUM(C28:C40)","v":17584.911},{"$f":"SUM(D28:D40)","v":5722.7458333333343},897.70133617021293,3124,491437.39707215538,0,null,null,null,"Total",17584.911,5722.7458333333343,897.70133617021293,3124,229963.19006417581,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Machine States",null,null,null,null,"The state specific energy consumption describes the ratio between the electric energy consumption in all machine states relative to the total energy consumptions over the whole machine life time.\n\nThe following states are used:\n- Operation: The machine is processing one or multiple parts\n- Ready: The machine is not processing, but can start processing within \n           seconds.\n- Standby: The machine is in a reduced power state. Only basic modules\n           are running. A state transition into \"Ready\" is only possible within\n           minutes or hours (warm-up).\n- Off: The machine is shutdown (main switch off or power line \n           disconnected)",null,null,null,null,"Energy demand",null,null,null,null,"The state specific energy consumption describes the ratio between the electric energy consumption in all machine states relative to the total energy consumptions over the whole machine life time.\n\nThe following states are used:\n- Operation: The machine is processing one or multiple parts\n- Ready: The machine is not processing, but can start processing within \n           seconds.\n- Standby: The machine is in a reduced power state. Only basic modules\n           are running. A state transition into \"Ready\" is only possible within\n           minutes or hours (warm-up).\n- Off: The machine is shutdown (main switch off or power line \n           disconnected)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Installed power compared to power consumptions over all machine states. The installed power is equal to the sum of rated powers of all machine modules.",null,null,null,null,null,null,null,null,null,"Installed power compared to power consumptions over all machine states. The installed power is equal to the sum of rated powers of all machine modules."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"installed power [W]","Operation","Ready","Standby","Off"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,36,8.1,6.5,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1017989.0109890109,201561.82417582418,138220.28571428574,791.76923076923094]
[]
[]
[]
[]
[]
[]
[]
[]
["Components","Component","Total",{"$f":"Calculation!D113","v":"Operation"},{"$f":"Calculation!E113","v":"Ready"},{"$f":"Calculation!F113","v":"Standby"},{"$f":"Calculation!G113","v":"Off"},null,null,null,"Components","Component","Total",{"$f":"D93","v":"Operation"},{"$f":"E93","v":"Ready"},"Standby","Off"]
[null,{"$f":"Calculation!B118","v":"Machine structure"},{"$f":"Calculation!H118*$C$6","v":0},{"$f":"Calculation!D118*$C$6","v":0},{"$f":"Calculation!E118*$C$6","v":0},{"$f":"Calculation!F118*$C$6","v":0},{"$f":"Calculation!G118*$C$6","v":0},null,null,null,null,"Machine structure",31831.35196527806,12525.453291688636,10688.386808907642,8617.5118646817828,0]
[null,{"$f":"Calculation!B119","v":"Hauptspindel"},{"$f":"Calculation!H119*$C$6","v":186795.81904337197},{"$f":"Calculation!D119*$C$6","v":178320.11010622428},{"$f":"Calculation!E119*$C$6","v":8475.7089371476959},{"$f":"Calculation!F119*$C$6","v":0},{"$f":"Calculation!G119*$C$6","v":0},null,null,null,null,"Hauptspindel",80496.913154585651,75152.71975013183,5344.1934044538211,0,0]
[null,{"$f":"Calculation!B120","v":"Achse X1"},{"$f":"Calculation!H120*$C$6","v":61135.178489504295},{"$f":"Calculation!D120*$C$6","v":59440.036702074758},{"$f":"Calculation!E120*$C$6","v":1695.1417874295394},{"$f":"Calculation!F120*$C$6","v":0},{"$f":"Calculation!G120*$C$6","v":0},null,null,null,null,"Achse X1",26119.745264268036,25050.906583377273,1068.838680890764,0,0]
[null,{"$f":"Calculation!B121","v":"Achse Y1"},{"$f":"Calculation!H121*$C$6","v":61135.178489504295},{"$f":"Calculation!D121*$C$6","v":59440.036702074758},{"$f":"Calculation!E121*$C$6","v":1695.1417874295394},{"$f":"Calculation!F121*$C$6","v":0},{"$f":"Calculation!G121*$C$6","v":0},null,null,null,null,"Achse Y1",26119.745264268036,25050.906583377273,1068.838680890764,0,0]
[null,{"$f":"Calculation!B122","v":"Achse Z1"},{"$f":"Calculation!H122*$C$6","v":13583.149127844492},{"$f":"Calculation!D122*$C$6","v":11888.007340414952},{"$f":"Calculation!E122*$C$6","v":1695.1417874295394},{"$f":"Calculation!F122*$C$6","v":0},{"$f":"Calculation!G122*$C$6","v":0},null,null,null,null,"Achse Z1",6079.0199975662199,5010.1813166754555,1068.838680890764,0,0]
[null,{"$f":"Calculation!B123","v":"Kabinett"},{"$f":"Calculation!H123*$C$6","v":92544.83492086918},{"$f":"Calculation!D123*$C$6","v":59440.036702074758},{"$f":"Calculation!E123*$C$6","v":21189.272342869241},{"$f":"Calculation!F123*$C$6","v":11915.52587592517},{"$f":"Calculation!G123*$C$6","v":0},null,null,null,null,"Kabinett",49183.279925364055,25050.906583377273,13360.483511134549,10771.889830852229,0]
[null,{"$f":"Calculation!B124","v":"KSM Pumpe"},{"$f":"Calculation!H124*$C$6","v":104020.06422863083},{"$f":"Calculation!D124*$C$6","v":104020.06422863083},{"$f":"Calculation!E124*$C$6","v":0},{"$f":"Calculation!F124*$C$6","v":0},{"$f":"Calculation!G124*$C$6","v":0},null,null,null,null,"KSM Pumpe",43839.086520910234,43839.086520910234,0,0,0]
[null,{"$f":"Calculation!B125","v":"Spindelkühlung"},{"$f":"Calculation!H125*$C$6","v":53555.473068569358},{"$f":"Calculation!D125*$C$6","v":29720.018351037379},{"$f":"Calculation!E125*$C$6","v":15256.276086865853},{"$f":"Calculation!F125*$C$6","v":8579.1786306661234},{"$f":"Calculation!G125*$C$6","v":0},null,null,null,null,"Spindelkühlung",29900.762097919116,12525.453291688636,9619.5481280168751,7755.7606782136045,0]
[null,{"$f":"Calculation!B126","v":"Sinumerik"},{"$f":"Calculation!H126*$C$6","v":7190.1928463036456},{"$f":"Calculation!D126*$C$6","v":2972.0018351037379},{"$f":"Calculation!E126*$C$6","v":1695.1417874295394},{"$f":"Calculation!F126*$C$6","v":953.24207007401367},{"$f":"Calculation!G126*$C$6","v":1569.8071536963546},null,null,null,null,"Sinumerik",3343.5675982639032,1252.5453291688639,1068.838680890764,861.75118646817828,160.43240173609703]
[null,"Sum",{"$f":"SUM(C94:C102)","v":579959.89021459816},{"$f":"SUM(D94:D102)","v":505240.31196763553},51701.824516600944,21447.946576665308,1569.8071536963546,null,null,null,null,"Sum",{"$f":"SUM(M94:M102)","v":296913.47178842331},{"$f":"SUM(N94:N102)","v":225458.15925039549},{"$f":"SUM(O94:O102)","v":43287.966576075945},{"$f":"SUM(P94:P102)","v":28006.913560215798},{"$f":"SUM(Q94:Q102)","v":160.43240173609703}]

{"sheet":"Comparision","index":6,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,1,8]]}
[null,null,null,null,null,null,null,null,{"$f":"Version","v":"ET-MTED-V3R1"}]
["Comparision (Version Manager)"]
[]
["Settings","Frame of reference",{"$f":"Results!C5","v":"machine"}]
[null,"Unit",{"$f":"Results!C12","v":"kg CO2 eq."}]
[null,null,{"$f":"Comparision!$C$4&\" [\"&Comparision!$C$5&\"]\"","v":"machine [kg CO2 eq.]"}]
[]
[]
["Results","File","Version","Raw Material","Purchasing & Production","Transportation & Packaging","Commissioning","Operation","Recycling","BON [kWh]","productivity, time share [%]","productivity, quantity [Pc/a]"]
[]
[null,null,"Working",{"$f":"RESULTS","v":17584.911},5722.7458333333343,897.70133617021293,3124,491437.39707215538,0,{"$f":"(Calculation!E117+Calculation!F117+Calculation!G117)*Results!$C$6","v":32876.614428663546},{"$f":"Calculation!D115","v":0.33926961587942212},{"$f":"Calculation!C154","v":123547.42039692214}]
[null,null,"Average",{"$f":"AVERAGE(D$10:D11)","v":17584.911},{"$f":"AVERAGE(E$10:E11)","v":5722.7458333333343},{"$f":"AVERAGE(F$10:F11)","v":897.70133617021293},{"$f":"AVERAGE(G$10:G11)","v":3124},{"$f":"AVERAGE(H$10:H11)","v":491437.39707215538},{"$f":"AVERAGE(I$10:I11)","v":0},{"$f":"AVERAGE(J$10:J11)","v":32876.614428663546},{"$f":"AVERAGE(K$10:K11)","v":0.33926961587942212},{"$f":"AVERAGE(L$10:L11)","v":123547.42039692214}]
[null,null,"Minimum",{"$f":"MIN(D$10:D11)","v":17584.911},{"$f":"MIN(E$10:E11)","v":5722.7458333333343},{"$f":"MIN(F$10:F11)","v":897.70133617021293},{"$f":"MIN(G$10:G11)","v":3124},{"$f":"MIN(H$10:H11)","v":491437.39707215538},{"$f":"MIN(I$10:I11)","v":0},{"$f":"MIN(J$10:J11)","v":32876.614428663546},{"$f":"MIN(K$10:K11)","v":0.33926961587942212},{"$f":"MIN(L$10:L11)","v":123547.42039692214}]
[null,null,"Maximum",{"$f":"MAX(D$10:D11)","v":17584.911},{"$f":"MAX(E$10:E11)","v":5722.7458333333343},{"$f":"MAX(F$10:F11)","v":897.70133617021293},{"$f":"MAX(G$10:G11)","v":3124},{"$f":"MAX(H$10:H11)","v":491437.39707215538},{"$f":"MAX(I$10:I11)","v":0},{"$f":"MAX(J$10:J11)","v":32876.614428663546},{"$f":"MAX(K$10:K11)","v":0.33926961587942212},{"$f":"MAX(L$10:L11)","v":123547.42039692214}]
[null,null,"Improvement",{"$f":"D14-D13","v":0},{"$f":"E14-E13","v":0},0,0,0,0,{"$f":"J14-J13","v":0},0,0]

{"sheet":"Calculation","index":7,"n_rows":176,"n_cols":13,"rows_kept":176,"cut":false,"hidden":true,"merged":[[0,10,0,11],[155,0,175,0],[107,0,151,0],[111,3,111,6],[0,0,0,7],[2,1,2,6],[5,0,24,0],[26,0,46,0],[71,0,92,0],[94,0,105,0],[48,0,69,0]]}
["Eco Tool-light Machine tool edition",null,null,null,null,null,null,null,null,null,"Output",null,"Comments"]
[]
["Overview","TODO"]
[]
[]
["Raw materials",null,"Impact Material 1","Impact Material 2","Impact Material 3","Impact Material 4","Impact Material 5","Impact","Mass"]
[null,"Machine"]
[null,"Machine structure",{"$f":"IF(LifeCycle!C9=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C9,KEA.General.Name,0)))*LifeCycle!C10","v":4820},{"$f":"IF(LifeCycle!D9=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D9,KEA.General.Name,0)))*LifeCycle!D10","v":3200},{"$f":"IF(LifeCycle!E9=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E9,KEA.General.Name,0)))*LifeCycle!E10","v":1064},{"$f":"IF(LifeCycle!F9=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F9,KEA.General.Name,0)))*LifeCycle!F10","v":58.99},{"$f":"IF(LifeCycle!G9=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G9,KEA.General.Name,0)))*LifeCycle!G10","v":0},{"$f":"SUM(C8:G8)","v":9142.99},{"$f":"SUM(LifeCycle!C10:G10)","v":4201},null,"Raw material",{"$f":"SUM(H8:H16)","v":17584.911}]
[null,{"$f":"Modules","v":"Hauptspindel"},{"$f":"IF(LifeCycle!C12=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C12,KEA.General.Name,0)))*LifeCycle!C13","v":140.1},{"$f":"IF(LifeCycle!D12=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D12,KEA.General.Name,0)))*LifeCycle!D13","v":425.6},{"$f":"IF(LifeCycle!E12=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E12,KEA.General.Name,0)))*LifeCycle!E13","v":589.9},{"$f":"IF(LifeCycle!F12=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F12,KEA.General.Name,0)))*LifeCycle!F13","v":0},{"$f":"IF(LifeCycle!G12=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G12,KEA.General.Name,0)))*LifeCycle!G13","v":0},{"$f":"SUM(C9:G9)","v":1155.5999999999999},{"$f":"SUM(LifeCycle!C13:G13)","v":120}]
[null,"Achse X1",{"$f":"IF(LifeCycle!C14=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C14,KEA.General.Name,0)))*LifeCycle!C15","v":233.5},{"$f":"IF(LifeCycle!D14=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D14,KEA.General.Name,0)))*LifeCycle!D15","v":53.2},{"$f":"IF(LifeCycle!E14=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E14,KEA.General.Name,0)))*LifeCycle!E15","v":58.99},{"$f":"IF(LifeCycle!F14=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F14,KEA.General.Name,0)))*LifeCycle!F15","v":0},{"$f":"IF(LifeCycle!G14=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G14,KEA.General.Name,0)))*LifeCycle!G15","v":0},345.69,{"$f":"SUM(LifeCycle!C15:G15)","v":61}]
[null,"Achse Y1",{"$f":"IF(LifeCycle!C16=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C16,KEA.General.Name,0)))*LifeCycle!C17","v":233.5},{"$f":"IF(LifeCycle!D16=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D16,KEA.General.Name,0)))*LifeCycle!D17","v":53.2},{"$f":"IF(LifeCycle!E16=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E16,KEA.General.Name,0)))*LifeCycle!E17","v":58.99},{"$f":"IF(LifeCycle!F16=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F16,KEA.General.Name,0)))*LifeCycle!F17","v":0},{"$f":"IF(LifeCycle!G16=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G16,KEA.General.Name,0)))*LifeCycle!G17","v":0},345.69,{"$f":"SUM(LifeCycle!C17:G17)","v":61}]
[null,"Achse Z1",{"$f":"IF(LifeCycle!C18=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C18,KEA.General.Name,0)))*LifeCycle!C19","v":140.1},{"$f":"IF(LifeCycle!D18=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D18,KEA.General.Name,0)))*LifeCycle!D19","v":26.6},{"$f":"IF(LifeCycle!E18=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E18,KEA.General.Name,0)))*LifeCycle!E19","v":29.495000000000001},{"$f":"IF(LifeCycle!F18=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F18,KEA.General.Name,0)))*LifeCycle!F19","v":0},{"$f":"IF(LifeCycle!G18=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G18,KEA.General.Name,0)))*LifeCycle!G19","v":0},196.19499999999999,{"$f":"SUM(LifeCycle!C19:G19)","v":35.5}]
[null,"Kabinett",{"$f":"IF(LifeCycle!C20=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C20,KEA.General.Name,0)))*LifeCycle!C21","v":36.150000000000006},{"$f":"IF(LifeCycle!D20=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D20,KEA.General.Name,0)))*LifeCycle!D21","v":5899},{"$f":"IF(LifeCycle!E20=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E20,KEA.General.Name,0)))*LifeCycle!E21","v":0},{"$f":"IF(LifeCycle!F20=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F20,KEA.General.Name,0)))*LifeCycle!F21","v":0},{"$f":"IF(LifeCycle!G20=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G20,KEA.General.Name,0)))*LifeCycle!G21","v":0},5935.15,{"$f":"SUM(LifeCycle!C21:G21)","v":115}]
[null,"KSM Pumpe",{"$f":"IF(LifeCycle!C22=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C22,KEA.General.Name,0)))*LifeCycle!C23","v":12.05},{"$f":"IF(LifeCycle!D22=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D22,KEA.General.Name,0)))*LifeCycle!D23","v":63.84},{"$f":"IF(LifeCycle!E22=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E22,KEA.General.Name,0)))*LifeCycle!E23","v":11.798000000000002},{"$f":"IF(LifeCycle!F22=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F22,KEA.General.Name,0)))*LifeCycle!F23","v":0},{"$f":"IF(LifeCycle!G22=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G22,KEA.General.Name,0)))*LifeCycle!G23","v":0},87.688000000000002,{"$f":"SUM(LifeCycle!C23:G23)","v":17.2}]
[null,"Spindelkühlung",{"$f":"IF(LifeCycle!C24=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C24,KEA.General.Name,0)))*LifeCycle!C25","v":7.23},{"$f":"IF(LifeCycle!D24=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D24,KEA.General.Name,0)))*LifeCycle!D25","v":42.56},{"$f":"IF(LifeCycle!E24=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E24,KEA.General.Name,0)))*LifeCycle!E25","v":11.798000000000002},{"$f":"IF(LifeCycle!F24=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F24,KEA.General.Name,0)))*LifeCycle!F25","v":0},{"$f":"IF(LifeCycle!G24=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G24,KEA.General.Name,0)))*LifeCycle!G25","v":0},61.588000000000008,{"$f":"SUM(LifeCycle!C25:G25)","v":11.2}]
[null,"Sinumerik",{"$f":"IF(LifeCycle!C26=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C26,KEA.General.Name,0)))*LifeCycle!C27","v":4.82},{"$f":"IF(LifeCycle!D26=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D26,KEA.General.Name,0)))*LifeCycle!D27","v":14.55},{"$f":"IF(LifeCycle!E26=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E26,KEA.General.Name,0)))*LifeCycle!E27","v":294.95},{"$f":"IF(LifeCycle!F26=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F26,KEA.General.Name,0)))*LifeCycle!F27","v":0},{"$f":"IF(LifeCycle!G26=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G26,KEA.General.Name,0)))*LifeCycle!G27","v":0},314.32,{"$f":"SUM(LifeCycle!C27:G27)","v":12}]
[null,"Tools"]
[null,{"$f":"Tools","v":"Fräser 1"},{"$f":"IF(LifeCycle!C29=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C29,KEA.General.Name,0)))*LifeCycle!C30","v":0.96400000000000008},{"$f":"IF(LifeCycle!D29=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D29,KEA.General.Name,0)))*LifeCycle!D30","v":0},{"$f":"IF(LifeCycle!E29=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E29,KEA.General.Name,0)))*LifeCycle!E30","v":0},{"$f":"IF(LifeCycle!F29=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F29,KEA.General.Name,0)))*LifeCycle!F30","v":0},{"$f":"IF(LifeCycle!G29=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G29,KEA.General.Name,0)))*LifeCycle!G30","v":0},{"$f":"SUM(C18:G18)","v":0.96400000000000008},{"$f":"SUM(LifeCycle!C30:G30)","v":0.4}]
[null,"Fräser 2",{"$f":"IF(LifeCycle!C31=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C31,KEA.General.Name,0)))*LifeCycle!C32","v":0.72299999999999998},{"$f":"IF(LifeCycle!D31=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D31,KEA.General.Name,0)))*LifeCycle!D32","v":0},{"$f":"IF(LifeCycle!E31=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E31,KEA.General.Name,0)))*LifeCycle!E32","v":0},{"$f":"IF(LifeCycle!F31=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F31,KEA.General.Name,0)))*LifeCycle!F32","v":0},{"$f":"IF(LifeCycle!G31=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G31,KEA.General.Name,0)))*LifeCycle!G32","v":0},0.72299999999999998,{"$f":"SUM(LifeCycle!C32:G32)","v":0.3}]
[null,"Fräser 3",{"$f":"IF(LifeCycle!C33=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C33,KEA.General.Name,0)))*LifeCycle!C34","v":0.72299999999999998},{"$f":"IF(LifeCycle!D33=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D33,KEA.General.Name,0)))*LifeCycle!D34","v":0},{"$f":"IF(LifeCycle!E33=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E33,KEA.General.Name,0)))*LifeCycle!E34","v":0},{"$f":"IF(LifeCycle!F33=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F33,KEA.General.Name,0)))*LifeCycle!F34","v":0},{"$f":"IF(LifeCycle!G33=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G33,KEA.General.Name,0)))*LifeCycle!G34","v":0},0.72299999999999998,{"$f":"SUM(LifeCycle!C34:G34)","v":0.3}]
[null,"Bohrer 1",{"$f":"IF(LifeCycle!C35=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C35,KEA.General.Name,0)))*LifeCycle!C36","v":0.48200000000000004},{"$f":"IF(LifeCycle!D35=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D35,KEA.General.Name,0)))*LifeCycle!D36","v":0},{"$f":"IF(LifeCycle!E35=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E35,KEA.General.Name,0)))*LifeCycle!E36","v":0},{"$f":"IF(LifeCycle!F35=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F35,KEA.General.Name,0)))*LifeCycle!F36","v":0},{"$f":"IF(LifeCycle!G35=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G35,KEA.General.Name,0)))*LifeCycle!G36","v":0},0.48200000000000004,{"$f":"SUM(LifeCycle!C36:G36)","v":0.2}]
[null,"Bohrer 2",{"$f":"IF(LifeCycle!C37=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C37,KEA.General.Name,0)))*LifeCycle!C38","v":0.24100000000000002},{"$f":"IF(LifeCycle!D37=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D37,KEA.General.Name,0)))*LifeCycle!D38","v":0},{"$f":"IF(LifeCycle!E37=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E37,KEA.General.Name,0)))*LifeCycle!E38","v":0},{"$f":"IF(LifeCycle!F37=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F37,KEA.General.Name,0)))*LifeCycle!F38","v":0},{"$f":"IF(LifeCycle!G37=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G37,KEA.General.Name,0)))*LifeCycle!G38","v":0},0.24100000000000002,{"$f":"SUM(LifeCycle!C38:G38)","v":0.1}]
[null,"Bohrer 3",{"$f":"IF(LifeCycle!C39=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C39,KEA.General.Name,0)))*LifeCycle!C40","v":0.24100000000000002},{"$f":"IF(LifeCycle!D39=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D39,KEA.General.Name,0)))*LifeCycle!D40","v":0},{"$f":"IF(LifeCycle!E39=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E39,KEA.General.Name,0)))*LifeCycle!E40","v":0},{"$f":"IF(LifeCycle!F39=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F39,KEA.General.Name,0)))*LifeCycle!F40","v":0},{"$f":"IF(LifeCycle!G39=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G39,KEA.General.Name,0)))*LifeCycle!G40","v":0},0.24100000000000002,{"$f":"SUM(LifeCycle!C40:G40)","v":0.1}]
[null,"Bohrer 4",{"$f":"IF(LifeCycle!C41=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C41,KEA.General.Name,0)))*LifeCycle!C42","v":0.24100000000000002},{"$f":"IF(LifeCycle!D41=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D41,KEA.General.Name,0)))*LifeCycle!D42","v":0},{"$f":"IF(LifeCycle!E41=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E41,KEA.General.Name,0)))*LifeCycle!E42","v":0},{"$f":"IF(LifeCycle!F41=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F41,KEA.General.Name,0)))*LifeCycle!F42","v":0},{"$f":"IF(LifeCycle!G41=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G41,KEA.General.Name,0)))*LifeCycle!G42","v":0},0.24100000000000002,{"$f":"SUM(LifeCycle!C42:G42)","v":0.1}]
[null,"Gewindeschneider",{"$f":"IF(LifeCycle!C43=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C43,KEA.General.Name,0)))*LifeCycle!C44","v":0.24100000000000002},{"$f":"IF(LifeCycle!D43=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D43,KEA.General.Name,0)))*LifeCycle!D44","v":0},{"$f":"IF(LifeCycle!E43=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E43,KEA.General.Name,0)))*LifeCycle!E44","v":0},{"$f":"IF(LifeCycle!F43=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F43,KEA.General.Name,0)))*LifeCycle!F44","v":0},{"$f":"IF(LifeCycle!G43=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G43,KEA.General.Name,0)))*LifeCycle!G44","v":0},0.24100000000000002,{"$f":"SUM(LifeCycle!C44:G44)","v":0.1}]
[]
["Purchasing & production"]
[null,null,null,null,null,null,null,null,"in-house Impact","external Impact",null,null,"special production methods"]
[null,"Machine"]
[null,{"$f":"B$8","v":"Machine structure"},{"$f":"IF(LifeCycle!C9=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!C9,KEA.General.Name,0)))*LifeCycle!C10","v":4016.6666666666674},{"$f":"IF(LifeCycle!D9=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!D9,KEA.General.Name,0)))*LifeCycle!D10","v":853.33333333333337},{"$f":"IF(LifeCycle!E9=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!E9,KEA.General.Name,0)))*LifeCycle!E10","v":319.20000000000005},{"$f":"IF(LifeCycle!F9=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!F9,KEA.General.Name,0)))*LifeCycle!F10","v":0},{"$f":"IF(LifeCycle!G9=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!G9,KEA.General.Name,0)))*LifeCycle!G10","v":0},{"$f":"SUM(C30:G30)","v":5189.2000000000007},{"$f":"H30*LifeCycle!C48","v":2075.6800000000003},{"$f":"H30-I30","v":3113.5200000000004},"Production",{"$f":"SUM(I30:I38)","v":2122.0912500000004},{"$f":"LifeCycle!D49","v":0}]
[null,{"$f":"Modules","v":"Hauptspindel"},{"$f":"IF(LifeCycle!C12=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!C12,KEA.General.Name,0)))*LifeCycle!C13","v":52.537500000000001},{"$f":"IF(LifeCycle!D12=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!D12,KEA.General.Name,0)))*LifeCycle!D13","v":127.68},{"$f":"IF(LifeCycle!E12=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!E12,KEA.General.Name,0)))*LifeCycle!E13","v":0},{"$f":"IF(LifeCycle!F12=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!F12,KEA.General.Name,0)))*LifeCycle!F13","v":0},{"$f":"IF(LifeCycle!G12=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!G12,KEA.General.Name,0)))*LifeCycle!G13","v":0},{"$f":"SUM(C31:G31)","v":180.2175},{"$f":"H31*LifeCycle!C50","v":0},{"$f":"H31-I31","v":180.2175},"Purchasing",{"$f":"SUM(J30:J38)","v":3600.6545833333339},{"$f":"LifeCycle!D50","v":0}]
[null,"Achse X1",{"$f":"IF(LifeCycle!C14=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!C14,KEA.General.Name,0)))*LifeCycle!C15","v":87.5625},{"$f":"IF(LifeCycle!D14=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!D14,KEA.General.Name,0)))*LifeCycle!D15","v":15.96},{"$f":"IF(LifeCycle!E14=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!E14,KEA.General.Name,0)))*LifeCycle!E15","v":0},{"$f":"IF(LifeCycle!F14=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!F14,KEA.General.Name,0)))*LifeCycle!F15","v":0},{"$f":"IF(LifeCycle!G14=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!G14,KEA.General.Name,0)))*LifeCycle!G15","v":0},103.52250000000001,{"$f":"H32*LifeCycle!C51","v":10.352250000000002},{"$f":"H32-I32","v":93.17025000000001},null,null,{"$f":"LifeCycle!D51","v":0}]
[null,"Achse Y1",{"$f":"IF(LifeCycle!C16=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!C16,KEA.General.Name,0)))*LifeCycle!C17","v":87.5625},{"$f":"IF(LifeCycle!D16=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!D16,KEA.General.Name,0)))*LifeCycle!D17","v":15.96},{"$f":"IF(LifeCycle!E16=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!E16,KEA.General.Name,0)))*LifeCycle!E17","v":0},{"$f":"IF(LifeCycle!F16=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!F16,KEA.General.Name,0)))*LifeCycle!F17","v":0},{"$f":"IF(LifeCycle!G16=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!G16,KEA.General.Name,0)))*LifeCycle!G17","v":0},103.52250000000001,{"$f":"H33*LifeCycle!C52","v":10.352250000000002},93.17025000000001,null,null,{"$f":"LifeCycle!D52","v":0}]
[null,"Achse Z1",{"$f":"IF(LifeCycle!C18=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!C18,KEA.General.Name,0)))*LifeCycle!C19","v":52.537500000000001},{"$f":"IF(LifeCycle!D18=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!D18,KEA.General.Name,0)))*LifeCycle!D19","v":7.98},{"$f":"IF(LifeCycle!E18=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!E18,KEA.General.Name,0)))*LifeCycle!E19","v":0},{"$f":"IF(LifeCycle!F18=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!F18,KEA.General.Name,0)))*LifeCycle!F19","v":0},{"$f":"IF(LifeCycle!G18=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!G18,KEA.General.Name,0)))*LifeCycle!G19","v":0},60.517499999999998,{"$f":"H34*LifeCycle!C53","v":6.0517500000000002},54.46575,null,null,{"$f":"LifeCycle!D53","v":0}]
[null,"Kabinett",{"$f":"IF(LifeCycle!C20=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!C20,KEA.General.Name,0)))*LifeCycle!C21","v":30.125000000000007},{"$f":"IF(LifeCycle!D20=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!D20,KEA.General.Name,0)))*LifeCycle!D21","v":0},{"$f":"IF(LifeCycle!E20=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!E20,KEA.General.Name,0)))*LifeCycle!E21","v":0},{"$f":"IF(LifeCycle!F20=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!F20,KEA.General.Name,0)))*LifeCycle!F21","v":0},{"$f":"IF(LifeCycle!G20=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!G20,KEA.General.Name,0)))*LifeCycle!G21","v":0},30.125000000000007,{"$f":"H35*LifeCycle!C54","v":15.062500000000004},15.062500000000004,null,null,{"$f":"LifeCycle!D54","v":0}]
[null,"KSM Pumpe",{"$f":"IF(LifeCycle!C22=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!C22,KEA.General.Name,0)))*LifeCycle!C23","v":10.041666666666668},{"$f":"IF(LifeCycle!D22=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!D22,KEA.General.Name,0)))*LifeCycle!D23","v":19.152000000000001},{"$f":"IF(LifeCycle!E22=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!E22,KEA.General.Name,0)))*LifeCycle!E23","v":0},{"$f":"IF(LifeCycle!F22=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!F22,KEA.General.Name,0)))*LifeCycle!F23","v":0},{"$f":"IF(LifeCycle!G22=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!G22,KEA.General.Name,0)))*LifeCycle!G23","v":0},29.193666666666669,{"$f":"H36*LifeCycle!C55","v":0},29.193666666666669,null,null,{"$f":"LifeCycle!D55","v":0}]
[null,"Spindelkühlung",{"$f":"IF(LifeCycle!C24=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!C24,KEA.General.Name,0)))*LifeCycle!C25","v":6.0250000000000012},{"$f":"IF(LifeCycle!D24=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!D24,KEA.General.Name,0)))*LifeCycle!D25","v":12.768000000000001},{"$f":"IF(LifeCycle!E24=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!E24,KEA.General.Name,0)))*LifeCycle!E25","v":0},{"$f":"IF(LifeCycle!F24=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!F24,KEA.General.Name,0)))*LifeCycle!F25","v":0},{"$f":"IF(LifeCycle!G24=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!G24,KEA.General.Name,0)))*LifeCycle!G25","v":0},18.793000000000003,{"$f":"H37*LifeCycle!C56","v":0},18.793000000000003,null,null,{"$f":"LifeCycle!D56","v":0}]
[null,"Sinumerik",{"$f":"IF(LifeCycle!C26=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!C26,KEA.General.Name,0)))*LifeCycle!C27","v":4.0166666666666675},{"$f":"IF(LifeCycle!D26=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!D26,KEA.General.Name,0)))*LifeCycle!D27","v":3.6375000000000002},{"$f":"IF(LifeCycle!E26=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!E26,KEA.General.Name,0)))*LifeCycle!E27","v":0},{"$f":"IF(LifeCycle!F26=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!F26,KEA.General.Name,0)))*LifeCycle!F27","v":0},{"$f":"IF(LifeCycle!G26=\"\",0,INDEX(KEA.General.Production,MATCH(LifeCycle!G26,KEA.General.Name,0)))*LifeCycle!G27","v":0},7.6541666666666677,{"$f":"H38*LifeCycle!C57","v":4.5925000000000002},3.0616666666666674,null,null,{"$f":"LifeCycle!D57","v":0}]
[null,{"$f":"B$17","v":"Tools"}]
[null,{"$f":"Tools","v":"Fräser 1"},{"$f":"IF(LifeCycle!C29=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C29,KEA.General.Name,0)))*LifeCycle!C30","v":0.96400000000000008},{"$f":"IF(LifeCycle!D29=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D29,KEA.General.Name,0)))*LifeCycle!D30","v":0},{"$f":"IF(LifeCycle!E29=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E29,KEA.General.Name,0)))*LifeCycle!E30","v":0},{"$f":"IF(LifeCycle!F29=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F29,KEA.General.Name,0)))*LifeCycle!F30","v":0},{"$f":"IF(LifeCycle!G29=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G29,KEA.General.Name,0)))*LifeCycle!G30","v":0},{"$f":"SUM(C40:G40)","v":0.96400000000000008},{"$f":"H40*LifeCycle!C59","v":0},{"$f":"H40-I40","v":0.96400000000000008},null,null,{"$f":"LifeCycle!D59","v":0}]
[null,"Fräser 2",{"$f":"IF(LifeCycle!C31=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C31,KEA.General.Name,0)))*LifeCycle!C32","v":0.72299999999999998},{"$f":"IF(LifeCycle!D31=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D31,KEA.General.Name,0)))*LifeCycle!D32","v":0},{"$f":"IF(LifeCycle!E31=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E31,KEA.General.Name,0)))*LifeCycle!E32","v":0},{"$f":"IF(LifeCycle!F31=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F31,KEA.General.Name,0)))*LifeCycle!F32","v":0},{"$f":"IF(LifeCycle!G31=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G31,KEA.General.Name,0)))*LifeCycle!G32","v":0},0.72299999999999998,{"$f":"H41*LifeCycle!C60","v":0},{"$f":"H41-I41","v":0.72299999999999998},null,null,{"$f":"LifeCycle!D60","v":0}]
[null,"Fräser 3",{"$f":"IF(LifeCycle!C33=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C33,KEA.General.Name,0)))*LifeCycle!C34","v":0.72299999999999998},{"$f":"IF(LifeCycle!D33=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D33,KEA.General.Name,0)))*LifeCycle!D34","v":0},{"$f":"IF(LifeCycle!E33=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E33,KEA.General.Name,0)))*LifeCycle!E34","v":0},{"$f":"IF(LifeCycle!F33=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F33,KEA.General.Name,0)))*LifeCycle!F34","v":0},{"$f":"IF(LifeCycle!G33=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G33,KEA.General.Name,0)))*LifeCycle!G34","v":0},0.72299999999999998,{"$f":"H42*LifeCycle!C61","v":0},0.72299999999999998,null,null,{"$f":"LifeCycle!D61","v":0}]
[null,"Bohrer 1",{"$f":"IF(LifeCycle!C35=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C35,KEA.General.Name,0)))*LifeCycle!C36","v":0.48200000000000004},{"$f":"IF(LifeCycle!D35=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D35,KEA.General.Name,0)))*LifeCycle!D36","v":0},{"$f":"IF(LifeCycle!E35=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E35,KEA.General.Name,0)))*LifeCycle!E36","v":0},{"$f":"IF(LifeCycle!F35=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F35,KEA.General.Name,0)))*LifeCycle!F36","v":0},{"$f":"IF(LifeCycle!G35=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G35,KEA.General.Name,0)))*LifeCycle!G36","v":0},0.48200000000000004,{"$f":"H43*LifeCycle!C62","v":0.48200000000000004},0,null,null,{"$f":"LifeCycle!D62","v":0}]
[null,"Bohrer 2",{"$f":"IF(LifeCycle!C37=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C37,KEA.General.Name,0)))*LifeCycle!C38","v":0.24100000000000002},{"$f":"IF(LifeCycle!D37=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D37,KEA.General.Name,0)))*LifeCycle!D38","v":0},{"$f":"IF(LifeCycle!E37=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E37,KEA.General.Name,0)))*LifeCycle!E38","v":0},{"$f":"IF(LifeCycle!F37=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F37,KEA.General.Name,0)))*LifeCycle!F38","v":0},{"$f":"IF(LifeCycle!G37=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G37,KEA.General.Name,0)))*LifeCycle!G38","v":0},0.24100000000000002,{"$f":"H44*LifeCycle!C63","v":0.24100000000000002},0,null,null,{"$f":"LifeCycle!D63","v":0}]
[null,"Bohrer 3",{"$f":"IF(LifeCycle!C39=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C39,KEA.General.Name,0)))*LifeCycle!C40","v":0.24100000000000002},{"$f":"IF(LifeCycle!D39=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D39,KEA.General.Name,0)))*LifeCycle!D40","v":0},{"$f":"IF(LifeCycle!E39=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E39,KEA.General.Name,0)))*LifeCycle!E40","v":0},{"$f":"IF(LifeCycle!F39=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F39,KEA.General.Name,0)))*LifeCycle!F40","v":0},{"$f":"IF(LifeCycle!G39=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G39,KEA.General.Name,0)))*LifeCycle!G40","v":0},0.24100000000000002,{"$f":"H45*LifeCycle!C64","v":0.24100000000000002},0,null,null,{"$f":"LifeCycle!D64","v":0}]
[null,"Bohrer 4",{"$f":"IF(LifeCycle!C41=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C41,KEA.General.Name,0)))*LifeCycle!C42","v":0.24100000000000002},{"$f":"IF(LifeCycle!D41=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D41,KEA.General.Name,0)))*LifeCycle!D42","v":0},{"$f":"IF(LifeCycle!E41=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E41,KEA.General.Name,0)))*LifeCycle!E42","v":0},{"$f":"IF(LifeCycle!F41=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F41,KEA.General.Name,0)))*LifeCycle!F42","v":0},{"$f":"IF(LifeCycle!G41=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G41,KEA.General.Name,0)))*LifeCycle!G42","v":0},0.24100000000000002,{"$f":"H46*LifeCycle!C65","v":0},0.24100000000000002,null,null,{"$f":"LifeCycle!D65","v":0}]
[null,"Gewindeschneider",{"$f":"IF(LifeCycle!C43=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!C43,KEA.General.Name,0)))*LifeCycle!C44","v":0.24100000000000002},{"$f":"IF(LifeCycle!D43=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!D43,KEA.General.Name,0)))*LifeCycle!D44","v":0},{"$f":"IF(LifeCycle!E43=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!E43,KEA.General.Name,0)))*LifeCycle!E44","v":0},{"$f":"IF(LifeCycle!F43=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!F43,KEA.General.Name,0)))*LifeCycle!F44","v":0},{"$f":"IF(LifeCycle!G43=\"\",0,INDEX(KEA.General.RawMaterial,MATCH(LifeCycle!G43,KEA.General.Name,0)))*LifeCycle!G44","v":0},0.24100000000000002,{"$f":"H47*LifeCycle!C66","v":2.4100000000000003E-2},0.21690000000000001,null,null,{"$f":"LifeCycle!D66","v":0}]
[]
["Packaging"]
[null,null,"wood","cardboard","plastic","Impact","Mass"]
[null,"Impact content",{"$f":"INDEX(KEA.Packaging.RawMaterial,MATCH(C50,KEA.Packaging.Name,0))","v":0.55957446808510636},{"$f":"INDEX(KEA.Packaging.RawMaterial,MATCH(D50,KEA.Packaging.Name,0))","v":1.44},{"$f":"INDEX(KEA.Packaging.RawMaterial,MATCH(E50,KEA.Packaging.Name,0))","v":2.93}]
[null,"Machine"]
[null,{"$f":"B$8","v":"Machine structure"},{"$f":"C$51*LifeCycle!C70","v":55.957446808510639},{"$f":"D$51*LifeCycle!D70","v":14.399999999999999},{"$f":"E$51*LifeCycle!E70","v":29.3},{"$f":"SUM(C53:E53)","v":99.657446808510642},{"$f":"SUM(LifeCycle!C70:E70)","v":120},null,null,null,"Packaging",{"$f":"SUM(F53:F61)","v":115.21893617021277}]
[null,{"$f":"Modules","v":"Hauptspindel"},{"$f":"C$51*LifeCycle!C72","v":0},{"$f":"D$51*LifeCycle!D72","v":0},{"$f":"E$51*LifeCycle!E72","v":0},{"$f":"SUM(C54:E54)","v":0},{"$f":"SUM(LifeCycle!C72:E72)","v":0}]
[null,"Achse X1",{"$f":"C$51*LifeCycle!C73","v":0},{"$f":"D$51*LifeCycle!D73","v":0},{"$f":"E$51*LifeCycle!E73","v":0},{"$f":"SUM(C55:E55)","v":0},{"$f":"SUM(LifeCycle!C73:E73)","v":0}]
[null,"Achse Y1",{"$f":"C$51*LifeCycle!C74","v":0},{"$f":"D$51*LifeCycle!D74","v":0},{"$f":"E$51*LifeCycle!E74","v":0},0,{"$f":"SUM(LifeCycle!C74:E74)","v":0}]
[null,"Achse Z1",{"$f":"C$51*LifeCycle!C75","v":0},{"$f":"D$51*LifeCycle!D75","v":0},{"$f":"E$51*LifeCycle!E75","v":0},0,{"$f":"SUM(LifeCycle!C75:E75)","v":0}]
[null,"Kabinett",{"$f":"C$51*LifeCycle!C76","v":0},{"$f":"D$51*LifeCycle!D76","v":0},{"$f":"E$51*LifeCycle!E76","v":0},0,{"$f":"SUM(LifeCycle!C76:E76)","v":0}]
[null,"KSM Pumpe",{"$f":"C$51*LifeCycle!C77","v":0},{"$f":"D$51*LifeCycle!D77","v":0},{"$f":"E$51*LifeCycle!E77","v":0},0,{"$f":"SUM(LifeCycle!C77:E77)","v":0}]
[null,"Spindelkühlung",{"$f":"C$51*LifeCycle!C78","v":11.191489361702127},{"$f":"D$51*LifeCycle!D78","v":1.44},{"$f":"E$51*LifeCycle!E78","v":2.93},15.561489361702126,{"$f":"SUM(LifeCycle!C78:E78)","v":22}]
[null,"Sinumerik",{"$f":"C$51*LifeCycle!C79","v":0},{"$f":"D$51*LifeCycle!D79","v":0},{"$f":"E$51*LifeCycle!E79","v":0},0,{"$f":"SUM(LifeCycle!C79:E79)","v":0}]
[null,{"$f":"B$17","v":"Tools"}]
[null,{"$f":"Tools","v":"Fräser 1"},{"$f":"C$51*LifeCycle!C81","v":0},{"$f":"D$51*LifeCycle!D81","v":0.14399999999999999},{"$f":"E$51*LifeCycle!E81","v":0.58600000000000008},{"$f":"SUM(C63:E63)","v":0.73000000000000009},{"$f":"SUM(LifeCycle!C81:E81)","v":0.30000000000000004}]
[null,"Fräser 2",{"$f":"C$51*LifeCycle!C82","v":0},{"$f":"D$51*LifeCycle!D82","v":0.14399999999999999},{"$f":"E$51*LifeCycle!E82","v":0.58600000000000008},{"$f":"SUM(C64:E64)","v":0.73000000000000009},{"$f":"SUM(LifeCycle!C82:E82)","v":0.30000000000000004}]
[null,"Fräser 3",{"$f":"C$51*LifeCycle!C83","v":0},{"$f":"D$51*LifeCycle!D83","v":0.14399999999999999},{"$f":"E$51*LifeCycle!E83","v":0.58600000000000008},0.73000000000000009,{"$f":"SUM(LifeCycle!C83:E83)","v":0.30000000000000004}]
[null,"Bohrer 1",{"$f":"C$51*LifeCycle!C84","v":0},{"$f":"D$51*LifeCycle!D84","v":0.14399999999999999},{"$f":"E$51*LifeCycle!E84","v":0.58600000000000008},0.73000000000000009,{"$f":"SUM(LifeCycle!C84:E84)","v":0.30000000000000004}]
[null,"Bohrer 2",{"$f":"C$51*LifeCycle!C85","v":0},{"$f":"D$51*LifeCycle!D85","v":0.14399999999999999},{"$f":"E$51*LifeCycle!E85","v":0.58600000000000008},0.73000000000000009,{"$f":"SUM(LifeCycle!C85:E85)","v":0.30000000000000004}]
[null,"Bohrer 3",{"$f":"C$51*LifeCycle!C86","v":0},{"$f":"D$51*LifeCycle!D86","v":0.14399999999999999},{"$f":"E$51*LifeCycle!E86","v":0.58600000000000008},0.73000000000000009,{"$f":"SUM(LifeCycle!C86:E86)","v":0.30000000000000004}]
[null,"Bohrer 4",{"$f":"C$51*LifeCycle!C87","v":0},{"$f":"D$51*LifeCycle!D87","v":0.14399999999999999},{"$f":"E$51*LifeCycle!E87","v":0.58600000000000008},0.73000000000000009,{"$f":"SUM(LifeCycle!C87:E87)","v":0.30000000000000004}]
[null,"Gewindeschneider",{"$f":"C$51*LifeCycle!C88","v":0},{"$f":"D$51*LifeCycle!D88","v":0.14399999999999999},{"$f":"E$51*LifeCycle!E88","v":0.58600000000000008},0.73000000000000009,{"$f":"SUM(LifeCycle!C88:E88)","v":0.30000000000000004}]
[]
["Transportation"]
[null,null,"lorry","ship","car","train","airplane","Impact"]
[null,"Impact Demand",{"$f":"INDEX(KEA.Transportation.RawMaterial,MATCH(C73,KEA.Transportation.Name,0))","v":0.16},{"$f":"INDEX(KEA.Transportation.RawMaterial,MATCH(D73,KEA.Transportation.Name,0))","v":0.01},{"$f":"INDEX(KEA.Transportation.RawMaterial,MATCH(E73,KEA.Transportation.Name,0))","v":0.5},{"$f":"INDEX(KEA.Transportation.RawMaterial,MATCH(F73,KEA.Transportation.Name,0))","v":0.02},{"$f":"INDEX(KEA.Transportation.RawMaterial,MATCH(G73,KEA.Transportation.Name,0))","v":1.1200000000000001}]
[null,"Machine"]
[null,{"$f":"B$8","v":"Machine structure"},{"$f":"C$74*($G53+$I8)*LifeCycle!C92/1000","v":69.135999999999996},{"$f":"D$74*($G53+$I8)*LifeCycle!D92/1000","v":518.52},{"$f":"E$74*($G53+$I8)*LifeCycle!E92/1000","v":0},{"$f":"F$74*($G53+$I8)*LifeCycle!F92/1000","v":0},{"$f":"G$74*($G53+$I8)*LifeCycle!G92/1000","v":0},{"$f":"SUM(C76:G76)","v":587.65599999999995},null,null,"Transportation",{"$f":"SUM(H76:H84)","v":782.4824000000001}]
[null,{"$f":"Modules","v":"Hauptspindel"},{"$f":"C$74*($G54+$I9)*LifeCycle!C94/1000","v":1.92},{"$f":"D$74*($G54+$I9)*LifeCycle!D94/1000","v":14.4},{"$f":"E$74*($G54+$I9)*LifeCycle!E94/1000","v":0},{"$f":"F$74*($G54+$I9)*LifeCycle!F94/1000","v":0},{"$f":"G$74*($G54+$I9)*LifeCycle!G94/1000","v":0},{"$f":"SUM(C77:G77)","v":16.32}]
[null,"Achse X1",{"$f":"C$74*($G55+$I10)*LifeCycle!C95/1000","v":0.97599999999999998},{"$f":"D$74*($G55+$I10)*LifeCycle!D95/1000","v":7.32},{"$f":"E$74*($G55+$I10)*LifeCycle!E95/1000","v":0},{"$f":"F$74*($G55+$I10)*LifeCycle!F95/1000","v":0},{"$f":"G$74*($G55+$I10)*LifeCycle!G95/1000","v":0},{"$f":"SUM(C78:G78)","v":8.2959999999999994}]
[null,"Achse Y1",{"$f":"C$74*($G56+$I11)*LifeCycle!C96/1000","v":0.97599999999999998},{"$f":"D$74*($G56+$I11)*LifeCycle!D96/1000","v":7.32},{"$f":"E$74*($G56+$I11)*LifeCycle!E96/1000","v":0},{"$f":"F$74*($G56+$I11)*LifeCycle!F96/1000","v":0},{"$f":"G$74*($G56+$I11)*LifeCycle!G96/1000","v":0},8.2959999999999994]
[null,"Achse Z1",{"$f":"C$74*($G57+$I12)*LifeCycle!C97/1000","v":0.56799999999999995},{"$f":"D$74*($G57+$I12)*LifeCycle!D97/1000","v":4.26},{"$f":"E$74*($G57+$I12)*LifeCycle!E97/1000","v":0},{"$f":"F$74*($G57+$I12)*LifeCycle!F97/1000","v":0},{"$f":"G$74*($G57+$I12)*LifeCycle!G97/1000","v":0},4.8279999999999994]
[null,"Kabinett",{"$f":"C$74*($G58+$I13)*LifeCycle!C98/1000","v":1.8400000000000003},{"$f":"D$74*($G58+$I13)*LifeCycle!D98/1000","v":13.800000000000002},{"$f":"E$74*($G58+$I13)*LifeCycle!E98/1000","v":0},{"$f":"F$74*($G58+$I13)*LifeCycle!F98/1000","v":0},{"$f":"G$74*($G58+$I13)*LifeCycle!G98/1000","v":0},15.640000000000002]
[null,"KSM Pumpe",{"$f":"C$74*($G59+$I14)*LifeCycle!C99/1000","v":0.2752},{"$f":"D$74*($G59+$I14)*LifeCycle!D99/1000","v":2.0640000000000001},{"$f":"E$74*($G59+$I14)*LifeCycle!E99/1000","v":0},{"$f":"F$74*($G59+$I14)*LifeCycle!F99/1000","v":0},{"$f":"G$74*($G59+$I14)*LifeCycle!G99/1000","v":0},2.3391999999999999]
[null,"Spindelkühlung",{"$f":"C$74*($G60+$I15)*LifeCycle!C100/1000","v":0.53120000000000001},{"$f":"D$74*($G60+$I15)*LifeCycle!D100/1000","v":3.984},{"$f":"E$74*($G60+$I15)*LifeCycle!E100/1000","v":0},{"$f":"F$74*($G60+$I15)*LifeCycle!F100/1000","v":0},{"$f":"G$74*($G60+$I15)*LifeCycle!G100/1000","v":0},4.5152000000000001]
[null,"Sinumerik",{"$f":"C$74*($G61+$I16)*LifeCycle!C101/1000","v":0.192},{"$f":"D$74*($G61+$I16)*LifeCycle!D101/1000","v":0},{"$f":"E$74*($G61+$I16)*LifeCycle!E101/1000","v":0},{"$f":"F$74*($G61+$I16)*LifeCycle!F101/1000","v":0},{"$f":"G$74*($G61+$I16)*LifeCycle!G101/1000","v":134.4},134.59200000000001]
[null,{"$f":"B$17","v":"Tools"}]
[null,{"$f":"Tools","v":"Fräser 1"},{"$f":"C$74*($G63+$I18)*LifeCycle!C103/1000","v":0},{"$f":"D$74*($G63+$I18)*LifeCycle!D103/1000","v":0},{"$f":"E$74*($G63+$I18)*LifeCycle!E103/1000","v":0.17500000000000002},{"$f":"F$74*($G63+$I18)*LifeCycle!F103/1000","v":0},{"$f":"G$74*($G63+$I18)*LifeCycle!G103/1000","v":3.9200000000000008},{"$f":"SUM(C86:G86)","v":4.0950000000000006}]
[null,"Fräser 2",{"$f":"C$74*($G64+$I19)*LifeCycle!C104/1000","v":0},{"$f":"D$74*($G64+$I19)*LifeCycle!D104/1000","v":0},{"$f":"E$74*($G64+$I19)*LifeCycle!E104/1000","v":0.15000000000000002},{"$f":"F$74*($G64+$I19)*LifeCycle!F104/1000","v":0},{"$f":"G$74*($G64+$I19)*LifeCycle!G104/1000","v":3.3600000000000008},{"$f":"SUM(C87:G87)","v":3.5100000000000007}]
[null,"Fräser 3",{"$f":"C$74*($G65+$I20)*LifeCycle!C105/1000","v":0},{"$f":"D$74*($G65+$I20)*LifeCycle!D105/1000","v":0},{"$f":"E$74*($G65+$I20)*LifeCycle!E105/1000","v":0.15000000000000002},{"$f":"F$74*($G65+$I20)*LifeCycle!F105/1000","v":0},{"$f":"G$74*($G65+$I20)*LifeCycle!G105/1000","v":3.3600000000000008},3.5100000000000007]
[null,"Bohrer 1",{"$f":"C$74*($G66+$I21)*LifeCycle!C106/1000","v":0},{"$f":"D$74*($G66+$I21)*LifeCycle!D106/1000","v":0.06},{"$f":"E$74*($G66+$I21)*LifeCycle!E106/1000","v":0.125},{"$f":"F$74*($G66+$I21)*LifeCycle!F106/1000","v":0},{"$f":"G$74*($G66+$I21)*LifeCycle!G106/1000","v":0},0.185]
[null,"Bohrer 2",{"$f":"C$74*($G67+$I22)*LifeCycle!C107/1000","v":0},{"$f":"D$74*($G67+$I22)*LifeCycle!D107/1000","v":4.8000000000000001E-2},{"$f":"E$74*($G67+$I22)*LifeCycle!E107/1000","v":0.1},{"$f":"F$74*($G67+$I22)*LifeCycle!F107/1000","v":0},{"$f":"G$74*($G67+$I22)*LifeCycle!G107/1000","v":0},0.14800000000000002]
[null,"Bohrer 3",{"$f":"C$74*($G68+$I23)*LifeCycle!C108/1000","v":0},{"$f":"D$74*($G68+$I23)*LifeCycle!D108/1000","v":4.8000000000000001E-2},{"$f":"E$74*($G68+$I23)*LifeCycle!E108/1000","v":0.1},{"$f":"F$74*($G68+$I23)*LifeCycle!F108/1000","v":0},{"$f":"G$74*($G68+$I23)*LifeCycle!G108/1000","v":0},0.14800000000000002]
[null,"Bohrer 4",{"$f":"C$74*($G69+$I24)*LifeCycle!C109/1000","v":0},{"$f":"D$74*($G69+$I24)*LifeCycle!D109/1000","v":0},{"$f":"E$74*($G69+$I24)*LifeCycle!E109/1000","v":0.1},{"$f":"F$74*($G69+$I24)*LifeCycle!F109/1000","v":0},{"$f":"G$74*($G69+$I24)*LifeCycle!G109/1000","v":2.2400000000000007},2.3400000000000007]
[null,"Gewindeschneider",{"$f":"C$74*($G70+$I25)*LifeCycle!C110/1000","v":0},{"$f":"D$74*($G70+$I25)*LifeCycle!D110/1000","v":4.8000000000000001E-2},{"$f":"E$74*($G70+$I25)*LifeCycle!E110/1000","v":0.1},{"$f":"F$74*($G70+$I25)*LifeCycle!F110/1000","v":0},{"$f":"G$74*($G70+$I25)*LifeCycle!G110/1000","v":0},0.14800000000000002]
[]
["Commissioning","Building materials"]
[null,"Material",null,"Impact"]
[null,{"$f":"LifeCycle!B115","v":"brick, concret"},{"$f":"KEA.Construction.RawMaterial","v":0.32},{"$f":"C97*LifeCycle!C115","v":32},null,null,null,null,null,null,"Commissioning",{"$f":"SUM(D97:D106)","v":3124}]
[null,{"$f":"LifeCycle!B116","v":"cement"},0.58699999999999997,{"$f":"C98*LifeCycle!C116","v":587}]
[null,{"$f":"LifeCycle!B117","v":"sand, grevel"},0.01,{"$f":"C99*LifeCycle!C117","v":5}]
[null,{"$f":"LifeCycle!B118","v":"steel, iron"},2.5,{"$f":"C100*LifeCycle!C118","v":2500}]
[]
[null,"Type of infrastructure"]
[null,{"$f":"Overview!B39","v":"Air conditioning"},null,null,null,null,null,null,null,null,null,null,{"$f":"LifeCycle!C120","v":0}]
[null,{"$f":"Overview!B40","v":"Heating (fluid)"},null,null,null,null,null,null,null,null,null,null,{"$f":"LifeCycle!C121","v":0}]
[null,{"$f":"Overview!B41","v":"Cooling (fluid)"},null,null,null,null,null,null,null,null,null,null,{"$f":"LifeCycle!C122","v":0}]
[null,{"$f":"Overview!B42","v":"Lubrication centre"},null,null,null,null,null,null,null,null,null,null,{"$f":"LifeCycle!C123","v":0}]
[]
["Operation"]
[null,"product lifetime [y]",{"$f":"LifeCycle!C126","v":5}]
[]
[null,"Energy"]
[null,null,null,"Average consumption during machine states",null,null,null,null,null,null,"Energy",{"$f":"SUM(D117:G117)","v":255182.35169442315}]
[null,null,"installed power","Operation","Ready","Standby","Off","Total"]
[null,"Total",{"$f":"SUM(LifeCycle!C131:C140)/1000","v":114},{"$f":"SUM(LifeCycle!D131:D140)/1000","v":34},{"$f":"SUM(LifeCycle!E131:E140)/1000","v":6.1},{"$f":"SUM(LifeCycle!F131:F140)/1000","v":4.5},{"$f":"SUM(LifeCycle!G131:G140)/1000","v":0.1}]
[null,"Time, relative",null,{"$f":"TRANSPOSE(MacheStateDistribution)","v":0.33926961587942212},0.19350933646455928,0.10881758790799242,0.35840345974802612]
[null,"Time, Absolut",null,{"$f":"MachineLifetime*365*24*D115","v":14860.00917551869},{"$f":"MachineLifetime*365*24*E115","v":8475.7089371476959},4766.2103503700682,15698.071536963544]
[null,"Impact demand",null,{"$f":"D114*D116*INDEX(KEA.Energy.RawMaterial,MATCH(MachineEnergySource,KEA.Energy.Name,0))","v":222305.73726575961},{"$f":"E114*E116*INDEX(KEA.Energy.RawMaterial,MATCH(MachineEnergySource,KEA.Energy.Name,0))","v":22748.802787304416},{"$f":"F114*F116*INDEX(KEA.Energy.RawMaterial,MATCH(MachineEnergySource,KEA.Energy.Name,0))","v":9437.0964937327353},{"$f":"G114*G116*INDEX(KEA.Energy.RawMaterial,MATCH(MachineEnergySource,KEA.Energy.Name,0))","v":690.71514762639595}]
[null,{"$f":"IF(LifeCycle!B131=\"\",\"\",LifeCycle!B131)","v":"Machine structure"},null,{"$f":"IF($B118=\"\",0,LifeCycle!D131)*Calculation!D$116/1000","v":0},{"$f":"IF($B118=\"\",0,LifeCycle!E131)*Calculation!E$116/1000","v":0},{"$f":"IF($B118=\"\",0,LifeCycle!F131)*Calculation!F$116/1000","v":0},{"$f":"IF($B118=\"\",0,LifeCycle!G131)*Calculation!G$116/1000","v":0},{"$f":"SUM(D118:G118)","v":0}]
[null,{"$f":"IF(LifeCycle!B133=\"\",\"\",LifeCycle!B133)","v":"Hauptspindel"},null,{"$f":"IF($B119=\"\",0,LifeCycle!D133)*Calculation!D$116/1000","v":178320.11010622428},{"$f":"IF($B119=\"\",0,LifeCycle!E133)*Calculation!E$116/1000","v":8475.7089371476959},{"$f":"IF($B119=\"\",0,LifeCycle!F133)*Calculation!F$116/1000","v":0},{"$f":"IF($B119=\"\",0,LifeCycle!G133)*Calculation!G$116/1000","v":0},{"$f":"SUM(D119:G119)","v":186795.81904337197}]
[null,{"$f":"IF(LifeCycle!B134=\"\",\"\",LifeCycle!B134)","v":"Achse X1"},null,{"$f":"IF($B120=\"\",0,LifeCycle!D134)*Calculation!D$116/1000","v":59440.036702074758},{"$f":"IF($B120=\"\",0,LifeCycle!E134)*Calculation!E$116/1000","v":1695.1417874295394},{"$f":"IF($B120=\"\",0,LifeCycle!F134)*Calculation!F$116/1000","v":0},{"$f":"IF($B120=\"\",0,LifeCycle!G134)*Calculation!G$116/1000","v":0},61135.178489504295]
[null,{"$f":"IF(LifeCycle!B135=\"\",\"\",LifeCycle!B135)","v":"Achse Y1"},null,{"$f":"IF($B121=\"\",0,LifeCycle!D135)*Calculation!D$116/1000","v":59440.036702074758},{"$f":"IF($B121=\"\",0,LifeCycle!E135)*Calculation!E$116/1000","v":1695.1417874295394},{"$f":"IF($B121=\"\",0,LifeCycle!F135)*Calculation!F$116/1000","v":0},{"$f":"IF($B121=\"\",0,LifeCycle!G135)*Calculation!G$116/1000","v":0},61135.178489504295]
[null,{"$f":"IF(LifeCycle!B136=\"\",\"\",LifeCycle!B136)","v":"Achse Z1"},null,{"$f":"IF($B122=\"\",0,LifeCycle!D136)*Calculation!D$116/1000","v":11888.007340414952},{"$f":"IF($B122=\"\",0,LifeCycle!E136)*Calculation!E$116/1000","v":1695.1417874295394},{"$f":"IF($B122=\"\",0,LifeCycle!F136)*Calculation!F$116/1000","v":0},{"$f":"IF($B122=\"\",0,LifeCycle!G136)*Calculation!G$116/1000","v":0},13583.149127844492]
[null,{"$f":"IF(LifeCycle!B137=\"\",\"\",LifeCycle!B137)","v":"Kabinett"},null,{"$f":"IF($B123=\"\",0,LifeCycle!D137)*Calculation!D$116/1000","v":59440.036702074758},{"$f":"IF($B123=\"\",0,LifeCycle!E137)*Calculation!E$116/1000","v":21189.272342869241},{"$f":"IF($B123=\"\",0,LifeCycle!F137)*Calculation!F$116/1000","v":11915.52587592517},{"$f":"IF($B123=\"\",0,LifeCycle!G137)*Calculation!G$116/1000","v":0},92544.83492086918]
[null,{"$f":"IF(LifeCycle!B138=\"\",\"\",LifeCycle!B138)","v":"KSM Pumpe"},null,{"$f":"IF($B124=\"\",0,LifeCycle!D138)*Calculation!D$116/1000","v":104020.06422863083},{"$f":"IF($B124=\"\",0,LifeCycle!E138)*Calculation!E$116/1000","v":0},{"$f":"IF($B124=\"\",0,LifeCycle!F138)*Calculation!F$116/1000","v":0},{"$f":"IF($B124=\"\",0,LifeCycle!G138)*Calculation!G$116/1000","v":0},104020.06422863083]
[null,{"$f":"IF(LifeCycle!B139=\"\",\"\",LifeCycle!B139)","v":"Spindelkühlung"},null,{"$f":"IF($B125=\"\",0,LifeCycle!D139)*Calculation!D$116/1000","v":29720.018351037379},{"$f":"IF($B125=\"\",0,LifeCycle!E139)*Calculation!E$116/1000","v":15256.276086865853},{"$f":"IF($B125=\"\",0,LifeCycle!F139)*Calculation!F$116/1000","v":8579.1786306661234},{"$f":"IF($B125=\"\",0,LifeCycle!G139)*Calculation!G$116/1000","v":0},53555.473068569358]
[null,{"$f":"IF(LifeCycle!B140=\"\",\"\",LifeCycle!B140)","v":"Sinumerik"},null,{"$f":"IF($B126=\"\",0,LifeCycle!D140)*Calculation!D$116/1000","v":2972.0018351037379},{"$f":"IF($B126=\"\",0,LifeCycle!E140)*Calculation!E$116/1000","v":1695.1417874295394},{"$f":"IF($B126=\"\",0,LifeCycle!F140)*Calculation!F$116/1000","v":953.24207007401367},{"$f":"IF($B126=\"\",0,LifeCycle!G140)*Calculation!G$116/1000","v":1569.8071536963546},7190.1928463036456]
[null,"Tools","Impact / P","Amount","Impact"]
[null,{"$f":"Tools","v":"Fräser 1"},{"$f":"I18+H40+F63+H86+H169","v":6.1890000000000009},{"$f":"Use!F46/Use!D46","v":713.28044042489717},{"$f":"IF(B128<>0,D128*C128,0)","v":4414.492645789689},null,null,null,null,null,"Tools",{"$f":"SUM(E128:E135)","v":10936.907313145055}]
[null,"Fräser 2",5.2630000000000008,{"$f":"Use!F47/Use!D47","v":713.28044042489717},{"$f":"IF(B129<>0,D129*C129,0)","v":3753.9949579562344}]
[null,"Fräser 3",5.2630000000000008,{"$f":"Use!F48/Use!D48","v":178.32011010622429},938.49873948905861]
[null,"Bohrer 1",1.5970000000000002,{"$f":"Use!F49/Use!D49","v":356.64022021244858},569.55443167928047]
[null,"Bohrer 2",1.2190000000000003,{"$f":"Use!F50/Use!D50","v":178.32011010622429},217.37221421948746]
[null,"Bohrer 3",1.2190000000000003,{"$f":"Use!F51/Use!D51","v":178.32011010622429},217.37221421948746]
[null,"Bohrer 4",3.4110000000000009,{"$f":"Use!F52/Use!D52","v":178.32011010622429},608.24989557233118]
[null,"Gewindeschneider",1.2190000000000003,{"$f":"Use!F53/Use!D53","v":178.32011010622429},217.37221421948746]
[null,"Infrastructure","Power","Up-Time","Impact"]
[null,{"$f":"B103:B106","v":"Air conditioning"},{"$f":"Infrastructure!C17","v":4800},{"$f":"Infrastructure!N17","v":43800},{"$f":"D137*C137/1000*INDEX(KEA.Energy.RawMaterial,MATCH(MachineEnergySource,KEA.Energy.Name,0))","v":92505.600000000006},null,null,null,null,null,"Infrastructure",{"$f":"SUM(E137:E140)","v":97267.011117777103}]
[null,"Heating (fluid)",{"$f":"Infrastructure!C20","v":0},{"$f":"Infrastructure!N20","v":0},{"$f":"D138*C138/1000*INDEX(KEA.Energy.RawMaterial,MATCH(MachineEnergySource,KEA.Energy.Name,0))","v":0}]
[null,"Cooling (fluid)",{"$f":"Infrastructure!C26","v":200},{"$f":"Infrastructure!N26","v":28101.928463036456},{"$f":"D139*C139/1000*INDEX(KEA.Energy.RawMaterial,MATCH(MachineEnergySource,KEA.Energy.Name,0))","v":2472.9697047472082}]
[null,"Lubrication centre",{"$f":"Infrastructure!C32","v":350},{"$f":"Infrastructure!N32","v":14860.00917551869},{"$f":"D140*C140/1000*INDEX(KEA.Energy.RawMaterial,MATCH(MachineEnergySource,KEA.Energy.Name,0))","v":2288.4414130298783}]
[null,"Resources","Amount","Up-Time","Impact"]
[null,{"$f":"KEA.Process.Name","v":"Oil (lubricant)"},{"$f":"LifeCycle!C146:C149","v":1E-3},{"$f":"IF(LifeCycle!D146=\"Operation only\",Calculation!D$116,IF(LifeCycle!D146=\"Ready and higher\",SUM(Calculation!D$116:E$116),IF(LifeCycle!D146=\"If machine is on\",SUM(Calculation!D$116:F$116),IF(LifeCycle!D146=\"Allways\",SUM(Calculation!D$116:G$116),0))))","v":14860.00917551869},{"$f":"C142*D142*60*INDEX(KEA.Process.RawMaterial,MATCH(B142,KEA.Process.Name,0))","v":1141.2487046798353},null,null,null,null,null,"Resources",{"$f":"SUM(E142:E145)","v":17344.074353783617}]
[null,"Pressured air",2,{"$f":"IF(LifeCycle!D147=\"Operation only\",Calculation!D$116,IF(LifeCycle!D147=\"Ready and higher\",SUM(Calculation!D$116:E$116),IF(LifeCycle!D147=\"If machine is on\",SUM(Calculation!D$116:F$116),IF(LifeCycle!D147=\"Allways\",SUM(Calculation!D$116:G$116),0))))","v":23335.718112666385},{"$f":"C143*D143*60*INDEX(KEA.Process.RawMaterial,MATCH(B143,KEA.Process.Name,0))","v":154.01573954359816}]
[null,"Gas",0,{"$f":"IF(LifeCycle!D148=\"Operation only\",Calculation!D$116,IF(LifeCycle!D148=\"Ready and higher\",SUM(Calculation!D$116:E$116),IF(LifeCycle!D148=\"If machine is on\",SUM(Calculation!D$116:F$116),IF(LifeCycle!D148=\"Allways\",SUM(Calculation!D$116:G$116),0))))","v":0},{"$f":"C144*D144*60*INDEX(KEA.Process.RawMaterial,MATCH(B144,KEA.Process.Name,0))","v":0}]
[null,"Water",60,{"$f":"IF(LifeCycle!D149=\"Operation only\",Calculation!D$116,IF(LifeCycle!D149=\"Ready and higher\",SUM(Calculation!D$116:E$116),IF(LifeCycle!D149=\"If machine is on\",SUM(Calculation!D$116:F$116),IF(LifeCycle!D149=\"Allways\",SUM(Calculation!D$116:G$116),0))))","v":14860.00917551869},{"$f":"C145*D145*60*INDEX(KEA.Process.RawMaterial,MATCH(B145,KEA.Process.Name,0))","v":16048.809909560183}]
[null,"Scrap","Impact / P","Amount","Defects","Impact"]
[null,{"$f":"Use!B57:B60","v":"steel, high-alloyed "},{"$f":"Use!H70:H73","v":4.67},{"$f":"Use!$C57*(1-Use!D57)*Calculation!$D$116","v":17832.011010622424},{"$f":"Use!$C57*Use!$C$64*Calculation!$D$116","v":445.80027526556069},{"$f":"(D147+E147)*C147","v":85357.378705096882},null,null,null,null,"Scrap material",{"$f":"SUM(F147:F150)","v":110699.63835302647}]
[null,"aluminium, copper, brass",5.32,{"$f":"Use!$C58*(1-Use!D58)*Calculation!$D$116","v":743.00045877593516},{"$f":"Use!$C58*Use!$C$64*Calculation!$D$116","v":74.300045877593448},{"$f":"(D148+E148)*C148","v":4348.0386847567725}]
[null,"steel, iron",2.41,{"$f":"Use!$C59*(1-Use!D59)*Calculation!$D$116","v":7430.0045877593511},{"$f":"Use!$C59*Use!$C$64*Calculation!$D$116","v":743.00045877593448},19696.942162150037]
[null,"PE, PP, PET, Polyester",2.91,{"$f":"Use!$C60*(1-Use!D60)*Calculation!$D$116","v":297.20018351037407},{"$f":"Use!$C60*Use!$C$64*Calculation!$D$116","v":148.6000917551869},1297.2788010227825]
[null,"Services"]
[null,"Impact",{"$f":"LifeCycle!C152*LifeCycle!C154*LifeCycle!C155*Calculation!C74/1000","v":7.4142399999999995},null,null,null,null,null,null,null,"Services",{"$f":"C152","v":7.4142399999999995}]
[null,"Parts"]
[null,"annual output",{"$f":"D116/(Use!C14*24)","v":123547.42039692214}]
[]
["Recycling"]
[null,null,"Impact Material 1","Impact Material 2","Impact Material 3","Impact Material 4","Impact Material 5","Impact"]
[null,"Machine"]
[null,{"$f":"B$8","v":"Machine structure"},{"$f":"IF(LifeCycle!C9=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C9,KEA.General.Name,0)))*LifeCycle!C10","v":0},{"$f":"IF(LifeCycle!D9=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D9,KEA.General.Name,0)))*LifeCycle!D10","v":0},{"$f":"IF(LifeCycle!E9=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E9,KEA.General.Name,0)))*LifeCycle!E10","v":0},{"$f":"IF(LifeCycle!F9=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F9,KEA.General.Name,0)))*LifeCycle!F10","v":0},{"$f":"IF(LifeCycle!G9=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G9,KEA.General.Name,0)))*LifeCycle!G10","v":0},{"$f":"SUM(C159:G159)*LifeCycle!C159","v":0},null,null,"Recycling",{"$f":"SUM(H159:H167)","v":0}]
[null,{"$f":"IF(Module_1=\"\",\"-\",Module_1)","v":"Hauptspindel"},{"$f":"IF(LifeCycle!C12=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C12,KEA.General.Name,0)))*LifeCycle!C13","v":0},{"$f":"IF(LifeCycle!D12=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D12,KEA.General.Name,0)))*LifeCycle!D13","v":0},{"$f":"IF(LifeCycle!E12=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E12,KEA.General.Name,0)))*LifeCycle!E13","v":0},{"$f":"IF(LifeCycle!F12=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F12,KEA.General.Name,0)))*LifeCycle!F13","v":0},{"$f":"IF(LifeCycle!G12=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G12,KEA.General.Name,0)))*LifeCycle!G13","v":0},{"$f":"SUM(C160:G160)*LifeCycle!C161","v":0}]
[null,{"$f":"IF(Module_2=\"\",\"-\",Module_2)","v":"Achse X1"},{"$f":"IF(LifeCycle!C14=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C14,KEA.General.Name,0)))*LifeCycle!C15","v":0},{"$f":"IF(LifeCycle!D14=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D14,KEA.General.Name,0)))*LifeCycle!D15","v":0},{"$f":"IF(LifeCycle!E14=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E14,KEA.General.Name,0)))*LifeCycle!E15","v":0},{"$f":"IF(LifeCycle!F14=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F14,KEA.General.Name,0)))*LifeCycle!F15","v":0},{"$f":"IF(LifeCycle!G14=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G14,KEA.General.Name,0)))*LifeCycle!G15","v":0},{"$f":"SUM(C161:G161)*LifeCycle!C162","v":0}]
[null,{"$f":"IF(Module_3=\"\",\"-\",Module_3)","v":"Achse Y1"},{"$f":"IF(LifeCycle!C16=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C16,KEA.General.Name,0)))*LifeCycle!C17","v":0},{"$f":"IF(LifeCycle!D16=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D16,KEA.General.Name,0)))*LifeCycle!D17","v":0},{"$f":"IF(LifeCycle!E16=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E16,KEA.General.Name,0)))*LifeCycle!E17","v":0},{"$f":"IF(LifeCycle!F16=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F16,KEA.General.Name,0)))*LifeCycle!F17","v":0},{"$f":"IF(LifeCycle!G16=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G16,KEA.General.Name,0)))*LifeCycle!G17","v":0},{"$f":"SUM(C162:G162)*LifeCycle!C163","v":0}]
[null,{"$f":"IF(Module_4=\"\",\"-\",Module_4)","v":"Achse Z1"},{"$f":"IF(LifeCycle!C18=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C18,KEA.General.Name,0)))*LifeCycle!C19","v":0},{"$f":"IF(LifeCycle!D18=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D18,KEA.General.Name,0)))*LifeCycle!D19","v":0},{"$f":"IF(LifeCycle!E18=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E18,KEA.General.Name,0)))*LifeCycle!E19","v":0},{"$f":"IF(LifeCycle!F18=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F18,KEA.General.Name,0)))*LifeCycle!F19","v":0},{"$f":"IF(LifeCycle!G18=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G18,KEA.General.Name,0)))*LifeCycle!G19","v":0},{"$f":"SUM(C163:G163)*LifeCycle!C164","v":0}]
[null,{"$f":"IF(Module_5=\"\",\"-\",Module_5)","v":"Kabinett"},{"$f":"IF(LifeCycle!C20=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C20,KEA.General.Name,0)))*LifeCycle!C21","v":0},{"$f":"IF(LifeCycle!D20=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D20,KEA.General.Name,0)))*LifeCycle!D21","v":0},{"$f":"IF(LifeCycle!E20=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E20,KEA.General.Name,0)))*LifeCycle!E21","v":0},{"$f":"IF(LifeCycle!F20=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F20,KEA.General.Name,0)))*LifeCycle!F21","v":0},{"$f":"IF(LifeCycle!G20=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G20,KEA.General.Name,0)))*LifeCycle!G21","v":0},{"$f":"SUM(C164:G164)*LifeCycle!C165","v":0}]
[null,{"$f":"IF(Module_6=\"\",\"-\",Module_6)","v":"KSM Pumpe"},{"$f":"IF(LifeCycle!C22=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C22,KEA.General.Name,0)))*LifeCycle!C23","v":0},{"$f":"IF(LifeCycle!D22=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D22,KEA.General.Name,0)))*LifeCycle!D23","v":0},{"$f":"IF(LifeCycle!E22=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E22,KEA.General.Name,0)))*LifeCycle!E23","v":0},{"$f":"IF(LifeCycle!F22=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F22,KEA.General.Name,0)))*LifeCycle!F23","v":0},{"$f":"IF(LifeCycle!G22=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G22,KEA.General.Name,0)))*LifeCycle!G23","v":0},{"$f":"SUM(C165:G165)*LifeCycle!C166","v":0}]
[null,{"$f":"IF(Module_7=\"\",\"-\",Module_7)","v":"Spindelkühlung"},{"$f":"IF(LifeCycle!C24=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C24,KEA.General.Name,0)))*LifeCycle!C25","v":0},{"$f":"IF(LifeCycle!D24=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D24,KEA.General.Name,0)))*LifeCycle!D25","v":0},{"$f":"IF(LifeCycle!E24=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E24,KEA.General.Name,0)))*LifeCycle!E25","v":0},{"$f":"IF(LifeCycle!F24=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F24,KEA.General.Name,0)))*LifeCycle!F25","v":0},{"$f":"IF(LifeCycle!G24=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G24,KEA.General.Name,0)))*LifeCycle!G25","v":0},{"$f":"SUM(C166:G166)*LifeCycle!C167","v":0}]
[null,{"$f":"IF(Module_8=\"\",\"-\",Module_8)","v":"Sinumerik"},{"$f":"IF(LifeCycle!C26=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C26,KEA.General.Name,0)))*LifeCycle!C27","v":0},{"$f":"IF(LifeCycle!D26=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D26,KEA.General.Name,0)))*LifeCycle!D27","v":0},{"$f":"IF(LifeCycle!E26=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E26,KEA.General.Name,0)))*LifeCycle!E27","v":0},{"$f":"IF(LifeCycle!F26=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F26,KEA.General.Name,0)))*LifeCycle!F27","v":0},{"$f":"IF(LifeCycle!G26=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G26,KEA.General.Name,0)))*LifeCycle!G27","v":0},{"$f":"SUM(C167:G167)*LifeCycle!C168","v":0}]
[null,{"$f":"B$17","v":"Tools"}]
[null,{"$f":"IF(Tool_1=\"\",\"-\",Tool_1)","v":"Fräser 1"},{"$f":"IF(LifeCycle!C29=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C29,KEA.General.Name,0)))*LifeCycle!C30","v":0},{"$f":"IF(LifeCycle!D29=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D29,KEA.General.Name,0)))*LifeCycle!D30","v":0},{"$f":"IF(LifeCycle!E29=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E29,KEA.General.Name,0)))*LifeCycle!E30","v":0},{"$f":"IF(LifeCycle!F29=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F29,KEA.General.Name,0)))*LifeCycle!F30","v":0},{"$f":"IF(LifeCycle!G29=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G29,KEA.General.Name,0)))*LifeCycle!G30","v":0},{"$f":"SUM(C169:G169)*LifeCycle!C170","v":0}]
[null,{"$f":"IF(Tool_2=\"\",\"-\",Tool_2)","v":"Fräser 2"},{"$f":"IF(LifeCycle!C31=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C31,KEA.General.Name,0)))*LifeCycle!C32","v":0},{"$f":"IF(LifeCycle!D31=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D31,KEA.General.Name,0)))*LifeCycle!D32","v":0},{"$f":"IF(LifeCycle!E31=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E31,KEA.General.Name,0)))*LifeCycle!E32","v":0},{"$f":"IF(LifeCycle!F31=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F31,KEA.General.Name,0)))*LifeCycle!F32","v":0},{"$f":"IF(LifeCycle!G31=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G31,KEA.General.Name,0)))*LifeCycle!G32","v":0},{"$f":"SUM(C170:G170)*LifeCycle!C171","v":0}]
[null,{"$f":"IF(Tool_3=\"\",\"-\",Tool_3)","v":"Fräser 3"},{"$f":"IF(LifeCycle!C33=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C33,KEA.General.Name,0)))*LifeCycle!C34","v":0},{"$f":"IF(LifeCycle!D33=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D33,KEA.General.Name,0)))*LifeCycle!D34","v":0},{"$f":"IF(LifeCycle!E33=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E33,KEA.General.Name,0)))*LifeCycle!E34","v":0},{"$f":"IF(LifeCycle!F33=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F33,KEA.General.Name,0)))*LifeCycle!F34","v":0},{"$f":"IF(LifeCycle!G33=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G33,KEA.General.Name,0)))*LifeCycle!G34","v":0},{"$f":"SUM(C171:G171)*LifeCycle!C172","v":0}]
[null,{"$f":"IF(Tool_4=\"\",\"-\",Tool_4)","v":"Bohrer 1"},{"$f":"IF(LifeCycle!C35=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C35,KEA.General.Name,0)))*LifeCycle!C36","v":0},{"$f":"IF(LifeCycle!D35=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D35,KEA.General.Name,0)))*LifeCycle!D36","v":0},{"$f":"IF(LifeCycle!E35=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E35,KEA.General.Name,0)))*LifeCycle!E36","v":0},{"$f":"IF(LifeCycle!F35=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F35,KEA.General.Name,0)))*LifeCycle!F36","v":0},{"$f":"IF(LifeCycle!G35=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G35,KEA.General.Name,0)))*LifeCycle!G36","v":0},{"$f":"SUM(C172:G172)*LifeCycle!C173","v":0}]
[null,{"$f":"IF(Tool_5=\"\",\"-\",Tool_5)","v":"Bohrer 2"},{"$f":"IF(LifeCycle!C37=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C37,KEA.General.Name,0)))*LifeCycle!C38","v":0},{"$f":"IF(LifeCycle!D37=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D37,KEA.General.Name,0)))*LifeCycle!D38","v":0},{"$f":"IF(LifeCycle!E37=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E37,KEA.General.Name,0)))*LifeCycle!E38","v":0},{"$f":"IF(LifeCycle!F37=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F37,KEA.General.Name,0)))*LifeCycle!F38","v":0},{"$f":"IF(LifeCycle!G37=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G37,KEA.General.Name,0)))*LifeCycle!G38","v":0},{"$f":"SUM(C173:G173)*LifeCycle!C174","v":0}]
[null,{"$f":"IF(Tool_6=\"\",\"-\",Tool_6)","v":"Bohrer 3"},{"$f":"IF(LifeCycle!C39=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C39,KEA.General.Name,0)))*LifeCycle!C40","v":0},{"$f":"IF(LifeCycle!D39=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D39,KEA.General.Name,0)))*LifeCycle!D40","v":0},{"$f":"IF(LifeCycle!E39=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E39,KEA.General.Name,0)))*LifeCycle!E40","v":0},{"$f":"IF(LifeCycle!F39=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F39,KEA.General.Name,0)))*LifeCycle!F40","v":0},{"$f":"IF(LifeCycle!G39=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G39,KEA.General.Name,0)))*LifeCycle!G40","v":0},{"$f":"SUM(C174:G174)*LifeCycle!C175","v":0}]
[null,{"$f":"IF(Tool_7=\"\",\"-\",Tool_7)","v":"Bohrer 4"},{"$f":"IF(LifeCycle!C41=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C41,KEA.General.Name,0)))*LifeCycle!C42","v":0},{"$f":"IF(LifeCycle!D41=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D41,KEA.General.Name,0)))*LifeCycle!D42","v":0},{"$f":"IF(LifeCycle!E41=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E41,KEA.General.Name,0)))*LifeCycle!E42","v":0},{"$f":"IF(LifeCycle!F41=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F41,KEA.General.Name,0)))*LifeCycle!F42","v":0},{"$f":"IF(LifeCycle!G41=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G41,KEA.General.Name,0)))*LifeCycle!G42","v":0},{"$f":"SUM(C175:G175)*LifeCycle!C176","v":0}]
[null,{"$f":"IF(Tool_8=\"\",\"-\",Tool_8)","v":"Gewindeschneider"},{"$f":"IF(LifeCycle!C43=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!C43,KEA.General.Name,0)))*LifeCycle!C44","v":0},{"$f":"IF(LifeCycle!D43=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!D43,KEA.General.Name,0)))*LifeCycle!D44","v":0},{"$f":"IF(LifeCycle!E43=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!E43,KEA.General.Name,0)))*LifeCycle!E44","v":0},{"$f":"IF(LifeCycle!F43=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!F43,KEA.General.Name,0)))*LifeCycle!F44","v":0},{"$f":"IF(LifeCycle!G43=\"\",0,INDEX(KEA.General.Recycling,MATCH(LifeCycle!G43,KEA.General.Name,0)))*LifeCycle!G44","v":0},{"$f":"SUM(C176:G176)*LifeCycle!C177","v":0}]

{"sheet":"Data","index":8,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":true,"merged":[[45,8,49,10]]}
[]
["Unit",{"$f":"Results!$C$12","v":"kg CO2 eq."}]
[]
[null,null,"Raw material","Production","Recycling","Low. Heat. Val.",null,"Raw material","Production","Recycling","Low. Heat. Val.",null,"Raw material","Production","Recycling","Low. Heat. Val."]
[null,null,{"$f":"KEA.Unit&\"/kg\"","v":"kg CO2 eq./kg"},{"$f":"KEA.Unit&\"/kg\"","v":"kg CO2 eq./kg"},{"$f":"KEA.Unit&\"/kg\"","v":"kg CO2 eq./kg"},{"$f":"KEA.Unit&\"/kg\"","v":"kg CO2 eq./kg"},null,"MJ/kg","MJ/kg","MJ/kg","MJ/kg",null,"kg CO2 eq/kg","kg CO2 eq/kg","kg CO2 eq/kg","kg CO2 eq/kg"]
["General","steel, iron",{"$f":"IF(KEA.Unit=\"MJ\",H6,M6)","v":2.41},{"$f":"IF(KEA.Unit=\"MJ\",I6,N6)","v":2.0083333333333337},{"$f":"IF(KEA.Unit=\"MJ\",J6,O6)","v":0},{"$f":"IF(KEA.Unit=\"MJ\",K6,P6)","v":0},null,30,25,-16,0,null,2.41,2.0083333333333337,0,0]
[null,"cast iron",1.6,0.42666666666666669,0,0,null,45,12,-16,0,null,1.6,0.42666666666666669,0,0]
[null,"steel, high-alloyed ",4.67,1.75125,0,0,null,80,30,-16,0,null,4.67,1.75125,0,0]
[null,"PE, PP, PET, Polyester",2.91,0.72750000000000004,0,0,null,80,20,-16,32,null,2.91,0.72750000000000004,0,0]
[null,"PS",3.7,0.82222222222222219,0,0,null,90,20,-16,32,null,3.7,0.82222222222222219,0,0]
[null,"aluminium, copper, brass",5.32,1.5960000000000001,0,0,null,100,30,-16,0,null,5.32,1.5960000000000001,0,0]
[null,"PUR, PC",8.2200000000000006,1.5657142857142858,0,0,null,105,20,-16,32,null,8.2200000000000006,1.5657142857142858,0,0]
[null,"Polyamids, EP",3.95,0.52666666666666673,0,0,null,150,20,-16,32,null,3.95,0.52666666666666673,0,0]
[null,"electronics",58.99,0,0,0,null,170,0,-16,0,null,58.99,0,0,0]
[]
[null,null,{"$f":"KEA.Unit&\"/kg\"","v":"kg CO2 eq./kg"},null,null,null,null,"MJ/kg",null,null,null,null,"kg CO2 eq/kg"]
["Packaging","wood",{"$f":"IF(KEA.Unit=\"MJ\",H17,M17)","v":0.55957446808510636},null,null,null,null,22,null,null,null,null,0.55957446808510636]
[null,"cardboard",{"$f":"IF(KEA.Unit=\"MJ\",H18,M18)","v":1.44},null,null,null,null,38,null,null,null,null,1.44]
[null,"plastic",{"$f":"IF(KEA.Unit=\"MJ\",H19,M19)","v":2.93},null,null,null,null,80,null,null,null,null,2.93]
[]
[null,null,{"$f":"KEA.Unit&\"/kg\"","v":"kg CO2 eq./kg"},null,null,null,null,"MJ/kg",null,null,null,null,"kg CO2 eq/kg"]
["Construction","brick, concret",{"$f":"IF(KEA.Unit=\"MJ\",H22,M22)","v":0.32},null,null,null,null,3,null,null,null,null,0.32]
[null,"cement",{"$f":"IF(KEA.Unit=\"MJ\",H23,M23)","v":0.58699999999999997},null,null,null,null,4,null,null,null,null,0.58699999999999997]
[null,"sand, grevel",{"$f":"IF(KEA.Unit=\"MJ\",H24,M24)","v":0.01},null,null,null,null,0.2,null,null,null,null,0.01]
[null,"steel, iron",{"$f":"IF(KEA.Unit=\"MJ\",H25,M25)","v":2.5},null,null,null,null,45,null,null,null,null,2.5]
[]
[null,null,{"$f":"KEA.Unit&\"/t/km\"","v":"kg CO2 eq./t/km"},null,null,null,null,"MJ/t/km",null,null,null,null,"kg CO2 eq/t/km"]
["Transportation","lorry",{"$f":"IF(KEA.Unit=\"MJ\",H28,M28)","v":0.16},null,null,null,null,1,null,null,null,null,0.16]
[null,"ship",{"$f":"IF(KEA.Unit=\"MJ\",H29,M29)","v":0.01},null,null,null,null,0.24,null,null,null,null,0.01]
[null,"car",{"$f":"IF(KEA.Unit=\"MJ\",H30,M30)","v":0.5},null,null,null,null,13,null,null,null,null,0.5]
[null,"train",{"$f":"IF(KEA.Unit=\"MJ\",H31,M31)","v":0.02},null,null,null,null,0.5,null,null,null,null,0.02]
[null,"airplane",{"$f":"IF(KEA.Unit=\"MJ\",H32,M32)","v":1.1200000000000001},null,null,null,null,22,null,null,null,null,1.1200000000000001]
[]
[]
[null,null,{"$f":"KEA.Unit&\"/kWh\"","v":"kg CO2 eq./kWh"},null,null,null,null,"MJ/kWh",null,null,null,null,"kg CO2 eq/kWh"]
["Energy","CH-Mix",{"$f":"IF(KEA.Unit=\"MJ\",H36,M36)","v":0.1},null,null,null,null,4.7,null,null,null,null,0.1]
[null,"EU-Mix",{"$f":"IF(KEA.Unit=\"MJ\",H37,M37)","v":0.44},null,null,null,null,8.3000000000000007,null,null,null,null,0.44]
[null,"Global Average",{"$f":"IF(KEA.Unit=\"MJ\",H38,M38)","v":0.78},null,null,null,null,11.9,null,null,null,null,0.78]
[]
[null,null,{"$f":"KEA.Unit&\"/l\"","v":"kg CO2 eq./l"},null,null,null,null,"MJ/l",null,null,null,null,"kg CO2 eq/l"]
["Process","Oil (lubricant)",{"$f":"IF(KEA.Unit=\"MJ\",H41,M41)","v":1.28},null,null,null,null,40,null,null,null,null,1.28]
[null,"Pressured air",{"$f":"7.5/60/1000*INDEX(KEA.Energy.RawMaterial,MATCH(MachineEnergySource,KEA.Energy.Name,0))","v":5.5000000000000002E-5},null,null,null,null,5.8750000000000002E-4,null,null,null,null,5.8750000000000002E-4]
[null,"Gas",{"$f":"IF(KEA.Unit=\"MJ\",H43,M43)","v":0},null,null,null,null,4.4999999999999997E-3,null,null,null,null,0]
[null,"Water",{"$f":"IF(KEA.Unit=\"MJ\",H44,M44)","v":2.9999999999999997E-4},null,null,null,null,5.4000000000000003E-3,null,null,null,null,2.9999999999999997E-4]
[]
[null,"Class","Water cooling","Air cooling",null,null,null,"Source:","N. Bey, 2000, The Oil Point Method – A tool for indicative environmental evaluation in material and process selection, Ph.D., Department of Manufacturing Engineering, Technical University of Denmark, Lynby, Denmark."]
["Building","A",5.05,2.6]
[null,"B",4.8499999999999996,2.5]
[null,"C",4.45,2.2999999999999998]
[null,"D",4.05,2.1]
[null,"E",3.65,1.9]
[null,"F",3.25,1.7]
[null,"-",3.05,1.6]
[]
[null,"Source: Schudeleit, 2015, inspire AG"]

{"sheet":"About","index":9,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,2],[5,1,5,2]]}
[]
["About"]
[]
[]
[]
["Project","This potential estimation tool for machine tools has been developed in the project \"Eco-design Toolbox\" (2011-2013). The goal of the project was, to supply the industry with tools for better product development. "]
[]
["Project lead","Züst Engineering AG\nCH-8607 Seegräben\n\nwww.zuestengineering.ch\nrainer.zuest@zuestengineering.ch"]
[]
["Research Partners","Institute for machine tools and manufacturing (IWF)\nETH Zürich\n\nwww.iwf.mavt.ethz.ch\nwww.inspire.ethz.ch\nweiss@inspire.ethz.ch"]
[null,"inspire\nAG für mechatronische Produktionssysteme und Fertigungstechnik"]
["Industry Partners","Mägerle AG\nRollomatic SA\nStarrag Heckert AG\nReiden Technik AG\nPfiffner AG"]
[]
["Endorsed by","Swiss Electric Research"]

{"sheet":"History","index":10,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":true,"merged":[[3,1,3,3],[0,0,0,5]]}
["History"]
[]
[]
["Current Version:",{"$f":"H44","v":"ET-MTED-V3R1"}]
[]
[]
["Name","V","R","Author","Date","Description","New Version?","Current?"]
[{"$f":"IF(D8=\"\",\"\",\"ET-MTED-V\"&B8&\"R\"&C8)","v":"ET-MTED-V1R0"},1,0,"ZS-inspire","2012-10-16","Initial Creation","x",{"$f":"IF(A8=\"\",H7,A8)","v":"ET-MTED-V1R0"}]
[{"$f":"IF(D9=\"\",\"\",\"ET-MTED-V\"&B9&\"R\"&C9)","v":"ET-MTED-V1R1"},{"$f":"IF(D9=\"\",\"\",IF(G9=\"\",B8,B8+1))","v":1},{"$f":"IF(D9=\"\",\"\",IF(B9-B8=0,C8+1,0))","v":1},"ZS-inspire","2012-11-11","Minor adaptions",null,{"$f":"IF(A9=\"\",H8,A9)","v":"ET-MTED-V1R1"}]
["ET-MTED-V2R0",{"$f":"IF(D10=\"\",\"\",IF(G10=\"\",B9,B9+1))","v":2},{"$f":"IF(D10=\"\",\"\",IF(B10-B9=0,C9+1,0))","v":0},"ZS-inspire","2013-01-23","New Model","x","ET-MTED-V2R0"]
["ET-MTED-V2R1",{"$f":"IF(D11=\"\",\"\",IF(G11=\"\",B10,B10+1))","v":2},{"$f":"IF(D11=\"\",\"\",IF(B11-B10=0,C10+1,0))","v":1},"ZS-inspire","2013-01-30","New Use phase input",null,"ET-MTED-V2R1"]
["ET-MTED-V2R2",2,2,"ZS-inspire","2013-01-07","Minor Model and format adaption\nExamples added",null,"ET-MTED-V2R2"]
["ET-MTED-V2R3",2,3,"ZS-inspire","2013-04-08","Empty forms, minor corrections",null,"ET-MTED-V2R3"]
["ET-MTED-V2R4",2,4,"ZS-inspire","2013-04-10","Droplist corrected",null,"ET-MTED-V2R4"]
["ET-MTED-V2R5",2,5,"ZS-inspire","2015-03-31","Formating and calculations",null,"ET-MTED-V2R5"]
["ET-MTED-V2R6",2,6,"ZS-inspire","2015-04-22","Infrastructure adapted",null,"ET-MTED-V2R6"]
["ET-MTED-V2R7",2,7,"ZS-IWF","2016-02-15","Minor corrections",null,"ET-MTED-V2R7"]
["ET-MTED-V2R8",2,8,"ZS-ZEAG","2017-07-10","Minor corrections in \"About\"",null,"ET-MTED-V2R8"]
["ET-MTED-V3R0",3,0,"ZS-ZEAG","2023-02-28","selection fleet, machine, part added; selection reference unit added; versioning added","x","ET-MTED-V3R0"]
["ET-MTED-V3R1",3,1,"ZS-ZEAG","2023-09-08","Changed to relative paths",null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]
["","","",null,null,null,null,"ET-MTED-V3R1"]