tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18426__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-01-05 00:00:00 |  | 136.45 | 1216 | 93.11 | 528
 | 2001-01-04 00:00:00 |  | 146.87 | 2016 | 88.03 | 912 | 125.05 | 1851 | 107.45 | 778
 | 2001-01-03 00:00:00 |  | 145.65 | 544 | 75.2 | 32 | 125.71 | 1965 | 99.79 | 652
 | 2001-01-02 00:00:00 |  | 151.43 | 224 | 80 | 32 | 120.29 | 1597 | 76.99 | 944
 | 2001-01-01 00:00:00 |  |  |  |  |  | 102.04 | 432 | 64.43 | 628
 | 2000-12-31 00:00:00 |  |  |  |  |  | 73.65 | 2126 | 66.14 | 1101
 | 2000-12-30 00:00:00 |  | 118.57 | 224 | 75 | 32 | 103.71 | 1824 | 100.69 | 360
 | 2000-12-29 00:00:00 |  | 140 | 64 | 103.1 | 232 | 139.65 | 2163 | 106.37 | 925
 | 2000-12-28 00:00:00 |  | 140 | 64 | 103.1 | 232 | 130.72 | 830 | 120.35 | 1115
 | 2000-12-27 00:00:00 |  | 200 | 64 | 160 | 200 | 121.92 | 1931 | 94.63 | 1065
 | 2000-12-26 00:00:00 |  | 275 | 64 | 203.1 | 232 | 124.96 | 2250 | 71.81 | 666
 | 2000-12-25 00:00:00 |  | 265 | 0 | 210 | 200 | 99.62 | 1532 | 62.74 | 155
 | 2000-12-24 00:00:00 |  | 265 | 0 | 210 | 200 | 131.21 | 1155 | 50.53 | 582
 | 2000-12-23 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 285 | 0 | 215 | 0
 | 2000-12-22 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 299 | 25 | 215 | 0
 | 2000-12-21 00:00:00 |  | 291.55 | 464 | 216.99 | 512 | 189.32 | 2060 | 171.06 | 292
 | 2000-12-20 00:00:00 |  | 275 | 0 | 212.86 | 280 | 214.57 | 1110 | 161.24 | 218
 | 2000-12-19 00:00:00 |  | 265.68 | 1180 | 201.43 | 280 | 194.39 | 1310 | 178.74 | 855
 | 2000-12-18 00:00:00 |  | 236.9 | 1680 | 190.62 | 960 | 223.03 | 852 | 172.62 | 525
 | 2000-12-17 00:00:00 |  | 215 | 800 | 200 | 200 | 173.03 | 1450 | 148.06 | 1255
 | 2000-12-16 00:00:00 |  | 275 | 480 | 210 | 400 | 183.11 | 2287 | 181.95 | 535
 | 2000-12-15 00:00:00 |  | 275 | 480 | 210 | 400 | 187.75 | 2655 | 153.05 | 1714
 | 2000-12-14 00:00:00 |  | 327.14 | 560 | 226 | 600 | 186.36 | 2035 | 170.6 | 1669
 | 2000-12-13 00:00:00 |  | 497.86 | 448 | 237.79 | 704 | 287.91 | 1278 | 165.71 | 1791
 | 2000-12-12 00:00:00 |  | 342.11 | 1328 | 239.28 | 1064 | 334.23 | 1940 | 165.94 | 1277
 | 2000-12-11 00:00:00 |  | 447.65 | 544 | 245.19 | 832 | 244.01 | 1470 | 147.46 | 1240
 | 2000-12-10 00:00:00 |  | 297.1 | 992 | 244.42 | 1504 | 200.84 | 712 | 127.41 | 600
 | 2000-12-09 00:00:00 |  | 315.42 | 2304 | 213.76 | 1976 | 187.04 | 810 | 148.98 | 1225
 | 2000-12-08 00:00:00 |  | 315.42 | 2304 | 213.76 | 1976 | 287.06 | 1430 | 175 | 390
 | 2000-12-07 00:00:00 |  | 312.11 | 2080 | 205.86 | 2776 | 246.51 | 172 | 138.05 | 519
 | 2000-12-06 00:00:00 |  | 267.18 | 2128 | 177.11 | 1344 | 260.08 | 529 | 151.35 | 911
Spreadsheet: 2047a074-374d-4a16-916f-3e82e3d8267e
Sheet: FA 02 - Data

[NAME]
Focus Area 02 - Arthritis, Osteoporosis and Chronic Back Conditions - Pennsylvania
Objective Number | Objective Title | Baseline Data | Final Data | HP2010 Goal | Target Progress
02-02 | Adults with Arthritis whose Activities are Limited  (age-adjusted percentage) | 33 ± 4 (2003) | 26 ± 2 (2007) | 33 | Met or exceeded target
02-04a | Overweight/Obese Adults with Arthritis who have been Counseled in Weight Reduction  (age-adjusted percentage) | 31 ± 5 (2003) | 41 ± 4 (2007) | 46 | Moved toward target
02-04b | Adults with Arthritis who have been Counseled to do Physical Activity  (age-adjusted percentage) | 55 ± 4 (2003) | 50 ± 3 (2007) | 67 | Moved away from target
02-07 | Adults with Chronic Joint Symptoms who have Seen a Doctor for those Symptoms (age-adjusted percentage) | 71 ± 3 (2003) | 73 ± 3 (2007) | 61 | Met or exceeded target
02-08 | Adults with Arthritis who have Taken a Class to Manage their Arthritis  (age-adjusted percentage) | 14 ± 3 (2003) | 11 ± 2 (2007) | 13 | Moved away from target
02-09 | Adults (aged 50+) Told by a Doctor they have Osteoporosis  (age-adjusted percentage) | 13 ± 2 (2003) | 12 ± 1 (2007) | 8 | Moved toward target
02-10 | Hospitalizations (aged 65+) for Vertebral Fractures  (age-adjusted per 10,000 population) | 17.3  (1996) | 23.2  (2008) | 14 | Moved away from target
Note: The list of objectives above are limited to those for which Pennsylvania data were available.
Spreadsheet: 800905d1665989655-is-there-a-search-or-filter-function-that-works-on-partial-results-for-strings-s666-f-search-or-filter-function-that-works-on-partial-results-for-strings
Sheet: SDDL

 |  |  |  | SDVDDL
 | [NAME] |  |  | at
 | Catherin
 | Katrin
 | [NAME]
 | [NAME]
 | [NAME]
 | Mikael
 | Micael
 | [NAME]
 | [NAME]
 | Orlando Leach
 | [NAME]
 | [NAME]
 | [NAME]
 | Amal Ware
 | [NAME]
 | Scarlet Dillard
 | [NAME]
 | [NAME]
 | Hedwig Todd
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Whoopi Fitzpatrick
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Signe Newton
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Elijah Hebert
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Wade Cox
 | [NAME]
 | Whitney Sweeney
 | [NAME]
 | [NAME]
 | Regina Booth
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Amity Gomez
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Guy Cline
 | Danielle Pruitt
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Pascale [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Paloma Kerr
 | Remedios Ewing
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Desirae Hodges
 | Tara O'connor
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Venus Spears
 | [NAME]
 | [NAME]
Spreadsheet: 106356d1303531532-find-max-of-a-particular-day-max-date-1-
Sheet: Sheet1

dates | scores | helper |  | [NAME] | date |  |  | dates | scores |  | Monday Scores | date
2011-04-22 00:00:00 | 2 | 0 |  | 50 | 2011-05-02 00:00:00 |  |  | 2011-04-22 00:00:00 | 2 |  | 8 | 2011-05-09 00:00:00
2011-04-23 00:00:00 | 3 | 0 |  |  |  |  |  | 2011-04-23 00:00:00 | 3 |  | 50 | 2011-05-02 00:00:00
2011-04-24 00:00:00 | 3 | 0 |  |  |  |  |  | 2011-04-24 00:00:00 | 3 |  | 50 | 2011-04-25 00:00:00
2011-04-25 00:00:00 | 10 | 10 |  |  |  | 4 | 50 | 2011-04-25 00:00:00 | 50
2011-04-26 00:00:00 | 2 | 0 |  |  |  |  |  | 2011-04-26 00:00:00 | 2
2011-04-27 00:00:00 | 2 | 0 |  |  |  |  |  | 2011-04-27 00:00:00 | 2
2011-04-28 00:00:00 | 23 | 0 |  |  |  |  |  | 2011-04-28 00:00:00 | 23
2011-04-29 00:00:00 | 2 | 0 |  |  |  |  |  | 2011-04-29 00:00:00 | 2
2011-04-30 00:00:00 | 50 | 0 |  |  |  |  |  | 2011-04-30 00:00:00 | 50
2011-05-01 00:00:00 | 3 | 0 |  |  |  |  |  | 2011-05-01 00:00:00 | 3
2011-05-02 00:00:00 | 50 | 50 |  |  |  | 11 | 50 | 2011-05-02 00:00:00 | 50
2011-05-03 00:00:00 | 2 | 0 |  |  |  |  |  | 2011-05-03 00:00:00 | 2
2011-05-04 00:00:00 | 2 | 0 |  |  |  |  |  | 2011-05-04 00:00:00 | 2
2011-05-05 00:00:00 | 2 | 0 |  |  |  |  |  | 2011-05-05 00:00:00 | 2
2011-05-06 00:00:00 | 2 | 0 |  |  |  |  |  | 2011-05-06 00:00:00 | 2
2011-05-07 00:00:00 | 3 | 0 |  |  |  |  |  | 2011-05-07 00:00:00 | 3
2011-05-08 00:00:00 | 3 | 0 |  |  |  |  |  | 2011-05-08 00:00:00 | 3
2011-05-09 00:00:00 | 8 | 8 |  |  |  | 18 | 8 | 2011-05-09 00:00:00 | 8
2011-05-10 00:00:00 | 2 | 0 |  |  |  |  |  | 2011-05-10 00:00:00 | 2
2011-05-11 00:00:00 | 2 | 0 |  |  |  |  |  | 2011-05-11 00:00:00 | 2
Spreadsheet: 777792d1650620781-creating-lookup-formula-using-3-drop-down-selections-kalkulator_pompy
Sheet: Stopa Zwrotu

 |  |  |  |  |  |  |  |  |  |  |  | dachowa
 |  |  |  |  |  |  |  |  |  |  |  | naziemna
 | 5000 | 0.17 |  |  |  |  |  |  |  |  |  | inna
 | 0 | 0.32
 |  | 0.19 |  |  |  |  | KOSZT PRĄDU
 |  | 0.07 |  |  |  |  | 0.75 |  |  |  |  | Koszt Instalacji |  |  | Zużycie energii |  | kWh
 |  |  |  |  |  |  |  |  |  |  |  | Dotacja "Mój prąd" | 5000 |  | Roczny koszt energii
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] termomodernizacyjna | 0.19
 |  |  |  |  |  |  |  |  |  |  |  | Realny koszt
 |  |  |  |  |  |  |  |  |  |  |  | Czas zwrotu instalacji |  | rok
 |  |  |  |  |  |  |  |  |  |  |  | Biorąc pod uwagę obecną cenę!
 | [NAME] | 0.08
 |  | 1
 |  | 2 |  |  |  |  |  |  |  |  |  | Prognozowany wzrost cen prądu (8%/rok) |  |  | Przyrostowo
 |  | 3 |  |  |  |  |  |  |  |  |  | 2020
 |  | 4 |  |  |  |  |  |  |  |  |  | 2021 |  |  |  | po roku
 |  | 5 |  |  |  |  |  |  |  |  |  | 2022 |  |  |  | po 2 latach
 |  | 6 |  |  |  |  |  |  |  |  |  | 2023 |  |  |  | po 3 latach
 |  | 7 |  |  |  |  |  |  |  |  |  | 2024 |  |  |  | po 4 latach
 |  | 8 |  |  |  |  |  |  |  |  |  | 2025 |  |  |  | po 5 latach
 |  | 9 |  |  |  |  |  |  |  |  |  | 2026 |  |  |  | po 6 latach
 |  | 10 |  |  |  |  |  |  |  |  |  | 2027 |  |  |  | po 7 latach
 |  | 11 |  |  |  |  |  |  |  |  |  | 2028 |  |  |  | po 8 latach
 |  | 12 |  |  |  |  |  |  |  |  |  | 2029 |  |  |  | po 9 latach
 |  | 13 |  |  |  |  |  |  |  |  |  | 2030 |  |  |  | po 10 latach
 |  | 14 |  |  |  |  |  |  |  |  |  | 2031 |  |  |  | po 11 latach
 |  | 15 |  |  |  |  |  |  |  |  |  | 2032 |  |  |  | po 12 latach
 |  | 16 |  |  |  |  |  |  |  |  |  | 2033 |  |  |  | po 13 latach
