tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 126317d1319633244-if-value-of-x-passes-criteria-then-copy-y-test
Sheet: Sheet1

Name | Gender | FSM | SEN Status | EAL | EN AT2 Reading KS1 | Reading Assessment LW [NAME] | [NAME] | LW Reading LW [NAME] | [NAME] | Pupil Progress~5
Child 1 |  |  |  |  |  |  |  | 3a
Child 2 |  |  |  |  |  |  |  | 3a
Child 3 |  |  |  |  |  |  |  | 3a
Child 4 |  |  |  |  |  |  |  | 3b
Child 5 |  |  |  |  |  |  |  | 3b
Child 6 |  |  |  |  |  |  |  | 3b
Child 7 |  |  |  |  |  |  |  | 3c
Child 8 |  |  |  |  |  |  |  | 3c
Child 9 |  |  |  |  |  |  |  | 3c
Child 10 |  |  |  |  |  |  |  | 2a
Child 11 |  |  |  |  |  |  |  | 2a
Child 12 |  |  |  |  |  |  |  | 2a
Child 13 |  |  |  |  |  |  |  | 2a
Child 14 |  |  |  |  |  |  |  | 2a
Child 15 |  |  |  |  |  |  |  | 2a
Child 16 |  |  |  |  |  |  |  | 2b
Child 17 |  |  |  |  |  |  |  | 2b
Child 18 |  |  |  |  |  |  |  | 2b
Child 19 |  |  |  |  |  |  |  | 2b
Child 20 |  |  |  |  |  |  |  | 2c
Child 21 |  |  |  |  |  |  |  | 2c
Child 22 |  |  |  |  |  |  |  | 2c
Child 23 |  |  |  |  |  |  |  | 2c
Child 24 |  |  |  |  |  |  |  | 2c
Child 25 |  |  |  |  |  |  |  | 2c
Child 26 |  |  |  |  |  |  |  | 2c
Child 27 |  |  |  |  |  |  |  | 1a
Child 28 |  |  |  |  |  |  |  | 1a
Child 29 |  |  |  |  |  |  |  | 1a
Child 30 |  |  |  |  |  |  |  | 1a
Spreadsheet: 882012d1730272168-transform-data-from-one-sheet-to-other-book2-1-
Sheet: PQ

 |  | Attribute | Product 1 | Product 2
Salesman-01 |  | Salesman-01 | 14 | 35
Salesman-02 |  | Salesman-03 | 18 | 28
Salesman-03 |  | [NAME] | 18 | 28
[NAME] |  | Salesman-07 | 15 | 41
[NAME] |  | Salesman-08 | 11 | 37
Salesman-06 |  | Salesman-12 | 9 | 35
Salesman-07 |  | Salesman-17 | 16 | 36
Salesman-08 |  | Salesman-20 | 20 | 32
Salesman-09 |  | Salesman-21 | 10 | 23
Salesman-10 |  | Salesman-25 | 16 | 32
Salesman-11
Salesman-12
Salesman-13
Salesman-14
Salesman-15
Salesman-16
Salesman-17
Salesman-18
Salesman-19
Salesman-20
Salesman-21
Salesman-22
Salesman-23
Salesman-24
Salesman-25
Salesman-26
Spreadsheet: 477094d1472137136-how-to-get-data-based-on-multiple-criteria-without-duplicating-the-data-oeldere-477085d1472133989-how-to-get-data-based-o-multiple-criteria-without-duplicating-the-d
Sheet: Sheet2

Outlet: |  | ABC Shop |  |  |  |  |  | Date: | 2016-01-01 00:00:00 | to | 2016-01-03 00:00:00
Sampling Costing Summary Report
No. | Brand Name | Products |  |  | Cost Price | Samples Used (Qty) |  |  | Total Pack Used | Total Pack Sold | Total Cost | %
1 |  | Calamari Rings |  |  | 4
2
3
4
5
6
7
8
9
10
Total:
* (Percentage must less than 15%) |  |  |  |  |  |  |  |  | Results:
Operation Cost
No. | Operation Cost Particulars |  |  |  | Amount |  | Remarks
1 | Cooking Oil |  |  |  | 1
2 | French Fries Holder / Cup |  |  |  | 5
3 | [NAME]
4 | [NAME]
5 | Gloves
6 | [NAME]
Sub-Total:
Expenses Cost
No. | Expenses Cost Particulars |  |  |  | Amount |  | Remarks
1 | Accomodation
2 | Parking
3 | Toll
4 | Petrol
5 | [NAME]
6 | Sampling Cost
Sub-Total:
Grand Total:
Spreadsheet: 664986d1582854253-cost-based-on-day-of-week-green-forum
Sheet: Summary

 | Month | Total GC | Total Cost
 | July
 | August
 | September
 | October
 | November
 | December
 | January
 | February
 | March
 | April
 | May
 | June
 | Total
