{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Score","Initial-Instructions","P(1)","P(2)","P(3)","P(4)","P(5)","P(6)","P(7)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Score","index":0,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Problem","Description","Possible Points","Earned Points","Note"]
[null,"1)","Did you create: Did you create 1) Single Condition Logical Test: B18: =E11>C18?",{"$f":"100/ROWS($C$3:$C$47)","v":2.2222222222222223},{"$f":"D3","v":2.2222222222222223}]
[null,null,"Did you create: Did you create 2) Contains Logical Test: B22: =COUNTIFS(C11:C14,C22)?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create 2) Contains Logical Test: B23: =COUNTIFS(C11:C14,\"*\"&C23&\"*\")?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create 3) NOT Logical Test: B27: =AVERAGEIFS(F11:F14,D11:D14,\"<>\"&C27)?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create 4) AND Logical Test B31: =AND(E12>=C31,F12>D31)?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create 4) AND Logical Test in COUNTIFS B35: =COUNTIFS(D11:D14,C35,F11:F14,D35)?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create 5) BETWEEN Logical Test F18: =FILTER(B11:B14,(E11:E14>=G18)*(E11:E14<=H18))?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create 6) OR Logical Test F23: =SUM(COUNTIFS(D11:D14,G23:H23))?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create 7) Is Item In List? Logical Test F27: =ISNUMBER(XMATCH(G27,D11:D14))?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create 8) Complex Logical Test F31: =FILTER(B11:B14,(D11:D14=G31)*(E11:E14>=G34)+(D11:D14=G32)*(E11:E14>=G34))?",2.2222222222222223,2.2222222222222223]
[null,null,"Other 1",2.2222222222222223,2.2222222222222223]
[null,null,"Other 2",2.2222222222222223,2.2222222222222223]
[null,2,"Did you create: Did you create Formula in cell F18: =FILTER(D18:D29,ISNUMBER(XMATCH(D18:D29,B18:B36)))?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create Conditional formatting Logical Formula for range F12:F23: =F12<>\"\"?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create Formula in cell H18: =FILTER(D18:D29,ISNA(XMATCH(D18:D29,B18:B36)))?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Did you create Conditional formatting Logical Formula for range H12:H23: =NOT(ISBLANK(H12))?",2.2222222222222223,2.2222222222222223]
[null,3,"Did you create: PivotTable Solution?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: PivotTable have good labels??",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: PivotTable indicate units??",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Worksheet Formula Solution?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Formula: =SORT(UNIQUE(CustomerSales[Product]))?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Formula: =AVERAGEIFS(CustomerSales[Sales($)],CustomerSales[Product],F17#)?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Formula: =AVERAGE(CustomerSales[Sales($)])?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Power Query Solution?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Power Query have good labels??",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Power Query indicate units??",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create: Power Query Total Row Formula: =AVERAGE(CustomerSales[Sales($)])?",2.2222222222222223,2.2222222222222223]
[null,4,"Did you create a Data Validation dropdown list to cell B11 based on the E-mails in the range F16:F22?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create a formula to lookup Employee ID based on the e-mail?",2.2222222222222223,2.2222222222222223]
[null,null,"Something like: =XLOOKUP(B11,F16:F22,B16:B22)",2.2222222222222223,2.2222222222222223]
[null,5,"Did you create a Data Validation dropdown list to cell B10 based on the Employee IDs in the range B15:B21?",2.2222222222222223,2.2222222222222223]
[null,null,"Did you create a formula to lookup the full record for the Employee ID selected?",2.2222222222222223,2.2222222222222223]
[null,null,"Something like: =XLOOKUP(B10,B15:B21,C15:H21)",2.2222222222222223,2.2222222222222223]
[null,6,"Did you create a  formula lookup the letter grade for Gigi?",2.2222222222222223,2.2222222222222223]
[null,null,"Something like: =XLOOKUP(C9,B18:B22,C18:C22,\"F\",-1)",2.2222222222222223,2.2222222222222223]
[null,null,"Something like: =LOOKUP(C9,F18:G22)",2.2222222222222223,2.2222222222222223]
[null,7,"1) Use Exact Match lookup to lookup product price in cell I15.",2.2222222222222223,2.2222222222222223]
[null,null,"Something like: =XLOOKUP(I14,B21:B24,C21:C24)",2.2222222222222223,2.2222222222222223]
[null,null,"2) Calculate the Amount Before Discount (Units * Price) in cell I17.",2.2222222222222223,2.2222222222222223]
[null,null,"3) Use Two Way Lookup to lookup the discount based on number of units purchased in cell I18.",2.2222222222222223,2.2222222222222223]
[null,null,"Something like: =XLOOKUP(I14,C13:F13,XLOOKUP(I16,B14:B18,C14:F18,,-1))",2.2222222222222223,2.2222222222222223]
[null,null,"4) Calculate the Amount of Discount (Amount Before Discount * Discount %) in cell I19.",2.2222222222222223,2.2222222222222223]
[null,null,"Did you use ROUND on Discount Amount Calculation, like: =ROUND(I17*I18,2).\nAll Requirements for using ROUND were met.",2.2222222222222223,2.2222222222222223]
[null,null,"5) Calculate the Amount to Pay (Amount Before Discount - Amount of Discount) in cell I20.",2.2222222222222223,2.2222222222222223]
[null,null,"Other",2.2222222222222223,2.2222222222222223]
[null,null,"Total Possible Points",{"$f":"SUM(D3:D47)","v":100.00000000000009}]
[null,null,"Is Test Submitted Past due date-time?","No",{"$f":"IF(D49=\"Yes\",-0.25*SUM(E3:E47),\"\")","v":""},{"$f":"IF(D49=\"Yes\",\"Deduction for late test\",\"\")","v":""}]
[null,null,null,"Your Earned Test Score:",{"$f":"SUM(E3:E49)","v":100.00000000000009}]
[]
[]
[null,"Be sure to scroll up to see whole score sheet.",null,null,null,"fall 2022"]

