tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4c55578a-acdb-4b7a-b984-eb0544d97330
Sheet: Sheet1

A level examination entries 2008/09 (provisional) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Female | Male | Total
Biology | 1935 | 1262 | 3197
Chemistry | 946 | 829 | 1775
Physics | 372 | 952 | 1324
Environmental Science | 0 | 1 | 1
Geology | 15 | 31 | 46
Mathematics | 1191 | 1513 | 2704
Statistics | 8 | 0 | 8
Further Maths | 36 | 114 | 150
Computer Studies | 12 | 81 | 93
Information Technology | 475 | 626 | 1101
Business Studies | 631 | 597 | 1228
Home Economics | 540 | 18 | 558
Art and Design | 713 | 332 | 1045
Art and Design: Graphics | 0 | 1 | 1
Art and Design (Photography) | 4 | 5 | 9
Art and Design (Critical Studies) | 46 | 24 | 70
Fine Art | 3 | 2 | 5
Geography | 1031 | 949 | 1980
History | 1115 | 1196 | 2311
Economics | 185 | 256 | 441
Religious Studies | 1500 | 587 | 2087
Law | 3 | 0 | 3
Politics | 432 | 586 | 1018
Psychology | 238 | 69 | 307
Sociology | 647 | 140 | 787
English | 48 | 22 | 70
English Language | 18 | 19 | 37
English Literature | 1681 | 656 | 2337
Drama | 427 | 158 | 585
Media Studies | 480 | 370 | 850
Film Studies | 3 | 4 | 7
Irish | 202 | 126 | 328
French | 471 | 186 | 657
German | 91 | 46 | 137
Italian | 2 | 0 | 2
Portuguese | 0 | 1 | 1
Spanish | 276 | 131 | 407
Chinese | 22 | 15 | 37
Polish | 1 | 3 | 4
Russian | 8 | 1 | 9
Ancient History | 0 | 10 | 10
Classical Civilisation | 60 | 36 | 96
Latin | 11 | 5 | 16
Music | 276 | 189 | 465
PE Studies | 269 | 484 | 753
Dance | 2 | 0 | 2
Accounting/Finance | 64 | 86 | 150
Design and Technology | 66 | 300 | 366
Systems | 7 | 38 | 45
Design and technology: Product Design | 132 | 256 | 388
Total | 16695 | 13313 | 30008
Figures include examinations taken in Winter 2008.
Spreadsheet: 108540d1305595378-largest-date-until-sum-10-largestdatesample
Sheet: Sheet1

Date | Color | Count
2010-01-11 00:00:00 | Red | 1
2010-01-15 00:00:00 | Blue
2010-01-15 00:00:00 | Blue
2010-01-16 00:00:00 | Red
2010-01-16 00:00:00 | Blue | 1
2009-08-29 00:00:00 | Red
2010-01-17 00:00:00 | Red | 1
2010-01-26 00:00:00 | Blue | 3
2010-01-26 00:00:00 | Red | 2
2010-01-28 00:00:00 | Red
2010-02-01 00:00:00 | Red | 1
2010-02-11 00:00:00 | Blue | 3
2010-03-13 00:00:00 | Blue
2010-03-13 00:00:00 | Red
2010-03-14 00:00:00 | Green | 4
2010-03-19 00:00:00 | Blue
2010-03-21 00:00:00 | Blue | 1
2010-03-21 00:00:00 | Blue | 1
2010-03-21 00:00:00 | Blue
2010-04-15 00:00:00 | Red | 2
2010-04-16 00:00:00 | Blue
Spreadsheet: 102840d1300783735-prediction-sheet-excel_example
Sheet: PrSales_12

Products & Sales |  |  |  |  | 2012 |  |  |  |  |  |  |  | PrSales_12 | PrSales_11
 |  |  | The numbers below represent sales per product
Description | Cost | Selling Price | jan | feb | [NAME] | apr | may | jun | jul | aug | sept | oct | nov | dec |  | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
1 | 4.9 | 6.125 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 2.87992 | 3.5999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 2.87992 | 3.5999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 2.75 | 3.4375 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 1.36 | 1.7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 2.4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 2.08 | 2.6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 2.09 | 2.6125 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | 3.02 | 3.775 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 3.99992 | 4.9999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 4.8 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 1.12 | 1.4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 1.24 | 1.55 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | 1.4 | 1.75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | 1.44 | 1.8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | 3.2 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | 1.24 | 1.55 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 | 1.68 | 2.1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | 1.8 | 2.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 | 1.96 | 2.45 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 | 2.04 | 2.55 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 | 1.68 | 2.1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | 3.4 | 4.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 688260d1595672046-password-generator-conversion-to-xl2003-example1794
Sheet: Create a password

 | Series | Type | Characters | Random Number | Index | Characters
 | 1st | Random Number | 7 | 2.0003 | 8 | ( |  | Password | (QT-9sw7
 |  | Random Uppercase Letter | T | 4.0004 | 6 | Q
 |  | Random Lowercase Letter | w | 7.0005 | 2 | T |  | [NAME] to regenarate
 |  | [NAME] | - | 5.0006 | 4 | -
 | 2nd | Random Number | 9 | 4.0007 | 5 | 9
 |  | Random Uppercase Letter | Q | 3.0008 | 7 | s
 |  | Random Lowercase Letter | s | 6.0009 | 3 | w
 |  | [NAME] | ( | 8.001 | 1 | 7
 |  | 33 | ! | 91 | [
 |  | 34 | " | 92 | \
 |  | 35 | # | 93 | ]
 |  | 36 | $ | 94 | ^
 |  | 37 | % | 95 | _
 |  | 38 | & | 96 | `
 |  | 39 | '
 |  | 40 | (
 |  | 41 | )
 |  | 42 | *
 |  | 43 | +
 |  | 44 | ,
 |  | 45 | -
 |  | 46 | .
 |  | 47 | /
Spreadsheet: 178923d1346956339-how-to-transpose-columns-into-rows-tableeditedshadrack
Sheet: Sheet4

Borrower ID | Loan ID | Recovery 1006-1106 | Payment 3Q 2011 | Payment 4Q 2011 | Payment 1Q 2012 | Payment 2Q 2012
6440 | 6440015 | 0 | 0 | 4570.944666666668 | 5645.580753333328 | 2936.252980000001
6440 | 6440090 | 1910.7579 | 0 | 0 | 0 | 0
6492 | 6492018 | 2348.048183333333 | 0 | 0 | 0 | 0
Borrower ID | Loan ID | Payment | Period
6440 | 6440015 | 0 | 1006-1106
6440 | 6440090 | 1910.7579 | 1006-1106
6492 | 6492018 | 2348.048183333333 | 1006-1106
6440 | 6440015 | 5645.580753333328 | 1Q 2012
6440 | 6440090 | 0 | 1Q 2012
6492 | 6492018 | 0 | 1Q 2012
6440 | 6440015 | 2936.252980000001 | 2Q 2012
6440 | 6440090 | 0 | 2Q 2012
6492 | 6492018 | 0 | 2Q 2012
6440 | 6440015 | 0 | 3Q 2011
6440 | 6440090 | 0 | 3Q 2011
6492 | 6492018 | 0 | 3Q 2011
6440 | 6440015 | 4570.944666666668 | 4Q 2011
6440 | 6440090 | 0 | 4Q 2011
6492 | 6492018 | 0 | 4Q 2011
 | 6440 | 6440 | 6492 | 6440 | 6440 | 6492 | 6440 | 6440 | 6492 | 6440 | 6440 | 6492 | 6440 | 6440 | 6492
Loan ID | 6440015 | 6440090 | 6492018 | 6440015 | 6440090 | 6492018 | 6440015 | 6440090 | 6492018 | 6440015 | 6440090 | 6492018 | 6440015 | 6440090 | 6492018
Payment | 0 | 1910.7579 | 2348.048183333333 | 5645.580753333328 | 0 | 0 | 2936.252980000001 | 0 | 0 | 0 | 0 | 0 | 4570.944666666668 | 0 | 0
Period | 1006-1106 | 1006-1106 | 1006-1106 | 1Q 2012 | 1Q 2012 | 1Q 2012 | 2Q 2012 | 2Q 2012 | 2Q 2012 | 3Q 2011 | 3Q 2011 | 3Q 2011 | 4Q 2011 | 4Q 2011 | 4Q 2011
Spreadsheet: kate_symes__18165__EOL 2-21
Sheet: EOL Deals

EOL Deals | From: 2/1/2001   To: 2/21/2001 |  |  | EnPower Deals | From: 2/1/2001   To: 2/21/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 693200 | 30 |  | EPMI Long Term California | 2329025 | 35
EPMI Long Term Northwest | 822200 | 44 |  | EPMI Long Term Northwest | 8544542 | 222
EPMI Long Term Southwest | 2045200 | 47 |  | EPMI Long Term Southwest | 13360525 | 104
EPMI Short Term California | 645000 | 551 |  | EPMI Short Term California | 1350250 | 318
EPMI Short Term Northwest | 120600 | 185 |  | EPMI Short Term Northwest | 386073 | 151
EPMI Short Term Southwest | 879200 | 339 |  | EPMI Short Term Southwest | 1719175 | 307
Grand Total | 5205400 | 1196 |  | Grand Total | 27889590 | 1137
EOL Deals | From: 2/21/2001   To: 2/21/2001
Desk | Total MWH | Total Deals |  | EnPower Deals | From: 2/21/2001   To: 2/21/2001
 |  |  |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 184400 | 6
EPMI Long Term Northwest | 21600 | 2 |  | EPMI Long Term Northwest | 111975 | 7
EPMI Long Term Southwest | 132000 | 7 |  | EPMI Long Term Southwest | 675200 | 8
EPMI Short Term California | 37800 | 58 |  | EPMI Short Term California | 20000 | 14
EPMI Short Term Northwest | 17800 | 30 |  | EPMI Short Term Northwest | 136200 | 11
EPMI Short Term Southwest | 43600 | 35 |  | EPMI Short Term Southwest | 26000 | 14
Grand Total | 437200 | 138 |  | Grand Total | 1030975 | 54
EOL Deals | From: 1/1/2001   To: 2/21/2001 |  |  | EnPower Deals | From: 1/1/2001   To: 2/21/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 1444800 | 97 |  | EPMI Long Term California | 6033090 | 180
EPMI Long Term Northwest | 2279025 | 130 |  | EPMI Long Term Northwest | 31690837 | 568
EPMI Long Term Southwest | 4420800 | 119 |  | EPMI Long Term Southwest | 23935114 | 320
EPMI Short Term California | 1134600 | 1315 |  | EPMI Short Term California | 2378520 | 824
EPMI Short Term Northwest | 240800 | 404 |  | EPMI Short Term Northwest | 832993 | 370
EPMI Short Term Southwest | 1876400 | 810 |  | EPMI Short Term Southwest | 3417015 | 684
Grand Total | 11396425 | 2875 |  | Grand Total | 68487569 | 2946
Spreadsheet: 728426d1618453583-index-match-multiple-criterion-returning-accounts-numbers-with-values-over-zero-help-list-test
Sheet: Report

account |  | first name |  |  |  |  | pymt 1 |  |  |  |  | Pymt 2 |  |  |  |  |  |  |  |  |  |  |  | Member ID
1999001111 |  | SYLVESTER |  |  |  |  | 0 |  |  |  |  | 45 |  |  |  |  |  |  |  |  |  |  |  | 60036011
1999005511 |  | SYLVESTER |  |  |  |  | 1502.84 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 60036011
2020003434 |  | [NAME] |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 11036011
2020003435 |  | [NAME] |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 59841239
2020003436 |  | SYLVESTER |  |  |  |  | 76.99 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 60036011
2020003437 |  | TOM |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 50155429
2020003438 |  | [NAME] |  |  |  |  | 0 |  |  |  |  | 4000 |  |  |  |  |  |  |  |  |  |  |  | 91746011
2020003558 |  | [NAME] |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 91746011
2021009999 |  | SYLVESTER |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 60036011
Spreadsheet: 840759d1692968561-get-a-list-of-words-consisting-of-certain-letters-only-from-a-named-range-exelforum-extract-words
Sheet: Ark1

abba | [NAME] | a
[NAME] | akper | n
abdul | akpere | k
abduls | [NAME]
abeba | anc
[NAME] | ancs
abel | ansa
abelhaugen | ansi
abelkonkurransen | acnac
[NAME] | aofs
aker | alsace
akergruppen | alsaces
Spreadsheet: 78152d1278567705-monthly-total-for-particular-expense-account-sumproduct-example
Sheet: Sheet1

 |  |  | Accounts
 | Date | Type | Debit | Credit
 | 2010-07-01 00:00:00 | fuel |  | -50
 | 2010-07-05 00:00:00 | food |  | -25
 | 2010-07-05 00:00:00 | [NAME] |  | -20
 | 2010-07-07 00:00:00 | food |  | -50
 | 2010-07-08 00:00:00 | transfer | -145 | 145
 | Analysis | Jul | Aug | Sep | Oct | Nov
 | Credit | 0
 | Expense Type |  | SUMPRODUCT((TEXT($B$3:$B$7,"MMM")=C$9)*($E$3:$E$7))
 | 1. Reads month from the month input row in Analysis table, uses column range B3:B7
 | 2. Reads and sums all expenses from credit account
 | PROBLEM:
 | Works fine as long as there is no positive transaction to nullify incurred credit
 | REALITY:
 | All credit accounts need to be paid. Running a sum of all these will result in Zero value
 | SOLUTION?
 | How is it possible to modify the above formula such that it picks up negative numbers only?
 | NOTE:
 | Expense is noted as a negative number
 | Income is noted as a positive number
Spreadsheet: 104790d1302253431-excel-2007-mcx-commodities-in-excel-file-buntz-mcx
Sheet: Sheet1

DATE | SCRIPT | BQ | BUY PRICE | SQ | SELL PRICE | Points | G-P/L | N-P/L |  | GOLD | 100
 |  |  |  |  |  |  |  |  |  | SILVER | 30
2011-04-04 00:00:00 | SILVER | 1 | 56214 | 1 | 56400 |  |  |  |  | LEAD | 5000
2011-04-05 00:00:00 | GOLD | 2 | 20960 | 2 | 20973 |  |  |  |  | ZINC | 5000
2011-04-04 00:00:00 | LEAD | 3 | 107 | 3 | 109 |  |  |  |  | COPPER | 1000
2011-04-05 00:00:00 | GOLD | 2 | 20500 | 2 | 20600 |  |  |  |  | GAS | 1250
2011-04-04 00:00:00 | Silver | 1 | 55000 | 1 | 56000
2011-04-04 00:00:00 | Zinc | 2 | 100 | 2 | 101
 | GAS | 1 | 185 | 1 | 186
 | Copper | 1 | 450 | 1 | 460
Spreadsheet: 677734d1589488776-power-query-merge-many-to-many-relationship-and-remove-duplicates-template-with-shipped-v3
Sheet: Raw Data

Order Number | Product | Product Code
FBAAMZ FR200305 | Sugar | 023
FBAAMZ FR200305 | Salt | 27
FBAAMZ FR200305 | Pepper | 54
[NAME]. | Shipment Comments
FBAAMZ FR200305 | [PHONE]-3217141
FBAAMZ FR200305 | [PHONE]-3874702
FBAAMZ FR200305 | [PHONE]-9910736
Spreadsheet: 793389d1661443658-looking-for-help-on-min-function-returning-wrong-value-firsttimeuploadtest
Sheet: Sheet1

ID | CreatedDateTime |  | LeadID | Earliest Date
00Q5G00000a2BUP | 16/02/2022 4:21 PM |  | 00Q5G00000a2BUP | =MIN(IF($A:$A=D2,B2, 0))
00Q5G00000a2C5A | 11/02/2022 4:21 PM |  | 00Q5G00000a2C5A
00Q5G00000a2kHI | 21/06/2022 12:01 PM |  | 00Q5G00000a2kHI
00Q5G00000a2m5v | 07/04/2022 10:51 AM |  | 00Q5G00000a2m5v
00Q5G00000a2mdW | 21/03/2022 10:45 AM |  | 00Q5G00000a2mdW
00Q5G00000a2wTy | 27/05/2022 9:53 AM |  | 00Q5G00000a2wTy
00Q5G00000a3fag | 01/04/2022 12:03 PM |  | 00Q5G00000a3fag
00Q5G00000a3fag | 01/04/2022 12:03 PM |  | 00Q5G00000a3oVM
00Q5G00000a3fag | 05/04/2022 2:00 PM |  | 00Q5G00000a3oXI
00Q5G00000a3fag | 07/04/2022 10:38 AM |  | 00Q5G00000a3pci
00Q5G00000a3fag | 07/04/2022 10:39 AM |  | 00Q5G00000a3ppT
00Q5G00000a3fag | 11/04/2022 9:53 AM |  | 00Q5G00000a3qh8
00Q5G00000a3fag | 12/04/2022 1:01 PM |  | 00Q5G00000a3tVV
00Q5G00000a3fag | 14/04/2022 3:01 PM |  | 00Q5G00000a3twH
00Q5G00000a3fag | 18/04/2022 1:51 PM |  | 00Q5G00000a3uiw
00Q5G00000a3fag | 26/04/2022 4:38 PM |  | 00Q5G00000a41fC
00Q5G00000a3fag | 26/04/2022 4:40 PM |  | 00Q5G00000a4DVS
00Q5G00000a3fag | 26/04/2022 4:40 PM |  | 00Q5G00000a4Lbw
00Q5G00000a3fag | 28/04/2022 4:36 PM |  | 00Q5G00000a5HW9
Spreadsheet: 832459d1686337456-formula-to-sum-an-offset-column-from-criteria-match-sample-sheet-for-sumif-with-offset-help
Sheet: Sheet1

Item no: | UNIT | [NAME] | TOTAL QTY ESTIMATED FOR ALL DESIGNS |  | TO-DATE |  |  | SYSTEM #1 |  | SYSTEM #2 |  | SYSTEM #3 |  | SYSTEM #4 |  | SYSTEM #5 |  | SYSTEM #6
 |  |  | FOR ALL  DESIGNS | FOR ORDERED  DESIGNS | ORDERED | EXTRA |  | BOM | ORDER | BOM | ORDER | BOM | ORDER | BOM | ORDER | BOM | ORDER | BOM | ORDER
 |  |  |  |  |  | (available for next order) |  | req'd by design | SJ 987654 | req'd by design | SJ | req'd by design | SJ 123456 | req'd by design | SJ | req'd by design | SJ | req'd by design | SJ
 |  | SYSTEM COMPONENTS
1 | EA | MATERIAL #1 |  |  |  |  |  | 5 | 5 | 3 |  | 7 | 6 | 3 |  | 4
2 | EA | MATERIAL #2 |  |  |  |  |  | 5 |  | 3 |  | 5 | 6 | 3 |  | 4
3 | EA | MATERIAL #3 |  |  |  |  |  | 1 |  |  |  |  | 2 | 6
4 | EA | MATERIAL #4 |  |  |  |  |  | 11 | 8 | 3 |  | 7 | 4 | 12 |  | 4
5 | EA | MATERIAL #5 |  |  |  |  |  | 8 | 8 | 3 |  | 15 | 18 | 3 |  | 4
 |  |  |  | ã |  | ã
 |  |  |  | expected results |  | expected results
 |  |  |  | 12
 |  |  |  | 12
 |  |  |  | 1 |  | 1
 |  |  |  | 18
 |  |  |  | 23 |  | 3
Spreadsheet: 858247d1706977367-median-if-formula-query-please-sample-spreadsheet
Sheet: Sheet1

WEEK | DAY | DATE | MONTH | K NUMBER | CONS | OPERATION | DISCHARGED | LOS |  |  | Month | Mean LOS | Median LOS
2 | Wednesday | 2023-08-09 00:00:00 | 2023-08-01 00:00:00 | K0418529 | HEM | [NAME] | 2023-08-10 00:00:00 | 1 |  |  | 2023-08-01 00:00:00
2 | Wednesday | 2023-08-09 00:00:00 | 2023-08-01 00:00:00 | K1039925 | HEM | [NAME] | 2023-08-10 00:00:00 | 1 |  |  | 2023-09-01 00:00:00
2 | Wednesday | 2023-08-09 00:00:00 | 2023-08-01 00:00:00 | K0195870 | HEM | [NAME] | 2023-08-10 00:00:00 | 1 |  |  | 2023-10-01 00:00:00
2 | Wednesday | 2023-08-09 00:00:00 | 2023-08-01 00:00:00 | K3573430 | DMH | THR | 2023-08-11 00:00:00 | 2 |  |  | 2023-11-01 00:00:00
6 | Thursday | 2023-09-07 00:00:00 | 2023-09-01 00:00:00 | [NAME] | BVB | [NAME] | 2023-09-10 00:00:00 | 2
6 | Friday | 2023-09-08 00:00:00 | 2023-09-01 00:00:00 | K0171573 | RB | [NAME] | 2023-09-08 00:00:00 | 0
6 | Friday | 2023-09-08 00:00:00 | 2023-09-01 00:00:00 | K0016993 | RB | UKR | 2023-09-09 00:00:00 | 1
10 | Friday | 2023-10-06 00:00:00 | 2023-10-01 00:00:00 | K3137900 | ARM | THR | 2023-10-14 00:00:00
10 | Friday | 2023-10-06 00:00:00 | 2023-10-01 00:00:00 | K0105403 | BVB | [NAME] | 2023-10-08 00:00:00 | 2
10 | Friday | 2023-10-06 00:00:00 | 2023-10-01 00:00:00 | K0939239 | BVB | THR | 2023-10-08 00:00:00 | 2
10 | Friday | 2023-10-06 00:00:00 | 2023-10-01 00:00:00 | K1514953 | BVB | [NAME] | 2023-10-10 00:00:00 | 4
11 | Monday | 2023-10-09 00:00:00 | 2023-10-01 00:00:00 | K0761898 | RB | [NAME] | 2023-10-10 00:00:00 | 1
11 | Monday | 2023-10-09 00:00:00 | 2023-10-01 00:00:00 | K1167521 | RB | THR | 2023-10-10 00:00:00 | 1
11 | Monday | 2023-10-09 00:00:00 | 2023-10-01 00:00:00 | K1592087 | RB | [NAME] | 2023-10-10 00:00:00 | 1
14 | Friday | 2023-11-03 00:00:00 | 2023-11-01 00:00:00 | K0585157 | ARM | THR | 2023-11-04 00:00:00 | 1
14 | Friday | 2023-11-03 00:00:00 | 2023-11-01 00:00:00 | K1052434 | BVB | [NAME] | 2023-11-04 00:00:00 | 1
14 | Friday | 2023-11-03 00:00:00 | 1932-11-01 00:00:00 | K0426464 | BVB | [NAME] | 2023-11-10 00:00:00 | 7
14 | Friday | 2023-11-03 00:00:00 | 2023-11-01 00:00:00 | K0210156 | ARM | THR | 2023-11-05 00:00:00 | 2
15 | Monday | 2023-11-06 00:00:00 | 2023-11-01 00:00:00 | K0851529 | APB | THR | 2023-11-08 00:00:00 | 2
Spreadsheet: 102886d1300800601-rename-product-number-and-adding-a-path-book1_ryanb4614
Sheet: Sheet1

 | mydomain.com/images/productimage/
AA07006 | mydomain.com/images/productimage/A/A07006.jpg | A | 2 | A
ZU07045 | mydomain.com/images/productimage/Z/Z07045.jpg | Z | 3 | Z
BK09858 | mydomain.com/images/productimage/B/B09858.jpg | B | 4 | B
AA07006 | mydomain.com/images/productimage/A/A07006.jpg | A |  | C
CU07045 | mydomain.com/images/productimage/C/C07045.jpg | C | 6 | N
BK09858 | mydomain.com/images/productimage/B/B09858.jpg | B
NA07006 | mydomain.com/images/productimage/N/N07006.jpg | N | 8
ZU07045 | mydomain.com/images/productimage/Z/Z07045.jpg | Z
BK09858 | mydomain.com/images/productimage/B/B09858.jpg | B
Spreadsheet: 767280d1644391551-inconsistency-in-date-sample
Sheet: Sheet1

Value Date | Description | Ref No./Cheque No. | Debit | Credit
2020-04-04 00:00:00 | by debit card-OTHPG 009514641715Freshtohome Bangalore- |  | 247
2020-04-05 00:00:00 | BULK POSTING-CR_DR ASHOK KUMAR P KA024723  04- |  |  | 1586.8
2020-04-06 00:00:00 | BULK POSTING-CR_DR ASHOK KUMAR P KA024723  05- |  |  | 293.7
2020-04-07 00:00:00 | BULK POSTING-CR_DR ASHOK KUMAR P KA024723  06- |  |  | 1288
2020-04-08 00:00:00 | BULK POSTING-CR_DR ASHOK KUMAR P KA024723  07- |  |  | 1082
2020-04-09 00:00:00 | BULK POSTING-CR_DR ASHOK KUMAR P KA024723  08- |  |  | 1679.6
2020-04-09 00:00:00 | by debit card-OTHPG 010020599175RAZORPAY LICIOUS      JAIPUR- |  | 338
10 04 2020 | BULK POSTING-CR_DR ASHOK KUMAR P KA024723  09- |  |  | 1188.4
10 04 2020 | by debit card-OTHPG 010113088010Freshtohome Bangalore- |  | 950
Spreadsheet: 272274d1382329732-working-schedule-test
Sheet: Splash

 | [NAME]
 | Retrieve values from Temp Schedule
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | 2013-11-17 00:00:00 | 2013-11-18 00:00:00 | 2013-11-19 00:00:00 | 2013-11-20 00:00:00 | 2013-11-21 00:00:00 | 2013-11-22 00:00:00 | 2013-11-23 00:00:00 | 2013-11-24 00:00:00 | 2013-11-25 00:00:00 | 2013-11-26 00:00:00 | 2013-11-27 00:00:00 | 2013-11-28 00:00:00 | 2013-11-29 00:00:00 | 2013-11-30 00:00:00 | 2013-12-01 00:00:00 | 2013-12-02 00:00:00 | 2013-12-03 00:00:00 | 2013-12-04 00:00:00 | 2013-12-05 00:00:00 | 2013-12-06 00:00:00 | 2013-12-07 00:00:00 | 2013-12-08 00:00:00 | 2013-12-09 00:00:00 | 2013-12-10 00:00:00 | 2013-12-11 00:00:00 | 2013-12-12 00:00:00 | 2013-12-13 00:00:00 | 2013-12-14 00:00:00
 | A | A | A |  |  |  |  | A | A | A |  |  |  |  | A | A | A |  |  |  |  | A | A | A
 | Push values to Temp Schedule
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | 2013-11-17 00:00:00 | 2013-11-18 00:00:00 | 2013-11-19 00:00:00 | 2013-11-20 00:00:00 | 2013-11-21 00:00:00 | 2013-11-22 00:00:00 | 2013-11-23 00:00:00 | 2013-11-24 00:00:00 | 2013-11-25 00:00:00 | 2013-11-26 00:00:00 | 2013-11-27 00:00:00 | 2013-11-28 00:00:00 | 2013-11-29 00:00:00 | 2013-11-30 00:00:00 | 2013-12-01 00:00:00 | 2013-12-02 00:00:00 | 2013-12-03 00:00:00 | 2013-12-04 00:00:00 | 2013-12-05 00:00:00 | 2013-12-06 00:00:00 | 2013-12-07 00:00:00 | 2013-12-08 00:00:00 | 2013-12-09 00:00:00 | 2013-12-10 00:00:00 | 2013-12-11 00:00:00 | 2013-12-12 00:00:00 | 2013-12-13 00:00:00 | 2013-12-14 00:00:00
 | A | A | A |  |  |  |  | A | A | A |  |  |  |  | A | A | A |  |  |  |  | A | A | A
Spreadsheet: 758452d1638884349-count-duplicate-sets-of-2-numbers-test-01
Sheet: Sheet1

a | b | c | d | e | f | g | Duplicate same sets | Comment
8 | 8 | 3 | 7 | 3 | 7 | 7 | 2 | 37 & # 37 is a same duplicate
2 | 0 | 2 | 6 | 1 | 0 | 2 | 2 | 02 & 02 is the same duplicate
4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 44 & 44 & 44 is the same duplicate
8 | 2 | 8 | 2 | 8 | 2 | 3 | 2 | 82 & 82 & 82 is the same duplicate
1 | 1 | 2 | 2 | 0 | 0 | 1 | 0 | because the sets are not same
3 | 0 | 2 | 4 | 8 | 1 | 9 | 0 | no duplicate sets
Spreadsheet: 82724d1282753640-search-for-value-in-one-row-and-take-next-column-value-example
Sheet: Example table 

Inventory Number | Attribute7Name | Attribute7Value | Attribute8Name | Attribute8Value | Attribute26Name | Attribute26Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attribute47Name | Attribute47Value | Attribute48Name | Attribute48Value | Attribute49Name | Attribute49Value | Attribute50Name | Attribute50Value | DC Code
BILL717-P | Color | Black | Color2 | Black and Gray | pic1 | 6_18_59.JPG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tukwila
BILL717-31 | Color2 | Orange and blue | Color | Orange | pic1 | 6_18_59.JPG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tukwila
POLOS24-P | Color | Multi-Colored | Color2 | Multi | pic1 | 8_24_9_0188.JPG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tukwila
BILL773-P | pic1 | IMG_5160.jpg | Color | Multi-Colored | Color2 | Multi |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tukwila
Quik250-P | Color | Multi-Colored | Color2 | Multi | pic1 | 01_13_10_341.JPG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tukwila
Quik253-P | Color | Black | Color2 | Black Blue and pink | pic1 | 01_13_10_413.JPG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tukwila
BILL840-P | Color | Black | Color2 | Black | pic1 | 02_15_10_0213.JPG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tukwila