tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 289b27f3-ee27-41ed-9e56-88012f6c3301
Sheet: $ mono by vendor

Monograph Expenditures by Vendor FY11 and FY12
Library | Code | Vendor | FY11 | FY12 | % change | % of total FY12
[NAME] | nbh | PELL BookHouse | 569.59 | 205.99
[NAME] | nksb | PELL Koeltz Scientific Books | 227.42 | 310.8
URI | none | Misc. vendors | 26984.13 | 34134.68
URI | uaca | Academic Book Center | 188 | 0
URI | ualbs | Alibris | 0 | 609.45 | N/A
URI | uanp | American Nurses Publishing | 103.9 | 46.5
URI | ucas | [NAME] | 158.61 | 130.4
URI | uebc | Eastern Book Company | 100761.67 | 159329.37
URI | [NAME] | EBSCO (e-books) | 0 | 52072.02 | N/A
URI | ufac | Facets Multimedia, Inc. | 29.95 | 0
URI | ufro | T Front Musical Literature, Inc. | 0 | 535.35 | N/A
URI | ufmls | URI Film Studies Department | 0 | 154.08 | N/A
URI | ugal | [NAME] books | 0 | 353.16 | N/A
URI | uhar | HARRASSOWITZ | 553.02 | 781.56
URI | [NAME] | HELIN (books through YBP approval pilot) | 179.74 | 0 | 0
URI | uibb | IBERBOOK International, S.L. | 107.25 | 0
URI | [NAME] | Movies Unlimited | 0 | 36.99 | N/A
URI | unwd | New Day Films | 0 | 570 | N/A
URI | upbs | PBS VIDEO | 104.23 | 23.74
URI | ustr | [NAME] | 103007.2 | 50000
URI | [NAME] | Swets (e-books) | 0 | 255 | N/A
URI | uvisa | [NAME] (Amazon & other orders by [NAME]) | 2722.61 | 1030.62
URI | uybp | Yankee Book Peddler | 109334.97 | 35703.81
URI | uybp1 | Yankee Book Peddler | 2121.32 | 14970.02
CCE | xcqp | CCE CongressQuart | 187.85 | 0
 |  | TOTAL
Spreadsheet: 144750d1331126897-if-name-in-a1-make-a3-show-1-ci2
Sheet: Individial Companies

Customer Name | Company ID#
Stapla | 1
Perkin Elemer | 2
[NAME] | 3
Varian Semiconductor | 4
Mass Bay Tech | 5
[NAME] | 6
Allergan | 7
Shire Human Genetics Theapies | 8
BAE Systems | 9
Entegris | 10
Genzyme | 11
Millenium | 12
Cambridge Brands | 13
Employees | 14
U-Mass | 15
Biotest | 16
Intel Mass. Inc | 17
[NAME] | 18
Henkel Corp | 19
Analog Devices | 20
Vaccum Paces | 21
MIT [NAME] | 22
[NAME] | 23
[NAME] | 24
Cathloc Med. | 25
Innovent | 26
Trek Diagostics | 27
[NAME] | 28
Innovative Products | 29
Dakota Systems | 30
IPG Photonics | 31
New England Labs | 32
[NAME] | 33
Instrumentation  Labs | 34
Kulite | 35
Axsvn Tech | 36
State Garden | 37
Clivus | 38
HEPA Damage | 39
Cabot | 40
Seaside Theater | 41
Ratheon Co. | 42
[NAME] | 43
Integra Radionics Inc. | 44
PP Manufacturing Co. | 45
Harvard University | 46
Gibbson Associates | 47
Davst Laboratories | 48
Roca | 49
Cutter Bros. | 50
Lattitude Gallery | 51
[NAME] | 52
DLM Box | 53
QSA Global | 54
Thought Forms | 55
[NAME] | 56
M/A-Com Tech. Sollutions | 57
[NAME] | 58
Damaged Sheet | 59
Materion | 60
Foxwoods Casino | 61
[NAME] | 62
[NAME] | 63
Chewy Inc. | 64
[NAME] | 65
[NAME] | 66
Matrix Equipment | 67
Damaged | 68
Emo | 69
Olympus | 70
Pen Cubes | 71
Non Metalic Solutions | 72
[NAME] | 73
Trimed Innovative Corp. | 74
E & S Technology Inc. | 75
Ahura Scientific | 76
Millennium Pharmaceuticals | 77
Beofund Research | 78
Great Batch Inc. | 79
Town of Burlington | 80
Advanced Design | 81
Lilliputian Systems | 82
[NAME] | 83
Spreadsheet: 6d09b36a-cc94-4bb6-8fe0-3eb0855c8ab6
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
[NAME] | Test | [NAME] | Dexamethasone | Dexamethasone | Tandem Mass Spectrometry (HPLC) | Plain, Red-Top Tube: Red |  |  | 3 | mL | Draw blood in a plain, red-top tube(s). Spin down and separate within 1 hour of collection. Send 3 mL of serum frozen in a plastic vial. Note:  1. Serum gel tube is acceptable, but must pour off into a plastic vial. 2. Minimum volume does not permit for repeat analysis. | Pediatric minimum:  1 mL Note: | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Dexamethasone, Serum* ng/dL   Adults baseline:  <30 8:00 AM following 1 mg dexamethasone Previous evening:  140-295 8:00 AM following 8 mg dexamethasone (4 x 2 mg doses) previous day:  1600-2850   Test Performed By:  Esoterix Endocrinology                               4301 Lost Hills Road                               Calabasas Hills, CA  91301 | Monday | 3-9 days | 5 - 20 days | 1 | 82542 |  |  |  |  | Esoterix Endocrinology
[NAME] | [NAME] | SERUM | Serum |  |  |  | Frozen | 365 days
[NAME] | Result | Z1745 | Dexamethasone | Dexamethasone | Alphanumeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 167959d1342169989-formula-to-auto-calculate-total-amount-at-the-last-row-of-the-day-formula
Sheet: Sheet1

