{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Company Level Aggregator Tool","Normalising Factors"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":0,"defined_names":3,"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":"Company Level Aggregator Tool","index":0,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,5,2,12],[3,5,3,13],[8,8,8,10],[42,1,42,13]]}
[]
[]
[null,null,null,null,null,"Company Level Aggregator Tool"]
[null,null,null,null,null,"This spreadsheet can be used to aggregate a set of reference product data together using a selected normalising factor. First select the normalising factor from the drop down box. \nNext enter data for each reference product. If there are more than 20 reference products, insert more rows in the table. Click the 'Add Labels' button to add labels to the points on the chart."]
[]
[null,null,null,"Select normalising factor:  ","product mass"]
[]
[null,null,"No.","Name of product range",{"$f":"CONCATENATE(\"Total \",E6,\" of product range\")","v":"Total product mass of product range"},"MCI of ref. product",null,"Combined Material Circularity Indicator"]
[null,null,1,"Product range 1",1000,0.1,null,null,{"$f":"CONCATENATE(\"MCI = \",TEXT(Combined_MCI,\"0.00\"))","v":"MCI = 0.27"}]
[null,null,2,"Product range 2",500,0.65]
[null,null,3,"Product range 3",100,0.1]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,null,"Combined MCI",{"$f":"SUM(Norm_Factors)","v":1600},{"$f":"SUMPRODUCT(Norm_Factors,MCIs)/SUM(Norm_Factors)","v":0.27187499999999998},{"$f":"1-Combined_MCI","v":0.72812500000000002}]
[null,null,null,{"$f":"CONCATENATE(\"Total \",$E$6)","v":"Total product mass"},null,{"$f":"SUM(Norm_Factors)","v":1600}]
[null,null,null,"Combined Material Circularity Indicator",null,{"$f":"SUMPRODUCT(Norm_Factors,MCIs)/SUM(Norm_Factors)","v":0.27187499999999998}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This spreadsheet has been provided as part of the Circularity Indicators Project by the Ellen MacArthur Foundation and Granta Design Ltd (co-founded by the EU's Life programme). Further information on the Project, including a project overview and the full methodology can be found at http://www.ellenmacarthurfoundation.org/circularity-indicators/. In addition to this interactive model, a commercially available Circularity Indicators webtool has been developed by Granta and integrated with the MI:Product Intelligence package. Information on the web tool can be found at http://www.grantadesign.com/products/mi/pi.htm."]

{"sheet":"Normalising Factors","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Normalising factors"]
[]
[null,"product mass",null,"Additional normalising factors can be added here"]
[null,"sales revenue"]