tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 62438d1263390787-excel-2007-calculating-a-certain-time-range-between-2-hours-shiftunsocial
Sheet: Hours Calc

 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY |  |  | Total Shift Hours | Total Hours Worked
Shift 1 |  |  |  |  |  |  |  |  | 19:30:00 | 07:30:00 | 19:30:00 | 07:30:00 | 19:30:00 | 07:30:00
Shift 2 |  |  |  |  |  |  | 07:00:00 | 19:00:00 | 07:00:00 | 19:00:00
Shift 3 | 07:30:00 | 19:30:00 | 07:30:00 | 19:30:00 | 07:00:00 | 19:00:00 | 19:30:00 | 07:30:00
Shift 4 |  |  |  |  |  |  |  |  | 19:30:00 | 07:30:00 | 19:30:00 | 07:30:00 | 19:30:00 | 07:30:00
Shift 5 |  |  |  |  | 07:30:00 | 19:30:00 | 07:30:00 | 19:30:00 | 07:30:00 | 19:30:00
Shift 6 | 07:00:00 | 19:00:00 | 07:00:00 | 19:00:00 | 19:00:00 | 07:00:00 | 19:00:00 | 07:00:00
Shift 7 | 19:00:00 | 07:00:00 | 19:00:00 | 07:00:00 |  |  |  |  |  |  | 09:00:00 | 19:00:00 | 09:00:00 | 19:00:00
Shift 8 | 19:00:00 | 07:00:00 | 19:00:00 | 07:00:00 |  |  |  |  |  |  | 09:00:00 | 19:00:00 | 09:00:00 | 19:00:00
Shift 9 |  |  |  |  |  |  |  |  | 19:00:00 | 07:00:00 | 19:00:00 | 07:00:00 | 19:00:00 | 07:00:00
Shift 10 |  |  |  |  | 07:30:00 | 19:30:00 | 07:30:00 | 19:30:00 | 07:30:00 | 19:30:00
Shift 11 | 07:00:00 | 19:00:00 | 07:00:00 | 19:00:00 | 19:00:00 | 07:00:00 | 19:00:00 | 07:00:00
Shift 12 |  |  |  |  |  |  |  |  | 19:00:00 | 07:00:00 | 19:00:00 | 07:00:00 | 19:00:00 | 07:00:00
Shift 13 |  |  |  |  |  |  | 07:00:00 | 19:00:00 | 07:00:00 | 19:00:00
Shift 14 | 07:30:00 | 19:30:00 | 07:30:00 | 19:30:00 | 07:00:00 | 19:00:00 | 19:30:00 | 07:30:00
Shift 15 | 19:30:00 | 07:30:00 | 19:30:00 | 07:30:00 |  |  |  |  |  |  | 07:30:00 | 19:30:00 | 07:30:00 | 19:30:00
Shift 16 | 19:30:00 | 07:30:00 | 19:30:00 | 07:30:00 |  |  |  |  |  |  | 07:30:00 | 19:30:00 | 07:30:00 | 19:30:00
Shift 17
Shift 18
Shift 19
Shift 20
Shift 21 | 05:00:00 | 17:00:00 |  |  | 16:00:00 | 00:00:00 |  |  | 15:00:00 | 23:00:00
Shift 22
 |  |  |  |  |  |  |  | Total Hours For Roster
 |  |  |  |  |  |  |  | Total Unsocial Hours For Roster
 |  |  |  |  |  |  |  | Percentage Of Roster That Is Unsocial
Spreadsheet: 771492d1646697665-iferror-index-aggregate-formula-to-copy-and-paste-across-two-workheets-index-match-1-aggregateand-countif
Sheet: Customer

BRANCH | CITY | STATE | MANUFACTURER | MODEL | PROD | Description
75 | AUSTIN | TX | BROTHER | PBCN1P | PB8900
75 | AUSTIN | TX | BROTHER | PBCN1P | PB8900
75 | AUSTIN | TX | BROTHER | PBCN1P | PB8900
57 | AUSTIN | TX | CANON | CC3N0T | CB35C
57 | AUSTIN | TX | CANON | CC3N0S | C4235
44 | AUSTIN | TX | CANON | CC4N1B | CB50C
44 | AUSTIN | TX | CANON | CC4N1B | CB50C
74 | AUSTIN | TX | CANON | CC2U1K | CB3330
74 | AUSTIN | TX | CANON | CC3U0W | CB5535
74 | AUSTIN | TX | CANON | CC3U0W | CB5535
44 | AUSTIN | TX | CANON | CC2N1Q | CB5540
44 | AUSTIN | TX | CANON | CC4N27 | CB5540
44 | AUSTIN | TX | CANON | CC3N0X | CB5540
44 | AUSTIN | TX | CANON | CC3N11 | CB5540
44 | AUSTIN | TX | CANON | CC3N11 | CB5540
44 | AUSTIN | TX | CANON | CC3N11 | CB5540
44 | AUSTIN | TX | CANON | CC3N11 | CB5540
74 | AUSTIN | TX | CANON | CC3U0E | [NAME]
74 | AUSTIN | TX | CANON | CC4U1P | CB5550
Spreadsheet: 228388d1366105079-please-help-me-d-quotation
Sheet: Orders

Forename | Surname | Gender | Product | Size | Colour
Alasdair | [NAME] | M | Softshell | M | Black
[NAME] | [NAME] | M | Fleece | S | Black
[NAME] | Brockway | M | Hardshell | M | Red
Benedikt | [NAME] | M | Fleece | S | Red
Christian | Chistianson | M | Hardshell | M | Black
[NAME] | Crema | M | Hardshell | M | Black
Cara | Croft | F | Hardshell | L | Black
Cristina | [NAME] | F | Softshell | L | Red
[NAME] | [NAME] | M | Softshell | M | Red
Elena | [NAME] | F | Hardshell | S | Red
Ella | Davies | F | Hardshell | M | Red
Filippo | Ebdy | M | Hardshell | M | Red
Flaminia | [NAME] | F | Softshell | M | Black
[NAME] | [NAME] | M | Softshell | L | Black
[NAME] | Gommeren | M | Hardshell | M | Black
[NAME] | [NAME] | M | Hardshell | S | Black
Hugh | Han | M | Softshell | M | Red
[NAME] | Hatem | M | Hardshell | M | Black
[NAME] | Heynes | M | Hardshell | M | Black
[NAME] | Hindley | M | Hardshell | M | Red
[NAME] | [NAME] | M | Softshell | M | Red
[NAME] | Johnston | F | Softshell | S | Black
Justin | Kapsch | M | Softshell | M | Red
Laurent | Kirkness | M | Fleece | S | Red
Leo | [NAME] | M | Hardshell | S | Red
Lily | Loosley | F | Hardshell | M | Black
[NAME] | Maldaner | M | Softshell | M | Black
Nathan | McCrae | M | Hardshell | M | Black
Nathan | Mcleod | M | Fleece | S | Red
[NAME] | Menaged | M | Softshell | M | Red
Rebecca | Papadimitriou | F | Hardshell | M | Red
Rene | Pitsch | M | Hardshell | M | Black
[NAME] | Pottharst | M | Hardshell | S | Red
Sahir | Shariff | M | Fleece | L | Red
[NAME] | [NAME] | M | Hardshell | M | Red
Tana | Turley | F | Softshell | L | Black
[NAME] | Vetch | M | Softshell | L | Black
Timmy | [NAME] | M | Softshell | L | Red
Turan | Walterskirchen | F | Softshell | M | Red
[NAME] | Wheeler | M | Hardshell | L | Red
Spreadsheet: 854967d1704721496-no-formula-works-please-help-production-file-2-
Sheet: Key Data

