tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 106266d1303424844-simple-pivot-table-question-pivot-day92-c-
Sheet: pivot

 | Project | Group | Owner | Cost | Comments |  |  | Sum of Cost | Column Labels
 | Project 1 | Red | [NAME] | 10 | Comment 1 |  |  | Row Labels | Comment 1 | Comment 10 | Comment 2 | Comment 3 | Comment 4 | Comment 5 | Comment 6 | Comment 7 | Comment 8 | Comment 9 | Grand Total
 | Project 2 | Red | Sue | 34 | Comment 2 |  |  | [NAME] | 10 | 89 |  |  | 78 |  |  | 367 |  |  | 544
 | Project 3 | Red | [NAME] | 54 | Comment 3 |  |  | Project 1 | 10 |  |  |  |  |  |  |  |  |  | 10
 | Project 4 | Blue | [NAME] | 78 | Comment 4 |  |  | Project 10 |  | 89 |  |  |  |  |  |  |  |  | 89
 | Project 5 | Blue | Sue | 12 | Comment 5 |  |  | Project 4 |  |  |  |  | 78 |  |  |  |  |  | 78
 | Project 6 | Blue | [NAME] | 65 | Comment 6 |  |  | Project 7 |  |  |  |  |  |  |  | 367 |  |  | 367
 | Project 7 | Green | [NAME] | 367 | Comment 7 |  |  | [NAME] |  |  |  | 54 |  |  | 65 |  |  | 7 | 126
 | Project 8 | Green | Sue | 432 | Comment 8 |  |  | Project 3 |  |  |  | 54 |  |  |  |  |  |  | 54
 | Project 9 | Green | [NAME] | 7 | Comment 9 |  |  | Project 6 |  |  |  |  |  |  | 65 |  |  |  | 65
 | Project 10 | Green | [NAME] | 89 | Comment 10 |  |  | Project 9 |  |  |  |  |  |  |  |  |  | 7 | 7
 |  |  |  |  |  |  |  | Sue |  |  | 34 |  |  | 12 |  |  | 432 |  | 478
 |  |  |  |  |  |  |  | Project 2 |  |  | 34 |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  | Project 5 |  |  |  |  |  | 12 |  |  |  |  | 12
 |  |  |  |  |  |  |  | Project 8 |  |  |  |  |  |  |  |  | 432 |  | 432
 |  |  |  |  |  |  |  | Grand Total | 10 | 89 | 34 | 54 | 78 | 12 | 65 | 367 | 432 | 7 | 1148
 |  |  |  |  |  |  |  | Owner | sum cost | Comments
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Project 1 | 10 | Comment 1
 |  |  |  |  |  |  |  | Project 4 | 78 | Comment 4
 |  |  |  |  |  |  |  | Project 7 | 367 | Comment 7
 |  |  |  |  |  |  |  | Project 10 | 89 | Comment 10
 |  |  |  |  |  |  |  | Sue
 |  |  |  |  |  |  |  | Project 2 | 34 | Comment 2
 |  |  |  |  |  |  |  | Project 5 | 12 | Comment 5
 |  |  |  |  |  |  |  | Project 8 | 432 | Comment 8
 |  |  |  |  |  |  |  | and so on …..
Spreadsheet: 838483d1691051051-textsplit-function-is-it-possible-to-spill-an-empty-cell-with-zero-txtsplit-aligw
Sheet: Sheet1

 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed |  |  | GK |  |  |  |  | AliGW
 | 1 Smoke Wagon |  | 86 | 85/ 73 | 67 |  |  |  | 73 |  |  |  |  | 85 | 73 | 67 |  |  | 85 | 73 | 67
 | 2 Global Hysteria |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 3 I Strong |  | 86 | [NAME] 75 * | 71* |  |  |  | 75 |  |  |  |  | 86 | 75 | 71 |  | 86 | 86 | 75 | 71
 | 4 Maluma |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 5 Warrior's Cause |  | 93 | 91/ 65 | 66 |  |  |  | 65 |  |  |  |  | 91 | 65 | 66 |  | 93 | 91 | 65 | 66
 | 6 Exclusive Entry |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 7 Bundaburg |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 8 Imposter Syndrome |  | 85 | 87/ 75 | 72 |  |  |  | 75 |  |  |  |  | 87 | 75 | 72 |  | 85 | 87 | 75 | 72
 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed
 | 3 Protectthewitness |  | 95 | 85/ 57 * | 66* |  |  |  | 57 |  |  |  |  | 85 | 57 | 66 |  |  | 85 | 57 | 66
 | 2 R Girl Faith |  | 79 | 73/ 61 * | 63* |  |  |  | 61 |  |  |  |  | 73 | 61 | 63 |  | 79 | 73 | 61 | 63
 | 5 Vaccina |  | 88 | 81/ 55 * | 63* |  |  |  | 55 |  |  |  |  | 81 | 55 | 63 |  | 88 | 81 | 55 | 63
 | 1 Phancy Philly |  | 79 | 67/ 51 * | 54* |  |  |  | 51 |  |  |  |  | 67 | 51 | 54 |  | 79 | 67 | 51 | 54
 | 4 Sailor's Salute |  | 82 | 71/ 50 * | 53* |  |  |  | 50 |  |  |  |  | 71 | 50 | 53 |  | 82 | 71 | 50 | 53
 | 6 Calvary Kat |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Spreadsheet: 1de2ef0e-999d-40eb-863d-cf023a8ab332
Sheet: B

Course color corresponds with term of offering.  ORANGE for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
 | AOK Designation | CAR Designation | Comment
Biology
BIOL 121 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 122 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 124 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 125 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 126 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 127 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 129 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 133 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 151 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 155 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 175 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 182 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 250 |  | Experiential-Travel
BIOL 309 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 315 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 333 | Natural & Mathematical Sciences-Nat Sci w Lab | Experiential-Travel
BIOL 335 | Natural & Mathematical Sciences-Nat Sci w Lab | Experiential-Travel
BIOL 350 |  | Computing
BIOL 381 | Natural & Mathematical Sciences-Nat Sci w Lab |  | 2009-2010 (Flies, Fishes, and Foods)
BIOL381 | Natural & Mathematical Sciences-Nat Sci w Lab |  | Summer 2013 (Special Topics in General Zoology)
 |  |  | Fall 2011 (Evolution & Natural Selection)
BIOL 400 |  | Experiential-Research; Capstone
BIOL 450 |  | Experiential-Research
BIOL 487-488 |  | Experiential-Research; Capstone
BIOL 491-492 |  | Experiential-Research
BIOL 493-494 |  | Experiential-Research
BIOL 496-498 |  | Experiential-Research; Capstone
BIOL 499 |  | Capstone
Black Studies
BLST 160 | Social Sciences | Non-Western, Experiential-Travel | Cross-listed with PSYC 160
BLST 201 | Social Sciences |  | Cross-listed with SOCI 225
BLST 381 |  | Experiential-Travel | J-Term 2009,2010;2012  Cross-listed with HIST 381
BLST 381 | Arts & Literature-Arts |  | J-Term 2013 (Black American Theatre)
Business
BUSN 111 | Social Sciences
BUSN 213 | Social Sciences
BUSN 336 |  | Computing
BUSN 425 |  | Capstone | Accounting & Economics/Business major
BUSN 450-451 |  | Experiential-Internship, Capstone | Economics/Business major
BUSN 452 |  | Capstone; Experiential-Internship | Accounting major
BUSN 455 |  | Capstone; Experiential-Field Studies
BUSN 481 |  | Experiential-Travel | J-Term 2014(Industrailization: Progression of Industrail Rev.In GB)
BUSN 491-492 |  | Capstone; Experiential-Research | Accounting & Economics/Business major
BUSN 496-498 |  | Capstone; Experiential-Research | Accounting & Economics/Business major
Spreadsheet: 144940d1331219997-excluding-data-from-a-formula-if-they-have-already-been-used-2012-regional-scores-example-1-
Sheet: Statistics

Overall
 |  | Points | %
1 |  |  |  |  | 1
2
3
4
Job Specific - Mill
 |  | Points | %
1
2
3
4
Job Specific - Lathe
 |  | Points | %
1
2
3
4
Job Specific - Bench
 |  | Points | %
1
2
3
4
Spreadsheet: 737661d1624532806-after-24-hour-formula-not-work-tree-tracker
Sheet: time

user |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 1 | 2 | 3 | 4 | 5 |  |  |  | user | time in | time out
a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | 6 | 22
s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s | 8 | 13
ww |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ww | 20 | 4
65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 | 22 | 23
df |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | df | 23 | 5
Spreadsheet: 137584d1327242478-convert-data-from-differnt-rows-in-sheet-1-to-a-columns-in-sheet-2-in-sequence-rev-sheet-1-to-sheet-2
Sheet: Sheet1

Company 1
City 1
Company 1
Company 1 Description
Address: Address 1
Phone: Phone 1
Mobile / Cell Phone: Mobile 1
Website: http://www.c1.com/
Company 2
City 2
Company 2
Company 2 Description
Address: Address 2
Phone: Phone 2
Website: http://www.c2.com/
Company 3
City 1
Company 3
Company 3 Description
Address: Address 3
Phone: Phone 3
Mobile / Cell Phone: Mobile 3
Company 4
City 7
Company 4
Company 4 Description
Address: Address 4
Phone: Phone 4
Mobile / Cell Phone: Mobile 4
Website: http://www.c4.com/
[NAME]: [EMAIL]
Company 5
Company 5
Company 5 Description
Address: Address 5
Website: http://www.c5.net/
Spreadsheet: 47283d1246308740-formula-to-get-average-percentage-new-tables
Sheet: Sheet1

 | Runs | 16 | 9 | 9 | 4 | 8 | 2
Runs |  | fast | firm | good | yield | mud | soft | Totals
10 | 1000
5 | 1200
3 | 1400
0 | 1600
8 | 1800
10 | 2200
6 | 2400
4 | 2850
2 | 3200
 | Totals
What I would like is to get a formula which will give me an average percentage at the end of each column/row based one the amount of runs at the start of each column.
Of you go over each percentage you will see it shows 1/2 etc, which obviously comes up as 50%. All of these added together totals to the amount of runs in each column.
Is there any type of formula to be able to get an average percentage for each based on the runs?
Thanks
G
Spreadsheet: 84439d1284492644-comparing-ytd-2010-with-same-months-from-2009-sample-sales
Sheet: Sheet1

2010 SALES RECORD
Salesperson |  | January | February | March | April | May | June | July | August | September | October | November | December | Totals
Brian & Co | 2003-01-01 00:00:00
Total # | CT, MA ,ME, | 82 | 94 | 119 | 119 | 74 | 94 | 120 | 144 |  |  |  |  | 846
Total Sales | NH, RI, VT | 79056.75 | 64135.75 | 95855.2 | 54572.5 | 163625 | 52209.5 | 71760.47 | 75191.76 |  |  |  |  | 656406.93
Previous Year
Total # |  | 49 | 109 | 79 | 82 | 64 | 97 | 118 | 164 | 83 | 103 | 88 | 58 | 1094
Total Sales |  | 45603 | 64978.25 | 52121.75 | 45203.5 | 37656.75 | 73451.5 | 77340.4 | 80680.75 | 48737.5 | 74877 | 48334.75 | 29675.75 | 678660.9
Spreadsheet: 176272d1345800867-vlookup-counta-to-draw-figures-for-certain-names-test
Sheet: Sheet1

Name | Date complete site 1 | Date complete site 2
[NAME] | 2012-06-25 00:00:00 | 2011-12-13 00:00:00
[NAME] | 2012-06-25 00:00:00 | 2011-11-11 00:00:00
[NAME] | 2012-06-25 00:00:00 | 2011-11-14 00:00:00
[NAME] | 2012-07-16 00:00:00 | 2011-12-22 00:00:00 |  |  |  |  | Name | Site 1's Complete | Site 2's Complete
[NAME] | 2012-07-16 00:00:00 | 2011-12-12 00:00:00 |  |  |  |  | [NAME] | ? | ?
[NAME] | 2012-07-13 00:00:00 | 2011-12-09 00:00:00 |  |  |  |  | [NAME] | ? | ?
[NAME] | 2012-07-09 00:00:00 | 2011-11-18 00:00:00 |  |  |  |  | [NAME] | ? | ?
[NAME] | 2012-07-13 00:00:00 | 2011-12-09 00:00:00
[NAME] | 2012-06-19 00:00:00 | 2011-11-11 00:00:00
[NAME] | 2012-07-03 00:00:00 | 2011-11-18 00:00:00
[NAME] | 2012-06-29 00:00:00 | 2011-11-04 00:00:00
[NAME] | 2012-07-09 00:00:00 | 2011-12-09 00:00:00
[NAME] | 2012-07-11 00:00:00 | 2011-11-17 00:00:00
[NAME] | 2012-07-13 00:00:00 | 2011-11-18 00:00:00
[NAME] | 2012-06-19 00:00:00 | 2011-12-09 00:00:00
[NAME] | 2012-06-29 00:00:00 | 2011-12-09 00:00:00
[NAME] | 2012-07-18 00:00:00 | 2011-11-14 00:00:00
[NAME] | 2012-06-19 00:00:00 | 2011-12-09 00:00:00
[NAME] | 2012-07-09 00:00:00 | 2011-11-11 00:00:00
[NAME] | 2012-06-18 00:00:00 | 2011-12-15 00:00:00
[NAME] | 2012-07-09 00:00:00 | 2011-11-18 00:00:00
[NAME] | 2012-07-13 00:00:00 | 2011-12-09 00:00:00
[NAME] | 2012-07-11 00:00:00 | 2011-12-15 00:00:00
[NAME] | 2012-06-26 00:00:00 | 2011-11-14 00:00:00
[NAME] | 2012-07-11 00:00:00 | 2011-11-18 00:00:00
[NAME] | 2012-06-26 00:00:00 | 2011-11-11 00:00:00
[NAME] | 2012-07-03 00:00:00 | 2011-12-12 00:00:00
[NAME] | 2012-07-05 00:00:00 | 2011-11-17 00:00:00
[NAME] | 2012-07-03 00:00:00 | 2011-12-09 00:00:00
[NAME] | 2012-06-22 00:00:00 | 2011-11-11 00:00:00
[NAME] | 2012-06-25 00:00:00 | 2011-12-09 00:00:00
[NAME] | 2012-06-22 00:00:00 | 2011-11-11 00:00:00
[NAME] | 2012-06-29 00:00:00 | 2011-12-22 00:00:00
[NAME] | 2012-07-05 00:00:00 | 2011-11-18 00:00:00
[NAME] | 2012-07-31 00:00:00 | 2011-11-11 00:00:00
[NAME] | 2012-07-31 00:00:00 | 2011-12-15 00:00:00
[NAME] | 2012-06-19 00:00:00 | 2011-11-14 00:00:00
[NAME] | 2012-06-28 00:00:00 | 2011-12-12 00:00:00
[NAME] | 2012-06-07 00:00:00 | 2011-12-09 00:00:00
[NAME] | 2012-06-07 00:00:00 | 2011-11-11 00:00:00
[NAME] | 2012-06-12 00:00:00 | 2011-11-11 00:00:00
[NAME] | 2012-06-18 00:00:00 | 2011-11-11 00:00:00
[NAME] | 2012-06-18 00:00:00 | 2011-11-11 00:00:00
Spreadsheet: 826310d1681920744-copying-data-from-a-new-daily-file-to-a-master-file-with-all-data-temp-mac-sheets
Sheet: MASTER

ID # | Test Date | Milliamps | Test Date | Milliamps | Test Date | Milliamps | Test Date | Milliamps | Test Date | Milliamps | Test Date | Milliamps | Test Date | Milliamps
33413 | 44475 | 7
33435 | 2020-04-23 00:00:00 | 6 | 2021-10-13 00:00:00 | 4
33472 | 43962 | 10
33337 | 2012-10-26 00:00:00 | 7 | 2013-05-06 00:00:00 | 7 | 2013-11-12 00:00:00 | 7 | 2014-05-05 00:00:00 | 7 | 2016-06-03 00:00:00 | 7 | 2017-04-26 00:00:00 | 7 | 2017-12-12 00:00:00 | 8
33629 | 2012-10-26 00:00:00 | 7 | 2013-05-06 00:00:00 | 5 | 2013-11-12 00:00:00 | 7 | 2014-05-22 00:00:00 | 7 | 2014-12-18 00:00:00 | 7 | 2015-07-09 00:00:00 | 7 | 2016-01-11 00:00:00 | 7
33336 | 2012-07-13 00:00:00 | 6 | 2013-01-07 00:00:00 | 7 | 2013-08-08 00:00:00 | 7 | 2014-02-14 00:00:00 | 7 | 2014-08-28 00:00:00 | 7 | 2015-02-11 00:00:00 | 7 | 2015-09-04 00:00:00 | 7
33360 | 2012-07-13 00:00:00 | 8 | 2013-01-07 00:00:00 | 8 | 2014-07-29 00:00:00 | 8 | 2015-02-11 00:00:00 | 9 | 2015-07-31 00:00:00 | 8 | 2016-02-04 00:00:00 | 9 | 2016-09-30 00:00:00 | 9
33287 | 2012-10-15 00:00:00 | 11 | 2013-03-15 00:00:00 | 12 | 2013-09-13 00:00:00 | 12 | 2014-03-24 00:00:00 | 12 | 2014-09-24 00:00:00 | 12 | 2015-03-27 00:00:00 | 13 | 2016-03-02 00:00:00 | 12
33288 | 2012-10-26 00:00:00 | 7 | 2013-11-01 00:00:00 | 7 | 2014-04-30 00:00:00 | 7 | 2014-11-20 00:00:00 | 7 | 2015-12-07 00:00:00 | 7 | 2016-06-28 00:00:00 | 7 | 2016-12-08 00:00:00 | 7
33289 | 2012-09-05 00:00:00 | 7 | 2013-08-23 00:00:00 | 7 | 2014-01-31 00:00:00 | 7 | 2014-08-07 00:00:00 | 7 | 2015-06-12 00:00:00 | 7 | 2015-10-01 00:00:00 | 12 | 2015-12-23 00:00:00 | 7
33290 | 2012-07-13 00:00:00 | 9 | 2013-02-08 00:00:00 | 9 | 2013-03-14 00:00:00 | 10 | 2013-08-08 00:00:00 | 10 | 2014-09-24 00:00:00 | 10 | 2015-06-12 00:00:00 | 9 | 2015-12-11 00:00:00 | 10
33293 | 2012-10-26 00:00:00 | 7 | 2013-05-06 00:00:00 | 7 | 2013-11-12 00:00:00 | 7 | 2014-05-22 00:00:00 | 7 | 2015-07-15 00:00:00 | 7 | 2016-01-15 00:00:00 | 7 | 2016-08-09 00:00:00 | 7
Spreadsheet: 42162d1240728069-sum-of-cells-with-a-variable-cell-multiplier-itc-scoring_sheet
Sheet: Rifle

 |  |  |  |  | Rifle ITC
 |  |  |  |  | PHASE 1 |  |  |  | PHASE 2 |  |  |  |  |  |  |  | AWARDS
 |  |  |  |  | 40 | Target time |  |  | 55 | Target Time
 |  |  | Member |  | Time | Missed Targets | Score |  | Time | Missed Targets | Score |  | Total | Award |  |  | Gold | Silver | [NAME]
 |  | 1 | [NAME] |  | 40 | 0 | 50 |  | 55 | 0 | 50 |  | 100 | Gold
 |  | 2 | [NAME] |  | 50 | 0 | 20 |  | 55 | 0 | 50 |  | 70 | [NAME]
 |  | 3 | [NAME] |  | 45 | 0 | 35 |  | 55 | 0 | 50 |  | 85 | Silver
 |  | 4 | [NAME] |  | 60 | 0 | -10 |  | 55 | 0 | 50 |  | 40
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
Spreadsheet: 884772d1734026475-parts-inventory-comparison-week-over-week-inventory-balance-12-04-2024-vs-12-11-24
Sheet: Sheet1

 | 11.19 | 0 | 11.19
0172-GG3-005 | 85.11 | 198.59 | -113.48
0488GG3001 | 111.67 | 223.34 | -111.67
09121512PP | 489.02 | 0 | 489.02
1124292 | 0 | 32.62 | -32.62
1124294 | 0 | 25 | -25
12-820 | 69.51 | 34.76 | 34.75000000000001
1569-RR3-011 | 0 | 20.95 | -20.95
15W40 | 3670.6 | 3472.78 | 197.8199999999997
1637 | 43.12 | 21.56 | 21.56
194-N | 6.44 | 6.06 | 0.3800000000000008
200-0072-10-0 | 0 | 159.6 | -159.6
2020N-30 | 38.1 | 25.4 | 12.7
220129 | 149.68 | 74.84 | 74.84
226SH | 0 | 123.63 | -123.63
24295 | 0 | 33.2 | -33.2
24296 | 0 | 45.84 | -45.84
24297 | 0 | 61.5 | -61.5
2618XA | 0 | 46.97 | -46.97
2618XB | 0 | 46.97 | -46.97
320-2099 | 513.98 | 256.99 | 256.99
33208R | 235.51 | 192.69 | 42.81999999999999
3585XE | 151.41 | 129.78 | 21.63
4-01874 | 363.9 | 379.38 | -15.48000000000002
4070 | 19.68 | 9.84 | 9.84
4810 | 0 | 29.26 | -29.26
489078001 | 0 | 33.95 | -33.95
490471 | 37.03 | 31.74 | 5.290000000000003
50-40204-3 | 92.5 | 88.8 | 3.700000000000003
5129557 | 57.74 | 44.91 | 12.83000000000001
5686152 | 0 | 91.08 | -91.08
6891 | 427.2 | 213.6 | 213.6
6932 | 46.47 | 0 | 46.47
702135 | 36.5 | 0 | 36.5
705-1507 | 22.39 | 17.91 | 4.48
7060 | 23.88 | 17.91 | 5.969999999999999
707846 | 22.38 | 33.57 | -11.19
714446 | 239.4 | 359.1 | -119.7
7182 | 137.15 | 121.91 | 15.24000000000001
728222 | 5.61 | 0 | 5.61
75-530 | 9.65 | 0 | 9.65
75-531 | 121.14 | 100.95 | 20.19
75204 | 664.48 | 634.43 | 30.05000000000007
7565 | 330.49 | 660.99 | -330.5
7594R | 106.88 | 0 | 106.88
78152B | 347.1 | 312.39 | 34.71000000000004
782-2185 | 4.31 | 5.71 | -1.4
8240 | 89.59 | 0 | 89.59
8448AAA | 116.56 | 0 | 116.56
8943A | 60 | 54 | 6
9008 | 15.7 | 7.85 | 7.85
92060001 | 668.16 | 556.8 | 111.36
950011K | 121.68 | 97.35 | 24.33000000000001
950014K | 0 | 84.4 | -84.4
DWADT1024 | 72.45 | 57.96 | 14.49
EB1 | 45.48 | 41.69 | 3.789999999999999
EMC3-7901SS545 | 69.71 | 0 | 69.71
FCA053 | 6.58 | 26.34 | -19.76
FF5971NN | 194.22 | 129.48 | 64.74000000000001
FF63041NN | 104.15 | 83.32 | 20.83000000000001
FREIGHT *****USE FOR ALL FREIGHT*** | 684.97 | 996.75 | -311.78
h-175 | 23.5 | 27.05 | -3.550000000000001
H4656N | 39.94 | 33.28 | 6.659999999999997
IBR57 | 106.74 | 88.95 | 17.78999999999999
K514-1 | 81.4 | 48.84 | 32.56
KN20021 | 32.3 | 0 | 32.3
LF14001NN | 248 | 198.4 | 49.59999999999999
LF14002NN | 142.51 | 95.01 | 47.49999999999999
MINUS20 | 164.16 | 161.71 | 2.449999999999989
NPF002 | 787.26 | 952.47 | -165.21
NT3030ELS-WC | 121.88 | 0 | 121.88
R61691T | 0 | 25.44 | -25.44
TURTLE | 217.11 | 65.68 | 151.43
W307773 | 0 | 7.82 | -7.82
Spreadsheet: 106468d1303756148-not-picking-up-total-indexing-workbook37b
Sheet: Sheet1

