tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 122544d1316947094-automating-timesheet-tsheet2
Sheet: 11 Sept

Mining System |  |  |  | 07:30:00
 |  |  |  | 20:00:00
Clock No. | Discipline | Surname, Name | In | Out | Item No. | NT | Rate | OT | Rate | DT | Rate | Sum | Commment
201 | Supervisor | Cottle, Y | 08:00:00 | 22:00:00 | 001 |  | 345 |  | 345 |  | 410
223 | Supervisor | Fisher, N | 0800 | 1230 | 001 |  | 345 |  | 345 | 4.5 | 410
223 | Supervisor | Fisher, N | 1300 | 2200 | 003 |  | 345 |  | 345 | 9 | 410
22 | [NAME] | Titus, R | 0800 | 1900 | 001 |  | 240 |  | 286 | 10.5 | 320
41 | [NAME] | Khanye, M | 08:00:00 | 22:00:00 | 001 |  | 240 |  | 286 |  | 320
504 | Burner | [NAME], AA | 0800 | 0700 | 001 | 8.75 | 160 | 7 | 210 | 15.25 | 310 |  | ALL NIGHT
88 | Fitter | Currie, C | 0800 | 2200 | 001 |  | 152 |  | 212 | 13.5 | 308
544 | Fitter | Toefy. A | 0800 | 2200 | 001 |  | 152 |  | 212 | 13.5 | 308
18 | Rigger | Philander, O | 0800 | 1230 | 001 |  | 170 |  | 220 | 4.5 | 320
18 | Rigger | Philander, O | 1300 | 2300 | 003 |  | 170 |  | 220 | 10 | 320
111 | Rigger | Xoseni, V | 0800 | 1900 | 001 |  | 170 |  | 220 | 10.5 | 320
8 | Operator | [NAME], J | 0800 | 1900 | 001 |  | 138 |  | 182 | 10.5 | 253
54 | Operator | Nokosi, B | 0800 | 1230 | 001 |  | 138 |  | 182 | 4.5 | 253
54 | Operator | Nokosi, B | 1300 | 2200 | 003 |  | 138 |  | 182 | 9 | 253
16 | Operator | Ocks, M | 0800 | 1230 | 001 |  | 138 |  | 182 | 4.5 | 253
16 | Operator | Ocks, M | 1300 | 2300 | 003 |  | 138 |  | 182 | 10 | 253
20 | Operator | Samente, M | 0800 | 2200 | 001 |  | 138 |  | 182 | 13.5 | 253
226 | Safety | Arendse, B | 0800 | 2300 | 001 |  | 138 |  | 182 | 14.5 | 253
117 | Driver | [NAME], J | 0800 | 0100 | 001 |  | 134 | 1 | 172 | 15.5 | 250 |  | MEN HOME
17 | Driver | [NAME], S | 0800 | 1230 | 001 |  | 134 |  | 172 | 4.5 | 250 |  | MEN HOME
17 | Driver | [NAME], S | 1300 | 0100 | 003 |  | 134 | 1 | 172 | 11 | 250 |  | MEN HOME
247 | Labourer | Charles, C | 0800 | 2200 | 001 |  | 80 |  | 108 | 13.5 | 163
96 | Storeman | Cupido, V | 0800 | 1900 | 001 |  | 88 |  | 114 | 10.5 | 165
353 | Labourer | Isaacs, Z | 1700 | 1900 | 001 |  | 80 |  | 108 | 2 | 163
202 | Labourer | [NAME], M | 0800 | 1900 | 001 |  | 80 |  | 108 | 10.5 | 163
521 | Labourer | Lesaoana, L | 0800 | 2200 | 001 |  | 80 |  | 108 | 13.5 | 163
400 | Labourer | Matthews, D | 0800 | 1900 | 001 |  | 80 |  | 108 | 10.5 | 163
339 | Labourer | Mlambisa, J | 0800 | 1230 | 001 |  | 80 |  | 108 | 4.5 | 163
339 | Labourer | Mlambisa, J | 1300 | 2200 | 003 |  | 80 |  | 108 | 9 | 163
128 | Labourer | Nyembenya, M | 0800 | 2200 | 001 |  | 80 |  | 108 | 13.5 | 163
497 | Labourer | [NAME], T | 0800 | 1230 | 001 |  | 80 |  | 108 | 4.5 | 163
497 | Labourer | [NAME], T | 1300 | 2200 | 003 |  | 80 |  | 108 | 9 | 163
334 | Labourer | Zondani, B | 0800 | 2200 | 001 |  | 80 |  | 108 | 13.5 | 163
303 | Labourer | Zoneleni, N | 0800 | 2200 | 001 |  | 80 |  | 108 | 13.5 | 163
999 | [NAME] | N.Samadani | 0800 | 0700 | 001 | 8.75 | 54 | 7 | 77 | 7 | 110 |  | ALL NIGHT
999 | [NAME] | M.Huruma | 0800 | 1900 | 001 |  | 54 |  | 77 | 10.5 | 110
999 | [NAME] | T.Bonkolo | 0800 | 1900 | 001 |  | 54 |  | 77 | 10.5 | 110
 | à!/àà
Spreadsheet: 25689d1217169013-count-and-vlook-up-to-count-days-off-exampledate1
Sheet: Sheet3

Date | Day | Becky | [NAME] |  | Absent | Day
2008-07-27 00:00:00 | söndag | A(Absent) |  |  | Becky | måndag | onsdag | söndag | Grand Total
2008-07-28 00:00:00 | måndag | A(Absent) |  |  | P(Partial) |  | 1 |  | 1
2008-07-29 00:00:00 | [NAME] |  |  |  | A(Absent) | 1 |  | 1 | 2
2008-07-30 00:00:00 | onsdag | P(Partial) | A(Absent) |  | Grand Total | 1 | 1 | 1 | 3
 |  |  |  |  | Absent | Day
 |  |  |  |  | [NAME] | onsdag | Grand Total
 |  |  |  |  | A(Absent) | 1 | 1
 |  |  |  |  | Grand Total | 1 | 1
Spreadsheet: 115541d1311107842-using-if-statements-problems-events
Sheet: Sheet1

Event 1 | 2 | 3 | 2
Event 2 | 1 | 7 | 8
Event 3 | 0 | 0 | 0
Event 4 | 2 | 9 | 3
Event 5 | 3 | 5 | 0
Event 6 | 0 | 0 | 0
Event 7 | 2 | 3 | 0
Event 8 | 9 | 0 | 0
Event 9 | 0 | 0 | 9
Event 10 | 0 | 0 | 0
Event 11 | 8 | 8 | 8
Event 12 | 1 | 1 | 0
Event 13 | 4 | 1 | 0
Event 14 | 0 | 0 | 0
Event 15 | 0 | 0 | 0
Event 16 | 0 | 0 | 0
Event 17 | 1 | 3 | 0
Spreadsheet: 680308d1590929740-multiple-values-total-multiple-sheets-sum-countif-sample
Sheet: MONTHLY ERROR TOTALS

 |  |  | Stand Sheet | Loadsheet | Flight File (AF/KLM) | LIR | Final Load Report | LIR | Final Load Report | Cargo Documents | NOTOC | Pieces and Weight | Secure Clean Form | [NAME] | Technical Log | Turnaround Safety Checks | Ramp Job Card | Boarding Report | Passenger Manifest | Baggage Manifest | Offload Certifcate | UNMR Documentation | AAA Paperwork | [NAME] | Rush Tag(s) | [NAME] | Bingo Card
BOB
ANDY
KEVIN
MIKE
01JUN |  | N
02JUN
03JUN
04JUN
05JUN
06JUN
07JUN
08JUN
09JUN
10JUN
11JUN
12JUN
13JUN
14JUN
15JUN
16JUN
17JUN
18JUN
19JUN
20JUN
21JUN
22JUN
23JUN
24JUN
25JUN
26JUN
27JUN
28JUN
29JUN
30JUN
Spreadsheet: 850130d1700508793-pulling-data-from-disparate-columns-unique-filter
Sheet: No Vacants

 | EmplID | Name | Date Vacated | [NAME]
