tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 216216d1361643733-counting-the-number-of-guests-to-be-in-house-on-a-certain-day-copy-of-tracking
Sheet: Tracking

 | Company | Name | Check In | Check Out | # Nights | Room Type | Type | Date Booked | Checked Out | Confirmation #
 | Company1 | Worker1 | 2012-08-14 00:00:00 | 2013-08-31 00:00:00 |  | Room Type 1 | Permanent | 2012-08-14 00:00:00 |  | 101198
 | Company2 | Worker2 | 2012-08-27 00:00:00 | 2013-08-31 00:00:00 |  | Room Type 1 | Permanent | 2012-08-27 00:00:00 |  | 101437
 | Company3 | Worker3 | 2013-02-11 00:00:00 | 2013-08-31 00:00:00 |  | Room Type 1 | Permanent | 2013-02-07 00:00:00 |  | 106557
 | Company4 | Worker4 | 2013-02-17 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 1 | Permanent | 2012-05-28 00:00:00 |  | 100852
 | Company5 | Worker5 | 2013-02-18 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 1 | Permanent | 2012-09-10 00:00:00 |  | 102394
 | Company6 | Worker6 | 2013-02-19 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 1 | Permanent | 2012-10-28 00:00:00 |  | 104158
 | Company7 | Worker7 | 2013-02-20 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 1 | Permanent | 2012-04-27 00:00:00 |  | 100381
 | Company8 | Worker8 | 2013-02-21 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 1 | Permanent | 2012-04-27 00:00:00 |  | 100382
 | Company9 | Worker9 | 2013-02-22 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 1 | Permanent | 2012-09-05 00:00:00 |  | 102295
 | Company10 | Worker10 | 2013-02-23 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 2 | Permanent | 2012-09-06 00:00:00 |  | 102296
 | Company11 | Worker11 | 2012-09-15 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 3 | Permanent | 2012-09-07 00:00:00 |  | 102297
 | Company12 | Worker12 | 2012-09-16 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 4 | Permanent | 2012-09-08 00:00:00 |  | 102298
 | Company13 | Worker13 | 2013-02-17 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 5 | Permanent | 2012-09-09 00:00:00 |  | 102299
 | Company14 | Worker14 | 2012-09-18 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 6 | Permanent | 2012-09-10 00:00:00 |  | 102300
 | Company15 | Worker15 | 2012-09-19 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 7 | Permanent | 2012-09-11 00:00:00 |  | 102301
 | Company16 | Worker16 | 2012-09-20 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 8 | Permanent | 2012-09-12 00:00:00 |  | 102302
 | Company17 | Worker17 | 2012-09-21 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 9 | Permanent | 2012-09-13 00:00:00 |  | 102303
 | Company18 | Worker18 | 2012-09-22 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 10 | Permanent | 2012-09-14 00:00:00 |  | 102304
 | Company19 | Worker19 | 2012-09-23 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 11 | Permanent | 2012-09-15 00:00:00 |  | 102305
 | Company20 | Worker20 | 2012-09-24 00:00:00 | 2013-09-04 00:00:00 |  | Room Type 12 | Permanent | 2012-09-16 00:00:00 |  | 102306
Spreadsheet: 731202d1620227229-need-help-merging-info-from-two-tables-report-template-test3
Sheet: 12

 | PROGRAM Info (changes infrequently) |  |  |  |  |  |  | OVERALL STATUS |  |  |  |  |  |  | MILESTONES |  |  |  |  | RECENT ACCOMPLISHMENTS |  |  | KEY ISSUES / RISKS |  |  |  |  |  | NEXT STEPS
 | Project ID | Project Name | Department | Executive Sponsor | [NAME] | Project Manager | Parent Program | Target Completion Date | Status | Percent Complete | Overall Status | Scope | Schedule | Resources | Weekly Update Section | Name | Due Date | Status | Health | Weekly Update Section | Name | Due Date | Weekly Update Section | Name | Due Date | Priority (Impact & Probability) | Status | Mitigations | Weekly Update Section | Name | Due Date | Status
 | Numeric | Text | Text | Text | Text | Text | Text | Date | Status Dropdown | Numeric - Percentage | Health (current)  [NAME] | Scope RAG Status | Schedule  [NAME] | Resources [NAME] | <Milestones> | Text | Date | Status | [NAME] R- OffTrack A - At Risk G - On Track | <Recent Accomplishments> | Text | Date | <Key Issues / Risks> | Text | Date | Low /  Medium / High | Status Dropdown | Text | <Next Steps> | Text | Date | Status Dropdown
 | 12
