Hi All,
In another non-sports related sheet (which makes a change for me), I was at a training course this week and a colleague mentioned some work I'd done (didn't realise that I'd done it though) and that they spotted a substantial typo in it (one figure out of about 160 - and it was out enough that it was obviously wrong, 15 miles wrong on a 200m long site). In the course of the training, I spotted a manual way of adding a check to whenever I do figures like that in future (we don't have the IT to run the software that we have that would remove the need for me to manually input or copy and paste figures in).
In short I have put together a rough example sheet (as once I have the formulas right, I can then apply it to a bigger sheet, do a data validation pick table etc.).
In the attached (which is a two station, 4 point example - the job I made a typo on was about 70 points and 10 stations), my site co-ordinates are in yellow in columns B and C, the distance (to A in this case) in red in D and E is good (which is all I really want to add as a check) - but whilst I was at it, I figured I'd do the bearing as well. The working columns, F to K in green are good (I think, I may have to re-work the quadrant (Q) adjust, I have some papers on my desk - I'm not a surveyor by background).
The column that I need to re-work is L (in blue).
Basically I want to pull whichever check comes up between H and K. For some reason I have L6 and L7 working, but L4 and L5 don't (which makes me think my formula is off (I went with an index, iferror and match?).
I'm sure I can probably tidy the whole sheet up in the long term, but for now I just want to get something workable.
Thanks in advance for any suggestions,
Trig_Problem_Forum Copy.xlsx
Bookmarks