{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["P(1an)","P(1)","P(2)","P(2an)","P(3)","P(3an)","P(4)","P(4an)","P(5)","P(5an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"P(1an)","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Create Data Validation in cells B3 and B4 to create a drop down list. Then add conditional formatting to highlight the Year column, Product row and intersecting cell in the table so that as you change the values in cell B3 and B4 the conditional formatting will change.."]
[]
["Product","Pro 4"]
["Year",2005]
[]
[null,2000,2001,2002,2003,2004,2005,2006,2007]
["Pro 1",148546,145260,126372,135607,129679,111892,100470,111901]
["Pro 2",135646,96682,150431,141223,142200,124103,80135,151251]
["Pro 3",108400,94271,158998,90988,155191,150893,90387,156265]
["Pro 4",118815,91538,146520,80756,148281,81459,122481,148958]
["Pro 5",85537,144842,155701,127578,141733,159043,147788,111986]
["Pro 6",80333,119081,130797,120655,131298,127321,142540,156891]
["Pro 7",100767,147611,103388,108541,104562,143196,146959,89273]
["Pro 8",136596,93202,129286,97946,139244,125708,121492,98550]
["Pro 9",100584,119456,159582,141626,155847,89087,93680,136835]
["Pro 10",84500,95228,153251,124015,84391,159122,154183,98852]
["Pro 11",152229,116764,155102,147374,127889,123911,118891,148613]
["Pro 12",158323,132992,108734,86834,128842,85926,128578,80408]
["Pro 13",97946,94548,134937,137324,87869,124531,143985,84303]
["Pro 14",85431,91944,86687,81169,125446,154327,152973,109150]

{"sheet":"P(1)","index":1,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Create Data Validation in cells B3 and B4 to create a drop down list. Then add conditional formatting to highlight the Year column, Product row and intersecting cell in the table so that as you change the values in cell B3 and B4 the conditional formatting will change.."]
[]
["Product"]
["Year"]
[]
[null,2000,2001,2002,2003,2004,2005,2006,2007]
["Pro 1",148546,145260,126372,135607,129679,111892,100470,111901]
["Pro 2",135646,96682,150431,141223,142200,124103,80135,151251]
["Pro 3",108400,94271,158998,90988,155191,150893,90387,156265]
["Pro 4",118815,91538,146520,80756,148281,81459,122481,148958]
["Pro 5",85537,144842,155701,127578,141733,159043,147788,111986]
["Pro 6",80333,119081,130797,120655,131298,127321,142540,156891]
["Pro 7",100767,147611,103388,108541,104562,143196,146959,89273]
["Pro 8",136596,93202,129286,97946,139244,125708,121492,98550]
["Pro 9",100584,119456,159582,141626,155847,89087,93680,136835]
["Pro 10",84500,95228,153251,124015,84391,159122,154183,98852]
["Pro 11",152229,116764,155102,147374,127889,123911,118891,148613]
["Pro 12",158323,132992,108734,86834,128842,85926,128578,80408]
["Pro 13",97946,94548,134937,137324,87869,124531,143985,84303]
["Pro 14",85431,91944,86687,81169,125446,154327,152973,109150]

{"sheet":"P(2)","index":2,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Add Conditional Formatting to highlight the 5 largest values."]
[]
[null,2000,2001,2002,2003,2004,2005,2006,2007]
["Pro 1",148546,145260,126372,135607,129679,111892,100470,111901]
["Pro 2",135646,96682,150431,141223,142200,124103,80135,151251]
["Pro 3",108400,94271,158998,90988,155191,150893,90387,156265]
["Pro 4",118815,91538,146520,80756,148281,81459,122481,148958]
["Pro 5",85537,144842,155701,127578,141733,159043,147788,111986]
["Pro 6",80333,119081,130797,120655,131298,127321,142540,156891]
["Pro 7",100767,147611,103388,108541,104562,143196,146959,89273]
["Pro 8",136596,93202,129286,97946,139244,125708,121492,98550]
["Pro 9",100584,119456,159582,141626,155847,89087,93680,136835]
["Pro 10",84500,95228,153251,124015,84391,159122,154183,98852]
["Pro 11",152229,116764,155102,147374,127889,123911,118891,148613]
["Pro 12",158323,132992,108734,86834,128842,85926,128578,80408]
["Pro 13",97946,94548,134937,137324,87869,124531,143985,84303]
["Pro 14",85431,91944,86687,81169,125446,154327,152973,109150]

{"sheet":"P(2an)","index":3,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Add Conditional Formatting to highlight the 5 largest values."]
[]
[null,2000,2001,2002,2003,2004,2005,2006,2007,null,"Large?",null,"List"]
["Pro 1",148546,145260,126372,135607,129679,111892,100470,111901,null,5,null,{"$f":"IF(ROWS(M$4:M4)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M4)))","v":159582}]
["Pro 2",135646,96682,150431,141223,142200,124103,80135,151251,null,null,null,{"$f":"IF(ROWS(M$4:M5)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M5)))","v":159122}]
["Pro 3",108400,94271,158998,90988,155191,150893,90387,156265,null,null,null,{"$f":"IF(ROWS(M$4:M6)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M6)))","v":159043}]
["Pro 4",118815,91538,146520,80756,148281,81459,122481,148958,null,null,null,{"$f":"IF(ROWS(M$4:M7)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M7)))","v":158998}]
["Pro 5",85537,144842,155701,127578,141733,159043,147788,111986,null,null,null,{"$f":"IF(ROWS(M$4:M8)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M8)))","v":158323}]
["Pro 6",80333,119081,130797,120655,131298,127321,142540,156891,null,null,null,{"$f":"IF(ROWS(M$4:M9)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M9)))","v":""}]
["Pro 7",100767,147611,103388,108541,104562,143196,146959,89273,null,null,null,{"$f":"IF(ROWS(M$4:M10)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M10)))","v":""}]
["Pro 8",136596,93202,129286,97946,139244,125708,121492,98550,null,null,null,{"$f":"IF(ROWS(M$4:M11)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M11)))","v":""}]
["Pro 9",100584,119456,159582,141626,155847,89087,93680,136835,null,null,null,{"$f":"IF(ROWS(M$4:M12)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M12)))","v":""}]
["Pro 10",84500,95228,153251,124015,84391,159122,154183,98852,null,null,null,{"$f":"IF(ROWS(M$4:M13)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M13)))","v":""}]
["Pro 11",152229,116764,155102,147374,127889,123911,118891,148613,null,null,null,{"$f":"IF(ROWS(M$4:M14)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M14)))","v":""}]
["Pro 12",158323,132992,108734,86834,128842,85926,128578,80408,null,null,null,{"$f":"IF(ROWS(M$4:M15)>K$4,\"\",LARGE($B$4:$I$17,ROWS(M$4:M15)))","v":""}]
["Pro 13",97946,94548,134937,137324,87869,124531,143985,84303]
["Pro 14",85431,91944,86687,81169,125446,154327,152973,109150]

{"sheet":"P(3)","index":4,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Add Conditional Formatting to highlight duplicate values."]
[]
[null,2000,2001,2002,2003,2004,2005,2006,2007]
["Pro 1",148546,145260,126372,135607,129679,111892,100470,111901]
["Pro 2",135646,96682,150431,141223,142200,124103,80135,151251]
["Pro 3",108400,94271,158998,90988,155191,150893,90387,156265]
["Pro 4",118815,91538,146520,80756,148281,81459,122481,148958]
["Pro 5",85537,144842,155701,127578,141733,159043,147788,111986]
["Pro 6",80333,119081,130797,120655,131298,127321,142540,156891]
["Pro 7",100767,147611,103388,108541,104562,143196,146959,89273]
["Pro 8",136596,93202,129286,97946,139244,125708,121492,98550]
["Pro 9",100584,119456,159582,141626,155847,89087,93680,136835]
["Pro 10",84500,95228,153251,124015,84391,159122,154183,98852]
["Pro 11",152229,116764,155102,147374,127889,123911,118891,148613]
["Pro 12",158323,132992,{"$f":"I6","v":156265},86834,128842,85926,128578,80408]
["Pro 13",97946,94548,134937,137324,87869,124531,143985,{"$f":"C8","v":144842}]
["Pro 14",85431,91944,86687,81169,125446,154327,152973,109150]

{"sheet":"P(3an)","index":5,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Add Conditional Formatting to highlight duplicate values."]
[]
[null,2000,2001,2002,2003,2004,2005,2006,2007]
["Pro 1",148546,145260,126372,135607,129679,111892,100470,111901]
["Pro 2",135646,96682,150431,141223,142200,124103,80135,151251]
["Pro 3",108400,94271,158998,90988,155191,150893,90387,156265]
["Pro 4",118815,91538,146520,80756,148281,81459,122481,148958]
["Pro 5",85537,144842,155701,127578,141733,159043,147788,111986]
["Pro 6",80333,119081,130797,120655,131298,127321,142540,156891]
["Pro 7",100767,147611,103388,108541,104562,143196,146959,89273]
["Pro 8",136596,93202,129286,97946,139244,125708,121492,98550]
["Pro 9",100584,119456,159582,141626,155847,89087,93680,136835]
["Pro 10",84500,95228,153251,124015,84391,159122,154183,98852]
["Pro 11",152229,116764,155102,147374,127889,123911,118891,148613]
["Pro 12",158323,132992,{"$f":"I6","v":156265},86834,128842,85926,128578,80408]
["Pro 13",97946,94548,134937,137324,87869,124531,143985,{"$f":"C8","v":144842}]
["Pro 14",85431,91944,86687,81169,125446,154327,152973,109150]

{"sheet":"P(4)","index":6,"n_rows":770,"n_cols":2,"rows_kept":770,"cut":false,"hidden":false,"merged":[]}
["Create a unique list of SalesRep. Then add a COUNTIFS function that will count how many sales each SalesRep had above $150."]
[]
["SalesRep","Sales"]
["Denise",111]
["Thongtara",167]
["Sykes",191]
["Ewelina",110]
["Janita",146]
["Elain",177]
["Gianna",137]
["Richard",116]
["Elain",166]
["Michael",193]
["Ewelina",105]
["Michelle",189]
["Jason",122]
["Craig",196]
["Sarah",161]
["Mansa",197]
["Michelle",113]
["Shari",111]
["Richard",164]
["Christina",167]
["Denise",129]
["Richard",122]
["Thongtara",132]
["Michelle",178]
["Michelle",199]
["Shari",181]
["Carol",110]
["Kaur",104]
["Mitchell",110]
["Debra",185]
["Manavbir",183]
["Sykes",143]
["Elain",120]
["Michelle",147]
["Jason",117]
["Mansa",128]
["Shari",110]
["Kaur",158]
["Manavbir",133]
["Debra",190]
["Sarah",138]
["Daniel",143]
["Manavbir",167]
["Thongtara",135]
["Carol",125]
["Janita",107]
["Carol",162]
["Thongtara",192]
["Daniel",152]
["Gianna",155]
["Kaur",155]
["Mansa",145]
["Janita",149]
["Kaur",180]
["Yla-Katrina",190]
["Richard",127]
["Christina",114]
["Carol",191]
["Sykes",197]
["Sykes",186]
["Gianna",174]
["Yla-Katrina",114]
["Jason",121]
["Debra",134]
["Carol",174]
["Craig",178]
["Ewelina",132]
["Sarah",148]
["Michelle",120]
["Thongtara",199]
["Michelle",109]
["Gianna",138]
["Thongtara",153]
["Janita",122]
["Michael",154]
["Jason",174]
["Denise",181]
["Sarah",113]
["Nelia",177]
["Mitchell",138]
["Denise",175]
["Ewelina",149]
["Shari",140]
["Michelle",152]
["Jason",104]
["Daniel",116]
["Sykes",131]
["Thongtara",135]
["Michelle",164]
["Manavbir",178]
["Debra",139]
["Carol",160]
["Ewelina",162]
["Shari",103]
["Kaur",200]
["Mansa",132]
["Sarah",133]
["Mansa",187]
["Michael",173]
["Sykes",112]
["Daniel",132]
["Sykes",112]
["Daniel",131]
["Craig",175]
["Craig",158]
["Ewelina",148]
["Daniel",187]
["Mansa",168]
["Nelia",116]
["Jason",122]
["Debra",160]
["Debra",192]
["Christina",154]
["Jason",145]
["Richard",178]
["Sarah",112]
["Elain",115]
["Mansa",146]
["Debra",109]
["Denise",172]
["Daniel",146]
["Richard",144]
["Mitchell",146]
["Kaur",105]
["Ewelina",134]
["Richard",118]
["Debra",132]
["Carol",117]
["Michelle",194]
["Debra",122]
["Michelle",134]
["Sykes",134]
["Elain",125]
["Carol",115]
["Christina",105]
["Christina",179]
["Elain",114]
["Elain",176]
["Shari",194]
["Mitchell",170]
["Ewelina",144]
["Christina",175]
["Michelle",185]
["Carol",133]
["Sarah",131]
["Mansa",163]
["Denise",120]
["Manavbir",136]
["Gianna",195]
["Yla-Katrina",157]
["Michelle",187]
["Christina",185]
["Jason",154]
["Jason",187]
["Gianna",142]
["Denise",132]
["Mitchell",127]
["Mansa",184]
["Thongtara",164]
["Sykes",157]
["Craig",186]
["Elain",135]
["Janita",194]
["Thongtara",177]
["Mitchell",143]
["Manavbir",152]
["Nelia",101]
["Janita",110]
["Denise",124]
["Christina",102]
["Richard",139]
["Janita",152]
["Janita",168]
["Michael",151]
["Gianna",137]
["Janita",104]
["Nelia",139]
["Daniel",147]
["Mansa",190]
["Nelia",159]
["Manavbir",112]
["Christina",182]
["Richard",121]
["Kaur",181]
["Craig",104]
["Sykes",194]
["Christina",178]
["Carol",142]
["Mitchell",191]
["Sarah",120]
["Carol",155]
["Manavbir",199]
["Thongtara",106]
["Elain",149]
["Michelle",158]
["Gianna",144]
["Daniel",143]
["Daniel",177]
["Manavbir",142]
["Debra",193]
["Michelle",193]
["Mitchell",112]
["Michelle",123]
["Michael",197]
["Thongtara",155]
["Janita",118]
["Denise",169]
["Daniel",172]
["Michael",132]
["Yla-Katrina",154]
["Christina",152]
["Craig",128]
["Thongtara",101]
["Elain",174]
["Denise",124]
["Craig",172]
["Ewelina",165]
["Thongtara",117]
["Mitchell",109]
["Carol",172]
["Sarah",115]
["Shari",125]
["Sykes",113]
["Debra",152]
["Craig",144]
["Denise",153]
["Thongtara",188]
["Mansa",105]
["Sykes",144]
["Daniel",196]
["Denise",145]
["Manavbir",134]
["Carol",196]
["Michael",110]
["Shari",172]
["Michael",174]
["Gianna",109]
["Sarah",181]
["Michael",185]
["Gianna",170]
["Jason",179]
["Mitchell",109]
["Jason",110]
["Craig",137]
["Ewelina",128]
["Carol",183]
["Mitchell",200]
["Denise",114]
["Gianna",144]
["Elain",142]
["Daniel",167]
["Ewelina",169]
["Manavbir",131]
["Denise",113]
["Thongtara",162]
["Carol",152]
["Elain",143]
["Yla-Katrina",171]
["Michael",147]
["Nelia",164]
["Elain",163]
["Christina",148]
["Yla-Katrina",109]
["Daniel",179]
["Elain",130]
["Jason",197]
["Craig",106]
["Janita",145]
["Yla-Katrina",133]
["Elain",195]
["Debra",151]
["Shari",102]
["Kaur",152]
["Yla-Katrina",168]
["Nelia",139]
["Gianna",159]
["Thongtara",142]
["Mitchell",141]
["Jason",114]
["Richard",102]
["Thongtara",119]
["Richard",196]
["Manavbir",164]
["Manavbir",115]
["Daniel",178]
["Richard",153]
["Ewelina",101]
["Thongtara",151]
["Debra",115]
["Debra",170]
["Sarah",112]
["Daniel",163]
["Mitchell",181]
["Sykes",108]
["Daniel",114]
["Carol",119]
["Michelle",168]
["Manavbir",191]
["Debra",152]
["Shari",155]
["Richard",128]
["Elain",185]
["Michelle",164]
["Kaur",130]
["Manavbir",148]
["Manavbir",190]
["Elain",115]
["Manavbir",123]
["Ewelina",168]
["Janita",124]
["Michael",178]
["Ewelina",101]
["Michael",136]
["Janita",174]
["Nelia",156]
["Daniel",131]
["Craig",152]
["Nelia",193]
["Manavbir",165]
["Nelia",158]
["Elain",104]
["Thongtara",186]
["Ewelina",150]
["Thongtara",167]
["Debra",184]
["Carol",121]
["Sykes",184]
["Yla-Katrina",187]
["Sykes",140]
["Carol",129]
["Carol",184]
["Christina",147]
["Jason",182]
["Manavbir",132]
["Sarah",158]
["Daniel",184]
["Christina",107]
["Craig",148]
["Thongtara",132]
["Daniel",127]
["Christina",184]
["Ewelina",172]
["Daniel",147]
["Michael",124]
["Michael",184]
["Shari",196]
["Shari",122]
["Shari",148]
["Debra",136]
["Christina",133]
["Richard",182]
["Michael",167]
["Craig",133]
["Carol",134]
["Debra",142]
["Mitchell",165]
["Kaur",177]
["Jason",107]
["Gianna",139]
["Manavbir",111]
["Sykes",156]
["Kaur",152]
["Mansa",138]
["Michael",162]
["Ewelina",157]
["Ewelina",175]
["Kaur",135]
["Kaur",194]
["Jason",107]
["Craig",108]
["Carol",198]
["Janita",145]
["Mitchell",168]
["Mitchell",137]
["Gianna",145]
["Daniel",178]
["Manavbir",152]
["Sykes",120]
["Nelia",148]
["Kaur",175]
["Christina",131]
["Kaur",172]
["Janita",155]
["Denise",199]
["Craig",187]
["Gianna",127]
["Jason",200]
["Sarah",133]
["Janita",163]
["Manavbir",131]
["Ewelina",125]
["Shari",170]
["Ewelina",150]
["Daniel",126]
["Thongtara",175]
["Michael",180]
["Gianna",168]
["Sykes",174]
["Sykes",175]
["Thongtara",129]
["Michelle",107]
["Sarah",138]
["Christina",140]
["Elain",166]
["Yla-Katrina",137]
["Craig",172]
["Richard",119]
["Ewelina",165]
["Mitchell",143]
["Yla-Katrina",139]
["Nelia",190]
["Jason",160]
["Craig",175]
["Gianna",106]
["Ewelina",197]
["Kaur",152]
["Sykes",167]
["Jason",183]
["Denise",140]
["Denise",141]
["Kaur",173]
["Daniel",113]
["Nelia",105]
["Michelle",139]
["Thongtara",199]
["Yla-Katrina",126]
["Richard",200]
["Carol",119]
["Debra",186]
["Mansa",115]
["Denise",103]
["Michael",102]
["Manavbir",196]
["Denise",151]
["Jason",187]
["Richard",168]
["Michael",180]
["Janita",136]
["Manavbir",145]
["Yla-Katrina",141]
["Michelle",160]
["Kaur",166]
["Ewelina",145]
["Shari",131]
["Denise",193]
["Daniel",144]
["Elain",132]
["Janita",114]
["Craig",160]
["Christina",194]
["Shari",129]
["Mitchell",134]
["Manavbir",172]
["Elain",116]
["Debra",112]
["Carol",185]
["Nelia",149]
["Sarah",175]
["Richard",193]
["Manavbir",108]
["Sykes",182]
["Shari",138]
["Michael",112]
["Michael",111]
["Craig",101]
["Daniel",113]
["Jason",123]
["Michelle",137]
["Thongtara",149]
["Shari",117]
["Jason",168]
["Christina",109]
["Elain",107]
["Jason",121]
["Michelle",130]
["Kaur",172]
["Elain",147]
["Sarah",170]
["Christina",161]
["Manavbir",130]
["Michael",118]
["Ewelina",103]
["Daniel",186]
["Michael",189]
["Denise",186]
["Manavbir",110]
["Manavbir",144]
["Shari",146]
["Thongtara",139]
["Carol",157]
["Yla-Katrina",117]
["Carol",135]
["Elain",142]
["Manavbir",127]
["Daniel",123]
["Debra",146]
["Manavbir",141]
["Yla-Katrina",195]
["Elain",160]
["Nelia",128]
["Ewelina",166]
["Debra",194]
["Christina",187]
["Michael",165]
["Thongtara",103]
["Craig",199]
["Sykes",141]
["Christina",112]
["Daniel",163]
["Janita",186]
["Sarah",144]
["Shari",117]
["Ewelina",169]
["Thongtara",185]
["Michelle",131]
["Michael",137]
["Michael",195]
["Janita",128]
["Elain",192]
["Manavbir",184]
["Elain",106]
["Ewelina",152]
["Sykes",149]
["Mitchell",198]
["Carol",142]
["Richard",122]
["Jason",129]
["Richard",134]
["Manavbir",160]
["Craig",117]
["Michael",153]
["Christina",103]
["Mansa",106]
["Jason",156]
["Denise",113]
["Christina",161]
["Elain",158]
["Ewelina",109]
["Jason",132]
["Janita",129]
["Yla-Katrina",112]
["Michael",123]
["Gianna",154]
["Jason",115]
["Michelle",118]
["Carol",116]
["Manavbir",147]
["Mitchell",144]
["Nelia",148]
["Mitchell",195]
["Ewelina",182]
["Ewelina",115]
["Sarah",152]
["Mitchell",111]
["Sykes",142]
["Ewelina",191]
["Yla-Katrina",168]
["Kaur",174]
["Sykes",200]
["Manavbir",181]
["Sykes",183]
["Manavbir",179]
["Sarah",104]
["Jason",150]
["Richard",154]
["Mansa",119]
["Kaur",183]
["Michael",110]
["Yla-Katrina",116]
["Jason",185]
["Elain",123]
["Yla-Katrina",193]
["Debra",126]
["Jason",113]
["Ewelina",114]
["Nelia",157]
["Manavbir",186]
["Thongtara",198]
["Sarah",159]
["Thongtara",148]
["Craig",121]
["Jason",183]
["Mitchell",111]
["Denise",144]
["Manavbir",143]
["Gianna",189]
["Mitchell",173]
["Denise",161]
["Gianna",131]
["Craig",102]
["Manavbir",174]
["Craig",166]
["Mansa",125]
["Jason",140]
["Debra",190]
["Kaur",101]
["Richard",162]
["Denise",114]
["Craig",176]
["Mansa",167]
["Debra",104]
["Michael",191]
["Janita",143]
["Sarah",101]
["Christina",188]
["Manavbir",164]
["Michael",117]
["Nelia",174]
["Yla-Katrina",178]
["Debra",177]
["Sykes",114]
["Yla-Katrina",179]
["Debra",107]
["Michelle",108]
["Denise",151]
["Debra",159]
["Kaur",194]
["Carol",196]
["Christina",114]
["Ewelina",161]
["Elain",168]
["Michelle",125]
["Gianna",143]
["Manavbir",107]
["Thongtara",158]
["Kaur",160]
["Yla-Katrina",167]
["Denise",191]
["Janita",111]
["Richard",152]
["Christina",158]
["Michael",163]
["Elain",181]
["Manavbir",192]
["Janita",124]
["Carol",180]
["Nelia",146]
["Sarah",116]
["Ewelina",144]
["Kaur",196]
["Ewelina",108]
["Michelle",158]
["Christina",179]
["Ewelina",199]
["Sykes",158]
["Mansa",168]
["Nelia",183]
["Janita",176]
["Jason",166]
["Shari",122]
["Daniel",104]
["Debra",140]
["Ewelina",172]
["Christina",112]
["Gianna",133]
["Jason",104]
["Shari",194]
["Thongtara",186]
["Mansa",186]
["Sykes",180]
["Yla-Katrina",153]
["Mansa",117]
["Jason",193]
["Michael",114]
["Denise",189]
["Janita",182]
["Debra",118]
["Debra",160]
["Christina",168]
["Michelle",131]
["Christina",106]
["Denise",181]
["Sarah",182]
["Daniel",189]
["Denise",152]
["Michael",121]
["Jason",189]
["Michael",108]
["Debra",150]
["Sarah",170]
["Yla-Katrina",191]
["Daniel",109]
["Kaur",154]
["Elain",186]
["Michelle",129]
["Michael",149]
["Mitchell",152]
["Mitchell",136]
["Christina",191]
["Michelle",154]
["Denise",191]
["Sykes",131]
["Sykes",109]
["Gianna",199]
["Denise",178]
["Craig",151]
["Thongtara",148]
["Craig",133]
["Yla-Katrina",161]
["Denise",120]
["Elain",161]
["Elain",153]
["Michael",160]
["Sarah",128]
["Craig",104]
["Thongtara",199]
["Janita",111]
["Carol",195]
["Elain",146]
["Daniel",130]
["Mitchell",111]
["Daniel",113]
["Mansa",140]
["Michelle",165]
["Denise",130]
["Shari",114]
["Michael",127]
["Debra",199]
["Janita",117]
["Christina",176]
["Thongtara",193]
["Jason",152]
["Yla-Katrina",152]
["Denise",119]
["Denise",159]
["Carol",104]
["Christina",143]
["Elain",141]
["Kaur",111]
["Daniel",191]
["Nelia",165]
["Jason",157]
["Elain",111]
["Mansa",154]
["Michael",163]
["Nelia",143]
["Mansa",173]
["Christina",151]
["Carol",134]
["Ewelina",145]
["Mansa",192]
["Richard",114]
["Shari",190]
["Janita",156]
["Sarah",198]
["Shari",121]
["Nelia",156]
["Kaur",109]
["Michael",146]
["Nelia",192]
["Manavbir",102]
["Gianna",126]
["Craig",146]
["Manavbir",173]
["Carol",135]
["Ewelina",107]
["Mitchell",123]
["Shari",137]
["Jason",199]
["Yla-Katrina",152]
["Richard",112]
["Shari",160]
["Craig",119]
["Carol",115]
["Richard",182]
["Debra",200]
["Christina",196]

{"sheet":"P(4an)","index":7,"n_rows":770,"n_cols":9,"rows_kept":770,"cut":false,"hidden":true,"merged":[]}
["Create a unique list of SalesRep. Then add a COUNTIFS function that will count how many sales each SalesRep had above $150."]
[]
["SalesRep","Sales",null,"SalesRep","Count",null,"Hurdle",null,"check"]
["Denise",111,null,"Denise",{"$f":"COUNTIFS($A$4:$A$770,D4,$B$4:$B$770,\">\"&G$4)","v":18},null,150,null,{"$f":"SUMPRODUCT(--($A$4:$A$770=D4),--($B$4:$B$770>G$4))","v":18}]
["Thongtara",167,null,"Thongtara",20,null,null,null,{"$f":"SUMPRODUCT(--($A$4:$A$770=D5),--($B$4:$B$770>G$4))","v":20}]
["Sykes",191,null,"Sykes",15,null,null,null,15]
["Ewelina",110,null,"Ewelina",17,null,null,null,17]
["Janita",146,null,"Janita",10,null,null,null,10]
["Elain",177,null,"Elain",16,null,null,null,16]
["Gianna",137,null,"Gianna",9,null,null,null,9]
["Richard",116,null,"Richard",12,null,null,null,12]
["Elain",166,null,"Michael",21,null,null,null,21]
["Michael",193,null,"Michelle",16,null,null,null,16]
["Ewelina",105,null,"Jason",20,null,null,null,20]
["Michelle",189,null,"Craig",15,null,null,null,15]
["Jason",122,null,"Sarah",10,null,null,null,10]
["Craig",196,null,"Mansa",12,null,null,null,12]
["Sarah",161,null,"Shari",9,null,null,null,9]
["Mansa",197,null,"Christina",21,null,null,null,21]
["Michelle",113,null,"Carol",16,null,null,null,16]
["Shari",111,null,"Kaur",21,null,null,null,21]
["Richard",164,null,"Mitchell",10,null,null,null,10]
["Christina",167,null,"Debra",18,null,null,null,18]
["Denise",129,null,"Manavbir",21,null,null,null,21]
["Richard",122,null,"Daniel",15,null,null,null,15]
["Thongtara",132,null,"Yla-Katrina",17,null,null,null,17]
["Michelle",178,null,"Nelia",13,null,null,null,13]
["Michelle",199]
["Shari",181]
["Carol",110]
["Kaur",104]
["Mitchell",110]
["Debra",185]
["Manavbir",183]
["Sykes",143]
["Elain",120]
["Michelle",147]
["Jason",117]
["Mansa",128]
["Shari",110]
["Kaur",158]
["Manavbir",133]
["Debra",190]
["Sarah",138]
["Daniel",143]
["Manavbir",167]
["Thongtara",135]
["Carol",125]
["Janita",107]
["Carol",162]
["Thongtara",192]
["Daniel",152]
["Gianna",155]
["Kaur",155]
["Mansa",145]
["Janita",149]
["Kaur",180]
["Yla-Katrina",190]
["Richard",127]
["Christina",114]
["Carol",191]
["Sykes",197]
["Sykes",186]
["Gianna",174]
["Yla-Katrina",114]
["Jason",121]
["Debra",134]
["Carol",174]
["Craig",178]
["Ewelina",132]
["Sarah",148]
["Michelle",120]
["Thongtara",199]
["Michelle",109]
["Gianna",138]
["Thongtara",153]
["Janita",122]
["Michael",154]
["Jason",174]
["Denise",181]
["Sarah",113]
["Nelia",177]
["Mitchell",138]
["Denise",175]
["Ewelina",149]
["Shari",140]
["Michelle",152]
["Jason",104]
["Daniel",116]
["Sykes",131]
["Thongtara",135]
["Michelle",164]
["Manavbir",178]
["Debra",139]
["Carol",160]
["Ewelina",162]
["Shari",103]
["Kaur",200]
["Mansa",132]
["Sarah",133]
["Mansa",187]
["Michael",173]
["Sykes",112]
["Daniel",132]
["Sykes",112]
["Daniel",131]
["Craig",175]
["Craig",158]
["Ewelina",148]
["Daniel",187]
["Mansa",168]
["Nelia",116]
["Jason",122]
["Debra",160]
["Debra",192]
["Christina",154]
["Jason",145]
["Richard",178]
["Sarah",112]
["Elain",115]
["Mansa",146]
["Debra",109]
["Denise",172]
["Daniel",146]
["Richard",144]
["Mitchell",146]
["Kaur",105]
["Ewelina",134]
["Richard",118]
["Debra",132]
["Carol",117]
["Michelle",194]
["Debra",122]
["Michelle",134]
["Sykes",134]
["Elain",125]
["Carol",115]
["Christina",105]
["Christina",179]
["Elain",114]
["Elain",176]
["Shari",194]
["Mitchell",170]
["Ewelina",144]
["Christina",175]
["Michelle",185]
["Carol",133]
["Sarah",131]
["Mansa",163]
["Denise",120]
["Manavbir",136]
["Gianna",195]
["Yla-Katrina",157]
["Michelle",187]
["Christina",185]
["Jason",154]
["Jason",187]
["Gianna",142]
["Denise",132]
["Mitchell",127]
["Mansa",184]
["Thongtara",164]
["Sykes",157]
["Craig",186]
["Elain",135]
["Janita",194]
["Thongtara",177]
["Mitchell",143]
["Manavbir",152]
["Nelia",101]
["Janita",110]
["Denise",124]
["Christina",102]
["Richard",139]
["Janita",152]
["Janita",168]
["Michael",151]
["Gianna",137]
["Janita",104]
["Nelia",139]
["Daniel",147]
["Mansa",190]
["Nelia",159]
["Manavbir",112]
["Christina",182]
["Richard",121]
["Kaur",181]
["Craig",104]
["Sykes",194]
["Christina",178]
["Carol",142]
["Mitchell",191]
["Sarah",120]
["Carol",155]
["Manavbir",199]
["Thongtara",106]
["Elain",149]
["Michelle",158]
["Gianna",144]
["Daniel",143]
["Daniel",177]
["Manavbir",142]
["Debra",193]
["Michelle",193]
["Mitchell",112]
["Michelle",123]
["Michael",197]
["Thongtara",155]
["Janita",118]
["Denise",169]
["Daniel",172]
["Michael",132]
["Yla-Katrina",154]
["Christina",152]
["Craig",128]
["Thongtara",101]
["Elain",174]
["Denise",124]
["Craig",172]
["Ewelina",165]
["Thongtara",117]
["Mitchell",109]
["Carol",172]
["Sarah",115]
["Shari",125]
["Sykes",113]
["Debra",152]
["Craig",144]
["Denise",153]
["Thongtara",188]
["Mansa",105]
["Sykes",144]
["Daniel",196]
["Denise",145]
["Manavbir",134]
["Carol",196]
["Michael",110]
["Shari",172]
["Michael",174]
["Gianna",109]
["Sarah",181]
["Michael",185]
["Gianna",170]
["Jason",179]
["Mitchell",109]
["Jason",110]
["Craig",137]
["Ewelina",128]
["Carol",183]
["Mitchell",200]
["Denise",114]
["Gianna",144]
["Elain",142]
["Daniel",167]
["Ewelina",169]
["Manavbir",131]
["Denise",113]
["Thongtara",162]
["Carol",152]
["Elain",143]
["Yla-Katrina",171]
["Michael",147]
["Nelia",164]
["Elain",163]
["Christina",148]
["Yla-Katrina",109]
["Daniel",179]
["Elain",130]
["Jason",197]
["Craig",106]
["Janita",145]
["Yla-Katrina",133]
["Elain",195]
["Debra",151]
["Shari",102]
["Kaur",152]
["Yla-Katrina",168]
["Nelia",139]
["Gianna",159]
["Thongtara",142]
["Mitchell",141]
["Jason",114]
["Richard",102]
["Thongtara",119]
["Richard",196]
["Manavbir",164]
["Manavbir",115]
["Daniel",178]
["Richard",153]
["Ewelina",101]
["Thongtara",151]
["Debra",115]
["Debra",170]
["Sarah",112]
["Daniel",163]
["Mitchell",181]
["Sykes",108]
["Daniel",114]
["Carol",119]
["Michelle",168]
["Manavbir",191]
["Debra",152]
["Shari",155]
["Richard",128]
["Elain",185]
["Michelle",164]
["Kaur",130]
["Manavbir",148]
["Manavbir",190]
["Elain",115]
["Manavbir",123]
["Ewelina",168]
["Janita",124]
["Michael",178]
["Ewelina",101]
["Michael",136]
["Janita",174]
["Nelia",156]
["Daniel",131]
["Craig",152]
["Nelia",193]
["Manavbir",165]
["Nelia",158]
["Elain",104]
["Thongtara",186]
["Ewelina",150]
["Thongtara",167]
["Debra",184]
["Carol",121]
["Sykes",184]
["Yla-Katrina",187]
["Sykes",140]
["Carol",129]
["Carol",184]
["Christina",147]
["Jason",182]
["Manavbir",132]
["Sarah",158]
["Daniel",184]
["Christina",107]
["Craig",148]
["Thongtara",132]
["Daniel",127]
["Christina",184]
["Ewelina",172]
["Daniel",147]
["Michael",124]
["Michael",184]
["Shari",196]
["Shari",122]
["Shari",148]
["Debra",136]
["Christina",133]
["Richard",182]
["Michael",167]
["Craig",133]
["Carol",134]
["Debra",142]
["Mitchell",165]
["Kaur",177]
["Jason",107]
["Gianna",139]
["Manavbir",111]
["Sykes",156]
["Kaur",152]
["Mansa",138]
["Michael",162]
["Ewelina",157]
["Ewelina",175]
["Kaur",135]
["Kaur",194]
["Jason",107]
["Craig",108]
["Carol",198]
["Janita",145]
["Mitchell",168]
["Mitchell",137]
["Gianna",145]
["Daniel",178]
["Manavbir",152]
["Sykes",120]
["Nelia",148]
["Kaur",175]
["Christina",131]
["Kaur",172]
["Janita",155]
["Denise",199]
["Craig",187]
["Gianna",127]
["Jason",200]
["Sarah",133]
["Janita",163]
["Manavbir",131]
["Ewelina",125]
["Shari",170]
["Ewelina",150]
["Daniel",126]
["Thongtara",175]
["Michael",180]
["Gianna",168]
["Sykes",174]
["Sykes",175]
["Thongtara",129]
["Michelle",107]
["Sarah",138]
["Christina",140]
["Elain",166]
["Yla-Katrina",137]
["Craig",172]
["Richard",119]
["Ewelina",165]
["Mitchell",143]
["Yla-Katrina",139]
["Nelia",190]
["Jason",160]
["Craig",175]
["Gianna",106]
["Ewelina",197]
["Kaur",152]
["Sykes",167]
["Jason",183]
["Denise",140]
["Denise",141]
["Kaur",173]
["Daniel",113]
["Nelia",105]
["Michelle",139]
["Thongtara",199]
["Yla-Katrina",126]
["Richard",200]
["Carol",119]
["Debra",186]
["Mansa",115]
["Denise",103]
["Michael",102]
["Manavbir",196]
["Denise",151]
["Jason",187]
["Richard",168]
["Michael",180]
["Janita",136]
["Manavbir",145]
["Yla-Katrina",141]
["Michelle",160]
["Kaur",166]
["Ewelina",145]
["Shari",131]
["Denise",193]
["Daniel",144]
["Elain",132]
["Janita",114]
["Craig",160]
["Christina",194]
["Shari",129]
["Mitchell",134]
["Manavbir",172]
["Elain",116]
["Debra",112]
["Carol",185]
["Nelia",149]
["Sarah",175]
["Richard",193]
["Manavbir",108]
["Sykes",182]
["Shari",138]
["Michael",112]
["Michael",111]
["Craig",101]
["Daniel",113]
["Jason",123]
["Michelle",137]
["Thongtara",149]
["Shari",117]
["Jason",168]
["Christina",109]
["Elain",107]
["Jason",121]
["Michelle",130]
["Kaur",172]
["Elain",147]
["Sarah",170]
["Christina",161]
["Manavbir",130]
["Michael",118]
["Ewelina",103]
["Daniel",186]
["Michael",189]
["Denise",186]
["Manavbir",110]
["Manavbir",144]
["Shari",146]
["Thongtara",139]
["Carol",157]
["Yla-Katrina",117]
["Carol",135]
["Elain",142]
["Manavbir",127]
["Daniel",123]
["Debra",146]
["Manavbir",141]
["Yla-Katrina",195]
["Elain",160]
["Nelia",128]
["Ewelina",166]
["Debra",194]
["Christina",187]
["Michael",165]
["Thongtara",103]
["Craig",199]
["Sykes",141]
["Christina",112]
["Daniel",163]
["Janita",186]
["Sarah",144]
["Shari",117]
["Ewelina",169]
["Thongtara",185]
["Michelle",131]
["Michael",137]
["Michael",195]
["Janita",128]
["Elain",192]
["Manavbir",184]
["Elain",106]
["Ewelina",152]
["Sykes",149]
["Mitchell",198]
["Carol",142]
["Richard",122]
["Jason",129]
["Richard",134]
["Manavbir",160]
["Craig",117]
["Michael",153]
["Christina",103]
["Mansa",106]
["Jason",156]
["Denise",113]
["Christina",161]
["Elain",158]
["Ewelina",109]
["Jason",132]
["Janita",129]
["Yla-Katrina",112]
["Michael",123]
["Gianna",154]
["Jason",115]
["Michelle",118]
["Carol",116]
["Manavbir",147]
["Mitchell",144]
["Nelia",148]
["Mitchell",195]
["Ewelina",182]
["Ewelina",115]
["Sarah",152]
["Mitchell",111]
["Sykes",142]
["Ewelina",191]
["Yla-Katrina",168]
["Kaur",174]
["Sykes",200]
["Manavbir",181]
["Sykes",183]
["Manavbir",179]
["Sarah",104]
["Jason",150]
["Richard",154]
["Mansa",119]
["Kaur",183]
["Michael",110]
["Yla-Katrina",116]
["Jason",185]
["Elain",123]
["Yla-Katrina",193]
["Debra",126]
["Jason",113]
["Ewelina",114]
["Nelia",157]
["Manavbir",186]
["Thongtara",198]
["Sarah",159]
["Thongtara",148]
["Craig",121]
["Jason",183]
["Mitchell",111]
["Denise",144]
["Manavbir",143]
["Gianna",189]
["Mitchell",173]
["Denise",161]
["Gianna",131]
["Craig",102]
["Manavbir",174]
["Craig",166]
["Mansa",125]
["Jason",140]
["Debra",190]
["Kaur",101]
["Richard",162]
["Denise",114]
["Craig",176]
["Mansa",167]
["Debra",104]
["Michael",191]
["Janita",143]
["Sarah",101]
["Christina",188]
["Manavbir",164]
["Michael",117]
["Nelia",174]
["Yla-Katrina",178]
["Debra",177]
["Sykes",114]
["Yla-Katrina",179]
["Debra",107]
["Michelle",108]
["Denise",151]
["Debra",159]
["Kaur",194]
["Carol",196]
["Christina",114]
["Ewelina",161]
["Elain",168]
["Michelle",125]
["Gianna",143]
["Manavbir",107]
["Thongtara",158]
["Kaur",160]
["Yla-Katrina",167]
["Denise",191]
["Janita",111]
["Richard",152]
["Christina",158]
["Michael",163]
["Elain",181]
["Manavbir",192]
["Janita",124]
["Carol",180]
["Nelia",146]
["Sarah",116]
["Ewelina",144]
["Kaur",196]
["Ewelina",108]
["Michelle",158]
["Christina",179]
["Ewelina",199]
["Sykes",158]
["Mansa",168]
["Nelia",183]
["Janita",176]
["Jason",166]
["Shari",122]
["Daniel",104]
["Debra",140]
["Ewelina",172]
["Christina",112]
["Gianna",133]
["Jason",104]
["Shari",194]
["Thongtara",186]
["Mansa",186]
["Sykes",180]
["Yla-Katrina",153]
["Mansa",117]
["Jason",193]
["Michael",114]
["Denise",189]
["Janita",182]
["Debra",118]
["Debra",160]
["Christina",168]
["Michelle",131]
["Christina",106]
["Denise",181]
["Sarah",182]
["Daniel",189]
["Denise",152]
["Michael",121]
["Jason",189]
["Michael",108]
["Debra",150]
["Sarah",170]
["Yla-Katrina",191]
["Daniel",109]
["Kaur",154]
["Elain",186]
["Michelle",129]
["Michael",149]
["Mitchell",152]
["Mitchell",136]
["Christina",191]
["Michelle",154]
["Denise",191]
["Sykes",131]
["Sykes",109]
["Gianna",199]
["Denise",178]
["Craig",151]
["Thongtara",148]
["Craig",133]
["Yla-Katrina",161]
["Denise",120]
["Elain",161]
["Elain",153]
["Michael",160]
["Sarah",128]
["Craig",104]
["Thongtara",199]
["Janita",111]
["Carol",195]
["Elain",146]
["Daniel",130]
["Mitchell",111]
["Daniel",113]
["Mansa",140]
["Michelle",165]
["Denise",130]
["Shari",114]
["Michael",127]
["Debra",199]
["Janita",117]
["Christina",176]
["Thongtara",193]
["Jason",152]
["Yla-Katrina",152]
["Denise",119]
["Denise",159]
["Carol",104]
["Christina",143]
["Elain",141]
["Kaur",111]
["Daniel",191]
["Nelia",165]
["Jason",157]
["Elain",111]
["Mansa",154]
["Michael",163]
["Nelia",143]
["Mansa",173]
["Christina",151]
["Carol",134]
["Ewelina",145]
["Mansa",192]
["Richard",114]
["Shari",190]
["Janita",156]
["Sarah",198]
["Shari",121]
["Nelia",156]
["Kaur",109]
["Michael",146]
["Nelia",192]
["Manavbir",102]
["Gianna",126]
["Craig",146]
["Manavbir",173]
["Carol",135]
["Ewelina",107]
["Mitchell",123]
["Shari",137]
["Jason",199]
["Yla-Katrina",152]
["Richard",112]
["Shari",160]
["Craig",119]
["Carol",115]
["Richard",182]
["Debra",200]
["Christina",196]

{"sheet":"P(5)","index":8,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Create a small budget table (sales and expenses) with an assumption area and then save 3 scenarios. Make something up."]
[]
[null,"Jan","Feb","Mar","Apr","May","Jun"]
["Sales",100,200,300,400,500,600]
["Ex1"]
["Ex2"]
["Ex3"]
["Ex4"]
["Ex5"]
["Ex6"]
["Ex7"]
["Ex8"]
["Ex9"]
["Ex10"]
["Ex11"]
["Total Ex"]
["Net Income"]
[]
["Assumptions"]
["Ex1",0.03]
["Ex2",0.04]
["Ex3",0.05]
["Ex4",0.06]
["Ex5",7.0000000000000007E-2]
["Ex6",0.08]
["Ex7",0.09]
["Ex8",0.1]
["Ex9",0.11]
["Ex10",0.12]
["Ex11",0.13]

{"sheet":"P(5an)","index":9,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Create a small budget table (sales and expenses) with an assumption area and then save 3 scenarios. Make something up."]
[]
[null,"Jan","Feb","Mar","Apr","May","Jun"]
["Sales",100,200,300,400,500,600]
["Ex1",{"$f":"B$4*$B20","v":0.5},{"$f":"C$4*$B20","v":1},{"$f":"D$4*$B20","v":1.5},{"$f":"E$4*$B20","v":2},{"$f":"F$4*$B20","v":2.5},{"$f":"G$4*$B20","v":3}]
["Ex2",{"$f":"B$4*$B21","v":1},{"$f":"C$4*$B21","v":2},{"$f":"D$4*$B21","v":3},{"$f":"E$4*$B21","v":4},{"$f":"F$4*$B21","v":5},{"$f":"G$4*$B21","v":6}]
["Ex3",{"$f":"B$4*$B22","v":1.5},{"$f":"C$4*$B22","v":3},{"$f":"D$4*$B22","v":4.5},{"$f":"E$4*$B22","v":6},{"$f":"F$4*$B22","v":7.5},{"$f":"G$4*$B22","v":9}]
["Ex4",{"$f":"B$4*$B23","v":2},{"$f":"C$4*$B23","v":4},{"$f":"D$4*$B23","v":6},{"$f":"E$4*$B23","v":8},{"$f":"F$4*$B23","v":10},{"$f":"G$4*$B23","v":12}]
["Ex5",{"$f":"B$4*$B24","v":2.5},{"$f":"C$4*$B24","v":5},{"$f":"D$4*$B24","v":7.5},{"$f":"E$4*$B24","v":10},{"$f":"F$4*$B24","v":12.5},{"$f":"G$4*$B24","v":15}]
["Ex6",{"$f":"B$4*$B25","v":3},{"$f":"C$4*$B25","v":6},{"$f":"D$4*$B25","v":9},{"$f":"E$4*$B25","v":12},{"$f":"F$4*$B25","v":15},{"$f":"G$4*$B25","v":18}]
["Ex7",{"$f":"B$4*$B26","v":3.5000000000000004},{"$f":"C$4*$B26","v":7.0000000000000009},{"$f":"D$4*$B26","v":10.500000000000002},{"$f":"E$4*$B26","v":14.000000000000002},{"$f":"F$4*$B26","v":17.5},{"$f":"G$4*$B26","v":21.000000000000004}]
["Ex8",{"$f":"B$4*$B27","v":4},{"$f":"C$4*$B27","v":8},{"$f":"D$4*$B27","v":12},{"$f":"E$4*$B27","v":16},{"$f":"F$4*$B27","v":20},{"$f":"G$4*$B27","v":24}]
["Ex9",{"$f":"B$4*$B28","v":4.5},{"$f":"C$4*$B28","v":9},{"$f":"D$4*$B28","v":13.5},{"$f":"E$4*$B28","v":18},{"$f":"F$4*$B28","v":22.5},{"$f":"G$4*$B28","v":27}]
["Ex10",{"$f":"B$4*$B29","v":5},{"$f":"C$4*$B29","v":10},{"$f":"D$4*$B29","v":15},{"$f":"E$4*$B29","v":20},{"$f":"F$4*$B29","v":25},{"$f":"G$4*$B29","v":30}]
["Ex11",{"$f":"B$4*$B30","v":5.5},{"$f":"C$4*$B30","v":11},{"$f":"D$4*$B30","v":16.5},{"$f":"E$4*$B30","v":22},{"$f":"F$4*$B30","v":27.5},{"$f":"G$4*$B30","v":33}]
["Total Ex",{"$f":"SUM(B5:B15)","v":33},66,99,132,165,198]
["Net Income",{"$f":"B4-B16","v":67},134,201,268,335,402]
[]
["Assumptions"]
["Ex1",5.0000000000000001E-3]
["Ex2",0.01]
["Ex3",1.4999999999999999E-2]
["Ex4",0.02]
["Ex5",2.5000000000000001E-2]
["Ex6",0.03]
["Ex7",3.5000000000000003E-2]
["Ex8",0.04]
["Ex9",4.4999999999999998E-2]
["Ex10",0.05]
["Ex11",5.5E-2]