tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 78dc6a80-91c1-405f-9b33-e23d44c23603
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
 | Contents of Spreadsheet Fields are as Follows:
CMAQ ID | Application ID
[NAME] | [NAME]
Facility to be Improved | Project Location
Project Cost | Total project cost
Federal Request | Total federal request
Project Description | short description of the project
Program year | first program year
Completion year | completion year
ROW | ROW  code, N=not required, R=Required, A= Acquired
Design | Design code, N=Not Begun, U=Underway, S=Submitted, A=Approved.  Cell shaded green phase 2 approved
Construction Ready? | Project readiness. Y=project is mostly finished with design and ROW issues - suitable for 2013 implementation and before, N=outstanding ROW or engineering issues-cast doubt of project readiness by 2013, P=project can probably be ready by 2013.  Cell shaded RED=project not ready and construction programming requested for fy2012, YELLOW=project not ready and construction programming requested for fy2013
Interstate Sys | Interstates, 0=Off system, 1=On system
[NAME] | National Highway System, 0=Off system, 1=On system
SRA Sys | Strategic Regional Arterials, 0=Off system, 1=On system
OPA Sys | Other Principal Arterials, 0=Off system, 1=On system
CTA | CTA System, 0=Off system, 1=On system
Pace | Pace System, 0=Off system, 1=On system
TSP | Planned Transit Signal Priority Route, 0=Off system, 1=On system
[NAME] | Bus as probe monitored route, 1=0n system, 0=Off System
Total Veh | Total vehicle counts on each intersection link divided by two.  Total was divided by two to account for directionality.  Counts obtained from IRIS 2010.  For signal interconnect project maximum link vehicle count was used.
Total VPL | Total vehicle counts on each intersection link divided by the number of lanes.  Total was then divided by two to account for direction.  Vehicle counts obtained from IRIS 2010.  For signal interconnect project maximum link vehicle per lane was used.
Heavy Veh | Total heavy vehicle counts recorded on each intersection link in IRIS 2010 and then divided by two.  For signal interconnect project maximum link heavy vehicle count was used.
[NAME] | Maximum AM travel time index
Max PM TTI | Maximum PM travel time Index
Safety | Location of IDOT 5% crash list
Crashes08 | total 2008 Crashes at Project Location
Crashes09 | Total 2009 Crashes at Project Location
Severity Index08 | calculated by formula (20*#Fatal Crash)+(10*#Ainjury Crash)+(3*#Binjury Crash)+(2*#Cinjury Crash)+(1*#PDO Crash)/total crashes
Severity Index09 | calculated by formula (20*#Fatal Crash)+(10*#Ainjury Crash)+(3*#Binjury Crash)+(2*#Cinjury Crash)+(1*#PDO Crash)/total crashes
Congested | Location identified as congested by Counties and/or IDOT
Strategic Interest | Project type is inline with CMAP's strategic interest
Priority | Field for user to assign priorities based on evaluation criteria
Notes | User notes
Spreadsheet: 788684d1658639756-average-function-based-on-multiple-criteria-book-2_average
Sheet: Sheet1

 |  |  |  |  |  | Lookup column C for all cells > 50
 | Sold | Quantity | Price |  |  | Lookup column D for all cells > 50
 | 20 | 10 | 100 |  |  | From the cells in column C >50 & column D >50 then average column B for those cells that match the criteria
 | 15 | 100 | 100
 | 30 | 65 | 50 |  |  | ANSWER | 37.5
 | 50 | 30 | 20 |  |  |  | Table1
 | 100 | 800 | 10 |  |  |  | 37.5
 | 20 | 150 | 200
 | 75 | 75 | 400
 | 65 | 20 | 20
 | 30 | 35 | 60
 | 40 | 175 | 70
Spreadsheet: 728541d1618503130-how-to-make-values-in-one-column-follow-the-values-in-other-columns-link-value-to-client-aligw
Sheet: Sheet1

 |  | January |  |  |  | February |  |  |  |  | March |  |  |  |  | Clients
 |  | Client name | Comments | Premium |  | Client name | Comments | Premium |  |  | Client name | Comments | Premium |  |  | Client name | Comment
 |  | [NAME] |  | 10000 |  | [NAME] |  | 10000 |  |  | [NAME] |  | 10000 |  |  | [NAME] | Ok
 |  | Client Can |  | 20000 | New client | [NAME] |  | 17000 |  |  | [NAME] |  | 17000 |  |  | [NAME]
 |  | Client Cree |  | 15000 |  | Client Can |  | 20000 |  |  | Client Can |  | 20000 |  |  | Client Can | Renew ahead
 |  | [NAME] |  | 1000 |  | Client Cree |  | 15000 |  | New client | Client Cannot |  | 15000 |  |  | Client Cannot
 |  |  |  |  |  | [NAME] |  | 1000 |  |  | Client Cree |  | 15000 |  |  | Client Cree | Talk to repr.
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 1000 |  |  | [NAME] | Small bus.
Spreadsheet: 219787d1362948178-have-a-function-but-if-the-answer-is-a-negative-i-want-it-to-say-zero-0-stats-sheet
Sheet: Sheet1

Date Referred | Install Date | Removal Date | Total # of Days Sentenced | Offender | Agency | Number of Days Served at time of report | Offence that put Offender on Program | Violations Yes/No | Was it a Misd. or Felony | What is Violation | Date of Report
2012-12-07 00:00:00 | 2013-01-27 00:00:00 | 2013-05-12 00:00:00 | 105 | [NAME] | [NAME] | 41 | DUI | Yes | Misd | DUI | 2013-03-09 00:00:00
2013-03-07 00:00:00 | 2013-03-15 00:00:00 | Pre-Trial | PT | [NAME] | Pinal Co APO | -6 |  |  |  |  | 2013-03-09 00:00:00
2013-03-01 00:00:00 | 2013-03-16 00:00:00 | 2013-04-25 00:00:00 | 40 | [NAME] | [NAME] | -7 |  |  |  |  | 2013-03-09 00:00:00
2013-01-15 00:00:00 | 2013-03-17 00:00:00 | 2013-04-01 00:00:00 | 15 | [NAME] | [NAME] | -8 |  |  |  |  | 2013-03-09 00:00:00
2013-02-21 00:00:00 | 2013-03-28 00:00:00 | 2013-04-13 00:00:00 | 16 | [NAME] | [NAME] | -19 |  |  |  |  | 2013-03-09 00:00:00
2013-02-21 00:00:00 | 2013-04-10 00:00:00 | 2013-04-17 00:00:00 | 7 | [NAME] 6 | [NAME] | -32 |  |  |  |  | 2013-03-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2013-03-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2013-03-09 00:00:00
 |  |  |  |  |  |  | Column G is the date of report minus the |  |  |  | 2013-03-09 00:00:00
 |  |  |  |  |  |  | installation date, but some of the people
 |  |  |  |  |  |  | on the list have not been installed yet so
 |  |  |  |  |  |  | I would like the number to be zero, they are
 |  |  |  |  |  |  | now coming up with a negative number.
 | Total # of Participants Refered in reporting period |  |  |  |  |  | Also if someone has completed their time
 |  |  |  |  |  |  | during the reporting period can we get it to
 | Total # of Participants in Program during reporting period |  |  |  |  |  | stop counting at the removal date.
 |  |  |  |  |  |  | Also is there any way of getting this to work
 | Total # of Participants Completing Program during reporting period |  |  |  |  |  | with having my date of report only in 1 cell
 |  |  |  |  |  |  | rather than in the whole column? If not this
 | Total # of Participants that were violated from Program during reporting period |  |  |  |  |  |  | is the least of my worries!
 | Total # of Participants that have used alcohol and/or drugs while on program
 | and/or refused an alcohol or drug test during the reporting period
 | Number of DUI offenders that have used alcohol and/or drugs while on the |  |  |  |  |  |  |  | I am also going to be sending questions about
 | program and/or refused an alcohol or drug test during the reporting period |  |  |  |  |  |  | <-------- | all of those!
 | Number of program participants that committed a new misd. [NAME] while
 | on program during the reporting period (See Offender info for individual accounts)
Spreadsheet: 697844d1601567533-is-there-a-way-to-automate-this-row-sort-process-rowsort-ans
Sheet: Sheet1

 | 3 | 12 | 13 | 19 | 34 | 53 | 65
 | 7 | 22 | 33 | 18 | 91 | 26 | 77
 | 45 | 34 | 5 | 67 | 89 | 12 | 23
 | 39 | 14 | 25 | 46 | 8 | 42 | 19
 | 12 | 48 | 23 | 55 | 13 | 40 | 21
 | 19 | 4 | 69 | 17 | 51 | 39 | 33
 | 99 | 14 | 15 | 20 | 36 | 39 | 9
 | 23 | 24 | 37 | 81 | 13 | 15 | 1
 | 66 | 22 | 49 | 93 | 1 | 25 | 44
 | 6 | 88 | 19 | 12 | 45 | 68 | 23
Spreadsheet: 45834d1244627777-count-book4-1-
Sheet: Sheet1

 | Week 01 | Apple | 1
 | Week 02 | [NAME] | 1
 | Week 03 | Apple | 3
 | Week 04 | Orange | 1
 | Week 05 | Orange | 3
 | Week 06 | [NAME] | 3
 | Week 07 | Apple | 4
 | Week 08 | Orange | 4
 | Week 09 | Orange | 5
 | Week 10 | Orange | 6
 | Week 11 | Apple | 5
 | Week 12 | [NAME] | 4
 | Winners: | Orange
 | I want to display as "apple" in row 18
Spreadsheet: 676832d1589011506-conditional-formatting-extends-to-totals-row-jaybook1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Qtr 1
 |  |  |  |  |  |  |  |  |  |  | Qtr 3 |  |  |  |  | 1800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | raja | 100
 |  |  | sno | empid | empname | salary |  |  |  |  |  |  |  |  |  |  |  | 2 | jay | 200
 |  |  | 13 | 1023 | deep t | 4000 |  |  |  | 13 | 1 |  |  |  | 4 | 7 |  | 3 | [NAME] | 300
 |  |  | 1 | 1023 | [NAME] | 1000 |  |  |  | 1 | 6 |  |  | 15 | 2 | 1 |  | 4 | harish | 400
 |  |  | 2 | 1023 | [NAME] m | 2000 |  |  |  | 6 | 2 |  |  |  | 3 | 2 |  | 5 | nimoo | 500 | 100
 |  |  | 3 | 1023 | [NAME] m | 3000 |  |  |  | 3 | 5 |  |  |  | 4 | 3
 |  |  | 4 | 1021 | minal r | 4000 |  |  |  | 4 | 4
 |  |  | 5 | 1022 | [NAME] | 5000 |  |  |  | 5 | 3 | 5834.4354
 |  |  | 6 | 1023 | [NAME] m | 4000 |  |  |  | 6 | 2
 |  |  | 7 | 1021 | minal r | 1000 |  |  |  |  |  |  |  |  |  |  |  | 1 | raja | 100
 |  |  | 8 | 1022 | [NAME] | 5000 |  |  |  |  |  |  |  |  | 5345 |  |  | 2 | jay | 200
 |  |  | 9 | 1022 | [NAME] | 4000 |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | 300
 |  |  | 10 | 1023 | [NAME] m | 3000 |  |  |  |  |  |  |  |  |  |  |  | 4 | harish | 400
 |  |  | 11 | 1024 | raja n | 5000 |  |  |  |  |  | lname | fname | Name | 434 |  |  | 5 | nimoo | 500
 |  |  | 12 | 1022 | dj m | 4000 |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  | 14 | 1021 | rama m | 7000 |  |  |  |  |  | Desai | Jaideep
 |  |  | 15 | 1022 | [NAME] | 4000 |  |  |  |  |  | Karkera | Harish
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 3 | 3
 |  |  |  |  |  |  | sal2 | sal3 |  |  | 2 | 4 |  | 201904
 |  |  |  |  |  |  | 12000 | 25000 |  |  |  |  |  | 25
 |  |  |  |  |  |  | 11000 | 23000
 |  |  |  |  | ename | sal1 | 4000 | 9000 |  |  | 1,02,500 | 102500
 |  |  | 10000 |  | [NAME] |  | 2000 | 5000
 |  |  |  |  | [NAME] m
 |  |  |  |  | minal r
 |  |  |  |  | raja m | 3000 |  |  | 111
 |  |  |  |  |  | 5345
 |  |  |  |  |  | 34534
 |  |  |  |  |  |  | 2019-03-02 00:00:00
 |  |  |  |  |  |  |  | 2019
 |  |  |  | 234
 |  |  |  |  | 1900-01-02 00:00:00
Spreadsheet: 467909d1467040951-need-help-with-formula-flooring-calculator
Sheet: Sheet1

Job Number |  | Job Description |  |  |  |  | Hours Worked | Cost Per Hour | Total Labor Cost
25-780234 |  | [NAME] |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | TOTAL MATIRALS:
 |  |  |  |  |  |  |  | GRAND TOTAL JOB COST:
 |  |  |  |  |  | Qty | Square yards | Price Per | Total
 |  |  |  |  |  | 24 |  | 1.97
 |  |  |  |  |  |  | 30 | 2.99
TOTAL MARTIAL COST
Spreadsheet: 53313d1253201672-helpppppppp-with-excel-formula-example
Sheet: Sheet1

Despatch Date | Customer | Dseq | Order | Line | Item | PosT Code | Vol (m3) | [NAME] |  | Order | VOL | WEIGHT
2009-02-13 00:00:00 | [NAME] | 0 | 202909 | 5 | R055 | TR4 8QQ | 0.10992 | 80.33 |  | 202909 | 0.10992 | 80.33
2009-02-13 00:00:00 | [NAME] | 0 | 203474 | 1 | R043 | TR4 8QQ | 0.31621 | 218.3 |  | 203474 | 2.1442 | 1635.2
2009-02-13 00:00:00 | [NAME] | 0 | 203474 | 2 | R064 | TR4 8QQ | 0.87936 | 732
2009-02-13 00:00:00 | [NAME] | 0 | 203474 | 3 | R045 | TR4 8QQ | 0.94863 | 684.9
Spreadsheet: 051b1e7e-a9bf-4047-ab82-c193e4d239a3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Figure 1.2.9 - Net financial assets of families as a percentage of GDP of some countries - Year 2010
 | Source: processing  by  Regione  Veneto  -  Direzione  Sistema Statistico Regionale on Banca d´Italia data
 | Net financial assets of families as a percentage of GDP of some countries - Year 2010
 |  | Belgium | United Kingdom | Italy | France | Germany | Euro Area | Portugal | Sweden | Spain | Ireland
 | 2009 | 210.4 | 187.9 | 179.8 | 131.5 | 131 | 129.8 | 126.7 | 99.4 | 76.3 | 66.3
 | Source: processing by [NAME] on Eurostat data
Spreadsheet: 854682d1704464715-matching-asset-list-to-unit-matching-asset-list
Sheet: Sheet1

 | Matching Asset List to Unit
 | Asset
 | 1. Table
 | 2. Chair
 | 3. Sofa
 | 4. Fan
 | 5. Table Lamp
 | 6. Side Table
 | Unit |  | No | Unit | Table | Chair | Sofa | Fan | Table Lamp | Side Table
 | 1) 1-2 (2,5) |  | 1 | 1-2 |  | x |  |  | x
 | 2) 2-2 (2,5,6) |  | 2 | 2-2 |  | x |  |  | x | x
 | 3) 23-1 (1) |  | 3 | 23-1 | x
 | 4) 17-2 (1,2,3,5) |  | 4 | 17-2 | x | x | x |  | x
 | 5) 3-1 (1,2,4) |  | 5 | 3-1 | x | x |  | x
 | 6) 19-3 (1) |  | 6 | 19-3 | x
 | 7) 33-2 (2,3,5) |  | 7 | 33-2 |  | x | x |  | x
 | 8) 19-2 (1,3,5) |  | 8 | 19-2 | x |  | x |  | x
 | 9) 21-1 (1) |  | 9 | 21-1 | x
 | 10) 12-1 (6) |  | 10 | 12-1 |  |  |  |  |  | x
 | 11) 3-3 (2) |  | 11 | 3-3 |  | x
 | 12) 33-3 (1,2,6) |  | 12 | 33-3 | x | x |  |  |  | x
 |  |  |  | Unit | Table | Chair | Sofa | Fan | Table Lamp | Side Table
 |  |  | 1 | 1-2 |  | x |  |  | x
 |  |  | 2 | 2-2 |  | x |  |  | x | x
 |  |  | 3 | 23-1 | x
 |  |  | 4 | 17-2 | x | x | x |  | x
 |  |  | 5 | 3-1 | x | x |  | x
 |  |  | 6 | 19-3 | x
 |  |  | 7 | 33-2 |  | x | x |  | x
 |  |  | 8 | 19-2 | x |  | x |  | x
 |  |  | 9 | 21-1 | x
 |  |  | 10 | 12-1 |  |  |  |  |  | x
 |  |  | 11 | 3-3 |  | x
 |  |  | 12 | 33-3 | x | x |  |  |  | x
