Register Register

Author Topic: Seeking Input for a digital record sheet for AToW  (Read 3069 times)

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #30 on: 23 July 2021, 23:27:28 »
Subskills really need to be free text.  I figured out a way to do the math with that in Excel.

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #31 on: 24 July 2021, 08:45:45 »
Subskills really need to be free text.  I figured out a way to do the math with that in Excel.

"Free Text"? Not sure what you mean. As for the skill math, haven't put that in yet. Right now it is all freely modifiable (both levels/points and XP). In a soon iteration it's going to change to be only the initial will be freely modifiable then all changes after will be +/- XP Changes to make going through the modules easier.

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #32 on: 24 July 2021, 09:43:04 »
I mean if you select "Protocol", you should be able to type in whatever it is to the right of that instead of having to whip up an exhaustive list of subskills to choose from.

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #33 on: 24 July 2021, 10:51:30 »
Some are, some aren't I noticed. The ones that are (Occupation, Career, Art, etc) will accept anything in a text box. The ones that say "Any Language" or "Any Affiliation" I limited to known ones in the book. Can add more as needed.

Edit: And as I think about it, it's not confirming and just accepting what is in the text box and attaching to the end so it'll crash right now for various dumb reasons due to the complexity and somewhat spaghetti code that is there already. But will be fixed.

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #34 on: 24 July 2021, 11:03:38 »
I got around the issue in my look up tables with just one extra line for skill like that.  Basically, just the name of the skill, then "Skill/zzz".  That way, Excel picks up any "Skill/you name it" as being between those two and grabs one of them.  They of course have the same Attribute(s), Target Number and Type.  Tiered skills were a little trickier, but I figured those out too.

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #35 on: 24 July 2021, 11:09:11 »
The main skill has the TN/Type and the sub skill just inherits it correct (at least for the variable ones)? If so then it's a non-issue code wise for me. Thankfully.

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #36 on: 24 July 2021, 11:24:20 »
Yep, you have it right.  When/if you want the code for calculating the XP costs, I've got all that figured out already.  There are 23 skills and 20 Traits that require the "/zzz" trick, and six Tiered skills to work around.

Aging was another significant coding thing, but that's all figured out too.

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #37 on: 24 July 2021, 13:30:29 »
I'll need to figure all that out eventually as well. Last time I looked at your excel, the equations didn't load up in Numbers so might need to get some time with you to take a look at them.

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #38 on: 24 July 2021, 13:43:37 »
Just shoot me a note when you're ready, and I'll make the time!  :thumbsup:

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #39 on: 24 July 2021, 18:59:08 »
Did more work today:

* Skill update and delete now work correctly
* XP is calculated on Trait/Skill creation based on traits at time of creation (Fast/Slow Learner accounted for)
* TN/Complexity adjusted for tiered skills.
* Modifiers from Attributes shown in () on skills if any.
* After initial creation, only XP can be adjusted. Levels will auto calculate on update of each Trait/Skill/Attribute

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #40 on: 24 July 2021, 19:13:14 »
since I wish to include info for Total Warfare, would it make more sense to switch skills from 2 columns to 1 and expand it all out?

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #41 on: 25 July 2021, 01:44:12 »
I think that would make sense, but I'm not sure how you would do it.

Also, I'm not sure you can have a zero Attribute (other than EDG).

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #42 on: 25 July 2021, 09:19:50 »
I think that would make sense, but I'm not sure how you would do it.

Since it's all SVGs it would be just a matter of changing the drawing logic. I'll work on that next time I'm in the code.

Also, I'm not sure you can have a zero Attribute (other than EDG).

waves hand Ignore most of the values on the display. They are there for testing purposes only. :)

Edit: And looking at the AToW book, they range from 1-8 with a few going up to 10 via traits. 0 is possible but usually with crippling effects.
« Last Edit: 25 July 2021, 09:23:47 by rjhancock »

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #43 on: 25 July 2021, 10:53:41 »
Ah, found the rules on pages 35-36.  You certainly wouldn't create a character with zero (other than EDG), but it could happen during game play.

Maelwys

  • Major
  • *
  • Posts: 4735
