tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18397__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2000-12-28 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728 | 128.78 | 2370 | 96.27 | 690
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800 | 124.75 | 1488 | 90.47 | 590
 | 2000-12-25 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 78.91 | 709 | 55.11 | 871 |  | 204.22 | 10800
 | 2000-12-24 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 92.39 | 584 | 65.56 | 160 |  | 204.22 | 10800
 | 2000-12-23 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 140 | 35 | 121.09 | 184
 | 2000-12-22 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 267.5 | 0 | 80 | 375
 | 2000-12-21 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 252.65 | 1831 | 132.45 | 530
 | 2000-12-20 00:00:00 |  | 269.33 | 15200 | 190.33 | 2688 | 198.54 | 3261 | 151.82 | 927
 | 2000-12-19 00:00:00 |  | 258.18 | 10272 | 178.86 | 1968 | 195.85 | 2305 | 133.46 | 718
 | 2000-12-18 00:00:00 |  | 224.43 | 11840 | 176.78 | 1168 | 220.89 | 1072 | 124.85 | 495
 | 2000-12-17 00:00:00 |  | 196.67 | 1200 | 175.71 | 280 | 136.93 | 985 | 113.5 | 500 |  | 177.12 | 2664
 | 2000-12-16 00:00:00 |  | 233.65 | 12880 | 192.27 | 2704 | 130.23 | 922 | 120.83 | 60
 | 2000-12-15 00:00:00 |  | 238.8 | 13024 | 192.27 | 2704 | 180.19 | 1670 | 128.18 | 706
 | 2000-12-14 00:00:00 |  | 334.66 | 15184 | 213.55 | 2480 | 200 | 150 | 174.54 | 271
 | 2000-12-13 00:00:00 |  | 495.62 | 14992 | 223.93 | 4504 | 276 | 3139 | 184.69 | 2161
 | 2000-12-12 00:00:00 |  | 330 | 9200 | 211.98 | 2688 | 347.7 | 2622 | 193.04 | 1826
 | 2000-12-11 00:00:00 |  | 414.56 | 9200 | 213.96 | 2480 | 204.38 | 2263 | 187.04 | 1280
 | 2000-12-10 00:00:00 |  | 254.96 | 2160 | 217.63 | 2280 | 180.88 | 1906 | 161.34 | 780 |  | 172.02 | 600
 | 2000-12-09 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 189.51 | 1364 | 138.71 | 403
 | 2000-12-08 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 290.86 | 1368 | 205.28 | 799
 | 2000-12-07 00:00:00 |  | 262.73 | 15808 | 174.55 | 2816 | 241.93 | 1455 | 118.5 | 865
 | 2000-12-06 00:00:00 |  | 250.5 | 23472 | 154.65 | 3232 | 283.47 | 2363 | 157.27 | 595
 | 2000-12-05 00:00:00 |  | 227.52 | 24992 | 101.29 | 3072 | 232.74 | 2743 | 129.08 | 673
 | 2000-12-04 00:00:00 |  | 190.1 | 29792 | 122.57 | 3880 | 162.07 | 2138 | 113.27 | 707
 | 2000-12-03 00:00:00 |  | 131.13 | 1600 | 119.17 | 600 | 107.99 | 2405 | 107.67 | 1422 |  | 122.75 | 11040
 | 2000-12-02 00:00:00 |  | 137.08 | 30464 | 72.7 | 2560 | 118.37 | 1436 | 90.96 | 1103
 | 2000-12-01 00:00:00 |  | 137.11 | 30144 | 72.7 | 2560 | 118.32 | 2042 | 90.99 | 855
 | 2000-11-30 00:00:00 |  | 171.25 | 27456 | 82.58 | 2392 | 129.11 | 2102 | 91.19 | 576
 | 2000-11-29 00:00:00 |  | 172.05 | 26336 | 87.15 | 3328 | 109.18 | 1495 | 95.66 | 607
 | 2000-11-28 00:00:00 |  | 129.76 | 22496 | 80.75 | 2568 | 119.59 | 2075 | 96.18 | 1478
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 10 April 2012

Daily Morning Staff |  |  |  |  | Tuesday
 | 07:30-14:30 |  | 2012-04-10 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS | last year balance leave 2011
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME] | Emergancy leave : Annual send message to Rabee due to some family reason
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 215568d1361411181-need-assistance-with-a-formula-for-indirect-color-highlight-with-text-terms-example
Sheet: Sheet1

