tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86857d1286817557-downcount-of-days-left-in-one-month-networkdays
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  | 9
Spreadsheet: mary_fischer__25623__31Y
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031Y
COMPANY NAME  The LINC Corp Holding Company
ANALYSIS OF OTHER CURRENT LIABILITIES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: 190772d1351785789-averaging-values-certain-of-days-in-the-past-sample_data
Sheet: Sheet3

Date | Ref | Test
2000-01-05 00:00:00 | 0.2618549194502592
2000-01-05 00:00:00 | 0.1621994043650264
2000-01-05 00:00:00 | 0.02643539560337626
2000-01-07 00:00:00 | -0.09670329670329668
2000-01-10 00:00:00 | 0.04381454251838002 | Pull value for average of values 4 weekdays days earlier, or if no values on that day, whatever the next previous day is…i.e. in this case, I would want average of values on 1/6, but there are none, so rather average of values on 1/5…0.26. 0.16, 0.03
2000-01-11 00:00:00 | -0.1433610481229528
2000-01-13 00:00:00 | -0.06698853349426671
2000-01-14 00:00:00 | 0.1924502864846647
2000-01-21 00:00:00 | -0.05740181268882173
2000-01-21 00:00:00 | -0.1133471933471933
2000-01-21 00:00:00 | -0.04748049199841313
2000-01-21 00:00:00 | 0.01128503822351665
2000-01-21 00:00:00 | -0.05795918367346946
2000-01-24 00:00:00 | -0.2901222588783234
2000-01-25 00:00:00 | -0.1125521074571561
2000-01-25 00:00:00 | -0.04258390472753518
2000-01-26 00:00:00 | -0.1612223393045311
2000-01-27 00:00:00 | 0.1406573882143915
2000-01-31 00:00:00 | -0.01362397820163483
Spreadsheet: 834711d1688027169-require-help-in-multiple-vlookup-tasl-pan-india-dispatch-report-working
Sheet: Dashboard

 | Plan Vs Dispatch 2023-2024 |  |  |  |  |  |  |  | Store Supply Performance
 | Customer | Planned Volume | Indent YTD | Dis. YTD | GRN YTD | Indent Pending | Dis. Pending |  | State | Stores | Dis.Qty | AVG TPOD | Solid | GRN Qty | GRN%
 | ITC FBD |  |  |  |  |  |  |  | WB | MMMCCL
 | Haldiram Noida |  |  |  |  |  |  |  | WB | SGS
 | [NAME] |  |  |  |  |  |  |  | WB | NB
 | [NAME] |  |  |  |  |  |  |  | Total
 | Tulsi Speciality Guwahati
 | Terrestrial Foods GK
 | Total |  |  |  |  |  |  |  | Store Supply Performance
 |  |  |  |  |  |  |  |  | State | Stores | Dis.Qty | AVG TPOD | Solid | GRN Qty | GRN%
 | Today`s Indent |  |  |  |  |  |  |  | GJ | WC
 | Customer | Indent |  |  |  |  |  |  | GJ | SA
 | ITC FBD Coimbatore |  |  |  |  |  |  |  | GJ | MCS
 | ITC FBD Guwahati |  |  |  |  |  |  |  | GJ | KP
 | ITC FBD Haridwar |  |  |  |  |  |  |  | GJ | JG
 | ITC FBD Medak |  |  |  |  |  |  |  | GJ | GC
 | ITC FBD Mysore |  |  |  |  |  |  |  | GJ | SM
 | ITC FBD Panchla |  |  |  |  |  |  |  | GJ | GP
 | ITC FBD Pune |  |  |  |  |  |  |  | Total
 | ITC [NAME]
 | ITC FBD Vijayawada
 | Haldiram Noida
 | [NAME]
 | [NAME]
 | Tulsi Speciality Guwahati
 | Terrestrial Foods GK
 | Total
 | Plant [NAME]
 | Plant |  | TC1 | TC3 | TC10 | 5147 | 5158 | 5177 | 6026 | Hermes | Taurus | Taurus(F) | Winner | LR | Trial
 | ITC FBD Coimbatore
 | ITC FBD Guwahati
 | ITC FBD Haridwar
 | ITC FBD Medak
 | ITC FBD Mysore
 | ITC FBD Panchla
 | ITC FBD Pune
 | ITC [NAME]
 | ITC FBD Vijayawada
 | Haldiram Noida
 | [NAME]
 | [NAME]
 | Tulsi Speciality Guwahati
 | Terrestrial Foods GK
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: DX04 JFK

 |  |  |  |  | DX04 [NAME]
Registration number : | DX04 [NAME] |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2004-02-27 00:00:00 | 12 Months | 2005-03-01 00:00:00 | 1238
Specification : | 6 x 2 A (3 Axle) |  | 2005-02-28 00:00:00 | 12 Months | 2006-03-01 00:00:00 | 1200
Type : | FTG XF95.430 |  | 2006-02-28 00:00:00 | 12 Months | 2007-03-01 00:00:00 | 1200
1st Registered : | 01.03.04 |  | 2007-02-28 00:00:00 | 12 Months | 2008-03-01 00:00:00 | 1200
Engine : | XE CI 12.60 litre |  | 2008-02-29 00:00:00 | 12 Months | 2009-03-01 00:00:00 | 1200
[NAME] : | 44,000kg |  | 2009-02-27 00:00:00 | 12 Months | 2010-03-01 00:00:00 | 1200
 |  |  | 2010-02-26 00:00:00 | 12 Months | 2011-03-01 00:00:00 | 1200
 |  |  | 2011-02-28 00:00:00 | 12 Months | 2012-03-01 00:00:00 | 1200
 |  |  | 2011-11-29 00:00:00 | 12 Months | 2012-03-01 00:00:00 | 700 (RP HGV)
Back To Index |  |  | Exchange tax disc from HGV to RP HGV Euro 3 to Euro 4 by Eminox
 |  |  | 2012-02-29 00:00:00 | 12 Months | 2013-03-01 00:00:00 | 700
Spreadsheet: 816743d1675803303-use-a-conditional-formula-for-duplicates-duplicates-etaf
Sheet: Sheet1

name1
[NAME]
name3
[NAME]
name3
name12
name5
name24
name7
name3
name4
name5
name6
name7
Spreadsheet: 93437d1293021029-formula-needed-to-fetch-data-from-different-worksheets-and-include-adjacent-cells-copy-of-core-staff-leave-2010
Sheet: DS

DS
HOLIDAYS
2010
Monday | 1900-08-09 00:00:00 | DS |  |  | HOLIDAYS TAKEN
Tuesday | 1900-08-10 00:00:00 | DS
Wednesday | 1900-08-11 00:00:00 | DS |  |  | HOLIDAY ENTITLEMENT | 14 | D.O.S 28/06/2010: 28 DAYS (ANNUAL ENTITLEMENT) / 12 MONTHS X 6 MONTHS
Thursday | 1900-08-12 00:00:00 | DS
Friday | 1900-08-13 00:00:00 | DS |  |  | BALANCE C/FWD 2011
Monday | 1900-08-16 00:00:00 | DS
Tuesday | 1900-08-17 00:00:00 | DS
Wednesday | 1900-08-18 00:00:00 | DS
Monday | 1900-08-30 00:00:00 | DS | STATUTORY HOLIDAY
Wednesday | 1900-12-22 00:00:00 | DS
Monday | 1900-12-27 00:00:00 | DS | STATUTORY HOLIDAY
Tuesday | 1900-12-28 00:00:00 | DS | STATUTORY HOLIDAY
Wednesday | 1900-12-29 00:00:00 | DS
Thursday | 1900-12-30 00:00:00 | DS
 |  |  | HOLIDAYS TAKEN
Spreadsheet: 537173d1504857411-forumal-assistance-excel-template
Sheet: Performance Tracking

Performance Area | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Quality |  |  |  |  |  |  | 0.6533 | 0.95
PKA |  |  |  |  |  |  | 0.95 | 0.95
FCR |  |  |  |  |  |  | 0.9127 | 0.9577
VOC |  |  |  |  |  |  | 0.75
Telephone costs |  |  |  |  |  |  | 94.17 | 24.27
Service failures |  |  |  |  |  |  | 0 | 0
Compliance assessments
Leave management
CMM PKA
Key Performance Target Ratings
Performance Area | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Quality
PKA
FCR
VOC
Telephone costs
Service failures
Compliance assessments
Leave management
Service failures
Compliance assessments
Leave management
Spreadsheet: 102118d1300151180-help-with-comparison-chart-pivot-table-copy-of-sample-coursework-sample
Sheet: Sheet1

Lastname | Firstname | Course Name | status |  | Required Course Name
Smith | [NAME] | Accelerated NCDA Course | completed |  | Accelerated NCDA Course
Smith | [NAME] | Accelerated NCDA Preassessment | completed |  | Accelerated NCDA Preassessment
Smith | [NAME] | An Introduction to Hardware | completed |  | An Introduction to Hardware
Smith | [NAME] | An Introduction to  Software | completed |  | An Introduction to  Software
Smith | [NAME] | Fast Track 101 | still to do |  | Fast Track 101
Smith | [NAME] | Data Integration | still to do |  | Data Integration
Smith | [NAME] | Presentation and Design Concepts | still to do |  | Presentation and Design Concepts
Smith | [NAME] | Advanced Software Techniques | still to do |  | Advanced Software Techniques
Smith | [NAME] | Advanced Hardware Techniques | still to do |  | Advanced Hardware Techniques
Smith | [NAME] | Deployment | still to do |  | Deployment
Smith | [NAME] | Planning | still to do |  | Planning
Smith | [NAME] | Troubleshooting | still to do |  | Troubleshooting
Jones | [NAME] | Fast Track 101 | completed
Jones | [NAME] | Accelerated NCDA Course | completed
Jones | [NAME] | Accelerated NCDA Preassessment | completed
Jones | [NAME] | An Introduction to Hardware | completed
Completed Courses
[NAME]
Smith
completed
Accelerated NCDA Course
Accelerated NCDA Preassessment
An Introduction to  Software
An Introduction to Hardware
still to do
Advanced Hardware Techniques
Advanced Software Techniques
Data Integration
Deployment
Fast Track 101
Planning
Presentation and Design Concepts
Troubleshooting
[NAME]
Jones
completed
Accelerated NCDA Course
Accelerated NCDA Preassessment
An Introduction to Hardware
Fast Track 101
Spreadsheet: 00023b08-3cbb-4619-ae3a-e0e5cf10d577
Sheet: Groups

 | Visual Properties |  |  |  | [NAME] | Layout |  | Do Not Edit |  | Graph Metrics
Group | Vertex Color | Vertex Shape | Visibility | Collapsed? | Label | Collapsed X | Collapsed Y | ID | Collapsed Properties | Vertices | Unique Edges | Edges With Duplicates | Total Edges | Self-Loops | Reciprocated Vertex Pair Ratio | Reciprocated Edge Ratio | Connected Components | Single-Vertex Connected Components | Maximum Vertices in a Connected Component | Maximum Edges in a Connected Component | Maximum Geodesic Distance (Diameter) | Average Geodesic Distance | Graph Density | [NAME] in Tweet
[NAME] | 0, 12, 96 | Disk |  |  | [NAME] obama2012 [NAME] heardaboutharry obama forward seniors latinos fl |  |  | 3 |  | 78 | 499 | 56 | 555 | 119 | 0.5371024734982333 | 0.6988505747126437 | 1 | 0 | 78 | 555 | 4 | 2.309665 | 0.07242757242757243 | [NAME] obama2012 [NAME] heardaboutharry obama forward seniors latinos fl
G2 | 0, 136, 227 | Disk |  |  | releasethemnow obama2012 romney edshow gopfail mapoli gop p2 2012elections releasethereturns |  |  | 4 |  | 63 | 366 | 40 | 406 | 82 | 0.4459459459459459 | 0.616822429906542 | 1 | 0 | 63 | 406 | 4 | 2.160746 | 0.08218125960061444 | releasethemnow obama2012 romney edshow gopfail mapoli gop p2 2012elections releasethereturns
G3 | 0, 100, 50 | Disk |  |  | romneyshambles romney mittthetwit showusthetaxreturns smallestviolin whyhide gop obama 2012elections releasethereturns |  |  | 5 |  | 21 | 16 | 12 | 28 | 28 | Not Applicable | Not Applicable | 21 | 21 | 1 | 3 | 0 | 0 | 0 | romneyshambles romney mittthetwit showusthetaxreturns smallestviolin whyhide gop obama 2012elections releasethereturns
G4 | 0, 176, 22 | Disk |  |  | mapoli |  |  | 6 |  | 20 | 49 | 10 | 59 | 19 | 0.2758620689655172 | 0.4324324324324325 | 1 | 0 | 20 | 59 | 6 | 2.51 | 0.09736842105263158 | mapoli
G5 | 191, 0, 0 | Disk |  |  | obama2012 tcot p2 obots clue |  |  | 7 |  | 6 | 3 | 20 | 23 | 11 | 0.2 | 0.3333333333333333 | 1 | 0 | 6 | 23 | 4 | 1.777778 | 0.2 | obama2012 tcot p2 obots clue
G6 | 230, 120, 0 | Disk |  |  | wakeup |  |  | 8 |  | 2 | 1 | 2 | 3 | 2 | 0 | 0 | 1 | 0 | 2 | 3 | 1 | 0.5 | 0.5 | wakeup
G7 | 255, 191, 0 | Disk |  |  |  |  |  | 9 |  | 2 | 0 | 8 | 8 | 4 | 0 | 0 | 1 | 0 | 2 | 8 | 1 | 0.5 | 0.5
Spreadsheet: 66310d1266998712-excel-2007-wrapped-text-not-showing-up-sample-problem
Sheet: Fixed Spreadsheet

FIXED ESTIMATE SPREADSHEET            (Office Use Only)
Name: |  | Date:
Address: |  | Job Description:
ITEM | [NAME] | MATERIAL | LABOR | ALLOWANCES | TOTAL+MKUP
1 | PLANS & PERMITS
2 | DECORATOR/INTERIOR DESIGNER
3 | SITE PREP & DEMO/WASTE REMOVAL
4 | EXCAVATION & DRAINAGE
5 | FOUNDATION & CONCRETE
6 | MASONRY & CAST STONE
7 | FRAMING & EXTERIOR TRIM
8 | HVAC
9 | PLUMBING
10 | ELECTRIC/PHONE/CABLE/SECURITY
11 | INSULATION
12 | DRYWALL
13 | WINDOWS
14 | DOORS
15 | CABINETRY
16 | MILLWORK & TRIM
17 | HARDWARE
18 | COUNTERTOPS
19 | TILE
20 | GLASS & MIRRORS
21 | FLOORING
22 | APPLIANCES
23 | PAINT & PAPER
24 | ROOFING & GUTTERING
25 | EQUIPMENT RENTAL
26 | FENCE & IRON WORK
27 | POOLS/SPA
28 | DECKS/ARBORS
29 | LANDSCAPING & IRRIGATION SYSTEM
30 | SPECIALTY ITEMS
31 | SUPERVISION
32
 | Total Project Costs
Spreadsheet: 879549d1727124233-count-data-exclude-duplicates-sample-count-v2
Sheet: Sheet1

Location | Store Count 1 | Store Count 2
Hong Kong | 1 | 1
NY | 1 | 1
NY | 1 | 1
LA | 1
Portland | 1
NY | 1 | 1
Dallas | 1 | 1
London | 1
Sao Paolo | 1
Amsterdam | 1 | 1
Amsterdam | 1 | 1
Spreadsheet: a67855df-05ef-4b2b-8463-daa269dab0c5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8748 | 28253 | Margarita | Ovsyannikva | RUS | 55 | [NAME] | 00:00:34 | 00:30:41 | 00:00:56 | 00:26:25 | 1 | 01:25:45
8748 | 68545 | Tatiana | Bregeda | RUS | 54 | 00:29:01 | 00:00:38 | 00:31:34 | [NAME] | 00:25:16 | 2 | 01:27:25
8748 | 28191 | Greta | Vettorata | ITA | 57 | 00:30:10 | [NAME] | 00:38:06 | 00:01:17 | 00:32:18 | 3 | 01:42:46
8748 | 46060 | Ilaria | Titone | ITA | 56 | 00:31:42 | 00:00:34 | 00:35:35 | 00:01:21 | 00:38:16 | 4 | [NAME]
Spreadsheet: 34571d1231879033-picking-random-cell-from-range-day-shift-online-
Sheet: Sheet1

Day Shift Rota
Shift Commencing: |  | 2009-01-14 00:00:00
2009-01-14 00:00:00
Staff a | 08:00:00 | 16:00:00
Staff b | 08:30:00 | 16:30:00
Staff c | 09:00:00 | 17:00:00
Staff d | FLOAT | FLOAT
Staff e | FLOAT | FLOAT
2009-01-15 00:00:00
Staff a | 08:00:00 | 16:00:00
Staff b | 08:30:00 | 16:30:00
Staff c | 09:00:00 | 17:00:00
Staff d | FLOAT | FLOAT
Staff e | FLOAT | FLOAT
2009-01-16 00:00:00
Staff a | 08:00:00 | 16:00:00
Staff b | 08:30:00 | 16:30:00
Staff c | 09:00:00 | 17:00:00
Staff d | FLOAT | FLOAT
Staff e | FLOAT | FLOAT
2009-01-19 00:00:00
Staff a | 08:00:00 | 16:00:00
Staff b | 08:30:00 | 16:30:00
Staff c | 09:00:00 | 17:00:00
Staff d | FLOAT | FLOAT
Staff e | FLOAT | FLOAT
2009-01-20 00:00:00
Staff a | 08:00:00 | 16:00:00
Staff b | 08:30:00 | 16:30:00
Staff c | 09:00:00 | 17:00:00
Staff d | FLOAT | FLOAT
Staff e | FLOAT | FLOAT
Spreadsheet: chris_germany__2912__Plant Fuel 02 2000
Sheet: Mar 00

Date | lbs 1CT oil | lbs 1 DB oil | lbs 2 CT oil | lbs 2 DB oil | lbs Aux. Blr oil | daily oil mmbtu | daily oil gallons | Fuel Tank Level | Oil Deliv. Gallons | Trucks | lbs 1 CT gas | lbs 1 DB gas | lbs 2 CT gas | lbs 2 DB gas | lbs Aux. Blr gas | Daily gas mmbtu
2000-03-01 00:00:00
2000-03-02 00:00:00
2000-03-03 00:00:00
2000-03-04 00:00:00
2000-03-05 00:00:00
2000-03-06 00:00:00
2000-03-07 00:00:00
2000-03-08 00:00:00
2000-03-09 00:00:00
2000-03-10 00:00:00
2000-03-11 00:00:00
2000-03-12 00:00:00
2000-03-13 00:00:00
2000-03-14 00:00:00
2000-03-15 00:00:00
2000-03-16 00:00:00
2000-03-17 00:00:00
2000-03-18 00:00:00
2000-03-19 00:00:00
2000-03-20 00:00:00
2000-03-21 00:00:00
2000-03-22 00:00:00
2000-03-23 00:00:00
2000-03-24 00:00:00
2000-03-25 00:00:00
2000-03-26 00:00:00
2000-03-27 00:00:00
2000-03-28 00:00:00
2000-03-29 00:00:00
2000-03-30 00:00:00
2000-03-31 00:00:00
mmbtu
gallons
Spreadsheet: 685238d1593838450-using-nested-ifs-to-enter-text-based-on-partial-text-in-another-cell-ifs_search_sample
Sheet: 6-BS

 | CPR - Coon's Parenting Resource
 | [NAME] To: |  |  |  | Invoice #:
 | Address: |  |  |  | Invoice Date: | 2020-07-03 00:00:00
 |  |  | [NAME]: | 75
 | Item # | Date / Description | Qty | Unit Price | Discount | Price
 |  |  |  |  | Invoice Subtotal
 |  |  |  |  | Other
 |  |  |  |  | Deposit Received
 |  |  |  |  | TOTAL
To start new Paragraph - Press Alt + Enter
Spreadsheet: 192993d1352679518-auto-filling-a-form-with-conditions-tracking-form
Sheet: Sheet1

PO Number | Status | Ship Date | Tracking Number
101 | Not Done | N/A | N/A
102 | Done | 2012-10-31 00:00:00 | 1234567
103 | Not Done | N/A | N/A
104 | Done | 2012-11-05 00:00:00 | 7654321
Spreadsheet: 513271bc-97be-4e2e-9ac5-16c0a4c00996
Sheet: Freading eBooks

Freading eBooks 2014
 | Patrons | Circulations |  | Tokens Used | Top Book | Number of Titles
 |  | Total | Daily Average |  |  | 39750 | *Jan3, 2014
January | 267 | 882 | 28 | 1408 | The Snow Dance
February | 191 | 617 | 22 | 976 | A Pocket Can Have a Treasure in It
March | 186 | 599 | 19 | 926 | Twelve Years a Slave | 48723 | *Mar 28, 2014
April | 170 | 478 | 16 | 939 | Twelve Years a Slave
May | 163 | 556 |  | 1123 | Twelve Years a Slave
June | 110 | 401 |  | 689 |  | 48979 | *June 27, 2014
July | 111 | 384 |  | 668
August | 98 | 409 |  | 776 | [NAME]
September | 99 | 417 |  | 756 | Season of Storms (Kearsley) | 52510 | *Sept 26, 2014
October
November
December
Year to date
Notes
Tokens cost 50 cents each.
Patron stats--we can only see how many unique patrons used Freading during a given time period, so:
 | we run this monthly for a monthly number
 | run it at the end of the year for a full year number of unique users, this should be our total year of patrons.
Number of titles available requested quarterly from Freading.  Date of Freading report will be noted at the side.*
Spreadsheet: 139671d1328374086-please-help-me-with-this-chart-not-sure-where-to-start-machine-problem
Sheet: Data Entry

date | week | month | year | Machine Number | Die problem | material problem | conveyor problem | glued pin problem | weighing problem
2012-02-01 00:00:00 |  |  |  | 1 |  | 1
2012-02-01 00:00:00 |  |  |  | 2
2012-02-01 00:00:00 |  |  |  | 3 | 1 |  | 1
2012-02-01 00:00:00 |  |  |  | 4 |  |  |  |  | 1
2012-02-01 00:00:00 |  |  |  | 5 |  |  |  | 1
2012-02-01 00:00:00 |  |  |  | 6 |  | 1
2012-02-02 00:00:00 |  |  |  | 1
2012-02-02 00:00:00 |  |  |  | 2 | 1 |  | 1
2012-02-02 00:00:00 |  |  |  | 3 |  |  |  |  | 1
2012-02-02 00:00:00 |  |  |  | 4 |  |  |  | 1
2012-02-02 00:00:00 |  |  |  | 5 |  | 1
2012-02-02 00:00:00 |  |  |  | 6
2012-02-03 00:00:00 |  |  |  | 1 | 1 |  | 1
2012-02-03 00:00:00 |  |  |  | 2 |  |  |  |  | 1
2012-02-03 00:00:00 |  |  |  | 3 |  |  |  | 1
2012-02-03 00:00:00 |  |  |  | 4 |  | 1
2012-02-03 00:00:00 |  |  |  | 5
2012-02-03 00:00:00 |  |  |  | 6 | 1 |  | 1
2012-02-04 00:00:00 |  |  |  | 1 |  |  |  |  | 1
2012-02-04 00:00:00 |  |  |  | 2 |  |  |  | 1
2012-02-04 00:00:00 |  |  |  | 3 |  | 1
2012-02-04 00:00:00 |  |  |  | 4
2012-02-04 00:00:00 |  |  |  | 5 | 1 |  | 1
2012-02-04 00:00:00 |  |  |  | 6 |  |  |  |  | 1
2012-02-05 00:00:00 |  |  |  | 1 |  |  |  | 1
2012-02-05 00:00:00 |  |  |  | 2
2012-02-05 00:00:00 |  |  |  | 3 |  | 1
2012-02-05 00:00:00 |  |  |  | 4
2012-02-05 00:00:00 |  |  |  | 5 | 1 |  | 1
 |  |  |  | 6 |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
Spreadsheet: darrell_schoolcraft__7445__imball0202
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -13510 | -13500
2 | -19133 | -19000
3 | -17376 | -17500
4 |  | -2500
5 | -6727 | -5000
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
2002-01-31 00:00:00 |  |  | -135557
2002-02-05 00:00:00
CBS Volume
 |  |  | -67034
Spreadsheet: richard_shapiro__32163__CE2 Pack Template 2506 (FINAL VERSION)
Sheet: Appendices Qtr

YTD Actual | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
 | Actual Headcount
YTD Budget | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
 | Forecast Headcount
YTD Variance | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
 | Headcount Variance
Spreadsheet: 880608d1728420087-find-latest-date-in-excel-based-on-multiple-conditions-testing-example
Sheet: Sheet3

Test | Date | Done | NEED
ABC | 2024-08-01 00:00:00 | Open | Most Recent
ABC | 2024-07-01 00:00:00 | Closed
ABC | 2024-06-01 00:00:00 | Closed
LMN | 2024-02-02 00:00:00 | Closed
LMN | 2024-03-02 00:00:00 | Open | No
LMN | 2024-04-02 00:00:00 | Closed
QRS | 2024-09-03 00:00:00 | Closed
QRS | 2024-07-03 00:00:00 | Closed
QRS | 2024-05-03 00:00:00 | Open | No
XYZ | 2021-01-04 00:00:00 | Open | No
XYZ | 2021-05-03 00:00:00 | Closed
XYZ | 2021-07-07 00:00:00 | Open | No
XYZ | 2021-09-12 00:00:00 | Closed
Spreadsheet: 886724d1736840095-extract-values-in-alternate-columns-based-on-matching-criteria-sekharks-sample-347-spill-365-aligw
Sheet: Sheet1

 | Available data |  |  |  |  |  |  | Required to be filled
 | A | S | D | F |  |  |  | A | S | D | F
 | 1 | 2 | 3 | 4 |  |  |  | 1 |  | 3
 | 5 | 6 | 7 | 9 |  |  |  | 3 |  | 5
 | 3 | 4 | 5 | 6 |  |  |  | 5 |  | 7
 |  |  |  |  |  |  |  |  | S | D | F
 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4
 |  |  |  |  |  |  |  | 3 | 4 | 5 | 6
 |  |  |  |  |  |  |  | 5 | 6 | 7 | 9
Spreadsheet: 672872d1587049532-highlighting-days-in-a-calendar-based-on-a-pattern-calendar-perpetual-cf-datevalue-a-day
Sheet: Calendars and Calculators

 | 2019-05-01 00:00:00
 | WK | S | M | T | W | T | F | S |  | WK | S | M | T | W | T | F | S |  | WK | S | M | T | W | T | F | S |  | WK | S | M | T | W | T | F | S |  |  | Enter 1st of desired month in top-left calendar. The rest will populate automatically.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Highlight Current Day? |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st Month of FISCAL Year* |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * Week (WK) numbers are based off this selection
 | WK | S | M | T | W | T | F | S |  | WK | S | M | T | W | T | F | S |  | WK | S | M | T | W | T | F | S |  | WK | S | M | T | W | T | F | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00
 | WK | S | M | T | W | T | F | S |  | WK | S | M | T | W | T | F | S |  | WK | S | M | T | W | T | F | S |  | WK | S | M | T | W | T | F | S
Spreadsheet: 88127d1288044326-looking-up-next-non-zero-value-and-counting-zeros-escrow-escrow
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27
Scenario 1
Due | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 54000 | 0
Escrowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
Escrow Period
Escrow
Scenario 2
Due | 0 | 0 | 12000 | 0 | 0 | 12000 | 0 | 0 | 12000 | 0 | 0 | 12000 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
Escrowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
Escrow Period
Escrow
Spreadsheet: 272281d1382336665-conditional-formating-border-line-problem-condtional-formating
Sheet: Sheet1

 |  |  |  |  |  | original data
 |  |  |  |  | no | name |  | description
 |  |  |  |  | 1 | zidan | 1 | test1
 |  |  |  |  |  |  | 2 | test2
 |  |  |  |  |  |  | 3 | test3
 |  |  |  |  | 2 | bill | 1 | test5
 |  |  |  |  |  |  | 2 | test6
 |  |  |  |  | 3 | [NAME] | 2 | [NAME]
 |  |  |  |  |  | after formula
 |  |  |  |  | no | name |  | description
 |  |  |  |  | 1 | zidan | 1 | test1
 |  |  |  |  |  |  | 2 | test2
 |  |  |  |  |  |  | 3 | test3
 |  |  |  |  | 2 | bill | 1 | test5
 |  |  |  |  |  |  | 2 | test6
 |  |  |  |  | 3 | [NAME] | 2 | [NAME]