tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25624__31X
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031X
COMPANY NAME     Harper Investment Company
ANALYSIS OF OTHER DEFERRED CREDITS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
EXTENSION:
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash (Pd) / Rec'd |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
 |  | 0
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 64273d1265141248-search-tabs-and-return-results-kc_environmental_aspects-1-
Sheet: Process - Activity 13

Operating Condition | Process Evaluated | process 13 | Date |  |  | Enter Date |  | Team | 0
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 0 | 0 | 6 | Yes
 |  |  |  |  | 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
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
Spreadsheet: 167942d1342164918-i-want-to-send-data-in-multiple-workbook-frist-data-entry-voucher-bill-book-sheet
Sheet: Voucher-Sheet

 |  |  |  |  |  |  |  |  |  |  |  | A/C Ref.
Project | Head of A/C | Voucher# | DATE | B# | P# | L# | Description | Cheq#/ATM | Slip#/Bank | Book # | [NAME]# | Page# | Ledger# | DEBIT | CREDIT | BALANCE | Present/Un Present
P-05 | Lbr-Shakoor-Tile | 604 | 2012-05-11 00:00:00 | 0 | 35 | BL-03 | Shakoor-Tile | 62074903 | HMB-A | A-12 | 13 | 98 | CL-11 |  | 100000
P-05 | C-Expense | 610 | 2012-05-12 00:00:00 | 0 | 35 | BL-03 | Labour,from 06-05 to 12-05-2012 | 62074909 | HMB-A | A-12 | V-07 | 74 | PS-09 |  | 3200
P-05 | Lbr-Moosa-Chipping | 612 | 2012-05-14 00:00:00 | 0 | 35 | BL-03 | Moosa-Chipping | 62074911 | HMB-A | A-12 | 10 | 101 | CL-11 |  | 20000
P-05 | Lbr-Akhtar-Trolly | 618 | 2012-05-17 00:00:00 | 0 | 35 | BL-03 | Akhtar-Trolly | 62074913 | HMB-A | A-12 | 2 | 43 | CL-11 |  | 10000
P-05 | C-Expense | 628 | 2012-05-19 00:00:00 | 0 | 36 | BL-03 | Labour, from 13-05 to 19-05-2012 | 62074918 | HMB-A | A-12 | V-08 | 74 | PS-09 |  | 1600
P-22 | Lbr-M.Khan-Shutring | 607 | 2012-05-11 00:00:00 | 0 | 35 | BL-03 | M.Khan-Shutring | 62074906 | HMB-A | A-12 | 9 | 69 | CL-11 |  | 4100
P-22 | C-Expense | 609 | 2012-05-12 00:00:00 | 0 | 35 | BL-03 | Labour,Mason,from 06-05 to 12-05-2012 | 62074908 | HMB-A | A-12 | V-11 | 78 | PS-09 |  | 3650
P-22 | [NAME] | 625 | 2012-05-18 00:00:00 | 0 | 35 | BL-03 | Shafiq-Tile | 62074915 | HMB-A | A-12 | 7 | 128 | CL-11 |  | 5000
P-22 | C-Expense | 638 | 2012-05-22 00:00:00 | 0 | 36 | BL-03 | Labour, from 13-05 to 19-05-2012 | 62074921 | HMB-A | A-12 | V-12 | 78 | PS-09 |  | 5600
P-22 | [NAME] | 640 | 2012-05-23 00:00:00 | 0 | 36 | BL-03 | Labour,Shafiq-Tile | 62074923 | HMB-A | A-12 | 8 | 128 | CL-11 |  | 10000
P-35 | Lbr-M.Khan-Shutring | 606 | 2012-05-11 00:00:00 | 0 | 35 | BL-03 | M.Khan-Shutring | 62074905 | HMB-A | A-12 | 4 | 122 | CL-11 |  | 17600
Spreadsheet: 869373d1715947394-copying-data-to-next-line-and-remove-old-line-book1
Sheet: Sheet1