Spreadsheet: 103708d1301436559-count-conditional-formatted-cells-2-example-wkbook
Sheet: Sheet1

 |  |  |  |  |  |  | Bonus
1982-06-12 00:00:00 | 3 | 11 | 12 | 14 | 41 | 43 | 13
1982-06-19 00:00:00 | 8 | 33 | 36 | 37 | 39 | 41 | 9
1982-06-26 00:00:00 | 1 | 6 | 23 | 24 | 27 | 39 | 34
1982-07-03 00:00:00 | 3 | 9 | 10 | 13 | 20 | 43 | 34
1982-07-10 00:00:00 | 5 | 14 | 21 | 31 | 34 | 47 | 45
1982-07-17 00:00:00 | 8 | 20 | 21 | 25 | 31 | 41 | 33
1982-07-24 00:00:00 | 18 | 25 | 28 | 33 | 36 | 42 | 7
1982-07-31 00:00:00 | 7 | 16 | 17 | 31 | 40 | 48 | 26
1982-08-07 00:00:00 | 5 | 10 | 23 | 27 | 37 | 38 | 33
1982-08-14 00:00:00 | 4 | 15 | 30 | 37 | 46 | 48 | 3
1982-08-21 00:00:00 | 7 | 9 | 21 | 33 | 38 | 42 | 45
1982-08-28 00:00:00 | 11 | 17 | 19 | 20 | 36 | 43 | 9
1982-09-04 00:00:00 | 7 | 14 | 17 | 20 | 37 | 47 | 34
1982-09-11 00:00:00 | 25 | 28 | 29 | 30 | 35 | 44 | 3
1982-09-18 00:00:00 | 8 | 18 | 36 | 39 | 41 | 47 | 31
1982-09-25 00:00:00 | 9 | 12 | 13 | 14 | 44 | 48 | 18
1982-10-02 00:00:00 | 4 | 14 | 18 | 40 | 43 | 44 | 5
1982-10-09 00:00:00 | 13 | 16 | 18 | 34 | 35 | 36 | 26
1982-10-16 00:00:00 | 11 | 23 | 25 | 28 | 29 | 36 | 27
1982-10-23 00:00:00 | 7 | 18 | 23 | 25 | 37 | 45 | 39
1982-10-30 00:00:00 | 11 | 18 | 19 | 31 | 37 | 45 | 41
1982-11-06 00:00:00 | 8 | 14 | 16 | 18 | 31 | 48 | 45
1982-11-13 00:00:00 | 4 | 11 | 23 | 24 | 25 | 45 | 41
1982-11-20 00:00:00 | 3 | 4 | 19 | 33 | 34 | 48 | 39
1982-11-27 00:00:00 | 5 | 17 | 21 | 28 | 30 | 43 | 36
1982-12-04 00:00:00 | 6 | 17 | 24 | 36 | 38 | 46 | 29
1982-12-11 00:00:00 | 4 | 9 | 10 | 11 | 43 | 46 | 3
1982-12-18 00:00:00 | 7 | 13 | 23 | 32 | 33 | 45 | 36
1982-12-25 00:00:00 | 11 | 18 | 22 | 28 | 35 | 37 | 42
1983-01-01 00:00:00 | 25 | 26 | 31 | 35 | 45 | 48 | 12
1983-01-08 00:00:00 | 11 | 19 | 25 | 31 | 32 | 36 | 44
1983-01-15 00:00:00 | 8 | 34 | 37 | 39 | 41 | 47 | 18
1983-01-22 00:00:00 | 5 | 10 | 30 | 35 | 36 | 45 | 13
1983-01-29 00:00:00 | 8 | 22 | 26 | 27 | 34 | 42 | 14
1983-02-05 00:00:00 | 3 | 5 | 6 | 33 | 38 | 39 | 8
1983-02-12 00:00:00 | 10 | 14 | 25 | 31 | 44 | 47 | 17
1983-02-19 00:00:00 | 11 | 13 | 15 | 16 | 24 | 31 | 9
1983-02-26 00:00:00 | 11 | 12 | 19 | 25 | 29 | 44 | 48
1983-03-05 00:00:00 | 2 | 7 | 21 | 22 | 30 | 33 | 3
1983-03-12 00:00:00 | 11 | 15 | 25 | 38 | 41 | 43 | 37
1983-03-19 00:00:00 | 2 | 10 | 11 | 31 | 43 | 49 | 29
1983-03-26 00:00:00 | 21 | 24 | 25 | 32 | 39 | 49 | 40
1983-04-02 00:00:00 | 4 | 10 | 23 | 38 | 41 | 46 | 43
1983-04-09 00:00:00 | 20 | 24 | 28 | 35 | 42 | 46 | 27
1983-04-16 00:00:00 | 1 | 3 | 19 | 31 | 32 | 47 | 37
1983-04-23 00:00:00 | 3 | 17 | 20 | 30 | 35 | 48 | 26
1983-04-30 00:00:00 | 18 | 26 | 29 | 35 | 36 | 49 | 25
1983-05-07 00:00:00 | 2 | 13 | 41 | 42 | 44 | 47 | 12
Spreadsheet: 860168d1708368487-remove-ap-team-rank-from-college-basketball-team-name-ncaab-college-basketball-scores-and-game-results
Sheet: Rank

