tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 726429d1617226134-populate-text-from-other-sheet-based-on-number-or-word-entered-reminders
Sheet: TOPICS

Weekly [NAME] |  |  |  |  |  | Safety Minder Schedule |  |  |  |  |  |  | Managers [NAME] |  |  |  |  |  |  | Monthly [NAME]
Week 1 | Cleaning |  |  |  | Week 1 | Observe |  |  |  |  |  | Week 1 | Sign in |  |  |  |  |  | January | Be kind
 | Safety |  |  |  |  | Don't rush |  |  |  |  |  |  | Sign out |  |  |  |  |  |  | Golden rule
Week 2 | Wall Washing |  |  |  | Week 2 | Teamwork |  |  |  |  |  | Week 2 | Requests |  |  |  |  |  | February | Polite
 | Lifting |  |  |  |  | Ask questions |  |  |  |  |  |  | Onboarding |  |  |  |  |  |  | Compassion
Week 3 | Dusting |  |  |  | Week 3 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | March | Attentive
 | Fire |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Punctual
Week 4 | Storage |  |  |  | Week 4 |  |  |  |  |  |  | Week 4 |  |  |  |  |  |  | April
 | Equipment
Week 5 | [NAME] |  |  |  | Week 5 |  |  |  |  |  |  | Week 5
 | Falling Objects
CustomerServiceMinders
1. Interactive
2. [NAME]
3. Communication
4. Telephone Etiquette
5. Communicating with Unhappy Customers
Spreadsheet: 05d13b4b-dcc4-4c9d-9851-9db68c942c16
Sheet: 2010-11

Table T2
Non-UK Domiciled Student Numbers by Ethnic Group
Ethnic Group | Undergraduate | Graduate | Total
Asian or Asian British
- Bangladeshi | 130 | 54
- Indian | 895 | 485
- Pakistani | 218 | 120
- Other | 442 | 205
Subtotal
Black or Black British
- African | 226 | 199
- Caribbean | 54 | 49
- Other | 11 | 12
Subtotal
Chinese
Chinese | 356 | 149
Subtotal
Mixed
[NAME] and Asian | 232 | 91
[NAME] and Black African | 42 | 21
[NAME] and Black Caribbean | 42 | 20
- Other | 184 | 134
Subtotal
White
[NAME] | 5359 | 4124
Subtotal
Other
Other Ethnic Background | 240 | 194
Information Refused | 298 | 246
Not Known | 12 | 16
Subtotal
Total
This table is concerned with students whose domicile at the time of application is outside the UK irrespective of nationality.
Spreadsheet: 123866d1317906486-linking-pages-quote_lookup_examples
Sheet: EETF

Item | Code | Designation | Data1 | Data2 | Data3
244.100 | EETF | ABCD | u | 1 | 6
244.101 | EETF | ABCE | u | 2 | 7
244.102 | EETF | ABCF | u | 3 | 8
244.103 | EETF | ABCG | u | 4 | 9
244.104 | EETF | ABCH | u | 5 | 10
Spreadsheet: 62fd0060-400d-42bd-b57f-2e846cb61949
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 1/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mkt year and qtr 1/ |  | High-fructose corn syrup (HFCS) | Glucose and dextrose | Starch | Alcohol for fuel | Alcohol for beverages and manufacturing | Cereals and other products | Seed | Total food, seed, and industrial use
2010/11 | Q1 Sep-Nov | 126.248 | 65.111 | 66.286 | 1242.658 | 33.02 | 49.115 | 0 | 1582.438
 | [NAME] | 116.276 | 59.709 | 62.688 | 1254.872 | 34.588 | 48.575 | 0 | 1576.708
 | [NAME] | 138.904 | 70.832 | 64.577 | 1257.794 | 36.164 | 49.655 | 20.24 | 1638.166
 | [NAME] | 139.621 | 76.705 | 64.824 | 1263.417 | 31.228 | 49.655 | 2.76 | 1628.21
 | MY Sep-Aug | 521.049 | 272.357 | 258.375 | 5018.741 | 135 | 197 | 23 | 6425.522
2011/12 | Q1 Sep-Nov | 119.636 | 77.965 | 64.652 | 1266.691 | 33.302 | 50.732 | 0 | 1612.978
 | [NAME] | 115.001 | 71.002 | 62.025 | 1304.805 | 34.93 | 50.732 | 0 | 1638.495
 | [NAME] | 136.829 | 72.977 | 62.138 | 1247.777 | 36.586 | 50.531 | 23.565 | 1630.403
 | [NAME] | 141.894 | 72.327 | 65.153 | 1191.752 | 31.682 | 51.234 | 0.963 | 1555.005
 | MY Sep-Aug | 513.36 | 294.271 | 253.968 | 5011.025 | 136.5 | 203.229 | 24.528 | 6436.881
2012/13 | Q1 Sep-Nov | 123.87 | 64.565 | 63.911 | 1142.388 | 32.992 | 50.304 | 0 | 1478.03
 | MY Sep-Aug | 485 | 280 | 240 | 4500 | 135 | 202 | 25 | 5867
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 1/15/2013
Spreadsheet: 474447d1470757142-vlookup-post-code-region-post-code-regions
Sheet: Regions

EAST ANGLIA | THE MIDLANDS | NORTH EAST ENGLAND | NORTH WEST ENGLAND | LONDON | SOUTH CENTRAL ENGLAND | SOUTH EAST ENGLAND | SOUTH WEST ENGLAND | WALES | NORTHERN IRELAND | SCOTLAND | ISLANDS
AL | B | BD | BB | E | GU | BN | BH | CF | BT | AB | GY
CB | [NAME] | DH | BL | EC | HA | BR | BS | LD |  | DD | JE
CM | DE | DL | CA | N | HP | CR | DT | LL |  | DG | IM
CO | DY | DN | CW | NW | OX | CT | EX | NP |  | EH
EN | LE | HD | FY | SE | PO | DA | GL | SA |  | FK
IG | NG | HG | L | SW | RG | KT | HR |  |  | G
IP | NN | [NAME] | LA | W | SL | ME | PL |  |  | HS
LU | ST | HX | M | WC | SN | RH | TA |  |  | IV
MK | WS | LN | OL |  | SO | SM | TQ |  |  | KA
NR | WV | LS | PR |  | SP | TN | TR |  |  | KW
PE |  | NE | SK |  | UB | TW | WR |  |  | KY
RM |  | S | SY |  |  | BA |  |  |  | ML
SG |  | SR | TF |  |  |  |  |  |  | PA
SS |  | TS | WA |  |  |  |  |  |  | PH
WD |  | WF | WN |  |  |  |  |  |  | TD
 |  | YO | CH |  |  |  |  |  |  | ZE
Spreadsheet: sally_beck__35479__projected 2002 budget saving
Sheet: Sheet1

Enron America's Projected Cost Savings
Salaries |  | 1383000
Benefits & Tax
Subtotal
Assocaties |  | 864000
Analysis |  | 280800
Contractors |  | 300000
Logistics Trip |  | 100000
Employee expense |  | 150000
[NAME]
Direct savings
Allocated saving |  | 150000
Total Savings
Spreadsheet: 825058d1681093768-dependant-drop-down-list-display-data-from-multiple-dynamic-ranges-invoice_example
Sheet: Invoice

 |  | ITEM: |  |  |  |  | CUST REF: |  | QTY: | PER: | UNIT: | TOTAL:
 |  | T-Shirt |  |  |  |  | Client A |  | 2 | ea. | 10
 |  | Short |  |  |  |  |  |  | 1 | ea. | 14
 |  | T-Shirt |  |  |  |  | Client B |  | 10 | ea. | 5
 |  | Short |  |  |  |  |  |  | 10 | ea. | 8
 |  | Jacket |  |  |  |  |  |  | 5 | ea. | 15
 |  | Shoes |  |  |  |  |  |  | 5 | pair. | 40
 |  | Retail |  |  |  | Cell shading is not required, it is only to illustrate which list each item should be drawing from
 |  | Manufacture
 |  |  |  |  |  | Summary
 | SELECTED PRICE LIST |  |  |  |  | I Would like to try and have "Lists" for manufacturing and retail update dynamically as new entries are added to the "Price Lists"
 |  |  |  |  |  | These dynamic ranges then provide data for the data validation lists which can be selected from the Invoice "Item" column
 | Retail |  |  |  |  | These lists would be dependant on the  "Selected Price List" tab , in order to stop the data validation lists becoming unreasonably long
 |  |  |  |  |  | "Per" and "Unit" data should then autofill from the relevant list as "Items" are added from the drop down
 |  |  |  |  |  | I would like the formatting of the Invoice to remain within an A4 size. So adding extra columns may be difficult
Spreadsheet: 738754d1625227887-index-aggregate-formula-help-example-data-1-
Sheet: Results

Results for: | Feb2021
 | Category | Species | Member [NAME]
 | Open ExC |  |  |  | <- Winner of the category
 | Open ExCat |  |  |  | <- Winner of the category
 | Open MinC |  |  |  | <- Winner of the category
Spreadsheet: 172849d1344355291-extract-rows-based-on-cell-value-into-final-sheet-cc-test
Sheet: April

2012-04-06 00:00:00 | 52.63 | Test | Business | Mileage Reimbursement
2012-04-06 00:00:00 | 3.68 | Test
2012-04-06 00:00:00 | 12.53 | Test
2012-04-07 00:00:00 | 11.1 | Test
2012-04-07 00:00:00 | 25.66 | Test | Business | Dining
2012-04-07 00:00:00 | 1 | Test
2012-04-10 00:00:00 | 131.06 | Test | Business | Phone
2012-04-11 00:00:00 | 0 | Test
Spreadsheet: 140491d1328779785-excel-2007-id-to-be-picked-up-site-id
Sheet: Sheet1

 |  |  |  |  |  | Result table
 | Site ID | Value |  |  |  | Site ID | Value
 | 17893 |  |  |  |  | 17894 | 0
 | 17894 | 0 |  |  |  | 17897 | 0
 | 17895 | TBD |  |  |  | 17900 | 0
 | 17896 | Not implemented
 | 17897 | 0
 | 17898
 | 17899
 | 17900 | 0
 | 17901
Spreadsheet: 201872d1356174985-calculated-field-problem-with-subtracting-start-end-total-trail
Sheet: Sheet1

office | client | cohort | start | end
glasgow | client 1 | WP JSA Early Access | 2012-01-31 00:00:00
glasgow | client 2 | WP JSA 25+ | 2011-12-16 00:00:00 | 2012-05-11 00:00:00
glasgow | client 3 | WP JSA 25+ | 2012-05-22 00:00:00 | 2012-07-25 00:00:00
glasgow | client 4 | WP [NAME] 18-24 | 2012-06-28 00:00:00
Spreadsheet: c1049827-1973-4761-b36f-b0882c76b935
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44037407 | 2014-11-15 21:27:05 | AXIS | 1 | 6 | 5 | 439574 | creetingdragons | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
Spreadsheet: 295040d1391576815-automatically-fitering-values-through-based-on-a-criteria-database-and-constituent-tabs
Sheet: Victoria

 |  |  | Category | List A | List B | List C
 |  |  | A | 0.367089517588567 | 0.2004199707822576 | 0.5642164971521103
 |  |  | B | 0.6866906612341263 | 0.9998021785803782 | 0.07577003464536625
 |  |  | C | 0.3586075039024669 | 0.8944862727421745 | 0.8546364670883694
 |  |  | D | 0.9618628787092993 | 0.40216863136179 | 0.1209537209759846
 |  |  | E | 0.8937803475639466 | 0.4487979585836039 | 0.9517168393507838
 |  |  | F | 0.295242874192561 | 0.3820738826591505 | 0.8318062084577288
Spreadsheet: 215204d1361305458-formula-help-test
Sheet: Sheet1

Site&Asset values | Site | site name | AssetName | AssetNumber | Date | StartTime | EndTime
 | Bradford | Area 1 | Unit | 1 | 2012-04-19 00:00:00 | 12:00:00 | 12:15:00
 | Bradford | Area 1 | Unit | 1 | 2012-08-01 00:00:00 | 10:15:00 | 10:30:00
 | Bradford | Area 2 | Base | 1 | 2012-08-09 00:00:00 | 10:15:00 | 10:30:00
 | Bradford | Area 2 | Base | 1 | 2012-08-10 00:00:00 | 10:15:00 | 10:30:00
Spreadsheet: matthew_lenhart__26075__PG&E
Sheet: Curves

Date | NX | Socal | Rockies | Permian | Waha | SJ | PG&E | Malin | Aeco | LIBOR | Socal/Malin | Malin/Aeco | Socal/SJ
Spreadsheet: 51574d1251221366-data-validation-from-table-non-vb-dynamic-data-validation
Sheet: Admin

Department: | ADMIN
Project 1
Title
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
Project 2
Title
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
Spreadsheet: 43852d1242487114-writting-number-from-columns-in-reversed-order-base
Sheet: Sheet1

 | enter number | 10000
 |  | ([NAME]. 268435455)
0 | 0
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
A | 10
B | 11
C | 12
D | 13
E | 14
F | 15
G | 16
H | 17
I | 18
J | 19
K | 20
L | 21
M | 22
N | 23
O | 24
P | 25
Q | 26
R | 27
S | 28
T | 29
U | 30
V | 31
W | 32
X | 33
Y | 34
Z | 35
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 |  | -2198
2 | -2087 | -3232
3 | -2 | -2673
4 | -2087 | -2139
5 | -2087 | -1056
6 | -2087 | -1501
7 | -2 | -2139
8 |  | -2139
9 | -2087 | -2139
10 | -2087 | -1187
11 | -2087 | -2139
12 | -2087 | -2139
13 | -2087 | -3500
14 | -2 | -2139
15 | -2087 | -2139
16 | -1977 | -2139
17 | -1958 | -2671
18 | -1775 | -2139
19 | -827 | -2139
20 | -610 | -593
21 | -1258
22 | -1985
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | -354102.16
2001-07-22 00:00:00
Spreadsheet: chris_germany__2576__VNG Pipeline Setup-Oct-00
Sheet: 10-6

2000-10-06 00:00:00 |  |  | VNG Daily Setup
Flow Date |  |  |  | DTH
 |  |  | 2000-10-05 00:00:00 |  | 2000-10-06 00:00:00 |  | 2000-10-07 00:00:00 |  | 2000-10-08 00:00:00
 |  |  | Thursday |  | Friday |  | Saturday |  | Sunday
 |  |  | High | Low | High | Low | High | Low | High | Low
Richmond, VA Forecast |  |  | 84 | 71 | 85 | 66 | 70 | 58 | 61 | 45
Cooling / (Heating) Degree Days
Forecasted Demand |  |  | 45000 |  | 43000 |  | 45000 |  | 80000
INTERRUPTIBLE STATUS |  |  | ON / ON |  | ON / ON |  | ON / ON |  | ON / ON
SUPPLY: | AVAILABLE
TRANSCO
FS  Swing | 15930 |  | 15930 |  | 15930 |  | 15930 |  | 15930
FT | 14400 |  | 20556 |  | 20556 |  | 20556 |  | 20556
WSS - W/D  (3,386) | 8524 |  | -3300 |  | -3300 |  | -3300 |  | -3300
GSS-INJ (575) | 2070 |  | -484 |  | -484 |  | -484 |  | -484
WSS  W/D Capacity | 0
TOTAL Emporia | 38000
TOTAL City Gate (.0268%) | 37620
FT-WSS-INJ (3,386)
COLUMBIA
+  SST - Spot | 0 |  | 0 |  | 0 |  | 0 |  | 0
+  FTS - System Supply | 57970 |  | 11198 |  | 11198 |  | 11198 |  | 46198
=  Subtotal FT Sys. Supply | 57970 |  |  | * |  | * |  | * |  | *
SST - FSS         (9837) | 31827.5 |  | -5076 |  | -7076 |  | -5076 |  | -5076
EndUser |  |  | 2000 |  | 2000 |  | 2000 |  | 2000
Cove Point LNG |  |  | 0 |  | 0 |  | 0 |  | 0
LNG (3,244) | 52090 |  | -6081 | * | -6081 | * | -6081 | * | -6081 | *
TOTAL | 141887.5
CNGT
FTNN | 46075 |  | 16558 |  | 16558 |  | 16558 |  | 16558
GSS            (16,599) | 53648 |  | -16599 |  | -16599 |  | -16599 |  | -16599
Subtotal Cannot exceed 46,075 Apr - Oct
EndUser |  |  | 11175 |  | 11175 |  | 11175 |  | 11175
[NAME] | 9975
TOTAL Quantico | 93604
TOTAL City Gate(.0025%) | 93369.99
VNG
PROPANE
NORTHERN | 17275 |  | 0 |  | 0 |  | 0 |  | 0
SOUTHERN | 34450 |  | 0 |  | 0 |  | 0 |  | 0
TOTAL | 324602.49
Difference
 | Projected  Storage  Summary
 |  |  | [NAME]. |  | [NAME]
 | FSS |  | 9837 |  | 63655
 | GSS |  | 484 |  | 2070
 | WSS |  | 3386 |  | 8524
 | CNG GSS |  | 16599 |  | 53648
 | LNG |  | 3244 |  | 52090
 | Propane |  | 12,000 gal/day |  | 51825
High Burn Contingenies |  |  |  |  |  |  |  | Low Burn Contingenies
1) Reduce Columbia FSS Injection to 0 |  |  |  |  |  |  | 1) Increase Columbia FSS injection to 9,837
2) Reduce CNG GSS Injection to 0 |  |  |  |  |  |  | 2) Notify ENA  contact for instructions if there is excess supply
3) Notify ENA  contact for instructions if additional supply is needed
Spreadsheet: 169260d1342755935-pivot-table-excel-2003-suppress-zero-values-testpivot-ver-4-with-event-code
Sheet: Sheet1

DateRange | DataRange |  |  |  |  |  | DESIRED DISPLAY:
2000-01-31 00:00:00 | 10
2001-01-31 00:00:00 | 100 |  |  |  |  |  | Sum of Field1
2001-01-31 00:00:00 | -100 |  |  |  |  |  | DateRange | Total
2002-01-31 00:00:00 | 2000 |  |  |  |  |  | 2000-01-31 00:00:00 | 10
2002-01-31 00:00:00 | 2000 |  |  |  |  |  | 2002-01-31 00:00:00 | 2000
2002-01-31 00:00:00 | -2000 |  |  |  |  |  | Grand Total | 2010
2003-01-31 00:00:00 | 30000
2003-01-31 00:00:00 | -30000
2003-01-31 00:00:00 | 400
 |  |  | CURRENT PIVOT TABLE
 |  |  | Sum of Field1
 |  |  | DateRange | Total
 |  |  | 2000-01-31 00:00:00 | 10
 |  |  | 2001-01-31 00:00:00 | 0
 |  |  | 2002-01-31 00:00:00 | 2000
 |  |  | 2003-01-31 00:00:00 | 400
 |  |  | Grand Total | 2410
Spreadsheet: 219945d1363018455-splitting-the-information-in-a-cell-into-2-cells-example
Sheet: Sheet1

 | 38.65 | 40.11 | (3) 36.70 | (3) 37.02 | (3) 36.66 | (3) 37.18 | (3) 37.60 | (3) 38.15 | (3) 38.28 | (3) 38.84 | (3) 39.11 | (3) 39.21 | (3) 39.44 | (1) 35.83 | (1) 30.42
 | (4) 38.87 | (2) 39.78 | (2) 36.66 | (2) 36.95 | (2) 36.74 | (2) 37.16 | (2) 37.64 | (2) 38.16 | (2) 38.30 | (2) 38.85 | (2) 39.09 | (2) 39.22 | (2) 39.45 | (2) 35.92 | (2) 30.51
 | (5) 38.97 | (4) 40.02 | (4) 36.64 | (4) 37.06 | (4) 36.62 | (4) 37.17 | (4) 37.62 | (5) 38.35 | (4) 38.05 | (4) 38.86 | (4) 39.10 | (4) 39.22 | (4) 39.46 | (3) 35.86 | (3) 30.45
 | (2) 38.75 | (1) 39.64 | (1) 36.68 | (1) 36.96 | (1) 36.70 | (1) 37.19 | (1) 37.63 | (1) 38.28 | (1) 38.18 | (1) 38.84 | (1) 39.11 | (1) 39.21 | (1) 39.50 | (4) 37.15 | (4) 36.05
 | (7) 39.13 | (5) 40.29 | (5) 36.37 | (5) 37.19 | (5) 36.61 | (5) 37.21 | (5) 37.57 | (4) 37.84 | (5) 38.64 | (5) 38.74 | (5) 39.20 | (5) 39.30 | (5) 39.57 | (5) 39.49 | (5) 39.09
 | (6) 39.11 | (7) 40.90 | (7) 38.27 | (7) 38.54 | (8) 39.17 | (8) 39.03 | (8) 39.13 | (8) 38.74 | (7) 38.10 | (7) 38.68 | (7) 39.07 | (7) 39.83 | (7) 40.83 | (7) 40.69 | (6) 36.51
 | (9) 39.36 | (8) 40.87 | (10) 38.65 | (10) 38.63 | (10) 38.87 | (10) 39.07 | (10) 39.26 | (10) 38.96 | (10) 38.99 | (10) 39.23 | (9) 39.98 | (9) 40.12 | (8) 40.34 | (8) 38.79 | (7) 35.68
 | (3) 38.86 | (6) 40.84 | (6) 38.26 | (6) 38.53 | (6) 39.16 | (7) 39.16 | (6) 38.92 | (6) 38.52 | (6) 38.39 | (6) 38.63 | (6) 38.83 | (6) 39.48 | (6) 40.86 | (6) 41.22 | (8) 40.99
 | (8) 39.30 | (10) 41.28 | (9) 38.01 | (9) 38.53 | (9) 38.97 | (9) 38.99 | (9) 39.21 | (9) 38.91 | (9) 39.00 | (9) 39.51 | (10) 40.39 | (10) 40.91 | (10) 41.45 | (10) 40.97 | (9) 36.85
 | (10) 39.49 | (9) 40.93 | (8) 37.96 | (8) 38.53 | (7) 38.87 | (6) 39.00 | (7) 39.11 | (7) 38.69 | (8) 38.97 | (8) 39.25 | (8) 40.73 | (8) 40.30 | (9) 41.15 | (9) 40.49 | (10) 40.02
Spreadsheet: 249725d1373601126-grouping-of-record-data-work-sheet
Sheet: EXCEPTED RESULT

Company | NAME | GROUP Name
REGAHA PR | AEON GANIC | ARC MALABS PR
ARC MALABS PR | AMATH | ARC MALABS PR
REGAHA PR | AMATH | ARC MALABS PR
ARC MALABS PR | [NAME] | ARC MALABS PR
ANSHIP PR | DANI PING | ANSHIP PR
HIPP PR | DANI PING | ANSHIP PR
ARC MALABS PR | DIN MARA | ARC MALABS PR
BAGABRO  PR | GAYA BRO PLE | BAGABRO  PR
BAGABRO  PR | GRAW HESH | BAGABRO  PR
DIGY LOW PR | GRAW HESH | BAGABRO  PR
ANSHIP PR | LIYAKA | ANSHIP PR
HIPP PR | LIYAKA | ANSHIP PR
ARC MALABS PR | MAJA JA | ARC MALABS PR
REGAHA PR | MAJA JA | ARC MALABS PR
REGAHA PR | MANAN ARAYA | ARC MALABS PR
BAGABRO  PR | OMI BAGAD | BAGABRO  PR
ARC MALABS PR | RAKAUMAR IMA | ARC MALABS PR
ANSHIP PR | RAVATIN | ANSHIP PR
HIPP PR | RAVATIN | ANSHIP PR
DIGY LOW PR | RAWA INIT | BAGABRO  PR
BAGABRO  PR | RAWAL MAR | BAGABRO  PR
ANSHIP PR | SAIKUM | ANSHIP PR
HIPP PR | SAIKUM | ANSHIP PR
ANSHIP PR | SEVANTVORA | ANSHIP PR
HIPP PR | SEVANTVORA | ANSHIP PR
ANSHIP PR | SHADO SAD | ANSHIP PR
HIPP PR | SHADO SAD | ANSHIP PR
ANSHIP PR | SHAPAN | ANSHIP PR
HIPP PR | SHAPAN | ANSHIP PR
ANSHIP PR | UMENOD BHAI | ANSHIP PR
HIPP PR | UMENOD BHAI | ANSHIP PR
Spreadsheet: 678217d1589786577-formula-to-get-unique-data-excel-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 500 | Expenses Airfare Aug-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 2500 | Expenses Airfare Jul-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 800 | Expenses Airfare Jun-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 500 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 350 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 450 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 550 | Expenses Airfare Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 650 | Expenses Airfare Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 750 | Expenses Airfare Sep-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 350 | Expenses Airfare Sep-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100 | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100 | 2500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100 | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Ercot AA

 | Ercot Power Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  |  | 0
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  | 0 |  |  |  | Sr. Specialist | 78000 | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000 | 1
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200 | 2
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000 | 2
 |  |  |  |  |  |  |  |  | Director | 156000 | 2
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 05fe99ce-2e3e-4653-8480-92c54b45c2f3
Sheet: Sheet5

 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
DOD
Delta
% Delta
CFO Act Civilian Agencies
Delta
% Delta
Spreadsheet: 121737d1316371375-vlookup-verification-sample-vlookup-help-
Sheet: Pricing Report

Test Sheet
Model | Price Store 1 | Price Store 2 | Price Store 3
abc | 8 | #N/A | 4
def | #N/A | #N/A | 3
ghi | 3 | #N/A | 2
jkl | #N/A | 1 | 1
mno | #N/A | 3 | #N/A
pqr | #N/A | 4 | #N/A
[NAME] | #N/A | 6 | #N/A
vwx | #N/A | #N/A | 12
yz1 | 12 | #N/A | 12
a1 | 12 | #N/A | 11
a2 | #N/A | #N/A | 10
a3 | #N/A | #N/A | 9
a4 | #N/A | 7 | #N/A
a5 | #N/A | 8 | #N/A
a6 | 3 | 10 | #N/A
a7 | #N/A | 11 | #N/A
[NAME] | #N/A | #N/A | #N/A
a9 | #N/A | #N/A | #N/A
Spreadsheet: 145320d1331531417-forecast-using-excel-book1
Sheet: Sheet1

Month | Day | Visitor footfall/ occupancy | No of days in month | Subtotal | Total
January | Saturday (Average) | 2400 | 4 | 9600
 | Sunday (Average) | 3600 | 4 | 14400
 | Other weekday (average per day) | 1181 | 22 | 25982 | 49982
February | Saturday (Average) | 3200 | 4 | 12800
 | Sunday (Average) | 2800 | 4 | 11200
 | Other weekday (average per day) | 1409 | 22 | 30998 | 54998
July | Saturday (Average) | 1300 | 4 | 5200
 | Sunday (Average) | 1100 | 4 | 4400
 | Other weekday (average per day) | 473 | 22 | 10406 | 20006
August | Saturday (Average) | 1400 | 4 | 5600
 | Sunday (Average) | 1200 | 4 | 4800
 | Other weekday (average per day) | 527 | 22 | 11594 | 21994
Spreadsheet: 880929d1728762216-if-this-then-that-if
Sheet: Sheet1

 | Table
 | Item No. | Item  Description | Qty Items/ per/Case | Value/ per/Item | Value/ Case | Weight/ Per/Item Kg | Weight/ Per/Case Kg
 | 1 | Widget A | 3 | 12 |  | 2
 | 2 | Widget B | 5 | 8 |  | 0.4
 | 3 | Widget C | 10 | 13 |  | 0.65
 | 4 | Widget D | 8 | 7 |  | 0.78
 | 5 | Widget E | 41 | 81 |  | 20.4
 | 6 | Widget F | 66 | 52 |  | 12
 | 7 | Widget G | 21 | 8 |  | 8.6
 | 8 | Widget H | 9 | 45 |  | 91.56
 | 9 | Widget I | 3 | 32 |  | 56
 | 10 | Widget J | 4 | 9.5 |  | 2.8
 | Need: | If B17:C18 are input then auto complete D17:F18
 | Summary
 | Item No. | Qty of Cases | Item Description | Value/ Sub | Weight/Sub
 | 4 | 24
 | 9 | 15
 | This is what it should show.
 | Summary
 | Item No. | Qty of Cases | Item Description | Value/ Sub | Weight/Sub
 | 4 | 24 | Widget D
 | 9 | 15 | Widget I
Spreadsheet: 830983d1685343996-how-to-use-xlookup-with-a-max-date-criteria-sample-1-aligw
Sheet: Sheet1

source Table |  |  |  |  |  | Result | Result
[NAME] | Value | Value Date |  |  | [NAME] | Value | Value Date |  |  |  |  |  |  |  |  |  |  |  | Value | Value Date | <<<<< AliGW Original
21185 | -1.27 | 2020-12-12 00:00:00 |  |  | 21185 |  | 2020-12-12 00:00:00 |  | Column G and H are the two data I want from the source data from the source table |  |  |  |  |  |  |  |  | 21185 | -1.27 | 2020-12-12 00:00:00
21185 | -0.25 | 2020-10-21 00:00:00 |  |  | 21219 | -1.1 | 2020-12-12 00:00:00 |  |  |  |  |  |  |  |  |  |  | 21219 | -1.1 | 2020-12-12 00:00:00
21185 | -0.25 | 2020-09-30 00:00:00 |  |  | 24011 | -0.95 | 2020-11-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 24011 | -0.95 | 2020-11-10 00:00:00
21219 | -1.1 | 2020-12-12 00:00:00 |  |  | 24015 | -0.45 | 2020-04-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | 24015 | -0.45 | 2020-04-04 00:00:00
21219 | -0.4 | 2020-08-29 00:00:00 |  |  | 24031 | 0.111 | 2020-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | 24031 | 0.111 | 2020-09-30 00:00:00
21219 | -1.29 | 2020-04-11 00:00:00
21219 | 0 | 2020-03-05 00:00:00
24011 | -0.95 | 2020-11-10 00:00:00 |  |  |  | Value | Value Date | <<<<< AliGW New
24011 | 0 | 2020-09-30 00:00:00 |  |  | 21185 | -1.27 | 2020-12-12 00:00:00
24011 | -0.52 | 2020-02-20 00:00:00
24015 | -0.43 | 2020-02-20 00:00:00
24015 | -0.45 | 2020-04-04 00:00:00
24031 | -0.38 | 2020-03-28 00:00:00
24031 | 0.111 | 2020-09-30 00:00:00
24031 | -0.71 | 2020-05-18 00:00:00
21182
21216
24014
24015
24031