{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cognos_Office_Connection_Cache","DATA","PAF","ROY","COS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Cognos_Office_Connection_Cache","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"DATA","index":1,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,1,null,{"$f":"IF(ISBLANK(E2),D2&E3,E2&E3)","v":"Product1Units"},{"$f":"IF(ISBLANK(F2),E2&F3,F2&F3)","v":"Product1Revenue LC"},{"$f":"IF(ISBLANK(G2),F2&G3,G2&G3)","v":"Product2Units"},"Product2Revenue LC","Product3Units","Product3Revenue LC","Product4Units","Product4Revenue LC","Product5Units","Product5Revenue LC"]
[null,null,{"$f":"+C1+1","v":2},null,"Product1",null,"Product2",null,"Product3",null,"Product4",null,"Product5"]
[null,null,{"$f":"+C2+1","v":3},null,"Units","Revenue LC","Units","Revenue LC","Units","Revenue LC","Units","Revenue LC","Units","Revenue LC"]
[{"$f":"+IF(LEFT(D4,1)=\"S\",LEFT(D4,4),LEFT(D4,6))","v":"S080"},{"$f":"IF(LEFT(A4,1)=\"S\",MID(D4,11,100),MID(D4,10,100))","v":"COUNTRY"},4,"S080---AV COUNTRY",5,{"$f":"SUM(F5:F9)","v":7000},4,{"$f":"SUM(H5:H9)","v":4200},3,{"$f":"SUM(J5:J9)","v":2400},2,1100,1,400]
[{"$f":"+IF(LEFT(D5,1)=\"S\",LEFT(D5,4),LEFT(D5,6))","v":"115141"},{"$f":"IF(LEFT(A5,1)=\"S\",MID(D5,11,100),MID(D5,10,100))","v":"JJDD"},5,"115141---JJDD",1,1200,0,0,0,0,0,0,0,0]
["102521",{"$f":"IF(LEFT(A6,1)=\"S\",MID(D6,11,100),MID(D6,10,100))","v":"JJDD22"},6,"102521---JJDD22",1,1300,1,900,0,0,0,0,0,0]
["102624","JJDD33",7,"102624---JJDD33",1,1400,1,1000,1,700,0,0,0,0]
["127797","JJDD44",8,"127797---JJDD44",1,1500,1,1100,1,800,1,500,0,0]
["124570","JJDD44",9,"124570---JJDD44",1,1600,1,1200,1,900,1,600,1,400]

