GUI Display information according to current time (HELP!)

[swstrau118]

I'm new at programming, is it possible to write a program that could reference an excel, csv (any file type) on your GUI, so when you press a button it would display that information.

Explained:

Say you are making an On Call schedule for your 3 employee's - each person is on call at different times of the day:

• Person 1 - 8am - 4pm
• Person 2 - 5pm - 9pm
• Person 3 - 10pm - 3am

They are located in an excel file. The GUI would have a button to when you click on the button it would take the current time and display (inside the GUI or msg box) who would be on call based on the time. Is this program possible? If so please help! I'm lost on how I could start and have been researching.

Thanks

[water]

This should you get started.

[swstrau118]

Maybe its because I'm really tired - how could I use that function to relate off an excel spreadsheet (or something) to display the information I need according to the time?

[stormbreaker]

Not exactly what you wanted, but still could be of great help for a starter.

_CallOfDuty()

Func _CallOfDuty()
$HOUR = @HOUR
If $HOUR >= 8 AND $HOUR <= 16 then msgbox(64, 'Your dearest PC says:', 'I think person-1 on duty for now.')
If $HOUR >= 17 AND $HOUR <= 21 then msgbox(64, 'Your dearest PC says:', 'I think person-2 on duty for now.')
If $HOUR >= 22 OR $HOUR <= 3 then msgbox(64, 'Your dearest PC says:', 'I think person-3 on duty for now.')
EndFunc

WHAT IT DOES? It'll display a message telling which person should be on-duty at the time when it is opened. I leave dealing with CSV part for others. I'm too lazy for it.

Good luck with your app.

Edited April 13, 2013 by MKISH

[water]

First you need to read the data form a Excel workbook. Use the Excel UDF that comes with AutoIt. Functions _ExcelBookOpen and _ExcelReadCell or _ExcelReadSheetToArray will do what you need

[swstrau118]

Thanks for everyone's help so far, I was reading up on the Excel functions and it looks like you can only look at specific cell numbers and such. What happens if it changes? Here is an example schedule of mine that I created that I am looking to use. Any help is greatly appreciated!

Coverage Calendar and Contact Information - April 2013.xlsx

[water]

You either read the whole sheet into an array and then search for the relevant content. Or you search in Excel for one of the header lines and then read the needed cells.

[swstrau118]

Ah ok - let me try that! Thanks