ملاحظات |  |  |  |  | منتجات جلاسبى | كود الصنف | الصلاحية |  |  |  | أجناش الشوكولاتة | كود الصنف |  | الجونش | [NAME] |  | نوع الإضافة | التشغيلة
جميع المعادلات حتى 1000 خانة فى الصف |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | سبريد لوتس
ال Key data حتى 120 خلية |  |  |  | بلح | بلح ميلك فستق لوز | A1 |  |  |  |  | تروفل ميلك | TM |  |  |  |  | سبريد نوتيلا
 |  |  |  |  | بلح ميلك بندق لوز | A2 |  |  |  |  | تروفل دارك | TD |  |  |  |  | [NAME]
 |  |  |  |  | بلح ميلك لوز | A3 |  |  |  |  |  |  |  |  |  |  | سبريد فسدق
 |  |  |  |  | بلح أبيض لوز | A4 |  |  |  |  | [NAME] | MN |  |  |  |  | سبريد لوز
 |  |  |  |  | بلح دارك لوز | A5 |  |  |  |  | [NAME] | WN |  |  |  |  | بسكويت لوتس
 |  |  |  |  | بلح كاجو بالشوكولاتة | A6 |  |  |  |  | [NAME] 55 % | D55N
 |  |  |  |  | بلح ميلك لوز كراميل | A7 |  |  |  |  | [NAME] 75% | D75N |  |  | الملف يعتبر ملكية خاصة بشركة جلاسبى فارما © بإعداد كلاً من مهندس عبدالحافظ عبدالناصر - مهندس عبدالله فؤاد [EMAIL] [EMAIL]
 |  |  |  |  | بلح ميلك [NAME] | A8 |  |  |  |  | [NAME] | D85N
 |  |  |  |  |  |  |  |  |  |  | [NAME] 95% | D95N
 |  |  |  |  | مشمشية بالشوكولاتة | A11
 |  |  |  |  |  |  |  |  |  |  | ميلك بديل | MS
 |  |  |  | تورتينا | تورتينا وايت | A12 |  |  |  |  | [NAME] | WS
 |  |  |  |  | تورتينا ميلك | A13 |  |  |  |  | [NAME] | DS
 |  |  |  | معمول | معمول | A14 |  |  |  |  | اسبريد فسدق | PS
 |  |  |  |  | معمول بالشيكولاته الوايت | A15 |  |  |  |  | اسبريد لوز | AS
 |  |  |  |  | معمول بالشيكولاته الميلك | A16 |  |  |  |  | اسبريد بندق | HS
 |  |  |  | لوتس | لوتس ميلك طبيعي | C1 |  |  |  |  | نوتيلا ميلك | NM
 |  |  |  |  | لوتس ميلك بديل | C2 |  |  |  |  | نوتيلا دارك | ND
 |  |  |  |  | لوتس دارك | [NAME]
 |  |  |  |  | لوتس وايت | C4
 |  |  |  | تروفيل | تروفل [NAME] بديل | F2
 |  |  |  |  | تروفل دارك بالكاكاو | F5
 |  |  |  |  | تروفل ميلك بالكاكاو | F3
 |  |  |  |  | تروفيل ويتورز | F4
 |  |  |  | Dark | شنط دارك 55% | D1
 |  |  |  |  | شنط دارك 75% | D2
 |  |  |  |  | شنط دارك 85% | D3
 |  |  |  |  | شنط دارك 95% | D4
 |  |  |  |  | [NAME] | D5
 |  |  |  |  | شنط دارك فسدق | D6
 |  |  |  | فسدق | شنط ميلك فسدق | D7 |  |  |  |  | [NAME] : TM191123 كود الصنف - يوم - شهر  - سنة
 |  |  |  |  | شنط وايت فسدق | D8
 |  |  |  | لوز | شنط دارك لوز | D9
 |  |  |  |  | شنط ميلك لوز | D10
 |  |  |  |  | شنط [NAME] لوز | D11
 |  |  |  |  | ميلك [NAME] مربعات | D12
 |  |  |  | سلبريشن | ميلك طبيعي نوتيلا أصلي | E1
 |  |  |  |  | ميلك اسبريد فسدق | E2
 |  |  |  |  | [NAME] لوز | E3
 |  |  |  |  | دارك55% [NAME] لوتس | E4
 |  |  |  |  | ميلك بندق [NAME] | E5
 |  |  |  | مصر للطيران | [NAME] فسدق | E6
 |  |  |  |  | ميلك لوز [NAME] | E7
 |  |  |  |  | منتجات الشرقى
 |  |  |  | منتجات الشرقى | [NAME] | [NAME]
 |  |  |  |  | بقلاوة | G2
 |  |  |  |  | [NAME] (محشية) | G3
 |  |  |  |  | [NAME] | G4
 |  |  |  |  | بسيمة | G5
 |  |  |  |  | [NAME] | G6
 |  |  |  |  | بسبوسة | G8
 |  |  |  |  | كنافة مفرومة | G9
 |  |  |  |  | جلاش بالمكسرات | G10
 |  |  |  |  | كنافة أساور بالشوكولاتة | G11
