tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 111714d1308046244-cheking-through-data-and-show-status-sanlen_data
Sheet: Detail

 |  |  |  |  |  | TOWER |  |  |  |  |  |  |  |  |  | BTS ROOM COMPLETION |  | FENCE/ GATE | GROUNDING | READY FOR TELECOM  INSTALLATION (RFTI)
 | CW MOBILIZATION/LAYOUT |  |  | EXCAVATION |  | CONCRETE POURING |  |  |  | BACKFILL | DELIVERY BATCH | DELIVERY  STATUS |  | ERECTION
 |  |  |  |  |  | FOOTING |  | COLUMN
NAME | FC | AC | REMARKS | FC | AC | FC | AC | FC | AC | AC |  | FC | AC | FC | AC | FC | AC | AC | AC | FC | AC
Name1
[NAME] |  | 12
Name3
Name4 |  | 16
Name5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-15 00:00:00
Name6 |  |  |  |  | HALTED
Name7
Name8
Name9
Name10
Name11 |  |  |  |  |  |  |  |  |  | HALTED
Name12
Name13
 |  | *** if C is number then the color in my Status sheet should be Orange
 |  | *** if C is blank then color in my status sheet should be White
 |  | *** if any of C to V contain the word HALTED then the color in my status sheet should be Red
 |  | *** if V is date then color should be blue
Spreadsheet: 792236d1660804154-date-function-with-transpose-forum-upload-hd-5-1-
Sheet: Calculator

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60
CHECK IN
CHECK OUT
FATIGUE
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 14 March 2012

Daily Morning Staff |  |  |  |  | Wednesday
 | 07:30-14:30 |  | 2012-03-14 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS | Emergency Leave (Comp off)
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 9c753d7a-aa69-4b58-9ade-ddff9bef0f36
Sheet: EQUIPMENT INPUT

