tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 464488d1465153087-how-count-occurences-in-multiple-separated-columns-using-countif-or-other-function-tr-eng
Sheet: K.Piątek

MIESIĘCZNY  PLAN  TRAS
 | Region............................................ |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
Lp. | PONIEDZIAŁEK  (04.04) |  |  | TYP KLIENTA | TYP WIZYTY | WTOREK  I |  |  |  | TYP KLIENTA | TYP WIZYTY | ŚRODA  I |  |  |  | TYP KLIENTA | TYP WIZYTY | CZWARTEK  I |  |  | TYP KLIENTA | TYP WIZYTY | PIĄTEK  I |  |  | TYP KLIENTA | TYP WIZYTY
1. | [NAME] |  |  |  | Z | PIP Hetmańska Łódź |  |  |  |  | Z | Makro Rzgów |  |  |  |  | Z | [NAME] 131 Wawa |  |  |  | Z | [NAME]
2. | [NAME] |  |  |  | Z | Pip Pabianice |  |  |  |  | Z | Makro [NAME] |  |  |  |  | Z | [NAME] 2 Wawa |  |  |  | Z | Auchan Puławska Warszawa
3. | [NAME] |  |  |  | Z | Pip Pabianicka Łódź |  |  |  |  | Z | [NAME] |  |  |  |  |  | PIP [NAME] |  |  |  | Z | [NAME]
4. | [NAME] |  |  |  | Z | [NAME]. [NAME] |  |  |  |  | Z | [NAME] |  |  |  |  |  | Artus [NAME] |  |  |  | Z | [NAME]
5. | [NAME] |  |  |  | Z | [NAME] |  |  |  |  | Z | real [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
6. | [NAME] |  |  |  | Z | [NAME] |  |  |  |  |  | Janex [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | Carrefour [NAME]
7. | [NAME] |  |  |  |  | Selgros  3 maja [NAME] |  |  |  |  |  | Bełchatówdis |  |  |  |  |  | [NAME] |  |  |  |  | Carrefour [NAME]
8. | Auchan Puławska Warszawa |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]. |  |  |  |  | Z | [NAME] [NAME] |  |  |  |  | [NAME]
9. | [NAME] |  |  |  |  | auchan Karskiego Łódź |  |  |  |  |  | Del. [NAME]. |  |  |  |  | Z | [NAME]
10. | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME]
11.
12.
13.
14.
15.
16.
17.
18.
Lp. | PONIEDZIAŁEK  II |  |  | TYP KLIENTA | TYP WIZYTY | WTOREK  II |  |  |  | TYP KLIENTA | TYP WIZYTY | ŚRODA  II |  |  |  | TYP KLIENTA | TYP WIZYTY | CZWARTEK  II |  |  | TYP KLIENTA | TYP WIZYTY | PIĄTEK  II |  |  | TYP KLIENTA | TYP WIZYTY
1. | [NAME] |  |  |  |  | PIP Hetmańska Łódź |  |  |  |  | Z | Zjamex Łódź |  |  |  |  | z | [NAME] 131 Wawa |  |  |  | Z | [NAME]
2. | [NAME] |  |  |  | Z | Pip Pabianice |  |  |  |  | Z | [NAME] |  |  |  |  | z | [NAME] 2 Wawa |  |  |  | Z | Auchan Puławska Warszawa
3. | [NAME] |  |  |  | Z | Pip Pabianicka Łódź |  |  |  |  | Z | Makro Rzgów |  |  |  |  |  | PIP [NAME] |  |  |  | Z | [NAME]
4. | [NAME] |  |  |  | Z | [NAME]. [NAME] |  |  |  |  | Z | Makro [NAME] |  |  |  |  |  | Artus [NAME] |  |  |  | Z | [NAME]
5. | [NAME] |  |  |  | Z | [NAME] |  |  |  |  | Z | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
6. | [NAME] |  |  |  | Z | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | Carrefour [NAME]
7. | [NAME] |  |  |  |  | Selgros  3 maja [NAME] |  |  |  |  |  | real [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | Carrefour [NAME]
8. | Auchan Puławska Warszawa |  |  |  |  | [NAME] |  |  |  |  |  | Janex [NAME] |  |  |  |  | z | [NAME] [NAME] |  |  |  |  | [NAME]
9. | [NAME] |  |  |  |  | auchan Karskiego Łódź |  |  |  |  |  | Del. [NAME] |  |  |  |  | z | [NAME]  [NAME]
10.
11.
12.
13.
14.
15.
16.
17.
18.
Spreadsheet: 273109d1382615858-compare-number-and-color-cell-if-biger-or-smaller-work-hours
Sheet: Te transferuar

 | Sbu | Opt | Id Badge | Turno(ore) | 2013-01-10 00:00:00 | 2013-02-10 00:00:00 | 2013-03-10 00:00:00 | 2013-04-10 00:00:00 | 2013-05-07 00:00:00 | 2013-07-10 00:00:00 | 2013-08-10 00:00:00 | 2013-09-10 00:00:00 | 2013-10-10 00:00:00 | 2013-11-10 00:00:00 | 2013-12-10 00:00:00 | [NAME] | 15/10/2013 | 16/10/2013 | 17/10/2013 | [NAME] | 19/10/2013 | 21/10/2013 | 22/10/2013 | 23/10/2013 | 24/10/2013 | 25/10/2013 | 26/10/2013 | 28/10/2013 | 29/10/2013 | 30/10/2013 | 31/10/2013 | Grand Total | Ore Dovute | Diferenza | Note
 |  | MIHAELA | 832 | 8 | 9 | 8.5 | 8.5 | 7.5 | 0 | 8 | 8.5 | 0 | 8.5 | 8.5 | 0 | 8 | 8 | 8 | 8.5 | 8 | 4 | 8.5 | 8.5 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | Tot Ore x gg
 |  | Fte X GG
Spreadsheet: 674147d1587675325-accrued-interest-w-prepayments-formula-interst
Sheet: Sheet2

Column1 | Principal | Principal Date | Interest Rate | Payment 1 | payment Date | Payment 2 | payment [NAME] | Payoff Amount | Status
1 | 10000 | 2020-04-10 00:00:00 |  | 1000 | 2020-04-14 00:00:00 | 2000 | 2020-04-17 00:00:00
2 | 10000 | 2020-04-05 00:00:00 |  | 500 | 2020-04-10 00:00:00 | 6000 | 2020-04-20 00:00:00
3 | 5000 | 2020-04-07 00:00:00 |  | 2000 | 2020-04-16 00:00:00 | 6000 | 2020-04-19 00:00:00
4
5
6
7
8
9
10
Spreadsheet: 4b5465d6-b40c-489a-a6b6-7c35fe8b28a6
Sheet: Sheet1

DAFTAR JUDUL SKRIPSI
[NAME] ILMU HUKUM
UIN SUSKA RIAU
[NAME] : Tahun 1984 s/d sekarang
NO | Nama | L/P | NIM | No Alumni | [NAME] | [NAME] | [NAME] | [NAME] | IPK | PEMBIMBING | MASA STUDI
180 | [NAME] | L | [PHONE] | 11318/2003 | 2003-05-19 00:00:00 | [NAME] | 1975-03-08 00:00:00 | Tinjauan Hukum Islam Terhadap Transaksi [NAME] Internet di PT. Telkom Kandatel Pekanbaru. | 3.31 | Drs. Akbarizan, M.Ag, M.Pd
73 | Supiati | P | 10425025188 |  | 2008-06-09 00:00:00 | Pekanbaru | 1985-07-21 00:00:00 | Sistem Penyaluran Kredit Pada PT. Bank [NAME] Pangkalan [NAME] KUD [NAME] (Menurut Perspektif Ekonomi Islam. | 3.3 | Drs. [NAME] | 4
96 | Ridho Setiawan | L | 10024017491 | IN/13/S1-S.JS/14357/2005 / 15 Sep 2005 | 2005-07-27 00:00:00 | Pekanbaru | 1980-01-03 00:00:00 | Perjuangan Kader Hizbut Tahrir Indonesia (HTI) Dalam Menegakkan [NAME] (Study Pada DPD Hizbut Tahrir Indonesia (HTI) Kota Pekanbaru). | 3.61 | Drs. [NAME], MA | 5
158 | [NAME] | L | 19822012984 | 10372/2002 | 2002-05-07 00:00:00 | Pelanduk | 1978-03-06 00:00:00 | [NAME] ([NAME]) [NAME] Dalam Perspektif Hukum Islam (Studi Kasus di Desa Pelanduk [NAME]). | 3.72
477 | [NAME] | P |  |  | 1996-04-01 00:00:00 |  |  | Analisis Terhadap Pendapat Ibnu Qoyyim Tentang Hak [NAME] [NAME]. |  | Dra. Hj. Asmah Salut
1 | [NAME] | L | 10321022440 | [PHONE] / 02 Maret 2009 | 2009-01-12 00:00:00 | Bangkinang | 1984-11-20 00:00:00 | Motivasi Masyarakat Melaksanakan [NAME] Sudah Meninggal Dunia Menurut Hukum Islam (Studi di Desa Merbau Kecamatan Bunut [NAME]). | 3.15 | [NAME], M.Ag | 6
179 | Sunanik | P | 10623003781 |  | 2010-04-28 00:00:00 | Pola-pola [NAME] [NAME] Menurut Perspektif Hukum Islam (Studi Perbandingan [NAME] di Masjid Istiqamah dan [NAME] Kelurahan Tangkerang Tengah Pekanbaru).
Spreadsheet: 133371d1324367803-calculating-a-column-with-another-sheet-dummy-sheet
Sheet: Items

 | 2011-12-15 00:00:00 | 2011-12-31 00:00:00 | 2011-01-15 00:00:00 | 2011-01-31 00:00:00 | 2011-02-15 00:00:00 | 2011-02-28 00:00:00 | 2011-03-15 00:00:00 | 2011-03-31 00:00:00
Item 2 | 14.485
Item 3 | 25
Item 4 | 39
Item 5 | 28
Item 6 | 50
Item 7 | 4.999
Item 8 | 29.5
Item 9 | 48.983
Item 10 | 59.95
Item 11 | 14.2
Item 12 | 22.5
Item 13 | 393
Item 14 | 19.25
Item 15 | 5.5
Item 16 | 7.482
Item 17 | 24
Item 18 | 49
Item 19 | 40
Item 20 | 99.95
Item 21 | 5.75
Item 22 | 11.1
Item 23 | 14.399
Item 24 | 20
Item 25 | 4.85
Item 26 | 10.999
Item 27 | 16.8
Item 28 | 13.5
Item 29 | 13.95
Item 30 | 7.633
Item 31 | 7.7
Item 32 | 20
Item 33 | 14.5
Item 34 | 19.6
Item 35 | 13.9
Item 36 | 77
Item 37 | 24
Item 38 | 8.74
Item 39 | 9.999
Item 40 | 42.299
Item 41 | 12.35
Item 42 | 15.85
Item 43 | 12.5
Item 44 | 120
Item 45 | 14.5
Item 46 | 88.3
Item 47 | 50
Item 48 | 78.5
Item 49 | 17.28
Item 50 | 8.77
Item 51 | 6.75
Item 52 | 7
Item 53 | 12.15
Item 54 | 8
Item 55 | 15
Item 56 | 36.999
Item 57 | 75
Item 58 | 8
Item 59 | 18.4
Item 60 | 6.46
Item 61 | 9.8
Item 62 | 363.883
Item 63 | 24.999
Item 64 | 149.5
Item 65 | 7.995
Item 66 | 40
Item 67 | 21
Item 68 | 28.75
Item 69 | 28.5
Item 70 | 15.75
Item 71 | 29
Item 72 | 700
Item 73 | 18.75
Item 74 | 8.89
Item 75 | 16
Item 76 | 8.5
Item 77 | 8.85
Item 78 | 17.1
Item 79 | 10.25
Item 80 | 107.117
Item 81 | 14
Item 82 | 13
Item 83 | 40
Item 84 | 194.5
Item 85 | 21.95
Item 86 | 8.5
Item 87 | 31.483
Spreadsheet: 78063d1278513197-selecting-specific-cells-find8digitnumbers
Sheet: Data

1 | 73641949 | 15 | 966203 | 20100615 | 20100217 | 400046 | 563785
1 | 73641370 | 15 | 966204 | 20100615 | 20100217 | 400393 | 556728
1 | 73631865 | 15 | 966213 | 20100615 | 20100217 | 400999 | 556795
1 | 73814023 | 15 | 966214 | 20100615 | 20100218 | 400554 | 555260
1 | 73747681 | 15 | 966218 | 20100615 | 20100218 | 400950 | 555225
1 | 73751673 | 15 | 966222 | 20100615 | 20100219 | 400156 | 558077
1 | 73751436 | 15 | 966224 | 20100615 | 20100219 | 400310 | 566679
1 | 73808767 | 15 | 966225 | 20100615 | 20100219 | 400328 | 558094
73644768 | 15 | 966207 | 20100615 | 20100217 | 400566 | 556734
2010-06-05 00:00:00 | 3 | 2 | 73821222 | 15 | 966209 | 20100615 | 20100217 | 400706 | 557186
2010-06-05 00:00:00 | 3 | 2 | 73823953 | 15 | 966241 | 20100615 | 20100222 | 400115 | 566777
2010-06-05 00:00:00 | 3 | 2 | 73827486 | 15 | 966250 | 20100615 | 20100223 | 400247 | 557210
2010-06-05 00:00:00 | 3 | 2 | 73829790 | 15 | 966258 | 20100615 | 20100223 | 400840 | 572036
2010-06-05 00:00:00 | 3 | 2 | 73827988 | 15 | 966267 | 20100615 | 20100224 | 400960 | 558682
2010-06-11 00:00:00 | 3 | 2 | 73828002 | 15 | 966270 | 20100615 | 20100225 | 400003 | 558351
2010-06-05 00:00:00 | 3 | 2 | 73827985 | 15 | 966274 | 20100615 | 20100225 | 400659 | 571076
2010-06-11 00:00:00 | 3 | 3 | 73771120 | 15 | 966161 | 20100615 | 20100127 | 400029 | 549143
2010-06-11 00:00:00 | 3 | 3 | 73853927 | 15 | 966206 | 20100615 | 20100217 | 400504 | 550471
Spreadsheet: 805083d1668524394-merging-different-data-sets-with-different-formatting-into-one-based-on-quantity-filter-different-data-sets-_-merge-into-one
Sheet: Combine

Name | Quantity | mapping
[NAME] | 700 | yellow
[NAME] | 550 | yellow |  | <==== Desired Outcome (formula to sort the 3 different data sets from largest to smallest (quantity) from 'Data' sheet)
Apple | 500 | red
Orange | 400 | orange
[NAME] | 50 | white
Turkey | 19 | white
Beef | 18 | [NAME]
Chicken | 15 | white
Pasta | 6 | yellow
Spreadsheet: paul_lucci__28350__02~Jan
Sheet: December

RESOURCE SUPPLY |  |  |  | GAS PURCHASE PROGRAM
FOR IMMEDIATE DELIVERY TO:
 | CSU's GAS MARKETING REPRESENTATIVE
SHORT TERM GAS PROPOSAL REQUEST 1
GENERAL INFORMATION:
Term: |  | 2002-01-01 00:00:00 | to | 2002-01-31 00:00:00
Delivery Points: |  | ANY INTO CIG | EXCEPTIONS: | Powder River
> Volumes are baseload.
 | [NAME] requested: | 5000 | MMBTU/DAY
Our target is : |  |  | MMBTU for the month. (No guarantee on minimum volumes.)
 | Proposal Deadline: 11:00 a.m., Mountain Time: |  |  | 2001-12-20 00:00:00
 | *** Proposals may be FAXED to: [PHONE]  ***
 | Please note new fax #
Spreadsheet: 27964d1221731032-return-previous-entry-if-index-returns-a-blank-entry-in-a-broken-series-of-columns-flight-sched
Sheet: Sep 08

 | 2008-09-18 00:00:00 | 18
 | Sep-08 | 87 | 90 |  | Flight Schedule
 | Name | Last Location | Last Job | Changes / Comments | 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
 |  |  |  |  | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job #
 | Rich | TEST B | TEST 3 |  | Dpt | [NAME] | 2215 | OC815 | AUS812 | Arr | AKL | 0230 | OC815 | AUS812 | Dpt | AKL | 1330 | BA126 | NH | Trn | AKL - LHR |  | BA126 | NH | Arr | LHR | 0855 | BA126 | NH |  |  |  |  |  | [NAME] | EMA - ROM | 0920 - 1405 | EJ922 | ITA846 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST |  |  | TEST2 |  | TEST B |  |  | TEST 3
Spreadsheet: louise_kitchen__23884__ERCOT Hot List 04-13-01
Sheet: Deals Lost

Deal Type | Commercial Lead | Customer | Region | Prob.(%) | Deal Description | Term | Size | Price | Status | Date of Last Contact | Expected Completion Date | Expected Value
Origination | Tingleaf/Sukaly | AEP Frontera | ERCOT | 0 | Toll | 4/1/02-12/31/17 | 150 MW |  | AEP sold plant | 2001-01-22 00:00:00 | Q102
Origination | Parks/Sukaly | AES Frontera | ERCOT | 0 | Power Marketing (214 MW) |  |  |  | AEP sold plant
Origination | Parks/Sukaly/Tingleaf | AES Frontera | ERCOT | 0 | Tolling Deal (300 MW) |  |  |  | AEP sold plant
Origination | Parks/Sukaly/Ahn | AES [NAME] | ERCOT | 0 | Power marketing | 10/1/02-9/30/08 | 280 MW | 65-35% AES-EPMI sharing above a 10 heat rate | AES will use New Energy as their power market | 2001-02-06 00:00:00 | Q1
Origination | Curry/Parks/Ahn | Avista-Steag NRG | ERCOT | 0 | Energy Management |  |  |  | NRG refused to sign CA | 2001-01-05 00:00:00 | Q2
Origination | Curry | City of Bryan | ERCOT | 0 | Peaking Deal | 5/02 - 10/03 | 100 MW | $3.50 kW-mo for day-ahead; $4.50 kW-mo for intra-day | Canceled the RFP--said they didn’t need it |  | Q1
Origination | Ahn/Parks/Curry | Gregory Power Partners | ERCOT | 0 | QSE/Power Marketing | 4/1/01-3/31/06 |  | $570,000/year | Did not make short-list.  GPP needed gas manager | 2001-02-02 00:00:00 | Q2
Origination | Parks/Ahn | Ridge Energy Storage | ERCOT | 0 | Tolling Deal (500MW) |  |  |  | Price too high | 2000-12-21 00:00:00 | Q1
Origination | Tingleaf/Curry | TECO Fronterra | ERCOT | 0 | Power Marketing and QSE/AS | Five years starting June 1, '01 w/ option to extend five more years | 214 MW | 35% share above a 10,000Heat Rate | See Hot List
Origination | Ducote | TU Electric | ERCOT | 0 | Blend & Extend Gas Contract
Origination | Parks/Sukaly | ANP | ERCOT | 0 | Toll |  | 200 MW | $6.00 Capacity | ANP sent counter offer of $7.70--Price too high | 2001-02-20 00:00:00 | Q2 | 15000000
Origination | Ducote | San Antonio | ERCOT | 0 | Toll |  |  |  | Waiting to see if pipeline is built |  | Q3
Origination | Parks/Curry/Ahn | TNMP | ERCOT | 0 | QSE/AS/Power Supply Full-Req | 6/1/01-12/31/06 | 1025 MW weighted average est. peak | $5.88 kw-mo capacity; 7000 Heat Rate at Henry Hub + $[NAME] | Lost to Calpine | 2001-02-27 00:00:00 | Q1 | 5000000
Midmarketing | Curry | [NAME] | ERCOT | 0.5 | Flexible Schedule Call Option | 5/1/01-9/30/01 | 50 MW | $11,820/MW-Month Capacity Payment; 11,000 Heat Rate + .10 | Did not accept any offers for RFP | 2001-03-13 00:00:00 | 2001-03-23 00:00:00
Origination | Ahn | Cap-Rock Coop | ERCOT | 0.1 | QSE/AS |  | 5 MW |  | Did not make short-list. | 2001-02-28 00:00:00 | Q2 | 0
Spreadsheet: 09e6a2e2-2356-4f26-b5a7-d165817acf12
Sheet: ATTACK

Team | [NAME] | Set | PPG | PPB | 15PG
Alpharetta | ATTACK (National) | ATTACK | 278.3 | 17.82 | 1.88888888888889
Alpharetta B | ATTACK (Varsity) | ATTACK | 187.1 | 12.81
Athens Academy | ATTACK (National) | ATTACK | 287.2 | 19.88 | 2.33333333333333
Brookwood A | ATTACK (National) | ATTACK | 367.2 | 22.32 | 2.33333333333333
Brookwood B | ATTACK (Varsity) | ATTACK | 277.1 | 15.47
Chattahoochee A | ATTACK (National) | ATTACK | 307.2 | 20.34 | 2.11111111111111
Chattahoochee B | ATTACK (National) | ATTACK | 266.1 | 20.53 | 2.33333333333333
Chattahoochee C | ATTACK (Varsity) | ATTACK | 172.1 | 13.6
[NAME] | ATTACK (Varsity) | ATTACK | 248.6 | 13.8
Dorman A | ATTACK (National) | ATTACK | 478.9 | 24.91 | 7.33333333333333
Dorman B | ATTACK (National) | ATTACK | 307.2 | 18.19 | 2.55555555555556
Dorman C | ATTACK (National) | ATTACK | 193.3 | 16.43 | 1.66666666666667
East Paulding | ATTACK (Varsity) | ATTACK | 90.8 | 7.67
Eastside (GA) | ATTACK (Varsity) | ATTACK | 353.3 | 17.28
[NAME] | ATTACK (Varsity) | ATTACK | 130 | 10 | 0
GSMST | ATTACK (Varsity) | ATTACK | 326.1 | 16.45
Johns Creek A | ATTACK (Varsity) | ATTACK | 295.6 | 15.19
Johns Creek B | ATTACK (Varsity) | ATTACK | 133 | 11.29
[NAME] | ATTACK (Varsity) | ATTACK | 132.9 | 10.68
Marist A | ATTACK (National) | ATTACK | 270 | 20.66 | 2.22222222222222
Marist B | ATTACK (Varsity) | ATTACK | 265.7 | 13.51
Marist C | ATTACK (Varsity) | ATTACK | 98.3 | 8.12
Milton | ATTACK (Varsity) | ATTACK | 110 | 8.46
Norcross A | ATTACK (National) | ATTACK | 334.4 | 20.53 | 3.11111111111111
Oak Mountain Academy | ATTACK (Varsity) | ATTACK | 200.8 | 13.6
Prince Avenue | ATTACK (Varsity) | ATTACK | 135 | 10.64
River Ridge | ATTACK (Varsity) | ATTACK | 107 | 8.57
Roswell A | ATTACK (Varsity) | ATTACK | 255 | 14.83
Roswell B | ATTACK (Varsity) | ATTACK | 144.2 | 9.2
Sequoyah | ATTACK (Varsity) | ATTACK | 40.8 | 7.14
[NAME] | ATTACK (Varsity) | ATTACK | 23.3 | 4.44
Wesleyan | ATTACK (Varsity) | ATTACK | 280.7 | 17.54
Wheeler | ATTACK (Varsity) | ATTACK | 170 | 12.31
Woodland | ATTACK (Varsity) | ATTACK | 126.4 | 10.23
Spreadsheet: 600508d1543811879-conditional-formatting-sunday-tester-blank
Sheet: TimeSheet

 | Event: |  |  |  |  |  |  | Date:
 | Call Time:
 | Out Time: |  |  | Straight |  |  |  | OT |  |  | Straight
 | Employee Name | DEPT | No. | Hrs. | Rate | Amt. | DEPT2 | Hrs.2 | Rate2 | [NAME] | [NAME] | Rate3 | Amt.3 | Total
1 |  | CC |  | 2 |  |  | CC
 |  | Rg |  | 2 |  |  | Rg
 |  | Ha |  | 2 |  |  | Sp
 |  | Ha |  | 2 |  |  | Sp
 |  | Ha |  | 2 |  |  | Sp
 |  | Ha |  | 2 |  |  | Sp
 | TOTAL
Spreadsheet: 160683d1339165947-finding-and-adding-2-cells-sample-workbook
Sheet: Sheet1

 | Q1 SALES | Q1 CASES |  |  | Q2 SALES | Q2 CASES |  |  | YTD SALES | YTD CASES
CAT | 548 | 8 |  | BALL | 148 | 8 |  | BALL |  |  |  | <<<I need to add Q1 and Q2 together…
DOG | 861 | 5 |  | CAR | 2487 | 9 |  | CAR
TRUCK | 247 | 7 |  | DOG | 2482 | 2 |  | CAT
 |  |  |  | TRUCK | 9713 | 1 |  | DOG
 |  |  |  |  |  |  |  | TRUCK
Spreadsheet: 59a02d70-d777-4820-a50d-a27fa15a6b8d
Sheet: Vdam 13 mei

JURYINDELING ½-FINALE TURNEN HEREN TE VOLENDAM 13 MEI 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juryvergadering: 08.50 uur
BAAN 1 wedstrijd 4 EN 5 niv 10 EN 9 V |  |  |  |  |  |  | Supervisor: |  | BAAN 2 wedstrijd 4 EN 5 niveau 6,7 EN 8 V
 |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  | VLOER |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  | PAARD-VOLTIGE |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
Arno Pluk |  |  |  |  |  |  | RINGEN |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
Godfried Nankoe |  |  |  |  |  |  | SPRONG |  | Ruben Bakema
 |  |  |  |  |  |  |  |  | [NAME]
Ciska Fonville |  |  |  |  |  |  | BRUG |  | René de Koster
[NAME] |  |  |  |  |  |  |  |  | Sietske van der Veer
[NAME] |  |  |  |  |  |  | REKSTOK |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | Gijan Koedood
Spreadsheet: 53119d1253045505-average-top-mid-and-bottom-book1
Sheet: Sheet1

Gross | Gross
Margin | Margin% | Rank |  | Top 3 | 60.256
51.241 | 36.46% | 2 |  |  | 51.241
25.584 | 19.56% | 20 |  |  | 48.076
19.914 | 16.26% | 40
17.188 | 14.27% | 52 |  | Middle 3 | 18.282
19.167 | 15.55% | 43 |  |  | 18.212
6.828 | 5.23% | 84 |  |  | 17.547
48.076 | 29.17% | 3
18.282 | 13.78% | 47 |  | Bottom 3 | -8.63
16.896 | 12.75% | 58 |  |  | -5.524
16.124 | 12.14% | 64 |  |  | -5.334
16.549 | 12.27% | 59
17.021 | 14.07% | 56
17.128 | 14.44% | 53
18.742 | 15.23% | 46
17.547 | 14.61% | 49
14.55 | 12.19% | 69
15.552 | 12.94% | 67
12.982 | 7.14% | 73
14.896 | 8.19% | 68
21.01 | 9.01% | 34
25.646 | 38.39% | 19
20.011 | 16.54% | 38
18.962 | 15.77% | 44
19.48 | 16.50% | 42
9.803 | 9.24% | 79
9.42 | 8.88% | 80
4.627 | 4.36% | 86
4.891 | 4.61% | 85
19.985 | 16.56% | 39
14.427 | 9.86% | 70
60.256 | 35.29% | 1
21.511 | 12.63% | 30
16.295 | 14.89% | 61
15.715 | 14.36% | 66
17.126 | 16.15% | 54
17.09 | 16.11% | 55
22.949 | 21.05% | 25
28.381 | 25.42% | 15
31.899 | 28.12% | 10
13.532 | 12.76% | 71
3.795 | 4.62% | 89
4.062 | 5.02% | 87
1.09 | 1.39% | 90
1.072 | 1.36% | 91
-5.524 | -6.56% | 94
-5.334 | -6.33% | 93
-5.189 | -6.16% | 92
21.473 | 19.23% | 31
21.066 | 18.87% | 33
24.867 | 22.34% | 23
10.257 | 8.93% | 78
7.424 | 6.46% | 82
10.736 | 9.35% | 77
24.927 | 22.72% | 22
24.548 | 22.94% | 24
22.412 | 20.93% | 26
16.91 | 10.41% | 57
16.164 | 14.95% | 63
20.345 | 14.86% | 37
-8.63 | -9.99% | 95
16.48 | 10.60% | 60
3.974 | 2.45% | 88
22.298 | 13.99% | 27
31.39 | 28.72% | 11
28.79 | 16.96% | 13
20.952 | 15.14% | 35
35.187 | 21.87% | 8
29.341 | 14.21% | 12
16.116 | 23.86% | 65
21.224 | 15.24% | 32
39.81 | 19.25% | 6
26.197 | 23.72% | 17
25.89 | 23.45% | 18
21.768 | 19.05% | 29
25.189 | 22.05% | 21
19.758 | 20.69% | 41
40.662 | 29.19% | 5
39.802 | 28.58% | 7
42.141 | 21.31% | 4
11.796 | 12.27% | 76
12.149 | 12.64% | 74
12.001 | 12.48% | 75
17.328 | 13.99% | 50
22.075 | 17.84% | 28
18.78 | 15.17% | 45
16.246 | 13.13% | 62
20.792 | 16.80% | 36
17.258 | 13.94% | 51
18.212 | 14.71% | 48
28.565 | 19.89% | 14
13.346 | 17.65% | 72
32.867 | 23.42% | 9
7.47 | 6.89% | 81
7.285 | 6.72% | 83
27.305 | 18.15% | 16
Spreadsheet: 2b7ca935-fc22-44b2-80a9-6298b1229e68
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2267 | 10368 | Emilie | Darras | FRA | 0 | 0.43.54 | 00:00:00 | 0.58.02 | 00:00:00 | 0.52.34 | 3 | 2.34.30
2267 | 6522 | Radka | [NAME] | CZE | 73 | 0.34.27 | 00:00:00 | 0.44.52 | 00:00:00 | 0.35.35 | 1 | 1.54.54
2267 | 6007 | Lydia | Weydahl | NOR | 72 | 0.34.46 | 00:00:00 | 0.41.43 | 00:00:00 | 0.34.54 | 2 | 1.51.23
Spreadsheet: 551295d1512829071-compare-2-lists-and-leave-unmatched-items-compare-2-lists-problem
Sheet: Sheet1

Original Data
List 1 |  | List 2
apples |  | apples
apples |  | apples
apples |  | pears
grapes
I need the end result to be
List 1 |  | List 2
apples |  | pears
grapes
Hence, I need to:
1. Compare 2 lists
2. Remove any identical items
3. l Leave only the unmatched items.
Can anyone help?
Spreadsheet: 114871d1310564649-sumproduct-calculation-capex-and-opex-stock-distribution-spreadsheet-test
Sheet: Sheet1

 | A | B | C | D |  |  | E |  |  |  |  | F
 | Stock Out | Prod ID No. | Opex Stock in | Capex Stock In |  | ID No. | opex open stock | opex stock in | opex stock out | Opex Running Stock |  | capex open stock | capex stock in | capex stock out | Capex Running Stock |  | Total Running Stock
 | 10 | 001 |  |  |  | 001 | 50 | 0 |  | 50 |  | 10 | 0 | 10 | 0 |  | 50
 | 20 | 001
 |  | 001 |  |  |  | Spreadsheet needs to take stock out of capex stock first, and to take capex running stock to zero before stock starts to be taken out of the opex stock out column
 | The first entry of 10 in Stock out is taken from the Capex stock as it matches the current capex stock the next entry of 20 in the Stock out should come off the opex stock as it is now reverted to the secondary stock holding
 |  |  |  |  |  | A | This is the cumulative stock out for all items removed from the stock under the product id no. of 001 (this cannot be done with 2 columns for items being booked out.
 |  |  |  |  |  | B | The product id no. (the whole sheet will run from 001 to 1630)
 |  |  |  |  |  | C | Opex bought stock incoming
 |  |  |  |  |  | D | Capex bought stock incoming
 |  |  |  |  |  | E | Opex bought stock opening figure
 |  |  |  |  |  | F | Capex bought stock opening figure