tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: JPN

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 53 | 00:01:36.568000 | 2 |  | 1 |  | 00:01:30.475000
2 | [NAME] |  |  | 18 | 53 | 00:01:36.682000 | 5 |  | 2 |  | 00:01:30.886000
3 | [NAME] |  |  | 15 | 53 | 00:01:36.916000 | 1 |  | 3 |  | 00:01:30.466000
4 | [NAME] |  |  | 12 | 53 | 00:01:36.828000 | 6 |  | 4 |  | 00:01:31.156000
5 | [NAME] |  |  | 10 | 53 | 00:01:37.645000 | 3 |  | 5 |  | 00:01:30.617000
6 | [NAME] |  |  | 8 | 53 | 00:01:37.916000 | 8 |  | 6 |  | 00:01:32.116000
7 | [NAME] |  |  | 6 | 53 | 00:01:37.800000 | 4 |  | 7 |  | 00:01:30.804000
8 | [NAME] |  |  | 4 | 53 | 00:01:36.569000 | 17 |  | 8 |  | 00:01:34.704000
9 | [NAME] |  |  | 2 | 53 | 00:01:37.053000 | 10 |  | 9 |  | 00:01:32.245000
10 | [NAME] |  |  | 1 | 53 | 00:01:36.614000 | 23 |  | 10
11 | [NAME] |  |  | 0 | 53 | 00:01:38.133000 | 11 |  | 11 |  | 00:01:32.463000
12 | [NAME] |  |  | 0 | 53 | 00:01:37.970000 | 12 |  | 12 |  | 00:01:32.746000
13 | [NAME] |  |  | 0 | 53 | 00:01:39.724000 | 7 |  | 13 |  | 00:01:32.380000
14 | Pastor Maldonado |  |  | 0 | 53 | 00:01:37.645000 | 14 |  | 14 |  | 00:01:33.224000
15 | [NAME] |  |  | 0 | 53 | 00:01:37.411000 | 16 |  | 15 |  | 00:01:33.427000
16 | [NAME] |  |  | 0 | 53 | 00:01:38.407000 | 9 |  | 16 |  | 00:01:32.297000
17 | [NAME] |  |  | 0 | 53 | 00:01:39.080000 | 13 |  | 17 |  | 00:01:33.079000
18 | [NAME] |  |  | 0 | 53 | 00:01:39.297000 | 18 |  | 18 |  | 00:01:35.454000
19 | Jarno [NAME] |  |  | 0 | 53 | 00:01:39.561000 | 19 |  | 19 |  | 00:01:35.514000
20 | [NAME] |  |  | 0 | 51 | 00:01:41.704000 | 21 |  | 20 |  | 00:01:36.507000
21 | [NAME] |  |  | 0 | 51 | 00:01:41.794000 | 20 |  | 21 |  | 00:01:36.439000
22 | [NAME] |  |  | 0 | 51 | 00:01:41.437000 | 22 |  | 22 |  | 00:01:37.846000
23 | [NAME] |  |  | 0 | 50 | 00:01:42.409000 | 24 |  | 23
24 | Sebastien Buemi |  |  | - | 11 | 00:01:42.107000 | 15 |  | RET |  | 00:01:33.227000
Spreadsheet: 875386d1721962676-simplify-formula-simplify
Sheet: Sheet1

Number | Count | of | Count of | Compare 9 | Compare 8 | Compare 7 | Compare 6 | Compare 5 | Compare 4 | Compare 3 | Compare 2 | Compare 1
9 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 , A6 = A7 , A7 = A8 , A8 = A9 , A9 = A10 , A10 = A11 ) , B11 , IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 , A6 = A7 , A7 = A8 , A8 = A9 , A9 = A10 ) , B10 , IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 , A6 = A7 , A7 = A8 , A8 = A9 ) , B9 , IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 , A6 = A7 , A7 = A8 ) , [NAME] , IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 , A6 = A7 ) , [NAME] , IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 ) , [NAME] , IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 ) , [NAME] , IF ( AND ( A2 = A3 , A3 = A4 ) , B4 , IF ( A2 = A3 , B3 , B2 ) ) ) ) ) ) ) )
9
9
9
9
9
9
9
9
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 , A6 = A7 , A7 = A8 , A8 = A9 , A9 = A10 , A10 = A11 ) , B11 , "NEXT" )
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 , A6 = A7 , A7 = A8 , A8 = A9 , A9 = A10 ) , B10 , "NEXT" )
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 , A6 = A7 , A7 = A8 , A8 = A9 ) , B9 , "NEXT" )
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 , A6 = A7 , A7 = A8 ) , [NAME] , "NEXT" )
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 , A6 = A7 ) , [NAME] , "NEXT" )
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 , A5 = A6 ) , [NAME] , "NEXT" )
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ( AND ( A2 = A3 , A3 = A4 , A4 = A5 ) , [NAME] , "NEXT" )
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ( AND ( A2 = A3 , A3 = A4 ) , B4 , "NEXT" )
7 |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ( AND ( A2 = A3 ) , B3 , B2 )
7
7
7
7
7
7
6
6
6
6
6
6
5
5
5
5
5
4
4
4
4
3
3
3
2
2
1
17
10
14
11
14
Spreadsheet: 273154d1382625596-range-of-cells-defined-by-other-cells-for-maximum-minimum-average-and-standard-deviation-array-functions-for-taniwha
Sheet: Sheet1

Distance Start | Distance End | Height |  | Section Start | SectionEnd | [NAME] | Min | [NAME] | Avg
0 | 0.001 | 40.1 |  | 0 | 0.02
0.001 | 0.002 | 28.5 |  | 0.02 | 0.04
0.002 | 0.003 | 21.2 |  | 0.04 | 0.06
0.003 | 0.004 | 12.2
0.004 | 0.005 | 9.2
0.005 | 0.006 | 10 |  |  |  |  |  | I would like to find the minimum, maximum, average and standard deviation for a range of cells, however the range of cells in the formula would be defined by other cells. If you look at the attached spreadsheet, I would like to find the maximum height that lies between each Section Start and Section End. I would like to formula to look at the cell E2 (0.000) and cell F2 (0.020) . The formula would then look at all the  Heights (column C) which lie between the corresponding Distance Start and Distance End, ie: in this case the formula would find the maximum value for C2:C21, because these heights lie between the Section Start and Section End defined in E2 and F2. I would like to do the same thing with minimum, average and standard deviation.
0.006 | 0.007 | 11.1
0.007 | 0.008 | 9.6
0.008 | 0.009 | 4.6
0.009 | 0.01 | 1.8
0.01 | 0.011 | 2.2
0.011 | 0.012 | 3.1
0.012 | 0.013 | 2.7
0.013 | 0.014 | 3.2
0.014 | 0.015 | 2.6
0.015 | 0.016 | 2.4
0.016 | 0.017 | 3.1
0.017 | 0.018 | 30.6
0.018 | 0.019 | 40
0.019 | 0.02 | 37.8
0.02 | 0.021 | 17.2
0.021 | 0.022 | 3.2
0.022 | 0.023 | 4.5
0.023 | 0.024 | 3.5
0.024 | 0.025 | 2.7
0.025 | 0.026 | 1.7
0.026 | 0.027 | 2.7
0.027 | 0.028 | 2.3
0.028 | 0.029 | 2
0.029 | 0.03 | 1.4
0.03 | 0.031 | 1.3
0.031 | 0.032 | 2
0.032 | 0.033 | 3.3
0.033 | 0.034 | 1.8
0.034 | 0.035 | 2
0.035 | 0.036 | 2.5
0.036 | 0.037 | 3
0.037 | 0.038 | 3.2
0.038 | 0.039 | 2.2
0.039 | 0.04 | 1.2
0.04 | 0.041 | 1.5
0.041 | 0.042 | 1.3
0.042 | 0.043 | 1.4
0.043 | 0.044 | 2.4
0.044 | 0.045 | 2.1
0.045 | 0.046 | 2.9
0.046 | 0.047 | 2.5
0.047 | 0.048 | 1.3
0.048 | 0.049 | 1.5
0.049 | 0.05 | 1.7
0.051 | 0.051 | 2.2
0.052 | 0.052 | 2.1
0.053 | 0.053 | 1.6
0.054 | 0.054 | 1.7
0.055 | 0.056 | 2
0.056 | 0.057 | 2.1
0.057 | 0.058 | 1.6
0.058 | 0.059 | 1.8
0.059 | 0.06 | 1.6
0.06 | 0.061 | 2.3
Spreadsheet: 682325d1592007842-go-to-next-row-until-it-finds-string-no-blank-rows-apples_count
Sheet: Sheet1

Table 1
 |  |  | Count | Rotten
2019-08-17 00:00:00 | Bananas | Apples | 10 | 5
2019-08-24 00:00:00 | Apples | Oranges | 13 | 6
2019-08-25 00:00:00 | Apples | Onions | 3 | 0
2019-09-01 00:00:00 | Watermelon | Apples | 5 | 1
2019-09-14 00:00:00 | Apples | Grapefruits | 8 | 0
2019-09-21 00:00:00 | [NAME] | Apples | 17 | 8
2019-09-28 00:00:00 | Apples | [NAME] | 3 | 0
Table 2
 |  |  | Count | Rotten
2019-08-24 00:00:00 | Apples | Oranges | 13 | 6
2019-08-25 00:00:00 | Apples | Onions | 3 | 0
2019-09-14 00:00:00 | Apples | Grapefruits | 8 | 0
2019-09-28 00:00:00 | Apples | [NAME] | 3 | 0
Table 3
 |  |  | Count | Rotten
2019-08-24 00:00:00 | Apples | Oranges | 13 | 6
2019-08-25 00:00:00 | Apples | Onions | 3 | 0
2019-09-14 00:00:00 | Apples | Grapefruit | 8 | 0
2019-09-28 00:00:00 | Apples | [NAME] | 3 | 0
Spreadsheet: 66335d1267015998-excel-2007-if-and-statement-test1
Sheet: Sheet1

02 | 1 | 106800 | 2320600 | CS
02 | 1 | 106800 | 2320600 | WHL
02 | 1 | 106800 | 2295400 | WHL
02 | 1 | 106800 | 2201800 | CS
02 | 1 | 106800 | 2006200 | WHL
02 | 1 | 106800 | 2191600 | PC
02 | 1 | 106800 | 2011000 | WHL
02 | 1 | 106800 | 2246200 | PC
02 | 1 | 106800 | 2387800 | WHL
02 | 1 | 106800 | 2398000 | PC
02 | 1 | 106800 | 2141800 | WHL
02 | 1 | 106800 | 2265400 | WHL
02 | 1 | 106800 | 2219800 | WHL
02 | 1 | 106800 | 2291800 | CS
02 | 1 | 106800 | 2131000 | WHL
02 | 1 | 106800 | 2189800 | WHL
02 | 1 | 106800 | 2306200 | PC
02 | 1 | 106800 | 2329000 | WHL
02 | 1 | 106800 | 2049400 | WHL
02 | 1 | 106800 | 2192200 | CS
02 | 1 | 106800 | 3811000 | PC
02 | 1 | 106800 | 3913000 | CS
02 | 1 | 106800 | 4120000 | CS
02 | 1 | 106800 | 4892000 | CS
02 | 1 | 106800 | 4893500 | CS
02 | 1 | 106800 | 4900000 | CS
02 | 1 | 109800 | 1068000 | CS
02 | 1 | 109800 | 1068000 | PC
02 | 1 | 109800 | 1377000 | CS
02 | 1 | 109800 | 1382050 | PC
02 | 1 | 109800 | 1380000 | PC
Spreadsheet: 91428d1291153957-usage-of-vlookup-with-closest-match-usage-of-vlookup
Sheet: Sheet1

 |  |  | case 1 | problem |  |  |  | case 2 | ok
 |  |  | 40529 | up |  |  |  | 1 | up
 |  |  | 162140 | down |  |  |  | 2 | down
 |  |  | 324192 | left |  |  |  | 3 | left
 |  |  | 283605 | right |  |  |  | 4 | right
 |  |  | down |  |  |  |  | right
