  Microsoft Office Forums  Adding station numbers
 Register FAQ Search Today's Posts Mark Forums Read

#1
 mbenton  Windows XP Office 2010 64bit Novice Join Date: Jan 2015 Posts: 7  Adding station numbers

Sometimes in engineering and surveying, distances along a line or curve from a beginning point are expressed as station numbers. For example, the first point could be 50.50 feet from the beginning point and would be expressed as 0+50.50, the next point might be 136.68 feet from the beginning point and would be expressed as 1+36.68 and the next point might be 243.89 feet from the beginning point and would be expressed as 2+43.89. Can someone show me how I can get excel to add or subtract these station numbers?

#2
 gebobs  Windows 7 64bit Office 2010 64bit Expert Join Date: Mar 2014 Location: Atlanta Posts: 834   Quote:
 Originally Posted by mbenton Sometimes in engineering and surveying, distances along a line or curve from a beginning point are expressed as station numbers. For example, the first point could be 50.50 feet from the beginning point and would be expressed as 0+50.50, the next point might be 136.68 feet from the beginning point and would be expressed as 1+36.68 and the next point might be 243.89 feet from the beginning point and would be expressed as 2+43.89. Can someone show me how I can get excel to add or subtract these station numbers? Thanks in advance for your help.
I'm not sure I understand how this works. Does the number to the left of the plus sign always correspond to the hundreds portion of the distance?

If so, you can convert such numbers with the following:
=LEFT(A1,FIND("+",A1)-1)*100+RIGHT(A1,LEN(A1)-FIND("+",A1))
#3
 mbenton  Windows XP Office 2010 64bit Novice Join Date: Jan 2015 Posts: 7  Gebobs,

Thank you so much , you are exactly right in your assumption. Now can you show me how to convert it back from a distance to a station numbner, i.e. 256.35 to 2+56.35.

Thanks again
#4
 gebobs  Windows 7 64bit Office 2010 64bit Expert Join Date: Mar 2014 Location: Atlanta Posts: 834   Why do you need to convert back? You still have the unconverted station number in A1.
#5
 mbenton  Windows XP Office 2010 64bit Novice Join Date: Jan 2015 Posts: 7  Because I will have to add a distance to the converted station number and then display the results as a station number
#6
 gebobs  Windows 7 64bit Office 2010 64bit Expert Join Date: Mar 2014 Location: Atlanta Posts: 834   Just show how you want it displayed. I can't understand by your explanation what you want.
#7
 mbenton  Windows XP Office 2010 64bit Novice Join Date: Jan 2015 Posts: 7  I want to display the distance 256.35 as 2+56.35
#8
 gebobs  Windows 7 64bit Office 2010 64bit Expert Join Date: Mar 2014 Location: Atlanta Posts: 834   You've lost me. I assumed you already had that. The equation in post #2 depends on it. In that example, it assumes it is in A1.
#9
 mbenton  Windows XP Office 2010 64bit Novice Join Date: Jan 2015 Posts: 7  In my first post I asked how I could get excel to add station numbers together.
example: (1+50.23) + (2+36.46) = (3+86.69)

You showed me how I could convert a station number to a gereral number by using =LEFT(A1,FIND("+",A1)-1)*100+RIGHT(A1,LEN(A1)-FIND("+",A1))

I can use that to convert (1+50.23) to 150.23 and (2+36.46) to 236.46 so I can then add 150.23 and 236.46 and come up with the sum of 386.69 but now I must display 386.69 as the station number 3+86.69.

I need a formula like you gave me above to convert the general number 386.69 back to a station number 3+86.69.
#10
 gebobs  Windows 7 64bit Office 2010 64bit Expert Join Date: Mar 2014 Location: Atlanta Posts: 834   Let's start over. I assumed your sheet would look something like this:

A1: 1+50.23
B1: 2+36.46
C1: [the formula doing the addition]

At any rate, conversion back might work with:
=INT(A1/100)&"+"&MOD(A1,100)

It won't work if the number after the plus sign ever exceeds 100.
#11
 mbenton  Windows XP Office 2010 64bit Novice Join Date: Jan 2015 Posts: 7  That's what I needed...thank you so much

 Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Similar Threads Thread Thread Starter Forum Replies Last Post dkester Word 0 10-01-2013 09:24 PM gf1701 Word 1 03-11-2013 01:25 AM mindblaster PowerPoint 2 03-07-2013 11:43 AM Roscoe PowerPoint 0 01-26-2011 12:36 PM adding numbers in same cell jetdude68 Word Tables 1 07-20-2010 12:30 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:05 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top