First | Last | E-Mail | Date | Status |  | Color/Word Key | TOTAL
 |  |  |  | interested |  | Already Submitted
 |  |  |  | not interested |  | Not Interested
 |  |  |  | sourced, called |  | Not Qualified
 |  |  |  | sourced, not interested |  | More $$$
 |  |  |  |  |  | Too Far Away
 |  |  |  |  |  | H1B/Subcontractor
 |  |  |  |  |  | Sourced =
 |  |  |  |  |  | E-Mailed =
 |  |  |  |  |  | Called =
 |  |  |  |  |  | Spoke to =
 |  |  |  |  |  | Interested
 |  |  |  |  |  | Submitted =
Spreadsheet: 674533d1587899045-formula-to-allocate-stock-to-different-stores-based-on-the-minimums-set-by-the-business-allocation
Sheet: Sheet2

 | Problem
 |  |  | 4 | 3 | 2 | 2 | 1 | 1 | 1 | 1
 |  | Total | A | B | C | D | E | F | G | H
 | Apple | 10
 | Solution I want
 |  |  | 4 | 3 | 2 | 2 | 1 | 1 | 1 | 1
 |  | Total | A | B | C | D | E | F | G | H
 | Apple | 10 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | 0
Spreadsheet: 178254d1346738590-counting-data-on-another-worksheet-scorecard_new_backup
Sheet: Data

Customer Name | Likely to Recommend | Date of Survey
Adam | 10-- Extremely likely | 2012-09-04 00:00:00
[NAME] | 10-- Extremely likely | 2012-09-02 00:00:00
Edmond | 0-- Not likely at all | 2012-09-01 00:00:00
[NAME] | 10-- Extremely likely | 2012-09-02 00:00:00
[NAME] | 6 | 2012-09-01 00:00:00
Adam | 8 | 2012-09-02 00:00:00
[NAME] | 10-- Extremely likely | 2012-09-01 00:00:00
Edmond | 5 | 2012-09-01 00:00:00
[NAME] | 7 | 2012-09-03 00:00:00
[NAME] | 10-- Extremely likely | 2012-09-01 00:00:00
Adam | 9 | 2012-09-02 00:00:00
[NAME] | 10-- Extremely likely | 2012-09-04 00:00:00
Edmond | 8 | 2012-09-02 00:00:00
[NAME] | 7 | 2012-09-03 00:00:00
[NAME] | 0-- Not likely at all | 2012-09-01 00:00:00
Adam | 0-- Not likely at all | 2012-09-01 00:00:00
[NAME] | 10-- Extremely likely | 2012-09-02 00:00:00
Edmond | 10-- Extremely likely | 2012-09-01 00:00:00
[NAME] | 5 | 2012-09-02 00:00:00
[NAME] | 4 | 2012-09-04 00:00:00
Spreadsheet: 847133d1698212251-finding-top-2-supplier-out-of-5-supplier-list-newlogictest
Sheet: Sheet1

 | supplier | only_bevg [x] |  |  | supplier | only_bevg [x]
1 | a | x | 1 | 1 | a | x
2 | b | x | 1 | 2 | metro
3 | metro |  | 1 | 3 | c | x
4 | c |  | 1 | 4 | b
5 | d |  |  | 5 | d | x
S1 |  |  |  | S1
S2 |  |  |  | S2
S1
S2 |  | in this case supplier c should appear.
Survey tool logic: if in Q15 Metro is mentioned as #1 supplier, set Metro #1 and ask for supplier #2. If Metro is not mentioned as #1, please set #1 Supplier from Q15 as #1 and set Metro #2. If a supplier is indicated as supplying only beverages in Q16, please take the next best supplier that is not supplying beverages only.
Spreadsheet: 882189d1730450649-what-if-product-launch-date-change-whatifdynamicsalesdislay
Sheet: Cashflow

 |  | 1
