tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 99976d1298480020-median-book1
Sheet: Sheet1

date | value | median
2010-12-01 00:00:00 | 23
2010-12-01 00:00:00 | 23
2010-12-01 00:00:00 | 23
2010-12-01 00:00:00 | 23
2010-12-01 00:00:00 | 23
2010-12-01 00:00:00 | 23
2010-12-01 00:00:00 | 32
2010-12-01 00:00:00 | 32
2010-12-01 00:00:00 | 32
2010-12-01 00:00:00 | 33
2010-12-01 00:00:00 | 34
2010-12-01 00:00:00 | 35
2010-12-01 00:00:00 | 36
2010-12-01 00:00:00 | 37
2010-12-01 00:00:00 | 45
2010-12-01 00:00:00 | 45
2010-12-01 00:00:00 | 45
2010-12-01 00:00:00 | 50
2010-12-01 00:00:00 | 50
2010-12-01 00:00:00 | 50
2010-12-01 00:00:00 | 50
2010-12-04 00:00:00 | 50
2010-12-04 00:00:00 | 51
2010-12-04 00:00:00 | 52
2010-12-04 00:00:00 | 53
2010-12-04 00:00:00 | 54
2010-12-04 00:00:00 | 55
2010-12-04 00:00:00 | 56
2010-12-04 00:00:00 | 57
2010-12-04 00:00:00 | 60
2010-12-04 00:00:00 | 60
2010-12-04 00:00:00 | 60
2010-12-04 00:00:00 | 60
2010-12-04 00:00:00 | 60
2010-12-04 00:00:00 | 60
2010-12-04 00:00:00 | 60
2010-12-04 00:00:00 | 60
2010-12-04 00:00:00 | 64
2010-12-04 00:00:00 | 66
2010-12-04 00:00:00 | 68
2010-12-04 00:00:00 | 70
2010-12-04 00:00:00 | 72
2010-12-04 00:00:00 | 74
2010-12-04 00:00:00 | 74
2010-12-04 00:00:00 | 74
2010-12-04 00:00:00 | 74
2010-12-04 00:00:00 | 74
2010-12-04 00:00:00 | 74
2010-12-10 00:00:00 | 12
2010-12-10 00:00:00 | 12
2010-12-10 00:00:00 | 13
2010-12-10 00:00:00 | 14
2010-12-10 00:00:00 | 15
2010-12-10 00:00:00 | 16
2010-12-10 00:00:00 | 17
2010-12-10 00:00:00 | 18
2010-12-10 00:00:00 | 23
2010-12-10 00:00:00 | 23
2010-12-10 00:00:00 | 23
2010-12-10 00:00:00 | 23
2010-12-10 00:00:00 | 23
2010-12-10 00:00:00 | 23
2010-12-10 00:00:00 | 23
2010-12-10 00:00:00 | 23
2010-12-10 00:00:00 | 27
2010-12-10 00:00:00 | 31
2010-12-10 00:00:00 | 35
2010-12-10 00:00:00 | 36
2010-12-10 00:00:00 | 38
2010-12-10 00:00:00 | 38
2010-12-10 00:00:00 | 38
2010-12-10 00:00:00 | 38
2010-12-10 00:00:00 | 39
2010-12-10 00:00:00 | 40
2010-12-10 00:00:00 | 41
Spreadsheet: andy_zipper__277__Allario Prospects -- 6-01
Sheet: Metals & Mining

[NAME]
Prospects:  Petchems, NGL's/ Oil/ Refined, Pulp & Paper
Company Name | Ticker | Market  [NAME] ($B) | Sector | Draft  Priority | Status | Documents | Comments
General Motors | AA | 37.5 | Petchems (Steel) | 1 | Meeting in Detroit between EGM/ENW and GM Purchasing/Treasury/Business Dev. Being scheduled. | NDA | Positive momentum
BP Amoco |  |  | Petchems/ NGL's | 1 | 5/09/01 -Initial meeting in NY held.  Currently contacting head of NGL trading. | None | Good initial meeting and presentation
[NAME] |  |  | Oil and Gas Products | 1 | 5/29/01 - Contacted HETCO traders, Chief Risk Officer & CIO.  Awaiting response for request for a meeting in NY. | None | Former employer. I know organization and management well.
American Express/ Sabre Corp. |  |  | Travel Related Services | 1 | Discussion began in April 2001.  Business Model meeting set for June 7th, 1 to 4PM in Dallas. | NDA with Sabre | Outgrowth of earlier market making campaign
[NAME] |  |  | Energy, NGL's, pipe cap | 2 | 5/12/01 - Initial meeting with CIO.  Following up to meet trading group. | None | Strong CIO interest
Quebecor Inc. |  |  | Pulp & Paper | 2 | 5/29/01 - Initial contacts made.  Awaiting replies. | None | My brother's employer.  Bro plays golf with N.A. President.
Spreadsheet: joe_parks__14713__POSTION05_02
Sheet: M-V_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  | 114.75 | 3.929 |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 153
 |  |  |  |  |  |  |  |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  | 0.5
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 884593d1733827065-automatically-export-data-from-multiple-sheets-if-it-matches-into-a-combined-sheet-tester-2
Sheet: Takings

