Add manpower scheduling functionality to existing MS-Excel workbook


$60.00
Hourly: $60.00 - $80.00

Context/Background: BDG has a ‘BCG Contract Job Master” spreadsheet which is updated daily and maintains all critical data on each job. This data range table is many things to many people and is maintained as a dynamic Teams document. As such, this table is constantly being filtered, sorted and added to. Any new functionality needs to accommodate how this spreadsheet is used. New Functionality Request: Using existing data input fields (columns): • Storefront Man Hours • First Mob(ilization) Date • Average Crew Size • 10% Overtime toggle OR • 20% Overtime toggle Based on the inputs provided above, I would like to see functionality added to do the following: • Calculate the number of weeks a job will last based on manpower intensity • Visually ‘block out’ the calendar weeks • List the avg daily crew size on the cell for each week • Automatically add calendar weeks as needed • SEE EXAMPLE (YELLOW ROW) IN ATTACHED DOCUMENT

Keyword: Web Programmer

Price: $60.0

Microsoft Excel Visual Basic for Applications Desktop Application

 

API Automation Expert, AI+Agent , Power Pages Creator needed

We are seeking an experienced automation expert to help us rebuild our intake system using Microsoft Power Pages. The project includes integrating and Developing AI+Agent and building a (RAG) system. The ideal candidate will have a strong background in automation, CRM i...

View Job
Web Developer Needed for Ruby on Rails & React Feature Development

We are seeking an experienced web developer to join our team for continued feature development on our web application. The project primarily involves working with Ruby on Rails and React, with a Shopify integration. The ideal candidate should have a solid understanding ...

View Job
Azure AD / External ID SSO Integration for Multi-Tenant SaaS Application

We are looking for an experienced developer to integrate Azure Active Directory (AD) and External ID single sign-on (SSO) into our multi-tenant SaaS application. This integration will allow end users to securely log in using their Microsoft credentials. The ideal candid...

View Job