Spreadsheet: 740339d1626283158-first-contact-resolution-calculation-fcr-calc-call-data-example-1-2-
Sheet: Sheet1

 | Call Back Window: |  |  | 3 | Days
 | Call Date | Agent ID | Name | ANI | Resolved |  |  |  |  | 0 = Calls back
 | 2021-07-01 00:00:00 | 123456 | Scott | 1111 | 0 |  |  |  |  | 1 = No call back |  |  | FCR Score By Agent
 | 2021-07-01 00:00:00 | 123456 | Scott | 2222 | 1 |  |  |  |  |  |  |  | Agent Name | Calls | Resolved Calls | % Repeat Call Rate
 | 2021-07-02 00:00:00 | 123457 | [NAME] | 3333 | 1 |  |  |  |  |  |  |  | Scott
 | 2021-07-02 00:00:00 | 123457 | [NAME] | 1111 | 1 |  |  |  |  |  |  |  | [NAME]
 | 2021-07-03 00:00:00 | 123458 | Jennie | 5555 | 0 |  |  |  |  |  |  |  | Jennie
 | 2021-07-03 00:00:00 | 123460 | [NAME] | 5555 | 1 |  |  |  |  |  |  |  | [NAME]
 | 2021-07-04 00:00:00 | 123456 | Scott | 6666 | 1 |  |  |  |  |  |  |  | [NAME]
 | 2021-07-04 00:00:00 | 123459 | [NAME] | 7777 | 0
 | 2021-07-05 00:00:00 | 123459 | [NAME] | 1111 | 1
 | 2021-07-06 00:00:00 | 123457 | [NAME] | 7777 | 1
 | 2021-07-07 00:00:00 | 123458 | Jennie | 8888 | 1
 | 2021-07-08 00:00:00 | 123459 | [NAME] | 2222 | 1
 | 2021-07-09 00:00:00 | 123458 | Jennie | 1111 | 1
Spreadsheet: 453564d1459359992-cant-copy-formula-down-16-03-08-formulaire-des-prix
Sheet: Orphée

 | Maison Orphée
 | Produit | Status | Code | Prix | Qté | /Kg | Marque | Provenance | Note
 | Huile de noisettes [NAME] |  | 16012025 | 64.02 |  |  | Maison Orphée | France
 | Huile de noix de coco [NAME] |  | 22010150 | 117.2 | 15 |  | Soleil d'Or
 | Huile de noix de coco vierge pots 908ml |  | 15012052 | 87.69 |  |  | [NAME] format 850g
 | Huile de noix de coco vierge Vrac |  | 12010116 | 218.38 | 15 |  | Maison Orphée
 | Huile de sésame grillée 500ml |  | 16012026 | 55.8 |  |  | [NAME]: Maison Orphée 250ml | Mexique et Canada
 | Huile d'olive extra vierge 1L |  | 22012080 | 77.1 |  |  | Soleil d'or 1L | Tunisie
 | Huile d'olive extra vierge 3L |  | 22010258 | 33.71 |  |  | Soleil d'or 3L | Tunisie
 | [NAME] à l'ancienne |  | 13070118 | 47.1 | 15 |  | Maison Orphée | Canada
 | [NAME] dijon |  | 13070116 | 47.1 | 15 |  | Maison Orphée | Canada
 | [NAME] |  | 13070025 | 169.68 | 16 |  | Maison Orphée | Italie
 | [NAME] cidre 5% |  | 13070006 | 30.12 | 8 |  | Maison Orphée | Canada
