Digital spreadsheet formula automation

3) A method for automating a the construction of a digital spreadsheet formula comprising the steps of:

• recognizing a formula's name in real time and without the author's intervention;
• traversing the spreadsheet's used range and recognizing the formula variables names and their associated value in real-time and without the author's intervention;
• identifying missing information;
• displaying a dialog box to assist in adding the missing information to the spreadsheet;
• identifying errors in the variables;
• displaying a dialog box to assist in correcting the erroneous variables;
• constructing the completed formula;
• locating the cell where the result is expected to be placed in association with the formula's name;
• displaying a dialog box to confirm or not an overwrite;
• displaying a dialog box to select an alternate location if there would be a wrongful overwrite;
• inserting the completed formula in the cell associated with the expected result.