tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 794880d1662378235-absence-trackershowing-extra-days-in-some-months-how-to-fix-employee-absence-tracker
Sheet: June Abs Data

 |  |  | PLEASE NOTE:  The start day is the first day of leave/sickness and the end date is the last day of leave/sickness and NOT the day that they retun to work
 | Employee Name | Start Date | End Date | Type of Leave | Reason for Sickness Absence | Other reasons for Leave Of Absence | Days | Self Cert Completed | Teaching / Non Teaching | Continued absence from previous month? | Has a Doctors Note been submitted? | Doctors Note Start | Doctors Note End | Is the [NAME] ongoing at the end of the month
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-30 00:00:00 | Sickness Absence | Heart (Pressure, Circulation etc)
 | Employee 1 | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | Sickness Absence | Mental Health (Stress / Anxiety etc)
 | Employee 1 | 2022-08-10 00:00:00 | 2022-08-12 00:00:00 | Sickness Absence | Back / Neck
 | Employee 1 | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | Dependant Care Paid
 | Employee 1 | 2022-08-24 00:00:00 | 2022-08-26 00:00:00 | Compassionate Paid
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-29 00:00:00 | Leave of Absence Paid |  | Fertility
 | Employee 1 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | Leave of Absence Unpaid |  | Study Leave
 | Employee 1 | 2022-05-05 00:00:00 | 2022-05-15 00:00:00 | Dependant Care Unpaid
 | Employee 1
 | Employee 1
Spreadsheet: 740746d1626530383-count-occurrences-in-the-last-7-days-book1
Sheet: Sheet1

Date | Unit | Last 7 days
2021-07-01 00:00:00 | A | 0
2021-07-01 00:00:00 | A | 0
2021-07-01 00:00:00 | B | 0
2021-07-02 00:00:00 | B | 0
2021-07-03 00:00:00 | B | 0
2021-07-03 00:00:00 | A | 0
2021-07-03 00:00:00 | A | 0
2021-07-05 00:00:00 | B | 0
2021-07-05 00:00:00 | B | 0
2021-07-06 00:00:00 | A | 0
2021-07-06 00:00:00 | A | 0
2021-07-09 00:00:00 | B | 0
2021-07-09 00:00:00 | A | 0
2021-07-12 00:00:00 | A | 4
2021-07-12 00:00:00 | A | 4
2021-07-13 00:00:00 | B | 5
2021-07-13 00:00:00 | B | 5
2021-07-15 00:00:00 | A | 4
2021-07-15 00:00:00 | B | 5
2021-07-15 00:00:00 | B | 5
2021-07-16 00:00:00 | B | 5
2021-07-16 00:00:00 | A | 4
Today = 17/07/2021
Spreadsheet: 83378d1283362738-index-and-vlookup-help-within-a-table-nfl2010
Sheet: Team

Team | Green Bay |  |  |  | Qual Games |  |  |  | For more about this sort of array formula see these videos:
 |  |  |  |  |  |  |  |  | Excel Magic Trick 358: Part 1: Return Multiple Items From
Week # | Date | G # | Bet Team | H/A | Opponent | [NAME] | Profit |  | Excel Magic Trick 360: Part 3: Return Multiple Items From
 |  |  |  |  |  |  |  |  | Excel Magic Trick 359: Part 2: Return Multiple Items From
 |  |  |  |  |  |  |  |  | For the basics of array formulas see this playlist:
 |  |  |  |  |  |  |  |  | http://www.youtube.com/view_play_list?p=007E7E9CA63304D3
 |  |  |  |  |  |  |  |  | Ctrl + T to create Table that has dynamic ranges
Spreadsheet: 722203d1615114726-rotate-cells-by-grouping-excel
Sheet: Sheet1

Have
Customer_Name | Purchase
[NAME] | Laptop
[NAME] | [NAME]
[NAME] | Headphones
[NAME] | Laptop
[NAME] | Notebook
 |  |  |  | Want:
 |  |  |  | Customer_Name | Purchase1 | Purchase2 | Purchase3
