Скачать с ютуб AL: Unravelling Constraints, A Case Study developing with Access by Steve Schapel + Jack Drawbridge в хорошем качестве

AL: Unravelling Constraints, A Case Study developing with Access by Steve Schapel + Jack Drawbridge

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/