tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kim_ward__20771__RFP_loadprofiles_193_151_202_141_113_110
Sheet: Proposal D_202

Proposal D - Hayes Lemmerz International Inc./North American Wheels Division
Please submit your response to this RFP by completing and returning this sheet.
Marketing Company:
Marketing Rep:
Date:
Accounts: | La Mirada, CA
Term #1: | April 1, 2001 - March 31, 2002
Term #2: | April 1, 2001 - March 31, 2003
Price #1: | NGI "Southern California Border Average"______________________________
 | The monthly volume invoiced by [NAME] will equal metered usage grossed up
 | for interstate pipeline and utility fuel loss.
 | Bid good through
Price #2: | NGI "Southern California Border Average"______________________________
 | The monthly volume invoiced by [NAME] will equal metered usage and will
 | include the cost of interstate pipeline and utility fuel loss.
 | Bid good through
Volume: | Full Requirements |  |  |  |  |  |  | Yes     or      No
Delivery Point: | Southern California Border |  |  |  |  |  |  | Yes     or     No
Transportation: | Primary firm, non-recallable |  |  |  |  |  |  | Yes     or     No
Nominations & | [NAME] will be responsible for utility nominations and associated balancing.
Balancing | [NAME] will make nominations based on historical usage.  [NAME] will notify
 | Buyer of any periods of daily balancing and/or other operational flow orders,
 | which may cause penalties.  [NAME] will indemnify [NAME] against any
 | penalties that occur due to non-performance by [NAME]. |  |  |  |  |  |  | Yes     or     No
Required Contract: | Seller agrees to utilitze [NAME]'s Base Sales Agreement and applicable
 | Exhibits.  [NAME] has reviewed this contract and has submitted all requested |  |  |  |  |  |  | Yes     or     No
 | changes for consideration.
Credit: | All credit arrangements and contractual agreements will be between [NAME]
 | and [NAME]. |  |  |  |  |  |  | Yes     or     No
Other: | Buyer reserves the right to fix a price based on current market conditions
 | for a portion of volumes up to 100% requirements.
 | At any time during the term of this Agreement, [NAME] will fix the cost of
 | commodity and/or basis for any month(s) per [NAME]’s request at no additional
 | cost. |  |  |  |  |  |  | Yes     or     No
Comments:
Spreadsheet: 842981d1694961463-using-textsplit-with-map-and-lambda-is-not-working-map-textsplit
Sheet: Sortert etter enhetsnr

 |  |  | Textsplit |  |  | [NAME]
 | 2r 37m2 |  |  | 37m2 |  |  | 37m2
 | 2r 49m2
 | 2r 50m2
 | 2r 51m2
 | 2r 58m2
 | 3r 81m2 |  | 2r
 | 4r 101m2 |  | 2r
 | 4r 89m2 |  | 2r
 | 4r 94m2 |  | 2r
 | 4r 96m2 |  | 3r
 | 4r 97m2 |  | 4r
 | 5r 102m2 |  | 4r
 | 5r 104m2 |  | 4r
 |  |  | 4r
 |  |  | 4r
 |  |  | 5r
 |  |  | 5r
Spreadsheet: 38e5d012-5ebe-4644-802c-a1617bcd7583
Sheet: Results

