tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 144b8e05-0e10-43e9-8ce4-ef42e0f34835
Sheet: Complex Block Schedule

.
Return to Index Page
 |  | Complex Block Schedule
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 |  | Period 1 | Period 1 | Period 1 | Period 2 | Period 1
 |  | 49 | 49 | 90 | 90 | 49
 |  | Period 2 | Period 2 |  |  | Period 2
 |  | 48 | 48 | Period 3 | Seminar | 48
 |  | Period 3 | Period 3 | 90 | 90 | Period 3
 |  | 49 | 49 |  |  | 49
 |  | Period 4 | Period 4 | Period 5 | Period 4 | Period 4
 |  | 50 | 50 | 90 | 90 | 50
 |  | Period 5 | Period 5 |  |  | Period 5
 |  | 48 | 48 |  |  | 48
 |  | Period 6 | Period 6 | Period 7 | Period 6 | Period 6
 |  | 48 | 48 | 90 | 90 | 48
 |  | Period 7 | Period 7 |  |  | Period 7
 |  | 48 | 48 |  |  | 48
 |  | Using the schedule above the calculation of vocational seminar time is:
 |  | Seminar meets |  |  | 90 | minutes per week
 |  | Divide by 5 to get daily average |  |  |  | minutes per day
 |  | There are seven periods in a full schedule |  |  | 7 | periods per full time
 |  | Divide minutes per day to get daily minutes per period |  |  |  | minutes per period
 |  | Round time to whole minutes |  |  | 3 | minutes per period
 |  | Need to know enrollment on all vocational classes |  |  | 265 | kids enrolled in clases
 |  | except, DO NOT COUNT: OJT & IHT
 |  | multiply # kids by minutes per period
 |  | Total Minutes |  |  |  | minutes
 |  | The result is added to the minutes from all your approved vocational classes.
 |  | How much is this worth?
 |  | [NAME] to hours  (divide by  60) |  |  |  | hours
 |  | Vocational weighting formula (Hrs / 6 X .5) equals FTE |  |  |  | FTE
 |  | FTE times BSAPP ($3838 for FY14) |  |  |  | additional vocational funds
 | ***  Enrollment in all .5 funded classes except OJT & IHT
Spreadsheet: 734405d1622141914-possibly-need-multiple-vlookup-or-index-w-vlookup-excel-forum-example-two-way-lookup
Sheet: Data

Month | Emp ID | [NAME] | [NAME] | CPA$ | CPAI | PPA$ | PPA$ Num
Jan | A613595 | 267 | 11.83 | 0 | 0 | 0 | 0
Jan | A295879 | 1188 | 20.63 | 99.88 | 98.18 | 99.88 | 1398.34
Jan | A794209 | 579 | 13.76 | 100 | 100 | 100 | 0
Feb | A072145 | 621 | 13.13 | 0 | 0 | 0 | 0
Feb | A287813 | 1154 | 20.8 | 100 | 100 | 100 | 0
Feb | A287785 | 466 | 11.2 | 88.33 | 79.62 | 88.34 | 148556.39
Feb | A613811 | 1275 | 32.76 | 81.67 | 80 | 81.68 | 11985.54
Feb | A325201 | 475 | 12.96 | 93.62 | 66.66 | 93.62 | 4679.08
Feb | A613530 | 421 | 13.3 | 95.5 | 94.11 | 95.51 | 44436.63
Feb | A179264 | 288 | 13.3 | 99.66 | 96.66 | 99.67 | 3198
Feb | A613595 | 968 | 22.9 | 100 | 100 | 100 | 0
Feb | A295879 | 639 | 15.4 | 96.77 | 84 | 96.77 | 38256.35
Feb | A794209 | 372 | 11.06 | 100 | 100 | 100 | 0
Mar | A072145 | 1133 | 16.8 | 0 | 0 | 0 | 0
Mar | A287813 | 1447 | 21.63 | 100 | 100 | 100 | 0
Mar | A287785 | 645 | 12.33 | 96.21 | 71.42 | 96.21 | 48430.32
Mar | A613811 | 1108 | 27 | 100 | 100 | 100 | 0
Mar | A325201 | 608 | 16.46 | 100 | 100 | 100 | 0
Apr | A072145 | 1501 | 18.5 | 100 | 100 | 100 | 0
Apr | A287813 | 1423 | 18.13 | 100 | 100 | 100 | 0
Apr | A072145 | 1501 | 18.5 | 100 | 100 | 100 | 0
Apr | A287813 | 1423 | 18.13 | 100 | 100 | 100 | 0
Apr | A377643 | 1968 | 18.43 | 100 | 100 | 100 | 0
Apr | A287785 | 531 | 11.86 | 97.92 | 88.63 | 97.92 | 18076.52
Apr | A613811 | 1495 | 35.63 | 100 | 100 | 100 | 0
Apr | A462621 | 172 | 2.91 | 0 | 0 | 0 | 0
Apr | A325201 | 924 | 17.56 | 100 | 100 | 100 | 0
Apr | A378293 | 2199 | 12.37 | 0 | 0 | 0 | 0
Apr | A613283 | 785 | 18.36 | 31.57 | 20 | 31.57 | 141030.96
Apr | A613530 | 697 | 14.6 | 100 | 100 | 100 | 0
Apr | A179264 | 515 | 14.2 | 100 | 100 | 100 | 0
Apr | A613595 | 1107 | 25.03 | 0 | 0 | 0 | 0
Apr | A458561 | 88 | 0.98 | 0 | 0 | 0 | 0
Apr | A295879 | 1197 | 19.26 | 97.84 | 90.47 | 97.85 | 29658.52
Apr | A794209 | 483 | 11.6 | 100 | 100 | 100 | 0
Apr
Spreadsheet: 85bd393d-5992-4713-be53-4467b513ff48
Sheet: Sheet1

