tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 702309d1604268666-formula-that-refernces-resource-to-give-a-monthly-total-resource1-v2
Sheet: Sheet2

 | Resource Name | Start Date | End Date | Planned Hours Per Day | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00
 | [NAME] | 2019-05-31 00:00:00 | 2021-06-30 00:00:00 | 0.06
 | [NAME] | 2019-05-31 00:00:00 | 2020-12-12 00:00:00 | 8
 | [NAME] | 2019-05-31 00:00:00 | 2021-06-30 00:00:00 | 0.22
 | [NAME] | 2020-11-01 00:00:00 | 2021-12-12 00:00:00 | 0.22
 | [NAME] | 2020-11-01 00:00:00 | 2021-12-12 00:00:00 | 4.5
 | [NAME] | 2020-11-01 00:00:00 | 2021-12-12 00:00:00 | 5.15
Spreadsheet: 95980d1295470736-multiple-line-invoices-customers-orders-accounts-copy
Sheet: Customers

 |  |  |  |  |  | Delivery address |  |  |  |  | Invoice address (if different)
Cust ID | Company | Contact | Phone1 | Phone2 | [NAME] | Add1 | Add2 | Add3 | Add4 | Add5 | Add1 | Add2 | Add3 | Add4 | Add5 | Terms
11001 | test | me | 0123 | 01234 | a@b.c | add 1 | add 2 | add 3 | add 4 | add 5 |  |  |  |  |  | cod
11002
11003
11004
11005
11006
11007
11008
11009
11010
11011
11012
11013
11014
11015
11016
11017
11018
11019
11020
11021
11022
11023
11024
11025
11026
Spreadsheet: 287650d1388923432-new-here-and-need-help-with-auto-populating-cells-call-log_kamal
Sheet: Call Log 2014

Date: | Number: | Street: | Town: | Area: | Type: | Transport: | Crew 1: | Crew 2: | Crew 3: | Crew 4: | Crew 5: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
 |  | Street
 |  | Street
 |  | Street
Spreadsheet: 693150d1598805374-how-do-i-add-data-to-a-sheet-without-messing-up-the-formatting-for-the-whole-workbook-problems
Sheet: August

 |  | A | A | B | B | A | A | B | B | Hrs | Beg | End
Last | First | 1 | 2 | 15 | 16 | 22 | 23 | 29 | 30 | Com. | Hrs | Hrs
Adams | [NAME] | 10 | 8 |  |  |  |  | 8 | 12 |  | 100
[NAME] | Daryl |  | 8 |  |  |  | 8 | 8 |  |  | 40
[NAME] | [NAME] |  | 8 |  | 8 | 8 |  |  |  |  | 30
Credence | [NAME] |  |  | 8 | 8 |  |  |  |  |  | 20
[NAME] | Daryl | 10 | 8 | 8 |  |  | 8 |  |  |  | 50
Edwards | [NAME] | 10 | 8 | 8 |  | 8 | 8 |  | 12 |  | 80
[NAME] | Anne |  | 8 |  | 8 |  | 8 |  |  |  | 24
Gonzales | George |  | 8 |  | 8 |  |  | 8 |  |  | 50
Hernandez | [NAME] |  |  | 8 | 8 |  |  | 8 | 12 |  | 36
Smith | [NAME] | 10 | 8 |  |  | 8 |  |  | 12 |  | 100
 | Total Workers
