tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 827485d1682716882-how-to-make-a-consensus-list-consensusanswer
Sheet: Sheet1

Player # |  | Class | Strength | Experience | [NAME] |  |  | Player # | Order
1 |  | 2 | 11 | 6 | 10 |  |  | 11 | 1 |  |  | 1
2 |  | 6 | 2 | 12 | 11 |  |  | 2 | 2 |  | 2 | 2
3 |  | 11 | 10 | 4 | 1 |  |  | 6 | 2 |  | 6 | 2
4 |  |  | 12 |  |  |  |  | 10 | 2 |  | 10 | 2
5 |  |  |  |  |  |  |  | 12 | 2 |  | 12 | 2
6
7
8
9
10
11
12
13
Player # | 13 | Class | Strength | Experience | [NAME] |  |  | Player # | Order
 |  | 2 | 11 | 6 | 10 |  |  | 11 | 1 |  |  | 1
 |  | 6 | 2 | 12 | 11 |  |  | 2 | 2 |  | 2 | 2
 |  | 11 | 10 | 4 | 1 |  |  | 6 | 2 |  | 6 | 2
 |  |  | 12 |  |  |  |  | 10 | 2 |  | 10 | 2
 |  |  |  |  |  |  |  | 12 | 2 |  | 12 | 2
Spreadsheet: 185832d1349858822-sorting-non-empty-cells-to-bottom-schedule-example
Sheet: 2

2200-0000 |  |  | 0000-0200 |  |  | 0200-0400 |  |  | 0400-0600 |  |  | SUNDAY
TERI |  |  | TERI |  |  | TERI |  |  | TERI
CHAD |  |  | CHAD |  |  | CHRISTY |  |  | CHRISTY
CHRISTY |  |  | CHRISTY |  |  | DEBBIE |  |  | DEBBIE
CHARITY E |  |  | CHARITY E |  |  | JESSIE |  |  | JESSIE
KATHY |  |  | KATHY |  |  | JESS |  |  | JESS
DEBBIE |  |  | DEBBIE |  |  | CHARITY L |  |  | CHARITY L
JESSIE |  |  | JESSIE
JESS |  |  | JESS
CHARITY L |  |  | CHARITY L
0600-0800 |  |  | 0800-1000 |  |  | 1000-1200 |  |  | 1200-1400
TERI |  |  | JULIE |  |  | JULIE |  |  | JULIE
JULIE |  |  | VAL |  |  | VAL |  |  | VAL
VAL |  |  | [NAME] |  |  | ANGELA |  |  | ANGELA
[NAME] |  |  | KELLY |  |  | [NAME] |  |  | [NAME]
KELLY |  |  | KATY |  |  | KELLY |  |  | KELLY
KATY |  |  |  |  |  | KATY |  |  | KATY
 |  |  |  |  |  | JESSICA |  |  | JESSICA
 |  |  |  |  |  | TAMMY |  |  | TAMMY
1400-1600 |  |  | 1600-1800 |  |  | 1800-2000 |  |  | 2000-2200
JULIE |  |  | CHAD |  |  | CHAD |  |  | CHAD
VAL |  |  | ANGELA |  |  | ANGELA |  |  | ANGELA
ANGELA |  |  | JESSICA |  |  | JESSICA |  |  | STEPHANIE
[NAME] |  |  | CHARITY E |  |  | CHARITY E |  |  | CHARITY E
KELLY |  |  | KATHY |  |  | KATHY |  |  | KATHY
KATY |  |  | TAMMY |  |  | TAMMY |  |  | JESSIE
TAMMY |  |  |  |  |  |  |  |  | JESS
 |  |  |  |  |  |  |  |  | CHARITY L
Spreadsheet: 525651d1498821543-help-for-sum-of-different-columns-with-a-multiplying-based-on-condition-kenytr
Sheet: Sheet1

 |  |  |  |  |  |  | X | Y
 | 1000 | X | 1 | X |  |  | 1000 | 360
 | 600 | X/Y | 0.4 | Y |  |  | 240 | 800
 | 800 | Y | 0 |  |  |  | 400 | 200
 | 400 | X | 1 |  |  |  | 275 | 225
 | 200 | Y | 0
 | 500 | X/Y | 0.55
