tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 277c16ef-0c1f-44ae-bdf4-b070466a6c88
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688654320 | Building 429 | I Believe | 2006-03-14 | Studio Series 3-Key CD Trax | Rock | 9.99 | N | To Be Retired
Word Records | 80688654221 | Building 429 | Fearless | 2006-03-14 | Studio Series 3-Key CD Trax | Rock | 9.99 | N | To Be Retired
Word Records | 80688654023 | Building 429 | Because You'Re Mine | 2006-03-14 | Studio Series 3-Key CD Trax | Rock | 9.99 | N | To Be Retired
Word Records | 80688654429 | Building 429 | I Belong To You | 2006-03-14 | Studio Series 3-Key CD Trax | Rock | 9.99 | N | To Be Retired
Word Records | 80688649425 | Building 429 | Space In Between Us, The | 2005-11-08 | Studio Series 3-Key CD Trax | Rock | 9.99 | N | To Be Retired
Word Records | 80688649326 | Building 429 | No One Else Knows | 2005-11-08 | Studio Series 3-Key CD Trax | Rock | 9.99 | N | To Be Retired
Word Records | 80689461620 | Building 429 | Glory Defined | 2004-04-16 | Studio Series 3-Key CD Trax | Na | 9.99 | N | To Be Retired
Word Records | 80688721527 | Building 429 | Power Of Your Name | 2007-05-01 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688721428 | Building 429 | Majesty | 2007-05-01 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688721329 | Building 429 | You Carried Me | 2007-05-01 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688719920 | Building 429 | Grace Greater Than All Our Sin | 2007-06-05 | Studio Series 3-Key CD Trax | Praise | 9.99 | N | To Be Retired
Spreadsheet: 774014d1648160886-comparing-dimensions-in-2-columns-to-yield-a-single-unique-result-samplesheetexcelquestion
Sheet: Sheet1

 | Table to which Run Factor needs to be returned |  |  |  |  |  | REFERENCED RUN FACTORS
 |  | Length | [NAME] | Returned Run Factor |  |  | Length | [NAME] | Run Factor
 | Item 1 | 15 | 25 | 0.027 |  |  | 15 | 20 | 0.023
 | Item 2 | 40 | 20 | 0.051 |  |  | 15 | 25 | 0.027
 | Item 3 | 20 | 20 | 0.027 |  |  | 15 | 30 | 0.035
 | Item 4 | 15 | 40 | 0.043 |  |  | 15 | 40 | 0.043
 | Item 5 | 30 | 30 | 0.064 |  |  | 20 | 20 | 0.027
 |  |  |  |  |  |  | 20 | 25 | 0.032
 |  |  |  |  |  |  | 20 | 30 | 0.041
 |  |  |  |  |  |  | 20 | 40 | 0.05
 |  |  |  |  |  |  | 25 | 20 | 0.035
 |  |  |  |  |  |  | 25 | 25 | 0.041
 |  |  |  |  |  |  | 25 | 30 | 0.053
 |  |  |  |  |  |  | 25 | 40 | 0.064
 |  |  |  |  |  |  | 30 | 20 | 0.043
 |  |  |  |  |  |  | 30 | 25 | 0.05
 |  |  |  |  |  |  | 30 | 30 | 0.064
 |  |  |  |  |  |  | 30 | 40 | 0.079
 |  |  |  |  |  |  | 40 | 20 | 0.051
 |  |  |  |  |  |  | 40 | 25 | 0.059
 |  |  |  |  |  |  | 40 | 30 | 0.076
 |  |  |  |  |  |  | 40 | 40 | 0.093
Spreadsheet: 821993d1679042610-how-to-creat-a-dynamic-array-filter-based-on-a-dynamic-array-filter-of-another-table-dynamic-array-on-dynamic-array-test
Sheet: Blad1

