Course Measurement Mobile Spreadsheet | Road Course Measurement Forums

garybrumleymember

I've been spending a lot of time lately trying to further develop my mobile spreadsheet that I use while measuring. It's an adaptation of the spreadsheet that @duanerussell made available some time ago on his website (thank you Duane). I've added several tools such as a segmented course calculator, radial turn calculator, a short measurement tool, a one-click reverse course direction feature, and more. It's formatted to be used with the Google Sheets app on a mobile phone. If anyone is interested, I'm happy to share this tool in exchange for your feedback, corrections, etc. Of course, please double check all math yourself before finalizing your courses.

To access this resource:

Click the following link: https://bit.ly/3ntJ6fx
Choose "File" > "Make a copy" to save to your own Google account.

So that it populates with numbers instead of error cells, I've taken the liberty to add my most recent calibration data (calibration course length and counts) on the "Calibration" tab. You'll want to delete that and replace with your own. I recommend making a new copy for every measurement day.

Does anyone else use a mobile spreadsheet? If so, what features have you built into it?

9/11/218:11 PM

Original Post

AdminMember

Very impressive Gary. Or I guess I should say very impressive Gary and Duane.

I especially like the segmented course input page that you created. Measuring a course from start to finish or finish to start is pretty straight-forward, so having an app or spreadsheet to do the calculations for that type of measurement isn't really all that important to me. But measuring in segments can get complicated and it's easy to make mistakes, so I can certainly see how having a spreadsheet in the field for keeping all that organized would be helpful.

9/16/2111:31 AM

Add Reply

Sign In To Reply

<div id="{%=id%}" class="reveal-modal small h-alert-modal-popup" data-reveal>
    <div class="first-modal-focus focus-utility-element" tabindex="0" aria-label="Inside Modal"></div>

<h4 id="{%=id%}_title" class="margin-bottom-10 popup-title"></h4>
    <div id="{%=id%}_body" class="margin-bottom-10 popup-body">
        </div>

<ul id="{%=id%}ButtonGroup" class="button-group h-popup-buttons even-button-group even-1">
    <li id="{%=id%}Okay_buttonContainer"><a id="{%=id%}Okay" href="javascript:void(0);" class="button success no-margin-bottom h-alert-modal-ok-button" role="button">OK</a><script type="text/javascript">
        (function() {
            function {%=id%}Okay_click(event, data) {
            {%=id%}Popup.hide();
        }
        
                $('#{%=id%}Okay').on('click', {%=id%}Okay_click);
        })();
    </script></li></ul><a href="javascript:void(0);" class="close-reveal-modal" aria-label="Close Modal">&#215;</a><div class="last-modal-focus focus-utility-element" tabindex="0"></div>
</div>
<script type="text/javascript">
        (function() {
            {%=id%}Popup = new SS.Popup.ModalPopup('{%=id%}');
        })();
    </script>