tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 769513d1645568544-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing
Sheet: Average Checkins per AG+Week

Weeks | Start Date | End Date
Week 1 | 2022-01-03 00:00:00 | 2022-01-09 00:00:00
Week 2 | 2022-01-10 00:00:00 | 2022-01-16 00:00:00 |  |  |  | IS THERE A WAY TO TAKE WHAT'S ON THE AVERAGE CHECKINS PER AGE GROUP TAB AND DO IT PER WEEK?
Week 3 | 2022-01-17 00:00:00 | 2022-01-23 00:00:00
Week 4 | 2022-01-24 00:00:00 | 2022-01-30 00:00:00
Starting Age | Ending Age
13 | 19
20 | 29
30 | 39
40 | 49
50 | 59
60 | 69
70 | 79
80 | 89
90 | 99999
Spreadsheet: 116666d1311974156-multi-line-cell-spliting-sampleadlistwitherrors
Sheet: Sheet1

Title | Name | Address | Postcode | [NAME] | [NAME] | [NAME] | [NAME]
Mr | [NAME] | Madeup House Imaginary Street Crazy Town Weird Area Silly County | BL4 8LA | [EMAIL] | 123456789 | 9876543210 | 5678901234
Mr | [NAME] | Madeup House Weird Area Silly County | BL4 8LA | [EMAIL] | 123456789 | 9876543210 | 5678901234
Mr | [NAME] | Madeup House Imaginary Street Weird Area Silly County | BL4 8LA | [EMAIL] | 123456789 | 9876543210 | 5678901234
Spreadsheet: 222117d1363768306-format-rows-based-on-predecessor-value-in-a-column-book3
Sheet: Sheet1

BEFOR
Customer | PartNo | Qty
AA | 6547 | 45
AA | 32657 | 8
AA | 3474 | 64
BB | 3441 | 21
BB | 65754 | 15
CC | 21574 | 36
DD | 2154 | 98
DD | 35454 | 65
DD | 544 | 32
DD | 65441 | 654
DD | 6544 | 455
EE | 311 | 259
FF | 364 | 54
FF | 3465 | 21
GG | 3216 | 46
HH | 13246 | 65
HH | 3215 | 987
AFTER
Customer | PartNo | Qty
AA | 6547 | 45
 | 32657 | 8
 | 3474 | 64
BB | 3441 | 21
 | 65754 | 15
CC | 21574 | 36
DD | 2154 | 98
 | 35454 | 65
 | 544 | 32
 | 65441 | 654
 | 6544 | 455
EE | 311 | 259
FF | 364 | 54
 | 3465 | 21
GG | 3216 | 46
HH | 13246 | 65
 | 3215 | 987
