Fashion Assistant
Introduction: Fashion Assistant
This project you are able to turn your clothes into easy data, which won't only keep track of all your clothes but able to accomplish some feats you couldn't have ever thought to accomplish. To be able to perfect your wardrobe, so you can live your fullest life. There are quite a few big problems with how to work the solution. I would have to say my favorite one would be the functional dictionary, which basically troubleshoot problematic clothing, to fix the annoyances. So this is all non-coding so it is easy to follow along, if you know the basics of excel which is a mirror image of open office. I am a proficient coder, so some parts do have like that coding talk to it. I realize this guide through isn't perfect, but I will go back and edit if you are having a hard time understanding it. As well as answer comments.
Supplies
* printer paper
* printer
* computer
* open office (open source)
* no staple stapler
* cutting board
* clothes
Step 1: Gathering the Clothes
This step is to gather the clothes that you want to put into the system. The system can accommodate for not just t-shirts or pants, but also accessories such as jewelry, ties, wigs, bolos and ectara. It should not be used for items that don’t exist in the clothing category.
Step 2:
As you have collected your clothes, now you must collect the data that exists from your clothes such as make of the clothes that means if it’s a skirts, jorts, robe, ectara. The other categories are self-explanatory such as main color, brand, clothing material, age, country of origin, size (optional), and rank (optional). The clothing material stated if its over 10%, you should include it as clothing material. The age of the particular clothes is what year you believe it is from such as scarf from 2015, even if your wrong about the particular year. Though you could track down the exact year of when the article of clothing was produced, though that could prove difficult. Rank is for emergency case scenario if you have two articles of clothing that are same in every category, but that never really happens.
You will want to set up the spreadsheet, then collect the data and input the data. 242
You will need to come up with acronyms that fit with each data you have inputted. Such as if you had a Sweater you need to input it like so SW,Sweater. It is important that there is a comma and that there isn’t any space. The acronyms once typed for like TS,Tshirt will next time auto suggest the rest of the word once ts is typed so all you have to do is enter it. You also don’t have to worry about managing acronyms as much, since they are column specific.The yellow highlighted row was simply an example of the process, that matches with the picture.
Step 3: Set Up for Text to Columns
This the part which is setting up for turning the article of clothing into a specific code. So the picture highlights what is needed to be done with every single category.
Step 4: Preserve Code Dictionary
The code category needs to be copied and pasted into the dictionary category. The dictionary category is basically to make updating the spreadsheet easier in the future.
Step 5: Text to Columns
The next thing to do is to highlight the specific code column, then go to data, then text to columns. It is important that comma is the only one that is selected before applying it and shows you a preview of it. Click accept.
Step 6: Identification Codes Formed
The next thing you need to do is head over to Identification codes category. You will need to type =concatenate(B2,E2,H2,K2,N2,Q2,T2), what concatenate is doing is simply to combine the acronym codes to create an identification code for that specific clothing item. In the second photo there is a dark small box next to the identification code, if you click and hold on that down the list end. It will auto calculate the answers for you, so you it saves you from having to do repetitive work to achieve the same result.
Step 7: Clean Up(hide Columns)
It is looking kind of messy so you will need to hide the acronym code and dictionary columns. But don’t hide the identification codes column.
Step 8: If It Needs to Be Updated(Optional)
First you will need select all columns then left click go down to show all columns. Go to the dictionaries for each category to input the data. After that copy it over to the code category, the go to data, then text to columns, commas only. 316