tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58593d1258830599-date-formula-in-colour-on-2nd-worksheet-goss-training-matrix-test
Sheet: Goss Full List

Todays date: | 2009-11-20 00:00:00 | Training Matrix
 |  | FLT - Couterbalance | FLT - Reach | FLT - Narrow Aisle | PASMA Scaffolding Training | ISOH Managing Safely | [NAME] Training | Health and Safety Reps Course | Control of Contractors | DSE Assessor Training | NEBOSH General Certificate | 1st Aid Course | Safety in Machine Design | Management of Health and Safety | City and Guilds Machinery Safety | Overhead Pendant Crane Lifting/Slinging | [NAME] | CDM Awareness Course | Manual Handling Awareness Course | Risk Assessment Awareness Course | Accident Investigation Awareness Course | Introduction to Health and Safety at Work | NVQ2 in Plant Operations
 |  | 3 Yrly | 3 Yrly | 3 Yrly | 5 Yrly | 3 Yrly | Yrly | Yrly | Yrly | Yrly | . | 3 Yrly | . | Yrly | . | 3 Yrly | Yrly | . | Yrly | Yrly | Yrly | Yrly | .
Installations | 1 |  |  |  |  | 2003-07-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-07 00:00:00 | 2009-07-07 00:00:00 | 2009-07-07 00:00:00 | 2009-07-07 00:00:00
 | 2 |  |  |  |  | 2006-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-08 00:00:00 | 2009-09-08 00:00:00 | 2009-09-08 00:00:00 | 2009-09-08 00:00:00
 | 3 |  |  |  |  | 2006-02-02 00:00:00
 | 4 |  |  |  |  | 2003-06-06 00:00:00
 | 5 |  |  |  |  | 2006-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00
Spreadsheet: 770414d1646056803-sorting-multiple-columns-by-matching-values-in-rows-sample-workbook
Sheet: Sheet1

Name | ID | 2020 Sales | 2020 Units | 2021 Sales | 2021 Units | [NAME] | Units Difference
 | 8910 | 300 | 6 | 100 | 2 | -200 | -4
Julie | 1599 | 0 | 0 | 1000 | 20 | 1000 | 20
[NAME] | 1011 | 150 | 3 | 850 | 17 | 700 | 14
Mark | 1234 | 100 | 2 | 600 | 12 | 500 | 10
[NAME] | 9999 | 50 | 1 | 0 | 0 | -50 | -1
[NAME] | 2044 | 900 | 18 | 200 | 4 | -700 | -14
[NAME] | 1555 | 400 | 8 | 350 | 7 | -50 | -1
[NAME] | 5678 | 700 | 14 | 750 | 15 | 50 | 1
Spreadsheet: 843068d1695038728-index-match-by-worksheet-name-test-2
Sheet: 1

Global Filters in a Helper Column
1st Global Filter by Business Product (Asset Management, Trading, Mortgage)
2nd Global Filter by Business Sub Product (Residential Mortgage, [NAME], Private Client)-> Unique Identifier - 1, 2, 3-> these identifiers also are the sheet names
 |  |  |  |  |  | $ | $ | $ | $ | $ | $ | $
 | Country | State | City | Business Code | Business Center | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Residential
Commercial
Spreadsheet: phillip_m_love__30126__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 5/10/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
[NAME] | V89956.1 V89958.1 V89960.1 V89964.1 V89965.1 | F | C3GC | Brant Reves
Gulf Gas Utilities | V90219.1 | P | NG | [NAME]
Highland Energy Company | V90317.1 | P | NG | [NAME]
Kennedy Oil | V42434.A | F | NG | [NAME]
Nabisco, Inc. | V89067.3/4/5/6/7/8 | F/P | NG | [NAME]
New Counterparty | V90800.1/2/3/4/5/6/7/8/9/A/B/C/D/E/F | F/P | SHRC | [NAME]
New Counterparty | V90890.1/2 | F | HO/WTI | [NAME]
New Counterparty | V90976.1/2 | F/P | SHRC | [NAME]
North Texas Gas Partners, Ltd. | V90415.1 V90429.1 V90452.1 | F | NG | [NAME]
Suemaur Exploration & Production | V87304.1 | P | NG | [NAME]
Texican Natural Gas Company | V89373.1/4/6 | P | NG | [NAME]
Virginia Electric and Power Co | V90632.1 | F | 61NY | [NAME]
Westport Petroleum, Inc. | V90960.1/2 | F | KERO/HO | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Coral Energy Resources, LP | V88438.1 | F | NG | Coral Energy Holding, LP
Deutsche Bank SA | V88627.1 | F | NG | Deutsche Bank AG
Duke Energy Marketing Limited Partner.. | V90522.1/2 | F | NG | Duke Energy Trading and Marketing
Pioneer Resources Producing L.L.C. | V90781.1/2/3/4 | F | WTI | Pioneer Natural Resources USA, Inc.
Spreadsheet: 727979d1618237902-formula-to-bring-back-value-based-on-scoring-value-euro-2020-master
Sheet: Fixtures & Points

