tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 275437d1383514000-sum-cells-based-on-current-month-report-template
Sheet: CPs D W MTD YTD LTD

 | CP Sales
 | Daily |  | Promotion | Transaction Count
 | RESIDENTIAL |  | BUY ONE GET ONE CHANNEL PACK | 2
 | RESIDENTIAL |  | COMP FREE CHANNEL PACK - IGLOO | 1
 | RESIDENTIAL |  | HALF PRICE CHANNEL PACK | 1
 | RESIDENTIAL |  | NOT APPLICABLE | 81
 | RESIDENTIAL |  | [NAME] | 72
 | SLINGSHOT |  | SLINGSHOT REGISTRATION OFFER | 35
 | ZERO $ STB |  | ZERO $ STB REGISTRATION 12 | 5
 |  |  | Sum: | 197
 | Weekly |  | Promotion | Transaction Count
 | RESIDENTIAL |  | BUY ONE GET ONE CHANNEL PACK | 7
 | RESIDENTIAL |  | COMP FREE CHANNEL PACK - IGLOO | 8
 | RESIDENTIAL |  | HALF PRICE CHANNEL PACK | 20
 | RESIDENTIAL |  | NOT APPLICABLE | 555
 | RESIDENTIAL |  | [NAME] | 515
 | SLINGSHOT |  | SLINGSHOT REGISTRATION OFFER | 454
 | ZERO $ STB |  | ZERO $ STB REGISTRATION 12 | 37
 | MTD | Promotion |  | Transaction Count
 | RESIDENTIAL | BUY ONE GET ONE CHANNEL PACK |  | 10
 | RESIDENTIAL | COMP HALF PRICE CHANNEL PACK-IGLOO |  | 2
 | RESIDENTIAL | HALF PRICE CHANNEL PACK |  | 30
 | RESIDENTIAL | NOT APPLICABLE |  | 1812
 | SLINGSHOT | SLINGSHOT REGISTRATION OFFER |  | 1419
 | ZERO $ STB | ZERO $ STB REGISTRATION 12 |  | 107
 |  | Sum: |  | 3380
 | YTD |  | Promotion | Transaction Count
 | RESIDENTIAL |  | BUY ONE GET ONE CHANNEL PACK | 10
 | RESIDENTIAL |  | COMP FREE CHANNEL PACK - IGLOO | 180
 | RESIDENTIAL |  | COMP HALF PRICE CHANNEL PACK-IGLOO | 2
 | RESIDENTIAL |  | HALF PRICE CHANNEL PACK | 30
 | RESIDENTIAL |  | NOT APPLICABLE | 7540
 | RESIDENTIAL |  | [NAME] | 7387
 | RESIDENTIAL |  | SLINGSHOT REGISTRATION OFFER | 186
 | SLINGSHOT |  | [NAME] | 1
 | SLINGSHOT |  | SLINGSHOT REGISTRATION OFFER | 6730
 | ZERO $ STB |  | NOT APPLICABLE | 1
 | ZERO $ STB |  | ZERO $ STB REGISTRATION 12 | 108
 |  | LTD | Promotion |  | Transaction Count
 |  | EMPLOYEE | NOT APPLICABLE |  | 3
 |  | EMPLOYEE | [NAME] |  | 1
 |  | RESIDENTIAL | 30 DAY CHANNEL PACK DISCOUNT |  | 35
 |  | RESIDENTIAL | BUY ONE GET ONE CHANNEL PACK |  | 10
 |  | RESIDENTIAL | COMP FREE CHANNEL PACK - IGLOO |  | 210
 |  | RESIDENTIAL | COMP HALF PRICE CHANNEL PACK-IGLOO |  | 3
 |  | RESIDENTIAL | HALF PRICE CHANNEL PACK |  | 30
 |  | RESIDENTIAL | IGLOO BONUS CHANNEL PACK |  | 198
 |  | RESIDENTIAL | NOT APPLICABLE |  | 11632
 |  | RESIDENTIAL | [NAME] |  | 11537
 |  | RESIDENTIAL | SLINGSHOT REGISTRATION OFFER |  | 472
 |  | SLINGSHOT | NOT APPLICABLE |  | 3
 |  | SLINGSHOT | [NAME] |  | 1
 |  | SLINGSHOT | SLINGSHOT REGISTRATION OFFER |  | 9085
 |  | ZERO $ STB | NOT APPLICABLE |  | 1
 |  | ZERO $ STB | ZERO $ STB REGISTRATION 12 |  | 108