{"sheet":"PAF","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[7,6,7,10],[1,6,1,7],[2,6,2,7],[3,6,3,7],[4,6,4,7],[1,10,1,11]]}
[]
[null,null,{"$f":"VLOOKUP(G2,DATA!$A:$C,3,FALSE)","v":6},null,"Account number",null,"102521"]
[null,null,{"$f":"VLOOKUP(G3,DATA!$B:$C,2,FALSE)","v":4},null,"Country",null,{"$f":"IFERROR(IF(VLOOKUP(G2,DATA!A4:A9,1,FALSE)=PAF!G2,\"Country\",\"\"),\"Country2\")","v":"Country"}]
[null,null,null,null,"Start period",null,"2015-02-01"]
[null,null,{"$f":"ROUND((+G5-G4)/30,0)","v":23},null,"End period",null,"2016-12-31"]
[]
[]
[null,null,null,null,null,null,"LAST 12 MONTHS"]
[]
["2015 Roy","2015 Std costs","To keep?",null,"Product",null,"Units","ASP","Revenue LC","Margin LC","Margin %"]
[]
[{"$f":"VLOOKUP(E12,ROY!B5:P9,15,FALSE)","v":6.0000000000000019E-2},{"$f":"VLOOKUP(E12,COS!B:N,13,FALSE)","v":115.38461538461539},{"$f":"+I12","v":1.3},null,"Product1",null,{"$f":"IFERROR(HLOOKUP($E12&$G$10,DATA!$D:$N,PAF!$C$2,FALSE),\"\")","v":1},{"$f":"IFERROR(I12/G12*1000,0)","v":1300},{"$f":"IFERROR(HLOOKUP($E12&$I$10,DATA!$D:$N,PAF!$C$2,FALSE)/1000,\"\")","v":1.3},{"$f":"+I12-A12*I12-B12*G12/1000","v":1.1066153846153846},{"$f":"IFERROR(J12/I12,0)","v":0.8512426035502958}]
[{"$f":"VLOOKUP(E13,ROY!B6:P10,15,FALSE)","v":6.0000000000000019E-2},{"$f":"VLOOKUP(E13,COS!B:N,13,FALSE)","v":115.38461538461539},0.9,null,"Product2",null,{"$f":"IFERROR(HLOOKUP($E13&$G$10,DATA!$D:$N,PAF!$C$2,FALSE),\"\")","v":1},900,{"$f":"IFERROR(HLOOKUP($E13&$I$10,DATA!$D:$N,PAF!$C$2,FALSE)/1000,\"\")","v":0.9},{"$f":"+I13-A13*I13-B13*G13/1000","v":0.73061538461538456},0.81179487179487175]
[{"$f":"VLOOKUP(E14,ROY!B7:P11,15,FALSE)","v":6.0000000000000019E-2},{"$f":"VLOOKUP(E14,COS!B:N,13,FALSE)","v":115.38461538461539},{"$f":"+I14","v":0},null,"Product3",null,{"$f":"IFERROR(HLOOKUP($E14&$G$10,DATA!$D:$N,PAF!$C$2,FALSE),\"\")","v":0},0,{"$f":"IFERROR(HLOOKUP($E14&$I$10,DATA!$D:$N,PAF!$C$2,FALSE)/1000,\"\")","v":0},{"$f":"+I14-A14*I14-B14*G14/1000","v":0},0]
[{"$f":"VLOOKUP(E15,ROY!B8:P12,15,FALSE)","v":6.0000000000000019E-2},{"$f":"VLOOKUP(E15,COS!B:N,13,FALSE)","v":115.38461538461539},{"$f":"+I15","v":0},null,"Product4",null,{"$f":"IFERROR(HLOOKUP($E15&$G$10,DATA!$D:$N,PAF!$C$2,FALSE),\"\")","v":0},0,{"$f":"IFERROR(HLOOKUP($E15&$I$10,DATA!$D:$N,PAF!$C$2,FALSE)/1000,\"\")","v":0},{"$f":"+I15-A15*I15-B15*G15/1000","v":0},{"$f":"IFERROR(J15/I15,0)","v":0}]
[{"$f":"VLOOKUP(E16,ROY!B9:P13,15,FALSE)","v":6.0000000000000019E-2},{"$f":"VLOOKUP(E16,COS!B:N,13,FALSE)","v":115.38461538461539},0,null,"Product5",null,{"$f":"IFERROR(HLOOKUP($E16&$G$10,DATA!$D:$N,PAF!$C$2,FALSE),\"\")","v":0},0,{"$f":"IFERROR(HLOOKUP($E16&$I$10,DATA!$D:$N,PAF!$C$2,FALSE)/1000,\"\")","v":0},{"$f":"+I16-A16*I16-B16*G16/1000","v":0},0]
[]
[null,null,null,null,"TOTAL",null,null,null,{"$f":"+SUM(I12:I16)","v":2.2000000000000002},{"$f":"+SUM(J12:J16)","v":1.8372307692307692},{"$f":"+J18/I18","v":0.83510489510489505}]

{"sheet":"ROY","index":3,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,15]]}
[null,2015]
[]
["Cognos matching",null,"FYP_01","FYP_02","FYP_03","FYP_04","FYP_05","FYP_06","FYP_07","FYP_08","FYP_09","FYP_10","FYP_11","FYP_12",null,"2015 Avg"]
[null,"No Product",0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,null,{"$f":"IFERROR(AVERAGE(C4:N4),\"#Missing\")","v":6.0000000000000019E-2}]
["Xience V","Product1",0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,null,{"$f":"IFERROR(AVERAGE(C5:N5),\"#Missing\")","v":6.0000000000000019E-2}]
["Xience Nano","Product2",0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,null,6.0000000000000019E-2]
["Xience Prime","Product3",0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,null,6.0000000000000019E-2]
["Xience Prime LL","Product4",0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,null,6.0000000000000019E-2]
["Xience SBA","Product5",0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,null,6.0000000000000019E-2]

{"sheet":"COS","index":4,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,"FY07","FY08","FY09","FY10","FY11","FY12","FY13","FY14","FY15","FY16","FY14 LC","FY15 LC"]
[null,"No Product",150,150,150,150,150,150,150,150,150,150,{"$f":"+J2/1.3","v":115.38461538461539},{"$f":"+K2/1.3","v":115.38461538461539}]
[null,"Product1",150,150,150,150,150,150,150,150,150,150,{"$f":"+J3/1.3","v":115.38461538461539},{"$f":"+K3/1.3","v":115.38461538461539}]
[null,"Product2",150,150,150,150,150,150,150,150,150,150,115.38461538461539,115.38461538461539]
[null,"Product3",150,150,150,150,150,150,150,150,150,150,115.38461538461539,115.38461538461539]
[null,"Product4",150,150,150,150,150,150,150,150,150,150,115.38461538461539,115.38461538461539]
[null,"Product5",150,150,150,150,150,150,150,150,150,150,115.38461538461539,115.38461538461539]