tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0116e974-fb59-459a-b5d4-6c87531ddc5d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
TABLE 1
HEADCOUNT ENROLLMENT OF CREDIT STUDENTS
UNIVERSITY OF HAWAI‘I
Spring 2011
 |  |  | HEADCOUNT ENROLLMENT |  |  |  |  |  |  |  | Continuing Education Headcount
 |  |  | Total Headcount | V% |  | Regular Students | Special Subtotal | Early Admit
 | UH SYSTEM TOTAL |  | 56449 | 1 |  | 55982 | 467 | 467 |  |  | 2327
 | University of Hawai‘i at Mānoa |  | 19361 | 0.3429821608885897 |  | 19360 | 1 | 1 |  |  | 2283
 | University of Hawai‘i at Hilo |  | 3941 | 0.06981523144785559 |  | 3908 | 33 | 33
 | University of Hawai‘i - West O‘ahu |  | 1372 | 0.0243051249800705 |  | 1371 | 1 | 1
 | University of Hawai‘i, Community Colleges |  | 31775 | 0.5628974826834842 |  | 31343 | 432 | 432 |  |  | 44
 |  | Hawai‘i Community College | 3497 | 0.06194972453010682 |  | 3421 | 76 | 76
 |  | Honolulu Community College | 4292 | 0.07603323353823806 |  | 4255 | 37 | 37 |  |  | 44
 |  | Kapi‘olani Community College | 8736 | 0.1547591631384081 |  | 8690 | 46 | 46
 |  | Kaua‘i Community College | 1327 | 0.02350794522489327 |  | 1299 | 28 | 28
 |  | Leeward Community College | 7177 | 0.1271413133979344 |  | 7129 | 48 | 48
 |  | Maui Community College | 4313 | 0.07640525075732077 |  | 4148 | 165 | 165
 |  | Windward Community College | 2433 | 0.04310085209658276 |  | 2401 | 32 | 32
 | Notes:
 | 1. Percents may not sum due to rounding.
 | 2. The Total Headcount is the sum of Regular and Special students only.
 | 3. [NAME] counts are included in the Regular student count and are shown separately for information purposes only.
 | Counts for Continuing Education credit students at UH Mānoa (Outreach College) and Honolulu CC (SOCAD) are
 | identified by Credit Type field in IRO_Base which identifies students by registered term/academic period. This excludes
 | students who may have enrolled after the census date.
Spreadsheet: joe_parks__15015__PIRA Access Form1
Sheet: Sheet1

 |  | PIRA ACCESS FORM
Please provide the following information on the 10 Users who should have access to PIRA material; email the list to: [EMAIL]
Primary Contact Name | Title/Position | Company/Subsidiary | Mailing Address | City, State, Zip | [NAME] | Telephone | Fax
[NAME] | President | Bridgeline Holdings, L.P. | 333 Clay St. | Houston, TX 77002 | [EMAIL] | [PHONE] | [PHONE]
Other Names | Title/Position | Company/Subsidiary | Mailing Address | City, State, Zip | [NAME] | Telephone
[NAME] | VP Origination/Supply | Bridgeline Holdings, L.P. | 333 Clay St. | Houston, TX 77002 | [EMAIL]
Rich Cain | Dir. Origination | Bridgeline Holdings, L.P. | 333 Clay St. | Houston, TX 77002 | [EMAIL]
[NAME] | CFO | Bridgeline Holdings, L.P. | 333 Clay St. | Houston, TX 77002 | [EMAIL]
[NAME] | VP Operations/Engineering | Bridgeline Holdings, L.P. | 333 Clay St. | Houston, TX 77002 | [EMAIL]
[NAME] | Sr. Trader | Bridgeline Holdings, L.P. | 333 Clay St. | Houston, TX 77002 | [EMAIL]
Tiffany Smith | Sr. Trader | Bridgeline Holdings. L.P. | 333 Clay St. | Houston, TX 77002 | [EMAIL]
[NAME] | Sr. Trader | Bridgeline Holdings, L.P. | 333 Clay St. | Houston, TX 77002 | [EMAIL]
[NAME] | Sr. Trader | Bridgeline Holdings, L.P. | 333 Clay St. | Houston, TX 77002 | [EMAIL]
Spreadsheet: 107255d1304456797-excel-2007-instead-of-vlookup-book3
Sheet: Sheet1

 | Country | City | Street
[NAME] | Netherlands | [NAME] | [NAME]
[NAME] | Germany | Munich | MunichStreet1
[NAME] | Britain | London | Bacon Street (E1)
 |  |  | IF [NAME] IS SELECTED |  | SELECT NAME: | [NAME]
 |  |  | Netherlands | [NAME] | [NAME]
 |  | colkeyrange | D11:F11
 |  |  | THIS MUST BE THE VALUE THAT NEEDS TO BE SELECTED
 |  |  | SO later IF I CHOOSE THIS COL KEY RANGE THE VALUES IN THOSE COLUMN MUST BE ACCESSED in my BPC processes
Spreadsheet: 59888d1260408402-excel-2007-what-if-analysis-palak-shah-palm-city-police-department-analysis
Sheet: Sheet1

Precinct | Violent Population | Police Crimes | Officers | Residents per officer | Crimes per officer
Shea Blvd. | 99552 | 318 | 85 | 1172 | 4
Lakeland Heights | 99223 | 582 | 108 | 919 | 6
Sunnydale | 68432 | 206 | 77 | 889 | 3
Old Town | 47732 | 496 | 55 | 868 | 10
Mountainview | 101233 | 359 | 82 | 1235 | 5
Financial District | 58102 | 511 | 70 | 831 | 8
Riverdale | 78903 | 537 | 70 | 1128 | 8
[NAME] | 75801 | 306 | 82 | 925 | 4
Total | 625978 | 3315 | 629 | 996 | 6
Per Officer | 995.196 | 5.27
Spreadsheet: 43607d1242245242-can-you-add-sum-based-on-dates-time-20example_daddy
Sheet: Weekly Time

Branch: Richmond |  |  |  |  | Pay Period From: | 2009-01-01 00:00:00 | To: | 2009-01-07 00:00:00
Name |  | Employee # | Regular Hrs | [NAME] | Holiday | Personal | Vacation | Total
[NAME] | Jones | 0231 | 8 | 0 | 0 | 0 | 0 | 8
[NAME] | Smith | 1495 | 0 | 0 | 0 | 8 | 0 | 8
Fred | [NAME] | 2111 | 4 | 0 | 0 | 4 | 0 | 8
Wayne | Barker | 3094 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Hodges | 3672 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Castle | 5334 | 0 | 0 | 0 | 0 | 0 | 0
Walter | [NAME] | 6243 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Reynolds | 7112 | 0 | 0 | 0 | 0 | 0 | 0
Gene | [NAME] | 8442 | 0 | 0 | 0 | 0 | 0 | 0
Blank | Blank | Blank | 0 | 0 | 0 | 0 | 0
Blank | Blank | Blank | 0 | 0 | 0 | 0 | 0
Blank | Blank | Blank | 0 | 0 | 0 | 0 | 0
Blank | Blank | Blank | 0 | 0 | 0 | 0 | 0
Blank | Blank | Blank | 0 | 0 | 0 | 0 | 0
Blank | Blank | Blank | 0 | 0 | 0 | 0 | 0
Blank | Blank | Blank | 0 | 0 | 0 | 0 | 0
Blank | Blank | Blank | 0 | 0 | 0 | 0 | 0
Blank | Blank | Blank | 0 | 0 | 0 | 0 | 0
Blank | Blank | Blank | 0 | 0 | 0 | 0 | 0
 | Technicians Total |  | 0 | 0 | 0 | 0 | 0 | 24
[NAME] | [NAME] | 85646 |  |  |  |  |  | 0
Pam | Seford | 8874 |  |  |  |  |  | 0
(1) Copy to Accounting every Monday by 9:00 am
(1) Copy for Branch Manager |  |  |  |  | Branch Manager Signature:
Spreadsheet: 812047d1672926147-how-to-use-unique-function-match-multiple-criteria-match-2-criteria-with-one-being-an-or-result
Sheet: Material - Materials

 | Category (All) | Station
 | Material | 50 |  | CW 2022 |  |  |  |  | CW 2023 |  |  | Responsible | CW1
 | Sub Category | Count | Mins | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | AVG MTTF (hrs / min) | AVG MTTF Downtime (min)
 | Material Handling
 | C/O - WL to WL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index match 2 cells, then drag formula to return unique results w/o leaving blank results
 | Ford damper label (2nd instance) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In cell C4 I'm trying to return another cells data by using index match, which I can get to work. However, if I drag the formula, the formula only returns the first result in the data that it found. Dragging also creates #N/A errors. Is it possible for the formula to return all unique results by skipping over duplicates and not leaving blanks?
 | Waiting on dampers
 | Dampers with different mixed colored dots
 | Station empty
 | Labor shortage
Spreadsheet: 640800d1568090332-allocation-formula-to-allocate-excess-stocks-to-required-inter-trasnfer-file-test-1-
Sheet: Sheet1

Sku Code | To Store | Incoming Stock opening | Qty Needed | cumulative requested | From | Total incoming /sku/store | Total requested /sku/store | Allocated | Balance | Action |  | Allocated | Balance | Action
1000058 | HKP06 | 6 | 3 | 3 | hpp28 |  |  |  |  |  |  | 3 | 3 | Allocated
1000058 | HHP20 | 6 | 4 |  | hpp28 |  |  |  |  |  |  | 3 | 0 | Partial Allocation
1000058 | HHP30 | 6 | 4 |  | hpp28 |  |  |  |  |  |  | 0 | 0 | No Allocation
1000058 | HHP28 | 6 | 7 |  | hpp28 |  |  |  |  |  |  | 0 | 0 | No Allocation
1000060 | HHP27 | 9 | 2 |  | hpp28 |  |  |  |  |  |  | 2 | 7 | Allocated
1000060 | HKP22 | 9 | 5 |  | hpp28 |  |  |  |  |  |  | 5 | 2 | Allocated
1000061 | [NAME] | 0 | 1 |  | hpp28 |  |  |  |  |  |  | 0 | 0 | No Allocation
1000061 | HKP25 | 0 | 1 |  | hpp28 |  |  |  |  |  |  | 0 | 0 | No Allocation
1000061 | HKP06 | 0 | 2 |  | hpp28 |  |  |  |  |  |  | 0 | 0 | No Allocation
 |  |  |  |  |  |  |  |  |  |  |  | Result should be
Spreadsheet: 844881d1696513506-formatting-cell-if-date-is-greater-than-x-months-ago-calibrationschedule-sample-
Sheet: 0-1 Mic

Unit | Gage No. | Issued To | Calibration Cycle (Months) | Date | Reading | %Error
0-1 Mitutoyo | 750 | [NAME] | 3 | 2023-07-18 00:00:00 | 0.2 | 0
 |  |  |  |  | 0.22 | 0
 |  |  |  |  | 0.25 | 0
0-1 Mic Start | 9 | [NAME] | 3 | 2023-04-15 00:00:00 | 0.15 | 0
 |  |  |  |  | 0.17 | 0
 |  |  |  |  | 0.185 | 0
0-1 Mic | 8 | [NAME] | 6 | 2023-04-23 00:00:00 | 1 | 0
 |  |  |  |  | 0.15 | 0
 |  |  |  |  | 0.175 | 0
0-1 Mic | 2 | [NAME] | 6 | 2023-04-23 00:00:00 | 0.1 | 0
 |  |  |  |  | 0.25 | 0
 |  |  |  |  | 0.5 | 0
