Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2015, 07:43 AM
mbenton mbenton is offline Adding station numbers Windows XP Adding station numbers Office 2010 64bit
Novice
Adding station numbers
 
Join Date: Jan 2015
Posts: 7
mbenton is on a distinguished road
Default 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?



Thanks in advance for your help.
Reply With Quote
  #2  
Old 01-26-2015, 06:46 AM
gebobs gebobs is offline Adding station numbers Windows 7 64bit Adding station numbers Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by mbenton View Post
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))
Reply With Quote
  #3  
Old 01-26-2015, 04:17 PM
mbenton mbenton is offline Adding station numbers Windows XP Adding station numbers Office 2010 64bit
Novice
Adding station numbers
 
Join Date: Jan 2015
Posts: 7
mbenton is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 01-26-2015, 04:22 PM
gebobs gebobs is offline Adding station numbers Windows 7 64bit Adding station numbers Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Why do you need to convert back? You still have the unconverted station number in A1.
Reply With Quote
  #5  
Old 01-26-2015, 04:26 PM
mbenton mbenton is offline Adding station numbers Windows XP Adding station numbers Office 2010 64bit
Novice
Adding station numbers
 
Join Date: Jan 2015
Posts: 7
mbenton is on a distinguished road
Default

Because I will have to add a distance to the converted station number and then display the results as a station number
Reply With Quote
  #6  
Old 01-27-2015, 06:11 AM
gebobs gebobs is offline Adding station numbers Windows 7 64bit Adding station numbers Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Just show how you want it displayed. I can't understand by your explanation what you want.
Reply With Quote
  #7  
Old 01-27-2015, 06:16 AM
mbenton mbenton is offline Adding station numbers Windows XP Adding station numbers Office 2010 64bit
Novice
Adding station numbers
 
Join Date: Jan 2015
Posts: 7
mbenton is on a distinguished road
Default

I want to display the distance 256.35 as 2+56.35
Reply With Quote
  #8  
Old 01-27-2015, 06:55 AM
gebobs gebobs is offline Adding station numbers Windows 7 64bit Adding station numbers Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #9  
Old 01-27-2015, 07:46 AM
mbenton mbenton is offline Adding station numbers Windows XP Adding station numbers Office 2010 64bit
Novice
Adding station numbers
 
Join Date: Jan 2015
Posts: 7
mbenton is on a distinguished road
Default

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.
Reply With Quote
  #10  
Old 01-27-2015, 09:05 AM
gebobs gebobs is offline Adding station numbers Windows 7 64bit Adding station numbers Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 834
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #11  
Old 01-27-2015, 09:13 AM
mbenton mbenton is offline Adding station numbers Windows XP Adding station numbers Office 2010 64bit
Novice
Adding station numbers
 
Join Date: Jan 2015
Posts: 7
mbenton is on a distinguished road
Thumbs up

That's what I needed...thank you so much
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding captions without numbers (Word 2011 forMac) dkester Word 0 10-01-2013 09:24 PM
Adding a page without affecting all page numbers in doc gf1701 Word 1 03-11-2013 01:25 AM
Adding Slide Numbers to powerpoint 2010 mindblaster PowerPoint 2 03-07-2013 11:43 AM
Panic Adding slide numbers to master Roscoe PowerPoint 0 01-26-2011 12:36 PM
Adding station numbers 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft