tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: af3ecd7b-7570-427c-959f-b17e1cc818d6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: August 1, 2014 (10:30 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 229371
2004 | 229646 | 233241 | 235336 | 237875
2005 | 242085 | 244136 | 247183 | 247443
2006 | 250954 | 254990 | 258328 | 262731
2007 | 263776 | 266272 | 270025 | 272054
2008 | 276019 | 278206 | 280691 | 273572
2009 | 267266 | 267665 | 268736 | 271174
2010 | 273058 | 275612 | 279685 | 281383
2011 | 283078 | 290271 | 293177 | 293795
2012 | 297910 | 301286 | 303811 | 309614
2013 | 311967 | 314808 | 320087 | 326348
2014 | 329985 | X | X | X
Spreadsheet: 306f9f05-1efb-41d4-9c15-e0281c69651d
Sheet: CafeFavorites

 | Commodity Processing Worksheet |  |  | Bulk Egg |  | A566/100047
 | [NAME] is pleased to be a part of the National Processing Agreement (NPA). [NAME] is able to process commodity cheese into a variety of great tasting sandwiches.                                                             These sandwiches are sure to be a hit with both students and staff members.  Please use this form to help you calculate your sandwich order.
 |  |  |  |  |  | A |  | B |  | C |  | D |  | E
Product Code | Product Description | Commodity Code | Finished Gross Case Weight | Serving Size (oz) | [NAME] and M/MA | Estimated Number of Servings | \ | Servings Per Case | = | Total Finished Cases Needed | X | Amount of Commodity DF per case (in pounds) | = | Number of Commodity Pounds need to order
 | BREAKFAST ITEMS
51160 | [NAME] Sandwich (IW & WG) | 100047   (A566) | 21.09 | 3.5 | 1 BR.  1 M/MA |  |  | 90 |  |  |  | 3.79
52160 | Mighty Breakfast Sandwich (IW & WG) | 100047   (A566) | 17.95 | 4.4 | 2 BR. 2 M/MA |  |  | 60 |  |  |  | 3.47
50112 | Sunrise Twist-Sausage, Egg & Cheese (IW & WG) | 100047   (A566) | 27.3 | 3.7 | 1 BR.  2 M/MA |  |  | 112 |  |  |  | 4.71
50140 | Sunrise Twist-Egg & Cheese (IW & WG) | 100047   (A566) | 23.4 | 2.5 | 1 BR. 1.25 M/MA |  |  | 140 |  |  |  | 5.89
51140 | Sunrise Twist-Turkey Ham, Egg & Cheese (IW & WG) | 100047   (A566) | 25.9 | 2.8 | 1 BR.  1.5 M/MA |  |  | 140 |  |  |  | 5.89
 |  |  |  |  |  |  | TOTAL Commodity Pounds Needed |  |  |  |  |  |  |  | A566
 | [NAME] |  |  |  |  | Customer's Name
 | www.cafefavorites.com
 | [PHONE] |  |  |  |  | Address
 | Visit the website for Product and Broker Contact Information
 |  |  |  |  |  | City / State / Zip
 |  |  |  |  |  | Contact
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Phone
 |  |  |  |  |  | Fax
 |  |  |  |  | Authorized Signature
Spreadsheet: 62676d1263572510-auto-populate-the-selection-from-the-database-justinng
Sheet: Lookup

State ID Lookup | Arizona
State ID | Product ID | Quantity | Gross Sales | Net Sales | Cost | Number of Orders
Arizona | Product 14 | 104 | 52000 | 42640 | 39000 | 1
Arizona | Product 17 | 30 | 57000 | 46740 | 42750 | 1
Arizona | Product 2 | 50 | 10000 | 8200 | 7500 | 1
Arizona | Product 3 | 50 | 500 | 410 | 350 | 1
Arizona | Product 4 | 202 | 4040 | 3312 | 3030 | 4
Arizona | Product 5 | 62 | 62000 | 50840 | 46500 | 1
Arizona | Product 7 | 212 | 2120 | 1738 | 1484 | 1
Spreadsheet: b6ce2ba8-34e0-4b23-880b-744c4c5e87a1
Sheet: Sheet1

PROG ID | ATHLETE ID | TEAM FIRST | TEAM LAST | NATIONALITY | START NUMBER | LEG 1 | LEG 2 | LEG 3 | LEG 4 | POSITION | TOTAL TIME
7123 | 11433 | Team I | Russia | RUS | 0 | 00:24:01 | 00:00:00 | 00:25:45 | 00:00:00 | 1 | 01:16:15
Spreadsheet: 462858d1464206194-threat-matrix-tiering-system-threat-matrix-ndm-2-
Sheet: Gangs

Gangs | 0
 | 0
Gang 1
Gang 2
Gang 3
Gang 4
Gang 5
Gang 6
Gang 7
Gang 8
Gang 9
Gang 10
Gang 11
Gang 12
Gang 13
Gang 14
Gang 15
Gang 16
Gang 17
Gang 18
Gang 19
Gang 20
Gang 21
Gang 22
Gang 23
Gang 24
Gang 25
Spreadsheet: 875184d1721762665-covert-column-days-into-rows-to-map-a-call-schedule-in-the-format-we-require-call-schedule-challenge-rjc00001-
Sheet: WANT

BDR | AccountId | Name | Outlet Status | Day of Week | Call? |  | BDR | AccountId | Name | Outlet Status | Day of Week | Call?
Rodger Federer | 1231 | ABC Outlet | OPEN | Monday1 | 1 |  | Rodger Federer | 1232 | BDE Outlet | OPEN | Monday | 1
Rodger Federer | 1233 | AMD Outlet | OPEN | Tuesday1 | 1 |  | Rodger Federer | 1234 | GCD Outlet | OPEN | Tuesday | 1
Rodger Federer | 1234 | GCD Outlet | OPEN | Tuesday1 | 1 |  | Rodger Federer | 1233 | AMD Outlet | OPEN | Tuesday | 1
Rodger Federer | 1231 | ABC Outlet | OPEN | Wednesday1 | 1 |  | Rodger Federer | 1231 | ABC Outlet | OPEN | Wednesday | 1
Rodger Federer | 1235 | APE Outlet | OPEN | Thursday1 | 1 |  | Rodger Federer | 1235 | APE Outlet | OPEN | Thursday | 1
Rodger Federer | 1231 | ABC Outlet | OPEN | Friday1 | 1 |  | Rodger Federer | 1231 | ABC Outlet | OPEN | Friday | 1
Rodger Federer | 1233 | AMD Outlet | OPEN | Monday2 | 1 |  | Rodger Federer | 1235 | APE Outlet | OPEN | Saturday | 1
 |  |  |  |  |  |  | Rodger Federer | 1233 | AMD Outlet | OPEN | Monday | 1
 |  |  |  |  |  |  | Rodger Federer | 1231 | ABC Outlet | OPEN | Tuesday | 1
 |  |  |  |  |  |  | Rodger Federer | 1232 | BDE Outlet | OPEN | Wednesday | 1
 |  |  |  |  |  |  | Rodger Federer | 1235 | APE Outlet | OPEN | Thursday | 1
 |  |  |  |  |  |  | Rodger Federer | 1235 | APE Outlet | OPEN | Saturday | 1
 |  |  |  |  |  |  | Rodger Federer | 1232 | BDE Outlet | OPEN | Saturday | 1
 |  |  |  |  |  |  | Rodger Federer | 1231 | ABC Outlet | OPEN | Monday | 1
 |  |  |  |  |  |  | Rodger Federer | 1235 | APE Outlet | OPEN | Tuesday | 1
 |  |  |  |  |  |  | Rodger Federer | 1234 | GCD Outlet | OPEN | Wednesday | 1
 |  |  |  |  |  |  | Rodger Federer | 1232 | BDE Outlet | OPEN | Wednesday | 1
 |  |  |  |  |  |  | Rodger Federer | 1235 | APE Outlet | OPEN | Thursday | 1
 |  |  |  |  |  |  | Rodger Federer | 1231 | ABC Outlet | OPEN | Friday | 1
 |  |  |  |  |  |  | Rodger Federer | 1235 | APE Outlet | OPEN | Saturday | 1
 |  |  |  |  |  |  | Rodger Federer | 1235 | APE Outlet | OPEN | Friday | 1
 |  |  |  |  |  |  | Rodger Federer | 1231 | ABC Outlet | OPEN | Saturday | 1
 |  |  |  |  |  |  | Rodger Federer | 1231 | ABC Outlet | OPEN | Monday | 1
 |  |  |  |  |  |  | Rodger Federer | 1233 | AMD Outlet | OPEN | Tuesday | 1
 |  |  |  |  |  |  | Rodger Federer | 1234 | GCD Outlet | OPEN | Tuesday | 1
 |  |  |  |  |  |  | Rodger Federer | 1235 | APE Outlet | OPEN | Wednesday | 1
 |  |  |  |  |  |  | Rodger Federer | 1231 | ABC Outlet | OPEN | Wednesday | 1
 |  |  |  |  |  |  | Rodger Federer | 1231 | ABC Outlet | OPEN | Thursday | 1
 |  |  |  |  |  |  | Rodger Federer | 1235 | APE Outlet | OPEN | Thursday | 1
 |  |  |  |  |  |  | Rodger Federer | 1233 | AMD Outlet | OPEN | Friday | 1
Spreadsheet: 05fe99ce-2e3e-4653-8480-92c54b45c2f3
Sheet: 3. CostGSF

 | FY 2012 Federal Real Property Charts
 | Cost per Gross Square Feet of Buildings†
 | Fiscal Year | Owned Annual Operating Costs** | Gross Square Feet** | Owned Annual Operating Costs/ GSF** | Leased Annual Costs*** | Gross Square Feet | Leased Annual Costs/ GSF
 | FY 2011 | 15218985676.046 | 2752533221.22 | 5.529083376258187 | 8810308899.262001 | 556789143.802 | 15.82342076409995
 | FY 2012 | 15776457592.822 | 2755557168.839 | 5.725324000252588 | 8805185191.179 | 546169917.58 | 16.12169566239295
 | † All real property data from the CFO Act agencies required to submit data to the FRPP
 | **includes federal government owned, foreign government owned, museum trust, and state government owned
 | ***Includes operations and maintenance costs and rent
 | Note, is it difficult to compare Owned and Leased Annual Operating Costs (AOC) due to their make-up.  Owned AOC only includes operations and maintenance costs, whereas Leased AOC also includes rent to capture the full cost of the asset.
Spreadsheet: 791740d1660571115-pay-as-you-earn-calculation-paye-calculator-hd1-1-
Sheet: Sheet1

Date of Birth | 1963-12-02 00:00:00 | 1942-04-08 00:00:00
Tax start period | 2021-07-01 00:00:00 | 2021-07-01 00:00:00
Tax end period | 2022-06-30 00:00:00 | 2022-06-30 00:00:00
Gross earnings | 123000 | 345000
Pension fund (Tax Deductible | 1755 | 1755
Taxable pay
Annual Tax rebate (not more than 60 years of ages | 8200 | 8200
Annual Tax rebate (more than 60 years of ages | 10900 | 10900
The rates of Income Tax applicable are as follows:
RATES OF NORMAL TAX FOR INDIVIDUALS
Exceeds | Does not exceed
Taxable Income |  |  |  | Rates
0 | 100000 | 0 | 0.2 | E0           +  20% of the excess of E0 00
100000 | 150000 | 20000 | 0.25 | E20 000 + 25% of the excess of E100 000
150000 | 200000 | 32500 | 0.3 | E32 500 + 30% of the excess of E150 000
200000 |  | 47500 | 0.33 | E47 500 + 33% of the excess of E200 000
 | not more than 60 years | more than 60 years
Tac pro year
Taks pro month
Spreadsheet: 693551d1599034125-sum-if-multiple-criteria-sum-if-formula-helpsumproductandmatch
Sheet: Sheet1

[NAME] | Values | Control | Test |  |  |  | Test | Control | %Control | % Test | CONTROL TOTAL | TEST TOTAL
Affinity | Dislike itDislike it | 6 | 5 |  |  | Affinity |  |  |  |  | 156 | 304
Affinity | Hate itHate it | 1 |  |  |  | Consideration
Affinity | Like itLike it | 65 | 132 |  |  | CTA
Affinity | Love itLove it | 59 | 126
Affinity | NeutralNeutral | 25 | 41
Consideration | Somewhat likely | 59 | 90
Consideration | Very likely | 77 | 153
CTA | Somewhat likely | 71 | 108
CTA | Very likely | 52 | 153
Spreadsheet: 80836d1281017405-adjust-logarithmic-scale-adjust-chart-gasification-process
Sheet: Tabelle1

CHEMCAD | 6.2.0 | Page | 1
Job name: | carbon_gasification | Date: | 2010-07-06 00:00:00 | Time: | 16:46:23
Sensitivity Analysis Report
carbon gasification
Run | temperature | hydrogen | carbon | carbon_monoxide
# | K | kmol/h | kmol/h | kmol/h |  | k
0 | 300 | 0 | 1 | 0
1 | 375 | 2.26577e-06 | 0.999997 | 2.26577e-06
2 | 450 | 7.89502e-05 | 0.999921 | 7.89502e-05
3 | 525 | 0.00100942 | 0.998991 | 0.00100942
4 | 600 | 0.00684436 | 0.993155 | 0.00684436
5 | 675 | 0.0299099 | 0.97009 | 0.0299099
6 | 750 | 0.0930141 | 0.906986 | 0.0930141
7 | 825 | 0.215512 | 0.784488 | 0.215512
8 | 900 | 0.384702 | 0.615298 | 0.384702
9 | 975 | 0.556498 | 0.443502 | 0.556498
10 | 1050 | 0.695188 | 0.304812 | 0.695188
11 | 1125 | 0.792912 | 0.207088 | 0.792912
12 | 1200 | 0.857652 | 0.142347 | 0.857652
13 | 1275 | 0.899876 | 0.100123 | 0.899876
14 | 1350 | 0.927649 | 0.0723514 | 0.927649
15 | 1425 | 0.946275 | 0.0537245 | 0.946275
16 | 1500 | 0.959068 | 0.0409319 | 0.959068
17 | 1575 | 0.968071 | 0.0319289 | 0.968071
18 | 1650 | 0.974558 | 0.0254419 | 0.974558
19 | 1725 | 0.979336 | 0.0206639 | 0.979336
20 | 1800 | 0.982927 | 0.0170724 | 0.982927
Run | temperature | water
# | K | kmol/h
0 | 300 | 1
1 | 375 | 0.999997
2 | 450 | 0.999921
3 | 525 | 0.998991
4 | 600 | 0.993155
5 | 675 | 0.97009
6 | 750 | 0.906986
7 | 825 | 0.784488
8 | 900 | 0.615298
9 | 975 | 0.443502
10 | 1050 | 0.304812
11 | 1125 | 0.207088
12 | 1200 | 0.142347
13 | 1275 | 0.100123
14 | 1350 | 0.0723514
15 | 1425 | 0.0537245
16 | 1500 | 0.0409319
17 | 1575 | 0.031929
18 | 1650 | 0.025442
19 | 1725 | 0.0206639
20 | 1800 | 0.0170726
Spreadsheet: 825444d1681316631-search-names-between-sheets-find-names-between-sheets
Sheet: Plan1

Code | Matric. | Name | [NAME] here :
2502 | 11308 | ADAO CARLOS DE MORAIS | Not Found
2502 | 6906 | ADEILSON CARNEIRO DE CARVALHO | ADEILSON CARNEIRO DE CARVALHO
2502 | 1683 | ADILSON ARCHILA | ADILSON ARCHILA
2502 | 175 | [NAME] | Not Found
2502 | 8929 | ADSON BATISTA | ADSON BATISTA
2502 | 11456 | [NAME] FERREIRA | [NAME]FERREIRA
2502 | 11300 | EDILSON GONÇALVES DE OLIVEIRA | EDILSON GONCALVES DE OLIVEIRA
Spreadsheet: 97268d1296499333-sequencing-copy-of-episodecounter
Sheet: Sheet1

Client | Episode
22 |  | <<< Here is your [NAME] and copy down
44
77
44
11
33
55
88
55
55
55
55
Spreadsheet: 624755d1558057134-calculate-number-of-employees-working-each-hour-4-tens-schedule-sample-vdillon-
Sheet: 05.13 (2)

Hotel Reservations Schedule
 | Monday
 | 2019-05-13 00:00:00
NAME | 00:00:00 | 10:30:00 | 7 | 8 | 9 | 10 | 6
NAME | 06:00:00 | 16:30:00 | 7 | 8 | 9 | 10 | 6
NAME | 08:00:00 | 18:30:00 |  | 8 | 9 | 10
NAME | 10:00:00 | 20:30:00 |  |  |  | 10
NAME | 11:00:00 | 21:30:00
NAME | 11:00:00 | 22:30:00
NAME | 13:00:00 | 23:30:00
NAME | 13:00:00 | 23:30:00
NAME | 15:00:00 | 01:30:00
NAME | 23:00:00 | 09:30:00 | 7 | 8 | 9 |  | 6
NAME
NAME
NAME
NAME
NAME
NAME
NAME
NAME
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
 | [NAME] |  | Manual Calculations
07:00:00 |  | 07:00:00 | 1
08:00:00 |  | 08:00:00 | 2
09:00:00 |  | 09:00:00 | 2
10:00:00 |  | 10:00:00 | 3
11:00:00 |  | 11:00:00 | 5
12:00:00 |  | 12:00:00 | 5
13:00:00 |  | 13:00:00 | 7
14:00:00 |  | 14:00:00 | 7
15:00:00 |  | 15:00:00 | 8
16:00:00 |  | 16:00:00 | 8
17:00:00 |  | 17:00:00 | 7
18:00:00 |  | 18:00:00 | 7
19:00:00 |  | 19:00:00 | 6
20:00:00 |  | 20:00:00 | 6
21:00:00 |  | 21:00:00 | 5
22:00:00 |  | 22:00:00 | 4
23:00:00 |  | 23:00:00 | 4
00:00:00 |  | 1900-01-01 00:00:00 | 3
01:00:00 |  | 1900-01-01 01:00:00 | 3
02:00:00 |  | 1900-01-01 02:00:00 | 2
03:00:00 |  | 1900-01-01 03:00:00 | 2
04:00:00 |  | 1900-01-01 04:00:00 | 2
05:00:00 |  | 1900-01-01 05:00:00 | 2
06:00:00 |  | 1900-01-01 06:00:00 | 2
Spreadsheet: 502d7e42-7cfe-44a9-9136-1d8e47495707
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7101 | 47678 | [NAME] | [NAME] | ESP | 73 | 00:27:18 | 00:02:05 | 01:50:36 | 00:00:59 | 00:24:17 | 1 | 02:45:15
7101 | 47645 | Santiago | [NAME] | ESP | 72 | 00:26:48 | 00:01:37 | 02:06:59 | 00:00:48 | 00:37:55 | 2 | 03:14:11
7101 | 40953 | [NAME] | [NAME] | GBR | 70 | 00:27:08 | 00:02:53 | 02:21:12 | 00:01:23 | 00:58:54 | 3 | 03:51:31
7101 | 12645 | Santos | Caballero | ESP | 71 | 00:30:55 | 00:02:41 | [NAME] | [NAME] | 01:06:57 | 4 | 05:21:25
Spreadsheet: 3c3fb57a-02a8-4b86-afbe-ed320a1d0d5f
Sheet: Control Area

Annual Reconfiguration Auction Result Report
SP_ARARESULT_<customer id>_<commitment period begin>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Control Area RA Result
Start Date | End Date | Total Supply Offers Submitted | Total Supply Offers Cleared | Total Demand Bids Submitted | Total Demand Bids Cleared | Net Capacity Cleared | Total ISO Supply Offer | Total ISO Demand Bid | Total ISO Supply Offers Cleared | Total ISO Demand Bids Cleared
Date | Date | MW | MW | MW | MW | MW | MW | MW | MW | MW
Spreadsheet: 63842d1264704240-multiple-drop-down-list-to-equal-numbers-pointsforchairs
Sheet: Test

Day | Furniture |  | Stationery |  | Points |  |  |  |  |  | Furniture | Points | Stationery | Points
Monday | Chairs |  | Notepad |  | 45
Monday | Table |  | Pencils |  | 105 |  |  |  |  |  | Table | 100 | Lined Paper | 15
Tuesday | Coffee Table |  | Colouring Pencils |  | 45 |  |  |  |  |  | Chairs | 25 | Plain Paper | 15
Tuesday | Desk |  | Ruler |  | 60 |  |  |  |  |  | Desk | 50 | Notepad | 20
 |  |  | Total= |  | 255 |  |  |  |  |  | Coffee Table | 30 | Pens | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | Pencils | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | Colouring Pencils | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | Colouring Pens | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | Ruler | 10
Spreadsheet: kate_symes__18709__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-23 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472
 | 2001-02-22 00:00:00 |  | 216.97 | 18320 | 115.4 | 7080 | 206.96 | 2653 | 104.69 | 565
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600 | 175.48 | 1613 | 94.66 | 1119
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000 | 139.51 | 4942 | 140.75 | 1333
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 224.69 | 964
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 380.8 | 7853 | 212.12 | 765
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152 | 213.1 | 4017 | 117.86 | 910
 | 2001-02-12 00:00:00 |  | 194.93 | 17552 | 141 | 4752 | 165.13 | 3805 | 115.9 | 481
 | 2001-02-11 00:00:00 |  | 153.75 | 112 | 150 | 56 | 134.71 | 1414 | 82.08 | 149 |  | 141.16 | 14856
 | 2001-02-10 00:00:00 |  | 150.49 | 27080 | 104.14 | 5240 | 140.81 | 430 | 173.37 | 178
 | 2001-02-09 00:00:00 |  | 150.65 | 32480 | 104.14 | 5240 | 171.89 | 2860 | 131.06 | 362
 | 2001-02-08 00:00:00 |  | 182.53 | 10624 | 115.29 | 7280 | 188.98 | 1327 | 99.67 | 694
 | 2001-02-07 00:00:00 |  | 165.65 | 16640 | 113.79 | 6040 | 170.48 | 1096 | 90.98 | 1046
 | 2001-02-06 00:00:00 |  | 156.9 | 18000 | 117.37 | 6400 | 125.6 | 1999 | 88.75 | 1161
 | 2001-02-05 00:00:00 |  | 151.48 | 12400 | 128.84 | 4400 | 113.86 | 1196 | 83.59 | 982
 | 2001-02-04 00:00:00 |  | 145 | 0 | 120 | 0 | 99.69 | 4662 | 101.68 | 220 |  | 128.84 | 13200
 | 2001-02-03 00:00:00 |  | 168.58 | 13568 | 128.08 | 4200 | 117.03 | 3689 | 99.69 | 1202
 | 2001-02-02 00:00:00 |  | 178.98 | 11968 | 128.08 | 4200 | 152.67 | 7590 | 120.57 | 710
 | 2001-02-01 00:00:00 |  | 239.7 | 15792 | 151.12 | 4208 | 156.7 | 4400 | 127.04 | 2339
 | 2001-01-31 00:00:00 |  | 258.52 | 12800 | 158.13 | 5192 | 175.35 | 3038 | 132 | 1931
 | 2001-01-30 00:00:00 |  | 244.66 | 12560 | 140.9 | 5400 | 178.19 | 3125 | 120.98 | 1446
 | 2001-01-29 00:00:00 |  | 252.84 | 13440 | 177.78 | 5400 | 183 | 4553 | 122.38 | 2433
 | 2001-01-28 00:00:00 |  | 207.5 | 800 | 185 | 200 | 150.26 | 3312 | 132.26 | 2111 |  | 177.78 | 16200
 | 2001-01-27 00:00:00 |  | 225.83 | 13200 | 141.8 | 2840 | 152.11 | 781 | 114.82 | 728
 | 2001-01-26 00:00:00 |  | 225.83 | 13200 | 141.75 | 2800 | 223.17 | 1850 | 161.11 | 180
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040 | 153.9 | 2315 | 108.66 | 1079
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
Spreadsheet: 743248d1628328215-drop-downs-and-associated-formula-sample-55-ans
Sheet: Lists

ROUTE | JUNCTION | DISTANCE |  | ROUTE | JUNCTION | DISTANCE |  | ROUTE | JUNCTION | DISTANCE
N1 | 1. Ballybay | 0 |  | M3 | 1. Trimston | 0 |  | A5 | 1. [NAME] | 0
 | 2. Castlelawn | 23 |  |  | 2. Bluebell | 5 |  |  | 2. Kilmore | 30
 | 3. [NAME] | 52 |  |  | 3. Fernhill | 33 |  |  | 3. Fairymore | 37
 | 4. [NAME] | 76 |  |  | 4. Coalston | 45 |  |  | 4. Whitethorn | 52
 | 5. Birdcastle | 110 |  |  | 5. Breen | 67 |  |  | 4. Bonville | 92
Additional names  up to row in Columns B,F,J does not require any change in above formula
Spreadsheet: 104853d1302286587-find-all-repititions-of-contents-of-cell-within-a-text-column-listmatch-example
Sheet: ListMatch output

ID | Name | Current Output
A1 | [NAME], [NAME], [NAME] | A2, D3, A6, LA5, D1
A2 | [NAME], [NAME] | D3, [NAME], A6, LA5
D3 | [NAME], [NAME], [NAME] | A1, A2, A6, LA5
A4 | [NAME] | LA5
A5 | [NAME]
A6 | [NAME] | A1, A2, D3, LA5
A7 | [NAME] | A1, [NAME], A5
Z1 |  | A8, A9
LA4 | [NAME] | LB4
LA5 | [NAME] , [NAME] | A1, A2, D3, A6
LB4 | [NAME]
A8 |  | Z1, A9
A9 |  | Z1, A8
D1 | [NAME] | A1
Spreadsheet: 825058d1681093768-dependant-drop-down-list-display-data-from-multiple-dynamic-ranges-invoice_example
Sheet: Lists

 | List Type |  | List 1 (Manufacture) |  |  |  | List 2 (Retail) |  |  |  | Ideally these lists will populate dynamically from the price lists
 | Type |  | Item | Per | Price |  | Item | Per | Price
 | Manufacture |  | T-Shirt | ea. | 5 |  | T-Shirt | ea. | 10
 | Retail |  | Short | ea. | 8 |  | Jacket | ea. | 35
 |  |  | Jacket | ea. | 15 |  | Short | ea. | 14
 |  |  | Scarf | ea. | 10 |  | Glove | pair. | 6
 |  |  | Shoes | pair. | 40
 |  |  | Hat | ea. | 2
Spreadsheet: 162226d1339770843-count-formula-for-codes-problem
Sheet: Sheet1

Demand CODE |  | A |  | 8 |  | A |  | 3
 | 1st Code | Price | Total |  | 2nd Code | Price | Total
 | 83 | 100000 | should be times(*) with 2 |  | 83 | 50000 | disc 10%
 | C9 | 200000 | disc 10% |  | A8 | 100000 | disc 10%
 | [NAME] | 50000 | disc 10% |  | E3 | 200000 | disc 10%
 | A8 | 150000 | should be time(*) with 4 |  | A3 | 50000 | should be times with 5
 | B4 | 250000 | disc 10% |  | 8E | 150000 | disc 10%
 | G5 | 100000 | disc 10% |  | AE | 250000 | disc 10%
 | K7 | 50000 | disc 10%
my 1st problem is :
1. in the "Total Column (D6)" , I want the count is : if the "1st Code Column (B6)" first digit and second digit has 1 same code with the "CODE Column (C2,E2,G2 and I2)" then the "PRICE Column (C6)" should be times (*) with 2
2. in the "Total Column (D6)" , I want the count is : if the "1st Code Column (B6)" first digit has a 2 same code and second digit has 1 same code with the "CODE Column (C2,E2,G2 and I2)" then the "PRICE Column (C6)" should be times (*) with 4 {so with the opposite if first digit has 1 same code and second digit has 2 same code}
3. in the "Total Column (D6)" , I want the count is : if the "1st Code Column (B6)" first digit has a 3 same code and second digit has 1 same code with the "CODE Column (C2,E2,G2 and I2)" then the "PRICE Column (C6)" should be times (*) with 6 {so with the opposite if first digit has 1 same code and second digit has 3 same code}
4. in the "Total Column (D6)" , I want the count is : if the "1st Code Column (B6)" first digit has a 2 same code and second digit has 2 same code with the "CODE Column (C2,E2,G2 and I2)" then the "PRICE Column (B6)" should be times (*) with 6
5. if there is no same code or got only 1 same code in the first or second digit "1st Code Column (B6)" and "Code Column (C2,E2,G2 and I2) then the "Price Column (C6)" will get a 5% discount.
my 2nd problem is :
1.in the "Total Column (G6)" , I want the count is : if the "2nd Code Column (F6)" first digit has a same code with the "Code Column (G2) and the second digit has a same code with the "Code Column (I3)" then the price should be times (*) with 5
2.if there is no same code then the "Price Column (F6)" will get a 10% discount
Spreadsheet: 41339d1239811751-identify-list-and-sum-2-columns-test-time-sheet
Sheet: Apr 6-11

 | NAME:
 |  |  |  |  | TOTAL HRS |  |  |  |  |  |  | Job Key
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB [NAME]
2009-04-06 00:00:00 | 06:30:00 | 02:00:00 | 7 | OFFICE |  | PROJECT MANAGE |  |  |  |  |  | 1
 | 02:00:00 | 03:00:00 | 1 | OFFICE | 8 | QUOTE |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 1
2009-04-07 00:00:00 | 06:30:00 | 10:30:00 | 4 | 28099 |  | PROGRAM |  |  |  |  |  | 2
 | 10:30:00 | 03:00:00 | 4 | 29001 | 8 | PROGRAM |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 3
2009-04-08 00:00:00 | 06:30:00 | 09:00:00 | 2.5 | SHOP |  |  |  |  |  |  |  | 4
 | 09:00:00 | 12:00:00 | 3 | 27004 |  | RUN |  |  |  |  |  | 5
 | 12:00:00 | 03:00:00 | 2.5 | OFFICE | 8 | PROJECT MANAGE |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 5
2009-04-09 00:00:00 | - | - | 8 | VAC | 8 | VACATION |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 6
2009-04-10 00:00:00 | - | - | 8 | HOL | 8 | HOLIDAY |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7
 | SUMMARY | OFFICE | 10.5
 |  | 28099 | 4 |  |  |  |  |  | VACATION
 |  | 29001 | 4 |  |  |  |  | Accrued | 54
 |  | SHOP | 2.5 |  |  |  |  | Used | 8
 |  | 27004 | 3 |  |  |  |  | Remaining | 46
 |  | VAC | 8
 |  | HOL | 8
 |  | TOTAL | 40 | TOTAL | 40