tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 548732d1511292173-approval-matrix-with-4-different-lookup-criteria-index-matches-array-not-sure-approval-matrix-1-1-
Sheet: Sheet1

 |  |  | < | < | < | <
 |  |  | Op Income | Revenue | Capital | New Lease (Term) | BU MD | BU VP | COO | CEO | BU Finance | CFO | Ground | Corp | BOD
 | Op Income | Revenue | 0.07 | 0
 | 7%-12.5% | <$2M | 0.125 | 2000000 |  |  | A |  |  |  | A
 |  | >=$2m | 0.125 | 5000000 |  |  | R | A |  |  | A
 |  | >=$5m | 0.125 | 10000000 |  |  | R | R | A |  | A
 |  | >=$10m | 0.125 | 1e+99 |  |  | R | R | R | A | R | A
 | >12.5% | <$2.5m | 1 | 2500000 |  |  | A |  |  |  | A
 |  | >=$2.5M | 1 | 7500000 |  |  | R | A |  |  | A
 |  | >=$7.5m | 1 | 12500000 |  |  | R | R | A |  | A
 |  | >=$12.5m | 1 | 1e+99 | 0 | 0 | R | R | R | A | R | A
Capital | $0-$1M | $0-$2.5m |  |  | 1000000 | 2500000 | R | A |  |  | A |  |  |  |  |  | Auxiliary Calculations
 | $1m- $2.5M | $2.5M to $5m |  |  | 2500000 | 5000000 | R | R | A |  | R | A |  |  |  |  |  | Aux | Excel Row
 | $2.5M-$5m | $5m to $10m |  |  | 5000000 | 10000000 | R | R | R | A | R | A |  |  |  |  | Op Income:
 | $5m-$15m | $10m to $40m |  |  | 15000000 | 40000000 | R | R | R | R | R | R | A |  |  |  | Revenue:
 | $15m - $50m | $40m to $100m |  |  | 50000000 | 100000000 | R | R | R | R | R | R | R | A |  |  | Capital:
 | > $50m | >$100m |  |  | 1e+99 | 1e+99 | R | R | R | R | R | R | R | R | A |  | New Lease:
 | Example:
 | Op Income: | 0.15
 | Revenue: | 11000000
 | Capital: | 100000
 | New Lease: | 100000
 | Reviewer (s):
 | Approver:
 | Reviewer (s): | BU MD | COO | BU Finance
 | Approver: | BU VP | CEO | BU Finance | CFO
 | Reviewer:
 | Approver:
Spreadsheet: 202409d1356549383-sum-like-cells-in-a-ticket-ticket-example1
Sheet: Sheet2

 |  | Description |  |  |  |  | QTY |  | UOM |  | Unit Amt | Gross Amt | Unit Net | Discount | Net Amount
 |  | CLASS H PREMIUM |  |  |  |  |  |  | per sack
 |  | [NAME] |  |  |  |  |  |  | per pound
 |  | Cement Retarder >200degF |  |  |  |  |  |  | per pound
 |  | [NAME] |  |  |  |  |  |  | per pound
Spreadsheet: 53521d1253438380-look-up-names-from-a-table-fix
Sheet: Fixtures 1st Half

