tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2213f14d-5114-47ee-800f-4487fe84cd69
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | McCoy-Davis | Regina | [EMAIL] | [PHONE] |  | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | McNair | Emilie | [EMAIL] | [PHONE] |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Wilson | [NAME] | [EMAIL] | [PHONE] | 36-334-7264 | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | [NAME] | Louis | [EMAIL] | [PHONE] |  | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | [NAME] | Leah | [EMAIL] | [PHONE] |  |  |  | Raleigh | NC | 27695
UNC Asheville | Cutspec | [NAME] | [EMAIL] | [PHONE] |  | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Covington | [NAME] | [EMAIL] | [PHONE] |  |  |  | Chapel Hill | NC | 27599
UNC Charlotte |  |  |  |  |  | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Saxton | Tresa | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | Bullard | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Wesner | Katrin | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | Potter | [NAME] | [EMAIL] | [PHONE] |  | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University |  |  |  |  |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | [NAME] | Ether | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics |  |  |  |  |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 63966d1264801984-lookup-and-produce-a-subset-without-arrays-excelobjectivestatemenexample
Sheet: Sheet1

Objective:  By selecting Group in Output Table, bring over the desired services that are billable in that PG
 | with each in its own row.  No error codes appearing on empty rows.
 | Service & Rate Table |  |  |  |  |  |  |  |  |  |  | Dropdown for Groups
 |  |  |  |  |  |  |  |  |  |  |  | Group1
 |  | Service is billable in: |  |  |  |  |  |  |  |  |  | Group2
 | Name | Group1 | Group2 | Group3 | Group4 | Rate | Unit |  |  |  |  | Group3
 | Service 1 | 1 | 1 |  |  | 10 | 15 |  |  |  |  | Group4
 | Service 2 |  | 1 | 1 |  | 20 | 15
 | Service 3 | 1 |  | 1 | 1 | 30 | 20
 | Output Table |  |  |  |  |  | Example of Output Table with Group = Group3 Red signifies input data from Service & Rate Table
 | Select Group=> | Group1 |  |  |  |  | Select Group=> | Group3
 | Service Name | Rate | Unit | Total |  |  | Service Name | Rate | Unit | Total
 | Service 1 | 10 | 15 | 150 |  |  | Service 2 | 20 | 15 | 300
 |  |  |  | 0 |  |  | Service 3 | 30 | 20 | 600
 | Service 3 | 30 | 20 | 600 |  |  |  |  |  | 0
 |  |  |  | 750 |  |  |  |  |  | 900
Spreadsheet: 221344d1363488587-time-calculations-man-hour-calculator
Sheet: Sheet1

 |  | # of Crew | AM
 |  | 3 | PM
Start Time | AM/PM | End Time | AM/PM | Total Hours
07:30:00 | AM | 09:00:00 | AM
Start Time | AM/PM | End Time | AM/PM | Total Hours
09:05:00 | AM | 11:00:00 | AM
Start Time | AM/PM | End Time | AM/PM | Total Hours
11:03:00 | AM | 12:10:00 | PM
Start Time | AM/PM | End Time | AM/PM | Total Hours
12:50:00 | PM | 02:30:00 | PM
Spreadsheet: 552343d1513504061-how-to-sort-by-shift-and-only-count-unique-names-users-shift-and-uniquename
Sheet: Sheet1

Shift | Name
Shift 1 | Mario |  |  | Shift 1
Shift 2 | [NAME] |  |  | Shift 2
Shift 3 | [NAME] |  |  | Shift 3
Shift 4 | [NAME] |  |  | Shift 4
Shift 1 | Mario
Shift 1 | Duie
Shift 2 | [NAME]
Shift 3 | [NAME]
Shift 4 | Jessica
Shift 1 | [NAME]
Shift 2 | Mario
Shift 3 | [NAME]
Shift 4 | [NAME]
Spreadsheet: 723703d1615841199-how-to-display-named-range-in-the-formula-based-result-book5
Sheet: TASK#2

0 | apple |  | Left hand side table is data. It is assigned named range "MY_TABLE"
1 | ball |  | below table is another set of data. It is assigned named range "MY_CITY"
2 | cat |  | AA | san jose
3 | dog |  | BB | san francisco
4 | egg |  | CC | dallas
5 | frog |  | DD | napa
6 | goat |  | EE | [NAME]
user input | Need formula to generate below output
1 | MY_TABLE_ball | NOTES : if user any number from MY_TABLE, then the formula should display "named range" followed by "_" followed by "data corresponding to that number from the above table"
2 | MY_TABLE_cat
AA | [NAME]
BB | MY_CITY_san francisco
Spreadsheet: 328399d1403886953-sumproduct-with-different-sized-arrays-oeldere-328325d1403873088-sumproduct-with-different-sized-arrays-sumproductexample3
Sheet: Sheet1

