tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 194603d1353261035-monthly-calculations-pt-group-by-month
Sheet: Sheet1

Date | Data
2012-01-01 00:00:00
2012-01-02 00:00:00
2012-01-03 00:00:00 |  |  | Row Labels | Sum of Data
2012-01-04 00:00:00 |  |  | Jan | 104
2012-01-05 00:00:00 |  |  | Feb | 90
2012-01-06 00:00:00 |  |  | Grand Total | 194
2012-01-07 00:00:00
2012-01-08 00:00:00
2012-01-09 00:00:00
2012-01-10 00:00:00
2012-01-11 00:00:00
2012-01-12 00:00:00
2012-01-13 00:00:00
2012-01-14 00:00:00
2012-01-15 00:00:00
2012-01-16 00:00:00
2012-01-17 00:00:00
2012-01-18 00:00:00
2012-01-19 00:00:00
2012-01-20 00:00:00
2012-01-21 00:00:00
2012-01-22 00:00:00
2012-01-23 00:00:00
2012-01-24 00:00:00
2012-01-25 00:00:00
2012-01-26 00:00:00
2012-01-27 00:00:00
2012-01-28 00:00:00
2012-01-29 00:00:00
2012-01-30 00:00:00
2012-01-31 00:00:00
2012-02-01 00:00:00
2012-02-02 00:00:00
2012-02-03 00:00:00
2012-02-04 00:00:00
2012-02-05 00:00:00
2012-02-06 00:00:00
2012-02-07 00:00:00
2012-02-08 00:00:00
2012-02-09 00:00:00
2012-02-10 00:00:00
2012-02-11 00:00:00
2012-02-12 00:00:00
2012-02-13 00:00:00
2012-02-14 00:00:00
2012-02-15 00:00:00
2012-02-16 00:00:00
2012-02-17 00:00:00
2012-02-18 00:00:00
2012-02-19 00:00:00
2012-02-20 00:00:00
2012-02-21 00:00:00
2012-02-22 00:00:00
2012-02-23 00:00:00
2012-02-24 00:00:00
2012-02-25 00:00:00
2012-02-26 00:00:00
2012-02-27 00:00:00
2012-02-28 00:00:00
2012-02-29 00:00:00
Spreadsheet: 136692d1326793736-cumulative-count-abbreviated-example
Sheet: Sheet1

a |  | 1
a |  | 1
b |  | 2
b |  | 2
 |  | 2
 |  | 2
c |  | 3
a |  | 3
a |  | 3
 |  | 3
b |  | 3
a |  | 3
g |  | 4
 |  | 4
 |  | 4
 |  | 4
h |  | 5
 |  | 5
i |  | 6
j |  | 7
k |  | 8
f |  | 8
f |  | 8
 |  | 8
a |  | 8
a |  | 8
a |  | 8
b |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
c |  | 8
d |  | 9
Spreadsheet: 800275d1665575273-replace-outlier-and-empty-cell-to-calculate-reliable-average-media-no-outlier_celle-vuote
Sheet: Foglio1

[NAME] originale
5
8
2
8
2
3
9
12
5
3
5
7
9
8
4
6
2
2
2
8
2
3
6
5
60
4
8
1
6
5
2
10
6
7
8
3
9
9
5
1
Spreadsheet: 63006d1263983153-gathering-information-by-the-most-recent-dates-cashier-work-history-test-1-
Sheet: Employee Summary

 | Employee Summary
 | Employee Name: |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Employee #: |  |  |  |  |  | 12345
 | ACES (Lastest Entries):
 | Date |  |  |  | Observed by |  |  |  |  |  |  |  |  | Score |  |  | Average
 | 2010-01-15 00:00:00 |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 20 |  |  | 4
 | 2010-01-18 00:00:00 |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 23 |  |  | 4.6
 | 2010-01-20 00:00:00 |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 16 |  |  | 3.2