Spreadsheet: 821619d1678819595-count-cells-containing-text-that-overlaps-the-search-text-example_count_formula
Sheet: Sheet1

 | BusUnit Selection |  | BusUnits |  |  |  |  |  |  | Should be:
0 |  |  | Legacy |  |  |  | [NAME] |  |  | 6
1 | [NAME] |  | Legacy [NAME], Legacy |  |  |  | Legacy Good Co |  |  | 14
2 | Legacy |  | [NAME] |  |  |  | Legacy |  |  | 23
3 | Legacy Good Co |  | Legacy
 |  |  | Legacy, [NAME]
 |  |  | Legacy
 |  |  | Legacy Good Co
 |  |  | Legacy [NAME], Legacy
 |  |  | Legacy
 |  |  | Legacy
 |  |  | Legacy, [NAME]
 |  |  | [NAME]
 |  |  | [NAME], Legacy
 |  |  | Legacy, [NAME]
 |  |  | Legacy [NAME], Legacy
 |  |  | [NAME]
 |  |  | Legacy
 |  |  | Legacy, [NAME]
 |  |  | Legacy, [NAME]
 |  |  | [NAME]
 |  |  | Legacy, [NAME]
 |  |  | Legacy, [NAME]
 |  |  | Legacy [NAME], Legacy
 |  |  | Legacy Good Co
 |  |  | Legacy, [NAME]
 |  |  | Legacy [NAME], Legacy
 |  |  | [NAME]
 |  |  | Legacy
 |  |  | Legacy
 |  |  | Legacy [NAME], Legacy
Spreadsheet: 809668d1671209437-finding-a-row-and-column-match-with-a-list-and-return-a-specific-value-attendanceregister-4-
Sheet: Feuil1

 |  | Classes | Mr. [NAME] | Ms. [NAME] | Ms. [NAME] | Mr. [NAME] |  | Exemptions |  |  |  | Exemptions
First name | Last name |  | English | History | Arts | Geography |  | First name | Last name | Classes |  | First name | Last name | Classes
 |  | Dates | 2022-10-01 00:00:00 | 2022-11-03 00:00:00 | 2022-11-04 00:00:00 | 2022-12-16 00:00:00 |  | [NAME] | Smith | English |  |  | Smith | English
[NAME] | Edwards |  | Present | Present | Present |  |  | [NAME] | Linsey | History |  | [NAME] | Linsey | History
[NAME] | Smith |  | Exempted | Present | Present |  |  | Damian | Milly | Arts |  | Damian | Milly | English
[NAME] | Lamar |  | Present | Present | Present |  |  | Damian | Milly | English |  | Damian | Milly | Arts
Adele | Otto |  | Absent | Present | Present |  |  | George | Brinley | Geography
[NAME] | Linsey |  | Present | Exempted | Present |  |  | [NAME] | [NAME] | Geography
Genette | Delroy |  | Present | Present | Present
Damian | Milly |  | Exempted | Present | Exempted
George | Brinley |  | Present | Present | Present
[NAME] | [NAME] |  | Present | Present | Present
Spreadsheet: 159788d1338843035-excel-2007-i-need-a-formula-to-calculate-six-months-at-a-time-from-separate-sheet-tabs-hr-calendar-with-formulas
Sheet: Sep

 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | 1. Absent - EX  2. Absent - UN  3. Bereavement  4. Discipline  5. FMLA  6. Tardy
 |  |  | NOTES:
 |  |  | Type in Employee's Last Name and the Corresponding Number
Spreadsheet: 0549992c-256b-41ba-bc57-9ae8e373d495
Sheet: Sheet1

