Panarchy Posted February 11, 2007 Report Share Posted February 11, 2007 ______________________________________________NEW EXCEL!Okay, I need help again.How do I simulate a game of snakes and ladders on Excel? Quote Link to comment Share on other sites More sharing options...
Irene Posted February 11, 2007 Report Share Posted February 11, 2007 NEW EXCEL!How do I simulate a game of snakes and ladders on Excel?Is this homework from school Panarchy? Quote Link to comment Share on other sites More sharing options...
-pops- Posted February 11, 2007 Report Share Posted February 11, 2007 Unless it is for a school project or something similar, I don't see the point of the request - there are numerous hits on Gooooogle for it.If it is for a school project, asking here is a cop out :) Quote Link to comment Share on other sites More sharing options...
Irene Posted February 11, 2007 Report Share Posted February 11, 2007 Unless it is for a school project or something similar, I don't see the point of the request - there are numerous hits on Gooooogle for it.If it is for a school project, asking here is a cop out :)I was just thinking that if it was school work, then schools are definitely not what they used to be! :D Quote Link to comment Share on other sites More sharing options...
-pops- Posted February 11, 2007 Report Share Posted February 11, 2007 The abacus was a new invention when I was at school. :D Quote Link to comment Share on other sites More sharing options...
Irene Posted February 11, 2007 Report Share Posted February 11, 2007 The abacus was a new invention when I was at school. :DDidn't realise that you're so much younger than me!! :lol: :lol: :lol: Quote Link to comment Share on other sites More sharing options...
andsome Posted February 11, 2007 Report Share Posted February 11, 2007 The abacus was a new invention when I was at school. :DDidn't think it was that long ago when it was invented. :lol: Quote Link to comment Share on other sites More sharing options...
Panarchy Posted February 12, 2007 Author Report Share Posted February 12, 2007 It is kinda homework.I want to know the formula's for this so I can do extension by simulating Monopoly.That will be my real project.Please help,Panarchy Quote Link to comment Share on other sites More sharing options...
doug Posted February 12, 2007 Report Share Posted February 12, 2007 This is some interesting School that you are attending! Quote Link to comment Share on other sites More sharing options...
Panarchy Posted February 12, 2007 Author Report Share Posted February 12, 2007 Um... thanks?Anyway, back on topic, please HELP! Quote Link to comment Share on other sites More sharing options...
AlanHo Posted February 12, 2007 Report Share Posted February 12, 2007 There is an example on This Page which uses Excel macros.Perhaps you can analyse this for ideas. Quote Link to comment Share on other sites More sharing options...
Panarchy Posted February 12, 2007 Author Report Share Posted February 12, 2007 Thanks I will try that now. Quote Link to comment Share on other sites More sharing options...
AlanHo Posted February 12, 2007 Report Share Posted February 12, 2007 Why not take a look at This Forum Quote Link to comment Share on other sites More sharing options...
Panarchy Posted February 12, 2007 Author Report Share Posted February 12, 2007 I need to know the formula on how to make the snakes and ladders macro game. Quote Link to comment Share on other sites More sharing options...
AlanHo Posted February 12, 2007 Report Share Posted February 12, 2007 Can you not open up the macros as if to edit them and examine the structure ?. I am no expert at Excel so cannot help further. Quote Link to comment Share on other sites More sharing options...
doug Posted February 12, 2007 Report Share Posted February 12, 2007 Here's some suggestions, mind it's been years since I was playing Snakes and Ladders and also playing about with macro's. But I've had your problem on my mind all day. It should be a very stimulating exercise for you, These are only suggestions and other people are bound to either correct me or make suggestions for improvements or corrections. I storngly suggest that you build the whole thing up in several small blocks. then you can combine them in stages. This will be my suggestion for a single player - leave it to you to convert it to a multiplayer game.First draw up an overall Flow diagram, Each stage to be as small blocks - such as:-Draw up 2 tables, e.g. ladder test and snake test. In each table decide the start and finish positions.starting at position 1 - beginning. Call this counter position. Throw dice - you've done that now. Add the number to your position, counter positionNow comes the interesting parts - conditional statements IF( ), look up the syntax via the help function.If the number = any number in ladder table then i.e. =true the take the new number in table, else keep your original number.If the number = any number in snake table i.e.= true then take new number in table else keep new number.If number > finish number go back to counter position.If number = end number go to Win routine.If number < end number go to throw dice again.Not very efficient but provided you concentrate on getting the flow diagram sorted then it should be relatively straight forward.Hope I haven't done too much of your homework for you though but this procedure should work out - I hope. Do test each block thoroughly though. Quote Link to comment Share on other sites More sharing options...
doug Posted February 12, 2007 Report Share Posted February 12, 2007 Forgot to add a most important set of conditions:-Always check to see if the counter position is valid i.e. no negative number or that it is greater than the max number on the board + 6.Also do build in a break out or stop test. You don't want to get into an endless loop.I did that when I was learning programming ( Fortran 2) and our night school was using the County Council Computer (an ICL 1900 type) during night school. No monitors in those days just punched cards. Anyway my program went into an endless loop - it had bypassed my traps and also the built in traps. It spewed out a whole box of Line Printer paper at a great rate of knots. Frightened the life out of me. Visions of Council Payrolls and Council Tax demands in error gave me a bit of a nightmare that night.Have fun. Quote Link to comment Share on other sites More sharing options...
Panarchy Posted February 12, 2007 Author Report Share Posted February 12, 2007 Thanks!I'm anti tax by the way! :P Quote Link to comment Share on other sites More sharing options...
Irene Posted February 12, 2007 Report Share Posted February 12, 2007 How old are you Panarchy?No indication on your profile. Quote Link to comment Share on other sites More sharing options...
Panarchy Posted February 13, 2007 Author Report Share Posted February 13, 2007 Please respect my anonymity!I'll tell you this much though, I am between the age of 15 and 21. Quote Link to comment Share on other sites More sharing options...
andsome Posted February 13, 2007 Report Share Posted February 13, 2007 Please respect my anonymity!I'll tell you this much though, I am between the age of 15 and 21.A mere child. :D Quote Link to comment Share on other sites More sharing options...
Panarchy Posted February 13, 2007 Author Report Share Posted February 13, 2007 :lol:YAY 200 posts now!I saw a post that you guys where making before, and at that time I knew then the age you guys would be.Over 70's club, right?:P:D Quote Link to comment Share on other sites More sharing options...
Irene Posted February 13, 2007 Report Share Posted February 13, 2007 I saw a post that you guys where making before, and at that time I knew then the age you guys would be.Over 70's club, right?Wrong! Some of us are under 70. B) The common factor which we have is experience, which comes with age. :D i.e. Why have you reached 200 posts on this forum? .... In search of experience. :lol: Quote Link to comment Share on other sites More sharing options...
Panarchy Posted February 13, 2007 Author Report Share Posted February 13, 2007 Well in between 60 and 70 then! :D Quote Link to comment Share on other sites More sharing options...
doug Posted February 13, 2007 Report Share Posted February 13, 2007 Get on with your homework! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.