nepotist
05-04-2011, 10:53 AM
Hello,
I have a spreadsheet with about 10 tabs, each representing data for a unique feature and I have another spreadsheet that I would like to update by looking up data from respective tabs.
Example:
Spreadsheet with 10 tabs has the data in following format
ID From To Data1
13175000 0.000 0.690 a
13175000 0.690 1.344 b
13175000 1.344 2.020 a
13175000 2.020 2.279 c
13175000 2.279 2.300 d
13175000 2.300 2.929 a
13175000 2.929 5.233 b
Spreadsheet 2 where the data needs to be updated
ID From To Data1
13175000 0.000 0.690
13175000 0.690 1.344
13175000 1.344 2.279
13175000 2.279 2.929
13175000 2.929 5.233
I need to retrieve values for column data1 from spreed sheet 1. If you notice the spreadsheet 2 has different from and To Example: in Spread sheet 1 tww data points 2.279 to 2.300 and 2.300 to 2.929 are merged in to one data point in spreadsheet 2. I would Like to either calculate weighted average in this case or take the data from larger point i;e 2.279 to 2.300 has a length of 2.300-2.279 = 0.021 and has value "d" while segment 2.300 to 2.929 (length 2.929-2.300 = 0.629) has value "a", so the value in spreadsheet 2 for data 2.279 to 2.929 should be "a", the value of larger data point
I hope I was able to explain it better.
Any help is appreciated.
I have a spreadsheet with about 10 tabs, each representing data for a unique feature and I have another spreadsheet that I would like to update by looking up data from respective tabs.
Example:
Spreadsheet with 10 tabs has the data in following format
ID From To Data1
13175000 0.000 0.690 a
13175000 0.690 1.344 b
13175000 1.344 2.020 a
13175000 2.020 2.279 c
13175000 2.279 2.300 d
13175000 2.300 2.929 a
13175000 2.929 5.233 b
Spreadsheet 2 where the data needs to be updated
ID From To Data1
13175000 0.000 0.690
13175000 0.690 1.344
13175000 1.344 2.279
13175000 2.279 2.929
13175000 2.929 5.233
I need to retrieve values for column data1 from spreed sheet 1. If you notice the spreadsheet 2 has different from and To Example: in Spread sheet 1 tww data points 2.279 to 2.300 and 2.300 to 2.929 are merged in to one data point in spreadsheet 2. I would Like to either calculate weighted average in this case or take the data from larger point i;e 2.279 to 2.300 has a length of 2.300-2.279 = 0.021 and has value "d" while segment 2.300 to 2.929 (length 2.929-2.300 = 0.629) has value "a", so the value in spreadsheet 2 for data 2.279 to 2.929 should be "a", the value of larger data point
I hope I was able to explain it better.
Any help is appreciated.