tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 786213d1657040388-complex-unique-formula-based-on-multiple-criteria-example-data-formula-sheet
Sheet: Sheet1

ACTUAL DATE | ACTUAL NUMBER |  | REPORTED DATE | REPORTED TOTAL | REPORTED UNIQUE
2022-06-28 00:00:00 | 1234567890 |  |  |  | 4
2022-06-28 00:00:00 | 2345678901 |  | 2022-06-29 00:00:00 |  | 1
2022-06-28 00:00:00 | 3456789012 |  | 2022-06-30 00:00:00 |  | 4
2022-06-28 00:00:00 | 4567890123 |  | 2022-07-01 00:00:00 |  | 2
2022-06-29 00:00:00 | 5678901234 |  | 2022-07-02 00:00:00 |  | 3
2022-06-29 00:00:00 | 2345678901 |  | 2022-07-03 00:00:00 |  | 0
2022-06-30 00:00:00 | 6789012345 |  | 2022-07-04 00:00:00 |  | 4
2022-06-30 00:00:00 | 7890123456 |  | ^ | ^ | ^_Need formula to pull this actual number?
2022-06-30 00:00:00 | 1234567890 |  | ^ | ^
2022-06-30 00:00:00 | 4567890123 |  | ^ | ^_ [NAME] used: "=COUNTA(UNIQUE(FILTER(B:B,A:A=D8)))"
2022-06-30 00:00:00 | 8901234567 |  | ^
2022-06-30 00:00:00 | 9012345678 |  | ^_ [NAME] used: "=UNIQUE(FILTER(A2:A1000,A2:A1000<>""))"
2022-06-30 00:00:00 | 2345678901
2022-06-30 00:00:00 | 9012345678
2022-07-01 00:00:00 | 9876543210 |  | ACTUAL DATE | Reported Total | Reported Unique
2022-07-01 00:00:00 | 8765432109 |  | 2022-06-28 00:00:00 | 4 | 4
2022-07-01 00:00:00 | 8901234567 |  | 2022-06-29 00:00:00 | 2 | 2
2022-07-01 00:00:00 | 6789012345 |  | 2022-06-30 00:00:00 | 8 | 7
2022-07-01 00:00:00 | 1234567890 |  | 2022-07-01 00:00:00 | 5 | 5
2022-07-02 00:00:00 | 7654321098 |  | 2022-07-02 00:00:00 | 4 | 4
2022-07-02 00:00:00 | 6543210987 |  | 2022-07-03 00:00:00 | 1 | 1
2022-07-02 00:00:00 | 5432109876 |  | 2022-07-04 00:00:00 | 9 | 9
2022-07-02 00:00:00 | 9012345678
2022-07-03 00:00:00 | 6789012345
2022-07-04 00:00:00 | 4321098765
2022-07-04 00:00:00 | 3210987654
2022-07-04 00:00:00 | 2345678901
2022-07-04 00:00:00 | 7654321098
2022-07-04 00:00:00 | 6543210987
2022-07-04 00:00:00 | 4567890123
2022-07-04 00:00:00 | 2109876543
2022-07-04 00:00:00 | 1098765432
2022-07-04 00:00:00 | 6789012345
Spreadsheet: 115280d1310922002-if-then-conditional-formatting-with-dates-date-range-example
Sheet: Sheet1

START | END | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00
2011-07-25 00:00:00 | 2011-11-02 00:00:00 | 1 | 1 | 1 | 1 | 1
2011-10-05 00:00:00 | 2012-03-09 00:00:00 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
2011-08-19 00:00:00 | 2012-01-12 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1
2011-09-05 00:00:00 | 2012-03-17 00:00:00 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | TOTAL | 2 | 2 | 4 | 4 | 4 | 3 | 3 | 2 | 2
 |  | Check the C/F
 |  | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1
 |  | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0
 |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 462541d1464092837-bonus-based-on-hours-worked-bonus-for-cumulative-hours-_-for-mblacklock-_-as
Sheet: Sheet1

Week | Hours worked | Cumulative hours | Cumul less bonus hrs | Bonus due?
2010-01-01 00:00:00 | 40
 | 37.5
 | 37.5
 | 37.5
 | 40
 | 35
 | 37.5
 | 30
 | 30
 | 40
 | 32.5
 | 37.5
 | 27.5
 | 27.5
 | 37.5
