tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842809d1694787988-countifs-count-cell-if-two-other-cells-have-the-right-criteria-excel-problem15092023-etaf-2
Sheet: Sheet1

Existing formula
Table A - number of 'CRA' documents per person |  |  | Table B |  |  |  | CRA*
Name | CRA documents |  | ref | Name | Status
J. abinger |  |  | CRA-567 | J. abinger | Made obsolete
D.johnson |  |  | CRA-2 | D.johnson | Made obsolete
[NAME] |  |  | CRA-13 | D.johnson | Revised
 |  |  | SOP-1 | J. abinger | Made obsolete
 |  |  | SOP-15 | [NAME] | Made obsolete
How do get the number of 'CRA' documents per person that are 'made obsolete'?
Name | Made obsolete
J. abinger
D.johnson
[NAME]
Spreadsheet: 867915d1714663040-sum-based-on-selected-book-1
Sheet: Sheet1

Code | Total Cost
a | 696.51
a | 784.41
a | 998.61
a | 2170.03
a | 2443.73
a | 8429.05
a | 12802.39
a | 16638.59
a | 21844.34
a | 31099.86
a | 48732.77
b | 10
b | 904.45
c | 217.14
c | 3918.54
d | 19947.15
d | 53844.69
e | 0
e | 0
e | 0
e | 0
e | 0
e | 1848.45
e | 1848.45
e | 3361.85
e | 0
e | 138.29
Spreadsheet: 108477d1305551926-excel-2007-data-transfer-example
Sheet: Sheet2

Balance | Loan 1 | Loan 2 | Loan 3 | Loan 4 | Loan 5 | Loan 6 | Loan 7 | Loan 8 | Loan 9 | Loan 10 | Loan 11 | Loan 12 | Loan 13 | Loan 14 | Loan 15 | Loan 16 | Loan 17 | Loan 18 | Loan 19 | Loan 20 | Loan 21 | Loan 22 | Loan 23 | Loan 24 | Loan 25 | Loan 26 | Loan 27 | Loan 28 | Loan 29 | Loan 30 | Loan 31 | Loan 32 | Loan 33 | Loan 34 | Loan 35 | Loan 36 | Loan 37 | Loan 38 | Loan 39 | Loan 40 | Loan 41 | Loan 42 | Loan 43 | Loan 44 | Loan 45 | Loan 46 | Loan 47 | Loan 48 | Loan 49 | Loan 50 | Loan 51 | Loan 52 | Loan 53 | Loan 54
Year 1
Year 2
Year3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
Year 10
Year 11
Year 12
Year 13
Year 14
Year 15
Year 16
Year 17
Year 18
Year 19
Year 20
Year 21
Year 22
Year 23
Year 24
Year 25
Year 26
Year 27
Year 28
Year 29
Year 30
Spreadsheet: 598561d1542593346-inventory-aging-fifo-inventory-age-updated
Sheet: Sheet2

 |  |  |  |  |  | [NAME]
 |  | Buffer In | Buffer Out | Daily Buffer Amount |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-3 Days | 4 - 11 Days | 12 - 17 Days | 18+ Days
 | 2017-10-15 00:00:00 | 0 | 0
 | 2017-10-16 00:00:00 | 414 | -22
 | 2017-10-17 00:00:00 | 270 | 0
 | 2017-10-18 00:00:00 | 395 | 0
 | 2017-10-19 00:00:00 | 191 | 0
 | 2017-10-20 00:00:00 | 289 | 0
 | 2017-10-21 00:00:00 | 187 | -30
 | 2017-10-22 00:00:00 | 30 | 0
 | 2017-10-23 00:00:00 | 216 | 0
 | 2017-10-24 00:00:00 | 190 | 0
 | 2017-10-25 00:00:00 | 64 | -96
 | 2017-10-26 00:00:00 | 4 | -28
 | 2017-10-27 00:00:00 | 14 | 0
 | 2017-10-28 00:00:00 | 33 | 0
 | 2017-10-29 00:00:00 | 0 | 0
 | 2017-10-30 00:00:00 | 33 | -30
 | 2017-10-31 00:00:00 | 0 | -32
 | 2017-11-01 00:00:00 | 0 | 0 | 0
 | 2017-11-02 00:00:00 | 0 | 0 | 0
 | 2017-11-03 00:00:00 | 0 | 0 | 0
 | 2017-11-04 00:00:00 | 0 | 0 | 0
 | 2017-11-05 00:00:00 | 0 | 0 | 0
 | 2017-11-06 00:00:00 | 20 | 0 | 0
 | 2017-11-07 00:00:00 | 0 | 0 | 0
 | 2017-11-08 00:00:00 | 0 | 0 | 0
 | 2017-11-09 00:00:00 | 0 | 0 | 0
 | 2017-11-10 00:00:00 | 0 | 0 | 0
 | 2017-11-11 00:00:00 | 0 | 0 | 0
 | 2017-11-12 00:00:00 | 0 | 0 | 0
 | 2017-11-13 00:00:00 | 0 | 0 | 0
 | 2017-11-14 00:00:00 | 0 | 0 | 0
 | 2017-11-15 00:00:00 | 0 | 0 | 0
 | 2017-11-16 00:00:00 | 0 | 0 | 0
 | 2017-11-17 00:00:00 | 0 | 0 | 0
 | 2017-11-18 00:00:00 | 0 | 0 | 0
 | 2017-11-19 00:00:00 | 0 | 0 | 0
 | 2017-11-20 00:00:00 | 0 | 0 | 0
 | 2017-11-21 00:00:00 | 0 | 0 | 0
 | 2017-11-22 00:00:00 | 0 | 0 | 0
 | 2017-11-23 00:00:00 | 0 | 0 | 0
 | 2017-11-24 00:00:00 | 0 | 0 | 0
 | 2017-11-25 00:00:00 | 0 | 0 | 0
Spreadsheet: 7546bda5-3aec-42bc-8725-d314f69a1f5e
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
PMLK | Test | PMLK | Milk, Processed, IgE | Milk, Processed, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PMLK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PMLK | Result | PMLK | Milk, Processed, IgE | Milk, Processed, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6174-7
Spreadsheet: 59747-vlookup-error-alanh
Sheet: Sheet1

DEVICE # | MODEL |  |  |  | STARTS WITH | MODEL
27-0384202 |  |  |  |  | 27 | CLASSIC
31E-0780805 |  |  |  |  | 31 | TP I
34G-0670261 |  |  |  |  | 34 | TP II
34H2-0906558 |  |  |  |  | 343 | 343
343P2-0395893 |  |  |  |  | 344 | 344
344AP-0150496
27-0384203
31E-0780806
34G-0670262
34H2-0906559
343P2-0395894
344AP-0150497
27-0384204
31E-0780807
34G-0670263
34H2-0906560
343P2-0395895
344AP-0150498
27-0384205
31E-0780808
34G-0670264
34H2-0906561
343P2-0395896
344AP-0150499
27-0384206
31E-0780809
34G-0670265
34H2-0906562
343P2-0395897
344AP-0150500
Spreadsheet: 69882d1270564633-adding-based-on-fiscal-year-book2
Sheet: Sheet1