Spreadsheet: 589bbde7-2b17-447a-9b2d-7f1fa4902533
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2012/13 |  |  |  | 2011/12
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 14 |  | 8208 |  | 12.4 |  | 9343 |  | 15.9 |  | 2285 |  | 19 |  | 2041
September | 13.8 |  | 9192 |  | 13.7 |  | 10310 |  | 17.4 |  | 1496 |  | 17.8 |  | 2197
October | 13.9 |  | 11773 |  | 14.1 |  | 8703 |  | 16.4 |  | 1907 |  | 16.5 |  | 3074
November | 14.2 | 1/ |  |  | 13.9 |  | 7205 |  | 17.3 | 1/ |  |  | 16.9 |  | 4410
December |  |  |  |  | 13.8 |  | 9947 |  |  |  |  |  | 16.6 |  | 5007
January |  |  |  |  | 13.6 |  | 9491 |  |  |  |  |  | 16.7 |  | 5896
February |  |  |  |  | 13.2 |  | 9926 |  |  |  |  |  | 16 |  | 3712
March |  |  |  |  | 13 |  | 10050 |  |  |  |  |  | 16 |  | 4733
April |  |  |  |  | 13.2 |  | 9432 |  |  |  |  |  | 15.8 |  | 3904
May |  |  |  |  | 13.3 |  | 9698 |  |  |  |  |  | 16.3 |  | 3262
June |  |  |  |  | 13.5 |  | 7129 |  |  |  |  |  | 15.4 |  | 3395
July |  |  |  |  | 13.5 |  | 7492 |  |  |  |  |  | 16 |  | 2707
Average to date 2/ | 13.975 |  |  |  |  |  |  |  | 16.75
Season-average farm price | 14.2 | 3/ |  |  | 13.4 |  |  |  | 17 | 3/ 4/ |  |  | 16.5
Average marketings |  |  | 9724.333333333334 |  |  |  | 9060.5 |  |  |  | 1896 |  |  |  | 3694.833333333333
Total volume marketed |  |  | 29173 |  |  |  | 108726 |  |  |  | 5688 |  |  |  | 44338
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
4/ The medium/short-grain season-average- farm price ([NAME]) largely reflects rice that is marketed through
price pools in California. The pool price is not final until all the rice in the pool is marketed for the crop year.
Therefore, [NAME] forecasts based on the average of NASS monthly prices and the final price may differ.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated December 11, 2012.
Spreadsheet: 6d273b4e-1a55-4700-be09-d203b2c49373
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
URCU | Test | URCU | Uric Acid, [NAME] | [NAME], U | Uricase | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. Add 10 g of boric acid as preservative at start of collection. 3. Mix well before taking 5-mL aliquot. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	No Refrigerated	Yes Frozen	Yes 6N HCl	No 50% Acetic Acid	No Na2CO3	Yes Toluene	Yes 6N HNO3	No Boric Acid	Preferred Thymol	Yes | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Diet-dependent: <750 mg/specimen The reference value is for a 24-hour collection. Specimens collected for other than a 24-hour time period are reported in unit of mg/dL for which reference values are not established. | Monday through Sunday; Continuously | Same day/1 day | Same day/1 day | 1 | 84560 |  |  |  |  | Rochester
URCU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
URCU | Order Question | TM29 | Collection Duration |  | Plain Text
URCU | Order Question | VL27 | [NAME] |  | Plain Text
URCU | Result | UACID | [NAME], U | [NAME], U | Numeric |  |  |  |  | mg/spec |  |  |  |  |  |  |  |  |  | 3087-4
URCU | Result | TM29 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9
URCU | Result | VL27 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3167-4
URCU | Result | UACN1 | Uric Acid Concentration | Uric Acid Concentration | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 21587-1
Spreadsheet: 61342d1262166754-excel-2007-conditional-formatting-where-a-value-of-b-is-entered-712195-conditional-formatting
Sheet: Sheet1

 | TASK | PRIORITY | AREA | [NAME] | DATE ENTERED | STATUS
 | wash car | A | Car | wash car | 2009-12-25 00:00:00
 | fit curtain pole | B | House | in boys bedrooms | 2009-11-09 00:00:00
 | cut lawn | B | Garden | tidy leaves first! | 2009-12-18 00:00:00
 | paint bathroom | A | House | obtain paint | 2009-12-01 00:00:00
 | tidy store room | D | Basement | purchase shelfs | 2000-01-01 00:00:00
Spreadsheet: 28edd9bb-ba73-4940-8e20-af1b7e7cbb1e
Sheet: 6. Building Potential Summary

