tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 841067d1693319409-total-subscriptions-to-show-in-bands-template-price-break-points
Sheet: Sheet2

 | OSM | Table | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 10000 | 12000 | 14000 | 16000 | 18000 | 25000 | Total Sub | Total Subscription |  |  | Price grid - Decreasing fee based on fixed volumes bands
 | 2024 | 500 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | From | To
 | 2024 | Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1000 |  | 15 | 1000
 | 2025 | 1500 | 1000 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1001 | 2000 |  | 14 | 2000
 | 2025 | Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001 | 3000 |  | 13 | 3000
 | 2026 | 3250 | 1000 | 999 | 999 | 252 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 3001 | 4000 |  | 12 | 4000
 | 2026 | Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4001 | 5000 |  | 11 | 5000
 | 2027 | 5500 | 1000 | 999 | 999 | 999 | 999 | 504 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 5001 | 6000 |  | 10 | 6000
 | 2027 | Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6001 | 10000 |  | 9 | 10000
 | 2028 | 8750 | 1000 | 999 | 999 | 999 | 999 | 3754 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 10001 | 12000 |  | 8 | 12000
 | 2028 | Revenue |  |  |  |  |  |  |  |  |  |  |  |  | 525535 |  |  |  | 12001 | 14000 |  | 7 | 14000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14001 | 16000 |  | 6 | 16000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16001 | 18000 |  | 5 | 18000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18001 | 25000 |  | 4 | 25000
 |  | Table | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 10000 | 12000 | 14000 | 16000 | 18000 | 25000 | Total Sub | Total Subscription
 | 2024 |  | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2025 |  | 1000 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2026 |  | 1000 | 999 | 999 | 252 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2027 |  | 1000 | 999 | 999 | 999 | 999 | 504 | 0 | 0 | 0 | 0 | 0 | 0
 | 2028 |  | 1000 | 999 | 999 | 999 | 999 | 3754 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 74155d1274735051-comparing-data-in-two-different-arrangements-example
Sheet: In an array

 | 001 | 043 | 117 | 121 | 122 | 135 | 136 | 143 | 148 | 151 | 152 | 153 | 154 | 168 | 169 | 181 | 202 | 208 | [NAME] | 241 | 242
AL | 0 | 0 | 9484 | 0 | 0 | 14 | 2271 | 0 | 0 | 37 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48713 | 0 | 0
AR | 0 | 0 | 3771 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26201 | 0 | 0
AZ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CO | 0 | 0 | 19242 | 0 | 0 | 0 | 30252 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DC | 0 | 0 | 9733 | 100 | 100 | 100 | 100 | 100 | 0 | 0 | 100 | 100 | 100 | 0 | 100 | 0 | 100 | 100 | 100 | 100 | 100
DE | 0 | 0 | 24928 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 898 | 0 | 0 | 0 | 0 | 0
FL | 0 | 0 | 55914 | 0 | 0 | 894 | 7003 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1159 | 435 | 0 | 0 | 0 | 0
GA | 0 | 0 | 43553 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HI | 0 | 0 | 814 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
IA | 0 | 0 | 5362 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 99829 | 0 | 0
ID | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LA | 0 | 0 | 66883 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MA | 0 | 0 | 0 | 0 | 0 | 0 | 11568 | 0 | 3694 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 243386 | 0 | 0
MD | 0 | 0 | 42305 | 0 | 0 | 0 | 4094 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 0 | 0
MO | 0 | 0 | 8137 | 0 | 0 | 0 | 3819 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1807 | 0 | 0 | 0 | 0 | 0
MS | 0 | 0 | 3277 | 0 | 0 | 133 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 832775d1686583685-maximum-occurences-of-text-maxtext
Sheet: Sheet1

 | 2023-06-01 00:00:00 | 2023-06-02 00:00:00 | 2023-06-03 00:00:00 | 2023-06-04 00:00:00 | 2023-06-05 00:00:00 | 2023-06-06 00:00:00 | 2023-06-07 00:00:00 | 2023-06-08 00:00:00 | 2023-06-09 00:00:00 | 2023-06-10 00:00:00 | 2023-06-11 00:00:00 | [NAME] | Want to Return
1AM | --- | WNW | N | NNE | NNW | NW | NW | N | --- | --- | NW |  | NW
2AM | --- | W | NNE | N | NW | --- | --- | W | N | --- | NNW |  | W
3AM | NW | WNW | --- | --- | N | NW | WNW | --- | --- | N | --- |  | NW
4am | --- | N | N | NW | WNW | NE | NNE | --- | NE | N | N |  | N
 |  | [NAME] in column M:
 |  | =[INDEX($B3:$L3,MATCH(MAX(COUNTIF($B3:$L3,$B3:$L3)),COUNTIF($B3:$L3,$B3:$L3),0))]
On each row are wind speed directions.  When the wind is calm it returns (---).  The formula counts
the maximum occurrences of each row including text and the 3 dashes (column M). I am looking for it to just find the
maximum occurences  of just the text, not the 3 dashes (column N)
Spreadsheet: 787098d1657633197-sum-the-expenses-by-month-groups-of-contractors-samplesheet
Sheet: Monthly expenses

Month: | 01, 2019 | 02, 2019 | 03, 2019 | 04, 2019 | 05, 2019 | 06, 2019 | 07, 2019 | 08, 2019 | 09, 2019 | 10, 2019 | 11, 2019 | 12, 2019
Backend
Support
Other
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: McCullough

Hour
Ending |  |  |  |  |  |  |  | hourly non-firm
Pacific | Mona physical | PNM |  |  | APS(t)t | PAC | PAC | PAC(t) | Balance
Standard | position | Purchase |  |  | from Mead | Sale | Sale | [NAME]/RB
(PST)
100 | 0
200 | 0
300 | 0
400 | 0
500 | 0
600 | 0
700 | 0
800 | 0
900 | 0
1000 | 0
1100 | 0
1200 | 0
1300 | 0
1400 | 0
1500 | 0
1600 | 0
1700 | 0
1800 | 0
1900 | 0
2000 | 0
2100 | 0
2200 | 0
2300 | 0
2400 | 0
Spreadsheet: 813686d1673927141-finding-name-matches-and-adding-their-number-totals-gdkp-raffle-sheet-sample
Sheet: Sheet1

Zzyxk's 50/50 GDKP Raffle |  |  |  |  |  |  |  |  |  |  |  | Top Contributors |  |  |  |  |  |  |  | All Contributors |  |  |  |  | Every Contribution
 |  |  |  |  |  | Total
Name | # of tickets | current total | roll needed to win |  |  |  |  |  |  |  |  | Rank | Name |  |  | Total  Tickets |  |  |  | Name | Total  Tickets |  |  |  | Name | Tickets
A | 5 |  | 1 | to |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | A | 15 |  |  |  | A | 10
B | 1 |  |  | to |  | GDKP Cut |  |  |  |  |  | 2 |  |  |  |  |  |  |  | B | 13 |  |  |  | B | 12
C | 10 |  |  | to |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | F | 16 |  |  |  | F | 6
D | 12 |  |  | to |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | Q | 20 |  |  |  | Q | 20
E | 7 |  |  | to |  | Winner Cut |  |  |  |  |  | 5 |  |  |  |  |  |  |  | R | 14 |  |  |  | R | 14
F | 3 |  |  | to |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  | S | 4 |  |  |  | S | 4
G | 17 |  |  | to |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | U | 7 |  |  |  | U | 7
H | 3 |  |  | to |  | Roll |  |  |  |  |  | 8 |  |  |  |  |  |  |  | V | 11 |  |  |  | V | 11
 |  |  |  | to |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | W | 10 |  |  |  | W | 10
 |  |  |  | to |  | 10 |  |  |  |  |  | 10 |  |  |  |  |  |  |  | X | 8 |  |  |  | X | 8
 |  |  |  | to |  | Winner |  |  |  |  |  | Current Leader |  |  |  |  |  |  |  | C | 14 |  |  |  | C | 4
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 21 |  |  |  | E | 3
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 10 |  |  |  | D | 9
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 31 |  |  |  | F | 7
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 14 |  |  |  | G | 14
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 11
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 5
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 1
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 10
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 12
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 7
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 3
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 17
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 3
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
Spreadsheet: 110551d1307156934-look-up-info-from-multiple-columns-example
Sheet: Sheet1

 | Table 1 |  |  | Look up F3 and retrieve Data
 | 100 | 410 |  | Look Up | 211
 | 105 | 413
 | 106 | 416 |  | Tbl 1 Data | 412
 | 120 | 411 |  | Tbl 2 Data
 | 123 | 411
 | 130 | 413 |  | Note:  The look up data is not always a number by itself; sometimes it has letters or symbols behind it, which explains why the formula is not just a simple [NAME].
 | 133
 | 200 | 410
 | 201 | 411
 | 202 | 413 |  | Table 2
 | 203 | 419 |  | 100 | 410 | 222 | 412 | 305 | 412
 | 211 | 412 |  | 105 | 413 | 231 | 412 | 321 | 412
 | 212 | 412 |  | 106 | 416 | 232 | 412 | 322 | 417
 | 213 | 412 |  | 120 | 411 | 241 | 412 | 324 | 415
 | 220 | 410 |  | 123 | 411 | 242 | 412 | 336 | 411
 | 221 | 412 |  | 130 | 413 | 243 | 412 | 428 | 412
 | 222 | 412 |  | 133 |  | 244 |  | 431 | 410
 | 231 | 412 |  | 200 | 410 | 250 | 410 | 432 | 411
 | 232 | 412 |  | 201 | 411 | 251 | 412 | ASP | 415
 | 241 | 412 |  | 202 | 413 | 252 | 412 | CA2 | 420
 | 242 | 412 |  | 203 | 419 | 268 | 411 | LT2 | 415
 | 243 | 412 |  | 211 | 412 | 300 | 410 | PUH | 419
 | 244 |  |  | 212 | 412 | 301 | 412 | ta1 | 420
 | 250 | 410 |  | 213 | 412 | 302 | 419 | TA2 | 420
 | 251 | 412 |  | 220 | 410 | 303 | 412 | TFX
 | 252 | 412 |  | 221 | 412 | 304 | 412 | WSHR | 413
 | 268 | 411
 | 300 | 410
 | 301 | 412
 | 302 | 419
 | 303 | 412
 | 304 | 412
 | 305 | 412
 | 321 | 412
 | 322 | 417
 | 324 | 415
 | 336 | 411
 | 428 | 412
 | 431 | 410
 | 432 | 411
 | ASP | 415
 | CA2 | 420
 | LT2 | 415
 | PUH | 419
 | ta1 | 420
 | TA2 | 420
 | TFX
 | WSHR | 413
Spreadsheet: 884851d1734115003-index-match-or-book1-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Persons
 |  |  |  |  |  |  | Percentage | Bedroom Count | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  | 0.3 | 0 | 673.75 | 792.5 | 911.25 |  |  |  |  |  | Percentage | 0.3
 |  |  |  |  |  |  | 0.3 | 1 | 655.75 | 774.5 | 893.25 |  |  |  |  |  | Bed Count | 3
 |  |  |  |  |  |  | 0.3 | 2 |  | 734.5 | 853.25 | 970.75 | 1065.75 |  |  |  | Person | 3
 |  |  |  |  |  |  | 0.3 | 3 |  |  | 815.25 | 932.75 | 1027.75 | 1122.75
 |  |  |  |  |  |  | 0.5 | 0 | 1226.25 | 1423.75 | 1621.25 |  |  |  |  |  | Dollar Amount
 |  |  |  |  |  |  | 0.5 | 1 | 1208.25 | 1405.75 | 1603.25
 |  |  |  |  |  |  | 0.5 | 2 |  | 1365.75 | 1563.25 | 1759.5 | 1918.25
 |  |  |  |  |  |  | 0.5 | 3 |  |  | 1525.25 | 1721.5 | 1880.25 | 2037.75
 |  |  |  |  |  |  | 0.8 | 0 | 1502.5 | 1738.75 | 1976.25
 |  |  |  |  |  |  | 0.8 | 1 | 1484.5 | 1720.75 | 1958.25
 |  |  |  |  |  |  | 0.8 | 2 |  | 1680.75 | 1958.25 | 2154 | 2344.5
 |  |  |  |  |  |  | 0.8 | 3 |  |  | 1880.25 | 2116 | 2306.5 | 2495.25
 |  |  |  |  |  |  | 1 | 0 | 2055 | 2370 | 2686.25
 |  |  |  |  |  |  | 1 | 1 | 2037 | 2352 | 2668.25
 |  |  |  |  |  |  | 1 | 2 |  | 2312 | 2628.25 | 2943.25 | 3195.75
 |  |  |  |  |  |  | 1 | 3 |  |  | 2590.25 | 2905.25 | 3157.75 | 3410.25
Spreadsheet: 102947d1300820363-excel-formula-just-in-time-system-book1_drakaz
Sheet: Sheet1

 |  |  | Paddington
 |  |  | Dr | Cr | Balance
Opening stock |  |  | 100
Date | Invoice No. | Account
2011-04-01 00:00:00 | 181532 | Myrt | 40 |  | 140
2011-04-02 00:00:00 | 52665 | Mood |  | 130 | 10
2011-04-11 00:00:00 | 154564sa | Ridd | 10 |  | 20
2011-04-12 00:00:00 | 51dsa | Myrt |  | 30 | -10
2011-04-13 00:00:00 | ef55e | Snap |  | 100 | -110
Spreadsheet: 586881d1534706474-basketball-table-and-best-second-places-womens-eb-qualifier-tables
Sheet: GroupH

GROUP H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS | rank
Team name | Bonus/penalty points
Macedonia
Italy
Croatia
Sweden
ROUND 1 |  |  |  |  |  |  | Table
 |  | 52 | : | 61
 |  | 71 | : | 83 |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS
 |  |  | :
 |  |  | :
 |  | 63 | : | 55
 |  |  | :
ROUND 2
 |  | 93 | : | 33
 |  |  | :
 |  | 91 | : | 51
 |  | 47 | : | 108
 |  | 54 | : | 57
 |  | 47 | : | 69
ROUND 3
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
ROUND 4
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
Spreadsheet: randall_gay__31452__32614_2
Sheet: Turbine Capitals

 |  |  |  |  |  |  | List Total: |  |  |  | List Total: | Credit Total
GT Turbine Capitals
LINE | CATALOG | CAT |  |  |  |  |  |  | SIMILAR-TO | UNIT
ITEM | NUMBER | LOC | PART NAME | PART DESCRIPTION | CYC | QTY | SYS PRICE | UM | DWG NUMBER | PRICE | LINE PRICE
 | ____________
