tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92984d1292501364-show-overlapping-fys-from-a-start-date-and-duration-fy-overlap
Sheet: Sheet1

ERROR-PRONE METHOD |  |  |  |  |  |  | 8(Oct 2007-Sep 2008) | NA
Traing Start Date | 2010-05-05 00:00:00 |  |  |  |  |  | 9(Oct 2008-Sep 2009) | 8(Oct 2007-Sep 2008)
FY of trainng Start Date | 0(Oct 2009-Sep 2010) |  |  |  |  |  | 0(Oct 2009-Sep 2010) | 9(Oct 2008-Sep 2009)
1st FY of overlap | 1(Oct 2010-Sep 2011) |  |  |  |  |  | 1(Oct 2010-Sep 2011) | 0(Oct 2009-Sep 2010)
2nd FY of overlap | 8(Oct 2007-Sep 2008) |  |  |  |  |  | 2(Oct 2011-Sep 2012) | 1(Oct 2010-Sep 2011)
Accounting Line | 2102070 & 2112070 & 2182070 24-2512 |  |  |  |  |  | 3(Oct 2012-Sep 2013) | 2(Oct 2011-Sep 2012)
 |  |  |  |  |  |  | 4(Oct 2013-Sep 2014) | 3(Oct 2012-Sep 2013)
 |  |  |  |  |  |  | 5(Oct 2014-Sep 2015) | 4(Oct 2013-Sep 2014)
 |  |  |  |  |  |  | 6(Oct 2015-Sep 2016) | 5(Oct 2014-Sep 2015)
ERROR-FREE METHOD |  |  |  |  |  |  | 7(Oct 2016-Sep 2017) | 6(Oct 2015-Sep 2016)
Traing Start Date | 2010-05-05 00:00:00 |  |  |  |  |  | 8(Oct 2017-Sep 2018) | 7(Oct 2016-Sep 2017)
Duration of Training (days) | 760 |  |  |  |  |  | 9(Oct 2018-Sep 2019) | 8(Oct 2017-Sep 2018)
Accounting Line | 2102070 & 21 HELP ( 1) 2070 & 21 HELP (2) 2070 24-2512 |  |  |  |  |  |  | 9(Oct 2018-Sep 2019)
Spreadsheet: 122759d1317134570-sum-does-not-work-sum_test
Sheet: Foglio1

1.811,66-
1.811,66-
1.000,15
1.000,15-
5.300,00
5.300,00
2.900,30
1.735,81
1.351,62
1.450,09
3.503,20
1.500,02
900,11
727,00
1.425,36
1.199,82
1.800,05
3.805,60
3.805,60-
3.639,15
3.639,15-
3.639,15
719,89
149,97
199,98
3.600,45
3.600,45-
1.099,99-
225,12
299,96
1.199,97
1.199,97-
2.044,27
370,81
4.442,07
1.667,91
4.000,23
187,55
249,97
650,11
1.675,27
879,99
1.595,10
2.750,50
4.400,00
4.399,97
2.992,73
2.110,29
499,93
2.000,25
3.695,00
842,00
1.448,70-
1.159,20
4.127,20
3.900,16
Spreadsheet: 869928d1716466767-required-multilevel-sequence-serial-numbers-book11-new
Sheet: Sheet1

 |  |  |  |  |  |  |  | Helper columns
 | C-Title | M-Title | CM Index | CM Title |  |  |  | B Count | M Count | CM Count
 | Area-1 | Topic-1 |  | Statement-1
 |  |  |  | Statement-2 |  |  |  | CM-1. | 1.
 |  |  |  | Statement-3 |  |  |  | CM-1. | 1.
 |  | Topic-2 |  | Statement-4 |  |  |  | CM-1. | 2.
 |  |  |  | Statement-5 |  |  |  | CM-1. | 2.
 |  |  |  | Statement-6 |  |  |  | CM-1. | 2.
 |  |  |  | Statement-7 |  |  |  | CM-1. | 2.
 |  | Topic-3 |  | [NAME] |  |  |  | CM-1. | 3.
 |  |  |  | Statement-9 |  |  |  | CM-1. | 3.
 | Area-2 | Topic-A |  | Statement-10 |  |  |  | CM-2. | 1.
 |  |  |  | Statement-11 |  |  |  | CM-2. | 1.
 |  |  |  | Statement-12 |  |  |  | CM-2. | 1.
 |  |  |  | Statement-13 |  |  |  | CM-2. | 1.
 |  | Topic-B |  | Statement-14 |  |  |  | CM-2. | 2.
 |  |  |  | Statement-15 |  |  |  | CM-2. | 2.
 |  |  |  | [NAME] |  |  |  | CM-2. | 2.
 |  |  |  | Statement-17 |  |  |  | CM-2. | 2.
 |  |  |  | Statement-18 |  |  |  | CM-2. | 2.
 |  |  |  | [NAME] |  |  |  | CM-2. | 2.
 |  | Topic-C |  | Statement-20 |  |  |  | CM-2. | 3.
 |  |  |  | Statement-21 |  |  |  | CM-2. | 3.
 |  |  |  | Statement-22 |  |  |  | CM-2. | 3.
 | Area-3 | Topic-X1 |  | Statement-23 |  |  |  | CM-3. | 1.
 |  |  |  | Statement-24 |  |  |  | CM-3. | 1.
 |  |  |  | Statement-25 |  |  |  | CM-3. | 1.
 |  |  |  | Statement-26 |  |  |  | CM-3. | 1.
 |  |  |  | Statement-27 |  |  |  | CM-3. | 1.
 |  | Topic-X2 |  | Statement-28 |  |  |  | CM-3. | 2.
 |  |  |  | Statement-29 |  |  |  | CM-3. | 2.
 |  |  |  | Statement-30 |  |  |  | CM-3. | 2.
 |  |  |  | Statement-31 |  |  |  | CM-3. | 2.
 |  | Topic-X3 |  | Statement-32 |  |  |  | CM-3. | 3.
 |  |  |  | [NAME] |  |  |  | CM-3. | 3.
 |  |  |  | Statement-34 |  |  |  | CM-3. | 3.
 |  |  |  | Statement-35 |  |  |  | CM-3. | 3.
 |  |  |  | Statement-36 |  |  |  | CM-3. | 3.
 |  |  |  | Statement-37 |  |  |  | CM-3. | 3.
 |  | Topic-X4 |  | Statement-38 |  |  |  | CM-3. | 4.
 |  |  |  | Statement-39 |  |  |  | CM-3. | 4.
 |  |  |  | Statement-40 |  |  |  | CM-3. | 4.
 |  |  |  | Statement-41 |  |  |  | CM-3. | 4.
 |  |  |  | Statement-42 |  |  |  | CM-3. | 4.
 |  |  |  | Statement-43 |  |  |  | CM-3. | 4.
 | Area-4 | Topic-A-1 |  | Statement-44 |  |  |  | CM-4. | 1.
 |  |  |  | Statement-45 |  |  |  | CM-4. | 1.
 |  |  |  | Statement-46 |  |  |  | CM-4. | 1.
 |  |  |  | Statement-47 |  |  |  | CM-4. | 1.
 |  | Topic-Z-1 |  | Statement-48 |  |  |  | CM-4. | 2.
 |  |  |  | Statement-49 |  |  |  | CM-4. | 2.
 | Area-5 | Topic-Z-2 |  | Statement-50 |  |  |  | CM-5. | 1.
 |  |  |  | Statement-51 |  |  |  | CM-5. | 1.
 |  |  |  | Statement-52 |  |  |  | CM-5. | 1.
 |  | Topic-Z-5 |  | Statement-53 |  |  |  | CM-5. | 2.
Spreadsheet: 106972d1304106248-type-of-lookup-function-sample
Sheet: Main

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Split
Loan # | Consultant | Disburse Date | [NAME]? | Loan Amount | Borrower | Investor | LP/BP | Costs Paid | Units | Date | Source | Type | Title | Fee | Fee | Gross | Comm. Rate | Comm. Rate | Comm. Rate | BONUS | Proc | PROC | Check Amt | Bonus Chk
1 | Sean | 2011-04-04 00:00:00 | S | 99000 | Schmoe | Fifth Third | LP |  |  | 2011-04-08 00:00:00 | TELE |  |  | 2227.5 | 2227.5 | 2227.5 | 50 | 25 | 15 | 40 | 217.8 | 108.9 | 39.59999999999999 | 396
2 | [NAME] | 2011-04-04 00:00:00 | S | SPLIT | Schmoe | Fifth Third | LP |  |  | 2011-04-08 00:00:00 | SELF |  |  |  | 2227.5 | 2227.5 | 50 | 25 | 25 | 40 | 217.8 | 108.9 | 138.6
3 | [NAME] | 2011-04-08 00:00:00 |  | 133000 | Travis | Union | BP |  |  | 2011-04-22 00:00:00 | PC |  |  | 2992.5 | 2992.5 | 2992.5 | 90 | 90 | 90 | 0 | 375 | 375 | ZERO-BP | 0
4 | [NAME] | 2011-04-11 00:00:00 |  | 404000 | [NAME] | Liberty | LP |  |  | 2011-04-22 00:00:00 | SELF |  |  | 8080 | 8080 | 8080 | 90 | 90 | 90 | 20 | 550 | 550 | 3086 | 808
5 | [NAME] | 2011-04-12 00:00:00 |  | 311550 | Dillhole | Fifth Third | LP |  |  | 2011-04-22 00:00:00 | TELE |  |  | 7009.875 | 7009.875 | 7009.875 | 90 | 90 | 80 | 20 | 550 | 550 | 1942.4 | 623.1
6 | [NAME] | 2011-04-12 00:00:00 |  | 233420 | Butts | [NAME] | LP |  |  | 2011-04-22 00:00:00 | SELF |  |  | 5251.95 | 5251.95 | 5251.95 | 50 | 50 | 50 | 40 | 375 | 375 | 792.1000000000001 | 933.6800000000001
7 | Sean | 2011-04-18 00:00:00 |  | 277000 | Richards | Fifth Third | LP |  |  | 2011-04-22 00:00:00 | PC |  |  | 6232.5 | 6232.5 | 6232.5 | 50 | 50 | 50 | 40 | 375 | 375 | 1010 | 1108
8 | Todd | 2011-04-21 00:00:00 |  | 187500 | Frankfurt | Union | LP |  |  | 2011-04-22 00:00:00 | SELF |  |  | 4218.75 | 4218.75 | 4218.75 | 65 | 65 | 65 | 0 | 375 | 375 | 843.75 | 0
9 | Sean | 2011-04-22 00:00:00 |  | 145000 | [NAME] | Franklin | LP |  |  | 2011-05-06 00:00:00 | TELE |  |  | 3262.5 | 3262.5 | 3262.5 | 50 | 50 | 40 | 40 | 375 | 375 | 205 | 580
10 | [NAME] | 2011-04-22 00:00:00 |  | 267000 | [NAME] | Liberty | LP |  |  | 2011-05-06 00:00:00 | PC |  |  | 5340 | 5340 | 5340 | 50 | 50 | 50 | 40 | 375 | 375 | 960 | 1068
11 | [NAME] | 2011-04-23 00:00:00 |  | 300133 | Franklin | Fifth Third | LP |  |  | 2011-05-06 00:00:00 | TELE |  |  | 6752.992499999999 | 6752.992499999999 | 6752.992499999999 | 90 | 90 | 80 | 0 | 550 | 550 | 1851.064 | 0
Spreadsheet: 48284d1247515075-comparing-values-and-adding-a-field-vlookup_rep_name
Sheet: Sheet1

Account Name | Member Rep | Random Account Name | Lookup Result
Company 1 | Rep 1 | Company 3 | Rep 3
Company 2 | Rep 2 | Company 20 | Rep 20
Company 3 | Rep 3 | Company 17 | Rep 17
Company 4 | Rep 4 | Company 6 | Rep 6
Company 5 | Rep 5 | Company 11 | Rep 11
Company 6 | Rep 6 | Company 4 | Rep 4
Company 7 | Rep 7 | Company 19 | Rep 19
Company 8 | Rep 8 | Company 9 | Rep 9
Company 9 | Rep 9 | Company 15 | Rep 15
Company 10 | Rep 10 | Company 12 | Rep 12
Company 11 | Rep 11 | Company 5 | Rep 5
Company 12 | Rep 12 | Company 18 | Rep 18
Company 13 | Rep 13 | Company 13 | Rep 13
Company 14 | Rep 14 | Company 1 | Rep 1
Company 15 | Rep 15 | Company 8 | Rep 8
Company 16 | Rep 16 | Company 10 | Rep 10
Company 17 | Rep 17 | Company 14 | Rep 14
Company 18 | Rep 18 | Company 16 | Rep 16
Company 19 | Rep 19 | Company 7 | Rep 7
Company 20 | Rep 20 | Company 2 | Rep 2
Spreadsheet: 92727d1292278109-scroll-bar-wont-stop-scrolling-scroll-bar-example-working
Sheet: northeast

employee # | sales $
1118 | 22324.61933621217
1119 | 46938.46895515526
1120 | 18905.66814303627
1121 | 85754.54668314659
1122 | 64965.18404485026
 | 1 | jan
jan
feb
[NAME]
apr
may
jun
Spreadsheet: 83543d1283509153-display-text-between-space-x-and-x-from-cell-example
Sheet: Sheet1

Data |  |  |  |  | [NAME] |  | Number required
00118385 B L S SL 10G 13 24 29.58 384.54 01/03/2011 |  |  |  |  | 13 |  | 13
00135641 * W C B M CN 133 24 36.21 1194.93 01/03/2011 |  |  |  |  | 133 |  | 133
00163514 * C LDTPDN AFTECKSRATE 3 12 23.52 70.56 01/03/2011 |  |  |  |  | #N/A |  | 3
00163521 * B LHG AFTECKSRATE 10 12 25.13 251.30 01/03/2011 |  |  |  |  | #N/A |  | 10
00243032 V E DTEBYDF AFTECKSRAE 3 12 24.35 73.05 19/04/2011 |  |  |  |  | #N/A |  | 3
00247108 * E W CRWOPDE TODAGESE 3 24 10.18 30.54 01/03/2011 |  |  |  |  | #N/A |  | 3
00323352 P O TTDS CLDTPDN 75G 36 12 5.40 194.40 01/03/2011 |  |  |  |  | #N/A |  | 36
00366656 * T OYDQD PRURF TUBE 31 12 4.80 148.80 01/03/2011 |  |  |  |  | #N/A |  | 31
00409476 * H EACH SFMBRT NI ZSRKG 3 24 17.34 52.02 01/03/2011 |  |  |  |  | #N/A |  | 3
00422888 * M FQDRONSA NI ZSRKG 3 24 18.48 55.44 01/03/2011 |  |  |  |  | #N/A |  | 3
00444613 * H RT CLDTPDN CRUBN 25 12 17.64 441.00 01/03/2011 |  |  |  |  | #N/A |  | 25
00444620 M E SV CLDTP CRUBN 20 12 18.48 369.60 01/03/2011 |  |  |  |  | #N/A |  | 20
00444637 C L DTPDN CRUBN 30 12 18.84 565.20 01/03/2011 |  |  |  |  | #N/A |  | 30
00444644 C L DTPDN CRUBN KDSETB 30 12 21.12 633.60 01/03/2011 |  |  |  |  | #N/A |  | 30
00444651 * R ZUUF & JGRW CLDTPDN 12 12 18.72 224.64 01/03/2011 |  |  |  |  | #N/A |  | 21
00444675 H R T YNGF CRUBN 36 12 21.84 786.24 01/03/2011 |  |  |  |  | #N/A |  | 36
00444712 [NAME] YNGF 20 12 21.96 439.20 01/03/2011 |  |  |  |  | 20 |  | 20
00444729 * F GHNVX CLDTP GRYBD 12 12 14.64 175.68 01/03/2011 |  |  |  |  | #N/A |  | 12
00444736 [NAME] 12 12 9.84 118.08 01/03/2011 |  |  |  |  | #N/A |  | 12
00477178 T FGISW ERAC 30 12 19.80 594.00 01/03/2011 |  |  |  |  | 30 |  | 30
00490382 T H DHKAB GENITR 213G 40 24 27.40 1096.00 01/03/2011 |  |  |  |  | #N/A |  | 40
00495288 T R GHCADG THDHKAB GENITR 3 12 29.45 88.35 01/03/2011 |  |  |  |  | #N/A |  | 3
Spreadsheet: 234072d1368001247-golf-analysis-spreadsheet-help-squire82-20130507-v2
Sheet: Sheet1

Weather | S, W
Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total
Par | 3 | 4 | 3 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 4 | 3 | 4 | 65
Score | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 6 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 72
FH |  | 1 |  | 0 | 1 | 0 |  | 1 | 1 | 0 |  |  |  | 1 | 1 | 0 |  | 1 | 7
GIR | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 9
Putts | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 33
Chip | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 6
Pitch | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
U&D | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 3
Penalty | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | D | D | 4 | D | 4 | D | P | D | D | D | 5 | 6 | 5w | 5w | 3w | D | 9 | 3w
Approach |  | S |  | 5w | L | 5w |  | 5 | 8 | 7 |  |  |  | P | L | S |  | L
0 - 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 2 | 1 | 18
6 -10 | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 5
11 - 20 |  | 1 |  |  |  |  | 1 |  | 1 |  | 1 | 1 |  |  | 1 |  |  | 1 | 7
21+ |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  | 3
Club Analysis |  |  |  |  | Missed Green Analysis |  |  |  |  |  |  |  |  | GIR Analysis
Club | Shots | Success |  |  | Shot |  | No. | Tot Putts |  | U&D |  |  |  | Below Par |  | 0
D | 8 | 3 |  |  | Chip |  | 6 | 9 |  | 3 |  |  |  | At Par |  | 9
3w | 2 | 2 |  |  | Pitch |  | 3 | 6 |  | 0 |  |  |  | Above Par |  | 0
5w | 4 | 2 |  |  | [NAME] |  | 0 | 0 |  | 0
4 | 2 | 1
5 | 2 | 1 |  |  | Putting Analysis |  |  |  |  |  |  |  |  | Par Performance
6 | 1 | 0 |  |  | Putts |  |  | 33 |  |  |  |  |  | Par 3 |  |  | 2
7 | 1 | 0 |  |  | Putts per hole |  |  | 1.833333333333333 |  |  |  |  |  | Par 3 avg |  |  | 3.714285714285714
8 | 1 | 1 |  |  | % of shots |  |  | 0.4583333333333333 |  |  |  |  |  | Par 4 |  |  | 10
9 | 1 | 0 |  |  | GIR avg |  |  | 2 |  |  |  |  |  | Par 4 avg |  |  | 4.181818181818182
P | 2 | 1 |  |  | Missed GIR avg |  |  | 1.666666666666667 |  |  |  |  |  | Birdies |  |  | 0
S | 2 | 2 |  |  | [NAME] par 3 |  |  | 14 |  |  |  |  |  | Pars |  |  | 12
L | 3 | 3 |  |  | [NAME] par 4 |  |  | 19 |  |  |  |  |  | Bogeys |  |  | 5
X | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | Double Bogeys |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Front 9 - Par 3 |  |  | 2 |  | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Front 9 - Par 4 |  |  | 2 |  | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back 9 - Par 3 |  |  | 3 |  | ?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Back 9 - Par 4 |  |  | 0 |  | ?
Spreadsheet: darrell_schoolcraft__7715__saledoc03_16TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-03-15 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 3/16/2002-03/18/02 |  |  | FAX Number:
Total Quantity |  |  | 30000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.89
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
3/16/2002 | 2002-03-18 00:00:00 | 30000 |  | 10000 |  | 10000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
West Texas Pool |  |  | 58646 |  | 10000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 809907d1671429412-summarise-multiple-excel-worksheets-into-one-sheet-book1
Sheet: Raw Data 3

ID | Surname | First Name | Job | Q1 | Q2 | Q3 | Q4
2931 | Wick | [NAME] | National | 1 | 3 | 100 | 96
1591 | [NAME] | [NAME] | National | 85 | 20 | 55 | 5
1289 | [NAME] | [NAME] | International | 69 | 77 | 54 | 7
2147 | Wo | [NAME] | Customer Service | 12 | 75 | 14 | 4
Spreadsheet: 123770d1317844634-subtotaling-exampleforsubtotaling1
Sheet: Sheet1

