tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: drew_fossum__8870__Fixed2
Sheet: Summary

ENRON TRANSPORTATION & STORAGE
FUEL HEDGING BOOK
SUMMARY
AS OF DECEMBER 09, 1999
Related | Company | Contract | Contract | Contract | Hedged | Offsetting | Hedge | Unhedged | Contract | [NAME]. | Spread | Contract | Fuel
Trans. | Name | Name | Number | Type |  | Counter- | Term | Term | Price | Actual/ |  | Volume | Dth/d | Gains and (Losses)
 |  |  |  | (1) |  | Party |  |  |  | Futures |  | (Short) |  | Total | Realized | Unrealized
 |  |  |  |  |  |  |  |  |  | Prices |  | Long |  | (4) | (4) | (4)
1 | TW | Avista |  | F |  | Engage | 06/98-05/99
1 | TW | Engage | 26125 | P | Y | Avista | 06/98-05/99
1 | TW | Sempra |  | F |  | Engage | 06/99-05/00
1 | TW | Engage | 26125 | P | Y | Sempra | 06/99-05/00
2 | TW | Avista |  | F |  | Over-rtnd | 10/98-12/99
2 | TW | Over-rtnd |  | P | Y | Avista | 10/98-12/99
2 | TW | Sempra |  | F |  | Over-rtnd | 10/98-12/99
2 | TW | Over-rtnd |  | P | Y | Sempra | 10/98-12/99
2 | TW | Sempra |  | F |  | Over-rtnd | 05/99-12/99 |  | 2.01
2 | TW | Over-rtnd |  | P | Y | Sempra | 05/99-12/99 |  | 2.01
2 | TW | RMTC |  | F |  | Over-rtnd | 01/01-12/00 |  | 2.365
2 | TW | Over-rtnd |  | P | Y | RMTC | 01/01-12/00 |  | 2.365
6 | NNG | El Paso | 25834 | P | Y | Base Gas Repurchase | 06/02-10/02 (5) |  | 2.216
6 | NNG | El Paso |  | F | Y | Base Gas Repurchase | 06/02-10/02 (5) |  | 2.216
8 | NNG | MEC | 105706 | P | N |  | 11/99-04/00
8 | NNG | MEC | 105706 | P | N |  | 11/99-04/00
UNHEDGED PRICE EXPOSURE
SUMMARY
Related | Company | Contract | Contract | Contract | Hedged | Counter- | Hedge | Unhedged | Contract | [NAME]. | Spread | Contract | Fuel
Trans. | Name | Name | Number | Type |  | Party | Term | Term | Price | Actual/ |  | Volume | Dth/d | Gains and (Losses)
 |  |  |  | * |  |  |  |  |  | Futures |  | Short(-) |  | Total | Realized | Unrealized
 |  |  |  |  |  |  |  |  |  | Prices |  | Long(+) |  | (4) | (4) | (4)
1 | TW | Engage | 26125 | P | N |  |  | 06/00-05/03 |  |  |  | -273750
7 | TW | Over-rtnd |  | P | N |  |  | 01/01-12/01 |  |  |  | 5475000
3 | NNG | GPM | 101021 | P | N |  |  | 01/96-12/05 |  |  |  | 923648.25
4 | NNG | GPM | 101073 | P | N |  |  | 01/96-12/05 |  |  |  | 164380.4375
5 | NNG | Apache | 22064 | P | N |  |  | [NAME] |  |  |  | -3900
(1) Contract Type: |  | F-Financial
 |  | P-Physical
(2)TW Over Retention is estimated for 15 mnths. @ 200,000/mnth less outstanding deals(Avista_2 & Sempra_2).
(3)Contract term 12 month evergreen.
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
(5)Margin call:  $   1,000,000-NNG
$20,000,000-El Paso
Spreadsheet: 273330d1382680703-index-match-help-auswtz
Sheet: Results

 |  |  |  |  |  |  | 2013-08-01 00:00:00
 |  |  |  |  |  |  |  |  | TEST A | TEST B | TEST C | TEST D
 |  |  |  |  |  |  | Model1 |  | 10 | 50 | 28 | 8
 |  |  |  |  |  |  | Model2 |  | 10 | 50 | 28 | 8
 |  |  |  |  |  |  | Model3 |  | 10 | 50 | 28 | 8
Spreadsheet: 39235d1237411096-vlookup-issue-pump_dft_stores_reciept2
Sheet: Stores Reciept

