tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 20e6b8de-3f96-4838-a923-c040b9d7a8fb
Sheet: Sheet1

PRESIDENTIAL PRIMARY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
1996-02-20 00:00:00
Names on Checklist
Grafton County | Republican | Democratic | Libertarian | Undeclared | Total |  | Code A | Code B | Code C
[NAME] | 394 | 140 | 12 | 192 | 738 |  | 22 | 102 | 65
Ashland | 587 | 331 | 3 | 235 | 1156 |  | 47 | 111 | 67
Bath | 256 | 64 | 0 | 187 | 507 |  | 5 | 62 | 20
[NAME] | 95 | 17 | 0 | 49 | 161 |  | 0 | 0 | 1
Bethlehem | 532 | 296 | 3 | 298 | 1129 |  | 57 | 163 | 130
Bridgewater | 369 | 127 | 6 | 141 | 643 |  | 20 | 41 | 33
Bristol | 912 | 320 | 4 | 341 | 1577 |  | 59 | 150 | 76
Campton | 562 | 264 | 7 | 566 | 1399 |  | 57 | 182 | 155
Canaan | 654 | 523 | 4 | 709 | 1890 |  | 49 | 154 | 136
Dorchester | 111 | 53 | 0 | 74 | 238 |  | 6 | 20 | 4
Easton | 96 | 53 | 0 | 58 | 207 |  | 4 | 23 | 18
Ellsworth | 24 | 2 | 3 | 18 | 47 |  | 0 | 11 | 11
Enfield | 848 | 661 | 5 | 743 | 2257 |  | 82 | 197 | 160
Franconia | 300 | 161 | 0 | 151 | 612 |  | 21 | 67 | 61
[NAME] | 211 | 177 | 2 | 210 | 600 |  | 14 | 67 | 21
[NAME] | 119 | 60 | 2 | 96 | 277 |  | 3 | 24 | 7
Hanover | 1700 | 2164 | 9 | 1941 | 5814 |  | 551 | 410 | 397
Haverhill | 1200 | 308 | 3 | 826 | 2337 |  | 27 | 50 | 50
Hebron | 248 | 37 | 0 | 62 | 347 |  | 9 | 68 | 44
Holderness | 605 | 281 | 4 | 363 | 1253 |  | 54 | 79 | 79
Landaff | 83 | 41 | 2 | 90 | 216 |  | 5 | 11 | 0
Lebanon Ward 1 | 1120 | 814 | 6 | 516 | 2456 |  | 95 | 207 | 184
Lebanon Ward 2 | 868 | 849 | 2 | 577 | 2296 |  | 61 | 178 | 141
Lebanon Ward3 | 827 | 805 | 4 | 648 | 2284 |  | 49 | 114 | 41
Lincoln | 323 | 216 | 2 | 417 | 958 |  | 33 | 81 | 42
Lisbon | 362 | 130 | 2 | 371 | 865 |  | 8 | 95 | 24
Littleton | 1399 | 713 | 2 | 1005 | 3119 |  | 71 | 205 | 83
Livermore | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
[NAME] | 117 | 76 | 0 | 93 | 286 |  | 2 | 26 | 10
Lyme | 381 | 512 | 1 | 233 | 1127 |  | 13 | 107 | 46
Monroe | 341 | 71 | 2 | 134 | 548 |  | 8 | 40 | 6
Orange | 66 | 39 | 0 | 59 | 164 |  | 2 | 22 | 16
Orford | 301 | 194 | 0 | 249 | 744 |  | 20 | 67 | 38
Piermont | 173 | 67 | 1 | 187 | 428 |  | 4 | 22 | 37
Plymouth | 1543 | 958 | 16 | 1321 | 3838 |  | 340 | 373 | 213
Rumney | 553 | 153 | 6 | 228 | 940 |  | 33 | 159 | 116
[NAME] | 216 | 80 | 1 | 93 | 390 |  | 7 | 25 | 24
[NAME] | 372 | 161 | 5 | 660 | 1198 |  | 17 | 203 | 135
[NAME] | 257 | 104 | 3 | 214 | 578 |  | 6 | 37 | 22
Waterville Valley | 95 | 35 | 0 | 36 | 166 |  | 5 | 37 | 26
Wentworth | 271 | 86 | 10 | 90 | 457 |  | 10 | 22 | 4
Woodstock | 334 | 166 | 2 | 215 | 717 |  | 17 | 98 | 32
Totals | 19825 | 12309 | 134 | 14696 | 46964 |  | 1893 | 4110 | 2775
Code A: Number of persons who registered to vote at the polling place on Presidential Primary Election Day.
Code B: Number of undeclared voters voting on Presidential Primary Election Day.
Code C: Number of undeclared voters voting on Presidential Primary Election day who returned to
undeclared status before leaving the polling place.
Spreadsheet: sally_beck__33712__Metrics 0623
Sheet: HPL&LRC

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | HPL and LRC
Results based on Activity through June 23, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 12
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 65 | 10 | 1 | 0 | 2 |  | 7 | 8 | 93 | 40 |  | 12
- Exits |  | 0 | 4 | 0 | 0 | 4 | 0 | 1 | 1 | 2 | 6 | 16 | 5
- Executions |  | 0 | 28 | 0 | 0 | 9 | 4 | 6 | 10 | 32 | 6 | 8 | 1
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 0 | 0 |  | 104 | 4.8 | 4.8 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 0 |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 6 | 0.984 |  |  | 137 | 6.884 |  | 32 | 3.251 |  |  |  |  | 0 | 0
Identified Margin
Budget |  | 0
$ Coverage
$ millions
Spreadsheet: 221311d1363464224-adding-two-seperate-drop-down-lists-still-crazy-pay-roll
Sheet: Sheet1

