tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 753773d1635752336-closest-distance-between-2-zipcodes-sample-zipcode-file
Sheet: Sheet2

tem | Product | Category (To be filled)
Item 1 | Product 1
Item 2 | Product 1
Item 3 | Product 1
Item 1 | Product 2
Item 1 | Product 3
Item 5 | Product 1
Item 4 | Product 4
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 5-5T

 | Section 5: Fuel Consumption
 | Table 5-5Trend: Vehicle Disposals by Fuel Type by Year
 | Fuel Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Gasoline |  |  |  | 27182
 | Diesel |  |  |  | 5540
 | Gasoline Hybrid |  |  |  | 507
 | Diesel Hybrid |  |  |  | 7
 | Gasoline LGHG |  |  |  | 208
 | Diesel LGHG | (Data not collected prior to 2012) |  |  | 1
 | Gasoline Plug-in Hybrid |  |  |  | 53
 | CNG |  |  |  | 336
 | E-85 |  |  |  | 13728
 | Electric |  |  |  | 159
 | Hydrogen |  |  |  | 3
 | LPG |  |  |  | 6
 | Grand Total |  |  |  | 47730
 | Note: Pursuant to guidance from the Environmental Protection Agency pertaining to §141 of the Energy Independence and Security Act (EISA), beginning in 2011 petroleum fueled vehicles meeting EPA's definition of low greenhouse gas (LGHG) vehicles may be considered alternative fuel vehicles (AFVs) when acquired for use in locations where alternative fuel is not available. Therefore, although these vehicles consume petroleum, agencies may consider them alternative fuel vehicles in the limited circumstances described.
 | Data not collected prior to 2012.
Spreadsheet: dutch_quigley__9178__NGDelta11-28
Sheet: Sheet1

Natural Gas
Month | Futures | Options | Total
2001-01-02 00:00:00 | 1828 | -617
2001-02-02 00:00:00 | -3181 | 686
2001-03-02 00:00:00 | 1747 | 259
2001-04-02 00:00:00 | -2272 | 76
2001-05-02 00:00:00 | 1261 | 207
2001-06-02 00:00:00 | -118 | 340
2001-07-02 00:00:00 | 49 | 0
2001-08-02 00:00:00 | -9322 | 2
2001-09-02 00:00:00 | -6113 | 203
2001-10-02 00:00:00 | 7962 | -20
2001-11-02 00:00:00 | -8536 | -359
2001-12-02 00:00:00 | 4723 | -122
2001-01-03 00:00:00 | 870 | 0
2001-02-03 00:00:00 | 5613 | 0
2001-03-03 00:00:00 | -603 | 16
2001-04-03 00:00:00 | -568 | 0
2001-05-03 00:00:00 | -1577 | 0
2001-06-03 00:00:00 | 3051 | 17
2001-07-03 00:00:00 | 3945 | 0
2001-08-03 00:00:00 | -751 | 0
2001-09-03 00:00:00 | -3 | 0
2001-10-03 00:00:00 | -812 | 0
2001-11-03 00:00:00 | -156 | 0
2001-12-03 00:00:00 | 2690 | 0
2001-01-04 00:00:00 | -3938 | 0
2001-02-04 00:00:00 | 2225 | 0
2001-03-04 00:00:00 | -194 | 0
2001-04-04 00:00:00 | 183 | 0
2001-05-04 00:00:00 | 43 | 0
2001-06-04 00:00:00 | 69 | 0
2001-07-04 00:00:00 | -11 | 0
2001-08-04 00:00:00 | 1874 | 0
2001-09-04 00:00:00 | -14 | -84
2001-10-04 00:00:00 | 205 | 0
2001-11-04 00:00:00 | 90 | 0
Spreadsheet: 135182d1325861047-how-to-set-listbox-for-coloumns-in-correct-way-definedlistboxv1
Sheet: List1

 |  | Date |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
