Page 1 of 1

Total Size of All Movies

Posted: 2004-09-29 02:04:51
by Guest
Hello, I have just started using Ant Movie Catalog. :)

The statistics window is very comprehensive but I would like to view the total disk size of all my movies.

I have tried exporting to Excel and summing up all the rows but it would treat multiple disks as "0". For ex. "700+700" would be equivalent to "0"
Perhaps there is a way to do so through other forms of export? Unforunately I' am not a pro at this. If any one has a solution or any ideas of how this can be done I would be very greatfull. Thanks.

Posted: 2004-09-29 08:32:38
by antp
I think that someone wrote a script for that, I should try to find it
What you can do in Excel is to add a "=" in front of each cell, so the "700+700" will become "=700+700" which is a valid formula.

Posted: 2004-09-30 21:37:45
by Guest
Thanks. I will use that method now even though it is still tedious, if someone can find that script or write one I would be very thankful.

Posted: 2004-09-30 22:19:46
by antp
I do not know Excel very much but this should be doable easily (well, I know it was doable with Lotus 1-2-3, I hope Excel can do that at least :D)