Spreadsheet: 853126d1703066481-formula-need-for-payroll-vlookup-or-if-excel-form
Sheet: Date Base

Employee No. | Employee Full Name | Basic | Food Allowance | Housing  Allowance | Transportation | Phone Allowance | OT | Other Allowance | Gross Salary
1 | XYZ | 4000 | 300 | 2500 | 800 | 300 | 0 | 300
2 | ABC | 3000 | 200 | 1500 | 500 | 100 |  | 500
3 | QAS | 2000 | 100 | 500 | 200 | 100 | 0 | 700
Spreadsheet: 68258d1268782487-matching-help-test-matching
Sheet: info

assetnum | serialnum | assettag | location | description
6164 | 151464 |  | 14AL1801A | ANALYZER: VAPOR DESTRUCTOR O2 (O2)
6165 | 151464 |  | 14AL1801B | ANALYZER: VAPOR DESTRUCTOR O2 (O2)
6166 | 980600246 |  | 14AL3801 | ANALYZER: VAPOR PRESSURE ([NAME])
3025 | DW41062 |  | 14C047 | COMP: TRK. [NAME]. COMP.
Spreadsheet: c1529e66-09ae-4e02-92e4-a5093832a314
Sheet: Cb.markers

symbol | Cs_A1 | Cs_B1 | Cs_C1 | Cn_A3 | Cn_B3 | Cn_C3 | Cb_A2 | Cb_B2 | Cb_C2 | Cm_A4 | Cm_B4 | Cm_C4 | Vs_A5 | Vs_B5 | Vs_C5 | Vn_A7 | Vn_B7 | Vn_C7 | Vb_A6 | Vb_B6 | Vb_C6 | Vm_A8 | Vm_B8 | Vm_C8
NTS | 91.2247133333333 | 92.8304491666667 | 91.1125941666667 | 86.40823 | 89.7999629166667 | 85.1955345833333 | 152.040116666667 | 209.9278 | 179.393316666667 | 87.64431 | 88.9659804166667 | 96.8703429166667 | 93.4045925 | 88.0857020833333 | 90.0209670833333 | 86.8008508333333 | 95.4252195833333 | 87.5225845833333 | 97.7200441666667 | 95.8458154166667 | 98.1985508333333 | 89.43159625 | 88.2569741666667 | 95.5155070833333
SLC45A4 | 356.0148375 | 406.556525 | 303.936770833333 | 261.951579166667 | 233.947795833333 | 233.889020833333 | 110.890240416667 | 105.1581 | 114.242100833333 | 222.8413125 | 174.052245833333 | 219.221895833333 | 310.679904166667 | 395.7481 | 252.9444125 | 183.210283333333 | 429.235225 | 232.59925 | 229.41925 | 202.715904166667 | 209.603383333333 | 200.888166666667 | 189.3596125 | 176.989054166667
Spreadsheet: 673738d1587508963-if-or-not-multiple-with-left-function-excel-eg-questray-
Sheet: Sheet1

 | Check starts with 0 |  |  |  | Check starts with any of 01/02/03/04/05/06/070/08/09
[PHONE] |  |  |  | [PHONE]
[PHONE] |  |  |  | [PHONE] |  |  |  | 01 | OK
[PHONE] |  |  |  | [PHONE] |  |  |  | 02 | OK
[PHONE] |  |  |  | [PHONE] |  |  |  | 03 | OK
[PHONE] |  |  |  | [PHONE] |  |  |  | 04 | OK
[PHONE] |  |  |  | [PHONE] |  |  |  | 05 | OK
[PHONE] |  |  |  | [PHONE] |  |  |  | 06 | OK
[PHONE] |  |  |  | [PHONE] |  |  |  | 08 | OK
[PHONE] |  |  |  | [PHONE] |  |  |  | 09 | OK
 |  |  |  |  |  |  |  | 070 | OK
