{"product_id":"swimming-log-lap-tracker","title":"Swimming Log and Lap Tracker Spreadsheet","description":"\u003cp\u003eThis swimming log is for pool swimmers who train a few times a week and want to know whether each stroke is getting faster. Type the pool length, the laps, the stroke and the time, and the workbook works out distance and pace per 100 m.\u003c\/p\u003e\u003cp\u003ePace by Stroke then compares the last four weeks with the four before for every stroke, so you can see what is improving and what has slipped.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. Pick All strokes or one stroke and the whole page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eDistance:\u003c\/strong\u003e kilometers swum, laps, and meters per swim\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe stroke board:\u003c\/strong\u003e pace now against before for every stroke, faster or slower\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe last 40 swims:\u003c\/strong\u003e meters per swim, with the stroke picked stacked on the rest\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe fastest sets:\u003c\/strong\u003e your five quickest sets of 100 m or more\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTime in the water:\u003c\/strong\u003e hours in the pool and time per swim\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePace, week by week:\u003c\/strong\u003e pace per 100 m for every week, where lower is quicker\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonth by month, pools and swim days:\u003c\/strong\u003e meters each month, meters in 25 m and 50 m pools, and meters by day of the week\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat sets it apart\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003ePace by stroke:\u003c\/strong\u003e freestyle, backstroke, breaststroke, butterfly, IM and kick, each with its distance, average swim pace per 100 m and best set\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGetting faster, or not:\u003c\/strong\u003e the last four weeks against the four before, stroke by stroke, with the change in seconds and a verdict of faster, slower or about the same. You set the window\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eOne row per stroke per swim:\u003c\/strong\u003e a warm-up and a main set are two rows. Distance and pace are worked out, and each swim's total shows on its first row\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWeeks and months:\u003c\/strong\u003e every week from Monday against your distance goal, and one stroke's pace month by month, charted\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Swims, Pace by Stroke, Weekly and Dashboard. It handles 25 m and 50 m pools in one log and charts distance by month and by stroke, which makes it a straightforward lap tracker for swim training. The worked example follows one masters swimming regular from January to September: 102 swims, freestyle coming down from 2:06 to 1:54 per 100 m, backstroke faster too, and breaststroke and butterfly a second slower, which the file points out. It works just as well for triathlon swim sessions.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not just the dashboard, and both use the same formulas. Each comes filled with a worked example and blank, in Excel and in Google Sheets.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The template is for personal and business use on your own devices, so please do not share or resell the files. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I log swims in different pool lengths?\u003c\/h3\u003e\u003cp\u003eYes. It handles 25 m and 50 m pools in one log, and distance is worked out from laps and pool length.\u003c\/p\u003e\u003ch3\u003eWhich strokes does it track?\u003c\/h3\u003e\u003cp\u003eFreestyle, backstroke, breaststroke, butterfly, IM and kick, each with its distance, average pace per 100 m and best set.\u003c\/p\u003e\u003ch3\u003eHow do I log a session with several sets?\u003c\/h3\u003e\u003cp\u003eUse one row per stroke per swim, so a warm-up and a main set are two rows. Each swim's total shows on its first row.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Both have the same tabs and formulas, and both are included in every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597873676382,"sku":"OPX-224","price":12.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/swimming-log-lap-tracker-01.jpg?v=1790833205","url":"https:\/\/opxviashop.com\/products\/swimming-log-lap-tracker","provider":"OPXVIA","version":"1.0","type":"link"}