Spreadsheet: 340000d3-5928-44d2-b29c-6143814098e3
Sheet: 50+

 |  | LA RUTA DE LOS CONQUISTADORES - 20th EDITION
 |  | GENERAL RESULTS
 |  | November 1-3, 2012
POS | ID | Name | Country | Cat | Stage 1 | Stage 2 | Stage 3 | General
1 | 82 | DURAN Carlos | CRC | 50+ | 06:35:44 | 05:36:10 | 02:15:09 | 14:27:03
2 | 154 | [NAME] | CRC | 50+ | 08:01:49 | 05:22:39 | 02:20:06 | 15:44:34
3 | 150 | [NAME] | CRC | 50+ | 08:22:17 | 05:48:15 | 02:13:59 | 16:24:31
4 | 452 | PASOS Mauricio | CRC | 50+ | 07:49:31 | 06:25:35 | 02:20:27 | 16:35:33
5 | 146 | [NAME] | CRC | 50+ | 08:01:17 | 06:08:57 | 02:31:49 | 16:42:03
6 | 240 | [NAME] | CAN | 50+ | 08:32:34 | 06:11:12 | 02:28:07 | 17:11:53
7 | 266 | [NAME] | ITA | 50+ | 09:49:06 | 05:50:12 | 02:17:35 | 17:56:54
8 | 127 | SANCHEZ Francisco | CRC | 50+ | 09:03:03 | 06:52:23 | 02:31:53 | 18:27:19
9 | 20 | SILVA [NAME] | PER | 50+ | 10:09:13 | 07:14:38 | 02:38:47 | 20:02:38
10 | 48 | FERNANDEZ Roberto | CRC | 50+ | 10:55:11 | 06:46:08 | 02:31:10 | 20:12:30
11 | 78 | BAEZ Rito | CRC | 50+ | 10:04:40 | 07:05:17 | 03:04:23 | 20:14:20
12 | 65 | [NAME] | CRC | 50+ | 09:37:25 | 07:56:14 | 03:18:27 | 20:52:05
13 | 88 | ZUÑIGA [NAME] | CRC | 50+ | 10:02:49 | 09:23:35 | 03:19:54 | 22:46:18
14 | 149 | MENA Gonzalo Antonio | CRC | 50+ | 10:27:21 | 10:06:15 | 03:25:00 | 23:58:35
15 | 198 | LEENHOUTS [NAME] | USA | 50+ | 11:26:43 | 09:09:36 | 03:36:43 | 1 day, 0:13:02
16 | 24 | [NAME] | USA | 50+ | DNF | DNS | DNS
17 | 93 | CESPEDES Francisco Adrian | CRC | 50+ | DNF | 09:30:31 | 03:06:15
18 | 135 | ALFARO William | CRC | 50+ | DNF | DNS | DNS
19 | 168 | GARCIA simplicio | mex | 50+ | DNF | DNF | 03:33:48
20 | 366 | [NAME] | USA | 50+ | DNF | 06:32:03 | 03:25:31
Spreadsheet: 687439d1595214000-populate-a-spread-sheet-based-on-data-that-is-structured-differently-example-workbook-updated
Sheet: Data Collection 

Rejections
Assessment Date | Assessed By | Product: | Type/Variety | Class: | Packed On: | Receival Temp: | Qty Received | Quantity Rejected | Unit Of Measurement | Defect | Major Defect | Minor Defect | No Of Products With Defect Major | No Of Products With Defect Minor | Total Units Assessed | Total % Out Of Spec Major | Total Units Out of spec Minor | No. Ctns Used For Assessment | Qty Rejected | Supplier | Response
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BEEGEE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rose
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Verra
Spreadsheet: 821922d1678989681-solved-help-with-dropdowns-and-fetching-info-via-indirect-new-pricing-matrix-v10-for-help
Sheet: Pricing Info

