{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Freight & Forwarding","Other variable cost","Power & Fuel","Profit","Fixed Cost","Ark2","Raw data","All company ","Dashboard","Ark1","Calculation"],"not_rendered":{"charts":10,"images":4,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":7},"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":"Freight & Forwarding","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Variable","Freight & Forwarding"]
[]
["Summer av Value","Kolonneetiketter"]
["Radetiketter","ACC Ltd","Ambuja Cement","JK Lakshmi Cement","Ultratech Cement"]
[2011,20,23,20,22]
[2012,20,23,19,20]
[2013,21,25,21,21]
[2014,22,24,22,23]
[2015,23,27,22,24]

{"sheet":"Other variable cost","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Variable","Other variable cost"]
[]
["Summer av Value","Kolonneetiketter"]
["Radetiketter","ACC Ltd","Ambuja Cement","JK Lakshmi Cement","Ultratech Cement"]
[2011,15,11,23,16]
[2012,18,9,25,17]
[2013,22,13,26,18]
[2014,20,12,30,19]
[2015,19,11,29,18]

{"sheet":"Power & Fuel","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Variable","Power & Fuel"]
[]
["Summer av Value","Kolonneetiketter"]
["Radetiketter","ACC Ltd","Ambuja Cement","JK Lakshmi Cement","Ultratech Cement"]
[2011,23,23,30,23]
[2012,21,24,24,24]
[2013,21,22,20,21]
[2014,21,23,21,20]
[2015,20,22,21,21]

{"sheet":"Profit","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Variable","Profit"]
[]
["Summer av Value","Kolonneetiketter"]
["Radetiketter","ACC Ltd","Ambuja Cement","JK Lakshmi Cement","Ultratech Cement"]
[2011,15,18,8,17]
[2012,15,19,12,17]
[2013,7,13,14,8]
[2014,8,14,8,9]
[2015,8,10,10,9]

{"sheet":"Fixed Cost","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Variable","Fixed Cost"]
[]
["Summer av Value","Kolonneetiketter"]
["Radetiketter","ACC Ltd","Ambuja Cement","JK Lakshmi Cement","Ultratech Cement"]
[2011,27,25,19,24]
[2012,26,25,20,22]
[2013,29,27,19,22]
[2014,29,27,19,24]
[2015,30,30,18,24]