0-1 Mic | 3 | [NAME] | 12 | 2023-07-12 00:00:00 | 0.1 | 0
 |  |  |  |  | 0.25 | 0
 |  |  |  |  | 0.3 | 0
0-1 Mic | 807 | [NAME]. P | 3 | 2023-06-20 00:00:00 | 0.08 | 0
 |  |  |  |  | 0.108 | 0
 |  |  |  |  | 0.17 | 0
Spreadsheet: 127299e7-75ae-40f3-a3f7-3c3fb5b5485d
Sheet: NPV1

NPV function: NPV(rate, value1, [NAME], ….)
Interest rate: | 0.06
Period | 0 | 1 | 2 | 3 | 4 | 5
Cost |  | 95000
Benefit |  |  | 8000 | 8000 | 8000 | 108000
Total Cash Flow
Net Present Value
Spreadsheet: 01b3bf87-025c-4934-8acc-f731b482fcc8
Sheet: Corporate VC Deal Stages

Total Venture Capital and Corporate Venture Capital by Deal Stage - Last 7 Quarters
01/01/2011-09/30/2012
Company Stage as of Investment Round | Total # Deals | Average $M Per Deal | Total $M Invested in that Stage by All VC Types | # Deals with CVC Participation | Avg. CVC investment in Those Rounds Participated In | $ CVC Investment | % of CVC Investment $ | % of Deals with CVC Involvement | CVC % of $ In Sector
Seed | 632 |  | 1608.4 | 54 |  | 66.76
Early Stage | 2701 |  | 14476.5 | 369 |  | 1071.31
Expansion | 1721 |  | 16882 | 323 |  | 1596.26
Later Stage | 1524 |  | 16286.2 | 241 |  | 1251.78
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 881675d1729796181-four-linked-index-match-worksheets-and-col-a-misalignment-with-manually-entered-data-grant-tracker-2024-design-v2
Sheet: FilterBlanks (2)

Grant/Award Name |  | This sheet is used solely to filter out blank rows for the Tracker sheet.
Spreadsheet: ada6062b-c14d-4ab1-88f0-05cd1919433f
Sheet: North, Vista

ATTACHMENT 9 PRICE SCHEDULE
NORTH COUNTY
 | Service address:
 | North County Division
 | 325 South Melrose Drive
 | Vista, CA 92081
 | MODEL | SERIAL # | [NAME] ID# | OLD ID # | PRICE Base Year | PRICE Year 1 | PRICE Year 2 | PRICE Year 3 | PRICE Year 4
