#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Custom Number

I'm a surveyor and I always use a number format 0+00.00 for Stationing.
Everytime I need to use that format, I always have to create it. It will be
nice if the 0+00.00 format will be included in your list of Custom formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default Custom Number

If you put the following Workbook_Open in your PERSONAL.XLS workbook's
ThisWorkbook module, the format you want should automatically be available
in any workbook you open...

Private Sub Workbook_Open()
Dim Setting As Variant
With ActiveCell
Setting = .NumberFormat
.NumberFormat = "0+00.00"
.NumberFormat = Setting
End With
End Sub

--
Rick (MVP - Excel)


"jal111" wrote in message
...
I'm a surveyor and I always use a number format 0+00.00 for Stationing.
Everytime I need to use that format, I always have to create it. It will
be
nice if the 0+00.00 format will be included in your list of Custom formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,358
Default Custom Number

See Rick's suggestion as to how to get your format as needed.

The issue with trying to make everyone happy is that it is impossible. Just
think, say MS decided to make 1000 different groups happy by adding their
format to the current list of formats, would you want to scroll through 1000
different number formats to find your one?

You might also look into making your own template.
--
** John C **

"jal111" wrote:

I'm a surveyor and I always use a number format 0+00.00 for Stationing.
Everytime I need to use that format, I always have to create it. It will be
nice if the 0+00.00 format will be included in your list of Custom formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default Custom Number

It appears that using the PERSONAL.XLS workbook's Workbook_Open procedure
does not always work. Try putting this in a Module in your PERSONAL.XLS
workbook instead...

Sub SurveyFormat()
Dim LastRow As Long
Dim Setting As Variant
With ActiveSheet
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
With .Cells(LastRow + 1, "A")
Setting = .NumberFormat
.NumberFormat = "0+00.00"
.NumberFormat = Setting
End With
End With
End Sub

Then, simply Run this macro (Alt+F8) whenever you want the 0+00.00 format
available in the Custom Format listing.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
If you put the following Workbook_Open in your PERSONAL.XLS workbook's
ThisWorkbook module, the format you want should automatically be available
in any workbook you open...

Private Sub Workbook_Open()
Dim Setting As Variant
With ActiveCell
Setting = .NumberFormat
.NumberFormat = "0+00.00"
.NumberFormat = Setting
End With
End Sub

--
Rick (MVP - Excel)


"jal111" wrote in message
...
I'm a surveyor and I always use a number format 0+00.00 for Stationing.
Everytime I need to use that format, I always have to create it. It will
be
nice if the 0+00.00 format will be included in your list of Custom
formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default Custom Number

Hi,

You can handle this problem another way:

