tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 118124d1313480811-conditional-statement-krish
Sheet: Sheet2

 | I ST LINKAGE
 | SHPI SCORE | SHG SCORE
 |  | 75-89 | 90-94 | >94
 | 70-80 | 6 TIMES OR 4000 PER MEMBER | 6TIMES OR 4500 | 6 TIMES OR 5000
 | 81-90 | 6 TIMES OR 4500 | 6 TIMES OR 5000 | 6 TIMES OR 5500
 | 91-100 | 6 TIMES OR 5000 | 6 TIMES OR 5500 | 6 TIMES OR 6000
 | 2ND LINKAGE
 | 70-80 | 2 TIMS THE IST WITH PRIVATE OR 3 TIMES THE FIRST LNKAGE PSU LIMIT OF 125000 | 150000 | 180000
 | 81-90 | 150000 | 180000 | 225000
 | 91-100 | 180000 | 225000 | 250000
 | 3RD LINKAGE
 | 70-80 | 2TIMES THE FIRST LINKAGE WITH PRIVATE OR 3 TIMES THE FIRST WITH PSU | 225000 | 250000
 | 81-90 | 225000 | 250000 | 275000
 | 91-100 | 250000 | 300000 | 350000
Spreadsheet: 0396838c-31b1-4256-a69a-c9f9ce2090b5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Crossroads of America Council | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  | Boy Scouts of America
 |  |  | 7125 Fall Creek Road North
 |  |  | Indianapolis, IN 46256
 |  |  | PH (317) 813-7070 / Fax (317) 813-7126
 |  |  | [EMAIL]
 |  |  | Boy Scout Uniform Order Form
 |  |  |  |  | Item Cost | SIZE | Quantity | Total Cost
 | [NAME] Short Sleeve Shirt
 | Youth | Medium & Large |  |  | 24.99
 | [NAME] | S,M,L,XL & XXL |  |  | 29.99
 | [NAME] | 3X |  |  | 32.99
 | [NAME] | 4X |  |  | 32.99
 | Nylon Short Sleeve Shirts are Available for $10.00 additional
 | Patches | Crossroads Shoulder Patch |  |  | 2.2
 |  | World Scouting Crest |  |  | 1.99
 |  | Unit Numbers ( 0 to 9) | Unit # __________ |  | $1.49 each
 |  | Shoulder Loops | Green |  | 2.99
 | Neckerchiefs | Screen Printed |  |  | 8.99
 |  | Embroidered |  |  | 9.99
 | Hats | Green | S/M   or    M/L |  | 12.99
 |  | Green | XL |  | 13.99
 | Slides | BS |  |  | 4.99
 | Belt | S/M |  |  | 10.99
 |  | M/L |  |  | 11.99
 |  | XL |  |  | 12.99
 | Pants | Youth size 8 to 22 (evens) | 6,8,10,12,14,16,18,20,22 |  | 34.99
 | Canvas | Husky size 32 to 36 ([NAME]) | 32H, 34H, 36H |  | 34.99
 |  | ADULT even by waist | 32-56 |  | 39.99
 | Pants | Youth S,M,L,XL |  |  | 44.99
 | Nylon | [NAME],M,L,XL,XXL,XXXL |  |  | 44.99
 | Socks | Ankle  (XS to L) | S, M, L, XL |  | 5.99
 |  | Crew   ([NAME] to L) | S, M, L, XL |  | 5.99
 | Book | BS Handbook | Soft Cover |  | 11.99
 |  | BS Handbook | Coil Bound |  | 16.99
 |  | BS Handbook Cover (soft/hard) | Black Fabric |  | 9.99
 |  | BS Handbook Cover (coil) | [NAME] |  | 9.99
 | Badge Adhesive | [NAME] |  |  | 8.99
 |  | FreeStyle |  |  | 8.99
 |  |  |  |  |  | Total Items/Sub Total: | 0 | 0
 | Other Items to be added to the order (not included in TOTAL COST) |  |  |  |  | Shipping Cost (see chart): |  | 0
 | Item # | Description |  |  |  | Total Cost: |  | 0
 | Name |  |  |  | Order Amount |  |  | Domestic Shipping Cost
 | Address |  |  |  | Up to $50 |  |  | 7.50
 | City, State |  |  |  | $50.01 to $100 |  |  | 9.95
 | Zip Code |  |  |  | $100.01 to $150 |  |  | 13.95
 | Telephone # |  |  |  | Over $150.01 |  |  | 8% of the total order
 | [NAME]
 | PRICES SUBJECT TO CHANGE : CURRENT AS OF 12/12/2013
