tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 70113d1270774855-pulling-info-out-of-an-old-layout-oct-08-example
Sheet: 10-6-08 2ND

Daily Problem Report |  |  |  |  |  | 2nd shift |  | Date |  | 2008-10-06 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 9 |  | 2.75 |  | 4
PR |  | 2 |  |  |  | 3.6
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 5-1 | 55181/3-04030-T1 |  | Problem: MISLOCATED PART |  |  | Station:1/5 |  | Ran:START OF 800 | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | FINGERS OUT OF LOCATION |  |  | E.Y.
 |  |  |  |  | Explain: | CLEANED OUT AND INSPECTED  MIS LOCATION. POLISHED PILOT.  HELPED WITH FINGERS. |  |  |  |  | 7:15-7:30
 |  |  |  |  | OK.
Stamping T/L: ADAM D
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 3-1 | 55712-08030-T1 |  | Problem: OVERLAPPING |  |  | Station:2/6 |  | Ran:500 OF 1200 | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | UNKNOWN |  |  | 9:45-10:00
 |  |  |  |  | Explain: | WIPED OUT PRESS. INSPECTED BLANK TO GUIDES. OK .PROBLEM DIE PRESS. RAN PARTS AND |  |  |  |  | E.Y.
 |  |  |  |  | PUT ON HOLD.
Stamping T/L: G.C.
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 2-1 | 64115-04030-00 |  | Problem: MIS FED |  |  | Station:PROG |  | Ran:968 OF 1050 | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | FEED ROLLERS FED IT TO FAR. |  |  | 2:15-2:30
 |  |  |  |  | Explain: | WIPED OUT AND INSPECTED. OK. |  |  |  |  | E.Y.
Stamping T/L: GLENN
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 836891d1689701811-reverse-proportional-distribution-example-1-
Sheet: Sheet1

Item | Reviews | Ranking | New Rank
A | 161 | 499
B | 6774 | 500
C | 5744 | 504
D | 9484 | 498
E | 30 | 500
 |  |  |  | Check
Variable | 0.05
Spreadsheet: 857618d1706598658-textjoin-multiple-criteria-with-data-in-rows-between-date-range-book1-252-aligw
Sheet: Sheet1

TASK NAME | START | FINISH |  | Calendar | Tasks
Example 1 | 2024-04-29 00:00:00 | 2024-05-11 00:00:00 |  | 2024-04-29 00:00:00
Example 2 | 2024-05-03 00:00:00 | 2024-05-04 00:00:00
Example 3 | 2024-05-06 00:00:00 | 2024-05-13 00:00:00
Example 4 | 2024-05-13 00:00:00 | 2024-05-13 00:00:00
Example 5 | 2024-05-13 00:00:00 | 2024-05-31 00:00:00 |  |  |  |  |  | 2024-05-31 00:00:00
Example 6 | 2024-05-15 00:00:00 | 2024-05-15 00:00:00 |  |  |  |  | 2024-05-15 00:00:00 | 2024-05-15 00:00:00
Example 7 | 2024-06-01 00:00:00 | 2024-06-01 00:00:00
Example 8 | 2024-05-27 00:00:00 | 2024-05-27 00:00:00
Example 9 | 2024-06-01 00:00:00 | 2024-06-01 00:00:00
Example 10 | 2024-05-28 00:00:00 | 2024-05-30 00:00:00
Example 11 | 2024-05-31 00:00:00 | 2024-06-08 00:00:00
Example 12 | 2024-06-10 00:00:00 | 2024-06-15 00:00:00
Example 13 | 2024-05-21 00:00:00 | 2024-05-21 00:00:00
Example 14 | 2024-05-22 00:00:00 | 2024-05-22 00:00:00
Example 15 | 2024-05-23 00:00:00 | 2024-05-29 00:00:00
Example 16 | 2024-05-29 00:00:00 | 2024-05-29 00:00:00
Example 17 | 2024-05-29 00:00:00 | 2024-05-29 00:00:00
Example 18 | 2024-05-30 00:00:00 | 2024-06-01 00:00:00
Example 19 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
Example 20 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
Example 21 | 2024-05-29 00:00:00 | 2024-05-29 00:00:00
Example 22 | 2024-05-30 00:00:00 | 2024-05-30 00:00:00
Example 23 | 2024-05-29 00:00:00 | 2024-05-29 00:00:00
Example 24 | 2024-05-30 00:00:00 | 2024-05-31 00:00:00
Example 25 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
Example 26 | 2024-05-23 00:00:00 | 2024-05-23 00:00:00
Example 27 | 2024-05-30 00:00:00 | 2024-05-30 00:00:00
Example 28 | 2024-05-27 00:00:00 | 2024-05-27 00:00:00
Example 29 | 2024-05-28 00:00:00 | 2024-05-28 00:00:00
Example 30 | 2024-05-29 00:00:00 | 2024-05-29 00:00:00
Example 31 | 2024-05-30 00:00:00 | 2024-05-31 00:00:00
Example 32 | 2024-05-25 00:00:00 | 2024-05-25 00:00:00
Example 33 | 2024-05-30 00:00:00 | 2024-05-30 00:00:00
Spreadsheet: 356661d1415181583-creating-formula-which-auto-looks-up-specific-data-and-makes-calculation-based-on-that-data-predictions
Sheet: Sheet1

 |  |  |  |  |  | My Percentages |  |  |  |  |  |  |  |  | My Decimal Odds |  |  |  |  |  |  |  |  | Bookies Best Decimal Odds |  |  |  |  |  |  |  |  | Difference In Odds
Date |  | Fixtures |  |  |  | Home Win % | Draw % | [NAME] | Home Double Chance % | Away Double Chance % | Under 2.5 % | Over 2.5 % | BTTS % |  | Home Win | Draw | [NAME] | Home Double Chance | Away Double Chance | Under 2.5 | Over 2.5 | BTTS |  | HW | D | AW | HDC | ADC | U2.5 | O2.5 | BTTS |  | HW Diff | D Diff | AW Diff | HDC Diff | [NAME] | U2.5 Diff | O2.5 Diff | BTTS Diff
2014-11-01 00:00:00 |  | Arsenal | v | Burnley
Spreadsheet: 34253d1231415375-consolidate-data-from-multiple-worksheets-example_2-1-
Sheet: OPRA Codes

OPRA Code | Category
A01 | Landfill | L
A02 | Landfill | L
A03 | Landfill | L
A04 | Landfill | L
A05 | Landfill | L
A06 | Landfill | L
A07 | Landfill | L
A08 | Landfill | L
A09 | Transfer | T
A10 | Transfer | T
A11 | Transfer | T
A12 | Transfer | T
A13 | Transfer | T
A14 | Transfer | T
A15 | Transfer | T
A16 | Recovery | V
A17 | Recovery | V
A18 | Incinerator | I
A19 | Recycling | Y
A19a | Recycling | Y
A20 | Recycling | Y
A21 | Recovery | V
A22 | Composting | C
A23 | Recovery | V
A24 | Recovery | V
Spreadsheet: f0ac6734-8b7f-476b-92a1-250b99073aed
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
AAMSD | Test | AAMSD | Amino Acids, [NAME], Plasma | Amino Acid, MSUD Panel, P | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Green top (sodium heparin) Acceptable: EDTA, plasma gel, or lithium heparin Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Collection Instructions:  1. Fasting (12 hours). Infants should be drawn just before next feeding.  2. Spin down promptly. Additional Information:  1. Patient's age is required. 2. Include family history, clinical condition (asymptomatic or acute episode), diet, and drug therapy information. Forms: If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 0.25 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK - note to lab Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Thrombin-activated tube | ISOLEUCINE < or =23 months: 31-105 nmol/mL 2-17 years: 30-111 nmol/mL > or =18 years: 36-107 nmol/mL   LEUCINE < or =23 months: 48-175 nmol/mL 2-17 years: 51-196 nmol/mL > or =18 years: 68-183 nmol/mL  VALINE < or =23 months: 83-300 nmol/mL 2-17 years: 106-320 nmol/mL > or =18 years: 136-309 nmol/mL  ALLO-ISOLEUCINE < or =23 months: <2 nmol/mL 2-17 years: <3 nmol/mL > or =18 years: <5 nmol/mL | Monday through Friday; 8 a.m. | 3 days (not reported on Saturday or Sunday) | 5 days | 1 | 82136 |  |  |  |  | Rochester
AAMSD | [NAME] | PLASMA | Plasma |  |  |  | Frozen | 14 days
AAMSD | Result | 32446 | [NAME] | [NAME] | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 20661-5 | [NAME]:SCnc:Pt:Ser/Plas:Qn:
AAMSD | Result | 32447 | Isoleucine | Isoleucine | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 20648-2 | Isoleucine:SCnc:Pt:Ser/Plas:Qn:
AAMSD | Result | 32448 | Leucine | Leucine | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 20649-0 | Leucine:SCnc:Pt:Ser/Plas:Qn:
AAMSD | Result | 32449 | Allo-isoleucine | Allo-isoleucine | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 22670-4 | Alloisoleucine:SCnc:Pt:Ser/Plas:Qn:
AAMSD | Result | 32450 | Interpretation (AAMSD) | Interpretation (AAMSD) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 88095d1288020676-format-not-staying-same-test-for-pricing
Sheet: Quote to Client

 |  | Date
Client |  | Site
Item No | Item Description | Labour | Materials | Total
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 |  | Total
Spreadsheet: 56400d1256594818-solved-auto-change-row-font-colour-and-move-row-example
Sheet: Sheet1

Project | Owner(s) | Date Started | To Be Completed By | Completed On | Status | Comments/Updates
Project c | [NAME] | 2009-10-01 00:00:00 | 2009-10-31 00:00:00 | 2009-10-10 00:00:00 | Complete | Done
Project a |  |  |  |  | WIP
Project b |  |  |  |  | WIP
Project d |  |  |  |  | On-hold
 |  |  |  |  | Complete
 |  |  |  |  | WIP
 |  |  |  |  | On-hold
Spreadsheet: 718150d1613014504-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 10

 |  |  | Date | 2021-01-10 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  | 1900-01-10 00:00:00 |  |  |  | 1001 | Stoppage 3 | Category 3
Machine2 | 15:00:00 | 16:00:00 |  | 1900-01-15 00:00:00 |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 13:00:00 | 14:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine4 | 13:00:00 | 14:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 675907d1588551052-detecting-schedule-conflicts-minimal-sample
Sheet: Consolidated

Consolidated Schedule
Customer # | Employee # | Sun | Mon | Tue | Wed | Thu | Fri | Sat
1 | 1 |  | 1 | 0 | 1 | 0 | 1 | 0
1 | 2 |  | 0 | 1 | 0 | 1 | 0 | 1
1 | 3 |  | 0 | 1 | 0 | 1 | 0 | 0
1 | 4 |  | 1 | 0 | 1 | 0 | 1 | 0
2 | 1 |  | 0 | 1 | 0 | 1 | 0 | 1
2 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0
2 | 3 |  | 1 | 0 | 1 | 0 | 1 | 0
2 | 4 |  | 0 | 0 | 0 | 0 | 0 | 1
3 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
3 | 2 |  | 0 | 0 | 0 | 0 | 1 | 1
3 | 3 |  | 0 | 1 | 0 | 0 | 1 | 1
3 | 4 |  | 1 | 0 | 1 | 0 | 1 | 0
4 | 1 |  | 0 | 0 | 1 | 0 | 0 | 0
4 | 2 |  | 0 | 0 | 1 | 0 | 0 | 1
4 | 3 |  | 0 | 0 | 0 | 0 | 0 | 0
4 | 4 |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 328860d1404121094-incident-resolution-sla-calculations-sla-details-_1
Sheet: Sheet1

 |  |  |  | Incident Start | Incident End | Priority |  | Priority | Resolution Time (hrs) | Core Hours (Mon-Fri)
 |  |  |  | 2014-03-05 13:32:00 | 2014-03-08 20:03:00 | P1 |  | P1 | 2 | 08:00-18:00
 |  |  |  | 2014-03-08 23:36:00 | 2014-03-09 00:41:00 | P2 |  | P2 | 4 | 08:00-18:00
 |  |  |  | 2014-03-09 01:08:00 | 2014-03-09 03:07:00 | P1 |  | P3 | 24 | 08:00-18:00
 |  |  |  | 2014-03-09 18:37:00 | 2014-03-10 01:43:00 | P2 |  | P4 | 48 | 08:00-18:00
 |  |  |  | 2014-03-08 20:50:00 | 2014-03-10 04:39:00 | P2
 |  |  |  | 2014-03-07 10:48:00 | 2014-03-10 04:43:00 | P3
 |  |  |  | 2014-03-10 12:17:00 | 2014-03-10 14:06:00 | P3
 |  |  |  | 2014-03-10 13:03:00 | 2014-03-11 14:28:00 | P3
 |  |  |  | 2014-03-10 15:55:00 | 2014-03-12 16:54:00 | P1
 |  |  |  | 2014-03-11 08:13:00 | 2014-03-11 08:14:00 | P3
 |  |  |  | 2014-03-09 12:42:00 | 2014-03-11 09:23:00 | P1
 |  |  |  | 2014-03-11 10:42:00 | 2014-03-11 12:44:00 | P3
 |  |  |  | 2014-03-11 06:11:00 | 2014-03-11 15:30:00 | P3
 |  |  |  | 2014-03-08 12:06:00 | 2014-03-08 20:04:00 | P1
 |  |  |  | 2014-03-09 18:13:00 | 2014-03-15 20:17:00 | P4
 |  |  |  | 2014-03-10 16:26:00 | 2014-03-10 16:27:00 | P2
 |  |  |  | 2014-03-11 08:56:00 | 2014-03-11 10:31:00 | P3
Spreadsheet: 824765d1680809350-separate-out-accrue-rate-into-excel-column-accrual-rate
Sheet: Sheet1

Accrual Rate
[After 10 Years, accrue 9.334 hours  twice a month] |  | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[After 0 Days, accrue 6 hours  twice a month] | 6 | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[After 2 Years, accrue 7.667 hours  twice a month] | 7.667 | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[After 0 Days, accrue 9.334 hours  twice a month] | 9.334 | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[Not currently assigned to plan] | blank | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
X | blank
Y | blank
Z | blank
expected results
Accrual Rate
[After 10 Years, accrue 9.334 hours  twice a month] |  | 9.334
[After 0 Days, accrue 6 hours  twice a month] |  | 6
[After 2 Years, accrue 7.667 hours  twice a month] |  | 7.667
[After 0 Days, accrue 9.334 hours  twice a month] |  | 9.334
[Not currently assigned to plan] |  | "blank"
Spreadsheet: 776116d1649510730-count-of-ids-that-meet-3-conditions-test-21
Sheet: Sheet1

 | Request ID |  | Originator |  |  |  | Request type |  | Completed on |  |  | Expected | [NAME]
 | 21674793 |  | Smith [NAME] |  |  |  | Create |  | 2021-12-08 12:01:59.362000 |  |  | 2
 | 21711447 |  | Bond [NAME] |  |  |  | Modify |  | 2021-12-10 16:55:46.302000
 | 21711465 |  | Bond [NAME] |  |  |  | Modify |  | 2021-12-10 16:57:37.545000
 | 22056524 |  | Smith [NAME] |  |  |  | Create |  | 2022-01-17 11:45:26.783000
 | 22056569 |  | Smith [NAME] |  |  |  | Modify |  | 2022-01-17 11:46:37.191000
 | 22063875 |  | Bond [NAME] |  |  |  | Create |  | 2022-01-17 15:35:46.616000
 | 22178899 |  | Smith Harriet |  |  |  | Renew |  | 2022-01-26 10:37:43.858000
 | 22179027 |  | Smith [NAME] |  |  |  | Close |  | 2022-01-26 10:41:48.486000
 | 22179060 |  | Doe [NAME] |  |  |  | Modify |  | 2022-01-26 10:42:49.360000
 | 22363929 |  | Smith [NAME] |  |  |  | Create |  | 2022-02-09 17:21:25.392000
 | 22461097 |  | Smith Harriet |  |  |  | Modify |  | 2022-02-18 12:10:00.042000
Spreadsheet: 539cdcb3-aa8a-49ff-8b67-6ed1a64db5dc
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
[NAME] | Test | [NAME] | MPL Exon 10 Mutation Detection, Bone Marrow | MPL Exon 10 Mutation Detection, BM | Mutation Detection in DNA Using Sanger Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA |  |  | 2 | mL | [NAME] must arrive within 168 hours of collection.   Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD [NAME]: 2 mL Collection Instructions: 1. Invert several times to mix bone marrow. 2. Send specimen in original tube. Additional Information: Collection date is required. Forms:  1. Hematopathology Patient Informations Sheet (Supply T676) in Special Instructions 2. If not ordering electronically, submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday | 5 days | 8 days | 1 | 81403 |  |  |  |  | Rochester
[NAME] | [NAME] | BNMARW | Bone Marrow |  |  |  | Ambient | 7 days
[NAME] | Result | 20232 | Final Diagnosis: | Final Diagnosis: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34574-4 | Path report.final diagnosis:Imp:Pt:[NAME]:Nom:
Spreadsheet: 457055d1461180345-conditional-formatting-if-multiple-cells-contain-any-text-and-not-numbers-cf-istext
Sheet: Sheet1

666.6 | 230.6 | 862.2 | 12.2
343.1 | 330.8 | 817.5 | 570.6
535.9 | 138.2 | 3 | 730.1
256.2 | [NAME] | 869.8 | 233.4
17.2 | 18.5 | 858.9 | [NAME]
805.8 | 261.9 | 136.5 | 162.2
381.3 | Carol | 618.7 | 449.3
55.5 | 618.8 | 48 | 72.3
492.4 | 804.4 | 369.8 | 959.1
261.1 | 856.8 | 704.6 | 7.5
Spreadsheet: 130705d1322524801-excel-2007-sum-countifs-formula-question-example-multiple-criteria
Sheet: info

salesman | promocode | Verifier
[NAME] | 111 | cf1234
[NAME] | 111 | ts1234
[NAME] | 111
[NAME] | 333 | sh1234
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 999 | ts1234
[NAME] | N999 | [NAME]
[NAME] | PI
[NAME] | RN | mf1234
[NAME] | SB
[NAME] | SB | nl1234
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | 333
[NAME] | SB | nl1234
[NAME] | SB
[NAME] | 111
[NAME] | SB | jb1234
[NAME] | PI
[NAME] | 9999 | nl1234
[NAME] | SB | cf1234
[NAME] | 333 | cf1234
[NAME] | 333
[NAME] | SB
[NAME] | SB
[NAME] | SB | nl1234
[NAME] | SB | ts1234
[NAME] | 9999 | nl1234
[NAME] | 9999 | ts1234
[NAME] | M998
Spreadsheet: 90170d1289931183-cannot-get-formulas-to-populate-a-protected-worksheet-when-inserting-rows-bcs-scope-list-template
Sheet: Building13

Building13
 | Reference No. | Year | Priority | BCS Reference | Items | Existing Conditions | Recommendations | New Const. | Additions | Alteration | Major Systems | Major Repair | Energy | Bond | Capital | Estimated Cost with Incidental
 |  | SITE ISSUES
 |  | ARCHITECTURAL ISSUES
 |  | MECHANICAL ISSUES
 |  | PLUMBING ISSUES
 |  | ELECTRICAL ISSUES
Spreadsheet: 140993d1329010011-need-a-count-with-multiple-variables-example
Sheet: Sheet1

EMP | NS DAYS | BDS | PSM | SBS | IES
[NAME] | SAT SUN | X |  | X |  |  | X = employee is trained on this equipment.
MIKE | SUN MON | 1 | X | X | X
SUSAN | MON TUE | 2 |  | X
TOM | TUE WED | X | X
BILL | WED THU | 3 | X
[NAME] | THU FRI | 4 |  | X | X
JOE | FRI SAT | X
 | SAT | SUN | MON | TUE | WED | THU | FRI
BDS | 0 | 1 | 2 | 0 | 3 | 4 | 0
PSM | 0 | 0 | 0 | 0 | 0 | 0 | 0
SBS | 0 | 0 | 0 | 0 | 0 | 0 | 0
IES | 0 | 0 | 0 | 0 | 0 | 0 | 0
BDS PSM SBS IES ARE TYPES OF EQUIP. | SBS ISE are types of | re types of equipment
EMP =Technicians that work on equipment
NS Days = Non- Scheduled to work days.
Need a way to count the number of employees trained on each equip on every day of the week. |  |  |  |  |  |  |  | week input into second table.
Spreadsheet: 328257d1403843754-help-require-to-complete-year-mukesh
Sheet: Sheet1

method 1 |  |  | method 2
2011-2012 |  | 11
2012-2013 |  | 12
2013-2014 |  | 13
2014-2015 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
Spreadsheet: 708267d1607699966-help-to-maybe-use-vlookup-to-quickly-copy-prices-from-table-b-to-a-sample
Sheet: a

Supplier P/N | Price
TMJ316BB7106KLHT
HMJ325KC7475KMHPE
[NAME]
EMK105B7104KVHF
EMK107B7474KAHT
TMK107AB7105KAHT
TMK105B7103KVHF
TMK212B7225KGHT
UMK105B7102KVHF
Spreadsheet: 813423d1673741490-bring-multiple-cells-into-one-based-on-a-match-s666-pq-bring-multiple-cells-into-one-based-on-a-match
Sheet: Sheet1

Name | Model Number | Sub type | Type | Generate here |  |  | Model Number | Names | Sub | Type
Adam | 855 | 1 |  |  |  |  | 855 | [NAME], [NAME], Yolanda | 1,3,6 | Primary
[NAME] | 855 | 3 |  |  |  |  | 890 | [NAME] | 1
Yolanda | 855 | 6 | Primary | [NAME], [NAME], Yolanda |  |  | 891 | [NAME], [NAME], Victoria | 4,55,70 | Primary
[NAME] | 890 | 1 |  |  |  |  | 905 | Shane | 9
[NAME] | 891 | 4 | Primary | [NAME], Carety, Victoria |  |  | 907 | [NAME] | 10
[NAME] | 891 | 55 |  |  |  |  | 912 | Kimberly | 14
Victoria | 891 | 70 |  |  |  |  | 934 | [NAME], [NAME], [NAME], [NAME], Mario | 2,3,7,8,17 | Primary
Shane | 905 | 9 |  |  |  |  | 987 | [NAME] | 21
[NAME] | 907 | 10 |  |  |  |  | 988 | Colin, [NAME] | 20,25 | Primary
Kimberly | 912 | 14 |  |  |  |  | 989 | Xavier | 29
[NAME] | 934 | 2
[NAME] | 934 | 3
[NAME] | 934 | 7 | Primary | [NAME], [NAME], [NAME], [NAME], Mario
[NAME] | 934 | 8
Mario | 934 | 17
[NAME] | 987 | 21
[NAME] | 988 | 20
Zachary | 988 | 25 | Primary | Colin, [NAME]
Xavier | 989 | 29
Is there a formula that can collect these names from column A based on a match in Column B?
Model 891 is in Row 6, 7 and 8, but names go in Row 6, because of the 'Primary' designation
Spreadsheet: 07cf38c9-65cc-4178-a125-307bf7e1cdac
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8779 | 55465 | Fabio | Barsi | ITA | 141 | 00:16:40 | 00:00:47 | [NAME] | 00:01:21 | 00:19:40 | 1 | 01:02:37
8779 | 69383 | Simone | Ripamonti | ITA | 142 | 00:17:53 | 00:00:28 | 00:32:59 | 00:01:26 | [NAME] | 2 | 01:11:01
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44026

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44026
Number of cores |  | 4
Spare cores |  | 2
Core size |  | mm2
Cable Type |  | Cu, PVC
Drawing References
Cable Service |  | [NAME]
Panel Number |  |  | Panel Number
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | 0 | INITIAL | 0 | INITIAL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes
Edition Notes