tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: EAST-MKT-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  LRC
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 94713376 | 473320441
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 10891162 | 57916986
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 105604538 | 531237427
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -86651070 | -428205264
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -18686518 | -99288706
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 111100 | 576322
 | Total Purchases: |  | -105226488 | -526917648
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 146820 | 733951
14 |  | Cash Out | 32754 | 0
15 |  | Cash In | -3 | -15
16 |  | Synthetic Storage | 21704 | -2157
 | Total Imbalances: |  | 201275 | 731779
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 48720 | 234343
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 48720 | 234343
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -628045 | -3002055.1
 |  |  | 0 | 0
23 | Fuel: |  | -111100 | -576322
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -279589
25 |  | Demand | 0 | -478059
 | Total Transport Expense: |  | 0 | -757648
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 6148832.3931
31 |  | Prior Month Book Balance | 0 | -3230224.9819
 |  | Total MTM Income | 0 | 2918607.4112
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -2603179
34 |  | Originations | 0 | 31959.92
35 |  | Broker Fees | 0 | -4553
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -89953
 |  | TOTAL INTRA-MTH
Spreadsheet: 156690d1337389887-populate-data-only-when-project-is-complete-help-2
Sheet: Totals

Project | Cost | Labor
AA
AB
AC
AD
AE
AF
 |  |  |  |  | If you look on April tab you will see Project AA listed 3 times.  When I do a Sumif all numbers are summed together.  However there is one line that has not been complete in the AA project and those numbers I would like excluded from the totals.  AA on this sheet in theory would be 10 not 14.  Once an X is put in the "complete" column in the April tab that would be the indicator to let the numbers sum with the totals that are already there.
Spreadsheet: fffbb318-a4c7-407e-879a-7b1a2348479b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42332089 | 2014-07-17 00:46:55 | AXIS | 1 | 7 | 1 | 1007284 | Temple58 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42332300 | 2014-07-17 01:32:20 | ALLIES | 0 | 5 | 7 | 1007284 | Temple58 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42348831 | 2014-07-18 09:08:00 | ALLIES | 1 | 7 | 5 | 979406 | homez | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42462184 | 2014-07-26 17:12:56 | AXIS | 0 | 2 | 6 | 418850 | SIR B LAW | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
42462640 | 2014-07-26 18:13:58 | ALLIES | 1 | 6 | 4 | 418850 | SIR B LAW | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
Spreadsheet: 826571d1682087005-map-a-table-kg-to-g-map-kg-to-g
Sheet: convert

 |  |  |  |  |  |  | expected result
Al-100 | 0.025 | [NAME] |  |  |  |  |  | g |  |  |  | g
Al-100 | 1 | [NAME] |  |  |  |  |  | g |  |  | 1000 | g
[NAME] | 0.025 | [NAME] |  |  |  |  |  | g |  |  | 25 | g
[NAME] | 0.5 | [NAME] |  |  |  |  |  | g |  |  | 500 | g
[NAME] | 1 | L |  |  |  |  |  | mL |  |  | 1000 | mL
Al-102 | 0.025 | [NAME] |  |  |  |  |  | g |  |  | 25 | g
Al-102 | 1 | [NAME] |  |  |  |  |  | g |  |  | 1000 | g
Al-103 | 0.025 | [NAME] |  |  |  |  |  | g |  |  | 25 | g
Al-103 | 1 | g |  |  |  |  | 1 | g |  |  | 1 | g
Al-104 | 1 | [NAME] |  |  |  |  |  | g |  |  | 1000 | g
Al-105 | 25 | [NAME] |  |  |  |  |  | g |  |  | 25000 | g
[NAME] | 25 | [NAME] |  |  |  |  |  | g |  |  | 25000 | g
Al-111 | 1 | [NAME] |  |  |  |  |  | g |  |  | 1000 | g
Al-112 | 1 | L |  |  |  |  |  | mL |  |  | 1000 | mL
Al-113 | 1 | g |  |  |  |  | 1 | g |  |  | 1 | g
Al-113 | 500 | g |  |  |  |  | 500 | g |  |  | 500 | g
AA7075-100 | 1 | [NAME] |  |  |  |  |  | g |  |  | 1000 | g
Spreadsheet: 773710d1648020495-the-total-number-of-corresponding-product-purchase-in-the-last-5-orders-date-3-23-aligw
Sheet: Sheet1