Spreadsheet: 877836d1724778583-formula-algorithm-to-establish-accurate-target-forecasting-revenue-example
Sheet: Data

 | 2024-04-06 00:00:00 | 2024-04-13 00:00:00 | 2024-04-20 00:00:00 | 2024-04-27 00:00:00 | 2024-05-04 00:00:00 | 2024-05-11 00:00:00 | 2024-05-18 00:00:00 | 2024-05-25 00:00:00 | 2024-06-01 00:00:00 | 2024-06-08 00:00:00 | 2024-06-15 00:00:00 | 2024-06-22 00:00:00 | 2024-06-29 00:00:00 | 2024-07-06 00:00:00 | 2024-07-13 00:00:00 | 2024-07-20 00:00:00 | 2024-07-27 00:00:00 | 2024-08-03 00:00:00 | 2024-08-10 00:00:00 | 2024-08-17 00:00:00 | 2024-08-24 00:00:00 | 2024-08-31 00:00:00 | 2024-09-07 00:00:00 | 2024-09-14 00:00:00 | 2024-09-21 00:00:00 | 2024-09-28 00:00:00 | 2024-10-05 00:00:00 | 2024-10-12 00:00:00 | 2024-10-19 00:00:00 | 2024-10-26 00:00:00 | 2024-11-02 00:00:00 | 2024-11-09 00:00:00 | 2024-11-16 00:00:00 | 2024-11-23 00:00:00 | 2024-11-30 00:00:00 | 2024-12-07 00:00:00 | 2024-12-14 00:00:00 | 2024-12-21 00:00:00 | 2024-12-28 00:00:00 | 2025-01-04 00:00:00 | 2025-01-11 00:00:00 | 2025-01-18 00:00:00 | 2025-01-25 00:00:00 | 2025-02-01 00:00:00 | 2025-02-08 00:00:00 | 2025-02-15 00:00:00 | 2025-02-22 00:00:00 | 2025-03-01 00:00:00 | 2025-03-08 00:00:00 | 2025-03-15 00:00:00 | 2025-03-22 00:00:00 | 2025-03-29 00:00:00
