tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: brad_mckay__1422__Wk 15 Results 
Sheet: Sheet2

Teams |  | Team #5 | Pts. | TM |  | Team #6 | Pts. | TM |  | Team #7 | Pts. | TM |  | Team #8 | Pts. | TM
 |  | [NAME] |  |  |  | [NAME] |  |  |  | Kook/Todd |  |  |  | [NAME]
QB's | X | Beuerlein | 4 | Car | X | Culpepper | 7.5 | Minn |  | [NAME] |  | NO |  | [NAME] |  | NE
 |  | Fielder |  | [NAME] |  | B. Griese |  | Den | X | [NAME] | 0 | Buf | X | [NAME] | 11 | SF
Rec | X | Mason | 1 | [NAME] | X | T. Holt | 6 | STL | X | [NAME] | 0 | Buf | X | [NAME] | 0 | Indy
 | X | Schroeder | 0 | GB |  | [NAME] |  | NE | X | [NAME] | 1 | NE | X | [NAME] | 0 | STL
 | X | [NAME] | 3 | Balt | X | [NAME] | 0 | [NAME] |  | [NAME] |  | [NAME] | X | [NAME] | 0 | TB
 |  | [NAME] |  | Car | X | [NAME] | 1 | Den | X | [NAME] | 3 | NO |  | [NAME] |  | Oak
 |  | McKnight |  | Dal |  | [NAME] |  | [NAME] |  | [NAME] |  | Atl |  | D. Ward |  | Jets
RB's | X | M. Faulk | 9 | StL | X | [NAME] | 1 | Wash | X | [NAME] | 5 | [NAME] |  | [NAME] |  | GB
 |  | [NAME] |  | [NAME] | X | [NAME] | 0 | Minn |  | [NAME] |  | Dal |  | [NAME] |  | Car
 |  | Beasley |  | SF |  | R.Anderson |  | Jets | X | A. Green | 7 | GB | X | [NAME] | 2 | TB
 | X | [NAME] | 2 | [NAME] |  | Fazande |  | SD |  | [NAME] |  | Balt | X | Richardson | 2 | KC
Rookies | X | [NAME] | 0 | NYG | X | [NAME] | 4.5 | Dal |  | [NAME] |  | [NAME] |  | [NAME] |  | Pitt
 |  | Prentice |  | Clev |  | [NAME] |  | NE | X | [NAME] | 6 | Den | X | Pennington | 1 | Jets
Kickers |  | Daluiso |  | NYG |  | Longwell |  | GB | X | J. Elam | 2 | Den | X | Gramatica | 5.25 | TB
 | X | D. Akers | 1.25 | [NAME] |  | [NAME] | 0.25 | Jets |  | Del Greco |  | [NAME] |  | [NAME] |  | NE
Defense | X | Kansas City | 2 |  |  | New Orleans |  |  | X | Pittsburgh | 0 |  | X | Seattle | 2
 |  | N.Y. Jets |  |  | X | Miami | 2 |  |  | Atlanta |  |  |  | Carolina
week total
golden toe
 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Spreadsheet: 725298d1616609635-currency-conversion-problem-conversion
Sheet: Sheet1

 | Division | Name | Level | Amount (in local currency) | currency | Amount in USD | Budget in USD
 | A | Kamay Holdings Ltd | 1 | 1600 | GBP |  | 2700
 | B | Mobile Marketing Group, MMGRP Limited. | 2 | 1500 | USD |  | 1600
 | C | protorrent.co.uk | 3 | 2900 | EUR |  | 4000
 | D | West Hotel | 3 | 8050 | ILS |  | 2100
 | E | [NAME] | 2 | 1600 | USD |  | 1700
 | D | Axonn Media Ltd | 3 | 3000 | USD |  | 3200
 | E | Amsalem | 1 | 4000 | ILS |  | 1100
 | B | Bellini Baskets | 2 | 2500 | GBP |  | 4200
 | A | RANK DIGITAL LTD | 3 | 4800 | GBP |  | 8100
 | D | CITADEL COMMERCE UK LIMITED | 3 | 8000 | ILS |  | 2100
 | A | CENTER HOTEL | 2 | 1000 | GBP |  | 1700
 | C | Games OS | 1 | 4000 | ILS |  | 1000
 | E | Cybersource | 2 | 1500 | EUR |  | 1900
 | A | Digital Envoy - Digital Element | 2 | 800 | EUR |  | 1000
 | D | Digital Corner | 2 | 6100 | ILS |  | 1400
 | B | [NAME] | 1 | 1500 | USD |  | 1400
 | A | Business raptors ltd | 1 | 1050 | USD |  | 1000
 | D | Eurocity Ltd | 1 | 4700 | ILS |  | 1100
 | E | GB Group | 1 | 1000 | USD |  | 1000
 | E | [NAME] | 3 | 3000 | GBP |  | 4600
 | B | Hemscott | 2 | 1800 | USD |  | 1700
 | Total
