tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 180632f8-184e-4bd7-bea5-952a7e3009ab
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/15/2009 | Men's Basketball | LOYOLA (MARYLAND) | 12:00 AM | W, 83-60
11/24/2009 | Men's Basketball | The Citadel (Charleston, W.Va.) | 12:00 AM | W, 69-50
11/26/2009 | Men's Basketball | Long Beach State (Anaheim, Calif.) | 12:00 AM | W, 85-62
11/27/2009 | Men's Basketball | Texas A&M (Anaheim, Calif.) | 12:00 AM | W, 73-66
11/29/2009 | Men's Basketball | Portland (Anaheim, Calif.) | 12:00 AM | W, 84-66
12/09/2009 | Men's Basketball | DUQUESNE | 12:00 AM | W, 68-39
12/12/2009 | Men's Basketball | COPPIN STATE | 12:00 AM | W, 69-43
12/19/2009 | Men's Basketball | at Cleveland State | 12:00 AM | W, 80-78
12/23/2009 | Men's Basketball | OLE MISS | 12:00 AM | W, 76-66
12/26/2009 | Men's Basketball | at Seton Hall | 12:00 AM | W, 90-84 (OT)
12/29/2009 | Men's Basketball | MARQUETTE | 12:00 AM | W, 63-62
01/01/2010 | Men's Basketball | at Purdue | 12:00 AM | L, 62-77
01/06/2010 | Men's Basketball | RUTGERS | 12:00 AM | W, 86-52
01/09/2010 | Men's Basketball | at Notre Dame | 12:00 AM | L, 68-70
[NAME] | Men's Basketball | at USF | 12:00 AM | W, 69-50
01/16/2010 | Men's Basketball | SYRACUSE | 12:00 AM | L, 71-72
[NAME] | Men's Basketball | vs. [NAME] (Charleston, W.Va.) | 12:00 AM | W, 68-60
01/23/2010 | Men's Basketball | OHIO STATE | 12:00 AM | W, 71-65
01/26/2010 | Men's Basketball | at DePaul | 12:00 AM | W, 62-46
01/30/2010 | Men's Basketball | LOUISVILLE | 12:00 AM | W, 77-74
02/03/2010 | Men's Basketball | PITT | 12:00 AM | W, 70-51
02/06/2010 | Men's Basketball | at St. John's | 12:00 AM | W, 79-60
02/08/2010 | Men's Basketball | VILLANOVA | 12:00 AM | L, 75-82
02/12/2010 | Men's Basketball | at Pitt | 12:00 AM | L, 95-98 (3OT)
02/17/2010 | Men's Basketball | at Providence | 12:00 AM | W, 88-74
02/20/2010 | Men's Basketball | SETON HALL | 12:00 AM | W, 75-63
02/22/2010 | Men's Basketball | at Connecticut | 12:00 AM | L, 62-73
02/27/2010 | Men's Basketball | CINCINNATI | 12:00 AM | W, 74-68
03/01/2010 | Men's Basketball | GEORGETOWN | 12:00 AM | W, 81-68
03/06/2010 | Men's Basketball | at Villanova | 12:00 AM | W, 68-66 (OT)
[NAME] | Men's Basketball | vs. Cincinnati | 12:00 AM | W, 54-51
03/12/2010 | Men's Basketball | vs. Notre Dame | 12:00 AM | W, 53-51
03/13/2010 | Men's Basketball | vs. Georgetown | 12:00 AM | W, 60-58
03/19/2010 | Men's Basketball | vs. Morgan State | 12:00 AM | W, 77-50
03/21/2010 | Men's Basketball | vs. Missouri | 12:00 AM | W, 68-59
[NAME] | Men's Basketball | vs. Washington | 12:00 AM | W, 69-56
[NAME] | Men's Basketball | vs. Kentucky | 12:00 AM | W, 73-66
04/03/2010 | Men's Basketball | vs. [NAME] | 12:00 AM | L, 57-78
Spreadsheet: 111425d1307793553-copying-conditional-format-sample
Sheet: Sheet-1

 | Monthly Incentive Year 2011
 | Amson - Green
 | Name: | [NAME] |  |  |  |  |  |  |  |  | Territory #: | PSR-1/G |  | Area: | Peshawar
 | Net Rate | Products | T a r g e t s |  |  |  |  |  |  | Period |  |  | Incentive Sales Units | Incentive Rate | Amount
 |  |  |  |  |  |  |  |  |  | Apr-11 |  |  |  |  |  |  |  |  | 90-99.9% | 100-124.9% |  | 125 % & above
 |  |  | 2nd Qtr | Apr |  | May |  | Jun |  | Targets | Sales | % |  |  |  |  |  |  | Rs. | Rs. |  | Rs.
 | 2100 | Advir |  | 7.26 | 4 |  |  |  |  | 7.26 | 4 | 55.09641873278237 |  | 0 | 0 | 0 |  |  | 11 | 33 | 0 | 67
 | 38.25 | Ciprox 100 mg |  | 24.75 | 0 |  |  |  |  | 24.75 | 0 | 0 |  | 0 | 0 |  |  |  | 0.5 | 1 | 0 | 2
 | 71.4 | Ciprox 250 mg |  | 396 | 444 |  |  |  |  | 396 | 444 | 112.1212121212121 |  | 1.5 | 666 |  |  |  | 0.8 | 1.5 | 0 | 2.5
 | 112.2 | Ciprox 500 mg |  | 297 | 346 |  |  |  |  | 297 | 346 | 116.4983164983165 |  | 2 | 692 |  |  |  | 1 | 2 | 0 | 3.6
 | 153 | Ciprox 750 mg |  | 19.8 | 0 |  |  |  |  | 19.8 | 0 | 0 |  | 0 | 0 |  |  |  | 2.5 | 5 | 0 | 7.5
 |  | Total Cirpox |  | 65573.8875 | 70522.8 |  |  |  |  | 65573.8875 | 70522.8 | 107.5470780956825 |  |  | 1358 | 0
 | 382.5 | Fefan DS |  | 69.3 | 16 |  |  |  |  | 69.3 | 16 | 23.08802308802309 |  | 0 | 0 |  |  |  | 6 | 12 | 0 | 18
 | 24 | [NAME] |  | 297 | 41 |  |  |  |  | 297 | 41 | 13.8047138047138 |  | 0 | 0 |  |  |  | 0.35 | 0.8 | 0 | 1.15
 |  | Total Fefan |  | 33635.25 | 7104 |  |  |  |  | 33635.25 | 7104 | 21.12069926639463 |  |  | 0 | 1
 | 89.89 | [NAME] 60 ml |  | 158.4 | 48 |  |  |  |  | 158.4 | 48 | 30.3030303030303 |  | 0 | 0 |  |  |  | 1 | 3 | 0 | 4.5
 | 148.22 | [NAME] 120 ml |  | 247.5 | 104 |  |  |  |  | 247.5 | 104 | 42.02020202020202 |  | 0 | 0 |  |  |  | 2 | 5 | 0 | 8
 |  | Total Foro |  | 50923.026 | 19729.6 |  |  |  |  | 50923.026 | 19729.6 | 38.74396623641336 |  |  | 0 | 0
 | 73.95 | Omepral |  | 495 | 114 |  |  |  |  | 495 | 114 | 23.03030303030303 |  | 0 | 0 | 1 |  |  | 0.8 | 1 | 0 | 2.5
 | 88.27 | [NAME] |  | 59.4 | 0 |  |  |  |  | 59.4 | 0 |  |  | 0 | 0 |  |  |  | 1.5 | 2.5 | 0 | 5
 | 43.99 | Silimarin 60 ml |  | 66 | 24 |  |  |  |  | 66 | 24 | 36.36363636363636 |  | 0 | 0 |  |  |  | 0.7 | 1.25 | 0 | 2.5
 | 78.38 | Silimarin 120 ml |  | 79.2 | 10 |  |  |  |  | 79.2 | 10 | 12.62626262626263 |  | 0 | 0 |  |  |  | 1 | 2 | 0 | 4
 |  | Total Silimarin |  | 9111.036 | 1839.56 |  |  |  |  | 9111.036 | 1839.56 | 20.19045913110211 |  |  | 0 | 1
 | 95.63 | Vida |  | 198 | 34 |  |  |  |  | 198 | 34 | 17.17171717171717 |  | 0 | 0 | 1 |  |  | 1 | 3 | 0 | 5
 | 24.92 | Amdoxine |  | 237.6 | 39 |  |  |  |  | 237.6 | 39 | 16.41414141414142 |  | 0 | 0 | 1 |  |  | 1 | 3 | 0 | 4
 | 144.67 | Prenor 5's |  | 118.8 | 0 |  |  |  |  | 118.8 | 0 | 0 |  | 0 | 0 | 1 |  |  | 3 | 6 | 0 | 10
 |  | Total Green |  | 253136.9775 | 120249.56 |  |  |  |  | 253136.9775 | 120249.56 | 47.50375120521458 |  |  | 1358 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 863056d1710613899-need-help-with-formula-or-function-pulling-data-to-another-tab-copy-of-2023-budget-031024