Month / Year |  | 2024-12-01 00:00:00
Date |  | Takings Before Fee's |  | Fee's |  | To Pay Sellers |  |  |  |  | Transaction Fee's
2024-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 0.025
Monthly Total
Spreadsheet: 886021d1735961558-how-to-automatically-add-entry-on-one-sheet-based-on-another-sheet-test-1
Sheet: Masterfile

 | First Name | Middle Name | Last Name | Full Name | Biometrics | Initials | Company | Area
1 | [NAME] | Valmorida | Salmo | [NAME] Valmorida Salmo | WCVSalmo | WCVS | Merdistric Corporation | [NAME]
2 | [NAME] | Lluch | Salmo | [NAME] | SLSalmo | SLS | Widemind Corporation | CDOC
3 | [NAME] | Valmorida | Salmo | [NAME] Valmorida Salmo | WPVSalmo | WPVS | Widemind Corporation | CDOC
4 | Maricyl | Paculba | Datu | [NAME] | MPDatu | MPD | Merdistric Corporation | CDOC
5 | Jemboy | Ababa | [NAME] | Jemboy Ababa Villasencio | JAVillasencio | JAV | Merdistric Corporation | CDOC
6 | Jonny | Joring | Cabil | Jonny Joring Cabil | JJCabil | JJC | Merdistric Corporation | [NAME]
7 | Dianna Fe | Destinado | Hermogenes | Dianna Fe Destinado Hermogenes | DFDHermogenes | DFDH | Merdistric Corporation | CDOC
8 | Lorimer | Edmilao | [NAME] | [NAME] Valmorida Jr | LEValmorida Jr | LEVJ | Widemind Corporation | CDOC
6 | Jonny | Joring | Cabil | Jonny Joring Cabil | ASabil | JJC | Merdistric Corporation | [NAME]
7 | Jonny | Joring | Cabil | Jonny Joring Cabil | BDAR | JJC | Merdistric Corporation | [NAME]
8 | Jonny | Joring | Cabil | Jonny Joring Cabil | JohnDoe |  | Widemind Corporation | Los Angeles
9 | Jonny | Joring | Cabil | Jonny Joring Cabil | JJCabil | JJC | Merdistric Corporation | [NAME]
10 | Jonny | Joring | Cabil | Jonny Joring Cabil | FSgHAR | JJC | Merdistric Corporation | [NAME]
11 | Jonny | Joring | Cabil | Jonny Joring Cabil | DSXAR | JJC | Merdistric Corporation | [NAME]
12 | Jonny | Joring | Cabil | Jonny Joring Cabil | SdFFar | JJC | Merdistric Corporation | CDOC
13 | Jonny | Joring | Cabil | Jonny Joring Cabil | JJCabil | JJC | Merdistric Corporation | CDOC
14 | Jonny | Joring | Cabil | Jonny Joring Cabil | [NAME] | JJC | Merdistric Corporation | CDOC
15 | Jonny | Joring | Cabil | Jonny Joring Cabil | Amabil | JJC | Merdistric Corporation | CDOC
16 |  |  |  |  | JohnDoe |  | Widemind Corporation | Los Angeles
16 |  |  |  |  | JohnFox | JJC | Merdistric Corporation | CDOC
16 |  |  |  |  | JaneDoe |  | Widemind Corporation | Los Angeles
Spreadsheet: 219342d1362727289-help-with-a-formula-function-if-its-possible-admit-dc-2013
Sheet: Totals

Admission and Discharges
2013
January Totals
Admits/Discharge by Times |  |  |  |  | Where Are Admits From
 | Admission | Discharges |  |  |  | # of patients