Consoliated Revenue
Launch Month
Product One | 1 | At the moment both launch months are the same. I'd like to be able to use the table to the left to dynamically change the launch months and revenue shown on this page
Product Two | 1
Spreadsheet: andy_zipper__238__DYNEGY-ICE VOL May31
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:   All
Instruments:   All
Trade Dates:   May-31-01 thru May-31-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
May-31-01 | 151138237 |  | Bought | NG [NAME], ID, GDD | [NAME] (NY) | Next Day Gas | Jun-01-01 | Jun-01-01 |  |  |  | AEP Energy Services, Inc. | 0 | USD / MMBtu | 25000 | Daily | 25000 | MMBtus | Pimenov, V
May-31-01 | 178556869 |  | Bought | NG [NAME], FP | [NAME] | Next Day Gas | Jun-01-01 | Jun-01-01 |  |  |  | Aquila Energy Marketing Corp | 3.63 | USD / MMBtu | 5000 | Daily | 5000 | MMBtus | Goodell, S
May-31-01 | 363199534 |  | Sold | NG Fin BS, LD1 for IF | [NAME] (NY) | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | CMS Marketing, Services & Trading | 1.35 | USD / MMBtu | 5000 | Daily | 755000 | MMBtus | [NAME], G
May-31-01 | 433755766 |  | Sold | NG [NAME], FP | CNG-SP | Next Day Gas | Jun-01-01 | Jun-01-01 |  |  |  | NJR Energy Services Company | 3.865 | USD / MMBtu | 15000 | Daily | 15000 | MMBtus | Goodell, S
May-31-01 | 966851395 |  | Bought | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | Duke Energy Trading and Marketing LLC | 3.9 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
May-31-01 | 124786060 |  | Bought | NG Fin, FP for LD1 | [NAME] | Cal 03 | Jan-01-03 | Dec-31-03 |  |  |  | AEP Energy Services, Inc. | 3.83 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
May-31-01 | 169228916 |  | Sold | NG Fin BS, LD1 for IF | TCO | 2001-10-01 00:00:00 | Oct-01-01 | Oct-31-01 |  |  |  | Aquila Risk Management Corp. | 0.175 | USD / MMBtu | 5000 | Daily | 155000 | MMBtus | [NAME], G
May-31-01 | 170840966 |  | Sold | NG Fin BS, LD1 for NGI | Chicago | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | Duke Energy Trading and Marketing LLC | 0.17 | USD / MMBtu | 5000 | Daily | 755000 | MMBtus | [NAME], G
May-31-01   Deals
Spreadsheet: 485681d1477013319-sumproduct-with-3-columns-need-to-multiply-with-one-column-sumproduct-with-3-columns-and-times-with-one-column-example
Sheet: Sheet1

 |  |  |  | A1 | A2 | A3 |  | M1 Probability | QA
 |  |  |  | 500 |  |  |  | 1
 |  |  |  | 230
 |  |  |  | 100
 |  |  |  | 150 |  |  |  | 0.5
 |  |  |  | 230
 |  |  |  | 200
 |  |  |  |  | 400 |  |  | 0.05
 |  |  |  |  | 200 |  |  | 0.2
 |  |  |  |  | 300 |  |  | 0.3
 |  |  |  |  | 600 |  |  | 1
 |  |  |  |  | 700 |  |  | 0.3
 |  |  |  |  | 800 |  |  | 0.5
 |  |  |  |  | 300 |  |  | 0.7
 |  |  |  |  |  | 150 |  | 1
 |  |  |  |  |  | 230
 |  |  |  |  |  | 600
 |  |  |  |  |  | 700
 |  |  |  |  |  | 800 |  | 0.7
 |  |  |  |  |  | 500
 |  |  |  |  |  | 230
 |  |  |  |  |  |  | I need this total to be 2,855.00
Spreadsheet: 9d5cd3fd-558d-40ff-8791-a60a99b42aed
Sheet: Sheet1

Release: Annual Estimates of the Population of Metropolitan and Micropolitan Statistical Areas | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=111
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-01 4:34 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Annual Estimates of the Population of Metropolitan and Micropolitan | 2005-06-07 00:00:00 | Current
Statistical Areas
Link:
http://www.census.gov/popest/ | 2005-06-07 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2005-06-07 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2005-06-07 00:00:00
2006-01-19 00:00:00
2006-08-21 00:00:00
2006-09-14 00:00:00
2007-04-05 00:00:00
2008-03-27 00:00:00
2009-03-19 00:00:00
2010-03-25 00:00:00
2012-04-05 00:00:00
2013-03-27 00:00:00
2014-06-20 00:00:00
Spreadsheet: 169059d1342694551-creating-a-order-form-for-a-machine-hire-system-automated-rates-new
Sheet: Sheet1

7 Day Charge Calcs
Weekend Usage box |  |  | Y | Means the system will charge for weekend use.
 |  |  | N | The system will not charge for weekend use.
 |  |  |  |  |  |  |  |  |  |  |  | There after £24.00 per day
 |  |  | Days | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | Days |  |  | 8 | 9 | 10
 |  |  | Charge | 35 | 60 | 85 | 100 | 120 | 144 | 168 |  | Charge |  |  | 192 | 216 | 240
Automated system check
Weekend Usage box ticked? |  |  |  | Y
Number of days |  |  |  | 1
Daily Charge
Weekend Charge 20% of £168.00
Total
Spreadsheet: 871677d1718104071-query-pivot-to-transpose-email-address-email
Sheet: Sheet1

IDCUST | CUSTOMER NAME | [NAME] |  | IDCUST | CUSTOMER NAME | EMAIL1 | EMAIL2 | EMAIL3
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  | UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] | [EMAIL] | [EMAIL]
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  | UC1002 | [NAME] (UC1002) | [EMAIL]
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  | UC1005 | Island Car Trading Pte Ltd | [EMAIL] | [EMAIL]
UC1002 | [NAME] (UC1002) | [EMAIL]
UC1005 | Island Car Trading Pte Ltd | [EMAIL]
UC1005 | Island Car Trading Pte Ltd | [EMAIL]
Spreadsheet: 863271d1710833559-entering-a-letter-or-blank-if-a-cell-is-within-a-range-mhe-assessment-sheet
Sheet: Sheet1

MHE Evaluation Inspection Report
Warehouse Location |  |  |  | Region
Brand |  |  |  | Model |  |  | Serial No.
Inspection Date |  |  |  | Hour [NAME] |  | Assest Number
1. Visual Structure Inspection |  |  |  | [NAME] |  |  |  |  | Score
 | Mast Assembly Condition |  |  |  |  |  |  |  | 0
 | Load Backrest Condition |  |  |  |  |  |  |  | 0
 | Side Panels |  |  |  |  |  |  |  | 0
 | Safety Shield |  |  |  |  |  |  |  | 0
 | Cracked, Deformed or Damaged Parts |  |  |  |  |  |  |  | 0
Maximum Score 50
2. Electrical System |  |  |  | [NAME]
 | Battery Condition |  |  |  |  |  |  |  | 0
 | Battery Compartment Condition |  |  |  |  |  |  |  | 0
 | Connector and Cables Condition |  |  |  |  |  |  |  | 0
 | Electrical Components Condition |  |  |  |  |  |  |  | 0
 | Battery Tray |  |  |  |  |  |  |  | 0
 | Contactor Panel Condition |  |  |  |  |  |  |  | 0
 | Electric Motor Condition |  |  |  |  |  |  |  | 0
Maximum Score 70
3. Brakes |  |  |  | [NAME]
 | Brake Pedal Condition |  |  |  |  |  |  |  | 10
 | Overall Braking System Condition |  |  |  |  |  |  |  | 0
Maximum Score 20
4. Hydraulic System |  |  |  | [NAME]
 | Visible Oil Leaks |  |  |  |  |  |  |  | 0
 | Cylinder Seal Condition |  |  |  |  |  |  |  | 0
 | [NAME] And Fitting Condition |  |  |  |  |  |  |  | 10
 | [NAME] |  |  |  |  |  |  |  | 10
Maximum Score 40
5. Mast Assembly |  |  |  | [NAME]
 | Mast Channels Wear |  |  |  |  |  |  |  | 10
 | [NAME] |  |  |  |  |  |  |  | 10
 | Mast And Fork Roller Condition |  |  |  |  |  |  |  | 10
Maximum Score 30
6. Cold Store Trucks
 | Heating Resistors Condition |  |  |  |  |  |  |  | 10
 | Wiring Condition |  |  |  |  |  |  |  | 0
Maximum Score 20
7. Safety Devices
 | Reversing Mirror |  |  |  |  |  |  |  | 10
 | Seat Condition |  |  |  |  |  |  |  | 10
 | Seat Belt Condition |  |  |  |  |  |  |  | 10
 | Overhead Protection Condition |  |  |  |  |  |  |  | 10
 | Overal Lighting Condition |  |  |  |  |  |  |  | 10
Maximum Score 50
Inspected By |  |  |  | Signature |  |  |  | Total
 |  |  |  |  |  |  |  | %
Date |  |  |  | 75%-100% = Excellent
 |  |  |  | 40% - 75% = Quote For Maintenance
 |  |  |  | 0% - 40% = Consider Replacing
Spreadsheet: 275446d1383516495-finding-a-value-in-row-based-on-a-condition-sample
Sheet: Φύλλο1

