tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 552013d1513259811-delete-all-the-values-that-are-to-the-right-side-with-respect-to-a-value-that-is-stated-illustration-2
Sheet: Illustration2

SL No | Sequences | Output |  | Lookup Table
1 | A1-D1;A3-1VG;A7-GH7;A2-L0;A8-P0;A5-5L;A2C-JU8 |  |  | A2
2 | A3-F4;A9-K5;A1-9JG;A6-K0;A5-I0;A2C-JU8;A7-9UI;A4-UI8;B2-UI6 |  |  | A2C
3 | A5-G7;A7-J8;A1-5P;A4-B8I;B2-UI8;A0-H7;G-KL0 |  |  | B2
4 | A6-H9;A3-KL0;BA2-L1;A1-OP |  |  | BA2
5 | A5-L5;A4-J7;A6-K9;E2-UI8;A9-J9;A7-K4;B2-L0 |  |  | C2
6 | [NAME] |  |  | C2AD
7 | A4-Z4;C2AD-N8;A3-H9 |  |  | C
8 | A0-G6;A1-S4;C-GH7 |  |  | D2
9 | A5-G8;A6-H7;A2-J8;A8-L0;GF2-FG6;D2-MK0;A0-H0;A1-L0 |  |  | D2C
10 | A0-VY6;A3-K0;A5-AD4;D2C-MN8;A7-9O;A8-G6 |  |  | AD2
11 | [NAME] |  |  | E2
12 | A3-F4;A9-K5;A1-9JG;A6-K0;A5-I0;AD2-JU8;A7-9UI;EF2-UI8;A8-UI6 |  |  | EF2
13 | A5-GU7;A6-H7S;A7-J8;A8-L0;A9-FG6;D2-MK0;A0-H0;A1-L0 |  |  | F2
14 | A1-N8;A4-K19;E2-H7;A7-J8;A8-B7;AG23-J0;A5-C8 |  |  | FZ2
15 | A4-BV7;A6-N7;A2-C5;A1-M9;EF2-NV7;A3-O3;A0-C6 |  |  | AG23
16 | A3-F4;A9-K5;A1-9JG;A6-K0;A5-I0;E2-JU8;A7-9UI;A4-UI8;A8-UI6 |  |  | G2
17 | [NAME] |  |  | GF2
18 | A4-BV7;A6-N7;A5-C5;A1-M9;F2-NV7;A3-O3;A0-C6 |  |  | G
19 | A0-F7;A2-V6;A8-BN8;FZ2-JU8;A1-N5
20 | A3-F4;A9-K5;A1-9JG;A6-K0;A5-I0;F2-JU8;A7-9UI;A2C-UI8;A8-UI6
21 | [NAME]
22 | A5-G8;A6-H7;A7-J8;A8-L0;A9-FG6;AG23-MK0;A0-H0;A1-L0
23 | A4-BV7;A6-N7;A5-C5;D2C-M9;G2-NV7;A3-O3;A0-C6
24 | [NAME]
25 | A6-H9;A3-KL0;G-L1;A1-OP
Note: I have filled the Column "Output" (i.e. Column C) manually. I have retained only those values which are to the left of red coloured one's and including red coloured one's. To the right of the red coloured one's must be deleted.
Spreadsheet: kate_symes__18207__Deal Correction 3-7
Sheet: Current Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-03-07 00:00:00 | 2001-03-07 00:00:00 | 2001-03-05 00:00:00 | STNW | SC | Houston | N/A | Price: from 350 to 360 |  | 537565 | MID-C | 2001-03-06 00:00:00 | On [NAME] | 25 | 360 | Seattle City
 | 2001-03-07 00:00:00 | 2001-03-07 00:00:00 | 2001-03-06 00:00:00 | LTNW | MS | Houston | Prebon | Added and backdated late EES sleeve deals |  | 539859/861 | Palo Verde | K01 | On [NAME] | 25 | 268/272 | PGET/EES
 |  |  |  | Grand Count
