tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: harry_arora__12153__Option Model - light
Sheet: Prob Model

 | This is a sample model |  |  |  |  | PJM WesternHub
 |  |  |  |  |  |  |  | Over- |  |  |  |  |  |  |  |  |  |  |  |  | Implied | B Model | Implied |  |  | Bid/Offer | Bid/Offer |  | Days | Peak
 | M | T | W | T | F | Prob | Week | Write | Avg | Bid | Ask | Strike | C Bid | C Offer | C Delta | P Bid | P Offer |  | [NAME] |  | Bid Vol | C Bid | [NAME] |  |  | Call | Put | Rate | [NAME] | Days
MA | 36 | 36 | 40 | 48 | 40 | 0.05 | 2001-09-03 00:00:00 |  |  | 38 | 42 | 40 |  |  |  |  |  |  | 2001-09-05 00:00:00 |  | 0.8 |  | 0.8
A | 33 | 34 | 36 | 40 | 38 | 0.35 |  |  |  | 35.5 | 36.5 | 35 |  |  |  |  |  |  |  |  | 0.7 |  | 0.85
N | 30 | 30 | 33 | 35 | 30 | 0.55 |  |  |  | 32.9 | 33.1 | 30 |  |  |  |  |  |  |  |  | 1.5 |  | 0.8
B | 26 | 26 | 28 | 30 | 28 | 0.05 |  |  |  | 27 | 28 | 25 |  |  |  |  |  |  |  |  | 0.6 |  | 0.81
MB | 22 | 22 | 22 | 22 | 22 | 0 |  |  |  | 21 | 23 | 20 |  |  |  |  |  |  |  |  | 0.6 |  | 0.85
MA | 45 | 40 | 38 | 38 | 35 | 0.05 | 2001-09-10 00:00:00 |  |  | 38 | 42 | 40 |  |  |  |  |  |  | 2001-09-12 00:00:00 |  | 0.5 |  | 0.8
A | 38 | 36 | 35 | 35 | 35 | 0.2 |  |  |  | 35 | 36 | 35 |  |  |  |  |  |  |  |  | 0.35 |  | 0.85
N | 33 | 33 | 32 | 32 | 30 | 0.5 |  |  |  | 32.9 | 33.1 | 30 |  |  |  |  |  |  |  |  | 0.2 |  | 0.8
B | 28 | 28 | 26 | 26 | 26 | 0.2 |  |  |  | 26 | 27 | 25 |  |  |  |  |  |  |  |  | 0.2 |  | 0.81
MB | 22 | 22 | 22 | 22 | 22 | 0.05 |  |  |  | 21 | 23 | 20 |  |  |  |  |  |  |  |  | 0.2 |  | 0.85
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Batch Update

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | [NAME]
Activity Description / Purpose | Update daily transactions through a Batch Process
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Review transaction document
Determine if action is needed
Sign transaction document
File hard copy
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: daren_farmer__5382__Monthly Capacity Matrix
Sheet: May 00

Locations | Transport Receipts | Buy | Transport Usage | Net Supply | Transport Deliveries | Sell | Transport Usage | Net Market | Net Throughput
HPL 1 - Thompsonville | 48430 | 193392 |  |  | 2131 | 5153
HPL 14 - South TX |  | 1372 | 0 |  | 75 | 12424 | 0
HPL 18 - Three Rivers | 771 | 5614 |  |  |  | 4689
HPL 21 - Big Cowboy | 630 | 0 |  |  |  | 0 | 9700
HPL 22 - Nueces |  | 0 |  |  | 10000 | 7001 | 50
HPL 2 - Robstown | 5504 | 161130 | 1 |  | 15189 | 23396 | 1
HPL 19 - King Ranch | 85500 | 0 |  |  | 85500 | 1500
HPL 3 - A/S South | 37825 | 80840 |  |  | 10000 | 99
HPL 4 - A/S Central |  | 5000 |  |  | 31000 | 178240
HPL 5 - Edna |  | 22 | 50 |  | 10071 | 54297 | 0
HPL 6 - Texas City | 1311 | 16127 | 6781 |  | 1227 | 152245
HPL 10 - Ship Channel |  | 54516 |  |  | 32700 | 311606 | 400
HPL 15 - Katy | 16585 | 98538 |  |  |  | 48329
HPL 16 - West Loop | 40847 | 150000 | 0 |  |  | 30001 | 0
HPL 17 - East Loop |  | 3670 |  |  | 10000 | 51181
HPL 13 - Mid Texas |  |  |  |  |  |  | 40000
HPL 23 - Bammel |  |  |  |  | 1347 | 56453
HPL 7 - A/S East |  | 1 |  |  |  | 49
HPL 8 - East Texas | 3103 | 177959 | 0 |  | 30299 | 152600 | 5466
HPL 9 - Freeport |  | 5295 | 0 |  | 797 | 30756
HPL 11 - Corpus |  | 1097 |  |  |  | 20020
HPL 12 - Valley |  | 20392 |  |  |  | 4159 | 0
HPL 20 - Hardin |  |  |  |  | 170 | 3201
HPL 24 - Gas Loss |  | 1 |  |  |  | 1560
HPL OffSystem | 5954 | 312 |  |  | 5954 | 11740
Transport Thruput
Net Supply and Market include transportation throughput.
Spreadsheet: 854967d1704721496-no-formula-works-please-help-production-file-2-
Sheet: دفتر التغليف

م | اسم الصنف | نوع الشوكولاتة | [NAME] | الجونش | تاريخ التغليف | القائم بالتغليف | عدد الكراتين | وزن الكرتونة | اجمالي الوزن | ملاحظات
 | بلح ميلك فستق لوز | تروفل ميلك |  |  |  |  | 10 | 6
 |  | [NAME]
 | شنط دارك 55% | [NAME] 55 %
 | شنط دارك 55% | [NAME] 55 %
 | تروفل ميلك بالكاكاو | تروفل ميلك
 | تورتينا ميلك | ميلك بديل
 | تورتينا وايت | [NAME]
Spreadsheet: 120355d1315232529-macro-to-colour-a-cell-test-macro-for-b1-leg
Sheet: Sheet1

Deal Id | Trade id | Counterparty | Book | Type
E12545212B | 123456B | BOOK1234 | BOOK7894 | BERM
E12545212B | 123456B1 | BOOK7894 | BOOK1234 | BERM
E12124542B | 4785923B | BOOK7123 | BOOK7531 | BERM
E12124542B | 4785923B1 | BOOK7531 | BOOK7123 | BERM
E4586523B | 456223B | Orange | BOOK7864 | BERM
E13254323C | 456475B | Apple | BOOK9515 | EURO
E1231234B | 4456523B | Pear | BOOK9515 | BERM
Spreadsheet: 90271d1290022086-excel-2007-summarize-by-average-in-pivot-shows-div-0-callfreqavg_bydowhour
Sheet: Pivot

 | Call Time\Frequency - 12 Month by Hour and Day of Week Daily AVG
 | Count of Request
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Grand Total
 | 12 AM | 1 |  | 6 | 25 |  | 1 |  | 33
 | 1 AM | 1 | 2 |  | 3 | 3 | 1 | 1 | 11
 | 2 AM |  | 2 | 3 | 3 | 1 | 1 | 1 | 11
 | 3 AM |  | 1 | 11 | 9 | 2 | 2 |  | 25
 | 4 AM |  | 2 | 13 | 5 |  |  |  | 20
 | 5 AM |  | 1 | 8 | 2 | 1 |  | 1 | 13
 | 6 AM |  |  | 12 | 5 | 9 | 1 |  | 27
 | 7 AM |  | 19 | 6 | 10 | 22 | 15 | 1 | 73
 | 8 AM |  | 20 | 37 | 13 | 15 | 16 | 2 | 103
 | 9 AM |  | 31 | 47 | 20 | 22 | 14 | 13 | 147
 | 10 AM |  | 19 | 17 | 22 | 7 | 11 | 7 | 83
 | 11 AM | 2 | 26 | 34 | 44 | 18 | 10 | 8 | 142
 | 12 PM |  | 31 | 16 | 34 | 22 | 17 | 13 | 133
 | 1 PM |  | 18 | 31 | 11 | 18 | 1 |  | 79
 | 2 PM |  | 19 | 24 | 18 | 25 | 6 | 1 | 93
 | 3 PM |  | 17 | 45 | 16 | 18 | 15 |  | 111
 | 4 PM |  | 40 | 32 | 27 | 47 | 20 |  | 166
 | 5 PM | 1 | 42 | 8 | 21 | 10 | 15 |  | 97
 | 6 PM |  | 17 | 11 | 10 | 7 | 1 | 5 | 51
 | 7 PM |  | 16 | 11 | 1 |  | 2 |  | 30
 | 8 PM | 2 |  | 2 | 1 |  | 13 |  | 18
 | 9 PM |  |  |  |  | 3 |  |  | 3
 | 10 PM |  |  |  | 1 | 1 | 1 |  | 3
 | 11 PM |  | 2 | 13 | 2 |  |  |  | 17
 | Grand Total | 7 | 325 | 387 | 303 | 251 | 163 | 53 | 1489
