{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Q","Start","Bill","Mike","Sheet8","Sheet7","Sheet6","sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":3},"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":"Q","index":0,"n_rows":30,"n_cols":28,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Method 0 - This Method Does Not Work!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conditional Formatting Top 70%",null,null,null,null,null,null,"Pivot table uses a Value Filter to show Top 70% of Items - won't work if there are duplicates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(A17:A30)","v":7263},null,null,null,null,null,null,null,null,"Method 3"]
[768,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,{"$f":"P16*O17","v":5084.0999999999995},null,null,null,768,null,null,null,null,768,null,"Row Labels","Sum of Method 3"]
[1152,null,null,null,null,null,null,null,null,null,null,null,null,null,"How Many",3,null,null,null,1152,null,null,null,null,1152,null,1152,1152]
[128,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(LARGE($A$17:$A$30,ROW(INDIRECT(\"A1:A\"&P18))))","v":5472},null,null,null,128,null,null,null,null,128,null,1728,1728]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,"Keep",{"$f":"P19>=P17","v":true},null,null,null,1,null,null,null,null,1,null,2592,2592]
[2592,null,null,null,null,null,null,null,null,null,null,null,null,null,"HiLite",{"$f":"LARGE($A$17:$A$30,P18)","v":1152},null,null,null,2592,null,null,null,null,2592,null,"Grand Total",5472]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,4]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,2]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,8]
[512,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,512,null,null,null,null,512]
[1728,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1728,null,null,null,null,1728]
[256,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,256,null,null,null,null,256]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,null,null,null,null,32]
[64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,null,null,null,null,64]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,16]

{"sheet":"Start","index":1,"n_rows":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[768]
[1152]
[128]
[1]
[2592]
[4]
[2]
[8]
[512]
[1728]
[256]
[32]
[64]
[16]

{"sheet":"Bill","index":2,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Method 0 - This Method Does Not Work!"]
[null,null,null,null,null,null,null,"Conditional Formatting Top 70%",null,null,null,null,null,null,"Pivot table uses a Value Filter to show Top 70% of Items - won't work if there are duplicates"]
[null,null,"Sum",{"$f":"SUM(A17:A30)","v":7263},null,null,null,null,null,null,null,null,"Method 3"]
[768,null,0.7,{"$f":"D16*C17","v":5084.0999999999995},null,null,null,768,null,null,null,null,768,null,"Row Labels","Sum of Method 3"]
[1152,null,"How Many",3,null,null,null,1152,null,null,null,null,1152,null,1152,1152]
[128,null,"Total",{"$f":"SUM(LARGE($A$17:$A$30,ROW(INDIRECT(\"A1:A\"&D18))))","v":5472},null,null,null,128,null,null,null,null,128,null,1728,1728]
[1,null,"Keep",{"$f":"D19>=D17","v":true},null,null,null,1,null,null,null,null,1,null,2592,2592]
[2592,null,"HiLite",{"$f":"LARGE($A$17:$A$30,D18)","v":1152},null,null,null,2592,null,null,null,null,2592,null,"Grand Total",5472]
[4,null,null,null,null,null,null,4,null,null,null,null,4]
[2,null,null,null,null,null,null,2,null,null,null,null,2]
[8,null,null,null,null,null,null,8,null,null,null,null,8]
[512,null,null,null,null,null,null,512,null,null,null,null,512]
[1728,null,null,null,null,null,null,1728,null,null,null,null,1728]
[256,null,null,null,null,null,null,256,null,null,null,null,256]
[32,null,null,null,null,null,null,32,null,null,null,null,32]
[64,null,null,null,null,null,null,64,null,null,null,null,64]
[16,null,null,null,null,null,null,16,null,null,null,null,16]

{"sheet":"Mike","index":3,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sales","Cum",null,"%","Lookup"]
[2592,{"$f":"SUM($A$17:A17)/$A$31","v":0.35687732342007433},null,0.8,{"$f":"INDEX(A17:A30,MATCH(TRUE,B17:B30>D17,0))","v":768}]
[1728,{"$f":"SUM($A$17:A18)/$A$31","v":0.59479553903345728}]
[1152,{"$f":"SUM($A$17:A19)/$A$31","v":0.75340768277571246},null,null,"Remember: Ctrl + Shift + Enter"]
[768,{"$f":"SUM($A$17:A20)/$A$31","v":0.85914911193721599},null,null,"You will get #VALUE! error if you don't use CSE"]
[512,{"$f":"SUM($A$17:A21)/$A$31","v":0.92964339804488505}]
[256,{"$f":"SUM($A$17:A22)/$A$31","v":0.96489054109871952}]
[128,{"$f":"SUM($A$17:A23)/$A$31","v":0.98251411262563682}]
[64,{"$f":"SUM($A$17:A24)/$A$31","v":0.99132589838909546}]
[32,{"$f":"SUM($A$17:A25)/$A$31","v":0.99573179127082467}]
[16,{"$f":"SUM($A$17:A26)/$A$31","v":0.99793473771168939}]
[8,{"$f":"SUM($A$17:A27)/$A$31","v":0.99903621093212169}]
[4,{"$f":"SUM($A$17:A28)/$A$31","v":0.9995869475423379}]
[2,{"$f":"SUM($A$17:A29)/$A$31","v":0.999862315847446}]
[1,{"$f":"SUM($A$17:A30)/$A$31","v":1}]
[{"$f":"SUM(A17:A30)","v":7263}]

{"sheet":"Sheet8","index":4,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Sales"]
[2592,0.35687732342007433]
[1728,0.59479553903345728]
[1152,0.75340768277571246]
[768,0.85914911193721599]
[512,0.92964339804488505]
[256,0.96489054109871952]
[128,0.98251411262563682]
[64,0.99132589838909546]
[32,0.99573179127082467]
[16,0.99793473771168939]
[8,0.99903621093212169]
[4,0.9995869475423379]
[2,0.999862315847446]
[1,1]
["Grand Total"]

{"sheet":"Sheet7","index":5,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sales","Cum",null,"%","Value"]
[2592,{"$f":"SUM($A$17:A17)/$A$31","v":0.35687732342007433},null,0.7,{"$f":"INDEX(A17:A30,MATCH(TRUE,B17:B30>D17,0))","v":1152}]
[1728,{"$f":"SUM($A$17:A18)/$A$31","v":0.59479553903345728}]
[1152,{"$f":"SUM($A$17:A19)/$A$31","v":0.75340768277571246}]
[768,{"$f":"SUM($A$17:A20)/$A$31","v":0.85914911193721599}]
[512,{"$f":"SUM($A$17:A21)/$A$31","v":0.92964339804488505}]
[256,{"$f":"SUM($A$17:A22)/$A$31","v":0.96489054109871952}]
[128,{"$f":"SUM($A$17:A23)/$A$31","v":0.98251411262563682}]
[64,{"$f":"SUM($A$17:A24)/$A$31","v":0.99132589838909546}]
[32,{"$f":"SUM($A$17:A25)/$A$31","v":0.99573179127082467}]
[16,{"$f":"SUM($A$17:A26)/$A$31","v":0.99793473771168939}]
[8,{"$f":"SUM($A$17:A27)/$A$31","v":0.99903621093212169}]
[4,{"$f":"SUM($A$17:A28)/$A$31","v":0.9995869475423379}]
[2,{"$f":"SUM($A$17:A29)/$A$31","v":0.999862315847446}]
[1,{"$f":"SUM($A$17:A30)/$A$31","v":1}]
[{"$f":"SUM(A17:A30)","v":7263}]

{"sheet":"Sheet6","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"sheet1","index":7,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hurdle",0.7,null,null,null,null,"More infor about PERCENTILE.EXC\nand PERCENTILE.INC"]
[null,null,null,null,null,null,"Excel 2010 Statistics #27: Excel 2010 Functions for Percentile, Quartile and Rank "]
[null,null,null,null,null,null,null,null,null,"PERCENTRANK"]
["Sales",null,"Sales",null,null,"Sales",null,"PERCENTRANK.EXC","PERCENTILE.INC"]
[768,null,768,null,null,768]
[1152,null,1152,null,null,1152]
[128,null,128,null,null,128]
[1,null,1,null,null,1]
[2592,null,2592,null,null,2592,null,"Not it…"]
[4,null,4,null,null,4]
[2,null,2,null,null,2]
[8,null,8,null,null,8]
[512,null,512,null,null,512]
[1728,null,1728,null,null,1728]
[256,null,256,null,null,256]
[32,null,32,null,null,32]
[64,null,64,null,null,64]
[16,null,16,null,null,16]