EA UFC Excel Spreadsheet

[jeremym480]

Re: EA UFC Excel Spreadsheet

So, when I clicked on the hyperlink it says that it's deleted?
Thanks and the faces were a huge help.

I don't know what the problem is because when I click it it works. I'll post it again and if it's doesn't work this time then I will email you a copy in Excel rather than Excel Online.

[queenie.paula]

Re: EA UFC Excel Spreadsheet

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

[jeremym480]

Re: EA UFC Excel Spreadsheet

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]

Re: EA UFC Excel Spreadsheet

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]

Re: EA UFC Excel Spreadsheet

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]

Re: EA UFC Excel Spreadsheet

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]

Re: EA UFC Excel 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

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]

Re: EA UFC Excel Spreadsheet

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]

Re: EA UFC Excel Spreadsheet

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]

Re: EA UFC Excel Spreadsheet

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?

[jeremym480]

Re: EA UFC Excel Spreadsheet

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?

Do you have dates entered into the cell A6 of the Events History Spreadsheet? If so, then I'm guess that the formula in the Title Reigns column is off. The formula should look like this:

='EVENTS HISTORY'!$A$6-'TITLE HISTORY'!H2 & " Days"

If there's any other number than 6 after the A$ then that's your problem. You can manually enter those yourself. Also, if you change EVENTS HISTORY to UPCOMING EVENTS in the formula, then that should stop it from messing up going forward.

[Th3_FuTuRe]

Re: EA UFC Excel Spreadsheet

Do you have dates entered into the cell A6 of the Events History Spreadsheet? If so, then I'm guess that the formula in the Title Reigns column is off. The formula should look like this:

='EVENTS HISTORY'!$A$6-'TITLE HISTORY'!H2 & " Days"

If there's any other number than 6 after the A$ then that's your problem. You can manually enter those yourself. Also, if you change EVENTS HISTORY to UPCOMING EVENTS in the formula, then that should stop it from messing up going forward.

Thanks!! That helped clear it up. For whatever reason, the formula didn't have the A6 in there.

[pimpinpidgeon8]

Re: EA UFC Excel Spreadsheet

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.

The link for the file doesn't seem to work for me, could you post a new download link.

[jeremym480]

Re: EA UFC Excel Spreadsheet

The link for the file doesn't seem to work for me, could you post a new download link.

I wasn't sure which file you wanted so here's a link for both in Excel Online.

My file - https://onedrive.live.com/edit.aspx?...!117&app=Excel

Ryan's file - https://onedrive.live.com/edit.aspx?...!117&app=Excel

[pimpinpidgeon8]

Re: EA UFC Excel Spreadsheet

I wasn't sure which file you wanted so here's a link for both in Excel Online.

My file - https://onedrive.live.com/edit.aspx?...!117&app=Excel

Ryan's file - https://onedrive.live.com/edit.aspx?...!117&app=Excel

I need your file and is there another way you could post it for me to download? I'm clicking on your link, signing in with my account and it keeps telling me the file "may not exist or is no longer available"... The link you posted in the "UFC Universe thread" when you had your 1.3 update worked well for me ... is your updated sheet any different or is it the same as that link?