tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 858470d1707149275-count-blocks-of-numbers-numbers-in-range
Sheet: Sheet1

SAMP 1 |  |  |  |  |  | SAMP 2 |  |  |  |  |  | SAMP 3 |  |  |  |  |  | SAMP 4
UNITS | 155 | POINTS | TOTAL | TOT PTS |  | UNITS | 84 | POINTS | TOTAL | TOT PTS |  | UNITS | 51 | POINTS | TOTAL | TOT PTS |  | UNITS | 12 | POINTS | TOTAL | TOT PTS
 | 0-20 | 5 | 20 | 100 |  |  | 0-20 | 5 | 20 | 100 |  |  | 0-20 | 5 | 20 | 100 |  |  | 0-20 | 5 | 12 | 60
 | 21-40 | 10 | 20 | 200 |  |  | 21-40 | 10 | 20 | 200 |  |  | 21-40 | 10 | 20 | 200 |  |  | 21-40 | 10 | 0 | 0
 | 41-80 | 15 | 40 | 600 |  |  | 41-80 | 15 | 40 | 600 |  |  | 41-80 | 15 | 11 | 165 |  |  | 41-80 | 15 | 0 | 0
 | 81-100 | 20 | 20 | 400 |  |  | 81-100 | 20 | 4 | 80 |  |  | 81-100 | 20 | 0 | 0 |  |  | 81-100 | 20 | 0 | 0
 | >100 | 25 | 55 | 1375 |  |  | >100 | 25 | 0 | 0 |  |  | >100 | 25 | 0 | 0 |  |  | >100 | 25 | 0 | 0
Spreadsheet: 4a525a5b-1324-42e9-9d35-1bb080d104a1
Sheet: Sheet1

Food Insecurity by Year, Maine, 1999-2010 | Unnamed: 1 | Unnamed: 2
Year | Households Reporting Food Insecurity*
 | Average % | 90% Margin of Error