Sheet: Summary-Month

 | GET STARTED |  |  |  |  |  |  | NOTE
 | Set your starting balance in cell [NAME], then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. |  |  |  |  |  |  | Only edit highlighted cells.
 |  |  |  |  |  |  |  | Try not to alter cells that contain a formula.
 | As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.
 | Monthly Budget |  |  |  |  |  |  |  | Starting balance: |  | 1000
 |  |  | START BALANCE | END BALANCE
 | Expenses |  |  |  |  |  | Income
 | Average |  |  |  |  |  | Average
 | Actual |  |  |  |  |  | Actual
 | Expenses |  |  |  |  |  | Income
 |  |  | Budget | Month | Diff. |  |  |  | Budget | Month | Diff.
 | Totals |  |  |  |  |  | Totals
 | Payments |  | 0 |  |  |  | Payday |  | 40000
 | Bank |  | 0 |  |  |  | Other |  | 0
 | Loans |  | 0 |  |  |  | Advance |  | 0
 | Save |  | 0 |  |  |  | Investing |  | 0
 | Home |  | 0
 | Food |  | 0
 | Travel |  | 0
 | Shop |  | 0
 | Medical |  | 0
 | Pet |  | 0
 | Misc |  | 0
Spreadsheet: 782511d1654090443-copy-range-of-cells-based-on-cell-value-help-example-filter-table-aligw
Sheet: Subcontractor Inventory