1 | G0705L1 |  | KIT | CASE ARR, TURB, SHROUD KIT - STG1 | 15 | 1 | 182902 |  | 339A9964G002 | 182902
2 | G0705LA |  | KIT | CASE ARR, TURB, SHROUD KIT - STG2 | 19 | 1 | 137414 |  | 339A9965G005 | 137414
3 | G0705LG |  | KIT | CASE ARR, TURB, SHROUD KIT - STG3 | 37 | 1 | 74762 |  | 339A9966G005 | 74762
4 | G13014X | UA40 | KIT | CMPRSR STATR, VANE ARR, KIT -BLADES | 29 | 1 | 892751 |  | 106L1708G002 | 892751
5 | G13014Z | TB02 | KIT | CMPRSR STATR, VANE SET, IGV, KIT | 37 | 1 | 207783 |  | 317A9589G004 | 207783
6 | G13032S |  | KIT | CMPRSSR RTR, BLADE KIT | 19 | 1 | 811394 |  | 106L1709G001 | 811394
7 | [NAME] |  | KIT | ROTOR, TRBN, [NAME] STG | 21 | 1 | 910540 |  | 314B7165G020 | 910540
8 | G13052M |  | KIT | ROTOR, TRBN, [NAME] STG | 33 | 1 | 901965 |  | 314B7166G023 | 901965
9 | G13052P |  | KIT | ROTOR, TRBN, [NAME] STG | 13 | 1 | 791255 |  | 314B7167G019 | 791255
10 | G140100 |  | NOZZLE-ASM | NOZZ 1ST-STG, ASSEMBLY | 17 | 1 | 899488 |  | 109E3735G018 | 899488
11 | G140200 |  | NOZZLE-ASM | NOZZ 2ND STG, ASSEMBLY | 29 | 1 | 926971 |  | 116E1417G001 | 926971
12 | G140300 |  | RING-ASM | SPPRT RNG, 1ST-STG ASSEMBLY | 24 | 1 | 36558.9 |  | 227C5682G005 | 36558.9
13 | G140900 |  | NOZZLE-ASM | NOZZLE 3RD STG, ASSEMBLY | 25 | 1 | 986568 |  | 112E6649G001 | 986568
Spreadsheet: 4d51a705-dfb3-469b-a578-b62d61d537e9
Sheet: Sheet1

Sight loss data tool
Published: v1.1 - November 2013
This knowledge base provides a range of data related to sight loss for England and constituent regions,
counties, London boroughs and unitary authorities.
-
Using this resource
Each row in the "Data" worksheet represents a region, county, London borough or unitary authority in England.
Each column has a different indicator linked to sight loss. These are grouped into broad categories:
certification and registration, living with sight loss, high risk, sight threatening eye conditions and support
Further details on how each indicator has been calculated can be found in the "Evidence sources" worksheet.
-
Further information
If you have any questions about the information contained in this spreadsheet, please contact RNIB Evidence and Service Impact
at [EMAIL] or telephone [PHONE].
-
The UK Vision Strategy has launched a JSNA template to enable Health and Wellbeing Boards to better understand the
eye health needs of their local populations and support effective commissioning of services. For more information please visit
http://www.commissioningforeyecare.org.uk/
-
Notes
1. Most of the data presented here are best estimates. The information has been modelled to each local area
using estimates for how common sight loss is and for some eye conditions. In most cases, at least
gender and age have been factored into these calculations. However, the modelling does not take into
account a number of factors that may influence the results for each area. For example: BME communities;
local good practice on the eye care pathway, deprivation and so on.
2. Where applicable, definitions for each indicator are given in the "Evidence sources" worksheet.
In addition, a summary of the type of data used is also given - either official statistic or RNIB estimate.
3. Table conventions:
numerical values are too small = -
no data available = x
4. This is the first phase of this JSNA knowledge hub. Additional work will be undertaken in 2013 to add in more
geographical areas, improve reporting tools and add in additional indicators.
-
Evidence and Service Impact, RNIB
Updated: January 2013
Spreadsheet: 218329d1362429142-lookup-a-value-and-display-all-data-multiple-rows-and-columns-fruits1
Sheet: Data