Appendix 6 |  |  |  |  |  | DFT SOP 014 ISSUE 1 |  |  | Appendix 6 |  |  |  |  |  | DFT SOP 014 ISSUE 1
 |  |  |  |  |  | PMP Copy (3-3-09) |  |  |  |  |  |  |  |  | PMP Copy (3-3-09)
 | CATEGORY |  |  |  |  |  |  |  |  | CATEGORY
 |  |  | 3 |  |  |  |  |  |  |  |  | 3
PART |  | 6120100 |  |  |  |  |  |  | PART |  | 6120100
[NAME] |  | #N/A |  |  |  |  |  |  | [NAME] |  | #N/A
SALES |  |  |  |  |  |  |  |  | SALES |  | 0
ORDER |  |  |  |  |  |  |  |  | ORDER
QTY |  |  |  |  |  |  |  |  | QTY |  | 0
PLAN DATE |  |  |  |  |  |  |  |  | PLAN DATE |  | 0
STORES |  | RRFPS |  |  |  |  |  |  | STORES |  | RRFPS
 | ST |  |  | OT
Spreadsheet: 108609d1305642495-fining-the-first-2-digits-of-a-6-digit-number-timesheet-1
Sheet: Timesheet - AF

 | Househam Sprayers Engineering Timesheet
 | Year to date totals: |  | Jan-Mar: |  | Apr-Jun: |  | Jul-Sept: |  | Oct-Dec: |  | Total:
 | January, February, March
 | January |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday |  | 30401 | 2 | 30401 | 2 | 30401 | 2 | 30401 | 2 | 30401 | 2
 | Tuesday |  | 10102 | 0.5 | 10102 | 0.5 | 10102 | 0.5 | 10102 | 0.5 | 10102 | 0.5
 | Wednesday |  | 10102 | 8 | 10102 | 8 | 10102 | 8 | 10102 | 8 | 10102 | 8
 | Thursday
 | Friday
 | Total weekly hours
 | Jan. total: R&D hours
 | February |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | Feb. total: R&D hours
 | March |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | Mar. total: R&D hours
 | April, May, June
 | April |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | Apr. total: R&D hours
 | May |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | May. total: R&D hours
 | June |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | Jun. total: R&D hours
 | July, August, September
 | July |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | Jul. total: R&D hours
 | August |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | Aug. total: R&D hours
 | September |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | Sept. total: R&D hours
 | October, November, December
 | October |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | Oct. total: R&D hours
 | November |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | Nov. total: R&D hours
 | December |  | JOB NO | Week 1 | JOB NO | Week 2 | JOB NO | Week 3 | JOB NO | Week 4 | JOB NO | Week 5
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Total weekly hours
 | Dec. total: R&D hours
Spreadsheet: 127024d1320122195-excel-2007-find-duplicate-numbers-in-string-search-duplicate
Sheet: example

 | code | Required |  | Your Formula
 | 1
 | 2
 | 3 , 6
 | 4, 5
 | 6 | Duplicate
 | 7
 | 3 | Duplicate
 | 4 | Duplicate
 | 100
 | 10 |  |  |  | <- point 1. | 10 has not been used before
 | 9, 3 | Duplicate |  |  | <- point 2. | the number 3 has been used before
 | 11
 | 12
 | 13
 | 3, 6 | Duplicate |  |  | <- both numbers have been used before
 | 15
 | 16
 | 17
 | 18
Spreadsheet: 769500d1645562274-add-to-validation-list-several-dv-options
Sheet: FILTERS

