Upgrade Extended Accounting Light to Full

Upgrade Extended Accounting Light to Full
MS Excel add-in 97/2000/XP. Data Entry Bug Tracker. Tracks entry bugs during an entry and later. Pivot Table Wizard. Quick Subtotals Adding to the spredsheet. Ararm-Clock. Extort of a spreadsheet to the existing databases (MS Access, Visual Foxpro, M

How to Run the Extended Accounting:

---

Simply open your worksheet and choose the item in the "EA" menu. You can see the sample of such worksheet below. Your worksheet can be arbitrary.

The Extended Accounting can check your worksheet and select the erroneous cells by red color.

Extended Accounting detected an error in the source list above : department 4 does not exist. How does Extended Accounting know the erroneous cells? It simply finds available values of "Department" column on the "Hierh" worksheet ( please see below ). Note that the Extended Accounting does not change your worksheet. It inserts the new one with the name "Errors" instead and copies your worksheet here.

Another bug cell in the source list - E12 : the department 1 does not trade with a log. How does the Extended Accounting found this erroneous cell? It simply finds available values of "Goods" column on the "Hierh" worksheet ( please see above) while the value in the "Department" column = 1.

Please note that the Extended Accounting can check many columns of this worksheet by this way. For this purpose you will need only to create your own "Hierh" ( you may use another name) worksheet and define the link to it in the special form.

You can also use the Extended Accounting for the automated data entry on your worksheet. How can the Extended Accounting automate your entry? It is simply. It offers to enter data into all columns of your list. If you enter the wrong value and the Extended Accounting "knows" that one is not valid, it offers to correct it. What is more, if there is only one valid value, the Extended Accounting enters it automatically. How can the Extended Accounting know the set of valid values for the current cell if this value depends of many other columns? It simply finds the available values of the current column on the "Hierh" worksheet (or other worksheets) while the values of other controlled columns of this worksheet(s) are the same as in the worksheet you create.

The Extended Accounting tracks here the "Depart." and "Ric Code" columns. The Automated Entry Procedure entered many columns automatically as it can calculate them using the formula from the previous row. For example, the cell "J8" ("Total" column) is calculated by one using the following formula:
Qty * NetAmount * (1+Comission+StampDuty) + PtmLevy + ContractCharge

Extended Accounting Main Features:

---

Automated data entry into your worksheets - unique

Data Entry Bug Tracker (during the entry and later) - unique

Quick adding the subtotals to your spreadsheets

Alarm-Clock

Quick generating the pivot tables including created on a base of the external databases (MS Access, Visual FoxPro and others using the ODBC drivers)

Export of your spreadsheets to the existing MS Access, Visual FoxPro and other databases using the ODBC drivers.

System Requirements:

---

Windows 9x/Me/NT/2000/XP

Excel 97/2000/XP

Upgrade Extended Accounting Light to Full Download Page

4TOPS Compare Excel Files 4TOPS Compare Files is used to find differences in values or formulas between worksheets or Microsoft Excel files.

Addintools Assist A powerful add-in for MS Excel that expands the features of Excel grea

Pages: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12)