tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0af8195a-eab1-467c-8729-42e75254c985
Sheet: Sheet1

Library Web Site Statistics  <http://www.uri.edu/library/> | 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
2002-2003
Successful requests for pages (visits)
 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | ANNUAL TOTAL
/library/ successful requests for pages (visits) | 97106 | 90268 | 143641 | 154877 | 166713 | 98853 | 79876 | 129090 | 131415 | 158439 | 89584 | 80313 | 1420175
uri.edu successful requests for pages (visits) | 2483502 | 2972267 | 3288406 | 2445981 | 2368849 | 2041983 | 2407262 | 2454518 | 2430450 | 2677322 | 2151320 | 1891988 | 29613848
/library/ visits as % of uri.edu visits | 0.03910043156800357 | 0.03037008451797904 | 0.04368104181782907 | 0.06331897099773057 | 0.07037721695219915 | 0.04841029528649357 | 0.03318126568690903 | 0.05259281048254688 | 0.05407023390730112 | 0.05917816385178921 | 0.04164141085473105 | 0.04244900073361987 | 0.04795644929358724
/library/ distinct hosts served | 7514 | 7427 | 10239 | 13016 | 14062 | 11364 | 12179 | 14190 | 14593 | 13875 | 13120 | 11854 | 143433
uri.edu distinct hosts served | 148712 | 159980 | 166679 | 171982 | 175929 | 162441 | 189028 | 186010 | 199374 | 186667 | 194108 | 191212 | 2132122
/library/ distinct hosts served as % of uri | 0.05052719350153317 | 0.04642455306913364 | 0.06142945422038769 | 0.07568233884941447 | 0.07992997174996731 | 0.06995770772157275 | 0.06442960831199611 | 0.07628622117090479 | 0.07319409752525405 | 0.07433022441031355 | 0.06759123786757887 | 0.06199401711189674 | 0.06727241686920354
Spreadsheet: 44220d1242853947-dget-does-not-return-a-value-when-it-should-dgetissue
Sheet: Sheet1

Type | Supplier | Model | KWac | KWp | Voltage | Phase | Breaker | PartNumber | Cost | AmountPerWp |  | Warranty | UnitsPerTruck | QuantityPhaseCopper | PhaseCopper | QuantityNeutralCopper | NeutralCopper | QuantityGroundCopper | GroundCopper | QuantityPhaseAluminum | PhaseAluminum | QuantityNeutralAluminum | NeutralAluminum | QuantityGroundAluminum | GroundAluminum | ConduitSize | QuantityConduit
Satcon:30 | Satcon | PV30 | 30 | 36 | 480 | 3 | 40 | 1506-626 | 16590 | 0.4608333333333333 | 4645.200000000001 | 7962 | 36 | 3 | #8 | 1 | #10 | 1 | #8 | 3 | #6 | 1 | #10 | 1 | #8 | 1.5 | 1
Satcon:50 | Satcon | PV50 | 50 | 60 | 480 | 3 | 65 | 1506-628 | 19560 | 0.326 | 5476.8 | 9189 | 30 | 3 | #4 | 1 | #8 | 1 | #8 | 3 | #3 | 1 | #8 | 1 | #8 | 1.5 | 1
Satcon:75 | Satcon | PV75 | 75 | 90 | 480 | 3 | 100 | 1506-630 | 30534 | 0.3392666666666667 | 8549.52 | 10177 | 24 | 3 | #2 | 1 | #6 | 1 | #8 | 3 | 1ot | 1 | #6 | 1 | #6 | 2 | 1
Satcon:100 | Satcon | PV100 | 100 | 120 | 480 | 3 | 150 | 1506-632 | 34776 | 0.2898 | 9737.28 | 10552 | 18 | 3 | 1ot | 1 | #6 | 1 | #6 | 3 | 3ot | 1 | #6 | 1 | #4 | 2.5 | 1
Satcon:135 | Satcon | PV135 | 135 | 162 | 480 | 3 | 200 | 1506-634 | 44352 | 0.2737777777777778 | 12418.56 | 12985 | 12.34567901234568 | 3 | 4ot | 1 | #4 | 1 | #2 | 3 | 250 MCM | 1 | #4 | 1 | #2 | 3 | 1
Satcon:250 | Satcon | PV250 | 250 | 300 | 480 | 3 | 400 | 1507-016 | 67002 | 0.22334 | 18760.56 | 16357 | 6 | 3 | 500 MCM | 1 | #3 | 1 | 1ot | 6 | 250 MCM | 2 | #3 | 2 | 1ot | 4 | 1
Satcon:375 | Satcon | PV375 | 375 | 425 | 480 | 3 | 600 | 1507-017 | 86480 | 0.2034823529411764 | 24214.4 | 22901 | 4 | 6 | 300 MCM | 2 | #1.0 | 2 | 1ot | 6 | 500 MCM | 2 | #1.0 | 2 | 2ot | 3 | 2
Satcon:500 | Satcon | PV500 | 500 | 600 | 480 | 4 | 800 | 1506-638 | 110440 | 0.1840666666666667 | 30923.2 | 26576 | 4 | 6 | 500 MCM | 2 | #3 | 2 | 1ot | 9 | 400 MCM | 3 | 1ot | 3 | 3ot | 4 | 2
 | Type
 | Satcon:30
Spreadsheet: 716383d1612190946-formula-to-look-up-2-columns-of-data-and-return-data-from-another-worksheet-cost-calculator
Sheet: Pricing

Part No. | Product Description | Package Type | Weight (g) | Post Cost
ABC | Part ABC | LL | 300 | 2
DEF | Part DEF | RM | 750 | 2.5
GHI | Part GHI | OS | 2000 | 18
JKL | Part JKL | P | 5050 | 6
Spreadsheet: 116915d1312299122-selective-columns-handicapscorecards-master3
Sheet: Transfer to Archive

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index
Posn on day | Player | Course | Competition | Tee | Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | handicap | exact | stableford | adustment | new handicap | par 3 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | etc …
Spreadsheet: 879094d1726557634-auto-highlighting-and-extracting-in-other-table-the-not-mathing-numbers-book100
Sheet: Sheet1

DATA |  |  |  |  |  |  |  |  |  |  | HIGHLIGHT THE NUMBERS |  |  |  |  |  |  |  |  |  |  |  | RESULT HERE NOT MATCHING NUMBERS
 | Table A |  |  |  |  |  | Table B |  |  |  |  | Table A |  |  |  |  |  | Table B |  |  |  |  |  | Table A |  |  |  | Table B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Maching Numbers against B |  |  |  | Not Maching Numbers against A
Reference | D | C |  |  |  | Reference | C | D |  |  | Reference | D | C |  |  |  | Reference | C | D |  |  |  | Reference | D | C |  | Reference | C | D
NJv : 2323 | 5000 | 0 |  |  |  | BPmt : 1066 | 0 | 5000 |  |  | NJv : 2323 | 5000 | 0 |  |  |  | BPmt : 1066 |  | 5000 |  |  |  | NJv : 2596 | 0 | 4348 |  | NJv : 999 | 33 | 0
BPmt : 2838 | 19550 | 0 |  |  |  | NJv : 999 | 0 | 19550 |  |  | BPmt : 2838 | 19550 | 0 |  |  |  | NJv : 999 |  | 19550 |  |  |  | NJv : 2596 | 0 | 652 |  | BPmt : 1302 | 8889 | 0
NJv : 2596 | 0 | 4348 |  |  |  | NJv : 999 | 33 | 0 |  |  | NJv : 2596 | 0 | 4348 |  |  |  | NJv : 999 | 33
NJv : 2596 | 0 | 652 |  |  |  | BPmt : 1302 | 8889 | 0 |  |  | NJv : 2596 | 0 | 652 |  |  |  | BPmt : 1302 | 8889
BPmt : 3139 | 0 | 17000 |  |  |  | NJv : 1265 | 17000 | 0 |  |  | BPmt : 3139 | 0 | 17000 |  |  |  | NJv : 1265 | 17000
NJv : 2779 | 0 | 2550 |  |  |  | NJv : 1265 | 2550 | 0 |  |  | NJv : 2779 | 0 | 2550 |  |  |  | NJv : 1265 | 2550
NJv : 2779 | 20000 | 0 |  |  |  | BPmt : 1533 | 0 | 20000 |  |  | NJv : 2779 | 20000 | 0 |  |  |  | BPmt : 1533 |  | 20000
BPmt : 3450 | 0 | 18000 |  |  |  | NJv : 1443 | 18000 | 0 |  |  | BPmt : 3450 | 0 | 18000 |  |  |  | NJv : 1443 | 18000
NJv : 3003 | 0 | 2550 |  |  |  | NJv : 1443 | 2550 | 0 |  |  | NJv : 3003 | 0 | 2550 |  |  |  | NJv : 1443 | 2550
NJv : 3003 | 14000 | 0 |  |  |  | BPmt : 1781 | 0 | 14000 |  |  | NJv : 3003 | 14000 | 0 |  |  |  | BPmt : 1781 |  | 14000
BPmt : 3606 | 0 | 17000 |  |  |  | NJv : 1615 | 17000 | 0 |  |  | BPmt : 3606 | 0 | 17000 |  |  |  | NJv : 1615 | 17000
NJv : 3218 | 0 | 2400 |  |  |  | NJv : 1615 | 2400 | 0 |  |  | NJv : 3218 | 0 | 2400 |  |  |  | NJv : 1615 | 2400
NJv : 3218 | 15000 | 0 |  |  |  | BPmt : 1922 | 0 | 15000 |  |  | NJv : 3218 | 15000 | 0 |  |  |  | BPmt : 1922 |  | 15000
Spreadsheet: 736832d1623894007-formula-to-add-percentages-from-the-next-positive-percentage-above-the-given-row-stock-short-term-comparison-7
Sheet: Sheet1

 |  |  | Override?
2021-06-15 11:15:00 |  |  |  | 1.390390890732007e-05 |  | 0.004814537883883641 | 0.004129608045853939 | 1.390390890732007e-05 | 4243.47
2021-06-15 11:30:00 |  |  |  | 8.695713649431447e-05 |  |  |  |  | 4243.839
2021-06-15 11:45:00 |  |  | Y | -0.0004404031349916071 |  |  |  |  | 4241.97
2021-06-15 12:00:00 |  |  | Y | -4.714790533644209e-05 |  |  |  |  | 4241.77
2021-06-15 12:15:00 |  |  |  | 0.0005846615917410869 |  |  |  |  | 4244.25
2021-06-15 12:30:00 |  |  |  | 0.0006055251222241154 |  |  |  |  | 4246.82
2021-06-15 12:45:00 |  |  |  | -0.0005135607348556448 |  |  |  |  | 4244.639
2021-06-15 13:00:00 |  |  |  | 0.0001041313525131926 |  |  |  |  | 4245.081
2021-06-15 13:15:00 |  |  |  | 1.625410681205253e-05 |  |  |  |  | 4245.15
2021-06-15 13:30:00 |  |  | Y | -0.0002923336042307545 |  |  |  |  | 4243.909
2021-06-15 13:45:00 |  |  |  | 0.0005162693168021537 |  |  |  |  | 4246.1
2021-06-15 14:00:00 |  |  |  | 0.0008172205082308537 |  |  |  |  | 4249.57
2021-06-15 14:15:00 |  |  |  | -0.0004988740037227268 |  |  |  |  | 4247.45
2021-06-15 14:30:00 |  |  |  | 0.0004023590624961937 |  |  |  |  | 4249.159
2021-06-15 14:45:00 |  |  | Y | -0.000143322478636243 |  |  |  |  | 4248.55
2021-06-15 15:00:00 |  |  |  | 0.0004377964246624622 |  |  |  |  | 4250.41
2021-06-15 15:15:00 |  |  |  | -0.0005011281264630796 |  |  |  |  | 4248.28
2021-06-15 15:30:00 |  |  |  | -0.0003271912397486698 |  |  |  |  | 4246.89
2021-06-15 15:45:00 |  |  |  | 0.0002802050441617077 |  |  |  |  | 4248.08
2021-06-15 16:00:00 |  |  |  | -0.000275418542023731 |  |  |  |  | 4246.91
Spreadsheet: 96760d1296059259-display-intersecting-cell-scratch
Sheet: Sheet1

 | Length