TABLE1
Code1 | code2 | ItemCode |  | FILTER_1
1 | a | aa
2 | b | bb |  | gg
3 | c | cc |  | hh
4 | d | dd |  | ii
5 | e | ee
6 | f | ff
7 | g | gg
8 | h | hh
9 | i | ii
[NAME] |  |  |  | FILTER_2
ItemCode | Description |  |  | ItemCode | Description
aa | line1 |  |  |  |  |  |  |  | [NAME]
aa | line2 |  |  |  |  |  |  | ff | [NAME]
aa | line3 |  |  |  |  |  |  | ff | lineff3
aa | line4 |  |  |  |  |  |  | ff | lineff4
aa | line5
aa | line6
aa | line7
ff | [NAME]
ff | [NAME]
ff | lineff3
ff | lineff4
ii | lineii1
ii | lineii2
ii | [NAME]
ii | [NAME]
ii | [NAME]
Spreadsheet: 738275d1624953405-transposing-data-book1
Sheet: Sheet3

 |  |  | AUDCLP Curncy | 515.673
 |  |  | AUDCZK Curncy | 18.1714
 |  |  | AUDDKK Curncy | 5.013
 |  |  | AUDHUF Curncy | 211.757
 |  |  | AUDILS Curncy | 2.8311
 |  |  | AUDJPY Curncy | 88.085
 |  |  | AUDKRW Curncy | 855.6085
 |  |  | AUDMXN Curncy | 12.6062
 |  |  | AUDNZD Curncy | 1.0615
 |  |  | AUDNOK Curncy | 6.47467
 |  |  | AUDPLN Curncy | 2.8803
 |  |  | AUDSEK Curncy | 6.1776
 |  |  | AUDCHF Curncy | 0.7307
 |  |  | AUDTRY Curncy | 2.1262
 |  |  | AUDGBP Curncy | 0.4952
 |  |  | AUDUSD Curncy | 0.7303
 |  |  | AUDEUR Curncy | 0.6726
Spreadsheet: 128506d1321016288-numerical-sorting-800428-numerical-sorting-brelu
Sheet: Rank MDW

member |  |  |  |  |  |  |  | MEMBERS SCORE CARDS (RANKED) |  |  |  |  |  |  |  |  |  |  |  | position
G | 13 | 10 | 13 | 9 | 15 | 15 | 13 | 13 | 12 | 12 | 15 | 14 | 15 | 12 | 15 | 9 | 10 | 0 | 0 | 1
I | 14 | 11 | 11 | 8 | 12 | 10 | 13 | 13 | 13 | 13 | 14 | 15 | 14 | 14 | 15 | 10 | 8 | 0 | 0 | 2
O | 12 | 10 | 15 | 11 | 13 | 12 | 12 | 10 | 10 | 10 | 10 | 12 | 13 | 14 | 15 | 12 | 15 | 0 | 0 | 3
R | 14 | 12 | 11 | 15 | 11 | 11 | 12 | 11 | 11 | 10 | 10 | 12 | 12 | 10 | 15 | 11 | 10 | 0 | 0 | 4
F | 13 | 10 | 12 | 9 | 11 | 14 | 12 | 12 | 15 | 9 | 14 | 11 | 13 | 9 | 12 | 11 | 9 | 0 | 0 | 5
B | 14 | 9 | 12 | 9 | 13 | 11 | 10 | 12 | 13 | 12 | 13 | 14 | 13 | 11 | 9 | 11 | 9 | 0 | 0 | 6
M | 12 | 10 | 12 | 10 | 11 | 12 | 11 | 8 | 10 | 11 | 11 | 14 | 12 | 10 | 14 | 11 | 11 | 0 | 0 | 7
H | 13 | 10 | 11 | 7 | 11 | 13 | 11 | 7 | 10 | 13 | 15 | 12 | 15 | 10 | 9 | 9 | 8 | 0 | 0 | 8
N | 12 | 8 | 12 | 7 | 11 | 8 | 13 | 6 | 10 | 11 | 12 | 15 | 13 | 9 | 14 | 11 | 12 | 0 | 0 | 8
J | 12 | 8 | 9 | 9 | 11 | 9 | 11 | 11 | 9 | 10 | 12 | 14 | 9 | 9 | 15 | 11 | 12 | 0 | 0 | 10
K | 12 | 10 | 10 | 8 | 11 | 9 | 9 | 8 | 10 | 15 | 13 | 14 | 12 | 11 | 10 | 10 | 8 | 0 | 0 | 11
P | 10 | 9 | 12 | 9 | 11 | 11 | 10 | 10 | 11 | 9 | 12 | 11 | 9 | 12 | 10 | 8 | 11 | 0 | 0 | 12
D | 13 | 8 | 7 | 7 | 10 | 11 | 9 | 7 | 9 | 11 | 11 | 15 | 10 | 10 | 12 | 15 | 8 | 0 | 0 | 13
Q | 12 | 9 | 10 | 8 | 11 | 15 | 12 | 9 | 10 | 10 | 11 | 11 | 9 | 8 | 8 | 8 | 11 | 0 | 0 | 14
C | 10 | 9 | 9 | 7 | 8 | 14 | 11 | 8 | 10 | 8 | 13 | 10 | 12 | 8 | 11 | 8 | 15 | 0 | 0 | 15
A | 13 | 9 | 8 | 6 | 9 | 9 | 10 | 11 | 11 | 9 | 10 | 8 | 10 | 9 | 12 | 9 | 9 | 0 | 0 | 16
E | 10 | 7 | 9 | 6 | 11 | 8 | 12 | 10 | 10 | 9 | 12 | 13 | 11 | 9 | 7 | 10 | 8 | 0 | 0 | 16
L | 10 | 7 | 9 | 4 | 8 | 10 | 9 | 7 | 8 | 9 | 9 | 15 | 8 | 8 | 13 | 12 | 8 | 0 | 0 | 18
Spreadsheet: 162634d1340018369-excel-formulas-seem-to-stop-working-at-a-certain-range-camp-sign-up-spreadsheet-test
Sheet: Water Week 2

 | Name | Age | Emergency Contact | Phone Number
