tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__35045__Open_Issues
Sheet: Upstream Changes

2000-04-26 00:00:00
Changes required by upstream process for SAP Interfacing
FIN | GAS | PWR
 |  |  | Remit to Address types – check or wire
 |  |  |  |  GBL_Address_Num is populated within the Address table
 |  |  |  |  Internal_Entity_Id is populated within the Address table
 |  |  |  |  SAP_Id is populated within the Address table
 |  |  | [NAME] to Address types– check (we should not have bill to a wire location)
 |  |  |  |  GBL_Address_Num is populated within the Address table
 |  |  |  |  Internal_Entity_Id is populated within the Address table
 |  |  | Wires – payment methods (PM Address role)
 |  |  |  |  Wire_Method_Id is populated within the Address table for statements identified within Unify as wires.
 |  |  |  |  GBL_SAP_Bank_Acct_Id is populated within the Address table for Service Verifications and Supply Verifications identified within Unify as wires.
 |  |  |  |  Wire_ABA_Number is populated within the Address table for statements identified as wires.
 |  |  |  |  Wire_Account_Number is populated within the Address table for statements identified as wires.
 |  |  | Desk Id / Book code information
 |  |  |  |  Power – That a Desk Company Id exists for each line item
 |  |  |  |  Gas – That a Desk Id exists for each line item
 |  |  |  |  Financial – That a book code & desk id exists for the line item.
 |  |  | Statement Final Process – GL Account Updates in Acct Trans table
 |  |  |  | Statement Final Process
 |  |  |  | Changes are needed to the statement final process that when inserted into the Accounting_Transaction table,
 |  |  |  | 1) to derive the counterparty status from SAP_Intco_Matrix.  Ie 3rd party, Intercompany, [NAME], and populate the GL Account Number as such.
 |  |  |  | The field selected is derived from the GL_Account_Reference, based on
 |  |  |  | 3rd party | GL_Account_Number
 |  |  |  | InterCompany | GL_Intco_Account_Num
 |  |  |  | [NAME] | GL_Non_SAP_Account_Num
 |  |  | Accrual Process
 |  |  |  | Changes added to front end DRAFT accrual to stop the accrual if any ‘lessor of’ transactions are encountered.
 |  |  |  | This will have to be identified based on Transaction_Type_Id hardcoded for Gas/ Pwr.
 |  |  |  | A message will have to be raised in the messagebox informing of a lessor identified.  The user will then have to reselect the gl account on the statement and
 |  |  |  | redraft before accrual can start again.
 |  |  | Statement Final Process/ Accrual Process – Validation for different country codes
 |  |  |  | Statement Final Process/ Accrual Process – Validation for different country codes
 |  |  |  | Ensure that the statement does not have multiple country codes, based on the PL_Pt.  SAP cannot handle this.
 |  |  |  | The user will have to create a new statement.
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: ESS

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
ESSENTIA WATER 12/1.5L | 09556 |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  | 2023-09-27 00:00:00 | 297478 | ESSENTIA WATER 12/1.5L | 09556 | 10 | ** Lowering level back to 30 days
ESSENTIA WATER 12/1L | 09555 |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  | ESSENTIA WATER 12/1L | 09555 | 9
ESSENTIA WATER 24/20Z PET | 09553 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 2023-09-27 00:00:00 | 297479 | ESSENTIA WATER 24/20Z PET | 09553 | 2
ESSENTIA WATER 24/700ML | 09554 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ESSENTIA WATER 12/1L | 09555 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ESSENTIA WATER 24/700ML | 09554 | 3 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-10 00:00:00 | 297484 | ESSENTIA WATER 12/1L | 09555 | 20
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
ESSENTIA WATER 12/1.5L | 09556 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-10 00:00:00 | 297485 | ESSENTIA WATER 12/1L | 09555 | 20
ESSENTIA WATER 12/1L | 09555
ESSENTIA WATER 24/20Z PET | 09553 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-10 00:00:00 | 297486 | ESSENTIA WATER 12/1.5L | 09556 | 15
ESSENTIA WATER 24/700ML | 09554 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ESSENTIA WATER 24/20Z PET | 09553 | 4
Spreadsheet: 861140d1709110632-data-validation-with-conditional-list-by-input-formula-data-validation-with-conditional-list
Sheet: Sheet1

 |  |  |  |  |  | Table |  |  |  | Filtered List
 | List refer to filtered table | Model | Color | Location |  | Model | Color | Location |  | No | Model |  | No | Color |  | No | Location
 |  | A | Orange | #2 Lot2 |  | A | Black | #5 Lot Z1
 |  |  |  |  |  | A | BLUE | #0 Lot1 |  |  | B |  |  | BLUE |  |  | #3 Lot3
 |  |  |  |  |  | A | BLUE | #2 Lot2 |  |  |  |  |  | Orange
 |  |  |  |  |  | A | BLUE | #3 Lot3 |  |  |  |  |  | RED
 |  |  |  |  |  | A | BLUE | #4 Lot D1 |  |  |  |  |  | White
 | List by formula if don't want create additional table list (error) | Model | Color | Location |  | A | Orange | #2 Lot2 |  |  |  |  |  | Yellow
 |  | A |  |  |  | A | Orange | #3 Lot3
 |  |  |  |  |  | A | RED | #0 Lot1
 |  |  |  |  |  | A | RED | #2 Lot2
 |  |  |  |  |  | A | RED | #3 Lot3
 |  |  |  |  |  | A | RED | #4 Lot D1
 |  |  |  |  |  | A | White | #4 Lot D1
 |  |  |  |  |  | A | White | #5 Lot Z1
 |  |  |  |  |  | A | Yellow | #2 Lot2
 |  |  |  |  |  | A | Yellow | #3 Lot3
 |  |  |  |  |  | B | Green | #0 Lot1
 |  |  |  |  |  | B | Green | #1 Lot 1A
 |  |  |  |  |  | B | Green | #2 Lot2
 |  |  |  |  |  | B | Green | #3 Lot3
 |  |  |  |  |  | B | Yellow | #0 Lot1
 |  |  |  |  |  | B | Yellow | #1 Lot 1A
 |  |  |  |  |  | B | Yellow | #2 Lot2
 |  |  |  |  |  | B | Yellow | #3 Lot3
Spreadsheet: 870379d1716907124-modifying-table-to-be-more-dynamic-book2-2-
Sheet: Haldusaruanne

FinSummaHaldus |  |  |  |  |  |  |  |  | Kulukoht
Code |  |  | [NAME] |  | Client | Year |  |  | 5300 [NAME] otsused ja kohustused | 5340 Üür | 5312 [NAME] intressid | 5352 Kapiralirendi põhiosa maksed | 5353 Remondifondi laekumine
SEEMNE200 |  |  | 70000869 |  | Client1 | 2024 |  |  | 1000 | 1000 | 1000 | 1000 | 5000
SEEMNE200 |  |  | 70000869 |  | Client1 | 2025 |  |  | 1000 | 1000 | 1000 | 1000 | 5000
SEEMNE200 |  |  | 70000869 |  | Client1 | 2026 |  |  | 1000 | 1000 | 1000 | 1000 | 5000
SEEMNE200 |  |  | 70000869 |  | Client1 | 2027 |  |  | 1000 | 1000 | 1000 | 1000 | 5000
SEEMNE200 |  |  | 70000869 |  | Client1 | 2028 |  |  | 1000 | 1000 | 1000 | 1000 | 5000
PURAVIKU4 |  |  | 70000869 |  | Client2 | 2024 |  |  | 1000 | 1000 | 1000 | 1000 | 5000
PURAVIKU4 |  |  | 70000869 |  | Client2 | 2025 |  |  | 1000 | 1000 | 1000 | 1000 | 5000
PURAVIKU4 |  |  | 70000869 |  | Client2 | 2026 |  |  | 1000 | 1000 | 1000 | 1000 | 5000
PURAVIKU4 |  |  | 70000869 |  | Client2 | 2027 |  |  | 1000 | 1000 | 1000 | 1000 | 5000
PURAVIKU4 |  |  | 70000869 |  | Client2 | 2028 |  |  | 1000 | 1000 | 1000 | 1000 | 5000
Spreadsheet: 93634d1293286784-weighing-point-clusters-weighing-clusters
Sheet: Sheet1

 |  |  |  | CLUSTER SIZE | 3
