tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: larry_campbell__20969__Kingman Calcs
Sheet: Example

[NAME]
RED ROCK EXPANSION PROJECT
KINGMAN 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 = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
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 = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
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 = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
Particulate Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 385.80 [NAME]/hr x 6.6E-3 lb/MMBtu x 1.15
Annual (ton per year)
 | tpy = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
SO2 Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 385.80 [NAME]/hr x 3.4E-3 lb/[NAME] x 1.15
Annual (ton per year)
 | tpy = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
Formaldehyde Emissions
Maximum Hourly (lb/hr)
 | lb/hr = | maximum heat rate at 50% load at 95oF x AP42 factor lb/[NAME] x 1.15
 |  | 385.80 [NAME]/hr x 7.1E-4 lb/MMBtu
Annual (ton per year)
 | tpy = | [NAME] hourly (lb/hr) x 8760 hrs/yr x 1/2000 tons/lb
Spreadsheet: e00fb296-4f0a-4492-8d58-8f1da80c092f
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: |  |  | 2014-05-15 16:02:25.350000
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.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.6 | 102.475 | 102.35 | 101.975
4.5 | 102.513 | 102.388 | 102.263 | 101.888 |  | Note: | Refer To Price [NAME]
4.375 | 102.032 | 101.907 | 101.782 | 101.407 |  |  | For all Price Adjs
4.25 | 101.424 | 101.299 | 101.174 | 100.549
4.125 | 100.57 | 100.445 | 100.32 | 99.695
4 | 99.557 | 99.432 | 99.307 | 98.682
3.875 | 98.504 | 98.379 | 98.254 | 97.629
3.75 | 97.629 | 97.504 | 97.379 | 96.754
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.875 | 102.75 | 102.625 | 102.25
3.75 | 102.438 | 102.313 | 102.188 | 101.813
3.625 | 102.293 | 102.168 | 102.043 | 101.668
3.5 | 101.741 | 101.616 | 101.491 | 101.116
3.375 | 101.013 | 100.888 | 100.763 | 100.138
3.25 | 100.266 | 100.141 | 100.016 | 99.391
3.125 | 99.694 | 99.569 | 99.444 | 98.819 |  | 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 | 2014-05-29 16:02:25.350000
30 DAY | 2014-06-13 16:02:25.350000
45 DAY | 2014-06-28 16:02:25.350000
60 DAY | 2014-07-13 16:02:25.350000
90 DAY | 2014-08-12 16:02:25.350000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 596534d1541191943-conditional-formatting-how-to-highlight-rows-based-on-multiple-cell-values-my-copy-locker-assignments
Sheet: By Employee

Locker Assignments
Locker Number | Locker Location (North/South)
27 | North
9A | North
7A | North
11A | North
23 | North |  | North |  | South
11 | North |  | Top | Bottom | Top | Bottom
34 | North |  | 1A | 2A
13A | North |  | 3A | 4A
18A | North |  | 5A | 6A
29 | North |  | 7A | 8A
35 | North |  | 9A | 10A
9 | North |  | 11A | 12A
17 | North |  | 13A | 14A
14A | North |  | 15A | 16A
25 | North |  | 17A | 18A
6 | North |  | 1 | 2
5A | North |  | 3 | 4
 |  |  | 5 | 6
 |  |  | 7 | 8
4A | North |  | 9 | 10
 |  |  | 11 | 12
 |  |  | 13 | 14
30 | North |  | 15 | 16
12A | North |  | 17 | 18
6A | North |  | 19 | 20
1A | North |  | 21 | 22
 |  |  | 23 | 24
7 | North |  | 25 | 26
33 | North |  | 27 | 28
32 | North |  | 29 | 30
8 | North |  | 31 | 32
3A | North |  | 33 | 34
4 | North |  | 35 | 36
11 | South
10 | North
12 | North
14 | North
16A | North
11 | South
26 | North
21 | North
5 | North
15 | North
31 | North
18 | North
17A | North
2 | North
35 | South
1 | North
32 | South
25 | South
7 | South
2A | North
Spreadsheet: 98735d1297608616-vba-split-data-against-two-criteria-tables
Sheet: Sheet1