History | Unnamed: 1
2011-09-30 00:00:00 | 12
2011-10-31 00:00:00 | 23
2011-11-30 00:00:00 | 30
2011-12-31 00:00:00 | 41
2012-01-31 00:00:00 | 76
2012-02-29 00:00:00 | 98
2012-03-31 00:00:00 | 99
2012-04-30 00:00:00 | 101
2012-05-31 00:00:00 | 100
2012-06-30 00:00:00 | 80
2012-07-31 00:00:00 | 84
2012-08-31 00:00:00 | 80
2012-09-30 00:00:00 | 99
2012-10-31 00:00:00 | 103
2012-11-30 00:00:00 | 125
2012-12-31 00:00:00 | 201
2013-01-31 00:00:00 | 242
2013-02-28 00:00:00 | 259
2013-03-31 00:00:00 | 274
2013-04-30 00:00:00 | 273
2013-05-31 00:00:00 | 258
2013-06-30 00:00:00 | 263
2013-07-31 00:00:00 | 255
2013-08-31 00:00:00 | 247
2013-09-30 00:00:00 | 291
Spreadsheet: james_steffes__12771__TX - Enron_10312001PilotStatus_Justification
Sheet: Justification

ESI ID | 814-01 Sent | 814-05 Received | 867-02 Received | 867-04 Received | Initial Meter Read | 867-03 Received | 810 Received
10443720003625902 | 2001-08-29 00:00:00 | 2001-09-07 00:00:00 | 2001-09-09 00:00:00 | 2001-10-09 00:00:00 | 2001-10-05 00:00:00
10443720003630335 | 2001-08-29 00:00:00 | 2001-09-07 00:00:00 | 2001-09-09 00:00:00 | 2001-10-09 00:00:00 | 2001-10-04 00:00:00
10443720006522263 | 2001-08-29 00:00:00 | 2001-09-07 00:00:00 |  | 2001-10-09 00:00:00 | 2001-10-04 00:00:00
10443720006871343 | 2001-08-29 00:00:00 | 2001-09-07 00:00:00 | 2001-09-09 00:00:00 | 2001-10-06 00:00:00 | 2001-09-27 00:00:00
10443720007738300 | 2001-08-29 00:00:00 | 2001-09-07 00:00:00 | 2001-09-09 00:00:00 | 2001-10-09 00:00:00 | 2001-10-05 00:00:00
10443720004233186 | 2001-08-30 00:00:00 | 2001-09-07 00:00:00 | 2001-09-09 00:00:00 | 2001-10-06 00:00:00 | 2001-09-28 00:00:00
10443720005335270 | 2001-08-30 00:00:00 | 2001-09-07 00:00:00 |  |  | 2001-10-08 00:00:00
10443720003001397 | 2001-08-30 00:00:00 | 2001-09-07 00:00:00 |  | 2001-10-06 00:00:00 | 2001-09-24 00:00:00 |  | 2001-10-25 00:00:00
10443720004431331 | 2001-08-30 00:00:00 | 2001-09-07 00:00:00 | 2001-09-09 00:00:00 | 2001-09-14 00:00:00 | 2001-09-12 00:00:00 |  | 2001-10-15 00:00:00
10443720005335301 | 2001-08-30 00:00:00 | 2001-09-07 00:00:00 | 2001-09-09 00:00:00 |  | 2001-10-08 00:00:00
10443720006171483 | 2001-10-11 00:00:00 | 2001-10-15 00:00:00 |  |  | 2001-11-06 00:00:00
10443720003538593 | 2001-10-17 00:00:00 | 2001-10-25 00:00:00 |  |  | 2001-10-29 00:00:00
Spreadsheet: 70431d1271179435-sort-array-depending-on-2nd-column-sort_example-1
Sheet: Folha2

