tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41138d1239653053-excel-workbook-data-populating-project_issue_log-1-
Sheet: Issue Template

Issue Number
Issue Title | testing
Issue Description | testing spread sheet
Impact On Project | High
Priority | High
Resolution | yes
Reported Date | 2009-08-11 00:00:00
Initiator | [NAME]
Assigned To | [NAME]
Due Date | 2009-08-12 00:00:00
Status | Open
Completion Date
Attachments
Spreadsheet: 131975d1323425027-nested-if-or-and-matched-indexed-statements-final-yez-sample
Sheet: Pre.Post Accom

 | Pre-tour Accommodation in Amsterdam |  |  |  |  |  | Post-tour Accommodation in Amsterdam
 | Tour code |  | Date tour starts |  | Room Type |  | Tour code |  | Date tour ends |  | Room Type
 | Name |  | # of nights | Pax arrives at hotel |  |  | Name |  | # of nights | Pax departs hotel
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Spreadsheet: 831840d1685949855-list-values-that-match-criteria-multiple-ranges-into-one-list-book2
Sheet: Sheet1

1 |  |  |  |  |  | 1 | 2 | [NAME]
2 |  | [NAME] | [NAME] | Rio |  | 2 |  | [NAME]
3 |  |  |  |  |  | 5 | 7 | [NAME]
4 |  | Hugh | [NAME] |  |  | 4 |  | [NAME]
5 |  | [NAME] |  |  |  | 2 | 5 | [NAME]
6 |  |  |  |  |  | 7 | 2 | Rio
7 |  | Rio |  |  |  | 8 |  | [NAME]
8 |  | Hugh |  |  |  | 4 | 8 | Hugh
9 |  |  |  |  |  | 4 |  | [NAME]
Spreadsheet: 484645d1476369598-case-when-testfile
Sheet: MasterSheetFR

1
2
3
4
5
6
7
Spreadsheet: 90149d1289916851-reconciling-to-columns-sample
Sheet: Sheet2

1 | 200 | 106
2 | 201 | 103
3 | 202 | 101
4 | 203 | 100
5 | 204 | 102
6 | 205 | 104
7 | 206 | 105
Spreadsheet: 489679d1479386914-daily-production-reporting-production-build-vs-complete
Sheet: Settings

Employee No | Employee Names |  | Current Hourly Rate
21 | [NAME] |  | 0.875
22 | Trevor
27 | Aman
29 | [NAME]
25 | Luco
31 | Mahesh
34 | [NAME]
35 | [NAME]
38 | Wei
40 | Thy
46 | Santosh
48 | [NAME]
15 | Bo
50 | Bradley
51 | [NAME]
52 | Casual 1
53 | Casual 2
54 | Casual 3
55 | Casual 4
56 | Casual 5
Spreadsheet: cara_semperger__1459__ENRON_BPA_JANUARY_POSITIONS
Sheet: January Month Positions

 |  |  | To: BPA [NAME]
 |  |  | From:
 |  |  | [NAME](503)464-3902
 |  |  | [NAME] (503)464-3831
 |  |  | [NAME] (503)464-3814
2002-01-01 00:00:00
 | HLH |  |  |  | MID COLUMBIA
 | MONTH | 25 | C#10123 |  | BPA | ENRON | BPA |  | C#10742 | 25
 | MONTH | 50 | C#10123 |  | BPA | ENRON | BPA |  | C#10642 | 50
 | MONTH | 25 | C#10123 |  | BPA | ENRON | BPA |  | C#10742 | 25
 | MONTH | 2 | C#10123 |  | BPA | ENRON | BPA |  | C#42022 | 2
 | MONTH | 50 | C#10227 |  | BPA | ENRON | BPA |  | C#42014 | 50
 | MONTH | 50 | C#10227 |  | BPA | ENRON | BPA |  | C#10605 | 50
 | MONTH | 25 | C#24502 |  | BPA | ENRON | BPA |  | C#24315 | 25
 | MONTH |  |  |  | OPEN | ENRON | BPA |  | C#10743 | 50
 | MONTH |  |  |  | OPEN | ENRON | BPA |  | C#42013 | 50
 | MONTH |  |  |  | OPEN | ENRON | BPA |  | C#42022 | 12
 | MONTH |  |  |  | OPEN | ENRON | BPA |  | C#24517 | 25
 | LLH M-SAT, 1-24 SUN AND HOLIDAYS
 | MONTH | 50 | C#10123 |  | BPA | ENRON | BPA |  | C#10642 | 50
 | MONTH | 50 | C#10123 |  | BPA | ENRON | BPA |  | C#10742 | 50
 | MONTH | 2 | C#10123 |  | BPA | ENRON | BPA |  | C#42022 | 2
 | MONTH | 25 | C#24450 |  | BPA | ENRON | BPA |  | C#42014 | 25
 | MONTH | 50 | C#10227 |  | BPA | ENRON | BPA |  | C#10743 | 50
 | MONTH | 50 | C#10227 |  | BPA | ENRON | BPA |  | C#10605 | 50
 | MONTH |  |  |  | OPEN | ENRON | BPA |  | C#42022 | 11
 | MONTH |  |  |  | OPEN | ENRON | BPA |  | C#42013 | 50
 | MONTH |  |  |  | OPEN | ENRON | BPA |  | C#42014 | 25
 | ALL HOURS ALL DAYS |  |  |  | COB
 | MONTH | 25 | C#21896 |  | BPA | ENRON | OPEN
 | MONTH | 25 | C#21892 |  | BPA | ENRON | OPEN
 | MONTH | 50 | C#23273 |  | BPA | ENRON | OPEN
 | MONTH | 50 | C#23274 |  | BPA | ENRON | OPEN
Spreadsheet: 816758d1675818674-populate-another-sheet-if-the-conditions-are-met-auto-populate
Sheet: Approved

 |  |  |  |  |  |  |  |  | START | END/STOP
Unit | NAME | Requesting Unit | Name of Accounts | Classification of Transactions (Simple, Complex, Highly Technical) | No. of Collateral/s | Location | Appraised Value | Date of Receipt of Complete Documents from Requesting Unit (Month-Date-Year) | Date of Inspection (Month-Date-Year) | Accounts Processed | Number of Working Days (WD) Processed* | Number of incidence   beyond TAT | Remarks
 |  |  |  |  |  |  |  |  |  | Date of Approval of Appraisal Report (Month-Date-Year)
REGION | ISABELLE | ABC | NOTES | SIMPLE | 1 | LONDON | 4250000 | 2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 1 |  | DONE
 |  | Sub total
 |  | GRAND TOTAL
Spreadsheet: 537747d1505239237-how-to-assign-an-array-name-to-a-number-value-to-use-in-hlookup-oeldere-537742d1505238420-how-to-assign-
Sheet: Tables

 | 89MS |  |  |  |  |  |  |  |  | 89MNS
 |  | Starting Age |  |  |  |  |  |  |  |  | Starting Age
Attained Age | 0 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 0 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 1 | 24 | 24 | 18 | 24 | 24 | 24 | 24 | 24 | 1 | 24 | 24 | 18 | 24 | 24 | 24 | 24 | 24
 | 2 | 24 | 24 | 26 | 24 | 24 | 24 | 24 | 24 | 2 | 24 | 24 | 26 | 24 | 24 | 24 | 24 | 24
 | 3 | 24 | 24 | 98 | 24 | 24 | 24 | 24 | 24 | 3 | 24 | 24 | 98 | 24 | 24 | 24 | 24 | 24
 | 4 | 24 | 24 | 85 | 24 | 24 | 24 | 24 | 24 | 4 | 24 | 24 | 85 | 24 | 24 | 24 | 24 | 24
 | 5 | 24 | 24 | 84 | 24 | 24 | 24 | 24 | 24 | 5 | 24 | 24 | 84 | 24 | 24 | 24 | 24 | 24
 | 6 | 24 | 24 | 86 | 24 | 24 | 24 | 24 | 24 | 6 | 24 | 24 | 86 | 24 | 24 | 24 | 24 | 24
 | 7 | 24 | 24 | 76 | 24 | 24 | 24 | 24 | 24 | 7 | 24 | 24 | 76 | 24 | 24 | 24 | 24 | 24
 | 8 | 24 | 24 | 62 | 24 | 24 | 24 | 24 | 24 | 8 | 24 | 24 | 62 | 24 | 24 | 24 | 24 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Static Table of Values
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Values | Table Names
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 339 | 89MS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 364 | 89MNS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 640 | 89FS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 958 | 89FNS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 658 | 94FS
 |  |  |  |  |  |  |  |  |  |  |  |  | Calc'd Value:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | If my calc'd value is 339, I need to assign table name _89MS to the HLOOKUP range
 |  |  |  |  |  |  |  |  |  |  |  |  |  | in B6, B7, B8…….
Spreadsheet: 462967d1464259277-lookup-formula-with-more-than-2-criteria-lookup-with-more-than-2-criteria-2-
Sheet: Balance Sheet

 |  |  |  |  | Planned
 | Category |  | Full Year 2015 |  | 2016-01-15 00:00:00 |  | [NAME]
 | Current Assets |  |  |  |  |  |  |  |  |  |  | Actual
 | Cash |  | 0 |  |  |  |  |  |  |  | 2016-01-15 00:00:00 | Planned
 | Bank of America Checking |  | 0
 | Bank of America Payroll |  | 0
 | [NAME] |  | 0 |  |  |  |  |  |  |  | Q1 2016
 | Petty Cash |  | 0
 | Union Bank |  | 0
 | Union Bank- Operations |  | 0
 | Union Bank- Payroll |  | 0 |  |  |  |  |  |  |  | Q2 2016
 | Union Bank- Recurring Payments |  | 0
 | Bank of the West- Operations |  | 0
Spreadsheet: 114341d1310092747-how-to-copy-cells-if-it-matches-certain-conditions-corn
Sheet: Sheet1

yellow corn | 10050
corn | 7500
cooked corn | 65
l-threonine | 5789
vitamin d | 6544
vitamin e | 8900
yogurt | 467
skim milk | 777
dried beef | 897
[NAME] | 10003
Spreadsheet: 76563d1277120083-how-to-delete-meaningless-characters-e-g-zeros-from-cells-excel-2007-delete-zeros
Sheet: with zeros

 | BUDGET
Product | YTD May-10
 | [NAME] | Volume | Sales
ACTARA 25WG 10X1KG | 11.97557743815049 | 119.7557743815049 | 1794897.291029578
Actara 25WG 20x 40gm | 0 | 0 | 0
Total Actara | 0 | 119.7557743815049 | 1794897.291029578
 | 0 | 0 | 0
Actellic 25EC 12x 1Lt | 81.59440510655163 | 979.1328612786195 | 1821187.121978231
Actellic 25EC 24x 100ml | 0 | 0 | 0
Total Actellic EC | 0 | 979.1328612786195 | 1821187.121978231
 | 0 | 0 | 0
Actellic Super 12x 200gm | 18.63284546728949 | 44.71882912149476 | 22459.57561168788
Actellic Super 12x 500gm | 74.53138186915795 | 447.1882912149476 | 198551.6012994367
Actellic Super 1x 25Kg | 0 | 0 | 0
Actellic Super 24x 100gm | 7.453138186915793 | 17.88753164859791 | 10906.40643624271
ACTELLIC SUPER 24X50GM | 0 | 0 | 0
Actellic Super 6x 1Kg | 149.0627637383159 | 894.3765824298953 | 314780.9956874847
Actellic Super 6x 2Kg | 7.453138186915793 | 89.43765824298953 | 27054.89161850428
Total Actellic Super | 0 | 1493.608892657925 | 573753.4706533564
 | 0 | 0 | 0
AGRAL 90 12 X 100ML | 13.0883465265044 | 15.70601583180527 | 14429.9020454711
Agral 90 1x 20Lt | 1125.597801279378 | 22511.95602558756 | 6318339.417882946
AGRAL 90 24 x 50ML | 0 | 0 | 0
Agral 90 6x 1Lt | 65.44173263252199 | 392.6503957951319 | 142413.3086799472
Total Agral 90 | 0 | 22920.3124372145 | 6475182.628608365
 | 0 | 0 | 0
Applaud 6x 1Lt | 269.9107823856265 | 1619.464694313759 | 4988710.661257516
 | 0 | 0 | 0
Daconil 720 SC 12x 500ml | 0 | 0 | 0
Daconil 720 SC 1x 20Lt | 0 | 0 | 0
Total Daconil | 0 | 0 | 0
 | 0 | 0 | 0
Duduthrin 1.75EC 12x 500ml | 88.3574059697079 | 530.1444358182473 | 567972.4502490286
DUDUTHRIN 1.75EC 12X200ML | 40.78034121678825 | 97.87281892029183 | 117825.9602053127
Duduthrin 1.75EC 1x 20Lt | 227.010566106788 | 4540.211322135759 | 4587611.58936125
DUDUTHRIN 1.75EC 24X100ML | 27.1868941445255 | 65.24854594686121 | 83494.41206800168
DUDUTHRIN 1.75EC 24X50ML | 13.86530785763976 | 16.63836942916772 | 23340.85973052607
Duduthrin 1.75EC 6x 1Lt | 88.3574059697079 | 530.1444358182473 | 555200.9912637359
Total Duduthrin | 0 | 5780.259928068574 | 5935446.262877856
 | 0 | 0 | 0
ERGOSTIM 12X500ML | 12.13169452232296 | 72.79016713393773 | 111368.9557149247
ERGOSTIM 24X100ML | 0 | 0 | 0
ERGOSTIM 24X50ML | 0 | 0 | 0
Total ERGOSTIM | 0 | 72.79016713393773 | 111368.9557149247
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A28

TABLE A28  FREQUENCY OF PRICE SPIKES IN THE NEW ENGLAND DAY-AHEAD ENERGY MARKET DURING JUNE, JULY, AND AUGUST OF 1998, 1999, AND 2000
Price Equals or Exceeds | # of hours |  |  | # of hours |  |  | # of hours
 | % of available hours |  |  | % of available hours |  |  | % of available hours
 | 1998-06-01 00:00:00 | 1999-06-01 00:00:00 | 2000-06-01 00:00:00 | 1998-07-01 00:00:00 | 1999-07-01 00:00:00 | 2000-07-01 00:00:00 | 1998-08-01 00:00:00 | 1999-08-01 00:00:00 | 2000-08-01 00:00:00
100 | NA | 34 | 7 | NA | 40 | 0 | NA | 0 | 3
 |  | 0.04722 | 0.00972 |  | 0.05376 | 0 |  | 0 | 0.00833
250 | NA | 23 | 3 | NA | 14 | 0 | NA | 0 | 0
 |  | 0.03194 | 0.00417 |  | 0.01882 | 0 |  | 0 | 0
500 | NA | 15 | 0 | NA | 2 | 0 | NA | 0 | 0
 |  | 0.02083 | 0 |  | 0.00269 | 0 |  | 0 | 0
750 | NA | 3 | 0 | NA | 0 | 0 | NA | 0 | 0
 |  | 0.00417 | 0 |  | 0 | 0 |  | 0 | 0
1000 | NA | 1 | 0 | NA | 0 | 0 | NA | 0 | 0
 |  | 0.00139 | 0 |  | 0 | 0 |  | 0 | 0
Source:  ISO-NE Website (www.iso-ne.com).  Data was only available through August 15, 2000.
Spreadsheet: 494065d1482160611-cant-sum-cells-book1
Sheet: Sheet1

319756 | STYLIST WEAR & POSITION VERIFICATION | 2 | MC | TM |  |  | 0:12 | 0:00
319755 | T&E 5-6 31XXN PARK BRAKE TENSIONER VERIFICATION & CALIBRATION | 2 | MC | TM |  |  | 1:00 | 0:00
1736 | T&E 1-1 A/C LEAK DETECTOR PER DAY CHECK | 0 | EL | EL |  |  | 0:36 | 0:00
3002 | T&E 10-1 DYNAMIC BALANCER PER SHIFT ELECTRICAL | 2 | EL | EL |  |  | 0:30 | 0:00
318329 | T&E 15-1 ROLL/BRAKE TEST MACHINE #1 - 4 | 2 | EL | EL | TECH [NAME] | TRADESMAN | 0:30 | 0:00
1383 | T&E 15-4 WHEEL ALIGNMENT PER SHIFT ELECTRICAL | 0 | EL | EL |  |  | 0:30 | 0:00
1309 | T&E 1-1 AC FILL PIPING PM | 0 | MC | PF |  |  | 0:06 | 0:00
1309 | T&E 1-1 AC FILL PIPING PM | 0 | MC | PF |  |  | 0:06 | 0:00
1309 | T&E 1-1 AC FILL PIPING PM | 0 | MC | PF |  |  | 0:06 | 0:00
1477 | T&E 10-1 BALANCER DAILY CHECK PIPING | 2 | MC | PF |  |  | 0:12 | 0:00
1477 | T&E 10-1 BALANCER DAILY CHECK PIPING | 2 | MC | PF |  |  | 0:12 | 0:00
1676 | T&E 10-5 TIRE SOAPER PER SHIFT PIPING | 2 | MC | PF |  |  | 0:12 | 0:00
3049 | T&E 10-5 WHEEL SOAPER PER SHIFT PIPING | 2 | MC | PF |  |  | 0:12 | 0:00
1254 | T&E 13-1 RADIATOR FILL DAILY PIPING CHECK | 0 | MC | PF |  |  | 0:12 | 0:00
3129 | T&E 15-10 CASTER / CAMBER DRILL DAILY PIPING | 2 | MC | PF |  |  | 0:12 | 0:00
320428 | APD PORTABLE UNIT INSPECTION | 2 | MC | PF |  |  | 0:18 | 0:00
1487 | T&E 5-3 BRAKE EVAC AND FILL DAILY PIPING | 2 | MC | PF |  |  | 1:00 | 0:00
3102 | T&E 8-2 FUEL FILL SYSTEM DAILY PIPING CHECK | 2 | MC | PF |  |  | 0:12 | 0:00
6002 | CM GENERIC | 2 | MC | TRAC |  |  | 0:00 | 0:00
4122 | (OBS) PPE - GLOVE INSPECTION AND CERTIFICATION REMINDER | 2 | SP | SUPV | ENGINEERING | Engineering Personnel | 2:00 | 0:00
6002 | CM GENERIC | 2 | MC | TM | TECH [NAME] | TRADESMAN | 3:00 | 0:00
Spreadsheet: 100904d1299106942-duplicate-dates-sum-combination-sample
Sheet: Sheet1