Diameter | 12 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2
0 | 3 | 2.5 | 2.25 | 2.05 | 1.85 | 1.7 | 1.1 | 0.96 | 0.81 | 0.72
0.0626 | 3.5 | 2.8 | 2.38 | 2.18 | 1.95 | 1.7 | 1.5 | 1.28 | 1.06 | 0.84
0.126 | 4.45 | 3.6 | 3.7 | 3.35 | 2.9 | 2.65 | 2.14 | 1.86 | 1.62 | 0.95
0.1876 | 6 | 5.6 | 4.95 | 4.42 | 3.95 | 3.5 | 3.05 | 2.5 | 2.16 | 1.35
0.251 | 11.9 | 11.5 | 9.5 | 7.95 | 6.25 | 5.5 | 4.9 | 4.05 | 3.2 | 2
0.376 | 13.4 | 13.2 | 11.05 | 9.1 | 7.36 | 6.35 | 5.55 | 4.6 | 3.55 | 2.5
0.376 | 14.9 | 14.3 | 12.7 | 10.48 | 8.35 | 7.25 | 6.14 | 5.15 | 3.96 | 2.7
0.501 | 16.9 | 16.4 | 14.24 | 12.1 | 10 | 8.4 | 7.15 | 5.72 | 4.6 | 4
0.631 | 18.4 | 17.7 | 15.5 | 13.4 | 11.25 | 9.85 | 8.3 | 6.75 | 5.5 | 5.2
0.751 | 20.2 | 18.35 | 16.5 | 14.7 | 12.77 | 11.32 | 9.87 | 8.4 | 6.7 | 6.15
0.876 | 22 | 19 | 17.5 | 16 | 14.3 | 12.8 | 11.45 | 10.05 | 7.9 | 7.1
1.001 | 27 | 24 | 22.9 | 20.85 | 17.95 | 15.95 | 14.2 | 12.4 | 11.4 | 11.3
1.251 | 42 | 37.2 | 35.8 | 30.1 | 28.25 | 23.8 | 18 | 16.74 | 14.85 | 13.7
1.501 | 64 | 56 | 48.5 | 42 | 37.5 | 30.25 | 24.2 | 20.38 | 18.6 | 18
2.001 | 101 | 96 | 85 | 72.9 | 64.25 | 58.7 | 45.6 | 38.4 | 29.5 | 23.2
2.501 | 125.6 | 112.4 | 105.35 | 92.1 | 84.75 | 73.75 | 64.15 | 58.25 | 47.6 | 32.4
Diameter | Length | Cost
0.65 | 3.8 | 6.75
Spreadsheet: 863962d1711356665-sumif-date-range-lookup-value-problem-sum-between-dates-with-lookup-problem
Sheet: Sheet1

Asset No | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00
1 | 11500 | 11500 | 11500 | 11500 | 11500 | 11500 | 11500 | 11500
2 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000
3 | 24000 | 24000 | 24000 | 24000 | 24000 | 24000 | 24000 | 24000
4 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500
5 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000
6 | 9450 | 9450 | 9450 | 9450 | 9450 | 9450 | 9450 | 9450
7 | 33000 | 33000 | 33000 | 33000 | 33000 | 33000 | 33000 | 33000
8 | 6500 | 6500 | 6500 | 6500 | 6500 | 6500 | 6500 | 6500
9 | 0 | 0 | 0 | 0 | 0 | 25000 | 25000 | 25000
10 | 0 | 0 | 0 | 0 | 0 | 3500 | 3500 | 3500
11 | 0 | 0 | 0 | 0 | 0 | 0 | 65000 | 65000
12 | 8800 | 8800 | 8800 | 8800 | 8800 | 0 | 0 | 0
Date Criteria
Date Begin | 2023-07-01 00:00:00
Date End | 2023-12-31 00:00:00
 |  | Sum Value
Lookup Value | 8
 | 9
 | 10
Spreadsheet: 674027d1587638949-time-between-duplicates-time-between-duplicates-etaf-4
Sheet: Sheet1

Branch | Date | Time | Amount | Processing Date | Name | Reference | Code | Duplicate | Time Between Duplicates - MAXIFS | NON MAXIFS - Older versions
Poole | 2020-01-10 00:00:00 | 01:00:00 | 725 | 2020-01-11 00:00:00 | [NAME] | 123 | AA01 |  | IF(I2="","",C2-MAXIFS($C$1:[NAME]:[NAME]:B1,B2,D$1:D1,D2,E$1:E1,E2,F$1:F1,F2,H$1:H1,H2)) | IF(I2="","",C2-MAX(IF((A$1:A1=A2)*(B$1:B1=B2)*(D$1:D1=D2)*(E$1:E1=E2)*(F$1:F1=F2)*(H$1:H1=H2),C$1:C1)))
Poole | 2020-01-10 00:00:00 | 07:04:00 | 324.84 | 2020-01-12 00:00:00 | [NAME] | 834 | AB09
Bournemouth | 2020-02-11 00:00:00 | 10:33:00 | 500 | 2020-01-12 00:00:00 | [NAME] | 176 | AB08
Poole | 2020-01-10 00:00:00 | 02:00:00 | 725 | 2020-01-11 00:00:00 | [NAME] | 124 | AA01
Bournemouth | 2020-01-10 00:00:00 | 06:20:00 | 70 | 2020-01-11 00:00:00 | [NAME] | 234 | AC11
Christchurch | 2020-01-10 00:00:00 | 09:54:00 | 190.83 | 2020-01-12 00:00:00 | [NAME] | 529 | BR87
Christchurch | 2020-02-11 00:00:00 | 12:31:00 | 201 | 2020-01-12 00:00:00 | [NAME] | 179 | BR90
Christchurch | 2020-01-10 00:00:00 | 19:43:00 | 398 | 2020-01-11 00:00:00 | [NAME] | 200 | AA03
Bournemouth | 2020-02-11 00:00:00 | 12:31:00 | 500 | 2020-01-12 00:00:00 | [NAME] | 176 | AB08
Poole | 2020-01-10 00:00:00 | 04:00:00 | 725 | 2020-01-11 00:00:00 | [NAME] | 125 | AA01
Spreadsheet: 828480d1683542840-pull-multiple-data-table-based-on-specific-value-test
Sheet: DB_WKs

Weeks
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: 493394d1481704969-assist-with-axis-setting-what-it-looks-like
Sheet: Data Sheet

 | ch31
 | MonthYear | [NAME] | %Uncontactable | %Diarized | %Taken Up | %Not Interested | %Disqualified | %Enquiry
 | 2016-11-01 00:00:00 | 632227 | 0.5845637721894194 | 0.1449337026099803 | 0.0970173687615366 | 0.08732148421373968 | 0.04694832710403067 | 0.006018407945247514
 | 2016-12-01 00:00:00 | 195519 | 0.5857793871695334 | 0.1418174192789448 | 0.09341803098420103 | 0.09535646152036376 | 0.05425559664278152 | 0.005805062423600776
 | ch34
 | MonthYear | CallCentre | %Taken Up
 | 2016-11-01 00:00:00 | Acquisitions | 0.07105221309302942
 | 2016-11-01 00:00:00 | Business Banking | 0.1445598382937199
 | 2016-11-01 00:00:00 | Cash Investments | 0.08711061369147548
 | 2016-11-01 00:00:00 | Hunters | 0.04811774316669122
 | 2016-11-01 00:00:00 | Supersize | 0.1483965968586387
 | 2016-11-01 00:00:00 | Vault | 0.1080706210676716
 | 2016-11-01 00:00:00 | Winers & Diners | 0.1195152052870151
 | 2016-12-01 00:00:00 | Acquisitions | 0.06582216467788782
 | 2016-12-01 00:00:00 | Business Banking | 0.1357608451337379
 | 2016-12-01 00:00:00 | Cash Investments | 0.083008356545961
 | 2016-12-01 00:00:00 | Hunters | 0.04248970717490864
 | 2016-12-01 00:00:00 | Supersize | 0.1498390013673856
 | 2016-12-01 00:00:00 | Vault | 0.13208885844302
 | 2016-12-01 00:00:00 | Winers & Diners | 0.09137780745191862