Spreadsheet: 848215d1698979193-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days
Sheet: Pay Summary Sheet 

 | EMPLOYEE NAME : |  |  |  |  | STAFF # : |  |  |  |  |  |  |  | POSITION : |  | Senior Bus Operator
 | PAY PERIOD FROM : |  |  |  |  | TO : |  |  |  |  |  |  |  |  | DEPOT : | Brookvale
SECTION 1. PAY SUMARY |  |  |  |  |  |  |  |  |  |  |  |  | SECTION 2. LEAVE ENTITLEMENT SUMMARY
[NAME] |  |  | THIS PAY PERIOD |  |  | YEAR TO DATE |  |  |  |  |  |  | [NAME] |  |  | THIS PAY (Hrs) |  |  | ACCUMULATED TO DATE (Hrs)
Paid Expenses (When Applicable): |  |  | 0 |  |  |  |  |  |  |  |  |  | Annual Leave :
Gross Earnings From Normal Work : |  |  |  |  |  |  |  |  |  |  |  |  | Long Service Leave :
Gross Earnings From Additional Payments : |  |  |  |  |  |  |  |  |  |  |  |  | Sick Leave :
Gross Earnings Sub-Total : |  |  |  |  |  |  |  |  |  |  |  |  | RDO :
Less Super Sacrifice : |  |  | 0 |  |  |  |  |  |  | TAX CALCULATOR
Taxable Income :
Less Tax Payable :
Net Sub-Total : |  |  |  |  |  |  |  |  |  |  |  |  | SECTION 3. HOURS WORKED SUMMARY
LESS DEDUCTIONS AFTER TAX |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | HOURS
[NAME] : |  |  | 22.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] FOR THIS PAY PERIOD :
Traffic Fund : |  |  | 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORMAL HOURS WORKED YEAR TO DATE :
Brookvale Christmas Club + Ex-Service |  |  | 5
Brookvale Institute : |  |  | 5 |  |  |  |  |  |  |  |  |  | OVERTIME HOURS WORKED THIS PAY PERIOD : |  |  |  |  |  | N/A
SASS / SSS : |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME HOURS WORKED YEAR TO DATE : | N/A
Overpayment : |  |  | 33.49
Deductions Sub-Total : |  |  |  |  |  |  |  |  |  |  |  |  | DAYS WORKED THIS PAY PERIOD :
NET PAY TO BANK : |  |  |  |  |  |  |  |  |  |  |  |  | ADO's CANCELLED YEAR TO DATE : |  |  |  |  |  | 6
SUPERANNUATION :
 |  |  |  |  | YEAR TO DATE VALUE : | 22