Revenue | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | Week 34 | Week 35 | Week 36 | Week 37 | Week 38 | Week 39 | Week 40 | Week 41 | Week 42 | Week 43 | Week 44 | Week 45 | Week 46 | Week 47 | Week 48 | Week 49 | Week 50 | Week 51 | Week 52
Prior Year | 796314.55 | 759786.37 | 898145.37 | 1065753.68 | 519135 | 646047 | 1074350 | 865550.84 | 884868 | 978237 | 997818 | 688072 | 1025771 | 584645 | 1101091 | 752790 | 1227834 | 836305 | 373982 | 868979 | 799721 | 626696 | 6940 | 678124 | 1063475 | 1125524 | 1674390 | 1073117 | 1030989 | 1159279 | 1266052 | 906706 | 690496 | 625446 | 1030261 | 246847 | 672328 | 897300 | 824255 | 1220261 | 652280 | 926358 | 754250 | 607855 | 785899 | 654852 | 571480 | 734925 | 810227 | 745051.32 | 836137.1826000001 | 836933.635252
Target | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21 | 936475.21
Actual | 655729.07 | 732722.69 | 600653.54 | 1154078.24 | 975097 | 1252780.63 | 899637.75 | 1264998.15 | 1072123.37 | 1487692.02 | 879096.99 | 899395.51 | 1013152.71 | 480886.67 | 651359.67 | 472135.74 | 720614.91 | 1502484.26
Spreadsheet: jim_schwieger__14297__Bronco Division Rescheduled Games _3
Sheet: Sheet1