1
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
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 135745d1326214474-help-with-copying-vlookup-formula-for-baseball-statistics-program-book1
Sheet: G1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BACK |  |  |  | SAVE
Back to Index
 |  | 2011-12-10 00:00:00 |  |  | (Date) |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10+ | R | H | E
 |  | Day/Night Game: | (Enter D or N) |  |  |  | D |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 3 | 5 | 0 | 1 | 0 |  |  |  |  | WP
 |  | Home/Away: | (Enter H or A) |  |  |  | H |  |  |  |  |  |  |  |  | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | LP
 |  | BATTING LINEUP | POS | AB | R | H | RBI | BB | K | 1B | 2B | 3B | HR | GS | SB | CS | HBP | IBB | FC | SF | SH | GDP | BA | OBP | SLG% | SB% | AB/HR | RPRO | TOB | SBA | TS | TB | BB/K | XBH
 |  | Bargesser, [NAME] |  | 6 | 2 | 3 | 1 | 1 | 2 | 1 | 2
 |  | Baxter, Clarence |  | 6 | 3 | 4 | 1 | 1 | 1 | 3 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  | [NAME], [NAME]
 |  | Withrow, [NAME]
 |  | Schwartz, Freddie
 |  |  |  | 5 | 2 | 3 | 1 | 4 | 1 | 2
Spreadsheet: 37146d1235080811-dependent-validation-task_codes-version-2-
Sheet: Sheet1

VS-001_Single_Camera_(HD)
 | VS-001A_Prepare_Shooting_Package | VS - Video Shoots
 | VS-001B_Shoot_Event |  | VS-001_Single_Camera_(HD)
 | VS-001C_Dump_Footage |  |  | VS-001A_Prepare_Shooting_Package
 |  |  |  | VS-001B_Shoot_Event
