tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4594d873-083c-4b07-b2c9-a642f7abfb3a
Sheet: Docket

JURIS | TICKET | VIOL | OCCUR | NAME | VIOLATION | FINE AMT | COST AMT | REST AMT | TOTAL AMT | TIME SERVED | PAID AMT | BALANCE | OFFENSE DT | ATTORNEY | BOND POSTED | COMPLAINANT
DPD | 1017571 | 5740 | 0 | AIKINS,HAYWOOD | [NAME] | 281 | 69 | 0 | 350 | 0 | 0 | 350 | 2013-03-24 00:00:00 | [NAME] | 0 | CARLA [NAME]
DPD | 1019913 | 2244 | 0 | AMADI,EMMANUEL O | SPEEDING | 81 | 102.1 | 0 | 183.1 | 0 | 0 | 183.1 | 2013-01-31 00:00:00 |  | 183.1 | C VINSON
DPD | 194380 | 5004 | 0 | DAVIS,WALTER | FENCE - FAILED TO MAINTAIN - CITY ORDINANCE | 173 | 64 | 0 | 237 | 0 | 0 | 237 | 2012-07-14 00:00:00 |  | 0 | T WASHINGTON
DPD | 1016652 | 2000 | 0 | HALL,[NAME] | RED LIGHT - RAN | 70 | 102.1 | 0 | 172.1 | 0 | 0 | 172.1 | 2012-11-10 00:00:00 |  | 0 | M A GONZALES
DPD | 1022008 | 5140 | 0 | JONES,[NAME] TROY | LITTERING - VEHICLE DRIVER - CITY ORD | 173 | 119 | 0 | 292 | 0 | 0 | 292 | 2013-02-27 00:00:00 |  | 292 | C VINSON
FTA | 1022008 | 3039 | 1 | JONES,[NAME] TROY | FAILURE TO APPEAR | 73 | 119 | 0 | 192 | 0 | 0 | 192 | 2013-05-08 00:00:00 |  | 192 | R W MITCHELL
DPD | 1018978 | 3002 | 0 | NKUBA-MCCLENDON,[NAME] | LIABILITY INSURANCE-FMFR | 0 | 317 | 0 | 317 | 0 | 0 | 317 | 2013-10-02 00:00:00 |  | 0 | R ALLSTOT
DPD | 1018789 | 2244 | 0 | SMITH,CURTIS [NAME] | SPEEDING | 85 | 102.1 | 0 | 187.1 | 0 | 0 | 187.1 | 2013-07-10 00:00:00 |  | 0 | J R ZIHLMAN
DPD | 1022198 | 1320 | 0 | STEPHENS,LOREN KEITH | [NAME] | 45 | 102.1 | 0 | 147.1 | 0 | 0 | 147.1 | 2013-05-28 00:00:00 |  | 0 | C VINSON
DPD | 1022198 | 2413 | 0 | STEPHENS,LOREN KEITH | TURN - NO SIGNAL | 70 | 102.1 | 0 | 172.1 | 0 | 0 | 172.1 | 2013-05-28 00:00:00 |  | 0 | C VINSON
DPD | 188763 | 3020 | 0 | STRAIN,TIMOTHY MICHAEL | CRIMINAL MISCHIEF-DAMAGE TO PROPERTY | 223 | 69 | 0 | 292 | 0 | 0 | 292 | 2013-05-07 00:00:00 |  | 0 | B EVANS
DPD | 1021570 | 2098 | 0 | WELTY,MICHEAL BRIAN | REGISTRATION-NO REAR/FRONT PLATE | 70 | 102.1 | 0 | 172.1 | 0 | 0 | 172.1 | 2013-02-12 00:00:00 |  | 0 | K JORDAN
Spreadsheet: 291588d1390337039-overnight-weekend-work-schedule-schedule2
Sheet: Sheet2

 | Saturday | Sunday | Monday | Tuesday | Wedsnesday | Thursday | Friday | Totals | Saturday | Sunday | Monday | Tuesday | Wedsnesday | Thursday | Friday | Totals
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 216409 | 214564 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 212420 | 214971 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 221572 | 222370 |  | 4477 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 219273 | 224915 |  | 1276 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 185522 | 183474 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 164874 | 182838 |  | 21037 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 170513 | 212981 |  | 46832 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 208241 | 215303 |  | 11936 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 244312 | 252585 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 239584 | 236368 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 237058 | 239663 |  | 6248 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 211948 | 213917 |  | 4672 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 217410 | 213983 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 233108 | 238826 |  | 7833
15 | 189384 | 215677 |  | 26468 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 151173 | 189752 |  | 39013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 129417 | 185365 |  | 52368 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18 | 205779 | 212053 |  | 1879
19 | 191216 | 208174 |  | 7701
20 | 153438 | 202373 |  | 26809
21 | 186072 | 209859 |  | 14484
22 | 160654 | 217616 |  | 47947
23 | 148501 | 189529 |  | 38025
24 | 141423 | 186433 |  | 57326
25 | 148090 | 192818 |  | 50101
26 | 177460 | 186428 |  | 5955
27 | 132979 | 177800 |  | 44757
28
29
30
31
 | 2001-05-31 00:00:00 |  |  |  | -386
 | 2001-06-27 00:00:00