WEIGHTS |  |  | POINTS | NUMBER OF POINTS IN ONE CLUSTER
0.1 |  |  | 33 | 2
0.41 |  |  | 47 | 2
0.29 |  |  | 15 | 2
0.04 |  |  | 27 | 3
0.46 |  |  | 21 | 4 |  | POINTS IN CLUSTER | WEIGHT OF EACH
0.79 |  |  | 20 | 3 |  | 21 | 0.46
0.81 |  |  | 98 | 4 |  | 20 | 0.79
0.33 |  |  | 23 | 2 |  | 23 | 0.33
0.82 |  |  | 83 | 1 |  | 20 | 0.05
0.62 |  |  | 74 | 1 |  | AVERAGE WEIGHT | 0.4075
0.53 |  |  | 97 | 4 |  | CUMULATIVE WEIGHT | 1.63
1 |  |  | 99 | 3 |  | STDEV | 0.3070694818223828
0.23 |  |  | 96 | 4
0.24 |  |  | 33 | 2
0.03 |  |  | 49 | 2
0.15 |  |  | 38 | 1
0.84 |  |  | 9 | 1
0.96 |  |  | 77 | 2
0.88 |  |  | 41 | 1
0.83 |  |  | 27 | 3
0.01 |  |  | 94 | 3
0.74 |  |  | 26 | 3
0.15 |  |  | 91 | 2
0.41 |  |  | 92 | 3
0.05 |  |  | 20 | 3
0.47 |  |  | 15 | 2
0.28 |  |  | 77 | 2
0.43 |  |  | 55 | 1
0.86 |  |  | 44 | 1
0.86 |  |  | 80 | 1
Spreadsheet: 678228d1589789360-dynamic-reporting-possible-pivot-table-with-multiple-columns-on-one-sheet-to-source-from-pivottest
Sheet: Sheet3

Agency name | Organisation Type | Progress
GIVEONE | PRIVATE | FINISHED
GIVETWO | PRIVATE | FINISHED
GIVEONE | PRIVATE | STARTUP
GIVETWO | PRIVATE | STALLED
ONETAKE | GOVERNMENT | ONGOING
TWOTAKE | GOVERNMENT | ONGOING
Spreadsheet: eric_saibi__9810__092101R
Sheet: Sooner 01

Owner Name |  | OG&E Electric Service
Station Name |  | Sooner Power Station
Unit Name |  | Sooner 01
NERC Region |  | SPP
State |  | OK
Fuel Type |  | Coal
Capacity |  | 568 MW
Start Date |  | 2001-10-08 00:00:00
End Date |  | 2001-12-02 00:00:00
Prv. Start Date |  | 2001-09-21 00:00:00
Prv. End Date |  | 2001-11-15 00:00:00
Comments |  | Turb O/H--Didn't have enough man power to do the work now
SIC |  | 4911
Plant ID |  | 1013000
Unit ID |  | 1006549
Outage ID |  | 12579
Spreadsheet: 675146d1588175947-i-need-some-help-with-an-index-and-match-function-tracker-excel-blank
Sheet: Sheet 1

 |  |  | Date
 |  |  |  |  |  |  | 2020-04-20 00:00:00 | 2020-04-21 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-04-24 00:00:00 | 2020-04-25 00:00:00 | 2020-04-26 00:00:00 | 2020-04-27 00:00:00 | 2020-04-28 00:00:00 | 2020-04-29 00:00:00 | 2020-04-30 00:00:00 | 2020-05-01 00:00:00 | 2020-05-02 00:00:00 | 2020-05-03 00:00:00 | 2020-05-04 00:00:00 | 2020-05-05 00:00:00 | 2020-05-06 00:00:00 | 2020-05-07 00:00:00 | 2020-05-08 00:00:00 | 2020-05-09 00:00:00 | 2020-05-10 00:00:00 | 2020-05-11 00:00:00 | 2020-05-12 00:00:00 | 2020-05-13 00:00:00 | 2020-05-14 00:00:00 | 2020-05-15 00:00:00 | 2020-05-16 00:00:00 | 2020-05-17 00:00:00 | 2020-05-18 00:00:00 | 2020-05-19 00:00:00 | 2020-05-20 00:00:00 | 2020-05-21 00:00:00 | 2020-05-22 00:00:00 | 2020-05-23 00:00:00 | 2020-05-24 00:00:00 | 2020-05-25 00:00:00 | 2020-05-26 00:00:00 | 2020-05-27 00:00:00 | 2020-05-28 00:00:00 | 2020-05-29 00:00:00 | 2020-05-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | 2020-07-11 00:00:00 | 2020-07-12 00:00:00
