Morale Emojis output in reports

[Yankee Hotel Foxtrot]

Hi, I am trying to create some spreadsheets for my game.
Unfortunately when I output .csv file report, the morale information is removed.
Is there a setting in game to change how the game outputs these, ie converts them to a value or range value like Very High, Normal, Low, Very Low etc..?


Thank you

[OutS|der]

No that stuff has never been exported when exporting players. You'll notice there are a few columns not included.

Will just have to edit this in game on a player by player basis.

[Yankee Hotel Foxtrot]

Originally Posted by OutS|der

No that stuff has never been exported when exporting players. You'll notice there are a few columns not included.

Will just have to edit this in game on a player by player basis.

Is there are reason why? Its quite annoying, given the influence of various morale indicators. I'm trying to monitor changes on spreadsheets and having to update these manually seems unnecessary.
Is there a compelling reason why OOTP would not make these changes. Especially as it seems a lot of people keep spreadsheets of game data.

[matskralc!]

Morale information can be found in the morale, morale_mod, morale_player_performance, morale_team_performance, morale_team_transactions, morale_team_chemistry, and morale_player_role columns in the player.csv file that can be exported from League Settings > Database > Database Tools > Export data to CSV files.

I am not 100% sure, but the columns appear to use the following scales:

morale: 1 to 100
morale_mod: 0 to 200
morale_player_performance: -500 to 500
morale_team_performance: -500 to 500
morale_team_transactions: -500 to 500
morale_team_chemistry is hard to say. The league file I'm looking at ranges from -2057 to 3388.
morale_player_role: -5000 to 5000

[Yankee Hotel Foxtrot]

Originally Posted by matskralc!

Morale information can be found in the morale, morale_mod, morale_player_performance, morale_team_performance, morale_team_transactions, morale_team_chemistry, and morale_player_role columns in the player.csv file that can be exported from League Settings > Database > Database Tools > Export data to CSV files.

I am not 100% sure, but the columns appear to use the following scales:

morale: 1 to 100
morale_mod: 0 to 200
morale_player_performance: -500 to 500
morale_team_performance: -500 to 500
morale_team_transactions: -500 to 500
morale_team_chemistry is hard to say. The league file I'm looking at ranges from -2057 to 3388.
morale_player_role: -5000 to 5000

Thanks mate, appreciate it!
Its a shame its not in reporting, I'd been setting up some rules on spreadsheets to help me guide training development plan adjustments and such, and morale and coaching would be great to include.
I have a Master Spreadsheet of my complete organisation roster's ratings.

I've set up a grouped tiered heading structure to group ratings. My Spreadsheet has 4 tabs which represent Quarterly update cycles of my roster, which I import via the game's report output function into .csv.

I've spent time calibrating the spreadsheet against the report column so I can just dump it in and it's aligned.. I've just got the first Qtr in and working and slowly trying to build some tags, and spreadsheet flags to help inform and highlight significant tagged scenarios. Whilst I've included all morale context fields in my report, they just return blanks.

Unfortunately I don't seem to be able to change that.
My current work around therefore is instead I do it on a player by player basis and I share screenshots of the game with CoPilot to capture specific player's morale info and then I couple if with my game data to CoPilots thoughts on possible influence on my development plan.
I'd much rather the report output the emojis as value ranges like it does for Personality traits like intelligence and work ethic etc.. And just output the smiley face as Very Happy and the angry face and Very Angry. Then I can make my own rule sets in Excel around tagging morale as a volatility variable

[OutS|der]

My bad, I was thinking Personality settings. Those aren't exported for some reason.
Morale is though. Sorry for the confusion

[matskralc!]

Personality ratings are also included in the players.csv file that can be exported from League Settings > Database > Database Tools > Export data to CSV files.

personality_greed: 1-200
personality_loyalty: 1-200
personality_play_for_winner: 1-200
personality_work_ethic: 1-200
personality_intelligence: 1-200
personality_leader: 1-255

[OutS|der]

Originally Posted by matskralc!

Personality ratings are also included in the players.csv file that can be exported from League Settings > Database > Database Tools > Export data to CSV files.

personality_greed: 1-200
personality_loyalty: 1-200
personality_play_for_winner: 1-200
personality_work_ethic: 1-200
personality_intelligence: 1-200
personality_leader: 1-255

Not all of them. It's missing 5 others

[NoOne]

The best way is to make 'work' sheets... use exclusive sheets for the import data -- a link to a file can force the spreasheet to automatically 'update links' to data files too, which often saves the trouble of constantly re-importing it.

So you have a sepearte worksheet for each exported data file.. then use references to create a contiguous table of the columns you want to put to gether...

Now, each time you open the spreadhseet, it'll ask to update links, which then updates all your tables automatically. you can simply point to the typical export folder or move the files somewhere you consistently use for this spreadhseet etc... just make the 'link' to the proper file location.

table creation - just do thehe first row (or 2 rows if you have subleague). Once all the =!sheet1.a1 etc are filled out, highlight top row, then use the 'fill' function for the rest of the table rows. Cell references will auto-increment and entire table is made in a matter of seconds.

pulling data from multiple files and consolidating to 1 table is easy-peasy.

You could even incorporate an IF into the column with morale and such ... if you don't want the raw values, you can just convret it to what you see in the game.... not emojies... well even that you could make it display one of a number of images.

Originally Posted by Yankee Hotel Foxtrot

Thanks mate, appreciate it!
Its a shame its not in reporting, I'd been setting up some rules on spreadsheets to help me guide training development plan adjustments and such, and morale and coaching would be great to include.
I have a Master Spreadsheet of my complete organisation roster's ratings.

I've set up a grouped tiered heading structure to group ratings. My Spreadsheet has 4 tabs which represent Quarterly update cycles of my roster, which I import via the game's report output function into .csv.

I've spent time calibrating the spreadsheet against the report column so I can just dump it in and it's aligned.. I've just got the first Qtr in and working and slowly trying to build some tags, and spreadsheet flags to help inform and highlight significant tagged scenarios. Whilst I've included all morale context fields in my report, they just return blanks.

Unfortunately I don't seem to be able to change that.
My current work around therefore is instead I do it on a player by player basis and I share screenshots of the game with CoPilot to capture specific player's morale info and then I couple if with my game data to CoPilots thoughts on possible influence on my development plan.
I'd much rather the report output the emojis as value ranges like it does for Personality traits like intelligence and work ethic etc.. And just output the smiley face as Very Happy and the angry face and Very Angry. Then I can make my own rule sets in Excel around tagging morale as a volatility variable