tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: eric_saibi__9812__9-23-01
Sheet: Summary

Flow Date |  | Available Off Peak Capacity |  |  |  |  |  |  | Available On Peak Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Off Peak Capacity
2001-09-23 00:00:00
Counterparty |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
Enron Call |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mirant Call |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
FPL |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18.75
Total
[NAME]: |  | Deal Details
18.75
Deal_id |  | CP | Volume | Price | Start Hour |  | End Hour
 |  | Mirant Call | -50 |  | 8 |  | 24
784865.1 |  | [NAME] | -50 | 18.75 | 8 |  | 24
784837.1 |  | FPL | 50 | 18.75 | 8 |  | 24
758660.15 |  | Enron Call | -100 |  | 7 |  | 22
784271.1 |  | Enron bk/out | 100 | 20.25 | 7 |  | 22
Spreadsheet: 4930dc35-87f2-49fb-9fc4-c7cdb2ecde27
Sheet: Sheet1

FragmentSmiles
[*][C@H]1[*][c](:[*]):[c](C[C@@H]1N([*])[*]):[c]([*]):[*]
[*][N+](=O)[*]
[*][N+](=[*])[O-]
[*]:[c](:[*])[N+](=O)[O-]
[*][N+](=[*])[*]
[*][c](:[*]):[c](:[cH]:[*])[N+](=[*])[*]
[*][c](:[*]):[c](:[cH]:[*])[N+](=O)[O-]
[*]C[C@H](O[*])C([*])[*]
[*]C1=C2C[*][*]CCN2[c](:[cH]:[*]):[c](:[*])[*]1
[*]C[c]1:[c]([*]):[*]:[c](:[*]):[c](:[cH]:[*]):[c]:1N
[*]C(=[*])C(=O)[c](:[*]):[*]
[*]C[C@H]1OCC[*][C@@H]1[*]
[*]N1[*]CO[C@H]2C[c](:[*]):[*]C[C@H]12
[*]=C1[*]C2=[*][*]CN2[c]3:[cH]:[cH]:[*]:[cH]:[c]1:3
[*]C(=[*])C1=C([*])[*][*][c](:[*]):[c](:[cH]:[*])C1=O
[*]C(=[*])[c]1:[c]([*]):[*]:[cH]:[cH]:[c]:1C
[*]N1[*]=C([*])C(=O)[c]2:[cH]:[cH]:[*]:[cH]:[c]1:2
[*]:[cH]:[c]1CCC[*][c]:1:[*]
[*]C(=[*])C1=C2CC[*][*]CN2C(=[*])[*]=C1[*]
[*]O[c]1:[cH]:[*]:[c]([*]):[c]2C[*][C@H]([*])C[c]:1:2
[*]CC1=[NAME][*]
[*]:[c]1C[c]2:[cH]:[cH]:[*]:[cH]:[c]:2[c]:1:[*]
[*]:[c](:[*])C1=N[*]CCC1
[*][c](:[*]):[c](N):[c]([*]):[*]
[*]C(=C(C(=[*])[*])C(=[*])[*])[*]
[*]O[C@@H]1C[c](:[c]([*]):[*]):[c](:[*])[*][C@H]1[*]
[*]CBr
[*][c]1:[*]:[cH]:[c](:[cH]:[cH]:1)[N+](=[*])[*]
[*][C@@H]1[*]N([*])CCO1
[*]n1:[*]:[*]:[c]2[*]C(=[*])N(C)C(=O)[c]:1:2
[*][c]1:[*]:[*]:[c]2:[*][*]CCC(=O)[c]:1:2
[*][N+](=[*])[c](:[cH]:[*]):[cH]:[*]
[*]:[cH]:[c](:[cH]:[*])[N+](=O)[O-]
[*]N([*])C1=C([*])CCC1
[*]COC(=O)C(=C([*])[*])C(=[*])[*]
[*][c]1:[*]:[cH]:[cH]:[c]2:[NAME]
[*]N1[*][*]:[c](:[*])CCC1
[*]=C1CCCN1[c](:[*]):[*]
[*]=C
[*]CC(=C([*])[*])N([*])[*]
[*]C[c]1:[c]([*]):[*]:[cH]:[cH]:[c]:1OC
[*]:[c]1:[*][*]CC1=O
[*]C1[*][c](:[*]):[c](:[cH]:[*])C(=O)C1
[*]:[c]1:[*]C[C@H]2O[*]CN(C)[C@@H]2C1
[*][C@H]1[*][*]C(=[*])C1
[*]C[C@@H](C([*])[*])N([*])[*]
[*]C(=[*])[c]1:[c]([*]):[*]:[*]:n:1[*]
[*][c](:[*]):[c]1:[c]([*]):[*]:[*]:[c]:1:[*]
[*][C@@H]1[*][*]CN1C
[*]C([*])[c](:[cH]:[*]):[c]([*]):[*]
Spreadsheet: 154876d1336586804-count-hours-for-sales-reps-and-customers-new-sumproduct-star
Sheet: Sheet1

I want to add [NAME]'s hours (the green numbers): 2+8+3=13
 |  |  |  |  |  |  |  |  |  | Later I will want a more general formula for all Rep-ID combinations
 |  |  |  |  |  |  |  |  |  |  | Customer ID
Customer ID | Rep | Hours | Rep | Hours | Rep | Hours |  |  |  |  | 111 | 333 | 444 | 666 | 987 | abc | def | ghi
987 | [NAME] | 2 | [NAME] | 4 | [NAME] | 5 |  |  |  | [NAME]
234 | [NAME] | 5 | Sue |  | [NAME] | 3 |  |  |  | [NAME]
111 | [NAME] | 3 | [NAME] |  | Sue | 2 |  |  |  | [NAME]
567 | [NAME] | 2 | [NAME] |  | [NAME] | 4 |  |  |  | [NAME]
111 | [NAME] | 7 | [NAME] |  | [NAME] | 3 |  |  |  | [NAME]
987 | [NAME] | 7 | [NAME] |  | [NAME] | 3 |  |  |  | [NAME]
333 | Sue | 7 | [NAME] |  | [NAME] | 2 |  |  |  | [NAME] |  |  |  |  | 13
444 | [NAME] | 8 | [NAME] |  | [NAME] | 4 |  |  |  | [NAME]
987 | [NAME] | 4 | [NAME] | 3 | [NAME] | 3 |  |  |  | [NAME]
666 | [NAME] | 8 | [NAME] | 3 | [NAME] | 3 |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Sue
 |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: f7f021f9-0d8f-4530-a7ed-603a329b5164
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
CATLN | Test | CATLN | Calcitonin, Fine-Needle Aspiration Biopsy (FNAB)-Needle Wash, [NAME] | Calcitonin, FNAB, [NAME] | Immunoenzymatic Assay |  |  |  | 1.5 | mL | Container/Tube: Sterile vial [NAME]: 1.5 mL Collection Instructions: After collection of the cytology specimens and expulsion of the material for smear or CytoTrap, process as follows: 1. Wash/rinse each FNA needle from a single biopsied area with 0.1 to 0.5 mL of normal saline.  2. Pool each wash from a single biopsied area into 1 vial. The washes from a biopsied area are pooled (final volume 1-1.5 mL). If more than 1 area is biopsied, each biopsy area should be submitted as a separate specimen, under a separate order. 3. Inspect the specimen as follows: a. If the specimen shows visible blood or tissue contamination, centrifuge the specimen, transfer the supernatant to a new plastic vial, and freeze. b. If specimen is clear, freeze specimen in plastic vial. [NAME] should be frozen within 2 to 4 hours of collection. | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm Reject; Cold Reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; Varies | Same day/1 day | 3 days | 1 | 82308 |  |  |  |  | Rochester
CATLN | [NAME] | FNWASH | Fine Needle Wash |  |  |  | Frozen | 7 days
CATLN | Result | CATL | Calcitonin, FNAB, [NAME] | Calcitonin, FNAB, [NAME] | Numeric |  |  |  |  | pg/mL
CATLN | Result | SITEB | Site | Site | Numeric
Spreadsheet: 757214d1638120247-return-large-or-small-value-when-criteria-is-met-large-if-worksheet
Sheet: Sheet1

Soil Rating | Cropland A Value
56 | 6430.37
60 | 5868.93
75 | 5537.63 |  |  |  | Largest | Smallest | Average
68 | 5611.08 |  |  | Soil Rating Above 60 | 5869 | 5053 | 5518
58 | 5174.83 |  |  | Soil Rating Below 60 | 6581 | 5175 | 5803
56 | 6100
71 | 5053.49
55 | 6580.61
59 | 5679.78
53 | 5356.87
58 | 5700
51 | 5400
Spreadsheet: 764111d1642595749-conditional-formatting-of-range-dependant-on-value-in-column-outside-range-book1
Sheet: Sheet1

 |  | Location | Owner |  | a | b | c | d | e | f
 |  | l1 |  |  |  | X | X | X | X | X
 |  | l2 |  |  | Jul 22 | X | X | X | X | X
 |  | l3 |  |  | X | Nov 22 | X | X | X | X
 |  | [NAME] |  |  | X | X | X | X | X | X
 |  | l5 |  |  | X | X | X | X | X | X
 |  | l6 |  |  | X | X | X | X | X | X
 |  | [NAME] |  |  | X | X | X | X | X | X
 |  | [NAME] |  |  | X | X | X | X | X | X
 |  | l9 |  |  | X | X | X | X | X | X
 |  | l10 |  |  | X | X | X | X | X
 |  | l11 |  |  | X | X | X | X | X | X
 |  | l12 |  |  | X | X | X | X | X | X
 |  | l13 |  |  | X
 |  | l14 |  |  | X | WIP
 |  | l15 |  |  | X | X | X | X | X | X
Spreadsheet: 818278d1676693709-im-tracking-temperature-for-the-days-looking-for-help-temperature-sample
Sheet: kvsrinivasamurthy

Temperature
 | High | Low
2022-12-30 00:00:00 | 80.67 | 77.71
2023-01-03 00:00:00 | 81.5 | 76.6
2023-01-04 00:00:00 | 77.42 | 72.73
2023-01-05 00:00:00 | 74.92 | 72.46
2023-01-06 00:00:00 | 75.47 | 73.24
2023-01-09 00:00:00 | 76.74 | 73.47
2023-01-10 00:00:00 | 75.92 | 73.84
2023-01-11 00:00:00 | 77.84 | 74.31
2023-01-12 00:00:00 | 79.16 | 77.1
2023-01-13 00:00:00 | 80.11 | 77.97
2023-01-17 00:00:00 | 81.23 | 78.53
2023-01-18 00:00:00 | 82.66 | 79.21
2023-01-19 00:00:00 | 81.49 | 78.45
2023-01-20 00:00:00 | 81.91 | 79.91
2023-01-23 00:00:00 | 82.64 | 81.05
2023-01-24 00:00:00 | 82.22 | 79.66
2023-01-25 00:00:00 | 81.23 | 79.45
2023-01-26 00:00:00 | 82.14 | 79.92
2023-01-27 00:00:00 | 82.48 | 79.04
2023-01-30 00:00:00 | 80.49 | 77.66
2023-01-31 00:00:00 | 79.25 | 76.55
2023-02-01 00:00:00 | 79.73 | 76.05
2023-02-02 00:00:00 | 77.24 | 74.97 |  |  |  |  |  | Im thinking he first step would be to find the lowest High temperature and  fill that cell a color
2023-02-03 00:00:00 | 78 | 73.1 |  |  |  |  |  | But  in addition to that argument, it cant have a low temperature above it
2023-02-06 00:00:00 | 74.51 | 72.25 |  |  |  |  | High | This cell next to the high would contain the lowest high temperature value of 74.5 that did not have a low temperature value above it The 72 doesn’t count because it on the same day
2023-02-07 00:00:00 | 77.6 | 74.35
2023-02-08 00:00:00 | 78.57 | 77.08
2023-02-09 00:00:00 | 78.84 | 76.52 |  |  |  |  |  | Then for the low temperature the Highest Low temperature fill that green or something
2023-02-10 00:00:00 | 80.33 | 77.47 |  |  |  |  | Low | But  in addition to that argument, it cant have a high temperature below it
2023-02-13 00:00:00 | 80.62 | 78.45
2023-02-14 00:00:00 | 79.61 | 77.46 |  |  |  |  |  | Im not sure if this could be updated as I insert additional temperatures
 |  |  |  |  |  |  |  | This is what I have been working on kinda fiddling with the formulas
 | =AND(ROWS($B$3:$B3)>1,$B3=SMALL($B$3:$B3,1))
 |  | =[NAME]LARGE($C3:$C$33,1))