Project ID | Project Name | Project Size | Start Date | End Date |  | Allocation
123456 | Test 1 | S | 2020-04-01 00:00:00 | 2020-06-30 00:00:00
Stage 1 |  | S | 2020-04-27 00:00:00 | 2020-05-02 00:00:00
Stage 2 |  | S | 2020-05-05 00:00:00 | 2020-05-17 00:00:00
Stage 3 |  | S | 2020-05-18 00:00:00 | 2020-05-20 00:00:00
Stage 4 |  | S | 2020-05-21 00:00:00 | 2020-05-22 00:00:00
Stage 5 |  | S | 2020-05-24 00:00:00 | 2020-05-30 00:00:00
234567 | Test 2 | M | 2020-04-21 00:00:00 | 2020-05-21 00:00:00
Stage 1 |  | M | 2020-04-23 00:00:00 | 2020-04-24 00:00:00
Stage 2 |  | M | 2020-04-26 00:00:00 | 2020-04-27 00:00:00
Stage 3 |  | M | 2020-04-28 00:00:00 | 2020-05-03 00:00:00
Stage 4 |  | M | 2020-05-04 00:00:00 | 2020-05-14 00:00:00
Stage 5 |  | M | 2020-05-14 00:00:00 | 2020-05-21 00:00:00
Spreadsheet: 126268d1319608243-automated-list-of-discrepancies-in-columns-and-arrays-separate-sheets-listsampleamended
Sheet: Target

ID | State | Actual Account?
99827 | PA
99828 | PA
99829 | PA
99830 | PA
99831 | PA
99832 | PA
99833 | PA
99834 | PA
99835 | PA
99836 | PA
99837 | PA
99838 | PA
99839 | PA
99840 | PA
99841 | PA
99842 | PA
99860 | PA
99861 | PA
99871 | PA
47443 | NY
47444 | NY
47445 | NY
47448 | NY
47459 | NY
47480 | NY
47501 | NY
47502 | NY
Spreadsheet: 677508d1589378151-send-a-sheet-by-mail-with-formulas-without-loose-the-values-total-file
Sheet: Folha 2

 |  |  |  |  |  |  |  |  |  | DAY | YEAR
 |  |  |  |  |  |  |  |  | A | 4 | 20
 |  |  |  |  |  |  |  |  | B | 8 | 16
 |  |  |  |  |  |  |  |  | C | 9 | 54
 |  |  |  |  |  |  |  |  | D | 12 | 47
 |  |  |  |  |  |  |  |  | E | 21 | 48
 |  |  |  |  |  |  |  |  | F | 24 | 105
Spreadsheet: 877683d1724491898-conditional-formatting-northernrunner-cf-365-aligw-tms-v3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43
 |  |  | 1, 11, 21, 31, 41, 51
 |  |  | 2, 12, 22, 32, 42, 52 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 3, 13, 23, 33, 43 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | True
 |  |  | 4, 14, 24, 34, 44 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 5, 15, 25, 35, 45 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 6, 16, 26, 36, 46 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 7, 17, 27, 37, 47 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 8, 18, 28, 38, 48 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 9, 19, 29, 39, 49 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 10, 20, 30, 40, 50 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
