tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 85657d1285731622-count-formula-raginiyanswer
Sheet: Sheet1

Dept No | Category
10 | Old |  |  | Count of Category | Column Labels
12 | Old |  |  | Row Labels | New | Old | Grand Total
10 | New |  |  | 10 | 2 | 1 | 3
15 | Old |  |  | 12 | 1 | 1 | 2
18 | New |  |  | 15 |  | 2 | 2
10 | New |  |  | 18 | 1 |  | 1
15 | Old |  |  | Grand Total | 4 | 4 | 8
12 | New |  |  | ^^^^ My Answer
 |  | 1 | <<< Your Formula
Spreadsheet: 835372d1688544133-count-and-rank-from-data-with-category-example-hd-6-
Sheet: Sheet1

 | Group | Other Data | Other Data | Transport |  |  | Count |  |  |  | Rank |  |  |  |  | Count
 | Children | x | x | Boat |  |  | Group | Transport | Count |  | Group | Transport | Count | Rank |  | Group | Transport | Count
 | Adult | x | x | Car |  |  | Children | Boat | 1 |  | Children | Bus | 2 | 1 |  |  | Car | 1
 | Teen | x | x | Bike |  |  |  | Car |  |  |  | Boat | 1 | 2 |  |  | Bus | 1
 | Adult | x | x | Bus |  |  |  | Bike | 1 |  |  | Bike | 1 | 2 |  |  | Taxi | 2
 | Adult | x | x | Taxi |  |  |  | Bus | 2 |  |  | Plane | 1 | 2 |  |  | Boat | 3
 | Teen | x | x | Boat |  |  |  | Plane | 1 |  |  | Car |  |  |  | Children | Boat | 1
 | Teen | x | x | Taxi |  |  |  | Taxi |  |  |  | Taxi |  |  |  |  | Bike | 1
 | Children | x | x | Bike |  |  | Teen | Boat | 2 |  | Teen | Car | 3 | 1 |  |  | Plane | 1
 | Teen | x | x | Car |  |  |  | Car | 3 |  |  | Boat | 2 | 2 |  |  | Bus | 2
 | Adult | x | x | Boat |  |  |  | Bike | 1 |  |  | Bike | 1 | 3 |  | Teen | Bike | 1
 | Children | x | x | Plane |  |  |  | Bus |  |  |  | Taxi | 1 | 3 |  |  | Boat | 2
 | Children | x | x | Bus |  |  |  | Plane |  |  |  | Bus |  |  |  |  | Taxi | 1
 | Adult | x | x | Boat |  |  |  | Taxi | 1 |  |  | Plane |  |  |  |  | Car | 3
 | Adult | x | x | Taxi |  |  | Adult | Boat | 3 |  | Adult | Boat | 3 | 1
 | Teen | x | x | Boat |  |  |  | Car | 1 |  |  | Taxi | 2 | 2
 | Teen | x | x | Car |  |  |  | Bike |  |  |  | Car | 1 | 3
 | Children | x | x | Bus |  |  |  | Bus | 1 |  |  | Bus | 1 | 3
 | Teen | x | x | Car |  |  |  | Plane |  |  |  | Bike
 | Adult | x | x | Boat |  |  |  | Taxi | 2 |  |  | Plane
Spreadsheet: 871001d1717477359-if-or-statement-with-concat-if-and-or-query-aligw
Sheet: Sheet1

 |  |  |  |  |  | FORMULA RESULT |  |  | FORMULA RESULT REQUIRED
 |  | Purchasing Document | Vendor | PO Corrected | PO Line Corrected | CONTRACT_PO | DATA_SOURCE |  | Result required
 |  | 3106050272 | ABC | 3106050272 | 10 |  | REV |  | [PHONE] - 10 - ABC
 |  | 3106050273 | DEF | 3106050273 | 20 |  | ACC |  | [PHONE] - 20 - DEF
 |  |  |  | 3106050274 | 30 |  | FIN |  | 3106050274
 |  | 3106050272 | ABC | 3106050272 | 10 |  | REV |  | [PHONE] - 10 - ABC
 |  | 3106050273 | DEF | 3106050273 | 20 |  | ACC |  | [PHONE] - 20 - DEF
 |  | 3106050274 | GHI | 3106050274 | 30 |  | FIN |  | 3106050274