Release: International Financial Statistics | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=239
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-06-20 2:16 AM [NAME]
 | Real-Time | Period
Name: | Start | End
International Financial Statistics | 2011-10-13 00:00:00 | Current
Link:
http://www.imf.org/external/data.htm | 2011-10-13 00:00:00 | Current
Source:
International Monetary Fund | 2011-10-13 00:00:00 | Current
Notes:
The International Financial Statistics (IFS) consist of approximately | 2011-10-13 00:00:00 | Current
32,000 time series covering more than 200 countries starting in 1948.
Includes exchange rates, Fund accounts and the main global and country
economic indicators.
The IMF does not make this data available to the public free of charge
on its website.  The Federal Reserve Bank of St. Louis has been given
permission by the IMF to publish a limited number of IFS time series.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-10-13 00:00:00
2012-02-08 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-06-29 00:00:00
2012-08-02 00:00:00
2012-09-04 00:00:00
2012-10-01 00:00:00
2012-11-15 00:00:00
2012-12-03 00:00:00
2013-01-02 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-03 00:00:00
Spreadsheet: 781975d1653661613-vlookup-cant-find-data-for-only-some-rows-soft-skills-record-no-data-
Sheet: QADets Full

Cohort | FullName | EmailAddress | MobileNumber | Address | ZipCode | Registered On | City | IsGdprApproved | CurrentProgressStatus | Job Title | Gender | User Assigned | Start Date | Intro | 1st | 2nd | In Person
Spreadsheet: 147299d1332706942-excel-2003-drop-down-bar-auto-fill-another-cell-part-2-invoices
Sheet: Sheet1

 |  |  |  |  |  | Fishing |  |  |  |  | Homeware
 |  | Invoice Month | Spend | Department |  | Month | Total Spend Per Month | Budget | Allowance |  | Month | Total Spend Per Month | Budget | Allowance
January |  | January | 1000 |  |  | January | 6000 | 10000 | 4000 |  | January |  | 10000 | 10000
February |  | January | 1000 |  |  | February | 3200 | 10000 | 6800 |  | February |  | 10000 | 10000
March |  | January | 1000 |  |  | March | 4878 | 10000 | 5122 |  | March |  | 10000 | 10000
April |  | February | 2000 |  |  | April | 1000 | 10000 | 9000 |  | April |  | 10000 | 10000
May |  | March | 2300 |  |  | May | 3425 | 10000 | 6575 |  | May |  | 10000 | 10000
June |  | February | 1200 |  |  | June | 3764 | 10000 | 6236 |  | June |  | 10000 | 10000
July |  | April | 1000 |  |  | July | 2340 | 10000 | 7660 |  | July |  | 10000 | 10000
August |  | January | 3000 |  |  | August | 1000 | 10000 | 9000 |  | August |  | 10000 | 10000
September |  | August | 1000 |  |  | September | 2357 | 10000 | 7643 |  | September |  | 10000 | 10000
October |  | December | 123 |  |  | October | 15124 | 10000 | -5124 |  | October |  | 10000 | 10000
November |  | June | 2999 |  |  | November | 4666 | 10000 | 5334 |  | November |  | 10000 | 10000
December |  | July | 2340 |  |  | December | 1179 | 10000 | 8821 |  | December |  | 10000 | 10000
 |  | October | 7650