Results Wed 24th
Men's & Women's
Black Mountain Bears | 10 | def | ANZ | 2
PLC | 2 | def by | NEGS Ninjas | 1
Sisters | 6 | def by | [NAME] | 1
RossBuild | 6 | def by | High Velocity | 3
SportsUNE | 6 | def | [NAME] It | 4
[NAME] | 13 | def | [NAME] Plumbing | 1
A touch of all stars | 5 | def | Oh What a feeling | 3
The Blur | 3 | def by | Gladiators | 6
[NAME] | 5 | def | Turn it up | 8
Brothers | 9 | def | Clontarf Brumbies | 4
Thursaday 25th
Mixed
The Parmies | 5 | def | T Birds & pink Ladies | 4
[NAME] | 7 | def | The Goers | 4
Imperial invincibles | 4 | def | We Not Fit | 6
The Royal | 7 | drew | Green monkeys | 6
Low Velocity | 7 | def by | Mix-A-Rabbit | 4
[NAME] | 7 | def by | Tooheys | 10
Blue Steel | 7 | def | Maccas | 8
[NAME] | 12 | def by | Roberts & morrow | 3
Bullfrogs | 2 | def | [NAME] $7 Snitzels | 6
Impies Select | 1 | def by | Tropics | 10
GrazAg | 11 | def by | [NAME] | 5
Rage | 3 | def | Imperial Impacts | 3
Marble hill magic | 8 | def | The Comets | 9
Spreadsheet: 735370d1622905985-auto-populate-field-for-whole-year-based-on-2-criterias-of-t-f-and-name-impossible-example-file
Sheet: input

Name | Date Changed | Old Value | New Value |  |  |  | This page is the raw data and it would come in this format.
T001 | 2021-01-07 00:00:00 | T | F |  |  |  | Trying to recognise by [NAME] and when date changed from either T  - F or F - T
T001 | 2021-01-22 00:00:00 | F | T |  |  |  | Populate dates for all 365 days in the year depending on this
T001 | 2021-02-22 00:00:00 | T | F |  |  |  | there is no start date or end date by Name in this report so 01/01/2021 or 31/12/2021
T003 | 2021-01-07 00:00:00 | T | F |  |  |  | I was thinking there would need to be something that breaks this datat down into another sheet
T003 | 2021-01-20 00:00:00 | F | T |  |  |  | by name and use index match for each section
T003 | 2021-02-22 00:00:00 | T | F |  |  |  | Output sheet is the one that needs to be populated in that format however is very manual
T005 | 2021-02-03 00:00:00 | T | F
T005 | 2021-02-08 00:00:00 | F | T
T005 | 2021-02-22 00:00:00 | T | F
T007 | 2021-01-07 00:00:00 | T | F
T007 | 2021-01-08 00:00:00 | F | T
T007 | 2021-02-22 00:00:00 | T | F
T013 | 2021-01-07 00:00:00 | T | F
Spreadsheet: 89789d1289516884-auto-populate-test
Sheet: Source

Company | Date | Qty | Pepsi | Coke | Sprite | DR Pepper | [NAME] | MR Pib | Aquafina | Gatorade
Company A | 2010-11-05 00:00:00 | 5 | x |  |  |  | x |  | x
Company B | 2010-11-05 00:00:00 | 4 |  |  |  | x
Company C | 2010-11-06 00:00:00 | 3 |  |  | x
Company D | 2010-11-07 00:00:00 | 2 |  |  |  |  | x
Company E | 2010-11-08 00:00:00 | 1
Spreadsheet: 130417d1322270160-converting-text-in-a-schedule-to-a-date-wo
Sheet: WO DEC

 |  |  |  |  |  |  |  | 2011-12-01 00:00:00 | 2011-12-02 00:00:00 | 2011-12-03 00:00:00 | 2011-12-04 00:00:00 | 2011-12-05 00:00:00 | 2011-12-06 00:00:00 | 2011-12-07 00:00:00 | 2011-12-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-10 00:00:00 | 2011-12-11 00:00:00 | 2011-12-12 00:00:00 | 2011-12-13 00:00:00 | 2011-12-14 00:00:00 | 2011-12-15 00:00:00 | 2011-12-16 00:00:00 | 2011-12-17 00:00:00 | 2011-12-18 00:00:00 | 2011-12-19 00:00:00 | 2011-12-20 00:00:00 | 2011-12-21 00:00:00 | 2011-12-22 00:00:00 | 2011-12-23 00:00:00 | 2011-12-24 00:00:00 | 2011-12-25 00:00:00 | 2011-12-26 00:00:00 | 2011-12-27 00:00:00 | 2011-12-28 00:00:00 | 2011-12-29 00:00:00 | 2011-12-30 00:00:00 | 2012-01-01 00:00:00
