{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Table Of Contents","Settings","Characters","Words","Sentences","Text","TextAnalyzers"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1904","formulas":"cached_only"}

{"sheet":"Table Of Contents","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]],"flags":["formulas_cached_only"]}
[]
[]
[null,"This document was exported from Numbers '08.  Each table was converted to an Excel worksheet."]
[]
[]
[]
[null,"Numbers Sheet Name","Numbers Table Name","Excel Worksheet Name"]
[]
[null,"Sheet 1"]
[null,null,"Table 1","Sheet 1 - Table 1"]
[null,"Sheet 2"]
[null,null,"Table 1","Sheet 2 - Table 1"]

{"sheet":"Settings","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,"return type","function name","argument 1","argument 2","description","reference","link"]
[null,"Settings","void","ignoreNumber","boolean enable",null,"ignore numbers when argument ignore set true"]
[null,null,"void","stopList","boolean enable",null,"enable stop list when argument set true","a stop list is a list of words to be filtered a prior","www.en.wikipedia.org/wiki/Stop_word"]
[null,null,"void","stemWords","boolean enable",null,"stem all words in the text into base form","stemming","www.en.wikipedia.org/wiki/Stemming"]
[null,null,"void","caseSensitive","boolean enable",null,"Capital letters are distinguished from small letters when argument enable set true"]
[null,null,"void","sort","enum style",null,"specify sorting style for a list of results"]
[]
[]
[]
["Quantity"]
[]
["Length"]

{"sheet":"Characters","index":2,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Character Level","return type","function name","argument 1","argument 2","description"]
[null,"English"]
[null,"Quantity","int","numOfCharacters",null,null,"count the total number of characters in the text"]
[null,null,"int[26]","numOfAtoZ","enum sort",null,"return the number of each A to Z in the text"]
[]
[]
[]
[]
[]
["Quantity","Chinese"]
[null,"Quantity","int ","numOfCharacters",null,null,"count the total number of Chinese characters(字) in the text "]
["Length",null,"int ","numOfUniqueCharacters",null,null,"coun total number of unique Chinese characters (字) in the text"]
[null,null,null,"getUniqueCharacters",null,null,"return an array of unique Chinese characters in the text"]
[]
["Occurance",null,"hashtable","characterOccurance",null,null,"return a hashtable of number of times for every Chinese character appears in the text"]
[null,null,"hashtable","characterFrequency",null,null,"return a hashtable of frequency appears in a text (frequence =  characterOccurance / numOfCharacters)"]
[null,null,"array","topCharacters","enum sort","int range","return a sorted array of most frequently occuring words"]
[null,null,"hashtable","characterRanks","enum sort","int range","return a sorted hashtable ranking the frequency of words"]
[]
[null,"Detection",null,"findCharacter","string s",null,"return words in the text that exactly match required Chinese character s"]
[null,null,null,"findCharacterSynonym","string s",null,"return words in the text that is synonym of required Chinese character s"]
[]
[null,"Pinyin",null,"pinyinTag",null,null,"tag every Chinese character in the text with its Hanyu Pinyin"]
[]
[]
[null,"Strokes","hashtable","numOfStrokes","enum sort","int range","return a hash table of stroke number for each unique character in the text"]

{"sheet":"Words","index":3,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Word Level","return type","function name","argument 1","argument 2","description","reference","link"]
[null,"English"]
[null,"Quantity","int","numOfWords",null,null,"count the total number of words in the corpus"]
[null,null,"int","numOfUniqueWords",null,null,"count the number of unique words"]
[]
[null,"Length","double","averageWordLength",null,null,"return the average length of all sentences in the text"]
[null,null,"string","longesetWord",null,null,"return the word composed of maximun number of characters in the text"]
[null,null,"int","longestWordLength",null,null,"return the number of characters composing the longest word in the text"]
[null,null,"string","shortestWord",null,null,"return the word composed of minimun characters in the text"]
[null,null,"int","shortestWordLength",null,null,"return the number of characters composing the longest word in the text"]
[]
["Length","Occurance","hashtable","wordOccurance",null,null,"return a hashtable of number of times for every word appears in the text"]
[null,null,"hashtable","wordFrequency",null,null,"return a hashtable of frequency appears in a text (frequence =  wordOccurance / numOfWord)"]
[null,null,"array","topWords","enum sort","int range","return a sorted array of most frequently occuring words"]
[null,null,"hashtable","wordRanks","enum sort","int range","return a sorted hashtable ranking the frequency of words"]
[]
[null,"Detection","string[]","checkMisspell",null,null,"return an array of mis-spelled words in the text"]
[null,null,null,"findWord","string s",null,"return words in the text that exactly match required word s"]
[null,null,null,"findSynonym","string s",null,"return words in the text that is synonym of required word s"]
[]
[null,"Syllables","double","averageSyllables",null,null,"return the average syllables in each words in the text"]
[null,null,"int","maxSyllables",null,null,"return the number of syllables of the word with the highest number of syllables"]
[null,null,"int","minSyllables",null,null,"return the number of syllables of the word with least number of syllables"]
[null,null,"int","hardWords",null,null,"return the number of words with 3 or more syllables"]
[]
[null,"Part of Speech",null,"posTag",null,null,"return the part of speech for every word in the text","Brown Corpus"," www.en.wikipedia.org/wiki/Brown_Corpus"]
[]
[null,"Sequence"]
[]
[]
[null,"Chinese"]
[null,"Quantity","int","numOfWords",null,null,"count the total number of words in the corpus"]
[null,null,"int","numOfUniqueWords",null,null,"count the number of unique words"]
[]
[null,"Length","double","averageWordLength",null,null,"return the average length of all sentences in the text"]
[null,null,"string","longesetWord",null,null,"return the word composed of maximun number of characters in the text"]
[null,null,"int","longestWordLength",null,null,"return the number of characters composing the longest word in the text"]
[null,null,"string","shortestWord",null,null,"return the word composed of minimun characters in the text"]
[null,null,"int","shortestWordLength",null,null,"return the number of characters composing the longest word in the text"]
[]
[null,"Occurance","hashtable","wordOccurance",null,null,"return a hashtable of number of times for every word appears in the text"]
[null,null,"hashtable","wordFrequency",null,null,"return a hashtable of frequency appears in a text (frequence =  wordOccurance / numOfWord)"]
[null,null,"array","topWords","enum sort","int range","return a sorted array of most frequently occuring words"]
[null,null,"hashtable","wordRanks","enum sort","int range","return a sorted hashtable ranking the frequency of words"]
[]
[null,"Detection","string[]","checkMisspell",null,null,"return an array of mis-spelled words in the text","common Chinese word misspelled: wrong character with 1/similar sound, or 2/similar structure"]
[null,null,null,"findWord","string s",null,"return words in the text that exactly match required word s"]
[null,null,null,"findSynonym","string s",null,"return words in the text that is synonym of required word s"]
[]
[null,null,"int","hardWords",null,null,"return the number of words with 3 or more syllables"]
[]
[]
[]
[]
[null,"Part of Speech",null,"posTag",null,null,"return the part of speech for every word in the text","Brown Corpus"," www.en.wikipedia.org/wiki/Brown_Corpus"]

{"sheet":"Sentences","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Sentence Level","return type","function name","argument 1","argument 2","description"]
[null,"English/ Chinese"]
[null,null,"int","numOfSentences",null,null,"count the total number of sentences in the corpus"]
[null,null,"hashtable","sentenceLength",null,null,"return a hashtable of sentence length"]
[null,null,"double","averageSentenceLength",null,null,"return the average number of words in each sentence in the text "]
[null,null,"int","longestSentenceLength",null,null,"return the length of the longest sentence"]
[null,null,"int","shortestSentenceLength",null,null,"return the length of the shortest sentence"]
[null,null,"string","longestSentence",null,null,"return the longest sentence"]
[null,null,"string","shortestSentence",null,null,"return the shortest sentence"]

{"sheet":"Text","index":5,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Text Level","return type","function name","argument 1","argument 2","description","reference","link"]
[null,"English"]
[null,"Complexity","double","lexicalDensity",null,null,"return number of unique words / total number of words","Lexical Density"]
[null,"Readability","double","GFI",null,null,"return Gunning Fog Index","Gunning Fog Index","www.en.wikipedia.org/wiki/Gunning-fog_Index"]
[null,null,"double","ARI",null,null,"return Automated Readability Index","Automated Readability Index","www.en.wikipedia.org/wiki/Automated_Readability_Index"]
[null,null,"double","SMOG",null,null,"return  SMOG","Simple Measure Of Gobbledygook","www.en.wikipedia.org/wiki/SMOG_%28Simple_Measure_Of_Gobbledygook%29"]
[null,null,"double","FKRT",null,null,"return grade of Flesch-Kincaid Readability Test","Flesch-Kincaid Readability Test","www.en.wikipedia.org/wiki/Flesch-Kincaid_Readability_Test"]
[null,null,"double","CLI",null,null,"return Coleman Liau Index","Coleman-Liau Index","www.en.wikipedia.org/wiki/Coleman-Liau_Index"]
[]
[]
[null,"Chinese"]
["Length","Complexity","double","lexicalDensity",null,null,"return number of unique words / total number of words","Lexical Density"]

{"sheet":"TextAnalyzers","index":6,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Hyperpo","usingEnglish.com","Textalyser","TAPoR"]