tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f502bc39-6c7f-4d0d-8213-bce2ee21994e
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
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Total Construction: U.S. Total
 |  | Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2012
 |  | Data Extracted on: July 30, 2014 (5:45 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
Spreadsheet: 36da8d2d-d81f-4ab0-8316-ca014ae579f3
Sheet: Sheet1

 |  |  |  | Micro L.I.C Agents Comission Report
Sr.No. | Policy [NAME] | P.No. | D.O.C | Amount | Agent Name
1 | RAKESH KUMAR | 539083286 | 2010-05-28 00:00:00 | 200 | RAKESH KUMAR
2 | MADHU TIWARI | 539083278 | 2010-05-28 00:00:00 | 150 | CHITRANJAN KUMAR
3 | NEELAM MISHRA | 539083279 | 2010-05-28 00:00:00 | 100 | CHITRANJAN KUMAR
4 | RAMPUKARI DAS | 539083294 | 2010-05-28 00:00:00 | 100 | CHITRANJAN KUMAR
5 | RAMDEV DAS | 539083295 | 2010-05-28 00:00:00 | 100 | CHITRANJAN KUMAR
Spreadsheet: 111484d1307862447-vlookup-non-unique-data-multiple-values-array-formula-vlookup-non-unique-data-multiple-values-array-formula
Sheet: Sheet1

Raw | Data
A | 15 |  | A
B | 15 |  | B
C | 20 |  | C
A | 20
A | 25
A | 26
B | 27
Spreadsheet: 831036d1685366197-return-a-value-from-the-chart-sample-work-book-bethh_cnd-
Sheet: Seating Assignments

GUESTS | ID | Assigned | Table # |  |  | TABLE 1 - Numerical ID
NEEDS NAME | 1 |  |  |  |  | Table 1 | Table 2 | Table 3 | Table 4 | Table 5 | Table 6 | Table 7 | Table 8 | Table 9 | Table 10 | Table 11 | Table 12 | Table 13 | Table 14 | Table 15
[NAME] | 2 |  |  |  | 1 | 2 | 2
[NAME] | 3 |  |  | G | 2 | 3 | 10
[NAME] | 4 |  |  | N | 3 | 4
Greg | 5 |  |  | I | 4 | 5
Imogen | 6 |  |  | T | 5 | 6
Charlene | 7 |  |  | A | 6 | 7
[NAME] | 8 |  |  | E | 7 | 8
[NAME] | 9 |  |  | S | 8 | 9
Anna | 10
[NAME] | 11
George | 12 |  |  |  |  | Table 2 - Name THIS TABLE POPULATES AUTOMATICALLY
[NAME] | 34 |  |  |  |  | Table 1 | Table 2 | Table 3 | Table 4 | Table 5 | Table 6 | Table 7 | Table 8 | Table 9 | Table 10 | Table 11 | Table 12 | Table 13 | Table 14 | Table 15
[NAME] | 35 |  |  |  | 1
[NAME] | 36 |  |  | G | 2
[NAME] | 37 |  |  | N | 3
Danielle | 38 |  |  | I | 4
Emilie | 39 |  |  | T | 5
[NAME] | 40 |  |  | A | 6
[NAME] | 41 |  |  | E | 7
[NAME] | 42 |  |  | S | 8
Ian | 43
Erin | 44
[NAME] | 45
[NAME] | 46
Becky | 47
[NAME] | 48
Brittany | 49
Nathalie | 50
Amanda | 51
[NAME] | 52
[NAME] | 53
Heather | 54
[NAME] | 55
Mark | 56
[NAME] | 57
Meagan | 58
[NAME] | 59
Raj | 60
Garth | 61
Rose | 62
Kayla | 63
[NAME] | 64
[NAME] | 65
Spreadsheet: 883726d1732378621-excel-lookup-help-required-eoy-2024-new-eba
Sheet: YEAR END 2024

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE EVALUATION FORM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEAR END [2024]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE OF REVIEW:
 | EMPLOYEE
 | NAME
 | EMPLOYEE ID
 | DEPARTMENT |  |  |  |  | Claims & Network Management
 | POSITION |  |  |  |  | Senior Motor Claims Operations Manager
 | REPORTING TO |  |  |  |  | Deputy Chief Executive Officer
 | GRADE |  |  |  |  | 6
 | SECTION 2: CONTRIBUTION IN ACHIEVING BUSINESS OBJECTIVES (KPI)
 | EXCELLING PERFORMANCE |  |  |  |  |  |  |  |  |  | CONSISTENT PERFORMANCE |  |  |  |  |  |  |  |  |  | INCONSISTANT PERFORMANCE |  |  |  |  |  |  |  |  |  | UNDER PERFORMANCE
 | [ 4 ] |  |  |  |  |  |  |  |  |  | [ 3 ] |  |  |  |  |  |  |  |  |  | [ 2 ] |  |  |  |  |  |  |  |  |  | [ 1 ]
 | Delivered excellence for this KPI objective through own competence and contribution.  Exceeded expectations |  |  |  |  |  |  |  |  |  | Constantly delivered for this KPI objective by demonstrating what good looks like.  Supported in task completion |  |  |  |  |  |  |  |  |  | Required some additional guidence/work on understanding the KPI objective and competency to perform well |  |  |  |  |  |  |  |  |  | Missed the target/objective. Did not deliver what was required of the KPI objective through will or skill.  Needed additional probing to deliver
 | CATEGORY |  |  |  |  |  | KPI |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMP |  |  | MGR |  |  | SCORE
 | DELIVER FINANCIAL RESULTS |  |  |  |  |  | Maintain an ideal loss ratio for the motor claims department in line with company standards |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | ADVANCED OPERATIONS |  |  |  |  |  | Improve the internal operations in the motor claims department |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | SERVICE TO CUSTOMERS |  |  |  |  |  | IMPROVE CUSTOMER EXPERIENCE AND SATISFACTION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | LEARNING AND GROWTH |  |  |  |  |  | IMPROVE THE LEARNING AND GROWTH ENVIRONMENT WITHIN THE DEPARTMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | TOTAL
 | ADDITIONAL INSTRUCTIONS
 | ˃ Complete all Performance Appraisals within established timelines   ˃ Reviews will be based on facts and not assumptions or interpretations   ˃ Include all relevant information to support ratings   ˃ The Employee may provide any additional performance-related comments   ˃ Ensure the document is signed by all parties, i.e. [NAME], [NAME] and the Head of the Department prior to final submission to HR & Admin, Gov. PR Department
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [ Pg. 4 - 6 ]
Spreadsheet: 798600d1664570908-dates-not-calculating-correctly-understanding-dates-miscalculated
Sheet: Solution

Solution - Understanding Dates
Goal
 | Fill in the functions to answer the questions
Practice Questions
Practice Question 1
 | What is todays date?
Practice Question 2
 | What day will it be in one week from today?
Practice Question 3
 | What year was it 15 years ago from today?
Practice Question 4
 | What month will it be 4 months from today?
Practice Question 4
 | What day number is it today?
Practice Question 4
 | Use a formula to create a date using the answers to questions 4-6.
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5325

5325 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 685515d1594050255-permutations-and-outcomes-workbook-v1
Sheet: Manual 

 |  |  |  |  |  |  |  | Blister | Carton | Overlabel | IFU | Language | 2nd UPC | WORKFLOW
 |  |  |  |  |  |  |  | y | n | n | n | n | n
 |  |  |  |  |  |  |  | y | y | n | n | n | n
 |  |  |  |  |  |  |  | y | y | y | n | n | n
 |  |  |  |  |  |  |  | y | y | y | y | n | n
 |  |  |  |  |  |  |  | y | y | y | y | y | n
 |  |  |  |  |  |  |  | y | y | y | y | y | y
 |  |  |  |  |  |  |  | n | n | n | n | n | n
 |  |  |  |  |  |  |  | n | y | n | n | n | n
 |  |  |  |  |  |  |  | n | y | y | n | n | n
 |  |  |  |  |  |  |  | n | y | y | y | n | n
 |  |  |  |  |  |  |  | n | y | y | y | y | n
 |  |  |  |  |  |  |  | n | y | y | y | y | y
 |  |  |  |  |  |  |  | n | n | y | n | n | n
 |  |  |  |  |  |  |  | n | n | y | y | n | n
 |  |  |  |  |  |  |  | n | n | y | y | y | n
 |  |  |  |  |  |  |  | n | n | y | y | y | y
 |  |  |  |  |  |  |  | n | n | n | y | n | n
 |  |  |  |  |  |  |  | n | n | n | y | y | n
 |  |  |  |  |  |  |  | n | n | n | y | y | y
 |  |  |  |  |  |  |  | n | n | n | n | y | n
 |  |  |  |  |  |  |  | n | n | n | n | y | y
 |  |  |  |  |  |  |  | n | n | n | n | n | y
Spreadsheet: 732419d1620935517-help-with-indexing-formula-example-sheet
Sheet: Companies

Customer Number | Customer Name | City | Market Segment | Reps | Products
1 | Example 1 | City 1 | Market 1 | Rep 1 , Rep 3 , Rep 6 , Rep 8 , Rep 9 | Product 1 , Product 2 , Product 3 , Product 4 ,
2 | Example 2 | City 2 | Market 2 | Rep 2 , Rep 4 , Rep 6 , Rep 8 | Product 2 , Product 3, Product 4, Product 5
3 | Example 3 | City 3 | Market 3 | Rep 1 , Rep 3 | Product 3 , Product 2
Spreadsheet: 865989d1712926726-create-variable-rows-calculator
Sheet: Stress Test

Death Benefit | 100000
Annual Premiums | 2880
Current Value of Money | 0.06
Insurant's age on December 31 | 66
M/F | M
Mortality per StasCan | 18.79 | use
Years left to Term 90
Present Value of Financial Considerations
Life expectancy based on life insurance tables
Power Equation
Value of future proceeds
Year | Premium |  | Present Value at |  |  | Year | Premium |  | Present Value at
1 |  |  |  |  |  | 21 | 2880
2 | 2880 |  |  |  |  | 22 | 2880
3 | 2880 |  |  |  |  | 23 | 2880
4 | 2880 |  |  |  |  | 24 | 2880
5 | 2880 |  |  |  |  | 25
6 | 2880 |  |  |  |  | 26
7 | 2880 |  |  |  |  | 27
8 | 2880 |  |  |  |  | 28
9 | 2880 |  |  |  |  | 29
10 | 2880 |  |  |  |  | 30
11 | 2880 |  |  |  |  | 31
12 | 2880 |  |  |  |  | 32
13 | 2880 |  |  |  |  | 33
14 | 2880 |  |  |  |  | 34
15 | 2880 |  |  |  |  | 35
16 | 2880 |  |  |  |  | 36
17 | 2880 |  |  |  |  | 37
18 | 2880 |  |  |  |  | 38
19 | 2880 |  |  |  |  | 39
20 | 2880 |  |  |  |  | 40
Cost of life insurance (PV)
Value of Insurance Proceeds
NET VALUE
net value should be |  | or more
Spreadsheet: 634a7cf3-7deb-48e0-bf07-19e659ef4f42
Sheet: Sheet1

Start Date | End Date | Meeting Name | HQ Hotel | Venues | Attendees
2014-10-20 00:00:00 | 2014-10-20 00:00:00 | Nevada Future Business Leaders Fall Leadership Extravaganza | Cashman Center | Cashman Center | 650
2014-10-25 00:00:00 | 2014-10-25 00:00:00 | Seventh-Day Adventist Church Nevada / Utah Conference Las Vegas Convocation | Cashman Center | Cashman Center | 5000
2014-11-22 00:00:00 | 2014-11-22 00:00:00 | Milan Institute Graduation Ceremony | Cashman Center | Cashman Center | 1500
Spreadsheet: 708966d1608114394-time-values-issue-time-example
Sheet: Sheet1

Handling Time Seconds | [NAME] (hh:[NAME]:ss) | Hours
27690 |  | 7.69
717338 |  | 199.26
698890 |  | 194.13
595078
544254
492075
826939
744801
762190
737274
749678
526002
440906
905441
809004
833735
837859
724030
663966
491531
954210
792897
817303
828762
757158
465947
366306
780690
793702
720240
620709
596359
461890
379255
649108
610811
Spreadsheet: 805860d1668963737-formula-to-count-blank-cells-from-column-where-the-rows-range-changes-s666-pq-count-blank-cells-from-column-where-the-rows-range-changes
Sheet: Sheet1

Notes | Worker | Status |  | Status | Count
 | Name1 |  |  |  | 16
 | [NAME] | x
 | Name3 |  |  |  |  | Blank cell count from column c
 | Name4
 | Name5
 | Name6
 | Name7 | m
 | Name8
 | Name9
 | Name10
 | Name11 | d
 | Name12
 | Name13
 | Name14
 | Name15 | c
 | [NAME]
 | Name17
 | Name18
 | Name19
 |  | zz
Spreadsheet: 63030d1264000724-help-compiling-data-on-a-summary-page-depending-on-drop-down-menu-choices-example-a-
Sheet: Staff

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
2 | Year 1
3
4
5
6
2 | Year 2
9
4
15
16
Spreadsheet: 59164d1259629921-set-cell-to-take-value-from-most-recently-filled-in-column-709101-set-cell-to-take-value-from-most-recently-filled-in-column
Sheet: Sheet1

Original Amount | Percent Spent Recent Month | Cumulative |  | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2010-01-01 00:00:00
12000 | 0.2 | 0.3 | Program 1 | 1200 | 2400
14000 |  |  | Program 2
16000 |  |  | Program 3
18000 |  |  | Program 4
20000 |  |  | Program 5
22000 |  |  | Program 6
24000 |  |  | Program 7
26000 |  |  | Program 8
28000 |  |  | Program 9
30000 |  |  | Program 10
Spreadsheet: 202562d1356629138-offset-match-vs-index-match-example
Sheet: Volume_v06

 |  | Actuals22
 |  | Quarter | 1 | 1 | 1 | 2 | 2 | 2
 |  | Month | 1 | 2 | 3 | 4 | 5 | 6
 |  | Year | 2010 | 2010 | 2010 | 2010 | 2010 | 2010
 | R |  | Actual | Actual | Actual | Actual | Actual | Actual
 | 1 | Total Openings 000s | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00
 | 1.01 | West Division | 1 | 1 | 1 | 1 | 1 | 1
 | 1.55 | W/MW/NW Division | 2 | 2 | 2 | 2 | 2 | 2
 | 1.56 | fmr Alliance | 3 | 3 | 3 | 3 | 3 | 3
 | 1.565 | Subtotal WEST (Kathy) | 4 | 4 | 4 | 4 | 4 | 4
 | 1.21 | Eastern Division | 5 | 5 | 5 | 5 | 5 | 5
 | 1.4 | Central Division | 6 | 6 | 6 | 6 | 6 | 6
 | 1.22 | FAHWC (FL) | 7 | 7 | 7 | 7 | 7 | 7
 | 1.569 | Subtotal EAST (Suzan) | 8 | 8 | 8 | 8 | 8 | 8
 | 1.23 | old Subtotal Eastern Div'n (Trae) incl. FAHWC | 9 | 9 | 9 | 9 | 9 | 9
Spreadsheet: 731146d1620209647-need-help-merging-info-from-two-tables-report-template-test3
Sheet: Registry

ID | Name | Department | Executive Sponsor | [NAME] | Project Manager | Program | Target Completion Date | Status | Percent Complete | Overall Health | Scope Health | Schedule Health | Resources Health
12 | Consulting Agreements | Advisory Fees | [NAME] | [NAME] | [NAME] | Data | 2021-06-30 00:00:00 | In Progress | 0.75 | On Track | On Track | On Track | On Track
60 | Enterprise CRM | Marketing Operations | [NAME] | [NAME] | [NAME] | CRM | 2023-06-30 00:00:00 | In Progress | 0.25 | At Risk | On Track | At Risk | At Risk
Spreadsheet: 270844d1381706932-need-to-count-one-cell-if-another-contains-specific-text-example
Sheet: Sheet1

Products | Sales |  | Total Here | Products | Packet Size | Write Your Criteria Below | Helper Column to find What Contains A,B,C,D and So On | Copy this Column Here and paste as values only
Grass | 120 |  |  | Grass | A | a |  | Grass
Sead | 420 |  |  | Sead | B |  |  | Tree
Plant | 32 |  |  | Plant | B |  |  | Corn
Tree | 6 |  |  | Tree | A
Corn | 74 |  |  | Corn | A
Fence | 34 |  |  | Fence | C
Goat | 23 |  |  | Goat | D
Spreadsheet: 2a8b0630-ee2b-413e-a701-14f81a2a3dc6
Sheet: Sheet1

Table S1.  Sequences of the primers used for stem-loop RT-PCR | Unnamed: 1 | Unnamed: 2
miRNA | Name | Sequence(5'-3')*
sja-miR-7-5p | RNA | UGGAAGACUGGUGAUAUGUUGUU
 | RT stem-loop primer | GTCGTATCCAGTGCAGGGTCCGAGGTATTCGCACTGGATACGACAACAACAT
 | Forward primer | ATCGTACGTGGGTGGAAGACTGGTGAT
sja-miR-61 | RNA | UGACUAGAAAGUGCACUCACUU
 | RT stem-loop primer | GTCGTATCCAGTGCAGGGTCCGAGGTATTCGCACTGGATACGACAAGTGAGT
 | Forward primer | ATCGTACGTGGGTGACTAGAAAGTGCA
sja-miR-219-5p | RNA | UGAUUGUCCAUUCGCAUUUCUUG
 | RT stem-loop primer | GTCGTATCCAGTGCAGGGTCCGAGGTATTCGCACTGGATACGACCAAGAAAT
 | Forward primer | ATCGTACGTGGGTGATTGTCCATTCGC
sja-miR-125b | RNA | UCCCUGAGACUGAUAAUUGCU
 | RT stem-loop primer | GTCGTATCCAGTGCAGGGTCCGAGGTATTCGCACTGGATACGACAGCAATTA
 | Forward primer | [NAME]
sja-miR-125a | RNA | UCCCUGAGACCCUUUGAUUG
 | RT stem-loop primer | GTCGTATCCAGTGCAGGGTCCGAGGTATTCGCACTGGATACGACCAATCAAA
 | Forward primer | ATCGTACGTGGGTCCCTGAGACCCTTT
sja-miR-124-3p | RNA | UAAGGCACGCGGUGAAUGUCA
 | RT stem-loop primer | GTCGTATCCAGTGCAGGGTCCGAGGTATTCGCACTGGATACGACTGACATTC
 | Forward primer | ATCGTACGTGGGTAAGGCACGCGGTG
sja-miR-1 | RNA | UGGAAUGUGGCGAAGUAUGGUC
 | RT stem-loop primer | GTCGTATCCAGTGCAGGGTCCGAGGTATTCGCACTGGATACGACGACCATAC
 | Forward primer | ATCGTACGTGGGTGGAATGTGGCGAAG
sja-bantam | RNA | UGAGAUCGCGAUUAAAGC
 | RT stem-loop primer | GTCGTATCCAGTGCAGGGTCCGAGGTATTCGCACTGGATACGACGCTTTAAT
 | Forward primer | ATCGTACGTGGGTGAGATCGCGATTAAA
sja-miR-71b-5p | RNA | UGAAAGACUUGAGUAGUGAGACG
 | RT stem-loop primer | GTCGTATCCAGTGCAGGGTCCGAGGTATTCGCACTGGATACGACCGTCTCAC
 | Forward primer | ATCGTACGTGGGTGAAAGACTTGAGTAG
sja-miR-3479-5p | RNA | AGGUGGAUGUUAGUGCAAUUUA
 | RT stem-loop primer | GTCGTATCCAGTGCAGGGTCCGAGGTATTCGCACTGGATACGACTAAATTGC
 | Forward primer | ATCGTACGTGGGAGGTGGATGTTAGTG
sja-Novel-23-5p | RNA | UCAGCUGUGUUCAUGUCUUCGA
 | RT stem-loop primer | [NAME]
 | Forward primer | ATCGTACGTGGGTCAGCTGTGTTCATG
 | Common reverse primer | GCAGGGTCCGAGGTATTC
Spreadsheet: phillip_m_love__30143__9911_OA
Sheet: ONT_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ALL
REGION:  ONTARIO
 |  |  | 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 | 29124134 | 93298632
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 2467938 | 7302508
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 31592072 | 100601140
 | Purchases:
6 |  | 3rd Party / Inter Enron | -27025350 | -87314096
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -4606171 | -14726977
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -31631521 | -102041073
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 39449 | 92310.66
23 | Fuel: |  | 0 | 0
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | -3231
 | Total Transport Expense: |  | 0 | -3231
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 695659.5228982903
31 |  | Prior Month Book Balance | 0 | 837625
 |  | Total MTM Income | 0 | 1533284.52289829
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -125217
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -77
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 19990
 |  | TOTAL INTRA-MTH
FT-Ontario
 |  | Current Month MTM | 0 | 686492
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: larry_campbell__20963__Flagstaff1
Sheet: Example

[NAME]
RED ROCK EXPANSION PROJECT
FLAGSTAFF COMPRESSOR STATION
Table 6
EXAMPLE EMISSION CALCULATIONS
GE LM2500 TURBINE
[NAME]
Maximum Hourly (lb/hr)
 | lb/hr = | maximum hourly emission rate at 64% load at 00F x 1.15
Annual (ton per year)
 | tpy = | (80% x annual avg emission rate) + (20% x annual emission rate based on maximum hourly) x 1.15
 |  | (0.8 x 99.43) + (0.2 x 110.81) x 1.15
CO Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum hourly emission rate at 64% load at 00F x 1.15
Annual (ton per year)
 | tpy = | (80% x annual avg emission rate) + (20% x annual emission rate based on maximum hourly) x 1.15
 |  | (0.8 x 60.44) + (0.2 x 67.45) x 1.15
VOC Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum hourly emission rate at 64% load at 0oF x 10% NMHC x 1.15
Annual (ton per year)
 | tpy = | ((80% x annual avg emission rate) + (20% x annual emission rate based on maximum hourly)) x 10% NMHC x 1.15
 |  | ((0.8 x 20.59) + (0.2 x 23.65)) x 0.1 x 1.15
Particulate Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 352.24 MMBtu/hr x 6.6E-3 lb/MMBtu x 1.15
Annual (ton per year)
 | tpy = | avg heat rate at base load at 60oF x AP42 factor lb/MMBtu x 8760 hrs/yr x 1 ton/2000 lbs x 1.15
 |  | 192.80 [NAME]/hr x 6.6E-3 lb/MMBtu x 8760 / 2000 x 1.15
SO2 Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 352.24 MMBtu/hr x 3.4E-3 lb/[NAME] x 1.15
Annual (ton per year)
 | tpy = | avg heat rate at base load at 60oF x AP42 factor lb/MMBtu x 8760 hrs/yr x 1 ton/2000 lbs x 1.15
 |  | 192.80 [NAME]/hr x 3.4E-3 lb/MMBtu x 8760 / 2000 x 1.15
Formaldehyde Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 352.24 MMBtu/hr x 7.1E-4 lb/[NAME] x 1.15
Annual (ton per year)
 | tpy = | avg heat rate at base load at 60oF x AP42 factor lb/MMBtu x 8760 hrs/yr x 1 ton/2000 lbs x 1.15
 |  | 192.80 [NAME]/hr x 7.1E-4 lb/MMBtu x 8760 / 2000 x 1.15
Spreadsheet: 660920d1580802152-formula-to-find-the-value-from-on-column-based-on-same-name-and-date-question
Sheet: Sheet1

DATA 1 |  |  |  |  | DATA 2
 | Start Date | End Date | Value |  |  | Date | Value?
[NAME] | 2000-01-05 00:00:00 | 2001-01-05 00:00:00 | Text1 |  | [NAME] | 2002-02-01 00:00:00 | Text2 | Need formula to find the value from  D:D based on same name and date range in B:C
[NAME] | 2002-01-05 00:00:00 | 2003-01-05 00:00:00 | Text2 |  | [NAME] | 2000-02-01 00:00:00 | Text1
[NAME] | 2002-01-05 00:00:00 | 2003-01-05 00:00:00 | Text3 |  | [NAME] | 2002-03-01 00:00:00 | Text3
[NAME] | 2003-01-05 00:00:00 | 2004-01-05 00:00:00 | Text4 |  | [NAME] | 2002-04-01 00:00:00
Mark | 2004-01-05 00:00:00 | 2005-01-05 00:00:00 | Text5 |  | Mark | 2002-05-01 00:00:00
[NAME] | 2005-01-05 00:00:00 | 2006-01-05 00:00:00 | Text6 |  | [NAME] | 2002-06-01 00:00:00