Date | Product | Amount | Total amount of the day
2012-06-20 00:00:00 | AAA | 5
2012-06-20 00:00:00 | BBB | 6
2012-06-20 00:00:00 | CCC | 10
2012-06-21 00:00:00 | BBB | 3
2012-06-21 00:00:00 | CCC | 2
2012-06-21 00:00:00 | DDD | 3
2012-06-21 00:00:00 | BBB | 5
2012-06-22 00:00:00 | AAA | 1
2012-06-22 00:00:00 | BBB | 2
2012-06-22 00:00:00 | CCC | 3
2012-06-22 00:00:00 | DDD | 4
2012-06-22 00:00:00 | EEE | 5
2012-06-22 00:00:00 | BBB | 6
2012-06-22 00:00:00 | CCC | 7
 | Query
 | Is there any formula that we can enter at column C which is able to auto calculate total amount of the day at the last row of the day?
 | Set a formula to pull down, total amount of the day will be calculated at the last row of the day
 | Currently I enter sum formula at the last row of the day to calculate total amount of the day manually. It is not smart enough for a very big file.
 | Please help
 | Hi you can enter the fourmla at the end of the day shown in column F above or see daysummery sheet next
Spreadsheet: ca08ab7d-8f5b-47cf-af44-b65953420719
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259062 | 71875 | [NAME] | Priest | RSA |  | 00:40:57 | 00:00:00 | 01:21:08 | 00:00:00 | 00:21:59 | 1 | 02:24:04
259062 | 71870 | Toni | Snoxell | RSA |  | 00:38:21 | 00:00:00 | 01:25:24 | 00:00:00 | 00:20:30 | 2 | 02:24:15
259062 | 71874 | Naomi | [NAME] | RSA |  | 00:39:11 | 00:00:00 | 01:25:58 | 00:00:00 | 00:21:18 | 3 | 02:26:27
259062 | 71873 | Esmari | Goosen | RSA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 02:28:33
259062 | 71872 | Dane | Phaal | RSA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 455551d1460395807-formula-for-creating-dashboards-from-data-arranged-by-date-and-by-sales-rep-dashboard-problem-example
Sheet: Leads Generated by Sales Rep

 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Fred | Greg | Holly
Period Began | 2016-04-01 00:00:00
Period End | 2016-04-30 00:00:00
 | Actuals
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: susan_pereira__39450__ENRON
Sheet: ENRON

 | VARIBUS CORPORATION |  |  |  |  |  |  |  | MAY 31, 1999 |  |  |  |  |  |  | {SERVICES}PSNU~QAGQ
 | P.O. BOX 61000
 | NEW ORLEANS, LA 70161 |  |  |  |  |  | INVOICE NUMBER |  |  |  |  | 99-05-07
 | PH# (504)576-4152
 | IN ACCOUNT WITH
 | ENRON CAPITAL & TRADE RESOURCE CORP. |  |  |  |  |  |  |  | AMOUNT
 | Attn: [NAME]
 | 1400 SMITH, SUITE 3707
 | Houston, Texas 77002
 |  |  |  |  |  | PER
MMBTU'S |  |  | [NAME] |  |  | MMBTU |  |  |  |  |  | AMOUNT
40000 |  |  | Natural Gas Transported to |  |  | 0.03 |  |  |  |  |  | 1200
 |  |  | GSU at [NAME] in
 |  |  | April 1999 (TETCO)
 |  |  | Contact Person
 |  |  | Accounting Question
 |  |  | [NAME]Ph# (504)576-4152
 |  |  | Operational Questions
 |  |  | [NAME] Ph# (281)297-3553
 |  |  |  | TOTAL AMOUNT DUE
 | PLEASE REMIT TO:
 | VARIBUS
 | P.O. BOX 61000
 | NEW  ORLEANS, LA.   70161
 | Attn: [NAME]
Spreadsheet: 27759d1221315587-formattin-a-report-properties-2-
Sheet: Sheet1

Req# | Date Opened | Date Needed By | Customer Name | Proerties 1 &2
111 | 2008-08-14 00:00:00 | 2008-08-16 00:00:00 | [NAME] | abc
111 | 2008-08-14 00:00:00 | 2008-08-16 00:00:00 | [NAME] | cbs
222 | 2008-08-15 00:00:00 | 2008-08-16 00:00:00 | mrs smith | def
222 | 2008-08-15 00:00:00 | 2008-08-16 00:00:00 | mrs smith | deg
333 | 2008-08-15 00:00:00 | 2008-08-16 00:00:00 | miss [NAME] | sss
333 | 2008-08-15 00:00:00 | 2008-08-16 00:00:00 | miss [NAME] | sst
444 | 2008-08-15 00:00:00 | 2008-08-16 00:00:00 | [NAME] | nnn
444 | 2008-08-15 00:00:00 | 2008-08-16 00:00:00 | [NAME] | mmm
555 | 2008-09-13 00:00:00 | 2008-09-16 00:00:00 | [NAME] | jjj
555 | 2008-09-13 00:00:00 | 2008-08-16 00:00:00 | [NAME] | kkk
Spreadsheet: 3ac3c357-3b4a-41c5-ad37-505387ce3959
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
[NAME]
 | Ingredients
 | You will need the following ingredients to prepare enough jerk chicken for 4 people:-
 | [NAME] One 3 1/2 lb chicken (Family size legs with thighs work great if preferred)
 | 6 sliced scotch bonnet peppers (jalapenos may be used if scotch bonnet peppers are unavailable)
 | 2 Tbsp. Fresh thyme
 | 2 Tbsp. ground allspice
 | 8 Cloves garlic, finely chopped
 | 3 Medium onions, finely chopped
 | 2 Tbsp. sugar
 | 2 Tbsp. salt
 | 2 tsp. ground black pepper
 | 1 to 2 tsp. of the following (to taste)
 | -ground cinnamon (2 tsp.)
 | -nutmeg (1 tsp. )
 | -ginger (2+ tsp.)
 | **Tomato Paste two to three teaspoons
 | **[NAME] teaspoon+ to taste
 | 1/2 cup olive oil
 | 1/2 cup soy sauce
 | Juice of one lime (1 Tbsp. + 1 tsp.)
 | 1 cup orange juice
 | 1 cup white vinegar
 | Preparation
 | Chop the onion, garlic and peppers. These do not need to be chopped too fine, as the blender will
 | liquefy them.  Seed the peppers 1st, leeks may be substituted for people who have stomach troubles with onions.
 | Making the marinade - Blend all of the ingredients (excluding the chicken) in a blender to make the jerk sauce.
 | Pulse till a paste.
 | Cut the raw chicken up in to 4 pieces, if using whole chicken.
 | Rub the sauce in to the meat, saving some for basting and dipping later.
 | Leave the chicken in the fridge to marinate overnight.
 | Smoke for 3+ hrs at 225 or grill slow, mopping on more [NAME] as you go.
 | If smoking finish on grill to crisp up skin and char the spices some.
 | Serve with ice cold Red Stripe and the cheap dinner rolls, along with rice and peas.