lions | v | lol | lions | v | colts | cubs | v | colts | cubs | v | sharks | bears | v | sharks | bears | v | diamonds
colts | v | boxers | lol | v | cubs | sharks | v | lions | colts | v | bears | diamonds | v | cubs | sharks | v | rovers
cubs | v | old boys | boxers | v | sharks | bears | v | lol | lions | v | diamonds | rovers | v | colts | cubs | v | rangers
sharks | v | nvg | old boys | v | bears | diamonds | v | boxers | lol | v | rovers | rangers | v | lions | colts | v | bulls
bears | v | slackers | nvg | v | diamonds | rovers | v | old boys | boxers | v | rangers | bulls | v | lol | lions | v | tigers
diamonds | v | tigers | slackers | v | rovers | rangers | v | nvg | old boys | v | bulls | tigers | v | boxers | lol | v | slackers
rovers | v | bulls | tigers | v | rangers | bulls | v | slackers | nvg | v | tigers | slackers | v | old boys | boxers | v | nvg
rangers | v | Free Week | bulls | v | Free Week | tigers | v | Free Week | slackers | v | Free Week | nvg | v | Free Week | old boys | v | Free Week
rovers | v | diamonds | rovers | v | rangers | bulls | v | rangers | bulls | v | tigers | slackers | v | tigers | slackers | v | nvg
rangers | v | bears | diamonds | v | bulls | tigers | v | rovers | rangers | v | slackers | nvg | v | bulls | tigers | v | old boys
bulls | v | sharks | bears | v | tigers | slackers | v | diamonds | rovers | v | nvg | old boys | v | rangers | bulls | v | boxers
tigers | v | cubs | sharks | v | slackers | nvg | v | bears | diamonds | v | old boys | boxers | v | rovers | rangers | v | lol
slackers | v | colts | cubs | v | nvg | old boys | v | sharks | bears | v | boxers | lol | v | diamonds | rovers | v | lions
nvg | v | lions | colts | v | old boys | boxers | v | cubs | sharks | v | lol | lions | v | bears | diamonds | v | colts
old boys | v | lol | lions | v | boxers | lol | v | colts | cubs | v | lions | colts | v | sharks | bears | v | cubs
boxers | v | Free Week | lol | v | Free Week | lions | v | Free Week | colts | v | Free Week | cubs | v | Free Week | sharks | v | Free Week
old boys | v | nvg | old boys | v | boxers | lol | v | boxers
boxers | v | slackers | nvg | v | lol | lions | v | old boys
lol | v | tigers | slackers | v | lions | colts | v | nvg
lions | v | bulls | tigers | v | colts | cubs | v | slackers
colts | v | rangers | bulls | v | cubs | sharks | v | tigers
cubs | v | rovers | rangers | v | sharks | bears | v | bulls
sharks | v | diamonds | rovers | v | bears | diamonds | v | rangers
bears | v | Free Week | diamonds | v | Free Week | rovers | v | Free Week
Spreadsheet: 158517d1338292015-combine-match-and-index-template-spend
Sheet: Reporting

Product | Month | Facility | City | Consumption
A | Jan | Fac1 | Cit1
A | Jan | Fac2 | Cit3
B | Jan | Fac2 | Cit3
C | Jan | Fac3 | Cit2
D | Jan | Fac1 | Cit2
A | Feb | Fac1 | Cit1
A | Feb | Fac2 | Cit3
B | Feb | Fac2 | Cit3
C | Feb | Fac3 | Cit2
D | Feb | Fac1 | Cit2
A | Mar | Fac1 | Cit1
A | Mar | Fac2 | Cit3
B | Mar | Fac2 | Cit3
C | Mar | Fac3 | Cit2
D | Mar | Fac1 | Cit2
Spreadsheet: 93376d1292962297-piecwise-linear-interpolation-tuneman-linear-interpolation
Sheet: Sheet1

X | Y
0 | 1 | Baseline data
0.1 |  | Interpolated Y values
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1 | 2 | Baseline data
Spreadsheet: 741367d1626992613-automation-to-combine-subsequent-cells-in-a-column-with-the-original-record-row-mock-spreadsheet_solved
Sheet: Sheet1

Name | Last 4 | Phone | Entry | Exit | SC | SC disability
[NAME], [NAME] | K1007 | (609)351-2036 | SEP 11,2001 | SEP 30,2001 | 70 | POST-TRAUMATIC STRESS DIS
 |  |  |  |  |  | LIMITED MOTION OF WRIST
 |  |  |  |  |  | MIGRAINE HEADACHES
 |  |  |  |  |  | INFLAMMATION OF UVEA
[NAME], [NAME] | S8808 | (856)200-1597 | SEP 11,2001 | SEP 17,2002 | 80 | HYPERTENSIVE VASCULAR DIS
 |  |  |  |  |  | LABYRINTHITIS
 |  |  |  |  |  | POST-TRAUMATIC STRESS DIS
 |  |  |  |  |  | HEMORRHOIDS