Spreadsheet: 834621d1687951781-extract-data-with-conditions-filter-function-filter-example-multiple-variations-v3
Sheet: Summary

PRODUCT CODE | PRODUCT NAME | VALUE
 | PRODUCT JJJ | 1000 |  |  |  |  |  | [NAME] | IGH
III | PRODUCT III | 900
GGG | PRODUCT GGG | 700
CCC | PRODUCT CCC | 300
AAA | PRODUCT AAA | 100
Spreadsheet: debra_perlingiere__8439__mi-industrialspotentials
Sheet: Sheet1

Entity | Holding Company
DARLING INTERNATIONAL INC | DARLING INTERNATIONAL INC
MENASHA CORP | MENASHA CORPORATION
MARTIN MARIETTA MAGNESIA SPC | LOCKHEED MARTIN CORP
DSC LTD | DSC LTD
CROWN BANDAGE | FORT [NAME]
U S GRAPHITE | U S GRAPHITE
GEORGIA-PACIFIC CORP | GEORGIA-PACIFIC CORPORATION
MARATHON ASHLAND PETROLEUM LLC | USX CORPORATION
INDRESCO INC | INDRESCO INC
MEAD PAPER | MEAD CORPORATION
PLAINWELL PAPER CO | PLAINWELL INC
PERFECT CIRCLE SEALED POWER | SEALED POWER TECH LTD PARTNR
KELLOGG COMPANY | KELLOGG COMPANY
IPMC HOLDING CORP | ARCADIA PARTNERS LP
FOX RIVER PAPER CO | FOX VALLEY CORPORATION
SOLUTIA INC | MONSANTO COMPANY
ABTCO INC | ABT BUILDING PRODUCTS CORP
NORTH STAR STEEL CO | CARGILL INCORPORATED
ELF ATOCHEM NORTH AMERICA INC | ELF AQUITAINE INC
KRAFT FOODS INC | PHILIP MORRIS COMPANIES INC
ROCK-TENN CO | ROCK-TENN COMPANY
DETROIT DIESEL CORP | PENSKE CORP
UNITED STATES GYPSUM CO | USG CORPORATION
GERBER PRODUCTS CO | SANDOZ CORP
OWENS-ILLINOIS INC | OWENS-ILLINOIS INC
VENTURE INDUSTRIES CORP | VENTURE INDUSTRIES CORP
QUANEX CORP | QUANEX CORPORATION
GIBRALTAR CEMENT INC | GIBRALTAR NATIONAL CORP
FLETCHER PAPER CO | FLETCHER CORP
CELOTEX CORP | JASPER CORP
CARGILL INC | AKZO NOBEL INC
CHAMPION INTERNATIONAL CORP | CHAMPION INTERNATIONAL CORP
Peninsular Gas Co.
MICHIGAN LIMESTONE OPERATIONS | MICHIGAN LIMESTONE OPERATIONS
DOW CHEMICAL CO | THE DOW CHEMICAL COMPANY
GUARDIAN FIBERGLASS INC | GUARDIAN INDUSTRIES CORP
UNITED DISTILLER & VINTNERS | UDV [NAME]
HAYES WHEELS INTERNATIONAL | VARITY CORP
SARA LEE CORP | SARA LEE CORPORATION
J & L SPECIALTY STEEL INC | J & L SPECIALTY STEEL INC
BASF CORP | [NAME]
HURON VALLEY STEEL CORP | HURON VALLEY STEEL CORP
ARTISTIC CARTON CO INC | ARTISTIC CARTON CO (DEL)
HAYES-ALBION CORP | F E L CORP
PHARMACIA & UPJOHN INC | PHARMACIA & UPJOHN INC
MUELLER BRASS FORGING COMPANY | MUELLER INDUSTRIES INC
IKO MONROE INC | IKO MONROE INC
Spreadsheet: 74656885-9109-4795-a4e9-5fa1d2106608
Sheet: HZ1

