tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 788255d1658351755-trying-to-use-vlookup-to-pull-data-from-one-workbook-to-another-excelforumhelp-2-
Sheet: Sheet1

Inv Date | Invoice | Vendor | Amount | Ref # | Description | Draw
OIDATE | OIINV | VNAME | ODAMT | ODJCPHS | ODDESC | ODJCDRW
2017-11-09 00:00:00 | 7611-110917 | 100 Eleventh Avenue Condo |  | 10-04-5000 | FILMING - 11/8 - 11/9/17 | 36
2017-04-30 00:00:00 | [NAME] | 76 Eleventh Funding, LLC |  | 40-01-5100 | Deficit fee - April 2017
2017-04-30 00:00:00 | [NAME] | 76 Eleventh Funding, LLC |  | 40-01-5100 | Deficit fee - April 2017
2017-05-31 00:00:00 | 7611-053117 | 76 Eleventh Funding, LLC |  | 40-01-5100 | [NAME] 2017
2017-05-31 00:00:00 | 7611-053117 | 76 Eleventh Funding, LLC |  | 40-01-5100 | [NAME] 2017
2019-10-31 00:00:00 | 7611-103119 | 76 Eleventh Funding, LLC |  | 40-01-5100 | OCT 2019 - INTEREST | 100
2019-06-30 00:00:00 | 7611-063019 | 76 Eleventh Funding, LLC |  | 40-01-5100 | JUNE 2019 - INTEREST | 100
2019-05-31 00:00:00 | 7611-053119 | 76 Eleventh Funding, LLC |  | 40-01-5100 | MAY 2019 - INTEREST | 100
2019-12-31 00:00:00 | 7611-123119 | 76 Eleventh Funding, LLC |  | 40-01-5100 | DEC 2019 - INTEREST | 100
2019-09-30 00:00:00 | 7611-093019 | 76 Eleventh Funding, LLC |  | 40-01-5100 | SEPT 2019 - INTEREST | 100
2019-11-30 00:00:00 | 7611-113019 | 76 Eleventh Funding, LLC |  | 40-01-5100 | NOV 2019 - INTEREST | 100
2019-07-31 00:00:00 | 7611-073119 | 76 Eleventh Funding, LLC |  | 40-01-5100 | JULY 2019 - INTEREST | 100
2019-08-31 00:00:00 | 7611-083119 | 76 Eleventh Funding, LLC |  | 40-01-5100 | AUGUST 2019 - INTEREST | 100
2017-03-03 00:00:00 | 2 | 76 Eleventh Funding, LLC |  | 40-01-2000 | EB-5 Funding - Closing Costs | 21
Spreadsheet: 0739d714-64e6-4824-848f-8cfdf1b0c2c1
Sheet: Sheet1