Rank | Logo | Team | Pts | W/L
1 |  | UConn | 1509 | 2024-02-24 00:00:00
2 |  | Purdue | 1480 | 2024-03-23 00:00:00
3 |  | Houston | 1386 | 2024-03-22 00:00:00
4 |  | Marquette | 1273 | 2024-06-19 00:00:00
5 |  | Arizona | 1241 | 2024-05-20 00:00:00
6 |  | Kansas | 1227 | 2024-06-20 00:00:00
7 |  | North Carolina | 1216 | 2024-06-20 00:00:00
8 |  | Tennessee | 1033 | 2024-06-19 00:00:00
9 |  | Duke | 1025 | 2024-05-20 00:00:00
10 |  | Iowa State | 969 | 2024-05-20 00:00:00
11 |  | South Carolina | 921 | 2024-05-21 00:00:00
12 |  | Baylor | 811 | 2024-06-19 00:00:00
13 |  | Auburn | 799 | 2024-06-20 00:00:00
14 |  | Illinois | 728 | 2024-06-19 00:00:00
15 |  | Alabama | 618 | 2024-07-18 00:00:00
16 |  | Dayton | 425 | 2024-04-21 00:00:00
17 |  | Creighton | 410 | 2024-07-19 00:00:00
18 |  | [NAME] | 296 | 2024-06-21 00:00:00
19 |  | BYU | 294 | 2024-07-18 00:00:00
20 |  | Wisconsin | 249 | 2024-09-17 00:00:00
21 |  | Virginia | 218 | 2024-06-20 00:00:00
22 |  | Kentucky | 217 | 2024-07-18 00:00:00
23 |  | Indiana State | 209 | 2024-05-22 00:00:00
24 |  | Florida Atlantic | 206 | 2024-06-20 00:00:00
25 |  | Oklahoma | 178 | 2024-08-18 00:00:00
Spreadsheet: drew_fossum__8690__Gallup Modification Exh N
Sheet: FED & ST INCOME TAX

 |  |  |  |  |  |  |  |  |  |  |  | Page  7 of  7