A | RANK | 1 |  |  | A | RANK
A | TURNOVER | 5000 |  |  | E | RANK
B | RANK | 2 |  |  | E | TURNOVER
B | TURNOVER | 10000 |  |  | D | RANK
C | RANK | 4 |  |  | D | TURNOVER
C | TURNOVER | 15000 |  |  | C | RANK
D | RANK | 5 |  |  | C | TURNOVER
D | TURNOVER | 20000 |  |  | B | RANK
E | RANK | 3 |  |  | B | TURNOVER
E | TURNOVER | 25000 |  |  | A | TURNOVER
Spreadsheet: 675207d1588193567-matching-up-to-two-sets-of-data-move-sample
Sheet: Sheet1

Client # | DDA Account | Primary Name | RDS | RDS Limit | Setup Date | DDA ACCT | RISK
4541231 | 668 | ABC CO | Y | 20000 | 2010-06-02 00:00:00 | 668 | M
4543453 | 7499 | BBB | Y | 125000 | 2011-06-22 00:00:00 | 7499 | H
4543453 | 9505 | BBB | Y | 125000 | 2011-06-22 00:00:00 | 9505 | M
4543453 | 1380 | BBB | Y | 125000 | 2011-06-22 00:00:00 | 1380 | L
 |  |  |  |  |  | 7624 | M
 |  |  |  |  |  | 7616 | M
4541231 | 802 | ABC CO | Y | 20000 | 2010-06-02 00:00:00
34213453 | 7608 | CORP INC | Y | 750000 | 2019-08-27 00:00:00
Spreadsheet: 768354d1644935997-vlookup-issues-vlookup-sample
Sheet: Reference

MFR PART NO | UPC-A | DEALER PART NO
CCI-2-125 | [PHONE] | 115935
2HA | [PHONE] | 177278
3MDA | [PHONE] | 177285
MPP+4"X8" | [PHONE] | 115828
2MDA | [PHONE] | 177280
[NAME] | [PHONE] | 177290
CCI-266-125 | [PHONE] | 115936
CCI-2/0-200 | [PHONE] | 115934
CCI-266-200 | [PHONE] | 115937
Spreadsheet: 86812d1286790009-highlight-column-if-todays-date-book1-1-_scott488
Sheet: Sheet1

 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon
 | 2010-10-10 00:00:00 | 2010-10-11 00:00:00 | 2010-10-12 00:00:00 | 2010-10-13 00:00:00 | 2010-10-14 00:00:00 | 2010-10-15 00:00:00 | 2010-10-16 00:00:00 | 2010-10-17 00:00:00 | 2010-10-18 00:00:00
 | 2 | 4 | 6 | 1 | 76 | 34 | 6 | 32 | 46
 | 45 | 6 | 345 | 3 | 234 | 68 | 4 | 74 | 43
 | 26 | 34 | 34 | 346 | 856 |  | 45 | 25
 | 43 | 11 | 18 | 72 | 23 |  |  | 2 | 245
Spreadsheet: 41772d1240299699-dynamic-range-help-example
Sheet: Sheet1

Department | Account | Rate | OT % | Hours | Total |  | Hide this column
Z | Exempt | 0 | 0 | 0 | 0 |  | 0
Z | [NAME] | 0 | 0 | 0 | 0 |  | 0
Z | Resident Care Coord | 0 | 0 | 0 | 0 |  | 0
Z | RNs | 27.6143 | 0.03 | 110 | 3037.573 |  | 91.12719
Z | LPNs | 25.1732 | 0.05 | 470 | 11831.404 |  | 591.5702
Z | CNAs | 12.7411 | 0.05 | 1096 | 13964.2456 |  | 698.2122800000001
Z | [NAME] | 15.3161 | 0.05 | 236.992 | 3629.7931712 |  | 181.48965856
Z | [NAME] | 13.1428 | 0.05 | 112 | 1471.9936 |  | 73.59968
Z | Other Nurses | 0 | 0.03 | 0 | 0 |  | 0
Z | Training | 16.9538 | 0 | 30 | 508.614 |  | 0
Z | [NAME] | 0 | 0 | 0 | 1635.99900856 |  | 0
Q | Exempt | 19.38 | 0 | 80 | 1550.4 |  | 0
Q | [NAME] | 0 | 0.02 | 0 | 0 |  | 0
Q | Chefs | 0 | 0 | 0 | 0 |  | 0
Q | Cooks | 12.1176 | 0.05 | 118.72 | 1438.601472 |  | 71.9300736
Q | Utility Workers | 0 | 0.03 | 0 | 0 |  | 0
Q | Servers | 0 | 0.03 | 0 | 0 |  | 0
Q | Bussers | 10.0674 | 0.06 | 382.13 | 3847.055562 |  | 230.82333372
Q | Training | 10.9752 | 0 | 2 | 21.9504 |  | 0
Q | [NAME] | 0 | 0 | 0 | 302.75340732 |  | 0
L | Exempt | 17 | 0 | 40 | 680 |  | 0
L | [NAME] | 0 | 0 | 0 | 0 |  | 0
L | HouseKeepers | 10.4854 | 0.05 | 160 | 1677.664 |  | 83.8832
L | Laundry | 10.197 | 0.05 | 112 | 1142.064 |  | 57.1032
L | Training | 10.3824 | 0 | 5 | 51.91200000000001 |  | 0
L | [NAME] | 0 | 0 | 0 | 140.9864 |  | 0
A | Exempt | 0 | 0 | 0 | 0 |  | 0
A | [NAME] | 18.87475 | 0.06 | 120 | 2264.97 |  | 135.8982
A | [NAME] | 0 | 0 | 0 | 135.8982 |  | 0
Spreadsheet: 840091d1692405433-offset-indirect-formula-with-increasing-delta-change-in-row-position-examplecalender
Sheet: Delivery Calender