Fishing |  | December | 1000 |  |  | Shooting
Shooting |  | November | 100 |  |  | Month | Total Spend Per Month | Budget | Allowance
Homeware |  | November | 4566 |  |  | January |  | 10000 | 10000 |  | from the help given before I am able to populate column H. if I add another factor in such a department. How do I populate only the relevant department and that months department????
 |  | May | 3225 |  |  | February |  | 10000 | 10000
 |  | March | 2578 |  |  | March |  | 10000 | 10000
 |  | May | 100 |  |  | April |  | 10000 | 10000
 |  | May | 100 |  |  | May |  | 10000 | 10000
 |  | October | 7474 |  |  | June |  | 10000 | 10000
 |  | September | 2357 |  |  | July |  | 10000 | 10000
 |  | June | 765 |  |  | August |  | 10000 | 10000
 |  | December | 56 |  |  | September |  | 10000 | 10000
 |  |  |  |  |  | October |  | 10000 | 10000
 |  |  |  |  |  | November |  | 10000 | 10000
 |  |  |  |  |  | December |  | 10000 | 10000
Spreadsheet: 679687d1590583669-match-a-number-to-the-left-of-a-name-across-multiple-arrays-example-list
Sheet: Names

Name | Order #
Adam | 1
[NAME] | 2
[NAME] | 3
[NAME] | 4
[NAME] | 5
[NAME]
George
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Mark
Nathan
Ozzie
[NAME]
Quinn
Rodger
[NAME]
[NAME]
Umberto | 6
Victor
Walter
Xander
Spreadsheet: 872158d1718539165-dropdown-list-that-changes-based-off-table-contents-tv-points-aligw
Sheet: Sheet1

 |  |  | TV POINTS |  |  |  | MODEL
 |  |  | 2024 TORNADO | 2024 DISTINCTION | 2024 TRACTION |  | 2024 TORNADO
MODEL | 2024 TORNADO |  | MAIN TV & EXT POINT | MAIN TV & EXT ENTERTAINMENT HATCH | MAIN TV & EXT ENTERTAINMENT HATCH |  | 2024 DISTINCTION
FLOOR PLAN | 22' RD REAR CLUB LOUNGE |  | MAIN TV & EXT ENTERTAINMENT HATCH | MAIN TV & EXT ENTERTAINMENT HATCH & BEDROOM | MAIN TV & EXT ENTERTAINMENT HATCH & BEDROOM |  | 2024 TRACTION
TV POINTS | MAIN TV & EXT POINT |  | MAIN TV & EXT POINT & BEDROOM
 |  |  | MAIN TV & EXT ENTERTAINMENT HATCH & BEDROOM |  |  |  | FLOOR PLAN
 |  |  |  |  |  |  | 18'6 MD
 |  |  | 2024 TORNADO |  |  |  | 18'6 MD REVERSED KITCHEN
 |  |  |  |  |  |  | 19'6 ANGLED KITCHEN
 |  |  |  |  |  |  | 20' RD STRAIGHT KITCHEN
 |  |  |  |  |  |  | 20' MD ANGLED KITCHEN
 |  |  |  |  |  |  | 20'RD ANGLED KITCHEN
 |  |  |  |  |  |  | 20'6 MD BIG BATHROOM
 |  |  |  |  |  |  | 20'6 RD
 |  |  |  |  |  |  | 21' MD SIDE CLUB LOUNGE
 |  |  |  |  |  |  | 21'6 MD BIG BATHROOM
 |  |  |  |  |  |  | 22' MD SIDE CLUB LOUNGE
 |  |  |  |  |  |  | 22' RD REAR CLUB LOUNGE
 |  |  |  |  |  |  | 19'6 MD EAST WEST FAMILY VAN
 |  |  |  |  |  |  | 20'6 MD EAST WEST FAMILY VAN
 |  |  |  |  |  |  | 21' MD FAMILY VAN
 |  |  |  |  |  |  | 21'6 MD REVERSED KITCHEN FAMILY VAN
 |  |  |  |  |  |  | 22' MD FAMILY VAN
 |  |  |  |  |  |  | 22' MD REVERSED KITCHEN FAMILY VAN
