Thread: Bronco's Salaries and Free Agents

Originally Posted by G_Money

Good deal. Where did you get it?

This, however has got to be a misprint:



Maybe he meant 1.7 million dollar roster bonus?

~G

it's not a misprint. that's why i think robertson is a duesh bag.

actually looking at blys contract. he has already been paid the bulk of his money. the next couple of years its not so bad and if he is considering to restructure then i'd say just keep him. might as well see what he could do with better linebackers and a better dline. he actually might be good trade bait after his restructure if we decide to go that route. as of right now he is going to be making 3.2 mil a year.

OK, I've put it into a nifty little spreadsheet. Special thanks to Devin, who runs the sim-league I'm in, and I used his team-contract template to make it a little easier.

Anyone who wants it, just PM me your e-mail address and I'll send it your way. I'll make sure my box isn't full...

It's all color coded, and I'll explain that in the e-mail.

P.S. I have to leave my internet for a while, so, I'll be back around 9, 9:30-ish tonight...

I made up the Excel file but it was too tough to copy and paste on here. If any of you want a copy of the file, PM me your email address and I'll email it to you.

LOL, looks like MB beat me to it.

Originally Posted by BaileyTheBest

LOL, looks like MB beat me to it.

I bet my spreadsheet is better than yours.

Now that Mike has been "terminated", does anyone else besides me think there will be some surprising subtractions this offseason?

Originally Posted by frauschieze

Excel doesn't format right on here when you copy/paste. Just an FYI.

If you copy and paste and then surround it with "code" tags (the # icon on the new post tool bar) it usually formats pretty good. If it doesn't, if you first paste it into notepad, then copy it again and paste it and surround it by code tags, it will look pretty good. You might have to play with it a little in notepad, adding tab characters (press the tab key) to do some fine tuning.

It usually winds up being a bit manual, paste it and preview, then make adjustments in notepad (adding tabs), the copy and paste again, preview, etc.

The key is to use the 'code' tags.

Just as an example, I know it is off topic, but I just grabbed a spreadsheet I had. By using the "code" tags and by playing with the tabs in notepad, you can get everying aligned correctly:

Code:

Name			RUSHES	%	YARD	AVG	TD
1995					
| Terrell Davis		237	71%	1117	4.7	7
| Aaron Craver		73	22%	333	4.6	5
| Rod Bernstine		23	7%	76	3.3	1
| Reggie Rivers		2	1%	2	1	0
							
1996					
| Terrell Davis		345	76%	1538	4.5	13
| Aaron Craver		59	13%	232	3.9	2
| Vaughn Hebron		49	11%	262	5.3	0
| Reggie Rivers		2	0%	6	3	0
					
1997					
| Terrell Davis		369	81%	1750	4.7	15
| Vaughn Hebron		49	11%	222	4.5	1
| Derek Loville		25	5%	124	5	1
| Howard Griffith	9	2%	34	3.8	0
| Detron Smith		4	1%	10	2.5	0
					
1998					
| Terrell Davis		392	86%	2008	5.1	21
| Derek Loville		53	12%	161	3	2
| Vaughn Hebron		9	2%	31	3.4	1
| Howard Griffith	4	1%	13	3.2	0
| Anthony Lynn		0	0%	0	0	0
| Detron Smith		0	0%	0	0	0
					
1999					
| Olandis Gary		276	68%	1159	4.2	7
| Terrell Davis		67	16%	211	3.1	2
| Derek Loville		40	10%	203	5.1	1
| Howard Griffith	17	4%	66	3.9	1
| John Avery		5	1%	21	4.2	0
| Anthony Lynn		2	0%	2	1	0
| Detron Smith		1	0%	7	7	0
					
2000					
| Mike Anderson		297	65%	1487	5	15
| Terrell Davis		78	17%	282	3.6	2
| Karon Coleman		54	12%	183	3.4	1
| Olandis Gary		13	3%	80	6.2	0
| Raymont Harris	10	2%	22	2.2	0
| Howard Griffith	5	1%	4	0.8	0
					
2001					
| Mike Anderson		175	43%	678	3.9	4
| Terrell Davis		167	41%	701	4.2	0
| Olandis Gary		57	14%	228	4	1
| Karon Coleman		4	1%	17	4.2	0
| Patrick Hape		2	0%	0	0	0
| Tony Carter		1	0%	4	4	0
					
2002					
| Clinton Portis	273	69%	1508	5.5	15
| Mike Anderson		84	21%	386	4.6	2
| Olandis Gary		37	9%	147	4	1
| Reuben Droughns	4	1%	11	2.8	1
					
2003					
| Clinton Portis	290	61%	1591	5.5	14
| Quentin Griffin	94	20%	345	3.7	0
| Mike Anderson		70	15%	257	3.7	3
| Cecil Sapp		12	3%	31	2.6	0
| Reuben Droughns	6	1%	14	2.3	0
					
2004					
| Reuben Droughns	275	60%	1240	4.5	6
| Quentin Griffin	85	19%	311	3.7	2
| Tatum Bell		75	16%	396	5.3	3
| Garrison Hearst	20	4%	81	4	1
| Cecil Sapp		4	1%	32	8	0
| Kyle Johnson		0	0%	0	0	0
					
2005					
| Mike Anderson		239	50%	1014	4.2	12
| Tatum Bell		173	36%	921	5.3	8
| Ron Dayne		53	11%	270	5.1	1
| Cecil Sapp		5	1%	21	4.2	0
| Kyle Johnson		4	1%	9	2.2	1

Originally Posted by Tned

If you copy and paste and then surround it with "code" tags (the # icon on the new post tool bar) it usually formats pretty good. If it doesn't, if you first paste it into notepad, then copy it again and paste it and surround it by code tags, it will look pretty good. You might have to play with it a little in notepad, adding tab characters (press the tab key) to do some fine tuning.

It usually winds up being a bit manual, paste it and preview, then make adjustments in notepad (adding tabs), the copy and paste again, preview, etc.

The key is to use the 'code' tags.

Oh....I know. It's just a pain in the ass for a spreadsheet as detailed as this one. Was just trying to warn BTB.

Originally Posted by frauschieze

Oh....I know. It's just a pain in the ass for a spreadsheet as detailed as this one. Was just trying to warn BTB.

For omething too complicated, the next two best options are print to PDF and provide a link, or several print screens (as many as it takes height wise to get the full spreadsheet), and then attach the image.

Originally Posted by Tned

For omething too complicated, the next two best options are print to PDF and provide a link, or several print screens (as many as it takes height wise to get the full spreadsheet), and then attach the image.

Print screen method:

Open up the spreadsheet, then press the "Print Scrn" button on your keyboard.
Open Paint (or your image editor of choice)
paste in the image - CTRL+V
Then, click the select button in paing (a sqare made up of dotted lines)
Select just the portion you want to display (getting rid of the parts of your desktop you don't want to show)
Click, File, New and don't save changes.
Paste again -CTRL+V, which will now paste in just the part you wanted to show.
Save then upload to a file server.

Repeat as many times as necessary, scrolling down in the spreadsheet to show more rows in the "Print Scrn" screen capture:



Putting a space here to show the different images, but if now space is put, it will look like a continuos image/spreadsheet (second one has not line break/space.


Here with the two images with no space between them.

Nice work!!!

Here's the screenshots from my Excel file.

Great job, BTB! I feel so inferior with my computer skills compared to most here!