Spreadsheet: 79501d1279746634-eliminating-un-necessary-spacings-exampledoc5
Sheet: Sheet1

STORE A COLUMN | STORE B COLUMN | COMMON STORES | DESIRED COLUMN!! |  |  | helper | result
15 | 12 | 15 | 15 |  |  | 2 | 15
20 | 15 |  | 25 |  |  |  | 25
25 | 200 | 25 | 40 |  |  | 4 | 40
30 | 122
35 | 40
40 | 25 | 40 |  |  |  | 7
Spreadsheet: 539324d1506051531-dynamic-scatter-plot-based-on-value-in-cell-dynamicchart
Sheet: (L3) Milestone tracking

ProjectID | Project Phase | X-axis | Y-axis |  | Show only with ProjectID:
3010 | [NAME] | 2017-01-19 00:00:00 | Completed |  | 1279
1279 | Pilot National groups on new Emp | 2017-02-17 00:00:00 | Completed
125 | [NAME] | 2017-02-20 00:00:00 | Completed
1279 | Migrate all national users to ne | 2017-03-03 00:00:00 | Completed
1246 | [NAME] | 2017-03-27 00:00:00 | Completed
1269 | Finalize Stakeholder Engagement | 2017-05-26 00:00:00 | Completed
1546 | Introduce Reimagined and Rationa | 2017-06-20 00:00:00 | Completed
612 | Finalize LOE & Timeframes | 2017-07-01 00:00:00 | Completed
1269 | Finalize training curriculum | 2017-07-17 00:00:00 | Completed
1546 | Go-Live Release A | 2017-07-23 00:00:00 | Cancelled
1546 | Go-Live Release B | 2017-09-25 00:00:00 | Due
3010 | IT Release - Enrollment Delivera | 2017-10-16 00:00:00 | On track
3010 | IT Release - Core Functionality | 2017-11-13 00:00:00 | On track
1269 | Go Live - Technology (Option 2 & | 2018-03-30 00:00:00 | On track
612 | Go-Live Mass rollout of maintena | 2018-03-31 00:00:00 | On track
125 | Launch Broker Communities for Ne | 2018-04-06 00:00:00 | On track
1279 | Production Release of  [NAME] | 2018-06-15 00:00:00 | On track
125 | Launch Broker Communities Renewa | 2018-09-03 00:00:00 | On track
Spreadsheet: 160352d1339062482-compare-cell-values-to-cell-range-and-indicate-if-value-is-found-bookgv
Sheet: Sheet1

ALL USERS
codes | first name | last name | INDICATION IF SUCCESSFUL |  |  | success codes
100 | Fname1 | Lname1 |  |  |  | 200
200 | Fname2 | Lname2 |  |  |  | 300
300 | Fname3 | Lname3 |  |  |  | 500
400 | Fname4 | Lname4 |  |  |  | 900
500 | Fname5 | Lname5 |  |  |  | 1200
600 | Fname6 | Lname6
700 | Fname7 | Lname7
800 | Fname8 | Lname8
900 | Fname9 | Lname9
1000 | Fname10 | Lname10
1100 | Fname11 | Lname11
1200 | Fname12 | Lname12
1300 | Fname13 | Lname13
1400 | Fname14 | Lname14
1500 | Fname15 | Lname15
Spreadsheet: 788838d1658757682-age-in-y-m-d-format-from-days-or-months-agetable-ans
Sheet: Sheet1

MOS | DAYS | WKS | YRS | YRSMOS | YRSMOSDAYS | AGECAT
 |  |  |  |  |  | C1
 |  |  |  |  |  | C1
 |  |  |  |  |  | C1
 |  |  |  |  |  | C1
Spreadsheet: 710668d1609175635-find-and-return-values-based-off-of-multiple-conditions-return-multiple-matches-with-multiple-conditions-jacc-2
Sheet: STOCK

PRODUCT | TAG | QTY |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1336423-find-and-return-values-based-off-of-multiple-conditions.html
40887501820 | 1.73217304031263e+17 | 8
40887501820 | 2.73129817022015e+17 | 15
40887501820 | 2.73129807166142e+17 | 16
43341404020 | 2.73129817022015e+17 | 16
43341404020 | 2.73129817020341e+17 | 20
39573004420 | 1.73217304018652e+17 | 28
39573004420 | 2.7312981702202e+17 | 30
40887501820 | 2.7312981702202e+17 | 30
40887501820 | 1.73217304018652e+17 | 32
39573004420 | 2.7312981702202e+17 | 35
40887501820 | 2.7312981702198e+17 | 35
43341404020 | 2.7312981702198e+17 | 35
39573004420 | 2.73129817022021e+17 | 40
39573004420 | 1.7321730397559e+17 | 40
39573004420 | 1.7321730397559e+17 | 45
40887501820 | 1.7321730397559e+17 | 45
40887501820 | 2.73129817022022e+17 | 47
40887501820 | 2.73129817022022e+17 | 48
39573004420 | 2.73129817021973e+17 | 50
39573004420 | 2.73129817021973e+17 | 50
40887501820 | 2.73129817021979e+17 | 50
40887501820 | 2.73129817021979e+17 | 50
40887501820 | 2.73129817021981e+17 | 50
40887501820 | 2.73129817021972e+17 | 50
40887501820 | 1.7321730397559e+17 | 50
43341404020 | 2.73129817021981e+17 | 50
39573004420 | 2.7312981702198e+17 | 52
39573004420 | 2.73129817021976e+17 | 52
40887501820 | 2.73129817021981e+17 | 52
40887501820 | 2.73129817021981e+17 | 52
43341404020 | 2.73129817021979e+17 | 52
39573004420 | 2.7312981702198e+17 | 53
39573004420 | 2.73129817021981e+17 | 53
40887501820 | 2.73129817021979e+17 | 53
40887501820 | 2.7312981702198e+17 | 53
39573004420 | 2.73129817022021e+17 | 55
39573004420 | 2.73129817021992e+17 | 55
39573004420 | 2.73129817021995e+17 | 55
39573004420 | 1.7321730397559e+17 | 55
40887501820 | 2.73129817021981e+17 | 55
40887501820 | 2.73129817021992e+17 | 55
40887501820 | 2.73129817021995e+17 | 55
43341404020 | 2.73129817021981e+17 | 55
43341404020 | 2.73129817021973e+17 | 55
43341404020 | 2.73129817021973e+17 | 55
40887501820 | 1.73217304070303e+17 | 100
40887501820 | 1.73217304070303e+17 | 105
40887501820 | 1.73217304070303e+17 | 110
Spreadsheet: 777935d1650685056-how-to-change-cell-name-based-on-another-cell-and-place-data-on-correct-row-sample-workbook-kittybat-
Sheet: PIVOT

Sum of number | Column Labels |  |  |  |  |  |  | echeckin | Values
Row Labels | Completed | In Progress | Not Started | Not Yet Available | Grand Total |  |  | Completed |  | In Progress |  | Not Started |  | Not Yet Available |  | Total Count | Total %
CLINIC1 [10402254] | 92 | 9 | 19 | 1 | 121 |  | Epic Dept. | Count | % | Count | % | Count | % | Count | %
CLINIC2 [10402304] | 46 | 3 | 0 | 0 | 49 |  | CLINIC 1 OP | 92 | 0.7603305785123967 | 9 | 0.0743801652892562 | 19 | 0.1570247933884298 | 1 | 0.008264462809917356 | 121 | 1
CLINIC3 [10402165] | 0 | 3 | 0 | 0 | 3 |  | CLINIC 2 OP | 46 | 0.9387755102040817 | 3 | 0.06122448979591837 | 0 | 0 | 0 | 0 | 49 | 1
Grand Total | 138 | 15 | 19 | 1 | 173 |  | CLINIC 3 OP | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 3 | 1
 |  |  |  |  |  |  | Grand Total | 138 | 0.7976878612716763 | 15 | 0.08670520231213873 | 19 | 0.1098265895953757 | 1 | 0.005780346820809248 | 173 | 1
Spreadsheet: 729236d1618971482-conditional-formatting-formula-based-on-length-of-expired-date-training-register
Sheet: Sheet1

 |  | Employee
Training Type | Frequency | [NAME] | [NAME] | Danial Jones | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Contractors & Site Visitors | 6 monthly | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00 | 2021-01-11 00:00:00
High Reach Evaluations | 6 monthly | 2012-01-01 00:00:00 | 2021-01-18 00:00:00
Counter Balance Evaluations | 6 monthly | 2020-10-01 00:00:00 | 2021-02-08 00:00:00
Pre-Op Demonstration | 6 monthly |  | 2021-01-18 00:00:00
Absent/Late process | 6 monthly |  | 2021-02-01 00:00:00
Spreadsheet: lisa_gang__22316__ENA_PGE_JUNE_11_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-06-11 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0
0700 | 50 | 25 | 25 | 25 | 25
0800 | 50 | 25 | 25 | 25 | 25
0900 | 50 | 25 | 25 | 25 | 25
1000 | 50 | 25 | 25 | 25 | 25
1100 | 50 | 25 | 25 | 25 | 25
1200 | 50 | 25 | 25 | 25 | 25
1300 | 50 | 25 | 25 | 25 | 25
1400 | 50 | 25 | 25 | 25 | 25
1500 | 50 | 25 | 25 | 25 | 25
1600 | 50 | 25 | 25 | 25 | 25
1700 | 50 | 25 | 25 | 25 | 25
1800 | 50 | 25 | 25 | 25 | 25
1900 | 50 | 25 | 25 | 25 | 25
2000 | 50 | 25 | 25 | 25 | 25
2100 | 50 | 25 | 25 | 25 | 25
2200 | 50 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24718
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP
 | MID | TEMU | SNCL | MORGAN | SDGE
 | MID(T)CPJK/TRACEY/WESLEY | ISO(T)MALIN/NP15 | ISO(T)CPJK/NP15 | SNCL | ISO(T)MALIN/SYMAR/SP15
 | MID(L)WESLEY | TEMU(L)NP15 | SNCL(L)NP15 | ISO(T)CPJK/NP15 | SDGE(L)SP15
 |  |  |  | SNCL(L)NP15
Spreadsheet: 864671d1711753822-question-on-date-range-based-cell-populating-food-safety-walk
Sheet: Bakery

 |  |  |  |  | Department: | Bakery
 |  |  |  |  | Walk Date:
 |  |  |  |  | Auditor:
 |  |  |  |  | Auditor Role:
Market Guard
Question 1: | What is the Market Guard Completion for the Previous Day?
Question 2: | What is the MTD Completion for the Store?
General |  |  |  |  |  |  | Results
1 | Are there any products with missing labels? If so, note quantity. |  |  |  |  |  | P
 | Notes:
2 | Are there any products with incomplete labels? If so, note quantity. |  |  |  |  |  | P
 | Notes:
3 | Are there any expired items? |  |  |  |  |  | P
 | Notes:
4 | Are items stored in the cooler/freezer according to the storage hierarchy? |  |  |  |  |  | P
 | Notes:
5 | Is there any evidence of food/drink usage in the department? |  |  |  |  |  | P
 | Notes:
Cleaning |  |  |  |  |  |  | Results
6 | Do the customer facing displays have aged food debris? |  |  |  |  |  | P
 | Notes:
7 | Are the display door tracks clean? |  |  |  |  |  | P
 | Notes:
8 | Are the hand washing sinks blocked? |  |  |  |  |  | P
 | Notes:
9 | Is there any evidence of the hand washing sinks being used for anything other than hand washing? |  |  |  |  |  | P
 | Notes:
10 | Are the appliance control panels and handles clean? |  |  |  |  |  | P
 | Notes:
11 | Are the cooler/freezer door handles clean? |  |  |  |  |  | P
 | Notes:
12 | Are the hood grates clean? |  |  |  |  |  | P
 | Notes:
13 | Are the walls clean of built up food splatter? |  |  |  |  |  | P
 | Notes:
14 | Are the floors around coolers/equipment clean? |  |  |  |  |  | P
 | Notes:
Supplies/Chemicals |  |  |  |  |  |  | Results
15 | Are there any unauthorized chemicals? |  |  |  |  |  | P
 | Notes:
16 | Are the chemicals mixed correctly?  IE, too dark or light? |  |  |  |  |  | P
 | Notes:
17 | Are the sanitizer strips expired? |  |  |  |  |  | P
 | Notes:
18 | Is the paper towel dispenser stocked and functional at each hand washing sink? |  |  |  |  |  | P
 | Notes:
19 | Are gloves stocked and easily accessible? |  |  |  |  |  | P
 | Notes:
Misc Notes
Spreadsheet: 697078d1601153269-compare-lists-on-two-tables-compare_lists
Sheet: Contracts completed

 | Proj No | Contract No. | Received  on | Tender Rates XL | Request for Tender Rates Sent on | Tender Rates Received on | Date of Upload
 | D/00515 | 12.2535.1927 | 2015-03-20 00:00:00 | Yes
 | D/00589 | 13.2544.0054 | 2015-02-25 00:00:00 | Yes
 | D/00481 | 14.2614.1630 | 2015-08-10 00:00:00 | Yes
 | D/00463 | 13.2614.2112 | 2015-08-18 00:00:00 | Yes
 | D/00420 | 13.2613.0706 | 2015-09-18 00:00:00 | Yes
 |  | 15.3652.2407 | 2017-02-22 00:00:00 | Yes
 |  | 15.2537.0910 | 2017-03-04 00:00:00 | Yes
 |  | 12.2912.2864 | 2016-02-10 00:00:00 | Yes
 |  | [PHONE].0242 | 2018-11-01 00:00:00 | Yes
 |  | 15.2615.2038 | 2018-02-27 00:00:00 | Yes |  |  | 2018-09-10 00:00:00
 |  | [PHONE].2032 | 2018-03-13 00:00:00 | Yes | 2018-03-14 00:00:00 | 2018-03-14 00:00:00
 |  | [PHONE].2059 | 2018-08-03 00:00:00 | Yes | 2018-08-06 00:00:00
 |  | [PHONE].0837 | 2018-10-31 00:00:00 | Yes
 |  | [PHONE].1304 | 2018-12-03 00:00:00 | Yes
 |  | 15.2614.0964 | 2015-12-17 00:00:00 | Yes
 |  | [PHONE].0828 | 2018-11-30 00:00:00
 |  | [PHONE].0088 | 2017-10-04 00:00:00 | No | 2018-01-28 00:00:00
 |  | [PHONE].0348 | 2018-05-28 00:00:00 | Yes | 2018-07-03 00:00:00 | 2018-07-03 00:00:00
 |  | [PHONE].1322 | 2019-05-08 00:00:00 | Yes
 |  | 14.2615.2016 |  | Yes
 |  | [PHONE].0116 | 2018-06-25 00:00:00 | Yes |  |  | 2019-10-05 00:00:00
 |  | [PHONE].1267 | 2019-03-19 00:00:00 | yes
 | D/00501 / D/00500 | 13.2601.2696 | 2014-12-05 00:00:00 | Yes |  |  | 2014-10-24 00:00:00
 | (075011)- | 12.2912.2699 （109.2535.1038) | 2015-03-12 00:00:00 | Yes
 |  | [PHONE].1047 | 2018-01-16 00:00:00 | Yes
 |  | 16.3651.0018 | 2016-10-31 00:00:00 | No | 2018-04-19 00:00:00
 |  | [PHONE].1165 | 2018-03-26 00:00:00 | Yes | 2018-07-03 00:00:00 | 2018-07-03 00:00:00
 |  | [PHONE].0422 | 2018-05-15 00:00:00 | Yes | 2018-07-03 00:00:00 | 2018-07-19 00:00:00 | 2018-10-06 00:00:00
 |  | [PHONE].1661 | 2018-08-24 00:00:00 | Yes | 2018-09-10 00:00:00 | 2018-09-10 00:00:00
 |  | [PHONE].0138 | 2018-10-24 00:00:00 | Yes
 |  | 15.2615.0898 | 2016-02-11 00:00:00 | Yes
 |  | 15.2615.1726 | 2016-11-16 00:00:00 | Yes
 |  | [PHONE].1900 | NA | no
 |  | [PHONE].1586 | 2020-02-12 00:00:00 | no
 |  | 18.[PHONE] | 2018-05-03 00:00:00 | No | 2018-07-03 00:00:00
 |  | 14.2613.0674 | 2016-03-18 00:00:00 | No | 2018-03-10 00:00:00
 |  | [PHONE].1018 | 2018-04-04 00:00:00 | Yes
 |  | [PHONE].1019 | 2018-04-04 00:00:00 | Yes
 |  | [PHONE].1048 | 2018-01-16 00:00:00 | Yes
 |  | [PHONE].0319 | 2018-08-14 00:00:00 | No
 |  | 16.3652.0348 | 43116 | No
 |  | [PHONE].0840 | 2018-11-29 00:00:00 | no
 |  | [PHONE].2159 | 2019-05-08 00:00:00 | no
 |  | 14.2613.0982 |  | Yes
 |  | 16.2544.0625 | 2017-03-01 00:00:00 | No | 2017-02-22 00:00:00
 |  | [PHONE].0815 | 43865 | no
 |  | 109.2535.1038 (12.2912.2699) | 2015-07-21 00:00:00 | Yes
 |  | [PHONE].0282 | 2017-03-28 00:00:00 | No
 |  | [PHONE].0689 | 2017-02-22 00:00:00 | No | 2017-02-22 00:00:00
 |  | [PHONE].1080 | 2017-07-21 00:00:00 | No
 |  | [PHONE].1082 | 2017-08-23 00:00:00 | No
 |  | [PHONE].1084 | 2017-11-01 00:00:00 | No
 |  | [PHONE].1135 | 2018-11-29 00:00:00
