tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 746110d1630509869-formula-to-calculate-total-book1
Sheet: Sheet1

Date | Invoice number | Description | price | tax | total
2021-08-12 00:00:00 | 145678 | Oil Can | 12 |  |  |  | =total of taxes for the invoice number 145678
 |  | Onion 3kg | 4
 |  | Fish can | 19
 |  | Water 1.5l | 7
2021-08-13 00:00:00 | 147989 | apple | 4 |  |  |  | =total of taxes for the invoice number 147989
 |  | orange | 5
 |  | Onion 3kg | 21
 |  | [NAME] | 40
2021-08-18 00:00:00 | 147999 | Oil Can | 12 |  |  |  | =total of taxes for the invoice number 147999
 |  | Onion 3kg | 4
 |  | Fish can | 19
 |  | Water 1.5l | 7
Spreadsheet: 114962d1310619745-automatically-updating-data-from-one-sheet-to-another-june
Sheet: Main

Date | 6390 | 1090 | 2090 | 90 | 5011 | 2410 | 6566 | 3599 | 9406 | 8788 | 5570 | 3090 | 469
2011-06-01 00:00:00 | ='6390'!B2 | ='1090'!B2
 | ='6390'!B3
 | ='6390'!B4
 | ='6390'!B5
 | ='6390'!B6
 | ='6390'!B7
 | ='6390'!B8
 | ='6390'!B9
 | ='6390'!B10
 | ='6390'!B11
 | ='6390'!B12
 | ='6390'!B13
 | ='6390'!B14
 | ='6390'!B15
 | ='6390'!B16
 | ='6390'!B17
 | ='6390'!B18
 | ='6390'!B19
 | ='6390'!B20
 | ='6390'!B21
 | ='6390'!B22
 | ='[NAME]
 | ='6390'!B24
 | ='6390'!B25
 | ='6390'!B26
Spreadsheet: 675184d1588187130-matching-up-to-two-sets-of-data-move-sample
Sheet: Sample

Sample |  |  |  |  |  |  |  |  | Non Sorted List
Client # | DDA Account | Primary Name | RDS | RDS Limit | Setup Date | Review | Visit | Officer | DDA ACCT | NAME | RISK
4541231 | 668 | ABC CO | Y | 20000 | 06/02/2010 | 01092021 | 05072020 | ALP - PRIETO (60) |  |  | H
 | 802 | ABC CO | Y |  |  |  |  | ALP - PRIETO (60) |  |  | M
4543453 | 9505 | BBB | Y | 125000 | 06/22/2011 | 12102020 | 11262020 | NSK - KAIL (52) |  |  | L
 | 7499 | BBB | Y |  |  |  |  | NSK - KAIL (52) |  |  | M
 | 1380 | BBB | Y |  |  |  |  | NSK - KAIL (52) |  |  | M
34213453 | 7608 | CORP INC | Y | 750000 | 2019-08-27 00:00:00 |  |  | CWM - MILAM (59) |  |  | M
 | 7616 | ABC CO |  |  |  |  |  |  |  |  | M
 | 921 | Test |  |  |  |  |  |  |  |  | L
 |  |  |  |  |  |  |  |  | Sorted List
 |  |  |  |  |  |  |  |  | DDA ACCT | NAME | RISK
They both have a column in common, what I'm wanting to do is figure out how to tell excel to |  |  |  |  |  |  |  |  |  |  | H
sort it out so it matches the rows up based off of those same fields so that I don't have to manually retype everything. |  |  |  |  |  |  |  |  |  |  | M
There is extra data in one set, anything that doesn't match up should just be moved to the bottom. |  |  |  |  |  |  |  |  |  |  | L
 |  |  |  |  |  |  |  |  |  |  | M
 |  |  |  |  |  |  |  |  |  |  | M
 |  |  |  |  |  |  |  |  |  |  | M
 |  |  |  |  |  |  |  |  |  |  | M
 |  |  |  |  |  |  |  |  | Both are [NAME]
 |  |  |  |  |  |  |  |  | Enter by pressing
 |  |  |  |  |  |  |  |  | Shift, Ctrl, enter
Spreadsheet: 28959d1223557470-mrp-plan-expolding-down-materials-copy-of-exceltip
Sheet: BOM

Raw Material | Used in | Qty | Week
Raw Material 1 | Item1 | 1500 | 41
Raw Material 1 | Item2 | 2000 | 41
Raw Material 2 | Item1 | 1 | 41
Raw Material 3 | Item1 | 1 | 41
Raw Material 4 | Item1 | 1 | 41
Raw Material 5 | Item1 | 1 | 41
Raw Material 6 | Item1 | 1 | 41
Raw Material 7 | Item1 | 1 | 41
Spreadsheet: andy_zipper__216__EOL_Countries&Products_Status_05-25-01
Sheet: EOL New NA  Products

 |  | ENRONONLINE NEW PRODUCTS STATUS Managed by US office |  |  |  | as of:
 | TRANSACTION  PRODUCTS
# | Commodity | Product | Country/Location | Business Unit | Business Unit  Contact | Process Manager | Responsibility |  |  | Scheduled for | Comments
 | Freight | US Tanker Freight Swap | US | Freight | [NAME] | [NAME] | [NAME] |  | For Release | 2001-06-01 00:00:00 | 5/18 Needs to be discussed with Tax & Legal. 5/25 Waiting on approval from legal, to be released June 4th.
 | Freight | US Tanker Freight Swap | US | Freight | [NAME] | [NAME] | [NAME] |  | Test | 2001-06-01 00:00:00 | 5/18 Needs to be discussed with Tax & Legal.
 | Gas | Can Gas Fin Opt Call/Put (INTERNAL ONLY) | CAN | Gas | Lon Draper | [NAME] | [NAME] | On Hold | On Hold | 2001-03-01 00:00:00 | 3/09 Description in Legal, Launch target is March 19th. 3/16 Waiting on notice from Savita. Product on Hold. 3/30 Product Revised. 4/20 On Hold. 5/11 Product changed to External.
 | Gas | US Gas Secondary Firm | US | Gas | [NAME] | [NAME] | [NAME] | Test | Test | 2001-04-01 00:00:00 | 4/13 Drafting Language. 4/20 Product on Hold. 4/27 Product in Test. 5/11 Waiting on GTC launguage from legal
 | Global Products | US SYN Fuel Coal | US | Global Products | [NAME] | [NAME] | [NAME] | On Hold | On Hold | 2001-04-01 00:00:00 | 3/30 Drafting Language.  4/9 Product Type on hold pending Legal development of GTC's and logistics, etc. 4/20 Product on Hold. 5/11 Waiting on GTC from legal.
 | Newsprint | Can Newsprint Phy | CAN | Newsprint | [NAME] | [NAME] | [NAME] |  | For Release | 2001-06-01 00:00:00 | 5/25 Waiting on approvals to be released June 4th.
 | Power | Us West Power CAISO Spread | Us | Power | [NAME] | [NAME] | [NAME] | Review | Review | 2001-03-01 00:00:00 | 3/09 Description being reviewed by trader,
 | Power | US Phy Power Call and Put | US | Power | [NAME] [NAME] | [NAME] | [NAME] |  | For Release | 2001-06-01 00:00:00 | 5/25 Waiting on approvals to be released June 4th.
 | Recovered Paper | Can Recycled OCC Phy | CAN | Recovered Paper | [NAME] | [NAME] | [NAME] |  | For Release | 2001-06-01 00:00:00 | 5/25 Pending Sigma factor and GTC. Waiting on approvals to be released June 4th.
 | Recovered Paper | Can Recycled ONP Phy | CAN | Recovered Paper | [NAME] | [NAME] | [NAME] |  | For Release | 2001-06-01 00:00:00 | 5/25 Pending Sigma factor and GTC. Waiting on approvals to be released June 4th.
