tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 121179d1315908424-if-formula-if-example
Sheet: Sheet1

Account | Cust Name | Post Code | 2000 | 4000 | 8000
1 | Customer 1 |  | 10 | 10 | 5
2 | Customer 2 |  | 5 |  | 5
3 | Customer 3 |  | 6 | 7 | 5
4 | Customer 4 |  |  | 20
5 | Customer 5 |  | 50 | 2 | 5
Example
Account | Cust Name | Post Code | 2000 | 4000 | 8000
1 | Customer 1 |  | 10 | 10 | 5
2 | Customer 2 |  | 5 |  | 5
3 | Customer 3 |  | 6 | 7 | 5
4 | Customer 4 |  |  | 20
5 | Customer 5 |  | 50 | 2 | 5
Spreadsheet: 484989d1476636565-fill-the-form-in-sheet3-using-data-from-sheet1-school-report
Sheet: العدل

 |  | [NAME]
 |  | [NAME] : | العين |  |  | [NAME] : | 337
 |  | المحطـة : | [NAME] |  |  | الحلقـــــــــــــــة : | ح2  /  بنين
 |  | المدرسة : | العدل |  |  | الرقم التسلسلي :
 | م | [NAME] | حجم الحافلة (عدد الركاب) | عدد الطلبة المنقولين | اسم السائق |  | عدد أيام الغياب (بدون توفير بديل)
 | 2 | B0004269 | 60 | 23 | حسين عبود سالم
 | 10 | B0009320 | 61 | 46 | حمزه محمد عفران
 | 3 | B0011462 | 60 | 64 | سايوة جول جمعه
 | 4 | B0005838 | 60 | 37 | سعيد محمد علي الصيعري
 | 5 | B0007057 | 60 | 35 | صلاح الدين فيرومال
 | 6 | B0007067 | 60 | 42 | عارف أحمد إسماعيل
 | 7 | B0006895 | 60 | 38 | عبدالرحمن سيد الله خان
 | 8 | B0017687 | 25 | 30 | عبدالهاشم [NAME]
 | 9 | B0021361 | 55 | 26 | سيدالله جان محمد علي خان
 | 11 | B0026572 | 26 | 15 | محمد الله داد الله داد
 | 1 | B0006910 | 60 | 49 | محمد جمال الدين
 | 12 | B0008032 | 61 | 57 | محمد زمان [NAME]
 | 13 | B0013141 | 61 | 52 | [NAME]
 | 14 | B0003198 | 60 | 46 | نذير أحمد دلبار
 | 15 | B0009446 | 61 | 40 | وحيدالله محمد جمشيد خان
 | الاجمالي
 | [NAME] المحطة |  |  |  |  |  | [NAME]
 | ............................. |  |  |  |  |  | .................................
 | ملخص شهادات انجاز خدمة النقل المدرسي ( للمدرسة )
 |  | [NAME] : |  |  |  | [NAME] :
 |  | المحطـــة : |  |  |  | الحلقـــــــــــــــــة :
 |  | المدرسـة : |  |  |  | [NAME] :
 |  |  |  |  |  | الوظيفة :
 | أولا:- الحافلات المدرسية
 | بيانات الحافلات المدرسية
 | م | البند |  |  | خط فردي | خط زوجي | الاجمالي
 | 1 | حافلة كبيرة |  |  | 0 | 13
 | 2 | حافلة صغيرة |  |  | 0 | 2
 | الاجمالي
 | [NAME] خدمة النقل المدرسي (من قبل المدرسة)
 | [NAME] خدمة النقل المدرسي
 | م
 | 1
 | 2
 | 3
 | 4
 | ثالثا:-  معالجة  الملاحظات  ( من قبل المحطة )
 | معالجة الملاحظات من قبل المحطة [NAME] خدمة النقل المدرسي
 | م
 | 1
 | 2
 | 3
 | 4
 | [NAME] المحطة |  |  |  |  | [NAME]
 | ............................. |  |  |  |  | .................................