Date | Time | Team1 | Actual Score | [NAME]'s score predictions | Points
Friday 11th June | 20:00:00 | Turkey v Italy | 3 - 1 | 3 - 0
Saturday 12th June | 14:00:00 | Wales v Switzerland | 2 - 1 | 2 - 1
Saturday 12th June | 17:00:00 | Denmark v Finland | 1 - 0 | 4 - 3
Saturday 12th June | 20:00:00 | Belgium v Russia | 0 - 0 | 2 - 0
Sunday 13th June | 14:00:00 | England v Croatia
Sunday 13th June | 17:00:00 | [NAME]
Sunday 13th June | 20:00:00 | Netherlands v Ukraine
Monday 14th June | 14:00:00 | Scotland v Czech Republic
Monday 14th June | 17:00:00 | Poland v Slovakia
Monday 14th June | 20:00:00 | Spain v Sweden
Tuesday 15th June | 17:00:00 | Hungary v Portugal
Tuesday 15th June | 20:00:00 | France v Germany
Wednesday 16th June | 14:00:00 | Finland v Russia
Wednesday 16th June | 17:00:00 | Turkey v Wales
Wednesday 16th June | 20:00:00 | Italy v Switzerland
Thursday 17th June | 14:00:00 | Ukraine v North Macedonia
Thursday 17th June | 17:00:00 | Denmark v Belgium
Thursday 17th June | 20:00:00 | Netherlands v Austria
Friday 18th June | 14:00:00 | Sweden v Slovakia
Friday 18th June | 17:00:00 | Croatia v Czech Republic
Friday 18th June | 20:00:00 | England v Scotland
Saturday 19th June | 14:00:00 | Hungary v France
Saturday 19th June | 17:00:00 | Portugal v Germany
Saturday 19th June | 20:00:00 | Spain v Poland
Sunday 20th June | 17:00:00 | Italy v Wales
Sunday 20th June | 17:00:00 | Switzerland v Turkey
Monday 21st June | 17:00:00 | Ukraine v Austria
Monday 21st June | 17:00:00 | North Macedonia v Netherlands
Monday 21st June | 20:00:00 | Finland v Belgium
Monday 21st June | 20:00:00 | Russia v Denmark
Tuesday 22nd June | 20:00:00 | Czech Republic v England
Tuesday 22nd June | 20:00:00 | Croatia v Scotland
Wednesday 23rd June | 17:00:00 | Sweden v Poland
Wednesday 23rd June | 17:00:00 | Slovakia v Spain
Wednesday 23rd June | 20:00:00 | Germany v Hungary
Wednesday 23rd June | 20:00:00 | Portugal v France
Spreadsheet: darrell_schoolcraft__7414__imball0201
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 5471 | 5741 | 1041 | 1125 | 1062 | 872 | 1490 | 1123
2 | 5369 | 5741 | 815 | 1125 | 1031 | 872 | 1504 | 1123
3 | 5302 | 5741 | 762 | 1125 | 986 | 872 | 1644 | 1123
4 | 3429 | 5741 | 400 | 1125 | 953 | 872 | 1516 | 1123
5 | 5207 | 5741 |  | 1125 | 927 | 872 | 1465 | 1123
6 | 5669 | 5741 | 358 | 1125 | 921 | 872 | 1438 | 1123
7 | 6151 | 5741 |  | 1125 | 821 | 872 | 1413 | 1123
8 | 6148 | 5741 | 678 | 1125 | 1002 | 872 | 1398 | 1123
9 | 5873 | 5741 | 803 | 1125 | 979 | 872 | 1695 | 1123
10 | 5548 | 5741 | 1069 | 1124 | 985 | 872 | 1531 | 1123
11 | 5525 | 5741 | 1322 | 125 | 994 | 872 | 1481 | 1123
12 | 5676 | 5741 | 1071 | 125 | 969 | 872 | 1439 | 1123
13 | 5786 | 5741 | 746 | 125 | 983 | 872 | 1427 | 1123
14 | 6107 | 5741 | 962 | 125 | 617 | 872 | 1418 | 1123
15 | 6068 | 5741 | 777 | 125 | 811 | 872 | 1663 | 1123
16 | 6099 | 5741 | 484 | 95 | 1066 | 662 | 1472 | 1123
17 | 5842 | 4241 | 584 | 125 | 1015 | 872 | 1444 | 1123
18 | 5631 | 4241 | 401 | 125 | 1000 | 872 | 1409 | 1123
19 | 5880 | 4241 | 494 | 125 | 985 | 872 | 1397 | 1123
20 | 5162 | 4241 | 540 | 125 | 986 | 872 | 1373 | 1123
21 | 3353 | 4241 | 424 | 125 | 946 | 872 | 1650 | 1123
22 | 6538 | 4241 | 331 | 125 | 900 | 872 | 1503 | 1123
23 | 3258 | 4238 | 225 | 125 | 995 | 872 | 1352 | 1123
24 | 6451 | 4241 | 372 | 125 | 978 | 872 | 1509 | 1123 |  |  | 377
25 | 6351 | 4241 | 286 | 125 | 952 | 872 | 1429 | 1123 |  |  | 725
26 | 6094 | 4241 | 337 | 125 | 929 | 872 | 1410 | 1123
27 | 5524 | 4241 |  | 125 | 948 | 872 | 1401 | 1123
28 | 5575 | 4241 | 211 | 125 | 936 | 872 | 1382 | 1123
29 | 5178 | 4241 | 172 | 125 | 924 | 872 | 1565 | 1123
30 | 5190 | 4241 | 246 | 125 | 900 | 872 | 1464 | 1123
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 406899.92
2002-01-30 00:00:00
CBS Volume
 |  |  | 166968
Spreadsheet: 190598d1351710749-can-i-filter-a-table-based-on-the-filtered-results-of-another-table-my-sample
Sheet: Sheet 1

Row Number | Subject | Area | Jur | Neigh | ID No | [NAME] | Unit Number | Street Number | Street Name & Type | City
1 | Y | 2 | 111 | 220007 | 12289000 | 01 |  | 123 | SALTER ST | NEW WESTMINSTER
2 | N | 2 | 111 | 220520 | 03665000 | 01 |  | 456 | E COLUMBIA ST | NEW WESTMINSTER
3 | N | 2 | 111 | 220543 | 03056000 | 01 |  | 789 | BRUNETTE AVE | NEW WESTMINSTER
4 | N | 2 | 111 | 220001 | 00751000 | 01 |  | 101 | AGNES ST | NEW WESTMINSTER
5 | N | 2 | 111 | 220530 | 01142000 | 01 |  | 102 | ELEVENTH ST | NEW WESTMINSTER
6 | N | 2 | 111 | 220001 | 00745000 | 01 |  | 103 | AGNES ST | NEW WESTMINSTER
Spreadsheet: 877994d1724944290-selection-of-tax-period-from-a-table-selection-of-tax-period
Sheet: Sheet1

TAXABLE INCOME
Tax Year | Start Period | End Period
2024 / 2025 | 2024-07-01 00:00:00 | 2025-06-30 00:00:00
2025 / 2026 | 2025-07-01 00:00:00 | 2026-06-30 00:00:00
2026 / 2027 | 2026-07-01 00:00:00 | 2027-06-30 00:00:00
2027 / 2028 | 2027-07-01 00:00:00 | 2028-06-30 00:00:00
EXPECTED RESULT
 |  | ANNUAL TAX PERIOD
PAY DATE |  | formula 1 | formula 2
 |  | Start Period | End Period
Pay date | 2024-08-31 00:00:00 | 2024-07-01 00:00:00 | 2025-06-30 00:00:00
Pay date | 2025-07-31 00:00:00 | 2025-07-01 00:00:00 | 2026-06-30 00:00:00
Pay date | 2025-12-31 00:00:00 | 2025-07-01 00:00:00 | 2026-06-30 00:00:00
Pay date | 2028-04-30 00:00:00 | 2027-07-01 00:00:00 | 2028-06-30 00:00:00
Spreadsheet: 66279d1266971880-sum-exact-range-based-on-criteria-sum-extract-range
Sheet: Sheet1

SIMPLE EXTRACT WHERE MONTHLY TOTALS ARE SUPPLIED
 | Date | Monthly Totals |  | Total to Qtr
 |  | 0
 |  | 0
 | 2010-01-01 00:00:00 | 10 | 1 | 10
 | 2010-02-01 00:00:00 | 20 | 2 | 30
 | 2010-03-01 00:00:00 | 30 | 0 | 60
 | 2010-04-01 00:00:00 | 40 | 1 | 40
 | 2010-05-01 00:00:00 | 50 | 2 | 90
 | 2010-06-01 00:00:00 | 60 | 0 | 150
 | 2010-07-01 00:00:00 | 70 | 1 | 70
 | 2010-08-01 00:00:00 | 80 | 2 | 150
 | 2010-09-01 00:00:00 | 90 | 0 | 240
 | 2010-10-01 00:00:00 | 100 | 1 | 100
 | 2010-11-01 00:00:00 | 110 | 2 | 210
 | 2010-12-01 00:00:00 | 120 | 0 | 330
Spreadsheet: 0f8e4176-25ab-49c0-8f64-5d2d21b98978
Sheet: Sheet1

 | First Name | Last Name | City | Country | club
1 | Tristan | ABBOTT | / | Royaume-Uni
2 | Egor | Andreev | London | United Kingdom
3 | CADARIO | [NAME] | LOUGRES | France
4 | [NAME] | Antonov | [NAME] | Russian Federation
5 | Vincent | AUBIN | CRAON | France
6 | Cédric | [NAME] | SAINT JEAN DE VÉDAS | France
7 | [NAME] | [NAME] | London | United Kingdom
8 | THOMAS | BOUISSON | LA GARDE | France
9 | Sébastien | Boujenah | Lannion | France
10 | Clément | Brazy | [NAME] | France
11 | Lukas | Choma | Martin | Slovakia
12 | [NAME] | Christoffersen | Greve | Denmark
13 | Bartlomiej | Czyz | [NAME] | Poland
14 | [NAME] | Darin | Chennevieres sur marne | France
15 | [NAME] | Evans | Reading | United Kingdom
16 | [NAME] | Falk | Odense c | Denmark
17 | [NAME] | FLOCH | TREGASTEL | France
18 | [NAME] | [NAME] | Coventry | United Kingdom
19 | Julien | Gonget | [NAME] | France
20 | Maxence | Gregoire | chaintrix | France
21 | Nikolaj | Grønbek | Frederikssund | Denmark
22 | [NAME] | Harju | Helsinki | Finland
23 | [NAME] | Hart | Vancouver | Canada
24 | [NAME] | Helmersen | [NAME] | Denmark
25 | [NAME] | Hoogendoorn | Udenhout | The Netherlands
26 | Nikolaj | Jall | Ølstykke | Denmark
27 | [NAME] | [NAME] | København Ø | Denmark
28 | [NAME] | Jeavons | [NAME] | United Kingdom
29 | Anders | [NAME] | Holstebro | Denmark
30 | [NAME] | [NAME] | KING'S LYNN | United Kingdom
31 | Dennis | Karimi | Copenhagen | Denmark
32 | Dennis | [NAME] | Sønderborg | Denmark
33 | Carsten | [NAME] | Sønderborg | Denmark
34 | Stephen | Kilvington | [NAME] | United Kingdom
35 | Morten | Krusaa | Copenhagen | Denmark
36 | [NAME] | [NAME] | Cagnes sur mer | France
37 | Alistair | [NAME] | London | United Kingdom
38 | [NAME] | Ledet | Ardres | France
39 | Guillaume | Louis | Betton | France
40 | [NAME] | Magaard | odense | Denmark
41 | [NAME] | MALPEL | [NAME] sur save | France
42 | [NAME] | [NAME] | [NAME] | France
43 | [NAME] | MAUREL | Le Mans | France
44 | [NAME] | Medina Rodriguez | Madrid | Spain
45 | Ulrik | Meelby | Hilleroed | Denmark
46 | Manuel | Morales JDT | Madrid | Spain
47 | JEREMY | MOREL | DRAGUIGNAN | France
48 | Grigory | Mostman | london | United Kingdom
49 | [NAME] | Nielsen | Vallensbæk | Denmark
50 | Matthias | Pelgrims | Werchter | Belgium
51 | Stanislas | Petroff | Angers | France
52 | [NAME] | [NAME] | [NAME] | United Kingdom
53 | ADRIEN | POULLOT | La Gaude | France
54 | Davide | Rossetti | [NAME] | Italy
55 | Evgeniy | Rukavichnikov | [NAME] | Russian Federation
56 | Dmitry | Samarkin | London | United Kingdom
57 | Jean-Baptiste | Sauve | Colomars | France
58 | [NAME] | Schamberger | [NAME] | Germany
59 | [NAME] | Shagabutdinov | Moscow | Russian Federation
60 | [NAME] | Slack | Wiston | United Kingdom
61 | Edouard | [NAME] | uccle | Belgium
62 | Mathieu | Vogel | toulouse | France
63 | [NAME] | Wentzlaff | [NAME] | Switzerland
64 | Cameron | West | Vancouver | Canada
65 | [NAME] | [NAME] | elsham | United Kingdom
66 | Shaun | Wood | Consett | United Kingdom
67 | Dmitriy | Zaloga | Perm | Russian Federation
68 | [NAME] | [NAME] der Laan | Delft | The Netherlands
 | 68 | 68 | 68 | 68
Spreadsheet: 736228d1623423580-help-completing-my-spreadsheet-dies-tc-sample-small
Sheet: Dies

shape | kind of die | ID | Repeat Around Inches | Repeat Around mm | Description | label width | label height OR repeat step if a set | Gap Across | Gap Around | [NAME] x # Around | No Across | No Around | radius | Total Margin Top & Boottom | [NAME] width  Across | Check Label H + Gap x No around - Cyl Repeat | no of teeth | tooth | total minimum paper width calculated. Preffered. ([NAME]) | Machines die can run on.
1 | 2 | FFOLD/01449 | 9 |  | 24X12MM-4 16 BACK HORIZ.+VERT | 24 | 12 | 3 | 2.2875 |  | 4 | 16 | 2 |  |  |  | 72 | 3.175 |  | 5100,5105,5110,5010,5130,5135
1 | 2 | FFOLD/02170 | 9 |  | 115 X 225MM-1 | 115 | 225 | 0 | 3.6 |  | 1 | 1 | 2 |  |  |  | 72 | 3.175
1 | 2 | FFOLD/00998 | 9 |  | 65 X 208MM-2 | 56 | 208 | 4 | 20.6 |  | 2 | 1 | 2 |  |  |  | 72 | 3.175
1 | 2 | SYF/01411 |  | 228.6 | 134X226MM-1 BACK FOR  SYNTHETIC | 134 | 225.6 | 0 | 3 |  | 1 | 1 | 1 |  |  |  |  | 3.175
1 | 2 | FFOLD/01499 | 9 |  | 32X16MM-4 | 32 | 16 | 4 | 3.05 |  | 4 | 12 | 2 |  |  |  | 72 | 3.175
3 | 2 | FFOLD/02403 | 12 |  | 105 X 298MM-2 LABELSETS (SEE NOTES) | 105 | 298 | 3 | 6.8 |  | 2 | 1 | 2.5 |  |  |  | 96 | 3.175
3 | 2 | FFOLD/01855 | 12.25 |  | 60 X 75MM-3 LABELSET | 60 | 75 | 3 | 2.787 |  | 3 | 4 | 2 |  |  |  | 98 | 3.175
3 | 2 | SYF/02057 | 12.25 |  | 91 X 41-2 | 91 | 41 | 4 | 3.45 |  | 2 | 7 | 0 |  |  |  |  | 3.175
2 | 2 | FFOLD/02068 | 12.25 |  | 59.5 X 59.5MM-3 | 59.5 | 59.5 | 4 | 2.73 |  | 3 | 5 |  |  |  |  | 98 | 3.175
1 | 2 | FFOLD/02287 | 16 |  | 101.6 X 200.2MM-3 + FACE CUT | 101.6 | 200.2 | 3 | 3 |  | 3 | 2 | 2 |  |  |  | 128 | 3.175 |  | 5000,5005
1 | 2 | FFOLD/02115 | 16 |  | 105 X 198MM-3 | 105 | 198 | 3 | 5.2 |  | 3 | 2 | 2 |  |  |  | 128 | 3.175
1 | 2 | FFOLD/02327 | 16 |  | 105 X 200MM-3 | 105 | 200 | 3 | 3.2 |  | 3 | 2 | 1 |  |  |  | 128 | 3.175
3 | 2 | FFOLD/01712 | 16 |  | LABELSET (SEE NOTES) | 77 | 132 | 14 | 3.467 |  | 4 | 3 | 0 |  |  |  | 128 | 3.175
1 | 2 | FFOLD/01939-TUBE | 16 |  | 84 X 96.7MM-6 | 84 | 96.7 | 2.5 | 4.9 |  | 6 | 4 | 2 |  |  |  | 128 | 3.175
1 | 2 | FFOLD/02440 | 16 |  | 101.6 X 38.1MM-5 | 101.6 | 38.1 | 3 | 2.54 |  | 5 | 10 | 2 |  |  |  | 128 | 3.175
1 | 2 | FFOLD/02369 | 16.25 |  | 101.6 X 203.2MM-2 | 101.6 | 203.2 | 3 | 3.175 |  | 2 | 2 | 2 |  |  |  | 130 | 3.175
1 | 2 | FFOLD/02152 | 16.25 |  | 53.34 X 203MM-4 | 53.34 | 203 | 3 | 3.375 |  | 4 | 2 | 2 |  |  |  | 130 | 3.175
1 | 2 | FFOLD/02282 | 16.25 |  | 127 X 203MM-2 | 127 | 203 | 3 | 3.375 |  | 2 | 2 | 2 |  |  |  | 130 | 3.175
1 | 2 | FFOLD/00795 | 16.5 |  | 29 X 67MM-4  SOLID # around guessed by JR at 6 | 28.57 | 66.67 | 3.175 | 3.18 |  | 4 | 6 | 2 |  |  |  | 132 | 3.175
Spreadsheet: 724135d1616020471-change-static-text-to-dynamic-text-in-large-workbook-sample-workbook
Sheet: D3 Epid. Demog. & Service Data

Return to Contents |  | D3:  Epidemiological, [NAME], and Service/Program Data
 |  |  |  |  | Area 1 |  |  |  | Area 2
 |  | Distance between Group-Area HQ/warehouse and Area HQ/warehouse | km | The log books of drivers are a good source of information on the various distances. Drivers  will also be able to supply good estimates of the amount of time it takes to do the various journeys identified here.   For Area to Care sites and Outpatient Care sites to Community Outreach activity sites, average the data over all the potential sites.   Note that the distance and time to record here relates to the one-way and not the return journey. |  | u
 |  | Time between Group-Area HQ/warehouse and Area HQ/warehouse | hours |  |  | u
 |  | Average distance between Area HQ/warehouse and Outpatient Care site | km |  |  | u
 |  | Average time between Area HQ/warehouse and Outpatient Care | hours |  |  | u
 |  | Average distance between Area HQ/warehouse and Inpatient Care site | km |  |  | u
 |  | Average time between Area HQ/warehouse and Inpatient Care site | hours |  |  | u
Spreadsheet: 219599d1362803052-conditional-sum-excel-2010-drop-down-lists-2013-planting-1
Sheet: seed

 |  | PURCHASE |  |  |  |  |  | USED
# |  | dennis | justin | jay | ron | total |  | dennis | justin | jay | ron
1 | 1151 AM |  |  | 9 | 9
2 | 1324 HR | 32 |  |  | 16
3 | 1498 HR | 48 |  |  | 32
4 | 1508 CHR | 32 | 32 |  | 30
5 | 1625 CHR |  |  |  | 30
6 | 1690 HR | 48
7 | 33D42 | 64 |  |  | 32
8 | 33D47 | 32 | 32 | 15 | 44
9 | 92y70 |  |  | 100
10 | 92y83 |  |  |  | 100
11 | DK 63-87 |  | 16
12 | DK 66-87 |  | 16
13
14
15
16
17
18
19
Spreadsheet: 6411599d-41b4-44e6-8bf8-4582bfd3f1e6
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40859296 | 2014-04-05 22:42:04 | AXIS | 1 | 7 | 6 | 586355 | Warbanner1 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40859911 | 2014-04-05 23:19:24 | ALLIES | 1 | 7 | 6 | 586355 | Warbanner1 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 142f6715-a334-4b6e-b7b6-867cfcd6462f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
New Hartford PTO
[NAME]
Name: |  |  |  | Phone #:
Check #: |  |  |  | [NAME]:
Product | Qty | Total |  | Product | Qty | Total
99 Restaurant $25.00 |  | $ |  | Lands' End $25.00 |  | $
Applebee's $25.00 |  | $ |  | Lands' End $100.00 |  | $
Applebee's $50.00 |  | $ |  | Lowe's Home Improvement $25.00 |  | $
Barnes & Noble Booksellers $10.00 |  | $ |  | Lowe's Home Improvement $100.00
Barnes & Noble Booksellers $25.00 |  | $ |  | Marshalls $25.00 |  | $
Barnes & Noble Booksellers $100.00 |  | $ |  | Marshalls $100.00 |  | $
Barnes & Noble "Teacher [NAME]" $20.00 |  | $ |  | Michaels $25.00 |  | $
Bath & Body Works $10.00 |  | $ |  | Panera Bread $10.00 |  | $
Bath & Body Works $25.00 |  | $ |  | Panera Bread $25.00 |  | $
Bed Bath & Beyond $25.00 |  | $ |  | Payless Shoes $20.00 |  | $
Best Buy $25.00 |  | $ |  | ShopRite $25.00 |  | $
Best Buy $100.00 |  | $ |  | ShopRite $100.00 |  | $
Blockbuster $10.00 |  | $ |  | Starbucks $10.00 |  | $
Borders $10.00 |  | $ |  | Starbucks $25.00 |  | $
Borders $25.00 |  | $ |  | Stop & Shop $25.00 |  | $
Chili's Grill & Bar $25.00 |  | $ |  | Stop & Shop $100.00 |  | $
Claire's $10.00 |  | $ |  | Subway $10.00 |  | $
Cold Stone Creamery $10.00 |  | $ |  | Subway $50.00 |  | $
CVS/pharmacy $25.00 |  | $ |  | T.J. Maxx $25.00 |  | $
Dick's Sporting Goods $25.00 |  | $ |  | T.J. Maxx $100.00 |  | $
Dressbarn $25.00 |  | $ |  | Wal-Mart $25.00 |  | $
Dunkin' Donuts $10.00 |  | $ |  | Wal-Mart $100.00 |  | $
Fashion Bug $25.00 |  | $ |  |  |  | $
Game Stop $25.00 |  | $ |  |  |  | $
Gap $25.00 |  | $ |  |  |  | $
Home Depot $25.00 |  | $ |  |  |  | $
Home Depot $100.00 |  | $ |  |  |  | $
iTunes® $15.00 |  | $ |  |  |  | $
JCPenney $25.00 |  | $ |  |  |  | $
JCPenney $100.00 |  | $ |  |  |  | $
KMart $25.00 |  | $ |  |  |  | $
KMart $50.00 |  | $ |  |  |  | $
[NAME]'s Department Store $25.00 |  | $ |  |  |  | $
[NAME]'s Department Store $100.00 |  | $ |  |  |  | $
L.L. Bean $25.00 |  | $
L.L. Bean $100.00 |  | $ |  | Totals
Please visit www.shopwithscrip.com for additional retailers.
If you would like to order from a retailer not listed above, please use the blank spaces provided.
Please make your check payable to NHPTO and return to school OR send to:
[NAME], NHPTO / GLScrip Program, 30 [NAME], New Hartford.
Any questions, please contact [NAME] at 496-7775 or [EMAIL]
Turn in your order form by the 5th of each month, and gift cards will be delivered by the 15th of the month.
Spreadsheet: 814380d1674333654-multiple-ifs-in-one-cell-based-on-other-cells-multiple-ifs
Sheet: Sheet1

 |  |  |  |  |  |  |  | Days
 |  |  |  |  |  | 0 | Prospect Lead | 0
 |  |  |  |  |  | 1 | New Sales Contact | 3
 |  |  |  |  |  | 2 | Contract Signed | 1
 |  |  |  |  |  | 3 | PEND Adj. Meeting | 3
 |  |  |  |  |  | 4 | SCH Adj. Meeting | 5
 |  |  |  |  |  | 5 | PEND Ins. Approval | 5
 |  |  |  |  |  | 6 | Scope Pending | 3
 |  |  |  |  |  | 7 | Scope Uploaded | 1
 |  |  |  |  |  | 8 | [NAME]. Uploaded | 1
 |  |  |  |  |  | 9 | Project Verification | 5
 |  |  |  |  |  | 10 | New Job Project | 3
 | Date | ISO | ISR | CNV | Customer | # | Status |  | Status Date | DAYS | MAX | Address | City | ST | Zip
 | 2023-01-13 00:00:00 | RB | [NAME] | [NAME] | [NAME] | 1 |  |  | 2023-01-17 00:00:00 |  |  | 2058 Appaloosa Way | Conyers | GA | 30012
 |  |  |  |  |  | 1 |  |  | 2023-01-17 00:00:00
 |  |  |  |  |  | 2 |  |  | 2023-01-19 00:00:00