Spreadsheet: 732664d1621129185-possible-vlookup-function-trying-to-search-through-multiple-sheets-summary-v4
Sheet: 011

Crew and Equipment |  |  |  |  |  |  |  |  |  |  |  |  | Production
DATE | CREW NUMBERS | Crew mumbers | Crew Sup Days | Crew Sup OT HOURS | Camp Sup Days | Camp Sup OT Hours | CCV DAYS (C01) | CCV Miles (C01) | Support Vehicle DAYS | Support Vehicle Miles | Additional Saws | Chipper Days | FUEL REDUCTION ACRES | [NAME] | [NAME] | [NAME]
2021-05-04 00:00:00 | 4012 | 9 | 1 | 0 | 0 | 0 | 1 | 42 | 0 | 0 | 0 | 0 | 2
 | Plant Sage Brush
2021-05-06 00:00:00 | 4012 | 10 | 1 | 0 | 0 | 0 | 1 | 42 | 0 | 0 | 0 | 0 | 2
 | Plant Sage Brush
TOTALS |  | 49 | 5 | 0 | 0 | 0 | 5 | 210 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0
Spreadsheet: 146082d1331891358-converting-hours-minutes-seconds-and-milliseconds-book1_ag65
Sheet: Sheet1

hh:[NAME]:ss:ms | Seconds (Rounded) |  | 1 millisecond = 0.001 seconds
00:01:54:23 | 114
00:00:49:59 | 49
00:01:20:06 | 80
00:01:21:13 | 81
00:02:02:46 | 122
00:02:03:30 | 123
[NAME] | 135
00:04:24:18 | 264
00:02:21:48 | 141
00:01:41:38 | 101
00:00:25:66 | 25
00:02:04:48 | 124
00:01:49:01 | 109
Spreadsheet: 0da39b64-26a0-4941-85a9-ef619a9e6a9e
Sheet: Exhibit XVIII, Page 3

Owners Forms
USAA-GIC
Pennsylvania
Catastrophe & Total Loss History
Accident Year | Catastrophe Incurred Losses | Total Incurred Losses
1993-06-30 00:00:00 | 0 | 0
1994-06-30 00:00:00 | 0 | 0
1995-06-30 00:00:00 | 0 | 0
1996-06-30 00:00:00 | 0 | 0
1997-06-30 00:00:00 | 0 | 0
1998-06-30 00:00:00 | 0 | 0
1999-06-30 00:00:00 | 0 | 0
2000-06-30 00:00:00 | 0 | 0
2001-06-30 00:00:00 | 0 | 0
2002-06-30 00:00:00 | 0 | 0
2003-06-30 00:00:00 | 0 | 0
2004-06-30 00:00:00 | 0 | 0
2005-06-30 00:00:00 | 0 | 0
2006-06-30 00:00:00 | 0 | 0
2007-06-30 00:00:00 | 0 | 788
2008-06-30 00:00:00 | 9108 | 25195
2009-06-30 00:00:00 | 5144 | 479165
2010-06-30 00:00:00 | 134210 | 603044
2011-06-30 00:00:00 | 210275 | 918399
2012-06-30 00:00:00 | 580343 | 3711647
Spreadsheet: 851901d1702031042-change-the-color-of-a-cell-in-a-sheet-based-on-another-cell-that-is-in-a-different-tab-book1-etaf-2-
Sheet: Cabin Alocation