ALAAUTO | AL | ALAAUTO | AL
ALBUQUERQ | AZ | ALBUQUERQ | AZ
ALLIANCE | BC | ALLIANCE | BC
ALTUS | CA | ALTUS | CA
ATLANTA | CO | [NAME] | CO
AUSTELL | FL | ATLANTA | FL
AVONDALE | GA | BALTIMORE | GA
BARCUT | IL | BARCUT | IL
BARSTOW | KS | BARSTOW | KS
BEAUMONT | MA | BIGLIFT | MA
BIRMINGHA | MN | BIRMINGHA | MD
BLUISLAND | MO | BRAINTTER | MN
BLUSPRING | MS | CADIZ | MO
CHARLOTTE | NC | CHICAGO | MS
CHEYENNE | ND | CLEARING | MT
CHICAGO | NE | CLEBURNE | ND
CICERO | NJ | CMALOTONE | NE
CINCINNAT | NM | CORCHRIST | NJ
CLEARING | OH | CROXTON | NM
COLTON | OK | DAKCITY | NY
CORCHRIST | OR | DALLAS | OH
CROXTON | PA | DAYBLUFF | OK
DALLAS | TN | DENVER | ON
DENVER | TX | DILWORTH | OR
EAGPASS | WA | EAGPASS | PA
ELPASO | WY | EIGSTREET | TN
ESTJOHNS | ZZ | ELMIRAGE | TX
ESTLOUIS |  | ELPASO | WA
EVERETT |  | ESTJOHNS | ZZ
FAIRBURN |  | ETTER
FREMONT |  | FREMONT
GLOGATSO |  | FRYBURG
HOUSTON |  | GLOGATSO
KANCITY |  | HOUSTON
LAHARAPMT |  | [NAME]
LOGPARCHI |  | KANCITY
LOGPARKAN |  | KENT
[NAME] |  | KORF
LONBEACH |  | LAHARAPMT
LONBEAEPI |  | LAUBN
LONBEAITS |  | LAUREL
[NAME] |  | LOGPARCHI
LONBEALBC |  | LOGPARKAN
LONBEAPCT |  | [NAME]
LONBEATPI |  | LONBEACH
LONJCT |  | LONBEAEPI
LOSANGELE |  | LONBEAITS
LUBBOCK |  | [NAME]
MCCOOK |  | LONBEAPCT
MEMPHIS |  | LONBEATPI
MIDLOTHIA |  | LONJCT
MINOT |  | LOSANGELE
MISSINGAC |  | LUBBOCK
NATCITY |  | MCCOOK
NBAY |  | MEMPHIS
NEWWESTMI |  | MIDLOTHIA
NWOHIICTF |  | MINOT
OAKINTGAT |  | MISSINGAC
OMAHA |  | NATCITY
PASADENA |  | NBAY
PHOENIX |  | NBERGEN
PORTERSIX |  | NEWWESTMI
PORTLAND |  | NWOHIICTF
RICHMOND |  | OAKINTGAT
RIVGATE |  | OAKLAND
ROBSTOWN |  | OKLCITY
RUTHERFOR |  | OMAHA
SANANGJCT |  | ORILLIA
SANBERNAR |  | PEARLAND
SANDIEGO |  | PHOENIX
SANJOSE |  | PITTSBURG
SEAPIEFIV |  | PORTERSIX
SEAPIEONE |  | PORTLAND
SEATTLE |  | RICHMOND
SKEARNY |  | ROBSTOWN
SPOKANE |  | RUTHERFOR
SSEATTLE |  | SANBERNAR
STLOUIS |  | SANDIEGO
STOCKTON |  | SEAPIEFIV
STPAUL |  | SEAPIEONE
TACBLAIR |  | SEATTLE
TACEXP |  | SPOKANE
TACOMA |  | SSEATTLE
TACPCT |  | STJOHNS
THENARD |  | STLOUIS
TICSEASID |  | STOCKTON
TICTF |  | STPAUL
TRAPAC |  | SYRACUSE
TUPELO |  | TACBLAIR
UTTING |  | TACEXP
[NAME] |  | TACOMA
VELOX |  | TACPCT
WATSON |  | TICSEASID
WBASIN |  | TICTF
WILSPRING |  | TRAPAC
WINHAVEN |  | TUPELO
WORCESTER |  | UTTING
ZITA |  | [NAME]
 |  | VELOX
 |  | WBASIN
 |  | WILSPRING
 |  | WORCESTER
 |  | YUSTERMIN
 |  | ZITA
Spreadsheet: 782537d1654103308-oldest-and-latest-dates-formula-oldest-and-latest-date
Sheet: Sheet1

 |  |  | 2022-05-20 00:00:00 | 2022-05-21 00:00:00 | 2022-05-22 00:00:00 | 2022-05-23 00:00:00 | 2022-05-24 00:00:00 | 2022-05-25 00:00:00 | 2022-05-26 00:00:00 | 2022-05-27 00:00:00 | 2022-05-28 00:00:00 | 2022-05-29 00:00:00 | 2022-05-30 00:00:00 | 2022-05-31 00:00:00
