tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 688222d1595631785-index-small-count-match-i-dont-know-blank-nat
Sheet: ALL

Patient Name | realssn | Visit Date Time | Last Modified Date | Clinic | Encounter Age | [NAME]
Name1 | SSN1 | 2020-06-29 09:00:00 | 2020-07-22 | (663A4)(545) AML MHS AT PR2 PROV 8 GP TELE | 25 | *Missing*
Name10 | SSN10 | 2020-07-15 14:00:00 | 2020-07-15 | (663A4)(502) AML MHS MH INJECTION IND | 9 | *Missing*
Name17 | SSN17 | 2020-07-16 10:00:00 | 2020-01-16 | (663A4)(502) AML MHS MH RTMS IND | 8 | *Missing*
[NAME] | SSN2 | 2020-07-06 12:31:02 | 2020-07-23 | (663A4)(502) AML MHS MH LIM IND | 18 | *Missing*
Name3 | SSN3 | 2020-07-08 08:30:00 | 2020-07-22 | (663A4)(502) AML MHS MH INJECTION IND | 16 | *Missing*
Name4 | [NAME] | 2020-07-10 10:15:00 | 2020-04-02 | (663A4)(527) AML MHS MH TELE-X | 14 | *Missing*
Name7 | SSN7 | 2020-07-15 11:00:00 | 2020-07-15 | (663A4)(502) AML MHS VVC PACC IOP MORRISON | 9 | *Missing*
Name8 | SSN8 | 2020-07-15 13:00:00 | 2020-07-13 | (663A4)(545) AML MHS AT HENRIQUES IND TELE | 9 | *Missing*
Name9 | SSN9 | 2020-07-15 14:00:00 | 2020-07-15 | (663A4)(545) AML MHS AT HENRIQUES IND TELE | 9 | *Missing*
Name5 | SSN5 | 2020-07-13 11:00:00 | 2020-01-16 | (663A4)(502) AML MHS MH RTMS IND | 11 | *Missing*
Name11 | SSN11 | 2020-07-15 17:00:00 | 2020-07-16 | (663A4)(545) AML MHS AT PH2 PROV 7 GP TELE | 9 | *Missing*
Name12 | SSN12 | 2020-07-15 17:00:00 | 2020-07-16 | (663A4)(545) AML MHS AT PH2 PROV 7 GP TELE | 9 | *Missing*
Name13 | SSN13 | 2020-07-15 17:00:00 | 2020-07-16 | (663A4)(545) AML MHS AT PH2 PROV 7 GP TELE | 9 | *Missing*
Name14 | SSN14 | 2020-07-15 17:00:00 | 2020-07-22 | (663A4)(545) AML MHS AT PH2 PROV 7 GP TELE | 9 | *Missing*
Name15 | SSN15 | 2020-07-15 17:00:00 | 2020-07-16 | (663A4)(545) AML MHS AT PH2 PROV 7 GP TELE | 9 | *Missing*
[NAME] | SSN16 | 2020-07-16 10:00:00 | 2020-07-17 | (663A4)(560) AML MHS AT VVC C GP | 8 | *Missing*
Name6 | SSN6 | 2020-07-13 13:00:00 | 2020-01-14 | (663A4)(502) AML MHS MH RTMS IND | 11 | *Missing*
Name18 | SSN18 | 2020-07-16 18:00:00 | 2020-07-17 | (663A4)(545) AML MHS AT PH2 OLY YAN TELE | 8 | *Missing*
Name19 | SSN19 | 2020-07-16 18:00:00 | 2020-07-17 | (663A4)(545) AML MHS AT PH2 OLY YAN TELE | 8 | *Missing*
Spreadsheet: 863557d1710993831-maintenance-interval-forecasting-maintenance-interval-forecasting
Sheet: LET+MMULT

 | Maintenance Interval Forecasting |  |  |  | https://www.excelforum.com/excel-general/1421344-maintenance-interval-forecasting.html
 | Service Number | Service Interval | Cumulative |  | Machine | Last completed service | Next Service Cycle | Next Service Cycle | Next Service Cycle | Next Service Cycle | Next Service Cycle
 | 0 | 0 |  |  | Mach #1 | 1000
 |  | 250 |  |  | Mach #2 | 7500
 |  | 500 |  |  | Mach #3 | 21000
 |  | 250 |  |  | Mach #4 | 21010
 |  | 1000 |  |  | Mach #5 | 40000
 |  | 250 |  |  | Mach #6 | 55000
 |  | 500 |  |  | Mach #7 | 66000
 |  | 250
 |  | 2000
 |  | 250
 |  | 500
 |  | 250
 |  | 1000
 |  | 250
 |  | 500
 |  | 250
 |  | 4000
 |  | 250
 |  | 500
 |  | 250
 |  | 1000
 |  | 250
 |  | 500
 |  | 250
 |  | 6000
 | Repeat cycle
Spreadsheet: 725829d1616917317-help-on-adjusting-excel-formula-to-calculate-more-date-sales-ledger-7
Sheet: Student Names

WATERFORD PRIMARY SCHOOL
Student Number | Student Name | Year Enrolled | Parent | Address | Contact Telephone | [NAME]
ST 001 | [NAME] | 2018 | [NAME] | 103 Magpie Road Burnside
ST 002 | [NAME] | 2020 | Pang Saunders
ST 003 | [NAME] | 2019 | Seel David
ST 004 | O'Neil James | 2019 | [NAME]
ST 005 | [NAME] | 2019 | [NAME]
Student Number | Student Name | Year Enrolled | Parent | Address | Contact Telephone | [NAME]
ST 001 | [NAME]
ST 002 | [NAME]
ST 003 | [NAME]
ST 004 | O'Neil James
ST 001 | [NAME]
Student Number | Student Name | Year Enrolled | Parent | Address | Contact Telephone | [NAME]
ST 001 | [NAME]
ST 002 | [NAME]
ST 003 | [NAME]
ST 004 | O'Neil James
ST 001 | [NAME]
Spreadsheet: 47062d1245958240-concatenate-and-unique-values-book1
Sheet: Sheet1

Dog:Brown:Small:0001 |  |  |  |  |  |  | Dog |  |  |  |  | [NAME] | Small
Cat:Black:Large:0001 |  |  |  |  |  |  | Cat |  |  |  |  | Black | Large
Dog:Yellow:Large:0001 |  |  |  |  |  |  | Dog |  |  |  |  | Yellow | Large
Bird:Blue:Medium:0001 |  |  |  |  |  |  | Bird |  |  |  |  | Blue | Medium
Turtle:Green:Small:0001 |  |  |  |  |  |  | Turtle |  |  |  |  | Green | Small
Cat:Black:Large:0002 |  |  |  |  |  |  | Cat |  |  |  |  | Black | Large
Cat:White:Large:0001 |  |  |  |  |  |  | Cat |  |  |  |  | White | Large
Dog:Brown:Small:0002 |  |  |  |  |  |  | Dog |  |  |  |  | [NAME] | Small
Dog:[NAME]:Small:0003 |  |  |  |  |  |  | Dog |  |  |  |  | [NAME] | Small
 |  |  |  |  |  |  | Dog |  |  |  |  | [NAME] | Small
 |  |  |  |  |  |  | Cat |  |  |  |  | Black | Large
Spreadsheet: 819631d1677605279-how-can-i-count-vacant-days-per-month-with-blank-move-in-dates-hotel-vacancy
Sheet: vacancy date

Vacancy Loss Start Date | New move in date | vacant days per room | Hotel Name
2023-01-01 00:00:00 |  |  | Drake
2023-01-02 00:00:00 | 2023-02-17 00:00:00 |  | Drake
2023-01-11 00:00:00 | 2023-03-19 00:00:00 |  | Omni
2023-01-21 00:00:00 | 2023-03-31 00:00:00 |  | Omni
2023-04-01 00:00:00 | 2023-04-10 00:00:00 |  | Omni
Spreadsheet: monika_causholli__28177__Foex Prices
Sheet: FOEX

source: Foex.fi
Last Updated: 08/14/2001
Prepared by: EIM Fundamentals
 |  | Date | NBSK | % Change | BHKP | % Change |  |  |  | Monthly Averages
 |  | 2001-04-17 00:00:00 | 586.53 |  | 543.42 |  |  |  | Date | NBSK | BHKP
 |  | 2001-04-24 00:00:00 | 580.42 |  | 536.53 |  |  |  | 2001-01-01 00:00:00 | 708.192
 |  | 2001-05-02 00:00:00 | 577.98 |  | 524.57 |  |  |  | 2001-02-01 00:00:00 | 677.445
 |  | 2001-05-08 00:00:00 | 572.04 |  | 512.05 |  |  |  | 2001-03-01 00:00:00 | 636.1625
 |  | 2001-05-15 00:00:00 | 560.19 |  | 497.16 |  |  |  | 2001-04-01 00:00:00 | 596.4925
 |  | 2001-05-22 00:00:00 | 545.22 |  | 490.16 |  |  |  | 2001-05-01 00:00:00 | 559.124 | 500.266
 |  | 2001-05-29 00:00:00 | 540.19 |  | 477.39 |  |  |  | 2001-06-01 00:00:00 | 520.8825 | 453.3525
 |  | 2001-06-05 00:00:00 | 536.63 |  | 465.59 |  |  |  | 2001-07-01 00:00:00 | 483.1620000000001 | 410.558
 |  | 2001-06-12 00:00:00 | 519.9 |  | 456.26 |  |  |  | 2001-08-01 00:00:00
 |  | 2001-06-19 00:00:00 | 515.5 |  | 450.7
 |  | 2001-06-26 00:00:00 | 511.5 |  | 440.86
 |  | 2001-07-03 00:00:00 | 499.55 |  | 422.03
 |  | 2001-07-10 00:00:00 | 490.85 |  | 411.92
 |  | 2001-07-17 00:00:00 | 478.91 |  | 408.25
 |  | 2001-07-24 00:00:00 | 477.27 |  | 408.5
 |  | 2001-07-31 00:00:00 | 469.23 |  | 402.09
 |  | 2001-08-07 00:00:00 | 459.82 |  | 396.85
 |  | 2001-08-14 00:00:00 | 457.58 |  | 398.45
 |  |  |  |  |  |  |  |  |  |  | Paper Downtime in Europe April-June
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Grades
 |  |  |  |  |  |  |  |  |  | M-Real | 245000 | paper
 |  |  |  |  |  |  |  |  |  | Sappi | 150000 | CTD wdfree
 |  |  |  |  |  |  |  |  |  | [NAME] enso | 75000 | magazine
 |  |  |  |  |  |  |  |  |  | [NAME] | 93000 | wdfree
 |  |  |  |  |  |  |  |  |  | UPM-Kymmene | 290000 | magazine and wdfree
Spreadsheet: 622883d1556972253-create-one-master-list-from-lists-on-multiple-worksheets-ef1282a_create-one-list-from-multiple-sheets
Sheet: List 2

Status | S/G | Description | Item No. | Serial No. | Type | Own Depot | Curr Depot
Available | 999998 | List 2 Description 1 | 9971099 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 2 | 9971101 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 3 | 9971429 |  | XHire | SIN | SIN
On [NAME] | 999998 | List 2 Description 4 | 9962347 |  | XHire | HOU | HOU
In Service | 999998 | List 2 Description 5 | 9962032 |  | XHire | HOU | HOU
Available | 999998 | List 2 Description 6 | 9962241 |  | XHire | HOU | HOU
Available | 999998 | List 2 Description 7 | 9971488 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 8 | 9970412 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 9 | 9970954 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 10 | 9972091 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 11 | 9972092 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 12 | 9970285 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 13 | 9970333 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 14 | 9970370 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 15 | 9970371 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 16 | 9970372 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 17 | 9970373 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 18 | 9970391 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 19 | 9970607 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 20 | 9970608 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 21 | 9970610 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 22 | 9970718 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 23 | 9970720 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 24 | 9970908 |  | XHire | SIN | SIN
On [NAME] | 999998 | List 2 Description 25 | 9970934 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 26 | 9970936 |  | XHire | SIN | SIN
On [NAME] | 999998 | List 2 Description 27 | 9971097 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 28 | 9971126 |  | XHire | SIN | SIN
Spreadsheet: 871848d1718248290-calculating-overtime-to-be-paid-after-deductions-are-made-forum-sheet-ot-build-up-rev-01
Sheet: Sheet1

DAY | [NAME] |  | [NAME] | CUMULATIVE TIME |  | LATE RUNNING OVERTIME WORKED | CUMULATIVE TIME |  | OVERTIME TO BE PAID
Monday | 7.3 |  | 0 |  |  | 0 |  |  | 0
Tuesday | 7.55 |  | 0.75 |  |  | 0 |  |  | 0
Wednesday | 7.4 |  | 0.4 |  |  | 0.25 |  |  | 0
Thursday | 7.65 |  | 0 |  |  | 0.2 | 0 |  | 0.2
Friday | 8.25 |  | 0.45 |  |  | 0.45 | 0 |  | 0.45
TOTAL :
Spreadsheet: 675630d1588380233-looking-for-the-right-conditional-formatting-formula-function-conditionalformattingsample
Sheet: Sheet1

 |  |  | columnA | columnB |  | columnC |  |  |  |  |  | Priority
 | Spreadsheet2 / Table 3 |  | text1 | 0 |  | text |  | Spreadsheet2 / Table 4 |  |  | False
 |  |  | text2 | 1 |  | text |  |  |  |  | False
 |  |  | text3 | 2 |  | text |  |  |  |  | True
 |  |  | text4 | 3 |  | text |  |  |  |  | True
 |  |  | text5 | 0 |  | text |  |  |  |  | True
 |  |  | text6 | 5 |  | text |  |  |  |  | True
 |  |  | text7 | 6 |  | text |  |  |  |  | True
 |  |  | [NAME] | 7 |  | text |  |  |  |  | True
 |  |  | [NAME] | 0 |  | text |  |  |  |  | False
 |  |  | text10 | 9 |  | text |  |  |  |  | False
 |  |  | [NAME] INCLUDES items with columnB balances | Priority
 | Spreadsheet1 / Table 2
 |  |  | text3 | 1
 |  |  | text2 | 2
 |  |  | text10 | 3
 |  |  | text4 | 4
 |  |  | [NAME] | 5
 |  |  | text7 | 6
 |  |  | text6 | 7
Spreadsheet: 288915d1389344281-convert-one-column-of-addresses-into-three-columns-when-text-to-be-grouped-is-not-even-example-address-column-separated-to-3-columns
Sheet: Sheet1

CURRENT FORM |  |  |  | DESIRED RESULT
COMBINED ADDRESS |  |  |  | SUBURB | STATE | POSTCODE
ALTONA NORTH VIC 3025 |  |  |  | ALTONA NORTH | VIC | 3025
BONDI NSW 2026 |  |  |  | BONDI | NSW | 2026
WOOLLOONGABBA QLD 4102 |  |  |  | WOOLLOONGABBA | QLD | 4102
TOOWONG QLD 4066 |  |  |  | TOOWONG | QLD | 4066
NOVAR GARDENS SA 5040 |  |  |  | NOVAR GARDENS | SA | 5040
assuming your data starts from a2 in
B2 copy paste =LEFT(A2,FIND(" ",A2)-1) for stats name and drag down
in c2 copy paste =MID(A2,FIND(" ",A2)+1,LEN(A2)-(LEN(B2)+LEN(D2)+1)) and drag down
in D2 copy and paste =RIGHT(A2,LEN(A2)-FIND("@",SUBSTITUTE(A2," ","@",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))) for postal code
Spreadsheet: 826902d1682362729-conditional-averageif-fixed-area-plot-template
Sheet: Blank

Plot
Species and Diameter Class | Quantity of Stems | Average Tree Height (m) | Average Crown Base Height (m)
Layer 2 (≥7.5 cm - 12.5 cm dbh)
Total Layer 2 - All Species
Total Layer 2 - Conifers Only
Layer 3 (≥1.3 cm - 7.5 cm dbh)
Total Layer 3 - All Species
Total Layer 3 - Conifers Only
Layer 4 (<1.3 cm dbh)
Total Layer 4 - All Species
Total Layer 4 - Conifers Only
Spreadsheet: 746628d1630920877-statement-by-name-and-by-date-older-to-newer-2-statment-2
Sheet: Folha1

 |  |  |  |  |  |  |  |  |  |  |  | FRAÇÃO | I
 |  | BOOKS
 | 1 Q |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE | TOTAL PAYMENT | BOOKS | NEWSPAPERS
 | 2 Q
 | 3 Q |  |  |  |  |  |  |  |  |  |  | DÍVIDA DE 2020
 | 4 Q |  |  |  |  |  |  |  |  |  |  | Quota Trimestral Ordinária | 0 |  | 1 February 2021 | 217 | 132 | 85
 |  |  |  |  |  |  |  |  |  |  |  | Quota Mensal Elevadores | 0
 |  | NEWSPAPERS
 | 1 Q
 | 2 Q |  |  |  |  |  |  |  |  |  |  | 2021
 | 3 Q |  |  |  |  | 2021-09-03 00:00:00 | 100 |  |  |  |  | Quota Trimestral Ordinária | 0
 | 4 Q |  |  |  |  |  |  |  |  |  |  | Quota Mensal Elevadores | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 September 2021 | 100 | --- | 100
 |  |  |  |  |  |  |  |  |  |  |  | DÉBITOS 2021
 |  |  |  |  |  |  |  |  |  |  |  | Quota Trimestral Ordinária | 0
 |  |  |  |  |  |  |  |  |  |  |  | Quota Mensal Elevadores | 0
 |  |  |  |  |  |  |  |  |  |  |  | PAGAMENTOS 2021
 |  |  |  |  |  |  |  |  |  |  |  | Quota Trimestral Ordinária | 0
 |  |  |  |  |  |  |  |  |  |  |  | Quota Mensal Elevadores | 0
 |  |  |  |  |  |  |  |  |  |  |  | SALDO EM DÍVIDA À DATA DE | 0
Spreadsheet: 757128d1638035470-how-to-xlookup-if-the-search-keys-are-comma-separated-excelforum
Sheet: Sheet2

Product ID | Quantity |  |  |  | Search | Result
AB001 | 1209 |  |  |  | AB001,HN002
HN002 | 3407 |  |  |  | AB001
CN890 | 3340 |  |  |  | CN890
MK003 | 5600 |  |  |  | MK003,CN890
Spreadsheet: 835178d1688386863-skip-one-row-when-value-changes-in-another-column-sample-51-
Sheet: Аркуш1

As is:
 | 1 |  |  | 0
 | 1 |  |  | 0
 | 2 |  |  | 0
 | 2 |  |  | 0
 | 2 |  |  | 0
 | 3 |  |  | 0
To be:
 | 1 |  |  | 0
 | 1 |  |  | 0 |  | 0
 | 2
 | 2 |  |  | 0 |  | 0
 | 2 |  |  | 0 |  | 0
 | 3 |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
Spreadsheet: 774975d1648745733-total-based-on-3-criteria-items-need-a-formula-excel-forum-sample-1
Sheet: Sorter Calcs

 | Branch Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Off-Site Hrs | Off-Site Earnings | Sorter Hrs | Sorter Earnings | Non-Worked Hrs | Non-Worked Earnings | Temp Hrs | Temp Earnings