Table: |  |  |  |  |  |  |  |  |  | East |  |  |  |  |  |  | Central |  |  |  |  |  |  | South |  |  |  |  |  |  | Central
ID | Regions | Customer | item |  |  |  |  | mobile |  | pc |  | other |  |  | mobile |  | pc |  | other |  |  | mobile |  | pc |  | other |  |  | mobile |  | pc |  | other
A-1001 | East | Customer 1 | PC | EastPC | 1EastPC |  |  | A-1014 | Customer 14 | A-1001 | Customer 1 | A-1005 | Customer 5 |  |  |  | A-1010 | Customer 10 | A-1020 | Customer 20 |  | A-1003 | Customer 3 | A-1009 | Customer 9 | [NAME] | Customer 19 |  |  |  | A-1010 | Customer 10 | A-1020 | Customer 20
[NAME] | West | Customer 2 | Mobile | WestMobile | 1WestMobile |  |  | A-1017 | Customer 17 | A-1004 | Customer 4 | A-1007 | Customer 7 |  |  |  |  |  |  |  |  | A-1013 | Customer 13
A-1003 | South | Customer 3 | Mobile | SouthMobile | 1SouthMobile |  |  |  |  | A-1011 | Customer 11 | A-1021 | Customer 21
A-1004 | East | Customer 4 | PC | EastPC | 2EastPC |  |  |  |  | A-1015 | Customer 15
A-1005 | East | Customer 5 | Other | EastOther | 1EastOther
A-1006 | West | Customer 6 | Other | WestOther | 1WestOther
A-1007 | East | Customer 7 | Other | EastOther | 2EastOther
A-1008 | West | Customer 8 | Other | WestOther | 2WestOther
A-1009 | South | Customer 9 | PC | [NAME] | 1SouthPC
A-1010 | Central | Customer 10 | PC | CentralPC | 1CentralPC
A-1011 | East | Customer 11 | PC | EastPC | 3EastPC
A-1012 | West | Customer 12 | Mobile | WestMobile | 2WestMobile
A-1013 | South | Customer 13 | Mobile | SouthMobile | 2SouthMobile
A-1014 | East | Customer 14 | Mobile | EastMobile | 1EastMobile
A-1015 | East | Customer 15 | PC | EastPC | 4EastPC
A-1016 | West | Customer 16 | Mobile | WestMobile | 3WestMobile
A-1017 | East | Customer 17 | Mobile | EastMobile | 2EastMobile
A-1018 | West | Customer 18 | PC | WestPC | 1WestPC
[NAME] | South | Customer 19 | Other | SouthOther | 1SouthOther
A-1020 | Central | Customer 20 | Other | CentralOther | 1CentralOther
A-1021 | East | Customer 21 | Other | EastOther | 3EastOther
A-1022 | West | Customer 22 | Other | WestOther | 3WestOther
Spreadsheet: 78996d1279230028-excel-2007-transposing-3-columns-into-multiple-columns-test-spreadsheet-2
Sheet: Tranpose

Pupil Details |  | Aspirational Target
 | Subject
Name | Group
[NAME], [NAME] | Art&Des | B
 | CreatArt | A |  |  | Art&Des | CreatArt | D&T | English | Geography | History | Hu'ties | ICT | Maths | MFL | PE | Science
 | D&T | A |  | [NAME], [NAME] | B | A | A | A | A* | A | A | A | A* | A | A | A*
 | English | A |  | Allman, [NAME] | C | B | C | C | C | C | C | C | C | C | B | B
 | Geography | A* |  | [NAME],Mary | A | A | A | A | A | A | A | B | C | B | B | B
 | History | A
 | Hu'ties | A
 | ICT | A
 | Maths | A*
 | MFL | A
 | PE | A
 | Science | A*
