Solved

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

Posted on 2007-11-22
7
300 Views
Last Modified: 2010-04-16
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.
0
Comment
Question by:asgarcymed
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 84

Expert Comment

by:ozo
ID: 20336083
It depends on how you want those factors to interact, but something like
total((size*depth)²) would seem to satisfy your criterion
Or you could might explicitly evaluate each of
*) 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)
(that looks like a duplicate)
and sum those individual scores, perhaps with some weighting factor

Given a few example folders and what you want their relative scores to be, we may be able to fit a function that orders them appropriately
0
 

Author Comment

by:asgarcymed
ID: 20336358
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.  
0
 

Author Comment

by:asgarcymed
ID: 20336371
PS - I do not why, but the "Experts Exchange" sometimes makes illegal characters; what can be awful in case of posting formulas/equations/algorithms/functions.

«(zero or letter) »
[illegal characters - why do they are generated????]
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:asgarcymed
ID: 20344601
ozo - Do you have any news?

Thanks.

Regards.
0
 
LVL 15

Accepted Solution

by:
JimFive earned 500 total points
ID: 20601276
I think what you would want to add is a "Weight" for each category to indicate how important each category is overall. So your formula would be something like (Weight1 * Category1) + (Weight2 * Category2) + ...

Also, By counting subfolders and depth separately it seems that you are giving extra weight to organization.

I would think just counting files or adding up file size would give you a quantity rating.  Beyond that you don't have any quality items at all anyway.  (Length of book <> Quality of book)

--
JimFive
0
 

Author Comment

by:asgarcymed
ID: 20603766
JimFive - Excellent idea! I was over-complicating! I agree with you 100%!!

Thank you very much for your suggestion!!

Best regards.
0
 
LVL 84

Expert Comment

by:ozo
ID: 20604357
Didn't I say you could sum the individual scores with a weighting factor?
You never gave examples of scores from which we could determine what weights might work best to produce the desired order or whether interactions between categories would need to be taken into account.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question