+ Reply to Thread
Results 1 to 4 of 4

Maybe an Advanced problem, or simple.

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    New York
    MS-Off Ver
    2013
    Posts
    2

    Maybe an Advanced problem, or simple.

    (I apologies in advance if this problem is more leaning towards a math problem than excel)


    The issue has to do with an object on a line with 4 pass through stations, this object moves back and forth on the line. The major problem I'm having is figuring out how to calculate and display each distance each station is from the moving object.

    What should I be looking into to solve this, and also could excel handle something like this?

    (I've included a picture to better visualize the problem)

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,701

    Re: Maybe an Advanced problem, or simple.

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    10-29-2014
    Location
    New York
    MS-Off Ver
    2013
    Posts
    2

    Re: Maybe an Advanced problem, or simple.

    So as I've stated in the original problem but forgot the picture here is the picture.
    dot problem.png
    (The stations are the space in between the yellow boxes)

    TO restate again, how do I have four excel boxes(Either rows or columns) change simultaneously as the position of the red moves further and closer to some stations?

    What I've done in the excel sheet,'before', I've added nothing in. The 'before' sheet just shows the red dot's position in length to each station as it moves from left to right on the line.

    Problem again is to have four independent boxes advance through these value ranges shown in in the 'before' sheet.

    The 'After' Sheet is what I did in an attempt to have something progress through these values. I tried a y=mx+b but no success.
    Attached Files Attached Files

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,676

    Re: Maybe an Advanced problem, or simple.

    I don't understand at all what you're trying to do. Could you provide some context?

    Object on a line? Stations?
    Entia non sunt multiplicanda sine necessitate

+ 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. Advanced Filter Problem
    By M_Easty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2013, 06:42 PM
  2. simple "if function" moving to more advanced functions later
    By michael55moss in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-24-2013, 07:26 PM
  3. Advanced Filter Problem
    By bjwade62 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2012, 10:47 AM
  4. Replies: 2
    Last Post: 09-19-2007, 07:00 AM
  5. Advanced Filtering problem
    By george-smith@work.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2006, 11:10 PM

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