tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 867527d1714385769-a-chart-displaying-the-most-recent-7-filled-entries-but-i-dont-know-how-to-make-it-excelforum
Sheet: Insert here

Amount of people per week
Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | Week 34 | Week 35 | Week 36 | Week 37 | Week 38 | Week 39 | Week 40 | Week 41 | Week 42 | Week 43 | Week 44 | Week 45 | Week 46 | Week 47 | Week 48 | Week 49 | Week 50 | Week 51 | Week 52
17 | 21 | 19 | 22 | 16 | 23 | 22 | 22 | 14 | 18 | 20 | 21 | 22 | 23 | 15 | 17 | 26 | 21
Spreadsheet: 107452d1304617024-need-to-input-text-before-inputting-a-number-book1_brandy
Sheet: Sheet1

Performance | Bonus | The D/V formula
Outstanding | 20 | 1
 |  | 0
 |  | 0
Successful | 10 | 1
 |  | 0
Average | 5 | 1
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 85074d1285147418-picking-the-second-value-out-of-two-results-example
Sheet: Sheet1

6 | 14 | 18 | 0 | 0 | 0 | 0 | 12
7 | 16 | 19 | 22 | 0 | 0 | 0 | 13
4 | 9 | 18 | 21 | 0 | 0 | 0 | 12.5
5 | 10 | 0 | 0 | 0 | 0 | 0 | 7.5
7 | 10 | 0 | 0 | 0 | 0 | 0 | 8.5
2 | 5 | 13 | 17 | 0 | 0 | 0 | 9
Spreadsheet: 685682d1594139907-split-5-parameters-separated-by-and-into-series-of-columns-5-parameter-test
Sheet: PQ

Product | 1 | 2 | 3 |  | Product | 1.1 | 1.2 | 1.3 | 2.1 | 2.2 | 2.3 | 3.1 | 3.2 | 3.3 | 4.1 | 4.2 | 4.3 | 5.1 | 5.2 | 5.3
101 | 0219A&1&January&PC&4 | 0219B&3&February&PC&2 | 0219C&2&March&PM&2 |  | 101 | 0219A | 0219B | 0219C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
102 | 0220A&1&January&PC&4 | 0220B&3&February&PC&2 | 0220C&2&March&PM&2 |  | 102 | 0220A | 0220B | 0220C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
103 | 0221A&1&January&PC&4 | 0221B&3&February&PC&2 | 0221C&2&March&PM&2 |  | 103 | 0221A | 0221B | 0221C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
Spreadsheet: 875525d1722102919-using-dropdowns-to-indicate-task-completion-status-with-color-coding-no-merged-or-wrapped
Sheet: MICHAEL REHAB

 |  |  | Quad Dage
 |  |  | Sets | Reps | Kg
 |  | Reverse Lunge | 3 | 10 | BW
 |  | Single [NAME] | 3 | 5-8 | BW
 |  | Single [NAME] | 3 | 5-10 | BW
 |  |  | Posterior Chain Dage
 |  |  | Sets | Reps | Kg
 |  | Reverse Lunge | 3 | 10 | BW
 |  | Single [NAME] | 3 | 5-8 | BW