REGION | DOI | PTD | Incurred | Outs Res |  |  | Q1 | Q2 | Q3 | Q4
R1 | 2005-07-01 00:00:00 | 685.71 | 685.71 | 0 |  | R1 | 2752.6 | 4276.54 | 2552.32 | 3810.9
R1 | 2005-08-01 00:00:00 | 690.59 | 690.59 | 0 |  | R2
R1 | 2005-10-01 00:00:00 | 738.9 | 738.9 | 0 |  | R3
R1 | 2005-11-01 00:00:00 | 828.92 | 828.92 | 0
R1 | 2005-12-01 00:00:00 | 170.03 | 170.03 | 0
R1 | 2005-12-21 00:00:00 | 400.42 | 400.42 | 0
R1 | 2006-02-16 00:00:00 | 1153.54 | 1153.54 | 0
R1 | 2006-03-11 00:00:00 | 122.62 | 122.62 | 0
R1 | 2006-05-11 00:00:00 | 470.72 | 470.72 | 0
R1 | 2006-06-02 00:00:00 | 216.02 | 216.02 | 0
R1 | 2006-06-07 00:00:00 | 430.12 | 430.12 | 0
R1 | 2006-06-16 00:00:00 | 208.62 | 208.62 | 0
R1 | 2006-06-24 00:00:00 | 279.9 | 279.9 | 0
R1 | 2006-06-24 00:00:00 | 135.97 | 135.97 | 0
R1 | 2006-06-26 00:00:00 | 164.1 | 164.1 | 0
R2 | 2005-07-01 00:00:00 | 207.66 | 207.66 | 0
R2 | 2005-08-01 00:00:00 | 556.3 | 556.3 | 0
R2 | 2005-10-01 00:00:00 | 108.62 | 108.62 | 0
R2 | 2005-11-01 00:00:00 | 0 | 0 | 0
R2 | 2005-12-01 00:00:00 | 86.05 | 86.05 | 0
R2 | 2005-12-21 00:00:00 | 197.4 | 197.4 | 0
R2 | 2006-03-10 00:00:00 | 638.99 | 638.99 | 0
R2 | 2006-06-21 00:00:00 | 168.81 | 168.81 | 0
R2 | 2006-06-30 00:00:00 | 1859.25 | 1859.25 | 0
R3 | 2005-07-01 00:00:00 | 72.57 | 72.57 | 0
R3 | 2005-10-01 00:00:00 | 685.08 | 685.08 | 0
R3 | 2005-11-01 00:00:00 | 42 | 42 | 0
R3 | 2005-12-01 00:00:00 | 117.96 | 117.96 | 0
R3 | 2006-02-02 00:00:00 | 0 | 0 | 0
R3 | 2006-04-03 00:00:00 | 501.11 | 501.11 | 0
R3 | 2006-04-29 00:00:00 | 314.02 | 314.02 | 0
R3 | 2006-05-02 00:00:00 | 410.41 | 410.41 | 0
R3 | 2006-05-20 00:00:00 | 379.63 | 379.63 | 0
Spreadsheet: 37040d1234978835-adding-hh-mm-ss-not-working-test
Sheet: Sheet1

2:34
2:34
2:34
2:34
2:34
2:34
3:20
3:31
5:03
6:08
6:08
6:08
6:08
6:08
6:09
6:09
6:09
6:17
6:17
6:23
6:23
6:23
6:23
23:28
Spreadsheet: 5b5e83d6-fe91-4336-bdd2-fa2c76876a7f
Sheet: Sheet1

[NAME] | Unnamed: 1
CT | [NAME] (označení dle nového systému)
ZK | [NAME]
SR | studie realizovatelnosti (= proveditelnosti)
DK TSK | dokumentační komise Technické správy komunikací hl. m. Prahy
DUR | dokumentace pro územní rozhodnotí (řízení)
UR | územní rozhodnotí
DSP | dokumentace pro stavební povolení
SP | stavební povolení
VV | [NAME]
OMI | Odbor městského [NAME]. m. Prahy
Spreadsheet: 175926d1345669749-if-not-if-vlookup-holiday
Sheet: Employee Sick  Holiday Vacation

 | Holiday |  |  |  |  |  | Weekend |  |  |  |  |  |  | Weekend |  |  |  |  |  | Weekend
