tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 819102d1677214709-help-with-dependent-drop-down-lists-draft-work-book-risk-category
Sheet: ListCMC

Critical Risks | Top Event | Top Event Array Spilled Without Duplicates | Consequence | Mitigation | Uncontrolled Risk | Non Duplic URR | Controlled Risk | Non Duplic CRR | Mitigation | Control 2 | Control 3 | Control 4 | Control 5 | Control 6 | Control 7 | Control 8 | Control 9 | Control 10 | Control 11 | Control 12 |  |  |  |  |  | Residual Risk Rating |  | Risk Control Effectiveness
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low |  | Totally ineffective
Asset Failure | Asbestos Exposure | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal | Operational Requirements / Part 139 | Cleaning | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium |  | Largely ineffective
Breach of Security | Asbestos Exposure | COVID-19 Exposure - Frontline Operations contracting from Public | Personal Exposure | Chemical Training | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High |  | Partially effective
Chronic & Acute Impact on Health | Asbestos Exposure |  | Regional Exposure | Haz / Bio disposal | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Critical |  | Substantially effective
High Risk Work | Asbestos Exposure |  | Reputational | SOPs | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fully effective
Uncontrolled Release of Energy | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal |  | Slips, Trips and [NAME] | Containment | 0 |  | 0
Vehicles | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal |  |  | 0
 | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal |  |  | 0
 | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal |  |  | 0
 | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal |  |  | 0
 | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal |  |  | 0
 | COVID-19 Exposure - Frontline Operations contracting from Public |  |  | 0
 | COVID-19 Exposure - Frontline Operations contracting from Public
 | COVID-19 Exposure - Frontline Operations contracting from Public
 | COVID-19 Exposure - Frontline Operations contracting from Public
 | COVID-19 Exposure - Frontline Operations contracting from Public
 | COVID-19 Exposure - Frontline Operations contracting from Public
 | COVID-19 Exposure - Frontline Operations contracting from Public
 | COVID-19 Exposure - Frontline Operations contracting from Public
Spreadsheet: 769963d1645732441-want-to-sum-values-greater-than-a-specific-number-samplefile
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Sequence Values |  |  |  |  |  |  |  |  |  |  |  |  | Values | Expected Result | Expected Result
 |  | 1 |  |  |  |  |  |  |  |  |  | 3 | 8 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | 2 |  |  |  |  |  |  |  |  |  | 9 | 13 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | 4 |  |  |  |  |  |  |  |  |  | 14 | 18 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 2
 |  | -5
 |  | 6
 |  | 1
 |  | 5
 |  | 8
 |  | 7
 |  | 1
 |  | 6
 |  | 1
 |  | 5
 |  | 8
 |  | 6
 |  | 1
 |  | 5
 |  | 8
Spreadsheet: 0d30d346-b2a1-4843-abe7-b17c0a1ee1ab
Sheet: Physical records

Microsoft® Office SharePoint® Server 2010
Physical records planning worksheet
Fill this worksheet by using the following topics:
Physical records planning
Prepared by: |  |  |  | Date:
Physical Record | Record Category | Media | Properties | Processes | Policies | Forms | Content Type
signed NDA | legal document | paper | second party | add new record | expiration | N/A |  |  | example
 |  |  | date signed | destroy record | auditing |  |  |  | example
 |  |  | NDA type |  | barcode |  |  |  | example
 |  |  |  |  |  |  |  |  | example