[NAME], [NAME] | A7684 | (609)638-0079 | SEP 12,2001 | MAR 29,2004 | 90 | IMPAIRED HEARING
 |  |  |  |  |  | ARTHRITIS, DEGENERATIVE
 |  |  |  |  |  | FLAT FOOT CONDITION
 |  |  |  |  |  | [NAME] OF KNEE
 |  |  |  |  |  | LOSS OF EYE
 |  |  |  |  |  | DEFORMITY OF THE PENIS
 |  |  |  |  |  | PARALYSIS OF EXTERNAL POP
 |  |  |  |  |  | PARALYSIS OF EXTERNAL POP
 |  |  |  |  |  | TINNITUS
 |  |  |  |  |  | LIMITED MOTION OF ANKLE
 |  |  |  |  |  | SCARS
 |  |  |  |  |  | FOOT PAIN
 |  |  |  |  |  | HEMORRHOIDS
 |  |  |  |  |  | HYPERTENSIVE VASCULAR DIS
 |  |  |  |  |  | HIATAL HERNIA
 |  |  |  |  |  | SLEEP APNEA SYNDROMES
 |  |  |  |  |  | [NAME] OF
 |  |  |  |  |  | LIMITED MOTION OF ARM
 |  |  |  |  |  | NEOPLASM, BENIGN, GENITOU
Spreadsheet: 814978d1674676568-subtract-a-certain-amount-of-weeks-from-date-and-result-in-weekday-book1
Sheet: example

 |  |  |  |  |  |  |  |  |  | LAST UPDATE
 |  |  |  |  |  |  |  | Anticipated Order Date |  | Lead Time at Order(Weeks) |  | Need Onsite Per Schedule
 |  |  |  |  |  |  |  |  |  | 10-12 |  | 2023-04-05 00:00:00
 |  |  |  |  |  |  |  |  |  | 4-6 |  | 2023-04-19 00:00:00
 |  |  |  |  |  |  |  |  |  | 8-10 |  | 2023-04-10 00:00:00
 |  |  |  |  |  |  |  |  |  | 8-10 |  | 2023-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 12-16 |  | 2023-03-29 00:00:00
 |  |  |  |  |  |  |  |  |  | 12-16 |  | 2023-03-29 00:00:00
 |  |  |  |  |  |  |  |  |  | 8-10 |  | 2023-03-15 00:00:00
 |  |  |  |  |  |  |  |  |  | 8-10 |  | 2023-03-15 00:00:00
 |  |  |  |  |  |  |  |  |  | 20-22 |  | 2023-05-17 00:00:00
 |  |  |  |  |  |  |  |  |  | 24 |  | 2023-05-17 00:00:00
 |  |  |  |  |  |  |  |  |  | 22 |  | 2023-03-15 00:00:00
 |  |  |  |  |  |  |  |  |  | 3-18 |  | 2023-07-19 00:00:00
 |  | *Italic represents last date of submission to meet date required onsite
Spreadsheet: 457048d1461179350-value-lookups-from-a-table-rccs-refi
Sheet: AHFC FHA

 | Your actual rate, payment, and costs could be higher. Get an official [NAME] before choosing a loan.
 |  |  |  |  |  | NMLS:
 |  |  |  |  |  | Office:
 |  |  |  |  |  | Cell:
 |  |  |  |  |  | Fax:
 |  |  |  |  |  | [NAME]:
 | Loan Program: AHFC FHA
 | Loan Details |  |  |  |  | Monthly Payment Information
 | Estimated Value |  |  |  |  | Principal and Interest |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Property Taxes |  |  |  |  |  | [NAME] | 0.49
 | Base Loan Amount |  |  |  |  | Estimated Homeowners Insurance |  |  |  |  |  | [NAME]
 | FHA Upfront Premium |  |  |  |  | FHA Mortgage Insurance |  | 0.85 |  |  |  | PMI Percentage
 | Total Loan Amount |  |  |  |  | Homeowners Association Dues |  |  | 0 |  |  | [NAME]
 | Interest Rate |  |  | 0.035 |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  | 30
 | AHFC Commitment Fee |  |  | 0.0025
 | Number of Units |  |  | 1 |  | Total Monthly Payment
 | Cash to Close Amounts
 | Closing Costs
 | Prepaid Costs
 |  | Total
 | Closing Costs |  |  |  |  | Prepaid Expenses
 | [NAME] fee |  |  |  |  | Interest | 15 | days
 | AHFC Commitment Fee |  |  |  |  | Taxes | 7 | months
 | Credit Report fee |  |  | 50 |  | Homeowners Insurance | 14 | months
 | Wire fee |  |  | 40 |  | Homeowners Dues | 0 | months
 | [NAME] fee |  |  | 290
 | Tax registration fee |  |  | 96
 | Flood Certification |  |  | 11 |  | Total
 | Title Closing fees |  | 0.5 |  |  | Income Ratios
 | Title Insurance - ALTA
 | Recording Fees |  |  | 100 |  | Income
 |  |  |  | 0 |  | Monthly debts
 |  |  |  | 0 |  | Housing Ratio
 | Total |  |  |  |  | [NAME]