DA_001 Title Page |  |  |  | VS-001C_Dump_Footage
 | DA_001A Set up DVD |  | VS-002_Two_Camera_(HD)
 | DA_001B Burn DVD Master |  |  | VS-002A_Prepare_Shooting_Package
 | DA_001C Check DVD Master |  |  | VS-002B_Shoot_Event
 | DA_001D [NAME] |  |  | VS-002C_Dump_Footage
 | DA_001E Create DVD Label |  | VS-003_Multi_Camera_(HD)
 | DA_001F Create Discribe Job |  |  | VS-003A_Prepare_Shooting_Package
 |  |  |  | VS-003B_Shoot_Event
 |  |  |  | VS-003C_Dump_Footage
 |  |  | VS-004_Single_Camera_(SD)
 |  |  |  | VS-004A_Prepare_Shooting_Package
 |  |  |  | VS-004B_Shoot_Event
 |  |  |  | VS-004C_Capture_Footage
 |  |  | VS-005_Two_Camera_(SD)
 |  |  |  | VS-005A_Prepare_Shooting_Package
 |  |  |  | VS-005B_Shoot_Event
 |  |  |  | VS-005C_Capture_Footage
 |  |  | VS-006_Multi_Camera_(SD)
 |  |  |  | VS-006A_Prepare_Shooting_Package
 |  |  |  | VS-006B_Shoot_Event
 |  |  |  | VS-006C_Capture_Footage
 |  | PS - Photo Shoots
 |  |  | PS_001 Single Camera
 |  |  | PS_002 Two Camera
 |  |  | PS_003 Multi Camera
 |  | VE - Video Edits
 |  |  | VE_001 Edge Trim
 |  |  |  | VE_001A Edit Footage
 |  |  |  | VE_001B [NAME]
 |  |  |  | VE_001C Edit Audio
 |  |  |  | VE_001D Add Chapter Markers
 |  |  |  | VE_001E Compress Footage
 |  |  | VE_002 Multi-Clip
 |  |  | VE_003 Fast Edit
 |  |  | VE_004 Full Edit
 |  |  | VE_005 Match Audio
 |  | DA - Disc Authoring
 |  |  | DA_001 Title Page
 |  |  |  | DA_001A Set up DVD
 |  |  |  | DA_001B Burn DVD Master
 |  |  |  | DA_001C Check DVD Master
 |  |  |  | DA_001D [NAME]
 |  |  |  | DA_001E Create DVD Label
 |  |  |  | DA_001F Create Discribe Job
 |  |  | DA_002 Title Page + Menus
 |  |  | DA_003 Title Page (Motion)
 |  |  | DA_004 Title Page + Menus (Motion)
 |  | GD - Graphic Design
 |  |  | GD_001 Crop and Color
 |  |  | GD_002 Compositing
 |  |  | GD_003 DVD/CD Sleeve
 |  |  | GD_004 DVD/CD Label
 |  |  | GD_005 Print Layout
 |  | VD - video design
 |  | WD - web design
 |  | FD - flash design
 |  | SD - sound design
 |  | vc - video conversion
 |  | DD - disc duplication
 |  |  | DD_001 Small Run B&W
 |  |  |  | DD_001A [NAME]
 |  |  |  | DD_001B [NAME]
 |  |  | DD_002 Large Run B&W
 |  |  |  | DD_002A [NAME]
 |  |  |  | DD_002B Package Discs
 |  |  | DD_001 Small Run Color
 |  |  |  | DD_003A [NAME]
 |  |  |  | DD_003B Package Discs
 |  |  | DD_002 Large Run Color
 |  |  |  | DD_004A [NAME]
 |  |  |  | DD_004B [NAME]
 |  | wv - web video
 |  | ls - live support
 |  | ws - web support
 |  | sh - shipping & handling
 |  | ad - administration
 |  | ar - archiving
 |  | qc - quality control
 |  | os - online sales
 |  | ER - Equipment Rental
 |  | SR - Studio Rental
Spreadsheet: 674859d1588059470-extrapolate-a-list-of-names-extrapolate-list-of-names-ex-1
Sheet: Sheet1