Spreadsheet: 101336d1299494909-excel-2007-cross-referencing-tables-testb
Sheet: Customers

 | Package 1 | Package 2 | Package 3 | Package 4 | Package 5 | Package 6 | Package 7 | Package 8 | Package 9
Customer 1 | 1 |  | 1 | 1 |  | 1 | 1
Customer 2 | 1
Customer 3 |  | 1 | 1 |  |  |  |  | 1
Customer 4 |  |  |  |  |  |  | 1 | 1
Customer 5
Customer 6 |  | 1 |  | 1 |  | 1 |  | 1
Customer 7 | 1 | 1 | 1
Customer 8 |  | 1 | 1 | 1 |  |  |  |  | 1
Customer 9 |  |  |  |  | 1 |  | 1 | 1
Customer 10 |  |  |  |  |  |  | 1 |  | 1
Customer 11 |  | 1 | 1 |  | 1 |  |  | 1
Customer 12 | 1 |  |  | 1 |  | 1 | 1
Customer 13 |  |  |  |  |  |  |  | 1
Customer 14 |  | 1 | 1 |  | 1 |  |  | 1
Spreadsheet: 676315d1588754947-cannot-get-index-match-formula-to-sum-eus_gah
Sheet: Library

Final enrolment | Number of Citations Views | Number of Files Download | Students that Viewed Citation | Students that Downloaded Files | Students that Viewed Full Text |  | Centre Code | ISBN/ISSN etc                     or URL | Publisher Name | Title of Publication | Date of Publication | Title of Work | Author(s) / Creator(s) of work
 |  |  |  |  |  |  | 800 | 00113530 | Current History, Inc. | Current History | 2017 | Trump and the Asia-Pacific: do the ties still bind?(Author abstract) | Beeson, [NAME]
Spreadsheet: 30236755-1152-4c4e-ad84-d76bf0965369
Sheet: 2005

WEST BRANCH MARINA HISTORICAL DATA - 2005
Category |  |  |  |  |  |  |  |  |  |  |  |  | Total | Commission | %
of Revenue | Jan. | Feb. | March | Apr. | May | Jun. | Jul. | Aug. | Sept. | Oct. | Nov. | Dec. | Receipts | Paid | Paid
Rental - Boats & Motors | 0 | 0 | 0 | 0 | 5315.5 | 25190 | 57261.5 | 36657 | 9759.25 | 0 | 0 | 0 | 134183.25 | 7380.080000000001 | 0.055
Marine Equipment Sales | 0 | 0 | 0 | 0 | 415.04 | 3342.39 | 4972.38 | 1429.21 | 392.04 | 0 | 0 | 0 | 10551.06 | 369.28 | 0.035
Bait and Tackle | 0 | 0 | 0 | 0 | 309.45 | 1176.97 | 1225.78 | 523.04 | 246.4 | 0 | 0 | 0 | 3481.64 | 191.49 | 0.055
Gasoline and Oil | 0 | 0 | 0 | 0 | 1192.64 | 9343.9 | 19812.18 | 12916.97 | 5757.75 | 0 | 0 | 0 | 49023.44 | 0 | 0
Food and Beverage | 0 | 0 | 0 | 0 | 1305.4 | 7723.54 | 11118.84 | 5314.59 | 1301.59 | 0 | 0 | 0 | 26763.96 | 0 | 0
Vending | 0 | 0 | 0 | 0 | 0 | 390 | 530 | 320 | 50 | 0 | 0 | 0 | 1290 | 64.5 | 0.05
Transient Dockage | 0 | 0 | 0 | 0 | 0 | 795 | 750 | 210 | 60 | 0 | 0 | 0 | 1815 | 453.75 | 0.25
Souvenirs and Sundries | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.06
All Other Receipts | 0 | 0 | 0 | 0 | 63.04 | 46.52 | 181.11 | 142.41 | 0 | 0 | 0 | 0 | 433.08 | 17.32 | 0.04
Totals | 0 | 0 | 0 | 0 | 8601.070000000002 | 48008.32 | 95851.79 | 57513.22 | 17567.03 | 0 | 0 | 0 | 227541.43 | 8476.42
Spreadsheet: 126383d1319659658-spreadsheet-with-multi-formulae-help-stock-control
Sheet: MONTHLY COST

MONTHLY EXPENSES SHEET PER VEHICLE OCTOBER 2011
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
TOTALS PER VEHICLE
MONTHLY EXPENSES SHEET PER VEHICLE NOVEMBER 2011
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE DECEMBER 2011
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE JANUARY 2012
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE FEBRUARY 2012
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
MONTHLY EXPENSES SHEET PER VEHICLE MARCH 2012
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS
ADHESIVE
DEGREASER
SINGLE EDGED BLADES
STANLEY BLADES
LONG BLADES
TISSUE ROLL
CUTTING GLOVES
RUBBER GLOVES
Spreadsheet: 415851d1440630828-how-to-build-auto-fill-calendar-on-excel-excel-calendar
Sheet: Sheet1

 | 1 | 2 | 3 | 2 | 1 | 0 | 1
 |  |  |  |  |  |  |  |  | Date | Event
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | 2015-03-08 00:00:00 | Get Groceries
 |  |  |  |  |  |  | 2015-01-08 00:00:00 |  | 2015-03-08 00:00:00 | Get camping ticket
 |  |  |  |  |  |  |  |  | 07/20/2015 | Pick berries
 |  |  |  |  |  |  |  |  | 08/15/2015 | Do laundry
 |  |  |  |  |  |  |  |  | 08/15/2015 | Get water
 |  |  |  |  |  |  |  |  | 08/15/2015 | Eat chicken
 | 2015-02-08 00:00:00 | 2015-03-08 00:00:00 | 2015-04-08 00:00:00 | 2015-05-08 00:00:00 | 2015-06-08 00:00:00 | 2015-07-08 00:00:00 | 2015-08-08 00:00:00 |  | 08/15/2015 | Sleep
 |  |  |  |  |  |  |  |  | 08/17/2015 | Pay electric bill
 |  |  |  |  |  |  |  |  | 08/19/2015 | Give [NAME] money back
 |  |  |  |  |  |  |  |  | [NAME] | Pay rent
 |  |  |  |  |  |  |  |  | 08/30/2015 | Watch TV
 | 2015-09-08 00:00:00 | 2015-10-08 00:00:00 | 2015-11-08 00:00:00 | 2015-12-08 00:00:00 | 08/13/2015 | 08/14/2015 | 08/15/2015
 | 08/16/2015 | 08/17/2015 | 08/18/2015 | 08/19/2015 | [NAME] | 08/21/2015 | 08/22/2015
 | 08/21/2015 | 08/22/2015 | 08/23/2015 | 08/24/2015 | 08/25/2015 | 08/26/2015 | 08/27/2015
 | 08/28/2015 | 08/29/2015 | 08/30/2015 | 08/31/2015
Spreadsheet: mark_haedicke__24600__105655 - O&M 053101
Sheet: Headcount - 105656

 | ENRON NORTH AMERICA
 | CC 105656
 | HEADCOUNT AS OF 05-31-01
EMPLOYEE |  |  | TOTAL
BLAINE, MICHELLE |  | hOther Non-Commercial | 1
BROWNFELD, [NAME] |  | hOther Non-Commercial | 1
EDISON, ANDREW |  | hOther Non-Commercial | 1
[NAME],[NAME] |  | hOther Non-Commercial | 1
MERAZ,CLAUDIA |  | hOther Non-Commercial | 1
SANDERS,RICHARD B |  | hOther Non-Commercial | 1
SWEET, TWANDA |  | hOther Non-Commercial | 1
[NAME], STEPHANIE |  | hOther Non-Commercial | 1
Spreadsheet: 127055d1320153184-divide-cell-to-worksheets-then-add-for-check-n-balance-raiders-ledger
Sheet: Emma

Emma
Fall 2011
Date | Description | Check # | Credit | Debit | Balance
9/2011 | Field Rental - September
9/2011 | Tiffany - September
9/2011 | Insurance
Spreadsheet: 709720d1608522308-help-with-ipmt-formulas-for-advance-payments-on-a-loan-amortization-schedule-loan_amortization-2
Sheet: End