Spreadsheet: 77502d1277958480-skip-rows-autofill-demo
Sheet: Sheet1

1
2
3
4
5
6
7
8
Spreadsheet: 884562d1733798674-lookup-text-and-match-by-searching-in-range-partial-text
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Expected Required Result |  | Main Data to Lookup
 |  |  |  |  |  |  |  | Lookup from M column | Result1 | Result2
 |  |  |  |  |  |  |  | Private Limited | 24 | 32146 Private Limited | 19 | 3426 Apex Court
 |  |  |  |  |  |  |  | Private Limited | 24 | 32146 Private Limited | 20 | 26364 High Court
 |  |  |  |  |  |  |  | Government Institution | 22 | 14421 Government Institution | 22 | 14421 Government Institution
 |  |  |  |  |  |  |  | Public Limited | 23 | 11122 Public Limited | 23 | 11122 Public Limited
 |  |  |  |  |  |  |  | Private Limited | 24 | 32146 Private Limited | 24 | 32146 Private Limited
 |  |  |  |  |  |  |  | Private Limited | 24 | 32146 Private Limited | 25 | 91424 Other Entities
Spreadsheet: 777792d1650620781-creating-lookup-formula-using-3-drop-down-selections-kalkulator_pompy
Sheet: pompy

 | Pompa | 180 L | 300 L | COMPACT | 450L |  | Producent |  | [NAME] | Klasa energetyczna | [NAME] | Gwarancja | Czynnik chłodniczy | [NAME] grzałek | [NAME] faz | Cena
 | ARISTON 5 kW | 31070 | 33070 | 35070 | 350 |  | ARISTON 5 kW | 12 | 5 | [NAME] |  | do 8 lat | R410A | 4 | 1 | 40 L
 | ARISTON 7 kW | 32190 | 34190 | 36190 | 420 |  | ARISTON 7 kW | 12 | 7 | [NAME] |  | do 8 lat | R410A | 4 | 1 | 40 L
 | ARISTON 11 kW | 35710 | 37710 | 39710 | 490 |  | ARISTON 11 kW | 12 | 11 | [NAME] |  | do 8 lat | R410A | 6 | 1 | 40 L
 | ARISTON 14 kW | 40330 | 42330 | niedostępne | 560 |  | ARISTON 14 kW | 12 | 14 | [NAME] |  | do 8 lat | R410A | 6 | 3 | 40 L
 | ARISTON 16 kW | 42170 | 44170 | niedostępne | 630 |  | ARISTON 16 kW | 12 | 16 | [NAME] |  | do 8 lat | R410A | 6 | 3 | 40 L
 | LG 5kW | 34750 |  | niedostępne | 700 |  | LG 5kW | 12 | 5 | [NAME] |  | do 5 lat | R32 | 6 | 1 | 40 L
 | LG 7 kW | 35210 |  | niedostępne | 770 |  | LG 7 kW | 12 | 7 | [NAME] |  | do 5 lat | R33 | 6 | 1 | 40 L
 | LG  9kW | 36150 |  | niedostępne | 840 |  | LG  9kW | 12 | 9 | [NAME] |  | do 5 lat | R34 | 6 | 1 | 40 L
 | LG 12 kW | 37140 |  | niedostępne | 910 |  | LG 12 kW |  | 12 | A+ |  | do 5 lat | R410A | 6 | 1 | 40 L
 | LG 14 kW | 42640 |  | niedostępne | 980 |  | LG 14 kW |  | 14 | A+ |  | do 5 lat | R410A | 6 | 1 | 40 L
 | LG 16 kW | 44300 |  | niedostępne | 1050 |  | LG 16 kW |  | 16 | A+ |  | do 5 lat | R410A | 6 | 1 | 40 L
 |  | Bufor 100 | Bufor 200 | Bufor 300 | Bufor 400
 | Bufor 1 | 560 | 630 | 840 | 980
 | Bufor 2 | 630 | 700 | 910 | 1050
 | Bufor 3 | 700 | 770 | 980 | 1120
 | Bufor 4 | 770 | 840 | 1050 | 1190
 | Bufor 5 | 840 | 910 | 1120 | 1260
 | Bufor 6 | 910 | 980 | 1190 | 1330
 | Bufor 7 | 980 | 1050 | 1260 | 1400
 | Bufor 8 | 1050 | 1120 | 1330 | 1470