Date | Product name | quantity
2022-03-01 00:00:00 | Apple | 1
2022-03-01 00:00:00 | cherries | 3 |  |  | Apple
2022-03-02 00:00:00 | Pineapple | 5 |  |  | cherries
2022-03-03 00:00:00 | Apple | 9 |  |  | mangosteen
2022-03-04 00:00:00 | cherries | 4
2022-03-05 00:00:00 | Apple | 8
2022-03-06 00:00:00 | mangosteen | 1
2022-03-07 00:00:00 | Pineapple | 6
2022-03-08 00:00:00 | Apple | 4
2022-03-09 00:00:00 | Pineapple | 8
2022-03-10 00:00:00 | Apple | 2
2022-03-11 00:00:00 | cherries | 5
2022-03-12 00:00:00 | Apple | 6
2022-03-13 00:00:00 | mangosteen | 4
Spreadsheet: 739404d1625675787-sumifs-and-if-else-condition-sample_if
Sheet: Data

GL Acct | Desc | Amount | Period
6000 | Benefits | 3000 | 1
7000 | Labor | 6000 | 1
8000 | Overhead | 7000 | 1
9000 | Other | 2000 | 1
6000 | Benefits | 3000 | 2
7000 | Labor | 6000 | 2
8000 | Overhead | 7000 | 2
9000 | Other | 2000 | 2
6000 | Benefits | 3000 | 3
7000 | Labor | 6000 | 3
8000 | Overhead | 7000 | 3
9000 | Other | 2000 | 3
Spreadsheet: 211011d1359638074-help-row-into-column-another-sheet-dee2
Sheet: TAM

Sl.No | Name | FA(a) | FA(b) | FA(a+b) | SA
1 | Raja | 15 | 17 | 32 | 60
2 | Rav
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
Spreadsheet: 139734d1328426122-converting-sumif-to-sumsomething-for-excel-2003-a-little-help-please-book2-1-
Sheet: Sheet2

Team 1 Panel
SRN | S/N | Name | Team | Type of Leave | [NAME] By | Start Of Sickness | Expected RTW | Actual Day Back | Recorded Number of Days Off? | Occurrences (total) | Occurrences (cal. year) | Days Off (cal.year) | Current Bradford Score | Initial Comments | Intial Actions | Comments |  |  |  | Occurances | date calc | Older than a year |  |  | 2012-02-05 00:00:00 | 2011-02-05 00:00:00
Ref 1 | C3467 | [NAME] | 1B | Part Day | [NAME] | 2012-01-01 00:00:00 | 2012-01-12 00:00:00 | 2012-01-22 00:00:00 | 21 | 4 | 4 | 85 | 1360 | 0 | None |  | 2815 |  | 4 | 4 | 35 | no | 0 | 0
Ref 2 | C3467 | [NAME] | 1B | Full Sickness | [NAME] | 2012-01-09 00:00:00 | 2012-01-15 00:00:00 | 2012-01-20 00:00:00 | 11 | 4 | 4 | 85 | 1360 | 0 | None |  | 11 |  | 4 | 4 | 27 | no | 0 | 0
Ref 3 | C3467 | [NAME] | 1A | Emergency Leave | [NAME] | 2012-01-09 00:00:00 | 2012-01-16 00:00:00 | 2012-02-20 00:00:00 | 42 | 4 | 4 | 85 | 1360 | 0 | None |  | 42 |  | 4 | 4 | 27 | no | 0 | 0
Ref 4 | C3467 | Adam | 1A | [NAME] | [NAME] | 2012-01-11 00:00:00 | 2012-02-22 00:00:00 | 2012-01-22 00:00:00 | 11 | 4 | 4 | 85 | 1360 | 0 | None |  | 11 |  | 4 | 4 | 25 | no | 0 | 0
Spreadsheet: 695874d1600436467-merging-data-by-using-unique-reference-in-excel-investor-detail_merge_fund_perf_vlookup_chris
Sheet: Sheet1

