tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707267d1607140701-unique-list-from-row-name-based-on-criteria-from-column-data-header-and-column-contents-weekend-schedule
Sheet: Sheet1

 | 2020-12-06 00:00:00
[NAME] | X |  | X | X | X | X | X |  |  | X
[NAME] | X |  |  | X |  |  | X |  |  | X |  |  | X
[NAME] |  | X |  | X |  |  |  |  | X | X |  | X
[NAME] |  | X | X |  | X | X |  | X |  | X
[NAME] |  | X | X |  |  | X | X |  |  |  |  |  | X
[NAME] | X |  |  |  | X |  |  |  | X |  | X
[NAME] |  | X |  |  |  | X |  | X |  | X
[NAME] |  | X | X |  |  | X | X |  |  | X |  | X | X
[NAME] | X |  |  | X | X |  |  |  |  |  |  | X
[NAME] |  | X |  |  | X |  | X | X |  |  | X | X | X
[NAME] | X |  | X |  |  | X | X |  |  |  | X
[NAME] |  | X |  |  |  |  |  |  |  |  |  |  | X
[NAME] |  | X | X |  |  | X | X |  |  |  | X | X
[NAME] | X
 | 2020-12-06 00:00:00
Spreadsheet: ac0da297-ea4b-410b-8972-8b634ef39b9c
Sheet: Sheet1

CDBG Missing Data | 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
EUGENE OR
Data as of 06/01/2009
Act ID | Status | [NAME] | Matrix CD | Prop Accomp MA04 | Actual [NAME] | Total [NAME] CDBG08 | Create FT Jobs CDBG11 | Create FT Jobs LM CDBG11 | Create PT Hours CDBG11 | Create PT Hours LM CDBG11 | Retain FT Jobs CDBG11 | Retain FT Jobs LM CDBG11 | Retain PT Hours CDBG11 | Retain PT Hours LM CDBG11 | Assist Type CDBG11 | [NAME] CDBG13 | [NAME] CDBG13 | Num Very Low Incm CDBG13 | Units Start CDBG14 | Units [NAME] CDBG14 | Units Occ LM Start CDBG14 | Units Exp CDBG14 | Units [NAME] CDBG14 | Units Occ LM Exp CDBG14 | LMA % CDBG07
156 | 3 | LMH | 01 | 0 | 27
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 135SP

135SP
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-09-24 00:00:00 |  |  | CJY | N/A | N/A | N/A | N/A |  | 2010-11-09 00:00:00 | 2010-11-09 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00 |  | THIS ACCOUNT HAS CAT B AUTHORIZATIONS; THERE ARE NO ON HAND ASSETS, ASSETS ARE MAINTAINED IN BASE STOCK. NO AM427G INVENTORY COUNT SHEET IS REQUIRED. THE SIGNED RESULTS LETTER FULFILLS THE REQUIREMENT FOR A QUARTERLY INVENTORY.
GENERAL ACCOUNT INFORMATION / NOTES
AF RESERVE SF MOBILITY ACCOUNT (CAT B)...NO ASSETS ON HAND BUT STILL HAS CAT B AUTHORIZATIONS. A QUARTERLY ACCOUNT REVIEW MFR PACKAGE IS EMAILED TO CUSTODIAN EVERY QUARTER.
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 |  | -882
500046 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 |  | -10272
500528
500529
500619
INDEX
2002-02-28 00:00:00 |  |  | -578777.86
2002-03-06 00:00:00
CBS Volume
 |  |  | -56360
Spreadsheet: 845580d1697033675-problem-incrementing-or-decrementing-a-cells-value-based-on-a-filters-value-golfscoresmultiplayerliveck76bak-aligw
Sheet: AdminLists

 | Teams |  | Rank |  | Increment
 | Team1 |  | 1 |  | 0.001
 | Team2 |  | 2 |  | 0.002
 | Team3 |  | 3 |  | 0.003
 | Team4 |  | 4 |  | 0.004
 | Team5 |  | 5 |  | 0.005
 | Team6 |  | 6 |  | 0.006
 | Team7 |  | 7 |  | 0.007