Spreadsheet: sally_beck__34331__PROPOSAL TEMPLATES
Sheet: Approval List

BU Group | PP Grp | Approvals
EBS - DIP | DEBSE, DEBSC, DEBSW | [NAME], [NAME]
EBS - Non DIP | EBSE, EBSC, EBSW | [NAME], [NAME]
EEC - Non DIP | EECE, EECC, EECW | [NAME]
EEC -DIP | DEECE, DEECC, DEECW | [NAME]
EES - DIP | DEESE, DEESC, DEESW | Wade Stubblefield, [NAME], [NAME]
EES -Non DIP | EESE, EESC, EESW | Wade Stubblefield, [NAME], [NAME]
EGA -Non DIP | EGAE, [NAME], EGAW | [NAME], [NAME], [NAME]
EGF - DIP | DEGFE, DEGFC, DEGFW | [NAME], [NAME]
EGF - Non DIP | EGFC, EGFE, EGFW | [NAME], [NAME]
EGM - DIP | DEGME, DEGMC, DEGMW | [NAME], [NAME]
EGM - Non DIP | EGMC, EGME, EGMW | [NAME], [NAME]
EGP - Non DIP | EGPW,EGPC, EGPE | [NAME], [NAME]
EIM - DIP | DEIME, DEIMC, DEIMW | [NAME], [NAME], [NAME]
EIM - Non DIP | EIMW, EIME, EIMC | [NAME], [NAME], [NAME]
EMTH - Non DIP | EMTHE, EMTHC, EMTHW | [NAME], [NAME], [NAME]
ENA - DIP | DENAE, DENAC, DENAW | [NAME], [NAME], [NAME]
ENA - Non DIP | ENAC, ENAC, ENAW | [NAME], [NAME], [NAME]
ENE - DIP | DENEE, DENEC, DENEW | [NAME], [NAME]
ENE - Non DIP | ENEC, ENEE, ENEW | [NAME], [NAME]
ENW - DIP | DENWE, DENWC, DENWW | [NAME], [NAME], [NAME]
ENW - Non DIP | ENWC, ENWE, ENWW | [NAME], [NAME], [NAME]
EPI - Non DIP | EPIE, EPIC, EPIW | [NAME], [NAME], [NAME]
ETS - DIP | DETSE, DETSC, DETSW | [NAME], [NAME], [NAME], [NAME]
ETS - Non DIP | ETSE, ETSC, ETSW | [NAME], [NAME], [NAME], [NAME]
MTL - Non DIP | MTLW | [NAME], [NAME]
Spreadsheet: 145830d1331757636-using-dates-to-calculate-rent-rolling-income-for-excell-help-forum-v2
Sheet: Rolling Forecast

 |  |  |  |  |  | 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 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51
File Id | Early Termination Date | [NAME] | Rent Obligation from - 02/01/12 - until Early Term Date | [NAME] | Sublease Start Date | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | Total
L1 | 2011-10-31 00:00:00 | 0 | 0 | 0
L2 | 2013-10-31 00:00:00 | 21 | 210000 | 190000 | 2012-04-01 00:00:00
S2 |  | 19
L3 | 2012-03-31 00:00:00 | 2 | 20000 | 0
[NAME] | 2012-07-15 00:00:00 | 5.5 | 16600 | 0
L5 | 2012-03-31 00:00:00 | 2 | 20000 | 0
L6 | 2013-07-31 00:00:00 | 18 | 180000 | 84648.16674999999 | 2013-01-01 00:00:00
S6 |  | 7 | 70000
 |  |  |  |  |  |  |  |  |  |  |  | Cell L8 should be this because of the 15 Days in July of Rent Obligatoion
 |  |  |  |  |  |  |  |  |  |  |  | Days from 2/1/12 to Early Term Date
 |  |  |  |  |  |  |  |  |  |  |  | Daily Rent
 |  |  |  |  |  |  |  |  |  |  |  | Days in Each Month