Claim# | Coverage | TotalLossPaid
[PHONE] | Liability-CSL | 60000
 | Liability-CSL                       Total
[PHONE] Total
[PHONE] | Liability-BI | 45000
 | Liability-BI                        Total
[PHONE] | Liability-PD | 0
[PHONE] | Liability-PD | 3816.23
 | Liability-PD                        Total
[PHONE] Total
[PHONE] | Liability-BI | 100000
 | Liability-BI                        Total
[PHONE] | Liability-PD | 0
 | Liability-PD                        Total
[PHONE] | Personal Injury Protect | 10000
 | Personal Injury Protect             Total
[PHONE] Total
[PHONE] | Liability-BI | 106000
[PHONE] | Liability-BI | 30000
 | Liability-BI                        Total
[PHONE] | Liability-CSL | 0
 | Liability-CSL                       Total
[PHONE] | Liability-PD | 4690.26
[PHONE] | Liability-PD | 5968.92
 | Liability-PD                        Total
[PHONE] Total
[PHONE] | Liability-CSL | 0
[PHONE] | Liability-CSL | 74000
[PHONE] | Liability-CSL | 0
[PHONE] | Liability-CSL | 869438.65
 | Liability-CSL                       Total
[PHONE] Total
Grand Total
Spreadsheet: 735053d1622666632-sumproduct-shows-value-sumproduct-shows-value-
Sheet: 1

Nr |  |  |  | FTE | H 1 | H2 | 2021
100087 | Employee 1 | 15 | 100 | 0.5
100016 | Employee 2 | 40 | 100 | 1
100046 | Employee 3 | 40 | 100 | 1
100053 | Employee 4 | 40 | 100 | 1
100071 | Employee 5 | 40 | 100 | 1
100096 | Employee 6 | 40 | 100 | 1
Spreadsheet: 852780d1702730699-how-to-join-the-text-of-several-cells-with-a-single-comma-sample-data1
Sheet: Foaie1

 |  | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 | Field 8 | Field 9 | Result
1 | DINING1 |  | pears |  |  |  | grapes
2 | DINING2 |  |  | lemon |  | pears |  |  |  | cherries |  |  | !!!!! In the "Result" column marked with yellow, I would like to join the words from the "Field 1...9" columns, but each word separated from the other by a comma.
3 | DINING3 | oranges |  | pears
4 | DINING4
5 | [NAME] |  |  |  | grapes |  |  |  | pears | cherries
6 | DINING6 |  |  | cherries
7 | DINING7 | pears
8 | DINING8 |  |  |  | oranges
9 | DINING9 |  |  |  | pears
10 | DINING10 |  |  |  |  |  |  | pears
11 | DINING11 |  | oranges
12 | DINING12 |  |  |  |  | grapes
13 | DINING13 |  |  |  |  |  |  | oranges
14 | DINING14 | grapes
15 | [NAME] |  |  |  |  |  |  |  |  | oranges
16 | DINING16 |  | pears
17 | DINING17 |  |  |  | lemon |  | pears
18 | DINING18 |  | cherries |  |  |  |  |  |  | pears
19 | DINING19 |  |  |  |  |  |  |  | pears
20 | DINING20 |  |  | grapes
Spreadsheet: 680105d1590780886-using-isnumber-for-ifs-function-over-a-range-apartment-items-expenses
Sheet: Sheet1

 |  | Apartment Items - Expenses
 |  | Item |  | Location | Control | Price |  | A's Expenses |  |  | My attempt
 |  | Door Draft Stopper |  | Living | Both | 9.99
 |  | Room Divider |  | Bed | A | 47.99 |  | D's Expenses
 |  | [NAME] |  | Bed | A | 30.95
 |  | Coat Hanger |  | Living | Both | 19.97
 |  | Coffee Maker |  | Kitchen | A | 24.99
 |  | TV LED Strip |  | Living | Both | 13.99
 |  | Coasters |  | Living | Both | 16.99
 |  | Canvas Art |  | Living | Both | 29.9
 |  | Pillow Cover |  | Bed | A | 13.99
 |  | [NAME] |  | Bath | A | 20.99