00087126 | [PHONE] | Archie | 0 | 00AAC00000
00115804 | [PHONE] | [NAME] | 0 | 00AAC00000
00088961 | [PHONE] | Veronica | 0 | 00AAC00000
00089575 | [PHONE] | Betty | 0 | 00AAC00000
00115660 | [PHONE] | Kalel | 0 | 00AAC00000
00116132 | [PHONE] | Superman | 0 | 00AAC00000
00060423 | [PHONE] | Spiderman | 0 | 00AAC00000
00060441 | [PHONE] | [NAME] | 0 | 00AAC00000
00028431 | [PHONE] | [NAME] | 0 | 00AAC00000
00038527 | [PHONE] | [NAME] | 0 | 00ADDPGS00
00037873 | [PHONE] | Micky | 0 | 00APP00000
00059998 | [PHONE] | Minnie | 0 | 00APP00000
00060000 | [PHONE] | [NAME] | 0 | 00APP00000
00060001 | [PHONE] | Goofy | 0 | 00APP00000
00060002 | [PHONE] | Dopey | 0 | 00APP00000
00087128 | [PHONE] | Doc | 0 | 00APP00000
00037875 | [PHONE] | Grumpy | 0 | 00APP00000
00038413 | [PHONE] | [NAME] | 0 | 00APP00000
00078932 | [PHONE] | Sleepy | 0 | 00APP00000
00086425 | [PHONE] | Bashful | 0 | 00APP00000
00039073 | [PHONE] | [NAME] | 0 | 00APP00000
00041602 | [PHONE] | Batman | 0 | 00APP00000
00060422 | [PHONE] | [NAME] | 0 | 00APP00000
00037885 | [PHONE] | [NAME] | 0 | 00APS00001
00037877 | [PHONE] | Ringo | 0 | 00APS00001
00087129 | [PHONE] | [NAME] | 0 | 00APS00001
00039072 | [PHONE] | [NAME] | 0 | 00APS00001
00059035 | [PHONE] | [NAME] | 0 | 01ADDINH00
00079006 | [PHONE] | [NAME] | 0 | 01ADDINH00
00060076 | [PHONE] | [NAME] | 0 | 01ADDINH00
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
Spreadsheet: 189686d1351280122-index-match-with-multiple-criteria-across-both-rows-and-columns-book1
Sheet: Summary Page

Product | Warranty Status | Product Age (Yrs) | World Region | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
Product A | In warranty | 5-9 | North America
Product A | Out of Warranty | 5-9 | North America
Product B | In warranty | 5-9 | North America
Product B | Out of Warranty | 5-9 | North America
Product C | In warranty | 5-9 | North America
Product C | Out of Warranty | 5-9 | North America
Spreadsheet: 802104d1666648547-working-with-excel-calendar-for-if-date-and-or-workday-functions-excelgor
Sheet: Sheet1

Start Date | 2022-07-23 00:00:00 |  | Holidays | 2022-10-24 00:00:00
Payment Date 1
Payment Date 2
Payment Date 3
Payment Date 4
Payment Date 5
Payment Date 6
Payment Date 7
Payment Date 8
Payment Date 9
Spreadsheet: 140460d1328758186-want-multiple-results-from-vlookup-ptmultiple-lookup
Sheet: Sheet1

 |  |  |  |  |  |  |  | Company | b | <<Select this to change company
 | Company | Customer | Amount
 | a | [NAME] | 10 |  |  |  |  | Row Labels | Sum of Amount
 | b | [NAME] | 11 |  |  |  |  | [NAME] | 11
 | c | helen | 12 |  |  |  |  | [NAME] | 17
 | a | bob | 13 |  |  |  |  | Grand Total | 28
 | a | [NAME] | 14
 | d | [NAME] | 15
 | e | mark | 16
 | b | [NAME] | 17
 | c | natalia | 18
 | c | [NAME] | 19
 | d | ross | 20
 | c | anna | 21
 | a | [NAME] | 22
 | Company | A | Amount
Spreadsheet: 001132f7-c09c-49a9-9a67-da2ca8d1bebf
Sheet: Sheet1

FIFTH THIRD BANCORP | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
SC 13G/A
06/10/2014
Common Stock
1 |  | NAMES OF REPORTING PERSONS
 |  | I.R.S. IDENTIFICATION NOS. OF ABOVE PERSONS
 |  | (ENTITIES ONLY)
 |  | Fifth Third Bancorp. IRS Identification
 |  | Number 31-0854434
2 |  | CHECK THE APPROPRIATE BOX IF A MEMBER OF
 |  | A GROUP (See Instructions)
 |  | (a) (b)
3 |  | SEC USE ONLY
4 |  | CITIZENSHIP OR PLACE OF ORGANIZATION
 |  | Ohio
NUMBER OF |  |  |  | 5 |  | SOLE VOTING POWER
SHARES
BENEFICIALLY OWNED BY |  |  |  |  |  | 151400
EACH |  |  |  | 6 |  | SHARED VOTING POWER
REPORTING
PERSON WITH |  |  |  |  |  | 9242
 |  |  |  | 7 |  | SOLE DISPOSITIVE POWER
 |  |  |  |  |  | 106616
 |  |  |  | 8 |  | SHARED DISPOSITIVE POWER
 |  |  |  |  |  | 54026
9 |  | AGGREGATE AMOUNT BENEFICIALLY OWNED BY
 |  | EACH REPORTING PERSON
 |  | 160642
10 |  | CHECK IF THE AGGREGATE AMOUNT IN ROW (9)
 |  | EXCLUDES CERTAIN SHARES
 |  | (See Instructions)
11 |  | PERCENT OF CLASS REPRESENTED BY AMOUNT
 |  | IN ROW (9)
 |  | 2.37%
12 |  | TYPE OF REPORTING PERSON (See Instructions)
 |  | HC
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 163343d1340282393-transfer-contents-of-a-cell-to-next-available-blank-cell-in-another-worksheet-example
Sheet: Sheet2

####### | ######## | ####### | ######## | Cell | Cell | Cell | Cell
####### | ######## | ####### | ######## | Contents | Contents | Contents | Contents
####### | ######## | ####### | ######## | to | to | to | to
####### | ######## | ####### | ######## | be | be | be | be
####### | ######## | ####### | ######## | moved | moved | moved | moved
Spreadsheet: 778389d1651046884-fetching-cell-value-with-multiple-criteria-book3
Sheet: Format Auto

 | Pulse | in | Season | Rabi |  | Pulse | in | Season | Kharif
 | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha) |  | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha)
 | Horse-Gram |  |  |  |  | Cowpea(Lobia)
 | Moong(Green Gram) |  |  |  |  | Horse-Gram
 | Other Rabi Pulses |  |  |  |  | Moong(Green Gram)
 | Urad |  |  |  |  | Other Kharif Pulses
 |  |  |  |  |  | Urad
 | Cereal | in | Season | Rabi |  | Cereal | in | Season | Kharif
 | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha) |  | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha)
 | Jowar |  |  |  |  | Jowar
 | Maize |  |  |  |  | Maize
 | Ragi |  |  |  |  | Ragi
 | [NAME] |  |  |  |  | [NAME]
 | Small Millets |  |  |  |  | Small Millets
 | Oilseeds | in | Season | Rabi |  | Oilseeds | in | Season | Kharif
 | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha) |  | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha)
 | Spices | in | Season | Rabi |  | Spices | in | Season | Kharif
 | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha) |  | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha)
 | Other Crops
 | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha) | Season
Spreadsheet: 94764d1294527067-calculating-hours-roster-2011
Sheet: we 9.1.11

 |  |  | Week 1 |  |  |  |  |  |  | CASH | BANK | HOURS | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
ROSTER | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Date | 3
RYAN | * | on | on | night | night | night | *
[NAME] | on | * | * | day | on | on | on
BAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | on | * | * | day | on | on | on
GLEN | * | * | 6-cl | 6-cl | 5-cl | 8-cl | * |  | 10 |  |  |  |  |  | 6.5 | 7 | 10.5 | 8
PAURIC | 11-6 | 11-6 | * | * | 6-10 10-cl | 6-10 10-cl | * |  | 11 |  |  |  | 6.5 | 6.5 |  |  | 10 | 10
KELO | * | * | 11-6 | 11-6 | 11-6 | 11-6 | 11-6 |  | 10 |  |  |  |  |  | 6.5 | 6.5 | 6.5 | 6.5 | 6.5
RACHAEL | * | * | * | * | * | * | * |  | 10
HANNA | * | * | * | * | 11-cl | 11-cl | * |  | 9 |  |  |  |  |  |  |  | 4 | 4
FLOOR
DANA | * | 11-6 | 11-6 | 11-6 | 11-6 | 6-cl | * |  | 10 |  |  |  |  | 6.5 | 6.5 | 6.5 | 6.5 | 6
JEN | 11-4 | * | * | * | * | 12-4 6-cl | * |  | 10 |  |  |  | 5 |  |  |  |  | 7.5
[NAME] | 6-cl | * | 12-3 6-cl | 1-4 | 1-4 8-10 10-cl | 8-10 10-cl | * |  | 10 |  |  |  | 6.5 |  |  | 4 | 8 | 8
RORY | * | 12-3 | * | * | * | * | 11-4 6-cl |  | 9 |  |  |  |  | 3 |  |  |  | 6.5
ALISHA | 12-6 | 12-4 6-cl | 12-4 | * | 12-3 5-cl | 11-6 | * |  | 9 |  |  |  | 5.5 |  | 4 |  | 7.5 | 4
MARY | H | H | H | H | H | H | * |  | 9
MIKEY | 6-cl | * | * | 6-cl | 6-12 12-cl | 7-12 12-cl | 12-6 |  | 9 |  |  |  | 6.5 |  |  | 6.5 | 10 | 9 | 5.5
CAOIMHE | 12-3 | * | * | 12-3 | 5-cl cash | cashdesk | * |  | 9 |  |  |  | 3 |  |  | 3 | 4 | 4
BAR BACKS
ANDY | * | * | * | * | 8-cl | 8-cl | * |  | 9 |  |  |  |  |  |  |  | 9 | 9
LEON | * | * | * | * | 10-cl | 10-cl | * |  | 9 |  |  |  |  |  |  |  | 8 | 8
[NAME] | * | * | * | * | * | * | * |  | 9
LILLY | * | * | * | * | 10-cl | 10-cl | * |  | 9 |  |  |  |  |  |  |  | 8 | 8
MELODY | * | * | * | * | 10.45-cl | 10.45-cl | * |  | 9 |  |  |  |  |  |  |  | 7.25 | 7.25
Opening | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Closing | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
CELLER
PIOTR | 8-2 | 8-2 | 8-2 | 8-2 | 8-2 | * | * |  | 12.5 |  |  |  | 5.5 | 5.5 | 5.5 | 5.5 | 5.5
* | * | * | * | * | * | * | * |  | 9
VALI | H | H | H | H | H | H | H |  | 9
SAMUEL | 9-12 | 9-12 | 9-12 | 9-12 | 9-12 | 9-4 | 9-4 |  | 9 |  |  |  | 3 | 3 | 3 | 3 | 3 | 7 | 7
 |  |  |  |  |  |  |  |  |  | GROSS |  |  | TOTAL HOURS
 |  |  |  |  |  |  |  |  |  |  |  | PRSI
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 11c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency Basis | 10 | 15 | 24 | 53 | 97 | 117 | 71 | 7 | 394
Cross-Currency Fixed-Fixed | 7 | 1 | 5 | 6 | 22 | 18 | 26 | - | 85
Cross-Currency Fixed-Float | 5 | 4 | 19 | 30 | 60 | 30 | 12 | - | 160
TOTAL | 22 | 20 | 48 | 89 | 179 | 165 | 109 | 7 | 639
Spreadsheet: d7867f4c-9488-473f-8c6b-c2fedc953139
Sheet: Denial Rate Trend By Income

 | 2006 | 2007 | 2008 | 2009 | 2010
0-30% MFI | 0 | 0 | 0.2 | 0.4444444444444444 | 0.2972972972972973
31-50% MFI | 0.9230769230769231 | 0.4545454545454545 | 0.3472222222222222 | 0.1425661914460285 | 0.09780775716694773
51-80% MFI | 0.09248554913294797 | 0.2016129032258064 | 0.1468609865470852 | 0.07678328032712403 | 0.06120218579234973
81-95% MFI | 0.08045977011494253 | 0.169811320754717 | 0.1281198003327787 | 0.07547169811320754 | 0.03176620076238882
>95% MFI | 0.09473684210526316 | 0.1263537906137184 | 0.1107011070110701 | 0.06592465753424658 | 0.04740740740740741
Spreadsheet: 768184d1644871463-creating-a-dynamic-list-that-pulls-from-one-tab-to-another-based-on-a-criteria-cohort-tracking-consolidated
Sheet: E3200 M22

Full Name | Status | [NAME] | District | Position | Manager / Sponsor | Manager / Sponsor Email | Appv'd by district | Date Appv'd | ASD / AECRM | [NAME]? | AP #1 | AP #2 | DG # | DG Topic | Chairperson Report | Panel Member 2 | Panel Member 2 E-mail Address | Panel Member 3 | Panel Member 3 E-mail Address | Panel Member 4 (Optional) | Panel Member 4 E-mail Address | Panel Member 5 (Optional) | Panel Member 5 E-mail Address | Webinar #1 Participation | Commitment Rec'd? | Coaching: PI Assess | Post DG Assignments | Module 1 | Webinar #2 Participation | DG - Clarify Values | [NAME] | Module 2 | Webinar #3 Participation | Module 5 | Webinar #4 Participation | DG - The Power of Purpose | DG - How Great Leaders Inspire Action | Module 4 | Webinar #5 Participation | DG -  Reaching Your Potential | DG -  Receiving Feedback | Coaching: Goal Setting | Submit PAP | Module 5 | Webinar #6 Participation | DG - PCL Executive Speech on Development  Planning | Module 6 | Webinar #7 Participation | PAP Presentation #1 | [NAME] in the Real World | PAP Presentation #2 | Coaching Check-in | Module 7 | Webinar #8 Participation | Module 8 | myPCL [NAME] submitted | Qualtrics  Results?
[NAME] Testing |  |  |  |  | testspon1 | [EMAIL] |  |  | AECRM
[NAME] |  |  |  |  | testspon2 | [EMAIL] |  |  | ASD
Spreadsheet: 747964d1631807122-autofill-but-from-a-different-sheet-autofill-cells-from-different-sheets
Sheet: Sheet1

 | Date/Name | [NAME] | [NAME] | [NAME] | [NAME]
 | 2021-01-01 00:00:00 |  |  |  |  |  | So, the input for the 1st row is from 'January' sheet. I want Excel to recognize the pattern, so that I can use autofill without going to each month and referncing cells.
 | 2021-02-01 00:00:00
 | 2021-03-01 00:00:00
 | 2021-04-01 00:00:00
 | 2021-05-01 00:00:00 |  |  |  |  |  | The issue is that if I drag [NAME] (70) down, Excel will refer to [NAME], [NAME], and so on - for each of the data points [C3:F3].
Spreadsheet: 875887d1722514420-automatically-expand-table-1-after-adding-data-to-table-2-testfile
Sheet: Table 1

