Change 10,000 to 100+00 in an Excel Spreadsheet
Posted on 2016-09-24
I work in Pipeline Construction and I do QC work. The way that Survey measures the line is for example, 75,880' down the line is represented as Station 758+80. Is there a way that i can change 758+80 back to 75,880' so that i can add my joint length? I have to track the welds location, but i am only given stations for certain welds. I have all the joint lengths. I want to be able to have it so i can just make it so I can say for instance,
current weld station # = (previous weld station #) + (previous pipe length in feet).
current weld station # = 758+80 + 40
current weld station # = 759+20
Then also show it back to the 758+56 format. Thank you if somebody could help me. I have something upwards of 3,000 welds to track, or i would just do it manually.