tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 781308d1653201490-create-a-number-sequence-for-each-change-in-a-column-in-excel-with-text-new-number-sequence-aligw
Sheet: Orders

Truck Number | Booking ID | Sample this row would be in Column A
 | [NAME] | Truck 01
 | [NAME] | Truck 02
 | [NAME] | Truck 02
 | [NAME] | Truck 02
 | [NAME] | Truck 02
 | MDB-22-1Z4Y-1PXB | Truck 03
 | MDB-22-1Z4Y-1PXB | Truck 03
 | MDB-22-1Z4Y-1PXB | Truck 03
 | [NAME] | Truck 04
 | MDB-22-1J4L-5G8L | Truck 05
 | MDB-22-1J4L-5G8L | Truck 05
 | [NAME] | Truck 06
 | [NAME] | Truck 06
 | [NAME] | Truck 07
 | [NAME] | Truck 07
 | [NAME] | Truck 07
 | MDB-22-YQB2-0S60 | Truck 08
 | MDB-22-YQB2-0S60 | Truck 08
 | MDB-22-Y022-RYM2 | Truck 09
 | MDB-22-Y022-RYM2 | Truck 09
 | MDB-22-Y022-RYM2 | Truck 09
 | MDB-22-Y022-RYM2 | Truck 09
 | MDB-22-Y022-RYM2 | Truck 09
 | MDB-22-Y022-RYM2 | Truck 09
 | MDB-22-Y022-RYM2 | Truck 09
 | [NAME] | Truck 10
 | [NAME] | Truck 10
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 | [NAME] | Truck 11
 |  | Truck 12
 | N/A | Truck 13
Spreadsheet: 6d52ae53-5132-4411-a222-4071c0d9b2f1
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2012-09-11 00:00:00 | State Senate Dist. 9 - Republican
 | Hawkins, r | Kenney, r | Sanborn, r | Nyquist, d | [NAME]
Bedford | 1197 | 241 | 1497 | 1
Dublin | 31 | 19 | 105
[NAME] | 43 | 29 | 144 |  | 1
[NAME] | 19 | 12 | 122 |  | 1
Hancock | 26 | 15 | 173
[NAME] | 54 | 51 | 316
Lyndeborough | 27 | 35 | 110
[NAME] | 67 | 54 | 197
New Boston | 101 | 66 | 436 | 20
Peterborough | 80 | 40 | 331 |  | 5
Richmond | 36 | 7 | 91
[NAME] | 2 | 10 | 31 |  | 1
Temple | 25 | 37 | 61
Troy | 30 | 18 | 118
Totals | 1738 | 634 | 3732 | 21 | 8
 | State Senate District 10 - Republican
 | Foote, r | Kelly, d | [NAME]
Alstead | 104 | 1
Chesterfield | 242 | 1
Gilsum | 65
Harrisville | 63
Hinsdale | 110
[NAME] | 72
[NAME] | 170 | 3 | 3
[NAME] 3 | 232 | 2
[NAME] | 216 | 8
[NAME] | 253
Marlborough | 129 |  | 3
[NAME] | 56 |  | 1
Roxbury | 16 |  | 1
[NAME] | 42 | 1 | 1
[NAME] | 64
Swanzey | 388 | 1 | 3
Walpole | 268 |  | 1
Westmoreland | 173 | 1
Winchester | 129 | 1 | 2
Totals | 2792 | 19 | 15
 | State Senate District 11 - Republican
 | Bradgon, r | Dwyer, r | [NAME]
Amherst | 942 | 235 | 1
Merrimack | 900 | 1272 | 4
Milford | 843 | 283 | 5
[NAME] | 280 | 64 | 2
Totals | 2965 | 1854 | 12
Spreadsheet: 135183d1325861429-excel-2007-formatting-cfor060112
Sheet: Self Assessment Shortcomings

 | Season | 2011-2012
No | Question / Match | 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
 | Pre-Match
1 | Approach the game calmly and fully prepared and not distracted in any way
2 | Check the pitch for and players  equipment for safety
 | Law Application
3 | Know when and how to start and stop game
4 | Stop the game when an expectation existed
5 | Differentiate between penal and technical offences
6 | Signal stoppages appropriately and correctly
7 | Recognise when to take action regarding [NAME], Cautions and Misconduct
8 | Deal with players who showed dissent appropriately
9 | [NAME] play in accordance with [NAME]
10 | Apply the correct method of restart following offside offences
 | Positioning/Fitness/Work Rate
11 | Face the play at all times
12 | Display a commitment and willingness to be involved in the game
13 | Demonstrate movement around the field of play when the game was in progress
14 | Make use of time when play had stopped by moving towards where the restart was  goining to take place
 | Alertness and Awareness
15 | Display concentration and awareness in open play
16 | Restart the game correctly and with a  reasonable degree of accuracy in my  positioning
17 | Manage injury situations appropriately
 | Communication
18 | Use signals at appropriate times
19 | Use signals so no one was in doubt of the  ownership of the next phase of play
20 | Use a whistle so that it could be heard
21 | Ensure that my whistle was effective
 | Teamwork
22 | Request Assistants and provide with basic  instructions for the match
23 | Make effective use of Club Assistants as per Competition Rules
24 | Generally acknowledge signals from Club Assistants
25 | Ensure I was seen to communicate and show respect for their support
 | Advantage
26 | Use the correct Arm and Voice signal when  playing advantage
 | Overall Match Control
27 | Display involvement at a level that met the needs of the game
28 | Leave the field of play feeling that I had demonstrated an empathy with the game
29 | Feel that I had exercised overall control within a correct application pf Law
30 | Make a positive contribution to an enjoyable game of football
X
Spreadsheet: 82789d1282818170-how-to-define-auto-color-rows-two-week-programme
Sheet: Sheet1 (2)

Activity  ID | Activity Description |  |  |  | Actual %Comp | Early       Start | Early    Finish | Late   Start | Late Finish | 2010
 |  |  |  |  |  |  |  |  |  | 2010-08-24 00:00:00 | 2010-08-25 00:00:00 | 2010-08-26 00:00:00 | 2010-08-27 00:00:00 | 2010-08-28 00:00:00 | 2010-08-29 00:00:00 | 2010-08-30 00:00:00 | 2010-08-31 00:00:00 | 2010-09-01 00:00:00 | 2010-09-02 00:00:00 | 2010-09-03 00:00:00 | 2010-09-04 00:00:00 | 2010-09-05 00:00:00 | 2010-09-06 00:00:00 | 14
001 | excavation Works |  |  |  |  | 2010-08-24 00:00:00 | 2010-08-30 00:00:00
002 | Concrete Works |  |  |  |  | 2010-08-25 00:00:00 | 2010-08-31 00:00:00
Spreadsheet: 466187d1466057213-if-and-large-query-if-and-lrg
Sheet: Sheet1

Number | % | Category | Large 1 | Large 2 | Results
4 | 0.34 | 84.49999999999999 |  |  | 4
2 | 0.2741935483870968 | 77.74 |  |  | 2
3 | 0.1164383561643836 | 56.61499999999999 |  |  | 1
1 | 0.1024096385542169 | 62.52999999999999
7 | 0.07391304347826087 | 69.28999999999999
5 | 0.0648854961832061 | 56.61499999999999
6 | 0.02048192771084337 | 56.61499999999999
8 | 0.02004716981132075 | 54.925
9 | 0.0005188146610919523 | 54.925
10 | 0.0005188146610919523 | 53.23499999999999
Spreadsheet: 735895d1623250840-hi-i-would-like-to-use-2-or-3-isnumber-search-functions-in-1-formula-test-isnumber-1-formula
Sheet: Sheet2

Volgnummer | Periode | Weeknr | Tdatum | Opleiding | [NAME] | Omschrijving | Van | Tot | Lokatie | E_Lokatie | Soort | Aantal deelnemers | Verdeling
Spreadsheet: 886978d1737052521-find-and-highlight-multiple-names-across-entire-sheet-example-etaf
Sheet: Sheet1

Team |  | PHL | SXM | MUC | LAX
BOB |  | BOB | TINA | JOE | HANNA
JOE |  | DAN | RICH | GLEN | [NAME]
[NAME] |  | LYNN | BRIT | [NAME] | BILL
TINA |  | [NAME] |  | SAM | BOB
 |  | ALEX |  | ALEX | TINA
 |  |  |  | LYNN | SVEN
 |  |  |  |  | [NAME]
 |  |  |  | [NAME] | TAYLOR
 |  |  |  |  | HANK
Spreadsheet: 66688d1267363007-transferring-data-from-multiple-sheets-into-one-spanish
Sheet: Sheet1

Knowledge Object No. | Knowledge Object Name | Knowledge Object Name in Spanish | Date Started | Date Ended
1 | [NAME] | aabbccdd | 2010-01-26 00:00:00 | 2010-01-28 00:00:00
2 | Last Samurai | bbccddee | 2010-01-27 00:00:00 | 2010-01-29 00:00:00
3 | Schindler's List | ccddeeff | 2010-01-30 00:00:00 | 2010-02-01 00:00:00
4 | Lord of Rings | hhjjiikk | 2010-02-02 00:00:00 | 2010-02-04 00:00:00
5 | Godfather | lleeddpp | 2010-02-04 00:00:00 | 2010-02-06 00:00:00
6 | Shawshank Redemption | cceeddhh | 2010-02-10 00:00:00 | 2010-02-12 00:00:00
7 | Good, Bad, Ugly | [NAME] | 2010-02-13 00:00:00 | 2010-02-15 00:00:00
8 | School of Rock | bbiippss | 2010-02-18 00:00:00 | 2010-02-20 00:00:00
9 | Ninja Assasin | bbssccdd | 2010-02-19 00:00:00 | 2010-02-21 00:00:00
10 | Drunken Master | wwqqzzpp | 2010-02-22 00:00:00 | 2010-02-24 00:00:00
Spreadsheet: 860803d1708801907-hourly-headcount-calculator-staffing
Sheet: Sheet1

Employee Name | Days Staffed | Shift Start | Shift End
Employee A | Mon-Fri | 8am | 5pm |  |  |  |  |  | Sun | Mon | Tue | Wed | Thur | Fri | Sat
Employee B | Sun-Wed | 8am | 7pm |  |  |  |  | 00:00:00
Employee C | Tue-Sat | 8am | 5pm |  |  |  |  | 01:00:00
Employee D | Wed-Sat | 9am | 8pm |  |  |  |  | 02:00:00
Employee E | Sun-Thur | 11am | 8pm |  |  |  |  | 03:00:00
 |  |  |  |  |  |  |  | 04:00:00
 |  |  |  |  |  |  |  | 05:00:00
 |  |  |  |  |  |  |  | 06:00:00
 |  |  |  |  |  |  |  | 07:00:00
 |  |  |  |  |  |  |  | 08:00:00
 |  |  |  |  |  |  |  | 09:00:00
 |  |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  | 16:00:00
 |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  | 23:00:00
Spreadsheet: 748649d1632259095-sum-multiple-by-on-multiple-criteria-examplesheet
Sheet: Sheet1

Trade Date |  |  |  | [NAME] | Purchase / Sale | Shipment Start | Shipment End | Months | Tons/Month | Price $ | FOB / DLVD | Location | NOTES
9/10/20021 |  |  |  | 1500 | P | 2021-10-01 00:00:00 | 2021-12-31 00:00:00 |  |  | 255 | FOB |  |  |  |  | Purchase | Sales
2021-09-02 00:00:00 |  |  |  | -325 | S | 2021-10-01 00:00:00 | 2021-12-31 00:00:00 |  |  | 273 | DLVD |  |  |  | October
2021-09-02 00:00:00 |  |  |  | -325 | S | 2021-10-01 00:00:00 | 2021-12-31 00:00:00 |  |  | 271 | DLVD |  |  |  | November
2021-09-09 00:00:00 |  |  |  | -350 | S | 2021-10-01 00:00:00 | 2021-12-31 00:00:00 |  |  | 270 | DLVD |  |  |  | December
2021-09-09 00:00:00 |  |  |  | -200 | S | 2021-10-01 00:00:00 | 2022-03-31 00:00:00 |  |  | 275 | DLVD |  |  |  | January
2021-09-09 00:00:00 |  |  |  | -450 | S | 2021-10-01 00:00:00 | 2022-03-31 00:00:00 |  |  | 275 | DLVD |  |  |  | Feburary
2021-09-09 00:00:00 |  |  |  | -750 | S | 2021-10-01 00:00:00 | 2022-03-31 00:00:00 |  |  | 275 | DLVD |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
Spreadsheet: 849297d1699821277-how-to-copy-formulas-across-the-row-when-criteria-are-in-static-cells-sample-report-purchase-and-supplier-payments-1-
Sheet: Payment forecast 

 |  |  | Purchase  Month |  |  |  |  |  |  |  | Credit Terms |  |  | Item | Payment Month
 |  |  | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 60 days | 30 days | Due Now |  | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 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 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 0.25 | 0.6 | 0.15 | Stock & Purchase - PT A |  |  |  |  |  | ???? | ??? | ????
 |  |  |  |  |  |  |  |  |  |  | 0.2 | 0.5 | 0.3 | Stock & Purchase - PT B
Spreadsheet: 488457d1478668429-conditional-sorting-formula-book1
Sheet: Sheet1

Date | Color | Unit | Number 1 | Number 2
2016-01-01 00:00:00 | Blue | CL | 0 | 15 |  |  | So I have date, color, unit and number 1 and I want number 2 according to the following pattern.
2016-01-01 00:00:00 | Blue | CM | 0 | 15 |  |  | For Same color and [NAME], I want the value in number1 of Unit "X" to be placed in the Number 2 of all units for same color and date.
2016-01-01 00:00:00 | Blue | X | 15 | 15
2016-01-01 00:00:00 | Green | CL | 0 | 23 |  |  | Number 1 value of all units except "X" willa lways be zero.
2016-01-01 00:00:00 | Green | CM | 0 | 23
2016-01-01 00:00:00 | Green | X | 23 | 23
2016-01-02 00:00:00 | Blue | CL | 0 | 21
2016-01-02 00:00:00 | Blue | CM | 0 | 21
2016-01-02 00:00:00 | Blue | X | 21 | 21
2016-01-02 00:00:00 | Red | CL | 0 | 29
2016-01-02 00:00:00 | Red | CL | 0 | 29
2016-01-02 00:00:00 | Red | CL | 0 | 29
2016-01-02 00:00:00 | Red | X | 29 | 29
Spreadsheet: 148917d1333616727-kindof-h-v-lookup-with-multiple-values-character-fun
Sheet: RESULT

 | Item 1 | Item 2 | Item 3
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: HR

HR | ok
 |  |  | Bonus
[NAME], [NAME] | VP |  |  | R
Clyatt, [NAME] | Admin Coordinator |  | 5000
[NAME]) [NAME] | Associate |  | 7500
Davies, [NAME] | Dir |  | 35000
Labbe, Anne | Analyst |  | 7500
Cashion, Tana | Associate |  | 15000
[NAME], [NAME] | Manager |  |  | R
Slone, [NAME] | Manager |  |  | R
Kearney, Julie | Manager |  | 25000
Curless, [NAME] | Specialist |  | 7500
Broussard, [NAME] | Specialist |  |  | R
Buckley, [NAME] | Sr. Spec |  | 15000
Calgary | Vacancy
Total | 12
Spreadsheet: 474819d1470922013-how-to-find-data-from-multiple-sheets-to-a-single-sheet-as-shown-in-sample-file-how-to-find-data
Sheet: ABB1STMF

Share Holding Percentage [as on Jun 30, 2015 (year ended)] | Sponsor/Director: | Govt: | Institute: | Foreign: | Public:
 | 20 | 0 | 45.23 | 0 | 34.77
Share Holding Percentage [as on Feb 29, 2016] | Sponsor/Director: | Govt: | Institute: | Foreign: | Public:
 | 20 | 0 | 60.96 | 0 | 19.04
Share Holding Percentage [as on May 31, 2016] | Sponsor/Director: | Govt: | Institute: | Foreign: | Public:
 | 20 | 0 | 63.08 | 0 | 16.92
Spreadsheet: 130887d1322645883-count-example1
Sheet: Sheet1

 | 1 | vz5 | 1 | arezina/luka 1 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | arezina/[NAME] 2 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | ceca/delija 1 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | ceca/delija 2 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 | 1 | vz5 | 5 | arezina/luka 1 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | arezina/[NAME] 2 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | ceca/delija 1 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | ceca/delija 2 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 | 2 | vz5 | 6 | arezina/luka 1 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | arezina/[NAME] 2 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | ceca/delija 1 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | ceca/delija 2 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 | - | [NAME] | 6 | arezina/luka 1 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | arezina/[NAME] 2 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | ceca/delija 1 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
 |  |  |  | ceca/delija 2 | ok | 2011-11-29 00:00:00 | ok | 2011-11-30 00:00:00
Spreadsheet: 50281d1249652323-lookup-and-index-sample
Sheet: Appraisal Fees

 | DATE | NAME | LOAN # | Const. | CR Date | CR Amt |  | DR Date | DR Amt | Check # |  | Appraiser Name or Comment | Invoice #
 |  | a | 1
 |  | b | 2
 |  | c | 3
 |  | d | 4 | Y
 |  | e | 5
 |  | f | 6
 |  | g | 7 | Y
 |  | h | 8
Spreadsheet: 47719d1246895295-excel-2007-find-highest-value-from-several-lists-690310_trendkill
Sheet: PT

Row Labels | Average of Value
[NAME] | 1
Adam | 2.5
[NAME] | 3
Niklas | 3
[NAME] | 4
[NAME] | 4
[NAME] | 4
[NAME] | 5
Anna | 5.666666666666667
[NAME] | 6
Kerry | 6.5
[NAME] | 6.5
Anders | 7
[NAME] | 7.5
Julie | 12
Spreadsheet: 844550d1696336893-total-add-with-text-test-108-aligw
Sheet: Sheet3

Date | Milk | [NAME] | Tea Power | Sugar | Biscuts | Water
2023-09-01 00:00:00 | 11 L | 3 PKT | 2 PKT | 2 KG
2023-09-02 00:00:00 | NIL | NIL | NIL | NIL
2023-09-03 00:00:00 | NIL | NIL | NIL | NIL
2023-09-04 00:00:00 | 9 L | 3 PKT | 2 PKT | NIL
2023-09-05 00:00:00 | 10 L | 3 PKT | 2 PKT | 2 KG
2023-09-06 00:00:00 | 6 L | 2 PKT | 1 PKT | NIL
2023-09-07 00:00:00 | 8 L | 3 PKT | 2 PKT | NIL
Spreadsheet: larry_campbell__21410__2002 ETS OM 03 Budget
Sheet: North - James Fleak

NORTH AREA TEAM
[NAME]
 |  |  |  | 52505500 |  |  |  | 52508000 |  |  | 52509000
Company | State | Facility | Status | Title V Fee | Other Permit Fee | EIQ Fee | Testing | Title V Prep/Renewal | [NAME]. | Other Permit Prep/Renewal | Environmental Expense
0179 | NE | BEATRICE COMPRESSOR STATION | Active
 | KS | ALBERT COMPRESSOR STATION | Active
 | KS | BURDETT | Active
 | KS | BUSHTON LIQUIDS | Sold
 | KS | BUSHTON COMPRESSOR STATION | Active
 | KS | CLIFTON COMPRESSOR STATION | Active
 | KS | CUNNINGHAM UNDERGROUND STORAGE | Active
 | KS | CUNNINGHAM LIQUIDS | Active
 | KS | FOWLER COMPRESSOR STATION | Active
 | KS | KALVESTA COMPRESSOR STATION | Active
 | KS | LYONS UNDERGROUND STORAGE | Active
 | KS | MACKSVILLE COMPRESSOR STATION | Active
 | KS | MULLINVILLE COMPRESSOR STATION | Active |  |  | 45000 |  |  | 1000
 | KS | TESCOTT COMPRESSOR STATION TS | Active |  |  |  | 10000 |  | 500
 | KS | EDWARDS COUNTY #3 | Inactive
 | KS | [NAME] | Active
 | KS | CLARK COUNTY #1 CS | Active |  |  | 1700 |  |  | 500
 | KS | CLARK COUNTY #2 CS | Active |  |  | 2600 |  |  | 500
Spreadsheet: 876348d1723037236-check-different-values-over-other-worksheets-crosscheck
Sheet: Deutschland

Supplier no | Item no | Old Purchase price | Currency | NEW Price | NEW supplier item no | unit price incl 2% discount
LT6898 | 5200 | 0.94 | EUR | 0.94 | 1408560 | 0.93
LT6898 | 5201 | 1 | EUR | 1 | 1408561 | 0.98
LT6898 | 5202 | 1.03 | EUR | 1.03 | 1408568 | 1.01
LT6898 | 5203 | 1.09 | EUR | 1.08 | 1408562 | 1.06
LT6898 | 5204 | 1.14 | EUR | 1.22 | 1408572 | 1.12
LT6898 | 5205 | 1.15 | EUR | 1.15 | 1408563 | 1.13
LT6898 | 5206 | 1.21 | EUR | 1.29 | 1408570 | 1.19
LT6898 | 5207 | 1.43 | EUR | 1.43 | 1408564 | 1.41
LT6898 | 5208 | 1.56 | EUR | 1.66 | 1408571 | 1.52
Spreadsheet: 124970d1318777428-excel-2007-how-to-shuffle-list-of-words-in-a-column-example
Sheet: Sheet1

[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Kermit Pavon
[NAME]
[NAME]
[NAME]
[NAME]
Vernice Oshinsky
[NAME]
Illa Maclaughlin
[NAME]
[NAME]
[NAME]
Matilda Depetris
Byron Fishback
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Yesenia Jabour
[NAME]
[NAME]
[NAME]
Shirely Croman
Hector [NAME]
[NAME]
Sal Livernoche
[NAME]
[NAME]
[NAME]
[NAME]
Mitchell Zuniga
[NAME]
[NAME]
[NAME]
[NAME]
Shane Kelman
[NAME]
[NAME]
Temple Kerney
[NAME]
[NAME]
[NAME]
Jazmine Sohre
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Burl Cosgriff
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Ashley Harbor
[NAME]
Jonathon Riedlinger
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Riley Cohoe
Hae Waldrope
[NAME]
[NAME]
[NAME]
[NAME]
Huey Russo
[NAME]
[NAME]
Kacy Rezentes
[NAME]
[NAME]
[NAME]
Spreadsheet: 93586d1293147888-pulling-data-from-matrixes-on-other-sheets-using-a-drop-down-menu-model
Sheet: Calculator

Transactions | Locality | Age of Wine in Year Sold | Year [NAME] | Number of Bottles | Total Sales Price
[NAME] | California | 19 | 2005 | 2 |  | <-- [Should be 400x2=800]
[NAME] | New York | 14 | 2007 | 4 |  | <-- [Should be 500x4=2000]
[NAME] | New York | 2 | 2004 | 8 |  | <-- [Should be 225x8=1800]
[NAME] | California | 29 | 2010 | 7 |  | <-- [Should be 600x7=4200]
Spreadsheet: 696404d1600795101-dynamic-month-ytd-formula-exampledynamicdates-etaf
Sheet: Data

Month | Term | Product Tier | State | 2020 Values
2020-01-01 00:00:00 | New | AUTO | CA | -250
2020-01-01 00:00:00 | New | AUTO | CA | 0
2020-01-01 00:00:00 | New | AUTO | CA | 90
2020-01-01 00:00:00 | New | AUTO | CA | 344
2020-02-01 00:00:00 | New | AUTO | CA | -1380
2020-01-01 00:00:00 | New | AUTO | CA | 0
2020-03-01 00:00:00 | New | AUTO | CA | 436
2020-01-01 00:00:00 | New | AUTO | CA | 3294
2020-04-01 00:00:00 | Renewal | AUTO | CA | -135
2020-01-01 00:00:00 | Renewal | AUTO | CA | 0
2020-01-01 00:00:00 | Renewal | AUTO | CA | 52
2020-01-01 00:00:00 | Renewal | AUTO | CA | 314
2020-01-01 00:00:00 | Renewal | AUTO | CA | -1223
Spreadsheet: 63264d1264175804-if-formula-for-duplicate-data-problem4
Sheet: Stock

21.01.2010                                                                                                                                   Dynamic List Display                                                                                                                                           1
21.01.2010 |  |  | Stock Usage Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Stock Usage Report
 |  | Month | Plnt | Plant Description | SLoc | SLoc Description | Material Number | Material Description | ALCIB Mat# | ALCIB Var# | Mat Group | Opening Stock | Receipt Qty | Issued Qty | Closing Stock | MtrSq | AUn | Open Stk (m2) | Receipts (m2) | Issued (m2) | [NAME] (m2) | Value of valuated stock
FOP10.0 CL G 3210x2250 LS 11 | 2001435 | 12.2009 | 9062 | [NAME] | 20 | Raw Materials | 2001435 | FOP10.0 CL G 3210x2250 LS 11 | 100010 | 561 | 409 | 31 | 154 | 159 | 26 | 7.22 | M2 | 223.82 | 1111.88 | 1147.98 | 187.72 | 984.66
Spreadsheet: 754316d1636107992-applying-countif-formula-when-counting-values-from-multiple-worksheets-countif-example
Sheet: Dental

Name | Staff ID |  |  | Staff type | Employed as/student type | Job description
Name 1 | ID 1 |  |  | Academic | Teaching & Research | Associate Professor
Name 2 | ID 2 |  |  | Non-academic | Adjunct | Clinical Senior Lecturer
Name 3 | ID 3 |  |  | Non-academic | Adjunct | Clinical Associate Professor
Name 4 | ID 4 |  |  | Non-academic | Adjunct | Clinical Senior Lecturer
Name 5 | ID 5 |  |  | Non-academic | Adjunct | Clinical Professor
Name 6 | ID 6 |  |  | Non-academic | Adjunct | Clinical Senior Lecturer
Name 7 | ID 7 |  |  | Non-academic | Staff | Dental Specialist
Name 8 | ID 8 |  |  | Academic | Teaching & Research | Senior Lecturer
Name 9 | ID 9 |  |  | Academic | Teaching | Clinical Dental Academic
Name 10 | ID 10 |  |  | Academic | Teaching & Research | Senior Lecturer
Name 11 | ID 11 |  |  | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 12 | ID 12 |  |  | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 13 | ID 13 |  |  | Academic | Teaching & Research | Head of Division
Name 14 | ID 14 |  |  | Non-academic | Adjunct | Clinical Senior Lecturer
Name 15 | ID 15 |  |  | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 16 | ID 16 |  |  | Academic | Teaching & Research | Senior Lecturer
Name 17 | ID 17 |  |  | Academic | Teaching & Research | Senior Lecturer
Name 18 | ID 18 |  |  | Academic | Teaching & Research | Senior Lecturer
Name 19 | ID 19 |  |  | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 20 | ID 20 |  |  | Non-academic | Adjunct | Clinical Senior Lecturer
Name 21 | ID 21 |  |  | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 22 | ID 22 |  |  | Academic | Teaching & Research | Head of Division
Name 23 | ID 23 |  |  | Academic | Teaching & Research | Senior Lecturer
Name 24 | ID 24 |  |  | Non-academic | Adjunct | Adjunct Senior Lecturer
Name 25 | ID 25 |  |  | Non-academic | Adjunct | Clinical Associate Professor
Name 26 | ID 26 |  |  | Non-academic | Adjunct | Adjunct Senior Lecturer
Spreadsheet: 704551d1605620502-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects-web-post
Sheet: Won

EQUALS FORMULA | Site [NAME] | Date (Estimate Complete) | Start  Date | Notes | SN# or PO# or  WBS# | SO# (ZM02, ZM03) OR MHPS Standard Order |  |  |  |  |  |  |  |  | Kickoff