Architect Archive

Thread: Architect Crafting Spreadsheet Helps Rationalize Prices

Ashii
Thu Jul 03, 2003 2:07 pm
#1

Here's a link to a spreadsheet thatI have been developing over the last few days. You'll need XL (or a program that understands XLS file). Hopefully it will help rationalize and normalize prices for our stuff. Or least help people understand the pricing.


Here's the site. Hope you find it helpful.


http://coretechswg.freewebpage.org/


-Jubey, Core Tech Architect




-Jubey, Core Tech Master Architect,
East Dune Sea Oasis, Tatooine (5011, 3290)
Betatoxin
Thu Jul 03, 2003 2:45 pm
#2

Thank you
hugefeet
Thu Jul 03, 2003 5:19 pm
#3

doesnt work anymore


sounds like a great idea though

how does 15k for a house and 30k for a factory figure for anyone who has the tool?
Jubey
Thu Jul 03, 2003 8:55 pm
#4

what doesn't work? the site or the link to the spreadsheet in the site.


-Jubey

Jubey
Thu Jul 03, 2003 8:57 pm
#5

As for the house and factory, the tool is a bit more complicated than that. you can configure different costs for different resources. The way the tool is currently configured, houses are at 10k and factories at 50k


btw, i just checked the links and it seems to be working fine.


-Jubey

Rath
Fri Jul 04, 2003 1:29 am
#6

Very cool tool, I don't do markups though like in the tool. I just increase the cost on a per resource basis.



Drase Rancor - Rodian
RETIRED Master Architect --- 8/1/03 - 9/15/03
Master Weaponsmith

DrasTek Weapons: Quality At Its Finest
Just 900 m North of Coronet in Kor Mesa! Corellia -240 -3205
Now on Talus, South of Dearic! 50 -4000
Jubey
Fri Jul 04, 2003 3:50 am
#7

The tool is flexible enough for you to use it the way you want to. Easy enough to set the markup to 0. For me, I wanted the cost to reflect the actual (or close to the actual) cost it takes me to obtain the resource.


Anyway, its easy to see that its possible, assuming you can get low grade ore efficiently, to still come out ahead selling a house for 10k.


Glad you found it useful,


Jubey

dmarkis
Fri Jul 04, 2003 6:22 am
#8

if you make the mark up 0 for the houses the cost goes up



"Stealing kills from AFK fighters since 2003"
PoisonedWell
Fri Jul 04, 2003 7:50 am
#9

I think your costs for housing is too low.


What about the Wall Modules that require 200 Ore and 50 Metal and you need 10 of them



So there is 2500 resources that is not in your calculation




Master Thread Hijacker
Lowca: Master Artisan / Master Architect / Master Merchant / Novice Chef
Ahazi: ......not telling...
Shadowfire: Scout/Marksman
Eclipse: Medic
Jubey
Fri Jul 04, 2003 11:10 am
#10

It is a spreadsheet. it is not a set price guide


You can adjust the costs for materials on page 2, and it adapts the prices on page 1. Those are just example prices. They will not necessarily work for you and you can adjust it so that it better suits your needs.


As for the 3 wall modules for medium houses, they are rolled up in the 13k+ low grade ore mentioned inthe tool for them, so yes, they are taken into account.


-Jubey

Rath
Fri Jul 04, 2003 4:58 pm
#11

Now you just need to add a figure that represents critical failures. I figure about 10% of materials are lost on most builds.



Drase Rancor - Rodian
RETIRED Master Architect --- 8/1/03 - 9/15/03
Master Weaponsmith

DrasTek Weapons: Quality At Its Finest
Just 900 m North of Coronet in Kor Mesa! Corellia -240 -3205
Now on Talus, South of Dearic! 50 -4000
Ashii
Fri Jul 04, 2003 6:30 pm
#12

Hard to quantitize that. The way I use it, I reflect that in either cost of the material of the profit %. Or maybe even the markup/discount if you wanted to use a flat rate. All the numbers are tweakable and will automatically update the rest of the sheet.


-Jubey




-Jubey, Core Tech Master Architect,
East Dune Sea Oasis, Tatooine (5011, 3290)
Ozill
Fri Jul 04, 2003 10:05 pm
#13

Great Work Jubey






Ahmik - Master Doctor - Master Swordsmen
Page 1 of 2
Previous Next