tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 726740d1617394215-help-with-highlighting-cells-21-pallet-log-pallet-copy
Sheet: Pallet Log

Date | Job # | Customer Name | Job Name | Fill Out | Fill Out | White | EPS | Pull for EPS & Didde | Fill Out | Fill Out | Web Sheets | Total Color Sheets | If there are  2 Web  Envelopes (EPS) |  | If       3 EPS | If      4 EPS | Fill Out | Date Done:
 |  |  |  | P.B. | S.S. |  | Envelopes |  | # of Pallets
 |  |  |  | Pink | Blue |  |  |  | Didde | Web |  |  |  |  |  |  | Done
 |  |  |  |  | P |  |  |  | 0 | 16
 |  |  |  |  | P |  |  |  | 1 | 4
 |  |  |  | P |  |  |  |  | 1 | 22
 |  |  |  | P |  |  |  |  | 3 | 25
Spreadsheet: 274521d1383141537-how-to-get-count-of-rows-in-a-column-based-on-the-data-964936
Sheet: Sheet2

error_code --header |  | Unique code | Count
815 |  | 17
815 |  | 730
815 |  | 815
815 |  | 99999 |  |  |  |  | Row Labels | Count of error_code --header
99999 |  |  |  |  |  |  | 17 | 4
99999 |  |  |  |  |  |  | 730 | 42
99999 |  |  |  |  |  |  | 815 | 6
17 |  |  |  |  |  |  | 99999 | 3
815 |  |  |  |  |  |  | Grand Total | 55
815
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
17
730
17
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
730
17
Spreadsheet: 86959d1286900255-return-results-based-on-rows-and-columns-sumrange
Sheet: Case1

YEAR | JUL | AUG | SEP | OCT | NOV | DEC
06-07 | 22.14572477465627 | 22.95205756053276 | 20.42606592584077 | 20.62042368526101 | 20.42077386208998 | 20.02747790672068
07-08 | 21.98065299951864 | 22.76122544906151 | 21.72028874202497 | 20.38876147072488 | 19.64489939500539 | 19.63872353625021
08-09 | 20.16520597651089 | 21.06660592039758 | 21.37052078383947 | 21.31950946717534 | 20.0747194353872 | 19.72486578419761
09-10 | 20.31043515405951 | 21.19613943730176 | 21.47840787023051 | 21.41011208827436 | 20.12519463550144 | 19.74223653105615
10-11 | 20.94761423425778 | 21.89847182336391 | 22.21570004772643 | 22.15830850925122 | 20.8397671456447 | 20.47940164921136
11-12 | 21.94558015770029 | 22.93259338935022 | 23.25001022460939 | 23.17986894224702 | 21.77767401154922 | 21.3830243997527
12-13 | 21.87036527653161 | 22.88818462502872 | 23.22837741032172 | 23.17960776070709 | 21.78904139879121 | 21.41829781717435
13-14 | 22.01935138125068 | 23.02115531398992 | 23.3417105211913 | 23.26745823189225 | 21.85224784678095 | 21.46773695327527
14-15 | 22.0043268329115 | 23.04324729005417 | 23.3937152072161 | 23.35120513068079 | 21.95353396800352 | 21.59337063298112
A1:G10 = Case1
Spreadsheet: 242219d1370938509-how-to-filter-cell-by-color-in-office-2003-both-background-color-and-text-color-color-change-format
Sheet: BACK GROUND FILTER

VENDOR | DATE | INVOICE | ETD | REMARKS | back color
ACRO GAIN | 2013-05-15 00:00:00 | RECEIVED |  | RECEIVED | [NAME]
AVERY DENNISON | 2013-05-15 00:00:00 | RECEIVED |  | RECEIVED | [NAME]
C T LABEL | 2013-05-15 00:00:00 | RECEIVED |  |  | Custom color or no fill
[NAME] | 2013-05-15 00:00:00 | RECEIVED |  |  | Light Turqoise
DURAFLEX | 2013-05-15 00:00:00 | RECEIVED |  | RECEIVED | [NAME]
DURAFLEX | 2013-05-15 00:00:00 |  |  |  | Custom color or no fill
EVERGREEN | 2013-05-15 00:00:00 |  |  |  | Custom color or no fill
LEEJO | 2013-05-15 00:00:00 | RECEIVED |  | RECEIVED | [NAME]
NUWA | 2013-05-15 00:00:00 |  |  | RECEIVED | [NAME]
PCK | 2013-05-15 00:00:00 | RECEIVED |  |  | Custom color or no fill
PCK | 2013-05-15 00:00:00 |  |  |  | Custom color or no fill
PCK | 2013-05-15 00:00:00 |  |  |  | Custom color or no fill
Spreadsheet: 824723d1680790633-calculate-percentage-but-anything-in-na-field-master-audit-worksheet
Sheet: Sheet1

Facility: |  | Audit Date:
Auditor:
Objective:
Process & Methodology:
Task |  | Compliant | Non-Compliant | N/A | Notes
 |  | x
 |  | x
 |  |  |  |  | X
 |  | X
 |  | X
 |  | X
 |  | X
 |  |  | X
Total
 | Percent Compliant
Pass/Fail |  |  | Non-Compliant findings must be corrected.
Follow-up Date:
Follow-up Pass/Fail:
Auditor:
Spreadsheet: 822065d1679072355-count-the-number-of-instances-of-a-value-in-one-column-based-on-a-value-in-another-sample
Sheet: Summary

ID# | Assocaite Name | Supervisor | Department | Total Points | Level | Verbal Warning Date | Stop - VW | Written Warning Date | Stop - WW | Start - Final Written Warning Date | Stop - Final | Termination | Tardies | WLBD | Date
111111 |  |  |  |  |  | 2022-11-15 00:00:00
222222
333333
444444
555555
666666
777777
888888
999999 |  |  |  |  |  | 2022-11-02 00:00:00 |  | 2022-12-02 00:00:00 |  | 2023-02-02 00:00:00
111112
111113
111114
111115
111116
111117
111118
111119 |  |  |  |  |  | 2023-02-03 00:00:00 |  | 2023-02-04 00:00:00
111120
111121
111122
Spreadsheet: 726995d1617642389-data-entered-a-sheet-need-to-appear-automatically-on-another-sheet-as-per-headings-etc-accounting-module-caracalla-sol-01-1-
Sheet: Bank Balance

Particulars |  | Money In |  |  |  |  |  |  | Money Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Balance
Date | Ref/Invoice/Cheque No. | Document Charges | Loan Capital Recovery | Loan Interest Recovery | Donations | Other Incomes | Owners Capital | Third Party Loans | Building Rent | Electricity | Fuel | Internet Charges | Mobile Charges | Statationery | Computers | Furniture | Travelling Costs | Marketing/Advertising | Charitables | Sponsorships | Entertainment | Insurance | Water Bill | Car | Motor Bike | Owners Withdrawals | Salaries | Loans Disburesed | Interest Paid | Petty Cash | EPF | ETF | Bonus | Debit | Credit
Spreadsheet: 0c26a43b-0ec3-43a9-be53-fc074bdef693
Sheet: DMATS

New ID Ff | FFUJ | FMAN | FCIRG | FVEG | FOXG | FGSG | Fs | Product
DMATS1 | FFUJ_09179 | DMATS1 | FCIRG_01609 | FVEG_09966 | n.d. | n.d. | n.d.
DMATS2 | n.d. | DMATS2 | FCIRG_02680 | n.d. | n.d. | n.d. | n.d.
DMATS3 | FFUJ_14683 | DMATS3 | FCIRG_01665 | n.d. | FOXG_03930 | n.d. | n.d.
DMATS4 | n.d. | DMATS4 | FCIRG_10662 | FVEG_12218 | [NAME] | n.d. | n.d.
 | 2 | 4 | 4 | 2 | 2 | 0 | 0
