tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5c1b7636-f4e6-4734-b67b-a9a3b465e699
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8238 | 58323 | [NAME] | Colbert | USA | 183 | 00:28:46 | 00:01:30 | 01:30:47 | 00:00:56 | 00:55:03 | 1 | 02:57:04
8238 | 46849 | Annette | Macniven | USA | 185 | 00:32:10 | 00:01:34 | 01:33:23 | 00:01:13 | 00:57:47 | 2 | 03:06:09
8238 | 58325 | [NAME] | [NAME] | USA | 186 | [NAME] | 00:01:58 | 01:40:47 | 00:01:11 | 00:53:39 | 3 | 03:07:11
8238 | 58324 | [NAME] | Hollibaugh | USA | 184 | 00:32:18 | 00:01:30 | [NAME] | 00:01:20 | 00:55:01 | 4 | 03:16:55
Spreadsheet: 716402d1612196259-how-to-count-and-sum-up-a-column-based-on-unique-values-of-another-column-no-of-unique-position
Sheet: Sheet2

Job Code | Name | Job Title | Position | Fund | FTE Actual | FTE Budget
5069 | [NAME] | [NAME] | 00011111 | 109630 | 0.2 | 0.2
6227 | STudent2 | [NAME] | 00020982 | 109622 | 1 | 1 |  | answer should be:
5069 | STudent3 | [NAME] | 00039634 | 109630 | 0.2 | 0.2 |  | # filled position |  | 11
5052 | STudent4 | Facilities Customer Advocate | 00039273 | 109629 | 0.39996 | 0.39996 |  | # of vacant position - |  | 3
6226 | STudent5 | Building Attendant I | 00025021 | 109622 | 0.475 | 0.475
6226 | Vacant | Building Attendant I | 00039640 | 109621 | 0 | 0.475
5303 | STudent7 | HVAC Mechanic | 00014914 | 109630 | 0.70002 | 0.70002
5069 | STudent8 | [NAME] | 00040280 | 109630 | 0.70003 | 0.70003
6226 | Vacant | Building Attendant I | 00039321 | 109621 | 0 | 0.5
6226 | Vacant | Building Attendant I | 00039321 | 109622 | 0 | 0.5
6220 | STudent9 | Supv, Operations & Maintenance | 00040278 | 109630 | 0.83001 | 0.83001
6227 | Vacant | [NAME] | 00013771 | 109622 | 0 | 0
6226 | STudent11 | Building Attendant I | 00013834 | 109621 | 1 | 1
6227 | STudent12 | [NAME] | 00013881 | 109622 | 1 | 1
6227 | STudent13 | [NAME] | 00014072 | 109622 | 1 | 1
6227 | STudent14 | [NAME] | 00011111 | 109621 | 0.8 | 0.8
6227 | STudent15 | [NAME] | 00020982 | 109621 | 1 | 0
Spreadsheet: 878413d1725473303-range-data-selection-excel-help-1
Sheet: Sheet1

 | Measured Width |  | Measured Thick |  | Criteria 1 | [NAME]
1 | 0.268 |  | 0.26
2 | 0.51 |  | 0.125
3 | 0.166 |  | 0.37
4 | 0.182 |  | 0.5
5 | 0.6 |  | 0.1
6 | 0.278 |  | 0.25
 |  |  |  |  | Pass Criteria 1 |  | Pass Criteria 2
 |  |  |  |  | Pass [NAME] |  | Pass CriteriaThick
 |  |  |  |  | 0.25 |  | 0.4
 |  |  |  |  | 0.25 |  | 0.25
 |  |  |  |  | 0.25 |  | 0.125
 |  |  |  |  | 0.37 |  | 0.4
 |  |  |  |  | 0.37 |  | 0.25
 |  |  |  |  | 0.5 |  | 0.4
Spreadsheet: sally_beck__35172__MgmtSum-Q3-0928_Global
Sheet: GM-WeeklyChnge

