tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 146688d1332314940-how-to-create-a-rule-depending-on-date-periods-rental-guest-stay-calculation-table
Sheet: HB

 | Хармони Хилс Резиденс – 2012 (Тип на настаняване – “HB”)
 | Studio | 2 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 46 |  |  |  | 49 |  |  |  | 55 |  |  |  | 62 |  |  |  | 55 |  |  |  | 49 |  |  |  | 47 |  |  |  | 43 |  |  |  | 48
 | 1-Bedroom Apartment | 2 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 54 |  |  |  | 57 |  |  |  | 64 |  |  |  | 74 |  |  |  | 64 |  |  |  | 57 |  |  |  | 55 |  |  |  | 53 |  |  |  | 56
 | 2-Bedroom Apartment | 4 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 82 |  |  |  | 85 |  |  |  | 94 |  |  |  | 106 |  |  |  | 94 |  |  |  | 85 |  |  |  | 83 |  |  |  | 81 |  |  |  | 88
 | 2-Bedroom Villa | 4 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 86 |  |  |  | 89 |  |  |  | 99 |  |  |  | 117 |  |  |  | 99 |  |  |  | 89 |  |  |  | 87 |  |  |  | 85 |  |  |  | 92
 | 3-Bedroom Villa | 6 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 112 |  |  |  | 117 |  |  |  | 125 |  |  |  | 146 |  |  |  | 125 |  |  |  | 117 |  |  |  | 115 |  |  |  | 108 |  |  |  | 117
Spreadsheet: 145287d1331492042-highlight-entire-row-is-first-cell-is-60-days-older-than-today-need-help-excel-file
Sheet: Sheet1

JOIN | NAME | STATUS/REMARKS
2012-01-01 00:00:00 | ARMSTRONG, [NAME]
2012-01-07 00:00:00 | AVELLANEDA, DANIEL E.
2012-01-10 00:00:00 | BARAJAS JR, GUILLERMO. | COMPLETED
2012-02-01 00:00:00 | ALLAIN, [NAME]
2012-02-18 00:00:00 | GARRETT, TRAVIS P.
2012-02-24 00:00:00 | ALBRIGHT, [NAME]
2012-02-25 00:00:00 | FLORES, [NAME]
2012-03-02 00:00:00 | [NAME], [NAME]
2012-03-05 00:00:00 | ROMEROFERNANDEZ, MAURICIO.
2012-03-06 00:00:00 | [NAME], [NAME]
Spreadsheet: 88360d1288195486-moving-data-to-different-sheets-parsespecial
Sheet: DOHA - SHR

Invoice Num | cdf | Sail Date | 2009-08-12 00:00:00
Vessel | SAGAR | Voyage | 105
14 | 2009-08-12 00:00:00 | [NAME] | SHR | SHR | ABC | DCN | LADER
Invoice Num | ghi | Sail Date | 2009-12-12 00:00:00
Vessel | CASTOR | Voyage | 0018
21 | 2009-12-12 00:00:00 | [NAME] | SHR | SHR | ABC | DCN | EMPTY 1
22 | 2009-12-12 00:00:00 | [NAME] | SHR | SHR | ABC | DCN | EMPTY 2
Invoice Num | jkl | Sail Date | 2009-12-12 00:00:00
Vessel | JEEVAN | Voyage | 265
33 | 2009-12-12 00:00:00 | [NAME] | SHR | SHR | ABC | RFR | LADER
36 | 2009-12-12 00:00:00 | [NAME] | SHR | SHR | ABC | RFR | [NAME]
37 | 2009-12-12 00:00:00 | [NAME] | SHR | SHR | ABC | DCN | [NAME]
Spreadsheet: 266553d1379660808-conditional-formatting-specific-month-from-a-date-range-joeyjee
Sheet: Sheet1

Customer | Start | End | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00
A | 2013-01-01 00:00:00 | 2013-07-31 00:00:00
B | 2013-01-01 00:00:00 | 2013-12-31 00:00:00
C | 2013-02-01 00:00:00 | 2013-11-30 00:00:00
D | 2013-10-01 00:00:00 | 2013-10-31 00:00:00
Spreadsheet: 833396d1686933541-sum-values-each-row-dynamic-arrays-return-spilling-column-sumrow-aligw
Sheet: Feuil1

IGNORE
A | B | C |  | A | B | C |  | total of row, spilling, expected result
0 | 1 | 0 |  |  | 1 | 0 | 1
0 | 1 | 0 |  | 0 | 1 | 0 | 1 | 1
0 | 1 | 1 |  | 0 | 1 | 1 | 2 | 2
1 | 0 | 0 |  | 1 | 0 | 0 | 1 | 1
0 | 1 | 0 |  | 0 | 1 | 0 | 1 | 1
0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
1 | 0 | 0 |  | 1 | 0 | 0 | 1 | 1
1 | 0 | 0 |  | 1 | 0 | 0 | 1 | 1
0 | 0 | 1 |  | 0 | 0 | 1 | 1 | 1
1 | 0 | 1 |  | 1 | 0 | 1 | 2 | 2
Spreadsheet: 804026d1667847828-lookup-names-then-return-names-from-another-column-to-create-another-list-sorted-deals-etaf
Sheet: Deals

SR. | Customer | Contact | [NAME] | DOB | Nationality | Interested In | Remarks
1 | [NAME] | [PHONE] | [EMAIL] | 1993-01-09 00:00:00 | Australian | TV | Sold
2 | Mark | [PHONE] | [EMAIL] | 1979-03-19 00:00:00 | Indian | Mobile | Cancelled
3 | Christian | [PHONE] | [EMAIL] | 1977-01-23 00:00:00 | South African | Accessories | Reviewed
4 | Adam | [PHONE] | [EMAIL] | 1991-08-08 00:00:00 | Swiss | CD Player | Cancelled
5 | Clyde | [PHONE] | [EMAIL] | 1975-07-01 00:00:00 | Dutch | DVD Player | Sold
6 | George | [PHONE] | [EMAIL] | 1982-09-07 00:00:00 | Cambodian | Playstation | Sold
7 | [NAME] | [PHONE] | [EMAIL] | 1983-11-11 00:00:00 | Algerian | X Box | Cancelled
8 | Chloe | [PHONE] | [EMAIL] | 1987-09-12 00:00:00 | British | Gameboy | In Progress
9 | [NAME] | [PHONE] | [EMAIL] | 1990-09-13 00:00:00 | Italian | Laptop | Cancelled
10 | [NAME] | [PHONE] | [EMAIL] | 1976-06-07 00:00:00 | French | AC | In Progress
11 | Open for New
12 | Open for New
13 | Open for New
SR. | Cancelled Customers | Reason | Manager's Feedback
Spreadsheet: 82982d1282989977-if-statements-help-book1
Sheet: Sheet1

 |  |  | 13450 | Total | <-- Advice: Sum at the top
Guest | Cost per Head | Total Cost | Discount
200 | 12.5 | 2500 | 2250 | <--- Advice: No blank row
150 | 10 | 1500 | 1350
500 | 15 | 7500 | 6750
50 | 20 | 1000 | 1000
10 | 15 | 150 | 150
80 | 10 | 800 | 800
Spreadsheet: 28f528d8-27cf-4659-9123-91fea2d15ae8
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: |  |  | 2011-01-11 09:31:04.580000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.5 | 101.5 | 101.375 | 100.875 |  | and are added to price quote
5.125 | 101.346 | 101.346 | 101.221 | 100.721
5 | 101.044 | 101.044 | 100.919 | 100.419 |  | Note: | Refer To Price [NAME]
4.875 | 100.233 | 100.233 | 100.108 | 99.60799999999999 |  |  | For all Price Adjs
4.75 | 99.722 | 99.722 | 99.597
4.625 | 98.74199999999999 | 98.74199999999999 | 98.61699999999999
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.625 | 101.13 | 101.13 | 101.005 | 100.505
4.5 | 100.953 | 100.953 | 100.828 | 100.328
4.375 | 100.721 | 100.721 | 100.596 | 100.096
4.25 | 100.227 | 100.227 | 100.102 | 99.60199999999999
4.125 | 99.01899999999999 | 99.01899999999999 | 98.89399999999999
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | 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: |  |  | 2011-01-11 09:31:04.580000
 |  |  |  |  |  | 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 | 2011-01-25 09:31:04.580000
30 DAY | 2011-02-09 09:31:04.580000
45 DAY | 2011-02-24 09:31:04.580000
60 DAY | 2011-03-11 09:31:04.580000
90 DAY | 2011-04-10 09:31:04.580000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 692445d1598343044-excel-formula-to-calculate-employee-benefits-employee-benefits-3
Sheet: PAYROLL

Date | Period | Employee Code Number | Employee Name | Employee I.D Number | Age | Elderly benefit | Disability benefit | Vehicle Engine Capacity | Motoring Benefit
2020-01-20 00:00:00 | 1 | CA1
2020-01-20 00:00:00 | 1 | CA2
2020-01-20 00:00:00 | 1 | CA3
2020-01-20 00:00:00 | 1 | CA4
2020-01-20 00:00:00 | 1 | CA5
2020-01-20 00:00:00 | 1 | CA6
I am asking for the formula to calculate disiability and motor vehicle benefits
Desired outcome
Date | Period | Employee Code Number | Employee Name | Employee I.D Number | Age | Elderly benefit | Disability benefit | Vehicle Engine Capacity | Motoring Benefit
2020-01-20 00:00:00 | 1 | CA1 |  |  |  | 0 | 720 |  | 1800
2020-01-20 00:00:00 | 1 | CA2 |  |  |  | 720 |  |  | 2400
2020-01-20 00:00:00 | 1 | CA3 |  |  |  | 720 | 720 |  | 4800
2020-01-20 00:00:00 | 1 | CA4 |  |  |  | 0 |  |  | 0
2020-01-20 00:00:00 | 1 | CA5 |  |  |  | 0 |  |  | 0
2020-01-20 00:00:00 | 1 | CA6 |  |  |  | 0 |  |  | 3600
Spreadsheet: 104195d1301846023-inventory-management-master-inventory
Sheet: Master Inventory

Item | Description | Supplier | Unit Cost | Price | Beginning Inventory | Purchases | Sales | Current Inventory
MX270 | Earbuds | Sennheiser | 5.996 | 14.99 | 12
MX370 | Earbuds | Sennheiser | 6.795999999999999 | 16.99 | 24
CX280 | Earbuds | Sennheiser | 19.98 | 49.95 | 14
OMX680 | Earbuds | Sennheiser | 23.98 | 59.95 | 3
MDR-EX300 | Earbuds | Sony | 19.596 | 48.99 | 5
MDR-EX500LP | Earbuds | Sony | 30.51600000000001 | 76.29 | 7
SOMDRNC33 | Earbuds | Sony | 75.99600000000001 | 189.99 | 3
HA-NC100 | Headphones | JVC | 17.4 | 43.5 | 19
HA-NC250 | Headphones | JVC | 41.51600000000001 | 103.79 | 6
BOAEH | Headphones | Bose | 50.38 | 125.95 | 2
BOOEHS2 | Headphones | Bose | 71.98 | 179.95 | 3
BOMOEH | Headphones | Bose | 79.98 | 199.95 | 1
Spreadsheet: 734796d1622491195-lookup-value-in-one-sheet-against-another-along-rows-and-return-another-value-lookup-issue-2-
Sheet: Progress

Test Case ID | [NAME] | [NAME] | [NAME]
TS-01-01
AC074
AC058
TS-01-02
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 718378d1613128634-required-formula-to-generate-leave-register-additional-requirement-sample_leavebook2
Sheet: ResultPeriod

 | Select -- >> | Period From | 2021-02-01 00:00:00 | Period To | 2021-02-15 00:00:00
 | Leave for the Period |  |  | Expected Result
 | Name
 | [NAME] |  |  | 1
 | Micheal
 | [NAME] |  |  | 2
 | Ahmed
 | [NAME]
 | Greg |  |  | 1
 | Micky
 | Trace |  |  | 1
 | Lisy
 | Saraham |  |  | 1
 | Total
Spreadsheet: 188056d1350665234-sort-numbers-that-are-stored-as-text-sortcolumn-modified
Sheet: Sheet1

CopyResults
1x
1x14[NAME]
1x20[NAME]
1x24mm
1x25mm
1x26mm
1x27mm
1x28mm
1x30[NAME]
1x32mm
1x35mm
1x42mm
1x45[NAME]
1-3x14mm
1-4x20mm
1-4x24mm
1-4x25mm
1-4x32mm
1-5x24mm
1-6x24mm
1-6.5x24mm
1-12x30mm
1.1-8x24mm
1.25x20mm
1.25-4x20mm
1.25-4x24mm
1.25-4x32[NAME]
1.25-8x32mm
1.5x16[NAME]
1.5x24mm
1.5-4x20mm
1.5-4.5x20mm
1.5-4.5x32mm
1.5-5x20mm
1.5-5x32mm
1.5-6x40mm
1.5-6x42mm
1.5-6x44[NAME]
1.75-4x24mm
1.75-4x32[NAME]
1.75-5x32mm
1.75-6x32mm
2x20mm
2X30mm
2-6x28mm
2-6x32mm
2-7x28mm
2-7x32mm
2-7x33mm
2-7x35mm
2-7x36mm
2-10x38mm
2-10x42mm
2-10x50mm
2-12x42
2-12x42mm
2.5x20mm
2.5x28mm
2.5x30[NAME]
2.5-7x32mm
2.5-8x32mm
2.5-8x36mm
2.5-10x40mm
2.5-10x42
2.5-10x42mm
2.5-10x44mm
2.5-10x50mm
2.5-10x56mm
2.5-15x56mm
2.5-16x42mm
2.5-16x50mm
2.75x27mm
3x
3x30mm
3x32mm
3-7x20mm
3-9x32mm
3-9x33mm
3-9x38mm
3-9x40mm
3-9x42
3-9x42 mm
3-9x42mm
3-9x50mm
3-9x50mm
3-9x50mm
3-9x52mm
3-10x40mm
3-10x44mm
3-12x32mm
3-12x40mm
3-12x42mm
3-12x44mm
3-12x50mm
3-12x52mm
3-12x56mm
3-15x42mm
3-15x50
3-15x50mm
3-18x44mm
3.25x
3.5x35mm
3.5-10x36mm
3.5-10x40mm
3.5-10x40mm
3.5-10x42mm
3.5-10x44mm
3.5-10x50mm
3.5-10x56mm
3.5-21x50mm
3.5-25x56mm
4x
4x15mm
4x20 [NAME]
4x22mm
[NAME]
[NAME]
4x30[NAME]
4x32[NAME]
4x33mm
[NAME]
4-12x40mm
4-12x42mm
4-12x44mm
4-12x50mm
4-16x40mm
4-16x42mm
4-16x50mm
4-16x50mm
4-16x50mm
4-20x50mm
4.5-14x32mm
4.5-14x40mm
4.5-14x42mm
4.5-14x44mm
4.5-14x50mm
4.5-14x56mm
4.5-18x44mm
4.5-30x50mm
5X36mm
5-15x40mm
5-20x50mm
5.5x50mm
6x32[NAME]
6x36mm
6x42mm
6x48mm
6-12x50mm
6-18x40mm
6-18x44mm
6-18x50mm
6-21x44mm
6-24x40mm
6-24x42mm
6-24x44mm
6-24x50mm
6.20x40mm
6.5-20x40mm
6.5-20x50mm
6.5-20x56mm
7x24mm
8x30mm
8-26x50mm
8-32x40mm
8-32x50mm
8-32x56mm
8.5-25x50mm
8.5-32x50mm
10x40mm
10x42mm
10x50mm
10-30x60mm
10-40X50mm
10-40X56mm
10-50x60mm
12x40mm
12-40x60mm
12.5-7x28mm
16x40mm
20-60x80mm
24x44mm
25x40mm
30x40mm
35x45mm
36x42mm
40x45mm
45x45mm
Spreadsheet: 717064d1612462581-how-to-create-conditional-formatting-based-on-todays-date-and-a-column-book1
Sheet: February

 | YOY | 90674 | 45510 | [NAME]
 | YOY + 20% |  |  | Bench | Pace
 | Pace |  |  | 58000 |  | Highlight F3 based on today's pacing.
 | Date | PAGEVIEWS | USERS | 728x90-1
PACING |  |  |  | Impressions | Clicks
CHART | TOTALS:
 | 2021-02-01 00:00:00 | 4670 | 2176 | 3031 | 7
 | 2021-02-02 00:00:00 | 3995 | 2390 | 2482 | 5
 | 2021-02-03 00:00:00 | 4400 | 2887 | 3122 | 3
 | 2021-02-04 00:00:00
 | 2021-02-05 00:00:00
 | 2021-02-06 00:00:00
 | 2021-02-07 00:00:00
 | 2021-02-08 00:00:00
 | 2021-02-09 00:00:00
 | 2021-02-10 00:00:00
 | 2021-02-11 00:00:00
 | 2021-02-12 00:00:00
 | 2021-02-13 00:00:00
 | 2021-02-14 00:00:00
 | 2021-02-15 00:00:00
 | 2021-02-16 00:00:00
 | 2021-02-17 00:00:00
 | 2021-02-18 00:00:00
 | 2021-02-19 00:00:00
 | 2021-02-21 00:00:00
 | 2021-02-21 00:00:00
 | 2021-02-22 00:00:00
 | 2021-02-23 00:00:00
 | 2021-02-24 00:00:00
 | 2021-02-25 00:00:00
 | 2021-02-26 00:00:00
 | 2021-02-27 00:00:00
 | 2021-02-28 00:00:00
Spreadsheet: 817508d1676289290-display-the-average-of-the-previous-10-games-dynamically-bostoncelticsplayers
Sheet: BOS Total

 | Player | Team | POS | MP | FG | FGA | FG% | 3P | 3PA | 3P% | FT | FTA | ORB | DRB | TRB | AST | STL | BLK | TOV | PF | PTS | GMSC | PM
 | [NAME] | BOS | SG
 | [NAME] | BOS | PF
 | [NAME] | BOS | PF
 | [NAME] | BOS | PF
 | [NAME] | BOS | SF
 | [NAME] | BOS | C
 | [NAME] | BOS | PG
 | [NAME] | BOS | PG
 | [NAME] | BOS | C
 | Payton Pritchard | BOS | PG
 | Blake Griffin | BOS | C
 | [NAME] | BOS | C
 | [NAME] | BOS | PG
 | [NAME] | BOS | PF
 | [NAME] | BOS | C
Spreadsheet: 7c037ed1-e0ea-43b8-933e-292b51bb4384
Sheet: Sheet1

PRESIDENT OF THE UNITED STATES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Libertarian Presidential Primary
1996-02-20 00:00:00
Summary by | Browne, l | Schiff, l | [NAME], r | Buchanan, r
Counties
Belknap | 16 | 19 | 3 | 6
Carroll | 22 | 15 | 1 | 4
Cheshire | 24 | 20 | 4 | 5
Coos | 3 | 4 | 0 | 4
[NAME] | 49 | 16 | 2 | 4
Hillsborough | 240 | 95 | 22 | 49
Merrimack | 47 | 42 | 15 | 19
Rockingham | 185 | 92 | 21 | 71
[NAME] | 53 | 28 | 11 | 12
[NAME] | 14 | 5 | 3 | 2
Totals | 653 | 336 | 82 | 176
Summary by | [NAME], r | Forbes, r | Keyes, r | [NAME], r | [NAME], d | [NAME]**
Counties
Belknap | 3 | 10 | 0 | 2 | 3 | 0
Carroll | 6 | 3 | 0 | 1 | 4 | 0
Cheshire | 2 | 3 | 0 | 0 | 5 | 0
Coos | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 2 | 2 | 0 | 0 | 2 | 1
Hillsborough | 20 | 29 | 5 | 10 | 12 | 39
Merrimack | 8 | 9 | 5 | 1 | 10 | 1
Rockingham | 20 | 39 | 12 | 3 | 18 | 2
[NAME] | 6 | 8 | 3 | 1 | 11 | 0
[NAME] | 0 | 0 | 2 | 1 | 0 | 0
Totals | 67 | 103 | 27 | 19 | 65 | 43
*write-ins
The following candidates received 15 or fewer votes statewide: R: Gramm-1. Lugar-13. D: Chimento-1. Killeen-1.
Write-ins: Nader-12. Kemp-8. Gore-4. Perot-2.
Spreadsheet: 853971d1703928028-found-max-value-but-its-finding-first-value-christmas-comp-23-24-pointscore-fix-error-aligw
Sheet: MysteryWeight