Spreadsheet: 796025d1663072562-google-sheets-countifs-until-a-sumif-condition-is-met-question_v2
Sheet: Sheet1

 | Input
 | Desired Output
 | Initial Stock | 100
 | Date of stockout: | 2022-09-22 00:00:00
 | Sales forecast | 10
 | Stock coverage in days | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0
 | Desired output 1: On which day am I going out of stock? Ie when is the sum of sales forecast>= my current stock
 | Desired output 2: Stock coverage (in days) on any given day. Ie how many days of stock are left on the 15th Sep?
 | Expected result: 22-Sep
 | Expected result 2: on 15th Sep there are 8 days of stock left
 | Limitation: no helper row/column
Spreadsheet: 734343d1622118650-coloring-cells-by-conditional-formating-with-fis-testkleur-rijen2-keebellah-
Sheet: nl (3)

Project | datum | vertrek | via | aankomst | Tijd | wie nederland | wie Duitsland | [NAME] | nummer | telefoon | tropcos | beg NL | Beg D | ROOD | GROEN
5258 |  |  | waldseite sud |  |  | [NAME] | nl
5259 |  |  | waldseite sud |  |  | [NAME] | nl
5259 |  |  | waldseite sud |  |  |  | nl
5259 |  |  | waldseite sud
5259 |  |  | waldseite sud |  |  | [NAME]
5260 |  |  |  |  |  | [NAME]
5260 |  |  |  |  |  |  | nl
5258 |  |  | waldseite sud |  |  | [NAME] | nl
5259 |  |  |  |  |  | [NAME] | nl
5259 |  |  | waldseite sud |  |  |  | nl
5259 |  |  | waldseite sud
5259 |  |  | waldseite sud |  |  | [NAME]
5260 |  |  |  |  |  | [NAME]
5260 |  |  |  |  |  |  | nl
Spreadsheet: 3d57c3d1-3748-438e-bbbd-855e8d74ce20
Sheet: Sheet1

Индекс цен в строительстве | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
в процентах
 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013
на конец периода, к декабрю предыдущего года
Все элементы технологической структуры | 179.2 | 117.3 | 104.4 | 106.5 | 106.7 | 106.5 | 108.8 | 104.5 | 103 | 105.6 | 105.3 | 105 | 107.1 | 108.5 | 104.5 | 103.6 | 105.4 | 104.6 | 103.3
строительно-монтажные работы | 165.8 | 110.6 | 104.8 | 108.9 | 110.2 | 107.9 | 111.6 | 106.3 | 104.3 | 105.6 | 104.9 | 104.9 | 107.5 | 108.4 | 104.4 | 102.9 | 105.6 | 105.3 | 103.5
машины и оборудование | 159.1 | 121.3 | 103.5 | 104.4 | 102.7 | 102.6 | 104.5 | 102 | 101.7 | 108 | 107.3 | 104.4 | 106.7 | 109.4 | 104.2 | 107.7 | 106.6 | 102.5 | 101.3
[NAME] работы и затраты | 396 | 139.4 | 104.4 | 104.3 | 103.7 | 108.8 | 107.6 | 103.9 | 101.6 | 102.7 | 103.7 | 105.9 | 106.3 | 107.9 | 105.2 | 103.6 | 104.3 | 104.2 | 104
к предыдущему году
Все элементы технологической структуры | 319.4 | 133.2 | 105.3 | 108.1 | 105 | 108.7 | 107.6 | 106.3 | 103.5 | 104.2 | 106 | 105 | 105.8 | 108.1 | 105.8 | 104.6 | 104.6 | 104.9 | 103.8
строительно-монтажные работы | 303.9 | 126.6 | 102.5 | 109.9 | 107.3 | 111.6 | 109.4 | 108.6 | 105.1 | 105.3 | 105.1 | 105.1 | 106.2 | 108.3 | 105.4 | 104.2 | 104.3 | 105.4 | 104
машины и оборудование | 316.4 | 130.6 | 109.7 | 104.4 | 101.7 | 103.7 | 103.6 | 102.6 | 102.1 | 104 | 109.6 | 104.7 | 105.6 | 108.4 | 106 | 106.6 | 107.6 | 103.8 | 102.2
[NAME] работы и затраты | 468 | 176 | 108.2 | 110.6 | 104.2 | 108.7 | 108.2 | 105.7 | 102 | 102.3 | 104 | 105.1 | 104.8 | 107.1 | 106.8 | 104.6 | 103.9 | 104.3 | 104.1
Spreadsheet: lynn_blair__24320__INTERCONNECT NOMvsSCHED
Sheet: Dec 4

 |  | INTERCONNECT NOMINATED vs. SCHEDULED FOR NNG
 | Gas Day: | 12/04/01 |  | Cycle: |  | Timely |  | Evening |  | IntraDay 1 |  | IntraDay 2
 |  |  |  | Prior Day | Prior Day |  |  |  |  |  |  |  |  | REDUCTION
IC PIPE | POI | K# | Gas Type | [NAME] | Sched | NOM | SCHED | NOM | SCHED | NOM | SCHED | NOM | SCHED | REASON
EPNG | 169 | Nothing significant to report
 | 186
 | 2618
 | 57088
 | 57100
[NAME] | 2174 | Nothing significant to report
OASIS | 64128 | Nothing significant to report
PEPL | 173 | 108321 |  | 7495 | 7495 | 0 | 0 | 0 |  |  |  |  |  | noms dropped to zero
 |  | 107628 |  | 6428 | 6428 | 0 | 0 | 0 |  |  |  |  |  | noms dropped to zero
 |  | 100796 |  | 15288 | 15288 | 0 | 0 | 0 |  |  |  |  |  | noms dropped to zero
TWPL | 3531 | Nothing significant to report
 | 60667
 | 60749
ENA/LE330 |  | K# | Gas Type |  |  | NOM | SCHED | NOM | SCHED | NOM | SCHED | NOM | SCHED | REASON
[NAME] | 37654 | 100919 | IT |  |  | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | PBR - Pool Mismatches
 |  | 101099 | [NAME]
Note: | K#101099 is an administrative contract set up to reimburse ENA for providing Electricity to operate the electric compressors on NNG.
 | This gas should continue to flow when nominated.  The volume is 2,010 dth per day for December.  If you have any questions, please call.
 | [NAME].
 | K#108452 nominated 10,000 receipt point at POI #1709 ([NAME] Ranch)--confirmed to zero during all cycles. [NAME], 3-3063
Spreadsheet: 731569d1620413700-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: TRX