Spreadsheet: 91152d1290884903-conditional-formatting-and-buckets-question-buckets
Sheet: Sheet1

 | 1 |  |  | Title: Services
 | 2
 | 3 |  |  | 1 | 5 | 12
 | 4 |  |  | 20 | 45 | 46
 | 5
 | 6
 | 7 |  |  | 1
 | 8
 | 9
 | 10
 | 11
 | 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
 | 53
 | 54
Spreadsheet: 745623d1630065394-how-to-get-a-value-in-excel-based-on-multiple-cells-and-excluding-duplicates-mock-up-1-
Sheet: Sales Orders

[NAME] | Profile | [NAME] | [NAME] | Article | Webinar | Bespoke | Other products
SO45583
SO50232
SO51843
 |  |  |  |  |  |  | *pls note that the sales orders in this tab are unique, but in the LIVE tab we have lots of duplicates, and there we can find the same Sales order on many lines, each of that line can have another product
Spreadsheet: 25ed47dc-389e-416c-995f-ef35e8d7bfea
Sheet: EPR EBITDA FCF

Unaudited Supplemental Data
Reconciliations of GAAP to Non-GAAP Measures (in millions)
Adjusted EBITDA For The Periods Ended September 30,
 | Fourth Quarters |  |  |  | Years
 | 2012 |  | 2011 |  | 2012 |  | 2011
GAAP Income from continuing operations | 90.09999999999985 |  | 59.99999999999989 |  | 249.7000000000003 |  | 292.2999999999998
Other (income) expense, net | 15.6 |  | 16.9 |  | 78.9 |  | 76.99999999999999
Income tax provision | 2.599999999999998 |  | 38.9 |  | 93.1 |  | 135.6
Depreciation and amortization | 61 |  | 60.40000000000001 |  | 240.3 |  | 221.8
Other charges:
Share-based compensation | 7.8 |  | 8.2 |  | 33.2 |  | 39.7
Contingent acquisition related costs | 31.3 |  | 0 |  | 69.1 |  | 0
Impairment and restructuring | 42.5 |  | 15.8 |  | 42.5 |  | 15.8
Adjusted EBITDA | 250.8999999999999 |  | 200.1999999999999 |  | 806.8000000000003 |  | 782.1999999999998
Free Cash Flow For The Years Ended September 30,
 |  |  |  |  | 2012 |  | 2011
GAAP net operating cash flows |  |  |  |  | 446.5000000000002 |  | 612.3999999999999
Investment in property, plant and equipment |  |  |  |  | -43.8 |  | -14.1
Investment in gaming operations equipment |  |  |  |  | -162.4 |  | -189.2
Investment in intellectual property |  |  |  |  | -2.5 |  | -1.8
Free Cash Flow (before dividends) |  |  |  |  | 237.8000000000002 |  | 407.2999999999998
Dividends paid |  |  |  |  | -70.6 |  | -71.7
Free Cash Flow (after dividends) |  |  |  |  | 167.2000000000002 |  | 335.5999999999999
Spreadsheet: 720756d1614276850-can-we-create-a-formula-to-extract-time-from-a-timesheet-and-populate-it-diff-columns-sample-timesheets-with-over-midnight-debcharge-
Sheet: Sheet1

 |  |  | Start time | Finish time | Total hrs | 6am-10pm | 10pm-midnight | 12am-6am
 |  |  |  |  |  | 06:00:00 | 22:00:00 | 0:00:01
 |  |  |  |  |  | 22:00:00 | 23:59:59 | 06:00:00
 |  | 2019-06-27 00:00:00 | 10:30:00 | 15:00:00
 |  | 2019-06-29 00:00:00 | 16:05:00 | 00:50:00
 |  | 2019-06-30 00:00:00 | 11:00:00 | 17:45:00
 |  | 2019-07-01 00:00:00 | 13:35:00 | 22:10:00
 |  | 2019-07-04 00:00:00 | 15:20:00 | 00:05:00
 |  | 2019-07-05 00:00:00 | 14:00:00 | 22:35:00
 |  | 2019-07-06 00:00:00 | 15:20:00 | 23:45:00
 |  | 2019-07-07 00:00:00 | 11:00:00 | 17:15:00
 |  | 2019-07-08 00:00:00 | 14:10:00 | 21:35:00
 |  | 2019-07-11 00:00:00 | 14:05:00 | 00:30:00
Spreadsheet: 872037d1718383261-countifs-issue-sample
Sheet: Data

 |  |  |  |  |  | Result |  | Starting XI |  |  |  |  |  |  |  |  |  |  | Subs |  |  |  |  | Cards
Fixture Date | Team | Opposition | Home / Away | Venue | Competition | Home | Away | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 14 | 15 | 16 | 17 | Yellow | Red
2024-06-13 00:00:00 | U17 | Ballymacash Rangers | Away | Bluebell | SBYL U17 Premier Division | 1 | 4 |  |  |  |  | TP1 |  |  |  |  |  |  |  |  |  |  |  | 1
2024-06-14 00:00:00 | U16 | Knockbreda | Home | [NAME] | NIBFA U16 Cup | 3 | 2 |  |  |  |  | TP1
2024-01-02 00:00:00 | U18 | Welders | Away | Blanchflower | National League U18 | 0 | 1 |  |  |  |  | TP1
2024-02-01 00:00:00 | U20 | PSNI | Home | [NAME] | NIFL U20 League | 2 | 1 |  |  |  |  | TP1
2024-04-25 00:00:00 | U17 | Limavady | Away | Showgrounds | SBYL U17 Premier Division | 2 | 1 |  |  |  |  | TP1
Spreadsheet: 715186d1611594820-help-needed-with-formula-to-count-how-many-times-a-team-wins-power-rankings
Sheet: PR202021

2021-01-25 00:00:00 | RU | FI | SV | DE | CS/SK
1 |  | MTL | MTL | TBL | VGK
2 |  | TOR | VGK | VGK | TBL
3 |  | VGK | TOR | COL | WSH
4 |  | DAL | WSH | WSH | BOS
5 |  | NYI | WPG | PHI | MTL
6 |  | BOS | PIT | BOS | TOR
7 |  | COL | MIN | STL | STL
8 |  | TBL | CBJ | TOR | PHI
9 |  | PIT | BOS | MTL | PIT
10 |  | WPG | TBL | PIT | COL
11 |  | CAR | DAL | DAL | MIN
12 |  | STL | NJD | MIN | CAR
13 |  | MIN | PHI | EDM | DAL
14 |  | WSH | STL | CAR | WPG
15 |  | FLA | BUF | NSH | FLA
16 |  | CBJ | COL | NJD | NJD
Spreadsheet: 866856d1713782627-fomula-for-finding-inserting-data-from-a-prevous-date-previousmeasurement-aligw
Sheet: Sheet1

HoleID | Date | Water  Level Measured Today | Previous Water Level Measurement
H1 | 2024-01-01 00:00:00 | 10
H2 | 2024-01-01 00:00:00 | 20
H3 | 2024-01-01 00:00:00 | 30
H1 | 2024-02-02 00:00:00 | 8
H2 | 2024-02-02 00:00:00 | 18
H3 | 2024-02-02 00:00:00 | 28
H1 | 2024-03-03 00:00:00 | 6
H2 | 2024-03-03 00:00:00 | 16
H3 | 2024-03-03 00:00:00 | 26
Spreadsheet: efd8f661-2e6c-4c32-9733-ec60323a4bde
Sheet: Sheet1