Spreadsheet: 861565d1709455076-how-to-transform-horizontal-data-with-merged-headers-to-a-vertical-format-sample-final
Sheet: Sheet1

 | Emplyee [NAME] |  |  |  |  |  |  |  |  |  |  | Father [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Child - 1 |  |  |  | Child - 2 |  |  |  | Child - 3 |  |  |  | Child - 4 |  |  |  | Child - 5 |  |  |  | Child - 6
Date | CNIC No. | Email address | Employee Code | Name of Employee | Department | Date of Joning  DD-MM-YYYY | Date of Birth | Gender | Employee Age | Address | [NAME] | Name | CNIC | Date Of Birth | Age | Name | CNIC | Date Of Birth | Age | Name | CNIC | Date Of Birth | Age | Name | Date Of Birth | Gender | Age | Name | Date Of Birth | Gender | Age | Name | Date Of Birth | Gender | Age | Name | Date Of Birth | Gender | Age | Name | Date Of Birth | Gender | Age | Name | Date Of Birth | Gender | Age | Present Salary | Contact Number
 | 123 | AAA | 100 | ABC | Marketing | 2017-10-10 00:00:00 | 1990-01-13 00:00:00 | FEMALE | 33 | Flat#123 | Married | ADDDD | 111 |  | 61 | GHI | 222 |  | 60 | JB | 203 | 1990-01-13 00:00:00 | 30 | HGAA |  | Male | 5 | PHAI |  |  | 2
 | 111 | BBB | 103 | CCD | Prod | 2022-06-01 00:00:00 | 1986-04-09 00:00:00 | MALE | 36 | Flat#124 | Married | ABGGG | 11111 |  | 65 |  |  |  |  | BH | 1011 | 1990-01-13 00:00:00 | 30 | VGG |  | Male | 4 | ABGH |  |  | 2 | HVVV |  |  | 1
 | 201 | CCC | 101 | GHT | Export | 2017-02-01 00:00:00 | 1986-06-08 00:00:00 | MALE | 36 | Flat#182 | Married |  |  |  | 70 | HGN | 333 |  | 65 | NU | 3000 | 1990-01-13 00:00:00 | 30 | TH |  | Male | 3
The Above data is too large of employees and the main headers are merged. I need the details as per below template.
Employee Code | Name | Age | Desig/Relation | CNIC No. | Date Of Birth
100 | ABC | 33 | Marketing | 123 | 1990-01-13 00:00:00 |  |  | Name | Age | Desig/Relation | CNIC No | Date of Birth
 | ADDDD | 61 | Father | 111 |  |  | 100 | ABC | 33 | Marketing | 123 | 1990-01-13 00:00:00
 | GHI | 60 | Mother | 222 |  |  |  | ADDDD | 61 | Father | 111
 | JB | 30 | Spouse | 203 | 1990-01-13 00:00:00 |  |  | GHI | 60 | Mother | 222
 | HGAA | 5 | Child-1 |  |  |  |  | JB | 30 | Spouse | 203 | 1990-01-13 00:00:00
103 | CCD | 36 | Prod | 111 | 1986-04-09 00:00:00 |  |  | HGAA | 5 | Child - 1
 | ABGGG | 65 | Father | 11111 |  |  |  | PHAI | 2 | Child - 2
 | BH | 30 | Spouse | 1011 | 1990-01-13 00:00:00 |  | 103 | CCD | 36 | Prod | 111 | 1986-04-09 00:00:00
 | VGG | 4 | Child-1 |  |  |  |  | ABGGG | 65 | Father | 11111
 | ABGH | 2 | Child-2 |  |  |  |  | BH | 30 | Spouse | 1011 | 1990-01-13 00:00:00
 | HVVV | 1 | Child-3 |  |  |  |  | VGG | 4 | Child - 1
101 | GHT | 36 | Export |  | 1986-06-08 00:00:00 |  |  | ABGH | 2 | Child - 2
 | HGN | 65 | Mother | 333 |  |  |  | HVVV | 1 | Child - 3
 | NU | 30 | Spouse | 3000 | 1990-01-13 00:00:00 |  | 101 | GHT | 36 | Export | 201 | 1986-06-08 00:00:00
 | TH | 3 | Child-1 |  |  |  |  | HGN | 65 | Mother | 333
 |  |  |  |  |  |  |  | NU | 30 | Spouse | 3000 | 1990-01-13 00:00:00
 |  |  |  |  |  |  |  | TH | 3 | Child - 1
Spreadsheet: 115927d1311364171-calculation-of-categories-and-sub-categories-with-data-validation-changes
Sheet: Guest Experience Log

DAILY SHIFT REPORT
Day / Date
Credit Limit Letters |  |  |  |  |  |  |  |  | End of Day House Status
Room |  |  | Name |  | Payment Received |  | Due Out |  | Occupancy
 |  |  |  |  |  |  |  |  | Rooms Occupied
 |  |  |  |  |  |  |  |  | OOO Rooms
Physically / Mentally Impaired Guests In-House |  |  |  |  |  |  |  |  | Arrivals
Room |  |  | Name |  | Disability |  | Due Out |  | VIP Arrivals
 |  |  |  |  |  |  |  |  | Departures
 |  |  |  |  |  |  |  |  | VIP Departures
[NAME] |  |  |  |  |  |  |  |  | Adults In House
Room |  |  | Name |  | Checked |  | Due Out |  | Children In House
 |  |  |  |  |  |  |  |  | Conference Blocks In House
 |  |  |  |  |  |  |  |  | VIPs In House
AM Shift
Assistant Manager |  |  |  |  | Occupancy
Front Desk Team |  |  |  |  | Arrivals
Concierge Team |  |  |  |  | Departures
Shift Notes / Issues
Time | By Whom | Room | Name |  | Comments & Resolution |  |  | Category | Sub Category | [NAME]
 |  |  |  |  |  |  |  | Grapevine Dinner | Drink Service | 25
 |  |  |  |  |  |  |  | Check In | Booking under Different Name | 15
PM Shift
Assistant Manager |  |  |  |  | Occupancy
Front Desk Team |  |  |  |  | Arrivals
Concierge Team |  |  |  |  | Departures
Shift Notes / Issues
Time |  | Room | Name |  | Comments & Resolution |  |  | Category | Cause / Problem | [NAME]
Night Audit Shift
Assistant Manager |  |  |  |  | Occupancy
Front Desk Team |  |  |  |  | Arrivals
Concierge Team |  |  |  |  | Departures
Shift Notes / Issues
Time |  | Room | Name |  | Comments & Resolution |  |  | Category | Cause / Problem | [NAME]
Spreadsheet: 872306d1718690879-help-with-doing-a-transpose-basicall-columns-combined-into-a-column-rows-become-column-sampleprofiledata-solution-aligw
Sheet: Sheet1

What I have:
Profile | Object | Permission1 | Permission2 | Permission3 | Permission4 | Permission5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Solution:
P1 | O1 | F | F | T | T | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1 | P2 | P3
P1 | O2 | T | T | F | F | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O1
P2 | O1 | F | T | F | T | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 1 | F | F
P3 | O3 | T | T | T | F | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 2 | F | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 3 | T | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 4 | T | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 5 | T | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 1 | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 2 | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 3 | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 4 | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 5 | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 1 |  |  | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 2 |  |  | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 3 |  |  | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 4 |  |  | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permission 5 |  |  | F
Spreadsheet: 29575d1224661922-locking-formulas-master
Sheet: Fixings

 |  | Job No: | 0
 |  | Main Contractor | 0
 |  | Site | 0
 |  | Descripion | #N/A
Fixings
Quantity ordered | Quantity Sent | Connection Item | Description | Order No | Cost Each | Total Cost
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  | TOTAL COST | 0
Spreadsheet: 737902d1624646886-combining-or-sorting-non-numerical-values-by-their-adjacent-duplicate-acc-s-into-1-row-example-of-query
Sheet: Sheet1

Account Number | Symbol (Holding) | Account Numbers Unique | Holdings (Desired Outcome 1) | If first outcome is impossible, here's another desired outcome that would still work for me
ABC123 | AEG | ABC123 | AEG AMRX AMZN APTS | AEG | AMRX | AMZN | APTS
ABC123 | AMRX | DEF123 | CBOE CNC CVS FNF KO MS ORCL SLF TY | CBOE | CNC | CVS | FNF | KO | MS | ORCL | SLF | TY
ABC123 | AMZN | GHI123 | CNC KO MS PRLB SLF TY | CNC | KO | MS | PRLB | SLF | TY
ABC123 | APTS | JKL123 | CBOE CNC FNF KO MS ORCL SLF TY | CBOE | CNC | FNF | KO | MS | ORCL | SLF | TY
DEF123 | CBOE | MNO123 | GE GM MARA T | GE | GM | MARA | T
DEF123 | CNC
DEF123 | CVS
DEF123 | FNF
DEF123 | KO
DEF123 | MS
DEF123 | ORCL
DEF123 | SLF
DEF123 | TY
GHI123 | CNC
GHI123 | KO
GHI123 | MS
GHI123 | PRLB
GHI123 | SLF
GHI123 | TY
JKL123 | CBOE
JKL123 | CNC
JKL123 | FNF
JKL123 | KO
JKL123 | MS
JKL123 | ORCL
JKL123 | SLF
JKL123 | TY
MNO123 | GE
MNO123 | GM
MNO123 | MARA
MNO123 | T
Spreadsheet: 167102d1341901803-need-help-with-soccer-table-please-soccer-table
Sheet: Fifa12 Spreadsheet

 |  |  | P | W | D | L | GF | GA | (+/-) | Pts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Home | Score | Away | Score | Home Result
AC Milan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manchester City | 0 | Barcelona | 0
Barcelona |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AC Milan | 1 | Real Madrid | 0
Chelsea |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chelsea | 0 | Manchester City | 0
Manchester City |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Real Madrid | 0 | Chelsea | 0
Real Madrid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Barcelona | 2 | AC Milan | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manchester City | 0 | AC Milan | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manchester City | 0 | AC Milan | 0
 | Match Day 1 |  |  |  |  |  | Match Day 2 |  |  |  |  |  | Match Day 3
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | Match Day 4 |  |  |  |  |  | Match Day 5 |  |  |  |  |  | Match Day 6
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | Match Day 7 |  |  |  |  |  | Match Day 8 |  |  |  |  |  | Match Day 9 |  |  |  |  |  | Match Day 10
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 |  |  | P | W | D | L | GF | GA | (+/-) | Pts
AC Milan
Barcelona
Chelsea
Manchester City
Real Madrid
Spreadsheet: daren_farmer__6636__CES - April
Sheet: LONE

Purchase
 | From [NAME]
 | At Sandtrap
 | For IF -.12 (base) and GDA-.13 (swing)
Sale
 | To TXU Energy
 | At Sandtrap
 | For IF-.09
Term
 | [NAME] is thru 6/01
 | TXU is thru 11/00
Other
 | TXU picks up the gas at the Fairway Plant
 |  | [NAME] At TXU [PHONE]
 |  | [NAME] is the operator
 | Gas is [NAME]'s and other working interest owners
 | Meter 178477
Deal Numbers
 | Supply
 | [NAME] | 139267 | Base
 |  | 143609 | Swing
 | CoOwners | 141977
 |  | 141978
 |  | 141930
 | Market | 144129
Spreadsheet: 808600d1670529496-need-to-exclude-weekends-from-total-countif-formula-2022-annual-leave-tracker-sample
Sheet: Mark Leave

ID | EMP ID | EMP Name | Date | Leave Type | Reason
 | 10001 | TEST Person | 2022-12-01 00:00:00 | V
 | 10001 | TEST Person | 2022-12-05 00:00:00 | HD
 | 10001 | TEST Person | 2022-12-07 00:00:00 | WH
 | 10001 | TEST Person | 2022-12-16 00:00:00 | SL
 | 10001 | TEST Person | 2022-12-17 00:00:00 | SL
 |  |  |  |  | Funeral
 |  |  |  |  | Funeral
 |  |  |  |  | Funeral
 |  |  |  |  | Funeral
 |  |  |  |  | Funeral
 |  |  |  |  | Funeral
 |  |  |  |  | Funeral
 |  |  |  |  | Funeral
 |  |  |  |  | Funeral
Spreadsheet: 114196d1309997079-index-match-search-works-in-some-cells-but-not-others-expense
Sheet: expenses

 |  | Overhead |  |  |  | Network |  |  |  | Contract Salaries |  |  |  | One-time Expenses
 |  | Company A | Paid? | Company B | Paid? | Company A | Paid? | Company B | Paid? | Company A | Paid? | Company B | Paid? | Company A | Paid? | Company B | Paid?
2011 | Aug | 518 | 1 | 518 | 1 | 12.495 | 0 | 12.495 | 0 | 50 | 0 | 50 | 0 | 87.5 | 0 | 87.5 | 0
 | Sep | 518 | 0 | 518 | 0 | 12.495 | 0 | 12.495 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Oct | 518 | 0 | 518 | 0 | 12.495 | 0 | 12.495 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Nov | 518 | 0 | 518 | 0 | 12.495 | 0 | 12.495 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Dec | 518 | 0 | 518 | 0 | 12.495 | 0 | 12.495 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012 | Jan | 518 | 0 | 518 | 0 | 12.495 | 0 | 12.495 | 0 | #N/A | 0 | #N/A | 0 | 0 | 0 | 0 | 0
 | Feb | 518 | 0 | 518 | 0 | 12.495 | 0 | 12.495 | 0 | #N/A | 0 | #N/A | 0 | 0 | 0 | 0 | 0
 | Mar | 518 | 0 | 518 | 0 | 12.495 | 0 | 12.495 | 0 | #N/A | 0 | #N/A | 0 | 0 | 0 | 0 | 0
 | Apr | 518 | 0 | 518 | 0 | 12.495 | 0 | 12.495 | 0 | #N/A | 0 | #N/A | 0 | 0 | 0 | 0 | 0
 | May | 518 | 0 | 518 | 0 | 12.495 | 0 | 12.495 | 0 | #N/A | 0 | #N/A | 0 | 0 | 0 | 0 | 0
 | June | 0 | 0 | 1036 | 0 | 0 | 0 | 24.99 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | 0 | 0
 | July | 0 | 0 | 1036 | 0 | 0 | 0 | 24.99 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fixed Monthly |  | One-time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense | Amount | Expense | Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overhead | 1036 | Installation | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Network | 24.99 | Certification | 100
Variable Monthly
 |  | Contract Salaries
2011 | Aug | 100
 | Sep | 351
 | Oct | 122
 | Nov | 101
 | Dec | 371
2012 | Jan | 139
 | Feb | 302
 | Mar | 270
 | Apr | 232
 | May | 441
 | June | 246
 | July | 365
Spreadsheet: 107927d1305059908-excel-2007-headcount-based-on-date-and-start-stop-times-copy-of-manpower-2
Sheet: Report

 | Headcount by Half Hour
 | Monday | Tuesday | Wednesday | Thursday | Friday
 | 2011-05-09 00:00:00 | 2011-05-10 00:00:00 | 2011-05-11 00:00:00 | 2011-05-12 00:00:00 | 2011-05-13 00:00:00
06:00:00 | 0 | 0 | 1 | 0 | 0
06:30:00 | 1 | 1 | 1 | 1 | 1
07:00:00 | 2 | 2 | 2 | 2 | 2
07:30:00 | 2 | 2 | 2 | 2 | 2
08:00:00 | 2 | 2 | 2 | 2 | 2
08:30:00 | 2 | 2 | 2 | 2 | 2
09:00:00 | 3 | 2 | 3 | 3 | 3
09:30:00 | 3 | 2 | 3 | 3 | 3
10:00:00 | 4 | 3 | 4 | 3 | 4
10:30:00 | 4 | 3 | 4 | 3 | 4
11:00:00 | 4 | 3 | 4 | 4 | 4
11:30:00 | 4 | 3 | 4 | 4 | 4
12:00:00 | 3 | 3 | 3 | 3 | 3
12:30:00 | 3 | 3 | 3 | 3 | 3
13:00:00 | 3 | 3 | 3 | 3 | 3
13:30:00 | 3 | 3 | 3 | 3 | 3
14:00:00 | 3 | 3 | 3 | 3 | 3
14:30:00 | 3 | 3 | 2 | 3 | 3
15:00:00 | 2 | 2 | 2 | 2 | 2
15:30:00 | 1 | 1 | 1 | 1 | 1
16:00:00 | 1 | 1 | 1 | 1 | 1
16:30:00 | 1 | 1 | 1 | 1 | 1
17:00:00 | 1 | 1 | 1 | 1 | 1
17:30:00 | 1 | 1 | 1 | 1 | 1
18:00:00 | 1 | 1 | 1 | 1 | 1
18:30:00 | 0 | 0 | 0 | 1 | 0
19:00:00 | 0 | 0 | 0 | 1 | 0
19:30:00 | 0 | 0 | 0 | 0 | 0
Spreadsheet: tracy_geaccone__40323__3rd quarter curr est
Sheet: CashCorpPlan

DETAIL OF CHANGE IN CASH FROM CORPORATE
(Millions of Dollars)
 |  |  |  |  | 2001
 |  |  |  |  | 3rd CE |  | PLAN |  | [NAME]
Cash from Corporate Information
 | Net Income After Financing Costs |  |  |  |  |  |  |  |  | (1)
 | Price Risk Management Activities |  |  |  |  |  | 0
 | Other Non-Cash Items |  |  |  |  |  |  |  |  | (1)
 | Net (Gain) / Loss from Sale of Assets |  |  |  |  |  | 8.3
 | Net Production Payments |  |  |  |  |  | 0
 | Equity Earnings |  |  |  |  |  | 0
 | Equity Distributions |  |  |  |  |  | 0
 | Working Capital Changes |  |  |  |  |  | -120.7 |  |  | (2)
 | Proceeds from Sale of Assets |  |  |  |  |  | 0
 | Capital Expenditures |  |  |  |  |  | -193.1 |  |  | (3)
 | Dividends to EPC |  |  |  |  |  | -82.4 |  |  | (4)
 | Change in Third Party Debt |  |  |  |  |  | 240.8 |  |  | (2)
 | Other Cash Changes |  |  |  |  |  |  |  |  | (5)
 |  | (Increase) / Decrease in Cash From Corporate
Cash From Corporate Variance Analysis
Please explain variances.
(1) |  | Plan has been adjusted by ($3.4) mm for GATX fee and $10.4 mm for transfer of goodwill
(2) |  | Trading deposits
(3) |  | Distribution and [NAME] 24 MW project
(4) |  | 3rd and 4th quarter dividends reflected as loan to Corp.
(5) |  | COLI $31.5 mm loss compared to plan
Spreadsheet: 70535d1271258846-excel-2007-making-cells-follow-other-cells-monthly-gas-reports-2010-master-v6
Sheet: WEX Report

Truck # | System  YTD | WEX  YTD | YTD Difference | Blank | Receipts | January WEX | Difference | Blank2 | FEB Receipts | February WEX | FEB Difference | Blank3 | March Receipts | March WEX | March Difference | Blank4 | April Receipts | April WEX | [NAME] | Blank5 | May Receipts | May WEX | [NAME] | Blank6 | June Receipts | June WEX | June Difference | Blank7 | July Receipts | July WEX | July Difference | Blank8 | August Receipts | August WEX | August Difference | [NAME] | [NAME] | September WEX | [NAME] | Blank10 | [NAME] | October WEX | [NAME] | Blank11 | Nov Receipts | November WEX | Nov Difference | Blank12 | Dec Receipts | December WEX | [NAME]
Spreadsheet: 137692d1327327345-total-of-each-operation-test-total-of-item
Sheet: Sheet1

Operation | Time |  | Operation | Operation | Operation
Threading | 6 |  | Threading | Attach | Slope
Threading | 6
Attach | 6
Threading | 6
Attach | 6
Threading | 6
Threading | 6
Attach | 6
Attach | 6
Threading | 6
Attach | 6
Attach | 6
Attach | 6
Slope | 6
Attach | 6
Attach | 6
Slope | 6
Slope | 6
Slope | 6
Total Threading
Total Attach
Total Slope
Spreadsheet: 275240d1383414156-how-to-use-index-and-match-with-multiple-criteria-driverssample
Sheet: Winners

RaceID | Year | Race | Driver | Time
1 | 2012 | 7
2 | 2012 | 8
3 | 2013 | 1
4 | 2013 | 2
5 | 2013 | 3
Spreadsheet: 4547bdc9-d899-42f0-b282-9085d641ac92
Sheet: 10. Structures by Agency

FY 2013 Federal Real Property Charts
Structures†
Agency | Owned Structure Assets** | Owned Annual Operating Costs** | Leased Structure Assets | Lease Annual Costs*
Agriculture | 17695 | 266760592.36 | 56 | 56451.64
Air Force*** | 70934 | 1590871653.99 | 3435 | 110914031.74
Army*** | 176794 | 1555391092.75 | 5095 | 56080504.82
Commerce | 105 | 10289661 | 560 | 2307774.96
Corps of Engineers*** | 3702 | 741440677 | 41 | 951643.83
Defense/WHS*** | 515 | 2074458.37
Energy | 7669 | 329784619 | 1 | 3064
Environmental Protection Agency | 101 | 410160.69 | 3 | 5805171.6
General Services Administration | 180 | 31286665.98 | 117 | 8194769
Health and Human Services | 84 | 23386410.874
Homeland Security | 35641 | 277732946.41 | 1615 | 16760423.39
Interior | 75456 | 984212523.1120001 | 18 | 230211.03
Justice | 389 | 1145247 | 1 | 42800
Labor | 1641 | 874208.8 | 39 | 79637.573
National Aeronautics And Space Administration | 2363 | 129529024 | 5 | 1561992
National Science Foundation | 228 | 9551747
Navy*** | 59705 | 2173908162.9 | 5676 | 225601805.05
State | 1982 | 43876013.86 | 300 | 10939749.15
State (USAID) | 4 | 159518.28 | 5 | 79904.95
Transportation | 42506 | 79753746.47 | 225 | 2261745.55
Veterans Affairs | 2956 | 20670278.78 | 1 | 0
Total
† All real property data from the CFO Act agencies required to submit data to the FRPP
*Includes operations and maintenance costs and rent
**includes federal government owned, foreign government owned, museum trust, state government owned
*** Department of Defense
Spreadsheet: 80dbe1d2-a509-4382-928f-ed1804352fc8
Sheet: Other Services

Other Services
Firm Name | Contact Person | [NAME]
Bozzuto Insurance Services | [NAME] | [EMAIL]
Cushman & Wakefield | [NAME] | [NAME]
NERT | [NAME] | [EMAIL]
USGS | [NAME] | [EMAIL]
Bay Area Earthquake Alliance | [NAME] | [EMAIL]
SPUR | [NAME] | [EMAIL]
SFAA | [NAME] | [EMAIL]
ABAG | [NAME] | [EMAIL]
Marx|Okubo Associates | [NAME] | [EMAIL]
SEAONC | [NAME] | [EMAIL]
ZFA | [NAME] | [EMAIL]
Red Cross | Amiling, [NAME] | [EMAIL]
Rebuilding Together San Francisco | [NAME] | [EMAIL]
Quake Prepare | [NAME] | [EMAIL]
AEG | [NAME] | [EMAIL]
EERI | [NAME] | [EMAIL]
AACA | [NAME] | [EMAIL]
RBA | Grace Shanahan | [EMAIL]
CEA (CRMP) 2 tables | [NAME] | [EMAIL]
CGS | [NAME] | [EMAIL]
Paragon Real Estate | [NAME] | [EMAIL]
ETC Building and Design | [NAME] | [EMAIL]
Bubble Real Estate | [NAME] | [EMAIL]
True Market Solutions/ LittleFootprint Lighting | [NAME] | [EMAIL]
Brown and Co. Real Estate | [NAME] | [EMAIL]
Better Homes & Gardens Real Estate Mason-McDuffie | [NAME] | [EMAIL]
Intero Real Estate Services | Dyniece Abril | [EMAIL]
Re/Max- Prestigious Properties | [NAME] | [EMAIL]
LeaseLords | [NAME] | [EMAIL]
Alliance Environmental Group, Inc. | [NAME] | [EMAIL]
Spreadsheet: 878556d1725640614-return-values-excluding-2-sets-of-date-criteria-example-exclude-dates
Sheet: Sheet1

City | Sales | Date of Sale | Review Date
Hong Kong | 4 | 2021-04-05 00:00:00 | 2022-11-05 00:00:00
NY | 3 | 2022-03-22 00:00:00
LA | 5.5 | 2021-12-02 00:00:00
Berlin | 6 | 2024-02-03 00:00:00
Amsterdam | 2 | 2023-06-04 00:00:00 | 2023-12-05 00:00:00
Santiago | 8 | 2020-08-05 00:00:00
Spreadsheet: 116486d1311864321-vlookup-with-if-function-example1
Sheet: Sheet1

 | 2 | 1
 | 4 | 2
 | 5 | 3
 | 6 | 4
 | 9 | 5
 | 11 | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17 |  | Ineed the cell in colume A to have a "1" them when the value in column B is somehere in the entire array C.
 |  | 18
 |  | 19
 |  | 20