WBS | Oldest Date | Latest Date | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st
H5640A199 |  |  |  |  | 2 | 1 | 2 | 2 | 1 | 2
H5806A199 |  |  | 5 | 3 | 1 | 10 | 6 |  | 8
Need formula to get Oldest (Start) date and Latest (Close) date from the table above
Spreadsheet: 05a717a4-f9db-4fd7-a3eb-7bdcb0222500
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Government and Public Administration: National Security
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the National Security Pathway of the Government and Public Administration Career Cluster) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        National Security Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Agent/Specialist ►Airborne Warning/Control               .   Specialist ►Combat Aircraft Pilot/Crew ►Combat Control Officer ►Combat Engineer ►Cryptographer ►Intelligence Analyst ►Intelligence/Counter-Intelligence ►National Security Advisor ►Officer/Specialist:     • Artillery     • Combat Operations     • Electronic Warfare Operations     • Military Intelligence     • Missile and Space Systems     • Munitions     • Nuclear Weapons     • Signals Intelligence     • Special Forces ►Staff or Field Officer ►Submarine Officer ►Surface Ship Warfare Officer
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 775597d1649217468-concatenatex-and-bulleted-list-example
Sheet: Example

HERE IS HOW IT WORKS CURRENTLY
task1 | Column Labels
Row Labels | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00
Documentation | Do doc task A  • Do doc task A  • Do doc task B  • Do doc task C | Do doc task D  • Do doc task E  • Do doc task F  • Do doc task G
Security | Do security task 1  • Do security task 1  • Do security task 2  • Do security task 3
Software | Do software task 1 | Do software task 5 | Do software task 2  • Do software task 3  • Do software task 4  • Do software task 5
HERE IS WHAT I WOULD PREFER
Row Labels | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00
Documentation | • Do doc task A   • Do doc task A   • Do doc task B   • Do doc task C | • Do doc task D  • Do doc task E    • Do doc task F   • Do doc task G
Security | • Do security task 1   • Do security task 1   • Do security task 2   • Do security task 3
Software | Do software task 1 | • Do software task 5 | • Do software task 2   • Do software task 3   • Do software task 4   • Do software task 5
Spreadsheet: thomas_martin__39742__Lunch Estimate
Sheet: June

June 2001
 | Vendor |  | Total Price |  | F(X) Trading |  | Texas Trading |  | Midwest Trading |  | Midwest Origination |  | East Trading |  | East Origination |  | West Trading |  | West Origination |  | Middle Marketing |  | Gas Fundy |  | IT |  | Weather |  | Wellhead
2001-06-01 00:00:00 | Crumly's |  | 1363.95
2001-06-04 00:00:00 | Pappadeaux |  | 1852.26
2001-06-05 00:00:00 | North China Border |  | 2500.2
2001-06-06 00:00:00 | Pappasitos |  | 1911.05
2001-06-07 00:00:00 | [NAME]'s |  | 1200
2001-06-08 00:00:00 | Crumly's |  | 1363.95
2001-06-09 00:00:00 | [NAME]'s |  | 2246.41
2001-06-11 00:00:00 | [NAME]'s |  | 1260.24
2001-06-12 00:00:00 | Subway |  | 870.69
2001-06-13 00:00:00 | Black-Eyed Pea |  | 1643.82
2001-06-16 00:00:00 | Treebeards |  | 1700
2001-06-17 00:00:00 | [NAME] |  | 1880
2001-06-18 00:00:00 | Goode Company |  | 1667.05
2001-06-19 00:00:00 | Sodexho Marriot |  | 1852.92
2001-06-20 00:00:00 | [NAME] |  | 1389.36
2001-06-23 00:00:00 | Droubi Bros. |  | 1245.98
2001-06-24 00:00:00 | Pappasitos |  | 1959.04
2001-06-25 00:00:00 | Black-Eyed Pea |  | 1634.22
2001-06-26 00:00:00 | Sodexho Marriot |  | 1752
2001-06-27 00:00:00 | [NAME]'s |  | 1680
2001-06-28 00:00:00 | [NAME] |  | 2050.87
Total
Avg
Spreadsheet: 04ee76f2-efdb-4fc8-a540-8bde2dc353f7
Sheet: 4.2(LS) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(LS): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | LS - Life Sciences
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 3 | 1 | 0 | 0
 |  | Part Time | 1 | 1 | 0 | 0
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | 0 | 0 | 0 | 0
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
 | [NAME]. graduated with a GPA of 3.0 or above |  | 0 | 0 | 0 | 0
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Employed after graduation |  |  | m | m | m | m
Notes:
na = not offered; m = not tracked;
Spreadsheet: 678776d1590057860-to-find-patient-return-with-72-hours-72-hours-example
Sheet: Sheet1

