We have a series of values, which describe the "value" of 15 minutes in consecutive 15-min-intervalls, as follows:
from - to value
00:00h - 00:14h 5
00:15h - 00:29h 9
00:30h - 00:44h 11
00:45h - 00:59h 8
01:00h - 01:14h 3
01:15h - 01:29h 88
The value of 00:00h - 00:59h is 5+9+11+8=33
The value of 00:15h - 01:14h is 9+11+8+3=31
The value of 00:30h - 01:29h is 11+8+3+88=110
The task is to find the x most valuable hours (containing 4 consecutive 15-minute-values) of the entire series of data.
*Typically*, there are 48 values, representing 12 hours (see attached example) and we need to find the five most valuable hours (x=5).
*Note1*: The hour can start at *any* of the 15min-values, like one hour 03:15h - 04:14h or one hour 02:45h - 03:44h
*Note2*: The most valuable hours may contain every 15-min-value of the series only once (no double usage, no overlapping of the most valueable hours)
The table is in MS EXCEL. So formulas, a spread-sheet, etc shall be provided as a result. An example is provided as an attachment.
Hey there, I went through all the details you gave and the spread sheet. I can assist you to find most 5 valuable hours with 4 consecutive 15-minute-values in a day as I'm good in IQ. PS: I've been working as a Mathem Daha Fazla
Bu iş için 13 freelancer ortalamada €23 teklif veriyor
Hello, I have read your project details and I am interested in this project. A professional, qualified and experienced analyst who is expert in numerical, verbal and reasoning. I am sure my experience and skills will Daha Fazla
Hello ! How do you do??? I have checked the project details; I am expert in ms excel. Contact me so we can discuss about it before you award the job. Looking forward to work with you. Thanks.
Hi, I'm energetic, driven and attentive Virtual assistant I am always looking to work long term and provide you quality work. Please review my profile for Web and Data entry, Excel projects https://www.freelancer. Daha Fazla
Hello there With a lot of experience high skills in excell and math i am confident of being best person for completing your tasks
Dear Employer, I have reviewed your project details that seems to be great and I can help you out in completing that.I am a passionate PHP Developer with wide experience in Web Designing and Development. I will provide Daha Fazla
Hello, I am an engineer and expert in MS Excel Formula. I have read the problem and I am sure I can do it. I will need at most 3 Hours time to deliver the solution correctly. You can check my portfolio items for some Daha Fazla