Spreadsheet Surgeons

Had the tough task of traveling to Japan to promote spreadsheet surgeons. 🍣These weeks I've spent hard at work 🍜 in Japan 🍢 have been a struggle but I will reluctantly 🍤 volunteer for any similar tasks that must be done ⛩️ for the company ♨️ Thanks Adam Sims Department of State Development for helping small companies make connections at ILS Japan.

𝗣𝘂𝘇𝘇𝗹𝗲 𝗧𝗶𝗺𝗲! "If I flip two fair coins and tell you that at least one of them is heads, what's the probability that the other coin is also heads?" 𝗔𝗻𝘀𝘄𝗲𝗿: Your first instinct might be to say 1/2. But this is where conditional probability shows its tricky nature. Let's break it down: When flipping two coins, there are four possible outcomes: •   Heads, Heads (HH) •   Heads, Tails (HT) •   Tails, Heads (TH) •   Tails, Tails (TT) Now, we're given the information that at least one coin is heads. This eliminates the TT outcome, leaving us with only three possibilities: HH, HT, and TH. Among these three remaining scenarios, only one (HH) has both coins showing heads. Therefore, the actual probability is 1/3, not 1/2! Just as this coin flip problem shows how writing down a clear mathematical model revealed a surprising truth, software development becomes much more reliable when we step back and carefully model our problem space before diving into code. In fact, with a proper understanding of the problem we can get a generalised equation so we never run into this bug again. P(all heads | at least one heads) = (1/2)^k / (1 - (1/2)^k) Where k is the total number of coins P(m heads | at least n heads) = [C(k,m) * (1/2)^k] / [Σᵢ₌ₙᵏ C(k,i) * (1/2)^k] where C(k,m) is the binomial coefficient #SoftwareEngineering #SystemsThinking #CleanCode #SoftwareArchitecture #Mathematics #Probability #ProblemSolving #DataScience

Excel is great, Power BI is great, I've heard Tableau is great. However, all low code solutions have a limit. As your project grows, you will encounter the same problems you did in Excel just at a larger scale. Additionally, the short term cost of hiring a programmer is often lower than the short term cost of hiring a Power BI expert for the same problem. At Spreadsheet Surgeons we try to give you the best of both worlds, we are programmers with additional expertise in Power BI. We will choose the best solution for that job whether that's Power BI, R, .NET or a mixture of all of them.

As we celebrate #NationalCodingWeek, let's spotlight a game-changer: How Large Language Models (LLMs) are transforming the way we approach ANY software project in ANY programming language! Here's why LLMs are the ultimate tool for instant adaptation and immediate contribution to diverse coding environments: 1️⃣ Universal Code Fluency: Seamlessly transition between languages - from Java to Rust, Python to Go, and everything in between. 2️⃣ Rapid Project Onboarding: Quickly understand and contribute to any codebase, regardless of its complexity or domain. 3️⃣ Contextual Problem-Solving: Adapt your existing skills to new paradigms and project-specific requirements on the fly. 4️⃣ Cross-Language Best Practices: Instantly access and apply industry standards and optimizations for any language or framework. 5️⃣ Real-time Learning and Application: Simultaneously learn and implement new concepts, dramatically reducing ramp-up time. With LLMs, you can: 1. Quickly grasp the project architecture 2. Understand language-specific idioms 3. Translate your ideas into the required syntax 4. Implement best practices unique to that environment 5. Debug and optimize code efficiently All of this happens in real-time, allowing for immediate, valuable contributions! 🔍 Our Edge: Our experience in functional programming allows us to define precise coding criteria in any language (python, typescript, c#, Haskell, rust,... any language). The future of coding is adaptable, and we're at the forefront. No matter the language, framework, or project complexity, we have the tools and expertise to contribute meaningfully from day one. 💼 Looking for versatile programmers who can hit the ground running on any project? Let's connect! We're ready to tackle your unique challenges, regardless of the tech stack. What's your take on this LLM-powered approach to universal code adaptation? How could this transform your project workflows? #AIinCoding #UniversalProgramming #AdaptiveCoding #TechInnovation #SoftwareDevelopment #ProgrammingServices #AnyLanguageAnyProject

Here's a literature review looking at 122 different papers studying spreadsheets. The overall conclusion was that 94% of spreadsheets contain errors. As with most studies of this nature it's hard to attach a monetary cost to these mistakes, but the study makes a strong case that it's worthwhile investing effort in your spreadsheet's design and maintenance in order to avoid these errors in the future. https://lnkd.in/gQjkiJva  #spreadsheetsurgeons #spreadsheets #excel #adelaide