tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7fe40ac8-4b71-425f-a4ee-8f303ad1435a
Sheet: TEMP

Gene ID | [NAME] | Species ID | miRNA | Site type | UTR_start | UTR_end | 3pairing_contr | local_AU_contr | position_contr | context_score | context_percentile
7422 | VEGFA | 9606 | hsa-miR-410 | 1 | 1152 | 1158 | 0.014 | -0.009 | 0.0183 | -0.076 | 8
7422 | VEGFA | 9606 | hsa-miR-576-5p | 3 | 1185 | 1191 | 0.007 | -0.197 | 0.044 | -0.456 | 96
7422 | VEGFA | 9606 | hsa-miR-452 | 2 | 1196 | 1202 | 0.02 | -0.19 | 0.023 | -0.308 | 85
7422 | VEGFA | 9606 | hsa-miR-548d-3p | 2 | 1222 | 1228 | -0.042 | -0.085 | 0.02 | -0.268 | 83
7422 | VEGFA | 9606 | hsa-miR-200b | 2 | 1232 | 1238 | 0.005 | -0.132 | 0.019 | -0.269 | 78
7422 | VEGFA | 9606 | hsa-miR-429 | 2 | 1232 | 1238 | -0.057 | -0.132 | 0.019 | -0.331 | 89
7422 | VEGFA | 9606 | hsa-miR-200c | 2 | 1232 | 1238 | 0.005 | -0.132 | 0.019 | -0.269 | 78
7422 | VEGFA | 9606 | hsa-miR-203 | 1 | 1254 | 1260 | -0.017 | -0.09 | 0.0109 | -0.195 | 66
7422 | VEGFA | 9606 | hsa-miR-548p | 3 | 1394 | 1400 | 0.005 | -0.097 | 0.008 | -0.394 | 94
7422 | VEGFA | 9606 | hsa-miR-613 | 2 | 1444 | 1450 | 0.005 | 0.008 | 0 | -0.148 | 55
7422 | VEGFA | 9606 | hsa-miR-206 | 2 | 1444 | 1450 | 0.036 | 0.008 | 0 | -0.117 | 41
7422 | VEGFA | 9606 | hsa-miR-1 | 2 | 1444 | 1450 | 0.036 | 0.008 | 0 | -0.117 | 41
7422 | VEGFA | 9606 | hsa-miR-361-5p | 3 | 1552 | 1558 | 0.003 | -0.169 | -0.019 | -0.495 | 98
7422 | VEGFA | 9606 | hsa-miR-578 | 3 | 1600 | 1606 | 0.007 | -0.188 | -0.027 | -0.518 | 99
7422 | VEGFA | 9606 | hsa-miR-185 | 2 | 1634 | 1640 | -0.026 | -0.129 | -0.017 | -0.333 | 94
7422 | VEGFA | 9606 | hsa-miR-29c | 3 | 1676 | 1682 | -0.005 | -0.171 | -0.04 | -0.526 | 99
7422 | VEGFA | 9606 | hsa-miR-29b | 3 | 1676 | 1682 | -0.005 | -0.171 | -0.04 | -0.526 | 99
7422 | VEGFA | 9606 | hsa-miR-29a | 3 | 1676 | 1682 | -0.005 | -0.171 | -0.04 | -0.526 | 99
7422 | VEGFA | 9606 | hsa-miR-556-3p | 1 | 1694 | 1700 | 0.014 | -0.039 | -0.0208 | -0.145 | 38
7422 | VEGFA | 9606 | hsa-miR-944 | 2 | 1696 | 1702 | 0.005 | -0.013 | -0.023 | -0.192 | 47
7422 | VEGFA | 9606 | hsa-miR-889 | 3 | 1713 | 1719 | 0.001 | -0.081 | -0.046 | -0.436 | 96
7422 | VEGFA | 9606 | hsa-miR-569 | 1 | 1716 | 1722 | 0.014 | -0.025 | -0.0224 | -0.132 | 38
7422 | VEGFA | 9606 | hsa-miR-548f | 2 | 1743 | 1749 | 0.005 | -0.001 | -0.027 | -0.184 | 55
7422 | VEGFA | 9606 | hsa-miR-548a-3p | 2 | 1743 | 1749 | 0.005 | -0.001 | -0.027 | -0.184 | 54
7422 | VEGFA | 9606 | hsa-miR-548e | 2 | 1743 | 1749 | -0.026 | -0.001 | -0.027 | -0.215 | 68
7422 | VEGFA | 9606 | hsa-miR-548c-3p | 1 | 1775 | 1781 | -0.028 | -0.084 | -0.0266 | -0.238 | 77
7422 | VEGFA | 9606 | hsa-miR-655 | 3 | 1830 | 1836 | 0.005 | -0.152 | -0.067 | -0.524 | 98
7422 | VEGFA | 9606 | hsa-miR-383 | 2 | 1848 | 1854 | -0.026 | -0.014 | -0.037 | -0.238 | 79
Spreadsheet: b5d77a22-fc8a-44f2-91e3-f78a9f3252ba
Sheet: Sheet1

