The Lists worksheet is used for a bit more in V Planner than in the previous version. Additionally, List is different in the High School V Planner, so this page only applies to V Planner V4+.
There are four things that may be edited at the Lists worksheet.
1. Today’s Greetings Column D
You can enter up to 32 greetings that will display randomly at the Today worksheet. It’s an opportunity to talk to yourself without looking crazy. Feel free to remove the greetings that I put into the file if you have a lot to say to yourself, but please remember to backup your files whether it’s the V Planner or all of those important digital photographs.
Tip– Repeating a greeting – entering it more than once – increases its chances of appearing on the Today worksheet.
2. Space for Location List Key
Under the greetings – Column D – Control the space between the items in the Location List Key –
Place a space, or two spaces or three in the cell as instructed. The location list key appears on the transcript. If there is more than one item in the list, spaces will need to be added. I could have just programmed them in, but I like to give you control when I can. See image below.
Throughout the V Planner I have programmed a statement to appear when something triggers it. I have made some of the statements changeable by you. Isn’t that wonderful? The Power! If you change the statements, please make the new statements say the same thing, but in your own words.
I introduced the ability to use characters in the V Planner V3. The formula that allows this is CHAR(). In V Planner V4, I expanded the use of char; mainly because of the nice characters that one can use for a key (legend). See the characters used in the location list key in the image above – that was accomplished with CHAR().
The characters used in the key are controlled at the Lists worksheet in column A beginning on row 18. I have already filled it in, but if you need different characters, please visit Lists and change the numbers. For help with choosing numbers, go to the CharMap worksheet.
ONE BIG THING to KNOW – If you edit the charlist after setting up the characters at the Data# worksheets, then you will need to return to the Data# worksheets and replace the particular selections – The reason is this: charlist populates a drop down list and while the drop down list will contain your changes instantly – the selections that were previously made will not update. Drop down lists are nice, but they can be a hassle if one changes the contents of the list after making selections.
That is all to V4’s Lists worksheet.
Note- The High School V Planner worksheet contains an extra item, so if you are using the high school v planner, be sure to go to the High School category and find the Lists article there.