Name | Dat of Completion | Status
[NAME] | 2020-01-01 00:00:00 | complete
[NAME] | 2020-01-02 00:00:00 | incomplete |  |  |  | Names of people who have an incomplete AND complete status to show below as written
[NAME] | 2020-01-03 00:00:00 | incomplete
[NAME] | 2020-01-04 00:00:00 | complete |  |  |  | [NAME]
[NAME] | 2020-01-05 00:00:00 | incomplete |  |  |  | [NAME] 6
[NAME] 6 | 2020-01-06 00:00:00 | complete |  |  |  | [NAME]
[NAME] | 2020-01-07 00:00:00 | incomplete |  |  |  | [NAME]
[NAME] | 2020-01-08 00:00:00 | complete
[NAME] | 2020-01-09 00:00:00 | incomplete
[NAME] | 2020-01-10 00:00:00 | complete
[NAME] | 2020-01-11 00:00:00 | complete
[NAME] | 2020-01-12 00:00:00 | incomplete
[NAME] | 2020-01-13 00:00:00 | complete
[NAME] | 2020-01-14 00:00:00 | complete
[NAME] | 2020-01-15 00:00:00 | incomplete
[NAME] 6 | 2020-01-16 00:00:00 | incomplete
[NAME] | 2020-01-17 00:00:00 | incomplete
[NAME] | 2020-01-18 00:00:00 | incomplete
[NAME] | 2020-01-19 00:00:00 | complete
[NAME] | 2020-01-20 00:00:00 | complete
Spreadsheet: 692349d1598287686-need-to-extract-data-and-skip-blanks-machine-shop-schedules_excel-forum
Sheet: Plating Cost Calculator

 |  |  |  |  | PURCHASE ORDER ENTRY (Do not populate gray cells) |  |  |  |  |  |  | (Eastern!T2="X",Eastern!C2,0) | IFERROR(INDEX(Eastern!$T$2:$T$100,SMALL(IF(ISTEXT(Eastern!$T$2:$T$100),ROW(Eastern!$T$1:$T$100),""),ROW(Eastern!C2))),"")
CNC / LASER ENTRY (Do not populate gray cells) |  |  |  |  | PO SUBTOTAL |  |  | Expedite: SAME DAY
 |  |  |  |  | PO WASTE FEE (5% of SUBTTL) |  |  | Expedite: NEXT DAY
P/N | L | W | REV | QTY | Total Dimensions | Cost per Part | Total QTY Cost
 | 8.423 | 6.762 | A1 | 4
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
www.atlaspm.xxx/toms-tutorials-for-excel/toms-tutorials-for-excel-listing-noncontiguous-data-without-blanks/
Spreadsheet: 888022d1738334101-duplicating-rows-on-a-new-sheet-using-helper-column-count-roster
Sheet: Training & Insurance

Last Name | First Name | Middle Initail | Counseling Date | Insurance Expiration | Insurance State | [NAME] | Liscense State | Registration Expiration Date | MSF Basic Date | MSF ARC Date
Ahlers | [NAME] | G
Wells | Adam | W
[NAME] | Aquashia | I
[NAME] | Jodi | A
[NAME] | Jodi | A
Carvalho | [NAME] | C
Connor | Jessica | E
Covell | [NAME] | A
Dabolt | Kyler | R
Dabolt | Kyler | R
Dabolt | Kyler | R
Dabolt | Kyler | R
[NAME] | Grady | D
Osborne | [NAME]
Rivas | [NAME] | R
[NAME] | Ilnur | R
Abounada | Suhype | I
Barton | [NAME] | A
[NAME] | [NAME] | C
[NAME] | [NAME] | C
[NAME] | Justin | A
Gray | [NAME] | L
[NAME] | [NAME] | E
[NAME] | Skyler | A
[NAME] | [NAME] | C
Webb | Mason | O
WIlson | [NAME] | A
Spreadsheet: 479925d1473675406-find-name-that-carries-the-shift-on-that-day-modulo-prova-2-
Sheet: Ottobre (2)

 |  | [NAME]
02/10 | Data
 | Turno Mattina | Turno Pomeriggio | Turno Notturno
 | 07.00 - 13.00 | 13.00 - 19.00 | 19.00 - 07.00
 | [NAME] dovrebbe contenere il resoconto giornaliero
 | Data
 | Turno Mattina | Turno Pomeriggio | Turno Notturno
 | 07.00 - 13.00 | 13.00 - 19.00 | 19.00 - 07.00
F2---> | Pietro | Pietro | Pietro
F2---> | Valerio | Valerio | Valerio
Spreadsheet: 41486d1239961204-cell-value-based-on-three-references-cells-test
Sheet: Output Data Sheet

 | 101 |  |  |  |  |  | 102