Spreadsheet: 682738d1592307236-find-a-high-low-avg-price-v3_sales-2020
Sheet: Pivot Table

Species | Grade | Vessesl | Sum of Boxes2 | Sum of Total Cost | [NAME] | [NAME]
COD | 1 | PD352 | 1 | 130 | 3.25 | 3.25
 |  | BF505 | 28 | 3360 | 3.636363636363636 | 3.636363636363636
 | 1 Total |  | 29 | 3490 | 3.25 | 3.636363636363636
 | 2 | PD352 | 2 | 162.5 | 3.25 | 3.25
 |  | BF505 | 31 | 3668 | 3.575757575757576 | 3.606060606060606
 | 2 Total |  | 33 | 3830.5 | 3.25 | 3.606060606060606
 | 3 | PD352 | 4 | 464 | 2.9 | 2.9
 |  | BF505 | 16 | 1712 | 3.151515151515151 | 3.333333333333333
 | 3 Total |  | 20 | 2176 | 2.9 | 3.333333333333333
 | 4 | PD352 | 3 | 300 | 2.5 | 2.5
 |  | BF505 | 1 | 95 | 2.878787878787879 | 2.878787878787879
 | 4 Total |  | 4 | 395 | 2.5 | 2.878787878787879
 | 5 | BF505 | 1 | 94 | 2.848484848484849 | 2.848484848484849
 | 5 Total |  | 1 | 94 | 2.848484848484849 | 2.848484848484849
FKB | U | BF505 | 1 | 2 | 0.2 | 0.2
 | U Total |  | 1 | 2 | 0.2 | 0.2
NEP | U | PD352 | 4 | 145 | 1.333333333333333 | 2.777777777777778
 | U Total |  | 4 | 145 | 1.333333333333333 | 2.777777777777778
USK | U | BF505 | 8 | 160 | 0.4444444444444444 | 0.4444444444444444
 | U Total |  | 8 | 160 | 0.4444444444444444 | 0.4444444444444444
WHG | 2 | PD352 | 2 | 280 | 3.111111111111111 | 3.111111111111111
 | 2 Total |  | 2 | 280 | 3.111111111111111 | 3.111111111111111
 | 4 | PD352 | 9 | 648 | 1.6 | 1.6
 | 4 Total |  | 9 | 648 | 1.6 | 1.6
Grand Total |  |  | 111 | 11220.5 | 0.2 | 3.636363636363636
Spreadsheet: 698751d1602161433-return-value-based-on-criteria-example-1-
Sheet: Sheet1

 | Date |  |  |  | Units |  |  | Type | Cost In
 | 2020-10-03 00:00:00 |  |  |  | 1 |  |  | RAY
 | 2020-10-05 00:00:00 |  |  |  | 1 |  |  | ETD
 | 2020-10-06 00:00:00 |  |  |  | 1 |  |  | DOGS
 | 2020-10-06 00:00:00 |  |  |  | 1 |  |  | DOGS
 | 2020-10-06 00:00:00 |  |  |  | 1 |  |  | RAY
 | 2020-10-06 00:00:00 |  |  |  | 1 |  |  | ETD
 |  |  |  |  |  |  |  |  |  | RAY = £0.06
 |  |  |  |  |  |  |  |  |  | ETD = £0.11
 |  |  |  |  |  |  |  |  |  | DOGS = £0.15
Spreadsheet: 846340d1697576132-if-cell-containts-either-x-then-perform-calc-1-if-y-then-perform-calc-2-salesid_net_contribution
Sheet: Sheet1

SALES ID | RESULT | MARGIN | NET PROFIT |  | TOTAL
1 | W | 0.01 | 300
2 | L | 0.02
3 | W | 0.01
4 | L | 0.02
5 | L | 0.01
6 | W | 0.02
7 | W | 0.01
8 | W | 0.02
9 | W | 0.01
10 | L | 0.02
Spreadsheet: 872841d1719290063-put-together-uneven-data-from-various-sheet-tabs-book9
Sheet: Total