Game # | Visitor Team | Home Team | Day | Date | Time | Field | Comments
Bronco-Gray
1069 | Pirates-Hamilton | Rockies-Cook | MON | 2001-04-30 00:00:00 | 8:00pm | WLY#5
1070 | Cubs-Hamilton | Rangers-Dean | WED | 2001-05-02 00:00:00 | 8:00pm | BC#2
1079 | Red Sox-Thorton | Tigers-Campbell | WED | 2001-04-25 00:00:00 | 6:00pm | BC#2
1102 | Pirates-Hamilton | Marlins-Bleyl | WED | 2001-05-09 00:00:00 | 6:00pm | WLY#5
1103 | Mets-Labay | Red Sox-Thorton | WED | 2001-05-02 00:00:00 | 6:00pm | BC#2
1104 | Braves-Thorton | Rockies-Cook | SUN | 2001-04-29 00:00:00 | 4:30pm | BC#2
1107 | Yankees-Labay | Dodgers-Truitt | TUE | 2001-05-01 00:00:00 | 8:00pm | WLY#5
1144 | Mariners-Bleyl | Twins-Truitt | TUE | 2001-05-01 00:00:00 | 6:00pm | BC#2
1129 | Padres-Arnold | Astros-Bleyl | FRI | 2001-04-27 00:00:00 | 6:00pm | [NAME]
1130 | Marlins-Bleyl | Twins-Truitt | FRI | 2001-04-27 00:00:00 | 8:00pm | [NAME]
1157 | Mets-Labay | Yankees-Labay | WED | 2001-04-25 00:00:00 | 8:00pm | BC#2
1179 | Cubs-Hamilton | Red Sox-Thorton
Bronco-Maroon
1202 | Braves-Labay | Cardinals-Hamilton | TUE | 2001-05-01 00:00:00 | 6:00pm | WLY#5
1203 | Cardinals-Hamilton | Marlins-Bleyl | TUE | 2001-05-01 00:00:00 | 8:00pm | BC#2
1238 | A's-Hamilton | Marlins-Bleyl
1217 | Cardinals-Hamilton | Reds-Cook | FRI | 2001-04-27 00:00:00 | 6:00pm | WLY#5
1218 | A's-Hamilton | Astros-Campbell | FRI | 2001-04-27 00:00:00 | 8:00pm | WLY#5
1231 | Astros-Campbell | Braves-Labay | SUN | 2001-04-29 00:00:00 | 2:30pm | BC#2
1232 | Marlins-Bleyl | Cardinals-Hamilton | WED | 2001-05-09 00:00:00 | 8:00pm | WLY#5
Spreadsheet: 728102d1618308848-how-can-i-pull-a-value-from-a-cell-if-it-finds-a-match-test-spreadsheet
Sheet: Sheet2

Client Number | Search Name | Code | Amount | Date of Withdrawal
1731126 |  | FER010/001 | 20000 | 2021-04-13 00:00:00
603460 |  | FER010/001 | 328 | 2021-04-13 00:00:00
4666459 |  | FER010/001 | 9763 | 2021-04-13 00:00:00
4666460 |  | FER010/001 | 1208 | 2021-04-13 00:00:00
4667460 |  | FER010/001 | 97000 | 2021-04-13 00:00:00
Spreadsheet: 0447847e-a380-4d5a-a8ad-c085caf3130d
Sheet: Prepaid Template