Spreadsheet: 220420d1363155266-round-up-time-unless-already-at-the-desired-time-value-time-schedule-ans
Sheet: Sheet1

 |  | st time | end time |  | duration
 |  | 05:30:00 |  |  | 01:30:00
 |  |  |  |  | 00:20:00
 |  |  |  |  | 00:31:00
 |  |  |  |  | 02:00:00
 |  |  |  |  | 01:45:00
 |  |  |  |  | 00:00:01
Spreadsheet: 711688d1609850547-reversing-formula-breaks-if-input-too-long-reverse-sequence-gk-final
Sheet: Sheet1

Input Sequences | Sequence Output
[NAME]
A*rA*rCAGCTrAA*rA*rCA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCA*rA*rCAGCTrAA*rA*rCAGC*rCAGCTrAA*rA*rCAGCTrAA*rA*rCA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCA*rA*rCAGCTrAA*rATrAA*rA*rCAGCTrAA*rA*rCA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCA*rA*rCAGCTrAA*rA*rCAGC*rCAGCTrAA*rA*rCA
CAGCTrAA*rA*rCA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCA*rA*rCAGCTrAA*rA*rCAGC*rCAGCTrAA*rA*rCAGCTrAA*rA*rCA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCA*rA*rCAGCTrAA*rATrAA*rA*rCAGCTrAA*rA*rCA*rA*rCAGCTrAA*rA*rCAG
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 396694 | 399831
78311 | 144135 | 146400 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 384608 | 455615 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 439642 | 408292
500293 | 211101 | 243455
500302 |  | 3636
500303 |  | 10627
500305 | 606286 | 632358
500307 | 39914 | 23574
500313 |  | 1119
500314
500655 | 78474
500657 | 36695 | 12000
INDEX
2002-01-31 00:00:00 |  |  | 121616.94
2002-02-12 00:00:00
CBS Volume
 |  |  | 70652
Spreadsheet: 105623d1302907786-excel-2007-over-time-with-3-series-chart-issue
Sheet: nhart 2

date | APAC Switch Planned | APAC Switch Actual | APAC Router Planned | APAC Router Actual | NA Router Planned | NA Router Actual
2011-04-16 00:00:00 | 3 | 1
2011-04-20 00:00:00 |  | 3
2011-04-25 00:00:00 |  |  | 1 | 1
2011-04-28 00:00:00 |  |  | 2 | 2
2011-05-03 00:00:00 |  |  | 3
2011-05-05 00:00:00 |  |  | 4 | 3
2011-05-07 00:00:00 |  |  |  | 4 | 1 | 1
2011-05-14 00:00:00 |  |  |  |  | 4 | 4
2011-05-28 00:00:00 |  |  |  |  | 6 | 6
2011-06-04 00:00:00 | 4 | 4 |  |  | 7 | 7
2011-06-11 00:00:00 |  |  |  |  | 8 | 8
2011-07-04 00:00:00 | 5 | 5
2011-07-23 00:00:00 | 6 | 6
2011-07-24 00:00:00 | 7
2011-07-25 00:00:00 | 8
2011-07-26 00:00:00 | 9
2011-07-27 00:00:00 | 10 | 7
2011-07-28 00:00:00 | 11
2011-07-29 00:00:00 | 12 | 8
2011-07-30 00:00:00 | 13 | 9
2011-07-31 00:00:00 | 16 | 10
2011-08-06 00:00:00 | 17 | 11 |  |  | 9 | 9
Spreadsheet: 142558d1329913733-excel-2010-if-the-value-is-found-in-column-a-then-sum-the-amounts-in-cell-in-b-test-budget-spreadsheet
Sheet: Expense Sheet

 | Expense 2 Date
 | Item | Expense
 | Petrol | 300
 | Petrol | 300
 | Internet | 1000
 | Spares | 250
 | Spares | 150
 | Consumables | 90
 | Labor | 550
 | Spares | 230
 | Internet | 1000
 | Consumables | 50
 | Spares | 600
