tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24110__Data Room Index Capestany
Sheet: Data Room Doc. Index

NewCo
Due Diligence Index
 |  |  |  |  | Notes
Risk Management ([NAME] Gossett/ [NAME])
 | ENA |  |  |  | 1 Binder; 2 Copies
1 | ENA YTD 2001 Earnings Estimate
2 | VaR by Commodity
3 | PRM Portfolio Liquidation
4 | Monthly Cross Commodity Trading Reports (July 2000 - YTD 2001)
5 | EOL Volumes
6 | Financial Market Making - Product Type and Term
7 | Bios and Resumes
 | POWER |  |  |  | 1 Binder; 2 Copies
1 | East & West Power: Daily Position Reports (Oct. '01)
2 | East Month End Reports
3 | West Month End Reports
4 | Forward Power Curves
5 | Power Risk Books (Jan. 18, '01, Jan. 31, '01, June 20, '01, July 16, '01, Sept. 24, '01)
6 | [NAME] and New Deals (Jan. 18, '01, Jan. 31, '01, June 30, '01, July 16, '01, Sept. 24, '01, )
 |  | West Management |  |  | (Not in binders)
 |  | LT-NW |  |  | (Not in binders)
7 | Delta Positions |  |  |  | 1 Jacket
 | GAS |  |  |  | 1 Binder; 2 Copies
1 | P&L By Book ( Month end; [NAME] report for Oct. '01)
2 | Basis Positions (Total, By [NAME])
3 | Positions By Book
4 | Prices as of Nov. 29, '01
5 | New Deals: 1/18, 1/31, 6/20, 7/16, 9/24
6 | Var, P&L and Pricing :  1/18, 1/31, 6/20, 7/16, 9/24
7 | Natural Gas P&L by Book (3/26-4/25/01) |  |  |  | 1 Binder, 2 Copies
8 | Natural Gas P&L by Book (4/27-6/11/01) |  |  |  | 1 Binder, 2 Copies
9 | Basis and New Deals |  |  |  | 1 Jacket
Accounting ([NAME]) |  |  |  |  | 1 Binder; 4 Copies
1 | EBIT/Cash Flow: 1998 - YTD 2001
2 | PRM Rollforward - Detail of Risk Mgt. Activities (2000 - YTD 2001)
3 | [NAME] by Qtr (2001)
4 | Gas & Power Roll Out of Book
5 | Gas & Power by Major Counterparty
6 | Net Asset Schedule - Qtr by Qtr (2000 - YTD 2001)
7 | 2002 Pro-Forma
8 | 2002 Plan
9 | 2001 Internal Audit Reports
10 | EBIT Analysis (Recurring Trading)
11 | Working Capital Projection (Worst Case)
Risk Assessment & control  ([NAME]) |  |  |  |  | 1 Binder; 3 Copies
1 | Risk Policy
2 | VaR Presentation
3 | VarR Overview
4 | VaR Diversification
5 | Component VaR
6 | VaR @ 99% Confidence
7 | Limits/Utilization
8 | Backtest by Year
9 | Backtest by Desk
10 | New Co VaR
11 | EVT Presentation
12 | Position/VaR
13 | Stress Tests
14 | New Co Pos/Stress
15 | Deal Volume
16 | [NAME]
17 | Curve Validation
18 | Model Notes
Credit ([NAME]) |  |  |  |  | 1 Binder; 3 Copies
1 | Contractual Collateral Thresholds For Select Counterparties
2 | Distressed Counterparty Report - Loss History 2000-2001
3 | Gas & Power Net Credit Exposures by Counterparty
4 | Power Credit Watch List
5 | Gas Credit Watch List
6 | Total Notional Gas and Power Values by Counterparty
7 | Cash Flow from PRM Portfolio Liquidation
8 | Gross Notional Positions by Commodity
9 | Select Relationship Exposures Across all Enron Entities
10 | Collateral Position Report
11 | EOL Credit Checking Calculation
12 | ENA & EPMI Counterparty Exposures by Net Exposure
13 | ENA & EPMI Counterparty Exposures by Net Obligation
14 | Credit Reserve Enron Corp Enron Americas
Spreadsheet: 97244d1296485224-move-changing-data-from-one-speadsheet-to-another-test
Sheet: Original

Program #134 Conv. Fixed 25-30 Year; PT 130, PT 152 rate builder
Interest | Discount | Origination | APR | Employee
Rate | Points | Fee | Calc | Pricing |  | I need to take this information and move it to Result.  I only need to move the rows that are in the larger font.  This changes daily.  Sometimes multiple times in a day.  Interest Rates can fall off or be added.  There are multiple tables like this.
3.75 | 9.25 | 0 | 0.04626942571420343 | 8.875
3.875 | 8.125 | 0 | 0.04652376479272424 | 7.75
4 | 7.125 | 0 | 0.04689868828657331 | 6.75
4.125 | 6.25 | 0 | 0.04739099826790577 | 5.875
4.25 | 5.25 | 0 | 0.04776737292015494 | 4.875
4.375 | 4.25 | 0 | 0.04814474305694924 | 3.875
4.5 | 3.5 | 0 | 0.04875016778323531 | 3.125
4.625 | 2.625 | 0 | 0.04924029907670982 | 2.25
4.75 | 1.875 | 0 | 0.04984203594484882 | 1.5
4.875 | 1 | 0 | 0.0511096067247383 | 0.625
5 | 0.25 | 0 | 0.05237734558373636 | -0.125
5.125 | -0.25 | 0 | 0.05364525262805982 | -0.625
5.25 | -1 | 0 | 0.05491332793219385 | -1.375
5.375 | -1.625 | 0 | 0.05618157153875593 | -2
5.5 | -2 | 0 | 0 | -2.375
5.625 | -2.625 | 0 | 0 | -3
5.75 | -3 | 0 | APR | -3.375
0 | 0 | 0 | 0.06851978067783343 | 0
Spreadsheet: 148704d1333528421-average-3-months-6-months-trend-line-array-formula-achizitii-trend-tabla
Sheet: TRENDLINE - TABLE

 | Data
 | UM | Kg
 |  | Avg. price / 3months | Avg. price / 6months | Last direct
 | TABLA 010
 | TABLA 010 A
 | TABLA 015
 | TABLA 020
 | TABLA 020 A
 | TABLA 020 B
 | TABLA 020 C
 | TABLA 030
 | TABLA 030 S355
 | TABLA 040
 | TABLA 040 S355
 | TABLA 050
 | TABLA 050 HD
 | TABLA 050 S355
 | TABLA 060
 | TABLA 060 S355
 | TABLA 080
 | TABLA 080 A
 | TABLA 080 S355
 | TABLA 100
 | TABLA 100 S355
 | TABLA 120
 | TABLA 120 S355
 | TABLA 150
 | TABLA 150 S355 A
 | TABLA 160
 | TABLA 200
 | TABLA 250
Spreadsheet: 742247d1627623655-resetting-a-value-in-a-field-and-hiding-fields-via-check-mark-travel-forms-request-or-voucher-2
Sheet: DROP DOWN

 |  |  |  |  |  |  |  |  | SELECT ONE |  |  | SELECT ONE
LOCATION 1 |  |  |  |  |  | SELECT ONE |  |  | Conference |  |  | Normal TDY
LOCATION 2 |  | ONE, TRAVELER | TRAVELER | E11001100 |  | PLANE |  |  | Training | Enter # of Hours |  | Actual Expense for Lodging | (Approval Memo Required)
LOCATION 3 |  | TWO, CUSTOMER | CUSTOMER | E11002200 |  | GOV |  |  | Site Visit
LOCATION 4 |  | THREE, SUPERVISOR | SUPERVISOR | E11003300 |  | POV | Was POV advantagous to the Govt? |  | Emergency | Enter Operation
LOCATION 5 |  |  |  |  |  | RENTAL CAR |  |  | [NAME]
LOCATION 6 |  |  |  |  |  |  |  |  | Other | [NAME]
LOCATION 7
 |  |  |  |  |  | SELECT ONE
 |  |  |  |  |  | ALL |  |  |  | NO | Skip to Line 11
 |  |  |  |  |  | PARTIAL AMOUNT | Enter Amt |  |  | YES
 |  |  |  |  |  |  |  |  |  | NO | Limited to Cost of Airfare
 |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  |  |  | SUPPLEMENTAL
 |  |  |  |  |  |  | PARTIAL
 |  |  |  |  |  |  | FINAL
Spreadsheet: 216489d1361788708-need-formula-to-connect-sheets-example
Sheet: Sheet1

 |  |  | 1-Febb |  | 4-Febb |  | 5-Febb |  | 6-Febb |  | 7-Febb |  | 8-Febb |  | 11-Febb |  | 12-Febb |  | 13-Febb |  | 18-Febb |  | 19-Febb |  | 20-Febb |  | 21-Febb |  | 22-Febb |  | 25-Febb |  | 26-Febb |  | 27-Febb |  | 28-Febb
Opt | Gg. Ass.
[NAME]
[NAME] |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  | the  number 1 corespond to the sheet2 but the list in seet1 at the same date already exist
Spreadsheet: daren_farmer__5461__hpl0907
Sheet: Sheet1

HPLN0907.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - September 07, 2000
 |  |  |  |  |  | ** Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-09-07 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 50  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 50  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | LS HPL [NAME] |  | ENA | 25 | 10
Enron (S) |  | Oasis Sealy |  | ENA | 30 | 0
Enron (S) |  | Oasis Turbine |  | ENA | 0 | 10
Enron (S) |  | Reklaw |  | ENA | 30 | 10
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 265343d1379201567-inserting-table-rows-from-another-file-2010-wine
Sheet: Reds

2010 Vintage Year - Red Wines
 |  | Tracking Data
 |  | Category 1 |  |  | Category 2 |  |  | Category 3 |  |  | Category 4 |  |  | Category 5 |  |  | Category 6
Appellation | Wine | Element 1 | Element 2 | Element 3 | Element 4 | Element 5 | Element 6 | Element 7 | Element 8 | Element 9 | Element 10 | Element 11 | Element 12 | Element 13 | Element 14 | Element 15 | Element 16 | Element 17 | Element 18 | Comments
Central Coast, CA | Central Coast C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Central Coast, CA | Central Coast C2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Central Coast, CA | Central Coast C3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Needs to be Moved from 2010 to 2011 File
Napa, CA | Napa N1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Napa, CA | Napa N2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Needs to be Moved from 2010 to 2011 File
Napa, CA | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Napa, CA | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Napa, CA | Napa N5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Napa, CA | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Napa, CA | Napa N7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Needs to be Moved from 2010 to 2011 File
Napa, CA | Napa N8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Sonoma, CA | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Sonoma, CA | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Sonoma, CA | Sonoma S3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Sonoma, CA | Sonoma S4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Sonoma, CA | Sonoma S5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Needs to be Moved from 2010 to 2011 File
Sonoma, CA | Sonoma S6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Spreadsheet: kate_symes__18688__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-21 00:00:00 |  | 283.75 | 4800 | 240 | 200
 | 2001-02-20 00:00:00 |  | 326.82 | 4400 | 300 | 600 | 324.71 | 8650 | 350.06 | 1975
 | 2001-02-19 00:00:00 |  | 326.15 | 5200 | 300 | 600 | 382.2 | 4390 | 356.1 | 1540
 | 2001-02-18 00:00:00 |  |  |  |  |  |  |  | 399.12 | 4290 |  | 320 | 600
 | 2001-02-17 00:00:00 |  | 346.07 | 3360 | 320 | 200 | 397.33 | 8623 | 394.97 | 2510
 | 2001-02-16 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 444.06 | 5450 | 419.61 | 1985
 | 2001-02-15 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 436.92 | 5630 | 480.72 | 1815
 | 2001-02-14 00:00:00 |  | 323 | 2000 | 300 | 0 | 601.45 | 2755 | 404.44 | 1970
 | 2001-02-13 00:00:00 |  | 307.5 | 2400 | 315 | 0 | 400.85 | 9115 | 379.49 | 2005
 | 2001-02-12 00:00:00 |  | 287.5 | 2400 | 277.5 | 0 | 380.82 | 9260 | 330.18 | 1690
 | 2001-02-11 00:00:00 |  |  |  |  |  |  |  | 398.34 | 5105 |  | 250 | 0
 | 2001-02-10 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.49 | 9007 | 373.04 | 3310
 | 2001-02-09 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.64 | 9525 | 391.75 | 2705
 | 2001-02-08 00:00:00 |  | 360.63 | 3200 | 300 | 48 | 407.79 | 7436 | 402.59 | 2830
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 882154d1730405227-get-value-from-different-workbook-based-on-multiple-criteria-and-based-on-the-latest-date-input-workbook-example_correct_structure
Sheet: Input workbook

 |  | Machine | ID number | Others | Others | Update "date" | Cyceltime | Others
 |  | Example1 | 12345 |  |  | 2024-10-18 00:00:00 | 70
 |  | Example1 | 12345 |  |  | 2024-10-19 00:00:00 | 85
 |  | Example1 | 12345 |  |  | 2024-10-20 00:00:00 | 90
 |  | Example2 | 67891 |  |  | 2024-10-25 00:00:00 | 40
 |  | Example2 | 67891 |  |  | 2024-10-28 00:00:00 | 50
 |  | Example3 | 65743 |  |  | 2024-10-28 00:00:00 | 60
 |  | Example4 | 97745 |  |  | 2024-10-28 00:00:00 | 80
 |  | From the source workbook I need a formula that checks.
 |  | If there is a match between Machine and ID number in this workbook and in the source workbook.
 |  | If there is a match. Updates the cyceltime to the one with the latest date in this workbook. Into the source workbook
Spreadsheet: 12883052-1324-47c6-8a08-ad510fbc07ca
Sheet: PPI 002

Permit No.: |  | WQ0005790 |  | Facility Name: |  | Oak Island WWTF |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
PPI: |  | 002 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder
Monthly Limit: |  |  | 400000
Daily Limit:
Sample Frequency: |  |  | [NAME]
Spreadsheet: 866777d1713698910-countifs-multiple-critera-steak
Sheet: Sheet1

Name | date | food
[NAME] | 2024-01-22 15:00:00 | Steak
[NAME] | 2024-01-23 13:00:00 | Sandwich
[NAME] | 2024-02-01 12:45:00 | Pasta
[NAME] | 2024-02-09 16:00:00 | Salad
[NAME] | 2024-02-21 12:45:00 | Soup
[NAME] | 2024-02-27 11:15:00 | Ice Cream
[NAME] | 2024-03-06 12:45:00 | Chips
[NAME] | 2024-03-13 12:45:00 | Steak
[NAME] | 2024-03-28 12:45:00 | Salad
[NAME] | 2024-03-29 10:45:00 | Steak
[NAME] | 2024-04-01 12:15:00 | Steak
[NAME] | 2024-04-01 13:00:00 | pasta
[NAME] | 2024-04-03 12:45:00 | Steak
[NAME] | 2024-04-05 14:02:00 | pasta
[NAME] | 2024-04-11 12:30:00 | Chips
Spreadsheet: 202315d1356504482-how-to-get-counts-by-date-wise-data-in-2-different-coloums-chris
Sheet: Sheet3

 |  |  | 2012-12-01 00:00:00 | uk
 |  |  | 2012-12-01 00:00:00 | ind
 |  |  | 2012-12-01 00:00:00 | us
 |  |  | 2012-12-01 00:00:00 | ind
 |  |  | 2012-12-01 00:00:00 | uk
 |  |  | 2012-12-01 00:00:00 | us
 |  |  | 2012-12-02 00:00:00 | us
 |  |  | 2012-12-02 00:00:00 | ind
 |  |  | 2012-12-02 00:00:00 | uk
 |  |  | 2012-12-02 00:00:00 | uk
Spreadsheet: 854024d1703981641-calculating-annual-days-of-business-wrkday-1-
Sheet: Sheet1

 |  | 2024
 | HOLIDAY | DAY |  | Reflected |  | 2024-04-01 00:00:00 | 2024-06-22 00:00:00 |  |  | 2024-06-23 00:00:00 | 2024-08-31 00:00:00 |  |  | 2024-09-01 00:00:00 | 2025-01-25 00:00:00 |  |  | 2025-01-26 00:00:00 | 2025-03-31 00:00:00
 | Memorial Day |  |  | SUN |  | SUN | WEEK | SAT |  | SUN | WEEK | SAT |  | SUN | WEEK | SAT |  | SUN | WEEK | SAT
 | Juneteenth |  |  | WEEK
 | Fourth of July |  |  | SUN |  | 12 | 59 | 12 |  | 11 | 49 | 10 |  | 26 | 98 | 23 |  | 10 | 45 | 10
 | Labor Day |  |  | SUN
 | Columbus Day |  |  | SAT
 | Election Day |  |  | WEEK
 | Veteran's Day |  |  | SAT
 | Thanksgiving |  |  | SUN
 | Christmas |  |  | SUN
 | New Year's Day |  |  | SUN
 | MLK Day |  |  | SUN
 | Presidents Day |  |  | SAT
 | Christmas Eve
 | New Year's Eve
Spreadsheet: 847916d1698760770-calculate-accumulated-values-for-each-day-during-the-last-90-days-from-newest-date-volymeday-1-aligw-version-us
Sheet: Blad1

 | Date: | Total per day | date 2 |  |  |  |  |  |  | How to get the column in dated order, oldest date as last figure
 |  |  |  |  |  |  |  |  |  |  | IN dated order
 | 2023-12-10 00:00:00 | 4000 |  |  |  |  | 8000 |  |  |  | 2023-12-10 00:00:00 | 8000
 | 2023-12-10 00:00:00 | 4000 |  |  |  | 2023-12-01 00:00:00 | 8000 |  |  |  | 2023-12-01 00:00:00 | 8000
 | 2023-12-01 00:00:00 | 2000 |  |  |  | 2023-10-29 00:00:00 | 9500 |  |  |  | 2023-11-09 00:00:00 | 23000
 | 2023-10-29 00:00:00 | 1000 |  |  |  | 2023-11-01 00:00:00 | 5000 |  |  |  | 2023-11-03 00:00:00 | 8000
 | 2023-10-29 00:00:00 | 7000 |  |  |  | 2023-11-09 00:00:00 | 23000 |  |  |  | 2023-11-02 00:00:00 | 1000
 | 2023-12-01 00:00:00 | 6000 |  |  |  | 2023-10-28 00:00:00 | 7000 |  |  |  | 2023-11-01 00:00:00 | 5000
 | 2023-11-01 00:00:00 | 3000 |  |  |  | 2023-11-02 00:00:00 | 1000 |  |  |  | 2023-10-29 00:00:00 | 9500
 | 2023-10-29 00:00:00 | 1000 |  |  |  | 2023-11-03 00:00:00 | 8000 |  |  |  | 2023-10-28 00:00:00 | 7000
 | 2023-11-09 00:00:00 | 2000 | 2023-11-09 00:00:00
 | 2023-10-28 00:00:00 | 7000
 | 2023-11-02 00:00:00 | 1000
 | 2023-11-03 00:00:00 | 8000
 | 2023-11-01 00:00:00 | 2000
 | 2023-11-09 00:00:00 | 10000
 | 2023-11-09 00:00:00 | 9000
 | 2023-11-09 00:00:00 | 2000
 | 2023-10-29 00:00:00 | 500
Matris is about 2000 rows
Spreadsheet: 025eceb2-e321-453b-9dba-87fcc186cf95
Sheet: Verano

Código del Curso | Nombre del Curso | Requisitos | Descripción | Crs. | Sec. | [NAME] | Desde | Hasta | Salón | Profesor (a) | [NAME] | #horas [NAME]
Dere 7996 | [NAME] en Derecho Público: Derecho Federal sobre Tribus Indias (American Indian Law) |  | Descrip | 1 | 411 | L,M,W,J,V | 09:00:00 | 11:20:00 | L-1 | [NAME] | 16 al 20 de junio de 2014 | 1
Dere 7997 | [NAME] en Derecho Público: The Crisis in Access to Justice |  | Descrip | 1 | 711 | L,M,W,J,V | 09:00:00 | 11:20:00 | L-1 | Chief Judge [NAME] | 7 al 11 de julio de 2014 | 1
Dere 7998 | [NAME] en Derecho Público: Derecho Penal Comparado |  | Descrip | 2 | 412 | L,M,W,J,V | 14:00:00 | 16:40:00 | L-1 | Dr. [NAME] | 30 de junio al 11 de julio de 2014 | 1
Dere 7556 | [NAME] I | [NAME] | Descrip | 3 | 413 | L,M,W,J | 6:00PM | 8:20PM | L-4 | [NAME] | 16 de junio al 10 de julio de 2014
Dere 7035 | [NAME] |  | Descrip | 3 | 413 | L,M,W,J,V | 18:00:00 | 20:30:00 | L-1 | Félix Figueroa Cabán | 16 de [NAME]
Dere 7995 | Taller de Práctica Legal |  | Descrip | 3 | 013 | P/A | P/A | P/A | P/A | [NAME] | 2 de junio al 11 de julio de 2014
Dere 7997 | [NAME] en Derecho Público: Political Asylum |  | Descrip | 2 | 412 | L,M,W,J,V | 13:00:00 | 15:20:00 | [NAME] | [NAME] | 16 al 27 de junio de 2014 | 1
Dere 7998 | [NAME] en Derecho Público: EB Employment Based Immigration |  | Descrip | 2 | 422 | L,M,W,J,V | 09:00:00 | 11:20:00 | [NAME] | [NAME] | 16 al 27 de junio de 2014
Dere 7999 | [NAME] en Derecho Público: Before the Immigration Court: Considerations to representing aliens in removal proceedings |  | Descrip | 2 | 412 | L,M,W,J,V | 16:00:00 | 18:20:00 | [NAME] | [NAME] | 16 al 27 de junio de 2014 | 1
 |  |  |  |  |  |  |  |  |  | Revisado:
Spreadsheet: 19f8f38a-7ce5-4b0e-9008-a6dfb7789271
Sheet: Sheet1

NR 15 ANEXO 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
LIMITE DE TOLERÂNCIA PARA RUÍDO CONTÍNUO E INTERMITENTE
NÍVEL DE RUÍDO   dB( A ) | MÁXIMA EXPOSIÇÃO DIÁRIA PERMISSÍVEL |  | ENTRE COM OS VALORES  dB(A) |  |  | EXPOSIÇÃO DIÁRIA PERMISSÍVEL |  | DOSE
85 | 8 horas | 8 | 94 |  | 94 | 2 horas e 15 minutos | 2.25 | 0.4444444444444444
86 | 7 horas | 7 | 95 |  | 95 | 2 horas | 2 | 0.5
87 | 6 horas | 6 | 95 |  | 95 | 2 horas | 2 | 0.5 | JORNADA DE TRABALHO
88 | 5 horas | 5 | 96 |  | 96 | 1 hora e 45 minutos | 1.75 | 0.5714285714285714 | 8 |  | HORAS
89 | 4 horas e 30 minutos | 4.5 | 94 |  | 94 | 2 horas e 15 minutos | 2.25 | 0.4444444444444444
90 | 4 horas | 4 | 98 |  | 98 | 1 hora e 15 minutos | 1.25 | 0.8 | 8
91 | 3 horas e 30 minutos | 3.5 | 98 |  | 98 | 1 hora e 15 minutos | 1.25 | 0.8
92 | 3 horas | 3 |  |  | 0 |  |  |  |  | [NAME] = | 96.0581283278837 | dB( A )
93 | 2 horas e 40 minutos | 2.66 | 96 |  | 96 | 1 hora e 45 minutos | 1.75 | 0.5714285714285714
94 | 2 horas e 15 minutos | 2.25 |  |  | 0 |  |  |  | DOSE TOTAL = |  | 463.1746031746031 | %
95 | 2 horas | 2 |  |  | 0
96 | 1 hora e 45 minutos | 1.75 |  |  | 0
97 | 1 hora e 30 minutos | 1.5 |  |  | 0
98 | 1 hora e 15 minutos | 1.25 |  |  | 0
99 | 1 hora e 09 minutos | 1.14 |  |  | 0
100 | 1 hora | 1 |  |  | 0
101 | 52 minutos | 0.87 |  |  | 0
102 | 45 minutos | 0.75 |  |  | 0
103 | 39 minutos | 0.65 |  |  | 0
104 | 35 minutos | 0.58 |  |  | 0
105 | 30 minutos | 0.5 |  |  |  |  |  | 4.631746031746031
106 | 25 minutos | 0.41
107 | 22 minutos | 0.37
108 | 20 minutos | 0.33
109 | 17 minutos | 0.28
110 | 15 minutos | 0.25
111 | 13 minutos | 0.21
112 | 10 minutos | 0.16
113 | 9 minutos | 0.15
114 | 8 minutos | 0.13
115 | 7 minutos | 0.11
Spreadsheet: 157052d1337606366-convert-mutiple-values-in-one-colums-to-single-row-sample
Sheet: Sheet1

ID | Login | Groups | Disabled | Never connected | Description | Last Login Time | Owner | Creation Date
9823 | de1 | Everyone DE_Corporate | 0 | 0 |  | 2012-02-23 14:14:01.531000 | Administrator | 2010-11-09 10:01:10.083000
9890 | ee1 | Everyone RHO_APAC_Corporate RHO_APAC_Designer | 0 | 0 |  | 2012-03-06 12:51:32.294000 | Administrator | 2010-11-09 10:25:50.673000
9899 | sg1 | Everyone SG_Corporate SG_DESIGNER | 0 | 0 |  | 2011-05-13 15:23:55.973000 | Administrator | 2010-11-09 10:27:07.457000
9911 | .hk1 | Everyone HK_Corporate HK_DESIGNER HK_Corporate1 | 0 | 0 |  | 2011-06-22 11:09:15.580000 | Administrator | 2010-11-09 10:28:14.725000
Spreadsheet: 845626d1697051162-why-wont-it-format-the-date-anon125-wont-format-date
Sheet: wont format date

10/01/2023 |  |  |  | 2023-10-01 00:00:00
09/27/2023 |  |  |  | 2023-09-27 00:00:00
09/26/2023 |  |  |  | 2023-09-26 00:00:00
09/25/2023 |  |  |  | 2023-09-25 00:00:00
09/25/2023 |  |  |  | 2023-09-25 00:00:00
09/25/2023 |  |  |  | 2023-09-25 00:00:00
09/24/2023 |  |  |  | 2023-09-24 00:00:00
09/24/2023 |  |  |  | 2023-09-24 00:00:00
09/24/2023 |  |  |  | 2023-09-24 00:00:00
09/24/2023 |  |  |  | 2023-09-24 00:00:00