This table is a frequency of numbers 1 to 49
1. Find the mean value in tan table . Not the average . We are looking for the most frequent number appearing.
2. The fist target is find the mean value of the frequency for each number 1 to 49 according to the tan table !
Table : Number tang , explain
This is a table of the same number where off number1 is the spot the number was drawn .
The target is to adjust this table according the mean value in the frequency ascending downward .this means the for example the mean frequency is 15 the row it will go 14 numbers down .
I have color marked the last 5 draw numbers and adjusted the table accordingly manually ( maybe not correct ) it is possible that according to the new draw numbers Finally the table need to fine tuned ,that means one or two pos up or down to match the last numbers . ( Results from last drawing )
The cos table: This is a reference chart from my old program . This is for ref. only
The steg table: This is the number position of the draws numbers .
The new table for cos : This is the result of your work what is coming out from the number tang table. After we move all the Rows for the correct position you need to transfer the new frequeny to the cos table.
Finally we are looking for a correlation of the two table in order get the next possible drawing number in the steg table .
Please let me know if you can do some code work for this . no one has done it before . it is simple excel work no rocket science
[login to view URL] the mean value in tan table
2. Adjust by copy or by code the tan number table for the mean value in the frequency in position down
3. Find the new frequency and transfer into cos table.
4. Find the correlation of the new cos table and the tan table .
126 freelancers are bidding on average $24 for this job
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.
Hi there, Gone through your requirements. Will do this task in a day. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Looking forward your message for the discussion. Regards, Karthick G.
Hi I have read your job description and interested to deal with you, I have expertise in all of these fields. Quality is assured. -“Waiting on your response.” Kind Regards, Batairy
With over 30 years of experience and extensive knowledge of Visual Basic Excel and Data Architecture, I am the person you need to meet your goal. I await your contact. Best regards
I have a strong technical skills in c++,Excel VBA,VBScript,VB.NET . Your requirement sharing and my programming skills help us to finish the project successfully