1 | AMANO PIX 3000 | 343048095 | 2258 | 71548
2 | AMANO PIX 3000 | 321145909 | 2260 | 93184
3 | AMANO PIX 3000 | 302130086 | 2259 | 90191
4 | [NAME] | 302982 | 2185 | 76592
5 | [NAME] | 369458 | 2239 | 76609
6 | WHITAKER ET | 855852BF | 2232 | 91226
7 | WHITAKER ET | 855847BF | 2241 | 91219
8 | WHITAKER ET | 855848BF | 2190 | 91220
9 | WHITAKER ET | 855844BF | 2234 | 91227
10 | WHITAKER ET | 855855BF | 2378 | 91216
11 | WHITAKER ET | 855851BF | 2163 | 91222
12 | [NAME]. | 866961HG | 2272 | 91909
13 | WHITAKER ET | 866960HG | 2164 | 10255
14 | [NAME]. | 855849BF | 2401 | 91215
15 | [NAME]. | 866947HG | 2269 | 90493
16 | WIDMER T-3 | 157706 | 2189 | 76622
17 | [NAME] | 507996 | 2233 | 10518
18 | [NAME] | 508113 | 2237 | 10519
19 | [NAME] | 504927 | 2151 | 10448
20 | [NAME] | 507406 | 2230 | 10442
21 | [NAME] | 507407 | 2158 | 10441
22 | [NAME] | 507411 | 2264 | 10438
23 | [NAME] | 507412 | 2992 | 10440
24 | [NAME] | 507413 | 2243 | 10439
25 | [NAME] | 507416 | 2231 | 10447
26 | [NAME] | 509998 | 2153
27 | [NAME] | 509999 | 2240
28 | [NAME] | 510000 | 2236
29 | WIDMER T-3 | 161147 | 2165 | 10653
30 | WIDMER T-3 | 162470 | 2270 | 10996
31 | WHITAKER ET | 851959HE | 2271 | 77556
32 | WHITAKER ET | 854878SE | 2275 | 91225
33 | WHITAKER ET | 855854BF | 2277 | 91218
34 | WHITAKER ET | 855845BF | 2535 | 10603
35 | [NAME] | 507414 | 2276 | 10445
36 | [NAME] | 507415 | 2274 | 10446
37 | [NAME] | 283052 | 2056 | 91270
38 | [NAME] | 369457 | 2054 | 76384
39 | [NAME] | 507452 | 2055
40 | [NAME] | 507453 | 2051
41 | [NAME] | 507454 | 2053 | 10493
42 | [NAME]. | 854869SE | 2057 | 91067
43 | WIDMER T-3 | 198639 | 2536
44 | [NAME] | 396874 | 2152 | 76411
45 | [NAME] | 507408 | 3042 | 10443
46 | RAPIDPRINT ARL-E | 491163 | 2052 | 2052
47 | [NAME] | 376491 | 2442 | 76414
48 | WIDMER E-3 Embosser | 177875 | 3282 | 10724
49 | [NAME] | 362083 | 2186
50 | WIDMER N3 Numbering | 154735 | 2191
51 | WIDMER | 165975 | 2229
52 | WHITAKER ET | 0133224MN | 2555 | 20541
53 | Widmer T-3 | 165976 | 2273
 |  |  | TOTAL *
 |  |  | * transfer these totals to summary sheet
Spreadsheet: 828440d1683489632-moved-from-libreoffice-to-excel-365-i-dont-know-why-formula-broke-oekonomi-marstal-ophold-help-me
Sheet: Offdays Automatic

Offday Calculator
Start |  |  |  | Salery Period |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacationdays spend |  | Paid Offdays |  | Result
Start date | 2022-12-21 00:00:00 |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Balance | 78.58 |  |  | To
Vacation days |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
Total | 42
Spend |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 0
Result |  |  |  | To
Rates
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 0
Hjemme | -1 |  |  | To
Mønstring | 0.82
[NAME] | 0.82 |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 80
Sygdom | 0 |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 0
 | From | To |  | To
Mønstring | 2023-01-11 00:00:00 | 2023-03-12 00:00:00 |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Mønstring | 2023-04-04 00:00:00 | 2023-05-20 00:00:00 |  | To
Mønstring | 2023-06-27 00:00:00 | 2023-08-08 00:00:00
Mønstring | 2023-09-19 00:00:00 | 2023-10-17 00:00:00 |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 0
Mønstring | 2023-11-16 00:00:00 | 2023-12-18 00:00:00 |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
Spreadsheet: 740210d1626241195-trying-to-interpolate-a-table-help-please
Sheet: Sheet1

 | 85 | 80 | 75 | 70 | 65 | 60 | 55 | 50 | 45 | 40