Loan Amount
Residual Value
APR
[NAME] (m)
Month |  | Begin Balance | Payment | Interest | Principle | End Balance
1
Spreadsheet: 879723d1727274245-need-help-returning-data-when-cell-matches-column-headers-newtonus_prime-notes-ks-365-aligw
Sheet: TEMPLATE

ACCT | Acct Manager | Due to Pre-Press | Due to Prod | Ship Date | Due In-Store | Promo | Notes
GGPM |  | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
 | [NAME]
SONO CALS |  | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
 | [NAME]
TOFA |  | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
 | [NAME]
 | [NAME]
 | [NAME]
RACT |  | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
 | [NAME]
 | [NAME]
 | Shane Delaney
BASS |  | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
 | Amanda Isackson
 | [NAME]
HHGJ [NAME] |  | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
 | Breezi [NAME]
 | [NAME]
 | [NAME]
HHGJ TMOB |  | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
KNST |  | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
 | [NAME]
Spreadsheet: 67040d1267679592-auto-data-search-and-entry-purchase-report
Sheet: Daily Purchases

 |  |  |  | Daily Purchases
[NAME] |  | Sale |  | VIN |  |  |  | Year | Make |  | Model | Color
 |  |  |  | 2
Mileage | Type | Storage Dealer Name |  | Address 1 |  |  | Address 2 |  | City | State | ZIP | Phone
BSRP |  | Owner |  | Address 1 |  |  | Address 2 |  | City | State | ZIP | Phone
2b
Channel | Purchase Amount | Buy Fee |  | Facilitation Fee | Transport Fee | PSI Fee | Total Purchase Price | Binding ID | Destination |  | ECR
 |  |  |  |  |  |  |  |  | 2a
[NAME] |  | Sale |  | VIN |  |  |  | Year | Make |  | Model | Color
 |  |  |  | 3
Mileage | Type | Storage Dealer Name |  | Address 1 |  |  | Address 2 |  | City | State | ZIP | Phone
BSRP |  | Owner |  | Address 1 |  |  | Address 2 |  | City | State | ZIP | Phone
3b
Channel | Purchase Amount | Buy Fee |  | Facilitation Fee | Transport Fee | PSI Fee | Total Purchase Price | Binding ID | Destination |  | ECR
 |  |  |  |  |  |  |  |  | 3a
[NAME] |  | Sale |  | VIN |  |  |  | Year | Make |  | Model | Color
 |  |  |  | 1
Mileage | Type | Storage Dealer Name |  | Address 1 |  |  | Address 2 |  | City | State | ZIP | Phone
BSRP |  | Owner |  | Address 1 |  |  | Address 2 |  | City | State | ZIP | Phone
1b
Channel | Purchase Amount | Buy Fee |  | Facilitation Fee | Transport Fee | PSI Fee | Total Purchase Price | Binding ID | Destination |  | ECR
 |  |  |  |  |  |  |  |  | 1a
Spreadsheet: 747983d1631812886-trimmean-with-if-statement-bo-backtesting
Sheet: CALCS

TIME (WINNING TRADES)
START | END | TOTAL TIME | ENTRIES | AVE PRICE | TRADED %
08:00:00 | 08:29:00
08:30:00 | 08:59:00
09:00:00 | 09:29:00
09:30:00 | 09:49:00
09:50:00 | 10:29:00
10:30:00 | 11:29:00
11:30:00 | 14:59:00
FED INCOME TAX
Income
Tax Rate
INCOME | RATE
19750 | 0.1
80250 | 0.12
171050 | 0.22
326600 | 0.24
414700 | 0.32
622050 | 0.35
 | 0.37
Spreadsheet: 116899d1312280639-radar-plot-gb-diving-monitoring-and-evaluation-database
Sheet: PROFILE