NON-POTABLE WATER CALCULATOR
Step 6 of 7: Summary of Building Potential
 | Project Name: |  |  |  | LEGEND:
 |  |  |  |  | [NAME]
 |  |  |  |  | Linked from User Input
 | Instructions: |  |  |  | Default Value
 | An accounting of total demand and onsite supplies for the project are summarized below.  No user input is needed for this step. |  |  |  | Autogenerated Value
 | A. TOTAL DEMAND (No user input needed - auto-calculated)
 | Red font below in Domestic Fixtures sections indicates supplies that will be used towards non-potable demands
 |  |  |  |  | Average Monthly Demand (gal/mth)
 | Demand Types | Ave Daily Water Demand (gpd) | Annual Water Demand (gpy) | Allowable Non-Potable Demand (gpy) | January | February | March | April | May | June | July | August | September | October | November | December
 | DOMESTIC FIXTURES  - Commercial
 | Showerhead
 | [NAME]
 | Urinals
 | Toilet (Water Closet)
 | [NAME]
 | Low [NAME]
 | SUBTOTAL
 | DOMESTIC FIXTURES - Multi-Family Residential
 | Showerhead
 | Bathroom Faucet
 | Bath
 | Washing Machine
 | Toilet (Water Closet)
 | [NAME]
 | Dishwasher
 | SUBTOTAL
 | HVAC/COOLING
 | Conventional Cooling
 | SUBTOTAL
 | OTHER INDOOR DEMANDS THAT CAN BE MET WITH NON-POTABLE SUPPLIES
 | Indoor Decorative Water Feature
 | Commercial Laundry
 | SUBTOTAL
 | OUTDOOR DEMANDS
 | Landscape Irrigation | N/A
 | Decorative Water Feature
 | SUBTOTAL
 | GRAND TOTAL
 | Project Total Annual Water Demand (gpy)
 |  |  | % of Total Water Demand
 | Project Potential Non-Potable Demand (gpy)
 | Total Annual Toilet/Urinal Flushing Demand (gpy)
 | Total Annual Irrigation Demand (gpy)
 | TOTAL ONSITE SUPPLIES (No user input needed - auto-calculated)
 | The table below is an accounting of the total potential onsite supply available; the values do not represent the final supplies that will be used for the project
 |  |  |  |  | Average Monthly Demand (gal/mth)
 | [NAME] | Ave [NAME] (gpd) | Annual Supply (gpy) |  | January | February | March | April | May | June | July | August | September | October | November | December
 | Graywater
 | Blackwater
 | Foundation Drainage
 | [NAME] | N/A
 | Stormwater | N/A
 | TOTAL
 | Total Annual Graywater Supply (gpy)
 | Total Annual Blackwater Supply (gpy)
 | Total Annual Foundation Drainage Supply (gpy)
 | Total Annual Rainwater Supply (gpy)
 | Total Annual Stormwater Supply (gpy)
 | >>> Please proceed on to Step 7: Project Definition
Spreadsheet: f698f412-f5e6-43d4-ac31-f76d2e29eda6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259066 | 71905 | Helena | Oberholzer | RSA |  | 00:39:27 | 00:00:00 | 01:17:29 | 00:00:00 | 00:21:01 | 1 | 02:17:57
259066 | 64022 | [NAME] | Hopking | RSA |  | 00:40:03 | 00:00:00 | 01:16:09 | 00:00:00 | [NAME] | 2 | 02:18:10
259066 | 63711 | Celeste | Erasmus | RSA |  | 00:40:03 | 00:00:00 | 01:22:28 | 00:00:00 | 00:22:24 | 3 | 02:24:55
Spreadsheet: 193036d1352710116-time-sheet-with-formula-cell-to-work-out-the-hours-work-rota-template-november-2012
Sheet: Staffing Manager Time Table

STAFFING MANAGER TIME TABLE
Time | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
Ash
Nikki
[NAME]
[NAME]
Spreadsheet: kenneth_lay__19488__holdings for confirmation
Sheet: Sheet1

Reported holdings of [NAME]
Company | Direct Holdings | Indirect holdings | Direct and Indirect combined
Enron | 2766998 | 118876
Compaq | 340724 | ? | ?
Eli Lilly | 34308 | 20220
i2 Technologies | 5000 | 8000 | 13000
Newpower Holdings | 150000 | 0
EOTT Energy Partners | 125000 | 0
Spreadsheet: dana_davis__4473__CANADA - 28C
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 28C
COMPANY NAME ECT - CANADA ACCOUNTING ENTRY
EQUITY INVESTEE'S SUMMARIZED INFORMATION
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 694729d1599763991-if-formula-help-dschittone-sample
Sheet: 06-07

