tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 412164-function-sumproduct-with-visible-cells-efbrainzlp
Sheet: Folha1

MAPA DE PRODUÇAO EM CURSO DE ENVELOPES 2015
 | PET TRANSPARENTE |  |  |  |  |  |  |  |  | EMBOSSED CORES |  |  |  | TODOS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Máquina a executar            ( Manual ou Automática) | Medida Exterior
[NAME] |  |  |  |  |  |  |  |  | Quantidade em EMBOSSED TRANSPARENTE |  |  |  | Quantidade em EMBOSSED CORES | QUANTIDADE TOTAL |  | Comp | [NAME] | Aba | m² unit | m² totais | ML Totais da encomenda
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 5 | 10
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 20 | 5
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 5 | 10
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 20 | 5
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 20 | 5
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 5 | 10
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 5 | 10
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 5 | 10
16 |  |  | 700 |  |  | 1500 |  |  |  |  |  |  |  |  |  | 50 | 20 | 5
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 20 | 5
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 20 | 5
21 |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 20 | 5
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
25 |  | 510 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 20 | 5
26 |  |  | 18100 |  |  |  |  |  |  |  |  |  |  |  |  | 32.5 | 23.5 | 5
27 |  | 105 | 105 |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 20 | 5
28 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 5 | 10
29 |  |  | 1500 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 5 | 10
30 |  |  |  |  |  |  |  |  |  |  |  |  | 140000 |  |  | 50 | 20 | 5
31 |  | 5600 | 5600 |  | 5600 | 5600 |  |  |  |  |  |  |  |  |  | 20 | 5 | 10
32 | 2800 | 2800 | 2800 |  | 2800 | 2800 | 2800 |  |  |  |  |  |  |  |  | 20 | 5 | 10
33 |  | 5600 | 5600 |  | 2800 | 5600 |  |  |  |  |  |  |  |  |  | 20 | 5 | 10
34 | 1000 | 2800 | 2100 |  | 2800 |  | 800 |  |  |  |  |  |  |  |  | 20 | 5 | 10
59
60
61
80
Spreadsheet: 876052d1722697878-how-to-combine-vlookup-and-conditional-formating-help-4
Sheet: Sheet1

 |  | Data |  |  |  |  | Example
 |  | Name | Fee Limit |  |  |  | Week 1 | Fee |  | Week 2 | Fee |  | Week 3 | Fee |  | Week 4 | Fee
 |  | Su | 1400 |  |  |  | Su | 1237 |  | Su |  |  | Su |  |  | Su
 |  | DI | 1400 |  |  |  | DI | 1500 |  | DI |  |  | DI |  |  | DI
 |  | [NAME] | 1400 |  |  |  | [NAME] | 1300 |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 |  | Je | 1400 |  |  |  | Je | 1200 |  | Je |  |  | Je |  |  | Je
 |  | Al | 1400 |  |  |  | Al | 1532 |  | Al |  |  | Al |  |  | Al
 |  | Ck | 1400 |  |  |  | Ck | 1355 |  | Ck |  |  | Ck |  |  | Ck
 |  | AT | 1000 |  |  |  | AT | 1100 |  | AT |  |  | AT |  |  | AT
 |  | [NAME] | 1400 |  |  |  | [NAME] | 1309 |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 |  | [NAME] | 1400 |  |  |  | [NAME] | 1506 |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 |  | [NAME] | 1400 |  |  |  | [NAME] | 1234 |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 |  | Ci | 1300 |  |  |  | Ci | 989 |  | Ci |  |  | Ci |  |  | Ci
 |  | CH | 1200 |  |  |  | CH | 1301 |  | CH |  |  | CH |  |  | CH
 |  | BS | 1200 |  |  |  | BS | 809 |  | BS |  |  | BS |  |  | BS
 |  | No | 1400 |  |  |  | No | 1345 |  | No |  |  | No |  |  | No
 |  | Wi | 800 |  |  |  | Wi | 985 |  | Wi |  |  | Wi |  |  | Wi
 |  | Le | 800 |  |  |  | Le | 765 |  | Le |  |  | Le |  |  | Le
 |  | [NAME] | 1400 |  |  |  | [NAME] | 1395 |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 |  | HL | 1400 |  |  |  | HL | 1408 |  | HL |  |  | HL |  |  | HL
 |  | hc | 300 |  |  |  | hc | 298 |  | hc |  |  | hc |  |  | hc
 |  |  |  |  |  |  | Green mean below the fee limit
 |  |  |  |  |  |  | Red mean above the fee limit
