Posts Tagged ‘spreadsheet’

Review: EditGrid a web based spreadsheet application

EditGrid is an online spreadsheet application, similar to the highly touted Google Spreadsheets and widely used Microsoft Excel. With a week of EditGrid usage under my belt, I can say that I am considerably more impressed by EditGrid than Google Spreadsheets. From the very get go, EditGrid is refreshing. The first thing I love is that you can register without giving your email address… Continue reading

March 22 2007 | By Kyle | Tagged: office, online, software, spreadsheet | 5 comments»

Advanced Gantt Charts in Spreadsheet

Gantt Chart is useful. It tracks tasks start and finish dates, dependencies and resources. Unfortunately drawing gantt chart usually requires a project management software. Alternative? Peltier Technical Services shows a way of doing it in Spreadsheet (i.e. Excel):

Gantt charts are useful tools in program management, which help to show graphically when tasks must start and finish, and which tasks are underway at any given time. Gantt charts help in… Continue reading

September 27 2006 | By Leon | Tagged: chart, gantt, project, spreadsheet | 5 comments»

Lightweight data exploration in Excel

This is such a good trick for spreadsheet user. Juice Analytics have a great trick on plotting graphs within the cell, by using the function REPT() to repeat a single bar character ("|"). They called it a In-cell bar graph:

What are some practical uses of in-cell bar graphs? For starters, they offer a good way to profile a dataset that has hundreds or thousands… Continue reading

August 11 2006 | By Leon | Tagged: graph, software, spreadsheet | 6 comments»

Handy Personal Finance Spreadsheets

Get Rich Slowly introduces a bunch of great spreadsheets. Those spreadsheets will help you on budgeting, debt calculations, home maintenance, auto expenses etc. Check it out!Good personal finance spreadsheets are hard to find on the web because sploggers monopolize the search results. Still, I’ve managed to collect links to a stack of them that I’d like to share.Spreadsheets more useful than web-based calculators because:* You can… Continue reading

May 26 2006 | By Leon | Tagged: finance, spreadsheet | 5 comments»