41 |  |  |  |  | 30 | 7 | 0 | 4 | 16 | 33
 |  |  |  | 22 | 4 | 0 | 4 | 15 | 30 | 45
 |  | 37 | 14 | 2 | 0 | 5 | 15 | 28 | 43 | 56
 | 23 | 7 | 0 | 0 | 6 | 16 | 28 | 41 | 54 | 64
 | 2 | 0 | 2 | 8 | 18 | 29 | 41 | 53 | 62 | 68
 | 0 | 4 | 11 | 21 | 31 | 42 | 52 | 61 | 67 | 70
 | 7 | 15 | 24 | 34 | 43 | 53 | 61 | 67 | 70 | 70
 | 19 | 27 | 36 | 45 | 54 | 61 | 66 | 70 | 70 | 68
 | 31 | 40 | 48 | 55 | 62 | 67 | 70 | 70 | 69 | 64
 | X | 50 |  |  | [NAME]'s Answer
 | Y | 31
 | ------------------------------------------------------------------------------------------------------------------------------------------------------
 | X | 57.5 |  | Answer should be 52
 | Y | 30 |  |  | [NAME]'s [NAME]
Spreadsheet: 837485d1690203999-need-calculate-duplicate-count-based-on-date-count-will-start-from-old-date-to-new-date-excel-forum-help
Sheet: Sheet1

IMEI Number | Shuffling Request Date | Result | I Want in this Sequence
869657069447735 | 2023-07-19 00:00:00 |  | 6
869657069447735 | 2023-07-18 00:00:00 |  | 5
869657069447735 | 2023-07-18 00:00:00 |  | 4
869657069447735 | 2023-07-17 00:00:00 |  | 3
869657069447735 | 2023-07-10 00:00:00 |  | 2
869657069447735 | 2023-07-04 00:00:00 |  | 1
Spreadsheet: 474819d1470922013-how-to-find-data-from-multiple-sheets-to-a-single-sheet-as-shown-in-sample-file-how-to-find-data
Sheet: Sheet1

Share Holding Percentage
Name | Date | Sponsor/Director | Govt | Institute | Foreign | Public
AAMRATECH | 2015-12-31 00:00:00 | 13.9 | 0.57 | 57.06 | 1.84 | 26.63
AAMRATECH | 2016-02-29 00:00:00 | 13.9 | 0.57 | 57.2 | 1.5 | 26.83
AAMRATECH | 2015-12-31 00:00:00 | 13.9 | 0.57 | 57.27 | 1.49 | 26.77
ABB1STMF | 2015-06-30 00:00:00 | 20 | 0 | 45.23 | 0 | 34.77
ABB1STMF | 2016-02-29 00:00:00 | 20 | 0 | 60.96 | 0 | 19.04
ABB1STMF | 2016-05-31 00:00:00 | 20 | 0 | 63.08 | 0 | 16.92
Spreadsheet: 295226d1391625518-editing-large-amounts-of-data-test-book-for-excel-forum
Sheet: Sheet1

 |  | North Hollywood | CA | 91606-4120 |  |  |  |  | North Hollywood | CA | 91606-4120
 |  | Studio City | CA | 91614 |  |  |  |  | Studio City | CA | 91614
 |  | [NAME] | CA | 91708-0145 |  |  |  |  | [NAME] | CA | 91708-0145
 |  | [NAME] | CA | 91709-1273 |  |  |  |  | [NAME] | CA | 91709-1273
 |  | [NAME] | CA | 91709-2419 |  |  |  |  | [NAME] | CA | 91709-2419
 |  | [NAME] | CA | 91709-8809 |  |  |  |  | [NAME] | CA | 91709-8809
 |  | [NAME] | CA | 91710 |  |  |  |  | [NAME] | CA | 91710
 |  | Claremont | CA | 91711 |  |  |  |  | Claremont | CA | 91711
 |  | Covina | CA | 91723 |  |  |  |  | Covina | CA | 91723
