Program needed : random name select

Great Ogre Dictator

Great Ogre Dictator

Lord Nagafen Raider
196
262
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.
 
Vinen

Vinen

God is dead
2,793
497
Great Ogre Dictator_sl said:
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.
Click to expand...
Talk to a_skeleton_03. This would be an EXCELLENT project for him to focus his dev work on. These are very simple requirements to meet.
 
Great Ogre Dictator

Great Ogre Dictator

Lord Nagafen Raider
196
262
a_skeleton_03_sl said:
I could be useful!
Click to expand...
It would be great if you could.
smile.png
 
Deathwing

Deathwing

<Bronze Donator>
17,206
8,201
Still in planning phase. Waiting for HR to create user stories so time can be billed properly.
 
A

a_skeleton_03

<Banned>
29,948
29,765
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.
 
Deathwing

Deathwing

<Bronze Donator>
17,206
8,201
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.
 
Palum

Palum

what Suineg set it to
29,215
48,948
You should do this with VBA in Excel a_skeleton_03 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.
 
You must log in or register to reply here.