Create a table in Excel

Employer
[no-member:pro]Aleksey[/no-member:pro]
Project parameters
Type of cooperationOne-time project
SectionTexts and translation
Prepaymentprepayment is possible
Payment methodsBank transfer
Acceptance of requestsfrom Oct 1, 2019 until Oct 3, 2019
Project description
We need a specialist in Excel. You need to create a table in Excel
The table should have the following columns.
These columns are classified as Accommodation:
House economy 2-seater;
House of economy 4-seater;
Eco-house 4-seat suite;
8-person suite house;
House (hairy) 2-seater;
Add/seats;
Date; call/person;
Clock/day;
Cost/accommodation;
Discount;
2. These columns are in the category of Baths:
Bath 1/with a cold vat;
Bath 1/ with a hot vat;
Bath 1;
Bath 2;
Bath 3 exit;
broom/kol
Broom/cost;
Date;
Kol/man;
COL/Clock;
Cost/baths
Other/services;
Date;
Cost
3. There must be a few outcomes.
1. Total house 2 locals
2. Total house 4 locals
3. Total Eco-House 4-Seater
4. Total house for 8 people
5. Total house 2-seat (hairy)
6. Total for Bath 1 with a vat and without a vat
7. Total Bath 2.
8. Total for Bath 3.
9. Total of additional/services
10. Totally in all baths for the month
11. Totally every house in a month.
4. We need to program the schedules.
• Chart in the form of a curve by house (cost, by month, only the results)
• Schedule in the form of a curve on the baths (cost, by months, only the results)
• Schedule in the form of a funnel by months of residence (col person)
• Schedule in the form of a funnel by months of bath (col person)
• Schedule of discounts by month in the form of a funnel (results of discounts for the week and month)
Also make it possible to add homes; services.
The table should have the following columns.
These columns are classified as Accommodation:
House economy 2-seater;
House of economy 4-seater;
Eco-house 4-seat suite;
8-person suite house;
House (hairy) 2-seater;
Add/seats;
Date; call/person;
Clock/day;
Cost/accommodation;
Discount;
2. These columns are in the category of Baths:
Bath 1/with a cold vat;
Bath 1/ with a hot vat;
Bath 1;
Bath 2;
Bath 3 exit;
broom/kol
Broom/cost;
Date;
Kol/man;
COL/Clock;
Cost/baths
Other/services;
Date;
Cost
3. There must be a few outcomes.
1. Total house 2 locals
2. Total house 4 locals
3. Total Eco-House 4-Seater
4. Total house for 8 people
5. Total house 2-seat (hairy)
6. Total for Bath 1 with a vat and without a vat
7. Total Bath 2.
8. Total for Bath 3.
9. Total of additional/services
10. Totally in all baths for the month
11. Totally every house in a month.
4. We need to program the schedules.
• Chart in the form of a curve by house (cost, by month, only the results)
• Schedule in the form of a curve on the baths (cost, by months, only the results)
• Schedule in the form of a funnel by months of residence (col person)
• Schedule in the form of a funnel by months of bath (col person)
• Schedule of discounts by month in the form of a funnel (results of discounts for the week and month)
Also make it possible to add homes; services.