BILL TO: | NARRAGANSETT | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Purchase Order No. | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | REGIONAL SCHOOL DISTRICT
 | 462 Baldwinville Rd.
 | Baldwinville, MA  01436
 | Phone: (978) 939-5661 Fax: (978) 939-5179
Name: |  |  |  |  |  |  | Name:
Attn: |  |  |  |  |  |  | Attn:
Address: |  |  |  |  |  |  | Address:
City: |  | State: |  | Zip: |  |  | City: |  | State: |  | Zip:
 |  |  |  |  |  |  | Phone:
Vendor Fax: |  | Phone:
Date of Request |  | Requistioned By |  |  |  |  | Date of Order |  | Account To Be Charged
Qty | Description |  |  |  |  |  |  | Unit Price |  | Extended Price
 | 0 |  |  |  |  |  |  | TOTAL |  | 0
Signature of Building Principal or Administrator |  |  |  |  | Date |  | Signature of Superintendent of Schools |  |  |  |  | Date
Signature of Chief Procurement Officer |  |  |  |  | Date
 | Vendor's Copy |  |  | Receiving Copy |  |  | Acct. Office Copy |  |  | Principal's Copy
 |  |  |  |  |  | NRSD Purchase Order, Page 2 of 2
Vendor Name: |  |  |  |  |  |  | PO Number (from pg.1)
Date of Request |  | Requistioned By |  |  |  |  | Date of Order |  | Account To Be Charged
Qty | Description |  |  |  |  |  |  | Unit Price |  | Extended Price
 |  |  |  |  |  |  |  | SUBTOTAL |  | 0
 |  |  |  |  |  |  |  | TOTAL |  | 0
Signature of Building Principal or Administrator |  |  |  |  | Date |  | Signature of Superintendent of Schools |  |  |  |  | Date
Signature of Chief Procurement Officer |  |  |  |  | Date
 | Vendor's Copy |  |  | Receiving Copy |  |  | Acct. Office Copy |  |  | Principal's Copy
Spreadsheet: 826051d1681751632-need-help-with-a-formula-that-will-reallocate-hours-worked-based-on-home-location-employee-time-detail-reallocation-
Sheet: Sheet1

 | ORIGINAL REPORT |  |  |  |  |  |  |  |  |  |  |  |  | "Desired" REALLOCATION REPORT
 | Date | Location Name | Time In | Time Out | Total Time | Regular Hours | Regular Wages ($) | OT Hours | OT Wages ($) | Total Wages ($) | Rate ($) | Home Location |  | Date | Location Name | Time In | Time Out | Total Time | Regular Hours | Regular Wages ($) | OT Hours | OT Wages ($) | Total Wages ($) | Rate ($) | Home Location
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME]
 | 2023-04-02 00:00:00 | 348873 - 978 Worcester St | 03:56:00 | 14:59:00 | 11.05 | 11.05 |  |  |  |  | 17 | 303453 - 951 Worcester St |  | 2023-04-02 00:00:00 | 348873 - 978 Worcester St | 03:56:00 | 14:59:00 | 11.05 |  |  | 11.05 |  |  | 17 | 303453 - 951 Worcester St
 | 2023-04-03 00:00:00 | 303453 - 951 Worcester St | 03:53:00 | 14:04:00 | 10.18 | 10.18 |  |  |  |  | 17 | 303453 - 951 Worcester St |  | 2023-04-03 00:00:00 | 303453 - 951 Worcester St | 03:53:00 | 14:04:00 | 10.18 | 10.18 |  |  |  |  | 17 | 303453 - 951 Worcester St
 | 2023-04-04 00:00:00 | 331381 - 12 Washington St | 03:59:00 | 14:43:00 | 10.73 | 10.73 |  |  |  |  | 17 | 303453 - 951 Worcester St |  | 2023-04-04 00:00:00 | 331381 - 12 Washington St | 03:59:00 | 14:43:00 | 10.73 |  |  | 10.73 |  |  | 17 | 303453 - 951 Worcester St
 | 2023-04-05 00:00:00 | 331381 - 12 Washington St | 03:58:00 | 14:05:00 | 10.12 |  |  |  |  |  | 17 | 303453 - 951 Worcester St |  | 2023-04-05 00:00:00 | 331381 - 12 Washington St | 03:58:00 | 14:05:00 | 10.12 |  |  | 10.12 |  |  | 17 | 303453 - 951 Worcester St
 | 2023-04-06 00:00:00 | 303453 - 951 Worcester St | 03:52:00 | 14:31:00 | 10.65 |  |  |  |  |  | 17 | 303453 - 951 Worcester St |  | 2023-04-06 00:00:00 | 303453 - 951 Worcester St | 03:52:00 | 14:31:00 | 10.65 |  |  | 2.13 |  |  | 17 | 303453 - 951 Worcester St
 | 2023-04-07 00:00:00 | 303453 - 951 Worcester St | 03:49:00 | 14:59:00 | 11.17 |  |  |  |  |  | 17 | 303453 - 951 Worcester St |  | 2023-04-07 00:00:00 | 303453 - 951 Worcester St | 03:49:00 | 14:59:00 | 11.17 | 11.17 |  |  |  |  | 17 | 303453 - 951 Worcester St
 | 2023-04-08 00:00:00 | 303453 - 951 Worcester St | 03:53:00 | 14:01:00 | 10.13 |  |  |  |  |  | 17 | 303453 - 951 Worcester St |  | 2023-04-08 00:00:00 | 303453 - 951 Worcester St | 03:53:00 | 14:01:00 | 10.13 | 10.13 |  |  |  |  | 17 | 303453 - 951 Worcester St
 | Employee Totals |  |  |  |  |  |  |  |  |  | 17 |  |  | Employee Totals |  |  |  |  |  |  |  |  |  | 17
Spreadsheet: darrell_schoolcraft__7319__imball0202
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -246404 | -244010
2 | -244917 | -244299
3 | -242647 | -242291
4 | -244008 | -243254
5 | -246342 | -243974
6 | -251402 | -250987
7 | -248856 | -248311
8 | -264991 | -264300
9 | -253917 | -251967
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 28722
2002-02-09 00:00:00
CBS Dollars
 |  |  | -143669
Spreadsheet: 271046d1381792923-help-on-sumif-statement-mai-baltic-leave
Sheet: Leave Summary

 | Vacation Leave Summary
 | Vacation Days | Number Eligible | Total Days | Days Remaining
 | 15-day
 | 5-day
 | None |  | 0
 | Total
Spreadsheet: 160662d1339161408-count-of-style-in-a-range-of-sale-contribution-book3-test
Sheet: Contribution

Total Sales
3147815
% | 0.2 | 0.25 | 0.5 | 0.75 | 0.9 | 1
Row Position | 12 | 17 | 54 | 131 | 243 | 630
 | SALES | 0% - 20% | 0% - 25% | 0% - 50% | 0% - 75% | 0% - 90% | 0% - 100%
CUMULATIVE | Styles | 12 | 17 | 54 | 131 | 243 | 630
 | Sales $ | 609570 | 764872 | 1563204 | 2357857 | 2832351 | 3147815
 | Sales $ / style | 50797.5 | 44992.47058823529 | 28948.22222222222 | 17998.90839694656 | 11655.76543209877 | 4996.531746031746
SALES | 0%-20% | 21%-25% | 26%-50% | 51%-75% | 76%-90% | 91%-100% | TOTAL
Styles | 12 | 5 | 37 | 77 | 112 | 387 | 630
Sales $ | 609570 | 155302 | 798332 | 794653 | 474494 | 315464 | 3147815
Sales $ / style | 50797.5 | 31060.4 | 21576.54054054054 | 10320.16883116883 | 4236.553571428572 | 815.1524547803617 | 4996.531746031746
Sales Units | 32003 | 7555 | 32748 | 29810 | 21628 | 24520 | 148264
EOH Units | 269446 | 56306 | 269651 | 270516 | 233512 | 376593 | 1476024
AVG WOS | 8.419398181420492 | 7.452812706816678 | 8.234121167704899 | 9.074672928547468 | 10.79674496023673 | 15.35860522022839 | 9.9553768952679
Styles under AVG WOS | 8 | 3 | 25 | 39 | 73 | 284 | 432
Styles over AVG WOS | 4 | 2 | 12 | 38 | 39 | 103 | 198
 | OK, Right |  |  | Should be 4
 |  |  |  | Should be 1
Spreadsheet: 120860d1315589905-column-into-several-rows-examble
Sheet: Taul1

1 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
2 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
3 |  | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48
4 |  | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66
5
6
7
8
9
10
11
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
Spreadsheet: 183428d1348828877-pivot-table-w-multiple-duplicate-identiier-pivot-20test-1-
Sheet: Open Bal Data

PjM | Project Number | Project Name | [NAME] | Region | WA Amount (Pending or Approved) | Invoices (Pending or Approved) | WA CO Balance | [NAME] | ODD - ACTUAL START/FINISH |  | Row Labels | Count of Project Name
[NAME] | 10002694 | A | ADELHARDT CONSTRUCTION CORP | West | 10000 | 10000 |  | Zero Balance | 2012-08-28 00:00:00 |  | Central | 11
[NAME] | 10002694 | A | ARCADIS US INC | West | 20000 | 20000 |  | Zero Balance | 2012-08-28 00:00:00 |  | D | 4
[NAME] | 10002694 | A | GENSLER | West | 30000 | 30000 |  | Zero Balance | 2012-08-28 00:00:00 |  | E | 7
[NAME] | 10002694 | A | GMR PROTECTION RESOURCES INC | West | 40000 | 40000 |  | Zero Balance | 2012-08-28 00:00:00 |  | West | 13
[NAME] | 10002694 | A | PROJECT EXPEDITERS INC | West | 50000 | 50000 |  | Zero Balance | 2012-08-28 00:00:00 |  | A | 5
[NAME] | 10002694 | B | RIKER DANZIG SCHERER [NAME] | West | 60000 | 58000 |  | >$0.00 < $1,000 | 2012-08-28 00:00:00 |  | B | 2
[NAME] | 10002694 | B | SECURITY VAULT WORKS INC | West | 70000 | 50000 |  | >$2,500 | 2012-08-28 00:00:00 |  | C | 5
[NAME] | 10003840 | C | GENSLER | West | 80000 | 50000 |  | >$2,500 | 2011-12-13 00:00:00 |  | D | 1
[NAME] | 10003840 | C | GMR PROTECTION RESOURCES INC | West | 90000 | 50000 |  | >$2,500 | 2011-12-13 00:00:00 |  | Grand Total | 24
[NAME] | 10003840 | C | ICON IDENTITY SOLUTIONS | West | 100000 | 50000 |  | >$2,500 | 2011-12-13 00:00:00
[NAME] | 10003840 | C | LECHASE CONSTRUCTION SERVICES | West | 110000 | 50000 |  | >$2,500 | 2011-12-13 00:00:00
[NAME] | 10003840 | C | PROJECT EXPEDITERS INC | West | 120000 | 50000 |  | >$2,500 | 2011-12-13 00:00:00
AL | 10003956 | D | BNF CONTRACTORS INC | West | 130000 | 50000 |  | >$2,500 | 2012-08-06 00:00:00
AL | 10003956 | D | GENSLER | Central | 140000 | 50000 |  | >$2,500 | 2012-08-06 00:00:00
AL | 10003956 | D | GMR PROTECTION RESOURCES INC | Central | 150000 | 50000 |  | >$2,500 | 2012-08-06 00:00:00
AL | 10003956 | D | ICON IDENTITY SOLUTIONS | Central | 160000 | 50000 |  | >$2,500 | 2012-08-06 00:00:00
AL | 10003956 | D | PROJECT EXPEDITERS INC | Central | 170000 | 50000 |  | >$2,500 | 2012-08-06 00:00:00
[NAME] | 10005325 | E | ADT SECURITY SVCS INC | Central | 180000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | GENSLER | Central | 190000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | GMR PROTECTION RESOURCES INC | Central | 200000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | GRACE CONSTRUCTION MANAGEMENT | Central | 210000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | ICON IDENTITY SOLUTIONS | Central | 220000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | IDX CORP | Central | 230000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00
[NAME] | 10005325 | E | PROJECT EXPEDITERS INC | Central | 240000 | 50000 |  | >$2,500 | 2012-07-13 00:00:00