tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 35069d1232573369-table-searching-problems-book1a
Sheet: Sheet11

Nets | slot standard & Pencil pleats with NEW Weighted Hem
 |  | (2w) | (4w) | (6w) | (8w) | (10w) |  | !!!!!!! | If tervoile tape is required Add 20% to Pencil pleat price
 |  | 1 | 2 | 3 | 4 | 5
 |  | 20.7 | 41.445 | 62.145 | 82.935 | 103.59
 | Slot, standard & pencil pleats with sides & NEW Weighted Hem
 |  | (2w) | (4w) | (6w) | (8w) | (10w)
 |  | 1 | 2 | 3 | 4 | 5
upto 200cm |  | 35.05500000000001 | 55.8 | 76.5 | 97.245 | 118.035 |  | !!!!!!! | If tervoile tape is required Add 20% to Pencil pleat price
201cm to 400 cm |  | 49.77 | 70.11000000000001 | 91.215 | 111.6 | 132.66
401cm and over |  | 68.76 | 89.41499999999999 | 110.115 | 130.905 | 151.65
Nets | Pinch pleat with NEW Weighted Hem
 |  | (2w) | (4w) | (6w) | (8w) | (10w)
 |  | 1 | 2 | 3 | 4 | 5
 |  | 30.375 | 60.795 | 91.215 | 121.68 | 152.1
 | Pinch pleat with sides & NEW Weighted Hem
 |  | (2w) | (4w) | (6w) | (8w) | (10w)
 |  | 1 | 2 | 3 | 4 | 5
upto 200cm |  | 44.595 | 75.105 | 105.525 | 135.945 | 166.32
201cm to 400 cm |  | 58.995 | 89.41499999999999 | 119.79 | 150.255 | 180.675
401cm and over |  | 78.885 | 108.72 | 139.23 | 169.605 | 200.025
If a Turned Hem is required please add 15% to above prices
Spreadsheet: 814793d1674593989-find-values-in-different-worksheets-pasta1
Sheet: Planilha2

 | 2023-05-01 00:00:00 | 115 | 2023-06-01 00:00:00 | 215
 | 2023-05-02 00:00:00 | 116 | 2023-06-02 00:00:00 | 266
 | 2023-05-03 00:00:00 | 117 | 2023-06-03 00:00:00 | 317
 | 2023-05-04 00:00:00 | 118 | 2023-06-04 00:00:00 | 368
 | 2023-05-05 00:00:00 | 119 | 2023-06-05 00:00:00 | 419
 | 2023-07-01 00:00:00 | 121 | 2023-08-01 00:00:00 | 521
 | 2023-07-01 00:00:00 | 122 | 2023-08-01 00:00:00 | 572
 | 2023-07-01 00:00:00 | 123 | 2023-08-01 00:00:00 | 623
 | 2023-07-01 00:00:00 | 124 | 2023-08-01 00:00:00 | 674
 | 2023-07-01 00:00:00 | 125 | 2023-08-01 00:00:00 | 725
Spreadsheet: mark_whitt__25276__El Paso Summary-bv and mv
Sheet: PV numbers

50/50 |  | PV PGE Basis | PV PGE Index | PV Delivery Swap | PV SJ Basis | PV SJ Index | PV SJ Swap | PV Perm Basis | [NAME] Index | [NAME] | [NAME] | [NAME] | [NAME] | PV Spread | PV Reservation | PV Commodity | [NAME] | [NAME] | Value over tolls | PV Volume |  | 60/40 | PGE Basis | PGE Index | Delivery Swap | SJ Basis | SJ Index | SJ Swap | Perm Basis | Perm Index | Perm Swap | [NAME] | Receipt Index | [NAME] | Spread | Reservation | Commodity | Fuel | Tolls | Value over tolls | PV Volume |  | PV Volume | PGE CG Basis | PGE CG Index | PGE CG Swap | PGE BDR Basis | PGE BDR Index | PGE BDR Swap | Spread | Demand | Commodity | Fuel | Tariff | Value over Tolls
Spreadsheet: 45388d1244121021-trying-to-sum-every-eighth-cell-in-a-column-expenditure-example
Sheet: Sheet1