Spreadsheet: mary_fischer__25615__32L
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032L
COMPANY NAME   Jovinole Associates
ANALYSIS OF A/R - OTHER
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:  Sonya City
EXTENSION:  3 9690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 731026d1620130724-highlight-date-range-on-calendar-ef1523a_test-2-copy
Sheet: Calendar

 | 2020 | MAY |  | MONDAY |  | 3099 Issue [NAME]
 | CALENDAR YEAR | CALENDAR MONTH |  | FIRST DAY OF WEEK
 |  | 43942 | 43943 | 43944 | 43945 | 43946 | 43947
 |  | 2020-04-28 00:00:00 | 2020-04-29 00:00:00 | 2020-04-30 00:00:00 | 2020-05-01 00:00:00 | 2020-05-02 00:00:00 | 2020-05-03 00:00:00
 |  | 2020-05-05 00:00:00 | 2020-05-06 00:00:00 | 2020-05-07 00:00:00 | 2020-05-08 00:00:00 | 2020-05-09 00:00:00 | 2020-05-10 00:00:00
 |  | 2020-05-12 00:00:00 | 2020-05-13 00:00:00 | 2020-05-14 00:00:00 | 2020-05-15 00:00:00 | 2020-05-16 00:00:00 | 2020-05-17 00:00:00
 |  | 2020-05-19 00:00:00 | 2020-05-20 00:00:00 | 2020-05-21 00:00:00 | 2020-05-22 00:00:00 | 2020-05-23 00:00:00 | 2020-05-24 00:00:00
 |  | 2020-05-26 00:00:00 | 2020-05-27 00:00:00 | 2020-05-28 00:00:00 | 2020-05-29 00:00:00 | 2020-05-30 00:00:00 | 2020-05-31 00:00:00
 |  | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00
Spreadsheet: 789577d1659191719-if-value-is-y-return-values-in-range-and-copy-to-another-sheet-example2
Sheet: EQA

First Name | Surname | Value 1 | Information 1 | Information 2 | Information 3 | Information 4 | Information 5 | Information 6 | Information 7
[NAME] | Franks |  | 2022-02-10 00:00:00
Mark | Smith |  | 2021-07-16 00:00:00
Toby | Jones |  | 2021-04-23 00:00:00
[NAME] | Sands |  | 2021-08-26 00:00:00
Emma | Hill |  | 2020-08-15 00:00:00
[NAME] | Franks
[NAME] | Jones | = new record
Mark | Smith
Toby | Jones
[NAME] | Sands
Emma | Hill
Spreadsheet: 107913d1305055120-move-data-based-upon-number-carshow
Sheet: Owners 

Owner Number | FirstName | LastName | City | Make | Model | Year | Class | AutoNumber
1-1 | [NAME] | Smith | Howell | Honda | CRV | 2003 | 1 | 1
2-2 | [NAME] | [NAME] | Freehold | Ford | Model T | 1900 | 2 | 2
3-3 | Mr | XYZ | Wall | Toyota |  | 2005 | 3 | 3
4-4 | Mrs | xyz | Ocean |  |  | 2006 | 4 | 4
5-5 | a | b |  |  |  | 2007 | 5 | 5
6-6 | c | d |  |  |  | 2008 | 6 | 6
7-7 | e | f |  |  |  | 0 | 7 | 7
8-8 | g | h |  |  |  | 0 | 8 | 8
9-9 | I | j |  |  |  | 0 | 9 | 9
10-10 | k | l |  |  |  | 0 | 10 | 10
11-11 | m | n |  |  |  | 0 | 11 | 11
12-12 | o | p |  |  |  | 0 | 12 | 12
13-13 | q | r |  |  |  | 0 | 13 | 13
14-14 | s | t |  |  |  | 0 | 14 | 14
15-15 | u | v |  |  |  | 0 | 15 | 15
16-16 | w | x |  |  |  | 0 | 16 | 16
16-17 | mr | sssf | [NAME] |  |  | 0 | 16 | 17
Spreadsheet: 141452d1329270597-polynomial-regression-equation-in-a-formula-example5
Sheet: Sheet1

 |  |  | 1991 | 2000 | 2010 | 2020
 |  |  | 13015 | 22107 | 50279 | 98524.92800448426
 |  |  | 3547 | 9640 | 19211 | 49267.75375558453
 |  |  | 12506 | 24946 | 34427 | 62215.93140264869
 |  |  | 46461 | 42653 | 42104 | 39531.92876370468
 |  |  | 5064 | 5609 | 5262 | 5504.983783161462
 |  |  | 5292 | 7311 | 7172 | 8868.127368388088
 |  |  | 7653 | 9051 | 10683 | 12752.77409947545
 |  |  | 13015 | 22107 | 50279