Spreadsheet: 878444d1725527840-unique-text-join-and-transpose-by-formula-as-well-as-by-code-text-join-and-transpose-spill-2024-aligw
Sheet: Expected Result

Date | Particulars |  |  |  |  | Text Join
2024-06-16 00:00:00 | [NAME],Greenland
 | Pistachio Glues
2024-06-16 00:00:00 | Wold Never Goes Wrong |  |  |  |  |  |  |  | [NAME]
 | [NAME]
2024-06-16 00:00:00 | Google Inc |  |  |  |  |  |  |  | Rusted Pure Base
 | Rusted Pure Base
2024-06-17 00:00:00 | Amazon Coporation |  |  |  |  |  |  |  | Pills & Lassi/Pistachio Glues
 | Pills & Lassi
 | Pills & Lassi
 | Pills & Lassi
 | Pistachio Glues
2024-06-17 00:00:00 | [NAME] LLC |  |  |  |  |  |  |  | Fever/Pola Ship
 | Fever
 | Pola Ship
 | Pola Ship
2024-06-18 00:00:00 | Wold Vision Pvt Ltd |  |  |  |  |  |  |  | Pola Ship
 | Pola Ship
 | Pola Ship
2024-06-18 00:00:00 | New Kalakriti |  |  |  |  |  |  |  | Pills & Lassi
 | Pills & Lassi
2024-06-20 00:00:00 | [NAME] |  |  |  |  |  |  |  | Addons/Harder
 | Addons
 | Harder
2024-06-20 00:00:00 | Hindustan Lever Ltd |  |  |  |  |  |  |  | Fever/Pola Ship
 | Fever
 | Pola Ship
2024-06-21 00:00:00 | Overseas Market |  |  |  |  |  |  |  | Pola Ship
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-06-23 00:00:00 | Hindustan Lever Ltd |  |  |  |  |  |  |  | Pills & Lassi
 | Pills & Lassi
 | Pills & Lassi
2024-06-30 00:00:00 | Reliance Telecom |  |  |  |  |  |  |  | Pure Base/Pola Ship
 | Pure Base
 | Pola Ship
2024-06-30 00:00:00 | Hindustan Lever Ltd |  |  |  |  |  |  |  | Pola Ship
 | Pola Ship
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-07-03 00:00:00 | Alzazira Corporation Ltd |  |  |  |  |  |  |  | Pills & Lassi/Rusted Pure Base
 | Pills & Lassi
 | Rusted Pure Base
2024-07-03 00:00:00 | [NAME] |  |  |  |  |  |  |  | Rusted Pure Base/Rusted Pola Ship
 | Rusted Pure Base
 | Rusted Pure Base
 | Rusted Pola Ship
 | Rusted Pola Ship
 | Rusted Pola Ship
2024-07-03 00:00:00 | Botanical Garden |  |  |  |  |  |  |  | Fever/Pola Ship
 | Fever
 | Pola Ship
 | Pola Ship
2024-07-07 00:00:00 | Plast Product |  |  |  |  |  |  |  | BONE Sheet/Rusted BONE Sheet
 | BONE Sheet
 | Rusted BONE Sheet
2024-07-08 00:00:00 | Alzazira Corporation Ltd |  |  |  |  |  |  |  | Rusted Lock Film/Pills & Lassi
 | Rusted Lock Film
 | Pills & Lassi
2024-07-10 00:00:00 | Alzazira Corporation Ltd |  |  |  |  |  |  |  | Pure Base/Pills & Lassi/Rusted Pure Base
 | Pure Base
 | Pills & Lassi
 | Rusted Pure Base
2024-07-12 00:00:00 | Maharaja Pvt. Ltd., Capetown |  |  |  |  |  |  |  | Rusted Pola Ship
 | Rusted Pola Ship