Spreadsheet: 38139d1236264558-if-then-or-conditional-formatting-example-spreadsheet
Sheet: Cert. Payroll

Certified Payroll Log
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet |  | 1 | of | 1
Project:
Contract No: | Pay Request #1 |  |  |  |  |  |  |  | Pay Request #2 |  |  |  |  |  |  |  |  |  |  | Pay Request #3
Contractors  / Week Ending | 2008-10-05 00:00:00 | 2008-10-12 00:00:00 | 2008-10-19 00:00:00 | 2008-10-26 00:00:00 | 2008-11-02 00:00:00 | 2008-11-09 00:00:00 | 2008-11-16 00:00:00 | 2008-11-23 00:00:00 | 2008-11-30 00:00:00 | 2008-12-07 00:00:00 | 2008-12-14 00:00:00 | 2008-12-21 00:00:00 | 2008-12-28 00:00:00 | 2009-01-04 00:00:00 | 2009-01-11 00:00:00 | 2009-01-18 00:00:00 | 2009-01-25 00:00:00 | 2009-02-01 00:00:00 | 2009-02-08 00:00:00 | 2009-02-15 00:00:00 | 2009-02-22 00:00:00 | 2009-03-01 00:00:00 | 2009-03-08 00:00:00 | 2009-03-15 00:00:00 | 2009-03-22 00:00:00 | 2009-03-29 00:00:00 | 2009-04-05 00:00:00 | 2009-04-12 00:00:00 | 2009-04-19 00:00:00 | 2009-04-26 00:00:00 | 2009-05-03 00:00:00 | 2009-05-10 00:00:00 | 2009-05-17 00:00:00 | 2009-05-24 00:00:00
Earthpro, Inc. | 1 | 2 | 3 | 4 | NW | 5 | NW | NW | NW | NW | NW | NW | NW | NW | NW | 6 | NW | NW | 7 | 8 | NW
Prestige Site Development |  |  |  | 1 | 2 | 3 | 4 | 5 | NW | NW | NW | NW | NW | NW | NW | 6 | 7 | NW | NW | 8 | NW
Southeast Concrete Solutions |  |  |  |  |  | 1 | NW | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | NW | 13 | 14
James' Electric |  |  |  |  |  |  | 1 | NW | NW | NW | NW | 2 | 3 | NW | NW | NW | 4 | 5 | 6 | 7 | 8 | 9
T&T Plumbing |  |  |  |  |  |  |  | 1 | NW | NW | NW | NW | NW | NW | NW | 2 | 3 | 4 | NW | NW | NW
[NAME] |  |  |  |  |  |  |  |  | 1 | 2 | NW | NW | 3 | 4 | 5 | 6 | 7 | 8 | NW | 9 | 10
Blue-McRae Masons |  |  |  |  |  |  |  |  |  |  | 1 | NW | NW | NW | NW | NW | NW | NW | 2 | 3 | 4 | 5
Wilson Mobile Welding |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | NW | NW | NW | NW | NW | 4 | NW
Reliance Mechanical, Inc. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Roofing Plus |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | NW
Campbellsville Industries |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | NW | NW
Arango Insulation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
EDA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2
Spreadsheet: 600288d1543590414-adding-flight-times-in-a-rolling-time-window-both-forward-and-backward-looking-100-in-672-practice-1
Sheet: Sheet1

