Linking the Macro-enabled excel file to MIT

[Nataniel_Bombalez]

Is it possible to show the macro-enabled workbook in MIT?

[ABG]

AI2 has no native Excel macro support.

The closest it comes to that is through the use of Google Sheets or advanced list blocks.

[ABG]

FAQ Section: Google Sheets

Starter Guides Download a Google Sheet as CSV for the Media Folder and load it at startup - ABG AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Creating a Credential for Google Sheets - @Gordon_Lu Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web…

[ABG]

FAQ Section: Lists

Introductory Making Lists (Concepts) - MIT Lists Chapter from MIT AI2 Online book Translatable copy of Lists Chapter from MIT AI2 Online book How to work with Lists - imagnity MIT AI2 List Blocks Help Page How to Display a List - MIT nb191 Advanced list blocks (filter, sort, map, reduce) Tables Dynamic-editable-html-table - @TimAI2 free-tableviewer-fully-style-customized-to-show-table-data (extension) - @Kevinkun Dynamic Table Layout and Table Listpicker (HTML) - @Taifun Dynamic Tab…

[ABG]

Logging Marathon Runner Checkpoints in Google Sheets

This sample is intended to show how to use Google Sheets aggregation functions like MAXIFS to summarize multirow log data into single line summaries. This sample uses the New York City Marathon as a base, though it probably can't scale to the 53,000 runners. It is based on three sheets: Checkpoints, a list of locations each runner must cross on his route Mileposts, a detail list of runner checkpoint timestamps Runners, a master list of runners, with identifying bar codes and stats Checkpoin…