FY 2013 Prepaids
REQUIRED INFORMATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FOR SYSTEM OFFICE USE ONLY |  |  |  |  |  | 2013-06-30 00:00:00 |  | FY 2014 CHARTSTRING CHANGES (Use ONLY if the chartstring CHANGES from one FY to the next)
[NAME] | REQ PO CR TR PC OTH | Requisition number, [NAME] number, [NAME] number, Travel Request number, [NAME], Other | Trans Date (ProCard ONLY) | Post Date (ProCard ONLY) | Invoice Number | Begin Date of Contract | End Date of Contract | Invoice Amount | Business Unit | Account | Fund | Department | Program | Class | Project Grant | Amount | Charge to FY13 expense | (Charge to FY14 expense) Prepaid Amt |  | Begin Date | End Date | # of days | Days prepaid |  | [NAME] | REQ PO CR TR PC OTH | Requisition number, [NAME] number, [NAME] number, Travel Request number, [NAME], Other | Invoice Amount | Business Unit | Account | Fund | Department | Program | Class | Project Grant | Amount
EXAMPLE COMPANY | CR | 15678596 |  |  | A7102 | 2013-03-01 00:00:00 | 2014-02-28 00:00:00 | 500 | 21000 | 50700 | 01 | 706325 | 06000 | 00 |  | 500
ONE-DAY CONFERENCE | PC | [NAME] | 2012-06-15 00:00:00 | 2012-06-16 00:00:00 |  | 2013-07-15 00:00:00 | 2014-07-15 00:00:00 | 100 | 21000 | 50112 | 01 | 706325 | 06000 | 00 |  | 100 |  |  |  |  |  |  |  |  | ONE-DAY CONFERENCE | PC | [NAME] | 100 | 21000 | 50112 | 01 | 706035 | 06000 | 00 |  | 100
PERIODICAL SUBSCRIPTION | PO | PO6801004556 |  |  | 105493 | 2012-10-01 00:00:00 | 2013-09-30 00:00:00 | 400 | 68010 | 60000 | 01 | 706325 | 04100 | 00 |  | 400
Spreadsheet: 806383d1669274560-searching-for-an-exact-numeric-match-with-a-formula-filter-example-forum
Sheet: Sheet1

 | ID | Result |  |  | ID | Value
 | 5.1 |  |  |  | 5.1 | banana
 | 5.2 |  |  |  | 5.11 | apple
 | 5.3 |  |  |  | 15.1 | [NAME]
 | 5.4 |  |  |  | 10.6 5.1 | avocado
 |  |  |  |  | 4.9 5.2 13.3 | orange
Spreadsheet: e6429647-99f7-42ce-99a8-2623d1e337d1
Sheet: February

Date | Name | Activity
1
2 | Groundhog Day | http://www.holidayinsights.com/other/ghog.htm
3 | Give Kids A Smile Day | http://www.ada.org/givekidsasmile.aspx
4 | Thank a Mailman Day | http://www.holidayinsights.com/moreholidays/February/thankmailmanday.htm
5
6
7
8 | Kite Flying Day | [NAME]
9
10 | Umbrella Day | http://www.holidayinsights.com/moreholidays/February/umbrelladay.htm
11
12 | [NAME] Birthday | http://www.holidayinsights.com/other/lincoln.htm
13
14 | National Ferris Wheel Day | http://www.holidayinsights.com/moreholidays/February/ferriswheelday.htm
15 | [NAME] | http://teacherlink.ed.usu.edu/tlresources/units/byrnes-celebrations/susanb.html
16
17
18 | Pluto Day | http://www.history.com/this-day-in-history/pluto-discovered
19
20
21
22 | Walking the Dog Day | http://www.holidayinsights.com/moreholidays/February/walkdogday.htm
23 | Tennis Day | http://www.holidayinsights.com/moreholidays/February/tennisday.htm
24
25
26 | Tell a Fairy Tale Day | http://www.holidayinsights.com/moreholidays/February/tellfairytaleday.htm
27 | International Polar Bear Day | http://www.holidayinsights.com/moreholidays/February/polarbearday.htm
28 | National Tooth Fairy Day | http://www.holidayinsights.com/moreholidays/February/toothfairyday.htm
Spreadsheet: 101168d1299287153-lookup-index-match-lookup
Sheet: Sheet1

