tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 267958d1380315263-help-sorting-two-tiered-and-if-forumula-use-tie-breaker
Sheet: Arrayformula

 |  |  |  |  |  |  |  | [NAME]
F Name | Surname | Other info 1 | Other info 2 | No. | Laps | Time In | Position | DNF?
A | Bloggs |  |  | 1 | 2 | 13:31:30
B | Bloggs |  |  | 2 | 3 | 14:31:30 | 21
C | Bloggs |  |  | 3 | 4 | 13:44:32 | 12
d | Bloggs |  |  | 4 | 5 | 13:30:25 | 6
e | Bloggs |  |  | 5 | 2 | 13:31:20 | 24
f | Bloggs |  |  | 6 | 3 | 13:41:54 | 18
g | Bloggs |  |  | 7 | 4 | 13:43:32 | 11
h | Bloggs |  |  | 8 | 5 | 13:31:30 | 7
i | Bloggs |  |  | 9 | 6 | 13:51:23 | 4
j | Bloggs |  |  | 10 | 7 | 13:56:23 | 2
k | Bloggs |  |  | 11 | 8 | 13:32:17 | 1
l | Bloggs |  |  | 12 | 1 | 12:32:14 | 26
m | Bloggs |  |  | 13 | 2 | 13:20:45 | 23
n | Bloggs |  |  | 14 | 3 | 13:35:45 | 17
o | Bloggs |  |  | 15 | 4 | 13:45:32 | 13
p | Bloggs |  |  | 16 | 5 | 14:01:34 | 8
q | Bloggs |  |  | 17 | 4 | 13:56:45 | 14
r | Bloggs |  |  | 18 | 3 | 13:24:54 | 16
s | Bloggs |  |  | 19 | 2 | 11:12:32 | 22
t | Bloggs |  |  | 20 | 6 | 13:43:56 | 3
u | Bloggs |  |  | 21 | 5 | 13:30:11 | 5
v | Bloggs |  |  | 22 | 4 | 1900-01-02 15:08:00 | 15
w | Bloggs |  |  | 23 | 3 | 13:43:56 | 19
x | Bloggs |  |  | 24 | 3 | 13:43:58 | 20
y | Bloggs |  |  | 25 | 4 | 13:42:45 | 9
z | Bloggs |  |  | 26 | 4 | 13:42:46 | 10
EVENT FINISH TIME | 13:30:00
 |  |  |  |  |  |  | ^^^^^
 |  |  |  |  |  |  | Enter a position
 |  |  |  |  |  |  | Ie. 1, 2, 3. for 1st,
 |  |  |  |  |  | Primary | 2nd, 3rd.
 |  |  |  |  |  | Sort | Based on No of
 |  |  |  |  |  |  | laps.
 |  |  |  |  |  | Secondary | If Tied on laps.
 |  |  |  |  |  | Sort | Lowest time wins
Spreadsheet: daren_farmer__6586__egmnom-Feb
Sheet: EGM 201

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-001
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-02-01 00:00:00
Fax: | (713)646-5799 | Stop:
 |  | 2000-02-29 00:00:00
