calc

  1. R

    quarterly calcs from month numbers

    I've been asked to calculate quarterly dollar spread based on start and end months. I need it in this format. removed bad image Q1 calc is easy, but gets complicated (for me) on the rest. Any help would be greatful. Thank you. <tbody> start month end month total cost q1 q2 q3 q4 3 7...
  2. O

    Golf foursomes problem

    Try this:Here's what I need. 16 golfers put into 4 foursomes every day for five days. Need every golfer to play with each other golfer only once example: Day 1 (Joe -Skip-John-Pete) Day 2 (Joe -Scott - Jason- Harry) Day 3 ( Joe - Craig - Dave -Ken) Day 4 ( Joe - Zilly - Chris - Ed)...
  3. O

    Oh4fore

    4 Rows and 4 columns using numbers 1 through 16 insert in the 16 numbers in all cells using every combinations should be 5 possible groups example A1=1 B1=2 C1=3 D1=4 A2=5 B2=6 c2+7 D2=8 A3=9 B3=10 C3=11 D3=12...
  4. L

    Private Equity IRR Calc

    Hey All, Quick question, I'm trying to calculate an ongoing IRR calc for a Private Equity Investment. For every period, I want to have an IRR calc up to that point. I need to somehow bring in the Fair Value of the fund on that date into the last cash flow of the IRR calc, otherwise the Cash...
  5. W

    Solver macro

    Dear Excel community Goal I'd like to write a VBA macro using Solver. I've no previous experience with macros. I am looking for a dummy guide please. Solver input Set Objective: 'Calc optimised'!$J$14 To: Min By changing variable cells: 'Calc optimised'!$E$3 Subject to the constraints...
  6. S

    Using VBA Replace Function to Edit Formulas

    I'm trying to create a loop to Find and Replace parts of formulas on my sheet labeled Output. With my current code, the replace function isn't working and I suspect it's trying to replace string functions only. I need this to alter the formulas. For example here is my array on Sheet1 with column...
  7. I

    Basic error in my code that I'm unable to identify

    Hi There's something in my below code that causes the workbook to hang either during or immediately after the named procedures run and I strongly suspect the cause is either in the first or last 4 rows. Private Sub Worksheet_Change(ByVal Target As Range) CALC = Application.Calculation...
  8. M

    IF and ProductIF Functions

    Hi, I need help with this simple calculation in Excel that I am having difficulty with. I have tried couple of formulas so far and nothing is giving me the correct answer. The formulas are displayed in "MyProduct#1" and "MyProduct#2" columns. So the "Original table" is what I am working with...
  9. R

    Copy / paste / insert anything in file taking to long, even with calc off

    I have been using Excel since it came out. Never really had this issue come up. On large files with a lot of calculations, I keep the Calc off which allows me to insert rows, columns, cut and paste without delay. Files over 100 MB, multiple pages - not a problem. But now I have a spreadsheet...
  10. N

    Excel Sheet Calc vs Workbook Calc

    Hi, May be obvious but I have noticed in a file I'm working in, if you do a sheet calc (Shift+F9) the check that is built in is zero. However if you do an F9 calc, i.e. the whole file, a difference appears even though nothing has changed. My guess is something to do with iterative calculation...
  11. S

    VBA / Rounding

    Hi there! So I am doing comparison reviews between a system calc and also using VBA to calc % based on criteria. Column T contains tenure. Our system rounds 4.9986 to 5.0, but 4.9900 would round down to 4.0. Is there any way to properly round up / down to nearest whole # based on the above? Ty!!
  12. B

    Change event triggered after macro is finished

    Long time browser, first time poster. I've got a problem with a worksheet change event being triggered after I manually run a macro. The issue is that the change event actually happens before the manually run macro is even started. I've duplicated the issue in a much simpler example. Code...
  13. R

    Using end of month function to calculate monthly cost

    Hello All, I have the following formula below. If I am using 6 30 2018 as the end date, the range the following provides is YTD (Jan1 18' to June 30 18'). Now need calendar year however so should I be using EOMONTH ? Or something else. Data!$A:$A is a column of monthly dates. B2 = 6 30 2018...
  14. R

    Data Table Replication

    Hello, I am trying to use a data table for inputs and another data table for calculations based on the Inputs from the Input Data Table. So therefore I wish to replicate the data exactly in the Calc table as it is in the Input table and then add columns for my calculations to the calc table. I...
  15. E

    How can i do a LIFO calc in excel?

    Hi, Is there a way to do a LIFO calc that reduces the older invoice and adds in the newest invoice? Making the average number of days outstanding change?
  16. P

    trying to shorten an if statement - must be some other function

    I'm using =if(d3*e3/f3+g3<>0,d3*e3/f3+g3,0) Isn't there something similar to iferror(x,0) - that simply returns x as long as x is not an error. A number of times - I need to test if something meets some condition and if it does I just want that value returned and if not I want a zero - but...
  17. D

    Please help Adding a count of unique values to a current calc

    Good morning, The below calc works as it should. I now need to add to this calc using the below as a criteria and counting total unique values from column $B:$B if they meet the below criteria. =COUNTIFS(SURVEYS!$N:$N,"=Jacksonville",SURVEYS!$A:$A,"=ANSWERED") Please help
  18. M

    Peak/ Off-Peak/ Shoulder calc

    HI, I have a mechanical schedule spreadsheet where i calculate all buildings energy consumption. I have to calculate Peak / Off Peak and Shoulder consumption. I am hoping someone can assist with the required easy calculation. I have bee given the sheet from a previous employee with calcs...
  19. B

    Vba Formula Array Calc

    Trying to calculate the percentage of projects meeting the target for each year. Here's what I came up with. Maybe there is a better way to do this, but I need it to work dynamically with changing data. What I have so far doesn't seem to return anything, just a null value... 'P-Std Calc...

Some videos you may like

This Week's Hot Topics

Top