Omaha | 2106 | Omaha
Lincoln | 2107 | Lincoln
Minneapolis | 2108 | Minneapolis
So Dakota | 2109 | So Dakota
So. Dakota | 2109 | So Dakota
Hayward | 3018 | HAY DDU
Ontario | 3024 | ONT DDU
Hayward | 3218 | HAY
San Jose | 3219 | SJC
San Francisco | 3221 | SFO
Concord | 3225 | CCR
[NAME] | 3226 | MRY
Petaluma | 3227 | PET
Burbank | 3314 | BUR
Inglewood | 3317 | ING
Commerce | 3320 | COM
Redlands | 3321 | RDL
San Diego | 3322 | SAN
Los Angeles | 3323 | LAX
Ontario | 3324 | ONT
Orange- | 3325 | ORG
Carlsbad | 3316 | CBD
Sacramento | 3416 | SAC
[NAME] | 3419 | STK
Reno | 3420 | RNO
Fresno | 3512 | FAT
Las Vegas | 3513 | VEG
Santa Maria | 3624 | SMX
Ventura | 3625 | VNS
Bakersfield | 3650 | BFL
Visalia | 3655 | VIS
Phoenix | 3701 | PHX
Tucson- | 3702 | TUC
[NAME] | 3703 | BKY
[NAME] | 3730 | UTA
Denver | 3740 | DIA
Colorado | 3741 | COS
Boise | 3750 | BOI
Vancouver | 3810 | VAN
Seattle | 3910 | SEA
Spokane | 3925 | GEG
Tacoma | 3915 | TAC
Phx Ops | 3701
Phoenix | 3701
Co Springs | 3741
Totals w/o DDU
Totals w DDU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *Use cells AS45, AU45 & AW45 for formula on MTD CPP tab row 213*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Off-Site Hrs | Off-Site Earnings
Spreadsheet: 879937d1727539237-extract-a-list-of-currency-and-amounts-from-a-matrix-with-a-spill-formula-lambda-cash-flow-forecast-1-
Sheet: Forecast 260924

 |  |  |  | 1 | 1 | 5 | 15
Bank's region | Bank | Statement accounts | Currency |  |  |  |  | Conversion | I/C + Deposits
IN | JPM | 50078 | USD
IN | JPM | 50078 | USD
IN | JPM | 50078 | EUR |  | 511740
IN | JPM | 50078 | GBP |  | 73709
IN | JPM | 50078 | AUD
GB | HSBC | 200987 | USD | 7120363
GB | HSBC | 200987 | USD
GB | HSBC | 200987 | GBP
GB | HSBC | 200987 | EUR
GB | HSBC | 200987 | AUD
US | CITIBANK | 7433 | USD
US | CITIBANK | 90807 | NIS
US | CITIBANK | 801.7683883749727 | USD |  | 7003766
US | CITIBANK | 278.3189847924104 | EUR
US | CITIBANK | 175.7076287609073 | GBP |  | 558
US | CITIBANK | 673.7614867316984 | AUD
UK | CITIBANK | 744.6707467759913 | USD
UK | CITIBANK | 726.3982087969856 | GBP
UK | CITIBANK | 675.4697063208389 | AUD
UK | CITIBANK | 829.4605501364579 | EUR
Spreadsheet: 63975d1264812716-excel-2007-data-validation-issue-personal-lines-quote-sheet1
Sheet: AUTO DETAIL

Automobile Insurance Detail
Drivers | DOB | Accidents/Claims/Violations?
Vehicles | Collision Ded. | Comp Ded | Rental Expense | Towing
Other Physical Coverage | N/A
Quoted Coverages
Bodily Injury Liability
Property Damage Liability
Tort Option
[NAME]
Underinsured Motorist
First Party Medical
Income Loss
Funeral Benefit
Accidental Death
Extraordinary Medical
Personal Liability Umbrella | None
Agent Notes:
Spreadsheet: 144948d1331222460-conditional-formatting-in-excel-2003-inventory-price-testing-samples-test
Sheet: Sheet1

[NAME] | Vendor Invoice No. or Receiving # | Receiving # | Invoice date
CARGILL MEAT SOLUTIONS CORP. | 26839423 | 00192946 | 2012-01-04 00:00:00
CARGILL MEAT SOLUTIONS CORP. | 26833356 | 00192603 | 2011-12-27 00:00:00
CALLI-TRADING, LLC | 00177920 | 00177920 | 2011-02-06 00:00:00
BAR-S FOODS | [PHONE] | 00192801 | 2011-12-27 00:00:00
HARVEST SELECT CATFISH | 236505 | 00191943 | 2011-12-12 00:00:00
BAR-S FOODS | [PHONE] | 00192801 | 2011-12-27 00:00:00
NATIONAL BEEF PACKING CO., LLC | 4165302 | 00192472 | 2011-12-28 00:00:00
MONARCH TRADING, CO. LLC. | 35093 | 00192681 | 2011-12-27 00:00:00
MONARCH TRADING, CO. LLC. | 34575 | 00191441 | 2011-12-05 00:00:00
MONARCH TRADING, CO. LLC. | 00188853 | 00188853 | 2011-10-07 00:00:00
Spreadsheet: 690136d1596888277-unique-list-of-entries-sample-49-ans
Sheet: Sheet2

 | PO | 45
 |  | Descriptions |  |  |  |  |  | Qty | Unit | Rate | Amount
 |  | Product | Make | Size | Code no | Shade | Thickness
Spreadsheet: 04d1b405-4d26-4922-ad19-7396facb5367
Sheet: Table 5

TABLE 5
TAX FORGIVENESS BY COUNTY - 2011
(Money amounts are in thousands of dollars)
 | TOTAL NUMBER OF | FORGIVENESS | TOTAL | TAXABLE
COUNTY | TAX RETURNS | AMOUNT | INCOME | INCOME
TOTALS-ALL RETURNS | 1362972 | 304978 | 11323341 | 10994102
OUT-OF-STATE | 51033 | 10087 | 486743 | 363889
PENNSYLVANIA | 1311939 | 294891 | 10836598 | 10630213
ADAMS | 10611 | 2479 | 90874 | 88974
ALLEGHENY | 119156 | 23608 | 877947 | 857658
ARMSTRONG | 8583 | 1769 | 64676 | 63222
BEAVER | 19488 | 3902 | 144873 | 141313
BEDFORD | 6212 | 1523 | 55605 | 54825
BERKS | 45451 | 10707 | 390971 | 384310
BLAIR | 15339 | 3459 | 127107 | 124771
BRADFORD | 7061 | 1613 | 60303 | 58932
BUCKS | 51483 | 10069 | 377841 | 368748
BUTLER | 17643 | 3453 | 129558 | 126129
CAMBRIA | 18239 | 3484 | 128223 | 125234
CAMERON | 731 | 146 | 5425 | 5287
CARBON | 7806 | 1604 | 59322 | 57995
CENTRE | 10647 | 2223 | 82973 | 80660
CHESTER | 34196 | 8116 | 298353 | 292032
CLARION | 4680 | 986 | 36567 | 35752
CLEARFIELD | 10160 | 2208 | 81657 | 80205
CLINTON | 4465 | 1045 | 37973 | 37167
COLUMBIA | 7235 | 1511 | 56151 | 54993
CRAWFORD | 10800 | 2656 | 96590 | 94660
CUMBERLAND | 22832 | 4578 | 170667 | 166110
DAUPHIN | 29660 | 6736 | 246348 | 241646
DELAWARE | 49762 | 11441 | 421799 | 415037
ELK | 4011 | 749 | 27980 | 27400
ERIE | 34358 | 7796 | 284666 | 279829
FAYETTE | 17825 | 3897 | 142790 | 140255
FOREST | 724 | 125 | 4654 | 4524
FRANKLIN | 17064 | 4056 | 149028 | 145600
FULTON | 1765 | 414 | 14947 | 14621
GREENE | 3770 | 809 | 29499 | 29001
HUNTINGDON | 5301 | 1200 | 43658 | 43131
INDIANA | 9903 | 2140 | 78340 | 76772
JEFFERSON | 6411 | 1440 | 52740 | 51828
JUNIATA | 2893 | 737 | 26852 | 26401
[NAME] | 24837 | 5379 | 198032 | 193849
LANCASTER | 54400 | 14645 | 532967 | 523327
[NAME] | 11353 | 2441 | 89033 | 87231
LEBANON | 16116 | 3789 | 138301 | 135438
LEHIGH* | 40474.4151 | 9425 | 344858 | 338127
LUZERNE | 38602 | 8245 | 304130 | 298291
LYCOMING | 13347 | 2942 | 109173 | 106855
MCKEAN | 5351 | 1092 | 40514 | 39874
MERCER | 14672 | 3166 | 115266 | 112945
MIFFLIN | 6324 | 1606 | 58102 | 57263
MONROE | 16914 | 3925 | 145089 | 142199
MONTGOMERY | 60441 | 12341 | 460968 | 450579
MONTOUR | 2015 | 416 | 15361 | 14833
NORTHAMPTON* | 30208.5849 | 6151 | 228842 | 222967
NORTHUMBERLAND | 11753 | 2558 | 93639 | 92006
PERRY | 4960 | 1188 | 43482 | 42655
PHILADELPHIA | 159449 | 44914 | 1615718 | 1602696
PIKE | 5943 | 1260 | 47526 | 46340
POTTER | 2309 | 543 | 20028 | 19674
SCHUYLKILL | 17816 | 3619 | 133635 | 130440
SNYDER | 4586 | 1157 | 42042 | 41435
[NAME] | 9644 | 2013 | 74060 | 72451
SULLIVAN | 821 | 154 | 5901 | 5777
SUSQUEHANNA | 4931 | 1117 | 42003 | 41045
TIOGA | 4766 | 1036 | 38406 | 37531
UNION | 4010 | 989 | 36118 | 35281
VENANGO | 7069 | 1512 | 55317 | 54229
WARREN | 5270 | 1074 | 39555 | 38711
WASHINGTON | 22467 | 4291 | 159399 | 155678
WAYNE | 6518 | 1380 | 51221 | 50034
WESTMORELAND | 40570 | 7426 | 277134 | 269849
WYOMING | 3368 | 743 | 27240 | 26834
YORK | 44369 | 9676 | 356584 | 348747
*  Includes a representative share of the city of Bethlehem
Spreadsheet: 718026d1612958491-sumifs-formula-summing-by-month-is-getting-zeroes-excel-forum-sumifs
Sheet: Sheet1

 | MONTHLY INCOME SUMMARY |  |  |  |  |  | RENTAL INCOME
 | MONTH | RENTAL INCOME | BALANCE OWING | RENTAL EXPENSES | PROFIT LOSS |  | TENANT NAME | WEEK | DATE DUE | AMOUNT DUE | DATE PAID | AMOUNT PAID
 | 2020-07-01 00:00:00 |  |  |  |  |  |  | 1 |  | 100 | 2021-01-07 00:00:00 | 100
 | 2020-08-01 00:00:00 |  |  |  |  |  |  | 2 |  | 100 | 2021-01-08 00:00:00 | 95
 | 2020-09-01 00:00:00 |  |  |  |  |  |  | 3 |  | 100 | 2021-01-09 00:00:00 | 105
 | 2020-10-01 00:00:00 |  |  |  |  |  |  | 4 |  | 100 | 2020-07-12 00:00:00 | 130
 | 2020-11-01 00:00:00 |  |  |  |  |  |  | 5 |  | 100 | 2020-07-13 00:00:00 | 50
 | 2020-12-01 00:00:00 |  |  |  |  |  |  | 6 |  | 100 | 2020-07-15 00:00:00 | 120
 | 2021-01-01 00:00:00 |  | CELL [NAME] 300 |  |  |  |  | 7 |  | 100 | 2020-07-18 00:00:00 | 100
 | 2021-02-01 00:00:00 |  |  |  |  |  |  | 8
 | 2021-03-01 00:00:00 |  |  |  |  |  |  | 9
 | 2021-04-01 00:00:00 |  |  |  |  |  |  | 10
 | 2021-05-01 00:00:00 |  |  |  |  |  |  | 11
 | 2021-06-01 00:00:00 |  |  |  |  |  |  | 12
 | YTD TOTAL |  |  |  |  |  |  | 13