1999-2001 | 9.4 | ±1.07
2002-2004 | 9.8 | ±0.97
2005-2007 | 13.3 | ±1.49
2008-2010 | 15.4 | [NAME]
US 2008-2010 | 14.6 | ±0.23
* "Food insecure—At times during the year, these households were uncertain of having, or unable to acquire, enough food to meet the needs of all their members because they had insufficient money or other resources for food. Food-insecure households include those with low food security and very low food security."  (Source: http://www.ers.usda.gov/briefing/foodsecurity/stats_graphs.htm, accessed 4/18/12)
Note:  Food insecurity data are not available by demographic groups for Maine.
Data Sources:  Economic Research Service, U.S. Department of Agriculture.   Household Food Security in the United States, 2001 (http://www.ers.usda.gov/publications/fanrr29/fanrr29.pdf, accessed 4/18/12),  Household Food Security in the United States, 2004 (http://www.ers.usda.gov/publications/err11/err11.pdf, accessed 4/18/12),  Household Food Security in the United States, 2007 (http://www.ers.usda.gov/Publications/ERR66/ERR66.pdf, accessed 4/18/12), and  Household Food Security in the United States in 2010 (http://www.ers.usda.gov/Publications/ERR125/ERR125.pdf, accessed 4/18/12).
Spreadsheet: 788425d1658471362-find-particular-value-in-cell-after-a-certain-cell-value-example
Sheet: FRL

FRL
SALES PER EMPLOYEE
- Factory | -2.437961379310345 | -1.232678571428571 | -3.148943076923078 | -2.682687692307692 | -0.282624 | -2.4243936 | -5.508445 | -0.006135000000000002 | -7.210175 | 1.7466288 | -3.796889999999999 | -1.376235
- Fixed Support | -35.35044 | -17.2575 | -40.93626 | -34.87494 | -3.5328 | -30.30492 | -66.10134 | -0.07362000000000002 | -86.52210000000001 | 21.83286 | -45.56267999999999 | -16.51482
- Total Sales Per Employee | -2.280673548387097 | -1.1505 | -2.924018571428572 | -2.491067142857143 | -0.2616888888888889 | -2.244808888888889 | -5.084718461538461 | -0.005663076923076924 | -6.655546153846155 | 1.617248888888889 | -3.504821538461538 | -1.270370769230769
INVESTMENT
- Depreciation | 6.913789999999999 | 6.91374 | 6.815060000000001 | 6.96769 | 6.96786 | 6.968019999999999 | 6.967569999999999 | 6.96779 | 6.96788 | 6.88034 | 6.88029 | 7.334629999999999
Percent To Sales | -1.173471673902786 | -2.403734028683181 | -0.9988787446630445 | -1.198744427947403 | -11.83400135869565 | -1.379581929270891 | -0.6324443649705134 | -567.8720456397716 | -0.4831977032457603 | 1.890821449869601 | -0.9060428403245815 | -2.664744756527773
- Capital Spending (INPUT DATA)
Spreadsheet: 96616d1295978180-skip-weekend-days-on-production-roster-roster
Sheet: What it's doing

 | FFS Operator
 | Manual Operator
 | [NAME]
 | [NAME] (FFS Assist,  Forkhoist)
 | Office, Loading
 | 2nd Shift FFS Operator
 | 2nd [NAME] (FFS Assist,  Forkhoist)
 | 2nd Shift Manual Operator
 | Days for Production
 |  |  | hrs per day | target | bgs per day
 | Production Hours |  | 9 | 190
 |  |  | 9 | 50
 |  |  | 9 | 3
 |  |  |  |  |  |  |  |  |  |  | FFS Operator | Kalanga
 |  |  |  |  |  |  |  |  |  |  | Manual/Bulk Bags | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Forklift/Floater | Paea/Colin
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Temp
 |  |  |  |  |  |  |  |  |  |  | Office | Paea/Colin
 |  |  |  |  |  |  |  |  |  |  | PGTS | [NAME]
 |  |  |  |  |  |  |  |  |  |  | PGTS | Temp
Spreadsheet: 56839d1256946395-linking-sheets-pipeline-template-weeks
Sheet: Ranges

Status | L&G | MC |  | BHI |  | Month |  | week
Active | 0 | 0 | 0 | 0 | 0 | Jan |  | 1
Complete | 1 | One | 250 | BC | 340 | Feb |  | 2
Decline | 2 | Two | 500 | B | 170 | Mar |  | 3
Gone Off | 3 | Three | 750 | C | 170 | Apr |  | 4
 | 4 | Four | 1000 |  |  | May |  | 5
 | 5 |  |  |  |  | Jun |  | 6
 | 6 |  |  |  |  | Jul |  | 7
 | 7 |  |  |  |  | Aug |  | 8
 | 8 |  |  |  |  | Sep |  | 9
 | 9 |  |  |  |  | Oct |  | 10
 |  |  |  |  |  | Nov |  | 11
 |  |  |  |  |  | Dec |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  | 52
Spreadsheet: 867760d1714556125-i-am-trying-to-pull-data-from-a-cell-based-on-another-cells-value-beginner-help-forum-test-sheet-v2-worksheet
Sheet: MHC - Paste Sheet

OUTLET | TEXT | START TIME | TOWN | MINUTES DW / TIPPING | [NAME] | TEXT3 | RETURN TIME | REG | PASTE BOX | Column1
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
 | - |  |  |  | [NAME] | -
Spreadsheet: 723756d1615883549-conditional-formatting-for-dates-within-certain-number-of-days-book1-26-ans
Sheet: Data2

Plan End Date | Cell A minus 90 days
2022-01-14 00:00:00 |  |  |  |  |  | =[NAME]<>"")
2022-02-22 00:00:00
2021-12-24 00:00:00
2021-09-03 00:00:00
2021-06-21 00:00:00
2021-06-01 00:00:00 |  | Cell A Colour should change
2021-06-05 00:00:00 |  | Cell A Colour should change
2021-04-11 00:00:00 |  | Cell A Colour should change
2021-11-30 00:00:00
2021-06-09 00:00:00 |  | Cell A Colour should change
2021-05-27 00:00:00 |  | Cell A Colour should change
2021-05-21 00:00:00 |  | Cell A Colour should change
2022-05-28 00:00:00
2021-07-10 00:00:00 |  | Cell A Colour should change
2024-02-28 00:00:00
2021-03-26 00:00:00 |  | Cell A Colour should change
2021-07-23 00:00:00
2022-02-02 00:00:00
2021-05-20 00:00:00 |  | Cell A Colour should change
2021-05-07 00:00:00 |  | Cell A Colour should change
2022-06-02 00:00:00
2021-12-11 00:00:00
2021-12-24 00:00:00
2021-09-07 00:00:00
2022-02-03 00:00:00
2021-10-08 00:00:00
2021-10-15 00:00:00
Spreadsheet: 50568d1250020852-multiple-lookup-book4
Sheet: July

 |  |  |  |  | [NAME] WITH MATCHING "X" ON TAB |  |  |  |  | [NAME] WITH MATCHING "X" ON TAB
 |  |  |  |  | MATRIX WITH [NAME] (COLUMN B) |  |  |  |  | MATRIX WITH [NAME] (COLUMN B)
 |  |  |  |  | AND THE LABOR RESULT HERE |  |  |  |  | AND THE OH RESULT HERE
 |  |  |  |  | Labor | Labor | Labor | Labor |  | OH | OH | OH | OH
Sku | Description | Qty | Ext Labor | Ext OH | Label | Glue | Box | Tape |  | Label | Glue | Box | Tape
100 | FS 8x8 | 85 | 109.65 | 946.9000000000001 | 109.65 |  |  |  |  | 946.9
200 | FS 8x9 | 23 | 57.73 | 442.0599999999999 |  |  | 57.73 |  |  |  |  | 442.06
300 | FS 8x10 | 44 | 179.52 | 1303.72 |  | 179.52 |  |  |  |  | 1303.72
400 | FS 8x11 | 9 | 12.96 | 103.41 | 12.96 |  |  |  |  | 103.41
500 | FS 8x12 | 32 | 53.12 | 415.36 |  | 53.12 |  |  |  |  | 415.36
600 | FS 8x13 | 20 | 47 | 350.2 |  | 47 |  |  |  |  | 350.2
700 | FS 8x14 | 18 | 48.42 | 356.58 |  |  | 48.42 |  |  |  |  | 356.58
800 | FS 8x15 | 17 | 26.86 | 211.31 |  |  |  | 26.86 |  |  |  |  | 211.31
900 | FS 8x16 | 19 | 37.62 | 286.33 | 37.62 |  |  |  |  | 286.33
111 | FS 8x17 | 22 | 50.82 | 380.6 |  |  |  | 50.82 |  |  |  |  | 380.6
222 | FS 8x18 | 93 | 279 | 2030.19 |  |  | 279 |  |  |  |  | 2030.19
Spreadsheet: 771369d1646645763-select-conditional-data-from-a-table-select-conditional-data-from-a-table-rev-001
Sheet: Sheet2

 |  |  | Desired result:All SerialNumber and Remark where Info is Good. Does not need to be a table |  |  | Actual Results
 |  |  |  | Burger |  |  | Burger
 |  |  |  | Pizza |  |  | Pizza |  |  | Burger
 |  |  |  |  |  |  |  |  | 166 | Pizza
Spreadsheet: john_griffith__15727__10_15_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 60 | 325 | 410 | 39.1 | 49.4 | 1.67 | 2001-10-15 10:28:00
 | [NAME] | 61 | 710 | 800 | 42.7 | 48.1 | 1.74 | 2001-10-15 10:28:00
 | HU F2 | 62 | 880 | 980 | 40.4 | 45 | 1.66 | 2001-10-15 10:28:00
 | HU G2 | 63 | 980 | 1100 | 36.8 | 41.3 | 1.55 | 2001-10-15 10:28:00
 | [NAME] | 64 | 1100 | 1250 | 36.3 | 41.2 | 1.56 | 2001-10-15 10:28:00
 | [NAME] | 70 | 1275 | 1425 | 35.1 | 39.2 | 1.63 | 2001-10-15 10:28:00
 | [NAME] | 71 | 1350 | 1500 | 33.7 | 37.4 | 1.59 | 2001-10-15 10:28:00
 | [NAME] | 70 | 1400 | 1600 | 32.8 | 37.6 | 1.55 | 2001-10-15 10:28:00
 | HU N2 |  |  |  | 34.7 | 38.1 | 1.58 | 2001-10-12 14:55:00
 | [NAME] |  |  |  | 28.9 | 34.2 | 1.39 | 2001-10-04 14:29:00
 | HU U2 |  |  |  |  |  | 0.05 | 2001-09-06 10:39:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 861702d1709566127-correlating-values-that-appear-most-often-to-a-value-in-a-column-book1
Sheet: All users and group memberships

JobTitile | Group 1 | Group 2 | Group 3 | Group 4 | Group 5 | Group 6 | Group 7 | Group 8 | Group 9 | Group 10
Accountant | A | B | C | D | E | F | G | H | Y | Z
Administrator | A | D
Administrator | A | E | Z
Report builder | F | G | Y
Report builder | G | Y
Administrator | D | E | Y
Accountant | A | C | D
Report builder | H | Y | Z
Report builder | H | Y
Result:
JobTitle | Top 75% groups
Accountant | A, C, D
Report builder | H, G, Y
Administrator | A, D, E
Number of occurances of each Group (A, B, C,..) is calculated per JobTitle, and only those occuring at least 75% for a JobTitile are selected.
Spreadsheet: 782846d1654330674-help-need-to-remove-multiple-nested-if-statements-timesheet
Sheet: Summary

TIME CARD
Month: | April | SELECT Month from Dropdown
Year: | 2022 | Change Month to Current Year
ACME |  | Person A | Person B | Person C | Person D
Day | Date | Hours Worked | Hours Worked | Hours Worked | Hours Worked
Total Employee Work Hours
Employee Signature
Approver's Signature |  |  | KEY TEAM TOTAL HOUR
Spreadsheet: 09a481de-c859-4833-84a2-322c78a138c5
Sheet: Sheet1

a | 10000 | (to river) (ft)
S | 0.005
T | 5000 | ft^2/day
4T/S
sdf
t (days) | River_a
10
Spreadsheet: 01ed928d-5fe4-486b-ad2f-e95a46266d9b
Sheet: monographs productivity stats

Monographs Productivity Statistics FY10 and FY11
COLLECTION METRICS
 | FY10 | FY11 | % change
Monograph volumes withdrawn | 728 | 317
Monograph volumes added (total) | 11532 | 10670
Firm orders | 3507 | 3901
Standing orders | 218 | 151
Approval plan | 3908 | 3715
Gifts | 3899 | 2903
Media added | 218 | 289
PRODUCTIVITY METRICS
 | FY10 | FY11 | % change
ACQUISITIONS
Requests searched | 5096 | 4737
Duplicates returned | 291 | 322
Titles ordered | 3965 | 3746
Approvals returned | 56 | 12
Invoices processed | 698 | 684
Order records created | N/A | 7529 | N/A
COPY CATALOGING
LC Copy | 6591 | 6562
Edited Copy | 944 | 3743
Original | N/A | 352 | N/A
Sent to Cataloging | 1343 | 338
Items deleted from HELIN | N/A | 314 | N/A
INVENTORY
Barcodes scanned | 0 | 26470 | N/A
HELIN corrections | 0 | 669 | N/A
Items recovered | 0 | 98 | N/A
No barcodes | 0 | 21 | N/A
No item record | 0 | 273 | N/A
Search cards sent to Circ | 0 | 148 | N/A
Other (new labels) | 0 | 198 | N/A
Spreadsheet: mark_taylor__24689__More Ref Creds 22 Feb 2000
Sheet: Sheet1

 | Name | Industry | S&P | Country
 | AMR Corp. | Airlines | BBB- | US
 | United Air Lines Inc. | Airlines | BB+ | US
 | British Airways plc | Airlines | BBB+ | UK
 | Delta Air Lines Inc. | Airlines | BBB- | US
 | Japan Airlines Co. Ltd. | Airlines | BB | Japan
 | Northwest Airlines Corp. | Airlines | BB | US
 | Suez Lyonnaise des Eaux s.a. | Energy | A | France
 | TransCanada Pipelines Ltd. | Energy | A- | Canada
 | Nippon Telegraph & Telephone Corp. | Telecoms | AA+ | Japan
 | Deutsche Telekom AG | Telecoms | AA- | Germany
 | France Télécom | Telecoms | AA- | France
 | [NAME] | Telecoms | A+ | Spain
 | Bell Canada | Telecoms | A+ | Canada
 | Cable & Wireless Communications plc | Telecoms | A | UK
 | Telstra Corp. Ltd. | Telecoms | AA+ | Australia
 | Alcatel S.A. | Electronics, Electrical Equipment | A | France
 | Siemens A.G. | Electronics, Electrical Equipment | AA | Germany
 | Hitachi | Electronics, Electrical Equipment | A+ | Japan
 | Sony Corp. | Electronics, Electrical Equipment | A+ | Japan
 | Toshiba Corp. | Electronics, Electrical Equipment | BBB+ | Japan
 | Koninklijke Philips Electronics N.V. | Electronics, Electrical Equipment | BBB+ | Netherlands
 | ABB Asea Brown Boveri Ltd. | Electronics, Electrical Equipment | AA- | Switzerland
 | Ericsson (Telefonaktiebolaget L.M.) | Electronics, Electrical Equipment | A+ | Sweden
 | Samsung Electronics | Electronics, Electrical Equipment | BB | S. Korea
 | Electrolux AB | Electronics, Electrical Equipment | BBB+ | Sweden
 | Sanyo Electric Co. Ltd. | Electronics, Electrical Equipment | BBB | Japan
 | Nokia Corp. | Electronics, Electrical Equipment | A | Finland
Spreadsheet: 376932d1423751138-auto-average-depending-on-content-colum-map2
Sheet: Blad1

Productie Ordernr | Artikelsoort | Naam | [NAME] | [NAME] | Bestelde hvh productieplanning | Bestelde hvh productieplanning * Netto gewicht | Productie hvh Productie | Productie hvh Productie * netto gewicht | Productie hvh Logistiek | Productie hvh Logistiek * nettogewicht | Percentage
[PHONE] | 1 | a | 1.35 | TR | 120 | 162 | 154 | 207.9 | 138 | 186.3 | 115
[PHONE] | 1 | a | 1.35 | TR | 192 | 259.2 | 213 | 287.55 | 192 | 259.2 | 100
[PHONE] | 1 | a | 1.35 | TR | 288 | 388.8 | 300 | 405 | 293 | 395.55 | 101.7361111111111
[PHONE] | 1 | a | 1.35 | TR | 288 | 388.8 | 298 | 402.3 | 296 | 399.6 | 102.7777777777778
[PHONE] | 1 | b | 1.35 | TR | 288 | 388.8 | 294 | 396.9 | 288 | 388.8 | 100
[PHONE] | 1 | b | 1.35 | TR | 384 | 518.4 | 398 | 537.3 | 394 | 531.9 | 102.6041666666667
[PHONE] | 1 | c | 1.35 | TR | 192 | 259.2 | 204 | 275.4 | 199 | 268.65 | 103.6458333333333
[PHONE] | 1 | c | 1.35 | TR | 192 | 259.2 | 202 | 272.7 | 192 | 259.2 | 100
[PHONE] | 1 | c | 1.35 | TR | 96 | 129.6 | 110 | 148.5 | 107 | 144.45 | 111.4583333333333
[PHONE] | 1 | c | 1.35 | TR | 288 | 388.8 | 297 | 400.95 | 288 | 388.8 | 100
[PHONE] | 1 | d | 1.35 | TR | 384 | 518.4 | 384 | 518.4 | 378 | 510.3 | 98.4375
[PHONE] | 1 | d | 1.35 | TR | 384 | 518.4 | 396 | 534.6 | 384 | 518.4 | 100
[PHONE] | 1 | j | 1.35 | TR | 192 | 259.2 | 195 | 263.25 | 179 | 241.65 | 93.22916666666666
[PHONE] | 1 | n | 1.35 | TR | 192 | 259.2 | 209 | 282.15 | 192 | 259.2 | 100
[PHONE] | 1 | n | 1.35 | TR | 384 | 518.4 | 392 | 529.2 | 382 | 515.7 | 99.47916666666666
[PHONE] | 1 | n | 1.35 | TR | 48 | 64.8 | 49 | 66.15 | 51 | 68.85 | 106.25
[PHONE] | 1 | w | 1.35 | TR | 96 | 129.6 | 108 | 145.8 | 105 | 141.75 | 109.375
[PHONE] | 1 | w | 1.35 | TR | 288 | 388.8 | 296 | 399.6 | 278 | 375.3 | 96.52777777777779
[PHONE] | 1 | q | 1.35 | TR | 120 | 162 | 131 | 176.85 | 135 | 182.25 | 112.5
[PHONE] | 1 | m | 1.35 | TR | 192 | 259.2 | 199 | 268.65 | 190 | 256.5 | 98.95833333333334
[PHONE] | 1 | m | 1.35 | TR | 288 | 388.8 | 305 | 411.75 | 310 | 418.5 | 107.6388888888889
[PHONE] | 1 | t | 1.35 | TR | 288 | 388.8 | 292 | 394.2 | 292 | 394.2 | 101.3888888888889
[PHONE] | 1 | t | 1.35 | TR | 288 | 388.8 | 300 | 405 | 288 | 388.8 | 100
[PHONE] | 1 | t | 1.35 | TR | 384 | 518.4 | 390 | 526.5 | 382 | 515.7 | 99.47916666666666
[PHONE] | 1 | t | 1.35 | TR | 192 | 259.2 | 204 | 275.4 | 200 | 270 | 104.1666666666667
Spreadsheet: 85958d1285944499-error-with-if-statement-oct-march-1011-termtime-only
Sheet: January

 | YOUTH ASSOCIATION SOUTH YORKSHIRE - STAFF TIMESHEET
 | Name
 | Date | Start AM | Finish | Start PM | Finish | Holiday | Sick | Total | Project/Location/Outputs
Monday | 2011-01-03 00:00:00 |  |  |  |  |  |  | 0 | BANK HOLIDAY
Tuesday | 2011-01-04 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2011-01-05 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2011-01-06 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2011-01-07 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 20
Monday | 2011-01-10 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2011-01-11 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2011-01-12 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2011-01-13 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2011-01-14 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2011-01-17 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2011-01-18 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2011-01-19 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2011-01-20 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2011-01-21 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2011-01-24 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2011-01-25 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2011-01-26 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2011-01-27 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2011-01-28 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
 |  |  |  |  | Total | 0 | 0 | 95.00000000000001
 |  |  |  |  | Please print off, sign and
 |  |  |  |  | Submit this timesheet by 5th February
 | Signed | ………………………………………
 | Date | ………………………………………
 | Notes/Comments
Spreadsheet: 213724d1360622148-formatting-number-as-text-issue-pt-cas2
Sheet: PlayTradeExport

Accept Value: | 2.5 | Location Value:
EAN IPC | TITLE | LowestPrice | Status
743216280629 | [NAME] | 2.95 | ACCEPT
75992354127 | [NAME] | 3.96 | ACCEPT
16861830021 | Nickelback - All The Right Reasons | 4.37 | ACCEPT
731454883429 | [NAME] (Advisory) | 3.13 | ACCEPT
685738745920 | The Pogues - Very Best Of (Remastered) | 7.45 | ACCEPT
602517938137 | 50 Cent - Before I Self Destruct | 4.99 | ACCEPT
94639720026 | [NAME] (CD & DVD) | 14.98 | ACCEPT
5014797291485 | [NAME] | 6.98 | ACCEPT
42280001520 | [NAME] | 4.25 | ACCEPT
75678367427 | Stills - Logic Will Break Your Heart | 3 | ACCEPT
886972347424 | Bullet For My Valentine - Scream, Aim, Fire | 4.73 | ACCEPT
75596279222 | Various - Smallville TV Soundtrack: The Talon Mix | 2.96 | ACCEPT
5014293651325 | [NAME] The Very Best Of | 2.94 | ACCEPT
77779920921 | Dr. [NAME] | 3.94 | ACCEPT
5014797292369 | Various - Northern Soul Floorshakers | 2.99 | ACCEPT
93624854524 | Red Hot Chili Peppers - Greatest Hits | 4.89 | ACCEPT
5038456114922 | The Shangri-Las - Leader Of The Pack | 4.98 | ACCEPT
683519101026 | Various - Urban Funk Breaks - In The Mix | 2.94 | ACCEPT
731455202229 | [NAME] Of | 11.18 | ACCEPT
724383308125 | [NAME] (Live) | 4.94 | ACCEPT
77774643825 | The Beatles - Beatles For Sale | 6.48 | ACCEPT
5012093917429 | The Charlatans - The Charlatans | 2.62 | ACCEPT
886974069225 | Pink - Funhouse | 2.98 | ACCEPT
724384683429 | Madness - It's...Madness | 3.87 | ACCEPT
654378030727 | Various - Teenage Kicks: Punk 2 | 4.36 | ACCEPT
724357940627 | [NAME] Pie | 13.48 | ACCEPT
5014293692427 | Rock-A-Doodle-Doo - That'll Be The Day | 4.98 | ACCEPT
75596246828 | The Doors - Best Of | 3.99 | ACCEPT
94635800227 | Various - Scrubs: Original TV Soundtrack | 3.98 | ACCEPT
8004883530922 | Billie Holiday - As Time Goes By | 5.98 | ACCEPT
731453125025 | The Velvet Underground - Velvet Underground And Nico | 3.49 | ACCEPT
5014797131385 | Various - Vox Humana | 8.98 | ACCEPT
602527266015 | [NAME] Fame Monster (UK Deluxe 2CD) | 3.48 | ACCEPT
5016958030926 | Bjork - Telegram | 5.9 | ACCEPT
724384233228 | Various - Best 60's Album In The World...Ever II | 2.99 | ACCEPT
8811148324 | [NAME] Of | 4.43 | ACCEPT
731454322720 | Ace Of Base - Singles Of The 90s | 6.57 | ACCEPT