object network Flex_webservices.mf.nl_2 |  |  | host 82.161.207.74 | description [NAME] helloflexgroup
host 82.161.207.74 |  | object network Flex_webservices.mf.nl_3 | host 213.127.203.44 | description [NAME] helloflexgroep
description [NAME] helloflexgroup |  | object network Locatie_MF_Emmen | subnet 192.168.58.0 255.255.255.0 | object network WSUS_NAT
object network Flex_webservices.mf.nl_3 |  | host 192.168.61.35 | description t.b.v. AlwaysOnVPN | object network o365-smtp
host 213.127.203.44 |  | fqdn v4 smtp.office365.com | object network o365-outlook-1 | subnet 40.92.0.0 255.254.0.0
description [NAME] helloflexgroep
object network Locatie_MF_Emmen
subnet 192.168.58.0 255.255.255.0
object network WSUS_NAT
host 192.168.61.35
description t.b.v. AlwaysOnVPN
object network o365-smtp
fqdn v4 smtp.office365.com
object network o365-outlook-1
subnet 40.92.0.0 255.254.0.0
Spreadsheet: 840527d1692800279-need-to-enter-data-3-times-a-day-on-same-date-blood-pressure-log-sample
Sheet: Blood Pressure Log

Blood Pressure Log
Name | [Your Name] | Your Age
D.O.B | 1967-07-12 00:00:00
[NAME] | 120 | mmHg
[NAME] | 80 | mmHg                      from
Normal Pulse | 60 | BPM                             to
Date | Systolic  (mmHg) | Diastolic  (mmHg) | Pulse  (BPM) | [NAME] | Column1 | [NAME] | Normal Puls
2014-02-25 00:00:00 | 135 | 80 | 65
2014-02-26 00:00:00 | 130 | 82 | 64
2014-02-27 00:00:00 | 129 | 80 | 65
2014-02-28 00:00:00 | 135 | 85 | 68
2014-03-01 00:00:00 | 140 | 90 | 72
2014-03-02 00:00:00 | 135 | 85 | 68
2014-03-03 00:00:00 | 125 | 80 | 65
2014-03-04 00:00:00 | 128 | 80 | 64
2014-03-05 00:00:00 | 135 | 84 | 63
2014-03-06 00:00:00 | 140 | 90 | 70
2014-03-07 00:00:00 | 135 | 80 | 65
2014-03-08 00:00:00 | 130 | 80 | 65
2014-03-09 00:00:00 | 120 | 80 | 60
2014-03-10 00:00:00 | 125 | 80 | 60
2014-03-11 00:00:00 | 125 | 80 | 65
2014-03-12 00:00:00 | 130 | 85 | 65
2014-03-13 00:00:00 | 125 | 85 | 60
2014-03-14 00:00:00 | 130 | 80 | 65
2014-03-15 00:00:00 | 125 | 80 | 65
2014-03-16 00:00:00 | 130 | 80 | 70
2014-03-17 00:00:00 | 130 | 80 | 75
Spreadsheet: 134038d1324951624-calculating-overtime-hours-and-pay-with-two-payrates-helppayroll
Sheet: Sheet1

Doe, [NAME] | Date | Rate | Hours | Tips | Pay
Week 1
 | 2011-12-12 00:00:00 | 10 | 12
 | 2011-12-13 00:00:00 | 10
 | 2011-12-14 00:00:00 | 10 | 10
 | 2011-12-15 00:00:00 | 10 | 8
 | 2011-12-16 00:00:00 | 10 | 8
 | 2011-12-17 00:00:00 | 10 | 8
 | 2011-12-18 00:00:00 | 10
SUBTOTALS:
 | Overtime:
Week 2
 | 2011-12-19 00:00:00 | 10 | 5
 | 2011-12-20 00:00:00 | 10 | 12
 | 2011-12-21 00:00:00 | 10 | 10
 | 2011-12-22 00:00:00 | 10 | 9
 | 2011-12-23 00:00:00 | 10 | 7
 | 2011-12-24 00:00:00 | 10 | 8
 | 2011-12-25 00:00:00 | 10
SUBTOTALS:
 | Overtime:
 | Reg. Hours | : |  | Reg. Pay:
 | O.T. Hours | : |  | [NAME]:
 |  |  |  | Tips:
 |  |  |  | Total:
This basic form works fine, though is probably pretty rough by your standards, but I'm
proud of it. Below is an example of the form I'm having trouble with.
Doe, [NAME] | Date | Rate | Hours | Tips | Pay
Week 1 - Manager
 | 2011-12-12 00:00:00 | 15 | 4
 | 2011-12-13 00:00:00 | 15 | 5
 | 2011-12-14 00:00:00 | 15 | 6
 | 2011-12-15 00:00:00 | 15 | 9
 | 2011-12-16 00:00:00 | 15 | 8
 | 2011-12-17 00:00:00 | 15 | 11
 | 2011-12-18 00:00:00 | 15