COD | EXP |  |  | SORT
14/0430
14/0431
14/0432 | YES
14/0433
14/0434 | YES
14/0435
14/0436
14/0437
14/0438
14/0439
14/0440
14/0441
14/0442
14/0443
14/0444
14/0445
14/0446
14/0447
14/0448 | YES
14/0449 | YES
13/0450 | YES
15/0451
15/0452
15/0453 | YES
15/0454
15/0455
15/0456
15/0457
15/0458
15/0459
15/0460
15/0461
15/0462
15/0463
15/0464
15/0465
15/0466
15/0467 | YES
15/0468
14/0505 | YES
14/0508
14/0509
15/0510
15/0511
13/0525 | YES
13/0526
13/0527
14/0528 | YES
14/0529 | YES
13/0530 | YES
13/0531 | YES
13/0532 | YES
14/0543
15/0544
14/0546
14/0547 | CANCEL
14/0548
14/0549 | YES
14/0550 | YES
14/0551
14/0553
14/0554
15/0555
15/0556 | CANCEL
14/0557
14/0558
15/0560
15/0561
14/0564 | YES
14/0565
14/0566
13/0568 | YES
14/0569
14/0570
13/0571 | YES
14/0572 | YES
13/0573 | YES
13/0574 | YES
13/0575 | YES
14/0576 | YES
14/0578 | YES
14/0579 | YES
14/0580 | YES
14/0581 | YES
14/0582 | YES
14/0583 | YES
14/0584
14/0585
14/0586
14/0587
14/0594 | YES
14/0595 | YES
14/0596 | YES
14/0599 | YES
14/0600 | YES
14/0601 | YES
14/0607 | YES
14/0608 | YES
14/0609 | YES
Spreadsheet: f1d8ff89-7d0b-48d7-8975-298abe693ebb
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
BILID | Test | BILID | Bilirubin Direct, Serum | [NAME], Direct | Photometric, [NAME] Acid | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Serum gel Acceptable: Red top Submission Container/Tube: Amber vial (Supply T192) [NAME]: 0.5 mL Collection Instructions: Protect specimen from light. Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =12 months: 0.0-0.3 mg/dL  Reference values have not been established for patients who are <12 months of age. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82248 |  |  |  |  | Rochester
BILID | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 24 hours
BILID | Result | BILID | [NAME], Direct | [NAME], Direct | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 1968-7 | Bilirubin.glucuronidated+Bilirubin.albumin bound:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: darron_c_giron__8018__Official Post IDs Version 2
Sheet: Sheet1

User ID:
Password:
Date | 2000-10-16 00:00:00
Comm CD | ALL
Port  CD | Book CD | Comment
G | G | FT - Central
I | G | FT - Central |  | Port | Book | Risk | Post ID | Official Flag | Comm
 |  |  |  | G | G | P | 916648 | 1 | NG
 |  |  |  | G | G | D | 916649 | 1 | NG
 |  |  |  | I | G | I | 916650 | 1 | NG
Spreadsheet: 887796d1738124426-fixed-asset-depreciation-v2-fixed-asset-depreciation-v3
Sheet: v1

 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | Total
 | Net Book Value b/f |  | 0
 | Addition |  | 500000
 | Initial Depreciation | 0.2
 | Annual Depreciation | 0.1
 | Net Book Value c/f
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Net Book Value b/f |  | 0
 | Addition |  |  |  | 300000
 | Initial Depreciation | 0.2
 | Annual Depreciation | 0.1
 | Net Book Value c/f
 | Need a generic formula for Initial Depreciation and Annual Depreciation.
 | Asset bought in Year 1
 | - Initial Depreciation = $500,000 x 20% = $100,000 in Year 1
 | - Annual Depreciation = $500,000 x 10% = $50,000 per year from Year 1 to Year 8
 | Asset bought in Year 3
 | - Initial Depreciation = $300,000 x 20% = $60,000 in Year 3
 | - Annual Depreciation = $300,000 x 10% = $30,000 per year from Year 3 to Year 10
Spreadsheet: 287296d1388750432-sorting-dates-as-i-know-them-book41
Sheet: Sheet1 (2)

 |  | 2.8.1974 Oxfordshire County Council University grant result.
 |  | 18.7.1977 University External Studies Teaching Course.
 |  | 7.2.1977 University External Studies Teaching Course.
 |  | 7.2.1977 6/2 stamp.
 |  | 17.6.1976 [NAME] lost books.
 |  | 15.6.1976 Lukes, [NAME] and Newton-Smith defend their views on “The nature of explanation and the Concept of a Person.
 |  | 11.06.1976 Balliol P.P.E. Tutors Schools dinner.
 |  | 8.6.1976 Notes for a “Thanks to the Balliol Tutors at the end of our studies.
 |  | 8.6.1976 [NAME] asks me to give “Thanks” few words at Schools Dinner.
 |  | 20.5.1976 Party invitation.
 |  | 13.05.1976 [NAME] work?
 |  | 4.5.1976 [NAME] account.
 |  | 1.5.1976 Balliol library asking for their books back.
 |  | 1.5.1976 Notes for Finals examination.
 |  | 29.4.1976 [NAME] note on revision.
 |  | 25.4.1976 Revision time table.
 |  | 23.12.1974 Oxfordshire County Council University grant receipts.
 |  | 28.11.1974 [NAME].
 |  | 16.10.1974 Barclays Bank account.
 |  | 1976 Examination answers paper.
 |  | 1976 Finals papers questions.
 |  | 1976 [NAME] for [NAME] term.
 |  | 1976 Oxford Cyrenians asking for contributions of fifty pence.
 |  | 1976 Oxford Union Society calendar.
 |  | 1976 Oxford Union Treasurer note.
 |  | 1976 University Labour Club internecine strife with dodgy accounts.
 |  | 1974 Balliol JCR
 |  | 23.6.1976 Revision note from [NAME].