EDT  JANE      CABIN ALLOCATION
C | 600 |  |  | 603 |  |  | 604 |  |  | 605 |  |  | 608 |  |  | 609 |  |  | 610 |  |  | The E3 cell in the cabin allocation tab (which takes data from the cabin list tab, specifically the position on the ship, in this case the chief officer) should light up
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to a specific color depending on what shift (shift in the cabin list tab) will be assigned to it in the cabin list tab.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Depending on the time (4 in total to choose from: 1200-2400, 2400-1200, 0600-1800, 1800-0600), I would like to have cells with positions on the ship in the cabin allocation tab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to be colored in a selected color after entering the shift time hour in the shift (cabin list) column.
B | 502                                             503 |  |  |  |  |  | 504 |  |  | 505 |  |  | 530 |  |  | 531 |  |  | 532
 | 533 (W) |  |  | 534  (W) |  |  | 535  (W) |  |  | 536  (W) |  |  | 537  (W) |  |  | 538  (W) |  |  | 539
A | 430 |  |  | 431 |  |  | 432 |  |  | 433  (W) |  |  | 434  (W) |  |  | 435 |  |  | 437
 | 438  (W) |  |  | 439 |  |  | 401 |  |  | 402 |  |  | 403 |  |  | 404 |  |  | 405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLOAT
 |  |  | d
 | 406 |  |  | 407 |  |  | 408 |  |  | 409 |  |  | 410 |  |  |  | 12:00-24:00 |  | 00:00-12:00 | temporary
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00-18:00 |  | 18:00-06:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLOAT
 |  | Date: |  | 2023-11-24 00:00:00 |  |  | MARINE CREW |  |  |  |  |  | CHARTERERS |  |  |  |  | TOTAL : | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FREE BEDS:
Spreadsheet: 6baf7bf6-45bb-4db3-a9f6-6d09cc7dff53
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Financial Forecast Template
 | Notes and major healthwarnings
 | Users use this template at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read.
 | ----------------------
 | Where possible we have tried to provide explanatory notes, but if you do not understand something please note that we cannot and will not respond to individual queries regarding the template.
 | ----------------------
 | If you do spot a mistake in the template, please let us know and we will try to fix it (although we may not respond to your email).
 | ----------------------
 | Please note that this is a fairly advanced spreadsheet and is only of use to those with proficient spreadsheeting skills.
 | ----------------------
 | Please note that the spreadsheet assumes some accounting knowledge.
 | ----------------------
 | Spreadsheeting is a matter of personal preference and there are often many ways of solving a problem. If you don't particularly like our ways then…er...sorry.
 | ----------------------
 | Each business is different and it can be difficult to adapt a template for your business. In that case, simply use the template as a reference for your own forecast.
 | ----------------------
 | You should always, always, manually check your draft forecast to check for formula and other mistakes. Don't let a third party discover your mistakes, it can damage your credibility.
 | ----------------------
 | If the prospect of preparing a financial forecast is all too much for you and you need professoinal help, then please contact us using the contact details on our website, www.envestors.co.uk.
Spreadsheet: 862623d1710300719-formula-for-cost-projection-sauna-room-cost-analysis-jt-
Sheet: Sheet1 (2)

Date | Job | Invoice | [NAME] | Cost/CF | Labor Charge | Est. [NAME] | Est Cost/CF | LINEST |  | Lower | Upper | Est. Cost
2023-08-02 00:00:00 |  | 29519.79 | 210.16 |  |  | 200
2023-07-26 00:00:00 |  | 27468.29 | 255.21
2023-05-01 00:00:00 |  | 28037.76 | 258
2023-07-25 00:00:00 |  | 29507.06 | 262.41
2023-02-13 00:00:00 |  | 39398.8 | 347.11
2024-03-04 00:00:00 |  | 36025.2 | 384
2023-07-03 00:00:00 |  | 45995.26 | 488.2
2023-02-23 00:00:00 |  | 45199.38 | 504
2023-09-06 00:00:00 |  | 47966.41 | 515.38
2024-03-01 00:00:00 |  | 48159.44 | 519.34
2023-02-24 00:00:00 |  | 49713.13 | 595
2023-09-06 00:00:00 |  | 53378.45 | 651.9
2024-02-01 00:00:00 |  | 59984.39 | 780.17
2024-02-01 00:00:00 |  | 60081.37 | 785.33
2023-10-16 00:00:00 |  | 56362.89 | 864.78
2024-03-27 00:00:00 |  | 71191.23 | 922.37 |  |  |  |  |  |  |  | Slope (a) | Y-Intercept (b)
2024-02-26 00:00:00 |  | 63151.85 | 1056.47 |  |  |  |  |  |  | LINEST
2023-06-13 00:00:00 |  | 57585.37 | 1115.28 |  |  |  |  |  |  | y=ax+b
2023-03-13 00:00:00 |  | 100679.25 | 1408
Spreadsheet: 817622d1676363743-formula-needed-to-calculate-values-for-nulls-between-values-example
Sheet: Sheet1