Spreadsheet: 106060d1303302548-fomula-for-selecting-text-algorithimspreadsheet-1-
Sheet: Sheet2

 |  |  | Which of these software titles and Instruments do you wish to have on PC ?
 |  |  | Gx Developer | Iconics – Genesis | Kepserver/ Linkmaster | LS2Win/ DL2e | Office 2010 | OS Weather | Spectroradiometer | Virtual Weather | WMR100N | WMR200
 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Min PC Operating Requirments:
Operating System: |  |  | Windows XP | Windows XP | Windows XP | Windows XP | Windows XP | Windows XP | Windows XP | Windows XP | Windows XP | Windows XP | Windows XP
Pentium CPU Processor: |  |  | 1 | 4 | 4 | 1 | 4 | 4 | 1 | 1 | 4 | 4 | 4
Min CPU Processor Speed : |  |  | 133 | 1000 | 2000 | 1000 | 500 | 1000 | 1000 | 1000 | 1000 | 1000 | 2000
RAM MB : |  |  | 32 | 512 | 1000 | 10 | 512 | 512 | 512 | 8 | 512 | 512 | 1000
HDD Memory GB: |  |  | 0.08 | 2 | 0.18 | 0.512 | 3.5 | 0.512 | 20 | 0.01 | 0.512 | 0.512 | 20
Display Resolution: |  |  | 800 x 600 | 800 x 600 | 800 x 600 | 800 x 600 | 1024 x 767 | 1024 x 767 | 1024 x 767 | 800 x 600 | 1024 x 767 | 1024 x 767 | 1024 x 767
DVD Drive: |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Serial Port: |  |  | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 7
USB Port: |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 3
Ethernet Port: |  |  | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Pointing Device: |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1
Spreadsheet: 811256d1672383668-finding-cell-of-large-function-large-address
Sheet: Sheet2

1 |  |  | Five Large Values | Cell Ref |  | Five Lowest Values | Cell Ref
Spreadsheet: mary_fischer__25613__32H
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  32H
COMPANY NAME  Williard, Inc.
ANALYSIS OF GOODWILL
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-00 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 6-30-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Goodwill |  | 40 |  | 365202 |  |  |  | -113488
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 42e67994-3ed6-4a6a-8463-3e757069a52d
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
FH7GM | Test | FH7GM | Herpesvirus 7 IgG and IgM Antibody Panel, IFA | Herpesvirus 7 IgG/IgM Ab Panel, IFA | IFA (Immunofluorescence Assay) | Serum, [NAME] |  |  |  |  | Draw blood in a red-top tube(s). (Serum gel tube(s) is acceptable.) Spin down and send 1 mL serum refrigerated. | 0.5 mL | Hemolysis:	Mild OK; Gross OK Thawing:	Warm OK; Cold OK Lipemia:	Mild OK; [NAME] OK Icterus:	NA Other:	NA | Reference Range:  IgG	<1:320 IgM	<1:20  Human Herpesvirus 7 (HHV-7), a close relative of HHV-6, is found in >85% of the population, with transmission occurring in early childhood. Like HHV-6, HHV-7 is a cause of exanthem subitum (roseola infantum). Due to the ubiquitous nature of HHV-7 infection, >80% of individuals in the general population exhibit HHV-7 IgG titers >or=1:20; however, only 5% of these individuals exhibit titers >1:320. Thus, HH-7 [NAME] titers > or = 1:320 are suggestive of recent HHV-7 infection. Detection of HHV-7 specific IgM is also indicative of recent infection.   Test Performed by:	Focus Diagnostics 			5785 Corporate Avenue 			Cypress, CA 90630-4750 | Thursday | 1 - 8 days | 3 - 21 days |  | Profile |  |  |  |  | Focus Diagnositics, Inc.
FH7GM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FH7GM | Result | Z3000 | Herpesvirus 7 IgG Antibody, IFA | Herpesvirus 7 IgG Antibody, IFA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FH7GM | Result | Z3001 | Herpesvirus 7 IgM Antibody, IFA | Herpesvirus 7 IgM Antibody, IFA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FH7GM | Billing Component | FH7GM |  | VIRUS ANTIBODY NOS |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86790
FH7GM | Billing Component | FH7GM |  | VIRUS ANTIBODY NOS |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86790
Spreadsheet: 883510d1732120504-calculating-percentage-returns-over-different-intervals-stock-returns
Sheet: Quarterly Returns