LIST PROJECT # | DISTRICT SCHOOL - PROPOSED BUILDING PROJECT                                      (List Deficiencies from District Facilities Director and 00-05 District LRFP'S by School and Year)   Note:  Add Rows for Additional Schools | 2006-2007 | Life - Safety  - Priority A | Critical /  Recommended Projects -              Priority B | [NAME]Priority C | Barrier-Free ADA Compliance - Priority H | Energy Efficiency - Priority E | Quantity -Check Total | Unit Cost
 | SCHOOL NAME: [NAME] Complex
1 | Stucco (EIFS) Finish and Sealant | 85600 | 0 |  | 0 | 0 | 0 | 10700 | 8
3 | Paint Interior Walls | 26800 | 0 | 0 |  | 0 | 0 | 243214 | 0.55
9 | ATC System Zone Control Upgrade |  | 0 | 0 | 0 | 0 |  | 217316 | 1.75
10 | Clean and refurbish [NAME] | 100000 | 0 |  | 0 | 0 | 0 | 217316 | ls
13 | Upgrade Phone System - Classrooms (VO/IP) - Backbone installed | 35000 | 0 | 0 |  | 0 | 0 |  | ls
14 | Replace Toilet Partitions (ADA) - 3 per room (district to buy/install) | 10000 | 0 | 0 |  | 0 | 0 |  | ls
15 | Paint Exterior Spiral Staircase (near pool) | 10000 | 0 | 0 |  | 0 | 0 |  | ls
19 | Re-seal/re-glaze (3) skylights, library curtain wall & EIFS circle windows | 75000 | 0 |  | 0 | 0 | 0 |  | (30,40,5)
 | SUBTOTAL "A"
 | SCHOOL NAME: [NAME]
3 | [NAME] to Central Storage |  | 0 | 0 |  | 0 | 0 | 3007 | 65
5 | Extend ATC System into Older Portion of Building (Combine with [NAME] ) | 160000 | 0 | 0 | 0 | 0 |  | 38008 | 4.2
6 | Install Exterior Metal Panels (Soffits & Fascias) | 0 |  | 0 | 0 | 0 | 1282 | 19.5
8 | Interior-Blackboard/Whiteboard & Ex. Bds. (12 rooms x 2 bds/rm) | 25000 | 0 | 0 |  | 0 | 0 | 256 | 30
9 | Leaks in New and Old Building (DDL - Rising wall at old MP Room) | 67750 | 0 |  | 0 | 0 | 0
23 | Replace Fence around Pre-K Play Area | 12000 | 0 |  | 0 | 0 | 0 | 800 | 15/lf
31 | Replace Single Ply Membrane Roof for BUR (Roofs A, B, C) |  | 0 |  | 0 | 0 | 0 | 24937 | 14.25
35 | Replace Teachers Dining  Room HVAC w/ Split System (cooling only) | 15000 | 0 | 0 |  | 0 | 0 | 200 | ls
 |  |  |  |  |  |  | 0
 | SUBTOTAL "B"
 | SCHOOL NAME: William Davies Middle School
1 | Paint Interior Walls | 7000 | 0 | 0 |  | 0 | 0 | 63380 | 0.55
2 | Replace [NAME] | 21500 | 0 | 0 |  | 0 | 0 | 15622 | 4.1
7 | Replace Garage Roof |  | 0 |  | 0 | 0 | 0 | 1200 | 15
 |  |  |  |  |  |  | 0
 | SUBTOTAL "C"
 | SCHOOL NAME:
1 |  | 0 | 0 | 0 | 0 | 0
 | SUBTOTAL "D"
 | SUMMARY SUBTOTALS (Subtotals A-G) :
 | PROJECT SOFT COSTS (A/E Fees, [NAME], Printing x 25%) :
 | PROJECT TOTALS:
Spreadsheet: 202291d1356484385-cell-reset-unit-6-spreadsheet
Sheet: Products to Order

 |  |  | [NAME]
 |  |  | Products That Need To Be Ordered