Spreadsheet: 379709d1424970780-need-a-formula-to-calculate-current-transformer-ratios-copy-of-tapfinder
Sheet: Sheet1

X1-X6
X1-X5 | 2000
[NAME] | 1500
X1-X3 | 1200
X1-X2 | 400
SECONDARY => | 5
Spreadsheet: 76443d1276976334-cell-referencing-end-of-day-cell-reset-excel-forum-sheet
Sheet: Delivery

Customer | Hidden Column | Date ordered | Yards ordered | Product ordered | Yards shipped | Date shipped | Order complete | Product code - DO NOT MODIFY THIS COLUMN | Product code - DO NOT MODIFY THIS COLUMN | Committed quantities
Customer A | 0 |  |  |  |  |  |  | 205 | 205-MAM | 0
Customer B | 0 |  |  |  |  |  |  | 206 | 206-BAM | 0 | Yes | 1
Customer C | 0 |  |  |  |  |  |  | 207 | 207-RAM | 0 |  | 2
Customer D | 0 |  |  |  |  |  |  | 617 | 617-AS420 | 0 |  | 3
Customer E | 0 |  |  |  |  |  |  | 720 | 720-AP | 0 |  | 4
Customer F | 0 |  |  |  |  |  |  | 723 | 723-GM | 0 |  | 5
Customer G | 0 |  |  |  |  |  |  | 728 | 728-LP | 0 |  | 6
Customer H | 0 |  |  |  |  |  |  | 731 | 731-LS | 0 |  | 7
Customer I | 0 |  |  |  |  |  |  | 737 | 737-NL | 0 |  | 8
Customer J | 0 |  |  |  |  |  |  | 740 | 740-NP | 0 |  | 9
Customer K | 0 |  |  |  |  |  |  | 743 | 743-ON | 0 |  | 10
Customer L | 0 |  |  |  |  |  |  | 746 | 746-OS | 0 |  | 11
Customer M | 0 |  |  |  |  |  |  | 749 | 749-RM | 0 |  | 12
 | 0 |  |  |  |  |  |  | 752 | 752-SL | 0 |  | 13
 | 0 |  |  |  |  |  |  | 755 | 755-VN | 0 |  | 14
 | 0 |  |  |  |  |  |  | 765 | 765-AM | 0 |  | 15
 | 0 |  |  |  |  |  |  | 771 | 771-EM | 0 |  | 16
 | 0 |  |  |  |  |  |  | 774 | 774-FB1 | 0 |  | 17
 | 0 |  |  |  |  |  |  | 783 | 783-FR | 0 |  | 18
 | 0 |  |  |  |  |  |  | 786 | 786-RR | 0 |  | 19
 | 0 |  |  |  |  |  |  | 790 | 790-RAW | 0 |  | 20
 | 0 |  |  |  |  |  |  | 850 | 850-AC | 0 |  | 21
 | 0 |  |  |  |  |  |  | 853 | 853-COW | 0 |  | 22
 | 0 |  |  |  |  |  |  | 859 | 859-HOR | 0 |  | 23
 | 0 |  |  |  |  |  |  | 862 | 862-MM | 0 |  | 24
 | 0 |  |  |  |  |  |  | 865 | 865-NS | 0 |  | 25
 | 0 |  |  |  |  |  |  | 868 | 868-OVC | 0 |  | 26
 | 0 |  |  |  |  |  |  | 877 | 877-TAN | 0 |  | 27
 | 0 |  |  |  |  |  |  | 880 | 880-REA | 0 |  | 28
 | 0 |  |  |  |  |  |  | 883 | 883-TM | 0 |  | 29
 | 0 |  |  |  |  |  |  | 888 | 888-RL1 | 0 |  | 30
 | 0 |  |  |  |  |  |  | 891 | 891-RL2 | 0 |  | 31
 | 0 |  |  |  |  |  |  | 894 | 894-RLC | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 03b87d00-284d-4c7d-93ca-23ddd8d14add