Spreadsheet: 113793d1309646955-i-could-use-nested-if-statements-but-vlookupvalidation
Sheet: Sheet2

Property | Interest
Prop 1 | 2.111121883200028
Prop 2 | 2.775739733803401
Prop 3 | 2.639312478165305
Prop 4 | 2.970311274742321
Prop 5 | 2.670516020992621
Prop 6 | 1.7089259327987
Prop 7 | 1.518750565900707
Prop 8 | 1.735428387648065
Prop 9 | 1.889622364080798
Prop 10 | 2.104147301489595
Prop 11 | 1.25630128633084
Prop 12 | 2.150248957015088
Prop 13 | 2.445234620722027
Prop 14 | 2.199974278486629
Prop 15 | 1.308485153096115
Prop 16 | 2.694556110062238
Prop 17 | 1.14770925969395
Prop 18 | 2.91033021350991
Prop 19 | 1.942507552783237
Prop 20 | 2.103442537996433
Prop 21 | 1.417015456322628
Prop 22 | 1.324291256346062
Prop 23 | 2.857698363607872
Prop 24 | 1.698694223029586
Prop 25 | 1.320677156933449
Prop 26 | 2.67244558347509
Spreadsheet: 777916d1650663557-conditional-formatting-when-all-rows-of-a-type-meet-a-condition-cond-frmt-etaf
Sheet: Sheet1

123 | arrived
123 | arrived
123 | arrived
123 | arrived
123 | arrived
123 | arrived
1234 | arrived
1234 | ordered
1234 | arrived
1234 | ordered
12345 | arrived
12345 | arrived
12345 | arrived
Spreadsheet: andy_zipper__187__DYNEGY-ICE VOL May18
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  May-18-01 thru May-18-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: cb931009-b577-4819-b79e-8019135ee5e4
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
HODGE | Test | HODGE | Carbapenemase Detection, Modified Hodge Test | Carbapenamase-Modified Hodge Test | Modified Hodge Test |  |  |  |  |  | Container/Tube: Slant Specimen Volume: Isolate Collection Instructions:  1. [NAME] species in pure culture, actively growing. 2. Place specimen in a large infectious container (Supply T146) and label as an etiologic agent. Additional Information: 1. Specimen source and organism identification are required. 2. See Infectious Specimen Shipping Guidelines in Special Instructions for shipping information. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Agar plate | Negative | Monday through Sunday | 2 days |  | 1 | 87185 |  |  |  |  | Rochester
HODGE | [NAME] | VARIES | Varies |  |  |  | Ambient
HODGE | Order Question | Q00M0031 | [NAME]) and Organism Identification (Required) |  | Plain Text
HODGE | Result | HODGE | Carbapenamase-Modified Hodge Test | Carbapenamase-Modified Hodge Test | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 811979d1672904583-sum-range-with-conditions-horizontal-and-vertical-sum-range-with-multiple-criteria-horizontal-and-vert-v2
Sheet: Sheet1

Account | LA | SF | Nash | MIA | NYC | SLC | DAL | HOU | POR | Total
Cost | 15 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 0
Book | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 0
Value | -1000000 | -2000000 | 0 | 0 | -500000 | -3500000 | 65987552 | 0 | 0 | 0
Amount | 5569 | 5569 | 5569 | 5569 | 5569 | 5569 | 5569 | 5569 | 5569 | 0
Book1 | 56987 | 56987 | 56987 | 56987 | 56987 | 56987 | 56987 | 56987 | 56987 | 0
Book2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Book3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Book4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: b5257669-ae72-4854-b756-29e6ddc61c7c
Sheet: Keeper Status