[NAME] Evaluation
BASIC ANTHROPOMETRY
VARIABLE
[NAME] (KG) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | best
HEIGHT (CM) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDSTAND PRESS-UPS REP MAX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HEADSTAND TIME MAX (S)
TESTS FOR RANGE OF MOTION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRONE STREAMLINE EXTENSION TEST - (S)
TEST | BEST |  |  |  |  |  | RATING |  |  |  |  |  |  | RATING | GOAL FOR NEXT |  |  | BENCHMARK |  |  |  | SUPINE STREAMLINE EXTENSION TEST - (S)
COMBINED SHOULDER/ THORACIC TEST (CM) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIDE STREAMLINE EXTENSION TEST ([NAME]) - (S)
SHOULDER PASSIVE ROM TEST (˚) | L |  |  | R |  |  |  | L |  |  | R |  |  |  |  |  |  |  |  |  |  | SIDE STREAMLINE EXTENSION TEST (RIGHT) - (S)
HAMSTRING LENGTH TEST (˚) | L |  |  | R |  |  |  | L |  |  | R |  |  |  |  |  |  |  |  |  |  | HAMSTRING BRIDGE REP MAX - LEFT
MODIFIED THOMAS TEST (˚) - HA/HE/KF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HAMSTRING BRIDGE REP MAX - RIGHT
[NAME] TO WALL TEST | L |  |  | R |  |  |  | L |  |  | R |  |  |  |  |  |  |  |  |  |  | CALF RAISE REP MAX - LEFT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALF RAISE REP MAX - RIGHT
CONDITIONING ASSESSMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOUBLE LEG LOWER REP MAX
TEST | BEST |  |  |  |  |  | RATING |  |  |  |  |  |  | RATING | GOAL FOR NEXT |  |  | BENCHMARK
HANDSTAND PRESS-UPS REP MAX
HEADSTAND TIME MAX (S)
PRONE STREAMLINE EXTENSION TEST - (S)
SUPINE STREAMLINE EXTENSION TEST - (S)
SIDE STREAMLINE EXTENSION TEST ([NAME]) - (S)
SIDE STREAMLINE EXTENSION TEST (RIGHT) - (S)
HAMSTRING BRIDGE REP MAX - LEFT
HAMSTRING BRIDGE REP MAX - RIGHT
CALF RAISE REP MAX - LEFT
CALF RAISE REP MAX - RIGHT
DOUBLE LEG LOWER REP MAX
MOVEMENT ASSESSMENTS/ FMS
TEST | BEST |  |  |  |  |  | RATING |  |  |  |  |  |  | RATING | GOAL FOR NEXT |  |  | BENCHMARK
OVERHEAD SQUAT
HURDLE STEP | L |  |  | R |  |  |  | L |  |  | R
BOUND AND HOLD | L |  |  | R |  |  |  | L |  |  | R
SKINFOLD TESTING
SITE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHANGE |  |  | GOAL FOR NEXT
Tricep SF (mm)
Subscapulare SF (mm)
Biceps SF (mm)
Illiac Crest SF (mm)
Supraspinale SF (mm)
Abdominal SF (mm)
Front Thigh SF (mm)
Medial Calf SF (mm)
SUM OF 8 (mm)
GENERAL COMMENTS
Spreadsheet: 146632d1332275668-excel-2007-need-help-with-formula-sgtnnis
Sheet: fresh plant

Room 20 |  |  |  |  |  |  | Room 21
Empire |  |  | Romes |  |  |  | Empire
Receiver # | # of boxes | # of boxes transfer | Receiver # | # of boxes | # of boxes transfer |  | Receiver # | # of boxes | # of boxes transfer | Receiver # | # of boxes | # of boxes transfer
 |  |  |  |  |  |  |  |  |  |  |  |  |  | The receiver numbers came from the march page, but for room 20 I need
 |  |  |  |  |  |  |  |  |  |  |  |  |  | them to go to either empires or romes depending on which column they are in
 |  |  |  |  |  |  |  |  |  |  |  |  |  | on the march page.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | When I enter in a receiver number on the march page I want it to transfer to the
 |  |  |  |  |  |  |  |  |  |  |  |  |  | room which in this case is 20 and then depending on the variety transfer to the
 |  |  |  |  |  |  |  |  |  |  |  |  |  | column that is for them(empire or romes)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Right now I can get them to transfer to the room but I need them to sort by variety
 |  |  |  |  |  |  |  |  |  |  |  |  |  | too.
Total | 842 | 0 | Total | 567 | 553 |  | Total | 842 | 0 | Total | 567 | 553
Spreadsheet: 683465d1592752284-count-and-lookup-help-for-a-leaderboard-scrabble-data
Sheet: Leaderboard