Date_T1 | 01/02/2024
Date_T2 | 11/18/2024 |  | 11/18/2024
 | Q1 | Q2 | Q3 | Q4
AMD
AVGO
NVDA
BRO
MMC
CMG
AAPL
MSFT
MA
V
MCO
BAC
JPM
COST
LULU
TSMC
TSLA
WKHS
SPY
VOO
Spreadsheet: 59965d1260478508-excel-2007-help-with-a-lookup-that-will-return-multiple-occurrences-multiple-occurrences
Sheet: List

Item No. | ID | Number | LOSID | Last Name | Status | File Name | Print Job | Servicer | Correspondent | Flags
1 | 161963 | 407196110 | 5 | DUFFY | Sent to Client | [NAME] | Generic | SERVICING, LP | CW | APP | 501 | 417
2 | 162498 | 430651643 | 5 | BECK | Sent to Client | [NAME] | Generic | SUB-SERVICER | CW
3 | 163018 | 458407747 | 5 | SANTIAGO | Sent to Client | [NAME] | Generic | SERVICING, LP | CW
Spreadsheet: 27119d1219976347-vlookups-with-multiple-returns-slob-generator
Sheet: Sheet2

25.08.2008                                                                                        Dynamic List Display                                                                                                   1
 | Material | Material Description | Batch | Stock Status | Quantity | Base UOM | Quantity | Alternative UOM | Stock Value | Shelf Life Expiratio | Storage Location | [NAME] | Remaining Shelf Life
 | 1111111 | product a | DAMAGED | S | 440 | PC | 36.667 | DZ | 1628 | 19.01.2009 | 330A | CLAIMS | -220
 | 1111111 | product a | DAMAGED | S | 110 | PC | 9.167 | DZ | 407 | 19.01.2009 | 330A | CLAIMS | -220
 | 1111111 | product a | 621 | S | 6192 | PC | 516 | DZ | 4705.92 | 19.01.2009 | 330A | HOL227/1 | -220
 | 1111111 | product a | 505 | O | 462 | PC | 38.5 | DZ | 545.16 | 03.02.2009 |  |  | -204
 | 1111111 | product a | 53887V | O | 124920 | PC | 124920 | PC | 32479.2 | 13.02.2009 |  |  | -194
 | 1111111 | product a | 225341 | O | 668.627 | T3 | 668.627 | T3 | 26196.81 | 19.02.2009 |  |  | -189
 | 2222222 | product b | 225340 | O | 0.09 | T3 | 0.09 | T3 | 3.53 | 19.02.2009 |  |  | -189
 | 2222222 | product b | 225339 | O | 9.444 | T3 | 9.444 | T3 | 370.02 | 19.02.2009 |  |  | -188
 | 2222222 | product b | 619 | S | 924 | PC | 77 | DZ | 3003 | 29.02.2009 | 330A | CARINGBAH | -179
 | 2222222 | product b | 176554 |  | 22500 | PC | 1875 | DZ | 62325 | 20.03.2009 | 330B |  | -158
 | 2222222 | product b | 621 | S | 960 | PC | 80 | DZ | 3120 | 22.05.2009 | 330A | HOL384/1 | -95
 | 2222222 | product b | 621 | S | 960 | PC | 80 | DZ | 3120 | 22.05.2009 | 330A | HOL383/1 | -95
 | 2222222 | product b | 621 | S | 960 | PC | 80 | DZ | 3120 | 22.05.2009 | 330A | [NAME] | -95