S.N. | Particulars | Bought  Units | Unit or TRX Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | [NAME] | 47802.15 | 2.51e-06 |  | -0.1201035 | 14172 | 2017-12-25 00:00:00 | 2017-12-25 00:00:00
2 | [NAME] | -28400 | 4.23e-06 |  | 0.120132 | 13863.1 | 2017-12-31 00:00:00
3 | Fees for transferring 19402.15 XRP from Binance to Ledger (via MEW) | -100 |  |  |  |  | 2018-01-02 00:00:00
4 | [NAME] | -19302.15 | 4.81e-06 |  | 0.09280378 | 10832.28 | 2018-03-02 00:00:00
5 | [NAME] | 58555.93465909 | 4.17e-06 |  | -0.24537567 | 8706.44 | 2018-03-22 00:00:00 | 2018-03-22 00:00:00
6 | [NAME] | -58555.93465909 | 5.99e-06 |  | 0.35045726 | 8984.31 | 2018-03-23 00:00:00
7 | [NAME] |  | 5.66e-06 |  |  | 8908 | 2018-03-27 00:00:00 | 2018-03-27 00:00:00
8 | [NAME] | -362041 | 5.67e-06 |  |  | 8908 | 2018-03-27 00:00:00
9 | [NAME] | 366855 | 5.59e-06 |  |  | 8908 | 2018-03-27 00:00:00 | 2018-03-27 00:00:00
10 | [NAME] | -366855 | 5.65e-06 |  |  | 8908 | 2018-03-27 00:00:00
11 | [NAME] |  | 6.53e-06 |  |  | 7083 | 2018-03-29 00:00:00 | 2018-03-29 00:00:00
12 | [NAME] |  | 5.8e-06 |  |  | 7083 | 2018-03-29 00:00:00
13
14
15
 | Next Buy
 | TRX in [NAME] (via MEW) | 0
 | TRX in Bittrex | 0
 | TRX in Binance | 0.967
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: 687716d1595359533-calculated-columns-in-power-query-for-staggered-product-launches-staggered-product-launch-model
Sheet: Model

 |  |  | 1 | 2 | 3 | 4 | 5
 | Product Unit Modelling
 | Product X Revenue |  | 10 |  |  |  |  |  | <-- Revenue profile of launching one product
 | Product Launch Schedule
 | Product X Additions (Launches) |  | 1 | 1 | 2 | 3 | 5 |  | <-- How many of the above products will be launched in each year
 | Total Products X's (Cumulative) |  |  |  |  |  |  |  | <-- Cumulative total of no. of products that exist in each year
 | Company Revenue | Launches
 | Revenue from Product X's launched in Year 1
 | Revenue from Product X's launched in Year 2
 | Revenue from Product X's launched in Year 3
 | Revenue from Product X's launched in Year 4
 | Revenue from Product X's launched in Year 5
 | Total Company Revenue |  |  |  |  |  |  |  | <-- Total revenue generated from launching products according to the above schedule
 | Once I have the above cells in Yellow, I'll be able to [NAME] and get the following final results.
 | Account | Year | Amount
 | Total Company Revenue
 | Total Company Revenue
 | Total Company Revenue
 | Total Company Revenue
 | Total Company Revenue
Spreadsheet: 167469d1342007449-multiple-column-sum-product-based-on-set-criteria-usage-10th-july-2012
Sheet: Pot v Act purchase scrap

 |  |  | [NAME] 29th June to 1st July 2012
 | Potential usage |  |  |  |  | Actual usage
 | No. of Pans | type 6 | Type 5 | Type 5 & 6 |  |  | No. of Pans | Type 6 | Type 5 | Type 5 & 6
A Pan | 0 | 0 |  |  |  | A | 0 | 0 | 0
B Pan | 15 | 75 | 75 |  |  | B | 15 | 188.68 | 83.78
C Pan | 6 |  | 150 |  |  | C | 6 | 48.66 | 34.76000000000001
S Pan | 10 |  | 150 |  |  | S | 10 | 91.18 | 93.02
F Pan | 0 |  | 0 |  |  | F | 0 | 0 | 0
M | 0 | 0 |  |  |  | M | 0 | 0 | 0
N | 0 | 0 |  |  |  | N | 0 | 0 | 0
O | 0 | 0 |  |  |  | O | 0 | 0 | 0
P | 0 | 0 |  |  |  | P | 0 | 0 | 0
Total | 31 | 75 | 375 |  |  | Total | 31 | 328.52 | 211.56
Grand total |  |  |  | 450 |  | Grand total |  |  |  | 540.0799999999999
 | No. of Pans | type 6 | Type 5 | Type 5 & 6 |  | Average Pan Weight
A Pan | 0 | 0 | 0 |  |  | A
B Pan | 15 | 113.68 | 8.780000000000001 |  |  | B | 57.216
C Pan | 6 | 48.66 | -115.24 |  |  | C | 51.66666666666666
S Pan | 10 | 91.18 | -56.98 |  |  | S | 45
F Pan | 0 | 0 | 0 |  |  | F
M Pan | 0 | 0 | 0 |  |  | M
N Pan | 0 | 0 | 0 |  |  | N
O Pan | 0 | 0 | 0 |  |  | O
P Pan | 0 | 0 | 0 |  |  | P
Total | 31 | 253.52 | -163.44 |  |  | All Pan Average | 52.20129032258065
Grand total |  |  |  | 90.08000000000001
 |  |  | Under used
 |  |  | Correct Usage
 |  |  | Incorrectly used
