Hi,
is there a plan to add beginner template with kgs or an option to choose between kgs and lbs? Reason i ask is in lbs there is no possibility to enter fractional values. I know i could recalculate kgs to lbs and round them up or down but… i foresee i will get lazy 
Thanks!
I second this. Calculating all values from lbs to kgs and the other way around is a hassle. Does someone have a solution for this or is it planned to be made? It would definitely spare me a lot of time. Thanks!
I think I’m missing something the templates do for us. What happens if you just always enter everything in kg…it doesn’t work?
It rounds up fractional values. Smallest plate is 1.25kg which means both of them give 2.5kg increase. Enter that in xls and it will round it up to 3. So every time i see weird value i have to remember that it is actually something else. Also, it seems this is just display issue since when i hover over the cell it shows correct value, but it displays it rounder up. So yeah, not a problem but a hassle.
Ok, so if you want to go up from 60 to 62.5 and enter 62.5 for weight you see “63 lbs” in the weight column. There’s not really any confusing that this means anything other than 62.5 kg, however it is uglier and says lbs instead of kg.
Are you using google sheets or excel?
If the former the easiest way to fix this (will be very similar in excel)
highlight the cells you want to change (in this case for the first exercise on a week, select E31-E39).
Select Format → Number → More Formats → Custom Format
Now you should see a window pop up with a text box that says 0" LBS" Change it to say 0.0" KG" (or kg if you prefer). And click Apply
Obviously this only changes that range. There are several sheets/ranges to update. If you are using Google sheets, I could probably throw some javascript together in 10 or so minutes to update the ranges for each exercise, estimated one-rep max, tonnage and the summary at the top of each of the “Week X” sheets. Of course, then you’d have to run the script on your copy.
Let me know if interested and I could look into it.
Thanks man.
I’m using google sheets. I will try your suggestion but in parallel you could provide me with the script 
Sure. Note I was lazy and didn’t bother writing a loop, as much so you could edit it if the template you have has more or less than 13 weeks.
Tools → Macros → import macro and then paste this guy in the script editor that pops up and then run it. Note that you’ll have to allow it to run–which is why I’m giving it to you in this format as opposed to “sharing” a script. If I share a script and you use it you’d have to trust that some random person (me) isn’t doing ugly things in the script to your account stuff. 
I ran it and it updated all 13 weeks on my strength template to kg with a single decimal place.
Note that the ranges may be slightly off depending on which template/version you are using. If the first exercise for the first day, for example, is E32:E40, you’d change it to that.
Good luck and let me know if you need help!
function UpdateLbsToKg() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var mySheet = ss.getSheetByName(‘Week 1’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 2’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 3’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 4’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 5’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 6’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 7’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 8’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 9’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 10’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 11’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 12’);
mySheet.getRangeList([‘F7:F18’, ‘E31:E39’, ‘E40:H40’, ‘E44:H44’, ‘K31:K39’, ‘K40:N40’, ‘K44:N44’, ‘Q31:Q39’, ‘Q44:T44’, ‘Q40:T40’, ‘E55:E63’, ‘E64:H64’, ‘E68:H68’, ‘K55:K63’, ‘K64:N64’, ‘K68:N68’, ‘Q55:Q63’, ‘Q64:T64’, ‘Q68:T68’, ‘E79:E87’, ‘E88:H88’, ‘E92:H92’, ‘K79:K87’, ‘K88:N88’, ‘K92:N92’, ‘Q79:Q87’, ‘Q88:T88’, ‘Q92:T92’]).setNumberFormat(‘0.0" kg"’);
var mySheet = ss.getSheetByName(‘Week 13’);
};
Thanks Smokes for figuring this stuff out. It seems to work to just go by all the cells I want changed to KG and change the number format (or try to get your macro to work). It works for all the mentioned cells although there is one cell I can’t seem to figure out, it’s the cell with ‘ONE-REP MAX: xx lbs’ on the tab ‘CALCULATORS’, still in the Beginner Template. It seems to be a custom kind of thing. Do you know what’s going on here and how I can change this cell to have kg as well?
Ron–is it the number that shows up in pounds, the label or both?
If it’s just the label, it is easy to fix. It looks like that is indeed a very special format–to update it I would :
Click on the cell
Format → Number → More Formats → Custom Number Format
Select the first one in the list which should be: “ONE-REP MAX: “0” lbs” and change it to: “ONE-REP MAX: “0” kg”
If the source fields (E9 to N9) are also showing up still in lbs instead of kg we’ll have to fix those as well. Let me know and good luck!