0000-0200 | 13 | 0 |  |  | ED | 94
0201-0400 | 5 | 0 |  |  | CDU | 0
0401-0600 | 3 | 0 |  |  | ASU | 8
0601-0800 | 1 | 0 |  |  | OR | 1
0801-1000 | 1 | 3 |  |  | [NAME] | 3
1001-1200 | 16 | 8 |  |  | DA | 6
1201-1400 | 15 | 32
1401-1600 | 16 | 38
1601-1800 | 11 | 21 |  |  | Inpatient vs Observation
1801-2000 | 12 | 8 |  |  |  | # of patients
2001-2200 | 7 | 1 |  |  | Inpt | 0
2201-2400 | 13 | 0 |  |  | Obs | 0
Admits/Discharge by Days |  |  |  |  |  |  |  |  |  | 2013-01-02 00:00:00
 | Admission | Discharges
Monday | 10
Tuesday | 24
Wednesday | 23
Thursday | 16
Friday | 10
Saturday | 6
Sunday | 10
Spreadsheet: 842006d1694100504-using-sumproduct-to-return-values-based-on-criteria-when-date-filter-changes-excel-formula-09-07-2023
Sheet: Sheet2

Phase Owner | Phase Type | Start Date | Month | Year
[NAME] | Account Cleanup | 2023-06-01 00:00:00
[NAME] | Account Cleanup | 2023-06-20 00:00:00
Zachary | Implementation | 2023-06-30 00:00:00
Laurel | Implementation | 2023-08-21 00:00:00
Laurel | Implementation | 2023-06-14 00:00:00
Zachary | Implementation | 2023-06-01 00:00:00
Laurel | Implementation | 2023-07-14 00:00:00
Zachary | Implementation | 2023-07-28 00:00:00
Zachary | Implementation | 2023-08-15 00:00:00
[NAME] | Implementation | 2023-03-15 00:00:00
Laurel | Implementation | 2023-05-23 00:00:00
[NAME] | Light Implementation | 2023-07-11 00:00:00
[NAME] | Light Implementation | 2023-08-09 00:00:00
Laurel | Light Implementation | 2023-05-11 00:00:00
[NAME] | Light Implementation | 2023-05-31 00:00:00
Spreadsheet: darrell_schoolcraft__7244__saledoc01_16TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2002-01-23 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 01/24/02 |  |  | FAX Number:
Total Quantity |  |  | 10000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
01/24/02 | 2002-01-24 00:00:00 | 10000 |  | 10000 |  | 10000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 10000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 67404d1268052857-countif-with-offset-2010-03-08_counting_seminars
Sheet: Sheet1

Date | Audience
2009-10-21 00:00:00 | ACME
2009-10-22 00:00:00 | ACME
2009-11-18 00:00:00 | Stakeholders
2009-11-18 00:00:00 | External
2009-12-08 00:00:00 | Stakeholders
2009-12-09 00:00:00 | External
2009-12-09 00:00:00 | Stakeholders
2010-01-05 00:00:00 | ACME
2010-01-19 00:00:00 | Stakeholders
2010-01-20 00:00:00 | Stakeholders
2010-01-22 00:00:00 | External
2010-02-01 00:00:00 | ACME
2010-02-02 00:00:00 | Stakeholders
2010-02-04 00:00:00 | External
2010-02-11 00:00:00 | Stakeholders
2010-02-15 00:00:00 | ACME
2010-02-23 00:00:00 | ACME
2010-02-23 00:00:00 | Stakeholders
2010-03-02 00:00:00 | Stakeholders
2010-03-03 00:00:00 | Stakeholders
2010-03-12 00:00:00 | Stakeholders
2010-03-31 00:00:00 | Stakeholders
 | 6 | ACME
 | 12 | Stakeholders
 | 4 | External
Spreadsheet: 1fabe53c-7786-451b-a9e3-650102bdc28d
Sheet: Sheet1

Outreach FY09 scorecard | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Domain | Measurement tool | Description | Goal | Goal Source | YTD result | Goal Met?
 | Review of waiting list | SMD persons (except for HAP) referred for Independent Living Program services will be enrolled within 15 business days of referral | 0.8 | Four years of historical data
 | # of CPST units delivered | 12,480 units of CPST will be delivered by June 30, 2009 | 0.95 | Four years of historical data