Product ID |  | Product Name |  |  |  |  | Cost Price | Retail Price | Number Remaining
 |  | [NAME]
 |  | IST Pro Ear Mask
 |  | ScubaPro T-One BCD
 |  | [NAME]
 |  | ScubaPro X-Force BCD
 |  | Suunto Zoop Dive Computer
 |  | ScubaPro T-Black BCD
 |  | Mares Nemo Wide
 |  | [NAME] BCD
 |  | UWATEC Galileo Sol (including [NAME])
 |  | [NAME]
 |  | Suunto D6i with USB
 |  | Oceanic Probe HLC BCD
 |  | ScubaPro Mens Everdry 4 Dry Suit
 |  | [NAME]
 |  | ScubaPro Womens Everdry 4 Dry Suit
 |  | [NAME] BCD
 |  | Fourth Element Mens Proteus Long Wetsuit
 |  | [NAME]
 |  | Forth Element Womens Proteus Long Wetsuit
 |  | [NAME]
 |  | Fourth Element Mens Proteus Short Wetsuit
 |  | Hollis SMS 100 Sidemount Harness
 |  | Forth Element Womens Proteus Short Wetsuit
 |  | [NAME]
 |  | ScubaPro 12 Litre 232 Bar Single Valve Cylinder
 |  | ScubaPro X-One BCD
 |  | ScubaPro 15 Litre 232 Bar Single Valve Cylinder
 |  | Cressie S300 BCD
 |  | [NAME]
 |  | [NAME] BCD
 |  | Mares X Stream Fins
 |  | Oceanic Hera Ladies BCD
 |  | TUSA X-Pert Evolution Full Foot Fins
 |  | Oceanic Hera Ladies BCD
 |  | [NAME]
 |  | Mares Hybrid Pro Tec BCD
 |  | Mares Avanti Quattro Plus Fins
 |  | [NAME] Lady BCD
 |  | Mares Quattro Excel Plus
 |  | Mares i3 Mask
 |  | [NAME] On Water Fins
 |  | Mares X-VU Sunrise Liquidskin Mask
 |  | Pro Force Force Fins
 |  | Sherwood Scuba Allure  Mask
 |  | ScubaPro Delta Zip Boots
 |  | TUSA Freedom One Pro Mask
 |  | ScubaPro EverFlex Gloves
 |  | [NAME]
 |  | TUSA Imprex Dive Slipper
 |  | Hollis M1 Mask
 |  | ScubaPro MK25 S600 Regulator
 |  | Cressi Big Eyes Evolution Crystal Mask
 |  | Apeks XTX 50 Octopus Regulator
 |  | TUSA Geminus Mask
 |  | Oceanic Alpha 9 CDX5 Regulator
Spreadsheet: 25467d1216778991-if-statement-sample
Sheet: Sheet1

POD 1 | Joe - Intake | Mary - Intake | Steve - Intake | Sally - Intake |  | [NAME] | [NAME] | Sue - Case | [NAME]
08:00:00 | Johnson-123456 | Lewis-226678 | Adams-854112 | Young-112987 | 08:00:00
09:00:00 |  |  |  |  | 09:00:00
10:00:00 |  |  |  |  | 10:00:00
11:00:00 |  |  |  |  | 11:00:00
01:00:00 |  |  |  |  | 01:00:00
02:00:00 |  |  |  |  | 02:00:00
03:00:00 |  |  |  |  | 03:00:00
04:00:00 |  |  |  |  | 04:00:00
Spreadsheet: 674554d1587911901-sumifs-taking-a-significant-time-to-render-250-000-rows-2020-04-26-oeldere-example-pt
Sheet: Pivot table

