1
Леонид
no recommendations
no complaints
Project title: Create an online Excel table
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Bank transfer, Electronic money
Acceptance of requests: from 2022-03-08 until 2022-03-23
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Bank transfer, Electronic money
Acceptance of requests: from 2022-03-08 until 2022-03-23
Project description:
Remote work for a table creation specialist in Excel. You need to create a table in an online oxel.
The main page should have a table (I attach the option).
Task:
You need to keep a good record of projects.
The table should be ready to add clients(pages), performers(pages), service status(pages), service types(pages), and to keep financial records.
The main sheet should sort customers by name, independently add extra lines (always let there be one empty line), remove from the list.
Projects with the status Ready, paid.
The steps should look like this:
- Select from the client list
We write a unique name for the project.
- select from the list of the performer
Select from the list the type of service
- status.
- enter the order price
- Introduce the price of the work
At this stage, the table itself enters the start date of the project and the profit.
At the same time, the Client’s page should display:
- start date of the project
- project name
- performer
- project cost
- current status of the project
- completion date (after the project status change on the home page on Ready, paid).
The page should have a separation into current projects and project history, where all past closed projects will be displayed.
The same thing with the contractor, only instead of the price of the project - the price of the work.
There should be a page with FINANCES:
- Displaying figures for all open projects:
- projects in the work
- ready, not paid.
- not at work.
- keeping statistics by month (each last month saves and starts a new one) - Total projects, Total work, Profit
Adding the client performer, adding the name in a new line - a new sheet with the name of the client performer should appear formatted under all the output parameters.
Remote work for a table creation specialist in Excel. You need to create a table in an online oxel.
The main page should have a table (I attach the option).
Task:
You need to keep a good record of projects.
The table should be ready to add clients(pages), performers(pages), service status(pages), service types(pages), and to keep financial records.
The main sheet should sort customers by name, independently add extra lines (always let there be one empty line), remove from the list.
Projects with the status Ready, paid.
The steps should look like this:
- Select from the client list
We write a unique name for the project.
- select from the list of the performer
Select from the list the type of service
- status.
- enter the order price
- Introduce the price of the work
At this stage, the table itself enters the start date of the project and the profit.
At the same time, the Client’s page should display:
- start date of the project
- project name
- performer
- project cost
- current status of the project
- completion date (after the project status change on the home page on Ready, paid).
The page should have a separation into current projects and project history, where all past closed projects will be displayed.
The same thing with the contractor, only instead of the price of the project - the price of the work.
There should be a page with FINANCES:
- Displaying figures for all open projects:
- projects in the work
- ready, not paid.
- not at work.
- keeping statistics by month (each last month saves and starts a new one) - Total projects, Total work, Profit
Adding the client performer, adding the name in a new line - a new sheet with the name of the client performer should appear formatted under all the output parameters.
