Grader Project 2
Richard Holmes
LC_Li_exploring.xlsxSubmission - MarkUp
| Submission MarkUp | ||
| This is a machine generated report of your submission document containing error details as annotations. | ||
| Details of all points deducted in the submitted document are listed on this sheet. | ||
| Assignment Details | ||
| Submission ID | 4456338400 | |
| Assignment Name | Excel Chapter 2 Grader Project | |
| Submission Date | 19 February, 2020 | |
| Report Generated on | 28 February, 2020 | |
| Points Obtained | 53.364/100 (53.364%) | |
| Worksheet: 'New Clients' (Points Deducted: 46.636) | ||
| Points Deducted | Details | Error Description |
| 39.636 | Cell level Incorrect Actions | 50 cell(s) commented inplace. Please check the sheet. |
| 2.000 | Incorrect Actions: Sheet (New Clients) | 2.000 point(s) deducted in instruction #12: -In the Sheet 'New Clients' the 'fit to pages' was not applied. |
| 5.000 | Incorrect Actions: Header(s)/Footer(s) | 5.000 point(s) deducted in instruction #13: -In the Sheet 'New Clients' the 'Center Footer Text Case' was not set as per instruction. -In the Sheet 'New Clients' the 'Center Footer Content' was not set to '&[Date]'. -In the Sheet 'New Clients' the 'Right Footer Text Case' was not set as per instruction. -In the Sheet 'New Clients' the 'Right Footer Content' was not set to '&[File]'. |
New Clients
| Health & Fitness Gym | ||||||||||
| Date Prepared: | 2/17/20 Project Error:: Project Error: 5 point(s) deducted in instruction #3: - In the Cell 'B2' of Sheet 'New Clients', the 'Formula' was not set to 'TODAY()'. |
|||||||||
| Client Project Error:: Project Error: 0.385 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Membership Project Error:: Project Error: 0.385 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Cost Project Error:: Project Error: 0.385 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Locker Project Error:: Project Error: 0.384 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Annual Total Project Error:: Project Error: 0.385 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Years Project Error:: Project Error: 0.384 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Total Due Project Error:: Project Error: 0.385 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Down Payment Project Error:: Project Error: 0.384 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Balance Project Error:: Project Error: 0.385 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Monthly Payment Project Error:: Project Error: 0.384 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | number of new members |
| Andrews | Deluxe | $ 575 | Yes | $ 654.31 Project Error:: Project Error: 8 point(s) deducted in instruction #4: - In the Cell 'E5' of Sheet 'New Clients', the 'Formula' was not set to 'IF(D5="Yes",$B$22+C5,C5)'. | 1 | $ 654.31 | $ 250 | $ 404.31 Project Error:: Project Error: 0.029 point(s) deducted in instruction #7: - In the Cell 'I5' of Sheet 'New Clients', the 'Formula Result Value' was not set to '400'. | ($76.56) Project Error:: Project Error: 1.333 point(s) deducted in instruction #8: - In the Cell 'J5' of Sheet 'New Clients', the 'Formula Result Value' was not set to '34.381'. | 0 |
| Baker | Individual | $ 300 | Yes | $ 379.31 Project Error:: Project Error: 0.236 point(s) deducted in instruction #5: - In the Cell 'E6' of Sheet 'New Clients', the 'Formula' was not set to 'IF(D6="Yes",$B$22+C6,C6)'. | 2 | $ 758.63 | $ 150 | $ 608.63 Project Error:: Project Error: 0.029 point(s) deducted in instruction #7: - In the Cell 'I6' of Sheet 'New Clients', the 'Formula Result Value' was not set to '600'. | ($37.52) Project Error:: Project Error: 1.333 point(s) deducted in instruction #8: - In the Cell 'J6' of Sheet 'New Clients', the 'Formula Result Value' was not set to '26.525'. | 0 |
| Carter | Family | $ 1,500 | No | $ - 0 Project Error:: Project Error: 0.319 point(s) deducted in instruction #5: - In the Cell 'E7' of Sheet 'New Clients', the 'Formula' was not set to 'IF(D7="Yes",$B$22+C7,C7)'. - In the Cell 'E7' of Sheet 'New Clients', the 'Formula Result Value' was not set to '1500'. | 3 | $ - 0 | $ 700 | $ (700.00) Project Error:: Project Error: 0.029 point(s) deducted in instruction #7: - In the Cell 'I7' of Sheet 'New Clients', the 'Formula Result Value' was not set to '3800'. | ($21.72) Project Error:: Project Error: 1.333 point(s) deducted in instruction #8: - In the Cell 'J7' of Sheet 'New Clients', the 'Formula Result Value' was not set to '115.173'. | 1 |
| Dudley | Deluxe | $ 575 | No | $ - 0 Project Error:: Project Error: 0.236 point(s) deducted in instruction #5: - In the Cell 'E8' of Sheet 'New Clients', the 'Formula' was not set to 'IF(D8="Yes",$B$22+C8,C8)'. | 2 | $ - 0 | $ 250 | $ (250.00) Project Error:: Project Error: 0.03 point(s) deducted in instruction #7: - In the Cell 'I8' of Sheet 'New Clients', the 'Formula Result Value' was not set to '900'. | ($11.32) Project Error:: Project Error: 1.334 point(s) deducted in instruction #8: - In the Cell 'J8' of Sheet 'New Clients', the 'Formula Result Value' was not set to '39.787'. | 1 |
| Evans | Deluxe | $ 575 | Yes | $ 654.31 Project Error:: Project Error: 0.235 point(s) deducted in instruction #5: - In the Cell 'E9' of Sheet 'New Clients', the 'Formula' was not set to 'IF(D9="Yes",$B$22+C9,C9)'. | 3 | $ 1,962.94 | $ 250 | $ 1,712.94 | ($59.27) Project Error:: Project Error: 1.333 point(s) deducted in instruction #8: - In the Cell 'J9' of Sheet 'New Clients', the 'Formula Result Value' was not set to '51.525'. | 0 |
| Foust | Individual | $ 300 | No | $ - 0 Project Error:: Project Error: 0.236 point(s) deducted in instruction #5: - In the Cell 'E10' of Sheet 'New Clients', the 'Formula' was not set to 'IF(D10="Yes",$B$22+C10,C10)'. | 1 | $ - 0 Project Error:: Project Error: 0.083 point(s) deducted in instruction #5: - In the Cell(s) 'G10', 'E12' of Sheet 'New Clients', the 'Formula Result Value' was not set to '300'. | $ 150 | $ (150.00) Project Error:: Project Error: 0.03 point(s) deducted in instruction #7: - In the Cell(s) 'I10' of Sheet 'New Clients', the 'Formula Result Value' was not set to '150'. | ($13.22) Project Error:: Project Error: 1.334 point(s) deducted in instruction #8: - In the Cell 'J10' of Sheet 'New Clients', the 'Formula Result Value' was not set to '12.893'. | 1 |
| Gardner | Individual | $ 300 | No | $ - 0 Project Error:: Project Error: 0.235 point(s) deducted in instruction #5: - In the Cell 'E11' of Sheet 'New Clients', the 'Formula' was not set to 'IF(D11="Yes",$B$22+C11,C11)'. | 2 | $ - 0 | $ 150 | $ (150.00) Project Error:: Project Error: 0.029 point(s) deducted in instruction #7: - In the Cell 'I11' of Sheet 'New Clients', the 'Formula Result Value' was not set to '450'. | ($6.79) Project Error:: Project Error: 1.333 point(s) deducted in instruction #8: - In the Cell 'J11' of Sheet 'New Clients', the 'Formula Result Value' was not set to '19.894'. | 1 |
| Hart | Individual | $ 300 | No | $ - 0 Project Error:: Project Error: 0.319 point(s) deducted in instruction #5: - In the Cell 'E12' of Sheet 'New Clients', the 'Formula' was not set to 'IF(D12="Yes",$B$22+C12,C12)'. - In the Cell(s) 'G10', 'E12' of Sheet 'New Clients', the 'Formula Result Value' was not set to '300'. | 3 | $ - 0 | $ 150 | $ (150.00) Project Error:: Project Error: 0.03 point(s) deducted in instruction #7: - In the Cell 'I12' of Sheet 'New Clients', the 'Formula Result Value' was not set to '750'. | ($4.65) Project Error:: Project Error: 1.334 point(s) deducted in instruction #8: - In the Cell 'J12' of Sheet 'New Clients', the 'Formula Result Value' was not set to '22.732'. | 1 |
| Ivans | Individual | $ 300 | Yes | $ 379.31 Project Error:: Project Error: 0.235 point(s) deducted in instruction #5: - In the Cell 'E13' of Sheet 'New Clients', the 'Formula' was not set to 'IF(D13="Yes",$B$22+C13,C13)'. | 3 | $ 1,137.94 | $ 150 | $ 987.94 Project Error:: Project Error: 0.029 point(s) deducted in instruction #7: - In the Cell 'I13' of Sheet 'New Clients', the 'Formula Result Value' was not set to '975'. | ($34.51) Project Error:: Project Error: 1.333 point(s) deducted in instruction #8: - In the Cell 'J13' of Sheet 'New Clients', the 'Formula Result Value' was not set to '29.551'. | 0 |
| Totals | $ 2,067 Project Error:: Project Error: 0.4 point(s) deducted in instruction #9: - In the Cell 'E14' of Sheet 'New Clients', the 'Formula Result Value' was not set to '5025'. | $ 20 | $ 4,514 Project Error:: Project Error: 0.4 point(s) deducted in instruction #9: - In the Cell 'G14' of Sheet 'New Clients', the 'Formula Result Value' was not set to '11925'. | $ 2,200 | $ 2,314 Project Error:: Project Error: 0.4 point(s) deducted in instruction #9: - In the Cell 'I14' of Sheet 'New Clients', the 'Formula Result Value' was not set to '9725'. | $ (266) Project Error:: Project Error: 0.4 point(s) deducted in instruction #9: - In the Cell 'J14' of Sheet 'New Clients', the 'Formula Result Value' was not set to '352.46'. | 5 | |||
| Membership Project Error:: Project Error: 0.385 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Cost Project Error:: Project Error: 0.384 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Down Payment Project Error:: Project Error: 0.385 point(s) deducted in instruction #11: - In the Cell(s) 'A4', 'B4', 'C4', 'D4', 'E4', 'F4', 'G4', 'H4', 'I4', 'J4', 'A17', 'B17', 'C17' of Sheet 'New Clients', the 'Wrap Text' was not applied. | Summary Statistics | |||||||
| Deluxe | $ 575 | $ 250 | Number of New Members | 5 Project Error:: Project Error: 1.633 point(s) deducted in instruction #10: - In the Cell 'H18' of Sheet 'New Clients', the 'Formula' was not set to 'COUNTA(A5:A13)'. - In the Cell 'H18' of Sheet 'New Clients', the 'Formula Result Value' was not set to '9'. |
||||||
| Family | $ 1,500 | $ 700 | Lowest Monthly Payment | ($4.65) Project Error:: Project Error: 2.009 point(s) deducted in instruction #10: - In the Cell(s) 'H19', 'H20', 'H21', 'H22' of Sheet 'New Clients', the 'Category' was not set to 'Accounting'. - In the Cell 'H19' of Sheet 'New Clients', the 'Formula' was not set to 'MIN(J5:J13)'. - In the Cell 'H19' of Sheet 'New Clients', the 'Formula Result Value' was not set to '12.893'. |
||||||
| Individual | $ 300 | $ 150 | Average Monthly Payment | ($29.51) Project Error:: Project Error: 0.675 point(s) deducted in instruction #10: - In the Cell(s) 'H19', 'H20', 'H21', 'H22' of Sheet 'New Clients', the 'Category' was not set to 'Accounting'. - In the Cell 'H20' of Sheet 'New Clients', the 'Formula Result Value' was not set to '39.162'. |
||||||
| Maxium Monthly Payment | ($4.65) Project Error:: Project Error: 0.675 point(s) deducted in instruction #10: - In the Cell(s) 'H19', 'H20', 'H21', 'H22' of Sheet 'New Clients', the 'Category' was not set to 'Accounting'. - In the Cell 'H21' of Sheet 'New Clients', the 'Formula Result Value' was not set to '115.173'. |
|||||||||
| Locker Fee | $ 75 | Median Monthly Payment | ($21.72) Project Error:: Project Error: 0.675 point(s) deducted in instruction #10: - In the Cell(s) 'H19', 'H20', 'H21', 'H22' of Sheet 'New Clients', the 'Category' was not set to 'Accounting'. - In the Cell 'H22' of Sheet 'New Clients', the 'Formula Result Value' was not set to '29.551'. |
|||||||
| Interest Rate | 5.75% | |||||||||
| Months Per Year | 12 | |||||||||
| Annual Interest | $ 4.31 | |||||||||
| Total amount | $ 79.31 | |||||||||
EX16_XL_CH02_GRADER_CAP_AS_Gym_Management 1.10
Name: [2/17/2020] EX16_XL_CH02_GRADER_CAP_AS_Gym_Management1.10