Employee | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 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 | 2012-03-01 00:00:00 | 2012-03-02 00:00:00 | 2012-03-03 00:00:00 | 2012-03-04 00:00:00 | 2012-03-05 00:00:00 | 2012-03-06 00:00:00 | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 2012-03-09 00:00:00 | 2012-03-10 00:00:00 | 2012-03-11 00:00:00 | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-16 00:00:00 | 2012-03-17 00:00:00 | 2012-03-18 00:00:00 | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00 | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00 | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00 | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-14 00:00:00 | 2012-04-15 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00
[NAME]
[NAME]
Stephen
Walter
[NAME]
[NAME]
Spreadsheet: 93879d1293653285-using-gbp-and-pounds-shillings-as-currencies-poundssterlingtopoundsdecimal
Sheet: Sheet1

 | £ | s | d | Decimal |  | Decimal | £ | s | d |  | String
 | 1 | 1 | 0 | 1.05 |  | 1.05 | 1 | 1 | 0 |  | £1/1s/0d
 | 1 | 1 | 1 | 1.054166666666667 |  | 1.054166666666667 | 1 | 1 | 1 |  | £1/1s/1d
 | 1 | 2 | 2 | 1.108333333333333 |  | 1.108333333333333 | 1 | 2 | 2 |  | £1/2s/2d
 | 1 | 3 | 3 | 1.1625 |  | 1.1625 | 1 | 3 | 3 |  | £1/3s/3d
 | 1 | 4 | 4 | 1.216666666666667 |  | 1.216666666666667 | 1 | 4 | 4 |  | £1/4s/4d
 | 1 | 5 | 5 | 1.270833333333333 |  | 1.270833333333333 | 1 | 5 | 5 |  | £1/5s/5d
 | 1 | 6 | 6 | 1.325 |  | 1.325 | 1 | 6 | 6 |  | £1/6s/6d
 | 1 | 7 | 7 | 1.379166666666667 |  | 1.379166666666667 | 1 | 7 | 7 |  | £1/7s/7d
 | 1 | 8 | 8 | 1.433333333333333 |  | 1.433333333333333 | 1 | 8 | 8 |  | £1/8s/8d
 | 1 | 9 | 9 | 1.4875 |  | 1.4875 | 1 | 9 | 9 |  | £1/9s/9d
 | 1 | 10 | 10 | 1.541666666666667 |  | 1.541666666666667 | 1 | 10 | 10 |  | £1/10s/10d
 | 1 | 11 | 11 | 1.595833333333333 |  | 1.595833333333333 | 1 | 11 | 11 |  | £1/11s/11d
 | 1 | 12 | 0 | 1.6 |  | 1.6 | 1 | 12 | 0 |  | £1/12s/0d
 | 1 | 13 | 0 | 1.65 |  | 1.65 | 1 | 13 | 0 |  | £1/13s/0d
 | 1 | 14 | 0 | 1.7 |  | 1.7 | 1 | 14 | 0 |  | £1/14s/0d
 | 1 | 15 | 0 | 1.75 |  | 1.75 | 1 | 15 | 0 |  | £1/15s/0d
 | 1 | 16 | 0 | 1.8 |  | 1.8 | 1 | 16 | 0 |  | £1/16s/0d
 | 1 | 17 | 0 | 1.85 |  | 1.85 | 1 | 17 | 0 |  | £1/17s/0d
 | 1 | 18 | 0 | 1.9 |  | 1.9 | 1 | 18 | 0 |  | £1/18s/0d
 | 1 | 19 | 0 | 1.95 |  | 1.95 | 1 | 19 | 0 |  | £1/19s/0d
Totals | 29 | 16 | 6 | 29.825 |  | 29.825 | 29 | 16 | 6 |  | £29/16s/6d
Spreadsheet: 715490d1611736933-extracting-text-solution
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Result
[NAME] B final silencer exit right/left - 135x80 type 53 right/left |  |  |  |  |  |  |  |  |  | 135x80 type 53 right/left
[NAME] final silencer cross exit right/left  - 2x76 type 12 right/left - with polished facia |  |  |  |  |  |  |  |  |  | 2x76 type 12 right/left
[NAME] I B/C 57 front silencer replacement pipe
Renault 19 - 5 doors final silencer - 135x80 type 53 |  |  |  |  |  |  |  |  |  | 135x80 type 53
Porsche Boxster type 986 final silencer - 135x80 type 53 center |  |  |  |  |  |  |  |  |  | 135x80 type 53 center
Seat Altea 5P/ Seat Altea 5P XL - front wheels drive front silencer
Skoda Octavia 1U 4x4 final silencer - 2x76 type 18 |  |  |  |  |  |  |  |  |  | 2x76 type 18
VW Touareg type 7L final silencer exit right/left - 2x80 type 25 right/left - pipe diameter: 70[NAME] |  |  |  |  |  |  |  |  |  | 2x80 type 25 right/left
Spreadsheet: mary_fischer__25808__EA account conversion for Bentlty
Sheet: Sheet2

A/C # | A/C Description | Jan | Feb | Mar | Apr | May | Jun | Jul
2810 | General Obligations Contingency | 304705.81 | 297544.81 | 297544.81 | 297544.81 | 297544.81 | 297544.81 | 297544.81
3500 | R/E | 836806.02 | 976768.18 | 976768.18 | 976768.18 | 976768.18 | 976768.18 | 976768.18
6230 | Advertising Temp Labor | 938.2 | 2141.67 | 2141.67 | 2141.67 | 2141.67 | 2141.67 | 2141.67
6530 | Telephone | 0 | 11418.89 | 11418.89 | 11418.89 | 11418.89 | 11418.89 | 11418.89
6890 | Misc Income | 0 | 4761.58 | 4761.58 | 4761.58 | 4761.58 | 4761.58 | 4761.58
 |  |  | Balance Changes with no current period activity.  [NAME] builds her MTD file on
 |  |  | current period acitvity.