Year & Month | Total Number of Available Rooms* | Total Number of Sold Rooms** | Total Room Revenue | Currency | Total Revenue
2022-01-01 00:00:00 | 128 | 114 | 348707.4299999999 | Usd | 404716.8499999999
2022-01-02 00:00:00 | 128 | 95 | 250258 | Usd | 295457.9399999999
2022-01-03 00:00:00 | 128 | 96 | 196276.85 | Usd | 233482.73
2022-01-04 00:00:00 | 128 | 75 | 149181.37 | Usd | 176194.89
2022-01-05 00:00:00 | 128 | 78 | 150174.29 | Usd | 184033.99
2022-01-06 00:00:00 | 128 | 105 | 192605 | Usd | 227660.56
2022-02-01 00:00:00 | 128 | 66 | 100503.3 | Usd | 119613.62
2022-02-02 00:00:00 | 128 | 69 | 108712.43 | Usd | 129944.22
2022-02-03 00:00:00 | 128 | 81 | 144285.98 | Usd | 172227.05
2022-02-04 00:00:00 | 128 | 72 | 121112.39 | Usd | 145313.64
2022-02-05 00:00:00 | 128 | 72 | 125246.71 | Usd | 152839.97
2022-02-06 00:00:00 | 128 | 42 | 61754.14999999999 | Usd | 74874.7
2022-03-01 00:00:00 | 128 | 69 | 106379.39 | Usd | 137287.89
2022-03-02 00:00:00 | 128 | 45 | 71860.27 | Usd | 86932.93000000001
2022-03-03 00:00:00 | 128 | 52 | 83295.65 | Usd | 115281.77
2022-03-04 00:00:00 | 128 | 66 | 112571.69 | Usd | 152615.46
2022-03-05 00:00:00 | 128 | 66 | 117264.93 | Usd | 160886.76
2022-03-06 00:00:00 | 128 | 71 | 110788.42 | Usd | 154764.89
Spreadsheet: 792817d1661179089-rolling-total-for-points-scored-in-last-3-games-rolling-total-for-points-scored-in-last-3-games-2-
Sheet: Totals

Name |  |  |  | 5
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
B
C
Spreadsheet: 750282d1633367485-simple-index-match-with-three-conditions-returens-ref-when-only-one-cell-schanged-error
Sheet: Schedule - A330-200 - CCC

 |  |  |  | A330-200 - CCC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flight dates
CPT | STN | Sector 1 |  |  | STN | DUR | Sector 2
Dry Operating Weight Weight Kg | 116610.8843537415
[NAME] | 12784.24 |  |  |  | [NAME]
ZFW  Kg | 116610.8843537415 |  |  |  | ZFW  Kg
[NAME] | 69349 |  |  |  | [NAME]
[NAME] | 185959.8843537415 | [NAME] |  |  | [NAME] |  | [NAME]
ZFW Under Load | 53360.02086167801 | 47.00023854875285 |  |  | ZFW Under Load
MLD Weight | 181968.7074829932 |  |  |  | MLD Weight | 181968.7074829932
MAX ZFW | 169970.9052154195 |  |  |  | MAX ZFW | 169970.9052154195
MTOW | 232960.1229024943 |  |  |  | MTOW | 232960.1229024943
Burn Per [NAME] | 5590 |  |  |  |  | 5590
Flight Time | 11:09:06.623000 |  |  |  |  | 11:09:07
 |  |  |  |  | [NAME]
 |  |  |  |  | Contingency
 |  | 69349 |  |  | Alternative |  | 69349
 |  |  |  |  | Reserve
 |  |  |  |  | Taxi
Total Sector Fuel |  |  |  |  | Total Sector Fuel
Block Speed Kt | 470.3023758099352 |  |  |  | Block Speed Kt | 470.3023758099352
Pax & baggage weight [NAME] |  |  |  |  | Pax & baggage weight [NAME]
Male 0.7% | 109 | 9415.42 |  |  | Male % | #REF! | #REF!
Female 0.3% | 91 | 3368.82 |  |  | [NAME] | 0 | 0
Avg pax weight | 74.18181818181817 |  |  |  | Avg pax weight
Trip Passengers | 123.4 | 12784.24 |  |  | Trip Passengers
APS weight | 116610.8843537415 | 1582 |  |  | APS weight
Pilots & Engineer | 4 | 436 |  |  | Pilots & Engineer | 4
Cabin Crew & Equipment | 6 | 546 |  |  | Cabin Crew & Equipment | 6
 |  | 982