Spreadsheet: 631609d1562749681-distance-between-coordinates-shown-in-a-sorted-list-xlf_1282014c
Sheet: Report

 |  |  | Location ID | DE902
 |  |  |  | Distance
 |  |  | OR654 | 12.52996408614167
 |  |  | LN392 | 2662.475727588892
 |  |  | [NAME] | 13281.93046962677
 |  |  | UB482 | 13525.29992273739
 |  |  | [NAME] | 13862.13464802589
 |  |  | [NAME] | 14176.06422812764
 |  |  | RH992 | 14176.06422812764
 |  |  | KO420 | 14602.71978091753
 |  |  | HF029 | 15455.48954255413
 |  |  | RH392 | 15455.48954255413
 |  |  | OL942 | 16596.81104911423
 |  |  | NJ111 | 17398.68997942087
 |  |  | LK392 | 17398.68997942087
 |  |  | HY675 | 18204.41256948436
 |  |  | ES492 | 20347.43829085126
 |  |  | KH387 | 20594.73937684087
 |  |  | PL122 | 22226.85695279474
 |  |  | PG343 | 22226.85695279474
 |  |  | [NAME] | 22261.78961808776
 |  |  | LR012 | 23369.35465518892
 |  |  | PY492 | 26378.09433981159
 |  |  | PT940 | 26378.09433981159
 |  |  | KL329 | 34833.50222128117
 |  |  | GF329 | 34833.50222128117
 |  |  | DR029 | 35326.29146966887
 |  |  | DF392 | 35970.17549303867
 |  |  | WE942 | 36070.00001386194
 |  |  | SD932 | 36070.00001386194
Spreadsheet: 474220d1470677426-mileage-reimbursement-form-formulas-not-working-test-mileage-form
Sheet: Ref-Minutes

Mileage Minutes | Amityville | Bay Shore 180 | Bay Shore 375 | Hauppauge (LIVM / Middle Country Management) | Brentwood | Hauppauge 110 Marcus Blvd | [NAME] 281 Main | Port Jefferson | Sayville | West Islip | Deer Park | Garden City | Hempstead | Holbrook | Riverhead | Smithtown | Southampton | Southold | [NAME] (NSEYE) | Little Neck | Other (Please explain thoroughly in the next column)
Amityville |  | 18 | 16 | 23 | 22 | 21 | 30 | 41 | 29 | 15 | 18.0 | 25 | 24 | 30 | 49 | 32 | 64 | 76 | 37 | 28
Bay Shore 180 | 18 |  | 8 | 18 | 13 | 18 | 31 | 29 | 13 | 7 | 19.0 | 42 | 41 | 23 | 41 | 28 | 55 | 67 | 34 | 41
Bay Shore 375 | 16 | 8 |  | 16 | 13 | 18 | 31 | 28 | 18 | 9 | 18 | 42 | 40 | 22 | 39 | 29 | 53 | 65 | 36 | 42
Hauppauge (LIVM / Middle Country Management) | 23 | 18 | 16 |  | 9 | 4 | 23 | 25 | 20 | 13 | 17 | 34 | 36 | 14 | 35 | 16 | 57 | 64 | 23 | 32
Brentwood | 22 | 13 | 13 | 9 |  | 9 | 26 | 33 | 23 | 13 | 15 | 38 | 40 | 19 | 40 | 21 | 60 | 68 | 26 | 37
Hauppauge 110 Marcus Blvd | 21 | 18 | 18 | 4 | 9 |  | 22 | 27 | 22 | 15 | 15 | 37 | 39 | 15 | 36 | 14 | 57 | 64 | 25 | 35
[NAME] 281 Main | 30 | 30 | 31 | 23 | 26 | 22 |  | 28 | 42 | 28 | 26 | 37 | 39 | 42 | 62 | 37 | 84 | 82 | 6 | 34
Port Jefferson | 41 | 29 | 28 | 25 | 33 | 27 | 28 |  | 26 | 35 | 38 | 60 | 60 | 22 | 34 | 25 | 57 | 55 | 45 | 60
Sayville | 29 | 13 | 18 | 20 | 23 | 22 | 42 | 26 |  | 20 | 27 | 50.0 | 47 | 17 | 36 | 31 | 49 | 60 | 40 | 51
West Islip | 15 | 7 | 9 | 13 | 13 | 15 | 28 | 35 | 20 |  | 14 | 43 | 43 | 30 | 47 | 27 | 58 | 70 | 31 | 44
Deer Park | 18 | 19 | 18 | 17 | 15 | 15 | 26 | 38 | 27 | 14 |  | 31 | 32 | 20 | 41 | 23 | 64 | 70 | 22 | 35
Garden City | 25 | 42 | 42 | 34 | 38 | 37 | 37 | 60 | 50 | 43 | 31 |  | 2 | 45 | 63 | 45 | 73 | 80 | 42 | 28
Hempstead | 24 | 41 | 40 | 36 | 40 | 39 | 39 | 60 | 47 | 43 | 32 | 2 |  | 43 | 65 | 41 | 80 | 90 | 39 | 25
Holbrook | 30 | 23 | 22 | 14 | 19 | 15 | 42 | 22 | 17 | 30 | 20 | 45 | 43 |  | 25 | 18 | 47 | 54 | 30 | 50
Riverhead | 49 | 41 | 39 | 35 | 40 | 36 | 62 | 34 | 36 | 47 | 41 | 63 | 65 | 25 |  | 39 | 34 | 31 | 53 | 65
Smithtown | 32 | 28 | 29 | 16 | 21 | 14 | 37 | 25 | 31 | 27 | 23 | 45 | 41 | 18 | 39 |  | 59 | 65 | 30 | 55
Southampton | 64 | 55 | 53 | 57 | 60 | 57 | 84 | 57 | 49 | 58 | 64 | 73 | 80 | 47 | 34 | 59 |  | 50 | 70 | 70
Southold | 76 | 67 | 65 | 64 | 68 | 64 | 82 | 55 | 60 | 70 | 70 | 80 | 90 | 54 | 31 | 65 | 50 |  | 75 | 75
Huntington 148 E Main | 37 | 34 | 36 | 23 | 26 | 25 | 6 | 45 | 40 | 31 | 22 | 42 | 39 | 30 | 53 | 30 | 70 | 75 |  | 45
Little Neck | 28 | 41 | 42 | 32 | 37 | 35 | 34 | 60 | 51 | 44 | 35 | 28 | 25 | 50 | 65 | 55 | 70 | 75 | 45
[NAME] | 23 | 45 | 78
Spreadsheet: 883708d1732358794-vlookup-for-salaries-yearly-salary-increment-based-on-anniversay-date-forecasting-salary-forecasting-jt-
Sheet: ORoos

 | As April budget year |  | Month | Update