Spreadsheet: 02f56ded-c5b4-4c7a-9d04-e7700f19b13f
Sheet: Income

COMBINED HOUSING/COMMERCIAL OPERATING BUDGET  - INCOME
 | Project Name:
 |  |  | Date:
 |  |  | County:
ANNUAL Residential Income: |  |  |  |  |  |  |  | Annual Inflation Rate Factor: |  |  |  | 0.02
Rents based on:
Unit [NAME] | Unit Type | # of Baths | Square Feet | Median Income % | Gross Monthly Rent Per Unit |  | Tenant Paid Utility Allow |  | Net Monthly Rent Per Unit |  | Number of Units |  | 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
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
 | Bdr |  |  |  |  | - |  | = |  | X 12 |  | =
SUB-TOTALS |  |  |  |  |  |  |  |  |  |  |  | =
Other Revenue:
Laundry
Parking
Utility Reimbursements
Miscellaneous Fees
Service Income
Other Income
SUB-TOTAL OTHER REVENUE
Gross Income:
Less Vacancy Rate |  |  |  | 0.05
Effective Gross Income (Residential):
Commercial:
ANNUAL Commercial Income (Enter on Comm Income Tab, uses escalator on this tab):
Commercial Income:
TOTAL COMMERCIAL REVENUE
Less Vacancy Rate |  |  |  | 0.1
Effective Gross Income (Commercial):
Effective Gross Income (Total Project):
Spreadsheet: 113377d1309294014-excel-2010-formula-book1
Sheet: Sheet1

 |  |  |  |  |  | Price | Bid | Total Cost | Mtl Cost | Fab | Shop Prime | Galv | HPC | Qty | [NAME] LFT | Sell Size SFT | Wt | Bid Length | [NAME]
Line Item | QTY | Material Description |  |  |  |  |  |  |  |  | PER LB
 |  |  |  |  |  |  |  |  |  |  | 0.15 | 0.25 | 0.4
1.1 | 2 | HSS 4 x 4 x 1/4" x 23'-0" |  |  |  |  |  |  | 0.65 | 0.9 | 0 | 0 | 0.4 |  | 30 |  | 12.21
1.2 | 180 | Plate 1/2" x 12" x 12" |  |  |  |  |  |  | 0.65 | 0.9 | 0 | 0 | 0.4 |  |  |  | 16.21 | 12 | 12
 |  |  |  |  |  | PRICE=SUM(BID*QTY*SELL [NAME] LFT)*WEIGHT
 |  |  |  |  |  | BID=SUM(MTL COST+FAB+SHOP PRIME+GALV+HPC)
 |  |  |  |  |  | TOTAL COST=SUM(MTL COST+FAB+SHOP [NAME])
Spreadsheet: 164643d1340825491-vlookup-to-return-value-found-in-1-of-4-columns-to-a-different-column-in-same-row-test-sheet
Sheet: Key