model | project artifact | balsa wood | project | add new record | expiration | retrieve |  |  | example
 |  |  | model stage | destroy record | auditing |  |  |  | example
 |  |  | creator |  | barcode |  |  |  | example
 |  |  | creation date |  |  |  |  |  | example
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -2197 | -2135 |  | -25
2 | -2276 | -2135 | -4 | -25
3 | -2197 | -2135 |  | -25
4 | -2147 | -2135 |  | -25
5 | -2142 | -2135 |  | -25
6 | -2155 | -2135 |  | -25
7 | -2065 | -2135 |  | -25
8 | -2033 | -2135 | -2 | -25
9 | -2041 | -2135 | -2 | -25
10 | -2149 | -2135 |  | -25
11 | -2104 | -2135 |  | -25
12 | -2098 | -2135 |  | -25
13 | -2095 | -2135 |  | -25
14 | -2107 | -2135 |  | -25
15 | -2037 | -2135 |  | -25
16 | -2142 | -2135 |  | -25
17 | -2099 | -2135 |  | -25
18 | -2195 | -2135 |  | -25
19 | -2128 | -2135 |  | -25
20 | -2170 | -2135 |  | -25
21 | -2072 | -2135 |  | -25
22 | -1958 | -2135 |  | -25
23 | -2118 | -2135 | -7 | -25
24 | -2191 | -2135 |  | -25
25 | -2157 | -2135 |  | -25
26 | -2127 | -2135 |  | -25
27 | -2108 | -2135 |  | -25
28 | -1984 | -2135 |  | -25
29
30
31
index
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93989.4
2002-01-28 00:00:00
CBS Volume
 |  |  | 39070
Spreadsheet: 169755d1343051276-formula-across-multiple-sheets-salary-july-2012
Sheet: Jan

Sr. No. | Name | Designation | CTC | P.M. Salary | Ac/No. | Pay | Hold
1 | [NAME] | RM | 120000 |  | xxx3833 |  | 0
2 | [NAME] | RM | 120000 |  | [NAME] |  | 5000
3 | Zee | Sr. RM | 240000 |  | xxx6698 |  | 0
4 | Stanley | Team Leader | 360000 |  | xxx6871 |  | 0
5 | Ria | RM | 120000 |  | xxx8721 |  | 0
Spreadsheet: 868813d1715520265-vlookup-test-12-05-24-etaf
Sheet: Supplier Table

Supplier Code | Supplier
108 | Bryson Packaging
63 | Celbration Packaging
116 | Colpac
1 | Coppice
57 | [NAME]
114 | Foundation
2 | I2R
89 | Mister [NAME] (Caterline)
69 | RH Packaging
107 | [NAME]
101 | [NAME]
75 | Smith & Bateson Ltd
92 | Sovereign
62 | [NAME]
Spreadsheet: 396eebf8-0b8c-4017-9ae8-db10cebb0b0e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-09-13 09:27:23.540000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.702 | 101.577 | 101.452 | 101.077
4.25 | 101.275 | 101.15 | 101.025 | 100.65 |  | Note: | Refer To Price [NAME]
4.125 | 100.213 | 100.088 | 99.963 | 99.588 |  |  | For all Price Adjs
4 | 99.808 | 99.683 | 99.558
3.875 | 99.232 | 99.107 | 98.982
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 101.875 | 101.75 | 101.625 | 101.25
3.625 | 101.492 | 101.367 | 101.242 | 100.867
3.5 | 101.193 | 101.068 | 100.943 | 100.568
3.375 | 100.798 | 100.673 | 100.548 | 100.173
3.25 | 100.268 | 100.143 | 100.018
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-09-27 09:27:23.540000
30 DAY | 2011-10-12 09:27:23.540000
45 DAY | 2011-10-27 09:27:23.540000
60 DAY | 2011-11-11 09:27:23.540000
90 DAY | 2011-12-11 09:27:23.540000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 0f057144-50c5-4466-8b4d-ab32ffff4584
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
SPSA | Test | SPSA | Prostate-Specific Antigen (PSA) Screen, Serum | Prostate-Specific Ag Screen, S | Electrochemiluminescent Immunoassay (ECLIA) | Plain, Red-Top Tube: Red |  |  | 0.6 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 0.6 mL Additional Information:  1. Free prostate-specific antigen (PSA) can only be added to previously-submitted specimen within 12 hours of performing total PSA. [NAME] must have been shipped frozen. 2. Include patient's age. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Males: Age (Years)	PSA Upper Limit (ng/mL) <40	< or =2.0 40-49	< or =2.5 50-59	< or =3.5 60-69	< or =4.5 70-79	< or =6.5 > or =80	< or =7.2   Females: not applicable | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | G0103 |  |  |  |  | Rochester
SPSA | [NAME] | SERUM | Serum |  |  |  | Frozen | 180 days
SPSA | Result | SPSA | Prostate-Specific Ag Screen, S | Prostate-Specific Ag Screen, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 2857-1 | Prostate specific Ag:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 6890bb61-2b62-4f9c-8ea8-bf835b42b707
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
PAI1 | Test | PAI1 | Plasminogen Activator [NAME], Plasma | PAI-1 Ag, P | Enzyme-Linked Immunosorbent Assay (ELISA) | Light blue-top (3.2% Sodium Citrate) tube: LgtBlu |  |  | 1 | mL | See Coagulation Studies in Special Instructions.   Specimen Type: Platelet-poor plasma Collection Container/Tube: Light-blue top (citrate) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Spin down, remove plasma, and spin plasma again.  2. Freeze specimen immediately at < or =-40 degrees C, if possible. Additional Information:  1. Double-centrifuged specimen is critical for accurate results as platelet contamination may cause spurious results. 2. Each coagulation assay requested should have its own vial. | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK - refreeze - note to lab Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | 3-72 ng/mL | Thursday; 12 p.m. | 7 days | 12 days | 1 | 83520 |  |  |  |  | Rochester
PAI1 | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
PAI1 | Result | 86083 | PAI-1 Ag, P | PAI-1 Ag, P | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 22758-7
Spreadsheet: 202479d1356602132-sum-of-column-entries-based-on-value-in-other-column-sample
Sheet: Sheet1

