Conference trucks::football;1

    
    	Excellent idea, Gary. What did you mean by "pointers"? Do you
    	mean "how to do it" or where to get the results or what?
    
    	Check out the conference directory. There is already a note that
    	I think Al Roberstson updates that carries results, points, latest
    	league table etc.
    
    	Don't want you wasting your time developing something that already
    	exists....
    
    	Andy.
             

    Andy,
    
    
    By pointers I mean has anyone got a spreadsheet that I can have a 
    copy of. 
    
    I want to use it for a local boys team that I run, so it won't be 
    a problem getting the results, its just working out how to do it 
    on excel. 
    
    Thanks Gary

    
    Hi,
    	I have a BASIC program that I used last year to enter the Scottish
    Premier Division in note 14. The reason that I'm not doing it this year
    though is because I missed the first couple of weeks when I was on
    holiday. It's better if you can start at the beginning of the campaign.
    It did, however, update the league table from results entered, so it
    did all the work for you, and could also produce the Form Guide that is
    shown at the bottom of the table.
    	If it's of interest, just let me know.
    
    Archie
    

    
    I have a BASIC program which can do this BUT if you have MS Access
    it'll allow you more flexibility in your design and resultant output
    and NOT that difficult to program.
    
    However Excel V5.0 would be ideal as it has Combo Boxes which would
    reduce the amount of work to be done once the design of the sheet has
    been completed.
    
    Dezzz.
    
    

I've got a simple command procedure, designed for a league with 10 teams.
It reads the current standing from a .dat file. Then you have to enter the
results and it creates actual .txt file with results und standings, and an
updated .dat file.

It's not very confortable, the user interface is poor (no correction
possibility,...) if you enter a mistake you have to delete the created
(wrong) files and try it again...

...but anyway feel free to copy and use (part of) it...

   copy CRASHY::DISK$USER2:[000000.PUBLIC.RANK]*.*   (48.330)

andre

----------------------
output:
$type RANG_AKT.TXT

        *** Results, 1. Round ***
        ==========================

        UHC Rot Weiss Chur  -  HC Rychenberg            1 :  1
        UHC GIANTS KLOTEN   -  SV Wiler                 5 :  2
        UHU Bern            -  Torpedo Chur             6 :  3
        Torpedo Gauchern    -  Alligator Malans         3 :  3
        UHC Uznach          -  UHT Z�ziwil              8 :  1

        *** Standing after 1. Round ***
        ================================

            Team                Games      Score      Diff          Points

         1. UHC Uznach            1       8 -   1     +  7            2
         2. UHU Bern              1       6 -   3     +  3            2
         3. UHC GIANTS KLOTEN     1       5 -   2     +  3            2
        ------------------------------------------------------------------
         4. Torpedo Gauchern      1       3 -   3     +  0            1
         5. Alligator Malans      1       3 -   3     +  0            1
         6. UHC Rot Weiss Chur    1       1 -   1     +  0            1
         7. HC Rychenberg         1       1 -   1     +  0            1
         8. Torpedo Chur          1       3 -   6     -  3            0
        ------------------------------------------------------------------
         9. SV Wiler              1       2 -   5     -  3            0
        10. UHT Z�ziwil           1       1 -   8     -  7            0

    
    Gary ,
    
    Monday's Sun contains a parallellogram/spreadsheet with all past
    results and future fixtures . It may give you a pointer . All you have
    to then is calculate the.......add the.....write a flow chart ...then
    onto Basic.......then hand over responsibility to Chris McDonald and
    then you should be there.
    
    Peter Unite. 

Gary,

I started working on a spreadsheet to calculate the standings of my proper 
football aswell my basketballteam. The footballclub I'm playing for (which is in 
fact a British footballclub) consists of 6 teams and as I'm playing for two of 
them I've three different standings to produce. The only logic problem I'm facing 
is that I'm trying to create a template useable for all. This template is set up 
for 14 teams. Now the problem is that the schedule for one league is not the same 
as for the other league. But besides this, when my spreadsheet comes out of 
beta-testing and you're interested give me a sign.


Paddy

    Many thanks for all your inputs, If I make any progress I will 
    keep you posted.
    
    
    Gary 
    
    
    PS Don, I will ensure that you work a 25 hour day during the move 
    ;-).