Archive for the ‘Talks’ Category

Funding Your Startup

Monday, September 8th, 2008

Yesterday, I was interviewed by TVB Pearl Money Magazine, a local TV program, about startup funding, particularly VC funding. I’m no expert but EditGrid did run through a few stages and was supported by different types of fund including bank loan, angels, government fund and VC.

If you are doing a startup, perhaps the following Q&As may be interesting to you.

1. Background on your business (nature of what you do).

We make online spreadsheet: EditGrid. It runs on a “Software as a Service (SaaS)” business model.

2. Can you take us back to the beginning of your business: How did you start? What was the first thing you had to do? Where did you get funding?

We started the company before we graduate from HKU. We graduated in 2004, one year after the disease SARS hit Hong Kong badly. The opportunity cost of doing a startup cannot be lower.

The first thing we did was to build a team by pooling all the best people I can find at that time. We had some ideas to start with, but honestly it tends to change a lot down the road when we have more knowledge to generate better vision of the world. We always put the team first, thus our company name: Team and Concepts - team is before and more important than concepts.

Then we needed money. Our solution was to borrow. When you do startup, you need to take the risk.

Later, we have angel investors and government funding. But they usually come in after you’ve something more solid.

3. Moving on to VC funding: at what point did you decide to seek venture capital?

The way VC really works is to have money chasing deals. VCs are in the business of funding the best investment opportunities they can find. Probably you will know you are ready when you are tracked by a few VCs who actively approach you and try to know more about you, your company and product.

To reach this point, you need to build traction. That’s buzz around your product, users using your product, customers paying your product, big name partners working with you, etc. VCs want to see where you are now more than where you will be in the future. VCs want visibility of exit. I would say a business plan and a quality team is NOT what they want the most. They want to see some solid execution that has already been done.

4. What was the process like? How do you go about doing that?

A VC approached us and looked at our company, determined we have potential but a bit early stage for them. He made lots of referral to some series A VCs. A few of them found us interesting and send a representative to visit us in our office and watch the demo. Some asked me to make a demo to all their partners in Beijing. (note: VC tends to have all partners in the company endorse a deal before they move forward). The term sheet was signed a few days after the meeting - before I left Beijing. It was fast. From that point to cash in bank took about 2 months.

We didn’t submit any business plan. The key part of the subsequent due diligence was a number calls to our clients and partners.

5. What are the pros and cons of selling stakes of your business to venture capitals or other private equity investors, for that matter?

Acceleration. Taking VC fund accelerate your success or failure. Of course, the VC will also enjoy a big part of your success at pay day.

With more money, we can hire good people and can focus to do what make sense for our business.

6. Has anything changed ever since you got investors on board?

Our series A investor is WI Harper, they are good and entrepreneur friendly. So, they largely leave us alone to take our company forward and always be available to give advice and help when we need them.

If you have chance, try to take money from reputable VCs.

7. For those with an idea to start up their own business, what’s the best route to getting funding? When does private investment come into the picture?

Take risk for your company. Focus to do one thing and one thing only. Do it better than anybody else in the world. The market and the VCs will tell you when you are ready.

Introducing EditGrid Macro: Trendy, Mighty, Friendly

Thursday, September 4th, 2008

Why EditGrid macro? Rapid application development using spreadsheet as a component. Enhancing spreadsheet to add custom features. Mashing up data from Web 2.0 web service providers.

JavaScript. EditGrid Macros are written in JavaScript, not in VBA. Use a modern language, instead of learning another (otherwise useless) proprietary language. Use the comfortable and familiar C++/Java syntax. Write in OOP and higher order functions.

Powerful. EditGrid Macros can create forms, which are defined using HTML (plus CSS) and manipulated using DOM. You can add everything you would add to your blog/website e.g. YouTube video and Google Maps. It is also possible use SOAP and REST to retrieve data and manipulate other data from other sites, enough for mashing up with other web services.

Asynchronous. EditGrid Macros are executed independent of the spreadsheet. It does not block other spreadsheet features like when you make a blocking function call such as VBA’s MsgBox(”text”, vbYesNo). This is essential to spreadsheets with Real-Time-Update across collaborators. By executing macros on the client side, we ensure that macros can provide the best interactions towards users, while can still access spreadsheet data and operations on our server side.

We put our money where our mouth is. Instead of writing some Hello World alike macros, which our competitor did, we decided to write something inspiring & useful.

Custom Behavior

HTML Toolbox

Mash-up

Pay Calculators

Tuesday, September 2nd, 2008

Gconnect.in, a community website for government officers in India, has picked EditGrid’s calculator widget to publish a few calculators for a new pay scheme.

They are highly popular. At peak hours, the spreadsheets see thousands of concurrent users. In a few days, they have been visited more than 1 million times. Finally we have a spreadsheet that can challenge the popularity of the adr spreadsheet regularly visited by thousands of people every day.

It also seems to us that these popular spreadsheets were moved to EditGrid from another service.

Well, competition and choice are always a good thing for end users.

EditGrid = Data * Spreadsheet * On Demand

Thursday, June 19th, 2008

