Programme Spreadsheet - Version 1.3 Out Now (June 2011) |
View previous topic :: View next topic |
Author |
Message |
Senior82
Joined: 25 Nov 2008 Posts: 982 Location: Near Sheffield
|
|
Back to top |
|
|
Tigerhawk
Joined: 22 Nov 2008 Posts: 129 Location: Waterlooville
|
Posted: Wed Jul 22, 2009 12:36 pm
Post subject: |
|
|
yes same here |
|
Back to top |
|
|
Geddon
Joined: 20 Nov 2008 Posts: 1044 Location: Bristol
|
Posted: Wed Jul 22, 2009 2:28 pm
Post subject: |
|
|
Firstly - some good news, I've made an Excel 2003 compatible version. The bad news is, some of the features won't work properly. Sorting can only take three values in Excel 2003, so I'm not sure how well that's going to work, and some of the conditional formatting won't work properly either.
However it will do the basic things right, and if you guys could give me some feedback on things that don't work properly that'd be great.
Download link is in the original post.
Barrett - I had considered using check boxes, just felt that it was easier to use the . and , because it saves having to use the mouse, and it's easier to transfer that to information on other sheets as well.
Last edited by Geddon on Wed Jul 22, 2009 3:07 pm; edited 1 time in total |
|
Back to top |
|
|
Tigerhawk
Joined: 22 Nov 2008 Posts: 129 Location: Waterlooville
|
Posted: Wed Jul 22, 2009 3:00 pm
Post subject: |
|
|
Thanks for that Geddon
using the "." or "," in the away section doesn't colour, also in the away section if you enter the "." for not got it comes out on the panel as got and vice versa for the ",".
Any chance of an FA trophy section especially as league teams could now take part in this if they spend a season or two in the conference. |
|
Back to top |
|
|
Tigerhawk
Joined: 22 Nov 2008 Posts: 129 Location: Waterlooville
|
Posted: Wed Jul 22, 2009 3:17 pm
Post subject: |
|
|
not turns up as green and got turns orange in home column no colour in away section, in the section where it lists the league teams for the season the home team name is imported but not the away and finally in the totals page at the beginning not got has imported into the got column
Finally finally how do you save the document on your own computer I can't see any option for this after downloading the document. |
|
Back to top |
|
|
Tigerhawk
Joined: 22 Nov 2008 Posts: 129 Location: Waterlooville
|
|
Back to top |
|
|
Geddon
Joined: 20 Nov 2008 Posts: 1044 Location: Bristol
|
Posted: Wed Jul 22, 2009 5:15 pm
Post subject: |
|
|
Yes I'd noticed that it doesn't colour, Excel 2003 only supports limited conditional formatting, will have to take a look at that for the next version.
. is for got, and , is for not got - I made a mistake on the 2009/10 page, but that's the way round they should be.
FA Trophy is something that could be added to the next version, cheers.
I'm not sure what you mean by the league teams not showing the away team, do you mean that the away columns are not colouring in correctly or something else?
Thanks for the feedback though, knew it'd a be a little raw, was hoping it'd be a little better than it is though! |
|
Back to top |
|
|
Tigerhawk
Joined: 22 Nov 2008 Posts: 129 Location: Waterlooville
|
Posted: Wed Jul 22, 2009 5:28 pm
Post subject: |
|
|
when you enter the teams on the seasons page it then transfers them to the seasons on page O but it doesn't the away teams not from the 09/10 season anyway
thanks for doing this by the way |
|
Back to top |
|
|
Geddon
Joined: 20 Nov 2008 Posts: 1044 Location: Bristol
|
Posted: Wed Jul 22, 2009 5:37 pm
Post subject: |
|
|
Oh, I see what you mean now. I had it programmed so that it only adds the teams if they're in the home section - basically it assumes that if you played that team at home in the league in a certain season then you played them away as well, so there was no need to add them on both sides. Does anyone think that it's worth changing that? I don't know of any leagues where you play different teams home and away?
Tigerhawk wrote: |
thanks for doing this by the way |
No problem, it's just grown out of the one I made for myself basically. |
|
Back to top |
|
|
Steveboy
Joined: 11 Dec 2008 Posts: 134 Location: Cardiff
|
Posted: Fri Jul 31, 2009 10:41 am
Post subject: |
|
|
Hi Geddon
Just downloaded your superb spreadsheet, but when I enable the macro I get the following message
'Unable to see the visibility of worksheet class'
I am using office 2007
Steveboy |
|
Back to top |
|
|
craig Site Admin
Joined: 22 Nov 2014 Posts: 1349
|
Posted: Fri Jul 31, 2009 9:59 pm
Post subject: |
|
|
Geddon,
Why do you use 3 columns to input the date? I never set up the original version (1.0) but i did put all my data into a copy of your original file but i cant seem to import it. Did i read somewhere you said i should be able to?
Help please!!
Craig |
|
Back to top |
|
|
YCFC1922
Joined: 22 Nov 2008 Posts: 70 Location: York
|
Posted: Sat Aug 01, 2009 12:21 pm
Post subject: |
|
|
Is there a way of inputting reserves too _________________ WANTED - YORK BADGES - please PM with details |
|
Back to top |
|
|
Geddon
Joined: 20 Nov 2008 Posts: 1044 Location: Bristol
|
Posted: Wed Aug 05, 2009 4:37 pm
Post subject: |
|
|
Sorry guys, only just seen your comments.
Steve - I don't know why it's doing that, but you should just be able to click "end" and it won't affect anything else.
Craig - Not sure really mate, I did it originally because it looks a little tidier. You should be able to import the data yes, if you use the importer on the home tab. Make sure that the only spreadsheet you have open is the one you want to import into though, might not work otherwise, and probably best to make a backup as well, the code isn't great!!
YCFC - Not at the moment, but you could just use two different spreadsheets. |
|
Back to top |
|
|
craig Site Admin
Joined: 22 Nov 2014 Posts: 1349
|
Posted: Wed Aug 05, 2009 4:45 pm
Post subject: |
|
|
I cant seem to get it to work but i may be doing something wrong as i dont really use Excel much. Any chance i can send you my original file next time your around on MSN please. |
|
Back to top |
|
|
Steveboy
Joined: 11 Dec 2008 Posts: 134 Location: Cardiff
|
Posted: Fri Aug 07, 2009 11:55 am
Post subject: |
|
|
Hi All
Been playing with this spreadsheet now for two days input all my programme collection, but the excel programme has crashed at least four times. Im using excel 2007 genuine product, has anbody else encountered this ??????
It's a superb spreadsheet but not working as it should.
Geddon any ideas when the next version will be available????? |
|
Back to top |
|
|
craig Site Admin
Joined: 22 Nov 2014 Posts: 1349
|
Posted: Mon Aug 10, 2009 11:14 am
Post subject: |
|
|
Cheers mate
Look forward to it |
|
Back to top |
|
|
Geddon
Joined: 20 Nov 2008 Posts: 1044 Location: Bristol
|
Posted: Mon Aug 10, 2009 11:43 am
Post subject: |
|
|
Steve, I'm not sure what's causing that to be honest, I've never had a problem with it. What error message (if any) are you getting when it crashes? I am working on a new version, but it'll be a while before it's released because I'm going to attempt to fix the 2003 version as well.
Craig, I'm doing yours at the moment, should have it back with you later in the day. |
|
Back to top |
|
|
KavJack
Joined: 21 Nov 2008 Posts: 49 Location: Long Beach, California
|
Posted: Tue Aug 11, 2009 8:53 pm
Post subject: Keeping track of one's collection |
|
|
I use Microsoft Access to keep track of my collection. I can perform SQL queries against my collection. I can also correlate it to the my Access databases for the FA Cup, FA Trophy, and FA Vase databases. I also have Access databases for all NPL games, Football League (incl. Premiership), Conference (including GOLA and APL) and rounds proper for the FA Amateur Cup. These can all be subjected to SQL queries which match each other.
In many cases there are a few programmes offered on E*Bay where the seller doesn't know which season or the exact nature of the game played. In most cases I can tell him much about his programme. |
|
Back to top |
|
|
CarlisleUtdMem
Joined: 20 Apr 2009 Posts: 359
|
Posted: Wed Aug 12, 2009 8:28 pm
Post subject: Re: Keeping track of one's collection |
|
|
KavJack wrote: |
I use Microsoft Access to keep track of my collection. I can perform SQL queries against my collection. |
Don't suppose you'd be willing to share this would you? _________________ Regards,
Adam |
|
Back to top |
|
|
KavJack
Joined: 21 Nov 2008 Posts: 49 Location: Long Beach, California
|
Posted: Wed Aug 12, 2009 9:39 pm
Post subject: Keeping track of one's collection |
|
|
Sure, I don't mind. It's quite a big task though.
My Access design view is as follows:
GIDX: Index value
Home Team: Text
Away Team: Text
Venue
Competition
Date Played
Season
Cover Price
Volume
Number
Quantity
Pages
Condition
Style
Size
Date Acquired
Price Paid
Current Price
Source (of acquisition)
E*Bay (yes or no)
E*Bay_Name
Score
My Collection Volume
Neutral Venue
Spare_4 - often used a s a pointer to image of programme
Spare_5
Spare_6 - often contains actual E*Bay number for auction when won item
Note
I have written many queries - too many to list. For example
..Leeds in Inter-City Fairs.. enquiry
SELECT [Programme Collection].[Home Team], [Programme Collection].[Away Team], [Programme Collection].Venue, [Programme Collection].[Competition], [Programme Collection].[Date Played], [Programme Collection].Season, [Programme Collection].Score, [Programme Collection].[Cover Price], [Programme Collection].[Date Acquired], [Programme Collection].Source
FROM [Programme Collection]
WHERE (
((InStr([Programme Collection].[Competition],"Inter-City"))>0
OR
(InStr([Programme Collection].[Competition],"U.E.F.A"))>0)
AND
(((InStr([Programme Collection].[Home Team],"Leeds"))>0)
OR
((InStr([Programme Collection].[Away Team],"Leeds"))>0))
)
ORDER BY [Programme Collection].[Date Played];
Contact me at [email protected] if you want to go into this in greater detail. |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|
|
|
|
grantham, 16 hours, 34 minutes ago
Enniskillendoc, 18 hours, 19 minutes ago
James, 18 hours, 53 minutes ago
Raxfactor, 19 hours, 23 minutes ago
Raxfactor, 19 hours, 28 minutes ago
ndg1860, 19 hours, 37 minutes ago
colchestersid, 20 hours ago
Raxfactor, 20 hours, 47 minutes ago
Pete’s Picture Palace, 1 day, 11 hours ago
Martin1963, 1 day, 15 hours ago
ndg1860, 1 day, 16 hours ago
PhilWBA, 1 day, 17 hours ago
Flaming Pie, 1 day, 19 hours ago
slightfold, 1 day, 19 hours ago
CAFC 1947, 2 days, 1 hour ago
Flaming Pie, 2 days, 1 hour ago
CAFC 1947, 2 days, 2 hours ago
DerbyCounter, 2 days, 3 hours ago
Dorking, 3 days, 22 hours ago
Dorking, 4 days ago
colchestersid, 4 days, 3 hours ago
Raxfactor, 4 days, 21 hours ago
Cpfc jim, 4 days, 22 hours ago
Raxfactor, 4 days, 22 hours ago
Cpfc jim, 4 days, 22 hours ago
grantham, 6 days, 15 hours ago
Pablo2019, 6 days, 16 hours ago
Dorking, 6 days, 21 hours ago
grantham, 1 week ago
seandel1, 1 week ago
Thedoog10, 1 week ago
colchestersid, 1 week ago
kenners46, 1 week ago
Thedoog10, 1 week ago
colchestersid, 1 week, 1 day ago
Spireitenag1955, 1 week, 1 day ago
siddy, 1 week, 1 day ago
DerbyCounter, 1 week, 2 days ago
grantham, 1 week, 2 days ago
pafcprogs, 1 week, 2 days ago
pafcprogs, 1 week, 2 days ago
Flaming Pie, 1 week, 2 days ago
Cpfc jim, 1 week, 2 days ago
FootballShirts24, 1 week, 3 days ago
gatfb, 1 week, 3 days ago
Cpfc jim, 1 week, 3 days ago
grantham, 1 week, 4 days ago
PaulRStoke, 1 week, 5 days ago
manchesterunitedman1, 1 week, 5 days ago
manchesterunitedman1, 1 week, 5 days ago |
|
11,648
Members
10,148
Members Wants
39
Members Mini-Stores
4,227
Members Items for Sale
|
|
|