Algorithm to Score Global Quality-Quantity of Files (eBooks)

[asgarcymed]

I would like to create an algorithm to score the "global quality/quantity" of eBooks of each subject.

Each subject has a main subfolder, like:

eBooks\Subject1\(...)
eBooks\Subject2\(...)
eBooks\Subject3\(...)
(...)

I would to create an algorithm/equation/formula to score them (subjects). I think it would be important such algorithm/equation/formula to rely on:

*) Total Size of each Subfolder (the higher the better)

*) Total Number of Files inside each Subfolder (the higher the better)

*) Total Number of Sub-Subfolders inside each Subfolder (the higher the better)

*) Maximum Folder Depth (the higher the better)

*) The Size of the Largest File Size (the higher the better)

*) The Size of the Largest File Size (the higher the better)


I tried many combinations but the resultant score were very absurd, except when:

Score = (Total Number of Files inside each Subfolder) * (Total Size of each Subfolder)

Do you know a better one?

Thanks.

Regards.

 

[xwb]

Looks more like quatity rather than anything else. What is the purpose of this? Just wondering whether a right click on the ebook and select properties will give you the same ranking.

 

[asgarcymed]

Please, download my CSV file (inside a ZIP) at:

http://tinyurl.com/ypv8t7

You will find a "Score" Column/Row, which corresponds to :

Score = (Total Number of Files inside each Subfolder) * (Total Size of each Subfolder)


You also will find that all numeric values are preceded with

«(zero or letter) »

because I do not know how to numerically sort the Columns/Rows inside a CSV file; and I do not want to sort it as alphabetic sorting:

1-10-100-1000-2-20-200-2000

instead of

1-2-10-20-100-200-1000-2000

If you know how to solve this; I also would appreciate your help

Thanks.

Best regards.

 

[xwb]

You'll get numeric sorting if you separate the (letter) from the number. Instead of

(a) 2.73

put a in one column and 2.73 in another column. You'll know if it is numeric when the text in the cell insists on being right justified. When you've converted all of them, just use data/sort on the score column.

I still don't know what this is for.

 

[asgarcymed]

Maybe I should rename "score the global quality/quantity" to "score the global quantity (only)". Thus, I want to get a good algorithm to evaluate what are the subject/subfolder which have better and worse quantity of files...