Spreadsheet: bb8a3ae3-27f1-4862-957d-1fe8974bac61
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
TTGG | Test | TTGG | Tissue Transglutaminase (tTG) Antibody, IgG, Serum | Tissue Transglutaminase Ab, IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <6.0 U/mL (negative) 6.0-9.0 U/mL (weak positive) >9.0 U/mL (positive) Reference values apply to all ages. | Monday through Saturday; 4 p.m. | Same day/1 day | 4 days | 1 | 83516 |  |  |  |  | Rochester
TTGG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TTGG | Result | TTGG | Tissue Transglutaminase Ab, IgG, S | Tissue Transglutaminase Ab, IgG, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 56537-4 | Tissue transglutaminase Ab.IgG:ACnc:Pt:Ser:Qn:EIA
Spreadsheet: 98960d1297769316-lots-of-data-to-collate-and-remove-duplicates-example
Sheet: FINAL

 |  |  | The final sheet should look like this - however I would ideally like this so be automated somehow, either a macro or with links
 |  |  |  |  |  |  |  |  |  |  | Back | Forward |  | Back | Forward
 |  |  | Code1 |  |  |  |  |  |  |  | Figure | Figure |  | Code | Code
 |  |  | Code 1 |  |  |  |  |  |  |  | 9 | 22 |  | Code2 | Code2
 |  |  | Code 1
 |  |  | Code 1
 |  |  | Code 1
 |  |  | Code 1
 |  |  | Code2 |  |  |  |  |  |  |  | 22 | 9 |  | Code1 | Code1
 |  |  | Code2 |  |  |  |  |  |  |  | 10 |  |  | Code3
 |  |  | Code2
 |  |  | Code2
 |  |  | Code2
 |  |  | Code3 |  |  |  |  |  |  |  |  | 10 |  |  | Code2
 |  |  | Code3 |  |  |  |  |  |  |  | 10 | 5 |  | Code4 | Code4
 |  |  | Code3 |  |  |  |  |  |  |  | 22 | 4 |  | Code5 | Code5
 |  |  | Code3
 |  |  | Code3
 |  |  | Code4 |  |  |  |  |  |  |  | 5 | 10 |  | Code 3 | Code3
 |  |  | Code4 |  |  |  |  |  |  |  | 8 | 6 |  | Code5 | Code5 | NO MATCH
 |  |  | Code4
 |  |  | Code4
 |  |  | Code4
 |  |  | Code5 |  |  |  |  |  |  |  | 4 | 22 |  | Code3 | Code
 |  |  | Code5
 |  |  | Code5
 |  |  | Code5
 |  |  | Code5
Spreadsheet: 631444d1562672306-distance-between-coordinates-shown-in-a-sorted-list-pq-distances-aligw
Sheet: Desired Result

 |  |  | Location ID | x | y
 |  |  | [NAME]
 |  |  | Location ID | Coordinate X | Coordinate Y | Helper
 |  |  | RH992 | 665580 | 258800 | 0
 |  |  | [NAME] | 665470 | 258450 | 366.9
 |  |  | KO420 | 665069 | 259111 | 598.2
 |  |  | OL942 | 656550 | 256150 | 9410.8
 |  |  | HY675 | 655820 | 257720 | 9819.6
 |  |  | [NAME] | 656260 | 249240 | 13351.3
 |  |  | OR654 | 668855 | 245017 | 14166.7
 |  |  | DE902 | 668849 | 245006 | 14176.1
 |  |  | UB482 | 655642 | 247923 | 14733.4
 |  |  | LN392 | 671310 | 243990 | 15879.8
 |  |  | HF029 | 653510 | 246900 | 16949.8
 |  |  | RH392 | 653510 | 246900 | 16949.8
 |  |  | [NAME] | 647150 | 249980 | 20431.8
 |  |  | KH387 | 648322 | 246675 | 21091.6
 |  |  | PG343 | 646860 | 248249 | 21488.6
 |  |  | PL122 | 646860 | 248249 | 21488.6
 |  |  | LR012 | 645850 | 249150 | 21963.5
 |  |  | ES492 | 650560 | 236088 | 27229.3
 |  |  | DR029 | 638611 | 263271 | 27337.1
 |  |  | LK392 | 656622 | 232628 | 27662.6
 |  |  | NJ111 | 656622 | 232628 | 27662.6
 |  |  | WE942 | 637023 | 261981 | 28733.6
 |  |  | SD932 | 637023 | 261981 | 28733.6
 |  |  | PT940 | 643443 | 237911 | 30436.8
 |  |  | PY492 | 643443 | 237911 | 30436.8
 |  |  | DF392 | 633251 | 239845 | 37476.1
 |  |  | GF329 | 635070 | 236500 | 37790.9
 |  |  | KL329 | 635070 | 236500 | 37790.9