Spreadsheet: 726769d1617442201-sumifs-function-doesnt-calculate-values-as-expected-accounting-module
Sheet: Monthly Expenses Summary

 | MONTHLY EXPENSES SUMMARY
 | Slicer to filter data by Account Titles is in this cell.
 | G/L Code | Account Title | January | February | March | April | May | June | July | August | September | October | November | December | Total
 | WGL001 | Building Rent | 35000 | 35000
 | WGL002 | Electricity
 | WGL003 | Fuel
 | WGL004 | Internet Charges | 20000
 | WGL005 | Mobile Charges
 | WGL006 | Statationery |  |  |  |  |  |  |  |  |  |  |  | 4000
 | WGL007 | Travelling Costs
 | WGL008 | Marketing
 | WGL009 | Charitables
 | WGL010 | Sponsorships
 | WGL011 | Entertainment
 | WGL012 | Insurance
 | WGL013 | Water Bill
 | WGL014 | Training
 | WGL015
 | WGL016
 | WGL017
 | WGL018
 | Total
Spreadsheet: 80249d1280431386-counting-unique-entries-in-a-column-correlated-by-date-example-1-
Sheet: Sheet1

Billing month | Service number
2005-10-01 00:00:00 | xxxx4496 |  |  |  | 2005-10-01 00:00:00 | 2005-12-01 00:00:00
2005-10-01 00:00:00 | [NAME]
2005-10-01 00:00:00 | xxxx0823 |  |  |  | xxxx4027
2005-10-01 00:00:00 | xxxx0823
2005-10-01 00:00:00 | xxxx4020
2005-10-01 00:00:00 | xxxx4020
2005-10-01 00:00:00 | xxxx4027
2005-10-01 00:00:00 | xxxx4027
2005-10-01 00:00:00 | xxxx9399
2005-10-01 00:00:00 | xxxx3994
2005-10-01 00:00:00 | xxxx3994
2005-10-01 00:00:00 | xxxx4496
2005-10-01 00:00:00 | xxxx4496
2005-10-01 00:00:00 | xxxx9399
2005-10-01 00:00:00 | xxxx3994
2005-10-01 00:00:00 | xxxx4027
2005-10-01 00:00:00 | [NAME]
2005-10-01 00:00:00 | xxxx4027
2005-10-01 00:00:00 | [NAME]
2005-10-01 00:00:00 | xxxx4027
2005-11-01 00:00:00 | xxxx4027
2005-11-01 00:00:00 | xxxx3994
2005-11-01 00:00:00 | xxxx9399
2005-11-01 00:00:00 | xxxx9399
2005-11-01 00:00:00 | xxxx4020
2005-11-01 00:00:00 | xxxx4020
2005-11-01 00:00:00 | xxxx3994
2005-11-01 00:00:00 | xxxx4020
2005-11-01 00:00:00 | xxxx4020
2005-11-01 00:00:00 | xxxx9399
2005-11-01 00:00:00 | xxxx3994
2005-11-01 00:00:00 | xxxx4020
2005-11-01 00:00:00 | xxxx9399
2005-11-01 00:00:00 | xxxx4496
2005-11-01 00:00:00 | xxxx4496
2005-11-01 00:00:00 | xxxx0823
2005-11-01 00:00:00 | xxxx9399
2005-11-01 00:00:00 | xxxx0823
2005-11-01 00:00:00 | xxxx3994
2005-11-01 00:00:00 | xxxx4020
2005-12-01 00:00:00 | xxxx0823
2005-12-01 00:00:00 | xxxx0823
2005-12-01 00:00:00 | xxxx3994
2005-12-01 00:00:00 | xxxx0823
2005-12-01 00:00:00 | xxxx0823
2005-12-01 00:00:00 | xxxx0823
2005-12-01 00:00:00 | xxxx9399
2005-12-01 00:00:00 | xxxx4020
2005-12-01 00:00:00 | xxxx9399
2005-12-01 00:00:00 | xxxx4020
2005-12-01 00:00:00 | xxxx9399
2005-12-01 00:00:00 | xxxx4020
2005-12-01 00:00:00 | xxxx3994
2005-12-01 00:00:00 | xxxx9399
2005-12-01 00:00:00 | xxxx9399
2005-12-01 00:00:00 | xxxx9399
2005-12-01 00:00:00 | xxxx9399
2005-12-01 00:00:00 | xxxx3994
2005-12-01 00:00:00 | xxxx9399
2005-12-01 00:00:00 | xxxx9399
Spreadsheet: 849101d1699635162-formula-to-return-the-header-with-first-positive-value-after-a-series-of-negative-vaules-test-data
Sheet: Test Data

 | Need formula to return the first positive value after negative values |  | 2023-11-11 00:00:00 | 2023-11-18 00:00:00 | 2023-11-25 00:00:00 | 2023-12-02 00:00:00 | 2023-12-09 00:00:00 | 2023-12-16 00:00:00 | 2023-12-23 00:00:00 | 2023-12-30 00:00:00 | 2024-01-06 00:00:00 | 2024-01-13 00:00:00 | 2024-01-20 00:00:00 | 2024-01-27 00:00:00 | 2024-02-03 00:00:00 | 2024-02-10 00:00:00 | 2024-02-17 00:00:00 | 2024-02-24 00:00:00 | 2024-03-02 00:00:00