Spreadsheet: 0e649573-efbf-4a08-be36-5ff12b83c5ec
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Availability of WLCG Tier-1 [NAME] | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | 2006-07-01 00:00:00 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
Data from SAM monitoring. Site availability as agreed in WLCG MB on 07mar06 and 04apr06. Service considered unavailable from time of first failure to time of next success      Scheduled interruptions are considered as unavailable.
 | average (all sites) |  |  |  | 0.7049462365591399 |  | target |  | 0.882 |  |  |  |  | site average colour coding:  < 90% of target    ≥ 90% of target   ≥ target
 | CERN-PROD |  |  | average | 0.9033333333333333 |  |  |  |  | FZK-LCG2 |  |  | average | 0.5423655913978496 |  |  |  | IN2P3-CC |  |  | average | 0.8674193548387098
 | INFN-T1 |  |  | average | 0.3137634408602151 |  |  |  |  | RAL-LCG2 |  |  | average | 0.7324731182795701 |  |  |  | SARA-MATRIX |  |  | average | 0.8444086021505377
 | TRIUMF-LCG2 |  |  | average | 0.797204301075269 |  |  |  |  | Taiwan-LCG2 |  |  | average | 0.9764516129032257 |  |  |  | USCMS-FNAL-WC1 |  |  | average | 0.2003225806451613
 | PIC |  |  | average | 0.8717204301075269 |  |  |  |  | BNL |  |  | average |  |  |  |  | NDGF |  |  | average
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: AC

 | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing | Incoming | Outgoing
 |  |  |  |  |  |  |  | Total
 | ACash |  |  |  |  |  |  | Prior Year
 | Month | Day | Transaction | Subcategory | Amount
Spreadsheet: 264477d1378899513-how-to-compare-data-in-excel-2010-954144
Sheet: Sheet1

1 | 2 | 1 | 2 | 1 | 2
1 | 2 | 1 | 5 | 1 | 2
1 | 2 | 1 | 2 | 1 | 2
1 | 8 | 1 | 2 | 9 | 2
1 | 2 | 1 | 2 | 1 | 2
1 | 2 | 4 | 2 | 1 | 2
1 | 2 | 1 | 2 | 1 | 2
1 | 2
1 | 2
1 | 2
1 | 2
1 | 2
1 | 2
1 | 2
Spreadsheet: 2532feeb-5693-4fe6-b857-1662c8e9ccec
Sheet: 4ED OUT OF 59

ANON# | RANK
11639 | 4
12332 | 9
15287 | 3
17139 | 12
22655 | 11
24728 | 10
24814 | 15
27503 | 2
37419 | 6
44016 | 13
66830 | 14
72133 | 1
72588 | 5
72609 | 7
95861 | 8
Spreadsheet: larry_campbell__21031__SeminolePTE
Sheet: Fugitives

NORTHERN NATURAL GAS COMPANY
SEMINOLE COMPRESSOR STATION
TNRCC ACCOUNT NO. GA-0174-T
Fugitive Emissions Potential To Emit
Component | Service | Component | Emission | In-Service | Percent | VOC Emissions
Type |  | Count | Factor1 | Hours | VOC2 | Annual |  | Hourly
 |  | (comp) | (lb/hr/comp) | (hrs/yr) | (wt%) | (lb/yr) | (tn/yr) | (lb/hr)