Select Subcontractor: | Subcontractor 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Subcontractor List
Part Number | Part Name | Quantity Issued | Quantity Installed | Quantity On-Hand |  |  |  |  |  |  |  |  |  |  | Subcontractor 1
 | Widget 1 | 50 | 15 | 35 |  |  |  |  |  |  |  |  |  |  | Subcontractor 2
01-17500103 | Widget 4 | 45 | 0 | 45 |  |  |  |  |  |  |  |  |  |  | Subcontractor 3
01-17500105 | Widget 6 | 550 | 275 | 275
01-17500109 | Widget 10 | 700 | 275 | 425
Spreadsheet: 27269d1220427061-gas-and-milage-formula-not-working-out-gas
Sheet: Dec 08 

Personal Monthly Budget for September 2008
 | Total Projected Cost | Total Actual Cost | Total Difference |  | Projected Monthly Income |  |  | Refuel Date | [NAME] | Km | Litre | R Cost | KM/L | R cost per KM | Price Of Petrol | Date of increase
 | 14212 | 14212 | 0 |  | [NAME] | 14000 |  |  | 240011 |  | (fuel added) |  | (KM)
 |  |  |  |  | Nellie | 3000 |  | 2008-08-21 00:00:00 | 240463 | 452 | 42.445 | 432.939 | 10.64907527388385 | 0.957829646017699 | 10.2 | 2008-08-06 00:00:00
 |  |  |  |  | Extra income | 0
 | Projected Cost | Actual Cost | Difference |  | Total monthly income | 17000
Housing |  |  |  |  | Actual Monthly Income
Mortgage or rent | 4100 | 4100 | 0
Vodacom | 550 | 550 | 0 |  | [NAME] | 14000
Cell C | 250 | 250 |  |  | Nellie | 3000
Deon | 270 | 270 | 0 |  | Extra income | 0
Electricity | 700 | 700 | 0 |  | Total monthly income | 17000
Alarm | 320 | 320 | 0
Tv | 25 | 25 | 0 |  | Projected balance (Projected income minus expenses) | 2788
Transaction cost | 300 | 300 | 0
Maintenance or repairs | 0 | 0 | 0 |  | Actual balance (Actual income minus expenses) | 2788
Supplies | 0 | 0 | 0
Other | 0 | 0 | 0 |  | Difference (Actual minus projected) | 0
Subtotals | 6515 | 6515 | 0
Transportation
Vehicle payment |  | 0 | 0
Bus/taxi fare |  | 0 | 0
Insurance | 0 | 0 | 0
Licensing |  |  | 0
Fuel | 2700 | 2700 | 0
Maintenance |  | 0 | 0
Other |  | 0 | 0
Subtotals | 2700 | 2700 | 0
Insurance
Home | 720 | 720 | 0
Health | 2777 | 2777 | 0
Life | 1500 | 1500 | 0
Other |  |  | 0
Subtotals | 4997 | 4997 | 0 |  |  | Projected Cost | Actual Cost | Difference
 |  |  |  |  | Loans
Food |  |  |  |  | Personal |  |  | 0
Groceries |  |  | 0 |  | Student |  |  | 0
Dining out |  |  | 0 |  | Credit card |  |  | 0
Other |  |  | 0 |  | Credit card |  |  | 0
Subtotals | 0 | 0 | 0 |  | Credit card |  |  | 0
 |  |  |  |  | Other |  |  | 0
