tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 160281d1339024358-how-to-combine-if-statement-in-offset-function-please-help-timesheet-upload-1
Sheet: Master Timesheet

Weekly Time Allocation
2012-05-01 00:00:00
Time | Name |  | Monday |  | Name |  | Tuesday |  | Name |  | Wednesday |  | Name |  | Thursday |  | Name |  | Friday
 |  |  | 5 |  |  |  | 6 |  |  |  | 7 |  |  |  | 8 |  |  |  | 9
6:00 - 6:15 | A.K |  |  |  | T.G
6:15 - 6:30 | M.C
6:30 - 6:45 | T.G
6:45 - 7:00
7:00 - 7:15
7:15 - 7:30
7:30 - 7:45
7:45 - 8:00
8:00 - 8:15
8:15 - 8:30
8:30 - 8:45
8:45 - 9:00
9:00 - 9:15
9:15 - 9:30
9:30 - 9:45
9:45 - 10:00
10:00 - 10:15
10:15 - 10:30
10:30 - 10:45
10:45 - 11:00
11:00 - 11:15
11:15 - 11:30
11:30 -11:45
11:45 - 12:00
12:00 - 12:15
12:15-  12:30
12:30 - 12:45
12:45 - 1:00
1:00 - 1:15
1:15 - 1:30
1:30 - 1:45
1:45 - 2:00
2:00 - 2:15
2:15 - 2:30
2:30 - 2:45
2:45 - 3:00
3:00 - 3:15
3:15 - 3:30
3:30 - 3:45
3:45 - 4:00
4:00 - 4:15
4:15 - 4:30
4:30 - 4:45
4:45 - 5:00
5:00 - 5:15
5:15 - 5:30
5:30 - 5:45
5:45 - 6:00
6:00 - 6:15
6:15 - 6:30
6:30 - 6:45
6:45 - 7:00
7:00 - 7:15
7:15 - 7:30
Spreadsheet: 44319d1242921759-ifsum-problem-master
Sheet: Expenses Detail

Day/Date | Receipt No. | Supplier | Product | Cost (inc vat) | Cost Group
 |  |  |  |  |  | ARE YOUR EXPENSES CORRECT?
 |  |  |  |  |  |  | Wages (1) |  | Drinks Cost (4)
 |  |  |  |  |  |  | [NAME] (2) |  | Sundry Costs (5)
 |  |  |  |  |  |  | Advertising/PR (3) |  | Food Purchases (6)
Spreadsheet: 684612d1593459233-google-sheets-how-to-have-values-appear-from-one-tab-but-skip-rows-as-needed-sample-performance-1-
Sheet: Stats

 |  | Employee 1 | Daily Output | goal % | Comment |  | Employee 2 | Daily Output | goal % | Comment |  | Employee 3 | Daily Output | goal % | Comment |  | Employee 4 | Daily Output | goal % | Comment |  | Employee 5 | Daily Output | goal % | Comment |  | Employee 6 | Daily Output | goal % | Comment
 | 2020-06-29 00:00:00 | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
 |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
 |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
 |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
 |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
 | Weekly Average | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
Spreadsheet: 35979d1233710756-how-can-i-auto-sort-book1
Sheet: Sheet1

 | List udated as of
Employee |  | Total Hours
[NAME] | 1
[NAME] | 2
[NAME] | 3
[NAME] | 4 | 0
[NAME] | 5 | 0
[NAME] | 6 | 0
[NAME] | 7 | 0
[NAME] | 8 | 0
[NAME] | 9 | 0
Spreadsheet: 876988d1723691724-inventory-status-report-stock-report
Sheet: Inventory Report

