{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Score","Initial-Instructions","P(1)","P(2)","P(3)","P(4)"],"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":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Problem","Description","Possible Points","Earned Points","Note"]
[null,"1)","Check list for building model:",{"$f":"100/ROWS($C$3:$C$48)","v":2.1739130434782608},{"$f":"D3","v":2.1739130434782608}]
[null,null,"Excel's Golden Rule: List all formula elements in cells with label?",2.1739130434782608,2.1739130434782608]
[null,null,"Style Formatting: is it easy to read and understand?",2.1739130434782608,2.1739130434782608]
[null,null,"Is Number Formatting interfering with our solution, or helping?",2.1739130434782608,2.1739130434782608]
[null,null,"Document model?",2.1739130434782608,2.1739130434782608]
[null,null,"Use ROUND function if necessary?",2.1739130434782608,2.1739130434782608]
[null,null,"Keep default alignments?",2.1739130434782608,2.1739130434782608]
[null,null,"Building Model:",2.1739130434782608,2.1739130434782608]
[null,null,"List all month labels for Sales",2.1739130434782608,2.1739130434782608]
[null,null,"Enter formula inputs for Sales amounts",2.1739130434782608,2.1739130434782608]
[null,null,"List all Expense labels for Sales",2.1739130434782608,2.1739130434782608]
[null,null,"Enter formula inputs for Expense Percentages amounts",2.1739130434782608,2.1739130434782608]
[null,null,"Create Dynamic Spilled Array Formula for Expense Amounts, like: =ROUND(C32:N32*C17:C26,2)",2.1739130434782608,2.1739130434782608]
[null,null,"Create Totals Rows using SUM function",2.1739130434782608,2.1739130434782608]
[null,null,"Add Expenses with SUM function without including Sales Amounts",2.1739130434782608,2.1739130434782608]
[null,null,"Create Dynamic Spilled Array Formula for  Net Income Formula like: =C32:O32-C43:O43",2.1739130434782608,2.1739130434782608]
[null,null,null,2.1739130434782608,2.1739130434782608]
[null,null,null,2.1739130434782608,2.1739130434782608]
[null,"2)","Did you create the Single Input-Output Formulas: D19: =ROUND(B19*$D$16,2)?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you create the SUM: D24: =SUM(D19:D23)?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you use the ROUND function for the Single Input-Output Formulas?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you create the Dynamic Spilled Array Formulas: H19: =ROUND(F19:F23*H16,2)?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you create the SUM: H24: =SUM(H19#)?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you use the ROUND function for the Dynamic Spilled Array Formulas?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you create the Excel Table Formulas: L19: =ROUND([@Sales]*$L$16,2)?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you create the SUM: L24: =SUBTOTAL(109,[Commission Paid ($)])?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you use the ROUND function for the Excel Table Formulas?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you document the formulas you used in the cells below the commission paid calculations?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you write about which formula you like most and why you like it most?",2.1739130434782608,2.1739130434782608,"Example of answer to this question:","I like Single Input-Output Formulas is I have to send a workbook file to someone who does not have the ability to spill results and will not need to add new data later. I like Dynamic Spilled Array Formulas when I have the Excel version Microsoft 365 and I do not need to add new data later. I like them because they are faster and easier to create than in older versions of Excel. I don't need to lock references, I don't need to manually copy the formula and Editing is only done in one cell and you don't need to re copy. I like Table Formulas when I have a table of data and I will add new data later. This is because the Excel Table feature will update table formulas in columns, other formulas and all other tools that are pointing to them."]
[null,null,"Did you write about when you would use a Single Input-Output Formula?",2.1739130434782608,2.1739130434782608,"Example of answer to this question:","Use Single Input-Output Formulas when you have to send a workbook file to someone who does not have the ability to spill results and will not need to add new data later."]
[null,null,"Did you write about when you would use a Dynamic Spilled Array Formula?",2.1739130434782608,2.1739130434782608,"Example of answer to this question:","Use Dynamic Spilled Array Formulas when you have the Excel version Microsoft 365 and I do not need to add new data later. They are faster and easier to create than in older versions of Excel. You don't need to lock references,  don't need to manually copy the formula and Editing is only done in one cell and you don't need to re copy."]
[null,null,"Did you write about when you would use a Excel Table Formula?",2.1739130434782608,2.1739130434782608,"Example of answer to this question:","You use Table Formulas when you have a table of data and will add new data later. This is because the Excel Table feature will update table formulas in columns, other formulas and all other tools that are pointing to them."]
[null,"3)","Did you create report column headers such as: Products, Total Sales ($)",2.1739130434782608,{"$f":"D35","v":2.1739130434782608}]
[null,null,"Did you create sorted unique list with  a formula like: =SORT(UNIQUE(Homework04TableAnswer[Product]))",2.1739130434782608,2.1739130434782608]
[null,null,"Did you use SORT function?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you use UNIQUE function?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you create sorted unique list with  a formula like: =SUMIFS(Homework04TableAnswer[Sales ($)],Homework04TableAnswer[Product],G9#)",2.1739130434782608,2.1739130434782608]
[null,null,"Did you use SUMIFS function?",2.1739130434782608,2.1739130434782608]
[null,null,"Did you use # (Spilled Range Operator) to get criteria that is spilled from the top cell in the unique list?",2.1739130434782608,2.1739130434782608]
[null,"4)","Create formula to calculate the number of days between two dates is: Later Date - Earlier Date.",2.1739130434782608,2.1739130434782608]
[null,null,"Create a Dynamic Spilled Array Formulas to calculate the number of days between two dates, like: =F9:F18-E9:E18",2.1739130434782608,2.1739130434782608]
[null,null,"Did you use the Single Input-Output Formula by mistake?",2.1739130434782608,2.1739130434782608]
[null,null,"Other 1",2.1739130434782608,2.1739130434782608]
[null,null,"Other 2",2.1739130434782608,2.1739130434782608]
[null,null,"Other 3",2.1739130434782608,2.1739130434782608]
[null,null,"Was your name in the test file name?",2.1739130434782608,2.1739130434782608]
[null,null,"Total Possible Points",{"$f":"SUM(D3:D48)","v":100.00000000000004}]
[null,null,"Is Test Submitted Past due date-time?","No",{"$f":"IF(D50=\"Yes\",-0.25*SUM(E3:E48),\"\")","v":""},{"$f":"IF(D50=\"Yes\",\"Deduction for late test\",\"\")","v":""}]
[null,null,null,"Your Earned Test Score:",{"$f":"SUM(E3:E50)","v":100.00000000000004}]
[]
[]
[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 video #3"]
[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 “Busn218Fall2022Test03.xlsm\","]
[null,"you MUST rename the file to become: “SiouxNoline Busn218Fall2022Test03.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 four problems on the worksheets with the names \"P(1)\", \"P(2)\", \"P(3)\" and \"P(4)\"."]
["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 contact Michael Girvin: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[null,null,null,null,null,"Fall, 2022 File"]

{"sheet":"P(1)","index":2,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"You are required to make a sales and expense budget. The estimated sales for a 12 month period are:"]
[null,"Jan = 5,200, Feb = 6,950, Mar = 7,900, Apr = 10,100, May = 17,650, Jun = 17,650"]
[null,"Jul = 19,250, Aug = 15,650, Sep = 15,750, Oct = 31,050, Nov = 32,400, Dec = 52,200"]
[null,"The expenses as a percentage of sales are as follows:"]
[null,"COGS = 37.50%, Salaries and Wages = 13.50%, Rent  = 10.50%, Supplies  = 1.50%, Depreciation  = 4.75%, Utilities = 3.50%"]
[null,"Advertising = 3.75%, Administration  = 2.50%, Interest  = 2.50%, Tax  = 8.75%"]
[null,"Use the example #1 model building example in MECS video #1 as a guide to solving this test problem. The minute mark that shows one way to solve this problem is: 48:00. Link here:",null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.youtube.com/watch?v=AUYagm4ZA7M&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=7&t=2280s"]
[null,"Be sure to follow Excel's Golden Rule and build an Excel Model to solve this problem.",null,null,null,null,null,null,null,null,null,null,null,null,"MECS03"]
[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 contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]

{"sheet":"P(2)","index":3,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[32,1,32,11],[33,1,33,11],[34,1,34,11],[35,1,35,11]]}
[]
[null,"In this problem you are going to make a formula calculation in three different ways and they write about which one you like most and why you like it most."]
[null,"As listed below, the three types of formulas you are required to create are: Single Input-Output Formula, Dynamic Spilled Array Formula, Excel Table Formula."]
[null,"MECS video #3 shows how to create formulas like these at the 38:00 minute mark. Video link is to right =>",null,null,null,null,null,"MECS03",null,null,null,"https://www.youtube.com/watch?v=AUYagm4ZA7M&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=7&t=455s"]
[null,"The formula calculation you are going to make is: Sales*Commission Rate = Commission Paid. "]
[null,{"$f":"\"For example, if the sales representative, \"&C25&\", made \"&DOLLAR(B25)&\" in sales to customers, her commission pay would be calculated this way: \"&DOLLAR(B25)&\"*\"&TEXT(D22,\"0.00%\")&\" = \"&DOLLAR(ROUND(B25*D22,2))&\".\"","v":"For example, if the sales representative, Shayla, made $57,439.95 in sales to customers, her commission pay would be calculated this way: $57,439.95*2.75% = $1,579.60."}]
[null,"You must think about whether or not the ROUND function is required here. If it is, you must use it. If it is not, do not use it."]
[null,"Create the Single Input-Output Formula in cell D25 and then add all the commission paid amounts in cell D30."]
[null,"Create the Dynamic Spilled Array Formula in cell H25 and then add all the commission paid amounts in cell H30."]
[null,"Create the Single Input-Output Formula in cell L25 and then add all the commission paid amounts in cell L30."]
[null,"Document the formulas you used in the cells below the commission paid calculations."]
[null,"In the yellow cells below (starting in cell B35), write about which formula you like most and why you like it most. This section is listed as \"a\"."]
[null,"In the yellow cells below (starting in cell B36), write about when you would use a Single Input-Output Formula. This section is listed as \"b\"."]
[null,"In the yellow cells below (starting in cell B37), write about when you would use a Dynamic Spilled Array Formula. This section is listed as \"c\"."]
[null,"In the yellow cells below (starting in cell B38), write about when you would use a Excel Table Formula. This section is listed as \"d\"."]
[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 contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[]
[null,"2) Single Input-Output Formulas",null,null,null,"3) Dynamic Spilled Array Formulas",null,null,null,"5) Excel Table Formulas"]
[]
[null,null,"Commission Rate",2.75E-2,null,null,"Commission Rate",{"$f":"D22","v":2.75E-2},null,null,"Commission Rate",{"$f":"H22","v":2.75E-2}]
[]
[null,"Sales","Sales Rep Name","Commission Paid ($)",null,"Sales","Sales Rep Name","Commission Paid ($)",null,"Sales","Sales Rep Name","Commission Paid ($)"]
[null,57439.95,"Shayla",null,null,57439.95,"Shayla",null,null,57439.95,"Shayla"]
[null,57463.54,"Chantel",null,null,57463.54,"Chantel",null,null,57463.54,"Chantel"]
[null,55844.99,"Sioux",null,null,55844.99,"Sioux",null,null,55844.99,"Sioux"]
[null,57840.71,"Justina",null,null,57840.71,"Justina",null,null,57840.71,"Justina"]
[null,55257.17,"Ty",null,null,55257.17,"Ty",null,null,55257.17,"Ty"]
[null,null,"Total",null,null,null,"Total",null,null,null,"Total:"]
[]
[]
["a"]
["b"]
["c"]
["d"]

{"sheet":"P(3)","index":4,"n_rows":113,"n_cols":13,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Create a dynamic worksheet model that will show a sorted list of products and add the total sales for each product."]
[null,"You can use the SUMIFS function (similar to MAXIFS) top calculate the sales totals for each product."]
[null,"Whereas, MAXIFS will determine the largest value based on a condition, SUMIFS will add numbers based on a condition."]
[null,"MECS video #3 shows how to do a similar problem using the MAXIFS function at the 1:02:24 minute mark. Video link to right =>",null,null,null,null,null,null,null,null,"MECS03",null,"https://www.youtube.com/watch?v=AUYagm4ZA7M&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=7&t=3744s"]
[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 contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[]
[null,"Date","Product","Customer","Sales ($)"]
[null,"2022-07-19","Carlota","Customer 20",36368.19]
[null,"2022-07-17","Aspen","Customer 6",32532.89]
[null,"2022-07-10","Yanaki","Customer 20",27638.77]
[null,"2022-07-17","Aspen","Customer 15",14635.89]
[null,"2022-07-09","Yanaki","Customer 14",34372.400000000001]
[null,"2022-07-07","Yanaki","Customer 16",37088.49]
[null,"2022-07-03","Yanaki","Customer 10",24704.79]
[null,"2022-07-13","Aspen","Customer 27",38171.46]
[null,"2022-07-18","Quad","Customer 19",28347.85]
[null,"2022-07-30","Quad","Customer 2",12746.14]
[null,"2022-07-23","Yanaki","Customer 12",24177.25]
[null,"2022-07-29","Quad","Customer 1",16007.05]
[null,"2022-07-18","Aspen","Customer 8",44332.480000000003]
[null,"2022-07-05","Carlota","Customer 16",33232.67]
[null,"2022-07-24","Aspen","Customer 15",71245.42]
[null,"2022-07-18","Aspen","Customer 19",32359.3]
[null,"2022-07-29","Carlota","Customer 8",23631.69]
[null,"2022-07-09","Quad","Customer 14",13628.28]
[null,"2022-07-15","Quad","Customer 19",48261.919999999998]
[null,"2022-07-10","Yanaki","Customer 13",11177.42]
[null,"2022-07-30","Yanaki","Customer 27",47571.98]
[null,"2022-07-08","Carlota","Customer 13",40004.629999999997]
[null,"2022-07-20","Quad","Customer 18",23528.799999999999]
[null,"2022-07-10","Yanaki","Customer 16",40585.61]
[null,"2022-07-10","Yanaki","Customer 16",12596.67]
[null,"2022-07-31","Carlota","Customer 15",39140.67]
[null,"2022-07-16","Carlota","Customer 9",47734.35]
[null,"2022-07-31","Quad","Customer 17",49964.14]
[null,"2022-07-27","Carlota","Customer 16",16543.25]
[null,"2022-07-09","Aspen","Customer 5",54714.36]
[null,"2022-07-20","Aspen","Customer 18",52705.49]
[null,"2022-07-01","Carlota","Customer 10",31849.47]
[null,"2022-07-09","Carlota","Customer 27",21385.39]
[null,"2022-07-13","Aspen","Customer 4",29228.44]
[null,"2022-07-14","Aspen","Customer 8",61043.19]
[null,"2022-07-02","Yanaki","Customer 13",51255.23]
[null,"2022-07-27","Carlota","Customer 22",13206.49]
[null,"2022-07-10","Aspen","Customer 7",51678.83]
[null,"2022-07-23","Carlota","Customer 1",54859.02]
[null,"2022-07-24","Carlota","Customer 3",46497.47]
[null,"2022-07-10","Carlota","Customer 1",16147.47]
[null,"2022-07-20","Aspen","Customer 13",34898.17]
[null,"2022-07-11","Carlota","Customer 26",17296.310000000001]
[null,"2022-07-17","Aspen","Customer 20",19047.7]
[null,"2022-07-24","Yanaki","Customer 12",52856.78]
[null,"2022-07-12","Quad","Customer 25",29177.41]
[null,"2022-07-30","Aspen","Customer 3",41334.58]
[null,"2022-07-03","Quad","Customer 16",46394.22]
[null,"2022-07-15","Yanaki","Customer 15",41930.300000000003]
[null,"2022-07-05","Quad","Customer 16",38800.94]
[null,"2022-07-19","Yanaki","Customer 12",51842.64]
[null,"2022-07-02","Yanaki","Customer 6",15040.56]
[null,"2022-07-19","Aspen","Customer 21",37759.58]
[null,"2022-07-30","Quad","Customer 25",36042.65]
[null,"2022-07-20","Quad","Customer 8",68465.100000000006]
[null,"2022-07-29","Quad","Customer 23",23599.08]
[null,"2022-07-28","Aspen","Customer 9",38026.9]
[null,"2022-07-07","Quad","Customer 26",24981.95]
[null,"2022-07-18","Aspen","Customer 8",32145.360000000001]
[null,"2022-07-24","Quad","Customer 20",36503.57]
[null,"2022-07-05","Yanaki","Customer 3",13142.83]
[null,"2022-07-03","Quad","Customer 14",11197.38]
[null,"2022-07-03","Quad","Customer 15",11498.82]
[null,"2022-07-09","Aspen","Customer 6",16502.87]
[null,"2022-07-08","Carlota","Customer 24",45111.96]
[null,"2022-07-07","Yanaki","Customer 1",17126.05]
[null,"2022-07-31","Aspen","Customer 17",44088.86]
[null,"2022-07-23","Carlota","Customer 18",12508.49]
[null,"2022-07-15","Quad","Customer 2",20214.48]
[null,"2022-07-11","Carlota","Customer 12",47044.93]
[null,"2022-07-27","Quad","Customer 27",53428.75]
[null,"2022-07-06","Yanaki","Customer 23",40460.959999999999]
[null,"2022-07-27","Aspen","Customer 1",40221.06]
[null,"2022-07-24","Carlota","Customer 4",46538.78]
[null,"2022-07-20","Aspen","Customer 13",45051.99]
[null,"2022-07-28","Aspen","Customer 21",20479.189999999999]
[null,"2022-07-17","Yanaki","Customer 5",16727.59]
[null,"2022-07-09","Quad","Customer 13",32913.74]
[null,"2022-07-20","Yanaki","Customer 23",21870.240000000002]
[null,"2022-07-25","Carlota","Customer 21",22275.29]
[null,"2022-07-16","Quad","Customer 25",51974.720000000001]
[null,"2022-07-27","Yanaki","Customer 23",35437.43]
[null,"2022-07-10","Aspen","Customer 9",27940.81]
[null,"2022-07-27","Carlota","Customer 3",11967.16]
[null,"2022-07-10","Quad","Customer 13",37356.25]
[null,"2022-07-06","Carlota","Customer 5",27474.82]
[null,"2022-07-29","Yanaki","Customer 21",18020.810000000001]
[null,"2022-07-14","Aspen","Customer 22",12150.4]
[null,"2022-07-25","Aspen","Customer 12",35545.25]
[null,"2022-07-15","Carlota","Customer 2",52252.04]
[null,"2022-07-18","Yanaki","Customer 24",19660.14]
[null,"2022-07-05","Carlota","Customer 17",25518.5]
[null,"2022-07-23","Yanaki","Customer 16",21918.01]
[null,"2022-07-15","Carlota","Customer 7",42817.63]
[null,"2022-07-18","Quad","Customer 26",71123.28]
[null,"2022-07-09","Carlota","Customer 16",11671.9]
[null,"2022-07-25","Sunshine","Customer 9",49962.37]
[null,"2022-07-08","Aspen","Customer 27",44583.8]
[null,"2022-07-26","Sunshine","Customer 4",31253.16]
[null,"2022-07-07","Carlota","Customer 25",97008.74]
[null,"2022-07-12","Yanaki","Customer 1",25540.23]
[null,"2022-07-16","Sunshine","Customer 23",54182.63]
[null,"2022-07-08","Quad","Customer 19",45047.97]

{"sheet":"P(4)","index":5,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal: Create a formula in cell G10 that calculates number of days it took to pay the invoice and that will spill down the column."]
[null,"The formula to calculate the number of days between two dates is: Later Date - Earlier Date."]
[null,"New records will not be added to the below Customer Table"]
[null,"Understanding Date and Time Values in Excel was shown in MECS video #3 at the 54:32 minute mark. Here is link:",null,null,null,null,null,null,"MECS03",null,null,null,null,"https://www.youtube.com/watch?v=AUYagm4ZA7M&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=5&t=3272s"]
[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 contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[]
[null,"Customer","Invoice #","Amount Owed","Invoice Issue Date\n(Earlier Date)","Invoice Pay Date\n(Later Date)","Number Days To Pay Invoice"]
[null,"Rafaela Sparkman",2693,227.66,"2020-12-07T12:00:00","2021-02-27T12:00:00"]
[null,"Providencia Esposito",2867,759.31,"2020-12-21T12:00:00","2020-12-29T12:00:00"]
[null,"Adrien Dougherty",3092,303.89,"2020-12-24T12:00:00","2021-07-17T12:00:00"]
[null,"Marvis Block",3222,459.95,"2020-12-30T12:00:00","2021-06-12T12:00:00"]
[null,"Drucilla Ragsdale",3247,574.95000000000005,"2021-01-15T12:00:00","2021-07-07T12:00:00"]
[null,"Senaida Battles",3319,315.25,"2021-02-11T12:00:00","2021-05-24T12:00:00"]
[null,"Ossie Kimbrough",3459,181.82,"2021-02-16T12:00:00","2021-03-01T12:00:00"]
[null,"Elwood Koehler",3587,177.74,"2021-02-19T12:00:00","2021-10-23T12:00:00"]
[null,"Corliss Coffin",3903,581.59,"2021-03-14T12:00:00","2021-05-05T12:00:00"]
[null,"Claudette Barela",3950,761.62,"2021-03-16T12:00:00","2021-09-10T12:00:00"]