Fruit | Colors | Purchased | Cost per 1/1/13 | Total | Purchased | Cost per 1/2/13 | Total | Purchased | Cost per 1/2/13 | Total
Apple | Green | 5 | 0.4 | 2 | 5 | 0.4 | 2 | 5 | 0.4 | 2
Apple | Yellow | 21 | 0.5 | 10.5 | 21 | 0.5 | 10.5 | 21 | 0.5 | 10.5
Apple | Red | 25 | 0.3 | 7.5 | 21 | 0.3 | 6.3 |  | 0.3 | 0
Apple | Blue |  | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
Apple | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 |  | 0.39 | 0
[NAME] | red | 22 | 0.25 | 5.5 |  | 0.25 | 0 |  | 0.25 | 0
[NAME] | Yellow | 8 | 0.29 | 2.32 |  | 0.29 | 0 | 21 | 0.29 | 6.09
[NAME] | Blue |  | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
[NAME] | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 |  | 0.39 | 0
Spreadsheet: b29e7c0d-8c92-4de6-9a99-bc577ad2e7f3
Sheet: S15

Table S15. List of primers used in the present study.
Region | Primer | Forward Primer [NAME] (5'-3') | Reverse Primer [NAME] (5'-3') | Product size (bp)
Exon | s.E2 | TGTGGGCTTGGAATGTGTGA | CCAGTTGAGAAGTACAGGACAG | 343
 | s.E3,4 | GCTGTAGCTTTGAGTATCTATTGTG | CATCCCAGACGACGAACAGT | 443
 | s.E5 | ACTAAGGATTGTACTTGAAGAAGTT | GACCTGTTGGAATATGGTATAGAAG | 291
 | s.E6 | ACTGCCCAAAAGCTATCAACTC | AAAAAGCACACAATACTTGCTGAA | 443
 | s.E7 | GCAATATCAGTAATGAGGTACTCAA | TGCTGAAAAGAAATTTGCTGTG | 463
 | s.E8 | TCCAAAATAACTGCAAAGGATGG | ACCCGGCTGGAAGTAAACA | 262
 | s.E9 | TTCAGTAAGACTTTTGCTCTAACA | GGATGTGATTTTGGTTGGTTTT | 611
Intron | s.SNP.1 | CTCTGTTCCTTCAGCAGTATATGT | TGGAGGTTGAGGACGCTG | 260
 | s.SNP.3 | ACACACACACATTGCTGCC | TGCCTCTGCTATCACCAGTTA | 181
 | s.SNP.4 | GGTTTGTTTGATTTTGCATTTTGTG | ATGATGATTGTTGTGACCTATGGA | 150
 | [NAME] | AAAAACCTTTCTAGCCCTGTAG | GGCAGTGGCATGGATATTC | 228
 | s.SNP.6 | ATTGAAAGTGCCCACCCTG | GTACTTGTGTAAGCAGTTCACT | 204
 | s.SNP.9 | AGAAAACTCTGAGAACCCCTT | AATCCCCTGAAACTGTAGGCT | 405
 | s.SNP.11 | GGTTTGGAGGTAAAGTGTCTTGT | GGGAATAAATGCCTAGAGGGG | 309
 | s.SNP.12 | TTTTCTAAAGGACCACCTGTTGT | GCACTGGCACCATAATCACC | 332
 | s.SNP.13 | AACAAGCAACATGACCAAAGG | GGTAACTAAAGACCTTGAAATGAGT | 465
 | s.SNP.15 | TTTGTCTATTTTGTTCACTGCCTT | AAAGGTGATACGACTTCCTTACT | 453
 | s.SNP.17 | CATGAGGTTTCTCCAGTATGGG | TCGAAGTCAGAACTAGAATTTGGG | 458
 | s.SNP.21 | TGGTGAGGACAGATAGGAGAT | TGTCTCTTCATATTTTAGTTCGGTG | 332
 | s.SNP.23 | AACGCAAAAGAACCAATCCAAA | TCAGACTTTACCACAGTTCATAGA | 331
 | s.SNP.24 | CAAGATCACTGGAGTTTGTGAG | GTGAGCACCCATTGTTTTCC | 265