Spreadsheet: 688015d1595525928-need-running-sum-based-on-filtered-records-running-sum-filtered-example-test
Sheet: Sheet1

Organization | Amount | Running Total |  | Select Budget: | 200
ABC | 40
ABC | 32
ABC | 52
KLM | 70
KLM | 50
KLM | 69
RST | 45
RST | 35
RST | 49
XYZ | 59
XYZ | 32
XYZ | 57
Spreadsheet: 862494d1710207261-exclude-holidays-in-total-holiday-sample-1-
Sheet: Jan

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance | Current formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If Holiday is on Weekend
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance | Aiming for this result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3.5 | 4 | 10
 |  | 2018-01-01 00:00:00 | 1 | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 0.5 |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | Holiday fall on weekend | 3.5 days is filled | 4 Weekend is filled excluding Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If Holiday is on Weekdays
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance | Aiming for this result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 6.5 | 2 | 10
 |  | 2018-01-01 00:00:00 | 1 | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 0.5 |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | Holiday fall on weekdays | 6.5 days is filled | 2 Weekend is filled excluding Holiday
Spreadsheet: 106082d5-9a85-4ea6-a437-f0177bc58a32
Sheet: Sheet1

Table 1--Wheat: U.S. market year supply and disappearance, 12/13/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Item and unit |  |  | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13
 | Area: Planted | Million acres | 57.334 | 60.46 | 63.193 | 59.168 | 53.593 | 54.409 | 55.736
 | Harvested | Million acres | 46.8 | 50.999 | 55.699 | 49.893 | 47.619 | 45.705 | 48.991
 | Yield | Bushels per acre | 38.6 | 40.2 | 44.9 | 44.5 | 46.3 | 43.7 | 46.3
 | Supply: Beginning stocks | Million bushels | 571.19 | 456.153 | 305.818 | 656.505 | 975.637 | 862.246 | 742.62
 | Production | Million bushels | 1808.416 | 2051.088 | 2499.164 | 2218.061 | 2206.916 | 1999.347 | 2269.117
 | Imports 1/ | Million bushels | 121.862 | 112.631 | 126.971 | 118.59 | 96.92 | 112.064 | 130
 | Total supply | Million bushels | 2501.468 | 2619.872 | 2931.953 | 2993.156 | 3279.473 | 2973.657 | 3141.737
 | Disappearance: Food use | Million bushels | 937.911 | 947.865 | 926.769 | 918.92 | 925.641 | 941.387 | 950
 | Seed use | Million bushels | 81.869 | 87.615 | 78.045 | 69.471 | 70.889 | 76.271 | 73
 | Feed and residual use | Million bushels | 117.059 | 15.962 | 255.219 | 149.85 | 131.864 | 163.866 | 315
 | Total domestic use | Million bushels | 1136.839 | 1051.442 | 1260.033 | 1138.241 | 1128.394 | 1181.524 | 1338
 | Exports 1/ | Million bushels | 908.476 | 1262.612 | 1015.415 | 879.278 | 1288.833 | 1049.513 | 1050
 | Total disapperance | Million bushels | 2045.315 | 2314.054 | 2275.448 | 2017.519 | 2417.227 | 2231.037 | 2388
 | Ending stocks | Million bushels | 456.153 | 305.818 | 656.505 | 975.637 | 862.246 | 742.62 | 753.737
 | CCC inventory 2/ | Million bushels | 41
 | Stocks-to-use ratio |  | 22.3023 | 13.2157 | 28.8517 | 48.3583 | 35.6709 | 33.2859 | 31.5635
 | Loan rate | Dollars per bushel | 2.75 | 2.75 | 2.75 | 2.75 | 2.94 | 2.94 | 2.94
 | Contract/direct payment rate | Dollars per bushel | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52
 | Farm price 3/ | Dollars per bushel | 4.26 | 6.48 | 6.78 | 4.87 | 5.7 | 7.24 | 7.70-8.30
 | Government payments | Million dollars | 1120 | 1118
 | Market value of production | Million dollars | 7694.734 | 13289.326 | 16625.759 | 10654.115 | 12827.254 | 14475.2723 | 18152.936