Spreadsheet: 286d92f4-a608-4d46-bcc7-8048115bc2fa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Název laboratoře:
 |  |  |  |  |  |  |  | IČ:
 | [NAME] laboratoře:
 | Protokol o zkoušce o analytickém rozboru vína č.
 | Firma:
 | [NAME], příjmení, titul: |  |  |  |  |  |  | IČ:
 | Ulice a číslo:
 | Obec a PSČ:
 | Druh vína: |  |  | Ročník: |  |  | Číslo šarže:
 | Datum přijetí vzorku: |  |  |  |  |  | Velikost šarže v l:
 | Výsledky rozborů:
 |  |  |  | Výsledek |  | [NAME] | Opakovatelnost |  | A/N | Metoda/kód
 | Skutečný obsah alkoholu |  |  |  |  | obj%
 | Celkový obsah alkoholu |  |  |  |  | obj%
 | [NAME] bezcukerného extraktu |  |  |  |  | g/l
 | [NAME] těkavých kyselin |  |  |  |  | meq/l
 | [NAME] |  |  |  |  | mg/l
 | Celkový obsah SO2 |  |  |  |  | mg/l
 | Redukující látky |  |  |  |  | g/l
 | Cukr (fruktóza+glukóza) |  |  |  |  | g/l
 | Celkový obsah kyselin |  |  |  |  | g/l
 | Sacharóza |  |  |  |  | g/l
 | Hustota relativní
 | [NAME] |  |  |  |  | MPa
 | Cukr (fruktóza+glukóza+sacharóza) |  |  |  |  | g/l
 | Protokol verze 2.5V      aktualizace 1.12.2010 |  | Ve sloupci A/N znamená A=metoda akreditovaná, N=[NAME]
 | Datum vystavení: |  |  | [NAME] pracovník:
 |  |  |  | (razítko, podpis)
 | 4
Spreadsheet: 788190d1658318402-extracting-names-into-respective-columns-name_extraction
Sheet: Sheet1