Spreadsheet: chris_germany__1764__090100winterload
Sheet: Dths-Load Curves

 |  |  |  | Dths -  Load Curves
Residential |  |  |  | Consumption
 | AGL | BGE | CMD | COH | CPA | CVA | MCON | NIP | NJN | WGLMD | WGLVA
NOV | 9.7592 | 8.905028827470005 | 8.33 | 13.2 | 9.5352 | 6.9972 | 14.2695 | 11.8047 | 11.9485 | 7.6636 | 6.896400000000001
DEC | 15.3032 | 13.16086860179375 | 8.33 | 20.4 | 9.8484 | 6.9972 | 19.98 | 17.2547 | 18.0895 | 7.6636 | 7.131600000000001
JAN | 17.5208 | 15.39808248365807 | 8.33 | 24 | 9.8484 | 6.9972 | 22.41 | 20.8953 | 22.379 | 7.6636 | 7.131600000000001
FEB | 13.86 | 12.60475632972878 | 8.33 | 20.4 | 8.8972 | 6.9972 | 19.845 | 16.35 | 17.963 | 7.6636 | 6.4428
MAR | 9.7152 | 10.42246551440649 | 8.33 | 15.6 | 9.8484 | 6.9972 | 16.929 | 13.6904 | 16.031 | 7.6636 | 7.131600000000001
APR | 5.0424 | 6.234232615193818 | 8.33 | 8.4 | 9.5352 | 6.9972 | 11.043 | 8.175 | 8.326 | 7.6636 | 6.896400000000001
 |  | 3725
Commercial |  |  |  | Consumption
 | AGL | BGE | CMD | COH | CPA | CVA | MCON | NIP? |  | WGLMD
NOV | 23.914 | 31.5 | 33.7365 | 28 | 15.618 | 30.4045 | 42.2885 | 224.4 |  | 20.825
DEC | 36.652 | 43.8 | 33.7365 | 42 | 16.131 | 30.4045 | 56.855 | 226.1 |  | 20.825
JAN | 41.756 | 49.8 | 33.7365 | 50.4 | 16.131 | 30.4045 | 63.03850000000001 | 244.8 |  | 20.825
FEB | 33.33 | 42.3 | 33.7365 | 46.2 | 14.573 | 30.4045 | 56.4815 | 204 |  | 20.825
MAR | 23.804 | 36 | 33.7365 | 37.8 | 16.131 | 30.4045 | 49.053 | 173.4 |  | 20.825
 |  | 106
NOV |  |  |  |  |  |  |  |  |  |  |  | 30
DEC |  |  |  |  |  |  |  |  |  |  |  | 31
JAN |  |  |  |  |  |  |  |  |  |  |  | 31
FEB |  |  |  |  |  |  |  |  |  |  |  | 28
MAR |  |  |  |  |  |  |  |  |  |  |  | 31
Spreadsheet: 805495d1668712031-if-a-number-goes-below-0-a-percentage-is-increased-to-increase-that-number-back-to-0-excel-help-formula-2
Sheet: Sheet2

Net Income | Owners Charges | Rate Increase |  | Owner Charges
 |  | 0.13 |  | Income | 500000
 |  |  |  | Extra Income | 200000
 |  |  |  | Expenses | -2000000
Current Owner Charges | Increase to Owner Charges | Projected Owner Charges
100000
300000
250000
150000
Spreadsheet: 255001d1375442809-how-to-lookup-value-based-on-date-time-closest-to-criteria-book12-ans
Sheet: Calls