Spreadsheet: 79699d1279895568-pivot-table-raw-data-pivot-test-raw-data
Sheet: Sheet1

 |  |  |  |  | date | total | subtotal | [NAME]
 |  |  |  |  | 2010-07-22 00:00:00 | 1 | 1 | abc
 |  |  |  |  | 2010-07-22 00:00:00 | 1 | 0 | abc
 |  |  |  |  | 2010-07-22 00:00:00 | 1 | 1 | abc
 |  |  |  |  | 2010-07-22 00:00:00 | 1 | 1 | abc
 |  |  |  |  | 2010-07-22 00:00:00 | 1 | 0 | abc
 |  |  |  |  | 2010-07-22 00:00:00 | 1 | 1 | def
 |  |  |  |  | 2010-07-22 00:00:00 | 1 | 1 | def
 |  |  |  |  | 2010-07-22 00:00:00 | 1 | 1 | def
 |  |  |  |  | 2010-07-22 00:00:00 | 1 | 0 | def
 |  |  |  |  | 2010-07-31 00:00:00 | 1 | 1 | abc
 |  |  |  |  | 2010-07-31 00:00:00 | 1 | 0 | abc
 |  |  |  |  | 2010-07-31 00:00:00 | 1 | 1 | abc
 |  |  |  |  | 2010-07-31 00:00:00 | 1 | 1 | abc
 |  |  |  |  | 2010-07-31 00:00:00 | 1 | 0 | abc
 |  |  |  |  | 2010-07-31 00:00:00 | 1 | 1 | def
 |  |  |  |  | 2010-07-31 00:00:00 | 1 | 0 | def
 |  |  |  |  | 2010-07-31 00:00:00 | 1 | 1 | def
Spreadsheet: 690297d1597013496-lookup-value-in-column-then-assess-corresponding-row-for-a-value-finance2
Sheet: Summary Fore Old

This table is only used to make the mock up work.
Accountant | Car - insurance | Car - Repayment
2020-06-01 00:00:00 | 2020-06-04 00:00:00 | 2020-06-06 00:00:00
2020-07-01 00:00:00 | 00:00:00 | 2020-07-05 00:00:00
2020-07-31 00:00:00 | 2020-06-11 00:00:00 | 2020-07-19 00:00:00
2020-08-30 00:00:00 |  | 2020-08-02 00:00:00
2020-09-29 00:00:00 |  | 2020-08-16 00:00:00
2020-10-29 00:00:00 |  | 2020-08-30 00:00:00
2020-11-28 00:00:00 |  | 2020-09-13 00:00:00
2020-12-28 00:00:00 |  | 2020-09-27 00:00:00
2021-01-27 00:00:00 |  | 2020-10-11 00:00:00
2021-02-26 00:00:00 |  | 2020-10-25 00:00:00
 |  | 2020-11-08 00:00:00
 |  | 2020-11-22 00:00:00
 |  | 2020-12-06 00:00:00
 |  | 2020-12-20 00:00:00
 |  | 2021-01-03 00:00:00
 |  | 2021-01-17 00:00:00
 |  | 2021-01-31 00:00:00
 |  | 2021-02-14 00:00:00
 |  | 2021-02-28 00:00:00
 |  | 2021-03-14 00:00:00
 |  | 2021-03-28 00:00:00
 |  | 2021-04-11 00:00:00
 |  | 2021-04-25 00:00:00
 |  | 2021-05-09 00:00:00
 |  | 2021-05-23 00:00:00
 |  | 2021-06-06 00:00:00
 |  | 2021-06-20 00:00:00
 |  | 2021-07-04 00:00:00
 |  | 2021-07-18 00:00:00
 |  | 2021-08-01 00:00:00
Spreadsheet: 2feeebd7-ae58-4741-b351-c1e437e3b68c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Water Quality Salty Discharge  Mass Balance Calculations Form | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  | Water Quality Point Source Program
 |  |  |  | Doc Type:  Standards Review Calculations
Note: [NAME] both the Mass Balance tab and the Sodium % tab
Mass Balance Calculations for Salty Discharge
Parameter |  |  | River * | Discharge **
Flow:     cfs |  |  |  | 0 |  | Annual 7Q10 estimate
mgd |  |  |  |  |  | WWTF is ADW design, Industrial is max day design
Specific conductance, uS/cm
Hardness, mg/L as CaCO3
Chlorides, mg/L
Total [NAME], mg/L
Sulfates, mg/L as SO4
Bicarbonates:   mg/L
milliequivalents/L (meq/L) |  |  | 0 | 0 |  | meq/L = mg/L divided by 61.02
other
other
other
* River Monitoring data:  upstream/representative monitoring data
** Discharge data:  Effluent monitoring data
Results: |  |  |  | Use | Estimated
 |  |  | [NAME] | Class | Concentration
Specific conductance, uS/cm |  |  | 1000 | 4A |  |  | Minn. R. 7050
Hardness, mg/L as CaCO3 |  |  | 250 | 3B
Chlorides, mg/L |  |  | 100 | 3B |  |  | Notes:
Total [NAME], mg/L |  |  | 500 | 1C
Sulfates, mg/L as SO4 |  |  | 250 | 1C
Bicarbonates:   milliequiv/L |  |  | 5 | 4A
other
other
other
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 16b

 |  | TOTAL
