tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 807085d1669733876-calculate-sum-each-month-based-on-two-variables-sales-team-goals-asm-commission-calculator-2023
Sheet: Team Andy

SALES TEAM | Team Andy |  |  |  |  |  |  |  |  |  |  |  |  | SALES TEAM | Team Andy
Row Labels | Sum of JAN | Sum of FEB | Sum of MAR | Sum of APR | Sum of MAY | Sum of JUN | Sum of JUL | Sum of AUG | Sum of SEP | Sum of OCT | Sum of NOV | Sum of DEC |  | SALES PERSON | Sum of JAN | Sum of FEB | Sum of MAR | Sum of APR | Sum of MAY | Sum of JUN | Sum of JUL | Sum of AUG | Sum of SEP | Sum of OCT | Sum of NOV | Sum of DEC
[NAME] | 1441 | 1150 | 1375 | 1496 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | [NAME] | 4 | 4 | 7 | 3
[NAME] | 880 | 1455 | 1150 | 760 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | [NAME] | 4 | 5 | 4 | 5
Mitch Tharp | 1340 | 1350 | 1920 | 1070 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Mitch Tharp | 4 | 7 | 7 | 2
[NAME] | 1810 | 2886 | 3345 | 2183 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | [NAME] | 8 | 10 | 14 | 8
Grand Total | 5471 | 6841 | 7790 | 5509 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Grand Total | 20 | 26 | 32 | 18
Spreadsheet: e9986045-9650-4fba-a5bd-dc580aee837c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FICP | Test | FICP | Immune Complex Panel | Immune Complex Panel | Radial Immunodiffusion (RID)/Enzyme Linked Immunosorbent Assay (ELISA)/Immunoassay and Precipitation | Serum Gel Tube: SGT |  |  | 1.5 | mL | Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.)  [NAME] down and pour into 4 plastic aliquot vials each containing 1.5 mL serum. Freeze immediately. Send specimen frozen, in plastic vials. | 2 aliquots of 1 mL each | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | PEG IgG   REFERENCE RANGE: < 3.5 mg/[NAME]     INTERPRETIVE CRITERIA:                                               < 3.5 mg/dL    Normal level                             > or = 3.5  mg/dL    Elevated level      The PEG method is both antigen and antibody non-specific and is based on the property of immune complexes to precipitate at low concentrations of PEG (2.5-3.5%). The PEG method will precipitate immune complexes of various sizes and composition as well as other macromolecules present in serum. Elevated serum IgG may cause a false positive increase in the PEG precipitate.   Test Performed by: Focus Diagnostics                                       5785 Corporate Avenue                                       Cypress, CA   90630-4750    [NAME], C1q   REFERENCE RANGE: < OR = 25.1 [NAME] by: Quest Diagnostics Nichols Institute                                       33608 [NAME]                                       San Juan Capistrano, CA 92690-6130                                       [NAME], M.D.       [NAME]REFERENCE RANGE:  0-8 mcg/mL  Negative   Test Performed by: Quest Diagnostics Nichols Institute                                       33608 [NAME]                                       San Juan Capistrano, CA 92690-6130                                       [NAME], M.D. | Varies by test | 1 - 8 days | 3 - 10 days | 3 | 86332 |  |  |  |  | Focus Diagnositics, Inc.
FICP | [NAME] | SERUM | Serum |  |  |  | Frozen
FICP | Result | Z1945 | PEG IgG | PEG IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FICP | Result | [NAME] | [NAME], C1q | [NAME], C1q | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FICP | Result | Z1948 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 219291d1362700666-expanding-sum-range-when-using-sumifs-function-for-sales-tracking-spreadsheet-sales-totals-sheet
Sheet: Reference Sheet

Products |  | January |  | February
 |  | revenue | sites | revenue | sites
a
b
c
d
e
f
g
h
i
j
Division
US
CNW
LatAm
Europe
Vintage
Asia
Spreadsheet: 98439d1297338971-find-in-cell-where-there-are-two-characters-before-and-after-space-stateabreviationscanada
Sheet: Canada State Abreviations