Week beginning | Use the drop down menu in the 'Week Beginning' column to select the week you wish to view.
 | STORE | TRANSFERS | 2023-01-02 00:00:00
 | Truck
 |  |  |  | Staffing
 |  |  |  | DC Notes
 |  |  |  | Store Notes
 |  |  |  | VACATION CALENDAR
 | Position 1
 | Position 2
 | Position 3
 | Position 4
 | Position 5
 | STORE | TRANSFERS
 | Truck
 |  |  |  | Staffing
 |  |  |  | DC Notes
 |  |  |  | Store Notes
 |  |  |  | VACATION CALENDAR
 | Position 1
 | Position 2
 | Position 3
 | Position 4
 | Position 5
 | STORE | TRANSFERS
 | Truck
 |  |  |  | Staffing
 |  |  |  | DC Notes
 |  |  |  | Store Notes
 |  |  |  | VACATION CALENDAR
 | Position 1
 | Position 2
 | Position 3
 | Position 4
 | Position 5
 | STORE | TRANSFERS
 | Meetings
 | Truck
 |  |  |  | Staffing
 |  |  |  | DC Notes
 |  |  |  | Store Notes
 |  |  |  | VACATION CALENDAR
 | Position 1
 | Position 2
 | Position 3
 | Position 4
 | Position 5
 | STORE | TRANSFERS
 | Truck
 |  |  |  | Staffing
 |  |  |  | DC Notes
 |  |  |  | Store Notes
 |  |  |  | VACATION CALENDAR
 | Position 1
 | Position 2
 | Position 3
 | Position 4
 | Position 5
Spreadsheet: 492739d1481230239-working-with-a-large-amount-of-email-address-lists-with-duplicate-addresses-re-arrange-data-2
Sheet: Sheet1

 |  |  |  |  | 1 | 2 |  |  |  | 4 | 3 |  |  |  |  |  | 5
List 1 | List 2 | List 3 | List 4
Cersi | Arya | Jon | Bran
[NAME] | Bra | Meera | Cersi
Jon | Cersi | [NAME] | [NAME]
Meera | Meera | Robb | Jon
Sansa | Robb | Stannis | Meera
Tyrion | Tywin | Tyrion | Varys
Spreadsheet: 85958d1285944499-error-with-if-statement-oct-march-1011-termtime-only
Sheet: March

 | YOUTH ASSOCIATION SOUTH YORKSHIRE - STAFF TIMESHEET
 | Name
 | Date | Start AM | Finish | Start PM | Finish | Holiday | Sick | Total | Project/Location/Outputs
Monday | 2011-02-28 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2011-03-01 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2011-03-02 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2011-03-03 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2011-03-04 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2011-03-07 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2011-03-08 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2011-03-09 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2011-03-10 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2011-03-11 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2011-03-14 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2011-03-15 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2011-03-16 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2011-03-17 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2011-03-18 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2011-03-21 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2011-03-22 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2011-03-23 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2011-03-24 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2011-03-25 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
 |  |  |  |  | Total | 0 | 0 | 100
 |  |  |  |  | Please print off, sign and
 | Signed | ……………………………………… |  |  | Submit this thimesheet by 9th April
 | Date | ………………………………………
 | Notes/Comments