With our users’ enthusiastic submissions, our team watched the coming of our 100th Featured Spreadsheet, published just earlier this week!

Since the very first Featured Spreadsheet came out, we’ve visited more than 1000 pieces of nicely made spreadsheets now. Looking through these various spreadsheets is a fruitful and engaging experience. We understand more of your EditGrid usages on areas like finance, and SMEs. Our team’s got thrilled by these skills and designs. We trully enjoy it!

We hope to highlight everyone the most exciting, and popular EditGrid spreadsheets. A piece of new featured spreadsheet gets published every two or three days. In general, these spreadsheets gain a visitor boost of at least 200 per day while it is exhibited at the upper left corner of the EditGrid webpage. All published featured spreadsheets will be stored at the Featured Spreadsheet page and get displayed later on at the upper left exhibit section.

Look forward to the birth of the next 100 Featured Spreadsheets. Submit us your spreadsheets and let’s speed this process up together!

We are introducing two major improvements in this month’s release, one being our redesigned workspace and the other is the optimization of our grid. We have also added two new ecommerce remote data packs.

Redesigned Workspace

You’ve probably noticed your EditGrid workspace looks different today. The revamped workspace offers three improvements, the use of AJAX, a left sidebar and a filter function. Our goal is to offer a workspace where users can get what they need effortlessly and efficiently.

• AJAX dialog windows
  By using AJAX in our workspace, we have introduced a faster and smoother interface to our workspace. Instead of loading new pages for each action, i.e. edit tag, edit note, upload, sharing, etc., like the previous workspace, all these actions are now done on the fly and changes will be reflected immediately in the book list.
• Left sidebar
  The addition of the left sidebar improves file browsing capabilities. In addition to the standard All/Active/Archived spreadsheet views, a tag-list and owner-list view (sorted alphabetically) can also be found. If you have tagged a keyword with your spreadsheets, you can locate it quickly by clicking on the tag. Likewise, if you are working with your collaborators, you can access the those spreadsheets by clicking on the owner in the owner-list.
• Filter function
  The filter function is perfect for locating any spreadsheet in your workspace. If you know the name of the spreadsheet or partial name of the spreadsheet you need access to, type it in the filter box and will display matching results in the books list.

Optimized Grid

In the past, we have gotten feedback from our users telling us the performance of EditGrid is on the slow side. In this release, we have made performance improvements to the grid and you’ll experience a faster response time when performing the following actions:

• Opening smaller sized sheets
• Resizing columns/rows of any size
• Navigating between sheets
• Resizing browser window
• Scrolling (most significant in IE6 and noticeable in FF2, IE7)
• Cursor movements

New Remote Data Packs

We have added two new remote data packs, Amazon and eBay. Now you have access to ecommerce data to further enhance your EditGrid spreadsheets. Both Amazon and eBay data packs will allow you to search for products by keywords and gather detail product information you are looking for, all within your spreadsheet.

The lucky few should be getting their iPhone 3G on launch day in Hong Kong. There has been as much talk about the price as they have about the phone as the announced $199/$299USD price tag is not to be found anywhere. There has also been buzz around the net earlier about Hong Kong having the best deal anywhere.

We weren’t exactly sold on the reports and created a price comparison spreadsheet highlighting our Yahoo! Finance Currency remote data function which compares the price plans between providers across the globe. You’ll see that Hong Kong is among the cheapest, but as we found out, Australia offers an even cheaper price plan than Hong Kong.

So, what happened on the first day of iPhone mania here? Nothing really and to my surprise, there were no lines at any of the 3 Hong Kong stores I went by, total opposite of other parts of the world. Instead, 3 Hong Kong offered exclusivity to 500 randomly picked individuals who previously registered online and 1000 VIP customers on the first day of sale. The rest will have to wait until tomorrow.

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!

Over the weekend, we spotted some unusual activities in our email system. A user had abused our system by using our Invite Friends function and sent out invitation emails which included a private message that solicit personal and/or financial information to his/her list of recipients. It’s unknown how many were affected, but would like to inform all of the situation.

If you have received an email from an unknown sender and by way of the EditGrid domain over this past weekend requesting personal information, bear in mind that it might be spam or a possible phishing attempt. Please note that EditGrid will never ask for passwords nor will we ask for financial-related information in emails.

In response, we have banned the user, set a limit on the number of invitations you are allowed to send and we are also seeking additional ways to improve so this and similar activities will not happen again.

We want to remind everyone that EditGrid will not tolerate this type of activities. We take user privacy seriously and our Privacy Policy outlines EditGrid’s commitment to protecting our users’ privacy. Those registered users who fail to abide by the Terms of Use will be dealt with according to the Terms.

Just like how we are required to have an ICQ account here at EditGrid, we are bringing back some of the features found in the old EditGrid website. We are the classics type here. For those unfamiliar with the old site, I’ll fill you in quickly here.

Previously, we list the most popular spreadsheets in our front page, unfiltered, have a look at the results found in Internet Archive Wayback Machine and see for yourself. We have found over the course of redesigning our new website in the latter part of 2007 that displaying popular spreadsheets was a hit with users and visitors and have had harsh criticism when we changed it.

So here we are, the latest design in our website which includes a Featured Spreadsheets section highlighting the most exciting and popular spreadsheets created by our users and the EditGrid Team, a rebirth of our popular spreadsheets found in the past designs. These featured spreadsheets are submitted by our users and reviewed by our team before going on the mainsite, an opposite approach to our earlier website. We also have crawlers team members search through the EditGrid community for the coolest spreadsheets available.

Have a look at our latest redesign and let us know what you think!

The Sichuan earthquake which struck last Monday has brought more than 32,000 dead and 220,000 injured, in addition to making many more homeless.  The whole EditGrid Team has been very concerned of the earthquake’s impact and has been tracking the earthquake closely.

As a tiny token of our empathy to those affected by the natural disaster, we have pledged a HK$30,000 donation to the relief effort.  We know we are not in as good a financial position as the other Chinese Internet giants’ to make substantial donation — what’s important is that we think we’ve done our part.  And we encourage all our users and readers to consider donating to the relief aid fund as well (see this spreadsheet for more details), if you haven’t already done so.

Today marks one week since the earthquake struck and also sees the start of a 3-day national mourning period.  During these three days we’ll re-paint the EditGrid site banner black as a sign of mourning.  Spend a little thought over to the earthquake victims whenever you notice the mourning black banner — they’ll need and appreciate every bit of your concerns.

Update: our user war-god, publisher of the most popular spreadsheet on EditGrid, played his part as well:

(Contrast the above with the spreadsheet’s normal form as reported here.)

The 7.8 magnitude earthquake that struck Sichuan, China earlier in the week was so powerful that the impact was even felt here in Hong Kong, some 1500km away. While Hong Kong was not affected, the same cannot be said for those in Sichuan and surrounding provinces, where tens of thousands of familes have been impacted by this disaster. The estimated death toll has reached close to 20,000 with many still unaccounted for, not to mention the millions of homes that were destroyed.

We have created a spreadsheet with information pertaining to the earthquake, donation status and ways you can help out. Everyone is welcome to help update it with the latest information, stats and donation efforts.

Along with the many companies, individuals and governments who have made contributions, EditGrid’s parent company Team and Concepts is also doing their part by making a donation to World Vision Hong Kong to help the quake victims, our neighbors up north.

For those who want to contribute, you can do it through World Vision Hong Kong, or through other organizations. We have created a list of organizations from Hong Kong, China and US who are accepting donations to aid the relief efforts.