Province/Territory | Abbreviation | French name
Alberta | AB | Alberta
British Columbia | BC | [NAME]
Manitoba | MB | Manitoba
New Brunswick | NB | Nouveau-Brunswick
Newfoundland and Labrador | NL | Terre-Neuve-et-Labrador
Northwest Territories | NT | Territoires du Nord-Ouest
Nova Scotia | NS | Nouvelle-Écosse
Nunavut | NU | Nunavut
Ontario | ON | Ontario
Prince Edward Island | PE | Île-du-Prince-Édouard
Quebec | QC | Québec
Saskatchewan | SK | Saskatchewan
Yukon | YT | Yukon
Spreadsheet: 700433d1603194669-totals-from-two-different-tabs-into-a-third-tab-of-the-same-workbook-ledger-example-reva
Sheet: Checking Account

Due Date | Checking Account Activity | Debit/Credit | Banking Activity | Balance | Ref #
2020-01-01 00:00:00 | Mortgage | -1000
2020-01-01 00:00:00 | Mortgage | -1000 |  |  | 1
2020-01-01 00:00:00 | Electric | -200 |  |  | 2
2020-01-05 00:00:00 | Gas | -75 |  |  | 3
2020-01-15 00:00:00 | Phone | -50 |  |  | 4
2020-01-17 00:00:00 | [NAME] | -8 |  |  | 8
2020-01-20 00:00:00 | Cable | -100 |  |  | 5
2020-01-21 00:00:00 | Dining Out | -50 |  |  | 6
2020-02-01 00:00:00 | Mortgage | -1200 |  |  | 1
2020-02-01 00:00:00 | Electric | -180 |  |  | 2
2020-02-05 00:00:00 | Gas | -75 |  |  | 3
2020-02-15 00:00:00 | Phone | -50 |  |  | 4
2020-02-16 00:00:00 | [NAME] | -8 |  |  | 8
2020-02-20 00:00:00 | Cable | -100 |  |  | 5
2020-02-27 00:00:00 | Dining Out |  |  |  | 6
2020-03-01 00:00:00 | Mortgage | -600 |  |  | 1
2020-03-01 00:00:00 | Electric | -150 |  |  | 2
2020-03-05 00:00:00 | Gas | -72 |  |  | 3
2020-03-15 00:00:00 | Phone | -45 |  |  | 4
2020-03-16 00:00:00 | [NAME] | -9 |  |  | 8
2020-03-20 00:00:00 | Cable | -96 |  |  | 5
2020-03-27 00:00:00 | Dining Out | -45 |  |  | 6
2020-04-01 00:00:00 | Mortgage | -600 |  |  | 1
2020-04-01 00:00:00 | Electric | -150 |  |  | 2
2020-04-05 00:00:00 | Gas | -72 |  |  | 3
2020-04-15 00:00:00 | Phone | -45 |  |  | 4
2020-04-16 00:00:00 | [NAME] | -9 |  |  | 8
2020-04-20 00:00:00 | Cable | -96 |  |  | 5
2020-04-27 00:00:00 | Dining Out | -45 |  |  | 6
2020-05-01 00:00:00 | Mortgage | -600 |  |  | 1
2020-05-01 00:00:00 | Electric | -150 |  |  | 2
2020-05-05 00:00:00 | Gas | -72 |  |  | 3
2020-05-15 00:00:00 | Phone | -45 |  |  | 4
2020-05-16 00:00:00 | [NAME] | -9 |  |  | 8
2020-05-20 00:00:00 | Cable | -96 |  |  | 5
2020-05-27 00:00:00 | Dining Out | -45 |  |  | 6
Spreadsheet: 76546d1277110598-hlookup-and-vlookup-combined-match-excel-problem
Sheet: Sheet1

Carbon Type | Units | 2007 | 2008 | 2009
Diesel | litres | 2.63914 | 2.63914 | 2.63914
Electricity | kWh | 0.54055 | 0.54055 | 0.54055
Gas | litres | 2.7619 | 2.7619 | 2.7619
LPG | litres | 1.4951 | 1.4951 | 1.4951
Natural Gas | kWh | 0.18358 | 0.18358 | 0.18358
 |  | Used