Spreadsheet: 865585d1712650673-adding-merging-a-formula-with-an-existing-formula-to-capture-2-conditions-pay-calculator_2024_rev-04_forum-version
Sheet: 76Hr Build-Up Time

80
DATE | DAY | SHIFT [NAME] |  |  |  | NORMAL TIME                                             (After ADO Deduction) | ADO | RDO | PUBLIC HOLIDAY | SICK DAY - NO PAY | SICK DAY | ANNUAL LEAVE | DAY OFF - NO PAY | CUMULATIVE TIME | BALANCE |  | HOURS PAID BY EMPLOYER
WEEK 1
 |  |  |  |  | 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
WEEK 2
 |  |  |  |  | 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL FOR THE PAY PERIOD:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AMOUNT (Hrs) DUE IF LESS THAN 76hrs :
Spreadsheet: 93374904-6b64-4a74-98df-117d983a631f
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
fold change values
ChIP | clone | figure | primer
 |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P
HP1 | XVI. | Fig. 3a | 1.829767190902308 | 1.728915448514633 | 2.170582798484359 | 1.816688852579305 | 1.813796834884541 | 2.357987454264725 | 1.987104945867841 | 1.895542418845781
H3K9me3 | XVI. | Fig. 3a | 0.8829572057190077 | 1.169774996645917 | 2.049284927839644 | 2.159065349819983 | 2.528678292511957 | 2.985383005960758 | 5.260195839057237 | 7.601825701742539
HP1 | I. | Fig. 3b | 3.572688760489651 | 4.870009292442391 | 11.06601476458381 | 9.044447085428407 | 10.39463676663673 | 8.999819993486474 | 7.920331118255923
H3K9me3 | I. | Fig. 3b | 19.90898271227178 | 6.531004392499144 | 6.285701430684725 | 4.344012229529602 | 4.58557153595078 | 5.22795142042319 | 5.101645575492748
HP1 | IX. | Fig. [NAME] | 1.140137436797103 | 2.151005130446792 | 2.10413586649083 | 1.637732212891749
H3K9me3 | IX. | Fig. [NAME] | 3.062031598102806 | 4.693377537799426 | 4.81257333448894 | 4.837667647667321
HP1 | XI. | Fig. S5 | 2.291683196184131 | 2.167934900347951 | 2.118688966174858 | 1.741387002507013 | N.A. | 1.471300668444309 | 1.196382111598959 | 1.646940247977577 | 1.815566659108643 | 1.700053375518134 | 1.263909458336902 | 1.02115814672079 | 1.46878738835665 | 1.587381951737703 | 2.013768361747282 | 1.526221961518976
H3K9me3 | XI. | Fig. S5 | 15.58790722109933 | 4.932203393177939 | 3.814931515703366 | 1.354486923793707 | N.A. | 0.9673764769875874 | 0.9872343259943913 | 2.171304124814465 | 3.610475796223521 | 3.633285707844119 | 1.127086981220829 | 1.078122775780773 | 1.349999797882766 | 2.949365334214853 | 6.814432981017321 | 1.19922077849641
H3acetylation | XVI. | Fig. 2a | 0.0493358720805839
H3acetylation | I. | Fig. 2a | 0.468426788919231
H3acetylation | XI. | Fig. 2a | 0.434007939000541
H3acetylation | IX. | Fig. 2a | 0.208698182929767
H3K9me3 | XVI. | Fig. 2b | 0.9
H3K9me3 | I. | Fig. 2b | 19.9
H3K9me3 | XI. | Fig. 2b | 15.6
H3K9me3 | IX. | Fig. 2b | 3.1
H3 | XVI. | Fig. 2c | 0.6372195740683937
H3 | I. | Fig. 2c | 1.075711723167782
H3 | XI. | Fig. 2c | 2.139726935824104
H3 | IX. | Fig. 2c | 1.362630230416276
Pol II | XVI. | Fig. 2d | -0.0366338049380854
Pol II | I. | Fig. 2d | 0.320478751695274
Pol II | XI. | Fig. 2d | 0.400415924741171
Pol II | IX. | Fig. 2d | 0.322810601480745
Spreadsheet: 0c85f177-4004-419f-ab75-a1004683a0b2
Sheet: Sheet1