MYSTERY    LENGTH   WINNERS
Bream | [NAME] (mm) | Closest Length (mm) | difference | Age Group | Angler # | [NAME] |  | LOW | HIGH | RANDOM NUMBER GENRATOR
Flathead | [NAME] (mm) | Closest Length (mm) | difference | Age Group | Angler # | [NAME] |  | LOW | HIGH | RANDOM NUMBER GENRATOR
OVERALL BIGGEST FISH WINNERS
Bream |  | Length | Angler # | Name |  |  |  | Press F9 to complete Calculations Check for TIEs!
 | Small Fry
 | Junior
 | High School
Flathead |  | Length | Angler # | Name
 | Small Fry
 | Junior
 | High School
Spreadsheet: 703620d1605087175-copy-different-and-changing-length-lists-from-multiple-sheets-dept-summary-for-questions-ans
Sheet: 2ND DIV

 |  |  |  |  | LAST NAME | FIRST NAME | TYPE 1 | TYPE 2 | TYPE 3 | TYPE 4
 |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
TYPE 1 |  |  |  |  |  |  |  | X
TYPE 2 |  |  |  |  |  |  |  |  |  | X
TYPE 3 |  |  |  |  |  |  |  |  | X
TYPE 4 |  |  |  |  |  |  | X
TOTAL |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  | X
TYPE 2
FIRST NAME | LAST NAME | START | STOP
 |  | 300 | 900
 |  | 1200 | 1400
TYPE 3
 |  | START | STOP
 |  | 6500 | 8500
 |  | 7200 | 9000
Spreadsheet: 887917d1738239997-combining-vlookups-on-multiple-sheets-book2-bytemarks-
Sheet: Two B

 | DEF-one |  |  | 3
 | DEF-two |  |  | 1
 | DEF-three |  |  | 5
 | DEF-four |  |  | 1
 | DEF-five |  |  | 3
 | DEF-six |  |  | 1
 | DEF-seven |  |  | 4
 | DEF-eight |  |  | 1
 | DEF-nine |  |  | 1
 | DEF-ten |  |  | 1
Spreadsheet: 57224d1257352532-automatic-updates-linked-sources-not-updating-test-partners
Sheet: 1

Agent | Mortgage-4
Banker1
Banker2
Banker3
Participating Agents
Spreadsheet: 08453559-78fa-4519-a58d-fe57fafa857d
Sheet: J-Hooks, LV-1s

 | J Hooks, LV-1
