This post will provide a central forum where I address problems that I am informed of. If you are having a problem, PLEASE let me know; otherwise I probably won't fix it. However, it is best to leave your comment on the post where you encountered the problem. Otherwise, I won't know which spreadsheet is causing the problem.
Can't Download SpreadsheetYou can never download my spreadsheets by clicking on the image in the post; that's just a picture. Clicking on the picture will normally give you a larger, clearer version of the picture, but not download the associated spreadsheet. To download the spreadsheet, look for a link -- generally near the end of the post.
Google may deny access to Google Documents/Spreadsheets if you do not have a Google account. If you don't have one, go here (they're free). Let me know if you're having problems.
In some browsers (e.g., Internet Explorer) you'll see a dialog box asking you to either OPEN the spreadsheet, or SAVE it to your PC. In some other browsers (e.g., some versions of Chrome) you may need to click on a link that appears at the bottom of your browser screen -- or at the bottom of a new blank screen.
Note: In all cases you must have a spreadsheet program on your computer -- either Excel, or a program that can read Excel files.
Downloading From Google Documents/SpreadsheetsSome of the links take you to Google Documents/Spreadsheets. If you end up there, while in Google spreadsheets click on File - Download.
Can't Enter DataTo enter data you must actually download the associated spreadsheet; clicking on the screenshot will expand it, but not allow you to enter data. The link to download the spreadsheet and enter data is usually at the end of the post.
Multiple WorksheetsMany of the models are Excel workbooks containing multiple worksheets. To navigate between worksheets, click on the tabs in the bottom left hand corner of the workbook.
Problem: Spreadsheet Cells Contain ###### or #VALUE!
I’m sill having problems converting from Excel to Google Spreadsheets and back. In some cases, when you first open a spreadsheet you may see ###### or #VALUE! or #NAME in some cells.
First, try widening the column width of columns containing ##### by about 1/2" -- or until the #### in that column disappear.
If that doesn't solve the problem, click on the offending cells one by one, starting in the upper left and ending in the lower right, and hit the F2 key and then the Enter key for each; the correct numbers should magically appear.
#NAME errorsThere are apparently problems converting range names when downloading from Google Spreadsheets to the spreadsheet on your PC. If you get #NAME errors, please let me know. You won't be able to resolve those unless I make changes in the spreadsheet as it exists on Google Docs.
Problems With Graphs
The graphs in my posts are created using Excel. When I upload to Google Spreadsheets (GS), the graphs disappear. I then try to replicate the graphs using Google Spreadsheets (GS) -- as best I can. Therefore, for some spreadsheets, I provide two links.
If you use the gs link you can work in GS, and the graphs I created in GS will be available to you (though they will generally be somewhat different from the graphs in the posts).
If you use the second link you can download to Excel. However, the graphs apparently do not export to Excel. You will have to recreate them. The good news is that you will be able to create the same graphs that I have included in the post (assuming you have basic Excel skills).
At least, I think that's the way it's working. Let me know if I'm mistaken.
If you are aware of additional problems, please let me know. However, it's better to leave a comment on the post where the problem was encountered rather than here.
Last updated 1/7/2012