Code | RVU
99201 | 0.48
99202 | 0.93
99203 | 1.42
99204 | 2.43
99205 | 3.17
99241 | 0.64
99242 | 1.34
99243 | 1.88
99244 | 3.02
99245 | 3.77
99211 | 0.18
99212 | 0.48
99213 | 0.97
99214 | 1.5
99215 | 2.11
99354 | 1.77
99406 | 0.24
99407 | 0.5
85060 | 0.45
38220 | 1.08
38221 | 1.37
G0436 | 0.24
G0437 | 0.5
G0179 | 0.45
G0180 | 0.67
G0181 | 1.73
G0182 | 1.73
99221 | 1.92
99222 | 2.61
99223 | 3.86
99231 | 0.76
99232 | 1.39
99233 | 2
99238 | 1.28
99239 | 1.9
99252 | 1.5
99253 | 2.27
99254 | 3.29
99255 | 4
99218 | 1.28
99219 | 2.14
99220 | 2.99
99224 | 0.54
99225 | 0.96
99226 | 1.44
99217 | 1.28
99282 | 0.88
99283 | 1.34
99284 | 2.56
99285 | 3.8
99242 | 1.34
99243 | 1.88
99244 | 3.02
99245 | 3.77
99304 | 1.64
99305 | 2.35
99306 | 3.06
99307 | 0.76
99308 | 1.16
99309 | 1.55
99310 | 2.35
Spreadsheet: 194989d1353386504-how-to-count-cell-values-based-on-2-conditions-example_excel_help
Sheet: El Paso

 | Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Date Shift Vacated |  |  | Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Date Shift Vacated
 | 05:30:00 | 14:00:00 | 1 | 1 |  |  | 1 | 1 | 1 | 2012-08-10 00:00:00 |  |  | 09:00:00 | 18:00:00 | 1 |  |  | 1 | 1 | 1 | 1 | 2012-08-12 00:00:00
 | 09:00:00 | 20:00:00 | 1 | 1 |  | 1 |  |  | 1 | 2012-08-19 00:00:00 |  |  | 06:00:00 | 15:00:00 |  | 1 |  | 1 | 1 | 1 | 1 | 2012-08-11 00:00:00
 | 09:00:00 | 20:00:00 | 1 | 1 |  | 1 |  |  | 1 | 2012-08-22 00:00:00 |  |  | 09:00:00 | 18:00:00 | 1 |  |  | 1 | 1 | 1 | 1 | 2012-08-22 00:00:00
 | 14:15:00 | 23:00:00 |  | 1 | 1 | 1 | 1 |  | 1 | 2012-08-23 00:00:00 |  |  | 14:30:00 | 23:15:00 | 1 | 1 | 1 | 1 |  |  | 1 | 2012-08-28 00:00:00
 | 14:00:00 | 22:45:00 |  | 1 | 1 |  | 1 | 1 | 1 | 2012-08-23 00:00:00 |  |  | 12:00:00 | 20:45:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-06 00:00:00
 | 12:00:00 | 20:45:00 | 1 | 1 | 1 | 1 | 1 |  |  | 2012-08-23 00:00:00 |  |  | 09:00:00 | 18:00:00 | 1 |  |  | 1 | 1 | 1 | 1 | 2012-09-20 00:00:00
 | 11:00:00 | 8:00 OPM | 1 | 1 | 1 |  | 1 | 1 |  | 2012-08-30 00:00:00 |  |  | 11:00:00 | 22:00:00 |  | 1 | 1 |  | 1 | 1 |  | 2012-09-26 00:00:00
 | 09:00:00 | 20:00:00 | 1 | 1 |  | 1 |  |  | 1 | 2012-08-26 00:00:00 |  |  | 04:55:00 | 13:25:00 |  | 1 | 1 | 1 |  | 1 | 1 | 2012-10-13 00:00:00
 | 09:00:00 | 20:00:00 | 1 | 1 |  | 1 |  |  | 1 | 2012-08-26 00:00:00 |  |  | 11:00:00 | 22:00:00 |  | 1 | 1 |  | 1 | 1 |  | 2012-10-16 00:00:00
 | 09:00:00 | 20:00:00 | 1 | 1 |  | 1 |  |  | 1 | 2012-09-02 00:00:00 |  |  | 12:00:00 | 20:45:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-10-18 00:00:00
 | 10:00:00 | 21:00:00 |  | 1 |  |  | 1 | 1 | 1 | 2012-08-31 00:00:00 |  |  | 09:00:00 | 18:00:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-10-26 00:00:00
 | 14:45:00 | 23:15:00 | 1 | 1 | 1 |  |  | 1 | 1 | 2012-09-04 00:00:00 |  |  | 11:00:00 | 22:00:00 |  | 1 | 1 |  | 1 | 1 |  | 2012-10-28 00:00:00
 | 14:00:00 | 22:45:00 |  | 1 | 1 |  | 1 | 1 | 1 | 2012-09-05 00:00:00
 | 04:55:00 | 13:25:00 | 1 | 1 | 1 | 1 |  |  | 1 | 2012-09-07 00:00:00
 | 09:00:00 | 17:45:00 | 1 | 1 |  | 1 | 1 | 1 |  | 2012-08-20 00:00:00
 | 12:30:00 | 21:00:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-08 00:00:00
 | 11:00:00 | 20:00:00 | 1 | 1 | 1 |  | 1 | 1 |  | 2012-09-12 00:00:00
 | 12:30:00 | 21:00:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-06 00:00:00
 | 14:15:00 | 23:00:00 |  | 1 | 1 | 1 | 1 |  | 1 | 2012-09-21 00:00:00
 | 14:45:00 | 23:15:00 |  |  | 1 | 1 | 1 | 1 | 1 | 2012-10-17 00:00:00
 | 07:30:00 | 16:30:00 | 1 | 1 | 1 |  | 1 | 1 |  | 2012-10-17 00:00:00
 | 09:00:00 | 20:00:00 | 1 | 1 |  | 1 |  |  | 1 | 2012-10-26 00:00:00
 | 12:30:00 | 21:00:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-10-29 00:00:00
 | 11:30:00 | 20:15:00 |  |  | 1 | 1 | 1 | 1 | 1 | 2012-10-31 00:00:00