What I have. . . |  | [NAME] | CA | 91730-3171 |  | What I would like. . . |  |  | [NAME] | CA | 91730-3171
 |  | Rancho Cucamonga | CA | 91730-5627 |  |  |  |  | Rancho Cucamonga | CA | 91730-5627
 |  | Rancho Cucamonga | CA | 91730-8110 |  |  |  |  | Rancho Cucamonga | CA | 91730-8110
 |  | Alta Loma | CA | 91737-2341 |  |  |  |  | Alta Loma | CA | 91737-2341
 |  | Alta Loma | CA | 91737-2905 |  |  |  |  | Alta Loma | CA | 91737-2905
 |  | [NAME] | CA | 91741 |  |  |  |  | [NAME] | CA | 91741
 |  | [NAME] | CA | 91745 |  |  |  |  | [NAME] | CA | 91745
 |  | [NAME] | CA | 91745 |  |  |  |  | [NAME] | CA | 91745
 |  | [NAME] | CA | 91750 |  |  |  |  | [NAME] | CA | 91750
 |  | [NAME] | CA | 91750-2387 |  |  |  |  | [NAME] | CA | 91750-2387
 |  | Ontario | CA | 91761-5343 |  |  |  |  | Ontario | CA | 91761-5343
 |  | Ontario | CA | 91764-2254 |  |  |  |  | Ontario | CA | 91764-2254
 |  | Diamond Bar | CA | 91765-1816 |  |  |  |  | Diamond Bar | CA | 91765-1816
 |  | [NAME] | CA | 91766 |  |  |  |  | [NAME] | CA | 91766
 |  | Rosemead | CA | 91770-1605 |  |  |  |  | Rosemead | CA | 91770-1605
 |  | San Dimas | CA | 91773-3128 |  |  |  |  | San Dimas | CA | 91773-3128
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 19565 | 19737
2 | 19701 | 19737
3 | 19719 | 19737
4 | 19712 | 19737 |  | -10000 |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 19700 | 19737 |  | -50
6 | 19696 | 19737 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7 | 22849 | 22895
8 | 19738 | 19737 |  |  |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 | 19291 | 19737 | -10996 | -25000 |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 | 19791 | 19737 | -1092 | -9593 |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 | 39582 | 39737 | -16072 | -25000 |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13
14 |  |  |  |  |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15
16 |  |  |  |  |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 159450
2001-12-11 00:00:00
CBS Dollars
 |  |  | 416892
Spreadsheet: 873388d1719887517-overlapping-schedule-conditional-formatting-issue-sync_tool_final_draft_fna_review-fazalnajeeb-
Sheet: Hourly Plan_new_edit

 | Starting Date |  | 2024-03-01 00:00:00
 |  |  | 0
ID | Measurement Station | Start Date & Time | End Date & Time | Start Date & Time Gamry1 | End Date & Time Gamry1 | Start Date & Time Gamry2 | End Date & Time Gamry2 | Start Date & Time Gamry3 | End Date & Time Gamry3 | Start Date & Time Gamry4 | End Date & Time Gamry4 | Start Date & Time Gamry5 | End Date & Time Gamry5 | Start Date & Time Gamry6 | End Date & Time Gamry6 | Start Date & Time Gamry7 | End Date & Time Gamry7 | Start Date & Time Gamry8 | End Date & Time Gamry8 | Start Date & Time Gamry9 | End Date & Time Gamry9 | Start Date & Time Gamry10 | End Date & Time Gamry10
1 | MS1 | 2024-03-01 07:50:00 | 2024-03-03 11:40:00
2 | MS2 | 2024-03-01 15:00:00 | 2024-03-03 15:00:00
3 | MS3 | 2024-03-02 15:00:00 | 2024-03-04 15:00:00
4 | MS4 | 2024-03-02 15:00:00 | 2024-03-05 15:00:00
5 | [NAME] | 2024-03-03 15:00:00 | 2024-03-05 08:00:00
6 | MS6 | 2024-03-03 15:00:00 | 2024-03-07 07:00:00
7 | MS7 | 2024-03-05 15:00:00 | 2024-03-08 22:00:00
8 | MS8 | 2024-03-05 15:00:00 | 2024-03-09 15:00:00
Credit: ExcelAir
Spreadsheet: 287146d1388669193-auto-populating-autopopulate
Sheet: Sheet1