Item ID | Return the weekending with positive value | Expected results | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH | Ending Inv OH
Item A |  | 2023-12-02 00:00:00 | -500 | -600 | -700 | 3342 | 3072 | -2000 | 2531 | 2166 | 1801 | 1436 | 1071 | 701 | 330 | 1160 | 789 | 465 | 141
Item B |  | 2023-11-11 00:00:00 | 720 | 840 | 780 | 1188 | 756 | 642 | 489 | 362 | 234 | 106 | -22 | 385 | 263 | 142 | 20 | 547 | 450
Item C |  | 2023-12-23 00:00:00 | -500 | -600 | -700 | -800 | -1000 | -2000 | 2531 | 2166 | 1801 | 1436 | -500 | 701 | 330 | 1160 | 789 | 465 | 141
Spreadsheet: 258410dc-f7dd-4301-ab6d-68d63e96901b
Sheet: ECH and 4-8

 | Fresh. | Soph. | Juniors | Seniors | Post-Bach | Sem. Total | Academic Probation | ECH-6 SPED | [NAME] | 4-8 Gen | 4-8 ELA | 4-8 Math | 4-8 Science | 4-8 Social Studies | Trad. based on age | Non-Trad based on age | Transfer Admit | FR Admit | Re-entry | Post-bach
