Unless I have an old book, or am doing math poorly
weapon Proficiency per sheet costs 40, per rule book costs 6 and I have to sell back 4 crit attacks to get it.
As noted above, the spreadsheet is currently hard-set to display the Scholar costs in the Cost column (column D), but there are a couple of ways around this.
1) You can just look at column K to see the results of Skill purchases for Templar; the costs are all accurate there, with row 4 giving you an accurate Body Point total for the build required for selected skills; if using the Build Override box, row 2 will also tell you how much build you have free to spend (if it's positive) or how much extra build you need to have all chosen skills (if negative). Your Validation box will likely end up yelling at you at some point using this method, but if it's only a "You need X more build" message and cell K2 isn't a negative number you can safely ignore it.
2) You can manually force the spreadsheet to calculate everything for a Templar. If you look at the top of the spreadsheet, you should note that it goes straight from column Q to column S; in between those columns there should be a set of arrows that looks something like this [<>]. If you click that, it will show column R, but more specifically cell R2, which should have "Sr" already in it. That's the abbreviation for Scholar, and the spreadsheet references this abbreviation when calculating just about everything in columns B and D; since you want Templar, delete Sr and put in T, which will force the spreadsheet to calculate everything for a Templar.
3) You can make the Class drop down menu work properly. If you follow option 2 up to the point where you change what goes into cell R2, instead of putting in T, instead put in "=VLOOKUP(Q2,'Class Abbreviations'!A:B,2,FALSE)" (no quotation marks, credit to IMoriarty). This will make R2 autofill the proper abbreviation of the Class chosen in the drop down, which will change the spreadsheet as noted in option 2.
I recommend using option 3, but if you're afraid you're going to mess something up by messing with cells and references, option 1 is the safest bet until a revision is made to the source sheet.
ETA: If anyone is having issues with the instructions for options 2 or 3, feel free to PM me and I'll do what I can to help you out.