id |  | value 1 |  | value 2 |  |  | Sample output
001 |  | 1800 |  | 4000 |  |  | id
001 |  |  |  |  |  |  | 1 | 5800
001 |  |  |  |  |  |  | 2 | 1700
001 |  |  |  |  |  |  | 3 | 1700
002 |  | 1700 |  |  |  |  | 4 | 2000
002 |  |  |  |  |  |  | 5 | 5000
002 |  |  |  |  |  |  | 6 | 5400
002
003 |  | 1700
003
003
004 |  | 2000
004
004
005 |  | 1800 |  | 3000
005 |  | 200
005
005
006 |  | 1800 |  | 3000
006 |  | 600
006
007 |  | 1500 |  | 3000
007 |  | 500
007
007
008 |  | 1500
008 |  | 0
008
008
009 |  | 1500
009
009
0010 |  | 1200
0010
0010
0010
Spreadsheet: 6ce91e5b-3a64-45cb-b4b5-7a7ecc887568
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
PBORB | Test | PBORB | Lyme Disease (Borrelia burgdorferi), Molecular Detection, PCR, Blood | Lyme Disease PCR, B | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME], leak proof vial: ScwLkPf |  |  |  |  | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Anticoagulants other than EDTA | Negative | Monday through Saturday (June through November) Monday through Friday (December through May) | 1 day | 4 days | 1 | 87476 |  |  |  |  | Rochester
PBORB | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 7 days
PBORB | Result | 56080 | Lyme Disease PCR, B | Lyme Disease PCR, B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32667-8 | Borrelia burgdorferi DNA:ACnc:Pt:[NAME]:Ord:Probe.amp.tar
Spreadsheet: 4cecbb92-35d4-4007-8fdb-04e2725b1527
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
2012-09-11 00:00:00 | State Senate District 19 - Republican
 | Rausch, r | Reisdorf, d | [NAME]
[NAME] | 1655
Hampstead | 728
Windham | 948 |  | 6
Totals | 3331 |  | 6
 | State Senate District 20 - Republican
 | [NAME], r | D'Allesandro, d | [NAME]