Allman, [NAME] | Art&Des | C
 | CreatArt | B
 | D&T | C
 | English | C
 | Geography | C
 | History | C
 | Hu'ties | C
 | ICT | C
 | Maths | C
 | MFL | C
 | PE | B
 | Science | B
[NAME],Mary | Art&Des | A
 | CreatArt | A
 | D&T | A
 | English | A
 | Geography | A
 | History | A
 | Hu'ties | A
 | ICT | B
 | Maths | C
 | MFL | B
 | PE | B
 | Science | B
Spreadsheet: 5af2d500-54ec-4b2c-b944-d2f9e6eac817
Sheet: PPI 002

Permit No.: |  | WQ0035232 |  | Facility Name: |  | Arlington Place |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
PPI: |  | 002 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00940 | 31616 | 00610 | 00620 | 00600 | 00400 | 00665 | 70300 | 00530
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Composite | Grab | Composite | Composite | Composite | Grab | Composite | Composite | Composite
Monthly Limit: |  |  | 100000 | 10 |  | 14 |  |  | 4 |  | 2 |  | 15
Daily Limit: |  |  |  |  |  |  |  |  |  | 6-9
Sample Frequency: |  |  | [NAME] | 2 x Month | 3 x Year | 2 x Month | 2 x Month | 2 x Month | 2 x Month | 5 x Week | 2 x Month | 3 x Year | 2 x Month
Spreadsheet: 692823d1598595201-need-to-extract-data-and-skip-blanks-machine-shop-schedules_excel-forum-2003
Sheet: Plating Cost Calculator

 |  |  |  |  | PURCHASE ORDER ENTRY (Do not populate gray cells) |  |  |  |  |  |  | (Eastern!T2="X",Eastern!C2,0) | IFERROR(INDEX(Eastern!$T$2:$T$100,SMALL(IF(ISTEXT(Eastern!$T$2:$T$100),ROW(Eastern!$T$1:$T$100),""),ROW(Eastern!C2))),"") |  |  |  |  |  | 200
CNC / LASER ENTRY (Do not populate gray cells) |  |  |  |  | PO SUBTOTAL | 195 |  | Expedite: SAME DAY
 |  |  |  |  | PO WASTE FEE (5% of SUBTTL) | 39 |  | Expedite: NEXT DAY
P/N | L | W | REV | QTY | Total Dimensions | Cost per Part | Total QTY Cost
PN 6 | 8.423 | 6.762 | A1 | 4 | 126 | 8.82 | 35.28
PN 14 |  |  |  |  | 0 | 0 | 0
PN 15 |  |  | #N/A | #N/A | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
www.atlaspm.xxx/toms-tutorials-for-excel/toms-tutorials-for-excel-listing-noncontiguous-data-without-blanks/ |  |  |  |  | 0 | 0 | 0
PN 6 |  |  |  |  | 0 | 0 | 0
PN 14 |  |  |  |  | 0 | 0 | 0
PN 15 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A |  |  |  |  | 0 | 0 | 0
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 24

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | HT20 | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: 115750d1311264872-sumif-and-lookups-based-on-months-sample
Sheet: Data Feed

