projected

Hi guys, I am very new to VBA and I am looking for some help with some code that would help me at work, basically I am looking to optimize a simple dashboard for my projects Workplan for the year. The table on "2019 Plan" shows the number of projected days and to the right of it the actual...

I'm trying to find the required corpus for the following: Present Value = 200,000 20 years to retirement 30 years total retirement Projected inflation = 2% Projected growth = 6% Annual withdrawal will be $115,000 To meet the $115,000 with 2% inflation and 6% growth requires a corpus of...

I cannot for the life of me find a good resource on how to effectively use solver to "solve" my problem. Column B has projected points, and column C has a corresponding salary. The goal is to maximize total projected points while not using more than 50k in salary and must use 6 players...

Hi, my worksheet has a date manually entered in A1, I use the formula =EDATE(A1,6) to project the date 6 months ahead in A2. In A3 I manually enter “pass“ of “fail“. I would like the date in A2 to only be projected if A3 reads “pass“. Thank you very much.

Not sure if this is doable. I have a spreadsheet approximately 200 rows with 12 columns for weeks in a quarter. Each column has a (projected) number that could be between 0 and 99 (usually not that high though) Those numbers go through each column and then I do a sum in the last column...

http://<a href="http://s33.photobucket.com/user/phifer8390/media/excelimg.png.html" target="_blank"><img src="http://i33.photobucket.com/albums/d76/phifer8390/excelimg.png" border="0" alt=" photo excelimg.png"/></a> I would like a formula calculate the sum of a row based on the last 12 months...

I am trying to find a formula that will handle calculating "Income Surplus/(Deficit)" regardless of Total Operating Expense calculating a positive or negative number. For example: Projected YE Income is 5,260,162 Projected YE Expense is 6,328,910 Hard Income Surplus/(Deficit) is -1,068,748...

Hello, I need help formatting an excel spreadsheet. I am not sure if it will require a macro or a basic formula. The spreadsheet has 4 columns: Duration (B1), Projected Start Date (C1), Projected Finish Date (D1) and Actual Finish (E1). The first three columns - duration, projected start and...

Excel 2013 I have a sheet that has projected hours for my team. I want to be able to enter in the actual hours used at a later time and get a sense of how accurate are projections are vs actual hours used. I would like to have the comparisons on a different spreadsheet so as not to clutter our...

I have tried with all my knowledge to try and figure this out but with no success.:mad: Scenario. March has 31 days in the month (this would be entered into the alllocated cell) We do not work Sundays so less 5 Sundays (this would be entered into the alllocated cell)= 26 Working days. Last...