ENRON GLOBAL MARKETS
3RD QUARTER 2000 DETAIL OF GROSS MARGIN - WEEKLY CHANGE
 |  |  |  |  |  |  | Actual | Deals | Forecast | Total
Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin
Liquids
Coal
Emissions
Weather
Global Risk Markets
Equity Trading
FX / Int Rate Trading
Soft Commodities Trading
Grain Trading
Meat Trading
Financial Trading
Office of the Chairman
Overview
Total Commercial
Other Interest Related Charges
Global Markets Pre-tax Income
(1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 151190d1334826476-pivot-table-show-full-range-of-data-exampledata
Sheet: Temp

Score | Weight | Company | Domanda
4 | 0.000550030242695464 | [NAME] | Q1 |  | Question | Q2
5 | 0.07689542364674476 | AirFrance | Q1
4 | 0.3763548455541983 | Alitalia | Q1 |  | Somma di Weight | Column
4 | 0.1233579131087333 | Easyjet | Q1 |  | [NAME] | [NAME] | AirFrance | Alitalia | Easyjet | KLM | MeridianaFly | Ryanair | Swiss | Windjet
3 | 0.01086351579450703 | KLM | Q1 |  | 1 |  |  |  |  |  |  |  |  | 0.04470603414923805
3 | 0.06910705519607294 | Lufthansa | Q1 |  | 2 |  |  |  |  | 0.007942101035761748
4 | 0.07106199420758369 | MeridianaFly | Q1 |  | 3 |  |  |  |  |  | 0.0779280228162484
4 | 0.2076799407497857 | Ryanair | Q1 |  | 4 | 0.0006031743097047011 | 0.06746006379617324 | 0.4127183499196435 |  |  |  | 0.2277460313589013 | 0.02561943543015737
4 | 0.02336217584311416 | Swiss | Q1 |  | 5 |  |  |  | 0.1352767871841719
3 | 0.04076710565656483 | Windjet | Q1
4 | 0.0006031743097047011 | [NAME] | Q2
4 | 0.06746006379617324 | AirFrance | Q2
4 | 0.4127183499196435 | Alitalia | Q2
5 | 0.1352767871841719 | Easyjet | Q2
2 | 0.007942101035761748 | KLM | Q2
3 | 0.0779280228162484 | MeridianaFly | Q2
4 | 0.2277460313589013 | Ryanair | Q2
4 | 0.02561943543015737 | Swiss | Q2
1 | 0.04470603414923805 | Windjet | Q2
Spreadsheet: 686663d1594740528-sumifs-by-month-and-year-sumifs-by-month-and-year
Sheet: Sheet1

EST Close Date | AMOUNT
 | 65162.5 |  |  | 2017 | 2018 | 2019 | 2020
 | 100000 |  | January
 | 100000 |  | February
 | 105000 |  | March
2020-08-30 00:00:00 | 135000 |  | April
2020-07-17 00:00:00 | 174740 |  | May
2017-10-16 00:00:00 | 180000 |  | June
 | 185000 |  | July
 | 191000 |  | August
 | 197395 |  | September
 | 203080 |  | October
2018-07-26 00:00:00 | 205000 |  | November
2019-01-17 00:00:00 | 210680 |  | December
2020-06-08 00:00:00 | 225000
 | 226100
2018-12-18 00:00:00 | 230000
2019-07-22 00:00:00 | 233750
2017-10-17 00:00:00 | 238000
2018-04-09 00:00:00 | 240000
2018-10-23 00:00:00 | 240000
 | 240014
2018-01-26 00:00:00 | 251250
2019-09-23 00:00:00 | 252000
 | 252000
 | 254750
2019-10-31 00:00:00 | 255000
2019-11-06 00:00:00 | 255000
2020-07-17 00:00:00 | 260000
 | 260000
 | 260000
 | 260000
 | 260000
 | 264127.7375
2020-06-01 00:00:00 | 266260.5
2019-08-31 00:00:00 | 272000
2019-04-29 00:00:00 | 273000
 | 273095
 | 275000
2020-07-01 00:00:00 | 277000
 | 279537.5
 | 281801.14
 | 284000
 | 284620
2019-03-22 00:00:00 | 290000
 | 290014
2020-07-17 00:00:00 | 291000
 | 291442.86
 | 291442.86
 | 291442.86
 | 294750
 | 295000
 | 295000
2018-09-10 00:00:00 | 297220
2018-10-30 00:00:00 | 300000
 | 302974.1
 | 304486.875
2020-05-08 00:00:00 | 305500
2019-03-06 00:00:00 | 306000
2018-10-16 00:00:00 | 309765
2017-10-31 00:00:00 | 311250
2020-03-09 00:00:00 | 312085
2018-07-05 00:00:00 | 313625
 | 329000
2020-07-24 00:00:00 | 332000
2018-09-10 00:00:00 | 333000
 | 338000
 | 338318.75
 | 340000
2020-04-21 00:00:00 | 340826
 | 341100
2020-07-06 00:00:00 | 343500
 | 345404
 | 345950
 | 346442.86
 | 349365.62
 | 350000
 | 352939.2075
 | 354642.82
 | 356000
 | 356000
 | 356650
2017-12-26 00:00:00 | 360000
2019-08-26 00:00:00 | 361517
 | 361617.66
 | 362000
 | 363000
 | 364750
 | 364943.04165
2018-01-29 00:00:00 | 365735
 | 367580
 | 368207.8125
 | 368207.8125
 | 370452
2019-03-21 00:00:00 | 378000
2020-07-14 00:00:00 | 380000
 | 380000
 | 383025.76
 | 386270
 | 390000
 | 393000
2020-06-23 00:00:00 | 397000
 | 400000
 | 400000
 | 407000
 | 407000
 | 408405
 | 408405
2018-07-26 00:00:00 | 410125
2020-07-17 00:00:00 | 412000
2018-06-08 00:00:00 | 412153
2018-12-31 00:00:00 | 414950
2019-11-06 00:00:00 | 415850
2019-05-07 00:00:00 | 416100
2020-08-16 00:00:00 | 417000
 | 417000
 | 417000
2019-08-12 00:00:00 | 420000
2019-08-30 00:00:00 | 425000
2020-08-10 00:00:00 | 426000
 | 434551.14
2020-04-27 00:00:00 | 435870
2020-07-17 00:00:00 | 440000
 | 483312.5
 | 495000
 | 495000
2020-04-30 00:00:00 | 501549.34
 | 521000
 | 531000
 | 532174
 | 536000
 | 536000
 | 536000
 | 536000
 | 536000
2020-07-31 00:00:00 | 540000
 | 551900
 | 558352
 | 560000
 | 580000
 | 592250
 | 592250
 | 606550
 | 609900
 | 609900
 | 613679.6875
 | 638226.875
 | 645192
2020-04-23 00:00:00 | 650000
 | 654864.76
2020-04-24 00:00:00 | 667814.76
2020-08-30 00:00:00 | 680000
2020-08-15 00:00:00 | 695382.5
 | 695868.75
2020-04-30 00:00:00 | 742750
Spreadsheet: 169ea132-b149-4612-930a-2bf1af5ce1a0
Sheet: DV-IDENTITY-0

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAAAABHvm0Q=
Spreadsheet: 6a8bbc3e-4ba5-4cd9-b87c-950f85f851c7
Sheet: Certification Codes

Certification Code | Certification Name
[NAME] | Automotive Service Excellence- Medium & Heavy Truck - Diesel
ASET | Automotive Service Excellence – Automotive Service Tech. Level 1
AWS | American Welding Society - 3 Position Qualifications (AWS- 1F, 2F, & 1G)
CDL | Commercial Driver’s License
[NAME] | CISCO- Certified Entry Networking Technician
CISCONA | CISCO – Certified Network Associate
CISCONP | CISCO – Certified Network Professional
CNA | Certified Nurse Aide
COMPTIAA | CompTIA – A+ Certification
COMPTIAN | CompTIA – Network + Certification
HVACER | HVAC Excellence- Employment Ready Certification in one of the following: Light Commercial Air Conditioning; Air Conditioning; Basic Refrigeration & Charging Procedures; Electric, Gas, & Oil Heat; Heat Pump; System Diagnosis & Troubleshooting Procedures; Light Commercial Refrigeration
ICER | Industry Competency Exam – Residential HVAC
ICELC | Industry Competency Exam – Light Commercial HVAC
ICEC | Industry Competency Exam – Commercial HVAC
KDACPA | Kansas Dept. of Agriculture – KS Commercial Pesticide Applicator’s Certificate
KDAASC | Kansas Dept. of Agriculture – Agriculture Skills & Competencies Certificate
MSSCPT | Manufacturing Skills Standards Council- Certified Production Technician
NCCER1 | NCCER Core Certificate AND Electrical Level 1 Certificate
NCCER2 | NCCER Core Certificate AND Construction Laborer Certificate
NCCER3 | NCCER Core Certificate AND Plumbing & Pipefitting Level 1 Certificate
NCCER4 | NCCER Core Certificate AND  Carpentry Level 1
NCCER5 | NCCER Core Certificate AND  Industrial Maintenance Level 1 Certificate
NCCER6 | NCCER Core Certificate AND  Control Center Operations Certificate
NCCER7 | NCCER Core Certificate AND  Sheet Metal Level 1 Certificate
NCCER8 | NCCER Core Certificate AND  Concrete Finishing Certificate
NCCER9 | NCCER Core Certificate AND  Introduction to Masonry Level 1 Certificate
NATEFA | NATEF- 4 Automobile Assessments (Brakes, Electrical/Electronic Systems, Engine Performance, and Suspension & Steering)
NATEFM | NATEF – 4 Medium/Heavy Truck Assessments (Brakes, Electrical/Electronic Systems, Diesel Engines, and Steering & Suspension)
NATEHVAC | North American Technician Excellence – HVAC-R (Core Exam AND Specialty Area Exam)
NIMSMA | National Institute for Metalworking Skills – Machining Level 1
NIMSMF | National Institute for Metalworking Skills – Metal Forming 1
Spreadsheet: 777310d1650315991-conditional-format-a-cell-based-on-values-in-a-dataset-column-and-dates-in-another-column-condformat-example-docgee-
Sheet: Data

Date | Pass or Fail |  | Date | Pass or Fail
2022-01-01 00:00:00 | PASS |  | 2022-01-01 00:00:00 | PASS
2022-01-13 00:00:00 | PASS |  | 2022-01-13 00:00:00 | PASS
2022-02-12 00:00:00 | PASS |  | 2022-02-12 00:00:00 | PASS
2022-02-26 00:00:00 | FAIL |  | 2022-02-26 00:00:00 | FAIL
2022-02-27 00:00:00 | PASS |  | 2022-02-27 00:00:00 | PASS
Spreadsheet: sally_beck__35041__MgmtSum-Q2-0501
Sheet: Expense Weekly Change

PLAN2000
TOT_OPS_EXPENSES | ENRON NORTH AMERICA
2000-06-01 00:00:00 | 2ND QUARTER 2000 EXPENSES-Weekly Change
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
[NAME] | Gas Trading
[NAME] | Power Trading
IR_FX | Financial Drift
ECT_INV_IRFX | Financial Trading
CANADA | Canada Trading
COAL | Coal
WEATHER | GRM -  Weather
SO2 | Emissions
INSURANCE | GRM - New Products
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream
DWNSTRM_IND_ORIG | Industrial Downstream
MDSTRM_IPP_ORIG | Midstream IPP
 | Canada Origination & Finance
MEXICO | Mexico
 | Total Origination
N_BS_DEV | Generation Investments
ASST_ORIG | ENA Upstream Assets
ASST_TRD | ENA Upstream Assets - Trading
 | Total Assets
EQUITY | Principal Investing
PROD_FIN | Energy Capital Services
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group |  |  |  |  |  | Moved Business to Business and Enron Networks Plan & Actual into Group
OF_CHAIR | Office of the Chairman
 | Total Commercial
GROUP | Group
TREASURY_INT | Other Interest Related Charges
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Genco
 | Gas Assets |  |  |  |  |  | Moved Condensate & Gathering income to margin
Spreadsheet: 735203d1622751585-formula-to-convert-range-and-provide-outcome-according-to-2-parameters-formulas
Sheet: Sheet1

 | Range | Score |  | 1) | I'm working on a score system which provide a score number. I need then a formula which convert the number (included in the range provided) in the respective letter