2010-06-14 00:00:00 | 3
2010-06-15 00:00:00 | 0
2010-06-16 00:00:00 | 0
2010-06-17 00:00:00 | 0
2010-06-18 00:00:00 | 2.2
2010-06-18 00:00:00 | 9.2
2010-06-21 00:00:00 | 0
2010-06-22 00:00:00 | 0
2010-06-23 00:00:00 | 0
2010-06-24 00:00:00 | 0
2010-06-25 00:00:00 | 1.5
2010-06-25 00:00:00 | 1.1
2010-06-28 00:00:00 | 0
2010-06-29 00:00:00 | 0
2010-06-30 00:00:00 | 0
Spreadsheet: 123076d1317320188-populate-calendar-with-list-of-dates-excelforum-794438-calendar
Sheet: Calendar_1

 |  | 2000
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Spreadsheet: 234752d1368184336-sorting-numbers-from-smallest-to-largest-sorting
Sheet: Hoja1

 |  |  | 21203
 |  |  | 21145
 |  |  | 31215
 |  |  | 35219
 |  |  | 35216
 |  |  | 31217
 |  |  | 41158
 |  |  | 49125
 |  |  | 41118
 |  |  | 47218
 |  |  | 41156
 |  |  | 41159
 |  |  | 41162
 |  |  | 41166
 |  |  | 43204
 |  |  | 41163
 |  |  | 41155
 |  |  | 44210
 |  |  | 44220
 |  |  | 410209
 |  |  | 41168
 |  |  | 41182
 |  |  | 51208
 |  |  | 51183
 |  |  | 21165
 |  |  | 31105
 |  |  | 31176
 |  |  | 31157
 |  |  | 32181
 |  |  | 34205
 |  |  | 36183
 |  |  | 35211
 |  |  | 35214
 |  |  | 41158
 |  |  | 41207
 |  |  | 47212
 |  |  | 41119
Spreadsheet: 70519d1271246156-sort-array-depending-on-2nd-column-sort_example-1
Sheet: Folha2

COD | EXP
14/0430
14/0431
14/0432 | YES
14/0434 | YES
14/0435
14/0436
14/0437
14/0438
14/0439
14/0440
14/0441
14/0442
14/0443
14/0444
14/0445
14/0446
14/0448 | YES
 | YES
13/0450 | YES
15/0451
15/0452
15/0453 | YES
15/0454
15/0455
15/0456
15/0457
15/0458
15/0459
15/0460
15/0461
15/0462
15/0463
15/0464
15/0465
15/0466
15/0467 | YES
15/0468
14/0505 | YES
14/0508
14/0509
15/0510
15/0511
13/0525 | YES
13/0526
13/0527
14/0528 | YES
14/0529 | YES
13/0530 | YES
13/0531 | YES
13/0532 | YES
14/0543
15/0544
14/0546
14/0547 | CANCEL
14/0548
14/0549 | YES
14/0550 | YES
14/0551
14/0553
14/0554
15/0555
15/0556 | CANCEL
14/0557
14/0558
15/0560
15/0561
14/0564 | YES
14/0565
14/0566
13/0568 | YES
14/0569
14/0570
13/0571 | YES
14/0572 | YES
13/0573 | YES
13/0574 | YES
13/0575 | YES
14/0576 | YES
14/0578 | YES
14/0579 | YES
14/0580 | YES
14/0581 | YES
14/0582 | YES
14/0583 | YES
14/0584
14/0585
14/0586
14/0587
14/0594 | YES
14/0595 | YES
14/0596 | YES
14/0599 | YES
14/0600 | YES
14/0601 | YES
14/0607 | YES
14/0608 | YES
14/0609 | YES
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -39398 | -19492
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -888354 | -1121791
58710 | -42802 | -30869
60921 | -529081 | -300954
78026
500084 |  | -33000
500085 | -3058
500097 | -17244 | -11000
INDEX
2001-11-30 00:00:00 |  |  | 504796.07
2001-12-11 00:00:00
CBS Volume
 |  |  | 190825
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-09-P-0188

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
[NAME] |  |  | 1P
[NAME] |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 696593d1600903397-colour-coding-based-on-multiple-variables-assets-jpjmilton-
Sheet: Sheet2

Item | Serial | Asset
Item | 1234 | 4321
Item | 1235 | 4322
Item | 1236 | 4323
Item | 1237 | 4324
Item | 1238 | 4325
Item | 1239 | 4326
Spreadsheet: 130126d1322070355-lookup-value-of-a-code-to-different-code-which-is-almost-common-to-a-lookup-value-pradeepb270-2011-11-23
Sheet: Main

 |  |  | Correct
 |  |  | Target
 | Material Code |  | [NAME]
1 | 11100-KWA-9000 |  | 11100KWA900
2 | [PHONE] |  | 11200198900 |  | Corrected by sort
3 | 11200-KST-8700 |  | 11200KST870
4 | 11200-KST-9400 |  | 11200KST870
5 | 11200-KVH-9500 |  | 11200KVH950
6 | 11200-KWA-9400 |  | 11200KWA900
7 | 11330-KCC-8300 |  | 11330KCC730
8 | 11330-KST-9410 |  | 11330KST901
9 | 11330-KTC-9010 |  | 11330KTC901
10 | 11330-KTC-A200 |  | 11330KTC901
11 | 11330-KVH-7600 |  | 11330KVH760
12 | 11330-KVH-9500 |  | 11330KVH760
13 | 11330-KWA-9000 |  | 11330KWA900
14 | 11330-KWA-9300 |  | 11330KWA900
15 | 11330-KWH-Y000 |  | 11330KWHY00
16 | 11331-KWA-9300 |  | 11330KWA900 |  | You appear to have missed the "1" in the fifth digit
17 | 11341-KCC-8300 |  | 11341KCC900
18 | 11341-KST-9410 |  | 11341KST870
19 | 11341-KST-A100 |  | 11341KST870
20 | 11341-KTC-A200 |  | 11341KTC900
21 | 17511-KWH-970Y |  | 17511KWH970ZA
22 | 77236-KCC-900U |  | 77236KCC900ZV
23 | 77246-KCC-730S |  | 77240KWA930ZD
24 | 77256-KCC-730S |  | 77250KWA930ZE
25 | 83400-KWA-940R |  | 83400KWA910ZA
26 | 83401-KCC-7304 |  | 83400KWA910ZA
27 | 83401-KST-950R |  | 83400KST930ZA |  | You appear to have missed the "1" in the fifth digit
28 | 83401-KWA-910V |  | 83400KWA910ZA
29 | 83500-KST-A10U |  | 83505KST860ZD |  | Inconsistent choice (up instead of down)
30 | 83500-KVH-900U |  | 83300KVH760ZA |  | You appear to have missed the "5" in the third digit
31 | 83501-KCC-830T |  | 83501KCC905ZA
32 | 83600-KST-920R |  | 83605KST880ZC |  | Inconsistent choice (up instead of down)
33 | 83600-KVH-900R |  | 83400KVH760ZA |  | You appear to have missed the "6" in the third digit
34 | 83601-KCC-830T |  | 83601KCC905ZA
Spreadsheet: 708355d1607757555-counting-discount-based-on-date-criteria-and-top-3-first-discount_problem
Sheet: EDITED

 |  |  |  |  |  |  | my expected result
 |  |  | name | date payment |  | name | discount
 |  |  | jhon | 2020-12-04 00:00:00 |  | jhon | 100
 |  |  | [NAME] | 2020-12-05 00:00:00 |  | [NAME] | 100
 |  |  | frans | 2021-01-31 00:00:00 |  | frans | 100
 |  |  | darius | 2021-01-31 00:00:00 |  | darius | 50 | over top 3
 |  |  | [NAME] | 2021-02-01 00:00:00 |  | [NAME] | 50 | payment between 1/2/2021 till 31/03/2021
 |  |  | joko | 2021-03-31 00:00:00 |  | joko | 50 | payment between 1/2/2021 till 31/03/2021
 |  |  | sisca | 2021-04-01 00:00:00 |  | sisca | 0 | over date 31/03/2021
 |  |  | [NAME] | 2021-04-02 00:00:00 |  | [NAME] | 0 | over date 31/03/2021
