tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 219502d1362770622-lookup-not-working-correctly-example-wsykes-oeldere-
Sheet: Talkgroup Personalities

CHANNEL | PERSONALITY 24 | NES B
1 | 3
2 | 5
3 | 7
4 | 9
5 | B
6 | D
7 | F
8 | 11
9 | 13
10 | 15
11 | 17
12 | 19
13 | 1B
14 | 1D
15 | 1F
16 | 21
Spreadsheet: 105697d1302971435-creating-a-lookup-based-on-multiple-requirements-query
Sheet: Sheet1

 |  | Number | Date | STEP 1 | STEP 2 |  |  |  | Final DATA
A-1 | 1 | A | 2009-10-26 00:00:00 |  | 1 | 1 |  |  | Number | Date
A-2 | 2 |  | 2009-12-10 00:00:00 |  | 1 | 2 |  | 2010-04-06 00:00:00 | A | 2010-04-06 00:00:00
A-3 | 3 |  | 2010-02-03 00:00:00 |  | 1 | 3 |  | 2010-04-06 00:00:00 | B | 2010-04-06 00:00:00
A-4 | 4 |  | 2010-04-06 00:00:00 |  | 1 | 4 |  | 2010-09-11 00:00:00 | C | 2010-09-11 00:00:00
A-5 | 5 |  | 2010-06-18 00:00:00 | 1 |  | 4 |  | 2010-10-28 00:00:00 | D | 2010-10-28 00:00:00
A-6 | 6 |  | 2011-01-31 00:00:00 | 1 |  | 4 |  | 2009-09-24 00:00:00 | E | 2009-09-24 00:00:00
B-1 | 1 | B | 2009-10-26 00:00:00 |  | 1 | 1 |  | 2010-02-04 00:00:00 | F | 2010-02-04 00:00:00
B-2 | 2 |  | 2009-12-10 00:00:00 |  | 1 | 2 |  | 2010-09-03 00:00:00 | G | 2010-09-03 00:00:00
B-3 | 3 |  | 2010-02-16 00:00:00 |  | 1 | 3 |  | 2009-06-19 00:00:00 | H | 2009-06-19 00:00:00
B-4 | 4 |  | 2010-04-06 00:00:00 |  | 1 | 4 |  | 2010-05-07 00:00:00 | I | 2010-05-07 00:00:00
B-5 | 5 |  | 2010-06-18 00:00:00 | 1 |  | 4 |  | 2010-07-09 00:00:00 | J | 2010-07-09 00:00:00
B-6 | 6 |  | 2011-01-31 00:00:00 | 1 |  | 4 |  | 2011-01-26 00:00:00 | K | 2011-01-26 00:00:00
C-1 | 1 | C | 2010-09-11 00:00:00 | 1 |  | 1 |  | 2011-01-26 00:00:00 | L | 2011-01-26 00:00:00
C-2 | 2 |  | 2010-09-28 00:00:00 | 1 |  | 1 |  | 2011-01-26 00:00:00 | M | 2011-01-26 00:00:00
D-1 | 1 | D | 2010-10-08 00:00:00 |  | 1 | 1
D-2 | 2 |  | 2010-10-28 00:00:00 |  | 1 | 2
D-3 | 3 |  | 2010-12-07 00:00:00 | 1 |  | 2
E-1 | 1 | E | 2009-09-24 00:00:00 | 1 |  | 1
E-2 | 2 |  | 2009-10-19 00:00:00 | 1 |  | 1
E-3 | 3 |  | 2010-10-28 00:00:00 | 1 |  | 1
F-1 | 1 | F | 2010-02-04 00:00:00 |  | 1 | 1
F-2 | 2 |  | 2010-03-12 00:00:00 | 1 |  | 1
G-1 | 1 | G | 2010-09-03 00:00:00 |  | 1 | 1
G-2 | 2 |  | 2010-09-28 00:00:00 | 1 |  | 1
H-1 | 1 | H | 2009-06-19 00:00:00 | 1 |  | 1
H-2 | 2 |  | 2009-12-07 00:00:00 | 1 |  | 1
I-1 | 1 | I | 2010-05-07 00:00:00 |  | 1 | 1
I-2 | 2 |  | 2010-05-26 00:00:00 | 1 |  | 1
J-1 | 1 | J | 2010-07-09 00:00:00 | 1 |  | 1
J-2 | 2 |  | 2010-08-09 00:00:00 | 1 |  | 1
K-1 | 1 | K | 2011-01-26 00:00:00 | 1 |  | 1
[NAME] | 2 |  | 2011-02-28 00:00:00 | 1 |  | 1
L-1 | 1 | L | 2011-01-26 00:00:00 | 1 |  | 1
L-2 | 2 |  | 2011-02-28 00:00:00 | 1 |  | 1
M-1 | 1 | M | 2011-01-26 00:00:00 | 1 |  | 1
Spreadsheet: ryan_slinger__33674__5_14act
Sheet: EPEData

 | 37122.2
 | NEWMAN 1 ,ECON, 40  , 68  , 39  , 83  , 28  ,1
 | NEWMAN 2 ,MANL, 47  , 77  , 37  , 82  ,  0  ,1
 | NEWMAN 3 ,ECON, 36  , 95  , 35  ,103  , 60  ,1
 | NEWMN/GT1,AVAL,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,AVAL,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,125  ,214  , 86  ,214  , 89  ,1
 | NEWMAN   ,, 248 ,  454,  197, 482 , 177 ,
 | COPPER   ,ECON, 15  , 69  , 15  , 69  , 53  ,1
 | RIOGRAN 6,MANL, 45  , 40  , 28  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 38  , 32  , 30  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  , 90  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,  83 ,   72,   58,  97 ,   0 ,
 | PALOVERDE,[NAME]  ,461  ,461  ,600  ,  0  ,1
 | FOURCRNRS,MANL,103  ,103  ,103  ,104  ,  0  ,1
 | LAMBDA, 34.13,  653,  649,  281,    2,    0,21554,105
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Heavy Equipment