Spreadsheet: 137754d1327344963-many-if-statements-ef16_sample
Sheet: Sheet1

 | ABC Motors |  |  |  |  |  | XYZ Motors |  |  |  |  | MotorType | MotorSize | MotorSpeed
 |  |  |  |  |  |  |  |  |  |  |  | ABC | 5 | 1200
Motor Size (HP) | Speed (RPM) |  |  | Cost ($) |  | Motor Size (HP) | Speed (RPM) |  |  | Cost ($) |  | XYZ |  | 1800
 | 1200 | 1800 | 3600 |  |  |  | 1200 | 1800 | 3600 |  |  |  |  | 3600
5 | N/A | 83.7-83.9 | 84.0 | 15 |  | 5 | 89.5-91.0 | N/A | 84.0 | 13
10 | 87.5 | N/A | 85.5-86.5 | 22 |  | 10 | 87.5 | N/A | 90.2-90.5 | 19
15 | 88.5 | 0.876 | 86.5 | 27 |  | 15 | N/A | 87.6 | 86.5 | 28
20 | 89.9-90.2 | 0.902 | 87.5 | 31 |  | 20 | 86.5 | 90.2 | 87.5 | 32
25 | 90.2-90.5 | N/A | 89.5-91.0 | 37 |  | 25 | 89.5-90.2 | N/A | 89.5-91.0 | 35
20 | 89.5-90.2 | 0.902 | 87.5 | 31 |  | 20 | 89.5-90.2 | 0.902 | 87.5 | 38
25 | 90.2-90.5 | N/A | 89.5-91.0 | 37 |  | 25 | 84.0 | N/A | 90.2 | 42
... | ... | ... | ... | ... |  | ... | ... | ... | ... | ...
... | ... | ... | ... | ... |  | ... | ... | ... | ... | ...
... | ... | ... | ... | ... |  | ... | ... | ... | ... | ...
Motor Type |  | ABC |  |  |  |  |  |  |  |  |  |  | 95
Motor Size |  | 5
Motor Speed |  | 1800
Efficiency (%)
Cost ($)
Spreadsheet: 141175d1329140461-vlookup-trying-to-add-up-all-values-of-a-duplicate-entry-example
Sheet: Sheet1

 |  | PO Number | PO Qty | Qty Received |  |  | PO Number | Number Received
 |  | 120431 | 100 |  |  |  | 120431 | 100
 |  | 120432 | 50 |  |  |  | 120432 | 25
 |  | 120433 | 10 |  |  |  | 120433 | 10
 |  | 120434 | 100 |  |  |  | 120434 | 50
 |  | 120435 | 50 |  |  |  | 120435 | 50
 |  |  |  |  |  |  | 120432 | 25
 |  |  |  |  |  |  | 120434 | 50
Spreadsheet: 87677d1287564729-help-in-sumifs-sumifs-1-
Sheet: Sheet1

 |  | LP | 35
 |  |  | SMS
 |  |  | 3250
 |  | LO | 40
 |  |  | WRN
 |  |  | 6492
 |  | LN | 20
 |  |  | SDS
 |  |  | 7135
 |  | MP | 31
 |  |  | SDS
 |  |  | 333
 |  | MO | 11
 |  |  | WRN
 |  |  | 99
 |  | MN | 35
 |  |  | WRN
 |  |  | 1100
 | 1 | Sum, How many records in column D is >=100 and started with L in column C (The Result should be =16,877).
 | 2 | Sum, How many records in column D is>=100 and started with M in column C (The Result should be =1,433)
Spreadsheet: sally_beck__34369__FallonDelaneyrpt
Sheet: Beck

