Quote:
Hello all. So I am starting another spreadsheet project. I want to create a sheet that calculates cost and mass for a 'Mech's or vehicle's various components for a parts inventory. The idea is that each 'Mech and vehicle design would have its own inventory sheet for parts exclusive to that design. I want to make a generic inventory sheet, all the user would have to do is put in a few stats, mass, MP, etc. and the sheet would calculate the cost and mass for an individual component. The user would then input a number indicating how many of those components are in the inventory so a campaign player knows how much cargo space he needs to haul his stuff around and how much his inventory is worth.
A lot of parts are generic and used across a range of designs but this spreadsheet is for components specific to a 'Mech design, say the actuator set for the right arm of a Thunderbolt, or at least those that I think should be considered specific to a design. Other people may have different opinions on the subject.
Most components that would need repaired or replaced on a 'Mech or Vehicle has specific masses associated with them, but a few do not: specifically actuators. So how much of a 'Mechs internal structure do you think should be set aside for the actuators? How much of a cockpit's mass is for the sensors? Etc. I'm just looking for peoples' opinions, and any sources of information on the subject I might have missed.
Concerning actuators and internal structure I was thinking I'd just set aside half the internal structure's mass for actuators and divide that half by the number of actuators in the design to get a rough number for an actuator's mass. The other half would be divided by the total number of the design's internal structure circles to get the mass for each of them. That mass would include the appropriate set of myomer bundles etc. for a limb. Thoughts?
For a cockpit I was think a half ton for life support, a half ton for the cockpit itself: controls, ejection seat, monitors, etc. and the remaining amount, depending on whether its a standard or compact cockpit, for sensors. Thoughts?
First let me say I love this idea
I think the mass for actuators is pretty close, I would go with between a quarter to a third of the mechs internal structure weight for the cockpit mass.
I see something like this 30-50% for actuators depending on if it has arms or not, 25-30% for the cockpit, the rest would be the rest of the supporting structure of the mechs frame.
The thing that can not be forgotten is all the wiring and hoses that are also bundled withing the framing
_________________
Everyone here is crazy except you and me, and I am NOT TO SURE about you.
People like you are the reason People like me need medication.
[img]
http://www.heavymetalpro.com/countries/flag-us.gif[/img][img]
http://www.heavymetalpro.com/countries/mil-marines.gif[/img]