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