Dynamic Data Validations combobox XL > WEB: Employee Scheduler

[Stephan]

Hello

Compiled comprehensive XL staff/business spreadsheet, essentially an employee / client scheduler:

STAFF#DV#.xls 14.5mb http://www.hkrebs63.karoo.net/xl/STAFFdv.xls

STAFF.zip 2.7mb http://www.hkrebs63.karoo.net/xl/STAFF.zip

Its far better then all the online schedulers I've seen so far. Essentially my approach here is the same as SQL, via 3D DYNAMIC DATA VALIDATION using COMBO BOXES.

ONEDRIVE would have been ideal to make this useable online, however file features/size prevents this, GOOGLEDRIVE was my next option and perhaps some its APPs can FUSION TABLE this spreadsheet for an effective website employee scheduler solution.

Q. Other viable options to make this non macro spreadsheet of use online? All Formula.

Perhaps a more sophisticated ONEDRIVE equivalent.

 

[AVK]

Its a very large file can't open. Kindly small but enough data file attach.

 

[Stephan]

Download the XL zip file instead thats only 2.7mb:
http://www.hkrebs63.karoo.net/xl/STAFF.zip

 

[AVK]

After unzip .xls file size 14 mb ???

 

[Stephan]

After unzip .xls file size 14 mb ???

Hello, yes 14MB in this case file size is indictative of quality!
& for comparitive purposes how many 3D Dynamic Data Validations have you seen that actually work & are fully populated, there u go then.

Go look at the file! 14MB is nothing these days, a utube video is 60mb.

 

[Gregor]

Hello, yes 14MB in this case file size is indictative of quality!
& for comparitive purposes how many 3D Dynamic Data Validations have you seen that actually work & are fully populated, there u go then.

Go look at the file! 14MB is nothing these days, a utube video is 60mb.

Hi Stephan

I know its ages old but do you still have this scheduler that I could access - using the link doesn't seem to work it takes me to an invalid web page?