{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["(826-old-an)","(828)","(828an)","(829)","(829an)"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":0,"comments":2,"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":"(826-old-an)","index":0,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["IF there is a tie in the scores, then award the highest rank to the largest weight"]
[]
["Weight","Score (Biggest best)","Rank",null,"add","RANK or RANK.EQ","What we want is:"]
[182,5,{"$f":"_xlfn.RANK.EQ(B4,$B$4:$B$14,0)+SUMPRODUCT(--(B4=$B$4:$B$14),--(A4<$A$4:$A$14))","v":6},null,null,{"$f":"_xlfn.RANK.EQ(B4,$B$4:$B$14,0)","v":6}]
[184,2,{"$f":"_xlfn.RANK.EQ(B5,$B$4:$B$14,0)+SUMPRODUCT(--(B5=$B$4:$B$14),--(A5<$A$4:$A$14))","v":10},null,null,{"$f":"_xlfn.RANK.EQ(B5,$B$4:$B$14,0)","v":7}]
[205,7,3,null,1,2,{"$f":"\"because '\"&B6&\"' has weight of '\"&A6&\"' we want rank of 3\"","v":"because '7' has weight of '205' we want rank of 3"}]
[199,1,11,null,null,11]
[188,7,5,null,3,2,{"$f":"\"because '\"&B8&\"' has weight of '\"&A8&\"' we want rank of 5\"","v":"because '7' has weight of '188' we want rank of 5"}]
[185,2,8,null,null,7]
[190,7,4,null,2,2,{"$f":"\"because '\"&B10&\"' has weight of '\"&A10&\"' we want rank of 4\"","v":"because '7' has weight of '190' we want rank of 4"}]
[188,2,7,null,null,7]
[207,7,2,null,0,2,{"$f":"\"because '\"&B12&\"' has weight of '\"&A12&\"' we want rank of 2\"","v":"because '7' has weight of '207' we want rank of 2"}]
[187,9,1,null,null,1]
[185,2,8,null,null,7]

{"sheet":"(828)","index":1,"n_rows":150,"n_cols":24,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
["Sunshine 10 Ply",20.5,"15/05/08/10"]
[]
["Individual Discounts",0.15,0.05,0.08,0.1]
["Compliments (Cost)"]
[]
["Net Cost Equilvalent"]
["Wholesale Price"]
[]
["Product","Retail Price","Series Discount (Enter each Discount as 2-digits)",null,null,null,null,"Net Cost Equilalent","Wholesale Price"]
["Quad",30.25,"20/05/10/20"]
["Bellen",25.25,"10/10/08/18"]
["Carlota",21.95,"15/10/16/16"]
["Carlota Doublers",55.95,"05/05/08/08"]
["Majestic Beaut",23.95,"10/05/16/20"]
["Sunshine 5 Ply",19.25,"15/10/08/14"]
["Sunshine 10 Ply",20.5,"15/05/08/10"]
["Sunset",23.5,"15/15/14/08"]
["Sunbell",26.95,"15/05/10"]
["Flattop",20.95,"15/10"]
["Bellen Dancer",29.95,"10"]
["Bellen Wind Dancer",32.25,"15/05/18/06"]
["GelFast",21.5,"05/15/10/16"]
["Phenolic Sunshine",35.5,"10/05/16/16"]
["Icarus MTA",35.25,"20/15/06/16"]
[]
["Product","Retail Price","Series Discount (Enter each Discount as 2-digits)","Net Cost Equilalent","Wholesale Price"]
["Quad",30.25,"20/05/10/20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C27,CHOOSE(LEN(C27)-LEN(SUBSTITUTE(C27,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.54720000000000002}]
["Bellen",25.25,"10/10/08/18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C28,CHOOSE(LEN(C28)-LEN(SUBSTITUTE(C28,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.61106400000000016}]
["Carlota",21.95,"15/10/16/16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C29,CHOOSE(LEN(C29)-LEN(SUBSTITUTE(C29,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.53978399999999993}]
["Carlota Doublers",55.95,"05/05/08/08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C30,CHOOSE(LEN(C30)-LEN(SUBSTITUTE(C30,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.76387600000000011}]
["Majestic Beaut",23.95,"10/05/16/20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C31,CHOOSE(LEN(C31)-LEN(SUBSTITUTE(C31,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.57455999999999996}]
["Sunshine 5 Ply",19.25,"15/10/08/14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C32,CHOOSE(LEN(C32)-LEN(SUBSTITUTE(C32,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.60526800000000003}]
["Sunshine 10 Ply",20.5,"15/05/08/10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C33,CHOOSE(LEN(C33)-LEN(SUBSTITUTE(C33,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.66861000000000004}]
["Sunset",23.5,"15/15/14/08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C34,CHOOSE(LEN(C34)-LEN(SUBSTITUTE(C34,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.57164199999999998}]
["Sunbell",26.95,"15/05/10/14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C35,CHOOSE(LEN(C35)-LEN(SUBSTITUTE(C35,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.62500500000000003},0.15,0.05,0.1,{"$f":"PRODUCT(1-U35:W35)","v":0.72675000000000001}]
["Flattop",20.95,"15/10/16/14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C36,CHOOSE(LEN(C36)-LEN(SUBSTITUTE(C36,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.55263599999999991},0.15,0.1,null,{"$f":"PRODUCT(1-U36:W36)","v":0.76500000000000001}]
["Bellen Dancer",29.95,"10/05/18/06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C37,CHOOSE(LEN(C37)-LEN(SUBSTITUTE(C37,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.65903400000000001},0.1,null,null,{"$f":"PRODUCT(1-U37:W37)","v":0.9}]
["Bellen Wind Dancer",32.25,"15/05/18/06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C38,CHOOSE(LEN(C38)-LEN(SUBSTITUTE(C38,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.622421}]
["GelFast",21.5,"05/15/10/16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C39,CHOOSE(LEN(C39)-LEN(SUBSTITUTE(C39,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.61046999999999996}]
["Phenolic Sunshine",35.5,"10/05/16/16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C40,CHOOSE(LEN(C40)-LEN(SUBSTITUTE(C40,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.60328799999999994}]
["Icarus MTA",35.25,"20/15/06/16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C41,CHOOSE(LEN(C41)-LEN(SUBSTITUTE(C41,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.53692799999999996}]
[]
[]
["Product","Retail Price","Series Discount (Enter each Discount as 2-digits)","Net Cost Equilalent","Wholesale Price"]
["Quad",30.25,"20/05/10/20"]
["Bellen",25.25,"10/10/08/18"]
["Carlota",21.95,"15/10/16/16"]
["Carlota Doublers",55.95,"05/05/08/08"]
["Majestic Beaut",23.95,"10/05/16/20"]
["Sunshine 5 Ply",19.25,"15/10/08/14"]
["Sunshine 10 Ply",20.5,"15/05/08/10"]
["Sunset",23.5,"15/15/14/08",null,null,"{1,4,7,10}"]
["Sunbell",26.95,"15/05/10",null,null,"{1,4,7}"]
["Flattop",20.95,"15/10",null,null,"{1,4}"]
["Bellen Dancer",29.95,"10",null,null,1]
["Bellen Wind Dancer",32.25,"15/05/18/06"]
["GelFast",21.5,"05/15/10/16"]
["Phenolic Sunshine",35.5,"10/05/16/16"]
["Icarus MTA",35.25,"20/15/06/16"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,1]
[null,null,null,null,4]
[null,null,null,null,7,{"$f":"SUBSTITUTE($C$27,\"/\",\"^\",ROWS(F$134:F134))","v":"20^05/10/20"},{"$f":"SEARCH(\"^\",F134)-1","v":2}]
[null,null,null,null,10,{"$f":"SUBSTITUTE($C$27,\"/\",\"^\",ROWS(F$134:F135))","v":"20/05^10/20"},{"$f":"SEARCH(\"^\",F135)-1","v":5}]
[null,"Series Discount","20/5/1/20",{"$f":"REPLACE(C136,SEARCH(\"/\",C136)+1,0,0)","v":"20/05/1/20"},null,{"$f":"SUBSTITUTE($C$27,\"/\",\"^\",ROWS(F$134:F136))","v":"20/05/10^20"},{"$f":"SEARCH(\"^\",F136)-1","v":8}]
[null,null,{"$f":"MID($C$136,3*ROWS(C$137:C137)-2,2)/100","v":0.2},null,{"$f":"1+(ROWS(E$137:E137)-1)*3","v":1},{"$f":"1+(3*ROWS(E$137:E137)-3)","v":1},{"$f":"1+3*ROWS(E$137:E137)-3","v":1},{"$f":"3*ROWS(E$137:E137)-2","v":1}]
[null,null,{"$f":"MID($C$136,3*ROWS(C$137:C138)-2,2)/100","v":{"$error":"#VALUE!"}},null,{"$f":"1+(ROWS(E$137:E138)-1)*3","v":4},{"$f":"1+(3*ROWS(E$137:E138)-3)","v":4},{"$f":"1+3*ROWS(E$137:E138)-3","v":4},{"$f":"3*ROWS(E$137:E138)-2","v":4}]
[null,null,{"$f":"MID($C$136,3*ROWS(C$137:C139)-2,2)/100","v":{"$error":"#VALUE!"}},null,{"$f":"1+(ROWS(E$137:E139)-1)*3","v":7},{"$f":"1+(3*ROWS(E$137:E139)-3)","v":7},{"$f":"1+3*ROWS(E$137:E139)-3","v":7},{"$f":"3*ROWS(E$137:E139)-2","v":7}]
[null,null,{"$f":"MID($C$136,3*ROWS(C$137:C140)-2,2)/100","v":{"$error":"#VALUE!"}},null,{"$f":"1+(ROWS(E$137:E140)-1)*3","v":10},{"$f":"1+(3*ROWS(E$137:E140)-3)","v":10},{"$f":"1+3*ROWS(E$137:E140)-3","v":10},{"$f":"3*ROWS(E$137:E140)-2","v":10}]
[]
[null,null,null,{"$f":"SUBSTITUTE($C$136,\"/\",\"/0\",{1,2,3})","v":"20/05/1/20"},null,{"$f":"INDEX(SUBSTITUTE($C$136,\"/\",\"/0\",{1,2,3}),ROWS(F$142:F142))","v":"20/05/1/20"}]
[null,null,null,"20/05/1/20",null,{"$f":"INDEX(SUBSTITUTE($C$136,\"/\",\"/0\",{1,2,3}),ROWS(F$142:F143))","v":"20/5/01/20"}]
[null,null,null,"20/05/1/20",null,{"$f":"INDEX(SUBSTITUTE($C$136,\"/\",\"/0\",{1,2,3}),ROWS(F$142:F144))","v":"20/5/1/020"}]
[null,null,null,"20/05/1/20",null,{"$f":"INDEX(SUBSTITUTE($C$136,\"/\",\"/0\",{1,2,3}),ROWS(F$142:F145))","v":{"$error":"#REF!"}}]
[]
[null,null,null,"Series Discount","20/5/10/20"]
[null,null,null,null,{"$f":"SUBSTITUTE($E$147,\"/\",\"/0\",ROWS(E$148:E148))","v":"20/05/10/20"},{"$f":"INDEX(SUBSTITUTE($E$147,\"/\",\"/0\",{1,2,3}),ROWS(F$148:F148))","v":"20/05/10/20"}]
[null,null,null,null,{"$f":"SUBSTITUTE($E$147,\"/\",\"/0\",ROWS(E$148:E149))","v":"20/5/010/20"},{"$f":"INDEX(SUBSTITUTE($E$147,\"/\",\"/0\",{1,2,3}),ROWS(F$148:F149))","v":"20/5/010/20"}]
[null,null,null,null,{"$f":"SUBSTITUTE($E$147,\"/\",\"/0\",ROWS(E$148:E150))","v":"20/5/10/020"},{"$f":"INDEX(SUBSTITUTE($E$147,\"/\",\"/0\",{1,2,3}),ROWS(F$148:F150))","v":"20/5/10/020"}]

{"sheet":"(828an)","index":2,"n_rows":150,"n_cols":24,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
["Sunshine 10 Ply",20.5,"15/05/08/10"]
[]
["Individual Discounts",0.15,0.05,0.08,0.1]
["Compliments (Cost)",{"$f":"1-B3","v":0.85},{"$f":"1-C3","v":0.95},0.92,0.9]
[]
["Net Cost Equilvalent",{"$f":"PRODUCT(B4:E4)","v":0.66861000000000004}]
["Wholesale Price",{"$f":"ROUND(B1*B6,2)","v":13.71}]
[]
["Product","Retail Price","Series Discount (Enter each Discount as 2-digits)",null,null,null,null,"Net Cost Equilalent","Wholesale Price"]
["Quad",30.25,"20/05/10/20",20,5,10,20,{"$f":"PRODUCT(1-D10:G10/100)","v":0.54720000000000002},{"$f":"ROUND(B10*PRODUCT(1-D10:G10/100),2)","v":16.55}]
["Bellen",25.25,"10/10/08/18",10,10,8,18,{"$f":"PRODUCT(1-D11:G11/100)","v":0.61106400000000016},{"$f":"ROUND(B11*PRODUCT(1-D11:G11/100),2)","v":15.43}]
["Carlota",21.95,"15/10/16/16",15,10,16,16,{"$f":"PRODUCT(1-D12:G12/100)","v":0.53978399999999993},{"$f":"ROUND(B12*PRODUCT(1-D12:G12/100),2)","v":11.85}]
["Carlota Doublers",55.95,"05/05/08/08",5,5,8,8,{"$f":"PRODUCT(1-D13:G13/100)","v":0.76387600000000011},{"$f":"ROUND(B13*PRODUCT(1-D13:G13/100),2)","v":42.74}]
["Majestic Beaut",23.95,"10/05/16/20",10,5,16,20,{"$f":"PRODUCT(1-D14:G14/100)","v":0.57455999999999996},{"$f":"ROUND(B14*PRODUCT(1-D14:G14/100),2)","v":13.76}]
["Sunshine 5 Ply",19.25,"15/10/08/14",15,10,8,14,{"$f":"PRODUCT(1-D15:G15/100)","v":0.60526800000000003},{"$f":"ROUND(B15*PRODUCT(1-D15:G15/100),2)","v":11.65}]
["Sunshine 10 Ply",20.5,"15/05/08/10",15,5,8,10,{"$f":"PRODUCT(1-D16:G16/100)","v":0.66861000000000004},{"$f":"ROUND(B16*PRODUCT(1-D16:G16/100),2)","v":13.71}]
["Sunset",23.5,"15/15/14/08",15,15,14,8,{"$f":"PRODUCT(1-D17:G17/100)","v":0.57164199999999998},{"$f":"ROUND(B17*PRODUCT(1-D17:G17/100),2)","v":13.43}]
["Sunbell",26.95,"15/05/10",15,5,10,null,{"$f":"PRODUCT(1-D18:G18/100)","v":0.72675000000000001},{"$f":"ROUND(B18*PRODUCT(1-D18:G18/100),2)","v":19.59}]
["Flattop",20.95,"15/10",15,10,null,null,{"$f":"PRODUCT(1-D19:G19/100)","v":0.76500000000000001},{"$f":"ROUND(B19*PRODUCT(1-D19:G19/100),2)","v":16.03}]
["Bellen Dancer",29.95,"10",10,null,null,null,{"$f":"PRODUCT(1-D20:G20/100)","v":0.9},{"$f":"ROUND(B20*PRODUCT(1-D20:G20/100),2)","v":26.96}]
["Bellen Wind Dancer",32.25,"15/05/18/06",15,5,18,6,{"$f":"PRODUCT(1-D21:G21/100)","v":0.622421},{"$f":"ROUND(B21*PRODUCT(1-D21:G21/100),2)","v":20.07}]
["GelFast",21.5,"05/15/10/16",5,15,10,16,{"$f":"PRODUCT(1-D22:G22/100)","v":0.61046999999999996},{"$f":"ROUND(B22*PRODUCT(1-D22:G22/100),2)","v":13.13}]
["Phenolic Sunshine",35.5,"10/05/16/16",10,5,16,16,{"$f":"PRODUCT(1-D23:G23/100)","v":0.60328799999999994},{"$f":"ROUND(B23*PRODUCT(1-D23:G23/100),2)","v":21.42}]
["Icarus MTA",35.25,"20/15/06/16",20,15,6,16,{"$f":"PRODUCT(1-D24:G24/100)","v":0.53692799999999996},{"$f":"ROUND(B24*PRODUCT(1-D24:G24/100),2)","v":18.93}]
[]
["Product","Retail Price","Series Discount (Enter each Discount as 2-digits)","Net Cost Equilalent","Wholesale Price"]
["Quad",30.25,"20/05/10/20",{"$f":"PRODUCT(1-MID(C27,{1,4,7,10},2)/100)","v":0.54720000000000002},{"$f":"ROUND(PRODUCT(1-MID(C27,{1,4,7,10},2)/100)*B27,2)","v":16.55},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C27,CHOOSE(LEN(C27)-LEN(SUBSTITUTE(C27,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.54720000000000002}]
["Bellen",25.25,"10/10/08/18",{"$f":"PRODUCT(1-MID(C28,{1,4,7,10},2)/100)","v":0.61106400000000016},{"$f":"ROUND(PRODUCT(1-MID(C28,{1,4,7,10},2)/100)*B28,2)","v":15.43},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C28,CHOOSE(LEN(C28)-LEN(SUBSTITUTE(C28,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.61106400000000016}]
["Carlota",21.95,"15/10/16/16",{"$f":"PRODUCT(1-MID(C29,{1,4,7,10},2)/100)","v":0.53978399999999993},{"$f":"ROUND(PRODUCT(1-MID(C29,{1,4,7,10},2)/100)*B29,2)","v":11.85},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C29,CHOOSE(LEN(C29)-LEN(SUBSTITUTE(C29,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.53978399999999993}]
["Carlota Doublers",55.95,"05/05/08/08",{"$f":"PRODUCT(1-MID(C30,{1,4,7,10},2)/100)","v":0.76387600000000011},{"$f":"ROUND(PRODUCT(1-MID(C30,{1,4,7,10},2)/100)*B30,2)","v":42.74},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C30,CHOOSE(LEN(C30)-LEN(SUBSTITUTE(C30,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.76387600000000011}]
["Majestic Beaut",23.95,"10/05/16/20",{"$f":"PRODUCT(1-MID(C31,{1,4,7,10},2)/100)","v":0.57455999999999996},{"$f":"ROUND(PRODUCT(1-MID(C31,{1,4,7,10},2)/100)*B31,2)","v":13.76},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C31,CHOOSE(LEN(C31)-LEN(SUBSTITUTE(C31,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.57455999999999996}]
["Sunshine 5 Ply",19.25,"15/10/08/14",{"$f":"PRODUCT(1-MID(C32,{1,4,7,10},2)/100)","v":0.60526800000000003},{"$f":"ROUND(PRODUCT(1-MID(C32,{1,4,7,10},2)/100)*B32,2)","v":11.65},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C32,CHOOSE(LEN(C32)-LEN(SUBSTITUTE(C32,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.60526800000000003}]
["Sunshine 10 Ply",20.5,"15/05/08/10",{"$f":"PRODUCT(1-MID(C33,{1,4,7,10},2)/100)","v":0.66861000000000004},{"$f":"ROUND(PRODUCT(1-MID(C33,{1,4,7,10},2)/100)*B33,2)","v":13.71},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C33,CHOOSE(LEN(C33)-LEN(SUBSTITUTE(C33,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.66861000000000004}]
["Sunset",23.5,"15/15/14/08",{"$f":"PRODUCT(1-MID(C34,{1,4,7,10},2)/100)","v":0.57164199999999998},{"$f":"ROUND(PRODUCT(1-MID(C34,{1,4,7,10},2)/100)*B34,2)","v":13.43},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C34,CHOOSE(LEN(C34)-LEN(SUBSTITUTE(C34,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.57164199999999998}]
["Sunbell",26.95,"15/05/10/14",{"$f":"PRODUCT(1-MID(C35,{1,4,7,10},2)/100)","v":0.62500500000000003},{"$f":"ROUND(PRODUCT(1-MID(C35,{1,4,7,10},2)/100)*B35,2)","v":16.84},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C35,CHOOSE(LEN(C35)-LEN(SUBSTITUTE(C35,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.62500500000000003},0.15,0.05,0.1,{"$f":"PRODUCT(1-U35:W35)","v":0.72675000000000001}]
["Flattop",20.95,"15/10/16/14",{"$f":"PRODUCT(1-MID(C36,{1,4,7,10},2)/100)","v":0.55263599999999991},{"$f":"ROUND(PRODUCT(1-MID(C36,{1,4,7,10},2)/100)*B36,2)","v":11.58},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C36,CHOOSE(LEN(C36)-LEN(SUBSTITUTE(C36,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.55263599999999991},0.15,0.1,null,{"$f":"PRODUCT(1-U36:W36)","v":0.76500000000000001}]
["Bellen Dancer",29.95,"10/05/18/06",{"$f":"PRODUCT(1-MID(C37,{1,4,7,10},2)/100)","v":0.65903400000000001},{"$f":"ROUND(PRODUCT(1-MID(C37,{1,4,7,10},2)/100)*B37,2)","v":19.739999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C37,CHOOSE(LEN(C37)-LEN(SUBSTITUTE(C37,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.65903400000000001},0.1,null,null,{"$f":"PRODUCT(1-U37:W37)","v":0.9}]
["Bellen Wind Dancer",32.25,"15/05/18/06",{"$f":"PRODUCT(1-MID(C38,{1,4,7,10},2)/100)","v":0.622421},{"$f":"ROUND(PRODUCT(1-MID(C38,{1,4,7,10},2)/100)*B38,2)","v":20.07},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C38,CHOOSE(LEN(C38)-LEN(SUBSTITUTE(C38,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.622421}]
["GelFast",21.5,"05/15/10/16",{"$f":"PRODUCT(1-MID(C39,{1,4,7,10},2)/100)","v":0.61046999999999996},{"$f":"ROUND(PRODUCT(1-MID(C39,{1,4,7,10},2)/100)*B39,2)","v":13.13},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C39,CHOOSE(LEN(C39)-LEN(SUBSTITUTE(C39,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.61046999999999996}]
["Phenolic Sunshine",35.5,"10/05/16/16",{"$f":"PRODUCT(1-MID(C40,{1,4,7,10},2)/100)","v":0.60328799999999994},{"$f":"ROUND(PRODUCT(1-MID(C40,{1,4,7,10},2)/100)*B40,2)","v":21.42},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C40,CHOOSE(LEN(C40)-LEN(SUBSTITUTE(C40,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.60328799999999994}]
["Icarus MTA",35.25,"20/15/06/16",{"$f":"PRODUCT(1-MID(C41,{1,4,7,10},2)/100)","v":0.53692799999999996},{"$f":"ROUND(PRODUCT(1-MID(C41,{1,4,7,10},2)/100)*B41,2)","v":18.93},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1-MID(C41,CHOOSE(LEN(C41)-LEN(SUBSTITUTE(C41,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.53692799999999996}]
[]
[]
["Product","Retail Price","Series Discount (Enter each Discount as 2-digits)","Net Cost Equilalent","Wholesale Price"]
["Quad",30.25,"20/05/10/20",{"$f":"PRODUCT(1-MID(C45,CHOOSE(LEN(C45)-LEN(SUBSTITUTE(C45,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.54720000000000002},{"$f":"ROUND(D45*B45,2)","v":16.55}]
["Bellen",25.25,"10/10/08/18",{"$f":"PRODUCT(1-MID(C46,CHOOSE(LEN(C46)-LEN(SUBSTITUTE(C46,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.61106400000000016},{"$f":"ROUND(D46*B46,2)","v":15.43}]
["Carlota",21.95,"15/10/16/16",{"$f":"PRODUCT(1-MID(C47,CHOOSE(LEN(C47)-LEN(SUBSTITUTE(C47,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.53978399999999993},11.85]
["Carlota Doublers",55.95,"05/05/08/08",{"$f":"PRODUCT(1-MID(C48,CHOOSE(LEN(C48)-LEN(SUBSTITUTE(C48,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.76387600000000011},42.74]
["Majestic Beaut",23.95,"10/05/16/20",{"$f":"PRODUCT(1-MID(C49,CHOOSE(LEN(C49)-LEN(SUBSTITUTE(C49,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.57455999999999996},13.76]
["Sunshine 5 Ply",19.25,"15/10/08/14",{"$f":"PRODUCT(1-MID(C50,CHOOSE(LEN(C50)-LEN(SUBSTITUTE(C50,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.60526800000000003},11.65]
["Sunshine 10 Ply",20.5,"15/05/08/10",{"$f":"PRODUCT(1-MID(C51,CHOOSE(LEN(C51)-LEN(SUBSTITUTE(C51,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.66861000000000004},13.71]
["Sunset",23.5,"15/15/14/08",{"$f":"PRODUCT(1-MID(C52,CHOOSE(LEN(C52)-LEN(SUBSTITUTE(C52,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.57164199999999998},13.43,"{1,4,7,10}",{"$f":"LEN(C52)-LEN(SUBSTITUTE(C52,\"/\",\"\"))+1","v":4},{"$f":"LEN(C52)","v":11},{"$f":"LEN(SUBSTITUTE(C52,\"/\",\"\"))","v":8},{"$f":"H52-I52","v":3}]
["Sunbell",26.95,"15/05/10",{"$f":"PRODUCT(1-MID(C53,CHOOSE(LEN(C53)-LEN(SUBSTITUTE(C53,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.72675000000000001},19.59,"{1,4,7}",{"$f":"LEN(C53)-LEN(SUBSTITUTE(C53,\"/\",\"\"))+1","v":3},{"$f":"LEN(C53)","v":8},{"$f":"LEN(SUBSTITUTE(C53,\"/\",\"\"))","v":6},{"$f":"H53-I53","v":2}]
["Flattop",20.95,"15/10",{"$f":"PRODUCT(1-MID(C54,CHOOSE(LEN(C54)-LEN(SUBSTITUTE(C54,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.76500000000000001},16.03,"{1,4}",2,5,4,1]
["Bellen Dancer",29.95,"10",{"$f":"PRODUCT(1-MID(C55,CHOOSE(LEN(C55)-LEN(SUBSTITUTE(C55,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.9},26.96,1,1,2,2,0]
["Bellen Wind Dancer",32.25,"15/05/18/06",{"$f":"PRODUCT(1-MID(C56,CHOOSE(LEN(C56)-LEN(SUBSTITUTE(C56,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.622421},20.07,null,4]
["GelFast",21.5,"05/15/10/16",{"$f":"PRODUCT(1-MID(C57,CHOOSE(LEN(C57)-LEN(SUBSTITUTE(C57,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.61046999999999996},13.13]
["Phenolic Sunshine",35.5,"10/05/16/16",{"$f":"PRODUCT(1-MID(C58,CHOOSE(LEN(C58)-LEN(SUBSTITUTE(C58,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.60328799999999994},21.42]
["Icarus MTA",35.25,"20/15/06/16",{"$f":"PRODUCT(1-MID(C59,CHOOSE(LEN(C59)-LEN(SUBSTITUTE(C59,\"/\",\"\"))+1,1,{1,4},{1,4,7},{1,4,7,10}),2)/100)","v":0.53692799999999996},18.93]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,1]
[null,null,null,null,4]
[null,null,null,null,7,{"$f":"SUBSTITUTE($C$27,\"/\",\"^\",ROWS(F$134:F134))","v":"20^05/10/20"},{"$f":"SEARCH(\"^\",F134)-1","v":2}]
[null,null,null,null,10,{"$f":"SUBSTITUTE($C$27,\"/\",\"^\",ROWS(F$134:F135))","v":"20/05^10/20"},{"$f":"SEARCH(\"^\",F135)-1","v":5}]
[null,"Series Discount","20/5/1/20",{"$f":"REPLACE(C136,SEARCH(\"/\",C136)+1,0,0)","v":"20/05/1/20"},null,{"$f":"SUBSTITUTE($C$27,\"/\",\"^\",ROWS(F$134:F136))","v":"20/05/10^20"},{"$f":"SEARCH(\"^\",F136)-1","v":8}]
[null,null,{"$f":"MID($C$136,3*ROWS(C$137:C137)-2,2)/100","v":0.2},null,{"$f":"1+(ROWS(E$137:E137)-1)*3","v":1},{"$f":"1+(3*ROWS(E$137:E137)-3)","v":1},{"$f":"1+3*ROWS(E$137:E137)-3","v":1},{"$f":"3*ROWS(E$137:E137)-2","v":1}]
[null,null,{"$f":"MID($C$136,3*ROWS(C$137:C138)-2,2)/100","v":{"$error":"#VALUE!"}},null,{"$f":"1+(ROWS(E$137:E138)-1)*3","v":4},{"$f":"1+(3*ROWS(E$137:E138)-3)","v":4},{"$f":"1+3*ROWS(E$137:E138)-3","v":4},{"$f":"3*ROWS(E$137:E138)-2","v":4}]
[null,null,{"$f":"MID($C$136,3*ROWS(C$137:C139)-2,2)/100","v":{"$error":"#VALUE!"}},null,{"$f":"1+(ROWS(E$137:E139)-1)*3","v":7},{"$f":"1+(3*ROWS(E$137:E139)-3)","v":7},{"$f":"1+3*ROWS(E$137:E139)-3","v":7},{"$f":"3*ROWS(E$137:E139)-2","v":7}]
[null,null,{"$f":"MID($C$136,3*ROWS(C$137:C140)-2,2)/100","v":{"$error":"#VALUE!"}},null,{"$f":"1+(ROWS(E$137:E140)-1)*3","v":10},{"$f":"1+(3*ROWS(E$137:E140)-3)","v":10},{"$f":"1+3*ROWS(E$137:E140)-3","v":10},{"$f":"3*ROWS(E$137:E140)-2","v":10}]
[]
[null,null,null,{"$f":"SUBSTITUTE($C$136,\"/\",\"/0\",{1,2,3})","v":"20/05/1/20"},null,{"$f":"INDEX(SUBSTITUTE($C$136,\"/\",\"/0\",{1,2,3}),ROWS(F$142:F142))","v":"20/05/1/20"}]
[null,null,null,"20/05/1/20",null,{"$f":"INDEX(SUBSTITUTE($C$136,\"/\",\"/0\",{1,2,3}),ROWS(F$142:F143))","v":"20/5/01/20"}]
[null,null,null,"20/05/1/20",null,{"$f":"INDEX(SUBSTITUTE($C$136,\"/\",\"/0\",{1,2,3}),ROWS(F$142:F144))","v":"20/5/1/020"}]
[null,null,null,"20/05/1/20",null,{"$f":"INDEX(SUBSTITUTE($C$136,\"/\",\"/0\",{1,2,3}),ROWS(F$142:F145))","v":{"$error":"#REF!"}}]
[]
[null,null,null,"Series Discount","20/5/10/20"]
[null,null,null,null,{"$f":"SUBSTITUTE($E$147,\"/\",\"/0\",ROWS(E$148:E148))","v":"20/05/10/20"},{"$f":"INDEX(SUBSTITUTE($E$147,\"/\",\"/0\",{1,2,3}),ROWS(F$148:F148))","v":"20/05/10/20"}]
[null,null,null,null,{"$f":"SUBSTITUTE($E$147,\"/\",\"/0\",ROWS(E$148:E149))","v":"20/5/010/20"},{"$f":"INDEX(SUBSTITUTE($E$147,\"/\",\"/0\",{1,2,3}),ROWS(F$148:F149))","v":"20/5/010/20"}]
[null,null,null,null,{"$f":"SUBSTITUTE($E$147,\"/\",\"/0\",ROWS(E$148:E150))","v":"20/5/10/020"},{"$f":"INDEX(SUBSTITUTE($E$147,\"/\",\"/0\",{1,2,3}),ROWS(F$148:F150))","v":"20/5/10/020"}]

{"sheet":"(829)","index":3,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Bellen",25]
["Carlota",22]
["Quad",32.75]
[]
["Null Hypothesis","H0 :","Mu"," >=",20," "]
["Alternative Hypothesis","Ha :","Mu"," <",{"$f":"E5","v":20}]
["Alpha",0.05,"Risk that we reject H0, when it is true. Accept Ha, but H0 is true"]
["Population Standard Deviation",2,"Sigma"]
["Sample Size",50]
["Xbar",19.399999999999999]
["Critical Value",{"$f":"NORMSINV(B7)","v":-1.6448536269514726}]
["Rejection Rule","If our calculated test statistic is less than or equal to -1.64485, we reject H0 and accept Ha, otherwise we fail to reject H0."]
["Standard Error",{"$f":"B8/SQRT(B9)","v":0.28284271247461901}]
["Test Statistic",{"$f":"(B10-E5)/B13","v":-2.1213203435596477}]
["Conclusion","Because our calculated test statistic is less than -1.64485, we reject H0 and accept Ha. From or sample evidence it is reasonable to assume that mu is greater than 20."]
["p-value",{"$f":"NORMSDIST(B14)","v":1.6947426762344404E-2}]
["Conclusion","Because the p-value of .01695 is less than .05, we reject H0 and accept Ha. From or sample evidence it is reasonable to assume that mu is greater than 20."]
[]
["Steps:"]
[1,"Shift + F2 = Inster Comment"]
[2,"Click on outside edge (see dots)"]
[3,"Ctrl + 1 to open Format Comment dialog box"]
[4,"Colors and Lines tab"]
[5,"Fill: Color"]
[6,"Fill Effects"]
[7,"Picture tab"]
[8,"Select Picture button"]

{"sheet":"(829an)","index":4,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Bellen",25]
["Carlota",22]
["Quad",32.75]
[]
["Null Hypothesis","H0 :","Mu"," >=",20," "]
["Alternative Hypothesis","Ha :","Mu"," <",{"$f":"E5","v":20}]
["Alpha",0.05,"Risk that we reject H0, when it is true. Accept Ha, but H0 is true"]
["Population Standard Deviation",2,"Sigma"]
["Sample Size",50]
["Xbar",19.399999999999999]
["Critical Value",{"$f":"NORMSINV(B7)","v":-1.6448536269514726}]
["Rejection Rule","If our calculated test statistic is less than or equal to -1.64485, we reject H0 and accept Ha, otherwise we fail to reject H0."]
["Standard Error",{"$f":"B8/SQRT(B9)","v":0.28284271247461901}]
["Test Statistic",{"$f":"(B10-E5)/B13","v":-2.1213203435596477}]
["Conclusion","Because our calculated test statistic is less than -1.64485, we reject H0 and accept Ha. From or sample evidence it is reasonable to assume that mu is greater than 20."]
["p-value",{"$f":"NORMSDIST(B14)","v":1.6947426762344404E-2}]
["Conclusion","Because the p-value of .01695 is less than .05, we reject H0 and accept Ha. From or sample evidence it is reasonable to assume that mu is greater than 20."]
[]
["Steps:"]
[1,"Shift + F2 = Inster Comment"]
[2,"Click on outside edge (see dots)"]
[3,"Ctrl + 1 to open Format Comment dialog box"]
[4,"Colors and Lines tab"]
[5,"Fill: Color"]
[6,"Fill Effects"]
[7,"Picture tab"]
[8,"Select Picture button"]