- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
The number of pages (printed?) would be a function of font size & margins. The number of words would be easier to get a handle on using something like http://ginstrom.com/CountAnything/
or the word counting feature in WORD.
Unfortunately you'd have to open the files to get a count; easy for a few but not so easy for 16,000 files. :(
You could 'count' a sampling of files, then estimate the rest based on file size to word count correlation.
Or you could 'print' the files to PDF & then merge them into a single PDF document. This would give a better printed page count. The could be done on a sampling basis.
All Caps Ctrl+Shift+A Annotation Alt+Ctrl+M App Maximize Alt+F10 App Restore Alt+F5 Apply Heading1 Alt+Ctrl+1 Apply Heading2 Alt+Ctrl+2 Apply Heading3 Alt+Ctrl+3 Apply List Bullet Ctrl+Shift+L Auto Format Alt+Ctrl+K Auto Text F3 Auto Text Alt+Ctrl+V Bold Ctrl+B Bold Ctrl+Shift+B Bookmark Ctrl+Shift+F5 Browse Next Ctrl+Page Down Browse Prev Ctrl+Page Up Browse Sel Alt+Ctrl+Home Cancel Esc Center Para Ctrl+E Change Case Shift+F3 Char Left Left Char Left Extend Shift+Left Char Right Right Char Right Extend Shift+Right Clear Del Close or Exit Alt+F4 Close Pane Alt+Shift+C Column Break Ctrl+Shift+Return Column Select Ctrl+Shift+F8 Copy Ctrl+C Copy Ctrl+Insert Copy Format Ctrl+Shift+C Copy Text Shift+F2 Create Auto Text Alt+F3 Customize Add Menu Shortcut Alt+Ctrl+= Customize Keyboard Shortcut Alt+Ctrl+Num + Customize Remove Menu Shortcut Alt+Ctrl+- Cut Ctrl+X Cut Shift+Del Date Field Alt+Shift+D Delete Back Word Ctrl+Backspace Delete Word Ctrl+Del Distribute Para Ctrl+Shift+J Do Field Click Alt+Shift+F9 Doc Close Ctrl+W Doc Close Ctrl+F4 Doc Maximize Ctrl+F10 Doc Move Ctrl+F7 Doc Restore Ctrl+F5 Doc Size Ctrl+F8 Doc Split Alt+Ctrl+S Double Underline Ctrl+Shift+D End of Column Alt+Page Down End of Column Alt+Shift+Page Down End of Doc Extend Ctrl+Shift+End End of Document Ctrl+End End of Line End End of Line Extend Shift+End End of Row Alt+End End of Row Alt+Shift+End End of Window Alt+Ctrl+Page Down End of Window Extend Alt+Ctrl+Shift+Page Down Endnote Now Alt+Ctrl+D Extend Selection F8 Field Chars Ctrl+F9 Field Codes Alt+F9 Find Ctrl+F Font Ctrl+D Font Ctrl+Shift+F Font Size Select Ctrl+Shift+P Footnote Now Alt+Ctrl+F Formatting Properties Shift+F1 Go Back Shift+F5 Go Back Alt+Ctrl+Z Go To Ctrl+G Go To F5 Grow Font Ctrl+Shift+. Grow Font One Point Ctrl+] Hanging Indent Ctrl+T Header Footer Link Alt+Shift+R Help F1 HHC Alt+Ctrl+F7 Hidden Ctrl+Shift+H Hyperlink Ctrl+K Indent Ctrl+M Italic Ctrl+I Italic Ctrl+Shift+I Justify Para Ctrl+J Left Para Ctrl+L Line Down Down Line Down Extend Shift+Down Line Up Up Line Up Extend Shift+Up List Num Field Alt+Ctrl+L Lock Fields Ctrl+3 Lock Fields Ctrl+F11 Macro Alt+F8 Mail Merge Check Alt+Shift+K Mail Merge Edit Data Source Alt+Shift+E Mail Merge to Doc Alt+Shift+N Mail Merge to Printer Alt+Shift+M Mark Citation Alt+Shift+I Mark Index Entry Alt+Shift+X Mark Table of Contents Entry Alt+Shift+O Menu Mode F10 Merge Field Alt+Shift+F Microsoft Script Editor Alt+Shift+F11 Microsoft System Info Alt+Ctrl+F1 Move Text F2 New Default Ctrl+N Next Field F11 Next Field Alt+F1 Next Misspelling Alt+F7 Next Object Alt+Down Next Window Ctrl+F6 Next Window Alt+F6 Normal Alt+Ctrl+N Normal Style Ctrl+Shift+N Normal Style Alt+Shift+Clear (Num 5) Open Ctrl+O Open Ctrl+F12 Open Alt+Ctrl+F2 Open or Close Up Para Ctrl+0 Other Pane F6 Other Pane Shift+F6 Outline Alt+Ctrl+O Outline Collapse Alt+Shift+- Outline Collapse Alt+Shift+Num - Outline Demote Alt+Shift+Right Outline Expand Alt+Shift+= Outline Expand Alt+Shift+Num + Outline Move Down Alt+Shift+Down Outline Move Up Alt+Shift+Up Outline Promote Alt+Shift+Left Outline Show First Line Alt+Shift+L Page Alt+Ctrl+P Page Break Ctrl+Return Page Down Page Down Page Down Extend Shift+Page Down Page Field Alt+Shift+P Page Up Page Up Page Up Extend Shift+Page Up Para Down Ctrl+Down Para Down Extend Ctrl+Shift+Down Para Up Ctrl+Up Para Up Extend Ctrl+Shift+Up Paste Ctrl+V Paste Insert Paste Format Ctrl+Shift+V Prev Field Shift+F11 Prev Field Alt+Shift+F1 Prev Object Alt+Up Prev Window Ctrl+Shift+F6 Prev Window Alt+Shift+F6 Print Ctrl+P Print Ctrl+Shift+F12 Print Preview Ctrl+F2 Print Preview Alt+Ctrl+I Proofing F7 Redo Alt+Shift+Backspace Redo or Repeat Ctrl+Y Redo or Repeat F4 Redo or Repeat Alt+Return Repeat Find Shift+F4 Repeat Find Alt+Ctrl+Y Replace Ctrl+H Research Lookup Ctrl+Shift+O Reset Char Ctrl+Space Reset Char Ctrl+Shift+Z Reset Para Ctrl+Q Revision Marks Toggle Ctrl+Shift+E Right Para Ctrl+R Save Ctrl+S Save Shift+F12 Save Alt+Shift+F2 Save As F12 Select All Ctrl+A Select All Ctrl+Clear (Num 5) Select All Ctrl+Num 5 Select Table Alt+Clear (Num 5) Show All Ctrl+Shift+8 Show All Headings Alt+Shift+A Show Heading1 Alt+Shift+1 Show Heading2 Alt+Shift+2 Show Heading3 Alt+Shift+3 Show Heading4 Alt+Shift+4 Show Heading5 Alt+Shift+5 Show Heading6 Alt+Shift+6 Show Heading7 Alt+Shift+7 Show Heading8 Alt+Shift+8 Show Heading9 Alt+Shift+9 Shrink Font Ctrl+Shift+, Shrink Font One Point Ctrl+[ Shrink Selection Shift+F8 Small Caps Ctrl+Shift+K Space Para1 (single spacing) Ctrl+1 Space Para15 (one-and-a-half line spacing) Ctrl+5 Space Para2 (double spacing) Ctrl+2 Spike Ctrl+Shift+F3 Spike Ctrl+F3 Start of Column Alt+Page Up Start of Column Alt+Shift+Page Up Start of Doc Extend Ctrl+Shift+Home Start of Document Ctrl+Home Start of Line Home Start of Line Extend Shift+Home Start of Row Alt+Home Start of Row Alt+Shift+Home Start of Window Alt+Ctrl+Page Up Start of Window Extend Alt+Ctrl+Shift+Page Up Style Ctrl+Shift+S Style Separator Alt+Ctrl+Return Subscript Ctrl+= Superscript Ctrl+Shift+= Symbol Font Ctrl+Shift+Q Task Pane Ctrl+F1 Thesaurus RR Shift+F7 Time Field Alt+Shift+T Toggle Character Code Alt+X Toggle Field Display Shift+F9 Toggle Master Subdocs Ctrl+\ Toggle XMLTag View Ctrl+Shift+X Translate Pane Alt+Shift+F7 Un Hang Ctrl+Shift+T Un Indent Ctrl+Shift+M Underline Ctrl+U Underline Ctrl+Shift+U Undo Ctrl+Z Undo Alt+Backspace Unlink Fields Ctrl+6 Unlink Fields Ctrl+Shift+F9 Unlock Fields Ctrl+4 Unlock Fields Ctrl+Shift+F11 Update Auto Format Alt+Ctrl+U Update Fields F9 Update Fields Alt+Shift+U Update Source Ctrl+Shift+F7 VBCode Alt+F11 Web Go Back Alt+Left Web Go Forward Alt+Right Word Count List Ctrl+Shift+G Word Count Recount Ctrl+Shift+R Word Left Ctrl+Left Word Left Extend Ctrl+Shift+Left Word Right Ctrl+Right Word Right Extend Ctrl+Shift+Right Word Underline Ctrl+Shift+W
Perl is a great language for this type of problem.
I recommend using Perl, and installing the Lingua::Phonology::Syllable module. Here is a working example:
use Lingua::Phonology;
use Lingua::Phonology::Syllable;
my $phono = Lingua::Phonology->new();
$phono->features->loadfile;
$phono->symbols->loadfile;
# Create a new Syllable object
my $syll = new Lingua::Phonology::Syllable;
# Create an input word
my @word = $phono->symbols->segment('s','h','e','p','h','e','r','d');
# Allow onset clusters and simple codas
$syll->set_complex_onset;
$syll->set_coda;
# Syllabify the word
$syll->syllabify(@word);
my $count = $syll->count_syll;
print "Count: $count\n"; # prints "Count: 2"
# @word now has features set to indicate a syllabification of
# <shep><herd>
You should use the formula COUNT (Cell1, Cell2), please replace Cell1 and Cell2 for the range of your cells in Excell. You could use too the formula COUNT.IF(Cell1,Cell2,Criterion), Cell1 and Cell2 is the range of cells when can exist an entry.
Example The final formula is like:
COUNT(A1:A5)/COUNT.IF(A1:A5,"=x")*100
Count will only work with numbers. So select another box where you want your number and use this formula: =count(x:x) This should give the count number then you will need to find the difference. In another box, use =sum(x-x). This should give you your difference.
×