Page 4 of 10

Re: Marksmanship Tracking Sheet (based on RMA-Standards as per AO 1803-03) v1.6

PostPosted:Tue May 22, 2018 2:54 pm
by Christopher Bayonet
In looking through the AD I also noticed that there's a limit in how many hours a member can earn for any activity based on percentage of time needed for their next level.

I need to recode a significant chuck of data towards this... it will be pushing back the next release by a little bit longer. Estimated date for new release is about June 1st due to the recording needed as well as completion of a few other areas.

Re: Marksmanship Tracking Sheet (based on RMA-Standards as per AO 1803-03) v1.6

PostPosted:Sat Jun 09, 2018 10:55 pm
by Erik Plossl
How are you coming on the new version? I know we're working on trying to get some members up with Marksmanship awards, so I was curious how you were coming on this.

Re: Marksmanship Tracking Sheet (based on RMA-Standards as per AO 1803-03) v1.6

PostPosted:Sun Jun 10, 2018 10:50 am
by Christopher Bayonet
Erik Plossl wrote:How are you coming on the new version? I know we're working on trying to get some members up with Marksmanship awards, so I was curious how you were coming on this.
Had to take a break from it last week due to work. It should be finished by Saturday hopefullly

Sent from my NS-P11A8100 using Tapatalk


Re: Marksmanship Tracking Sheet (based on RMA-Standards as per AO 1803-03) v1.6

PostPosted:Tue Jun 12, 2018 1:05 am
by Kevin Walsh
I have bashed together a really basic database for tracking second fleet marksmanship Awards, its done with the newest version of M$ Access

its currently set up with the following datafields
Name
Rank
Ship
Pistol Award
Rifle Award

is this something anybody else might find useful? everything possible uses pull down menus, and updating is quick and painless

Re: Marksmanship Tracking Sheet (based on RMA-Standards as per AO 1803-03) v1.6

PostPosted:Tue Jun 12, 2018 12:15 pm
by Christopher Bayonet
Kevin Walsh wrote:I have bashed together a really basic database for tracking second fleet marksmanship Awards, its done with the newest version of M$ Access

its currently set up with the following datafields
Name
Rank
Ship
Pistol Award
Rifle Award

is this something anybody else might find useful? everything possible uses pull down menus, and updating is quick and painless
I will have the excel version out this weekend.

Sent from my LGLS992 using Tapatalk


Re: Marksmanship Tracking Sheet (based on RMA-Standards as per AO 1803-03) v1.6

PostPosted:Tue Jun 12, 2018 12:33 pm
by Kevin Walsh
very cool, I put this together while sifting through a lot of missing and disjointed records I've been catching up on

Re: Marksmanship Tracking Sheet (based on RMA-Standards as per AO 1803-03) v1.6

PostPosted:Thu Jun 14, 2018 3:50 am
by Tamera Tozer-Kilts
We've found another issue. The hours logged in the RMA section of an individual page are not aggregating correctly in the RMN/RMMC and Grayson sections.

For example in cell F38 it currently reads:
=IF(Name<>"",IFERROR(MAX(F29,F26,F30,F33),""),"")

I believe it should read:
=IF(Name<>"",IFERROR(sum(F29,F26,F30,F33),""),"")

If I am correct, this will aggregate equivelent riffle hours. The same would aply to the pistol cell F39.

Thank you for your attention.

Re: Marksmanship Tracking Sheet (based on RMA-Standards as per AO 1803-03) v1.6

PostPosted:Thu Jun 14, 2018 5:36 am
by Andrew Sivula
Based on the AO you do not add the weapon specializations together to get the rmn weapon qualification, you take the highest one and use that one, that is why its listed as max not sum
Tamera Tozer-Kilts wrote:
Thu Jun 14, 2018 3:50 am
We've found another issue. The hours logged in the RMA section of an individual page are not aggregating correctly in the RMN/RMMC and Grayson sections.

For example in cell F38 it currently reads:
=IF(Name<>"",IFERROR(MAX(F29,F26,F30,F33),""),"")

I believe it should read:
=IF(Name<>"",IFERROR(sum(F29,F26,F30,F33),""),"")

If I am correct, this will aggregate equivelent riffle hours. The same would aply to the pistol cell F39.

Thank you for your attention.

Re: Marksmanship Tracking Sheet (based on RMA-Standards as per AO 1803-03) v1.6

PostPosted:Thu Jun 14, 2018 8:57 am
by Christopher Bayonet
That's not an issue... It is as per AO.

The only cummulative award is the Grayson Marksmanship award.
Tamera Tozer-Kilts wrote:We've found another issue. The hours logged in the RMA section of an individual page are not aggregating correctly in the RMN/RMMC and Grayson sections.

For example in cell F38 it currently reads:
=IF(Name<>"",IFERROR(MAX(F29,F26,F30,F33),""),"")

I believe it should read:
=IF(Name<>"",IFERROR(sum(F29,F26,F30,F33),""),"")

If I am correct, this will aggregate equivelent riffle hours. The same would aply to the pistol cell F39.

Thank you for your attention.
Sent from my LGLS992 using Tapatalk


Re: Marksmanship Tracking Sheet (based on RMA-Standards as per AO 1803-03) v1.6

PostPosted:Thu Jun 14, 2018 9:01 am
by Christopher Bayonet
Andrew Sivula wrote:Based on the AO you do not add the weapon specializations together to get the rmn weapon qualification, you take the highest one and use that one, that is why its listed as max not sum
Tamera Tozer-Kilts wrote:
Thu Jun 14, 2018 3:50 am
We've found another issue. The hours logged in the RMA section of an individual page are not aggregating correctly in the RMN/RMMC and Grayson sections.

For example in cell F38 it currently reads:
=IF(Name<>"",IFERROR(MAX(F29,F26,F30,F33),""),"")

I believe it should read:
=IF(Name<>"",IFERROR(sum(F29,F26,F30,F33),""),"")

If I am correct, this will aggregate equivelent riffle hours. The same would aply to the pistol cell F39.

Thank you for your attention.
Also I will note, as I have said previously, the version thatcis circulating is obsolete... I am about to release the first patch of the new one soon.

It has all the coding errors corrected and will be compliant for black sphinx reporting.

Sent from my LGLS992 using Tapatalk