{"id":20424,"date":"2016-03-01T03:01:02","date_gmt":"2016-02-29T17:01:02","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/ITblog\/?p=20424"},"modified":"2016-03-13T20:55:24","modified_gmt":"2016-03-13T10:55:24","slug":"spreadsheet-problem-solving-template-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/spreadsheet-problem-solving-template-tutorial\/","title":{"rendered":"Spreadsheet Problem Solving Template Tutorial"},"content":{"rendered":"
\"Spreadsheet<\/a>

Spreadsheet Problem Solving Template Tutorial<\/p><\/div>\n

We’re keen on the word “template”<\/a> and if you’ve clicked that link you’ll get some technical thoughts on templates, but to me, in layman’s terms, or a programmer’s terms perhaps, it represents a stage of a journey worth snapshotting, that helps you not have to repeat all that hard work you’d done reaching that point.<\/p>\n

Don’t know why, exactly, but Kenny Rodgers<\/a> springs to mind about “template” usage …<\/p>\n

\nYou got to .. know when to hold ’em …
\nKnow when to fold ’em …
\nKnow when to walk away
\nKnow when to run\n<\/p><\/blockquote>\n

… if that song says to you … “think about it” … then that’s what I’m getting at. Not everything is worth a template, believe me. “Template clutter” goes with scratching the head years later, saying … “now why did we do that” … if not well documented … and with that, as far as “not well documented” goes, it can be hugely more useful (and you can do better than we do with today’s slideshow<\/a>‘s “My Templates” here) to keep your templates in aptly named folders with aptly named template files.<\/p>\n

To me, where we got to with LibreOffice and our Problem Solving spreadsheet that we presented yesterday with Spreadsheet Problem Solving Primer Tutorial<\/a> as shown below, that is worth “Saving As Template”.<\/p>\n

With spreadsheet applications there may be different places where “template” selection becomes apparent (on the way back into your spreadsheet application) … for example …<\/p>\n