At this time, we're investigating the problem and looking for a solution.
If you've encountered this issue while converting your file, we suggest attempting to create and upload an EPUB directly to our system.
While there are a number of EPUB conversion options, Calibre (Download Here) has shown the best results for creating an EPUB for the Lulu system. Please review their extensive Help resources (Found Here) to create an EPUB 2 that our system can validate.
We've also created this Forum Thread. Post questions here and we'll do our best to respond and assist.
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?