|
Quick-XL |
|
When we first came up with the idea for Quick-XL, the main idea was to provide a quick and easy way to enter data into Excel spreadsheets. We realized, at that time that there were only two ways to get data into a spreadsheet; "import the data" or "enter the data". But as time went on, we realized that those who imported their data also needed a way to attach additional collateral information to each row of data in a convenient way. That's where Quick-XL came in. Consider the following example. Suppose you have a spreadsheet that tracks the price of the stocks in your portfolio for the most recent 7 day period. Each day, you run a program that posts the current day's closing price for each stock you track. One day, there is a sudden drop in the price of one of your stocks. You look into the situation and determine the reason. Fortunately, you have a column called 'Notes'. You enter a note explaining why the stock dropped so that at some later date when you are looking at summary statistics such as YTD high and YTD low, you can look at the note and see why your stock shows such apparent volitility. Without Quick-XL, this is a bit of a problem. If you format the 'Notes' column as 'Shrink to fit', then the only way to read the text of the note is to click on it. It will appear in the data entry field in an unformatted jumble. If you format the 'Notes' column any other way, it will mess up the look of your spreadsheet. The following screen shots illustrate this point: |
|
|
|
|
|
Copyright(c) 2008, Patent Pending all rights reserved. |