DIVPLACE | NO. | PRIJMENI | JMENO | [NAME] | DIV | [NAME] | finish
1 | 282 | Uhrová | [NAME] | 1983 | HZ1 | [NAME] | 1:06:01
2 | 249 | Líkařová | [NAME] | 1986 | HZ1 | [NAME], ZP-MA | 1:09:49
3 | 267 | Rybář Dyntar | Martina | 1987 | HZ1 | Rakovník | 1:10:00
4 | 246 | Kubzová | Lenka | 1980 | HZ1 | [NAME] | 1:11:38
5 | 303 | [NAME] | Kateřina | 1989 | HZ1 | [NAME] | 1:11:48
6 | 214 | Herinková | Lucie | 1986 | HZ1 | Happy Bike Team | 1:12:18
7 | 314 | Hodoušová | [NAME] | 1994 | HZ1 | [NAME] | 1:13:34
8 | 280 | [NAME] | Lenka | 1968 | HZ1 | [NAME] | 1:14:53
9 | 260 | Poprocká | Irena | 1986 | HZ1 | Orlová | 1:15:59
10 | 288 | Vrzáková | Anna | 1989 | HZ1 | [NAME] | 1:16:27
11 | 315 | Petrášová | Karolína | 1995 | HZ1 | [NAME] | 1:17:24
12 | 277 | Taiblová | Kateřina | 1984 | HZ1 | [NAME] | 1:19:38
13 | 292 | [NAME] | [NAME] | 1975 | HZ1 | Slaný | 1:26:26
14 | 201 | Čížková | Petra | 1989 | HZ1 | [NAME], ZP-MA | 1:27:07
15 | 231 | [NAME] | Kateřina | 1987 | HZ1 | [NAME] | 1:28:54
16 | 211 | Hejdová | Sandra | 1996 | HZ1 |  | 2:08:27
Spreadsheet: 0879a46c-491b-4431-8f7b-042407999fba
Sheet: School Budget (21)

Fresh Fruit & Vegetable Program  Projected Budget Tool for SY 2014-2015
Instructions: The tool will determine your monthly budget based on your school's enrollment and the # of serving days per month.
Step 1. Enter data into grey-colored cells in the "FFVP School Information" table.
Step 2. Enter the "# of Serving Days per Month" for each month (July-June) in the "Projected Monthly FFVP Budget for SY 2014-2015" table. You must fill in the entire table to determine your monthly budget.
Step 3. Check your work! Cell E24 should match "July FFVP Allocation", cell E34 should match "October FFVP Allocation", and cell E35 should match "Total FFVP Allocation". The cells labeled "July FFVP Allocation", "October FFVP Allocation", and "Total FFVP Allocation" will turn green if you've entered all the information correctly.
FFVP School Information
SFA/District Name
School Name
# of Student Participating in FFVP
July FFVP Allocation
October FFVP Allocation
Total FFVP Allocation
Total FFVP Funds Available per Student
Projected Monthly FFVP Budget for SY 2014- 2015
Allocation | Month | # of Serving Days per Month | # of Servings per Month | Total Monthly Budget | Total Monthly Operational Cost Budget | Total Montly Administrative Cost Budget
July | July
 | August
 | September
 | July Totals
October | October
 | November
 | December
 | January
 | February
 | March
 | April
 | May
 | June
 | October Totals
Totals
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 12a