Name | Played | Points
[NAME] | =SUMPRODUCT(COUNTIF(INDIRECT(Week1:Week2,A2))) |  | Played Week 1 and scored 3
[NAME]
Bec
Cara
[NAME]
[NAME]
Debbie
Gemma P
Gemma S
G
Georgina
Heather
[NAME]
[NAME]
[NAME]
Jon
[NAME] |  |  | Didn’t play week 1 but has in week 2
[NAME]
Julie B & Louise |  |  | Didn’t play week 1 so should be zero, will play in week 2
[NAME]
[NAME]
L & D |  |  | Scored 2 in week 1
[NAME]
[NAME]
Mandi
Mandy
[NAME]
[NAME]
Nicki
[NAME]
Roberta
Sandra
Stephen |  |  | How do I add his points for week 2
Sue
[NAME]
[NAME]
Spreadsheet: 161524d1339535964-dates-calulations-between-rows-work-log-logbook
Sheet: In Field OR Closed

 |  |  | Work Package Logbook
Package Number | Number |  | [NAME] | Date Approved | Date Closed | Revision | Planner | Status | Action | Days
 | CNS-FWP-0XXXX |  | Description A | 2010-03-05 00:00:00 | 2010-06-21 00:00:00 |  | Veal | Closed
 | CNS-FWP-0XXXX |  | Description A | 2010-05-17 00:00:00 |  |  | Reed | Open
 | CNS-FWP-0XXXX |  | Description A | 2010-06-07 00:00:00 |  |  | Carusone | Open
 | CNS-FWP-0XXXX |  | Description A | 2010-05-27 00:00:00 |  |  | Bannister | Open
 | CNS-FWP-0XXXX |  | Description A | 2010-05-10 00:00:00 | 2011-05-23 00:00:00 |  | Bannister | Closed
 | CNS-FWP-0XXXX |  | Description A | 06-30-10 | 2011-09-19 00:00:00 |  | Reed | Open
 | CNS-FWP-0XXXX |  | Description A | 07-16-10 | 2010-08-05 00:00:00 |  | Dinger | Open
 | CNS-FWP-0XXXX |  | Description A | 2010-09-07 00:00:00 |  |  | Hastings | Open
 | CNS-FWP-0XXXX |  | Description A | 2011-01-20 00:00:00 |  |  | Ciullo | Open
 | CNS-FWP-0XXXX |  | Description A | 2010-11-09 00:00:00 | 2011-01-25 00:00:00 |  | Gross | Closed
 | CNS-FWP-0XXXX |  | Description A | 2010-10-14 00:00:00 | 2011-05-16 00:00:00 |  | Hastings | Closed
 | CNS-FWP-0XXXX |  | Description A | 2010-10-14 00:00:00 |  |  | Reed | Open
 | CNS-FWP-0XXXX |  | Description A | 2010-10-10 00:00:00 | 2011-12-09 00:00:00 |  | Reed | Closed
 | CNS-FWP-0XXXX |  | Description A | 2010-10-23 00:00:00 | 2010-11-05 00:00:00 |  | Reed | Closed
 | CNS-FWP-0XXXX |  | Description A | 2010-10-22 00:00:00 | 2011-12-08 00:00:00 |  | Hastings | Closed
 | CNS-FWP-0XXXX |  | Description A | 2010-10-23 00:00:00 | 2011-05-24 00:00:00 |  | Reed | Closed
 | CNS-FWP-0XXXX |  | Description A | 2010-07-06 00:00:00 | 2010-08-31 00:00:00 |  | Reed | Closed
 | CNS-FWP-0XXXX |  | Description A | 2010-11-03 00:00:00 |  |  | Reed | Open
 | CNS-FWP-0XXXX |  | Description A | 2010-12-01 00:00:00 | 2011-01-05 00:00:00 |  | Reed | Closed
 | CNS-FWP-0XXXX |  | Description A | 2010-10-14 00:00:00 |  |  | Reed | Open