HEAVY EQUIPMENT OPERATIONS
Diploma
Student Name:
ID #
Prerequisite | Semester | Grade
___ DIT 103 (2) Preventive Maintenance Lab
General Education and Support Courses
___ CIT 105 (3) Introduction to Computers OR IC3 Computer Literacy Exam
___ EFM  100 (3) Personal Financial Management
OR ___ BAS 120 Personnel Finance
___ WPP 200 (3) Workplace Prinicples
Program Requirements
___ HEO 100 (12) Heavy Equipment Operations I
OR ___ HEO 150 (7) Heavy Equipment IA
AND ___ HEO 250 (5) Heavy Equipment IIA
___ HEO 125 (3) Special Problems I
___ HEO 200 (7) Heavy Equipment Operations II
___ HEO 225 (3) Special Problems II
Recommended Elective
___ HEO 215 (1-4) Heavy Equipment Operations
Program Electives
___ HEO 115 (7) Hydraulic Excavator Operator
___ HEO 109 (2) Power Shovel/Backhoe Operator
___ HEO 106 (7) Motor-grader Operator
___ HEO 105 (4) Utility Tractor Loader Operator
___ HEO 111 (7) Bulldozer Operator
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 717603d1612769511-modified-countif-function-to-count-one-occurance-from-each-row-adjusted-countif-function
Sheet: Sheet1