Nutricontrol |  |  |  |  |  |  | NIR
Monsternummer | Datum | Productsoort | Monsternummer klant | Aufrere | Vocht 80°C (vacuum) | Ruw eiwit (Kjeldahl, 6,25) | NIR-code | GS/EP | Controle | Aufrere2 | Moisture103 | Protein625
If new data is added in "Table 2" than I want to automatically expand the table above to include the data.
Spreadsheet: 850708d1701097920-creating-a-list-from-a-table-using-multiple-criteria-book2-namiridite-
Sheet: Sheet2

 | Person | [NAME] | (From drop down list) |  |  |  | (Cells that will be hidden that give information based on drop down list and IF stataments)
 | Item | IP | (From drop down list) |  |  |  | Category | Bananas
 |  |  |  |  |  |  | Code | IP*-IPKL | Some items will have simple codes, but in instances such as what I am calling IPKL, I would want these excluded from the results, as IPKL would be it's own item. I am also not sure if referencig this cell will make use of the asterisk
 | Number | 8 | Number randomly selected from list 3 |  |  |  | Date | 2023-11-01 00:00:00
 |  |  |  |  |  |  | List 1 |  |  |  |  |  |  | List 2 |  |  |  |  |  |  | List 3
 |  |  |  |  |  |  | Here I want a list of numbers for items that have the chosen person from the Person column, and the same for Category and Code, and the date should be after the date in I5 |  |  |  |  |  |  | Here I want a list of numbers for items that have the chosen person from the Person column, and the same item, but this time from tracker 2, and the date should be after the date in I5 |  |  |  |  |  |  | List 1 minus [NAME]
 |  |  |  |  |  |  | Example: |  |  |  |  |  |  | Example: |  |  |  |  |  |  | Example:
 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 8
Spreadsheet: 169159d1342713912-unique-values-without-remove-duplicates-sample
Sheet: Sheet1

 |  |  | What it Should BE!
salearners.co.za | 41.215.236.76 |  | 1 | As this is the first occurrence of the duplicate it must be counted, all subsequent ones should be 0.
salearners.co.za | 41.215.236.76 |  | 0
salearners.co.za | 41.76.211.235 |  | 1
k53.gavinhoole.ws | 66.43.60.212 |  | 1
salearners.co.za | 74.54.27.173 |  | 1
getyourlearners.co.za | 74.55.245.28 |  | 1
k53.gavinhoole.ws | 78.46.99.8 |  | 1
salearners.co.za | 78.46.99.8 |  | 1
getyourlearners.co.za | 85.25.120.116 |  | 1 | As this is the first occurrence of the duplicate it must be counted, all subsequent ones should be 0.
getyourlearners.co.za | 85.25.120.116 |  | 0
k53.gavinhoole.ws | 85.25.120.116 |  | 1 | As this is the first occurrence of the duplicate it must be counted, all subsequent ones should be 0.
k53.gavinhoole.ws | 85.25.120.116 |  | 0
salearners.co.za | 85.25.120.116 |  | 1 | As this is the first occurrence of the duplicate it must be counted, all subsequent ones should be 0.
salearners.co.za | 85.25.120.116 |  | 0
Spreadsheet: 174442d1345057246-scoreboard-wins-1-up-updated-test-course
Sheet: Testing

 |  |  | Test Course
 |  |  |  |  | Eagle |  | [NAME] |  | Par |  | [NAME] |  |  |  |  |  | 2Bogey+
 |  |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Count of GIR | Number of holes - par 3's | Missed Left | Missed Right | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOTAL
Flag | ID | Name | PAR | 4 | 5 | 4 | 3 | 4 | 4 | 4 | 4 | 4 |  |  |  |  |  | 4 | 4 | 4 | 4 | 3 | 5 | 4 | 4 | 4
 | 1 | [NAME] | SCORE | 4 | 4 | 3 | 5 | 4 | 4 | 5 | 4 | 4 |  |  |  |  |  | 3 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4
 |  |  | [NAME]?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OUT |  |  |  |  |  |  |  |  |  | IN | TOTAL
