Total Size of All Movies

Guest · Post by **Guest** » 2004-09-29 02:04:51

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.

Post by **antp** » 2004-09-29 08:32:38

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.

Guest · Post by **Guest** » 2004-09-30 21:37:45

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.

Post by **antp** » 2004-09-30 22:19:46

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

)