Tagged with `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…

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…

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…

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…