Spreadsheet: 686128d1594375727-populating-a-table-using-index-test
Sheet: Sheet1

 | tier | no. | cumulative no.
 | 1000 | 2
 | 3000 | 4
 | 5000 | 6 |  |  |  |  |  | start:
 | 10000 | 9
Spreadsheet: 0b7fc49d-01c3-4804-a8b2-98ae9aae09e9
Sheet: Nelsonville

School | Scholarship | Experation Date
Nelsonville York | Nelsonville-Rotary Scholarships | TBA
 | [NAME] | TBA
 | Nelsonville Elks #543 | TBA
 | Nelsonville VFW Post # 3467 | TBA
 | [NAME] and Marguerite McQuillen Scholarship Fund in Memory | TBA
 | of [NAME]
 | Athens Area Vietnam Veterans of America | TBA
 | Chapter 100 [NAME]
 | Ohio Credit Union Foundation Video Scholarship | TBA
TBA or N/A: Check with Guidance Counselors for Updated Dates
Spreadsheet: 853551d1703417935-retrieving-and-moving-transferring-data-glenn-new-problem
Sheet: Wk1

1 | Value |  |  |  |  |  | Value |  |  |  | Wk1
 |  |  |  |  |  |  | 171824
 |  |  |  |  |  |  | 22333
 |  |  |  |  |  |  | 147211
 |  |  |  |  |  |  | 245613
 |  |  |  |  |  |  | 254133
 |  |  |  |  |  |  | 241116
 |  |  |  |  |  |  | 910054
 |  |  |  |  |  |  | 17622
 |  |  |  |  |  |  | 77582
 |  |  |  |  |  |  | 972231
 |  |  |  |  |  |  | 620144
 |  |  |  |  |  |  | 55623
 |  |  |  |  |  |  | 710020
Spreadsheet: 176482d1345884782-how-to-get-sum-of-different-criterias-in-one-cell-sample-sheet-barry-
Sheet: Sheet1

Invoice | source_code | material | sales_area | Qty
1 | ABC | ERASER | pune | 10
2 | XYZ | PENCIL | nashik | 10
3 | XYZ | PEN | pune | 10
4 | ABC | RULER | dhule | 10
5 | XYZ | PEN | satara | 10
6 | XYZ | SCALE | nashik | 10
7 | ABC | PENCIL | pune | 10
8 | XYZ | PEN | satara | 10
material | PENCIL | 20
 | If, I put invice or source code or material or sales area in cell B14 total should come in D14
 | please help its very important
Spreadsheet: 2b46b716-f845-4565-ad98-f078ff993f65
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
AVERAGE SCHOLASTIC ASSESSMENT TEST I (SAT-I) SCORES
(RECENTERED SCALE)
1997 TO 2005
 |  |  | VERBAL |  |  |  | MATH
 | Year |  | UHH  1/ | Hawai‘i  2/ | US  3/ |  | UHH  1/ | Hawai‘i  2/ | US  3/
 | 1997…………………………………………….. |  | 479 | 483 | 505 |  | 486 | 512 | 511
 | 1998…………………………………… |  | 487 | 483 | 505 |  | 495 | 513 | 512
 | 1999………………………………………………………. |  | 494 | 482 | 505 |  | 503 | 513 | 511
 | 2000………………………………………………… |  | 482 | 488 | 505 |  | 494 | 519 | 514
 | 2001…………………………………. |  | 485 | 486 | 506 |  | 493 | 515 | 514
 | 2002………………………………………. |  | 496 | 488 | 504 |  | 515 | 520 | 516
 | 2003………………………………………. |  | 489 | 486 | 507 |  | 497 | 516 | 519
 | 2004………………………………………. |  | 486 | 487 | 508 |  | 497 | 514 | 518
 | 2005............................... |  | 499 | 490 | 508 |  | 507 | 516 | 520
 | Note:  UH Hilo data not available prior to 1997.  UH Hilo data may not tie exactly to other previously published reports due to the use of different data files.
 | 1/  UHH:  First-time freshmen entering the fall semester at the University of Hawai‘i at Hilo.
 | 2/  Hawai‘i:  Hawai‘i test takers.
 | 3/  US:  US test takers
 | Sources:  Hawai‘i and US data from Profile of College Bound Seniors National Report, and Profile of College Bound Seniors Hawai‘i Report from College Board online website.  UH Hilo data from Student Information Management System (SIMS) application files.  Fall 2003 and Fall 2004 data for UH Hilo are from [NAME].  Effective Fall 2005, data are from Banner Operational Data Store (ODS) IRO_ADMISSIONS.