Inv Ref | Sal | Name | Surname | Add 1 | Add 2 | Add 3 | Add 4 | Add 5 | Inv Ref | Total Contribution | Units | Unit price | Current Value | Gains or Losses
EXA001 | Mr | [NAME] | [NAME] | Buckingham Palace | Buckingham Gate | London | England | UK20 9BP
EXA002
EXA003
EXA004
EXA005
EXA006
EXA007
EXA008
EXA009
EXA010
EXA011
EXA012
EXA013
EXA014
EXA015
EXA016
EXA017
EXA018
EXA019
EXA020
EXA021
EXA022
EXA023
EXA024
EXA025
EXA026
EXA027
EXA028
EXA029
EXA030
Spreadsheet: 187306d1350402103-check-time-is-between-2-times-and-highlight-cell-sample-rota
Sheet: Sheet1

 |  |  | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00
Start | Finish | Elapse | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00
Off | Off
08:00:00 | 12:00:00
Spreadsheet: 50251d1249631397-countif-counting-too-much-text-values-project
Sheet: results

Chances/probability |  |  | 54
1 - poor/no chance | 9
2- perhaps some chance | 7
3- interested / potential | 3
4 -somewhat good | 1
5 -very good | 0
? -unknown yet | 34 |  | problem with formula..
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FY08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08 | FY08
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 21

 |  | Gross Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated gross notional amount outstanding, January 4 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 769099d1645289133-how-many-unique-areas-have-been-visited-by-vehicle-in-date-range-report
Sheet: Sheet4

 | Vehicle No.
 | 1/63335
 | 8/12539
 | 11/17055
 | 13/51504
 | 15/70824
 | 13/80857
 | 13/80774
 | 2/98435
 | 1/67031
 | 15/25206
 | 15/58135
 | 13/54318
 | 13/16090
 | 13/69725
 | _
 | 13/70824
 | 6/1103
 | 13/51814
 | 11/69228
 | 1/64134
 | 13/80774+1/63335
 | 13/51504+1/64134
 | 13/51623
 | 15/70824+1/64134
 | 13/80774+13/51501
 | 12//4496
 | _______
 | 1/77274
 | 11/63335
Spreadsheet: stephanie_panus__39306__e prime Energy Marketing omnibus
Sheet: ANEWSWP2

OMNIBUS CONFIRMATION INFORMATION SHEET--DEAL #YL0308.1/3/4
 |  | ATTORNEY:
DATE: | 2001-11-21 00:00:00 | DEAL MAKER:
COUNTERPARTY: | e prime Energy Marketing, Inc. | CONTACT: | [NAME]
ADDRESS: | 1099 18th Street | TITLE: | Risk Manager
 | Suite 3000 | PHONE: | [PHONE]
 | Denver, CO 80202 | FAX:
Incorporation State |  | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) | Xcel Energy Inc. (A-) | Enron Corp. (BBB-)
LIMIT $ MILLIONS | $10MM | ** | **Outgoing Gty dated 6/18/01 already issued that will cover this deal.
Incorporation State |  | Oregon
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | $5MM | $10MM | USD
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 0 | 0
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | X | X
-Below = S&P/Moody's | BBB- | BBB- | S&P
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-EBITDA/Int.
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME])
-Guarantor ($[NAME]) | $50MM | $100MM
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: X | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: X | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: X | NO:
OTHER COMMENTS:
This omnibus confirmation is tied to deal #'s YL0308.1/3/4; trade date 11/20/01.
Counterparty is an Eligible Contract Participant--Guarantor meets applicable financial criteria.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x6-6002
Spreadsheet: 480112d1473781640-vlookup-last-match-clarification
Sheet: Sheet1

 | Column B | Column C |  | Column E |  |  | Column H
 |  |  |  | Vlookup - last match
 | EMPNAME | STATUS_WEF | Column1 | STATUS_WEF2 | Column3 | Check | Date should be
 | AMANDEEP SINGH | 2011-12-01 00:00:00 |  |  |  | Error | 2014-10-01 00:00:00
 | AMANDEEP SINGH | 2012-07-01 00:00:00 |  |  |  | Error
 | AMANDEEP SINGH | 2014-10-01 00:00:00 |  |  |  | Error
 | AMANDEEP SINGH | 2013-01-01 00:00:00 |  |  |  | Error
 | SUKHDEV KUMAR | 2010-07-13 00:00:00 |  |  |  | Error
 | SUKHDEV KUMAR | 2011-11-01 00:00:00 |  |  |  | Error
 | SUKHDEV KUMAR | 2015-08-01 00:00:00 |  |  |  | Error
 | SUKHDEV KUMAR | 2012-02-01 00:00:00 |  |  |  | Error
 | Date in Column c represents movement of employee with in the diff group companies over his tenure
 | would like to capture his last working date in column E
 | I am trying the below array formula in colum E  to extract the last date
 | =LOOKUP(9.99999999999999E+307,IF(B$4:B$11=B4,IF(ISNUMBER(C$4:C$11),C$4:C$11)))
 | I am getting error.
 | What I actually need is shown in column H , can some one please help and also guide me where I am going wrong .
 | regards