Efficiency | # of days of HAP occupancy | 4,750 days of HAP occupancy will be provided | 0.9 | Four years of historical data
 | Chart review to determine # of persons served without any episodes of hospitalization | SMD Adults will maintain overall psychiatric stability | 0.9 | Four years of  historical data
Effectiveness
 | Chart review of ISP Update forms | SMD Adults will maintain or achieve at least one objective identified on their Individual Service Plan. | 0.8 | Four years of historical data
 | Review of individual checkbooks | SMD Adults receiving protective payee services will maintain financial stability | 0.9 | Four years of historical data
 | Chart review to determine # of persons who remained in their housing | SMD Adults will have housing that is safe, decent and affordable | 0.9 | Four years of historical data
Effectiveness | Aggregated data from Consumer Outcome  responses | SMD Adults will have an 0.5 point increase in their Quality of Life score on a subsequent administration of the ODMH Adult Consumer Form A., when compared to the initial administration. | 0.5
 |  |  |  | new
 | # person who rated their satisfaction with services at the “very high” or “high” level | SMD Adults will express satisfaction with the services received | 0.9 | Four years of historical data
Satisfaction
Spreadsheet: 50677d1250157706-continual-updates-of-most-recent-information-shifts
Sheet: Shift

Date | Team | V1 | V2 | V3 | V4 | V5
2009-07-28 00:00:00 | 1 | A | B | C | D | E
2009-08-03 00:00:00 | 1 | D | G | K
2009-08-04 00:00:00 | 1 | K
2009-08-09 00:00:00 | 2 | J | L | D | C
2009-08-12 00:00:00 | 1 | I | M | F
2009-08-13 00:00:00 | 1 | D | A
2009-08-13 00:00:00 | 2 | E | K
2009-08-13 00:00:00 | 3 | C | G
2009-08-13 00:00:00 | 4 | J | B | L | L
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 73336 | - | 26703
Cross-Currency Fixed-Fixed | - | 6498 | - | 5927
Cross-Currency Fixed-Float | - | 4622 | - | 2944
TOTAL | - | 84456 | - | 35574
Spreadsheet: 93488d1293050281-excel-2007-grabbing-cell-in-same-column-different-row-eaa
Sheet: Sheet3

2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
Total
Spreadsheet: 787519d1657826999-calculate-how-many-records-open-by-the-end-of-each-month-date
Sheet: Sheet1

Record # | Department | Date Created | Date Closed |  |  | Department | Open as of today | Open by of end of May 2022 | Open by end of Jun 2022 | Open by end of Jul 2022
1 | A | 2022-04-23 00:00:00 |  |  |  | A
2 | B | 2022-06-12 00:00:00 | 2022-07-03 00:00:00 |  |  | B
3 | B | 2021-11-06 00:00:00 | 2022-05-27 00:00:00 |  |  | C
4 | B | 2021-12-03 00:00:00 |  |  |  | D
5 | B | 2022-03-22 00:00:00 |  |  |  | E
6 | A | 2022-06-21 00:00:00 | 2022-07-10 00:00:00
7 | B | 2022-03-10 00:00:00 | 2022-07-13 00:00:00
8 | C | 2021-11-03 00:00:00
9 | D | 2021-10-04 00:00:00 | 2022-05-26 00:00:00
10 | E | 2022-07-01 00:00:00
11 | C | 2022-04-12 00:00:00 | 2022-07-02 00:00:00
Spreadsheet: debra_perlingiere__8419__NG Energy Trading
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-08-20 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | NG Energy Trading, L.L.C. | CONTACT:
ADDRESS: | 5600 N May Ave. Ste.190 | TITLE:
 | Oklahoma City, OK 73112 | PHONE:
 |  | FAX:
INCORPORATION STATE: | OK | S&P RATING:
STRUCTURE | Rating | COUNTERPARTY | ENA ENTITY
COLLATERAL | A- & above | 10 | 35
THRESHOLD in $ | BBB+ | 7.5 | 25
according to Credit Matrix | BBB | 5 | 12
 | BBB- | 2.5 | 6
 | Below BBB- | 0 | 0
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | Alliant Energy Corporation (A+) | Enron Corp. (BBB+)
LIMIT in $[NAME] | $15MM | $30MM
Incorporation State: | WI | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | X | X
-Below = | BBB- | BBB- | S&P
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty
-Guarantor ($[NAME]) | $100MM | $100MM
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | D.Vanek | x3-1436
Spreadsheet: 438462d1451996922-sum-with-2-condition-sumif
Sheet: Foglio2

