CincyBattletech
Campaigns (all) => "Have `Mech, Will Travel." => Lance Maintenance Rolls => Topic started by: Timberwolfd on March 11, 2017, 10:49:43 AM
-
Attached is a spreadsheet for calculating maintenance, repair, and refit numbers.
Green cells indicate human input required. Most inputs are arranged with drop down menus. Most repairs/refits do not require quantity numbers. The exceptions are armor and heatsink refits and armor repairs.
Known issues/missing information:
1. Internal structure refit time is wrong (each mech will be unique, so no single value works). An internal refit requires stripping everything, replacing each location, and then reinstalling every piece of equipment. (Just buy the dang upgraded mech.....)
2. Changing cockpit types requires installing 2x life support and 2x sensors as well.
3. Upgrading unit quality time is not defined, so 900 minutes has been used arbitrarily. Edit: refurbishment is a flat two weeks. I'll update this in the next version
4. Changing myomer type has been set to 1800 minutes base time based on replacing all of the actuators (including the hip and shoulder actuators/replacing limbs...)
5. Some constraints are not enforced, including refit facility type (ie the code will calculate numbers for a refit requiring a factory when you tell it you are in a dropship bay.)
Edit:
6. Shoulder and hip actuator replacement also involve internal structure replacement for the limb. That means other actuators, weapons, equipment, and armor need to be installed
Edit 2:
7. The current version does not address the modifiers for true custom mechs. True customs (as opposed to kits to change between models) incur a +2 TN modifier and take twice as much time.
New version inbound soon TM..
If you find any errors, let me know.
Rob, if you have input on what you want any particular numbers to be for the campaign, let me know.
-
I cant access the doc
-
I cant access the doc
Could you give me some more information?
It is an Excel spreadsheet (2013 .xlsx) that should open in Excel 2007 or later.
Do you have security settings set high for internet files?
-
not sure where to start
its a win 7 I don't have very much on here for office stuff
-
Do you have Microsoft Office? If so, which version? Without Excel, one of the Microsoft Office programs, you won't be able to open it.
When I get back to my computer tonight, I'll see if opening it in Google docs works correctly. I don't expect it to though, because I am using some of the more unusual features to automatically select modifiers and such.
-
Do you have Microsoft Office? If so, which version? Without Excel, one of the Microsoft Office programs, you won't be able to open it.
When I get back to my computer tonight, I'll see if opening it in Google docs works correctly. I don't expect it to though, because I am using some of the more unusual features to automatically select modifiers and such.
don't think I have any of it which would make sense
-
Do you have Microsoft Office? If so, which version? Without Excel, one of the Microsoft Office programs, you won't be able to open it.
When I get back to my computer tonight, I'll see if opening it in Google docs works correctly. I don't expect it to though, because I am using some of the more unusual features to automatically select modifiers and such.
don't think I have any of it which would make sense
It seems to work in Libreoffice which is an open source office package. If you don't have Microsoft office.
-
Do all of the formulas and drop down work?
-
Do all of the formulas and drop down work?
The Libreoffice is appears to be doing everything the spreadsheet has. I haven't tried entering my units yet. Just got the program loaded on my tablet last night.
Thanks for the spreadsheet, it will make things a lot easier for me to keep up on my units since I have never done this kind of a campaign. (^_^)b
-
Yeah, last time I ran an AccountTech campaign all of the details and modifiers drove me batty. So I made the original version of this spreadsheet. This time I added the refits, but there are a lot more caveats and exceptions in refits, so I could only code so much of it.
Edit: Rob's campaign guide for this campaign has removed the need for maintenance rolls. All maintenance rolls are autopass.
-
Is there an easy way to "reset" all the previously entered data to have a blank worksheet?
-
Not really. Eventually I'll get bored enough to make it a proper form, but that hasn't happened yet.
I normally just save as a new document to avoid the problem. You could also download it again. :-\
-
Note, Rob has chosen to go to BMR for repair and refit. I will create a new calculator after my copy of BMR arrives (got rid of it when I moved last... Doh!).
-
Note, Rob has chosen to go to BMR for repair and refit. I will create a new calculator after my copy of BMR arrives (got rid of it when I moved last... Doh!).
i now have excel viewer and excel online
not sure if i can save a doc on there or here and swap them though. Will play around with it and see
I was able to save file and upload to excel online and now have access
-
Revised version of the repair and refit sheet for everyone to use in their customization activities.
-
Revised revised version. I found an error on the customization sheet and fixed it.
-
Version 5 with the last vestiges of StratOps repair features removed.
-
Version 3 repair mod for replacing armor was -2. Version 5 mod is -1. Is this correct? Also I can't get tech mod and quirk columns to work in version 5 so target numbers won't come up. Version 3 does work. Is it me? or is something wrong?
-
Version 3 repair mod for replacing armor was -2. Version 5 mod is -1. Is this correct? Also I can't get tech mod and quirk columns to work in version 5 so target numbers won't come up. Version 3 does work. Is it me? or is something wrong?
bmr rules state -1 for armor since thats what were using they decided to fix it on the sheet i actually asked the same thing lol
the other parts not sure
-
Version 3 repair mod for replacing armor was -2. Version 5 mod is -1. Is this correct? Also I can't get tech mod and quirk columns to work in version 5 so target numbers won't come up. Version 3 does work. Is it me? or is something wrong?
I'll look into it when I get back home. I assume this is on the repair page?
-
Version 3 repair mod for replacing armor was -2. Version 5 mod is -1. Is this correct? Also I can't get tech mod and quirk columns to work in version 5 so target numbers won't come up. Version 3 does work. Is it me? or is something wrong?
I'll look into it when I get back home. I assume this is on the repair page?
yes, repair page I also have question on refit target numbers. for straight hs swap --vet tech, double time, shows tn 4 in tn column and 6 just to right of tn column. you had target #'s of 7. I don't understand.
-
Version 6 with the last of the StratOps repair rules excised (I know I thought this last time...). Now repairs and customizations are all using BMR modifiers with no StratOps tech or quality mods. The Tech Mod column is for IS teams working on clan or mixed tech mechs, not StratOps tech mod.
-
Version 3 repair mod for replacing armor was -2. Version 5 mod is -1. Is this correct? Also I can't get tech mod and quirk columns to work in version 5 so target numbers won't come up. Version 3 does work. Is it me? or is something wrong?
I'll look into it when I get back home. I assume this is on the repair page?
yes, repair page I also have question on refit target numbers. for straight hs swap --vet tech, double time, shows tn 4 in tn column and 6 just to right of tn column. you had target #'s of 7. I don't understand.
Depending on which mech refit you were looking at, adding CASE results in a TN of 5 at the factory +2 for custom to 7 total. Since I was clumping my refits, the TNs were sometimes larger.
-
Version 7 changes
Included hull breach repairs (Note that Hull Breach repairs cannot make use of extra time or rush time)
Repair of damaged multi-crit weapons and equipment (Must have 1 crit surviving)
-
2. Changing cockpit types requires installing 2x life support and 2x sensors as well.
In Tech Manual pg 275, the example for cost calculation for the Mongoose mech, for life support and sensors it only uses the cost for 1 each. This leads me to believe that there is only of each but each takes 2 crit locations.
-
That would explain some of the most egregious cost differences and why they have a repair life support option for more than one critical. On the other hand, they are distinct and non contiguous critical which would argue for 2 separate items.
If Rob wants to rule on this (either way) for clarity, it would probably limit misunderstandings.
-
They are in fact a single item, with split critical slots. You need only purchase and mount a single Sensor or Life Support unit when repairing a destroyed Head Location. Note, however, that Head Slots are fixed; you cannot open up Slot 1 on a Head Location by moving the Life Support in that slot around. Not even with a customization, unless you're doing weird-ass Torso Cockpit shennannnigans, in which case I'll ask how are you in the 3060s already?
Precendent: Fusion Engines, SFE, XL, and otherwise. Single item. Split slots.
-
Latest correction (v8)
Revised time bonuses to include triple time and readjust TN modifiers for double, triple, quadruple progression.
-
Version 7 changes
Included hull breach repairs (Note that Hull Breach repairs cannot make use of extra time or rush time)
Repair of damaged multi-crit weapons and equipment (Must have 1 crit surviving)
I thought it couldn't have more than 50% of an equipments crit slots destroyed to repair it
-
I went digging through the books (both StratOps and BMR are the same). The relevant section is diagnosis (which I don't think anyone has actually done). See page 176/177 in StratOps.
The relevant bit is
Any weapons or equipment are rendered inoperative by a critical hit or destruction of the location in which they are situated and may be beyond repair. Players can attempt to repair weapons and equipment that have received a critical hit or are in a destroyed location (if a weapon received a critical hit and is also in a destroyed location, only a single roll is made). For each destroyed item, roll 2D6. On a result of 10 or more, the item can be repaired; otherwise, it must be replaced.
I can't find any rule stating that 50% of the crits must be okay, in fact it looks like a fully crit hit weapon could theoretically be resurrected by RAW.
-
I am trying to figure out how the excel sheet you made calculates TN and times.
How is weight class factored in for both these values?
I just want to figure out how this all factors in so I wont make the mistake of just going into the rules blindly.
-
I am trying to figure out how the excel sheet you made calculates TN and times.
How is weight class factored in for both these values?
I just want to figure out how this all factors in so I wont make the mistake of just going into the rules blindly.
Weight class has no bearing on repair times or TNs.
I will be making a new version soon(TM) to incorporate Rob's +1 modifier for customized mechs.
The TNs for repairs are based on the tables from BMR (They are the same as StratOps except for an offset of 1 brought about by StratOps using quality and tech level modifiers.). You can find them in the LookupTables tab. Everything in Blue is used to calculate TNs. Any given repair has a TN modifier and time from the table. The modifiers for location, time spent, etc. are there as well.
It should go without saying that fiddling with the tables will change or break the spreadsheet.
-
I went digging through the books (both StratOps and BMR are the same). The relevant section is diagnosis (which I don't think anyone has actually done). See page 176/177 in StratOps.
The relevant bit is
Any weapons or equipment are rendered inoperative by a critical hit or destruction of the location in which they are situated and may be beyond repair. Players can attempt to repair weapons and equipment that have received a critical hit or are in a destroyed location (if a weapon received a critical hit and is also in a destroyed location, only a single roll is made). For each destroyed item, roll 2D6. On a result of 10 or more, the item can be repaired; otherwise, it must be replaced.
I can't find any rule stating that 50% of the crits must be okay, in fact it looks like a fully crit hit weapon could theoretically be resurrected by RAW.
Me and rob had a discussion at one point regarding critical remaining may want to have rob chime in again because I've lost a few parts or bought parts based on that
-
The general idea was that tracking damaged weapons/equipment in the warehouse and their repair checks added a whole extra level of complexity to the process. The 50% rule means that you don't have to keep track of damaged 1 or 2-crit components, which significantly eases the process.
-
The general idea was that tracking damaged weapons/equipment in the warehouse and their repair checks added a whole extra level of complexity to the process. The 50% rule means that you don't have to keep track of damaged 1 or 2-crit components, which significantly eases the process.
Yeah, the roll multiplication can get annoying quick. I don't get why they didn't do a single roll for the mech and have it be a MoS thing. For each MoS a crit is repairable would have been easier.
I have no way to implement that in the Excel sheet itself, so that will be a human tracking thing.
-
Will the next one of these include rush time values?
-
I'll take a look at it. The problem is making sure the user actually uses the lower tech rank. Since an elite tech works like a veteran to get the job done in 1/2 the time, a regular to get it done in 1/4 the time, etc., there are challenges implementing it easily in cells.
-
so if an ammo bin has taken a crit, is there anything that needs to be bought to replace it (assuming ammo depleted/ not enough to kill mech outright)?
-
so if an ammo bin has taken a crit, is there anything that needs to be bought to replace it (assuming ammo depleted/ not enough to kill mech outright)?
the crit slot should be repaired and ammo bought as far as i know
-
under maintenance outcome, for the table lookup that includes quality. There is a value that transferred over as #REF. What is that value exactly?
=IF(C54=LookupTables!$B$8,VLOOKUP(IF(Z54<-7, -7,IF(Z54>6,6,Z54)),Maintenance,VLOOKUP(#REF!,Quality,3,FALSE),FALSE),"")
-
under maintenance outcome, for the table lookup that includes quality. There is a value that transferred over as #REF. What is that value exactly?
=IF(C54=LookupTables!$B$8,VLOOKUP(IF(Z54<-7, -7,IF(Z54>6,6,Z54)),Maintenance,VLOOKUP(#REF!,Quality,3,FALSE),FALSE),"")
It was pointed at column O that used to have unit quality. Since we don't have quality in our campaign, it got deleted. You can look at earlier versions of the sheet to see how it would have worked. It implements StratOps' failure of maintenance reducing quality of units.
-
That makes more sense now. Was kinda weird getting that when it didnt exist.
-
Update to Version 9.
With the rules v2-2 version Rob added a +1 maintenance modifier for custom mechs. This version includes that modifier.
-
With the added of the custom column in roster also affected the lookup regarding clan/IS tech, thereby adding a 2 mod to the entire thing. Was this by design?
-
With the added of the custom column in roster also affected the lookup regarding clan/IS tech, thereby adding a 2 mod to the entire thing. Was this by design?
No. I'll look at it this evening.
-
I figured it out. The tech is still set up for column 8 (which is now considered custom). Change it to 9 and its good to go.
-
I figured it out. The tech is still set up for column 8 (which is now considered custom). Change it to 9 and its good to go.
Fixed
-
All,
UPDATE: I fixed an issue where it was adding a day to the completion date unless you hit the time available exactly. That's been fixed.
Attached is the maintenance spreadsheet. I made changes to Jon's that broke the refit sheet, so ignore that. You will need to replace my information with yours. If you have issues, let me know.
With a sweep of his...
Hat
-
Looks like we'll get to make a completely new spreadsheet soon.
-
Steve pointed out that on the Custom calculator portion I didn't have the extra/rush time modifiers factoring in. I fixed this issue. Attached is the newest version. If anyone finds any other errors please let me know.
-
Steve pointed out that on the Custom calculator portion I didn't have the extra/rush time modifiers factoring in. I fixed this issue. Attached is the newest version. If anyone finds any other errors please let me know.
TN modifier to customs is removed from errata, also removed from custom.
The x2 time only applies to failed rolls as well, which is what I was asking Rob about when customs were being done.
-
Fixed TN for Extra/Rush times.
Removed Custom x2 time and TN modifier.
For Steve ;D, added more locations for techs in the roster.
New Version attached.
Again, please let me know of any errors.