Latest market year is projected; previous market year is estimated. Totals may not add due to rounding. 1/ Includes flour and selected other products expressed in grain-equivalent bushels. 2/ Stocks owned by USDA's Commodity Credit Corporation (CCC). Most CCC-owned inventory is in the Bill Emerson Humanitarian Trust.
3/ U.S. season-average price based on monthly prices weighted by monthly marketings. Prices do not include an allowance for loans outstanding and government purchases. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Date run: 12/11/2012
Spreadsheet: 2e0a652e-5d43-4a12-bae7-c7e17db7ba6c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  | High School to College and Career Pathway: Post-Secondary
 | Region: |  |  |  |  |  |  | Area of Study:
 | District: |  |  |  |  |  |  | Pathway:
 | School: |  |  |  |  |  |  | College/Institution:
 | Contact: |  |  |  |  |  |  | Articulation Agreement in Place?
 | Phone: |  |  |  |  |  |  | Date:
 | [NAME]:
 | Name of Degree or Certificate:
 |  |  |  |  |  |  |  | Legend (CTE Course Type)
 |  |  |  |  |  |  |  | I = Introductory Course: (preferred) |  |  | E = Elective Course
 |  |  |  |  |  |  |  | F = Foundation Course: (required) |  |  | A = Additional Articulated Course
 | HIGH SCHOOL |  |  |  |  |  |  |  |  |  |  | COLLEGE
 |  |  |  |  |  | Core Code | High School Suggested Academic Courses |  | H S Credit | Concurrent College Credit |  | College Course # | College General Education Requirements | College Credit
 | [NAME] | CTE Course Type |  |  |  | CIP # | High School Suggested CTE Pathway Courses |  | H S Credit | Concurrent College Credit |  | College Course # | College Major Course Requirements | College Credit
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | Total potential credits earned in High School: |  |  |  |  |  |  |  |  |  |  | Total credits required for Degree/Certificate:
Spreadsheet: 36974d1234909681-formula-that-count-repeated-entries-given-a-text-condition-example-attached-example
Sheet: Sheet1

ID | Type
1001 | a |  | Result | Notice: that the function I am looking for is to tell me how many duplicates in ID for a particular text
1002 | a
1001 | a |  |  | (A) dublicate cases | (b) duplicate cases | G | H | T
1005 | b |  |  | 4 | 2 | 0 | 0 | 0
1005 | b
1006 | g
1007 | h
1001 | h
1005 | t
1009 | a
1009 | a
1223 | b
Spreadsheet: 850070d1700471820-sum-spilled-array-sample
Sheet: Sheet1

RND 2310 530 10 + 30 |  |  |  |  | 2310 | 530 | 10 | + | 30 |  |  | 2310 | 530 | 10 | + | 30
RND 2400 10 0 + 10 |  |  |  |  | 2400 | 10 | 0 | + | 10 |  | RND | 2400 | 10 | 0 | + | 10
RND 2420 6 0 + 6 |  |  |  |  | 2420 | 6 | 0 | + | 6 |  | RND | 2420 | 6 | 0 | + | 6
RND 2440 3 0 + 3 |  |  |  |  | 2440 | 3 | 0 | + | 3 |  | RND | 2440 | 3 | 0 | + | 3
RND 2460 428 8 + 28 |  |  |  |  | 2460 | 428 | 8 | + | 28 |  | RND | 2460 | 428 | 8 | + | 28
RND 2490 6 0 + 6 |  |  |  |  | 2490 | 6 | 0 | + | 6 |  | RND | 2490 | 6 | 0 | + | 6
RND 2640 227 4 + 27 |  |  |  |  | 2640 | 227 | 4 | + | 27 |  | RND | 2640 | 227 | 4 | + | 27
 |  |  |  |  | sum |  |  | why is this 0?