Base 1 | EMP # | SEN # | CONTACT # | CONTACT # ALT | LAST WO | WO LIST |  | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
 |  |  |  |  |  | YES | NO | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
EMP 1 | 1111 | 111 |  |  |  |  | X
EMP 2 | 1221 | 122 |  |  |  | X
EMP 3 | 1331 | 133 |  |  |  | X
EMP 4 | 1441 | 144 |  |  |  | X
Base 2 | EMP # | SEN # | CONTACT # | CONTACT # ALT | LAST WO | WO LIST |  | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
 |  |  |  |  |  | YES | NO | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
EMP 5 | 1551 | 155 |  |  |  | X
EMP 6 | 1661 | 166 |  |  |  |  | X
EMP 7 | 1771 | 177 |  |  |  | X
EMP 8 | 1881 | 188 |  |  |  | X
Base 3 | EMP # | SEN # | CONTACT # | CONTACT # ALT | LAST WO | WO LIST |  | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
 |  |  |  |  |  | YES | NO | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
EMP 9 | 1991 | 199 |  |  |  | X
EMP 10 | 2112 | 211 |  |  |  | X
EMP 11 | 2222 | 222 |  |  |  | X
EMP 12 | 2332 | 233 |  |  |  | X
Base 3 | EMP # | SEN # | CONTACT # | CONTACT # ALT | LAST WO | WO LIST |  | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
 |  |  |  |  |  | YES | NO | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Spreadsheet: 215479d1361389574-formula-that-can-count-number-of-orders-booked-on-a-date-ignoring-duplicates-test
Sheet: Sheet2

 | Order | Ship By
 | 17752 | 2012-08-01 00:00:00
 | 17752 | 2012-08-01 00:00:00
 | 17752 | 2012-08-01 00:00:00
 | 17772 | 2012-09-20 00:00:00
 | 17773 | 2012-12-27 00:00:00
 | 17773 | 2012-12-27 00:00:00
 | 17773 | 2012-12-27 00:00:00
 | 17725 | 2012-12-27 00:00:00
 | 17774 | 2012-10-19 00:00:00
 | 17775 | 2012-11-21 00:00:00
 | 17775 | 2012-11-21 00:00:00
 | 17775 | 2012-11-21 00:00:00
 | 17775 | 2012-11-21 00:00:00
 | 17781 | 2012-11-21 00:00:00
 | 17776 | 2012-11-07 00:00:00
 | 17776 | 2012-11-07 00:00:00
 | 17776 | 2012-11-07 00:00:00
 | 17778 | 2012-11-27 00:00:00
 | 17779 | 2012-11-14 00:00:00
Spreadsheet: 4b21f7e0-e782-435d-aab5-7e4b54907df9
Sheet: San Benito COE

REGIONAL DIRECTORY 2014/2015
SAN BENITO COUNTY OFFICE OF EDUCATION/SAN ANDREAS
[NAME], Superintendent | [NAME], San Andreas, Santa Ana Principal | [NAME], Fiscal Officer
460 Fifth Street | 191 Alvarado Street | 460 Fifth Street
Hollister, CA 95023 | Hollister, CA 95023 | Hollister, CA 95023
O: [PHONE] x127 | O:[PHONE] X201 | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
Elida Rodriguez, PASS/OSY, Community & Family Services Specialist | [NAME], SBC Accountant
191 Alvarado Street | 460 Fifth Street
Hollister, CA 95023 | Hollister, CA 95023
O: [PHONE] x211 | O: [PHONE] X 123
F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL]
Spreadsheet: 70288c4a-6a4a-4ff3-b6a2-bf738d301dff
Sheet: Sheet1

