Spreadsheet to help with recruiting

[France72086]

Quote: Originally Posted by srudoff

i used it to keep past results but it also gives me a clue into how hard other teams are recruiting them. for instance if i get 300 points in one week and my lag increases to 400, i know the top team is going hard after them. conversely if i mail it in and spend 20 minutes and get 150 points and my lag goes down or stays the same, it tells me that other teams aren't spending that many minutes with them either. it also lets me make an educated guess on a recruit's value of a certain subject if i do a blind pitch. if it comes back high i know he rates it high and have a snapshot of that without using minutes to ask him.

Got it, that's pretty much what i figured, but I was wondering if you had any additional tricks or tips. Thanks again for the template, I will definitely be using this.

[srudoff]

bumping this in case anyone else wants to give it a try - perhaps a couple of you fellow excel nerds can make some additions or suggestions

[Mack Attack 11]

Quote: Originally Posted by srudoff

perhaps a couple of you fellow excel nerds can make some additions or suggestions

Yes I made some changes. Unfortunately I work with excel everyday. I am still testing it so I might have more changes. But I think it will boil down to personal preference. I just made it flow better and easier to read from my point of view. You may think my changes are not needed.

[gamemaster-2005]

tagged at work right now.

[MacCLovin]

Quote: Originally Posted by Mack Attack 11

Yes I made some changes. Unfortunately I work with excel everyday. I am still testing it so I might have more changes. But I think it will boil down to personal preference. I just made it flow better and easier to read from my point of view. You may think my changes are not needed.

Can I see your changes?? I love the initial idea though...

[Mack Attack 11]

Quote: Originally Posted by MacCLovin

Can I see your changes?? I love the initial idea though...

Let me get through a few more weeks of recruiting. I dont have much data yet to see what I want to do. But you have an excellent sheet to begin with.

[srudoff]

Quote: Originally Posted by Mack Attack 11

Let me get through a few more weeks of recruiting. I dont have much data yet to see what I want to do. But you have an excellent sheet to begin with.

any updates you'd like to share?

[MyWifeH8sFtball]

^^Same here, anything you have changed or come up with would be appreciated.