2024-07-12 00:00:00 | Maharaja Pvt. Ltd., Capetown |  |  |  |  |  |  |  | Pola Ship
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-07-24 00:00:00 | London Nepal Ltd,Losangles |  |  |  |  |  |  |  | Pola Ship
 | Pola Ship
2024-07-24 00:00:00 | London Nepal Ltd,Losangles |  |  |  |  |  |  |  | Pola Ship
 | Pola Ship
2024-07-28 00:00:00 | The Kingdom of Plant of Apes |  |  |  |  |  |  |  | Pills & Lassi
 | Pills & Lassi
 | Pills & Lassi
Spreadsheet: 860167d1708368441-create-a-kpi-dashboard-from-multiple-sheets-samplenew
Sheet: Brioche

[NAME] (oz) | Case Weight (lb) | Speed (per min) | Dough Size 1 (lb) | Dough Size 1 (oz) | Theo Units per Dough |  | Units per case (ea) |  | Cases per Dough
1.5 |  | 45 | 189.81 |  |  |  | 240
 |  | 12 Pocket
 |  | 12
Product | Date | Do's ran | Dough Size | Total Weight(lbs) | [NAME] (hrs) | [NAME] | [NAME] | [NAME] | Pack Stop | [NAME] | Total RT | Theo Pieces | Actual Pieces | [NAME] | Total Cases | Extra | Actual Case Yield | Eff % | Waste % | Overall Eff | Units Per Hour
Brioche | 2024-01-30 00:00:00 | 48 | 4 |  |  | 19:14:00 | 06:04:00 |  | 00:00:00 | ? |  |  |  |  | 1583 | 15
Brioche | 2024-01-31 00:00:00 | 32 | 4 |  |  | 06:10:00 | 14:00:00 |  | 00:00:00 | ? |  |  |  |  | 889 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average:
Spreadsheet: 729437d1619092573-formula-to-return-the-most-commonly-occurring-text-value-based-on-criteria-sample-data-for-forum
Sheet: Output Idea

 | Site Number | Site Name | Turbidity | Ammonia | Phosphate | Iron | Total N | pH
 | 123101238A1 | URST | The most commonly occuring exception reason for issues pertaining to Turbidity at site "URST" (IF ANY) | The most commonly occuring exception reason for issues pertaining to Ammonia at site "URST" (IF ANY) | The most commonly occuring exception reason for issues pertaining to Phosphate at site "URST" (IF ANY) | The most commonly occuring exception reason for issues pertaining to iron at site "URST" (IF ANY) | The most commonly occuring exception reason for issues pertaining to Total N at site "URST" (IF ANY) | The most commonly occuring exception reason for issues pertaining to pH at site "URST" (IF ANY)
 | 123101718A1 | TOCK | The most commonly occuring exception reason for issues pertaining to Turbidity at site "TOCK" (IF ANY) | The most commonly occuring exception reason for issues pertaining to Ammonia at site "TOCK" (IF ANY) | etc | etc | etc | etc
 | 123100489A1 | OUTH | etc | etc | etc | etc | etc | etc
 | 123102931A1 | OUGH | etc | etc | etc | etc | etc | etc
 | 123100009A1 | NTON | etc | etc | etc | etc | etc | etc
 | 123100728A1 | NDEN
 | 123102818A1 | IELD
 | 123101533A1 | REEN
 | 123103121A1 | KLEY
 | 123102777A1 | RDEN
 | 123101726A1 | REET
 | 123100368A1 | ROOK
 | 123103026A1 | ROSS
 | 123100627A1 | NDEN
 | 123101289A1 | RING
 | 123103007A1 | SWAY
 | 123101364A1 | RDEN
 | 123102403A1 | OMBE
 | 123101753A1 | FORD
 | 123100346A1 | GATE
 | 123101653A1 | MEON
 | 123103158A1 | IELD
 | 123108031A1 | TNEY
 | 123102214A1 | LSEA
 | 123102195A1 | REEN
 | 123101191A1 | AYNE
 | 123100480A1 | IDGE
 | 123101208A1 | FORD
 | 123100676A1 | HILL
 | 123103234A1 | TTON
 | 123102511A1 | EEDS
 | 123101581A1 | WICK
 | 123101675A1 | GTON
 | 123100164A1 | IELD
 | 123102095A1 | FOLD
 | 123101138A1 | IGHT
 | 123100505A1 | URCH
 | 123100345A1 | LAGE
 | 123107426A1 | FORD
 | 123102883A1 | SHAM
 | 123100446A1 | WOOD
 | 123102698A1 | RTON
 | 123103172A1 | XTED
 | 123103202A1 | WOOD
 | 123101679A1 | XTED
 | 123100592A1 | MMON
 | 123102082A1 | URST
 | 123101125A1 | SHAM
 | 123101932A1 | OUGH
 | 123101974A1 | DORE
 | 123103178A1 | ITON
 | 123102861A1 | KHAM
 | 123100668A1 | SHAM
 | 123100710A1 | HILL
 | 123102198A1 | XALL
 | 123100392A1 | ROSS
 | 123111161A1 | LISH
 | 123103000A1 | OUTH
 | 123100352A1 | DHAM
Spreadsheet: 757852d1638472189-countifs-not-equal-multiple-values-in-same-column-countifs-not-equal-multiple-values-in-same-column
Sheet: Sheet1

Code | ID | Product Type | Unit Type | Date |  |  | 2021-03-01 00:00:00
MATH | S-02 | REG | 35' | 2021-03-31 00:00:00 |  |  | 6 | <-- | =SUM(COUNTIFS(tblData[Date],">="&$H$1,tblData[Date],"<="&EOMONTH($H$1,0), tblData[Product Type], {"SPEC","MODEL"}))
MATH | S-09 | MODEL | 35' | 2021-03-31 00:00:00 |  | 2STRYTH | 5
MATH | S-10 | STD | 42' | 2021-03-31 00:00:00 |  | 35' | 3
MATH | S-11 | SPEC | 42' | 2021-03-31 00:00:00 |  | 42' | 1
MATH | S-22 |  | 35' | 2021-03-31 00:00:00 |  | Total | 15 | <-- | =COUNTIFS(tblData[Date],">="&$H$1,tblData[Date],"<="&EOMONTH($H$1,0))
MATH | S-23 | UNQ | 35' | 2021-03-31 00:00:00
ENG | T28-19 | MODEL | 2STRYTH | 2021-03-31 00:00:00
ENG | T28-21 | REG | 2STRYTH | 2021-03-31 00:00:00 |  |  | Desired Result via formula
ENG | T28-22 | SPEC | 2STRYTH | 2021-03-31 00:00:00
ENG | T28-23 | REG | 2STRYTH | 2021-03-31 00:00:00
ENG | T29-24 | MODEL | 2STRYTH | 2021-03-31 00:00:00
ENG | T29-25 | REG | 2STRYTH | 2021-03-31 00:00:00 |  | Orange colored border (G2:G6) is a dynamic formula
ENG | T29-26 | SPEC | 2STRYTH | 2021-03-30 00:00:00
ENG | T29-27 | REG | 2STRYTH | 2021-03-30 00:00:00 |  | Note that DFH is determined by 'Product Type' = MODEL or SPEC
ENG | T29-28 | SRT | 2STRYTH | 2021-03-31 00:00:00
Spreadsheet: 155901d1337099157-is-there-a-way-to-link-horizontal-cells-in-book1-to-vertical-cells-in-book2-book3
Sheet: DataList

PM Completion Data |  |  |  |  |  |  |  |  |  |  |  | PMI'ers |  | Done List |  | Est Hours List
 | Primo |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  | 410 |  | 0.5
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433 |  | Name: Primitivo Gutierrez |  | 411 |  | 1
W1 |  |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  | 412 |  | 1.5
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  | 420 |  | 2
W3 |  |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  | 421 |  | 2.5
W4 |  |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  | 422 |  | 3
 | Refugio |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  | 423 |  | 3.5
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433 |  | Name: [NAME] |  | 425 |  | 4
W1 |  |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  | 432 |  | 4.5
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Name: Emilio Escutia |  | 433 |  | 5
W3 |  |  |  |  |  |  |  |  |  |  |  | Name: Pedro Reyes |  |  |  | 5.5
W4 |  |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  |  |  | 6
 | [NAME] |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  |  |  | 6.5
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433 |  | Name: [NAME] |  |  |  | 7
W1 |  |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  |  |  | 7.5
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Name: [NAME] |  |  |  | 8
W3
W4
 | [NAME]
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | Enrique
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | [NAME]
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | Miro
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | Juan
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | Abel
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | Emilio
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | [NAME]
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | Doug
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | Francisco
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | Dale
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | Ray
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | [NAME]
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
 | Totals
 | 410 | 411 | 412 | 420 | 421 | 422 | 423 | 425 | 432 | 433