Kept in 2010 and 2011, so can't be kept in 2012
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Félix Hernández - Sea - SP
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] - 1B
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Kept for 1st time in 2011
 | [NAME]
 | [NAME] - 1B
 | [NAME]
 | [NAME]
 | Alexei Ramírez - CWS - SS
 | [NAME]
 | [NAME]
 | [NAME] 1B,OF
 | [NAME] - OF
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Chase Utley - Phi - 2B
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] - OF
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] 1B
 | [NAME]
 | [NAME] - OF
 | [NAME],RP
 | [NAME]
 | [NAME],OF
 | [NAME]
 | [NAME]
 | Martín Prado - Atl - 2B,3B
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] 1B
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Shin-Soo Choo - Cle - OF
 | [NAME] ChC - SS
 | [NAME]
 | Trevor Cahill - Oak - SP
 | [NAME] - OF
Spreadsheet: 266738d1379707223-file-excel-format-for-mann-kendall-test-with-tied-group-nuovo-foglio-di-lavoro-di-microsoft-office-excel
Sheet: Foglio1

[NAME]: | NEW YORK  Frequenza deli estremi (N95 Index) 1971-2012
 | y-axis title:
 | 1971 | 19
 |  | 18 |  |  | n=number of time periods
 |  | 19 |  | n= | 42
 |  | 18
 |  | 14
 |  | 17
 |  | 19
 |  | 17
 |  | 18
 |  | 18
 |  | 19
 |  | 19
 |  | 19
 |  | 18
 |  | 19
 |  | 18
 |  | 19
 |  | 16
 |  | 18
 |  | 19 |  |  |  |  | Subtract each earlier year from each later year
 |  | 18 |  |  |  | year J:
 |  | 19 |  |  | year K: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # + | # -
 |  | 19
 |  | 18
 |  | 19
 |  | 19
 |  | 19
 |  | 19
 |  | 19
 |  | 19
 |  | 18
 |  | 19
 |  | 17
 |  | 19
 |  | 19
 |  | 18
 |  | 16
 |  | 19
 |  | 19
 |  | 19
 |  | 19
 |  | 19
 |  |  |  |  |  | # ties (diff=0):
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S=
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S=
If [NAME], then use the variance calculation to estimate probability.
If [NAME], then use the table, below. Note: a significant p value is not possible with fewer than 4 time periods.
n>=5 is required to reach p<.05.
# Positive diffs
# Negative diffs
S
Evaluation (Normal Approximation, N>=10)
Variance(S) |  | =(n(n-1))(2n+5)/72)  This formula may be conservative in the presence of tied values.
ZS
Zcrit,.05 | 1.96 | (two-tailed. For one-tailed test use 1.65)
Interpretation
Spreadsheet: 1bcf805d-f2ed-4499-8ff5-c78feb0b27a2
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
BBLD | Test | BBLD | Bacterial Culture, Blood | Bacterial Culture, Blood | Automated or Manual Detection of Positive Blood Cultures with Conventional Identification Methods |  |  |  |  |  | This test is available by special request only - pre-approval by testing lab is required.  Incubate blood bottles at 35 degrees C for 24 hours before sending.  Include a completed microbiology request form. | 10-20 mL for adults; 1.0-3.0 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | No growth Identification of all organisms | Daily; Continuously | 5 days | 8 days | 1 | 87040 |  |  |  |  | Rochester
BBLD | [NAME] | CULTURE | [NAME] Culture |  |  |  | Ambient
BBLD | Order Question | Q00M0005 | [NAME] |  | Plain Text
BBLD | Result | BBLD | Bacterial Culture, Blood | Bacterial Culture, Blood | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 681868d1591796500-splitting-multiple-days-from-a-data-set-sample
Sheet: Sheet1