Spreadsheet: 676998d1589136075-transpose-data-from-1-column-to-rows-transpose-equally
Sheet: Sheet1

ITEMS ( RAW DATA WITH ME) |  | Output
1 |  | Persons | Attendance
2 |  | A | Present
3 |  | B | Present
4 |  | C | Abscent
5 |  | D | Present
6 |  | E | Present
7 |  | F | Present
8 |  | G | Present
9 |  | H | Present
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
Spreadsheet: chris_germany__1985__ENA-Reliant Prepay
Sheet: Apr 2002

ENA Purchases from Reliant - April 2002
For deliveries on FGT Zone 2 & 3
[NAME] |  | [NAME][PHONE]     [EMAIL]
Backup ENA Trader |  | [NAME]  [PHONE]  [EMAIL]
[NAME] |  | [NAME] [PHONE]  [EMAIL]
City of Tallahassee |  | Pam McCullers [PHONE]
[NAME] |  | [NAME][PHONE]  [EMAIL]
[NAME] |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  | [NAME]  [PHONE]  [EMAIL]
Reliant Settlements |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
 | Date | Volume | Location | Price [NAME] | GD Post | Price | Total |  | Prepayments | Balance
 |  |  |  |  |  |  |  |  | Balance from March 2002
Mon | 2002-04-01 00:00:00 | 2000 | Z3 | Fixed Price Zone 3 | N/A | 3.32 |  |  | 0
Tue |  | 2000 | [NAME] | [NAME] | 3.445 |  |  |  | 0
Wed |  | 2000 | [NAME] | [NAME] | 3.75 |  |  |  | 0
Thu |  | 2000 | [NAME] | [NAME] | 3.7 |  |  |  | 37000
Fri |  | 2000 | [NAME] | [NAME] | 3.6 |  |  |  | 0
Sat |  | 0 |  |  | 3.32 |  |  |  | 0
Sun |  | 0 |  |  | 3.32 |  |  |  | 0
Mon |  | 2000 | Z1 | [NAME] | 3.32 |  |  |  | 0
Tue |  | 0 |  | [NAME] | 3.37 |  |  |  | 0
Wed |  | 2000 | [NAME] | [NAME] | 3.26 |  |  |  | 0
Thu |  | 2000 | [NAME] | [NAME] | 3.27 |  |  |  | 0
Fri |  | 0 |  | [NAME] | 3.17 |  |  |  | 22000
Sat |  | 0 |  | FGT Z1 GD + .06 | 3.08 |  |  |  | 0
Sun |  | 0 |  | FGT Z1 GD + .06 | 3.08 |  |  |  | 0
Mon |  | 2000 | Z1 DRN 6489 | FGT Z1 GD + .06 | 3.08 |  |  |  | 0
Tue |  | 2000 | [NAME] | [NAME] | 3.305 |  |  |  | 0
Wed |  | 2000 | [NAME] | [NAME] | 3.45 |  |  |  | 0
Thu |  | 0 |  | [NAME] | 3.4 |  |  |  | 0
Fri |  | 0 |  | [NAME] | 3.52 |  |  |  | 17000
Sat |  | 0 |  | [NAME] | 3.4 |  |  |  | 0
Sun |  | 0 |  | [NAME] | 3.4 |  |  |  | 0
Mon |  | 0 |  | [NAME] | 3.4 |  |  |  | 0
Tue |  | 2000 | [NAME] | [NAME] | 3.6 |  |  |  | 0
Wed |  | 2000 | [NAME] | [NAME] | 3.64 |  |  |  | 0
Thu |  | 2000 | [NAME] | [NAME] | 3.53 |  |  |  | 0
Fri |  | 0 |  | [NAME] | 3.48 |  |  |  | 0
Sat |  | 0 |  | [NAME] | 3.345 |  |  |  | 0
Sun |  | 0 |  | [NAME] | 3.345 |  |  |  | 0
Mon |  | 2000 | [NAME], Tallahassee k#5634 | [NAME] | 3.345 |  |  |  | 45000
Tue |  | 2000 | [NAME] | [NAME] | 3.46 |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  | Sitara deal #1203186
 | **  Estimated Gas Daily Midpoint used for flow date indicated.