Sheet: Sheet1

Men's Singles | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
NO | COUNTRY | NAT RANK | FAMILY NAME | GIVEN NAME | BWF No. | WR
1 | CAM | 1 | SIM | PISEY
 | CAM | 2 | SIENG | KIMHONG
 | CAM | 3 | CHEA | SENVISOTH
 | CAM | 4 | PHENG | MENGLENG
2 | HKG | 1 | [NAME] | CHEUK YIU
 | HKG | 2 | CHUNG | YONNY
3 | IND | 1 | [NAME] | ADITYA
 | IND | 2 | K P | CHIATYNA
4 | INA | 1 | CHRISTIE | [NAME]
 | INA | 2 | PANGESTU | M BAYU
 | INA | 3 | SUSANTO | ANDRES
5 | IRI | 1 | SHAHBAZI | MEHRAN
6 | JPN | 1 | KOGA | MINORU
 | JPN | 2 | NISHI | YUTAKA
 | JPN | 3 | SHIMONO | HASHIRU
 | JPN | 4 | [NAME] | KENYA
 | JPN | 5 | OGURA | YOSHITAKA
 | JPN | 6 | WATANABE | [NAME]
 | JPN | 7 | KOSHIMA | RIKI
 | JPN | 8 | MORI | KOHEI
7 | JOR | 1 | ABU JALLOD | PAHA ALDEEN
 | JOR | 2 | ALSHANNIK | BAHAEDEEN
8 | KOR | 1 | [NAME] | [NAME] SEOK
 | KOR | 2 | SEO | SEUNG JAE
9 | MAC | 1 | LOU | HOK MAN
 | MAC | 2 | HO | SENG IO
10 | MAS | 1 | JONG | ZIE SHENG, [NAME]
 | MAS | 2 | ZAINUDIN | ZAIRUL NIZAM
11 | PAK | 1 | ISLAM | MUHAMMAD WADOOD
 | PAK | 2 | [NAME] | SHUJAAT ALI
12 | PHI | 1 | MONTERUBIO | [NAME]
 | PHI | 2 | PINEDA | ROBERTO
 | PHI | 3 | REMO | CARLO GLENN
 | PHI | 4 | ALCALA | MARK SHELLEY
13 | SIN | 1 | TENG | PANG LIANG LESLIE
 | SIN | 2 | TAN | MING SHUN
14 | SRI | 1 | KARUNARATNE | EDIRIMUNI CHAMIKA DINUSHAN
 | SRI | 2 | DUMBUKOLA GOONATHILAKE | BUWANEKA THARINDU DULLEWA
 | SRI | 3 | ANGODAVIDANALAGE | SACHIN PREMASHAN DIAS
 | SRI | 4 | RANAWEERA | PRAMODDYA [NAME]
15 | SYR | 1 | MAHMOUD | ARAM
 | SYR | 2 | ALJALLAD | AHMAD
 | SYR | 3 | BAHE | HOSAM
 | SYR | 4 | ALHAMAD [NAME] | MOSTAFA
Spreadsheet: harry_arora__12150__DealRooms Target Markets
Sheet: Insurance

Aegis Insurance
Aetna
AIG Energy
Allstate Financial
Alternative Risk Solutions
American Express Bank
Amex Financial Advisors
American International
ARS
Atlantic Mutual
Bladex
Blaylock & Partners
Chubb & Son
Energy Insurance Mutual
Executive Liability
Fidelity & Deposit of Maryland
J & H Marsh & McLennan
[NAME]
[NAME]
Kemper Insurance
Liberty Bond Services
[NAME]
Met Life
MONY Life
Munich-American Risk Partners
Prudential
Putnam
Strategic Risk Solutions
Teachers
Travelor's
Winterthour
Spreadsheet: 676733d1588949836-pivot-table-pivot
Sheet: Sheet1

 |  |  |  |  |  | I want a formua to to find all the 38 FROM the pivot table and return the whole cell text (at the moment it manual filter and paste) | I want a formua to to find THE TOTAL OF EACH CATORGY (at the moment it manual filter and paste)
