tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 74814d1275358962-counting-unique-combinations-example
Sheet: Sheet1

Vendor Code | Numer of part #'s
A0598
I086
B575
R051
T0228
I369
A025
C508
S0393
S0518
C0383
H355
T0260
W047
R471
M256
D322
S0359
A580
A0482
S0254
T585
N0041
W0034
I0196
M0346
G221
M336
W114
M562
M0370
T0194
F0129
S826
H0116
S0117
T171
[NAME]
[NAME]
A853
T0176
I0187
R156
W0049
G0061
S0340
[NAME]
[NAME]
L318
P0014
G471
G0160
K089
F0090
T0178
S593
S0050
A0480
T0193
A0646
V0023
C0544
K0069
P0272
B067
F013
E0173
F0155
I0086
M0431
M630
R0280
S0374
[NAME]
Spreadsheet: 676889d1589041481-help-with-excel-formula-work-scheduling-watchbill
Sheet: Shift Work Calendar

 | TECH SCHEDULE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020
 | FOR MORE DETAILS ON SHIFT HOURS, PLEASE SEE THE REVERSE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0500 - 1300 |  |  |  |  | 1300 - 2100 |  |  |  |  | 2100 - 0500
 |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo
 |  |  |  |  |  |  |  | TRAVEL | ROM
 |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo
 |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo
 |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo
 |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo
 |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo
 |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo
 |  | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo
Spreadsheet: 5e610a4c-9598-495b-a5c2-994fbce96fca
Sheet: Sheet1

HASIL PENILAIAN PLPG TAHAP 5-8 TAHUN 2011
NO | NOMOR PESERTA | NAMA PESERTA | ASAL SEKOLAH | KAB/KOTA | STATUS
1 | 11036106311216 | ROCHMANI SUSI NURSANTI | SLB-B YRTRW | [NAME] | LULUS
2 | 11036146411026 | SUKASNO | SMK N 9 SKA | [NAME] | MENGULANG UJIAN TULIS
3 | 11036106310571 | KARYANI WISMANINGSIH | SMP N 12 SKA | [NAME] | LULUS
4 | 11036106310661 | IRMAHEN WL | SMP N 11 SKA | [NAME] | LULUS
Spreadsheet: 102456d1300386308-excel-if-function-used-for-different-scenarios-book2
Sheet: Sheet1

Senario 1
 | 1 | 8.00 0800-1600
 | 2 | AL | 8.00
 | 3
 |  |  |  |  |  |  | what I am trying to get here is if [NAME] is used that it will know from the formula that it should be whatever line 1 has which in the first 5 characters in this case 8.00
