I thought about publishing it, but I'm not ready to yet. I know it's a little greedy of me, but I'm afraid if I publish it, there would be an influx of people RSing the same items I do!
you know what though, I *CAN* publish the template and let you fill in your own info!.... hmmmm.... give me a little while on that k?
you'll need to have MS Excel to use it.
EDIT: Ok, here it is.
Right click on these words and Save Target As...
Lawyerbot piece: I give my word that this is a safe item. It is a spreadsheet for use in restocking. The only formulas in it are simple addition (well, subtraction). There are no macros or anything that I put in it that can harm your computer, and once it's on your computer I no longer have access to it; I can't steal anything from you. However, if you don't feel like you can trust me, DO NOT DOWNLOAD IT. Please also let's not have any discussion about whether this is safe or not. I say it is, if you don't believe that, I am not making you download it, so just ignore it.
If you download it, you are saying that you read the instructions below, and you are releasing me of all responsibility if anything bad happens on your computer because I'm not there with you to be your excel tutor. Also, of course remember to back up your work frequently, and I am not liable for loss of data if you mistakenly save this item over your own spreadsheet with the same name, blah blah blah.[/color]
Ok.
How To Use This Spreadsheet:
*First, you must save it to your computer, and you must have MS Excel to open and edit it.
*Second, there are two tabs at the BOTTOM LEFT of the screen. One says Enter Your Data Here. That should be self-explanatory. The other tab says Print - Do Not Type Here.
Pay attention when you are typing in this spreadsheet. If you type on the print side, the sheet won't work!!!!
I can't tell you how important this step is. Mainly ignore the Print tab until you are in step 4.
*Third, I have included some samples on how to fill in the data.
Type the item name in the Name column (on the DATA tab, remember!)
The Cost column is for how much it costs in the shop. I recommend just putting what the shopkeeper originally asks for, not the price you'll haggle for, because haggle prices can change.
The Value column is for how much it sells for on the shop wiz. I recommend putting the LOWEST price you see, not an average price.
The Profit column will automatically calculate. Do not type anything in that column, or it will stop working.
*Sort the ENTER DATA HERE tab before going on to step 4, and DO NOT sort the print tab. You will see that the print tab automatically sorts itself according to what you have in the data tab. just don't touch the print tab, ever, except for step 4, which is really not necessary.
*Fourth, once you have figured out profit, if you know how to use Excel, I recommend going into the Print tab and selecting the items that have good profit, and making them either bold or red (i put one example of each for you to look at). If you don't have a color printer, use bold, not red.
Select the items that have bad profit (under 100 np, or negative) and make them gray, or italic or something hard to read.
OTHER NOTES:
*If you don't know how to use excel, and don't have the chance to learn how to bold/change text color, then I recommend printing it plain and using a highlighter.
*
DO NOT, and I repeat again more emphatically DO NOT change the font sizes, font type, or column widths on the Print tab. If the small size is too hard for you to read, I recommend making it whatever size/font you want IN THERE, and printing it from there. Do not mess with the print tab unless you really know what you're doing. It can cease to work if you mess with it.
*The print tab will always print out as 3 pages, even if you have only 10 items. If you have
more than 349 items, you will either have to set up more print pages if you know how, or just pick your favorites and delete the others (recommended), or print from the other page.
Last edited by
miz sparrow on Wed Apr 26, 2006 4:29 pm, edited 1 time in total.