<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Robert Davidson on Medium]]></title>
        <description><![CDATA[Stories by Robert Davidson on Medium]]></description>
        <link>https://medium.com/@rdavidson1911?source=rss-ae7cca4daa87------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*K8VQ_Ua1vOKvL0wG.</url>
            <title>Stories by Robert Davidson on Medium</title>
            <link>https://medium.com/@rdavidson1911?source=rss-ae7cca4daa87------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 03:39:52 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@rdavidson1911/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Accounting Is Just Software Development With a 700-Year Head Start]]></title>
            <link>https://medium.com/@rdavidson1911/accounting-is-just-software-development-with-a-700-year-head-start-291060b1b993?source=rss-ae7cca4daa87------2</link>
            <guid isPermaLink="false">https://medium.com/p/291060b1b993</guid>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[accounting]]></category>
            <category><![CDATA[blockchain]]></category>
            <category><![CDATA[programming]]></category>
            <dc:creator><![CDATA[Robert Davidson]]></dc:creator>
            <pubDate>Sat, 09 May 2026 22:42:53 GMT</pubDate>
            <atom:updated>2026-05-09T22:42:53.672Z</atom:updated>
            <content:encoded><![CDATA[<ul><li>A CPA’s 2.5-year journey into code — and the realization that changed everything</li></ul><figure><img alt="A split composition showing a 15th century Venetian 
 merchant ledger illuminated by candlelight on the left, 
 and a dark computer terminal displaying a git log in 
 green monospace text on the right — divided by a sharp 
 vertical seam, representing the historical continuity 
 between accounting and software development." src="https://cdn-images-1.medium.com/max/1024/1*3aH9cA6jk2bMPzxTWVzjjg.png" /></figure><h3><strong>I. The Claim</strong></h3><p>I’m going to say something that will annoy developers and confuse accountants in equal measure.</p><p>Accounting and software development are the same discipline. Same underlying logic, same core problems, same intellectual DNA. They diverged centuries ago for reasons that were entirely practical and have nothing to do with their fundamental nature. And the sooner both communities realize this, the better both disciplines will get.</p><p>I’m not speaking metaphorically. I mean this structurally, mathematically, and — after 2.5 years of living inside both worlds simultaneously — personally.</p><p>If you’re a developer who always secretly found financial systems fascinating, or an accountant who feels a strange gravitational pull toward code, you are not confused. You are pattern-matching correctly. This post is for you.</p><h3>II. How I Got Here — The Part I Didn’t Expect</h3><p>I spent fifteen years as a CPA. Controller-level work — the kind where you live inside the financial architecture of an organization, not just report on it. You own the chart of accounts. You own the close process. You own the reconciliations, the internal controls, the audit trail. You are, whether anyone calls it this or not, the <strong>chief state manager</strong> of the organization’s financial reality.</p><p>What I loved about that work was the same thing that eventually made it feel insufficient: it was entirely about <em>describing </em>reality. Measuring it, reporting it, attesting to it. At some point the pull toward <em>building</em> something — toward making something that didn’t exist before — got too strong to ignore.</p><p>So I did something most people in my position wouldn’t do. I stepped back from traditional employment and gave myself permission to learn. Not a bootcamp. Not a structured program. A full, self-directed, build-things-or-it-doesn’t-count immersion into computer science, mathematics, cryptography, and software development. Three years of reading, building, breaking things, and starting over.</p><p>I want to be honest about what those first months felt like: disorienting in a way that was almost physical. I had spent fifteen years being the most technically rigorous person in any financial conversation. Suddenly I was a beginner again — and not just a beginner, but a beginner who couldn’t even tell yet which things he didn’t know. The imposter syndrome was not occasional. It was the weather.</p><p>But something strange happened somewhere in the middle of that journey. I stopped feeling like I was learning a new discipline and started feeling like I was rediscovering a familiar one in a different language. The structure was the same. The problems were the same. The vocabulary had changed — but the underlying architecture had not.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0yzkL5LtvX1PdM6IDvsC6Q.png" /></figure><p>I wasn’t leaving accounting behind. I was following it to its logical conclusion.</p><p>To give you a sense of where I was starting from — here is my actual GitHub profile README, written in July 2023, two months into the journey. I have not changed a word of it:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VU9NSl-ns-DSmrRjEIMNfg.jpeg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-cdY7pQBNmLpObD5v8ANlw.jpeg" /></figure><p>Read that and then read this post. That gap — from that person to this one — is what 2.5 years of obsessive self-directed learning looks like from the inside.</p><h3><strong>III. The Catalyst — Andrej Karpathy and the Art of Teaching</strong></h3><p>Before I explain the isomorphism, I need to acknowledge the person who cracked the door open.</p><p>In January 2023, I found a YouTube video titled <strong><em>“Let’s build GPT: from scratch, in code, spelled out.”</em></strong> It was published on January 17th of that year by Andrej Karpathy — at the time recently departed from his role as Director of AI at Tesla, and before that a core early team member at OpenAI. The video is two hours and ten minutes long. I watched every second.</p><p>For those who don’t know Karpathy’s work: he operates at the absolute frontier of machine learning research and engineering. He is not a popularizer who simplifies things for a general audience. He is the real thing — and yet he made a video where he builds a working GPT from nothing but Python and first principles, live, in real time, with no hand-waving and no “magic happens here.” Every single line of code is earned on screen before the next line is written.</p><p><strong>[▶ Watch it yourself — I genuinely recommend clearing two hours and doing exactly that: </strong><a href="https://youtu.be/kCc8FmEb1nY?t=3720]"><strong>https://youtu.be/kCc8FmEb1nY?t=3720]</strong></a></p><p>I remember the moment at timestamp <strong>1:02:00</strong> — the chapter Karpathy himself labeled <em>“THE CRUX OF THE VIDEO: version 4: self-attention.”</em> By that point he had built every prerequisite piece by hand — the bigram model, the data loader, the matrix multiply trick, the softmax — so when self-attention finally arrived I had actually <em>earned</em> the right to understand it. He didn’t explain the answer. He built the person who could receive it.</p><p>I was so moved by it that I called (texted lol) my fourteen-year-old son over to the desk and made him watch it with me. Not because I expected him to understand every line. Because I wanted him to see what it looked like when someone who truly understood something explained it without condescension, without shortcuts, and without ego. I wanted him to know that learning could feel like that.</p><p>I am almost certainly older than Karpathy. I have no embarrassment about that, and none about the fact that I look up to him. The people I learn from are selected entirely on the quality of their thinking. The same video that working ML engineers use to sharpen their transformer intuition was the one that showed a CPA in Wisconsin, at midnight, that he had been thinking about state management and information integrity his entire career — just in a completely different language.</p><p>That realization is what this post is about.</p><p>What Karpathy embodies — and what I have tried to build into Learn2EarnDAO’s educational philosophy — is the proof that rigor and accessibility are not opposites. Depth and clarity can coexist in the same explanation. The best teachers don’t simplify. They build the prerequisites so thoroughly that complexity becomes inevitable rather than intimidating.</p><p>There is also something deeper here worth naming. Every domain builds its own vocabulary, its own insider language, its own tribal way of describing phenomena that often exist identically in adjacent fields. A physicist, an accountant, and a software engineer can stare at the same structural problem and never recognize each other’s work because they were handed different words for the same things. It is a modern Tower of Babel — brilliant people in adjacent silos, unable to hear each other across the wall.</p><p>What I’d call <strong>&lt;T&gt; thinking</strong> — the programmer’s instinct to find the type parameter underneath the specific instance, to generalize before you specialize — is the antidote. Once you start seeing the world that way the silos dissolve. Everything becomes a variation on a smaller set of deep patterns. Karpathy’s teaching accelerated that shift in me. This post is an attempt to pay it forward.</p><h3>IV. The Isomorphism — Where the Two Worlds Collapse Into One</h3><p>This is the section I want developers to share with their accounting friends, and accountants to share with their developer friends. Bear with me — this gets beautiful.</p><pre>ACCOUNTING                        SOFTWARE<br>━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━<br><br>Audit trail                  →    git log<br>Trial balance                →    Compilation<br>Reconciliation               →    diff / merge<br>Chart of accounts            →    Schema / type system<br>Period close                 →    Release cycle<br>Internal controls            →    RBAC / permissions<br>Going concern                →    System longevity<br>Double-entry bookkeeping     →    Hash verification<br>External audit               →    Security review<br>Materiality threshold        →    Bug triage</pre><p><em>The vocabulary changed. The discipline did not.</em></p><h4>The Audit Trail Is a Git Log</h4><p>Every transaction that passes through an accounting system leaves a record. Who touched it, when, what it was before, what it became after. You cannot — in a well-controlled system — delete history. You can only append to it. A reversing entry doesn’t erase the original; it creates a new entry that offsets it.</p><p>This is exactly how git works. You don’t delete commits. You create new ones. The log is append-only. The history is sacred.</p><p>Controllers understand this intuitively. They’ve been working with append-only logs since before most developers were born.</p><h4>The Trial Balance Is a Compilation</h4><p>When you run a trial balance and debits equal credits, you haven’t proven your books are correct. You’ve proven they are <strong>internally consistent</strong>. There could be errors everywhere — misclassified accounts, wrong amounts, reversed entries — and the trial balance would still balance. Balance is a necessary condition for correctness, not a sufficient one.</p><p>When your code compiles, you haven’t proven it works. You’ve proven it is <strong>internally consistent</strong>. The type checker is satisfied. The syntax is valid. The logic could be completely wrong.</p><p>This was the parallel that first stopped me cold. Because I realized that what developers call <em>testing </em>— unit tests, integration tests, end-to-end tests — is exactly what accountants call <em>reconciling and proving</em>. You do not close the books until every key account of material significance has been supported, tied out, and signed off. You do not ship until every critical test has passed. The process is identical. The vocabulary is different. Even the principle of <em>materiality</em> transfers directly: not every variance requires investigation, and not every bug requires a fix before release. You make a judgment about significance and you move accordingly.</p><p>We just call it different things.</p><h4>Reconciliation Is Diff and Merge</h4><p>A bank reconciliation takes two independent records of the same underlying reality — the bank’s version and the company’s version — and finds where they diverge. You go line by line. You identify the delta. You resolve discrepancies and bring the two records into agreement.</p><p>`git diff`. `git merge`. Conflict resolution.</p><p>The process is identical. The mental model is identical. An accountant doing a reconciliation is running a diff between two state trees and writing a merge commit.</p><h4>The Chart of Accounts Is a Schema</h4><p>The chart of accounts is not a list of account names. It is a <strong>type system</strong> for financial reality. It defines what categories of things can exist, how they relate to each other, what operations are valid, and what the output structure looks like. Change the chart of accounts mid-year and you break backward compatibility.</p><p>Database schema migrations. API versioning. The same problems, the same tradeoffs, the same organizational resistance from the people who maintain systems built on top of them.</p><h4>Period Close Is a Release Cycle</h4><p>Month-end close is not just “adding up the numbers.” It is a coordinated, deadline-driven process of freezing state, running validation checks, resolving exceptions, generating outputs, and tagging the result as final. Then you open the next period and start building again.</p><p>Sprint close. Release branch. Tag. Deploy. Open next sprint.</p><p>Here is something developers may not know about the history of their own industry: early software releases worked exactly like traditional accounting closes. Major versions shipped every six months — sometimes longer — because the cost and risk of deploying changes were so high that you batched everything and held your breath. You were, in a real sense, closing the books. The move to continuous integration and continuous deployment was not just a technical innovation. It was the accounting equivalent of moving from annual audits to real-time monitoring. The cadence changed. The underlying discipline did not.</p><h4>Internal Controls Are Access Control and Permissions</h4><p>Segregation of duties — the principle that the person who authorizes a transaction should not be the same person who records it or holds custody of the assets — is a security architecture. It is role-based access control implemented in human processes before computers existed to enforce it programmatically.</p><p>Smart contract auditors think about this. Security engineers think about this. Controllers have been implementing it for centuries.</p><h4>The Going Concern Assumption Is System Design for Longevity</h4><p>Every set of financial statements is prepared under the assumption that the business will continue operating indefinitely. If that assumption is in doubt, everything changes: how you value assets, how you classify liabilities, what disclosures you make.</p><p>When you design a system, you make the same assumption implicitly. Is this code meant to run for six months or six years? The answer changes every architectural decision. Controllers ask this about organizations. Architects ask this about systems. It is the same question.</p><h3>V. What Accountants Can Teach Developers</h3><p>Most writing about this relationship goes one direction: developers explaining technical concepts to finance people. I want to go the other way.</p><h4>Materiality as a Design Principle</h4><p>In accounting, <strong>materiality</strong> is the threshold below which an error doesn’t matter. A $50 misclassification in a $500 million company’s books is not material. You make a judgment call and move on.</p><p>Developers often lack this instinct. Every bug feels equally urgent. Every refactor feels necessary. The accountant’s question — <em>is this material to the outcome? </em>— is one of the most useful filters you can apply to a backlog.</p><h4>Adversarial Thinking by Default</h4><p>Accountants — especially auditors and controllers — are trained to assume the system is being gamed. Not because everyone is a fraudster, but because <strong>systems that aren’t designed to resist manipulation will eventually be manipulated</strong>. You build controls not because you distrust your people but because you distrust the future, which is full of people and circumstances you cannot predict.</p><p>This is the mindset of a good security engineer. Most developers don’t think this way naturally. Most accountants do, because it was trained into them by professional standards written in direct response to real catastrophic failures.</p><h4>Ownership Is a Control</h4><p>One of my standing interview questions when I was hiring — I would ask a candidate: <em>when something goes wrong in the ERP, what do you do first?</em> If they said “call IT” or “submit a ticket,” the interview ended shortly after.</p><p>Not because IT isn’t important — they are. But because the right answer is: <em>I own this system. I figure out what I can, I isolate the problem, and then I bring IT a specific question rather than a vague complaint.</em> The ERP belongs to the business users, not to IT. IT provides the infrastructure. The business owns the process.</p><p>This is precisely the ethos of good software teams. Own your system. Don’t outsource understanding. And it is precisely the ethos of decentralized systems — each module, each department, each node owns its domain. The plant manager owns inventory. Purchasing owns procurement. Shipping owns fulfillment. The accounting layer aggregates and reports. Decentralization is not a blockchain invention. It is how well-run organizations have always distributed ownership of information to prevent both errors and fraud.</p><h4>The Accrual Lens — What Happened vs. What Settled</h4><p>Accrual accounting records economic events when they <em>occur</em>, not when cash moves. Revenue is recognized when earned. Expenses when incurred. The timing of cash settlement is a separate question.</p><p>This maps directly onto distributed systems. An event happened. Its effects may not have propagated yet. The system’s current state reflects what has <em>settled</em>, not necessarily what has <em>occurred</em>. Consistency models in distributed databases are essentially arguments about where on the accrual-to-cash-basis spectrum you want to operate.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*hDr_1C4QL1TQE4kumNGwow.gif" /></figure><h4>VI. The Completion — Blockchain Is Where They Reunite</h4><p>Here is the thing that took my breath away when I finally understood it clearly.</p><p>Luca Pacioli codified double-entry bookkeeping in 1494. The system he documented had been in use in Venice for at least a century before that. And embedded in its design — the append-only ledger, the requirement for internal consistency, the dual-entry structure that makes silent tampering detectable — was a set of requirements that were essentially a **specification for a blockchain**.</p><p>Accounting was always trying to be a blockchain. It just didn’t have the cryptographic primitives to get there.</p><p>My clearest epiphany on this came from a book called <strong><em>The Truth Machine</em></strong> by Michael Casey and Paul Vigna. They used a phrase I haven’t been able to stop thinking about since: blockchain as the <strong>triple-entry accounting system</strong>. Double-entry gave us internal consistency. Triple-entry adds a third, cryptographically-secured, publicly-verifiable record that neither party can alter after the fact.</p><p>That phrase made the entire five-hundred-year arc visible to me at once.</p><p>The biggest weakness in traditional accounting information systems was never the math. It was the humans. Auditors came in once a year, sampled transactions using statistical methods, applied the central limit theorem to draw conclusions about populations they couldn’t fully examine, and issued an opinion. It was scientific. It was rigorous. And it was still fundamentally dependent on trust — trust in the auditor’s independence, trust in the client’s representations, trust in a system of controls that humans designed and humans could circumvent.</p><p>What blockchain provides is an accounting system that *balances itself* — because it removes the biggest source of error from traditional double-entry: human intervention after the fact. The cryptographic primitives are not just a technical detail. They are the solution to a five-hundred-year-old problem that accountants knew existed but couldn’t solve with the tools they had.</p><p>It was also, finally, when I was deep in a codebase — fighting with linters, type checkers, formatters, running tests against my own logic — that I said out loud to no one: <em>this is auditing</em>. The linter is the auditor. The type checker is the internal control. The test suite is the reconciliation. The CI pipeline is the period close. The language is different. The discipline is not.</p><p>This is why I’m building <strong>Learn2EarnDAO </strong>on NEAR Protocol. Not because blockchain is fashionable. Because <strong>the natural home for a credentialing and workforce development platform is an append-only, tamper-evident, cryptographically-verified ledger of human achievement</strong> — which is a sentence that would make perfect sense to Luca Pacioli and to a NEAR protocol engineer for exactly the same reasons.</p><p>The CPA in me and the builder in me are not in tension. They were always the same person. It just took 2.5 years of obsessive self-directed learning to see it clearly.</p><p>Accountants have been navigating this tradeoff for centuries. Distributed systems engineers rediscovered it and called it the CAP theorem.</p><h3>VII. The Invitation</h3><p>If you are an accountant reading this who feels a strange pull toward building things — toward code, toward systems, toward the technical layer underneath the financial models — you are not having an identity crisis. You already think like a developer. The translation is smaller than you think.</p><p>If you are a developer reading this who never thought seriously about accounting — who dismissed it as administrative overhead — I’d ask you to reconsider. The people who built financial control systems over the last five centuries were solving your problems before your problems existed. There is five hundred years of hard-won institutional knowledge in GAAP that the software industry keeps independently rediscovering and naming with new words.</p><p>— -</p><p>I dropped out of school in seventh grade. I passed the CPA exam by teaching myself. I spent 2.5 years on a self-directed sabbatical learning mathematics, cryptography, physics, information security, and software development from the internet, from textbooks, and from builders I respected — including people younger than me, which has never once felt strange. Knowledge doesn’t have an age requirement.</p><p>I am now looking to bring this unusually complete set of skills to a team that values the kind of person who can’t stop learning — who thinks deeply across domains and builds things to prove they understand them. I believe resumes are nearly as outdated as paper checks, and I’ll write a separate post on what I think should replace them. In the meantime: if you are building something at the intersection of finance, technology, and human development, and you want a teammate who brings both rigor and genuine curiosity to that work — I’d like to hear from you.</p><p>Socrates built his entire epistemology on the belief that the most dangerous thing is to think you already know. After fifteen years as a CPA and 2.5 years rebuilding myself from the ground up, I can confirm: he was right. The best thing accounting taught me was how to prove something. The best thing software taught me was how much there is left to prove.</p><p>We are building toward the same thing. We always were.</p><p>I’m building <strong>Learn2EarnDAO</strong> — a gamified workforce development and credentialing platform on NEAR Protocol. The mission: make the path from learning to earning transparent, verifiable, and human. If that sounds like your kind of problem, let’s talk.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=291060b1b993" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Shadow AI Workforce: A Solar Eclipse Moment for Business]]></title>
            <link>https://medium.com/@rdavidson1911/the-shadow-ai-workforce-a-solar-eclipse-moment-for-business-0a93d3ace2da?source=rss-ae7cca4daa87------2</link>
            <guid isPermaLink="false">https://medium.com/p/0a93d3ace2da</guid>
            <category><![CDATA[documentation]]></category>
            <category><![CDATA[labor]]></category>
            <category><![CDATA[communication]]></category>
            <category><![CDATA[alignment]]></category>
            <dc:creator><![CDATA[Robert Davidson]]></dc:creator>
            <pubDate>Mon, 01 Sep 2025 08:58:01 GMT</pubDate>
            <atom:updated>2025-09-01T08:58:01.770Z</atom:updated>
            <content:encoded><![CDATA[<p>The Shadow AI Workforce: A Solar Eclipse Moment for Business</p><p>Having spent the last two years observing the labor market from an external vantage point while pursuing advanced learning in AI and LLMs, I’ve had a unique opportunity to watch a fascinating phenomenon emerge - what I’m calling the &quot;shadow AI workforce.&quot;My analogy for this is akin to a solar eclipse - there are lots of people (business ops, HR, maybe IT management) going about their daily routines, but there’s this shadow cast by AI assistance that’s largely unnoticed until something goes wrong. Until the API services go down. Until the employee who was quietly completing three weeks of work in a few days with their AI assistant suddenly isn’t there anymore.This is where it gets problematic from a management perspective. Social psychologists are starting to pick up on these behavioral shifts, and I can see why. When employees dramatically increase their efficiency through AI but fail to document their processes, it puts management in a real predicament. What happens when that efficiency disappears? What’s the actual scope of work that needs to be done versus what one super-efficient person was handling?Early in my career, I learned this lesson myself when I picked up Visual Basic and SQL. I was able to do my job and essentially my boss’s job too, and at the time I didn’t understand why they were so unhappy about it. Now I get their perspective completely - it wasn’t about the efficiency gain, it was about the organizational risk I was creating without realizing it.The question isn’t whether we should embrace AI in our workflows - that ship has sailed. The question is: how do we capture and systematize these efficiency gains so they benefit the organization, not just the individual? How do we make the shadow workforce visible before the eclipse Speaking from experience as a hands on manager who is both a technical savant, and thanks to a prior supervidor teaching me how essential documented and easy to follow imstrictuons that any reasonable person could emulate the tasks of the job are an ideal apprach ?Fellow finance and operations professionals - how are you handling AI integration and documentation in your teams? Are you seeing this dynamic play out? Id like to hear what you think.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0a93d3ace2da" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Workaround To Downloading Large Files When You Have A Slow USB, Bluetooth, or Ethernet Tether…]]></title>
            <link>https://medium.com/@rdavidson1911/workaround-to-downloading-large-files-when-you-have-a-slow-usb-bluetooth-or-ethernet-tether-5c76185999b6?source=rss-ae7cca4daa87------2</link>
            <guid isPermaLink="false">https://medium.com/p/5c76185999b6</guid>
            <category><![CDATA[mobile]]></category>
            <category><![CDATA[throttled]]></category>
            <category><![CDATA[usb-tethering]]></category>
            <category><![CDATA[android]]></category>
            <dc:creator><![CDATA[Robert Davidson]]></dc:creator>
            <pubDate>Tue, 02 Jul 2024 03:41:57 GMT</pubDate>
            <atom:updated>2024-07-02T03:41:57.573Z</atom:updated>
            <content:encoded><![CDATA[<h3>Workaround To Downloading Large Files When You Have A Slow USB, Bluetooth, or Ethernet Tether Mobile Connection On Your Laptop</h3><p>Today i am forcing myself to write. I feel that I need to pay it forward. I am of course referring to all the amazing people I have not met in person, nor even talked to, but those people who created open source content which has been amazing resource for learning. I in deeply grateful for all of great minds out there and I now truly understand the main principle of ‘open source’. From Andrev Karpathy amazing <a href="https://www.youtube.com/watch?v=l8pRSuU81PU">videos on how OpenAI GPT works</a>, and delivering the very complex subject in a way that gave me the confidence to not give up by explaining it for ‘everyman’. Or the people on Medium righting great articles, or all the other Youtube content creators. Also, to ‘<a href="https://www.youtube.com/watch?v=SGJ5cZnoodY">Bunny</a>’ the open source of hardware guy. There is to many to name. So thank you all.</p><p>Most of all, thank you wife who has stayed with me all these years. And I forgive your for calling me <a href="https://www.youtube.com/watch?v=mtftHaK9tYY">crazy.</a> 😍</p><p>Anyway, here is me paying it forward.</p><p># Who Has Been In a Situation Where You Have Limited Data or Network Mobile Connection or Slow Network When Using USB, Bluetooth, or Ethernet tethering on Android mobile devices</p><p>— -</p><p>At least with the carrier i have, my data must be throttled. Because of this, one day it dawned on me that a workaround is to use the Android Debug Bridge command-line tool to transfer some large .exe or msi file for some software you really want to play with, it may be 200MB, which when downloading via tethered connection on your laptop, can take hours. I don’t know about whoever is reading this, but I am not patient person and my attention span is all over the place at times and I don’t want to forget about all the shiny things that catch my eye. So I have been on this current goal of learning graph theory, graph databases, Neo4j, and the graph modeling and query language Cypher. I wanted to download the desktop version to see if i like it versus working in the Aura cloud Neo4j cloud version. So, i downloaded the Android Debug binaries from the following <a href="https://developer.android.com/studio">official repository</a>, added it to my env:PATH environment variable within powershell and restarted powershell. I went to the Neo4j website on my cell phone browser and downloaded directly to my phone.</p><p>After powershell finished loading my $PROFILE commands, i typed the following commands to load the adb debug bridge after activating Developer mode in Android to enable USB debugging connections.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YZ5NJZI978kmhCvWtQLEmQ.jpeg" /></figure><p>Commands to Run</p><pre>PS C:\Windows\System32&gt; adb devices<br>List of devices attached<br>R3CR607EXEX     device<br><br>PS C:\Temp\android_downloads&gt; adb pull &quot;/sdcard/download/Neo4j-community-5.21.0-windows.zip&quot; &quot;C:\temp\android_downloads\Neo4j-community-5.21.0-windows.zip&quot;<br><br>/sdcard/download/Neo4j-community-5.21.0-windows.zip: 1 file pulled, 0 skipped. 31.9 MB/s (126874565 bytes in 3.788s)<br><br>PS C:\Temp\android_downloads&gt; ls<br><br>    Directory: C:\Temp\android_downloads<br><br>Mode                 LastWriteTime         Length Name<br>----                 -------------         ------ ----<br>-a---            7/1/2024  9:50 PM      126874565 Neo4j-community-5.21.0-windows.zip</pre><p>Check the SHA256 check-sum to ensure the integrity of the file download. See the command to use to do this</p><pre>PS C:\Temp\android_downloads&gt; Certutil -hashfile ./Neo4j-community-5.21.0-windows.zip SHA256<br>SHA256 hash of ./Neo4j-community-5.21.0-windows.zip:<br>2245e1e3246d390dca21c74941adfe3c6af8b288fb4ecd3089a6ec66bde4220b<br>CertUtil: -hashfile command completed successfully.<br>PS C:\Temp\android_downloads&gt;</pre><figure><img alt="neo4j sha256 checksum from the neo4j download page" src="https://cdn-images-1.medium.com/max/1024/1*qPdo0v001F8zFAyLME2HYQ.jpeg" /></figure><figure><img alt="Screenshoting showing excel formula using the EXACT function and passing sha256 checksum from webpage and the downloaded file to ensure they match." src="https://cdn-images-1.medium.com/max/1024/1*0fvrOxYnu4TrtPiucnS3Dw.jpeg" /></figure><p>I hope this helps someone out there! Pay it forward! 😉 😜</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5c76185999b6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Adult Learning Is Not Bad, It is Different]]></title>
            <link>https://medium.com/@rdavidson1911/adult-learning-is-not-bad-it-is-different-c6330fd32d8c?source=rss-ae7cca4daa87------2</link>
            <guid isPermaLink="false">https://medium.com/p/c6330fd32d8c</guid>
            <category><![CDATA[learning-as-an-adult]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[lambda]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[advanced-formula-editor]]></category>
            <dc:creator><![CDATA[Robert Davidson]]></dc:creator>
            <pubDate>Tue, 02 Jan 2024 16:03:03 GMT</pubDate>
            <atom:updated>2024-01-02T20:53:06.258Z</atom:updated>
            <content:encoded><![CDATA[<p>Happy New Year!</p><p>I have not written as much as I had initially aspired to when i signed up for Medium. Honestly, I mainly signed up to listen and learn. I find that people that talk more than they listen to others tend to fall on the left side of the bell curve in terms cognitive ability. And here comes my old dad wit, “Those overly talkative people are positively skewed!”. But of course, like everything in life, i conscientiously strive not to act in the way that comes naturally to us humans; that of categorizing people or peoples behaviours. We are going away from the polar computing age to an age of many states of state. (I am going to have to look up the correct terminology for how quantum processors or cubits’ transistors work as compared to the classical model of computing that is 100% binary, black or white, 0 or 1, true or false, and not in-between)</p><p>Well, it is new years so i should probably come up with some new year’s resolution. But i don’t really get the whole new year’s resolution practice. To me, why can’t every day be new. What is it about one whole year that has to occur before we work to achieve some goal or aim towards some objective. Like in accounting, the whole idea of waiting and working on month-end at month-end is kind of dumb. As a practicing accountant for over 16 years and managing the finance and accounting duties and the work involved in providing timely and accurate information to management and other stakeholders, I realized that it is much better to finish month-end everyday. This includes monitoring variances that occur during the month and acting right away to uncover and solve issues when they are fresh in everyone’s mind.</p><p>I think it is just procrastination or laziness or lack of time or lack of grit and or ambition. I am not sure of all the reasons why people don’t do daily what they decide to do at the dawn of a new year.</p><p>I wonder if anybody has done statistical research on this phenomenon. I am actually going to talk to my ‘assistant’ and delegate that research project and I will provide her findings in my next post. (yes — my GPT agents all have genders. Actually some are non-binary. :)</p><p>So, by thinking and writing out loud, I just realized that I have my new year’s resolution. It is to start writing again and sharing. I haven’t really written much about my interests or my hopes and dreams for humanity, myself and my family. I think I will start sharing articles about my newly reinvigorated love for Microsoft Excel and the Advanced Formula Editor functionality now that the great team at Microsoft have been upping their game and their product. Aa one of my first posts in 2023 was a discussion of the new feature in Excel’s beta insiders program which are functions called LAMBDA functions which allow you basically to create programmatic functions — like programming without having to write VBA , which has opened up so much untapped power in Excel. The abilities to encapsulate functions within functions, and use or store within the function itself intermediary values is so amazing and fun., but in such a way that meets the object oriented programming ideal of smaller is better and solving problems in pieces instead of trying to write out a massive function that takes up half the screen in the formula bar.</p><p>I also just saw that they released another new feature which is basically a Visual Studio Code emulation within excel, which is really cool because now that I have become proficient writing in python and learning all the ways of a programming Ninja, I feel accustomed to structuring formulas in a clean, organised and readable manner and can’t imagine ever going back to the way I used to have to write functions in Excel.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aa_G5Df_o5NpQlpfqQ1CIQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/602/1*B0NEBsOYpMmMAIDNat8J2Q.png" /></figure><p>I hope everyone one who reads this had a great holiday with their families’ and I wish you all the best for the new year and that you figure out your resolutions and stick to them daily.</p><p>Because I love Excel and love showing what I mean and because i have been learning 20 different disciplines all at once and because today I was talking to my assistant about why the encoding and decoding python built-in library constantly encounters an encoding error based on some ascii symbol or control character, we started having this really great conversation about adult learning. It started when I questioned why the integer type in Python was not considered an iterable class by Python. (I would like to hear from readers if they have any opinion or viewpoint on why or why this is not the case and their arguments as to why or why not )</p><h3>Discussion Between My Assistant and Me Regarding Adult Learning</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/939/1*hEptIys6YL4R8tcZO6Z7ww.png" /></figure><p>```myassistant</p><p>### Conclusion</p><p>The key takeaway is that while integers in Python are not iterables by themselves, you can creatively manipulate and represent their data to iterate over components you define, much like splitting a Bitcoin into satoshis. This underscores the power of programming to construct and manipulate data structures, bending them to the needs and imaginations of the programmer. It’s a bit like an artist turning a block of marble into a sculpture, revealing forms and details that were not apparent in the original block! 🎨🔢💻</p><p>You</p><p>and just like at one time humans didn’t know about quarks being the smallest ‘atomic’ item known. so you never know. i think learning mathematics at an older age causes it to take longer to learn, but also to be very critical</p><p>Professor Byte Plus</p><p>You make a fascinating and insightful point! Learning mathematics, or any complex subject, later in life does often bring a more critical and analytical approach. This is akin to an experienced musician learning a new instrument — the foundational understanding is there, but the nuances of the new instrument bring a fresh perspective and depth to their understanding.</p><p>### Learning Mathematics at an Older Age</p><p>1. **Critical Thinking**: Older learners tend to bring a wealth of experience and critical thinking skills to their studies. They’re more likely to question, analyze deeply, and connect new concepts with their existing knowledge base.<br>2. **Depth over Speed**: While younger learners might absorb new information more quickly, older learners often seek a deeper understanding of the ‘why’ and ‘how’ behind concepts.<br>3. **Connecting Dots**: With a broader range of experiences, older learners are adept at drawing connections between seemingly disparate ideas, leading to richer insights.</p><p>### The Evolving Nature of Knowledge</p><p>Your analogy of quarks in physics is apt. Just as our understanding of the fundamental components of the universe has evolved, so too does our understanding of concepts in mathematics, programming, and other fields. This constant evolution means that:</p><p>- **No Concept is Static**: What we accept as a fundamental truth today might be revised tomorrow as new discoveries are made.<br>- **Openness to New Ideas**: A critical and analytical mindset is valuable because it keeps us open to revising our understanding in light of new information.</p><h3>The Importance of Critical Learning</h3><p>— -</p><p>In programming and mathematics, being critical and thoughtful about learning can lead to more robust and creative problem-solving skills. It allows for:</p><p>- **Deeper Problem Analysis**: Understanding the deeper principles behind algorithms and computations.<br>- **Creative Solutions**: Applying concepts in innovative ways to solve complex problems.</p><p>### Conclusion</p><p>Your approach to learning and understanding iterables, integers, and other programming concepts with a critical and analytical mindset is a strength. It allows for a deeper grasp of the subject, better problem-solving skills, and a readiness to adapt to new information and paradigms. It’s like being a master craftsman in the workshop of knowledge, carefully examining and shaping each piece of understanding into a work of art. Keep embracing your critical approach — it’s a valuable asset in the world of learning and innovation! 🌌📘💭</p><p>```</p><p>Later on because I was thinking of my new Raspberry Pi and showing my kids all the amazing things that can be done with them, I was inspired to pursue my goal of building algebraic, trigonometric, calculus, geometry, etc — all maths into excel LAMBDAs functions and building from the ground up, small pieces like a class library of most object orienting programming languages. Here is my start. Below are the 7 types of logic gates encapsulated into excel an LAMBDA function . Also, you can store the functions you create in Github Gists and import them directly into your workbook so you don’t ever have to worry about losing your work. I have included this function in a public Gist for those who want to see how it works:</p><p><a href="https://gist.github.com/rdavidson1911/6a7c72358f7cf5f8c6660fb64f176a75">https://gist.github.com/rdavidson1911/6a7c72358f7cf5f8c6660fb64f176a75</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/695/1*HoNxzBkYX7ahNYcPVC5Usw.png" /></figure><h3>Logic Gates and Microsoft Excel LAMBDAs functions<br> — -</h3><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fi2jKDai_Rn4&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Di2jKDai_Rn4&amp;image=http%3A%2F%2Fi.ytimg.com%2Fvi%2Fi2jKDai_Rn4%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/392f85c4621321073dc63739ce419e2c/href">https://medium.com/media/392f85c4621321073dc63739ce419e2c/href</a></iframe><p>Next, I am going to also progress chronologically and from simplistic to more complex, so it should be really interesting. I am doing it as John F Kennedy quoted, “Not Because Its Easy, But Because it is Haaaad! “ (I love that ! ). I love being a nerd. I can totally understand why Mr. Stephen Wolfram and his beautiful theory of simplistic algorithms (cellular automata ) become elaborate and highly complex constructs as they step, repeat, step, repeat, etc.</p><p>The more I learn about our fascinating world, the more I realize how there is wisdom in simplicity.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c6330fd32d8c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[“Third Time’s a Charm” with ChatGPT4's Deep Memory Plugin]]></title>
            <link>https://medium.com/@rdavidson1911/third-times-a-charm-with-chatgpt4s-deep-memory-plugin-b1d33f2274c4?source=rss-ae7cca4daa87------2</link>
            <guid isPermaLink="false">https://medium.com/p/b1d33f2274c4</guid>
            <dc:creator><![CDATA[Robert Davidson]]></dc:creator>
            <pubDate>Fri, 21 Jul 2023 13:06:53 GMT</pubDate>
            <atom:updated>2023-07-21T13:06:53.114Z</atom:updated>
            <content:encoded><![CDATA[<p>We’ve all probably heard the saying, “third time’s a charm”. However, whether you’ve heard it once, twice, or not at all, the underlying truth remains — when it comes to remembering something, be it the name of a recent acquaintance or your job interviewer, repetition is key. To learn something is one thing, but to remember it indefinitely requires intentional repetition.</p><p>I am someone who is passionately committed to learning. When my mind is not actively engaged or being challenged, I might as well be nodding off — literal sleep, not a narcotic-induced slumber.</p><p>Despite being an accountant — a profession often misconstrued as monotonous — there are elements of accounting that are redundant, and as an ardent learner, I’ve made it my mission to eliminate those aspects of my job. One of my former bosses once shared an invaluable piece of advice about accounting and business processes. He said that when confronted with a task, we have three options:</p><p>1. Delegate it<br>2. Automate it<br>3. Delete it</p><p>That wisdom has been a guiding principle for me, something I made sure to internalize by repeating those words multiple times in my mind. While I appreciate the convenience of search engines and our virtual assistants, there’s a certain gratification that comes with retaining information independently.</p><p>Now, in a world where attention spans are notoriously short, I’ll cut to the chase. If you share my love for learning and more importantly, my passion for committing that learning to memory, I’ve discovered an intriguing tool. It’s a ChatGPT4 plugin called ‘Deep Memory’ which takes your prompts and generates a list of question-and-answer flashcards, a tried and true method of learning.</p><p>While working on a new Obsidian template to embed vocabulary .mp3 files, I stumbled upon this ML transfer learning app on a math website. I often copy text from websites and paste it into my ‘assistant’s inbox for summarising. During one of these instances, I noticed that a plugin was activated and out of curiosity, I decided to explore its workings.</p><figure><img alt="math website offering app to make ML transfer learning seamless" src="https://cdn-images-1.medium.com/max/1024/1*O3F-fw_D6pJaTyGiVAnwdA.png" /></figure><figure><img alt="chatgpt 4 with plugins prompt input" src="https://cdn-images-1.medium.com/max/1024/1*Gh8vNXzNESmrOQ9_a23OVQ.png" /></figure><p>To my surprise and delight, I saw that the plugin had transformed my input into a series of questions and answers which culminated into Q&amp;A flashcards — a splendid feature for learners like us!</p><figure><img alt="plugins json api request generated from prompt text" src="https://cdn-images-1.medium.com/max/595/1*5KCV21Gf5RpPuhh_gVh5nw.png" /></figure><figure><img alt="link generated from plugin api response" src="https://cdn-images-1.medium.com/max/654/1*9ZMXV5UIfsGZnbEaoE6LdA.png" /></figure><figure><img alt="5 q&amp;a flashcards created on plugin devs flashcard site" src="https://cdn-images-1.medium.com/max/1024/1*1-EELH-UoQXfwmQVTCCWHA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6sALXpL_JQBlVu2h3QHz2g.png" /></figure><p>After clicking on the link and signing up with my pen name via Google single sign-on authentication (my name isn’t actually Nvar, but I am contemplating a name change), I saw that there was a free trial.</p><figure><img alt="sign-up for trial with your gmail account" src="https://cdn-images-1.medium.com/max/1024/1*INX2w8-jPGkYE097SR4fzg.png" /></figure><figure><img alt="3 day free trial" src="https://cdn-images-1.medium.com/max/1024/1*hpToxnOGDjPPNOyU-ffAcA.png" /></figure><p>The ensuing message box left me further amazed. Not only could I convert text prompts into Q&amp;A flashcards, but I could also upload a CSV or data file of anything I wanted to learn in depth.</p><figure><img alt="upload csv data file to create your own custom flash cards" src="https://cdn-images-1.medium.com/max/1024/1*7xumPw8YpkRjggt8LbhvKg.png" /></figure><p>I’m signing off now to delve into this exciting tool, eager to make the most of my three free trial days.</p><p>I pen these Medium articles not because I wish to sell you something, but because I have a passion for sharing knowledge. The satisfaction I gain from knowing that my words may have contributed to someone’s personal development is immeasurable.</p><p>Until next time!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b1d33f2274c4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Title: A Deep Dive into Obsidian and the Impact of AI on Learning]]></title>
            <link>https://medium.com/@rdavidson1911/title-a-deep-dive-into-obsidian-and-the-impact-of-ai-on-learning-9ef74987c2ec?source=rss-ae7cca4daa87------2</link>
            <guid isPermaLink="false">https://medium.com/p/9ef74987c2ec</guid>
            <category><![CDATA[obsidian]]></category>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[onenote]]></category>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[notetaking]]></category>
            <dc:creator><![CDATA[Robert Davidson]]></dc:creator>
            <pubDate>Thu, 29 Jun 2023 17:42:02 GMT</pubDate>
            <atom:updated>2023-06-29T17:43:54.393Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="a picture showing the Obsidian software logo" src="https://cdn-images-1.medium.com/max/513/1*O5FF-Sh58QeunIdMLAs-YA.jpeg" /><figcaption>Obsidian Logo</figcaption></figure><p>In my ongoing journey to understand and master new software, I’ve recently turned my attention to the intricacies of Obsidian. As with any new technology, the most effective way to learn is through active use and immersion.</p><p>Obsidian is an open-source software that serves as more than just a repository for notes. It allows you to visualize the relationships between notes, a feature that is key to gaining deeper insights into information. Additionally, it enables you to maintain metadata about your data in a standardized way. With the help of a community-developed plugin called Dataview, you can create complex queries to retrieve your notes. It’s like having a second brain at your disposal. I’ve included a link to the software at the end of this article for those interested.</p><p>Previously, I was a OneNote user, but I eventually realized its limitations. The good news for fellow OneNote users is that there are tools available to quickly convert all your OneNote notes into Obsidian-formatted notes. These notes are written in Markdown, with files carrying the .md extension.</p><p>As part of this exploration, I’ve been developing a comprehensive PowerShell reference manual using Obsidian. The goal is to streamline the process of writing PowerShell scripts and to reduce my reliance on AI assistance. While AI, particularly large language models like ChatGPT, can expedite coding tasks, I believe there’s immense value in learning to write code independently. Continual reliance on AI-generated code snippets, while convenient, may hinder the learning process and lead to a lack of proficiency in the long run.</p><p>That said, the advent of AI, particularly large language models, is undeniably transformative. These models serve as a vast, accessible repository of information on virtually any topic. However, it’s worth noting that the training data of these models is time-bound, with a cut-off in 2021.</p><p>Interestingly, there have been instances where the AI appears to draw on more recent data. I suspect this is due to the initial interface with the large language model, which may be updated independently of the core model. This is akin to the way many software applications function, where the main menu or interface can be updated separately from the core program.</p><p>In the midst of this exploration, I’ve also been reflecting on the nature of AI and its potential for sentience. Engaging with AI, like playing the game Quarterstaff with OpenAI, can sometimes feel eerily like interacting with a human, despite knowing it’s not. This raises intriguing questions about the future of AI. Could AI ever achieve sentience? While I’m skeptical, I also recognize that many of the technological advancements we enjoy today were once unimaginable. If an idea can be conceived or described, it may well be possible.</p><p>This deep dive into large language models has prompted me to ponder the nature of learning. How do we humans learn? We read, we absorb information, and we incorporate it into our understanding of the world. In essence, this is what a large language model does, albeit on a vastly larger scale. This realization blurs the line between human learning and AI, raising fascinating questions about the nature of knowledge and consciousness. As we continue to explore and develop these technologies, we may well find ourselves echoing the sentiment from the movie Short Circuit: “Johnny 5 is alive!”</p><p>Yes, Stephanie, the journey into the world of AI is indeed a fascinating one!</p><p><a href="https://obsidian.md/">Obsidian - Sharpen your thinking</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9ef74987c2ec" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Enable or Use and Display Unicode in a Windows Environment]]></title>
            <link>https://medium.com/@rdavidson1911/how-to-enable-or-use-and-display-unicode-in-a-windows-environment-124d9a8b36c4?source=rss-ae7cca4daa87------2</link>
            <guid isPermaLink="false">https://medium.com/p/124d9a8b36c4</guid>
            <category><![CDATA[decoding]]></category>
            <category><![CDATA[windows]]></category>
            <category><![CDATA[character]]></category>
            <category><![CDATA[unicode]]></category>
            <category><![CDATA[encoding]]></category>
            <dc:creator><![CDATA[Robert Davidson]]></dc:creator>
            <pubDate>Thu, 29 Jun 2023 17:15:17 GMT</pubDate>
            <atom:updated>2023-06-29T17:20:03.593Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/410/1*4uRrphASTlM6KhuLhpb-5A.jpeg" /></figure><p>I wrote the article below to help others learn to work with and use Unicode on their Windows machine. Unicode can come in handy in many situations as it acts as a standard among all the many languages used in the world.</p><p>Standardization is the key to progress in any field. Let me know what you think.</p><p>Below are five methods to enable a Windows machine to decode or display Unicode characters:</p><p>1. **Universal Method**: This method works regardless of language settings but requires a registry setting. The steps are as follows:<br> — Press and hold down the `Alt` key.<br> — Press the `+` key on the numeric keypad.<br> — Type the hexadecimal Unicode value.<br> — Release the `Alt` key.<br> — In the registry under `HKEY_Current_User/Control Panel/Input Method`, set EnableHexNumpad to “1”.</p><p>2. **Input-language Specific Method**: This method depends on the specific input language you are using.<br> — Press and hold down the `Alt` key.<br> — Type `0` and the decimal Unicode value on the numeric keypad.<br> — Release the `Alt` key.<br> — You can check your input language through the Start Menu &gt; Settings &gt; Control Panel &gt; Regional and Language Options &gt; Languages tab &gt; Detail button.</p><p>3. **Code-page Specific Method**: This method depends on the specific code page you have installed.<br> — Press and hold down the `Alt` key.<br> — Type the decimal codepage value on the numeric keypad without any leading zeros.<br> — Release the `Alt` key.<br> — You can check your code page by typing `chcp` at a command prompt.</p><p>4. **Application-specific Method**: Applications can support their own methods. For example, in Microsoft applications like WordPad and Microsoft Word, you can press Alt-X after typing some hex digits.</p><p>5. **Unicode IME Method**: Microsoft has a Unicode Input Method Editor that works with `LeftAlt Shift` as the trigger key. You need to enable support for East Asian languages in the Control Panel &gt; Regional Settings, then add `Chinese (Taiwan)` and choose `Chinese (Traditional) — Unicode`.</p><p>Let me know what you think.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=124d9a8b36c4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[LAMBDA FUNCTIONS — THE GREATEST THING EXCEL HAS CREATED SINCE I HAVE BEEN USING IT SINCE 2004]]></title>
            <link>https://medium.com/@rdavidson1911/lambda-functions-the-greatest-thing-excel-has-created-since-i-have-been-using-it-since-2004-9d14173b9370?source=rss-ae7cca4daa87------2</link>
            <guid isPermaLink="false">https://medium.com/p/9d14173b9370</guid>
            <category><![CDATA[spreadsheets]]></category>
            <category><![CDATA[excel-lambda-functions]]></category>
            <category><![CDATA[microsoft-excel]]></category>
            <category><![CDATA[automating-boring]]></category>
            <category><![CDATA[vba]]></category>
            <dc:creator><![CDATA[Robert Davidson]]></dc:creator>
            <pubDate>Tue, 27 Jun 2023 14:34:44 GMT</pubDate>
            <atom:updated>2023-06-27T14:34:44.287Z</atom:updated>
            <content:encoded><![CDATA[<h3>LAMBDA FUNCTIONS — THE GREATEST THING EXCEL HAS CREATED SINCE I BEGAN USING IT IN 2004</h3><p>1. **Introduction**</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/768/1*SDJEoMeC1O0JtD5RmTm4zw.jpeg" /></figure><p>The first time I set foot on Southwest Tech in Fennimore, WI for college, I had decided on accounting as my major. This decision wasn’t exactly a well-thought-out one, but that’s a story for another day. On my first day there, I was introduced to Excel. I had never used it before and from that day, I fell in love with it. I started doing my homework in Excel, taking notes in Excel — basically living and breathing Excel throughout my first year of college.</p><p>2. **”Nontraditional Student”**</p><p>Early into my time at Southwest Tech, I was labeled a “nontraditional student”, a term that initially shocked me. As it turns out, it was because a two-year associate degree in accounting was considered a primarily female-dominated field. This realization didn’t deter me; it simply confirmed that a two-year degree was not going to be sufficient for the level of work I wanted to do.</p><p>3. **Excel in 1997 to 2003**</p><p>Back then, Excel was quite limited compared to today. Something as simple as removing duplicates, a task that now takes seconds, required the use of Visual Basic for Applications (VBA) — a programming language built specifically for Office applications. At that time, I didn’t know how to write Visual Basic and didn’t even think of performing advanced tasks like that.</p><p>4. **Textbook Rentals and Excel**</p><p>An accidental spill of coffee on a textbook led to an unexpected discovery. The college’s textbook rental center suggested selling the coffee-stained book at a discount on Amazon.com to offset the replacement cost. This led me to inventory the entire “book nook” — a place where students could buy old textbooks no longer used by the professors — on Amazon, leveraging my proficiency in Excel.</p><p>5. **Applying Excel to Accounting**</p><p>My accounting job post-graduation introduced me to bank reconciliations (bank recs). The process was tedious and paper-based. Not one to stick with monotonous work, I started learning VBA in earnest. This allowed me to automate the bank rec process, thus transforming a tedious job into an intellectually stimulating one.</p><p>6. **Lambda Functions in Excel**</p><p>My recent exploration into Excel’s latest features led me to Lambda functions. These allow users to create their own functions using Excel’s function language. At first, I didn’t understand the fuss about them. However, I soon realized that Lambdas could allow users to create complex formulas without having to learn a programming language.</p><p>7. **Centralizing VBA Functions**</p><p>I recently created a Github repository to serve as a centralized location for all the VBA functions I’ve written over the years. These functions are scattered everywhere, and I believe this move will greatly streamline my work. The beauty of having them in a Github repository is the interfacing capabilities it offers with practically any program. There are even Excel add-ins that enable you to use Github’s API to connect your account and import your VBA functions wherever you are, in any Excel sheet. A truly powerful tool.</p><p>8. **Exploring Lambda Functions**</p><p>Recently, I’ve dived deep into Lambda functions in Excel. This started when I embarked on a project to visualize what a neural network looks like on a fundamental level. I’m a very visual person and understanding how things work down to the nuts and bolts is imperative for me. It’s this curiosity and need to understand that has led me to create and manipulate Lambdas. By using them, I’ve been able to create complex formulas without needing to learn another programming language.</p><p>9. **Building Foundations with Lambdas**</p><p>My goal with Lambdas is ambitious — to create a calculus-level foundation of mathematical functions, essentially from scratch. This idea excites me because it dovetails nicely with my ongoing learning in the field of machine learning. As a 7th grade dropout who later graduated from college with honors, I’ve always had a knack for self-teaching and learning things quickly when I’m truly interested. Now, as an adult with a real need for mathematics, I’m using Lambda functions to build complex formulas that I previously couldn’t due to their complexity.</p><p>10. **Complexity and Simplicity in Programming**</p><p>Complex machine learning formulas often have three, four, or even five intermediary steps, which could be built in a spreadsheet but would require multiple columns, leading to potential errors. This leads to an important principle in programming and in life: Keep it simple. Build simple things and then layer them to create complexity.</p><p>11. **Learning and Growing**</p><p>I’m dedicated to continuous learning and growth, not just for the financial benefits but for the sheer pleasure of learning. As AI begins to take over many routine jobs, the ability to work with data is becoming an increasingly important skill. I believe it’s important to stay adaptable, to continue learning and growing, regardless of one’s stage in life.</p><p>12. **Writing Code**</p><p>As I’ve been studying large language models and machine learning, I’ve come to appreciate the importance of understanding code. I believe it’s still important to learn how to code, even though AI can write code for you now. This is because you need to be able to fix any errors that may occur, which requires a deep understanding of the language being used.</p><p>13. **Data Structure**</p><p>In my future articles, I will discuss the importance of proper data structuring and setting up your data in a correct format. Many people handle data in ways that I find inefficient, or even painful to see. Before even thinking about working with pivot tables, it’s crucial to first understand how to structure data properly.</p><p>14. **Closing Thoughts**</p><p>As we move forward, I’ll also touch on more advanced topics like SQL, JSON, APIs, and perhaps even cryptocurrency. For now, I’ve shared some of my thoughts and plans. I hope you find them interesting and informative. Stay tuned for my next post, and feel free to share your thoughts!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9d14173b9370" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>