Spreadsheet: 586795d1534633432-basketball-table-and-best-second-places-womens-eb-qualifier-tables
Sheet: GroupA

GROUP A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS | rank
Team name | Bonus/penalty points
Slovakia
Montenegro
Bosnia
Iceland
ROUND 1 |  |  |  |  |  |  | Table
 |  |  | :
 |  | 76 | : | 55 |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS
 |  | 78 | : | 62
 |  | 79 | : | 67
 |  |  | :
 |  | 69 | : | 37
ROUND 2
 |  | 72 | : | 73
 |  |  | :
 |  |  | :
 |  | 100 | : | 95
 |  | 97 | : | 67
 |  | 62 | : | 84
Spreadsheet: 776378d1649705562-automatically-lock-rows-if-columns-equals-specified-values-dashboard-test
Sheet: OVERVIEW 3

TYPE | (Tous)
 | Étiquettes de colonnes
 | HTVA |  |  | TVAC |  |  | Total HTVA | Total TVAC
PÉRIODE | canceled | received | to receive | canceled | received | to receive
2023 |  |  | 2950 |  |  | 2950 | 2950 | 2950
Q1 |  |  | 2950 |  |  | 2950 | 2950 | 2950
2024 |  |  | 2950 |  |  | 2950 | 2950 | 2950
Q1 |  |  | 2950 |  |  | 2950 | 2950 | 2950
2025 |  |  | 3538 |  |  | 3538 | 3538 | 3538
Q1 |  |  | 3538 |  |  | 3538 | 3538 | 3538
2021 |  | 6290 |  |  | 6290 |  | 6290 | 6290
Q3 |  | 1790 |  |  | 1790 |  | 1790 | 1790
Q4 |  | 4500 |  |  | 4500 |  | 4500 | 4500
2022 | 16.92 | 4105.46 | 3882.5 | 16.92 | 4105.46 | 3882.5 | 8004.88 | 8004.88
Q1 | 16.92 | 4105.46 |  | 16.92 | 4105.46 |  | 4122.38 | 4122.38
Q2 |  |  | 3882.5 |  |  | 3882.5 | 3882.5 | 3882.5
TOTAL | 16.92 | 10395.46 | 13320.5 | 16.92 | 10395.46 | 13320.5 | 23732.88 | 23732.88
The problem is that your "Year" column has some Text and some Numbers mixed together. [NAME] a column E and check the Year column with "=IsText(D2)" and pull it down. You are trying to sort numbers and text in your pivot table. That is the problem. Make all the Year values or numbers and try it again.
Spreadsheet: 1d883dce-d53f-4c05-a5ce-6e0ee229e8c1
Sheet: Sheet1

Unnamed: 0 | EC REGULATION 785/2004 INSURANCE ESTIMATOR | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  | SDR Definition
 |  |  |  |  |  | SDR Equivalent in |  | SDR Equivalent in
 | Enter data here |  | Insurance Minimum | SDRs Million |  | £ - Million |  | $ - Million
Aircraft Maximum Take off Mass (kgs) |  |  | Third party | 0.75 |  | 0.7396449704142012 |  | 1.144023668639053
Number of Passenger seats |  |  | Passenger | 0 |  | 0 |  | 0
Cargo Payload |  |  | Baggage | 0 |  | 0 |  | 0
 |  |  | Cargo | 0 |  | 0 |  | 0
Commercial use (Enter Yes or No Only) | Yes |  | Combined Single Limit Required | 0.75 |  | 0.7396449704142012 |  | 1.144023668639053
(Commercial includes Operating Licence holders)
 |  |  | War Risk Required | 0.75