Product1 | Cleared2 | Uncleared | TOTAL
Cross_Currency Basis | - | 305295 | 305295
Cross_Currency Fixed-Fixed | - | 372 | 372
Cross_Currency Fixed-Float | - | 14564 | 14564
TOTAL | - | 320231 | 320231
Spreadsheet: 80b0fae4-1c1a-409c-babd-6810642c9c81
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
SAA | Test | SAA | Sperm Antibody, Indirect, Serum | [NAME], Serum | Immunobead Technique | Varies: Var |  |  | 2 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 2 mL Collection Instructions: Draw blood from the individual suspected of having sperm antibodies. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | <50% binding | Wednesday; 8:30 a.m. Send specimen Monday through Friday | 7 days | 8 days | 1 | 89325 |  |  |  |  | Rochester
SAA | [NAME] | SERUM | Serum |  |  |  | Frozen
SAA | Result | SA_A | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31631-5
SAA | Result | STDYT | Study Type | Study Type | Alphanumeric
SAA | Result | H_IGA | Head, IgA | Head, IgA | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38674-8
SAA | Result | H_IGG | Head, IgG | Head, IgG | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38678-9
SAA | Result | M_IGA | Midpiece, IgA | Midpiece, IgA | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38675-5
SAA | Result | M_IGG | Midpiece, IgG | Midpiece, IgG | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38679-7
SAA | Result | TIGA | Tail, IgA | Tail, IgA | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38677-1
SAA | Result | TIGG | Tail, IgG | Tail, IgG | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38681-3
SAA | Result | TTIGA | Tail Tip, IgA | Tail Tip, IgA | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38676-3
SAA | Result | TTIGG | Tail Tip, IgG | Tail Tip, IgG | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 38680-5
SAA | Result | [NAME] | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8
Spreadsheet: 159979d1338917974-correlation-with-a-lag-book1
Sheet: Sheet1

01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00
1 | 2 | 3 | 4 | 5 | 6 | 7 | 6 | 5 | 4 | 3 | 2
5 | 6 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 1 | 1 | 1
Spreadsheet: 694609d1599717404-ranking-based-on-cell-value-against-the-unique-line-item-ranking-based-on-cell-value
Sheet: Sheet1

 |  |  |  | Slab 1 |  | Slab 2
Sl No | RM Part # | MFG Part  # | Supplier | Total Spend Slab1 | Rank Slab1 | Total Spend Slab1 | Rank Slab 2
1 | A103XX1 | Wy567 | A | 130.8 |  | 909
1 | A103XX1 | Wy567 | B | 145 |  | 900
1 | A103XX1 | Xy1231 | A | 155.1255524081722 |  | 1671.741390029816
1 | A103XX1 | Xy1231 | B | 204 |  | 1836
1 | A103XX1 | YyX821 | C | 144.45 |  | 1605
2 | A103XX2 | WQ568 | A | 100.3333333333333 |  | 986.6666666666666
2 | A103XX2 | XQ1232 | B | 98.36164881337595 |  | 816.6264247593097
3 | A121XX1 | WZ567 | A | 98.1 |  | 909
3 | A121XX1 | [NAME] | C | 145 |  | 900
4 | A121XX2 | XZ1232 | B | 242.784 |  | 822.4
4 | A121XX2 | YZX822 | C | 107.31 |  | 1461
Spreadsheet: 109234d1306161415-autofill-help-accessing-random-cells-on-separate-sheet-reference-book1example
Sheet: Sheet1

Client # | Name |  |  |  |  |  | Phone |  |  | Dates
930 | User1 LastName |  |  |  |  | Home # | [PHONE] |  | First |  | 2007-05-19 00:00:00
123 Smith Road |  |  |  |  |  | Work # | [PHONE] |  | Last |  | 2010-11-13 00:00:00
New York, NY 10001
 |  |  |  |  |  | E-Mail | [EMAIL] |  | Birthday |  | 1955-02-03 00:00:00
19 | User2 LastName |  |  |  |  | Home # | [PHONE] |  | First |  | 2006-11-15 00:00:00
456 Smith Road |  |  |  |  |  | Work # | [PHONE] |  | Last |  | 2011-01-15 00:00:00
New York, NY 10002
 |  |  |  |  |  | E-Mail | [EMAIL] |  | Birthday