Spreadsheet: 734469d1622187173-multi-if-and-function-for-range-of-cell-something-wrong-in-formula-multi-if
Sheet: Sheet1

Well | AAAA | BBBB | CCCC | DDDD |  |  | Interpretation
A01 |  | 31.28
A02 |  | 30.93
A03 |  | 30.38
A04 |  | 31.61
A05 |  | 30.69
A06 |  | 31.16
A07 |  | 31.52
A08 |  | 31.3
A09 |  | 30.45
A10 |  | 36.22
A11 |  | 31
A12 |  | 30.01
B01 |  | 31.97 | 37.28
B02 | 23.5 |  | 23.04 | 24.46
B03 |  | 30.19
B04 |  | 30.54
B05 |  | 29.75
B06 |  | 28.94
B07 |  | 29.46 | 38.8
B08 |  | 33.31
B09 |  | 28.76
B10 |  | 29.87
B11 |  | 28.96
B12 |  | 29.45
C01 |  | 30.14
C02 |  | 28.61
C03 |  | 29.38
C04 |  | 30.65
C05 |  | 30.77
C06 |  | 30.1
C07 |  | 29.15
C08 |  | 29.05
C09 |  | 29.85
C10 | 19.99 |  | 20.57 | 20.8
C11 |  | 28.88
C12 |  | 29.84
D01 |  | 28.98
D02 |  | 29.47
D03 |  | 28.6
D04 |  | 28.46
D05 |  | 28.95
D06 |  | 28.42
D07 |  | 29.38
D08 |  | 29.45
D09 |  | 28.63
D10 |  | 28.14
D11 |  | 28.62
D12 |  | 29.41
E01 |  | 30.06
E02 |  | 29.85
E03 |  | 29.14
E04 |  | 29.32
E05 |  | 28.53
E06 | 35.96 | 28.54
[NAME] |  | 29.11
E08 |  | 29.93
E09 |  | 29.04
E10 |  | 29.51
E11
E12 | 24.86 |  | 25.89 | 25.55
Spreadsheet: 113124d1309096778-help-with-time-formula-targets
Sheet: July 2011

Days | Calls |  |  |  |  | GSR |  |  |  |  | Surveys
 | Session I | Session II | Session III | Session IV |  | Session I | Session II | Session III | Session IV |  | Session I | Session II | Session III | Session IV
 | 49.99999999999998 | 49.99999999999999 | 25.00000000000004 | 25 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | Calculations |  | Difference
Day 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | 07:00:00 | 149.9999999999999
Day 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Break 1 | 09:30:00 | 150
Day 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lunch | 12:15:00 | 75.00000000000011
Day 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Break 2 | 14:00:00 | 75
Day 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stop | 15:30:00 | 7.5
Day 6
Day 7
Day 8
Day 9
Day 10
Day 11
Day 12
Day 13
Day 14
Day 15
Day 16
Day 17
Day 18
Day 19
Day 20
Day 21
Day 22
Spreadsheet: 732419d1620935517-help-with-indexing-formula-example-sheet
Sheet: Detail

Customer Number | Customer Name | City | Market Segment | Reps | Products
1 | Example 1 | City 1 | Market 1 | Rep 1 | Product 1
1 | Example 1 | City 1 | Market 1 | Rep 3 | Product 2
1 | Example 1 | City 1 | Market 1 | Rep 6 | Product 3
1 | Example 1 | City 1 | Market 1 | Rep 8 | Product 4
1 | Example 1 | City 1 | Market 1 | Rep 9 | Product 4
2 | Example 2 | City 2 | Market 2 | Rep 2 | Product 2
2 | Example 2 | City 2 | Market 2 | Rep 4 | Product 3
2 | Example 2 | City 2 | Market 2 | Rep 6 | Product 4
2 | Example 2 | City 2 | Market 2 | Rep 8 | Product 5
3 | Example 3 | City 3 | Market 3 | Rep 1 | Product 3
3 | Example 3 | City 3 | Market 3 | Rep 3 | Product 2
Spreadsheet: 13ed5817-fd61-4bda-883b-43f02093ff13
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
43542462 | 2014-10-12 03:04:55 | ALLIES | 1 | 5 | 3 | 711155 | [NAME] | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
43542667 | 2014-10-12 03:20:21 | AXIS | 1 | 5 | 3 | 711155 | [NAME] | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
Spreadsheet: 774619d1648568621-match-words-in-a-list-to-strings-in-another-column-then-highlight-rows-with-matches-workbook
Sheet: Sheet1

