I need someone to help build a spreadsheet with VBA to help automate my staffing
- or -
Post a project like this£250(approx. $314)
- Posted:
- Proposals: 13
- Remote
- #1479413
- Expired
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
270269649865963451105071211927981228050125553212671401284149133186714949781541543
Description
Experience Level: Intermediate
General information for the business: digital media production
Kind of development: New program from scratch
Description of requirements/functionality: The spreadsheet must have several core functions:
1) Have an active/editable database of staff available in two groups -- full time and casuals
2) Must have a calendar with dates as cells that can be changed from neutral, "good" and "bad" (ie there is a staffing gap that needs to be filled)
3) Users will be able to choose from a drop down of suggested staff for "bad" cells.
4) Will be able to automatically generate emails requesting staff availability for these days using Outlook.
5) Once staffing has been confirmed, user must be able to send confirmation email of date and show correlated with the "bad" cell which will then turn "good"
6) There must me a home screen/dashboard detailing active/ongoing requests for staffing that is automatically updated based on the users actions.
7) There must be a page where user can enter availability of staff if given. This will influence who is suggested as potential cover for "bad" cells.
OS requirements: Windows, Other
Extra notes: Can be either made in Microsoft VBA / Excel or Google Spreadsheets.
I have provided notes / comments within the Excel and image provided
Kind of development: New program from scratch
Description of requirements/functionality: The spreadsheet must have several core functions:
1) Have an active/editable database of staff available in two groups -- full time and casuals
2) Must have a calendar with dates as cells that can be changed from neutral, "good" and "bad" (ie there is a staffing gap that needs to be filled)
3) Users will be able to choose from a drop down of suggested staff for "bad" cells.
4) Will be able to automatically generate emails requesting staff availability for these days using Outlook.
5) Once staffing has been confirmed, user must be able to send confirmation email of date and show correlated with the "bad" cell which will then turn "good"
6) There must me a home screen/dashboard detailing active/ongoing requests for staffing that is automatically updated based on the users actions.
7) There must be a page where user can enter availability of staff if given. This will influence who is suggested as potential cover for "bad" cells.
OS requirements: Windows, Other
Extra notes: Can be either made in Microsoft VBA / Excel or Google Spreadsheets.
I have provided notes / comments within the Excel and image provided
Suhail P.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
14 May 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 Suhail,
Are you open for different technology stack?
Have a responsive web based application readily available with exactly same functionality that you are looking for built on Microsoft stack .
I look forward to your reply.
Regards,
Dharmesh -
Hi Suhail
I could develop a multi-user desktop application for the advertised fixed cost.
Please let me know if this interests you.
Regards
Shaun
343356343306
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