Spreadsheet: 705009d1605847134-complicated-look-up-with-spaces-in-search-table-error
Sheet: TR -2 latest

CALC | Legal Entity / Trading Name | Account Number / Site Code | Lease Number / CADD Code | Lease Name | Building / Land | Floor / Parcel | Site Description
 | AIRSERVICES AUSTRALIA | DP60355001 | CV512 | AIRSERVICES MAIN LEASE
 | AIR SERVICES AUSTRALIA | 01-AS-001004 |  |  | RUNWAYS AND TAXIWAYS | ASA FACILITIES | OTHER
 | AIR SERVICES AUSTRALIA | 01-AS-001016 |  |  | RUNWAYS AND TAXIWAYS | ASA FACILITIES | OTHER
 | ASIANA AIRLINES INC | DP914178 | OZ006 | ASIANA AIRLINES LVL3 T1
 | ASIANA AIRLINES | T1-L3-031004 | 3-1004 |  | TERMINAL 1 | LEVEL 3 | OFFICE
 | ASIANA AIRLINES | T1-L3-031004 | 3-1004 |  | TERMINAL 1 | LEVEL 3 | OFFICE
 | ASIANA AIRLINES | T1-L3-031004 | 3-1004 |  | TERMINAL 1 | LEVEL 3 | OFFICE
 | ATTORNEY GENERALS DEPARTMENT | DP100548 | [NAME] | ATTORNEY GENERALS DEPT OFFICES T1
 | ATTORNEY GENERALS DEPT | T1-L1-0B1008 | B1-008 |  | TERMINAL 1 | LEVEL 1 | GOVERNMENT
 | ATTORNEY GENERALS DEPT | T1-L1-0C1002 | C1-002 |  | TERMINAL 1 | LEVEL 1 | OFFICE
 | ATTORNEY GENERALS DEPT | T1-L1-0C1002 | C1-002 |  | TERMINAL 1 | LEVEL 1 | OFFICE
 | ATTORNEY GENERALS DEPT | T1-L1-0C1002 | C1-002 |  | TERMINAL 1 | LEVEL 1 | OFFICE
 | ATTORNEY GENERALS DEPT | T1-M-01M012 | 1M-012 |  | TERMINAL 1 | MEZZANINE | GOVERNMENT
 | GM CABS PTY LIMITED | DP914181 | [NAME] | GM CABS BLDG 246/128 OFFICE L3
 | GM CABS | 10-DO-010048 |  |  | DOMESTIC SPINE | OTHER | CAR PARK
 | GM CABS | 128-1-010071 |  |  | BUILDING 128 | SINGLE LEVEL | OFFICE
 | GM CABS | 246-3-0F3010 |  |  | BUILDING 246 | LEVEL 3 | OFFICE
 | GM CABS PTY LIMITED | DP914181 | GG505 | GM CABS OVERFLOW
 | GM CABS PTY LIMITED | DP914181 | GM504 | GM CABS - FAC OFFICE
 | GM CABS | 10-DO-010048 |  |  | DOMESTIC SPINE | OTHER | CAR PARK
 | GM CABS | 10-DO-010048 |  |  | DOMESTIC SPINE | OTHER | CAR PARK
 | GM CABS | 246-1-0F1006 |  |  | BUILDING 246 | LEVEL 1 | OFFICE
 | GM CABS | 246-1-0F1006 |  |  | BUILDING 246 | LEVEL 1 | OFFICE
 | WALKER MASCOT PTY LTD | DP960605 | WM501 | WALKER  - HANGAR 3
 | WALKER - HANGAR 3 | H3-1-010047 |  |  | HANGAR 3 | ALL LEVELS | OTHER
 | WCC NSW Pty Ltd | DP914338 | EP513 | ENTERPRISE RAC - 2015 CONTRACT
Spreadsheet: 797540d1663945470-excel-date-issue-date-issue
Sheet: Sheet1

