We're aware of an issue with converting some DOC, DOCX, ODT, and RTF files to EPUB through our Ebook Wizard.
We've created this Forum Thread with some workarounds and advice to assist you in publishing you ebook.

How to format Revenue data in Excel

Each time I download my revenue data (CSV file) and import it into Excel, I then have to format the spreadsheet (e.g. adjust column widths, and then add Excel functions to make sense of the data).

 

For example, I use the =SUM function to add up the Quantity and Earnings columns. I also use the =COUNTIF function to create separate sub-totals per individual book title. Other formulae allow me to see how profitable each book title is.

 

Rather than do this manually each time, may I ask if anyone has developed a Visual Basic macro in Excel to automate the whole thing?

Comments

Sign In or Register to comment.