Spreadsheet: 725138d1616557190-help-with-an-if-statement-sample-5-
Sheet: Sheet1

Ticker | Date | Day of year | Day of WK |  | E1 | E2 | SL Close | SL Low | PT1 | PT2 | PT3 | PAx Broke E2 before hitting P1 | Hit PT1 after E1 | Hit E1, but not E2 | Hit E1 and E2 | Broke SL Close | Broke SL Low | Fails to hit PT1 w/in 10 bars | Fails to hit PT2 w/in 10 bars | Fails to hit PT3 w/in 10 bars | Hit PT1 in 10bars, before hitting E1/E2
CFRX | 2021-03-11 00:00:00 |  |  |  | 5 | 5 | 5 | 5 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected result
 |  | scenario 1 |  |  | 5 | 5 | 5 | 5 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | X
 |  | scenario 2 |  |  | ? | ? | ? | ? | ? | ? |  |  |  |  |  |  |  |  |  |  | ?
 |  | scenario 3 |  |  | ? | ? | ? | ? | ? | ? |  |  |  |  |  |  |  |  |  |  | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Re: Help with an =If statement
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Okay, I'm attaching the example that tipped me off. Cells F2 and G2 comprise of a zone where I would consider entries("E1" and "E2"), J2, K2, and L2 are price targets (PT1-3). In this example, price went up and touched [NAME] and PT2, but not [NAME], so cells J2 and K2 got a "1" for the number of days it took to reach those PTs. But then price came back down below "E1" and "E2" a few days later.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell V2 is the formula in question. It is supposed to be a true/false on whether price action hit PT1 without hitting E1/E2, and within 10 days from the signal. Basically, this cell is telling my whether or not price skipped my entry zone or not within a period of 10 days. It should read as a "1" as it is true in this case. Price action didn't hit E1/E2 until 4 days after hitting [NAME], but currently produces an "X" (false).
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanks again, let me know if I can explain anything else.
Spreadsheet: 268726d1380756613-help-circumference-error-circumference-error
Sheet: Table 4 Inter MFI(No FMO) 

Analyst 1
 | Mean Fluorescence Intensity of AF488
 | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
MF39741M | 363 | 1278 | 571 | 1049 | 1915 | 2095
MF39735M | 311 | 1222 | 908 | 1299 | 4522 | 4685
MF39746M | 228 | 1242 | 554 | 1250 | 3722 | 3988
MF39758F | 361 | 1386 | 655 | 1210 | 2300 | 2509
MF39755F | 501 | 1228 | 538 | 1012 | 2075 | 2216
MF39754F | 475 | 1397 | 911 | 1254 | 3320 | 3463
Mean | 373 | 1292 | 690 | 1179 | 2976 | 3159
SD | 102 | 79 | 175 | 119 | 1045 | 1054
Analyst 2
 | Mean Fluorescence Intensity of AF488
 | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
