tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 187544d1350502096-trying-to-compare-inevntory-sheets-and-carry-differences-to-another-worksheet-sales-test
Sheet: Day Rate Field Tkt with stamp

 |  |  | WE ACCEPT |  |  | Selling District:
 |  |  |  |  |  | FIELD TICKET NUMBER:
 |  |  |  |  |  | CONTRACT NUMBER:
 |  |  |  |  |  | Date:
 |  |  |  |  |  | Purchase Order Number:
 |  |  |  |  |  | DESTINATION OF PRODUCTS OR SERVICE
 |  |  |  |  |  |  | Land |  | Water |  |  | X | Offshore |  |  | International
CUSTOMER NUMBER: |  |  |  |  |  | Lease Name:
BILL TO: |  |  |  |  |  | Location:
 |  |  |  |  |  | City:
 |  |  |  |  |  | County: |  |  |  |  |  |  | State:
 |  |  |  |  |  | Country: |  |  |  |  |  |  | Ship Via:
Part# |  |  |  |  |  |  |  |  | Price |  |  |  |  |  |  | Qty | AMOUNT
 |  | [NAME] |  |  |  |  |  |  | Each |  |  |  | Total
Shipping
 |  |  |  |  |  |  |  |  |  |  |  |  | SUBTOTAL
Place Stamp Here |  |  |  |  | Tax Code |  |  | % |  |  |  |  | TOTAL TAX
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  | District
 |  |  |  |  |  |  | Represntative |  |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  | Customer
 |  |  |  |  |  |  | Representative
 |  |  |  |  |  |  |  |  | Please Print Clearly
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
Spreadsheet: 0c806029-4f97-4d95-b1a9-e1312207ce9f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 10. LEASE FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Motor cars and station wagons - New ; |  |  | Original | A2413502X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Motor cars and station wagons - Used ; |  |  | Original | A2413503A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Light trucks - New ; |  |  | Original | A2413504C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Light trucks - Used ; |  |  | Original | A2413505F | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Heavy trucks - New ; |  |  | Original | A2413506J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Heavy trucks - Used ; |  |  | Original | A2413507K | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Other motor vehicles ; |  |  | Original | A2413508L | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413509R | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 12fde7fd-7dcf-49d5-9e58-5b043a98f227
Sheet: Sheet1

 | Credit  Headcount At Census
 | MSJC District Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY11-13
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13
Male | 2035 | 5463 | 5555 | 2475 | 6240 | 6646 | 1507 | 7180 | 7155 | 932 | 6521 | 6641 | 158 | 6286 | 6465 | 640 | 5950 | 5783
Female | 3578 | 8879 | 8755 | 4217 | 9686 | 10144 | 2466 | 10431 | 10189 | 1261 | 9256 | 9195 | 62 | 8604 | 8872 | 830 | 8222 | 7925
Undeclared | 39 | 114 | 138 | 84 | 246 | 242 | 57 | 217 | 199 | 31 | 172 | 185 | 2 | 135 | 147 | 9 | 120 | 108
Term Total | 5652 | 14456 | 14448 | 6776 | 16172 | 17032 | 4030 | 17828 | 17543 | 2224 | 15949 | 16021 | 222 | 15025 | 15484 | 1479 | 14292 | 13816
Academic Year | 21297 |  |  | 24409 |  |  | 24067 |  |  | 21012 |  |  | 19534 |  |  | 17829
% of Total | Credit Headcount % of Total
 | MSJC District Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY11-13
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13
Male | 0.3600495399858457 | 0.3779053680132817 | 0.3844822812846069 | 0.3652597402597403 | 0.3858520900321543 | 0.3902066697980273 | 0.3739454094292804 | 0.4027372672201032 | 0.4078549848942598 | 0.4190647482014389 | 0.4088657596087529 | 0.4145184445415392 | 0.7117117117117117 | 0.418369384359401 | 0.4175277706019117 | 0.4327248140635565 | 0.4163168205989365 | 0.4185726693688477
Female | 0.6330502476999292 | 0.6142086330935251 | 0.6059662236987818 | 0.6223435655253837 | 0.5989364333415781 | 0.5955847815875999 | 0.6119106699751861 | 0.5850908682970608 | 0.5808014592715043 | 0.5669964028776978 | 0.5803498651953101 | 0.5739342113476062 | 0.2792792792792793 | 0.5726455906821963 | 0.5729785585120124 | 0.5611899932386748 | 0.5752868737755388 | 0.5736103068905617
Undeclared | 0.006900212314225053 | 0.007885998893193137 | 0.009551495016611296 | 0.01239669421487603 | 0.01521147662626762 | 0.01420854861437294 | 0.0141439205955335 | 0.01217186448283599 | 0.01134355583423588 | 0.01393884892086331 | 0.01078437519593705 | 0.0115473441108545 | 0.009009009009009009 | 0.008985024958402662 | 0.00949367088607595 | 0.006085192697768763 | 0.008396305625524769 | 0.00781702374059062
Spreadsheet: mary_fischer__25619__77L
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077L
COMPANY NAME   PBM Mechanical Inc.
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other |  | 1433670 |  | 275373 |  |  |  |  |  |  |  |  |  | 108303
Gross PP & E
Accumulated DD & A |  | -505380 |  |  |  |  |  | -102114 |  |  |  |  |  | -50979
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
Depr Charged to Jobs |  | 1150 |  | 56105 |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  |  |  |  |  |  |  | MEP Services, Inc |  |  |  | 108303 |  | -50979
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 79200d1279493146-excel-2007-how-to-make-this-conditional-equation-book1-index-
Sheet: Sheet1

 |  |  | Rules |  |  |  |  |  | C2 > * or /
 |  | 65 | 32.5 | 1 to 5 | If C2 | [NAME]6 |  | 1 | 6
 |  | 7 | 28 | 6 to 9 | If [NAME] | [NAME] |  | 6 | 4
 |  | 11 | 22 | 10 to 15 | If C4 | [NAME] |  | 10 | 2
 |  | 16 | 24 | 16 to 25 | If C5 | [NAME]1.5 |  | 16 | 1.5
 |  | 500 | 51.0204081632653 | 26 to 50 | If C6 | [NAME] |  | 26 | 1
 |  | 60 | 30 | 51 to 75 | If C8 | D2= C2/2 |  | 51 | 0.5
 |  | 1 | 6 | 76 to 90 | If C9 | D2= C2/2.5 |  | 76 | 0.4
 |  | 93 | 26.57142857142857 | 91 to 110 | If [NAME] | D2= C2/3 |  | 91 | 0.3333333333333333
 |  | 125 | 35.71428571428572 | 111 to 130=/3;5 | If C11 | D2= C2/3.5 |  | 11 | 0.2857142857142857
 |  | 359 | 36.63265306122449 | 131 to 150=/4 | If C12 | D2= C2/4 |  | 131 | 0.25
 |  | 499 | 50.91836734693877 | 151 to 175=/4;5 | If [NAME] | [NAME] |  | 151 | 0.2222222222222222
 |  | 200 | 36.36363636363637 | 176 to 210=/5;5 | If [NAME] | D2= C2/5.5 |  | 176 | 0.1818181818181818
 |  | 245 | 37.69230769230769 | 211 to 250=/6;5 | If C15 | [NAME] |  | 211 | 0.1538461538461539
 |  | 65 | 32.5 | 251 to 290=/7;5 | If [NAME] | [NAME] |  | 251 | 0.1333333333333333
 |  | 300 | 35.29411764705883 | 291 to 320=/8;5 | If C17 | D2= C2/8.5 |  | 291 | 0.1176470588235294
 |  | 1 | 6 | 321 to 360=/9;8 | If C18 | D2= C2/9.8 |  | 321 | 0.1020408163265306
Spreadsheet: 714494d1611245593-adding-a-text-superscript-to-the-end-of-a-formula-text-superscript-after-formula
Sheet: Sheet1

Service Rank1 | Service Volume2 | Service %3 | Academic Service
1 | 26 | 0.3376623376623377 | Bone Marrow Transplant Service
2 | 24 | 0.3116883116883117 | Thoracic Surgical Service
3 | 22 | 0.2857142857142857 | Pulmonary Service
TOTALS:
12 days4
Legend:
1 | Rank based upon volume compared to all services
2 | Number of referrals from this service
3 | Percentage of total volume from this service
4 | Number of days in reporting period
5 | Patients per technologist per day
Spreadsheet: 1470de41-3623-4284-9096-8a17fa2ddfdf
Sheet: Table 10

Table 10
[NAME] (1,000 tons)
Week ending 10/18/2014 | Corn | Wheat | Soybeans | Other | Total
Mississippi River
Rock Island, IL (L15) |  |  |  | 0
Winfield, MO (L25) |  |  |  | 0
Alton, IL (L26) |  |  |  | 0
Granite City, IL (L27)
Illinois River (L8) |  | 0 |  | 0
Ohio River (L52) |  |  |  |  |  | n/a
Arkansas River (L1)
Weekly total - 2014
Weekly total - 2013
2014 YTD1
2013 YTD
2014 as % of 2013 YTD
Last 4 weeks as % of 20132
Total 2013
1 Weekly total, YTD (year-to-date) and calendar year total includes Miss/27, [NAME], and Ark/1; "Other" refers to oats, barley, sorghum, and rye.
2 As a percent of same period in 2013.
Note:  Total may not add exactly, due to rounding
Source:  U.S. Army Corps of Engineers
Spreadsheet: darrell_schoolcraft__7477__imball0202
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 31118 | 31456
2 | 26432 | 31456
3 | 27387 | 31394
4 | 31954 | 31456
5 | 31066 | 34456
6 | 37507 | 36936
7 | 37808 | 38956
8 | 38181 | 39034
9 | 38435 | 39956
10 | 36511 | 39956
11 | 36351 | 34319
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 100916
2002-02-11 00:00:00
CBS Volume
 |  |  | 62232
Spreadsheet: 725772d1616849931-monthly-to-cusotm-date-report-sample-3-
Sheet: Report (F)

Criteria |  | Total Entries
Start Date | 2020-09-16 00:00:00
End Date | 2020-10-13 00:00:00
Total Unit Sold |  | Total Sell Price |  | Total Charges on Sell
Total Unit Sold |  | Total Sell Return Amt |  | Total Sell Return Charges
After Return |  | Actual Sell Price
 |  |  | TOTAL
Date | Model | Leather | Color | Unit Sold | Status | Sell Price | VAT | Unit Cost | DHL Cost | Handling Charges | Amazon Fees | PPC Cost | Total Cost | Net Sales | [NAME] | After [NAME] | Date of Return | Amazon Comm on Return | [NAME] after return | Ship Return Charges | DHL Cost | Handling Chges | Total Return Charges | Profit/Loss
Spreadsheet: 07882d31-48e9-4d61-987a-f8862dbf0f8e
Sheet: Sheet1

2013 YMCA Corporate Rates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Membership Type | Code |  | Pay in Full |  | Payroll Deduction |  | Joining Fee
YOUTH (Through age 13) | 110 |  | 117.5 |  | 10.75 |  | 0
YOUTH (age 14 - 18) | 910 |  | 241 |  | 21.75 |  | 0
COLLEGE STUDENT (12+ credits) | 210 |  | 395.5 |  | 36.75 |  | 0
ADULT | 310 |  | 476.5 |  | 43.75 |  | 30
With Center Locker | 311 |  | 696 |  | 64.75 |  | 30
1 Adult Family | 610 |  | 476.5 |  | 43.75 |  | 30
With 1 Center Locker | 611 |  | 696 |  | 64.75 |  | 30
2 Adult Family | 710 |  | 848.5 |  | 78.75 |  | 60
With 1 Center Locker | 711 |  | 1068 |  | 99.75 |  | 60
With 2 Center Lockers | 712 |  | 1287.5 |  | 120.75 |  | 60
Youth 18 and younger are included on parent's membership at no additional cost.
College students must bring in proof of 12 or more credits currently enrolled in.
Joining fee is waived for new members 65 and older.
Spreadsheet: 720350d1614110632-value-error-using-a-triple-nested-substitute-formula-error-due-to-empty-cell-s-test
Sheet: Sheet1

1
3
5 |  |  |  |  | #1 and #2 | #1 ,#2 and #3
7 |  |  |  |  | 5 | 5
9 |  |  |  |  | 5 | 5
11$ |  |  |  |  | 5 | 5
13 |  |  |  |  | 5 | 5
 |  |  |  |  | 5
 |  |  |  |  | 5 | 5
 |  |  |  |  | word | word
 |  |  |  |  | 5 | 5
 |  |  |  |  | #5 | #5
 |  |  |  |  | 5 | 5
 |  |  |  |  | 5 | 5
 |  |  |  |  | 5 | 5
Spreadsheet: 215679d1361454861-excel-newbie-needs-help-book2
Sheet: Sheet2

White Sandwich Loaf
WS loaf (small)
White (WS) Buns ½ dz
WS Dinner Rolls ½ dz
[NAME]
Hot dog buns [NAME] dz
12” Pizza Crust
8” Pizza Crust
[NAME] (WF) Loaf
WF Loaf (small)
WF Buns ½ doz.
WF Dinner Rolls ½ doz.
WF Hot dog buns [NAME] dz
12” WF Pizza Crust
8” WF Pizza Crust
[NAME]
[NAME] (small)
[NAME] buns ½ doz
Cran dinner rolls ½ doz
Glazed [NAME]
Rye Loaf
Anzac Cookies 1pk
Anzac Cookies 2pk
Choc Chip 2pk
Chocolate [NAME] 1pk
Double Choc Chip 2pk
Ginger 2pk
Hungerbuster 1pk
Hungerbuster 2pk
[NAME] 2pk
[NAME] 2pk
Snicker-doodle 2pk
Peanut Butter 2pk
Medium Boomerang
Large Boomerang
[NAME] keychain
All Purpose [NAME] lb
[NAME]
Choc Cake Mix
[NAME]
Guar Gum 8 oz
[NAME] flour (Green Label)
[NAME] flour (Red Label)
Tapioca Starch
Spreadsheet: 830166d1684759485-need-formula-that-sums-2-tables-based-on-date-sample32
Sheet: Sheet1

 |  |  |  | Month | Tx | Amount |  | Month | Tx | Amount |  | Month | Total | Answers
 |  |  |  | Jan | xuau | 505 |  | Jan | asnm | 901 |  | Jan
 |  |  |  | Feb | asdi | 401 |  | Feb | sijuw | 511 |  | Feb
 |  |  |  | Mar | sauw | 607 |  | Mar | ijsua | 17 |  | Mar
 |  |  |  | Apr | [NAME] | 112 |  | Apr | wujg | 182 |  | Apr
 |  |  |  | May | iuuw | 551 |  | May | dbgs | 254 |  | May
 |  |  |  | Jun | isjij | 124 |  | Jun | jusuh | 689 |  | Jun
 |  |  |  | Jul | qjkiw | 512 |  | Jul | [NAME] | 385 |  | Jul
 |  |  |  | Aug | [NAME] | 534 |  | Aug | sjnnj | 905 |  | Aug
 |  |  |  | Sep | smikn | 212 |  | Sep | ijsuj | 391 |  | Sep
 |  |  |  | Oct | nsknj | 908 |  | Oct | uhjwuh | 837 |  | Oct
 |  |  |  | Nov | [NAME] | 362 |  | Nov | iqji | 276 |  | Nov
 |  |  |  | Dec | whuhq | 819 |  | Dec | wiuhy | 398 |  | Dec
Spreadsheet: 836088d1689083302-cell-will-not-populate-image-function-until-double-clicked-qr-code-test-sheet-2
Sheet: Sheet1

Manufacturer | Vendor | Part Number | Description | Aisle | Bay | Shelf | Concatenated Data | URL Request | QR Code
Manufacturer | Vendor | [PHONE] | Test Part | AISLE 12 | BAY 1 | SHELF 6
 |  |  |  |  |  |  | ABC123
 |  |  |  |  |  |  | PART #: [PHONE]
 |  |  |  |  |  |  | PART #:
 |  |  |  |  |  |  | PART
A | B | C | D | E | F | G
Spreadsheet: 84843d1284933025-number-format-and-sum-function-football
Sheet: Sheet1

Home team | Away team | Results
A | B | 32
A | C | 21
A | D | 30
A | E | 24
A | F | 23
So,goal difference for the team A should be  12-10
But when I use Sum (B3:B7 ) I get
 |  |  |  | F11 | =SUMPRODUCT(LEFT(C3:C7,1)+0)&"-"&SUMPRODUCT(RIGHT(C3:C7,1)+0)
 |  |  |  | G11 | =SUMPRODUCT(LEFT(C3:C7,1)+0)-SUMPRODUCT(RIGHT(C3:C7,1)+0)
Spreadsheet: 707891d1607525718-how-to-assign-a-country-to-a-specific-area-dashboard-aligw
Sheet: POLAND

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: 857274d1706287217-conditional-formatting-excel-help-conditional-formatting-template
Sheet: Sheet1

 | 90
Follow Up | State | Client Name | CAR
 | WY | [NAME], [NAME] | 2023-06-21 00:00:00
 | WY | Jordan, [NAME] | 2023-11-12 00:00:00
 | WY | [NAME], [NAME] | 2023-09-12 00:00:00
 | WY | [NAME], [NAME]
 | WY | Doe, [NAME] | 2024-01-10 00:00:00
 | WY | [NAME], [NAME]
 | WY | Gump, Forest | 2023-07-26 00:00:00
Spreadsheet: 722016d1614994528-xlookup-to-replace-vlookup-in-complex-problem-xlookup-problem
Sheet: MultiCondition

 |  |  |  | Start Year | Grade | Role | Savings Produced
 |  |  |  | 2013 | A | Analyst | 174291
First Name | Surname | Uniqe Reference |  | 2014 | D | Vice President | 224534
[NAME] | [NAME] | 11547 |  | 2013 | C | Vice President | 204394
Smith | [NAME] | 34343 |  | 2013 | B | Associate Vice President | 278178
[NAME] | [NAME] | 75365 |  | 2013 | D | Director | 370746
[NAME] | [NAME] | 93564 |  | 2014 | A | Analyst | 163583
 |  |  |  | 2014 | B | Associate Vice President | 270746
Lookup the person in the criteria in the table above |  |  |  | 2013 | A | Analyst | 122575
 |  |  |  | 2014 | D | Director | 221802
Criteria
[NAME]
[NAME], [NAME]
[NAME] |  |  |  |  |  |  |  |  | *with out duplicate [NAME]
[NAME] |  |  |  |  |  |  |  |  | *with out duplicate [NAME]
Look up the Savings Produced for a Director of Grade D who started in 2014.
Criteria
2014
D
Director
Spreadsheet: 178138d1346674250-hide-data-example-client
Sheet: Sheet2

1 | Client 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 880190d1727811313-looking-up-data-across-entire-workbook-sample-workbook1
Sheet: Master 

Project Name |  | Calculat the cost to implement ABC System
Store Estimating |  | Total Min Hours | Total [NAME]
Store 1 |  |  |  | Check B1 of each Estimated sheet and If [NAME] (6A through 23 A) has but in an estime, I want the totals pulled in to collumns C and D
Store 2
Store 3
Store 4 |  | 80 | 140
Store 5
Store 6 |  | 135 | 220
Store 7
Store 8
Store 9
Store 10
Store 11
Store 12
Store 13
Store 14
Store 15
Store 16
Store 17
Store 18
 | Totals
Spreadsheet: 766154d1643784036-bonus-structure-based-on-a-flat-rate-sales-over-a-certain-amount-quarterly-bonus-spreadsheet
Sheet: Sheet1

 | Sales | % | Commission
January 1 - 31st | 100000 | 0.01
Februrary 1-28th | 100000 | 0.01
March 1 - 31st | 102000 | 0.01 |  |  |  | Sales | Bonus
 |  |  |  |  |  | 275000 | 500
Quarterly Sales/Bonus |  |  |  |  |  | 300000 | 1000
 |  |  |  |  |  | 325000 | 1500
April 1- 30th | 100000 | 0.01 | 0
May 1-31st | 125000 | 0.01 | 0
June 1- 30th | 110000 | 0.01 | 0
Quarterly Sales/Bonus
Spreadsheet: 157354d1337706557-excel-border-underline-help-copy-of-underline-test-1
Sheet: Sheet1

AS KICK STARTER | V-80 | (Log) | 2 | set
AS KICK STARTER | VEGA-R | (Log) | 2.5 | set
AS KICK STARTER | WIN | (Log) | 3.1 | set
AS KICK STARTER | YL2G | (Log) | 4 | set
AS FORK(W/NUT) | ALFA | (Log) | 5 | pc
AS FORK(W/NUT) | C-70MK2 | (Log) | 8 | pc
AS FORK(W/NUT) | TIGER | (Log) | 1 | pc
AS FORK(W/NUT) | VEGA-R NEW | (Log) | 0.25 | pc
AS FORK(W/NUT) | VIXION | (Log) | 6.5 | pc
AS FORK(W/NUT) | YB100 | (Log) | 20 | pc
AS GEAR DEPAN | GL-100 | (Log) | 1 | pc
AS GEAR DEPAN | GRAND | (Log) | 5 | pc
AS GEAR DEPAN | NEOTECH | (Log) | 8 | pc
AS GEAR DEPAN | RX-100 | (Log) | 1 | pc
ARMATURE | CRYPTON | (Log) | 5 | set
ARMATURE | GRAND | (Log) | 64 | set
ARMATURE | [NAME] | (Log) | 4 | set
ARMATURE | REVO ABSOLUTE | (Log) | 2 | set
ARMATURE | SHOGUNNEW | (Log) | 2 | set
ARMATURE | SMASH NEW | (Log) | 1 | set
Spreadsheet: 486003d1477242579-pattern-copying-issue-sample-1-
Sheet: Sheet1

[NAME] | 0 | 0
Ref no | HO1-110 | Account Name   : | ABC | Date | Descr 1 | Descr 2
2012-07-01 00:00:00 |  | Brevious Balance | 1622.3 | 500
[NAME] | 1122.3 | 0
Ref no | HO1-112 | Account Name   : | KJL | Date
2012-07-01 00:00:00 |  | Brevious Balance | 7126.25 | 1000
2013-04-23 00:00:00 | JV1310187 | Ahmed | 0 | 2126.25
2013-06-30 00:00:00 | JV1312305 | Mohamed | 0 | 2000
2013-06-30 00:00:00 | JV1312306 | Ibrahim | 0 | 2000
[NAME] | 14361.15 | 0
Ref no | HO1-111 | Account Name   : | NBN | Date
2012-07-01 00:00:00 |  | Brevious Balance | 2981410.88375 | 2820038.78
2012-09-17 00:00:00 | BANK-REC1303130 | Layla | 10716.37 | 0
Spreadsheet: 57337d1257439791-count-example-database-for-services
Sheet: Sheet1

Service1(e.g. Introductory Mapping Event, OHS Training) | Date commencing | [NAME] work | Date commencing
 |  | visited only no service taken up | 2009-02-01 00:00:00
management role consultation | 2009-01-01 00:00:00
DBT training | 2009-09-02 00:00:00
 |  | visited only no service taken up | 2009-03-03 00:00:00
SCI | 2009-04-03 00:00:00
SCI | 2009-05-05 00:00:00
 |  | phone call | 2009-11-11 00:00:00
SCI | 2009-10-11 00:00:00 |  | .
DBT training | 2009-01-20 00:00:00
consolidation event | 2009-06-06 00:00:00
[NAME] mapping event | 2009-04-16 00:00:00
team consultation | 2009-09-13 00:00:00
DBT training | 2009-06-12 00:00:00
DBT training | 2009-08-17 00:00:00
DBT training | 2009-09-28 00:00:00
 |  | email | 2009-08-12 00:00:00
Spreadsheet: 115375d1311011056-multiple-row-lookup-for-index-match-sample
Sheet: Summary

 | Project A | Project A | Project B | Project C
 | 2011-01-01 00:00:00 | 2011-03-05 00:00:00 | 2011-01-01 00:00:00 | 2011-04-05 00:00:00
Variable 1
Variable 2
Variable 3
Variable 4
Spreadsheet: 50600d1250076967-extracting-a-number-out-of-a-sentence-extracting-example
Sheet: Sheet1

On a shopping trip, Melita bought a necklace that cost £2.10, a pair of shorts which cost £7.99 and a pair of leggings that cost £15.14. How much did [NAME] spend in total?
In a music shop, [NAME] bought a CD that cost £7.38, a book which cost £5.10 and a t-shirt that cost £8.70. How much did [NAME] spend in total?
In a sports shop, [NAME] bought a pair of boxing gloves that cost £8.45, a rugby ball which cost £5.82 and a pair of football socks that cost £2.14. How much did [NAME] spend in total?
At a newsagent, [NAME] bought a newspaper that cost £0.75, a can of lemonade which cost £1.63 and a packet of chewing gum that cost £0.33. How much did [NAME] spend in total?
In a supermarket, Scott bought a tin of soup that cost £1.94, a box of cereal which cost £1.29 and a box of eggs that cost £1.56. How much did Scott spend in total?
In a bicycle shop, [NAME] bought a bike pump that cost £6.41, a spare tyre which cost £5.90 and a speedometer that cost £12.49. How much did [NAME] spend in total?
On a shopping trip, Azita bought a necklace that cost £2.67, a pair of shorts which cost £7.32 and a pair of leggings that cost £15.33. How much did [NAME] spend in total?
In a charity shop, Nathaniel bought a book that cost £0.66, a board game which cost £1.30 and a coat that cost £5.59. How much did [NAME] spend in total?