Assessment  Date | Building Portfolio | Building Site | Building ID | Building Abbr | Building Name | Floor | Room | Keyword | EQ_Type | Equipment Group/Keyword | Equipment Type | Status | Condition  (at assessment) | Field Notes | Area Serviced (Bldg/Floor/Wing/Room) | Criticality | EQ_Group | Nomenclature | len | Old EQ_ID (If Existing) | EQ_ID | No. | In-Field Reference Name/Nomenclature | Parent [NAME] | State_ID | MFR | Manufacturer | [NAME] No | Mfr Serial No | Mfr Part No/Date/Code | Acquisition Date | Acquisition Vendor | Acquisition Comments | Warranty Vendor | Warranty Expiration Date | Warranty Usage Expiration | Warranty Comments | Current Replacement Cost | Spec (FILTER) | Spec (BELTs) | Spec (MOTOR) | Spec (REFRIGERANT) | Spec (MECH COUPLINGS  & SEALS) | Spec (TONS) | Spec (CFM) | Spec  (BTU/Hr) | Spec  (STATIC PRESSURE) | Spec  (HP) | Spec  (RPM) | Spec  (HERTZ) | Spec  (PHASE) | Spec  (AIR TEMP IN/OUT) (SUMMER/WINTER) | Spec  (WATER TEMP IN/OUT) (SUMMER/WINTER) | [NAME](HEAD-FEET or TOTAL [NAME] HEAD (TDH) | Spec  (GPM) | Spec (IMPELLER DIAMETER) | Spec  (PSI) | Spec (GALLONS) | Spec  (KVA) | Spec (AMPS) + (MAIN LUG or BREAKER) (OPEN or CLOSED) | Spec (CIRCUITS) | Spec  (VOLTS) | Spec (WATTS) | Spec  (WIRE) | Spec  (POLES) | Spec  (MCA) | Spec  (MAX FUSE) | Spec (OTHER)
Example Only: |  |  |  |  | UNIVERSITY HALL | 0 | 001 |  |  | AIR HANDLING UNIT | AIR HANDLER, HVAC > 30K CFM | ACTIVE | VERYGOOD | UNIT INCLUDES COMBINED HRU | 1st & 2nd floor |  |  |  |  |  |  | 001 | AHU-1 |  |  |  | HAW'S PRODUCTS | [NAME] | 472010C08248-04 | MFR DATE: 11/15/2010 | 2012-01-10 00:00:00 | -VENDOR- |  | -VENDOR- | 2015-01-10 00:00:00 |  | 3 YEARS PARTS ONLY |  |  |  | FORMAT: MOTOR: MAKE, MODEL#/CAT#/SPEC# or TYPE:, SN#, HP:,  RPM:, PH:, VOLTS:, AMPS:, PF:, DUTY CYCLE, FRAME:, ENCL:, INSUL CLASS:, NEMA RATING:, WEIGHT: | R410A, 4.2LBS |  |  | 7500 RETURN CFM 7500 SUPPLY CFM |  | 8.5" |  |  | 60 | 3 | 70.9IN,110.4OUT | 180IN,136.3OUT |  |  |  |  |  |  |  |  | 460
Example Only: |  |  |  |  | UNIVERSITY HALL | 0 | 001 |  |  | FAN | FAN, EXHAUST, BELT | ACTIVE | VERYGOOD | GREASE FITTING ON MOTOR | 1st floor commons |  |  |  |  |  |  | 003 | EF-3 |  |  |  | GREENHECK | 22-QEP-4-60-11 | [PHONE] |  |  | -VENDOR- |  | -VENDOR- |  |  | 1 Year Manufacturer's Warranty for Defects |  | EXAMPLE: FILTERS: PRE: (X6) MERV8 24X12X4, (X6) MERV8 24X24X4 AIR GUARD (DP 4-40 MAX) FINAL: (X3) MERV14 24X24X12 METAL CASE SYNTHETIC RIGID CELL WITH HEADER (16443FS), (X3) MERV14 24X12X12 METAL CASE SYNTHETIC RIGID CELL WITH HEADER (16440FS). | (X1) 4L490 (A47) | EXAMPLE: MOTOR: BALDOR RELIANCE CAT#VM3111, SPEC#34F12-255, SN#W1111161326, HP:3/4, RPM:3450, PH:3, VOLTS:230/460, AMPS:2.6/1.3, PF:73, DUTY CYCLE:, FRAME:56C, ENCL:OPEN, INSUL CLASS:B, NEMA RATING:40C AMB-CONT |  | A33 |  | 7500 [NAME] |  | 8.5" | 15 | 1750 | 60 | 3 |  |  |  |  |  |  |  |  |  |  | 460
Spreadsheet: 790653d1659930909-split-date-and-time-in-column-dataset
Sheet: Sheet1

Check | Order Type | Date | Time | Minutes | Employee | Item Count | Voids | Discounts | Service Charges | Check Total
8146 | Order Type 1 | 2022-01-01 00:00:00 | 2022-01-01 10:12:59.700000 | 2 | Plongkaew | 3 | 0 | 0 | 14 | 164.78
8147 | Order Type 1 | 2022-01-01 00:00:00 | 2022-01-01 10:31:35.723000 | 26 | Plongkaew | 2 | 0 | 0 | 18 | 211.86
8148 | Order Type 1 | 2022-01-01 00:00:00 | 2022-01-01 10:47:38.960000 | 20 | Plongkaew | 2 | 0 | 0 | 7.22 | 85
8149 | Order Type 1 | 2022-01-01 00:00:00 | 2022-01-01 10:49:04.713000 | 5 | Plongkaew | 2 | 0 | 0 | 7.22 | 85
8150 | Order Type 1 | 2022-01-01 00:00:00 | 2022-01-01 10:51:01.273000 | 3 | Plongkaew | 2 | 0 | 0 | 7.22 | 85
8151 | Order Type 1 | 2022-01-01 00:00:00 | 2022-01-01 10:58:16.180000 | 15 | Plongkaew | 2 | 0 | 0 | 18 | 211.86
8152 | Order Type 1 | 2022-01-01 00:00:00 | 2022-01-01 11:00:50.377000 | 38 | Plongkaew | 4 | 0 | 0 | 105 | 1235.85
8153 | Order Type 1 | 2022-01-01 00:00:00 | 2022-01-01 11:05:28.407000 | 25 | Plongkaew | 2 | 0 | 0 | 18 | 211.86
8154 | Order Type 1 | 2022-01-01 00:00:00 | 2022-01-01 11:15:26.977000 | 34 | Plongkaew | 2 | 0 | 0 | 18 | 211.86
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 51

कार्यक्रम PROGRAM |  |  | बुतनर्ादी तर्देिी मुद्रा (अतधकारी) BASIC FOREX (OFFICERS) | PROG CODE
 |  |  |  | IT 1721
तर्षर् समूह/JOB FAMILY |  |  | FOREIGN EXCHANGE
उद्देश्य/OBJECTIVE |  |  | TO     ENHANCE     AWARENESS     ON     FOREX     PRODUCTS, TECHNIQUES     ADOPTED     AND     BASIC     OPERATIONAL GUIDELINES IN HANDLING FOREX ACTIVITIES
लतक्षि समूह/TARGET GROUP |  |  | [NAME]
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Evolution from FERA to FEMA 1999, RBI as a regulator. FTP 2023. Authorised Persons – AD I, AD II, AD III, FFMCs. International Trade – Role of DGFT, ECGC, ICC, FEDAI, FIMMDA, FBIL. Gift City – [NAME].
 | II | Foreign  Exchange  –  Market  Structure  –  Salient  features,  market conventions.  Fixed  v/s  Floating  exchange  rate,  [NAME]  Woods System (Gold Standard), [NAME]. Importance of USD in International markets   –   Reserve,   Invoicing,   Payment,   Settlement   Currency. Settlement    –    Cash/Tom/Spot/Forwards,    Time    difference    - Settlement Risk, Deliverable/Non-Deliverable.
 | III | Non-Resident Deposit Accounts - NRE, [NAME], FCNR(B) & SNRR. [NAME]. Remittance facilities to NRIs/PIO/OCI. Borrowing & lending by NRIs & PIOs.  Foreign Currency Accounts for Residents.
 | IV | Foreign Outward Remittances - FEMA regulation relating to   Capital &   Current   account   transactions,   LRS   scheme   &   small   value remittances, Exchange for travel, Prepaid Travel Card etc. Foreign Inward Remittances - Regulatory Guidelines, Various modes of  Receiving  Inward  remittances,  Encashment  of  Foreign  currency notes, FOSC, FCDB, FCRA.
Day 2 | I & II | FEMA 1999 on Import & Exports & related remittances. EDPMS  and  IDPMS.  Due  diligence  for  extending  credit  facility  & monitoring, Brief on Fund based/non-fund-based limits. Export  Finance  Pre/Post  Shipment  in  rupees/foreign  currency  & Crystallisation.
 | III | ECGC – ECIB – obligation of bank, claim procedures and ECGC Policies in general
 | IV | Important ICC  provisions  with caselets  on: INCO  Terms  2020; UCP 600; URC 522; URDG 758; ISBP745; ISP98.
Day 3 | I | Permitted Capital Account transactions: FDI, ODI, ECB.
 | II | Trade  Based  Money  Laundering  (TBML)   –   Concept,   scope  and application. Exercising Due Diligence. Case Studies.
 | III | Organizational Structure – GTPC – FX4U.
 | IV | Marketing    of    banking    services    and    customer    relationship management,  Customer  scoping  and  importance  of  cross-selling. Conducting sales calls / mock sales calls, Feedback & Valediction.
Spreadsheet: 3cb44a23-d837-42ba-8702-ec83b60bb9a8
Sheet: Sheet1

 | First Name | Last Name | City | Country | club
1 | [NAME] | Decoo | Middelkerke | Belgium
2 | [NAME] | DONARD | Chalons-en -champagne | France
3 | Alain | MEREDITH | Monaco | Monaco
4 | Martin | Metz | Wilhelmsfeld | Allemagne
5 | ZANOTTI | Michel | carces | France
6 | JeanClaude | SABATHE | AUBAGNE | France
 | 6 | 6 | 6 | 6
Spreadsheet: 06ac31b2-f2e2-44d9-b433-09f1e3920a8b
Sheet: Property (700)

Part II Budget Detail
Expenditures for the acquisition of fixed assets, including expenditures for land or existing buildings and improvements of grounds; initial equipment;
additional equipment; and replacement of equipment. (i.e., machinery, school buses, furniture & fixtures, audiovisual equipment, non-bus vehicles,
computer equipment (hardware)).
Property (700)
Description | Project Year 1 | Project Year 2 | Project Year 3 | Total
Spreadsheet: 802827d1667057543-adding-an-if-function-to-the-current-formula-working-doc
Sheet: Combined 

[NAME] | DEN | DEN
[NAME] Holiday | ATL | ATL
[NAME] | BOS | BOS
Anfernee Simons | POR | POR
[NAME] | MIN | MIN
Ayo Dosunmu | CHI | CHI
Bennedict Mathurin | IND | IND
[NAME] | DET | DET
Bradley Beal | WAS | WAS
[NAME] | MIL | MIL
[NAME] | IND | IND
[NAME] | DET | DET
Cam Reddish | NY | NY
[NAME] | PHO | PHO
Spreadsheet: 63886d1264742527-if-how-to-add-more-than-one-if-help-8
Sheet: lookuptable

0 | unknown |  | E135/E136/E140/E141 | junior 14 and under | E135/E136/E140/E141junior 14 and under | E135
1900 | amateur 36 and up |  | E135/E136/E140/E141 | junior 15-17 | E135/E136/E140/E141junior 15-17 | E136
1974 | amateur 18-35 |  | E135/E136/E140/E141 | amateur 18-35 | E135/E136/E140/E141amateur 18-35 | E140
1992 | junior 15-17 |  | E135/E136/E140/E141 | amateur 36 and up | E135/E136/E140/E141amateur 36 and up | E141
1995 | junior 14 and under |  | E501/E502 | junior 15-17 | E501/E502junior 15-17 | E501
1998 | junior 11 and under |  | E501/E502 | amateur 18-35 | E501/E502amateur 18-35 | E502
Spreadsheet: 7abcbc85-2329-4bb3-b45b-0cb8a47b3f7c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Fixed-Volume Pipette Calibration | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  | Reference: ISO 8655-6:2002 (E)
Analyst: |  |  |  |  |  | Test Conditions
Date of Calibration: |  |  |  |  |  | Barometric pressure, kPa or mbar
Calibration due date: |  |  |  |  |  | Relative Humidity, %
Pipet manufacturer: |  |  |  |  |  | Ambient temp., degrees C
Serial/ID number: |  |  |  |  |  | Test liquid temp., degrees C
Nominal Volume: |  |  |  |  |  | Z correction factor
Location of use:
Leak Test |  |  |  |  |  | Balance check
Time begin: |  |  |  |  |  | Balance manufacturer
Time end: |  |  |  |  |  | Serial Number
Pass/Fail |  |  |  |  |  | Location of use
 |  |  |  |  |  | Weight set serial #
Pipet Calibration
Dial setting: |  |  | units:
Time begin:
Replicate | Mass | Units |  | Volume (V)
m1
m2 |  |  |  |  |  | Weight | Units | Reading | Tolerance | Pass/Fail
m3
m4
m5
m6
m7
m8
m9
m10
Mean mass
Time end: |  |  |  |  |  | COMMENTS/CORRECTIVE ACTION:
Mean vol.
% RE
RE Tolerance
s
% CV
[NAME]
PASS/FAIL
A leak test may be performed by filling the pipette tip with distilled or deionized water to the maximum nominal volume and placing the pipette on a vibration-free stand. Observe the meniscus in the tip for 1 minute. After 1 minute, there should be no visible droplet formation at the tip. If there are no signs of droplet formation, proceed with the calibration check. If droplet formation is observed, successful maintenance and corrective action must be taken or the pipette must not be used.
Complete green-shaded cells only (obtain Z Corr. Factor from Table 1 on Sheet 2). The spreadsheet will populate all unshaded cells
for you.
Obtain RE and CV tolerances from the pipettor manufacturer's specifications.
Use appropriate ASTM 1 or 2 tolerances for the balance checks (refer to sheet 3).
If dial setting (volume) is in mls, mass should be recorded in gm. If dial setting (volume) is in μl, mass should be recorded in mg.
Spreadsheet: 884193d1733254836-looking-for-best-formula-to-explode-boms-test-bom-expo
Sheet: Example

[NAME]
Item |  |  |  | Count | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
TEST2 |  |  |  | 100 | 365100
TEST1 |  |  |  | 120 | 254880
[NAME] | UNITID_Assy | UNITID_Child | PerAssemblyQty | TopAssemblyQty | Manual Calc'd
TEST2
R1471 | M | [NAME] | 0.045 | 0.0054
R1682 | M | [NAME] | 0.0001 | 1.2e-05
R3217 | M | [NAME] | 0.015454 | 0.001854
R621 | M | [NAME] | 0.006707 | 0.000805
R4774 | M | [NAME] | 0.04 | 0.0048
K677 | M | [NAME] | 0.022335 | 0.00268
R1302 | M | [NAME] | 0.107143 | 0.012857
R214 | M | [NAME] | 0.283784 | 0.034054
R2557 | M | [NAME] | 0.042 | 0.00504
R289 | M | [NAME] | 0.0525 | 0.0063
R675 | M | [NAME] | 0.106061 | 0.012727
R965 | M | [NAME] | 0.0525 | 0.0063
R270 | M | M | 1 | 0.12
R145 | M | [NAME] | 0.01375 | 0.00165
R626 | M | [NAME] | 0.03 | 0.0036
PL228007-A | EA | M | 0.001 | 1
P464 | EA | M | 0.001 | 1
P124 | EA | M | 0.001 | 1
PB267 | EA | ea | 0.041667 | 0.041667
WF274 | EA | M | 0.12 | 120
TEST1
K405 | M | [NAME] | 0.012 | 0.0012
R3597 | M | [NAME] | 0.021031 | 0.002103
R364 | M | [NAME] | 0.027442 | 0.002744
R366 | M | [NAME] | 0.037797 | 0.00378
[NAME] | M | [NAME] | 0.012427 | 0.001243
R5808 | M | [NAME] | 0.029153 | 0.002915
[NAME] | M | [NAME] | 0.018122 | 0.001812
R6179 | M | [NAME] | 0.009838 | 0.000984
R694 | M | [NAME] | 0.012984 | 0.001298
R774 | M | [NAME] | 0.017604 | 0.00176
R3636 | M | M | 1 | 0.1
K360 | M | [NAME] | 0.03825 | 0.003825
K368 | M | [NAME] | 0.03262 | 0.003262
R2225 | M | [NAME] | 0.057472 | 0.005747
R355 | M | [NAME] | 0.093243 | 0.009324
R358 | M | [NAME] | 0.010356 | 0.001036
R363 | M | [NAME] | 0.033137 | 0.003314
R3642 | M | [NAME] | 0.05799 | 0.005799
R4118 | M | [NAME] | 0.01398 | 0.001398
R6121 | M | [NAME] | 0.027442 | 0.002744
R6123 | M | [NAME] | 0.047117 | 0.004712
PL228174-A | EA | M | 0.001 | 1
P462 | EA | M | 0.001 | 1
P124 | EA | M | 0.001 | 1
PB153 | EA | ea | 0.05 | 0.05
B3886 | EA | M | 0.1 | 100
Consolidated Requirements
R1471
R1682
R3217
R621
R4774
K677
R1302
R214
R2557
R289
R675
R965
R270
R145
R626
PL228007-A
P464
P124
PB267
WF274
K405
R3597
R364
R366
[NAME]
R5808
[NAME]
R6179
R694
R774
R3636
K360
K368
R2225
R355
R358
R363
R3642
R4118
R6121
R6123
PL228174-A
P462
PB153
B3886
Spreadsheet: 86d9809c-6557-46f8-b221-2d0883163a34
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
HEAB | Test | HEAB | [NAME], Serum | [NAME], S | Chemiluminescence Immunoassay (CIA) | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL  Collection Instructions: Spin down and immediately remove serum from clot.  Additional Information: 1. Date of draw is required. 2. If ordered with QHBV/82416 Hepatitis B Virus DNA Quantification by bDNA, Serum or HBVQU/88634 Hepatitis B Virus DNA Detection and Quantification by Real-Time PCR, Serum; send separate vials. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Red top | Negative See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Saturday; Varies | 1 day | 2 days | 1 | 86707 |  |  |  |  | Rochester
HEAB | [NAME] | SST | Serum SST |  |  |  | Frozen
HEAB | Result | HEAB | [NAME], S | [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 234670d1368161358-multiple-sort-imported-data-with-dates-book1
Sheet: Sheet1

No | Date 1 | Date 2 | Date 3 | Date 4 | T1 | T2 | T3 | T4 | T5 | T6
A-PR-1-OL | 2012-06-03 00:00:00 | 3/26/2012 | 3/26/2012 | 3/26/2012 | 20 | 20 | 20 | 20 | 0 | 0
AH-C-1-21 | 8/17/2011 | 10/17/2011 | 2012-02-10 00:00:00 | 2012-03-10 00:00:00 | 61 | 412 | 413 | 61 | 351 | 1
AH-C-1-153 | 2012-08-05 00:00:00 | 2012-07-08 00:00:00 | 10/26/2012 | 10/28/2012 | 91 | 171 | 173 | 91 | 80 | 2
AH-C-1-08 | 5/24/2012 | 6/27/2012 | 2012-09-08 00:00:00 | 2012-12-08 00:00:00 | 34 | 77 | 80 | 34 | 43 | 3
AE-S-1-84 | 7/31/2012 | 9/20/2012 | 10/30/2012 | 10/31/2012 | 51 | 91 | 92 | 51 | 40 | 1
AE-S-2-85 | 6/18/2012 | 2012-12-08 00:00:00 | 10/31/2012 | 10/31/2012 | 55 | 135 | 135 | 55 | 80 | 0
AE-D-2-63 | 2012-12-06 00:00:00 | 6/14/2012 | 6/14/2012 | 6/14/2012 | 2 | 2 | 2 | 2 | 0 | 0
HE-C-2-29 | 10/26/2012 | 2012-11-11 00:00:00 | 2012-11-11 00:00:00 | 2012-11-11 00:00:00 | 16 | 16 | 16 | 16 | 0 | 0
HE-S-1-10 | 2010-06-12 00:00:00 | 2011-03-03 00:00:00 | 2/26/2012 | 2/27/2012 | 87 | 447 | 448 | 87 | 360 | 1
HE-S-1-15 | 2011-04-05 00:00:00 | 8/28/2011 | 2012-04-01 00:00:00 | 2012-04-01 00:00:00 | 116 | 245 | 245 | 116 | 129 | 0
HE-S-1-050 | 5/23/2011 | 8/25/2011 | 2012-04-01 00:00:00 | 2012-04-01 00:00:00 | 94 | 226 | 226 | 94 | 132 | 0
Spreadsheet: 784177d1655483203-calculate-if-data-falls-inside-a-range-range
Sheet: Sheet2

Date | ERCOTW $ | Volume | P&L |  | Purchase | 20
 |  |  |  |  | Sale | 60
2019-01-01 00:00:00 | 12.705 | 43.4887199998
2019-01-01 01:00:00 | 13.8325 | 87.31909999999999
2019-01-01 02:00:00 | 15.2125 | 82.9939299999
2019-01-01 03:00:00 | 16.1075 | 73.41934
2019-01-01 04:00:00 | 16.0325 | 66.9779899998
2019-01-01 05:00:00 | 16.965 | 66.3174999999
2019-01-01 06:00:00 | 17.9625 | 51.55916999990001
2019-01-01 07:00:00 | 18.0675 | 43.9008119998
2019-01-01 08:00:00 | 18.8725 | 48.15582000000001
2019-01-01 09:00:00 | 20.0525 | 36.0819599999
2019-01-01 10:00:00 | 21.0575 | 12.0351769999
2019-01-01 11:00:00 | 21.5175 | 6.7872919998
2019-01-01 12:00:00 | 21.79 | 2.0356559999
2019-01-01 13:00:00 | 22.3525 | 1.4338939997
2019-01-01 14:00:00 | 24.1275 | 1.2498829998
2019-01-01 15:00:00 | 27.2825 | 0.8587099999000001
Spreadsheet: 678865d1590087848-append-2-named-range-with-the-same-structure-book1-redpeppery-
Sheet: Sheet1

Range1 | Range2
10 | 70
20 | 80
30 | 90
40 | 100
50 | 110
60 | 120
 | 130
 | 140
 | 150
Spreadsheet: 0cb111f0-a4df-475e-a9f8-6f2618af0fdf
Sheet: Sheet1

2006-11-07 00:00:00 | State Senate - District No. 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Gallus, r | Jackman, d | [NAME]
Albany | 104 | 129
Atkinson and [NAME]. Gt. | -- | -- | --
[NAME] | 559 | 604
Bean's Grant | -- | -- | --
Bean's Purchase | -- | -- | --
[NAME] | 376 | 264
[NAME] | 421 | 227
[NAME] 3 | 543 | 315
[NAME] 4 | 321 | 274
Bethlehem | 399 | 448
Cambridge
Carroll | 145 | 95
[NAME]'s Purchase | -- | -- | --
[NAME] | 52 | 30
Colebrook | 369 | 188
Columbia | 128 | 68
Crawford's Purchase | -- | -- | --
Cutt's Grant | -- | -- | --
[NAME] | 208 | 102
Dix's Grant | -- | -- | --
Dixville | 12 | 4
Dummer | 72 | 35
Errol | 81 | 39
Erving's Location | -- | -- | --
Franconia | 253 | 272
[NAME] | 548 | 407
Green's Grant | 1
Hadley's Purchase | -- |  | --
Hale's Location | 68 | 16
Hart's Location | 11 | 9
[NAME] | 240 | 265
[NAME] | 264 | 125
Kilkenny | -- | -- | --
Lancaster | 670 | 363
Lincoln | 244 | 191
Lisbon | 239 | 156
Littleton | 1145 | 601
Livermore | -- | -- | --
Low and Burbank's Grant | -- | -- | --
[NAME] | 110 | 87
Martin's Location | -- | -- | --
Milan | 264 | 159
[NAME] | 9 | 2
Northumberland | 329 | 286
[NAME] | -- | -- | --
[NAME]'s Grant |  | 1
Pittsburg | 211 | 87
Randolph | 86 | 103
Sargent's Purchase | -- | -- | --
Second College Grant | -- | -- | --
Shelburne | 108 | 73
[NAME] | 106 | 73
 | Gallus, r | Jackman, d | [NAME]
Stewartstown | 114 | 78
[NAME] | 71 | 86
Success | -- | -- | --
[NAME] | 119 | 160
Thompson & Meserve's Purchase | -- | -- | --
Waterville Valley | 68 | 67
Wentworth's Location | 5 | 3
[NAME] | 397 | 251
Totals | 9470 | 6743
Spreadsheet: 489315d1479209270-excel-report-from-multiple-excel-files-qrn-275-and-276
Sheet: Summary Results

Identifiers | Wavelength  (nm) | Link Length (km) |  |  | Link Loss  (dB) |  |  | ORL  (dB)
 |  | A->B | B->A | Avg | A->B | B->A | Avg | A->B | B->A
QRN FC 12; 275 | 1310 |  |  | 2.967 | 1.575 | 0.985 | 1.28 | 36.93 | 35.96
 |  |  |  | Unknown | Unknown | Unknown | Unknown | Pass | Unknown
QRN FC 12; 275 | 1490 |  |  | 2.967 | 1.168 | 0.639 | 0.903 | 38.29 | 37.42
 |  |  |  | Unknown | Unknown | Unknown | Unknown | Pass | Unknown
QRN FC 12; 275 | 1550 |  |  | 2.967 | 1.093 | 0.559 | 0.826 | 38.79 | 37.95
 |  |  |  | Unknown | Unknown | Unknown | Unknown | Pass | Unknown
QRN FC 12; 276 | 1310 |  |  | 2.9642 | 1.795 | 0.935 | 1.365 | 36.94 | 35.58
 |  |  |  | Unknown | Unknown | Unknown | Unknown | Pass | Unknown
QRN FC 12; 276 | 1490 |  |  | 2.9642 | 1.414 | 0.597 | 1.005 | 38.39 | 37.07
 |  |  |  | Unknown | Unknown | Unknown | Unknown | Pass | Unknown
QRN FC 12; 276 | 1550 |  |  | 2.9642 | 1.296 | 0.5 | 0.898 | 38.8 | 37.62
 |  |  |  | Unknown | Unknown | Unknown | Unknown | Pass | Unknown
 |  | 1.575 | 0.985 | 1.28 |  | -0.13 | 0.162 | 0.016 |  | 1.705 | 0.823 | 1.264
 |  | 1.168 | 0.639 | 0.903 |  | -0.124 | 0.152 | 0.014 |  | 1.292 | 0.487 | 0.889
 |  | 1.093 | 0.559 | 0.826 |  | -0.117 | 0.148 | 0.015 |  | 1.21 | 0.411 | 0.8109999999999999
 |  | 1.795 | 0.935 | 1.365 |  | 0.162 | -0.13 | 0.016 |  | 1.633 | 1.065 | 1.349
 |  | 1.414 | 0.597 | 1.005 |  | 0.152 | -0.124 | 0.014 |  | 1.262 | 0.721 | 0.9909999999999999
 |  | 1.296 | 0.5 | 0.898 |  | 0.148 | -0.117 | 0.015 |  | 1.148 | 0.617 | 0.883