tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 202879d1356783678-using-lookups-and-if-queries-together-scheduling
Sheet: UK

 | Port | Campaign | Demo | Packer |  |  | Total to be scheduled |  |  |  |  | 1 | YN
 | HK | 3 | 2000 | 132 |  |  |  |  |  |  |  | 2 | SH
 |  |  |  |  |  |  |  |  |  |  |  | 3 | HK
 |  |  |  |  |  |  |  |  |  |  |  | 4 | XM
 |  | Date | Qty |  |  |  |  |  |  |  |  | 5 | NG
 | 1 |  |  |  |  |  |  |  |  |  |  | 6 | QD
 | 2 |  |  |  |  |  |  |  |  |  |  | 7 | MN
 |  |  |  |  |  |  |  |  |  |  |  | 8
 | Total Purchase |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
Spreadsheet: 758179d1638722436-index-formulas-to-rearrange-from-vertical-to-horizontal-tf16400504_win32
Sheet: Shopping List

 |  | Shopping List | Recipe Index |  | Your shopping list is generated by the recipes selected on the Meal Planner worksheet. The amounts for repeated ingredients are aggregated in the amounts column of the table. The list is sorted for your convenience but filter buttons on the table headings help you search for specific entries. Mark the items you need to buy in the Need to Buy? column.
 | Item | Amount | Need to Buy? | Your shopping list is generated by the recipes selected on the Meal Planner worksheet. The amounts for repeated ingredients are aggregated in the amounts column of the table. The list is sorted for your convenience but filter buttons on the table headings help you search for specific entries. Mark the items you need to buy in the Need to Buy? column | Your shopping list is generated by the recipes selected on the Meal Planner worksheet. The amounts for repeated ingredients are aggregated in the amounts column of the table. The list is sorted for your convenience but filter buttons on the table headings help you search for specific entries. Mark the items you need to buy in the Need to Buy? column.
 |  |  | Yes
Spreadsheet: 103563d1301329225-copying-formulas-to-new-row-carshow
Sheet: Results by Owner Name & Town

Winners Class 1
 | Owner # | First Name | Last Name | Class | Make | Model | Year | Score
First Place | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Second Place
Thrid Place
Spreadsheet: 0b7fc49d-01c3-4804-a8b2-98ae9aae09e9
Sheet: Meigs

School |  |  | Scholarship | Experiation Date
Meigs |  |  | Rome-Canaan Alumni Association Scholarship | July 1st
 |  |  | Ohio State Fair Scholarship | May 1st
 |  |  | [NAME] and [NAME] Scholarship | May 1st
 |  |  | [NAME] Pomery Alumni Scholarship | May 12th
 |  |  | [NAME] Adam Grimm Scholarship | July 6th
 |  |  | Elks Lodge Scholarship | May 10th
 |  |  | The Friday Afternoon Businessmen's Group 2012 Scholarship | May 4th
 |  |  | [NAME] Memorial Scholarship | May 1st
 |  |  | [NAME] | May 1st
 |  |  | McComas-Moore Scholarship | May 1st
 |  |  | Rutland Alumni Scholarship | April 30th
 |  |  | [NAME]
Spreadsheet: 491270d1480386876-one-tab-just-wont-print-no-matter-what-example-dashboard
Sheet: Data List

Term 1 2015
Term 2 2015
Term 3 2015
Term 4 2015
Term 1 2016
Term 2 2016
Term 3 2016
Term 4 2016
Term 1 2017
Term 2 2017
Term 3 2017
Term 4 2017
Term 1 2018
Term 2 2018
Term 3 2018
Term 4 2018
Term 1 2019
Term 2 2019
Term 3 2019
Term 4 2019
Spreadsheet: 47677d1246858569-calendar-dates-dollar-amounts-and-assigning-points-test-variance-sheet
Sheet: Variance Tracking

Employee: | Cashier
Cashier Variances |  | TOTAL POINTS:
DATE | Comments
2009-03-21 00:00:00 | $0.10 Overage, Unknown |  | 0.1
2009-04-12 00:00:00 | $9.00 Shortage, Unknown |  | 9
2009-04-18 00:00:00 | $5.15 Overage, Unknown |  | 5.15
2009-04-24 00:00:00 | "" |  | 9
2009-04-27 00:00:00 | "" |  | 25.08
2009-05-01 00:00:00 | "" |  | 4.95
2009-05-23 00:00:00 | "" |  | 0.05
2009-05-30 00:00:00 | "" |  | 3.46
2009-06-06 00:00:00 | "" |  | 15
Spreadsheet: 717657d1612792146-if-then-statement-multiple-conditions-multiple-actions-using-or-if-then-sample-data
Sheet: RawData

