tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 37d5e855-0f61-48b5-91e3-7119fd208442
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | US Defensive Fund
 | Monthly Performance History
 | Inception Date | 2012-07-09 00:00:00
 |  | Class I | Class N | Russell 1000
 | Date | AUEIX | AUENX | Index
* | 2012-07-31 00:00:00 | 0.008000000000000007 | 0.008000000000000007 | 0.01762653187170171
 | 2012-08-31 00:00:00 | 0.005952380952380931 | 0.004960317460317443 | 0.02428149135217317
 | 2012-09-30 00:00:00 | 0.0177514792899407 | 0.01776900296150052 | 0.02572240785636382
 | 2012-10-31 00:00:00 | -0.01453488372093026 | -0.01454898157129003 | -0.01688263308870652
 | 2012-11-30 00:00:00 | 0.008849557522123908 | 0.009842519685039353 | 0.007944537508500105
 | 2012-12-31 00:00:00 | -0.002501283252926423 | -0.004026875333574154 | 0.01037066665316533
 | 2013-01-31 00:00:00 | 0.0531496062992125 | 0.05309734513274345 | 0.05423379650857152
 | 2013-02-28 00:00:00 | 0.02429906542056104 | 0.0242763772175536 | 0.0134352092795873
 | 2013-03-31 00:00:00 | 0.04197080291970789 | 0.0419325432999087 | 0.03860552126564576
 | 2013-04-30 00:00:00 | 0.02014010507880926 | 0.02012248468941391 | 0.01805859441151569
 | 2013-05-31 00:00:00 | 0.004291845 | 0.003430532 | 0.02224397
 | 2013-06-30 00:00:00 | -0.001709401709401592 | -0.0008547008547008517 | -0.01362827968381131
 | 2013-07-31 00:00:00 | 0.04880136986301364 | 0.04875962360992303 | 0.05350791407164568
 | 2013-08-31 00:00:00 | -0.03428571428571414 | -0.03507340946166393 | -0.02758241840840636
 | 2013-09-30 00:00:00 | 0.0312764159 | 0.0304311074 | 0.03486933
 | 2013-10-31 00:00:00 | 0.0450819672 | 0.04511895 | 0.044019845
 | 2013-11-30 00:00:00 | 0.0235294117647058 | 0.02354788069073765 | 0.02805706685098341
 | 2013-12-31 00:00:00 | 0.014287108 | 0.014757763 | 0.026977807
 | 2014-01-31 00:00:00 | -0.02593440122044244 | -0.02667682926829262 | -0.0319385965192972
 | 2014-02-28 00:00:00 | 0.04620203602193 | 0.04620203602193 | 0.04746582917621
 | * partial month return, inception date 7/9/2012
 | US Defensive Fund
 | [NAME]
 | Month-end Returns as of | Class I | Class N | Russell 1000
 | February 28, 2014 | AUEIX | AUENX | Index
 | 1 Year | 0.230735220633546 | 0.2283042922516587 | 0.2633523664632023
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.3587550832807385 | 0.3539001129831418 | 0.4448333054203719
 | Since Inception Annualized Return | 0.2053951360251993 | 0.2027688357985022 | 0.2513672047123907
 | Since Inception Annualized Monthly Volatility | 0.08521552653806798 | 0.08582736186788933 | 0.08735020779303657
 | Quarter-end Returns as of | Class I | Class N | Russell 1000
 | December 31, 2013 | AUEIX | AUENX | Index
 | 1 Year | 0.3027998772474458 | 0.3011249984421167 | 0.3311121603622893
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.3333292770816185 | 0.3295785540672724 | 0.424869117048452
 | Since Inception Annualized Return | 0.21464240293084 | 0.212331810846986 | 0.2704000184618067
Spreadsheet: 810545d1671845116-need-a-formula-to-lookup-balance-of-certain-account-for-1st-day-of-every-month-book5
Sheet: Sheet1