Contract | 2009-01-09 00:00:00 | 2009-02-09 00:00:00 | 2009-03-09 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00
budget | 100 | 100 | 100 | 100 | 100 | 100 | 100
released | 0 | 100 | 100 | 100 | 100 | 100 | 100
obligated | 0 | 0 | 100 | 100 | 100 | 100 | 100
expenditures | 0 | 0 | 0 | 15 | 20 | 40
BCWS | 0 | 16.66666666666667 | 33.33333333333334 | 50 | 66.66666666666667 | 83.33333333333334 | 100
ACWP | 0 | 0 | 17 | 49 | 70 | 81
Contract | 2009-01-09 00:00:00 | 2009-02-09 00:00:00 | 2009-03-09 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00
budget | 900 | 900 | 900 | 900 | 900 | 900 | 900
released | 900 | 900 | 900 | 900 | 900 | 900 | 900
obligated | 0 | 900 | 900 | 900 | 900 | 900 | 900
expenditures | 0 | 121 | 250 | 369 | 515 | 642
BCWS | 128.5714285714286 | 257.1428571428572 | 385.7142857142858 | 514.2857142857143 | 642.8571428571429 | 771.4285714285714 | 900
ACWP | 121 | 250 | 369 | 515 | 642 | 750
Contract | 2009-01-09 00:00:00 | 2009-02-09 00:00:00 | 2009-03-09 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00
budget | 0 | 0 | 0 | 0 | 150 | 150 | 150
released | 0 | 0 | 0 | 0 | 150 | 150 | 150
obligated | 0 | 0 | 0 | 0 | 0 | 150 | 150
expenditures | 0 | 0 | 0 | 0 | 0 | 0
BCWS | 0 | 0 | 0 | 0 | 0 | 70 | 80
ACWP | 0 | 0 | 0 | 0 | 0 | 62
Total
budget | 1000 | 1000 | 1000 | 1000 | 1150 | 1150 | 1150
released | 900 | 1000 | 1000 | 1000 | 1150 | 1150 | 1150
obligated | 0 | 900 | 1000 | 1000 | 1000 | 1150 | 1150
expenditures | 0 | 121 | 250 | 384 | 535 | 682 | 0
BCWS | 128.5714285714286 | 273.8095238095239 | 419.0476190476191 | 564.2857142857143 | 709.5238095238095 | 924.7619047619048 | 1080
ACWP | 121 | 250 | 386 | 564 | 712 | 893 | 0
Spreadsheet: 865578d1712644035-finance-tracker-help-suggestions-to-track-welcomed-personal-finance-tracker-test
Sheet: Cash Flow 2024