ProductNumber | CreateDate | OldProductGroup | NewProductGRP
PROD5221660 | 2021-02-08 03:27:01 | Tools_Service
PROD5221661 | 2021-02-08 02:50:18 | Software_Service
PROD5221662 | 2021-02-08 02:46:15 | Managed_Service
PROD5221663 | 2021-02-08 02:00:24 | Cloud_Computing
PROD5221664 | 2021-02-08 01:36:05 | Consulting_Service
PROD5221665 | 2021-02-08 01:21:16 | Angel_Funding
PROD5221666 | 2021-02-07 08:12:00 | Tools_Service
PROD5221667 | 2021-02-07 07:59:50 | Software_Service
PROD5221668 | 2021-02-07 06:48:17 | Managed_Service
PROD5221669 | 2021-02-06 18:47:29 | Cloud_Computing
PROD5221670 | 2021-02-06 18:00:18 | Consulting_Service
PROD5221671 | 2021-02-06 14:20:45 | Angel_Funding
PROD5221672 | 2021-02-05 15:39:58 | Tools_Service
PROD5221673 | 2021-02-05 14:03:22 | Software_Service
PROD5221674 | 2021-02-05 11:51:17 | Managed_Service
PROD5221675 | 2021-02-05 10:23:55 | Cloud_Computing
PROD5221676 | 2021-02-05 09:09:57 | Consulting_Service
PROD5221677 | 2021-02-05 08:57:43 | Angel_Funding
PROD5221678 | 2021-02-05 08:26:01 | Tools_Service
PROD5221679 | 2021-02-05 08:14:28 | Software_Service
PROD5221680 | 2021-02-05 06:50:35 | Managed_Service
PROD5221681 | 2021-02-05 04:55:32 | Cloud_Computing
PROD5221682 | 2021-02-04 23:04:33 | Consulting_Service
PROD5221683 | 2021-02-04 20:35:33 | Angel_Funding
PROD5221684 | 2021-02-04 15:43:46 | Tools_Service
PROD5221685 | 2021-02-04 15:37:17 | Software_Service
PROD5221686 | 2021-02-04 14:35:49 | Managed_Service
PROD5221687 | 2021-02-04 14:28:12 | Cloud_Computing
PROD5221688 | 2021-02-04 13:35:23 | Consulting_Service
PROD5221689 | 2021-02-04 13:12:15 | Angel_Funding
Spreadsheet: 05ef1194-7e3e-4ee1-b9eb-3b4931d696cd
Sheet: Sheet1

Unnamed: 0 | RFP NO. 4-12 EXTERIOR CLADDING                                                                                                                                                                                                                                                                                                                                 OPENED:  APRIL 6, 2012                                              AWARDED:    nAY 15, 2012                                                                                                                                               BOLDED AREA INDICATES AWARD |  | Par Builders II, Inc.         138 Belcher Rd S         Largo, Fl 33771                 Ph: [PHONE]           Jerome Ciaravino         [EMAIL] | TPD Construction Co.     447 3rd Ave N #202         St. Petersburg, Fl 33701     Ph: [PHONE]          Kurt Dys                [EMAIL] | Flores & Harper Construction Company 3725 W Grace St #150    Tampa Fl 33607               Ph: [PHONE]             Mack Harper [EMAIL] | Semco Construction, Inc. 205 Century Blvd.         Bartow, Florida 33830     Ph: [PHONE]          [NAME], Jr.             [EMAIL] | [NAME]                    25436 Geddy Dr.                  Land o' Lakes, Fl 34639            Ph: [PHONE]                Alek Bynzar                    [EMAIL] | Unnamed: 8
 | [NAME] OF ITEM(S) |  | 1 | 2 | 3 | 4 | 5 | 6
