Pages: [1] 2 3 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Joseph Shephard
|
Posted - 2009.01.27 10:47:00 -
[1]
The Arcelor Capital A-Sheet
January 27, 2009
The Complete, Multi-Purpose, Manufacturing Toolbox
Executive Summary
Purpose: The profits in manufacturing have never been stronger, but with production costs constantly shifting, it is difficult to elucidate those products with the strongest earning potential. The Arcelor Capital A-Sheet is a dynamic excel spreadsheet that allows up-to-the-day analysis of the best opportunities to make ISK.
Features: Nearly 700 Tech I Items are listed, along with their manufacturing profitability.
Tools available include: Per-Day Profit, Per-Unit Profit, Runs-per-Day, Profit Margins, Total Daily Cost, Total Per-Run Cost, Dynamic Sorting, Category Sorting, and more.
All manufacturing costs and times are also perfectly customizable to character skills, production environment, blueprint levels, implant bonusesùall the variables which can affect manufacturing profits.
The Blueprint Data Sheet, with nearly 700 items and their production characteristics, is worth the entire one-time fee!
Product: The A-Sheet is an excel spreadsheet which fuses raw manufacturing data and daily EVE Market data to produce an attractive, comprehensive, easy-to-use spreadsheet capable of finding the biggest profit opportunities EVE has to offer.
The A-Sheet is a two-part package, a user-interface (the æA-SheetÆ) and an update file with up-to-the-day data on the EVE economy.
The Service: A-Sheets are sold with a 10 million ISK startup fee, and an ongoing subscription of 10 million ISK per month after. Clients receive their A-sheet along with a biweekly updated data sheet which will update the original A-sheet automatically.
ISK is paid to Joseph Shephard in-game. Clients should simultaneously send an EVE-mail to Joseph Shephard listing where they would like the update file sent. We also ask that clients send along what version of Excel they have on their computer. When paying subscription costs, they simply give ISK with the reason æsubscription feeÆ in the reason line.
VISIT HTTP://WWW.ARCELORCAPITAL.COM TO LEARN MORE ABOUT THE A-SHEET |
Joseph Shephard
|
Posted - 2009.01.27 10:48:00 -
[2]
reserved |
Joseph Shephard
|
Posted - 2009.01.27 10:49:00 -
[3]
reserved |
Ricdic
Caldari
|
Posted - 2009.01.27 12:18:00 -
[4]
What stops people from pirating the sheet? I am ordering one copy btw |
Joseph Shephard
|
Posted - 2009.01.27 12:28:00 -
[5]
Edited by: Joseph Shephard on 27/01/2009 12:28:11 It wouldn't be overly easy to pirate the sheet. This is for a few reasons: 1) To help clients prevent accidental changes to the complex formulas, we locked all of the cells that should not be changed. As a result, all inputs can be altered (such as your skills, your POS modifiers, what BPOs you own and what their ML and PL are) but the cells that are purely computational are locked. Hence, it is not possible to just copy the sheet or copy the formulas. 2) Some items have consistently positive profit margins but many others oscilate between being money-makers and money-losers. Without updating your sheet with our mineral price and product price updates, all of the data on the sheet will become inaccurate.
To a certain extent, it is impossible to guarantee the complete pirating of the sheet. If our clients purchase it and consistently spread both the Master Sheet and the Price Updates to others, we will be very sad. Hence, at a certain point, we must rely on the morality of others (and the fact that -- if you spread this information around for free -- you are giving up your own strategic advantage).
Any other questions or comments, please let us know. We're very excited to have finished this (it took several long nights) and look forward to seeing what you all think!
J. Shephard Arcelor Capital
|
Ricdic
Caldari
|
Posted - 2009.01.27 12:47:00 -
[6]
It would have been more awesome if your first name was John btw.
However based on the service you are offering, Dr Rodney McKay is a far wiser choice of name.
How accurate are those prices btw? Are they pulled from Eve-Central or updated personally by you guys? And are the price updates covering just raw minerals? Moon minerals? components?
Also by buying this package will you include an expansion to cover t3 production when it becomes available? |
Zakalwe Staberinde
Gallente Malevolent Evolution
|
Posted - 2009.01.27 12:52:00 -
[7]
I order one copy. Sounds like an awesome job! |
Joseph Shephard
|
Posted - 2009.01.27 12:59:00 -
[8]
Originally by: Ricdic It would have been more awesome if your first name was John btw.
However based on the service you are offering, Dr Rodney McKay is a far wiser choice of name.
Having seen the show and knowing the two, I take that as high praise :)
As long as you cut out the weird anti-social qualities of the later.
Originally by: ricdic How accurate are those prices btw? Are they pulled from Eve-Central or updated personally by you guys? And are the price updates covering just raw minerals? Moon minerals? components?
The majority of price data is pulled from Eve-Central and is, as a result, prone to some of the same problems Eve-Central is prone to. For instance, very low volume items and items that are not frequently exported to Eve-Central will be less accurate.
However, we have added a few steps of our own to try to get a more accurate figure. This involves using different aspects of both buy and sell prices and -- for very specific products -- using a price-of-last-resort determined by prevailing mineral prices. For most items, the prices are very good. For Titans, Carriers, and rigs that have never been purchased in the history of the game, you might want to add some research of your own to bolster our calculations.
Originally by: ricdic Also by buying this package will you include an expansion to cover t3 production when it becomes available?
We use this sheet ourselves when looking at manufacturing, so our hope is to keep it as updated as possible. Whether or not we can expand it to include t3 depends partly on how t3 manufacturing works and whether or not it is conducive to being modeled. It's definitely on the "to do" list if at all possible.
As for the issue of it being included with this purchase, I would say we hope so but it's not guaranteed. Our hope was that the A-Sheet could be widely used so that we could keep costs low while still making enough ISK to do further programming in addition to the promised price updated. However, if there are few users the possible upside might not be worth the level of pain it would take to expand the sheet into t3.
So... tell your friends to buy a copy and you increase your chance of a free t3 upgrade! (innocent smile)
J. Shephard Arcelor Capital
|
Joseph Shephard
|
Posted - 2009.01.27 13:05:00 -
[9]
Originally by: Zakalwe Staberinde I order one copy. Sounds like an awesome job!
Zakalwe -- What version of Excel are you running? We have different versions of the file depending on whether or not you are running Excel 1997-2003 or an Excel version later than 2003 (such as 2007).
Anyone interest, please make sure that your Eve-Mail to Joseph Shephard includes: (1) The email address you want the files sent to and (2) What version of Excel you are using.
Thanks!
|
Kitchie
Gallente Kitchie's Logistics and Marketing Corp
|
Posted - 2009.01.27 13:07:00 -
[10]
I'd like to order a copy as well please
|
|
Muscaat
Eve University Ivy League
|
Posted - 2009.01.27 13:20:00 -
[11]
Any advice on OpenOffice compatibility? |
Damien Jax
Industrial Research College Ltd
|
Posted - 2009.01.27 13:30:00 -
[12]
What are the differences between this and Dedfal's spreadsheet? |
Joseph Shephard
|
Posted - 2009.01.27 13:33:00 -
[13]
Originally by: Muscaat Any advice on OpenOffice compatibility?
I happen to have Open Office so I opened it up and poked around the file. At first glance, it seems to be 100% functional for everything that really matters. However, a lot of the "extras" such as conditional colorings have been stripped away.
My impression is that users of Open Office could use this program and be entirely happy with the results. If that proves to be untrue, we are more than willing to work to fix the problem with you and -- if that proves to be impossible -- return your payment.
J. Shephard Arcelor Capital |
Joseph Shephard
|
Posted - 2009.01.27 13:34:00 -
[14]
Originally by: Damien Jax What are the differences between this and Dedfal's spreadsheet?
Damien, I'm not all that familiar with Dedfal's spreadsheets. A quick eve-search didn't bring up any hits for "Dedfal" so could you provide me with a link? I'll take a look sometime today between classes and let you know this evening when I get back. |
Damien Jax
Industrial Research College Ltd
|
Posted - 2009.01.27 13:41:00 -
[15]
Sorry, it was Dedaf.
Dedaf's tool |
Aadris
|
Posted - 2009.01.27 13:56:00 -
[16]
Looks great. Could you add a reprocess section that allows you to input your skills and the price of mins components etc and see the value of reprocessing something? I'd buy a seperate spreadsheet just for that or the same one with the reprocessing bit added for a bit more. |
Joseph Shephard
|
Posted - 2009.01.27 14:18:00 -
[17]
Edited by: Joseph Shephard on 27/01/2009 14:18:58
Originally by: Damien Jax What are the differences between this and Dedfal's spreadsheet?
Ok, I got to look this over before I went to class.
Dedfal's tool is a really nice little app, but it doesn't quite do what the A-Sheet does (unless there is a part of Dadaf's tool that just escaped me). Think of it this way: If you know what you want to build and you want to know exactly how much it will cost you, it seems you could use Dadaf's tool. What our A-Sheet does is that it instead calculated exactly what it would cost you to make 700 T1 items all at once. Hence, our sheet will help you identify markets you want to get into in addition to telling you the time and mineral requirements associated with the production.
Theoretically, if you entered the data for every single item into your saved content for Dadaf's tool, it would be nearly the same as my sheet, but mine saves you the trouble of entering about 10,000 data pieces into the tool manually.
If you want more details on differences I can look some more, but my first impression is just that: Our tool analyzes nearly all t1 items without needing any input other than your skills, Dedaf's analyzes products only as you enter them.
As for the reprocessing calculator, that is on the "short list" of things to add simply because of how easy it would be to do. The only reason it's not in this version is that I worked all night on it, got it working for manufacturing, prettied it up, and decided I just didn't want to do a reprocessing calculator at that moment. :)
J. Shephard
|
Keyser Kahn
Stellar-Parallax Corp
|
Posted - 2009.01.27 15:45:00 -
[18]
Nice looking sheet - I'll drop you an eve mail later along with a transfer of 20 mill to cover the sheet and updates.
(Oh and for when I forget later Excel 2007 would be the bunny)
Cheers
|
Juyfne
|
Posted - 2009.01.27 15:55:00 -
[19]
You said that prices can be off due to Eve-Central inaccuracies..is there a way to update prices/costs manually?
|
Damien Jax
Industrial Research College Ltd
|
Posted - 2009.01.27 16:11:00 -
[20]
So will it draw market prices of the produced good and compare that with the cost it takes to build and tell you the profit you can expect? Or do you still have to research the market price of the product and then just calculate how much it costs to build?
If the sheet tells you where the opportunities are (by analyzing and comparing the costs - sale price of a product) then your tool is extremly useful. HOwever, if all it does is tell you how much it costs to build, but you still have to research the market prices of the finished good, then Dedaf's tool does that. YOu can input how many items you want to build as well and it'll tell you the cost of materials needed.
|
|
Joseph Shephard
|
Posted - 2009.01.27 17:11:00 -
[21]
Originally by: Juyfne You said that prices can be off due to Eve-Central inaccuracies..is there a way to update prices/costs manually?
Right now, you can expect the prices to be accurate for every item that is sold in a respectable volume on the Market (excluding contracts, of course). So, if you are interested in anything other than Motherships, some Carriers, Titans, Capital Doomsday Mounts, you should be great. For all of those items (and there are very few of them) our spreadsheet calculates all of the material costs, buy taxes, time it takes to produce, etc but it will leave sell price as zero.
If you want to manually enter a price for these items -- or for any other item -- it's not currently possible. However, you can take the calculated figures for cost to produce (inclusive of material costs, taxes, and slot rentals) and simply subtract that from whatever you would have used on a basic scientific calculator to get profit per unit.
The reason you cannot manually update the prices is two-fold: The primary reason is that if we didn't lock the cells, inevitably, 30-50% of people would accidentally erase at least one formula and the errors would propagate through the entire sheet. The secondary reason is that if we leave everything unlocked, there is really nothing that stops anyone from stealing the spreadsheet, its formulas, and even the updating system. If you have special reasons to add prices manually instead of automatically, send me an Eve-Mail and maybe we can work something out for the specific case.
Originally by: Damien Jax Things in the Last Post
It's the second case -- the extremely useful one. All prices are updated automatically every time I send out a price update file. As of right now, that is planned to be two times per week at minimum but quite possibly more if you want (it takes about 15 minutes to create the update files and probably another 5 minutes to email them -- I just don't want to clog people's emails with Eve Price files if they don't want them that often).
That way, all you have to do is open our files, it will calculate the cost to produce everything automatically, it will update the sell prices automatically, and then it will spit out the profit per unit, profit per day, and profit margin as well as a dozen other statistics. Then you can sort them by whatever you want, filter them by various groups if your version of Excel allows, etc.
Our sheet also does what Dadaf's does -- tell you how much minerals you need for production given your skills, POS, BPO ML, etc, but has slightly less functionality on that end (mainly, it only gives you the material costs to produce one unit, not "x" units). However, ours has the added bonus that any BPO specific information you input such as ML and PL will be automatically entered into the overall profit analyzer, so you don't have to compensate for that manually.
Keyser and Others -- I just wanted to clarify in case there was any confusion. Purchasing the A-Sheet costs 10 Million ISK and it comes with data loaded into it as of today. Every month in which you want to receive updates costs 10 Million in addition and purchases you between 8 and 16 price updates for the month (prices update for every product and every material input). So, Keyser, your scenario of sending 20 Million ISK gets you the sheet and the full update service for one month (which I think you understood but I just wanted to make sure). Those who send 10 Million can get the sheet, take a look at it to see if you like the quality and functionality, and then decide if you think it is worthwhile to send another 10 Million ISK per month for the 8 to 16 updates.
J. Shephard Arcelor Capital |
J Carreg
Royal industry and research Zzz
|
Posted - 2009.01.27 18:04:00 -
[22]
Would like to order one sheet please
|
Zakalwe Staberinde
Gallente Malevolent Evolution
|
Posted - 2009.01.27 18:19:00 -
[23]
Edited by: Zakalwe Staberinde on 27/01/2009 18:18:53 Have you send the file, because I didnt get anything yet |
Damien Jax
Industrial Research College Ltd
|
Posted - 2009.01.27 19:03:00 -
[24]
Sounds good Joseph, I also actually read the information on your website, I suppose I should do that :P lol.
A couple of things:
Why not implement a macro that we can hit to connect to a webserver of yours and auto-download the update info? Dedaf does this with an update button that connects to eve-central and downloads mineral prices. DOing this would alleviate some of your work that you need to do.
Do the market prices exclude outliers? I hate those items where people try to sell at 1 million for something that costs 100,000 (to trick noobs who get quantity/price columns mixed up).
Charting solutions would be useful as well to compare and contrast profit margins and all that jazz. THough, you could just get it from the data in the tables, it's just prettier! Also, utilize 2007's auto conditional formatting, it's cool.
When I get home from work, I'll probably go ahead and order it just for a trial to see if it's useful. |
Saira Jin
|
Posted - 2009.01.27 19:26:00 -
[25]
Can someone who has bought this post a fair review please? Else, if I can act as a reviewer based on trust, I will do this - though I am no expert in the market.
Thank you.
|
Joseph Shephard
|
Posted - 2009.01.27 19:55:00 -
[26]
I am back from class, so anyone who has ordered a sheet so far today should have it within the next 30 mins. Please let me know via Eve-Mail if you do not have it after this time.
Hopefully those of you who are looking for reviews before making a decision will hear one way or the other soon.
J. Shephard Arcelor Capital
|
Zakalwe Staberinde
Gallente Malevolent Evolution
|
Posted - 2009.01.27 20:34:00 -
[27]
Confirmed, received 2 files. Checking it out right now. |
J Carreg
Royal industry and research Zzz
|
Posted - 2009.01.27 23:14:00 -
[28]
Received the document and have been playing around with it for the last 10 mins. First impressions are good. however I dont feel I am fitting enough information on my screen, and scrolling along to find the information I want/need gets boring very quickly. Is there any way to make the font smaller maybe? or the grids alittle smaller. I think would help a long way towards solving this.
A couple of things also snagged me up. One was the working price. This is obvioulsy taken from your price update sheet. I think it would be nice to allow me to put in my own working price so that if I get the minerals for lower than the working price I can see exactly how much profit I have made.
The second would be that I can you only take price data from the forge region. I would seriously think this is limiting your user base as different people operate in differnt regions. I understand why the forge was chosen, however having the option to change would be awesome. Are there any further plans to change which price sheet you get or even to be able to change the region on the sheet itself? going further on this, what about getting prices for just one system (probably only the market hubs) or even getting the buy prices from the forge, but selling in Lonetrek?
Figuring out the top selcetion stuff is confusing as well (to someone who hasnt really read the instructions and has just jumped in with both feet to have a play). Took 2 or three mins to figure it out completley. An idea would be: on the Production summary sheet, in the item name coloum, to be able to add products to that coloum as I see fit. So say if i wanted to compare an Osprey to an Omen, I would be able to add them both to a list and be able to view the figures next to each other. Yes there already is somethign like that with the parent groups, however condensing it down would be awesome.
Will continue to play further later. However from me its a big thumbs up so far.
|
Joseph Shephard
|
Posted - 2009.01.27 23:57:00 -
[29]
Edited by: Joseph Shephard on 27/01/2009 23:57:49
Originally by: J Carreg Is there any way to make the font smaller maybe? or the grids alittle smaller. I think would help a long way towards solving this.
I understand what you're saying. There's a lot of information to wade through on the summary page. I played around with font sizes, and in my opinion it's hard to read on any font size lower than 11. I'll look to see if there are ways to legibly condense it though (maybe I can turn the headers sideways so they take up less space and pack the columns 33% closer together.
Originally by: J Carreg I think it would be nice to allow me to put in my own working price so that if I get the minerals for lower than the working price I can see exactly how much profit I have made.
I guess I can add another column to the calculation of mineral prices where each person could enter their own values and then they could turn on and off whether or not they want their custom input values or the auto-updated data. I will add it to the short list of upgrades that will hopefully take place in the next 7 days.
Originally by: J Carreg The second would be that I can you only take price data from the forge region. I would seriously think this is limiting your user base as different people operate in differnt regions. I understand why the forge was chosen, however having the option to change would be awesome. Are there any further plans to change which price sheet you get or even to be able to change the region on the sheet itself? going further on this, what about getting prices for just one system (probably only the market hubs) or even getting the buy prices from the forge, but selling in Lonetrek?
The short answer is that there were no plans to do this in the near future. And the reason isn't that I love the Forge, it's actually very different from that. Because of Jita and the surrounding systems, the Forge typically has the lowest sell prices on almost anything. This means that you typically cannot buy minerals for cheaper than the Forge without venturing into lowsec. Also, the products you sell are typically are also at the lowest.
"Why," you ask, "do I want to calculate using the lowest sell price for the items I'm manufacturing?" The reason is that this spreadsheet is supposed to capture the value created by the process of manufacturing. If you are traveling around to buy cheaper minerals and then manufacturing with them, you are no longer just manufacturing. You are hauling minerals and then manufacturing. Just like if you manufacture rigs in the Forge and then sell them in Domain because you get a higher price, you are manufacturing and then hauling rigs.
This isn't to say you shouldn't buy the cheapest minerals and sell at the highest price possible because clearly you should, but the change in value derived from moving minerals, components, and final products is trading profits and not really manufacturing profits.
Also, Jita/Forge has the highest resistance to manipulation in popular markets and more people export Forge data to Eve-Central than the other regions. Hence, from a completeness standpoint the Forge is vastly superior.
Might we add other regions in the future? We might but unless a great many people call for it I don't think its on the short list for now. I think allowing you to enter custom mineral/component prices will allow you to do most of what you're looking for as a compromise.
Originally by: J Carreg ...add them both to a list and be able to view the figures next to each other...
I have an idea for how this might be done. I made a sheet that does something very much like that in first version of the A-Sheet I tried to make. I'll fix it up, add it back, and see what you guys think at the next update.
Originally by: J Carreg Will continue to play further later. However from me its a big thumbs up so far.
Glad to hear it :) |
ksc1226
|
Posted - 2009.01.28 00:00:00 -
[30]
Looks Interesting. I sent u the isk looking forward to checking it out. |
|
|
|
|
Pages: [1] 2 3 :: one page |
First page | Previous page | Next page | Last page |