Line # | Order # | Start | Finish
L10 | 2057441 | 2020-04-07 17:55:00 | 2020-04-08 06:35:00
L10 | 2057440 | 2020-04-07 09:40:00 | 2020-04-07 17:55:00
L10 | 2057263 | 2020-04-06 09:15:00 | 2020-04-07 09:40:00
L10 | 2057262 | 2020-04-06 06:30:00 | 2020-04-06 09:15:00
L10 | 2056978 | 2020-04-02 19:35:00 | 2020-04-04 21:40:00
L10 | 2056977 | 2020-04-02 14:45:00 | 2020-04-02 19:35:00
L10 | 2056976 | 2020-04-02 01:25:00 | 2020-04-02 14:45:00
L10 | 2056692 | 2020-03-31 11:20:00 | 2020-04-02 01:25:00
L10 | 2056691 | 2020-03-31 05:45:00 | 2020-03-31 11:20:00
L10 | 2056538 | 2020-03-30 20:25:00 | 2020-03-31 05:45:00
L10 | 2056537 | 2020-03-30 09:55:00 | 2020-03-30 20:25:00
L10 | 2056536 | 2020-03-30 06:30:00 | 2020-03-30 09:55:00
L10 | 2056362 | 2020-03-27 19:15:00 | 2020-03-28 05:30:00
Spreadsheet: 489714d1479399347-summarizing-form-data-into-records-lines-test-form
Sheet: Test Form (2)

 |  |  |  |  |  | LABOR, EQUIPMENT & MATERIAL |  |  |  |  |  |  | # |  | 6150
 | Contact:
 |  |  |  |  | WMLP
 | CUSTOMER: |  |  |  |  |  |  | LINE |  |  |  | DATE:
 | JOB SITE: | MP |  |  | GW |  |  | AFE |  |  |  | JOB #:
 | [NAME] OF WORK: |  |  |  |  |  |  |  |  |  |  | PHASE:
 |  |  |  |  |  |  |  |  |  |  |  | COUNTY:
 | LABOR |  |  |  |  |  |  |  | HOURS |  |  |  | PER  DIEM | TRUCK PAY | Notes
 | TRADE |  |  | EMPLOYEE |  |  |  |  | S.T. |  | O.T. | D.T.
 | EQUIPMENT |  |  |  |  |  |  | EQUIPMENT
 | E-NUMBER | QTY | UoM | [NAME] |  |  |  | E-NUMBER | QTY |  | UoM | DESCRIPTON
 | TRUCKING & VENDORS |  |  |  |  |  |  | PO No. |  |  | FOREMAN'S SIGNATURE:
 |  |  |  |  |  |  |  |  |  |  | INSPECTOR'S PRINTED NAME:
 | MATERIALS |  |  |  |  |  |  | QTY
 |  |  |  |  |  |  |  |  |  |  | INSPECTOR'S SIGNATURE:
Spreadsheet: afd13549-7de1-44fa-a339-0aa6d8131773
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
40139036 | 2014-02-20 00:11:01 | ALLIES | 0 | 2 | 5 | 67493 | [NAME] | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
40139250 | 2014-02-20 00:37:08 | AXIS | 1 | 5 | 4 | 67493 | [NAME] | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
40169414 | 2014-02-21 23:06:49 | ALLIES | 1 | 6 | 1 | 344565 | theone4you | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40169765 | 2014-02-21 23:31:05 | AXIS | 1 | 6 | 4 | 344565 | theone4you | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40170293 | 2014-02-21 23:56:24 | AXIS | 1 | 6 | 2 | 1401055 | PanzerBellota | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
40170503 | 2014-02-22 00:17:25 | ALLIES | 1 | 6 | 5 | 1401055 | PanzerBellota | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
40282829 | 2014-02-28 17:34:43 | AXIS | 0 | 3 | 6 | 1443685 | david.kahn | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
40283117 | 2014-02-28 18:00:13 | ALLIES | 1 | 6 | 2 | 1443685 | david.kahn | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
40283547 | 2014-02-28 18:25:21 | ALLIES | 1 | 7 | 2 | 1498194 | Dondiego | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40283925 | 2014-02-28 18:38:43 | ALLIES | 1 | 6 | 1 | 1004418 | lingfields | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
40284042 | 2014-02-28 18:54:18 | AXIS | 0 | 5 | 6 | 1004418 | lingfields | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
40339986 | 2014-03-03 21:49:46 | ALLIES | 0 | 4 | 10 | 688270 | Mouchotte72 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40340694 | 2014-03-03 22:26:02 | AXIS | 1 | 10 | 5 | 688270 | Mouchotte72 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40369682 | 2014-03-05 18:40:34 | ALLIES | 0 | 4 | 6 | 383581 | [NAME] | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
40370048 | 2014-03-05 19:01:18 | AXIS | 1 | 6 | 2 | 383581 | [NAME] | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 773678d1647991174-setting-up-formula-a-to-check-a-or-tol-between-columns-and-print-a-custom-text-result-mass-tp-csv-attachment
Sheet: ExcelCertAttachmentforTPgtxAmo