SUBTOTALS:
 | Overtime: |  |  |  |  |  | You can see here that in actuality, [NAME] has worked 31 hours of overtime.
Week 1 - Server |  |  |  |  |  |  | 21 hours at 15.00/hr and 10 hours at 2.13/hr. My form only displays a total of 3
 | 2011-12-12 00:00:00 | 2.13 | 8 | 214.34 |  |  | hours of OT, shorting my employee out of her rightful pay.
 | 2011-12-13 00:00:00 | 2.13 | 5 | 68
 | 2011-12-14 00:00:00 | 2.13 | 5 | 262.9
 | 2011-12-15 00:00:00 | 2.13 | 5 | 72
 | 2011-12-16 00:00:00 | 2.13 | 5 | 238.99
 | 2011-12-17 00:00:00 | 2.13
 | 2011-12-18 00:00:00 | 2.13
SUBTOTALS:
 | Overtime:
Week 2 - Manager
 | 2011-12-19 00:00:00 | 15 | 5
 | 2011-12-20 00:00:00 | 15
 | 2011-12-21 00:00:00 | 15 | 5
 | 2011-12-22 00:00:00 | 15
 | 2011-12-23 00:00:00 | 15 | 5
 | 2011-12-24 00:00:00 | 15
 | 2011-12-25 00:00:00 | 15
SUBTOTALS: |  |  |  |  |  |  |  | This week there was no overtime at all, and so I can make the
 | Overtime: |  |  |  |  |  |  | cells display the correct pay with only small corrections. It's
Week 2 - Server |  |  |  |  |  |  |  | only in the case of overtime that I really need help. Ofcourse,
 | 2011-12-19 00:00:00 | 2.13 |  |  |  |  |  | it may be that in order to calculate OT, I may need to change the
 | 2011-12-20 00:00:00 | 2.13 | 5 | 397 |  |  |  | way all of my formulas are working, in which case, I'd appreciate
 | 2011-12-21 00:00:00 | 2.13 | 5 |  |  |  |  | any advice you can give me.
 | 2011-12-22 00:00:00 | 2.13 | 5 | 108
 | 2011-12-23 00:00:00 | 2.13 | 5 | 233.85
 | 2011-12-24 00:00:00 | 2.13 | 5 | 142
 | 2011-12-25 00:00:00 | 2.13
SUBTOTALS:
 | Overtime:
 | Reg. Hours | : |  | Reg. Pay:
 | O.T. Hours | : |  | [NAME]:
 |  |  |  | Tips:
 |  |  |  | Total:
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Derivatives AA

 | Derivatives/Wellhead Analysts/Associates
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 0 | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 60500
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 7500
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 25000 | Total
ENAOUTSV | Outside Services |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  | 5000
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 59 | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  | 7500 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 10000 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 0.2 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 1500 | Analyst | 60500 | 1
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  | 0 | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 2
 | A&A Headcount |  |  |  |  |  | 1 | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 14a

Product |  | TOTAL
Single - Name* | Corporate | 742360
 | Loans | 4850
 | Municipal | 1828
 | Recovery
 | Sovereign | 218257
Index Tranche | Asia | <1,000
 | Europe | 172931
 | North America | 158277
Index | Asia | 26532
 | Europe | 381933
 | North America | 535351
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 2242318
Estimated net notional amount outstanding, February 1 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: John Bartholomew

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
This is standard procedure for any collective bargaining unit.
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
The teachers of our children have an extremely important role to play - they hold one of the most important jobs in our society.
Attracting and retaining high quality teachers must be a priority.
Teaching Profession: Simplifying Professional Relicensing
I'd like to explain my position
Explain your relicensing position, if you choose
I do not know anything about the current relicensing process.  I need to be better informed before adopting a position.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 23 Linden Rd., Hartland, VT 05048 | State Representative | Yes |  | Windsor
Spreadsheet: 769707d1645645614-combine-text-document-and-split-into-two-columns-document
Sheet: DATA FROM REPORT

