Private sector IR35 Off-payroll working rules are coming, the best way to be informed is straight from the horses mouth:[…]
Author: FinancialRadDeveloper
I am an Excel VBA RAD Developer in Banking. I am trying to share the tips and info I have picked up in the last few years.
Initial foray into Data Science with Python
Professionally I have undertaken a major segue into Python from the usual Excel VBA development environment. However this has remained very tightly linked to the quant library and specific business requirement solving as before. […]
Quick Transposer
A post from a Pistonhead member in need : Hopefully someone can help! I have a list of approx 50000 numbers in ‘Column A’ of spreadsheet. I need to split this list into batches of […]
Triskaidekaphobia! Or in English: Microsoft Excel Team’s fear of 13.
So today when I saw something that look like this it made me smile:
Public Enum ExcelVersionEnum Excel4 = 4 Excel95 = 7 Excel97 = 8 Excel2000 = 9 Excelxp = 10 Excel2003 = 11 Excel2007 = 12 Excel2010 = 14 'Triskaidekaphobia! End Enum
There is no Excel version 13. I of course only just found this out when I encountered Excel 2010 which, I blush to admit, I have not downloaded from TechNet yet and played with.
Triskaidekaphobia (from Greek tris meaning “3,” kai meaning “and,” and deka meaning “10”) is fear of the number 13; it is a superstition and related to a specific fear of Friday the 13th, called paraskevidekatriaphobia or friggatriskaidekaphobia.
G Challenge III – Practice Excel VBA Interview question – Watch face maths
I have heard of this question coming up a little bit in all sorts of technical interviews so I thought I would set it as a G Challenge. Question: “Please tell me what you would […]
Watch Accuracy Tracker
I had an idea the other day that I would write a small app in Excel to keep track of all my watches. I was planning to use a constant source like : http://time.is/ to […]
Essential tools for Excel VBA RAD (Rapid Application Development)
I guess a major point of RAD is speed. The clue is right there in the name: Rapid Application Development. So, all other things being equal, how do we go about getting more speed. I […]
