tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 96322d1295725492-excel-2007-average-calculation-with-two-criterias-dummy
Sheet: Blad1

Date | weekday | Result
2010-01-01 00:00:00 | [NAME]
2010-01-02 00:00:00 | Söndag |  |  |  | Month-> | january
2010-01-03 00:00:00 | Måndag |  |  |  | Weekday-> | [NAME]
2010-01-04 00:00:00 | Tisdag | 3240
2010-01-05 00:00:00 | Onsdag | 4515
2010-01-06 00:00:00 | Torsdag
2010-01-07 00:00:00 | Fredag | 2089
2010-01-08 00:00:00 | [NAME] | 1375
2010-01-09 00:00:00 | Söndag
2010-01-10 00:00:00 | Måndag
2010-01-11 00:00:00 | Tisdag | 2901
2010-01-12 00:00:00 | Onsdag | 1995
2010-01-13 00:00:00 | Torsdag | 2679
2010-01-14 00:00:00 | Fredag | 1097
2010-01-15 00:00:00 | [NAME] | 6580
2010-01-16 00:00:00 | Söndag
Spreadsheet: 154904d1336594418-analyse-date-frequency-cross-referencing-multiple-date-ranges-pastrentalsummarydataexamples
Sheet: IndivDateSummary

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
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 |  | N/A
31 |  | N/A |  | N/A |  | N/A |  |  | N/A |  | N/A
Spreadsheet: 763600d1642264628-if-and-or-function-book22
Sheet: Sheet1

Yellow, Gold or Orange | contains “Shirt | contain “Apple | equal to YES | DOES NOT contain apple | Contains apple
Yellow | Big shirt | [NAME] | Yesno
Gold | shirt | apple | Yes
Orange | tiny wee shirt | Pomegranate | Yes
Orange | tiny wee shirt | Apple | Yes
Spreadsheet: 772264d1647133263-calculating-cost-of-cargo-from-pricing-criteria-shipping-cost
Sheet: shipping cost