1 |  | 2012-02-17 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | Item1 | 10
2 |  | 2012-04-06 00:00:00 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | Item2 | 12
3 |  | 2012-04-06 00:00:00 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | Item3 | 13
Spreadsheet: 836774d1689636858-average-of-average-in-one-formula-book1
Sheet: Sheet1

2023-01-31 00:00:00 | 0.01
2023-02-28 00:00:00
2023-03-31 00:00:00 | 0.02
2023-04-30 00:00:00
2023-05-31 00:00:00
2023-06-30 00:00:00 | 0.03
2023-07-31 00:00:00
2023-08-31 00:00:00
2023-09-30 00:00:00 | 0.04
2023-10-31 00:00:00
2023-11-30 00:00:00
2023-12-31 00:00:00 | 0.05 | 0.03375
2024-01-31 00:00:00 | 0.06
2024-02-29 00:00:00 | 0.07
2024-03-31 00:00:00 | 0.08
2024-04-30 00:00:00
2024-05-31 00:00:00
2024-06-30 00:00:00 | 0.09
2024-07-31 00:00:00
2024-08-31 00:00:00
2024-09-30 00:00:00
2024-10-31 00:00:00
2024-11-30 00:00:00
2024-12-31 00:00:00 |  | 0.08
Date Value | Output Value |  |  |  |  | Helper Column to Check if Orange Cells are Right
2023 Average of Col B |  | =AVERAGE(B1:B12)
2023 Average of Col C |  | =AVERAGE(C1:C12)
2024 Average of Col B |  | =AVERAGE(B13:B24)
2024 Average of Col C |  | =AGGREGATE(1,6,C13:C24)
Spreadsheet: 481102d1474284668-arrival-times-vs-access-times-formula-arrival-time-vs-access-times
Sheet: Sheet1

DLCARV | [NAME]
1533 | 8AM-5:30PM
1533 | 8AM-5:30PM
1533 | 8AM-5:30PM
1533 | 8AM-5:30PM
1533 | 8AM-5:30PM
402 | 7AM-7PM
532 | 7AM-7PM
649 | 7 TO 5:30PM
649 | 7 TO 5:30PM
649 | 7 TO 5:30PM
649 | 7 TO 5:30PM
720 | 7AM-6PM
942 | 7AM-7PM
1033 | AFTER 10AM
2337 | 24HRS
907 | 24HRS
1055 | 24HRS
1158 | 7AM-7PM
1401 | 24 HRS
1431 | 7AM-7PM
1448 | 7AM-7PM
1251 | 8AM-5PM
1324 | 7AM-5PM
1432 | 7AM-6PM
558 | 7AM-7PM
814 | 7AM-7PM
849 | 7AM-7PM
940 | 7AM-7PM
106 | 24HRS
1325 | 7AM-6PM
Spreadsheet: 99700d1298301160-a-list-of-days-by-date-to-the-end-of-the-next-month-then-the-list-turns-to-months-excel-file
Sheet: What I Will See As It Stands

2011-03-21 00:00:00
2011-03-21 00:00:00 | 2011-03-22 00:00:00 | 2011-03-23 00:00:00 | 2011-03-24 00:00:00 | 2011-03-25 00:00:00 | 2011-03-26 00:00:00 | 2011-03-27 00:00:00 | 2011-03-28 00:00:00 | 2011-03-29 00:00:00 | 2011-03-30 00:00:00 | 2011-03-31 00:00:00 | 2011-04-01 00:00:00 | 2011-04-02 00:00:00 | 2011-04-03 00:00:00 | 2011-04-04 00:00:00 | 2011-04-05 00:00:00 | 2011-04-06 00:00:00 | 2011-04-07 00:00:00 | 2011-04-08 00:00:00 | 2011-04-09 00:00:00 | 2011-04-10 00:00:00 | 2011-04-11 00:00:00 | 2011-04-12 00:00:00 | 2011-04-13 00:00:00 | 2011-04-14 00:00:00 | 2011-04-15 00:00:00 | 2011-04-16 00:00:00 | 2011-04-17 00:00:00 | 2011-04-18 00:00:00 | 2011-04-19 00:00:00 | 2011-04-20 00:00:00 | 2011-04-21 00:00:00 | 2011-04-22 00:00:00 | 2011-04-23 00:00:00 | 2011-04-24 00:00:00 | 2011-04-25 00:00:00 | 2011-04-26 00:00:00 | 2011-04-27 00:00:00 | 2011-04-28 00:00:00 | 2011-04-29 00:00:00 | 2011-04-30 00:00:00 | 2011-05-01 00:00:00 | 2011-05-02 00:00:00 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 2011-05-05 00:00:00 | 2011-05-06 00:00:00 | 2011-05-07 00:00:00 | 2011-05-08 00:00:00 | 2011-05-09 00:00:00 | 2011-05-10 00:00:00 | 2011-05-11 00:00:00 | 2011-05-12 00:00:00 | 2011-05-13 00:00:00 | 2011-05-14 00:00:00 | 2011-05-15 00:00:00 | 2011-05-16 00:00:00 | 2011-05-17 00:00:00 | 2011-05-18 00:00:00 | 2011-05-19 00:00:00 | 2011-05-20 00:00:00 | 2011-05-21 00:00:00 | 2011-05-30 00:00:00 | 2011-06-29 00:00:00 | 2011-07-29 00:00:00 | 2011-08-28 00:00:00
Spreadsheet: 136478d1326667141-setting-up-my-books-excel-forum-post
Sheet: 2300

 | 2300
DATE | [NAME] / INVOICE NUMBER | ACCOUNT # | ACCOUNT NAME | DEBIT | CREDIT | Total |  | FOR THIS PAGE, I WANT TO TAKE ANY ENTRIES FROM THE GENERAL JOURNAL THAT REFERENCE THE ACCOUNT NUMBER, BUT I DON'T WANT TO SKIP ROWS, AND I DON'T WANT DUPLICATE ENTRIES OF COURSE.
(THIS ROW CONTAINS MANUALLY ENTERED BEGINNING TOTALS) |  |  |  |  |  | 19.25
JAN 11 | 2007137, DR. BOB | 2300 |  |  | 120.32 |  |  | THE ENTRY SHOULD LOOK LIKE THIS
JAN 13 | 2007138, [NAME] | 2300 |  |  | 36.85 |  |  | ALSO, I DON'T WANT TOTALS TO RUN ALL THE WAY DOWN IF THERE ARE NO ENTRIES YET.
Spreadsheet: 839823d1692255670-using-if-function-or-similar-function-rebar-counting-at-p2
Sheet: Taisei Rebar

BANDARANAYAKE INTERNATIONAL AIRPORT DEVELEOPMENT - Phase II Stage 2 Package A
REBAR COUNTING AT PIER 2 ( BELONGS TO TAISEI) ON 03.08.2023
10 MM (12M) |  | 20MM (12M) |  | 32MM (12M) |  | 40MM (12M) |  | 10M(10M-12M)
1060 |  | 349 |  | 549 |  | 106 |  | 11
Counted Jointly and actual quantity at pier 2 is as shown in above table
 |  | CSCEC |  |  | TAISEI |  |  |  | JAC
Name
Designation
Signature
Date
Spreadsheet: 719032d1613478726-calculate-the-frequency-of-answers-per-column-of-all-columns-sample-for-forum
Sheet: MAIN

F1 | F2 | F2.1
2 | 18 | 2 |  | F1 Value | Frequency
2 | 38 | 4 |  | 1
2 | 26 | 3 |  | 2
1 | 76 | 7
2 | 66 | 7 |  | THE ABOVE IS WHAT I WANT. I DID IT MANUALLY FOR COLUMN A USING A COUNTIF FUNCTION. HOWEVER, I WANT IT DONE FOR ALL COLUMNS (OVER 70 IN THE ORIGINAL FILE)
2 | 33 | 3
1 | 34 | 3
2 | 56 | 6
1 | 48 | 5
2 | 72 | 7
1 | 72 | 7
2 | 59 | 6
1 | 31 | 3
2 | 52 | 6
2 | 66 | 7
1 | 25 | 3
1 | 42 | 4
1 | 74 | 7
1 | 57 | 6
2 | 35 | 4
2 | 56 | 6
2 | 56 | 6
2 | 65 | 7
2 | 43 | 4
2 | 43 | 4
2 | 47 | 5
2 | 33 | 3
2 | 42 | 4
2 | 48 | 5
1 | 55 | 6
2 | 37 | 4
1 | 18 | 2
1 | 61 | 6
2 | 33 | 3
1 | 52 | 5
2 | 25 | 3
1 | 54 | 5
2 | 22 | 2
2 | 60 | 6
2 | 70 | 7
2 | 33 | 3
1 | 73 | 7
1 | 52 | 5
2 | 63 | 6
2 | 81 | 7
2 | 58 | 6
1 | 35 | 4
2 | 29 | 3
2 | 36 | 4
2 | 33 | 3
2 | 64 | 6
1 | 64 | 6
1 | 31 | 2
1 | 28 | 3
1 | 19 | 2
1 | 36 | 4
2 | 84 | 7
1 | 30 | 3
1 | 63 | 6
2 | 78 | 7
1 | 76 | 7
1 | 21 | 2
2 | 21 | 2
1 | 70 | 7
1 | 47 | 5
1 | 79 | 7
2 | 47 | 5
1 | 28 | 3
2 | 23 | 2
2 | 56 | 6
1 | 23 | 2
1 | 48 | 5
2 | 50 | 5
1 | 77 | 7
1 | 43 | 4
2 | 47 | 5
2 | 47 | 5
2 | 37 | 3
2 | 79 | 7
2 | 50 | 5
2 | 36 | 4
2 | 62 | 6
2 | 39 | 4
1 | 44 | 4
2 | 27 | 3
1 | 60 | 6
2 | 52 | 5
2 | 44 | 4
2 | 53 | 5
1 | 69 | 7
1 | 68 | 7
1 | 62 | 6
2 | 42 | 4
2 | 81 | 7
2 | 57 | 6
2 | 64 | 6
2 | 59 | 6
1 | 44 | 4
2 | 58 | 6
2 | 44 | 4
2 | 55 | 6
2 | 59 | 6
2 | 34 | 3
1 | 47 | 5
1 | 34 | 3
2 | 50 | 5
2 | 51 | 5
2 | 81 | 7
1 | 52 | 5
1 | 23 | 2
2 | 56 | 6
2 | 35 | 4
1 | 32 | 3
Spreadsheet: 0da9e9eb-fbf3-46af-ace9-4d2222a9d6a9
Sheet: Sheet1

Bounds For Population Parameters | Unnamed: 1 | Unnamed: 2 | Bounds Based on Sample Parameters | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Pop Mean(% LC) | 100 |  | Confidence Level(%) | 90 | Overall Bound Results *
Pop SD(Sigma)(% LC) | 6 |  | Sample Size(n) | 10 | Tablets |  | Capsules
Bound Results |  |  | Sample Mean(% LC) | 98 | Prob(Tabs) | 0.9923343013848296 | Prob(Caps) | 0.999986103837812
Prob(Tabs) | 0.9341474378384835 |  | Sample RSD(%) | 2.5 | Prob1 | 0.9999815558882625 | Prob1 | 0.9999999815363045
Prob(Caps) | 0.9867053296742418 |  | Upper Pop Mean(% LC) | 100.4739787581414 | Prob2 | 0.9923343013848296 | Prob2 | 0.999986103837812
Part 1 | 0.5556557173768926 |  | Lower Pop Mean(% LC) | 95.52602124185864 |  |  | At Upper Pop Mean
Part 2 | 0.9867053296742418 |  | Upper Sigma(% LC) | 4.014433694745239 |  |  | Part 1/1 | 0.9836015592666691
 |  |  |  |  |  |  | Part 2/1 | 0.9999999815363045
"Key in data" area |  |  |  |  |  |  | At Lower Pop Mean
Result area |  |  |  |  |  |  | Part 1/2 | 0.9674428912906725
 |  |  |  |  |  |  | Part 2/2 | 0.999986103837812
The values below will change according to what you have keyed.
* For Tablets: If n = 10, sample mean = 98% LC, sample RSD = 2.5% and with 90% confidence; there is at least 99.23% of all future samples tested for content uniformity will pass the USP test.
* For Capsules: If n = 10, sample mean = 98% LC, sample RSD = 2.5% and with 90% confidence; there is at least 100% of all future samples tested for content uniformity will pass the USP test.
TEXT FORMULAE
Population Parameters
Prob (Tablets)
Prob (Capsules)
Part1
Part2
Sample Parameters
Prob (Tablets)
Prob1
Prob2
Prob (Capsules)
Prob1
Part1/1
Part2/1
Prob2
Part1/2
Part2/2
Spreadsheet: 783303d1654714812-jump-from-newly-added-value-to-previous-duplication-where-adjacent-column-is-blank-excel-rack-numbers
Sheet: Munka1

Rack number | Arrived | Sent back | Comment
AA12 | 2022-04-05 00:00:00 | 2022-04-06 00:00:00
AB65 | 2022-04-05 00:00:00 | 2022-05-07 00:00:00
120 | 2022-04-05 00:00:00
AA54 | 2022-04-06 00:00:00 | 2022-05-07 00:00:00
AB67 | 2022-04-06 00:00:00 | 2022-05-08 00:00:00 |  |  | On the right this is a sample chart about rack management. Column "A" shows the number of the rack, "B" the date of arrival and "C" the date when it was sent back to the factory.
AC87 | 2022-04-06 00:00:00 | 2022-06-04 00:00:00 |  |  | The racks are used for more than one delivery, they can arrive multiple times. The list expands on a daily basis.
145 | 2022-04-06 00:00:00
167 | 2022-04-06 00:00:00 | 2022-05-06 00:00:00 |  |  | Is there any possible solution to indicate if a newly entered rack number already exists in the column AND hasn't sent back?
AC74 | 2022-04-07 00:00:00 | 2022-05-03 00:00:00
AA68 | 2022-04-07 00:00:00 | 2022-05-07 00:00:00 |  |  | E.g if the number "120" is entered as in A19, could a formula indicate that has arrived before (A4) and has not been sent back (blank C4)?
234 | 2022-04-08 00:00:00 |  |  |  | Either an indication with color in cell [NAME] (or in the row of the new data) or could the cell selection jump to the previous existing value (cell A4) ? This latter would be better.
AA45 | 2022-04-08 00:00:00 |  |  |  | Other solutiuon can work out as well. Thank you very much for your time, I appreciate :)
AD22 | 2022-04-08 00:00:00 |  |  |  | Example for what I need:
AC24 | 2022-04-08 00:00:00 |  |  |  | Rack number | Arrived | Sent back | Comment
346 | 2022-04-08 00:00:00 |  |  |  | AA12 | 2022-04-05 00:00:00 | 2022-04-06 00:00:00
AB37 | 2022-04-08 00:00:00 |  |  |  | AB65 | 2022-04-05 00:00:00 | 2022-05-07 00:00:00
AA12 | 2022-04-08 00:00:00 |  |  |  | 120 | 2022-04-05 00:00:00
120 |  |  |  |  | AA54 | 2022-04-06 00:00:00 | 2022-05-07 00:00:00
 |  |  |  |  | AB67 | 2022-04-06 00:00:00 | 2022-05-08 00:00:00
 |  |  |  |  | AC87 | 2022-04-06 00:00:00 | 2022-06-04 00:00:00
 |  |  |  |  | 145 | 2022-04-06 00:00:00
 |  |  |  |  | 167 | 2022-04-06 00:00:00 | 2022-05-06 00:00:00
 |  |  |  |  | AC74 | 2022-04-07 00:00:00 | 2022-05-03 00:00:00
 |  |  |  |  | AA68 | 2022-04-07 00:00:00 | 2022-05-07 00:00:00
 |  |  |  |  | 234 | 2022-04-08 00:00:00
 |  |  |  |  | AA45 | 2022-04-08 00:00:00
 |  |  |  |  | AD22 | 2022-04-08 00:00:00
 |  |  |  |  | AC24 | 2022-04-08 00:00:00
 |  |  |  |  | 346 | 2022-04-08 00:00:00
 |  |  |  |  | AB37 | 2022-04-08 00:00:00
 |  |  |  |  | AA12 | 2022-04-08 00:00:00
 |  |  |  |  | 120
Spreadsheet: a6a6dbe8-0e83-4a4d-876d-87037694536e
Sheet: QTD Recon Q3FY10

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended December 31, 2009
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 1243 |  | 0 |  | 103 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1346
Cost of goods sold | 654 |  | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 652
Gross profit | 589 |  | 2 |  | 103 |  | 0 |  | 0 |  | 0 |  | 0 |  | 694
Operating expenses:
Marketing and sales | 208 |  | 0 |  | 0 |  | 0 |  | 0 |  | -4 |  | 0 |  | 204
General and administrative | 84 |  | 0 |  | 0 |  | 0 |  | 0 |  | -9 |  | 0 |  | 75
Research and development | 290 |  | 0 |  | 0 |  | 0 |  | 0 |  | -29 |  | 0 |  | 261
Amortization of intangibles | 14 |  | -14 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 100 |  | 0 |  | 0 |  | 0 |  | -100 |  | 0 |  | 0 |  | 0
Total operating expenses | 696 |  | -14 |  | 0 |  | 0 |  | -100 |  | -42 |  | 0 |  | 540
Operating income (loss) | -107 |  | 16 |  | 103 |  | 0 |  | 100 |  | 42 |  | 0 |  | 154
Loss on strategic investments | -1 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income (expense), net | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -2
Income (loss) before provision for (benefit from) income taxes | -110 |  | 16 |  | 103 |  | 1 |  | 100 |  | 42 |  | 0 |  | 152
Provision for (benefit from) income taxes | -28 |  |  |  |  |  |  |  |  |  |  |  | 71 |  | 43
Net income (loss) | -82 |  | 16 |  | 103 |  | 1 |  | 100 |  | 42 |  | -71 |  | 109
Loss per share |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and diluted | -0.25 |  |  |  |  |  |  |  |  |  | Basic | 0.09 |  |  | 0.34
 |  |  |  |  |  |  |  |  |  |  | Diluted | 0.09 |  |  | 0.33
Number of shares used in computation
Basic and diluted | 325 |  |  |  |  |  |  |  |  |  | Number of shares used in computation
 |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 325
 |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 327
Spreadsheet: 109115d1306040553-excel-2007-salary-scheme-book5
Sheet: Sheet1

Start | End | Break | hours worked |  |  |  | tax table
08:00:00 | 16:00:00 | 00:30:00 |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 10000 | 1300
 |  |  |  |  |  |  | 11000 | 1500
before tax | tax to pay |  |  |  |  |  | 12000 | 1650
11567
Spreadsheet: 766486d1643904371-formula-to-automatically-generate-sequence-of-numbers-stock-short-term-comparison-17
Sheet: Sheet1

t3(poss alm a4?/a6?/a8?)
t4(poss alm a4?/a7?/a9?)
t5(poss alm a5?/a8?/a10?)
t6(poss alm a7?/a9?/a11?)
t7(poss alm a10?/a11?/a12?)
t8(poss alm a11?/a12?/a13?)
second example
t3(poss alm at4?/a6?/s8?)
 |  |  | t4(poss alm at5?/a7?/s9?)
 |  |  | t5(poss alm at6?/a8?/s10?)
 |  |  | t6(poss alm at7?/a9?/s11?)
 |  |  | t7(poss alm at8?/a10?/s12?)
 |  |  | [NAME]?)
Spreadsheet: 96331d1295729624-conditional-formatting-football-predictions_daddy
Sheet: Bonus Points - Goal Scorers

 | [NAME]'s Predictions |  | Stuart's Predictions |  | [NAME]'s Predictions |  | [NAME]'s Predictions |  | [NAME]'s Predictions |  | [NAME]'s Predictions
Week 1 | Malouda | Nani | Lampard | Berbatov | Nani | Anelka | Drogba | Hernandez
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Week 12
Week 13
Week 14
Week 15
Week 16
Week 17
Week 18
Week 19
Week 20
Week 21
Week 22
Week 23
Week 24
Week 25
Week 26
Week 27
Week 28
Week 29
Week 30
Spreadsheet: 494571d1482476972-mafia-game-vote-tally-vote-change-disregard-duplicate-values-and-summary-count-mafia
Sheet: ID

 | ID | Voter
 | 1 | Player 1
 | 2 | Player 2
 | 3 | Player 3
 | 4 | Player 4
 | 5 | Player 5
 | 6 | Player 6
 | 7 | Player 7
 | 8 | Player 8
 | 9 | Player 9
 | 10 | Player 10
 | 11 | Player 11
 | 12 | Player 12
 | 13 | Player 13
 | 14 | Player 14
 | 15 | Player 15
 | 16 | Player 16
 | 17 | Player 17
 | 18 | Player 18
 | 19 | Player 19
 | 20 | Player 20
 | 21 | Player 21
 | 22 | Player 22
 | 23 | Player 23
 | 24 | Player 24
 | 25 | Player 25
 | 26 | Player 26
 | 27 | Player 27
 | 28 | Player 28
 | 29 | Player 29
 | 30 | Player 30
 | 31 | Player 31
 | 32 | Player 32
 | 33 | Player 33
 | 34 | Player 34
 | 35 | Player 35
 | 36 | Player 36
 | 37 | Player 37
 | 38 | Player 38
 | 39 | Player 39
 | 40 | Player 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
Spreadsheet: 78756d1279073851-lookup-or-match-index-archery-example-2
Sheet: Sheet1

 |  |  | Rounds
Bow | Category |  | York | [NAME] | Bristol | There are a further 56 rounds
Recurve | ladies | GMB | 1080 | 1165
 |  | MB | 977 | 1091
 |  | [NAME] | 786 | 952
 |  | 1st Class | 511 | 723 | 911
 |  | 2nd Class | 308 | 508 | 725 |  | Bow | Category | Round | Score | Classification
 |  | 3rd Class | 142 | 280 | 473
 |  | Unclassified |  |  |  |  | Recurve | gent | [NAME] | 750 | 2nd class
Recurve | gents | GMB | 1146
 |  | MB | 1065
 |  | [NAME] | 913
 |  | 1st Class | 698 | 884
 |  | 2nd Class | 511 | 723 | 911
 |  | 3rd Class | 283 | 477 | 695
 |  | Unclassified
Recurve | U18 | JMB | 1015 | 1118
 |  | JBowman | 839 | 992
 |  | 1st Class | 511 | 723 | 911
 |  | 2nd Class | 283 | 477 | 695
 |  | 3rd Class | 89 | 192 | 353
 |  | Unclassified
 | There are a further 37 categories below this where bow and category vary
Archery classifications explained.
Every time you shoot one of the 59 rounds (which vary in the numbers of arrows, distance, and target size) in addition to a handicap score you earn a classification. They Range from Grand Master Bowman (GMB) to unclassified. You need to achieve or exceed a particular score to get the respective classification.  Some rounds are less demanding and the higher classification cannot be earned by shooting them.  There are 40 Categories of archer depending on age, gender and bow type with varying ‘thresholds’ for the awards.
In the table for example looking at the recurve gents ‘Hereford Round’ |  |  |  |  |  |  | Score | Clasification
 |  |  |  |  |  |  | 900 | 1st class
 |  |  |  |  |  |  | 883 | 2nd class
 |  |  |  |  |  |  | 476 | Unclassified
Spreadsheet: 477456d1472296049-finding-same-value-in-next-sheet-sample
Sheet: Main Sheet

 |  | No | amnt
 |  | S-01 | 400
 |  | S-02 | 400
 |  | S-03 | 400
 |  | S-04 | 400
 |  | S-05 | 400
 |  | S-06 | 400
 |  | S-07 | 400
 |  | S-08 | 400
 |  | S-09 | 400
 |  | S-10 | 400
 |  | S-11 | 400
 |  | S-12 | 400
 |  | S-13 | 400
 |  | S-14 | 400
 |  | S-15 | 400
 |  | S-16 | 400
 |  | S-17 | 400
 |  | S-18 | 400
 |  | S-19 | 400
 |  | S-20 | 400
 |  | S-21 | 400
 |  | S-22 | 400
 |  | S-23 | 400
 |  | S-24 | 400
 |  | S-25 | 400
 |  | S-26 | 400
 |  | S-27 | 400
 |  | S-28 | 400
 |  | S-29 | 400
 |  | S-30 | 400
Spreadsheet: 890168d1741374324-fetching-multiple-data-from-another-sheet-product-tree
Sheet: Product List

[NAME] | [NAME] | Cycle | Kavite | İş Merkezi | Rev. [NAME]
SLV101 | 500GR TUZLUK ŞİŞE, BİLLUR TUZ SLEEVE FIN | 0 | 0 |  | 29.03.2021
10010025 | 40/415 BİBERON SULUK KAPAK, BEYAZ | 23.6 | 4 |  | 29.03.2021
10010041 | 52 mm TUZLUK  KAPAK | 14.78 | 8 | ENJEKSİYON | 23.03.2022
100100411 | Ø52 TUZLUK  KAPAK, KIRMIZI | 0 | 16 | ENJEKSİYON | 29.03.2021
100100412 | Ø52 TUZLUK  KAPAK, OLYMPIA KIRMIZI | 15.8 | 8 | ENJEKSİYON | 31.05.2022
100100413 | Ø52 TUZLUK  KAPAK, SARAY MAVİ | 0 | 0 |  | 29.03.2021
10010042 | TUZ KAPAK MONTAJ KIRMIZI BEYAZ | 1.5 | 1 | MONTAJ | 29.09.2022
100100421 | TUZ KAPAK MONTAJ, KIRMIZI-BEYAZ | 0 | 0 | MONTAJ | 29.09.2022
100100422 | TUZ KAPAK MONTAJ, MAVİ-BEYAZ | 1.5 | 8 | ENJEKSİYON | 30.12.2022
Spreadsheet: 710445d1608985969-prime-and-composite-numbers-inventory
Sheet: Sheet1

A | B | C | D | E | F | Prime/Composite
2 | 3 | 4 | 5 | 6 | 7
10 | 24 | 31 | 59 | 81 | 99
10 | 11 | 19 | 35 | 41 | 88
Spreadsheet: 9f025f1e-beae-460a-868b-ceca908f6abc
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7679 | 57311 | Stella | Heyns | RSA | 0 | 00:23:41 | 00:00:00 | 01:58:13 | 00:00:00 | 00:44:32 | 1 | 03:06:28