Site | Source | 2007 | 2008 | 2009
A | Elect | 50 | 554 | 55
B | Elect | 4454 | 454 | 545
C | Gas | 4545 | 711 | 51
D | LPG | 44 | 44 | 55
CO2
Site | Source | 2007 | 2008 | 2009
A | Elect
B | Elect
C | Gas
D | LPG
Lookup "Type" and then a year and show a value and carry out a multiplicaiton
Lookup Electricity then the specific year e.g. 2008 and show the value 0.54055
.=C11*INDEX(carbonfactors,MATCH(B11,carbonfactors,0),MATCH(C1,carbonfactors,0))
Alternative
Not sure if [NAME] with an [NAME] would also fix this.
Spreadsheet: 4b21f7e0-e782-435d-aab5-7e4b54907df9
Sheet: Oakland

REGIONAL DIRECTORY 2014/2015
OAKLAND UNIFIED SCHOOL DISTRICT
[NAME], Superintendent | [NAME], MEP Coordinator | [NAME], Fiscal Officer
1025 2nd Avenue Room 301 | 2111 International Blvd | 1025 2nd Avenue Room 206
Oakland, CA, 94606 | Oakland, CA, 94606 | Oakland, CA, 94606
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[NAME] | [EMAIL] | [EMAIL]
[NAME], Claim Officer | [NAME], Controller | [NAME], Administrator Assistant II
1025 Second Avenue, Rm.308 | 1025 Second Avenue, Rm.308 | 2111 International Blvd
Oakland, CA, 94606 | Oakland, CA, 94606 | Oakland, CA, 94606
O: [PHONE] | O: [PHONE] | O:  [PHONE]
C: N/A | C: N/A | C: [PHONE]
F: 510- 879 8836 | F: 510- 879 8836 | F: [PHONE]
[NAME] | [EMAIL] | [EMAIL]
[NAME], Regional Community Liaison
O: [PHONE]
C: [PHONE]
[EMAIL]
Spreadsheet: 692577d1598440096-look-up-between-2-table-for-match-data-with-no-order-test
Sheet: table2

CODE | text
[PHONE]/000 | Sans gluten
[PHONE]/000 | Sans lactose
[PHONE]/000 | Convient aux végétaliens
[PHONE]/000 | 100% végétal
[PHONE]/000 | Sans conservateur
[PHONE]/000 | Sans arômes artificiels
[PHONE]/000 | [NAME] pression d'un mélange de graines de tournesol, [NAME], colza
[PHONE]/000 | Une texture onctueuse unique, sans huile de palme, grâce aux huiles de karité et de coco
[PHONE]/000 | Sans lait et sans lactose
[PHONE]/000 | Sans huile de palme
[PHONE]/000 | Naturellement riche en Oméga 3
[PHONE]/000 | A conserver au réfrigérateur (0-8°C). A consommer de préférence avant le : voir sur le couvercle
Spreadsheet: 100752d1299007315-using-a-dv-list-to-populate-a-list-list-polulation
Sheet: Group

Account | Type | Rep | <---  Here is where you can select the rep to have his list pulled
[NAME] | agency | [NAME]
Fish Shop | direct | [NAME]
Builder Game | direct | Mark
Lazlo's | direct | Mark
[NAME] | agency | Mark
[NAME] | agency | [NAME]
Lakeside | agency | [NAME]
Area 23 | agency | [NAME]
Timothy's | agency | [NAME]
Downtown Help | agency | Mark
Note: This is the complete list of accounts and data associated
Spreadsheet: 672279d1586814092-indexmatch-obtain-result-from-several-cells-test_model_v1
Sheet: Tabela

 |  |  |  | Set | [NAME] | Ano | [NAME] | Valor0 | Valor1 | Valor2 | Valor3 | Valor4 | Valor5 | Valor6 | Valor7 | Valor8 | Valor9 | Valor10
 |  |  |  | 1º | A | 2000 | Za | 1.1
 |  |  |  | 2º | B | 2001 | [NAME]
 |  |  |  | 3º | C | 2002 | Zc
 |  |  |  | 1º | D | 2003 | [NAME]
 |  |  |  | 1º | A | 2003 | Tb
 |  |  |  | 2º | B | 2004 | nm
 |  |  |  |  |  |  | Set | 1º
 |  |  |  |  |  |  | [NAME] | A
 |  |  |  |  |  |  | Ano | 2003
 |  |  |  |  |  |  | [NAME] | Tb
 |  |  |  |  |  |  | Valor | Valor8
 |  |  |  |  |  |  | Result