Code | Rank
1003 | 11
1004 | 22
1005 | 13
1007 | 30
1012 | 55
1014 | 11
1015 | 22
1016 | 13
1017 | 30
1018 | 55
1019 | 11
1003 | 22
1003 | 22
1012 | 30
1016 | 11
1019 | 55
Spreadsheet: 159605d1338772131-specialized-sum-formula-example
Sheet: Example

 |  |  |  |  |  | List of Numbers to Sum (With Range K3:O3)-->> |  |  |  | 1 | 3 | 11 | 0 | 7
Quantity of #s to Sum |  |  |  |  |  |  |  |  |  |  |  |  |  | This is the answer the formula would produce
3 |  |  |  |  |  |  |  |  |  |  |  |  | Sum the last 3 numbers from the above range in this cell (excluding the last number) -->> | 14
3.25 |  |  |  |  |  |  |  |  |  |  |  |  | Sum the last 3.25 numbers from the above range in this cell (i.e. the first three and 1/4 of the fourth) in this cell (excluding the last number) -->> | 14.25
6 |  |  |  |  |  |  |  |  |  |  |  |  | If 6 is more than the numbers in the range, then sum them all (excluding the last number) -->> | 15
0.5 |  |  |  |  |  |  |  |  |  |  |  |  | Since 0.5 is less than 1, just sum that percentage of the last number -->> | 3.5
0 |  |  |  |  |  |  |  |  |  |  |  |  | Since 0 is 0, the answer should be 0 -->> | 0
 | If It is possible, I would like to exclude any columns that are empty in the calculation (but this is not critical if it overcomplicates the formula).
 | By the way... What I am attempting to do here is to build a DSO (Days Sales Outstanding) formula for a monthly model. So, 3 would equal 3 months DSO, 0.5 would equal 15 days DSO, etc.
 | The numbers across the top would be my sales figures every month, the numbers to the left would be the DSO, and the output would be the resulting Accounts Receivable.
 | If you have any better solution than the formula I describe above, please let me know. I am trying to avoid the basic DSO caclulation (i.e., DSO * Sales / days = AR).
Spreadsheet: 272571d1382434627-lookup-please-help-or-do-i-need-a-macro-test-excel-forum-2
Sheet: KIT001

