contract

Hello: (Please note I will add an example of the workbook tomorrow) if anyone feels they have an answer from my description, I’d be very grateful for a response: I have a workbook that is used as a calendar to manage a team of employees working across multiple contracts. The workbook...

I have three workbooks open, I've completed my tasks on the first workbook (Adjustment Report) and now I'm ready to complete my tasks on the second workbook (New Rental Contract). I want to activate the new rental contract report and put a filter on column O to filter for Takeover, the coding...

I have a header and rows of data that looks like so: <tbody> Status Contract Number Comments Advertised Closed Evaluated Contract Value Awarded Executed 1 waiting on david 20/11/17 30/11/17 1/12/17 $50,000 Open 2 Finalising contract 10/11/17 16/11/17 Open 3 not sure 5/11/18 10/11/18...

I am trying to put the same monthly revenue into the correct months based on a start date and end date. I have the formula to equally split the revenue over these months but I would like to have the same number in each box. I have attached what I currently have and an example of what it should...

Hi I'm trying to write a formula in the grey cells which looks at the contract start date in column A and the current month e.g. DA30 then takes the data from the range in yellow and puts it into the corresponding month..... the start dates will be variable so I want the data in the grey cells...

I'm trying to write a formula to work out future potential monthly revenue based on contract start dates and their associated payment terms and value... hopefully someone can assist The input cells would be: Column V from cell V12 is the contract monthly value Column W from cell W12 is the...

Excel 2013. My user has a cell in which he enters contract numbers one after another in the single cell, ie., 123456, 234567, 345678, etc. The cell is 15 characters wide and the default height. He does not want the cell size changed. Each day, or several times a day, he has to add a new...

Hi, Hope I'm asking this in the right place! I'm using Web Intelligence Rich Client. I have lots of account number that can have many Contract types assigned to it. I want to list all the account that DONT have "With Maintenace" logged against it (but could have various others). I have...

Hi all, I have this line in a waiver: ="That the total amount of the contract including extras is $ "&D35&" prior to this payment on which he has received payment of $"&F35&" prior to this payment. " Which produces this: "That the total amount of the contract including extras is $ 91855223...

Can't get the formula right. I have two tabs in a spreadsheet with many rows and columns. I need to pull the need contrac t a nd comments from Tab 2 to the corresponding address in tab 1 (which has a bunch of other info in it) Trying to use index match (don't want to use vlookup- long story)...

Hi everyone. I've got a table detailing employee information, including starting and expiring contract dates, with all the relative pivot tables and pie charts. I'm trying to find a way to dynamically get Excel to list every year in between the date the employee started working for us and the...

Good afternoon everybody I have a very large table (14000 rows) of contract data, an extract of which I've simplified here. Each row in that table has a contract identifier ("ID") which may or may not be unique, depending on the complexity of the contract. Within each row, there may or may not...

I'm strugling with a problem. I can get the first correspondence in row, or the last value in a row but what I want is to get a correspondence within a table. I will give an example: Sheet1 <tbody> 01-jan 02-jan 03-jan 04-jan 05-jan 06-jan PersonA Contract A <tbody> Contrat B...

Hello, which formula could I use to find the due date of a maintenance contract based on the maintenance frequency (e.g. every 1 month), start date of the contract and today's date? Example: A security barrier contract: the contract is valid from 10/01/2018 till 10/12/2018. The frequency of...

Hi, I'm quite new in all of this and I came in front of the wall. I have one .xls with a macro that by entering the data and refreshing retrieves the required data from the database. Macro is doing the refresh. We can write more data (example: multiple contract numbers) and by clicking on the...

hi, i want to calculate the weighted average maturity of a list of contracts as at a certain date for multiple dates. In col A, i have the day the contract started, colum b the maturity in years, and column c the amount of the contract. I want to calulcate month end weighted average maturities...

Hi, We take on contracts typically ranging from 3 months to 36 months. we always use the 1st of the month for the start and end dates. for example: Contract 1: 1/4/18-1/12/18 = duration 8 months Contract 2: 1/2/18 - 1/2/18 = duration 12 months Contract 3: 1/1/18 - 1/1/20 = duration 24 months...

Hello all, hope someone out there can help me!! I have a large list of contracts as abbreviated below <tbody> Contract Title Start Date End Date Contract 1 23/10/18 31/12/18 Contract 2 01/11/18 30/11/18 Contract 3 15/10/18 14/12/18 Contract 4 22/10/18 28/12/18 Contract 5 01/11/18...

Dear all, Question. I have a table with contract start dates and contract end dates. I want to cross join this in power query with a table containing all months from 1/1/2019 to 31/12/2039 which are potentially the months in which payments can be done under the contracts. Is there a way in...

Hi, can someone please help me derive a formula to calculate the number of months that would fall within any given Calendar Year based on a contracts start and end date range. For instance, if I had a contract start date of 9/29/2017 and contract end date of 9/28/2020, and I know each calendar...