Sorting triplets...
Situation: chemical reactants are measured; samples are mixed, each sample is
measured in two different enviroments, samples are measured in triplets, the result should be an ideal path of the reactant through the changes of the environment. Algorithm: triplets of values - the amount of triplets is given, the range of values is given (confined) - I need to sort (extract from) these triplets in a way that - all values from the given range are covered by the selected triplets (which will cover the whole path of the reactant through the changes of the environment) and each value repeats between two triplets (this covers the measured differences). an example might look like: From these: {3,223;3,223;3,224} {0,121;0,122;6,782} {6,782;0,122;0,122} I need to get these: {3,223;0,122;6,782},{3,223;8,456;12,354},{33,012;8 ,456;6,782},{33,012;12,354;0,122} This wouldn't be a problem if I had the time to code a simple C app...but - how do I do this in Excel? Thank you for any ideas! |
Sorting triplets...
What algorithm is used to derive the second set of numbers from the first?
"Mac" wrote: Situation: chemical reactants are measured; samples are mixed, each sample is measured in two different enviroments, samples are measured in triplets, the result should be an ideal path of the reactant through the changes of the environment. Algorithm: triplets of values - the amount of triplets is given, the range of values is given (confined) - I need to sort (extract from) these triplets in a way that - all values from the given range are covered by the selected triplets (which will cover the whole path of the reactant through the changes of the environment) and each value repeats between two triplets (this covers the measured differences). an example might look like: From these: {3,223;3,223;3,224} {0,121;0,122;6,782} {6,782;0,122;0,122} I need to get these: {3,223;0,122;6,782},{3,223;8,456;12,354},{33,012;8 ,456;6,782},{33,012;12,354;0,122} This wouldn't be a problem if I had the time to code a simple C app...but - how do I do this in Excel? Thank you for any ideas! |
Sorting triplets...
That's the one I describe above: all (or as much as possible) values are
covered and each is repeated throughout two triplets. "Mike H" wrote: What algorithm is used to derive the second set of numbers from the first? "Mac" wrote: Situation: chemical reactants are measured; samples are mixed, each sample is measured in two different enviroments, samples are measured in triplets, the result should be an ideal path of the reactant through the changes of the environment. Algorithm: triplets of values - the amount of triplets is given, the range of values is given (confined) - I need to sort (extract from) these triplets in a way that - all values from the given range are covered by the selected triplets (which will cover the whole path of the reactant through the changes of the environment) and each value repeats between two triplets (this covers the measured differences). an example might look like: From these: {3,223;3,223;3,224} {0,121;0,122;6,782} {6,782;0,122;0,122} I need to get these: {3,223;0,122;6,782},{3,223;8,456;12,354},{33,012;8 ,456;6,782},{33,012;12,354;0,122} This wouldn't be a problem if I had the time to code a simple C app...but - how do I do this in Excel? Thank you for any ideas! |
All times are GMT +1. The time now is 10:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com