Goffstown | 1406 | 9 | 15
[NAME] 3 | 271 |  | 5
[NAME]* | 373 | 1 | 3
[NAME] 10 | 558 | 9 | 10
[NAME] 11 | 390 | 1 | 1
Totals | 2998 | 20 | 34
*correction received from ward clerk
 | State Senate District 21 - Republican
 | [NAME], r | [NAME], d | [NAME]
[NAME] | 220 | 1 | 9
[NAME] | 165 | 1 | 14
Madbury | 81 | 3 | 6
Newfields | 180
Newington | 81 |  | 1
Newmarket | 499 |  | 11
Portsmouth Ward 1 | 124 | 1 | 1
Portsmouth Ward 2 | 131 | 1 | 5
Portsmouth Ward 3 | 152 |  | 3
Portsmouth Ward 4 | 193 |  | 2
Portsmouth Ward 5 | 164 |  | 1
Totals | 1990 | 7 | 53
Spreadsheet: 684277d1593260444-date-format-issue-when-referencing-it-with-another-cell-template-client-project-planner_eh-aligw
Sheet: Project planner snapshot

ID | Tasks | Owner | Start Date | Duration | Priority |  | Status |  |  | ID |  |  |  |  | Task owners (Adhoc tasks excluded)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task meter (Adhoc tasks excluded)
 | Adhoc Tasks | Owner |  |  |  |  | Status |  |  | Adhoc queries
 | Opportunities for growth/upsells | Owner |  |  |  |  | Status
 |  |  |  |  |  |  |  |  |  | Meetings |  |  |  |  | On hold
 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | Not started
 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | In progress
 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  | Total Tasks
 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Priority tracker
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On hold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Tasks
Spreadsheet: vkaminski__40907__raptor2c
Sheet: Summary

 | Raptor II Daily Position Report & Summary
 | Inputs:
 | Trade Date |  | Prior Day
 | Summary:
 | Gains and Losses | Total | Realized | Unrealized
 | Previous Day's Cumulative
 | Today's Activity
 | Cumlative Ending
 | Notional Capacity
 | Credit Capacity
 | Remaining Governance Capacity
Spreadsheet: tori_kuykendall__39968__pasadena nov
Sheet: Sheet 1

City of Pasadena
Nov 2000 Invoice
 |  |  |  |  |  |  |  |  |  |  |  | Gas Daily | Gas Daily | Gas Daily | Gas Daily
 |  |  |  |  |  |  | Gas Daily | SoCal | Pasadena |  | Pasadena | Purchases | Purchases | Sales | Sales
[NAME] | 5.19 |  |  |  |  | Date | Mid | Usage | Net Nom | APEA | Imbalance | from EPMI | from EPMI | to EPMI | to EPMI
IFGMR EP San Juan | 4.41 |  |  |  |  |  | $/MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | $ | MMBtu | $
 |  |  |  |  |  | 2000-11-01 00:00:00 | 5.2 | 8253 |  | 3000
 |  |  |  | Amount |  | 2000-11-02 00:00:00 | 5.195 | 8430 |  | 3000
 | Border | Basin |  | Due |  | 2000-11-03 00:00:00 | 5.3 | 7522 |  | 3000
Pasadena | MMBtu | MMBtu | $/MMBtu | $ |  | 2000-11-04 00:00:00 | 5.445 | 6457 |  | 3000
Nomination |  |  |  |  |  | 2000-11-05 00:00:00 | 5.445 | 7683 |  | 3000
Fixed Price Nomination | 25000 | (this corresponds to the fixed price purchase) |  |  |  | 2000-11-06 00:00:00 | 5.445 | 9830 |  | 3000
APEA Nomination |  |  |  |  |  | 2000-11-07 00:00:00 | 5.455 | 9540 |  | 3000
Net Nomination |  |  |  |  |  | 2000-11-08 00:00:00 | 5.595 | 8148 |  | 3000
 |  |  |  |  |  | 2000-11-09 00:00:00 | 5.895 | 10157 |  | 3000