Galley | 2 | 600 |  |  | Galley | 2 | 600
Total |  | 1582 |  |  | Total
Aircraft Basic Empty Weight |  | 116610.8843537415 |  |  | Aircraft Basic Empty Weight |  | 116610.8843537415
Spreadsheet: 715472d1611725687-sum-n-count-of-values-in-rows-sum-first-5-numbers
Sheet: Sheet1

 | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 | Column 16 | Column 17 | Column 18 | Column 19 | Column 20 | [NAME] in this column to sum first 5 values in each row.
 | 1 |  | 2 |  | 5 |  | 8 | 8 | 7 | 8 |  | 5 |  |  | 6 |  | 5 |  | 8 | 1
 | 5 | 2 |  | 4 |  | 7 | 8 |  | 2 | 2 | 2 |  |  | 8 |  | 3 | 1 | 1 |  | 7
 |  |  | 8 |  |  |  | 2 | 8 |  | 3 |  | 3 |  | 7 |  |  | 9 |  | 4
 | 5 |  |  | 8 | 7 | 8 |  | 5 | 5 |  |  | 8 | 7 | 8 |  | 5
 |  | 7 | 8 |  | 2 | 2 | 2 |  |  | 7 |  |  | 2 | 2 | 2 |  |  | 5 | 5
 |  |  | 2 | 8 |  | 3 |  | 3 |  |  | 2 | 8 |  | 3 |  | 3 | 2 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 8 | 7 | 8 |  | 5
 |  |  |  |  |  | 7 | 8 |  | 2 | 2 | 2 |  |  | 8
 |  |  |  |  |  |  | 2 | 8 |  |  |  | 3 |  | 2 | 2 | 8 |  | 5 | 5
 |  |  |  |  |  | 5 |  | 8 | 8 |  | 8 |  | 5 | 3 |  | 2 | 2 |  |  | 7
 |  |  |  |  |  | 5 |  |  | 8 | 7 | 8 |  | 5 |  |  | 3 |  | 3
 |  |  |  |  |  |  | 7 | 8 |  | 2 | 2 | 2 |  | 8
 |  |  |  |  |  |  |  | 2 | 8 |  | 3 |  | 3 | 2 | 2 | 8 |  | 5 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 | 2 |  |  | 7
 | 5 |  | 8 | 8 | 7 |  |  |  |  |  |  |  |  |  |  | 3 |  | 3
 |  | 7 |  |  | 2
Spreadsheet: 113430d1309347697-help-with-line-chart-copy-of-daily-speed-test
Sheet: Sheet1

Daily Speed Test
Site: www.speedtest.net |  |  | Server: Coventry
Date | Time | [NAME] (ms) | DL Speed ([NAME]) | UL Speed ([NAME])
June 15th | 08:47:00 | 11 | 2.82 | 3.62
 | 11:10:00 | 10 | 3.63 | 3.6
 | 14:00:00 | 11 | 1.72 | 2.97
 | 16:15:00 | 26 | 3.63 | 3.46
June 16th | 08:46:00 | 10 | 3.71 | 3.61
 | 13:03:00 | 10 | 3.8 | 3.06
 | 14:54:00 | 26 | 3.41 | 1.79
 | 16:20:00 | 10 | 2.92 | 3.57
June 17th | 08:56:00 | 26 | 2.33 | 2.44
 | 12:31:00 | 10 | 3.71 | 3.63
 | 14:17:00 | 10 | 3.79 | 3.66
 | 15:20:00 | 10 | 2.15 | 3.49
June 20th | 09:05:00 | 11 | 1.57 | 3.2
 | 13:40:00 | 10 | 2.1 | 3.23
 | 15:54:00 | 10 | 3.81 | 3.73
June 21st | 12:00:00 | 11 | 3.43 | 2.89
 | 13:29:00 | 10 | 1.27 | 2.76
 | 14:31:00 | 73 | 1.22 | 2.67
 | 15:29:00 | 26 | 2.85 | 3.64
June 22st | 09:00:00 | 10 | 0.75 | 2.18
 | 12:02:00 | 10 | 2.36 | 3.49
 | 13:00:00 | 10 | 1.64 | 2
 | 15:33:00 | 10 | 1.34 | 3.34
June 23rd | 08:57:00 | 10 | 2.97 | 3.6
 | 10:12:00 | 10 | 1.59 | 3.46