DATE |  |  | pivot table
NAME | AMOUNT |  | Row Labels | Sum of AMOUNT |  | CATORGERY | AMOUNT
38 TV | 10 |  | 04 BORADBAND | 7
38 WATER | 20 |  | 04 TV | 10
38 BORADBAND | 30 |  | 04 WATER | 9
38 TV | 50 |  | 38 BORADBAND | 30
38 WATER | 10 |  | 38 TV | 60
04 TV | 5 |  | 38 WATER | 30
04 WATER | 6 |  | Grand Total | 146
04 BORADBAND | 7
04 TV | 5
04 WATER | 3
Spreadsheet: 851431d1701681385-conditional-formatting-multiple-criteria-example-ef
Sheet: Sheet1

Location |  |  |  | Location
1 |  |  |  | 2
Role | Travel | Name |  | Role | Travel | Name
Role1 | Y | [NAME] |  | Role1 | Y | [NAME]
Role1 | N | [NAME] |  | Role2 | N | Val Kilmer
Role3 | Y | [NAME] |  | Role1 | Y | [NAME]
Role4 | N | [NAME] |  | Role3 | N | [NAME]
Spreadsheet: 165100d1341012563-visual-display-of-information-with-3-variables-vagarwal_841904-visual-display-of-information-with-3-variables_29jun12_01
Sheet: Sheet1

Date | $ent | Ra%e
2010-09-23 00:00:00 | 10000 | 42
2010-12-10 00:00:00 | 5000 | 43
2011-05-11 00:00:00 | 8000 | 45
2011-08-11 00:00:00 | 6000 | 44
2011-11-12 00:00:00 | 8000 | 55
2012-02-12 00:00:00 | 7000 | 50
2012-05-12 00:00:00 | 4000 | 48
Spreadsheet: 49678d1249016193-can-we-unmerge-words-with-the-help-of-any-formula-unmerge-data
Sheet: Sheet1

Complete address | Address[1] | Address[2] | Address[3] | Address[4] | [NAME]]
1st Floor, 2a Harrison Road, Erdington, West Midlands, B24 9AA | 1st Floor | 2a Harrison Road | [NAME] | West Midlands | B24 9AA
[NAME], 11-13 Ockford Road, Godalming, [NAME], GU7 1QU | [NAME] | 11-13 Ockford Road | Godalming | [NAME] | GU7 1QU
Wetherspoon House, Central Park, Reeds Cresent, Watford, [NAME] 1QH
c/o [NAME], Property Dept, PO Box 170, Leeds,  LS2 8JF
Spreadsheet: 470447d1468493026-designing-a-file-to-split-out-and-consolidate-each-month-master-template
Sheet: Jul-16

2016-07-01 00:00:00
Employee | Manager | Number | Another Number | Grand total | Comment
[NAME] | Manager A
[NAME] | Manager A
[NAME] | Manager B
[NAME] | Manager B
[NAME] | Manager B
Louis | Manager C
[NAME] | Manager C
[NAME] | Manager D
[NAME] | Manager E
[NAME] | Manager E
Spreadsheet: richard_shapiro__32241__washingtonheadcount
Sheet: STAFF LISTING