RECEIPTS |  |  | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB | FEB
METER # | [NAME] | SUPPLIER | 1
35 | MOSS BLUFF |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
71 | TEXOMA |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
584 | VALERO - AGUA DULCE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
644 | LONE STAR KATY |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
701 | WESTERN HEADER |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4045 | EXXON CLEAR LAKE | SUPERIOR
4132 | EXXON KATY | ECT | 10000 | 10000 | 10000 | 10000 |  |  |  |  | 10000
4132 | EXXON KATY | ECT | 9500 | 9500 | 9500 | 9500 | 9500 | 9500 | 9500 | 9500 | 9500
4132 | EXXON KATY |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4132 | EXXON KATY  (AQ SS) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4132 | EXXON KATY |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4531 | NEEDVILLE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6269 | PG&E THOMPSONVILLE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6351 | TEJAS THOMPSONVILLE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6721 | PAWNEE PLANT |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6780 | [NAME] | Encina | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1591 | 0
6780 | [NAME] | Quadalope | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7038 | TRANS TX AUGA DULCE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7285 | MOSS BLUFF |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8740 | MID TX KATY |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6040 | VALERO RIVERSIDE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7038 | [NAME] | CONOCO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9643 | EXXON KING RANCH |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
98675710 | CROW OCONNER | [NAME] | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150
ZZZZ | FORCED PAYBACK | ENTEX/HPL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
35 | MOSS BLUFF
522 | HARDY
1000 | FORMOSA PLANT | FORMOSA
1060 | SHELL DEER PARK
1063 | LYONDELL/CITGO
1168 | [NAME]
1233 | TX CITY
1244 | KOCH REFINERY
1427 | GSU SABINE | ENTERGY | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000 | 13000
4132 | EXXON KATY HPL | AMOCO
7340 | LUFKIN CHAMPION | DONAHOE
1264 | WINNIE PIPELINE
1319 | ENERCORP
1326 | ENTERPRISE | ENTERPRISE
1373 | LYONDELL
1394 | HILL PETRTO | DYNEGY
1412 | HL&P PH ROBINSON
1427 | GSU SABINE | RES
1428 | DUPONT BEAUMONT | DUPONT
1431 | MARATHON TX CITY
1485 | OXY BATTLE GROUND | OXY
1507 | SABINE PIPELINE
1508 | IGS DODGE STREET
1563 | DESTECH
3069 | BAMMEL STORAGE | MIDCON/ENTEX
4132 | EXXON KATY HPL | RES
4531 | NEEDVILLE
3537 | [NAME] | KET
8020 | BAYPORT PLANT
 | HUNTSMAN | ENTEX
ZZZZ | IMBALANCE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | DELIVERY TOTAL
 |  | BALANCE
Spreadsheet: 328938d1404143534-formula-extension-help-publisher-control-sheet-may
Sheet: Rev by ad source

Reporting data as of: June 02 2014 11:59:59 GMT
Coull UK / 20476
DateTime Range: [May 1].[2014].[00:00] to [May 31].[2014].[23:59]
Time Zone: UTC
Filters: none
 | Manually fill in from Ad source type