Spreadsheet: 171295d1343678947-call-center-work-force-management-arrival-patterns
Sheet: Campaign 1

 |  | 2012-07-08 00:00:00 | 2012-07-09 00:00:00 | 2012-07-10 00:00:00 | 2012-07-11 00:00:00 | 2012-07-12 00:00:00 | 2012-07-13 00:00:00 | 2012-07-14 00:00:00 | 2012-07-15 00:00:00 | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00 | 2012-07-21 00:00:00 | 2012-07-22 00:00:00 | 2012-07-23 00:00:00 | 2012-07-24 00:00:00 | 2012-07-25 00:00:00 | 2012-07-26 00:00:00 | 2012-07-27 00:00:00 | 2012-07-28 00:00:00 | 2012-07-29 00:00:00 | 2012-07-30 00:00:00 | 2012-07-31 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Totals
 | 00:00:00 |  | 0 |  | 1 |  | 1 | 1 | 3 |  | 1 |  | 1 |  | 4 |  |  | 1 | 4 | 2 |  | 2
 | 01:00:00 |  |  |  |  | 2 |  |  | 2 | 3 |  | 2 |  |  | 1 | 1 |  |  | 2 |  | 1 |  | 2
 | 02:00:00 |  |  |  |  |  |  |  | 4 |  | 2 |  | 1 |  |  |  |  | 2 | 1 |  |  |  | 1
 | 03:00:00 |  |  |  | 2 | 5 |  |  |  | 2 | 1 |  |  |  |  | 2 |  | 1 | 1 |  | 1 |  | 3
 | 04:00:00 |  |  |  | 1 | 1 |  |  | 3 |  |  |  |  | 2 |  |  | 1 |  |  |  | 5
 | 05:00:00 |  |  |  |  | 4 | 2 |  | 4 |  |  |  |  |  | 1 | 2 | 2 |  |  |  | 1 | 1 | 2
 | 06:00:00 |  |  | 1 | 5 |  | 1 | 2 | 4 | 2 |  |  | 3 | 1 |  |  | 5 | 4 | 1 |  |  | 1 | 2
 | 07:00:00 | 4 | 6 | 5 | 3 | 1 | 4 | 2 | 6 | 2 |  | 4 |  | 1 |  | 1 | 6 | 3 |  | 3 | 4 |  | 2
 | 08:00:00 | 5 | 3 | 3 | 12 | 4 | 8 | 3 | 3 | 6 | 1 | 9 | 6 | 2 | 4 | 3 | 4 | 8 | 2 | 9 |  | 4 | 3
 | 09:00:00 | 9 | 8 | 5 | 8 | 1 | 3 | 4 | 3 | 2 | 3 | 6 | 4 | 10 | 6 | 0 | 6 | 7 | 5 | 6 | 7 | 1 | 4
 | 10:00:00 | 7 | 11 | 2 | 6 | 6 | 7 | 2 | 6 | 6 | 4 | 8 | 1 | 10 | 6 | 1 | 8 | 6 | 8 | 11 | 9 | 6 | 3
 | 11:00:00 | 3 | 7 | 5 | 2 | 2 | 6 | 9 | 3 | 7 | 2 | 11 | 4 | 4 | 9 | 2 | 12 | 8 | 3 | 6 | 7 | 6 | 6
 | 12:00:00 | 4 | 8 | 9 | 6 | 4 | 2 | 6 | 7 | 6 | 1 | 2 | 4 | 7 | 6 | 3 | 8 | 6 | 12 | 5 | 6 | 9 | 2
 | 13:00:00 | 7 | 3 | 5 | 3 | 5 | 7 | 2 | 9 | 4 | 6 | 7 | 6 | 8 | 5 | 4 | 3 | 9 | 9 | 7 | 6 | 17 | 2
 | 14:00:00 | 7 | 7 | 5 | 6 | 10 | 8 | 9 | 13 | 3 | 5 | 9 | 5 | 3 | 4 | 2 | 5 | 8 | 7 | 10 | 5 | 16 | 3
 | 15:00:00 | 6 | 7 |  | 5 | 8 | 1 | 2 | 11 | 5 | 8 | 5 | 7 | 8 | 5 | 3 | 9 | 7 | 5 | 5 | 9 | 4 | 4
 | 16:00:00 | 5 | 6 | 1 | 7 | 4 | 4 | 11 | 4 | 7 | 3 | 2 | 8 | 6 | 6 | 4 | 7 | 9 | 7 | 8 | 8 | 5 | 3
 | 17:00:00 | 5 | 8 | 5 | 1 | 6 | 6 | 4 | 3 | 6 | 3 | 3 | 8 | 4 | 3 | 1 | 6 | 5 | 11 | 5 | 3 | 2 | 4
 | 18:00:00 | 0 | 10 | 3 | 2 | 1 | 6 | 9 | 4 | 4 | 4 | 7 | 6 | 2 | 11 | 0 | 8 | 3 | 7 | 2 | 4 | 3 | 3
 | 19:00:00 | 2 | 7 | 8 | 3 | 2 | 4 | 1 | 4 | 3 | 6 | 5 | 3 | 1 | 3 | 2 | 8 | 7 | 2 | 5 | 5 | 4 | 4
 | 20:00:00 | 2 | 10 | 7 | 5 | 5 | 4 | 9 | 3 | 4 | 7 | 6 | 5 | 9 | 4 | 1 | 8 | 9 | 5 | 4 | 4 | 3 | 3
 | 21:00:00 | 5 | 4 | 2 | 4 | 2 |  | 4 | 6 | 1 | 5 | 4 | 3 | 3 | 4 | 3 | 4 | 6 | 6 | 7 | 4 | 1 | 2
 | 22:00:00 | 3 | 2 |  |  | 2 |  | 1 | 0 |  | 4 | 5 | 2 | 3 | 0 | 2 | 5 | 4 | 4 | 3 |  | 2 | 4
 | 23:00:00 | 1 | 0 | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  | 1 | 1 |  |  |  | 1 | 1 | 1 |  | 2
 | Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 833535d1687060343-using-excel-formulas-for-large-data-set-and-dynamic-address-references-example-for-help