5'flanking | P1 | GAAAGGGGACACAGAGTTAGT | TTCTTCATTCATCAGTCGGAATATC | 679
 | P2 | AAGAGAAAGAATCAGAAACTGGGTA | CTTTTGTAATGTGAGCAGCAGC | 688
 | P3 | ATACACCACCCTTTCCCAACTC | CCTCAGTCTCCTCTCCTCCC | 519
 | P4 | GCACTGGATTACATCACGGACT | AGATTTGCTTCACACACATTCTTCA | 692
 | P5 | CTTGGATGTTTACAAGGGTGTTC | TATGGTGTGATTGTGAGGCTGT | 686
 | P6 | CTGGAACTCTGCTTGTTGAGA | CATGATTTGAGCCCTAGCACTG | 769
 | P7 | CAGAACTGTGTAGCAGAAAGGT | CTCTAAGGGCAGATTAAGGCAG | 657
 | P8 | TGGAGAGAGATGGGAAGCAGTT | CAGAAGCGTAAGTAAAAGTGAGCC | 627
 | P9 | GCTGCTGCTACCACATACAGAT | CCTTCGGGAAACTCCGATGA | 696
 | Plong | TGAAAGAAAGGGGACACAGAGTT | ACCAGTTGAGAAGTACAGGACAG | 5439
 |  |  | Total | 12668 bp targetted
 | REPRO | CTGCAAAGCAAAGGAACCAT | CACCTGTATTTGGGTTGTGG | Primer used for Micro satellite (STR) studied in promoter region
Spreadsheet: 765715d1643533844-how-to-define-indirect-range-for-index-excel-example-index
Sheet: Daten