Spreadsheet: vkaminski__40651__SSIV NO
Sheet: Sheet1

Batuuka | [NAME]
Bernstein | Eitan
Buggs | Lauren
Carchman | [NAME]
Cepujnoska | Biljana
Daily | [NAME]
[NAME] | Rohanna
Jain | Aarti
Koh | Sung-Mee
[NAME] | Ward
Madrid | [NAME]
Rivaille | Maureen
Ruiz | Maria
Segura | Juan
Shipler | [NAME]
Stedman | Todd
Trainor | [NAME]
[NAME] | Cecilia
Spreadsheet: 174478d1345067612-excel-math-calculations-calculation-example
Sheet: Sheet1

 | TOTALS | A1 | A2 | A4 | A5 | A6 | A9-1(U) | A9-2 | B1 | B1(U) | B2 | B5-8 | B6 | B7 | B7(U) | B8 | C1 | C1x | C1-H | C1(U) | C1-H(U) | C1-AA | C1-AA2 | C2 | C2-H | C2(U) | C2-H(U) | C2-AA | C2-AA2 | C5-1 | C5-8 | C5-8x | C5-8p | C5-8H | C5-8.2 | C5-8.2x | C5-8.2H | C6 | C6x | C6(U) | C6-1 | C6-1x | C7 | C7x | C7-H | C7(U)-H | C7(U)-L | C8 | C8x | C8-HS | C8-H | C8(U) | E1 | E1-H | E1-3 | E2 | E2-2 | E2-3 | E3 | G1.2 | G1.7 | G2.1 | G2.1b | G3.1 | G3.1b | G3.2 | G3.2b | J7 | J8 | M26-5 | M26-13 | M3-4.1 | M3-4.2 | M3-4.3 | S1 | S2 | S3 | [NAME] | S5 | S6 | UA1 | UA3 | UB1 | UC1 | UM5 | Y3.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Insulator - C-Neck Pin Type |  | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 2 | 4 | 2 | 2 |  |  | 4 | 3 | 3 |  |  |  | 3 | 3 | 5 |  |  |  | 5 |  |  | 2 | 2 | 2 |  | 4 | 4 |  | 4 | 4 | 4 | 1 | 1 |  |  |  |  |  | 5 | 5 |  |  | 6
