tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 739618d1625827177-automatically-insert-images-in-cells-sample
Sheet: Stock By Brand

Code | Des | Brand | WH | Onhand SUM | Part Image
676K65020 | FEED ROLLER [NAME] | Xerox | WH IT | 4 | I want the image on my PC to be inserted here automaticly based on the Code, the image is renamed after the code showing in cell A2126
604K58410 | [NAME] FEED R | Xerox | WH IT | 12
603T80282 | CLEANING CLOTH | Xerox | WH IT | 5
Spreadsheet: 726524d1617284253-need-help-with-vlookup-based-on-if-and-and-vlookup-with-if-and
Sheet: Product A

 | Customer name | Product A
 | [NAME]
 | ASAP
 | PLSE
 | ADEV
 | ALKP
 | DPQE
 | CLCS
 | FNUP
 | VWPO
 | CP3O
 | VSOP
 | MANU
 | MANC
 | LIVP
 | ARSE
Spreadsheet: 886291d1736331855-doing-sum-doing-sum
Sheet: Required1

 | New Testament |  | 1 | 2
 | List | Code | Papermint | Papermint
 | [NAME] | 119232628
 | Amit Chaudary | 119212921
 | Arjun PD Yadav
 | Arjun Razzak | 119232448
 | Ajal Kumar Mukhiya | 139420531
 | [NAME] | 119213117
 | [NAME] | 119228041
 | [NAME]
 | [NAME]. Mandal | 119227334
 | Total
Spreadsheet: f60de1a4-1e20-4ad6-b4be-9ef576bf62fc
Sheet: Sheet1