Fall 2010 | 124 | 102 | 107 | 147 | 5 | 485 | 24 | 133 | 291 | 47 | 5 | 8 | 1 | 0 | 369 | 116 | 145 | 288 | 47 | 5
Spring 2011 | 74 | 107 | 106 | 148 | 3 | 438 | 30 | 133 | 255 | 38 | 5 | 7 | 0 | 0 | 313 | 125 | 120 | 276 | 39 | 3
Fall 2011 | 92 | 106 | 93 | 155 | 1 | 447 | 10 | 150 | 241 | 45 | 4 | 7 | 0 | 0 | 300 | 147 | 145 | 273 | 28 | 1
Spring 2012 | 65 | 96 | 110 | 133 | 1 | 405 | 21 | 162 | 204 | 35 | 2 | 2 | 0 | 0 | 314 | 91 | 127 | 254 | 23 | 1
Fall 2012 | 77 | 78 | 104 | 149 | 1 | 409 | 20 | 176 | 200 | 30 | 1 | 1 | 0 | 1 | 336 | 96 | 134 | 251 | 23 | 1
Spring 2013 | 42 | 70 | 97 | 139 | 3 | 351 | 24 | 150 | 172 | 28 | 1 | 0 | 0 | 0 | 250 | 101 | 120 | 214 | 16 | 1
Fall 2013 | 56 | 67 | 78 | 133 | 4 | 337 | 17 | 136 | 171 | 31 | NA | NA | NA | NA | 259 | 79 | 122 | 199 | 15 | 2
*Numbers are based on census report from 12th day of class
*Effective fall 2012 Academic Standing (dean’s list, good standing, probation, and suspension) determined by institutional GPA not overall.
Spreadsheet: e4635b1d-dd3b-41b6-b085-de16c297841f
Sheet: Page 2

Permit No.: |  |  | WQ0017824 |  |  | Facility Name: |  | Uwharrie Middle School |  |  |  |  |  | County: | Randolph |  | Month: | January |  | Year: | 2014
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 5 |  | Field Name: |  | 6 |  | Field Name: |  | 7 |  | Field Name: |  | 8
 |  |  |  |  |  | Area (acres): |  | 0.338 |  | Area (acres): |  | 0.327 |  | Area (acres): |  | 0.338 |  | Area (acres): |  | 0.413
 |  |  |  |  |  | Cover Crop: |  | Hardwood Forest |  | Cover Crop: |  | Hardwood Forest |  | Cover Crop: |  | Hardwood Forest |  | Cover Crop: |  | Hardwood Forest
 |  |  |  |  |  | [NAME] (in): |  | 0.25 |  | [NAME] (in): |  | 0.25 |  | [NAME] (in): |  | 0.25 |  | [NAME] (in): |  | 0.25
 |  |  |  |  |  | Annual Rate (in): |  | 39 |  | Annual Rate (in): |  | 39 |  | Annual Rate (in): |  | 39 |  | Annual Rate (in): |  | 39
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Total Volume Applied | Total Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Total Volume Applied | Total Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Total Volume Applied | Total Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Total Volume Applied | Total Time    Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 94306d1294158683-index-match-finding-max-index-max
Sheet: Sheet1

NNW |  | NNW | WNW | NNE | SSW | SE | SSW | SSW | SSW | SSW | W | N | WNW
WNW |  | 2nd example
NNE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | {=INDEX(C1:N1,MATCH(MAX(COUNTIF(C1:N1,C1:N1)),COUNTIF(C1:N1,C1:N1),0),1)}
SSW
SE |  | Looking to find the wind direction that shows up the most in the two examples,
SSW |  | In the first example (A1:A12), SSW shows up 5 times, and in the formula in A13 it gives the value of SSW.
SSW |  | In the second example (C1:N1), SSW shows up 5 times, but in the formula in [NAME], it gives an error or #[NAME]!
SSW
SSW |  | I took the formula in A13 and put it in [NAME] and changed the range from A1:A12 to C1:N1.
W |  | I need help writing the formula in [NAME] go equal the value of SSW.
N
WNW
 |  | 1st Example
 |  |  |  |  |  |  |  |  |  |  |  |  | {=INDEX(A1:A12,MATCH(MAX(COUNTIF(A1:A12,A1:A12)),COUNTIF(A1:A12,A1:A12),0),1)}
Spreadsheet: 868106d1714829280-index-match-function-v2-indexequiv
Sheet: Out