ID | Description | Status | Start Time
425506981 | Some stuff DEF-126 More stuff | Acknowledge | 2013-06-11 00:44:06
425506978 | Some stuff DEF-126 More stuff | Acknowledge | 2013-06-05 19:24:16
425508283 | Some stuff DEF-126 More stuff | Closed | 2013-06-13 23:55:05
425508280 | Some stuff ABC-123 More stuff | Closed | 2013-06-01 00:28:32
425508377 | Some stuff DEF-126 More stuff | Acknowledge | 2013-06-14 23:19:47
425508361 | Some stuff ABC-123 More stuff | Acknowledge | 2013-06-17 23:52:27
425508724 | Some stuff ABC-123 More stuff | Acknowledge | 2013-06-05 16:40:47
425508721 | Some stuff ABC-123 More stuff | Acknowledge | 2013-06-05 20:37:47
425508902 | Some stuff DEF-126 More stuff | Closed | 2013-06-06 03:01:08
425508944 | Some stuff DEF-126 More stuff | Closed | 2013-06-06 02:59:38
425509551 | Some stuff ABC-123 More stuff | Closed | 2013-06-27 18:39:46
425509531 | Some stuff DEF-126 More stuff | Acknowledge | 2013-06-06 02:59:33
425509527 | Some stuff DEF-126 More stuff | Closed | 2013-06-06 02:59:27
425509521 | Some stuff ABC-123 More stuff | Acknowledge | 2013-06-27 19:12:40
425509505 | Some stuff DEF-126 More stuff | Closed | 2013-06-06 02:59:21
425509483 | Some stuff DEF-126 More stuff | Closed | 2013-06-27 19:24:11
425509468 | Some stuff ABC-123 More stuff | Acknowledge | 2013-06-06 02:59:15
425509450 | Some stuff DEF-126 More stuff | Closed | 2013-06-06 02:59:09
425509432 | Some stuff ABC-123 More stuff | Closed | 2013-06-01 02:57:30
425509415 | Some stuff DEF-126 More stuff | Closed | 2013-06-08 15:19:18
425509412 | Some stuff DEF-126 More stuff | Acknowledge | 2013-06-08 15:19:09
Spreadsheet: 144967d1331225396-how-to-count-duplicates-1-10-not-sum-dummy-modified-by-tigeravatar-
Sheet: Sheet2

Key | Count
1
5
6
7
8
9
1
5
5
4
4
4
1
1
35
0
0
48
8
Spreadsheet: 692611d1598463106-get-all-values-from-two-ranges-classeur3
Sheet: Feuil1

Status | Range 1
Current | Name 1
Current | Name 2
Ok | Name 3
Ok | Name 4
 |  |  |  | What I need: only the rows with Status "Ok" in A
 |  |  |  |  | All
 |  |  |  |  | Name 3
 |  |  |  |  | Name 4
 |  |  |  |  | Name 6
Status | Range 2
Current | Name 5
Ok | Name 6 |  |  |  | (No blank rows between values)
Not available | Name 7
Spreadsheet: 854175d1704146197-a-networkday-formula-that-excludes-holidays-and-multiple-leave-date-entries-by-employee-formula-play_with-expected-results-highlighted-in-yellow_v3
Sheet: Leave

employee | Start | end |  | Leave type
AS123 | 2024-02-11 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
AP345 | 2024-03-12 00:00:00 | 2024-03-19 00:00:00 |  | Recreational
AS123 | 2024-02-07 00:00:00 | 2024-02-10 00:00:00 |  | Sick without Pay - MC
AP346 | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | Leave without pay
[NAME] | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
AP345 | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
Spreadsheet: b40abb85-e492-4b56-a0f9-bf0bc57fe23e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
TO: | Chairperson
DATE:
Student's Name |  |  |  |  |  | Student's Number
Has received a semester grade of "I" in
 |  |  |  | Course Name and Number
