Making an Occurence Matrix

Frequency of event:

Within a given Monday - Sunday Week, an event happens only once for that week. Which day of the week, the event will happen, it's uncertain but it's certain that in that monday-sunday week, the event will happen only once.

The Event :

The event itself is an operation which pics up random samples from two sets of containers. 1st set consists of 35 containers numbered 1 to 35. Second set contains 20 containers numbered 1 to 20.

When the event occurs, 7 random samples are taken out of 35 containers of set 1 and 1 random sample is taken out of 20 containers of set 2. A sample can be taken from one container only.

For example after an event occurred, the Sample Set will look like

Set 1 Samples : 9, 23, 3, 30, 1, 17, 28 (i.e. 7 samples selected from 35 of Set 1 containers)

Set 2 Samples : 15 (i.e. 1 samples selected from 20 of Set 2 containers)

Such Sample is generated once every week, as per the frequency of the event.

The Project

The project is to create an occurrence table for both sets, which will tell after how many event triggers a sample has been selected.

For example, Let's say a sample number 12 in selected in Wk 3, Wk 7, Wk 14, Wk 20 triggers , the Occurance table should tell me 12 has occurred 4 (i.e. Wk 7 - Wk 3), 7 (i.e. Wk 14-Wk7), 6 (i.e. Wk20-Wk14)

For set 1, in the occurance table, the title row can be numbers from 1 to 35, left most column can be Occurance 1, Occurance 2 etc. The cells should be filled up as per the example given above.

A similar table should be created for Set 2 also.

There is no overlap between Set 1 & Set 2 at any stage. Please note that this is not about calculating the frequency of occurrence of a particular number. Frequency can be obtained by counting entries in the occurrence table, but that's not the main objective of the project.

Before bidding, please make sure you have understood the problem definition and are able to explain the problem in your own words. Feel free to ask me any deeper clarification if need be.

Квалификация: Ввод данных, Обработка данных, Excel Macros, Excel VBA, PHP

О работодателе:
( 0 отзыв(-а, -ов) ) Australia

ID проекта: #18547486

Поручен:

I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple o Больше

\$60 AUD за 1 день
(10 отзывов(-а))
3.2

8 фрилансеров(-а) в среднем готовы выполнить эту работу за \$30

pransore

Torenia Tech. [login to view URL] Hello Sir, I read through the job details extremely carefully and I am absolutely sure that I can do this project very well. As per your requirement, I would like to tell y Больше

\$30 AUD за 1 день
(19 отзывов(-а))
4.5
sonaphp247

Hello, Greetings, Top most Freelancer to work with and have great reviews too. We have read your project details and we are very much keen to work with you. We have the best developer and designer team having more than Больше

\$27 AUD за 1 день
(21 отзывов(-а))
3.9
techlinesols6

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Больше

\$21 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
\$25 AUD за 1 день
(0 отзывов(-а))
0.0
hosannagrace

Will work to the fullest of my knowledge and will do my best to exceed your expectations. Relevant Skills and Experience Excel literate

\$25 AUD за 1 день
(0 отзывов(-а))
0.0
mulloa88

Hello, I studied industrial engineering in the United States and this reminds me of previous homework assignments. Anyway, I'll rephrase your problem to make sure I understand it correctly: - Exactly 1 time ever Больше

\$30 AUD за 2 дней(-я)
(0 отзывов(-а))
0.0
sunnymagdum

QUALITY QUALITY QUALITY OF WORK , I WANT TO PROVE THE WORK DONE IT IS MY FIRST LOOK OF JOB TO PROVE IT

\$25 AUD за 2 дней(-я)
(0 отзывов(-а))
0.0