Attempted Solution |  |  |  |  |  |  |  |  | Desired Solution
Date | Refernce | Ordered | Unit Price | Purchases | Sales | Actual Balance |  |  | Date | Refernce | Ordered | Unit Price | Purchases | Sales | Computer Balance | Actual Balance | [NAME]
2024-08-04 00:00:00 | B/FWD | 6825 | 1.677 | 0 |  |  |  |  | 2024-08-04 00:00:00 | B/FWD |  | 1.677 |  |  | 6825
2024-08-04 00:00:00 | 73125 |  | 1.72 |  | 2357.9 | 4400 |  |  | 2024-08-04 00:00:00 | 73125 |  | 1.72 |  | 2357.9 |  | 4400
2024-08-05 00:00:00 | FHIL00001286 | 16600 | 1.677 | 16613.5 |  |  |  |  | 2024-08-05 00:00:00 | FHIL00001286 | 16600 | 1.677 | 16613.5
2024-08-05 00:00:00 | 73126 |  | 1.72 |  | 1900.7 | 19182 |  |  | 2024-08-05 00:00:00 | 73126 |  | 1.72 |  | 1900.7 |  | 19182
2024-08-06 00:00:00 | 73128 |  | 1.72 |  | 2730.6 | 16500 |  |  | 2024-08-06 00:00:00 | 73128 |  | 1.72 |  | 2730.6 |  | 16500
2024-08-07 00:00:00 | 73129 |  | 1.72 |  | 2619.82 | 13830 |  |  | 2024-08-07 00:00:00 | 73129 |  | 1.72 |  | 2619.82 |  | 13830
2024-08-08 00:00:00 | 73132 |  | 1.72 |  | 3254.01 | 10580 |  |  | 2024-08-08 00:00:00 | 73132 |  | 1.72 |  | 3254.01 |  | 10580
2024-08-09 00:00:00 | 73133 |  | 1.72 |  | 2243.69 | 8101.78 |  |  | 2024-08-09 00:00:00 | 73133 |  | 1.72 |  | 2243.69 |  | 8101.78
2024-08-10 00:00:00 | 73134 |  | 1.72 |  | 2039.13 | 6210.65 |  |  | 2024-08-10 00:00:00 | 73134 |  | 1.72 |  | 2039.13 |  | 6210.65
2024-08-11 00:00:00 | FHIL00001296 | 16600 | 1.677 | 16619.5 |  |  |  |  | 2024-08-11 00:00:00 | FHIL00001296 | 16600 | 1.677 | 16619.5
2024-08-11 00:00:00 | 73135 |  | 1.72 |  | 1956.53 | 20855 |  |  | 2024-08-11 00:00:00 | 73135 |  | 1.72 |  | 1956.53 |  | 20855
2024-08-12 00:00:00 | 73136 |  | 1.72 |  | 2245.38 | 18790.24 |  |  | 2024-08-12 00:00:00 | 73136 |  | 1.72 |  | 2245.38 |  | 18790.24
2024-08-13 00:00:00 | 73137 |  | 1.72 |  | 1945.83 | 16754.41 |  |  | 2024-08-13 00:00:00 | 73137 |  | 1.72 |  | 1945.83 |  | 16754.41
2024-08-14 00:00:00 | FHIL00001285 | 10600 | 1.647 | 10599.8 |  |  |  |  | 2024-08-14 00:00:00 | FHIL00001285 | 10600 | 1.647 | 10599.8
2024-08-14 00:00:00 | 73138 |  | 1.72 |  | 1973.51 | 14690.9 |  |  | 2024-08-14 00:00:00 | 73138 |  | 1.72 |  | 1973.51 |  | 14690.9
Spreadsheet: 0eccce08-65a5-4184-8340-39b2d9c6aaff
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | DNA Assessment Project ID (For AMC Use Only): | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
 | ver1.1_070909 non-OHSUacad
 | Required Sample Information for DNA Assessment
 | 1 | Sample names: names must be unique; [NAME] of 6 alpha-numeric characters preferred; following characters not allowed (~ ! @ # $ % ^ & * ( ) - _ + = { } [ ] | \ ; : ' " < > , . ? /)
 | 2 | Estimated DNA concentration
 | 3 | Sample volumes
 | 4 | DNA type
 | 5 | Species
 | 6 | Sample source (tissue or culture type)
 |  | DNA samples must be submitted in 1.5ml tubes and named following the criteria listed above.
 | Investigator Information
 |  | Date (MM/DD/YY): |  |  |  |  |  |  | Principal Investigator:
 |  | Investigator Responsible for Samples: |  |  |  |  |  |  | Associate Investigator:
 |  | Phone Number: |  |  |  |  |  |  | Phone number:
 |  | E-mail: |  |  |  |  |  |  | E-mail:
 | Charge Information
 |  | $9.20 per sample, plus a $40.25  fee for each bioanalyzer chip processed
 |  | Principle Investigator: |  |  |  |  |  |  | Billing Address Line 1:
 |  |  |  | E-mail: |  |  |  |  |  |  | Billing Address Line 2:
 |  | PO Number: |  |  |  |  |  |  | City:
 |  | PO Source: |  |  |  |  |  |  | State:
 |  | Expiration Date: |  |  |  |  |  |  | Zip Code:
 | Sample Information
 |  |  | Number of Samples: |  |  |  |  | DNA Resuspension Buffer: |  |  |  |  | Downstream Application(s):
 | Sample Name |  | Conc. (ug/ul) | Volume (ul) | Species |  | DNA Isolation Method |  | DNA Type |  | Tissue Type / Name of Cell Line |  |  | Sample Source |  | Sample State (prior to DNA isolation) |  | Expected DNA Size(s)
 | Additional Sample Information:
 | Post Processing Options
 | Pending the outcome of the DNA assessment analysis, samples will be submitted to the following core labs:
 | OHSU GMSR for microarray profiling :
 | OHSU MPSSR for sequencing analysis :
 | Other (please comment) :
 |  | [NAME] here if you wish to collect samples after DNA assessment is completed.
 |  | After receiving data, please contact the AMC to schedule a pick up time.  It is helpful if you can plan to bring a styrofoam box containing dry ice
 |  |  |  | AMC will discard samples if no Post Processing Option is marked
Spreadsheet: 93239d1292857253-working-date-calculator-updated-calc
Sheet: Sheet1

 |  | [NAME] estimated start date of works |  |  |  | Sunday | 2011-04-03 00:00:00
 |  |  |  |  |  |  | 2011-01-03 00:00:00
 |  | And
 |  | Duration in working days(Mon to [NAME]) |  |  |  | 20 |  |  | End date of works |  | Thursday | 2011-05-05 00:00:00
 |  | Or
 |  | Duration in calendar days(Mon to Sun) |  |  |  | 11 |  |  | End date of works |  | Wednesday | 2011-04-13 00:00:00
 |  | Initial Notice must be served no later than |  |  |  | Saturday
 |  |  |  |  |  | Monday | 2011-01-03 00:00:00
 |  | The Major notice, 15 day validity period expires on: |  |  |  | Saturday |  |  | ***This does not apply to Work Permits***.
 |  | 10 Confirmation must be served on |  |  |  | Saturday |  |  | to achieve your planned start date.
 |  | The 5 day validity period on the original start date ends on: |  |  |  |  |  |  | ***This does not apply to Work Permits***.
 |  | 10 Confirmation can be served up until |  |  |  |  |  |  | after this date, the notice expires. ***Does not apply to Work Permits***.
Spreadsheet: 292630d1390699436-automated-posting-from-journals-to-ledgeraccounts-accounts
Sheet: RetainedEarnings

3-001 Retained earnings
Date | Ref. | Details | Debit |  | Date | Ref. | Details | Credit
2008-12-01 00:00:00 | 2-501 | Loan - J Mugot | 3700
 | 2-001 | National Bank - Visa | 333.36
 | 1-001 | National Bank - Cheque | 967.17
 |  | Total | 5000.53 |  |  |  | Total | 0
 |  | Balance | 5000.53 |  |  |  | Balance
Spreadsheet: 89394d1289209029-make-dropdown-list-without-repeated-value-copy-of-dropdown-no-repeat
Sheet: Sheet1

A1 |  |  |  |  |  |  |  | I want to take dropdown from list, must not type manually because there are many value in my table
A1 |  |  |  |  |  |  | [NAME] | Dropdown Should be Like this | Not like this that have value repeated
A2 |  |  |  |  |  |  |  | A1 | A1
A2 |  |  |  |  |  |  |  | A2 | B2
A3 |  |  |  |  |  |  |  | A3 | A3
A3 |  |  |  |  |  |  |  | A4 | B1
A4 |  |  |  |  |  |  |  | B1 | B1
A4 |  |  |  |  |  |  |  | B2 | B4
B1 |  |  |  |  |  |  |  | B3 | B3
B1 |  |  |  |  |  |  |  | B4 | A4
B2 |  |  |  |  |  |  |  |  | A1
B2 |  |  |  |  |  |  |  |  | B4
B3 |  |  |  |  |  |  |  |  | A3
B3 |  |  |  |  |  |  |  |  | B3
B4 |  |  |  |  |  |  |  |  | B2
B4 |  |  |  |  |  |  |  |  | A2
 |  |  |  |  |  |  |  |  | A4
 |  |  |  |  |  |  |  |  | A2
Spreadsheet: 5e8cbec6-f955-473e-9273-6aac299edb45
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
PLAB | Test | PLAB | Platelet Antibody, Serum | Platelet Ab, S | Enzyme-Linked Immunoabsorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 1.5 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1.5 mL | 0.5 mL | Hemolysis	Mild reject; Gross reject Thawing	Cold OK; Warm OK Lipemia	NA Icterus	NA Other	Serum gel tube | An interpretive report will be provided. | Monday through Friday; 7:30 a,m.-5:00 p.m. Saturday; 10:00 a.m.-6:00 p.m | 2 days | 4 days | 1 | 86022 |  |  |  |  | Rochester
PLAB | [NAME] | SRED | Serum Red |  |  |  | Frozen | 365 days
PLAB | Result | PL_AB | Platelet Ab, S | Platelet Ab, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24375-8
PLAB | Result | CMT34 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8
Spreadsheet: 455102d1460108434-sumifs-not-work-with-two-critirial-sumifs
Sheet: Sheet1

Consolidate Manual |  |  |  |  |  |  | Source
Item 1 | Item 2 | Apr | May | June |  |  | Item 1 | Apr | May | June
1AC0313A00 | 71X012 | 200 | 200 | 200 |  |  | 1AC0313A00 | 100 | 100 | 100
1AC0387A00 | 208-875-001 | 200 | 200 | 200 |  |  | 1AC0387A00 | 100 | 100 | 100
1AC0391A00 | 25253 | 200 | 200 | 200 |  |  | 1AC0391A00 | 100 | 100 | 100
1AC0393A00 | 208-874-001 | 200 | 200 | 200 |  |  | 1AC0393A00 | 100 | 100 | 100
1AC0410A00 | 208-976-001 | 200 | 200 | 200 |  |  | 1AC0410A00 | 100 | 100 | 100
1AC0413A00 | 209-014-001 | 200 | 200 | 200 |  |  | 1AC0413A00 | 100 | 100 | 100
1ACGG002 | 951-00053-00 | 200 | 200 | 200 |  |  | 71X012 | 100 | 100 | 100
 |  |  |  |  |  |  | 208-875-001 | 100 | 100 | 100
 |  |  |  |  |  |  | 25253 | 100 | 100 | 100
Consolidate with Fomular |  |  |  |  |  |  | 208-874-001 | 100 | 100 | 100
Item 1 | Item 2 | Apr | May | June |  |  | 208-976-001 | 100 | 100 | 100
1AC0313A00 | 71X012 |  |  |  |  |  | 209-014-001 | 100 | 100 | 100
1AC0387A00 | 208-875-001 |  |  |  |  |  | 1ACGG002 | 100 | 100 | 100
1AC0391A00 | 25253 |  |  |  |  |  | 951-00053-00 | 100 | 100 | 100
1AC0393A00 | 208-874-001
1AC0410A00 | 208-976-001
1AC0413A00 | 209-014-001
1ACGG002 | 951-00053-00
Spreadsheet: 861653d1709545587-productivity-calculation-prodctivity-calculation
Sheet: Sheet1

 |  |  | India | UAE | Saudi Arabia | South Africa | Ghana | Total
 |  | Budget 2024 - Productivity
 |  | Budget 2024 - FTE | 162.9999999999952 | 138.9999999999949 | 93 | 105 | 184
 |  | Budget 2024 - Volume '000 | 1558.953994887098 | 1151.893697106968 | 629.590304046388 | 344.6389352155448 | 552.0240658107899
 |  | Forecast 2024 - Volume '000 | 1413.494920269945 | 1082.598602596717 | 593.897626976175 | 288.7416296118869 | 477.8962568906358
 |  | Forecast 2024 - Productivity | 9564.134937957939 | 8287.005015158345 | 6769.78821555256 | 3282.275573481379 | 3000.130792449945 | 6194.592100974927
 |  | Forecast 2024 - FTE
 |  | FTE Reduction asper Forecast 2024
 |  |  |  |  |  | Country Total
Spreadsheet: 33481d1229928221-to-retain-the-value-of-previous-record-previous-record
Sheet: Sheet1

 | Summary | 146 | 72.4 | 126.8 | 0.8684931506849315 |  | Last month percentage
 | Descriptions | contract hours | JTD hours | work progress | percentage |  | 0.8684931506849315
 |  | 15 | 1.15 | 15 | 1
 |  | 11 | 7.75 | 11 | 1 |  | I want to get the record of last month percentage so that I can compare after I update the job progress
 |  | 12 | 5 | 12 | 1 |  | For e.g. the percentage for  now is 86.85. If I update my sheet, the % will changed.
 |  | 11 | 3 | 11 | 1 |  | Can I retain the 86.85% as a record for comparison?
 |  | 23 | 15.5 | 23 | 1
 |  | 8 | 6 | 8 | 1
 |  | 19 | 13 | 19 | 1
 |  | 23 | 16.5 | 23 | 1
 |  | 12 | 4.5 | 4.800000000000001 | 0.4
 |  | 8 | 0 | 0 | 0
 |  | 4 | 0 | 0 | 0
 |  |  |  | 0
Back to Index
Spreadsheet: 105165d1302614874-counting-unique-values-with-conditions-frequencyexample
Sheet: Values

 | Total Customers | 147 | Today | 2011-04-12 00:00:00
Back order Values | Value | Number of Customers | Date Range |  |  | Time covered
Over 6 months | 16865.08 | 129 | 2010-10-12 00:00:00 | 2010-01-13 00:00:00 |  | 8 months
12 - 26 Weeks | 2018.129999999999 | 5 | 2011-01-18 00:00:00 | 2010-10-12 00:00:00 |  | 14 weeks
8 -12 weeks | 2450.659999999998 | 2 | 2011-02-15 00:00:00 | 2011-01-18 00:00:00 |  | 4 weeks
0 - 12 Weeks | 5698.07 | 2 | 2011-04-12 00:00:00 | 2011-01-18 00:00:00 |  | 12 weeks
Total | 27031.94
Spreadsheet: eric_saibi__9960__110801
Sheet: Diablo Canyon 01

Owner Name | Pacific Gas and Electric Company
Station Name | Diablo Canyon Nuclear Power Station
Unit Name | [NAME]
NERC Region | WSCC
State | CA
Fuel Type | Nuclear
Capacity | 1,137 MW
Start Date | 2001-11-07 00:00:00
End Date | 2001-11-11 00:00:00
Comments | Due to a vibration in the unit, which caused a crack.  They are doing tunnel scraping, bracing, and welding.
SIC | 4911
Plant ID | 1016043
Unit ID | 1004942
Outage ID | 18832
Spreadsheet: 186440d1350042663-how-to-get-a-negative-time-result-without-using-additional-cell-data-test-time
Sheet: Sheet1

 | Using cell references in columns F and H allows column G to calculate correctly
 |  |  | DAILY HOURS | WEEKLY HOURS | TOTAL HOURS | CREDIT/ (DEBIT) | Extra data
 |  | Mon | 0:00:00 | 0:00:00 | 4 days, 16:50:00.001000 |  | 4 days, 15:05:00
 |  | Tue | 8:00:00 | 8:00:00 | 5 days, 0:50:00.001000 |  | 4 days, 19:45:00
 |  | Wed | 7:49:59.999000 | 15:49:59.999000 | 5 days, 8:40:00 |  | 5 days, 13:15:00
 |  | Thu | 8:00:00 | 23:49:59.999000 | 5 days, 16:40:00 |  | 5 days, 20:40:00
 |  | Fri | 7:30:00 | 1 day, 7:19:59.999000 | 6 days, 0:10:00 |  | 6 days, 4:00:00
 | Attempting to incorporate the subtracting value into the formula doesn't work when the result is negative
 |  |  | DAILY HOURS | WEEKLY HOURS | TOTAL HOURS | CREDIT/ (DEBIT) |  | Unused
 |  | Mon | 0:00:00 | 0:00:00 | 4 days, 16:50:00.001000 |  |  | 4 days, 15:05:00
 |  | Tue | 8:00:00 | 8:00:00 | 5 days, 0:50:00.001000 |  |  | 4 days, 19:45:00
 |  | Wed | 7:49:59.999000 | 15:49:59.999000 | 5 days, 8:40:00 |  |  | 5 days, 13:15:00
 |  | Thu | 8:00:00 | 23:49:59.999000 | 5 days, 16:40:00 |  |  | 5 days, 20:40:00
 |  | Fri | 7:30:00 | 1 day, 7:19:59.999000 | 6 days, 0:10:00 |  |  | 6 days, 4:00:00
Spreadsheet: 291174d1390209089-locating-a-row-in-a-table-of-data-based-on-specified-parameters-locating-a-row-in-a-table-of-data-based-on-specified-parameters
Sheet: Sheet1

 |  |  |  | Interested in 2 formulas:
 |  |  |  | (1) Looking only at the dates in column C, a formula that tells me in which row the first or second or nth event occurs regardless of who responsible
 |  |  |  | event number | 3 | row
 |  |  |  | (2) Looking at who is responsible for the event [Column B], a formula for identifying the first or second or nth event that is attributable to person A
 |  |  |  | person | A | event number | 3 | date |  | <- ARRAY FORMULA !!!
 | RESPONSIBLE PERSON? | DATE OF EVENT?
 | A | 2014-02-01 00:00:00
 | A | 2014-02-17 00:00:00
 | B | 2014-02-18 00:00:00
 | C | 2014-02-21 00:00:00
 | A | 2014-02-27 00:00:00
 | B | 2014-03-02 00:00:00
 | B | 2014-03-03 00:00:00
 | C | 2014-03-07 00:00:00
 | A | 2014-03-09 00:00:00
 | B | 2014-03-11 00:00:00
 | C | 2014-03-12 00:00:00
 | B | 2014-03-19 00:00:00
 | A | 2014-03-21 00:00:00
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: SFR Conv Refi No App

Subject | Start Date | All day event | Reminder on/off | Meeting Organizer | Categories | Description | Location
Sign Disclosures |  | True | False | Team Rosa | Sign Disclosures
[NAME] |  | True | False | Team Rosa | [NAME]
Processing Review |  | True | False | Team Rosa | Processing Review
Submit to Underwriting |  | True | False | Team Rosa | Submit to Underwriting
Final Approval |  | True | False | Team Rosa | Final Approval
CD |  | True | False | Team Rosa | CD
Docs Out |  | True | False | Team Rosa | Docs Out
Signing |  | True | False | Team Rosa | Signing
Close Date |  | True | False | Team Rosa | Close Date
Spreadsheet: 97905d1297014221-find-highest-number-only-if-two-names-matched-in-columns-tabletennisstats2
Sheet: OVERALL STATS

 | Liverpool Table Tennis League (LiTTLe)
 | LATEST RESULTS
 |  |  |  |  |  | vs |  | vs |  | vs |  | vs
 | PLAYER | GP | W | L | PCT | W | L | W | L | W | L | W | L |  |  |  |  | `
 | [NAME] |  |  |  |  | --- | ---
 | [NAME] |  |  |  |  |  |  | --- | ---
 | Sheldon |  |  |  |  |  |  |  |  | --- | ---
 | Al |  |  |  |  |  |  |  |  |  |  | --- | ---
 | OVERALL STANDINGS
 | PLAYER | GP | W | L | PCT | PF | PA | PTS DIFF | TOT PTS | PFPG | PPG IN LOSS | % OF GMS OT | OT W | OT L | WIN% IN OT | HIGH SCORE | LOW SCORE | BEST MGN | WORST MGN
 | [NAME]
 | [NAME]
 | Sheldon
 | Al
 | HEAD-TO-HEAD STATS
 |  | VS:
 | PLAYER | GP | W | L | PCT | PF | PA | PTS DIFF | TOT PTS | PFPG | PPG IN LOSS | % OF GMS OT | OT W | OT L | WIN% IN OT
 | Al
 | Sheldon
 | [NAME]
 |  | VS:
 | PLAYER | GP | W | L | PCT | PF | PA | PTS DIFF | TOT PTS | PFPG | PPG IN LOSS | % OF GMS OT | OT W | OT L | WIN% IN OT
 | Al
 | Sheldon
 | [NAME]
 |  | VS:
 | PLAYER | GP | W | L | PCT. | PF | PA | PTS DIFF | TOT PTS | PFPG | PPG IN LOSS | % OF GMS OT | OT W | OT L | WIN% IN OT
 | Al
 | [NAME]
 | [NAME]
 |  | VS:
 | PLAYER | GP | W | L | PCT. | PF | PA | PTS DIFF | TOT PTS | PFPG | PPG IN LOSS | % OF GMS OT | OT W | OT L | WIN% IN OT
 | Sheldon
 | [NAME]
 | [NAME]
 | "This ain't ping pong--it's table tennis."
Spreadsheet: 108679d1305694457-dataset-combination-dates-streets-routes-example_forum
Sheet: Sheet1

Table 1 | Route | Start Date | End Date | Vehicles per day
 | Route1 | 2012-01-01 00:00:00 | 2012-01-04 00:00:00 | 10
 | Route2 | 2012-01-02 00:00:00 | 2012-01-05 00:00:00 | 20
 | Route3 | 2012-01-01 00:00:00 | 2012-01-06 00:00:00 | 30
 | Route4 | 2012-01-03 00:00:00 | 2012-01-05 00:00:00 | 40
 | Route5 | 2012-01-04 00:00:00 | 2012-01-07 00:00:00 | 50
Table2 | Street | Route
 | Street1 | Route1
 | Street2 | Route1
 | Street3 | Route1
 | Street1 | Route2
 | Street2 | Route2
 | Street1 | Route3
 | Street3 | Route3
 | Street1 | Route4
 | Street2 | Route4
 | Street1 | Route5
Table3 | Output
 | Date | Street1 | Street2 | Street3
 | 2012-01-01 00:00:00 |  | 10
 |  |  |  | 30
 |  |  |  | 30
 |  | 50
Spreadsheet: 044751e8-5333-4f09-9e42-900f86bc093c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
POWER SOURCE
240VAC Mains/+2200W Generator |  |  |  |  |  | Fixed 240VAC Mains
Lead : 16A Fused Main Plug to EURO3-PIN |  |  |  |  |  |  | or
 |  |  |  |  |  | Portable Field Power Source
Pb, [NAME]
Lead : 60A Croc Clip (100A better?) to EURO3-PIN
4 x FEMALE Euro 3PIN connector (90 degree elbow) |  |  |  |  |  |  | F.3PIN
1 x MALE Euro 3PIN Chassis |  |  |  |  |  |  | M.3PIN CHASSIS
 |  |  |  |  | F.3PIN |  |  |  |  | F.3PIN
PSU's (POWER SUPPLY UNITS) |  |  | IBM X366 1300W Server PSU  12V/106.5A |  |  |  |  | IBM X366 1300W Server PSU  12V/106.5A
Check for Grounding and Always On modifications |  |  | PSU1 | Positive wired to PSU2 to achieve 24V |  |  |  | PSU2 | Earth Ground Pin Removed
 |  |  | Wired serially to output 24V/2600W/106.5A.  Plus single 12V supply from PSU1 to AUX output/3PIN XLR
 |  |  |  | PSU2 | PSU2 | PSU1 |  |  | PSU2 | PSU2 | PSU1
 |  |  |  | 24V/106.5A | 24V/106.5A | 12V/106.5A |  |  | 24V/106.5A | 24V/106.5A | 12V/106.5A
[NAME]
Charger's : 2 x 45A |  |  |  | 45A | 45A | 16A
Aux Output : 1 x 16A
Mountable fuse board for 3 fuses.
[NAME] AND SWITCHES
EC5 Male already supplied with charger. |  |  | [NAME] |  |  |  | [NAME] |  |  | 5A |  | 10A
2 x EC5 Female also required |  |  | [NAME] |  |  |  | [NAME] |  |  | SWITCH |  | SWITCH
5A switch for 3PIN XLR light
10A switch for 4mm
CHARGERS & OTHER OUTPUT's
2 x [NAME] |  |  | PowerLab 6 |  |  |  | PowerLab 6
3PIN XLR FEM Mountable Chassis |  |  | 24VDC/40A/1000W |  |  |  | 24VDC/40A/1000W |  |  | 3PIN XLR |  | AUX OUTPUT
4mm Banana FEM Connection Box |  |  |  |  |  |  |  |  |  | F.Chassis |  | 4mm [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | F.Chassis
MPA's (MULTI-PARRALLEL ADAPTOR)
2 x Revoletrix MPA's |  | MPA Adaptor Board |  |  |  | MPA Adaptor Board
18 x 5mm Bullet Connectors |  | 6 x 1S to 6S adaptor board |  |  |  | 6 x 1S to 6S adaptor board
10 M/F EC5
10M/F EC3
WIRING AND OTHER ACCESSORIES
Flight Case
AirVents
[NAME]
Fixings
10AWG Wire, 140A/6.0mm2
12AWG Wire, 100A/4.0mm2
14AWG Wire, 70A/2.5mm2 (Got)
32A 3 Core Flexi Cable (For mains supply)