Headshots |  |  | OLD/NEW COMPARISON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEW PACKAGES |  |  |  |  |  |  |  |  |  |  |  | OLD PACKAGES
 | Price
 | Including Tax
 | - Returning Client Discount
 | (with tax)
 |  |  | [NAME] (2023) |  | [NAME] (2023) |  | The Portfolio Package (2022) |  | The [NAME] (2023) |  | The Silver Collection (2022) |  | The Silver Collections (2023) |  | The Gold Collection (2022) |  | The Gold Collection (2023) |  | The Platinum Collection (2022) |  | The Platinum Collection (2023) |  |  |  | The Wrapped (2023) |  | The [NAME] (2023) |  | The Silver Collections (2023) |  | The Gold Collection (2023) |  | The Platinum Collection (2023) |  |  |  | The Basic Wrapped (2022) |  | The Basic Bronze (2022) |  | The Silver Collection (2022) |  | The Gold Collection (2022) |  | The Platinum Collection (2022) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection) |  | The Platinum Collection (was The Platinum Collection)
Basic Details | Subjects
 | Setups:
 | Limitations:
 | Upgrades & Extras
 | Use of/other additions
Time & Location
 | Time
 | Location
 | Travel Fees Applicable
Print Products & Files | Files:
 | Choice of:
 | Prints
 | Canvas:
 | Collage:
 | Album:
 | Other:
Spreadsheet: 143612d1330484156-excel-2007-adding-a-secondary-y-axis-graph-sample
Sheet: COM 400

COM 400 Assessment Questions
 | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
Strongly Agree | 20 |  | 19 |  | 15 |  | 17 |  | 17 |  | 15
Agree | 1 |  | 2 |  | 4 |  | 2 |  | 4 |  | 4
Neutral | 0 |  | 0 |  | 1 |  | 2 |  | 0 |  | 2
Disagree | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0
Strongly Disagree | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 555153d1515461217-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018-2-
Sheet: Tournament 3

 |  |  | Tournament 3
 |  |  |  |  |  |  | Player
 |  |  |  |  |  |  | Low Score
 |  |  | Player | Score
 |  | x | x | x
Spreadsheet: 193813d1352961296-value-error-stud-list-for-2009
Sheet: Sheet4

 |  | #N/A
#N/A | #N/A | #N/A | #N/A
1 | #N/A | #N/A | 66180
2 | #N/A | #N/A | 56000
3 | #N/A | #N/A | 85000
4 | #N/A | #N/A | 56000
5 | #N/A | #N/A | 56000
6 | #N/A | #N/A | 56000
7 | #N/A | #N/A | 85000
8 | #N/A | #N/A | 66180
9 | #N/A | #N/A | 56000
10 | #N/A | #N/A | 56000
11 | #N/A | #N/A | 56000
12 | #N/A | #N/A | 56000
13 | #N/A | #N/A | 85000
14 | #N/A | #N/A | 66180
15 | #N/A | #N/A | 66180
16 | #N/A | #N/A | 56000
17 | #N/A | #N/A | 66180
18 | #N/A | #N/A | 66180
19 | #N/A | #N/A | 85000
20 | #N/A | #N/A | 56000
21 | #N/A | #N/A | 85000
22 | #N/A | #N/A | 56000
23 | #N/A | #N/A | 85000
24 | #N/A | #N/A | 85000
25 | #N/A | #N/A | 56000
26 | #N/A | #N/A | 56000
27 | #N/A | #N/A | 66180
28 | #N/A | #N/A | 56000
29 | #N/A | #N/A | 56000
30 | #N/A | #N/A | 56000
31 | #N/A | #N/A | 66180
32 | #N/A | #N/A | 122180
33 | #N/A | #N/A | 56000
34 | #N/A | #N/A | 122180
35 | #N/A | #N/A | 56000
36 | #N/A | #N/A | 85000
37 | #N/A | #N/A | 56000
38 | #N/A | #N/A | 85000
39 | #N/A | #N/A | 193025
40 | #N/A | #N/A | 56000
41 | #N/A | #N/A | 56000
42 | #N/A | #N/A | 56000
43 | #N/A | #N/A | 56000
44 | #N/A | #N/A | 56000
45 | #N/A | #N/A | 56000
46 | #N/A | #N/A | 85000
47 | #N/A | #N/A | 25000
48 | #N/A | #N/A | 85000
49 | #N/A | #N/A | 56000
50 | #N/A | #N/A | 10000
51 | #N/A | #N/A | 85000
52 | #N/A | #N/A | 85000
53 | #N/A | #N/A | 141000
54 | #N/A | #N/A | 66180
55 | #N/A | #N/A | 56000
56 | #N/A | #N/A | 56000
57 | #N/A | #N/A | 56000
58 | #N/A | #N/A | 56000
59 | #N/A | #N/A | 112000
60 | #N/A | #N/A | 85000
61 | #N/A | #N/A | 56000
62 | #N/A | #N/A | 56000
63 | #N/A | #N/A | 66180
64 | #N/A | #N/A | 70000
65 | #N/A | #N/A | 56000
66 | #N/A | #N/A | 85000
67 | #N/A | #N/A | 56000
68 | #N/A | #N/A | 85000
 |  | #N/A | 4721185
 |  | #N/A | 486282
 |  | #N/A | 4234902