Spreadsheet: 853163d1703083311-need-help-with-formula-within-formula-for-subtotal-count-bok1
Sheet: Blad1

 |  | Table of Data |  |  |  |  | Summary
 | Year | Agreement | Group | Ref |  | Year | Nr of Agreements | Where Ref >= 50 | Where Ref < 50 |  | Year | Nr of Agreements | Sum<=50 | Sum>50
 | 2021 | KAP-KL | Group3 | 50 |  | 2021 |  | [NAME]? | [NAME]? |  | 2021 | 9 | 250 | 103
 | 2021 | PTR | Group3 | 0 |  | 2022 |  | [NAME]? | [NAME]? |  | 2022 | 12 | 350 | 205
 | 2021 | AKAP-KL | Group3 | 50 |  | 2023 |  | [NAME]? | [NAME]? |  | 2023 | 2 | 50
 | 2021 | AKAP-KL | Group3 | 50
 | 2021 | KAP-KL | Group3 | 52
 | 2021 | AKAP-KL | Group3 | 51
 | 2021 | PTR | Group3 | 0
 | 2021 | AKAP-KL | Group3 | 50
 | 2021 | AKAP-KL | Group3 | 50
 | 2022 | AKAP-KL | Group2 | 50
 | 2022 | AKAP-KL | Group2 | 50
 | 2022 | KAP-KL | Group2 | 50
 | 2022 | AKAP-KL | Group2 | 50
 | 2022 | KAP-KL | Group2 | 51
 | 2022 | AKAP-KL | Group2 | 52
 | 2022 | AKAP-KL | Group2 | 51
 | 2022 | AKAP-KL | Group2 | 51
 | 2022 | AKAP-KL | Group2 | 50
 | 2022 | KAP-KL | Group2 | 50
 | 2022 | PTR | Group2 | 0
 | 2022 | AKAP-KL | Group2 | 50
 | 2023 | PTR | Group1 | 0
 | 2023 | KAP-KL | Group1 | 50
Spreadsheet: 093532a8-0569-45ce-b52e-45010cfeeb5c
Sheet: 4.2(SS) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(SS): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | SS - Social Science
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 19 | 42 | 1 | 8
 |  | Part Time | 9 | 26 | 1 | 2
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | 1 | 3 | 0 | 0
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
 | [NAME]. graduated with a GPA of 3.0 or above |  | 0 | 1 | 0 | 0
Bachelor's Degree |  |  | 0 | 3 | 1 | 0
 | [NAME]. graduates admitted to graduate school |  | 0 | 0 | 0 | 0
 | [NAME]. graduated with a GPA of 3.0 or above |  | 0 | 2 | 1 | 0
Master's Degree |  |  | na | na | na | na
Employed after graduation |  |  | m | m | m | m
Notes:
na = not offered; m = not tracked;
Spreadsheet: bc7629f0-a18c-4e72-8805-77ffee0e19c0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-08-19 09:39:24.610000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.561 | 101.436 | 101.311 | 100.936 |  | and are added to price quote
4.75 | 101.082 | 100.957 | 100.832 | 100.457
4.625 | 100.364 | 100.239 | 100.114 | 99.739 |  | Note: | Refer To Price [NAME]
4.5 | 99.473 | 99.348 | 99.223 | 98.848 |  |  | For all Price Adjs
4.375 | 98.542 | 98.417 | 98.292 | 97.667
4.25 | 97.73 | 97.605 | 97.48 | 96.855
4.125 | 96.94 | 96.815 | 96.69 | 96.065
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.016 | 101.891 | 101.766 | 101.391
3.875 | 101.301 | 101.176 | 101.051 | 100.676
3.75 | 100.768 | 100.643 | 100.518 | 100.143
3.625 | 100.391 | 100.266 | 100.141 | 99.766
3.5 | 99.845 | 99.72 | 99.595 | 98.97
3.375 | 99.124 | 98.999 | 98.874 | 98.249
3.25 | 98.351 | 98.226 | 98.101 | 97.476 |  | Minimum loan amount:
3.125 | 97.216 | 97.091 | 96.966 | 96.341 |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-09-02 09:39:24.610000
30 DAY | 2013-09-17 09:39:24.610000
45 DAY | 2013-10-02 09:39:24.610000
60 DAY | 2013-10-17 09:39:24.610000
90 DAY | 2013-11-16 09:39:24.610000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.