Spreadsheet: 794100d1661874411-vlookup-returning-an-na-error-for-specific-table-array-excel-help
Sheet: Sheet1

Practice Code | NHS health board | GP list size
10002
10017
10106
10125
10182
10233
10286
10322
10361
10407
10445
10498
10553
Spreadsheet: 684733d1593517594-work-down-list-based-on-allocation-example
Sheet: Allocation

Reference number | Business lookup
1234 | Business 1
8765 | Business 1
9877 | Business 2
2345 | Business 2
9876 | Business 2
4567 | Business 2
1239 | Business 2
9876 | Business 2
5432 | Business 3
9876 | Business 3
3698 | Business 3
3685 | Business 4
2573 | Business 5
2357 | Business 5
7654 | Business 5
2345 | Business 5
7654 | Business 5
5432 | Business 5
1238 | Business 5
4875 | Business 5
9473 | Business 5
Spreadsheet: 90397d1290119714-excel-2007-need-to-count-add-records-values-in-a-date-range-forecast
Sheet: Sheet2

Week Ending | Orders | Books | Pages | Sheets | [NAME] | Total Sheets
2010-03-06 00:00:00 | 6 | 622 | 41904
2010-03-13 00:00:00
2010-03-20 00:00:00
2010-03-27 00:00:00
2010-04-03 00:00:00
2010-04-10 00:00:00
2010-04-17 00:00:00
2010-04-24 00:00:00
2010-05-01 00:00:00
2010-05-08 00:00:00
2010-05-15 00:00:00
2010-05-22 00:00:00
2010-05-29 00:00:00
2010-06-05 00:00:00
2010-06-12 00:00:00
2010-06-19 00:00:00
2010-06-26 00:00:00
2010-07-03 00:00:00
2010-07-10 00:00:00
2010-07-17 00:00:00
2010-07-24 00:00:00
2010-07-31 00:00:00
2010-08-07 00:00:00
2010-08-14 00:00:00
2010-08-21 00:00:00
2010-08-28 00:00:00
2010-09-04 00:00:00
2010-09-11 00:00:00
2010-09-18 00:00:00
2010-09-25 00:00:00
2010-10-02 00:00:00
2010-10-09 00:00:00
2010-10-16 00:00:00
2010-10-23 00:00:00
2010-10-30 00:00:00
2010-11-06 00:00:00
2010-11-13 00:00:00
2010-11-20 00:00:00
2010-11-27 00:00:00
2010-12-04 00:00:00
2010-12-11 00:00:00
2010-12-18 00:00:00
2010-12-25 00:00:00
2011-01-01 00:00:00
Spreadsheet: 136177d1326461743-retrieve-row-of-data-only-when-a-certain-word-is-in-a-particular-cell-in-that-row-copy-of-example-6
Sheet: Sheet2

Date | Source | Supplier | Material Type | Assay No | [NAME] | [NAME] | Heavies | [NAME] | [NAME] | Stones | Fines | % [NAME] | % Hvy
Spreadsheet: 721272d1614618500-combine-5-lists-into-one-list-combine-5lists-into-one-big-list
Sheet: Report