Ad source connection | Ad source | Impressions | Revenue | Revenue eCPM
AA_DFP_TEST_MEDIUM | DFP - Test | 20 | 0.0002 | 0.01
Adknowledge $10 | [NAME] | 63696 | 636.95 | 10
Adknowledge $3 | [NAME] | 367799 | 1103.376 | 3
Adknowledge $4 | [NAME] | 195644 | 782.512 | 4
Adknowledge $5 | [NAME] | 449562 | 2209.622 | 4.92
Adknowledge $6 | [NAME] | 110612 | 663.63 | 6
Adknowledge $7 | [NAME] | 100495 | 703.395 | 7
Adknowledge $8 | [NAME] | 156159 | 1249.232 | 8
Adknowledge $9 | [NAME] | 39113 | 352.008 | 9
Adknowledge DM $10 | [NAME] | 21620 | 216.2 | 10
Adknowledge DM $7 | [NAME] | 1552 | 10.864 | 7
Adknowledge DM $8 | [NAME] | 2779 | 22.232 | 8
AdMedia_SpotXchange | SpotXchange | 11984 | 73.7355 | 6.15
Altitude_SpotXchange | SpotXchange | 431904 | 3999.8808 | 9.26
Anyclip_ADK - $5 | [NAME] | 818554 | 4092.545 | 5
Anyclip_SpotXchange | SpotXchange | 959835 | 6970.8134 | 7.26
Blue Water CAN  - $4 | Blue Water | 25377 | 101.508 | 4
Blue Water UK - $4 | Blue Water | 504 | 2.016 | 4
Blue Water US - $4 | Blue Water | 58891 | 235.552 | 4
Coull Transcoder test - Do not use | Coull | 250 | 0.0025 | 0.01
Crazy4Media New | Creafi Online Media Publisher | 36179 | 209.8208 | 5.8
Czarina_Blue_Water - $2 | Blue Water | 223983 | 447.948 | 2
Czarina_SpotXchange | SpotXchange | 221895 | 1626.7681 | 7.33
Dailymotion_ADK $9.50 | [NAME] | 386278 | 3669.113 | 9.5
Dailymotion_SpotXchange | SpotXchange | 1001683 | 10328.9455 | 10.31
JW Player - AdX SDK Adaptor - SBM | Google AdX | 5 | 0.0001 | 0.01
JW Player - IMA 3 connection - SBM | Google AdX | 15 | 0.0002 | 0.01
Kitara_SpotXchange | SpotXchange | 10320 | 114.0644 | 11.05
[NAME] | SpotXchange | 5143 | 50.5335 | 9.83
LiveRail Central | LiveRail Central | 21275099 | 184299.9182 | 8.66
Matomy - SpotXchange | SpotXchange | 3742 | 28.7294 | 7.68
QA Smaato Prod | Smaato | 49 | 0.049 | 1
QA Smaato Stage | Smaato | 58 | 0.058 | 1
Sidereel_ADK - $5 | [NAME] | 15360 | 76.8 | 5
Sidereel_SpotXchange | SpotXchange | 26858 | 275.4615 | 10.26
Smaato - Mobile - Generic | Smaato | 1253612 | 1253.609 | 1
Smaato - Tablet - Generic | Smaato | 331485 | 331.485 | 1
Stickyads_SpotXchange | SpotXchange | 22 | 0.0426 | 1.93
Uvidi_SpotXchange | SpotXchange | 467323 | 4012.4861 | 8.59
Videomize_ADK - $4 | [NAME] | 81654 | 326.608 | 4
Videomize_SpotXchange | SpotXchange | 601779 | 3345.7668 | 5.56
VideoNatives_SpotXchange | SpotXchange | 37220 | 175.1611 | 4.71
Viewster - SpotXchange | SpotXchange | 134513 | 1592.6511 | 11.84
Web3_SpotXchange | SpotXchange | 13 | 0.0173 | 1.33
 | Lynda | 0 | 0.3
 | Nike Inc | 0 | 1.13998
Less
Google AdEx | Google AdEx
Smaato | Smaato
SpotXchange | SpotXchange
Lynda | Lynda
Nike Inc | Nike Inc
Add
Google AdEx
Smaato | Smaato
Open X | Open X |  |  | Multiplied revenue by average monthly ex rate
SpotXchange | SpotXchange
 | Totals for all
Spreadsheet: errol_mclaughlin_jr__10866__46M 1-Month Prepay
Sheet: $46M 1-Month Prepay

$46 M 1-Month Prepay
Execution Date |  | 2001-10-03 00:00:00
Totals
Nominal Value
PV Libor Value
PV COF Value
Difference
Libor / COF
Libor / Nominal
COF / Nominal
 |  | Actual |  |  |  | COF | Libor