Pets |  |  |  |  | Subtotals | 0 | 0 | 0
Food |  |  | 0
Medical |  |  | 0 |  | Taxes
Grooming |  |  | 0 |  | Federal |  |  | 0
Toys |  |  | 0 |  | State |  |  | 0
Other |  |  | 0 |  | Local |  |  | 0
Subtotals | 0 | 0 | 0 |  | Other |  |  | 0
 |  |  |  |  | Subtotals | 0 | 0 | 0
Personal Care
Medical |  | 0 | 0 |  | Savings or Investments
Hair/nails |  | 0 | 0 |  | Retirement account |  |  | 0
Clothing |  | 0 | 0 |  | Investment account |  |  | 0
Dry cleaning |  | 0 | 0 |  | Other |  |  | 0
Health club |  | 0 | 0 |  | Subtotals | 0 | 0 | 0
Organization dues or fees |  | 0 | 0
Other |  | 0 | 0 |  | Gifts and Donations
Subtotals | 0 | 0 | 0 |  | Charity 1 |  |  | 0
 |  |  |  |  | Charity 2 |  |  | 0
Entertainment |  |  |  |  | Charity 3 |  |  | 0
Deon |  | 0 | 0 |  | Subtotals | 0 | 0 | 0
CDs |  | 0 | 0
Movies |  | 0 | 0 |  | Legal
Concerts |  | 0 | 0 |  | Attorney |  |  | 0
Sporting events |  | 0 | 0 |  | Alimony |  |  | 0
Live theater |  | 0 | 0 |  | Payments on lien or judgment |  |  | 0
Other |  | 0 | 0 |  | Other |  |  | 0
Subtotals | 0 | 0 | 0 |  | Subtotals | 0 | 0 | 0
Peterol | Date
Spreadsheet: 801244d1666136994-dynamic-formula-that-subtracts-last-column-from-second-last-column-in-the-grand-total-line-hd
Sheet: Pivot

Sum of Numer of Accounts | Column Labels
Row Labels | 1 | 2 | 5 | 10 | 15 | 20
[NAME] | 16 | 5
Jery |  |  | 15 | 63 | 4 | 3
[NAME] |  |  |  |  | 50
[NAME] |  |  | 3
Grand Total | 16 | 5 | 18 | 63 | 54 | 3
Scenario:
Each week we will be adding a week which will expand the columns.  I would like some sort of a dynamic function that as the pivot table rows it would look at the Grand Total line and subtract
the last column from the second last column.  So in this case it would be 3 - 54.
[NAME]
Spreadsheet: fletcher_sturm__11014__dec 17
Sheet: Dec 3rd

December 17th, 2001 - Indicative Market Closing (3.30PM)
 | Cinergy |  | PJM-W
 |  |  |  |  | Entergy |  | TVA |  | Southern |  | Comed |  |  |  |  | CINERGY OPTIONS
