|
im
Original Poster
27,973 posts
86 months
|
Jw Vw said: im said: Jw Vw said: im, would it be possible for you to send me the spreadsheets you use when you have a chance? No problem, PM me your e-mail address. PM sent. Cheers im. Speeadsheet s at home, I'll do it later tonight when I get in from work. Any particular reason? Thinking of taking it on perhaps?
|
|
|
Jw Vw
4,044 posts
32 months
|
im said: Jw Vw said: im said: Jw Vw said: im, would it be possible for you to send me the spreadsheets you use when you have a chance? No problem, PM me your e-mail address. PM sent. Cheers im. Speeadsheet s at home, I'll do it later tonight when I get in from work. Any particular reason? Thinking of taking it on perhaps?  Thinking of taking it on , not weekly but as a share with a few others if possible. Thanks for sending.
|
|
|
BrabusMog
4,954 posts
55 months
|
im said: Speeadsheet s at home, I'll do it later tonight when I get in from work.
Any particular reason? Thinking of taking it on perhaps? Could you flick it on to me too, please? I'd like to see what I'm getting myself in for before agreeing to doing a stint!
|
|
|
Jw Vw
4,044 posts
32 months
|
BrabusMog said: im said: Speeadsheet s at home, I'll do it later tonight when I get in from work.
Any particular reason? Thinking of taking it on perhaps? Could you flick it on to me too, please? I'd like to see what I'm getting myself in for before agreeing to doing a stint! Same thoughts as me Brabus!
|
|
|
im
Original Poster
27,973 posts
86 months
|
BrabusMog said: im said: Speeadsheet s at home, I'll do it later tonight when I get in from work.
Any particular reason? Thinking of taking it on perhaps? Could you flick it on to me too, please? I'd like to see what I'm getting myself in for before agreeing to doing a stint! PM your e-mail address as well BM
|
Advertisement
|
|
|
oxford drinker
920 posts
98 months
|
can you send them to mee too, Im, thanks. Will have a look to see of i understand, if I do I'm happy to give this a go!
|
|
|
Black can man
10,977 posts
37 months
|
Please im do not send them to me , great to see there are lots of interested parties to carry on the good work
|
|
|
im
Original Poster
27,973 posts
86 months
|
Black can man said: Please im do not send them to me 
|
|
|
im
Original Poster
27,973 posts
86 months
|
Only just got in chaps and am starving and shattered. Will send the Spreadsheet in the morning...wife giving me jip 
|
|
|
im
Original Poster
27,973 posts
86 months
|
Jw Vw, Oxford Drinker, BrabusMogYou all have mail and a small project for next season 
|
|
|
oxford drinker
920 posts
98 months
|
Cheers, first impressions are  Still happy to give this a go, though, but might have to develop my own (simpler)spreadsheet 
|
|
|
im
Original Poster
27,973 posts
86 months
|
oxford drinker said: Cheers, first impressions are oxford drinker said: Still happy to give this a go, though, but might have to develop my own (simpler)spreadsheet I'm an Accountant - trust me, thats a very simple spreadsheet.  Seriously though....simpler means you'll have to spend more time actually doing it all manually which with 34 contestants (last years starting point) is a lot of data entry and cross-checking for errors in peoples points earned at each matchday (and of course cummulatively) and that their league position is correct etc etc etc. You will need to automate as much as possible or you'll be working on the spreadsheet for hours each weekend. You'll also have to be able to go back and change it all a few weeks later when some smart-arse realises that you mis-calculated his points for 3 matchdays back and he was due 5 points and not 4 UNLESS you've automated it so that manual errors are not really possible. The fixtures tab can be completed in one go for the season ahead by cut 'n' pasting the whole seasons fixtures from the BBC's fixtures website once the FA publish them. This'll help you make sure that all 380 games are forecast in the season. Try and do it manually and you're sure to miss some fixture on a wet Tuesday in deep winter. You should try to always be one-step ahead of the game where the fixtures are concerned and that tab helps. On the Results tab you simply copy the Matchday fixtures from the fixtures tab into the cells with the Yellow fill colour and then key in the actual results also into the yellow cells next to the fixtures. Once you keyed in everyones forecasts (do this as they post them to save time and tell you who hasn't forecast yet) then the spreadsheet calculates everyones points earned. Then follow the instructions on the League tab in cells B33 to B34 and M34 to M52. Actually...I could post bloody pages on this ...if you want to develop your own then that might be the best way forward - just cull what you need from mine (if anything). Otherwise ring me and I can talk you through it. Good luck guys
|
|
|
oxford drinker
920 posts
98 months
|
im said: I'm an Accountant - trust me, thats a very simple spreadsheet. I'm an Architect - trust me, that's a  complicated spreadsheet.
|
|
|
jammy_basturd
8,168 posts
81 months
|
Go then im, send it over. PM sent!
|
|
|
im
Original Poster
27,973 posts
86 months
|
jammy_basturd said: Go then im, send it over. PM sent! I was wondering when our resident expert was gonna throw his hat into the ring 'bout time Jammy.... You Have Mail.
|
|
|
jammy_basturd
8,168 posts
81 months
|
Feck me! I have a new found respect for you im* after seeing that you've been doing pretty much all of this manually - no vba code at all!
You are still Spurs fan, so that still isn't a lot :P
|
|
|
im
Original Poster
27,973 posts
86 months
|
jammy_basturd said: Feck me! I have a new found respect for you im* after seeing that you've been doing pretty much all of this manually - no vba code at all! Its was all about inputting in a predetermined order. Then you can use Excels functionality to do a lot of it (Data Sorting, VLOOKUP, Cell Referencing etc etc). The formulas are already inserted to calculate Matchday points. Now if you can come up with some super-duper coding that creates a nice looking league table by taking a pre-existing table and adding that Matchdays points then its pretty much job done. Thats the manual bit that was a pain.
|
|
|
oxford drinker
920 posts
98 months
|
My lunchtime has been well spent today learning about Excel!
|
|
|
im
Original Poster
27,973 posts
86 months
|
oxford drinker said: My lunchtime has been well spent today learning about Excel! Good luck with that  Whilst MOUS certified 13 years ago and with a basic knowledge of VBA its not something that is a pre-requisite for Accountancy so its become a faded memory. Recording Macros (VBA on autopilot) is as far as I go.
|
|
|
oxford drinker
920 posts
98 months
|
im said: Whilst MOUS certified 13 years ago and with a basic knowledge of VBA its not something that is a pre-requisite for Accountancy so its become a faded memory. Recording Macros (VBA on autopilot) is as far as I go. No, you've lost me there.....
|
|