year | (Alle)
[NAME] | Kolomlabels
Month | 2 | 3 | 4 | Eindtotaal
Attack | 38.5 | 38.5 | 55.5 | 132.5
Dale RODON | 6.5 | 6.5 |  | 13
[NAME] CAMPBELL | 5.5 | 5.5 |  | 11
[NAME] | 6.5 | 6.5 |  | 13
[NAME] |  |  | 6 | 6
[NAME] | 7 | 7 |  | 14
[NAME] |  |  | 5.5 | 5.5
[NAME] | 7.5 | 7.5 |  | 15
Oeldere |  |  | 32 | 32
[NAME] |  |  | 6 | 6
[NAME] |  |  | 6 | 6
[NAME] | 5.5 | 5.5 |  | 11
(leeg)
Defence | 21.5 | 21.5 | 20 | 63
[NAME] | 6.5 | 6.5 |  | 13
[NAME] |  |  | 8 | 8
[NAME] | 9 | 9 |  | 18
[NAME] |  |  | 5 | 5
[NAME] | 6 | 6 |  | 12
[NAME] |  |  | 7 | 7
(leeg)
Midfield | 48 | 48 | 34.5 | 130.5
[NAME] |  |  | 5.5 | 5.5
[NAME] | 7 | 7 |  | 14
[NAME] | 6 | 6 |  | 12
[NAME] |  |  | 6 | 6
Greg LEIGH | 6 | 6 |  | 12
[NAME] | 6 | 6 |  | 12
[NAME] |  |  | 6.5 | 6.5
[NAME] |  |  | 5 | 5
[NAME] | 4 | 4 |  | 8
[NAME] |  |  | 5.5 | 5.5
Richie AYEW |  |  | 6 | 6
[NAME] | 5.5 | 5.5 |  | 11
Scott DILLON | 7.5 | 7.5 |  | 15
[NAME] | 6 | 6 |  | 12
(leeg)
Eindtotaal | 108 | 108 | 110 | 326
Spreadsheet: 779624d1651916132-way-to-hide-certain-dates-when-date-is-in-another-field-daf-dharvey-no-all-dates-aligw
Sheet: Sheet1

Dates - Week One |  |  |  |  |  |  | Dates - Week Two
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Holiday Dates
2022-04-15 00:00:00 | Good Friday
2022-04-16 00:00:00 | Saturday before Easter Sunday
2022-04-17 00:00:00 | Easter Sunday
2022-04-18 00:00:00 | Easter Monday
2022-04-25 00:00:00 | Anzac Day
2022-06-13 00:00:00 | Queen's Birthday
Other Dates
2022-05-15 00:00:00
2022-05-16 00:00:00
Spreadsheet: 729134d1618925783-sumif-with-column-and-row-header-criteria-sum-if
Sheet: Data

Data Point | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00
A | 100 | 50 | 89 | 200 | 100 | 50 | 89 | 200 | 290
B | 200 | 150 | 189 | 300 | 200 | 150 | 189 | 300 | 390
C | 300 | 250 | 289 | 400 | 300 | 250 | 289 | 400 | 490
A | 400 | 350 | 389 | 500 | 400 | 350 | 389 | 500 | 590
E | 500 | 450 | 489 | 600 | 500 | 450 | 489 | 600 | 690
A | 600 | 550 | 589 | 700 | 600 | 550 | 589 | 700 | 790
Spreadsheet: 105377d1302744635-excel-2007-return-value-based-on-multiple-criteria-testdata
Sheet: Sheet1

Category | Date | [NAME] | [NAME] |  |  | Category | Date | [NAME] | [NAME]
A | 2010-03-11 00:00:00 | 1 |  |  |  | A | 2010-03-11 00:00:00 | 1
 | 2010-06-02 00:00:00 |  | 1 |  |  |  | 2010-06-02 00:00:00 |  | 1
 | 2010-11-03 00:00:00 | 1 |  |  |  |  | 2010-11-03 00:00:00 | 1
 | 2011-02-07 00:00:00 | 1 |  |  |  |  | 2011-02-07 00:00:00 | 1
B | 2010-09-05 00:00:00 | 1 |  |  |  | B | 2010-09-05 00:00:00 | 1
 | 2010-12-20 00:00:00 |  | 2 |  |  |  | 2010-12-20 00:00:00 |  | 1
 | 2010-12-27 00:00:00 |  | 2 |  |  |  | 2010-12-27 00:00:00 |  | 1