17 | from 17 to 23 | A
23.01 | from 23.01 to 29 | B |  | 25
29.01 | from 29.01 to 35 | C
35.01000000000001 | from 35.01 to 41 | D
41.01000000000001 | from 41.01 to 47 | E
47.01000000000001 | from 47.01 to 53 | F
53.01000000000001 | from 53.01 to 59 | G
59.01000000000001 | from 59.01 to 65 | H
65.01 | from 65.01 to 71 | I
71.01 | from 71.05 to 77 | J
77.01 | from 77.01 to 83 | K
83.01 | from 83.01 to 89 | L
89.01 | from 89.01 to 95 | M
95.01 | from 95.01 to 101 | N
101.01 | from 101.1 to 104 | O
 |  |  |  | 2) | Once the above formula is created, I need then a formula which assign to the letter the correspdondent settlment and collateral result (e.g. H will give the outcome 7 days and 10%)
Settltement | day after | A | B | C | D | E
 | 7 days | F | G | H | I | J
 | 30 days | K | L | M | N | O
 |  | 0 | 0.05 | 0.1 | 0.15 | 0.2
 |  | Collateral
Spreadsheet: 111911d1308154925-conditional-formatting-for-currency-symbols-and-cell-color-test
Sheet: Sheet2

Count of Actual Cost
program | currency | Target Cost | Actual Cost | Total
1 | [NAME] | 1040 | 1028 | 1
2 | Euro | 0 | 268.82 | 1
3 | [NAME] | 1196 | 1144 | 1
4 | Euro | 489 | 465 | 1
5 | Euro | 5498 | 6146 | 1
6 | [NAME] | 1503 | 1503 | 1
7 | [NAME] | 3155 | 3103 | 1
8 | [NAME] | 1377 | 1382 | 1
9 | [NAME] | 1897 | 1897 | 1
10 | Euro | 17595 | 17595 | 1
11 | Euro | 0 | 0 | 1
12 | (blank) | 0 | 0 | 1
13 | (blank) | 8000 | 6349 | 1
14 | (blank) | 491811 | 488040 | 1
15 | (blank) | 423799 | 421581 | 1
16 | (blank) | 349432 | 346591 | 1
17 | (blank) | 637594 | 647905 | 1
18 | (blank) | 6600 | 6812 | 1
19 | (blank) | 864418 | 1001244 | 1
20 | (blank) | 8181 | 8513 | 1
21 | (blank) | 0 | 0 | 1
22 | (blank) | 0 | 0 | 1
23 | (blank) | 0 | 0 | 1
24 | (blank) | 0 | 0 | 1
25 | (blank) | 7527 | 7434 | 1
26 | (blank) | 7587 | 7796 | 1
27 | (blank) | 11770 | 11875 | 1
28 | (blank) | 2470 | 2436 | 1
29 | (blank) | 4800 | 4517 | 1
30 | (blank) | 11005 | 7760 | 1
31 | (blank) | 0 | 0 | 1
32 | (blank) | 4549 | 4549 | 1
33 | (blank) | 0 | 0 | 1
34 | (blank) | 0 | 0 | 1
35 | (blank) | 0 | 0 | 1
36 | (blank) | 0 | 0 | 1
37 | (blank) | 0 | 0 | 1
(blank) | (blank) | (blank) | (blank)
Grand Total |  |  |  | 37
Spreadsheet: 68892d1269436475-excel-2007-index-and-match-question-lookup-sample-data
Sheet: Transfer