EXAMPLE |  |  |  |  |  |  |  | Type | Measure
Type | Units | Cartons | Cases | Picktickets | Packs | Helper |  | Car | Packs
Car |  |  | 0 |  | 97.66144959207445 | 97.66144959207445 |  | Motorcycle | Cases
Motorcycle |  |  | 2 |  |  | 2 |  | Truck | Cartons
Truck | 4516 | 2087 | 0 | 41 | 127.4852133585007 | 2087 |  | Accessories | Picktickets
Accessories | 2049 | 864 | 0 | 22 | 54.90275119506096 | 22 |  | Rail | Cartons
Mono | 2085 | 961 | 0 | 57 | 46.46905089777387 | 2085 |  | Mono | Units
Rail | 4963 | 2537 | 0 | 54 | 135.9510925306567 | 2537
Car | 4736 | 2426 | 0 | 54 | 134.8777517862569 | 134.8777517862569
Car | 3854 | 1862 | 0 | 35 | 105.7844745109962 | 105.7844745109962
Car | 186 | 49 | 0 | 49 | 3.57881313131313 | 3.57881313131313
Truck | 79 | 7 | 0 | 7 | 1.920573122529644 | 1.920573122529644
Accessories | 358 | 51 | 0 | 51 | 12.87813131313131 | 51
Mono | 105 | 39 | 0 | 39 | 3.491136363636363 | 105
Rail | 16130 | 151 | 151 | 0 | 534 | 151
Car | 32012 | 222 | 222 | 0 | 855 | 855
Accessories | 51495 | 442 | 442 | 36 | 1290 | 36
Accessories | 13520 | 61 | 61 | 5 | 187 | 5
Accessories | 25491 | 362 | 362 | 3 | 750.4655615942028 | 3
TEST
Type | Units | Cartons | Cases | Picktickets | Packs | Helper
Truck | 3601 | 1818 | 45 | 41 | 61 | ?
Accessories | 2646 | 1928 | 8 | 18 | 362
Mono | 4516 | 2087 | 7 | 41 | 6
Rail | 2049 | 864 | 13 | 22 | 302
Car | 2085 | 961 | 3 | 57 | 173
Mono | 4963 | 2537 | 32 | 54 | 254
Rail | 4057 | 1989 | 4 | 40 | 193
Car | 1617 | 726 | 2 | 62 | 268
Accessories | 6097 | 2232 | 44 | 51 | 107
Motorcycle | 3992 | 2229 | 1 | 50 | 305
Truck | 4736 | 2426 | 8 | 54 | 58
Accessories | 3854 | 1862 | 4 | 35 | 237
Mono | 186 | 49 | 6 | 49 | 152
Rail | 79 | 7 | 3 | 7 | 114
Car | 358 | 51 | 7 | 4 | 271
Car | 16130 | 151 | 151 | 0 | 534
Spreadsheet: 46489d1245334999-summing-variable-data-across-rigid-boundaries-qty-problem
Sheet: Sheet1

 |  |  |  | Example of My Problem :)
 |  |  |  |  |  | Full Pitch m (from start to finsh)
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ---Colour coded reaches
 |  |  | Start (m) | Finish (m) | [NAME] (m3)
 |  | Day 1 | 1 | 3 | 1 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333
 |  | Day 2 | 1 | 6 | 4 | 0.6666666666666666 | 0.6666666666666666 | 0.6666666666666666 | 0.6666666666666666 | 0.6666666666666666 | 0.6666666666666666
 |  | Day 3 | 4 | 7 | 3 |  |  |  | 0.75 | 0.75 | 0.75 | 0.75
 |  | Day 4 | 4 | 8 | 5 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  | Day 5 | 7 | 10 | 2 |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5
 |  | Day 6 | 3 | 10 | 8 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | Reach 1 | 2 | M3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 5 |  | Reach 2 | 8.833333333333332 | M3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 |  | Reach 3 | 3.416666666666667 | M3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 8 |  | Reach 4 | 5.75 | M3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 10 |  | Reach 5 | 3 | M3