THIS DATA IS COPIED FROM A TEXT DOCUMENT AND PASTED INTO EXCEL. |  | I NEED TO JOIN THE CATEGORY WITH THE TOTAL  SO IT IS IN ONE LINEBUT SEPARATE COLUMNS AS BELOW
 |  | CATEGORY | TOTAL
TOWN A                          202201  (0=>FRUIT01) (CATEGORY01) APPLES |  | (0=>FRUIT01) (CATEGORY01) APPLES | 12
 |  | (0=>FRUIT02) (CATEGORY02) PEARS | 120
12 |  | (0=>FRUIT03) (CATEGORY03) BANANAS | 3
 |  | (0=>FRUIT04) (CATEGORY04) PRUNES | 1121
(0=>FRUIT02) (CATEGORY02) PEARS |  | (0=>FRUIT05) (CATEGORY05) ORANGES | 0
 |  | (003100) PUMPKIN | 16
120 |  | (055012) ONIONS | 25
(0=>FRUIT03) (CATEGORY03) BANANAS
3
(0=>FRUIT04) (CATEGORY04) PRUNES
1121
(0=>FRUIT05) (CATEGORY05) ORANGES
0
(003100) PUMPKIN
16
(055012) ONIONS
25
TOWN B                          202201  (0=>FRUIT01) (CATEGORY01) APPLES
25
(0=>FRUIT02) (CATEGORY02) PEARS
95
(0=>FRUIT03) (CATEGORY03) BANANAS
1432
(0=>FRUIT04) (CATEGORY04) PRUNES
524
(0=>FRUIT05) (CATEGORY05) ORANGES
9
(012345) COCONUTS
99
(987654) DRAGON FRUIT
852
Spreadsheet: 857228d1706254488-countif-with-tabular-data-sample
Sheet: Sheet1

DATA
Student | TA | Test 1 | Test 2 | Test 3
[NAME] | [NAME] | A | A | B
[NAME] | [NAME] | B | C | B
[NAME] | [NAME] | C | C | B
Ellen | [NAME] | B | A | C
[NAME] | [NAME] | A | B | B
RESULT 1
Student | A | B | C
[NAME]
[NAME]
[NAME]
[NAME]
Ellen
RESULT 2
TA | A | B | C
[NAME] | 3 | 2 | 1
[NAME] | 1 | 5 | 3
Spreadsheet: 130856d1322622376-how-to-retrieve-the-nth-occurrence-test
Sheet: Sheet1

 | MON |  |  |  |  |  |  |  |  |  |  | Time | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00
TEAM | AGENT | Shift start | Break 1 start | Break 1 end | Break 2 start | Break 2 end | Break 3 start | Break 3 end | Break 4 start | Break 4 end | Shift end |  | 11 | 11 | 13 | 13 | 15 | 15 | 17 | 17 | 19 | 19 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 22 | 22 | 20 | 20 | 18 | 18 | 16 | 16 | 14 | 14
Team 1 | Agent 1 | 08:00:00 | 09:00:00 | 09:15:00 | 10:45:00 | 11:15:00 | 13:15:00 | 13:45:00 | 15:45:00 | 16:07:00 | 18:30:00 |  | o | o | o | o | 15 | o | o | o | o | o | o | 30 | 30 | o | o | o | o | o | o | o | o | 30 | 30 | o | o | o | o | o | o | o | o | 22.5 | 22.5 | o | o | o | o | o | o | o | o | o
Team 1 | Agent 1 | 08:00:00 |  |  |  |  |  |  |  |  | 18:30:00 |  | o | o | o | o | 15 | o | o | o | o | o | o | 30 | 30 | o | o | o | o | o | o | o | o | 302 | 302 | o | o | o | o | o | o | o | o | 152 | 7 | o | o | o | o | o | o | o | o | o
Team 1 | Agent 1 | 08:00:00 |  |  |  |  |  |  |  |  | 18:30:00 |  | o | o | o | o | 15 | o | o | o | o | o | o | 30 | 30 | o | o | o | o | o | o | o | o | 302 | 302 | o | o | o | o | o | o | o | o | 152 | 7 | o | o | o | o | o | o | o | o | o
Spreadsheet: 762785d1641819614-multiple-if-and-formula-multiple-criteria-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Present Formula | Result I Need
Employee ID | Employee Resident ID | ACH Bank Code | Bank Account Number | Employee Name | Location | Category | Amount | Worth Salary | Housing | Other Earnings | Deductions Total | Bank Fee
1783 |  | SABBSARI |  |  |  | WPS | 23150 | 15000 | 5250 | 2900 | 0 |  | 0
3233 |  | ACECSARI |  |  |  | WPS | 21490 | 16500 | 5775 | 2797 | 3582 |  | 5.75
3797 |  | SABBSARI |  |  |  | WPS | 14750 | 13000 | 3900 | 1750 | 3900 |  | 0
4863 |  | SINVSARI |  |  |  | WPS | 7133 | 7500 | 2250 | 1608 | 4225 |  | 5.75
5867 |  | ACECSARI |  |  |  | WPS | 7400 | 5000 | 1500 | 900 | 0 |  | 5.75
5932 |  | NCLBSAJD |  |  |  | WPS | 4675 | 4200 | 1260 | 823 | 1608 |  | 5.75
6000 |  | ACECSARI |  |  |  | WPS | 36500 | 33000 | 11550 | 3500 | 11550 |  | 5.75
6059 |  | NCLBSAJD |  |  |  | Non-WPS | 9051 | 5962 | 1789 | 3086 | 1786 |  | 8.05
7053 |  | Cash |  |  |  | Non-WPS | 5000 | 4000 | 1000 | 0 |  |  | 0
7054 |  | NCLBSAJD |  |  |  | Non-WPS | 5000 | 4000 | 1000 | 0 |  |  | 8.05
6001 |  | ACECSARI |  |  |  | WPS | 0 | 0 | 0 | 0 | 0 |  | 0
Spreadsheet: 70942d1271700995-reference-formula-or-array-formula-gas-price-decrease-study
Sheet: Sheet1