date
Wed, 31 Dec 2014 18:00:39 +0000
Wed, 31 Dec 2014 16:48:46 +0000
Wed, 31 Dec 2014 15:14:26 +0000
Wed, 31 Dec 2014 14:58:04 +0000
Wed, 31 Dec 2014 13:19:11 +0000
Wed, 31 Dec 2014 10:16:54 +0000
Tue, 30 Dec 2014 18:59:07 +0000
Tue, 30 Dec 2014 18:48:54 +0000
Tue, 30 Dec 2014 14:44:31 +0000
Tue, 30 Dec 2014 14:34:25 +0000
Tue, 30 Dec 2014 13:21:46 +0000
Tue, 30 Dec 2014 09:47:04 +0000
Mon, 29 Dec 2014 20:00:28 +0000
Mon, 29 Dec 2014 19:21:07 +0000
Mon, 29 Dec 2014 16:04:09 +0000
Mon, 29 Dec 2014 15:47:03 +0000
Mon, 29 Dec 2014 15:13:59 +0000
Mon, 29 Dec 2014 15:12:10 +0000
Mon, 29 Dec 2014 13:57:07 +0000
Spreadsheet: 697853d1601570572-count-of-numbers-in-a-range-equal-to-or-less-than-criteria-not-including-next-lower-number-numbers-example
Sheet: Sheet1

Numbers |  |  | Criteria | Count
40 |  |  | 40 | 3
39.2 |  |  | 39 | 2
39.4 |  |  | 38 | 2
39 |  |  | 37 | 0
38 |  | Example
38.2 |  | For criteria 40, numbers 40.0 down to 39.1 but not 39.0
37.7 |  | Also nothing higher than 40.0
99
 |  | For criteria 39, numbers 39.0 down to 38.1 but not 38.0
 |  | Also nothing higher than 39.0
Spreadsheet: d414b201-597a-477e-91ce-b0ddf122ee1b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4960 | 10324 | [NAME] | [NAME] | ITA | 393 | 00:28:32 | 00:01:24 | 02:51:55 | 00:00:56 | 00:56:28 | 1 | 04:19:13
4960 | 29543 | Simona | Mele | ITA | 392 | [NAME] | 00:02:30 | 03:54:41 | 00:02:41 | 01:08:14 | 2 | 05:35:00
Spreadsheet: 124223d1318258769-excel-2007-common-finder-exx
Sheet: Sheet1

Common A | Common B |  | IDEAL |  | ANSWER
12 | 24 |  | 9 |  | 3
 |  |  |  | 3 | 9 | 15
 |  |  |  | 2 | 8 | 16
 |  |  |  | 1 | 7 | 17
 |  |  |  |  | 6 | 18
 |  |  |  |  | 5 | 19
Spreadsheet: 23884d1213720648-sort-and-extract-data-from-one-excel-file-into-multiple-excel-files-sample-file
Sheet: Sheet1

Company # | Division # | Store /  Branch # | Department # | GL Account # | Vendor # | [NAME] | Receiving # | Customer # / PO | Customer Name | Invoice # | Receiving Date | Invoice AMT | GST Amt | QST Amt | Invoice Date | Payment Date | Discount Rate
5 | 3 | 374 | 18 | 5768 | 92253 |  | 1 | 8681120 |  | 2126380374 | 20080502 | 72.66 | 0 | 0 | 20080501 |  | 0
2 | 5 | 531 | 18 | 5768 | 92253 |  | 2 | 8680361 |  | 2126380375 | 20080502 | 21.14 | 0.98 | 0 | 20080501 |  | 0
2 | 5 | 550 | 18 | 5768 | 92253 |  | 3 | 8681021 |  | 2126380376 | 20080502 | 3.39 | 0.16 | 0 | 20080501 |  | 0
Spreadsheet: 266301d1379577927-working-days-and-hours-only-0a212
Sheet: Data

 |  |  | Hours Worked
 | Start | End | Shorter [NAME] | Longer Formula
 | 2013-09-07 09:30:00 | 2013-09-13 16:00:00 | 42.49999999988358 | 42.49999999988358
 | 2010-08-17 13:30:00 | 2010-08-17 14:45:00 | 1.250000000058208 | 1.250000000058208
 | 2010-08-17 15:00:00 | 2010-08-18 17:00:00 | 11.00000000005821 | 11.00000000005821
 | 2010-08-18 17:01:00 | 2010-08-19 16:00:00 | 7.983333333337214 | 7.983333333337214
 | 2010-08-19 17:00:00 | 2010-08-20 10:00:00 | 1.999999999883585 | 1.999999999883585
 | 2010-08-20 11:00:00 | 2010-08-20 17:00:00 | 6.000000000174623 | 6.000000000174623
 | 2010-08-20 17:30:00 | 2010-08-23 13:00:00 | 4.5 | 4.5
 | 2010-08-23 14:00:00 | 2010-08-23 16:00:00 | 1.999999999883585 | 1.999999999883585
 | 2010-08-23 17:00:00 | 2010-08-23 18:00:00 | 1.000000000116415 | 1.000000000116415
 | 2010-08-24 09:00:00 | 2010-08-25 14:00:00 | 14.00000000005821 | 14.00000000005821
 | 2010-08-25 15:00:00 | 2010-08-27 18:00:00 | 21 | 21
 | Approach