Transwestern Pipeline Company
Estimated Federal and State Income Taxes
Line
No. |  | Description |  | Year   1 |  | Year  2 |  | Year  3 |  | Year  4 |  | Year  5
 |  |  |  | -1 |  | -2 |  | -3 |  | -4 |  | -5
1 |  | Revenue
2 |  | Operating Expenses
3 |  | Amortization Expenses
4 |  | Subtotal - Expenses
5 |  | Accounting Income Before Taxes
6 |  | State Income Tax  (7.01% of line 5)    1/
7 |  | Accounting Income Before Federal Income Taxes
8 |  | Federal Income Tax  (35.00% of line 7)
 |  | 1/   Transwestern's composite state income tax rate of 7.01% is the same rate  filed in its RP93-34 rate case.
Spreadsheet: 35069d1232573369-table-searching-problems-book1a
Sheet: Sheet10

Eyelet curtains
[NAME] sewn sides & hems, lined including 40mm eyelets
 |  | (2w) | (4w) | (6w) | (8w) | (10w)
 |  | 1 | 2 | 3 | 4 | 5
upto 125cm |  | 49.46 | 91.67 | 125.48 | 153.41 | 202.7
126cm to 200cm |  | 56.91 | 105.42 | 144.27 | 176.45 | 233.1
201cm to 400cm |  | 65.15 | 122.12 | 161.65 | 204.23 | 259.56
401cm and over |  | 76.23 | 138.97 | 175.4 | 234.57 | 297.05
[NAME] sewn sides & hems, lined including 40mm eyelets
 |  | (2w) | (4w) | (6w) | (8w) | (10w)
