Error in Spreadsheet calcs.

September 30th, 2005, 10:56 AM

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

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.

September 30th, 2005, 11:26 AM

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

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.

September 30th, 2005, 11:38 AM

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

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

September 30th, 2005, 11:43 AM

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)

September 30th, 2005, 10:56 AM	#1
Skippy the One Eyed Beagle Guest Posts: n/a	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?

September 30th, 2005, 11:26 AM	#3
Skippy the One Eyed Beagle Guest Posts: n/a	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.

September 30th, 2005, 11:43 AM	#7
Skippy the One Eyed Beagle Guest Posts: n/a	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)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Proposed Rookie Salary Scale - Historical Analysis Spreadsheet	Preds	Frenzy Rules & Bylaws	0	March 2nd, 2004 12:37 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)