+ Reply to Thread
Results 1 to 4 of 4

Cost savings model equations

  1. #1
    Registered User
    Join Date
    08-21-2015
    Location
    California, USA
    MS-Off Ver
    office 2013 365
    Posts
    2

    Post Cost savings model equations

    I am trying to enter an equation in excel to help compare two percentages BETWEEN TWO GROUPS - a control group and an experimental group that are either (-) negative (aka saved money, because costs at the the end of year are LOWER) or LOST money (+) positive value(aka because costs at the end of the year are HIGHER). I have shown a few numbers and values just as an example.

    In this example:
    Control Group = A
    Experimental Group = B

    Here is what i am trying to input:

    Value
    ++ Cost increase
    A>B: A and B lost money, but A lost more money than B, subtract B-A *-1= -8% savings
    A<B: A and B lost money, but B lost more money than A, subtract B-A = +8% loss

    Mix Cost increase and decrease
    +- A>B: A lost money and B saved money, add ABS[10:2] *-1 (-12%) savings (note excel wont let me do ABS since this is a %)
    -+ A<B: A saved money and B lost money, add ABS[10:2] (+12%) loss

    -- Decrease in costs
    A>B: A and B saved money, but A saved more money than B, = B i.e. -2% (keep at -2%)
    A<B: A and B saved money, but B saved more money than A, B-A = - 8% savings

    PLEASE HELP. EXAMPLE WORK BOOK ATTACHED
    Attached Files Attached Files
    Last edited by AHCmaz; 08-25-2015 at 05:23 PM.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Cost savings model equations

    Welcome to the Forum AHCmaz.

    I am having difficulty understanding the written descriptions. Uploading a sample Excel workbook (not pics or links to third party sites) often clarifies things.
    Be sure to remove any sensitive data. Include enough rows (20-50) to show what you are starting with and include a few examples (hand typed if necessary) of what the goal is.

    To upload a sample Excel workbook click Go Advanced just below the reply window and at the bottom of the page click Manage Attachments. When the file is uploaded click Done.
    Dave

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Cost savings model equations

    Hi, welcome to the forum

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    08-21-2015
    Location
    California, USA
    MS-Off Ver
    office 2013 365
    Posts
    2

    Re: Cost savings model equations

    hi Fdibbins and Flameretired, as requested please see newly attached excel file to the initial post! thank you in advance!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 03-06-2015, 03:20 PM
  2. How to make a time period a variable for this model? (automating the model)
    By pigment01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2015, 12:47 PM
  3. VBA Model : Two Stage Gordon Model
    By elaph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2014, 11:37 AM
  4. Create a model that will generate a column of numbers based on model parameters
    By tncanoeguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 05:47 PM
  5. [SOLVED] Duration of phone call and total cost.....how to work ut cost per minute ?l
    By monkeyman90210 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2012, 04:18 AM
  6. [SOLVED] Outputing engineering cost based on total cost of project. Looking for help with matching
    By cadamhill in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2012, 09:31 PM
  7. Cost Driver calculation - Looking for formula/macro to calculate manpower cost alloca
    By Swastik Banerje in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2009, 11:18 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1