DateTime | [NAME] of Materials Manager-avl | [NAME] of Materials Manager-cur | Documents-avl | Documents-cur | Drafting-avl | Drafting-cur | Model Manager-avl | Model Manager-cur | Model Manager Plus / Word Excel Int. / Naming Catalog-avl | Model Manager Plus / Word Excel Int. / Naming Catalog-cur | Model Manager Task Agent-avl | Model Manager Task Agent-cur | Modeling-avl | Modeling-cur | Workflow Client-cur | Workflow Client-cur
20210806:145037 | 16 | 2 | 41 | 11 | 13 | 0 | 82 | 22 | 34 | 0 | 34 | 20 | 70 | 22 | 41 | 11
20210806:155037 | 16 | 1 | 41 | 9 | 13 | 0 | 82 | 18 | 34 | 0 | 34 | 16 | 70 | 16 | 41 | 9
20210806:165037 | 16 | 0 | 41 | 8 | 13 | 0 | 82 | 16 | 34 | 0 | 34 | 14 | 70 | 14 | 41 | 8
20210806:175037 | 16 | 0 | 41 | 3 | 13 | 0 | 82 | 6 | 34 | 0 | 34 | 4 | 70 | 8 | 41 | 3
20210806:185037 | 16 | 0 | 41 | 4 | 13 | 0 | 82 | 8 | 34 | 0 | 34 | 6 | 70 | 6 | 41 | 4
20210806:195037 | 16 | 0 | 41 | 3 | 13 | 0 | 82 | 6 | 34 | 0 | 34 | 4 | 70 | 4 | 41 | 3
20210806:205037 | 16 | 1 | 41 | 3 | 13 | 0 | 82 | 6 | 34 | 0 | 34 | 4 | 70 | 4 | 41 | 3
20210806:215037 | 16 | 0 | 41 | 2 | 13 | 0 | 82 | 4 | 34 | 0 | 34 | 2 | 70 | 2 | 41 | 2
20210806:225037 | 16 | 0 | 41 | 3 | 13 | 0 | 82 | 6 | 34 | 0 | 34 | 4 | 70 | 4 | 41 | 3
20210806:235037 | 16 | 0 | 41 | 2 | 13 | 0 | 82 | 4 | 34 | 0 | 34 | 2 | 70 | 2 | 41 | 2
20210807:002037 | 16 | 0 | 41 | 2 | 13 | 0 | 82 | 4 | 34 | 0 | 34 | 2 | 70 | 2 | 41 | 2
20210807:012037 | 16 | 0 | 41 | 1 | 13 | 0 | 82 | 2 | 34 | 0 | 34 | 0 | 70 | 0 | 41 | 1
20210807:022037 | 16 | 0 | 41 | 1 | 13 | 0 | 82 | 2 | 34 | 0 | 34 | 0 | 70 | 0 | 41 | 1
20210807:032037 | 16 | 0 | 41 | 1 | 13 | 0 | 82 | 2 | 34 | 0 | 34 | 0 | 70 | 0 | 41 | 1
20210807:042037 | 16 | 0 | 41 | 1 | 13 | 0 | 82 | 2 | 34 | 0 | 34 | 0 | 70 | 0 | 41 | 1
20210807:052037 | 16 | 0 | 41 | 1 | 13 | 0 | 82 | 2 | 34 | 0 | 34 | 0 | 70 | 0 | 41 | 1
20210807:062037 | 16 | 0 | 41 | 1 | 13 | 0 | 82 | 2 | 34 | 0 | 34 | 0 | 70 | 0 | 41 | 1
20210807:072037 | 16 | 0 | 41 | 1 | 13 | 0 | 82 | 2 | 34 | 0 | 34 | 0 | 70 | 0 | 41 | 1
20210807:082038 | 16 | 0 | 41 | 1 | 13 | 0 | 82 | 2 | 34 | 0 | 34 | 0 | 70 | 0 | 41 | 1
Spreadsheet: chris_stokley__3921__0401 PGES Final
Sheet: ECT

 | EPMI Charges To ECT
 | Trans Type | (CAISO 0701 M)
 | ID | (All)
 |  |  |  |  |  |  |  |  | MrktDt | (All)
 |  | Data |  |  |  |  |  |  | SchedType | (All)
 | Customer | Exp | Rev | Charge | Volume |  |  |  | ID | (All)
 | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  | Data
 |  |  |  |  |  |  |  |  | Customer | Location | TO | Charge | Rate | Volume | FTR %
 |  |  |  |  |  |  |  |  | PGES | All | SP15 | 5115.496099999987 | 0 | -113.5070999999999 | 0
 |  |  |  |  |  |  |  |  |  |  | NP15 | 880.7266999999973 | 0 | 52.40480000000002 | 0
 |  |  |  |  |  |  |  |  |  |  | HUMB | -43.50769999999999 | 0 | 0.0064 | 0
 |  |  |  |  |  |  |  |  |  |  | SF | -155.0379999999999 | 0 | -0.001799999999999992 | 0
 |  |  |  |  |  |  |  |  |  |  | ZP26 | -62.57409999999999 | 0 | -0.04649999999999999 | 0
 |  |  |  |  |  |  |  |  |  |  | All | -22574.72979999999 | 0 | -48834.4917000001 | 0
 |  |  |  |  |  |  |  |  |  | None | All | 135.7325 | 0.9510000000000004 | -142.6578159853916 | 0
 |  |  |  |  |  |  |  |  | PGES Total |  |  | -16703.89430000003 | 0.03628815789473686 | -49038.29371598548 | 0
 |  |  |  |  |  |  |  |  | Grand Total |  |  | -16703.89430000003 | 0.03628815789473686 | -49038.29371598548 | 0
Spreadsheet: 33755-nested-lookups-or-nedezero
Sheet: Sheet1

 |  | 1 | 5 | 50 | 0 |  |  |  |  |  |  |  |  | scale | percent | Score
 |  | 2 | 5 | 75 | 3 |  |  |  |  |  |  |  |  | 10 | 50 | 0
 |  | 3 | 5 | 100 | 5
 |  | 4 | 10 | 50 | 0
 |  | 5 | 10 | 75 | 7
 |  | 6 | 10 | 100 | 10
 |  | 7 | 15 | 50 | 5
 |  | 8 | 15 | 75 | 10
 |  | 9 | 15 | 100 | 15