Full Name | First Name | Middle Name (s) | Surname | Suffix
[NAME]
Carola Maria Häggkvist
Charli [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Delta [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Hannibal
[NAME]
[NAME]
[NAME]
[NAME]
Addison Rae Easterling
[NAME]
Colton [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] Justice
[NAME]
[NAME], Jr.
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] Shor Lynch
[NAME]
[NAME]
[NAME]
[NAME]
Peyton Roi List
[NAME]
[NAME]
[NAME]
Gaius Julius Caesar
Spreadsheet: susan_pereira__39452__ENRON
Sheet: ENRON

 | VARIBUS CORPORATION |  |  |  |  |  |  |  | JULY 31, 1999 |  |  |  |  |  |  | {SERVICES}PSNU~QAGQ
 | P.O. BOX 61000
 | NEW ORLEANS, LA 70161 |  |  |  |  |  | INVOICE NUMBER |  |  |  |  | 99-07-09
 | PH# (504)576-4152
 | IN ACCOUNT WITH
 | ENRON CAPITAL & TRADE RESOURCE CORP. |  |  |  |  |  |  |  | AMOUNT
 | Attn: [NAME]
 | 1400 SMITH, SUITE 3707
 | Houston, Texas 77002
 |  |  |  |  |  | PER
MMBTU'S |  |  | [NAME] |  |  | MMBTU |  |  |  |  |  | AMOUNT
529999 |  |  | Natural Gas Transported to |  |  | 0.03 |  |  |  |  |  | 15899.97
 |  |  | GSU at [NAME] in
 |  |  | June 1999 (TETCO)
 |  |  | Contact Person
 |  |  | Accounting Question
 |  |  | [NAME]Ph# (504)576-4152
 |  |  | Operational Questions
 |  |  | [NAME] Ph# (281)297-3553
 |  |  |  | TOTAL AMOUNT DUE
 | PLEASE REMIT TO:
 | VARIBUS
 | P.O. BOX 61000
 | NEW  ORLEANS, LA.   70161
 | Attn: [NAME]
Spreadsheet: michelle_lokay__26550__tahoe
Sheet: Sheet1

LAKE TAHOE
CUSTOMER FORUM
FEBRUARY 7-14, 2001
 |  |  |  |  | ARRIVAL | ARRIVAL INFORMATION | DEPARTURE | [NAME].
NAME | COMPANY | 02/07-10/01 | 02/11-14/01 | PHONE NUMBER | DATE | FLIGHT #,  TIME, AIRLINE | DATE | FLIGHT #,  TIME, AIRLINE
Attendees for February 7-11, 2001
[NAME] | Proaliance | X |  | [PHONE] | 2001-02-07 00:00:00 | Amer. Air #1589Q  10:54 a.m. | 2001-02-09 00:00:00 | Amer. Air #1530N  11:55 p.m.
[NAME] | Pudget Sound | X |  | [PHONE] | 2001-02-07 00:00:00 | Alaska #604  9:00 a.m. | 2001-02-09 00:00:00 | Alaska #--- 7:28 p.m.
[NAME] | Tanswestern | X |  | [PHONE] | 2001-02-07 00:00:00 | SW #1389  11:45 a.m. | 2001-02-09 00:00:00 | SW #688  12:10 p.m.
Les Munch | Midwest Energy | X |  | [PHONE] | 2001-02-07 00:00:00 | SW #372/1380   11:45 a.m. | 2001-02-10 00:00:00 | SW #82  8:00 a.m.
[NAME] | NGPL | X |  | [PHONE] | 2001-02-07 00:00:00 | Continental #1637  11:26 a.m. | 2001-02-10 00:00:00 | Continental #1880  11:55 a.m.
[NAME] | [NAME] | X |  | [PHONE] | 2001-02-07 00:00:00 | SW #1389  11:45 a.m. | 2001-02-10 00:00:00 | SW #688  12:10 p.m.
[NAME] | ONEOK | X |  | [PHONE] | 2001-02-07 00:00:00 | UA #1541  12:53 p.m. | 2001-02-10 00:00:00 | UA #2433 12:50 p.m.
[NAME] | ONEOK | X |  | 5143 | 2001-02-07 00:00:00 | SW #747/1389  11:45 a.m. | 2001-02-10 00:00:00 | SW#182   8:00 a.m.
[NAME] | ONEOK | X |  | 5176 | 2001-02-07 00:00:00 | SW #747/1389  11:45 a.m. | 2001-02-11 00:00:00 | ONEOK Plane  12:00 p.m.
[NAME] | ONEOK | X |  | 5075 | 2001-02-07 00:00:00 | SW #747/1389  11:45 a.m. | 2001-02-11 00:00:00 | ONEOK Plane  12:00 p.m.
[NAME] | SoCal | X |  | [PHONE] | 2001-02-08 00:00:00 | SW #399   7:15 p.m. | 2001-02-09 00:00:00 | SW #289  6:55 p.m.
[NAME] | ONEOK | X |  | 5168 | 2001-02-08 00:00:00 | Delta #3969  6:49 p.m. | 2001-02-11 00:00:00 | ONEOK Plane  12:00 p.m.
Spreadsheet: 685285d1593879942-fill-blanks-from-other-tabs-holiday-chart
Sheet: January

Name | Site |  |  | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 2021-01-09 00:00:00 | 2021-01-10 00:00:00 | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00 | 2021-01-15 00:00:00 | 2021-01-16 00:00:00 | 2021-01-17 00:00:00 | 2021-01-18 00:00:00 | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-01-23 00:00:00 | 2021-01-24 00:00:00 | 2021-01-25 00:00:00 | 2021-01-26 00:00:00 | 2021-01-27 00:00:00 | 2021-01-28 00:00:00 | 2021-01-29 00:00:00 | 2021-01-30 00:00:00 | 2021-01-31 00:00:00 | Total holidays | Total sick days | Total training days | Total days in lieu | Total weekend working
A Sample | [NAME]
B
C
D
E
F
G
H
I
Spreadsheet: 726044d1617026916-pulling-data-at-the-end-of-a-business-day-sample
Sheet: RECURRING TABLE

Resignations | Last Week | This Week
Campus | # of Resignations | # of Resignations
School 1 | 2 | 1
School 2 | 5 | 2
School 3 | 3 | 2
School 4 | 6 | 9
School 5 | 8 | 2
School 6 | 1 | 3
School 7 | 9 | 4
School 8 | 2
School 9 | 3 | 8
School 10 | 4 | 6
School 11 | 6 | 1
School 12 | 8 | 6
School 13 | 6 | 2
School 14 | 1 | 2
School 15 | 6 | 6
School 16 | 2 | 5
School 17 | 2 | 9
School 18 | 6 | 4
School 19 | 5 | 1
School 20 | 9 | 1
School 21 | 4 | 3
School 22 | 1 | 5
School 23 | 1 | 8
TOTAL
Spreadsheet: 718101d1612982018-seeing-if-one-cell-contains-the-value-of-another-cell-test_problem1
Sheet: Sheet1

Column1 | Column2 | Solution
01 | A42342-4342/01
01 | BFJNFW-4238/02
04 | [NAME]
01 | DVFRC-312N8/01
02 | [NAME]
01 | OEGHT34-NFI3ND/02-OFT
01 | HGDKTO-32EN2352345/01
01 | GJD32N-34NFJ3KD/01
03 | FNFJFOEITDC-123213J/03
02 | 832r2f28hf2-123BFBFB/00/02
01 | SC-42018-AA-600/00/01
04 | 238irh32h-9393/00/02
Spreadsheet: 798570d1664555591-sumproduct-arrays-different-size-match
Sheet: match-1array

UNMATCH |  | (check existing grades) |  | =SUMPRODUCT((1*ISNA(MATCH(A5:A1000,E5:E8,0))=1)*(A5:A1000<>"")*1) |  |  |  |  |  | case-unsensitive
 |  |  |  | =REDUCE(0,FILTER(A5:A1000,A5:A1000<>""),LAMBDA(a,b,a+ISNA(MATCH(TRUE,EXACT(b,E5:E8),0)))) |  |  |  |  |  | case-sensitive
grade |  |  |  | grade
A |  |  |  | A
A |  |  |  | B
B |  |  |  | b
C |  |  |  | C
D
a
F
A
A
B
B
D
A
B
Spreadsheet: 5a270909-2879-4623-bbc2-bd7c9e52e507
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
09/05/2009 | Women's Cross Country | at Maryland Eastern Shore | Results
10/12/2009 | Women's Cross Country | at Paul Short Invitational (Bethlehem, Pa.) | Results
10/16/2009 | Women's Cross Country | at Penn State National Open | Results
10/31/2009 | Women's Cross Country | at Big East Championships (Kenosha, Wisc.) | Results
11/14/2009 | Women's Cross Country | at NCAA Regionals (Princess Anne, Md.) | Results
11/21/2009 | Women's Cross Country | at ECAC Championships (New York, N.Y.) | Results
11/23/2009 | Women's Cross Country | at NCAA Championships (Terre Haute, Ind.) | Results
02/06/2010 | Women's Cross Country | at USA National Cross Country Championships (Spokane, Wash.) | all day
Spreadsheet: 129596d1321727333-applying-name-range-excel-2007-lowestpricesexcludingshanghai1
Sheet: Raw data

Part Code | Supplier | Supplier Location | Cost |  | [NAME] | [NAME]
AAA1 | ALP | Xiamen | 5.5 |  |  | AAA1 - $5.5 - ALP
AAA1 | DSB | Xiamen | 5.3 |  |  | AAA1 - $5.3 - DSB
AAA1 | STA | Shenzhen | 5.4 |  |  | AAA1 - $5.4 - STA |  | Supplier Location | (All)
AAA1 | AOS | Shanghai | 4.1 |  |  | AAA1 - $4.1 - AOS
BBB1 | ALP | Xiamen | 9.8 |  |  | BBB1 - $9.8 - ALP |  | Row Labels | Min of Cost
BBB1 | DSB | Xiamen | 10.5 |  |  | BBB1 - $10.5 - DSB |  | AAA1 | 4.1
BBB1 | AOS | Shanghai | 10.2 |  |  | BBB1 - $10.2 - AOS |  | AAA2 | 5.5
BBB1 | STA | Shenzhen | 7.5 |  |  | BBB1 - $7.5 - STA |  | AAA3 | 5.3
CCC1 | ALP | Xiamen | 4.5 |  |  | CCC1 - $4.5 - ALP |  | AAA4 | 5.4
CCC1 | DSB | Xiamen | 6.4 |  |  | CCC1 - $6.4 - DSB |  | AAA5 | 4.1
CCC1 | AOS | Shanghai | 3.55 |  |  | CCC1 - $3.55 - AOS |  | AB-CCC2-BS | 6.4
CCC1 | STA | Shenzhen | 5.33 |  |  | CCC1 - $5.33 - STA |  | [NAME] | 3.55
CCC1 | LUC | Guangdong | 3.44 |  |  | CCC1 - $3.44 - LUC |  | BBB1 | 7.5
AAA2 | ALP | Xiamen | 5.5 |  |  | AAA2 - $5.5 - ALP |  | BBB10 | 7.5
AAA3 | DSB | Xiamen | 5.3 |  |  | AAA3 - $5.3 - DSB |  | BBB3 | 9.8
AAA4 | STA | Shenzhen | 5.4 |  |  | AAA4 - $5.4 - STA |  | BBB5 | 10.5
AAA5 | AOS | Shanghai | 4.1 |  |  | AAA5 - $4.1 - AOS |  | CB-CCC1 | 4.5
BBB3 | ALP | Xiamen | 9.8 |  |  | BBB3 - $9.8 - ALP |  | CCC1 | 3.44
BBB5 | DSB | Xiamen | 10.5 |  |  | BBB5 - $10.5 - DSB |  | Grand Total | 3.44
BBB10 | AOS | Shanghai | 10.32 |  |  | BBB10 - $10.32 - AOS
BBB10 | STA | Shenzhen | 7.5 |  |  | BBB10 - $7.5 - STA
CB-CCC1 | ALP | Xiamen | 4.5 |  |  | CB-CCC1 - $4.5 - ALP
AB-CCC2-BS | DSB | Xiamen | 6.4 |  |  | AB-CCC2-BS - $6.4 - DSB
[NAME] | AOS | Shanghai | 3.55 |  |  | ABCCC3AB - $3.55 - AOS
 |  |  |  |  |  |  | See Final Cost Sheet
Spreadsheet: 156447d1337288341-pseudo-hlookup-to-autofill-adjacent-cells-dynamically-test
Sheet: Applications

Application | ACM | DMC | CAL | EHM
Various Things | E:\sql2000\mssql\data\*.* /EXCLUDE | C:\WINDOWS\system32\drivers\etc\services | D:\Program Files\OPCcalc\*.* | E:\3500\Trains\Primcfg\*.*
Various Things | F:\sql2000\mssql\backup\*.* | E:\Program Files\AspenTech\CIM-IO\etc\cimio_logical_devices.def |  | F:\SQL2005\MSSQL\BACKUP\*.*
Various Things | F:\sql2000\mssql\tranlog\*.* /EXCLUDE | E:\Program Files\AspenTech\AC Online\app\*.*
 | G:\sql2000\mssql\data\*.* /EXCLUDE | E:\Program Files\AspenTech\AC Online\app\composite\*.*
 |  | E:\Program Files\AspenTech\DMCplus Desktop\Templates\*.*
Spreadsheet: 831011d1685355056-enter-units-of-measurements-alongside-values-in-a-workbook-differentiated-by-colors-enter-kgs-in-green-cell
Sheet: Without Formula

 |  |  |  | 2 | 2 | 15 | 15 | 1 | 5 | 5 | 45 | 15 | 15
 |  |  |  | 2 | 2 | 5 | 5 | 45 | 2 | 2 | 2 | 5 | 5
 |  |  |  | 0.13 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  | 3132 | 2131 | 2 | 2 | 2 | 0.13 | 0.13 | 1 | 2 | 2
 |  |  |  | 89 | 1 | 2 | 2 | 1 | 3132 | 3132 | 2131 | 253 | 253
 |  |  |  | 253 | 1 | 0.13 | 1 | 2131 | 89 | 89 | 1 | 15 | 15
 |  |  |  | 15 | 1 | 3132 | 2131 | 1 | 253 | 253 | 1 | 5 | 5
 |  |  |  | 253 | 1 | 89 | 1 | 1 | 15 | 15 | 1 | 2 | 2
 |  |  |  | 2 | 1 | 253 | 1 | 2131 | 5 | 5 | 45 | 2 | 2
 |  |  |  | 5 | 45 | 15 | 1 | 1 | 2 | 253 | 253 | 1 | 253
 |  |  |  | 2 | 2 | 253 | 253 | 1 | 2 | 15 | 15 | 1 | 15
 |  |  |  | 2 | 2 | 15 | 15 | 1 | 0.13 | 5 | 5 | 45 | 5
 |  |  |  | 15 | 1 | 5 | 5 | 45 | 3132 | 2 | 2 | 2 | 2
 |  |  |  | 15 | 1 | 2 | 2 | 2 | 89 | 2 | 2 | 2 | 2
 |  |  |  | 5 | 45 | 2 | 2 | 2 | 253 | 253 | 1 | 2 | 2
 |  |  |  | 2 | 2 | 253 | 1 | 253 | 1 | 5 | 253 | 1 | 5
Spreadsheet: 64687b70-1472-4d93-bbe1-c89b60f1562a
Sheet: Newark

REGIONAL DIRECTORY 2014/2015
NEWARK UNIFIED SCHOOL DISTRICT
[NAME], Superintendent | [NAME], Coordinator of Student Development and Pupil Services | [NAME], Student Development Technician
5715 Musick Avenue | 5715 Musick Avenue | 5715 Musick Avenue
Newark, CA 94560 | Newark, CA 94560 | Newark, CA 94560
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
[NAME], Regional Community Liaison
O: [PHONE]
C: [PHONE]
[EMAIL]
Spreadsheet: 32183d1228278120-extract-data-based-on-date-test
Sheet: Sheet1

Date | Journey Log # | Sector | Block Hrs | Flight Hrs | Duty Time | Cyles | TTAF | AFL |  | Last 7 Days | Last 28 Days | Last 365 Days | Diff from Today | Last 7 Days | Last 28 Days | Last 365 Days
2008-10-09 00:00:00 | 120 | PHOG-NSFA | 6 | 5.9 |  | 1 | 5.9 | 1 |  | 0 | 0 | 5.9 | 54 | 5.9 | 5.9 | 5.9
2008-10-10 00:00:00 |  | NSFA-NZAA | 4.4 | 4.1 |  | 1 | 10 | 2 |  | 0 | 0 | 4.1 | 53 | 10 | 10 | 10
2008-10-16 00:00:00 | 121 | NZAA-YSSY | 3.4 | 3.2 |  | 1 | 13.2 | 3 |  | 0 | 0 | 3.2 | 47 | 7.3 | 13.2 | 13.2
2008-10-17 00:00:00 |  | YSSY-NZAA | 3.1 | 2.9 |  | 1 | 16.1 | 4 |  | 0 | 0 | 2.9 | 46 | 6.1 | 16.1 | 16.1
2008-10-29 00:00:00 | 122 | NZAA-NZNR | 0.7 | 0.6 |  | 1 | 16.7 | 5 |  | 0 | 0 | 0.6 | 34 | 0.6 | 16.7 | 16.7
2008-10-29 00:00:00 |  | NZNR-NZAA | 0.8 | 0.6 |  | 1 | 17.3 | 6 |  | 0 | 0 | 0.6 | 34 | 1.2 | 17.3 | 17.3
2008-10-30 00:00:00 | 123 | NZAA-NZNR | 0.75 | 0.6 |  | 1 | 17.9 | 7 |  | 0 | 0 | 0.6 | 33 | 1.8 | 17.9 | 17.9
2008-10-30 00:00:00 |  | NZNR-NZQN | 1.7 | 1.6 |  | 1 | 19.5 | 8 |  | 0 | 0 | 1.6 | 33 | 3.4 | 19.5 | 19.5
2008-11-01 00:00:00 |  | NZQN-NZAA | 1.7 | 1.5 |  | 1 | 21 | 9 |  | 0 | 0 | 1.5 | 31 | 4.9 | 21 | 21
2008-11-02 00:00:00 | 124 | NZAA-NSFA | 4.25 | 4.1 |  | 1 | 25.1 | 10 |  | 0 | 0 | 4.1 | 30 | 9 | 25.1 | 25.1
2008-11-02 00:00:00 |  | NSFA-PHOG | 5.1 | 5.5 |  | 1 | 30.6 | 11 |  | 0 | 0 | 5.5 | 30 | 14.5 | 30.6 | 30.6
2008-11-05 00:00:00 |  | PHOG-KLAS | 6.1 | 5.9 |  | 1 | 36.5 | 12 |  | 0 | 5.9 | 5.9 | 27 | 19.2 | 36.5 | 36.5
2008-11-05 00:00:00 |  | KLAS-KICT | 2.25 | 2.1 |  | 1 | 38.6 | 13 |  | 0 | 2.1 | 2.1 | 27 | 21.3 | 38.6 | 38.6
2008-11-05 00:00:00 | 125 | [NAME] | 1 | 0.9 |  | 1 | 39.5 | 14 |  | 0 | 0.9 | 0.9 | 27 | 22.2 | 39.5 | 39.5
2008-11-11 00:00:00 | 126 | [NAME] | 1.4 | 1.2 |  | 1 | 40.7 | 15 |  | 0 | 1.2 | 1.2 | 21 | 10.1 | 30.7 | 40.7
2008-11-12 00:00:00 |  | [NAME] | 4.1 | 4 |  | 1 | 44.7 | 16 |  | 0 | 4 | 4 | 20 | 5.2 | 34.7 | 44.7
2008-11-14 00:00:00 |  | MMTO-KSDM | 3.75 | 3.3 |  | 1 | 48 | 17 | 0 | 0 | 3.3 | 3.3 | 18 | 8.5 | 31.9 | 48
2008-11-15 00:00:00 |  | KSDM-KSNS | 1.1 | 1 |  | 1 | 49 | 18 |  | 0 | 1 | 1 | 17 | 9.5 | 32.9 | 49
2008-11-29 00:00:00 | 127 | KSNS-PHOG | 5.7 | 5.5 |  | 1 | 54.5 | 19 |  | 5.5 | 5.5 | 5.5 | 3 | 5.5 | 33.5 | 54.5
2008-11-30 00:00:00 |  | PHOG-NSFA | 6.5 | 6.3 |  | 1 | 60.8 | 20 | 6.3 | 6.3 | 6.3 | 6.3 | 2 | 11.8 | 30.2 | 60.8
2008-12-01 00:00:00 |  | NSFA-NZAA | 4.5 | 4.4 |  | 1 | 65.2 | 21 |  | 4.4 | 4.4 | 4.4 | 1 | 16.2 | 34.6 | 65.2
2008-12-02 00:00:00 |  | NSFA-NZAA | 4.5 | 4.4 |  | 1 | 69.60000000000001 | 22 |  | 4.4 | 4.4 | 4.4 | 0 | 20.6 | 39 | 69.60000000000001
Spreadsheet: 860153d1708360367-need-help-with-rag-status-for-multiple-projects-project-kpi-status
Sheet: Overall Project Status

Overall Project Status
Project Name | 2023-12-01 00:00:00 | 2024-01-24 00:00:00 | 2024-02-24 00:00:00 | 2024-03-24 00:00:00 | 2024-04-24 00:00:00 | 2024-05-24 00:00:00 | 2024-06-24 00:00:00 | 2024-07-24 00:00:00 | 2024-08-24 00:00:00 | 2024-09-24 00:00:00 | 2024-10-24 00:00:00 | 2024-11-24 00:00:00 | 2024-12-24 00:00:00
Project-1
Project-2
Project-3
Project-4
Project-5
Project-6
Overall Status Key:
Below rules apply to the Overall Project Status (see table above), [NAME] sheet 'Project KPIs' for individual project KPIs
RED | If any KPI is red, overall project is Red
AMBER | If any KPI is amber, overall project is amber
GREEN | If all KPIs are green, overall project status is Green
Spreadsheet: 0c59408c-0bcd-4d33-9825-9e19a78bd415
Sheet: Sheet1

CONTACT:
[NAME]
PA Department of Education
Division of Data Services
333 Market Street
Harrisburg, PA  17126-0333
[NAME]:  [EMAIL]
Phone:  (717) 787-2644
Fax:  (717) 787-3148
Text Telephone TTY:  (717) 783-8445
This workbook contains 2009-10 enrollment and dropout data for publicly funded schools in Pennsylvania as reported by school districts, comprehensive area vocational-technical schools, charter schools, and special program jointures.
DEFINITIONS:
SECONDARY UNGRADED (SUG) - Full-time secondary nongraded programs including ungraded special education.
Data used in calculating dropout rates was collected via the Pennsylvania Information Management System (PIMS).  These instruments provided a “snapshot” of the fall enrollment in grades 7 through 12 and the total number of dropouts in those grades throughout a single school year.  The following definitions apply:
DROPOUT – A student who, for any reason other than death, leaves school before graduation without transferring to another school/institution.
DROPOUT RATE – An annual or “event” rate that measures the proportion of students enrolled who drop out during a single school year.  The total number of dropouts for the school year is divided by the fall enrollment for the same year.
LEA Type codes are:
CTC - Comprehensive CTC
CS - Charter School
SD - School District
2011-04-05 00:00:00
Source: Pennsylvania Information Management System (PIMS)