Madden 18 CFM Scouting Tool - Page 3 - Operation Sports Forums
Home

Madden 18 CFM Scouting Tool

This is a discussion on Madden 18 CFM Scouting Tool within the Madden NFL Football forums.

Go Back   Operation Sports Forums > Football > Madden NFL Football
Reply
 
Thread Tools
Old 08-24-2017, 01:51 PM   #17
I hate you Norv
 
tdawg3782's Arena
 
OVR: 11
Join Date: Nov 2003
Location: San Diego
Posts: 3,496
Re: Madden 18 CFM Scouting Tool

Quote:
Originally Posted by Old Man Nathy
Odd. I'll check.
Quote:
Originally Posted by extremeskins04
Tdawg once I closed Excel 2016 and re-opened it I didn't have the problem anymore and I've added 6 players, but we'll see if OMN finds anything quirky.
Here is a quick video I made so you can see what's happening. Seemed like that would be easier then trying to explain it.

__________________
Twitch Broadcast Link
www.twitch.tv/tdawg3782


NFL: Chargers
Bandwagon NFL: TBD
MLB: Padres
NCAAF: San Diego State
NCAAB: San Diego State

tdawg3782 is offline  
Reply With Quote
Old 08-24-2017, 02:02 PM   #18
That's top class!
 
extremeskins04's Arena
 
OVR: 1
Join Date: Aug 2010
Location: Boston, Mass.
Posts: 3,178
Re: Madden 18 CFM Scouting Tool

Quote:
Originally Posted by tdawg3782
Here is a quick video I made so you can see what's happening. Seemed like that would be easier then trying to explain it.

Yep Tdawg I had that issue the first time I opened the tool in Excel 2016, but I have not had that problem since I first closed and re-opened it.

I did the exact same thing you did and followed your step in your video and I didn't get the #VALUE! error. It kept the rating and rank. I'm not sure man.
extremeskins04 is offline  
Reply With Quote
Old 08-24-2017, 02:10 PM   #19
I hate you Norv
 
tdawg3782's Arena
 
OVR: 11
Join Date: Nov 2003
Location: San Diego
Posts: 3,496
Re: Madden 18 CFM Scouting Tool

Quote:
Originally Posted by extremeskins04
Yep Tdawg I had that issue the first time I opened the tool in Excel 2016, but I have not had that problem since I first closed and re-opened it.

I did the exact same thing you did and followed your step in your video and I didn't get the #VALUE! error. It kept the rating and rank. I'm not sure man.
Really weird right? I know my fair share about Excel too and I'm stumped. Hopefully OMN can figure it out.
__________________
Twitch Broadcast Link
www.twitch.tv/tdawg3782


NFL: Chargers
Bandwagon NFL: TBD
MLB: Padres
NCAAF: San Diego State
NCAAB: San Diego State

tdawg3782 is offline  
Reply With Quote
Old 08-24-2017, 02:26 PM   #20
Rookie
 
Old Man Nathy's Arena
 
OVR: 0
Join Date: Jan 2015
Re: Madden 18 CFM Scouting Tool

Quote:
Originally Posted by tdawg3782
Really weird right? I know my fair share about Excel too and I'm stumped. Hopefully OMN can figure it out.


This is bizarre. I downloaded a fresh copy of the tool and followed the exact steps in your video but couldn't replicate the issue. Can you upload a copy of the spreadsheet where it's happened?
__________________

v5 released 24th August 2017! Check out the thread and download the latest version!
Old Man Nathy is offline  
Reply With Quote
Old 08-24-2017, 02:27 PM   #21
I hate you Norv
 
tdawg3782's Arena
 
OVR: 11
Join Date: Nov 2003
Location: San Diego
Posts: 3,496
Re: Madden 18 CFM Scouting Tool

OMN when I switch archetype the Pos concat column gives a #NAME?. I feel like this is the cause.

__________________
Twitch Broadcast Link
www.twitch.tv/tdawg3782


NFL: Chargers
Bandwagon NFL: TBD
MLB: Padres
NCAAF: San Diego State
NCAAB: San Diego State

tdawg3782 is offline  
Reply With Quote
Advertisements - Register to remove
Old 08-24-2017, 02:31 PM   #22
Rookie
 
Old Man Nathy's Arena
 
OVR: 0
Join Date: Jan 2015
Re: Madden 18 CFM Scouting Tool

Quote:
Originally Posted by tdawg3782
OMN when I switch archetype the Pos concat column gives a #NAME?. I feel like this is the cause.


Yeah that'll be what causes it, that new column gets used for all sorts of stuff. No idea why it would throw an error though. If you change the Concat function to the legacy concatenate function does it help?
__________________

v5 released 24th August 2017! Check out the thread and download the latest version!
Old Man Nathy is offline  
Reply With Quote
Old 08-24-2017, 02:37 PM   #23
I hate you Norv
 
tdawg3782's Arena
 
OVR: 11
Join Date: Nov 2003
Location: San Diego
Posts: 3,496
Re: Madden 18 CFM Scouting Tool

Figured it out guys. So I have a standalone version of Excel 2016. Apparently you must have a subscription to Office 365 for the Concat formula to work. That is my issue. It's not supported. Trying to find a workaround. Thanks for looking into it.
__________________
Twitch Broadcast Link
www.twitch.tv/tdawg3782


NFL: Chargers
Bandwagon NFL: TBD
MLB: Padres
NCAAF: San Diego State
NCAAB: San Diego State

tdawg3782 is offline  
Reply With Quote
Old 08-24-2017, 02:39 PM   #24
That's top class!
 
extremeskins04's Arena
 
OVR: 1
Join Date: Aug 2010
Location: Boston, Mass.
Posts: 3,178
Re: Madden 18 CFM Scouting Tool

Sorry what is the Pos Concat column? I don't see that.
extremeskins04 is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Football > Madden NFL Football »


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -5. The time now is 09:47 PM.

Top -