Day | Month | Shift | Time
 |  | 3rd | 11-12AM
 |  | 3rd | 12-1AM
 |  | 3rd | 1-2AM
 |  | 3rd | 2-3AM
 |  | 3rd | 3-4AM
 |  | 3rd | 4-5AM
 |  | 3rd | 5-6AM
 |  | 3rd | 6-7AM
 |  | 1st | 7-8AM
 |  | 1st | 8-9AM
 |  | 1st | 9-10AM
 |  | 1st | 10-11AM
 |  | 1st | 11-12PM
 |  | 1st | 12-1PM
 |  | 1st | 1-2PM
 |  | 1st | 2-3PM
 |  | 2nd | 3-4PM
 |  | 2nd | 4-5PM
 |  | 2nd | 5-6PM
 |  | 2nd | 6-7PM
 |  | 2nd | 7-8PM
 |  | 2nd | 8-9PM
 |  | 2nd | 9-10PM
 |  | 2nd | 10-11PM
 |  | 3rd | 11-12AM
 |  | 3rd | 12-1AM
 |  | 3rd | 1-2AM
 |  | 3rd | 2-3AM
 |  | 3rd | 3-4AM
 |  | 3rd | 4-5AM
 |  | 3rd | 5-6AM
 |  | 3rd | 6-7AM
 |  | 1st | 7-8AM
 |  | 1st | 8-9AM
 |  | 1st | 9-10AM
 |  | 1st | 10-11AM
 |  | 1st | 11-12PM
 |  | 1st | 12-1PM
 |  | 1st | 1-2PM
 |  | 1st | 2-3PM
 |  | 2nd | 3-4PM
 |  | 2nd | 4-5PM
 |  | 2nd | 5-6PM
 |  | 2nd | 6-7PM
 |  | 2nd | 7-8PM
 |  | 2nd | 8-9PM
 |  | 2nd | 9-10PM
 |  | 2nd | 10-11PM
Spreadsheet: 182305d1348418443-fetching-data-from-a-table-into-a-more-compact-form-result
Sheet: Arkusz1

Input table: |  |  | Wine  1 | Wine  2 | Wine  3 | Wine  4 | Wine  5 | Wine  6 | Wine  7 | Wine  8 | Wine  9 | Wine  10 | Wine  11 | Wine  12 | Wine  13 | Wine  14 | Wine  15 | Wine  16 | Wine  17 | Wine  18 | Wine  19 | Wine  20
 | Name 1 |  | 1 |  |  |  | 5 |  |  |  |  |  | 6 |  |  |  |  | 7
 | Name 2 |  |  |  | 2 |  |  | 3 |  |  |  | 3 |  |  |  |  |  |  |  | 1
 | Name 3 |  | 5 |  |  | 7 |  |  |  |  | 8 |  |  |  |  |  |  | 1
 | Name 4 |  | 2 |  |  |  |  | 3 |  | 3 |  |  |  |  | 4 |  |  |  |  | 6 |  | 1
 |  | helper column
 |  |  |  | Bottles
Spreadsheet: 872688d1719052571-using-large-match-and-index-but-not-finding-second-duplicate-score-match-example-v4-njb
Sheet: Scores

 |  | 100 |  | [NAME]
 |  | 104 |  | [NAME]
 |  | 134 |  | [NAME]
 |  | 112 |  | [NAME]
 |  | 123 |  | [NAME]
 |  | 87 |  | [NAME]
 |  | 143 |  | [NAME]
 |  | 116 |  | [NAME]
 |  | 123 |  | [NAME]
 |  | 112 |  | [NAME]
 |  | 120 |  | [NAME]
 |  | 126 |  | [NAME]
 | Pos | Sc | position in list
 | 1 |  |  |  |  | 1st
 | 2 |  |  |  |  | 2nd
 | 3 |  |  |  |  | 3rd
 | 4 |  |  |  |  | 4th
 | 5 |  |  |  |  | 5th
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12