apple | 2 |  | apple | 8
pear | 4 |  | pear | 4
apple | 6 |  | kiwi | 5
kiwi | 2 |  | orange | 6
kiwi | 3
apple | 6
orange | 2
kiwi | 6
kiwi | 3
apple | 2
orange | 4
orange | 2
Spreadsheet: 765833d1643633147-formula-help-needed-to-split-joint-house-bills-in-proportion-to-incomes-household-contribution-calculator-2
Sheet: Household Contribution Calculat

Joint Income |  |  |  |  |  | Monthly Joint Expenses
 |  | Total | Person 1 | Person 2 |  |  |  | Overall Cost | Person 1 Contributes | Person 2 Contributes
Net Income |  |  | 100000 | 50000 |  | Mortgage |  | 1500
Percentage Difference |  |  |  |  |  | Council Tax |  | 150
 |  |  |  |  |  | Water |  | 100
 |  |  |  |  |  | Gas |  | 80
 |  |  |  |  |  | Electric |  | 70
 |  |  |  |  |  | Total
Spreadsheet: 6e68a82d-15c6-4665-8c12-dda530ed6ea8
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TBMP | Test | TBMP | Mycobacteria Probe Ident Solid ([NAME] Only) | Mycobacteria Probe Ident |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87150 |  |  |  |  | Rochester
TBMP | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 3f9c0a1c-ac79-45f7-8327-6930afae930c
Sheet: Japan

Export Sales | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
Japan | this year | last year | this year | last year | this year | last year
Spreadsheet: 794880d1662378235-absence-trackershowing-extra-days-in-some-months-how-to-fix-employee-absence-tracker
Sheet: Dec Abs Data

 |  |  | PLEASE NOTE:  The start day is the first day of leave/sickness and the end date is the last day of leave/sickness and NOT the day that they retun to work
 | Employee Name | Start Date | End Date | Type of Leave | Reason for Sickness Absence | Other reasons for Leave Of Absence | Days | Self Cert Completed | Teaching / Non Teaching | Continued absence from previous month? | Has a Doctors Note been submitted? | Doctors Note Start | Doctors Note End | Is the [NAME] ongoing at the end of the month
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-30 00:00:00 | Sickness Absence | Heart (Pressure, Circulation etc)
 | Employee 1 | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | Sickness Absence | Mental Health (Stress / Anxiety etc)
 | Employee 1 | 2022-08-10 00:00:00 | 2022-08-12 00:00:00 | Sickness Absence | Back / Neck
 | Employee 1 | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | Dependant Care Paid
 | Employee 1 | 2022-08-24 00:00:00 | 2022-08-26 00:00:00 | Compassionate Paid
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-29 00:00:00 | Leave of Absence Paid |  | Fertility
 | Employee 1 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | Leave of Absence Unpaid |  | Study Leave
 | Employee 1 | 2022-05-05 00:00:00 | 2022-05-15 00:00:00 | Dependant Care Unpaid
 | Employee 1
 | Employee 1
Spreadsheet: 805774d1668906164-how-to-enter-in-an-if-function-to-capture-cell-data-pay-calculator_rev-08a
Sheet: ADO Build-Up Time

DATE | DAY | SHIFT [NAME] |  | TOTAL HOURS WORKED | DEFAULT HOURS |  |  | BUILD-UP TIME BASED ON DEFAULT HOURS |  | BUILD-UP TIME BASED ON WORK HOURS |  |  | BALANCE RE-CALCULATED BASED ON WORK DAYS |  |  |  | DEDUCT TO ZERO IF AN ADOC
 |  |  |  | Hrs:mins | hrs:mins format | Decimal format |  | TIME DEDUCTED (Decimal) | [NAME] | TIME DEDUCTED hrs:mins | RE-DISTRIBUTED BALANCE                                 hrs:mins |  | NOS. DAYS NOT DEDUCTED | DAYS DEDUCTED | DAILY BALANCE TO BE ADDED
WEEK 1
 | Monday | 'Work Calculator'!C10 | 'Work Calculator'!C10
 | Tuesday | 'Work Calculator'!C11
 | Wednesday
 | Thursday
 | Friday
 |  | WEEK 1 Sub-Total :
