Planet Calypso: Calypso Crafting Knowledge Base - Crafted Components & Items Cost Database

Please follow the following link to know more about it.

It is a database being converted into spreadsheet form as I have the time to do so.
It is free for all to view and use. You can also download it in Excel Office 2010 format or Open Office if you prefer to use that and edit the values to your hearts content :)

Enjoy and Happy Crafting!
Viper

Link >

http://www.planetcalypsoforum.com/f...o-Component-crafting-costs-Knowledge-database

Direct to Spreadsheet > https://docs.google.com/spreadsheet/ccc?key=0AqQWbrxabhWrdHRoeDBfdDJFSVFIUzlSVzB5Q1plaEE

--------------------------------------------------------------------------------
Revision List:
6-Jan-2013: Component Level 1 Blueprints Completed for Volume 1 and 2
7-Jan-2013: Component Level 2 Blueprints Completed for Volume 1 and 2
8-Jan-2013: Half way through Level 3 BPs ... No Further Updates.
9-Jan-2013: Started work on an OpenOffice BASE Database eta a few months.

--------------------------------------------------------------------------------

 

Hiya Tass,

I will do the spreadsheet first, then lets look at putting it into wiki :)

I am requesting an RSS Feed from MA down the track (Have already made the request via Wishlist on PCF too) to update information needed daily, MU Auction History that would be. If they can't do that then I have a Java App in the works, however it takes a few hours for the Java App to navigate the market Auctioneer and OCR all the values.

It is incompleted and still a bit buggy - Freezes often, however I am still a newbie to Java so I will have to read more where my errors are to fix its freezing problem.

Aside from that I hope that MA can provide an RSS feed once the sheet is up - Since it can be exported in multiple formats, I am guessing updating wiki should not be too much hassle.

Still early days, let us see what eventuates.

Cheers,
Viper

Oh yea and happy new year too :)

 

Today I will try to get all the Level 2 Blueprints into the system :)

 

Thanks for the heads up Tass :)

Also today I completed all Level 2 Component blueprints.

 

Hey guys,

It is getting harder to manage the spreadsheet with each new sheet that is added,
So I am now going to look into using BASE from Open Office to develop a full fledge database system in my free time for this little side project :)

Fingers crossed that MA will provide an API or RSS feed for market data in the future.

I am doing this for fun, but I am concerned it will become punishing to continue in the future updating manually.

Cheers,
Viper

 

Hey guys,

Let me think on it for a while.
Thanks for the kind offer.

 

I think I will be stopping this sharing is caring altogether as I have already lost a few ingame contacts, 2 high end crafters also over doing this spreadsheet and now database lol.

Funny how it works, friends until you threaten their profits.

I guess they have a lot more invested than I at any one point in time, but oh well.

Still thinking on it, but will probably just let it die now.

 

Yep it just comes down to laziness, anyone can work it out with effort and time and an understanding of excel & maths. It is not that complicated. As far as the friends are concerned, they are upset that if I do this then everyone will know what is good and not to craft and it will lead to a market crash from undercutters all undercutting each other.

As far as I see it, and I do understand their points of view, that once costs are presented, they will not go under their cost to make an item knowing that they will be losing money and if they do, then they are unlikely to craft that item again for the foreseeable future.

There is enough items and marketspace to go around, imo they are just being greedy, typical when it involves money.

 

As posted on PCF : http://www.planetcalypsoforum.com/f...o-begin-with&p=3053236&viewfull=1#post3053236

Sleepless Night!

Hi,

Having restless/sleepless nights is the worst thing imho.

So I have came to the conclusion that I will do another spreadsheet for people.
I am also looking at help contribute to the various wiki's down the track also - Mainly EntropiaPlanets Wiki.

Never the less, here is how the spreadsheet will be structured.


Master List Sheets

Will be protected view only sheets, they will link all the information back from each tab back to them.
These will be the sheet to look at as an overview of referenced information at a glance.

YOU CAN SORT THESE SHEETS to your hearts content without upsetting any of the dynamically linked data.


Resource Sheets.



These will be individual tabs which will contain the wiki links, recommended list quantity which you can adjust yourself of which it will auto-calculate list price and all data relevant to that resource. It is also where you keep your User Notes. User notes are personal notes that you want to keep on Blueprints and quantity, locations and mobs.


Manufacturing Master return % Breakdown Sheet.

This sheet is where the details for breakdown return percentages are kept which you can tweak yourself and it will update "all individual tabs in the spreadsheet" and master list sheets auctomatically


Crafting Item - Subcomponent & Final Item sheets - Individual tabs.

Each blueprint in the system will have an individual sheet assigned to it, just like each resource.
These breakdown sheets is where all the nitty gritty calculations that most hate doing are done.
They will automatically update as percentages on resource costs are updated.


Later On - Master Input Sheet

This will be a reference of everything in the spreadsheet which can be used to input market markup % data into which will in turn update all tabs automatically. Initial this sheet will not be created as YOU CAN NOT SORT THE DATA what-so-ever without upsetting the dynamic links to each individual tab. I will get around to making this sheet down the track once some sort of RSS/MA Site lookup can be provided for daily updates. I would hate to have to do updates on a 1000 items+ each week, it would suck entirely.

Anyway heading on to 5am here, off for some rest.

Any feedback of a positive/idea nature is welcomed, those who have concerns also, those who think that I am doing all the work for the lazy ones (To an extent I am) can like it or lump it

Peace Out,
Viper

 

So yea, there is an EntropiaPlanets Wiki slot for each tab :)

And I will help out eventually one day - when I get around to it to update the wiki too!

Time Out for sleep, just past 5am here.

 

No longer doing the database version since I think it may bit a bit difficult for people to run queries and reports properly. Most people are uysed to spreadsheets, so I will stick with that :)