Equipment | As Found | Line Number | Description | Standard | Tolerance - Neg | Tolerance - Pos | As Left | UOM | Result | Precision | Deviation | [NAME] | Limited | Result | Uncertaintity | Unc. Uom
 | 0.77 | 4 |  | 0.77 | 0.7699 | 0.7701 | 0.7701 | inch - In |  | 5 |  |  | No | In Tolerance
Spreadsheet: 853259d1703151347-separate-dates-into-year-and-quarter-test
Sheet: Sheet1

2023-01-17 00:00:00
2023-02-24 00:00:00
2023-04-03 00:00:00
2023-05-11 00:00:00
2023-06-18 00:00:00
2023-07-26 00:00:00
2023-09-02 00:00:00
2023-10-10 00:00:00
2023-11-17 00:00:00
2023-12-25 00:00:00
2024-02-01 00:00:00
2024-03-10 00:00:00
2024-04-17 00:00:00
2024-05-25 00:00:00
2024-07-02 00:00:00
2024-08-09 00:00:00
2024-09-16 00:00:00
2024-10-24 00:00:00
2024-12-01 00:00:00
2025-01-08 00:00:00
2025-02-15 00:00:00
Spreadsheet: 715206d1611603124-im-creating-a-tracker-and-would-like-the-current-end-date-to-stop-when-a-condition-forums_example
Sheet: Schottky Cycle time

 |  | Assume Priority P3 |  |  |  |  |  | Start date | Total steps | Days for completion | Steps/day | Supposed step (Today) | Actual current step | ahead/behind by
 | 3 | HP | 1st | 66
 | 3 | HP | Last | 58
 | 3 | LC | 1st | 61
 | 3 | LC | Last | 54
 | 2 | HP | 1st | 56
 | 2 | HP | Last | 52
 | 2 | LC | 1st | 54
 | 2 | LC | Last | 51
Spreadsheet: 35832d1233551517-formula-that-will-give-me-true-or-false-results-test
Sheet: Sheet1

