Results 1 to 5 of 5

Distribute rows proportionally to a column value

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2017
    Location
    portugal
    MS-Off Ver
    2013
    Posts
    4

    Distribute rows proportionally to a column value

    Hi,

    I have a spreadsheet with coordinate values. Each row as a value for x, y, z, and time. The problem is that the space coordinates were taken at different time intervals. When I import this data to an animation software it creates a frame for each row of coordinates, which is great, but because the time difference between rows isn't the same my object will have different speeds at each position coordinate.

    What I would like to figure out is how to distribute the rows according to a linear variation of the time value. I wouldn't mind having empty rows, that would even be ideal.

    I'm attaching a print screen of this. My problem is that the file has over 500k rows of data.

    Thanks in advance for your time.

    Best regards,

    Rui
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need to adjust totals proportionally
    By jdp0062 in forum Excel General
    Replies: 2
    Last Post: 11-06-2014, 01:33 PM
  2. distribute rows based on column content
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-17-2014, 12:04 PM
  3. Replies: 4
    Last Post: 11-22-2013, 06:37 PM
  4. [SOLVED] VBA to distribute data in column into columns and rows
    By AWM1966 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2012, 07:48 PM
  5. change numbers proportionally to sum up to 100
    By MichaelSSSS in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-08-2010, 06:42 AM
  6. code to change values proportionally to always sum up to 100
    By MichaelSSSS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2010, 05:59 AM
  7. [SOLVED] proportionally fill a cell
    By M John in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2006, 05:20 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