This feature is only available with Level 5 or higher programs.

Data from each of the three major parts of Royalty Functions (including Royalty Set-up, Royalty Reports, and Royalty Statements) can be accessed by a spreadsheet program.  To do so, select the FILE and MOVE DATA TO SPREADSHEET.  (In the Royalty Set-up Screen, it is accessed by selecting FILE and VIEW/PRINT RECORDS FROM SPREADSHEET.)

Important:  In the Royalty Report portion of the program, page through each of the reports before moving them to the spreadsheet.  (This is not necessary in Royalty Set-up and Royalty Statements)  So many calculations going on in the Royalty Report part of the program that the final set of calculations are not done until each report comes up on the screen.  Once the report has appeared on the screen just once (a fraction of a second is all it needs), all the calculations are done and you can use View/Print from Spreadsheet.  

If you haven't used the spreadsheet option in other parts of the program, you'll first be prompted to enter the path to your spreadsheet program.  Once you've entered the path, AnyBook will automatically start your spreadsheet program with the data in place.

This feature provides you with an additional way of viewing the data.  You can sort the data in various ways, manipulate it and print it.  Feel free to make whatever changes you desire.  When you use this option, data is placed in a separate report file and any changes made will not affect the original database.

Note: If you are using this function with Royalty Reports, you must have paged through the reports first.  (If you've already looked at each of the reports on the screen, then it's not necessary to do this).  The export function requires some additional data calculations which only occur when the report is visible on the report screen.  Once you page through the reports, all calculations will complete and you'll full access to the data in the spreadsheet.