MF39741M | 332 | 1341 | 496 | 1112 | 1650 | 1822
MF39735M | 290 | 1256 | 744 | 1159 | 3814 | 3909
MF39746M | 217 | 1139 | 511 | 1024 | 3423 | 3445
MF39758F | 335 | 1237 | 600 | 1021 | 2229 | 2438
MF39755F | 452 | 1150 | 492 | 970 | 1936 | 2058
MF39754F | 413 | 1255 | 788 | 1194 | 3002 | 3116
Mean | 340 | 1230 | 605 | 1080 | 2676 | 2798
SD | 84 | 75 | 131 | 88 | 867 | 823
[NAME]
Animal | Mean Fluorescence Intensity of AF488
MF39741M | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 348 | 1310 | 534 | 1081 | 1783 | 1959
%difference | 9 | 5 | 14 | 6 | 15 | 14
Pass/Fail | Pass | Pass | Pass | Pass | Pass | Pass
[NAME]
Animal | Mean Fluorescence Intensity of AF488
MF39735M | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 301 | 1239 | 826 | 1229 | 4168 | 4297
%difference | 7 | 3 | 20 | 11 | 17 | 18
Pass/Fail | Pass | Pass | Pass | Pass | Pass | Pass
[NAME]
Animal | Mean Fluorescence Intensity of AF488
MF39746M | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 223 | 1191 | 533 | 1137 | 3573 | 3717
%difference | 5 | 9 | 8 | 20 | 8 | 15
Pass/Fail | Pass | Pass | Pass | Pass | Pass | Pass
[NAME]
Animal | Mean Fluorescence Intensity of AF488
MF39758F | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 348 | 1312 | 628 | 1116 | 2265 | 2474
%difference | 7 | 11 | 9 | 17 | 3 | 3
Pass/Fail | Pass | Pass | Pass | Pass | Pass | Pass
[NAME]
Animal | Mean Fluorescence Intensity of AF488
MF39755F | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 477 | 1189 | 515 | 991 | 2006 | 2137
%difference | 10 | 7 | 9 | 4 | 7 | 7
Pass/Fail | Pass | Pass | Pass | Pass | Pass | Pass
[NAME]
Animal | Mean Fluorescence Intensity of AF488
MF39754F | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 444 | 1326 | 850 | 1224 | 3161 | 3290
%difference | 14 | 11 | 14 | 5 | 10 | 11
Pass/Fail | Pass | Pass | Pass | Pass | Pass | Pass
Spreadsheet: 166100d1341470504-compare-values-in-two-dissimilar-tables-sample-example
Sheet: Raw Data

Sales Report
Grouped by [NAME]
 | Sales
 | ------------
AAA | 400
BBB | 507.07
CCC | 790.86
DDD | 1068.33
EEE | 1565.55
FFF | 1609.69
GGG | 1764.58
HHH | 2017.49
III | 2212.25
JJJ | 2305.53
KKK | 3174.38
Spreadsheet: 839431d1691980472-creation-of-a-parts-ordering-program-sunday-13082023-1150am
Sheet: LOOKUP

[NAME]
Parts Connexion |  | Amazon Vin2
Mouser |  | Amazon Vin3
Tube Depot |  | Amazon Vin4
Amazon Vin1 |  | EBAY Vin1
Amazon Vin2 |  | EBAY Vin2
Amazon Vin3 |  | EBAY Vin3
Amazon Vin4 |  | EBAY [NAME]
EBAY Vin1 |  | [NAME]
EBAY Vin2 |  | Mouser
EBAY Vin3 |  | Parts Connexion
EBAY [NAME] |  | PPT
S&S |  | S&S
PPT |  | Tube Depot
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 26

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-26 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1118 |  | 989 |  | 67694 |  |  |  |  |  |  | 32 | 1 | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 2 | 33
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7278 |  | 7278 |  | 67694 |  |  |  |  |  |  | 34 | 3 | 36
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 32 | 4 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 5 | 38
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 3060 |  | 2938 |  | 67694 |  |  |  |  |  |  | 36 | 6 | 37
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 33 | 7 | 34
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 37 | 8 | 38
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 36 | 9 | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 15 | 41
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 15568 |  | 13435 |  | 67694 |  |  |  |  |  |  | 35 | 35 | 32
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 32 | 39 | 31
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1563 |  | 1371 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1447 |  | 1523 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 11207 |  | 11207 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3090 |  | 2984 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 2473 |  | 2359 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4470 |  | 4611 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 848 |  | 1076 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 36 |  | 37 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20146 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69079 | 20596 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 777153d1650202446-looking-for-a-formula-to-transpose-data-from-one-table-to-another-schedule-template
Sheet: Sheet1