Spreadsheet: 76380d1276880788-picking-numbers-from-a-list-732525-shims
Sheet: via Solver

 | Shims Available |  | [NAME] Needed
 |  |  | 115 |  | 220 |  | 180 |  | 160 |  | 440 |  | 600 |  | 1000
 | [NAME] | # Of | Qty | # Left | Qty | # Left | Qty | # Left | Qty | # Left | Qty | # Left | Qty | # Left | Qty | # Left
 | 76.2 | 12 | 1 | 11 | 2 | 9 | 2 | 7 | 1 | 6 | 5 | 1 | 1 | 0 | 0 | 0
 | 75.95 | 8 | 0 | 8 | 0 | 8 | 0 | 8 | 0 | 8 | 0 | 8 | 6 | 2 | 2 | 0
 | 50.8 | 14 | 0 | 14 | 0 | 14 | 0 | 14 | 0 | 14 | 0 | 14 | 0 | 14 | 14 | 0
 | 50.55 | 6 | 0 | 6 | 0 | 6 | 0 | 6 | 0 | 6 | 0 | 6 | 0 | 6 | 2 | 4
 | 25.15 | 21 | 1 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20
 | 18.8 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0 | 19
 | 18 | 6 | 0 | 6 | 0 | 6 | 0 | 6 | 0 | 6 | 0 | 6 | 0 | 6 | 0 | 6
 | 17 | 8 | 0 | 8 | 0 | 8 | 0 | 8 | 0 | 8 | 0 | 8 | 1 | 7 | 0 | 7
 | 16 | 5 | 0 | 5 | 1 | 4 | 0 | 4 | 0 | 4 | 0 | 4 | 0 | 4 | 0 | 4
 | 15 | 3 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 3
 | 14 | 9 | 0 | 9 | 0 | 9 | 0 | 9 | 0 | 9 | 0 | 9 | 0 | 9 | 0 | 9
 | 13 | 3 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 3
 | 12.44 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0 | 19
 | 11 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1
 | 6.09 | 21 | 0 | 21 | 0 | 21 | 0 | 21 | 0 | 21 | 1 | 20 | 0 | 20 | 0 | 20
 | 5 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5
 | 4 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5
 | 3 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 5
 | 2.91 | 25 | 0 | 25 | 0 | 25 | 0 | 25 | 0 | 25 | 0 | 25 | 0 | 25 | 0 | 25
 | 2.79 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 7 | 3
 | 2.76 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 8 | 2 | 2 | 0
 | 2.74 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 7 | 3 | 0 | 3
 | 2.71 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 8 | 2 | 0 | 2 | 2 | 0
 | 2.69 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 8 | 2 | 1 | 1 | 1 | 0
 | 2.66 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2.64 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 9 | 1 | 0 | 1 | 0 | 1 | 0.9999999988372937 | 0
 | 2.62 | 9 | 0 | 9 | 0 | 9 | 8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2.58 | 9 | 0 | 9 | 0 | 9 | 1 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2.56 | 6 | 0 | 6 | 0 | 6 | 0 | 6 | 1 | 5 | 3 | 2 | 2 | 0 | 0 | 0
 | 2.03 | 26 | 1 | 25 | 20 | 5 | 1.99999999943662 | 3 | 0 | 3 | 0.9999999980130284 | 2 | 1.000000011805566 | 1 | 0 | 1
 | 2 | 5 | 0 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1.27 | 12 | 6 | 6 | 0 | 6 | 0 | 6 | 5.999999999219422 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1 | 5 | 3.999999999706706 | 1 | 0.9999999984095496 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Actual | 114.9999999997067 |  | 219.9999999984095 |  | 179.9999999988564 |  | 159.9999999990087 |  | 439.9999999959664 |  | 600.0000000239654 |  | 999.9999999969303
 |  | Residual | 2.932978304670542e-10 |  | 1.590450438015978e-09 |  | 1.143632744060596e-09 |  | 9.913492249324918e-10 |  | 4.033609002362937e-09 |  | -2.39654127653921e-08 |  | 3.069658305321354e-09