{"sheet":"Initial-Instructions","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["* This test covers everything in class up to MECS class video #8"]
[null,"Test Instructions:"]
["1)","You must rename each test file so that the file name contains your name."]
[null,"For example, if your name is “Sioux Noline” and the test file has the name “Busn218Fall2022Test07.xlsm\","]
[null,"you MUST rename the file to become: “SiouxNoline Busn218Fall2022Test07.xlsm”."]
[null,"Tests that do not follow this naming rule are scored as zero."]
["2)","The Excel test file MUST use the file extension \".xlsm\". Tests that do not follow this rule are scored as zero."]
["3)","This test has 7 problem on the worksheets with the name \"P(1)to \"P(7)\"."]
["4)","Late tests without a documentable emergency are assessed as a 25% deduction."]
[null,"You can hand in tests late if a documentable emergency occurs, like documented deaths or medical emergencies."]
[5,"The test scores earned will count toward your grade for the class."]
[]
["If you have questions you can e-mail me at mgirvin@highline.edu"]
[null,null,null,null,null,"Fall, 2022 File"]

{"sheet":"P(1)","index":2,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal:","In the green cells below, create worksheet formulas for each of the 8 different logical tests based on the small table of data in the range B10:F14."]
[null,null,"For #2, create two different formulas, one each for the different types of conditions."]
[null,"Hints:","MECS video #7 at the 04:30 minute mark discusses the concepts of these logical tests."]
[null,null,"The worksheet \"8LT(an)\" in the MECS video #7 workbook shows exactly how to create these 8 formulas."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or e-mail Michael Girvin at mgirvin@highline.edu with questions."]
[]
[null,"Student","Address","Major","Credits","GPA"]
[null,"Nga, Luong","102 San Pablo Ave.","Physics",45,3.4]
[null,"Robinson, Chantel","5834 Birch St.","History",70,4]
[null,"Rouse, Sioux","16 San Pablo Ave.","Chemistry",40,3.4]
[null,"Simone, Alanna","10233 1st Ave. S.","Physics",60,3.5]
[]
[null,"1) Single Condition Logical Test:",null,null,null,"5) BETWEEN Logical Test"]
[null,{"$f":"B11&\"'s \"&C17&\" > \"&C18&\"?\"","v":"Nga, Luong's Credits > 60?"},{"$f":"E10","v":"Credits"},null,null,{"$f":"\"List \"&B10&\" names who have \"&E10&\" >= \"&G18&\" AND <= \"&H18&\":\"","v":"List Student names who have Credits >= 25 AND <= 50:"},"Lower\nLimit","Upper Limit"]
[null,null,60,null,null,null,25,50]
[]
[null,"2) Contains Logical Test:"]
[null,{"$f":"\"Number of \"&C10&\" that contain '\"&C23&\"'?\"","v":"Number of Address that contain 'San Pablo'?"},{"$f":"C10&\" contains?\"","v":"Address contains?"},null,null,"6) OR Logical Test"]
[null,null,"*San Pablo*",null,null,{"$f":"\"COUNT Majors that are \"&G23&\" OR \"&H23&\":\"","v":"COUNT Majors that are Physics OR History:"},{"$f":"$D$10","v":"Major"},{"$f":"$D$10","v":"Major"}]
[null,null,"San Pablo",null,null,null,"Physics","History"]
[]
[null,"3) NOT Logical Test:",null,null,null,"7) Is Item In List? Logical Test"]
[null,{"$f":"\"Average \"&F10&\" for Majors not '\"&C27&\"'?\"","v":"Average GPA for Majors not 'Physics'?"},{"$f":"D10&\" NOT:\"","v":"Major NOT:"},null,null,{"$f":"\"Is the \"&D10&\" '\"&G27&\"' in \"&D10&\" field?\"","v":"Is the Major 'Data Analysis' in Major field?"},{"$f":"D10","v":"Major"}]
[null,null,"Physics",null,null,null,"Data Analysis"]
[]
[null,"4) AND Logical Test",null,null,null,"8) Complex Logical Test"]
[null,{"$f":"B12&\"'s \"&C30&\" >= \"&C31&\" AND \"&D30&\" > \"&D31&\"?\"","v":"Robinson, Chantel's Credits >= 60 AND GPA > 3.5?"},{"$f":"E10","v":"Credits"},"GPA",null,{"$f":"\"List names for \"&E10&\" >=\"&G34&\" for \"&D10&\"s \"&G31&\" OR \"&G32","v":"List names for Credits >=50 for Majors Physics OR History"},"Majors?"]
[null,null,60,3.5,null,null,"Physics"]
[null,null,null,null,null,null,"History"]
[null,"4) AND Logical Test in COUNTIFS",null,null,null,null,"Credits?"]
[null,{"$f":"\"Count \"&D34&\" >= \"&D35&\" AND \"&LOWER(C34)&\" = \"&C35","v":"Count GPA >= >=3.4 AND major = Physics"},"Major","GPA",null,null,50]
[null,null,"Physics",">=3.4"]

{"sheet":"P(2)","index":3,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goals:"]
[null,{"$f":"\"In cell \"&ADDRESS(ROW(F18),COLUMN(F18),4)&\" spill prospective customer names that made it into our master list.\"","v":"In cell F18 spill prospective customer names that made it into our master list."}]
[null,{"$f":"\"In cell \"&ADDRESS(ROW(H18),COLUMN(H18),4)&\" spill prospective customer names that did NOT make it into our master list (and we still need to contact them).\"","v":"In cell H18 spill prospective customer names that did NOT make it into our master list (and we still need to contact them)."}]
[null,"Add conditional formatting to both spilled lists that adds a border and green fill for cells that have a spilled value."]
[null,"Hints:"]
[null,"This is similar to homework problem #4 in for MECS video #7."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or e-mail Michael Girvin at mgirvin@highline.edu with questions."]
[]
[]
[null,"List 1 = Master List.",null,"List 2 = Customers we have made sales calls to."]
[]
[null,"Master Customer List",null,"Prospective Customers"]
[]
[null,"List 1",null,"List 2",null,"Items in List 2 that are in List 1",null,"Items in List 2 that are in NOT in List 1"]
[null,"Fran's  Produce",null,"Produce Fast And Fresh"]
[null,"Produce Fast And Fresh",null,"Healthy Garden Produce"]
[null,"Veggies And Fruit Delight",null,"Veggies And Fruit Delight"]
[null,"Fruit & Veggie Delights",null,"Best For U"]
[null,"Clean & Neat  Produce",null,"Julie's Produce"]
[null,"Julie's Produce",null,"Fruit & Veggie Inc."]
[null,"Fruits And Nuts R Us",null,"Health Choice Fruit"]
[null,"Table Ready Produce",null,"Fresh Delights"]
[null,"Freshy Produce",null,"CA Produce"]
[null,"Veggie Are THE Way",null,"Gigi'S Produce"]
[null,"Greens Delight",null,"Delight & Health"]
[null,"Garden Fresh",null,"Garden Health"]
[null,"Garden Ready"]
[null,"Best Garden Produce"]
[null,"Fresh Produce Inc."]
[null,"Fresh Delights"]
[null,"Down To Earth"]
[null,"Fruit & Veggie Health"]
[null,"Garden Fresh Produce"]

{"sheet":"P(3)","index":4,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goals: Calculate average Sales by Product with a PivotTable, Worksheet Formulas and Power Query."]
[null,"Hint: This is like the Single Condition Logical Test section of MECS videop #7 at the 22:34 minute mark."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or e-mail Michael Girvin at mgirvin@highline.edu with questions."]
[]
[]
[null,"Customer","Product","Sales($)"]
[null,"Carey, Zada","Quad",45]
[null,"Emmons, Christi","Sunset",135]
[null,"Lear, Vania","Aspen",45]
[null,"Meador, Corazon","Quad",90]
[null,"Mohamed, Abdi","Aspen",23]
[null,"Nga, Luong","Aspen",45]
[null,"Robinson, Chantel","Quad",70]
[null,"Rouse, Sioux","Sunset",40]
[null,"Simone, Alanna","Sunset",60]
[null,"Thornburg, Tyrone","Quad",75]

{"sheet":"P(4)","index":5,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goals: Add a Data Validation dropdown list to cell B11 based on the E-mails in the range F16:F22."]
[null,"In cell C13, create a formula to lookup Employee ID based on the e-mail in cell B11."]
[null,"Hint in MECS video #8 at the 02:04 minute mark (Exact Math Lookup) and 04:00 minute mark (Data Validation)."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or e-mail Michael Girvin at mgirvin@highline.edu with questions."]
[]
[]
[null,{"$f":"F15","v":"E-mail"}]
[null,"PK15@gb.com"]
[]
[null,"Employee ID:"]
[]
[null,"Employee ID","First","Last","Start Date","E-mail","Start Position","BirthDate"]
[null,{"$f":"\"880-245-\"&ROWS(B$16:B16)+3399","v":"880-245-3400"},"Jo","Jones","2010-11-22",{"$f":"LEFT(C16)&LEFT(D16)&RIGHT(YEAR(E16),2)&\"@gb.com\"","v":"JJ10@gb.com"},"C1","1990-11-27"]
[null,{"$f":"\"880-245-\"&ROWS(B$16:B17)+3399","v":"880-245-3401"},"Mo","Abdi","2014-10-31",{"$f":"LEFT(C17)&LEFT(D17)&RIGHT(YEAR(E17),2)&\"@gb.com\"","v":"MA14@gb.com"},"A1","1983-11-08"]
[null,{"$f":"\"880-245-\"&ROWS(B$16:B18)+3399","v":"880-245-3402"},"Phil","Kips","2015-12-23","PK15@gb.com","A1","1986-12-30"]
[null,{"$f":"\"880-245-\"&ROWS(B$16:B19)+3399","v":"880-245-3403"},"Ty","Mimms","2016-01-31","TM16@gb.com","C1","1989-02-06"]
[null,{"$f":"\"880-245-\"&ROWS(B$16:B20)+3399","v":"880-245-3404"},"Lin","Chinn","2016-02-01","LC16@gb.com","D1","1963-02-09"]
[null,{"$f":"\"880-245-\"&ROWS(B$16:B21)+3399","v":"880-245-3405"},"Hien","Pham","2017-08-24","HP17@gb.com","A1","1978-09-03"]
[null,{"$f":"\"880-245-\"&ROWS(B$16:B22)+3399","v":"880-245-3406"},"Sam","Fix","2018-08-09","SF18@gb.com","D2","1997-08-14"]

{"sheet":"P(5)","index":6,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goals: Add a Data Validation dropdown list to cell B10 based on the Employee IDs in the range B15:B21."]
[null,"In cell C12, create a formula to lookup the full record for the Employee ID selected in cell B10."]
[null,"Hint in MECS video #8 at the 07:19 minute mark (Lookup Record)."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or e-mail Michael Girvin at mgirvin@highline.edu with questions."]
[]
[null,"Employee ID"]
[null,"880-245-3404"]
[]
[null,"Lookup Record:"]
[]
[null,"Employee ID","First","Last","Start Date","E-mail","Start Position","BirthDate"]
[null,{"$f":"\"880-245-\"&ROWS(B$15:B15)+3399","v":"880-245-3400"},"Jo","Jones","2010-11-22",{"$f":"LEFT(C15)&LEFT(D15)&RIGHT(YEAR(E15),2)&\"@gb.com\"","v":"JJ10@gb.com"},"C1","1990-11-27"]
[null,{"$f":"\"880-245-\"&ROWS(B$15:B16)+3399","v":"880-245-3401"},"Mo","Abdi","2014-10-31",{"$f":"LEFT(C16)&LEFT(D16)&RIGHT(YEAR(E16),2)&\"@gb.com\"","v":"MA14@gb.com"},"A1","1983-11-08"]
[null,{"$f":"\"880-245-\"&ROWS(B$15:B17)+3399","v":"880-245-3402"},"Phil","Kips","2015-12-23","PK15@gb.com","A1","1986-12-30"]
[null,{"$f":"\"880-245-\"&ROWS(B$15:B18)+3399","v":"880-245-3403"},"Ty","Mimms","2016-01-31","TM16@gb.com","C1","1989-02-06"]
[null,{"$f":"\"880-245-\"&ROWS(B$15:B19)+3399","v":"880-245-3404"},"Lin","Chinn","2016-02-01","LC16@gb.com","D1","1963-02-09"]
[null,{"$f":"\"880-245-\"&ROWS(B$15:B20)+3399","v":"880-245-3405"},"Hien","Pham","2017-08-24","HP17@gb.com","A1","1978-09-03"]
[null,{"$f":"\"880-245-\"&ROWS(B$15:B21)+3399","v":"880-245-3406"},"Sam","Fix","2018-08-09","SF18@gb.com","D2","1997-08-14"]

{"sheet":"P(6)","index":7,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal: Using a formula lookup the letter grade for Gigi in cell C10."]
[null,"Hint in MECS video #8 at the 14:24 minute mark (Exact Math or Next Smaller Lookup (Also known as Approximate Match Lookup))."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or e-mail Michael Girvin at mgirvin@highline.edu with questions."]
[]
[null,"Student:","Gigi"]
[null,"% Grade:",0.43]
[null,"Letter Grade:"]
[]
[]
[]
[]
[null,"Vertical Lookup Table:"]
[]
[null,"% Grade","Letter Grade"]
[null,0.48,"F"]
[null,0.62,"D"]
[null,0.72,"C"]
[null,0.85,"B"]
[null,0.94,"A"]

{"sheet":"P(7)","index":8,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal: Calculate the amount that the customer must pay based on looking up the product price (Exact Match Lookup) and looking up the Discount (Two Way Lookup)"]
[null,"Hint in MECS video #8 at the 29:06 minute mark (Two Way Lookup)"]
[null,"You can solve it this way:"]
[null,"1) Use Exact Match lookup to lookup product price in cell I15."]
[null,"2) Calculate the Amount Before Discount (Units * Price) in cell I17."]
[null,"3) Use Two Way Lookup to lookup the discount based on number of units purchased in cell I18."]
[null,"4) Calculate the Amount of Discount (Amount Before Discount * Discount %) in cell I19."]
[null,"5) Calculate the Amount to Pay (Amount Before Discount - Amount of Discount) in cell I20."]
[null,"Do not copy and paste work previously done. Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or e-mail Michael Girvin at mgirvin@highline.edu with questions."]
[]
[null,"Units/Product","Quad","Aspen","Sunshine","Yanaki",null,"Customer:","Jill Franks"]
[null,0,0,0,0,0,null,"Product Purchased","Sunshine"]
[null,12,0.1,0.15,0.1275,0.1,null,"Product Price"]
[null,44,0.375,0.4,0.22750000000000001,0.2,null,"Units Purchased",55]
[null,96,0.44,0.5,0.42,0.4,null,"Amount Before Discount"]
[null,256,0.5,0.55000000000000004,0.52,0.5,null,"Discount %"]
[null,null,null,null,null,null,null,"Amount of Discount"]
[null,"Product","Price",null,null,null,null,"Amount to Pay:"]
[null,"Quad",43.95,null,null,null,null,"Check:"]
[null,"Aspen",27.95]
[null,"Sunshine",19.95]
[null,"Yanaki",24.5]