The only reason to alter a worksheet is to fix a bug and when a bug is found, I will post instructions. If you alter a worksheet for another other reason and if you break it, you are on your own. You will have to download another V Planner, set it up, and then, don’t break it.
I know this sounds ominous, but it isn’t. The bottom line is if you’ve made changes to the V Planner that alters formulas, or makes your planner structurally different , and your planner "breaks," then there is no way that I will spend hours trying to figure out what you’ve done. Most people will not know that they’ve made formula changes, so please read about the actions can potentially make formula changes and then simply do not do those things.
The following is a list of actions that can result in an unsupported V Planner
Inserting Rows – Generally do not insert rows into the worksheets. Inserting rows anywhere among the supported worksheets and except the two sheets listed below will result in a fully unsupported V Planner. Why? Because adding rows can change formulas and, in some cases, it can break some functions.
Inserting Columns – There are no worksheets into which inserting columns is supported. Inserting columns anywhere among the worksheets will result in a fully unsupported V Planner. Why? Because adding columns can change formulas and, in some cases, it can break some functions.
Moving Cells – Moving cells is unsupported. There is a short write up about this at Do not Move Cells. Moving cells might be a temptation in the S-Sheets because you might decide to move lesson plans around, but do not use this method to do that. Moving cells anywhere among the supported worksheets will result in a fully unsupported V Planner. Why? Because moving cells can change formulas and, in some cases, it can break functions.
Altering Formatting – While you are able to change V Planner’s formatting without unprotecting the worksheet, you’ve changed it and there is nothing that you can do to convince me to fix if for you, even if the results alter Conditional Formatting.
If you are unsure of what conditional formatting is, go to an S-Sheet observe how the colors change in the S-Sheets when using the Dynamic Term Grade Calculator when a different term number is selected. This is one of the things that you will not want to break.
Altering formatting because of pasting – Altered formatting of any kind is unsupported, even when it is altered by mistake from neglecting to choose Match Destination Formatting.
Changing Tab Names – Changing Tab names will break hyperlinks in the planner. This action – changing tab names, is unsupported in that I will not relink the worksheets for you.
Right-clicking anywhere in the planner and Using CUT – Please don’t use Cut. Cut removes everything from the cell and in some cases will cause errors in your planner.
Using a V Planner in a program that is not Microsoft Excel will result in no support.
Basically, some changes that you make to the V planner can – best case- result in an unbroken and unsupported V Planner, or – worst case – a broken unsupported V Planner. Either way, I reserve the right not to support V Planners that have been altered in such a way that changes the formulas.
Some worksheets in the planner is not supported because they are not vital to the workings of the planner. Below is a list of worksheets that no one should be concerned about.
- Notes worksheet – Notes is not a vital worksheet and you can do anything that you want with it. Notes is not vital to the workings of the V Planner thus, it is not supported.
- TermDateCalculator worksheet – Term date calculator is an add-on worksheet. It is not vital to the V Planner’s functions, and therefore; it is unsupported.
- About worksheet – It’s primary purpose is the first landing page upon opening the file and it serves no other purpose beyond pointing you in the right direction in the setup.
- Help worksheets – Worksheet that are considered a "help" worksheet are unsupported. They are there to provide information about certain parts of the V Planner and have no bearing on V Planner function. When a V Planner is a brand new version, the help worksheets might or might not yet be fully updated.
- Points to Score is a tool that helps you arrive at a weighted score from a test that have point values. It does not affect V Planner function, so it is not a supported worksheet. IMPORTANT- if you copy and paste the score into an s-sheet rather than just typing it, BE SURE to select Match Destination Formatting after pasting.