Driver |  | Date |  | Load # |  | Pick-Up |  | Drop-Off |  | [NAME] |  | Rate |  | [NAME]
Load Total
Com Check
Check Total
Fuel Cost
Tolls
[NAME].
Cash Back
Cash Kept |  |  |  |  |  |  |  |  |  |  |  | Total Pay
Spreadsheet: 156542d1337342869-excel-2007-triplicate-values-to-pick-up-book1
Sheet: Sheet1

SA1 | SA2 | SA3 | Result
1 | 2 | 12 | 1
2 | 10 | 2 | 2
3 | 8 | 4 | 4
4 | 10 | 11 | 11
5 | 4 | 1
6 | 1
7 | 11
8
9
10
11
Spreadsheet: 111817d1308097023-look-up-and-find-excel-find
Sheet: Sheet1

Orange | Pink
Apple | red
Pear
Orange | Pink
Orange | pink
Orange | pink
Apple | red
Apple | red
Pear
Orange
Apple
Orange
Apple
Orange
Pear
Orange
Apple
Pear
Apple
Apple
Orange
Orange
Pear
Apple
Apple
Orange
Orange
Apple
Apple
Orange
[NAME]
[NAME]
Apple
[NAME]
Apple
Orange
Pear
Apple
[NAME]
Spreadsheet: 6db470fa-2913-40da-b7cb-615b1b0d2d0c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4319 | 10334 | [NAME] | Smyers | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00
Spreadsheet: 792429d1660899358-multiple-key-word-match-book5
Sheet: Sheet1

MAKT_Material_Description | CODE |  | KEY1 | KEY2 | KEY3 | [NAME] | KEY5 | KEY6 | CODE
BOLT & NUT, HEX HEAD, [NAME], BLACK, | 3116162110 |  | BOLT | NUT | HEX | M16 | 65MM | BLACK | 3116162110
BOLT & NUT, HEX HEAD, [NAME], BLACK, | 3116162111 |  | BOLT | NUT | HEX | M16 | 65MM | GALV | 3116162120
BOLT & NUT, HEX HEAD, [NAME], BLACK, |  |  | BOLT | NUT | HEX | M16 | 65MM | ZNC | 3116162130
BOLT & NUT, HEX HEAD, M20 X 65MM, BLACK, |  |  | BOLT | NUT | HEX | M16 | 65MM | PVC | 3116162140
BOLT & NUT, HEX HEAD, [NAME], ZNC, | 3116162130 |  | BOLT | NUT | HEX | M16 | 75MM | BLACK | 3116162111
BOLT & NUT, HEX HEAD, [NAME], ZNC, | 3116162131 |  | BOLT | NUT | HEX | M16 | 75MM | GALV | 3116162121
BOLT & NUT, HEX HEAD, [NAME], |  |  | BOLT | NUT | HEX | M16 | 75MM | ZNC | 3116162131
BOLT & NUT, HEX HEAD, M20 X 65MM, ZNC, |  |  | BOLT | NUT | HEX | M16 | 75MM | PVC | 3116162141
BOLT & NUT, HEX HEAD, [NAME], PVC, | 3116162140
BOLT & NUT, HEX HEAD, [NAME], PVC, | 3116162141
BOLT & NUT, HEX HEAD, [NAME], PVC,
BOLT & NUT, HEX HEAD, M20 X 65MM, PVC,
Spreadsheet: sally_beck__35425__Unify Top 10
Sheet: Logistics

 | Priority | Change Description | Change Type | Requestor | Responsible Party | Delivery Date
 | 1 | SIRP00365/Fix - Event Status shows QR late but has been received on EPNG. | Fix | T. Jaquet | [NAME] | 2001-11-14 00:00:00
 | 2 | QR, why some schedulers not receiving | Fix | T. Jaquet | [NAME] | 2001-11-14 00:00:00
 | 3 | SIRP00067/Enhance - Automate Load of Scheduled Quantities | Enhancement | T. Jaquet | [NAME] | Estimating
 | 4 | EDI Rewrite | Operations | T. Jaquet | [NAME] | Estimating
 | 5 | Path Manager [NAME] | Operations | All Schedulers | M Pena, [NAME], [NAME], [NAME], [NAME] | Phase I testing, Phase II - late November
 | 6 | Drivetrain  / Sybase Replication replacement | Operations | All Unify Users | [NAME], [NAME] | 2001-11-20 00:00:00
 | 7 | Bridge Rewrite | Operations | All Schedulers | [NAME], [NAME] | 2002-02-01 00:00:00
 | 8 | [NAME] Changes | Enhancement | EES | [NAME] | 2001-11-14 00:00:00
 | 9 | EES Interfaces | Enhancement | EES | M Pena, [NAME], [NAME] | ???
 | 10
Spreadsheet: 80693ab3-bccf-40ed-b8ee-f9773b44359b
Sheet: Sheet1