W1
[NAME]
W3
W4
Spreadsheet: 129034d1321416929-if-then-for-a-range-of-cells-ifthen_rangeofcells
Sheet: PEOPLE

FN | LN | Company | RegCode
[NAME] | Jones | abc
Fred | Jones | abc
[NAME] | Smith | def
[NAME] | Smith | ghi
Frederiqa | Wilson | ghi
[NAME] | Winton | ghi
[NAME] | Busch | jkl
Fred | Busch | jkl
Ima | Busch | jkl
Drinka | Busch | jkl
Santa | Claus | mno
Spreadsheet: 766234d1643814628-aggregate-primary-and-secondary-issue-types-transpose-and-add-table
Sheet: Sheet1

Primary Issue |  |  |  |  |  |  |  |  |  |  |  |  | Expectation - combine the 2 tables on the left for a total by type by quarter)
 | 2021 |  |  |  | 2022 |  |  |  |  |  |  |  | Quarter | Testing | Documentation | Technical | Coding | Implementation | Support
Issue Type | 1 | 2 | 3 | 4 | 1 | 2 | 3 |  |  |  |  | 2021 | 1 | 12 |  | 8 |  | 6
Testing | 6 | 7 | 4 |  | 45 | 23 | 8 |  |  |  |  |  | 2 | 7 | 34 |  |  | 10
Documentation |  | 34 | 3 |  | 7 |  | 7 |  |  |  |  |  | 3 | 8 | 6 |  | 6 |  | 8
Technical | 4 |  |  |  |  | 2 | 4 |  |  |  |  |  | 4 |  |  |  | 3
Coding |  |  | 3 | 3 | 8 |  | 1 |  |  |  |  | 2022 | 1 | 45 | 14 |  | 16 |  | 2
Implementation | 3 | 5 |  |  |  | 2 | 11 |  |  |  |  |  | 2 | 26 |  | 4 |  | 2
Support |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 16 | 14 | 8 | 2 | 22 | 5
Secondary Issue
 | 2021 |  |  |  | 2022
Issue Type | 1 | 2 | 3 | 4 | 1 | 2 | 3
Testing | 6 |  | 4 |  |  | 3 | 8
Documentation |  |  | 3 |  | 7 |  | 7
Technical | 4 |  |  |  |  | 2 | 4
Coding |  |  | 3 |  | 8 |  | 1
Implementation | 3 | 5 |  |  |  |  | 11
Support |  |  | 8 |  | 2 |  | 5
Spreadsheet: andy_zipper__179__DYNEGY-ICE VOL Apr26
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 1 | 1825000 |  | Carson , M | Firm-LD Peak | MWhs | 2 | 1600
Mckay, B | NG Fin BS, LD1 for IF | MMBtus | 2 | 1887500 |  | Dorland , C | Firm-LD Peak | MWhs | 27 | 128000
Pimenov, V | NG [NAME], ID, GDD | MMBtus | 3 | 12500 |  | [NAME], R | Firm-LD Peak | MWhs | 4 | 69600
Grand Total |  |  | 6 | 3725000 |  | Motley, M | Firm-LD Peak | MWhs | 2 | 20800
 |  |  |  |  |  | Grand Total |  |  | 35 | 220000
Spreadsheet: sally_beck__35399__2002 Eops Overview for Sally 11-02
Sheet: Headcount

ENRON NETWORKS - ENERGY OPERATIONS
2002 PLAN vs 2001 FORECAST HEADCOUNT
 |  | EA |  |  | EGM |  |  | EIM |  |  | EES (1) |  |  | EBS |  |  | Other |  |  | Total
Function |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan
Deal Capture / Documentation |  | 40 |  |  |  |  |  | 2 |  |  | 25 | 32 |  | 4 | 4
Risk Management |  | 87 |  |  |  |  |  |  |  |  | 33 | 34 |  | 9 | 9
Logistics |  | 74 |  |  |  |  |  | 2 | 3 |  | 29 | 29 |  | 6 | 6
Volume Management |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 34 | 52 |  | 0 | 0
Settlements |  | 71 |  |  |  |  |  |  |  |  |  |  |  | 12 | 11
Trade Accounting |  |  |  |  |  |  |  | 2 |  |  | 0 | 0 |  | 0 | 0
Other
Transaction Structuring |  | 0 | 0 |  | 10 | 10 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Technology |  | 0 | 0 |  | 2 | 2 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Special Projects |  | 0 | 0 |  | 0 | 0 |  | 6 |  |  | 0 | 6 |  | 0 | 0
Media Trafficing |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 3 | 3
Management |  |  | 5 |  |  |  |  |  |  |  |  |  |  | 3 | 3 |  | 2
Subtotal Direct Headcount
Global
Global Counterparty/OPD/Rates |  | 21 | 20 |  | 3 | 8 |  | 1 | 2 |  | 17 | 17 |  | 0.5 | 2 |  | 2.5 | 1
Global Contracts/Records Mgmt |  | 16 | 17 |  | 0.5 | 3 |  | 0.5 | 4 |  | 22 |  |  |  |  |  | 0.5 | 2
DPR/Risk Policy/Global Reporting |  | 7 | 6 |  | 5 | 4 |  | 1 | 2 |  | 3 | 0 |  | 0.5 | 1 |  | 4.5 | 6
Total Headcount
(1)  Does not include contractors - 8 in 2002.
Spreadsheet: 107962d1305084868-two-conditions-in-one-formula-in-conditional-formatting-conditional-formatting
Sheet: Sheet2

 |  | Available |  | Available
 | Group | Operator | Group | Operator
Part1 | 1 | 20 | 2 | 0
part2 | 1 | 12 | 2 | 0
part3 | 1 | 23 | 2 | 12
part4 | 1 | 16 | 2 | 19
Spreadsheet: 713587d1610817361-translating-multiple-column-index-to-other-work-sheets-film-tester
Sheet: Actors

Actor | Total | Ave Score | Oscars | Ave Time | Best Film | Score | Worst Film | Score | Bechdel | BOAT
[NAME]
[NAME]
[NAME]
[NAME]
Macaulay Culkin
[NAME]
[NAME]
Sacha Baron [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Mercedes Ruehl
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Heath Ledger
Julia Stiles
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Agnes Moorehead
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Elijah Wood
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Shia LeBeouf
[NAME]
Dakota [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
JK Simmons
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Rashida Jones
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Lamorne [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Hugo Weaving
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Woody Allen
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Val Kilmer
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Cameron Diaz
[NAME]
[NAME]
Rufus Sewell
[NAME]
[NAME]
Eli Wallach
[NAME]
[NAME]
Antonia Thomas
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Chazz Palminteri
[NAME]
Taren Egerton
[NAME]
[NAME]
[NAME]
Celeste Holm
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Giovanni Ribisi
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Rochenda Sandall
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Milly Shapiro
[NAME]
Micheal Ward
[NAME]
[NAME]
[NAME]
Amarah-Jae St. Aubyn
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] Velez
[NAME]
[NAME] Henry
Hailee Steinfeld
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Cybill Shepherd
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Glynn Turman
Colman [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 850482d1700825500-lookup-value-across-multiple-worksheet-and-locate-sample_
Sheet: Search

Brand | Item Code | EXPECTED RESULT (HYPERLINK FORMULA)
A |  | 1 | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
B |  | 2 | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
C |  | 3 | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
D |  | 4 | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
E |  | 5 | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
F |  | 6 | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
G |  | 7 | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
H |  | 8 | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
I |  | 9 | <<<HYPERLINK FORMULA HERE TO LOCATE "ITEM CODE"
Spreadsheet: 648584d1573119235-power-query-to-tidy-up-data-sample-data-for-power-query
Sheet: Sheet2

Product Name | Sales 1Yr | Costs 1Yr | Profit 1Yr | Sales 3Yr | Costs 3Yr | Profit 3Yr
AAA | 100 | 80 | 20 | 100 | 80 | 20
BBB | 100 | 80 | 20 | 100 | 80 | 20
CCC | 100 | 80 | 20 | 100 | 80 | 20
Spreadsheet: 91204d1290959941-fill-cells-using-vlookup-and-data-verification-copy-fr-1-
Sheet: Vehicle

Vehicle Number | License Plate
003006 | DMV-123 | [NAME]
015004 | DMV-124 | ALABAMA
023660 | DMV-125 | TENNESSEE
033011 | DMV-126 | WISCONSIN
053016 | [NAME] | OHIO
073504 | DMV-128 | CALIFORNIA
073505 | DMV-129 | [NAME]
073506 | DMV-130 | ALABAMA
073507 | DMV-131 | TENNESSEE
073508 | DMV-132 | WISCONSIN
073509 | DMV-133 | OHIO
073510 | DMV-134 | CALIFORNIA
073511 | DMV-135 | [NAME]
073512 | DMV-136 | ALABAMA
073513 | [NAME] | TENNESSEE
073514 | DMV-138 | WISCONSIN
073515 | DMV-139 | OHIO
073516 | DMV-140 | CALIFORNIA
073517 | DMV-141 | [NAME]
073518 | DMV-142 | ALABAMA
073519 | DMV-143 | TENNESSEE
073520 | DMV-144 | WISCONSIN
073521 | DMV-145 | OHIO
073522 | DMV-146 | CALIFORNIA
Spreadsheet: b07df7a1-a5ad-41db-9273-352537602f16
Sheet: template

Academic Work Planning Model 2010-11
Faculty: |  | Individual:
Subject: |  | FTE: | 1
A. Teaching:
Select activity below… | % of module | Formal Scheduled Teaching | Teaching Related Delivery Activity | Total
Example Module 1 | 1
Example Module 2 | 0.5
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
A. Teaching: Other Teaching Related Activity
Membership of Boards of examiners |  |  |  | 0
 |  |  | Academic guidance | 0
Ongoing development of teaching and learning methods |  |  |  | 0
 |  |  | Professional subject updating related to teaching | 0
 |  |  | General admin related to teaching | 0
 |  |  | Account to be taken of new modules | 0
Account to be taken of new lecturer |  |  |  | 0
 |  |  | Preparation and assessment associated with research degree supervision | 0
 |  |  |  | 0
Total
B. Academic Leadership & Management
 |  |  | Module Year leadership | 0
Programme leadership |  |  |  | 0
Subject/Team leadership |  |  |  | 0
Faculty wide responsibilities |  |  |  | 0
Recognised trade union duties |  |  |  | 0
Admissions related activities |  |  |  | 0
Approved external responsibilities |  |  |  | 0
 |  |  | Development of existing curriculum and subject provision | 0
 |  |  | Invigilation | 0
 |  |  | Placement development | 0
 |  |  | Provision on mentoring for new staff | 0
 |  |  | Examining associated with research degrees | 0
 |  |  |  | 0
Total
C. Research
 |  |  | Funded research | 0
 |  |  | Studying for a PhD | 0
 |  |  | Research associated with research student supervision | 0
Total
C. Scholarly Activity
Total (168 hours pro rata)
D. Other
External engagement, consultancy and business development |  |  |  | 0
Developing new income streams |  |  |  | 0
Development of new curriculum and subject provision |  |  |  | 0
Recruitment activity |  |  |  | 0
Funded 'external' projects |  |  |  | 0
Other faculty activities |  |  |  | 0
Delivery of CPD |  |  |  | 0
 |  |  | Administration associated with the above activities | 0
 |  |  |  | 0
Total
 |  | Total
Notes:
Spreadsheet: 800066d1665478293-amalgamating-and-deleting-rows-11102022-errors
Sheet: Final

Passenger Assist List |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-04 00:00:00
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Departure
Job | Assigned To | Name | HIP | VIP | W/C | BR W/C | Mob Imp | [NAME] | Time | Head Code | From | [NAME] | Time | Head Code | Destination | [NAME] | Additional Comments | Event Time
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42