EMBARK DATE | EMBARK LOCATION | DISEMBARK LOCATION | EXPORT LICENSE | DISEMBARK DATE | START STATE | DATE | PROJ | VESSEL | ROUNDS FIRED | TEAM LEADER | [NAME] | END STATE | [NAME]
2013-04-05 00:00:00 | MARUITUS | 18N - SEA LION |  | 2013-05-04 00:00:00 | 850 | 2013-04-06 00:00:00 | 13.137 | Vessel A | 8 | Curly watts | Test Fire/Zero |  | Complete
2013-06-30 00:00:00 | 18N - SEA LION | GALLE |  | 2013-07-09 00:00:00 |  | 2013-06-30 00:00:00 | 13.189 | Vessel C | 6 | [NAME] | Test Fire/Zero |  | Complete
2013-07-17 00:00:00 | GALLE | 18N - SEA LION |  | 2013-07-28 00:00:00 |  |  | 13.194 | Vessel N |  | [NAME]
2013-08-05 00:00:00 | 18N - SEA LION | FUJ - SOHA FOLK |  | 2013-08-12 00:00:00 |  | 2013-08-07 00:00:00 | 13.216 | Vessel I | 6 | [NAME] | Test Fire/Zero |  | Complete
Spreadsheet: 733869d1621863343-format-for-countifs-specifc-data-and-date-field-audience-analysis-2
Sheet: Audience Demographics

 | [NAME] |  |  |  |  |  |  |  |  |  | Row Labels | Count of Date2
 | FOR EACH QUARTER, PLEASE RECORD THE ACTUAL NUMBER OF SURVEY REPOSNSES TO EACH CATEGORY IN THE WHITE CELLS |  |  |  |  |  |  |  |  |  | Qtr1 | 6
 |  |  | Annual target | Q1 actuals | Q2 actuals | Q3 actuals | Q4 actuals | Annual total % |  |  | Feb | 6
 | TOTAL NUMBER OF AUDIENCE SURVEYS COLLECTED |  |  |  |  |  |  |  |  |  | Qtr2 | 4
 | Gender | Female |  |  |  |  |  |  |  |  | May | 4
 |  | Male |  |  |  |  |  |  |  |  | Qtr4 | 15
 |  | Non-binary |  |  |  |  |  |  |  |  | Dec | 15
 |  | Intersex |  |  |  |  |  |  |  |  | Grand Total | 25
 |  | Prefer to self-identify
 |  | Prefer not to say / did not answer
 | Gender Identity | Yes
 |  | No
 |  | Prefer to use own term
 |  | Prefer not to say / did not answer
 | Age | Age 0 to 15
 |  | Age 16-19
 |  | Age 20-24
 |  | Age 25-30
 |  | Age 31-34
 |  | Age 35-39
 |  | Age 40-49
 |  | Age 50-59
 |  | Age 60-69
 |  | Age 70+
 |  | Prefer not to say / did not answer
 | Sexual Orientation | Bisexual
 |  | [NAME]
 |  | Gay woman / Lesbian
 |  | Heterosexual / Straight
 |  | Prefer to use own term
 |  | Prefer not to say / did not answer
 | D/deaf and/or Disability | Yes, Disability
 |  | Yes, D/deaf
 |  | No
 |  | Prefer not to say / did not answer
 | [NAME] | Yes
 |  | No
 |  | Prefer not to say / did not answer
 | Religion | Buddhist
 |  | Christian
 |  | Hindu
 |  | Jewish
 |  | Muslim
 |  | Sikh
 |  | No Religion
 |  | Any other Religion or Belief
 |  | Prefer not to say / did not answer
 | Ethnicity | SOUTH ASIAN / SOUTH ASAIN BRITISH                    Indian
 |  | Pakistani
 |  | [NAME]
 |  | Any other Asian background
 |  | EAST ASIAN / EAST ASAIN BRITISH                        Chinese
 |  | Any other Asian background
 |  | BLACK/AFRICAN/CARIBBEAN/BLACK BRITISH   African
 |  | Caribbean
 |  | Any other Black/African/Caribbean background
 |  | MIXED/MULTIPLE                 White and Black Caribbean
 |  | White and Black African
 |  | White and Asian
 |  | Any other Mixed/Multiple ethnic background
 |  | WHITE       English/Welsh/Scottish/Northern Irish/British
 |  | Irish
 |  | Any other White background
 |  | Roma or Irish Traveller
 |  | OTHER ETHNIC GROUP                                                   Arab
 |  | Any other ethnic group
 |  | Prefer not to say / did not answer
 | New Audience (venue) | This is my first time
 |  | In the past month
 |  | In the past year
 |  | Over one year ago
 |  | Did not answer
 | New Audience (organisation) | This is my first time
 |  | In the past month
 |  | In the past year
 |  | Over one year ago
 |  | Did not answer
Spreadsheet: 887350d1737579825-conditional-formatting-borders-and-lines_2
Sheet: Border

Number | Name | Address |  |  |  |  |  |  |  |  | Number | name | Address
 | [NAME] | street 1 | Conditional Formating for formula automatic borders
 | bart | street 2 | Conditional Formating for formula automatic numbers
Spreadsheet: c872f1a7-a08a-4d19-9ce4-d51360b1c558
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Interdisciplinary
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 122299d1316718165-variable-data-validation-lists-example-timesheet
Sheet: TIMESHEET

 |  |  |  | Date: | 2011-01-01 00:00:00 | to |  | NAME:
JOB# | TYPE: | ITEM: | NOTES: | MON | TUES | WED | THURS | FRI | SAT | SUN
 | O
 | M
 | F
 | D
 | L
TOTAL:
 |  |  |  |  |  |  |  | HOURS WORKED:
Spreadsheet: 286544d1388353649-how-can-you-look-up-how-much-each-category-has-made-into-the-category-column-formula-mockup_alkey
Sheet: Sheet1

 |  |  |  |  | •purchases