Spreadsheet: 2c077705-e958-4e2e-a391-98d4756d7cad
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
44335743 | 2014-12-07 01:32:37 | ALLIES | 0 | 3 | 5 | 1288539 | Gorthos | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44335927 | 2014-12-07 01:48:19 | AXIS | 1 | 5 | 2 | 1288539 | Gorthos | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44336096 | 2014-12-07 02:00:19 | AXIS | 0 | 1 | 6 | 767699 | nap1815 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44336211 | 2014-12-07 02:14:02 | ALLIES | 0 | 3 | 6 | 767699 | nap1815 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44336360 | 2014-12-07 02:31:49 | ALLIES | 0 | 5 | 6 | 1246091 | Danish VIKING | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
44336535 | 2014-12-07 02:45:23 | AXIS | 1 | 6 | 1 | 1246091 | Danish VIKING | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
44351171 | 2014-12-08 01:20:37 | ALLIES | 1 | 6 | 5 | 635250 | [NAME] | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44351434 | 2014-12-08 01:43:01 | AXIS | 0 | 5 | 6 | 635250 | [NAME] | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44446752 | 2014-12-14 23:27:35 | ALLIES | 0 | 2 | 4 | 1670860 | zorkdarius | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
44447111 | 2014-12-14 23:41:29 | AXIS | 1 | 4 | 1 | 1670860 | zorkdarius | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
44447337 | 2014-12-14 23:56:39 | ALLIES | 0 | 1 | 6 | 1240562 | Big Taz | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
44447523 | 2014-12-15 00:09:57 | AXIS | 0 | 5 | 6 | 1240562 | Big Taz | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
44447730 | 2014-12-15 00:34:01 | AXIS | 0 | 5 | 6 | 1387464 | bluesunrising | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44447982 | 2014-12-15 00:50:58 | ALLIES | 1 | 6 | 3 | 1387464 | bluesunrising | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
Spreadsheet: 1a4fd918-f046-4d99-a325-341c5dcd14bd
Sheet: Sheet1