Valves | Gas/Vapor | 188 | 0.00992 | 8760 | 0.1
 | Light Liquid | 2 | 0.00551 | 8760 | 1
 | Heavy Liquid | 0 | 1.85e-05 |  | 1
 | Water/Oil | 0 | 0.000216 |  | 1
[NAME] | Gas/Vapor | 0 | 0.00529 |  | 0.1
 | Light Liquid | 0 | 0.0287 |  | 1
 | Heavy Liquid | 0 | N/A |  | 1 | N/A | N/A | N/A
 | Water/Oil | 0 | 5.29e-05 |  | 1
Flanges | Gas/Vapor | 213 | 0.00086 | 8760 | 0.1
 | Light Liquid | 5 | 0.000243 | 8760 | 1
 | Heavy Liquid | 0 | 8.6e-07 |  | 1
 | Water/Oil | 0 | 6.39e-06 |  | 1
Compressor Seals | Gas/Vapor | 1 | 0.0194 | 8760 | 0.1
 | Light Liquid | 0 | 0.0165 |  | 1
 | Heavy Liquid | 0 | 7.05e-05 |  | 1
 | Water/Oil | 0 | 0.0309 |  | 1
Relief Valves | Gas/Vapor | 5 | 0.0194 | 8760 | 0.1
 | Light Liquid | 0 | 0.0165 |  | 1
 | Heavy Liquid | 0 | 7.05e-05 |  | 1
 | Water/Oil | 0 | 0.0309 |  | 1
Sample Connections | Gas/Vapor | 0 | 0.0194 |  | 0.0584
 | Light Liquid | 0 | 0.0165 |  | 1
 | Heavy Liquid | 0 | 7.05e-05 |  | 1
 | Water/Oil | 0 | 0.0309 |  | 1
Open-Ended Lines | Gas/Vapor | 0 | 0.0194 |  | 0.1
 | Light Liquid | 0 | 0.0165 |  | 1
 | Heavy Liquid | 0 | 7.05e-05 |  | 1
 | Water/Oil | 0 | 0.0309 |  | 1
Total VOC (59999)
1  Emission factors for Oil and Gas Production Operations extracted from Table 2-4 of EPA-453/R-95-017.
2  Valve count is estimated.
3  VOC Emissions do not include methane or ethane. Percent VOC for gas service estimated; for liquid service assumed 100% VOC.
Spreadsheet: john_griffith__15893__11_13_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 275 | 36 | 38 | 84 | 88.6 | 14.92 | 2001-11-13 10:10:00
 | NG F2 | 295 | 64 | 66 | 79.8 | 82.3 | 15.03 | 2001-11-13 10:10:00
 | NG G2 | 300 | 78 | 81 | 72.3 | 75.1 | 13.9 | 2001-11-13 10:10:00
 | NG H2 | 295 | 79 | 82 | 63.9 | 66.4 | 12.08 | 2001-11-13 10:10:00
 | NG J2 | 295 | 74 | 78 | 53.3 | 56.2 | 10.15 | 2001-11-13 10:10:00
 | NG K2 | 300 | 76 | 79 | 48.6 | 50.5 | 9.35 | 2001-11-13 10:10:00
 | NG M2 | 305 | 84 | 88 | 48.4 | 50.8 | 9.51 | 2001-11-13 10:10:00
 | NG N2 | 305 | 90 | 94 | 48.7 | 50.9 | 9.55 | 2001-11-13 10:10:00
 | NG Q2 | 310 | 98 | 102 | 49.1 | 51.2 | 9.77 | 2001-11-13 10:10:00
 | NG U2 | 310 | 101 | 106 | 48 | 50.4 | 9.59 | 2001-11-13 10:10:00
 | NG V2 | 315 | 107 | 113 | 47.9 | 50.7 | 9.76 | 2001-11-13 10:10:00
 | NG X2 | 335 | 119 | 125 | 47.9 | 50.4 | 10.35 | 2001-11-13 10:10:00
 | [NAME] |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG H3 |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: tracy_geaccone__40259__C0366-111727