Legemeldt sykefravær fordelt på næringer | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
3. kvartal, østfold
 | 3. kvartal 2006 | 3. kvartal 2005 | 3. kvartal 2004 | 3. kvartal 2003 | 3. kvartal 2002
Fylket | 0.07 | 0.065 | 0.067 | 0.086 | 0.083
Jordbruk, skogbruk og fiske | 0.047 | 0.05 | 0.051 | 0.054 | 0.067
Olje- og gassutvinning | 0.065 | 0.054 | 0.023 | 0.061 | 0.074
Industri og bergverksdrift | 0.074 | 0.065 | 0.068 | 0.092 | 0.09
Kraft- og vannforsyning | 0.053 | 0.042 | 0.045 | 0.062 | 0.049
Bygge- og annleggsvirksomhet | 0.064 | 0.062 | 0.065 | 0.099 | 0.085
Varehandel, hotell- og restaurantvirksomhet | 0.066 | 0.061 | 0.061 | 0.08 | 0.074
Transport og kommunikasjon | 0.085 | 0.074 | 0.078 | 0.091 | 0.089
Finanstjenester | 0.053 | 0.052 | 0.055 | 0.057 | 0.057
Forretningsmessig tjenesteyting og eiendomsdrift | 0.057 | 0.059 | 0.063 | 0.081 | 0.074
[NAME] administrasjon | 0.063 | 0.056 | 0.055 | 0.064 | 0.066
Undervisning | 0.057 | 0.052 | 0.052 | 0.061 | 0.065
Helse- og sosialtjenester | 0.085 | 0.082 | 0.084 | 0.107 | 0.104
[NAME] sosiale og personlige tjenester | 0.071 | 0.067 | 0.065 | 0.084 | 0.08
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 2

[NAME] گسترش و نوسازی صنایع ایرانیان مانا ( سهامی خاص )
ترازنامه
درتاریخ   31خرداد 1390
[NAME] ها |  |  |  | يادداشت |  | 1390/03/31 |  | 1389/09/30 |  | بدهي هاوحقوق صاحبان سهام |  |  | يادداشت |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  |  | ریال |  | ریال |  |  |  |  |  |  | ریال |  | ریال
دارئيهای جاری: |  |  |  |  |  |  |  |  |  | بدهيهای جاری :
موجودی نقد |  |  |  | 4 |  |  |  |  |  |  | حسابهاواسنادپرداختنی تجاری |  | 13
حسابهای دريافتنی تجاری |  |  |  | 5 |  |  |  |  |  |  | سايرحسابهای پرداختنی |  | 14
سايرحسابهای دريافتنی |  |  |  | 6 |  |  |  |  |  |  | شرکتهای گروه |  | 15
شرکتهای گروه |  |  |  | 7 |  |  |  |  |  |  | پيش دريافتها |  | 16
موجودی مواد وکالاوپيمان درجريان پيشرفت |  |  |  | 8 |  |  |  |  |  |  | [NAME] |  | 17 |  | 0 |  | 0
سفارشات و پیش پرداختها |  |  |  | 9 |  |  |  |  |  |  | [NAME] |  | 18
 |  |  |  |  |  | 0 |  | 0 |  |  | [NAME] دریافتی کوتاه مدت |  | 19 |  | 67311564466 |  | 36249634412
دارائيهای غيرجاری : |  |  |  |  |  |  |  |  |  | بدهيهای بلند مدت :
 |  |  |  |  |  |  |  |  |  |  | [NAME] دریافتی بلند مدت |  | 19 |  | 0 |  | 19751134412