Bal Dec02 | 18.5 | 19.5 | 24.5 | 24.8 | 18 | 19.5 | 18 | 19 | 20 | 20.5 | 18.5 | 19.5 |  |  |  | Monthly Straddles
Jan-Feb02 | 26.1 | 26.2 | 30.85 | 31.05 | 23.65 | 23.8 | 25.5 | 26 | 28.25 | 28.75 | 24.5 | 24.8 |  |  | Janfeb 02 | 2.6 | 3.1
Mar-Apr02 | 24.85 | 25.15 | 28.1 | 28.2 | 22.9 | 23 | 24.5 | 24.75 | 25.25 | 26 | 22.75 | 23.25 |  |  | MarApr 02 | 3.4 | 3.9
May02 | 27.25 | 27.6 | 30.95 | 31.2 | 24.75 | 25.25 | 26.5 | 27 | 28.5 | 29 | 25 | 25.5 |  |  | MAY | 4.1 | 4.6
June02 | 36.75 | 37.25 | 40.85 | 41.2 | 32.75 | 33 | 35 | 36 | 38 | 38.5 | 32.25 | 32.75 |  |  | [NAME] | 6 | 7.5
Jul-Aug02 | 47.75 | 48 | 54.8 | 55 | 42.75 | 43.25 | 46.25 | 47.25 | 48.75 | 49.25 | 44.75 | 45.25 |  |  | July Aug | 10 | 11
Sep02 | 25.25 | 25.5 | 27.9 | 28.1 | 23.75 | 24.25 | 24.75 | 25.65 | 26.35 | 26.75 | 24 | 24.5 |  |  | Sept
Oct-Dec02 | 25.1 | 25.2 | 26.75 | 26.85 | 24 | 24.25 | 24.5 | 25 | 26.5 | 27 | 24.25 | 24.75 |  |  | Oct Dec
JanDec02 | 30.1 | 30.4 | 34 | 34.4 | 28.5 | 29.5 | 29 | 29.5 |  |  | 28.25 | 28.5
Jan-Feb03 | 28.25 | 28.75 | 31.75 | 32 |  |  |  |  |  |  | 26.75 | 27.25
[NAME] | 27 | 27.5 | 30.1 | 30.5
May03 | 28.25 | 29 | 31.85 | 32.05
June03 | 36.5 | 37 | 41 | 41.5
Jul-Aug03 | 47.25 | 47.5 | 52 | 52.25 |  |  |  |  |  |  | 44 | 44.5
Sep03 | 26.75 | 27.25 | 29.25 | 29.5
Oct-Dec03 | 27 | 27.25 | 28.75 | 29.25
Jan-Dec03 | 31.75 | 31.9 | 34 | 34.5 | 29.25 | 30.25 |  |  |  |  | 29.75 | 30.5
Jan Feb04 | 28.5 | 29.5 | 32 | 32.5
[NAME] 04 | 27 | 28 | 29.5 | 30.25
Jan-Dec04 | 31.9 | 32.4 | 34.25 | 34.75
Jan-Dec05 | 32 | 32.5 | 34.25 | 34.75
Prepared by [NAME]  Prebon Energy [PHONE]
Spreadsheet: 209296d1359057293-conditional-formatting-based-on-dates-accounts-recievable
Sheet: Sheet1

Broker Name | Customer Name | Load # | Amt | Lumper | Loading | Add Fee | FS Fee | Total | Inv | Date faxed | Net Terms | Due Date | Amt Paid | Balance
 |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00 | 15
 |  |  |  |  |  |  |  |  |  | 2013-01-15 00:00:00 | 15
 |  |  |  |  |  |  |  |  |  | 2013-01-20 00:00:00 | 15
 |  |  |  |  |  |  |  |  |  | 2013-01-09 00:00:00 | 15
Spreadsheet: 91091d1290773851-calculate-avg-cost-p-m-costs-calculator-help
Sheet: Sheet2

 | Oct | Nov | Dec | Jan | Feb | Apr | Total
Cost 1 | 1260.78 | 3800 | 0 | 3800 | 0 | 3800 | 12660.78
Cost 2 | 75.19 | 75.19 | 75.19 | 75.19 | 75.19 | 75.19 | 451.14
Cost 3 | 0 | 4938.5 | 0 | 0 | 0 | 0 | 4938.5
 |  |  |  |  |  | Total | 18050.42
Spreadsheet: 29040b71-90a3-4b9e-80f9-d44321e656ea
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  |  | SUBSIDES EXTRAORDINAIRES
 |  |  |  |  |  |  |  | FORMULE "DECOMPTE"
FEDERATION
CLUB
 |  | Concerne demande de subside extraordinaire du:
 |  | DECOMPTE
 | Objet:
 | Lieu:
 | Durée: |  | du |  |  |  | au
1. | COMPOSITION DE LA DELEGATION |  |  | Nom et prénom |  |  |  |  | Charge
1.1. | Officiels:
1.2. | [NAME]: |  |  | Nom et prénom |  |  |  |  | Club
2. | RESULTATS SPORTIFS
2.1. | Nombre des pays participants:
2.2. | Sports par équipes
2.2.1. | Rencontres et résultats:
2.2.2. | Classement final:
2.3. | Sports individuels: |  |  | [NAME] |  |  | Discipline |  | Place obtenue | Nombre des concurrents
2.3.1. | Classement des sportifs:
2.3.2. | Abandons:
 |  |  |  | DEPENSES
1. | [NAME] de route: |  |  |  |  |  |  |  | Montant en € | Total
1.1.
1.2.
1.3.
1.4. |  |  |  |  |  |  |  |  |  | 0
2. | [NAME] séjour pendant le voyage:
2.1. | Aller:
2.1.1.
2.1.2.
2.1.3.
2.2. | Retour:
2.2.1.
2.2.2.
2.2.3. |  |  |  |  |  |  |  |  |  | 0
3. | [NAME] séjour sur place:
3.1.
3.2.
3.3.
3.4.
3.5.
3.6.
3.7.
3.8.
3.9.
3.10. |  |  |  |  |  |  |  |  |  | 0
4. | Divers:
4.1.
4.2.
4.3.
4.4. |  |  |  |  |  |  |  |  |  | 0
 | TOTAL DES DEPENSES: |  |  |  |  |  |  |  |  | 0
 |  |  |  | RECETTES
 |  |  |  |  |  |  |  |  | Montant en € | Total
1. | Participation fédérale:
2. | Participation du club:
3. | Participation du Comité Olympique et [NAME]:
4. | Participation des officiels:
5. | Participation des sportifs:
6.
7.
8. |  |  |  |  |  |  |  |  |  | 0
 | Résultat financier: |  |  |  |  |  |  |  | [NAME]: | 0
 |  |  | Certifié exact,
 |  |  |  |  |  |  |  | ,le
 |  |  |  |  |  | Le Président (ou un délégué),
 | Prière de joindre une copie des factures en numérotant les différentes pièces.
Spreadsheet: 275009d1383309585-how-to-divide-the-final-rating-with-weighted-average-excelforum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T.P.S. | Final | Proficiency
10 | 50 |  |  |  |  | P.S. | 0.15 | 33 |  |  |  |  |  |  | P.S. | 0.25 | 10 | 15 |  |  | P.S. | 0.3 | 20 | 10 | 100 |  | P.S. | 0.3 |  | Grade | Level
10 | 27 |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  | 9 | 13 |  |  |  |  | 16 | 10 | 75
10 | 32 |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  | 10 | 14 |  |  |  |  | 17 | 10 | 75
10 | 32 |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  | 10 | 14 |  |  |  |  | 15 | 0 | 75
10 | 41 |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  |  | 14 | 10 | 88
10 | 41 |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  |  | 9 | 13 |  |  |  |  | 20 | 10 | 75
10 | 36 |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  | 9 | 13 |  |  |  |  | 17 | 0 | 75
10 | 37 |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  | 9 | 13 |  |  |  |  | 20 | 10 | 75
10 | 39 |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  |  | 19 | 10 | 88
10 | 30 |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  | 10 | 14 |  |  |  |  | 20 | 10 | 88
10 | 40 |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  | 10 | 14 |  |  |  |  | 20 | 10 | 75
10 | 33 |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  | 9 | 13 |  |  |  |  | 0 | 10 | 75
10 | 40 |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  | 10 | 13 |  |  |  |  | 20 | 10 | 75
Spreadsheet: 768453d1644976064-ignoring-blanks-in-formula-bowling-avg-help-excel-forum
Sheet: AVERAGES

 | NAME |  | SCOTT | SHAWN | I WILL HAVE A FEW HUNDRED BOWERS TO ADD
HIGH COMPOSITE AVERAGE | GAME 1 |  | 217 | 200
HIGH COMPOSITE AVERAGE | GAME 2 |  | 217 | 200
HIGH COMPOSITE AVERAGE | GAME 3 |  | 217 | 200
HIGH COMPOSITE AVERAGE | GAME 4 |  | 217 | 200
HIGH COMPOSITE AVERAGE | GAME 5 |  | 217 | 200
HIGH COMPOSITE AVERAGE | GAME 6 |  | 217 | 200 |  |  | THIS IS THE CORRECT AVERAGE FOR SHAWN'S LAST 12 GAMES
HIGH COMPOSITE AVERAGE | GAME 7 |  | 217 | 200 |  |  | BUT THERE AE NO BLANK CELLS - SO IT WORKS CORRECTLY
HIGH COMPOSITE AVERAGE | GAME 8 |  | 217 | 200
HIGH COMPOSITE AVERAGE | GAME 9 |  | 217 | 200
HIGH COMPOSITE AVERAGE | GAME 10 |  | 217 | 200
HIGH COMPOSITE AVERAGE | GAME 11 |  | 217 | 200
HIGH COMPOSITE AVERAGE | GAME 12 |  | 217 | 200
SPRING  2022 | GAME 13 |  | 220 | 230
SPRING  2022 | GAME 14 |  | 221 | 231
SPRING  2022 | GAME 15 |  | 222 | 232
SPRING  2022 | GAME 16 |  | 223 | 233
SUMMER 2022 | GAME 17 |  | 216 | 216 |  |  | THIS IS THE NUMBER THAT IS CORRECT FOR SCOTT
SUMMER 2022 | GAME 18 |  | 225 | 202 |  |  | IT TAKES THE AVERAGE OF THE LAST 12 GAMES BOWLED
SUMMER 2022 | GAME 19 |  | 222 | 198 |  |  | AND LEAVES OUT THE BLANKS
SUMMER 2022 | GAME 20 |  | 227 | 178
FALL 2022 | GAME 21 |  |  | 222
FALL 2022 | GAME 22 |  |  | 199
FALL 2022 | GAME 23 |  |  | 167
FALL 2022 | GAME 24 |  |  | 189 |  |  | I DON’T KNOW HOW 222 IS CALCULATED. SOMEHOW THE BLANKS MESS UP THE FORMULA
WINTER 2022 | GAME 25 |  | 188 | 244
WINTER 2022 | GAME 26 |  | 192 | 249
WINTER 2022 | GAME 27 |  | 244 | 189
WINTER 2022 | GAME 28 |  | 278 | 200
AVERAGE
Spreadsheet: 61747d1262675963-copy-numbers-out-of-a-list-of-errors-error-range-1-
Sheet: Sheet1

