Charting and Importing data

profileAK47
new.xlsx
Home>Computer Science homework help>Charting and Importing data

January

Name
Class Time:1pm
Lab Room #:
Grader's Name:
Grader's Email:
DATE VENDOR DESCRIPTION CHECK AMOUNT DEPOSITS F CURRENCY DESCRIPTION BANK BALANCE OFFICE REPAIR SCHOOL LICENSE MEALS SUB COST OF FOOD BANKING MISCELLANEOUS EXP TOTAL %RENT
2/1/14 # $ INR beginning balance 5,000.00 AUTO INSUR RENT UTILITIES EXP. MAINT. SUPPLIES FEES EATING OUT CONTR FOOD ESPRESSO BREAD BOOZE TOTAL FOOD COST OTHER TAXES FEES $ AMOUNT DESCRIPTON EXPENSES
ERROR:#NAME? ERROR:#NAME?
2/1/2014 [$INR] 0.00 70.00 30.00 100.00 70.00
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
TOTAL 900.00 0.00 [$INR] 0.00 4,100.00 0.00 0.00 70.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 30.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 70.00
0.00 ERROR:#DIV/0!
ERROR:#DIV/0!
CHECK FIGURE 100.00 0.00

Summary

DATE 2014 DEPOSITS F CURRENCY BANK BALANCE EMPLOYEE LEASE ACCOUNTING OFFICE REPAIR SUPPLIES LICENSE MEALS SUB COST OF GOODS COST OF PERSONAL BANKING MISCELLANEOUS EXP TOTAL
$ INR -40759.52 ADVERTISE AUTO BENEFITS INSUR LOANS LEGAL EXP. MAINT. FEES ENTER UTILITIES CONTR FOOD ESPRESSO BREAD BOOZE OTHER PAYROLL THINK OF PAYROLL LOAN TAXES FEES $ AMOUNT DESCRIPTON EXPENSES
January [$INR] 0.00
February [$INR] 0.00
March [$INR] 0.00
April [$INR] 0.00
May [$INR] 0.00
June [$INR] 0.00
July [$INR] 0.00
August [$INR] 0.00
September [$INR] 0.00
October [$INR] 0.00
November [$INR] 0.00
December [$INR] 0.00
Total 0 [$INR] 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

February