No | Employee Name | Job
1 | A | Job AA
2 | B | Job AA |  | Required:
3 | C | Job AA |  | Sheet Data contains 5 Lists in different columns
4 | D | Job AA |  | I want to combine them in one big list (in one column) in sheet Report
5 | E | Job AA
6 | F | Job AA
7 | G | Job AA
8 | H | Job AA
9 | I | Job BB
10 | J | Job BB
11 | K | Job BB
12 | L | Job AA
13 | M | Job AA
14 | N | Job AA
15 | O | Job AA
16 | P | Job AA
17 | Q | Job AA
18 | R | Job AA
19 | S | Job AA
20 | T | Job BB
21 | U | Job BB
22 | V | Job AA
23 | W | Job AA
24 | X | Job AA
25 | Y | Job AA
26 | Z | Job AA
27 | AA | Job AA
28 | BB | Job AA
29 | CC | Job AA
30 | DD | Job BB
31 | EE | Job BB
32 | FF | Job BB
33 | GG | Job AA
34 | HH | Job AA
35 | II | Job AA
36 | JJ | Job AA
37 | KK | Job AA
38 | LL | Job AA
39 | MM | Job AA
40 | NN | Job AA
41 | OO | Job BB
42 | PP | Job BB
43 | OO | Job AA
44 | PP | Job AA
45 | QQ | Job AA
46 | RR | Job AA
47 | SS | Job AA
48 | TT | Job AA
49 | UU | Job AA
50 | VV | Job AA
51 | WW | Job BB
52 | XX | Job BB
53 | YY | Job BB
54 | ZZ | Job BB
55 | AAA | Job cc
56 | BBB | Job cc
57 | CCC | Job cc
58 | DDD | Job cc
59 | EEE | Job cc
60 | FFF | Job cc
61 | GGG | Job cc
62 | HHH | Job DD
63 | III | Job DD
64 | JJJ | Job DD
65 | KKK | Job DD
66 | LLL | Job DD
67 | MMM | Job DD
68 | NNN | Job DD
69 | OOO | Job DD
70 | PPP | Job DD
71 | QQQ | Job DD
72 | RRR | Job DD
Spreadsheet: 137608d1327256429-excel-2007-how-do-i-write-a-if-calculation-not-to-count-two-cells-with-zero-as-a-default-atest21112
Sheet: Sheet1

Round 7 |  |  |  |  |  | Round8 |  |  |  |  |  |  | Total |  |  | Game Won(win=2; draw=1; loss=0)
For | Away | + / - | Acc | Points | R | For | Away | + / - | Acc | Points | R |  | For | Away | + / - | Points | Won | Draw | Lost
0 | 0 | 0 | 0 | 1 |  | 3 | 3 | 0 | 0 | 1 | D |  | 3 | 3 | 0 | 2 | 0 | 1 | 0
0 | 0 | 0 | 0 | 1 | D | 1 | 0 | 1 | 1 | 2 | W |  | 1 | 0 | 1 | 3 | 1 | 1 | 0
 |  | 0 | 0 | 1 | D |  |  | 0 | 0 | 1 | D |  | 0 | 0 | 0 | 2 | 0 | 2 | 0
Spreadsheet: 4b5465d6-b40c-489a-a6b6-7c35fe8b28a6
Sheet: Judul Masuk (2)