Included in this Corp budget |  |  |  | Not included in Corp budgets
Employee Last Name | First Name | Title |  | Employee Last Name | First Name | Title | Where are they budgeted?
Hillings | [NAME] | Vice President
[NAME] | Lors | Federal Government Affairs Representative
Long | [NAME] | Senior Director
Burns | [NAME] | Director
Sandherr | [NAME] | Vice President
Navin | [NAME] | Legislative Coordinator
Cooney | [NAME] | Office Manager
Fabian | [NAME] | Administrative Assistant
Palmer | Germain | [NAME] (part time)
[NAME] | [NAME] | Vice President
Hiler | Bessie | [NAME] (part time)
Open Positions
Vice President/General Manager (executive search)
Senior Administrative Assistant
Administrative Assistant
Spreadsheet: 52881d1252690010-first-in-first-out-fifo-accounting-for-equity-trades-book-cost-fifo-test
Sheet: Sheet9

Investment | PositionClass | Date | TradeQuantity | BaseUnitCost |  |  | Long Taxlot = Purchase
APC | LONG TAXLOTS | 2009-06-01 00:00:00 | 9030 | 54.127
APC | LONG TAXLOTS | 2009-06-02 00:00:00 | 4515 | 54.992
APC | LONG TAXLOTS | 2009-06-03 00:00:00 | 4515 | 55.01
APC | LONG TAXLOTS | 2009-06-04 00:00:00 | 4515 | 55.522
APC | LONG TAXLOTS | 2009-06-05 00:00:00 | 4515 | 57.348
APA | LONG TAXLOTS | 2009-06-06 00:00:00 | 13545 | 87.51
APA | LONG TAXLOTS | 2009-06-07 00:00:00 | 9030 | 87.956
APA | LONG TAXLOTS | 2009-06-08 00:00:00 | 27090 | 88.223
APA | LONG TAXLOTS | 2009-06-09 00:00:00 | 4515 | 88.232
CBE | LONG TAXLOTS | 2009-06-10 00:00:00 | 27090 | 34.309
CCK | LONG TAXLOTS | 2009-06-11 00:00:00 | 9030 | 24.496
CCK | LONG TAXLOTS | 2009-06-12 00:00:00 | 4515 | 25.653
CCK | LONG TAXLOTS | 2009-06-13 00:00:00 | 1806 | 25.659
CCK | LONG TAXLOTS | 2009-06-14 00:00:00 | 903 | 25.653
CCK | LONG TAXLOTS | 2009-06-15 00:00:00 | 1806 | 25.592
CCK | LONG TAXLOTS | 2009-06-16 00:00:00 | 13545 | 25.83
CCK | LONG TAXLOTS | 2009-06-17 00:00:00 | 22575 | 25.498
CCK | LONG TAXLOTS | 2009-06-18 00:00:00 | 9030 | 25.196
CCK | LONG TAXLOTS | 2009-06-19 00:00:00 | 13545 | 25.027
DHR | LONG TAXLOTS | 2009-06-20 00:00:00 | 4515 | 60.473
DHR | LONG TAXLOTS | 2009-06-21 00:00:00 | 4515 | 60.106
DHR | LONG TAXLOTS | 2009-06-22 00:00:00 | 22575 | 62.065
DHR | LONG TAXLOTS | 2009-06-23 00:00:00 | 4515 | 62.707
DHR | LONG TAXLOTS | 2009-06-24 00:00:00 | 18060 | 61.795
 |  |  |  |  |  | P&L
