I need help either finding or creating a pc program.
• The program needs to randomly choose a name, without repeats.
• Names should come from an easily editable database, such as a text doc with each name on an individual line or from an excel doc.
• Needs to be capable of creating a random array from a large set of names (at least 120).
• It will cycle through the current set of names until told to reset, or it reaches the end, at which point it will create a new random array.
• I need to be able to save the current array so that I can continue on from day to day.
This is mostly a program to assign certain daily tasks fairly (e.g. toolroom duty, projects, cutters/fitters, etc.). I've been having a horrible time looking something up online for this; most programs have no save options, and/or are limited to very small lists.
Any help would be much appreciated.
This sounds like a great VBA project.
This will be the forums greatest achievement. Teaching suineg to code.
This is what, like 10 lines in Python?
Calling me a Cunt is a lot like calling Hitler a Nazi, it's not exactly received as the insult you were intending.
Star Citizen referral code - [STAR-C3G4-2XMJ]
Any chance anyone has worked on this over the past couple nights?
Still in planning phase. Waiting for HR to create user stories so time can be billed properly.
I am SCRUMing it right now.
No for real I was coming to post that I am starting to play with it now.
What would make it like 10 lines of code is if you just had it be a random number generator that just spit out a bunch of numbers and you just looked at the spreadsheet and assigned that name to that number from the row it is in.
I will try a couple different things though.
oderint dum metuant
The construct you're describing, a collection of one piece of data pointing to another piece of data, is called a dictionary or map in most languages.
You should do this with VBA in Excel Suineg just so it's got an approachable interface he can use day to day. In fact, you can do this using just formulas and sorting but that's not as fun.
There are currently 1 users browsing this thread. (0 members and 1 guests)