Semaine | Heures  travaillees | Heures temporaires | Heures supplementaires | Conge rais pers - Planifie | Conge rais pers - Urgent | PAICD - approuve | Conge special | Accident du travail | [NAME] (PT&TP) | Conge non-paye
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
52
Spreadsheet: 82609d1282666320-remove-abbrevation-from-multiple-cells-samples-names
Sheet: Sheet1

HIGH RESOLUTION TECHNOLOGY & PETROLEUM LTDA (1) |  | INC.
HIGH RESOLUTION TECHNOLOGY & PETROLEUM LTDA (2) |  | CORP. |  | Working Correctly
CONSOL ENERGY INC. | NSOL ENERGY INC. | , INC |  | Not Working
DEER CONSUMER PRODUCTS INC. | DEER NSUMER PRODUCTS INC. | CORPORATION |  | Working Incorrectly
CLINICAL DATA INC. | CLINICAL DATA | HOLDING
DIAMOND FOODS INC. | DIAMOND FOODS | COMPANY
ARES CAPITAL CORP. | ARES CAPITAL RP. | LTD.
SANDERSON FARMS |  | CORP
KAR AUCTION SERVICES INC. | KAR AUCTION SERVICES | , INC.
REALD |  | CAPITAL
WARREN RESOURCES INC |  | LP
CF INDUSTRIES |  | , CORP
CBOE HOLDINGS INC. | CBOE S INC. | , CORP.
HUDSON PACIFIC PROPERTIES |  | , LP
HOME PROPERTIES, INC | HOME PROPERTIES | L.P.
EDUCATION MANAGEMENT CORPORATION | EDUCATION MANAGEMENT | ,L.P.
SENSATA TECHNOLOGIES HOLDING | SENSATA TECHNOLOGIES | PLC
FIRST POTOMAC REALTY TRUST |  | , PLC
BERRY PETROLEUM COMPANY | BERRY PETROLEUM | , LTD.
EQT CORP. | EQT RP. | LLC
KANSAS CITY SOUTHERN |  | , LLC
SWS GROUP INC. | SWS GROUP | CO
DG FAST CHANNEL |  | CO.
SALIX PHARMACEUTICALS |  | , CO
SOLAR CAPITAL LTD. | SOLAR  LTD. | , CO.
CLOUD PEAK ENERGY INC. | CLOUD PEAK ENERGY | COMPANY
FEDERAL SIGNAL CORP | FEDERAL SIGNAL RP | CO., INC.
FEDERAL SIGNAL CORP | FEDERAL SIGNAL RP | PARTNERS
CLINICAL DATA SYSTEMS |  | &CO.
APOLLO INVESTMENT CORP. | APOLLO INVESTMENT RP. | & CO.
PIEDMONT OFFICE REALTY TRUST |  | & CO
GOLUB GOLUB CAPITAL BDC INC. | GOLUB GOLUB  BDC INC. | CORPORATION
ANCESTRY.COM | ANCESTRY.M | INCORPORATED
TREEHOUSE FOODS INC. | TREEHOUSE FOODS
BIOMED REALTY TRUST
PENSKE AUTOMOTIVE GROUP INC. | PENSKE AUTOMOTIVE GROUP
INLAND REAL ESTATE CORP | INLAND REAL ESTATE RP
FORD MOTOR COMPANY | FORD MOTOR
APOLLO INVESTMENT CORP | APOLLO INVESTMENT RP
SOLAR CAPITAL LTD. | SOLAR  LTD.
SOVRAN SELF STORAGE, INC. | SOVRAN SELF STORAGE
CEDAR SHOPPING CENTERS INC. | CEDAR SHOPPING CENTERS
BLACKROCK KELSO CAPITAL | BLACKROCK KELSO
STUDENT TRANSPORTATION OF AMERICA LTD. | STUDENT TRANSPORTATION OF AMERICA
ALEXANDRIA REAL ESTATE EQUITIES
COLONIAL PROPERTIES TRUST | LONIAL PROPERTIES TRUST
COGDELL SPENCER CO | GDELL SPENCER
COGDELL SPENCER | GDELL SPENCER
Spreadsheet: 192851d1352587500-how-to-make-multiple-references-from-one-worksheet-to-another-easily-snack-calendar-gen
Sheet: schedule

 | Monday | Tuesday | Wednesday | Thursday
