![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Listing and distribution of work to be done and line graph
- or -
Post a project like this1232
€513(approx. $557)
- Posted:
- Proposals: 2
- Remote
- #3160865
- Awarded
Description
Experience Level: Expert
Nice to meet you, we are a web agency and i need to automate a process that we actually manually do, which is the following.
1- The Salesperson sell something
2- He/she compile a module (google form atm) with the following data:
What has been sold
Client name
Contact name
Contact mail
Contact phone
Data of contract signed
Value
Category (10 category)
3- this data all go into a google sheet
4- based on the category the data are copied into another sheet (a "division" sheet)
5- If the service is some kind of package (like 12 emails for example) the package is divided one segment per line, dividing the value for the number of items).
5- in these sheet there are also the: Data assigned, start dat, end date, time used fields
6- When a project start a "1" is counted on a statistic that we visualize daily, weekly and monthly (three different graph)
7-When a project end the same happen on an "end" statistic AND the value of the end project is added to a specific statistic (also daily, weekly and monthly)
We would like to automate all of this, just leaving to the human the possibility to add start, end and time on every specific project.
The automation should include the creation of line charts for the "start" "end" and "value" data.
If this is possibile on outlook online even better.
Thanks in advance for your time
Best regards
Andrea
![Solutions srl](https://www.peopleperhour.com/imgs/default_avatar_light_70x70.png)
Solutions srl
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
1 Jul 2021
Italy
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies