tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 551947d1513232734-to-insert-rows-of-data-between-other-rows-of-data-testexample
Sheet: After

The outcome is to insert the new rows between each occurrence of the original rows
11 | Blue | Delta | Orange
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
11 | Blue | Delta | Orange
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
11 | Blue | Delta | Orange
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
11 | Blue | Delta | Orange
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
Spreadsheet: 84201d1284192661-return-the-sum-of-a-range-by-list-sum_value_by_month
Sheet: Sheet1 (2)

 |  | Month |  | Vaue |  |  |  |  |  |  | Lookup Table
 |  | Jan |  | 10 |  |  |  |  |  |  | Jan
 |  | Feb |  | 10 |  |  |  |  |  |  | Feb
 |  | Feb |  | 20 |  |  |  |  |  |  | Mar
 |  | Mar |  | 56 |  |  |  |  |  |  | Apr
 |  | Apr |  | 37 |  |  |  |  |  |  | May
 |  | Mar |  | 20
 |  | May |  | 39
 |  | This equals the sum of all jan values | This equals the value of all feb values
Spreadsheet: 130973d1322674728-v-lookup-or-is-this-possible-through-counta-and-and-if-statements-copy-of-excel-help
Sheet: Sheet1

 | status | stage1 | stage 2 | stage 3 | stage4 | stage5 | stage6 | stage7 | stage 8 | [NAME] | Job on track
 | pre-planning | x | x
 | planning | x | x | x | x | x
 | survey | x | x | x | x | x | x
 | building | x | x | x | x | x | x | x | x
 | built | x | x | x | x | x | x | x | x | x
 |  |  | counta number | Track
Spreadsheet: f7a4b009-0457-4d52-b562-d91f3a69a7be
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7475 | 51336 | [NAME] | Sato | JPN | 0 | 00:12:42 | 00:01:00 | 01:13:14 | 00:01:13 | 00:48:24 | 1 | 02:16:34
7475 | 57789 | Masato | Kurokawa | JPN | 0 | 00:13:27 | 00:01:04 | 01:12:41 | 00:01:06 | 00:53:29 | 2 | [NAME]
7475 | 31968 | Yasuoki | Nakashima | JPN | 0 | [NAME] | 00:01:03 | 01:20:55 | 00:01:26 | 01:03:11 | 3 | 02:41:54
Spreadsheet: 881041d1728962064-cross-reference-data-in-2-columns-time-and-shift-fmneedshelp-book1
Sheet: Sheet1

Date of Injury | Employee Months of Service | Shift | Dept
2024-01-08 00:00:00 |  | 1 | Grocery
2023-08-14 00:00:00 |  | 2 | Meat
2023-11-27 00:00:00 |  | 2 | Produce
2023-08-09 00:00:00 |  | 2 | Deli
2023-04-03 00:00:00 |  | 2 | Produce
2024-01-15 00:00:00 |  | 2 | Produce
2023-11-16 00:00:00 |  | 2 | Meat
2021-03-08 00:00:00 |  | 1 | Grocery
2024-02-22 00:00:00 |  | 2 | Deli
2020-08-17 00:00:00 |  | 1 | Grocery
2024-03-11 00:00:00 |  | 2 | Produce
2024-01-08 00:00:00 |  | 1 | Grocery
2021-08-02 00:00:00 |  | 2 | Deli
2023-06-27 00:00:00 |  | 2 | Deli
2024-03-18 00:00:00 |  | 1 | Deli
2009-10-02 00:00:00 |  | 2 | Deli
2024-04-29 00:00:00 |  | 2 | Deli
2024-02-12 00:00:00 |  | 2 | Deli
2024-03-04 00:00:00 |  | 2 | Produce
1990-07-23 00:00:00 |  | 1 | Produce
2024-02-26 00:00:00 |  | 1 | Grocery
2024-03-18 00:00:00 |  | 1 | Grocery
2024-03-04 00:00:00 |  | 1 | Grocery
2024-05-28 00:00:00 |  | 2 | Deli
1999-08-04 00:00:00 |  | 3 | Freezer
2024-01-08 00:00:00 |  | 1 | Freezer
2024-06-03 00:00:00 |  | 2 | Produce
2023-06-27 00:00:00 |  | 2 | Deli
2024-07-15 00:00:00 |  | 2 | Deli
2024-08-05 00:00:00 |  | 2 | Deli
2019-03-25 00:00:00 |  | 1 | Grocery
1992-07-06 00:00:00 |  | 1 | Grocery
2024-08-04 00:00:00 |  | 1 | Grocery
2024-08-05 00:00:00 |  | 2 | Deli
2024-05-13 00:00:00 |  | 2 | Deli
Spreadsheet: 799697d1665217686-control-comma-separated-values-in-a-cell-against-a-list-of-single-values-in-a-column-excel_help
Sheet: control-2arrays

UNMATCH |  | case-unsensitive |  | =SUMPRODUCT((1*ISNA(MATCH(A4&A5:A1000,E5:E10&F5:F10,0))=1)*(A5:A1000<>"")*1)
 | ? | case-sensitive
grade | location |  |  | label | value
A | US |  |  | location | MX
A | DE |  |  | grade | A
B | MX |  |  | grade | B
C | US |  |  | location | US
D | DE |  |  | location | NL
a | MX |  |  | grade | C
F | US
A | DE
A | MX
B | FR
B | DE
D | MX
A | FR
B | US
Spreadsheet: 844300d1696012871-recipe-copy-example
Sheet: Sheet1

 | INGREDIENT: | [NAME]: | ANOTHER VALUE |  | Recipe
 | Sugar | 1 | 10
 | Glucose | 1 | 20
 | white chocolate |  | 30
 | milk | 1 | 40
 | Milk chocolate |  | 50
Spreadsheet: 14877093-8cea-4dca-bca7-9ba0728acfb3
Sheet: Sheet1

Table 2--Feed and residual use of wheat and coarse grains, 6/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Market year and quarter 1/ |  | Corn  (million metric tons) | Sorghum  (million metric tons) | Barley  (million metric tons) | Oats  (million metric tons) | Feed grains  (million metric tons) | Wheat  (million metric tons) | Energy feeds  (million metric tons) | Grain consuming animal units  (millions) | Energy feeds per grain consuming animal unit  (tons)
2010/11 | Q1 Sep-Nov | 52.56517625243693 | 2.278308027407873 | 0.03339892280853589 | 0.3692424370254856 | 55.24612563967882 | -1.710578956392525 | 53.5355466832863
 | [NAME] | 39.60915204511249 | 0.4116261200332755 | 0.1558688972531346 | 0.2912426710792143 | 40.46788973347812 | -0.07359084686626552 | 40.39429888661186
 | [NAME] | 18.19006432848806 | 0.3621446216176741 | 0.1719587303401672 | 0.2628795321828414 | 18.98704721262874 | -1.653072499503316 | 17.33397471312542
 | [NAME] | 11.37261625802519 | 0.09990284048694062 | 0.568935627059877 | 0.6743722960217218 | 12.71582702159373 | 5.565498303110466 | 18.28132532470419
 | MY Sep-Aug | 121.7370088840627 | 3.151981609545763 | 0.9301621774617146 | 1.597736936309263 | 127.4168896073794 | 2.12825600034836 | 129.5451456077278 | 92.94302041484113 | 1.393812521150238
2011/12 | Q1 Sep-Nov | 46.29057679729223 | 1.126669333790554 | -0.004724619458573851 | 0.3372977317653548 | 47.74981924338957 | -0.4589358175687261 | 47.29088342582084
 | [NAME] | 39.59248887110806 | 0.1480126751887625 | 0.2545415948856539 | 0.26114227291572 | 40.25618541409819 | 1.159654580240967 | 41.41583999433916
 | MY Sep-Aug | 115.5753684758657 | 1.905088491360424 | 0.9072357982456857 | 1.514665099050994 | 119.9023578645228 | 7.497965637646725 | 127.4003235021695 | 93.29754631822706 | 1.365527053279856
2012/13 | MY Sep-Aug | 138.4364303721908 | 2.286106189632508 | 0.9383486148645891 | 1.628 | 143.2888851766879 | 4.354487980252397 | 147.6433731569403 | 92.5889202575504 | 1.594611674336923
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Data run: 6/15/2012
Spreadsheet: 51932116-45da-457b-a0e9-3ab98e5e534e
Sheet: BP Training Montenegro

 |  | TRAINING BUDGET TEMPLATE | 1 Workshop
 |  | Training Title: | Business plan development
 |  | Country | Montenegro | Podgorica/Hotel Philia
 |  | Regional BP development Lead
 |  | PROJECT STAFF PARTICIPANTS
 | Ref. | ITEM Description |  | number man/days | daily cost | Total cost
 | 1 | Honorare/Personal
 | 1.2 | Training local coordination: x days X Euro
 | 1.3 | External Trainers:  days x Euro
 | 1.4 | Translation fees:  days x  Euro | 2 | 1 | 300
 | 1.5 | Facilitation fees :  days X  Euro
 | Sub-total 1
 | Ref. | ITEM Description |  | number days | daily cost | Total cost
 | 2 | Rent of facilities & insurence
 | 2.1 | Meeting room  and equipment | in-kind
 | 2.2 | Translation cabine (  days x euro) |  | 1 | 53 | 52
 | 2.3 | Translation cabine transport |  | 1 | 100 | 100
 | 2.4 | Technician/operator |  | 1 | 50 | 50
 | Sub-total 2
 | Ref. | ITEM Description |  |  |  | Total cost
 | 3 | Travel costs
 |  | Local travel cost for regional project coordinator |  | 1 | 300 | 300
 |  | Local travel cost for regional BP lead |  | 1 | 300 | 300
 | 3.1 | Local travel costs for participants (20 particpants) |  | 1 | 600 | 600
 | 3.2 | International travel costs lecturers: (Nº  lectures x [NAME] ) |  | 0 | 0 | 1100
 | 3.3 | Travel costs translater: Nº translater x Euro |  | 0 | 0 | 0
 | 3.4 | Local transport ( part x  Euro public transport) |  | 0 | 0 | 0
 | 3.5 | Local transport (Nº lecture + Nº translater x  Euro public transport) |  | 0 | 0 | 0
 | Sub-total 3
 | Ref. | ITEM Description | number participants |  |  | Total cost
 | 4 | Board and Lodging
 |  | Regional project coordinator |  | 2 | 80 | 160
 |  | Regional BP lead |  | 2 | 80 | 160
 | 4.1 | External Trainers: Nº person x Nº days x  Euro |  | 2 | 80 | 160
 | 4.2 | Participants: Nº participants x  days x  Euro | 20 | 1 | 80
 |  | Participants not sleeping in the hotel |  | 0 | 0 | 0
 | 4.3 | [NAME]:  days x  Euro
 | Sub-total 4
 | Ref. | ITEM Description |  | Number items | cost | Total cost
 | 7 | Printing
 | 7.1 | Documentation: Nº pax x  Euro
 | 7.2 | Certificates: Nº0 x  Euro
 | Sub-total 6
 | GRAND TOTAL
Spreadsheet: 153198d1335801212-auto-populate-comment-based-on-cell-values-big-project-need-a-guru-comments
Sheet: Orders

2012-04-30 00:00:00 | Company | [NAME] | Order#/s |  |  | PO# |  |  | Order Notes | Status | Customer PO# | Price
2012-01-12 00:00:00 | Customer #1 | [NAME] | 7891011 | 2061075 |  |  |  |  |  | Open | 123456 | 975
 |  |  | 12 | 345 | 346
Spreadsheet: 108214d1305264918-dates-book1
Sheet: Sheet1

 |  | Position | Hire date | probe date
employee | A | 1 | 2010-10-03 00:00:00 | 2011-03-02 00:00:00
employee | B | 1 | 2010-11-29 00:00:00 | 2011-01-02 00:00:00 |  | Position | 30-60days | 60-120days | 120-180days | 180+
employee | C | 2 | 2010-11-22 00:00:00 | 2011-02-21 00:00:00 |  | 1
employee | D | 4 | 2010-08-18 00:00:00 | 2010-12-03 00:00:00 |  | 2
employee | E | 3 | 2010-07-27 00:00:00 | 2011-10-14 00:00:00 |  | 3
employee | F | 3 | 2011-01-01 00:00:00 | 2011-04-07 00:00:00 |  | 4
employee | G | 4 | 2011-01-12 00:00:00 | 2011-03-07 00:00:00
employee | H | 4 | 2010-10-10 00:00:00 | 2011-02-01 00:00:00
employee | I | 2 | 2010-10-02 00:00:00 | 2011-01-02 00:00:00
employee | J | 1 | 2010-10-14 00:00:00 | 2011-01-02 00:00:00
employee | K | 1 | 2010-08-26 00:00:00 | 2010-10-19 00:00:00
employee | L | 1 | 2010-07-25 00:00:00 | 2010-09-24 00:00:00
employee | M | 2 | 2010-07-17 00:00:00 | 2010-09-11 00:00:00
employee | N | 2 | 2011-01-31 00:00:00 | 2011-03-30 00:00:00
employee | O | 1 | 2010-08-21 00:00:00 | 2010-11-23 00:00:00
employee | P | 1 | 2010-11-07 00:00:00 | 2011-03-14 00:00:00
employee | Q | 4 | 2010-08-14 00:00:00 | 2011-05-22 00:00:00
employee | R | 4 | 2010-08-02 00:00:00 | 2011-05-23 00:00:00
employee | S | 3 | 2010-08-04 00:00:00 | 2011-05-22 00:00:00
employee | T | 2 | 2010-12-07 00:00:00 | 2011-03-04 00:00:00
employee | U | 4 | 2010-07-05 00:00:00 | 2011-05-11 00:00:00
employee | V | 1 | 2011-01-11 00:00:00 | 2011-03-16 00:00:00
employee | W | 2 | 2010-08-11 00:00:00 | 2010-10-13 00:00:00
employee | X | 1 | 2010-10-14 00:00:00 | 2011-02-03 00:00:00
employee | Y | 1 | 2010-10-01 00:00:00 | 2011-02-03 00:00:00
employee | Z | 2 | 2010-09-04 00:00:00 | 2010-12-23 00:00:00
employee | AA | 1 | 2010-12-27 00:00:00 | 2011-04-03 00:00:00
employee | AB | 1 | 2010-09-04 00:00:00 | 2010-12-23 00:00:00
Spreadsheet: matthew_lenhart__26370__West Prices0606-01
Sheet: Power West Price Peak

 |  |  | 2001 |  | 2001 |  |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Q4-01 | Cal-01 | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0
COB | 0
NP15 | 0
ZP26 | 0
SP15 | 0
Palo Verde | 0
ROCKIES | 0
Price change |  |  | 2001 |  | 2001 |  |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Q4-01 | Cal-01 | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0
COB | 0
NP15 | 0
ZP26 | 0
SP15 | 0
Palo Verde | 0
ROCKIES | 0
 |  |  | 2001 |  | 2001 |  |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Q4-01 | Cal-01 | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0 | 0 | 0 | 0 | 105 | 185 | 235 | 150 | 132.3333333333333 | 153.1428571428571 | 108.6666666666667 | 52 | 104 | 50 | 78.66666666666667 | 49.08333333333334 | 42.1975 | 38.89253333333333 | 28.38426666666667 | 60.81333333333329 | 34.71759999999999 | 40.70193333333335
COB | 0 | 0 | 0 | 0 | 110 | 190 | 250 | 155 | 140.6666666666667 | 161 | 104.3333333333333 | 54 | 109.3333333333333 | 49.66666666666666 | 79.33333333333333 | 49.75 | 43.28083333333333 | 33.19416666666667 | 31.41583333333334 | 60.08333333333334 | 36.41583333333334 | 40.27729166666667
NP15 | 0 | 0 | 0 | 0 | 119 | 170 | 200 | 143 | 88 | 128 | 71 | 49 | 95 | 41 | 64 | 39.41666666666666 | 37.08333333333334 | 30.46 | 31.71333333333331 | 60.805 | 32.04666666666665 | 38.75625000000007
ZP26 | 0 | 0 | 0 | 0 | 115 | 170 | 195 | 135 | 81.66666666666667 | 122.8571428571429 | 78 | 64 | 110.3333333333333 | 37 | 72.33333333333333 | 39.25 | 36.75 | 30.25166666666667 | 31.63833333333331 | 59.3050722986247 | 31.07755922816562 | 38.06815788169763
SP15 | 0 | 0 | 0 | 0 | 115 | 170 | 195 | 135 | 82 | 123 | 54 | 54 | 100 | 40 | 62 | 43.08333333333334 | 39.91666666666666 | 31.92550449712469 | 35.49109582551636 | 63.77696911446699 | 31.78678512299792 | 40.74508864002653
Palo Verde | 0 | 0 | 0 | 0 | 140 | 220 | 260 | 175 | 85 | 150 | 54.66666666666666 | 53.66666666666666 | 121.6666666666667 | 40 | 67.5 | 39.58333333333334 | 36.59029672966567 | 36.15378443866696 | 33.68539242012115 | 52.87047697758679 | 36.84664353886649 | 39.88907434381035
ROCKIES | 0 | 0 | 0 | 0 | 140 | 220 | 260 | 175 | 85 | 150 | 54.66666666666666 | 53.66666666666666 | 121.6666666666667 | 40 | 67.5 | 39.58333333333334 | 36.59029672966567 | 36.15378443866696 | 33.68539242012115 | 52.87047697758679 | 36.84664353886649 | 39.88907434381035
Spreadsheet: 838524d1691091830-formula-that-capture-proportion-in-month-sample_benefit
Sheet: Values

HealthFirst
2023 Scorecard Realization
Property of Impact Advisors ©2023
Pay Period End Date | Value. | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00
2023-03-11 00:00:00 | 296389.148987563
2023-03-25 00:00:00 | 357574.6908805788
2023-04-08 00:00:00 | 434309.5884562506
2023-04-22 00:00:00 | 499630.3851183052
2023-05-06 00:00:00 | 451390.3556327077
2023-05-20 00:00:00 | 555372.5416376019
2023-06-03 00:00:00 | 497078.0948986675
2023-06-17 00:00:00 | 521576.6559827184
2023-07-01 00:00:00 | 544892.9764539846
2023-07-15 00:00:00 | 694229.204299228
2023-07-29 00:00:00 | 433334.7414073994
2023-08-12 00:00:00 | 533157.6399720978
2023-08-26 00:00:00 | 477194.9711027208
2023-09-09 00:00:00 | 500713.5897434097
2023-09-23 00:00:00 | 523097.2573958252
2023-10-07 00:00:00 | 666460.0361272589
Spreadsheet: 868871d1715603762-indirect-function-within-sumifs-to-sum-column-based-on-matching-criteria-test-document-2
Sheet: 12 weeks sales drop

Retail location | Store name | Handset (sold with) | model | 16.2024 | 17.2024 | 18.2024 | 19.2024
Retail location |  | Handset (sold with) | handset | TotalSales | TotalSales | TotalSales | TotalSales
 |  | 300025684 | Apples | 1
 |  | 300026129 | Bananas | 2
 |  | 300027564 | Strawberries | 3
Spreadsheet: 802316d1666788600-xlookup-with-multiple-search-criteria-and-multiple-return-values-range-lookup-aligw
Sheet: Sheet1

 |  |  | Material | Qty |  |  |  |  |  |  |  | Material | Qty | Material | Qty
 |  |  | Prod1 |  |  |  |  |  |  |  |  | Prod1 | 10 | Prod2 | 22
 |  |  | Prod2 |  |  |  |  |  |  |  |  | Prod3 | 30 | Prod4 | 40
 |  |  | Prod3
 |  |  | Prod4
Spreadsheet: 274160d1383037446-how-to-configure-vlookup-to-filter-first-one-or-two-key-words-flag-scenario-rambo3-
Sheet: AFTER

flag # | File [1] |  |  |  | File [2]
 | business name | flag rank |  |  | business name | flag rank
1 | amadeus corp. | 13 |  |  | [NAME] | 1
2 | eion inc. | 2 |  |  | eion incorporation | 2
3 | ryo ltd. | 21 |  |  | mega company | 3
4 | cat tech. | 4 |  |  | cat technologies | 4
5 | drew usa | 6 |  |  | carlton patent | 5
6 | drew ph. | 12 |  |  | drew u.s.a | 6
7 | [NAME]. | 10 |  |  | defiant mall | 7
8 | regulis co. | 11 |  |  | knolls corp, | 8
9 | red orange violet | 18 |  |  | red orange violet | 9
10 | iso pte. Inc. | 15 |  |  | crawford patent | 10
 |  |  |  |  | regulis corp | 11
 |  |  |  |  | drew ph. | 12
 |  |  |  |  | amadeus corporation | 13
 | **ranks has been placed based on the rank sheet |  |  |  | orange velocity | 14
 |  |  |  |  | iso patent incorporation | 15
 |  |  |  |  | arceus corp. | 16
 |  |  |  |  | bucket shoal inc. | 17
 |  |  |  |  | red orange violet | 18
 |  |  |  |  | sand filter corp. | 19
 |  |  |  |  | bayo incorporation | 20
 |  |  |  |  | ryo limited | 21
