EXCEL - some support needed to build a basic resourcing xls
- or -
Post a project like this£36/hr(approx. $45/hr)
- Posted:
- Proposals: 44
- Remote
- #3433225
- Expired
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
Lead Generation,Data Analysis,Data Visualization,Dashboard,LinkedIn Leads,Market Research,MS Excel,Google sheets,Web Research,CRM/CMS,Google Ads,PPC
Bay Minette
Google Sheets Automation, Apps script, Excel VBA Expert, Qlikview, WordPress Hack Fix, Proofreading
Bangalore
557764665533964136025503038826277545039575164249228142248935167199634516582054
Description
Experience Level: Expert
I am looking to build a very basic resource management xls.
I want to be able to build a project team on new tabs, driven from data stored in a master look up sheet, this contains details of the staff (name), salary, daily rate etc.
There will be a few master sheets:
- Rate Card
- Staff XLS
Requirements I have:
- I want to be able to create a new project tab
- I want to be able to select resources from the resources sheet
- When I select the staff name, it populates the 'cost' from the staff sheet
- I want to be able to select the % allocation (10,20,30,40,50,6070.80.90,100) to the project
- I need to be able to select the role of the individual (from the rate card)
- I need to be able to see when a resource is over allocted (red if over allocated, amber if over 90% and green under 89%) when I am adding a resource to a new project.
Some sample data attached!
Thanks,
Rob
I want to be able to build a project team on new tabs, driven from data stored in a master look up sheet, this contains details of the staff (name), salary, daily rate etc.
There will be a few master sheets:
- Rate Card
- Staff XLS
Requirements I have:
- I want to be able to create a new project tab
- I want to be able to select resources from the resources sheet
- When I select the staff name, it populates the 'cost' from the staff sheet
- I want to be able to select the % allocation (10,20,30,40,50,6070.80.90,100) to the project
- I need to be able to select the role of the individual (from the rate card)
- I need to be able to see when a resource is over allocted (red if over allocated, amber if over 90% and green under 89%) when I am adding a resource to a new project.
Some sample data attached!
Thanks,
Rob
Rob S.
100% (33)Projects Completed
33
Freelancers worked with
28
Projects awarded
47%
Last project
17 Feb 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Rob, are you still reviewing new proposals? Thanks
-
Dear Sir, do you want your benefit in the form of Excel document as a calculator of how the bank is managed?
10027551002614
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