Table S3. Results of genotyping other breeds affected with glaucoma or PLD.
Breed | Canine chromosome | SNP | Bp | Allele 1† | Frequency (A1) | Frequency (A2) | [NAME] | CHISQ | P | OR
Flat Coated Retriever (FCR) | 8 | BICF2P594410 | 19928718 | A | 0.6429 | 0.3125 | G | 3.274 | 0.07038 | 3.96
[NAME] (SH) | 8 | BICF2P594410 | 19928718 | A | 0.875 | 1 | G | 0.5455 | 0.4602 | 0
Welsh Terrier (WT) | 8 | BICF2P594410 | 19928718 | A | 0.75 | 1 | G | 1.2 | 0.2733 | 0
Flat Coated Retriever (FCR) | 8 | BICF2P377952 | 21323113 | A | 0 | 0 | G | NA | NA | NA
[NAME] (SH) | 8 | BICF2P377952 | 21323113 | A | 0 | 0 | G | NA | NA | NA
Welsh Terrier (WT) | 8 | BICF2P377952 | 21323113 | A | 0 | 0.125 | G | 1.324 | 0.25 | 0
Flat Coated Retriever (FCR) | 8 | BICF2S23025995 | 23018375 | C | 0.75 | 0.7778 | A | 0.04044 | 0.8406 | 0.8571
[NAME] (SH) | 8 | BICF2S23025995 | 23018375 | C | 1 | 0.6667 | A | 3.111 | 0.07776 | NA
Welsh Terrier (WT) | 8 | BICF2S23025995 | 23018375 | C | 1 | 1 | A | NA | NA | NA
† The glaucoma associated allele as allele 1.
 |  |  |  |  |  | Cases |  |  | Controls
Gene | mRNA | Mutation | Predicted protein | Polyphen2 | SIFT | Homozygous % | Heterozygous % | wt % | Homozygous % | Heterozygous % | wt %
CTAGE5 | XM_537421.3 | c.954C>A | p.Q289K | bening | tolerated | 0 | 25 | 75 | 0 | 0 | 100
 |  | c.614+101C>G |  |  |  | 0 | 33.3 | 66.7 | 0 | 50 | 50
 |  | c.615-102T>C |  |  |  | 0 | 33.3 | 66.7 | 0 | 25 | 75
 |  | c.960+21C>T |  |  |  | 0 | 25 | 75 | 0 | 25 | 75
 |  | c.1504+28G>A |  |  |  | 0 | 25 | 75 | 0 | 0 | 100
 |  | c.2459+22G>A |  |  |  | 0 | 25 | 75 | 0 | 0 | 100
FBXO33 | XM_845904 | c.1606C>T | p.D422D |  |  | 25 | 25 | 50 | 25 | 25 | 50
LRFN5 | XM_547788.2 | [NAME] | p.A267A |  |  | 50 | 0 | 50 | 0 | 25 | 75
 |  | c.2141+17A>C |  |  |  | 25 | 25 | 50 | 25 | 75 | 0
 |  | c.2141+18T>C |  |  |  | 25 | 25 | 50 | 25 | 75 | 0
PNN | NM_001003231.1 | c. 1319A>G | p.E430E |  |  | 0 | 75 | 25 | 0 | 75 | 25
 |  | c.1550G>T | p.Q527H | unknown | tolerated | 0 | 0 | 100 | 0 | 50 | 50
 |  | c.1917A>C | p.R630R |  |  | 0 | 66.7 | 33.3 | 66.7 | 33.3 | 0
 |  | c.142+6insGAGA |  |  |  | 25 | 50 | 25 | 50 | 25 | 25
 |  | c.214+37C>T |  |  |  | 0 | 0 | 100 | 0 | 50 | 50
 |  | c.527+154G>A |  |  |  | 25 | 25 | 50 | 0 | 75 | 25
TRAPPC6B | XM_537419.3 | c.585+20A>G |  |  |  | 66.7 | 33.3 | 0 | 75 | 25 | 0
 |  | c.680-111C>T |  |  |  | 0 | 100 | 0 | 0 | 100 | 0
Spreadsheet: 139670d1328373841-how-can-i-insert-date-of-today-in-column-c-when-i-enter-data-in-column-b-insert-today-date
Sheet: Sheet2

