| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Spiderman Blitz
Pator Tech School
Minmatar Republic
1
   |
Posted - 2012.02.11 08:28:00 -
[1] - Quote
A Bill of Materials (BOM) is a hierarchical list of materials involved in the production of something. Here's a simplified example of 5 BOMs:
Toast:
-Sliced Bread
-Butter
Sliced Bread:
-Bread
Bread:
-Water
-Flour
Flour:
-Wheat
Butter:
-Milk
-Salt
Typically the above list would have quantities on each of those items, so a sandwich would say 2 slices of bread but one slice of tomato or something. So you can see how you can make a hierarchy out of the above examples, going from Wheat, Milk and Salt to Toast and looking at each element on the way.
This has lots of potential applications in eve and life, but I can't find the software that can make a hierarchical system like this for free. Something where you can say: "I want 4 slices of toast" and it'll tell you how much water you need to make the toast, or you can say something like: "I have 40kg of salt, infinite water, 5kg of flour, and 24L of milk, how much toast can I make? Anyone know of any good free BOM software out there? It doesn't have to be extremely complicated. I don't know if a typical BOM system would have some way of accounting for the cost of processes involved in the production of something (electricity to heat oven for bread, or amortization of oven or whatever). That would be nice but not 100% required. |
Jes Visuit
Private Investment Holdings Inc
2
|
Posted - 2012.02.11 08:40:00 -
[2] - Quote
how about excel?
Column A -> Toast, Column B -> Row 1: Sliced Bread; Row 2: Butter, Column C etc
With base quantities and the correct formula set up you can leave a cell for number of toast you want and have excel work out the rest for you. |
Spiderman Blitz
Pator Tech School
Minmatar Republic
1
|
Posted - 2012.02.11 09:38:00 -
[3] - Quote
I find that excel is really hard to set up stuff like this. I end up doing things like having an extra column to multiply stuff in, etc. :(
Also what if you have something like salt, which is included in both bread and butter. I think excel suffers when looking at those relationships etc. I'm pretty sure you need a relational DB to set these things up. I know that you can theoretically hard code a relational db (which is what you were trying to do above, right?) but it's so much hassle vs just using something higher-level. |
Emma Royd
Maddled Gommerils
80
|
Posted - 2012.02.11 09:52:00 -
[4] - Quote
Do you want to make 1 specific thing, or do you want to input all your minerals and let the software work out that you could build 23 slices of toast, 2 packs of butter, and 1 pot marmalade
If you just want to make 1 specific thing, then it's fairly easy in excel.
Divide each mineral in stock by the amount the item takes to build
Choose the min value and rounddown
something like
B2 to H2 would be =sum(MINERAL in stock / MINERAL to build)
Items to build=ROUNDDOWN(MIN(B2:H2),0)
Something like that will display the number of Specific items you can build |
Jes Visuit
Private Investment Holdings Inc
2
|
Posted - 2012.02.11 10:01:00 -
[5] - Quote
you don't really need a relational database.
all you are doing is mapping out the flow of materials.
you will need extra columns to hold values and calculations in, if they present too much visual clutter you can always hide them once set up.
In the scenario where you are trying to build a shopping list for an end product, e.g. I want to make 10 toast, how much salt will I need, it is actually quite straightforward in excel.
The reverse scenario where you say I have 100 salt, what can I make, will require a bit more though, but should also be quite doable. |
Velicitia
Open Designs
533
|
Posted - 2012.02.11 14:03:00 -
[6] - Quote
it definitely is do-able in Excel. Dedaf does it in the production tabs of his spreadsheet ... though I have no idea what black magic he used to put it together ...
However, I don't believe you can put in (for example) 500m of all the minerals and get that you can build 10 each of Rokh, Abaddon, Hyperion, and Maelstrom. It instead shows the maximum number of each line item individually (so it's up to the user to know "OK, the sheet says I can build 40 of any one of them ... " instead of "OK, I can build 40 of ALL of them! \o/") |
Spiderman Blitz
Pator Tech School
Minmatar Republic
1
|
Posted - 2012.02.11 17:22:00 -
[7] - Quote
I was hoping to make a chart that went from moon goo to t2 stuff to try to maybe build a model of the economy in terms of what happens to prices when adjustments are made in different areas, or to anticipate the demand for something, or whatever. Obviously there are lots of uses for it, but moon goo was my focus. Even just trying to reduce all the high end stuff to their equivalent low end stuff is a huge pita in excel.
I wanted to pull levers at the very top and watch the numbers shift on the bottom. |
Professor Alphane
Alphane Research Co-operative
234
|
Posted - 2012.02.11 17:34:00 -
[8] - Quote
A quick google tells me there are plenty of free excel templates available for BOM work perhaps one of them would suit your purpose
YOU MUST THINK FIRST.... |
Cyniac
Twilight Star Rangers
Black Thorne Alliance
129
|
Posted - 2012.02.12 18:55:00 -
[9] - Quote
EVE MEEP can and does have a BOM system, which allows you to decide to what level you want to get to, i.e. the components, or the minerals needed for the components or whatever.
I would like it if it had more granularity (right now if you have multiple components, you cannot decide the status of each individual component, either you stop at the component level for everything, or you go down to the mineral level for everything).
Would be great if there was a real BOM system for EVE out there - if someone finds it I'd be really interested. |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |