tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 740012d1626139513-formula-to-pull-only-the-differences-between-sheets-occ-geo-template-sample-7-11-2021-3-
Sheet: (A) OCC-GEO

Employee Number | Xref | First Name | Last Name | Position | OCC | GEO | Employee Group Name
500079 | 500079 | ABEL | HERNANDEZ | 11002 - AK C/P Production - MP1770 - FACTORY MANAGER - CASE | 11-1021 | 73 | [NAME] Enterprise
501287 | 501287 | CONNIE | CORPUS | 11002 - AK C/P Production - MP2501 - SEAFOOD PROCESSOR - CASE | 51-3022 | 73 | [NAME] Enterprise
503418 | 503418 | MARTIN | ESPINOZA | 11002 - AK C/P Production - MP2501 - SEAFOOD PROCESSOR - CASE | 51-3022 | 20 | Island Enterprise
503771 | 503771 | NELSON | DAPAR | 20072 - AK C/P Galley - HS0510 - GALLEY ASST - CASE | 35-2021 | 73 | [NAME] Enterprise
504001 | 504001 | OLVIN | HERNANDEZ | 11002 - AK C/P Production - MP1720 - FACTORY FOREMAN - CASE | 51-1011 | 73 | [NAME] Enterprise
504734 | 504734 | [NAME] | LEBEL | 20010 - Day Rate Labor - MA3330 - FILLET TECH - DAILY | 51-3092 | 73 | [NAME] Enterprise
504769 | 504769 | RUBEN | POQUIZ | 20071 - AK [NAME] - VESSEL | 35-2021 | 20 | Independence
506754 | 506754 | [NAME] | ALLEN | 20010 - Day Rate Labor - MA3100 - MATE LICENSED - DAILY | 53-5021 | 20 | Freighter
506890 | 506890 | RICHARD | NICHOLSON | 30000 - AK Shore Salaries - Plant - OL1500 - ASST PLANT MANAGER - SHOREPLANT | 11-1021 | 57 | [NAME]
506922 | 506922 | VICTOR | COLTON | 11002 - AK C/P Production - MP1720 - FACTORY FOREMAN - CASE | 51-1011 | 20 | Island Enterprise
507074 | 507074 | [NAME] | POSADA | 11002 - AK C/P Production - MP1730 - ASST FACTORY FOREMAN - CASE | 51-1011 | 73 | [NAME] Enterprise
507280 | 507280 | HUNG | PHAN | 11002 - AK C/P Production - MP2501 - SEAFOOD PROCESSOR - CASE | 51-3022 | 73 | [NAME] Enterprise
507614 | 507614 | HUNG | TRUONG | 11002 - AK C/P Production - MP2501 - SEAFOOD PROCESSOR - CASE | 51-3022 | 20 | Island Enterprise
507772 | 507772 | [NAME] | DIAZ | 11002 - AK C/P Production - MP2501 - SEAFOOD PROCESSOR - CASE | 51-3022 | 20 | Island Enterprise
539388 | 539388 | BRADLEY | BEIER | 20128 - AK C/P Engine Room - MA3400 - FACTORY ENGINEER - CASE | 53-5031 | 73 | [NAME] Enterprise
539532 | 539532 | DANIEL | ROOT | 10003 - AK Shore Meal Plant - MP1100 - MEAL PLANT - SUPVSR | 45-1011 | 55 | [NAME]
540012 | 540012 | ADOLFO | CALLEJA MARIN | 11002 - AK C/P Production - MP2501 - SEAFOOD PROCESSOR - CASE | 51-3022 | 73 | [NAME] Enterprise
540100 | 540100 | [NAME] | SMITH | 20010 - Day Rate Labor - QY1400 - FSQA MANAGER - FACTORY TRAWLERS | 11-1021 | 73 | [NAME] Enterprise
540971 | 540971 | WAYNE | RICKARDS | 20010 - Day Rate Labor - MA3000 - MASTER LICENSED - DAILY | 53-5021 | 20 | Freighter
Spreadsheet: 206893d1358299946-need-help-with-re-sorting-a-list-that-i-am-working-on-sample-data
Sheet: Unit price (2)

WHAT I CURRENT HAVE |  |  | WHAT I WANT TO HAVE
(SMALL SAMPLE) |  |  | (LESS THE BOLD-FACE FORMAT AND SMALL FONTS)
PART_ID | UNIT_PRICE |  | PART_ID | UNIT_PRICE |  |  | PART_ID | UNIT_PRICE
077-1598 | 89500 |  | 077-1598 | 89500
411-0850 | 82000 |  | 411-0850 | 82000
920-0691 | 66825 |  | 411-0850 | 47628
920-0681 | 63990 |  | 920-0691 | 66825
412-0001 | 48600 |  | 920-0681 | 63990
412-0001 | 48600 |  | 412-0001 | 48600
411-0850 | 47628 |  | 412-0001 | 48600
411-1000 | 47628 |  | 412-0001 | 42700
520-0286 | 43850.43 |  | 412-0001 | 42100
520-0286 | 43104.97 |  | 412-0001 | 40500
412-0001 | 42700 |  | 412-0001 | 40095
412-0001 | 42100 |  | 412-0001 | 39700
412-0001 | 40500 |  | 412-0001 | 39700
412-0001 | 40095 |  | 412-0001 | 39700
412-0001 | 39700 |  | 412-0001 | 39150
412-0001 | 39700 |  | 411-1000 | 47628
412-0001 | 39700 |  | 520-0286 | 43850.43
412-0000 | 39500 |  | 520-0286 | 43104.97
412-0000 | 39500 |  | 412-0000 | 39500
412-0000 | 39500 |  | 412-0000 | 39500
412-0000 | 39500 |  | 412-0000 | 39500
412-0000 | 39150 |  | 412-0000 | 39500
412-0001 | 39150 |  | 412-0000 | 39150
412-0000 | 38925 |  | 412-0000 | 38925
412-0000 | 38925 |  | 412-0000 | 38925
412-0000 | 38925 |  | 412-0000 | 38925
412-0000 | 38925 |  | 412-0000 | 38925
412-0000 | 37825 |  | 412-0000 | 37825
412-0000 | 37825 |  | 412-0000 | 37825
412-0000 | 35880 |  | 412-0000 | 35880
412-0000 | 34938 |  | 412-0000 | 34938
Spreadsheet: 05a550d0-86dd-4184-b78f-502bbe44e061
Sheet: Sheet1

1992 - 36th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | [NAME], Stuttgart, Germany |  |  |  |  | 1992-09-19 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | USA | [NAME] | [NAME] | Herschend | [NAME] | D-Aspen | Przyemysl/Poland | 964.19 | 1900-01-01 21:36:00
2 | GER | Eimers | Wilhelm | Landsmann | Bernd | D-Columbus | Kielce/Poland | 882.7 | 1900-01-01 21:19:00
3 | AUT | Starkbaum | [NAME] | Scholz | Gerd | OE-PZS Polarstern | [NAME] | 872.34 | 1900-01-01 22:12:00
4 | SUI | Signer | Gerold | Osterwalder | Silvan | HB-BJB Solvay | Wojnicz/Poland | 850.78 | 1900-01-01 20:26:00
5 | GER | Kuinke | Volker | [NAME] | [NAME] | D-ODUS Düsseldorf | Piotrkow/Poland | 807.94 | 1900-01-01 19:17:00
6 | SUI | Sutter | Rolf | [NAME] | Kurt | HB-BTE  [NAME] | [NAME]Poland | 799.54 | 1900-01-01 16:41:00
7 | AUT | Lewetz | [NAME] | Wagner | [NAME] | OE-ZZI | Dzierzgow/Poland | 797.56 | 1900-01-02 06:28:00
8 | AVI | Soukup | [NAME] | Fraenckel | [NAME] | D-Caribbean | [NAME] Poland | 670.87 | 1900-01-01 15:30:00
9 | USA | [NAME] | [NAME] | Senez | [NAME] | N1636S Spirit of Sprinfield | Senica/ Chechoslovakia | 591.77 | 1900-01-01 23:09:00
10 | SUI | Spenger | [NAME] | Stoll | Christian | HB-BVZ  [NAME] | Niemca/Poland | 587.63 | 1900-01-01 13:35:00
11 | POL | Makne | [NAME] | [NAME] | Grzegorz | SP-BWH | Ogrodnica/Poland | 584.32 | 1900-01-02 14:09:00
12 | GBR | [NAME] | [NAME] | Wilkinson | [NAME] | G-BIHP Belgica | [NAME] | 514.96 | 23:03:00
13 | FRA | Hennequet | Bertrand | Leys | Vincent | F-GIRE | Strizov/ Chechoslovakia | 481.97 | 23:06:00
14 | GER | [NAME] | Heinz | Sjuts | Helma | D-Ruhrpott | Volevcice/Telc/ Chechoslovakia | 455.35 | 23:45:00
Spreadsheet: 810055d1671516104-how-to-index-match-with-multiple-criteria-when-having-some-identical-data-example-match-id
Sheet: Sheet1

 | Year | 2022 |  | Month | 8
Date | Description | Section | Category | Month | Year | Amount
2022-08-31 00:00:00 | [NAME] | Section 2 | Category 5 |  |  | 296
2022-08-29 00:00:00 | ethatreh | Section 1 | Category 5 |  |  | 76
2022-08-27 00:00:00 | aeha | Section 4 | Category 5 |  |  | 259
2022-08-21 00:00:00 | jr6tsjrtsjyrt | Section 2 | Category 5 |  |  | 383
2022-08-19 00:00:00 | rhtrs | Section 5 | Category 5 |  |  | 343
2022-08-19 00:00:00 | sthstrjhtrje67ju7r6 | Section 5 | Category 3 |  |  | 413
2022-08-12 00:00:00 | shgsrtjhtrsjsrj | Section 1 | Category 5 |  |  | 8
2022-08-10 00:00:00 | reaghe | Section 2 | Category 1 |  |  | 48
2022-08-05 00:00:00 | gwaefergagh | Section 5 | Category 2 |  |  | 341 |  |  |  | Date | Amount | Rank
2022-08-19 00:00:00 | fszfzsgzdrgrewe | Section 3 | Category 3 |  |  | 197 |  |  |  |  |  | 1
2022-08-18 00:00:00 | esgt5esgh | Section 4 | Category 1 |  |  | 340
2022-08-17 00:00:00 | drgaegaergeargae | Section 5 | Category 2 |  |  | 355 |  |  |  |  |  |  | << First occurrence is indeed 8/17/22
2022-08-15 00:00:00 | sye5 | Section 4 | Category 2 |  |  | 303 |  |  |  |  |  |  | << Second occurrence should be 08/10/22 (i.e not a duplicate of the first one)
2022-08-10 00:00:00 | hrsjeryj | Section 5 | Category 2 |  |  | 355
2022-08-04 00:00:00 | graegrgerahaeh | Section 4 | Category 3 |  |  | 174
2022-08-27 00:00:00 | [NAME] | Section 3 | Category 5 |  |  | 254
2022-08-26 00:00:00 | ergs | Section 5 | Category 4 |  |  | 11
2022-08-23 00:00:00 | 4et5ehw6n57ej6uty | Section 3 | Category 1 |  |  | 236
2022-08-22 00:00:00 | 6e5hyr6 | Section 2 | Category 1 |  |  | 41
2022-08-11 00:00:00 | rhetrshst | Section 1 | Category 5 |  |  | 231
2022-08-08 00:00:00 | ytjsrjhsr | Section 2 | Category 3 |  |  | 293 |  |  |  | =IFERROR(INDEX(Table1[Category],MATCH(1,($F$1=Table1[Month])*($C$1=Table1[Year])*(L14=Table1[Amount]),0)),"")
2022-08-02 00:00:00 | ragdstrhryduh | Section 5 | Category 4 |  |  | 241
Spreadsheet: michelle_lokay__26639__C000749EOG04_01
Sheet: COST SUMMARY

NORTHERN NATURAL GAS COMPANY
WORK ORDER C.000625 EOG PRONGHORN
ESTIMATED COST SCHEDULE RECAP
MATERIALS:
 | Chromatograph |  |  |  | 55000
 | H20 Monitor |  |  |  | 10000
 | H2S Monitor |  |  |  | 35000
 | EFM |  |  |  | 35000
 | Flow Control |  |  |  | 34000
 | Positive shut-in |  |  |  | 22000
 | Flow bypass |  |  |  | 12000
LABOR:
 | Engineering, CSUP, [NAME] |  |  |  | 120000
OTHER:
 | Tax Gross-up |  |  |  | 100000
 |  |  | Estimated Project Cost
Spreadsheet: 718128d1613000209-copy-new-row-to-a-second-page-use-power-query-to-append-tables-fatfish1969-
Sheet: Sheet4

Symbol | Stock | Name
AAPL | APPLE | [NAME]
ALK | ALASKA AIR GROUP | [NAME]
AMT | AMERICAN TOWER CORP | [NAME]
B | BARNES  GROP INC | [NAME]
BA | BOEING | [NAME]
BRK -B | BERKSHIRE | [NAME]
C | CITIGROUP INC | [NAME]
CLF | CLEVELAND CLIFFS INC | [NAME]
CRM | SALESFORCE | [NAME]
CVS | CVS HEALTH | [NAME]
DIS | DISNEY | [NAME]
DOW | DOW CHEMICAL | [NAME]
GBX | GREENBRIER | [NAME]
GM | GENERAL MOTORS | [NAME]
GS | GOLDMAN | [NAME]
GOOG | GOOGLE | [NAME]
Spreadsheet: 89564d1289348135-comparing-uniqueids-and-subtracting-vegasl-ef752642-sdg10
Sheet: Sheet1

Set A |  |  |  |  | Set B
UniuqeID | First Name | Last Name | Age |  | UniuqeID | First Name | Last Name | Age |  | Difference in Age from Set B  & Set A
BrianT | [NAME] | T | 21 |  | MicheleF | [NAME] | F | 22 |  | 0 | '=IF(ISNA(VLOOKUP($F3,$A$3:$D$6,4,FALSE)),"not found",$I3-VLOOKUP($F3,$A$3:$D$6,4,FALSE))
MicheleF | [NAME] | F | 22 |  | BillD | [NAME] | D | 23 |  | 0
BillD | [NAME] | D | 23 |  | TomT | [NAME] | T | 21 |  | not found
BillY | [NAME] | Y | 18 |  | No Name | No | Name | 26 |  | not found
 |  |  |  |  |  |  |  |  |  |  |  |  | Today, 05:53 PM
 |  |  |  |  |  |  |  |  |  |  |  |  | Comparing UniqueIDs and Subtracting - VegasL - EF752642 - SDG10.xls
 |  |  |  |  |  |  |  |  |  |  |  |  | Forum Contributor   Join Date: 10 Feb 2007
 |  |  |  |  |  |  |  |  |  |  |  |  | Posts: 152
 |  |  |  |  |  |  |  |  |  |  |  |  | Comparing UniqueIDs & Subtracting
 |  |  |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/752642-comparing-uniqueids-and-subtracting.html
 |  |  |  |  |  |  |  |  |  |  |  |  | Hello,
 |  |  |  |  |  |  |  |  |  |  |  |  | I want to compare two columns of data, and where ever there is a match, to subtract.
 |  |  |  |  |  |  |  |  |  |  |  |  | So in attached spreadsheet, I want to compare column A with column F,
 |  |  |  |  |  |  |  |  |  |  |  |  | and if there is an exact match, then display the difference of coulmn i and d, all else leave blank.
 |  |  |  |  |  |  |  |  |  |  |  |  | See desired result in column K
 |  |  |  |  |  |  |  |  |  |  |  |  | How can I do this via sumproduct or vlookup, or any other method?
 |  |  |  |  |  |  |  |  |  |  |  |  | Thanks
Spreadsheet: 171228d1343664438-excel-2007-conditional-formatting-request-for-help-cf-from-second-sheet-if-exists
Sheet: Dept Charges

Store Name | Tender | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Total
 |  | 2012-06-18 00:00:00 | 2012-06-19 00:00:00 | 2012-06-20 00:00:00 | 2012-06-21 00:00:00 | 2012-06-22 00:00:00 | 2012-06-23 00:00:00 | 2012-06-24 00:00:00 | 2012-06-25 00:00:00 | 2012-06-26 00:00:00 | 2012-06-27 00:00:00 | 2012-06-28 00:00:00 | 2012-06-29 00:00:00 | 2012-06-30 00:00:00 | 2012-07-01 00:00:00 | 2012-07-02 00:00:00 | 2012-07-03 00:00:00 | 2012-07-04 00:00:00 | 2012-07-05 00:00:00 | 2012-07-06 00:00:00 | 2012-07-07 00:00:00 | 2012-07-08 00:00:00 | 2012-07-09 00:00:00 | 2012-07-10 00:00:00 | 2012-07-11 00:00:00 | 2012-07-12 00:00:00 | 2012-07-13 00:00:00 | 2012-07-14 00:00:00 | 2012-07-15 00:00:00 | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00
Overall Total |  | 251 | 27 | 59.12 | 125.12 | 1 | 0 | 0 | 16.81 | 101.91 | 6 | 1001 | 6 | 0 | 0 | 13.72 | 12 | 0 | 57.21 | 5 | 0 | 4.77 | 255 | 30 | 4.73 | 15.41 | 5 | 0 | 5 | 23.97 | 434.82 | 60 | 2521.59
Store 101 | Dept. Charge | 1 | 0 | 0 | 119.31 | 1 | 0 | 0 | 0 | 96.91 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0.87 | 0 | 0 | 0 | 0 | 0 | 0 | 226.09
Spreadsheet: 788532d1658513930-inventory-control-spreadsheet-excel-demo
Sheet: Orders

 |  | Company Slogan | Orders
 |  |  | INVOICE NO.
 | Scottsdale, AZ |  | DATE
 | Phone | Fax |  | Branch #
 | email
 | TO |  | SHIP TO
 |  |  |  | Name
 |  |  |  | Company Name
 | Street Address |  |  | Street Address
 | City, ST  ZIP Code |  |  | City, ST  ZIP Code
 | Phone |  |  | Phone
 | JOB |  | PAYMENT TERMS
 | Job or project title |  | Due on receipt
 | [NAME] | QUANTITY | AMOUNT | TOTAL
 | Airplane (Foam Super Glider) | 3 | 3
 | Binoculars | 5 | 8
 | Backpack (Men's Black) | 5 | 8
 |  |  | Total
 |  |  | Shipping | 6.95
 |  |  | Grand Total
 | THANK YOU FOR YOUR BUSINESS!
Spreadsheet: 862297d1710045013-need-help-with-formula-or-function-pulling-data-to-another-tab-sample-budget-spreadsheet
Sheet: Expenses-Year

 |  | Expenses | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | Total | Average
Payments |  | Monthly totals:
 |  | CCard
 |  | Fees
 |  | Tickets
 |  | Subs
 |  | Misc
Spreadsheet: 788067d1658246764-mechanical-sizing-spreadsheet-sizing-sheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Reference Data
 | [NAME] |  | Length |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME] | Length Min | [NAME] |  | Size
 | 1.5 |  | 48 |  |  |  |  |  | 1.5 | 0 | 50 |  | 0.625
 | 2 |  | 58 |  |  |  |  |  | 1.5 | 51 | 125 |  | 0.75
 | 3 |  | 76 |  |  |  |  |  | 2 | 0 | 50 |  | 0.625
 | 3.5 |  | 100 |  |  |  |  |  | 2 | 51 | 80 |  | 0.75
 | 4 |  | 15 |  |  |  |  |  | 2 | 81 | 150 |  | 0.875
 | 4 |  | 190 |  |  |  |  |  | 2.5 | 0 | 80 |  | 0.75
 | 5 |  | 75 |  |  |  |  |  | 2.5 | 81 | 125 |  | 0.875
 |  |  |  |  |  |  |  |  | 3 | 0 | 80 |  | 0.75
 |  |  |  |  |  |  |  |  | 3 | 81 | 100 |  | 0.875
 |  |  |  |  |  |  |  |  | 3.5 | 0 | 50 |  | 0.75
 |  |  |  |  |  |  |  |  | 3.5 | 51 | 80 |  | 0.875
 |  |  |  |  |  |  |  |  | 3.5 | 81 | 250 |  | 1.125
 |  |  |  |  |  |  |  |  | 4 | 0 | 50 |  | 0.75
 |  |  |  |  |  |  |  |  | 4 | 51 | 80 |  | 0.875
 |  |  |  |  |  |  |  |  | 4 | 81 | 200 |  | 1.125
 |  |  |  |  |  |  |  |  | 5 | 0 | 50 |  | 0.875
 |  |  |  |  |  |  |  |  | 5 | 51 | 100 |  | 1.125
 | Sample
 | If "[NAME]" = 1.5, and "Length" is in range 0 - 50, then size is 5/8
 | If "[NAME]" = 1.5, and "Length" is in range 51 - 125, then size is 3/4
 | Note: Must work for all listed [NAME] and [NAME]
Spreadsheet: 745098d1629745037-if-cell-value-equals-another-cell-value-than-change-color-of-cell-book2
Sheet: Sheet1

 |  | 366.66 |  | 366.66
 |  | 183.33 |  | 183.33
 |  | 612.95 |  | 712.95
 |  | 499.07 |  | 499.07
 |  | 53 |  | 53
 |  | 244.62 |  | 254.62
 |  | 232.8 |  | 232.8
 |  | 638.26 |  | 638.26
 |  | 364.72 |  | 364.72
 |  | 316.61 |  | 316.61
Spreadsheet: 284ebc20-5d32-4c87-8a63-7b3860432e4b
Sheet: Sheet1

 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Tax Levies for all Tax Districts--January 1, 2010 Valuations
Levies for Taxes Payable in Fiscal Year 2011-2012
 |  |  | COUNTY TAX. | VALUATION
 |  |  | (INCLUDES GAS & ELECTRICITY)
GENERAL [NAME] | 3.5 |  | RURAL | 910787417
GENERAL SUPPLEMENTAL | 0
MH-DD SERVICES | 0.42755 |  | URBAN | 2599731688
DEBT SERVICE | 0.35544
PIONEER CEMETERY | 0 |  | TOTAL | 3510519105
SUB TOTAL- | 4.28299
RURAL SERVICES BASIC | 3.95 |  | TIF | 513499329
 |  |  | Tax Incremental Financing Used Only For GO Bond
TOTAL | 8.232990000000001 |  | Indebtedness
OTHER AGENCIES |  |  | STATE LEVY |  | 0.0032
COUNTY HOSPITAL | General | 0.27
 | F.I.C.A. | 0.09466 | AREA COLLEGE | GENERAL | 0.2025
 | I.P.E.R.S. | 0.10825 | XI | TORT LIAB. | 0.00746
 | Unemploy. Comp. | 0.00427 |  | INSURANCE | 0.06862
 | Tort Liability | 0.13193 |  | EARLY RET | 0.01492
AG. EXTENSION |  | 0.06751 |  | EQUIPMENT | 0.09
 |  |  |  | PLANT | 0.2025
ASSESSOR | Assessment Expense | 0.21364 |  | UNEMP CMP | 0.00418
 | F.I.C.A.
 | I.P.E.R.S.
SPECIAL APPRAISERS |  | 0.06552
TOTAL |  | 0.9557800000000001 |  | TOTAL | 0.5901799999999999
 |  |  | VOTED | REG | PLAY | DEBT
SCHOOL LEVIES | GENERAL | MANAGEMENT | PLANT/EQ | PLANT/EQ | GROUND | SERVICE | TOTAL
ADEL-DESOTO-MINBURN | 14.95195 | 1.47682 |  | 0.33 |  | 1.86547 | 18.62424
DALLAS CENTER - GRIMES | 11.4351 | 0.7981 | 1 | 0.33 |  | 3.93869 | 17.50189
EARLHAM | 13.84799 | 0.36278 | 1 | 0.33 |  | 0.70992 | 16.25069
MADRID | 13.11517 | 2.14036 | 1 | 0.33 |  | 0.54 | 17.12553
PANORAMA | 11.02051 | 0.54652 | 0.67 | 0.33 |  | 1.39721 | 13.96424
PERRY | 17.06269 | 1.59616 | 0.43378 | 0.33 |  | 2.17695 | 21.59958
[NAME] | 13.31217 | 1.0354 | 1.34 | 0.33 |  | 2.21243 | 18.23
WAUKEE | 12.43205 | 0.45922 | 1.34 | 0.33 |  | 3.24165 | 17.80292
WEST CENTRAL VALLEY | 11.70553 | 0.47163 |  | 0.33 |  | 4.05 | 16.55716
WEST DES MOINES | 11.24696 | 0.79758 | 1.34 | 0.33 | 0.135 |  | 13.84954
WOODWARD GRANGER | 14.6057 | 1.17509 | 1.34 | 0.33 |  | 2.29979 | 19.75058
Spreadsheet: 485102d1476707882-countifs-or-index-match-trying-to-count-how-many-times-it-happen-in-a-date-before-unique-list
Sheet: Sheet1

 | Results | Date Conducted |  | Date | Number of Times Conducted | Passed | Failed
 | Passed | 2016-10-10 00:00:00
 | Failed | 2016-10-10 00:00:00
 | Passed | 2016-10-10 00:00:00
 | Failed | 2016-10-10 00:00:00
 | Passed | 2016-10-12 00:00:00
 | Failed | 2016-10-12 00:00:00
 | Failed | 2016-10-12 00:00:00
 | Passed | 2016-10-13 00:00:00
 | Passed | 2016-10-15 00:00:00
 | Passed | 2016-10-12 00:00:00
 | Failed | 2016-10-15 00:00:00
 | Passed | 2016-10-20 00:00:00
 | Passed | 2016-10-20 00:00:00
 |  | 2016-10-21 00:00:00
Spreadsheet: 0a39ef43-c72c-4cea-b2b8-b617c529d15a
Sheet: Instruments

 | Instruments
UOM |  | PART NUMBER | PRICE
EA | T7208 Phones | NT8B26 | 116.88
EA | T7216E Phones | NT8B27 | 130.63
EA | KIM 24 extenders for above 7216E | NT8B29 | 163.63
EA | Analog feature sets single line | 220300VBA27S | 45.93
EA | Analog feature sets dual line | 220500VBA27S | 56.64
EA | Head sets (wireless) for above sets | CS55 | 250.77
EA | Head sets (wired) for above sets | H171 | 89
EA | Head sets (wireless) | CS55 | 250.77
EA | Head sets (wired) | H171 | 89
EA | Wired/wireless conference phones | 095501 | 302.75
EA | Cordless headsets for various instruments | SAVI W740 | 323.62
Spreadsheet: 679333d1590337084-help-with-extracting-data-more-than-one-row-above-poexample
Sheet: LookUp

part number list sample (these numbers are on the PO sheet)
805359 | <= single entry, works
499101 | <= single entry, works
87-4601 | <= first entry, works
87-4121 | <= second entry, does not
87-4110 | <= third entry, does not
23-0370 | <= first entry, works
8792-5 | <= second entry, does not
Enter part No. ===> | 805359
Bought By ==> | Lepior, [NAME] | P.O. Number ==> | 2713 | 2 Pcs.
Spreadsheet: 61411d1262246659-calculate-working-shifts-per-day-from-monthly-report-book1
Sheet: Sheet1

 |  | Person A |  | Person B
Date | Day | Work time |  | Work time
2009-11-30 00:00:00 | 2009-11-30 00:00:00 | [NAME] | 6+2 | [NAME]
2009-12-01 00:00:00 | 2009-12-01 00:00:00 | free_00 | 0 | day_shift_12
2009-12-02 00:00:00 | 2009-12-02 00:00:00 | free_00 | 0 | [NAME]
2009-12-03 00:00:00 | 2009-12-03 00:00:00 | free_00 | 0 | [NAME]
2009-12-04 00:00:00 | 2009-12-04 00:00:00 | day_shift_12 | 12 | [NAME]
2009-12-05 00:00:00 | 2009-12-05 00:00:00 | [NAME] | 2+2 | free_00
2009-12-06 00:00:00 | 2009-12-06 00:00:00 | free_00 | 8 | free_00
2009-12-07 00:00:00 | 2009-12-07 00:00:00 | free_00 | 0 | free_00
2009-12-08 00:00:00 | 2009-12-08 00:00:00 | vacation_08 | 8 | day_shift_12
2009-12-09 00:00:00 | 2009-12-09 00:00:00 | vacation_08 | 8 | [NAME] |  |  | start time | end time
2009-12-10 00:00:00 | 2009-12-10 00:00:00 | vacation_08 | 8 | free_00 |  | [NAME] | 20:00:00 | 08:00:00
2009-12-11 00:00:00 | 2009-12-11 00:00:00 | vacation_08 | 8 | free_00 |  | day_shift_12 | 08:00:00 | 20:00:00
2009-12-12 00:00:00 | 2009-12-12 00:00:00 | free_00 | 0 | day_shift_12 |  | free_00
2009-12-13 00:00:00 | 2009-12-13 00:00:00 | free_00 | 0 | [NAME] |  | vacation_08
2009-12-14 00:00:00 | 2009-12-14 00:00:00 | vacation_08 | 8 | free_00 |  | [NAME] | 08:00:00 | 16:00:00
2009-12-15 00:00:00 | 2009-12-15 00:00:00 | vacation_08 | 8 | free_00 |  | afternoon_08 | 13:00:00 | 21:00:00
2009-12-16 00:00:00 | 2009-12-16 00:00:00 | vacation_08 | 8 | day_shift_12
2009-12-17 00:00:00 | 2009-12-17 00:00:00 | vacation_08 | 8 | [NAME]
2009-12-18 00:00:00 | 2009-12-18 00:00:00 | free_00 | 0 | free_00 |  |  | 06:00:00 | 16:00:00 | 22:00:00 | Hollyday | Sunday
2009-12-19 00:00:00 | 2009-12-19 00:00:00 | free_00 | 0 | free_00 |  |  | 1 | 1.2 | 1.5 | 1.5 | 1.2
2009-12-20 00:00:00 | 2009-12-20 00:00:00 | day_shift_12 | 12 | free_00
2009-12-21 00:00:00 | 2009-12-21 00:00:00 | [NAME] | 2+2 | free_00
2009-12-22 00:00:00 | 2009-12-22 00:00:00 | free_00 | 6+2 | day_shift_12 |  | So….. Night shift on regular day:
2009-12-23 00:00:00 | 2009-12-23 00:00:00 | free_00 | 0 | [NAME] |  | start time | 20:00:00 | end time | 08:00:00
2009-12-24 00:00:00 | 2009-12-24 00:00:00 | [NAME] | 8 | [NAME]
2009-12-25 00:00:00 | 2009-12-25 00:00:00 | [NAME] | 4 | free_00 |  |  | 20:00-22:00 | 22:00-6:00 | 6:00-8:00
2009-12-26 00:00:00 | 2009-12-26 00:00:00 | free_00 | 6+2 | free_00 |  |  | 1.2 | 1.5 | 1
2009-12-27 00:00:00 | 2009-12-27 00:00:00 | free_00 | 0 | free_00
2009-12-28 00:00:00 | 2009-12-28 00:00:00 | day_shift_12 | 12 | [NAME] |  | So….. Night shift when hollyday or sunday is day after:
2009-12-29 00:00:00 | 2009-12-29 00:00:00 | [NAME] | 2+2 | [NAME] |  | start time | 20:00:00 | end time | 08:00:00
2009-12-30 00:00:00 | 2009-12-30 00:00:00 | free_00 | 6+2 | [NAME]
2009-12-31 00:00:00 | 2009-12-31 00:00:00 | [NAME] | 2+2 | [NAME] |  |  | 20:00-22:00 | 22:00-24:00 | 0:00-8:00
2010-01-01 00:00:00 | 2010-01-01 00:00:00 | [NAME] | 16 | [NAME] |  |  | 1.2 | 1.5 | 1,5 (1,2)
 |  | 188 | 168 | 196
Total |  | 168
Sunday |  | 20
Hollyday |  | 4
afternoon |  | 6
night shift |  | 26
 | regular | 112
Spreadsheet: 785503d1656450101-only-return-rows-that-are-needed-monday-prep-sheet
Sheet: Sheet1

Item | Monday | On Hand | To Prep | PSL | Expires
Bacon |  | 1 |  | 7
Chicken |  | 1 |  | 3
[NAME] |  | 1 |  | 4
Ham |  | 1 |  | 7
Meatball |  | 1 |  | 3
[NAME] |  | 1 |  | 7
OWP |  | 1 |  | 7
[NAME] |  | 1 |  | 5
Sausage |  | 1 |  | 4
Steak |  | 1 |  | 5
[NAME] |  | 1 |  | 3
[NAME] |  | 1 |  | 3
Item | Monday | On Hand | To Prep | PSL | Expires