6 |  |  | 1
Insurance category being calculated = | Commercial |  | Note the results given are estimates only
Exchange Rate (£)
Dollar | 1.54672
SDR | 1.014
Correct at | 2013-02-18 00:00:00
Instructions
1) Enter details of Maximum Take off Mass - For UK registered aircraft this can be found at |  |  |  |  |  | CAA UK Aircraft Register
2) Enter details of passenger seats (not crew)
3) Enter aircraft cargo payload (if known)
4) Is the aircraft used for Commercial or Private Use (only Type Yes or No - Default position is No - The Insurance category being calculated is shown in Red.  Check this meets your requirement. |  |  |  |  |  |  |  | Airline Licensing & Consumer Issues
Notes
1) Council Regulation minima are calculated in Special Drawing Rights (SDRs)  The sterling and dollar equivalents are for information only. Its is prudent to buy cover in excess of minima to allow for exchange rate movements.
2) Aircraft in this context includes balloons, gliders, gyroplanes and helicopters.
Spreadsheet: 135691d1326188585-how-to-automatically-refresh-filter-by-data-shange-workbook-of-grades
Sheet: duomenys

 |  | PASIRINKITE TECHNOLOGIJŲ SRITĮ
 |  | [NAME] ir mityba
 |  | Technologijos-Statyba ir medžio apdirbimas
 |  | Technologijos-Tekstilė ir apranga
 |  | Technologijos-Taikomasis menas, amatai ir dizainas
 |  | [NAME], [NAME]
 |  | PASIRINKITE KONSULTACINĮ PUNKTĄ
 |  | Trakų Nr.1 konsultacinio punkto
 |  | Trakų Nr.2 konsultacinio punkto
 |  | [NAME] konsultacinio punkto
 |  | Aukštadvario konsultacinio punkto
 |  | [NAME] konsultacinio punkto
 |  | [NAME] konsultacinio punkto
 |  | Lentvario Nr.1 konsultacinio punkto
 |  | Lentvario Nr.2 konsultacinio punkto
 |  | Molėtų konsultacinio punkto
 |  | Neįgaliųjų konsultacinio punkto
 |  | Paluknio konsultacinio punkto
 |  | Pastrėvio konsultacinio punkto
 |  | Vilniaus Romų konsultacinio punkto
 |  | Rūdiškių Nr.1 konsultacinio punkto
 |  | Rūdiškių Nr.2 konsultacinio punkto
 |  | Senųjų Trakų konsultacinio punkto
 |  | Vievio konsultacinio punkto
 |  | A įsk.
 |  | A neįsk.
 |  | B įsk.
 |  | B neįsk.
 |  | A10
 |  | B10
 |  | A9
 |  | B9
 |  | A8
 |  | B8
 |  | A7
 |  | B7
 |  | A6
 |  | B6
 |  | A5
 |  | B5
 |  | A4
 |  | B4
 |  | A3
 |  | B3
 |  | A2
 |  | B2
 |  | A1
 |  | B1
 |  | neat.
 |  | A10 ad.
 |  | B10 ad.
 |  | A9 ad.
 |  | B9 ad.
 |  | A8 ad.
 |  | B8 ad.
 |  | A7 ad.
 |  | B7 ad.
 |  | A6 ad.
 |  | B6 ad.
 |  | A5 ad.
 |  | B5 ad.
 |  | A4 ad.
 |  | B4 ad.
 |  | A3 ad.
 |  | B3 ad.
 |  | A2 ad.
 |  | B2 ad.
 |  | A1 ad.
 |  | B1 ad.
 |  | A10,B10,A9,B9,A8,B8,A7,B7,A6,B6,A5,B5,A4,B4,A3,B3,A2,B2,A1,B1,10 ad.,9 ad.,8 ad.,7 ad.,6 ad.,5 ad.,4 ad.,3 ad.,2 ad.,1 ad.[NAME][NAME].[NAME][NAME],neat.
 |  | B10,B9,B8,B7,B6,B5,B4,B3,B2,B1,neat.,B10 ad.,B9 ad.,B8 ad.,B7 ad.,B6 ad.,B5 ad.,B4 ad.,B3 ad.,B2 ad.,B1 ad.
Spreadsheet: 37933d1236040886-need-help-with-conditional-formula-test
Sheet: Sheet1

Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Weekly Rollup |  | Totals in $
5 | 5 | 5 | 5 | 5 | 5 | 0 | Feature RPH | 0.5714285714285714 |  | 30
1 | 1 | 1 | 0 | 0 | 0 | 0 | Access RPH | 0.05714285714285714 |  | 3
6 | 6 | 6 | 5 | 5 | 5 | 0 | Total RPH | 0.6285714285714286 |  | 42
 |  |  | Features | Access
 | Sunday |  | 5 | 1
 | Monday |  | 5 | 1
 | Tuesday |  | 5 | 1
 | Wednesday |  | 5
 | Thursday |  | 5
 | Friday |  | 5
 | Saturday
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 101751 | 98243
2 | 102927 | 104706
3 | 117477 | 116286
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
2001-11-30 00:00:00 |  |  | -47216
2001-12-03 00:00:00
CBS Dollars
 |  |  | 234489 |  |  |  | 12
 |  |  |  |  |  |  | 500
 |  |  |  |  |  |  | 5895