DAFTAR JUDUL PROPOSAL MASUK
[NAME] ILMU HUKUM
UIN SUSKA RIAU
NO | Nama | L/P | NIM | [NAME] | [NAME] | [NAME] | Ket
165 | Silvina | P | 10621003722 |  | 2010-04-23 00:00:00 | Konsep Perlindungan Anak di KPAID ([NAME] Indonesia [NAME]) Kota Pekanbaru Ditinjau Menurut Hukum Islam.
111 | [NAME] | P | 10621003689 |  | 2010-04-06 00:00:00 | Sertifikasi [NAME] (Studi [NAME] Masyarakat [NAME] [NAME] di Kecamatan Tambusai Utara [NAME]).
342 | [NAME] | L | 10424025098 | [NAME] | 2010-07-28 00:00:00 | Problematika Pemekaran Desa Di Desa Tanjung Barat Menjadi Desa Devenitif di [NAME] Hulu [NAME] di Tinjau Dari Hukum Islam
183 | M.  Arif | L | [PHONE] | 11419/2003 | 2003-05-31 00:00:00 | Desa Baru | 1976-03-11 00:00:00 | Tinjauan Hukum Islam Terhadap Sistem Pemberian Kredit [NAME] [NAME] Pada Bank [NAME]. | 2.81 | Prof. Dr. [NAME], MA
Spreadsheet: 2416a850-6bdc-4b8a-a4b1-66a0e0f81bc2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 11. Input to the [NAME] mining industry, index numbers and percentage changes
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Number ;  Open cut mining ; |  |  | Original | A2314310A | 1987-09-01 00:00:00 | 2013-03-01 00:00:00 | 103 | Index Numbers | INDEX | Quarter | 3
Percentage change from pervious quarter ;  Open cut mining ; |  |  | Original | A2314311C | 1987-12-01 00:00:00 | 2013-03-01 00:00:00 | 102 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Open cut mining ; |  |  | Original | A2314312F | 1988-09-01 00:00:00 | 2013-03-01 00:00:00 | 99 | Percent | PERCENT | Quarter | 3
Index Number ;  Underground mining ; |  |  | Original | A2314376T | 1987-09-01 00:00:00 | 2013-03-01 00:00:00 | 103 | Index Numbers | INDEX | Quarter | 3
Percentage change from pervious quarter ;  Underground mining ; |  |  | Original | A2314377V | 1987-12-01 00:00:00 | 2013-03-01 00:00:00 | 102 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Underground mining ; |  |  | Original | A2314378W | 1988-09-01 00:00:00 | 2013-03-01 00:00:00 | 99 | Percent | PERCENT | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 152220d1335289364-excel-sumif-formula-vfss_ytd-formulas
Sheet: 2012

 |  |  |  |  |  |  |  |  |  |  |  |  | Updated:
 | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec | YTD | Total Year
Actual | 10990 | -4475 | -10766 | 9800 | 9800 | 9800 | 9800 | 9800 | 9800 | 9800 | 9800 | 9800
Budget | 19008 | 11637 | -19373
[NAME]
Actual
Budget
[NAME]
Actual
Budget
[NAME]
Actual
Budget
[NAME]
Actual
Budget
[NAME]
Actual
Budget
[NAME]
Spreadsheet: 76961d1277402214-copying-and-pasting-with-enhanced-metafile-workbook
Sheet: Selected Financial Data

 |  |  |  | 3282021 | First Madison Bank & Trust | 4101239
 |  |  |  |  |  |  |  |  |  | For the Year Ended December 31, |  |  |  |  |  |  |  |  |  | Growth Rates
Description: |  |  |  |  |  |  | Peer (1) | Peer (2) | 2010Q1 | 2009Y | 2008Y | 2007Y | 2006Y | 2005Y | 2004Y | 2003Y | 2002Y | 2001Y | 2000Y | 07-08 | 00-07
BALANCE SHEET DATA:
 |  | Total Assets |  | 6826
 |  | Investment Securities |  | 6812
 |  | Loans, net of unearned income |  | 6816
 |  | Loan Loss Reserve |  | 6817
 |  | Total Deposits |  | 6827
 |  | Stockholders' Equity |  | 6844
 |  | Common Shares Outstanding
 |  | Book Value per Share
INCOME STATEMENT DATA:
 |  | Net Interest Income |  | 7024
 |  | Provision for Loan Losses |  | 7025
 |  | Securities Gains/(Losses) |  | 7038
 |  | Other Income |  | 7029
 |  | Other Expenses |  | 7033
 |  | Income Before Taxes |  | 7040
 |  | Tax Provision |  | 7041
 |  | Net Income |  | 7045
 |  | Dividends |  | 8394
 |  | Earnings Per Share
 |  | Dividends Per Share
PROFITABILITY:
 |  | ROAA |  | 6760
 |  | ROAE |  | 6761
 |  | Net Interest Margin |  | 6765
 |  | Noninterest Income / Avg Assets |  | 6763
 |  | Overhead / Avg Assets |  | 6764
 |  | Loans / Deposits
