Jump to content

  •  

Photo

Random Word Lists


  • Please log in to reply
3 replies to this topic

#1 welby  novice

welby
  • Members
  • 26 posts
  • FM Application:9 Advance
  • Time Online: 43m 16s

Posted 08 December 2011 - 06:28 AM

Hi all,

I have a 45 phrase/word list.

Out of that list I want to create 102 random sets of those phrases/words in a text file.

It's sole purpose is to then use that exported data file to create 102 5 x 3 Bingo/Buzzword tickets.

I have manged to create a single instance of this in Excel, but thought that FM would make a better job or so I thought.

Has anyone performed this before? If so please tell me how you achieved this.

Many thanks in advance.

Mark
  • 0

#2 LaRetta   Lifelong FM Student

LaRetta
  • Members
  • 9,512 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Cross Platform
  • Time Online: 166d 2h 45m 1s

Posted 08 December 2011 - 09:14 AM

Hi Mark,

I am not clear on the requirements. You have 45 records (?) with a field called Phrases which holds one word (?) or several words (?) and you want to select from random a mixture of those Phrases (in any order ?) until they make a string of how many words or Phrase groups? And then the result should be one text field holding a multiline of 102 of those random results (?) to export or should the result be records?

It can be done but it would help to see an example of your Phrases and how you wish the results. Also, are duplicate results allowed? Even random can produce duplicates naturally.
  • 0
Each assumption is an educated guess, a likely condition or event, presumed known and true in the absence of absolute certainty.

#3 comment  consultant

comment
  • Members
  • 23,499 posts
  • Time Online: 299d 9h 51m 12s

Posted 08 December 2011 - 09:17 AM

Each ticket contains 15 items from a list of 45? How often does the 45-items list change?

Also, are duplicate results allowed?


Yeah, that too (I seem to be a few seconds behind you today...).

Edited by comment, 08 December 2011 - 09:17 AM.

  • 0

#4 LaRetta   Lifelong FM Student

LaRetta
  • Members
  • 9,512 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Cross Platform
  • Time Online: 166d 2h 45m 1s

Posted 08 December 2011 - 09:22 AM

I like you in that position. Too bad it is meaningless, LOL. Ah, I see the 15 now after you spot it.
  • 0
Each assumption is an educated guess, a likely condition or event, presumed known and true in the absence of absolute certainty.




FMForum Advertisers