داراييهای ثابت مشهود |  |  |  | 10 |  |  |  |  |  | ذخيره مزايای پايان خدمت کارکنان |  |  | 20
سرمايه گذاريهای بلندمدت |  |  |  | 11
داراييهای نامشهود |  |  |  | 12
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | حقوق صاحبان سهام :
 |  |  |  |  |  |  |  |  |  | سرمايه (63000000سهم1000ريالی با نام تمام پرداخت شده) |  |  | 21 |  | 63000000000
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 22 |  | 6300000000
 |  |  |  |  |  |  |  |  |  | سايراندوخته ها |  |  | 23 |  | 176336710
 |  |  |  |  |  |  |  |  |  | سود انباشته
[NAME] |  |  |  |  |  |  |  |  |  | جمع بدهی هاوحقوق صاحبان سهام
حسابهای انتظامی |  |  |  | 29 |  |  |  | 1202583688216 |  | حسابهای انتظامی |  |  | 29 |  |  |  | 1202583688216
یادداشتهای توضیحی همراه ، جزء لاینفک صورتهای مالی می باشد.
Spreadsheet: 63873d1264730669-automatically-divide-list-into-even-segments-trucks
Sheet: data

count of split on sheet 1 | join split +count for use in index match on sheet 1
1 | 11
2 | 12
3 | 13
4 | 14
5 | 15
6 | 16
7 | 17
8 | 18
9 | 19
10 | 110
11 | 111
12 | 112
1 | 21
2 | 22
3 | 23
4 | 24
5 | 25
6 | 26
7 | 27
8 | 28
9 | 29
10 | 210
11 | 211
12 | 212
13 | 213
1 | 31
2 | 32
3 | 33
4 | 34
5 | 35
6 | 36
7 | 37
8 | 38
9 | 39
10 | 310
11 | 311
12 | 312
13 | 313
Spreadsheet: 766807d1644063535-nested-if-function-help-if_spreadsheet
Sheet: Sheet1

Category | Feb | Mar | Apr | May |  | Category | February | March | April | May
A | 400 | 450 | 900 | 800 |  |  | 0 | 850 | 900 | 800
B | 400 | 450 | 100 | 700 |  |  | 0 | 850 | 0 | 700
C | 900 | 100 | 200 | 400 |  |  | 900 | 0 | 0 | 0
D | 100 | 300 | 300 | 120 |  |  | 0 | 0 | 0 | 820
Spreadsheet: 784976d1656057289-product-qty-bundles-singles-formula-for-row-e
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Apple Juice | 0 | 0 | 0 | 0 pc |  |  | B | P | B | P | B | P | B | P | B | P
Iced Tea | 29 Box/27 | 0 | 3 Boxes | 26 Box/27 |  |  | 29 | 27 |  |  | 3 |  | 26
Bottle | 5 | 0 | 5 | 0 |  |  |  | 5 |  |  |  | 5
Medicine Brand | 5 Box/36 | 0 | 8 | 5Box/28 |  |  | 5 | 26 |  |  |  |  | 5 | 28
Vitamin | 7 Box/3 | 0 | 0 | 7 Box/3 |  |  | 7 | 3 |  |  |  |  | 7 | 3
Wine | 1 | 0 | 0 | 1 |  |  |  | 1 |  |  |  |  |  | 1
Ballpen | 2 Box/97 | 0 | 0 | 2 Box/97 |  |  | 2 | 97 |  |  |  |  | 2 | 97
Pencil | 31 Bot/41 | 0 | 0 | 31Bot/41 |  |  | 31 | 41 |  |  |  |  | 3 | 41
Spreadsheet: 107442d1304608472-counting-sign-changes-book3
Sheet: Sheet1

-1 | 0 | 3 | -2 | 1
1 | 0 | -1 | 1 | 0
0 | 1 | 1 | 1 | 0
Spreadsheet: 47546d1246576057-small-function-iannew
Sheet: Course List