Spreadsheet: 90755d1290514460-excel-2007-finding-and-returning-the-numeric-cells-in-a-column-book1_bored
Sheet: Sheet1

abc 1 |  | abc 1
abc 2 |  | abc 2
abc 3 |  | abc 3
123 | 123
124 | 124
125 | 125
126 | 126
127 | 127
128 | 128
129 | 129
abc 11 |  | abc 11
abc 12 |  | abc 12
abc 13 |  | abc 13
#N/A |  |  |  | #N/A | #N/A
abc 15 |  | abc 15
abc 16 |  | abc 16
abc 17 |  | abc 17
abc 18 |  | abc 18
abc 19 |  | abc 19
#N/A |  |  |  | #N/A | #N/A
abc 21 |  | abc 21
abc 22 |  | abc 22
#N/A |  |  | #N/A |  | #N/A
abc 24 |  | abc 24
abc 25 |  | abc 25
2010-11-23 00:00:00 | 40505
abc 27 |  | abc 27
abc 28 |  | abc 28
abc 29 |  | abc 29
abc 30 |  | abc 30
abc 31 |  | abc 31
Spreadsheet: 866196d1713172275-excel-formula-to-find-out-what-workday-of-a-month-is-a-particular-date-sample-etaf
Sheet: Sheet1

 |  | Date | What working day of the month |  |  |  |  | Holidays 2024
 |  | 2024-01-02 00:00:00 | 1 |  |  |  |  | 2024-01-01 00:00:00
 |  | 2024-01-15 00:00:00 | 10 |  |  |  |  | 2024-03-29 00:00:00
 |  | 2024-01-19 00:00:00 | 14 |  |  |  |  | 2024-04-01 00:00:00
 |  | 2024-01-23 00:00:00 | 16 |  |  |  |  | 2024-05-06 00:00:00
 |  | 2024-02-01 00:00:00 | 1 |  |  |  |  | 2024-05-27 00:00:00
 |  | 2024-02-14 00:00:00 | 10 |  |  |  |  | 2024-08-26 00:00:00
 |  | 2024-02-15 00:00:00 | 11 |  |  |  |  | 2024-12-25 00:00:00
 |  |  |  |  |  |  |  | 2024-12-26 00:00:00
Spreadsheet: a54189db-d2a8-4407-b24e-f8a55073f155
Sheet: CHANGE RATE IN CELL

PREVIOUS RATE: |  | 0.48 |  | During Period: | 2005-09-21 00:00:00 | to | 2005-12-31 00:00:00
 |  | 0.445 |  | During Period: | 2006-01-01 00:00:00 |  | 2006-12-31 00:00:00
 |  | 0.485 |  | During Period: | 2007-01-01 00:00:00 |  | 2007-12-31 00:00:00
 |  | 0.505 |  | During Period: | 2008-01-01 00:00:00 | to | 2008-06-01 00:00:00
 |  | 0.585 |  | During Period: | 2008-07-01 00:00:00 | to | 2008-12-31 00:00:00
 |  | 0.55 |  | During Period: | 2009-01-01 00:00:00 | to | 2009-12-31 00:00:00
 |  | 0.5 |  | During Period: | 2010-01-01 00:00:00 | to | 2010-12-31 00:00:00
 |  | 0.51 |  | During Period: | 2011-01-01 00:00:00 | to | 2011-06-30 00:00:00
 |  | 0.555 |  | During Period: | 2011-07-01 00:00:00 | to | [NAME]
NEW RATE: | CURRENT: | 0.565 |  | During Period: | 2013-01-01 00:00:00 | to | [NAME]
Use for reimbursement effective January 1, 2013
56.5 ¢ per mile