LeaseID | District | Property | Description | Acreage | Expiration Date | Bonus | Dollar amount
1001 | xxx | xx | Sec 6-15N-20W | 10 | 2012-04-16 00:00:00 | 30
1002 | xxx | xx | Sec 6-15N-20W | 10 | 2012-04-16 00:00:00 | 50
1003 | xxx | xx | Sec 7-14N-21W | 20 | 2012-05-01 00:00:00 | 50
1004 | xxx | xx | Sec 9-14N-21W | 30 | 2011-12-31 00:00:00 | 50
1005 | xxx | xx | Sec 8-14N-20W | 20 | 2012-01-15 00:00:00 | 75
1006 | xxx | xx | sec 5-15N-20W | 50 | 2013-04-13 00:00:00 | 25
1007 | xxx | xx | Sec 1090, Blk 89, E&II | 70 | 2013-04-01 00:00:00 | 30
1008 | xxx | xx | Sec 1090, Blk 89, E&II | 20 | 2013-05-16 00:00:00 | 50
1009 | xxx | xx | Sec 1090, Blk 89, E&II | 35 | 2013-05-16 00:00:00 | 50
1010 | xxx | xx | Sec 1544, Blk 90, E&II | 15 | 2013-07-07 00:00:00 | 50
1011 | xxx | xx | Sec 20-15N-20W | 40 | 2012-05-10 00:00:00 | 55
1012 | xxx | xx | Sec 15-14N-21W | 90 | 2014-04-09 00:00:00 | 75
1013 | xxx | xx | Sec 15-14N-21W | 40 | 2014-04-10 00:00:00 | 80
1014 | xxx | xx | Sec 4-14N-21W | 60 | 2013-07-10 00:00:00 | 60
1015 | xxx | xx | Sec 9-15N-21W | 65 | 2013-08-23 00:00:00 | 40
1016 | xxx | xx | Sec 6-14N-21W | 20 | 2011-09-15 00:00:00 | 20
Spreadsheet: daren_farmer__5906__hpl0606
Sheet: Sheet1

HPLN0606.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 06, 2000
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-06-06 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
Enron (FM) |  | LS HPL [NAME] |  | HPL | 40 | 40
Enron (FM) |  | HPL - Texoma |  | HPL | 20 | 20
 |  | Firm Summary
Enron (ES) |  | Oasis Sealy |  | ENA | 0 | 0
Enron (ES) |  | Reklaw |  | ENA | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65
Empire (Enron) |  | Delhi TOG #3 |  | Empire | 1.4 | 1.4
Empire (Enron) |  | Oasis Turbine |  | Empire | 7.95 | 7.95
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 767299d1644400754-filtering-data-semi-monthly-home-budget1
Sheet: Category PivotTable

 | Semi-Monthly Home Budget |  |  |  |  |  |  |  |  |  |  | CATEGORY PIVOT
 | This PivotTable is the data source for the Category Totals PivotChart on the Budget Report.
 | Row Labels | Sum of AMOUNT
 | Children | 150
 | Entertainment | 112
 | Food | 425
 | Household | 7880
 | Investment Accounts | 500
 | Medical | 500
 | Personal | 100
 | Pets | 150
 | Transportation | 925
 | Grand Total | 10742
Spreadsheet: 09235af8-59f8-4326-b26b-71919c32dc1f
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
 | Time Series Workbook
 | 9314.0 Sales of New Motor Vehicles, Australia
 | Table 1: New Motor Vehicles Sales by Type, All series
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aust. ;  Passenger vehicles ; |  |  | Original | A367169W | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Original | A367214W | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Original | A367259A | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Original | A367304A | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Seasonally Adjusted | A367170F | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Seasonally Adjusted | A367215X | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Seasonally Adjusted | A367260K | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Seasonally Adjusted | A367305C | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Trend | A367171J | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Trend | A367216A | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Trend | A367261L | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Trend | A367306F | 1994-01-01 00:00:00 | 2011-01-01 00:00:00 | 205 | Number | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 330382d1404737750-compare-cell-data-and-count-once-if-found-same-sample
Sheet: Sheet1

Shift Log Log Log for the period 1st June till 30th June 2014 |  |  |  | Shift Log Log Type | G | 1st | 2nd | R1st | R2nd | RNs
 |  |  |  |  | Actual | Proposed | Actual | Proposed | Actual | Proposed | Actual | Proposed | Actual | Proposed | Actual | Proposed | Actual | Proposed | Actual | Proposed | Actual | Proposed | Actual | Proposed | Eigible Shift days