To find (highlight) out who re-admit within 72 hours from last discharge
Name | Admit date | Admit time | Discharge Date | Discharge time |  |  |  |  | For example:
A | 2019-01-02 00:00:00 | 08:26:20 | 2019-01-02 00:00:00 | 10:11:35 |  |  |  |  | B came back within 72 hours after discharged on 05/01 16:12.
Z | 2019-01-03 00:00:00 | 04:40:55 | 2019-01-03 00:00:00 | 06:05:00 |  |  |  |  | X came back within 72 hours after discharged on 25/01 14:49
B | 2019-01-05 00:00:00 | 14:49:26 | 2019-01-05 00:00:00 | 16:12:56 |  |  |  |  | X came back within 72 hours after discharged on 26/01 22:22.
V | 2019-01-05 00:00:00 | 07:29:25 | 2019-01-05 00:00:00 | 09:36:54
B | 2019-01-07 00:00:00 | [NAME] | 2019-01-08 00:00:00 | 13:41:55 |  |  | 16:12:56
D | 2019-01-08 00:00:00 | 19:23:45 | 2019-01-08 00:00:00 | 19:47:02
F | 2019-01-11 00:00:00 | 11:29:30 | 2019-01-11 00:00:00 | 13:09:04
G | 2019-01-12 00:00:00 | 22:46:08 | 2019-01-14 00:00:00 | 00:31:26
E | 2019-01-13 00:00:00 | 14:23:44 | 2019-01-13 00:00:00 | 17:53:12
H | 2019-01-17 00:00:00 | 12:41:27 | 2019-01-17 00:00:00 | 16:31:40
E | 2019-01-19 00:00:00 | 05:23:54 | 2019-02-19 00:00:00 | 12:31:25
T | 2019-01-19 00:00:00 | 18:43:43 | 2019-01-19 00:00:00 | 20:11:26
A | 2019-01-19 00:00:00 | 22:46:12 | 2019-01-19 00:00:00 | 23:26:27
L | 2019-01-20 00:00:00 | 15:34:18 | 2019-01-20 00:00:00 | 20:22:50
E | 2019-01-21 00:00:00 | 11:22:34 | 2019-01-24 00:00:00 | 16:23:53 |  |  | 0.5218171296296296
W | 2019-01-21 00:00:00 | 18:59:34 | 2019-01-21 00:00:00 | 20:11:47
T | 2019-01-21 00:00:00 | 15:07:38 | 2019-01-21 00:00:00 | 17:35:33 |  |  | 20:11:26
V | 2019-01-21 00:00:00 | 16:04:36 | 2019-01-21 00:00:00 | 20:07:00
X | 2019-01-25 00:00:00 | 10:39:47 | 2019-01-25 00:00:00 | 14:39:51
X | 2019-01-26 00:00:00 | 21:34:46 | 2019-01-26 00:00:00 | 22:21:47 |  |  | 0.6110069444444445
O | 2019-02-03 00:00:00 | 15:58:09 | 2019-02-03 00:00:00 | 18:29:24
Z | 2019-02-03 00:00:00 | 17:43:06 | 2019-02-03 00:00:00 | 20:33:01
L | 2019-02-04 00:00:00 | 20:11:57 | 2019-02-03 00:00:00 | 21:14:09
X | 2019-02-28 00:00:00 | 23:06:49 | 2019-02-07 00:00:00 | 23:45:09
Spreadsheet: 679475-max-sumproduct-countif-pivot-of-sum-and-max
Sheet: Sheet2

Week | Name | Orders |  | Week | (All)
1 | [NAME] | 5000
1 | [NAME] | 200 |  | Row Labels | Sum of Orders | [NAME] of Orders2
1 | [NAME] | 1000 |  | [NAME] | 12000 | 7000
1 | [NAME] | 7000 |  | [NAME] | 1000 | 1000
 |  |  |  | [NAME] | 200 | 200
 |  |  |  | Grand Total | 13200 | 7000
Spreadsheet: 772649d1647423809-use-a-formula-stated-in-a-different-cell-test1
Sheet: Sheet1