Spreadsheet: 648448d1573052735-formula-to-generate-true-or-false-in-the-target-cells-only-true-false_v2-bittubadri-
Sheet: Time

 |  | Result |  |  |  | Result | Result | Result
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 15 | 14 | 11
MM/DD/YY |  |  |  |  |  |  |  |  |  | hours | minutes | seconds
Movement (%) |  |  |  | 2
 |  |  |  |  |  |  |  |  | Prev Close
 |  |  |  |  |  |  |  |  | Prev HIGH
 |  |  |  |  |  |  |  |  | Prev LOW
 |  |  |  |  |  |  |  |  | Open
Next Day's Closing Time
Spreadsheet: 194963-text-to-columns-example
Sheet: Sheet1

a
b
c
d
e
f
g
b
c
d
e
f
g
h
h
i
j
k
l
m
n
Spreadsheet: 111813d1308093363-if-find-or-mid-functions-submittal-returns
Sheet: Sheet1

Name | Title | Doc No. | Correspondence No. | Doc. Date | Doc.Type | Procurement No. | Contract Pkg. No. | To | To Organization | From | From Organization | Project Name
U220-REC-02524 - SUB 317119-022.001 1.04E.4 Class 1 Div 2 Cert for TBM.pdf
U220-REC-02526 - SUB 317119-027.001 1.04D.3 Tunnel Safety Plan.pdf
U220-REC-02527 - SUB 316617-144.001 1.05C.6a-f Slurry Panel Summary Report P-45.pdf
U220-REC-02528 - SUB 316617-145.001 1.05C.6a-f Slurry Panel Summary Report P-85.pdf
U220-REC-02529 - SUB 316617-146.001 1.05C.6a-f Slurry Panel Summary Report P-53.pdf
U220-REC-02530 - SUB 316617-147.001 1.05C.6a-f Slurry Panel Summary Report S-82.pdf
U220-REC-02531 - SUB 316617-148.001 1.05C.6a-f Slurry Panel Summary Report P-49.pdf
U220-REC-02655 - SUB 015724-053.001 1.05C2b SMR April 2011.pdf
U220-REC-02686 - SUB 317126-002.001 1.03F Completed MSHA Forms.pdf
U220-REC-02687 - SUB 317323-006.001 1.05E Tail Void Grouting Means and Methods.pdf
U220-REC-02679 - SUB 317119-020.002 1.04D2 Tunnel Training Plan.pdf
U220-REC-02672 - SUB 014500-100.001 1.04J IDRS Feb 2011.pdf
U220-REC-02673 - SUB 015713-071.001 1.04D TESC Inspection WE 05-06-11.pdf
U220-REC-02674 - SUB 015724-052.001 1.05C2a DMR Apr 2011.pdf
U220-REC-02675 - SUB 015724-054.001 1.05F Chemical Use Apr 2011.pdf
U220-REC-02676 - SUB 015713-070.001 1.04D TESC Inspection WE 04-29-11.pdf
U220-REC-02677 - SUB 310900-175.001 1.04E_H_J Instruments Installaton Data.pdf
U220-REC-02678 - SUB 316617-121.004 1.05C6a-f Slurry Panel Summary Report.pdf
Spreadsheet: 116653d1311969113-determining-the-of-overlap-in-two-date-ranges-excel-example
Sheet: Sheet1

