Recent content by arpod

I know this is stale, but thought I'd circle back and a) thank all those that responded with their input, and b) update that I managed to get chatGPT to put together code that does exactly what's required. Took a few revisions and clarifications, but probably about 90 minutes in total from...

Hi @KitaYama .. thanks. I do use Power Query quite a bit, and quite often using Access queries as the source. . But in this instance my challenges are: iteratively splitting into subgroups for analysis within Excel, and getting the results automatically back into Access Regards, A

Thanks @Isaac and @Uncle Gizmo ... will have a play with those responses and see if I can make some headway. Appreciated. A

If there's a way I can achieve it by transferring the data between the two apps that's probably preferable, at least in the short term. Trying to move what's in Excel currently into Access isn't a wheel I'm overly keen to recreate.

I think it is in this case ... but the issue I suspect is to be able to generate what is essentially a matrix of up to 200,000 cells based on this function (and a "seed" value) for up to 20 measurements near instantaneously. If I can achieve it using what's already in place, but taking out the...

There's a free version (you have to provide details though - they don't seem to spam though). Pic attached - it won't let me include a URL.

Hi @gemma-the-husky ... the Excel side uses an add-in I 'inherited' - SIPmath Modeller Tools. As far as I can see what it creates is native Excel (i.e. doesn't need the addin to share etc) - but I suspect the easiest approach would be to have a process to copy the access query (or temp table)...

Thanks @GPGeorge. That's the crux of what I'm trying to do.

Fair enough .. I will try to add some detail. Basically the calculation in Excel is a Monte Carlo approach where 20 * 100,000 cells are calculated via formula (using a Beta distribution) for each iteration. The resultant summary calculations provide is "output" value required. (A Monte Carlo...

Thanks @arnelgp ... that would definitely work if not for the part in the second main paragraph in the OP. The underlying intent isn't to get a percentage of the subtotal - instead it is a calculation that needs to happen in Excel as the actual values are a Monte Carlo calculation rather than a...

Hi there, Not 100% sure if this is the right area, but I have a bit of a weird one - I think. Basically I have a query in Access that outputs some values, which I then need to calculate by subgroup in Excel, and return the output result to the relevant record in Access. My (possibly naive)...