Spreadsheet: a69466eb-5441-4c8f-ab0c-b2bd50c02e91
Sheet: New  Table 17

Table 17
Weekly Port Region Grain Ocean Vessel Activity (number of vessels)
 |  |  |  | Pacific | Vancouver
 | Gulf |  |  | Northwest | B.C.
 |  | Loaded | Due next
Date | In port | 7-days | 10-days | In port | In port
2013 range | (16..60) | (20..56) | (31..81) | (0..24) | n/a
2013 avg. | 32 | 33 | 51 | 12 | n/a
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: 888285d1738777785-summary-of-data-book2
Sheet: Sheet1

 | data | Color
 | 500 | Red
 | 501 | Green |  | Row Labels | Colors
 | 502 | Red |  | 500 | Red
 | 502 | Red |  | 501 | Green
 | 503 | Blue |  | 502 | Red
 | 504 | Purple |  | 503 | Blue
 | 504 | Red |  | 504 | Red,Blue,Purple
 | 504 | Blue |  | 505 | Green
 | 505 | Green |  | 506 | Yellow
 | 506 | Yellow |  | 507 | Black
 | 507 | Black
Spreadsheet: 265940d1379443564-lookup-a-range-range-lookup-formula-example
Sheet: Range Lookup Formula

 |  |  | Range Lookup Excel
 |  |  | Lookup Value | 2
 |  |  | [NAME] in | Row no. 13
 |  |  | Start | End
 | 1 | 50%+ < List | -1 | 0.5
 | 2 | 33% to 50% < List | 0.501 | 0.6666
 | 3 | 20% to 33% < List | 0.6667 | 0.8
 | 4 | 10% to 20% < List | 0.801 | 0.9
 | 5 | 5% to 10% < List | 0.901 | 0.95
 | 6 | 0% to 5% < List | 0.951 | 0.9999
 | 7 | List Price | 1 | 1
 | 8 | 0% to 5% > List | 1.001 | 1.05
 | 9 | 5% to 10% > List | 1.051 | 1.1
 | 10 | 10% to 20% > List | 1.101 | 1.2
 | 11 | 20% to 33% > List | 1.201 | 1.3333
 | 12 | 33% to 50% > List | 1.3334 | 1.5
 | 13 | 50%+ > List | 1.501 | 10
Spreadsheet: 786436d1657193276-calculating-whether-a-range-of-values-falls-inside-or-outside-of-a-min-and-max-range-risk-appetite-tracker-sample-file
Sheet: Key Risk Metrics - Master

[NAME] | SMT Owner | Key Risk Indicator | Jun 22 Actual | Jul 22 Actual | Aug 22 Actual | Sep 22 Actual | Oct 22 Value | Nov-22 Actual | [NAME] | [NAME] | Feb-23 Actual | Mar-23 Actual | KRI Trend | KRI Flag | Minimum Threshold | [NAME] | [NAME] | [NAME]
Category 1 | JB | KRI 1 % of… | -0.055 | -0.04 |  |  |  |  |  |  |  |  | OK |  | -0.05 | 0.05 | Inside
Category 2 | SD | KRI 2 No. of | 159000 | 300000 |  |  |  |  |  |  |  |  | OK |  | £500K | £2M | Inside
Category 3 | SD | KRI 3 No. of | 0 | 2 |  |  |  |  |  |  |  |  | OK |  | 0 | 5 | Inside
Category 3 | JB | KRI 4 No. of | 0 | 3 |  |  |  |  |  |  |  |  | Worried |  | 0 | 5 | Inside
Category 3 | AL | KRI 5  % of… | 0.97 | 0.93 |  |  |  |  |  |  |  |  | Worried |  | 0.95 | 0.9 | Outside
Category 2 | AL | KRI 6 No of… | 3 | 3 |  |  |  |  |  |  |  |  | No Change |  | 1 | 5 | Inside
Category 1 | SD | KRI 7  % of… | 0.15 | 0.12 |  |  |  |  |  |  |  |  | OK |  | 0.03 | 0.2 | Inside
Category 1 | JB | KRI 8  % of… | 0.28 | 0.15 |  |  |  |  |  |  |  |  | OK |  | 0.1 | 0.35 | Inside
Spreadsheet: 862796d1710413064-lookinf-for-a-formula-to-compare-columns-ip-common
Sheet: Sheet1