APC | Sell | 2009-07-01 00:00:00 | 5000 | 57 |  | 14364.99999999999 | Used 5000 from the first tax lot
APC | Sell | 2009-07-02 00:00:00 | 5000 | 57.5 |  | 13768.74999999999 | Used 4030 from the first tax lot and 70 from the second
APA | Sell | 2009-07-03 00:00:00 | 5000 | 89.5 |  | 9949.999999999975 | From the first tax lot
APA | Sell | 2009-07-04 00:00:00 | 2000 | 89 |  | 2979.99999999999 | From the first tax lot
CBE | Sell | 2009-07-05 00:00:00 | 5000 | 33 |  | -6544.999999999987
CBE | Sell | 2009-07-06 00:00:00 | 2000 | 33.5 |  | -1617.999999999995
CBE | Sell | 2009-07-07 00:00:00 | 1000 | 34 |  | -308.9999999999975
CCK | Sell | 2009-07-08 00:00:00 | 5000 | 25.5 |  | 5020.000000000006
CCK | Sell | 2009-07-09 00:00:00 | 5000 | 25 |  | 1985.410000000006
CCK | Sell | 2009-07-10 00:00:00 | 1000 | 26 |  | 347.0000000000013
DHR | Sell | 2009-07-11 00:00:00 | 5000 | 63 |  | 12812.995
APC | Buy | 2009-07-12 00:00:00 | 1000 | 56 |  | #N/A | Last_Trade is a BNP (Bloomberg) function to get that last trade price.
APA | Buy | 2009-07-13 00:00:00 | 2000 | 87 |  | #N/A | Last_Trade is a BNP (Bloomberg) function to get that last trade price.
Spreadsheet: 158842d1338405439-conditional-compiling-to-a-new-workbook-receivables-wip
Sheet: Template

Accounts Receivable/[NAME]'s Payable |  |  |  |  |  |  |  | hide me |  |  | hide me |  |  | hide me | hide me | hide me
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Client's Check |  |  |  | Ray's Check
Inv # | Inv Dt | Age | Company | PO # | Inv Total | Cost | Selling | Pre-Profit | Profit | SP | Unrounded Comm. | [NAME] Com | (%) | [NAME]'s to pay | Money owed us | [NAME]'s totals | Cred | [NAME] | Ck # | Time | Date | Ck # | Notes
Page Totals: |  |  |  | Inv. Total |  | Profit |  |  | [NAME]'s Total |  |  |  |  |  |  |  | Money Owed Us |  |  |  | Pay Roy Next Run
Spreadsheet: 188258d1350772241-changing-numerical-values-of-cells-based-on-time-excelforumexample
Sheet: Sheet1

 | AREA A
NAME A-Z | SHIFT DETAILS |  |  |  |  | 2008-09-30 06:00:00 | 2008-09-30 07:00:00 | 2008-09-30 08:00:00 | 2008-09-30 09:00:00 | 2008-09-30 10:00:00 | 2008-09-30 11:00:00 | 2008-09-30 12:00:00 | 2008-09-30 13:00:00 | 2008-09-30 14:00:00 | 2008-09-30 15:00:00 | 2008-09-30 16:00:00 | 2008-09-30 17:00:00 | 2008-09-30 18:00:00 | 2008-09-30 19:00:00 | 2008-09-30 20:00:00 | 2008-09-30 21:00:00 | 2008-09-30 22:00:00 | 2008-09-30 23:00:00
 |  | Start | Finish | Duration | Break | 2008-09-30 07:00:00 | 2008-09-30 08:00:00 | 2008-09-30 09:00:00 | 2008-09-30 10:00:00 | 2008-09-30 11:00:00 | 2008-09-30 12:00:00 | 2008-09-30 13:00:00 | 2008-09-30 14:00:00 | 2008-09-30 15:00:00 | 2008-09-30 16:00:00 | 2008-09-30 17:00:00 | 2008-09-30 18:00:00 | 2008-09-30 19:00:00 | 2008-09-30 20:00:00 | 2008-09-30 21:00:00 | 2008-09-30 22:00:00 | 2008-09-30 23:00:00 | 2008-09-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Example---> |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | AREA B
 | AREA C
TOTAL EACH HOUR OF STAFF
Spreadsheet: tracy_geaccone__40282__Gas Accounting Budget
Sheet: Sheet1

Gas Accounting Budget to Actual at 6/30/2001
 |  |  |  | NNG |  | TW |  | FGT
 | Cost Center | Total |  | R 111437 |  | R 111068 |  | R 112386