Usage |  |  |  |  |  | 2000-11-10 00:00:00 | 6.89 | 9797 |  | 3000
Less APEA Usage |  |  |  |  |  | 2000-11-11 00:00:00 | 6.785 | 8570 |  | 3000
Net Usage |  |  |  |  |  | 2000-11-12 00:00:00 | 6.785 | 8070 |  | 3000
 |  |  |  |  |  | 2000-11-13 00:00:00 | 6.785 | 12579 |  | 3000
Gas Supply |  |  |  |  |  | 2000-11-14 00:00:00 | 7.365 | 11070 |  | 3000
NGI Purchases |  |  |  |  |  | 2000-11-15 00:00:00 | 8.285 | 8358 |  | 3000
Fixed Price Purchases | 25000 |  | 5.94 |  |  | 2000-11-16 00:00:00 | 8.195 | 10744 |  | 3000
Gas Daily Purchases from Enron |  |  |  |  |  | 2000-11-17 00:00:00 | 8.125 | 8576 |  | 3000
Gas Daily Sales to Enron |  |  |  |  |  | 2000-11-18 00:00:00 | 9.595 | 8402 |  | 3000
 |  |  |  |  |  | 2000-11-19 00:00:00 | 9.595 | 10374 |  | 3000
Kern River Station Purchases |  |  |  |  |  | 2000-11-20 00:00:00 | 9.595 | 11596 |  | 3000
Indexed Price Purchases | 114477 |  |  |  |  | 2000-11-21 00:00:00 | 13.42 | 9468 |  | 3000
Total Purchases |  |  |  |  |  | 2000-11-22 00:00:00 | 17.345 | 9659 |  | 3000
El Paso Capacity Reimbursement |  |  |  |  |  | 2000-11-23 00:00:00 | 16.67 | 8925 |  | 3000
Fixed | 112128 |  |  |  |  | 2000-11-24 00:00:00 | 16.67 | 11424 |  | 3000
Variable |  |  |  |  |  | 2000-11-25 00:00:00 | 16.67 | 8174 |  | 3000
 |  |  |  |  |  | 2000-11-26 00:00:00 | 16.67 | 10606 |  | 3000
Net Due |  |  |  |  |  | 2000-11-27 00:00:00 | 16.67 | 11051 |  | 3000
 |  |  |  |  |  | 2000-11-28 00:00:00 | 5.855 | 10292 |  | 3000
El Paso Capacity Reimbursement | $/MMBtu |  |  |  |  | 2000-11-29 00:00:00 | 15.47 | 9545 |  | 3000
 |  |  |  |  |  | 2000-11-30 00:00:00 | 17.995 | 10330 |  | 3000
[NAME]
IFGMR San Juan |  |  |  |  |  | Totals
Spread
 | -0.015
Less Fuel
Less Variable | -0.026
Net Reservation Value
Spreadsheet: 147701d1332937153-vlookup-based-on-id-and-date-range-vlookup-for-id-and-date-within-a-range
Sheet: Sheet1

Emp Id | Starte Date in project | End Date in project | Project Name |  |  | Audit Date | Emp Id | Desired Result
1 | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 | Project1 |  |  | 2012-01-12 00:00:00 | 2 | Project1
2 | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 | Project1 |  |  | 2012-02-20 00:00:00 | 1 | Project2
3 | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 | Project1 |  |  | 2012-03-01 00:00:00 | 3 | Data Unavailable
1 | 2012-02-01 00:00:00 | 2012-02-28 00:00:00 | Project2
2 | 2012-02-01 00:00:00 | 2012-02-28 00:00:00 | Project2
3 | 2012-02-01 00:00:00 | 2012-02-28 00:00:00 | Project2
Spreadsheet: robin_rodrigue__33242__YTD Recon
Sheet: Sep 00

 |  | 2000-09-01 00:00:00 |  | 2000-09-05 00:00:00 |  | 2000-09-06 00:00:00 |  | 2000-09-07 00:00:00 |  | 2000-09-08 00:00:00 |  | 2000-09-11 00:00:00 |  | 2000-09-12 00:00:00 |  | 2000-09-13 00:00:00 |  | 2000-09-14 00:00:00 |  | 2000-09-15 00:00:00 |  | 2000-09-18 00:00:00 |  | MTD |  | YTD |  | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (as of 8/31)
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34601336
South |  |  |  |  |  |  |  | -56275 |  |  |  | -65413 |  | -299322 |  | -155697 |  |  |  | -44770 |  | 267337 |  |  |  | 5263447
Tholt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13810919
Lenhart |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3171259
Kuykendall |  |  |  |  |  |  |  | -22420 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5682608
Total
Spreadsheet: 144323d1330919505-identifying-duplicates-rather-than-removing-them-identifiying-duplicates
Sheet: Sheet1