# | P. Date | Sell Date | Item Number | Item Name | Paid | Sold | Profit
1 | 2013-09-18 00:00:00 | 2013-10-15 00:00:00 | GW30BFF0000001 | apple | 1 | 5
2 | 2013-09-18 00:00:00 | unsold | GW37VS0000002 | orange | 1
3 | 2013-09-20 00:00:00 | 2013-10-24 00:00:00 | GW14SO0000003 | pear | 1 | 7
4 | 2013-10-02 00:00:00 | 2013-11-17 00:00:00 | GW30BF0000004 | [NAME] | 1 | 8
5 | 2013-10-02 00:00:00 | 2013-11-02 00:00:00 | GW30BF0000005 | apple | 1 | 9
6 | 2013-10-02 00:00:00 | 2013-10-08 00:00:00 | GW30BF0000006 | orange | 1 | 10
7 | 2013-10-02 00:00:00 | 2013-10-14 00:00:00 | GW30BF0000007 | pear | 1 | 11
8 | 2013-10-02 00:00:00 | 2013-10-14 00:00:00 | GW37VS0000008 | [NAME] | 1 | 12
9 | 2013-10-02 00:00:00 | unsold | GW37VS0000009 | apple | 1
10 | 2013-10-16 00:00:00 | 2013-12-09 00:00:00 | GW37VS0000010 | orange | 1 | 14
11 | 2013-10-19 00:00:00 | unsold | GW67TZ0000011 | pear | 1
12 | 2013-10-21 00:00:00 | 2013-12-04 00:00:00 | GW67TZ0000012 | [NAME] | 1 | 16
13 | 2013-10-21 00:00:00 | 2013-12-24 00:00:00 | GW67TZ0000013 | apple | 1 | 17
14 | 2013-10-21 00:00:00 | unsold | GW67TZ0000014 | orange | 1
15 | 2013-10-21 00:00:00 | 2013-12-06 00:00:00 | GW67TZ0000015 | pear | 1 | 19
16 | 2013-10-21 00:00:00 | 2013-12-01 00:00:00 | GW67TZ0000016 | [NAME] | 1 | 20
17 | 2013-10-21 00:00:00 | 2013-11-05 00:00:00 | GW67TZ0000017 | apple | 1 | 21
18 | 2013-10-25 00:00:00 | 2013-11-03 00:00:00 | GW34PD0000018 | orange | 1 | 22
19 | 2013-10-25 00:00:00 | 2013-11-12 00:00:00 | GW34PD0000019 | pear | 1 | 23
20 | 2013-10-25 00:00:00 | 2013-11-12 00:00:00 | GW34PD0000020 | [NAME] | 1 | 24
 |  |  |  |  |  | Monthly Sales
 | Category | Total Purchases | Sold | Profit |  | Category | October | November | December
 |  |  |  |  |  | GW30BF
 |  |  |  |  |  | GW37VS
 |  |  |  |  |  | GW14SO
 |  |  |  |  |  | GW67TZ
 |  |  |  |  |  | GW34PD
Spreadsheet: chris_germany__1835__DecCohCHOICE-ENA
Sheet: Dec 9

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-09 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1254 |  | 1254 |  | 67694 |  |  |  |  |  | 27 | 1 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 2 | x
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 5466 |  | 5466 |  | 67694 |  |  |  |  |  | 28 | 3 | x
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 26 | 4 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 5 | x
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2008 |  | 2008 |  | 67694 |  |  |  |  |  | 29 | 6 | x
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 26 | 7 | x
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 31 | 8 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 9 | x
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 13769 |  | 13769 |  | 67694 |  |  |  |  |  | 35 | 15 | x
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 28 | 35 | x
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68915 | 0 |  |  |  |  | 26 | 39 | x
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1351 |  | 1351 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1218 |  | 1218 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 12269 |  | 12269 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 1820 |  | 1820 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3919 |  | 3919 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5179 |  | 5179 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 820 |  | 820 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 45 |  | 45 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 328115d1403790164-processing-a-days-work-example
Sheet: CMATH99 - 2