TABLE 1 | 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
APPLICATIONS PROCESSED
UNIVERSITY OF HAWAI‘I - WEST O‘AHU
FALL 2003 TO FALL 2007
 |  |  | FALL SEMESTER
 | STUDENT LEVEL |  | 2003 |  |  | 2004 |  |  | 2005 |  |  | 2006 |  |  | 2007
 |  |  | No. | V% |  | No. | V% |  | No. | V% |  | No. | V% |  | No. | V%
 | TOTAL ………………………………………………………………………………………………………………………………… |  | 485 | 100 |  | 466 | 100 |  | 436 | 100 |  | 493 | 100 |  | 627 | 100
 | Accepted ………………………………………………………………………………………….. |  | 398 | 82.06185567010309 |  | 396 | 84.97854077253218 |  | 388 | 88.9908256880734 |  | 437 | 88.64097363083164 |  | 555 | 88.51674641148325
 | Enrolled; % of Accepted ……………………………………………………………………………………………………..………. |  | 284 | 71.35678391959799 |  | 284 | 71.71717171717171 |  | 303 | 78.09278350515464 |  | 359 | 82.15102974828376 |  | 402 | 72.43243243243244
 | Not Enrolled; % of Accepted ………………………………………………………………………………………………… |  | 114 | 28.64321608040201 |  | 112 | 28.28282828282828 |  | 85 | 21.90721649484536 |  | 78 | 17.84897025171625 |  | 153 | 27.56756756756757
 | Denied / Redirected …………………………………………………………………………………….. |  | 49 | 10.10309278350515 |  | 56 | 12.01716738197425 |  | 24 | 5.504587155963304 |  | 42 | 8.519269776876268 |  | 15 | 2.392344497607656
 | Incomplete / Pending / No Action ………………………………………………………………………… |  | 16 | 3.298969072164949 |  | 0 | 0 |  | 7 | 1.605504587155963 |  | 6 | 1.217038539553752 |  | 28 | 4.465709728867624
 | Cancelled …………………………………………………………………………………………………………… |  | 22 | 4.536082474226804 |  | 14 | 3.004291845493562 |  | 17 | 3.89908256880734 |  | 8 | 1.622718052738337 |  | 29 | 4.625199362041467
 | Note:  V% shows pecent of total applications, unless otherwise indicated.
 | Sources:  Fall 2003 data from UH West O‘ahu Student Services Office; Fall 2004 data are from Banner;                  Effective Fall 2005, data are from Banner Operational Data Store (ODS) IRO_ADMISSIONS.
Spreadsheet: 874791d1721300711-creating-a-dependant-drop-down-list-narbar_123-test-2-1-aligw
Sheet: LookupLists

4 | HC35/32
12
13
A1
A2
A3
A4
A5
CH1
CH10
CH11
CH12
CH13
CH14
CH15
CH16
CH17
[NAME]
CH19
CH2
CH20
CH21
CH22
CH23
CH24
CH25
CH26
CH27
CH28
CH3
CH4
CH5
CH6
CH7
CH8
CH9
CO81
CO82
CO85
CO86
CO87
CO88
CO89
CO90
CO91
CO92
CO93
CO94
CO95
CO96
CO97
CO98
G01
G02
G03
G04
G05
[NAME]
G07
G08
[NAME]
G10
G100
G104
G105
G106
G107
G108
G109
G11
G12
G13
G14
[NAME]
[NAME]
G19
G19A
G20A
G21
G21A
G22
G23
G25
G26
G27
G28
G29
G30
G31
G32
G33
G34
G35
G36
G37
G38
G39
G40
G41
G42
[NAME]
G44
G45
G46
G47
G48
G49
G50
G51
G52
G53
G54
G55
G56
G57
G58
G59
G60
G61
G62
[NAME]
G64
G65
G66
G67
G68
G69
[NAME]
G71
G72
G73
G74
G75
G76
G76A
G77
G77A
[NAME]
G79
G82
G83
G84
G85
G86
G89
G93
G94
G95
G96
G97
G98
G99
K1
K1
K10
K1A
K2
K2
K2A
K3
K4
K5
K6
K7
K8
K9
LX1
LX2
LX3
LX4
LX5
LX6
N01
N02
N03
N04
N06
N07
N08
N09
N10
N100
N101
N102
N103
N104
N105
N106
N107
N108
N109
N11
N110
N111
N112
N113
N114
N115
N116A
N117A
N118A
N119A
N12
N13
[NAME]
N15
N16
N17
N18
N19
N1A
N20
N21
N24
N25
N26
N27
N28A
N29A
N2A
N30
N31
N32
N33
N34
N35
N36
N37
N37A
N38
N39
N40
N41
N42
N43
N44
N45
N46
N47
N48
N49
N50
N51
N52
N53
N54
N55
N56
[NAME]
N58
N59
N60
N61
N62
N63
N64
N65
N66
[NAME]
N68
N69
N70
N71
N72
N73
N74
N75
N76
N77
N78
N79
N80
N81
N82
N83
N84
N85
N86
N87
N88
N89
N90
N93
N94
N94A
N95
[NAME]
N99
N99A
NB01
NB02
NB03
NB04
NB05
NB06
R1A
R2A
R47
R48
R49
R50
R51
R52
R53
R54
R55
R59
R60
R61
R62
R63
[NAME]
R65
R66
R67
R68
R69
R70
R71
R72
R73
R77
R78
[NAME]
R80
R81
S1
S10
S11
S12
S13
S14
S15
S16
S17
S18
S18A
S19
S2
S20
S22
S23
S23A
S23B
S24
S24A
S28
S29
S29A
S3
S32
S33
S34
S36
S37
S38
S39
[NAME]
S40
S41
S42
S43
S44
S45
S46
S47
S48
S49
S5
S50
S51
S52
S53
S54
S55
S56
S57
S58
S59
S6
S60
S61
S62
S63
S64
S65
S66
S67
S68
S69
S7
S70
S71
S78
S8
S81
S81A
S82
S82A
S83
S84
S85
S86
S87
S88
S9
SD1
SL01
SL02
T1
T10
T100
T101
T102
T103
T104
T105
T106
T107
T108
T109
T11
T110
T111
T113
T114
T12
T14
T15
T16
T17
T18
T19
T2
T20
T21
T3
T38
T39
T4
T40
T40A
T40B
T41
T41A
T41B
T42
T42A
T43
T43A
T44
T44A
T45
T45A
T46
T46A
T47
T47A
T48
T48A
T49
T49A
T5
T5
T50
T50A
[NAME]
T51B
T52
T53
T59
T6
T61
[NAME]
T64
T65
T7
T73
T74
T8
T89
T9
T90
T92
T93
T94
T95
T96
T97
T98
T99
TL10
TL11
TL12
TL12A
TL13
[NAME]
TL15
TL16
TL17
TL18
TL19
TL20
TL21
TL22
TL23
TL25
TL27
TL28
TL30
TL32
TL34
TL36
[NAME]
TL38
TL39
TL3A
TL40
TL41
TL42
TL43
TL4A
TL7
TL7A
TL8
TL8A
TL9
W01
W02
[NAME]
W04
[NAME]
W06
W07
W08
W09
W10
W11
W12
W14
W15
W16
W17
W18
W19
W20
W21
[NAME]
W23
W24
W25
W26
W28
W29
W30
W31
W32
W33
[NAME]
W35
W36
W37
W38
W39
W40
W41
W42
W43
W44
W45
W46
W47
[NAME]
W50
W51
W52
W53
Spreadsheet: 123779d1317847249-establishing-a-variable-range-based-on-data-size-tenantcharges
Sheet: Report

Date | Tenant ID | Charges |  |  | Tenant ID | Sum of Charges
2011-01-11 00:00:00 | 86 | 919 |  |  | 86 | 220576
2011-01-11 00:00:00 | 86 | 5559 |  |  | 2011-01-11 00:00:00 | 120049
2011-01-11 00:00:00 | 86 | 8387 |  |  | 2011-02-11 00:00:00 | 100527
2011-01-11 00:00:00 | 86 | 8956 |  |  | 8971 | 71708
2011-01-11 00:00:00 | 86 | 640 |  |  | 2011-01-11 00:00:00 | 16219
2011-01-11 00:00:00 | 86 | 1284 |  |  | 2011-02-11 00:00:00 | 55489
2011-01-11 00:00:00 | 86 | 1519 |  |  | Grand Total | 292284
2011-01-11 00:00:00 | 86 | 6588
2011-01-11 00:00:00 | 86 | 7144
2011-01-11 00:00:00 | 86 | 8046
2011-01-11 00:00:00 | 86 | 4426
2011-01-11 00:00:00 | 86 | 5458
2011-01-11 00:00:00 | 86 | 5798
2011-01-11 00:00:00 | 86 | 2642
2011-01-11 00:00:00 | 86 | 3764
2011-01-11 00:00:00 | 86 | 168
2011-01-11 00:00:00 | 86 | 3606
2011-01-11 00:00:00 | 86 | 9916
2011-01-11 00:00:00 | 86 | 391
2011-01-11 00:00:00 | 86 | 6069
2011-01-11 00:00:00 | 86 | 6628
2011-01-11 00:00:00 | 86 | 6077
2011-01-11 00:00:00 | 86 | 7346
2011-01-11 00:00:00 | 86 | 8718
2011-01-11 00:00:00 | 8971 | 1121
2011-01-11 00:00:00 | 8971 | 910
2011-01-11 00:00:00 | 8971 | 75
2011-01-11 00:00:00 | 8971 | 6237
2011-01-11 00:00:00 | 8971 | 5058
2011-01-11 00:00:00 | 8971 | 2818
2011-02-11 00:00:00 | 86 | 9356
2011-02-11 00:00:00 | 86 | 7721
2011-02-11 00:00:00 | 86 | 7120
2011-02-11 00:00:00 | 86 | 7099
2011-02-11 00:00:00 | 86 | 9273
2011-02-11 00:00:00 | 86 | 1992
2011-02-11 00:00:00 | 86 | 7125
2011-02-11 00:00:00 | 86 | 3984
2011-02-11 00:00:00 | 86 | 6802
2011-02-11 00:00:00 | 86 | 259
2011-02-11 00:00:00 | 86 | 6148
2011-02-11 00:00:00 | 86 | 2873
2011-02-11 00:00:00 | 86 | 4269
2011-02-11 00:00:00 | 86 | 6834
2011-02-11 00:00:00 | 86 | 9579
2011-02-11 00:00:00 | 86 | 1668
2011-02-11 00:00:00 | 86 | 4367
2011-02-11 00:00:00 | 86 | 1755
2011-02-11 00:00:00 | 86 | 2303
2011-02-11 00:00:00 | 8971 | 3844
2011-02-11 00:00:00 | 8971 | 5387
2011-02-11 00:00:00 | 8971 | 1105
2011-02-11 00:00:00 | 8971 | 6858
2011-02-11 00:00:00 | 8971 | 8846
2011-02-11 00:00:00 | 8971 | 7090
2011-02-11 00:00:00 | 8971 | 7211
2011-02-11 00:00:00 | 8971 | 3820
2011-02-11 00:00:00 | 8971 | 3439
2011-02-11 00:00:00 | 8971 | 737
2011-02-11 00:00:00 | 8971 | 7152
Spreadsheet: phillip_platter__31376__enronnovmeber01
Sheet: november 2

