Roster Monster

User avatar
elguapo
Hall of Fame
Posts: 2286
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

Re: Roster Monster

Postby elguapo » Wed Nov 07, 2018 2:38 pm

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

Sponsor

Sponsor
 

sarcasticface
MVP
Posts: 533
Joined: Fri Jan 05, 2018 4:57 pm

Re: Roster Monster

Postby sarcasticface » Wed Nov 07, 2018 3:54 pm

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?
Joshua 24:15 (...as for me and my house, we will serve the Lord.)

Mosiah 2:17 (...when ye are in the service of your fellow beings, ye are only in the service of your God.)

John 3:16 (For God so loved the world that He gave His only begotten Son...)

User avatar
elguapo
Hall of Fame
Posts: 2286
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

Re: Roster Monster

Postby elguapo » Wed Nov 07, 2018 4:22 pm

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.

sarcasticface
MVP
Posts: 533
Joined: Fri Jan 05, 2018 4:57 pm

Re: Roster Monster

Postby sarcasticface » Wed Nov 07, 2018 4:32 pm

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.
Joshua 24:15 (...as for me and my house, we will serve the Lord.)

Mosiah 2:17 (...when ye are in the service of your fellow beings, ye are only in the service of your God.)

John 3:16 (For God so loved the world that He gave His only begotten Son...)

User avatar
elguapo
Hall of Fame
Posts: 2286
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

Re: Roster Monster

Postby elguapo » Wed Nov 07, 2018 5:03 pm

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.

User avatar
elguapo
Hall of Fame
Posts: 2286
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

Re: Roster Monster

Postby elguapo » Thu Nov 08, 2018 8:20 pm

Version two of the formulas is up in the first post.

No equipment or contract for formulas yet.

sarcasticface
MVP
Posts: 533
Joined: Fri Jan 05, 2018 4:57 pm

Re: Roster Monster

Postby sarcasticface » Thu Nov 08, 2018 8:56 pm

I still don't get how to add "High" or "Low" to a player.
Joshua 24:15 (...as for me and my house, we will serve the Lord.)

Mosiah 2:17 (...when ye are in the service of your fellow beings, ye are only in the service of your God.)

John 3:16 (For God so loved the world that He gave His only begotten Son...)

User avatar
elguapo
Hall of Fame
Posts: 2286
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

Re: Roster Monster

Postby elguapo » Thu Nov 08, 2018 9:01 pm

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.

sarcasticface
MVP
Posts: 533
Joined: Fri Jan 05, 2018 4:57 pm

Re: Roster Monster

Postby sarcasticface » Thu Nov 08, 2018 9:22 pm

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!
Joshua 24:15 (...as for me and my house, we will serve the Lord.)

Mosiah 2:17 (...when ye are in the service of your fellow beings, ye are only in the service of your God.)

John 3:16 (For God so loved the world that He gave His only begotten Son...)

User avatar
elguapo
Hall of Fame
Posts: 2286
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX
Contact:

Re: Roster Monster

Postby elguapo » Fri Nov 09, 2018 1:10 pm

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.


Return to “Rosters”

Who is online

Users browsing this forum: No registered users and 12 guests