Event Type |  | Event Time |  | Event Duration(mins)
ACW_START |  | 2014-06-23 00:00:00 | 06:29:00 | 0
SOF_START |  | 2014-06-23 00:00:00 | 06:29:00 | 0
PARK |  | 2014-06-23 00:00:00 | 06:29:00 | 611
ISS | Job-No1 | 2014-06-23 00:00:00 | 06:29:00 | 0
ISS | Job-No2 | 2014-06-23 00:00:00 | 06:29:00 | 0
OSC_START |  | 2014-06-23 00:00:00 | 07:00:00 | 0
SCH_START |  | 2014-06-23 00:00:00 | 07:00:00 | 0
EXC | Job-No1 | 2014-06-23 00:00:00 | 07:10:00 | 0
EXC | Job-No2 | 2014-06-23 00:00:00 | 11:11:00 | 0
MOVE |  | 2014-06-23 00:00:00 | 07:30:00 | 55
ACL_START |  | 2014-06-23 00:00:00 | 12:00:00 | 0
[NAME] |  | 2014-06-23 00:00:00 | 12:40:00 | 0
COM | Job-No2 | 2014-06-23 00:00:00 | 16:36:00 | 0
COM | Job-No1 | 2014-06-23 00:00:00 | 08:06:00 | 0
ACW_END |  | 2014-06-23 00:00:00 | 16:37:00 | 0
SOF_END |  | 2014-06-23 00:00:00 | 16:37:00 | 0
OSC_END |  | 2014-06-23 00:00:00 | 16:40:00 | 0
SCH_END |  | 2014-06-23 00:00:00 | 16:40:00 | 0
MOVE |  | 2014-06-23 00:00:00 | 16:40:00 | 0
ACW_START |  | 2014-06-24 00:00:00 | 06:24:00 | 0
SOF_START |  | 2014-06-24 00:00:00 | 06:24:00 | 0
PARK |  | 2014-06-24 00:00:00 | 06:24:00 | 616
ISS | Job-No3 | 2014-06-24 00:00:00 | 06:24:00 | 0
ISS | Job-No4 | 2014-06-24 00:00:00 | 06:24:00 | 0
EXC | Job-No4 | 2014-06-24 00:00:00 | 06:27:00 | 0
OSC_START |  | 2014-06-24 00:00:00 | 07:00:00 | 0
SCH_START |  | 2014-06-24 00:00:00 | 07:00:00 | 0
FUR | Job-No4 | 2014-06-24 00:00:00 | 10:08:00 | 0
ISS | Job-No5 | 2014-06-24 00:00:00 | 10:10:00 | 0
ISS | Job-No6 | 2014-06-24 00:00:00 | 10:10:00 | 0
EXC | Job-No5 | 2014-06-24 00:00:00 | 10:12:00 | 0
ISS | Job-No6 | 2014-06-24 00:00:00 | 11:02:00 | 0
EXC | Job-No6 | 2014-06-24 00:00:00 | 13:18:00 | 0
COM | Job-No6 | 2014-06-24 00:00:00 | 13:18:00 | 0
ACL_START |  | 2014-06-24 00:00:00 | 13:19:00 | 0
[NAME] |  | 2014-06-24 00:00:00 | 13:59:00 | 0
COM | Job-No5 | 2014-06-24 00:00:00 | 15:56:00 | 0
EXC | Job-No6 | 2014-06-24 00:00:00 | 15:57:00 | 0
COM | Job-No6 | 2014-06-24 00:00:00 | 15:57:00 | 0
FUR | Job-No3 | 2014-06-24 00:00:00 | 15:59:00 | 0
ACW_END |  | 2014-06-24 00:00:00 | 16:00:00 | 0
SOF_END |  | 2014-06-24 00:00:00 | 16:00:00 | 0
OSC_END |  | 2014-06-24 00:00:00 | 16:40:00 | 0
SCH_END |  | 2014-06-24 00:00:00 | 16:40:00 | 0
MOVE |  | 2014-06-24 00:00:00 | 16:40:00 | 0
Spreadsheet: 692561d1598433963-if-function-example
Sheet: Sheet1

Intarziere TR | Intarziere Dep | [NAME]
00:00:00 | 07:40:00 |  |  |  |  | If you have any confussion Just Visit
00:00:00 | 07:40:00 |  |  |  |  | https://www.fiverr.com/share/lv92w2
05:00:00 | 07:45:00
05:00:00 | 07:45:00
07:45:00 | 07:45:00
07:00:00 | 06:00:00
00:00:00 | 00:00:00
Spreadsheet: 2336dd8c-0087-4713-b2a2-2eb1b9807c05
Sheet: INPUT

CONCRETE BATCH PLANT EMISSIONS CALCULATOR - INPUT SCREEN
REVISION A; Issued 01/23/2006
 |  | Instructions:  Enter emission source / facility data on the "INPUT" tab/screen.  The air emission results and summary of input data are viewed / printed on the "OUTPUT" tab/screen.  The different tabs are on the bottom of this screen.
 |  | This spreadsheet is for your use only and should be used with caution. DENR does not guarantee the accuracy of the information contained.  This spreadsheet is subject to continual revision and updating.  It is your responsibility to be aware of the most current information available.  DENR is not responsible for errors or omissions that may be contained herein.
Directions: Enter and select information in the boxes that are highlighted in blue:
General Facility Information
COMPANY NAME: |  |  |  |  | Company Name
FACILITY ID NUMBER: |  |  |  |  | 04/01/12345
PERMIT NUMBER |  |  |  |  | 01234R00
FACILITY CITY: |  |  |  |  | City
FACILITY COUNTY: |  |  |  |  | County
SPREADSHEET PREPARED BY: |  |  |  |  | Your Name
General Facility Information
MAXIMUM HOURLY THROUGHPUT AT TRUCK LOAD OUT |  |  |  |  | 1 | (yd3/hour)
IS THE MAXIMUM THROUGHPUT A SYNTHETIC LIMIT? |  |  |  |  | 1 | (1=No, 2=Yes)
ACTUAL ANNUAL PRODUCTION |  |  |  |  | 1 | (yd3/year)
Facility Production Information
PERCENT OF ANNUAL LOADOUT THROUGH TRUCK MIX |  |  |  |  | 100 | (% by volume)
PERCENT OF ANNUAL LOADOUT THROUGH CENTRAL MIX |  |  |  |  | 0 | (% by volume)
Facility Emissions Control Information
IS THERE A CONTROL DEVICE ON THE TRUCK MIX? |  |  |  |  | 1 | (1=No, 2=Yes)
IS THERE A CONTROL DEVICE ON THE CENTRAL MIX? |  |  |  |  | 1 | (1=No, 2=Yes)
Material Composition Information |  |  |  |  |  |  | Typical NC Comp.*
Cement |  |  |  |  | 410 | lbs | 410 lbs
Supplement |  |  |  |  | 120 | lbs | 120 lbs
Coarse Aggregate |  |  |  |  | 1884 | lbs | 1884 lbs
Sand |  |  |  |  | 1443 | lbs | 1443 lbs
Water |  |  |  |  | 167 | lbs | 167 lbs
Total |  |  |  |  | 4024 | lbs | 4024 lbs
* North Carolina typical material composition is based on data from industry contacts.  User may enter site-specific data.
Spreadsheet: 48085d1247247788-column-matching-command-example
Sheet: Sheet2

AUSTIN | TX | 1998-09-29 00:00:00
DELRAN | NJ | 1998-09-13 00:00:00
MILLVILLE | NJ | 1998-09-02 00:00:00
EATONTOWN | NJ | 2001-06-14 00:00:00
WEST LONG BRANCH | NJ | 1998-09-14 00:00:00
BRICK | NJ | 1998-10-28 00:00:00
TIMBERLAKE | NC | 1998-07-14 00:00:00
LAURINBURG | NC | 1998-07-31 00:00:00
SELMA | NC | 1998-08-12 00:00:00
OXFORD | NC | 1998-08-14 00:00:00
LUMBERTON | NC | 1998-08-20 00:00:00
GARNER | NC | 1998-10-09 00:00:00
ROXBORO | NC | 1998-10-21 00:00:00
DURHAM | NC | 1998-11-03 00:00:00
DURHAM | NC | 1998-11-04 00:00:00
BELCHERTOWN | MA | 1998-08-12 00:00:00
[NAME] | MA | 1998-09-01 00:00:00
SPRINGFIELD | MA | 1998-08-24 00:00:00
SANDY | UT | 1998-10-30 00:00:00
CHEROKEE | NC | 1998-11-09 00:00:00
CHEROKEE | NC | 1998-11-19 00:00:00
ROBBINSVILLE | NC | 1998-11-16 00:00:00
SYLVA | NC | 1998-11-17 00:00:00
Spreadsheet: 48400d1247613358-large-function-and-corresponding-name-sales-example-index-match-
Sheet: Sheet1

Name | Sales |  |  | TOP THREE
[NAME] | 100 |  |  | 1st | 225 | Ringo
[NAME] | 25 |  |  | 2nd | 100 | [NAME]
[NAME] | 60 |  |  | 3rd | 95 | [NAME]
[NAME] | 75
[NAME] | 95
[NAME] | 0
George | 80
Ringo | 225