Weighted Average Calculation for NonExempt Employee Teaching/Working Second Job (earning two different rates) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
KCTCS Human Resources Procedure #17 –  “Supplemental Assignment”
1. 1a) “Internal Faculty Overload” / (1b) "Working Second Job" - The FLSA Act requires a NonExempt employee paid at two or more different rates during the same work week by the same employer for doing two or more different jobs (such as a primary duty full-time Administrative Assistant also teaching any type of a KCTCS class, except VLI); or (1b) a primary duty full-time [NAME] also working occasionally as a Security Guard earning two different rates).
Process Description |  |  |  | [NAME]
Week 1
Total regular hours week 1 x regular hourly rate: |  |  |  | 0 | x | 0 | = | 0 | A
Total hours Teaching/Working Second Job x Rate: |  |  |  | 0 | x | 0 | = | 0
 |  |  |  | 0 | Total Hours |  |  | 0 | Total Amount
Total Amount/Total Hours = Average Hrly Rate: |  |  |  | 0 | / | 0 | = |  | Average Hrly Rate
Total Hours - 40hrs = Hours Over 40: |  |  |  | 0 | - | 40 | = | -40 | Hours Over 40
Average Hrly Rate / 2  = (1/2 Hrly Rate): |  |  |  |  | / | 2 | = |  | 1/2 Hrly Rate
1/2 Hrly Rate x Hours Over 40 = OT Amount: |  |  |  |  | x | 0 | = |  | OT Amount
OT Amount + Total Amount = Wages for Week 1: |  |  |  |  | + | 0 | = |  | Wages for Week 1
Week 2
Total regular hours week 2 x regular hourly rate: |  |  |  | 0 | x | 0 | = | 0 | B
Total hours Teaching/Working Second Job x Rate: |  |  |  | 0 | x | 0 | = | 0
 |  |  |  | 0 | Total Hours |  |  | 0 | Total Amount
Total Amount/Total Hours = Average Hrly Rate: |  |  |  | 0 | / | 0 | = |  | Average Hrly Rate
Total Hours - 40hrs = Hours Over 40: |  |  |  | 0 | - | 40 | = | -40 | Hours Over 40
Average Hrly Rate / 2 = (1/2 Hrly Rate): |  |  |  |  | / | 2 | = |  | 1/2 Hrly Rate
1/2 Hrly Rate x Hours Over 40 = OT Amount: |  |  |  |  | x | 0 | = |  | OT Amount
OT Amount + Total Amount = Wages for Week 1: |  |  |  |  | + | 0 | = |  | Wages for Week 2
Wages Week 1 + Wages Week 2 = Total Wages: |  |  |  |  | + |  | = |  | Total Wages
Total Wages - (Week 1A + Week 2B) = Adjustment |  |  |  |  | - | 0 | = |  | Adj. for Paycheck
For: |  | Acct#: |  | Pay Period: |  |  |  | Completed By:
Spreadsheet: 242f0739-e600-4910-aba8-85d157780db3
Sheet: phase2_but_exempt

Phase II Entities Exempted/Waived from MS4 Permit
Last revised 7/20/2010
COMMUNITY | [NAME]
Alamance | Phase II city (Exempt)
[NAME] | Phase II city (Exempt)
Bethania | Phase II city (Exempt)
Claremont | Phase II city (Exempt)
Connelly Springs | Phase II city (Exempt)
Drexel | Phase II city (Exempt)
Flat Rock | Phase II city (Exempt)
[NAME] | Phase II city (Exempt)
Hildebran | Phase II city (Exempt)
King | Phase II city (Exempt)
Long View | Phase II city (Exempt)
McAdenville | Phase II city (Exempt)
Oak Ridge | Phase II city (Exempt)
Pleasant Garden | Phase II city (Exempt)
Rhodhiss | Phase II city (Exempt)
Rural Hall | Phase II city (Exempt)
[NAME] | Phase II city (Exempt)
Stanley | Phase II city (Exempt)
Summerfield | Phase II city (Exempt)
[NAME] | Phase II city (Exempt)
Walkertown | Phase II city (Exempt)
Weddington | Phase II city (Exempt)
Wesley Chapel | Phase II city (Exempt)
Youngsville | Phase II city (Exempt)
Spreadsheet: 329767d1404400876-formula-in-column-only-on-visible-cells-dynamic-referencing-konfis-v1
Sheet: Sheet1