CAPITAL ADEQUACY
 |  | Equity / Assets
 |  | [NAME]. Equity / Tang. Assets |  | 9880
 |  | [NAME]. Comm. Equity / Tang. Assets |  | 19060
 |  | Leverage Ratio |  | 6774
 |  | Tier 1 Capital Ratio |  | 6772
 |  | Total Risk Based Capital Ratio |  | 6773
ASSET QUALITY
 |  | Nonperforming Assets:
 |  |  | Loans Past Due Over 90 Days | 6981
 |  |  | Nonaccrual Loans | 6998
 |  |  | Restructured Loans | 6964
 |  |  | Other Real Estate Owned | 7008
 |  | Nonperforming Assets + Loans <90 Days PD ("NPAs")
 |  | NPA's / Total Assets |  | 6794
 |  | Loss Reserve / Loans
 |  | Net Charge-Offs / Average Loans |  | 6801
Sources:  Audited Financial Statements, Bank Call Reports and Uniform Bank Performance Reports
Peer (1): Top quartile (by ROAA) of all publicly traded banks between $250-$500 million in assets
Peer (2): All Publicly traded banks between $250-$500 million in assets
Spreadsheet: 165371d1341204676-multiple-row-and-column-based-record-to-linear-format-10-06-12-lost
Sheet: South Distt.

Control Room No | 3335 | State | DELHI
FIR Number | 104/12 | District | SOUTH DISTRICT
FIR Date | 2012-06-10 00:00:00 | Police Station | SAROJNI NAGAR
Vehicle Type | CAR | Registration Number | DL5CB8666
[NAME] | CAR - TATA INDICA | Engine Number | 1965
[NAME] | 2006 | Chasis Number | 600136
Vehicle Color | GREY | Phone Number | 9410263732
Complainant | SANJAY SINGH | Address | E-1/191 NAND NAGRI
Stolen From | SAROJINI NAGAR MARKET ME GATE NO.-1 KE PASS
Status | STOLEN/THEFT | Reporting Date/Time on ZIPNET | 2012-06-10 00:05:42.010000
Control Room No | 3332 | State | DELHI
FIR Number | 185/12 | District | SOUTH DISTRICT
FIR Date | 2012-06-10 00:00:00 | Police Station | SAKET
Vehicle Type | CAR | Registration Number | DL2CV9854
[NAME] | CAR - MARUTI VAN | Engine Number | 80851
[NAME] | - | Chasis Number | 54073
Vehicle Color | UNKNOWN | Phone Number | -
Complainant | RAKESH LAL | Address | J-205 SAKET
Stolen From | J-205 SAKET
Status | STOLEN/THEFT | Report Dt./Time on ZIPNET | 2012-06-10 00:03:31.240000
Control Room No | 3340 | State | DELHI
FIR Number | 219/12 | District | SOUTH DISTRICT
FIR Date | 2012-06-10 00:00:00 | Police Station | MALVIYA NAGAR
Vehicle Type | CAR | Registration Number | DL3CAC7127
[NAME] | CAR - TATA INDICA | Engine Number | 4220
[NAME] | 2007 | Chasis Number | 3693
Vehicle Color | RED DARK | Phone Number | 9911773628
Complainant | PRITAM | Address | SAME
Stolen From | A-51 FLAT NO-3 PANCHSHEEL VIHAR
Status | STOLEN/THEFT | Report Dt./Time on ZIPNET | 2012-06-10 12:09:36.410000
Control Room No | 3320 | State | DELHI
FIR Number | 177/12 | District | SOUTH DISTRICT
FIR Date | 2012-06-10 00:00:00 | Police Station | VASANT KUNJ SOUTH
Vehicle Type | CAR | Registration Number | DL6CF5210
[NAME] | CAR - MARUTI ESTEEM | Engine Number | 624150
[NAME] | - | Chasis Number | 255929
Vehicle Color | MAROON | Phone Number | 9560704774
Complainant | MAHRUM | Address | SAME
Stolen From | B1471 VASANT KUNJ ENC.
Status | STOLEN/THEFT | Reporting Date/Time on ZIPNET | 2012-06-10 00:07:36.230000
Spreadsheet: 812832d1673402628-counting-across-range-with-multiple-criteria-irregular-table-setup-excel-forum-counting-acrross-ranges
Sheet: Sheet1

 | Entries
 |  |  |  |  |  |  |  |  |  | Expected Output
 | House | ok | CAR | 2 | Kitchen | ok |  |  |  |  | % ok ( count) | % of numbers(count)
 | Kitchen | ok |  |  | House | 3 |  |  |  | House | 3 | 4
 | House | 1 |  |  | House | 3 |  |  |  | Kitchen | 4 | 1
 | House | ok |  |  |  |  | Kitchen | ok |  | CAR | 1 | 1
 | Kitchen | 2 |  |  |  |  | House | ok
 | CAR |  |  |  |  |  | House | 4
 |  |  | Kitchen | ok
 |  |  |  | 2 | CAR | ok
 |  |  | How many "ok" for HOUSE
 |  |  | How many number entry for "HOUSE"
 |  |  | How many "ok" for Kitchen
 |  |  | How many number entry for Kitchen
 |  |  | How many "ok" for CAR
 |  |  | How many "number entries for CAR
