tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56584d1256750257-find-last-data-entry-example
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6
RED | w | l |  |  | w |  | w
BLUE |  | l | p | w |  | w | w
GREEN | w | l | p | l |  |  | l
YELLOW |  | p |  |  | w |  | w
Spreadsheet: 786354d1657124712-highlight-closest-value-closestvalue
Sheet: Sheet1

 | sys 1 | Rev | [NAME]
Fri | 318 | 303 | 308
Sat | 80 | 71 | 84
Sun | 77 | 62 | 82
Mon | 281 | 209 | 375
Tue | 427 | 382 | 406
 | 12 | 11 | 10
End result
 | sys 1 | Rev | [NAME]
Fri | 318 | 303 | 308
Sat | 80 | 71 | 84
Sun | 77 | 62 | 82
Mon | 281 | 209 | 375
Tue | 427 | 382 | 406
Spreadsheet: 95602d1295211450-picking-up-just-one-column-of-data-and-combining-forum-sample-15
Sheet: SAMPLE A

8 |  |  |  | 7 |  |  |  | 5
NUM |  |  |  | NUM |  |  |  | NUM
804 |  |  |  | 074 |  |  |  | 405 |  |  |  | H1: =IFERROR(INDEX(G:G,SMALL(INDEX(($G$9:$G$59<>"")*ROW($G$9:$G$59),0),ROWS($1:1)+COUNTIF($G$9:$G$59,""))),"")
813 |  |  |  | 317 |  |  |  | 342
282 |  |  |  | 272 |  |  |  | 414
805 |  |  |  | 570 |  |  |  | 046
814 |  |  |  | 174 |  |  |  | 154
382 |  |  |  | 273 |  |  |  | 244
581 |  |  |  | 760 |  |  |  | 334
428 |  |  |  | 517 |  |  |  | 074
870 |  |  |  | 472 |  |  |  | 614
618 |  |  |  | 373 |  |  |  | 542
528 |  |  |  | 770 |  |  |  | 344
438 |  |  |  | 176 |  |  |  | 804
808 |  |  |  | 752 |  |  |  | 174
187 |  |  |  | 347 |  |  |  | 642
268 |  |  |  | 870 |  |  |  | 543
484 |  |  |  | 177 |  |  |  | 049
089 |  |  |  | 762 |  |  |  | 814
188 |  |  |  | 357 |  |  |  | 472
728 |  |  |  | 447 |  |  |  | 436
638 |  |  |  | 907 |  |  |  | 445
485 |  |  |  | 187 |  |  |  | 419
189 |  |  |  | 277 |  |  |  | 428
378 |  |  |  | 637 |  |  |  | 347
684 |  |  |  | 475 |  |  |  | 464
855 |  |  |  | 179 |  |  |  | 249
289 |  |  |  | 728 |  |  |  | 438
865 |  |  |  | 377 |  |  |  | 447
389 |  |  |  | 467 |  |  |  | 456
848 |  |  |  | 557 |  |  |  | 484
578 |  |  |  | 792 |  |  |  | 475
866 |  |  |  | 378 |  |  |  | 466
 |  |  |  | 567 |  |  |  | 449
 |  |  |  | 739 |  |  |  | 485
 |  |  |  | 577 |  |  |  | 467
 |  |  |  | 766 |  |  |  | 954
 |  |  |  | 497 |  |  |  | 684
 |  |  |  | 578 |  |  |  | 877
 |  |  |  | 767
Spreadsheet: juan_hernandez__17712__Bkrqs839
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | Book Request #839
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | [NAME] | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
EPMI-ERCOT-SVCE | EPMI-ERCOT-SVCE |  |  | X | [K | R6 | X |  |  |  |  |  | PWR/MWHR/USD | [NAME] | MTM | Services Agrmt | 2001-07-30 00:00:00
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Access List | Administrator*
trohaue |  |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | JB
[NAME] | adahlke | [NAME] |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | JB
Casey Evans | cevans | [NAME] |  |  |  |  |  |  |  |  |  |  | Master booklist |  | Y | JB
[NAME] | jlewis | [NAME] |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | JB
[NAME] | [NAME] | [NAME] ([NAME]) [NAME] |  |  |  |  |  |  |  |  |  |  | Sent to TAGG/ERMS |  | - | -
[NAME] | tchapm2 | [NAME] |  |  |  |  |  |  |  |  |  |  | Active/Inactive Book List
[NAME] | tcarter | [NAME]
[NAME] | wfrankl2 | [NAME]
[NAME] | jmiller | [NAME] |  |  |  |  |  |  |  |  |  |  | Any questions, please contact :
[NAME] | tmay | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52465)
[NAME] | kcoulter | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52526)
[NAME] | jforney | Reese [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | (x57197)
[NAME] | cdean | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | (x31462)
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | ([NAME])
[NAME]
Spreadsheet: 708023d1607589493-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: UK

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 187002d1350315500-jump-to-a-particular-worksheet-based-on-the-current-cells-value-jump_example1
Sheet: Sorted_Summary

Electrical Usage Summary by Facility
Location |  | Address |  | Ga Power (GP)  or Greystone (GS) | Average (Jun 09 - Nov 11)1 |  |  |  |  |  | Account Number | Meter  No.
 |  |  | Type |  | Electricity Usage ([NAME]) | Monthly Charge | Other/ Non-Coincident $ | Power Cost Adjustment (PCA) $ | Base Charge | Cost/ KWH
1 | [NAME]
2 | [NAME]
3 | Arbor Place LS
4 | [NAME]
5 | Ashworth LS
6 | [NAME]
7 | Automatic Valve
8 | Bear Creek Lab Bldg
9 | Bear Creek Pump Station
10 | Bear Creek Lights
11 | Bear Creek WTP
12 | Bearden Landing LS
13 | [NAME]
14 | [NAME]
15 | [NAME]
16 | [NAME] Security Lights
17 | Blairs Bridge LS
18 | Boundry Waters Aquatic Cntr
19 | Brookfield LS
20 | Brookmont 1 LS
21 | Brookmont 2 LS
22 | Brookstone LS
23 | Cedar Place LS
24 | Cedar Terrace LS
25 | Chapel Hill Farms LS
26 | [NAME] LS
27 | [NAME]
28 | Concourse LS
29 | Crooked Creek LS
30 | Dog River Pump Station No. 1
31 | Dog River Pump Station No. 2
32 | Dog River Pump Station No. 2A
33 | [NAME] LS
34 | Favors SCADA
35 | Ferncrest [NAME]
36 | Field Complex
37 | Field Complex Lights
38 | Gates
39 | Golf Ridge No. 11
40 | Golf Ridge No. 21
41 | Gothards Creek
42 | [NAME] Rd LS
43 | [NAME] Station1
44 | [NAME]
45 | Hidden Creek LS
46 | House
47 | Houston St LS
48 | Hunters Ridge1
49 | Hwy 5 LS
50 | Hwy 78 Booster
51 | Hwy 92 Tank
52 | Hwy 166 Pump Station
53 | I-20
54 | Iroquis Park
55 | Ivy Green LS
56 | [NAME]
57 | [NAME]
58 | [NAME]
59 | Lions Gate
60 | Lower River LS
61 | Main Office
62 | Malone Rd LS
63 | McCoy Tank
64 | MCI
65 | Meadowview LS
66 | [NAME] (Burnt Hickory LS)
67 | [NAME]
68 | Monitoring Station
69 | Mount Vernon Elementary
70 | New Manchester "R"
71 | New Manchester Elem1
72 | N [NAME]
73 | Northside
74 | Paces Estates
75 | [NAME]
76 | [NAME]
77 | Rebel Trails WWTP
78 | Rebel Trails LS
79 | Red Lodge - Anneewakee Trls #1
80 | Retreat
81 | Rising Fawn1
82 | Riverside LS
83 | Riverstone LS
84 | Rodgers Creek
85 | SCADA Tower1
86 | [NAME]
87 | South Central
88 | South Central Lights
89 | South Central Influent Lift Station
90 | South Central Old Reject Pond
91 | Southside LS
92 | St Andrews Main
93 | St Andrews N LS
94 | Stone Bridge LS
95 | Sweetwater Influent Lift Station
96 | Sweetwater Treatment Plant #1
97 | Sweetwater Treatment Plant #2
98 | Sweetwater Terrace
99 | Terrace [NAME]
100 | Tributary1
101 | Tributary No. 32
102 | Tyree Rd1
103 | View at Cedar Mt
104 | View at Cedar Mt 21
105 | West Banks Mill Tank
106 | Westbrook LS
107 | Yeager Middle School LS
Total |  |  |  |  | 0 | 0 | 0 | 0 | 0
AVG (per site)
[NAME] |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | Notes
 | 1 - These site have less months of data than other sites.
 | 2 - Tributary No. 3 is a new account started this year (2011).
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 12b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending December 14, by product type and supermajor currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
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 currency 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: 861413d1709280827-index-match-help-race-2
Sheet: Course 

CAUL |  |  | Good | Soft | Heav
CAUL
CAUL | 1000 |  | 56.7 | 57.6
CAUL | 1100 |  | 62.3 | 63.2 | 66.3
CAUL | 1200 |  | 68.4 | 70.1 | 72.6
CAUL | 1400 |  | 81.5 | 83.8 | 86.9
CAUL | 1600 |  | 96.2 | 96.6 | 101.4
CAUL | 1700 |  | 103.9 | 104 | 106.3
CAUL | 1800 |  | 108.5 | 110.7
CAUL | 2000 |  | 120.7 | 123.6 | 127.1
CAUL | 2400 |  | 146.5 | 151.7
FLEM |  |  | Good | Soft | Heav
FLEM
FLEM | 1000 |  | 56.2 | 56.5
FLEM | 1100 |  | 62.5 | 62.5 | 66.1
FLEM | 1200 |  | 68.2 | 68.2
FLEM | 1400 |  | 81.2 | 81.2
FLEM | 1600 |  | 94.8 | 94.9
FLEM | 1700 |  | 101.8 | 101.8
FLEM | 1800 |  | 108.4 | 108.4 | 114
FLEM | 2000 |  | 120.6 | 120.6
FLEM | 2510 |  | 156.7 | 156.7
SANL |  |  | Good | Soft | Heav
SANL
SANL | 1200 |  | 70 | 70.5 | 73.4
SANL | 1300 |  | 77.7 | 78 | 81.3
SANL | 1400 |  | 83 | 82.8 | 88.45
SANL | 1500 |  | 90.2 | 89.1
SANL | 1600 |  | 95.8 | 97 | 99.8
SANL | 2100 |  | 130.1 | 130.9 | 135.7
SANL | 2400 |  | 150.5 | 152.9 | 155
SANH |  |  | Good | Soft | Heav
SANH
SANH | 1000 |  | 55.1 | 56.1 | 59.2
SANH | 1300 |  | 76 | 77.7 | 81.6
SANH | 1400 |  | 82.5 | 83.7 | 87.7
SANH | 1500 |  | 89.3 | 90.5
SANH | 1600 |  | 95.1 | 97.8
SANH | 1800 |  | 108.3 | 108.9 | 113.9
SANH | 2400 |  | 149.5 | 150.8 | 259.9
M V |  |  | Good | Soft | Heav
M V
M V | 955 |  | 54.6 | 55.7 | 57.9
M V | 1000 |  | 56.5 | 57.5 | 59.7
M V | 1200 |  | 69.4 | 70.5 | 71.6
M V | 1500 |  | 89.3 | 92.2 | 94.4
M V | 1600 |  | 94.4 | 96 | 98.4
M V | 2040 |  | 123.2 | 126 | 130.2
M V | 2500 |  | 155.2 | 156.6 | 159.4
M V | 3000 |  | 189.3 | 196.7
Spreadsheet: 874067d1720633405-planner-pq-planner
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | End
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-01-04 00:00:00 | 2025-12-31 00:00:00
1/4/2025 | 1/11/2025 | 1/18/2025 | 1/25/2025 | 2/1/2025 | 2/8/2025 | 2/15/2025 | 2/22/2025 | 3/1/2025 | 3/8/2025 | 3/15/2025 | 3/22/2025 | 3/29/2025 | 4/5/2025 | 4/12/2025 | 4/19/2025 | 4/26/2025 | 5/3/2025 | 5/10/2025 | 5/17/2025 | 5/24/2025 | 5/31/2025 | 6/7/2025 | 6/14/2025 | 6/21/2025 | 6/28/2025 | 7/5/2025 | 7/12/2025 | 7/19/2025 | 7/26/2025 | 8/2/2025 | [NAME] | 8/16/2025 | 8/23/2025 | 8/30/2025 | 9/6/2025 | 9/13/2025 | 9/20/2025 | 9/27/2025 | 10/4/2025 | 10/11/2025 | 10/18/2025 | 10/25/2025 | 11/1/2025 | 11/8/2025 | 11/15/2025 | 11/22/2025 | 11/29/2025 | 12/6/2025 | 12/13/2025 | 12/20/2025 | 12/27/2025
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 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 16b

 |  | TOTAL
Product |  | HY** | IG | Other
Index Tranche* | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending July 26, by product type (total value of trades in millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
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 Data Dictionary for product descriptions.
**See Data Dictionary for product grade 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: 121708d1316307108-excel-2008-drop-down-function-do-you-mean-something-like-this
Sheet: Sheet1

Leaderboard | Flash 10 or below, GIF, [NAME], HTML | 728x90 | 728x270 | down | on click | user-initiated | Yes | 50K | 100K | 150K | 2.5MB | 0:15 or 3x | 24fps | None | Yes
[NAME] | Flash 10 or below, GIF, [NAME], HTML | 300x250 | 600X500 | left | on click | user-initiated | Yes | 50K | 100K | 150K | 2.5MB | 0:15 or 3x | 24fps | None | Yes
Pre-roll | MOV, FLV | 640x360 | 0.01041666666666667 | N/A | N/A | Yes | N/A | N/A | N/A | N/A | 500K | N/A | 24fps | 1/3 Video Views | Yes
Prestitial | Flash 10 or below, GIF, [NAME], HTML | 600x400 | 0.1041666666666667 | N/A | N/A | user-initiated | Yes | 50K | 100K | 150K | 2.5MB | 0:15 or 3x | 24fps | 1/24 | Yes
Red Carpet Unit | GIF, JPG | 240x120 | Custom Built Internally - 240x120 Image Asset Required |  |  |  |  |  |  |  |  |  |  |  | 1x1
Skin | GIF, JPG | 1500x1000 | N/A | N/A | N/A | No | No | 150K | N/A | 150K | N/A | N/A | N/A | None | 1x1
Video Marquee | MOV, FLV | 1010x150 | 0.1041666666666667 | N/A | N/A | user-initiated | N/A | 50K | 100K | 150K | 2.5MB | N/A | 24fps | None | 1x1
Spreadsheet: 786429d1657191071-calculating-whether-a-range-of-values-falls-inside-or-outside-of-a-min-and-max-range-risk-appetite-tracker-sample-file
Sheet: Key Risk Metrics - Master

[NAME] | SMT Owner | Key Risk Indicator | Jun 22 Actual | Jul 22 Actual | Aug 22 Actual | Sep 22 Actual | Oct 22 Value | Nov-22 Actual | [NAME] | [NAME] | Feb-23 Actual | Mar-23 Actual | KRI Trend | KRI Flag | Minimum Threshold | [NAME] | [NAME]
Category 1 | JB | KRI 1 % of… | -0.055 | -0.04 |  |  |  |  |  |  |  |  | OK |  | -0.05 | 0.05 | Inside
Category 2 | SD | KRI 2 No. of | 159000 | 300000 |  |  |  |  |  |  |  |  | OK |  | £500K | £2M | Inside
Category 3 | SD | KRI 3 No. of | 0 | 2 |  |  |  |  |  |  |  |  | OK |  | 0 | 5 | Inside
Category 3 | JB | KRI 4 No. of | 0 | 3 |  |  |  |  |  |  |  |  | Worried |  | 0 | 5 | Inside
Category 3 | AL | KRI 5  % of… | 0.97 | 0.93 |  |  |  |  |  |  |  |  | Worried |  | 0.95 | 0.9 | Outside
Category 2 | AL | KRI 6 No of… | 3 | 3 |  |  |  |  |  |  |  |  | No Change |  | 1 | 5 | Inside
Category 1 | SD | KRI 7  % of… | 0.15 | 0.12 |  |  |  |  |  |  |  |  | OK |  | 0.03 | 0.2 | Inside
Category 1 | JB | KRI 8  % of… | 0.28 | 0.15 |  |  |  |  |  |  |  |  | OK |  | 0.1 | 0.35 | Inside
Spreadsheet: 672944d1587083450-help-with-wrap-text-and-autofit-row-height-between-multiple-sheets-treasurer-report-with-formatting-removed
Sheet: Check Register

 | Check Register |  | Current Balance
 | Spending Summary |  | Check # | Date | Payable To/Received From | Description | Category | Withdrawal (-) | Deposit (+) | Balance
 | Category | Total |  | 2019-05-31 00:00:00 |  | Beginning Balance | Beginning Balance |  | 1
 | Beginning Balance |  |  | 2019-06-01 00:00:00 |  | kalsdfgja;kdgja;gija;lkcbha;lkgjha;igakldah;lkfdgha;kfdg |  |  | 100
 | Member [NAME] |  |  | 2019-06-02 00:00:00 |  | kadglj;sdgja;lksdgja;klsdgja;dklsgja;kldgja;kldjg;ad |  | 100
 | Golf Outing Income
 | Golf Outing Expenses
 | [NAME] Income
 | [NAME] Expenses
 | Trade Show Income
 | Trade Show Expenses
 | Monthly Meetings
 | Secretary Expenses
 | Scholarship
 | Other Income
 | Other Expenses
Spreadsheet: 552847d1513799375-make-text-white-depending-on-another-cell-white-text
Sheet: Surface Drainage

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to hide |  |  |  | to hide |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  | Adjust less for RL Strip | Adjust Add for pipe bed |  |  | [NAME] |  |  |  | Deposit spoil | Bed & Surround | B & S Depth | Backfill | Backfill Depth | Pipe Material | In Existing Highway | In Existing Highway | Spoil Volume with Stone Backfill | Spoil Volume Excavated Backfill | Spoil Volume for Reference | Excavate Trench | [NAME] On Site | Cart Away Spoil Off Site | [NAME] | EWS | L & C | [NAME] | Backfill Stone | Backfill |  | Pipe |  | Rocker |  | Junction | Bed & Surround Concrete | Bed & Surround Stone | Bed & Surround Concrete | Bed & Surround Stone | Bed & Surround Stone |  | Total | O / H & Profit | Total
FROM |  | TO |  |  |  | Average | Run |  | Pipe | E.O. | E.O. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pipe |  | Rockers |  | Junction
M/H Ref. |  | M/H Ref. |  |  |  | [NAME]. | Length |  | Ø | Rockers | Junctions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rate |  | Rate |  | Rate
 |  |  |  |  |  | (m) | (m) |  | (m) | (nr) | (nr)
1.1 |  | 1.2 |  | 0 | 0 |  | 23 | 0.9 | 0.6 | 2 | 2 | Off Site | Stone |  | Stone |  | Concrete | No
1.2 |  | 2.1 |  | 0 | 0 |  | 15 | 0.9 | 0.6 | 2 |  | Off Site | Stone |  | Stone |  | Concrete | No
1.2 |  | 2.2 |  | 0 | 0 |  | 6 | 0.6 | 0.15 | 2 |  | Off Site | Stone |  | Stone |  | Concrete | No
Spreadsheet: 468144d1467143565-convert-comma-separated-string-into-column-with-adjacent-rows-data-ef925_expand_dated_records
Sheet: Sheet1

Cust Name | Cust Offering | Amount | Date |  | 0
Cust A | Product B | 10000 | Mar-17, Apr-18
Cust B | Product A | 0 | N/A
Cust C | Product G | 25000 | Jan-17, Oct-18, Nov-18, Feb-19
Cust D | Product A | 15000 | Dec-18, Jan-20
Cust Name | Cust Offering | Amount | Date
Spreadsheet: 235111d1368358006-filtering-an-excel-calendar-multiple-entires-per-cell-master
Sheet: Calendar

Master event [NAME]
Date | January | February | March | April | May | June | July | August | September | October | November | December
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
Spreadsheet: 814167d1674201221-if-b5-b128-contain-words-sum-left-hand-side-value-of-those-ask
Sheet: 架步扣數一覽表

 | 架步no. | 分判 | 簽收未 | 開始使用 | 簽收人 | 2022扣 [NAME]
架步no. | 1 | 源盛 | 未簽收 |  |  | MAR | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov
架步no. | 2 | 浚盈 | 巳簽收 | 2022-03-18 00:00:00 | 俞建建 | DN-387 | DN-387 | DN-387 | DN-387 | DN-387 | DN-387 | DN-387 | DN-387
架步no. | 3 | 捷信 | 巳簽收 | 2022-03-01 00:00:00 |  | DN-394 | DN-394 | DN-394 | DN-394 | DN-394 | DN-394 | DN-394 | DN-394
架步no. | 4 | 秦森記 | 巳簽收 | 2022-03-01 00:00:00 |  | DN-388 | DN-388 | DN-388 | DN-388 | DN-388 | DN-388 | DN-388 | DN-388
架步no. | 5 | 秦森記 | 巳簽收 | 2022-09-01 00:00:00 |  |  |  |  |  |  |  | DN-361 | DN-361
架步no. | 6 | 秦森記 | 巳簽收 | 2022-09-01 00:00:00 |  |  |  |  |  |  |  | DN-361 | DN-361
架步no. | 7 | 無
架步no. | 8 | 女更衣室
架步no. | 9 | 立基恒利 | 巳簽收 | 2022-09-01 00:00:00 |  |  |  |  |  |  |  | DN-359 | DN-359
架步no. | 10 | 標特美 | 巳簽收 |  |  |  |  |  |  |  |  | DN-359 | DN-359
架步no. | 11 | 中海男工
架步no. | 12 | 力群 | 巳簽收 | 2022-10-03 00:00:00 |  |  |  |  |  |  |  |  | DN-385 |  | B總
架步no. | 13 | 無租用 | 無租用
架步no. | 14 | 文平 |  | 2022-07-01 00:00:00 |  |  |  |  |  | DN-378 | DN-378 | DN-378 | DN-378
架步no. | 15 | 大華木門 | 巳簽收 | 2022-08-02 00:00:00 |  |  |  |  |  |  | DN-389 | DN-389 | DN-389
架步no. | 16 | 大華鋁窗 | 巳簽收 | 2022-08-02 00:00:00 |  |  |  |  |  |  | DN-390 | DN-390 | DN-390
架步no. | 17 | 新天 | 巳簽收 | 2022-08-02 00:00:00 |  |  |  |  |  |  | DN-391 | DN-391 | DN-391
架步no. | 18 | 均記 | 均不簽,管工葉德偉代均記簽收 | 2022-09-01 00:00:00 |  |  |  |  |  |  |  | DN-384 | DN-384
架步no. | 19 | 均記 | 均不簽,管工葉德偉代均記簽收 | 2022-09-01 00:00:00 |  |  |  |  |  |  |  | DN-384 | DN-384
架步no. | 20 | 蔡森 | 巳簽收 | 2022-08-02 00:00:00 |  |  |  |  |  |  | DN-392 | DN-392 | DN-392
架步no. | 21 | 男更衣室
架步no. | 22 | 雄偉 | 巳簽收 | 2022-08-08 00:00:00 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
架步no. | 23 | 日桂 | 巳簽收 | 2022-09-01 00:00:00 |  |  |  |  |  |  |  | DN-383 | DN-383
架步no. | 24 | 蔡森 | 巳簽收 | 2022-08-02 00:00:00 |  |  |  |  |  |  | DN-392 | DN-392 | DN-392
架步no. | 25 | 均記 | 均不簽,管工葉德偉代均記簽收 | 2022-09-01 00:00:00 |  |  |  |  |  |  |  | DN-384 | DN-384
架步no. | 26 | 均記 | 均不簽,管工葉德偉代均記簽收 | 2022-09-01 00:00:00 |  |  |  |  |  |  |  | DN-384 | DN-384
架步no. | 27 | 均記 | 均不簽,管工葉德偉代均記簽收 | 2022-09-01 00:00:00 |  |  |  |  |  |  |  | DN-384 | DN-384
架步no. | 28 | 朝興 | 不肯簽 |  |  | DN-413 | DN-413 | DN-413 | DN-413 | DN-413 | DN-413 | DN-413 | DN-413
架步no. | 29 | 捷信(坭釘) | 巳簽收 | 2022-03-01 00:00:00 |  | DN-394 | DN-394 | DN-394 | DN-394 | DN-394 | DN-394 | DN-394 | DN-394
架步no. | 30 | 文平 | 巳簽收 | 2022-04-01 00:00:00 |  |  | DN-395 | DN-395 | DN-395 | DN-395 | DN-395 | DN-395 | DN-395
架步no. | 31 | [NAME]
架步no. | 32 | [NAME]
 | 33 | 無此架步
Spreadsheet: 859191d1707659902-displaying-information-with-dropdowns-testbook
Sheet: Data

Site | Red |  |  |  |  | Upon selection of B1 only, when B2 and B3 are empty it should show top 5 bylines of the site selected in B1, for all the years and quarters
Year | 2020 |  |  |  |  | If B1 and B2 are selected, and B3 is empty, then it should show top 5 bylines of the site and year selected only
Quarter | Q2 |  |  |  |  | If B1, B2, B3 all are selected, then it should show top 5 bylines of the site, year and quarter selected
 |  |  |  |  |  | B1, B2, B3 have dropdowns
Top 5 Bylines
byline here | count here
byline here | count here
byline here | count here
byline here | count here
byline here | count here
Spreadsheet: 869721d1716302181-pull-data-through-from-a-worksheet-which-worksheet-is-defined-by-the-value-in-a-cell-using-indirect-with-filter-_with-spaces-etaf
Sheet: Load Sheet

 |  |  |  |  |  |  |  |  |  |  |  | Load No.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | sheet 1 |  | 010624
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sheet 1
Spreadsheet: 801498d1666227902-lookup-and-return-1st-cell-with-value-demo_sheet_1
Sheet: Monthly Avg

 | Agent Name |  | Zopen1
 |  | QA | ACW | [NAME] | ASR | OS
 | YTD Growth
 | YTD Average
 | Starting Pojnt
 | Feb
 | Mar
 | Apr
 | May
 | Jun
 | Jul
 | Aug
 | Sep
 | Oct
 | Nov
 | Dec