Automate an excel sheet which we are currently using to predict employees' routes
- or -
Post a project like this2792
$250
- Posted:
- Proposals: 6
- Remote
- #1251018
- Awarded
WordPress DataEntry | uploading | Web Admin | Photoshop | Data Entry | PDF2Word | Virtual Assistant | Ad-posting
Zongzhai
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
730505397759780468119279812280501309633
Description
Experience Level: Expert
General information for the business: Service provider on regular basis to residences in California
Description of excel work: I have an excel sheet built which acts to show appointments which are schedule on our employees days for six months. In order to make this sheet work however it is necessary to export a report from our CRM software, formate the columns, and then plug it all in.
I would like to have this automated so that the report is regularly updated and kept current. I have set the report up to be emailed as a csv file from our CRM to an email address set up exclusively for that purpose every 4 hours.
I now need someone to be able to put it all together so that the excel sheet can be viewed by multiple viewers at any given time and is updated every 4 hours.
The excel sheet as it is written will probably need to be built in another software so that it can be hosted online.
We do use Microsoft Sharepoint, which may be the best option.
As a note- I had posted this job about 5 weeks ago and chose a provider who strung me along for weeks before admitting that he had personal issues taking place that were precluding him from getting to this project.
I would like to see this project completed as quickly as possible and have other projects waiting behind it for someone who can show themselves to do great work.
Extra notes:
Description of excel work: I have an excel sheet built which acts to show appointments which are schedule on our employees days for six months. In order to make this sheet work however it is necessary to export a report from our CRM software, formate the columns, and then plug it all in.
I would like to have this automated so that the report is regularly updated and kept current. I have set the report up to be emailed as a csv file from our CRM to an email address set up exclusively for that purpose every 4 hours.
I now need someone to be able to put it all together so that the excel sheet can be viewed by multiple viewers at any given time and is updated every 4 hours.
The excel sheet as it is written will probably need to be built in another software so that it can be hosted online.
We do use Microsoft Sharepoint, which may be the best option.
As a note- I had posted this job about 5 weeks ago and chose a provider who strung me along for weeks before admitting that he had personal issues taking place that were precluding him from getting to this project.
I would like to see this project completed as quickly as possible and have other projects waiting behind it for someone who can show themselves to do great work.
Extra notes:
Shane H.
100% (4)Projects Completed
4
Freelancers worked with
4
Projects awarded
71%
Last project
16 Jun 2020
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi, I would like these clarifications:
1. Please confirm that the task is converting CSV files into xl sheets with proper formatting and taking appropriate fields only in appropriate places. That is what it sounds like.
2. You are saying that it has to be done with a periodicity of 4 hours. Till when will this updation (with 4 hours gap) will need to be done.
Thanks.
108810
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