Spreadsheet: 488954d1478913126-function-help-categorizing-copy-of-budgets
Sheet: Budget Tracking

 | Date: | Category: | Item: | Budget | Expenditure | Buget Item Bal | Budget Balance
 | 2017-01-01 00:00:00 | A3 |  | 100 |  |  |  |  |  | MONTHLY | BUDGET
 | 2017-01-01 00:00:00 | A4 |  | 50 |  |  |  |  |  | A3 | Transportation/Gas
 | 2017-01-01 00:00:00 | A5 |  | 50 |  |  |  |  |  | A4 | Clothing
 | 2017-01-01 00:00:00 | A6 |  | 125 |  |  |  |  |  | A5 | Entertainment
 | 2017-01-01 00:00:00 | A7 |  | 200 |  |  |  |  |  | A6 | Groceries
 | 2017-01-01 00:00:00 | A8 |  | 45 |  |  |  |  |  | A7 | Restaurant/Bars
 | 2017-01-02 00:00:00 | A6 |  |  | 23.55 |  |  |  |  | A8 | Alcohol
 | 2017-01-02 00:00:00 | A3 |  |  | 45
 | 2017-01-03 00:00:00 | A8 |  |  | 18.36
 | 2017-01-04 00:00:00 | A3 |  |  | 18.5
 | 2017-02-01 00:00:00 | A3 |  | 100
 | 2017-02-01 00:00:00 | A4 |  | 50
 | 2017-02-01 00:00:00 | A5 |  | 50
 | 2017-02-01 00:00:00 | A6 |  | 125
 | 2017-02-01 00:00:00 | A7 |  | 200
 | 2017-02-01 00:00:00 | A8 |  | 45
 | 2017-02-06 00:00:00 | A3 |  |  | 55
Spreadsheet: 109817d1306590101-question-about-countifs-variables-reqst-for-help-11-05-28
Sheet: Sheet1

MY0AAA | 2011-06-01 00:00:00
MY0AAB | 2011-05-01 00:00:00
MY0123 | 2011-02-01 00:00:00
MY0555 | 2011-06-01 00:00:00
MY0A85 | 2011-06-01 00:00:00
MY0AAB | 2011-05-01 00:00:00
MY0AAA | 2011-02-01 00:00:00
639254 | 2011-06-01 00:00:00
008L-123456 | 2011-06-01 00:00:00
96-52364 | 2011-05-01 00:00:00
96-11111 | 2011-02-01 00:00:00
MY0A114 | 2011-06-01 00:00:00
MY0A85 | 2011-06-01 00:00:00
MY0A52 | 2011-05-01 00:00:00
Spreadsheet: 708976d1608116540-lookup-across-multiple-columns-across-multiple-sheets-test-2-
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  | Apple
 |  | Apple |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Orange
 |  |  | Apple | No | Blue |  |  |  |  |  | Pear
 |  |  | Apple | Yes | Blue
 |  |  | Apple | No | Red
 |  |  | Apple | No | Red
 |  |  | Apple | Yes | Blue
 |  |  | Apple | Yes | Blue
 |  |  | Apple | No | Blue
 |  |  | Apple | Yes | Red
