IF you have a Google G-mail account, you can copy your own FREE Online Spreadsheet Puzzle Tracker. Then start tracking your jigsaw puzzles instantly and save it on whatever device you are using.
Watch the video and/or follow the steps below to get your FREE copy if you are not familiar with this process.
Note: You MUST make your own copy otherwise other Users may overwrite your Sheets. We suggest you make 2 copies as the spreadsheets have formulas embedded in the cells.
NOTE- Disclaimer: We bear no responsibility for any risk involved in using our Jigsaw Puzzle Hobby Tracker. By using this spreadsheet you will take full responsibility for any technical issues or anything else that may occur as a result of using the program.
Make a copy: Jigsaw Puzzle Hobby Tracker Link
Contact us at firstname.lastname@example.org if you are experiencing technical issues.
The following Video shows how to save 2 copies to the online Google Spreadsheet plus tips on how to use the Tracker sheets.
The Puzzle Hobby Tracker is a Google Spreadsheet with functions and formulas embedded. There are 30 sheets available by clicking the Pages (tabs at bottom of sheet) and the page with the How To info.
This Tracker is free for you to use and it is set up to track up to 500 jigsaw puzzles but you can also insert continuous rows to tracks up to thousands of jigsaw puzzles. (I've seen Google mention 40K rows but it also depends on how many cells are being used.)
The main 3 features are:
The following images shares a breakdown of the images used on the spreadsheet. Note the last 2 rows on the right side have dropdown lists to choose a '5 star' rating or a 'text description' rating.
Here's what is available to Track:
NOTE: The Time, Number of Pieces and Prices will keep a 'running total' at the top of their columns
Here's the Tracking Details:
1. Enter Date, Title and Start Time at start of session
2. Enter End Time at end of session
3. Times are calculated under Time section
4. Total Time is calculated in Yellow Highlight
5. Carry Total Time over to Master Sheet
6. *NOTE -'Time' Column has preset Formulas (do not use)
1. Track 1 Puzzle up to 5 sessions
2. Track up to 8 Puzzles at a time (scroll to the right to see more)
3. Record Total Time on Master Sheet
4. IF using more than 5 sessions for 1 puzzle
use a second Puzzle Time-Block and add both Times logged together
* To reuse Timer-Blocks highlight the End Time and Start Time cells
Next: right click and select Clear Contents
***DO NOT REMOVE OR CHANGE PINK COLUMNS (preset forumlas are embedded into cells) - IF changed, the time will not calculate correctly for that Timer-Block only. To fix a Timer-Block Highlight a correct Pink-Yellow cells group, Paste to incorrect cells to overwrite the mixed formulas
Instructions: Fill in the rows as shown in sample No. 1 (simply overwrite your information in sample). Use the Insert to upload your puzzle photo and resize to fit the Picture box.
Email email@example.com with questions or assistance and we will do our best to assist you.
TIP: Email as attachement - access the file (anytime) by opening the attachment on device.
Additional Sheets: There are 10 sheets that are labeled Blank. These are extras sheets that can easily be copied IF you lose the embedded formulas by mistake. Or you can use the Blank sheet to tract specific Brands only, or Shaped puzzles only, etc.
Page 29 and 30 can be used for the same purpose. You may also duplicate sheets simply by clicking on the Page Tab at the bottom, right click, scroll up to Duplicate, then give the Page a new Label.
Can I download the Jigsaw Puzzle Hobby Tracker to my device?
Yes you can but be mindful of a few things that can happen. When downloading the 'Sheet' to your device, the program will try to collaborate as best as it can to the Device's available program to use. For example; it may read most of the program if it is downloaded to the Excel program but maybe not ALL of the components of the program will work due to the transmission of data from the internet to your device.
How long can I use the program?
Once you make your own 'Copy', you may use the Tracker forever and modify it to suit your needs. You do not need permission to make those changes. You just cannot sell it or use it for Commercial purposes in the 'state' that it is in due to Copyright reasons.
How many puzzles can I add to the Sheet?
As stated above, there is the ability to insert lines before the end of line 500 so the formulas will continue to be used. Visibly you can see 500 lines but you can insert thousands of lines.
Why should I make 2 copies?
It's best to keep a backup blank copy and an active copy. This is useful in case the formulas or content gets accidentally erased - you can always copy/paste from backup blank copy.
How can I duplicate a Page?
You can duplicate sheets/Pages simply by clicking on the Page Tab at the bottom, right click, scroll up to Duplicate, then give the Page a new Label.
Technical - Keyboard Tips
We have collected a massive list of jigsaw puzzles in numerous categories on our Amazon Store link. It's a quick way to browse most current puzzles and/or specific seasons, accessories and themes. Makes for a terrific one-stop jigsaw puzzle gift giving shopping centre. CLICK HERE