{"sheet":"Ark2","index":5,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Summer av Value","Kolonneetiketter"]
["Radetiketter",2011,2012,2013,2014,2015,"Totalsum"]
["ACC Ltd",100,100,100,100,100,500]
["Fixed Cost",27,26,29,29,30,141]
["Freight & Forwarding",20,20,21,22,23,106]
["Other variable cost",15,18,22,20,19,94]
["Power & Fuel",23,21,21,21,20,106]
["Profit",15,15,7,8,8,53]
["Ambuja Cement",100,100,100,100,100,500]
["Fixed Cost",25,25,27,27,30,134]
["Freight & Forwarding",23,23,25,24,27,122]
["Other variable cost",11,9,13,12,11,56]
["Power & Fuel",23,24,22,23,22,114]
["Profit",18,19,13,14,10,74]
["JK Lakshmi Cement",100,100,100,100,100,500]
["Fixed Cost",19,20,19,19,18,95]
["Freight & Forwarding",20,19,21,22,22,104]
["Other variable cost",23,25,26,30,29,133]
["Power & Fuel",30,24,20,21,21,116]
["Profit",8,12,14,8,10,52]
["Ultratech Cement",102,100,90,95,96,483]
["Fixed Cost",24,22,22,24,24,116]
["Freight & Forwarding",22,20,21,23,24,110]
["Other variable cost",16,17,18,19,18,88]
["Power & Fuel",23,24,21,20,21,109]
["Profit",17,17,8,9,9,60]
["Totalsum",402,400,390,395,396,1983]

{"sheet":"Raw data","index":6,"n_rows":103,"n_cols":6,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Company","Year","Variable","Value"]
[null,null,"ACC Ltd",2011,"Other variable cost",15]
[null,null,"ACC Ltd",2011,"Power & Fuel",23]
[null,null,"ACC Ltd",2011,"Freight & Forwarding",20]
[null,null,"ACC Ltd",2011,"Fixed Cost",27]
[null,null,"ACC Ltd",2011,"Profit",15]
[null,null,"Ultratech Cement",2011,"Other variable cost",16]
[null,null,"Ultratech Cement",2011,"Power & Fuel",23]
[null,null,"Ultratech Cement",2011,"Freight & Forwarding",22]
[null,null,"Ultratech Cement",2011,"Fixed Cost",24]
[null,null,"Ultratech Cement",2011,"Profit",17]
[null,null,"Ambuja Cement",2011,"Other variable cost",11]
[null,null,"Ambuja Cement",2011,"Power & Fuel",23]
[null,null,"Ambuja Cement",2011,"Freight & Forwarding",23]
[null,null,"Ambuja Cement",2011,"Fixed Cost",25]
[null,null,"Ambuja Cement",2011,"Profit",18]
[null,null,"JK Lakshmi Cement",2011,"Other variable cost",23]
[null,null,"JK Lakshmi Cement",2011,"Power & Fuel",30]
[null,null,"JK Lakshmi Cement",2011,"Freight & Forwarding",20]
[null,null,"JK Lakshmi Cement",2011,"Fixed Cost",19]
[null,null,"JK Lakshmi Cement",2011,"Profit",8]
[null,null,"ACC Ltd",2012,"Other variable cost",18]
[null,null,"ACC Ltd",2012,"Power & Fuel",21]
[null,null,"ACC Ltd",2012,"Freight & Forwarding",20]
[null,null,"ACC Ltd",2012,"Fixed Cost",26]
[null,null,"ACC Ltd",2012,"Profit",15]
[null,null,"Ultratech Cement",2012,"Other variable cost",17]
[null,null,"Ultratech Cement",2012,"Power & Fuel",24]
[null,null,"Ultratech Cement",2012,"Freight & Forwarding",20]
[null,null,"Ultratech Cement",2012,"Fixed Cost",22]
[null,null,"Ultratech Cement",2012,"Profit",17]
[null,null,"Ambuja Cement",2012,"Other variable cost",9]
[null,null,"Ambuja Cement",2012,"Power & Fuel",24]
[null,null,"Ambuja Cement",2012,"Freight & Forwarding",23]
[null,null,"Ambuja Cement",2012,"Fixed Cost",25]
[null,null,"Ambuja Cement",2012,"Profit",19]
[null,null,"JK Lakshmi Cement",2012,"Other variable cost",25]
[null,null,"JK Lakshmi Cement",2012,"Power & Fuel",24]
[null,null,"JK Lakshmi Cement",2012,"Freight & Forwarding",19]
[null,null,"JK Lakshmi Cement",2012,"Fixed Cost",20]
[null,null,"JK Lakshmi Cement",2012,"Profit",12]
[null,null,"ACC Ltd",2013,"Other variable cost",22]
[null,null,"ACC Ltd",2013,"Power & Fuel",21]
[null,null,"ACC Ltd",2013,"Freight & Forwarding",21]
[null,null,"ACC Ltd",2013,"Fixed Cost",29]
[null,null,"ACC Ltd",2013,"Profit",7]
[null,null,"Ultratech Cement",2013,"Other variable cost",18]
[null,null,"Ultratech Cement",2013,"Power & Fuel",21]
[null,null,"Ultratech Cement",2013,"Freight & Forwarding",21]
[null,null,"Ultratech Cement",2013,"Fixed Cost",22]
[null,null,"Ultratech Cement",2013,"Profit",8]
[null,null,"Ambuja Cement",2013,"Other variable cost",13]
[null,null,"Ambuja Cement",2013,"Power & Fuel",22]
[null,null,"Ambuja Cement",2013,"Freight & Forwarding",25]
[null,null,"Ambuja Cement",2013,"Fixed Cost",27]
[null,null,"Ambuja Cement",2013,"Profit",13]
[null,null,"JK Lakshmi Cement",2013,"Other variable cost",26]
[null,null,"JK Lakshmi Cement",2013,"Power & Fuel",20]
[null,null,"JK Lakshmi Cement",2013,"Freight & Forwarding",21]
[null,null,"JK Lakshmi Cement",2013,"Fixed Cost",19]
[null,null,"JK Lakshmi Cement",2013,"Profit",14]
[null,null,"ACC Ltd",2014,"Other variable cost",20]
[null,null,"ACC Ltd",2014,"Power & Fuel",21]
[null,null,"ACC Ltd",2014,"Freight & Forwarding",22]
[null,null,"ACC Ltd",2014,"Fixed Cost",29]
[null,null,"ACC Ltd",2014,"Profit",8]
[null,null,"Ultratech Cement",2014,"Other variable cost",19]
[null,null,"Ultratech Cement",2014,"Power & Fuel",20]
[null,null,"Ultratech Cement",2014,"Freight & Forwarding",23]
[null,null,"Ultratech Cement",2014,"Fixed Cost",24]
[null,null,"Ultratech Cement",2014,"Profit",9]
[null,null,"Ambuja Cement",2014,"Other variable cost",12]
[null,null,"Ambuja Cement",2014,"Power & Fuel",23]
[null,null,"Ambuja Cement",2014,"Freight & Forwarding",24]
[null,null,"Ambuja Cement",2014,"Fixed Cost",27]
[null,null,"Ambuja Cement",2014,"Profit",14]
[null,null,"JK Lakshmi Cement",2014,"Other variable cost",30]
[null,null,"JK Lakshmi Cement",2014,"Power & Fuel",21]
[null,null,"JK Lakshmi Cement",2014,"Freight & Forwarding",22]
[null,null,"JK Lakshmi Cement",2014,"Fixed Cost",19]
[null,null,"JK Lakshmi Cement",2014,"Profit",8]
[null,null,"ACC Ltd",2015,"Other variable cost",19]
[null,null,"ACC Ltd",2015,"Power & Fuel",20]
[null,null,"ACC Ltd",2015,"Freight & Forwarding",23]
[null,null,"ACC Ltd",2015,"Fixed Cost",30]
[null,null,"ACC Ltd",2015,"Profit",8]
[null,null,"Ultratech Cement",2015,"Other variable cost",18]
[null,null,"Ultratech Cement",2015,"Power & Fuel",21]
[null,null,"Ultratech Cement",2015,"Freight & Forwarding",24]
[null,null,"Ultratech Cement",2015,"Fixed Cost",24]
[null,null,"Ultratech Cement",2015,"Profit",9]
[null,null,"Ambuja Cement",2015,"Other variable cost",11]
[null,null,"Ambuja Cement",2015,"Power & Fuel",22]
[null,null,"Ambuja Cement",2015,"Freight & Forwarding",27]
[null,null,"Ambuja Cement",2015,"Fixed Cost",30]
[null,null,"Ambuja Cement",2015,"Profit",10]
[null,null,"JK Lakshmi Cement",2015,"Other variable cost",29]
[null,null,"JK Lakshmi Cement",2015,"Power & Fuel",21]
[null,null,"JK Lakshmi Cement",2015,"Freight & Forwarding",22]
[null,null,"JK Lakshmi Cement",2015,"Fixed Cost",18]
[null,null,"JK Lakshmi Cement",2015,"Profit",10]

{"sheet":"All company ","index":7,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Summer av Value",null,"Year"]
["Variable","Company",2011,2012,2013,2014,2015,"Totalsum"]
["Fixed Cost","ACC Ltd",27,26,29,29,30,141]
[null,"Ambuja Cement",25,25,27,27,30,134]
[null,"JK Lakshmi Cement",19,20,19,19,18,95]
[null,"Ultratech Cement",24,22,22,24,24,116]
["Freight & Forwarding","ACC Ltd",20,20,21,22,23,106]
[null,"Ambuja Cement",23,23,25,24,27,122]
[null,"JK Lakshmi Cement",20,19,21,22,22,104]
[null,"Ultratech Cement",22,20,21,23,24,110]
["Other variable cost","ACC Ltd",15,18,22,20,19,94]
[null,"Ambuja Cement",11,9,13,12,11,56]
[null,"JK Lakshmi Cement",23,25,26,30,29,133]
[null,"Ultratech Cement",16,17,18,19,18,88]
["Power & Fuel","ACC Ltd",23,21,21,21,20,106]
[null,"Ambuja Cement",23,24,22,23,22,114]
[null,"JK Lakshmi Cement",30,24,20,21,21,116]
[null,"Ultratech Cement",23,24,21,20,21,109]
["Profit","ACC Ltd",15,15,7,8,8,53]
[null,"Ambuja Cement",18,19,13,14,10,74]
[null,"JK Lakshmi Cement",8,12,14,8,10,52]
[null,"Ultratech Cement",17,17,8,9,9,60]
["Totalsum",null,402,400,390,395,396,1983]

{"sheet":"Dashboard","index":8,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,1,3,5]]}
[null,"Fixed Cost","Profit","Power & Fuel","Other variable Cost","Freight & Forwarding"]
[null,null,null,null,null,null,null,null,null,"Δ%","Rank"]
[null,{"$f":"\"Between (\"&Calculation!D3&\"-\"&Calculation!E3&\")\"","v":"Between (2011-2015)"},null,null,null,null,null,null,null,{"$f":"+Calculation!Y14","v":0.14999999999999991},{"$f":"+Calculation!Z14","v":2}]
[null,null,null,null,null,null,null,null,null,{"$f":"+Calculation!Y16","v":0.17391304347826098},{"$f":"+Calculation!Z16","v":1}]
[null,null,null,null,null,null,null,null,null,{"$f":"+Calculation!Y17","v":0.10000000000000009},{"$f":"+Calculation!Z17","v":3}]
[null,null,null,null,null,null,null,null,null,{"$f":"+Calculation!Y15","v":9.0909090909090828E-2},{"$f":"+Calculation!Z15","v":4}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'All company '!B4","v":"Company"},{"$f":"+'All company '!C4","v":2011},{"$f":"+'All company '!D4","v":2012},{"$f":"+'All company '!E4","v":2013},{"$f":"+'All company '!F4","v":2014},{"$f":"+'All company '!G4","v":2015},{"$f":"+'All company '!H4","v":"Totalsum"}]
[null,null,null,null,null,null,null,null,{"$f":"+'All company '!A5","v":"Fixed Cost"},{"$f":"+'All company '!B5","v":"ACC Ltd"},{"$f":"+'All company '!C5","v":27},{"$f":"+'All company '!D5","v":26},{"$f":"+'All company '!E5","v":29},{"$f":"+'All company '!F5","v":29},{"$f":"+'All company '!G5","v":30},{"$f":"+'All company '!H5","v":141}]
[null,null,null,null,null,null,null,null,"Fixed Cost",{"$f":"+'All company '!B6","v":"Ambuja Cement"},{"$f":"+'All company '!C6","v":25},{"$f":"+'All company '!D6","v":25},{"$f":"+'All company '!E6","v":27},{"$f":"+'All company '!F6","v":27},{"$f":"+'All company '!G6","v":30},{"$f":"+'All company '!H6","v":134}]
[null,null,null,null,null,null,null,null,"Fixed Cost",{"$f":"+'All company '!B7","v":"JK Lakshmi Cement"},{"$f":"+'All company '!C7","v":19},{"$f":"+'All company '!D7","v":20},{"$f":"+'All company '!E7","v":19},{"$f":"+'All company '!F7","v":19},{"$f":"+'All company '!G7","v":18},{"$f":"+'All company '!H7","v":95}]
[null,null,null,null,null,null,null,null,"Fixed Cost",{"$f":"+'All company '!B8","v":"Ultratech Cement"},{"$f":"+'All company '!C8","v":24},{"$f":"+'All company '!D8","v":22},{"$f":"+'All company '!E8","v":22},{"$f":"+'All company '!F8","v":24},{"$f":"+'All company '!G8","v":24},{"$f":"+'All company '!H8","v":116}]
[null,null,null,null,null,null,null,null,{"$f":"+'All company '!A9","v":"Freight & Forwarding"},{"$f":"+'All company '!B9","v":"ACC Ltd"},{"$f":"+'All company '!C9","v":20},{"$f":"+'All company '!D9","v":20},{"$f":"+'All company '!E9","v":21},{"$f":"+'All company '!F9","v":22},{"$f":"+'All company '!G9","v":23},{"$f":"+'All company '!H9","v":106}]
[null,null,null,null,null,null,null,null,"Freight & Forwarding",{"$f":"+'All company '!B10","v":"Ambuja Cement"},{"$f":"+'All company '!C10","v":23},{"$f":"+'All company '!D10","v":23},{"$f":"+'All company '!E10","v":25},{"$f":"+'All company '!F10","v":24},{"$f":"+'All company '!G10","v":27},{"$f":"+'All company '!H10","v":122}]
[null,null,null,null,null,null,null,null,"Freight & Forwarding",{"$f":"+'All company '!B11","v":"JK Lakshmi Cement"},{"$f":"+'All company '!C11","v":20},{"$f":"+'All company '!D11","v":19},{"$f":"+'All company '!E11","v":21},{"$f":"+'All company '!F11","v":22},{"$f":"+'All company '!G11","v":22},{"$f":"+'All company '!H11","v":104}]
[null,null,null,null,null,null,null,null,"Freight & Forwarding",{"$f":"+'All company '!B12","v":"Ultratech Cement"},{"$f":"+'All company '!C12","v":22},{"$f":"+'All company '!D12","v":20},{"$f":"+'All company '!E12","v":21},{"$f":"+'All company '!F12","v":23},{"$f":"+'All company '!G12","v":24},{"$f":"+'All company '!H12","v":110}]
[null,null,null,null,null,null,null,null,{"$f":"+'All company '!A13","v":"Other variable cost"},{"$f":"+'All company '!B13","v":"ACC Ltd"},{"$f":"+'All company '!C13","v":15},{"$f":"+'All company '!D13","v":18},{"$f":"+'All company '!E13","v":22},{"$f":"+'All company '!F13","v":20},{"$f":"+'All company '!G13","v":19},{"$f":"+'All company '!H13","v":94}]
[null,null,null,null,null,null,null,null,"Other variable cost",{"$f":"+'All company '!B14","v":"Ambuja Cement"},{"$f":"+'All company '!C14","v":11},{"$f":"+'All company '!D14","v":9},{"$f":"+'All company '!E14","v":13},{"$f":"+'All company '!F14","v":12},{"$f":"+'All company '!G14","v":11},{"$f":"+'All company '!H14","v":56}]
[null,null,null,null,null,null,null,null,"Other variable cost",{"$f":"+'All company '!B15","v":"JK Lakshmi Cement"},{"$f":"+'All company '!C15","v":23},{"$f":"+'All company '!D15","v":25},{"$f":"+'All company '!E15","v":26},{"$f":"+'All company '!F15","v":30},{"$f":"+'All company '!G15","v":29},{"$f":"+'All company '!H15","v":133}]
[null,null,null,null,null,null,null,null,"Other variable cost",{"$f":"+'All company '!B16","v":"Ultratech Cement"},{"$f":"+'All company '!C16","v":16},{"$f":"+'All company '!D16","v":17},{"$f":"+'All company '!E16","v":18},{"$f":"+'All company '!F16","v":19},{"$f":"+'All company '!G16","v":18},{"$f":"+'All company '!H16","v":88}]
[null,null,null,null,null,null,null,null,{"$f":"+'All company '!A17","v":"Power & Fuel"},{"$f":"+'All company '!B17","v":"ACC Ltd"},{"$f":"+'All company '!C17","v":23},{"$f":"+'All company '!D17","v":21},{"$f":"+'All company '!E17","v":21},{"$f":"+'All company '!F17","v":21},{"$f":"+'All company '!G17","v":20},{"$f":"+'All company '!H17","v":106}]
[null,null,null,null,null,null,null,null,"Power & Fuel",{"$f":"+'All company '!B18","v":"Ambuja Cement"},{"$f":"+'All company '!C18","v":23},{"$f":"+'All company '!D18","v":24},{"$f":"+'All company '!E18","v":22},{"$f":"+'All company '!F18","v":23},{"$f":"+'All company '!G18","v":22},{"$f":"+'All company '!H18","v":114}]
[null,null,null,null,null,null,null,null,"Power & Fuel",{"$f":"+'All company '!B19","v":"JK Lakshmi Cement"},{"$f":"+'All company '!C19","v":30},{"$f":"+'All company '!D19","v":24},{"$f":"+'All company '!E19","v":20},{"$f":"+'All company '!F19","v":21},{"$f":"+'All company '!G19","v":21},{"$f":"+'All company '!H19","v":116}]
[null,null,null,null,null,null,null,null,"Power & Fuel",{"$f":"+'All company '!B20","v":"Ultratech Cement"},{"$f":"+'All company '!C20","v":23},{"$f":"+'All company '!D20","v":24},{"$f":"+'All company '!E20","v":21},{"$f":"+'All company '!F20","v":20},{"$f":"+'All company '!G20","v":21},{"$f":"+'All company '!H20","v":109}]
[null,null,null,null,null,null,null,null,{"$f":"+'All company '!A21","v":"Profit"},{"$f":"+'All company '!B21","v":"ACC Ltd"},{"$f":"+'All company '!C21","v":15},{"$f":"+'All company '!D21","v":15},{"$f":"+'All company '!E21","v":7},{"$f":"+'All company '!F21","v":8},{"$f":"+'All company '!G21","v":8},{"$f":"+'All company '!H21","v":53}]
[null,null,null,null,null,null,null,null,"Profit",{"$f":"+'All company '!B22","v":"Ambuja Cement"},{"$f":"+'All company '!C22","v":18},{"$f":"+'All company '!D22","v":19},{"$f":"+'All company '!E22","v":13},{"$f":"+'All company '!F22","v":14},{"$f":"+'All company '!G22","v":10},{"$f":"+'All company '!H22","v":74}]
[null,null,null,null,null,null,null,null,"Profit",{"$f":"+'All company '!B23","v":"JK Lakshmi Cement"},{"$f":"+'All company '!C23","v":8},{"$f":"+'All company '!D23","v":12},{"$f":"+'All company '!E23","v":14},{"$f":"+'All company '!F23","v":8},{"$f":"+'All company '!G23","v":10},{"$f":"+'All company '!H23","v":52}]
[null,null,null,null,null,null,null,null,"Profit",{"$f":"+'All company '!B24","v":"Ultratech Cement"},{"$f":"+'All company '!C24","v":17},{"$f":"+'All company '!D24","v":17},{"$f":"+'All company '!E24","v":8},{"$f":"+'All company '!F24","v":9},{"$f":"+'All company '!G24","v":9},{"$f":"+'All company '!H24","v":60}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]

{"sheet":"Ark1","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Calculation","index":10,"n_rows":17,"n_cols":26,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"First year","Last year"]
[null,"Year count",{"$f":"COUNT('Fixed Cost'!A:A)","v":5},{"$f":"'Fixed Cost'!$A$5","v":2011},{"$f":"INDEX('Fixed Cost'!A:A,YearCount+4)","v":2015}]
[null,"Company count",{"$f":"COUNT('Fixed Cost'!A:A)-1","v":4}]
[]
[null,"Selected chart type","Freight & Forwarding"]
[null,"Chart number",{"$f":"MATCH(Chart.selection,Chart.choicesdash2,0)","v":5}]
[null,"chart name",{"$f":"+CHOOSE(C7,\"FixedCost\",\"Profit\",\"Power&Fuel\",\"OthervariableCost\",\"Freight&Forwarding\")&\"Chart\"","v":"Freight&ForwardingChart"},null,null,null,"Chart.selection"]
[null,null,null,null,null,null,"Chart.choicesdash"]
[null,null,null,null,null,null,"Chart.name"]
[]
[null,null,"Fixed Cost","Fixed Cost","Profit","Profit","Power & Fuel","Power & Fuel","Other Variable Cost","Other Variable Cost","Freight & Forwarding","Freight & Forwarding",null,null,null,null,null,null,null,null,null,null,null,null,"Ti display"]
[null,"Company","First year","last year","First year","last year","First year","last year","First year","last year","First year","last year",null,"% Change","Rank","% Change","Rank","% Change","Rank","% Change","Rank","% Change","Rank",null,"% change"]
[null,"ACC Ltd",{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B14,\"year\",FirstYear,\"variable\",C$12)","v":27},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B14,\"year\",LastYear,\"variable\",D$12)","v":30},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B14,\"year\",FirstYear,\"variable\",E$12)","v":15},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B14,\"year\",LastYear,\"variable\",F$12)","v":8},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B14,\"year\",FirstYear,\"variable\",G$12)","v":23},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B14,\"year\",LastYear,\"variable\",H$12)","v":20},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B14,\"year\",FirstYear,\"variable\",I$12)","v":15},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B14,\"year\",LastYear,\"variable\",J$12)","v":19},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B14,\"year\",FirstYear,\"variable\",K$12)","v":20},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B14,\"year\",LastYear,\"variable\",L$12)","v":23},null,{"$f":"D14/C14-1","v":0.11111111111111116},{"$f":"_xlfn.RANK.EQ(N14,N$14:N$17)","v":2},{"$f":"F14/E14-1","v":-0.46666666666666667},{"$f":"_xlfn.RANK.EQ(P14,P$14:P$17)","v":3},{"$f":"H14/G14-1","v":-0.13043478260869568},{"$f":"_xlfn.RANK.EQ(R14,R$14:R$17)","v":3},{"$f":"J14/I14-1","v":0.26666666666666661},{"$f":"_xlfn.RANK.EQ(T14,T$14:T$17)","v":1},{"$f":"L14/K14-1","v":0.14999999999999991},{"$f":"_xlfn.RANK.EQ(V14,V$14:V$17)","v":2},null,{"$f":"INDEX($N14:$W14,($C$7-1)*2+1)","v":0.14999999999999991},{"$f":"INDEX($N14:$W14,($C$7)*2)","v":2}]
[null,"Ultratech Cement",{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B15,\"year\",FirstYear,\"variable\",C$12)","v":24},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B15,\"year\",LastYear,\"variable\",D$12)","v":24},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B15,\"year\",FirstYear,\"variable\",E$12)","v":17},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B15,\"year\",LastYear,\"variable\",F$12)","v":9},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B15,\"year\",FirstYear,\"variable\",G$12)","v":23},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B15,\"year\",LastYear,\"variable\",H$12)","v":21},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B15,\"year\",FirstYear,\"variable\",I$12)","v":16},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B15,\"year\",LastYear,\"variable\",J$12)","v":18},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B15,\"year\",FirstYear,\"variable\",K$12)","v":22},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B15,\"year\",LastYear,\"variable\",L$12)","v":24},null,{"$f":"D15/C15-1","v":0},{"$f":"_xlfn.RANK.EQ(N15,N$14:N$17)","v":3},{"$f":"F15/E15-1","v":-0.47058823529411764},{"$f":"_xlfn.RANK.EQ(P15,P$14:P$17)","v":4},{"$f":"H15/G15-1","v":-8.6956521739130488E-2},{"$f":"_xlfn.RANK.EQ(R15,R$14:R$17)","v":2},{"$f":"J15/I15-1","v":0.125},3,{"$f":"L15/K15-1","v":9.0909090909090828E-2},4,null,{"$f":"INDEX($N15:$W15,($C$7-1)*2+1)","v":9.0909090909090828E-2},{"$f":"INDEX($N15:$W15,($C$7)*2)","v":4}]
[null,"Ambuja Cement",{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B16,\"year\",FirstYear,\"variable\",C$12)","v":25},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B16,\"year\",LastYear,\"variable\",D$12)","v":30},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B16,\"year\",FirstYear,\"variable\",E$12)","v":18},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B16,\"year\",LastYear,\"variable\",F$12)","v":10},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B16,\"year\",FirstYear,\"variable\",G$12)","v":23},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B16,\"year\",LastYear,\"variable\",H$12)","v":22},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B16,\"year\",FirstYear,\"variable\",I$12)","v":11},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B16,\"year\",LastYear,\"variable\",J$12)","v":11},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B16,\"year\",FirstYear,\"variable\",K$12)","v":23},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B16,\"year\",LastYear,\"variable\",L$12)","v":27},null,{"$f":"D16/C16-1","v":0.19999999999999996},{"$f":"_xlfn.RANK.EQ(N16,N$14:N$17)","v":1},{"$f":"F16/E16-1","v":-0.44444444444444442},2,-4.3478260869565188E-2,{"$f":"_xlfn.RANK.EQ(R16,R$14:R$17)","v":1},0,4,0.17391304347826098,{"$f":"_xlfn.RANK.EQ(V16,V$14:V$17)","v":1},null,{"$f":"INDEX($N16:$W16,($C$7-1)*2+1)","v":0.17391304347826098},1]
[null,"JK Lakshmi Cement",{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B17,\"year\",FirstYear,\"variable\",C$12)","v":19},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B17,\"year\",LastYear,\"variable\",D$12)","v":18},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B17,\"year\",FirstYear,\"variable\",E$12)","v":8},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B17,\"year\",LastYear,\"variable\",F$12)","v":10},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B17,\"year\",FirstYear,\"variable\",G$12)","v":30},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B17,\"year\",LastYear,\"variable\",H$12)","v":21},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B17,\"year\",FirstYear,\"variable\",I$12)","v":23},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B17,\"year\",LastYear,\"variable\",J$12)","v":29},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B17,\"year\",FirstYear,\"variable\",K$12)","v":20},{"$f":"GETPIVOTDATA(\"value\",'All company '!$A$3,\"Company\",$B17,\"year\",LastYear,\"variable\",L$12)","v":22},null,-5.2631578947368474E-2,{"$f":"_xlfn.RANK.EQ(N17,N$14:N$17)","v":4},0.25,{"$f":"_xlfn.RANK.EQ(P17,P$14:P$17)","v":1},-0.30000000000000004,{"$f":"_xlfn.RANK.EQ(R17,R$14:R$17)","v":4},0.26086956521739135,{"$f":"_xlfn.RANK.EQ(T17,T$14:T$17)","v":2},0.10000000000000009,3,null,0.10000000000000009,3]