ID | Num | Date | Dif
i1 | 11 | Date1
i1 | 12 | Date2
i1 | 13 | Date3
i3 | 20 | [NAME]
i3 | 21 | Date5
i5 | 41 | Date6
Spreadsheet: 825333d1681251067-vlookup-2-sheets-test-2023
Sheet: Sheet2

DOCTOR | WHO | ADDRESS | [NAME]
BICKERTON | ART | NONE | 4
BLOOMSTEIN | ART | NONE | 3
BOAK | ART | NONE | 4
DEITCH | ART | NONE | 3
HALL | ART | NONE | 4
[NAME] | ART | NONE | 4
KRISTAN | ART | NONE | 4
LABCORP | ART | NONE | 4
MACDONALD | ART | NONE | 4
[NAME] | ART | NONE | 4
ORAM | ART | NONE | 2
RIVERVIEW HOSPITAL | ART | NONE | 3
ROMELLO | ART | NONE | 3
SAKY | ART | NONE | 10
SCHER | ART | NONE | 4
SHAH | ART | NONE | 5
[NAME] | ART | NONE | 4
SPORTSCARE | ART | NONE | 3
TWIN BORO | ART | NONE | 2
VLAHOS | ART | NONE | 5
WANG | ART | NONE | 30
Spreadsheet: 779836d1652132285-question-on-averages-book1
Sheet: Sheet1

40
50
30
50
60 |  | (average is 48)
70
50
40
50
60
50
69
48
89
70
50
Spreadsheet: andy_zipper__112__mODEL 3 7 01 Base
Sheet: Gas

Gas
 |  | Transactions EOL          Life-to-Date
Large Companies
 | Coral Energy Resources, L.P
 | Tenaska Marketing Ventures | 4120
 | ONEOK Energy Marketing and Trading Co
 | BP Energy Company | 3415
 | EnergyUSA-TPC Corp. | 3049
 | PanCanadian Energy Services, Inc. | 2565
 | TXU Energy Trading Company | 2473
Medium Companies
 | Western Gas Resources, Inc. | 2197
 | Adams Resources Marketing, Ltd. | 1720
 | Cibola Energy Services Corporation | 1643
 | Anadarko Energy Services Company | 1613
 | Enron Energy Services, Inc. | 1605
 | CMS Marketing, Services and Trading Co. | 1436
 | NJR Energy Services Company | 1380
 | Marathon Oil Company | 1185
 | Cornerstone Propane, L.P. | 1173
 | Occidental Energy Marketing, Inc. | 1123
 | Cinergy Marketing & Trading, LLC | 1032
 | WPS Energy Services, Inc. | 998
 | Conoco Inc. | 875
 | Tractebel Energy Marketing, Inc. | 825
 | Coral Energy Holding, L.P. | 822
 | Barrett Resources Corporation | 772
 | Equitable Energy L.L.C. | 657
 | Duke Energy Marketing Limited Partnership | 650
 | NUI Energy Brokers, Inc. | 646
 | Richardson Products II, Ltd. | 605
 | Clinton Energy Management Services, Inc. | 576
 | Mieco, Inc. | 546
 | TXU Energy Trading Canada Limited | 517
 | Consolidated Edison Solutions, Inc. | 489
 | Burlington Resources Trading Inc. | 419
 | Cargill Energy | 419
 | Ashland Specialty Chemicals Company | 414
 | Keyspan Energy Services, Inc. | 392
 | [NAME] | 0
Total Target Company Transactions:
Total Enron Gas Trading Transactions: |  | 219059
Projected Penetration for transactions:
Number of Companies targeted: |  | 36
Total Enron Gas Trading Customers: |  | 214
Projected Penetration for customers:
Spreadsheet: 848099d1698893195-income-tax-return-period-calculation-tax-period-calculate-esaji-
Sheet: Sheet2