S.No | Emp No | Employee Name | Department | Team Manager | 2014-06-01 00:00:00 |  | 2014-06-02 00:00:00 |  | 2014-06-03 00:00:00 |  | 2014-06-04 00:00:00 |  | 2014-06-05 00:00:00 |  | 2014-06-06 00:00:00 |  | 2014-06-07 00:00:00 |  | 2014-06-08 00:00:00 |  | 2014-06-09 00:00:00 |  | 2014-06-10 00:00:00
 |  |  |  |  | 0 | 0 | G | G | G | G | G | G | G | G | G | G | 0 | 0 | 0 | 0 | G | G | G | G | 7
 |  |  |  |  | 0 | 0 | 2nd | 2nd | 2nd | 2nd | 2nd | 2nd | 2nd | 2nd | 2nd | 2nd | 0 | 0 | 0 | 0 | Q14 | 2nd | 2nd | 2nd | 6
 |  |  |  |  | 0 | 0 | Q152 | 1st | Q152 | 1st | Q152 | 1st | Q152 | 1st | Q152 | 1st | 0 | 0 | 0 | 0 | 1st | 1st | 1st | 1st | 2
 |  |  |  |  | 0 | 0 | G | G | G | G | G | G | G | G | Q2 | G | 0 | 0 | 0 | 0 | Q2 | G | Q277 | G | 4
 |  |  |  |  | 0 | 0 | 1st | 1st | 1st | 1st | 1st | 1st | 1st | 1st | 1st | 1st | 0 | 0 | 0 | 0 | 1st | 1st | 1st | 1st | 7
 |  |  |  |  | 0 | 0 | G | G | G | G | G | G | G | G | G | G | 0 | 0 | 0 | 0 | G | G | G | G | 7
 |  |  |  |  | 0 | 0 | 1st | 1st | 1st | 1st | 1st | 1st | 1st | 1st | 1st | 1st | 0 | 0 | 0 | 0 | Q92 | 1st | Q92 | 1st | 5
 |  |  |  |  | 0 | 0 | G | 2nd | R2nd | R2nd | R2nd | R2nd | R2nd | R2nd | R2nd | R2nd | 0 | 0 | 0 | 0 | R2nd | R2nd | R2nd | R2nd | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] required
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | want to compare 'Actual' & "Proposed" Shift date wise
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and count once if same; ignore if Zero & Blank
Spreadsheet: 859703d1707993466-count-if-it-is-not-working-correctly-p1-aligw
Sheet: Total_Absence

