I saw Jaerin's spreadsheet a while back, but he took it down and is now charging 50 dollars for access to it.
I plan on contacting him about joining me as a collaborator on my own spreadsheet, and adding some of the RMAH stuff from his, as I don't really want to just copy his formulas.
I'd like to extend the same invitation to you, being that we're all working on the same sort of thing, and it makes more sense to work together and make one awesome spreadsheet that does everything.
I'd also like to put together a web/desktop/mobile app, but I don't really have the time to invest in it at the moment - I've spent at least 20 hours working on my spreadsheet alone, and that doesn't even put a dent in the time it would take to build a decent app with the same features.
I do think it makes sense to charge at least something for it. I certainly don't agree with the $50 price point, but I can see his point of view - if everyone has access to the same, powerful economic tools, nobody can really make any profit.
I don't have much use for the DPS calculator stuff for this particular project, but I like the dropdowns, etc.
I made the mistake of not using systems like that when I was working on mine, so it's going to be a major chore converting it over to names/variables/objects, which I need to do before I start adding new features.
Right now I'm mainly concerned with adding features, and that's a lot easier when everything is on the same sheet. I plan on reorganizing and consolidating some of the tables once I get everything set up properly.
I'm somewhat familiar with C++, C# and VB (in that order) but I need to get the spreadsheet finished before I think about porting it.
I found http://starcrafttool...lo-gem-calc.php a long while back when I was working with gems; it's simple and I found it pretty useful (in case any1 cares/wants)
it's not mine, I have no idea who made it
That's the first web-based calculator I've seen that actually incorporates the majority of the same features I have in my spreadsheet (it also has a much cleaner UI)
I don't know the first thing about java, unfortunately. But I'll be reaching out here and there, trying to find a programmer who might be willing to lend us a hand.
My spreadsheet fulfills its original design pretty well (comparing proft, and determining the cheapest way to craft any given gem color/type)
Unfortunately, I didn't make it modular at all, and there are all sorts of 'cascading' references that will break if I try to do anything with it. It's far too cumbersome to add any additional features to without a complete overhaul.
I set up a group SkyDrive and uploaded the various Excel spreadsheets to it, so we should be able to collaboratively live-edit them.
I'll probably also set up a SharePoint / Team Foundation Server once we nail down the design for the app. (I'm more familiar with TFS than Git/SVN, plus it would give me an excuse to familiarize myself with SharePoint Server 2013 and TFS 2012)
Before we start making drastic changes to spreadsheets and/or pumping out code, we need to draft some design notes and decide what capabilities we want this tool to have, what platforms we want to target, etc.