Lined |  | 1 | 2 | 3 | 4 | 5
upto 125cm |  | 59.9 | 106.52 | 155.98 | 201.76 | 257.25
126cm to 200cm |  | 68.93 | 122.48 | 179.24 | 232 | 295.84
201cm to 400cm |  | 78.8 | 142.12 | 207.17 | 269.69 | 341.88
401cm and over |  | 90.56 | 159.65 | 238.77 | 308.23 | 391.6
 |  | (2w) | (4w) | (6w) | (8w) | (10w)
Interlined |  | 1 | 2 | 3 | 4 | 5
upto 125cm |  | 82.7225 | 147.1025 | 215.3975 | 278.6175 | 355.25
126cm to 200cm |  | 95.19250000000001 | 169.1425 | 247.515 | 320.3775 | 408.5375
201cm to 400cm |  | 108.8225 | 196.2575 | 286.085 | 372.4325 | 472.12
401cm and over |  | 125.0625 | 220.4725 | 329.73 | 425.6475 | 540.7774999999999
Spreadsheet: 877973d1724918049-need-a-formula-for-counting-each-state-worked-in-then-for-each-state-i-need-a-tally-littlemack77-excel-example-formula-need-tms
Sheet: Sheet1

GRAINGER INVOICES |  |  |  |  |  |  |  |  | State Totals |  | AliGW
Invoice No. | HMT | Date | Purchased | Amount Spent | State
9208420589 | [NAME] | 2024-08-07 00:00:00 | 20 | 136.6 | CA |  |  |  | CA |  | 3111.6
9034589543 | Bud | 2024-08-06 00:00:00 | 125 | 1255 | TX |  |  |  | TX | 2 | 1391.6
9846573203 | [NAME] |  | 25 | 175 | CO |  |  |  | MT | 0
7895643213 | [NAME] |  | 222 | 2975 | CA |  |  |  | AL | 0
9875432103 | [NAME] | 2024-08-24 00:00:00 | 117 | 1775 | WA |  |  |  | ME | 0
8765904932 | Bud | 2024-08-12 00:00:00 | 20 | 136.6 | TX |  |  |  | WA | 1 | 1775
 |  |  |  |  |  |  |  |  | AZ | 0
 |  |  |  |  |  |  |  |  | NV | 0
 |  |  |  |  |  |  |  |  | MI | 0
 |  |  |  |  |  |  |  |  | CO | 1 | 175
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: EAST-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  NORTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2216 | -5218.68
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2216 | 5218.68
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99955 |  |  |  |  |  |  |  |  |  |  |  |  | 2216
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-East
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -200000 | 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
 |  | Financial Liquidations |  |  |  |  | 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
 |  | Originations |  |  |  |  | 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
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL