{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["(673)","(673an)","(674)","(674an)","(675)","(675an)","(676)","(676an)","(677)","(677an)","(678)","(678an)","(679)","(679an)","(680)","(68oan)","(681)","(681an)","(682)","(682an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"(673)","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Hurdle","Rate"]
[]
[0,0.1,null,"Dave Patton from Mr excel Message Board:"]
[20000,0.15,null,"http://www.mrexcel.com/forum/showthread.php?p=2388808#post2388808"]
[40000,0.2]
[60000,0.25]
[]
[null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Sales",15000,20000,10000,18000,10000]
["Formula 1"]
[]
["cum"]
[]
[null,null,"(20000-15000)*0.1",{"$f":"(20000-15000)*0.1","v":500}]
[null,null,"(35000-20000)*0.15",{"$f":"(35000-20000)*0.15","v":2250},{"$f":"SUM(D14:D15)","v":2750}]
[null,null,"35000*.1",{"$f":"(35000*0.1)","v":3500}]
[null,null,"15000*.05",{"$f":"15000*0.05","v":750},{"$f":"SUM(D16:D17)","v":4250}]
[null,null,1500,1500,{"$f":"E17-D18","v":2750}]
[]
["Formula 2",{"$f":"IF(VLOOKUP(SUM($B9:B9),$A$3:$A$6,1)-SUM(A9:$B9)<0,B9*VLOOKUP(SUM($B9:B9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:B9),$A$3:$A$6,1)-SUM(A9:$B9))*INDEX($B$3:$B$6,MATCH(SUM($B9:B9),$A$3:$A$6)-1)+(SUM($B9:B9)-VLOOKUP(SUM($B9:B9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:B9),$A$3:$A$6)))","v":1500},{"$f":"IF(VLOOKUP(SUM($B9:C9),$A$3:$A$6,1)-SUM(B9:$B9)<0,C9*VLOOKUP(SUM($B9:C9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:C9),$A$3:$A$6,1)-SUM(B9:$B9))*INDEX($B$3:$B$6,MATCH(SUM($B9:C9),$A$3:$A$6)-1)+(SUM($B9:C9)-VLOOKUP(SUM($B9:C9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:C9),$A$3:$A$6)))","v":2750},{"$f":"IF(VLOOKUP(SUM($B9:D9),$A$3:$A$6,1)-SUM($B9:C9)<0,D9*VLOOKUP(SUM($B9:D9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:D9),$A$3:$A$6,1)-SUM($B9:C9))*INDEX($B$3:$B$6,MATCH(SUM($B9:D9),$A$3:$A$6)-1)+(SUM($B9:D9)-VLOOKUP(SUM($B9:D9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:D9),$A$3:$A$6)))","v":1750},{"$f":"IF(VLOOKUP(SUM($B9:E9),$A$3:$A$6,1)-SUM($B9:D9)<0,E9*VLOOKUP(SUM($B9:E9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:E9),$A$3:$A$6,1)-SUM($B9:D9))*INDEX($B$3:$B$6,MATCH(SUM($B9:E9),$A$3:$A$6)-1)+(SUM($B9:E9)-VLOOKUP(SUM($B9:E9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:E9),$A$3:$A$6)))","v":3750},{"$f":"IF(VLOOKUP(SUM($B9:F9),$A$3:$A$6,1)-SUM($B9:E9)<0,F9*VLOOKUP(SUM($B9:F9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:F9),$A$3:$A$6,1)-SUM($B9:E9))*INDEX($B$3:$B$6,MATCH(SUM($B9:F9),$A$3:$A$6)-1)+(SUM($B9:F9)-VLOOKUP(SUM($B9:F9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:F9),$A$3:$A$6)))","v":2500},{"$f":"IF(VLOOKUP(SUM($B9:G9),$A$3:$A$6,1)-SUM($B9:F9)<0,G9*VLOOKUP(SUM($B9:G9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:G9),$A$3:$A$6,1)-SUM($B9:F9))*INDEX($B$3:$B$6,MATCH(SUM($B9:G9),$A$3:$A$6)-1)+(SUM($B9:G9)-VLOOKUP(SUM($B9:G9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:G9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:H9),$A$3:$A$6,1)-SUM($B9:G9)<0,H9*VLOOKUP(SUM($B9:H9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:H9),$A$3:$A$6,1)-SUM($B9:G9))*INDEX($B$3:$B$6,MATCH(SUM($B9:H9),$A$3:$A$6)-1)+(SUM($B9:H9)-VLOOKUP(SUM($B9:H9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:H9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:I9),$A$3:$A$6,1)-SUM($B9:H9)<0,I9*VLOOKUP(SUM($B9:I9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:I9),$A$3:$A$6,1)-SUM($B9:H9))*INDEX($B$3:$B$6,MATCH(SUM($B9:I9),$A$3:$A$6)-1)+(SUM($B9:I9)-VLOOKUP(SUM($B9:I9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:I9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:J9),$A$3:$A$6,1)-SUM($B9:I9)<0,J9*VLOOKUP(SUM($B9:J9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:J9),$A$3:$A$6,1)-SUM($B9:I9))*INDEX($B$3:$B$6,MATCH(SUM($B9:J9),$A$3:$A$6)-1)+(SUM($B9:J9)-VLOOKUP(SUM($B9:J9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:J9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:K9),$A$3:$A$6,1)-SUM($B9:J9)<0,K9*VLOOKUP(SUM($B9:K9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:K9),$A$3:$A$6,1)-SUM($B9:J9))*INDEX($B$3:$B$6,MATCH(SUM($B9:K9),$A$3:$A$6)-1)+(SUM($B9:K9)-VLOOKUP(SUM($B9:K9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:K9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:L9),$A$3:$A$6,1)-SUM($B9:K9)<0,L9*VLOOKUP(SUM($B9:L9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:L9),$A$3:$A$6,1)-SUM($B9:K9))*INDEX($B$3:$B$6,MATCH(SUM($B9:L9),$A$3:$A$6)-1)+(SUM($B9:L9)-VLOOKUP(SUM($B9:L9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:L9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:M9),$A$3:$A$6,1)-SUM($B9:L9)<0,M9*VLOOKUP(SUM($B9:M9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:M9),$A$3:$A$6,1)-SUM($B9:L9))*INDEX($B$3:$B$6,MATCH(SUM($B9:M9),$A$3:$A$6)-1)+(SUM($B9:M9)-VLOOKUP(SUM($B9:M9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:M9),$A$3:$A$6)))","v":0}]
["Formula 3",{"$f":"IF(B9<=$A$25,B9*$B$3,IF(B9<=$A$26,($A$25*$B$3)+((B9-$A$25)*$B$4),IF(B9<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((B9-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((B9-$A$27)*$B$6))))","v":1500},{"$f":"IF(SUM($B9:C9)<=$A$25,SUM($B9:C9)*$B$3,IF(SUM($B9:C9)<=$A$26,($A$25*$B$3)+((SUM($B9:C9)-$A$25)*$B$4),IF(SUM($B9:C9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:C9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:C9)-$A$27)*$B$6))))-SUM($B21:B21)","v":2750},{"$f":"IF(SUM($B9:D9)<=$A$25,SUM($B9:D9)*$B$3,IF(SUM($B9:D9)<=$A$26,($A$25*$B$3)+((SUM($B9:D9)-$A$25)*$B$4),IF(SUM($B9:D9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:D9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:D9)-$A$27)*$B$6))))-SUM($B21:C21)","v":1750},{"$f":"IF(SUM($B9:E9)<=$A$25,SUM($B9:E9)*$B$3,IF(SUM($B9:E9)<=$A$26,($A$25*$B$3)+((SUM($B9:E9)-$A$25)*$B$4),IF(SUM($B9:E9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:E9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:E9)-$A$27)*$B$6))))-SUM($B21:D21)","v":3750},{"$f":"IF(SUM($B9:F9)<=$A$25,SUM($B9:F9)*$B$3,IF(SUM($B9:F9)<=$A$26,($A$25*$B$3)+((SUM($B9:F9)-$A$25)*$B$4),IF(SUM($B9:F9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:F9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:F9)-$A$27)*$B$6))))-SUM($B21:E21)","v":2500},{"$f":"IF(SUM($B9:G9)<=$A$25,SUM($B9:G9)*$B$3,IF(SUM($B9:G9)<=$A$26,($A$25*$B$3)+((SUM($B9:G9)-$A$25)*$B$4),IF(SUM($B9:G9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:G9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:G9)-$A$27)*$B$6))))-SUM($B21:F21)","v":0},{"$f":"IF(SUM($B9:H9)<=$A$25,SUM($B9:H9)*$B$3,IF(SUM($B9:H9)<=$A$26,($A$25*$B$3)+((SUM($B9:H9)-$A$25)*$B$4),IF(SUM($B9:H9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:H9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:H9)-$A$27)*$B$6))))-SUM($B21:G21)","v":0},{"$f":"IF(SUM($B9:I9)<=$A$25,SUM($B9:I9)*$B$3,IF(SUM($B9:I9)<=$A$26,($A$25*$B$3)+((SUM($B9:I9)-$A$25)*$B$4),IF(SUM($B9:I9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:I9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:I9)-$A$27)*$B$6))))-SUM($B21:H21)","v":0},{"$f":"IF(SUM($B9:J9)<=$A$25,SUM($B9:J9)*$B$3,IF(SUM($B9:J9)<=$A$26,($A$25*$B$3)+((SUM($B9:J9)-$A$25)*$B$4),IF(SUM($B9:J9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:J9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:J9)-$A$27)*$B$6))))-SUM($B21:I21)","v":0},{"$f":"IF(SUM($B9:K9)<=$A$25,SUM($B9:K9)*$B$3,IF(SUM($B9:K9)<=$A$26,($A$25*$B$3)+((SUM($B9:K9)-$A$25)*$B$4),IF(SUM($B9:K9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:K9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:K9)-$A$27)*$B$6))))-SUM($B21:J21)","v":0},{"$f":"IF(SUM($B9:L9)<=$A$25,SUM($B9:L9)*$B$3,IF(SUM($B9:L9)<=$A$26,($A$25*$B$3)+((SUM($B9:L9)-$A$25)*$B$4),IF(SUM($B9:L9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:L9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:L9)-$A$27)*$B$6))))-SUM($B21:K21)","v":0},{"$f":"IF(SUM($B9:M9)<=$A$25,SUM($B9:M9)*$B$3,IF(SUM($B9:M9)<=$A$26,($A$25*$B$3)+((SUM($B9:M9)-$A$25)*$B$4),IF(SUM($B9:M9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:M9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:M9)-$A$27)*$B$6))))-SUM($B21:L21)","v":0}]
[]
[]
["Max"]
[20000]
[40000]
[60000]

{"sheet":"(673an)","index":1,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Hurdle","Rate"]
[]
[0,0.1,null,"Dave Patton from Mr excel Message Board:"]
[20000,0.15,null,"http://www.mrexcel.com/forum/showthread.php?p=2388808#post2388808"]
[40000,0.2]
[60000,0.25]
[]
[null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Sales",15000,20000,10000,18000,10000]
["Formula 1",{"$f":"SUMPRODUCT(--(SUM($B9:B9)>=$A$3:$A$6),SUM($B9:B9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:A10)","v":1500},{"$f":"SUMPRODUCT(--(SUM($B9:C9)>=$A$3:$A$6),SUM($B9:C9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:B10)","v":2750},{"$f":"SUMPRODUCT(--(SUM($B9:D9)>=$A$3:$A$6),SUM($B9:D9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:C10)","v":1750},{"$f":"SUMPRODUCT(--(SUM($B9:E9)>=$A$3:$A$6),SUM($B9:E9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:D10)","v":3750},{"$f":"SUMPRODUCT(--(SUM($B9:F9)>=$A$3:$A$6),SUM($B9:F9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:E10)","v":2500},{"$f":"SUMPRODUCT(--(SUM($B9:G9)>=$A$3:$A$6),SUM($B9:G9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:F10)","v":0},{"$f":"SUMPRODUCT(--(SUM($B9:H9)>=$A$3:$A$6),SUM($B9:H9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:G10)","v":0},{"$f":"SUMPRODUCT(--(SUM($B9:I9)>=$A$3:$A$6),SUM($B9:I9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:H10)","v":0},{"$f":"SUMPRODUCT(--(SUM($B9:J9)>=$A$3:$A$6),SUM($B9:J9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:I10)","v":0},{"$f":"SUMPRODUCT(--(SUM($B9:K9)>=$A$3:$A$6),SUM($B9:K9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:J10)","v":0},{"$f":"SUMPRODUCT(--(SUM($B9:L9)>=$A$3:$A$6),SUM($B9:L9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:K10)","v":0},{"$f":"SUMPRODUCT(--(SUM($B9:M9)>=$A$3:$A$6),SUM($B9:M9)-$A$3:$A$6,$B$3:$B$6-$B$2:$B$5)-SUM($A10:L10)","v":0}]
[]
["cum",{"$f":"SUM($B9:B9)","v":15000},{"$f":"SUM($B9:C9)","v":35000},{"$f":"SUM($B9:D9)","v":45000},{"$f":"SUM($B9:E9)","v":63000},{"$f":"SUM($B9:F9)","v":73000},{"$f":"SUM($B9:G9)","v":73000}]
[]
[null,null,"(20000-15000)*0.1",{"$f":"(20000-15000)*0.1","v":500}]
[null,null,"(35000-20000)*0.15",{"$f":"(35000-20000)*0.15","v":2250},{"$f":"SUM(D14:D15)","v":2750}]
[null,null,"35000*.1",{"$f":"(35000*0.1)","v":3500}]
[null,null,"15000*.05",{"$f":"15000*0.05","v":750},{"$f":"SUM(D16:D17)","v":4250}]
[null,null,1500,1500,{"$f":"E17-D18","v":2750}]
[]
["Formula 2",{"$f":"IF(VLOOKUP(SUM($B9:B9),$A$3:$A$6,1)-SUM(A9:$B9)<0,B9*VLOOKUP(SUM($B9:B9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:B9),$A$3:$A$6,1)-SUM(A9:$B9))*INDEX($B$3:$B$6,MATCH(SUM($B9:B9),$A$3:$A$6)-1)+(SUM($B9:B9)-VLOOKUP(SUM($B9:B9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:B9),$A$3:$A$6)))","v":1500},{"$f":"IF(VLOOKUP(SUM($B9:C9),$A$3:$A$6,1)-SUM(B9:$B9)<0,C9*VLOOKUP(SUM($B9:C9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:C9),$A$3:$A$6,1)-SUM(B9:$B9))*INDEX($B$3:$B$6,MATCH(SUM($B9:C9),$A$3:$A$6)-1)+(SUM($B9:C9)-VLOOKUP(SUM($B9:C9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:C9),$A$3:$A$6)))","v":2750},{"$f":"IF(VLOOKUP(SUM($B9:D9),$A$3:$A$6,1)-SUM($B9:C9)<0,D9*VLOOKUP(SUM($B9:D9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:D9),$A$3:$A$6,1)-SUM($B9:C9))*INDEX($B$3:$B$6,MATCH(SUM($B9:D9),$A$3:$A$6)-1)+(SUM($B9:D9)-VLOOKUP(SUM($B9:D9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:D9),$A$3:$A$6)))","v":1750},{"$f":"IF(VLOOKUP(SUM($B9:E9),$A$3:$A$6,1)-SUM($B9:D9)<0,E9*VLOOKUP(SUM($B9:E9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:E9),$A$3:$A$6,1)-SUM($B9:D9))*INDEX($B$3:$B$6,MATCH(SUM($B9:E9),$A$3:$A$6)-1)+(SUM($B9:E9)-VLOOKUP(SUM($B9:E9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:E9),$A$3:$A$6)))","v":3750},{"$f":"IF(VLOOKUP(SUM($B9:F9),$A$3:$A$6,1)-SUM($B9:E9)<0,F9*VLOOKUP(SUM($B9:F9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:F9),$A$3:$A$6,1)-SUM($B9:E9))*INDEX($B$3:$B$6,MATCH(SUM($B9:F9),$A$3:$A$6)-1)+(SUM($B9:F9)-VLOOKUP(SUM($B9:F9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:F9),$A$3:$A$6)))","v":2500},{"$f":"IF(VLOOKUP(SUM($B9:G9),$A$3:$A$6,1)-SUM($B9:F9)<0,G9*VLOOKUP(SUM($B9:G9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:G9),$A$3:$A$6,1)-SUM($B9:F9))*INDEX($B$3:$B$6,MATCH(SUM($B9:G9),$A$3:$A$6)-1)+(SUM($B9:G9)-VLOOKUP(SUM($B9:G9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:G9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:H9),$A$3:$A$6,1)-SUM($B9:G9)<0,H9*VLOOKUP(SUM($B9:H9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:H9),$A$3:$A$6,1)-SUM($B9:G9))*INDEX($B$3:$B$6,MATCH(SUM($B9:H9),$A$3:$A$6)-1)+(SUM($B9:H9)-VLOOKUP(SUM($B9:H9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:H9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:I9),$A$3:$A$6,1)-SUM($B9:H9)<0,I9*VLOOKUP(SUM($B9:I9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:I9),$A$3:$A$6,1)-SUM($B9:H9))*INDEX($B$3:$B$6,MATCH(SUM($B9:I9),$A$3:$A$6)-1)+(SUM($B9:I9)-VLOOKUP(SUM($B9:I9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:I9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:J9),$A$3:$A$6,1)-SUM($B9:I9)<0,J9*VLOOKUP(SUM($B9:J9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:J9),$A$3:$A$6,1)-SUM($B9:I9))*INDEX($B$3:$B$6,MATCH(SUM($B9:J9),$A$3:$A$6)-1)+(SUM($B9:J9)-VLOOKUP(SUM($B9:J9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:J9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:K9),$A$3:$A$6,1)-SUM($B9:J9)<0,K9*VLOOKUP(SUM($B9:K9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:K9),$A$3:$A$6,1)-SUM($B9:J9))*INDEX($B$3:$B$6,MATCH(SUM($B9:K9),$A$3:$A$6)-1)+(SUM($B9:K9)-VLOOKUP(SUM($B9:K9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:K9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:L9),$A$3:$A$6,1)-SUM($B9:K9)<0,L9*VLOOKUP(SUM($B9:L9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:L9),$A$3:$A$6,1)-SUM($B9:K9))*INDEX($B$3:$B$6,MATCH(SUM($B9:L9),$A$3:$A$6)-1)+(SUM($B9:L9)-VLOOKUP(SUM($B9:L9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:L9),$A$3:$A$6)))","v":0},{"$f":"IF(VLOOKUP(SUM($B9:M9),$A$3:$A$6,1)-SUM($B9:L9)<0,M9*VLOOKUP(SUM($B9:M9),$A$3:$B$6,2),(VLOOKUP(SUM($B9:M9),$A$3:$A$6,1)-SUM($B9:L9))*INDEX($B$3:$B$6,MATCH(SUM($B9:M9),$A$3:$A$6)-1)+(SUM($B9:M9)-VLOOKUP(SUM($B9:M9),$A$3:$A$6,1))*INDEX($B$3:$B$6,MATCH(SUM($B9:M9),$A$3:$A$6)))","v":0}]
["Formula 3",{"$f":"IF(B9<=$A$25,B9*$B$3,IF(B9<=$A$26,($A$25*$B$3)+((B9-$A$25)*$B$4),IF(B9<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((B9-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((B9-$A$27)*$B$6))))","v":1500},{"$f":"IF(SUM($B9:C9)<=$A$25,SUM($B9:C9)*$B$3,IF(SUM($B9:C9)<=$A$26,($A$25*$B$3)+((SUM($B9:C9)-$A$25)*$B$4),IF(SUM($B9:C9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:C9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:C9)-$A$27)*$B$6))))-SUM($B21:B21)","v":2750},{"$f":"IF(SUM($B9:D9)<=$A$25,SUM($B9:D9)*$B$3,IF(SUM($B9:D9)<=$A$26,($A$25*$B$3)+((SUM($B9:D9)-$A$25)*$B$4),IF(SUM($B9:D9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:D9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:D9)-$A$27)*$B$6))))-SUM($B21:C21)","v":1750},{"$f":"IF(SUM($B9:E9)<=$A$25,SUM($B9:E9)*$B$3,IF(SUM($B9:E9)<=$A$26,($A$25*$B$3)+((SUM($B9:E9)-$A$25)*$B$4),IF(SUM($B9:E9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:E9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:E9)-$A$27)*$B$6))))-SUM($B21:D21)","v":3750},{"$f":"IF(SUM($B9:F9)<=$A$25,SUM($B9:F9)*$B$3,IF(SUM($B9:F9)<=$A$26,($A$25*$B$3)+((SUM($B9:F9)-$A$25)*$B$4),IF(SUM($B9:F9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:F9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:F9)-$A$27)*$B$6))))-SUM($B21:E21)","v":2500},{"$f":"IF(SUM($B9:G9)<=$A$25,SUM($B9:G9)*$B$3,IF(SUM($B9:G9)<=$A$26,($A$25*$B$3)+((SUM($B9:G9)-$A$25)*$B$4),IF(SUM($B9:G9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:G9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:G9)-$A$27)*$B$6))))-SUM($B21:F21)","v":0},{"$f":"IF(SUM($B9:H9)<=$A$25,SUM($B9:H9)*$B$3,IF(SUM($B9:H9)<=$A$26,($A$25*$B$3)+((SUM($B9:H9)-$A$25)*$B$4),IF(SUM($B9:H9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:H9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:H9)-$A$27)*$B$6))))-SUM($B21:G21)","v":0},{"$f":"IF(SUM($B9:I9)<=$A$25,SUM($B9:I9)*$B$3,IF(SUM($B9:I9)<=$A$26,($A$25*$B$3)+((SUM($B9:I9)-$A$25)*$B$4),IF(SUM($B9:I9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:I9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:I9)-$A$27)*$B$6))))-SUM($B21:H21)","v":0},{"$f":"IF(SUM($B9:J9)<=$A$25,SUM($B9:J9)*$B$3,IF(SUM($B9:J9)<=$A$26,($A$25*$B$3)+((SUM($B9:J9)-$A$25)*$B$4),IF(SUM($B9:J9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:J9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:J9)-$A$27)*$B$6))))-SUM($B21:I21)","v":0},{"$f":"IF(SUM($B9:K9)<=$A$25,SUM($B9:K9)*$B$3,IF(SUM($B9:K9)<=$A$26,($A$25*$B$3)+((SUM($B9:K9)-$A$25)*$B$4),IF(SUM($B9:K9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:K9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:K9)-$A$27)*$B$6))))-SUM($B21:J21)","v":0},{"$f":"IF(SUM($B9:L9)<=$A$25,SUM($B9:L9)*$B$3,IF(SUM($B9:L9)<=$A$26,($A$25*$B$3)+((SUM($B9:L9)-$A$25)*$B$4),IF(SUM($B9:L9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:L9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:L9)-$A$27)*$B$6))))-SUM($B21:K21)","v":0},{"$f":"IF(SUM($B9:M9)<=$A$25,SUM($B9:M9)*$B$3,IF(SUM($B9:M9)<=$A$26,($A$25*$B$3)+((SUM($B9:M9)-$A$25)*$B$4),IF(SUM($B9:M9)<=$A$27,($A$25*$B$3)+(($A$26-$A$25)*$B$4)+((SUM($B9:M9)-$A$26)*$B$5),($A$25*$B$3)+(($A$26-$A$25)*$B$4)+(($A$27-$A$26)*$B$5)+((SUM($B9:M9)-$A$27)*$B$6))))-SUM($B21:L21)","v":0}]
[]
[]
["Max"]
[20000]
[40000]
[60000]

{"sheet":"(674)","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Aladin:","http://www.mrexcel.com/forum/showthread.php?p=2386428&posted=1"]
["VoG"]
["Counting with Two OR criteria"]
["Count \"Not Started\" or blanks",null,"Date","Project","Status",null,"Categories"]
[{"$f":"COUNTIF(E5:E15,\"Not Started\")+COUNTIF(E5:E15,\"\")","v":6},null,"2010-07-23","Project 1","Done",null,"Done"]
[{"$f":"SUMPRODUCT((E5:E15=\"\")+(E5:E15=\"Not Started\"))","v":6},null,"2010-07-24","Project 2","Done",null,"Mid"]
[{"$f":"SUM(COUNTIF(E5:E15,{\"\",\"Not Started\"}))","v":6},null,"2010-07-25","Project 3","Not Started",null,"Not Started"]
[null,null,"2010-07-26","Project 4"]
[null,null,"2010-07-27","Project 5"]
[null,null,"2010-07-28","Project 6","Not Started"]
[null,null,"2010-07-29","Project 7"]
[null,null,"2010-07-30","Project 8","Done"]
[null,null,"2010-07-31","Project 9","Mid"]
[null,null,"2010-08-01","Project 10","Done"]
[null,null,"2010-08-02","Project 11"]

{"sheet":"(674an)","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Aladin:","http://www.mrexcel.com/forum/showthread.php?p=2386428&posted=1"]
["VoG"]
["Counting with Two OR creiteria"]
["Count \"Not Started\" or blanks",null,"Date","Project","Status",null,"Categories"]
[{"$f":"COUNTIF(E5:E15,\"\")+COUNTIF(E5:E15,\"Not Started\")","v":6},null,"2010-07-23","Project 1","Done",null,"Done"]
[{"$f":"SUMPRODUCT((E5:E15=\"\")+(E5:E15=\"Not Started\"))","v":6},null,"2010-07-24","Project 2","Done",null,"Mid"]
[{"$f":"SUM(COUNTIF(E5:E15,{\"\",\"Not Started\"}))","v":6},null,"2010-07-25","Project 3","Not Started",null,"Not Started"]
[null,null,"2010-07-26","Project 4"]
[null,null,"2010-07-27","Project 5"]
[null,null,"2010-07-28","Project 6","Not Started"]
[null,null,"2010-07-29","Project 7"]
[null,null,"2010-07-30","Project 8","Done"]
[null,null,"2010-07-31","Project 9","Mid"]
[null,null,"2010-08-01","Project 10","Done"]
[null,null,"2010-08-02","Project 11"]

{"sheet":"(675)","index":4,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["ITEM","PRICE",null,"formula used:",null,"Item","Lower","Upper",null,"Tshirt Price Range","$50 to $100"]
["Tshirt",25,null,null,null,"Tshirt",50,100,null,"Pants Price Range","$100 to $200"]
["Pants",200,null,null,null,"Pants",100,200,null,"Blouse Price Range","$75 to $150"]
["Blouse",150,null,null,null,"Blouse",75,150,null,"Bag Price Range","$200 to $500"]
[null,null,null,null,null,"Bag",200,500]

{"sheet":"(675an)","index":5,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ITEM","PRICE",null,"formula used:",null,"Item","Lower","Upper",null,"Tshirt Price Range","$50 to $100"]
["Tshirt",100,null,{"$f":"AND(B2>=VLOOKUP(A2,$F$2:$H$5,2,0),B2<=VLOOKUP(A2,$F$2:$H$5,3,0))","v":true},null,"Tshirt",50,100,null,"Pants Price Range","$100 to $200"]
["Pants",200,null,true,null,"Pants",100,200,null,"Blouse Price Range","$75 to $150"]
["Blouse",150,null,true,null,"Blouse",75,150,null,"Bag Price Range","$200 to $500"]
["Bag",200,null,true,null,"Bag",200,500]
["Pants",null,null,false]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]
[null,null,null,{"$error":"#N/A"}]

{"sheet":"(676)","index":6,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Pro1",0,4,1]
["Pro2",2,6,5]
["Pro3",1,2,4]
[]
["Total"]
[]
[]
[]
[]
["Pro1",{"$f":"INT(RAND()*7)","v":4},2,1]
["Pro2",1,6,2,null,null,4]
["Pro3",0,5,0]
[]
[null,null,null,null,null,null,null,{"$f":"SUM($B$11:INDEX($13:$13,SUMPRODUCT(MAX(($11:$13<>\"\")*COLUMN($11:$13)*ISNUMBER($11:$13)))))","v":25}]
[null,null,null,null,null,null,null,{"$f":"SUM($B$11:INDEX($13:$13,_xlfn.AGGREGATE(14,6,($11:$13<>\"\")*COLUMN($11:$13)*ISNUMBER($11:$13),1)))","v":25}]
[null,null,null,null,null,null,null,{"$f":"SUM(B11:G13)","v":25}]

{"sheet":"(676an)","index":7,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Pro1",0,4,1,1,1]
["Pro2",2,6,5,5,5]
["Pro3",1,2,4,4,4]
[]
["Total",{"$f":"$B$2:INDEX($B$4:$AE$4,MATCH(10^10,$B$4:$AE$4))","v":0}]
[]
[null,{"$f":"SUM(RangeValuesFirst)","v":45}]
[]
[]
["Pro1",{"$f":"INT(RAND()*7)","v":4},2,3]
["Pro2",5,3,6,null,null,4]
["Pro3",5,2,3]
[]
[null,null,null,null,null,null,null,{"$f":"SUM($B$11:INDEX($13:$13,SUMPRODUCT(MAX(($11:$13<>\"\")*COLUMN($11:$13)*ISNUMBER($11:$13)))))","v":37}]
[null,null,null,null,null,null,null,{"$f":"SUM($B$11:INDEX($13:$13,_xlfn.AGGREGATE(14,6,($11:$13<>\"\")*COLUMN($11:$13)*ISNUMBER($11:$13),1)))","v":37}]
[null,null,null,null,null,null,null,{"$f":"SUM(B11:G13)","v":37}]

{"sheet":"(677)","index":8,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Player","Date","Score",null,"Name",{"$f":"\"Average Last \"&H2","v":"Average Last 3"},null,"Find last"]
["Mary","2010-07-01",10,null,"Mary",null,null,3]
["Kate","2010-07-02",4,null,"Kate"]
["Kate","2010-07-03",7,null,"Joe"]
["Kate","2010-07-05",4]
["Kate","2010-07-05",3,null,"post:","http://www.mrexcel.com/forum/showthread.php?t=482169"]
["Kate","2010-07-06",7,null,null,"Aladin"]
["Mary","2010-07-07",10,null,null,"pgc01"]
["Mary","2010-07-08",5]
["Mary","2010-07-09",7]
["Kate","2010-07-10",10]
["Joe","2010-07-11",3]

{"sheet":"(677an)","index":9,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Player","Date","Score",null,"Name",{"$f":"\"Average Last \"&H2","v":"Average Last 3"},null,"Find last"]
["Mary","2010-07-01",10,null,"Mary",{"$f":"AVERAGE(IF($A$2:$A$12=E2,IF(ROW($B$2:$B$12)>=LARGE(IF($A$2:$A$12=E2,ROW($B$2:$B$12)),MIN(COUNTIF($A$2:$A$12,E2),$H$2)),$C$2:$C$12)))","v":7.333333333333333},null,3]
["Kate","2010-07-02",4,null,"Kate",{"$f":"AVERAGE(IF($A$2:$A$12=E3,IF(ROW($B$2:$B$12)>=LARGE(IF($A$2:$A$12=E3,ROW($B$2:$B$12)),MIN(COUNTIF($A$2:$A$12,E3),$H$2)),$C$2:$C$12)))","v":6.666666666666667},null,null,null,{"$f":"AVERAGE(C11,C7,C6)","v":6.666666666666667}]
["Kate","2010-07-03",7,null,"Joe",{"$f":"AVERAGE(IF($A$2:$A$12=E4,IF(ROW($B$2:$B$12)>=LARGE(IF($A$2:$A$12=E4,ROW($B$2:$B$12)),MIN(COUNTIF($A$2:$A$12,E4),$H$2)),$C$2:$C$12)))","v":3}]
["Kate","2010-07-05",4]
["Kate","2010-07-05",3,null,"post:","http://www.mrexcel.com/forum/showthread.php?t=482169"]
["Kate","2010-07-06",7,null,null,"Aladin"]
["Mary","2010-07-07",10,null,null,"pgc01"]
["Mary","2010-07-08",5,null,null,{"$f":"IF(COUNTIF($A$2:$A$12,E2)<$H$2,\"Not Enough\",AVERAGE(IF($A$2:$A$12=E2,IF(ROW($B$2:$B$12)>=LARGE(IF($A$2:$A$12=E2,ROW($B$2:$B$12)),$H$2),$C$2:$C$12))))","v":7.333333333333333}]
["Mary","2010-07-09",7,null,null,{"$f":"IF(COUNTIF($A$2:$A$12,E3)<$H$2,\"Not Enough\",AVERAGE(IF($A$2:$A$12=E3,IF(ROW($B$2:$B$12)>=LARGE(IF($A$2:$A$12=E3,ROW($B$2:$B$12)),$H$2),$C$2:$C$12))))","v":6.666666666666667}]
["Kate","2010-07-10",10,null,null,{"$f":"IF(COUNTIF($A$2:$A$12,E4)<$H$2,\"Not Enough\",AVERAGE(IF($A$2:$A$12=E4,IF(ROW($B$2:$B$12)>=LARGE(IF($A$2:$A$12=E4,ROW($B$2:$B$12)),$H$2),$C$2:$C$12))))","v":"Not Enough"}]
["Joe","2010-07-11",3]

{"sheet":"(678)","index":10,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Team","Deadline","2010-07-07","2010-07-08","2010-07-09","2010-07-12","2010-07-13","2010-07-14","2010-07-15","Total After Deadline"]
["Red","2010-07-13",225,225,775,0,790,0,873]
["Blue","2010-07-08",0,4055,0,1585,325,0,760]
["Green","2010-07-09",500,0,1335,0,2585,3040,2046]

{"sheet":"(678an)","index":11,"n_rows":4,"n_cols":12,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Team","Deadline","2010-07-07","2010-07-08","2010-07-09","2010-07-12","2010-07-13","2010-07-14","2010-07-15","Total After Deadline"]
["Red","2010-07-13",225,225,775,0,790,0,873,{"$f":"SUM(INDEX(C2:I2,MATCH(B2,$C$1:$I$1)):I2)","v":1663},null,{"$f":"SUMPRODUCT(--($C$1:$I$1>=B2),C2:I2)","v":1663}]
["Blue","2010-07-08",0,4055,0,1585,325,0,760,{"$f":"SUM(INDEX(C3:I3,MATCH(B3,$C$1:$I$1)):I3)","v":6725},null,{"$f":"SUMPRODUCT(--($C$1:$I$1>=B3),C3:I3)","v":6725}]
["Green","2010-07-09",500,0,1335,0,2585,3040,2046,{"$f":"SUM(INDEX(C4:I4,MATCH(B4,$C$1:$I$1)):I4)","v":9006},null,9006]

{"sheet":"(679)","index":12,"n_rows":122,"n_cols":6,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"2003 method","2007/2010 method"]
["Date","Monthly Withdrawals",null,"Year","Annual Withdrawals","Annual Withdrawals"]
["2007-04-25",{"$f":"RANDBETWEEN(15000,47000)","v":25096},null,"2005-12-31"]
["2005-02-09",{"$f":"RANDBETWEEN(15000,47000)","v":19346},null,"2006-12-31"]
["2013-09-14",45074,null,"2007-12-31"]
["2006-12-25",20571,null,"2008-12-31"]
["2007-11-02",15618,null,"2009-12-31"]
["2009-12-09",17559,null,"2010-12-31"]
["2006-09-21",40683,null,"2011-12-31"]
["2008-09-30",29422,null,"2012-12-31"]
["2014-01-08",29351,null,"2013-12-31"]
["2005-10-25",19477,null,"2014-12-31"]
["2005-09-09",31415]
["2011-04-26",21770]
["2012-02-11",33542]
["2008-06-21",46099]
["2010-10-07",17850]
["2014-02-27",23195]
["2008-02-06",35583]
["2011-06-11",23757]
["2013-08-27",17175]
["2014-09-18",37635]
["2013-02-21",16376]
["2013-05-18",32194]
["2014-06-24",40612]
["2013-04-21",44458]
["2011-08-10",16190]
["2011-04-22",46369]
["2009-03-09",19437]
["2014-04-30",33202]
["2011-02-10",16261]
["2006-12-24",35133]
["2012-12-28",30532]
["2014-08-02",39712]
["2005-08-05",36417]
["2012-02-28",40222]
["2013-07-23",42693]
["2006-12-29",38029]
["2011-03-15",41068]
["2009-06-23",37650]
["2005-07-30",34628]
["2005-02-15",46231]
["2011-10-14",31963]
["2005-08-21",23705]
["2005-02-23",17877]
["2013-01-30",33019]
["2013-02-08",35599]
["2008-10-20",45743]
["2013-09-02",28447]
["2009-01-02",18437]
["2010-07-29",46590]
["2007-09-05",36561]
["2008-10-02",35395]
["2010-01-09",31135]
["2013-06-15",44835]
["2005-10-01",22693]
["2011-03-03",34564]
["2011-01-24",34752]
["2014-05-19",43635]
["2009-06-21",26399]
["2007-01-05",32280]
["2014-10-23",22222]
["2011-02-08",39883]
["2005-12-17",40391]
["2010-12-09",37072]
["2013-01-21",30686]
["2009-10-04",42119]
["2012-12-10",{"$f":"RANDBETWEEN(15000,47000)","v":44368}]
["2011-10-17",30310]
["2005-01-24",35907]
["2006-05-20",34155]
["2013-10-10",33234]
["2013-06-10",34989]
["2014-12-29",30128]
["2014-01-19",36676]
["2012-06-23",42236]
["2009-02-14",42121]
["2014-01-26",27784]
["2007-01-27",29656]
["2005-01-14",21820]
["2006-01-06",41111]
["2009-07-19",33640]
["2006-09-13",17667]
["2010-01-26",23126]
["2010-12-13",18635]
["2010-07-08",31660]
["2008-11-02",25514]
["2006-10-10",44757]
["2006-02-15",36806]
["2006-02-04",42558]
["2006-01-30",27755]
["2008-03-31",23192]
["2008-08-03",25299]
["2005-11-29",40960]
["2005-12-06",39413]
["2011-11-12",36836]
["2012-01-01",20330]
["2008-07-20",43587]
["2008-08-20",25437]
["2008-01-07",26144]
["2010-01-12",25853]
["2014-02-05",24864]
["2011-02-05",42876]
["2005-06-09",21557]
["2009-06-21",44110]
["2006-04-28",40103]
["2009-12-21",37693]
["2012-03-11",34972]
["2009-08-26",20819]
["2008-12-11",44024]
["2007-08-25",34204]
["2013-03-03",37989]
["2008-02-20",30595]
["2005-05-20",22368]
["2010-05-07",28540]
["2012-07-27",27762]
["2009-08-05",38680]
["2010-07-11",29034]
["2013-04-17",31579]
["2008-05-24",35685]
["2006-12-09",35483]
["2013-08-04",34465]

{"sheet":"(679an)","index":13,"n_rows":122,"n_cols":6,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"2003 method","2007/2010 method"]
["Date","Monthly Withdrawals",null,"Year","Annual Withdrawals","Annual Withdrawals"]
["2007-04-25",{"$f":"RANDBETWEEN(15000,47000)","v":31235},null,"2005-12-31",{"$f":"SUMPRODUCT(--(YEAR(D3)=YEAR($A$3:$A$122)),$B$3:$B$122)","v":480904},{"$f":"SUMIFS($B$3:$B$122,$A$3:$A$122,\"<=\"&D3,$A$3:$A$122,\">=\"&DATE(YEAR(D3),1,1))","v":480904}]
["2005-02-09",{"$f":"RANDBETWEEN(15000,47000)","v":39037},null,"2006-12-31",{"$f":"SUMPRODUCT(--(YEAR(D4)=YEAR($A$3:$A$122)),$B$3:$B$122)","v":405179},{"$f":"SUMIFS($B$3:$B$122,$A$3:$A$122,\"<=\"&D4,$A$3:$A$122,\">=\"&DATE(YEAR(D4),1,1))","v":405179}]
["2013-09-14",15263,null,"2007-12-31",168085,168085]
["2006-12-25",24134,null,"2008-12-31",368261,368261]
["2007-11-02",38511,null,"2009-12-31",353669,353669]
["2009-12-09",42935,null,"2010-12-31",322287,322287]
["2006-09-21",42202,null,"2011-12-31",441514,441514]
["2008-09-30",19336,null,"2012-12-31",229589,229589]
["2014-01-08",35594,null,"2013-12-31",475625,475625]
["2005-10-25",29678,null,"2014-12-31",351866,351866]
["2005-09-09",16974]
["2011-04-26",26423]
["2012-02-11",38502]
["2008-06-21",35575]
["2010-10-07",21451]
["2014-02-27",26513]
["2008-02-06",43256]
["2011-06-11",33612]
["2013-08-27",26768]
["2014-09-18",16550]
["2013-02-21",32406]
["2013-05-18",40774]
["2014-06-24",45599]
["2013-04-21",23792]
["2011-08-10",45746]
["2011-04-22",24689]
["2009-03-09",15908]
["2014-04-30",33885]
["2011-02-10",36909]
["2006-12-24",23454]
["2012-12-28",23002]
["2014-08-02",41930]
["2005-08-05",15762]
["2012-02-28",27349]
["2013-07-23",42065]
["2006-12-29",34352]
["2011-03-15",25295]
["2009-06-23",37637]
["2005-07-30",22965]
["2005-02-15",32613]
["2011-10-14",36280]
["2005-08-21",33660]
["2005-02-23",33194]
["2013-01-30",15713]
["2013-02-08",45529]
["2008-10-20",16840]
["2013-09-02",21368]
["2009-01-02",29973]
["2010-07-29",41219]
["2007-09-05",21155]
["2008-10-02",16691]
["2010-01-09",38931]
["2013-06-15",32785]
["2005-10-01",25323]
["2011-03-03",46419]
["2011-01-24",18519]
["2014-05-19",21923]
["2009-06-21",23252]
["2007-01-05",19634]
["2014-10-23",28522]
["2011-02-08",35239]
["2005-12-17",38210]
["2010-12-09",33727]
["2013-01-21",22524]
["2009-10-04",15918]
["2012-12-10",{"$f":"RANDBETWEEN(15000,47000)","v":19816}]
["2011-10-17",33774]
["2005-01-24",44445]
["2006-05-20",15986]
["2013-10-10",45662]
["2013-06-10",46292]
["2014-12-29",27560]
["2014-01-19",18085]
["2012-06-23",26695]
["2009-02-14",32119]
["2014-01-26",28004]
["2007-01-27",32965]
["2005-01-14",45625]
["2006-01-06",33376]
["2009-07-19",30368]
["2006-09-13",46697]
["2010-01-26",38032]
["2010-12-13",22898]
["2010-07-08",25374]
["2008-11-02",16919]
["2006-10-10",22041]
["2006-02-15",38114]
["2006-02-04",27813]
["2006-01-30",40474]
["2008-03-31",17405]
["2008-08-03",15174]
["2005-11-29",25383]
["2005-12-06",15925]
["2011-11-12",46120]
["2012-01-01",22363]
["2008-07-20",20442]
["2008-08-20",40707]
["2008-01-07",38172]
["2010-01-12",45793]
["2014-02-05",27701]
["2011-02-05",32489]
["2005-06-09",25198]
["2009-06-21",29592]
["2006-04-28",15164]
["2009-12-21",46587]
["2012-03-11",28678]
["2009-08-26",21564]
["2008-12-11",32443]
["2007-08-25",24585]
["2013-03-03",15452]
["2008-02-20",18826]
["2005-05-20",36912]
["2010-05-07",20392]
["2012-07-27",43184]
["2009-08-05",27816]
["2010-07-11",34470]
["2013-04-17",15074]
["2008-05-24",36475]
["2006-12-09",41372]
["2013-08-04",34158]

{"sheet":"(680)","index":14,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Rev",100,100,100]
[{"$f":"A9","v":"Ex1"},{"$f":"B$1*$B9","v":15},15,15]
[{"$f":"A10","v":"Ex2"},17,17,17]
[{"$f":"A11","v":"Ex3"},5,5,5]
[{"$f":"A12","v":"Ex4"},35,35,35]
[{"$f":"A13","v":"Ex5"},68,68,68]
[]
["assumptions",null,null,"scenarios button"]
["Ex1",0.15]
["Ex2",0.17]
["Ex3",0.05]
["Ex4",0.35]
["Ex5",0.68]

{"sheet":"(68oan)","index":15,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Rev",100,100,100]
[{"$f":"A9","v":"Ex1"},{"$f":"B$1*$B9","v":15},15,15]
[{"$f":"A10","v":"Ex2"},17,17,17]
[{"$f":"A11","v":"Ex3"},5,5,5]
[{"$f":"A12","v":"Ex4"},35,35,35]
[{"$f":"A13","v":"Ex5"},68,68,68]
[]
["assumptions",null,null,"scenarios button"]
["Ex1",0.15]
["Ex2",0.17]
["Ex3",0.05]
["Ex4",0.35]
["Ex5",0.68]

{"sheet":"(681)","index":16,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Smallest Number That Is Greater Than Zero",null,{"$f":"RANDBETWEEN(-50,200)/10","v":13.8}]
[null,null,6.7]
[null,null,4.3]
["Remember to use: Ctrl + Shift + Enter",null,13.3]
[null,null,-4]
[null,null,16.899999999999999]
[null,null,11]
[null,null,4.4000000000000004]
[null,null,17.399999999999999]
[null,null,13.4]
[null,null,17.2]
[null,null,16.600000000000001]
[null,null,8.6999999999999993]
[null,null,-2.2000000000000002]
[null,null,3.7]
[null,null,10.6]
[null,null,-4.5]
[null,null,19.7]
[null,null,18.399999999999999]
[null,null,15.6]
[null,null,3.9]
[null,null,10.4]
[null,null,8.8000000000000007]
[null,null,0.6]
[null,null,-1.7]
[null,null,8.1]

{"sheet":"(681an)","index":17,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Smallest Number That Is Greater Than Zero",null,{"$f":"RANDBETWEEN(-50,200)/10","v":-2.2000000000000002}]
[{"$f":"MIN(IF(C1:C26>0,C1:C26))","v":1.8},null,2.2999999999999998]
[null,null,2.1]
["Remember to use: Ctrl + Shift + Enter",null,8.3000000000000007]
[null,null,15.6]
[null,null,13.4]
[null,null,11.2]
[null,null,11]
[null,null,6.3]
[null,null,3]
[null,null,15.8]
[null,null,4]
[null,null,11.5]
[null,null,14]
[null,null,1.9]
[null,null,14]
[null,null,-0.2]
[null,null,-1.7]
[null,null,-2.6]
[null,null,14]
[null,null,15.9]
[null,null,1.8]
[null,null,10.5]
[null,null,3.9]
[null,null,5.5]
[null,null,10.7]

{"sheet":"(682)","index":18,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Average",null,"Times Entered As Text",null,"Times Entered As Text",null,"Average",null,"Times Entered As Text",null,"Average"]
[null,null,"08:30",null,"08:30",null,{"$f":"AVERAGE(E2:E16)","v":{"$error":"#DIV/0!"}},null," 08:30"]
[{"$f":"AVERAGE(IF(C2:C16<>\"\",C2:C16+0))","v":0.19083333333333335},null,"06:12",null,"06:12",null,null,null," 06:12"]
["Average of all text",null,"06:12",null,"06:12",null,null,null," 06:12"]
[{"$f":"AVERAGE(C2:C16)","v":{"$error":"#DIV/0!"}},null,"02:30",null,"02:30",null,null,null," 02:30"]
[null,null,"01:06",null,"01:06",null,null,null," 01:06"]
[null,null,"07:06",null,"07:06",null,null,null," 07:06"]
[null,null,"02:54",null,"02:54",null,null,null," 02:54"]
[null,null,"07:24",null,"07:24",null,null,null," 07:24"]
[null,null,"04:06",null,"04:06",null,null,null," 04:06"]
[null,null,"06:36",null,"06:36",null,null,null," 06:36"]
[null,null,"06:00",null,"06:00",null,null,null," 06:00"]
[null,null,"05:00",null,"05:00",null,null,null," 05:00"]
[null,null,"01:36",null,"01:36",null,null,null," 01:36"]
[null,null,"02:18",null,"02:18",null,null,null," 02:18"]
[null,null,"01:12",null,"01:12",null,null,null," 01:12"]

{"sheet":"(682an)","index":19,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Average",null,"Times Entered As Text",null,"Times Entered As Text",null,"Average",null,"Times Entered As Text",null,"Average"]
[{"$f":"AVERAGE(IF(C2:C16<>\"\",C2:C16+0))","v":0.18601190476190479},null,"08:30",null,"08:30:00",null,{"$f":"AVERAGE(E2:E16)","v":0.19083333333333335},null," 08:30",null,{"$f":"AVERAGE(IF(I2:I16<>\"\",TRIM(I2:I16)+0))","v":0.19083333333333335}]
[{"$f":"AVERAGE(IF(C2:C16<>\"\",C2:C16+0))","v":0.18601190476190479},null,"06:12",null,"06:12:00",null,null,null," 06:12"]
["Average of all text",null,null,null,"06:12:00",null,null,null," 06:12"]
[{"$f":"AVERAGE(C2:C16)","v":{"$error":"#DIV/0!"}},null,"02:30",null,"02:30:00",null,null,null," 02:30"]
[null,null,"01:06",null,"01:06:00",null,null,null," 01:06"]
[null,null,"07:06",null,"07:06:00",null,null,null," 07:06"]
[null,null,"02:54",null,"02:54:00",null,null,null," 02:54"]
[null,null,"07:24",null,"07:24:00",null,null,null," 07:24"]
[null,null,"04:06",null,"04:06:00",null,null,null," 04:06"]
[null,null,"06:36",null,"06:36:00",null,null,null," 06:36"]
[null,null,"06:00",null,"06:00:00",null,null,null," 06:00"]
[null,null,"05:00",null,"05:00:00",null,null,null," 05:00"]
[null,null,"01:36",null,"01:36:00",null,null,null," 01:36"]
[null,null,"02:18",null,"02:18:00",null,null,null," 02:18"]
[null,null,"01:12",null,"01:12:00",null,null,null," 01:12"]