week 1 | [NAME] | [NAME] | [NAME] | [NAME]
 | Whole wheat crackers, cheese, grapes & water | Celery, cream cheese, raisins  & juice | Cottage cheese, fruit, carrots & water | [NAME], jam, oranges & milk
week 2 | [NAME] | [NAME] | [NAME] | [NAME]
 | Cheese sticks, graham crackers & water | Yogurt covered raisins, apples, & Juice | Nilla wafers, bananas & milk | [NAME] cakes, yogurt, peaches & milk
week 3 | [NAME] | Kenny | [NAME] | [NAME]
 | Cucumbers, slatines, ranch & water | Chips, salsa (not spicy) & milk | [NAME], pears & milk | Nutrigrain bars, apples & milk
week 4 | [NAME] | Betty | [NAME] | Curt
 | Tortilla, peanut butter, apples & juice | Pita chips, hummus & milk | Wheat thins, cream cheese, cherry tomatoes & water | [NAME], yogurt covered raisins & water
week 5 | Deb | [NAME] | [NAME] | [NAME]
 | Celery, peanut butter, raisins & milk | Low-fat pudding, almonds, animal crackes & juice | [NAME], yogurt, canned pineapple & milk | Mini bagels, cream cheese & water
week 6 | [NAME] | [NAME] | Sandy | [NAME]
 | Jell-O, popcorn, cheese sticks & juice | Whole grain granola, yogurt, clementines & water | Edamame, vegetable dip, wheat thins & milk | Fruit leather (no added sugars), triscuits, cheese & juice
week 7 | Kristen | Vicky | [NAME] | Julie
 | Veggie chips, kiwi & juice | Applesauce, [NAME], bananas & water | Tortilla, shredded cheese, mild salsa & water | Granola Bars, Oranges & water
week 8 |  | Nate | [NAME] | [NAME]
 |  | Cucumbers, ranch, whole-grain crackers & water | Whole grain fig newtons, granola, fruit & water | snack, snack, snack, & snack
Spreadsheet: kate_symes__18979__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-30 00:00:00 |  | 179.99 | 23600 | 125.18 | 9040
 | 2001-03-29 00:00:00 |  | 187.27 | 26400 | 130.98 | 10880 | 181.96 | 553 | 151.95 | 154
 | 2001-03-28 00:00:00 |  | 161.91 | 27600 | 100.36 | 9480 | 170.67 | 208 | 110.85 | 544
 | 2001-03-27 00:00:00 |  | 155.95 | 22800 | 89.58 | 6200 | 152.08 | 1038 | 121.24 | 169
 | 2001-03-26 00:00:00 |  | 334.36 | 15600 | 230.55 | 6600 | 102.59 | 243 | 60.96 | 287
 | 2001-03-25 00:00:00 |  | 260 | 0 | 230 | 0 | 70 | 200 | 41.32 | 456 |  | 229.94 | 19200
 | 2001-03-24 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 113.77 | 1687 | 139.44 | 832
 | 2001-03-23 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 331.82 | 1155 | 150 | 4
 | 2001-03-22 00:00:00 |  | 377.69 | 16800 | 274.53 | 6400 | 233.97 | 521 | 266.13 | 248
 | 2001-03-21 00:00:00 |  | 452.08 | 17280 | 319.69 | 4928 | 443.97 | 58 | 294.11 | 259
 | 2001-03-20 00:00:00 |  | 402.53 | 16000 | 277.64 | 5952 | 456.15 | 488 | 316.05 | 214
 | 2001-03-19 00:00:00 |  | 397.48 | 26800 | 342.53 | 7360 | 398.47 | 1222 | 145.95 | 454
 | 2001-03-18 00:00:00 |  | 370 | 0 | 330 | 0 | 140.35 | 285 | 146.22 | 1255 |  | 343.75 | 22080
 | 2001-03-17 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 400 | 50 | 215.18 | 140
 | 2001-03-16 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 325 | 415 | 188.89 | 405
 | 2001-03-15 00:00:00 |  | 216.73 | 20560 | 174.7 | 10144 | 237.58 | 642 | 186.25 | 260
 | 2001-03-14 00:00:00 |  | 211.45 | 25360 | 172.67 | 8512 | 225.87 | 1552 | 157.5 | 480
 | 2001-03-13 00:00:00 |  | 211.79 | 20960 | 168.03 | 9088 | 235.45 | 33 | 150.36 | 445
 | 2001-03-12 00:00:00 |  | 263.78 | 24240 | 255.08 | 7632 | 223.3 | 996 | 176.32 | 106
 | 2001-03-11 00:00:00 |  | 265 | 0 | 230 | 200 | 219.32 | 111 | 174.9 | 264 |  | 255.41 | 23256
 | 2001-03-10 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 247.11 | 873 | 227.78 | 709
 | 2001-03-09 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 277.5 | 52 | 230.19 | 982
 | 2001-03-08 00:00:00 |  | 262.5 | 14400 | 203.46 | 4624 | 282.12 | 2609 | 247.42 | 748
 | 2001-03-07 00:00:00 |  | 332.94 | 26544 | 285.65 | 15720 | 330.51 | 717 | 232.25 | 507
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232 | 336.81 | 452 | 233.81 | 624
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 | 2001-03-02 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 377.23 | 90 | 300 | 100
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872 | 372.61 | 244 | 255 | 160
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 |  |  |  |  |  | ..
Spreadsheet: 213834d1360672133-using-combo-box-to-show-monthly-variable-data-test-7
Sheet: Sheet2