Spreadsheet: 722788d1615405253-how-to-return-multiple-column-headers-based-on-a-difference-book1
Sheet: Week 2

 | Balance Of Remuneration | [NAME] | [NAME] | Net Pay | q | Overtime 1.5 | Overtime 2.0 | Pay as you [NAME] | Salary Cost | [NAME] | Skills Development Levy | r | Sunday Wage | Sundry Deduction | Total Company Contributions | Total Deductions | Total Earnings | Unemployment Insurance Fund | Unemployment Insurance Fund | Wage Hourly
 | Totals | Earning | Deduction | Totals | Deduction | Earning | Earning | Deduction | Totals | Earning | Company Contribution | Deduction | Earning | Deduction | Totals | Totals | Totals | Company Contribution | Deduction | Earning
Number 1 | 2445 | 0 | 0 | 2268.1 | 0 | 787.5 | 0 | 152.45 | 2493.9 | 0 | 24.45 | 0 | 517.5 | 0 | 48.9 | 176.9 | 2445 | 24.45 | 24.45 | 1140
Spreadsheet: 219127d1362672012-help-with-a-formula-function-if-its-possible-admit-dc-2013
Sheet: 5

Admission and Discharges
2013
Date: | 2013-01-05 00:00:00
ADMISSIONS |  |  |  |  |  |  | DISCHARGES
Room # | Name | Time | From | Status | Telemetry Box # |  | Room # | Name | Time | To
317 | z | 03:10:00 | ED |  |  |  | 327 | a | 13:45:00
335 | x | 04:45:00 | ED |  |  |  | 309 | s | 14:10:00
210 | y | 11:50:00 | DA |  |  |  | 315 | d | 16:05:00
336 | b | 10:20:00 | ED |  |  |  | 214 | f | 15:45:00
IC03 | a | 10:40:00 | ED |  |  |  | 326 | g | 17:35:00
306 | c | 14:00:00 | ED |  |  |  | 216 | h | 16:35:00
 |  |  |  |  |  |  | 331 | j | 17:10:00
 |  |  |  |  |  |  | 201 | k | 19:30:00
 | How many admits: 0001-0200: | 0 | How many  From ED | How many inpt | Total # Admits |  |  | How many admits: 0001-0200: | 0 | Total #  Discharges
 | How many admits: 0201-0400: | 1 | 5 | 0 | 6 |  |  | How many admits: 0201-0400: | 0 | 8
 | How many admits: 0401-0600: | 1 | How many  From CDU | How many obs |  |  |  | How many admits: 0401-0600: | 0
 | How many admits: 0601-0800: | 0 | 0 | 0 |  |  |  | How many admits: 0601-0800: | 0
 | How many admits: 0801-1000: | 0 | How many from ASU |  |  |  |  | How many admits: 0801-1000: | 0
 | How many admits: 1001-1200: | 3 | 0 |  |  |  |  | How many admits: 1001-1200: | 0
 | How many admits: 1201-1400: | 1 | How many from OR |  |  |  |  | How many admits: 1201-1400: | 1
 | How many admits: 1401-1600: | 0 | 0 |  |  |  |  | How many admits: 1401-1600: | 2
 | How many admits: 1601-1800: | 0 | How many from CV |  |  |  |  | How many admits: 1601-1800: | 4
 | How many admits: 1801-2000: | 0 | 0 |  |  |  |  | How many admits: 1801-2000: | 1
 | How many admits: 2001-2200: | 0 | How many DA |  |  |  |  | How many admits: 2001-2200: | 0
 | How many admits: 2201-2400: | 0 | 1 |  |  |  |  | How many admits: 2201-2400: | 0
ROOM TRANSFERS |  |  |  |  |  |  | TELEMETRY - ON / OFF
Room # | Name | To Room # |  |  |  |  | Room# | Name | On/Off | Box #
 | Maloney
Spreadsheet: 684961d1593630890-separate-time-hrs-min-sec-to-other-columns-time-separation
Sheet: Table 1 (2)

Time | Hours | Minutes | Seconds
00:17:10
00:17:11
00:14:13
2 days, 0:06:01
1 day, 14:45:45
22:02:16
13:28:46
02:22:48
1 day, 13:17:32
2 days, 14:56:34
2 days, 8:43:52
3 days, 7:59:01
1 day, 15:49:40
2 days, 6:46:48
1 day, 13:23:34
2 days, 7:50:02
2 days, 8:21:23
1 day, 20:20:20
1 day, 5:45:54
1 day, 20:44:26
2 days, 5:15:31
12:56:49
1 day, 7:32:13
08:38:54
2 days, 4:54:29
1 day, 6:48:39
14:38:59
Spreadsheet: 191311d1352059223-filtering-values-based-on-multiple-oring-criteria-without-using-pivot-test-project
Sheet: Test

Id | Owner | Stage | Increemental | Stale | Amount
1 | ABC | Open | Y | N | 5000
2 | ABC | Closed | Y | N | 5001
3 | ABC | Rejected | N | Y | 5002
4 | ABC | Assigned | N | N | 5003
5 | DEF | Closed | Y | Y | 5004
6 | DEF | Open | N | N | 5005
7 | DEF | Closed | N | N | 5006
8 | DEF | Rejected | Y | Y | 5007
9 | DEF | Assigned | Y | N | 5008
10 | GHI | Closed | Y | N | 5009
11 | GHI | Open | N | Y | 5010
12 | GHI | Closed | N | N | 5011
13 | GHI | Rejected | Y | Y | 5012
14 | GHI | Assigned | Y | N | 5013
Required Output - Just mentioning the Stages and the Owner should produce the below output
For Stages | Open
 | Rejected
 | Assigned
Owner | Total No. | No. Of Stale | Sum of Increemental Amount
ABC | 3 | 1 | 5000
DEF | 3 | 1 | 10015
GHI | 3 | 2 | 10025
Spreadsheet: 486656d1477596730-need-to-call-up-info-maybe-a-vlookup-question-i-dont-know-testing
Sheet: Facebook

LASTNAME, FIRST |  |  |  | LASTNAME, FIRST |  |  |  | LASTNAME, FIRST
EMPLOYEE # |  |  |  | EMPLOYEE # |  |  |  | EMPLOYEE #
DEPT | HIRE DATE |  |  | DEPT | HIRE DATE |  |  | DEPT | HIRE DATE
LASTNAME, FIRST |  |  |  | LASTNAME, FIRST |  |  |  | LASTNAME, FIRST
EMPLOYEE # |  |  |  | EMPLOYEE # |  |  |  | EMPLOYEE #
DEPT | HIRE DATE |  |  | DEPT | HIRE DATE |  |  | DEPT | HIRE DATE
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 2

 | Jan 25 |  | Feb 1 |  | Feb 8 |  | Feb 15
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | 388372022 | 388372022 | 395042431 | 395042431 | 391358938 | 391358938 | 390901605 | 390901605
SD/MSPs | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 16743138 | 16743138 | 16797419 | 16797419 | 16700745 | 16700745 | 16665001 | 16665001
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 20848248 | 20848248 | 21093582 | 21093582 | 20943010 | 20943010 | 21204976 | 21204976
Dealers** | 17607027 | 17604488 | 17811411 | 17815529 | 17717132 | 17714119 | 17965251 | 17951102
Buyside | 3241221 | 3243760 | 3282172 | 3278054 | 3225878 | 3228891 | 3239725 | 3253873
Total Equity | 5246549 | 5246549 | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type 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: 218229d1362406096-formula-to-pull-data-from-left-column-next-to-the-1st-blank-cell-in-the-right-column-excel-formula
Sheet: Sheet1

# | Starting OPH:  OPH | Actual  OPH
0 | 28000 | Done During Previous Contract
1 |  | Billable to the Customer
 | SP30K | x
 |  | 33119
 |  | Not on Inv
 |  | 37018
 | [NAME]
 | SP50K