Home base time | Home base time
Departure Date/Time | Arrival Date/Time | Flight Hrs
2019-01-05 18:00:00 | 2019-01-06 02:00:00
2019-01-07 04:00:00 | 2019-01-07 16:00:00
2019-01-22 12:00:00 | 2019-01-23 01:00:00
2019-01-24 03:00:00 | 2019-01-24 18:00:00
2019-01-27 12:00:00 | 2019-01-28 01:00:00
2019-01-29 03:00:00 | 2019-01-29 18:00:00
2019-02-04 10:00:00 | 2019-02-04 20:00:00
2019-02-06 12:00:00 | 2019-02-06 22:00:00
2019-02-08 10:00:00 | 2019-02-08 20:00:00
2019-02-10 12:00:00 | 2019-02-10 22:00:00
Calendar day totals are easy to calculate with 28 day windows,
but looking to accumulate hours:minutes in consecutive 672 hour windows,
based on the governmental restrictions.
Spreadsheet: 40af4282-2f53-45f7-a92d-83b01361b391
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. RWM, AGRO, FSCI, ASCI) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom = Face  OR  Online Course = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. RWM, AGRO, FSCI, ASCI) and Number | PSY
Discipline codes:  AG = 0200  Natural Resource Mgt = 0300   (4 digits) | 4200
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for AGEC 1351, ASCI 1351 = 0200                             AGEC 1331 = 0800      Honors = 0801               (4 digits)
Long (L)  Forms | L | L | L | L | L | L | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: michelle_lokay__26631__imbalsumm0102
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 109647 | 107420
2 | 92682 | 92009
3 | 119934 | 117811
4 | 118073 | 120448
5 | 125154 | 123014
6 | 148315 | 149289
7 | 121730 | 120413
8 | 95622 | 93136
9 | 124406 | 124579
10 | 116813 | 115232
11 | 117045 | 115461
12 | 116972 | 115139
13 | 115321 | 113468
14 | 117984 | 117992
15 | 128931 | 129502
16 | 125236 | 123052
17 | 122223 | 121152
18 | 118594 | 121759
19 | 124085 | 122579
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  | -32211
2001-02-19 00:00:00
Spreadsheet: geir_solberg__11248__05-16
Sheet: MAY1501

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | SELL PRICE
2001-05-16 00:00:00 |  | Y | 6 | 6 |  | SP15 | EESI | 10 |  |  | 50 | Sold
2001-05-16 00:00:00 |  | Y | 8 | 8 |  | SP15 | EESI | 13 |  |  | 80 | Sold
2001-05-16 00:00:00 |  | Y | 22 | 22 |  | SP15 | EESI | 12 |  |  | 115 | Sold
2001-05-16 00:00:00 |  | Y | 11 | 11 |  | SP15 | EESI | 5 |  |  | 115 | Bought
2001-05-16 00:00:00 |  | Y | 12 | 12 |  | SP15 | EESI | 8 |  |  | 115 | Bought
2001-05-16 00:00:00 |  | Y | 13 | 13 |  | SP15 | EESI | 10 |  |  | 105 | Bought
2001-05-16 00:00:00 |  | Y | 14 | 14 |  | SP15 | EESI | 11 |  |  | 100 | Bought
Spreadsheet: 701262d1603664652-calendar-for-multi-day-recurring-events-recurring-events-multi-day
Sheet: January

 |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  | .
Spreadsheet: 41328d1239806073-counting-total-for-customers-that-can-appear-more-then-once-example1
Sheet: Sheet1

Date | Self Gen | IFA | Title | Initials | Surname | Post Code | Provider | Product | Investment Amount | Frequency | Commission | Address 1 | Address 2 | Address 3 | Address 4 | Total Sales | Total comission
2009-04-15 00:00:00 | Yes | IFA1 | Mr | A | AAA | AA11 1AA | L&G | SPP | 5760 | SINGLE | 194.4 | A | AA | AAA | AAAA | 2
2009-04-15 00:00:00 | n/a | IFA2 | Mr | B | BBB | BB22 2BB | [NAME] | FIB | 128.45 | Monthly | 834.48 | B | BB | BBB | BBBB | 1
2009-04-15 00:00:00 | No | IFA3 | Mrs | C | CCC | CC33 3CC | Fidelity | ISA | 7200 | SINGLE | 216 | C | CC | CCC | CCCC | 3
2009-04-15 00:00:00 | Yes | IFA1 | Mr | A | AAA | AA11 1AA | Fidelity | ISA | 7200 | SINGLE | 216 | A | AA | AAA | AAAA | 2
2009-04-15 00:00:00 | No | IFA3 | Mrs | C | CCC | CC33 3CC | Prudential | Investment Bond | 23000 | SINGLE | 690 | C | CC | CCC | CCCC | 3
2009-04-15 00:00:00 | Yes | IFA3 | Mrs | C | CCC | CC33 3CC | Cofunds | UT | 12600 | SINGLE | 252 | C | CC | CCC | CCCC | 3
Spreadsheet: 766533d1643923200-formula-to-copy-over-data-new-haddo-formula
Sheet: House

 |  |  | PO | RAISED |  | AMOUNT