0 | 9 | 1 | 4 | 7 |  | 9
000 | 900 | 100 | 400 | 700
019 | 919 | 119 | 419 | 719
028 | 928 | 128 | 428 | 728
037 | 937 | 137 | 437 | 737
001 | 901 | 101 | 401 | 701
029 | 929 | 129 | 429 | 729
038 | 938 | 138 | 438 | 738
056 | 956 | 156 | 456 | 756
002 | 902 | 102 | 402 | 702
011 | 911 | 111 | 411 | 711
039 | 939 | 139 | 439 | 739
048 | 948 | 148 | 448 | 748
057 | 957 | 157 | 457 | 757
066 | 966 | 166 | 466 | 766
012 | 912 | 112 | 412 | 712
049 | 949 | 149 | 449 | 749
067 | 967 | 167 | 467 | 767
022 | 922 | 122 | 422 | 722
059 | 959 | 159 | 459 | 759 |  |  |  |  |  |  | 0
068 | 968 | 168 | 468 | 768
005 | 905 | 105 | 405 | 705
014 | 914 | 114 | 414 | 714
023 | 923 | 123 | 423 | 723
069 | 969 | 169 | 469 | 769
006 | 906 | 106 | 406 | 706
024 | 924 | 124 | 424 | 724
033 | 933 | 133 | 433 | 733
007 | 907 | 107 | 407 | 707
016 | 916 | 116 | 416 | 716
025 | 925 | 125 | 425 | 725
034 | 934 | 134 | 434 | 734
089 | 989 | 189 | 489 | 789
008 | 908 | 108 | 408 | 708
017 | 917 | 117 | 417 | 717
026 | 926 | 126 | 426 | 726
035 | 935 | 135 | 435 | 735
044 | 944 | 144 | 444 | 744
099 | 999 | 199 | 499 | 799
018 | 918 | 118 | 418 | 718
027 | 927 | 127 | 427 | 727
036 | 936 | 136 | 436 | 736
Spreadsheet: 685965d1594297219-look-up-postcode-and-allocate-region-example
Sheet: North East

Postcode | In Use? | County | District | Region
CA8 2JF | Yes | Northumberland | Northumberland | [NAME]
CA8 7BB | Yes | Northumberland | Northumberland | [NAME]
CA8 7BD | Yes | Northumberland | Northumberland | [NAME]
CA8 7BE | Yes | Northumberland | Northumberland | [NAME]
CA8 7BG | Yes | Northumberland | Northumberland | [NAME]
CA8 7BH | Yes | Northumberland | Northumberland | [NAME]
CA8 7BJ | Yes | Northumberland | Northumberland | [NAME]
CA8 7BL | Yes | Northumberland | Northumberland | [NAME]
CA8 7BN | Yes | Northumberland | Northumberland | [NAME]
CA8 7BQ | Yes | Northumberland | Northumberland | [NAME]
Spreadsheet: 874992d1721537247-lotto-number-checker-wont-work-nomisdice-lottery-checker-by-henry-aligw
Sheet: Lottery Checker