Senario 2 |  |  |  |  |  |  | This is as far as I could get the formula done. |  |  |  |  | if(c4="AL",left(c3,5,0)
 | 1 | 8.00 0800-1600
 | 2 |  | formula
 | 3 | PL | 8
 |  |  |  |  |  |  | what I need to show here is that if PL is used that it takes the first 5 characters of Line 1 and Line 2 stays blank
Senario 3
 | 1 | 8.00 0800-1600
 | 2 | AL | formula
 | 3 | PL | 5
 |  |  |  |  |  |  | If a figure is entered in to line 3 (eg. 5.00 and PL is chosen I need it to take that figure from the first 5 characters of Line 1 as long as AL is selected on Line 2.
 | So I would need a formula to allow me to have [NAME] on it's own, or PL on it's own or both AL and PL but if the PL is used first that it substracts whatever is entered on line 3 from line 1.
 | 1 | 8.00 0800-1600
 | 2 | AL | AL
 | 3 | PL | 2
 |  |  |  |  |  |  | I need all 3 scenarios to work on this.
 |  | 8.00 0800-1600
 |  | PL
 |  | SL | 3
 |  | 8.00 0800-1600
 |  | AL | 8
 |  | PL | 5
 |  |  |  | 8.00 0800-1600
 | AL |  |  | AL | 8
 | SL |  |  | PL | 5
 | PL
Spreadsheet: 02ef4fdb-9c13-4fd3-b7f6-4966067d23ec
Sheet: Jan 2014

 |  | Ohio Dominican University Expense Report (Effective 01/01/2014)
 | Employee ID Number:
 | Employee Name: |  |  |  | Home Street Address:
 | Department: |  |  |  | City, State, Zip Code:
 | **** ALL ORIGINAL RECEIPTS MUST BE INCLUDED WITH THIS REPORT.****
 | TRAVEL & MILEAGE
 | Date | Detailed Business Purpose |  |  | Transportation                  (Airfare, Gas, Rental, Taxi, Tolls, Parking,  etc.) | Meals | Lodging |  | [NAME]. | Total Amount
 | *01/01/2014 (calendar year) IRS mileage rate is 56 cents.
 | Date | Detailed Business Purpose |  |  |  | To  (City, State) | From                         (City, State) |  | Total Miles | Total
 |  |  |  |  | Total Travel & Mileage:
 | SUPPLIES/OTHER EXPENSES
 | Date | Detailed Business Purpose |  |  |  | Item Description |  |  | Total
 |  |  |  |  | Total Supplies/Other:
 |  |  |  |  | Total Amount:
 | Employee Signature |  |  |  | Less Advance Not Returned:
 |  |  |  |  | Total Due:
 | [NAME]
 |  |  |  | Account Number: |  | Amount:
 | Supervisor Signature
 | Date
Spreadsheet: 46149d1245054427-row-highlighted-when-a-condition-is-met-test
Sheet: Sheet1

SL. NO. | [NAME] | EMPTY IN YARD | BOOKING REFERENCE NO | CONTAINER NO. | SEAL NO. | SHIPPING LINE | CRS / BLI / SOB | DESTINATION PORT | FULL IN YARD | SUPPLIER | LOADING SITE / YARD | MATERIAL CODE | WEIGHT MT | TARE WT (MT) | PAY LOAD (MT) | TRANSPORTER | STORAGE SITE | PRICE ZAR PMT | PRICE USD PMT | IHC EMPTY ZAR | IHC FULL ZAR | IHC TOTAL ZAR (SUM U+V) | THC ZAR | WARFAGE ZAR | CTO FEE ZAR | DOC CHARGES ZAR | AGENCY FEES ZAR | W/B CHARGES ZAR | STORAGE ZAR | LIFT ON/OFF ZAR | X-HAUL ZAR | TOTAL FOBING COST ZAR | TOTAL FOB COST OF FULL CONTAINER | FOBING COST PER CONT USD | TOTAL FOBING COST PMT ON ACTUAL WT BASIS USD | TOTAL FOBING COST PMT ON 20 MT BASIS USD | EXCHANGE RATE | FOB COST PMT ON ACTUAL WT BASIS USD | FOB COST PMT ON 20 MT BASIS USD | OCEAN FRIEGHT USD | OCEAN FREIGHT ON 20 MT BASIS USD | OCEAN FREIGHT PMT ON ACTUAL WT BASIS USD | SELLING COST USD | TOTAL C&F COST ON 20 MT BASIS USD | USD PMT CNF ACTUAL WT | INSPECTED BY | VESSEL / VOYAGE NO.
1 | [NAME] | 2009-04-30 00:00:00 | D941648 | MSCU 2700490 | 4878779 | MSC | SOB | MUNDRA | 2009-05-01 00:00:00 | LINBECK METALS | BRAKPAN | HONE | 25.52 | 2.28 | 28.2 | LINBECK | S.A.C.D | 2000 | 250 | 0 | 0 | 1450 | 958 | 965 | 35 | 100 | 250 | 0 | 250 | 310 | 5000 | 9318 | 60358 | 7544.75 | 45.64067398119122 | 58.2375 | 8 | 295.6406739811912 | 308.2375 | 400 | 20 | 15.67398119122257 | 10 | 338.2375 | 321.3146551724138 | NITIN GAHLOT | MSC CARLA 71A
2 | [NAME] | 2009-04-30 00:00:00 | D941648 | MSCU 3115490 | 4878957 | MSC | BLI | MUNDRA | 2009-05-04 00:00:00 | LINBECK METALS | WADVILLE | HONE | 27.93 | 2.28 | 28.2 | LINBECK | S.A.C.D | 2000 | 250 | 0 | 0 | 1150 | 958 | 965 | 35 | 100 | 250 | 0 | 250 | 310 | 5000 | 9018 | 64878 | 8109.75 | 40.35982814178303 | 56.3625 | 8 | 290.3598281417831 | 306.3625 | 400 | 20 | 14.32151808091658 | 10 | 336.3625 | 314.6813462226996 | ARJUN | MSC CARLA 71A
3 | [NAME] | 2009-04-30 00:00:00 | D941648 | MSCU 1940259 | 4879080 | MSC | CRS | MUNDRA | 2009-05-04 00:00:00 | LINBECK METALS | WADVILLE | HONE | 25.72 | 2.28 | 28.2 | LINBECK | S.A.C.D | 2000 | 250 | 0 | 0 | 1150 | 958 | 965 | 35 | 100 | 250 | 0 | 250 | 310 | 5000 | 9018 | 60458 | 7557.25 | 43.82776049766719 | 56.3625 | 8 | 293.8277604976672 | 306.3625 | 400 | 20 | 15.55209953343702 | 10 | 336.3625 | 319.3798600311042 | ARJUN | MSC CARLA 71A
Spreadsheet: 297764d1392571748-how-do-i-convert-due-date-into-this-week-or-next-week-using-pivot-or-formula-sample-excel
Sheet: Pivot Table

Date Completed or Closed | (blank)
Count of Project id | Column Labels
Row Labels | 2014-02-14 00:00:00 | 2014-02-17 00:00:00 | 2014-02-18 00:00:00 | 2014-02-20 00:00:00 | 2014-02-21 00:00:00 | 2014-02-24 00:00:00 | 2014-02-25 00:00:00 | 2014-02-26 00:00:00 | 2014-02-27 00:00:00 | 2014-02-28 00:00:00 | Grand Total
[NAME] |  |  | 2 |  |  |  | 1 |  |  | 1 | 4
[NAME] |  |  |  |  |  | 3 |  | 2 |  | 1 | 6
Carmen |  | 1 |  | 2 |  |  |  | 4 |  |  | 7
[NAME] | 1 |  | 2 |  | 3 | 7 |  | 1 | 2 | 2 | 18
Franca |  | 1 |  |  |  | 2 | 6 | 2 | 4 |  | 15
Kelly |  |  | 1 |  | 2 | 2 | 1 |  | 1 |  | 7
Grand Total | 1 | 2 | 5 | 2 | 5 | 14 | 8 | 9 | 7 | 4 | 57
Spreadsheet: scott_neal__38532__Neal Short Bonds Exe
Sheet: Income

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Income Distribution
($000's) |  |  | Maturity | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  |  |  | Maturity
Par | Description | Coupon | Date | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals |  |  |  | Year | Month | Percentage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
 | Totals
 | % of Total Annual Income
 | Year | Percentage
 | Year | Percentage
 | 2000 | 0.01538461538461539
 | 2001 | 0.01846153846153846
 | 2002 | 0.03076923076923077
 | 2006 | 0.08
 | 2008 | 0.01230769230769231
 | 2011 | 0.01538461538461539
 | 2013 | 0.04
 | 2015 | 0.006153846153846154
 | 2016 | 0.006153846153846154
 | 2019 | 0.12
 | 2020 | 0.1230769230769231
 | 2022 | 0.01538461538461539
 | 2023 | 0.06153846153846154
 | 2024 | 0.1292307692307692
 | 2025 | 0.04
 | 2027 | 0.1938461538461539
 | 2028 | 0.04615384615384616
 | 2031 | 0.04615384615384616
Spreadsheet: 586364d1534342362-need-and-or-added-to-an-index-small-if-statement-excel-training-index-small-if-need-to-add-or-1-
Sheet: Wholesalers

 | ABC | DEF | [NAME] | ABC3
This is tab name below:
ABC | <----- Coworker manually types this in at the top of each page
Partner | Address | City | State | Zip
 |  |  |  |  |  | NEW PROBLEM 07-24-2018: One of the wholesalers has 3 names, so each partner can call them by a different name, but we want to collect all under the main name which is ABC.  So for this formula to work I have to create several tables for the different names of the same wholesaler.
This is tab name below:
DEF | <----- Coworker manually types this in at the top of each page
Partner | Address | City | State | Zip |  | So instead of referencing one cell for each wholesaler, I know need to write the formulas in Column A with and OR statement, but I keep getting errors.
This is tab name below:
[NAME] | <----- Coworker manually types this in at the top of each page
Partner | Address | City | State | Zip
This is tab name below:
ABC3 | <----- Coworker manually types this in at the top of each page
Partner | Address | City | State | Zip
Spreadsheet: 694015d1599298445-search-cell-for-string-accounting-for-prefixes-2020-09-05-oeldere-rhemsath-693964d1599236604-search-cell-for-string-accounting-for-prefixes-
Sheet: Sheet1

Comments | Group |  |  |  |  |  | name | group
unprepared |  |  |  |  |  |  | unprepared | unprepared
underprepared |  |  |  |  |  |  | underprepared | prepared
 |  | prepared |  |  |  |  |  | unprepared
struggle |  | unprepared |  |  |  |  | struggle | other
prepared |  |  |  |  |  |  | prepared | prepared
prepared me |  |  |  |  |  |  | prepared me | prepared
not prepared |  |  |  |  |  |  | not prepared | prepared
very prepared |  |  |  |  |  |  | very prepared | prepared
unprofessional |  |  |  |  |  |  | unprofessional | other |  |  | Rijlabels | Aantal van Group
professional |  |  |  |  |  |  | professional | other |  |  | other | 11
poor |  |  |  |  |  |  | poor | other |  |  | classroom | 1
Prepared |  |  |  |  |  |  | Prepared | prepared |  |  | flawed | 1
lack |  |  |  |  |  |  | lack | other |  |  | great | 1
great |  |  |  |  |  |  | great | other |  |  | horrendous | 1
flawed |  |  |  |  |  |  | flawed | other |  |  | lack | 1
very prepared |  |  |  |  |  |  | very prepared | prepared |  |  | late | 1
unprepared |  |  |  |  |  |  | unprepared | unprepared |  |  | poor | 1
classroom |  |  |  |  |  |  | classroom | other |  |  | professional | 1
late |  |  |  |  |  |  | late | other |  |  | struggle | 1
superion |  |  |  |  |  |  | superion | other |  |  | superion | 1
horrendous |  |  |  |  |  |  | horrendous | other |  |  | unprofessional | 1
 |  |  |  |  |  |  |  |  |  |  | prepared | 7
 |  |  |  |  |  |  |  |  |  |  | not prepared | 1
 |  |  |  |  |  |  |  |  |  |  | prepared | 2
 |  |  |  |  |  |  |  |  |  |  | prepared me | 1
 |  |  |  |  |  |  |  |  |  |  | underprepared | 1
 |  |  |  |  |  |  |  |  |  |  | very prepared | 2
 |  |  |  |  |  |  |  |  |  |  | unprepared | 3
 |  |  |  |  |  |  |  |  |  |  | unprepared | 3
 |  |  |  |  |  |  |  |  |  |  | Eindtotaal | 21
Spreadsheet: 6ec93107-4c27-438b-9985-63162dfab73c
Sheet: Sheet1

Spine Point | Spinal Salary |  | [NAME] (£)
 |  |  | Grade 1 |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Grade 5 |  |  | Grade 6 |  |  | Grade 7 |  |  | [NAME] |  |  | Grade 9 |  |  | Grade 10
 |  |  | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate |  | Holiday Pay | Total
1 | 13486
2 | 13839
3 | 14202
4 | 14520
5 | 14905
6 | 15303
7 | 15658
8 | 16091
9 | 16540
10 | 17014
11 | 17503
12 | 18005
13 | 18523
14 | 19056
15 | 19606
16 | 20172
17 | 20764
18 | 21383
19 | 22020
20 | 22700
21 | 23352
22 | 24049
23 | 24766
24 | 25504
25 | 26264
26 | 27047
27
28 | 28685
29 | 29541
30 | 30424
31 | 31331
32 | 32267
33 | 33230
34 | 34223
35
36 | 36298
37 | 37382
38 | 38522
39 | 39649
40 | 40834
41 | 42055
42
43 | 44607
44 | 45941
45 | 47314
46 | 48729
47 | 50186
48 | 51687
49 | 53233
50 | 54826
51 | 56467
52 | 58156 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
53 | 59897 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
54 | 61689 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
55 | 63535 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
56 | 65437 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
57 | 67395 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
58 | 69412 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
Spreadsheet: 093be433-ba2b-4645-9ed2-039a684b3180
Sheet: Sheet1

FINISH LINE INC /IN/ | Unnamed: 1 | Unnamed: 2
8-K
[NAME]
CURRENT REPORT
Indiana | 0-20184 | 35-1537210
_____________________ | _____________ | ______________
(State or other jurisdiction | (Commission | (I.R.S. Employer
of incorporation) | File Number) | Identification No.)
3308 North Mitthoeffer Road, Indianapolis, |  | 46235
Indiana
_________________________________ |  | ___________
(Address of principal executive offices) |  | (Zip Code)
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 850645d1701059448-convert-list-into-lower-triangular-matrix-book1
Sheet: Sheet1

1 | 4 | 5 | 7
2 | 3
4 | 5 | 6
7 | 8 | 9 | 10
11 | 12 | 13 | 14 | 15
16 | 17 | 18 | 19 | 20 | 21
22 | 23 | 24 | 25 | 26 | 27 | 28
29 | 30 | 31 | 32 | 33 | 34 | 35 | 36
37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45
46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55
56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66
4 | 5
7 | 8 | 9
10 | 11 | 12 | 13
14 | 15 | 16 | 17 | 18
19 | 20 | 21 | 22 | 23 | 24
25 | 26 | 27 | 28 | 29 | 30 | 31
32 | 33 | 34 | 35 | 36 | 37 | 38 | 39
40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48
49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58
59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69
Spreadsheet: 266750d1379710111-combining-duplicate-names-and-summarizing-numbers-completionreport-1-
Sheet: Completion Report O

Name | Total Days
BAGGS, CORY E | 3
BAGGS, CORY E | 6
[NAME], [NAME] | 13
[NAME], [NAME] | 13
BROWN, [NAME] | 4
BROWN, [NAME] | 9
BROWN, [NAME] | 6
CHAMPINE, JUSTIN L | 3
CHAMPINE, JUSTIN L | 13
CHAMPINE, JUSTIN L | 3
CHRISTENSEN, CHAD M | 6
CHRISTENSEN, CHAD M | 10
DAVIS, BRADLEY J | 3
DAVIS, BRADLEY J | 17
FISHER, GORDON B | 16
FISHER, GORDON B | 9
FISHER, GORDON B | 12
FOSTER, DANIEL E | 3
GABBITAS, RICHARD W | 4
GABBITAS, RICHARD W | 3
GABBITAS, RICHARD W | 59
GABBITAS, RICHARD W | 3
GABBITAS, RICHARD W | 3
GABBITAS, RICHARD W | 5
GABBITAS, RICHARD W | 3
HANNA, [NAME] | 7
HANNA, [NAME] | 13
HANNA, [NAME] | 8
HENINGER, RYAN C | 13
HENINGER, RYAN C | 13
[NAME], [NAME] | 6
[NAME], [NAME] | 28
JOHNSON, ERICK R | 3
[NAME], [NAME] | 13
[NAME], [NAME] | 6
[NAME], [NAME] | 2
KOWALSKI, NATHAN | 8
KOWALSKI, NATHAN | 6
KREMER, JEFFREY W | 3
KREMER, JEFFREY W | 6
KREMER, JEFFREY W | 3
KREMER, JEFFREY W | 14
LAFEEN, JUSTIN S | 13
LAFEEN, JUSTIN S | 13
LAFEEN, JUSTIN S | 2
LARSEN, [NAME] | 12
LARSEN, [NAME] | 3
LARSEN, [NAME] | 3
LARSEN, [NAME] | 3
LARSEN, [NAME] | 8
MAGUIRE, GENE S | 12
MAGUIRE, GENE S | 12
MAGUIRE, GENE S | 6
MAGUIRE, GENE S | 13
MATTIS, [NAME] | 3
MATTIS, [NAME] | 13
MCELWEE, [NAME] | 47
MCELWEE, [NAME] | 6
MCELWEE, [NAME] | 3
MCELWEE, [NAME] | 9
METZLER, BRENDA M | 6
METZLER, BRENDA M | 12
[NAME], [NAME] D | 13
MOORMAN, DARYN J | 13
MOSCON, BRET J | 13
MOULTON, [NAME] | 12
[NAME], [NAME] | 13
[NAME], [NAME] | 35
[NAME], [NAME] | 9
[NAME], [NAME] | 14
NEVILLE, TRENT S | 3
NEVILLE, TRENT S | 8
NEVILLE, TRENT S | 3
NEVILLE, TRENT S | 10
PALUMBO, SCOTT D | 322
PALUMBO, SCOTT D | 322
PALUMBO, SCOTT D | 12
PAPADOPOULOS, [NAME] | 8
PETERSON, NICHOLAS J | 12
PORTER, EVELYN A | 67
PORTER, EVELYN A | 19
PORTER, EVELYN A | 4
PORTER, EVELYN A | 11
PORTER, EVELYN A | 6
PORTER, EVELYN A | 4
POWELL, KATHLEEN A | 3
POWELL, KATHLEEN A | 13
RASMUSSEN, BRIAN C | 1
RASMUSSEN, BRIAN C | 2
SANDBERG, [NAME] | 14
SANDBERG, [NAME] | 4
SANDBERG, [NAME] | 14
SANDBERG, [NAME] | 3
SMITH, RICK D | 13
STOWERS, MARK A | 3
STOWERS, MARK A | 12
WARNER, CHRISTINE M | 47
WARNER, CHRISTINE M | 34
WARNER, CHRISTINE M | 13
WARNER, CHRISTINE M | 13
WARNER, CHRISTINE M | 16
WATSON, JON C | 5
WATSON, JON C | 3
WATSON, JON C | 4
WILBUR, [NAME] | 18
WILBUR, [NAME] | 3
WILBUR, [NAME] | 6
WILBUR, [NAME] | 4
[NAME], MATTHEW H | 1
[NAME], MATTHEW H | 13
[NAME], NATHAN M | 27
[NAME], NATHAN M | 13
YOUNG, [NAME] | 12
YOUNG, [NAME] | 10
YOUNG, [NAME] | 3
YOUNG, [NAME] | 3
Spreadsheet: 106604d1303840061-linking-list-while-excluding-blanks-inventory-example
Sheet: Sheet1

Description |  |  |  |  |  |  | Cost | Quanity
License |  |  |  |  |  |  | 115.128 | 100
Option |  |  |  |  |  |  | 2302.56 | 1
Channel |  |  |  |  |  |  | 29 | 100
Product 1 |  |  |  |  |  |  | 123 | 1
Product 2 |  |  |  |  |  |  | 94.63333333333334 | 100
Product 3 |  |  |  |  |  |  | 5.833333333333334 | 100
Product 4 |  |  |  |  |  |  | 137.1333333333334
Product 5 |  |  |  |  |  |  | 5.833333333333334 | 100
Product 6 |  |  |  |  |  |  | 212.38 | 1
Product 7 |  |  |  |  |  |  | 21 | 100
Product 8 |  |  |  |  |  |  | 180 | 75
Product 9 |  |  |  |  |  |  | 43.16666666666666 | 65
Product 10 |  |  |  |  |  |  | 25.83333333333334
Product 11 |  |  |  |  |  |  | 78.33333333333334 | 1
Spreadsheet: 829131d1683948635-help-with-daily-schedule-with-auto-days-off-example-tennfox-
Sheet: Sheet1

 | WORK
 | Primary | Trainee |  |  |  |  | OFF
211 | doe, [NAME](MT) | Trainee, bill  (TW) |  |  |  |  | [NAME]  (SS)
212 | [NAME]  (SS) |  |  |  |  |  | Smith, bob (SM)
213 | Smith, bob (SM)
214 | [NAME], [NAME] (WT)
314 | sams, bob  (FS)
315
316
 |  | 2023-05-14 00:00:00
Spreadsheet: 151218d1334833116-pivot-table-how-to-sort-drop-down-lists-da6126-ctreconciler-redacted_reply
Sheet: DT 931 933

 |  |  |  |  |  |  |  |  |  |  |  |  | Version |  | 2012-04-16-01
 |  |  |  |  |  |  |  |  |  |  |  |  | MWH Ref |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Name |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 3rd party ref |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Control account |  | DT (931, 933)
0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 0 |  |  |  |  |  |  |  | Total: |  | 0 |  | 0
 |  |  |  |  | 0 |  |  |  |  |  |  |  | Visible subtotal: |  | 0 |  | 0
 |  | Default | Default | Default | Default |  | Default | Default |  | Default |  | Default |  |  |  |  | Default
 |  | <[NAME] | <[NAME] | <[NAME] | Movement £ |  | Transaction | APE |  | Processed? |  | Account |  |  |  |  | DT movement £ P&L (506)
5 | 0 |  | 0 |  |  | 0 |  |  |  | 0 |  |  | 0 | 0 | 0
 |  | Date | Boolean | Comment |  |  | Date | Date |  | Boolean |  | Comment
CountA | UsedRow? | <[NAME] | <[NAME] | <[NAME] | Movement £ | RowVisible? | Transaction | APE | Boolean Divider | Processed? | Comment Divider | Account | Total bal £ (Dr)/Cr | Visible bal £ | Movement total £ Dr/(Cr) | Blank Col | DT movement £ P&L (506) | End Col
8 | 1 |  | 0 |  |  | 1 | 2009-05-01 00:00:00 | 2010-04-30 00:00:00 |  | 0 |  | 931 BS DT B/fwd | 0 | 0 | 0 |  | 0
8 | 1 |  | 0 |  |  | 1 | 2010-04-30 00:00:00 | 2010-04-30 00:00:00 |  | 0 |  | 506 PL DT | 0 | 0 | 0 |  | 0
8 | 1 |  | 0 |  |  | 1 | 2011-04-30 00:00:00 | 2011-04-30 00:00:00 |  | 0 |  | 506 PL DT | 0 | 0 | 0 |  | 0
8 | 1 |  | 0 |  |  | 1 | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 0 |  | 506 PL DT | 0 | 0 | 0
Spreadsheet: 767872d1644685281-distribute-a-number-from-a-cell-across-others-based-on-the-percentage-of-another-cell-distribute-based-on-individual-percentage-of-available-tachyonstiggy-
Sheet: Team Assignments

FRUIT | TOTAL AVAILABLE | TOTAL TO PICK | TEAM 1 | TEAM 2 | TEAM 3 | TEAM 4 | TOTAL ASSIGNED
ORANGES |  | 50
APPLES |  | 11
 |  | TOTAL AVAILABLE BY TEAM
 |  | RANK
 |  |  | Calculate how many to "pick" based on their individual percentage of B.
 |  |  | The sum of D:G must be exactly the value in C.  Must be whole numbers.