Start Date | 2012-02-04 00:00:00
New Day | S.No | Name | Date
 | 1 | Deepak | 2012-02-04 00:00:00
N | 2 | Sita | 2012-02-05 00:00:00
 | 3 | [NAME] | 2012-02-05 00:00:00
N | 4 | [NAME] | 2012-02-06 00:00:00
 | 5 | [NAME] | 2012-02-06 00:00:00
 | 6 | Booo | 2012-02-06 00:00:00
 | 7 | Akal | 2012-02-06 00:00:00
 | 8 | Kakul | 2012-02-06 00:00:00
N | 9 | Patal | 2012-02-07 00:00:00
Spreadsheet: 732648d1621098838-conditioning-formatting-failing-chemistry_v2
Sheet: data

 |  |  |  |  |  |  |  |  |  |  |  |  | Ideal Range
 |  |  | 2021-05-10 00:00:00 | Lower | Mid | Upper | Low Test | High test |  | 2021-05-15 00:00:00 |  |  | Lower | Upper
 |  | Free Chlorine | 0.5 | 1 | 2 | 3 | 0.5 | 4.1 |  | 2 |  |  | 1 | 3
 |  | Combined chlorine (calculated from FC and TC) | 0.2 | 0.2 | 0.35 | 0.5 | 0.1 | 1 |  | 0.3 |  |  | 0.2 | 0.5
 |  | Total Chlorine | 0.53 | 1 | 2 | 3 | 0.5 | 4.1 |  | 2 |  |  | 1 | 3
 |  | pH | 7.3 | 7.6 | 7.7 | 7.8 | 0.5 | 9 |  | 7.7 |  |  | 7.6 | 7.8
 |  | Total Alkalinity | 58 | 60 | 70 | 80 | 0.5 | 100 |  | 70 |  |  | 60 | 80
 |  | Calcium Hardness | 124 | 200 | 300 | 400 | 0.5 | 500 |  | 225 |  |  | 200 | 400
 |  | Cyanuric Acid | 5 | 40 | 45 | 50 | 0.5 | 100 |  | 44 |  |  | 40 | 50
 |  | Iron | 0.1 | 0 | 0.15 | 0.3 | 0.5 | 4.1 |  | 0.2 |  |  | 0 | 0.3
 |  | Copper | 0.3 | 0 | 0 | 0 | 0.5 | 4.1 |  | 0 |  |  | 0 | 0
 |  | Phosphates | 75 | 0 | 50 | 100 | -0.1 | 110 |  | 80 |  |  | 0 | 100
 |  | TDS (total dissolved solids) | 1250 | 0 | 1250 | 2500 | -0.1 | 3000 |  | 100 |  |  | 0 | 2500
 |  | actual values:
 |  | Free Chlorine | 0.5
 |  | Combined chlorine (calculated from FC and TC) | 0.2
 |  | Total Chlorine | 0.53
 |  | pH | 7.3
 |  | Total Alkalinity | 58
 |  | Calcium Hardness | 124
 |  | Cyanuric Acid | 5
 |  | Iron | 0.1
 |  | Copper | 0.3
 |  | Phosphates | 75
 |  | TDS (total dissolved solids) | 1250