for the |  |  |  | Semester of |  |  |  |  | .
Reason for the "I" Grade:
Summary/Calculation of Student's Grade/Average to date:
Explanation of specific course requirements to be completed for replacement of the "I" grade with a letter grade:
Alternate grade if requirements are not completed:
 |  |  | Signed:
 |  |  |  | Faculty Member
 |  |  | Signed:
 |  |  |  | Department Chair
Incomplete ("I") Grades Policy: |  |  | Incomplete grades indicate that the student has not met specific require-
ments in a course.  The instructor will report an "I" only for a student who is passing, who can complete the
assignments without additional instruction, and who can present a valid reason for not completing the work
during the semester.  The instructor must write a justification for the "I" and file a copy with the department
chairperson's office.  The justification must include the signature of the instructor, the specific requirements
to be completed, and precalculated grade in case the student does not fulfill the necessary assignments for
the completion of the course.  The "I" grade must be removed within one semester.
Spreadsheet: 680206d1590856023-auto-copy-filtered-list-data-to-another-sheet-book4
Sheet: Sheet1

 | SYMBOL | date | OPEN | HIGH | LOW | CLOSE | volume | con | TIMESTAMP
 | I want to auto copy following filtered list data of [NAME] to sheet1 from column B to G and column I
 | SYMBOL | date | OPEN | HIGH | LOW | CLOSE |  |  | TIMESTAMP
 | BBB | 2020-05-28 00:00:00 | 9068.9 | 9169.7 | 9046.15 | 9075.1 |  | -252825 | 2020-05-21 00:00:00
Spreadsheet: 90693d1290466949-comparing-2-columns-and-then-moving-a-third-data-point-if-2-other-data-points-match-get-id
Sheet: Sheet2

Customer First Name | Customer Last Name | Unique ID# |  | Fname,Lname
FName37 | [NAME] |  |  | FName26,LName26
FName31 | [NAME] |  |  | FName20,LName20
FName20 | LName20 | 20 |  | FName7,LName7
FName7 | LName7 | 7 |  | FName17,LName17
FName5 | LName5 | 5 |  | FName30,LName30
FName14 | [NAME] | 14 |  | FName27,LName27
FName12 | LName12 | 12 |  | FName9,LName9
FName29 | LName29 | 29 |  | FName3,LName3
FName34 | [NAME] |  |  | FName29,LName29
FName35 | LName35 |  |  | FName22,LName22
FName32 | LName32 |  |  | FName2,LName2
[NAME] | [NAME] |  |  | FName11,LName11
FName15 | LName15 | 15 |  | FName10,LName10
FName33 | LName33 |  |  | FName24,LName24
FName39 | [NAME] |  |  | FName19,LName19
FName1 | LName1 | 1 |  | FName6,LName6
FName25 | LName25 | 25 |  | FName23,LName23
FName22 | LName22 | 22 |  | FName21,LName21
FName38 | LName38 |  |  | FName16,LName16
FName8 | [NAME] | 8 |  | FName28,LName28
FName4 | LName4 | 4 |  | FName12,LName12
FName13 | LName13 | 13 |  | FName5,LName5
 |  |  |  | FName1,LName1
 |  |  |  | FName13,LName13
 |  |  |  | FName15,LName15
 |  |  |  | FName14,LName14
 |  |  |  | FName8,LName8
 |  |  |  | FName4,LName4
 |  |  |  | FName25,LName25
 |  |  |  | FName18,LName18
Spreadsheet: 746984d1631164505-count-and-return-numbering-of-each-item-table-1
Sheet: Sheet 1