Ref: | 201 | 202 | 203 | 204 | 205 |  | 201 | 202 | 203 | 204 | 205
Date/Title
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: Disbursing

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
Spreadsheet: andy_zipper__759__10_23_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 270 | 22 | 24 | 112.7 | 122.9 | 20 | 2001-10-23 14:41:00
 | NG Z1 | 295 | 55 | 56 | 75.9 | 77.3 | 14.21 | 2001-10-23 14:41:00
 | NG F2 | 310 | 77 | 78.5 | 75.2 | 76.6 | 14.79 | 2001-10-23 14:41:00
 | NG G2 | 310 | 87 | 88 | 69.3 | 70.1 | 13.58 | 2001-10-23 14:41:00
 | NG H2 | 305 | 87 | 89 | 62.3 | 63.7 | 12.08 | 2001-10-23 14:41:00
 | NG J2 | 300 | 77.5 | 78.5 | 51.1 | 51.8 | 9.7 | 2001-10-23 14:41:00
 | NG K2 | 300 | 78.5 | 79 | 47.4 | 47.7 | 8.97 | 2001-10-23 14:41:00
 | NG M2 | 305 | 83 | 86 | 45.6 | 47.3 | 8.91 | 2001-10-23 14:41:00
 | NG N2 | 310 | 89 | 94 | 45.4 | 48 | 9.1 | 2001-10-23 14:41:00
 | NG Q2 | 315 | 96 | 101 | 45.7 | 48.1 | 9.29 | 2001-10-23 14:41:00
 | NG U2 | 315 | 102 | 106 | 46.2 | 48 | 9.33 | 2001-10-23 14:41:00
 | NG V2 | 320 | 105 | 112 | 44.9 | 48 | 9.34 | 2001-10-23 14:41:00
 | [NAME] |  |  |  |  |  | 10.12 | 2001-10-18 10:52:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 835698d1688734344-take-choosecols-sort-function-not-showing-output-in-a-particular-cell-book4
Sheet: Sheet1

File Name | Image Title | Score | Category | Salon Score | Closing Date | Judgement Date | Total Points |  | Rank | File Name | Title | Category | Total Points
1P3A5621 | Deep In Thought | 11 | Pictorial |  |  |  |  |  |  |  | Focused | Pictorial | 47
1P3A2370 | Returning To Den | 12 | Nature | 29 | 2022-11-12 00:00:00 | 2022-11-27 00:00:00 |  |  | 2 | 1P3A6097 | Reaching The Apex | Pictorial | 42
1P3A2093 | Watching You, Watching Me | 10 | Nature |  |  |  |  |  | 3 | 1P3A3622 | Watching For Danger | Nature | 42
1P3A0060 | All Eyes On Me | 9 | Nature |  |  |  |  |  | 4 | 1P3A2370 | Returning To Den | Nature | 41
1P3A6097 | Reaching The Apex | 13 | Pictorial | 29 |  |  |  |  | 5 | 1P3A7629 | Flower | Pictorial | 38
1P3A6212 | Focused | 13 | Pictorial | 34 | 2023-05-06 00:00:00 | 2023-05-15 00:00:00
1P3A8822 | A View From The Top | 11 | Nature
1P3A3622 | Watching For Danger | 13 | Nature | 29
1P3A7629 | Flower | 11 | Pictorial | 27
File Name | Image Title | Score | Category | Salon Score | Closing Date | Judgement Date | Total Points |  | Rank | File Name | Title | Category | Total Points
1P3A5621 | Deep In Thought | 11 | Pictorial |  |  |  |  |  |  |  | Focused | Pictorial | 47
1P3A2370 | Returning To Den | 12 | Nature | 29 | 2022-11-12 00:00:00 | 2022-11-27 00:00:00 |  |  | 2 | 1P3A6097 | Reaching The Apex | Pictorial | 42
1P3A2093 | Watching You, Watching Me | 10 | Nature |  |  |  |  |  | 3 | 1P3A3622 | Watching For Danger | Nature | 42
1P3A0060 | All Eyes On Me | 9 | Nature |  |  |  |  |  | 4 | 1P3A2370 | Returning To Den | Nature | 41
1P3A6097 | Reaching The Apex | 13 | Pictorial | 29
1P3A6212 | Focused | 13 | Pictorial | 34 | 2023-05-06 00:00:00 | 2023-05-15 00:00:00
1P3A8822 | A View From The Top | 11 | Nature
1P3A3622 | Watching For Danger | 13 | Nature | 29
1P3A7629 | Flower | 11 | Pictorial | 27
Spreadsheet: 854798d1704560431-to-calculate-remain-qty-using-correct-formulas-case11001
Sheet: Sheet1

 | 1
 |  |  |  |  |  |  |  |  | ignore
 |  |  |  | Helper column |  |  |  |  | expected result
 |  |  | Total Remain Supply |  |  |  | [NAME]
 |  |  | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 |  | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00
 | FACTORY | AA |  |  |  |  | 60 | 80 | 130 | 80 | 80
 |  | BB |  |  |  |  | 50 | 50 | 50 | 50 | 50
 |  | CC |  |  |  |  | 80 | 50 | 200 | 50 | 200
 |  |  | [NAME] |  |  |  | Delivery Schedule
 |  |  | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 |  | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00
 | CITY A | AA | 50
 |  | BB | 60
 |  | CC | 70
 | CITY B | AA | 80
 |  | BB | 90
 |  | CC | 100
 | CITY C | AA | 110
 |  | BB | 120
 |  | CC | 130
 | total Delivery | AA
 |  | BB
 |  | CC
 |  |  |  |  |  |  | without helper column in blue cells(ungroup the column) so in green cells I would like to have qty of delivery schedule plan based on
 |  |  |  |  |  |  | 1. qty of production schedule on that date
 |  |  |  |  |  |  | 2. remain qty each city each model after minus delivery of previous day start from 2 Jan
 |  |  |  |  |  |  | 2.1 if qty production below the remain, so prorate will apply for each model each city based on prod qty
 |  |  |  |  |  |  | 2.2 if qty production above the remain supply, qty will follow remain qty
