AL: Unravelling Constraints, A Case Study developing with Access by Steve Schapel + Jack Drawbridge
566 بار بازدید -
3 ماه پیش
-
Steve Schapel explains the challenges
Steve Schapel explains the challenges of constraint satisfaction, what that is, and his journey to create a solution in Microsoft Access for managing sport competitions. He is joined by Jack Drawbridge, who adds some fascinating information. Hosted by Maria Barnes. Interesting side discussions about twinBASIC, COM, and using DBEngine.Idle instead of Sleep.
0:00 Unravelleling Constraints: A Case Study developing with Access by Steve Schapel with Jack Drawbridge
2:00 Duane cardiograph with a heartbeat, flatline
3:11 intro by Maria Barnes
4:07 hello from Steve Schapel greetings from New Zealand
4:15 The Aim
6:14 The Story, Sports Competition management
run an event with a number of participants, attend activities
promote growth and development of young children
7:46 Capacities
8:05 Rotations, sessions, time slots
8:31 The Project
9:20 The Gut feeling, over-confident
9:58 An example
combination of activities and rotations of participants for 4/4/8
12:57 The Big Question -- create compliant schedule?
13:33 Define Carnival to try things out
6 rotations with 7 activities plus more details
11th iteration of code, valid schedule
14:59 VBA code for create schedule
create recordset for rotations, activities, nested recordset structure
15:40 loop through the recordsets
if it doesn't make the rule, try the next one
16:41 The Process in Immediate window
17:02 Next Step
70,000 got stuck
ask your mates
it looks so easy
20:30 New Vistas
Technologies and new words
21:01 Tools developed to solve this type of problem
21:18 thanks to Jack Drawbridge
stuck with me through this. Big learning experience
22:06 Umbrella Concept -- Constraint Satisfaction
22:31 assignment of fixed sets of data to a set of variables
23:11 Where to from here -- persevere with Access?
find someone else to help
24:57 Python in command prompt
25:46 writes data to CSV file
25:57 Apply to Application
create a solution for possible and requested event configurations
template - slice of the pie
27:48 VBA ImportTemplateDefinition from CSV
28:09 CarnivalTemplateDefs table, lot of numbers
28:28 End User Experience for SportsRunner
29:21 Carnival
assign template to event, generate Carnival schedule from SportsRunner
look at different ways, print, email, upload to website for parents and schools
33:34 Last Friday, first event run through this software in real life, about 350 children, gratifying
34:27 Q's and comments
35:24 Steve: Ade is master with words, paying attention
36:35 Mike Wolfe's 5-part series
37:18 Steve - the power of Or-Tools that google developed, Mike's article,
38:57 Jack Drawbridge
constraint satisfaction
40:10 MiniZinc from University of Melbourne
42:08 facts, rules, constraints
pseudo-language pass off to various solvers like Or-Tools
42:49 napsack problem
traveling salesman, shift scheduling
44:37 MiniZinc tournaments, Or-Tools keep on winning
45:07 Colin school 1200 kids, 150 activities, a week to fit it in
46:24 Access Europe in August speaker is MajP, Peter Poppe
47:42 Schapel like apple
48:32 JimD explored generating matrices
49:20 DbEngine.Idle lets database engine catch up, rather than sleeping and hoping its going to clear it up
49:52 Steve: Sleep 0.1 second to move the Timer on
50:36 pronounciation
51:56 Maria, fascinating
April meeting - Discord
52:45 May - using Web APIs from Access
break for summer, start again in August
53:10 applause for Steve
53:22 Neil got the time wrong
54:06 DevCon 2024
54:46 twinBASIC
57:20 COM is the reference
1:00:04 Ben curious if live chat group like Discord for Access developers
1:00:27 Next Access Lunchtime -- using Discord
1:01:55 UK Access user group open to non-physical people
1:02:38 Ben looking at Adrian's desk, background, blur
Links
Steve's website
https://datamanagementsolutions.biz/
SportsRunner application
https://sportsrunner.nz
Reader Challenge: Einstein's Five-House Logic Problem
https://nolongerset.com/classic-logic...
MiniZinc
https://www.minizinc.org/
Or-Tools
https://developers.google.com/optimiz...
https://github.com/google/or-tools
Mike Wolfe, twinBASIC articles
https://nolongerset.com/tag/twinbasic/
DevCon 2024
https://www.donkarl.com/devcon/archiv...
upcoming:
Access Lunchtime, Tuesday May 28, 2024, noon central
Using Web APIs in Access with George Young
https://accessusergroups.org/lunch/ev...
Access Europe, Wednesday August 7, 2024, 18:00 UK
Working with Treeviews
by Peter Poppe (MajP)
https://accessusergroups.org/europe/e...
Next Access Lunchtime:
Learn how to chat with other Access developers on Discord
TUESDAY 30 APRIL 2024, noon central
https://accessusergroups.org/lunch/ev...
AccessUserGroups.org host Maria Barnes
Last Tuesday @ noon Central
https://accessusergroups.org/lunch/
0:00 Unravelleling Constraints: A Case Study developing with Access by Steve Schapel with Jack Drawbridge
2:00 Duane cardiograph with a heartbeat, flatline
3:11 intro by Maria Barnes
4:07 hello from Steve Schapel greetings from New Zealand
4:15 The Aim
6:14 The Story, Sports Competition management
run an event with a number of participants, attend activities
promote growth and development of young children
7:46 Capacities
8:05 Rotations, sessions, time slots
8:31 The Project
9:20 The Gut feeling, over-confident
9:58 An example
combination of activities and rotations of participants for 4/4/8
12:57 The Big Question -- create compliant schedule?
13:33 Define Carnival to try things out
6 rotations with 7 activities plus more details
11th iteration of code, valid schedule
14:59 VBA code for create schedule
create recordset for rotations, activities, nested recordset structure
15:40 loop through the recordsets
if it doesn't make the rule, try the next one
16:41 The Process in Immediate window
17:02 Next Step
70,000 got stuck
ask your mates
it looks so easy
20:30 New Vistas
Technologies and new words
21:01 Tools developed to solve this type of problem
21:18 thanks to Jack Drawbridge
stuck with me through this. Big learning experience
22:06 Umbrella Concept -- Constraint Satisfaction
22:31 assignment of fixed sets of data to a set of variables
23:11 Where to from here -- persevere with Access?
find someone else to help
24:57 Python in command prompt
25:46 writes data to CSV file
25:57 Apply to Application
create a solution for possible and requested event configurations
template - slice of the pie
27:48 VBA ImportTemplateDefinition from CSV
28:09 CarnivalTemplateDefs table, lot of numbers
28:28 End User Experience for SportsRunner
29:21 Carnival
assign template to event, generate Carnival schedule from SportsRunner
look at different ways, print, email, upload to website for parents and schools
33:34 Last Friday, first event run through this software in real life, about 350 children, gratifying
34:27 Q's and comments
35:24 Steve: Ade is master with words, paying attention
36:35 Mike Wolfe's 5-part series
37:18 Steve - the power of Or-Tools that google developed, Mike's article,
38:57 Jack Drawbridge
constraint satisfaction
40:10 MiniZinc from University of Melbourne
42:08 facts, rules, constraints
pseudo-language pass off to various solvers like Or-Tools
42:49 napsack problem
traveling salesman, shift scheduling
44:37 MiniZinc tournaments, Or-Tools keep on winning
45:07 Colin school 1200 kids, 150 activities, a week to fit it in
46:24 Access Europe in August speaker is MajP, Peter Poppe
47:42 Schapel like apple
48:32 JimD explored generating matrices
49:20 DbEngine.Idle lets database engine catch up, rather than sleeping and hoping its going to clear it up
49:52 Steve: Sleep 0.1 second to move the Timer on
50:36 pronounciation
51:56 Maria, fascinating
April meeting - Discord
52:45 May - using Web APIs from Access
break for summer, start again in August
53:10 applause for Steve
53:22 Neil got the time wrong
54:06 DevCon 2024
54:46 twinBASIC
57:20 COM is the reference
1:00:04 Ben curious if live chat group like Discord for Access developers
1:00:27 Next Access Lunchtime -- using Discord
1:01:55 UK Access user group open to non-physical people
1:02:38 Ben looking at Adrian's desk, background, blur
Links
Steve's website
https://datamanagementsolutions.biz/
SportsRunner application
https://sportsrunner.nz
Reader Challenge: Einstein's Five-House Logic Problem
https://nolongerset.com/classic-logic...
MiniZinc
https://www.minizinc.org/
Or-Tools
https://developers.google.com/optimiz...
https://github.com/google/or-tools
Mike Wolfe, twinBASIC articles
https://nolongerset.com/tag/twinbasic/
DevCon 2024
https://www.donkarl.com/devcon/archiv...
upcoming:
Access Lunchtime, Tuesday May 28, 2024, noon central
Using Web APIs in Access with George Young
https://accessusergroups.org/lunch/ev...
Access Europe, Wednesday August 7, 2024, 18:00 UK
Working with Treeviews
by Peter Poppe (MajP)
https://accessusergroups.org/europe/e...
Next Access Lunchtime:
Learn how to chat with other Access developers on Discord
TUESDAY 30 APRIL 2024, noon central
https://accessusergroups.org/lunch/ev...
AccessUserGroups.org host Maria Barnes
Last Tuesday @ noon Central
https://accessusergroups.org/lunch/
3 ماه پیش
در تاریخ 1403/02/09 منتشر شده
است.
566
بـار بازدید شده