Moment due to Linearly Varying Pressure Aug 2023

khoitsma
Calculus, Engineering, Excel, Mathematics, Python, PyXLL, Sympy
0 Comments

I built a new function in Python and PyXLL

Continue Reading

Small Ideas — Large Effects Aug 2023

khoitsma
Concept, Engineering, General, History, Mathematics, Science, Software
0 Comments

Continue Reading

Online Embedded Excel Aug 2023

I built a new app on the web — accessible from any device — desktop, phone, iPad

· Grating calculations

Continue Reading

Filter a Pandas Dataframe using PyXLL (with video) Jul 2023

khoitsma
AISC, Concept, Engineering, Excel, Python, PyXLL, Video
0 Comments

The function uses only three parameters: the criteria range, the reverse sort toggle, and the upper limit on rows of results.

Note that conditional formatting is applied using the PyXLL formatter option.

lookup

Continue Reading