Template 1 |  |  |  |  | Template 2
 | 2022-04-01 00:00:00 | 2022-04-02 00:00:00 | 2022-04-03 00:00:00 |  |  | 2022-04-01 00:00:00 | 2022-04-02 00:00:00 | 2022-04-03 00:00:00
[NAME] | Day |  | Night |  | Day | [NAME] | [NAME] | [NAME]
[NAME] | Vacation | Vacation | Day |  | Swing | [NAME] | [NAME] | [NAME]
Mark | Night | Night |  |  | Night | Mark | Mark | [NAME]
[NAME] | Swing | Day | Day
[NAME] |  | Swing | Swing
Spreadsheet: 5dc2c654-2855-4bda-b8ee-fb5ad964d566
Sheet: Sheet1

Center Parcs National Schools Championships | Unnamed: 1
Results Return Sheet
Please fill in this sheet and return with a completed Results Table for each event.
Please return these results once the league has been completed (not following each round of matches)
By post:  National Schools Championhips, BADMINTON England, [NAME], MK8 9LA
By email:  [NAME]
League / County / Region round name:
Total number of schools participating:
Boys Yrs 7, 8 & 9 | No. of teams in event:
 | Winner (school name):
 | Contact name:
 | [NAME]:
 | Telephone:
Boys Yrs 10 & 11 | No. of teams in event:
 | Winner (school name):
 | Contact name:
 | [NAME]:
 | Telephone:
Girls Yrs 7, 8 & 9 | No. of teams in event:
 | Winner (school name):
 | Contact name:
 | [NAME]:
 | Telephone:
Girls Yrs 10 & 11 | No. of teams in event:
 | Winner (school name):
 | Contact name:
 | [NAME]:
 | Telephone:
Spreadsheet: 112338d1308498882-how-to-count-answers-of-respondents-excel-tna-final
Sheet: Charge Nurse

 | Respondent 1 |  |  |  |  |  | Respondent 2
Knowledge/Understanding of/Skills in/Attitude of | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5
Vision |  |  |  | X |  |  |  | X
Mission |  |  |  | X |  |  |  |  | X
Core Values |  |  |  | X |  |  |  |  |  | X
Total | 1 | 2 | 3 | 4 | 5
Vision
Mission
Core Values
 | How to:
 | 1. determine how many have answered "1" under the vision? Or how many answered "2"? "3"? And so on...
 | 2. determine how many have answered "1" under the mission? Or how many answered "2"? "3"? And so on...
Desired table
 | 1 | 2 | 3 | 4 | 5
Vision |  | 1 |  | 1
Mission |  |  | 1 | 1
Core Values |  |  |  | 2
Spreadsheet: 760518d1640265400-error-with-min-if-formula-book1
Sheet: Sheet1

[NAME] | C | 12.07
[NAME] | A | 9.49
GR-08 | C | 4.17
GR-08 | C | 2.45
GR-08 | C | 2.73
GR-09 | C | 49.56
GR-09 | C | 21.63
GR-01 | A | 154.84
GR-02 | A | 63
GR-03 | B | 174.57
GR-04 | C | 5.54
[NAME] | B | 26.26
GR-06 | B | 0.88
GR-07 | B | 13.89
GR-10 | A | 0.15
GR-11 | A | 0.1
GR-12 | C | 57.53