James Fleming, post: 401540, member: 136 wrote: This looks like a job for Excel
Are you sure it isn't a multiplicative factor. "=A2*B2"?
not my real name, post: 401454, member: 8199 wrote: Software like excel that has been around since 1985 and begs continuous upgrades and updates does not impress me
Try Autodesk products. 😉
FL/GA PLS., post: 401589, member: 379 wrote: Try Autodesk products. 😉
Autodesk finds out which function you use a lot and deletes them in the next "upgrade."
Tom Adams, post: 401584, member: 7285 wrote: Are you sure it isn't a multiplicative factor. "=A2*B2"?
D@mn lazy software developers should have caught that for me 😉
RADAR, post: 401532, member: 413 wrote: Take a look at how Europeans measure angles; I think you will be surprised.
Then take a look at the way WE measure angles...
- Take a circle and divide it 360 times; that's convenient...
- Now divide each one of those 60 times; now there's a number that we use every day...
- Now take one of those and divide it 60 more times; if it ain't broke, don't fix it; right?
1,296,000 isn't a number you use every day?
Lee D, post: 401616, member: 7971 wrote: 1,296,000 isn't a number you use every day?
no, but 1 and 2 are...
James Fleming, post: 401609, member: 136 wrote: D@mn lazy software developers should have caught that for me 😉
You don't use the handy AGGRAND(ize) function?
Dave Karoly, post: 401591, member: 94 wrote: Autodesk finds out which function you use a lot and deletes them in the next "upgrade."
But, you can "undelete" them for a paltry sum of less than 4K per year per seat. What a bargin.
I've already purchased BricsCAD (Thank you Jim Frame) and am impressed so far. Soon it will goodbye AutoDesk and good riddance.
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.
If anything, it's not the program that sucks, but your ability to use it. It's a phenomenal program. Look at this spreadsheet from surveyor Larry Scott:
Try calculating standard deviations for dozens of astro observations to any one of almost 20 celestial bodies (using real time ephemerides), reducing and averaging them etc., with your calculator. Believe me, I've tried. Nearly impossible to do in any reasonable time. Oh, it also does LaPlace corrections and Grid conversions on the fly too.
Conversion of decimal feet to feet, inches and fractions
For older versions of Excel along with some variations
The included spread sheet differs some from that of Scott Zelenak.
1. The formula, f' - ii nn/dd", is:
=IF(B9<0,"-","")&INT(ROUND(ABS(B9)*12*$B$3,0)/12/$B$3)&"' "&TRIM(TEXT(MOD(ROUND(ABS(B9)*12*$B$3,0)/$B$3,12),"- 00 ?/????"))&CHAR(34)
where
1a. B9 is the "decimal feet" cell
1b. $B$3 is the fractional rounding value. For 16ths, enter 16, 32nd's, 32, etc. Values up to 8192 should work.
2. The MROUND function, employed in Zelenak's formula, is not available in older versions of Excel. Instead, the method used is ROUND(ABS(B9)*12*$B$3,0)/12/$B$3. In Zelenak's spread sheet, the formula would, if not MROUND, be =ROUND(B9*192,0)/192. Note that without using the ABS function, negative numbers do not yield the desired results when converted to an integer. "192" is the product of 12 and 16.
3. The TEXT function format specifier is "- 00 ?/????" It allows fractional rounding values up to and including 8192nd's to display correctly.
4. The TRIM function is used to remove leading, trailing and double spaces generated by the format specifier.
5. Negative decimal feet numbers as well as zero may be converted.
6. Because the newest versions of Excel do not always open and display spread sheets generated from the older versions, some modifications may be necessary. Excel's "Validation" obstacle-feature is one that generates a lot of frustration. Another item that creates errors in differing versions of Excel is the backslash character in format specifiers. Trial-and-error is essential in these cases - usually indicated by #VALUE!
I have used slight variations of this formula for nearly 30 years. As far as I have determined, it yields correct results. If errors are detected, please inform. While I've tested many of my Execl spread sheets in OpenOffice, this one has not yet been tested.
In presenting spread sheets, I attempt to think of the ways a reader can make mistakes or be confused in interpreting the information. In the case of feet and inches, if in a table, I omit the foot and inch symbols and instead use a header "Feet - Inches" to reduce eye strain from the repetitiveness of the symbols. If a single instance is presented, I use the abbreviations ft and in instead of the symbols so that it is easier for a reader to recognize. At times in tables, I have place the feet in one column and the inches and fractions in the adjacent column. Then, I justify the feet to the right and inches to the left.
Spread sheets are invaluable for specialized results. There is no program that "does it all." Excel allows the special calculations, formats and reports that other programs do, or can, not provide.
Dave Karoly, post: 401570, member: 94 wrote: I use Excel a lot. It amazes me when I talk to Surveyors that don't know how to use Excel or an alternative spreadsheet program. I think the roots of it is in accounting. It would be nice if it could convert DD to DMS and do functions in degrees
I have a wee add-in I wrote for excel that gives it the toDMS; toDD; PolarToRectangular; RectangularToPolar functionality of the HP calculators.
Its free
Sing out if you would like a copy
jim.cox, post: 401971, member: 93 wrote: I have a wee add-in I wrote for excel that gives it the toDMS; toDD; PolarToRectangular; RectangularToPolar functionality of the HP calculators.
Its free
Sing out if you would like a copy
Jim,
I would like a copy.
Ed
jim.cox, post: 401971, member: 93 wrote: I have a wee add-in I wrote for excel that gives it the toDMS; toDD; PolarToRectangular; RectangularToPolar functionality of the HP calculators.
Its free
Sing out if you would like a copy
yes please
ekillo, post: 401972, member: 773 wrote: Jim,
I would like a copy.
Ed
Peter Ehlert, post: 401977, member: 60 wrote: yes please
No worries,
Just send me your email address in a message