Sheet: Dept_100193

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
ENRON BUILDING - Dept. 100193
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111727
2001-06-21 00:00:00 | EBR01/06 -ECN 4053b |  | Building Rent | Sq. Ft. Occupied | 381 | 2.08 | /MNTH | 793.74
 |  |  |  |  |  |  | Ticket Total |  | 793.74
2001-06-21 00:00:00 | EBR01/06 -ECN 4066 |  | Building Rent | Sq. Ft. Occupied | 113 | 2.08 | /MNTH | 235.41
 |  |  |  |  |  |  | Ticket Total |  | 235.41
2001-06-21 00:00:00 | EBR01/06 -ECN 4068a |  | Building Rent | Sq. Ft. Occupied | 114 | 2.08 | /MNTH | 237.5
 |  |  |  |  |  |  | Ticket Total |  | 237.5
2001-06-21 00:00:00 | EBR01/06 -ECN 4068b |  | Building Rent | Sq. Ft. Occupied | 87 | 2.08 | /MNTH | 181.25
 |  |  |  |  |  |  | Ticket Total |  | 181.25
2001-06-21 00:00:00 | EBR01/06 -ECN 4069 |  | Building Rent | Sq. Ft. Occupied | 432 | 2.08 | /MNTH | 899.99
 |  |  |  |  |  |  | Ticket Total |  | 899.99
2001-06-21 00:00:00 | EBR01/06 -ECN 4070 |  | Building Rent | Sq. Ft. Occupied | 379 | 2.08 | /MNTH | 789.57
 |  |  |  |  |  |  | Ticket Total |  | 789.57
2001-06-21 00:00:00 | EBR01/06 -ECN 4261 |  | Building Rent | Sq. Ft. Occupied | 113 | 2.08 | /MNTH | 235.41
 |  |  |  |  |  |  | Ticket Total |  | 235.41
 |  |  |  |  |  |  | Total for R/C: 111727 |  | 3372.86
 |  |  |  |  |  |  | Total for Dept_100193 |  | 3372.86
Spreadsheet: 748164d1631926743-hard-time-figuring-out-this-problem-involving-match-and-index-bootkick9-wright_excel_ch05_ps2_musiclessons
Sheet: LessonData

Lesson Data
Date | [NAME] | Student | Teacher | [NAME] | Skill Level | Total Fee
2018-01-07 00:00:00 | 000018 | [NAME] | [NAME] | 0.5
2018-01-08 00:00:00 | 000001 | [NAME] | [NAME] | 1.5
2018-01-12 00:00:00 | 000033 | [NAME] | [NAME] | 0.5
2018-01-16 00:00:00 | 000010 | [NAME] | [NAME] | 1.5
2018-01-17 00:00:00 | 000018 | [NAME] | Anne | 2
2018-01-19 00:00:00 | 000028 | [NAME] | [NAME] | 1
2018-01-21 00:00:00 | 000022 | [NAME] | Debbie | 1
2018-02-03 00:00:00 | 000008 | Violet Ward | Debbie | 1
2018-02-14 00:00:00 | 000008 | Violet Ward | [NAME] | 0.5
2018-02-16 00:00:00 | 000001 | [NAME] | Mark | 1
2018-02-20 00:00:00 | 000016 | [NAME] | [NAME] | 1
2018-03-10 00:00:00 | 000002 | [NAME] | Mark | 2
2018-04-02 00:00:00 | 000006 | [NAME] | Debbie | 1.5
2018-04-15 00:00:00 | 000022 | [NAME] | [NAME] | 1
2018-04-16 00:00:00 | 000006 | [NAME] | [NAME] | 2
2018-04-19 00:00:00 | 000018 | [NAME] | [NAME] | 2
2018-04-20 00:00:00 | 000033 | [NAME] | [NAME] | 1.5
2018-05-06 00:00:00 | 000008 | Violet Ward | Anne | 1
2018-05-07 00:00:00 | 000018 | [NAME] | Anne | 2
2018-05-07 00:00:00 | 000025 | [NAME] | Mark | 0.5
2018-05-08 00:00:00 | 000008 | Violet Ward | Debbie | 2
2018-05-09 00:00:00 | 000028 | [NAME] | [NAME] | 2
2018-05-12 00:00:00 | 000016 | [NAME] | Anne | 1
2018-05-15 00:00:00 | 000016 | [NAME] | Mark | 1.5
2018-05-17 00:00:00 | 000001 | [NAME] | Anne | 2
2018-05-21 00:00:00 | 000010 | [NAME] | Mark | 0.5
2018-05-29 00:00:00 | 000001 | [NAME] | Debbie | 1
Spreadsheet: 77186d1277718034-computing-average-sample
Sheet: Sheet2