Spreadsheet: 88085d1288013731-auto-assigning-sale-item-invoice-number-against-stock-list-excel-tests
Sheet: Sales

Sales
Invoice no | ITEM
10001 | AAA111
10002 | BBB111
10003 | BBB111
10004 | CCC111
10005 | DDD111
10006 | EEE111
10007 | CCC111
10008 | DDD111
10009 | EEE111
10010 | CCC111
10011 | DDD111
10012 | EEE111
10013 | BBB111
10014 | BBB111
10015 | CCC111
10016 | DDD111
10017 | EEE111
10018 | CCC111
10019 | AAA222
10020 | BBB222
10021 | BBB222
10022 | CCC222
10023 | DDD222
10024 | CCC111
10025 | DDD111
10026 | EEE111
10027 | CCC111
10028 | BBB222 CCC111 |  | multiple items in one cell with space as separator
10029 | BBB222 AAA111
Spreadsheet: 691205d1597567195-need-to-call-data-based-on-the-variable-sample-data
Sheet: DATA1

 |  | PF-1 |  |  |  |  |  | PF-2 |  |  |  |  |  | PF-3 |  |  |  |  |  | PF-4 |  |  |  |  |  | PF-5
 |  | Val-1 | Val-2 | Val-3 | % | T | Cum % | Val-1 | Val-2 | Val-3 | % | T | Cum % | Val-1 | Val-2 | Val-3 | % | T | Cum % | Val-1 | Val-2 | Val-3 | % | T | Cum % | Val-1 | Val-2 | Val-3 | % | T | Cum %
 | Mar''20 | 176118541.745 |  |  |  | 100 |  | 143053187.775 |  |  |  | 100 |  | 21117773.653 |  |  |  | 100 |  | 462151933.223 |  |  |  | 100 |  | 574395871.515 |  |  |  | 100
 | Apr''20 | 176102776.047 | 0 | 0 | -8.951753656250006e-05 | 99.99104824634375 | -8.951753656250006e-05 | 150254224.925 | 0 | 0 | 0.05033818023912962 | 105.033818023913 | 0.05033818023912962 | 22627375.426 | 0 | 0 | 0.07148489219579934 | 107.1484892195799 | 0.07148489219579934 | 487750588.857 | 0 | 0 | 0.0553901299416355 | 105.5390129941636 | 0.0553901299416355 | 616195426.349 | 0 | 0 | 0.07277133577536232 | 107.2771335775362 | 0.07277133577536232
 | May''20 | 188985412.674 | 0 | 0 | 0.073154080339777 | 107.3058014230153 | 0.073154080339777 | 153093019.34 | 0 | 0 | 0.01889327515693484 | 107.0182508486222 | 0.01889327515693484 | 23317936.319 | 33674.703 | 0 | 0.02903059579968814 | 110.2590737006608 | 0.02903059579968814 | 499373925.506 | 0 | 0 | 0.02383049229369094 | 108.0540596300047 | 0.02383049229369094 | 622984224.543 | 0 | 0 | 0.01101728105030597 | 108.4590359084312 | 0.01101728105030597
 | Jun''20
 | July''20
 | Aug''20
 | Sep''20
 | Oct''20
 | Nov''20
 | Dec''20
 | Jan''21
 | Feb''21
 | Mar''21