Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 390
Default Randomly Generate Specific Data

FB1
FB2
FB3 00 01 02 03 04 05
FB4 0
C1 1
C2 2
C3 3
C4 4
PO 5
PO1
PO2
PO3
CU1
CU2
CU3
CU4
I have created a random generator to place the data on the left into the
chart above. I would like to add a percentage stop, ie: CU4 is only 7% of
the data in the chart.
I would then like to create another grid that places the row and column
numbers associated with the data. ie: if if 022 is FB1, I would like FB! to
be placed in another chart that shows how many of each data point has been
placed.

Help?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,358
Default Randomly Generate Specific Data

You started getting questions in your other post. This layout is not any
clearer. What is 022, how do we know CU4 is only 7% what does FB1-4 C1-4
PO1-3 and CU1-4 represent? How are the numbers to the right come up with?
What are you trying to accomplish.
And, oh yeah, please do not multipost :)
--
** John C **

"Bill" wrote:

FB1
FB2
FB3 00 01 02 03 04 05
FB4 0
C1 1
C2 2
C3 3
C4 4
PO 5
PO1
PO2
PO3
CU1
CU2
CU3
CU4
I have created a random generator to place the data on the left into the
chart above. I would like to add a percentage stop, ie: CU4 is only 7% of
the data in the chart.
I would then like to create another grid that places the row and column
numbers associated with the data. ie: if if 022 is FB1, I would like FB! to
be placed in another chart that shows how many of each data point has been
placed.

Help?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 390
Default Randomly Generate Specific Data

The percentages are created by me. 022 is the column / row that the data
point appears in. The data set on the far left is text that I am randomly
assigning into the block and do not want more than certain percentages of
each data point

"John C" wrote:

You started getting questions in your other post. This layout is not any
clearer. What is 022, how do we know CU4 is only 7% what does FB1-4 C1-4
PO1-3 and CU1-4 represent? How are the numbers to the right come up with?
What are you trying to accomplish.
And, oh yeah, please do not multipost :)
--
** John C **

"Bill" wrote:

FB1
FB2
FB3 00 01 02 03 04 05
FB4 0
C1 1
C2 2
C3 3
C4 4
PO 5
PO1
PO2
PO3
CU1
CU2
CU3
CU4
I have created a random generator to place the data on the left into the
chart above. I would like to add a percentage stop, ie: CU4 is only 7% of
the data in the chart.
I would then like to create another grid that places the row and column
numbers associated with the data. ie: if if 022 is FB1, I would like FB! to
be placed in another chart that shows how many of each data point has been
placed.

Help?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
generate randomly assigned lists jt mwc New Users to Excel 6 August 8th 07 07:19 PM
Use Excel to randomly generate selections for cyle counting? Brad Dean Excel Worksheet Functions 2 November 3rd 06 06:35 PM
Generate column of 1's and 0's randomly Ian Engelbrecht Excel Discussion (Misc queries) 6 April 1st 06 02:52 PM
How to generate a list of randomly selected numbers within a range Bob Excel Worksheet Functions 2 November 7th 05 07:09 PM
How can I generate 10 sites randomly from a worksheet isankar Excel Discussion (Misc queries) 6 December 22nd 04 10:14 PM


All times are GMT +1. The time now is 06:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"