Excel plan on a page
- or -
Post a project like this$$$
- Posted:
- Proposals: 7
- Remote
- #1667898
- Expired
Excel Dashboard, Reporting Expert | VBA, Macros |Business Intelligence and Data Analytics | Power BI | Financial Analysis | Google Spreadsheet Design and Scripting | Python Expert | MT4 | MT4 Manager
Pune
3155615143749683681449473171306517373091811589
Description
Experience Level: Expert
General information for the business: Excel plan on a page
Industry: Internet/Software
Description of excel work: The client I am currently working on produces a monthly plan on a page in PowerPoint, this comprises of a series of swim lanes with milestones aligned by month, with the appropriate RED/AMBER/GREEN/COMPLETE status etc. There are c.100 milestones and activities shown and the process is quite time consuming to maintain. Ideally I'd like an automated plan on a page based on an excel extract from Microsoft project. We would like to be able to specify th number/title of siwm lanes and for the milestones to render accordingly;
Example output attached.
Extra notes:
Industry: Internet/Software
Description of excel work: The client I am currently working on produces a monthly plan on a page in PowerPoint, this comprises of a series of swim lanes with milestones aligned by month, with the appropriate RED/AMBER/GREEN/COMPLETE status etc. There are c.100 milestones and activities shown and the process is quite time consuming to maintain. Ideally I'd like an automated plan on a page based on an excel extract from Microsoft project. We would like to be able to specify th number/title of siwm lanes and for the milestones to render accordingly;
Example output attached.
Extra notes:
Jonathan H.
100% (4)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
1 Apr 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Cannot see the excel file?
-
Hi Jonathan
I would be happy to discuss and explain more advantages to do it as a web portal instead of excel, if you are interested lets have a call to discuss more.
Thanks -
Please share the excel sheet to be used as input, if this available.
ThanksJonathan H.08 Aug 2017Excel file uploaded.
-
Do you have a copy of the excel output from MS Project please?
Jonathan H.08 Aug 2017Excel file uploaded.
Scott W.08 Aug 2017I don't see a Excel file. :-/
477929477857476631476564
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