1653 | User3 LastName |  |  |  |  | Home # | [PHONE] |  | First |  | 2008-08-19 00:00:00
789 Smith Road |  |  |  |  |  | Work # | [PHONE] |  | Last |  | 2010-04-29 00:00:00
New York, NY 10003
 |  |  |  |  |  | E-Mail | [EMAIL] |  | Birthday |  | 1965-03-04 00:00:00
1703 | User1703 LastName |  |  |  |  | Home # | [PHONE] |  | First |  | 2009-12-22 00:00:00
111 Some Street |  |  |  |  |  | Work # | [PHONE] |  | Last |  | 2011-01-14 00:00:00
Newark, NJ 08912
 |  |  |  |  |  | E-Mail | [EMAIL] |  | Birthday
1170 | [NAME] |  |  |  |  | Home # | [PHONE] |  | First |  | 2007-06-01 00:00:00
2222 Jones Road |  |  |  |  |  | Work # | [PHONE] |  | Last |  | 2010-07-30 00:00:00
Edison, NJ 07689
 |  |  |  |  |  | [NAME] | [EMAIL] |  | Birthday |  | 1975-04-05 00:00:00
Spreadsheet: 705457d1606138437-equation-for-averaging-cells-that-include-signs-excel-help
Sheet: Sheet1

In the example below, the number generated in cells L52, L60-L62 should be the number 2 and not 1.  How can I fix this?
Sample ID | Bottle # | ml's Sample Used | Volume of B.O.D. Seed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
Effluent | 57 | 200 |  | 8.95 | 6.55 |  | 1.4
 | 58 | 180 |  | 8.88 | 6.53 |  | 1.4
 | 59 | 150 |  | 8.81 | 6.68 |  | 1.4
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Effluent Average:
Sample ID | Bottle # | ml's Sample Used | Volume of B.O.D. Seed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
[NAME]. | 60 | 200 |  | 8.93 | 6.56 |  | 1.4
 | 61 | 180 |  | 8.88 | 6.64 |  | 1.4
 | 62 | 150 |  | 8.76 | 6.75 |  | 1.4
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Effluent Duplicate Average:
 |  |  |  |  |  |  | Duplicate % Recovery (<20%):
 |  |  |  |  |  |  | Effluent & Duplicate Average:
Spreadsheet: 216754d1361880854-d-funtion-and-multiple-criteria-forumla-issue-daverage-problem
Sheet: Sheet1

Name | Company | Age
bob | Nestle | 23
anne | Nestle | 21
[NAME] | Cadburys | 25 |  |  |  | Company | Age | D-averages
Beverly | [NAME] | 28 |  |  |  | Nestle
[NAME] | Mars | 32 |  |  |  | Cadburys
Kelly | Mars | 35 |  |  |  | [NAME]
Spreadsheet: fb19c041-f48b-40d6-9d90-dad63114be04
Sheet: Sheet1

Unnamed: 0 | A Hortobágyi Nemzeti Park Igazgatóság mobiltelefon költségei 2010. évben | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Igazgatóság | [NAME]. | Korlátozás [NAME]. | Üzemeltetés költségei            eFt-ban /nettó/
 | Január | 123 | 2 | 377
 | Február | 123 | 2 | 389
 | Március | 123 | 2 | 359
 | [NAME] | 123 | 2 | 363
 | Május | 123 | 2 | 383
 | Június | 123 | 2 | 416
 | Július
 | Augusztus
 | [NAME]
 | [NAME]
 | November
 | December
 | 2010-09-06 00:00:00
