resource

Hi everyone, I'm trying to create a worksheet that will allow me to dynamically forecast resource requirements for projects. The idea is that the sheet requires data relating to project start and end dates, as well as the estimated resource effort at the project's maximum. Using a 'standard'...

Hi, I've got a resource plan spreadsheet and its functioning fine, but i was wondering if anyone can suggest how i can get it to exclude weekends and holidays. my forumula is: =SUMIFS(Table1[[Hours/Day]:[Hours/Day]],Table1[[Resource Name]:[Resource Name]],Report!$B17,Table1[[Start Date]:[Start...

Background: I am trying to build a rough what-if tool for team resource planning. I have separate sheets for different projects. I have a summary sheet that has totals. I can sum cells for a given resource across the sheets to show all planned work by person for a given time period, however if...

Hello, I hope everyone is doing good. I am looking for some recommendations regrading the Resource Management and Planning Software. Is there a software, where I can manage and plan my organizational resources (Like a resource planning calendar). Also, everyone should have access to this...

Hello: I have a large table where I need to find and then highlight the records that appeared for the first time last month. In case of the sample below, that would be to find records that include Resource C. Thanks for any ideas! Date Resource <tbody> 4-30-19 A 4-30-19 B...

Hello Everyone, I am interested in learning about Add-Ins, specifically how to make them. Any helpful resource you know about??? Any links to guide, videos etc. Regards,

Hi everyone. I want to get very good at VBA. I'm no rush to learn it. I think maybe in a year's time I can get very good at it. I want to know whats the best way to learn it? What are is best resource to learn it in the easiest way possible?

Hello, I've created a resource scheduling tool for my company that is based on days per weeks, projects that each resource is working on etc. I have a sum up at the bottom to ensure that each resource is not over allocated in each particular week, but as the number of projects is increasing, i...

This is my first post on the forum – so hello to you all and many thanks for reading this. I am by no means new to Excel/VBA – but have come up against an issue which is making me feel like a real newbie! I sincerely hope someone can tell me where I’m going wrong. I have an issue with an...

Hello, I'm designing a resourcing spreadsheet and am trying to customize the formulas so it only calculates numbers for the rows that are filtered out/visible. From somewhat similar posts, it seems like I should do something with the sumifs and function 9. I got stuck after dealing with the...

Hi There, I'm looking for some assistance with a formula I've been stewing over for a couple of days now and would appreciate some assistance. I am putting together a spreadsheet to help with forecasting where I have an input template that will feed a formulated forecasting vs. actual calc...

Hi all, I'm attempting to consolidate a big block of data with two columns and a reference to a month into a summary table and I can't seem to get there. Essentially I want to sum for example, all the items in the reference table that are CAPEX and Labour for the Month of September into the...

Hello :) I am using excel to demonstrate supply Vs demand, with regards to project resource capacity. What I am trying to achieve (using conditional formatting), as a look up between two sheets, that identifies IF (name) in Sheet 1, has a capacity less than usual in Sheet 2, then highlight the...

<tbody> Table from Task sheet A B C D E F G H W X Y Z AA AB AC AD AE AH 2 ID Project Name Task ID Task Description Task Type Start Date End Date # of Days Resource 1 Resource 1 Contact Resource 2 Resource 2 Contact Resource 3 Resource 3 Contact...

Hi, I have been asked on a high level to show my resource utilization for my department. The tool has to be used by others than myself. We do not want to register hours etc., but just track allocation on a quarterly basis by inputting the percentage each resource is allocated to what...

Hello, I am working on a spreadsheet that has the following setup. What would be the best way to find out which projects each person is on? I was thinking of doing a vlookup, but I would like to know if there is a better alternative. <tbody> Project Resource 1 Resource 2 Resource 3...

Hello, I am trying to set up a formula in a workbook to firstly highlight a range of cells between two given dates. Secondly I am trying to populate these cells based on start and finish dates and the quantity of resource for a given item. Duration Column J =((H49-G49)/5)+0.2 (Where 0.2 is 1...

Hello, I am struggling with finding a way to solve this problem. I would really appreciate your support. I've got a spreadsheet with tasks and the dates they start and end and who does them (resource)... I want to create another spreadsheet that shows me who does what on which day.. this pic...

Hi all, I've been struggling with a formula that I am trying to get to work and want to ask if anyone can assist. I have a workbook with named ranges and a named table. The named ranges are called, DATE, NAME, and WORKED. The table is called RATECARD and has headers NAME, RATE, RESOURCE, RATE...

All, I have a situation where I need to calculate within a pivot table. I need to calculate a delta between two columns that are at the second level. In other words, the elements that need to be calculated are pivoted and not their own individual field. Is there a way to do this. If it...