EA UFC Excel Spreadsheet

[jeremym480]

Quote: Originally Posted by queenie.paula

asked in the other thread with no answer, im not able to fool with your spreadsheet right now, if I ad say a new number for someone wins or loses, will all the other number adjust automatically? sorry im not a pro with spreadsheets

If you want to manually give a fighter a won/loss, then I would do add it in the "Old Win/Loss" column. The My Win/Loss columns are formulas so I wouldn't mess with those.

[queenie.paula]

Quote: Originally Posted by jeremym480

If you want to manually give a fighter a won/loss, then I would do add it in the "Old Win/Loss" column. The My Win/Loss columns are formulas so I wouldn't mess with those.

lol you've lost me

[jeremym480]

Quote: Originally Posted by queenie.paula

lol you've lost me

If you're using my spreadsheet, then the way to add wins or losses manually is by changing the numbers in the Old W/L columns (pictured below in Columns W and X).

If this isn't the spreadsheet you're using then I'd suggest PMing whoever posted the spreadsheet.

[queenie.paula]

Quote: Originally Posted by jeremym480

If you're using my spreadsheet, then the way to add wins or losses manually is by changing the numbers in the Old W/L columns (pictured below in Columns W and X). If this isn't the spreadsheet you're using then I'd suggest PMing whoever posted the spreadsheet.

yup I got your sheet, so if I changed it to update it after say I do an event say from 11-0 to 11-1 and press enter will all other numbers change for me too? btw try not to beat up on me too bad im in kenner la and should get good treatment lol

[jeremym480]

Quote: Originally Posted by queenie.paula

yup I got your sheet, so if I changed it to update it after say I do an event say from 11-0 to 11-1 and press enter will all other numbers change for me too? btw try not to beat up on me too bad im in kenner la and should get good treatment lol

When you move an event from the Upcoming Events tab to the Event's History tab all Wins and Losses will update automatically. I have a tutorial in the How's Your Universe Going thread. Check that out and that should help you get a handle on how everything flows.

[Siorai56]

Jeremy, awesome work, is your most up to date spreadsheet in the thread (can you post if not)?

Also, just curious if you or anyone on this thread has an excel sheet with all the fighters attributes, perks, etc, I'm working on some caf's and was thinking about putting together a community "bible" of sorts for CAF's for realistic attributes and perks. But I wanted to make sure they're realistic against the other fighters in the game, i.e. Fedor's takedown isn't higher than Cain Velasquez' etc etc.

[jeremym480]

Quote: Originally Posted by Siorai56

Jeremy, awesome work, is your most up to date spreadsheet in the thread (can you post if not)? Also, just curious if you or anyone on this thread has an excel sheet with all the fighters attributes, perks, etc, I'm working on some caf's and was thinking about putting together a community "bible" of sorts for CAF's for realistic attributes and perks. But I wanted to make sure they're realistic against the other fighters in the game, i.e. Fedor's takedown isn't higher than Cain Velasquez' etc etc.

This is the most up-to-date file. https://onedrive.live.com/edit.aspx?...!117&app=Excel

I know there's at least one error - Rafael Cavalcante is on my spreadsheet and he's named Rafael Feijao in the game. That's easy to fix or just leave the same if you're familiar with him.

Check out ryanawag's Attribute file here http://www.operationsports.com/forum...af-skills.html

It's a WIP, but he's doing a great job so far.

[Th3_FuTuRe]

Everything is great so far with this. Just ran UFC 197 with some minor adjustments (Kept DC/Jones main event) Everything copied and pasted smoothly EXCEPT, now in the title history. Everyone's title reigns have a #REF! error. What's the fix for this?