Go-Bruins
asked on
Google Spreadsheet (or Excel) - solving scheduling conflicts.
Hi all,
I have a fairly simple spreadsheet, but what I'm asking for may not be routine. Link and description here:
https://goo.gl/qhUfQ5
I'm trying to have formulas (or code) root out and mark scheduling conflicts. Right now, I'm using a very long formula that seems a little unrefined. I'd like to find a better approach if it's simple.
Thanks in advance.
I have a fairly simple spreadsheet, but what I'm asking for may not be routine. Link and description here:
https://goo.gl/qhUfQ5
I'm trying to have formulas (or code) root out and mark scheduling conflicts. Right now, I'm using a very long formula that seems a little unrefined. I'd like to find a better approach if it's simple.
Thanks in advance.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, and thanks for the response.
1. No, it won't always be sorted by date.
2. ID's are only important as a reference. Just something us humans can use to quickly talk about the same record.
3. Games aren't always 2 hours, but maybe i can input a game duration into a cell and reference it in formulas, code, etc.
4. Yes, the number of variable can certainly grow in the future.
1. No, it won't always be sorted by date.
2. ID's are only important as a reference. Just something us humans can use to quickly talk about the same record.
3. Games aren't always 2 hours, but maybe i can input a game duration into a cell and reference it in formulas, code, etc.
4. Yes, the number of variable can certainly grow in the future.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This looks like beautiful code, but the spreadsheet is hosted in Google Sheets, which uses a variation of Javascript.
Your tags are for Microsoft Excel and Office. If you cannot or are not using them then you should not include tags for them. I've never used Google's variation of javascript.
ASKER
My mistake. Many of the functions and formulas go cross-platform. The formula you suggested would have worked in Google Sheets.
Maybe what I can do is translate VBA to Javascript somehow.
Again - thanks for your help.
Maybe what I can do is translate VBA to Javascript somehow.
Again - thanks for your help.
No problem. You could post another question to get help converting my solution into javascript.
Having asked these, there are several ways to have a conflict so there won't be a short answer. It will be complex.