CincyBattletech

Please login or register.

Login with username, password and session length
Advanced search  

News:

Reactor: Online.  Sensors: Online.  Weapons: Online.  All systems nominal.

Pages: 1 2 3 [4]

Author Topic: Excel spreadsheet for maintenance, repair, and refit  (Read 9400 times)

deadlyfire2345

  • Colonel
  • *******
  • Posts: 4423
    • View Profile
Re: Excel spreadsheet for maintenance, repair, and refit
« Reply #45 on: July 25, 2018, 01:50:06 PM »
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.
Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: Excel spreadsheet for maintenance, repair, and refit
« Reply #46 on: July 25, 2018, 08:43:23 PM »
Quote from: deadlyfire2345 on July 25, 2018, 01:50:06 PM
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
Logged

Hat

  • Carpe Petasus
  • Administrator
  • Colonel
  • *****
  • Posts: 4633
    • View Profile
Re: Excel spreadsheet for maintenance, repair, and refit
« Reply #47 on: May 18, 2019, 09:11:18 PM »
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
« Last Edit: May 21, 2019, 11:38:34 AM by Hat »
Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: Excel spreadsheet for maintenance, repair, and refit
« Reply #48 on: June 07, 2019, 09:24:16 AM »
Looks like we'll get to make a completely new spreadsheet soon.
Logged

Ad Hoc

  • Lieutenant
  • *****
  • Posts: 1730
    • View Profile
Re: Excel spreadsheet for maintenance, repair, and refit
« Reply #49 on: August 22, 2019, 08:07:53 PM »
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.
Logged

deadlyfire2345

  • Colonel
  • *******
  • Posts: 4423
    • View Profile
Re: Excel spreadsheet for maintenance, repair, and refit
« Reply #50 on: August 22, 2019, 08:48:57 PM »
Quote from: Ad Hoc on August 22, 2019, 08:07:53 PM
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.
Logged

Ad Hoc

  • Lieutenant
  • *****
  • Posts: 1730
    • View Profile
Re: Excel spreadsheet for maintenance, repair, and refit
« Reply #51 on: August 23, 2019, 02:30:02 PM »
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.
« Last Edit: August 23, 2019, 04:04:17 PM by Ad Hoc »
Logged
Pages: 1 2 3 [4]
« previous next »