Numbers from Error Column
987.87 | 987.87
98.8 | 98.8
4 | 4
3 | 3
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A | 95 | 3.435 |  | 95 | 0 |  | #N/A
 | #N/A | 95.25 | 3.185 |  | 95.25 | 0 |  | #N/A
 | #N/A | 95.5 | 2.935 |  | 95.5 | 0 |  | #N/A
 | #N/A | 95.75 | 2.685 |  | 95.75 | 0 |  | #N/A
 | #N/A | 96 | 2.435 |  | 96 | 0 |  | #N/A
 | #N/A | 96.25 | 2.185 |  | 96.25 | 0 |  | #N/A
 | #N/A | 96.5 | 1.935 |  | 96.5 | 0 |  | #N/A
 | #N/A | 96.75 | 1.685 |  | 96.75 | 0 |  | #N/A
 | #N/A | 97 | 1.435 |  | 97 | 0 |  | #N/A
 | #N/A | 97.25 | 1.185 |  | 97.25 | 0 |  | #N/A
 | #N/A | 97.5 | 0.935 |  | 97.5 | 0 |  | #N/A
 | #N/A | 97.75 | 0.685 |  | 97.75 | 0 |  | 987.87
 | #N/A | 98 | 0.435 |  | 98 | 0 |  | 98.8
 | #N/A | 98.25 | 0.185 |  | 98.25 | 0 |  | #N/A
 | #N/A | 98.5 | -0.065 |  | 98.5 | 0 |  | #N/A
 |  | 98.75 | -0.315 |  | 98.75 | 0 |  | 4
 |  | 99 | -0.44 |  | 99 | 0 |  | #N/A
 |  | 99.25 | -0.44 |  | 99.25 | 0 |  | #N/A
 |  | 99.5 | -0.44 |  | 99.5 | 0 |  | #N/A
 |  | 99.75 | -0.44 |  | 99.75 | 0 |  | #N/A
 |  | 100 | -0.44 |  | 100 | 0 |  | 3
Spreadsheet: 594a7d57-875e-4a53-a8cc-725d23501923
Sheet: Sheet1

