Find the most valueable hours in a day... (MS EXCEL)

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.

Beceriler: Excel, Veri Girişi, Veri İşleme

Daha fazlasını gör: hours day days week hyphen grammar, cells find cut paste columns vba excel, need job hours day, job pays hour work hours day, accent reduction english online hours day, javascript rotation hours day options, windows service execute hours day, find hours spent time excel, paste day ctrl excel, day roster excel, view day forms excel, mysql column hours day, day expense excel sheet, linux shell script find last hours files, per hour hours day, hours day jpeg vector, we need to create a bill format in MS Excel for the patrol pump

İşveren Hakkında:
( 14 değerlendirme ) Villnachern, Switzerland

Proje NO: #28558128


(310 Değerlendirme)

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(3 Değerlendirme)

Bu iş için 13 freelancer ortalamada €23 teklif veriyor

(229 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(18 Değerlendirme)

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.  

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(28 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(6 Değerlendirme)

Hello there With a lot of experience high skills in excell and math i am confident of being best person for completing your tasks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(20 Değerlendirme)

Hello, I am a 4th year medical undergraduate (MBBS) from Sri Lanka. i have extensive knowledge in research work, academic writing, report writing, data analysis. I have knowledge in searching through online medical da Daha Fazla

€10 EUR in 2 gün içinde
(0 Değerlendirme)

Hi Buddy, If you are looking for a genius for this project, Then you are reading the right one. Over the last 1 years, I have been working as a Data entry, Data analysis, PDF/JPG to Word/Excel as well. I have higher ex Daha Fazla

€25 EUR in 4 gün içinde
(0 Değerlendirme)

my work is very serious and dynamic, I am punctual and fast I can very well help you in this job I have a lot of experience in the data entry and accounting marketing too, and all type of windows software, I would like Daha Fazla

€19 EUR in 7 gün içinde
(0 Değerlendirme)

Good day I am willing to do this job because I believe that i can complete your project within the time given and also with a reasonable budget. Being a professional data entry knowledge, I am responsible for manually Daha Fazla

€18 EUR in 6 gün içinde
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)