Spreadsheet: 454935d1460036357-lookup-add-another-one-searching-workbook
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00 |  | - |  | 2016-03-31 00:00:00
 |  |  |  | ID
 |  |  |  | 2222 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  | 3333 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4000
 |  |  |  | 4444 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500
 |  |  |  | 5555 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1980
 |  |  |  | 6666 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  | 7777 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5500
 |  |  |  | 8888 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3500
 |  |  |  | 9999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9100
Spreadsheet: 70378d1271159741-need-help-in-getting-the-count-using-lookup-book1
Sheet: Activity by Day and Time

 | Exisiting / New client | (All)
 | Count of Id |  | Week
 | Day | AM / PM | 10 | 11 | 12 | 13 | 14 | Grand Total
 | Mon | AM | 2 | 2 | 2 | 2 |  | 8
 |  | PM | 2 | 3 | 3 | 2 | 3 | 13
 | Mon Total |  | 4 | 5 | 5 | 4 | 3 | 21
 | Tue | AM | 2 | 2 | 1 | 1 | 2 | 8
 |  | PM | 2 | 2 | 4 | 3 | 1 | 12
 | Tue Total |  | 4 | 4 | 5 | 4 | 3 | 20
 | Wed | AM | 1 | 2 | 2 | 1 | 2 | 8
 |  | PM | 3 | 2 | 2 | 3 | 2 | 12
 | Wed Total |  | 4 | 4 | 4 | 4 | 4 | 20
 | Thu | AM | 3 | 3 | 3 | 1 |  | 10
 |  | PM | 3 | 2 | 1 | 2 |  | 8
 | Thu Total |  | 6 | 5 | 4 | 3 |  | 18
 | Fri | AM | 2 | 3 | 2 | 1 |  | 8
 |  | PM | 2 | 2 | 1 | 2 |  | 7
 | Fri Total |  | 4 | 5 | 3 | 3 |  | 15
 | Sat | AM | 1 | 1 |  | 1 |  | 3
 |  | PM | 1 | 2 |  |  |  | 3
 | Sat Total |  | 2 | 3 |  | 1 |  | 6
 | Grand Total |  | 24 | 26 | 21 | 19 | 10 | 100
 | Volume and % Contribution of activity by Day/time by week
 |  |  | Week
 |  |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | Total
 | Day | AM / PM | vol. | (%) | vol. | (%) | vol. | (%) | vol. | (%) | vol. | (%) | vol. | (%)
 | Mon | AM
 |  | PM
 | Mon Total
 | Tue | AM
 |  | PM
 | Tue Total
 | Wed | AM
 |  | PM
 | Wed Total
 | Thu | AM
 |  | PM
 | Thu Total
 | Fri | AM
 |  | PM
 | Fri Total
 | Sat | AM
 |  | PM
 | Sat Total
 | Total