A | B | C | D
Reports | BF |  | 10
Reports | ENH |  | 20
Reports | WF |  | 50
Reports | BF |  | 10
Reports | ENH |  | 30
Reports | WF |  | 45
Reports | BF |  | 55
Ext | ENH |  | 10
Ext | WF |  | 20
Ext | BF |  | 30
Ext | ENH |  | 40
Ext | WF |  | 50
Ext | BF |  | 60
Ext | ENH |  | 70
Ext | WF |  | 80
Ext | BF |  | 90
Ext | ENH |  | 100
Ext | WF |  | 110
Ext | BF |  | 120
Ext | ENH |  | 130
Ext | WF |  | 140
Ext | BF |  | 150
Ext | ENH |  | 160
Spreadsheet: andy_zipper__176__DYNEGY-ICE VOL Apr24
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-24-01 thru Apr-24-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-24-01 | 608179437 |  | Bought | NG Fin BS, LD1 for IF | TCO | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | AEP Energy Services, Inc. | 0.325 | USD / MMBtu | 5000 | Daily | 755000 | MMBtus | Mckay, B
Apr-24-01 | 196811021 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 03 | Jan-01-03 | Dec-31-03 |  |  |  | J. Aron & Company | 4.42 | USD / MMBtu | 2500 | Daily | 912500 | MMBtus | [NAME], J
Apr-24-01 | 831945054 |  | Bought | NG Fin, FP for LD1 | [NAME] | Cal 03 | Jan-01-03 | Dec-31-03 |  |  |  | AEP Energy Services, Inc. | 4.41 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
Apr-24-01 | 473047261 |  | Sold | NG Fin Sw Swap, IF for GDD | NNG-Demarc | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Aquila Risk Management Corp. | -0.0325 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Apr-24-01 | 211102181 |  | Bought | NG Fin, FP for LD1 | [NAME] | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Reliant Energy Services, Inc. | 5.09 | USD / MMBtu | 5000 | Daily | 155000 | MMBtus | [NAME], J
Apr-24-01 | 153186855 |  | Sold | NG Fin BS, LD1 for IF | NNG-Demarc | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Aquila Risk Management Corp. | -0.03 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Apr-24-01 | 132267254 |  | Sold | NG Fin BS, LD1 for IF | NNG-Demarc | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Cinergy Marketing & Trading, LLC | -0.03 | USD / MMBtu | 20000 | Daily | 620000 | MMBtus | [NAME], G
Apr-24-01  Deals
Spreadsheet: 868197d1714948948-calculating-start-time-when-shifts-go-past-midnight-schedule-example
Sheet: Sheet1