Employee Name | Level | Step | Anniversary | 2024-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Total Year |  | Spend | Budget
Employee A |  | 8
Employee B
Employee C
Employee D
Employee E
 | Level & Step as at April of the year for which the budget is. |  |  |  |  |  |  |  |  |  |  |  | [NAME] referencing table 2
 | Update annually on 'Patrice Test' sheet, or hardcode above.
 | Step Increases (anniversary & agreement) applied to the month FOLLOWING the month with the anniversary
April 1, 2024 | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8
IT-01 | 60000 | 61000 | 62000 | 63000 | 64000 | 65000 | 66000 | 67000
IT-02 | 80000 | 81000 | 82000 | 83000 | 84000 | 85000 | 86000 | 87000
IT-03 | 100000 | 102000 | 104000 | 106000 | 108000 | 110000 | 112000 | 114000
IT-04 | 120000 | 122000 | 124000 | 126000 | 128000 | 130000 | 132000 | 134000
Dec 22, 2024 | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8
IT-01 | 61500 | 62500 | 63500 | 64500 | 65500 | 66500 | 67500 | 68500
IT-02 | 81000 | 82000 | 83000 | 84000 | 85000 | 86000 | 87000 | 88000
IT-03 | 101500 | 103500 | 105500 | 107500 | 109500 | 111500 | 113500 | 115500
IT-04 | 121500 | 123500 | 125500 | 127500 | 129500 | 131500 | 133500 | 135500
Spreadsheet: 848054d1698859184-conditional-formatting-with-transposed-data-book1-2-
Sheet: Sheet3

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
 | velit & dolore | nulla & sint | non & in | officia & anim | laborum. & perspiciatis | iste & sit | doloremque & rem | ipsa & illo | et & beatae | sunt & enim | quia & aspernatur | aut & quia | dolores & ratione | nesciunt. & quisquam | dolorem & dolor | consectetur, & sed | numquam & tempora | labore & magnam | voluptatem. & ad | quis & ullam | laboriosam, & aliquid | commodi & autem | iure & in | velit & nihil | vel & dolorem | quo & pariatur?
Spreadsheet: 686013d1594312518-locate-matching-cells-in-multiple-worksheets-and-report-on-value-associated-with-match-server-and-storage-match
Sheet: Server & Application List

BIT ID - | Status | Operating Environment | Primary Application | Server Name | Storage Allocated
021800007ABC
Windows Server | Deployed - Functional | Test | ABC Test1 | ABCTEST1 | 1000
[NAME] | Deployed - Functional | Development | ABC Dev1 | ABCDEV1 | 500
AIX Server | Deployed - Functional | Production | ABC Prod1 | ABCPROD1 | 2000
Windows Server | Deployed - Functional | Test | DEF Test1 | DEFTEST1 | 3000
[NAME] | Deployed - Functional | Development | DEF Dev1 | DEFDEV1 | 1500
AIX Server | Deployed - Functional | Production | DEF Prod1 | [NAME] | 6000
Spreadsheet: 678110d1589721660-merge-two-rows-into-one-2020-05-17-oeldere2-png57-pt-678067d1589700808-merge-two-rows-into-one-merge_rows_example
Sheet: Sheet1

Player | Team | Color | Points | result | help
[NAME] | [NAME] | White | 4 |  |  |  |  |  | Som [NAME] | Kolomlabels
[NAME] | [NAME] | White | 2 |  |  |  |  |  | Rijlabels | Bluedogs | Bulls | Gothics | [NAME] | Tropics | Vixens | Eindtotaal
[NAME] | [NAME] | White | 3 |  |  |  |  |  | [NAME] |  |  |  |  | 13 |  | 13
[NAME] | Tropics | Orange | 6 |  |  |  |  |  | Orange |  |  |  |  | 13 |  | 13
[NAME] | Tropics | Orange | 7 |  |  |  |  |  | [NAME] |  |  | 4 |  |  |  | 4
[NAME] | Gothics | Black | 4 |  |  |  |  |  | Black |  |  | 4 |  |  |  | 4
Nick | Bluedogs | Blue | 9 |  |  |  |  |  | [NAME] |  |  |  | 9 |  |  | 9
Nick | Bluedogs | Blue | 3 |  |  |  |  |  | White |  |  |  | 9 |  |  | 9
[NAME] | Vixens | Yellow | 5 |  |  |  |  |  | Mark |  | 3 |  |  |  |  | 3
[NAME] | Vixens | Yellow | 3 |  |  |  |  |  | Grey |  | 3 |  |  |  |  | 3
[NAME] | Vixens | Yellow | 10 |  |  |  |  |  | Nick | 12 |  |  |  |  |  | 12
[NAME] | Vixens | Yellow | 8 |  |  |  |  |  | Blue | 12 |  |  |  |  |  | 12
Mark | Bulls | Grey | 3 |  |  |  |  |  | [NAME] |  |  |  |  |  | 26 | 26
 |  |  |  |  |  |  |  |  | Yellow |  |  |  |  |  | 26 | 26
 |  |  |  |  |  |  |  |  | Eindtotaal | 12 | 3 | 4 | 9 | 13 | 26 | 67
Spreadsheet: 881196d1729156947-need-help-creating-cocktail-costs-based-on-amount-and-bottles-used-alcohol-costs
Sheet: Cocktails

Cocktail | Price | Spirit | oz | Spirit | oz | Spirit | oz | Spirit | oz | Spirit | oz | Spirit | oz | Spirit | oz | Spirit | oz
White Russian | 8.5 | Barton Vodka | 1.5 | Kahlua | 1.5 |  | 1.5 |  | 1.5 |  | 1.5 |  | 1.5 |  | 1.5 |  | 1.5 | Examples
Long Island | 7.5 | Barton Vodka | 1.5 | [NAME] | 1.5 | [NAME] | 1.5 | Barton Gin | 1.5 | Triple Sec, Barton | 1.5 |  | 1.5 |  | 1.5 |  | 1.5 | Examples
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Examples
 |  | [NAME], Dekuyper | 1 | Bailey's | 1.5 | Seagrams 7 | 0.5 | 1800 Rep | 1.5
Spreadsheet: 15df2fca-5443-442b-ac69-c31d6b95bf5c
Sheet: Sheet1

Table 6--U.S. commercial rice imports  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Country |  | 2011/12 | 2010/11 | 2010/11 | 2009/10 | 2008/09 | 2007/08
or |  | as of | as of | market | market | market | market
region |  | October 2011  2/ | October 2010 | year | year | year | year
 |  |  |  | 1,000 metric tons
