Hello, I am looking for help on this spreadsheet.
The ISO Entry tab is for manual data entry.
On the Line # tab, I would like all of the information from the ISO Entry tab relisted where any lines that have the same Area Code, Plan Code, System Code, Pipe Size, and Insulation Thickness; The information under Straight Pipe, 90's/45's, Misc, Valves, Flanges is summed up and shown as 1 line item instead of multiple line items.
On the Pipe Size tab, I would like the information listed where any line that has the same Pipe Size and Insulation Thickness; The information under Straight Pipe, 90's/45's, Misc, Valves, Flanges is summed up and shown as 1 line item instead of multiple line items.
On the ISO tab, the row that looks like this "3"-SC2500-Q-CS02-2" is the Line Number. Everything above that is the information for that line number.
The Line Number tells us 4 things. Area Code, Plan Code, System Code, and Insulation Thickness. I would like an entry table to be able to tell the program where each of those are located in the Line Number.
Example:
Area Code = Q or A or etc.
Plan Code = SC or SH or CW or etc.
System Code = 2554 or 2835 or etc.
Insulation thickness = First number from the right (so 2" in above Line Number - or sometimes it will say 2EG at the end where 2 is still the thickness)
If the value under the "Size" column is "#x#", then I would like it displayed as the larger number.
For the columns 90s, Misc, Valves, Flanges, 45s - you will need to search for keywords under the Description Column on ISO tab. I would like a table where I can tell the program what to look for under each. Up to 10 different words under each column.
Example:
90s = 90
Misc = Tee, Reducer, Stubend
Valves = Valve, Expansion Joint
Flanges = Flanges
45s = 45
I would like 1 more entry table where I can Enter in the Plan Code and then enter in a color, and all of those lines are then highlighted that color. EX: CW = Blue
Thanks for the help!!
Bookmarks