June 24th | 10:18:00 | 10 | 2.58 | 3.51
 | 11:37:00 | 10 | 3.25 | 3.41
 | 13:05:00 | 11 | 0.64 | 2.76
 | 15:02:00 | 10 | 2.56 | 3.29
June 27th | 09:03:00 | 41 | 0.35 | 2.34
 | 12:54:00 | 10 | 2.45 | 3.41
 | 14:17:00 | 10 | 2.95 | 2.97
June 28th | 08:44:00 | 26 | 3.4 | 3.61
 | 11:15:00 | 10 | 3.76 | 3.58
 | 12:27:00 | 10 | 3.67 | 3.67
 | 15:32:00 | 10 | 2.94 | 3.74
June 29th
Spreadsheet: 6590c1e5-f036-4fe9-a3ca-e1500ab9966c
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0028860 | Unnamed: 3 | Facility Name: | Unnamed: 5 | American Soil and Mulch | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Wake | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate
Monthly Limit: |  |  | 150
Daily Limit:
Sample Frequency: |  |  | Monthly
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 119446d1314390802-retrieving-data-based-on-two-criteria-and-two-worksheets-example-spreadsheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | USD | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST
 |  |  |  |  |  |  |  |  |  |  | 2010 JAN | 2010 FEB | 2010 MAR | 2010 Q1 | 2010 APR | 2010 MAY | 2010 JUN | 2010 Q2 | 2010 JUL | 2010 AUG | 2010 SEP | 2010 Q3 | 2010 OCT | 2010 NOV | 2010 DEC | 2010 Q4 | 2010 TOTAL | 2011 JAN | 2011 FEB | 2011 MAR | 2011 APR | 2011 MAY | 2011 JUN | 2011 JUL | 2011 AUG | 2011 SEP | 2011 OCT | 2011 NOV | 2011 DEC | 2011 TOTAL
 |  |  |  |  |  |  |  | A.610070 | N | A.610070-Vacation Expense
 |  |  |  |  |  |  |  | A.610080 | N | A.610080-Vacation Expense Transfer
 |  |  |  |  |  |  |  | A.610090 | N | A.610080-Travel Expenses
 |  |  |  |  |  |  |  |  |  | A.610090-Bonus Expenses
Spreadsheet: 93745d1293512163-ranking-based-on-3-conditions-tiebreakertest5
Sheet: Sheet1

 |  |  |  | 1st tie breaker |  |  |  |  |  |  | 2nd Tie breaker