Spreadsheet: 764124d1642599206-formula-needed-to-aggregate-data-book2
Sheet: Sheet1

 | 21/22 |  |  |  |  |  |  |  |  |  |  |  | 22/23 |  |  |  |  |  |  |  |  |  |  |  | 23/24
 | 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 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00
Apples | 1 | 2 | 10 | 9 | 6 | 10 | 10 | 8 | 6 | 9 | 5 | 8 | 6 | 8 | 2 | 6 | 6 | 3 | 8 | 6 | 1 | 8 | 10 | 6 | 6 | 3 | 5 | 1 | 6 | 1 | 10 | 3 | 9 | 5 | 4 | 4
Oranges | 2 | 10 | 3 | 10 | 7 | 4 | 4 | 9 | 6 | 6 | 1 | 5 | 6 | 10 | 3 | 10 | 6 | 10 | 4 | 9 | 6 | 7 | 2 | 7 | 9 | 8 | 5 | 6 | 8 | 10 | 5 | 7 | 10 | 10 | 1 | 6
Bananas | 10 | 4 | 7 | 6 | 2 | 5 | 8 | 3 | 1 | 7 | 7 | 5 | 9 | 4 | 3 | 7 | 6 | 9 | 4 | 2 | 4 | 4 | 9 | 10 | 2 | 2 | 5 | 1 | 1 | 6 | 2 | 2 | 6 | 9 | 1 | 6
 | 21/22 | 22/23 | 23/24 |  |  | Expected values
Apples |  |  |  |  | 84 | 70 | 57
Oranges |  |  |  |  | 67 | 80 | 85
Bananas |  |  |  |  | 65 | 71 | 43
Spreadsheet: 774440d1648476580-vba-dynamic-list-from-same-column-on-multiple-sheets-forrick
Sheet: MasterList

 | Master List
 | v1124
 | v1125
 | v1126
 | v1127
 | v1128
 | v1129
 | v1130
 | v1131
 | v1132
 | v1133
 | v1134
 | v1135
 | v1136
 | v1137
 | v1138
 | v1139
 | v1140
 | v1141
 | v2123
 | v2124
 | v2125
 | v2126
 | v2127
 | v2128
 | v2129
 | v2130
 | v2131
 | v2132
 | v2133
 | v2134
 | v2135
 | v2136
 | v2137
 | v2138
 | v2139
 | v2140
 | v2141
 | v3123
 | v3124
 | v3125
 | v3126
 | v3127
 | [NAME]
 | v3129
 | v3130
 | v3131
 | [NAME]
 | v3133
 | v3134
 | v3135
 | v3136
 | v3137
 | v3138
 | v3139
 | v3140
 | v3141
Spreadsheet: 0353f169-2d51-42f6-80fb-40ba6b89d02d
Sheet: Sheet1