Spreadsheet: 850531d1700885485-sumifs-to-cover-12-month-range-test-file-3-ans
Sheet: SUMMARY

 |  |  |  | INCOME |  |  |  |  |  | 12 MONTH DISCOUNT FROM POINT OF SALE
 |  |  |  |  | MONTH | Total |  |  |  |  | MONTH | Total
 |  |  |  |  | 2021-04-01 00:00:00 | 13631236.14000005 |  |  |  |  | 2021-04-01 00:00:00
 |  |  |  |  | 2021-05-01 00:00:00 | 10870297.84000001 |  |  |  |  | 2021-05-01 00:00:00
 |  |  |  |  | 2021-06-01 00:00:00 | 11235049.72999983 |  |  |  |  | 2021-06-01 00:00:00
 |  |  |  |  | 2021-07-01 00:00:00 | 11375674.49000007 |  |  |  |  | 2021-07-01 00:00:00
 |  |  |  |  | 2021-08-01 00:00:00 | 11047088.53000001 |  |  |  |  | 2021-08-01 00:00:00
 |  |  |  |  | 2021-09-01 00:00:00 | 15009569.50999989 |  |  |  |  | 2021-09-01 00:00:00
 |  |  |  |  | 2021-10-01 00:00:00 | 16205006.37000012 |  |  |  |  | 2021-10-01 00:00:00
 |  |  |  |  | 2021-11-01 00:00:00 | 18972606.31000015 |  |  |  |  | 2021-11-01 00:00:00
 |  |  |  |  | 2021-12-01 00:00:00 | 19607554.82000009 |  |  |  |  | 2021-12-01 00:00:00
 |  |  |  |  | 2022-01-01 00:00:00 | 22646171.96000002 |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  | 2022-02-01 00:00:00 | 24387906.96999998 |  |  |  |  | 2022-02-01 00:00:00
 |  |  |  |  | 2022-03-01 00:00:00 | 33674203.49000009 |  |  |  |  | 2022-03-01 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 | 13778369.57000007 |  |  |  |  | 2022-04-01 00:00:00
 |  |  |  |  | 2022-05-01 00:00:00 | 11215578.15000004 |  |  |  |  | 2022-05-01 00:00:00
 |  |  |  |  | 2022-06-01 00:00:00 | 11670674.56000005 |  |  |  |  | 2022-06-01 00:00:00
 |  |  |  |  | 2022-07-01 00:00:00 | 11659817.47999995 |  |  |  |  | 2022-07-01 00:00:00
 |  |  |  |  | 2022-08-01 00:00:00 | 11175543.18999997 |  |  |  |  | 2022-08-01 00:00:00
 |  |  |  |  | 2022-09-01 00:00:00 | 15050394.26999996 |  |  |  |  | 2022-09-01 00:00:00
 |  |  |  |  | 2022-10-01 00:00:00 | 18160013.92999995 |  |  |  |  | 2022-10-01 00:00:00
 |  |  |  |  | 2022-11-01 00:00:00 | 22318997.69000021 |  |  |  |  | 2022-11-01 00:00:00
 |  |  |  |  | 2022-12-01 00:00:00 | 21313531.96000011 |  |  |  |  | 2022-12-01 00:00:00
 |  |  |  |  | 2023-01-01 00:00:00 | 22714867.94000003 |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  | 2023-02-01 00:00:00 | 24644562.24000016 |  |  |  |  | 2023-02-01 00:00:00
 |  |  |  |  | 2023-03-01 00:00:00 | 34000893.30000032 |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  | 2023-04-01 00:00:00 | 12847877.86000001 |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  | 2023-05-01 00:00:00 | 10871436.35000004 |  |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  | 2023-06-01 00:00:00 | 11275793.18999999 |  |  |  |  | 2023-06-01 00:00:00
 |  |  |  |  | 2023-07-01 00:00:00 | 11265823.47 |  |  |  |  | 2023-07-01 00:00:00
 |  |  |  |  | 2023-08-01 00:00:00 | 11138891.85999998 |  |  |  |  | 2023-08-01 00:00:00
 |  |  |  |  | 2023-09-01 00:00:00 | 14704071.91999999 |  |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  | 2023-10-01 00:00:00 | 17247419.54999997 |  |  |  |  | 2023-10-01 00:00:00
 |  |  |  |  | TOTAL |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  | * Apr 21 + 12 months etc etc
Spreadsheet: 837203d1689935112-match-cell-in-range-find-2nd-highest-seq-value-but-return-date-in-adjacent-cell-excel-problem
Sheet: Cycles