Spreadsheet: 821311d1678607674-interpolating-data-using-forecast-function-c172-takeoff-ans
Sheet: Sheet1

 | TEMP  (°C) | PRESSURE ALTITUDE (DRY RUNWAY) - C172S
 |  | 0 |  |  | 1000 |  |  | 2000 |  |  | 3000 |  |  | 4000
 |  | MTOW | GND ROLL | 50 FT OBST | MTOW | GND ROLL | 50 FT OBST | MTOW | GND ROLL | 50 FT OBST | MTOW | GND ROLL | 50 FT OBST | MTOW | GND ROLL | 50 FT OBST
 | 0 | 2550 | 860 | 1465 | 2550 | 940 | 1600 | 2550 | 1025 | 1755 | 2550 | 1125 | 1925 | 2550 | 1235 | 2120
 | 10 | 2550 | 925 | 1575 | 2550 | 1010 | 1720 | 2550 | 1110 | 1890 | 2550 | 1215 | 2080 | 2550 | 1335 | 2295
 | 20 | 2550 | 995 | 1690 | 2550 | 1090 | 1850 | 2550 | 1195 | 2035 | 2550 | 1310 | 2240 | 2550 | 1440 | 2480
 | 30 | 2550 | 1070 | 1810 | 2550 | 1170 | 1990 | 2550 | 1285 | 2190 | 2550 | 1410 | 2420 | 2550 | 1550 | 2685
 | 40 | 2550 | 1150 | 1945 | 2550 | 1260 | 2135 | 2550 | 1380 | 2355 | 2550 | 1515 | 2605 | 2550 | 1660 | 2880
 | 0 | 2400 | 745 | 1275 | 2400 | 810 | 1390 | 2400 | 885 | 1520 | 2400 | 970 | 1665 | 2400 | 1065 | 1830
 | 10 | 2400 | 800 | 1370 | 2400 | 875 | 1495 | 2400 | 955 | 1635 | 2400 | 1050 | 1795 | 2400 | 1150 | 1975
 | 20 | 2400 | 860 | 1470 | 2400 | 940 | 1605 | 2400 | 1030 | 1760 | 2400 | 1130 | 1930 | 2400 | 1240 | 2130
 | 30 | 2400 | 925 | 1570 | 2400 | 1010 | 1720 | 2400 | 1110 | 1890 | 2400 | 1215 | 2080 | 2400 | 1335 | 2295
 | 40 | 2400 | 995 | 1685 | 2400 | 1085 | 1845 | 2400 | 1190 | 2030 | 2400 | 1305 | 2230 | 2400 | 1430 | 2455
 | 0 | 2200 | 610 | 1055 | 2200 | 665 | 1145 | 2200 | 725 | 1250 | 2200 | 795 | 1365 | 2200 | 870 | 1490
 | 10 | 2200 | 655 | 1130 | 2200 | 720 | 1230 | 2200 | 785 | 1340 | 2200 | 860 | 1465 | 2200 | 940 | 1605
 | 20 | 2200 | 705 | 1205 | 2200 | 770 | 1315 | 2200 | 845 | 1435 | 2200 | 925 | 1570 | 2200 | 1010 | 1725
 | 30 | 2200 | 760 | 1290 | 2200 | 830 | 1410 | 2200 | 905 | 1540 | 2200 | 995 | 1685 | 2200 | 1090 | 1855
 | 40 | 2200 | 815 | 1380 | 2200 | 890 | 1505 | 2200 | 975 | 1650 | 2200 | 1065 | 1805 | 2200 | 1165 | 1975
 |  |  |  | [NAME] |  |  |  | Final Result for Temp 15°C at 500 ft elev with takeoff weight 2300 lb
 |  |  |  | Elevation |  | 500
 |  |  |  | Temp |  | 15 |  |  | GND ROLL | 50 FT OBST
 |  |  |  | takeoff weight |  | 2300
Spreadsheet: 723939d1615967566-weekday-function-returns-wrong-day-of-the-week-weekday
Sheet: WEEKDAY

Date | Day No. | Day
1972-03-13 00:00:00
1983-06-21 00:00:00
1974-11-24 00:00:00
1976-01-12 00:00:00
1977-07-22 00:00:00
1978-02-28 00:00:00
1978-03-20 00:00:00
1978-05-29 00:00:00
1981-05-22 00:00:00
1983-01-09 00:00:00
1983-11-25 00:00:00
1985-09-05 00:00:00
1987-03-25 00:00:00
1989-03-16 00:00:00
1989-10-09 00:00:00
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Jan6-Jan12p

Pavilion
 | 2013-01-06 00:00:00 |  |  | Thru | 2013-01-12 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-01-06 00:00:00 | 2013-01-07 00:00:00 | 2013-01-08 00:00:00 | 2013-01-09 00:00:00 | 2013-01-10 00:00:00 | 2013-01-11 00:00:00 | 2013-01-12 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 12:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
1:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 1:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
2:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 2:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
3:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 3:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
4:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 4:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
5:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 5:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
[NAME] |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | [NAME]
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
7:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 7:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
8:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 8:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
9:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 9:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
10:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 10:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
11:15PM |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks | 11:15PM
 |  |  |  |  | Silver Sticks | Silver Sticks | Silver Sticks
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 76230d1276770340-separate-one-column-to-2-columns-help
Sheet: Sheet1

0.043015 |  |  |  | change to | 0.043015 |  | -0.042092
[2.2321]* |  |  |  |  | [2.2321]* |  | [-2.1350]*
-0.042092 |  |  |  |  | 0.081947 |  | 0.021412
[-2.1350]* |  |  |  |  | [4.6530]** |  | [1.3215]
0.081947 |  |  |  | please help
[4.6530]**
0.021412
[1.3215]
0.138872
[4.1444]**
0.046216
[1.5953]
0.059947
[3.8664]**
0.018811
[1.2847]
0.023008
[1.7628]
-0.022567
[-1.7347]
0.034193
[1.8313]
-0.033429
[-1.7587]
0.066105
[3.3086]**
0.020536
[1.0927]
0.048755
[2.3698]*
-0.048106
[-2.3342]*
0.093955
[4.0429]**
0.019623
[0.8475]
0.085316
[4.5231]**
0.018863
[1.0282]
0.063173
[2.8672]**
0.015651
[0.7146]
0.077371
[4.0374]**
0.024935
[1.4641]
0.107108
[4.4613]**
0.007458
[0.3393]
0.089928
[3.9923]**
0.019006
[0.9332]
0.079131
[3.5093]**
0.011058
[0.4655]
0.086586
[3.4189]**
0.004055
[0.1639]
0.085139
[4.5279]**
0.024885
[1.3919]
0.012172
[2.1318]*
-0.006072
[-0.9664]
0.033696
[3.0710]**
-0.013822
[-1.2852]
0.062801
[4.6737]**
0.006707
[0.5389]
0.121277
[4.4661]**
0.028904
[1.2231]
0.009363
[0.7188]
0.001468
[0.1104]
0.067442
[3.9651]**
0.03504
[2.1363]*
0.077034
[3.3267]**
-0.013174
[-0.3738]
0.040739
[2.1424]*
-0.039721
[-2.0569]*
0.02416
[1.9388]
-0.022493
[-1.7659]
0.061388
[3.8969]**
0.023468
[1.5780]
0.10738
[3.5011]**
0.040519
[1.2750]
0.03939
[3.2257]**
0.010563
[0.8754]
0.084945
[4.7784]**
0.021439
[1.2722]
0.066375
[4.0103]**
0.017584
[1.0491]
0.107084
[4.1693]**
0.020321
[0.8533]
0.082078
[4.4927]**
0.01188
[0.7087]
Spreadsheet: 02d2a4b5-de91-4bab-860e-288a9e323aea
Sheet: Sheet1

Unnamed: 0 | Undergraduate Majors | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Faculty of Business
 | (BACC, BBA, Business Combined Majors)
 | Study Year | Major [NAME] |  |  | Enrolment Headcount
 |  |  | 2003-04 | 2004-05 | 2005-06 | 2006-07 | 2007-08 | 2008-09 | 2009-10 | 2010-11
 |  | Single | 570 | 657 | 625 | 651 | 648 | 655 | 788 | 763
 |  | Combined | 2 | 0 | 1 |  | 1 | 1 |  | 2
 | Year I | Sub-Total: | 572 | 657 | 626 | 651 | 649 | 656 | 788 | 765
 |  | Gen/Integ Studies | 0 | 0 | 0
 |  | Total: | 572 | 657 | 626 | 651 | 649 | 656 | 788 | 765
 |  | Single | 430 | 605 | 564 | 540 | 534 | 595 | 627 | 683
 |  | Combined | 5 | 5 | 2 | 4 | 1 | 2 | 2 | 2
 | Year II | Sub-Total: | 435 | 610 | 566 | 544 | 535 | 597 | 629 | 685
 |  | Gen/Integ Studies | 0 | 0 | 0 |  |  |  | 1
 |  | Total: | 435 | 610 | 566 | 544 | 535 | 597 | 630 | 685
 |  | Single | 420 | 502 | 660 | 623 | 580 | 590 | 659 | 677
 |  | Combined | 3 | 2 | 4 | 2 | 4 | 5 | 4 | 4
 | Year III | Sub-Total: | 423 | 504 | 664 | 625 | 584 | 595 | 663 | 681
 |  | Gen/Integ Studies | 3 | 1 | 0 |  |  |  | 1 | 4
 |  | Total: | 426 | 505 | 664 | 625 | 584 | 595 | 664 | 685
 |  | Single | 519 | 343 | 364 | 472 | 462 | 433 | 427 | 463
 |  | Combined | 4 | 3 | 2 | 8 | 6 | 1 | 2 | 4
 | Year IV | Sub-Total: | 523 | 346 | 366 | 480 | 468 | 434 | 429 | 467
 |  | Gen/Integ Studies | 2 | 0 | 1 | 1 |  |  | 1
 |  | Total: | 525 | 346 | 367 | 481 | 468 | 434 | 430 | 467
 |  | Single | 1939 | 2107 | 2213 | 2286 | 2224 | 2273 | 2501 | 2586
 |  | Combined | 14 | 10 | 9 | 14 | 12 | 9 | 8 | 12
 | TOTAL: | Sub-Total: | 1953 | 2117 | 2222 | 2300 | 2236 | 2282 | 2509 | 2598
 |  | Gen/Integ Studies | 5 | 1 | 1 | 1 | 0 | 0 | 3 | 4
 |  | Total: | 1958 | 2118 | 2223 | 2301 | 2236 | 2282 | 2512 | 2602
 | Male |  | 1102 | 1214 | 1323 | 1385 | 1395 | 1443 | 1553 | 1610 | 0.6187548039969254
 | Female |  | 856 | 904 | 900 | 916 | 841 | 839 | 959 | 992 | 0.3812451960030745
 | Full-Time |  | 1465 | 1604 | 1647 | 1669 | 1601 | 1662 | 1907 | 2128 | 0.8178324365872406
 | Part-Time |  | 493 | 514 | 576 | 632 | 635 | 620 | 605 | 474 | 0.1821675634127594
 | Combined and General/Integrated Studies reflect the number of students enrolled in the B.A. (Honours) program majoring in business and another major. These B.A. programs do not have a co-op option.
 | *BACC - Bachelor of Accounting; BBA - Bachelor of Business Administration
 | Codes: | BACC -- ACCC, ACCN, ACSP; BBA -- FNCE, COMP, QUAN, FNHR,  MKTG, INBU, MGMT, MKGM, INMK, MKFN, ENTR, HMRS, HMMK, PADM, ADMI, ADMN. ADSN, ADSP, GASS, ACTG, ACIN