Retain Beck
GIS ID | Formatted Name | Company Name | Job Title | [NAME] | Level1 Full Name | Level2 [NAME] | Level3 [NAME] | Level4 [NAME] | Company
90006766 | VALDEZ, CHRISTINA | ENRON NET WORKS LLC(CNEN) | COORD ADMIN | BECK, [NAME] | WHALLEY, [NAME] | PIPER, GREGORY | BECK, SALLY | VALDEZ, CHRISTINA | Estate
90012899 | BECK, [NAME] | ENRON NET WORKS LLC(CNEN) | CHIEF OPERATING OFFICER | PIPER, GREGORY F | WHALLEY, [NAME] | PIPER, GREGORY | BECK, SALLY |  | Estate
 |  |  |  | 2
Spreadsheet: 5af33ce5-e833-485a-b8db-080601d07d42
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
PHU_ | Test | PHU_ | pH, [NAME] | pH, U | [NAME] | [NAME]: Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL Collections Instructions: Collect a random urine specimen. | 1.0 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA |  | Monday through Sunday; Continuously | 1 day | 1 day | 1 | 83986 |  |  |  |  | Rochester
PHU_ | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
PHU_ | Result | PHU_ | pH, U | pH, U | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2756-5
Spreadsheet: ab91e035-c2f6-423e-b478-b375f3a4add5
Sheet: 21

Uke: | 21 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: 41616d1240166171-vlookup-multiple-lines-09-supplier
Sheet: Download Data

Manufacturer | Number | Start Date | Description | Revision Level | DefQty (exter.) | Serial no. | Completion date
Tesco | 10003188 | 2009-02-09 00:00:00 | Burgers | 00 | 3500 | 53939
Tesco | 20000746 | 2009-02-18 00:00:00 | Ham | 00 | 0 | 55556
Tesco | 10003219 | 2009-03-19 00:00:00 | Corned Beef | 00 | 28000 | 56405,56421,56422 | 2009-04-15 00:00:00
Tesco | 10003224 | 2009-04-07 00:00:00 | Steak | 00 | 15000 | 57570
Tesco | 10003253 | 2009-04-14 00:00:00 | Sausages | 01 | 17000 | 57707
Tesco | 10003227 | 2009-04-15 00:00:00 | Bread | 01 | 1 | 57751
Sainsburys | 10003164 | 2009-02-03 00:00:00 | Burgers | 01 | 1 | 55974 | 2009-02-09 00:00:00
Sainsburys | 10003192 | 2009-02-18 00:00:00 | Ham | 00 | 1 | 56340 | 2009-02-20 00:00:00
Sainsburys | 10003169 | 2009-03-04 00:00:00 | Corned Beef | 00 | 2 | 55555 | 2009-03-27 00:00:00
Sainsburys | 10003198 | 2009-03-20 00:00:00 | Steak | 01 | 75 | 57173
Sainsburys | 10003244 | 2009-04-01 00:00:00 | Sausages | 01 | 1 | 57454
Sainsburys | 10003245 | 2009-04-01 00:00:00 | Bread | 01 | 2 | 57460
Sainsburys | 10003260 | 2009-04-07 00:00:00 | Milk | 00 | 1 | 57540
Spreadsheet: 117606d1312910036-lookup-multiple-values-of-a-single-cell-and-return-sum-of-results-objectives-sample-sheet
Sheet: Objectives

CODE | Objective | Importance | Deadline | Status | Requirements | REQ. QUANT. | [NAME]
OB0001 | Objective 01 | 8 | 2014-01-01 00:00:00
OB0002 | Objective 02 | 5 | 2013-01-01 00:00:00
OB0003 | Objective 03 | 5 | 2012-01-01 00:00:00
OB0004 | Objective 04 | 5 | 2013-01-01 00:00:00
OB0005 | Objective 05 | 8 | 2011-12-01 00:00:00
OB0006 | Objective 06 | 7 | 2012-01-01 00:00:00
 | Each objective has a set of requirements. Everytime a requirement is completed, it's status on the "Requirements" Sheet changes to "1". As the requirements are completed, the Status row (row E) will display the percentage of completion of every objective, based on how many of it's related requirements are completed. I want to set the formula that returns this percentage of completion, but I do not want to have to edit individually every objective's formula. I want a general formula that will detect the requirements based on the F row, look for their status on the "Requirements" Sheet, compare the sum of the requirements' status with the total amount of requirements the objective has, and return a percentage of completion. The key is on the H row's formula. That's the one I need automated. I need it to detect the cells related to each objective based on the information on the F row's cell, and then return the sum of the "Status" of all these requirements. Ideally I would also want to eliminate the need for rows "G" and "H".
