tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 152423d1335377375-flattening-data-example
Sheet: Sheet1

PersonRef | AddRef | TITLE | FORENAME | SURNAME | GENDER_CODE | ADR_LINE_1 | ADR_LINE_2 | ADR_LINE_3 | ADR_LINE_4 | ADR_LINE_5 | ADR_POSTCODE
309351 | 156528 | MR | THOMAS | Black | M | Flat 1 | 10 Glebe Street | Dundee |  |  | DD1 1FG
309352 | 156528 | MRS | MAY | Black | F | Flat 1 | 10 Glebe Street | Dundee |  |  | DD1 1FG
309353 | 156529 | MRS | MARGARET | CLARK | F | 14 DRUM ROAD | DUNDEE |  |  |  | DD2 3RT
309354 | 156529 | MR | [NAME] | CLARK | M | 14 DRUM ROAD | DUNDEE |  |  |  | DD2 3RT
309355 | 156529 | MS | [NAME] | CLARK | F | 14 DRUM ROAD | DUNDEE |  |  |  | DD2 3RT
309356 | 156530 | MR | PAT | GREEN | M | 436 WALL ROAD | DUNDEE |  |  |  | DD5 6RT
309357 | 156531 | MRS | ROSE | SHARD | F | 1/1 | 273 BELL CLOSE | DUNDEE |  |  | DD6 5WE
309358 | 156531 | MISS | EMMA | ALLAN | F | 1/1 | 273 BELL CLOSE | DUNDEE |  |  | DD6 5WE
309359 | 156532 | MRS | [NAME] | GALL | F | 3/2 | 24 NAPWELL LANE | Dundee |  |  | DD9 8IU
AddRef | ADR_LINE_1 | ADR_LINE_2 | ADR_LINE_3 | ADR_LINE_4 | ADR_LINE_5 | ADR_POSTCODE | [NAME] | FORENAME1 | SURNAME1 | GENDER_CODE1 | TITLE2 | FORENAME2 | SURNAME2 | GENDER_CODE2 | TITLE3 | FORENAME3 | SURNAME3 | [NAME] | [NAME] | [NAME] | GENDER_CODE4 | FORENAME5 | SURNAME5 | GENDER_CODE5
156528 | Flat 1 | 10 Glebe Street | Dundee |  |  | DD1 1FG | MR | THOMAS | Black | M | MRS | MAY | Black | F
156529 | 14 DRUM ROAD | DUNDEE |  |  |  | DD2 3RT | MRS | MARGARET | CLARK | F | MR | [NAME] | CLARK | M | MS | [NAME] | CLARK | F | 14 DRUM ROAD
156530 | 436 WALL ROAD | DUNDEE |  |  |  | DD5 6RT | MR | PAT | GREEN | M
156531 | 1/1 | 273 BELL CLOSE | DUNDEE |  |  | DD6 5WE | MRS | ROSE | SHARD | F | MISS | EMMA | ALLAN | F
156532 | 3/2 | 24 NAPWELL LANE | Dundee |  |  | DD9 8IU | MRS | [NAME] | GALL | F
Spreadsheet: 180371d1347570073-entering-results-by-data-form-is-it-possible-fl1-2012-13
Sheet: Table

 |  |  |  | Home |  |  |  |  | Away |  |  |  |  | Overall
 |  | Team | M | W | D | L | F | A | W | D | L | F | A | W | D | L | F | A | [NAME] | Pts
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
Spreadsheet: 884593d1733827065-automatically-export-data-from-multiple-sheets-if-it-matches-into-a-combined-sheet-tester-2
Sheet: 11

Date | Seller # | [NAME] | Item Description | List Price | QTY | Total Sales | Card or Cash | Fee |  | To [NAME]
 |  |  |  |  |  |  | Card
Spreadsheet: 81706d1281837680-calculate-hours-ignoring-empty-cells-timesheet-simple
Sheet: Layout1

NAMES |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Total
Employee1 | In | 16:00:00 | 22:00:00 |  |  | 11:00:00 |  | 17:00:00 | 21
 | Out | 22:00:00 | 06:00:00 |  |  | 15:00:00 |  | 20:00:00
Employee2 | In |  |  |  |  |  |  |  | 0
 | Out
Employee3 | In |  |  |  |  |  |  |  | 0
 | Out
Employee4 | In |  |  |  |  |  |  |  | 0
 | Out
Employee5 | In |  |  |  |  |  |  |  | 0
 | Out
Employee6 | In |  |  |  |  |  |  |  | 0
 | Out
Employee7 | In |  |  |  |  |  |  |  | 0
 | Out
Employee8 | In |  |  |  |  |  |  |  | 0
 | Out
Employee9 | In |  |  |  |  |  |  |  | 0
 | Out
Employee10 | In |  |  |  |  |  |  |  | 0
 | Out
Employee11 | In |  |  |  |  |  |  |  | 0
 | Out
Employee12 | In |  |  |  |  |  |  |  | 0
 | Out
Spreadsheet: 781653d1653466097-apply-inflation-at-annivsery-period-to-prior-value-inflation-at-set-point-test
Sheet: Sheet1

Account Name | Contract Start | Renewal period (month) | End Date | Inflation | Contract Value
Test1 | 2023-10-01 00:00:00 | 36 |  | 0.05 | 10000
 |  |  | Every 36 months apply 5% inflation to previous number
 |  |  | value should only show in the month of renewal i.e at 36month period
 |  |  | cells in between to show zero
Spreadsheet: 794485d1662067130-need-help-is-it-possible-to-add-a-formula-to-a-pivot-table-sample-data-5-
Sheet: Sheet2

Project Number | Name | Percentage | 40 |  | Row Labels | Sum of Percentage | Sum of 40
111 | [NAME] | 20 |  |  | Ana | 60 | 100 | 100
123 | [NAME] | 10 |  |  | [NAME] | 30 | 30 | 30
214 | [NAME] | 10 |  |  | [NAME] | 20 | 20 | 20
915 | [NAME] | 10 |  |  | [NAME] | 60 | 60 | 60
852 | [NAME] | 30 |  |  | [NAME] | 50 | 90 | 90
741 | Ana | 40 |  |  | [NAME] | 30 | 30 | 30
159 | [NAME] | 20
456 | [NAME] | 20
789 | [NAME] | 20
321 | [NAME] | 10
147 | [NAME] | 30
258 | Ana | 20
369 | [NAME] | 10
Spreadsheet: 0b488b80-6e91-4e5d-b1ee-c7d1b00b6184
Sheet: Sheet4

Appendix A
Utilities
Electricity
[NAME]  (Kw-hr) | [NAME] (Kw-hr) | Electricity to [NAME] (Kw-hr) | Net Profit ($/hr)
[NAME]
Consumption (gal/hr) | Consumption (1000gal/hr) | Purchased Cost ($/hr) | Generation (gal/hr) | Generation (1000gal/hr) | Selling Price ($/hr) | Net Cost ($/hr)
 |  |  | 710003
Steam
20 lb Steam Consumption (lb/hr) | 20 lb Steam Generation (lb/hr) | 20 lb Steam to Sell (lb/hr) | 600 lb Steam Consumption (lb/hr) | 600 lb Steam Cost ($/hr) | Net 20 lb Steam Profit ($/hr)
1005946 | 4605022 |  | 3360000 | 16800 | 7198
Fuel Gas
Generated (lb/hr) | Preheat Furnace Requirement (lb/hr) | Fuel Gas to Sell (lb/hr) | Fuel Gas Profit ($/hr)
955900 | 151997.5 |  | 12648
Spreadsheet: 116901d1312285179-frequency-question-bookbshaver
Sheet: Sheet3

 |  |  | [NAME] | Billy | [NAME] | Adam | [NAME] | [NAME] | [NAME] | [NAME] | George | Blake | [NAME] | [NAME] | Doug | [NAME] | [NAME] | [NAME] | Total
[NAME] | Group 1 | [NAME] | x
[NAME][NAME] | Group 2 | Billy
[NAME] | Group 3 | [NAME]
[NAME] | Group 4 | Adam
[NAME] | Group 1 | [NAME]
Blake  [NAME]Brandon | Group 2 | [NAME]
[NAME] | Group 3 | [NAME]
[NAME][NAME] | Group 4 | [NAME]
Blake  [NAME] | Group 1 | George
[NAME]  [NAME] | Group 2 | Blake
[NAME] | Group 3 | [NAME]
[NAME][NAME] | Group 4 | [NAME]
[NAME] | Group 1 | Doug
[NAME] | Group 2 | [NAME]
[NAME] | Group 3 | [NAME]
[NAME][NAME] | Group 4 | [NAME]
[NAME] | Group 1 | Total
[NAME] | Group 2
[NAME] | Group 3
[NAME] | Group 4
[NAME] | Group 1
[NAME] | Group 2
[NAME][NAME] | Group 3
[NAME] | Group 4
Spreadsheet: 507694d1489778204-formula-help-for-a-wealth-management-fee-tier-calculation-xlf-investment-tiers
Sheet: Sheet1

Investment | Fee % | Fee | Cumulative |  | Investment | Fee
0 | 0.01 |  |  |  | 275000
25000.01 | 0.0075
100000.01 | 0.005
250000.01 | 0.004
Spreadsheet: 69743d1270369834-perform-if-statement-if-statment
Sheet: Sheet3

10 | 10 | 10 | 10 | 10 | 12 | 12 | 12 | 12 | 12 | 15 | 15 | 15 | 15 | 20 | 20
21741 | 20621 | 20237 | 19688 | 19119 | 18652 | 17609 | 16534 | 15767 | 15382 | 14899 | 13800 | 12605 | 11550 | 10557 | 8762
0 | 1120 | 1504 | 2053 | 2622 | 3089 | 4132 | 5207 | 5974 | 6359 | 6842 | 7941 | 9136 | 10191 | 11184 | 12979
From [A4 till P4] I need to write IF statement to make a calculation as following:-
1-whenever [A1:P1] changed from sequence (10) to (12) then under [F4] the formula will be [(F3-A3)/A2%)]
2-whenever [A1:P1] changed from sequence (12) to (15) then under [K4] the formula will be [(K3-F3)/F2%)]
3-whenever [A1:P1] changed from sequence (15) to (20) then under [O4] the formula will be [(O3-K3)/K2%)]
Spreadsheet: 825970d1681707914-sort-formula-sort-by-aligw
Sheet: Sheet1

Name | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
Michelle | 3890 | 3529 | 2803 | 3534 | 2668 | 4608 | 2882 | 4901 | 1536 | 3952 | 4578 | 2009
[NAME] | 3672 | 2442 | 1993 | 4427 | 2861 | 1298 | 1364 | 2953 | 4149 | 1614 | 4918 | 1970
Addy | 3791 | 4463 | 1324 | 3798 | 3278 | 1253 | 2443 | 4154 | 2794 | 4801 | 1543 | 4876
[NAME] | 1138 | 1050 | 3527 | 3936 | 1512 | 3500 | 2494 | 1890 | 3558 | 4902 | 3075 | 4280
 | Sort By Name |  | Sort By Month |  | Manually |  |  |  |  |  | How do I get the Name of the Person and Sort it by biggest to smallest?
 |  |  |  |  | 2022-04-30 00:00:00 | To Show the month instead of the amount
 | Addy |  | Oct'22 |  | 2022-10-31 00:00:00 |  |  |  |  |  | How do I get the Date and Sort it by biggest to smallest?
 | [NAME] |  | Nov'22 |  | 2022-11-30 00:00:00
 | [NAME] |  | [NAME] |  | 2022-08-31 00:00:00
 |  |  | [NAME] |  | 2022-12-31 00:00:00
 |  |  | [NAME] |  | 2022-01-31 00:00:00
 |  |  | Sep'22 |  | 2022-09-30 00:00:00
 |  |  | Feb'22 |  | 2022-02-28 00:00:00
 |  |  | Jun'22 |  | 2022-06-30 00:00:00
 |  |  | May'22 |  | 2022-05-31 00:00:00
 |  |  | Mar'22 |  | 2022-03-31 00:00:00
 |  |  | Jul'22 |  | 44773
Spreadsheet: 287686d1388941450-creating-a-specific-list-from-large-data-set-collections-proposal-ndm
Sheet: Basic Cust Data

 |  |  | AMT NET TAX | NUMBER OF SCHEDULED PAYMENTS | NUMBER of PAYMENTS REMAINING | 1-ACTIVE     2-PAID OFF 3-REPO'D | PAYOFF AMT RCVD | ACTIVE MO PAYMENT INCL SALES TAX
1 | XXX0001 | CUST0001 | 1645 | 35 |  | 1
2 | XXX0002 | CUST0002 | 2105 | 35 |  | 1
3 | XXX0003 | CUST0003 | 1745 | 35 |  | 1
4 | XXX0004 | CUST0004 | 4745 | 35 |  | 1
5 | XXX0005 | CUST0005 | 1950 | 35 |  | 1
Spreadsheet: 741365d1626990400-how-do-i-add-multiple-events-under-the-date-from-a-table-with-range-of-dates-calendar
Sheet: Events

 | Events
 | Start Date | End Date | Start Date | End Date
 | 2021-07-05 00:00:00
 | 2021-08-02 00:00:00
 | 2021-09-06 00:00:00
 | 2021-10-04 00:00:00
 | 2021-11-08 00:00:00
 | 2021-12-06 00:00:00
 | 2022-01-03 00:00:00
 | 2022-02-07 00:00:00
 | 2022-03-07 00:00:00
 | Start Date | End Date | Start Date | End Date
 | 2021-08-23 00:00:00 | 2021-08-27 00:00:00 | 2021-09-27 00:00:00 | 2021-10-01 00:00:00
 | 2021-11-08 00:00:00 | 2021-11-12 00:00:00 | 2021-12-06 00:00:00 | 2021-12-10 00:00:00
 | Start Date | End Date | Start Date | End Date
 | 2021-09-13 00:00:00 | 2021-09-17 00:00:00
 | 2021-11-08 00:00:00 | 2021-11-12 00:00:00
 | Start Date | End Date
 | 2021-08-11 00:00:00 | 2021-08-13 00:00:00
 | 2021-10-26 00:00:00 | 2021-10-28 00:00:00
 | Event Name | Start Date | End Date
 |  | 2021-09-06 00:00:00 | 2021-09-14 00:00:00
 |  | 2021-10-04 00:00:00 | 2021-10-08 00:00:00
 |  | 2021-11-01 00:00:00 | 2021-11-10 00:00:00
Spreadsheet: 88468d1288276677-totaling-qtys-from-multiple-tabs-materialsummary-array
Sheet: B2-Str

TH-10M02-w C4758-B2 Hughes Truss Assembly
Qty | Part # | Description |  |  |  |  |  |  | Midwest Part Number
 |  | [NAME]
1 | C3316.87AL | Assembled arm with the hughes assemblies shown below
2 | C3316.87A-1L | [NAME] Assembly--5 1/8" x 7 1/2" x 30' -0" Laminate Arm (assembled)
3 | 3414.2WF-100 | Adjustable Spacer Fitting with 2-3414.2WF body section & 1-3414-100 side plate & HB62-1-1/2 5/8 x2" Hex Bolt with MFH60
6 | 3414.2WF | Body Section
3 | 3414-100 | Side Plate
6 | HB62-1-1/2 | 5/8" x 2" Hex Bolt with MFH60
12 | WB66-1/2-1-3/4 | 5/8" x 6-1/2" WH Bolt
6 | WB58-1/2 | 1/2" x 8-1/2" WH bolt
 |  | Not assembled with above
1 | [NAME] | 5" x 3" x 1/4" x 15'-6" angle iron
 |  | Hughes Arm Mounting Hardware
2 | TR830-5 | 7/8" x 30 Thr'd Rods with 2 MF80 &2 2727.8
4 | MF80
8 | 2727.8 | 7/8" Bonding Clip
4 | N80 | 7/8" Nut
2 | SLW2-80 | 7/8" Spring Washer
4 | A783.1W-15 | 1W-15 Gain Fitting
 |  | Hughes X-Brace and X-Brace Mounting Hardware
1 | 2094-14-6 | 14'-6" X-Brace
2 | 2840.1C | Center Clamp Rod
2 | 2840.2G | Center Clamp Strap
2 | B818-6 | 7/8" x 18" Bolt with CW80 & MF80,2727.8 & extra N80
2 | B816-6 | 7/8' x 16" Bolt with CW80 & MF80,2727.8 & extra N80
4 | 2025ACV114 | Vee Brace, 9'-6" CC Holes, 8'-10' W.L. 30 & 45 deg. Fittings (3-3/8" x4-3/8 wood sect.)
1 | 2722.1D-B | 7/8" [NAME]
2 | 2722.1B-B | 7/8" [NAME]
2 | B814-6 | 7/8" x 14" Bolt, T=6" with MF80, 2727.8 w MF80, 2727.8 and extra N80
4 | 2702.8 | 7/8" Spring Washer
4 | YC4C4 | Connector Crimpit #4 CU to #4 CU ([NAME])
10 | CW80 | Curved Washer
6 | MF80
6 | 2727.8 | 7/8" Bonding Clip
6 | N80 | 7/8" Nut
 |  | Shield Wire Support-TM4/6M1-2 per tangent structure
6' | 8669-000250 | Wire-Flexible CU Braid (Belden)
4 | 989.1 | Damper-Spiral for 3/8" (PLP 5050104)
2 | 904 | Clamp-Parallel Grove 3/8" HS-#4 CU ([NAME])
10 ft | 833 | Conductor-Grd Wire #4 CU [NAME]
4 | YC4C4 | Connector-Crimpit #4 CU to #4CU ([NAME])
2 | 689.1 | Clamp-AGSusp w/Armor Rod (PLP AGS-7104)
2 | 1690.14 | 1501.6-14-B1CL 14" Shield wire Support (Hughes Brothers)
2 | B814-6 | 7/8" x 14" Bolt, T=6" with MF80, 2727.8 and extra N80
2 | MF80
2 | 2727.8 | 7/8" Bonding Clip
2 | N80 | 7/8" Nut
 |  | Ground Assembly-TM-9M1--2 per tangent structure
200 ft | #4 | Ground wire #4 Bare
2 | 632 | Cadweld-Type GT or Erico HammerLock EH58C1K (0632)
2 | 1445 | Coupling-Ground Rod 5/8"
4 | YC4C4 | Connector -Crimpit #4 to #4 Cu (BurndY YC4C4)
2 | 2501.1 | Molding-Wood 1" x 10' (Hughes 2501.1)
10 | 250174 | Staples-Galv. For Wood Molding (Hughes 250174)
30 | [NAME] | Staples-CU Coated Grd. Wire 2 x 1/2" x .162 ([NAME] or Chance 9169)
60 | 16D | Nails-Hot Dipped Galv.-for the Clips (16d)
60 | K5730-1 | Clips-Grd Wire Non-Static (Kearney 5730-1)
2 | 5/8" x 8' CW | [NAME]
 |  | Insulators  Assembly  [NAME]--three per tangent str
3 | SA-11 | Socket Eye
3 | AGS-5130 | Clamp-AGS   susp w/[NAME] for 795 ACSR "Drake"
3 | 1165.2 | Insulator-Susp 115 kV y [NAME] (OB S025036S2010)
3 | 2824 | Eye Bolt & Saddle 3/4" (Hughes 2824)
Spreadsheet: 736684d1623805290-need-to-fetch-latest-records-from-lookup-table-with-first-and-last-name-combination-new-microsoft-excel-worksheet-autorecovered-1-
Sheet: Sheet2

Member | Name
Mandalparthy | [NAME]
Priyanka | [NAME]
Balineni | Balineni
Chekuboyina | [NAME]
Anudeep | Polavarapu
Srinivasa | [NAME]
[NAME] | [NAME]
Samba | [NAME]
Sreenivasu | Bammireddi
Mousum | Chetia
Soumitra | Burman
[NAME] | [NAME]
Sunkara | Sunkara
Mohit | Sinha
Mansoor | Mansoor
Priyanka | Gottimukkala
Spreadsheet: 161580d1339566251-filter-excel-data-in-groupe-by-mode-problem
Sheet: Sheet1

City | Code |  | Result
Mumbai | 1 |  | 1 | Mumbai,SG
Delhi | 3 |  | 2 | Chennai,MPL
Chennai | 2 |  | 3 | Delhi,CPL
BLR | 7 |  | 4 | CPL
BPL | 3 |  | 7 | BLR
CPL | 4
MPL | 2
SG | 1
Spreadsheet: 61241d1262066538-cell-range-displacement-floating-ranges
Sheet: Sheet1

205 | Address builder-> | A4:A15 | Test sum formula using INDIRECT-> | 2310 | Test with one formula -> | 2310
221
208
121
237
276
324
153
8
22
158
309
72
234
396
Spreadsheet: 1115131a-a58d-4b53-9aa1-4fd448ea36dc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 | Fig. 6.5.13 - Comuni del Veneto, con il maggior numero di movimenti pendolari in entrata per studio e lavoro - Anno 2001
 | Fonte: [NAME] Sistema Statistico Regionale e Università di Padova - DCT Lab. Trasporti su dati Istat
 | Comuni del Veneto, con il maggior numero di movimenti pendolari in entrata per studio e lavoro - Anno 2001
 |  | Numero di spostamenti 2001
 | Venezia | 169538
 | Padova | 166947
 | [NAME] | 160358
 | [NAME] | 80863
 | Treviso | 60788
 | Rovigo | 31413
 | Bassano del Grappa | 29850
 | [NAME] | 24723
 | Schio | 24696
 | Conegliano | 21544
 | Belluno | 21127
 | San Dona' di Piave | 20369
 | Chioggia | 19655
 | Montebelluna | 19437
 | Thiene | 17771
 | Arzignano | 16808
 | [NAME] | 16190
 | Cittadella | 14603
 | Legnago | 14500
 | [NAME] | 14413
 | Mirano | 14388
 | Portogruaro | 13844
 | Este | 12550
 | Feltre | 12541
 | [NAME] | 12455
 | Montecchio Maggiore | 12236
 | San Bonifacio | 11913
 | Villorba | 11599
 | [NAME] | 11495
 | Adria | 11342
 | Monselice | 11294
 | [NAME] | 11189
 | Oderzo | 10945
 | [NAME] | 10874
 | Abano Terme | 10783
 | Iesolo | 10553
 | Mira | 10540
 | Bussolengo | 9905
 | San Martino Buon Albergo | 8729
 | Lonigo | 8367
 | Fonte: [NAME] Sistema Statistico Regionale e Università di Padova - DCT Lab. Trasporti su dati Istat
Spreadsheet: 144472d1330984581-searching-for-text-across-different-sheets-grocery-list
Sheet: Wk1 Shopping List

Produce | Quan. | Cost | Isle 1 | Quan. | Cost
Apples/lb | 3 | 7.791119999999999 | Balsamic Vinegar | 1 | 8.635158
Avacado | 4 | 8.613516 | Black Beans/lb | 2 | 3.657498
Total | 28.697292
Spreadsheet: 782759d1654243900-number-of-shared-letters-including-duplicates-between-text-in-two-cells-spreadsheet-for-excel-forum
Sheet: Letter Strings & Shared Letters

Letter String A | Letter String B | # of SL Required | # of SL Formula Output
blume | bloom | 3
brede | breed | 5
cheaze | cheese | 4
cheeze | cheese | 5
cherch | church | 5
pheere | fear | 2
fierse | fierce | 5
reache | reach | 5
rheef | reef | 4
rooph | roof | 3
staite | state | 5
tont | taunt | 3
wheed | weed | 4
werque | work | 2
Spreadsheet: 139179d1328116980-printing-individual-forms-from-a-table-test-log1
Sheet: Form

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 | 32 | 33 | 34
New Page | Pres Order | Old Page | Description / Page Name | Level | Site map code | Site map code notes | Phase | Template | Title (that appears in browser at top of page) | URL www.phoenixlife.co.uk/… | Breadcrumb | Notes | CTA1 | Link CTA 1 | CTA2 | Link CTA2 | CTA3 | Link CTA 3 | [NAME] | Link CTA 4 | GTK | Link GTK | Tech brief sent | Copy briefing sent | Progress Rating | Copy Progress | Project Manager | Need Outsourcer Approval? | Owner | Compliance | Legal | Other | Review Date / Occurrence ?
 | REMEMEBER THAT THE SHEET MUST BE SORTED BY PAGE NUMBER TO WORK
 | Page | Ha12 | I want cell in red to automatically go through all of the rows in the date HA12 and HN12 and print the resultant form. (Note the form is not finished!!)
 | Site map code | 2.12.2.2
 | Page Title | Its a wonderful Life Customer Centre - Glasgow - change your address
 | Project owner | 0
 | Please can you make sure that you check the following
 |  |  |  |  | Confirm copy | Confirm Link to correct page | If external to site does warning pop up | Comment
 | CTA 1 | Contact Us If you can't find the information you're looking for > contact us (Link to C7) | C7 | #N/A
 | CTA 2 | 0 | 0 | #N/A
 | CTA 3 | 0 | 0 | #N/A
 | [NAME] | 0 | 0 | #N/A
 | GTK | 0 | 0 | #N/A
 | Can you confirm that
 | All hyperlinks work
 | Copy on page matches
Spreadsheet: daren_farmer__5893__hpl0602
Sheet: Sheet1

HPLN0602.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 02, 2000
 |  |  |  |  |  | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-06-02 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
Enron (FM) |  | LS HPL [NAME] |  | HPL | 40 | 40
Enron (FM) |  | HPL - Texoma |  | HPL | 20 | 20
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | ENA | 5 | 0
Enron (S) |  | Oasis Sealy |  | ENA | 25 | 0
Enron (ES) |  | Reklaw |  | ENA | 30 | 30
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65
Empire (Enron) |  | Delhi TOG #3 |  | Empire | 1.4 | 1.4
Empire (Enron) |  | Oasis Turbine |  | Empire | 7.95 | 7.95
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 160562d1339111441-excel-2007-index-with-duplicates-department-updates-and-announcements
Sheet: Raw Announcements

 | Employee Announcements
Department | Mgr Flag | Update
Claims | Manager | all employees are fired
Claims |  | never mind
Compliance |  | Message3
Finance |  | Message4
HRODSSI |  | Message5
Information_Systems |  | Message6
Medical_Management |  | Message7
Claims | Manager | Message8
Compliance | Manager | Message9
Claims |  | Message10
Claims | Manager | Message11
Claims |  | Message12
Claims |  | Message13
Claims |  | Message14
Claims |  | Message15
Claims |  | Message16
Claims |  | Message17
Claims |  | Message18
Claims |  | Message19
Claims |  | Message20
Claims |  | Message21
Claims |  | Message22
Claims |  | Message23
Claims |  | Message24
Claims |  | Message25
Claims |  | Message26
Claims |  | Message27
Claims |  | Message28
Claims |  | Message29
Claims |  | Message30
Claims |  | Message31
Claims |  | Message32
Claims |  | Message33
Claims |  | Message34
Claims |  | Message35
Claims |  | Message36
Claims |  | Message37
Claims |  | Message38
Claims |  | Message39
Claims |  | Message40
Claims |  | Message41
Claims |  | Message42
Claims |  | Message43
Claims |  | Message44
Claims |  | Message45
Claims |  | Message46
Claims |  | Message47
Claims |  | Message48
Claims |  | Message49
Claims |  | Message50
Claims |  | Message51
Claims |  | Message52
Claims |  | Message53
Claims |  | Message54
Claims |  | Message55
Claims |  | Message56
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Claims
Spreadsheet: 700120d1602967163-merge-two-ranges-into-one-merge-two-ranges
Sheet: Sheet1

 |  | Data from external document |  |  |  |  |  | Data from external document |  |  |  |  | Desired result
 |  | Criss | 23 | Blue |  |  |  | Curt | 23 | Gray |  | My failed try: | =(C6:E8)(=FILTER(I6:K10;ISNUMBER(MATCH(I6:I10;H14:H19;0))))
 |  | Anna | 43 | Green |  |  |  | [NAME] | 42 | White |  |  | Criss | 23 | Blue
 |  | [NAME] | 21 | Red |  |  |  | [NAME] | 15 | Blue |  |  | Anna | 43 | Green
 |  | Hans | 11 | Orange |  |  |  | [NAME] | 23 | Yellow |  |  | [NAME] | 21 | Red
 |  | [NAME] | 43 | Black |  |  |  | Emma | 16 | Purple |  |  | [NAME] | 42 | White
 |  |  |  |  |  |  |  |  |  |  |  |  | Emma | 16 | Purple
 |  | My selection from data |  |  |  |  | My selection from data
 |  | =C6:E8 |  |  |  |  |  | =FILTER(I6:K10;ISNUMBER(MATCH(I6:I10;H14:H19;0)))
 |  |  | 23 | Blue |  |  | Emma |  | 42 | White
 |  | Anna | 43 | Green |  |  | [NAME] | Emma | 16 | Purple
 |  | [NAME] | 21 | Red