Date | ID | Start | Stop | Duration | Schedule Code
2102024 | 316048 | 21:00:00 | 01:00:00
2102024 | 316048 | 01:30:00 | 05:00:00 | 3.5 | 2102024-316048
2102024 | 316048 | 05:30:00 | 08:00:00 | 2.5 | 2102024-316048 |  |  |  |  | Hours
2102024 | 312969 | 22:00:00 | 01:30:00 | 3.500000000000001 | 2102024-312969 |  |  |  | 2102024-316048 | 10 | 01:30:00 | 10
2102024 | 312969 | 02:00:00 | 05:30:00 | 3.5 | 2102024-312969 |  |  |  | 2102024-312969 | 10 | 02:00:00 | 10
2102024 | 312969 | 06:00:00 | 09:00:00 | 3 | 2102024-312969 |  |  |  | 2102024-313972 | 5.483333333333334 | 04:31:00 | 5.483333333333334
2102024 | 313972 | 21:00:00 | 00:00:00 | 3 | 2102024-313972 |  |  |  | 2102024-21396 | 6.833333333333334 | 01:00:00 | 6.833333333333334
2102024 | 313972 | 04:31:00 | 07:00:00 | 2.483333333333334 | 2102024-313972 |  |  |  | 2102024-22114 | 7.983333333333334 | 15:31:00 | 7.983333333333334
2102024 | 21396 | 22:34:00 | 00:00:00 | 1.433333333333334 | 2102024-21396 |  |  |  | 2102024-22189 | 7.933333333333332 | 15:30:00 | 7.933333333333332
2102024 | 21396 | 01:00:00 | 02:30:00 | 1.5 | 2102024-21396 |  |  |  | 2102024-22255 | 4.483333333333333 | 22:31:00 | 4.483333333333333
2102024 | 21396 | 03:04:00 | 04:30:00 | 1.433333333333334 | 2102024-21396
2102024 | 21396 | 04:32:00 | 07:00:00 | 2.466666666666667 | 2102024-21396
2102024 | 22114 | 15:31:00 | 20:00:00 | 4.483333333333333 | 2102024-22114
2102024 | 22114 | 20:30:00 | 00:00:00 | 3.500000000000001 | 2102024-22114
2102024 | 22189 | 15:30:00 | 19:30:00 | 3.999999999999999 | 2102024-22189
2102024 | 22189 | 20:04:00 | 00:00:00 | 3.933333333333333 | 2102024-22189
2102024 | 22255 | 22:31:00 | 03:00:00 | 4.483333333333333 | 2102024-22255
Spreadsheet: 483528d1475697128-certain-data-pulling-up-in-a-range-of-data-sets-and-wanting-any-info-to-pull-up-along-it-variance-template_amended
Sheet: Sheet1

 |  |  |  |  | Areas | types
 |  |  |  |  |  | school | car | food | Date
 |  |  |  | row 1 | Location1 | 150 | 500 | 200 | 2016-04-09 00:00:00
 |  |  |  | row 2 | Location2 | 900 | 450 | 325 | 2016-04-09 00:00:00
 |  |  |  | row 3 | Location3 | 436 | 543 | 764 | 2016-04-09 00:00:00
 |  |  |  | row 4 | Location4 | 8565 | 2342 | 4635 | 2016-04-09 00:00:00
 |  |  |  | row 5 | Location5 | 967 | 876 | 65 | 2016-04-09 00:00:00
 |  |  |  | row 6 | Location6 | 8565 | 2342 | 123 | 2016-04-09 00:00:00
 |  |  |  | row 7 | [NAME] | 904345 | 8765 | 6546 | 2016-04-09 00:00:00
 |  |  |  |  | Location 8
 |  |  |  | row 1 | Location3 | 234 | 342 | 657 | 2016-04-16 00:00:00
 |  |  |  | row 2 | Location1 | 554 | 8797 | 23423 | 2016-04-16 00:00:00
 |  |  |  | row 3 | Location6 | 234 | 34576 | 75 | 2016-04-16 00:00:00
 |  |  |  | row 4 | Location4 | 967 | 6456 | 655464 | 2016-04-16 00:00:00
 |  |  |  | row 5 | Location2 | 905 | 873 | 1232 | 2016-04-16 00:00:00
 |  |  |  | row 6 | Location5 | 2347 | 345 | 4546 | 2016-04-16 00:00:00
 |  |  |  | row 7
 |  |  |  | row 8 | Location 8 | 5000 | 4000 | 2000
 |  |  |  | These are defined | Location1 |  |  |  | [NAME]
 |  |  |  |  | Location2 |  |  |  | [NAME]
 |  |  |  |  | Location3 |  |  |  | [NAME]
 |  |  |  |  | Location4 |  |  |  | [NAME]
 |  |  |  |  | Location5 |  |  |  | [NAME]
 |  |  |  |  | Location6 |  |  |  | [NAME]
 |  |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  |  |  | Location 8
 |  |  |  |  | Location1
 |  |  |  |  | Location2
 |  |  |  |  | Location3
 |  |  |  |  | Location4
 |  |  |  |  | Location5
 |  |  |  |  | Location6
 |  |  |  |  | [NAME]
 |  |  |  |  | Location8
Spreadsheet: 117568d1312888527-array-dynamic-vlookup-book3
Sheet: Sheet1

Date | Name |  |  |  | Date |  |  | Date | Name
2011-09-08 00:00:00 | [NAME] |  |  |  | 2011-09-08 00:00:00 |  |  | 2011-09-08 00:00:00 | [NAME]
2011-09-08 00:00:00 | [NAME]
2011-10-08 00:00:00 | [NAME]
2011-10-08 00:00:00 | [NAME]
2011-10-08 00:00:00 | [NAME]
2011-10-09 00:00:00 | [NAME]
2011-10-09 00:00:00 | [NAME]
Spreadsheet: 0f6b20ce-6cbb-40b6-bc0b-1668d2f16672
Sheet: Sheet1

Line # | MAKE/MODEL | VENDOR NAME: | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Crown Victoria | UNIT COST / Part #
 | Part Name | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
1 | A/C Accumulator
2 | A/C Compressor w/ Clutch (new)
3 | A/C Compressor w/o Clutch (new)
4 | ABS Front Sensor
5 | ABS Rear Sensor
6 | Alternator
7 | Alternator Mitsuba
8 | Belt, Serpentine
9 | Brake Light Switch
10 | Bulb, Dash Light
11 | Bulb, Marker Light
12 | Bulb, [NAME]
13 | Bulb, [NAME]
14 | Caliper Bracket
15 | Catalytic Convertor
16 | DPFE
17 | EGR
18 | Emergency Brake Shoes (set)
19 | Exhaust Flange Gasket
20 | Exhaust Pipe - Left
21 | Exhaust Pipe - Right
22 | Fan Assembly
23 | Fan Relay
24 | [NAME]
25 | Fuel Injector
26 | Fuel Pump
27 | Headlamp
28 | Headlight Assembly
29 | Idler Arm
30 | Ignition Coil
31 | [NAME]
32 | Intake Manifold Gasket
33 | Light Processor
34 | Lower Control Arm
35 | Master [NAME]
36 | [NAME]
37 | Oil Drain Plug
38 | Orifice Tube
39 | Outer Tie Rod
40 | Pads, Front (set
41 | Pads, Rear (set)
42 | Rack & Pinion
43 | Radiator
44 | Rear Axle Kit
45 | Rim
46 | Rotor, Front
47 | Rotor, Rear
48 | Shock, Front
49 | Shock, Rear
50 | Side Marker Light Assembly
51 | Spark Plug
52 | Starter
53 | [NAME], Front
54 | Tensioner
55 | Throttle Body Motor
56 | Trailing Bar
57 | Turn Signal Switch
58 | U-Joint
59 | Water Pump
60 | Window Motor
61 | Window Regulator
62 | [NAME]
63 | Wiper Motor
Spreadsheet: 167484d1342011402-to-change-a-descending-rank-formula-that-ignores-0s-to-one-that-ignores-blank-cells-2012-2-kimbap-hoping
Sheet: Student info

 | Class number | é | 1 |  |  | Student Information |  |  |  |  |  |  |  |  |  |  |  |  |  | ✂                                       ✂
 |  |  |  | No. |  | 학부 (Dept) | 학년 (Year) | 학번 (I.D.) | 이름 (name) | 소속학과 (?) | E-Mail | 전화번호 | 수강상태 (?) |  | 학본                    (Student number) |  | English name
 |  |  |  |  |  |  |  |  | neil
 |  |  |  | 2 |  | 제약공학과 | 1 | sunshinekate | 김기화 | 제약공학과 | [EMAIL] | 010-6251-4110 | 수강중
 |  |  |  | 3 |  | 영어학과 | 3 | nornor1027 | 김성엽 | 영어학과 | [EMAIL] | 010-7553-6223 | 수강중
 |  |  |  | 4 |  | 시각디자인학과 | 1 | ksy931203 | 김수연 | 시각디자인학과 | [EMAIL] | 010-6412-2065 | 수강중
 |  |  |  | 5 |  | 신소재공학과 | 1 | asdfyo | 김영훈 | 신소재공학과 | [EMAIL] | 010-8996-9320 | 수강중
 |  |  |  | 6
 |  |  |  | 7 |  | 신소재공학과 | 1 | ktm1397 | 김태민 | 신소재공학과 | [EMAIL] | 010-3364-6763 | 수강중
 |  |  |  | 8 |  | 기초과학부 | 1 | rampb78 | 박은민 | 기초과학부 | [EMAIL] | 010-3179-4278 | 수강중
 |  |  |  | 9 |  | 제약공학과 | 1 | jihye1415 | 박지혜 | 제약공학과 | [EMAIL] | 010-4613-7021 | 수강중
 |  |  |  | 10 |  | 제약공학과 | 1 | dnlwogml93 | 위재희 | 제약공학과 | [EMAIL] | 010-3606-7583 | 수강중
 |  |  |  | 11 |  | 시각디자인학과 | 1 | thdus314 | [NAME] | 시각디자인학과 | [EMAIL] | 010-3008-5061 | 수강중
 |  |  |  | 12 |  | 제약공학과 | 1 | kain832 | 이우행 | 제약공학과 | [EMAIL] | 010-2997-9312 | 수강중
 |  |  |  | 13 |  | 중어중국학과 | 1 | joobe0123 | 이주엽 | 중어중국학과 | [EMAIL] | 010-4506-8272 | 수강중
 |  |  |  | 14 |  | 시각디자인학과 | 1 | ekrcy99 | 최민지 | 시각디자인학과 | [EMAIL] | 010-3944-5117 | 수강중
 |  |  |  | 15 |  | 역사학과 | 1 | [NAME] | 최서영 | 역사학과 | [EMAIL] | 010-5434-9022 | 수강중
 |  |  |  | 16 |  | 사회복지학과 | 1 | cic2093 | 최소은 | 사회복지학과 | [EMAIL] | 010-8211-2093 | 수강중
 |  |  |  | 17 |  | 간호학과 | 1 | [NAME] | 최원진 | 간호학과 | [EMAIL] | 010-7659-3007 | 수강중
 |  |  |  | 18 |  | 시각디자인학과 | 1 | houng1993 | 홍주리 | 시각디자인학과 | [EMAIL] | 010-8879-0281 | 수강중
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  |  |  | é | é | é | é | é | é | é | é |  | é |  | é
 |  | é |  |  |  | to get this information: |  |  |  |  |  |  |  |  | to get this information: |  | Type in manually
 |  | é
 |  | é |  |  |  | 1. lms.sunmoon.ac.kr |  |  |  |  |  |  |  |  | 1.  lms.sunmoon.ac.kr
 |  | é |  |  |  | 2. Choose a class number then 수강생관리 (11th menu option) |  |  |  |  |  |  |  |  | 2. to be completed
 |  | é |  |  |  | 3. 엑셀다운 |  |  |  |  |  |  |  |  | 3
 |  | é |  |  |  | 4. Copy and paste ('values' only) |  |  |  |  |  |  |  |  | 4
 |  | é
 | Check the online attendance webpage to see who has unregistered.  Remove their data from this worksheet (do not delete the row). Otherwise, the averages in the Final Grades and Averages worksheets will be incorrect.  Please also remove test, participation, and homework scores.   However, make sure there are at least 10 "1's" on the attendance worksheet to take the score down to "0".