Cargo Class | Delivery Method | Total Weight (Tonnes) | Total Cube | WM | Height | Cost |  | Quarter |  |  | Q1 |  |  |  |  |  |  |  | Q2
AUTO | DIRECT | 1.85 | 18.2 |  | 1.8 |  |  | Q1
AUTO | DIRECT | 1.85 | 18.2 |  | 1.8 |  |  |  |  |  | Cargo Type | Delivery Method | Tonnes | Cube | WM | Height (metres) | Price (USD) |  | Cargo Type | Delivery Method | Tonnes | Cube | WM | Height (metres) | Price (USD)
AUTO | TRANSHIP | 1.85 | 18.2 |  | 2.5 |  |  |  |  |  | AUTO | DIRECT |  |  | >20 |  | 100 |  | AUTO | DIRECT |  |  | >20 |  | 115
CRATE | DIRECT | 20.28 | 18.3 |  | 1.8 |  |  |  |  |  | AUTO | DIRECT |  |  |  | >2 | 100 |  | AUTO | DIRECT |  |  |  | >2 | 115
CRATE | DIRECT | 20.28 | 18.3 |  | 1.8 |  |  |  |  |  | AUTO | DIRECT |  |  | <=20 | <=2 | 50 |  | AUTO | DIRECT |  |  | <=20 | <=2 | 65
CRATE | TRANSHIP | 20.28 | 18.3 |  | 1.8 |  |  |  |  |  | RORO | DIRECT | X |  |  |  | 150 |  | RORO | DIRECT | X |  |  |  | 165
RORO | DIRECT | 50 | 18.3 |  | 1.8 |  |  |  |  |  | CRATE | DIRECT |  |  | X |  | 40 |  | CRATE | DIRECT |  |  | X |  | 60
RORO | TRANSHIP | 15 | 18.3 |  | 1.8 |  |  |  |  |  | AUTO | TRANSHIP |  |  | >20 |  | 150 |  | AUTO | TRANSHIP |  |  | >20 |  | 175
RORO | DIRECT | 50 | 18.3 |  | 1.8 |  |  |  |  |  | AUTO | TRANSHIP |  |  |  | >2 | 150 |  | AUTO | TRANSHIP |  |  |  | >2 | 175
RORO | TRANSHIP | 15 | 18.3 |  | 1.8 |  |  |  |  |  | AUTO | TRANSHIP |  |  | <=20 | <=2 | 100 |  | AUTO | TRANSHIP |  |  | <=20 | <=2 | 125
AUTO | DIRECT | 2.36 | 30 |  | 3.4 |  |  |  |  |  | RORO | TRANSHIP | X |  |  |  | 200 |  | RORO | TRANSHIP | X |  |  |  | 225
AUTO | DIRECT | 2.3 | 30 |  | 3.4 |  |  |  |  |  | CRATE | TRANSHIP |  |  | X |  | 90 |  | CRATE | TRANSHIP |  |  | X |  | 115
AUTO | DIRECT | 2.3 | 30 |  | 3.4
AUTO | DIRECT | 2.36 | 30 |  | 3.4
AUTO | TRANSHIP | 2.36 | 30 |  | 3.4
AUTO | TRANSHIP | 2.36 | 30 |  | 3.4
AUTO | TRANSHIP | 2.3 | 30 |  | 3.4
AUTO | TRANSHIP | 2.36 | 30 |  | 3.4
AUTO | DIRECT | 2.36 | 30 |  | 3.4
AUTO | DIRECT | 2.36 | 30 |  | 3.4
CRATE | TRANSHIP | 32 | 30 |  | 1.6
CRATE | TRANSHIP | 32 | 30 |  | 1.6
CRATE | DIRECT | 33 | 25 |  | 1.6
CRATE | DIRECT | 33 | 25 |  | 1.6
Spreadsheet: 143535d1330453621-option-to-find-duplicates-as-opposed-to-remove-duplicates-dash-and-add
Sheet: Sheet1

[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 329659d1404378732-collate-data-problem-solving-sample-work-book
Sheet: Tab 2

 |  |  |  |  |  |  |  | Price [NAME]
 | Labour | Grade | Cost | Personnel | Days | Hr/Day
 | Travel and Subsistence | Basis
 | Materials and Subcontract | Basis | Cost
 | Pricing
 | Total labour
 | Total T&S
 | Total materials
Spreadsheet: 491169d1480349382-requesting-some-help-with-regards-to-a-vlookup-formula-sample-sheet-2
Sheet: Sheet1

Date | Time | Location | Repair | A/B | GROUP | EMPLOYEE | HAZARD |  | Date Range | 2016-03-20 00:00:00 | 2016-03-22 00:00:00
2016-03-17 00:00:00 | 250 | 111 access st | road sign | a | A1 | JONES | N
2016-03-17 00:00:00 | 1350 | 3941 adams ave | road sign | a | A1 | JONES | N |  | Number of:
2016-03-19 00:00:00 | 1440 | 218 freedom | road sign | a | A3 | GILROY | N |  | B |  |  | A | 8 |  | REPAIR |  |  | 0-700 TIMESLOT
2016-03-20 00:00:00 | 1445 | 897 rock well | pavement | a | B1 | BENS | Y |  | AT ADAMS AVE | 1 |  | AT ADAMS | 3 |  | ROAD SIGN |  |  | AT ADAMS | 1
2016-03-21 00:00:00 | 1928 | 2240 steam st | pavement | a | C2 | DAVIDS | Y |  |  |  |  |  |  |  | AT ADAMS | 2
2016-03-22 00:00:00 | 120 | 5992 major st | pavement | b | B2 | [NAME] | Y |  | Time Slots |  |  |  |  |  |  |  |  | 701-1600
2016-03-22 00:00:00 | 700 | 4876 arthur st west | road sign | b | A2 | NELSON | Y |  | From | To |  |  |  |  |  |  |  | AT ADAMS | 2
2016-03-22 00:00:00 | 1850 | 2401 zebra | pavement | B | A2 | WAGER | N |  | 0 | 700 |  | 2
2016-03-22 00:00:00 | 1400 | 111 access st | road sign | B | C1 | TOM | Y |  | 701 | 1600 |  | 0 |  |  |  |  |  | 1601-2400
2016-03-23 00:00:00 | 900 | 3941 adams ave | pavement | A | [NAME] | BILLINGS | N |  | 1601 | 2400 |  | 2 |  |  |  |  |  | AT ADAMS | 1
2016-03-25 00:00:00 | 535 | 3946 adams ave | pavement | A | B1 | FRAN | Y
2016-03-29 00:00:00 | 1900 | 1119 access st | road sign | a | B3 | DELL | Y |  |  |  |  |  | GROUP A1 |  | TOTAL A | 3
2016-03-29 00:00:00 | 2200 | 2200 adams ave | road sign | B | B3 | SANS | Y |  |  |  |  |  |  |  | TOTAL B | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AT LOCATION
 |  |  |  |  |  |  |  |  | 0 | 700 | 2 |  |  |  | ADAMS | 1
 |  |  |  |  |  |  |  |  | 701 | 1600 | 6 |  |  |  | A | 1
 |  |  |  |  |  |  |  |  | 1601 | 2400 | 4 |  |  |  | B | 0
 |  |  |  |  |  |  |  |  | ACCESS ST | Road Sign | B
 |  |  |  |  |  |  |  |  | ACCESS ST | PAVEMENT | B
 |  |  |  |  |  |  |  |  | ADAMS AVE | Road Sign | B
 |  |  |  |  |  |  |  |  | ADAMS AVE | PAVEMENT | B
 |  |  |  |  |  |  |  |  | ACCESS ST | Road Sign | A
 |  |  |  |  |  |  |  |  | ACCESS ST | PAVEMENT | A
 |  |  |  |  |  |  |  |  | ADAMS AVE | Road Sign | A
 |  |  |  |  |  |  |  |  | ADAMS AVE | PAVEMENT | A
Spreadsheet: 800429d1665664975-formula-to-return-multiple-matches-training-courses
Sheet: 2022.2023

W/C | Course Name | wk | Trainee Name | Result | Training Location
2022-09-20 00:00:00 | Delegate Examiner LGV | Wk 2 | [NAME] | Attended | [NAME]
2022-05-23 00:00:00 | [NAME] | Wk 1 | [NAME] | Completed - Week 1 | Leconfield
2022-05-30 00:00:00 | [NAME] | Wk 2 | [NAME] | Pass | Leconfield
2022-06-06 00:00:00 | CPC Training Group | Wk 1 | [NAME] | Pass | [NAME]
2022-05-16 00:00:00 | LDTM Supervision | Wk 1 | [NAME] | Completed - Week 1 | Avonmouth
2022-05-23 00:00:00 | LDTM Supervision | Wk 2 | [NAME] | Pass | Avonmouth
2022-04-04 00:00:00 | New Entrant X Mod 2 | Wk 3 | [NAME] | Completed - Week 3 | Leeds
2022-04-11 00:00:00 | New Entrant X Mod 2 | Wk 4 | [NAME] | Pass | Leeds
2022-09-20 00:00:00 | MC Development Week | Wk 3 | [NAME] | Pass | [NAME]
2022-09-12 00:00:00 | New Entrant I Mod 1 | Wk 1 | [NAME] | Attended | Virtual
2022-09-20 00:00:00 | New Entrant I Mod 2 | Wk 1 | [NAME] | Completed - Week 1 | Avonmouth
2022-09-26 00:00:00 | New Entrant I Mod 2 | Wk 2 | [NAME] | Further Development Needed | Avonmouth
2022-10-03 00:00:00 | New Entrant I Mod 2 | Wk 2 | [NAME] | Completed - Week 2 | Avonmouth
2022-10-10 00:00:00 | New Entrant i Mod 2 | Wk 3 | [NAME] |  | Avonmouth
2022-08-08 00:00:00 | New Entrant G Mod 1 | Wk 1 | [NAME] | Attended | Virtual
2022-08-15 00:00:00 | New Entrant G Mod 2 | Wk 1 | [NAME] | Completed - Week 1 | Brentwood
2022-08-22 00:00:00 | New Entrant G Mod 2 | Wk 2 | [NAME] | Completed - Week 2 | Brentwood
2022-08-29 00:00:00 | New Entrant G Mod 2 | Wk 3 | [NAME] | Further Development Needed | Brentwood
2022-09-05 00:00:00 | New Entrant G Mod 2 | Wk 3 | [NAME] | Further Development Needed | Brentwood
2022-09-12 00:00:00 | New Entrant G Mod 2 | Wk 5 | [NAME] | Further Development Needed | Brentwood
2022-10-03 00:00:00 | New Entrant I Mod 2 | Wk 3 | [NAME] | Completed - Week 3 | Brentwood
2022-10-10 00:00:00 | New Entrant i Mod 2 | Wk 4 | [NAME] |  | Brentwood
2022-04-04 00:00:00 | LDTM Supervision | Wk 1 | [NAME] |  | Slough
2022-04-11 00:00:00 | LDTM Supervision | Wk 1 | [NAME] | FTC | Slough
2022-08-29 00:00:00 | New Entrant H Mod 1 | Wk 1 | [NAME] | Attended | Virtual
2022-09-05 00:00:00 | New Entrant H Mod 2 | Wk 1 | [NAME] | Completed - Week 1 | Cambridge
2022-09-12 00:00:00 | New Entrant H Mod 2 | Wk 2 | [NAME] | Completed - Week 2 | Cambridge
2022-09-20 00:00:00 | New Entrant H Mod 2 | Wk 3 | [NAME] | Completed - Week 3 | Cambridge
2022-09-26 00:00:00 | New Entrant H Mod 2 | Wk 4 | [NAME] | Pass | Cambridge
 | Course Name | Training Location
 | CPC Training Group | [NAME]
 | Delegate Examiner LGV | [NAME]
 | LDTM Supervision | Avonmouth
 |  | Slough
 | MC Development Week | [NAME]
 | New Entrant G Mod 1 | Virtual
 | New Entrant G Mod 2 | Brentwood
 | New Entrant H Mod 1 | Virtual
 | New Entrant H Mod 2 | Cambridge
 | New Entrant I Mod 1 | Virtual
 | New Entrant I Mod 2 | Avonmouth
 |  | Brentwood
 | New Entrant X Mod 2 | Leeds
 | [NAME] | Leconfield
 | Grand Total
Spreadsheet: 864945d1712070149-calculate-accurate-weightings-with-upper-limit-weighting_problem
Sheet: Sheet1

Stock | Market Capitalisation | Weighting | Weighting Check | Weighting New
1 | 169896.0981
2 | 38279.0811
3 | 40017.1293
4 | 152105.58
5 | 133423.8117
6 | 47683.4289
7 | 62382.1071
8 | 100048.9488
9 | 58822.8672
10 | 782397.024
11 | 646884.0396
12 | 637721.1165
13 | 80577.9222
14 | 58191.939
15 | 34945.1334
16 | 95662.5618
17 | 207353.2224
18 | 64491.5055
19 | 134661.8328
20 | 58702.86840000001
TOTAL | 3604248.2178
Spreadsheet: 851159d1701374944-filtered-list-from-array-based-on-unique-rows-and-maximum-value-of-a-column-filtered-list-from-array-excelforum
Sheet: Sheet1

Date | Name | Item | Quantity | Cumulative Quantity
2023-09-20 00:00:00 | ABC | 1 | 5 | 5
2023-09-20 00:00:00 | ABC | 2 | 10 | 10
2023-09-20 00:00:00 | DEF | 1 | 20 | 20
2023-09-20 00:00:00 | DEF | 2 | 30 | 30
2023-10-20 00:00:00 | ABC | 2 | 20 | 30
2023-10-20 00:00:00 | DEF | 1 | 20 | 40
Desired Result:
Date | Name | Item | Quantity | Cumulative Quantity
2023-09-20 00:00:00 | ABC | 1 | 5 | 5
2023-10-20 00:00:00 | ABC | 2 | 20 | 30
2023-10-20 00:00:00 | DEF | 1 | 20 | 40
2023-09-20 00:00:00 | DEF | 2 | 30 | 30
Spreadsheet: 179588d1347306599-two-dimensional-vlook-up-find-team-reporting-to-shift-sample_workbook_w_reporting_team-c
Sheet: Sample

ID | Description | Registered | Deadline | Reporting Shift | Reporting Team
Task ID 1 | Task Description 1 | 2012-09-01 15:06:00 | 2012-09-02 15:06:00 | Based on Registered time Reporting Shift should be populated from Shift roaster i.e., (A, B, C); refer shift roaster | Based on Registered date Reporting Team should be populated from shift roaster i.e., (Team 1, Team 2, Team 3, Team 4, Team 5); refer shift roaster
Task ID 2 | Task Description 2 | 2012-09-02 15:06:00 | 2012-09-03 15:06:00
Task ID 3 | Task Description 3 | 2012-09-03 12:40:00 | 2012-09-04 12:40:00
Task ID 4 | Task Description 4 | 2012-09-03 23:40:00 | 2012-09-04 23:40:00
Task ID 5 | Task Description 5 | 2012-09-06 20:33:00 | 2012-09-07 20:33:00
Task ID 6 | Task Description 6 | 2012-09-05 05:41:00 | 2012-09-06 05:41:00
Task ID 7 | Task Description 7 | 2012-09-04 17:30:00 | 2012-09-05 17:30:00 |  |  | Team 2
Task ID 8 | Task Description 8 | 2012-09-01 04:36:00 | 2012-09-02 04:36:00 |  |  | Team 3
Task ID 9 | Task Description 9 | 2012-09-02 15:06:00 | 2012-09-03 15:06:00 |  |  | Team 2
Task ID 10 | Task Description 10 | 2012-09-04 12:40:00 | 2012-09-04 12:40:00 |  |  | Team 4
Task ID 11 | Task Description 11 | 2012-09-03 23:40:00 | 2012-09-04 23:40:00
Task ID 12 | Task Description 12 | 2012-09-06 20:33:00 | 2012-09-07 20:33:00
Task ID 13 | Task Description 13 | 2012-09-05 05:41:00 | 2012-09-06 05:41:00
Task ID 14 | Task Description 14 | 2012-09-04 17:30:00 | 2012-09-05 17:30:00
Task ID 15 | Task Description 15 | 2012-09-01 04:36:00 | 2012-09-02 04:36:00
Spreadsheet: 220024d1363036433-help-extracting-certain-portion-of-a-cell-pendingtransactions-template
Sheet: Batch

TxnType | Account | MerchantReference | CardNumber | ExpiryDate | Amount | PreAuthNumber | CPC | CarHolderName
P | 9996 | = Tender ID |  | MMYY | 00.00 | = (Blank) | = (Bank) | = Customer
P | 9996 | 28300 | 4557839111235745 | 0615 | 117.60 |  |  | [NAME]
P | 9996 | 28339 | 4567270198788364 | 1113 | 72.00 |  |  | [NAME]
P | 9996 | 28355 | 5420113834442425 | 0414 | 90.00 |  |  | Sweeney [NAME]
P | 9996 | 28340 | 4929555641719999 | 0317 | 219.60 |  |  | [NAME]
Spreadsheet: 715907d1611915581-error-with-countif-why-sum-with-criteria-aligw
Sheet: Sheet1

CalendarWeek | Year | Value | helper
1 | 2020 | 18695.92 |  |  | CRITERIA
2 | 2020 | 25778.31 |  |  | 52021
3 | 2020 | 10174.06
4 | 2020 | 13163.79 |  |  | number of rows
5 | 2020 | 13402.45
6 | 2020 | 17256.78
7 | 2020 | 15241.13
8 | 2020 | 23650.76
9 | 2020 | 7774.820000000001
10 | 2020 | 12469.86
11 | 2020 | 15347.92
12 | 2020 | 10576.4
13 | 2020 | 14839.47
14 | 2020 | 20338.5
15 | 2020 | 20647.78
16 | 2020 | 7136.88
17 | 2020 | 20551.89
18 | 2020 | 8803.33
19 | 2020 | 16665
20 | 2020 | 9539.5
21 | 2020 | 26539.34
22 | 2020 | 30439.33
23 | 2020 | 31021.46
24 | 2020 | 11590.66
25 | 2020 | 17167.82
26 | 2020 | 14020.98
27 | 2020 | 34754.38
28 | 2020 | 19736.92
29 | 2020 | 19069.58
30 | 2020 | 9606.36
31 | 2020 | 26037.5
32 | 2020 | 30417.69
33 | 2020 | 19399.86
34 | 2020 | 12063.99
35 | 2020 | 23507.9
36 | 2020 | 24940.7
37 | 2020 | 16071.47
38 | 2020 | 24550.17
39 | 2020 | 17508.69
40 | 2020 | 18167.2
41 | 2020 | 7369.59
42 | 2020 | 13055.22
43 | 2020 | 16689.03
44 | 2020 | 11733.18
45 | 2020 | 18712.8
46 | 2020 | 14536.38
47 | 2020 | 14229.84
48 | 2020 | 14075.66
49 | 2020 | 32626.99
50 | 2020 | 34174.36
51 | 2020 | 11078.88
52 | 2020 | 21485.36
2 | 2021 | 9374.880000000001
3 | 2021 | 10807.27
4 | 2021 | 19113.33
5 | 2021 | 9645.42
Spreadsheet: 471359d1468969466-excel-calculation-problem-of-the-pi-value-beenleigh-mix-designs-2016
Sheet: Type 2.3 Lot 73

RAW MATERIALS MIX DESIGN
Product Type: | Type 2.3 | Location: | Beenleigh [NAME] |  | Blender: | Pug 2 |  | Lab No.
Grading Type: | "C" | Lot No.: | 73 |  | Issue # : | 1 |  | Date: | 2016-05-05 00:00:00
 |  |  |  |  |  | Con  33 | Con 31
 |  | Mix Proportion (%): |  |  | 100 | 75 | 25
 | 0.4963636363636364 |  |  |  | Percent Passing (%)
Sieve (mm) | Minimum | Maximum | 1/3 Minimum | 1/3 Maximum | Mix | Plant  Scalps 21/04/16 | Dust Av. Last 30 days
37.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100
19 | 80 | 100 | 86.66666666666667 | 93.33333333333333 | 99.25 | 99 | 100
9.5 | 55 | 90 | 66.66666666666667 | 78.33333333333333 | 84.25 | 79 | 100
4.75 | 40 | 70 | 50 | 60 | 65 | 54 | 98
2.36 | 30 | 55 | 38.33333333333334 | 46.66666666666666 | 46.25 | 37 | 74
0.425 | 12 | 30 | 18 | 24 | 20.625 | 17.5 | 30
0.075 | 5 | 20 | 10 | 15 | 10.2375 | 9.25 | 13.2
Liquid Limit |  | 25 |  |  | 0
Plasticty Index |  | 6 |  |  | 0
Linear Shrinkage |  | 3.5 |  |  | 0
[NAME] |  | 0.3-0.55 |  |  | 0.4963636363636364 | 0.5285714285714286 | 0.44 | #N/A | #N/A | #N/A
Spreadsheet: 171873d1343898053-listing-information-from-data-table-listing-information-from-data-table
Sheet: Summary

[NAME] |  |  |  | [NAME] |  |  |  | Jon
Ref | Date | Cost |  | Ref | Date | Cost |  | Ref | Date | Cost
Spreadsheet: 42548d1241089907-count-cells-down-with-a-number-in-formula-example
Sheet: Sheet1

 | 1 |  |  | 1 | #N/A
 | 2 |  |  | 2 | #N/A
 | 6 |  |  | 6 | #N/A |  |  | SMALL EXAMPLE TO WHAT I AM AFTER, COUNT THE VALUE IN COLUMN G TO COLUMN B SO IT DISPLAYS SHOW LH.
 | 7 |  |  | 7 | #N/A |  |  | SO IN THIS EXAMPLE I NEED H11 TO DISPLAY SHOW LH
 | 8 |  |  | 8 | #N/A |  |  | SO IF I CAN COUNT TH VALUE OF CELL G IN COLUMN B I WILL GET THE VALUE I NEED.
 | 11 |  |  | 11 | 7 | 7
 | SHOW LH | 11 |  | 12 | #N/A
 | 12 |  |  | 13 | #N/A
 | 13 |  |  | 17 | 11 | 11
 | 17
 | SHOW RH | 17
Spreadsheet: 887917d1738239997-combining-vlookups-on-multiple-sheets-book2-bytemarks-
Sheet: One A

 | DEF-one |  |  | 3
 | DEF-two |  |  | 5
 | DEF-three |  |  | 4
 | DEF-four |  |  | 5
 | DEF-five |  |  | 2
 | DEF-six |  |  | 3
 | DEF-seven |  |  | 5
 | DEF-eight |  |  | 4
 | DEF-nine |  |  | 1
 | DEF-ten |  |  | 4
Spreadsheet: 716930d1612430180-how-to-find-costumer-name-on-specified-product-a
Sheet: Data

Product | Customer
Apple | [NAME]
Orange | Boy
Orange | [NAME]
Apple | [NAME]
[NAME] | [NAME]
Citrus | Caren
Apple | Kiky
[NAME] | Ian
Apple | Bake
Citrus | Boy
Apple | Boy
Spreadsheet: 67050475-6265-4e0b-8bbe-fc23cdd588f2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8689 | 66281 | Atsuko | Yamada | JPN | 0 | 00:28:10 | 00:00:00 | 00:49:27 | 00:00:00 | 00:28:10 | 1 | [NAME]
Spreadsheet: 109785d1306537280-investment-and-present-value-present-value
Sheet: Sheet1

Investment | 70000 | 70000
Years | 4 | 4
Number of periods |  | 48
Annual inflation rate | 0.05 | 0.05
Monthly inflation rate
Monthly recieved income | 700 | 700
Monthly income growth | 350 | 0.13
Present value??
Spreadsheet: 1c7d3baf-e039-4749-812b-e1c050187fc1
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0035735 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | [NAME] | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Bladen | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did conjunctive utilization occur at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | BD-1 |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 9.75 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage             (if applicable) | 5-Day Upset              (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Bulk Distributed |  |  |  | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal |  |  |  | gal | min | in | in | gal | min | in | in
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
Monthly Loading (gallons): |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Spreadsheet: 2429692b-faa5-492e-a401-29d8ab7b2be2
Sheet: Wholesale access table

 | Title: | Fixed broadband wholesale lines and agreements |  |  |  |  |  | ,
 | Date: | January 2013
 | Full title: | Fixed broadband wholesale lines and agreements,  January 2013
 | Date | Incumbent's PSTN activated main lines | Availability of wholesale access
 | January 2013 |  | Fully unbundled lines |  |  | Shared access lines supplied by the incumbent to new entrants |  |  | Wholesale DSL lines supplied
 |  |  | Unbundled lines | FUL Requested lines | [NAME] of agreements | Shared lines | SAL Requested lines | SAL N. of  agreements | Bitstream access |  | Simple resale
 | Country |  |  |  |  |  |  |  | [NAME] lines | [NAME] agreements | [NAME] | [NAME]
 | BE | 2845501 | confidential |  | 10 | 9851 |  | 7 | 144542 | 15 | 9673 | 21
 | BG | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential
 | CZ | 1394067 | 45778 |  | 3 | 1097 |  | 3 | 105168 | 21
 | DK | 1234678 | 1148759 | N/A | 11 | 18487 | N/A | 5 | 149843 | 28 | 41706 | 25
 | DE | 30883000 | 9436000 |  | 200 | 52000 |  | 30 | 604300 | 30 | 1216700 | 6
 | EE | 371000 | 5821 | 5 |  |  |  |  | 121
 | EL | 4906124 | 1779852 | 48484 | 7 | 14706 | 50 | 6 | 25806
 | ES | 16053774 | 3078440 | 46392 | 18 | 183517 | 550 | 11 | 652169 | 29 | 3755 | 6
 | FR | 9685000 | 10004000 |  |  | 906000 |  |  | 1455000
 | IE | 1368261 | 14683 | confidential | confidential | 47661 | confidential | confidential | 204232 | confidential
 | IT | 14090382 | 5225032 | 37497 | 40 | 77535 | 282 | 17 | 1840200 | 175
 | CY | 319213 | 33088 |  | 3 | 90 |  | 3 | 3542 | 6
 | LV | 468976 |  |  | 2 |  |  | 2 | 143 | 12
 | LT | 540053 | 443 |  | 2 | 76 |  | 2 | 1257 | 6
 | LU | 198000 | 21615 | 429 | 6 |  |  | 5 |  | 1 | 13514 | 8
 | [NAME] | 1920106 | 14851 | 61 | 7 | 2088 |  | 5 | 93205 | 31
 | MT | 168370 |  |  |  |  |  |  | 376
 | NL | 5506357 | 579600 |  | 6 | 72000 |  | 2 | 218220 | 20 | 13480 | 1
 | AT | 2286400 | 269100 | 905 | 34 | 38 |  | 2 | 41865 | 50
 | PL | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential
 | PT | 2469314 | 147495 |  | 4 |  |  |  | 30738 | 9 | 272 | 4
 | RO | 2300000 | 420 |  | 11 | 90 |  | 11 | N/A | N/A | N/A | N/A
 | SI | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential
 | SK | 947424 | 253 |  | 1 |  |  | 1 | 60209 | 15
 | FI | 1650903 | 258913 |  |  | 10800 |  |  | 30559
 | SE | 2643201 | 251640 |  |  | 209863 |  |  | 14891 |  | 71829
 | UK | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential | confidential
Spreadsheet: john_zufferli__16786__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 14  2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | BOM | 32 | 33.5
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 31 | 32
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 31 | 32
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 30 | 31.5
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 30 | 31.5
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 30 | 31.5
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 34 | 35
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 34 | 35
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 34 | 35
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 36.5 | 38
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 36.5 | 38
 |  | DEC | 33.3 |  |  |  | DEC | 36.5 | 38
 |  |  |  |  |  |  | Feb Dec
Spreadsheet: 94189d1294072898-summation-using-v-lookup-dummy
Sheet: Sheet1

Items | 2010 |  | 2009
 | Current Month | Last Month | Current Month | Last Month
A | 10 | 11 | 9 | 10
E | 30 | 31 | 29 | 30
D | 25 | 26 | 24 | 25
C | 20 | 21 | 19 | 20
B | 15 | 16 | 14 | 15