Last Name | First Name |  | Hire/Term Date | Active | Fulltime | Permanent
DOE | [NAME] | BEKELE | 2005-04-29 00:00:00 | 1 | 0 | 0
DOE | [NAME] |  | 2008-01-18 00:00:00 | 1 | 0 | 0
DOE | [NAME] |  | 2008-07-23 00:00:00 | 0 | 1 | 1
SMITH | JON |  | 2007-07-10 00:00:00 | 0 | 0 | 0
SMITH | JON |  | 2008-01-24 00:00:00 | 0 | 0 | 0
DOE | JUSTIN |  | 2003-05-23 00:00:00 | 1 | 0 | 0
DOE | JUSTIN |  | 2003-08-12 00:00:00 | 0 | 0 | 0
ANDREW | [NAME] |  | 2003-05-29 00:00:00 | 1 | 0 | 1
ANDREW | [NAME] |  | 2005-08-24 00:00:00 | 0 | 0 | 0
ANDREW | [NAME] |  | 2005-12-16 00:00:00 | 1 | 0 | 0
ANDREW | [NAME] |  | 2007-02-28 00:00:00 | 0 | 0 | 0
ANDREW | [NAME] |  | 2007-05-11 00:00:00 | 1 | 0 | 0
ANDREW | [NAME] |  | 2007-06-04 00:00:00 | 0 | 0 | 0
ANDREW | [NAME] |  | 2007-07-28 00:00:00 | 1 | 0 | 0
ANDREW | [NAME] |  | 2008-01-31 00:00:00 | 0 | 1 | 1
ANDREW | [NAME] |  | 2008-04-30 00:00:00 | 1 | 1 | 1
Spreadsheet: 494485d1482417756-past-2-months-values-calculation-sample-data
Sheet: Sheet2

 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 5
 |  | Products | Current Month (Sales Quantity-Month to date) |  | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | YTD Total (Till Last Month) | YTD Average (Till Last Month) |  | 2nd Last Month's Sales | Last Month's Sales
 |  | 1 | 755 |  | 9815 | 49075 | 151 | 3020 | 4907.5
 |  | 2 | 510 |  | 6630 | 33150 | 102 | 2040 | 3315
 |  | 3 | 654 |  | 8502 | 42510 | 130.8 | 2616 | 4251
 |  | 4 | 123 |  | 1599 | 7995 | 24.6 | 492 | 799.5
 |  | 5 | 51 |  | 663 | 3315 | 10.2 | 204 | 331.5
 |  | 6 | 516 |  | 6708 | 33540 | 103.2 | 2064 | 3354
 |  | 7 | 3232 |  | 42016 | 210080 | 646.4 | 12928 | 21008
 |  | 8 | 1223 |  | 15899 | 79495 | 244.6 | 4892 | 7949.5
 |  | 9 | 2323 |  | 30199 | 150995 | 464.6 | 9292 | 15099.5
 |  | 10 | 13330 |  | 4797 | 23985 | 73.80000000000001 | 1476 | 2398.5
 |  | Total
Spreadsheet: da051d70-67e4-4346-ad09-a0318f16fc0f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
4343 | 15394 | Mark | [NAME] | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00 | Elite Men
4342 | 15364 | [NAME] | Mantak | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00 | Elite Women
Spreadsheet: 147526d1332841068-order-code-generator-vlookup-test
Sheet: Sheet1

 |  | questions | Answer | Score | Text
 |  | question ! | <Yes> | 3
 | # | #
 |  | question 2 | <Daily> | 5
 | # | #
 |  | question 3 | <know Well> | 2
 | # | #
 |  | question 4 | <You/Individual> | 4
 | # | #
 |  | question 5 | <Yes> | 1
 | # | #
 |  | question 6 | <Highly> | 4
 | # | #
 |  | Total Score | 19 |  | form 009 to be completed and a vist
 | # | #
 | <Yes> | 3
 | <No> | 0
 | <Daily> | 5
 | <Most days> | 3
 | <Most weeks> | 2
 | <Most months> | 1
 | <Rare/1st call> | 0
 | <know Well> | 2
 | <known> | 1
 | <Not Known> | 0
 | <You/Individual> | 4
 | <Your Family/a Family> | 3
 | <The Community> | 1
 | <Highly> | 4
 | <Upset> | 3
 | <Unhappy> | 1 |  |  | form 001 to be completed
 | <[NAME] | 0 | 13 |  | form 009 to be completed and a vist
Spreadsheet: 85922d1285917252-text-into-a-cell-2010-09-28-vendas-de-animais-janeiro-2010
Sheet: Clientes

 |  | CLIENTE |  |  |  | CLIENTE |  |  |  | CLIENTE |  |  |  | CLIENTE |  |  |  | CLIENTE |  |  |  | CLIENTE |  |  |  | CLIENTE |  |  |  | CLIENTE |  |  |  | CLIENTE |  |  |  | CLIENTE |  |  |  | CLIENTE |  |  |  | CLIENTE