Insulator - F-Neck Pin Type |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 3 |  |  |  | 5 | 6 | 6 |  | 6 |  |  |  |  | 2 |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Insulator [NAME] |  | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Insulator [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Insulator - Hetherlite |  |  | 2 | 1 | 1 | 2 |  |  |  |  |  | 2 | 3 | 2 | 2 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 3 |  |  | 6 | 6 |  | 5 | 5 | 5 | 4 | 4 | 3 | 3 |  |  | 3 | 6 | 6 |  |  | 6
Insulator - Porclain |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 |  |  | 12 |  |  |  |  |  |  |  | 6 | 6 |  |  |  | 12 | 12
Spreadsheet: 298717d1392888010-will-a-count-if-formula-work-to-obtain-the-required-data-copy-of-programme-application-tracker-v0-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Migrations Planned
 |  |  |  |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 |  |  |  |  |  |  |  |  |  |  | EU
 |  |  |  |  |  |  |  |  |  |  | AMS
 |  |  |  |  |  |  |  |  |  |  | AAR
 |  |  |  |  |  |  |  |  |  |  |  | Migrations Actual
 |  |  |  |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 |  |  |  |  |  |  |  |  |  |  | EU
 |  |  |  |  |  |  |  |  |  |  | AMS
 |  |  |  |  |  |  |  |  |  |  | AAR
 |  |  |  |  |  |  |  |  |  |  |  | Decomms Planned
 |  |  |  |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 |  |  |  |  |  |  |  |  |  |  | EU
 |  |  |  |  |  |  |  |  |  |  | AMS
 |  |  |  |  |  |  |  |  |  |  | AAR
 |  |  |  |  |  |  |  |  |  |  |  | Decomms Actual
 |  |  |  |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 |  |  |  |  |  |  |  |  |  |  | EU
 |  |  |  |  |  |  |  |  |  |  | AMS
 |  |  |  |  |  |  |  |  |  |  | AAR
Spreadsheet: 166148d1341487817-date-range-filter-example-cashflow
Sheet: Sheet1

 | TRING PROJECT INCOME
 |  |  | 2012
 |  |  | Income Including VAT Summary |  |  |  |  |  |  |  |  | 2013
 |  |  | August | September | October | November |  |  |  |  | December | Jan
 |  |  |  | check
 |  |  |  | check
 |  |  | Item cost | Quantity | Price | [NAME] | Inc VAT | Date Cleared | Month | Year
 |  |  |  |  | 2000 |  |  | 2011-08-25 00:00:00
 | Stage 1 | Stage 1 |  |  | 1500 |  |  | 2011-09-25 00:00:00
 |  |  |  |  | 5000 |  |  | 2011-10-25 00:00:00
 |  |  |  |  | 6000 |  |  | 2012-12-25 00:00:00
Spreadsheet: 718627d1613240189-revenue-based-tiered-commission-formula-revenue-based-tiered-commission-
Sheet: Revenue Report Feb 12th

Day/ Date | Friday, February 12th 2021
 |  | Sales | Commission
 |  | 1000
 |  | 2000
 |  | 3000
 |  | 4000
 |  | 5000
 |  | 6000
 |  | 7000
 | Table
 | From (Amount) | Percentage | Differential
 | 0 | 0 | 0
 | 2700 | 0.15 | 0.15
 | 6000 | 0.2 | 0.05
Spreadsheet: 7c9e970a-7195-436c-a4a7-e2ebd599e36a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
35886372 | 2013-05-11 04:26:50 | AXIS | 0 | 4 | 6 | 603439 | MickeyScott01 | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
35948997 | 2013-05-15 05:13:02 | ALLIES | 1 | 6 | 5 | 1240009 | Yossarian44 | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
35949235 | 2013-05-15 05:45:44 | AXIS | 0 | 3 | 6 | 1240009 | Yossarian44 | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
35949667 | 2013-05-15 06:21:14 | ALLIES | 1 | 6 | 0 | 26778 | gheintze | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
35949837 | 2013-05-15 06:45:09 | AXIS | 1 | 6 | 5 | 26778 | gheintze | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
36027534 | 2013-05-20 15:21:12 | AXIS | 0 | 5 | 6 | 967588 | Cedric59 | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
36029484 | 2013-05-20 17:29:16 | AXIS | 0 | 4 | 6 | 828272 | hester24 | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
36029747 | 2013-05-20 17:56:35 | AXIS | 0 | 5 | 6 | 188654 | smith318 | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
36042262 | 2013-05-21 14:00:04 | AXIS | 0 | 4 | 6 | 569334 | Breakmate | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
36056900 | 2013-05-22 13:33:37 | AXIS | 1 | 6 | 3 | 1252868 | eljavi | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
36057071 | 2013-05-22 13:51:01 | ALLIES | 1 | 6 | 3 | 1252868 | eljavi | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
36057295 | 2013-05-22 14:10:30 | ALLIES | 0 | 2 | 6 | 678541 | Sauron93 | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
36057443 | 2013-05-22 14:26:14 | ALLIES | 1 | 6 | 4 | 828272 | hester24 | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
36057583 | 2013-05-22 14:37:28 | AXIS | 1 | 4 | 1 | 1327627 | player1327627 | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
36057677 | 2013-05-22 14:57:25 | ALLIES | 0 | 2 | 4 | 1327627 | player1327627 | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
36057872 | 2013-05-22 15:28:29 | ALLIES | 1 | 5 | 2 | 1327595 | player1327595 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
Spreadsheet: 8fe68711-8cb6-4153-afee-96ade869a022
Sheet: Sheet1

Tax Commissioner - DEM (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 5/25/2013 12:06:01 PM
Precincts Reporting: 565/565 - Total Ballots Cast: 111325
2006 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | TOTALS
Precinct 0701 | 49 | 49
Precinct 0702 | 39 | 39
Precinct 0703 | 44 | 44
Precinct 0704 | 84 | 84
Precinct 0705 | 14 | 14
Precinct 0706 | 97 | 97
Precinct 0707 | 49 | 49
Precinct 0708 | 66 | 66
TOTAL | 442 | 442
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 882008d1730258615-using-a-word-in-a-formula-where-the-word-has-a-set-numerical-value-test-kits
Sheet: Tables

Crestron UC | Cost | Crestron Transmitters | Cost2 | Crestron Recievers | Cost3 | Displays | Cost4 | Mounts | Cost5 | SpeakerBar Mount | Cost6 | 2x1 | Cost7
UC_B30_T | 50 | HD_TXC_4KZ_101_1G_W | 10 | HD_RXC_4KZ_101 | 10 | 4P_B55EJ2U | 10 | ST650 | 10 | MD5428 | 10 | HD-MD4X1-4KZ-E | 10
UC_BX30_T | 60 | HD_TXC_4KZ_101 | 20 | HD_RX_4K_210_C_E | 20 | 4P_B65EJ2U | 20 | ST660 | 20 | X | 0 | X | 0
UC_C100_T | 70 | HD_TX_301_C_E | 30 |  |  | 4P_B75EJ2U | 30 | ST670 | 30
UC_CX100_T | 80 | HD_TX_4KZ_401 | 40 |  |  | 4P_B86EJ2U | 40 | SA771PU | 40
UC_M50_T | 90
X | 0
Spreadsheet: 169170d1342715499-combining-if-statement-vlookup-sample-book
Sheet: All

Client Name | Client Since | Month | Industry | Budget | Traffic | Traffic Status | Leads | [NAME] | Coversion Rate | Conversions Status | New Visits | [NAME] | Page / Visits | Time on Site
Company A |  | 2012-06-01 00:00:00 | Dental | 1199 | 190 |  | 8 |  |  |  | 0.8622 | 0.6531 | 2.35 | 1 mins 59 secs
Company B |  | 2012-06-01 00:00:00 | Dental | 1199 | 381 |  | 32 |  |  |  | 0.8338 | 0.5422 | 2.76 | 1 mins 25 secs
Company C |  | 2012-06-01 00:00:00 | Dental | 2000 | 324 |  | 39 |  |  |  | 0.7284 | 0.5247 | 2.91 | 2 mins 30 secs
Company D |  | 2012-06-01 00:00:00 | Dental | 1199 | 326 |  | 37 |  |  |  | 0.8374 | 0.6074 | 2.29 | 1 mins 26 secs
Company E |  | 2012-07-01 00:00:00 | Dental | 1199 | 424 |  | 36 |  |  |  | 0.7215 | 0.3991 | 2.69 | 2 mins 06 secs
Company F |  | 2012-07-01 00:00:00 | Dental | 699 | 1246 |  | 24 |  |  |  | 0.7191 | 0.5907 | 2.27 | 2 mins 27 secs
Company G |  | 2012-07-01 00:00:00 | Dental | 1199 | 306 |  | 12 |  |  |  | 0.7241 | 0.4483 | 4.02 | 5 mins 09 secs
Company H |  | 2012-07-01 00:00:00 | Dental | 2500 | 476 |  | 104 |  |  |  | 0.771 | 0.4811 | 3.11 | 2 mins 51 secs
Company I |  | 2012-07-01 00:00:00 | Dental | 1199 | 432 |  | 24 |  |  |  | 0.6366 | 0.0069 | 4.39 | 1 mins 59 secs
Spreadsheet: ea521681-6e50-4962-9bb9-c17f5deb9281
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | STATE OF MAINE | Unnamed: 5 | Unnamed: 6
 |  |  |  |  | 2011 CDBG Public Facilities Applications
First Name | Last Name | Title | Address | Applicant | Project | CDBG Request
[NAME] | Giroux | Community Development Director | 55 Front Street | Allagash | [NAME] | 184285
 |  |  |  | Bath | Maine Maritrime Museum | 54000
 |  |  |  | Bridgewater | [NAME] | 350000
 |  |  |  | Cherryfield | [NAME] | 51500
 |  |  |  | [NAME] | [NAME] | 127500
 |  |  |  | Eastport | Fire Station | 350000
 |  |  |  | Farmington | [NAME] | 40000
 |  |  |  | Fort Fairfield | Health Center | 350000
 |  |  |  | Kittery | Head Start | 90000
 |  |  |  | [NAME] | Health Center | 350000
 |  |  |  | Presque Isle | Head Start | 350000
 |  |  |  | Prospect | Marsh School | 40000
 |  |  |  | Readfield | Union Meeting House | 150000
 |  |  |  | [NAME] | Health Center | 350000
Kristan | Porter | Chair, Board of Selectmen | PO Box 236 | TOTAL |  | 2837285
[NAME] | Brawn | Town Manager | 23 Main Street
[NAME] | [NAME] | Town Manager | 416 West Main Street
First Name | Last Name | Title | Address
[NAME] | Post | Acting Town Manager | PO Box 280
[NAME] | Bond | [NAME] and [NAME] | PO Box 77
[NAME] | Tibbetts | Town Manager | 1 Summer Street
[NAME] | Lizotte | County Commissioner | 159 East Main Street
[NAME] | Fortier | Town Manager | PO Box 159
[NAME] | Lynch | Community Development Director | 270 Pleasant Street
[NAME] | Peabody, Jr. | Town Manager | PO Box 10
[NAME] | Peabody, Jr. | Town Manager | PO Box 10
[NAME] | Bernier | Community Development Director | PO Box 110
First Name | Last Name | Title | Address
[NAME] | Town Manager | Director of Economic Affairs | 917 Main Street
Valmore | Blastow, Jr. | Town Manager | PO Box 299
[NAME] | Shea | County Commissioner | 50 State Street, Suite 7
[NAME] | Heavener | Town Manager | 114 Benton Avenue
Spreadsheet: 764451d1642751365-help-for-formula-for-extracting-different-words-and-sorting-them-among-spreadsheet-uniqe-list-in-assending-order-ans-2
Sheet: Sortedata

 | aaa | qqq | [NAME]
 | [NAME] | ww | aaa
 | dd | aaa | qqq
 | ee | dd | ee
 | aaa | ee | dd
 | ss | ss | zzz
 | ee | dd | ee
 | aaa | ee | dd
 | ss | ss | zzz
 | Unsorted data |  |  | Sorted as per count
 | LIST | COUNT |  | LIST | COUNT
Spreadsheet: 202704d1356699601-assigning-a-medical-record-number-to-a-patient-name-medication-utilization-v2-fake-data
Sheet: Sheet1

Request Date | Patient | MRN | Location | Qty | Medication
2012-11-13 00:00:00 | Hill,D | 5137345 | 7P | 1 | Alteplase (TPA) 1mg=2ml
 | [NAME], M | 7711974 | 4E | 1 | Alteplase (TPA) 1mg=2ml
 | [NAME], I | 1342504 | 7P | 2 | Alteplase (TPA) 1mg=2ml
 | [NAME], I | 1342504 | 7P | 1 | Alteplase (TPA) 1mg=2ml
2013-11-14 00:00:00 | Care, A | 5063464 | 2E | 1 | Alteplase (TPA) 1mg=2ml
 | [NAME], I | 8484848 | 5M | 1 | Alteplase (TPA) 1mg=2ml
 | Lance, K | 1458447 | 2E | 1 | Alteplase (TPA) 1mg=2ml
 | Lawyer, A | 4173477 | 7P | 1 | Alteplase (TPA) 1mg=2ml
 | [NAME], C | 2214717 | 4E | 2 | Alteplase (TPA) 1mg=2ml
 | [NAME], C | 2214717 | 4E | 2 | Alteplase (TPA) 1mg=2ml
 | Rogers, J | 5620333 | OP | 2 | Alteplase (TPA) 1mg=2ml
 | Wrightington, E | 3865816 | 5E | 4 | Alteplase TPA(Cathflo) 2mg=2ml
2012-11-15 00:00:00 | Hicks, C | 6483839 | 3E | 3 | Alteplase (TPA) 1mg=2ml
 | Seeley, A | 4860238 | 4N | 1 | Alteplase (TPA) 1mg=2ml
2012-11-16 00:00:00 | Freihofer, N | 4959602 | HEM | 4 | Alteplase TPA(Cathflo) 2mg=2ml
2012-11-17 00:00:00 | Lanier, J | 9572202 | 4C | 4 | Alteplase TPA(Cathflo) 2mg=2ml
 | Lanier, J | 9572202 | 4C | 4 | Alteplase TPA(Cathflo) 2mg=2ml
 | McMullen, B | 4659305 | 4E | 1 | Alteplase (TPA) 1mg=2ml
2012-11-18 00:00:00 | Henderson, B | 5984050 | 3N | 2 | Alteplase (TPA) 1mg=2ml