Spreadsheet: 9e272694-b330-4602-9c4c-e5a902e42fce
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 | Unnamed: 19 | Unnamed: 20
1. Name of vendor |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. Tax Identification number |  | 3. ST number |  | 4. Invoice number |  | 5. Date of invoice
6. Address (number and street, city, state, and ZIP code) |  |  |  |  |  |  |  |  |  |  |  | 7. Invoice Type |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | First Bill         Rate Adjust         Re-Bill                 Appeal |  |  |  | 8. Page |  | of |  | Pages
9. Invoice Service Type
 | Residential | LCPA |  |  | Relative |  |  |  | Foster Parent |  | Family Preservation |  | Independent Living |  | Adoption
 | Home Builders | CMHC |  |  | Medicaid |  |  |  | Group |  | Court |  | Reports
10. For the period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11. Total of Claim
From: |  | , |  | Year |  | to |  |  |  | ,   Year |  |  |  |  |  | $
 | CHILDREN FOR WHOSE SUPPORT AND ALLOWANCES ARE DUE AND PAYABLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATES OF SERVICE
 | 12. COUNTY | 13. BILLABLE UNIT REFERRAL ID |  |  |  |  | 14. CASE ID |  |  | 15. NAME / COMMENTS / DOCUMENTATION |  |  |  |  | 16. BILLING CODE | 17. BEGIN | 18.  END | 19.  UNIT | 20. RATE | 21. TOTAL COST
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Pursuant to the provisions and penalties of Indiana Code 5-11-10-1, I hereby certify that the foregoing invoice is just and correct, that the amount claimed is legally due, after allowing all just credits, and that no part of the same has been paid. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page Total
I hereby swear and affirm under the penalties of perjury the attached bill contains the actual placement and/or service costs provided for the individual listed on such bill.  The dates, days, hours and units of time and costs for placement or service are true and accurate.  I understand that in submitting this that I am under oath stating and affirming that these services were provided and fully understand that these services may be independently audited and that any discrepancy may be referred to a local prosecutor for criminal prosecution.
22. Signature of vendor |  |  |  |  |  |  |  |  |  |  | 23. Telephone number of vendor |  |  | 24. E-mail address of vendor |  |  |  |  | 25. Date (month, day, year)
 |  |  |  |  |  |  |  |  |  |  | (         )
Spreadsheet: 876881d1723593430-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.01.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-01 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 22 | 0 | 4 | 1 | 1 | 0 | 2 | 2 | 0
 | 5TH FL | 34 | 20 | 20 | 0 | 4 | 0 | 0 | 1 | 0 | 2 | 0
 | ABC | 27 | 18 | 22 | 0 | 6 | 0 | 1 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 1 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 1 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 0 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-01 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 2 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 0 | 4 | 0 | 1 | 0 | 1 | 1 | 0
 | 5TH FL | 34 | 20 | 17 | 2 | 3 | 1 | 0 | 0 | 1 | 2 | 0
 | ABC | 27 | 18 | 22 | 0 | 5 | 0 | 2 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 0 | 1 | 1 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 4.5 | 2 | 0 | 0 | 1 | 1 | 0
 | Total House Census