Im still working on pipes, so now i have to calculate insulation (U) with TWO parameters that i already have (interieur diameter (DI), Material) with ONE that i still have to calculate (exterieur diameter(Dext, depends of Di and Material)) and ONE fix number(8).
The problem here is that i dont know if the list will still save the same order, for example in the next image, will the new list with the U value still match with the right insulation type row ?
We have 6 parameters, i wanted to add a 7th list item for U calculation BUT with all the booleans im afraid that at the end all the work is for nothing because lists wont match and i wont be able to make them match again.
This is what i was thinking to do .
- Di is PVC? , those who are true are going to do a “If Di > 25 add 6mm, If Di > 35 add 8mm…”
-Those who are false are Steel? … same but different add values
-Those who are false are Copper? … same but different add values
-And so on
- Just apply the formula for each row in lists (so its important to have Dext Di and Insulation type on the same row)
Any thoughts? i feel that separate lists by true or false is a mistake and maybe you have a better solution