Just a general thought.
When developing your spreadsheet, do NOT try to do everything inside one cell. When that happens, you end up with incredibly complex formulas that are nearly impossible to debug if they do not work.
Always think "Divide & Conquer".
Also, take the time to understand formulas. They can be your best friend and your worst nightmare. Learn how to make the computer an extension of your thought process. Also, consider the method you are intending to use. Give it a bit of thought. Sketch it out on paper.
And perhaps the most important, Test your ideas/results BEFORE you spend the $$$.
Another note, easiest way to transfer your numbers to a spreadsheet is to use the following steps:
1) Save the word file as a ASCII TXT file
2) Open this file with NOTEPAD
3) Make sure everything appears uniform (crucial when importing into Excel). I suggest that you use a SPACE between the Date Column and the Number Column.
4) Save the file with Notepad & Close it.
5) Open the file in Excel. To open the TXT file you have created and saved in Notepad, make sure the Drop Down box reads "ALL FILES" instead of just "EXCEL FILES".
6) Once you found the file and clicked OK to open it, you will get a message box indicating that it is NOT an excel file, Open any way?, click yes. The Next screen you see will be the data in TXT file. If you use the SPACE as a Delimiter, Excel will assist you in the import. It is IMPORTANT that you try to import the date in one column and the numbers in another column by itself. Otherwise, you will need other formulas to break the data out.
I hope this helps some.
Sir Metro