Spreadsheet: 704227d1605454588-getting-the-average-net-sales-based-on-the-day-employee-schedule-copy
Sheet: DATA

 | Yearly Net Sales:
 | Yearly Orders:
 |  |  | [NAME]. Sales By Hour/Orders
 |  |  | Hour 1 (7-8) | Orders | Hour 2 (8-9) | Orders
 | [NAME]. Monday Net Sales:
 | [NAME]. Tuesday Net Sales:
 | [NAME]. Wednesday Net Sales:
 | [NAME]. Thursday Net Sales:
 | [NAME]. Friday Net Sales:
 | [NAME]. Saturday Net Sales:
 | [NAME]. Sunday Net Sales:
 |  | Average:
 | Date | Day | Hour 1 (7-8) | Orders | Hour 2 (8-9) | Orders | Total Net Sales | Total Orders
 | 2020-01-01 00:00:00 | Wednesday | 39.51 | 5 | 40.11 | 6 | 10
 | 2020-01-02 00:00:00 | Thursday | 39.51 | 5 | 40.11 | 6
 | 2020-01-03 00:00:00 | Friday | 30.98 | 5 | 99.96 | 13
 | 2020-01-04 00:00:00 | Saturday | 39.51 | 5 | 40.11 | 6
 | 2020-01-05 00:00:00 | Sunday | 25 | 5 | 40.11 | 6
 | 2020-01-06 00:00:00 | Monday | 35.03 | 5 | 65.75 | 8
 | 2020-01-07 00:00:00 | Tuesday | 22.74 | 3 | 47.72 | 8
 | 2020-01-08 00:00:00 | Wednesday | 58.01 | 6 | 114 | 12 | 10
 | 2020-01-09 00:00:00 | Thursday | 78.74 | 10 | 57.57 | 8
 | 2020-01-10 00:00:00 | Friday | 37.89 | 6 | 158.85 | 18
 | 2020-01-11 00:00:00 | Saturday | 39.51 | 5 | 40.11 | 6
 | 2020-01-12 00:00:00 | Sunday | 25 | 5 | 40.11 | 6
 | 2020-01-13 00:00:00 | Monday | 55.88 | 8 | 64.47 | 8
 | 2020-01-14 00:00:00 | Tuesday | 41.32 | 5 | 99.4 | 12
 | 2020-01-15 00:00:00 | Wednesday | 39.51 | 5 | 40.11 | 6 | 10
Spreadsheet: 706057d1606437989-match-2-criteria-and-display-value-from-another-cell-match-example
Sheet: Sheet1

Selected Line | Order | Standard Text Key | Work center | Activity | Operation short text
 | 40023710 |  | HCBPT | 0030 | Slurry blast trunnion
 | 40023710 |  | HCBPT | 0050 | Clean & preserve original Trunion footpr
 | 40023710 |  | HCBPT | 0065 | Apply preservation to trunnion - STOPAQ
 | 40023711 |  | HCBPT | 0030 | Slurry blast trunnion
 | 40023711 |  | HCBPT | 0050 | Clean & preserve original Trunion footpr |  |  |  | Match from D | Match from  B | Display
 | 40023711 |  | HCBPT | 0065 | Apply preservation to trunnion - STOPAQ |  |  |  | HCBPT | 40023710 | (should show value in F2)
 | 40023710 |  | HCPF | 0020 | Cold cut Trunnion |  |  |  | HCPF | 40023710 | (should show value in F8)
 | 40023710 |  | HCPF | 0060 | Install New Clamped support |  |  |  | HCSC | 40023710 | (should show value in F21)
 | 40023711 |  | HCPF | 0020 | Cold cut Trunnion
 | 40023711 |  | HCPF | 0060 | Install New Clamped support
 | 40023712 |  | HCPF | 0020 | Cold cut Trunnion
 | 40023712 |  | HCPF | 0060 | Install New Clamped support
 | 40027627 |  | HCPF | 0020 | IRATA [NAME] Holt Bolt Change Out
 | 40021843 |  | HCSC | 0020 | Build access scaffold WO#23204553
 | 40021843 |  | HCSC | 0050 | Destruct scaffold
 | 40022104 |  | HCSC | 0010 | Scaffold CISCC bolts H8D-N102185-D-003
 | 40022104 |  | HCSC | 0020 | Dismantle Scaff Well bay area upper mezz
 | 40023283 |  | HCSC | 0020 | Build access scaffold WO#23204554
 | 40023283 |  | HCSC | 0040 | Destruct scaffold
 | 40023710 |  | HCSC | 0010 | Temporary support Pipe
 | 40023710 |  | HCSC | 0070 | Destruct scaffold support
 | 40023711 |  | HCSC | 0010 | Temporary support Pipe