All Questions
8
questions
6
votes
4
answers
153
views
an algorithm that chooses the best games on steam
The code below will go through an excel spread sheet taken from kaggle, is named "SteamGames (71k games)" and the creator is "MEXWELL".
inside the ...
1
vote
0
answers
63
views
Appending data from files listed in a file
I am working on a project that requires me to write VBA code which, upon a button press, loads the data from certain files in a given directory.
In my testing, I was able to load the data from 1100 ...
1
vote
1
answer
105
views
ContactEditor - Excel VBA db app: Storage Library and MVP
In the previous post, I presented my Storage Library. Here, I would like to focus on the integration of the library with the MVP component.
Functional class mapping
First of all, the figure shows a ...
1
vote
0
answers
142
views
ContactEditor - Excel VBA db app: Storage Library
ContactEditor uses Excel VBA as a prototyping platform for a personal information manager combining the "Model, View, Presenter" (MVP) pattern and a persistent storage manager.
Fig. 1. Data ...
3
votes
1
answer
541
views
VBA introspection library for SQLite
SQLiteDB VBA Library is a set of VBA helper functions for the SQLite engine. The primary motivation behind this project is to provide convenient access to extended introspection features. Because of ...
2
votes
0
answers
442
views
Generic function for interpolating missing values in power query
I have written a (relatively) generic function for interpolating values in power query (also useful for power bi and m code).
I am looking for any improvements or input, but especially:
speed
handle ...
3
votes
1
answer
3k
views
Python script for refreshing and preprocessing data in Excel report files
I wrote some code to create marketshare reports. However, I'm sure it can be improved. The tasks performed are:
Open the global data file, refresh the data, import its content as a DF.
Create a ...
2
votes
1
answer
99
views
Importing Excel file to a database just once
How should I rewrite an if-return-else condition in the middle of this function?
...