WEEK 2
 | Monday
 | Tuesday
 | Wednesday |  |  |  |  |  |  |  |  |  |  |  | 04:00:00 | Hours to be deducted for this 2 week pay period
 | Thursday |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Friday |  |  |  |  |  |  |  |  |  |  |  |  | Balance to be re-distributed over each day for the pay period
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Days worked over the pay period
 |  | WEEK 2 Sub-Total :
Spreadsheet: robin_rodrigue__33299__DUB_Phy
Sheet: Sheet1

(Positions in Cont. [NAME].)     From: |  |  |  |  |  | March |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT |  | Prior Day
To: |  |  |  |  |  | Index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Change
EES (Lambert)
Physical |  | DUBLIN | PHY | -63.39158539527621 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -63.39158539527621 |  | -60.58757860727633 |  | -2.804006787999874
Gas Daily |  | DUBLIN | M | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Basis - Notional |  | DUBLIN | D | 0 |  |  |  | -23.99431742492744 |  | -13.95341471572929 |  | -15.56630562365146 |  | -11.73106341962073 |  | -0.5177334320534767 |  | 2.490196109028965 |  | -16.04168731105734 |  | -425.2100467430154 |  | -539.2711751962164 |  | -433.0817025429787 |  | -1889.478378241293 |  | -129.0023092029454 |  | -0.3024223249271649 |  | -3495.660360069387 |  | -3495.660360069387 |  | 0
Basis - Equivalent |  | DUBLIN | D | 0 |  |  |  | -0.4282905453897993 |  | -0.4340883484217599 |  | -0.01211401443912267 |  | 0.5889531050532876 |  | -0.4193400608753129 |  | -0.2937869172274898 |  | -3.802752208141404 |  | 5.246296667832967 |  | 3.639234098583265 |  | 2.824460855882712 |  | 5.530568470627943 |  | -0.2316646385736487 |  | 0 |  | 12.20747646491164 |  | 12.20747646491164 |  | 0
Price |  | DUBLIN | P | 0 |  |  |  | 0.08789061094326903 |  | -0.3778530161331171 |  | 0.07623132463463123 |  | 0.322619769858301 |  | 0.7761282737477221 |  | 0.541786735821038 |  | 42.40142574739567 |  | 67.0451571899256 |  | 75.96462219421535 |  | -29.92880495056507 |  | -80.92672898905487 |  | 75.02484862977812 |  | 30.99567906558813 |  | 182.0030025861548 |  | 182.0030025861548 |  | 0
TOTAL: |  |  |  | -63.39158539527621 |  |  |  | -0.3403999344465303 |  | -0.811941364554877 |  | 0.06411731019550856 |  | 0.9115728749115886 |  | 0.3567882128724092 |  | 0.2479998185935482 |  | 38.59867353925426 |  | 72.29145385775857 |  | 79.60385629279861 |  | -27.10434409468235 |  | -75.39616051842692 |  | 74.79318399120447 |  | 30.99567906558813 |  | 130.8188936557902 |  | 133.6229004437901 |  | -2.804006787999874
Spreadsheet: 04f35b39-b56f-4078-849e-9b6e2392ea42
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  | toss | gain | probability | Rewards | Change in wealth | Utility
w (initial wealth) | 5 |  | 1 | 1 | 0.5 | 0.5 | -0.5108256237659905 | -0.2554128118829952
c (game fee) | 3 |  | 2 | 2 | 0.25 | 1 | -0.2231435513142097 | -0.3111986997115477
 |  |  | 3 | 4 | 0.125 | 1.5 | 0.1823215567939547 | -0.2884085051123033
 |  |  | 4 | 8 | 0.0625 | 2 | 0.6931471805599456 | -0.2450868063273067
 |  |  | 5 | 16 | 0.03125 | 2.5 | 1.280933845462064 | -0.2050576236566172
 |  |  | 6 | 32 | 0.015625 | 3 | 1.916922612182061 | -0.1751057078412725
 |  |  | 7 | 64 | 0.0078125 | 3.5 | 2.580216829592325 | -0.1549477638600825
 |  |  | 8 | 128 | 0.00390625 | 4 | 3.258096538021482 | -0.1422208242584361
 |  |  | 9 | 256 | 0.001953125 | 4.5 | 3.943521672487517 | -0.1345186334918589
 |  |  | 10 | 512 | 0.0009765625 | 5 | 4.632785353021065 | -0.1299944290455493
 |  |  | 11 | 1024 | 0.00048828125 | 5.5 | 5.323985113296614 | -0.1273948269394474