Transaction number/Date-Time | Category | UPC | Product Name | Units | Dollars | Total Food Sold with Gas Purchase
1234 | Gas | 636 | Unleaded | 10.5 | 26.145
1234 | Juice | 232 | B 6/12L | 1 | 6.99
1234 | Food | 445 | Snickers | 2 | 0.99 | 0.99
1234 | Water | 566 | Evian | 1 | 4.99
1235 | Gas | 636 | Unleaded | 12 | 29.88
1235 | Juice | 235 | B L 1/24C | 2 | 3.98
1235 | Food | 441 | Donut | 3 | 3.5 | 3.5
1236 | Juice | 237 | N L 30 | 1 | 15.99
1236 | Food | 113 | Chips | 1 | 1.99
1236 | Soda | 745 | Pepsi 2 ltr | 2 | 3.29
1237 | Gas | 636 | Unleaded | 10.5 | 26.145
1237 | Food | 113 | Chips | 1 | 1.99 | 1.99
1237 | Soda | 745 | Pepsi 2 ltr | 2 | 3.29
Spreadsheet: 287587d1388879288-need-number-of-consecutive-hours-with-temperatures-below-zero-temp-rounded
Sheet: Pivot

 | Rank | Start Date in Hours | End Date in Hours | Sum of Hours Below Zero
 | 1 | 1996-01-29 23:00:00 | 1996-02-04 21:00:00 | 142
 | 2 | 1996-12-25 01:00:00 | 1996-12-26 14:00:00 | 37
 | 3 | 1996-01-19 09:00:00 | 1996-01-20 18:00:00 | 33
 | 4 | 1996-01-06 01:00:00 | 1996-01-06 17:00:00 | 16
 | 5 | 1996-01-07 02:00:00 | 1996-01-07 16:00:00 | 14
 | 6 | 1996-01-28 02:00:00 | 1996-01-28 15:00:00 | 13
 | 7 | 1996-12-26 23:00:00 | 1996-12-27 10:00:00 | 11
 | 8 | 1996-01-25 04:00:00 | 1996-01-25 14:00:00 | 10
 | 8 | 1996-02-06 02:00:00 | 1996-02-06 12:00:00 | 10
 | 8 | 1996-12-20 06:00:00 | 1996-12-20 16:00:00 | 10
 | Grand Total |  |  | 296
Spreadsheet: 100147d1298572968-add-letters-to-numbers-in-column-b-copy-of-book1_sem-1-new
Sheet: Sheet2