Symbol | HPV1 | HPV5 | HPV8 | HPV9 | HPV3 | HPV18 | HPV33 | HPV16 | HPV39 | [NAME] | HPV11 | HPV32
[NAME] | 1.95 | 2.69 | 3 | 1.92 | 2.15 | 2.46 | 2.39 | 4.49 | 1.5 | 0.48 | 0.82 | 0.61
CASP8 | 50.62 | 27.29 | 11.46 | 14.6 | 53.49 | 21.64 | 23.76 | 11.38 | 16.02 | 11.69 | 6.99 | 3.37
CDC20 | 5.52 | 5.38 | 8.8 | 9.85 | 2.04 | 3.44 | 3.83 | 5.41 | 1.58 | 1.41 | 1.24 | 0.96
CDH1 | 15.42 | 7.67 | 5.7 | 8.33 | 4.21 | 2.5 | 3.26 | 1.44 | 1.55 | 1.21 | 1.24 | 1.04
DERL2 | 8.03 | 7.77 | 6.74 | 11.07 | 7.24 | 7.32 | 7.62 | 3.05 | 4.89 | 3.37 | 2.21 | 2.22
FBXO22 | 4.42 | 2.95 | 3.04 | 4.75 | 3.18 | 3.59 | 5.57 | 2.64 | 1.85 | 2.58 | 2.15 | 1.52
HUWE1 | 2.04 | 5.8 | 3.61 | 4.63 | 0.78 | 1 | 1.27 | 1.42 | 1.23 | 2.64 | 1.09 | 0.92
PIAS1 | 4.23 | 5.8 | 3.33 | 6.71 | 2.58 | 1.64 | 2.71 | 1.11 | 1.16 | 0.8 | 1.72 | 0.73
PIAS4 | 3.68 | 5.76 | 3.17 | 16.77 | 1.83 | 1.66 | 3.59 | 2.46 | 2.29 | 1.04 | 1.63 | 0.73
POMP | 12.52 | 34.41 | 16.58 | 40.76 | 5.08 | 4.77 | 7.09 | 2.36 | 3.17 | 1.46 | 5.34 | 1.55
PSMA2 | 2.74 | 7.89 | 4.85 | 8.5 | 1.75 | 2.15 | 3.86 | 3.22 | 3.07 | 0.91 | 0.72 | 0.69
SKP2 | 2.31 | 2.76 | 4.27 | 3.7 | 1.08 | 2.43 | 2.23 | 1.15 | 1.15 | 0.7 | 0.69 | 0.75
SPOP | 9.53 | 59.11 | 47.34 | 83.17 | 37.18 | 16.28 | 24.57 | 5.69 | 4.08 | 26.13 | 19.38 | 57.28
UBA1 | 8.47 | 3.94 | 14.23 | 4.43 | 4.73 | 3.12 | 2.32 | 3.51 | 1.41 | 1.71 | 2.58 | 2.24
[NAME] | 1.19 | 1.47 | 1.3 | 2.96 | 0.56 | 1.15 | 1.46 | 2.66 | 13.78 | 0.45 | 0.69 | 0.52
WWP2 | 25.6 | 18.21 | 19.1 | 37.36 | 16.12 | 9.35 | 3.57 | 4.06 | 2.69 | 2.35 | 2.21 | 1.51
Spreadsheet: 53366417-0f9d-40f2-a531-235034d34a33
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8344 | 39198 | Mitch | Lewis | AUS | 0 | 00:24:05 | 00:01:01 | 01:06:22 | 00:00:25 | 00:36:59 | 1 | [NAME]
8344 | 56236 | [NAME] | Rodgers | AUS | 0 | 00:24:09 | 00:01:04 | 01:07:03 | 00:00:35 | 00:36:40 | 2 | 02:09:33
8344 | 56235 | Shannon | Cox | AUS | 0 | 00:25:44 | 00:01:16 | 01:08:23 | 00:00:35 | 00:39:16 | 3 | 02:15:15
Spreadsheet: 05fe99ce-2e3e-4653-8480-92c54b45c2f3
Sheet: 14. Land

 | FY 2012 Federal Real Property Charts
 | Land†
 | Agency | Owned Acres** | Owned Annual Operating Costs** | Leased Acres | Leased Annual Costs*
 | Agriculture | 120713.32 | 0 | 20442.984 | 2196845.98
 | Air Force*** | 8022380.43 | 0 | 386906.98 | 0
 | Army*** | 13000907.62 | 0 | 718723.909 | 1271.574
 | Commerce | 7497.708000000001 | 1955491 | 12059.989 | 3151404.4
 | Corps of Engineers*** | 7607271.672 | 35418 | 78888.69 | 233374
 | Defense/WHS*** | 947.56 | 0 | 0 | 0
 | Energy | 2288855.91 | 1806499 | 9141.08 | 2809169
 | Environmental Protection Agency | 603.86 | 4010320.02 | 24.57 | 6234000
 | General Services Administration | 2143.29 | 8499469.11 | 336.47 | 3452878
 | Health and Human Services | 4370.175 | 0 | 1832.106 | 533140.714
 | Homeland Security | 76737.699 | 6564043.380000003 | 11787.25 | 10472741.96
 | Interior | 6284861.09 | 821978.48 | 53446.142 | 1450000.31
 | Justice | 47990.6 | 117050 | 203 | 0
 | Labor | 4152.73 | 1477286.66 | 1677.16 | 10904
 | National Aeronautics And Space Administration | 186476.641 | 5947667 | 9.31 | 48703
 | National Science Foundation | 4721.27 | 183978 | 17.63 | 23898
 | Navy*** | 4189301.459 | 0 | 196314.382 | 0
 | State | 126209.945 | 29376180.71 | 862.571 | 25678201.32
 | State (USAID) | 54.45 | 566312.7999999999 | 3.24 | 117941.64
 | Transportation | 57627.07999999999 | 28544932.73 | 84095.475 | 14145575.004
 | Treasury | 167.065 | 565498 | 0 | 0
 | Veterans Affairs | 35458.04 | 65887611.93 | 134.11 | 4616930.96
 | Total | 42069449.614 | 156359736.82 | 1576907.048 | 75176979.862
 | † All real property data from the CFO Act agencies required to submit data to the FRPP
 | *Includes operations and maintenance costs and rent
 | **includes federal government owned, foreign government owned, museum trust, state government owned, withdrawn land, and leased.  DOES NOT INCLUDE PUBLIC DOMAIN LAND
 | *** Department of Defense