EXCEL formula to convert decimal to fractional feet.

Wow... good stuff. You're WAY better with Excel than I am lol thanks!!

Why is 0.50 sometimes 6-1/16" and other times 6"? (Maybe I'm missing something. I was just glancing @ it)

I see that as well, in cells H33 and I33 3.50 comes out as 3' 5 15/16"

Tom Adams, post: 401296, member: 7285 wrote: Why is 0.50 sometimes 6-1/16" and other times 6"? (Maybe I'm missing something. I was just glancing @ it)

Guessing from looking at the last two columns, the decimal data in the main table likely has more digits than are being displayed.

Ah yes, decimal cells have three decimal places input but formatted down to two for display.

Nice work. I have extreme disdain for Excel. Using it for anything other than keeping your bank balance sucks.

not my real name, post: 401306, member: 8199 wrote: Nice work. I have extreme disdain for Excel. Using it for anything other than keeping your bank balance sucks.

I haven't used it for a number of years but a good spreadsheet was a lifesaver when I was staking runway improvements. Between modified subgrade, crushed rock and varying concrete and/or asphalt wearing surfaces that changed all up and down a 7500' runway (that was 200' wide); a spreadsheet was the only way to go.

not my real name, post: 401306, member: 8199 wrote: Nice work. I have extreme disdain for Excel.

Since I do mostly construction work, I use Excel more than I do Autocad. Before Excel it was Lotus 123

James

not my real name, post: 401306, member: 8199 wrote: Nice work. I have extreme disdain for Excel. Using it for anything other than keeping your bank balance sucks.

Not if you know how to use it properly...

paden cash, post: 401307, member: 20 wrote: I haven't used it for a number of years but a good spreadsheet was a lifesaver when I was staking runway improvements. Between modified subgrade, crushed rock and varying concrete and/or asphalt wearing surfaces that changed all up and down a 7500' runway (that was 200' wide); a spreadsheet was the only way to go.

Scott Zelenak, post: 401291, member: 327 wrote: Finally got the formula perfect (except for negative numbers, oh well).
Anybody see any additional improvements that could be made?

Formula used in attached pic, with formatting spaces and 0 place holder;
=INT(MROUND(F10,1/192)) & TEXT(12*MOD(MROUND(F10,1/192),1),"' - 0 #/##") & """"

In case it helps anyone, see https://surveyorconnect.com/community/threads/excel-conversion-help-format.315284/#post-315494&apos ;">this thread for a version I wrote a few years back that would convert an ASCII coordinate file into an equivalent ASCII file with fractional units to a desired precision (e.g. sixteenths, eighths, quarters, etc).

Really? Why gang up on me? After all the years paying for and upgrading this software I just think it would be common sense for programmers to include this functionality.

And what's up with the trigonometry functions? I suppose you'll tell me that you all measure angles in radians next. Gosh I have a calculator that cost ten dollars and it will convert degrees, minutes and seconds to decimal.

Oh, and the graphing functions suck too, unless you want to make a pie chart. Excel is basically for accountants.

They have no idea who the scientific community is.

So, let me pose the question in a different way.

Let's say I'm selling some software. The software itself doesn't do anything that makes sense, but, you can write your own programs that will help it function...

Would you buy it?

I don't mean to be criticizing you or ganging up on you. I'm just saying that Excel is really good at things it was intended to do. Others have found ways to modify it to do things it was not intended to do.

I do grade sheets with it all the time. I have never adjusted a traverse with it and don't plan on trying. You are absolutely right about the graphing function but I don't use it for that.

To answer your question, no I would not.

James

not my real name, post: 401317, member: 8199 wrote: And what's up with the trigonometry functions? I suppose you'll tell me that you all measure angles in radians next. Gosh I have a calculator that cost ten dollars and it will convert degrees, minutes and seconds to decimal.

Oh, and the graphing functions suck too, unless you want to make a pie chart. Excel is basically for accountants.

=sin(radians(B3)) and =degrees(atan2(A4,A5)) or the like take care of the trig.

Scientific graphs work fine if you pick XY.

not my real name, post: 401321, member: 8199 wrote: So, let me pose the question in a different way.

Let's say I'm selling some software. The software itself doesn't do anything that makes sense, but, you can write your own programs that will help it function...

Would you buy it?

You mean like an "operating system"? Sure - in a heartbeat...

The value in Excel lies in its extraordinary versatility.

Could you fix the negative numbers by using absolute value? ABS(number)

not my real name, post: 401321, member: 8199 wrote:
Let's say I'm selling some software. The software itself doesn't do anything that makes sense, but, you can write your own programs that will help it function?

you mean like Visual Basic? Or C++?

Excel is just a tool. The fact you don't understand or like the tool doesn't make it less of a tool. If all you like is a hammer, everything starts to look like a nail.

I personally like excel. It can be infuriating, but it is still a valuble tool. I also like my HP48, and my HP35. Programming makes my job easier, with less chance for error.

I like my job being easier.
My boss likes me not having errors.

Forget my software analogy then... Everything is a "tool" these days and some are better than others.

Software like excel that has been around since 1985 and begs continuous upgrades and updates does not impress me when it still lacks basic functionality that can be found in a cheap calculator.

My calculator that cost $10.00 can easily convert from decimal degrees to degrees, minutes and seconds. It can solve trigonometric functions with out the need to convert the angular measurements to some obscure mathematical notation that nobody except high school algebra students use.

That is what I would expect from an update... some improved and practical functionality. The current functionality of the excel software is basically the same as when it was first written.

I can work around the limitations, and basically if you are not an accountant you will need to work around these frustrations.