Well, I had to recreate a spreadsheet to convert NAD83 TM coordinates to Geographic and back because the original seems to have "corrupted" itself.?ÿ Manual NOS NGS 5 contains all the constants and all the formulae, so it's just a matter of powering through it.?ÿ However, I'm getting one little headache using term "n^2" as defined on page 33.?ÿWhen I apply it to the formulae?ÿon page 36 with my TM constants I must be doing something wrong.
In?ÿConstants?ÿB2, B4,?ÿand B6 if I?ÿ square it I get the wrong answer.
In Constants B3 and B5 ?ÿif I square it I get the correct answer.
I'm attaching the XL sheet, if anyone would take a look and give some feedback I'd appreciate it.
The link to the manual;
https://alt.ngs.noaa.gov/PUBS_LIB/ManualNOSNGS5.pdf
?ÿ
?ÿ
?ÿ
It looks like a very minor difference either way.?ÿ Is "wrong" a difference in the last place, about 0.3 mm??ÿ That's all I saw when I took out the ^2 from term N15 in cells N18 and N19.
Using your SPC (in meters) through?ÿ CORPSCON6 gets 74 02 05.61455, same as I get if I don't square that already squared term (except to get eta^4 at the end).
I think you need to go back to see why the geographic to coordinate calculation gave you the easting 189300.6493 whereas CORPSCON6 gives 189300.650?ÿ I haven't gone through those equations.
Bill,
You're right. The n^2 term was getting me in the direct conversion as well.?ÿ
I went through both sets of equations looking for the squared term, and have it matching CORPSCON very well.
The scale factor came out slightly different in the two computations, which I fixed by putting the square on Q in the?ÿ SPC->Geo computation.
I fooled around with the?ÿ@scott-zelenak spreadsheet a bit.?ÿ First, I figured there was no advantage of a spreadsheet over CORPSCON if you couldn't put in columns of values and get them all done at once.?ÿ So I cut and pasted the formulas into a single row instead of a column and put the values you are most interested first.?ÿ All the supporting calculations can be in hidden columns that don't print.
Then I wanted to see if I could make another zone work.?ÿ So I picked one (Indiana East-couldn't use my Lambert state. That's another project) and made another column for its constants.?ÿ You can switch zones by copying one column off the first sheet and pasting it on the second sheet.?ÿ For a given conversion sheet to make any sense, of course, that master column has to be set for the zone of interest.?ÿ When you look at Indiana points with NJ constants set on the 2nd sheet, the results are useless, but I wanted separate sheets for them so I wouldn't lose the numbers typed in.
Hope someone finds it useful, and of course you must do some checking before you trust it.