Spreadsheet: 794626d1662149531-employee-absence-tracker-rolling-12-month-window-needed-2022-exempt-sick-test
Sheet: MAY

NAME |  | SHIFT | BADGE | DEPT | REASON | COMMENT
 | 2022-05-20 00:00:00 | 1 | 274037 | HP | Left Early
 | 2022-05-17 00:00:00 | 1 | 289680 | SP | Other
 | 2022-05-18 00:00:00 | 1 | 289680 | SP | Other
 | 2022-05-19 00:00:00 | 1 | 289680 | SP | Other
 | 2022-05-20 00:00:00 | 1 | 289680 | SP | Other
 | 2022-05-05 00:00:00 | 1 | 842479 | Shipping | Sick
 | 2022-05-18 00:00:00 | 3 | 82479 | Shipping | Left Early
 | 2022-05-12 00:00:00 | 3 | 275907 | FT | Personal
 | 2022-05-24 00:00:00 | 2 | 677114 | HP | Other
 | 2022-05-11 00:00:00 | 1 | 580586 | GP | Other
 | 2022-05-17 00:00:00 | 1 | 580586 | GP | Other
 | 2022-05-19 00:00:00 | 1 | 580586 | GP | Sick
 | 2022-05-20 00:00:00 | 1 | 580586 | GP | Sick
 | 2022-06-01 00:00:00 | 2 | 280484 | [NAME] | Arrived Late
 | 2022-05-11 00:00:00 | 1 | 677163 | RM | Sick
 | 2022-05-12 00:00:00 | 1 | 677163 | RM | Sick
 | 2022-05-13 00:00:00 | 1 | 677163 | RM | Sick
 | 2022-05-16 00:00:00 | 1 | 677163 | RM | Sick
 | 2022-05-10 00:00:00 | 2 | 18822 | SP | Sick
 | 2022-05-23 00:00:00 | 1 | 444801 | SP | Other
 | 2022-05-24 00:00:00 | 1 | 444801 | SP | Other
 | 2022-05-25 00:00:00 | 1 | 44801 | SP | Other
 | 2022-05-26 00:00:00 | 1 | 44801 | SP | Sick
 | 2022-05-09 00:00:00 | 1 | 615723 | [NAME] | FMLA
 | 2022-05-16 00:00:00 | 1 | 615723 | [NAME] | FMLA
 | 2022-05-25 00:00:00 | 1 | 615723 | [NAME] | Sick
 | 2022-05-26 00:00:00 | 1 | 615723 | [NAME] | Sick
 | 2022-05-02 00:00:00 | 1 | 289677 | [NAME] | Personal
 | 2022-05-20 00:00:00 | 1 | 289677 | [NAME] | Sick
 | 2022-05-02 00:00:00 | 1 | 285111 | GP | FMLA
 | 2022-05-05 00:00:00 | 1 | 285111 | GP | Sick
 | 2022-05-06 00:00:00 | 1 | 285111` | GP | Sick
 | 2022-05-09 00:00:00 | 1 | 285111 | GP | Sick
 | 2022-05-16 00:00:00 | 1 | 285111 | GP | FMLA
 | 2022-05-25 00:00:00 | 1 | 287111 | GP | FMLA
 | 2022-05-03 00:00:00 | 3 | 434025 | FT | Sick
 | 2022-05-02 00:00:00 | 1 | 842241 | Shipping | Personal
 | 2022-05-03 00:00:00 | 1 | 842241 | Shipping | Personal
 | 2022-05-04 00:00:00 | 1 | 842241 | Shipping | Personal
 | 2022-05-23 00:00:00 | 2 | 841627 | [NAME] | Sick
 | 2022-05-18 00:00:00 | 1 | 282157 | RM | Sick
 | 2022-05-19 00:00:00 | 1 | 282157 | RM | Sick
 | 2022-05-16 00:00:00 | 2 | 969977 | Shipping | Sick
 | 2022-05-17 00:00:00 | 2 | 969977 | Shipping | Sick
 | 2022-05-18 00:00:00 | 2 | 969977 | Shipping | Sick
 | 2022-05-19 00:00:00 | 2 | 969977 | Shipping | Sick
 | 2022-05-20 00:00:00 | 2 | 969977 | Shipping | Sick
 | 2022-05-10 00:00:00 | 1 | 841622 | IC | Sick
 | 2022-05-25 00:00:00 | 1 | 278459 | HP | Sick
 | 2022-05-26 00:00:00 | 1 | 278459 | HP | Sick
 | 2022-05-03 00:00:00 | 3 | 285518 | [NAME] | Sick
 | 2022-05-06 00:00:00 | 1 | 570698 | SP | Personal
 | 2022-05-16 00:00:00 | 1 | 272459 | Hotel | Sick
 | 2022-05-26 00:00:00 | 1 | 272459 | Hotel | Other
 | 2022-05-31 00:00:00 | 1 | 272459 | Hotel | Left Early
 | 2022-05-23 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-05-26 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-05-31 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-05-02 00:00:00 | 1 | 668536 | RL | Sick
Spreadsheet: 271907d1382104554-dynamic-comparator-text-fed-comparison
Sheet: Sheet1

 | First Value | Comparitor | Second Value | Comparitor True? | Output
 | 1 | >= | 2
 |  | Value | = | <> | > | >= | < | <=
 |  | 1 | True | False | False | True | False | True
 |  | 2 | False | True | True | True | False | False
 |  | 3 | False | True | False | False | True | True
Spreadsheet: 196817d1354116553-webimport-daily-updated-table-with-variable-number-of-objects-sample2
Sheet: IMPUT29-11

AAA
0.55
AAB
0.60
Army of the Damned
2.40
[NAME]
1.45
Champion of the Parish
1.10
Clifftop Retreat
2.55
Essence of the Wild
1.10
[NAME]
19.20
Gavony Township
1.10
Geist of Saint Traft
24.75
Grimgrin Corpse-Born
1.45
Grimoire of the Dead
1.40
Hinterland Harbor
3.10
Isolated Chapel
3.30
[NAME] of the Veil
22.50
Mikaeus the Lunarch
3.60
Mirror-Mad Phantasm
1.00
[NAME]
11.00
Past in Flames
5.50
Reaper from the [NAME]
1.30
Runechanter's Pike
0.78
Sever the Bloodline
0.62
Skaab Ruinator
1.15
[NAME]
6.95
Stromkirk Noble
1.50
[NAME]
3.10
Tree of Redemption
2.15
Woodland Cemetery
2.85
Spreadsheet: 600094d1543461222-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: FP07 Master Attendance

FP07 | Directing |  |  |  |  | Producing |  |  |  |  | Production Design |  |  |  |  | Post Production |  |  |  |  | Cinematography |  |  |  |  | Production Techniques |  |  |  |  | Story Development |  |  |  |  | Assistant Directing
[NAME] for all Disciplines for the FP Program (so far) | Present | Late | Excused | Absent | %of classes missed | Present | Late | Excused | Absent | %of classes missed | Present | Late | Excused | Absent | %of classes missed | Present | Late | Excused | Absent | %of classes missed | Present | Late | Excused | Absent | %of classes missed | Present | Late | Excused | Absent | %of classes missed | Present | Late | Excused | Absent | %of classes missed | Present | Late | Excused | Absent | %of classes missed | Present | Total Late | Total Excused | Total Absent | %of Program missed
Hui ([NAME]) Zhu
Qiran ([NAME]) Chen
[NAME] ([NAME]) [NAME]
Yuetong (Isabel) [NAME]
[NAME] (Vlad) [NAME]
Chenbo ([NAME]) Xiao
[NAME]) Lu
Chenyi (Freddie) Zhang
[NAME] ([NAME]) Fang
Jiaqing (Agnes) Kang
[NAME]
Junjie (Riol) He
Junqi (Eden) [NAME]
Linfeng (Wayne) Zhang
Muxin ([NAME]) [NAME]
Qianyun (Fay) Fang
Ruimin (Vic) [NAME]
[NAME] ([NAME]) [NAME]
Xiaochen (Seven) Qi
[NAME] (Leo) Yu
[NAME] ([NAME]) [NAME]
Xinwei (Will) [NAME]
[NAME] ([NAME]) Fu
Yiming ([NAME]) Deng
[NAME] ([NAME]) [NAME]