Date | Account # | Institution | Balance | Balance2
2022-12-05 20:05:43 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
2022-12-05 07:09:22 | xxxx8214 | Discover Card | 3924.28 | CREDIT
2022-12-05 03:16:35 | xxxx6977 | Citibank | 2113.08 | CREDIT
2022-12-04 23:09:02 | xxxx5009 | American Express Cards | 1048.25 | CREDIT |  | December 1st
2022-12-04 18:35:31 | xxxx4887 | Capital One | 1218.87 | CREDIT |  | xxxx0570 | =INDEX(Table1[Balance],MATCH(1,(G6=Table1[Account '#]),0),1)
2022-12-04 18:35:31 | xxxx3838 | Capital One | 1297.72 | CREDIT |  | xxxx3838
2022-12-04 18:14:37 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT |  | xxxx4887
2022-12-04 04:13:33 | xxxx8214 | Discover Card | 3850.9 | CREDIT |  | xxxx9243
2022-12-04 00:00:27 | xxxx0570 | Chase | 2118.55 | CREDIT |  | xxxx6977
2022-12-03 23:11:33 | xxxx6977 | Citibank | 2113.08 | CREDIT
2022-12-03 22:28:28 | xxxx5009 | American Express Cards | 1048.25 | CREDIT
2022-12-03 18:23:14 | xxxx4887 | Capital One | 1257.87 | CREDIT
2022-12-03 18:23:14 | xxxx3838 | Capital One | 1338.72 | CREDIT
2022-12-03 04:30:03 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
2022-12-03 03:48:24 | xxxx0570 | Chase | 2118.55 | CREDIT
2022-12-03 00:32:55 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-12-02 22:09:56 | xxxx5009 | American Express Cards | 1048.25 | CREDIT
2022-12-02 18:14:39 | xxxx4887 | Capital One | 1257.87 | CREDIT
2022-12-02 18:14:39 | xxxx3838 | Capital One | 1338.72 | CREDIT
2022-12-02 09:27:18 | xxxx6977 | Citibank | 2113.08 | CREDIT
2022-12-02 06:59:24 | xxxx5009 | American Express Cards | 1018.59 | CREDIT
2022-12-02 05:40:37 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-12-02 05:06:50 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
2022-12-01 12:09:15 | xxxx6977 | Citibank | 2113.08 | CREDIT
2022-12-01 10:48:06 | xxxx0570 | Chase | 2231.55 | CREDIT
2022-12-01 09:44:43 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-12-01 04:39:48 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
2022-12-01 02:17:33 | xxxx5009 | American Express Cards | 1018.59 | CREDIT
2022-12-01 02:15:13 | xxxx4887 | Capital One | 1257.87 | CREDIT
2022-12-01 02:15:13 | xxxx3838 | Capital One | 1338.72 | CREDIT
2022-11-30 09:45:37 | xxxx6977 | Citibank | 2154.08 | CREDIT
2022-11-30 07:24:10 | xxxx0570 | Chase | 2231.55 | CREDIT
2022-11-30 03:32:15 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-11-30 02:50:44 | xxxx5009 | American Express Cards | 1018.59 | CREDIT
2022-11-30 02:36:20 | xxxx9243 | Wells Fargo | 1540.54 | CREDIT
2022-11-30 00:04:18 | xxxx4887 | Capital One | 1257.87 | CREDIT
2022-11-30 00:04:18 | xxxx3838 | Capital One | 1338.72 | CREDIT
2022-11-29 07:17:07 | xxxx4887 | Capital One | 1257.87 | CREDIT
2022-11-29 07:17:07 | xxxx3838 | Capital One | 1338.72 | CREDIT
2022-11-29 06:35:01 | xxxx8214 | Discover Card | 3850.9 | CREDIT
2022-11-29 04:57:44 | xxxx6977 | Citibank | 2154.08 | CREDIT
2022-11-28 22:43:51 | xxxx0570 | Chase | 2231.55 | CREDIT
Spreadsheet: 838926d1691520659-averageifs-with-isformula-averageifs-help
Sheet: Solution 2

time/date | a(%) | b(%) | c(%) | [NAME])
2020-01-23 12:15:07 | 95.8077 | 2.7815 | 1.410800000000003
2020-01-24 12:15:00 | 95.4539 | 2.557 | 1.989099999999996
2020-01-29 10:30:00 | 96.1821 | 2.4956 | 1.322299999999994 | 0.63
2020-02-05 10:05:00 | 96.1561 | 2.6413 | 1.202600000000005 | 0.37
2020-02-12 11:30:00 | 94.4905 | 3.9694 | 1.540100000000003
2020-02-19 10:00:48 | 96.5018 | 2.161 | 1.337199999999997 | 2.873
2020-02-26 11:40:00 | 96.8241 | 1.9614 | 1.214499999999999 | 0.07
2020-03-06 15:15:00 | 96.9922 | 1.4135 | 1.594300000000003 | 0.83
2020-03-11 13:05:00 | 95.9704 | 1.9137 | 2.115900000000002 | 1.05
2020-03-18 10:10:49 | 96.472 | 1.9753 | 1.552700000000006
2020-03-25 08:55:00 | 93.5054 | 4.8329 | 1.661700000000005 | 0.66
2020-05-10 22:35:00 | 33.47 | 0.5 | 66.03 | 0.62
2020-05-13 12:30:37 | 0 | 0 | 100 | 0
2020-06-02 12:30:00 | 97.2685 | 1.343
Spreadsheet: 872667d1719036422-getting-data-from-one-workbook-to-another-ghm-team-aligw
Sheet: Girls

 |  |  |  |  |  |  |  |  |  |  | AliGW
 | Name | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2012 |  |  |  |  |  |  |  |  |  |  |  | 16.66
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 17.32
 |  |  |  |  |  |  |  |  |  |  | Ella Spink | 18.4
12 Years |  |  |  |  |  |  |  |  |  |  | Matilda Dawson | 18.54
 |  | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2013
11 Years
 |  | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2014
10 Years
2015 |  | 100 | 200 | Long
9 Years
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 12a

Product1 | Cleared2 | Uncleared | TOTAL
Cross_Currency Basis | 0 | 47358
Cross_Currency Fixed-Fixed | 0 | 19621
Cross_Currency Fixed-Float | 0 | 13830
TOTAL | 0
Spreadsheet: 840526d1692799127-need-function-to-determine-parent-or-child-in-a-hierarchy-plan
Sheet: Planilha1

COLUMN1 | COLUMN2 | COLUMN3 | COLUMN4 | FUNCTION
ITEM 1
 | ITEM 1.1
 |  | ITEM 1.1.1
 | ITEM 1.2
 |  | ITEM 1.2.1
ITEM 2
 | ITEM 2.1
ITEM 3
 | ITEM 3.1
 |  | ITEM 3.1.1
 |  |  | ITEM 3.1.1.1
ITEM 4
 | ITEM 4.1
Spreadsheet: 150423d1334521599-auto-populating-a-calendar-based-on-two-variables-training-plan
Sheet: LRTP

 | 2012 |  | DEPT / DIV: |  |  | WEAPONS/CG
 | Long Range Training Plan |  | SUBMITTED BY: |  |  | FC2 (SW) XXXX
 |  |  | REVIEWED BY: |  |  | GUNNERY OFFICER
 |  |  | APPROVED BY: |  |  | WEAPONS OFFICER
 | Topic Name
 |  | Topic Number | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 | [NAME] AND USES | CS-CG-05 | X |  |  | X |  |  | X |  |  | X
 | MAGAZINE SPRINKLER SYSTEMS | CS-CG-15 | X |  |  | X |  |  | X |  |  | X
 | SMALL ARMS SAFETY | CS-CG-24 | X |  |  | X |  |  | X |  |  | X
 | DUTY GUNNERS MATE | CS-CG-29 | X
 | SMALL BOAT ATTACKS | FP-40 |  | X |  |  |  |  |  | X
 | LOW [NAME] | FP-37 |  | X |  |  |  |  |  | X
 | VEHICLE INSPECTION | FP-34 |  | X |  |  |  |  |  | X
 | FRATERNIZATION | NR&R6 |  |  | X
 | SEXUAL HARASSMENT | NR&R7 |  |  | X
 | GRIEVANCE PROCEDURES | [NAME] |  |  |  |  | X
 | AMMUNITION HANDLING (HOIST) | CS-CG-04 |  |  |  |  | X
 | 5" HANDLING PROCEDURES | CS-CG-07 |  |  |  |  |  | X
 | MISFIRE PROCEDURES | CS-CG-11 |  |  |  |  |  | X
 | NSFS | CS-CG-21 |  |  |  |  |  | X |  |  |  |  | X
 | AMMO ADMIN | CS-CG-23 |  |  |  |  |  |  | X
 | ALCOHOL AWARENESS | NAVS 14 |  |  |  |  |  |  |  | X |  |  | X
 | BACK HEALTH | SS3 |  |  |  |  |  |  |  |  | X
Spreadsheet: 157776d1337870334-need-to-pull-800-rows-of-data-from-a-spread-sheet-at-one-time-look-up-one-cell
Sheet: Data

1234 | PO Number | Lines | Sage Order Date | Part Number | Description | Qty Ordered | Qty Out | Web Date | Web Confirmation | Pi Received Date | Pi Number | Etd | Date Dispatached | Invoice Number | Eta
6993Z014780-H | 6993 | 4 | 40913 | Z014780-H | PULLEY | 50 | 22 |  |  |  |  |  | 2012-03-10 00:00:00 | 9000952840 | 2012-04-24 00:00:00
6994Z014780-H | 6994 | 91 | 40913 | Z014780-H | PULLEY | 5 | 5 |  |  |  |  |  | 2012-03-07 00:00:00 | 9000952830 | 2012-04-21 00:00:00
7548Z014780-H | 7548 | 3 | 40991 | Z014780-H | PULLEY | 5 | 5 |  |  |  |  |  | #N/A |  | #N/A
Spreadsheet: 77084d1277510779-formula-to-sum-options-from-drop-down-selections-sumifexample
Sheet: Sheet1

A | B |  |  |  | shirt | 49
shirt | 7 |  |  |  | shoes | 23
shoes | 4 |  |  |  | pants | 10
shoes | 19
pants | 10
shirt | 12
shirt | 30
Spreadsheet: 153202d1335801887-hours-worked-after-certain-time-kaps_mr2_excel-forum_30apr12_01
Sheet: Sheet1

Start time | End Time | Expected result (no of hours worked after 8.00 p.m) |  |  |  | Formulaic Result
2012-04-23 23:00:00 | 2012-04-24 05:00:00 | 06:00:00
2012-04-23 15:00:00 | 2012-04-23 21:00:00 | 01:00:00
2012-04-23 04:00:00 | 2012-04-24 03:00:00 | 07:00:00
2012-04-23 14:00:00 | 2012-04-23 19:00:00 | 00:00:00
2012-04-23 01:00:00 | 2012-04-23 09:00:00 | 08:00:00
Spreadsheet: 147265d1332670390-day-to-date-conversion-lookup-days-ahead
Sheet: Sheet1

 | Next Day Reqd | is days away | Date | Check |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
2012-03-25 00:00:00 | Sun | 7 | 2012-04-01 00:00:00 | Sun |  | Mon | 7 | 1 | 2 | 3 | 4 | 5 | 6
2012-03-26 00:00:00 | Fri | 4 | 2012-03-30 00:00:00 | Fri |  | Tue | 6 | 7 | 1 | 2 | 3 | 4 | 5
2012-03-27 00:00:00 | Sat | 4 | 2012-03-31 00:00:00 | Sat |  | Wed | 5 | 6 | 7 | 1 | 2 | 3 | 4
2012-03-28 00:00:00 | Sat | 3 | 2012-03-31 00:00:00 | Sat |  | Thu | 4 | 5 | 6 | 7 | 1 | 2 | 3
2012-03-29 00:00:00 | Sat | 2 | 2012-03-31 00:00:00 | Sat |  | Fri | 3 | 4 | 5 | 6 | 7 | 1 | 2
2012-03-30 00:00:00 | Wed | 5 | 2012-04-04 00:00:00 | Wed |  | Sat | 2 | 3 | 4 | 5 | 6 | 7 | 1
2012-03-31 00:00:00 | Thu | 5 | 2012-04-05 00:00:00 | Thu |  | Sun | 1 | 2 | 3 | 4 | 5 | 6 | 7
2012-04-01 00:00:00 | Fri | 5 | 2012-04-06 00:00:00 | Fri
2012-04-02 00:00:00 | Sat | 5 | 2012-04-07 00:00:00 | Sat
2012-04-03 00:00:00 | Sun | 5 | 2012-04-08 00:00:00 | Sun
Enter your date in Column A, and the next required day in Column B |  |  |  |  | Your thread
 |  |  |  |  | Day to Date conversion
 |  |  |  |  | See here for more help with solutions
Spreadsheet: 80315d1280490155-sumproduct-sumifs-book1
Sheet: Sheet1

Date |  |  |  |  | Value | Name
2010-01-31 00:00:00 |  |  |  |  | 2842.72 | Mr. [NAME]
2010-01-31 00:00:00 |  |  |  |  | 7335.02 | Mr. [NAME]
2010-01-31 00:00:00 |  |  |  |  | 7571.69 | Mr. [NAME]
2010-01-31 00:00:00 |  |  |  |  | 6007.2 | Mr. [NAME]
2010-01-31 00:00:00 |  |  |  |  | 7414.63 | Mr. [NAME]
2010-01-31 00:00:00 |  |  |  |  | 6673.83 | Mr. [NAME]
2010-01-31 00:00:00 |  |  |  |  | 5612.51 | Mr. [NAME]
2010-01-31 00:00:00 |  |  |  |  | 6272.66 | Mr. [NAME]
2010-02-28 00:00:00 |  |  |  |  | 3837.82 | Mr. [NAME]
2010-02-28 00:00:00 |  |  |  |  | 6446.35 | Mr. [NAME]
2010-02-28 00:00:00 |  |  |  |  | 2930.34 | Mr. [NAME]
2010-02-28 00:00:00 |  |  |  |  | 3647.27 | Mr. [NAME]
2010-02-28 00:00:00 |  |  |  |  | 3701.85 | Mr. [NAME]
2010-02-28 00:00:00 |  |  |  |  | 3434.8 | Mr. [NAME]
2010-02-28 00:00:00 |  |  |  |  | 7414.63 | Mr. [NAME]
2010-02-28 00:00:00 |  |  |  |  | 6673.83 | Mr. [NAME]
Spreadsheet: 816045d1675335521-formula-to-get-min-and-max-with-conditions-paviot-cal
Sheet: Sheet2

Row Labels | Sum of Sales Qty | Sum of  Stock Qty
DTOTAL30-050 | 33 | 116
DTOTAL30-075 | 97 | 125
DTOTAL30-100 | 198 | 167
DTOTAL30-1000 | 1 | 23
DTOTAL30-1050 | 6 | 19
DTOTAL30-1100 | 0 | 14
DTOTAL30-1150 | 0 | 12
DTOTAL30-1200 | 2 | 8
DTOTAL30-125 | 275 | 146
DTOTAL30-150 | 310 | 153
DTOTAL30-175 | 273 | 150
DTOTAL30-200 | 334 | 143
DTOTAL30-225 | 215 | 169
DTOTAL30-250 | 322 | 129
DTOTAL30-275 | 276 | 151
DTOTAL30-300 | 234 | 165
DTOTAL30-325 | 158 | 173
DTOTAL30-350 | 227 | 161
DTOTAL30-375 | 180 | 161
DTOTAL30-400 | 120 | 193
DTOTAL30-425 | 140 | 164
DTOTAL30-450 | 118 | 176
DTOTAL30-475 | 69 | 175
DTOTAL30-500 | 102 | 177
DTOTAL30-525 | 49 | 161
DTOTAL30-550 | 99 | 155
DTOTAL30-575 | 31 | 185
DTOTAL30-600 | 55 | 154
DTOTAL30-650 | 77 | 92
DTOTAL30-700 | 38 | 100
DTOTAL30-750 | 26 | 92
DTOTAL30-800 | 16 | 89
DTOTAL30-850 | 12 | 85
DTOTAL30-900 | 9 | 85
DTOTAL30-950 | 13 | 17
DTOTAL90-050 | 15 | 109
DTOTAL90-075 | 44 | 132
DTOTAL90-100 | 108 | 149
DTOTAL90-1000 | 4 | 14
DTOTAL90-1050 | 1 | 13
DTOTAL90-1100 | 3 | 6
DTOTAL90-1150 | 0 | 7
DTOTAL90-1200 | 3 | 6
DTOTAL90-125 | 177 | 134
DTOTAL90-150 | 226 | 123
DTOTAL90-175 | 212 | 135
DTOTAL90-200 | 246 | 135
DTOTAL90-225 | 184 | 137
DTOTAL90-250 | 225 | 141
DTOTAL90-275 | 181 | 124
DTOTAL90-300 | 179 | 150
DTOTAL90-325 | 111 | 152
DTOTAL90-350 | 154 | 136
DTOTAL90-375 | 90 | 162
DTOTAL90-400 | 125 | 142
DTOTAL90-425 | 109 | 155
DTOTAL90-450 | 114 | 135
DTOTAL90-475 | 81 | 147
DTOTAL90-500 | 73 | 157
DTOTAL90-525 | 46 | 154
DTOTAL90-550 | 55 | 142
DTOTAL90-575 | 36 | 155
DTOTAL90-600 | 58 | 135
DTOTAL90-650 | 47 | 102
DTOTAL90-700 | 31 | 90
DTOTAL90-750 | 29 | 80
DTOTAL90-800 | 14 | 86
DTOTAL90-850 | 7 | 70
DTOTAL90-900 | 3 | 98
FLCB-BL | 45 | 225
FLCB-BR | 154 | 170
FLCB-GN | 152 | 199
FLCB-GY | 268 | 141
FLCB-HN | 45 | 211
FLCB-PZ | 265 | 171
FLCB-SRGY | 76 | 187
FLOD-10BL | 252 | 756
FLOD-10GN | 813 | 730
FLOD-10GY | 1763 | 526
FLOD-10PZ | 1964 | 468
Grand Total | 12903 | 11882
Spreadsheet: 708233d1607684765-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: USA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 58276d1258555580-if-and-vlookup-new-20microsoft-20excel-20worksheet-1-
Sheet: Sheet2

Group | Fruit
FRUITS | APPLE |  | FRUITS
FRUITS | MANGO |  | VEGETABLES
FRUITS | BANANA |  | ITEMS
VEGETABLES | CARROT
VEGETABLES | RADISH
VEGETABLES | PUMPKIN
ITEMS | BOOKS
ITEMS | TABLES
ITEMS | CHAIRS
Spreadsheet: 781367d1653286496-count-the-number-of-yes-from-one-list-in-another-list-linked-through-a-code-sample_new
Sheet: Tabelle1

Numer | Code 1 | Code 2 | Code 3 | Hit |  | Code 1 | Code 2 | Code 3 | Should be
1 | 1234 |  |  | Yes |  | 1234 |  |  | 2
 | 2344 |  |  | no |  | 2344 |  |  | empty
 | 12343 | 3456 | 1456 | No |  |  | 3456 | 1456 | 1
 | 1234 |  |  | Yes |  | 1898 |  |  | 1
 | 1898 |  |  | yes
 |  |  | 12345 |  |  |  |  | 12345 | 1
 | 12334 | 23456 |  |  |  | 2345 |  | 644224 | empty
 |  | 34566 |  |  |  |  | 544332 |  | empty
 | Original Source |  |  |  |  | To be mapped in
Spreadsheet: jim_schwieger__14291__BammelOA2001
Sheet: 9810

519 | I | 0 | 0
3082 | I | 0 | 0
3098 | I | 0 | 0
3100 | I | 0 | 0
3102 | I | 0 | 0
5499 | I | 0 | 0
9631 | I | 0 | 0
1355 | O | 0 | 0
3099 | O | 0 | 0
3101 | O | 0 | 0
3103 | O | 0 | 0
3052 | F | 0 | 0
3073 | F | 0 | 0
3074 | F | 0 | 0
3075 | F | 0 | 0
3083 | F | 0 | 0
3084 | F | 0 | 0
3085 | F | 0 | 0
3086 | F | 0 | 0
3087 | F | 0 | 0
3088 | F | 0 | 0
3089 | F | 0 | 0
3090 | F | 0 | 0
3091 | F | 0 | 0
3092 | F | 0 | 0
3093 | F | 0 | 0
3094 | F | 0 | 0
3095 | F | 0 | 0
3096 | F | 0 | 0
3097 | F | 0 | 0
8645 | F | 0 | 0
Spreadsheet: 539460d1506144631-excel-get-all-data-from-another-sheet-ho-status
Sheet: Sheet 1

Date | Tack Pack No | Item | [NAME] | Merchandiser | Season | Cutting Status | [NAME] | Production Status | Finishing Status | [NAME] | Helper Column
17-9-2017 | FZ 284 | Ladies 2 pcs | 280 | Maruf | Eid A 17 |  |  |  |  | 16
 | FZ 282 | Ladies Top | 300 | Maruf | Eid A 17 |  | 309 |  |  | 77
 | SR 308 | Men's Knit Shirt | 200 | Rokon | Eid A 17 | 212 | 212 | 212 | 212 | 210
13-9-2017 | LE 208 | [NAME] | 218 | Arman | Eid A 17 |  | 217 |  | 149
 | LE 209 | [NAME] | 160 | Arman | Eid A 17 |  | 165 | 164 | 164 | 25
16-9-2017 | RB 233 | Men's Shirt | 344 | Rokon | Win-17 |  | 387 | 387 | 387 | 383
19-9-2017 | RT 261 | Ladies Top | 144 | Maruf | Win-17 |  |  |  |  | 107
 | LE 208 | [NAME] | 218 | Arman | Eid A 17 |  | 217 |  | 149
21-9-2017 | SR 309
Spreadsheet: 181419d1348037729-compare-tables-in-excel-discounts
Sheet: Example_result

Phone Number | Discount ID |  |  | Number | Discount
[PHONE] | 53457 |  |  | [PHONE] | 56027
[PHONE] | 56006 |  |  | [PHONE] | 53457
[PHONE] | 56013 |  |  | [PHONE] | 56014
[PHONE] | 56026 |  |  | [PHONE] | 3686
[PHONE] | 8728 |  |  | [PHONE] | 56003
[PHONE] | 8729 |  |  | [PHONE] | 56009
Real Discount |  |  |  | New Discount
 | Result
 | Number | Discount
 | [PHONE] | 56027 | No
 | [PHONE] | 53457 | Yes
 | [PHONE] | 56014 | No
 | [PHONE] | 3686 | No
 | [PHONE] | 56003 | No
 | [PHONE] | 56009 | No
Spreadsheet: andy_zipper__209__eEuropeanWEMR 05-23-01
Sheet: Exec Summary

UK Marketing Report Executive Summary:       Week Ending 23/05/01
 |  |  |  |  |  |  | w/e 23/05 | w/e 16/05 | Company Name
Continental Markets:
Password Applications Initiated |  |  |  |  |  |  | 1 | 3
Execution Ids Issued |  |  |  |  |  |  | 0 | 0
New Customers Trading for the 1st time |  |  |  |  |  |  | 1 | 0 | Austrian Power: Entrade GmbH
UK Markets:
Password Applications Initiated |  |  |  |  |  |  | 2 | 0
Execution Ids Issued |  |  |  |  |  |  | 1 | 0 | Storm Telecommunications Ltd.
New Customers Trading for the 1st time |  |  |  |  |  |  | 1 | 0 | UK Gas: Coryton Energy Company Ltd
Nordic Markets:
Password Applications Initiated |  |  |  |  |  |  | 0 | 0
Execution Ids Issued |  |  |  |  |  |  | 0 | 0
New Customers Trading for the 1st time |  |  |  |  |  |  | 0 | 0
Global Markets:
Password Applications Initiated |  |  |  |  |  |  | 0 | 2
Execution Ids Issued |  |  |  |  |  |  | 0 | 0
New Customers Trading for the 1st time |  |  |  |  |  |  | 0 | 1
Metals (Excludes US customers in total count):
Password Applications Initiated |  |  |  |  |  |  | 0 | 1
Execution Ids Issued |  |  |  |  |  |  | 0 | 0
New Customers Trading for the 1st time |  |  |  |  |  |  | 1 | 0 | KGHM Polish Copper Ltd, Copper LME Registered Contract
Totals:
Guest ID's Issued |  |  |  |  |  |  | 35 | 36
Password Applications Initiated |  |  |  |  |  |  | 3 | 6
Execution Ids Issued |  |  |  |  |  |  | 1 | 0
New Customers Trading for the 1st time |  |  |  |  |  |  | 3 | 1
Spreadsheet: 696605d1600916331-help-with-a-formula-that-will-recognise-identical-unique-identifiers-more-than-once-data-example
Sheet: Bring in data here

Location | Payroll | Name
[NAME] | 1 | [NAME] J
Melb | 3 | [NAME] b
Pert |  | [NAME] b
Dar |  | [NAME] J
[NAME] |  | Adam c
Melb |  | Adam c
Pert |  | Adam 1
Adel |  | Adam 1
Dar |  | Adam 1
[NAME] |  | Ailsa B
Syd |  | Ailsa B
Melb |  | Ailsa B
Syd |  | [NAME] J
Syd |  | Adam c
Pert |  | Ailsa B
[NAME] |  | [NAME]
Adel |  | [NAME] J
Spreadsheet: 13c96532-3c3e-4133-9abc-e1b431e04a02
Sheet: Florida

Florida Pricing Spreadsheet
 | Product Category | Product Description | Unit of Issue | Unit Price
0001A | Watson's Produce
0001A(1)a | Apples | Fresh Empire [NAME] ct | CS | 16.75
0001A(1)b | Apples | Second Proposed Apple Product
0001A(1)c | Apples | Third Proposed Apple Product
0001A(2)a | Carrots | First Proposed Carrot Product
0001A(3)a | Lettuce | First Proposed Lettuce Product
0002A | Todd's Tomatoes
0002A(1)a | Strawberries | First Proposed [NAME]
0002A(2)a | Carrots | First Proposed Carrot Product
0003A | US Food Service
0003A(1)a | Apples | First Proposed Apple Product
0003A(2)a | Blueberries | First Proposed Blueberry Product
0003A(3)a | Grapes | First Proposed Grape Product
0003A(4)a | Oranges | First Proposed Orange Product
0003A(5)a | Strawberries | First Proposed [NAME]
0003A(6)a | Broccoli | First Proposed Broccoli Product
0003A(7)a | Carrots | First Proposed Carrot Product
0003A(8)a | Lettuce | First Proposed Lettuce Product
0004A | Gordon's Food Service
0004A(1)a | Apples | First Proposed Apple Product
0004A(2)a | Oranges | First Proposed Orange Product
0004A(3)a | Lettuce | First Proposed Lettuce Product
Note:  Information has been included for line item 0001A(1)a  for informational purposes only to demonstrate the detail of information required.
Offerors should overwrite or delete the pre-loaded information as appropriate to their proposal, but the numbering convention should be followed.
Offerors may add or delete line items using the indicated numbering format accordint to the items proposed.
Spreadsheet: 72410d1273087051-gantt-timeline-chart-multiple-bars-on-the-row-line-gantt-test
Sheet: Sheet2

Hotel | Time | Start | End
A | 5 | 2009-01-01 00:00:00
B | 7 | 2009-01-02 00:00:00
A | 14 | 2009-01-08 00:00:00
B | 1 | 2009-01-11 00:00:00
C | 3 | 2009-01-05 00:00:00
 | A | B | C | D
2009-01-01 00:00:00
2009-01-02 00:00:00
2009-01-03 00:00:00
2009-01-04 00:00:00
2009-01-05 00:00:00
2009-01-06 00:00:00
2009-01-07 00:00:00
2009-01-08 00:00:00
2009-01-09 00:00:00
2009-01-10 00:00:00
2009-01-11 00:00:00
2009-01-12 00:00:00
2009-01-13 00:00:00
2009-01-14 00:00:00
2009-01-15 00:00:00
2009-01-16 00:00:00
2009-01-17 00:00:00
2009-01-18 00:00:00
2009-01-19 00:00:00
2009-01-20 00:00:00