OOTP Developments Forums - View Single Post

kq76 · 01-13-2004, 10:55 AM

Formulas for this year:

http://www.ootpdevelopments.com/boar...threadid=40133

Figuring "$ for... next year" is a bit complicated, but my archive in my sig tries to get a reasonably close figure (it's not exact because it cannot foresee the future). Here's a screenshot of the applicable sheet for my old solo league. Notice what is inside the red square. NY stands for next year.

EDIT: Bah! It didn't attach. I'll put it here temporarily:

EDIT2: Here's the applicable VB code:

Code:

    'ny
    Range("I23") = "=I17+I40-I50" 'payroll
    Range("I24") = "=IF($B$7>0,$B$7-I23,""N/A"")" 'cap room
    Range("I25") = "=I$4+I$6+I$5+I$15-I23" '$ for FAs
    Range("I26") = "=I$4+I$6+I$5+I$15-(I23-I51)" '$ for Exts

So..

NY payroll = TY payroll + NY Salary Extensions - 1 Yr Salary Obligations (I count salary obligations as those contracts you _have_ to pay and 1 Yr Salary Obligations are just those 1 yr contracts you have)

NY $ for FAs = TY Att Rev + TY Merch Rev + TY Broadcasting Rev + Retained Earnings (NY Cash) - NY Payroll

NY $ for Exts = TY Att Rev + TY Merch Rev + TY Broadcasting Rev + Retained Earnings (NY Cash) - (NY Payroll - 2 Yr Salary Obligations)

If you think I should change something, let me know.

01-13-2004, 10:55 AM	#5
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,009	Formulas for this year: http://www.ootpdevelopments.com/boar...threadid=40133 Figuring "$ for... next year" is a bit complicated, but my archive in my sig tries to get a reasonably close figure (it's not exact because it cannot foresee the future). Here's a screenshot of the applicable sheet for my old solo league. Notice what is inside the red square. NY stands for next year. EDIT: Bah! It didn't attach. I'll put it here temporarily: EDIT2: Here's the applicable VB code: Code: 'ny Range("I23") = "=I17+I40-I50" 'payroll Range("I24") = "=IF($B$7>0,$B$7-I23,""N/A"")" 'cap room Range("I25") = "=I$4+I$6+I$5+I$15-I23" '$ for FAs Range("I26") = "=I$4+I$6+I$5+I$15-(I23-I51)" '$ for Exts So.. NY payroll = TY payroll + NY Salary Extensions - 1 Yr Salary Obligations (I count salary obligations as those contracts you _have_ to pay and 1 Yr Salary Obligations are just those 1 yr contracts you have) NY $ for FAs = TY Att Rev + TY Merch Rev + TY Broadcasting Rev + Retained Earnings (NY Cash) - NY Payroll NY $ for Exts = TY Att Rev + TY Merch Rev + TY Broadcasting Rev + Retained Earnings (NY Cash) - (NY Payroll - 2 Yr Salary Obligations) If you think I should change something, let me know. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project) For Beta/Devs: Full screen (1920x1080) Last edited by kq76; 01-13-2004 at 11:09 AM.