Spreadsheet: 866460d1713369063-looking-for-a-way-to-filter-a-text-variable-kansas-scheduler-v4-6-
Sheet: Weekly OJR View

 |  |  | K | USE CELL B5 TO EDIT DATE!!!  DO NOT EDIT ANY OTHER PART OF THIS SHEET!!!
 | 2024-04-15 00:00:00 | SchedTime |  | SchedTime |  | SchedTime |  | SchedTime |  | SchedTime |  | SchedTime |  | SchedTime
 | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital |  | All Digital
 | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric |  | All Fabric
 | Pieces to Ship |  | Pieces to Ship |  | Pieces to Ship |  | Pieces to Ship |  | Pieces to Ship |  | Pieces to Ship |  | Pieces to Ship
 | INV Pieces |  | INV Pieces |  | INV Pieces |  | INV Pieces |  | INV Pieces |  | INV Pieces |  | INV Pieces
 | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs | Order/Name | Stores/ Signs
 | CKGC 61110- ICE BOX TALL REPRINT | To Inv./ 186 |  |  | CKRE  2476- NB CKMW Welcome Sign & Coffee Panels | 3 /17 | CKRE  2477- NB RE CKMW ACM Panels 4702281 & 4702226 | 1/13 | CKCC 45484- NM MURALS 2723844 | To Inv./ 9
 | HHGJ   289 - E03108409 Macy's Son Grand Opening 2028 | 1 / 3 |  |  | GGPM 23497- New Low Priced Cigarettes April Rollout | 284/ 1872 | GIAB   281  - April Hang Tags - TO INV | To Inv./ 5300 | CKCC 45736- NM FFF MURAL 2720823 | To Inv./ 6
 |  |  |  |  | GIAB   289  - April New Dealer Kits - FROM INV | 14/ 126 LOW$ | GIAB   282  - Service WBBT, Weblink & 60 Day Shelf - TO INV | To Inv./ 343 | CKGC 61889- INSTALLATION NEEDS FOR- 9955 | 1/1
 |  |  |  |  | HHGJ   271 - E03082789 [NAME] | 216/ 6749 | GIAB   284  - Floor Mats - TO INV | To Inv./ 107 | CKGC 62256- RE ICE BOX FOR 1570 | 1/6
 |  |  |  |  | HHGJ   272 - E03081809 [NAME] | 216/ 12401 | GIAB   285  - 8in and 12in Circles - TO INV | To Inv./ 124 | CKWE 21113 (ships w/ CKWE 21105-) SWM - MAY/JUNE 2024 SMART VALUE TAGS | To Inv./ 1560
 |  |  |  |  | HHGJ   282 - E03094459 [NAME] April | 146/ 424 | GIAB   296  - NB - Weblink Banners | 1/1 | HHGJ   178 - E03059762 JD BOC Puma Fenty Launch | 17/ 37
 |  |  |  |  | HHGJ   306 (ships w/ HHGJ   271)    - E03082789 [NAME] x adidas Badge of Sports | 163/ 489 |  |  | HHGJ   275 - HR E03079504 JD-CHI New Balance 1906 AZ | 1/9
 |  |  |  |  | HHGJ   308 (ships w/ HHGJ   272)    - E03081809 [NAME] | 164/ 4908 |  |  | HHGJ   305 - E03086138 JD BOC Asics As | 157/ 303
 |  |  |  |  | KNST     3    - 4.25 Mother's Day | 137/ 698 |  |  | TOFA     2    - May June Cold Vault POP - | 374/ 30780
 |  |  |  |  |  |  |  |  | TOFA     3    - NB - May June Cold Vault POP - Store 300 | 283/ 23227
 |  |  |  |  |  |  |  |  | TOFA     4 (ships w/ TOFA     3)        - NB - May June Cold Vault POP - Store 200 | 29/ 2407
 |  |  |  |  |  |  |  |  | TOFA     5 (ships w/ TOFA     3)        - NB - May June Cold Vault POP - Store 100 | 91/ 2671
Spreadsheet: 710420d1608959519-countif-problem-subtracting-the-wrong-cell-because-two-cells-have-the-same-text-question
Sheet: Sheet1

Sold on | Fruit |  |  |  |  |  |  | Fruit | Number of fruit | Remaining fruit
2020-12-26 00:00:00 | Apple |  |  |  |  |  |  | Apple | 10
2020-12-27 00:00:00 | Apple |  |  |  |  |  |  | Apple | 10
2020-12-28 00:00:00 |  |  |  |  |  |  |  | Orange | 5
2020-12-29 00:00:00
2020-12-30 00:00:00
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: WTGmktg

 | /------------------------------------------  contract 22100  --------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -107 | -150 |  |  | -778 | -1001 |  | -2
2 | -84 | -150 |  |  | -696 | -1001 |  | -2
3 | -57 | -150 |  |  | -532 | -1001 |  | -2
4 | -51 | -150 |  |  | -477 | -1001 |  | -2
5 | -79 | -150 |  |  | -615 | -1001 |  | -2
6 | -85 | -150 |  |  | -674 | -1001 |  | -2
7 | -106 | -150 |  |  | -853 | -1001 |  | -2
8 | -131 | -150 |  |  | -1087 | -1001 |  | -2
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  | -40029.08
2001-12-08 00:00:00
CBS Volume
 |  |  | -5429