Spreadsheet: 41dd0f2a-5e26-46c3-a466-d059dc53dbd5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
EGGP | Test | EGGP | Eggplant, IgE | Eggplant, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
EGGP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EGGP | Result | EGGP | Eggplant, IgE | Eggplant, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7296-7
Spreadsheet: 166243d1341505693-using-index-match-equal-or-less-than-with-multiple-criteria-padal_excel_lookup_test-modified-by-tigeravatar-
Sheet: Sheet1

Main Category Name | Sub Category ID | [NAME]
ADG | 1 |  |  | Select Main Category: | BEF
ADG | 5 |  |  | Enter Sub Category ID: | 8
ADG | 9
ADG | 11 |  |  | [NAME]):
ADG | 15
BEF | 1
BEF | 5
BEF | 9
BEF | 11
BEF | 15
CPZ | 1
CPZ | 3
CPZ | 5
CPZ | 12
CPZ | 20
Spreadsheet: 157626d1337807011-sorting-worksheet-data-tree-order-test-form
Sheet: Sheet1

 |  |  |  |  |  |  | TALL TREES
Last Name | First Name | Total Amount | Down Payment | Balance Due | Special Order / Species and Quantity | Assignment | Am. Linden Basswood | Black Walnut | Hackberry | (DNR) Hybrid Poplar | Paper Birch | [NAME] | (Rubrum) Red Maple | [NAME] | Silver Maple | Sugar Maple | [NAME] | [NAME]
Doe | [NAME] | 110 | 50.5 |  |  |  | 25 |  |  |  |  |  |  |  | 150 |  |  | 25
Smith | Susy | 56 | 25 |  |  |  |  |  |  |  |  |  |  | 25 | 50 |  | 25 | 150
Turner | [NAME] | 75.23 | 50 |  |  |  |  |  |  |  | 25 |  |  |  | 25 | 50 |  | 50
Que | Suzy | 69.32 | 69.32 |  |  |  | 25 |  | 50 |  |  |  |  |  | 25 |  |  | 25
[NAME] | [NAME] | 16.96 | 15 |  |  |  | 50 |  |  |  |  |  | 50 |  | 10 |  | 15 | 75
Doe | [NAME] | 253.69 | 56.36 |  |  |  | 25 | 25 | 25 | 25 | 25 | 50 | 75 | 20 | 25 | 15 | 10 | 25
Spreadsheet: 22944d1212146634-how-to-identify-extra-items-and-duplicate-respectively-vlookup
Sheet: Sheet1 (2)

LATEST |  |  | BOSS SEND |  |  | New in BOSS Sheet and not in your latest Sheet |  | Available in your latest sheet but NOT in Boss Sheet
ID | Name |  | ID | Name
147 | [NAME] |  | 123 | harish |  | #N/A |  | #N/A
789 | jhon |  | 456 | bikash |  | bikash |  | jhon
258 | partho |  | 789 | jhon |  | jhon |  | #N/A
456 | bikash |  | 312 | [NAME] |  | #N/A |  | bikash
369 | sumit |  | 645 | [NAME] |  | #N/A |  | #N/A
159 | kidman |  | 978 | [NAME] |  | [NAME] |  | #N/A
213 | [NAME] |  | 213 | [NAME] |  | [NAME] |  | [NAME]
357 | rose |  | 546 | brono |  | brono |  | #N/A
258 | [NAME] |  | 879 | rhohan |  | rhohan |  | #N/A
879 | rhohan
546 | brono
978 | [NAME]
Spreadsheet: 755381d1636821515-reset-cell-increment-when-cell-value-changes-forum-help2
Sheet: Sheet1

Code | Should be Count |  |  |  |  | MOD(ROWS($1:1)-1,7)+1 | <---Formula that I have been using but isn't doing as I hoped :(
AA |  | <---Start increment again
AA
AA
AA
AA
AA
BB |  | <---Start increment again
BB
CC |  | <---Start increment again
CC
AA |  | <---Start increment again
AA
AA
AA
AA
AA
AA |  | <---Upto 7
AA |  | <---Start increment again
AA
BB |  | <---Start increment again
BB
BB
BB