Sheet: Sheet4

ENTERED DATA |  |  | ALTERED DATA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
1
 | 2023-03-01 00:00:00
 | Clm Prc
Red
 | 9500
A 20May23 | WO1 | ft
A 04Dec22 | WO1 | ft
A 27Oct22 | WO6 | ft
A 07Oct22 | WO6 | ft
A 25Sep22 | WO3 | ft
[NAME]): | 7 May 23 WO o 5F ft 1:03 Handily 70/78
Trainer (Last 365 days): All:
2
 | 2023-08-01 00:00:00
 | Clm Prc
White
 | 9500
A 20May23 | WO1 | ft
A 30Apr23 | WO2 | ft
A 04Dec22 | WO1 | ft
A 13Nov22 | WO2 | ft
A 27Oct22 | WO6 | ft
A 14Oct22 | WO8 | ft
A 25Sep22 | WO3 | ft
[NAME]): | 13 May 23 WO o 5F ft 1:01.60 Breezing 42/77
Trainer (Last 365 days): All:
3
 | 2023-04-01 00:00:00
 | Clm Prc
Blue
 | 10000
A 20May23 | WO2 | ft
A 25Nov22 | WO5 | ft
A 21Oct22 | WO2 | gd Â¹ 6 Âº
A 02Oct22 | WO3 | ft
[NAME]): | 13 May 23 WO tr 5F ft 1:00.40 Breezing 11/21
Spreadsheet: 110931d1307477768-if-and-variation-repeate-winners
Sheet: Sheet1

 | Name | Year | Finish |  |  |  |  |  |  |  |  |  |  |  |  | Winners | Former Winners
 | [NAME] | 1911
 | [NAME] | 1912 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | W
 | [NAME] | 1914 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FW | FW
 | [NAME] | 1911
 | [NAME] | 1912
 | [NAME] | 1913
 | [NAME] | 1915 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | W
 | [NAME] | 1919 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FW | FW
 | [NAME] | 1920 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FW
 | [NAME] | 1921 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FW
 | [NAME] | 1922 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FW
 | [NAME] | 1923 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FW
 | [NAME] | 1925 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FW
 | [NAME] | 1911
 | [NAME] | 1912
 | [NAME] | 1913
 | [NAME] | 1916
 | [NAME] | 1911 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | W
 | [NAME] | 1912 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FW | FW
 | [NAME] | 1914 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FW
 | [NAME] | 1911 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | W
 | [NAME] | 1911 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | W
 | [NAME] | 1912 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FW | FW
