Hey guys, so lately I've been working on building my own Profession Leveling Kit Spreadsheets. I'll attach them so you can view and get a better idea of what I'm talking about, but they basically all look like this:
If you don't want to download it, how it works is pretty simple (pretty basic, just something for ease). It's partially for WHILE I'm building, and partially for being used PRIOR to building. Once you get a feel for the market, you can look at what you have in stock and the prices of the mats beforehand, and can usually give a decent price quote to somebody before building the kit just by looking at this. Before, I was inputting prices manually. That was awful. After seeing Stede & Mithrildar's MoP Shuffling Spreadsheet though, I decided I wanted to try and do something like this. Granted, it doesn't need to be as neat or simple as that one, where anybody can get their server info with minimal effort, but just something to replace manually entering the price ranges. Anyway, it's a basic layout, where you enter the amount of stock you have in the "Have" column, the "Needed" automatically updates. Later today I'm adding two other options, one will be the "Total Projected Cost (Minimum)", where it will just calculate how much the kit will cost at a minimum, if you were to buy all pieces at the Lowest Buyout. This would be for the ENTIRE kit. The second will be "Total Projected Cost Remaining (Minimum)", which will be the same as before, but will only calculate the minimum price on what you still have to buy to complete the kit. More details will come as I build it, for easier access, but to be honest, I'm not overly experienced with Excel - I'm teaching myself as I go, using multiple online sources.
Now, if you look at the top right, you will see where I have a section *Reserved* for Importing the WoWU data for my realm (or eventually, of any realm you decide to select, such as in @Stede 's Shuffler. However, that is for later. Now, I just want to know how to import data from WoWU (I read Fetching WoW API AH data into Excel / Google Spreadsheet and Imported the data, but wasn't sure of what to do with it) then draw the prices for the items I want from that imported data to the specific areas on the spreadsheets. I would love to get the price as the 15th centile, but I would also settle for Lowest Buyout if that's easier, or the only option available. Now, if someone helps me out and just does it for me, to get it done, great. But, I would really like to learn HOW to do it, so I'd like to actually have someone help me through the process of doing it. Then, after it's all finished, I can put the entirety of my finished project out for anyone to use! I can also use the information to build more spreadsheets later. So, thanks for any help in advance, and I'll definitely +rep anyone who can help me out!