VLOOKUP Column # | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39
Course Name | Slope | Rating | 1 | HC | 2 | hc | 3 | hc | 4 | hc | 5 | hc | 6 | hc | 7 | hc | 8 | hc | 9 | hc | 10 | hc | 11 | hc | 12 | hc | 13 | hc | 14 | hc | 15 | hc | 16 | hc | 17 | hc | 18 | hc
Esmerelda | 112 | 68.1 | 4 | 7 | 3 | 13 | 5 | 17 | 4 | 9 | 4 | 11 | 4 | 5 | 4 | 1 | 3 | 3 | 4 | 15 | 4 | 14 | 4 | 6 | 3 | 10 | 4 | 18 | 4 | 16 | 5 | 12 | 4 | 2 | 3 | 8 | 4 | 4
Meadow Wood | 126 | 70.5 | 4 | 6 | 5 | 8 | 4 | 14 | 4 | 4 | 4 | 12 | 3 | 18 | 5 | 10 | 3 | 16 | 4 | 2 | 4 | 7 | 3 | 9 | 5 | 11 | 4 | 15 | 4 | 13 | 4 | 3 | 5 | 1 | 3 | 17 | 4 | 5
Downriver | 114 | 68 | 5 | 15 | 3 | 11 | 4 | 7 | 4 | 3 | 4 | 1 | 3 | 13 | 5 | 5 | 3 | 9 | 4 | 17 | 4 | 4 | 4 | 6 | 3 | 2 | 5 | 10 | 5 | 12 | 4 | 8 | 3 | 14 | 4 | 18 | 4 | 16
Indian Cannon | 121 | 68.3 | 4 | 9 | 3 | 17 | 5 | 3 | 3 | 15 | 4 | 1 | 4 | 11 | 4 | 7 | 4 | 13 | 5 | 5 | 4 | 6 | 5 | 8 | 4 | 16 | 3 | 18 | 4 | 2 | 4 | 14 | 4 | 12 | 3 | 4 | 4 | 10
[NAME] | 125 | 69.9 | 4 | 7 | 4 | 15 | 4 | 9 | 4 | 5 | 5 | 1 | 4 | 13 | 3 | 11 | 5 | 3 | 3 | 17 | 5 | 4 | 3 | 14 | 4 | 8 | 4 | 6 | 4 | 16 | 4 | 18 | 5 | 2 | 3 | 12 | 4 | 10
Spreadsheet: 290013d1389773885-excel-2010-convert-text-to-value-ramsee-excel-1-
Sheet: Ramsee-Excel (1)

Original file uploaded in | csv format;;;
Date | Description | Amount | Balance;;;
20131001 | ACB DEBIT:EXTERNAL            (     14.50 ) ADT PTA PTSMI01495ADTA041825 | -400.14 | 92757.12 | ;;;
20131001 | ACB DEBIT:EXTERNAL            (     14.50 ) SABCSAUKTV 111294245 OCT 13 | -28 | 92729.12 | ;;;
20131001 | ACB DEBIT:EXTERNAL            (     14.50 ) [NAME] | -471.15 | 92257.97 | ;;;
20131003 | ACB DEBIT:EXTERNAL            (     14.50 ) VOXCONS R843355 | -45 | 92212.97 | ;;;
20131004 | NOTIFIC FEE SMS     NOTIFYME  (      3.00 ) 6 SMS KENNISGEWINGS | 0 | 92212.97 | ;;;
Spreadsheet: e1e90035-203b-44c4-90b7-3096fc09e1ef
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | WORKFORCE
 |  |  |  |  |  |  | BRANCH: TAMWORTH
 |  |  |  |  |  |  | FAX to: 02 6765 3889  before 9am Monday
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | PAYROLL queries email: [EMAIL]
Time Sheet
Week ending day & date |  |  |  |  | Client Name
Employee Name |  |  |  |  | Client Address
Employee Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Employee's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  | Total Hours or Days
Send original receipts and client approval to Chandler Macleod, Ground Floor 127 Bridge Street, TAMWORTH NSW 2340
August 2010
Spreadsheet: 193972d1352999880-combo-box-drop-down-list-landscape2
Sheet: Sheet1

Item | Difficulty | Cost |  |  |  |  |  | Difficulty | Cost
Landscaping | 2 |  |  |  |  |  |  | Easy | 300
[NAME] |  |  |  |  |  |  |  | Medium | 500
 |  |  |  |  |  |  |  | Hard | 800
 |  |  |  | IF(OR(B2<1,B2=""),"",INDEX($J$2:$J$4,B2)) |  |  |  | Difficulty | Cost
 |  |  |  |  |  |  |  | Easy | 300
 |  |  |  |  |  |  |  | Hard | 500
Spreadsheet: 712032d1610026300-date-conversion-all-banks
Sheet: Pivot 3