TW | 111068 | 35749.17 | 0.6 | 21448.75 | 0.15 | 5362.9 | 0.25 | 8937.52
NNG | 111437 | 161805.92 | 0.6 |  | 0.15 |  | 0.25 | 40450.97
FGT | 112387 | 60542.42 | 0.6 | 36325.72 | 0.15 | 9081.04 | 0.25 | 15135.95
Settles to R
Ties to SAP |  |  |  | 154858.07 |  | 38715.29 |  | 64720.92
Budget |  | 281912.5 |  | 169147.51 |  | 42287.62 |  | 70477.38
Under-Budget
 |  |  |  |  |  |  |  |  | Difference
Mary's Report |  | Totals |  | NNG
R112386 |  |  |  |  |  |  |  | 49584.97
112387 |  |  |  | 36325.72 |  | 9081.04 |  | 15135.95
 |  |  |  |  |  |  |  |  | Total from 112387 in FGT Per Mary's Report
111437 |  |  |  | 97083.6 |  | 24271.35 |  | 40450.97 | Total from 111068
111068 |  |  |  | 21448.75 |  | 5362.9 |  | 8937.52 | Total from 111437
 |  |  |  |  |  |  |  |  | Included in R112386
 |  |  |  |  |  |  |  |  | Difference
Gas Accounting |  |  |  |  |  |  |  |  | Totals on Mary's Report
Budget |  | 281912.5 |  | 169147.51 |  | 42287.62 |  | 70477.38
Over Budget per Mary's Report
Spreadsheet: 297114d1392290957-sum-duplicate-values-within-an-array-pivot-solution_13-feb-2014
Sheet: Sheet1

Source |  |  |  | Result
ID | Name | Sale |  | ID | Sale
1 | [NAME] | 189 |  | 9 | 1661 |  | Row Labels | Sum of Sale
1 | [NAME] | 782 |  | 1 | 971 |  | 9 | 1661
4 | [NAME] | 563 |  | 7 | 564 |  | 1 | 971
5 | [NAME] | 76 |  | 4 | 563 |  | 7 | 564
9 | [NAME] | 899 |  | 8 | 241 |  | 4 | 563
8 | [NAME] | 241 |  | 5 | 76 |  | 8 | 241
7 | Nick | 564 |  |  |  |  | 5 | 76
9 | [NAME] | 762 |  |  |  |  | Grand Total | 4076
Spreadsheet: daren_farmer__5602__HPLN1123
Sheet: Sheet1

HPLN1123.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LAURA BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
 |  |  |  |  |  |  |  |  | Revision #1
SUBJECT:  TXU FUELS NOMINATION - November 23, 2000
 |  |  |  |  |  | **Thursday | **Friday | **Sat/Sun | **Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-11-23 00:00:00 | 2000-11-24 00:00:00 | 11/25-26/2000 | 2000-11-27 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs. | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs | 0 to 0  0900hrs | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs | 0  to 0 2100hrs | 0  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | HPL | 30 | 0 | 0 | 0 | 80 | *
Enron (S) |  | Sandhills |  | Enron | 0 | 8 | 8 | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 727398d1617882654-using-colour-to-show-the-highest-lowest-equal-numbers-in-2-rows-test-golf
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
A | 12 | 19 | 17 | 15 | 15 | 18 | 15 | 13 | 14 | 14 | 13 | 13 | 15 | 10 | 19 | 16 | 14 | 12
B | 12 | 14 | 10 | 17 | 11 | 15 | 15 | 14 | 11 | 10 | 12 | 11 | 16 | 12 | 19 | 15 | 12 | 11
Spreadsheet: 119309d1314304443-need-your-opinion-my-sample
Sheet: M Analysis

Item: | Area: | Unit [NAME] (in GBP VAT excl.): | Selling Price (in GBP VAT incl.): | Selling Price (in GBP VAT excl.): | Net margin (Maud's) | Gross Profit Margin (Maud's):
M Caesar Salad  Total |  |  | 3.2
M Baked Potato Total |  |  | 3.2
Maud's Goats Cheese Total |  |  | 3.2