Search term | The full workbook has over 100k entries
iphone 11 pro contract deals
i phone 11 pro [NAME] deals
apple phone
iphone 1 year contract
apple iphone contract deals
cheapest iphone 11 sim free
i phone 11 mobile & smart phones
iphone 11 max mobile & smart phones
best iphone deal uk
how much is an iphone 11 worth
how much is an iphone 11 worth
11
iphone 11 u switch
how much is my iphone 11 pro max worth
how much is an iphone 11 pro max worth
how much is the iphone 13 worth
how much are iphone 13 worth
how much is my iphone 13 worth
how much is an iphone 13 worth
iphone 13 worth
how much is an iphone 11 worth
Spreadsheet: 217506d1362084670-consolidate-by-two-factors-new-problem
Sheet: December2012

 |  |  |  |  |  |  |  |  |  |  |  | 0.27
Customer | Name | Product | Description | Qty | m2 | Value | Av Price | Matl Cost | Yield AdJ | Purch Cost | Tot Matl Cost | ES Cost
304 | Customer B | 512084 | energiKare(TM) | 1 | 0.3 | 32.25 | 107.5 | 0 | 0 | 4.49 | 4.49 | 0.81
304 | Customer B | 99999999 | Energy Surcharge | 0 | 0 | 0.86 | 0 | 0 | 0 | 0 | 0 | 0
3152 | Customer C | 102604 | 4mm Oriel Collection Laurel st | 2 | 5.64 | 386.84 | 68.59 | 143.31 | 188.5657894736842 | 0 | 188.5657894736842 | 15.228
3152 | Customer C | 500044 | Insulight(TM) | 157 | 100.7 | 1823.95 | 18.11 | 443.43 | 583.4605263157895 | 0 | 583.4605263157895 | 271.89
3152 | Customer C | 500045 | Insulight(TM) | 8 | 3.35 | 91.43 | 27.29 | 25.09 | 33.01315789473684 | 0 | 33.01315789473684 | 9.045000000000002
3152 | Customer C | 500144 | Insulight(TM) Protect | 42 | 13.64 | 371.06 | 27.2 | 65.14 | 85.71052631578948 | 0 | 85.71052631578948 | 36.828
3152 | Customer C | 500145 | Insulight(TM) Protect | 11 | 4.08 | 145.15 | 35.58 | 28.89 | 38.01315789473684 | 0 | 38.01315789473684 | 11.016
3152 | Customer C | 500264 | Insulight(TM) Protect1 | 5 | 2.53 | 96.14 | 38 | 2.77 | 3.644736842105263 | 0 | 3.644736842105263 | 6.831
3152 | Customer C | 500280 | Insulight(TM) Protect | 5 | 3.01 | 105.45 | 35.03 | 9.78 | 12.86842105263158 | 0 | 12.86842105263158 | 8.127
3152 | Customer C | 512167 | energiKare(TM) | 3 | 14.28 | 888.93 | 62.25 | 0 | 0 | 546.54 | 546.54 | 38.556
3152 | Customer C | 530169 | Insulight(TM) Therm | 6 | 31.51 | 2262.4 | 71.8 | 0 | 0 | 5871.86 | 5871.86 | 85.07700000000001
3152 | Customer C | 99999999 | Energy Surcharge | 0 | 0 | 1064.51 | 0 | 0 | 0 | 0 | 0 | 0