GuestLink | Asset Type Name | Asset Date | Itinerary Date Time | Itinerary Date Time To | Hotel Name
3579 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
3579 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
3579 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
3579 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
3582 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
3582 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
4290 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
4290 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12814 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12814 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12815 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12815 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12818 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
12818 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12818 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12818 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12886 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
12886 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12886 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12886 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12887 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
12887 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12887 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12887 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12888 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
12889 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
Spreadsheet: 150133d1334308169-excel-2007-populating-data-from-one-sheet-to-another-sheet-automatically-testing2
Sheet: Sheet A

Project | Country | Sector | Status
PA | England | FS | Won |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Won
PB | France | AG | WIP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIP
PC | UK | FS | Lost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lost
PD | China | RS | WIP
Spreadsheet: 219692d1362884511-sumifs-with-multiple-lookups-with-multiple-results-to-lookup-other-values-testmodel3
Sheet: Modifications

 | Mod1 | Mod2 | Mod3 | Mod4
Comp1 | 1 |  | 3 | 4
Comp2 | 4 |  | 2
[NAME] | 8 | 7 | 6 | 5
Comp4 |  | 6 | 7 | 8
Comp5 | 5 | 5
Amounts
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: DEN-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 | 10284481 | 21749004
2 |  | Liquidations
3 |  | Interdesk | 0 | 0
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 10284481 | 21749004
 | Purchases:
6 |  | 3rd Party / Inter Enron | -10208981 | -21377603
7 |  | Liquidations
8 |  | Interdesk | 0 | 0
9 |  | Option Premiums
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -10208981 | -21377603
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | -75500 | -153815.9393118396
23 | Fuel: |  | 0 | 0
 | Transport Expense:
24 |  | Commodity | 0 | -50088
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -50088
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 0.03999999980442226
31 |  | Prior Month Book Balance | 0 | 5694
 |  | Total MTM Income | 0 | 5694.039999999804
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -150000
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
FT-West
 |  | Current Month MTM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 842568d1694608941-dynamic-alphabetization-of-names-in-table-not-keeping-row-data-attached-example-book
Sheet: Example

Table 1 |  |  |  | Table 2
Name | Date | Other |  | Name | Position | Other
[NAME] | 2023-09-12 00:00:00 |  |  |  | Sales
[NAME] | 2023-09-12 00:00:00 |  |  |  | Sales
[NAME] | 2023-09-12 00:00:00 |  |  |  | Manager
[NAME] | 2023-09-12 00:00:00 |  |  |  | Accounting
 |  |  |  |  |  |  |  | This is how I would like the Table 2 - Future to look
Table 1 - Future |  |  |  | Table 2 - Future
Name | Date | Other |  | Name | Position | Other |  | Name | Position | Other
[NAME] | 2023-09-13 00:00:00 |  |  |  |  |  |  |  | Sales
[NAME] | 2023-09-13 00:00:00
[NAME] | 2023-09-13 00:00:00 |  |  |  |  |  |  |  | Sales
[NAME] | 2023-09-13 00:00:00 |  |  |  |  |  |  |  | Manager
Dwight | 2023-09-13 00:00:00 |  |  |  |  |  |  |  | Accounting
Spreadsheet: 117178d1312484990-differences-in-formula-vs-calculator-forexcelforum
Sheet: Sheet1