February
 | Jan Data |  |  |  |  | TL Name:
 |  | Advisor | CM | NTU | Fees | Own Access | Incentives | Refunds | Variances | Observations | Audit | Security | Folders |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All
 |  |  |  | Crits & Customer |  | EOD & Verbal |  | Advisor Errors
 |  | Calls | AS | Cust Contact | Advisor Feedback | EOD % logged | Logging & Outstandimg | Number of AE | Knowledge | Briefs
Spreadsheet: 35e5ea4e-93ae-4f13-b5f6-7ba4902e975f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MMAS | Test | MMAS | Methylmalonic Acid (MMA), Quantitative, Serum | Methylmalonic Acid, QN, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Serum Gel Tube: SGT |  |  | 1.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1.5 mL | 0.8 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | < or =0.40 nmol/mL | Monday through Friday; [NAME] until noon | 3 days (not reported on Saturday or Sunday) | 5 days | 1 | 83921 |  |  |  |  | Rochester
MMAS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 48 days
MMAS | Result | 80289 | Methylmalonic Acid, QN, S | Methylmalonic Acid, QN, S | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 13964-2 | Methylmalonate:SCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 35326d1232916490-countif-check-if-several-variable-appeared-in-the-range-excelforumhelp09
Sheet: Sheet1

 |  |  |  |  |  | 6 | 5,1 | 4,2 | 4,1,1
1 | 2 | 0 | 1 | 2 |  | 0 | 0 |  | ?
1 | 1 | 0 | 2 | 2 |  | 0 | 0
1 | 1 | 2 | 1 | 1 |  | 0 | 0
1 | 2 | 2 | 0 | 1 |  | 0 | 0
3 | 1 | 1 | 1 | 0 |  | 0 | 0
0 | 2 | 0 | 2 | 2 |  | 0 | 0
2 | 2 | 0 | 0 | 2 |  | 0 | 0
0 | 2 | 1 | 1 | 2 |  | 0 | 0
1 | 1 | 2 | 0 | 2 |  | 0 | 0
2 | 1 | 3 | 0 | 0 |  | 0 | 0
2 | 1 | 1 | 1 | 1 |  | 0 | 0
1 | 2 | 2 | 1 | 0 |  | 0 | 0
0 | 0 | 4 | 1 | 1 |  | 0 | 0
1 | 2 | 1 | 2 | 0 |  | 0 | 0
1 | 0 | 2 | 2 | 1 |  | 0 | 0
0 | 0 | 2 | 3 | 1 |  | 0 | 0