a
c
j
i
a
b
l
c
d
m
g
g
h
i
a
b
k
g
e
d
Spreadsheet: 676397d1588784972-how-can-i-calculate-realised-profits-loss-after-each-sell-trade-date-trading-dashboard
Sheet: Trading Log

SG Market (Online only)
Minimum commission |  |  |  | 25
SGD | 50000 | and below |  | 0.0028
Above SGD | 50000 | to | 100000 | 0.0022
SGD above | 100000 |  |  | 0.0018
Clearing fee |  |  |  | 0.000325
SGX trading fee |  |  |  | 7.5e-05
US Market (Online only)
Minimum commission |  | 25 | or | 0.0018
SEC Charge |  | 2.21e-05 | (for sale transaction only)
GST for ALL markets |  | 0.07
Trade Date | Counter | Market | Action | No. of Shares | Initial Price | Fees | Cost (USD) | Cost (SGD) | Average Cost | Fx
2020-04-28 00:00:00 | BNO | US | Buy | 2900 | 6 |  |  |  |  | 1.4297
2020-05-01 00:00:00 | BNO | US | Sell | 2900 | 7.0001 |  |  |  |  | 1.4
2020-05-01 00:00:00 | BNO | US | Buy | 2550 | 6.9 |  |  |  |  | 1.42
2020-05-05 00:00:00 | BNO | US | Sell | 550 | 8.06 |  |  |  |  | 1.4048
2020-05-06 00:00:00 | BNO | US | Sell | 2000 | 8.02 |  |  |  |  | 1.4048
2020-05-06 00:00:00 | SDOW | US | Buy | 530 | 33.596 |  |  |  |  | 1.42
Spreadsheet: 769129d1645335646-index-match-solution-required-for-multiple-criteria-with-merged-cell-index-match-for-merged-cell
Sheet: Summary

Device | Working Ratio | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 | 2022-02-05 00:00:00
Water Meter | [NAME] | 100 | 100 | 100 | 100 | 100
 | Consumption Ratio | 96 | 0 | 0 | 90 | 80.4
 |  |  |  |  |  |  |  |  |  | Required Result
 |  |  |  |  |  |  |  |  |  | 2022-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  | Consumption Ratio
 |  |  |  |  |  |  |  |  | Water Meter
Spreadsheet: 696104d1600628891-sumifs-if-time-is-equal-to-or-between-start-and-stop-time-that-crosses-midnight-sum-ifs-past-midnight
Sheet: Sheet1

Total Time | Start Time | End Time | Code | Start Time 2 | End Time 2 |  | Result
 | 22:35:00 | 23:59:00 | 32 | 22:35:00 | 23:59:00
 | 21:40:00 | 00:01:00 | 32 | 21:40:00 | 00:02:00
 | 20:22:00 | 22:15:00 | 32 | 20:22:00 | 22:15:00
 | 23:00:00 | 00:15:00 | 10 | 23:00:00 | 00:15:00
 | 18:00:00 | 19:00:00 | 10 | 18:00:00 | 19:00:00
 | 22:23:00 | 23:45:00 | 32 | 22:23:00 | 23:45:00