Flag | ID | Name | PAR | 4 | 5 | 4 | 3 | 4 | 4 | 4 | 4 | 4 |  |  |  |  |  | 4 | 4 | 4 | 4 | 3 | 5 | 4 | 4 | 4
 | 2 | [NAME] | SCORE | 4 | 4 | 3 | 4 | 3 | 4 | 3 | 5 | 4 |  |  |  |  |  | 3 | 4 | 4 | 4 | 3 | 5 | 5 | 3 | 4
 |  |  | [NAME]?
 |  |  | DESIRED RESULT
 |  |  | Leading? |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 |  | 2 | 2 | [NAME]
 |  |  | [NAME]? | AS | AS | 1UP | 2UP | 2UP | 3UP | 2UP | 2UP | 2UP |  |  |  |  |  | 2UP | 2UP | 2UP | 2UP | 2UP | 1UP | AS | 1UP | 1UP | Wins 1up
 |  |  | EXAMPLE
Spreadsheet: fc46409f-182c-4630-8904-6676352f18a7
Sheet: Sheet1

Table S13 - Topological network properties | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Network properties of orphans compared to annotated genes
PI, GC and integrated PI+GC networks
Network Property | PI | GC | Integrated_PI+GC
Degree | 5.66 / 10.06* (<0.001**) | 20.65 / 35.65 (<0.001) | 22.63 / 39.33 (<0.001)
Clustering Coefficient | 0.091/0.106 (<0.036) | 0.272 / 0.267 | 0.249 / 0.246
Betweenness | 1012 / 2262 (<0.001) | 2617 / 4161 (<0.001) | 2315 / 4072 (<0.001)
Closeness | 122 / 96 (<0.021) | 227 / 269 (<0.019) | 181 / 239 (<0.002)
*Orphan/Annotated Genes
**P-values correspond to the significance of orphans to have lower or higher value of a property compared to
annotated genes in a given network, based on 1000 randomizations. Only P-values at a significance level <0.1 are shown.
Spreadsheet: 787184d1657660969-sum-the-expenses-by-month-groups-of-contractors-sum-the-expenses-by-month-groups-of-contractors
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: 840466d1692758357-generate-a-random-number-help2
Sheet: Sheet1

Customer | Counter | Reference
TEST1
TEST1
TEST1
TEST2
TEST3
TEST3
TEST4
TEST5
TEST5
TEST5
TEST6
TEST6
TEST6
TEST7
TEST7
TEST7
TEST8
TEST8
Spreadsheet: 349217d1412253564-problem-related-representation-test-csv-1-
Sheet: Sheet2

USER | last_name | blood_GROUP | work | location | email | row
Spreadsheet: 55069d1255142499-iteration-702631-iteration-issue
Sheet: Sheet2

repeats
4 | GigabitEthernet, 1/0/1 - 48,GigabitEthernet, 2/0/1 - 48,GigabitEthernet, 3/0/1 - 48,GigabitEthernet, 4/0/1 - 48, | GigabitEthernet, 1/0/1 - 48, | GigabitEthernet, 2/0/1 - 48, | GigabitEthernet, 3/0/1 - 48, | GigabitEthernet, 4/0/1 - 48,
1 | GigabitEthernet, 1/0/1 - 48, | GigabitEthernet, 1/0/1 - 48,
2 | GigabitEthernet, 1/0/1 - 48,GigabitEthernet, 2/0/1 - 48, | GigabitEthernet, 1/0/1 - 48, | GigabitEthernet, 2/0/1 - 48,
3 | GigabitEthernet, 1/0/1 - 48,GigabitEthernet, 2/0/1 - 48,GigabitEthernet, 3/0/1 - 48, | GigabitEthernet, 1/0/1 - 48, | GigabitEthernet, 2/0/1 - 48, | GigabitEthernet, 3/0/1 - 48,
5 | GigabitEthernet, 1/0/1 - 48,GigabitEthernet, 2/0/1 - 48,GigabitEthernet, 3/0/1 - 48,GigabitEthernet, 4/0/1 - 48,GigabitEthernet, 5/0/1 - 48, | GigabitEthernet, 1/0/1 - 48, | GigabitEthernet, 2/0/1 - 48, | GigabitEthernet, 3/0/1 - 48, | GigabitEthernet, 4/0/1 - 48, | GigabitEthernet, 5/0/1 - 48,