Pred's Fantasy Football Forums

Pred's Fantasy Football Forums (http://predsff.com/forums//index.php)
-   SAC'D Free Agency & the Waiver Wire (http://predsff.com/forums//forumdisplay.php?f=92)
-   -   Error in Spreadsheet calcs. (http://predsff.com/forums//showthread.php?t=7912)

Skippy the One Eyed Beagle September 30th, 2005 10:56 AM
Error in Spreadsheet calcs.
 
OK. Just realized that there is an error on the spreadsheet calculations.

You are supposed to get 1 cap year back for each player on the IR. This doesn't seem to be happening.

This is a big deal for me cuz the reason I cut Will Allen was because I thought I was over cap years, but since I slapped Haggans on the IR, I should have gotten 1 year back which means I can fit Will Allen.

If you need help fixing the formula let me know, also, can I uncut Will Allen since I only cut him because I thought I had screwed up and was over?

Preds September 30th, 2005 10:58 AM
Re: Error in Spreadsheet calcs.
 
Quote:
Originally Posted by Skippy the One Eyed Beagle
OK. Just realized that there is an error on the spreadsheet calculations.

You are supposed to get 1 cap year back for each player on the IR. This doesn't seem to be happening.

This is a big deal for me cuz the reason I cut Will Allen was because I thought I was over cap years, but since I slapped Haggans on the IR, I should have gotten 1 year back which means I can fit Will Allen.

If you need help fixing the formula let me know, also, can I uncut Will Allen since I only cut him because I thought I had screwed up and was over?
I manually change the formula to subtract 1 for each guy put on IR. I usually do it after I update FFL from Frank's copy, then reupload it.

I'll get to it by the weekend. You do get 1 year for each IR move.

I'd be OK with reversing the Will Allen cut... no biggie to me. BTW, WHICH Will Allen did you mean to pickup? There's 2 DB's named Will Allen, one plays for the Saints, the other the Giants. You never specified a team in your bid you slacker.

Skippy the One Eyed Beagle September 30th, 2005 11:26 AM
Re: Error in Spreadsheet calcs.
 
Do you want me to fix the formula to do it automatically?


I meant the NYG one. Didn't realize there were two of them.

Preds September 30th, 2005 11:37 AM
Re: Error in Spreadsheet calcs.
 
Quote:
Originally Posted by Skippy the One Eyed Beagle
Do you want me to fix the formula to do it automatically?


I meant the NYG one. Didn't realize there were two of them.
y, that'd be good. Email the file to me when you're done.

Skippy the One Eyed Beagle September 30th, 2005 11:38 AM
Re: Error in Spreadsheet calcs.
 
Quote:
Originally Posted by Preds
y, that'd be good. Email the file to me when you're done.
Is the latest on the site?

Preds September 30th, 2005 11:40 AM
Re: Error in Spreadsheet calcs.
 
Quote:
Originally Posted by Skippy the One Eyed Beagle
Is the latest on the site?
know what, I'll email a good copy to you

Skippy the One Eyed Beagle September 30th, 2005 11:43 AM
Re: Error in Spreadsheet calcs.
 
It is actually a real easy fix preds.


In Cell H90 (the calc for IR player contract years) replace the formula with this one:

=SUM(H86:H89)-COUNT(H86:H89)


All times are GMT -4. The time now is 07:18 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
© 2000-2022 - Preds Fantasy Football Forums