C | 2011-01-14 00:00:00 | 1 |  |  |  | C | 2011-01-14 00:00:00 | 1
D | 2011-03-01 00:00:00 |  | 2 |  |  | D | 2011-03-01 00:00:00 |  | 1 |  |  | Category | Date
 | 2011-03-23 00:00:00 |  | 2 |  |  |  | 2011-03-23 00:00:00 |  | 1 |  |  | A | 2010-06-02 00:00:00
E | 2009-12-07 00:00:00 |  | 2 |  |  | E | 2009-12-07 00:00:00 |  | 1 |  |  | B | 2010-12-27 00:00:00
 | 2010-04-05 00:00:00 | 1 |  |  |  |  | 2010-04-05 00:00:00 | 1 |  |  |  | C | 2011-01-14 00:00:00
 | 2010-11-19 00:00:00 | 1 |  |  |  |  | 2010-11-19 00:00:00 | 1 |  |  |  | D | 2011-03-23 00:00:00
F | 2010-03-26 00:00:00 | 1 |  |  |  | F | 2010-03-26 00:00:00 | 1 |  |  |  | E | 2009-12-07 00:00:00
 | 2010-07-09 00:00:00 | 1 |  |  |  |  | 2010-07-09 00:00:00 | 1 |  |  |  | F | 2010-03-26 00:00:00
 | 2010-08-25 00:00:00 | 1 |  |  |  |  | 2010-08-25 00:00:00 | 1 |  |  |  | G | 2011-04-11 00:00:00
 | 2011-01-12 00:00:00 | 1 |  |  |  |  | 2011-01-12 00:00:00 | 1
G | 2009-09-04 00:00:00 | 1 |  |  |  | G | 2009-09-04 00:00:00 | 1
 | 2009-10-22 00:00:00 |  | 2 |  |  |  | 2009-10-22 00:00:00 |  | 1
 | 2010-01-16 00:00:00 | 1 |  |  |  |  | 2010-01-16 00:00:00 | 1 |  |  |  |  | Criteria | Date of Last Batch 2 if there is [NAME] for a category
 | 2010-05-03 00:00:00 |  | 2 |  |  |  | 2010-05-03 00:00:00 |  | 1 |  |  |  |  | -or-
 | 2010-08-05 00:00:00 | 1 |  |  |  |  | 2010-08-05 00:00:00 | 1 |  |  |  |  |  | Date of First Batch 1 if there is [NAME]
 | 2010-10-18 00:00:00 |  | 2 |  |  |  | 2010-10-18 00:00:00 |  | 1
 | 2010-11-30 00:00:00 | 1 |  |  |  |  | 2010-11-30 00:00:00 | 1
 | 2011-04-11 00:00:00 |  | 2 |  |  |  | 2011-04-11 00:00:00 |  | 1
Spreadsheet: 212609d1360174499-would-like-some-help-to-make-my-div-0-equal-0-holiday-tracker-201314
Sheet: Store Overview

Store Holiday Overview 2012/13
 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | P1 | Total
Target Holiday % | 0.041 | 0.0469 | 0.108 | 0.1225 | 0.1229 | 0.1184 | 0.0987 | 0.0871 | 0.0471 | 0.0316 | 0.0873 | 0.0884
Line Managers | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Stock Control - Food | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Stock Control - Non Food | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Checkouts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Services | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Petrol Filling Station | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Produce | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dairy | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bakery | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Counters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Clothing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Electrical & Entertainment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Health & Beauty | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Non Food (Nights) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grocery (Nights) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grocery (Days) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Price Integrity | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dot Com | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Store Contracted Hours | Total Store Holiday Hours Per Period |  |  |  |  |  |  |  |  |  |  |  | Total
3582.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Target Holiday Hours | 587.489 | 672.0301 | 1934.415 | 1755.3025 | 1761.0341 | 2120.692 | 1414.2723 | 1248.0559 | 843.6198750000001 | 452.7964000000001 | 1250.9217 | 1583.3545 | 15623.983375
Total Store Holiday % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0