I've released the Treecell version 1.4.
Treecell allows to explore Excel and CSV files as navigating a tree.
In 1.4, added support for database query as input for the table. PostgreSQL, MySQL, Oracle and H2 database are supported.
https://www.japplis.com/treecell/

#excel #csv #PostgreSQL #MySQL #oracle #OracleDatabase #windows #macOS #Linux #software #msexcel

#ICAEW are giving two lucky winners the chance to win free access to their set of #Excel on-demand #courses: https://lnkd.in/eCfaVQ9G

The competition was inspired by a recent Excel Community post:

https://lnkd.in/eVjuq5Sc

To enter, you must share your experience of an Excel inefficiency that you’ve come across, and the Excel features that you have been able to use to dramatically improve productivity.
https://www.linkedin.com/feed/update/urn:li:activity:7282368205782675456

Closes 3 Feb GMT.
#free #MSExcel #training @EuSpRIG

The request came yesterday, one of the client's employees is not able to open the Excel files on his system.

Tried taking remote access, but the system is slow and old enough that Anydesk didn't install. Couldn't take the remote.

Verbal probing didn't get me much information.
Cx requested to visit. Scheduled for 31st December i.e. today.

Leaving for the site in 10 minutes.

So I have been wanting to learn more about how to use Microsoft Excel so I can teach other people about some of the more advanced programming techniques. But then I really do not want to burn up all of that disk space just to run Wine and Excel.

So I got to thinking:

1. is there an older version of Microsoft Excel I could use instead?
2. The “ribbon” UI/UX asside, how far back in time (in Excel software versions) would I have to go before the formula language and cell computation engine became too different from the most recent Excel that it would not be very useful for me as a learning/teaching tool?
3. Would it take less disk space to run this in a minimal Windows NT 2000 or Windows XP instance on QEMU than it would take on Wine?

@EuSpRIG July 4-5 London programme continued:

whyqd: Auditable and reusable #crosswalks for fast, scaled #integration of scattered tabular data. Gavin Chait, #Whythawk, France, and Centre for Advanced Spatial Analysis, University College London.

#Excel: Automated Ledger or #Analytics IDE? Dr Andrew Kumiega, Assistant Professor of Analytics, Illinois Institute of Technology

#European #Spreadsheet #Risk #Interest #Group #Eusprig #ITRisk #MSExcel
Register: https://eusprig2024.eventbrite.co.uk/

@EuSpRIG Prof. Andy #Gordon (U. Edinburgh & CSO, #Cogna Plc) - a preview of his #Eusprig2024 (July 4-5 London) talk on representing #uncertainty in #spreadsheets - short version : https://youtu.be/D1Y0MsorccU?si=rZsexTFSXQ8Fulon

Longer version: how #Lambda can be used to represent and conserve #uncertainty, the impact of tools like #CoAudit for #Excel and #generative #AI in general https://youtu.be/uFoNHcbg_VE?si=dX5T361oPKQo82Bi

#European #Spreadsheet #Risk #Interest #Group #Eusprig #ITRisk #MSExcel
Register: https://eusprig2024.eventbrite.co.uk/

Dear @microsoft #MSExcel developers: has none of you printed a spreadsheet with #MSWindows set to its built-in #accessibility visual theme, high-contrast black? Because the latest version of #Microsoft365 apps for enterprise prints out black pages with light text. And when I switch the visual theme to the built-in high-contrast white, it prints white pages with black text. Same spreadsheet. That shouldn't happen. #usability

Simon Thorne's article for The Conversation on #spreadsheet #errors that was republished by ARC Technica is now the #1 organic hit when searching for "spreadsheet error" @EuSpRIG
https://arstechnica.com/science/2024/01/we-keep-making-the-same-mistakes-with-spreadsheets-despite-bad-consequences/
#Excel #MSExcel
Come to #Eusprig 2024, London 4 & 5 July, to get the latest defence strategies against #spreadsheet #risk. https://www.eusprig.org

