tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 777428d1650377277-attendance-rolling-12-month-calculator-attendance-example
Sheet: Sheet1

 | Employee Name | Total Points  this year | Total Points | 4/11/2022 | 4/12/2022 | 4/13/2022 | 4/14/2022 | 4/15/2022 | 4/16/2022 | 4/17/2022 | 4/18/2022 | 4/19/2022 | 4/20/2022 | 4/21/2022 | 4/22/2022 | 4/23/2022 | 4/24/2022 | 4/25/2022 | 4/26/2022 | 4/27/2022 | 4/28/2022 | 4/29/2022 | 4/30/2022 | 5/1/2022 | 5/2/2022 | 5/3/2022 | 5/4/2022 | 5/5/2022 | 5/6/2022
 | Employee A |  |  |  |  |  | 1 | 1
 | Employee B |  |  |  | 0.5 | 0.5 |  |  | 3
Spreadsheet: 762940d1641913429-cond-formatting-first-monday-on-the-month-sddo-vacation-tracker-2023
Sheet: Jan 2023

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative | T
Compressed Day / Journée comprimée
Assignment / Left
Half Day / Demie Journée
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
January | Dates of leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
Employee Name | 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 | 28 | 29 | 30 | 31 |  | Replaced by:
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
(Vacant CS-03)
[NAME]
[NAME]
[NAME]
(Vacant team lead)
(Vacant CS-03)
Sameer [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
January Total
Spreadsheet: 104770d1302224896-question-about-linking-formulas-from-one-page-to-another-new-accts-payable-2011
Sheet: Dec

december expenses
total
advertising
date | po# | suppplier.description | amount
subtotal
x
educational
date | po# | suppplier.description | amount
subtotal
x
supplies. blanks
date | po# | suppplier.description | amount
subtotal
x
supplies. designs
date | po# | suppplier.description | amount
subtotal
s
supplies. notions
date | po# | suppplier.description | amount
subtotal
supplies. machinery
date | po# | suppplier.description | amount
subtotal
supplies. office
date | po# | suppplier.description | amount
subtotal
etsy maintenance
date | po# | suppplier.description | amount
subtotal
website maintenance
date | po# | suppplier.description | amount
subtotal
shipping
date | po# | suppplier.description | amount
subtotal
utilities
date | po# | suppplier.description | amount
subtotal
Spreadsheet: 847053d1698152110-vlookup-and-if-example
Sheet: Special Prices

CUSDEFN | PRODCODE | Sales 2022 | Sales 2023 | Sales 2024
ABEL1 | 004
ABEL1 | 007
ABEL1 | 008
ABEL1 | 010
ABEL1 | 012
ABEL1 | 014
ABEL1 | 015
ABEL1 | 018
ABEL1 | 019
ABEL1 | 020
ABEL1 | 024
ABEL1 | 025
ABEL1 | 046
ABEL1 | 047
ABEL1 | 048
ABEL1 | 056
ABEL1 | 073
ABEL1 | 074
ABEL1 | 077
ABEL1 | 078
ABEL1 | 079
ABEL1 | 082
ABEL1 | 085
ABEL1 | 087
ABEL1 | 088
ABEL1 | 095
ABEL1 | 113
ABEL1 | 119
ABEL1 | 125
ABEL1 | 137
ABEL1 | 149
ABEL1 | 171
ABEL1 | 173
ABEL1 | 189
ABEL1 | 190
ABEL1 | 196
ABEL1 | 197
ABEL1 | 198
ABEL1 | 206
ABEL1 | 219
ABEL1 | 220
ABEL1 | 226
ABEL1 | 227
ABEL1 | 233
ABEL1 | 236
ABEL1 | 237
ABEL1 | 238
ABEL1 | 239
ABEL1 | 240
ABEL1 | 243
ABEL1 | 256
ABEL1 | 257
ABEL1 | 260
ABEL1 | 295
ABEL1 | 298
ABEL1 | 316
ABEL1 | 322
ABEL1 | 323
ABEL1 | 324
ABEL1 | 336
ABEL1 | 337
ABEL1 | 340
ABEL1 | 401
ABEL1 | 430
ABEL1 | 433
ABEL1 | 434
ABEL1 | 449
ABEL1 | 458
ABEL1 | 470
ABEL1 | 478
ABEL1 | 479
ABEL1 | 499
ABEL1 | 505
ABEL1 | 507
ABEL1 | 519
ABEL1 | 520
ABEL1 | 522
ABEL1 | 525
ABEL1 | 526
ABEL1 | 527
ABEL1 | 528
ABEL1 | 777
ABEL1 | 902
ABEL1 | 903
ABEL1 | 905
ABEL1 | 906
ABEL1 | 907
Spreadsheet: 582727d1532012280-creating-replacement-parts-list-supercede-data-countrycatmark-
Sheet: o

New Part | Space | Old Part 1 | Old Part 2 | Old Part 3 | Old Part 4 | Old Part 5 | Old Part 6 | Old Part 7 | Old Part 8 | Old Part 9 | Old Part 10 | Old Part 11 | Old Part 12 | Old Part 13 | Old Part 14 | Old Part 15 | Old Part 16 | Old Part 17 | Old Part 18 | Old Part 19 | Old Part 20 | Old Part 21 | Old Part 22 | Old Part 23 | Old Part 24 | Old Part 25 | Old Part 26 |  | H1 | H2 | H3 | H4 | H5 | H6 | H7 | H8 | H9 | H10 | H11 | H12 | [NAME] | H14 | H15 | H16 | H17 | H18 | H19 | H20 | H21 | H22 | H23 | H24 | H25 | H26 |  | H1 | H2 | H3 | H4 | H5 | H6 | H7 | H8 | H9 | H10 | H11 | H12 | [NAME] | H14 | H15 | H16 | H17 | H18 | H19 | H20 | H21 | H22 | H23 | H24 | H25 | H26 |  | Old Part 1 | Old Part 2 | Old Part 3 | Old Part 4 | Old Part 5 | Old Part 6 | Old Part 7 | Old Part 8 | Old Part 9 | Old Part 10 | Old Part 11 | Old Part 12 | Old Part 13 | Old Part 14 | Old Part 15 | Old Part 16 | Old Part 17 | Old Part 18 | Old Part 19 | Old Part 20 | Old Part 21 | Old Part 22 | Old Part 23 | Old Part 24 | Old Part 25 | Old Part 26
Spreadsheet: 741510d1627073630-lookup-match-with-multiple-criteria-help-car-repair-tracking
Sheet: Summary

 | Finish Date | 1st Car won't finish | 2nd Car won't finish | [NAME] won't finish
Al | 2021-05-31 00:00:00
[NAME] | 2021-06-21 00:00:00
[NAME] | 2021-06-28 00:00:00
[NAME] | 2021-06-28 00:00:00
What I would like to see automatically populated in the area above:
 | Finish Date | 1st Car won't finish | 2nd Car won't finish | [NAME] won't finish
Al | 2021-05-31 00:00:00 | Model 3 | Yugo
[NAME] | 2021-06-21 00:00:00 | Bus | Golf
[NAME] | 2021-06-28 00:00:00 | Mustang | Fusion
[NAME] | 2021-06-28 00:00:00
Spreadsheet: 32340d1228444355-workbook-stripped-of-format-after-its-saved-mastertemplate_standard-calc-november-2008v4_corrupt-corrected
Sheet: CCRF

Continuing Education and Workforce Development
Areas to be Completed: |  | Call Center: |  |  |  | Scheduling:
 |  | [NAME]: |  |  |  | Marketing:
 |  | Finance:
Division Code: |  | 0 |  | Department Code: |  |  | 0 |  |  |  |  |  | Comments:
Coordinator’s Name: |  | 0 |  |  |  |  |  |  | Phone: | 0
Program Support Name: |  |  |  |  |  |  |  |  | Phone:
Type of Request:
Today's Date
Term: | 200970 |  |  |  |  |  |  |  |  |  |  |  | Change to:
Class Title: | Something |  |  |  |  |  |  |  |  |  |  |  | Change to:
Course # | AHE 120 |  | / | Pt of Term: |  | 2 - Contract |  | / | Course Del ID: |  | Contract |  | Change to: |  |  | / | Pt of Term: |  |  |  | / | Course Del ID:
CRN# | 0 |  |  |  | / | Number of sessions: |  |  | 2 |  |  |  | Change to: |  |  |  | / |  | Number of sessions:
Date of Class: | 2009-01-07 00:00:00 |  |  |  |  |  | to | 2009-01-14 00:00:00 |  |  |  |  | Change to: |  |  |  |  |  |  | to
Skip Dates: | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 |  |  | Change to:
 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00
Days of Class |  |  |  | WED |  |  |  |  |  |  |  |  | Change to:
20% Date: | 2009-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Change to:
Time: | 09:00:00 |  |  |  |  | to | 09:30:00 |  |  |  |  |  | Change to: |  |  |  |  | to
Ttl Teaching Hrs. | 60 |  | / | Ttl MHEC: |  | 72 |  | / | CEU’s: | 7.2 |  |  | Change to: |  |  | / | Ttl MHEC |  |  |  | / | CEU’s
Location: | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | Change to:
Cost: | Tuition | 0 |  |  | / | Adm Fee: | 0 |  | / | Lab Fee: | 0 |  | Change to: | Tuition |  |  |  | / | Adm Fee:
 | Reg Fee: | 0 |  |  | / | Total Course Cost: |  | 0 |  |  |  |  |  | Lab Fee: |  |  | / | Reg Fee: |  | 5 |  | Total: | 5
Instructor: | 0 |  |  |  |  |  | / | Instructor ID: |  |  |  |  | Change to: |  |  |  |  | Instructor ID:
Account Number: | 0 |  |  |  |  |  |  |  |  |  |  |  | Change to:
[NAME]: | 0 |  |  |  |  |  | Contract ID: |  |  |  |  |  | [NAME]: |  |  | Substitute Hrs: |  |  |  |  |  | Dock:
Adjustment: | 0 |  |  |  | / | Reason for Adjustment |  |  | 0 |  |  |  | Adjustment: |  |  |  | / | Reason for Adjustment
Does this course require grades? |  |  |  |  |  |  |  |  |  |  |  |  | Total Payment: | 0 |  |  |  |  |  | Total Dock:
 |  |  |  |  |  |  |  |  |  |  |  |  | Instructor Status: |  |  |  |  |  |  |  | Process a $0 Contract:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Revised November 2008 v1
Spreadsheet: 82740d1282760163-multiplying-a-cell-number-by-a-user-input-number-food-nutrients-counter
Sheet: Fruits

 | Food Nutrients Counter |  |  | * Protein marked in red is where protein comes from plant  sources and should not be counted towards daily protein intake. |  | Fine Tune Results
Fruits | Protein | Carbs | Total Carbs | of which sugars | Calories | Description | Change Quantity | Change Weight
[NAME] | 1 | 27 | 54 | 112 | One Medium | 1 | 2
Fruits | Protein | Carbs |  | of which sugars | Calories | Description | Change Quantity | Change Weight
Apple | 0 | 19 |  | 76 | One Medium | 1 | 1
 |  |  |  | 0 | 100g |  | 100g
 |  |  |  | 0 | 100g mince |  | 100g
 |  |  |  | 0 | 100g steak |  | 100g
 |  |  |  | 0 | 100g burger |  | 100g
 |  |  |  | 0 | medium |  | 100g
 |  |  |  | 0 |  |  | 100g
 |  |  |  | 0 |  |  | 100g
 |  |  |  | 0 |  |  | 100g
 |  |  |  | 0 |  |  | 100g
 |  |  |  | 0 |  |  | 100g
Spreadsheet: 54382add-866e-492c-a670-1f98aa15383a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8522 | 63884 | [NAME] | [NAME] | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:07:37
Spreadsheet: 36650d1234520711-excel-order-form-671805
Sheet: Sheet1

 |  |  | [NAME]
 |  |  | Supervisor: |  |  | 2009-02-13 00:00:00
Description |  |  | PRODUCT CODE |  | On Hand Inventory | Inventory | Qty to Order
 |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  |  |  |  | 0 | Alain Alfonso
 |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  |  |  |  | 0 | Inoir Ortiz
 |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
COUNTRY LABELS:
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
Spreadsheet: 885928d1735851126-date-format-in-logic-statement-thbuster-surgery-follow-up-tracker
Sheet: Sheet1

Subject | Was Surgery Confirmed | Date of Surgery | Date Range for Follow-up
1 | yes | 2024-05-08 00:00:00
2 | no
3 | no
Spreadsheet: 756885d1637851257-corkscrew-array-corkscrew-array
Sheet: Sheet1

 |  |  |  | EXAMPLE 1 |  |  |  |  |  |  | EXAMPLE 2
 |  |  |  | SOURCE |  |  |  |  |  |  | SOURCE
 |  |  | 1 | 0 | 2 | 6 | 10 | 0 |  | 1 | 0 | 6 | 12 | 18 | 0
 |  |  | 2 | 0 | 3 | 7 | 0 | 0 |  | 2 | 1 | 7 | 13 | 19 | 0
 |  |  | 3 | 0 | 4 | 8 | 0 | 0 |  | 3 | 2 | 8 | 14 | 0 | 0
 |  |  | 4 | 1 | 5 | 9 | 0 | 0 |  | 4 | 3 | 9 | 15 | 0 | 0
 |  |  | 5 | 0 | 0 | 0 | 0 | 0 |  | 5 | 4 | 10 | 16 | 0 | 0
 |  |  | 6 | 0 | 0 | 0 | 0 | 0 |  | 6 | 5 | 11 | 17 | 0 | 0
 |  |  | 7 | 0 | 0 | 0 | 0 | 0 |  | 7 | 0 | 0 | 0 | 0 | 0
 |  |  | 8 | 0 | 0 | 0 | 0 | 0 |  | 8 | 0 | 0 | 0 | 0 | 0
 |  |  | 9 | 0 | 0 | 0 | 0 | 0 |  | 9 | 0 | 0 | 0 | 0 | 0
 |  |  | 10 | 0 | 0 | 0 | 0 | 0 |  | 10 | 0 | 0 | 0 | 0 | 0
 |  |  | 11 | 0 | 0 | 0 | 0 | 0 |  | 11 | 0 | 0 | 0 | 0 | 0
 |  |  | 12 | 0 | 0 | 0 | 0 | 0 |  | 12 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | RESULT
 |  |  |  | RESULT
 |  |  | 1 | 0 | 0 | 4 | 8 | 0 |  | 1 | 0 | 3 | 9 | 15 | 0
 |  |  | 2 | 0 | 1 | 5 | 9 | 0 |  | 2 | 0 | 4 | 10 | 16 | 0
 |  |  | 3 | 0 | 2 | 6 | 10 | 0 |  | 3 | 0 | 5 | 11 | 17 | 0
 |  |  | 4 | 0 | 3 | 7 | 0 | 0 |  | 4 | 0 | 6 | 12 | 18 | 0
 |  |  | 5 | 0 | 0 | 0 | 0 | 0 |  | 5 | 1 | 7 | 13 | 19 | 0
 |  |  | 6 | 0 | 0 | 0 | 0 | 0 |  | 6 | 2 | 8 | 14 | 0 | 0
 |  |  | 7 | 0 | 0 | 0 | 0 | 0 |  | 7 | 0 | 0 | 0 | 0 | 0
 |  |  | 8 | 0 | 0 | 0 | 0 | 0 |  | 8 | 0 | 0 | 0 | 0 | 0
 |  |  | 9 | 0 | 0 | 0 | 0 | 0 |  | 9 | 0 | 0 | 0 | 0 | 0
 |  |  | 10 | 0 | 0 | 0 | 0 | 0 |  | 10 | 0 | 0 | 0 | 0 | 0
 |  |  | 11 | 0 | 0 | 0 | 0 | 0 |  | 11 | 0 | 0 | 0 | 0 | 0
 |  |  | 12 | 0 | 0 | 0 | 0 | 0 |  | 12 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 349515d1412352796-auto-populate-sheets-based-on-master-sheet-doc-review-schedule-with-pivot-tables
Sheet: Quarterly Schedules

Next Review Date | Doc # | [NAME] | Last Review Date
2015-01-09 00:00:00 | 9 | Test 9 | 2014-01-09 00:00:00
2015-02-25 00:00:00 | 10 | Test 10 | 2014-02-25 00:00:00
2015-03-20 00:00:00 | 1 | Test 1 | 2014-03-20 00:00:00
2015-03-20 00:00:00 | 2 | Test 2 | 2014-03-20 00:00:00
2015-03-31 00:00:00 | 6 | Test 6 | 2014-03-31 00:00:00
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: HPL

HPL
Originator |  | Commodity |  | Team |  | Total |  | %Total
Gottlob |  | Gas |  | HPL |  | 5749630
Riley |  | Gas |  | HPL |  | 1546776
Morris |  | Gas |  | HPL |  | 723434
[NAME] |  | Gas |  | HPL
[NAME],[NAME] |  | Gas |  | HPL |  | 247870
Hall |  | Gas |  | HPL |  | 216719
Snieder |  | Gas |  | HPL
Lamphier |  | Gas |  | HPL
Martinez |  | Gas |  | HPL |  | 112510
[NAME] |  | Gas |  | HPL |  | 43010
[NAME] |  | Gas |  | HPL |  | 37419
[NAME] |  | Gas |  | HPL |  | 13663
Weissman |  | Gas |  | HPL |  | 12580
Lofton |  | Gas |  | HPL |  | 10149
Peyton |  | Gas |  | HPL |  | 2431
[NAME] |  | Gas |  | HPL |  | -2974
[NAME] |  | Gas |  | HPL |  | -42841
Papayoti |  | Gas |  | HPL
Total
Spreadsheet: 343272d1409859669-dotted-line-appears-in-conditional-formatted-cell-example
Sheet: Settings & Calculations

 | Highlight Settings
 | The tables below store settings and calculations for the Highlight Activities drop down list. Any changes could result in errors or loss of functionality.
 | No Highlight
 | Interval: | Start: | End: | Due:
 | This Week
 | This Month
 | This Quarter
 | This Year
 | Interval:
 | Last Week
 | Last Month
 | Last Quarter
 | Last Year
 | Selected Highlight:
 | Highlight Start
 | Highlight End
 | Owner
 | A
 | B
 | C
 | D
 | E
 | F
 | G
 | H
 | I
Spreadsheet: 677616d1589433043-how-to-use-multiple-index-and-match-in-the-multiple-conditions-sample-1
Sheet: PN

RESOLUTION_CODE | EDG | IVI | JAN | JAN S | M | M-TURB
REPLACE - BATTERY | P15051-20 | P18438-01 | P15051-21 | P20664-03 | P14586-04 | P07168-20
REPLACE - LCD | P15230-02 |  | P21148-11 | P20475-01N | P14522-01N | P09419-04
REPLACE - MAIN PCBA | P15615-03 | P21292-03 | P20593-02N | P21168-02N | P16055-01N | P19087-02
REPLACED END ITEM | P15615-03 | P21292-03 | P20593-02N | P21168-02N | P16055-01N | P19087-02
X PORTE BATTERY |  |  |  |  | P14586-04
X PORTE ENGINE |  |  |  |  | P16055-01N
Spreadsheet: errol_mclaughlin_jr__10058__Budget Temp
Sheet: CC 103818 - Upload

SAP PROFIT CENTER:
PROFIT CENTER OWNER:
SAP COST CATEGORY:
SAP COST | SAP COST |  |  |  |  |  |  |  |  |  |  |  |  | Annual
CENTER | ELEMENT | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Expense
 | 52000500
 | 52001000
 | 59003000
 | 52001500
 | 52002000
 | 52002500
 | 52003000
 | 52003500
 | 52004000
 | 52004500
 | 52503500
 | 52502000
 | 52507400
 | 52507000
 | 52507100
 | 52507200
 | 52507300
 | 52507500
 | 52507600
 | 52507700
 | 52508000
 | 52508100
 | 52508500
 | 53500000
 | 53500500
 | 53600000
 | 52500500
 | 52504100
 | 53800000
 | 53801000
 | 52504500
 | 54000000
 | 52502500
 | 52505500
 | 54005000
 | 52504200
 | 52506500
 | 52506000
 | 52503000
 | 52504000
 | 57200000
 | 57000000
 | 59099900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 124805d1318614925-time-formula-breaks-with-multiple-ins-per-day-test2
Sheet: Time Keeping

Week of | 2011-10-12 00:00:00 | [NAME] |  |  |  |  |  |  |  | Comments:
 | In | 17:06:00
 | Out | 1904-01-02 01:04:00
2011-10-12 00:00:00 | In | off
2011-10-12 00:00:00 | Out | 1904-01-02 01:04:00
 | job-
 | Lunch | #N/A
 | Hours | #N/A
 | In
 | Out
2011-10-13 00:00:00 | In
2011-10-13 00:00:00 | Out
 | job-
 | Lunch
 | Hours
 | In
 | Out
2011-10-14 00:00:00 | In
2011-10-14 00:00:00 | Out
 | job-
 | Lunch
 | Hours | 1900-01-01 00:00:00
 | In
 | Out
2011-10-17 00:00:00 | In
2011-10-17 00:00:00 | Out
 | job-
 | Lunch
 | Hours | 1900-01-01 00:00:00
 | In
 | Out
2011-10-18 00:00:00 | In
2011-10-18 00:00:00 | Out
 | job-
 | Lunch
 | Hours | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | Deciaml Time | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hours Total | #N/A | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | Hours Left | #N/A | 1904-01-02 16:00:00 | 1904-01-02 16:00:00 | 1904-01-02 16:00:00 | 1904-01-02 16:00:00 | 1904-01-02 16:00:00 | 1904-01-02 16:00:00 | 1904-01-02 16:00:00
Spreadsheet: 713599d1610820730-bulding-a-schedule-index-aggregate-dexter2-2-ef-1-16-21
Sheet: Schedule

Route 1 Line
 |  | Vehicle | Depot | Terminal A | Stop 1 | Stop 2 | Stop 3 | Terminal B | Column1 | Vehicle | Terminal B2 | Stop 33 | Stop 24 | Stop 15 | Terminal A6 | Column7 | Depot8 | Vehicle9
 | 101 |  |  | 05:30:00 |  |  |  |  |  |  | 06:15:00 |  |  |  |  | 07:00:00
 | 104 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:15:00
 | 102 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00
 | 103 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:45:00
 | 105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00
 | 106 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00
 | 109 |  |  |  |  |  |  |  |  | 109 | 08:00:00 | 08:11:00 | 08:31:00 | 08:36:00 | 08:42:00 | 08:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
 | 108 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00
 | 107 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:15:00
Spreadsheet: 92277d1291900425-excel-2007-conditional-formating-marked-by-coloured-condition-format
Sheet: DEC

INV | TAKEN BY | RCV DT | INV DT | CUSTOMER | AMOUNT | STATUS
SH297934 |  |  | 2010-12-05 00:00:00 | [NAME] | 10832.5
SH297935 |  |  | 2010-12-06 00:00:00 | ALMAHABAH MEAT SHOP | 13600
SH297936 | SHOUKAT |  | 2010-12-07 00:00:00 | GULF PASTRY | 3100
SH297937 | SHOUKAT |  | 2010-12-08 00:00:00 | EXPRESS BROOST CHICKEN REST | 863
I need if C2 is empty and D2 date is more then 2 days from today then A2 cell will come red colour
Spreadsheet: 857305d1706310834-avg-conditionally-formatted-cells-rebel17-ld-mailroom-sp-production-beta
Sheet: Sheet1

Rep |  | Task 1 |  | E.O.M. |  | Task 2 |  | E.O.M. |  | Task 3 |  | E.O.M. |  | Task 4 |  | E.O.M. |  | Task 5 |  | E.O.M. |  | Task 6 |  | E.O.M. |  | OTHER |  |  | ScoreCard
 |  | Actual | Goal |  |  | Actual | Goal |  |  | Actual | Goal |  |  | Actual | Goal |  |  | Actual | Goal |  |  | Actual | Goal |  |  | Actual | Goal
Rep 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rep 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rep 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rep 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rep 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rep 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: louise_kitchen__23083__Commercial Headcount for NEWCO
Sheet: Power-East

EAST POWER
Benchluch, Moises |  | Associate | Fundamentals
Cline, [NAME] |  | Sr. Spec | Fundamentals
Giron, Gustavo |  | Associate | Fundamentals
Imai, Rika |  | Manager | Fundamentals
Kaniss, [NAME] |  | Analyst | Fundamentals
Marquez, Maurico |  | Associate | Fundamentals
[NAME], [NAME] |  | Manager | Fundamentals
Hiemstra, Nick | Power Origination | Sr. Spec | Structuring
Meyn, [NAME] | Power Origination | Dir | Structuring
Reyes, [NAME] |  | [NAME] | Structuring
Rust, [NAME] |  | Manager | Structuring
Trefz, Greg | Power Origination | Sr. Spec | Structuring
[NAME], [NAME] |  | Analyst | Structuring
Abler, [NAME]
Acevedo, [NAME] |  | Sr. Spec
[NAME], [NAME] |  | Sr. Spec
Aucoin, [NAME] | Power Origination | Dir
[NAME], [NAME] |  | VP
[NAME], [NAME] |  | Dir
Ballato, [NAME] |  | Analyst
[NAME], [NAME] |  | Sr. Spec
Baughman, [NAME] | Hourly | Manager
[NAME], Terrell | Power Origination | Associate
Benson, [NAME] |  | Dir
Braddock, [NAME] | Power Origination | Associate
Broderick, [NAME] |  | Manager
[NAME], [NAME] |  | Manager
[NAME], [NAME]
[NAME], [NAME] |  | Manager
[NAME] | Trading | [NAME]
Comeaux, [NAME] |  | Manager
Cross, [NAME] | Power Origination | Manager
[NAME], [NAME] | Power Origination | Dir
[NAME], [NAME] | Northeast Trading | VP
[NAME] | Marketing | [NAME]
[NAME], [NAME] | Power Origination | Dir
Forney, [NAME] |  | Dir
Forster, [NAME] | Power Origination | Dir
Furrow, Dale | Power Origination | VP
[NAME], [NAME] |  | Staff
[NAME], [NAME] |  | Dir
Gualy, Jaime |  | Associate
[NAME], Gautum |  | Manager
Herrera, [NAME] | Power Origination | VP
[NAME], [NAME] | Power Origination | Dir
Jafry, [NAME] | Power Origination | Dir
Jones, [NAME] | Power Origination | Dir
King, [NAME] |  | Manager
[NAME], [NAME] | Hourly | Analyst
[NAME] | admin | [NAME]
[NAME], [NAME] | Power Origination | Dir
Lowell, [NAME] |  | Analyst
Makkai, [NAME] |  | Analyst
Matthews, [NAME] |  | Associate
May, [NAME] |  | Manager
[NAME], Greg | Power Origination | Manager
Misra, Narsimha |  | Manager
Mitro, Fred | Power Origination | Dir
Munoz, Victor | Power Origination | Manager
Pacheco, [NAME] | Power Origination | Manager
Padron, [NAME] |  | Analyst
Pan, Liqun | Power Origination | Manager
Presto, [NAME] | East Power Trading | VP
[NAME], [NAME] | Power Origination | Dir
Rogers, [NAME] |  | Associate
Rorshock, [NAME] | Power Origination | Associate
Saibi, [NAME] |  | Analyst
Santucci, [NAME] |  | Sr. Spec
Schiavon, [NAME] |  | Associate
[NAME], [NAME] |  | Associate
Seely, [NAME] |  | Associate
Serio, [NAME] |  | Manager
Simoes, Catherine | Power Origination | Manager
Stalford, [NAME] |  | Manager
Sturm, [NAME] | Midwest Trading | VP
[NAME], [NAME] |  | Dir
Symms, [NAME] |  | Sr. Spec
Taek Oh, [NAME] |  | Associate
[NAME], [NAME] |  | Associate
[NAME] | Marketing | [NAME]
[NAME] | Marketing | [NAME]
TJ Black | Trading | [NAME]
[NAME], [NAME] |  | Analyst
[NAME], [NAME] | Power Origination | Manager
Wagner, [NAME] |  | Associate
Wang, [NAME] |  | Manager
[NAME], [NAME]
Wood, George | Power Origination | Manager
 | Total | 75