Spreadsheet: f58a6829-bb74-48f8-afc0-80eefb0686eb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
4090 | 9439 | [NAME] | [NAME] | USA | 0 | 00:10:48 | 00:00:47 | 00:16:35 | 00:01:00 | 00:12:43 | 1 | [NAME]
4090 | 25222 | Darcy | La Fountain | USA | 0 | [NAME] | 00:00:49 | 00:16:30 | 00:01:18 | 00:12:22 | 2 | [NAME]
4090 | 9363 | [NAME] | Clarke-Steffen | USA | 0 | 00:11:04 | 00:00:55 | 00:21:55 | 00:01:21 | 00:12:21 | 3 | 00:47:36
4090 | 25224 | [NAME] | Mosca | USA | 0 | 00:12:47 | 00:00:47 | 00:19:38 | 00:00:59 | 00:14:15 | 4 | 00:48:26
4090 | 13256 | [NAME] | Karia | USA | 0 | 00:11:28 | 00:00:47 | 00:25:22 | 00:01:09 | 00:13:22 | 5 | 00:52:08
4090 | 25223 | [NAME] | Trippet | USA | 0 | 00:14:06 | 00:01:32 | 00:27:10 | 00:01:37 | 00:16:22 | 6 | 01:00:47
Spreadsheet: 794628d1662151744-8x8-matrix-8x8-matrix-2
Sheet: Sheet2

 |  |  | X1 | X2 | X3 | X4 | X5 | X6 | X7 | X8 | result
 |  | EQ1 | 0 | 90 | 161 | 235 | 307 | 380 | 452 | 525 | 190899.0863999999
 |  | EQ2 | -90 | 0 | 71 | 145 | 217 | 290 | 362 | 435 | 3605871.632
 |  | EQ3 | -161 | -71 | 0 | 74 | 146 | 219 | 291 | 364 | 1696880.768
 |  | EQ4 | -235 | -145 | -74 | 0 | 72 | 145 | 217 | 290 | -1378715.624
 |  | EQ5 | -307 | -217 | -146 | -72 | 0 | 73 | 145 | 218 | -2905908.315199999
 |  | EQ6 | -380 | -290 | -219 | -145 | -73 | 0 | 72 | 145 | -4454312.015999999
 |  | EQ7 | -452 | -362 | -291 | -217 | -145 | -72 | 0 | 73 | -5981504.707199999
 |  | EQ8 | -525 | -435 | -364 | -290 | -218 | -145 | -73 | 0 | -7529908.407999999
 |  | [NAME]
 |  | = | = | = | = | = | = | = | = | = | <>
 |  | EQ2 | -90 | 0 | 71 | 145 | 217 | 290 | 362 | 435 | 3605871.632
 |  |  | The same equation cannot have 2 different solutions.
 |  |  | This equation system therefore has no valid results.
Spreadsheet: 56809d1256916000-removing-blank-cells-from-column-blanks-removed
Sheet: Sheet1

 |  |  |  |  | Raw Data |  | Raw Data with Blank cells removed
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 1 |  | 1
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 6
 |  |  |  |  | 3 |  | 4
 |  |  |  |  |  |  | 17
 |  |  |  |  |  |  | 17
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 10
 |  |  |  |  | 6
 |  |  |  |  | 4
 |  |  |  |  | 17
 |  |  |  |  | 17
 |  |  |  |  | 2
 |  |  |  |  | 10