1. You can open a blank workbook and add the Custom format
2. Then choose File, Save and change the name to Book
3. Change the Files of Type to template (*.xlt)
4. Change the location to the \XLStart folder (usually located in
C:\Program Files\Microsoft Office\Office11\XLStart

This will handle all new workbooks. Every new workbook that opens will have
the built-in custom format. Everytime you start Excel the workbook that
opens will be this one. Evertime you click the New button this will be the
file that is used.

If this helps, please click the Yes button.

cheers,
Shane Devenshire

"jal111" wrote:

I'm a surveyor and I always use a number format 0+00.00 for Stationing.
Everytime I need to use that format, I always have to create it. It will be
nice if the 0+00.00 format will be included in your list of Custom formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Custom Number

I don't considered us just part of a user group you're talking about. Can you
imagine just here in the US, how many Engineering and Surveying companies
that will benefit if we add 0+00.00 format to our custom number. What more if
we are talking worldwide. For the meantime, I very satisfied with Rick and
Shane's suggestion. Both of them works. Thanks Guys :)

"John C" wrote:

See Rick's suggestion as to how to get your format as needed.

The issue with trying to make everyone happy is that it is impossible. Just
think, say MS decided to make 1000 different groups happy by adding their
format to the current list of formats, would you want to scroll through 1000
different number formats to find your one?

You might also look into making your own template.
--
** John C **

"jal111" wrote:

I'm a surveyor and I always use a number format 0+00.00 for Stationing.
Everytime I need to use that format, I always have to create it. It will be
nice if the 0+00.00 format will be included in your list of Custom formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Custom Number

As a matter of idle curiosity, what branch of engineering or surveying uses
that format, and why?
--
David Biddulph

"jal111" wrote in message
...
I don't considered us just part of a user group you're talking about. Can
you
imagine just here in the US, how many Engineering and Surveying companies
that will benefit if we add 0+00.00 format to our custom number. What more
if
we are talking worldwide. For the meantime, I very satisfied with Rick and
Shane's suggestion. Both of them works. Thanks Guys :)

"John C" wrote:

See Rick's suggestion as to how to get your format as needed.

The issue with trying to make everyone happy is that it is impossible.
Just
think, say MS decided to make 1000 different groups happy by adding their
format to the current list of formats, would you want to scroll through
1000
different number formats to find your one?

You might also look into making your own template.
--
** John C **

"jal111" wrote:

I'm a surveyor and I always use a number format 0+00.00 for Stationing.
Everytime I need to use that format, I always have to create it. It
will be
nice if the 0+00.00 format will be included in your list of Custom
formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions



  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default Custom Number

Road design (I was a road designer for more than 30 years) and surveying...
it is how the 100-foot stations on a center and/or survey line are marked
off (stations are labeled, as an example, 24, and measurements from that
100-foot station, say 12.34 feet down from it, are labeled 24+12.34).

--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
As a matter of idle curiosity, what branch of engineering or surveying
uses that format, and why?
--
David Biddulph

"jal111" wrote in message
...
I don't considered us just part of a user group you're talking about. Can
you
imagine just here in the US, how many Engineering and Surveying companies
that will benefit if we add 0+00.00 format to our custom number. What
more if
we are talking worldwide. For the meantime, I very satisfied with Rick
and
Shane's suggestion. Both of them works. Thanks Guys :)

"John C" wrote:

See Rick's suggestion as to how to get your format as needed.

The issue with trying to make everyone happy is that it is impossible.
Just
think, say MS decided to make 1000 different groups happy by adding
their
format to the current list of formats, would you want to scroll through
1000
different number formats to find your one?

You might also look into making your own template.
--
** John C **

"jal111" wrote:

I'm a surveyor and I always use a number format 0+00.00 for
Stationing.
Everytime I need to use that format, I always have to create it. It
will be
nice if the 0+00.00 format will be included in your list of Custom
formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions




  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Custom Number

nI can say all branches of Surveying use it and almost all of the branches of
Engineering, especially in Civil,Highway and Traffic. I can say Electrical
and Mechanical too, sometimes they deal with lines(pipelines, trenches etc.)

"Rick Rothstein" wrote:

Road design (I was a road designer for more than 30 years) and surveying...
it is how the 100-foot stations on a center and/or survey line are marked
off (stations are labeled, as an example, 24, and measurements from that
100-foot station, say 12.34 feet down from it, are labeled 24+12.34).

--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
As a matter of idle curiosity, what branch of engineering or surveying
uses that format, and why?
--
David Biddulph

"jal111" wrote in message
...
I don't considered us just part of a user group you're talking about. Can
you
imagine just here in the US, how many Engineering and Surveying companies
that will benefit if we add 0+00.00 format to our custom number. What
more if
we are talking worldwide. For the meantime, I very satisfied with Rick
and
Shane's suggestion. Both of them works. Thanks Guys :)

"John C" wrote:

See Rick's suggestion as to how to get your format as needed.

The issue with trying to make everyone happy is that it is impossible.
Just
think, say MS decided to make 1000 different groups happy by adding
their
format to the current list of formats, would you want to scroll through
1000
different number formats to find your one?

You might also look into making your own template.
--
** John C **

"jal111" wrote:

I'm a surveyor and I always use a number format 0+00.00 for
Stationing.
Everytime I need to use that format, I always have to create it. It
will be
nice if the 0+00.00 format will be included in your list of Custom
formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions





  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Custom Number

Ah, that rings vague bells from my dim and distant past. So that format is
recording two different numbers, hence it doesn't make sense as a format for
a cell containing one number in Excel. If recording two different
quantities, it wants two columns.
--
David Biddulph

"Rick Rothstein" wrote in message
...
Road design (I was a road designer for more than 30 years) and
surveying... it is how the 100-foot stations on a center and/or survey
line are marked off (stations are labeled, as an example, 24, and
measurements from that 100-foot station, say 12.34 feet down from it, are
labeled 24+12.34).
--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
As a matter of idle curiosity, what branch of engineering or surveying
uses that format, and why?
--
David Biddulph

"jal111" wrote in message
...
I don't considered us just part of a user group you're talking about. Can
you
imagine just here in the US, how many Engineering and Surveying
companies
that will benefit if we add 0+00.00 format to our custom number. What
more if
we are talking worldwide. For the meantime, I very satisfied with Rick
and
Shane's suggestion. Both of them works. Thanks Guys :)

"John C" wrote:

See Rick's suggestion as to how to get your format as needed.

The issue with trying to make everyone happy is that it is impossible.
Just
think, say MS decided to make 1000 different groups happy by adding
their
format to the current list of formats, would you want to scroll through
1000
different number formats to find your one?

You might also look into making your own template.
--
** John C **

"jal111" wrote:

I'm a surveyor and I always use a number format 0+00.00 for
Stationing.
Everytime I need to use that format, I always have to create it. It
will be
nice if the 0+00.00 format will be included in your list of Custom
formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions








  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default Custom Number

Not really. Since the station are 100 feet apart, Station 24 is actually
2400 feet from Station 0, so Station 24+12.34 is really 2412.34 feet from
Station 0. The + notation is a convenience as it allows you to look at a
station and immediately see the whole station it is measured from (24) and
how far past it it is 12.34 feet... this this easier to see with the +
notation than looking at 2412.34 directly.

--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Ah, that rings vague bells from my dim and distant past. So that format
is recording two different numbers, hence it doesn't make sense as a
format for a cell containing one number in Excel. If recording two
different quantities, it wants two columns.
--
David Biddulph

"Rick Rothstein" wrote in message
...
Road design (I was a road designer for more than 30 years) and
surveying... it is how the 100-foot stations on a center and/or survey
line are marked off (stations are labeled, as an example, 24, and
measurements from that 100-foot station, say 12.34 feet down from it, are
labeled 24+12.34).
--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
As a matter of idle curiosity, what branch of engineering or surveying
uses that format, and why?
--
David Biddulph

"jal111" wrote in message
...
I don't considered us just part of a user group you're talking about.
Can you
imagine just here in the US, how many Engineering and Surveying
companies
that will benefit if we add 0+00.00 format to our custom number. What
more if
we are talking worldwide. For the meantime, I very satisfied with Rick
and
Shane's suggestion. Both of them works. Thanks Guys :)

"John C" wrote:

See Rick's suggestion as to how to get your format as needed.

The issue with trying to make everyone happy is that it is impossible.
Just
think, say MS decided to make 1000 different groups happy by adding
their
format to the current list of formats, would you want to scroll
through 1000
different number formats to find your one?

You might also look into making your own template.
--
** John C **

"jal111" wrote:

I'm a surveyor and I always use a number format 0+00.00 for
Stationing.
Everytime I need to use that format, I always have to create it. It
will be
nice if the 0+00.00 format will be included in your list of Custom
formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader
and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions






  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Custom Number

When you said that it was "12.34 feet down from" the station, I assumed that
the 24 was measuring along the line and the 12.34 at right angles to the
line. That is presumably not the case, from what you are now saying.
--
David Biddulph

"Rick Rothstein" wrote in message
...
Not really. Since the station are 100 feet apart, Station 24 is actually
2400 feet from Station 0, so Station 24+12.34 is really 2412.34 feet from
Station 0. The + notation is a convenience as it allows you to look at a
station and immediately see the whole station it is measured from (24) and
how far past it it is 12.34 feet... this this easier to see with the +
notation than looking at 2412.34 directly.

--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Ah, that rings vague bells from my dim and distant past. So that format
is recording two different numbers, hence it doesn't make sense as a
format for a cell containing one number in Excel. If recording two
different quantities, it wants two columns.
--
David Biddulph

"Rick Rothstein" wrote in message
...
Road design (I was a road designer for more than 30 years) and
surveying... it is how the 100-foot stations on a center and/or survey
line are marked off (stations are labeled, as an example, 24, and
measurements from that 100-foot station, say 12.34 feet down from it,
are labeled 24+12.34).
--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
As a matter of idle curiosity, what branch of engineering or surveying
uses that format, and why?
--
David Biddulph

"jal111" wrote in message
...
I don't considered us just part of a user group you're talking about.
Can you
imagine just here in the US, how many Engineering and Surveying
companies
that will benefit if we add 0+00.00 format to our custom number. What
more if
we are talking worldwide. For the meantime, I very satisfied with Rick
and
Shane's suggestion. Both of them works. Thanks Guys :)

"John C" wrote:

See Rick's suggestion as to how to get your format as needed.

The issue with trying to make everyone happy is that it is
impossible. Just
think, say MS decided to make 1000 different groups happy by adding
their
format to the current list of formats, would you want to scroll
through 1000
different number formats to find your one?

You might also look into making your own template.
--
** John C **

"jal111" wrote:

I'm a surveyor and I always use a number format 0+00.00 for
Stationing.
Everytime I need to use that format, I always have to create it. It
will be
nice if the 0+00.00 format will be included in your list of Custom
formats
for numbers. It will benefit all the Surveyors and Engineers users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader
and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions








  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default Custom Number

No, the number after the plus is not an offset... the offsets are measured,
right or left (looking up station, that is, looking in the direction of
increasing stations), from a specified station on the center and/or survey
line... 24+12.34 is an example of such a station.

--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
When you said that it was "12.34 feet down from" the station, I assumed
that the 24 was measuring along the line and the 12.34 at right angles to
the line. That is presumably not the case, from what you are now saying.
--
David Biddulph

"Rick Rothstein" wrote in message
...
Not really. Since the station are 100 feet apart, Station 24 is actually
2400 feet from Station 0, so Station 24+12.34 is really 2412.34 feet from
Station 0. The + notation is a convenience as it allows you to look at a
station and immediately see the whole station it is measured from (24)
and how far past it it is 12.34 feet... this this easier to see with the
+ notation than looking at 2412.34 directly.

--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Ah, that rings vague bells from my dim and distant past. So that format
is recording two different numbers, hence it doesn't make sense as a
format for a cell containing one number in Excel. If recording two
different quantities, it wants two columns.
--
David Biddulph

"Rick Rothstein" wrote in message
...
Road design (I was a road designer for more than 30 years) and
surveying... it is how the 100-foot stations on a center and/or survey
line are marked off (stations are labeled, as an example, 24, and
measurements from that 100-foot station, say 12.34 feet down from it,
are labeled 24+12.34).
--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
As a matter of idle curiosity, what branch of engineering or surveying
uses that format, and why?
--
David Biddulph

"jal111" wrote in message
...
I don't considered us just part of a user group you're talking about.
Can you
imagine just here in the US, how many Engineering and Surveying
companies
that will benefit if we add 0+00.00 format to our custom number. What
more if
we are talking worldwide. For the meantime, I very satisfied with
Rick and
Shane's suggestion. Both of them works. Thanks Guys :)

"John C" wrote:

See Rick's suggestion as to how to get your format as needed.

The issue with trying to make everyone happy is that it is
impossible. Just
think, say MS decided to make 1000 different groups happy by adding
their
format to the current list of formats, would you want to scroll
through 1000
different number formats to find your one?

You might also look into making your own template.
--
** John C **

"jal111" wrote:

I'm a surveyor and I always use a number format 0+00.00 for
Stationing.
Everytime I need to use that format, I always have to create it.
It will be
nice if the 0+00.00 format will be included in your list of Custom
formats
for numbers. It will benefit all the Surveyors and Engineers
users.

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion,
click the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader
and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions









  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Survey stations in excel

Here is what I did in Excel. I entered the station # in one of my columns. Then in the next column I converted it to a number for additional calculations I did. The conversation uses the text formula function to select the full station to the left of the "+" and multiply it by 100 and then add the 2 far right numbers.

Left(cell containing the station #,1)+Right(cell containing the station #,2).

The only oddity is that when the stations start with 2 digits, the formula needs to have the "1" changed to "2" and when it has 3 digits, it will have to be "3".

Jim
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default Survey stations in excel

While you could use FIND to find the + sign and concatenate 100 times the
part to the left of the + sign and add it to the part on the right of the +
sign, this formula is much easier and it accomplishes the same end result...

=--SUBSTITUTE(cell containing the station #,"+","")

--
Rick (MVP - Excel)


"Jim Olyniec" wrote in message ...
Here is what I did in Excel. I entered the station # in one of my
columns. Then in the next column I converted it to a number for
additional calculations I did. The conversation uses the text formula
function to select the full station to the left of the "+" and multiply it
by 100 and then add the 2 far right numbers.

Left(cell containing the station #,1)+Right(cell containing the station
#,2).

The only oddity is that when the stations start with 2 digits, the formula
needs to have the "1" changed to "2" and when it has 3 digits, it will
have to be "3".

Jim




  #16   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Survey stations in excel

As shown below, I used: =--SUBSTITUTE(cell containing the station #,"+",""). Wow! Now I am able to add distances to stations in excel and get the next station. Very helpful. I had a starting station and need to place 400 CIDH piles 3 feet apart. I just add 3 feet to the station and the next station "magically" shows up in the next cell. Very helpful, very very helpful!!!
Thanks Rick!

On Sunday, December 14, 2008 at 7:11:53 PM UTC-8, Rick Rothstein wrote:
While you could use FIND to find the + sign and concatenate 100 times the
part to the left of the + sign and add it to the part on the right of the +
sign, this formula is much easier and it accomplishes the same end result....

=--SUBSTITUTE(cell containing the station #,"+","")

--
Rick (MVP - Excel)


"Jim Olyniec" wrote in message ....
Here is what I did in Excel. I entered the station # in one of my
columns. Then in the next column I converted it to a number for
additional calculations I did. The conversation uses the text formula
function to select the full station to the left of the "+" and multiply it
by 100 and then add the 2 far right numbers.

Left(cell containing the station #,1)+Right(cell containing the station
#,2).

The only oddity is that when the stations start with 2 digits, the formula
needs to have the "1" changed to "2" and when it has 3 digits, it will
have to be "3".

Jim


  #17   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Custom Number


Structural Engineer here...KISS method.

You could just go to the cell, click the Numbers Format, go to More Numbers Format, go down to Custom and enter this in the Type: dialogue

#+00.00

it takes the digits below the 100's place and put it after the + sign. what ever is in the 100's and above goes before it. Or go big and add a designator for feet :-)

#+00.00 "ft"

  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Custom Number

Format Cells/Custom #00+00.00
This will allow you to use mathematical functions and display stationing in typical fashion
  #19   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Custom Number

In engineering and survey, we don't use feet. We use stationing. It's easier to see 241+21 and not get a decimal out of place than 24121. We also use decimal places: 241+21.12 instead of 24121.12. Stationing is in multiples of 100'. We can produce a custom format to convert numbers 24121 into 241+21 automatically (Custom: ##+##) , but how do you type in a station 241+21 and have that automatically recogized as a number so you can subtract another station from it? For example, start station of a crew was 241+21 and they quit at station 361+13. The inspector types in the start and stop stations off the survey stakes and wants the Excel spreadsheet to tell him how much footage he got that day. Any suggestions?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom number format for driver's license number excel user Excel Discussion (Misc queries) 10 July 16th 08 10:05 PM
Moving custom number format to NUMBER Doug Boufford Setting up and Configuration of Excel 3 July 23rd 07 11:58 PM
Copying the number of a custom formatted number cell fbvideo Excel Discussion (Misc queries) 2 January 26th 07 12:00 AM
custom number Gklass Charts and Charting in Excel 2 May 30th 06 08:07 PM
Custom number format always defaults last number to 0. scubadave Excel Discussion (Misc queries) 2 June 15th 05 10:20 PM


All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"