tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 795082d1662496671-how-to-calculate-time-between-login-and-logout-times-agent-login-and-logout-times-admurray10-
Sheet: Sheet1

Time (BST) | User | Source | Type |  |  | User | Logged In | Logged Out | Difference Between Login and Logout |  |  | Agent List
2022-09-02 16:59:30 | Agent 1 | Agent | Logged Out |  |  | Agent 1 | 2022-09-02 08:59:20 | 2022-09-02 16:59:30 | 8 Hrs 0 Mins
2022-09-02 16:59:30 | Agent 1 | Agent | Logged Out |  |  | Agent 1 | 2022-09-01 08:15:00 | 2022-09-01 16:02:00 | 7 Hrs 47 Mins
2022-09-02 08:59:20 | Agent 1 | Agent | Logged In
2022-09-02 08:59:20 | Agent 1 | Agent | Logged In |  |  |  |  |  | Total Owed Time
2022-09-01 17:55:31 | Agent 2 | Agent | Set Busy |  |  |  |  |  | 0 Hrs 13 Mins
2022-09-01 17:46:31 | Agent 2 | Agent | Set Busy |  |  | Agent 1
2022-09-01 17:42:31 | Agent 2 | Telephone | Call Wrapped Up |  |  | User | Logged In | Logged Out | Difference Between Login and Logout
2022-09-01 17:41:51 | Agent 2 | Telephone | Agent Disconnected
2022-09-01 17:41:51 | Agent 2 | Telephone | Caller Disconnected
2022-09-01 16:02:00 | Agent 1 | Agent | Logged Out
2022-09-01 16:02:00 | Agent 1 | Agent | Logged Out |  |  |  |  |  | Total Owed Time
2022-09-01 08:15:00 | Agent 1 | Agent | Logged In
2022-09-01 08:15:00 | Agent 1 | Agent | Logged In
Spreadsheet: 1ce630ee-5161-424f-886d-f439d20a7f90
Sheet: SD_RTNCPCPMTDTL

Real Time Net Commitment Period Compensation Unit Payment Details Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Real Time Net Commitment Period Compensation Unit Payment Details Report
SD_RTNCPCPMTDTL_<customer id>_<settlement date>_<version>.CSV |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SD_RTNCPCPMTDTL_<customer id>_<settlement date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  |  |  | Startup Costs |  |  | No Load Costs |  |  | Energy Costs & Revenue |  |  |  |  | Daily Generation Offer |  |  | Daily Generation Value |  |  | Daily NCPC Credit |  |  | Hourly NCPC Credit
Trading Interval | ISO-NE Schedule Id | Resource Type | Asset ID | Base Startup Cost | Startup Adjustment Codes | Eligible Startup Costs | Base  No Load Cost | No Load Adjustment Codes | Eligible No Load Costs | Base Energy Cost | Base Energy Revenue | Energy Adjustment Codes | Eligible Energy Cost | Eligible Energy Revenue | Base Daily Generation Offer | Daily Generation Offer Adjustment Codes | Eligible Daily Generation Offer | Base Daily Generation Value | Daily Generation Value Adjustment Codes | Eligible Daily Generation Value | Base Daily Total NCPC Credit | Daily Total NCPC Credit Adjustment Codes | Eligible Daily Total NCPC Credit | Base Hourly NCPC Credit | Hourly NCPC Credit Adjustment Codes | Eligible Hourly NCPC Credit | NCPC Eligible | Implicit Self Scheduled Regulation MWs
Hour End | Number | String | Number | $ | String | $ | $ | String | $ | $ | $ | String | $ | $ | $ | String | $ | $ | String | $ | $ | String | $ | $ | String | $ | String | MWh
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 12 - Table 1