Date | Type | Category | Amount | Description | Total Spend (Past Week) | Total Spend (YTD Activity) | Total Spend (YTD)
2024-01-01 00:00:00 | Debit | Living Expenses (Misc) | 1000
2024-01-01 00:00:00 | Debit | Living Expenses (Board) | 50
2024-01-01 00:00:00 | Debit | Shopping (Grocery) | 100
2024-01-01 00:00:00 | Debit | Misc (Reimbursement) | 100
2024-01-02 00:00:00 | Credit | Reimbursement | 100
2024-01-03 00:00:00 | Debit | Shopping ([NAME]) | 100
2024-01-06 00:00:00 | Debit | Partner | 100
2024-01-07 00:00:00 | Debit | Entertainment | 100
2024-01-07 00:00:00 | Debit | Business | 100
2024-01-08 00:00:00 | Debit | Entertainment (Subscriptions) | 50
2024-01-08 00:00:00 | Debit | Entertainment | 100
2024-01-08 00:00:00 | Credit | Income | 1000
2024-01-12 00:00:00 | Credit | Income | 1000
2024-02-01 00:00:00 | Debit | Shopping (Grocery) | 200
 |  |  |  |  | In this column I want to show the spending over the previous 7 days from the data in A (changing per each entry
 |  |  |  |  |  | In this column I want to show the spending on the category YTD (changing per each entry)
 |  |  |  |  |  |  | In this column I want the YTD spending calculated (changing per each entry*)
 |  |  |  |  | Example of entries and how I want the formulas to work: |  | *changing per each entry:
 |  |  |  |  |  |  | Date | Category | Amount | Total Spend Past Week | Total Spend YTD Category | Total Spend YTD
 |  |  |  |  |  |  | 2024-01-01 00:00:00 | Business | 100 | 100 | 100 | 100
 |  |  |  |  |  |  | 2024-01-02 00:00:00 | Business | 50 | 150 | 150 | 150
 |  |  |  |  |  |  | 2024-02-01 00:00:00 | Business | 100 | 100 | 350 | 350
 |  |  |  |  |  |  | 2024-02-02 00:00:00 | Transport | 50 | 150 | 50 | 400
Spreadsheet: 57769d1257977111-need-one-cell-to-reference-just-the-month-from-another-date-formatted-cell-book2
Sheet: Sheet1

Check Request | Vendor | Line of Business | Cost | Notes
2009-01-07 00:00:00 | Co A | Shipping | 10
2009-01-07 00:00:00 | Co A | Receiving | 15
2009-01-14 00:00:00 | Co B | Shipping | 20
2009-01-14 00:00:00 | Co B | Shipping | 25
2009-02-15 00:00:00 | Co B | Receiving | 30
2009-02-16 00:00:00 | Co B | Receiving | 31
2009-02-17 00:00:00 | Co B | Receiving | 32
2009-02-18 00:00:00 | Co B | Receiving | 33
2009-02-19 00:00:00 | Co B | Receiving | 34
2009-02-20 00:00:00 | Co B | Shipping | 35
Spreadsheet: 75051d1275573783-conditional-equations-example-9
Sheet: CPA

 |  | Ash Content
 |  | W1 (DISH) | [NAME] (DISH + SAMPLE) | W3 (DISH + ASH) | ASH (%) | CaCO3 | H2S | Lead | IO
 | SAMPLE 1 |  |  |  | 0
 | SAMPLE 2 |  |  |  | 0
 | SAMPLE 3 |  |  |  | 0
 | SAMPLE 4 |  |  |  | 0
 | SAMPLE 5 |  |  |  | 0
 | SAMPLE 6 |  |  |  | 0
 |  | RESULTS
 | PELLET SIZE
 | BULK DENSITY
 | DSC MP (C)
 | SPECIFIC GRAVITY
Spreadsheet: errol_mclaughlin_jr__10058__Budget Temp
Sheet: EPSC

ENRON PROPERTY & SERVICES CORP *
DESCRIPTIONS | AMOUNT | Notes - Items to take into consideration
TRAVEL |  | When making reservations through TAP there are booking fees - $50 for domestic travel and $140 for international travel
SHIPPING/RECEIVING |  | $10 per package - fed ex, UPS, etc
FORMS MANAGEMENT |  | Business cards, letterhead, etc.
[NAME] |  | Based on usage
PHONE OPERATORS |  | Based on # of workplaces
MAIL CENTER |  | Based on usage
FACILITY MAINT. |  | Based on square footage.  There is an additional cost of $20 per hour to have the A/C turned on after hrs - with a $40 min.
SECURITY CHARGES |  | Based on square footage
CHURN/RELOCATION |  | Approx $400 Per Person per move (Phone-Lucent - $75, Boxes - $95, Furniture (chair) - $95, Flat Screen - $25, CPU - $50, [NAME]50, [NAME]50, [NAME]50, etc)
A / V & LOCKS / KEYS |  | Based on usage
BUILDING SERVICES |  | Based on square footage
FACILITY OPERATIONS |  | Based on square footage
CONVENIENCE COPIERS |  | Based on square footage
TRANS. SUBSIDY |  | Enron subsidies approx $100 per FTE who rides the bus
CAFETERIA |  | Based on # of workplaces
ENRON BUILDING |  | $2.08 per square foot per month - no estimate for Enron South at this time - average rent is $200 per cube per month - don't forget to budget for conference rooms *
PARKING |  | Enron subsidies approx $60 per month per FTE who parks
* If you have any questions regarding what to estimate for these services, we suggest you pull the last 3
months worth of EPSC invoices and take an average to project for 2002 charges.
Spreadsheet: 123167d1317387495-vlookup-lists-error-query-vlookup-lists-query
Sheet: Compare Lists

List 1 | List 2 | Result
FGH | ABC | GOOD
ABC | DEF | #N/A
JHG | DRG | #N/A
AJS | AJS | GOOD
MXY | MXY | GOOD
LPO | KLH | #N/A
AJS | NBV | #N/A
DGF | DGF | GOOD
RTD | ABC | GOOD
Spreadsheet: 846115d1697434777-countifs-with-wildcards-tempcountifs
Sheet: Data

DATA |  |  |  |  |  | Summary
Date | Character | Lessons_Abs | Code |  |  | Date | Code | Character | Count
2023-02-20 00:00:00 | 4 | 1 | RAD |  |  | 2023-02-20 00:00:00 | RAD | H
2023-02-20 00:00:00 | 6 | 1 | RAD |  |  | 2023-02-20 00:00:00 | RAD | 1
2023-02-20 00:00:00 | H 1 2 | 2.2 | RAD |  |  | 2023-02-20 00:00:00 | LAL | 2
2023-02-20 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | RAD | 3
2023-02-20 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | RAD | 4
2023-02-20 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | LAL | 5
2023-06-15 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | RAD | 6
2023-06-15 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD
2023-06-15 00:00:00 | H 1 2 3 4 5 6 | 0 | RAD
2023-02-08 00:00:00 | 5 6 | 2 | LAL
2023-03-09 00:00:00 | H 1 2 3 4 5 6 | 6.2 | LAL
Spreadsheet: 877091d1723766105-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-jdnethaji-
Sheet: Install

Installed  On | MarkNo. | Qty (Nos) | [NAME]. | GROSS WEIGHT | Assembly Name
2024-06-23 00:00:00 | QLGF-C2001 | 1
2024-06-23 00:00:00 | QLGF-C2002 | 1
2024-06-24 00:00:00 | QLGF-C2002 | 1
2024-06-23 00:00:00 | QLGF-C2003 | 1
2024-06-24 00:00:00 | QLGF-BM2003 | 1
2024-06-24 00:00:00 | QLGF-BM2004 | 1 |  | 205.7
2024-06-24 00:00:00 | QLGF-HB2005 | 1
2024-06-24 00:00:00 | QLGF-HB2009 | 1
2024-06-25 00:00:00 | QL-1-BM2002 | 1 |  | 673.6
2024-06-25 00:00:00 | QL-1-BM2003 | 1
2024-06-25 00:00:00 | QL-1-BM2004 | 1
Spreadsheet: 73543d1274199336-excel-2007-matrixed-data-gathering-with-report-example-data-gathering-and-report
Sheet: Role Based Report

[NAME] | Module | Task
Role 1 | Module 1 | Tracking Task 1
Role 1 | Module 1 | Querying Task 2
Role 1 | Module 1 | Querying Task 4
Role 1 | Module 1 | Managing Task 1
Role 1 | Module 1 | Managing Task 4
Role 2 | Module 1 | Tracking Task 1
Role 2 | Module 1 | Tracking Task 3
Role 2 | Module 1 | Tracking Task 5
Role 2 | Module 1 | Querying Task 1
Role 2 | Module 1 | Querying Task 2
Role 2 | Module 1 | Querying Task 3
Role 2 | Module 1 | Managing Task 2
Role 2 | Module 1 | Managing Task 3
Role 2 | Module 1 | Managing Task 4
Role 3 | Module 1 | Tracking Task 1
Role 3 | Module 1 | Tracking Task 2
Role 3 | Module 1 | Tracking Task 4
Role 3 | Module 1 | Querying Task 2
Role 3 | Module 1 | Querying Task 3
Role 3 | Module 1 | Querying Task 4
Role 3 | Module 1 | Managing Task 1
Role 3 | Module 1 | Managing Task 3
Role 3 | Module 1 | Managing Task 4
Role 4 | Module 1 | Tracking Task 2
Role 4 | Module 1 | Tracking Task 4
Role 4 | Module 1 | Querying Task 2
Role 4 | Module 1 | Querying Task 3
Role 4 | Module 1 | Managing Task 2
Role 4 | Module 1 | Managing Task 4
Spreadsheet: 77382d1277862084-filtering-one-list-by-date-and-category-example
Sheet: Example

21 0134D JUN 10 | Apple |  |  | Date | Apples | [NAME] | Kiwis
22 0134D JUN 10 | Apple |  |  | 2010-06-21 00:00:00 | 1
22 0635D JUN 10 | [NAME] |  |  | 2010-06-22 00:00:00 | 1 | 1
23 0213D JUN 10 | Apple |  |  | 2010-06-23 00:00:00 | 1 | 2 | 1
23 0313D JUN 10 | [NAME]
23 0413D JUN 10 | [NAME]
23 0513D JUN 10 | Kiwi
Spreadsheet: 100995d1299177068-drop-down-list-if-cells-contain-data-sample_dropdown
Sheet: CSA

 |  | 2011 President's Club - Inside Sales Executive Period Performance Tracker
 |  |  | Data source: period ending Send Reports
 |  |  | 4 | 8 | 12 | 17 | 21 | 25 | 30 | 34 | 38 | 43 | 47 | 52
 |  | Branch CSA Total | 2010 YTD NAR Performance
 |  |  | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6 | Period 7 | Period 8 | Period 9 | Period 10 | Period 11 | Period 12
 |  |  | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 1145
 |  | YTD week [NAME]. | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Detailed CSA summary
 |  | Accounts
 |  | Number | ISE Name | Period | Account # | CSA Name |  | Comment
 |  | 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
 |  | 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
 |  | 70
 |  | 71
 |  | 72
 |  | 73
 |  | 74
 |  | 75
 |  | 76
 |  | 77
 |  | 78
 |  | 79
 |  | 80
 |  | 81
 |  | 82
 |  | 83
 |  | 84
 |  | 85
 |  | 86
 |  | 87
 |  | 88
 |  | 89
 |  | 90
 |  | 91
 |  | 92
 |  | 93
 |  | 94
 |  | 95
 |  | 96
 |  | 97
 |  | 98
 |  | 99
 |  | 100
 |  | 101
 |  | 102
 |  | 103
 |  | 104
 |  | 105
 |  | 106
 |  | 107
 |  | 108
 |  | 109
 |  | 110
 |  | 111
 |  | 112
 |  | 113
 |  | 114
 |  | 115
 |  | 116
 |  | 117
 |  | 118
 |  | 119
 |  | 120
 |  | 121
 |  | 122
 |  | 123
 |  | 124
 |  | 125
 |  | 126
 |  | 127
 |  | 128
 |  | 129
 |  | 130
 |  | 131
 |  | 132
 |  | 133
 |  | 134
 |  | 135
 |  | 136
 |  | 137
 |  | 138
 |  | 139
 |  | 140
 |  | 141
 |  | 142
 |  | 143
 |  | 144
 |  | 145
 |  | 146
 |  | 147
 |  | 148
 |  | 149
 |  | 150
 |  | 151
 |  | 152
 |  | 153
 |  | 154
 |  | 155
 |  | 156
 |  | 157
 |  | 158
 |  | 159
 |  | 160
 |  | 161
 |  | 162
 |  | 163
 |  | 164
 |  | 165
 |  | 166
 |  | 167
 |  | 168
 |  | 169
 |  | 170
 |  | 171
 |  | 172
 |  | 173
 |  | 174
 |  | 175
 |  | 176
 |  | 177
 |  | 178
 |  | 179
 |  | 180
 |  | 181
 |  | 182
 |  | 183
 |  | 184
 |  | 185
 |  | 186
 |  | 187
 |  | 188
 |  | 189
 |  | 190
 |  | 191
 |  | 192
 |  | 193
 |  | 194
 |  | 195
 |  | 196
 |  | 197
 |  | 198
 |  | 199
 |  | 200
 |  | 201
 |  | 202
 |  | 203
 |  | 204
 |  | 205
 |  | 206
 |  | 207
 |  | 208
 |  | 209
 |  | 210
 |  | 211
 |  | 212
 |  | 213
 |  | 214
 |  | 215
 |  | 216
 |  | 217
 |  | 218
 |  | 219
 |  | 220
 |  | 221
 |  | 222
 |  | 223
 |  | 224
 |  | 225
 |  | 226
 |  | 227
 |  | 228
 |  | 229
 |  | 230
 |  | 231
 |  | 232
 |  | 233
 |  | 234
 |  | 235
Spreadsheet: 176ee733-3b62-44da-be8e-c791ea844dea
Sheet: Sheet1

State Senate (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/23/2013 6:35:08 AM
Precincts Reporting: 607/607 - Total Ballots Cast: 316016
2004 General Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Precinct 3801 | 188 | 114 | 302
Precinct 3803 | 529 | 308 | 837
Precinct 3805 | 468 | 214 | 682
Precinct 3809 | 245 | 109 | 354
Precinct 3841 | 1021 | 605 | 1626
Precinct 3852 | 663 | 434 | 1097
Precinct 3873 | 297 | 202 | 499
TOTAL | 3411 | 1986 | 5397
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 52285d1251988000-counting-transactions-per-agent-sample-1
Sheet: Sheet1

 |  | Name | Amount | AMT>1
 |  | [NAME] | 23.5 | 1
 |  | Gemma | 25 | 1
 |  | [NAME] | 26 | 1
 |  | Kayleigh | 24 | 1
 |  | [NAME] | 10 | 1
 |  | [NAME] | 78 | 1
 |  | Gemma | 23 | 1
 |  | [NAME] | 0 | 0
 |  | [NAME] | 0 | 0
 |  | [NAME] | 0 | 0
 |  | [NAME] | 0 | 0
 |  | [NAME] | 0 | 0
 |  | [NAME] | 0 | 0
 |  | [NAME] | -10 | 0
 |  | [NAME] | -10 | 0
 |  | [NAME] | 10 | 1
 |  | [NAME] | 105 | 1
 |  | [NAME] | 0 | 0
 |  | [NAME] | -10 | 0
 |  | [NAME] | -10 | 0
 |  | [NAME] | 10 | 1
 |  | [NAME] | 6.5 | 1
 |  | [NAME] | 0 | 0
 |  | [NAME] | 0 | 0
 |  | [NAME] | 0 | 0
 |  | [NAME] | -15 | 0
 |  | [NAME] | -15 | 0
 |  | [NAME] | 15 | 1
 |  | [NAME] | 0 | 0
 |  | [NAME] | 0 | 0
 |  | [NAME] | 0 | 0
 |  | [NAME] | 33 | 1
 |  | [NAME] | -15 | 0
 |  | [NAME] | -15 | 0
 |  | [NAME] | 15 | 1
 |  | [NAME] | 15 | 1
 |  | [NAME] | 101.4 | 1
 |  | [NAME] | 0 | 0
 |  | [NAME] | -10 | 0
 |  | [NAME] | -10 | 0
 |  | [NAME] | 10 | 1 |  |  |  |  | AMT>1 | TRUE
 |  |  |  |  |  | Count of Amount |  |  | Count of AMT>1
 |  |  |  |  |  | Name | Total |  | Name | Total
 |  |  |  |  |  | [NAME] | 8 |  | [NAME] | 3
 |  |  |  |  |  | [NAME] | 3 |  | [NAME] | 1
 |  |  |  |  |  | [NAME] | 7 |  | [NAME] | 4
 |  |  |  |  |  | [NAME] | 12 |  | [NAME] | 5
 |  |  |  |  |  | Gemma | 2 |  | Gemma | 2
 |  |  |  |  |  | [NAME] | 8 |  | [NAME] | 1
 |  |  |  |  |  | Kayleigh | 1 |  | Kayleigh | 1
 |  |  |  |  |  | Grand Total | 41 |  | Grand Total | 17
Spreadsheet: f8a30561-7457-4430-8cb9-26c2b9c8c04e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5898 | 40952 | [NAME] | Egan | GBR | 1002 | 00:18:32 | [NAME] | 00:51:40 | [NAME] | 00:20:34 | 1 | 01:35:18
5898 | 43863 | Carly | Waugh | USA | 1001 | 00:24:48 | [NAME] | 00:44:35 | [NAME] | 00:24:17 | 2 | 01:38:29
5898 | 43861 | Marayke | [NAME] | AUS | 1020 | 00:30:47 | 00:01:41 | 00:59:36 | 00:05:38 | 00:34:58 | 3 | 02:12:40
Spreadsheet: 738860d1625302673-adding-a-max-to-a-formula-to-prevent-a-return-of-a-minus-result-midshires-master
Sheet:  Master

1 | PLAYER | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total | Par 3 | Adjusted stableford points | Stroke Index |  |  | Handicap Alteration (Official) | Handicap Alteration (Unofficial) | New H'Cap | Official [NAME] points
1 |  | PAR | 4 | 4 | 4 | 4 | 3 | 5 | 3 | 5 | 4 | 3 | 4 | 4 | 5 | 3 | 4 | 4 | 4 | 4 |  |  |  | Playing H'Cap |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Official H'Cap
1 |  | S/I | 9 | 3 | 13 | 7 | 16 | 2 | 11 | 5 | 15 | 17 | 1 | 12 | 6 | 18 | 10 | 4 | 14 | 8 | 71 |  |  | S/I 1 | S/I 2 | S/I 3 |  |  |  |  |  |  |  |  |  |  |  |  | S/I 1 | S/1 2 | S/1 3
0 | [NAME] |  | 5 | 6 | 7 | 8
0 | [NAME]
0 | [NAME]
1 | [NAME]
0 | [NAME]
0 | [NAME]
1 | [NAME]
0 | [NAME]
1 | [NAME]
0 | [NAME]
0 | [NAME]
1 | [NAME]
0 | [NAME] |  | 5 | 6 | 7 | 8
1 | [NAME]
0 | [NAME]
1 | [NAME]
1 | [NAME]
0 | [NAME]
0 | [NAME]
1 | [NAME]
0 | [NAME]
1 | [NAME]
1 | [NAME]
1 | [NAME]
1 | [NAME]
1 | [NAME]
1 | [NAME]
0 | [NAME]
1 | [NAME]
1 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
1 | [NAME]
1 | [NAME]
1 | [NAME]
0 | [NAME]
1 | [NAME]
1 | [NAME]
1 | [NAME]
1 | [NAME]
0 | [NAME]
1 | [NAME]
1 | [NAME]
1 | [NAME]
0 | [NAME]
0 | [NAME]
1 | [NAME]
0 | [NAME]
1 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
1 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
 |  | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total
 |  | PAR | 4 | 5 | 4 | 4 | 3 | 5 | 3 | 5 | 4 | 3 | 5 | 4 | 4 | 3 | 4 | 5 | 4 | 5
 |  | S/I | 11 | 3 | 7 | 9 | 15 | 1 | 17 | 5 | 13 | 18 | 6 | 10 | 2 | 16 | 14 | 4 | 8 | 12 | 73
 | Number of Players
 | Average Score
 | PARS
 | BIRDIES
 | Total Score
Spreadsheet: 124099d1318098392-calculate-hi-points-points
Sheet: Year End Totals

Class | Number/Horse/Owner/Exhibitor | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | June | June | [NAME] | [NAME] | Duke Neff | [NAME] |  |  |  |  | TOTAL
AB YEARLING IN HAND TRAIL | 500/Dun Differently/[NAME]/[NAME] | 4 | 4 | 4 | 4 | 4 | 4 | 6 | 6 | 4 | 4 |  |  | 2 | 4 |  |  | 50
AB YEARLING IN HAND TRAIL | 505/Spursuade Me/Darrin Fultz/[NAME] | 3 | 3 | 3 | 3 | 5 | 5 | 5 | 4 | 3 | 3 |  |  | 4 | 3 |  |  | 44
AB YEARLING IN HAND TRAIL | 2/Choco Chanel/Peach Madl/Peach Madl | 2 | 1 | 2 | 2 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 |  |  | 27
AB YEARLING IN HAND TRAIL | 55/[NAME]/Julie Pennington/[NAME] | 1 | 2 | 1 | 1 |  |  | 3 | 3 |  |  |  |  | 3 | 2 | 0 | 0 | 16
AB YEARLING IN HAND TRAIL | 135/Ima Kids Superstar/Ellen Weeks/Doug Perry |  |  |  |  | 2 | 2 | 4 | 5 | 0 | 0 | 0 | 0 |  |  |  |  | 13
AB WALK TROT TRAIL | 92/Awesome Like That/Julie Dishman/[NAME] |  |  |  |  | 5 | 6 | 6 | 6 | 6 | 5 | 5 | 5 |  |  |  |  | 44
AB WALK TROT TRAIL | 1973/Impress A Hot Diva/Jennifer Gilbert/Jennifer Gilbert |  |  | 3 | 3 | 6 | 5 | 3 | 4 | 1 |  | 6 | 6 |  |  |  |  | 37
AB WALK TROT TRAIL | 123 [NAME][NAME]/[NAME] | 1 | 3 |  |  | 2 |  |  |  | 4 | 3 |  |  | 4 | 4 | 2 | 1 | 24
AB WALK TROT TRAIL | 9/Chex Out This Lope/Katie Rees/Erin Rees |  |  |  |  |  | 3 |  | 5 |  | 6 | 3 | 3 |  |  |  |  | 20
AB WALK TROT TRAIL | 94/Hes Been Lopin/Kayla Herl/Kayla Herl |  |  |  |  | 3 | 2 |  |  |  | 2 | 1 |  | 5 | 5 |  |  | 18
AB WALK TROT TRAIL | 24/Good N Plenty Gold/Jani Born/Stephanie Meyer |  |  |  |  |  |  | 5 |  | 5 | 4 |  |  |  |  |  |  | 14
AB WALK TROT TRAIL | 6/Docs Perfect Image/Jessica Streit/Isabella Streit | 3 | 2 | 1 | 1 |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 3 | 13
AB WALK TROT TRAIL | 95/King Of Lope N Slow/Raymond Mason/[NAME] |  |  |  |  |  | 4 |  |  |  |  | 4 | 2 |  |  |  |  | 10
AB WALK TROT TRAIL | 27/Princess Bar Retreat/Rhonda Kraft/Rhonda Kraft |  |  |  |  |  |  |  |  | 3 | 1 | 2 | 4 |  |  |  |  | 10
AB WALK TROT TRAIL | 21/Zippos April Lili/Olivia Stour/Olivia Stour | 2 | 1 | 2 | 2 |  |  | 2 |  |  |  |  |  |  |  |  |  | 9
AB WALK TROT TRAIL | 63/Justalittlesaltnlime/Mary Mages/Mary Mages |  |  |  |  | 1 |  | 4 | 2 |  |  |  |  |  |  |  |  | 7
AB WALK TROT TRAIL | 87/Smokys Scooter/[NAME]/[NAME] |  |  |  |  | 4 | 1 |  |  |  |  |  |  |  |  |  |  | 5
AB WALK TROT TRAIL | 91/A Touch of Destiny/[NAME][NAME] |  |  |  |  |  |  | 1 | 3 |  |  |  | 1 |  |  |  |  | 5
AB WALK TROT TRAIL | 66/A Burning Impulse/Susie McCreary/Josie |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2
AB WALK TROT TRAIL | 106/Top Fever/J Hendrickson/Sydney Mohn |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
ALL BREED 13-U YOUTH TRAIL | 48/Talkabouttwistn/Macy Flowers/Macy Flowers | 1 | 1 | 1 | 1 | 3 | 4 | 4 | 4 |  |  |  |  | 0 | 3 | 4 | 4 | 30
ALL BREED 13-U YOUTH TRAIL | 227/[NAME] |  |  |  |  | 4 | 2 | 3 | 3 |  |  |  |  |  |  |  |  | 12
ALL BREED 13-U YOUTH TRAIL | 909/Dun With Therapy/Tracy Wingate/[NAME] |  |  |  |  | 2 | 3 | 0 | 0 | 1 | 1 | 1 | 1 | 3 | 1 | 2 | 2 | 17