Name | LATENESS | NO SHOW | OTHER LEAVE | PAID VACATION | SICK | SUSPENSION | UNAUTHORIZED ABSENCE
Mariah Carey
[NAME]
[NAME]
Adele
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Anna Carenina
[NAME]
[NAME]
[NAME]
Ariana Grande
[NAME]
[NAME]
Batistuta
[NAME]
[NAME]
Bontekoe Lars
[NAME]
Britney Spears
[NAME]
[NAME]
Camilla Carillo
Captain America
[NAME]
[NAME]
[NAME]
Channing Tatum
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Don Quixote
[NAME]
Dr. [NAME]
Dulcinea del Toboso
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Iron Man
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Mariah [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Mr. [NAME]
Nemanja Matic
[NAME]
[NAME]
[NAME]
Novak Djokovic
Obafemi Martins
[NAME]
[NAME]
[NAME]
Patrik
Pewdiepie
[NAME]
[NAME]
Rihanna
Rio Ferdinand
Rita Ora
[NAME]
[NAME]
[NAME]
[NAME]
Rodrygo
Ronaldinho
[NAME]
[NAME]
[NAME]
Sandra Bullock
Schwarzenegger
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Willy Wonka
[NAME]
[NAME]
Spreadsheet: 144166d1330737766-pivot-table-help-pivot-table-help
Sheet: SHEET 1

1 | a | 1
 | b
 | c | 2
2 | a
 | b | 3
 | c
 | d | 4
3 | a
 | b | 5
4 | a
 | b | 6
 | c
5 | a | 7
 | b
 | c | 8
6 | a
 | b | 9
 | c
 | d | 10
7 | a
8 | a | 11
 | b
 | c | 12
Spreadsheet: 50990d1250597737-display-different-text-based-on-data-list
Sheet: Sheet1

List | List | List |  | [NAME] | Type | Available |  |  | [NAME] | Type | Available
penny | roll | bank |  | nickel | loose | 0 |  |  | nickel | roll | store
nickel | loose | store |  |  |  | 0
dime |  | home
 |  | none
Display different text based on data
 |  |  |  | Some possible combinations
 |  |  |  | penny | roll | bank
 |  |  |  |  |  | store
 |  |  |  | penny | loose | none
 |  |  |  | nickel | roll | bank
 |  |  |  |  |  | store
 |  |  |  |  |  | home
 |  |  |  | dime | roll | bank
 |  |  |  |  |  | home
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 34946 | 40319
2 | 39334 | 40319
3 | 40051 | 40319
4 | 40002 | 40180
5 | 39860 | 40319
6 | 39756 | 40319
7 | 39047 | 40319
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  | 403061
2001-02-07 00:00:00
Spreadsheet: 05600073-5351-4007-9125-1be607e336ba
Sheet: Sheet1

Table S3 | Unnamed: 1
SNP Category | Median coverage
All | 50
ASM | 66
CpG disrupting | 49
non-CpG disrupting | 51
Promoter | 52
Intergenic | 51
First Exon | 51
First Intron | 51
Other Introns | 44
Other Exons | 48
3' Proximal | 54
CpG islands | 50
non-CpG islands | 49
Spreadsheet: 881718d1729860053-is-result-is-value-specific-text-should-be-shown-example_calculation-with-na
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Different calculation | Different calculation | Different calculation
1
2
3
4
5 |  |  |  | Skill 1 | Skill 2 | Skill 3 | Skill 4 | Skills 5 |  | A | B | C
NA |  |  | [NAME] | 4 | 4 | 5 | 5 | 4
 |  |  | [NAME] | 3 | 3 | NA | NA | 4
 |  |  | [NAME] | NA | NA | 2 | NA | 2
 |  |  |  |  |  |  |  |  |  | If a cell with NA is included in the calculation, the result must also give NA (instead of VALUE)
Spreadsheet: 693331d1598924707-countifs-for-previous-7-days-countifs-example
Sheet: Sheet1

User | Date | Asset | Status |  | [NAME] on Sheet 2
Alpha | 2020-08-06 00:00:00 | 123 | Revisit
Alpha | 2020-08-06 00:00:00 | 123 | Complete
Beta | 2020-08-06 00:00:00 | 123 | Passed
Gama | 2020-08-07 00:00:00 | 12 | Revisit
Delta | 2020-08-07 00:00:00 | 1 | Revisit
Gamma | 2020-08-08 00:00:00 | 1234 | Complete
Gamma | 2020-08-09 00:00:00 | 123 | Complete
Gamma | 2020-08-10 00:00:00 | 12 | Passed
Gamma | 2020-08-11 00:00:00 | 12 | Revisit
Gamma | 2020-08-11 00:00:00 | 1 | Revisit
Alpha | 2020-08-12 00:00:00 | 1 | Passed
Delta | 2020-08-13 00:00:00 | 1 | Passed
Delta | 2020-08-14 00:00:00 | 123 | Passed
Alpha | 2020-08-15 00:00:00 | 1212 | Revisit
Spreadsheet: eric_saibi__9949__110601
Sheet: Rockport 02

Owner Name |  | American Electric Power
Station Name |  | Rockport Power Station
Unit Name |  | Rockport 02
NERC Region |  | ECAR
State |  | IN
Fuel Type |  | Coal
Capacity |  | 1,300 MW
Start Date |  | 2001-11-03 00:00:00
End Date |  | 2001-11-05 00:00:00
Comments |  | Tube leak
SIC |  | 4911
Plant ID |  | 1010400
Unit ID |  | 1004663
Outage ID |  | 18805
Spreadsheet: 683513d1592804274-adding-indirect-function-to-an-existing-if-statement-sample-file_indirect-lookup
Sheet: Injury Condensed

team | Rowname | Colname | colstatus | name | status
1 | 2 | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1
1 |  | 1