LAS results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 4Q10 | Scope |  |  | 4Q11 | Reported | Organic
Volume ('000 hl) | 10532.726 | 0 | 0 | 215.6550000000007 | 10748.381 | 0.02047475648754182 | 0.02047475648754185
Net revenue | 1237.044 | 0 | 4.765182799739705 | 323.9208172002601 | 1565.73 | 0.265702755924607 | 0.2618506837269006
Net revenue/hl | 117.4476578997688 | 0 | 0.4433395875843725 | 27.78024360467734 | 145.6712410920305 | 0.240307756637838 | 0.2365329722316414
[NAME] | -448.4210000000001 | 0 | -2.67341305238341 | -119.2765869476166 | -570.3710000000001 | 0.2719542572716263 | 0.2659924199527153
[NAME]/hl | -42.57406866940241 | 0 | -0.2487270457181793 | -10.24296367692181 | -53.0657593920424 | 0.2464338281621714 | 0.2405916088608025
Gross profit | 788.6230000000003 | 0 | 2.091769747356295 | 204.6442302526435 | 995.3589999999999 | 0.2621480732872357 | 0.2594956401888399
Gross margin | 0.6375060224211913 | 0 | 0 | 0 | 0.6357156086937084 | -20 | -10
SG&A excl. deprec.&amort. | -230.9299999999999 | 0 | -0.2667787868377616 | -47.63622121316238 | -278.833 | 0.2074351535097223 | 0.2062799169149197
SG&A deprec.&amort. | -18.58799999999999 | 0 | -0.3084000646864098 | -2.832599935313595 | -21.729 | 0.1689799870884445 | 0.1523886343508498
SG&A total | -249.5180000000001 | 0 | -0.5751788515238729 | -50.46882114847597 | -300.5619999999999 | 0.2045704117538607 | 0.2022652519997594
Other operating income/expenses | -4.301000000000002 | 0 | -0.009826933438622731 | 15.26082693343863 | 10.95 | nm | nm
Normalized EBIT | 534.8040000000002 | 0 | 1.5067639623938 | 169.4362360376062 | 705.7470000000001 | 0.3196367267260525 | 0.316819313314048
Normalized EBIT margin | 0.432324153385005 | 0 | 0 | 0 | 0.4507462972543159 | 180 | 190
Normalized EBITDA | 607.726 | 0 | 4.45067839263163 | 174.0493216073684 | 786.2260000000001 | 0.2937178926029167 | 0.2863943974873026
Normalized EBITDA margin | 0.4912727437342567 | 0 | 0 | 0 | 0.5021466025432227 | 110 | 100
Spreadsheet: 843100d1695057541-filter-specific-column-base-on-user-selection-my-formula-not-working-filter-by-area
Sheet: Sheet1

Name | Region | Inv | Amount |  | Region
A | North | #1 | 10 |  | North |  |  | Name | Invoice |  | East | West |  |  | Name | Invoice | South | East | West
B | East | #2 | 20 |  | South | x | Why is it not working?--> |  | #2 |  | 20 |  |  |  | B | #2 |  | 20 |  |  | <---- What I want
C | North | #3 | 30 |  | East | x |  | D | #4 |  |  | 40 |  |  | D | #4 |  |  | 40
D | West | #4 | 40 |  | West | x |  | E | #5 |  | 50 |  |  |  | E | #5 |  | 50
E | East | #5 | 50 |  |  |  |  | F | #6 | 60 |  |  |  |  | F | #6 | 60
F | South | #6 | 60 |  |  |  |  | A | #8 |  | 80 |  |  |  | A | #8 |  | 80
F | North | #7 | 70 |  |  |  |  | C | #10 |  | 100 |  |  |  | C | #10 |  | 100
A | East | #8 | 80 |  |  |  |  | D | #11 |  | 110 |  |  |  | D | #11 |  | 110
B | North | #9 | 90 |  |  |  |  | E | #12 | 120 |  |  |  |  | E | #12 | 120
C | East | #10 | 100 |  |  |  |  |  |  | 180 | 360 | 40 |  |  |  |  |  |  |  |  | <---- Possible to Vstack a total at end?
D | East | #11 | 110
E | South | #12 | 120
F | North | #13 | 130
Spreadsheet: 1482dd40-c719-476e-99da-bdff71e62242
Sheet: PBSF

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD  DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Emergency Management Certificate | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | PBSF 100 | 1 | X | 1
5 | PBSF 101 | 1 | X | 1
5 | PBSF 102 | 1 | X | 1
5 | PBSF 103 | 1 | X | 1
5 | PBSF 105 | 1
5 | PBSF 110 | 1 | X | 1
5 | PBSF 115 | 1 | X | 1
5 | PBSF 116 | 1 | X | 1
5 | PBSF 119 | 1
5 | PBSF 120 | 1 | 1 | 1
5 | PBSF 121 | 1 | X | 1
5 | PBSF 122 | 1 | X | 1
5 | PBSF 125 | 1 | X | 1
5 | PBSF 126 | 1 | X | 1
1 | PBSF 127X2 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
5 | PBSF 130 | 1
5 | PBSF 140 | 1
5 | PBSF 141 | 1
5 | PBSF 142 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: eric_saibi__9815__092501U
Sheet: San Juan 02

Owner Name |  | Public Service Company of New Mexico
Station Name |  | San Juan Generating Station
Unit Name |  | San Juan 02
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 350 MW
Start Date |  | 2001-09-24 00:00:00
End Date |  | 2001-09-27 00:00:00
Comments |  | Tube Leak
SIC |  | 4911
Plant ID |  | 1016385
Unit ID |  | 1007770
Outage ID |  | 18527
Spreadsheet: 786049d1656947961-xlookup-and-sumif-xlookup-and-sumif
Sheet: Sheet1

Fruit | Location | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | Total
Apples | London | 10 | 13 | 47 | 48 | 14 | 7 | 9 | 12 | 88 | 9 | 9 | 9
Oranges | London | 12 | 46 | 47 | 13 | 6 | 8 | 11 | 87 | 8 | 8 | 8 | 8
Pears | [NAME] | 45 | 46 | 12 | 5 | 7 | 10 | 86 | 7 | 7 | 7 | 7 | 7
Oranges | [NAME] | 45 | 11 | 4 | 6 | 9 | 85 | 6 | 6 | 6 | 6 | 6 | 6
Apples | [NAME] | 10 | 3 | 5 | 8 | 84 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Bananas | Bristol | 2 | 4 | 7 | 83 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Pears | Bristol | 3 | 6 | 82 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Bananas | Bristol | 5 | 81 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Bananas | London | 80 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
I want to lookup using [NAME] and sumif together to find a defined column and sumup all values meeting x2 specific References. In the example I want the formula to find Bananas in Bristol in July 22
eg Result |  | 2022-07-01 00:00:00
Bananas | Bristol
and also using one criteria only, just apples in July
Apples
Spreadsheet: rick_buy__32799__SUMMARY
Sheet: summary

MARINER ENERGY, INC.
APPENDIX
WEEKLY DRILLING AND COMPLETION SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  | PRESENT |  | PROPOSED
 |  |  | PROSPECT |  | AREA |  | WELL |  | E/D |  | [NAME] |  | DEPTH |  | TD |  | COMMENT
 | I. |  | WELLS CURRENTLY DRILLING
 |  |  | Green Canyon 136 |  | Deepwater |  | OCS-G 4508 #8 |  | D |  | 0.25 |  | 2,140' |  | 7,600' |  | Drilling.
 |  |  | (Shasta)
 | II. |  | WELLS REACHING TOTAL DEPTH, TESTING, OR TURNED TO SALES THIS WEEK
 |  |  | Green Cayon 516 |  | Deepwater |  | OCS-G 20074 #1 |  | E |  | 0.5 |  |  |  |  |  | Completing.
 |  |  | (Yosemite)
 | III. |  | WELLS ANTICIPATED TO SPUD WITHIN 90 DAYS
 |  |  | [NAME] 962 |  | Deepwater |  | OCS-G #1 |  | E |  | 0.15 |  |  |  | 4,478' |  | Expected spud date third week October 2001.
 |  |  | (Swordfish)
 |  |  | Visoca Knoll 962 |  | Deepwater |  | OCS-G #2 |  | E |  | 0.15 |  |  |  | 3,835' |  | Expected spud date  fourth week November
 |  |  | (Swordfish) |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001
 |  |  | Mississippi Canyon 205 |  | Deepwater |  | OCS-G #1 |  | E |  | 0.25 |  |  |  | 3,500' |  | Expected spud date mid December 2001.
 |  |  | (Piston)
 | IV. |  | OTHER
 |  |  | None to report.
Spreadsheet: 783595c6-82fb-496d-9016-0b694aab4cfa
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
CLBF | Test | CLBF | Chloride, Body Fluid | Chloride, BF | Indirect Ion-Selective Electrode (ISE)/Coulometric | Plastic vial: PlV |  |  | 1 | mL | Container/Tube: Sterile container [NAME]: 1 mL Collection Instructions: 1. Centrifuge to remove any cellular material. 2. Indicate specimen source. Additional Information: For spinal fluid, see CLSF/8218 Chloride, Spinal Fluid. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	Spinal fluid | Not applicable | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82438 |  |  |  |  | Rochester
CLBF | [NAME] | BODYFL | Body Fluid |  |  |  | Refrigerated | 7 days
CLBF | Order Question | FLD22 | [NAME] |  | Plain Text
CLBF | Result | CL_BF | Chloride, BF | Chloride, BF | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 2072-7
CLBF | Result | FLD22 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14725-6
Spreadsheet: scott_neal__37919__STOR9815
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9815
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2001-01-19 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 323 | 312
(TX, LA, OK, KS, MS)
Market Area - East |  | 872 | 816
Market Area - West |  | 264 | 241
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 74873d1275421261-double-offset-based-on-match-doubleoffset
Sheet: Step6

VisitorID (DW Only) | GeoSegmentation Demographic Area | [NAME] | Browser | Cookies | [NAME]
visID | geoDMA | eVar48 | [NAME] | cookies | custrLoy
[PHONE]-[PHONE]
100073969781554-45071752413341447
100082559648599-45071765835132681
103290891530871-45071740870591071
104033929642546-45071743554969079
107147780818696-45071740065316872
[PHONE]-[PHONE]
10721469920996-45071768787892856
[PHONE]-814748210
[PHONE]-[PHONE]
[PHONE]-[PHONE]
[PHONE]-[PHONE]
[PHONE]-475297912
[PHONE]-[PHONE]
[PHONE]-[PHONE]
[PHONE]-[PHONE]
[PHONE]-[PHONE]
108891537377368-45071748386788173
[PHONE]-[PHONE]
[PHONE]-958576261
[PHONE]-[PHONE]
Spreadsheet: 272948d1382553481-if-then-sum-formulas-report-example-nm2-
Sheet: Sheet1

 |  |  |  |  |  |  | Example of what column D should look like
Amount | Currency | Points |  |  |  |  | Amount | Currency | Points
231 | CHF | L |  |  |  |  | 231 | CHF | L
12313 | CHF | L |  |  |  |  | 12313 | CHF | L
123 | CHF | L |  |  |  |  | 123 | CHF | L
23 | CHF | L |  |  |  |  | 23 | CHF | L
23 | EUR | L |  |  |  |  | 23 | EUR | L
1 | EUR | L |  |  |  |  | 1 | EUR | L
112 | [NAME] | L |  |  |  |  | 112 | [NAME] | L
31 | USD | L |  |  |  |  | 31 | USD | L
313 | USD | L |  |  |  |  | 313 | USD | L
2 | CHF | T |  |  |  |  | 2 | CHF | T
322 | CHF | T |  |  |  |  | 322 | CHF | T
34232 | CHF | T |  |  |  |  | 34232 | CHF | T
4 | EUR | T |  |  |  |  | 4 | EUR | T
34 | EUR | T |  |  |  |  | 34 | EUR | T
2 | EUR | T |  |  |  |  | 2 | EUR | T
322 | GBP | T |  |  |  |  | 322 | GBP | T
43 | GBP | T |  |  |  |  | 43 | GBP | T
234 | USD | T |  |  |  |  | 234 | USD | T
2 | USD | T |  |  |  |  | 2 | USD | T
243 | USD | T |  |  |  |  | 243 | USD | T
Spreadsheet: larry_campbell__20971__pg&esamp
Sheet: PG&E Page 4

CONFIDENTIAL
[NAME] and PG&E Samples and Analytical Results
Date | Sample ID |  | Volume Drained |  | Comments |  |  |  | PG&E PCB | TW PCB | Location of sample point
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-03-18 00:00:00 | SLX-TW | 3-18-99-L | 0 |  | No liquid for sample |  |  |  |  |  | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-03-18 00:00:00 | PG&E-TW2 | 3-18-99-L | 50 oz |  |  |  |  |  | 144 PPM | 129 PPM | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-03-18 00:00:00 | PG&E-Top3 | 3-18-99-L | 64 oz |  |  |  |  |  | 90 PPM | 82 PPM | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-03-18 00:00:00 | PG&E-A6 | 3-18-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-03-18 00:00:00 | PG&E-B6 | 3-18-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
1999-03-18 00:00:00 | PG&E 10.84A | 3-18-99-L | 2 oz |  |  |  |  |  | 2 PPM | 2 PPM | PG&E's 34" Line A
1999-03-18 00:00:00 | PG&E 10.84B | 3-18-99-L | 2 oz |  |  |  |  |  | ND | ND | PG&E's 34" Line B
1999-03-18 00:00:00 | PG&E 8.58A | 3-18-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | PG&E's 34" Line B
1999-03-18 00:00:00 | PG&E-TW4 | 3-18-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 1st Siphon
1999-03-18 00:00:00 | PG&E-TW5 | 3-18-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 2nd siphon
1999-03-18 00:00:00 | PG&E-TW6 | 3-18-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 3rd Siphon
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-03-25 00:00:00 | SLX-TW | 3-25-99-L | 1 oz |  |  |  |  |  |  | 58 PPM | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-03-25 00:00:00 | PG&E-TW2 | 3-25-99-L | 36 oz |  |  |  |  |  | 216 PPM | 185 PPM | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-03-25 00:00:00 | PG&E-Top3 | 3-25-99-L | 36 oz |  |  |  |  |  | 86 PPM | 91 PPM | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-03-25 00:00:00 | PG&E-A6 | 3-25-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-03-25 00:00:00 | PG&E-B6 | 3-25-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
1999-03-25 00:00:00 | PG&E 10.84A | 3-25-99-L | 4 oz |  |  |  |  |  | 2 PPM | 1 PPM | PG&Es 34" Line A
1999-03-25 00:00:00 | PG&E 10.84B | 3-25-99-L | 2 oz |  |  |  |  |  | ND | ND | PG&E's 34" Line B
1999-03-25 00:00:00 | PG&E 8.58A | 3-25-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | PG&E's 34" Line B
1999-03-25 00:00:00 | PG&E-TW4 | 3-25-99-L |  |  | No liquid for sample |  |  |  |  |  | TW 20" 1st Siphon
1999-03-25 00:00:00 | PG&E-TW5 | 3-25-99-L |  |  | No liquid for sample |  |  |  |  |  | TW 20" 2nd siphon
1999-03-25 00:00:00 | PG&E-TW6 | 3-25-99-L |  |  | No liquid for sample |  |  |  |  |  | TW 20" 3rd Siphon
Spreadsheet: 751497d1634140415-transpose-values-inside-a-single-row-into-individual-rows-example
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5
Under 40 | 94.0064714553353 | 3.799657962158398 | 25.3454049873469 | A,B,C
40-50 | 65.95401856180482 | 22.88768667240045 | 67.6278556028393 | F,G,H
50-100 | 88.42686806580761 | 99.92790228547538 | 30.8290827127592 | L,M,A
100-200 | 6.860503080649172 | 92.96542022186559 | 62.46742486100275 | L,Q,A
 |  | <<< Desired Results
Under 40 | A |  | Column1 | Column5
Under 40 | B |  | Under 40 | A
Under 40 | C |  | Under 40 | B
40-50 | F |  | Under 40 | C
40-50 | G |  | 40-50 | F
40-50 | H |  | 40-50 | G
50-100 | L |  | 40-50 | H
50-100 | M |  | 50-100 | L
50-100 | A |  | 50-100 | M
100-200 | L |  | 50-100 | A
100-200 | Q |  | 100-200 | L
100-200 | A |  | 100-200 | Q
 |  |  | 100-200 | A
Spreadsheet: 862016d1709819047-how-to-apply-a-row-calculation-up-to-a-limit-threshold-and-caps
Sheet: Sheet3

 |  |  |  |  |  | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6 | Period 7 | Period 8 | Period 9 | Period 10 | Period 11 | Period 12
 |  | Monthly Pay |  |  |  | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
 |  |  | Rate | Threshold | Capped
 |  | Social Securty Contribution 1 | 0.00625 |  | 709.58
 |  | Social Securty Contribution 2 | 0.004 | 5000
 |  | Social Securty Contribution 3 | 0.011 | 8000 | 1000
Spreadsheet: 837762d1690398920-formula-to-add-values-based-on-criteria-as-month-quarter-and-yeartodate-exclude-colored-sample-data
Sheet: Sheet1

Current Month |  | 2023-06-30 00:00:00
EOM | EMP
2023-03-31 00:00:00 | 79.5266272189349
2023-04-30 00:00:00 | 1192.899408284023
2023-05-31 00:00:00 | 1232.66272189349
2023-06-30 00:00:00 | 1192.899408284023
2023-07-31 00:00:00 | 1232.66272189349
2023-08-31 00:00:00 | 1232.66272189349
2023-09-30 00:00:00 | 1192.899408284023 |  |  | [NAME] to add Values based on Criteria as month, Quarter and Year to date. Exclude those values which are Yellow highlighted
2023-10-31 00:00:00 | 1232.66272189349
2023-11-30 00:00:00 | 1192.899408284023
2023-12-31 00:00:00 | 1232.66272189349
2024-01-31 00:00:00 | 1232.66272189349
2024-02-29 00:00:00 | 1153.136094674556
2024-03-31 00:00:00 | 39.76331360946745
Requirement [NAME] calculated, should update when current month is changed in Cell C1
MTD | 0 | This is zero as value above is yellow highlighted
QTD |  | This is only adding Apr and May as June is Yellow highlighted
YTD |  | This is adding values of all months falling in year of current month in C1 excluding Yellow highlighted upto Current month
Spreadsheet: sara_shackleton__36378__RandomHouse(tradebook)
Sheet: Ticket

Paper/Pulp Deal Ticket |  |  |  |  |  |  |  |  |  |  |  | DRAFT
ERMS Deal Ticket Number: |  |  |  |  | (to be completed by [NAME])
 |  | Month |  | Day |  | Year
Deal Date:
ECT B/S
ECT Trader |  |  |  |  | Other:
Counterparty |  |  |  |  |  |  | Other: | Random House Corporation
Counterparty Contact |  | [NAME] |  |  |  |  | Phone |  |  |  | Fax | [PHONE]
Broker |  |  |  |  |  | Commission
Deal Type
Transaction Type |  |  |  |  | Other: |  |  |  |  |  | Linked trade
Option Style |  |  |  |  | Other:
 |  |  |  |  |  | Physical Prem |  |  |  | (ex: OCC11 - Official Board Markets)
Commodity |  |  |  |  |  | Storage
 |  |  |  |  |  | Other
 |  |  |  |  |  | Total
Pricing Reference | Commodity |  |  |  |  | Location |  | Low/High/Avg |  |  |  | Publication
Other:
Calculation Period |  |  |  |  |  |  | Payment/Settlement Date
 |  |  |  |  |  |  | 5 | Business Days After Price is Known
Other: | TBD |  |  |  |  | Note:
Fall Back Pricing:
 | Commodity |  |  |  |  | Location |  | Low/High/Avg |  |  |  | Publication |  |  |  |  | Spread
Other:
Trade Terms |  |  |  |  |  |  |  |  |  |  |  |  |  | Conditional
 | Annual Volume 15,500 short tons |  |  |  |  |  |  |  |  | Option only |  |  |  | Swap Only |  |  | Physical Only
Short/Metric | Monthly Vol. |  |  | Start Date |  | End Date |  | Fixed Price |  | Strike |  | Premium |  | [NAME] |  |  | Storage | Transport
 |  | 1291.67 |  | 2000-08-01 00:00:00 |  | 2006-07-31 00:00:00 |  |  |  | 980 |  | TBD
Currency
Note:
Note:
Option premium to be paid monthly.
Calculation period to be determined.  [NAME] negotiating possible quarterly calculation period.
Spreadsheet: 078824a8-08a3-4b3e-92b3-2416623d3509
Sheet: Table V.3

Table V.3 الجدول
Total Natural Gas Consumption and per capita Consumption in the ESCWA Region
مجموع استهلاك [NAME] الطبيعي [NAME] من استهلاك [NAME] الطبيعي في منطقة الإسكوا
 | Natural gas consumption (000 TOE)a/ |  | Natural gas consumption per capita ([NAME]
 | مجموع استهلاك الغاز الطبيعي |  | [NAME] من استهلاك الغاز الطبيعي
 | (ألف [NAME]) |  | (كغم مكافئ نفط)
 | 2008 | 2009 | 2008 | 2009
Bahrain | 12775 | 13286 | 12139 | 11360 | البحرين
Egypt | 36800 | 38300 | 470 | 480 | مصر
Iraq | 8278 | 9045 | 278 | 294 | العراق
Jordan | 2795 | 3066 | 478 | 509 | الأردن
Kuwait | 11500 | 12100 | 4513 | 4572 | الكويت
Lebanon | … | … | … | … | لبنان
Oman | 5263 | 5263 | 1996 | 1941 | عمان
Qatar | 18200 | 19000 | 13037 | 11892 | قطر
Saudi Arabia | 72400 | 69700 | 51860 | 43623 | المملكة العربية السعودية
The Sudan | … | … | … | … | السودان
The Syrian Arab Republic | 4083 | 5652 | 99 | 133 | الجمهورية العربية السورية
The United Arab Emirates | 53500 | 53200 | 2717 | 2653 | الإمارات العربية المتحدة
Yemen | … | … | … | … | اليمن
ESCWA* | 225594 | 228612 | 1271 | 1254 | [NAME]
Sources: | a/ | BP Statistical Review 2010 and OAPEC Annual Statistical Report 2010.
 | [NAME] | ESCWA Calculation, Population based on the United Nations: World Population Prospects: The 2010 Revision.
Note: | * | Excluding Lebanon, The Sudan and Yemen.