Draw # | #1 | #2 | #3 | #4 | #5 | #6 | # [NAME] |  | Check number | #1 | #2 | #3 | #4 | #5 | #6 |  | # | [NAME]
1 | 3 | 19 | 20 | 29 | 66 | 16 |  |  |  | 10 | 17 | 23 | 50 | 67 | 3 |  | 1
2 | 5 | 14 | 20 | 22 | 26 | 11 |  |  |  |  |  |  |  |  |  |  | 2
3 | 22 | 29 | 51 | 52 | 58 | 16 |  |  | Match? | 1 | 2 | 3 | 4 | 5 | 6 |  | 3
4 | 19 | 26 | 41 | 52 | 58 | 12 |  |  |  |  |  |  |  |  |  |  | 4
5 | 22 | 26 | 29 | 38 | 51 | 16 |  |  |  |  |  |  |  |  |  |  | 5
6 | 3 | 38 | 51 | 52 | 66 | 11 |  |  |  |  |  |  |  |  |  |  | 6
7 | 5 | 9 | 20 | 22 | 66 | 11 |  |  |  |  |  |  |  |  |  |  | 7
8 | 19 | 22 | 29 | 51 | 58 | 11 |  |  |  |  |  |  |  |  |  |  | 8
9 | 3 | 5 | 9 | 26 | 41 | 21 |  |  |  |  |  |  |  |  |  |  | 9
10 | 3 | 22 | 41 | 51 | 66 | 12 |  |  |  |  |  |  |  |  |  |  | 10
11 | 4 | 24 | 45 | 61 | 70 | 0 |  |  |  |  |  |  |  |  |  |  | 11
12 | 23 | 36 | 46 | 69 | 70 | 0 |  |  |  |  |  |  |  |  |  |  | 12
13 | 1 | 17 | 54 | 69 | 70 | 0 |  |  |  |  |  |  |  |  |  |  | 13
14 | 14 | 18 | 48 | 65 | 66 | 0 |  |  |  |  |  |  |  |  |  |  | 14
15 | 7 | 25 | 29 | 43 | 62 | 0 |  |  |  |  |  |  |  |  |  |  | 15
16 | 11 | 17 | 53 | 58 | 67 | 0 |  |  |  |  |  |  |  |  |  |  | 16
17 | 6 | 31 | 39 | 41 | 68 | 0 |  |  |  |  |  |  |  |  |  |  | 17
18 | 1 | 27 | 36 | 41 | 68 | 0 |  |  |  |  |  |  |  |  |  |  | 18
19 | 28 | 29 | 31 | 58 | 70 | 0 |  |  |  |  |  |  |  |  |  |  | 19
20 | 21 | 33 | 53 | 59 | 69 | 0 |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
Spreadsheet: 175565d1345569634-make-a-list-from-multipe-columns-that-are-not-next-to-each-other-combined-list-sample
Sheet: Combined Lists

 |  |  | combined list | Report 1 | Report 2 | Report 3 | Report 4 | Report 5 | Report 6 | Report 7
 |  |  | 1
 |  |  | 3
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 1000
 |  |  | 1001
 |  |  | 1002
 |  |  | 1003
 |  |  | 1004
 |  |  | 1005
 |  |  | 1006
 |  |  | 1007
 |  |  | 2000
 |  |  | 2001
 |  |  | 2002
 |  |  | 2003
 |  |  | 3000
 |  |  | 4000
 |  |  | 5000
 |  |  | 5001
 |  |  | 6000
 |  |  | 6001
 |  |  | 7000
 |  |  | 7001
 |  |  | 8000
 |  |  | 8001
 |  |  | 9000
 |  |  | 9001
 |  |  | 10000
 |  |  | 10001