DATE:NOVEMBER 2nd, 2001
CRC SP-15 AND NP-15 POSITIONS
 |  |  |  | AVISTA
 | PURCHASE |  |  |  |  |  | SELL
SP-15 |  | NP-15 |  |  |  | SP-15 |  | NP-15
50 MW |  | 0 |  |  |  | 0 |  | 25 MW
 |  |  |  | DYNEGY
 | PURCHASE |  |  |  |  |  | SELL
SP-15 |  | NP-15 |  |  |  | SP-15 |  | NP-15
0 |  | 50 MW |  |  |  | 0 |  | 0
 |  |  |  | ENRON
 | PURCHASE |  |  |  |  |  | SELL
SP-15 |  | NP-15 |  |  |  | SP-15 |  | NP-15
10 MW |  | 0 |  |  |  | 75 MW |  | 0
 |  |  |  | SEMPRA
 | PURCHASE |  |  |  |  |  | SELL
SP-15 |  | NP-15 |  |  |  | SP-15 |  | NP-15
0 |  | 0 |  |  |  | 0 |  | 25 MW
 |  |  |  | STRATEGIC
 | PURCHASE |  |  |  |  |  | SELL
SP-15 |  | NP-15 |  |  |  | SP-15 |  | NP-15
0 |  | 0 |  |  |  | 10 MW |  | 0
 |  |  |  | BP Amaco
 | PURCHASE |  |  |  |  |  | SELL
SP-15 |  | NP-15 |  |  |  | SP-15 |  | NP-15
25 MW |  | 0 |  |  |  | 0 |  | 0
Spreadsheet: 687438d1595212532-formula-for-data-cleansing-pls-help-excel-forum-1-
Sheet: Sheet1

Current :
First Name | Last name | [NAME] | Apps | Phone | Reg_sub
Prya | Bata | Email 	[EMAIL] | Apps 	ITR Management | Phone 	[PHONE] | Reg_Subjectline 	Strengthening ITRisk Management
Prya | Bata | Email 	[EMAIL] | Apps 	ITR Management | Phone 	[PHONE] | Reg_Subjectline 	Strengthening ITRisk Management
First Name 	Dany | Last Name 	Stube | Apps 	ITR Management | Reg_Subjectline 	Strengthening ITRisk Management | Email 	[EMAIL] | Phone 	021919000
First Name 	Mani | Reg_Subjectline 	Strengthening ITRisk Management | [NAME] 	[EMAIL] | Phone 	[PHONE] | Apps 	ITR Management | Last Name 	Misa
Reg_Subjectline 	Strengthening ITRisk Management | Last Name 	Grace | First Name 	Talia | [NAME] 	[EMAIL] | Phone 	660152931 | Apps 	ITR Management
Apps 	ITR Management | First Name 	[NAME] | Phone 	+[PHONE] | Last Name 	Luro | [NAME] 	[EMAIL] | Reg_Subjectline 	Strengthening ITRisk Management
Expected
First Name | Last name | [NAME] | Apps | Phone | Reg_sub
Spreadsheet: 8ceebdc5-36b7-4492-b1c5-c8b12c2cd5cd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6733 | 50236 | Gaby | Aued | PAN | 0 | 00:28:21 | 00:01:18 | 00:37:04 | 00:01:27 | 00:13:20 | 1 | 01:21:32
Spreadsheet: 859746d1708007921-displaying-information-with-dropdowns-testbook-1-
Sheet: Data

Site | Red |  |  |  |  | Upon selection of B1 only, when B2 and B3 are empty it should show top 5 bylines of the site selected in B1, for all the years and quarters
Year | 2020 |  |  |  |  | If B1 and B2 are selected, and B3 is empty, then it should show top 5 bylines of the site and year selected only
Quarter |  |  |  |  |  | If B1, B2, B3 all are selected, then it should show top 5 bylines of the site, year and quarter selected
 |  |  |  |  |  | B1, B2, B3 have dropdowns
Top 5 Bylines
 | 400
Ibrahim | 350
Musa | 300
[NAME] | 100
[NAME] | 90
Spreadsheet: 734791d1622488782-how-to-apply-appropriate-discount-from-a-grid-when-its-based-on-several-factors-fruit-1-
Sheet: Sheet1

 |  |  |  |  |  |  | Discount table
Product | Ordering Location | Price per unit | Quantity | Price after Discount |  |  |  | Ordering Locations
Apple | 1 | 2 | 6 |  |  |  | Product | 1 | 2 | 3
Apple | 2 | 2 | 8 |  |  |  | Apple | 0.05 | 0.2 | 0.2
Apple | 3 | 2 | 9 |  |  |  | Pear | 0.2 | 0.05 | 0.2
Pear | 1 | 3 | 13 |  |  |  | Orange | 0.2 | 0.1 | 0.11
Pear | 2 | 3 | 14
Pear | 3 | 3 | 14
Orange | 1 | 1 | 7
Orange | 2 | 1 | 7
Orange | 3 | 1 | 7
Spreadsheet: 2926491d-dad7-46b8-b021-422b4ad15e48
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-04-07 09:35:06.120000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.75 | 102.668 | 102.543 | 102.418 | 102.043
4.625 | 102.282 | 102.157 | 102.032 | 101.657 |  | Note: | Refer To Price [NAME]
4.5 | 101.344 | 101.219 | 101.094 | 100.719 |  |  | For all Price Adjs
4.375 | 100.487 | 100.362 | 100.237 | 99.612
4.25 | 99.909 | 99.784 | 99.659 | 99.034
4.125 | 99.078 | 98.953 | 98.828 | 98.203
4 | 98.06 | 97.935 | 97.81 | 97.185
3.875 | 97.011 | 96.886 | 96.761 | 96.136
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.431 | 102.306 | 102.181 | 101.806
3.75 | 102.075 | 101.95 | 101.825 | 101.45
3.625 | 101.67 | 101.545 | 101.42 | 101.045
3.5 | 101.095 | 100.97 | 100.845 | 100.22
3.375 | 100.34 | 100.215 | 100.09 | 99.465
3.25 | 99.545 | 99.42 | 99.295 | 98.67 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-04-21 09:35:06.120000
30 DAY | 2014-05-06 09:35:06.120000
45 DAY | 2014-05-21 09:35:06.120000
60 DAY | 2014-06-05 09:35:06.120000
90 DAY | 2014-07-05 09:35:06.120000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: b1b0e504-ce4d-4521-adfd-7288bc463cec
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Completed: United States
 |  | Seasonally Adjusted Single-family Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: June 19, 2013 (4:19 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 74084d1274699106-how-many-differences-between-ranges-countdifferences
Sheet: Sheet1

0 | 2 | <Differences count
1 | a |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | a
2 | b |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | b
3 | c |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | v
4 | d |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | d
5 | e |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | e
6 | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | g
Spreadsheet: 48bb5ada-e187-4814-b338-6ceb4c46370d
Sheet: Sheet1

Insurance Commissioner (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 11/1/2014 8:49:56 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | [NAME] | TOTALS
Adams | 692 | 527 | 1219
Barnes | 2608 | 2846 | 5454
Benson | 735 | 1532 | 2267
Billings | 319 | 163 | 482
Bottineau | 1758 | 1610 | 3368
[NAME] | 927 | 657 | 1584
Burke | 534 | 375 | 909
Burleigh | 21899 | 18018 | 39917
[NAME] | 31172 | 36145 | 67317
Cavalier | 939 | 1034 | 1973
Dickey | 1421 | 1060 | 2481
Divide | 504 | 573 | 1077
Dunn | 942 | 634 | 1576
Eddy | 488 | 644 | 1132
Emmons | 994 | 803 | 1797
[NAME] | 839 | 754 | 1593
Golden Valley | 523 | 302 | 825
Grand Forks | 13139 | 15310 | 28449
Grant | 802 | 510 | 1312
Griggs | 698 | 562 | 1260
Hettinger | 750 | 555 | 1305
Kidder | 672 | 528 | 1200
[NAME] | 1259 | 894 | 2153
Logan | 606 | 415 | 1021
McHenry | 1208 | 1189 | 2397
McIntosh | 924 | 578 | 1502
McKenzie | 1479 | 1074 | 2553
McLean | 2279 | 2278 | 4557
Mercer | 2518 | 1750 | 4268
[NAME] | 6536 | 6222 | 12758
[NAME] | 1165 | 1671 | 2836
[NAME] | 808 | 885 | 1693
[NAME] | 579 | 439 | 1018
Pembina | 1666 | 1474 | 3140
Pierce | 1080 | 1008 | 2088
Ramsey | 2180 | 2310 | 4490
[NAME] | 999 | 1348 | 2347
[NAME] | 667 | 631 | 1298
Richland | 3711 | 3469 | 7180
Rolette | 990 | 3327 | 4317
Sargent | 792 | 1072 | 1864
[NAME] | 491 | 283 | 774
Sioux | 258 | 1085 | 1343
Slope | 249 | 150 | 399
[NAME] | 5970 | 4452 | 10422
Steele | 464 | 550 | 1014
[NAME] | 4785 | 4355 | 9140
Towner | 569 | 573 | 1142
Traill | 1801 | 2074 | 3875
Walsh | 2446 | 2173 | 4619
Ward | 12678 | 11619 | 24297
Wells | 1230 | 1081 | 2311
[NAME] | 5277 | 3615 | 8892
TOTAL | 151019 | 149186 | 300205
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 773232d1647716846-vlookup-and-if-functions-example
Sheet: By Employee

Employee ID | Task Order | Employee Name | 2021-12-15 00:00:00 | 2021-12-31 00:00:00 | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
 |  |  | 80 | 88 | 80 | 80 | 80 | 72 | 88 | 96 | 88
1001 | [NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  | Answer:
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 01 AA.AD | [NAME], [NAME] | 0 | 0 | 0 | 5 | 0 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 02 AC.AD | [NAME], [NAME] | 0 | 5 | 5 | 5 | 5 | 5 | 5
 |  | Total Hours:
 |  | Extra Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extra Hours:
2403 | Doe, [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2403 | Doe, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 2403 | 01 AA.AD | Doe, [NAME] | 0 | 0 | 0 | 0 | 0 | 9 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 2403 | 02 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10
 |  | Total Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours:
 |  | Extra Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Extra Hours:
2050 | Fisher, Mary
 |  | Total Hours:
 |  | Extra Hours:
1920 | [NAME], [NAME]
 |  | Total Hours:
 |  | Extra Hours:
Spreadsheet: 0f0ad938-56c8-4462-b8bc-8f292ca48fc1
Sheet: Activities codes

 | SFY 2013 STATE CODE SHEET
SFY 2013 STATE EDRS-UFARS codes crosswalk
EDRS Activity Codes
Activity code | [NAME]
J | Assessment
M | Special Education Curriculm Development
O | IEP Planning Development, Review Due Process
Z | Travel - Mileage (ECSE - Home Based Travel Only)
Team Teaching Required for Personnel type code 1
+ | Team Teaching Model - Regular Class
* | Team Teaching Model - Resource Room
# | Team Teaching Model - Separate Class
Required for Personnel type code 12 Cultural Liaison
t | Americal Indian
u | Bilingual
v | African American
w | Other
Required for Alternative Delivery of Specialized Instructional Services FSC C and FSC N
s | Special Education Teacher
R | Regular Education Teacher
Required for Personnel Type code 62
a | Interpreter Services
b | Assistive Technology Services
c | Para/PCA Services
d | Nursing Services
e | Vision Services
f | Other IEP Specified Services
Spreadsheet: 790184d1659583437-sum-sumifs-with-multiple-values-in-3-criteria-sum-sumifs-with-multiple-values-in-3-criteria-hd
Sheet: Sheet1

Type | PC | CC | Amount |  |  | Lookup Criteria
A | 101 | 500100 | 49 |  |  | Type | PC | CC |  | HansDouwe
B | 101 | 500100 | 15 |  |  | A | 101 | 500100 |  |  | <--
C | 101 | 500100 | 39 |  |  | C | 202 | 500200 |  |  | <--
A | 202 | 500100 | 30 |  |  |  |  |  |  | or total in 1 formula:
B | 202 | 500100 | 13 |  |  |  |  |  |  |  | <--
C | 202 | 500100 | 16 |  |  | Result
A | 303 | 500100 | 41 |  |  |  | <--
B | 303 | 500100 | 21 |  |  |  | <--
C | 303 | 500100 | 42
A | 101 | 500200 | 23
B | 101 | 500200 | 28
C | 101 | 500200 | 36
A | 202 | 500200 | 43
B | 202 | 500200 | 13
C | 202 | 500200 | 37
A | 303 | 500200 | 45
B | 303 | 500200 | 42
C | 303 | 500200 | 34
A | 101 | 500300 | 17
B | 101 | 500300 | 44
C | 101 | 500300 | 32
A | 202 | 500300 | 23
B | 202 | 500300 | 22
C | 202 | 500300 | 40
A | 303 | 500300 | 26
B | 303 | 500300 | 11
C | 303 | 500300 | 37
Spreadsheet: 681783d1591740498-using-if-function-to-populate-cells-time-help-excel-help-time-2
Sheet: Scheduled Shift

Activity Date | Organization Name | Employee Name | Shift Start | Shift End |  |  |  | 2020-06-08 08:00:00 | 2020-06-08 08:15:00 | 2020-06-08 08:30:00 | 2020-06-08 08:45:00 | 2020-06-08 09:00:00 | 2020-06-08 09:15:00 | 2020-06-08 09:30:00 | 2020-06-08 09:45:00 | 2020-06-08 10:00:00 | 2020-06-08 10:15:00 | 2020-06-08 10:30:00 | 2020-06-08 10:45:00 | 2020-06-08 11:00:00 | 2020-06-08 11:15:00 | 2020-06-08 11:30:00 | 2020-06-08 11:45:00 | 2020-06-08 12:00:00 | 2020-06-08 12:15:00 | 2020-06-08 12:30:00 | 2020-06-08 12:45:00 | 2020-06-08 13:00:00 | 2020-06-08 13:15:00 | 2020-06-08 13:30:00 | 2020-06-08 13:45:00 | 2020-06-08 14:00:00 | 2020-06-08 14:15:00 | 2020-06-08 14:30:00 | 2020-06-08 14:45:00 | 2020-06-08 15:00:00 | 2020-06-08 15:15:00 | 2020-06-08 15:30:00 | 2020-06-08 15:45:00 | 2020-06-08 16:00:00 | 2020-06-08 16:15:00 | 2020-06-08 16:30:00 | 2020-06-08 16:45:00 | 2020-06-08 17:00:00 | 2020-06-08 17:15:00 | 2020-06-08 17:30:00 | 2020-06-08 17:45:00 | 2020-06-08 18:00:00 | 2020-06-08 18:15:00 | 2020-06-08 18:30:00 | 2020-06-08 18:45:00 | 2020-06-08 19:00:00 | 2020-06-08 19:15:00 | 2020-06-08 19:30:00 | 2020-06-08 19:45:00 | 2020-06-08 20:00:00 | 2020-06-08 20:15:00 | 2020-06-08 20:30:00 | 2020-06-08 20:45:00 | 2020-06-08 21:00:00 | 2020-06-08 21:15:00 | 2020-06-08 21:30:00 | 2020-06-08 21:45:00
2020-06-08 00:00:00 | Blockbusters | Superman | 2020-06-08 09:30:00 | 2020-06-08 17:45:00 |  |  | Superman |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2020-06-08 00:00:00 | Blockbusters | Superwoman | 2020-06-08 09:00:00 | 2020-06-08 18:15:00 |  |  | Superwoman |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 754461d1636222670-formula-to-bring-3-different-status-depending-on-percentage-test-1
Sheet: Sheet1

Name | # [NAME] | # [NAME] | % Completed | Status | Column1
Eddy | 450 | 450
Maria | 1000 | 658
Lazaro | 8054 | 7564
Pam | 3866 | 3866
[NAME] | 25 | 0
[NAME] | 3597 | 3465
Spreadsheet: 733515d1621608184-drop-down-assistance-to-work-out-waste-percent-plate-project
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Machines | [NAME] | Length |  | Sheet [NAME] | Sheet [NAME] | surface area
 |  |  | [NAME] |  | Machine Spec |  | [NAME] | Length | number on sheeet | % utilisation | % waste |  | Bobst 76 | 556 | 798 |  | 1250 | 1700
 |  |  | 1250x1700 |  | Bobst 76 |  |  |  |  |  |  |  | Bobst 102 | 715 | 1052 |  | 1500 | 2200
 |  |  | 1500x2200 |  |  |  |  |  |  |  |  |  | Bobst 104 | 736 | 1074
 |  |  |  |  |  |  |  |  |  |  |  |  | Bobst 106s | 760.5 | 1090
 |  |  |  |  |  |  |  |  |  |  |  |  | Bobst 106c | 730 | 1090
 |  |  |  |  |  |  |  |  |  |  |  |  | Bobst SPO 1600 | 1090 | 1629
 |  |  |  |  |  |  |  |  |  |  |  |  | Bobst 142 | 1028 | 1449
 |  |  |  |  |  |  |  |  |  |  |  |  | Bobst 145 | 1064 | 1484