prty_id | seq_no | st_date | end_date |  |  | prty_id | Start Date
AAABERGW0004 | 1 | 2023-12-31 00:00:00 |  |  |  | AAABERGW0004
AAABERGW0004 | 2 | 2018-05-08 00:00:00 | 2019-05-08 00:00:00 |  |  | AAABERGW0007
AAABERGW0004 | 3 | 2019-03-19 00:00:00 | 2020-03-19 00:00:00 |  |  | AABEDFOR0014
AAABERGW0004 | 4 | 2020-02-25 00:00:00 | 2021-02-25 00:00:00 |  |  | AABROOKS0016
AAABERGW0004 | 5 | 2021-01-12 00:00:00 | 2022-01-12 00:00:00 |  |  | AABROOKS0017
AAABERGW0004 | 6 | 2021-01-19 00:00:00 | 2022-01-19 00:00:00 |  |  | AABROOKS0018
AAABERGW0004 | 7 | 2021-11-19 00:00:00 | 2022-11-19 00:00:00 |  |  | AABROOKS0019
AAABERGW0004 | 8 | 2022-10-06 00:00:00 | 2023-10-06 00:00:00
AAABERGW0007 | 1 | 2017-08-10 00:00:00 | 2018-08-10 00:00:00
AAABERGW0007 | 2 | 2017-08-10 00:00:00 | 2018-08-10 00:00:00
AAABERGW0007 | 3 | 2018-06-27 00:00:00 | 2019-06-27 00:00:00
AAABERGW0007 | 4 | 2019-05-16 00:00:00 | 2020-05-16 00:00:00
AAABERGW0007 | 5 | 2020-03-17 00:00:00 | 2021-03-17 00:00:00
AAABERGW0007 | 6 | 2020-08-21 00:00:00 | 2021-08-21 00:00:00
AAABERGW0007 | 7 | 2022-05-26 00:00:00 | 2023-05-26 00:00:00
AAABERGW0007 | 8 | 2023-05-18 00:00:00 | 2024-05-18 00:00:00
AABEDFOR0014 | 1 | 2018-05-15 00:00:00 | 2019-05-15 00:00:00
AABEDFOR0014 | 2 | 2019-03-20 00:00:00 | 2020-03-20 00:00:00
AABEDFOR0014 | 3 | 2020-01-27 00:00:00 | 2021-01-27 00:00:00
AABEDFOR0014 | 4 | 2020-01-27 00:00:00 | 2021-01-27 00:00:00
AABEDFOR0014 | 5 | 2020-11-20 00:00:00 | 2021-11-20 00:00:00
AABEDFOR0014 | 6 | 2021-09-29 00:00:00 | 2022-09-29 00:00:00
AABEDFOR0014 | 7 | 2022-08-12 00:00:00 | 2023-08-12 00:00:00
AABEDFOR0014 | 8 | 2023-06-30 00:00:00 | 2024-06-30 00:00:00
Spreadsheet: phillip_platter__31373__ca0912EES
Sheet: SupplyBids

Min Price | 0
[NAME] | 2500
Price Offset | 0.01
Type | Supply
[NAME]
 | P1 | Q1 | P2 | Q2 | P3 | Q3 | P4 | Q4 | P5 | Q5 | P6 | Q6 | P7 | Q7 | P8 | Q8 | Total Q
HE1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
HE2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 213 | 0 | 0
HE8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 213 | 0 | 0
HE23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Generated PX Bids -- SUPPLY
 | P1 | Q1 | P2 | Q2 | P3 | Q3 | P4 | Q4 | P5 | Q5 | P6 | Q6 | P7 | Q7 | P8 | Q8 | P9 | Q9 | P10 | Q10 | P11 | Q11 | P12 | Q12 | P13 | Q13 | P14 | Q14 | P15 | Q15 | P16 | Q16