[NAME] | Org 1 | Org 2 | Org 3 | Org 4 | Org 5
 | [Seadawy, [NAME], Dept Math, [NAME], [NAME], Saudi Arabia
 | [Ahmed, Muhammad Adeel; Jouhar, Rizwan] King Faisal Univ, Coll Dent, Dept Restorat Dent & Endodont, [NAME], Saudi Arabia | [Zafar, [NAME]] Taibah Univ, Coll Dent, Dept Restorat Dent, [NAME], Saudi Arabia | [[NAME], [NAME] King Faisal Univ, Coll Dent, Dept Prosthodont & Dent Implantol, [NAME], Saudi Arabia
 | [[NAME], Imran] Taibah Univ, [NAME], Dept Chem, Al Medina Al Munawara 41477, Saudi Arabia | [Alharbi, [NAME], [NAME], Dept Biol, [NAME], Saudi Arabia
 | [Ewees, [NAME], Dept ESyst, [NAME], Saudi Arabia
 | [[NAME], [NAME]; Jleli, [NAME]; Samet, Bessem] King Saud Univ, [NAME], Dept Math, Riyadh, Saudi Arabia
 | [Alyami, Hussain] Taif Univ, [NAME], At Taif, Saudi Arabia
 | [[NAME], Ming-Hui; [NAME], Lain-Jong] King Abdullah Univ Sci & Technol, Phys Sci & Engn Div, Thuwal, Saudi Arabia
 | [Bousahla, Abdelmoumen Anis; [NAME], Fouad; Tounsi, Abdeldjebbar; Bedia, [NAME]; Benrahou, [NAME]; Tounsi, Abdelouahed] King Fahd Univ Petr & Minerals, Dept Civil & Environm Engn, Dhahran 31261, Eastern Provinc, Saudi Arabia | [[NAME], [NAME], Jeddah Community Coll, GRC Dept, Jeddah, Saudi Arabia
 | [Alhabib, [NAME], [NAME], King Fahad Cardiac Ctr, Dept Cardiac Sci, Riyadh, Saudi Arabia | [Al-Muhsen, [NAME]] King Saud Univ, King Saud Univ Med City, Riyadh, Saudi Arabia
 | [Dang, Shuping; [NAME], [NAME]; Shihada, Basem; [NAME], [NAME]] KAUST, Comp Elect & Math Sci & Engn Div, Thuwal, Saudi Arabia
 | [[NAME], [NAME]] King Saud Univ, Sustainable Energy Technol SET Ctr, Coll Engn, POB 800, Riyadh 11421, Saudi Arabia
 | [[NAME], [NAME] King Abdulaziz Univ, Chem Dept, [NAME], POB 80203, Jeddah 21589, Saudi Arabia | [[NAME], [NAME] King Abdulaziz Univ, Ctr Excellence Adv [NAME], POB 80203, Jeddah 21589, Saudi Arabia
 | [[NAME], [NAME] King Abdulaziz Univ, [NAME], Chem Dept, POB 80203, Jeddah 21589, Saudi Arabia | [[NAME], [NAME] King Abdulaziz Univ, Ctr Excellence Adv [NAME], POB 80203, Jeddah 21589, Saudi Arabia
 | [[NAME], [NAME]; Alsohime, Fahad; Hasanato, Rana] King Saud Univ, [NAME], Dept Pathol & Lab Med, Riyadh, Saudi Arabia | [[NAME], Haya; Almourfi, [NAME], Natl Ctr Genom Technol, Riyadh, Saudi Arabia | [Al-Muhsen, [NAME]] King Saud Univ, [NAME], Dept Pediat, Immunol Res Lab, Riyadh, Saudi Arabia | [Al Turki, Saeed] Misery Natl Guard Hlth Affairs, King Abdulaziz Med City, Dept Pathol & Lab Med, [NAME], Riyadh, Saudi Arabia | [Al Turki, Saeed] King Abdullah Int Med Res Ctr, Canc & Blood Res, Riyadh, Saudi Arabia
 | [[NAME], Xiaopeng; [NAME], [NAME]; [NAME], [NAME]; [NAME], [NAME]; Troughton, Joel; Gasparini, Nicola; [NAME], Yuanbao; Alsalloum, [NAME]; Maity, [NAME]; Turedi, [NAME]; [NAME], [NAME]; [NAME], Derya; [NAME], [NAME]; Han, [NAME]; [NAME], [NAME]; [NAME], [NAME], [NAME], Thuwal, Saudi Arabia | [Hedhili, [NAME]] KAUST, Imaging & Characterizat Core Lab, Thuwal, Saudi Arabia
Spreadsheet: 8b156947-b404-4c87-be13-6289053c79b0
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
10/10/2009 | Rifle | vs. Air Force (Lincoln, Neb.) | W, 4655-4587
10/11/2009 | Rifle | at Nebraska | W, 4666-4634
10/17/2009 | Rifle | at Ohio State | W, 4666-4538
10/18/2009 | Rifle | at Akron | W, 4665-4560
11/14/2009 | Rifle | ARMY | W, 4638-4562
11/21/2009 | Rifle | KENTUCKY | W, 4691-4642
01/17/2010 | Rifle | NC STATE | W, 4678-4561
01/21/2010 | Rifle | ALASKA-FAIRBANKS | W, 4697-4670
01/30/2010 | Rifle | vs. [NAME] (Cookeville, Tenn.) | W, 4696-4576
01/31/2010 | Rifle | [NAME] | Results
02/13/2010 | Rifle | NEBRASKA ([NAME]) | W, 4659-4612
02/20/2010 | Rifle | GARC Championship (Oxford, Miss.) | First Place, 2317
02/21/2010 | Rifle | GARC Championship (Oxford, Miss.) | First Place, 4653
03/12/2010 | Rifle | NCAA Championship (Fort Worth, Texas) | Third Place, 2308
03/13/2010 | Rifle | [NAME] (Fort Worth, Texas) | Third Place, 4641
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -9355 | -6760
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
2001-09-30 00:00:00 |  |  | -21514
2001-10-02 00:00:00
CBS Dollars
 |  |  | -132953
Spreadsheet: 108050d1305149862-auto-populating-excel-calendar-ts1019273743
Sheet: MAR

 | March 2011
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5
 | 6 |  | 7 |  | 8 |  | 9 | Ash Wednesday | 10 |  | 11 |  | 12
 | 13 | Daylight Savings Begins | 14 |  | 15 |  | 16 |  | 17 | St. Patrick's Day | 18 |  | 19
 | 20 | First Day of Spring | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26
 | 27 |  | 28 |  | 29 |  | 30 |  | 31
Spreadsheet: 167cde62-a076-4531-885f-62b8f4bc7e63
Sheet: Sheet1

Jaekaubandusettevõtete jaemüügi mahuindeks [NAME] trend, jaanuar 2002 - märts 2012 (2005=100) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Retail trade enterprises retail sales volume index and its trend, January 2002 - March 2012 (2005=100)
 | Kuu | [NAME] mahuindeks, % | Trend, %
 | Month | Retail sales volume index, % | Trend, %
2002 | I | 61 | 69
 | II | 60 | 69
 | III | 66 | 70
 | IV | 68 | 70
 | V | 74 | 71
 | VI | 74 | 71
 | VII | 76 | 72
 | VIII | 76 | 72
 | IX | 73 | 73
 | X | 73 | 73
 | XI | 71 | 73
 | XII | 84 | 74
2003 | I | 66 | 74
 | II | 65 | 75
 | III | 72 | 75
 | IV | 73 | 76
 | V | 79 | 76
 | VI | 81 | 78
 | VII | 84 | 79
 | VIII | 83 | 79
 | IX | 78 | 80
 | X | 84 | 81
 | XI | 78 | 82
 | XII | 95 | 83
2004 | I | 76 | 84
 | II | 73 | 85
 | III | 82 | 86
 | IV | 90 | 87
 | V | 91 | 87
 | VI | 91 | 88
 | VII | 96 | 90
 | VIII | 95 | 91
 | IX | 91 | 92
 | X | 95 | 94
 | XI | 92 | 94
 | XII | 111 | 94
2005 | I | 82 | 94
 | II | 80 | 95
 | III | 92 | 96
 | IV | 95 | 97
 | V | 100 | 97
 | VI | 103 | 98
 | VII | 107 | 100
 | VIII | 106 | 101
 | IX | 100 | 102
 | X | 106 | 104
 | XI | 102 | 106
 | XII | 126 | 108
2006 | I | 98 | 110
 | II | 94 | 111
 | III | 109 | 113
 | IV | 111 | 114
 | V | 120 | 116
 | VI | 124 | 117
 | VII | 127 | 119
 | VIII | 126 | 121
 | IX | 121 | 123
 | X | 127 | 125
 | XI | 124 | 128
 | XII | 148 | 130
2007 | I | 119 | 133
 | II | 115 | 135
 | III | 133 | 136
 | IV | 130 | 136
 | V | 139 | 136
 | VI | 146 | 136
 | VII | 143 | 136
 | VIII | 143 | 136
 | IX | 135 | 137
 | X | 140 | 137
 | XI | 133 | 137
 | XII | 156 | 136
2008 | I | 120 | 136
 | II | 122 | 135
 | III | 129 | 135
 | IV | 131 | 134
 | V | 138 | 133
 | VI | 136 | 131
 | VII | 141 | 130
 | VIII | 136 | 129
 | IX | 125 | 128
 | X | 130 | 126
 | XI | 119 | 124
 | XII | 140 | 122
2009 | I | 107 | 120
 | II | 99 | 118
 | III | 111 | 116
 | IV | 113 | 115
 | V | 116 | 114
 | VI | 121 | 112
 | VII | 118 | 110
 | VIII | 114 | 108
 | IX | 103 | 106
 | X | 108 | 105
 | XI | 99 | 104
 | XII | 119 | 104
2010 | I | 94 | 104
 | II | 89 | 104
 | III | 100 | 105
 | IV | 103 | 105
 | V | 110 | 106
 | VI | 113 | 107
 | VII | 117 | 108
 | VIII | 113 | 108
 | IX | 105 | 108
 | X | 109 | 108
 | XI | 105 | 108
 | XII | 125 | 107
2011 | I | 92 | 107
 | II | 91 | 107
 | III | 105 | 108
 | IV | 107 | 109
 | V | 113 | 110
 | VI | 118 | 112
 | VII | 122 | 113
 | VIII | 120 | 113
 | IX | 110 | 113
 | X | 115 | 114
 | XI | 109 | 115
 | XII | 133 | 116
2012 | I | 107 | 118
 | II | 102 | 119
 | III | 112 | 119
Spreadsheet: 54020d1253984232-transfer-data-for-specific-dates-master-1-
Sheet: Stat Calculator

 | 1 | PNC Weekly Target | 2100
 |  | Conflicts Weekly Target | 500
 |  | Id's Weekly Target | 500
 | 2 | PNC Completed | 23
 |  | [NAME]
 |  | Id's Completed
 | 3 | PNC Revised Target | 2077
 |  | Conflicts Revised Target | 500
 |  | Id's Revised Target | 500
Weekly Stats
How to use
Simply enter weekly targets into appropriate boxes in section 1 e.g. pnc weekly target of 2100, then enter 2100 into column next to pnc weekly target, cell D1. For conflicts weekly targets enter into cell D2
At beginning of week enter targets into section 3 as well.
Then each morning enter production agents daily stats into appropriate boxes in section 2 e.g. pnc 120, then enter 120 into cell next to PNC completed, cell D5, and so on for conflicts and ID's. Then overtype next production agents daily stats into appropriate boxes in section 2. Every time stats are entered into section 2 it deducts them from section 3 leaving a revised target. Then at start of next week delete all figures and re-enter new targets.
Spreadsheet: daren_farmer__5045__HPLN0421
Sheet: Sheet1

HPLN0421.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - April 21-23, 2001
 |  |  |  |  |  | **Sat/Sun | **Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 4/21-22/2001 | 2001-04-23 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 771324d1646630799-monthly-revenue-calculation-hang-up-excel-test-copy
Sheet: Monthly Breakdown

 | MONTHLY REVENUE
 | 2022
 | Month | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | Totals | Month
 | Gross |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross
 | GST |  |  |  |  |  |  |  |  |  |  |  |  |  | GST
 | PST |  |  |  |  |  |  |  |  |  |  |  |  |  | PST
 | Sum Tax |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum Tax
 | Late Fees |  |  |  |  |  |  |  |  |  |  |  |  |  | Late Fees
 | Net |  |  |  |  |  |  |  |  |  |  |  |  |  | Net
 | 2021
 | Month | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | Totals | Month
 | Gross |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross
 | GST |  |  |  |  |  |  |  |  |  |  |  |  |  | GST
 | PST |  |  |  |  |  |  |  |  |  |  |  |  |  | PST
 | Sum Tax |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum Tax
 | Late Fees |  |  |  |  |  |  |  |  |  |  |  |  |  | Late Fees
 | Net |  |  |  |  |  |  |  |  |  |  |  |  |  | Net
 | 2020
 | Month | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | Totals | Month
 | Gross |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross
 | GST |  |  |  |  |  |  |  |  |  |  |  |  |  | GST
 | PST |  |  |  |  |  |  |  |  |  |  |  |  |  | PST
 | Sum Tax |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum Tax
 | Late Fees |  |  |  |  |  |  |  |  |  |  |  |  |  | Late Fees
 | Net |  |  |  |  |  |  |  |  |  |  |  |  |  | Net
 | 2019
 | Month | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | Totals | Month
 | Gross |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross
 | GST |  |  |  |  |  |  |  |  |  |  |  |  |  | GST
 | PST |  |  |  |  |  |  |  |  |  |  |  |  |  | PST
 | Sum Tax |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum Tax
 | Late Fees |  |  |  |  |  |  |  |  |  |  |  |  |  | Late Fees
 | Net |  |  |  |  |  |  |  |  |  |  |  |  |  | Net
Spreadsheet: 525577d1498781091-skipping-blank-cells-when-copying-values-to-another-tab-answer1
Sheet: Sheet1

23 |  | 14 |  | 1612 |  | 23
34 |  | 14 |  | 2 |  | 78
54 |  | 24 |  | 16 |  | 78
36 |  | 24 |  | 25 |  | 78
34 |  | 52 |  | 25 |  | 85
36 |  | 25 |  | 15 |  | 565
124 |  | 15 |  | 15 |  | 68
2424 |  | 61 |  | 16 |  | 95
124 |  | 16 |  | 16 |  | 56
Spreadsheet: 700378d1603176044-autofill-year-for-data-transformation-autofill-year-for-data-transform
Sheet: Sheet2

Name | Effective Contract
[NAME] | 2005
[NAME] | 2006
[NAME] | 2007
[NAME] | 2008
[NAME] | 2009
[NAME] | 2010
[NAME] | 2011
[NAME] | 2012
[NAME] | 2013
[NAME] | 2014
[NAME] | 2015
[NAME] | 2016
[NAME] | 2017
[NAME] | 2018
[NAME] | 2019
[NAME] | 2020
[NAME] | 2006
[NAME] | 2007
[NAME] | 2008
[NAME] | 2009
[NAME] | 2010
[NAME] | 2011
[NAME] | 2012
[NAME] | 2013
[NAME] | 2014
[NAME] | 2015
[NAME] | 2016
[NAME] | 2017
[NAME] | 2018
Spreadsheet: 788247d1658341319-trying-to-use-vlookup-to-pull-data-from-one-workbook-to-another-excelforumhelp
Sheet: Sheet1

Date | InV | Entity | Draw #
2001-01-03 00:00:00 |  | Apple
2001-01-04 00:00:00 |  | Grape
2001-01-05 00:00:00 |  | Orange
2001-01-06 00:00:00 |  | Bev
2001-01-07 00:00:00 |  | Team
2001-01-08 00:00:00 |  | Sack
2001-01-09 00:00:00 |  | Tuna
2001-01-10 00:00:00 |  | Fish
2001-01-11 00:00:00 |  | Excel
Spreadsheet: john_griffith__15970__11_16_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO Z1 | 52 | 380 | 480 | 52.8 | 66.7 | 1.95 | 2001-11-16 14:52:00
 | HO F2 | 53 | 775 | 840 | 55.6 | 60.3 | 1.93 | 2001-11-16 14:52:00
 | HO G2 | 54 | 1080 | 1125 | 56.6 | 59 | 1.96 | 2001-11-16 14:52:00
 | [NAME] | 54 | 1200 | 1275 | 53.7 | 57.1 | 1.88 | 2001-11-16 14:52:00
 | HO J2 | 53 | 1280 | 1310 | 51.8 | 53.1 | 1.75 | 2001-11-16 14:52:00
 | HO K2 | 53 | 1250 | 1400 | 45.6 | 51.1 | 1.61 | 2001-11-16 14:52:00
 | HO M2 | 53 | 1300 | 1370 | 43.4 | 45.8 | 1.49 | 2001-11-16 14:52:00
 | HO N2 | 53 | 1350 | 1450 | 42.3 | 45.4 | 1.46 | 2001-11-16 14:52:00
 | HO Q2 | 55 | 1300 | 1500 | 36.8 | 42.5 | 1.37 | 2001-11-16 14:52:00
 | HO U2 | 56 | 1400 | 1550 | 36.9 | 40.9 | 1.37 | 2001-11-16 14:52:00
 | [NAME] |  |  |  | 38.4 | 42.2 | 1.42 | 2001-11-15 14:53:00
 | HO X2 |  |  |  | 37.9 | 40.3 | 1.38 | 2001-11-15 14:53:00
 | [NAME] |  |  |  | 33.3 | 36.6 | 1.32 | 2001-11-07 14:56:00
 | HO F3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO H3
Spreadsheet: 114340d1310090974-nested-ifs-or-array-logic_example
Sheet: 2006

YEAR 2006 CODES/RATES
List 1 | P | T | Global |  | List 2 | P | T | Global
100 | 4.17 | 12.44 |  |  | 200 | 12.22 | 335.5
101 | 3.26 | 45.02 |  |  | 201 | 23.33 | 325.5
102 | 44.3 | 5.21 |  |  | 202 | 225 | 439.5
103 | 6.55 | 4.22 |  |  | 203 | 245 | 544.2
104 | 9.01 | 660.25 |  |  | 204 | 8 | 3.22
105 | 9.55 | 324.55 |  |  | 205 | 23.2 | 65.5
106 | 2.94 | 35.69 |  |  | 206 | 65 | 45.21
107 | 32.22 | 8.88 |  |  | 207 | 65.66 | 115.2
108 | 45 | 7.21 |  |  | 208 | 5.46 | 465.55
109 | 544 | 10.21 |  |  | 209 | 80.5 | 5.1
110 | 65.99 | 101.23 |  |  | 210 | 65.66 | 5
111 | 91.22 | 127.3 |  |  | 211 | 9.21 | 25.2
Spreadsheet: 814289d1674254738-formula-to-calculate-up-to-a-number-then-back-to-zero-game-stats-3
Sheet: Drives

Drive | Play Type | Yards | Downs | Result | Add'l | Yards | Side | Yard
DAL1 | Kickoff |  | 1st and 10 | Incomplete |  |  |  | 25
DAL1 | Pass | 0 | 2nd and 10 | Incomplete |  |  | D
DAL1 | Pass | 0 | 3rd and 10 | Incomplete |  |  | D
DAL1 | Pass | 0 | 4th and 10 | Incomplete |  |  | D
DAL1 | Punt | 50 | 1st and 10 | T26 | RET | 10 | R
[NAME] | Rush | -2 | 2nd and 13 | T35
[NAME] | Pass | 0 | 3rd and 13 | T35
[NAME] | Pass | 0 | 4th and 13 | T35 |  |  | L
[NAME] | Punt | 45 |  | D22 | RET | 7 | L
DAL2 | Rush | -2 | 1st and 10 | D29
DAL2 | Rush | 5 | 2nd and 12
DAL2 | Sack | -8 | 3rd and 7
DAL2 | Punt | 45 | 4th and 15 |  |  | 10
Drive | Down | Play | Yards | Result | Extra | Add'l Yards | Direction | [NAME]
TB0 | Kickoff |  | - | Touchback |  |  | R | 25
DAL1 | 1st and 10 | Pass | 0 | Incomplete |  |  | R
 | 2nd and 10 | Pass | 0 | Incomplete |  |  | R
 | 3rd and 10 | Pass | 0 |  |  |  | R
 | 4th and 10 | Punt | 50 |  |  | 10 | L |  |  | 35 |  |  |  |  |  | IF(IF(C22="Punt",
[NAME] | 1st and 10 | Rush | -2 |  |  |  | L |  |  |  |  |  |  |  |  | IF(H22="L",OFFSET(INDEX(Sheet2!$A$1:$CW$1,MATCH(1,(Sheet1!H22=Sheet2!$A$2:$CW$2)*(Sheet1!I21=Sheet2!$A$1:$CW$1),0)),0,D22-G22),
 | 2nd and 12 | Pass | 0 |  |  |  | L |  |  |  |  |  |  |  |  | OFFSET(INDEX(Sheet2!$A$1:$CW$1,MATCH(1,(Sheet1!H22=Sheet2!$A$2:$CW$2)*(Sheet1!I21=Sheet2!$A$1:$CW$1),0)),0,-(D22-G22))),IF(I21+D22>50,50-(I21+D22),I21+D22)+G22)=0,20,IF(C22="Punt",
[NAME] | 3rd and 12 | Pass | 0 |  |  |  | L |  |  |  |  |  |  |  |  | IF(H22="L",OFFSET(INDEX(Sheet2!$A$1:$CW$1,MATCH(1,(Sheet1!H22=Sheet2!$A$2:$CW$2)*(Sheet1!I21=Sheet2!$A$1:$CW$1),0)),0,D22-G22),
[NAME] | 4th and 12 | Punt | 45 |  |  | 7 | L |  |  |  |  |  |  |  |  | OFFSET(INDEX(Sheet2!$A$1:$CW$1,MATCH(1,(Sheet1!H22=Sheet2!$A$2:$CW$2)*(Sheet1!I21=[NAME]))
DAL2 | 1st and 10 | Rush | -2 |  |  |  | R
 | 2nd and 12 | Rush | 5 |  |  |  | R
 | 3rd and 7 | Sack | -8 |  |  |  | R
 | 4th and 15 | Punt | 45 |  |  | 10 | R |  |  |  |  |  |  |  |  |  | PUNT GOES OPPOSITE WAY
[NAME] | 1st and 10 | Pass | 2 | Complete |  |  | L |  |  |  |  |  |  |  |  |  | EXTRA YARDS GOES OPPOSITE AGAIN
 | 2nd and 8 | Rush | 3 |  |  |  | L
 | 3rd and 5 | Pass | 0 |  |  |  | L
 | 4th and 5 | Punt | 54 |  |  |  | L
DAL3 | 1st and 10 | Rush | 5 |  |  |  | L
 | 2nd and 5 | Pass | 15 | Complete |  |  | L
 | 1st and 10 | Rush | 2 |  |  |  | L
 | 2nd and 8 | Rush | 3 |  | 15 | 0 | L |  |  | 40
 | 1st and 10 | Rush | 18 |  |  |  |  |  |  | 22
 | 1st and 10 | Rush | 0 |  |  |  |  |  |  | 22
 | 2nd and 10 | Pass | 22 |  |  |  |  |  |  | 0 | TD