Keyword Density Tool In Excel 06.04.08
Hi,
I need an excel guru to create in excel a template which will automatically count the number of words in an article and to automatically analyze keyword density for 3 chosen keywords per article.
Once the spreadsheet is created all an editor should have to do is copy/paste the article and keywords and a formula in the background should check:
1. Article legth - if above 300 (or any number chosen) pass if below 300 word in article fail
2. Keyword density - Keyword 1, keyword 2, keyword 3 - if each keyword featured between x% and x% in the article then Pass, if one outside of this threshold then fail
3. If article length pass and keyword density pass - overall pass
This project has been posted previously, so it should be fairly straitforward.
Thanks,
JW