Row Labels | Sum of Sum of Debit | Sum of Sum of Credit | Sum of Balance
Cash Withdrawal |  | 1030290 | -1030290
Customer | 37605081.79 | 3864 | 37601217.79
Expenses | 44370.4 | 14250106.6 | -14205736.2
Income | 108981.43 | 93725 | 15256.42999999999
Internal Transfer | 8519538 | 8627381.43 | -107843.4299999997
Nil | 853575.3 | 853575.3 | 0
Personal | 70197 | 3936616.23 | -3866419.23
Supplier | 527647.3300000001 | 23698203.86999999 | -23170556.53999999
(blank) | 4129 | 2519112.23 | -2514983.23
Grand Total | 47733520.24999999 | 55012874.65999999 | -7279354.410000026
Spreadsheet: 140586d1328811567-excluding-weekends-from-a-date-range-non-weekends
Sheet: Sheet1

AMRI | Days Processing |  | START | Would like it to be
Process 1 | 8 | Can include weekends
Analyze | 5 | Cannot include weekends |  | 2012-03-19 00:00:00
Process 2 | 1 | Can include weekends
Analyze 2 | 9 | Can include weekends
Review | 5 | Cannot include weekends |  | 2012-04-04 00:00:00
Ship | 2 | Can include weekends |  | 2012-04-11 00:00:00
END |  | Can include weekends |  | 2012-04-13 00:00:00
Spreadsheet: 766605d1643962294-search-within-an-array-table-book1
Sheet: Sheet1

Desired Results (Searchable databse)
Type the animal below | legs |  |  |  | animal database
dog | 4 |  |  |  | animal | legs
human | 2 |  |  |  | dog | 4
xyz |  |  |  |  | cat | 4
pluto |  |  |  |  | snake | 0
 |  |  |  |  | human | 2
tiny cat
snake big | 0
dog | 4
cat | 4
Spreadsheet: 51239d1250776204-hyperlink-function-help-695975
Sheet: HAX

PRODUCT DEVELOPMENT INGREDIENT DATABASE
SUPPLIER | [NAME] | WEIGHT | QUANTITY | NO. | CODE | ALLERGEN | DATE IN | DATE OUT | F.A.O. | [NAME]
HAX | REDCURRANT POWDER TYPE S | 100GM | 2 | 1 | 06 2210 |  | 2006-07-24 00:00:00 | 2007-01-01 00:00:00 | JL | C/LAB
Spreadsheet: 90025d1289792949-copying-the-value-in-specific-range-automatically-copying-values
Sheet: Sheet1

 | Start date | 2011-11-15 00:00:00
 | End date | 2011-12-01 00:00:00
 | Duration | 17
Value | 1000
2011-11-15 00:00:00 | 58.8235294117647
2011-11-16 00:00:00 | 58.8235294117647
2011-11-17 00:00:00 | 58.8235294117647
2011-11-18 00:00:00 | 58.8235294117647
2011-11-19 00:00:00 | 58.8235294117647
2011-11-20 00:00:00 | 58.8235294117647
2011-11-21 00:00:00 | 58.8235294117647
2011-11-22 00:00:00 | 58.8235294117647
2011-11-23 00:00:00 | 58.8235294117647
2011-11-24 00:00:00 | 58.8235294117647
2011-11-25 00:00:00 | 58.8235294117647
2011-11-26 00:00:00 | 58.8235294117647
2011-11-27 00:00:00 | 58.8235294117647
2011-11-28 00:00:00 | 58.8235294117647
2011-11-29 00:00:00 | 58.8235294117647
2011-11-30 00:00:00 | 58.8235294117647
2011-12-01 00:00:00 | 58.8235294117647
Spreadsheet: 150597d1334614833-converting-from-text-date-serial-date-test
Sheet: 1

Text: |  |  |  |  |  |  |  | [NAME]:
2012-04-16 15:00:00 |  |  |  |  |  |  |  | 2012-04-16 00:00:00
Date | Account | EOD Balance
2012-04-16 00:00:00 | 1243 | 100
2012-04-16 00:00:00 | 5633 | -506
2012-04-16 00:00:00 | 5674 | 20 |  | I have a macro that pulls the data from the account when the date in sheet 2 matches the date in sheet  1
2012-04-16 00:00:00 | 6200 | 0
etc | etc | etc
Spreadsheet: 73144d1273782357-index-and-match-benefits-3
Sheet: Benefits Sheet

 |  |  |  |  | Date:
 |  |  |  |  | Patient:
 |  |  |  |  | Insurance: | Delta
Unused [NAME] |  |  |  |  |  | Ins | Pt
Today's Visit |  |  |  |  | OS
Rem Maximum |  |  |  |  | GA
Remaining Ded
Proposed Treatment Plan
T# | Code | Description | NCOS Fee | - | Ins Fee | = | IWO | Est Ins Pmt | Est Pt Pmt
 | 7210 |  |  |  |  |  |  |  |  | (Ded)
 | 0
General Anesthesia
 |  | Totals:
 |  |  |  |  |  |  | Overmax
 |  |  |  |  |  |  | Total Pt Share
I authorize the doctor and/or such qualified assignees to preform the services listed above
Patient Signature ___________________________________________   Date ____________________
Financial Arrangements:
Disclaimer: Insurance coverage is estimated. Your actual indemnity may be less. You, the patient, are responsible for all amounts not covered by your inurance carrier. Ultimately, you are responsible for all financial obligations for your health care services. If for some reason the account should become deliqeunt, you agree to pay for all rebilling charges, interest charged, colection costs and attorney fees.
Signature ____________________________________________________   Date ______________________
 | Aetna | BC | Cigna | Delta | Guardian | Humana | 1st Dent | Metlife | UFCW | UC
Spreadsheet: louise_kitchen__23063__North America Nov 27
Sheet: SPECIALREPORT -1

TRADE DATE | NA GAS | NA POWER | US EAST GAS | US CENTRAL GAS | US WEST GAS | US NYMEX GAS | US TEXAS GAS | US EAST POWER | US CENTRAL POWER | US WEST POWER | CAN EAST GAS | CAN WEST GAS | CAN POWER | TOTAL TRADE CNT
2001-11-27 00:00:00 | 2016 | 662 | 404 | 401 | 455 | 676 | 52 | 377 | 8 | 275 | 7 | 21 | 2 | 3834
2001-11-26 00:00:00 | 2093 | 655 | 451 | 425 | 432 | 671 | 70 | 365 | 3 | 277 | 5 | 39 | 10 | 3547
2001-11-25 00:00:00 | 14 | 22 | 0 | 0 | 0 | 14 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 36
2001-11-24 00:00:00 | 48 | 16 | 0 | 0 | 0 | 48 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 64
2001-11-23 00:00:00 | 17 | 38 | 0 | 0 | 0 | 17 | 0 | 38 | 0 | 0 | 0 | 0 | 0 | 376
2001-11-22 00:00:00 | 27 | 8 | 0 | 0 | 0 | 27 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 318
2001-11-21 00:00:00 | 2326 | 712 | 658 | 498 | 443 | 618 | 38 | 368 | 4 | 331 | 11 | 60 | 9 | 3540
2001-11-20 00:00:00 | 3393 | 689 | 779 | 703 | 498 | 1235 | 78 | 496 | 4 | 179 | 5 | 95 | 10 | 4810
2001-11-19 00:00:00 | 3604 | 1047 | 897 | 780 | 558 | 1165 | 64 | 652 | 0 | 390 | 13 | 125 | 5 | 5533
2001-11-18 00:00:00 | 54 | 15 | 0 | 0 | 0 | 54 | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 69
2001-11-17 00:00:00 | 24 | 28 | 0 | 0 | 0 | 24 | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 52
2001-11-16 00:00:00 | 2626 | 909 | 713 | 555 | 444 | 744 | 57 | 547 | 1 | 358 | 16 | 97 | 3 | 4791
2001-11-15 00:00:00 | 2838 | 1092 | 734 | 670 | 480 | 755 | 54 | 600 | 1 | 481 | 23 | 122 | 10 | 5136
2001-11-14 00:00:00 | 2553 | 865 | 626 | 437 | 422 | 858 | 44 | 446 | 3 | 398 | 12 | 154 | 18 | 5209
2001-11-13 00:00:00 | 2312 | 930 | 532 | 526 | 508 | 562 | 74 | 436 | 5 | 481 | 12 | 98 | 8 | 4791
2001-11-12 00:00:00 | 2609 | 833 | 662 | 582 | 477 | 737 | 54 | 711 | 3 | 111 | 28 | 69 | 8 | 4762
2001-11-11 00:00:00 | 26 | 10 | 0 | 0 | 0 | 26 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 37
2001-11-10 00:00:00 | 13 | 17 | 0 | 0 | 0 | 13 | 0 | 17 | 0 | 0 | 0 | 0 | 0 | 30
2001-11-09 00:00:00 | 1834 | 782 | 469 | 356 | 329 | 535 | 29 | 467 | 1 | 301 | 32 | 84 | 13 | 3654
2001-11-08 00:00:00 | 2376 | 937 | 525 | 199 | 399 | 1040 | 55 | 710 | 1 | 210 | 15 | 143 | 16 | 4379
2001-11-07 00:00:00 | 3497 | 1542 | 782 | 688 | 789 | 932 | 51 | 903 | 7 | 621 | 65 | 190 | 11 | 6034
2001-11-06 00:00:00 | 3783 | 1547 | 955 | 837 | 689 | 958 | 73 | 982 | 3 | 554 | 61 | 210 | 8 | 6222
2001-11-05 00:00:00 | 3960 | 1581 | 972 | 798 | 704 | 1090 | 79 | 877 | 7 | 686 | 48 | 269 | 11 | 6444
2001-11-04 00:00:00 | 25 | 10 | 0 | 0 | 0 | 25 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 36
2001-11-03 00:00:00 | 26 | 32 | 0 | 0 | 0 | 26 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 58
2001-11-02 00:00:00 | 3780 | 1199 | 991 | 867 | 787 | 741 | 81 | 681 | 5 | 497 | 45 | 268 | 16 | 5836
2001-11-01 00:00:00 | 3973 | 1493 | 1001 | 858 | 692 | 1031 | 90 | 983 | 11 | 491 | 58 | 243 | 8 | 6539
Spreadsheet: 724143d1616035315-vlookup-based-on-value-that-appears-in-a-column-multiple_warehouse
Sheet: Sheet1

 |  | Location A | Location B | Location C |  | Inventory Data