ASIA |  | 129.452 | 125 | 529.789927 | 563.943544 | 536.401387 | 720.1501
China |  | 1.5 | 0.5 | 3.099664 | 3.786815 | 3.951477 | 122.996458
India |  | 25.1 | 24.1 | 96.454493 | 94.809691 | 74.049801 | 119.053533
Pakistan |  | 3.1 | 4.7 | 17.316937 | 19.386689 | 16.851572 | 19.37655
Thailand |  | 94.2 | 92.6 | 393.401422 | 400.976938 | 422.132044 | 454.383251
Vietnam |  | 5 | 2.1 | 15.901274 | 41.55395 | 17.477892 | 0.557244
Other |  | 0.5 | 1 | 3.616137 | 3.429461 | 1.938601 | 3.783064
EUROPE & FSU |  | 4.2 | 2 | 12.509634 | 9.410672 | 7.566448 | 8.544636
Italy |  | 1.8 | 1.2 | 7.529541 | 6.220285 | 5.73241 | 6.322959
Spain |  | 2 | 0.4 | 3.752805 | 1.55218 | 0.419219 | 0.419324
Russia |  | 0.006133 | 0.004275 | 0.034217 | 0.032442 | 0.064456 | 0.109972
United Kingdom |  | 0.037264 | 0 | 0.00935 | 0.126368 | 0.429608 | 0.533302
Other |  | 0.4 | 0.4 | 1.183721 | 1.479397 | 0.920755 | 1.159079
WESTERN HEMISPHERE |  | 15.503 | 5.7 | 42.735403 | 30.357434 | 31.065164 | 28.463008
Argentina |  | 0.6 | 0.9 | 2.677326 | 2.466583 | 1.121503 | 2.633889
Brazil |  | 7.4 | 0.6 | 6.331146 | 3.51007 | 3.902248 | 2.440662
Canada |  | 3.9 | 3.6 | 17.067255 | 15.357974 | 18.035834 | 13.571453
Mexico |  | 0.4 | 0.2 | 1.263642 | 6.120591 | 6.094151 | 9.207343
Uruguay |  | 3.2 | 0.384023 | 15.35029 | 2.871551 | 1.710958 | 0.257859
Other |  | 0 | 0.0096 | 0.045744 | 0.030665 | 0.20047 | 0.351802
OTHER |  | 0.3 | 2.4 | 3.532636 | 5.470538 | 39.298261 | 5.195028
Egypt |  | 0 | 0 | 0 | 0.644508 | 36.591199 | 2.714611
United Arab Emirates |  | 0.157209 | 1.5 | 3.029955 | 4.441327 | 2.224564 | 2.161834
Other |  | 0.07481 | 0.9 | 0.502681 | 0.384703 | 0.482498 | 0.318583
TOTAL |  | 149.534 | 134.3 | 588.5676 | 609.182188 | 614.33126 | 762.352772
1/ Columns labeled "market year" are total August-July imports reported by the U.S. Census Bureau.  2/ Most recent month available.
All data is reported on a product-weight basis.  Categories may not sum to total due to rounding.
Source: U.S. Census Bureau, Department of Commerce.
Last updated December 12, 2011.
Spreadsheet: 854934d1704699666-creating-a-3rd-sheet-with-allowed-ids-and-associated-information-from-a-pivot-table-beispiel
Sheet: Values

Debitor | Buchungsdatum | Belegart | Belegnummer | Belegdatum | Fälligkeitsdatum | Beschreibung | Betrag
200001 | 2023-12-05 00:00:00 | Rechnung | 666666 | 2023-12-10 00:00:00 | 2024-01-09 00:00:00 | Rechnung | 253.53
200002 | 2023-06-04 00:00:00 | Gutschrift | 213123 | 2023-08-04 00:00:00 | 2024-02-02 00:00:00 | Stornierung | -1259
200002 | 2023-07-08 00:00:00 | Rechnung | 142422 | 2023-12-20 00:00:00 | 2024-02-02 00:00:00 | Rechnung | -1837
200003 | 2023-03-31 00:00:00 | Rechnung | 123123 | 2023-12-06 00:00:00 | 2024-02-06 00:00:00 | Rechnung | 5000
200003 | 2022-08-12 00:00:00 | Rechnung | 421565 | 2023-08-12 00:00:00 | 2022-10-26 00:00:00 | Rechnung | -213
Spreadsheet: 491859d1480674518-mulitple-rows-to-a-single-column-leave-blanks-out-test-frames
Sheet: TEST2

 |  |  |  | HeadingA | HeadingB | HeadingC | HeadingD | HeadingE | [NAME] | HeadingG | HeadingH | HeadingI | HeadingJ | HeadingK | HeadingL | HeadingM
 |  |  |  | A1 | B1 | C1 | D1
 |  |  |  | A2 | B2 | C2 | D2 | E2
 |  |  |  | A3 | B3 | [NAME]
 |  |  |  | A4 | B4 | C4 | D4