Stay on the keyboard don’t touch that mouse! Tip: you can edit the contents of a cell in #MSExcel by pressing F2, to exit press F2 again. Dead simple, job done, happy days Seriously a lot more streamlined than moving back and forth to the mouse and double-clicking each time you want to edit the cell contents.

I've released Sheet Stats1.0.

A free game with colleagues to know who created the most complex Excel spreadsheet.

https://www.japplis.com/sheet-stats/

#apachepoi #excel #msexcel #stats #freeware

I've released Treecell 1.0.

Treecell is a new way to view Excel and CSV sheets. Explore the data as a hierarchic tree.

https://www.japplis.com/treecell/

#excel #tree #hierarchy #explorer #csv #msexcel #software #windows #macos

https://sysmod.wordpress.com/
#Excel #dynamic #array #cumulative sum
To calculate a 2-D array where each row is the #cusum of each row in the source table, it’s possible to use the #MMULT function. The #matrix multiplication is done with an upper-right triangular array of 1s. But when you get to 1000 rows, the matrix is a million-cell array, and for 3000 rows or more, #MSExcel is going to go out of memory.
Here is an efficient method of doing this for a dynamic array cusum down columns.

Is #MSExcel really this pain in the neck, or is it just me?

Great #Excel calcChain #forensics by @datacolada
#Harvard professor who studies honesty accused of #falsifying #data in #studies
https://amp.theguardian.com/education/2023/jun/25/harvard-professor-data-fraud
The original blog from 2021 http://datacolada.org/98 is followed by a 4 part blog
https://datacolada.org/109

#excel #msexcel #dataquality #fraud #statistics #probability #benfordslaw #inference #patterns #analysis #audit #behavioural #behavioral #science #honesty #research #review #francescagino
#eusprig #spreadsheet #risk

Here's an #Excel #trick I learned from Bo Rydobon. What do you think this #Excel formula returns?

=A2:A4 & "," & TOROW( B2:B3 )

Answer in the picture
#MSExcel #tips #tipps #astuces #spreadsheet #dynamic #array #formula

#London, #UK, 6 July 2023, the #European #Spreadsheet #Risk Interest Group
@eusprig
2023 #conference "The Spreadsheet Crisis: Regaining Control" programme PDF

https://eusprig.org/wp-content/uploads/eusprig-programme-2023-1.4.pdf

#AI #LAMBDA #Excel #MSExcel #productivityhacks
Register:
https://www.eventbrite.co.uk/e/eusprig-2023-annual-conference-the-spreadsheet-crisis-regaining-control-tickets-615697657267

EuSpRIG 2023 Annual Conference: The Spreadsheet Crisis: Regaining Control
Research on problems in the development, audit, testing and quality assurance of critical spreadsheet assets in a world of AI assistance.

For #ICAEW members, my tips on the tricks needed to get some #Excel functions to handle arrays and ranges and return arrays, is live on the #ICAEW_Excel page. Requires member login.
https://www.icaew.com/technical/technology/excel-community/excel-community-articles/2023/excel-tips-and-tricks-467

Excel Tips & Tricks #467 - Excel functions that are harder to get to return arrays or ranges
Such as AND, OR, and date functions like EOMONTH.

Hi, I’m James and this is my #introduction.

I'm originally from a rural town in middle Missouri but now call #SaintLouis my home. I have a love for the American southwest (my Mom is from New Mexico) and for the coastal city of #Savannah #Georgia.

I'm single, live alone with two #dachshunds (#dogs) named Amelia and Penelope. I'm a #progressive #liberal, can't stand money in #politics, and yearn for a day when the #Democrats improve their messaging and start fighting back.

What I'm into: #Photography, #Cooking, #Grilling, #StarWars, #StarTrek, #80sMovies, #JurassicPark, #Marvel, #dinosaurs, #computers, #gadgets, #VBA, #Python, #MSExcel, #art, #archaeology, #history, #3DPrinting, #philosophy, #news, and you'll find I'm a bit of an all-around nerd.

I’m also #diabetic, suffer from #anxiety, #depression, and #panicattacks. Forgive me in advance if I reach out.

I'm sarcastic as all get out but I have a big heart, that's easily broken when I see people (or animals) hurting.