projects

I would like to calculate the IRR of multiple different projects, I try to take array of cashflow and dates of different projects, then using XIRR, but XIRR can only calculate continuous data. Below is a simplify sample, I can manually put all the data of one project together, but I can't do...

Hello, I am preparing Financial statements for many projects using the same pro-forma template on monthly basis (12 columns) and about 150 rows. For some projects all rows will have numbers, for some projects may be 70% of rows are empty. Is it possible to have a macro to hide empty rows that...

Hi everyone, Ok so what i'm trying to do is this. I have a document Called "Master Dashboard" with a sheet Called "Projects Data" In this sheet Row1 has Headers of Project1,Project2 etc up to Project20 (A1:U1) I have a Folder on my desktop called "Projects" in this folder are up to 20 excel...

Hi All, I have to populate a 3x4 table that is a list of our corporate projects. The projects belong to only one Division and Tier at a time. Projects progress from Tier 3 to 2 to 1. The data is sorted like this: <tbody> Proj_Name Tier Division Project A 3 Operations Project B...

Hi! So in my 8th hour of trying to figure this out I've decided to bring in reinforcement ;-) I'm not even sure if the thing I'm trying to do is possible, so I'm hoping you can help me out! So what it is, is the following. I'm creating an hour log that also allows me to divide my day up in...

I have a schedule of Project level activities that encompasses tasks spanning multiple separate projects. Each Project is individually implemented at a different business location around the globe. However, any individual location may be impacted by the schedule of more than one project in the...

VBA noob so any help is much appreciated as I have tried but failed to do this. I am using the latest version of Excel. I need to be able to show/hide project rows depending on the value a user enters into a cell from a drop-down list in row 2 at the top of column in question. My sheet has a...

New here and to macros in Excel. Would really appreciate your help with a sorting macro! I have projects listed out in rows with various data in columns. I'm trying to create macro buttons that sort the projects & data. Since I add projects to the group and didn't want to update the macros...

Hi All, I'm new to PowerPivot and running into an issue with searching between 2 tables. I setup 2 tables in PowerPivot and created a relationship between them. I am trying to count the number of instances a user shows up in a specific column. The column may contain several users within the...

In the Excel VBA editor window, is there a way to have it open with all projects collapsed by default? Every time I open the window to edit a macro, my Personal XLSB file shows fully expanded, which I don’t like because it takes up space and I have to manually collapse it to see the other...

I know this looks daunting, but please don't turn away just yet. :) The concept of what I'm trying to achieve is simple, but requires a lot of detail to paint you the right picture. I'm trying to create a way for users to assign colors to projects in a dynamic list. So when the user makes a...

I'm not sure if this is possible but I'm trying to get an average of a column of only cells highlighted in a certain color. The column has GM% of projects. The color coding I'm using is as follows: Green for current Projects Blue for up coming projects Red for projects ending soon I would...

Modification to the attached excel sheet that uses Microsoft Power Query as follows. Keep all functionality working with these modifications. Employee Schedule Sheet- Option to sort by trade I would like the option to sort by trade then jobsite then alphabetical… Also dates should remain in...

Hello, I'm needing help figuring out a way to tweak a formula that I use on a spreadsheet at work. I use the formula below to track active unique projects and it works fine as long as my only criteria is not counting blanks...

Hi All I was wondering whether someone could advise. I have been following this tutorial on Dashboards: https://www.powerusersoftwares.com/single-post/2016/10/17/How-to-create-impressive-Excel-dashboards I'm using a pivot table to create a pivot gantt chart. I have a list of "projects" as...

Dear All, I have a database of projects and I need to filter to those projects which were active in 2016. Column J contains the projects' start date, column K contains the projects' end date in a mm/dd/yyyy format. So I do not want my filtered list to contain projects that run out of this...

Hello and thank you for any attention my post may receive. Is it possible to update a MS Project's resource list from an excel file via vba?

Hi, I am new to the forum and need some help with an excel formula. I was wondering if there is a way to count the number of projects that will be running in any given month based on the start date and the end date of a project. I have tried the COUNTIFS function but cannot seem to get it...

Hi, I have a question. I have an excel file with a long list of projects with versions of this list and I want to delete or hide all projects but the latest version. Is there a way to do this? Below an example of the type over versioning. The idea is that I want to have a filter that takes...

I have projects in 1 worksheet which i have some ratings with delivery date. Also I have gantt chart in different worksheet excel created based on all projects. Question is how do I render the gantt chart to be updated based on changing the ratings of the project. Any help please? I have put...