On Tuesday, February 1, 2022, Apex’s Chief Architect & Lead Developer, Bob Calco, presented as part of the London Clojurians’ online series discussing Apex’s vision of using LISP to turn document and desktop data silos commonly associated with MS Office products (especially Access and Excel documents, though not limited to these) into fully-interoperable, linked-data microservices.
Inspired in part by Microsoft’s recent announcement of the new LAMBDA Excel function (see: https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/), Apex had a broader vision to fully integrate a proper Lisp into the world’s most popular spreadsheet application. The result proved powerful enough to incorporate into our platform for general data interoperability. The first technology offering is called AcceλerateTM which transforms document and desktop data silos commonly associated with MS Office products (especially Access and Excel documents, though not limited to these) into fully-interoperable, linked-data microservices. Our brief demo will place a special focus on the use of Scheme for bringing a whole new dimension to Excel’s formula calculation capability. By leveraging the power of Lisp, AcceλerateTM empowers users to go well beyond what VBA can do in desktop database and spreadsheet applications like Access and Excel. We are also working on a distributed enterprise interoperability solution, called DomainMasterTM, which will be incorporating ClojureCLR as a language option as well. A sneak peek at that is also planned, time-permitting.
Bob Calco is Chief Architect and Lead Developer at Apex Data Solutions, LLC. A passionate Lisper, Bob is currently leading development of Apex’s generalized data interoperability platform, Unify!, and related technologies. Apex Data Solutions is a pioneer in the health data interoperability space, an active member of the HIMSS Blockchain Taskforce, and deeply experienced at complex enterprise data federation. This experience is being generalized for use in healthcare, finance and other domains such as M&A, in the Unify! platform, and will be made available to early adopters in 2022.
About the Event:
Title: **LISP: The Ultimate Excel LAMBDA**
Speaker: **Bob Calco, Apex Data Solutions, LLC**
Hosted by: **The London Clojurians**