Team | RANK | Ties | Final Rank with ties shown correctly | Add hi/low ranks for tie breaker | see only ties |  | Correct answer doing it by hand | [NAME] after tie-breaker | Correct answer? |  | Add total Points -- high points = better rank where Rank 1 is the highest | Answer
A | 1 |  |  | 14.5 |  |  | 2 | 2 |  |  | 185 |  | This is incorrect because the 190 points should end up in Rank 1 and 185 in Rank 2.
B | 1 |  |  | 14.5 |  |  | 1 | 1 |  |  | 190
C | 5 |  |  | 28.5 |  |  |  | 5 |  |  | 160
D | 8 |  |  | 39 |  |  | 9 | 9 |  |  | 146
E | 8 |  |  | 37.5 |  |  | 8 | 8 |  |  | 152
F | 6 |  |  | 31 |  |  |  | 6 |  |  | 156
G | 7 |  |  | 35 |  |  |  | 7 |  |  | 158
H | 11 |  |  | 55 | 45 |  | 12 | 12 |  |  | 109
I | 4 |  |  | 24.5 |  |  |  | 4 |  |  | 168
J | 11 |  |  | 45 |  |  | 11 | 11 |  |  | 125
K | 10 |  |  | 38.5 |  |  |  | 10 |  |  | 136
L | 1 |  |  | 18.5 |  |  | 3 | 3 |  |  | 176
 |  |  | Ties |  |  | If Col C=2, then look at D and find the duplicate. Then look at E to find out which number is the lowest.  The lower number, subtract 0.5 from ColumnD.  If they are equal, add 0 (and we'll go on to tie-breaker #2).  If it is the higher number, add 0.5.
 |  |  |  |  |  | If Col C=3, then look at D to find the other 2 duplicates.  Then look at E to find out which number is the lowest.  The lower number, subtract 1 from ColumnD.  The middle number stays the same, add 0.  If it is the higher number, add 1.
 |  |  | 10
 |  |  | 10
 |  |  | 10
 |  |  | 11
 |  |  | 13
 |  |  | 15
 |  |  | 15
Spreadsheet: 782626d1654163868-counting-cells-up-to-a-value-excluding-some-sample-worksheet-attached-high-point-low-point-aligw
Sheet: Sheet1

 |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  | START | 2 | 2 | 2 | 2
 |  |  |  |  |  | 3 | 3 | 3 | 3
 |  |  |  |  |  | 4 | 4 | 4 | 4
 |  |  |  |  |  | 4.5 | 4.5 | 4.5 | 4.5
 |  |  |  |  |  | 5 | 5 | 5 | 5
 |  |  |  |  |  | 10 | 10 | 10 | 10
 |  |  |  |  |  | 20 | 10 | 10 | 10
 |  |  |  |  |  | 30 | 20 | 20 | 10
 |  |  |  |  |  | 40 | 30 | 30 | 20
 |  |  |  |  |  | 50 | 40 | 40 | 30
 |  |  |  |  |  | 60 | 50 | 50 | 40
 |  |  |  |  |  | 70 | 60 | 60 | 50
 |  |  |  |  |  | 80 | 70 | 70 | 60
 |  |  |  |  |  | 92 | 80 | 80 | 70
 |  |  |  |  |  | 90.5 | 92 | 80 | 80
 |  |  |  |  |  | 90 | 90.5 | 92 | 80
 |  |  |  |  |  | 90 | 90 | 90.5 | 92
 |  |  |  |  |  | 80 | 90 | 90 | 90.5
 |  |  |  |  |  | 70 | 80 | 80 | 90
 |  |  |  |  |  | 60 | 70 | 70 | 80
 |  |  |  |  |  | 50 | 60 | 60 | 70
 |  |  |  |  |  | 40 | 50 | 50 | 60
 |  |  |  |  |  | 30 | 40 | 40 | 50
 |  |  |  |  |  | 20 | 30 | 30 | 40
 |  |  |  |  |  | 10 | 20 | 20 | 30
 |  |  |  |  |  | 3 | 10 | 10 | 20 |  | Expected Figures | 26 | 27 | 28 | 29
 |  |  |  |  |  | 4.5 | 3 | 10 | 10
 |  |  |  |  |  | 0 | 4.5 | 3 | 10 |  | Calculated figures
 |  |  |  |  |  | 0 | 0 | 4.5 | 3
 |  |  |  |  |  | 0 | 0 | 0 | 4.5
Spreadsheet: 70027d1270676417-how-to-change-cell-values-based-on-a-set-number-2009-8teams-
Sheet: WEEK 3B

MUV | BET TEAM | VS TEAM | GAME 1 | [NAME] | G1 $ Win | [NAME] | G1 $ Risk | G1   Result | GAME 2 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G2 Result | GAME 3 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G3 Result | TOT Units Risked | TOT Units Won | TOT Units Lost | TOT Unit Profit | TOT $$$ Profit
0 | NYY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | BOS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | MIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | CHC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | WAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | PIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | KC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
RETURN TO MLB OVERALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT L | 0 | 0
WEEK 3B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT W | 0
Spreadsheet: 852865d1702861109-aggregate-function-not-working-with-filter-function-acquisition-channel-report-v2
Sheet: Data

 |  | Acquisition Date
Spreadsheet: 709842d1608575516-fill-in-attendance-sheet-automatically-from-list-demo-file
Sheet: Master Table

 | Date | Special Number | FIRSTNAME | LASTNAME | Grade | Attended | Licence Class | ID Shown | Remarks
 | 2020-03-02 00:00:00 | 10113809
 | 2020-03-02 00:00:00 | 10112578
 | 2020-03-02 00:00:00 | 10113981
 | 2020-03-02 00:00:00 | 10114515
 | 2020-03-02 00:00:00 | 10117107
 | 2020-03-02 00:00:00 | 10117653
 | 2020-03-02 00:00:00 | 10550087
 | 2020-03-02 00:00:00 | 10116445
 | 2020-03-02 00:00:00 | 10112675
 | 2020-03-02 00:00:00 | 10114374
 | 2020-03-02 00:00:00 | 10609754
 | 2020-03-02 00:00:00 | 10112700
 | 2020-03-04 00:00:00 | 10117653
 | 2020-03-04 00:00:00 | 10118374
 | 2020-03-04 00:00:00 | 10117034
 | 2020-03-04 00:00:00 | 10503439
 | 2020-03-04 00:00:00 | 10113621
 | 2020-03-04 00:00:00 | 10113921
 | 2020-03-04 00:00:00 | 10115944
 | 2020-03-04 00:00:00
 | 2020-03-04 00:00:00
 | 2020-03-04 00:00:00
 | 2020-03-04 00:00:00
 | 2020-03-04 00:00:00
 | 2021-01-18 00:00:00 | 10113809
 | 2021-01-18 00:00:00 | 10112578
 | 2021-01-18 00:00:00 | 10113981
 | 2021-01-18 00:00:00 | 10114515
 | 2021-01-18 00:00:00 | 10117107
 | 2021-01-18 00:00:00 | 10117653
 | 2021-01-18 00:00:00 | 10550087
 | 2021-01-18 00:00:00 | 10116445
 | 2021-01-18 00:00:00 | 10112675
 | 2021-01-18 00:00:00 | 10114374
 | 2021-01-18 00:00:00 | 10609754
 | 2021-01-18 00:00:00 | 10112700
Spreadsheet: 84371d1284414583-excel-2007-penalties-for-cross-country-book2
Sheet: Sheet1

No | Start Time | Finish Time | Time Taken | Penalties
1 | 11:00:00 | 11:06:15 |  |  |  | PRE-INTRO Sections A & B
2 | 11:02:00 | 11:08:50
3 | 11:04:00 | 11:09:20 |  |  |  | 2860 | metres - Course distance
4 | 11:06:00 | 11:19:30
5 |  |  |  |  |  | 00:06:30 | minutes - Optimum Time (calculated seperately)
6
7 |  |  |  |  |  | 0.4 | Penalty points - every second in excess of Optimum Time
8
9 |  |  |  |  |  |  | Minimum Time               = Course Distance: |  |  |  |  | metres / | 520 | metres / minute
10
11 |  |  |  |  |  | 1 | Penalty point -for every commenced second faster than a
12 |  |  |  |  |  |  | speed of |  | metres per minute
13
14 |  |  |  |  |  | E | Elimination for exceeding the Time Limit (which is twice the optimum time)
15
16 |  |  |  |  |  | Note to self:
17 |  |  |  |  |  | Use auto-correct to change full stop to colon for entering times:
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
Spreadsheet: 150528d1334589528-percentage-difference-error-example
Sheet: Sheet1

 | Category | January | February | % change
 | A | 381116 | 2208676
 | B | 759598 | 912645
 | C | 5134922 | 6102781
 | D | 8422511 | 9878377
 | E | 16435317 | 17670096
 | F | 4939770 | 5161607
 | G | 11798855 | 10187917
Spreadsheet: 45341d1244100720-nesting-vlookup-in-if-vice-versa-and-pivot-table-686167_jbritt609
Sheet: Feb Summary

Model | Year-to-Date: Cat1 | Year-to-Date: Cat2 | Total YTD
500 | 0 | 71.45889999999997 | 71.45889999999997
750 | 65.81190400000003 | 927.4886422000018 | 993.3005462000018
900 | 854.1944177920018 | 0 | 854.1944177920018
AB | 249.962575616 | 271.4106356 | 521.373211216
AD | 0 | 22.094818 | 22.094818
AG | 20.34878848 | 0 | 20.34878848
AL | 0 | 624.5652999999998 | 624.5652999999998
AN | 575.2094080000002 | 0 | 575.2094080000002
BX | 1531.641888 | 1663.06455 | 3194.706438
BZ | 1219.255296 | 1323.8736 | 2543.128896
CA | 695.2956480000003 | 754.9555499999997 | 1450.251198
CB | 151.9132000000001 | 164.948125 | 316.8613250000001
DE | -1471.4364 | 0 | -1471.4364
DF | 0 | 1143.86391 | 1143.86391
DS | 0 | 910.56672 | 910.56672
DV | -4460.2879 | 0 | -4460.2879
DX | -3484.0798 | 0 | -3484.0798
FA | 0 | 519.2621099999999 | 519.2621099999999
GL | 0 | 1176.200585231511 | 1176.200585231511
GM | 0 | 90.62105580143117 | 90.62105580143117
MF | 285.2062146675877 | 309.6783580871581 | 594.8845727547458
MR | 3503.44592112051 | 3804.05939528445 | 7307.50531640496
OA | 123.9390020547091 | 134.5735986293186 | 258.5126006840277
OB | 46.54539717054277 | 50.53922891928637 | 97.08462608982914
OR | 58.47083890788366 | 63.48793419553044 | 121.9587731034141
RA | 180.8564546675876 | 0 | 180.8564546675876
RF | 3399.096161120509 | 0 | 3399.096161120509
TM | 19.58924205470908 | 0 | 19.58924205470908
ZP | 102.5331888744973 | 111.3310578351268 | 213.8642467096242
Grand Total | 3667.511446526538 | 14138.04407478381 | 17805.55552131035
Spreadsheet: 111132d1307598005-returning-a-lookup-value-based-on-multiple-criteria-sample
Sheet: Ship Data

Part # | S/N | Ship Date | Transaction
CI-5230-100 | 1228 | 2006-02-03 00:00:00 | 1
CI-5230-100 | 1229 | 2005-03-02 00:00:00 | 1
CI-5230-100 | 1230 | 2005-09-23 00:00:00 | 1
CI-5230-100 | 1230 | 2006-01-12 00:00:00 | 1
CI-5230-100 | 1230 | 2006-12-18 00:00:00 | 1
CI-5230-100 | 1230 | 2007-09-21 00:00:00 | 1
CI-5230-100 | 1234 | 2005-01-18 00:00:00 | 1
CI-5230-100 | 1235 | 2009-09-09 00:00:00 | 1
CI-5230-100 | 2409 | 2005-04-12 00:00:00 | 1
CI-5230-200 | 10017 | 2005-11-23 00:00:00 | 1
CI-5235-100 | 10019 | 2009-04-07 00:00:00 | 1
CI-5230-200 | 10020 | 2005-03-25 00:00:00 | 1
CI-5230-200 | 10020 | 2006-05-18 00:00:00 | 1
CI-5235-100 | 10020 | 2006-12-07 00:00:00 | -1
CI-5235-100 | 10020 | 2006-12-07 00:00:00 | 1
CI-5235-100 | 10020 | 2006-12-08 00:00:00 | 1
CI-5230-200 | 10020 | 2007-08-06 00:00:00 | 1
CI-5235-100 | 10020 | 2008-01-08 00:00:00 | 1
CI-5235-100 | 10020 | 2009-10-26 00:00:00 | 1
[NAME] | 10020 | 2010-09-16 00:00:00 | 1
CI-5235-100 | 10021 | 2006-12-08 00:00:00 | 1
CI-5235-100 | 10022 | 2007-01-04 00:00:00 | 1
CI-5235-100 | 10023 | 2006-12-07 00:00:00 | 1
CI-5235-100 | 10023 | 2007-11-26 00:00:00 | 1
CI-5230-200 | 10024 | 2005-06-08 00:00:00 | 1
CI-5230-200 | 10024 | 2008-11-14 00:00:00 | 1
CI-5235-100 | 10024 | 2009-08-03 00:00:00 | 1
CI-5235-100 | 10025 | 2007-01-04 00:00:00 | 1
CI-5230-200 | 10025 | 2007-02-13 00:00:00 | 1
AB-7200 | 13124 | 2005-12-21 00:00:00 | 1
CI-5235-100 | 13124 | 2007-08-02 00:00:00 | 1
[NAME] | 13124 | 2010-07-27 00:00:00 | 1
[NAME] | 13124 | 2011-03-14 00:00:00 | 1
[NAME] | 13124 | 2011-06-01 00:00:00 | 1
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 41391 | 40000
2 | 45177 | 42000
3 | 44413 | 42000
4 | 42918 | 40464
5 | 41645 | 40500
6 | 41817 | 38926
7 | 43253 | 39977
8 | 41966 | 40000
9 | 43196 | 40000
10 | 13372 | 11000
11 | 11783 | 11000
12 | 38810 | 26395
13 | 36764 | 33473
14 | 39824 | 38500
15 | 39336 | 37118
16 | 38586 | 38500
17 | 38586 | 40000
18 | 37730 | 39991
19 | 37263 | 39788
20 | 34033 | 38284
21 | 33585 | 38783
22 | 33038 | 37825
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | -47511.02
2001-07-22 00:00:00