DRGR QPR Review Guidance | Unnamed: 1
(1) | Log in to DRGR and click on the QPR tab in the navigation bar on the top of the page.  Find the grant you want and click [NAME] in the far right column in that row.  Under the action column, click on “Review” for the most recently submitted QPR.
(2) | There are three ways to look at a Quarterly Performance Report (QPR) in the Disaster Recovery Grant Reporting System (DRGR): (1) View – official “submitted” version with calculated fields; (2) Download – PDF file of official submitted version; (3) Review – to record your comments and change the status.
(3) | QPRs cannot be reviewed unless the QPR is in Submitted status. Grantees cannot submit QPRs unless the Action Plan is in Approved status when they try to submit the QPR.
(4) | If the QPR is missing required information, reject the QPR and send an email to the grantee requesting a correction within 10 days.
(5) | If the QPR review raises questions, note them in the comments field (with your initials) and discuss with the grantee before the next QPR is due.
(6) | If the review reveals that the Action Plan needs updating, you may accept the QPR with a note to the comment field, or you may reject the QPR and require the plan corrections prior to resubmission of the QPR.
(7) | If there is one late QPR, notify grantee.  If there is more than one late QPR or if any QPRs are missing, notify [NAME] to discuss options, including issuance of a finding of noncompliance.
(8) | After completion, save all of your comments and, using the pulldown menu, change the status of the QPR from Submitted-Await for Review to either Approved and Reviewed or Rejected – Await for Modification.  Remember to save after changing the status.
 | (a)  Rejected – Await for Modification unlocks the QPR so the grantee can edit it and make corrections.
 | (b)  Reviewed and Approved leaves the QPR locked and stored as the report of record.
(9) | Approved QPRs must be posted on grantee’s website 3 days after submission.
Spreadsheet: 376802d1423712381-sumif-for-multiple-criteria-criteria-ranges-and-sum-ranges-sample-book
Sheet: Summary

1891300002 | x |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
1891300003 | y |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
1891300004 | w
1891300005 | w
1891300006 | w
1891300007 | x
1891300008 | x
1891300009 | w
1891300010 | x
1891300011 | y
1891300012 | x
1891300013 | x
1891300014 | x
1891300015 | x
1891300016 | w
1891300017 | y
1891300018 | y
1891300019 | x
1891300020 | w
1891300021 | x
1891300022 | x
1891300023 | x
1891300024 | x
1891300025 | x
1891300026 | w
1891300027 | x
1891300028 | x
1891300029 | x
1891300030 | x
1891300031 | x
1891300032 | x
1891300033 | x
1891300034 | y
1891300035 | x
1891300036 | x
1891300037 | w
1891300038 | w
1891300039 | w
1891300040 | w
1891300041 | x
1891300042 | x
1891300043 | x
1891300044 | x
1891300045 | x
1891300046 | x
1891300047 | x
1891300048 | y
1891300049 | x
1891300050 | x
1891300051 | x
1891300052 | x
1891300053 | x
1891300054 | x
1891300055 | w
1891300056 | y
1891300057 | y
1891300058 | x
1891300059 | x
1891300060 | x
1891300061 | x
1891300062 | x
1891300063 | x
1891300064 | x
1891300065 | x
1891300066 | x
1891300067 | x
1891300068 | w
1891300069 | x
1891300070 | x
1891300071 | x
1891300072 | x
1891300073 | x
1891300074 | x
1891300075 | x
1891300076 | y
1891300077 | w
1891300078 | w
1891300079 | w
1891300080 | x
1891300081 | x
1891300082 | y
1891300084 | y
1891300085 | y
1891300086 | w
1891300087 | x
1891300088 | x
1891300089 | x
1891300090 | x
1891300091 | x
1891300092 | x
1891300093 | x
1891300094 | x
1891300095 | x
1891300096 | z
1891300097 | w
1891300098 | x
1891300099 | x
1891300100 | x
1891300101 | x
1891300102 | x
1891300103 | x
1891300104 | x
1891300105 | x
1891300106 | y
1891300107 | w
1891300108 | x
1891300109 | x
1891300110 | x
1891300111 | x
1891300112 | y
1891300113 | w
1891300114 | x
1891300115 | x
1891300116 | x
1891300117 | x
1891300118 | x
1891300119 | x
1891300120 | x
1891300121 | x
1891300122 | x
1891300123 | y
1891300124 | y
1891300125 | w
1891300126 | w
1891300127 | w
1891300128 | x
1891300129 | x
1891300130 | x
1891300131 | x
1891300132 | x
1891300133 | z
1891300134 | x
1891300135 | y
1891300136 | w
1891300137 | x
1891300138 | x
1891300139 | x
1891300140 | x
1891300141 | x
1891300142 | x
1891300143 | y
1891300144 | x
1891300145 | x
1891300146 | x
1891300147 | x
1891300148 | x
1891300149 | x
1891300150 | x
1891300151 | x
1891300152 | y
1891300153 | x
1891300154 | x
1891300155 | x
1891300156 | x
1891300157 | x
1891300158 | x
1891300159 | x
1891300160 | y
1891300161 | x
1891300162 | y
1891300163 | x
1891300164 | x
1891300165 | x
1891300166 | x
1891300167 | x
1891300168 | x
1891300169 | x
1891300170 | x
1891300171 | x
1891300172 | x
1891300173 | x
Spreadsheet: 887743d1738069720-check-list-for-advanced-doubles-check-list-for-advanced-doubles-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | An item nr can appear in multiple Pos nr, that's normal.
 |  |  |  |  |  |  |  |  |  |  | A code can appear in multiple items. It is not desired but it's not a problem.
 |  |  |  |  |  |  |  |  |  |  | The problem is when two identical item have different code.
 |  |  |  |  |  |  |  |  |  |  | I need to indicate or make a list of the rows where or item no's that are the same but have different code.
 |  | Pos | Item | Code | Desired output | zbor
 |  | H1 | 1 | A | Ok
 |  | H2 | 2 | B | H2, H5, H9
 |  | H3 | 4 | D | Ok
 |  | H4 | 4 | D | Ok
 |  | H5 | 2 | A | H2, H5, H9
 |  | H6 | 6 | F | H6, H10
 |  | H7 | 7 | G | Ok
 |  | H8 | 8 | H | Ok
 |  | H9 | 2 | B | Ok
 |  | H10 | 6 | J | H6, H10
 |  | H11 | 4 | D | Ok