Re: Seeking Input for a digital record sheet for AToW
« Reply #44 on: 25 July 2021, 12:15:25 »
I guess that's a good prompt to ask if you'll allow for a place for temporary effects to attributes, such as drugs?

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #45 on: 25 July 2021, 12:41:33 »
I guess that's a good prompt to ask if you'll allow for a place for temporary effects to attributes, such as drugs?

Eventually. Just aiming for basic alpha now (point builder and general game play support) then I'm going to switch to a different product. Just want to get these to a MVP state and keep poking CGL about a possible 'official' stamp. What ever happens after that will be up in the air.

If they go for my idea, then it'll be a full on app that supports the entire AToW rule set. If they don't, then it may morph into something that'll work with MekHQ.

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #46 on: 25 July 2021, 12:49:31 »
Best of luck with the official stamp!  :thumbsup:

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #47 on: 26 July 2021, 13:11:05 »
Best of luck with the official stamp!  :thumbsup:

Thanks. I'll take all the luck I can get.

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #48 on: 31 July 2021, 18:56:07 »
Today's updates:

* Combat Data is populated now from existing data.
* Updated C-Bill icon
* Updated Skill display to show calculated TW base number.

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #49 on: 31 July 2021, 19:04:35 »
Ah, I see what you're missing now.  When you're ready to incorporate the optimization logic, let me know.  That's a solved problem.

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #50 on: 01 August 2021, 10:24:47 »
Haven't even gotten to that point yet. Trying to get all the parts in first and just hit a stumbling block for inventory. Need to build a support database as weapons can be in multiple categories and the data structure I'm building for seed data isn't... that flexible easily.

So.... time to build the supporting software to support the support software. lol

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #51 on: 01 August 2021, 10:30:24 »
Ouch... good luck with the coding!  :thumbsup:

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #52 on: 01 August 2021, 12:16:41 »
The coding is the easy part. The design... that's the fun part.

Implementing all the rules.... that's the challenge.

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #53 on: 01 August 2021, 12:47:05 »
True, true... it took me months to get optimization right.

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #54 on: 01 August 2021, 18:06:17 »
Yea, when I get done with the support site and get to optimization, I’ll probably hit you up for what you did and see if I can transcribe it to the language I’m using.

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #55 on: 01 August 2021, 18:11:07 »
Cool, I'll be here!  :thumbsup:

rjhancock

  • Master Sergeant
  • *
  • Posts: 221
Re: Seeking Input for a digital record sheet for AToW
« Reply #56 on: 25 August 2021, 06:09:11 »
This project is going to take a backseat for a bit as the next part requires a considerable amount of data entry and, as I only want to do that once, will be building out a master site that contains it all for use in this and other related projects. Once that site is done and live, I'll adjust and integrate this one with it's API.

monbvol

  • Lieutenant Colonel
  • *
  • Posts: 11135
  • Flogging will continue until morale improves
Re: Seeking Input for a digital record sheet for AToW
« Reply #57 on: 25 August 2021, 14:04:38 »
I can certainly appreciate that as I've been there and done that, to such an extent that I'm probably never going to do another spreadsheet for AToW character creation again.

That said though if the data entry I have done with mine is in a useful to just yank and manipulate in a reasonable fashion you are absolutely welcome to do so.

Daryk

  • Colonel
  • *
  • Posts: 20988
  • The Double Deuce II/II-σ
Re: Seeking Input for a digital record sheet for AToW
« Reply #58 on: 25 August 2021, 14:06:15 »
Same here!  If you PM your data requirements to one or both of us, I'm sure we can save you some work.  :thumbsup:

Bedwyr

  • A Sticky Wicket
  • Global Moderator
  • Lieutenant Colonel
  • *
  • Posts: 8878
  • RIP. Again. And again. And again.
Re: Seeking Input for a digital record sheet for AToW
« Reply #59 on: 25 August 2021, 15:01:56 »
Still very much looking forward to this. Someday it would be awesome to have a structure that would work in Roll20 or similar (a group of us have been doing 5E gaming for over a year this way since the pandemic started).
Alas poor Photobucket. I knew him Horatio, a fellow of infinite jest, of most excellent fancy.