period

I am trying to discount cumulative interest over a period of time. Say I have an original mortgage for $100,000 and a term of 60 months, then the borrower prepays on month 1 for $50,000. I want to know what the cumulative interest lost over that period is at a discounted rate of 15%. I want...

Hello, Is it possible to insert a second grand total in the pivot table? My pivot has period averages and period actuals, could be 3 or 4 periods, hence 6 or 8 columns. The grand total is for actual, but i want to insert a second grand total for the averages. If a second grand total can't be...

Hi There, This is my table and I need to compare prior period to current period for any location that has less than -40% change and greater than 50% over the prior period. <colgroup><col><col><col><col></colgroup><tbody> Emp ID Location hours period 653521 A000101 80 201821 653521 A000101...

Hello, Let s say we have this columns and rows 1. A. B. C. D. 2. Name. 01.04.2018. 03.04.2018 2 3. Name. 05.04.2018 10.04.2018 5 This is the Main Page on my worksheet. My questions is, i need to sort all period...

Hi, I wonder if anybody could assist me in a smoothingformula I am struggling with, In this scenario I wish to take the replacementvalue/period of an item based on several inputs and in some instances smooththe resulting smooth the output over either 3,5,7 periods equally eachside of the...

Hello, I making a finance tracking file, Tab 1 - Summary - An overview that will change based on the selection I make Tab 2 - Details - List of every invoices with Period name (October 2018) and Tax code like "xxx" and Invoice amount Tab 3 - Data - So far just a list of Periods that a...

Hi, i have a data base with x values (time/dates) and y values (price). I have created a line chart, that show the price changes over e.g. a two year period, with each x being every 4 weeks. So far so good. However, i would now like to create some kind of formula or macro to identify the...

Below is a portion of a macro that saves the current workbook, prompts the user to SaveAs, and then (not shown) it clears the workbook to start a fresh period/quarter. On our LAN, when it prompts to SaveAs, it defaults to My Computer, is which is a terrible navigation to get to the right...

HI Everyone, I have some vba code that I’ve been using for years that I use to project the recoveries of an asset over some period of time according to a vector. So if I have cash outlay in period 1, I have a curve that recovers that cash amount over some period time (let’s say 24 months)...

Hello - ran a search and couldn't find a thread with my specific question. I am looking to formulate an IF function that has a defined start and end date that also performs a calculation if the original if logical test is met. For example: I am projecting to save $100 over a 12 month period...

Hi, I am trying to find a formula that will look up numbers of one worksheet and give me totals on another worksheet. The specifics: Column A Column B Column C Room # Class period The enrollment count The catch is that some classrooms and periods are listed twice, as two...

I have a table below for period. Sheet 1 <tbody> Start Date End Date Period 2/4/2018 3/3/2018 Period 1 3/4/2018 3/31/2018 Period 2 </tbody> Sheet 2 Has Hire date column C2 (2/15/18). I am looking for help to whether I can use if formula to say 2/15/18 fall in Period 1, whereas if is...

Hi all, This one has stumped me and I can't find the answer online. I need to sum a series that increases by a percentage each period. However, the percentage it increases depends on the number of periods. I.e., if it needs to increase from 80K to 100K over 3 years, the annual percentage...

Hello, I have built a spreadsheet to handle my finances (formulas only, no VBA), and now I am stuck with a formula that I thought would work... but just doesn't. Any help to fix my formula would be greatly appreciated :) In my spreadsheet I have: - the 'Expenses' table with "Account from" and...

hi, Can some canny person provide me with the applicable VBA based on the following criteria?:- when the date in cell B2 is the same as the date in D2 a popup message stating ' end of period, new date required in next input' would also prefer the text to show in bold red & font 16. Many...

I have a structured table, and there are three different columns representing a monthly period in the format YYYYMM (201809). The first is system generated, the second column is a manually input override period, and the third is a formula that takes the latest of the two periods. When I click on...

I have an Excel worksheet that has Overtime (OT) data for each person in the company summarized per pay period. My objectives in Excel are as follows: 1. Show a current pay period summary of OT hours by department (sorted with most hours at top); If the solution is within the PivotTable it...

Hi, I need a macro to delete a row and the next 5 rows based on what is in the first row. In Column A, wherever "Daily System Time Period Menu Items Report" appears, I need that row and the next 5 rows deleted. On the 6th row after "Daily System Time Period Menu Items Report", I need that cell...

Hey there, New to DAX so any help is appreciated. My goal is to understand how many customers cancel in a given sold date. Basically how many items did we sell in a given time period vs how many cancelled in that same period. What I'm trying to do is count the number of rows where [Cancel...

Good morning/evening, I have a file that shows products in a column. Next to the same individual product column, I have three criteria: unit cost, volume and cost for the period. Then next do it I have the sums of year 1-2-3 and so on and next to that I have the columns showing he monthly...