IP1 | IP2 | IP3 | IP4
172.185.32.1 | 172.555.231.2 | 199.99.85.2 | 166.896.12.1
199.258.2.1 | 144.254.32.25 | 198.87.65.2 | 123.454.65.8
199.257.5.2 | 199.99.85.2 | 172.555.231.2 | 136.258.35.2
166.896.12.1 | 172.185.32.1 | 144.254.32.25 | 172.555.231.2
 |  |  | 172.185.32.1
Spreadsheet: 221448d1363555362-inventory-problem-inventory2
Sheet: Blad1

 |  |  |  |  |  |  | sales |  |  |  |  |  |  |  |  |  | MONTH
 |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | AUG
 |  | 2013-02-28 00:00:00 | days to delivery | 2013-01-31 00:00:00 | 2013-02-28 00:00:00 | 2013-03-30 00:00:00 | 2013-04-30 00:00:00 | 2013-05-31 00:00:00 | 2013-06-30 00:00:00 | 2013-07-31 00:00:00 | 2013-08-31 00:00:00 | 2013-09-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-30 00:00:00 | 31/11/2013 | minimum order | date order
 | product 1 | 800 | 30 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400
 | product 2
 | Product 3
Spreadsheet: 821552d1678793352-excel-formula-to-calculate-inflation-conversion-factor-conversion-factor
Sheet: Sheet1

 | Kindly asking for excel formula to calculate conversion factor - column E
 | Monrh | Indices | Inflation rate | Conversion factors
 | 2021-12-01 00:00:00 | 2474.51 | 4.22 | 1.61
 | 2022-01-01 00:00:00 | 2608.79 | 5.43 | 1.52
 | 2022-02-01 00:00:00 | 2698.89 | 3.45 | 1.47
 | 2022-03-01 00:00:00 | 2759.83 | 2.26 | 1.44
 | 2022-04-01 00:00:00 | 2803.57 | 1.58 | 1.42
 | 2022-05-01 00:00:00 | 2874.85 | 2.54 | 1.38
 | 2022-06-01 00:00:00 | 2986.44 | 3.88 | 1.33
 | 2022-07-01 00:00:00 | 3062.93 | 2.56 | 1.3
 | 2022-08-01 00:00:00 | 3191.19 | 4.19 | 1.25
 | 2022-09-01 00:00:00 | 3342.02 | 4.73 | 1.19
 | 2022-10-01 00:00:00 | 3555.9 | 6.4 | 1.12
 | 2022-11-01 00:00:00 | 3760.86 | 5.76 | 1.06
 | 2022-12-01 00:00:00 | 3977.46 | 5.76 | 1
Spreadsheet: 122203d1316657320-excel-2007-last-cell-with-data-linked-to-another-column-joe-at-all-the-pies
Sheet: Sheet1

Name | Date | Drinks | Pies
Fred | 2010-01-01 00:00:00 | 5 | 4 |  |  | Name | [NAME]
[NAME] | 2010-01-01 00:00:00 | 8 | 56 |  |  | Pies | ?
[NAME] | 2010-01-01 00:00:00 | 99 | 3
Fred | 2010-02-02 00:00:00 | 4 | 2
[NAME] | 2010-02-02 00:00:00 | 1
Fred | 2010-03-03 00:00:00 | 3 | 5
Spreadsheet: 805778d1668910586-how-to-combine-the-same-cells-plus-commas-in-different-cells-product-list
Sheet: Sheet1

Product | Size
sepatu logo | 39
sepatu logo | 40
sepatu logo | 41
sepatu logo | 42
Sepatu att | 38
Sepatu att | 39
Sepatu att | 40
Sepatu att | 41
Sepatu att | 42
desired result
Product | size
sepatu logo | 39,40,41,42
[NAME] | 38,39,40,41,42
Spreadsheet: 719729d1613768652-how-to-extract-the-average-price-sss
Sheet: Arkusz1

 |  |  | [NAME]:
 |  |  | I |  | II |  | III |  | IV |  | V
 |  |  | Price | Amount | Price | Amount | Price | Amount | Price | Amount | Price | Amount |  | AVERAGE PRICE:
 |  |  | 33.1 | 25 | 27.5 | 50 | 45.2 | 40 | 17.7 | 15 | 20.35 | 70