Date |  | Days | Discount Days | Libor | COF | Discount Rate | Discount Rate |  | Monthly Payment | Discounted @ COF | Discounted @ Libor
2001-10-03 00:00:00 |  |  |  | 0.0264101498214844 | 0.0406627067496963 |  |  |  | 46000000
2001-11-03 00:00:00
Spreadsheet: a66a3d8d-074b-43ad-bf36-aeceb333b12b
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
EGFR | Test | EGFR | [NAME], 29 Mutation Panel, Tumor | [NAME], Tumor | Polymerase Chain Reaction (PCR) Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Plastic container: PlCont |  |  |  | Varies | Pathology report must accompany specimen in order for testing to be performed.   Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions.   Preferred: [NAME]: Tissue Container/Tube: Tissue block Collection Instructions: Submit a formalin-fixed, paraffin-embedded tissue block.   Acceptable: [NAME]: Tissue Container/Tube: Slides Specimen Volume: 1 stained and 5 unstained Collection Instructions: Submit 1 slide stained with hematoxylin-and-eosin and 5 unstained, non-baked slides with 5-micron thick sections of the tumor tissue. | Formalin-fixed, paraffin-embedde | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; 10 am | 5 days | 7 days | 1 | 81235 |  |  |  |  | Rochester
EGFR | [NAME] | VARIES | Varies |  |  |  | Ambient
EGFR | Result | 33305 | [NAME] | [NAME] | Alphanumeric
EGFR | Result | 33306 | [NAME] | [NAME] | Alphanumeric
EGFR | Result | 33307 | Source | Source | Alphanumeric
EGFR | Result | 33308 | Order Date | Order Date | Alphanumeric
EGFR | Result | 33309 | Reason for Referral | Reason for Referral | Alphanumeric
EGFR | Result | 33310 | Method | Method | Alphanumeric
EGFR | Result | 33311 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
EGFR | Result | 33312 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
EGFR | Result | 33313 | Amendment | Amendment | Alphanumeric
EGFR | Result | 33314 | Reviewed By: | Reviewed By: | Alphanumeric
EGFR | Result | 33315 | Release Date | Release Date | Alphanumeric
EGFR | [NAME] | SLRVW | Slide Review | Slide Review |  |  |  |  |  |  | For billing purposes only. |  |  |  |  |  |  | 1 | 88381 |  |  | Yes | No
Spreadsheet: ee045590-ed75-4ea6-a6d0-3d50a5ad23bc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: September 21, 2014 (2:18 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 835565d1688657664-index-match-with-filters-sample-finder-snapshot
Sheet: Archive position

Last name | First name | Birth date | Sex | Sample | Test | Analyser | Result datetime | Result | Unit | Request department | Request physician code
PATIENT 1 | TEST | 2000-01-01 00:00:00 | M | 123456 | ARCHIVE | MANUAL ARCHIVE | 2023-07-01 12:00:00 | RACK 1 POS 3 | MMOL/l | A&E | DR TEST
PATIENT 2 | TEST | 2000-01-02 00:00:00 | M | 123457 | ARCHIVE | MANUAL ARCHIVE | 2023-07-02 12:00:00 | RACK 2 POS 1 | MMOL/l | A&E | DR TEST
PATIENT 3 | TEST | 2000-01-03 00:00:00 | M | 123458 | ARCHIVE | MANUAL ARCHIVE | 2023-07-03 12:00:00 | RACK 3 POS 5 | MMOL/l | GP | DR TEST
PATIENT 4 | TEST | 2000-01-04 00:00:00 | M | 123459 | ARCHIVE | MANUAL ARCHIVE | 2023-07-04 12:00:00 | RACK 4 POS 2 | MMOL/l | GP | DR TEST
PATIENT 5 | TEST | 2000-01-05 00:00:00 | M | 123460 | ARCHIVE | MANUAL ARCHIVE | 2023-07-05 12:00:00 | RACK 4 POS 4 | MMOL/l | A&E | DR TEST
Spreadsheet: 841718d1693899229-how-to-display-certain-text-based-on-data-question
Sheet: rumus

 |  |  |  |  |  | RINA INDRIANA | rina
 |  |  |  |  |  | SINDHU GUMILANG PRASONTO | sindu
 |  |  |  |  |  | BENI NURDIANSAH | beni
 |  |  |  |  |  | [NAME] | rifa
 |  |  |  |  |  | NERRY YUDISTYA I.R | neri
 |  |  |  |  |  | ADE YANUWARDANA | ade
 |  |  |  |  |  | NERRY YUDISTYA I.R | anan
 |  |  |  |  |  | DIMAS ARMAN ZULFANI | dimas
6767 | mr a, mrs b | trim mr a |  | mrs b | b | AICO KINANTY | aico
344 | mrs c, mrs x | trim mrs c |  | [NAME] | x | TITO SURYO RAHARJO | [NAME]
 | DIMAS [NAME], GATOT TEGUH APRIANTO |  |  | DIMAS ARMAN ZULFANI |  | SITI DENISA MAHARATU | denisa
 | [NAME], SYAHIRUL ALIM WICAKSANA |  |  | TITO SURYO RAHARJO | #[NAME]! | mrs b | b
 | ADE YANUWARDANA, GATOT TEGUH APRIANTO |  |  | SITI DENISA MAHARATU | #[NAME]! | [NAME] | x
 | GATOT TEGUH APRIANTO, DIMAS ARMAN ZULFANI |  |  | [NAME] | #[NAME]!
 | SYAHIRUL ALIM WICAKSANA, UMU SARIFAH |  |  | SINDHU GUMILANG PRASONTO | #[NAME]!
 | [NAME], SYAHIRUL ALIM WICAKSANA |  |  | [NAME] | #[NAME]!
 | GATOT TEGUH APRIANTO, SITI DENISA MAHARATU |  |  | SINDHU GUMILANG PRASONTO | #[NAME]!
 |  |  |  | [NAME] | #[NAME]!
Spreadsheet: jeffrey_a_shankman__13928__JCC Swap Model-DPR (JH)
Sheet: Swap Calculation

 | JCC Swap Calculation Page
 | Today
 |  | Date | Brent Swap ($[NAME]) | JCC Fwd Curve (USD/bbl) | JCC Fwd Curve (Yen/bbl) | JCC Fwd Curve (Yen/kL) |  | [NAME] (kL) | [NAME] LIBOR | Discount Factor | Disc. Vol. ([NAME])
Spreadsheet: 741879d1627394663-count-and-number-the-amount-of-times-that-a-unique-value-appears-in-increments-of-one-sample-data
Sheet: Sheet1

Field 1 | Corresponding Field ([NAME] should give the results below) | Column for Formula | Notes
G01029 | 1
G01029 | 2
G01029 | 3
G01029 | 4
G01029 | 5
G01029 | 6
G01029 | 7
G01029 | 8
G01029 | 9
G01029 | 10
G01029 | 11 |  | G01029 appears 11 times and we assign a value that goes up in increments of one, starting by value "1"
G01030 | 1
G01031 | 2
G01031 | 3
G01031 | 4
G01031 | 5
G01031 | 6 |  | [NAME] appears 6 times and we assign a value that goes up in increments of one, starting by value "1"
G01032 | 1
G01032 | 2
G01032 | 3
G01032 | 4
G01032 | 5
G01032 | 6
G01032 | 7
G01032 | 8
G01032 | 9
G01032 | 10
G01032 | 11 |  | G01032 appears 11 times and we assign a value that goes up in increments of one, starting by value "1"
Spreadsheet: 39206d1237396380-update-formula-to-round-off-to-a-whole-number-mewsptosheet
Sheet: Sheet1

 |  | 2009-01-31 00:00:00 |  |  |  |  |  | 2009-02-28 00:00:00 |  |  |  | 2009-03-31 00:00:00 |  |  |  | 2009-04-30 00:00:00 |  |  |  | 2009-05-31 00:00:00 |  |  |  | 2009-06-30 00:00:00 |  |  |  | 2009-07-31 00:00:00 |  |  |  | 2009-08-31 00:00:00 |  |  |  | 2009-09-30 00:00:00 |  |  |  | 2009-10-31 00:00:00 |  |  |  | 2009-11-30 00:00:00 |  |  |  | 2009-12-31 00:00:00
 |  | Bal. Forward | Accrued | Used | Remaining |  |  | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining
Employee | Hire Date
[NAME] | 2007-12-15 00:00:00 | 0 | 6.64 | 0 | 6.64 |  |  | 6.64 | 6.64 |  | 13.28 | 13.28 | 6.64 |  | 19.92 | 19.92 | 6.64 |  | 26.56 | 26.56 | 6.64 |  | 33.2 | 33.2 | 6.64 |  | 39.84 | 39.84 | 6.64 |  | 46.48 | 46.48 | 6.64 |  | 53.12 | 53.12 | 6.64 |  | 59.76 | 59.76 | 6.64 |  | 66.39999999999999 | 66.39999999999999 | 6.64 |  | 73.03999999999999 | 73.03999999999999 | 6.64 |  | 79.67999999999999 | Could we round this off any?
[NAME] | 2006-02-17 00:00:00 | 1 | 6.64 | 1 | 6.64 |  |  | 6.64 | 6.64 |  | 13.28 | 13.28 | 10 |  | 23.28 | 23.28 | 10 |  | 33.28 | 33.28 | 10 |  | 43.28 | 43.28 | 10 |  | 53.28 | 53.28 | 10 |  | 63.28 | 63.28 | 10 |  | 73.28 | 73.28 | 10 |  | 83.28 | 83.28 | 10 |  | 93.28 | 93.28 | 10 |  | 103.28 | 103.28 | 10 |  | 113.28
[NAME] | 2005-03-01 00:00:00 |  | 30 |  | 30 |  |  | 30 | 30 |  | 60 | 60 | 10 |  | 70 | 70 | 10 |  | 80 | 80 | 10 |  | 90 | 90 | 10 |  | 100 | 100 | 10 |  | 110 | 110 | 10 |  | 120 | 120 | 10 |  | 130 | 130 | 10 |  | 140 | 140 | 10 |  | 150 | 150 | 10 |  | 160
 |  | cat!
mew!----- |  |  |  |  | This table is used to reference the appropriate number by # of months
 |  |  |  | 0 | 0.83
 |  |  |  | 37 | 1.25
 |  |  |  | 61 | 1.67
Spreadsheet: 292438d1390596022-changing-reference-saving-original-calculations-changingreference
Sheet: Cost Entries

date | [NAME] | Level | Cost
2014-01-01 00:00:00 | 1 | High
2014-01-02 00:00:00 | 1 | Low
2014-01-03 00:00:00 | 1 | Medium
2014-01-04 00:00:00 | 1 | Low
2014-01-05 00:00:00 | 1 | Low
2014-01-06 00:00:00 | 1 | Low
2014-01-07 00:00:00 | 1 | High
2014-01-08 00:00:00 | 1 | High
2014-01-09 00:00:00 | 1 | Medium
2014-01-10 00:00:00 | 1 | High
2014-01-11 00:00:00 | 1 | Low
2014-01-12 00:00:00 | 1 | Medium
2014-01-13 00:00:00 | 1 | High
2014-01-14 00:00:00 | 1 | High
2014-01-15 00:00:00 | 1 | Low
Spreadsheet: 846076d1697371404-power-query-how-to-extract-the-status-for-each-workbook-pq-desired-outputs
Sheet: Sheet1

 | Desired Outputs
 | Filename | Overall Status: |  |  |  | Filename | [NAME] | Range | Description | Status
 | Test Book 1.xlsx | Error |  |  |  | Test Book 1.xlsx | [NAME] | [NAME] | [NAME] | Ok
 | Test Book 2.xlsx | Ok |  |  |  | Test Book 1.xlsx | [NAME] | [NAME] | [NAME] | Ok
 | Test Book 3.xlsx | Error |  |  |  | Test Book 1.xlsx | [NAME] | [NAME] | [NAME] | Ok
 |  |  |  |  |  | Test Book 1.xlsx | [NAME] | [NAME] | [NAME] | Error
 |  |  |  |  |  | Test Book 1.xlsx | [NAME] | [NAME] | [NAME] | Ok
 |  |  |  |  |  | Test Book 2.xlsx | [NAME] | [NAME] | [NAME] | Ok
 |  |  |  |  |  | Test Book 2.xlsx | [NAME] | [NAME] | [NAME] | Ok
 |  |  |  |  |  | Test Book 2.xlsx | [NAME] | [NAME] | [NAME] | Ok
 |  |  |  |  |  | Test Book 2.xlsx | [NAME] | [NAME] | [NAME] | Ok
 |  |  |  |  |  | Test Book 2.xlsx | [NAME] | [NAME] | [NAME] | Ok
 |  |  |  |  |  | Test Book 3.xlsx | [NAME] | [NAME] | [NAME] | Ok
 |  |  |  |  |  | Test Book 3.xlsx | [NAME] | [NAME] | [NAME] | Error
 |  |  |  |  |  | Test Book 3.xlsx | [NAME] | [NAME] | [NAME] | Ok
 |  |  |  |  |  | Test Book 3.xlsx | [NAME] | [NAME] | [NAME] | Ok
 |  |  |  |  |  | Test Book 3.xlsx | [NAME] | [NAME] | [NAME] | Ok
Spreadsheet: andy_zipper__301__NYMEX Straddles
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | H | 210 | 25.5 | 26.5 | 0.6515500000000021 | -0.01709999999999812
 | J | 215 | 34.5 | 35.5 | 0.5613499999999966 | -0.01169999999999871
 | K | 225 | 40.5 | 42 | 0.5004999999999988 | -0.01319999999999855
 | M | 230 | 45.5 | 47 | 0.4643000000000006 | -0.005099999999999438
 | N | 235 | 52 | 53.5 | 0.4643999999999836 | -0.008699999999999042
 | Q | 240 | 60 | 62 | 0.4768999999999828 | 0.00389999999999957
 | U | 240 | 63 | 66 | 0.4677499999999838 | -0.006599999999999273
 | V | 245 | 69.5 | 71.5 | 0.4729999999999832 | -0.006299999999999306
 | X | 270 | 81 | 83 | 0.4731499999999832 | -0.006299999999999306
 | Z | 290 | 92 | 94 | 0.4753999999999829 | -0.004199999999999537
 | F | 300 | 102 | 103 | 0.4852500000000061 | -0.0005999999999999339
 | G | 295 | 103 | 106 | 0.4852500000000061 | 0.005249999999999422
 | H03 | 285 | 96 | 99 | 0.448699999999999 | -0.007799999999999141
 | M03 | 280 | 87.5 | 90 | 0.3799000000000006 | #[NAME]!
 |  |  | 2002-02-05 14:44:46.850000
 |  |  | Crude Oil Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | H | 2000 | 132 | 142 | 0.6182999999999836 | 0.007799999999999141
 | J | 2050 | 250 | 255 | 0.4760499999999968 | -0.008399999999999075
 | K | 2050 | 332 | 345 | 0.4726499999999956 | 0.00299999999999967
 | M | 2050 | 383 | 395 | 0.4592499999999944 | 0.008999999999999009
 | N | 2050 | 420 | 435 | 0.4419999999999942 | -0.004199999999999537
 | Q | 2050 | 450 | 460 | 0.424049999999995 | 0.0005999999999999339
 | U | 2050 | 465 | 475 | 0.4085000000000001 | 0.002399999999999736
 | V | 2050 | 475 | 495 | 0.3908500000000018 | 0.00389999999999957
 | X | 2050 | 480 | 500 | 0.3703499999999875 | -0.000299999999999967
 | Z | 2050 | 493 | 505 | 0.3608999999999885 | 0.005999999999999339
 | F | 2100 | 500 | 515 | 0.3455999999999902 | N/A
 | G | 2100 | 505 | 520 | 0.3149999999999936 | N/A
 |  |  | 2002-02-05 14:43:50.500000
Spreadsheet: 696646d1600938134-hyperlink-with-vlookup-in-another-file-27-men-heavier-fleece-pullover-hoodie
Sheet: SPEC

CUSTOMER | TEAMATICAL |  | NO. : | 27M |  |  |  |  |  | DATE: | 2019-12-24 00:00:00
SPORT |  |  | STYLE: |  |  |  |  |  |  | SIZES: | XS-2XL
 |  |  |  |  |  |  |  |  |  | BASE SIZE:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tolerance [cm]  +/-
Measurements Chart - Shirts |  |  |  | XS | XS measured | S | S measured | M | M measured | L | L measured | XL | XL measured | XXL | XXL measured | XXXL | XXXL measured |  | COMMENT
1/2 chest |  | 1/2 อกกว้าง |  | 46 |  | 51 |  | 56 |  | 61 |  | 66 |  | 71 |  | 76
1/2 bottom hem |  | 1/2 ชายกว้าง |  | 38 |  | 43 |  | 48 |  | 53 |  | 58 |  | 63 |  | 68
front length from HSP |  | ยาวหน้าจากข้างคอ |  | 65.4 |  | 68.3 |  | 71.1 |  | 74 |  | 76.8 |  | 79.7 |  | 82.5
back length from HSP |  | ยาวหลังจากข้างคอ |  | 65.4 |  | 68.3 |  | 71.1 |  | 74 |  | 76.8 |  | 79.7 |  | 82.5
short sleeve length form CB |  | แขนยาวจากหัวแขน |  | 63.6 |  | 64.9 |  | 66.2 |  | 67.5 |  | 68.8 |  | 70 |  | 71.3
shirst cuff opening |  | ปลายแขนกว้าง |  | 9.25 |  | 9.75 |  | 10.5 |  | 11.2 |  | 11.75 |  | 12.5 |  | 13
armhole height |  | [NAME] |  | 21.75 |  | 23 |  | 24.25 |  | 25.5 |  | 26.75 |  | 28 |  | 29.25
1/2 biceps |  | 1/2 ต้นแขน |  | 18.5 |  | 20 |  | 21.5 |  | 23 |  | 24.5 |  | 26 |  | 27.5
cuff height |  | ขอบแขนสูง |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
back neck width |  | คอหลังกว้าง |  | 20.5 |  | 21.5 |  | 22.5 |  | 23.5 |  | 24.5 |  | 255 |  | 26.5
front neck drop |  | คอหน้าลึก |  | 11.6 |  | 11.9 |  | 12.2 |  | 12.5 |  | 12.8 |  | 13.1 |  | 13.4
back neck drop |  | คอหลังลึก |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 2
collar cirumference in total |  | รอคอกว้าง |  | 51.8 |  | 54.1 |  | 56.3 |  | 58.6 |  | 60.8 |  | 63.1 |  | 65.3
pocket length |  | กระเป๋ายาว |  | 23.1 |  | 23.7 |  | 24.3 |  | 25 |  | 25.5 |  | 26.2 |  | 26.9
hood length |  | หมวกยาว |  | 44.5 |  | 45.9 |  | 47.2 |  | 48.6 |  | 49.9 |  | 51.3 |  | 52.6
1/2 hood width - on 1/2 hood height |  | 1/2 หมวกกว้าง |  | 25.1 |  | 25.9 |  | 26.7 |  | 27.5 |  | 28.3 |  | 29.1 |  | 29.9
Spreadsheet: 854176d1704147362-closest-date-with-criteria-with-maxifs-formula-closestdate
Sheet: Sheet1

Date | Symbol | Closest RS Date |  |  |  | Date | Symbol | [NAME]
2023-12-04 00:00:00 | MULN |  |  |  |  | 2023-05-04 00:00:00 | MULN | 1 for 10
2023-12-05 00:00:00 | ABC |  |  |  |  | 2023-08-11 00:00:00 | MULN | 1 for 20
2023-12-06 00:00:00 | ABC |  |  |  |  | 2023-12-04 00:00:00 | SYTA | 1 for 10
2023-12-07 00:00:00 | ABC |  |  |  | Desired date in cell C2-> | 2023-12-21 00:00:00 | MULN | 1 for 50
2023-12-30 00:00:00 | MULN |  |  |  | Desired date in cell C6 -> | 2023-12-30 00:00:00 | MULN | 1 for 10
Spreadsheet: 599522d1543160456-fill-rows-based-on-payment-type-jessica
Sheet: Jessica

 | Payment Type | Date | Amount | Variable Expense | Fixed Expense | Payee | Notes