DATE | AREA | DEPARTMENT | Number | BY | [NAME] OF PO | £
20.02.22 | Reactive | Plumbing / Drainage | 1234 | cally | blocked drain | 100
21.01.22 | Preventative | Frost Precautions | 7890 | cally | frost | 150
22.01.22 | Conservation | Conservation Works | 5678 | cally | conservation | 200
23.01.22 | Equipment | Equipment Rental / Lease | 4567 | cally | forklift hire | 250
24.01.22 | Utility | [NAME] | 3456 | cally | award | 300
25.01.22 | Vehicle | Fuel & Oil | 2345 | cally | fuel | 350
26.01.22 | Property | [NAME] | 12345 | cally | rat problem | 400
27.01.22 | Other | Stationery | 6789 | cally | stationary order | 450
Spreadsheet: 140541d1328798943-cells-reference-wont-update-when-dragged-down-book2
Sheet: Sheet1 (2)

 | Numéro |  |  |  |  | Lieu du Contrat
 | Activité |  | durée |  |  | [NAME] |  | prénom
 |  |  |  | Production projetée
 | Numéro |  |  |  |  | Lieu du Contrat
 | Activité |  | durée |  |  | [NAME] |  | prénom
 |  |  |  | Production
Spreadsheet: 213023d1360323393-autopoulate-a-workbook-from-another-workbook-booka
Sheet: Sheet1

Other ID | # | Name | Title | Date |  |  |  |  | Type e | Type f |  |  | Area | Description | Who to Solve |  |  |  |  | Date Completed
1 | 1001 | Person A | Operator | 2011-10-21 00:00:00 |  |  |  |  |  | X |  |  | 3 |  | Operator |  |  |  |  | 2011-10-25 00:00:00
2 | 1002 | Person B | Operator | 2011-10-21 00:00:00 |  |  |  |  |  | X |  |  | 3 |  | Maintenance |  |  |  |  | 2011-11-08 00:00:00
3 | 1003 | Person B | Operator | 2011-10-21 00:00:00 |  |  |  |  | X |  |  |  | 3 |  | Operator |  |  |  |  | 2012-03-21 00:00:00
 | # | Name | title | Date recorded | Type a | Type b | Type c | Type d | Type e | Type f | Type g | Priority | Area | Desctription | Who to solve | How to solve | Who really did | Due | Outstanding | Complete
 | 1001 | Person A | Normal guy | 2011-10-21 00:00:00 |  |  |  |  |  | X |  | A | 3 | [NAME] blah | Normal guy | Clean | Person A | 2011-10-25 00:00:00 |  | 2011-10-25 00:00:00 | True
 | 1003 | Person B | Normal guy | 2011-10-21 00:00:00 |  |  |  | X | X |  |  | C | 3 | Yakkity Schmakkitty | Normal guy | Investigate options | Person C | 2011-12-21 00:00:00 |  | 2011-10-25 00:00:00 | True
 | 1005 | Person B | Normal guy | 2011-10-21 00:00:00 |  |  |  | X | X |  |  | C | 3 | Yakkity Schmakkitty | Normal guy | Investigate options | Person C | 2011-12-21 00:00:00 |  | 2011-10-25 00:00:00 | True
Spreadsheet: 778724d1651247884-building-a-dynamic-formula-to-simplify-relations-substitute-len-excel-simplify-relations_substitute_len_countif_search
Sheet: Sheet1

 |  | Can someone guide me in the right direction… to go from yellow to green, with a dynamic (in-between) formula in blue
 |  |  |  | Helper Cells |  | (LEN($B6)-LEN(SUBSTITUTE($B6;E$5;"")))/LEN(E$5)
 | Relations between people | [NAME] |  | Anna | [NAME] | Casper | Dirk | Eva | [NAME] | Gerard | Hilde | Isabel |  | Group of relations |  | Wrong1 | Wrong2
 | Anna-Dirk, [NAME], Casper-Fiona |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Casper-Fiona
 | [NAME], Isabel-Boris, Eva-Isabel, [NAME], Dirk-Boris, Eva-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Boris-Dirk, Fiona-Eva, [NAME], Dirk-Hilde |  |  |  |  |  |  |  |  |  |  |  |  | Boris-Dirk-Hilde, [NAME]
 | Isabel-Anna, Eva-Boris, Hilde-Casper, Isabel-Gerard, Fiona-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | Isabel-Anna-Gerard, Eva-Boris, Hilde-Casper, Fiona-Dirk
 | Dirk-Casper, Fiona-Eva, [NAME], Dirk-Hilde, [NAME], Fiona-Hilde |  |  |  |  |  |  |  |  |  |  |  |  | Dirk-Casper-Hilde-Fiona-Isabel-Gerard-Eva
 | [NAME], Isabel-Anna, Eva-Hilde, Dirk-Casper |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Eva-Hilde, Dirk-Casper
 | Eva-Isabel, Eva-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | Eva-Isabel-Dirk
 | …
 | [NAME], [NAME], Casper-Eva, Isabel-Fiona |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 | Sample DATA in [B6:B14] |  |  | List of 9 People: |  |  |  |  |  |  |  |  |  | I Hardcoded the preferred FORMAT in [O6:O14]
 |  | I've been stuck on this (seemingly simple) dynamic formula-problem, for over 2 years now (since 2019)…
 | Dirk-Anna, [NAME], Casper-Fiona
 |  |  |  |  |  |  |  |  |  |  |  |  | Fiona-Eva
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Dirk-Hilde
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Fiona-Hilde
Spreadsheet: 38124d1236251550-excel-2007-significant-loss-of-functionality-error-forex-journal-live
Sheet: APRJOURNAL