Name
Class Time:1pm
Lab Room #:
Grader's Name:
Grader's Email:
DATE VENDOR DESCRIPTION CHECK AMOUNT DEPOSITS F CURRENCY DESCRIPTION BANK BALANCE OFFICE REPAIR SCHOOL LICENSE MEALS SUB COST OF FOOD BANKING MISCELLANEOUS EXP TOTAL %RENT
2/1/14 # $ INR beginning balance 5,000.00 AUTO INSUR RENT UTILITIES EXP. MAINT. SUPPLIES FEES EATING OUT CONTR FOOD ESPRESSO BREAD BOOZE TOTAL FOOD COST OTHER TAXES FEES $ AMOUNT DESCRIPTON EXPENSES
0.00
2/1/2014 [$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
TOTAL 900.00 0.00 [$INR] 0.00 4,100.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ERROR:#DIV/0!
0.00 ERROR:#DIV/0!
ERROR:#DIV/0!
CHECK FIGURE 0.00 ERROR:#DIV/0!

March

Name
Class Time:1pm
Lab Room #:
Grader's Name:
Grader's Email:
DATE VENDOR DESCRIPTION CHECK AMOUNT DEPOSITS F CURRENCY DESCRIPTION BANK BALANCE OFFICE REPAIR SCHOOL LICENSE MEALS SUB COST OF FOOD BANKING MISCELLANEOUS EXP TOTAL %RENT
2/1/14 # $ INR beginning balance 5,000.00 AUTO INSUR RENT UTILITIES EXP. MAINT. SUPPLIES FEES EATING OUT CONTR FOOD ESPRESSO BREAD BOOZE TOTAL FOOD COST OTHER TAXES FEES $ AMOUNT DESCRIPTON EXPENSES
0.00
2/1/2014 [$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
TOTAL 900.00 0.00 [$INR] 0.00 4,100.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ERROR:#DIV/0!
0.00 ERROR:#DIV/0!
ERROR:#DIV/0!
CHECK FIGURE 0.00 ERROR:#DIV/0!

April

Name
Class Time:1pm
Lab Room #:
Grader's Name:
Grader's Email:
DATE VENDOR DESCRIPTION CHECK AMOUNT DEPOSITS F CURRENCY DESCRIPTION BANK BALANCE OFFICE REPAIR SCHOOL LICENSE MEALS SUB COST OF FOOD BANKING MISCELLANEOUS EXP TOTAL %RENT
2/1/14 # $ INR beginning balance 5,000.00 AUTO INSUR RENT UTILITIES EXP. MAINT. SUPPLIES FEES EATING OUT CONTR FOOD ESPRESSO BREAD BOOZE TOTAL FOOD COST OTHER TAXES FEES $ AMOUNT DESCRIPTON EXPENSES
0.00
2/1/2014 [$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
TOTAL 900.00 0.00 [$INR] 0.00 4,100.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ERROR:#DIV/0!
0.00 ERROR:#DIV/0!
ERROR:#DIV/0!
CHECK FIGURE 0.00 ERROR:#DIV/0!

May

Name
Class Time:1pm
Lab Room #:
Grader's Name:
Grader's Email:
DATE VENDOR DESCRIPTION CHECK AMOUNT DEPOSITS F CURRENCY DESCRIPTION BANK BALANCE OFFICE REPAIR SCHOOL LICENSE MEALS SUB COST OF FOOD BANKING MISCELLANEOUS EXP TOTAL %RENT
2/1/14 # $ INR beginning balance 5,000.00 AUTO INSUR RENT UTILITIES EXP. MAINT. SUPPLIES FEES EATING OUT CONTR FOOD ESPRESSO BREAD BOOZE TOTAL FOOD COST OTHER TAXES FEES $ AMOUNT DESCRIPTON EXPENSES
0.00
2/1/2014 [$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
TOTAL 900.00 0.00 [$INR] 0.00 4,100.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ERROR:#DIV/0!
0.00 ERROR:#DIV/0!
ERROR:#DIV/0!
CHECK FIGURE 0.00 ERROR:#DIV/0!

June

Name
Class Time:1pm
Lab Room #:
Grader's Name:
Grader's Email:
DATE VENDOR DESCRIPTION CHECK AMOUNT DEPOSITS F CURRENCY DESCRIPTION BANK BALANCE OFFICE REPAIR SCHOOL LICENSE MEALS SUB COST OF FOOD BANKING MISCELLANEOUS EXP TOTAL %RENT
2/1/14 # $ beginning balance 5,000.00 AUTO INSUR RENT UTILITIES EXP. MAINT. SUPPLIES FEES EATING OUT CONTR FOOD ESPRESSO BREAD BOOZE TOTAL FOOD COST OTHER TAXES FEES $ AMOUNT DESCRIPTON EXPENSES
INR 300.00 46.00 57.00 403.00
2/6/2014 [$INR] 0.00 300.00 89.00 78.00 467.00 64.24
4/6/14 [$INR] 0.00 56.00 300.00 100.00 75.00 531.00 56.50
[$INR] 0.00 80.00 300.00 20.00 136.00 95.00 63.00 694.00 43.23
7/6/14 [$INR] 0.00 67.00 300.00 100.00 123.00 79.00 10.00 679.00 44.18
[$INR] 0.00 300.00 50.00 150.00 30.00 84.00 614.00 48.86
[$INR] 0.00 145.00 300.00 100.00 15.00 560.00 53.57
[$INR] 0.00 67.00 300.00 30.00 121.00 98.00 616.00 48.70
[$INR] 0.00 300.00 70.00 89.00 10.00 469.00 63.97
[$INR] 0.00 244.00 300.00 50.00 56.00 78.00 728.00 41.21
[$INR] 0.00 300.00 90.00 390.00 76.92
TOTAL -1,073.00 0.00 [$INR] 0.00 6,073.00 579.00 80.00 3,300.00 20.00 100.00 80.00 0.00 0.00 1,075.00 0.00 672.00 84.00 20.00 63.00 0.00 0.00 0.00 0.00 6,073.00 54.34
0.00 ERROR:#DIV/0!
ERROR:#DIV/0!
CHECK FIGURE 6,073.00 0.00

July

Name
Class Time:1pm
Lab Room #:
Grader's Name:
Grader's Email:
DATE VENDOR DESCRIPTION CHECK AMOUNT DEPOSITS F CURRENCY DESCRIPTION BANK BALANCE OFFICE REPAIR SCHOOL LICENSE MEALS SUB COST OF FOOD BANKING MISCELLANEOUS EXP TOTAL %RENT
2/1/14 # $ INR beginning balance 5,000.00 AUTO INSUR RENT UTILITIES EXP. MAINT. SUPPLIES FEES EATING OUT CONTR FOOD ESPRESSO BREAD BOOZE TOTAL FOOD COST OTHER TAXES FEES $ AMOUNT DESCRIPTON EXPENSES
0.00
2/1/2014 [$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
[$INR] 0.00 0.00 ERROR:#DIV/0!
TOTAL 900.00 0.00 [$INR] 0.00 4,100.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ERROR:#DIV/0!
0.00 ERROR:#DIV/0!
ERROR:#DIV/0!
CHECK FIGURE 0.00 ERROR:#DIV/0!