Chef Archive
Thread: Mokia Price Guide
Page 1 of 1
Onodrim666
Sun Mar 28, 2004 11:49 pm
#1
Hi, ive just made Master Chef, ive been using Mokia O'tannia price guide (excellent invaluable!), could someone confirm details in the column that list the Bio Foods. the price lists a crate of 25 bio using casks, but is the single bio in a cask (21 use etc) or a large glass (9-10 use etc). ive been using cask for all my bio, and large glasses for my cheaper stuff.
I must admit i love been a chef, slightly more than PvP, its such a welcome change nad as addictive.
I must admit i love been a chef, slightly more than PvP, its such a welcome change nad as addictive.
sciguyCO
Mon Mar 29, 2004 9:34 pm
#2
The updated spreadsheet is online now.
HTML version: http://home.comcast.net/~sciguyco/swg/foodPricing.htm
Excel version: http://home.comcast.net/~sciguyco/swg/foodPricing.xls
Groid
Tue Mar 30, 2004 1:15 am
#3
new update is being mailed to Sicguyco tonight. its all improved, alphabetical, includes prices for nutrient bio parts, and replicate bio parts.
new format.. $single glass $crate glass$ bio glass $ crate bio glass
cask -> $ nutrient $ crate nutrient
repl-> $replicate$ dont sell this way
I use casks for virtually all bio-engineered drinks
spreadsheet has been adjusted to the Bria server based on sales since patch went live
spreadsheet keeps the 'change one number' adjust all prices feature
Added a 'price you pay' for bio parts, just change to YOUR cost (from bio engineer) all other calcs done automaticallly
It has been a lot of work compiling this data, but well worth it for any chef to use. No longer need to ask.. what should I sell this for, as the question now is 'what do I pay for the materials'
Mokianna O'tannia...creater of the spreadsheet.. bria server
Gaenjin
Tue Mar 30, 2004 1:42 pm
#4
Thanks for the work, but I found that some of it is a littleconfusing. The use of $ throws me off, as well as the use of repl$. Also the placement of the >cask and rpl$ are confusing, but that may be because of the use of $ on the column labels. It took me a while to reason most of the chart out, still a bit confused when I look at it, a lot of scrolling up and down to check which column I am looking at.
Personally I use acustomized version of Bihlbo's Chart. (sorry forgot download URL, but the thread is on these Chef forums).
- I set all my resources at 10 cpu (ie. myCarbo unit cost is60 = 6 units*10cpu).
(It's my "static modifier".I can change thisas market requires, and it allows me to adjust to high priced rare resources that come in)
- Then Ihave it calculate using a formula thatusesthe"Cost per Item" and the"Average Quality" as a multiplier(SUBTOTAL)={ (Cost * AQ) + Cost }
(I used=(K23*L39)+K23 and =(O23*L39)+O23 as the formulas, then I just placed the cells below their respectiveCost per Factory Item and Cost per Item cells)
- It then figures outmy selling prices for factory-made units and hand-made unit.
That gives me a fair pricing that's based on how good of resources I use and experimentation efforts. It's about average pricing on my server. (Sunrunner)
My alterations arenot presentable, I'm an Excel noob, and there's a lot of work that I want to add and haven't bothered yet. Like,my BE additives totals are precalculated (I make my own)and stored in a Notepad file, and I manually calculate crate prices because I split my crates up into various amounts to experiment with what amount sells better. Bihlbo did wonderful work on that Chart, I have to thank him a lot for making it and sharing it with us.
Urrano
Fri Apr 02, 2004 4:38 am
#5
Excellent spreadsheet, Great, ive just changed the price of medium bio as tempest server is 50k a crate, which makes it 2000credits extra per use in bio food and it did all the calculating automatically, plus i changed the butter price as milks going for 20cpu, which takes care of the calc for the banta butter. What are the chances of having another box listing all the ingredients, so i can change those prices, eg if i have to buy cereal, and its more than 5cpu, it would make this spreadsheet the easiest and most universal one.
Whats more important, Potetial energy or Overall Quality? as i can farm flower fruit for 999, but the energy is only 300, is it worth it?
Whats more important, Potetial energy or Overall Quality? as i can farm flower fruit for 999, but the energy is only 300, is it worth it?
Page 1 of 1