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

 

UX/UI Designer Needed for Psychologist Website Usability Review & Optimization

I’m looking for an experienced UX/UI designer to assess my recently redesigned website and recommend improvements to enhance usability and reduce bounce rates. The goal is to ensure visitors engage with the site rather than clicking away prematurely. Key Responsibilitie...

View Job
Develop a Copy Trading Tool for Options Trading

We are seeking a skilled developer to create a copy trading tool specifically for options trading. The solution should be able to receive alerts from a Discord channel and utilize APIs to execute trades in our brokerage at a specified percentage. The ideal candidate wil...

View Job
Full Stack Developer for Neural Network Project

We are seeking a skilled Full Stack Developer to design, develop, and implement a neural network application. The ideal candidate will have experience in both front-end and back-end technologies, as well as a strong understanding of machine learning concepts. You will w...

View Job