Spreadsheet: 740633d1626432368-display-text-dependent-upon-todays-date-eh_date-return-2-
Sheet: Sheet1

 |  |  |  |  |  |  | JULY
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING |  | 26 | 3 | DELIVERING |  | 2 |  |  |  | 1 | 2 | 3 | 4
 |  | 27 | 4 |  |  | 3 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | P8 | 28 | 1 |  | Blank cell?? | 4 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | P8 | 29 | 2 |  | P7 | 1 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | P8 | 30 | 3 |  | P7 | 2 | 26 | 27 | 28 | 29 | 30 | 31
WORKING:
DELIVERING
Spreadsheet: 842852d1694845529-retrieve-a-specified-number-of-rows-from-a-table-excel-forum-question-selected-amount-of-rows
Sheet: Sheet1

Row | Date | Revenue | Expense |  |  |  |  |  |  | Row | Date | Revenue | Expense
 | 2023-09-16 00:00:00 | 100 | 50
 | 2023-09-20 00:00:00 | 200 | 50 |  | Choose number of rows: |  |  | 5
 | 2023-09-20 00:00:00 | 300 | 50
 | 2023-10-10 00:00:00 | 400 | 50
 | 2023-10-11 00:00:00 | 500 | 50
 | 2023-10-12 00:00:00 | 600 | 50
 | 2023-10-30 00:00:00 | 700 | 50
 | 2023-10-30 00:00:00 | 800 | 100
 | 2023-11-14 00:00:00 | 900 | 100
 | 2023-11-15 00:00:00 | 1000 | 100
 | 2023-11-16 00:00:00 | 1100 | 100
 | 2023-11-17 00:00:00 | 1200 | 100
 | 2023-12-18 00:00:00 | 1300 | 100
 | 2023-12-18 00:00:00 | 1400 | 200
 | 2023-12-18 00:00:00 | 1500 | 200
 | 2024-01-09 00:00:00 | 1600 | 200
 | 2024-01-10 00:00:00 | 1700 | 200
 | 2024-01-11 00:00:00 | 1800 | 200
 | 2024-03-14 00:00:00 | 1900 | 200
 | 2024-03-18 00:00:00 | 2000 | 200
Spreadsheet: 133721d1324565146-excel-2007-conditional-formatting-for-shortest-time-cd211211
Sheet: Sheet1

 | Wall Clock Time | Processing Time | Indexing Time | Post-Processing Time | Total Time
 | 03:46:12 | 00:59:04 | 03:46:14 | 00:18:41 | 08:50:11
 | Wall Clock Time | Processing Time | Indexing Time | Post-Processing Time | Total Time
 | 02:59:11 | 00:59:01 | 02:59:11 | 00:05:46 | 07:03:09 |  | 1
 | Wall Clock Time | Processing Time | Indexing Time | Post-Processing Time | Total Time
 | 02:59:02 | 01:00:31 | 02:59:02 | 00:08:31 | 07:07:06
Spreadsheet: 270052d1381353168-vlookup-to-display-mgr-by-various-group-codes-team-codes
Sheet: Case2

Manager | Team Codes
[NAME] | 1A
[NAME] | 1B
[NAME] | 1C
[NAME] | 2A
[NAME] | 2B
[NAME] | 2C
[NAME] | 3A
[NAME] | 3B
[NAME] | 3C
Criteria : | [NAME] | <-- input value
No | Team Codes
1
2
3
4
Spreadsheet: 810327d1671691563-help-with-if-or-formula-test-2
Sheet: Ark1