Spreadsheet: 882451d1730834177-changes-to-data-validation-list-entries-breaks-index-match-grant-tracker-2024-design-review-copy
Sheet: GrantsAwarded

Grant/Award Name | Grantor/Funder Name | Assigned To (First Name, Last Name) | Assigned To Email | Program Area | Description | Total [NAME] | Date of Receipt of Funds | Source Type | Start Date | End Date | Progress Report (PR) Frequency | Most Recent PR Due Date | [NAME] | Next Progress Report Due | Progress Reports ↓↓↓↓↓↓↓ | Final Report Due | Grant Renewal Date | Contact First Name | Contact Last Name | [NAME] | Phone | Ext | Address | City | State | Zip | Contact Notes/ Comments | Grantor Contact Info ↓↓↓↓↓↓↓
Actalent (test grant name?)
ADP (placeholder grant name)
Bank of America (grant name?)
Bank of America (grant name?)
Charitable Giving Foundation
Citibank 1 (grant name?)
Citibank 2 (grant name?)
Citibank 3 (grant name?)
Citizens Bank (grant name?)
Dodge Foundation (grant name?)
Hyde & Watson Foundation (grant name?)
LISC  (grant name?)
Lisc - Lowes (grant name?)
M&T Bank (grant name?)
PNC 1 (grant name?)
PNC 2 (grant name?)
Prudential (grant name?)
[NAME] (grant name?)
TD Bank (grant name?)
Turrell Foundation (grant name?)
United Airlines (grant name?)
United Way of Greater Newark (grant name?)
Victoria Foundation (grant name?)
Wells Fargo (grant name?)