Yearly Lolita Wardrobe Tracker (Template)

	B	C
1		READ ME BEFORE YOU START ADDING ITEMS
2
3	Hey There, Thank You for downloading this Yearly Lolita Wardrobe Tracker! I made this as a way to catalog my own wardrobe but hope this spreadsheet allows you to have more insight into your wardrobe as well. This is just the first version and I hope to make more future versions with more robust charts and item breakdowns, as well as built in budgeting tools. For now, please enjoy the spreadsheet and feel free to customize it to your needs. If you need any help or have suggestions for future versions, please reach out at kimbuuchavlogs at gmail dot com. This spreadsheet is totally FREE but if you'd like to support me, consider buying me a coffee
4	https://kimbuucha.live/coffee
5	Kim
6
7	Step 1: Download a Copy
8	To download a copy of this spreadsheet, go to File -> Make a Copy
9
10	Step 2: Get Familiar with the Dashboard
11	DASHBOARD TAB
12	Provides an overall view of your wardrobe and allows you set reminder goals for the year. There are two places to pay attention to on this tab:
13	- The Chart Filters
14	- The Current Year
15
16	The Chart Filter slider controls what is displayed in the graphs. You can select one year or multiple years. To Select a year, press the "ALL" drop down list and choose the year(s) you would like to filter. This is best used when choosing one year at a time, but if you wanted to see totals across multiple years, you are free to do so
17
18	The Current Year text field controls the amounts shown in the "Total Pieces Added" and "Total Spent" fields below it. To change the values displayed, change the year to the year of your choosing, for example, 2022
19
20	Item Breakdown Chart
21	This chart gives you a percentage of how many items were acquired based on the year chosen in the Chart Filter slider. This could be helpful to show you where you might be heavy in some items and lacking in others.
22
23	Color Breakdown Chart
24	This chart gives you a percentage of how many items per color were acquired based on the year chosen in the Chart Filter slider. This could be helpful to show you at a glance where you might be strong in some colors but lacking in others.
25
26	Total Spent
27	The dreaded total spent chart gives you a sum of how much money has been spent based on the year(s) chosen in the slider. Note that if no prices exist for any items for the year selected, the chart will display NO DATA.
28
29	Goals and Notes
30	These are free form text fields and you can enter whatever information you like
31
32
33	Step 3: Add some items to your Wardrobe List
34	WARDROBE LIST TAB
35	The Wardrobe List tab is where you add all of your wardrobe items. Use this tab to add/remove any items. Using the dropdown lists, you can categorize items in your wardrobe. Note: The values returned in the drop down lists is controlled by the Values tab (see the section below)
36	Note: The Year field is designed to document the year the item was added to your wardrobe, not the year it was released
37
38
39	FILTERING THE WARDROBE LIST
40	If you have a wardrobe full of envy or a LaForet sized closet, you can filter the options in the list by selecting the upside down triangle next to the column headers to choose a filter option.
41
42	CHANGING THE CURRENCY
43	By default, the currency used in the spreadsheet is set to US Dollars. To change the currency: 1. Select the "Price" column and select the entire column 2. Select Format from the menu options 3. Select Number 4. Select More Formats 5. Select More Currencies 6. Choose your currency from the list of options and hit the green Apply button
44
45	VALUES TAB
46	The Values tab is where you can control what displays in the drop down lists displayed on the Wardrobe List tab. This list is not conclusive and will vary depending on the lolita. Please feel free to update this list to cater to your closet accordingly.
47
48	UPDATING THE DROP DOWN LISTS
49	To update the list, add/update a value to the appropriate column. That option should now become available in the drop down list when you come back to it. ⚠️ Note: If you remove an option entirely, it will cause an error for any items that previously referenced that value.
50
51
52
53
54
55
56
57