Work order | [NAME] | Count | Numbering | Task
16896634 | WHATALEC |  | 1
16900570 | VAE |  | 1
16900716 | CMF |  | 1
16900594 | AE SMITH |  | 1
16896634 | CHUBB FIRE |  | 2
16896634 | CMF |  | 3
16900730 | CHUBB FIRE |  | 1
16900708 | CHUBB FIRE |  | 1
16900603 | HONEYWELL |  | 4
16900603 | SPD PLUMBING |  | 4
16900603 | VAE |  | 4
16900603 | HONEYWELL |  | 4
16903354 | CHUBB FIRE |  | 1
16903065 | HONEYWELL |  | 1
16903065 | HONEYWELL |  | 2
16903065 | AE SMITH |  | 3
16903642 | SPD PLUMBING |  | 1
16903642 | HONEYWELL |  | 2
16903642 | AE SMITH |  | 3
16904211 | VAE |  | 1
Spreadsheet: 711738d1609870795-pulling-one-of-multiple-headers-in-single-column-based-on-information-below-schedule-template-wip-5-
Sheet: Master Schedule

 | 2021-01-17 00:00:00
 | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa
Name 1 |  |  |  |  |  |  |  |  | p
Name 2 |  |  |  |  |  |  |  |  | a
Name 3 |  |  |  |  |  |  |  |  | P
Name 4 |  |  |  |  |  |  |  |  | A
Name 5 |  |  |  |  |  |  |  |  | P
Name 6 |  |  |  |  |  |  |  |  | A |  | a
Name 7 |  |  |  |  |  |  |  |  |  |  | a
Name 8 |  |  |  |  |  |  |  |  |  |  | p
Name 9 |  |  |  |  |  |  |  |  |  |  | p
Name 10 |  |  |  |  |  |  |  |  | a
Name 11 |  |  |  |  |  |  |  |  | a
Name 12 |  |  |  |  |  |  |  |  | a
Name 13 |  |  |  |  |  |  |  |  | a
Name 14 |  |  |  |  |  |  |  |  |  |  | p
Name 15 |  |  |  |  |  |  |  |  |  |  | p
Name 16 |  |  |  |  |  |  |  |  |  |  | a
Name 17 |  |  |  |  |  |  |  |  | A |  | a
Name 18 |  |  |  |  |  |  |  |  | P
Name 19 |  |  |  |  |  |  |  |  | P
Name 20 |  |  |  |  |  |  |  |  |  |  | a
Name 21 |  |  |  |  |  |  |  |  |  |  | a
Name 22 |  |  |  |  |  |  |  |  |  |  | a
Name 23 |  |  |  |  |  |  |  |  |  |  | a
Name 24 |  |  |  |  |  |  |  |  | A
Name 25 |  |  |  |  |  |  |  |  | P
Name 26
 | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa | S | M | T | W | TH | F | Sa
Name 27 |  |  |  |  |  |  |  |  |  |  | p
Name 28 |  |  |  |  |  |  |  |  |  |  | p
Name 29 |  |  |  |  |  |  |  |  |  |  | p
Name 30 |  |  |  |  |  |  |  |  | P
Name 31 |  |  |  |  |  |  |  |  | P
Name 32 |  |  |  |  |  |  |  |  | A
Name 33 |  |  |  |  |  |  |  |  | A
Name 34
Name 35 |  |  |  |  |  |  |  |  | A
Name 36 |  |  |  |  |  |  |  |  | A
Name 37 |  |  |  |  |  |  |  |  | P
Name 38 |  |  |  |  |  |  |  |  | P
Name 39 |  |  |  |  |  |  |  |  | P
Name 40 |  |  |  |  |  |  |  |  |  |  | a
Name 41
Name 42 |  |  |  |  |  |  |  |  | P
Name 43 |  |  |  |  |  |  |  |  | A
Name 44 |  |  |  |  |  |  |  |  | A
Name 45 |  |  |  |  |  |  |  |  | P
Name 46
Name 47 |  |  |  |  |  |  |  |  | A
Name 48
Name 49 |  |  |  |  |  |  |  |  | P
Name 50 |  |  |  |  |  |  |  |  | A
Name 51 |  |  |  |  |  |  |  |  | P
Name 52
Name 53 |  |  |  |  |  |  |  |  | A
Name 54
Name 55
Name 56
AM
PM