It’s been a while since we’ve updated you on what’s been keeping us busy here at EditGrid. Today we’re excited to announce a new core feature for the EditGrid platform: Data Functions. But first a little background…

The Competitive World of Spreadsheets

EditGrid has some tough competition. In fact, we often hear from friends how impressed they are with EditGrid’s product usually followed by a comment about how incredibly difficult it must be to compete with Microsoft and Google in this market segment. We’re well aware of the challenges we face. Between Microsoft’s dominant desktop productivity suite, Google’s brand and web presence to help it grow its web-based suite, and the incredible pool of resources at both companies, to say that EditGrid is an underdog would definitely be an understatement! Nonetheless, the strength of our competition has forced us to stay focused and relentlessly work on improving our product and user experience. As part of our drive to compete in this market we’ve decided to focus on data as a way to help differentiate us from our competitors and help our users create more and better spreadsheet content.

Data and Spreadsheets On Demand

EditGrid has come a long way in the last year and half. Today we offer a critical mass of spreadsheet features such as functions, formatting, and shortcut keys (sorry, no pivot tables just yet!), which make EditGrid as usable as your desktop spreadsheet. In addition, we’ve added a critical mass of web features such as sharing, collaboration, and publishing, which allow EditGrid to serve new use cases for spreadsheets on the web. Today we are taking our first step towards delivering a critical mass of data as well.

To get things started, we’ve made available stock and news data from Reuters, and partnered with StrikeIron and Xignite to expose some of their API data and services in EditGrid. In total we’re launching with 41 functions in 7 categories - all of which you can use to pull live data directly into your spreadsheet for further analysis or presentation. See the complete list at the bottom.

By delivering both data and spreadsheets on demand, we can significantly enhance the value of our standalone spreadsheet component. Easy access to live and automatic data will help our users create compelling spreadsheet content that will motivate increased sharing and collaboration in EditGrid. With today’s release it’s now possible for our users to create advanced valuation models and summary sheets for stocks, or to analyze trends in web startup funding and traffic, to name just a few of the possibilities. Of course, we’ll continue to add more and more data to EditGrid and are confident that in both the near and long term there will be exciting developments on this front. Be sure to drop by our forum to tell us what data you want as well as to share your work with others.

Here are a few examples:

Live data from Alexa, Compete and Yahoo! Finance is used to calculate a startup valuation.

Analyst estimates and recommendations come together in this spreadsheet to help you compare a stock with a few of its competitors.

Enjoy!

A series of unfortunate events occurred

Saturday, August 18th, 2007

A series of unfortunate events occurred, but EditGrid is there up and running 70 minutes later. It is normal our customers will complain to us for such a long outage, especially those who use our service for the serious work. I would see this as a lucky event which allows us to experience what is disaster recovery. Lucky? Yes, not many Web 2.0 start-ups got an opportunity to demonstrate their robust recovery plan (or the lack thereof).

Since we believe that EditGrid is not only known for its amazing amount of features, but also the transparency that we deliver to our users, I will try my best to explain all the work we have done during the 70 minutes of outage. In addition to your applause for our having done a good job, this article serves another purpose, that we owe publicly our users some improvements to the system that are of critical help to prevent another such incident from happening, or reduce the affected time even when it occurs unfortunately. If you are impatient, you can skip to the last paragraph.

We begin with some background. It was just yesterday, that we got an alert on our production system, a preventive alert that warned us of our growing user base and usage exceeding the capacity of our system. As a result, we deployed an extra machine into the production server farm, and arranged another stand-by machine.

Today at around 15:10 (all time are UTC hereinafter), we received an alert on our production system, the same alert occurred yesterday. Obviously, we begin to believe that the alert is again due to the same preventive warning, which is fired when our system responds too slowly to requests. For the first few minutes, we examined the servers one by one, trying to locate the cause. We examined every component but cannot find a clue on why they suddenly become slower than normal.

Starting from around 15:20, we noticed that the number of requests going into the servers started to reduce sharply, and eventually stopped a couple of minutes later. We believed that this is due to failure of the automatic recovery mechanism. We then went through all the servers, attempting to restart each component manually. Interestingly, one specific component, after being stopped, took forever to start.

At around 15:40, we eventually identified it to be a failure of the database server. The database process is running, but when we issue it a request, we simply got no response, not even an error. Having confirmed this behavior using a few different machines, we believe that it has to be the problem of the server itself. We decided to restart it. The result is what everyone can expect. Upon start-up, the server immediately crashed.

We tried a vast number of varying configuration parameters, but the database server still refuses to start. We attempted to resort to converting the backup database server into the primary one. It turns out that due to a totally unrelated event, *all* the backup database servers stopped replicating the primary server a number of hours ago. If we wanted to promote it as a primary server, we have to wait until it as replicated all the changes till the time we stopped the primary server. We have stop-watched, and this will take over an hour to finish.

On the other hand, we began searching the web for solutions to the reasons the server crashes. We identified a bug report for the version we are running that sounds related. Coincidentally we have recently started testing a newer version of the database server in our QA environment. With a little bit of hesitation, we copied the new version into our production system (which takes some time due to the overseas file transfer) and attempted to start the new version. It worked!