Product |  | HY** | IG | Other
Index Tranche* | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending August 16, by product type (total value of trades in millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for product grade descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 35390d1232995919-vlookup-rechnung-1-
Sheet: Musterrechnung

Pos. | Quantity | Unit | [NAME] | ArticleNumber | Article Description |  |  |  | ArticleNumber | Article Description
1 | 6 | qm |  | 100-150 | 15x15 cm Unit Two # 1106-TW 02 |  |  |  | 100-150 | 15x15 cm Unit Two # 1106-TW 02
2 | 12.5 | [NAME] |  | 100-160 | [NAME] |  |  |  | 100-160 | [NAME]
3 | 7.5 | qm |  | 200-100 | 25x25 cm [NAME]. Sorte   grau blau xyxxxxxxxx |  |  |  | 200-100 | 25x25 cm [NAME]. Sorte   grau blau xyxxxxxxxx
 |  |  |  | 200-110 | 30x30 cm Color Line Blue xRay VB  1. Sorte dunkelblau |  |  |  | 200-110 | 30x30 cm Color Line Blue xRay VB  1. Sorte dunkelblau
 |  |  |  | 100-150 | 15x15 cm Unit Two # 1106-TW 02
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: EAST-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 66050158 | 157021800.05
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 69521578 | 159508985.95
4 |  | Option Premiums | 0 | 24768
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 135571736 | 316555554
 | Purchases:
6 |  | 3rd Party / Inter Enron | -86507193 | -202900168
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -49770103 | -114326909
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 237567 | 531921
 | Total Purchases: |  | -136039729 | -316695156
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | -1004508 | -2299953
12 |  | Purchases | 582660 | 1315137
 | Total Intra CTS Sales / Purchases |  | -421848 | -984816
 | Imbalances:
13 |  | In Kind | 326249 | 812865
14 |  | Cash Out | 41175 | 54822.21905462886
15 |  | Cash In | 559377 | 1269071
16 |  | Synthetic Storage | -346452 | -778472
 | Total Imbalances: |  | 580349 | 1358286.219054629
 | Storage:
17 |  | Injection (Sales to Stg) | -311859 | -736027
18 |  | W/D (Purchase from Stg) | 205867 | 483787
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 205867 | 483787
 | Total Storage: |  | -105992 | -252240
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 475484 | 1074270.939144055
 |  |  | 0 | 0
23 | Fuel: |  | -237567 | -531921
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -509841
25 |  | Demand | 0 | -1302091
 | Total Transport Expense: |  | 0 | -1811932
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | -104001
 | Total Transport Revenue: |  | 0 | -104001
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 70884
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 70884
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 2849705.85
31 |  | Prior Month Book Balance | 0 | 196193
 |  | Total MTM Income | 0 | 3045898.85
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -2871909
34 |  | Originations | 0 | 667651
35 |  | Broker Fees | 0 | -8213
36 |  | Asset Group Demand Charges | 0 | 2670191
37 |  | [NAME] | 0 | 24523.945
38 |  | Interdesk Charges | 0 | 878217
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -1987039
 |  | TOTAL INTRA-MTH
FT-East
 |  | Current Month MTM | 0 | -199187
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 66398d1267053762-looping-a-named-range-excel_namedrangequeryoperation
Sheet: CityHall_Elec

Billing |  | Consum.
Read Date | Days | kWh
2005-01-17 00:00:00 | 34 | 332400
2005-02-16 00:00:00 | 30 | 273600
2005-03-15 00:00:00 | 27 | 206400
2005-04-15 00:00:00 | 31 | 238800
2005-05-13 00:00:00 | 28 | 244800
2005-06-15 00:00:00 | 33 | 205200
2005-07-18 00:00:00 | 33 | 291600
2005-08-16 00:00:00 | 29 | 247200
2005-09-15 00:00:00 | 30 | 258000
2005-10-18 00:00:00 | 33 | 194400
2005-11-17 00:00:00 | 30 | 234000
2005-12-14 00:00:00 | 27 | 230400
2006-01-18 00:00:00 | 35 | 280800
2006-02-14 00:00:00 | 27 | 223200
2006-03-14 00:00:00 | 28 | 234000
2006-04-13 00:00:00 | 30 | 238800
2006-05-15 00:00:00 | 32 | 231600
2006-06-15 00:00:00 | 31 | 266400
2006-07-17 00:00:00 | 32 | 321600
2006-08-15 00:00:00 | 29 | 300000
2006-09-18 00:00:00 | 34 | 318000
2006-10-12 00:00:00 | 24 | 187200
2006-11-16 00:00:00 | 35 | 265200
2006-12-15 00:00:00 | 29 | 274800
2007-01-17 00:00:00 | 33 | 302400
Spreadsheet: de1b1bb7-8df9-47bd-b79b-142e8c7eb912
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
CYCL | Test | CYCL | [NAME] | [NAME] | Safranin Stain of Stool | Stool Container: Stool |  |  | 10 | g | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  Patient should avoid use of anti-diarrheal medication (ie, loperamide or Pepto-Bismol).   The presence of barium will interfere with this test.   Submit only 1 of the following specimens:      Preferred: [NAME] stool Container/Tube: Preferred: ECOFIX preservative (Supply T219) Acceptable: Container with 10% formalin [NAME]: 10 g Specimen Stability Information: Ambient (preferred)/Refrigerated   Specimen Type: Unpreserved stool Container/Tube: Stool container (Supply T288) [NAME]: 5 g  Collection Instructions: See Stool Collection Information Sheet in Special Instructions. Specimen Stability Information: Refrigerated 3 days (preferred)/Frozen   Acceptable: [NAME] aspirate Container/Tube: Sterile container [NAME]: Entire collection | Preserved stool: 1 g/Unpreserved | Hemolysis	NA Thawing	Warm OK-note to lab; Cold OK Lipemia	NA Icterus	NA Other	NA | Negative If positive, reported as [NAME] species | Monday through Saturday; 12 p.m. | 2 days | 4 days |  | Profile |  |  |  |  | Rochester
CYCL | [NAME] | FECAL | Fecal |  |  |  | See instructions
CYCL | Order Question | Q00M0017 | [NAME] |  | Plain Text
CYCL | Result | CYCL | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
CYCL | Billing Component | CYCL |  | Concentration |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87015
CYCL | Billing Component | CYCL |  | Special Stain |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87207
Spreadsheet: 681013d1591296494-complicated-formula-needed-to-find-value-in-a-range-with-multiple-variables-consolidated-rules-sample-file-
Sheet: Calcultor Current

 |  |  |  |  |  | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00
 |  |  |  |  | Event Guests | 10 | 15 | 15 | 10 | 45 | 45 | 45
 |  |  |  |  | Total Guests | 80 | 86 | 85 | 86 | 86 | 86 | 86
 |  |  |  |  | Occupied rooms | 80 | 80 | 80 | 80 | 80 | 80 | 80
Business name 1
Department | Status | Unit of Measure | Shift | Code | Position | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
 | Active | n/a | n/a | 10a | Night Auditor
 | Active | Event Guests | Shift 1 | 12b | Planner
 | Active | Event Guests | Shift 2 | 12b | Planner
 | Active | Event Guests | Shift 3 | 12b | Planner
 | Inactive | n/a | n/a | 61a | Manager
 | Active | Total Guests | Shift 1 | 51a | Receptionist
 | Active | Total Guests | Shift 2 | 51a | Receptionist
 | Active | Total Guests | Shift 3 | 51a | Receptionist
 | Inactive | n/a | n/a | 31a | Engineer
 | Active | Occupied rooms | n/a | 40a | [NAME]
 | Active | Occupied rooms | n/a | 40b | Server
 |  |  |  |  |  | *** I started to attempt a formula in cell G22 but gave up. :(
Spreadsheet: 773817d1648054793-printing-multiple-payslips-from-pdf-payslip-updated
Sheet: 1008

 | Company Name
 | Address
 | Pay slip for the month of March 2022
 | Emp Code |  | Emp Name
 | Earnings |  | Deduction
 | Basic |  | NI
 | Medical |  | TAX
 | CONV Allowance
 | HRA
 | Total Addition |  | Total Deduction
 |  |  | Net Salary
 | Date
 | Signature of Employee |  | Director
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: firm9701

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
JANUARY, 1997
IFGMR (TRKL/TX) |  |  | 3.59 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 3.8
IFGMR (PEPL/TX/OK) |  |  | 4.1
IFGMR (ANR/LA) |  |  | 3.85
IFGMR (HENRY HUB) |  |  | 4.09
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001 | 3.93
 | 1993 | 2.4 | 2002 | 4.23
 | 1994 | 2.51 | 2003 | 4.73
 | 1995 | 2.61 | 2004 | 5.07
 | 1996 | 2.53 | 2005 | 5.43
 | 1997 | 2.65 | 2006 | 5.82 | JAN-SEP
 | 1998 | 2.67 | 2006 | 5.95 | OCT-DEC
 | 1999 | 2.9 | 2007 | 6.37
 | 2000 | 3.33
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-302
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.71 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.71 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.71 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 32658d1228839662-finding-matches-book1
Sheet: Sheet1

A | B | DUE | PAID
25 | 30 | 55 | 55
0 | 50 | 50 | 50
250 | 100 | 350 | 350
20 | 50 | 70
50 | 80 | 130 |  |  | **NEXT PAYMENT I RECEIVE ON MY LIST IS R220. IS THERE A WAY TO CALCULATE THAT THIS WILL BE C5+C6+C7**
0 | 20 | 20
ANOTHER EG.
A | B | DUE | PAID
200 | 100 | 300 | 300
0 | 10 | 10
50 | 25 | 75
70 | 80 | 150 |  |  | NEXT PAYMENT I RECEIVE IS FOR R285. IS THERE A FORMULA TO CALCULATE THAT THIS IS FOR C14 and C16
120 | 90 | 210
 |  | SO BASICALLY, IS THERE A WAY THAT I CAN ENTER THE PAYMENT INTO A CERTAIN CELL, AND I WILL BE TOLD FOR WHICH CELLS IN COLUMN C IT APPLIES TO
LOOKING SOMETHING LIKE THIS:
A | B | DUE | PAID |  |  | PAYMENT | CELL
200 | 100 | 300 | 300 |  |  | 285 | C29,C31 |  | AS the list will probabaly be way too long for excel to try every single combination, would there be way
0 | 10 | 10 |  |  |  | I enter | excel calculates |  | to select a range in which the due payments are most likely to be found - a small range of about 10 numbers
50 | 25 | 75 |  |  |  | this value | this
70 | 80 | 150
120 | 90 | 210
Spreadsheet: 116971d1312375221-conditional-formatting-if-the-value-is-selected-from-2-diff-columns-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Fixed Price or T&M | FP | T&M | FP
 |  | ProjectName |  |  |  |  |  |  |  | Activity | X | Y | Z
Activity 1 |  | Z |  |  |  |  |  |  |  | Documentation | 1 | 2 | 2
 |  | Execution |  |  |  |  |  |  |  | Execution | 1.85 | 1.6 | 1.5
 |  |  |  |  |  |  |  |  |  | Review | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  | Corrections | 0.87 | 0.65 | 0.75
 |  |  |  | If E5 was selected from the any of column FP's it should be formatted to a colour
Spreadsheet: 27228d1220364940-help-creating-in-house-reporting-excel-doc-correct-kt-usage
Sheet: Master

 | Ref Number | Should KT have been used? | Was [NAME] used? | Was the correct KT document used? | Q1 | Q2 | Q3 | Total | Total Score
 | 1 | Yes | Either Yes or No | Either Yes or No | Either Yes or No | 0 | 0 | 2 | 0
 | 2 | Yes | Either Yes or No | Either Yes or No | Either Yes or No | 0 | 0 | 2 | 0
 | 3 | Yes | Either Yes or No | Either Yes or No | Either Yes or No | 0 | 0 | 2 | 0
 | 4 | Yes | Either Yes or No | Either Yes or No | Either Yes or No | 0 | 0 | 2 | 0
 | 5 | Yes | Either Yes or No | Either Yes or No | Either Yes or No | 0 | 0 | 2 | 0
 | 6 | Yes | Either Yes or No | Either Yes or No | Either Yes or No | 0 | 0 | 2 | 0
 | 7 | Yes | Either Yes or No | Either Yes or No | Either Yes or No | 0 | 0 | 2 | 0
 | 8 | Yes | Either Yes or No | Either Yes or No | Either Yes or No | 0 | 0 | 2 | 0
 | 9 | Yes | Either Yes or No | Either Yes or No | Either Yes or No | 0 | 0 | 2 | 0
 | 10 | Yes | Either Yes or No | Either Yes or No | Either Yes or No | 0 | 0 | 2 | 0
 |  |  |  |  |  |  |  | 20 | 0 | 0
 |  |  |  |  |  | Row Number: |  | 5
 |  | Totals
 |  | Total Score | 0
 |  | Possible Score | 20
 |  | Percentage | 0
Spreadsheet: 881098d1729007639-verschachtelte-formel-verschachtelte-formel
Sheet: Input

 | IST | IST | IST | IST |  | Prognose | Prognose | Prognose | Prognose
Name | 2023 | 2022 | 2021 | 2020 |  | 2025 | 2024 | 2023 | 2022
Name1 | 31 | 79 | 66 | 51 |  | 7 | 49 | 53 | 74
[NAME] |  |  |  | - |  | -85.71428571428572 | -7.547169811320753 | 4.7 | 2
Hilfszeile | 77 | 50 | 44 | 66 |  |  | - | - | -
Name3 | 57 | 47 | 3 | 98 |  | 27 | 40 | 64 | 5
Name4 | 67 | 70 | 58 | 35 |  | 31 | 20 | 46 | 54
Name5 | 44 | 43 | 96 | 14 |  | 51 | 75 | 98 | 42
Name6 |  |  |  |  |  | 47 | 99 | 27 | 77
Hilfszeile | 8 | 6 | 5 | 10 |  |  | - | - | -
Name7 | 78 | 7 | 16 | 55 |  | 88 | 28 | 98 | 26
Name8 | 24 | 12 | 70 | 51 |  | 37 | 20 | 12 | 66
Name9 | 14 | 95 | 20 | 34 |  | 7 | 22 | 79 | 50
Name10 | 12 | 26 | 36 | 50 |  | 82 | 53 | 98 | 98
Name11 | 68 | 10 | 99 | 48 |  | 52 | 6 | 3 | 8
Hilfszeile | 32 | 43 | 16 | 43 |  |  | - | - | -
Hilfszeile | 23 | 17 | 39 | 21 |  |  | - | - | -
Name12 |  |  |  | 24.7 |  | 71 | 92 | 38 | 84
Name13 | 68 | 15 | 98 | 85 |  | 71 | 44 | 21 | 91
Name14 | 96 | 50 | 40 | 9 |  | 7 | 31 | 44 | 13