Page 2 of 4

Re: Roster Monster

Posted: Wed Nov 07, 2018 2:38 pm
by elguapo
Drag or copy the second row's column and paste it to the desired row's column.

If you want to do multiple players select the second row, the greyed out one, and drag the tiny square down to desired row.

Re: Roster Monster

Posted: Wed Nov 07, 2018 3:54 pm
by sarcasticface
elguapo wrote:Drag or copy the second row's column and paste it to the desired row's column.

If you want to do multiple players select the second row, the greyed out one, and drag the tiny square down to desired row.

Say my team had 3 QBs. If they were all good (High), they would all have the same ratings?

Re: Roster Monster

Posted: Wed Nov 07, 2018 4:22 pm
by elguapo
sarcasticface wrote:
elguapo wrote:Drag or copy the second row's column and paste it to the desired row's column.

If you want to do multiple players select the second row, the greyed out one, and drag the tiny square down to desired row.

Say my team had 3 QBs. If they were all good (High), they would all have the same ratings?


No. They would have random ratings based on the high and low values. So your three QBs could have mix of high, average and poor ratings. The formulas could be expanded to add a QB1 for first string ratings a QB2 for second string ratings etc.

I'm redoing the formulas but you can still work on your roster since the new formulas will over write the old ones. The body mass formulas seem to do an adequate job for positions.

Re: Roster Monster

Posted: Wed Nov 07, 2018 4:32 pm
by sarcasticface
elguapo wrote:
sarcasticface wrote:
elguapo wrote:Drag or copy the second row's column and paste it to the desired row's column.

If you want to do multiple players select the second row, the greyed out one, and drag the tiny square down to desired row.

Say my team had 3 QBs. If they were all good (High), they would all have the same ratings?


No. They would have random ratings based on the high and low values. So your three QBs could have mix of high, average and poor ratings. The formulas could be expanded to add a QB1 for first string ratings a QB2 for second string ratings etc.

I'm redoing the formulas but you can still work on your roster since the new formulas will over write the old ones. The body mass formulas seem to do an adequate job for positions.

I'll wait for the updated formula. I will keep the player names, position, weight, etc. Btw, No matter what you do for a QB all of his ratings will be at 2.

Re: Roster Monster

Posted: Wed Nov 07, 2018 5:03 pm
by elguapo
sarcasticface wrote:
elguapo wrote:
sarcasticface wrote:Say my team had 3 QBs. If they were all good (High), they would all have the same ratings?


No. They would have random ratings based on the high and low values. So your three QBs could have mix of high, average and poor ratings. The formulas could be expanded to add a QB1 for first string ratings a QB2 for second string ratings etc.

I'm redoing the formulas but you can still work on your roster since the new formulas will over write the old ones. The body mass formulas seem to do an adequate job for positions.

I'll wait for the updated formula. I will keep the player names, position, weight, etc. Btw, No matter what you do for a QB all of his ratings will be at 2.


Yeap. Temp fix is to remove the two solid gray rows above the QB ratings in the BASEDATA sheet and then in the PLAYDATA SHEET click on any cell with a formal and then using the function to find and replace, replace the " + 2" with null or in other words delete that string. All of them.

Re: Roster Monster

Posted: Thu Nov 08, 2018 8:20 pm
by elguapo
Version two of the formulas is up in the first post.

No equipment or contract for formulas yet.

Re: Roster Monster

Posted: Thu Nov 08, 2018 8:56 pm
by sarcasticface
I still don't get how to add "High" or "Low" to a player.

Re: Roster Monster

Posted: Thu Nov 08, 2018 9:01 pm
by elguapo
sarcasticface wrote:I still don't get how to add "High" or "Low" to a player.


The formula does it for you. Remember that this system is to quickly add players into Madden, once in Madden you can tweak them even further.

But if you're still a little lost I'll make a video explaining how to use the base ratings.

Re: Roster Monster

Posted: Thu Nov 08, 2018 9:22 pm
by sarcasticface
elguapo wrote:
sarcasticface wrote:I still don't get how to add "High" or "Low" to a player.


The formula does it for you. Remember that this system is to quickly add players into Madden, once in Madden you can tweak them even further.

But if you're still a little lost I'll make a video explaining how to use the base ratings.

That would be helpful.

EDIT: Nevermind, I got it!!! Thanks!

Re: Roster Monster

Posted: Fri Nov 09, 2018 1:10 pm
by elguapo
BUS36 wrote:Helmets....Vicius01and SpeedFlex
2 bar Rb- RBs, DBs, WRs
2 bar- Qbs,Ks and Ps
3BarRB- RBs, FBs,LBs, TEs and some OL& DLwiththe Vicius 01
RB Robots- RBs,LBs and DBs with the SpeedFlex
RB Bull-OL & DL
Full Cage -OL,DL and some LBs


I don't see Vicius01 and SpeedFlex. I only see Style1-Style4 and revolution.