Spreadsheet: 26932d1219660058-lookup-function-driver-login
Sheet: 6.24.08

 |  |  |  | Trailer Type
 | Pick-up # | Destination | Customer | Van | Flat | PIG | Trucking Co. | Appointment Time | Time In | Time Out
1 |  |  |  |  |  |  |  | 7:30 A.M.
2 |  |  |  |  |  |  |  | [NAME]
3 |  |  |  |  |  |  |  | 8:30 A.M.
 |  |  |  |  |  |  | BREAK | 9:15 A.M.
4 |  |  |  |  |  |  |  | 9:30 A.M.
5 |  |  |  |  |  |  |  | 10:00 A.M.
6 |  |  |  |  |  |  |  | 10:30 A.M.
 |  |  |  |  |  |  | LUNCH | 11:00 A.M
7 |  |  |  |  |  |  |  | 11:30 A.M.
8 |  |  |  |  |  |  |  | 12:00 P.M.
9 |  |  |  |  |  |  |  | 12:30 P.M.
10 |  |  |  |  |  |  |  | 1:00 P.M.
 |  |  |  |  |  |  | BREAK | 1:30 P.M.
11 |  |  |  |  |  |  |  | 1:45 P.M.
12 |  |  |  |  |  |  |  | 2:15 P.M.
13 |  |  |  |  |  |  |  | 2:45 P.M.
14 |  |  |  |  |  |  |  | 3:15 P.M.
15 |  |  |  |  |  |  |  | 3:45 P.M.
16 |  |  |  |  |  |  |  | 4:15 P.M.
17 |  |  |  |  |  |  |  | 4:45 P.M.
 |  |  |  |  |  |  | BREAK | 5:30 P.M.
18 |  |  |  |  |  |  |  | 5:45 P.M.
19 |  |  |  |  |  |  |  | 6:15 P.M.
20 |  |  |  |  |  |  |  | 7:00 P.M.
 |  |  |  |  |  |  | LUNCH | 7:30 P.M.
21 |  |  |  |  |  |  |  | 8:00 P.M.
22 |  |  |  |  |  |  |  | 8:30 P.M.
 |  |  |  |  |  |  | BREAK | 9:30 P.M.
23 |  |  |  |  |  |  |  | 9:45 P.M.
24 |  |  |  |  |  |  |  | 10:45 P.M.
25 |  |  |  |  |  |  |  | 11:45 P.M.
26 |  |  |  |  |  |  |  | 12:45 A.M.