Spreadsheet: andy_zipper__114__Broker detail 5-24-01
Sheet: BROKER DEAL SUMMARY

EnronOnline Broker Detail for 5/24/2001
Completed Transactions:
TODAY
Date | 2001-05-24 00:00:00
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 4 | 14 | 570 | 1053 | 18 | 1623
Natsource LLC |  | 13 |  | 869 | 13 | 869
Amerex Natural Gas I, Ltd. | 5 |  | 466.25 |  | 5 | 466.25
Amerex Power, Ltd. |  | 4 |  | 740 | 4 | 740
Grand Total | 9 | 31 | 1036.25 | 2662 | 40 | 3698.25
LIFE TO DATE (First Trade March 28, 2001)
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 64 | 162 | 17207.5 | 10041.04 | 226 | 27248.54
Natsource LLC | 28 | 213 | 4207.5 | 18857 | 241 | 23064.5
Power Merchants Group, LLC | 8 |  | 634.83 |  | 8 | 634.83
Amerex Natural Gas I, Ltd. | 37 | 1 | 5766.25 | 4 | 38 | 5770.25
Amerex Power, Ltd. |  | 9 |  | 1488 | 9 | 1488
Grand Total | 137 | 385 | 27816.08 | 30390.04 | 522 | 58206.12
Failed Transactions:
TODAY
Date | 2001-05-24 00:00:00
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. |  | 2 | 2
Natsource LLC |  | 1 | 1
Amerex Natural Gas I, Ltd. | 1 |  | 1
Amerex Power, Ltd. |  | 6 | 6
Grand Total | 1 | 9 | 10
LIFE TO DATE (First Trade March 28, 2001)
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. | 20 | 24 | 44
Natsource LLC | 4 | 38 | 42
Power Merchants Group, LLC | 20 |  | 20
Amerex Natural Gas I, Ltd. | 5 |  | 5
Amerex Power, Ltd. |  | 8 | 8
Grand Total | 49 | 70 | 119