Provider: | UC Berkeley School of Law (Provider #02442) | Unnamed: 2
Subject Matter/Title:
Date and Time of Activity:
Location:
 | Eligible California MCLE Credit
 | General Credit | 0
 | Legal Ethics: | 0
 | Law Practice Management: | 0
 | Substance Abuse/Emotional Distress: | 0
 | Civil and Criminal Remedies for Civil Rights Violations: | 0
 | Elimination of Bias in the Legal Profession: | 0
 | Total Hours: | 0
Name of Attendee | CA State Bar Number | Attendee Signature
Spreadsheet: 770492d1646120941-need-help-solving-this-sumif-scenario-copy-of-sample-data
Sheet: Sheet2

 |  |  | 0005
 |  |  | 0006
 |  |  | 0007
 |  |  | 0010
 |  |  | 0015
 |  |  | 0017
 |  |  | 0020
 |  |  | 0025
 |  |  | 0030
 |  |  | 0032
 |  |  | 0035
 |  |  | 0040
 |  |  | 0050
 |  |  | 0053
 |  |  | 0060
 |  |  | 0070
 |  |  | 0081
 |  |  | 0082
 |  |  | 0135
 |  |  | 0200
 |  |  | 0990
Spreadsheet: 49260d1248524749-excel-automation-daily
Sheet: DailyReport

 |  |  | [NAME] REPORT |  |  | JOB NO. |  | Report Date |  | Day on JOB No. | 1 | REPORT NO. | 1
OPERATOR |  |  | FIELD NAME |  | WELL NAME & No. |  | [NAME] |  | [NAME]. | COUNTY |  | STATE
[NAME] |  |  | MUD TYPE |  | MW (PPG) | FNL.VIS | [NAME] (sec) | Stroke | Bbl/STK | SPM | GPM-1 | Job Type
 |  |  |  |  |  |  |  | 0 | 0 | 103 | 0 | Directional
 |  |  | YP (cp) | SAND % | SOLIDS % | Oil % | cl- PPM | Stroke | Bbl/STK | SPM | GPM-2 | Report Circ. Hours
 |  |  |  |  |  |  |  | 0 | 0 | 103 | 0
 |  |  | LCM-Type | LCM-PPB | Temp ° F | Solids Cntrl | Shakers | NMDC ID | [NAME] | SPP | No.Pumps | GPM 1 Pmp | 0
GAP / ORIFICE: |  |  |  |  |  |  |  |  |  |  | 1 | GPM 2 Pmp
 |  |  | MIDNIGHT DEPTH |  |  | Inc°-Start: | Azm°-Strt: | Back-up | S/N | Back-up | S/N | Back-up | S/N
ROTOR/   POPPET: |  |  |  |  |  | 0 | 0 | Pulser: |  | Batt: | n/a | UBHO:
 |  |  |  |  | FEET | Inc°-End: | Azm°-End: | [NAME] |  | BattHsg: | n/a | UBHO:
PULSE WIDTH: |  |  |  |  |  | 0 | 0 | Gamma: |  | LgMSslv: |  | NMDC:
 |  |  | TOTAL CORRECTION ° |  | MagF-gauss | DipA ° | BattVDC | Batt: |  | LgMSslv: |  | BTRx:
[NAME] |  | 0 | 0 | GRID | 0 | 0 | 26.85 | BattHsg: |  | MdMSslv: |  | BTRD:
Run No. |  | 1 | IMO  ° | DAO  ° | [NAME] | [NAME] | [NAME] | Batt: |  | MdMSslv: |  | BTRx:
 |  |  |  | 0 |  |  | OFF | BattHsg: |  | PnyNMDC: | n/a | BTRD:
Strt.Time | End Time | DAILY RIG ACTIVITY SUMMARY (Detailed-3 hr. updates minimum) |  |  |  |  |  |  | Modules in Hole |  | Circulating  Hours
1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | Module Type | Serial Number | Start of REPORT | END of REPORT | Report TOTAL
1900-01-01 00:00:00
1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | Spr Pnt: |  | 0 | 0 | 0
1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | Centlzr 4: |  | 0 | n/a | 0
1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | Centlzr 3: |  | 0 | 0 | 0
1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | Centlzr 2: |  | 0 | 0 | 0
1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | Centlzr 1: |  | 0 | 0 | 0
1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | Gamma: |  | 0 |  | 0
1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | GSF:→>
 |  |  |  |  |  |  |  |  | Battery2: |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | Barrel: |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Battery1: |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Barrel: |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | [NAME]: |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Pulser: |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | LwrEnd: |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | MSSlve: |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | UBHO: |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | NMDC: |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | NMDC: |  | 0 | 0 | 0
COMMENTS: |  |  |  |  |  |  |  |  | BTRx Circulating Hours
Spreadsheet: 181694d1348119183-multiple-countif-statement-using-text-and-month-test
Sheet: Sheet1

Month | First Aid | Medical Aid
2012-01-01 00:00:00 |  |  |  | Example
2012-02-01 00:00:00 |  |  |  | Month | First Aid | Medical Aid
2012-03-01 00:00:00 |  |  |  | 2012-01-01 00:00:00 | 2 | 0
2012-04-01 00:00:00 |  |  |  | 2012-02-01 00:00:00 | 0 | 0
2012-05-01 00:00:00 |  |  |  | 2012-03-01 00:00:00 | 0 | 0
2012-06-01 00:00:00 |  |  |  | 2012-04-01 00:00:00 | 0 | 1
CountIf Statement Driven |  |  |  | 2012-05-01 00:00:00 | 1 | 0
 |  |  |  | 2012-06-01 00:00:00 | 0 | 1
Spreadsheet: 86746d1286725360-count-unique-values-based-on-several-criteria-sample-workbook
Sheet: Sheet1

User | Text | ID | Type | Date
User | Text | a1 | A | 1900-01-09 00:00:00
User | Text | a2 | A | 1900-01-09 00:00:00
User2 | Text | a1 | A | 1900-01-08 00:00:00
User | Text | c1 | C | 1900-01-09 00:00:00
User | Text | a1 | A | 1900-01-09 00:00:00
User | Text | a3 | B | 1900-01-09 00:00:00
User3 | Text | a1 | A | 1900-01-08 00:00:00
User | Text | a1 | A | 1900-01-10 00:00:00
User | Text | b1 | A | 1900-01-09 00:00:00
Spreadsheet: 491381d1480442050-weighted-percentile-calculation-help-weightedpercentilesample
Sheet: Sheet1

Sample Data |  |  |  |  |  |  | Desired Result
Item Number | Qty | Value |  |  |  |  | 289 |  | 0.05
101 | 1 | 289 |  |  |  |  | 289 |  | 0.25
102 | 1 | 207 |  |  |  |  | 207 |  | 0.5
103 | 1 | 255 |  |  |  |  | 255
104 | 2 | 204 |  |  |  |  | 204
105 | 3 | 270 |  |  |  |  | 270
106 | 1 | 277 |  |  |  |  | 270
107 | 5 | 272 |  |  |  |  | 270
108 | 1 | 259 |  |  |  |  | 277
109 | 1 | 257 |  |  |  |  | 272
110 | 1 | 253 |  |  |  |  | 272
 |  |  |  |  |  |  | 272
 |  |  |  |  |  |  | 272
 |  |  |  |  |  |  | 272
 |  |  |  |  |  |  | 259
 |  |  |  |  |  |  | 257
 |  |  |  |  |  |  | 253
Spreadsheet: 718530d1613166538-return-unique-count-example
Sheet: Example

ID | Value | Comment
A1 | 10 | Price
A1 | 10 | Price |  |  |  |  | B1
A1 | 10 | Price |  |  |  |  | C1
B1 | 5 | Value |  |  |  |  | D1
B1 | 5 | Value
C1 | 20
D1 | 15 | Value
D1 | 14 | Value
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -68011 | -37500 | -90 | -29410
2 | -49057 | -20000 |  | -27910
3 | -48415 | -11000 |  | -36910
4 | -29951 |  |  | -29410
5 | -29999 |  |  | -29410
6 | -29297 |  |  | -28307
7 | -64051 | -11000 |  | -51049
8 | -35246 |  |  | -34257
9 | -61903 | -10000 |  | -49974
10 | -63569 | -17500 |  | -44910
11 | -57587 | -27000 |  | -28288
12 | -57418 | -27000 |  | -28592
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  |  |  | 36339
 | 2001-08-12 00:00:00
CBS Dollars
 |  |  | -29968.41
Spreadsheet: 81064d1281346133-if-vlookup-and-linear-interpolation-combined-excel-forum-question
Sheet: Sheet1

Height | Terrain Category |  | Table 4.1(A) Mz,cat
63 | Cat 1 |  | Height (z) m | Terrain/height multiplier ([NAME],cat)
 |  |  |  | Cat 1 | Cat 2 | Cat 3 | Cat 4
 |  |  | 3 | 0.99 | 0.91 | 0.83 | 0.75
 |  |  | 5 | 1.05 | 0.91 | 0.83 | 0.75
 |  |  | 10 | 1.12 | 1 | 0.83 | 0.75
 |  |  | 15 | 1.16 | 1.05 | 0.89 | 0.75
 |  |  | 20 | 1.19 | 1.08 | 0.94 | 0.75
 |  |  | 30 | 1.22 | 1.12 | 1 | 0.8
 |  |  | 40 | 1.24 | 1.16 | 1.04 | 0.85
 |  |  | 50 | 1.25 | 1.18 | 1.07 | 0.9
 |  |  | 75 | 1.27 | 1.22 | 1.12 | 0.98
 |  |  | 100 | 1.29 | 1.24 | 1.16 | 1.03
 |  |  | 150 | 1.31 | 1.27 | 1.21 | 1.11
 |  |  | 200 | 1.32 | 1.29 | 1.24 | 1.16
 |  |  | 250 | 1.34 | 1.31 | 1.27 | 1.2
 |  |  | 300 | 1.35 | 1.32 | 1.29 | 1.23
 |  |  | 400 | 1.37 | 1.35 | 1.32 | 1.28
 |  |  | 500 | 1.38 | 1.37 | 1.35 | 1.31