Weight of 20 FP | 2.715
 | [NAME] | Burns, DDU | Cedar Point, DDU | Florence DDU | Peabody DDU | Peabody R001 | Peabody R002 | Marion DDU | Marion R001 | Marion R002 | [NAME] | Durham, DDU | Tampa, DDU | [NAME] | Canton R001 | [NAME] | Lehigh | Lincolnville | Lost Springs | Ramona | Burdick | Hillsboro Carriers | Hillsboro Rt 1 & 3 | [NAME] | Newton R002
[NAME] | Pieceweight | 306 | 111 | 283 | 431 | 110 | 180 | 747 | 248 | 201 | 254 | 134 | 153 | 100 | 315 | 150 | 133 | 198 | 83 | 95 | 83 | 1025 | 205 | 313 | 354
Free Press Issue
Vogt's | 0.045 | 0 | 0 | 0 | 0 | 0
Peabody Market | 0.0475 |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dale's Supermarket | 0.061 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  |  | 0
Carlson's | 0.0465 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0
Menard's 4 pg | 0.014 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  | 0
Alco | 0.0455 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 |  |  |  | 0 |  |  |  | 0
Lumberyard | 0
Hesston Food Market | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Buyer's Edge | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Menard's 4 pg | 0.0835 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Piece weight
 |  |  |  |  |  | This is the answer I'm getting
 |  |  |  |  |  | This is the answer I think I should be getting
 |  |  |  |  |  | F26 and F28 should contain identical results, but they don't
Spreadsheet: 697545d1601398387-need-help-with-regression-analysis-sampledata_regression
Sheet: Lookup

Crime | Crime_Code | State | State_Code
[NAME] | 1 | CA | 1
Assault | 2 | FL | 2
Homicide | 3 | TX | 3
Kidnapping | 4
Robbery | 5
Theft | 6