Priming |  |  |  |  |  | Overflate |  | Stål |  |  |  | Pris pr kg ferdig primet verksted
Stål (1,-) | 1 |  |  |  |  | 1. Ubehandlet |  | Prod | 800
 |  |  |  |  |  | 2. Primet |  | Mont | 800
Lakkering |  |  |  |  |  | 3. Våtlakkert |  | Prosjekt | 900
Stål | 1.61 |  |  |  |  | 4. [NAME] |  | Overflate | 2
 |  |  |  |  |  | 5. Duplex |  | Slyng | 0.3
 |  |  |  |  |  | 6. Owatrol |  | Prime | 0
 |  |  |  |  |  |  |  | Stål pr kg | 12.46
 |  |  |  |  |  | IF D13 are "1. Ubehandlet" = 0 or B3
 |  |  |  |  |  | IF D13 are "2. Primet" =  B3
 |  |  |  |  |  | IF D13 are "3. Våtlakkert " = B6
 |  |  |  |  |  | IF D13 are "4. [NAME]" = B3
 |  |  |  |  |  | IF D13 are "5. Duplex" = B3
 |  |  |  |  |  | IF D13 are "6. Owatrol" = B3
Spreadsheet: 870296d1716829865-how-to-convert-table-with-relative-position-number-to-header-of-reference-table-stock-comparison-29-ans-1-
Sheet: Sheet1

 | ?? | 3e | -2-1a | 4? | ?? |  | ??? | 0? | [NAME] | ??? | ?? | ??? | ???
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 1 | 8 | 5 | 4 | 8 | 9 | 15
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 3 | 10 | 7 | 7 | 11 | 15 | 22
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 15 | 19 | 26
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 17 | 19 | 27
 | 1 | 3 | 1 | 2 | 3 | 3 | 6 | 3 | 4 | 12 | 10 | 10 | 18 | 20 | 29
ref table
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 2 | 2 | 4 | 6
all | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 2 | 2 | 4 | 6
[NAME]) | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 1 | 5 | 5 | 3 | 4 | 6 | 9
all(s/fexp) | 1 | 1 | 0 | 0 | 2 | 0 | 3 | 2 | 2 | 7 | 7 | 5 | 6 | 8 | 12
all(s/fexp) | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 2 | 8 | 8 | 7 | 9 | 11 | 15
all(s/fexp) | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 2 | 8 | 8 | 7 | 9 | 11 | 15
 | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 3 | 9 | 9 | 8 | 10 | 12 | 16
 |  | didn't convert
 |  |  | convert table row 6 to below
FORMULA |  | 3e | 1 extt2a | 4? | ?? | 0 | ??? | 0? | [NAME] | ??? | ?? | ??? | ???
 | ?? | t5e | 1extt2 | t8? | ?? |  | ?? | t8? | t7a | ?? | ?? | ??? | ???
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 1 | 8 | 5 | 4 | 8 | 9 | 15
 | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 3 | 10 | 7 | 7 | 11 | 15 | 22
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 15 | 19 | 26
 | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 17 | 19 | 27
 | 1 | 3 | 1 | 2 | 3 | 3 | 6 | 3 | 4 | 12 | 10 | 10 | 18 | 20 | 29
Spreadsheet: 832214d1686187276-index-match-to-return-max-value-in-lookup-array-index-match-fix
Sheet: Sheet1

Find Value | 810 |  | 808 | 717 | 666 | 626 | 585 | 541 | 494 | 454 | 424 | 393 | 363 | 339 | 319 | 302
Matched Value |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N
Matched Letter
Spreadsheet: 773661d1647981872-cell-contain-help-please-currency-conversion-example-tms
Sheet: Sheet1

From Currency | To Currency | & | Rate | formula
AUD | CNY |  | 5 |  | =IF(COUNTIFS($A$2:$A2,$B2,$B$2:$B2,$A2),"",D2)
AUD | NZD |  | 0.98 |  | copied down
AUD | USD |  | 0.72
CNY | AUD |  | no need to enter becasuse we entered AUDCNY
NZD | AUD |  | no need to enter becasuse we entered AUDNZD
USD | AUD |  | no need to enter becasuse we entered AUDUSD