benefits

1. Benefits released by year and Month

Hi All, I am working on file which has benefits start date for example 01/01/17 and finish date of 30/04/7 with a benefit value \$10,000 and in other cases start date 01/10/17 an end date 30/10/18 Benefit value \$12,000. I am trying to capture cost by year and month on pro rata basis. So I can...
2. NPV & IRR with nested Offset Function help required

I am attempting to understand an NPV/IRR calculation using nested Offset from 2017 to 2027. The formulae are as follows: NPV(C15,OFFSET(D39,0,0,1,C16-1))+C39 Where C15 = WACC, D39 = 2018 net annual benefits, C39 = 2017 net annual benefits & C16 = valuation years IRR(OFFSET(C39,0,0,1,C16))...
3. Question on Access query

Hello, I have a question on trying to run a query. So I have a report that has all my information and I ran a query to pull up all duplicates. I created another query to add up those duplicates. Now I want to to bring those duplicate totals back to my original spreadsheet. Ive been stuck with...
4. Combine Row and Column Data

Hello all, I tried searching for a thread that addresses this question, but I was not able to locate one. I may not have worded my search correctly. I receive a hospital's accounting trial balance that has hospital department numbers as row headers across the row 1 and account type numbers in...
5. Need to find out the employee shift based on his/her login and logout timings

Hi I am Harish. I have login, logout and time spent in work everyday. Need to find out the work shift based on the login and logout values. <colgroup><col span="2"><col></colgroup><tbody> In Time Out Time Time Spent 06/01/2014 12:00:00 AM 06/01/2014 12:00:00 AM 00:00:00 06/02/2014...
6. Work tools - More Simple the Better

Hi everyone! I am an Excel novice looking to use it for a a few simple (I think...) tricks. #1 - There is an excel spreadsheet listing all employee names. I need something to pop up when the sheet is opened to remind us which employees are ready to choose benefits. Benefits are always due on...
7. Benefits of pivot charts/tables over inserted charts

I hope this isn't too ill-defined, but I'm just curious what is the benefit of a pivot chart/table over just highlighting the information and inserting a chart? From what I've got so far, with a pivot table I know I can have a dynamic chart and change the data from the rows to the columns very...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back