1 |  | 1
 |  | 1.25
 |  | 1.5
 |  | 1.75
2 |  | 2
 |  | 2.67
 |  | 3.33
4 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
4 |  | 4
 |  | 3.8
 |  | 3.6
 |  | 3.4
 |  | 3.2
3 |  | 3
 |  | 2.33
 |  | 1.67
Spreadsheet: 118763d1313999134-excel-2007-vlookup-return-multiple-values-swap-tracker
Sheet: Swap Info

 |  | Agent 1 | Date | Agent 2 | Date
 |  | BOUNDAOUI, MOHAMMED | 2011-09-24 00:00:00 | COULIBALY, AMADOU | 2011-09-25 00:00:00
 |  | GHAZALI, MAHDI | 2011-09-25 00:00:00 | KANSAYE, SEYDOU | 2011-09-26 00:00:00
 |  | NAWALAGUEMBA, YAMEOGO THEOPHANE | 2011-09-26 00:00:00 | LAIHEM, RABAH | 2011-09-27 00:00:00
 |  | NAWALAGUEMBA, YAMEOGO THEOPHANE | 2011-09-27 00:00:00 | HENRY, JUNIOR | 2011-09-28 00:00:00
 |  | OSSETÉ, CEDRIC JOHAN | 2011-09-28 00:00:00 | RAMOUL, KAMEL | 2011-09-29 00:00:00
 |  | [NAME], ZIZINA | 2011-09-29 00:00:00 | MECHID, MOKRANE | 2011-09-30 00:00:00
 |  | [NAME], ZIZINA | 2011-09-30 00:00:00 | [NAME], JEFFREY | 2011-10-01 00:00:00
 |  | BOUNDAOUI, MOHAMMED | 2011-09-24 00:00:00 | SAYAD, ILYAS | 2011-09-26 00:00:00