HE1 | 0 | 0 | 2500 | 0
HE2 | 0 | 0 | 2500 | 0
HE3 | 0 | 0 | 2500 | 0
HE4 | 0 | 0 | 2500 | 0
HE5 | 0 | 0 | 2500 | 0
[NAME] | 0 | 0 | 2500 | 0
HE7 | 0 | 0 | 2500 | 0
HE8 | 0 | 0 | 2500 | 0
HE9 | 0 | 0 | 2500 | 0
HE10 | 0 | 0 | 2500 | 0
HE11 | 0 | 0 | 2500 | 0
HE12 | 0 | 0 | 2500 | 0
HE13 | 0 | 0 | 2500 | 0
HE14 | 0 | 0 | 2500 | 0
HE15 | 0 | 0 | 2500 | 0
HE16 | 0 | 0 | 2500 | 0
HE17 | 0 | 0 | 2500 | 0
HE18 | 0 | 0 | 2500 | 0
HE19 | 0 | 0 | 2500 | 0
HE20 | 0 | 0 | 2500 | 0
HE21 | 0 | 0 | 2500 | 0
HE22 | 0 | 0 | 2500 | 0
HE23 | 0 | 0 | 2500 | 0
HE24 | 0 | 0 | 2500 | 0
Accepted Volumes
 | MCP | Q1 |  | Q2 |  | Q3 |  | Q4 |  | Q5 | Total
HE1
HE2
HE3
HE4
HE5
[NAME]
HE7
HE8
HE9
HE10
HE11
HE12
HE13 |  |  | 36.9 | 36.9 | 36.9 | 37.1 | 36.9 | 36.7 | 0.5 | 25 | 0
HE14 |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 5 | 5
HE15
HE16
HE17
HE18
HE19
HE20
HE21
HE22
HE23
HE24
Spreadsheet: kevin_hyatt__19625__Gila River- Ext Financial Stmts Fin Closing Proforma
Sheet: Balance Sheet

 |  | Current |  |  |  |  |  | Current |  |  |  |  |  | Current |  |  |  |  |  | Current |  |  |  |  |  | Current |  |  |  |  |  | Current
 | Beg. Bal. (COD) | Operations | AR/AP | Debt, [NAME] | Addl LT Debt | Distr | 2003 | Operations | AR/AP | Debt, [NAME] | Addl LT Debt | Distr | 2004 | Operations | AR/AP | Debt, [NAME] | Addl LT Debt | Distr | 2005 | Operations | AR/AP | Debt, [NAME] | Addl LT Debt | Distr | 2006 | Operations | AR/AP | Debt, [NAME] | Addl LT Debt | Distr | 2007 | Operations | AR/AP | Debt, [NAME] | Addl LT Debt | Distr | 2008
ASSETS
Cash | 0
Accounts Receivable
Property, Plant and Equipment
Land | 3983
Plant and Equipment net of depreciation
and amortization
Total Property, Plant and Equipment
Total Assets
LIABILITIES AND PARTNERS' CAPITAL
Liabilities
Accounts Payable | 18904
Long-Term Debt due within one year
Long-Term Debt
Total Liabilities
Partners' Capital | 587000
Total Liabilities and Partners' Capital
Debt to [NAME]
EBITDA / Interest Expense
Fixed/Total
Current Ratio
 | Assumptions:
 | Current Operations
 | Cash |  | 11/12*(Total Revenue-Variable Costs-Fixed Costs)
 | Accts Rec |  | 1/12*(Total Revenue)
 | Plant |  | Current year's Depreciation Expense
 | Accts Pay |  | (1/12*(Variable Costs+Fixed Costs)) + Major [NAME]
 | Partners Capital |  | Current year's Net Income
 | AR/AP
 | Cash |  | Net activity of:
 | Accts Rec |  | Receipt of prior year's ending balance
 | Accts Pay |  | Payment of prior year's ending balance
 | Debt
 | Cash |  | Total cash paid for:
 | Accts Pay |  | Payment of Interest Expense + Maintenance
 | LT Debt due w/in 1 Yr |  | Current year's principal repayment
 | Addl LT Debt
 | LT Debt due w/in 1 Yr |  | Reclass current portion of debt from LT Debt
 | LT Debt |  | Reclass current portion of debt from LT Debt
 | Distributions |  | 0.6
 | Cash |  | 75% current year's cash flow
 | Partners Capital |  | 75% current year's cash flow
 |  |  | NO DISTRIBUTION IN 2003