tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 106845d1304006411-vlookup-w-istext-classeur3
Sheet: BU

Sub-Bus | Category |  |  | Dept | Category |  |  |  |  | Sub-Bus Unique List | Found In Category?
TRE |  |  |  | GLFISUP | Finance |  |  |  |  | TRE
TRE |  |  |  | GLFITRS | Finance |  |  |  |  | EXTT
EXTT |  |  |  | GCM | Finance |  |  |  |  | CORICBA
CORICBA |  |  |  | SAFT | Finance |  |  |  |  | B000165
TRE |  |  |  | LNI | Finance |  |  |  |  | GEF
TRE |  |  |  | IFD | Finance |  |  |  |  | CAOU
TRE |  |  |  | EXTT | Finance |  | Defined name "Finance" |  |  | COMPL_SBU
TRE |  |  |  | IAB | Finance |  |  |  |  | OPEFNC
TRE |  |  |  | NAT | Finance |  |  |  |  | NAT
TRE |  |  |  | SYNSBU | Finance |  |  |  |  | CCG_SBU
TRE |  |  |  | WOK | Finance |  |  |  |  | CTY
B000165 |  |  |  | REL_SBU | Finance |  |  |  |  | LEGNTAX_SBU
GEF |  |  |  | CMF | Finance |  |  |  |  | ITECRRF
CAOU |  |  |  | CORICBA | Trading |  |  |  |  | ACFI_SBU
COMPL_SBU |  |  |  | GCM_JV_GLFI | Trading |  |  |  |  | B000460
OPEFNC |  |  |  | SET_JV_MARK | Trading |  | Defined Name "Trading" |  |  | HUMN_SBU
NAT |  |  |  | CORI_JV_CASHMGT | Trading |  |  |  |  | OPETLP
NAT |  |  |  | MNA | Trading |  |  |  |  | CORICOV
CCG_SBU |  |  |  | CPMCORE_SBU | Other |  |  |  |  | STRUT
CTY |  |  |  | PARTOT | Other
LEGNTAX_SBU |  |  |  | QPSGIBBIEN | Other
ITECRRF |  |  |  | PFE | Other
TRE |  |  |  | SSG | Other
ACFI_SBU |  |  |  | B000243 | Other
CAOU |  |  |  | B000345GRP | Other
OPEFNC |  |  |  | B000671 | Operations
B000460 |  |  |  | FSAUDIT | Operations
LEGNTAX_SBU |  |  |  | [NAME] | Operations
CCG_SBU |  |  |  | HUMN | Operations
COMPL_SBU |  |  |  | [NAME] | Operations
ACFI_SBU |  |  |  | ACFI | Operations
HUMN_SBU |  |  |  | OPER | Operations
OPETLP |  |  |  | B000442 | Operations
ITECRRF |  |  |  | FSCOV | Operations
B000460 |  |  |  | TRE | Marketing
CCG_SBU |  |  |  | TRD | Marketing
CCG_SBU |  |  |  | GEF | Marketing
CORICOV |  |  |  | SOL | Marketing
STRUT |  |  |  | CTY | Marketing
CCG_SBU |  |  |  | [NAME] | Marketing
CTY |  |  |  | GRS | Marketing
NAT |  |  |  | MARKTRS | Marketing
CAOU |  |  |  | FIC | Marketing
TRE |  |  |  | LYX | Marketing
Spreadsheet: tracy_geaccone__40633__1stQTRFore4qtrs
Sheet: FGT only

Revised 2/22/01 | 1st | 2nd | 3rd | 4th
Keiser (Ext. 33138) | QTR | QTR | QTR | QTR | TOTAL
Net Margins PLAN
VARIANCES:
Demand:         FTS-1 | 0.1 | 0 | 0 | 0 |  |  | Conversion of SFTS to FTS-1
Commodity:     FTS-1 |  | 0 | 0 | 0 |  |  | Lower throughput (down to 1 BCF/D) due to the continuing higher gas pricing
 |  |  |  |  |  |  | compared to oil.  As of 2/01, oil is cheaper than gas by about $1.50/MMbtu.