Spreadsheet: darrell_schoolcraft__7760__imbalsumm0105
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -62004 | -55369
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -3280111 | -3537584
58710 | -20439 | -2052
60921 | 1191558 | 1425613
78026 | 106655 | 83134
500084 | -21493 | -27000
500085 | -24286
500097
INDEX
2001-04-30 00:00:00 |  |  | 609435.99
2001-05-31 00:00:00
Spreadsheet: 678185d1589760264-can-i-create-a-conditional-formatting-formula-and-remove-the-reference-i-have-conditionalformattingsample
Sheet: sample

 | Sheet1 |  | Sheet1 Table1 |  |  |  |  |  | Sheet2 Table1
 | hidden column |  | Credit Card Debt | Balance | Payment Amount | Due Date |  |  | Priority | Creditors in Chosen Order | Original Balance | Total Interest Paid | Months to Pay Off | hidden column
 |  |  | text1 | 100 | 1 | 2020-06-02 00:00:00 |  |  | 1 | [NAME] |  | 20 | 3 | 1
 |  |  | text2 | 200 | 2 | 2020-06-06 00:00:00 |  |  | 2 | text2 |  | 10 | 5 | 2
 |  |  | text3 | 300 | 3 | 2020-06-06 00:00:00 |  |  | 3 | [NAME] |  | 5 | 16 | 3
 |  |  | text4 | 400 | 4 | 2020-06-07 00:00:00 |  |  | 4 | text4 |  | 0 | 9 | 4
 |  |  | text5 | 500 | 5 | 2020-06-14 00:00:00 |  |  | 5 | text5 |  | 0 | 16 | 5
 |  |  | text6 | 600 | 6 | 2020-06-15 00:00:00 |  |  | 6 | text7 |  | 0 | 0 | 6
 |  |  | text7 | 0 | 7 | 2020-06-16 00:00:00 |  |  | 7 | text10 |  | 0 | 6 | 7
 |  |  | [NAME] | 800 | 8 | 2020-05-21 00:00:00 |  |  | 8 | text3 |  | 0 | 7 | 8
 |  |  | [NAME] | 900 | 9 | 2020-05-24 00:00:00 |  |  | 9 | text6 |  | 0 | 6 | 9
 |  |  | text10 | 1000 | 10 | 2020-05-26 00:00:00 |  |  | 10 | text1 |  | 0 | 1 | 10
 | Sheet1 hidden column was created to easily provide a reference point for the conditional formatting (if priority = 1, then red
 | Is there a way to elimiate the need for sheet1's hidden column and use Sheet2's Priority column instead?
 | Aso, if I can eliminate Sheet2 hidden column that would be nice, but not necessary.
 |  |  | Sheet1 Table1 |  |  |  |  |  | Sheet2 Table1
 |  |  | Credit Card Debt | Balance | Payment Amount | Due Date |  |  | Priority | Creditors in Chosen Order | Original Balance | Total Interest Paid | Months to Pay Off
 |  |  | text1 | 100 | 1 | 2020-06-02 00:00:00 |  |  | 1 | [NAME] |  | 20 | 3
 |  |  | text2 | 200 | 2 | 2020-06-06 00:00:00 |  |  | 2 | text2 |  | 10 | 5
 |  |  | text3 | 300 | 3 | 2020-06-06 00:00:00 |  |  | 3 | [NAME] |  | 5 | 16
 |  |  | text4 | 400 | 4 | 2020-06-07 00:00:00 |  |  | 4 | text4 |  | 0 | 9
 |  |  | text5 | 500 | 5 | 2020-06-14 00:00:00 |  |  | 5 | text5 |  | 0 | 16
 |  |  | text6 | 600 | 6 | 2020-06-15 00:00:00 |  |  | 6 | text7 |  | 0 | 0
 |  |  | text7 | 0 | 7 | 2020-06-16 00:00:00 |  |  | 7 | text10 |  | 0 | 6
 |  |  | [NAME] | 800 | 8 | 2020-05-21 00:00:00 |  |  | 8 | text3 |  | 0 | 7
 |  |  | [NAME] | 900 | 9 | 2020-05-24 00:00:00 |  |  | 9 | text6 |  | 0 | 6
 |  |  | text10 | 1000 | 10 | 2020-05-26 00:00:00 |  |  | 10 | text1 |  | 0 | 1
Spreadsheet: 62117d1263028781-overtime-2010
Sheet: Holidays

 | Date |  | Holiday
 | 2010-01-18 00:00:00 | True
 | 2010-04-02 00:00:00 | True | Good Friday
 | 2010-05-31 00:00:00 | True
 | 2010-07-05 00:00:00 | True | 4th of July
 | 2010-09-06 00:00:00 | True
 | 2010-11-02 00:00:00 | True
 | 2010-11-15 00:00:00 | True
 | 2010-11-25 00:00:00 | True
 | 2010-11-26 00:00:00 | True
 | 2010-12-24 00:00:00 | True | Xmas/New Years
 | 2010-12-27 00:00:00 | True
 | 2010-12-28 00:00:00 | True
 | 2010-12-29 00:00:00 | True
 | 2010-12-30 00:00:00 | True
 | 2010-12-31 00:00:00 | True
Spreadsheet: 76556c14-4bb9-4f69-b133-d735e577e25a
Sheet: Sheet1

Reason Codes
1 | Travel between the relative home and school, to the extent that school transportation is not provided. |  |  |  |  |  |  |  | Child Person ID
2 | Travel to physical or behavioral health appointments.
3 | Travel for administrative case or judicial review, team meetings, foster parent training or visitations.
4 | Travel for Headstart, summer school, pre-school, summer camp or driver's education class.
5 | Travel for youth sixteen (16) year and older to and from employment or searching for job.
6 | Other: Must be authorized by Department and must have prior Local Office Director approval before
 | the trip, please attach authorization.
Month of Travel
Date | Starting Address (number and street, city, state and ZIP code): |  |  |  | Destination Address (number and street, city, state and ZIP code): |  |  |  |  | Reason Code | [NAME]
Pursuant to the provision and penalties of Indiana Code 5-11-10-1, I hereby certify that the foregoing invoice is just and correct, that the amount claimed is legally due, after allowing all just credits, and that no part of the same has been paid. |  |  |  |  |  |  |  |  | Total Miles Driven
 |  |  |  |  |  |  |  |  | Total Claimable $
I hereby swear and affirm under the penalties of perjury the attached bill contains the actual travel costs provided for the individual(s) listed on such bill.  The dates, destinations, reasons and mileage for travel are true and accurate.  I understand that in submitting this that I am under oath stating and affirming that this travel was provided and fully understand that this may be independently audited and that any discrepancy may be referred to a local prosecutor for criminal prosecution.
Relative Family Name |  |  |  |  | Relative Family Address (number and street, city, state and ZIP code)
Relative Family Email Address |  |  |  |  |  |  |  |  | Relative Family ST Number
Relative Family Signature |  |  |  |  | Relative Family Telephone Number |  |  |  | Date of Signature (month, day, year)
Spreadsheet: 544878d1509083931-reservation-system-reservations
Sheet: During

2017-12-01 00:00:00 | Reservations
 | Cameras | Tripods | Microphones |  |  | CAMERAS | AVAILABILITY |  | TRIPODS | AVAILABILITY |  | MICROPHONES | AVAILABILITY
Select The Item You Want to Reserve | Camera 4 Available | Tripod 4 Available | Microphone 4 Available |  |  | Camera 1 | Available |  | Tripod 1 | Available |  | Microphone 1 | Available
 |  |  |  |  |  | Camera 2 | Not Available |  | [NAME] | Not Available |  | Microphone 2 | Not Available
 |  |  |  |  |  | Camera 3 | Not Available |  | [NAME] | Not Available |  | Microphone 3 | Not Available
 |  |  |  |  |  | Camera 4 | Available |  | [NAME] | Available |  | Microphone 4 | Available
 |  |  |  |  |  | Camera 5 | Available |  | Tripod 5 | Available |  | Microphone 5 | Available
 |  |  |  |  |  | Camera 6 | Available |  | Tripod 6 | Available |  | Microphone 6 | Available
 |  |  |  |  |  | Camera 7 | Not Available |  | [NAME] | Not Available |  | Microphone 7 | Not Available
 |  |  |  |  |  | Camera 8 | Available |  | [NAME] | Available |  | Microphone 8 | Available
 |  |  |  |  |  | Camera 9 | Available |  | Tripod 9 | Available |  | Microphone 9 | Available
Spreadsheet: 605769d1547260464-alphabetize-column-while-moving-associated-data-alphabetize-help-please-1-
Sheet: BrandA

PartnerName
MNO | 853.1860237720916 | 375.6516517005425 | 742.8905068748893 | 465.148505049008 | 713.8785438915487 | 61.9728102575704 | 176.6720359890205
DEF | 120.9278517469567 | 326.2795641754846 | 982.5640059101114 | 671.3332831275872 | 785.8682030187438 | 533.1068395207539 | 101.1056783347081
GHI | 641.6170801163837 | 653.646599590389 | 551.7438109801218 | 343.8804532582721 | 155.7135806007954 | 431.1297379000154 | 159.178495583123
ABC | 884.3186249959682 | 501.4044942031258 | 982.5098472276414 | 114.1533188674195 | 984.0684392464321 | 45.35102421393822 | 631.5246009882793
JKL | 590.7382996083852 | 250.4543678766191 | 321.8514854286025 | 489.2868526651323 | 263.9653577655009 | 687.1787243442819 | 36.76774728769438
Spreadsheet: f3b4111e-3d2b-4a10-8939-a8948f2d706e
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
43366029 | 2014-09-29 17:30:42 | AXIS | 1 | 10 | 6 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43366293 | 2014-09-29 18:00:38 | ALLIES | 1 | 10 | 4 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 173754d1344713586-identifying-dates-that-are-not-included-find-insurance-coverage-gaps
Sheet: Sheet1

Name | Start | End | Comments | Explanation
[NAME] | 2011-07-07 00:00:00 | 2012-07-06 00:00:00 | Gap in coverage | There is a Gap between 7/11/11 and the previous coverage plan which is Row 4 where it ends on 5/11/11
Belden | 2010-01-12 00:00:00 | 2011-01-11 00:00:00 |  | There is a no Gap between 1/12/10 because there is no previous plan year
[NAME] | 2010-05-12 00:00:00 | 2011-05-11 00:00:00 |  | There is a no Gap between 5/12/10 and the previous coverage plan which is Row 7 where it ends on 1/11/12
[NAME] | 2012-07-07 00:00:00 | 2013-07-06 00:00:00 |  | There is a no Gap between 7/7/12 and the previous coverage plan which is Row 2 where it ends on 7/6/12
Belden | 2011-01-12 00:00:00 | 2012-01-11 00:00:00 |  | There is a no Gap between 1/12/11 and the previous coverage plan which is Row 3 where it ends on 1/11/11
[NAME] | 2009-05-12 00:00:00 | 2010-05-11 00:00:00 |  | There is a no Gap between 5/12/09 beacause there is no previous plan year
Belden | 2012-01-19 00:00:00 | 2013-01-18 00:00:00 | Gap in coverage | There is a Gap between 1/19/12 and the previous coverage plan which is Row 6 where it ends on 1/11/12
Sorted version of your data
Belden | 2010-01-12 00:00:00 | 2011-01-11 00:00:00
Belden | 2011-01-12 00:00:00 | 2012-01-11 00:00:00
Belden | 2012-01-19 00:00:00 | 2013-01-18 00:00:00 | Gap in coverage
[NAME] | 2009-05-12 00:00:00 | 2010-05-11 00:00:00
[NAME] | 2010-05-12 00:00:00 | 2011-05-11 00:00:00
[NAME] | 2011-07-07 00:00:00 | 2012-07-06 00:00:00 | Gap in coverage
[NAME] | 2012-07-07 00:00:00 | 2013-07-06 00:00:00
Spreadsheet: 09279f50-ca70-4529-a1b2-2d9bb8cc538b
Sheet: Trail Benefit Analysis

 | Trail Use Based on a 1.5 mile residential draw potential
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  | Population | Percentage of Adults | Total Adult Popoulation | Total Number of Commuters | Number of existing bicycle commuters | Number of new bicycle commuters | Number of existing pedestrain commuters | Total Daily adult cyclists | New daily adult cyclists | Annual Health Benefit | Annual Recreation/ commuter Benefit
 | Population within 400 meters | 3022 | 87.4
 | Population within 401- 800 meters | 4334 | 87.4
 | Population between 801-1600 meters | 6658 | 87.4
 | Population between 1601-2400 meters | 2450 | 87.4 |  |  |  | 0 |  |  | 0
 | Totals
 | 1. Population is from 2010 census overlayed within the City's GIS mapping System to provide population within 1.5 miles of the project site
 | 2. Percentage of adults in the population is from the 2010 census data.
 | 3. Total Adult population within 1.5miles of the project site
 | 4. Number of Commuters estimated at 50% of adults from National averages provided by NCHRP Report 552 page 38
 | 5. Number of existing Bicycle Communters is 5% of the total number of commuters within a 1.5 miles radius of the trail. 5% bicycle commute share is from the 2000 census data - City of Arcata
 | 6. Per the NCHRP Report 552, pg 39, the number of new bicycle commuters are estimated to be 1.93, 1.11 and 0.39 times the current values for residents at 400, 800 and 1600 meters respectively.
 | 7. Number of existing pedestrian commuters is calculated as 17% of the total commute population based on commute share from 2000 census data
 | 8. Total daily adult cyclists is calculated at the moderate rate of (.004 +1.2 x the commute share of 5% x the total adult population)as outlined in the NCHRP Report 552 page 38
 | 9. New daily adult cyclists is calculated to be 1.93, 1.11 and 0.39 times the current values for residents living within 400m, 800m and 1600m respecitively. NCHRP Report 552, pg. 39
 | 10. Annual Health Benefit is calculated as the number of new bicyclists x $128 (the median value per capita costs savings from physical activty of 10 studies per NCHRP Report 552 Appendix E)
 | 11. Annual Recreational/Commuter Benefit is the number of new cyclists (both recreational and commuter) x $10 per day of value x 365 days for recreational use and 260 days for commuter use.