+ Post New Thread
Results 1 to 3 of 3
Scripts Thread, Add bottom depth in Coding and Web Development; Hi, I have a spreadsheet of data with top depths only for a number of layers. The spreadsheet is structured ...
  1. #1

    Join Date
    Apr 2014
    Posts
    5
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Add bottom depth

    Hi,

    I have a spreadsheet of data with top depths only for a number of layers. The spreadsheet is structured as follows (only Layer_name and Top_Depth columns):

    Layer_name Top_Depth BottomDepth
    T-layer 3105.26 3127.21
    T-layer 3127.21 3135.31
    T-layer 3135.31 3135.31
    V-layer 3012 3030.8
    V-layer 3030.8 3101
    V-layer 3101 3108.2
    V-layer 3108.2 3112.6
    V-layer 3112.6 3112.6
    Y-layer 3305 3305.9
    Y-layer 3305.9 3327.2
    Y-layer 3327.2 3331.6
    Y-layer 3331.6 3331.6
    Z-layer 2916 3014
    Z-layer 3014 3014


    I would like to do the following: (desired results are shown in red in the bottom depth column)

    1. Add a third column called Bottom_Depth
    2. In each layer, take the top depth of the next line to be the bottom depth of the previous line
    3. When it reaches the end of that layer, it will copy the top depth to the bottom depth column.
    4. It then continues with part 1 and part 2 above for the next layer.

    How do I achieve this with a script? There are 900 layers, each layer with at least 10 lines (rows) of depths.

    Regards,

    Raury

  2. #2

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,696
    Thank Post
    335
    Thanked 515 Times in 483 Posts
    Rep Power
    179
    Wouldn't even bother with a script if you have it as a spreadsheet etc

    Just use an if statement
    Code:
    =IF(C5=C6,D6,D5)
    etc.

    ifvalue.png

    Like that right?

    Steve

  3. #3

    Join Date
    Apr 2014
    Posts
    5
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi Steve,

    Many thanks

    Raury

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 17th January 2011, 02:36 PM
  2. Xfire Group/messenger - Add your alias here
    By ZeroHour in forum Gaming
    Replies: 30
    Last Post: 20th March 2010, 02:55 PM
  3. Net Support add a new product to their range
    By Dos_Box in forum General Chat
    Replies: 2
    Last Post: 15th June 2006, 09:34 PM
  4. Cant add HP 1100 DTN to Server 2003
    By ChrisH in forum Hardware
    Replies: 1
    Last Post: 8th December 2005, 10:53 AM
  5. Add printer script not workling
    By mark in forum Windows
    Replies: 6
    Last Post: 15th September 2005, 10:07 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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