CLIENTE |  | PE-EM |  |  |  | DIMES 2000 |  |  |  | [NAME] |  |  |  | IANAKI DIMOV |  |  |  | GEORGI STEFANOV |  |  |  | TROYA 2 |  |  |  | SAXFURAJ |  |  |  | KARMES |  |  |  | GERONIMO COMERCE |  |  |  | IVANOV  & SIN |  |  |  | BMV |  |  |  | ZZZ
MORADA |  | Senokos |  |  |  | Zagorka 15 |  |  |  | Balik 1 |  |  |  | General [NAME] |  |  |  | General [NAME] |  |  |  | [NAME]. |  |  |  | [NAME]., 2 |  |  |  |  |  |  |  | [NAME] 40 |  |  |  | [NAME]. 4 |  |  |  | [NAME] |  |  |  | Z1
CIDADE |  | Balchik |  |  |  | [NAME] |  |  |  | Balchik |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Dulovo |  |  |  |  |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Nº CONTRIBUINTE |  | BG 124 599 036 |  |  |  | BG 123 512 014 |  |  |  | BG 124 090 765 |  |  |  | BG 041 061 569 |  |  |  | BG [PHONE] |  |  |  | BG 148 016 677 |  |  |  | BG 118 034 107 |  |  |  | BG 115 007 959 |  |  |  | BG 124 109 073 |  |  |  | BG 124 060 131 E |  |  |  | BG 834 057 425 |  |  |  | Z3
TIPO PAGAMENTO |  | [NAME] |  |  |  | [NAME] |  |  |  | Pagamento em dinheiro |  |  |  | Pagamento em dinheiro |  |  |  | Pagamento em dinheiro |  |  |  | Pagamento em dinheiro |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Pagamento em dinheiro |  |  |  | Pagamento em dinheiro |  |  |  | Pagamento em dinheiro |  |  |  | Z4
Spreadsheet: 192802d1352559755-hiding-rows-depending-on-the-value-of-a-cell-picked-from-a-drop-down-menu-base
Sheet: Sheet1

 | Model | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Cost |  | Actual |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Base Cost |  | 18000 |  | 17600 |  |  |  |  |  |  |  |  |  |  |  |  | 4
Engine
Diesel |  | 2500 |  | 0
Petrol |  | 1800 |  | 1600
Hybrid |  | 4500 |  | 0
Gearbox
Manual |  | 1000 |  | 100
Automatic |  | 2000 |  | 0
DSG |  | 3000 |  | 0
Wheels
Steel 175 |  | 0 |  | 0
Steel 185 |  | 100 |  | 0
Alloy 195 |  | 200 |  | 0
Alloy 205 |  | 300 |  | 300
Alloy 225 |  | 400 |  | 0
Alloy 235 |  | 500 |  | 0
Colour
Flat Red |  | 0 |  | 0
Flat Blue |  | 0 |  | 0
Black |  | 500 |  | 400
White |  | 250 |  | 0
Silver |  | 600 |  | 0
Sunroof |  | 550 |  | 0
Total
Percentage
Spreadsheet: 725025d1616504637-formula-to-sumif-s-based-on-multiple-criteria-on-same-column-test1
Sheet: Data

CODE
 | ACTUAL
151-01-500 | 366769.16
151-01-501
151-01-502
151-01-503
151-01-504
151-01-511
151-01-002 | 477.82
151-01-003 | 6191.35
151-01-005 | 2699.32
151-01-006 | 3004.47
151-01-007 | 1718.03
151-01-010 | 1797.25
151-01-012 | 8542.23
151-01-013 | 6607.61
151-01-017 | 73.44
151-01-018 | 6
151-01-022 | 1637.46
151-01-023 | 500
151-01-024 | 3941.48
151-01-030 | 0
151-01-060 | 3148.19
151-01-065 | 239.83
151-01-069 | 1409.23
151-01-077 | 830.24
151-01-080 | 67.82
151-01-083 | 4420.66
151-01-091 | 9016.25
151-01-100
151-01-126
151-01-147