DATE | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
DATE | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Wednesday, 1st April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Thursday,2nd April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
[NAME] April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Monday,6th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Tusday,7th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Wednesday,8th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Thursday,9th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Friday, 10th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Monday,13th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Tuesday,14th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Wednesday, 15th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Thursday,16th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Friday, 17th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Monday,20th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Tusday,21st April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Wednesday,22nd April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
[NAME] April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Friday,24th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Monday,27th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Tuesday,28th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Wednesday,29th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Thursday, 30th April 2009 | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
DATE | FOREX PAIR | POSITION (L/S) | LOT SIZE | ENTRY | EXIT | WIN |  | LOSE |  | PIPS
 |  |  |  | TOTALS
Spreadsheet: 758977d1639206001-fill-blank-cells-in-a-column-by-duplicating-values-of-first-unique-instance-excel-forum-11-12
Sheet: Sheet1

original data | preferred display |  | given data
11364-18 | 11364-18 |  | 95511-03-18
 | 11364-18 |  | 95511-04-18
 | 11364-18 |  | 95511-05-18
 | 11364-18 |  | 95511-06-18
11367-141 | 11367-141 |  | 95511-03-18
 | 11367-141 |  | 95511-04-18
 | 11367-141 |  | 95511-05-18
 | 11367-141 |  | 95511-06-18
11367-92 | 11367-92 |  | 95511-03-18
 | 11367-92 |  | 95511-04-18
 | 11367-92 |  | 95511-05-18
 | 11367-92 |  | 95511-06-18
11364-01 | 11364-01 |  | 95511-03-01
 | 11364-01 |  | 95511-04-01
 | 11364-01 |  | 95511-05-01
 | 11364-01 |  | 95511-06-01
11367-01 | 11367-01 |  | 95511-03-01
 | 11367-01 |  | 95511-04-01
 | 11367-01 |  | 95511-05-01
 | 11367-01 |  | 95511-06-01
10145-01 | 10145-01 |  | 95787-04-01
 | 10145-01 |  | 95787-05-01
 | 10145-01 |  | 95787-06-01
 | 10145-01 |  | 95787-07-01
 | 10145-01 |  | 95787-08-01
 | 10145-01 |  | 95787-03-01
 | 10145-01 |  | 95787-04-01
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 25469 | 23994
2 |  |  | 24784 | 22824
3 |  |  | 25183 | 23383
4 |  |  | 24557 | 24000
5 |  |  | 24078 | 24000
6 | 458 |  | 24837 | 24000
7 | 2841 |  | 24858 | 24000
8 | 4785 |  | 24955 | 24000
9 | 3622 |  | 24838 | 24000
10 | 1852 |  | 24699 | 24000
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -178485 | -46545
2001-08-31 00:00:00 | Balance | -1023166.39 |  | -399182.01
2001-09-10 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | -58339.66 | Zia |  |  | 22864 | -24566
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 | 44144.84 | [NAME] |  |  | 26357 | 26521
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -933276.39 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -42250
 |  |  |  | Duke
Spreadsheet: 756239d1637344811-talling-time-based-on-duration-totaling-time-dexter2-
Sheet: Sheet3

 |  |  |  |  | 05:20:00 |  |  | Count of time |  |  | Shift 1 | 05:20:00 | 09:22:00
 |  |  |  |  | 05:30:00 |  |  |  |  |  | Shift 2 | 13:40:00 | 18:28:00
 |  |  |  |  | 09:22:00
 |  |  |  |  | 13:40:00 |  |  |  |  |  |  | 05:20:00 | 05:30:00
 |  |  |  |  | 18:28:00 |  |  |  |  |  |  | 05:30:00 | 06:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 06:30:00 | 07:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 08:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 | 09:22:00
 |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 | 10:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 | 11:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 | 12:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 13:30:00 | 13:40:00
 |  |  |  |  |  |  |  |  |  |  |  | 13:40:00 | 14:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 14:30:00 | 15:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 16:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 16:30:00 | 17:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 18:28:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Total