Demand:         FTS-2 & STF | 1.3 | 0 | 0 | 0 |  |  | Primarily due to FPC needing additional firm capacity, which we were able to
 |  |  |  |  |  |  | supply them with an additional 35,000/D at a $0.45 margin.  We also locked
 |  |  |  |  |  |  | in higher margins on ST Firm.
Commodity:     FTS-2 & STF | -0.3 | 0 | 0 | 0 |  |  | Lower throughput (down to 1 BCF/D) due to continued higher gas pricing
 |  |  |  |  |  |  | compared to oil.  As of 2/01, oil is cheaper than gas by about $1.50/MMbtu.
Demand:         Phase 4  FTS-2 | 0 | 0 | 0 | 0
Commodity:     Phase 4  FTS-2 | 0 | 0 | 0 | 0
Other:               IT, SFTS, PNR, Western | 1.1 | 0 | 0 | 0 |  |  | The PNR margins (based on the spread between the winter/summer months)
 |  |  |  |  |  |  | were significantly higher than usual due to the high winter gas prices.
 |  |  |  |  |  |  | We also received stronger margins on Market Area IT, and SFTS
 |  |  |  |  |  |  | throughput was higher.
Stretch:  Non-Cash | 0 | 0 | 0 |  |  |  | First QTR increase of $1.6 MM over Plan was utilized to reduce 4th QTR
 |  |  |  |  |  |  | STRETCH.
Less:  T C & S | 0 | 0 | 0 | 0
Total Variances
Net Margins 1st QTR FORECAST
Expenses PLAN | -1.2 | -1.2 | -1.2 | -1.4
Variances | 0 | 0 | 0 | 0 |  |  | No Variances
Expenses 1st QTR FORECAST
Non-Recurring PLAN | 0 | 0 | 0 | 0.5
Variances | 0 | 0 | 0 | 0 |  |  | No Variances
Non-Recurring 1st QTR FORECAST
Total Commercial PLAN
Variances
Total Commercial 1st QTR FORECAST
Spreadsheet: 875833d1722458787-finding-name-in-a-range-ond-return-value-in-a-column-excel-forum-aug-24
Sheet: Sheet1

 |  | Profession | Section 1 | Section 2 | Section 3 | Section 4 | Section 5
 |  | Auditor | [NAME] | DANIEL LOPEZ | [NAME] | MARIA YOUNG | [NAME]
 |  | Actor | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 |  | [NAME] | [NAME] | [NAME] | [NAME] | MARGARET KING | [NAME] |  | [NAME]
 |  | Adhesive Bonding Machine Operator | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 |  | Tender | [NAME] | [NAME] | [NAME] | [NAME] | MICHELLE RIVERA |  | [NAME]
 |  | Administrative Law Judge | [NAME] | [NAME] | PATRICIA CLARK | NANCY TORRES | LAURA CAMPBELL |  | [NAME]
 |  | Administrative Services Manager | [NAME] | STEVEN MOORE | [NAME] | KAREN NGUYEN | SARAH MITCHELL |  | [NAME]
 |  | [NAME] and Secondary Education and Literacy Teacher | [NAME] | [NAME] | [NAME] | BETTY HILL | KIMBERLY CARTER |  | [NAME]
 |  | Instructor | THOMAS MARTINEZ | [NAME] | [NAME] ROBINSON | HELEN FLORES | [NAME] |  | THOMAS MARTINEZ
 |  | Advertising Sales Agent | [NAME] | [NAME] | JENNIFER WALKER | SANDRA GREEN | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | DANIEL LOPEZ
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 | Find an employee's profession by name using wildcards |  |  |  |  |  |  |  | [NAME]
 | Employee | [NAME] |  |  |  |  |  |  | STEVEN MOORE
 | Profession |  |  |  |  |  |  |  | [NAME]
 | Profession |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 | Find an employee's name by profession using wildcards |  |  |  |  |  |  |  | [NAME]
 | Profession | Machine |  |  |  |  |  |  | [NAME]
 | Employee(s) |  | [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | PATRICIA CLARK
 |  |  |  |  |  |  |  |  | [NAME]
 | 1 | I want to find an eployees names based on his or hers profession |  |  |  |  |  |  | [NAME]
 | 2 | I want to find an employee's profession based on his or hers name |  |  |  |  |  |  | [NAME] ROBINSON
 |  |  |  |  |  |  |  |  | JENNIFER WALKER
 |  |  |  |  |  |  |  |  | MARIA YOUNG
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | MARGARET KING
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | NANCY TORRES
 |  |  |  |  |  |  |  |  | KAREN NGUYEN
 |  |  |  |  |  |  |  |  | BETTY HILL
 |  |  |  |  |  |  |  |  | HELEN FLORES
 |  |  |  |  |  |  |  |  | SANDRA GREEN
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | MICHELLE RIVERA
 |  |  |  |  |  |  |  |  | LAURA CAMPBELL
 |  |  |  |  |  |  |  |  | SARAH MITCHELL
 |  |  |  |  |  |  |  |  | KIMBERLY CARTER
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 127882d1320671677-conditional-formatting-to-indicate-start-date-and-end-date-sample1
Sheet: Jan

Name | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T
 | 1 | 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
 | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00
Spreadsheet: 859201d1707665644-rank-and-count-values-in-a-range-from-the-same-range-across-multiple-sheets-sample-62-ans
Sheet: Review

Top 20
Bob2 | <---- | All manually entered |  |  |  | 10 |  |  |  |  | 10
Carmen3 | <---- |  |  |  | Bob2 | 8 |  |  |  | Bob2 | 8
Marge | <---- |  |  |  | Carmen3 | 7 |  |  |  | Carmen3 | 7
Abigail1 |  |  |  |  | Mark4 | 6 |  |  |  | Mark4 | 6
[NAME] |  |  |  |  | Tom5 | 5 |  |  |  | Tom5 | 5
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 1
[NAME] |  |  |  |  |  |  |  |  |  | Marge | 0
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 0
Ernie |  |  |  |  |  |  |  |  |  | [NAME] | 0
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 0
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 0
Priya |  |  |  |  |  |  |  |  |  | Ernie | 0
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 0
Tom5 |  |  |  |  |  |  |  |  |  | [NAME] | 0
[NAME] |  |  |  |  |  |  |  |  |  | Priya | 0
Mark4 |  |  |  |  |  |  |  |  |  | [NAME] | 0
Elaine |  |  |  |  |  |  |  |  |  | Elaine | 0
Maria |  |  |  |  |  |  |  |  |  | Maria | 0
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 0
[NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 0
EXPECTED OUTCOME
Abigail1 (10) | <------Formulas in here |  | that checks for the names entered into A2:A21 against the other 12 sheets
Bob2 (8) |  |  | and results in the name in the range that matched the most with the number
Carmen3 (7) |  |  | of times it matched in parenthesis.
Mark4 (6)
Tom5 (5) |  |  | The formula should account for the possibility of blank cells.
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 21

 |  | Gross Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated gross notional amount outstanding, November 16 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****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: 761398d1640876130-populate-result-from-2nd-tab-based-on-cell-value-stews73-test-file-2-aligw
Sheet: Sheet1

ID | Name | Address | Mobile Number | Date of Birth
1001 | CHRISTOPHER MEADEN | 1 high street
1001A | [NAME] | 1 high street
357A | [NAME] | 35 low street
357B | [NAME] | 35 low street
357C | [NAME] | 35 low street
C12 | [NAME] | 2 middle street
C18 | [NAME] | 15 halfway close
Spreadsheet: 217506d1362084670-consolidate-by-two-factors-new-problem
Sheet: November2012

 |  |  |  |  |  |  |  |  |  |  |  | 0.27
Customer | Name | Product | Description | Qty | m2 | Value | Av Price | Matl Cost | Yield AdJ | Purch Cost | Tot Matl Cost | ES Cost
304 | Customer B | 500044 | Insulight(TM) | 2 | 2.23 | 80.07 | 35.91 | 8.11 | 10.67105263157895 | 41.21 | 51.88105263157895 | 6.021
304 | Customer B | 512084 | energiKare(TM) | 96 | 40.38 | 986.81 | 24.44 | 250.19 | 329.1973684210526 | 45.8 | 374.9973684210526 | 109.026
304 | Customer B | 512484 | energiKare(TM) | 60 | 49.05 | 1290.96 | 26.32 | 333.21 | 438.4342105263158 | 0 | 438.4342105263158 | 132.435
304 | Customer B | 530049 | Insulight(TM) [NAME] | 34 | 11.02 | 318.39 | 28.89 | 83.01 | 109.2236842105263 | 11.2 | 120.4236842105263 | 29.754
304 | Customer B | 530149 | Insulight(TM) [NAME] | 1 | 0.63 | 19.22 | 30.51 | 6.89 | 9.06578947368421 | 0 | 9.06578947368421 | 1.701
304 | Customer B | 99999999 | Energy Surcharge | 0 | 0 | 487.34 | 0 | 0 | 0 | 0 | 0 | 0
3152 | Customer C | 102614 | 4mm Oriel Texture Laurel stk | 2 | 5.64 | 397.28 | 70.44 | 200.33 | 263.5921052631579 | 0 | 263.5921052631579 | 15.228
3152 | Customer C | 500044 | Insulight(TM) | 212 | 128.77 | 2432.8 | 18.89 | 577 | 759.2105263157895 | 0 | 759.2105263157895 | 347.679
3152 | Customer C | 500045 | Insulight(TM) | 26 | 13.76 | 304 | 22.09 | 94.7 | 124.6052631578947 | 0 | 124.6052631578947 | 37.152
3152 | Customer C | 500144 | Insulight(TM) Protect | 78 | 33.38 | 1082.84 | 32.44 | 155.6 | 204.7368421052632 | 0 | 204.7368421052632 | 90.12600000000002
3152 | Customer C | 500145 | Insulight(TM) Protect | 1 | 0.46 | 16.37 | 35.59 | 3.36 | 4.421052631578947 | 0 | 4.421052631578947 | 1.242
3152 | Customer C | 500264 | Insulight(TM) Protect1 | 36 | 20.11 | 783.91 | 38.98 | 29.53 | 38.85526315789474 | 13.6 | 52.45526315789474 | 54.297
3152 | Customer C | 500280 | Insulight(TM) Protect | 3 | 1.23 | 43.1 | 35.04 | 3.59 | 4.723684210526316 | 0 | 4.723684210526316 | 3.321
3152 | Customer C | 500281 | Insulight(TM) Protect | 1 | 0.4 | 20.62 | 51.55 | 2.3 | 3.026315789473684 | 0 | 3.026315789473684 | 1.08
3152 | Customer C | 512147 | energiKare(TM) | 4 | 5.03 | 212.32 | 42.21 | 33.9 | 44.60526315789473 | 0 | 44.60526315789473 | 13.581
3152 | Customer C | 512247 | energiKare(TM) | 2 | 2.41 | 121.41 | 50.38 | 10.63 | 13.98684210526316 | 0 | 13.98684210526316 | 6.507000000000001
3152 | Customer C | 99999999 | Energy Surcharge | 0 | 0 | 1122.8 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 164727d1340868849-excel-2007-help-on-vlookup-funtion-0addata-3-
Sheet: DATA

Date | Particulars | Amount | hideen columns
2012-04-07 00:00:00 | COMMN_6347B9_0406_25100 | 25100
2012-04-07 00:00:00 | COMMN_6347B7_0406_14000 | 14000
2012-04-07 00:00:00 | COMMN_6347B5_0406_14200 | 14200
2012-04-07 00:00:00 | COMMN_6347B4_0406_46000 | 46000
2012-04-07 00:00:00 | COMMN_6347C9_0406_1850 | 1850
2012-04-07 00:00:00 | COMMN_6347B8_0406_8495 | 8495
2012-04-07 00:00:00 | COMMN_6347C2_0402_3500 | 3500
Spreadsheet: 804987d1668459634-moving-a-row-into-another-sheet-automated-please-help-test-book
Sheet: North America

 | USA | Canada
 | x | x
 | x
 |  | x
 | x | x
Spreadsheet: 51932116-45da-457b-a0e9-3ab98e5e534e
Sheet: B&H 3 years

 | Project Title: | [NAME] | New Coalitions for Biodiversity - Developing public-private partnerships within protected areas in five countries of the South East Europe - Budget
 | Project Activities: | Bosnia & Herzegovina
 |  | YEAR 1 - 2011 |  |  | YEAR 2 -2012 |  |  | YEAR 3 2013 |  |  |  | TOTAL  3 YEARS
 | Category | Donor | WWF MEDPO | Total | Donor | WWF MEDPO | Total | Donor | WWF MEDPO | Total |  | Donor | WWF MEDPO | Total
1 | Project Staff
1.1 | BP development international support team: Expert 1: 30 month. ([NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  | Back to MATRA proposal
1.3 | Ministry focal point (NPCs+Serbian focal point) | 840
1.5 | PA staff cost (€ 2000 x YEAR x 2 PA)
 | Total 1
2 | Studies, publications and workshops
2.1 | Twelve Market Studies (2x PA x 1000) |  |  |  |  |  |  |  |  |  |  |  |  |  | Need more assumptions for estimation
2.2 | BP development workshops (1 WS x Y x PA) |  |  |  |  |  |  |  |  |  |  |  |  |  | check with old MATRA proposal
2.4 | Printing of six business plans
2.5 | Public launches/visibility events to highlight public-private partnership achievements (2,7) € 6000 (2 events) |  |  |  | 6000
 | Total 2
3 | Travel
3.1 | Travel PPP Lead
3.1 | Travel BP consultant (international)
3.2 | Travel Regional Project leader (3Xcountry)
3.2 | Travel BP development lead  local
 | Total 3
4 | Local Office Running Costs
 | Total 4
5 | Management Fees -8,5%
 | Total
 |  | Donor | WWF MedPO | Total
 | Year 1
 | Year 2
 | Year 3
 | Total 3 years
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  | 0
 | Total Direct Cost for MedPO ORC and Admin
Spreadsheet: 201699d1356082405-countif-that-returns-a-count-based-on-specific-words-within-a-cell-ghozi-21122012-countif-specific-text-within-a-cell
Sheet: Sheet1

 | Process | Countif should return |  |  | Filenames | Code
 | Authorise Customer Bill Invoice Adjustment |  |  |  | BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.03 - Authorise Customer [NAME] Adjustment\SI_ Authorise Customer Bill Invoice Adjustment | UC_R2.1_343
 | Track And Manage Customer Bill Inquiry Resolution |  |  |  | BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.03 - Authorise Customer [NAME] Adjustment\SI_ Authorise Customer Bill Invoice Adjustment | UC_R2_342
 |  |  |  |  | BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.04 - Track And Manage Customer [NAME] Resolution\SI Track And Manage Customer Bill Inquiry Resolution | UC_R2.1_1156
 |  |  |  |  | Operations\CRM - Customer Relationship Management\BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.04 - Track And Manage Customer [NAME] Resolution\SI Track And Manage Customer Bill Inquiry Resolution | UC_R2.1_1157
 |  |  |  |  | Operations\CRM - Customer Relationship Management\BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.04 - Track And Manage Customer [NAME] Resolution\SI Track And Manage Customer Bill Inquiry Resolution | UC_R2.1_036
 |  |  |  |  | Operations\CRM - Customer Relationship Management\BIH - Bill Inquiry Handling\Usage and Payment Inquiries\BIH.04 - Track And Manage Customer [NAME] Resolution\SI Track And Manage Customer Bill Inquiry Resolution | UC_R2.1_036.a
 | Requirement
 | I need a countif that takes the value in B3 and looks for it embedded within larger strings in F3:FX
 | So in this example the Countif would return the following values in C3 & C4
Spreadsheet: 83456d1283432902-excel-2007-pivot-table-column-display-organization-issues-pivottablecolumns
Sheet: Actual Pivot Table

 | Original Branch Different | Original Backorder Branch Different | Brest Branch Different | Values
 | FALSE |  |  |  |  |  |  |  |  | TRUE
 | FALSE |  |  | TRUE |  |  |  |  |  | FALSE |  |  |  |  |  | TRUE
 | TRUE |  |  | FALSE |  |  | TRUE |  |  | FALSE |  |  | TRUE |  |  | FALSE |  |  | TRUE
Branch | Count of Original Branch Different | Count of Original Backorder Branch Different | Count of Brest Branch Different | Count of Original Branch Different | Count of Original Backorder Branch Different | Count of Brest Branch Different | Count of Original Branch Different | Count of Original Backorder Branch Different | Count of Brest Branch Different | Count of Original Branch Different | Count of Original Backorder Branch Different | Count of Brest Branch Different | Count of Original Branch Different | Count of Original Backorder Branch Different | Count of Brest Branch Different | Count of Original Branch Different | Count of Original Backorder Branch Different | Count of Brest Branch Different | Count of Original Branch Different | Count of Original Backorder Branch Different | Count of Brest Branch Different
1 |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
2 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
3 | 1 | 1 | 1 |  |  |  |  |  |  | 2 | 2 | 2 | 1 | 1 | 1 |  |  |  | 1 | 1 | 1
4 |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 3 | 3 | 3 | 2 | 2 | 2
Spreadsheet: 697252d1601287895-lookup-or-index-using-2-columns-testdata
Sheet: Sheet1

Part Number | Part Description | Op No | Op Description
Part1 | Desc1 | 10 | OpDesc1a
Part1 | Desc1 | 20 | OpDesc1b
Part1 | Desc1 | 30 | OpDesc1c
Part1 | Desc1 | 40 | OpDesc1d
Part2 | [NAME] | 10 | OpDesc2a
Part2 | [NAME] | 20 | OpDesc2b
Part2 | [NAME] | 30 | OpDesc2c
Spreadsheet: 585899d1534065130-time-vlookup-error-rad
Sheet: Sheet3

 | Time | Decay Factor
 | 00:00:00 | 1
 | 00:10:00 | 0.981
 | 00:20:00 | 0.962
 | 00:30:00 | 0.944
 | 00:40:00 | 0.926
 | 00:50:00 | 0.908
 | 01:00:00 | 0.891
 | 01:10:00 | 0.872
 | 01:20:00 | 0.857
 | 01:30:00 | 0.841
 | 01:40:00 | 0.825
 | 01:50:00 | 0.809
 | 02:00:00 | 0.794
 | 02:10:00 | 0.778
 | 02:20:00 | 0.764
 | 02:30:00 | 0.749
 | 02:40:00 | 0.735
 | 02:50:00 | 0.721
 | 03:00:00 | 0.707
 | 03:10:00 | 0.693
 | 03:20:00 | 0.68
 | 03:30:00 | 0.667
 | 03:40:00 | 0.655
 | 03:50:00 | 0.642
 | 04:00:00 | 0.63
 | 04:10:00 | 0.618
 | 04:20:00 | 0.606
 | 04:30:00 | 0.595
 | 04:40:00 | 0.583
 | 04:50:00 | 0.572
 | 05:00:00 | 0.561
 | 05:10:00 | 0.55
 | 05:20:00 | 0.54
 | 05:30:00 | 0.53
 | 05:40:00 | 0.519
 | 05:50:00 | 0.509
Spreadsheet: 850340d1700690596-finding-the-max-value-and-corresponding-cell-max-reference-formula
Sheet: Sheet1

Row Labels | Field 1 | Column to Populate
1 | 40 | 2.94
2.7086 | 3
2.823475 | 2
2.861766666666667 | 1
2.8924 | 2
2.93835 | 27
3.014933333333333 | 2
3.053225 | 2
3.1681 | 1
2 | 55 | 3.12
2.9947 | 6
3.021521052631579 | 1
3.0311 | 1
3.0339 | 1
3.04566 | 1
3.0731 | 1
3.079633333333333 | 2
3.1039 | 1
3.1221 | 36
3.164566666666667 | 1
3.2495 | 4
3 | 36 | 2.07
2.0304 | 3
2.037038461538462 | 1
2.045810714285714 | 1
2.046090909090909 | 1
2.04658125 | 1
2.049577777777778 | 1
2.050315384615385 | 1
2.051975 | 3
2.054671875 | 1
2.055057142857143 | 1
2.055782352941177 | 1
2.056953846153846 | 1
2.059166666666667 | 1
2.060605 | 1
2.061781818181818 | 1
2.067385714285714 | 1
2.07355 | 15
2.095125 | 1
4 | 34 | 2.26
2.0421 | 6
2.099966666666667 | 1
2.1041 | 1
2.1289 | 1
2.135707843137255 | 1
2.138544444444445 | 1
2.1641625 | 1
2.168683333333334 | 1
2.186766666666667 | 2
2.2157 | 1
2.2591 | 16
2.4761 | 2
Spreadsheet: 736937d1623953433-match-data-from-multiple-sheet-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | RESULT
 | APPLE |  |  |  |  |  |  | CC |  | 3
 | ORANGE |  |  |  |  |  |  | DD |  | 4
 | KIWI |  |  |  |  |  |  | EE |  | 5
 | WATERMELON |  |  |  |  |  |  | FF |  | 6
 | BIKE |  |  |  |  |  |  | DD |  | 16
 | SOFA |  |  |  |  |  |  | WW |  | 17
 | BUS |  |  |  |  |  |  | QQ |  | 18
 | GREEN |  |  |  |  |  |  | GREEN |  | 14
 | BLUE |  |  |  |  |  |  | BLUE |  | 15
 | PEAR |  |  |  |  |  |  | GG |  | 7
 | ORANGE |  |  |  |  |  |  | HH |  | 8
Spreadsheet: 686097d1594362326-lookup-then-traffic-lights-pq-icon-with-text-workaround-aligw
Sheet: Sheet1

name | testing |  | approval |  | review
p1 | completed |  | not started |  | at risk
p2 | WIP |  | completed |  | At risk
p3 | at Risk |  | WIP |  | WIP
Spreadsheet: shelley_corman__38708__INGAA Data Template
Sheet: Primary Holder

Location | [NAME] | Shipper ID (DUNS) | Affiliate (Y/N) | Type | Capacity (MDth/d) | Expiration Date | Agent Name | Agent ID (DUNS) | Expiration Date | Services
 |  |  |  | LDC |  |  |  |  |  | Nominations
 |  |  |  | Producer |  |  |  |  |  | Release Capacity
 |  |  |  | Marketer |  |  |  |  |  | Negotiate Contracts
 |  |  |  | Power Generator |  |  |  |  |  | Balancing
 |  |  |  | Other End User |  |  |  |  |  | . . .
 |  |  |  | Pipeline Company
 |  |  |  | Other
Spreadsheet: dana_davis__4472__Responsibility List
Sheet: 3Q00

Tax Schedule Responsibility List
2Q00
Company |  |  |  | Responsible
Number |  | Company Name |  | Accountant
447 |  | Enron Minority Development Corp. |  | [NAME]
976 |  | [NAME], Inc. |  | [NAME]
977 |  | HGK Enterprises GP, Inc. |  | [NAME]
978 |  | HGK Enterprises LP, Inc. |  | [NAME]
979 |  | [NAME], Inc. |  | [NAME]
980 |  | Destec Properties Limited Partnership |  | [NAME]
27L |  | Enron Catalytica |  | [NAME]
46K |  | Sundance ECT US |  | [NAME]
129 |  | JEDI - Lewis, L.L.C. |  | [NAME]
132 |  | JEDI - Lewis Holdings, L.P. |  | [NAME]
002 |  | Enron Finance Corp. |  | [NAME]
003 |  | ERAC Finance Division |  | [NAME]
79R |  | Enron Re Limited |  | [NAME]
28C |  | ECT Canada Accounting Entity |  | Laynie East
46L |  | Sundance ECT Canada |  | Laynie East
277 |  | [NAME], L.L.C. |  | [NAME]
34M |  | ECT Securities GP Corp. |  | [NAME]
37H |  | ECT Securities Limited Partnership |  | [NAME]
40N |  | ECT Securities LP Corp. |  | [NAME]
957 |  | Kenobe, Inc. |  | [NAME]
960 |  | OBI-1 Holdings, L.L.C. |  | [NAME]
961 |  | Oilfield Business Investments-1, L.L.C. |  | [NAME]
925 |  | ECT Thailand Investments, Inc. |  | [NAME]
28P |  | FP Purchase Accounting Entity |  | [NAME]
272 |  | ECT Merchant Investment Corp. |  | [NAME]
941 |  | ENA CLO Holding Company GP, L.L.C. |  | [NAME] | Start in 3Q00
72S |  | ENA CLO I Holding Company II L.P. |  | [NAME]
1N2 |  | ECT Finance |  | [NAME]