RAMCO-GERSHENSON PROPERTIES TRUST | 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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
Please list in [NAME] (Skip Rows Between Entries) |  |  |  |  |  |  | ------------------------------------------------------------------------------------------$ Amounts per Each Share (to 6 places) of Stock Held on Record Date------------------------$ Amounts per Each Share (to 6 places) of Stock Held on Record Date--------------------------------------------------------------------------------------------
 |  |  |  |  |  |  |  | Year Taxable to Shareholders |  |  | Form 1099 Box 1 Breakdown |  |  | Box 1 Total | Box 2a | Box 2b | Box 2c | Box 2d | Box 2e |  | Box 3 | Box 6 | Box 8 | Box 9
 |  |  | Reclass | Estimated |  |  |  |  |  |  |  |  |  |  |  | Long Term Capital Gain Distributions
 |  |  | or | or |  |  | Total | [NAME]. [NAME]. (852(b)(7) |  |  |  |  | Foreign | Taxable | Total |  | Qualified | Unrecap |  | Long-Term |  | Foreign | Cash | Noncash | Exempt
Security |  | Ticker | Merger | Corrected | Record | Payable | Distribution | 2000 | 2002 | 2001 | Income | Short-term | Tax | Ordinary | Capital Gain | 28% Rate | 5 Year Gain | Sec. 1250 | Section 1202 | Rate Gain | Return of | Tax | Liquidation | Liquidation | Interest
Description | CUSIP | Symbol | (R or M) | (E or C) | Date | Date | Per Share | (Prior Year) | (Next Year) | (Current Year) | Dividends | Capital  Gain | Paid | Dividends | Distribution | Gain | (Included in 21) | Gain | Gain | (10 or 20%) | Capital | Paid | Distribution | Distribution | Dividends
(1) | (2) | (3) | (4) | (5) | (6) | (7) | (8)=(9)+(10)+(11) | (9) | (10) | (11)=(15)+(16)+(22)+(24) | (12) | (13) | (14) | (15)=(12)+(13) | (16)=(17)+(19)+(21) | (17) | (18) | (19) | (20) | (21) | (22) | (23) | (24) | (25) | (26)
Common Shares | 751452202 | RPT |  |  | 2001-03-31 00:00:00 | 2001-04-17 00:00:00 | 0.42 |  |  | 0.42 | 0.291 |  |  | 0.291 | 0.129 |  |  | 0.0051 |  | 0.1239
Common Shares | 751452202 | RPT |  |  | 2001-06-30 00:00:00 | 2001-07-17 00:00:00 | 0.42 |  |  | 0.42 | 0.291 |  |  | 0.291 | 0.129 |  |  | 0.0051 |  | 0.1239
Common Shares | 751452202 | RPT |  |  | 2001-09-30 00:00:00 | 2001-10-16 00:00:00 | 0.42 |  |  | 0.42 | 0.291 |  |  | 0.291 | 0.129 |  |  | 0.0051 |  | 0.1239
Common Shares | 751452202 | RPT |  |  | 2001-12-31 00:00:00 | 2002-01-15 00:00:00 | 0.42 |  |  | 0.42 | 0.291 |  |  | 0.291 | 0.129 |  |  | 0.0051 |  | 0.1239
Totals for 2001 |  |  |  |  |  |  | 1.68 |  |  | 1.68 | 1.164 |  |  | 1.164 | 0.516 |  |  | 0.0204 |  | 0.4956
Rec. 1/7/02
Spreadsheet: 53621d1253562095-multiple-criterias-in-spreadsheet-example-20of-20what-20is-20required-1-
Sheet: Sheet1

MASTER LIST |  |  |  |  |  |  |  |  | CLIENT LIST
ID | Acct # | Amount |  |  |  |  |  | ID | Acct # | Amount
11111 | AAA | 500 | OK | 1 | 1 | 1 |  | 11111 | AAA | 1000
11111 | AAA | 1000 | OK | 1 | 1 | 1 |  | 11111 | AAA | 500
22222 | BBB | 5000 | OK | 1 | 1 | 1 |  | 22222 | BBB | 5000
22222 | ZZZ | 2500 | OK | 1 | 1 | 1 |  | 22222 | ZZZ | 2500
33333 | CCC | 500 | OK | 1 | 1 | 1 |  | 33333 | CCC | 500
44444 | DDD | 2500 | OK | 1 | 2 | 1 |  | 44444 | DDD | 2500
44444 | DDD | 1500 | Check Amount | 1 | 2 | 0 |  | 44444 | EEE | 1500
55555 | GGG | 1500 | Check ID | 0 | 0 | 0 |  | 66666 | FFF | 200
55555 | GGG | 1500 | Check ID | 0 | 0 | 0 |  | 66666 | FFF | 200
Summary Totals |  | 16500 |  |  |  |  |  |  |  | 13900 |  | 2600
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] should explain what is the difference and why.
Basically, at the end of the day, I need a summary and details spreadsheet providing me with the following issues:  Master List Amt Total vs. Client List Amt Total -- The difference broken down in a detail spreadsheet(s) --- Could be something like [Perfect Match Spreadsheet] and [Amounts don't match] [ID and amounts match but Acct # is different][Remaining members from Master List] and [Remaining members from Client List]
As an added note, I've tried a VLOOKUP function, but doesn't seem to be the right way of doing this… see example of what happens on the next sheet.  Please help.  I've been working on this for 5 days now..
Spreadsheet: 106811d1303991934-generation-of-data-in-sheet-2-workassignments
Sheet: Sheet2

Task distrubution |  |  |  |  |  |  | How about a Pivot Table Answer Like This Below? You will need to Refresh this Pivot so it is correct
A | B | C | D | E | F |  | Count of Name | Name
1213 |  |  | 1216 | 1219 |  |  | Task No. | A | B | C | D | E | Grand Total
1214 |  |  | 1217 | 1220 |  |  | 1213 | 1 |  |  |  |  | 1
1215 |  |  | 1218 | 1221 |  |  | 1214 | 1 |  |  |  |  | 1
 |  |  |  |  |  |  | 1215 | 1 |  |  |  |  | 1
 |  |  |  |  |  |  | 1216 |  |  |  | 1 |  | 1
 |  |  |  |  |  |  | 1217 |  |  |  | 1 |  | 1
 |  |  |  |  |  |  | 1218 |  |  |  | 1 |  | 1
 |  |  |  |  |  |  | 1219 |  |  |  |  | 1 | 1
 |  |  |  |  |  |  | 1220 |  |  |  |  | 1 | 1
 |  |  |  |  |  |  | 1221 |  |  |  |  | 1 | 1
 |  |  |  |  |  |  | 2113 |  | 1 |  |  |  | 1
 |  |  |  |  |  |  | 3110 |  |  | 1 |  |  | 1
 |  |  |  |  |  |  | Grand Total | 3 | 1 | 1 | 3 | 3 | 11
Spreadsheet: 108126d1305214835-if-formula-help-auto-populate-a-bonus-based-on-return-on-sales-model-bonus-structure2
Sheet: Bonus '10 Q3 Metrics  (2)

Salaried Manager Bonus Structure
 | [NAME] | ROS $ | ROS %
Period 1 | 100000 | 10000 | 0.1
Period 2 | 100000 | 15000 | 0.15
Period 3 | 100000 | 20000 | 0.2
Total | 300000 | 45000 | 0.15
 |  | RM | GM
Avg. Weekly Guest Count Growth (Target -55)
Guest Count Growth |  | 0 | 0
Performance Earnings Growth
Performance Earning Groth |  | 0 | 0
Performance Earnings ROS%
0-5% | 15000 | 52.49999999999999 | 112.5
5.01-12% | 21000 | 315 | 997.5
12.01-100% | 9000 | 225 | 450
 | 45000
Simply Great Incentive
Steritech Score of 92% or better | Yes
Secret Shopper Score 100% | Yes
TUAU Top Box - 65% or better | Yes
Food Quality Score of 80% of Better | Yes
Overall Cleanliness Score of 90% of better | Yes
Speed of Service Score of 70% or Better | Yes
If 1=150, 2=300, 3=455, 4=605, 5=760, 6=915 | 6 | $380 | $915
Gross Total |  | 972.5 | 2475
Less Tax | 0.3726 | 362.3535 | 922.185
Net Total |  | 610.1465000000001 | 1552.815
Spreadsheet: 677241d1589259922-how-to-transpose-column-into-rows-pq-list-to-table-aligw
Sheet: makeover

Column1 |  |  | company | sector | industry | continent | country | marketvalue | sales | profits | assets | rank | forbeswebpage
company |  |  | ICBC | Financials | Major [NAME] | Asia | China | 215.6 | 148.7 | 42.7 | 3124.9 | 1 | http://www.forbes.com/companies/icbc/
sector |  |  | China Construction Bank | Financials | Regional Banks | Asia | China | 174.4 | 121.3 | 34.2 | 2449.5 | 2 | http://www.forbes.com/companies/china-construction-bank/
industry |  |  | Agricultural Bank of China | Financials | Regional Banks | Asia | China | 141.1 | 136.4 | 27 | 2405.4 | 3 | http://www.forbes.com/companies/agricultural-bank-of-china/
continent
country |  |  | company | sector | industry | continent | country | marketvalue | sales | profits | assets | rank | forbeswebpage
marketvalue |  |  | ICBC | Financials | Major [NAME] | Asia | China | 215.6 | 148.7 | 42.7 | 3124.9 | 1 | http://www.forbes.com/companies/icbc/
sales |  |  | China Construction Bank | Financials | Regional Banks | Asia | China | 174.4 | 121.3 | 34.2 | 2449.5 | 2 | http://www.forbes.com/companies/china-construction-bank/
profits |  |  | Agricultural Bank of China | Financials | Regional Banks | Asia | China | 141.1 | 136.4 | 27 | 2405.4 | 3 | http://www.forbes.com/companies/agricultural-bank-of-china/
assets
rank
forbeswebpage
ICBC
Financials
Major [NAME]
Asia
China
215.6
148.7
42.7
3124.9
1
http://www.forbes.com/companies/icbc/
China Construction Bank
Financials
Regional Banks
Asia
China
174.4
121.3
34.2
2449.5
2
http://www.forbes.com/companies/china-construction-bank/
Agricultural Bank of China
Financials
Regional Banks
Asia
China
141.1
136.4
27
2405.4
3
http://www.forbes.com/companies/agricultural-bank-of-china/
Spreadsheet: michelle_lokay__26631__imbalsumm0102
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1
2
3
4 | 1
5
6 | 15
7
8
9
10
11
12
13
14 | 6056 |  |  | 5000
15 | 243
16 | 15135 | 15000
17 | 186
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-01-31 00:00:00 |  |  |  | 1867
 | 2001-02-18 00:00:00
Spreadsheet: john_griffith__15867__11_12_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO Z1 | 61 | 380 | 480 | 38.5 | 48.7 | 1.67 | 2001-11-12 10:28:00
 | HO F2 | 62 | 775 | 875 | 45.3 | 51.2 | 1.88 | 2001-11-12 10:28:00
 | HO G2 | 62 | 1100 | 1200 | 48.9 | 53.4 | 1.99 | 2001-11-12 10:28:00
 | [NAME] | 61 | 1220 | 1320 | 47.4 | 51.3 | 1.89 | 2001-11-12 10:28:00
 | HO J2 | 60 | 1240 | 1340 | 43.7 | 47.2 | 1.71 | 2001-11-12 10:28:00
 | HO K2 | 59 | 1275 | 1400 | 41.3 | 45.3 | 1.61 | 2001-11-12 10:28:00
 | HO M2 | 59 | 1350 | 1475 | 40.1 | 43.8 | 1.56 | 2001-11-12 10:28:00
 | HO N2 | 59 | 1375 | 1500 | 38.3 | 41.8 | 1.49 | 2001-11-12 10:28:00
 | HO Q2 |  |  |  | 37.8 | 41.6 | 1.52 | 2001-11-09 14:51:00
 | HO U2 |  |  |  | 35.9 | 40.1 | 1.46 | 2001-11-09 14:51:00
 | [NAME] |  |  |  | 34.3 | 38.9 | 1.4 | 2001-11-08 14:49:00
 | HO X2 |  |  |  | 33.2 | 37.3 | 1.31 | 2001-11-07 14:56:00
 | [NAME] |  |  |  | 33.3 | 36.6 | 1.32 | 2001-11-07 14:56:00
 | HO F3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO H3
Spreadsheet: 211513d1359782443-sorting-based-on-matching-characteristics-binsort
Sheet: Sheet1

Object | [NAME] | Color | Shape | Combined | [NAME] | [NAME]
1 | 1 | blue | circle | bluecircle | 1 | 1
2 | 1 | red | square | redsquare | 1 | 1
3 | 1 | blue | circle | bluecircle | 1 | 1
4 | 2 | green | triangle | greentriangle | 2 | 1
5 | 2 | blue | circle | bluecircle | 1 | 1
6 | 2 | red | triangle | redtriangle | 2 | 1
7 | 3 | yellow | circle | yellowcircle | 3 | 1
8 | 3 | green | triangle | greentriangle | 2 | 1
9 | 3 | blue | circle | bluecircle | 1 | 1
Spreadsheet: 42cd56c3-b650-40c9-9738-1f254cea38c0
Sheet: Compendex(EI)

Compendex (Engineering Index)
2008-2009
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Total | 2008-2009 Price | Price per search
Compendex
Sessions | 111 | 76 | 88 | 497 | 97 | 113 | 72 | 49 | 107 | 143 | 49 | 69
Searches | 363 | 386 | 243 | 3830 | 349 | 302 | 300 | 193 | 365 | 424 | 233 | 282 |  | 16073
COUNTER-Compliant?: | No
Spreadsheet: 163073d1340184259-list-certain-row-only-when-matching-certain-condition-display-results-matching-certain-condition
Sheet: VLOOKUP RESULT

NAMES | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | 2012-05-31 00:00:00 | 2012-06-01 00:00:00 | 2012-06-02 00:00:00 | 2012-06-03 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 2012-06-09 00:00:00 | 2012-06-10 00:00:00 | 2012-06-11 00:00:00 | 2012-06-12 00:00:00 | 2012-06-13 00:00:00 | 2012-06-14 00:00:00 | 2012-06-15 00:00:00 | 2012-06-16 00:00:00 | 2012-06-17 00:00:00 | 2012-06-18 00:00:00 | 2012-06-19 00:00:00 | 2012-06-20 00:00:00 | 2012-06-21 00:00:00 | 2012-06-22 00:00:00 | 2012-06-23 00:00:00 | 2012-06-24 00:00:00 | 2012-06-25 00:00:00 | 2012-06-26 00:00:00 | 2012-06-27 00:00:00 | 2012-06-28 00:00:00 | 2012-06-29 00:00:00 | 2012-06-30 00:00:00
 | May | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun
Display list of the names which match only condition 4
Spreadsheet: 772321d1647199153-vlookup-on-a-different-worksheet-and-a-nested-if-function-cities-using-ssti
Sheet: Tier 1 Cities

 |  |  |  |  |  |  |  |  |  |  |  | $70,000 per square mile per year
Current SSTI customer |  | City | State | [NAME] | Total City Square Miles | Annual Contract Size | Sq Mile Expansion Potential |  | 15 |  | Potential Expansion
 | 1 | New York City | NY | 70
 |  | Los Angeles | CA
 |  | Chicago | IL | 117
Yes |  | Houston | TX | 10
 |  | Phoenix | AZ
 |  | Philadelphia | PA
 |  | San Antonio | TX
 |  | San Diego | CA |  | 3.6 | This was the customer that dropped in 4Q but they expect to come back
 |  | Dallas | TX
 |  | San Jose | CA
 |  | [NAME] | TX
 |  | Jacksonville | FL | 5
 |  | Fort Worth | TX
 |  | Columbus | OH | 12
 |  | Indianapolis | IA |  |  | In trial righ tnow for 5 square miles - 3 month trial |  |  |  |  |  |  |  | https://www.wrtv.com/news/public-safety/indianapolis-police-one-step-closer-to-getting-gunshot-detection-system
 |  | Charlotte | NC
 |  | San Francisco | CA | 13
 |  | Seattle | WA
 |  | Denver | CO | 14
 |  | Washington DC | DC | 18 | 68 | 500000
 |  | Nashville | TN
 |  | Oklahoma City | OK
 |  | El Paso | TX
 |  | Boston | MA | 6
 |  | Portland | OR
 |  |  | Total
 |  |  | [NAME] | Cities |  | Total Opportunity
 |  | Tier 1 New Opportunity | 9 |  | 70000
 |  | Tier 1 Expansion Opportunity
Spreadsheet: 864431d1711597865-array-formula-but-with-different-formula-inbetween-column-a-v-b
Sheet: Budget

Description |  | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00
Sales-Toy | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5400 | 5400 | 5400 | 5400
Sales-Food | 2000 | 2000 | 2000 | 2000 | 2000 | 2100 | 2100 | 2100 | 2100 | 2200 | 2200 | 2200
Sales-Furniture | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 4300 | 4300 | 4300 | 4300
Sales-Ad Hoc | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 18 - table 2

Ambev shareholding structure
 | ON | %Outs | PN | %Outs | Total | %Outs
Anheuser-Busch InBev | 1296225928 | 0.7404384971406227 | 632952390 | 0.4632870502058661 | 1929178318 | 0.6189532576515014
FAHZ | 299077066 | 0.1708407218947921 | 0 | 0 | 299077066 | 0.09595521707991386
Market | 155316312 | 0.08872078096458512 | 733268379 | 0.5367129497941339 | 888584691 | 0.2850915252685847
Outstanding | 1750619306 | 1 | 1366220769 | 1 | 3116840075 | 1
Treasury | 516025 |  | 354324 |  | 870349
TOTAL | 1751135331 |  | 1366575093 |  | 3117710424
Free float BM&FBovespa | 150849075 | 0.0861689771631023 | 434971331 | 0.3183755809234078 | 585820406 | 0.1879533090898159
Free float NYSE | 4467237 | 0.002551803801482811 | 298297048 | 0.2183373688707261 | 302764285 | 0.09713821617876882