Order # | Part | Quantity | Quantity | Quantity |  | Location | Part | Quantity
Order 1 | Part C |  |  |  |  | Location A | Part A | 1
Order 2 | Part B |  |  |  |  | Location A | Part B | 2
Order 3 | Part D |  |  |  |  | Location A | Part C | 3
Order 4 | Part A |  |  |  |  | Location A | Part D | 4
Order 5 | Part B |  |  |  |  | Location A | Part E | 5
Order 6 | Part A |  |  |  |  | Location B | Part A | 6
Order 7 | Part D |  |  |  |  | Location B | Part B | 7
Order 8 | Part A |  |  |  |  | Location B | Part C | 8
Order 9 | Part B |  |  |  |  | Location B | Part D | 9
Order 10 | Part B |  |  |  |  | Location B | Part E | 10
Order 11 | Part C |  |  |  |  | Location C | Part A | 11
Order 12 | Part E |  |  |  |  | Location C | Part B | 12
Order 13 | Part A |  |  |  |  | Location C | Part C | 13
Order 14 | Part E |  |  |  |  | Location C | Part D | 14
Order 15 | Part D |  |  |  |  | Location C | Part E | 15
Spreadsheet: 847514d1698404118-calculate-accumulated-values-for-each-day-during-the-last-90-days-from-newest-date-volymeday
Sheet: Blad1

 | Date: | Total per day | date 2 |  |  | Presentation to be:
 |  |  |  |  | Find automatically accumulated value with newest date on the top |  |  |  |  |  |  | Find values for each month where values exist
 | 2023-12-10 00:00:00 | 3000 |  |  | If a "date2" exist in D column, the row should not be calculated.
 | 2023-12-10 00:00:00 | 4000 |  |  | Values to calculated 90 days backwards from newest date
 | 2023-12-01 00:00:00 | 2000 |  |  |  | 2023-12-10 00:00:00 | 7000 |  |  |  |  | 2023-DEC | 15000
 | 2023-10-29 00:00:00 | 1000 |  |  |  | 2023-12-01 00:00:00 | 8000 |  |  |  |  | 2023-NOV | 36000
 | 2023-10-29 00:00:00 | 7000 |  |  |  | 2023-11-09 00:00:00 | 21000 |  |  |  |  | 2023-OCT | 16000
 | 2023-12-01 00:00:00 | 6000 |  |  |  | 2023-11-01 00:00:00 | 15000
 | 2023-11-01 00:00:00 | 3000 |  |  |  | 2023-10-29 00:00:00 | 9000
 | 2023-10-29 00:00:00 | 1000 |  |  |  | 2023-10-28 00:00:00 | 7000
 | 2023-11-09 00:00:00 | 2000 | 2023-11-09 00:00:00
 | 2023-10-28 00:00:00 | 7000
 | 2023-11-01 00:00:00 | 1000 |  |  |  |  | 7000
 | 2023-11-01 00:00:00 | 8000 |  |  |  | 2023-12-01 00:00:00 | 8000
 | 2023-11-01 00:00:00 | 2000 |  |  |  | 2023-11-09 00:00:00 | 21000
 | 2023-11-09 00:00:00 | 10000 |  |  |  | 2023-11-01 00:00:00 | 15000
 | 2023-11-09 00:00:00 | 9000 |  |  |  | 2023-10-29 00:00:00 | 9000
 | 2023-11-09 00:00:00 | 2000 |  |  |  | 2023-10-28 00:00:00 | 7000
 | 2023-11-01 00:00:00 | 1000
Matris is about 2000 rows
Spreadsheet: 176687d1346073424-indexing-with-duplicates-issue-department-position-status-working-file
Sheet: MemberOperations

MemberOperations
 | Filled Positions |  |  |  |  |  |  |  |  |  |  |  | Open Positions
 | Title | Location | Category | Hiring Manager | Number of Openings | Number Filled | Date Activated | Date Filled | Start Date | Business Days to Offer | Comments |  |  | Title | Location | Category | Hiring Manager | Created Date | Age | Comments
Spreadsheet: b9f9a5d3-4df1-49be-abe7-bb20ee4dc1dd
Sheet: CHINA

CHINA | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
EXPORT SALES, Egypt | this year | last year | this year | last year | this year | last year
2013-05-23 00:00:00 | 58.4 | 55.8 | 740.4 | 534.3 |  |  | 1443.2
 | 57 | 55.8 | 741.8 | 534.3 |  |  | 1464
 | 1465.3 | 167 | 57.8 | 57.8
 | 1498.3 | 281.5 | 115.6 | 57.8
 | 1473.8 | 280 | 115.6 | 59.2
 | 1480.1 | 277.5 | 348.6 | 61.8
 | 2329 | 274.3 | 523.4 | 64.9
 | 2741 | 273.5 | 531.4 | 65.8
 | 2847.1 | 272 | 603.2 | 67.2
 | 2790.7 | 213.6 | 789.4 | 127.6
 | 2671.2 | 211.3 | 969.7 | 129.9
 | 2602.1 | 169.6 | 1099.8 | 173.6
 | 2413.8 | 167.6 | 1340.4 | 175.5
 | 2221.4 | 167.2 | 1534.7 | 176
 | 2041.8 | 111.2 | 1720.6 | 234.6
 | 1746.4 | 55.2 | 2021.3 | 348.4
 | 1334.2 | 2.2 | 2428 | 406.1
 | 1267.1 | 2 | 2666.6 | 406.2
 | 1084 | 2 | 2848 | 406.2
 | 962.1 | 3 | 3018.1 | 406.2
 | 596.7 | 2.7 | 3427.9 | 407.1
 | 599.3 | 2 | 3428.3 | 407.8
 | 539.3 | 0.8 | 3487.1 | 409
 | 479.3 | 0.4 | 4546.2 | 409.5
 | 478.4 | 55.4 | 3606.8 | 409.5
 | 418.4 | 55.4 | 3669.3 | 409.5
 | 298.4 | 55.4 | 3785.9 | 409.5
 | 243.4 | 55 | 3838.2 | 409.9
 | 298.4 | 55.5 | 3838.2 | 409.9
 | 298.4 | 55.5 | 3838.2 | 409.9
 | 298.4 | 55.5 | 3838.2 | 409.9
 | 178.4 | 167.2 | 4017 | 409.9
 | 118.4 | 112.2 | 4078.9 | 467.7
 | 118.2 | 112.2 | 4078.9 | 467.7
 | 118.2 | 112.2 | 4078.9 | 468.7
 | 118.2 | 168.2 | 4078.9 | 467.7
 | 117.2 | 254.2 | 4081.9 | 467.7
 | 117.2 | 199.4 | 4081.9 | 468.4
 | 177.2 | 198.3 | 4081.9 | 529.9
 | 177.2 | 197.8 | 4081.9 | 530.4
 | 177 | 252.2 | 4081.9 | 531
 | 177 | 197 | 4081.9 | 591.7
 | 177 | 197 | 4081.9 | 591.7
 | 177 | 197.5 | 4081.9 | 591.7