Spreadsheet: 713434d1610716776-totals-from-two-different-tabs-into-a-third-tab-of-the-same-workbook-try-again-1-15-21
Sheet: Annual Ledger

Activity | Ref # | Jan Total | Feb Total | March Total | April Total | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual Total | Monthly Average
Mortgage | 1
Electric | 2
Gas | 3
Phone | 4
Cable | 5
Dining Out | 6
Groceries | 7
[NAME] | 8
Spreadsheet: 89997400-2930-4436-b15e-e5588c7c5c89
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Cod. Interno | Cod. Produttore | Produttore | Descrizione
Q.253.76 | ABDG-ET-IN5010 |  | Industrial Wireless Ethernet Router, [NAME] to 802.11b/g
Q.254.01 | ABDG-SE-IN5410 |  | Industrial Wireless Serial Device Server, 1 port to 802.11b/g
Q.254.02 | ABDG-SE-IN5420 |  | Industrial Wireless Serial Device Server, 2 port to 802.11b/g
Q.254.03 | ABDG-BR-IN5010 |  | Industrial Wireless Ethernet Client Bridge, Ethernet to 802.11b/g
Spreadsheet: 110769d1307382049-if-function-multi-column-multi-record-test
Sheet: Data

Date | Name | 1st Subject Score | 2nd Subject Score | 3rd Subject Score | 4th Subject Score
2011-04-13 00:00:00 | Student5 | 372 | 499 | 474 | 551
2011-05-17 00:00:00 | Student1 | 490 | 518 | 630 | 530
2011-03-28 00:00:00 | Student2 | 341 | 541 | 341 | 500
2011-04-16 00:00:00 | Student6 | 625 | 535 | 586 | 639
2011-05-02 00:00:00 | Student4 | 529 | 307 | 311 | 452
2011-05-05 00:00:00 | Student9 | 345 | 336 | 416 | 424
2011-04-28 00:00:00 | Student6 | 394 | 387 | 395 | 527
2011-05-16 00:00:00 | Student7 | 540 | 611 | 610 | 633
2011-04-15 00:00:00 | Student3 | 341 | 302 | 582 | 428
2011-04-24 00:00:00 | Student3 | 361 | 363 | 531 | 289
2011-04-28 00:00:00 | Student6 | 339 | 321 | 490 | 460
2011-05-07 00:00:00 | Student7 | 534 | 367 | 643 | 413
2011-05-05 00:00:00 | Student5 | 366 | 638 | 563 | 404
2011-05-08 00:00:00 | Student8 | 379 | 638 | 530 | 573
2011-05-22 00:00:00 | Student4 | 545 | 582 | 312 | 361
2011-04-02 00:00:00 | Student9 | 541 | 289 | 461 | 482
2011-05-05 00:00:00 | Student10 | 645 | 349 | 588 | 418
2011-05-01 00:00:00 | Student9 | 590 | 424 | 422 | 558
2011-04-03 00:00:00 | Student6 | 399 | 408 | 465 | 564
2011-04-18 00:00:00 | Student8 | 409 | 310 | 625 | 548
2011-05-24 00:00:00 | Student5 | 378 | 524 | 385 | 361
2011-05-14 00:00:00 | Student2 | 603 | 379 | 334 | 551
2011-05-05 00:00:00 | Student7 | 564 | 518 | 567 | 266
2011-04-19 00:00:00 | Student4 | 369 | 638 | 460 | 252
2011-04-01 00:00:00 | Student6 | 425 | 571 | 346 | 625
2011-04-09 00:00:00 | Student8 | 255 | 480 | 436 | 363
2011-04-01 00:00:00 | Student2 | 260 | 406 | 253 | 435
2011-04-30 00:00:00 | Student3 | 331 | 373 | 366 | 586
2011-04-03 00:00:00 | Student7 | 465 | 321 | 457 | 348
2011-04-23 00:00:00 | Student6 | 281 | 408 | 511 | 611
2011-05-05 00:00:00 | Student4 | 592 | 257 | 301 | 270
2011-03-28 00:00:00 | Student7 | 430 | 440 | 625 | 635