Date-bank | date formated | income Tax period | Month of year | Period |  | Start Date | Tax Year | Period
02/04/2022 |  |  |  |  |  | 2021-07-01 00:00:00 | 2021-2022 | Previous Year
07/04/2022 |  |  |  |  |  | 2022-07-01 00:00:00 | 2022-2023 | Current Year
10/04/2022 |  |  |  |  |  | 2023-07-01 00:00:00 | 2023-2024 | Next Year
18/04/2022
22/04/2022
22/04/2022
24/04/2022
28/04/2022
28/04/2022
28/04/2022
28/04/2022
03/05/2022
05/05/2022
08/05/2022
13/05/2022
15/05/2022
18/05/2022
23/05/2022
24/05/2022
25/05/2022
26/05/2022
27/05/2022
28/05/2022
29/05/2022
30/05/2022
30/05/2022
07/06/2022
11/06/2022
17/06/2022
20/06/2022
22/06/2022
25/06/2022
01/07/2022
01/07/2022
06/07/2022
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
09/07/2022
12/07/2022
26/07/2022
01/08/2022
01/08/2022
03/08/2022
10/08/2022
11/08/2022
13/08/2022
19/08/2022
23/08/2022
30/08/2022
06/09/2022
06/09/2022
11/09/2022
17/09/2022
29/09/2022
29/09/2022
29/09/2022
01/10/2022
04/10/2022
12/10/2022
12/10/2022
14/10/2022
17/10/2022
25/10/2022
01/11/2022
01/11/2022
01/11/2022
02/11/2022
04/11/2022
05/11/2022
12/11/2022
17/11/2022
19/11/2022
28/11/2022
28/11/2022
01/12/2022
11/12/2022
13/12/2022
18/12/2022
[NAME]
[NAME]
29/12/2022
29/12/2022
29/12/2022
07/01/2023
15/01/2023
19/01/2023
19/01/2023
21/01/2023
26/01/2023
27/01/2023
05/02/2023
05/02/2023
06/02/2023
07/02/2023
07/02/2023
09/02/2023
12/02/2023
13/02/2023
18/02/2023
03/03/2023
03/03/2023
05/03/2023
11/03/2023
13/03/2023
26/03/2023
26/03/2023
27/03/2023
04/04/2023
04/04/2023
04/04/2023
05/04/2023
06/04/2023
06/04/2023
08/04/2023
15/04/2023
15/04/2023
15/04/2023
15/04/2023
18/04/2023
21/04/2023
26/04/2023
29/04/2023
06/05/2023
18/05/2023
22/05/2023
05/06/2023
11/06/2023
11/06/2023
[NAME]
18/06/2023
19/06/2023
20/06/2023
22/06/2023
24/06/2023
26/06/2023
27/06/2023
27/06/2023
27/06/2023
30/06/2023
06/07/2023
12/07/2023
15/07/2023
26/07/2023
26/07/2023
28/07/2023
12/08/2023
16/08/2023
23/08/2023
05/09/2023
06/09/2023
07/09/2023
19/09/2023
21/09/2023
21/09/2023
28/09/2023
02/10/2023
11/10/2023
13/10/2023
24/10/2023
Spreadsheet: 3df5df53-5ff1-41d3-8271-aadd874e2f22
Sheet: Pre-bid Sheet

Name | Company | Phone | E-Mail
[NAME] | Rosendin Elect. | [PHONE] | [EMAIL]
[NAME] | Kingdom Pipelines | [PHONE] | [EMAIL]
[NAME] | O'Grady Paving Inc. | [PHONE] | [EMAIL]
[NAME] | Sonnikson & Stordahl | [PHONE] | [EMAIL]
[NAME] | Spiess Construction | [PHONE] | [EMAIL]
[NAME] | Lewis & Tibbits Inc. | [PHONE] | [EMAIL]
[NAME] | [NAME] | [PHONE] | [EMAIL]/[EMAIL]
[NAME] | [NAME] | [PHONE] | [EMAIL]
[NAME] | [NAME] | [PHONE] | [EMAIL]
[NAME] | CSC Water | [PHONE] | [EMAIL]
[NAME] | CSC Water | [PHONE] | [EMAIL]
[NAME] | CSC Water | [PHONE] | [EMAIL]
[NAME] | CSC Water | [PHONE] | [EMAIL]
[NAME] | GHD | [PHONE] | [EMAIL]
[NAME] | CSC Water | [PHONE] | [EMAIL]
NOTE:  Speiss Construction requested to be removed from this list, so please do not contact
them for any inquiries on the Northside Tanks Site Improvements Project (WA 30148).