Spreadsheet: 845407d1696938210-rearranging-text-in-one-table-based-on-another-table-data-cleansing1
Sheet: Data

Table Name - Cnvrt |  | Table Name - List
Find |  | List For Cleaning |  | Desired output |  | test
ArmChair |  | 3 legs,Chair |  | Chair, 3 legs
Cabinet |  | 40" black frame,Television |  | Television, 40" black frame |  | False
Carpet |  | ArmChair - Orthopedic with backrest |  | ArmChair, Orthopedic with backrest |  | False
Chair |  | Color Printer |  | Color Printer |  | False
Curtain |  | Colored Boxes |  | Colored Boxes |  | False
Lampshade |  | Curtain Synthetic, with rail |  | Curtain, Synthetic, with rail |  | False
Sofa |  | [NAME] |  | [NAME] |  | False
Stool |  | Metal leg/Lampshade |  | Lampshade, Metal leg |  | False
Table |  | Plate Set |  | Plate Set |  | False
Television |  | Rectangular in different sizes Carpet |  | Carpet, [NAME], different sizes |  | False
 |  | Self assembly,Stool |  | Stool, Self-Assembly |  | False
 |  | Sofa,Wood white color |  | Sofa, Wood, white color |  | False
 |  | standard old model,Cabinet |  | Cabinet, standard, old model |  | False
 |  | Table,[NAME], 3 meters long |  | Table, [NAME], 3 meters long |  | False
 |  | [NAME] |  | [NAME] |  | False
Spreadsheet: 698151d1601804395-formula-to-force-a-number-to-display-as-within-text-puzzle-and-conquest
Sheet: Sheet3