UOM | [NAME] | PART NUMBER | PRICE
EA | CAT 12 J-Hook w/wire hanger (box of 100) | JP75DW-L20 | 211.88
EA | CAT 12 J-Hook w/screw mount clip | CAT12CLP | 5.05
EA | CAT 12 J-Hook Hammer (box of 100) | CATHP24 | 132.49
EA | CAT 21 J-Hook (hook only) | CAT32HP | 189.92
EA | CAT 21 J-Hook w/wire hanger (box of 100) | JP75DW-L20 | 211.88
EA | CAT 21 J-Hook Hammer (box of 100) | JP75HBC25R-L20 | 298.19
EA | CAT 32 J-Hook (hook only) | CAT32 | 3.34
EA | CAT 32 bat wing wire hangers only | CAT324Z34 | 4.38
EA | CAT 32 slam-ins only | CAT324Z35 | 7.43
EA | CAT 32 J-Hook w/wire hanger (box of 100) | JP2DW-L20 | 329.67
EA | CAT 32 J-Hook Hammer (box of 100) | CAT32HP | 189.58
EA | CAT 32 J-Hook (no hanger?) (box of 100) | CAT32 | 382.12
EA | CAT 64 J-Hook w/wire hanger (box of 100) | CAT64HP | 722.14
EA | CAT 64 J-Hook (no hanger) (box of 100) | CAT64 | 724.38
EA | Beam clamps | BC | 1.08
EA | Bridal rings | 4BRT32-CAD | 1.54
EA | Single Gang Low Voltage Ring (box of 100) | MP1 | 182.95
Spreadsheet: 255a70be-bb04-48b1-aa06-a0560bc21e02
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42879575 | 2014-08-25 21:22:39 | AXIS | 0 | 3 | 5 | 706682 | emmanuelf | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42879937 | 2014-08-25 21:47:05 | ALLIES | 1 | 5 | 1 | 706682 | emmanuelf | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42882220 | 2014-08-26 00:13:18 | AXIS | 0 | 2 | 4 | 1620864 | diallo79 | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42882484 | 2014-08-26 00:34:30 | ALLIES | 0 | 2 | 4 | 1620864 | diallo79 | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42903878 | 2014-08-27 15:40:53 | AXIS | 0 | 3 | 4 | 464498 | gizzzmo | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42904098 | 2014-08-27 16:01:29 | ALLIES | 1 | 4 | 2 | 464498 | gizzzmo | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42905989 | 2014-08-27 19:20:52 | ALLIES | 1 | 5 | 4 | 1622302 | [NAME] | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42916488 | 2014-08-28 13:42:38 | AXIS | 1 | 4 | 1 | 464498 | gizzzmo | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42916637 | 2014-08-28 14:11:24 | ALLIES | 0 | 3 | 4 | 464498 | gizzzmo | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42918798 | 2014-08-28 18:34:21 | AXIS | 1 | 10 | 7 | 1507591 | darckjester | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42919426 | 2014-08-28 19:02:00 | ALLIES | 1 | 10 | 5 | 1507591 | darckjester | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42920687 | 2014-08-28 20:28:50 | AXIS | 0 | 1 | 4 | 1605687 | [NAME] | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42920796 | 2014-08-28 20:59:37 | ALLIES | 1 | 4 | 1 | 1605687 | [NAME] | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42937192 | 2014-08-30 00:30:01 | ALLIES | 1 | 6 | 0 | 1351059 | misterfunny | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
42937473 | 2014-08-30 00:50:42 | AXIS | 1 | 6 | 4 | 1351059 | misterfunny | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
42937856 | 2014-08-30 01:26:02 | AXIS | 1 | 4 | 3 | 1599805 | player1599805 | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42938001 | 2014-08-30 01:43:26 | ALLIES | 1 | 4 | 1 | 1599805 | player1599805 | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42938328 | 2014-08-30 02:33:10 | ALLIES | 1 | 6 | 4 | 1546936 | KATANA PAPA | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42938589 | 2014-08-30 03:10:37 | AXIS | 0 | 4 | 6 | 1546936 | KATANA PAPA | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
Spreadsheet: jonathan_mckay__16926__Area Managers
Sheet: South Fish

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | South Fish Creek Recreation Complex Ass. |  |  |  | Deal Date: | 2001-05-23 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 1498 | 0
 | February | 1298 | 0
 | March | 950 | 0
 | April | 653 | 0
 | May | 467 | 0
 | June | 416 | 0
 | July | 276 | 0
 | August | 256 | 0
 | September | 404 | 0
 | October | 599 | 0
 | November | 984 | 0
 | December | 1146 | 0
 | TOTAL:
Spreadsheet: 40197d1238513274-list-book1_mar31
Sheet: Sheet2

320 PLUS PARK BLVD NASHVILLE TN 37217-1001 | 320 PLUS PARK BLVD | NASHVILLE | TN | 37217-1001
806 TWIN CITY AVE [NAME] | 806 TWIN CITY AVE | SPRINGDALE | AR | 72764-7083
1415 MURFREESBORO RD NASHVILLE TN 37217 | 1415 MURFREESBORO RD | NASHVILLE | TN | 37217
300 WILMOT RD DEERFIELD IL 60015-4600 | 300 WILMOT RD | DEERFIELD | IL | 60015-4600
4325 AMNICOLA HWY CHATTANOOGA TN 37406-1014 | 4325 AMNICOLA HWY | [NAME] | TN | 37406-1014
2505 WEST PARWAY DRIVE RUSSELLVILLE AR 72801 | 2505 WEST PARWAY DRIVE | RUSSELLVILLE | AR | 72801
675 PONCE DE LEON AVE NE ATLANTA GA 30308-1829 | 675 PONCE DE LEON AVE NE | ATLANTA | GA | 30308-1829
2035 N COLLEGE AVE FAYETTEVILLE AR 72703-2613 | 2035 N COLLEGE AVE | FAYETTEVILLE | AR | 72703-2613
PO BOX 45009 SALT LAKE CTY UT 84145-0009 | PO BOX 45009 SALT LAKE | CTY | UT | 84145-0009
Spreadsheet: 838662d1691232425-maximum-drawdown-in-percentage-max-dd-solved
Sheet: Sheet1

Total R2 | [NAME] DD%
-0.005
-0.01
0
0.01
0.02
0.015
0.025
0.045
0.03
0.02
0.01
-0.05
-0.03
-0.09