Food | ceiling((Val_Cost+Val_AddOn)*Val_MultiplierFood*(1+VAT)+Val_Post,2) |  |  |  |  |  |  |  | These are subject to change for each outlet
Drink | ceiling((Val_Cost+Val_AddOn)*Val_MultiplierDrink*(1+VAT)+Val_Post,2)
Sundry | ceiling((Val_Cost+Val_AddOn)*Val_MultiplierSund*(1+VAT)+Val_Post,2)
Val_Cost -> | 100
[NAME] | 15
Val_MultiplierFood -> | 2.5
Val_MultiplierDrink -> | 3.2
Val_MultiplierSund -> | 1.8
VAT -> | 0.2
Val_Post -> | 5
 | Food | Drink | Sundry
Retail Price |  |  |  | What I would like
 |  |  |  | What I am getting
Spreadsheet: lindy_donoho__21984__EP1_item1
Sheet: Item 1

Cut Code | Cut Code Definition | Cut Category**
BMP | Bumped Quantities | B
CBL | Contract Balancing | B
CCD | Pipeline Capacity Constraint at Delivery Location | A
CCR | Pipeline Capacity Constraint at Receipt Location | A
CRD | Confirmation Response not Received at Delivery Location | B
CRR | Confirmation Response not Received at Receipt Location | B
EPS | Elapse Prorated Scheduled Quantities | B
FMJ | Force Majeure | A
[NAME] | Gas Quality Specifications not Met | B
IBC | Insufficient Backhaul Capacity | A
INV | Invalid Transaction | B
OTH | Other | B
PBD | Pipeline Balancing at Delivery Location | B
PBR | Pipeline Balancing at Receipt Location | B
PCC | Pipeline Capacity Constraint | A
PCD | Pipeline Capacity Constraint at Delivery Location | A
PLC | Pipeline Curtailment | A
PLM | Pipeline Maintenance | A
PMD | [NAME] at Delivery Location | A
PMR | [NAME] | A
PRD | Confirmation Party Reduction at Delivery Location | A
PRR | Confirmation Party Reduction at Receipt Location | A
**Cut Category [A - Insufficient Capacity; B - Other]
Spreadsheet: 0f5a5c47-df75-48ae-beaf-639ac0763327
Sheet: Probation, 2010SP

Students on probation, Spring 2010
 | Count | Inst. GPA | Cum. GPA | Transfer GPA
Freshman | 148 | 1.373621621621621 | 1.406837837837838 | 1.582823529411764
Junior | 15 | 1.813066666666667 | 1.868533333333333 | 2.285909090909091
Senior | 3 | 2.251333333333334 | 1.925333333333333 | 1.525
Sophomore | 24 | 1.734375 | 1.843416666666667 | 1.661545454545455
Special | 9 | 1.172555555555556 | 1.024444444444444
Total
2009 Fall Cohort
 | Mean ACT
 | Not on Probation | On Probation | [NAME]'s D | Significance
ACT Comp | 21.2 | 18.34 | 0.87855 | ***
ACT Engl | 20.54 | 17.06 | 0.804296 | ***
ACT Math | 20.96 | 17.85 | 0.89104 | ***
ACT Reading | 21.61 | 18.58 | 0.66696 | ***
ACT Science Reading | 21.09 | 19.11 | 0.551431 | ***
*p < 0.10; **p < 0.05; ***p < 0.0001
Name | Advisees on Probation | Total Advisees | Prcnt
[NAME], [NAME] | 1
Bailey, [NAME] | 1
[NAME], Ahrar | 1
Fuqua, [NAME] | 1
[NAME], [NAME] | 1
Silva, [NAME] | 1
Smith, Brian | 3
[NAME], Chad | 7
Lamb, Charles | 7
[NAME], [NAME] | 1
Spencer, [NAME] | 3
Crawford, [NAME] | 1
Wolff, [NAME] | 1
[NAME], [NAME] | 1
[NAME], Gina | 2
Boomer, Holly | 1
[NAME], [NAME] | 2
Knutson, [NAME] | 1
[NAME], [NAME] | 1
Alsup, [NAME] | 1
[NAME], [NAME] | 1
Valades, [NAME] | 16
Neighbours, Judith | 1
Pavel, [NAME] | 3
[NAME], [NAME] | 1
Schallenkamp, [NAME] | 4
Prosser, [NAME] | 1
Zehfus, Micheal | 1
Hickenbotham, Micheline | 1
Zehfus, [NAME] | 2
Marker, [NAME] | 1
[NAME], [NAME] | 2
[NAME], Sunhwi | 2