<?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 Yoko Spirig on Medium]]></title>
        <description><![CDATA[Stories by Yoko Spirig on Medium]]></description>
        <link>https://medium.com/@yokospirig?source=rss-625d2aec88b1------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*ijWeuBzu_bnb8OOt4QJlcw.jpeg</url>
            <title>Stories by Yoko Spirig on Medium</title>
            <link>https://medium.com/@yokospirig?source=rss-625d2aec88b1------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 04:45:35 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@yokospirig/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[How to explain ESOP to future team members?]]></title>
            <link>https://yokospirig.medium.com/how-to-explain-esop-to-future-team-members-8229cff26cfc?source=rss-625d2aec88b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/8229cff26cfc</guid>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[hiring]]></category>
            <category><![CDATA[stock-options]]></category>
            <dc:creator><![CDATA[Yoko Spirig]]></dc:creator>
            <pubDate>Wed, 16 Mar 2022 09:11:10 GMT</pubDate>
            <atom:updated>2022-03-16T09:11:10.923Z</atom:updated>
            <content:encoded><![CDATA[<p>I often get asked the question by fellow founders “how can we best explain the value of ESOP to future employees?”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/904/1*xE32uQQc63nDlxLr-hSP0A.png" /><figcaption>Question by a founder friend on whatsapp</figcaption></figure><p>Here’s a step by step guide:</p><ol><li>Explain the system: In our case, the equity we grant is a percentage of the cash salary that comes on top.</li><li>Show the value of the equity in 3 different scenarios: a) Valuation at the upcoming round b) Valuation in 4 years c) Moonshot valuation (e.g. unicorn).</li><li>Explain the mechanics: Vesting, cliff and exercise window. We wrote this <a href="https://ledgy.com/blog/explaining-employee-plans/">guide</a> to help explain these mechanics.</li><li>Show them how their grant will look like in your ownership software of choice, like Ledgy ;) This helps to show that equity is not a one-off topic but that it is taken seriously and in a transparent way all along.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AEUCHDi6N7fbfyzhPiS3Uw.png" /><figcaption>ledgy.com</figcaption></figure><p>Hope this helps and please reach out if you have any further questions!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8229cff26cfc" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[We’ve just raised our Series A ]]></title>
            <link>https://yokospirig.medium.com/weve-just-raised-our-series-a-2c302442626?source=rss-625d2aec88b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/2c302442626</guid>
            <category><![CDATA[fundraising]]></category>
            <category><![CDATA[series-a]]></category>
            <dc:creator><![CDATA[Yoko Spirig]]></dc:creator>
            <pubDate>Mon, 13 Sep 2021 16:28:25 GMT</pubDate>
            <atom:updated>2021-09-13T16:28:25.538Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Originally published on the </em><a href="https://ledgy.com/blog/ledgy-raises-series-a/"><em>Ledgy blog</em></a><em>.</em></p><p>We’ve just raised our Series A led by Sequoia with the participation of Xavier Niel, Harry Stebbings, Visionaries Club, and several leading SaaS founders including UiPath’s Daniel Dines and Front’s Mathilde Collin. Our existing investors and early supporters Myke Näf, Paul Sevinç, btov Partners, Creathor Ventures and VI Partners participated as well.</p><p>Luciana Lixandru is joining our board and our entire team at Ledgy is incredibly excited to partner with her and Sequoia to build the global platform for ownership.</p><h3>Looking back 🔎</h3><p>For our team and myself, our first words after closing this round are about gratitude. We want to thank our <a href="https://ledgy.com/about-us/">entire team of Ledgistas</a>, our existing investors, advisors and our customers who supported us since the beginning.</p><p>Raising a Series A has been a huge growth and learning process for me and I was lucky to benefit from many great advisors and resources about fundraising. Here are some lessons I learned along the way — I hope that they can benefit founders who are about to go through a similar journey.</p><h3>Learnings 🤓</h3><h4><strong>1. Dare to think big</strong></h4><p>One of our team members asked me: “How did you even dare to pitch Sequoia? I mean it’s <em>Sequoia</em>?!” I’ll share one secret: I would have never thought we would end up partnering with Luciana and the Sequoia team when we started to fundraise :) This is not to come across as falsely humble or unconfident. I’m rather sharing this because I think that if more people who think they’re not good enough would actually try things out more boldly, many more great companies would be created. So my top piece of advice is: Aim for the very best you can think of in anything you do. And don’t be disappointed if you fail: at least you will have tried.</p><h4><strong>2. Have a solid process</strong></h4><p>Having a very systematic yet simple enough process in place through our fundraising was key to success. Some of the tactics we used:</p><ul><li>Have an investor kanban on which you track the progress of all investors you are speaking with (we used Notion).</li><li>Have a weekly email informing your board on the progress of the fundraise. This helps keep everyone aligned and holds you accountable.</li><li>Create a data room in Notion including your KPIs, investor FAQs, financial projections, cohort analysis, etc. Having this ready before you start your fundraise is a good idea since after the first calls things can move very fast.</li></ul><p>A couple of great resources:</p><ul><li>Probably the most helpful resource on Series A I found:<a href="https://www.ycombinator.com/library/14-series-a-guide"> Y Combinator’s Series A guide</a></li><li>Mathilde Collin’s excellent<a href="https://collinmathilde.medium.com/front-series-a-deck-f2e2775a419b"> blog post and Series A deck</a> — Mathilde is one of my personal role models and I’m so happy she’s an investor in our Series A! :)</li><li><a href="http://fundraisingally.com/">Fundraisingally.com</a> — Shout out to Pascal Koenig for putting this together, super helpful.</li><li><a href="http://fundraisingfieldguide.com/">Fundraisingfieldguide.com</a></li></ul><h4><strong>3. Have a great team and advisors</strong></h4><p>This fundraise couldn’t have happened without a great team. First, it takes a lot of the founders’ time to fundraise, meaning the rest of the team has to jump in to compensate and help. Being intentional and transparent about your shift of focus and delegating your responsibilities during this phase is important. Second, especially as a first-time founder, it was key to get advice from board members, advisors and fellow founders. I couldn’t be more grateful to all the people who helped us in this process.</p><h3>Looking ahead 🔭</h3><p>At Ledgy our mission is to empower teams to be owners. Our vision is to build the global platform for ownership. We believe that the world’s biggest challenges will be solved by entrepreneurs, and that democratizing company ownership can be the difference between short-term growth and truly enduring success.</p><p>On our way to fulfil our mission and vision, our next step is to strengthen our presence in the rest of continental Europe as well as in the UK to finally establish a standard way for companies to manage ownership. Second, we will increase our feature set to better support public companies as well — a number of them are on Ledgy already.</p><p>To achieve the above goals we are expanding our team, and we are looking for fellow Ledgistas to join us on our mission — apply <a href="https://ledgy.com/jobs/">here</a>!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XhpaopuhaWIgHfOGZVyxGg.jpeg" /><figcaption>Some of the Ledgy team</figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2c302442626" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Raising a convertible loan in times of Corona]]></title>
            <link>https://yokospirig.medium.com/raising-a-convertible-loan-in-times-of-corona-ff67d9f530aa?source=rss-625d2aec88b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/ff67d9f530aa</guid>
            <category><![CDATA[pandemic]]></category>
            <category><![CDATA[share-learnings]]></category>
            <category><![CDATA[convertible-notes]]></category>
            <category><![CDATA[coronavirus]]></category>
            <category><![CDATA[fundraising]]></category>
            <dc:creator><![CDATA[Yoko Spirig]]></dc:creator>
            <pubDate>Mon, 18 May 2020 19:03:45 GMT</pubDate>
            <atom:updated>2020-05-20T08:59:27.311Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ovpr87Xj-qimCGAJaRYpaA.jpeg" /></figure><p><em>This post was originally published on the </em><a href="https://ledgy.com/blog/raising-a-convertible-loan-in-times-of-corona"><em>Ledgy blog</em></a><em>.</em></p><p>At Ledgy, we’ve raised a <a href="https://www.eu-startups.com/2018/12/ledgy-raises-funding/">Seed round</a> in 2018 of €1m. To bridge towards Series A, we decided to raise a convertible loan. We had made this decision before the Corona-crisis kicked in, but since the signing happened at the peak of the global outburst, the pandemic still played a role on the final loan structure. The whole process was overall super efficient, lasting one month in total. Since we believe that many companies are currently preparing to confront the bumpy months ahead, among others with convertible loans, we wanted to share what we’ve learned.</p><h4>The process</h4><p>In total, from the time we had the first parameters ready (pitch deck, financial projections, loan size) and the final signing, it took us one month. And from the time the terms were agreed upon and the signing, it was roughly two weeks. We tried to make it as simple as possible and just used a trello-board and a google doc to keep track of every step. This simple measure was nevertheless key, because the main challenge is to keep the momentum even though many parties are involved, so having an overview of the progress with e.g. a kanban-board is important.</p><p>Here’s how the process looked like step-by-step:</p><ul><li>We agreed with the board on the pitch deck, financial projection, loan size and a table showing the pro-rata of each investor. A note here: The preparation of the pitch deck, took a significant amount of time—ca. one month including feedback from advisors—prior to the start of fundraising. Many first-time founders including us at the beginning, tend, I think, to underestimate the importance of having a great pitch deck. Investing enough time in this is key, not only in order to have a clear message when you start raising but it also has the nice side effect of creating an internal alignment about the strategy of the company.</li><li>We reached out to all investors in a 30min 1–1 call giving them an update about why we raise a convertible, current business numbers and how much their pro-rata would amount to. At this point the terms were not yet finally decided.</li><li>In parallel to the calls with investors, we discussed and decided the terms with our lead investor and our board. It’s important to take the final decision together with your board. Indeed, the board members have the responsibility to decide on the best terms for the company.</li><li>We sent the final terms to all investors. In parallel, we finalized the legal side, i.e. a binding convertible loan agreement.</li><li>The very last step was then to invite all investors to sign the agreement—of course <a href="https://support.ledgy.com/how-to-use-digital-signatures-on-ledgy">digitally on Ledgy</a>!</li></ul><h4>The learnings</h4><p>What we learned along the way:</p><ul><li>As first-time founders it was at first not clear to us how to best tackle a convertible loan with existing investors. The usual process is actually to agree on terms with your lead investor and also most importantly with your board. Usually, no further negotiations are required with the other investors.</li><li>Our most trusted advisors are also our investors. This means that it was sometimes tricky to seek advice on e.g. terms from investors who had both an advisor-hat and an investor-hat. What worked well here, was to make this paradox transparent and to address it at the beginning of the conversation: “I know you have two roles as both an investor and advisor to the company. I’d love to hear your opinion about X, from both perspectives.”</li><li>Negotiation: For me personally, it was tough to negotiate with people I really appreciate to work with and to whom I feel very grateful for their support, namely our board members. Indeed, unlike an equity round which requires negotiations with a new lead investor, in the case of a convertible loan round with existing investors, you have to agree on the terms with your existing lead investor and board members. The main learning for me here was a basic principle of negotiation: Be clear about what’s important to you on the content but be nice on the formulation. This allows to set a clear boundary between the business and personal side of things.</li><li>Terms: As founders it’s important to get informed about what the market standards are. In our case we used our own resources based on aggregated data statistics, <a href="https://ledgy.com/blog/examples-of-convertible-notes">as written in our blog post</a>. We then also asked fellow founders, investors and our lawyer. Also, we used Ledgy’s <a href="https://support.ledgy.com/simulating-convertible-loan-conversions-together-with-investments">round modeling functionality</a> to simulate in seconds the effect of different loan parameters and sizes on the cap table.</li><li>Impact of corona: Of course the fact that the pandemic just kicked in, meant that the general economic situation was much more risky. Therefore investors will tend to be more risk averse and will want to have terms that reflect this riskier environment. On the other hand, if the company has been doing well lately, it strongly speaks for better terms in favor of the company. Overall, it’s important to find a good middle way here. In our case, we agreed on standard terms and adjusted 1–2 parameters to be more investor-friendly than usual to take the economic situation into account.</li><li>Trust: Last but not least, one of the main reasons why the process went so smoothly and fast is because a strong relationship of trust was already established between the investors and our company before we even started to raise. Indeed <a href="https://support.ledgy.com/webinar-how-to-report-to-your-investors">we report to all investors every month in a very transparent way on Ledgy</a>. Therefore, there were no surprises on the investors’ side about the status of the business. The personal 1–1 calls at the beginning of the fundraising mentioned above also contributed to establishing trust.</li></ul><p>We wish everyone a lot of resilience and stamina in these tough times! Further helpful <a href="https://ledgy.com/blog/examples-of-convertible-notes">resources</a> include:</p><ul><li><a href="https://www.gruenderszene.de/business/coronavirus-startups-gruender-checkliste-btov">Checklist to be prepared for the crisis</a> by our investor Andreas Goeldi</li><li><a href="https://ledgy.com/blog/free-digital-signatures">Ledgy’s corona crisis-offer</a> of free signatures and financing round modeling to all startups.</li></ul><p>Feel free to reach out if you have any feedback or questions to contact@ledgy.com!</p><p><em>This post and many more resources can be found on ledgy.com/blog</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ff67d9f530aa" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[React Hooks in 1 minute]]></title>
            <link>https://yokospirig.medium.com/react-hooks-in-1-minute-e0f9c15d08d5?source=rss-625d2aec88b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/e0f9c15d08d5</guid>
            <category><![CDATA[react]]></category>
            <category><![CDATA[javascript]]></category>
            <category><![CDATA[react-hook]]></category>
            <dc:creator><![CDATA[Yoko Spirig]]></dc:creator>
            <pubDate>Tue, 19 Mar 2019 21:27:00 GMT</pubDate>
            <atom:updated>2019-03-19T21:27:00.701Z</atom:updated>
            <content:encoded><![CDATA[<p>This is how you write a component with a state with the React framework traditionally. Notice the state variable on the second line.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZYt01Hanf-isoLAoKPRnbw.png" /></figure><p>This is how you write a component with a state with React Hooks. Notice that there’s no state variable defined.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/852/1*G3jEDRxeaz0Zsg2g-rYWOQ.png" /></figure><p>You see that the only difference is, with React Hooks you don’t define a state variable but, instead, the function useState, included in the React framework, does it for you. That’s very basically what React Hooks does.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e0f9c15d08d5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The basics of pre- and post-money option pools]]></title>
            <link>https://medium.com/ledgy/the-basics-of-pre-and-post-money-option-pools-4aeceea340e9?source=rss-625d2aec88b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/4aeceea340e9</guid>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[employee-engagement]]></category>
            <category><![CDATA[stock-options]]></category>
            <category><![CDATA[legal]]></category>
            <dc:creator><![CDATA[Yoko Spirig]]></dc:creator>
            <pubDate>Wed, 20 Feb 2019 22:08:14 GMT</pubDate>
            <atom:updated>2019-03-25T21:24:03.238Z</atom:updated>
            <content:encoded><![CDATA[<p>If you’ve never understood what’s a pre- and post-money option pool, here’s your chance. Get a piece of paper and a pencil, write down the formulas and don’t give up until the end of this post!</p><h4>How it all started</h4><p>Sheryl and Elon are two good friends who decided to cofound a company called SpaceBook (the social network for aspiring communities on Mars). Their initial cap table looks as below, with the total number of shares being <br>1 million:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*zxKhypIA2GzlGjsprMeAzg.png" /></figure><p>They now want to raise a seed round. They manage to get a deal with an investor, Peter:</p><ul><li>Peter invests $500,000</li><li>Everyone agrees on a pre-money valuation of $5 million</li></ul><p>This means that Peter will receive 9.09% of the company. How do we know that?</p><ul><li>We know the price per share = pre-money valuation / total number of shares pre-money = $5 million / 1 million shares = $5</li><li>Peter will receive the following number of shares: her investment / price per share = 100,000 shares</li><li>The new total number of shares in the company is 1 million + 100,000 = 1.1 million</li><li>Peter’s total number of shares / new total number of shares in the company = 9.09%</li></ul><h4>Option Pool</h4><p>Now that Sheryl, Elon and Peter have agreed on the basic deal, they start talking about reserving shares for employees, i.e. creating a stock option pool. There are basically two possibilites: a pre-money (aka investor friendly) or a post-money (aka founder friendly) option pool. The naming is a little confusing since different people use the naming pre or post for different purposes, so make sure you know if you are talking about an investor or founder friendly pool. I will explain in more details what each of them means below — for now, read on.</p><p>Let’s say we want to create an option pool of <strong>10%</strong> (in the fully diluted cap table after the capital increase), i.e. the <em>№ </em><strong>shares in option pool </strong>has to be equal to 10% of the total number of shares after the investment. In this case the following equation is true:</p><p>(Sheryl + Elon+ Peter)’ shares = <strong>90%</strong> * ((Sheryl + Elon+ Peter)’ shares + <em>№ </em><strong>shares in option pool </strong>)</p><p>Simply reshuffling and isolating the terms, we have:</p><blockquote><strong>№</strong> <strong>shares in option pool </strong>= (Sheryl + Elon+ <strong>Peter</strong>’s shares) * (1/90% -1)</blockquote><p>Think thoroughly about this, and once you understand it, just accept it and notice <strong>one important thing we’ll need later on: The <em>№</em> shares in the option pool depends on the number of Peter’s shares.</strong></p><h4><strong>So, what is a post-money (founder friendly) option pool?</strong></h4><p>Very easy to calculate and understand. The round is done as explained above. Then an option pool of 10% is created, which dilutes everyone. In this case, Peter will end up with less than the planned 9.09%, after the pool is created.</p><h4><strong>What is a pre-money (investor friendly) option pool?</strong></h4><p>This is tricky to calculate because it involves equations that have to be solved numerically. And it’s founders-unfriendly, because only the founders (Sheryl and Elon) get diluted. In which case would Sheryl and Elon go for a pre-money pool? In the event that Peter for instance says “A deal is a deal. With or without the option pool, I want to have my 9.09% for my $500,000 investment as agreed before this whole pool story!“</p><p>This means, the shares created for the pool have to be created, so to say, <strong>before</strong> Peter invests in the company, so that he does not get diluted. In other words, the price per share that Peter will pay will diminish from: pre-money valuation / (Sheryl + Elon’s shares), to: pre-money valuation / (Sheryl+ Elon’s shares + <strong>Option pool shares</strong>). This again means, that if Peter gets a cheaper price per share, then he will get more shares for her $500,000 investment. An important detail to be noticed here:<strong> The number of Peter’s shares </strong>depends on the number of shares in the option pool!<br>By now, you should see that we have a “problem“: The number of shares in the option pool depends on the number of Peter’s shares because it has to represent exactly 10% of the total shares after the capital increase. On the other hand, the number of Peter’s shares also depends on the number of shares in the option pool because her stake also needs to be exactly 9.09% as agreed during the deal. This is why we need to solve this numerically which is what Ledgy’s round modeling does.</p><h4><strong>Still wondering if you should go for a pre- or post-money option pool?</strong></h4><p>As stated above, the post-money is friendlier for the founders. But if your investors insist on a pre-money pool, you can also for example negotiate the company’s valuation to be higher in order to reach a win-win situation.</p><p>Please reach out if anything’s unclear. By the way, on Ledgy, you don’t need to care about these formulas, because they are done for you in the background.</p><p><a href="https://www.ledgy.com/">The missing accounting software for your cap table</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4aeceea340e9" width="1" height="1" alt=""><hr><p><a href="https://medium.com/ledgy/the-basics-of-pre-and-post-money-option-pools-4aeceea340e9">The basics of pre- and post-money option pools</a> was originally published in <a href="https://medium.com/ledgy">Ledgy</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[CSV export]]></title>
            <link>https://medium.com/ledgy/csv-export-96215c180194?source=rss-625d2aec88b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/96215c180194</guid>
            <category><![CDATA[import-export]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[help]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[cap-table]]></category>
            <dc:creator><![CDATA[Yoko Spirig]]></dc:creator>
            <pubDate>Tue, 31 Jul 2018 16:22:44 GMT</pubDate>
            <atom:updated>2018-07-31T16:22:44.195Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*u7fb5vghcVeF5S2DYxrhiA.jpeg" /></figure><p>Ledgy lets you export all your data as CSV files. You might be thinking “Well great, but I hate all the formatting problems when opening CSV in Excel or Google Sheets”. Don’t worry we’ve thought about this and here’s a step-by-step guide to import CSV with all special characters and numbers well-formatted.</p><h4>TL;DR</h4><p>To open your CSV file optimally in Microsoft Excel or Google Sheets you need to make sure that</p><ul><li>The encoding is <strong>UTF-8</strong></li><li>The decimal separator is a dot → <strong>.</strong></li><li>The thousand separator is a comma → <strong>,</strong></li></ul><h4>Quick guide to open CSV in Excel</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/468/1*4sl6cMaoKhkD8xqjUu0lww.png" /></figure><ol><li>Open a blank excel sheet.</li><li>In the <em>Data</em> menu click on <em>From Text.</em></li><li>Select your CSV file exported from Ledgy.</li><li>In the import window, make sure the encoding is set to Unicode (UTF-8). Choose the format <em>Delimited — Characters such as commas or tabs separate each field</em>. Click on next.</li><li>Choose Delimiters to be Comma. Click on next.</li><li>Click on <em>Advanced…</em> and set decimal separator to dot (<strong>.</strong>) and thousands separator to comma (<strong>,</strong>).</li><li>Click on ok and finish.</li></ol><h4><strong>Quick guide to open CSV in Google Sheets</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/389/1*TVvMQJbn-Pq21RUbDlvWAw.png" /></figure><ol><li>Create a blank google sheet.</li><li>Click on <em>File → Import</em>. Choose the Upload tab and upload your CSV file.</li><li>The window on the left-hand side will pop up.</li><li>Since Google should be able to automatically detect the formatting, just click on <em>Import data</em> and you’re done.</li></ol><h4>Learnings</h4><p>With a score of 4 against 7 setup steps Google does a better job than Microsoft to import CSV files 😃</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=96215c180194" width="1" height="1" alt=""><hr><p><a href="https://medium.com/ledgy/csv-export-96215c180194">CSV export</a> was originally published in <a href="https://medium.com/ledgy">Ledgy</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Our interview at Y Combinator]]></title>
            <link>https://medium.com/ledgy/our-interview-at-y-combinator-e1131fd89ecc?source=rss-625d2aec88b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/e1131fd89ecc</guid>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[switzerland]]></category>
            <category><![CDATA[news]]></category>
            <category><![CDATA[ycombinator]]></category>
            <dc:creator><![CDATA[Yoko Spirig]]></dc:creator>
            <pubDate>Wed, 13 Dec 2017 15:11:14 GMT</pubDate>
            <atom:updated>2018-07-18T10:56:47.799Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9xXIvLa-80Zg3jJrq6VdYw.png" /></figure><p>Do you know how many Swiss startups have ever been funded by YC?</p><p><a href="http://world.ycombinator.com/"><em>0, Null, Nada </em></a><em>— and this needs to change!</em></p><p>In this post we’ll describe our experience of being selected for an interview at the YC headquarters in Mountain View, California. And why it’s important for Switzerland that more startups apply to YC.</p><p>Two months ago, when we were still a three months old startup, we sent our written application for the Winter 2017 batch. Although some people said it was too early, it felt natural for us to apply because YC focuses more on the team’s potential than on how far you are in your product development. You also need to attach a video to the application, which <a href="http://www.ycombinator.com/video/">doesn’t have to be formal at all</a>.</p><p>Ten days later, we were invited for a video call with a YC partner. As far as we know, they do this with all non-US founders, since they need to invest much more in travel costs to invite us to their office (yup, they cover your travel expenses, which is pretty fair!).</p><p>Our video interview lasted ten minutes and was in a rather relaxed atmosphere: more like a conversation than an interview. Still, we prepared for it like a real interview and had all numbers and answers to standard questions ready.</p><p>One week later, we found the great news in our mailbox:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/952/1*vb0LKzOROa_KNUGXe-Hebw.png" /></figure><p>Of course, we were super excited and started right away to prepare our trip. Just before leaving <a href="http://blog.ledgy.com/ledgy-launches-online-cap-table-tool-d1c141618b40">we also launched our app</a>, so it was overall a very intense time.</p><p>We prepared for the interview by reading a lot of reports from previous applicants. <a href="https://www.linkedin.com/pulse/y-combinator-how-nail-interview-barak-ben-ezer/">This article</a> encapsulates quite well how to prepare for the basics. On top of that, we tried to read as much as possible about our field. For the interview it’s critical to be as up-to-date as possible, more on that below.</p><p>After flying over the pond to Mountain View and a few days of settling in, the big day arrived. The picture below shows Yoko and Ben waiting for our interview in <a href="https://www.ycombinator.com/atyc/">the room where once a week the entire YC batch meets</a> and listens to talks from eminent entrepreneurs.</p><p>After a few minutes of waiting we were warmly welcomed by four YC partners. After the classical opening “so tell us what you’re doing”, we were bombarded with questions during ten minutes. It wasn’t much about the standard “who are your customers, what is your growth rate, what is your IP, etc” but rather about the challenges and bottlenecks. They try to find the weak spots — not because they’re mean, but because they want to find out how well you understand the field you’re working on, and if you can come up with smart ideas.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bLsub09yIpBsezXPEO2mKg.png" /></figure><p>You receive feedback the same day. Either with a call if you’re funded or by email if you’re not. Unfortunately, we received an email in the evening telling us they wouldn’t fund us this time. We were of course quite disappointed but hey, even Drew Houston from Dropbox got rejected the first time!</p><p>In the email we also got some good feedback from their side. Furthermore, we were in touch with a YC partner who even introduced us to a YC hacker in our field. We ended up meeting for an hour in San Francisco, which was really awesome.</p><p>Overall it was a great adventure and we’re looking forward to our next trip to Mountain View!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*ukoIzn21UJ0gLqm3LbTJrw.png" /></figure><h3><strong>Lessons learned</strong></h3><p><em>Apply</em>—The application process and the feedback we got from top entrepreneurs and investors is totally worth it.</p><p><em>More Swiss startups should apply — </em>Our guess is that not enough Swiss startups apply in the first place, so the number of companies getting funded is naturally low. The data shows that if one company from a country gets in, the chances are higher for the next ones. Hence, it’s even more important that at least one company makes it. We are in touch with YC partners and engineers to try to organize a YC info event in Zurich next year.</p><p><em>Have deep insights in your field—</em>In hindsight, the best way to prepare for the YC interview is really to know a lot in your field. The YC partners should learn something new from you to be impressed. The standard KPIs and numbers you can find everywhere are still important and you should know them. But the part making the difference is really if you have smart ideas about difficult problems.</p><p><em>Focus—</em>We were in a period of reflection about our startup, triggered through the interview preparation. Our time in the Silicon Valley reminded us how critical focus is for an early stage startup.</p><p><em>Americans are crazier and friendlier—</em>One impression we immediately got after a few days in the states is that everyone is much more open and sees an interaction with a stranger as an opportunity rather than a problem. And about the craziness, well… maybe get your first impression by watching the performance of the <a href="https://www.youtube.com/watch?v=I14b-C67EXY">former Microsoft CEO</a>. Got it? Okay, we’re not saying that’s the way. It’s more about the way of taking yourself less seriously, that is sometimes missing in the Swiss world. You don’t have to be perfect or behave perfectly to be taken seriously. So just apply to YC, even if you feel unsure.</p><p><em>That’s it! Don’t hesitate to </em><a href="http://www.ledgy.com/contact"><em>get in touch with us</em></a><em> if you consider applying. We’re happy to tell you more about our experience. And if you happen to be in Zurich, we like coffee and beer.</em></p><p><a href="https://www.ledgy.com/">The missing accounting software for your cap table</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e1131fd89ecc" width="1" height="1" alt=""><hr><p><a href="https://medium.com/ledgy/our-interview-at-y-combinator-e1131fd89ecc">Our interview at Y Combinator</a> was originally published in <a href="https://medium.com/ledgy">Ledgy</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>