Tuesday, December 19th, 2017 / by Excel Champ
It’s common for organizations to start out with a simple Excel spreadsheet to manage their staffing needs. As the organizations grow and the staffing and reporting requirements become more complex, these simple spreadsheets can then be transformed into Excel applications with an amazing amount of functionality. At eSoftware Associates, our expert VBA developers have created customized Excel staffing applications for firms in construction management, manufacturing, and healthcare.
Excel is great for developing forecasts, whether they are based on simple counts and ratios or more complex models. Models can be developed for individual projects, locations or business units. Then, these separate models can be aggregated using native Excel functionality or VBA code, depending on the complexity. Aggregate data is then fed into the subsequent steps.
With PTO, holidays, conferences, training and other demands that pull people off the job, it’s important to have the availability of your resources at your disposal. If your firm is large and this information is stored in a separate database, it can be pulled into Excel with a data connection or an export/import procedure. If your firm is small, an interface can be provided to enter this information directly into Excel.
Here is where the fun begins. For each project, location or business unit, you get to pick who you want on the job and when. Alternatively, you can provide us with logic so we can have fun developing an algorithm for use in assigning people automatically. Either way, a single person can only work up to one FTE per day. Unless, of course, you like to work your people at, say, 120% FTE. At some point there is a limit to how much a single person can work before you will have to assign another resource to fill the need. That limit will be part of the logic that you will need to provide us, if we automate this process.
Here is where Excel does a really great job. With the data from Steps 2 and 3, nice visualizations can be created to let you quickly determine where you are over or under staffed.
Finally, with all the data in one place, Excel can create all the reports you need at the click of a button. No more pouring over different spreadsheets for hours trying to figure things out. Patient care facilities rely on our applications to show them how they are doing in meeting the documented and required hourly care needs of their patients. These facilities not only need to ensure they are managing their staffing according to their own company policies, but they also have to maintain adequate staffing to meet regulatory requirements.
ESW is a professional Microsoft Consulting firm specializing in Excel, SQL & O365. Contact us today for a free chat regarding your Microsoft Excel consulting needs.
I can not recommend ExcelHelp more highly. We had been struggling to complete a critical project and finding them was a lifesaver. Tom was knowledgable, professional, personable, patient and responsive. Look no further for your database programming needs. Thanks Tom and ExcelHelp.com!Randy Hartnell
We anticipate a long business partnership with ExcelHelp and look forward to working with them. I have been nothing but impressed with your firm’s services, your team members tenacity and the overall results. Sometimes you have to travel a bumpy road trying different firms until you find the one that fits.Posted By: Charlene Faber
Chief Operation Officer, Current Builders
I’d like to express my gratitude for the help and cooperation we’ve received from your entire organization during the development of our Modeling Utility. Over the past several weeks we’ve engaged key customers worldwide...We have confidence that this effort will add significant capability and value to the overall success of the program.Business Development Manager
Network Architecture and Strategy
Posted By: Marty M.