Row Labels | Sum of Total Att |  | Row Labels | Sum of Total Def |  | Sum of Star Rating | LVL 0
Elros | 20 |  | Eri | 1.755 |  | Row Labels | 2/10 | 26/35 | 3/10 | 38/75 | 5/10 | 5/20 | 53/75 | 6/10 | 6/20 | 7/20 | 7/35 | Grand Total
Florine | 13.987 |  | Sarbor | 1.715 |  | Agnimp |  |  |  | 2 |  |  |  |  |  |  |  | 2
Agnimp | 13.756 |  | Regina | 1.705 |  | Albertus |  |  |  |  |  |  | 2 |  |  |  |  | 2
Naax | 12 |  | Florine | 1.635 |  | Cerno |  | 3 |  |  |  |  |  |  |  |  |  | 3
Lamassu | 12 |  | Zues | 1.416 |  | Deedoe |  |  |  |  | 4 |  |  |  |  |  |  | 4
Albertus | 12 |  | Deedoe | 1.356 |  | Fuga |  |  | 4 |  |  |  |  |  |  |  |  | 4
Scarlet | 12 |  | Agnimp | 1.336 |  | Hart |  |  |  |  |  |  |  |  | 4 |  |  | 4
Eri | 12 |  | Lux | 1.27 |  | [NAME] |  |  |  |  |  | 3 |  |  |  |  |  | 3
Hart | 8.383000000000001 |  | Talon | 1.26 |  | Medusa |  |  |  |  |  |  |  |  |  | 5 |  | 5
Talon | 8 |  | [NAME] | 1.26 |  | Nilesh |  |  |  |  |  |  |  |  |  |  | 4 | 4
[NAME] | 8 |  | Grand Total | 14.708 |  | Ryska |  |  |  |  |  |  |  | 5 |  |  |  | 5
[NAME] | 8 |  |  |  |  | Sarbor | 5 |  |  |  |  |  |  |  |  |  |  | 5
Sakhir | 8 |  |  |  |  | Grand Total | 5 | 3 | 4 | 2 | 4 | 3 | 2 | 5 | 4 | 5 | 4 | 41
Grand Total | 148.126
Spreadsheet: benjamin_rogers__920__Gas Supply FP
Sheet: Sheet3

 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | 2003-07-01 00:00:00 | 2003-08-01 00:00:00 | 2003-09-01 00:00:00 | 2003-10-01 00:00:00 | 2003-11-01 00:00:00 | 2003-12-01 00:00:00 | 2004-01-01 00:00:00 | 2004-02-01 00:00:00 | 2004-03-01 00:00:00 | 2004-04-01 00:00:00 | 2004-05-01 00:00:00 | 2004-06-01 00:00:00 | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00
PGLC | 294153 | 171252 | 93967 | 61705 | 59412 | 63544 | 52429 | 71145 | 183421 | 294732 | 320950 | 323599 | 290092 | 155423 | 84916 | 57327 | 56227 | 59468 | 46838 | 58546 | 181810 | 288667 | 318309 | 320528 | 278511 | 137763 | 72858 | 52529 | 53057 | 55432 | 41285 | 58543
NS | 49111 | 39111 | 20548 | 13304 | 13585 | 12436 | 11365 | 19748 | 39111 | 49111 | 49111 | 49111 | 49111 | 36680 | 19131 | 12721 | 13054 | 12185 | 11051 | 18643 | 39111 | 49111 | 49111 | 49111 | 49111 | 34610 | 17890 | 12172 | 12952 | 11948 | 10760 | 18643
Spreadsheet: 86803d1286785230-subtotals-subtotal-1-
Sheet: Sheet1

clockno | name | HourlyRate | new rate | Diff | leaver? | StartDate | DaySequence | hours | store | worked
307794 |  | 4.83 | 4.92 | -0.08999999999999986 | No | 2010-09-12 00:00:00 | 0 | 4
307794 |  | 4.83 | 4.92 | -0.08999999999999986 | No | 2010-09-12 00:00:00 | 3 | 4
307794 |  | 4.83 | 4.92 | -0.08999999999999986 | No | 2010-09-12 00:00:00 | 6 | 4
307794 |  | 4.83 | 4.92 | -0.08999999999999986 | No | 2010-09-19 00:00:00 | 0 | 4 |  | HOLIDAY
307794 Total |  |  |  |  |  |  |  | 16
328006 |  | 5.15 | 5.25 | -0.09999999999999964 | No | 2010-09-26 00:00:00 | 0 | 4
328006 Total |  |  |  |  |  |  |  | 4
328007 |  | 5.15 | 5.25 | -0.09999999999999964 | No | 2010-09-26 00:00:00 | 1 | 4
328007 |  | 5.15 | 5.25 | -0.09999999999999964 | No | 2010-09-26 00:00:00 | 2 | 4
328007 |  | 5.15 | 5.25 | -0.09999999999999964 | No | 2010-09-26 00:00:00 | 4 | 4
 |  |  |  |  |  |  |  | 12
Spreadsheet: 694235d1599470009-consolodating-date-power-query-product-report-analysis
Sheet: Disc-Admin

DISCOUNTS
 |  |  | Helper