Droid Engineer Archive
Thread: Been bored, so I did a new DE Pricing spreadsheet
TheRealTK421
Fri Jan 07, 2005 1:35 am
#14
I meant 25 total (5 crates of 5 'use').
Gron_DM wrote:
same 10k for seekers/probes. btw how do you make a crate of 25? mine always come out with 5 per
/bow
Respectfully,
TheRealTK421
Fri Jan 07, 2005 1:42 am
#15
Nah...you may just be 'dropping your pants' for no reason (on the price). It's entirely possible that you could sell just as many at 40k, 45k, 50k and beyond...if you pick your price point and stay with it.
CTRL_ALT wrote:
I guess I'm just too crazy to be a DE...selling for 30k.
In addition, moving your pricing up little by little over time is also a good thing. I used to sell a fully 'loaded' Probot (1 yr + ago) for like 40-45k.
I didn't just start at 80k. I did pricing 'elasticity' testing to find that good middle ground between low-balling on the price and never making a sale (based on price alone).
Most of my sales have never been based solely on price though (another good tip to the up and coming MDEs out there)...
/bow
Respectfully,
Earymi
Fri Jan 07, 2005 8:51 am
#16
I guess I'm the only one with this problem, but I can't open this workbook. What program opens it? I tried Excel, and no go. 
1StarNinja
Fri Jan 07, 2005 10:13 am
#17
.ace is a compressed file. It's another form of "zip" file. Winzip won't uncompress it but WinRAR does, you can find an eval copy on download.com
Once you uncompress it from .ace you will have the Excel file
CTRL_ALT
Fri Jan 07, 2005 9:03 pm
#18
TheRealTK421 wrote:
Nah...you may just be 'dropping your pants' for no reason (on the price). It's entirely possible that you could sell just as many at 40k, 45k, 50k and beyond...if you pick your price point and stay with it.
CTRL_ALT wrote:
I guess I'm just too crazy to be a DE...selling for 30k.
In addition, moving your pricing up little by little over time is also a good thing. I used to sell a fully 'loaded' Probot (1 yr + ago) for like 40-45k.
I didn't just start at 80k. I did pricing 'elasticity' testing to find that good middle ground between low-balling on the price and never making a sale (based on price alone).
Most of my sales have never been based solely on price though (another good tip to the up and coming MDEs out there)...
/bow
Respectfully,
I make a decent profit...highest price on droids is 30k (If I ever make high quality R3 boomers, they would be 50k or so). As long as i'm making good profit, no reason to raise price.
LonelyGhost
Fri Jan 07, 2005 11:22 pm
#19
I'm wondering if maybe those higher-priced servers might, over the next 6 months or so, see a reduction in prices. HOnestly, I dont think I'll ever lower the cost of a combat probot to less than 24k or so. Its just not worth my time (personally). It will be interesting to see how the long-term effect of the solo-group nerf, combined with the new combat we'll have after the CURB will affect the whole economy.
Bah! Enjoy it as long as you can! I will probably never see much business. I just dont care to set up a busy store. I am happy tinkering here and there, making ends meet. But I will be looking at procing. I have already used my newest Architect spreadsheet to guide me in raising almost everythign in the structres list. Its a little shocking to see how much Architects are cutting themselves short.
Bah! Enjoy it as long as you can! I will probably never see much business. I just dont care to set up a busy store. I am happy tinkering here and there, making ends meet. But I will be looking at procing. I have already used my newest Architect spreadsheet to guide me in raising almost everythign in the structres list. Its a little shocking to see how much Architects are cutting themselves short.
Straker_Atrella
Sat Jan 08, 2005 1:35 pm
#20
The problem is this, no matter if you are on a "expensive"or "cheap" server the money that people make from missions is the same. The missions on my server don't pay more then yours. Meaning that before the group Nerf you could make 1 million in 3 hours from missions, after the group nerf, you could make 750k in 3 hours. People have tested it.
So if the amount of money people are making on "expensive" or "cheap" servers is the same, then the only difference is how much the combatents spend on expenses and how much they keep. The only real difference between an expensive server and a cheap is is that from the beginging, pretty much as a whole the crafters took a bigger cut of that money. On an expensive server, maybe 25% of what a combatent makes may go to expenses, where on a cheap server, maybe 5% does.
Unfortunatly it's probably way to late to make changes now, the people who spend the money are accustomed to paying less, unless everybody banded together, you would have a hard time getting people to pay more.
Earymi
Sat Jan 08, 2005 4:10 pm
#22
Not commenting about base prices, but in my opinion, when you look at CPU for resources, you should look at the sales value (that is, what you could sell the raw resources for) rather than the cpu to mine them. That's the opportunity cost involved in using those resources to make something, and is (again, just in my opinion) a more reasonable number to base your production costs on.
Frankly, if I can't sell a finished product for substantially above what I can sell the raw resources for, it's not worth my time & energy to make said item.
And that's the reason I dropped architect, fwiw, and the reason I won't sell swoops and other master artisan items. People won't pay the price for a swoop that's greater than (or even equal to) the price I could get for the resources themselves, so why go to the trouble of turning those resources into something else?
Doc16743
Mon Jan 10, 2005 9:42 am
#23
The spreadsheet is fantastic, but I have one small question.
Where is the cpu for resources? I'd like to be able to plug in my own values for a better cost picture.
Thanks!
LonelyGhost
Mon Jan 10, 2005 3:48 pm
#24
Set the base CPU on the "Worksheet" page, the cell in Yellow, in I2. Then, go to the "Lookup - Markup" page and set the Markup to a desirable level for the resources you want.
A 100% Markup is double the Base CPU. A 50% Markup is half again the Base CPU. If your Base CPU is 10, then a 50% Markup makes that specific resource worth (10+(10*.5)), or 15cpu. 100% Markup is 20cpu. Etc...
That help?
EDIT**
Yeah, it would be too hard to switch. I have the every single schematic keyed to multiply the Base CPU by the multiplier and add it back into the Base. My best suggestion would be to add this to the sheet, maybe under the Lookup page. I'll add it in the next patchup I do.
Need 4 rows, 2 columns
A1 - blank
B1 - My Desired Resource CPU
A2 - =cpu
B2 - Base Workbook CPU
A3 - =A1 - A2
B3 - Difference
A4 - =A3 / A2
B4 - Required Markup on the Resource
Make sure you enter the = sign in A3 through A4, and exactly "=cpu" without quotations in A1.
Hope it helps!
A 100% Markup is double the Base CPU. A 50% Markup is half again the Base CPU. If your Base CPU is 10, then a 50% Markup makes that specific resource worth (10+(10*.5)), or 15cpu. 100% Markup is 20cpu. Etc...
That help?
EDIT**
Yeah, it would be too hard to switch. I have the every single schematic keyed to multiply the Base CPU by the multiplier and add it back into the Base. My best suggestion would be to add this to the sheet, maybe under the Lookup page. I'll add it in the next patchup I do.
Need 4 rows, 2 columns
A1 - blank
B1 - My Desired Resource CPU
A2 - =cpu
B2 - Base Workbook CPU
A3 - =A1 - A2
B3 - Difference
A4 - =A3 / A2
B4 - Required Markup on the Resource
Make sure you enter the = sign in A3 through A4, and exactly "=cpu" without quotations in A1.
Hope it helps!
Message Edited by LonelyGhost on 01-10-2005 06:28 PM
Message Edited by LonelyGhost on 01-10-2005 06:29 PM
Message Edited by LonelyGhost on 01-10-2005 06:30 PM
Doc16743
Mon Jan 10, 2005 6:00 pm
#25
Thanks for the quick response! It was hiding in plain sight!
Hope you'll post here when a new version is available! While the markup is important, I believe it's every bit important to a DE that harvests all his own resources, or buys them all, as it allows him to see exactly what the cost of a system or completed droid is. It's especially critical when a resource such as Tolium must be purchased, and the rest of the resources are harvested at a lower cost.
Please feel free to ask for beta testing on a version if you like!
Thanks again!
LonelyGhost
Sun Feb 06, 2005 8:43 pm
#26
Okay, had some more free time, so I redid the whole thing, hehe. I got some new tricks to play with. This one has a pretty basic Factory Calculator too. I'll be adding littele pieces as time goes on.
Link is in my Sig! Enjoy!
Link is in my Sig! Enjoy!