A. | Total Project |  | 234000 | 297265 | 292619 | 368542.8 | 243526
B. | Deductions
 | 1. EIFS |  | 105000 | 154000 | 84395 | 176437 | 89500
 | 2. Interior |  | 17000 | 34000 | 49250 | 71684 | 43400
 | 3. Fiberglass Wall Liner Panels |  | 37000 | 40000 | 37800 | 57833 | 8700
 | 4. Folding Partitions & Support |  | 31522 | 32000 | 33500 | 36636 | 77000
 | 5. Steel Canopy - Convenience Store |  | 2000 | 5000 | 4825 | 8217 | 4900
 | 6. Landscaping |  | 1000 | 11000 | 14798 | 17735 | 2980
 | Time to Complete - Calendar Days |  | 110 | 106 | 95 | 116 | 80
 | Awarded Amount Deduct Line 6 Landscaping |  | 233000 | 286265 | 277812 | 350807.8 | 240546
Spreadsheet: 194666d1353287680-entries-in-one-cell-separeted-by-coma-reorgdata-w1-cola-colc-crittersik-ef877274-sdg15
Sheet: Sheet1

a, f, g
a, f, g
a, b, b |  |  |  |  |  |  | ReorgData w1 colA colC - crittersik - EF877274 - SDG15.xls
a, b, c |  |  |  |  |  |  | Today, 05:47 PM#1
 |  |  |  |  |  |  | entries in one cell separeted by coma
 |  |  |  |  |  |  | http://www.excelforum.com/excel-general/877274-entries-in-one-cell-separeted-by-coma.html
 |  |  |  |  |  |  | Hi!
 |  |  |  |  |  |  | Is it possible to be simply done?
 |  |  |  |  |  |  | I have a column of letters, but sometimes two or more letters in one cell, like:
 |  |  |  |  |  |  | 1 a, f, g
 |  |  |  |  |  |  | 2 a
 |  |  |  |  |  |  | 3 a, b, b
 |  |  |  |  |  |  | 4 a, b, c
 |  |  |  |  |  |  | I would like to have somewhere else a column of all the letters (don't care about repetitions):
 |  |  |  |  |  |  | 01:00:00
 |  |  |  |  |  |  | 2 f
 |  |  |  |  |  |  | 3 g
 |  |  |  |  |  |  | 3 a
 |  |  |  |  |  |  | 4 a
 |  |  |  |  |  |  | 5 b
 |  |  |  |  |  |  | ...... and so on
 |  |  |  |  |  |  | And also I would like to be able to find all cells that contain a specified letter, ex. a
 |  |  |  |  |  |  | I was trying to do that for a while but no luck
 |  |  |  |  |  |  | I would really appreciate someone's help!
 |  |  |  |  |  |  |  | A | B | C
 |  |  |  |  |  |  | 1 | a, f, g |  | a
 |  |  |  |  |  |  | 2 | a, f, g |  | f
 |  |  |  |  |  |  | 3 | a, b, b |  | g
 |  |  |  |  |  |  | 4 | a, b, c |  | a
 |  |  |  |  |  |  | 5 |  |  | f
 |  |  |  |  |  |  | 6 |  |  | g
 |  |  |  |  |  |  | 7 |  |  | a
 |  |  |  |  |  |  | 8 |  |  | b
 |  |  |  |  |  |  | 9 |  |  | b
 |  |  |  |  |  |  | 10 |  |  | a
 |  |  |  |  |  |  | 11 |  |  | b
 |  |  |  |  |  |  | 12 |  |  | c
 |  |  |  |  |  |  | 13 |  |  |  | end
Spreadsheet: 196120d1353863724-find-top-ten-occurence-numbers-in-a-matrix-sealpino_875363_mode_25nov12_01
Sheet: Sheet1

 | Counts >>>
Counts vvv | List |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<< Horizontal
 | ^^^^^^^^^^
 | Vertical
Spreadsheet: chris_germany__2336__2001tran04
Sheet: Apr Matrix

Transco FT Commodity |  |  |  |  |  |  |  |  | CGAS FT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.8 |  |  | 3.03
 | 1 | 2 | 3 | 4 | 4A | 5 | 6 |  | CGAS Fuel
1
2 |  |  |  |  |  |  |  |  | CNG FT
3 |  |  |  |  |  |  |  |  | CNG Fuel
4
4A
5 |  |  |  |  |  |  |  |  |  |  |  |  | St 65
6 |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 4.46 | 4.455
 | INCLUDES GRI ($0.0070) and Great Plains Surcharge ($0.0097) |  |  |  |  |  |  |  | Iroq -GRI |  |  |  | 4.42 | 4.44
TETCO | to:  St. 65 | STX | WLA | ELA |  |  |  |  | [NAME]
Zn 3 - 65 |  |  |  |  | "ELA Rate Assumes $0.0622 'IT'" |  |  |  | Total |  |  | Ela
TRCO IT Rates |  | 2 | 3 | 4 | 4A | 5 | 6
2
3
4
6
 | Note:  2-2, 2-3, and 3-3 rates do not include surcharges.
Tenn FT Commodity
 |  | Toca/Patt |  |  |  |  |  |  |  |  |  | [NAME]
 |  | Kinder | Hiedelburg
 | Chicago | Carnes | Rosehill | Pugh | Varibus | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 6
0 |  |  |  |  |  |  |  |  |  |  |  | Stx
L
1
2
4
5
6
MGT Rate |  |  |  |  | [NAME] include GRI of $0.0075
Fuel |  |  |  |  | [NAME] difference:
 |  |  |  |  | [NAME] difference:
TETCO FT Commodity using April - November Fuels
 | STX | LRC | [NAME] | M-1 | M-2 | M-3 |  |  | It to M2 | It to M3
STX
ETX
WLA
ELA
M1
M2
M3
 |  |  |  |  | Texas Gas FT Commodity
Sonat | 0-0 | 0-1 | 0-2 | 0-3 |  | SL-Inter | SL-Intra | 1 | 4
 |  |  |  |  | SL
 |  |  |  |  | 1
Gulf Onshore IT-Mainline FT |  |  |  |  | Algonquin |  |  | NFG | [NAME] 3 |  | FT
 | Off | On | Leach |  | Commodity and Fuel
Off |  |  |  |  | AFT-1
On |  |  |  |  |  |  |  |  | FEBRUARY, 2001
ML |  |  |  |  |  |  | TENNESSEE GAS PIPELINE: SPECIAL TRANS. RATES
 | Offshore and [NAME] are IT rates |  |  |  |  |  | 0 | L | 1 | 2 | 3
 |  |  |  |  |  | 0
 |  |  |  |  |  | L
Transport expense using Prices shown below |  |  |  |  |  | 1
Trco Z1 |  |  | CGLF On
[NAME] |  |  | M/L
Trco Z3 |  |  | TGT Sl
[NAME] |  |  | [NAME]
[NAME] |  |  | TGP/NFG Niagara
Stx |  |  | CNG SP
[NAME] |  |  | CGAS
Ela |  |  | Iroquois
M1
M3 |  |  | [NAME]
Spreadsheet: 803821d1667726328-how-to-do-fast-replacing-of-row-number-accross-different-columns-untitled-spreadsheet-1-
Sheet: Text

Princess Puff
PIB: 108214289 MB: 63296635 265-[PHONE]-14 Raiffeisen banka a.d. [NAME]
Laze Pačua 3, [NAME], 11000 [NAME] | DATUM:
 | BROJ FAKTURE
 | ZA: |  | prodaja kolača
Ispostavi račun:
Ime:
Adresa:
Telefon:
DEO GRADA:
Ime artikla | Cena | [NAME] |  | Ukupno
 |  |  | IZNOS | IZNOS
 | UKUPNO
Ako imate bilo kakvih pitanja u vezi sa ovom fakturom, obratite se na telefon [PHONE], [EMAIL] Fiskalni račun se izdaje tek pošto dostava preuzme novac- svoj fiskalni račun za ovu porudžbinu možete dobiti u našem lokalu uz navođenje broja porudžbine.
U ukupni iznos racuna uracunat je PDV po stopi od 10%
ZAHVALJUJEMO SE NA PORUDŽBINI!
Spreadsheet: 696332d1600762145-help-if-matching-value-return-1st-value-attach-file-sample-excel
Sheet: Sheet1

 | 0 | 5
 | 1 | 1
 | 2 | 2
 | 3 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 7 |  | 1 |  | 8
 | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 9 |  | 9 |  | 9
 | 5 | 5
 | 6 | 6
 | 7 | 7
 | 8 | 8
 | 9 | 9
 | 10 | 1
 | 11 | 2
 | 12 | 3
 | 13 | 4
 | 14 | 5
 | 15 | 6
 | 16 | 7
 | 17 | 8
 | 18 | 9
 | 19 | 1
 | 20 | 2
 | 21 | 3
 | 22 | 4
 | 23 | 5
 | 24 | 6
 | 25 | 7
 | 26 | 8
 | 27 | 9
 | 28 | 1
 | 29 | 2
 | 30 | 3
 | 31 | 4
 | 32 | 5
 | 33 | 6
 | 34 | 7
 | 35 | 8
 | 36 | 9
 | 37 | 1
 | 38 | 2
 | 39 | 3
 | 40 | 4
 | 41 | 5
 | 42 | 6
 | 43 | 7
 | 44 | 8
 | 45 | 9
 | 46 | 1
 | 47 | 2
 | 48 | 3
 | 49 | 4
 | 50 | 5
 | 51 | 6
 | 52 | 7
 | 53 | 8
 | 54 | 9
 | 55 | 1
 | 56 | 2
 | 57 | 3
 | 58 | 4
 | 59 | 5
 | 60 | 6
 | 61 | 7
 | 62 | 8
 | 63 | 9
 | 64 | 1
 | 65 | 2
 | 66 | 3
 | 67 | 4
 | 68 | 5
 | 69 | 6
 | 70 | 7
 | 71 | 8
 | 72 | 9
Spreadsheet: 28871e6d-f48e-4305-aee4-b67e586317dd
Sheet: Sheet1

Best Practices Workshop: Parts of Speech and Sentence Structure Survey Results, Sept. 28, 2012
1. This workshop is an effective follow-up to our assesment findings regarding student writing problems.
 |  | 1. Strongly Disagree | 0
 |  | 2. Disagree | 0
 |  | 3. Neutral | 0
 |  | 4. Agree | 10
 |  | 5. Strongly Agree | 13
2. I will apply some or all of these techniques in my classroom.
 |  | 1. Strongly Disagree | 0
 |  | 2. Disagree | 0
 |  | 3. Neutral | 0
 |  | 4. Agree | 11
 |  | 5. Strongly Agree | 12
3. I learned valuable strategies in today's workshop.
 | 1. Strongly Disagree | 0
 | 2. Disagree | 0
 | 3. Neutral | 0
 | 4. Agree | 9
 | 5. Strongly Agree | 14
Spreadsheet: 842131d1694186648-if-and-only-works-on-the-same-row-123
Sheet: Sheet1

 |  | Manual |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Refunds included if relevant
Status | Date | $ [NAME] | Order number | Card provider | Local / International | Country zone | Tracking number | Product SKU | Quantity | Product weight / g | Products total weight | Product cost (inc.direct costs) | Total order products cost | Shipping cost | Total order cost | Product price | Order products price | Order shipping price | Order total
In process | 2023-09-01 00:00:00 | 3.8 | 10334193 |  | International | 1 |  | 100004 | 1
In process | 2023-09-01 00:00:00 | 3.8 | 10334193 |  | International | 1 |  | 100012 | 1
In process | 2023-09-01 00:00:00 | 3.8 | 10334193 |  | International | 1 |  | 100023 | 1
Spreadsheet: vkaminski__40664__Position_030200
Sheet: Single Data Base

Counter | Input Date | Client Name : | Connection Voltage : | Generator / Load`s Area : | Location ( State ) : | Buy / Sell : | Executed / Not Executed : | Active ( Yes / No ) : | Curve : | Escalator : | Escalator Periodicity | LDC Name: | Start Date : | Maturity Date : | Aux Start Date | Aux Maturity Date | Working days first period | Working days Last Period | Contract Date | First of First Esc. | Generator`s Load Factor ( % ) : | NPVInvest | Peak Price ( R$ / MWh ) : | Off-Peak Price ( R$ / MWh ) : | Interruptible Price ( R$ / MWh ) : | Peak Volume ( MW ) : | Off-Peak Volume ( MW ) : | Interruptible Volume ( MW ) : | Interruptible Generation ( % ) : | Peak COG Price ( MWh ) : | Off-Peak COG Price ( MWh ) : | Interruptible COG Price ( MWh ) : | Loss Factor ( % ) : | Connection ( R$ / kW ) : | Transmission ( R$ / kW ) : | Distribution - Generator ( R$ / kW ) : | Distribution - Load Peak ( R$ / kW ) : | Distribution - Load Off-Peak ( R$ / kW ) : | Pis / Cofins ( % ) : | ICMS ( % ) : | CPMF ( % ) : | CCC ( R$ / MWh ) : | ANEEL Fiscalization ( R$ / MWh ) : | RGR ( R$ / MWh ) : | Connection Status | Transmission Status | [NAME] | Pis/Cof Status | ICMS Status | [NAME] | CCC Status | ANEEL Status | RGR Status
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-02-29 00:00:00 | 2000-09-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2 | 3 |  |  |  |  | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39
Counter
Input Date
Client Name :
Connection Voltage :
Generator / Load`s Area :
Location ( State ) :
Buy / Sell :
Executed / Not Executed :
Active ( Yes / No ) :
Curve :
Escalator :
Escalator Periodicity
LDC Name:
Start Date :
Maturity Date :
Aux Start Date
Aux Maturity Date
Working days first period
Working days Last Period
Contract Date
First of First Esc.
Generator`s Load Factor ( % ) :
NPVInvest
Peak Price ( R$ / MWh ) :
Off-Peak Price ( R$ / MWh ) :
Interruptible Price ( R$ / MWh ) :
Peak Volume ( MW ) :
Off-Peak Volume ( MW ) :
Interruptible Volume ( MW ) :
Interruptible Generation ( % ) :
Peak COG Price ( MWh ) :
Off-Peak COG Price ( MWh ) :
Interruptible COG Price ( MWh ) :
Loss Factor ( % ) :
Connection ( R$ / kW ) :
Transmission ( R$ / kW ) :
Distribution - Generator ( R$ / kW ) :
Distribution - Load Peak ( R$ / kW ) :
Distribution - Load Off-Peak ( R$ / kW ) :
Pis / Cofins ( % ) :
ICMS ( % ) :
CPMF ( % ) :
CCC ( R$ / MWh ) :
ANEEL Fiscalization ( R$ / MWh ) :
RGR ( R$ / MWh ) :
Connection Status
Transmission Status
[NAME]
Pis/Cof Status
ICMS Status
[NAME]
CCC Status
ANEEL Status
RGR Status
Spreadsheet: 267047d1379921328-using-hlookup-for-deriving-a-value-ef-sumproduct
Sheet: Sheet1

Aug | Channel A | 20 |  |  |  |  |  |  | Channel |  | Jul | Aug | Sep
Sep | Channel A | 25 |  |  |  |  |  |  | Channel A
Jul | Channel A | 15 |  |  |  |  |  |  | Channel B
Aug | Channel B | 35
Sep | Channel B | 40
Jul | Channel B | 30
Spreadsheet: 678938d1590133124-i-need-a-formula-that-can-help-me-to-to-flag-certain-value-example
Sheet: Sheet1

Name | Value | Number | Condiiton |  |  |  |  |  |  |  |  | All conditions
A | True | 23 | ABC | To flag if Value is True and number is less than 50 (but not negative), and codition is not the red words |  |  |  |  |  |  |  | ABD
B | False | 234 | DEF |  |  |  |  |  |  |  |  | DEF
C | False | 23 | GHI |  |  |  |  |  |  |  |  | GHI
D | False | 51 | GHI |  |  |  |  |  |  |  |  | JKL
E | True | -1 | GHI |  |  |  |  |  |  |  |  | MNO
F | False | -335 | GHI |  |  |  |  |  |  |  |  | PQR
G | False | 1 | GHI
H | False | 24 | GHI
I | True | 43 | PQR
J | False | 76 | GHI
K | False | 23 | GHI
L | False | 164 | GHI
M | True | 33 | MNO
N | False | 631 | GHI
O | False | -12 | GHI
P | False | -543 | GHI
Q | False | 12 | GHI
R | False | 1 | MNO
S | True | 413 | PQR
T | False | 23 | PQR
Spreadsheet: 128673d1321186978-compare-two-ranges-and-count-numbers-that-are-greater-or-less-by-8-count
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | 0 | 0 | 2 | 3 | 3 | 4 | 7 | 12
 |  |  | 0 | 0 | 1 | 2 | 2 | 3 | 9 | 17 |  | 4
 | F6 has a difference of 1 with  D5,E5 and F5 - so F6 is highlighted and counts as 1. As long as a value has a difference of 1 with any of the values in the previous range it counts as 1.
 | G6  has a difference of 1 with 2 of the values in the previous range
 | H6 has a difference of 1 with 2 of the values in the previous range
 | I6 has a difference of 1 with 1 value in the previous range
 | D6,E6, J6 and K6 don't have a difference of 1 with any of the values in the previous range
Spreadsheet: 56370d1256570169-formula-count-occurences-in-a-specific-time-period-sarahmad
Sheet: Sheet1

Hospital Number | Date | Theatre | Hour | Time into PACU | Date Out | Time Out of PACU
 | 2009-10-10 00:00:00 |  |  | 08:00:00 | 2009-10-10 00:00:00 | 11:20:00
 | 2009-10-10 00:00:00 |  |  | 20:50:00 | 2009-10-11 00:00:00 | 02:00:00
 | 2009-10-10 00:00:00 |  |  | 08:01:00 | 2009-10-11 00:00:00 | 23:00:00
Full Hours
Date | Hour | # Patients
2009-10-11 00:00:00 | 09:01:00 | 1
2009-10-11 00:00:00 | 21:00:00 | 1
 | Partial Hours
 | Hour | # Patients
2009-10-10 00:00:00 | 07:01:00 | 1
2009-10-10 00:00:00 | 21:00:00 | 2
Spreadsheet: 1be25a5f-aa36-4859-a150-54334041f108
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40355355 | 2014-03-04 20:17:08 | ALLIES | 0 | 2 | 4 | 1502683 | rmlsoro | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
40355591 | 2014-03-04 20:43:36 | AXIS | 1 | 4 | 3 | 1502683 | rmlsoro | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
Spreadsheet: 46349d1245248341-vlookup-and-dates-dashboard
Sheet: dashboard

197773 | 2005-06-10 00:00:00
197775 | 2005-06-10 00:00:00
197776 | 2005-06-10 00:00:00
197906 | 2005-06-14 00:00:00
198051 | 2005-06-14 00:00:00
198055 | 2005-06-14 00:00:00
198068 | 2005-06-14 00:00:00
198070 | 2005-06-14 00:00:00
198072 | 2005-06-14 00:00:00
198074 | 2005-06-14 00:00:00
198092 | 2005-06-15 00:00:00
198131 | 2005-06-15 00:00:00
198150 | 2005-06-15 00:00:00
198194 | 2005-06-15 00:00:00
Spreadsheet: 265986d1379456659-comparing-the-balance-of-a-paypal-account-with-other-numbers-from-the-spreadsheet-model-kits-for-forum
Sheet: Expenses

 | Sales Less paypal fees
 | less shipping expenses+ebay fees |  |  | F SHARE OF TOTAL
 | equals Profit from Kits: | Lots or [NAME] sold: | [NAME]
 | plus early Magazine profit | Average profit per kit:
 | 275.81
 | Total Profit
 |  |  |  | F SELLING CUT
 | Reimburse List: |  |  | M SHARE
 |  |  |  | R SHARE
 |  |  |  | F SHARE
 |  |  |  | F OWED
 |  |  |  | reimburse:
Spreadsheet: 872090d1718443372-need-help-in-tranposing-table-exam-results-sample
Sheet: Sheet2

StudentA12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StudentA2
 | 78 | 86 |  |  |  |  |  |  |  |  |  |  |  |  | StudentA3
Chinese Language - EXP | 81 | 81 |  |  |  |  |  |  |  |  |  |  |  |  | StudentA4
Design & Technology - CMN | VR | Not scored |  |  |  |  |  |  |  |  |  |  |  |  | StudentA5
English Language - EXP | 60 | 98.99999999999999 |  |  |  |  |  |  |  |  |  |  |  |  | StudentA6
Food & Consumer Education - CMN | 80 | 81 |  |  |  |  |  |  |  |  |  |  |  |  | StudentA7
Geography - EXP | 86 | 86 |  |  |  |  |  |  |  |  |  |  |  |  | StudentA8
History - EXP | 80 | 88 |  |  |  |  |  |  |  |  |  |  |  |  | StudentA9
Literature in English - EXP | 60 | 75 |  |  |  |  |  |  |  |  |  |  |  |  | StudentA10
Mathematics - EXP | 80 | 97 |  |  |  |  |  |  |  |  |  |  |  |  | StudentA11
Science - EXP | 60 | 68 |  |  |  |  |  |  |  |  |  |  |  |  | StudentA12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StudentA13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StudentA14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StudentA15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StudentA16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StudentA17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StudentA18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StudentA19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StudentA20