Spreadsheet: 073e55c4-b8f2-4ca8-b314-f0a200a5de13
Sheet: Sheet1

Your Name Here database instructions
For the 5200 Your Name Here Appointment Calendar:
For the 5210 Your Name Here Desk Calendar:
1.) Save this database with your own naming convention to a location that is convenient for you.
2.) Choose the tab labelled [NAME] if you want your order packed bulk.
Choose the tab labelled Individual Mail if you want your order individually mailed (extra charges apply)
3.) You will need to supply the following information for all names:
* First Name
* Last name
* The Full Name field is automatically populated
* Company Name (only needed if your order utilizes the City Theme)
4.) If you are requesting your calendars to be individually mailed, you will also need to supply:
* Address
* City
* State
* Zip
* Country (if other than USA)
5.) Your ad copy and any artwork that is to be printed in the imprint area must be supplied.
6.) Send us your database, order and adcopy/artwork.
Additional Information
Double-check all submitted names. [NAME] is not responsible for errors in names or addresses supplied and will not make chnages to the submitted database. We do not recommend copying from an existing spreadsheet as the character limit notice will not alert you if there is an issue.
Type First & Last Names in upper/lower case so the software works correctly
Do not include any special characters (example: &, #, @) in the First and Last Names
Type the Company Name exactly as you want it to appear - either upper/lower or all CAPS.
- We suggest no more that 20 characters to ensure the company name is readable.
Spreadsheet: 477257d1472208512-index-match-problem-match
Sheet: Sheet1

Venue1 |  |  |  | Item |  | Sales
1 | 0.12 |  |  | 1
2 | 0.14 |  |  | 8
3 | 0.13 |  |  | 7
4 | 0.11 |  |  | 6
5 | 0.1
6 | 0.11
7 | 0.12
8 | 0.17
Venue2
1 | 0.16
2 | 0.09
3 | 0.1
4 | 0.12
5 | 0.15
6 | 0.14
7 | 0.12
8 | 0.11