01 02 38 | A
01 03 10 | B
01 04 17 | C
01 05 24 | D
01 06 16 | E
01 07 36 | F
01 08 15 | G
01 09 14 | H
01 11 26 | I
01 12 30 | J
01 13 25 | K
01 18 37 | L
01 19 21 | M
01 20 29 | N
01 22 31 | O
01 23 28 | P
01 27 39 | R
01 32 35 | S
01 33 34 | T
02 03 34
02 04 25
02 05 06
02 07 15
02 08 23
02 09 12
02 10 37
02 11 39
02 13 35
02 14 18
02 16 27
02 17 33
02 19 24
02 20 36
02 21 28
02 22 29
02 26 30
02 31 32
03 04 35
03 05 32
03 06 08
03 07 12
03 09 24
03 11 14
03 13 16
03 15 33
03 17 18
03 19 27
03 20 30
03 21 38
03 22 36
03 23 29
03 25 31
03 26 37
03 28 39
04 05 27
04 06 29
04 07 39
04 08 14
04 09 36
04 10 18
04 11 22
04 12 34
04 13 30
04 15 28
04 16 19
04 20 32
04 21 33
04 23 37
04 24 38
04 26 31
05 07 30
05 08 10
05 09 38
05 11 23
05 12 35
05 13 28
05 14 33
05 15 18
05 16 31
05 17 26
05 19 39
05 20 22
05 21 36
05 25 37
05 29 34
06 07 32
06 09 33
06 10 27
06 11 34
06 12 28
06 13 37
06 14 39
06 15 17
06 18 30
06 19 36
06 20 26
06 21 25
06 22 38
06 23 31
06 24 35
07 08 35
07 09 20
07 10 11
07 13 17
07 14 24
07 16 18
07 19 22
07 21 23
07 25 28
07 26 34
07 27 33
07 29 31
07 37 38
08 09 29
08 11 31
08 12 22
08 13 33
08 16 20
08 17 30
08 18 36
08 19 26
08 21 27
08 24 25
08 28 32
08 34 38
08 37 39
09 10 19
09 11 37
09 13 15
09 16 26
09 17 21
09 18 39
09 22 32
09 23 35
09 25 27
09 28 34
09 30 31
10 12 24
10 13 32
10 14 16
10 15 25
10 17 28
10 20 21
10 22 33
10 23 30
10 26 36
10 29 35
10 31 34
10 38 39
11 12 33
11 13 19
11 15 38
11 16 36
11 17 32
11 18 20
11 21 29
11 24 28
11 25 35
11 27 30
12 13 36
12 14 17
12 15 32
12 16 38
12 18 26
12 19 23
12 20 31
12 21 37
12 25 39
12 27 29
13 14 27
13 18 38
13 20 34
13 21 26
13 22 23
13 24 29
13 31 39
14 15 26
14 19 32
14 20 23
14 21 31
14 22 35
14 25 38
14 28 29
14 30 36
14 34 37
15 16 23
15 19 29
15 20 39
15 21 30
15 22 27
15 24 34
15 31 36
15 35 37
16 17 29
16 21 35
16 22 25
16 24 33
16 28 37
16 30 34
16 32 39
17 19 31
17 20 24
17 22 37
17 23 39
17 25 34
17 27 38
17 35 36
18 19 28
18 21 22
18 23 34
18 24 31
18 25 32
18 27 35
18 29 33
19 20 25
19 30 37
19 33 38
19 34 35
20 27 37
20 28 38
20 33 35
21 24 39
21 32 34
22 24 26
22 28 30
22 34 39
23 24 27
23 25 36
23 26 38
23 32 33
24 30 32
24 36 37
25 26 29
25 30 33
26 27 32
26 28 35
26 33 39
27 28 31
27 34 36
28 33 36
29 30 38
29 32 37
29 36 39
30 35 39
31 33 37
31 35 38
32 36 38
Spreadsheet: 438520d1452014629-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-summary1
Sheet: Sheet1

Employee Name | Start Date | Years of Service | vac available | hours used | hours remaining
A | 2014-10-23 00:00:00
B | 2015-08-11 00:00:00
C | 2014-10-27 00:00:00
D | 2015-03-30 00:00:00
E | 2015-03-21 00:00:00
F | 2015-05-29 00:00:00
G | 2013-11-20 00:00:00
H | 2015-07-15 00:00:00
I | 2012-08-31 00:00:00
J | 2014-01-27 00:00:00
K | 2012-07-09 00:00:00
L | 2014-10-29 00:00:00
M | 2015-01-01 00:00:00
N | 2010-07-20 00:00:00