It only seemed to work. It works when we created a spreadsheet, but not when we attempt to login. Then we noticed a lot of errors from the server, complaining about invalid indexes on some tables. We immediately executed some SQL queries to repair the corresponding table indexes and everything really worked. Time flew, and it is already 16:30.

Can we do better? We are not in a position to make sure our database have no bug. But we should be alerted when the backup database server failed to keep synchronised with the primary server. We should also have better mechanisms, than enumerating all servers and components, to identify the faulty one. In the best case, the outage can be much shortened. We will definitely learn from all events and keep our service stable. In any case, you can rest assured, that your data are still here, though it may take some more time for them to be recovered.

EditGrid participates in Office 2.0 Conference

Monday, August 13th, 2007
O2conBanner.gif

You may have heard the buzz. The second Office 2.0 Conference is going to be held on 5th - 7th September, 2007 in St. Regis Hotel, San Francisco — and we are going there. While it will be a lonely 12-hour trip from Hongkong to San Francisco for us, we will find familiar company at the conference — CentralDesktop, ThinkFree as well as our friends in the OpenSAM consortium are among some of the partners on our growing partner list that we’ll be meeting there. Some of them we’ll be meeting in person for the first time. We’re looking forward to that.

At the conference we will launch the EditGrid iPhone edition. The iPhone has taken mobile productivity to the next level, and we will demonstrate how EditGrid can help our users take advantage of that to get real-time updated data on their fingertip. This is also to celebrate the iPhone experiment in the Office 2.0 Conference.

In case you don’t know it yet, the second Office 2.0 Conference, organised by Ismael Ghalimi of IT|Redux, is not only a conference to explore the future of online productivity and collaboration but also an annual gathering for Office 2.0 folks to meet, learn and have fun. The conference line-up is impressive. It follows the tantalising success of the first Office 2.0 Conference. Follow the buzz here.

This will be the most important event EditGrid has ever participated in after the Under the Radar: Why Office 2.0 Matters conference. We’d love to reach out to more partners and customers and we hope that you’ll join us there.

More live tables and charts

Tuesday, July 10th, 2007

Although great standards like (X)HTML and CSS defined by W3C already work smoothly on the Web, we still find them a little bit insufficient for presenting effectively graphical and tabular data, which is common with such as statistical and analytical information.

Tables are natively supported by HTML, but they are far from being convenient for non-technical people to use; charts are not easy either — most probably you’ll have to extract a chart from your desktop spreadsheet application, save it as an image file and upload it to somewhere before you can really display it on your web page. Worst of all, the tables and charts are static.

We therefore make EditGrid best for publishing live tables and charts. Charts for stock analysis can now be generated dynamically from real time data, and you get 30+ different kinds of useful charts to choose. Neat and tidy statistical tables can be embedded in your online experiment report, or you can update scores in your online tournament tables directly from your EditGrid spreadsheet. All you need to do is just getting a permalink for a chart, and copying and pasting a piece of readily available code for a table.

What if you’ve already drawn up a nice illustration and would like to post it on EditGrid? We also support inserting custom (static) images into EditGrid spreadsheets. Simply paste your link and everything is done! (Question: What if you’d like to insert a dynamic image that depends on parameters and, better still, these parameters are on your EditGrid spreadsheets? Watch this space :P)

450px-morecharts_3.png
Chart Gallery 1
450px-morecharts_4.png
Chart Gallery 2

We believe sooner or later you will find more tables and charts on the Internet. They are live, and generated by EditGrid.

EditGrid’s capability to incorporate financial data

Wednesday, July 4th, 2007

What would EditGrid mean to you other than a spreadsheet application? Our smart users have demonstrated some of the great uses in the financial world.

This spreadsheet makes good use of the power of remote data. It fetches stock quotes of the Hong Kong Hang Seng Index companies and incorporates them in conjunction with the latest prices of the corresponding ADRs. In this way it compares the stocks’ performance in the two markets and, owing to the 13-hour time difference between New York and Hongkong, predicts the resulting impact to the Hang Seng Index on the next day.

Additionally, its second sheet comprises a comparison between prices of H-shares listed in Hong Kong and the corresponding prices of A-shares in Shanghai. You may probably discover that the prices in Hong Kong are to some extent influenced by the A-shares.

The spreadsheet has become one of the most popular spreadsheet on editgrid.com. Many visitors keep their eyes on the ADRs every night (in Hong Kong time) and the A-shares every morning. It really showcases EditGrid’s capabilities to manage and structure financial data (and most importantly the data is live!) in order to create useful presentations of instant market trends, analysis and even charts .

450px-finance_1.png
Hong Kong ADR prices to affect HSI and H-shares vs A-shares

450px-finance_2.png
Live currencies exchange table


Our team has also made a number of spreadsheets that contain the quotes of the component stocks of the world major indexes, including DJI and GSPC of US, HSI and HSCEI of Hongkong, and a live currencies exchange table, etc.

Similar usage can be found in this spreadsheet, where world major indexes quotes are centralized to produce a nice watch-list for busy investors.

Have you thought of any other clever usage of EditGrid to manage your portfolio?