This is what I currnetly have
Start 1 | End 1 | Aging1 | Start 2 | End 2 | Aging 2 | Overlap aging | Overlap %
2011-06-21 00:00:00 | 2011-06-27 00:00:00 | 5 | 2011-05-27 00:00:00 | 2011-06-26 00:00:00 | 21
2011-06-21 00:00:00 | 2011-06-30 00:00:00 | 8 | 2011-05-27 00:00:00 | 2011-06-06 00:00:00 | 7
2011-06-21 00:00:00 | 2011-06-30 00:00:00 | 8 | 2011-05-27 00:00:00 | 2011-07-04 00:00:00 | 25
2011-06-21 00:00:00 | 2011-06-30 00:00:00 | 8 | 2011-07-05 00:00:00 | 2011-07-06 00:00:00 | 2
I need a formula to return the values in yellow.
Start 1 | End 1 | Aging1 | Start 2 | End 2 | Aging 2 | Overlap aging | Overlap %
2011-06-21 00:00:00 | 2011-06-27 00:00:00 | 5 | 2011-05-27 00:00:00 | 2011-06-26 00:00:00 | 21 | -4 | -0.8
2011-06-21 00:00:00 | 2011-06-30 00:00:00 | 8 | 2011-05-27 00:00:00 | 2011-06-06 00:00:00 | 7 | 0 | 0
2011-06-21 00:00:00 | 2011-06-30 00:00:00 | 8 | 2011-05-27 00:00:00 | 2011-07-04 00:00:00 | 25 | -8 | -1
2011-06-21 00:00:00 | 2011-06-30 00:00:00 | 8 | 2011-07-05 00:00:00 | 2011-07-06 00:00:00 | 2 | 0 | 0
Spreadsheet: 00977619-663f-4e0d-b0f6-a46cf6ae4fb7
Sheet: Sheet1

A | Name: |  |  |  |  | [NAME] for COMPLETED Credits  | My Cumulative GPA | My Cumulative # of Credits |  |  | Special Notes:
A- | ID#: |  |  |  |  |  |  |  |  |  |  Some classes may not be offered every year. Check major/departmental website for your 2 or 4 year projected course schedules. Schedules often change, and it is your responsibility to keep your plan up to date.
 | [NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUM QP
B | Fall 20__ |  |  |  |  | Winter 20__ |  |  |  |  |  |  |  |  |  | Summer 20__
B- | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits |  |  | SUM QP/Credits
C+
C
C-
[NAME]
D | Term GPA |  |  |  |  | Term GPA |  |  |  |  | Term GPA |  |  |  |  | Term GPA
D- | Fall  20__ |  |  |  |  | Winter 20__ |  |  |  |  | Spring 20__ |  |  |  |  | Summer 20__
F | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits
R
 | Term GPA |  |  |  |  | Term GPA |  |  |  |  | Term GPA |  |  |  |  | Term GPA
 | Fall 20__ |  |  |  |  | Winter 20__ |  |  |  |  | Spring 20__ |  |  |  |  | Summer 20__
 | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits
 | Term GPA |  |  |  |  | Term GPA |  |  |  |  | Term GPA |  |  |  |  | Term GPA
 | Fall 20__ |  |  |  |  | Winter 20__ |  |  |  |  | Spring 20__ |  |  |  |  | Summer 20__
 | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits | COURSE | CREDITS | GRADE | Quality PTS | QP/Credits
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Credits | Cumulative GPA
 | Term GPA |  |  |  |  | Term GPA |  |  |  |  | Term GPA |  |  |  |  | Term GPA
Spreadsheet: 220295d1363113850-data-in-two-cells-return-a-numeric-value-februrary-summary-updated-v2
Sheet: Summary

 |  |  |  | 2013-03-01 00:00:00
All Tickets for January |  |  | (not including PM tickets)
 | Code | Feb Total | Feb Open | Feb Closed | Prev  Month Closed | Total Closed in Feb | CTE | Factory | Calvin | Cliff | [NAME] | [NAME] | [NAME] | Vincent | [NAME] | [NAME] | [NAME]
Service Required | SR
In Shop Repair | IS
New Equipment | NEI
In Shop FM&ME | ISFM
Calibration Services | CS
Equipment Transfers
PM | PM |  |  |  |  |  | 1