State Representative (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Downloaded at 6/19/2013 4:38:56 AM
Precincts Reporting: 696/696 - Total Ballots Cast: 292249
2000 General Election - OFFICIAL RESULTS
County | [NAME] | [NAME] | [NAME] | [NAME] [NAME] | TOTALS
Pembina | 221 | 513 | 494 | 355 | 1583
Walsh | 1453 | 2222 | 2003 | 1767 | 7445
TOTAL | 1674 | 2735 | 2497 | 2122 | 9028
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 130610d1322487432-linking-formula-for-two-spreadsheets-b
Sheet: Sheet1

 | PREFERRED MODE
 | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 | x | y | x | y | x | y | x | y | x | y | x | y | x | y | x | y | x | y | x | y
Spreadsheet: b3a783b6-4ff4-4948-ba7e-0d7f123a43f5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
4351 | 15355 | [NAME] | [NAME] | USA | 0 |  |  |  |  |  | 1 | 02:02:19 | Elite Men
4351 | 10421 | Greg | Welch | AUS | 0 |  |  |  |  |  | 2 |  | Elite Men
4351 | 26725 | [NAME] | Kearns | USA | 0 |  |  |  |  |  | 3 |  | Elite Men
4350 | 15387 | Erin | [NAME] | NZL | 0 |  |  |  |  |  | 1 | 02:21:53 | Elite Women
4350 | 10334 | [NAME] | Smyers | USA | 0 |  |  |  |  |  | 2 |  | Elite Women
4350 | 15296 | Joy | [NAME] | USA | 0 |  |  |  |  |  | 3 |  | Elite Women
Spreadsheet: 190901d1351837815-how-to-start-a-scatter-chart-axis-values-from-different-figures-sales-vs-profit
Sheet: Sheet7

 | Cost | FTE
2007/08 | 11695000 | 101
2008/09 | 14396000 | 112
2009/10 | 21884000 | 111.6
2010/11 | 21644000 | 117
2011/12 | 22924000 | 126
2012/13 | 27500000
2013/14 | 29299000
2014/15 | 31263000
2015/16 | 33406000
2016/17 | 41684000
Spreadsheet: 203718d1357229169-database-building-issues-example-for-help
Sheet: Sheet1

date |  |  |  |  |  |  |  |  |  | Can someone help?
month | contract a | contract b | contract c | contract d | contract e | contract f |  |  |  | I want to be able to create a database which stores all the data in the tables on the left and
1 |  |  |  |  |  |  |  |  |  | I want to be able to retrieve the numbers and plot as follows:
2 |  |  |  |  |  |  |  |  |  | for example (manual example)- i want to extract the values of contract b month 3 for the last 3 days
3
4 |  |  |  |  |  |  |  |  |  | date | contract b/month 3
5
6
7
8
9
10 |  |  |  |  |  |  |  |  |  | And then plot them in a graph
11
12
date
month | contract a | contract b | contract c | contract d | contract e | contract f
1 | 6.77 | 52.62 | 90.09 | 75.78 | 92.49 | 92.76
2 | 10.93 | 97.94 | 3.77 | 90.83 | 95.61 | 75.21
3 | 95.31 | 56.21 | 60.79 | 55.84 | 61.1 | 77.72
4 | 31.62 | 80.41 | 71.08 | 39.67 | 84.15 | 6.38
5 | 86.82 | 89.69 | 94.08 | 4.85 | 5.2 | 87.4
6 | 12.9 | 77.97 | 88.13 | 97.27 | 47.88 | 40.01
7 | 50.58 | 91.39 | 83.05 | 84.59 | 18.02 | 64.22
8 | 26.61 | 9.69 | 41.52 | 59.08 | 54.57 | 34.02
9 | 53.33 | 4.57 | 29.38 | 44.8 | 47.34 | 97.94
10 | 79.08 | 1.65 | 6.08 | 50.87 | 44.23 | 46.33
11 | 90.18 | 62.19 | 69.83 | 38.24 | 58.71 | 79.74
12 | 99.86 | 84.08 | 71.14 | 17 | 17.27 | 54.53
month | contract a | contract b | contract c | contract d | contract e | contract f
1 | 72.46 | 54.35 | 49.5 | 76.77 | 59.43 | 86.98
2 | 29.72 | 9.04 | 66.09 | 90.92 | 44.6 | 80.98
3 | 11.4 | 73.61 | 53.12 | 80.22 | 14 | 66.9
4 | 94.86 | 41.84 | 21.5 | 51.25 | 70.81 | 8.78
5 | 5.37 | 6.9 | 49.94 | 25.88 | 22.55 | 38.82
6 | 84.69 | 95.31 | 36.78 | 22.39 | 89.9 | 67.78
7 | 8.13 | 54.18 | 29.51 | 90.93 | 97.46 | 3.64
8 | 49.48 | 59.6 | 82.53 | 93.47 | 24.26 | 16.35
9 | 35.51 | 60.45 | 70.7 | 13.07 | 21.07 | 1.67
10 | 65.02 | 59.76 | 17.56 | 66.82 | 3.26 | 28.47
11 | 8.92 | 4.45 | 12.73 | 77.56 | 36.63 | 43.04
12 | 84.49 | 20.2 | 50.06 | 12.69 | 13.68 | 67.78
Spreadsheet: 825523d1681377840-how-to-get-sum-of-rows-where-several-rows-are-empty-in-between-gettotalsumofeachfieldname
Sheet: Sheet1

Field name |  | Total Time par fields
Test1
Test2
Test3
Test4
Test5
Test6
[NAME]
Test8
Test9
Spreadsheet: monique_sanchez__28317__newdeals
Sheet: West-SJ

Deal Num | EOL Id | Deal Type | Commodity | B/S | Counterparty | P/F | Start Date | End Date | Risk Type | Price Ref | [NAME] | Volume | UOM | Frequency | Position | Contract Price | Curve | Deal Value | Modified By | Last Modified | Broker | Broker Fee | Sitara Id
VE4622.1 |  | SWP | NG | BUY | GD-NEWJR | FIN | 2001-07-01 00:00:00 | 2001-10-31 00:00:00 |  | NX1 | IF-NWPL_ROCKY_M | 20000 | MMBTU | DAY |  | -1.219 |  | 1748.15059644912 | [NAME] | 37046.6456134259
VE4616.1 |  | SWP | NG | BUY | Reliant Energy Services, Inc. | FIN | 2001-11-01 00:00:00 | 2002-03-31 00:00:00 |  | NX1 | IF-ELPO/SJ | 10000 | MMBTU | DAY |  | -0.25 |  | 0 | [NAME] | 37046.6446412037 | Prebon Yamane, USA Inc. | 377.5
VE4524.1 | 1335830 | SWP | NG | BUY | GD-NEWJR | FIN | 2001-07-01 00:00:00 | 2001-09-30 00:00:00 |  | NX1 | IF-ELPO/SJ | 3500 | MMBTU | DAY |  | -0.74 |  | -2295.54132453758 | Tagg Bridge | 37046.6296412037
VE4470.1 | 1335806 | SWP | NG | BUY | GD-NEWJR | FIN | 2001-10-01 00:00:00 | 2001-10-31 00:00:00 |  | NX1 | IF-ELPO/SJ | 5000 | MMBTU | DAY |  | -0.485 |  | 3058.93654744125 | Tagg Bridge | 37046.6211458333
VE4469.1 | 1335804 | SWP | NG | BUY | GD-NEWJR | FIN | 2001-09-01 00:00:00 | 2001-09-30 00:00:00 |  | NX1 | IF-ELPO/SJ | 10000 | MMBTU | DAY |  | -0.71 |  | -0.00637296192465325 | Tagg Bridge | 37046.6210648148
VE4468.1 | 1335803 | SWP | NG | BUY | GD-NEWJR | FIN | 2001-08-01 00:00:00 | 2001-08-31 00:00:00 |  | NX1 | IF-ELPO/SJ | 10000 | MMBTU | DAY |  | -0.72 |  | 0.00880968644357811 | Tagg Bridge | 37046.6210300926
VE4467.1 | 1335802 | SWP | NG | BUY | GD-NEWJR | FIN | 2001-07-01 00:00:00 | 2001-07-31 00:00:00 |  | NX1 | IF-ELPO/SJ | 10000 | MMBTU | DAY |  | -0.83 |  | 6179.18397762564 | Tagg Bridge | 37046.6209953704
Spreadsheet: a1e44e4c-32bb-42f5-8e3b-70d3785ac166
Sheet: Sheet1

Global X MLP ETF | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | Fund Holdings Data as of 8/29/2014
% of Net Assets | Name | Identifier | Market Price($) | Shares Held | Market Value($)
6.08 | KINDER MORGAN ENERGY PRTN | 494550106 | 96.38 | 81365 | 7841958.7
5.67 | MARKWEST ENERGY-PART UTS | 570759100 | 79.73 | 91730 | 7313632.9
5.61 | MAGELLAN MIDSTREAM | 559080106 | 83.93 | 86226 | 7236948.18
5.48 | ENTERPRISE PRODUCTS PRTNR | 293792107 | 40.63 | 174032 | 7070920.16
5.41 | SPECTRA ENERGY PARTNERS | 84756N109 | 56.99 | 122357 | 6973125.43
5.29 | ACCESS MIDSTREAM PARTNERS | 00434L109 | 64.35 | 105917 | 6815758.95
5.18 | PLAINS ALL AMERN PIP | 726503105 | 59.93 | 111457 | 6679618.01
4.98 | [NAME] PARTNERS | 118230101 | 79 | 81198 | 6414642
4.94 | ENERGY TRANSFER PARTNERSP | 29273R109 | 57.45 | 110978 | 6375686.1
4.9 | [NAME] PARTNERS LP | 96950F104 | 53.01 | 119071 | 6311953.71
4.88 | ONEOK PARTNERS LP | 68268N103 | 59.43 | 105880 | 6292448.4
4.45 | ENBRIDGE ENERGY PARTNERS | 29250R106 | 36.32 | 158142 | 5743717.44
4.35 | TARGA RESOURCES PARTNERS | 87611X105 | 74.4 | 75330 | 5604552
4.04 | SUNOCO LOGISTICS PRTS | 86764L108 | 49.48 | 105206 | 5205592.88
3.32 | REGENCY ENERGY PARTNERS | 75885Y107 | 32.98 | 129832 | 4281859.36
3.13 | EL PASO PIPELINE PART LP | 283702108 | 41.56 | 96944 | 4028992.64
3.04 | WESTERN GAS PARTNERS L.P. | 958254104 | 77.49 | 50596 | 3920684.04
2.94 | NUSTAR ENERGY LP | 67058H102 | 66.09 | 57270 | 3784974.3
2.79 | DCP MIDSTREAM PARTNER LLP | 23311P100 | 56.58 | 63489 | 3592207.62
2.19 | GENESIS ENERGY L.P. | 371927104 | 55.7 | 50799 | 2829504.3
2.18 | AMERIGAS PARTNERS-LP | 030975106 | 46.27 | 60757 | 2811226.39
2.02 | CRESTWOOD MIDSTREAM PART | 226378107 | 23.36 | 111524 | 2605200.64
1.67 | ENLINK MIDSTREAM PARTNERS | 29336U107 | 30.99 | 69542 | 2155106.58
1.57 | [NAME] | 87233Q108 | 58.62 | 34455 | 2019752.1
1.55 | ATLAS PIPELINE PARTNERS | 049392103 | 36.93 | 54005 | 1994404.65
1.54 | SUBURBAN PROPANE PARTNERS | 864482104 | 44.47 | 44506 | 1979181.82
1.46 | TESORO LOGISTICS LP | 88160T107 | 70.28 | 26782 | 1882238.96
1.37 | NGL ENERGY PARTNERS LP | 62913M107 | 42.58 | 41490 | 1766644.2
1.22 | ALLIANCE RESOURCE PTNRLP | 01877R108 | 49.76 | 31651 | 1574953.76
1.11 | [NAME]. PART. | 096627104 | 19.95 | 71633 | 1429078.35
1.09 | EV ENERGY PARTNERS L.P. | 26926V107 | 41.8 | 33497 | 1400174.6
0.88 | NORTHERN TIER ENERGY LP | 665826103 | 26.18 | 43160 | 1129928.8
0.82 | CRESTWOOD EQUITY PARTNERS | 226344109 | 12.75 | 82552 | 1052538
0.64 | CHENIERE ENERGY PARTNERS | 16411Q101 | 33.1 | 24846 | 822402.6
0.62 | NATURAL RESOURCE PART. LP | 63900P103 | 15.88 | 50492 | 801812.96
0.27 | CASH | CASH | 1 | 343746.38 | 343746.38
Spreadsheet: 63abca64-469c-46bb-baf7-e1b6f6498c2c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Name of Business Unit personnel who prepared this claim. | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  | Name: |  |  | Telephone number:
Name of Business Unit |  |  |  |  |  |  | Business Unit Number
ENCOMPASS Voucher Number |  |  |  |  | Invoice Number |  | Invoice Date (month, day, year) |  | Invoice Amount
Name of Vendor |  |  |  |  |  |  | Address (number and street)
ENCOMPASS Vendor Number |  |  |  |  |  |  | Address (city, state, and ZIP code)
AREA BELOW TO BE COMPLETED BY BUSINESS UNIT.
Date |  | Line # |  | Amount | Fund | Department | Project | Handling Code | Line Description
 |  |  |  | [NAME] | Account | Program | Activity
GROSS AMOUNT $ |  |  |  |  | 0 |  | Furnished to:  (name of business unit)
I certify that this claim is correct and valid and is a proper charge against the chartfields indicated.
Authorized Signature of Business Unit |  |  |  |  |  |  | Date (month, day, year)
Pursuant to the provisions and penalties of Indiana Code 5-11-10-1, I hereby certify that the foregoing Fund and Account is just and correct, that the amount claimed is legally due, after allowing all just credits, and that no part of the same has been paid.
Signature of Vendor |  |  |  |  |  |  | Date (month, day, year)
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -42385 | -39000 |  |  |  |  |  |  |  | San Juan
2 | -42398 | -40000 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -42443 | -40000 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 | -41996 | -40000 |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 | -42071 | -40000 |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 | -42173 | -42972 |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 | -48371 | -50000 |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 | -80802 | -70000 |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 | -82459 | -80300 |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10 | -78069 | -80300
11 | -83884 | -80300
12 | -84205 | -80299
13 | -80842 | -80300
14 | -82060 | -85300 |  |  |  | 9/1 - 9/25
15 | -84337 | -80300
16 | -84089 | -85300
17 | -83899 | -85300
18 | -83874 | -85300
19 | -84508 | -85300 |  |  |  | Accumulated @ 9/25/01
20 | -84869 | -85300
21 | -83828 | -84261 |  |  |  | Equilalent volumes at 9/25/01
22 | -84074 | -86272
23 | -83123 | -84052
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | -2220
2002-02-23 00:00:00
CBS Volume
 |  |  | 86032
Spreadsheet: 65251d1265930410-import-content-from-separate-excel-files-to-a-single-spreadsheet-toimport
Sheet: Sheet1

 | ToImport | ToImport | ToImport | ToImport | ToImport | ToImport | ToImport | ToImport | ToImport | ToImport | ToImport | ToImport | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport |  |  |  |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  |  |  |  | ToImport
 |  | ToImport |  |  | ToImport
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ToImport
 |  |  |  |  |  |  |  |  |  |  |  |  | ToImport
 |  |  | ToImport |  |  |  |  |  |  |  | ToImport
Spreadsheet: 2b753917-303b-4c4a-a159-c9170e91c9af
Sheet: Sheet1

Ⅰ　概要 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
３．平成21年主要品目別生産動向
(13)  わさび(生産量）
[NAME] | 水わさび　トン |  | 畑わさび　トン |  | 合　　計　　トン
 | 根  茎 | [NAME] | 根  茎 | [NAME] | 根  茎 | [NAME]
01北海道 | 2 | 0 | 0 | 0 | 2 | 0
02青森 | 0.2 | 1.2 | 0 | 31.3 | 0.2 | 32.5
03岩手 | 8.8 | 1.5 | 2.4 | 620.5 | 11.2 | 622
04宮城 | 9 | 4.2 | 0.3 | 1 | 9.3 | 5.2
05秋田 | 0 | 0 | 0 | 0 | 0 | 0
06山形 | 0.5 | 0.3 | 0 | 0.2 | 0.5 | 0.5
07福島 | 0 | 0 | 1.5 | 15 | 1.5 | 15
08茨城 | 0.2 | 0.1 | 0 | 0.3 | 0.2 | 0.4
09栃木 | 10.8 | 14.3 | 0.1 | 6.6 | 10.9 | 20.9
10群馬 | 0.2 | 0.2 | 0 | 0 | 0.2 | 0.2
11埼玉 | 0 | 0 | 0 | 0.2 | 0 | 0.2
12千葉 | 0 | 0 | 0 | 0 | 0 | 0
13東京 | 24.8 | 0 | 0 | 0 | 24.8 | 0
14神奈川 | 0 | 0 | 0 | 0 | 0 | 0
15新潟 | 0.2 | 0.3 | 0 | 0 | 0.2 | 0.3
16富山 | 0.2 | 0.1 | 0 | 0 | 0.2 | 0.1
17石川 | 0.5 | 0.9 | 0 | 0.4 | 0.5 | 1.3
18福井 | 0.5 | 0 | 0 | 0 | 0.5 | 0
19山梨 | 7 | 12.1 | 0.3 | 0.7 | 7.3 | 12.8
20長野 | 316.8 | 739.2 | 7.2 | 16.8 | 324 | 756
21岐阜 | 1.1 | 0.6 | 0 | 0 | 1.1 | 0.6
22静岡 | 295.1 | 638.2 | 4.5 | 232.3 | 299.6 | 870.5
23愛知 | 0 | 0 | 0.6 | 6.2 | 0.6 | 6.2
24三重 | 0.3 | 0.5 | 1.8 | 0.2 | 2.1 | 0.7
25滋賀 | 0 | 0 | 0 | 0 | 0 | 0
26京都 | 0.1 | 0.4 | 0 | 0 | 0.1 | 0.4
27大阪 | 0 | 0 | 0 | 0 | 0 | 0
28兵庫 | 1.5 | 2.2 | 0 | 4.6 | 1.5 | 6.8
29奈良 | 1.2 | 0.2 | 0.1 | 0.1 | 1.3 | 0.3
30和歌山 | 0.2 | 0 | 0.5 | 0.5 | 0.7 | 0.5
31鳥取 | 3.2 | 4.8 | 29.6 | 2.8 | 32.8 | 7.6
32島根 | 2.4 | 10.1 | 9 | 113 | 11.4 | 123.1
33岡山 | 0.4 | 0.7 | 3.9 | 7.8 | 4.3 | 8.5
34広島 | 1.6 | 4.4 | 0.3 | 1.7 | 1.9 | 6.100000000000001
35山口 | 2.5 | 2.2 | 22.5 | 54.2 | 25 | 56.40000000000001
36徳島 | 0 | 0 | 0 | 1.6 | 0 | 1.6
37香川 | 0 | 0 | 0 | 0 | 0 | 0
38愛媛 | 0 | 0 | 0 | 3.3 | 0 | 3.3
39高知 | 0.1 | 0.6 | 6 | 3.3 | 6.1 | 3.9
40福岡 | 0 | 0 | 10.3 | 1.5 | 10.3 | 1.5
41佐賀 | 0 | 0 | 0 | 18 | 0 | 18
42長崎 | 0 | 0 | 0 | 0 | 0 | 0
43熊本 | 0 | 0 | 0 | 0.2 | 0 | 0.2
44大分 | 0.5 | 8.9 | 0 | 94 | 0.5 | 102.9
45宮崎 | 0 | 0 | 6.4 | 0.5 | 6.4 | 0.5
46鹿児島 | 0 | 0 | 0 | 0 | 0 | 0
47沖縄 | 0 | 0 | 0 | 0 | 0 | 0
合計 | 691.9000000000002 | 1448.200000000001 | 107.3 | 1238.8 | 799.2000000000002 | 2687
Spreadsheet: 737999d1624734477-change-specific-column-letter-inside-formula-for-drag-down-keto-food-calculator-copy
Sheet: Month Juli

Datum | Nahrungsmittel | Menge (g) | Datum | Nahrungsmittel | Menge (g) | Datum | Nahrungsmittel | Menge (g) | Datum | Nahrungsmittel | Menge (g) | Datum | Nahrungsmittel | Menge (g) | Datum | Nahrungsmittel | Menge (g) | Datum | Nahrungsmittel | Menge (g) | Datum | Nahrungsmittel | Menge (g) | Datum | Nahrungsmittel | Menge (g) | Datum | Nahrungsmittel | Menge (g)
2021-07-01 00:00:00 | Agavensirup | 200 | 2021-07-02 00:00:00 | Agavensirup | 200 | 2021-07-03 00:00:00 | Agavensirup | 200 | 2021-07-04 00:00:00 | Agavensirup | 100 | 2021-07-05 00:00:00 | Agavensirup | 50 | 2021-07-06 00:00:00 | Agavensirup | 200 | 2021-07-07 00:00:00 | Agavensirup | 200 | 2021-07-08 00:00:00 | Agavensirup | 200 | 2021-07-09 00:00:00 | Agavensirup | 20 | 2021-07-10 00:00:00 | Agavensirup | 10
 | Ahornsirup | 150 |  | Ahornsirup | 1200 |  | Ahornsirup | 150 |  | Ahornsirup | 150 |  | Ahornsirup | 150 |  | Ahornsirup | 150 |  | Ahornsirup | 150 |  | Ahornsirup | 150 |  | Ahornsirup | 150 |  | Ahornsirup | 150
 | Amaranth, Samen, roh | 400 |  | Amaranth, Samen, roh | 400 |  | Amaranth, Samen, roh | 200 |  | Amaranth, Samen, roh | 400 |  | Amaranth, Samen, roh | 400 |  | Amaranth, Samen, roh | 50 |  | Amaranth, Samen, roh | 350 |  | Amaranth, Samen, roh | 400 |  | Amaranth, Samen, roh | 400 |  | Amaranth, Samen, roh | 400
Spreadsheet: 203391d1357093551-j-and-r-database-userform-error-in-find-delete-function-of-multiple-record-vb-code-fix-add-and-editdatabaseform
Sheet: Sheet1

Name | Company | Std/Area Code | Telephone | Approved
[NAME] | Test | 234 | 12345 | Yes
[NAME] | J & R Excel Solutions | 1507 | 413579 | No
[NAME] | Change | 15901 | 99990 | Yes
[NAME] | AJP | 1909 | 1952 | No
Richie | ABC Co | 7863 | 56789 | Yes
[NAME] | Excel-it | 19045 | 1952 | Yes
[NAME] | ABC | 1905 | 1976 | Yes
[NAME] | Acme, Inc | 444 | 44 444 | No
mary | Company ltd | 7777 | 888888 | Yes
WESSON | CARS | 111 | 1111 | Yes
Spreadsheet: john_griffith__15655__Book4
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.2 | 0.34 | 0.38 | 0.5143999999999991 | 0.008399999999999075
 | N | 4.25 | 0.62 | 0.67 | 0.5276999999999994 | 0.005099999999999438
 | Q | 4.35 | 0.82 | 0.87 | 0.5338 | 0
 | U | 4.35 | 0.98 | 1.03 | 0.5344000000000007 | -0.005699999999999372
 | V | 4.4 | 1.12 | 1.18 | 0.5436000000000013 | -0.01229999999999865
 | X | 4.55 | 1.32 | 1.38 | 0.5600999999999998 | 0.001499999999999835
 | Z | 4.75 | 1.52 | 1.57 | 0.5689000000000003 | -0.002399999999999736
 | F | 4.8 | 1.65 | 1.7 | 0.5708000000000006 | -0.005699999999999372
 | G | 4.7 | 1.7 | 1.75 | 0.5684000000000002 | -0.002399999999999736
 | H | 4.5 | 1.56 | 1.63 | 0.5203999999999995 | 0.004199999999999537
 | J | 4.2 | 1.15 | 1.25 | 0.4001000000000005 | -0.004499999999999504
 | K | 4.15 | 1.1 | 1.2 | 0.3775999999999999 | 0.0005999999999999339
 |  |  | 2001-05-10 09:28:53.220000
Spreadsheet: 884177d1733242785-formula-to-pick-up-the-country-with-the-highest-score-exercise
Sheet: Sheet1

 | Number of UBOs | UBO Citizenship 1 | UBO Citizenship 2 | UBO Citizenship 3 | Citizenship  Weight 1 | Citizenship  Weight 2 | Citizenship  Weight 3
 | UBO 1 | [NAME] | Angola | Greece | 0.25 | Restricted | 0.5
 | UBO 2 | Luxembourg | Czech Republic | [NAME] | 0.25 | 0.25 | 0.25
 | UBO 3 | [NAME] | Iran, Islamic Republic of | Denmark | 0.25 | Prohibited | 0.25
 | UBO 4 | Kuwait | Denmark | Gambia | 0.75 | 0.25 | 0.5
 | UBO 5 | Kyrgyzstan | Dominica | Georgia | 0.5 | 0.5 | 0.5
 | Highest score country
 | list of country and relarted score
 | [NAME] | 0.25
 | Luxembourg | 0.25
 | [NAME] | 0.25
 | Kuwait | 0.75
 | Kyrgyzstan | 0.5
 | Angola | Restricted
 | Czech Republic | 0.25
 | Iran, Islamic Republic of | Prohibited
 | Denmark | 0.25
 | Dominica | 0.5
 | Greece | 0.5
 | [NAME] | 0.25
 | Denmark | 0.25
 | Gambia | 0.5
 | Georgia | 0.5
Spreadsheet: 758095d1638640885-sum-from-multiple-sheets-with-final-sheet-choice-from-drop-down-menu-sum
Sheet: SUM

 |  |  |  |  |  | Feb | 1 | [NAME]
 | B | C | D |  |  |  | 2 | Feb
Michel |  |  |  |  |  |  | 3 | Mar
[NAME] |  |  |  |  |  |  | 4 | Apr
Johnn |  |  |  |  |  |  | 5 | Mag
 |  |  |  |  |  |  | 6 | Giu
 |  |  |  |  |  |  | 7 | [NAME]
 |  |  |  |  |  |  | 8 | Ago
 |  |  |  |  |  |  | 9 | Set
 |  |  |  |  |  |  | 10 | Ott
 |  |  |  |  |  |  | 11 | Nov
 |  |  |  |  |  |  | 12 | Dic
Spreadsheet: 5dd24772-9bec-4940-b477-df681653ec6f
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
RBP24 | Test | RBP24 | Retinol-Binding Protein, 24 Hour, [NAME] | Retinol-Binding Protein, 24-Hour, U | Immunonephelometry | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. Mix well before taking 5-mL aliquot. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.    Urine Preservative Collection Options Ambient	Preferred Refrigerated	Yes Frozen	Yes 6N HCI	No 50% Acetic Acid	No Na2CO3	No Toluene	Yes 6N HNO3	No Boric Acid	Yes Thymol	Yes | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | <163 mcg/24 hours | Varies; 8 a.m. to 4 p.m. | 7 days | 8 days | 1 | 83883 |  |  |  |  | Rochester
RBP24 | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
RBP24 | Order Question | DUR6 | Collection Duration |  | Plain Text
RBP24 | Order Question | VL59 | [NAME] |  | Plain Text
RBP24 | Result | RBP1 | Retinol-Binding Protein, 24-Hour, U | Retinol-Binding Protein, 24-Hour, U | Numeric |  |  |  |  | mcg/24 h |  |  |  |  |  |  |  |  |  | 18362-4 | [NAME] binding protein:MRat:24H:[NAME]:Qn:
RBP24 | Result | RBPC1 | RBP/Creat Ratio | RBP/Creat Ratio | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | In Process
RBP24 | Result | DUR6 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
RBP24 | Result | VL59 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
RBP24 | Result | RBPCN | Retinol-Binding Protein Conc | Retinol-Binding Protein Conc | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
RBP24 | Result | CRCN | Creatinine Concentration | Creatinine Concentration | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 20624-3 | Creatinine:MCnc:24H:[NAME]:Qn:
Spreadsheet: 882563d1730958126-return-multiple-numbers-for-one-name-lookup-test
Sheet: Pivot

Name | Phone Number
Abshire, Clare Tanya | (616) 341-8770
[NAME], [NAME] | (872) 332-1420
Badalandabad, Taj Mahal | (518) 461-1188
Bagg, [NAME] | (805) 599-1264
Bailey, [NAME] | (570) 488-7093
 | (785) 797-4905
Barlow, [NAME] | (650) 508-7083
Beardly, [NAME] | (909) 449-2120
Benson, [NAME] | (724) 362-1730
Bognar, Staci E | (323) 686-8181
 | (419) 604-2340
Borton, Wendel M | (228) 633-7828
 | (713) 732-6446
 | (850) 232-1311
Branch, Arthur M | (814) 288-7264
[NAME], [NAME] | (916) 885-1247
Brockman, [NAME] | (360) 847-9735
[NAME], [NAME] | (941) 564-8319
Grand Total
Spreadsheet: 53361d1253240726-calendar-and-buttons-3m-brookings
Sheet: Toluol

Toluol
399 Lbs./Drum
[NAME]
Lot # | CB24705
PO | USMMMFP900
Rel. | 14 | 2009-06-01 00:00:00
Toluol
399 Lbs./Drum
[NAME]
Lot # | CB24705
PO | USMMMFP900
Rel. | 14 | 2009-06-01 00:00:00
Spreadsheet: 437887d1451558899-countifs-with-multiple-criteria-countifs
Sheet: SAMPLE DATA

DATA |  |  | REQUIRED COLUMN
NAME | [NAME] | SERIAL NUMBER | COUNTIFS
LONDON | 251 | 19 | 1
LONDON | 252 | 19 | 1
LONDON | 272 | 19 | 1
LONDON | 273 | 19 | 1
LONDON | 274 | 19 | 1
LONDON | 084 | 19 | 1
LONDON | 766 | 33 | 2
LONDON | 764 | 33 | 2
JAPAN | 761 | 32 | 3
JAPAN | 754 | 32 | 3
US | 762 | 23 | 4
US | 777 | 23 | 4
US | 759 | 23 | 4
AUSTRALIA | 085 | 44 | 1
AUSTRALIA | 089 | 44 | 1
AUSTRALIA | 088 | 43 | 2
AUSTRALIA | 090 | 43 | 2
AUSTRALIA | 086 | 49 | 3
AUSTRALIA | 087 | 49 | 3
NETHERLANDS | 754 | 47 | 4
NETHERLANDS | 747 | 47 | 4
SWITZERLAND | 205 | 50 | 5
SWITZERLAND | 208 | 50 | 5
SWITZERLAND | 210 | 50 | 5
SWITZERLAND | 212 | 50 | 5
SWITZERLAND | 214 | 50 | 5