retool | Vendoring for executables written in Go

I'm relatively new to VBA, so bear with me.

I have a excel workbook with multiple sheets, which are fed by data imported from multiple external excel files. To complete this action, I have successfully built a VBA code that opens allows the user to open the files.

Behind the scenes, one of the subs imports data from the GL raw data into a spreadsheet with multiple columns. I am attaching a couple screen grabs here to show what is happening:

The pre-existing data looks like this: [Pre-Populated Date][1]

Raw data once downloads will look like this: [RawData][2]

Once the macro runs, the previous columsn all populate as intended, but because the last two columsn are populated intermittently, they end up doing this:[MergeData][3] [1]: https://i.stack.imgur.com/lZ1fX.png [2]: https://i.stack.imgur.com/wjMBr.png [3]: https://i.stack.imgur.com/gnrqi.png

Please keep in mind I only summarized columns in these images, as the workbook in question has 28 columns preceding the two columns in question.

Due to the sheer size of the data and the macro itself, I would like to maintain the structure of the code itself. Especially since it is intended that this macro will be transferred to other general ledger workbooks.

Currently, my macro looks like this (summarized for time):

Does anyone have any tips to get the current UTC time, from online somewhere, and write some decent python code assuming my computer clock is always wrong?

I'm trying to create a voronoi tessellation from a trajectory.xyz file with 305 particles in it and multiple frames of data. I have used this script I found on GitHub here: https://gist.github.com/pv/8036995 and retooled some stuff to more accurately fit my goal of plotting a single frame's tessellation (code below). My problem is, however, that whenever I run the code, there's no border/outline for any of the polygons generated.

This makes the whole thing look kind of messy and muddled. I am fairly confident it has to do with the graphing of the tessellation, but I'm unsure of how to fix it. Even when I run the GitHub script exactly as it is with the random points, my polygons don't have outlines. Any ideas?

Code:

I use the Retool tool to build a dashboard.
I import my data from a google sheet and I would like to be able to make transformation statistics from the data.

From this

I am building an interface to connect tables and present information in Retool about used products we are selling on behalf of customers.

I have several tables that all relate back to a single product. The other tables are information on a process or status - ie, Sent for repair, Sold, Returned, seller paid out.

I am looking to get a table that gives a product history sorted by date. I can JOIN all the tables and get a single row of data but I am looking for a vertical table like:

I've been retooling some older spreadsheet tools for filtering and formatting dynamic data outputs using Excel's newer Dynamic Array Formulas functionality. This has been helping remove some of the need for pre-allocating cells and lower amounts of helper columns (which has allowed for reduced file sizes and snappier performance).

One function type I am struggling to replace is pulling out dynamic, running duplicate counts.

For instance, say I have a column B of 20 names that can vary in length from a handful to say 200 names. There is also related data in columns C, D, etc that similarly varies in size. For use of filtering the Data in the later columns, we currently use a helper column in A consisting of the running count of the duplicates in A with a formula using semi-anchored ranges(ie. Beginning the range with an anchored cell that expands as the formula is copied down the helper column akin to the solution here with CountIf() and a semi-anchored range). The drawback here vs the new dynamic array formulas is that the helper column needs to be pre-allocated for the data.

Despite attempts with Index(), Aggregate(), Filter(), and a few more involved notations like Sumproduct(--(...)), the most straightforward method I can find to make helper column A seems to be by creating the running count via semi-anchored ranges, which unfortunately does not seem to translate well to the new dynamic array Formulas.

Has anyone had any luck adapting the use of semi-anchored ranges and formulas for use in dynamic array formulas?

I have 2 views:

I have been able to successfully integrate Bigquery with Retool on a project. However, right now, I am suddenly seeing the following error message when I try to query my bigquery table from my Retool app:

I have been retooling my approach to an app that I have made, started using classes and more object oriented style and separate files for pages and not just smacking everything in a function in the main file.

Here is the App.js