tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 152377d1335367092-need-help-with-multiple-lookup-formulas-and-worksheets-fsfc-04-25-12
Sheet: PymtRect

Pull this data from Main & Billing sheets (goes to Parent with check)
Foster Care Agency |  |  | Foster Parent Payment Record
Address
Phone, etc.
Foster Parent: |  | [NAME] Jones |  |  | If possible, first name then last name here
 |  | 30 Main Street
 |  | City, ST 99999
You will be paid for a full day the day the child arrives; you will not be paid for the last day the child is in your home.
All the below data should be pulled from other sheets - ie - pull [NAME] childs name based on Foster Parent and input age, dates, amounts, etc.
Name of Resident | Age | Date From | Date To | Monthly Rate | Days in Residence | Pro-Rated Amount
Rodgers, [NAME] | 17 | 2012-03-01 00:00:00 | 2012-03-31 00:00:00 |  |  | 825
Last, First | 15 | 2012-03-01 00:00:00 | 2012-03-12 00:00:00 |  |  | 319
 |  |  |  |  | Total:
Spreadsheet: 6a29195f-5276-40f7-8acf-f2c354c201a1
Sheet: Sheet1

irradiation/ reconstitution | recipient genotype | [NAME] | HPRT (copies per µg of tissue) | TMEV (copies per µg of tissue)
yes | [NAME] | [NAME] | 21321 | 12867
yes | [NAME] | shi | 23392 | 3674
no | [NAME] |  | 15799 | 7529
yes | shi | [NAME] | 51566 | 61
yes | shi | shi | 49714 | 137
no | shi |  | 43388 | 46
Spreadsheet: 681807d1591764619-collor-2-or-3-cells-in-a-week-map1
Sheet: Datablad

2020 | 2019
Datum | [NAME] | dag maan | brugdag |  |  | Soort te werkstelling |  |  | [NAME] | Ziek aantal |  | [NAME] | Werkongeval aantal
 | Nieuwjaar |  |  |  |  | Voltijds
 | Paaszondag |  |  |  |  | 4/5
 | Paasmaandag |  |  |  |  | Halftijds
 | Dag v/d Arbeid
 | Hemelvaartsdag
 | Pinksterzondag |  |  |  |  | Welke Dag 4/5
 | Pinkstermaandag |  |  |  |  | Maandag
 | Nationale Feestdag |  |  |  |  | Dinsdag
 | [NAME] |  |  |  |  | Woesdag
 | Allerheiligen |  |  |  |  | Donderdag
 | Wapenstilstand 1918 |  |  |  |  | Vrijdag
 | Kerstmis
 | 2de Kerstdag
tot aantal feestdagen in weekend
Codes | Naam | Aantal Dagen
KD | [NAME]
[NAME] VM | [NAME] voormiddag
KD NM | [NAME] namiddag
[NAME] | Collectief verlof
[NAME] | Collectief [NAME]
[NAME] | Collectief [NAME]
V | Verlof
V VM | Verlof voormiddag
V NM | Verlof namiddag
Z | Ziek
ZoW VN | Ziek geworden op werk voormiddag
ZoW NM | Ziek geworden op werk namiddag
SP | Sociale promotie
GV | Gelegenheidsverlof
GV VM | Gelegenheidsverlof voormiddag
GV NM | Gelegenheidsverlof namiddag
VN | Dienstvrijstelling
VN VM | Dienstvrijstelling voormiddag
VN NM | Dienstvrijstelling namiddag
ZD | Zending
ZD VM | Zending voormiddag
ZD NM | Zending namiddag
WO | Werkongeval
STAKING | Staking
VVJ | Verlof vorig jaar | 5
VVJV | Verlof vorig [NAME]
VVJM | Verlof vorig jaar namiddag
OBTVERLOF | [NAME] verlof
4/5 | 4/5
Spreadsheet: benjamin_rogers__1068__gencomodel
Sheet: Peak Revenue

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual | Fuel | Annual | VOM | Annual | SO2 | Annual | NOx | Annual
 | Bucket 1 | Bucket 2 | Bucket 3 | Bucket 4 | Bucket 5 | Bucket 6 | Bucket 7 | Bucket 8 | Bucket 9 | Bucket 10 | Bucket 11 | Bucket 12 | Bucket 13 | Bucket 14 | Bucket 15 | Bucket 16 | Bucket 17 | Bucket 18 | Bucket 19 | Bucket 20 | Revenue | Cost | Fuel | Cost | VOM | Cost | SO2 | Cost | NOx
2000-01-15 00:00:00
Spreadsheet: 887468d1737699934-spill-formula-to-split-data-to-3-tabs-based-on-several-criteria-aging-dec-24
Sheet: Table Summary

Collectors |  | Collector |  | Total
 |  | Shawn
[NAME] |  | Shawn | A Consumer Services | 8860711.710000003
[NAME] |  | [NAME] | A HBH | 15938647.54
 |  | [NAME] | A SaaS | 16013389.15
 |  | Shawn | A Other | 5845.69
 |  | [NAME] | A LG Funnel | 520761.08
 |  | [NAME] | A Insurance | 1529265.14
 |  | [NAME] | C Consumer Services | 2844414.92
 |  | [NAME] | C Insurance | 7930.130000000001
 |  | [NAME] | C Accelerator | 118400.46
 |  | Shawn | C SaaS | 1332458.29
 |  | [NAME] | C Lending & Banking | 750
 |  | Shawn | A Accelerator | 1908976.53
 |  | Shawn | C HBH | -31.63
 |  | Shawn | B Insurance | 522289
Spreadsheet: 105978d1303231390-2007-return-cell-contents-based-upon-a-match-of-specific-text-coupon-question-for-excel-formatting
Sheet: Sheet1

 | Source Data: |  |  | Desired Result:
 | Column A |  |  | Column A | Column B
Row 1 | PROGRAM NUMBER                      - 12345678.00001 |  | Row 1 | PROGRAM NUMBER                      - 12345678.00001
Row 2 | OFFER CODE 111942 |  | Row 2 | OFFER CODE 111942 | PROGRAM NUMBER                      - 12345678.00001
Row 3 | OFFER CODE 112045 |  | Row 3 | OFFER CODE 112045 | PROGRAM NUMBER                      - 12345678.00001
Row 4 | OFFER CODE 112047 |  | Row 4 | OFFER CODE 112047 | PROGRAM NUMBER                      - 12345678.00001
Row 5 | OFFER CODE 112048 |  | Row 5 | OFFER CODE 112048 | PROGRAM NUMBER                      - 12345678.00001
Row 6 | TOTAL Amounts for                12345678.00001 |  | Row 6 | TOTAL Amounts for                12345678.00001
Row 7 | PROGRAM NUMBER                      - 23456789.00002 |  | Row 7 | PROGRAM NUMBER                      - 23456789.00002
Row 8 | OFFER CODE 112591 |  | Row 8 | OFFER CODE 112591 | PROGRAM NUMBER                      - 23456789.00002
Row 9 | TOTAL Amounts for                23456789.00002 |  | Row 9 | TOTAL Amounts for                23456789.00002
Row 10 | PROGRAM NUMBER                      - 34567890.00003 |  | Row 10 | PROGRAM NUMBER                      - 34567890.00003
Row 11 | OFFER CODE 112571 |  | Row 11 | OFFER CODE 112571 | PROGRAM NUMBER                      - 34567890.00003
Row 12 | TOTAL Amounts for                34567890.00003 |  | Row 12 | TOTAL Amounts for                34567890.00003
Row 13 | PROGRAM NUMBER                      - 456789012.00005 |  | Row 13 | PROGRAM NUMBER                      - 456789012.00005
Row 14 | OFFER CODE 112134 |  | Row 14 | OFFER CODE 112134 | PROGRAM NUMBER                      - 456789012.00005
Row 15 | TOTAL Amounts for                456789012.00005 |  | Row 15 | TOTAL Amounts for                456789012.00005
 | Column A has Source Data
 | Spreadsheet has Many Rows (1000+)
 | I would like to find a formula to enter into Column "B" to achieve the Desired Result.
 | In English:  If "Column A" contains the word "Offer", then return the contents of the 1st Cell above (in Column "A") containing the word "Program", if not, [NAME]
Spreadsheet: b1f9b2b0-e515-4c22-9b01-0916c761a801
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FBERY | Test | FBERY | Beryllium, Blood | Beryllium | Inductively Coupled Plasma/Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 2 | mL | Draw blood in a metal free, royal blue-top with EDTA tube(s). Send 2 mL of EDTA whole blood refrigerated. | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Reference Range: <1.0 ng/mL                                                 Test Performed by: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN  55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 83018 |  |  |  |  | Medtox Laboratories, Inc.
FBERY | [NAME] | WBEDTAMF | [NAME] EDTA - Metal Free (ERB) |  |  |  | Refrigerated | 14 days
FBERY | Result | Z1177 | Beryllium | Beryllium | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 881717d1729859911-type-matching-named-ranges-book-23
Sheet: Actuals

 |  | C1 | C2 | [NAME] | Category | C5 | C6 | C7 | C8 | Type |  | Income |  | Expenses |  | Savings
 |  | 2024-10-19 00:00:00 | Bank | Store 1 | Groceries |  | -20.99 |  |  | Expenses |  | Paychecks/Salary |  | Auto Insurance |  | Education
 |  | 2024-10-18 00:00:00 | Bank | Store 2 | Groceries |  | -22.42 |  |  | Expenses |  | Other Income |  | Automotive |  | Emergency Fund
 |  | 2024-10-18 00:00:00 | Bank | Store 3 | Transfer |  | -587.61 |  |  |  |  | Interest |  | Clothing/Shoes |  | Propane
 |  | 2024-10-18 00:00:00 | Bank | Store 4 | Transfer |  | -2421.3 |  |  |  |  | IRA Deposit |  | CRV Loan |  | Taxes
 |  | 2024-10-17 00:00:00 | Bank | Store 5 | Gasoline/Fuel |  | -18.6 |  |  | Expenses |  | End Month Shortage |  | Electricity |  | Vacation
 |  | 2024-10-17 00:00:00 | Bank | Store 6 | General Merchandise |  | -15.13 |  |  | Expenses |  |  |  | Gasoline/Fuel
 |  | 2024-10-17 00:00:00 | Bank | Store 7 | Transfer |  | 587.61 |  |  |  |  |  |  | General Merchandise
 |  | 2024-10-17 00:00:00 | Bank | Store 8 | Transfer |  | 2421.3 |  |  |  |  |  |  | Gifts
 |  | 2024-10-16 00:00:00 | Bank | Store 9 | Transfer |  | 700 |  |  |  |  |  |  | Groceries
 |  | 2024-10-16 00:00:00 | Bank | Store 10 | Transfer |  | -700 |  |  |  |  |  |  | Healthcare/Medical
 |  | 2024-10-17 00:00:00 | Bank | Salary | Paychecks/Salary |  | 2200 |  |  | Income |  |  |  | Home Improvement
 |  | 2024-10-01 00:00:00 | Bank | Trip | Vacation |  | 1200 |  |  | Savings |  |  |  | Home Insurance
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Home Maintenance
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Internet
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Kubota Loan
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mortgage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pets/Pet Care
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Service Charges/Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Telephone
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Trash Removal
Spreadsheet: 240162d1370240353-conditional-formating-copy-of-time-line
Sheet: Sheet1

Building | 1
Frame | A1
Floor
20
19
18
17
16
15
14
13
12
11
10
9
8
7
6
5
4
3
2
1
Spreadsheet: 41f22892-ee8c-4aad-81cd-eab3d8db9e3b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259307 | 60564 | [NAME] | Onißeit | GER | 1081 | 00:55:22 | 00:06:42 | 03:51:33 | [NAME] | 02:06:34 | 1 | 07:08:18
259307 | 8131 | Tiare | Lund | NZL | 1082 | 00:55:50 | 00:08:20 | 03:59:36 | 00:10:41 | 02:16:33 | 2 | 07:31:01
Spreadsheet: 802837d1667060814-conditional-formatting-highlight-duplicates-referencing-another-tab-conditional-formatting
Sheet: Reference Sheet

 | All PO's Tracked on RFE
 | VT7883
 | VT7881
 | VT7880
 | VT14685
 | VT14413
 | VT14412
 | VT14405
 | VT14117
 | VT11401
 | VT9906
 | VT14321
 | VT12420
 | VT11669
 | VT16300
 | VT16185
 | VT16085
 | VT15748
 | VT17019
 | VT16950
 | VT16641
 | VT16396
 | VT17277
 | VT17668
 | VT18078
 | VT18217
 | VT18229
 | VT18550
 | VT14745
 | VT18627
 | VT18855
 | VT12386
 | VT10561
 | VT10346
 | VT10081
 | VT12849
 | VT12391
 | VT14136
 | VT11858
 | VT14744
 | VT14476
 | VT14266
 | VT13874
 | VT11386
 | VT12754
 | VT12572
 | VT11539
 | VT11388
 | VT11098
 | VT15055
 | VT16116
 | VT16949
 | VT14958
 | VT6692
 | VT12642
 | VT13784
 | VT15049
 | VT15652
 | VT15677
 | VT15947
 | VT16993
 | VT15889
 | VT16118
 | VT17746
 | VT17528
 | VT17168
 | VT18225
 | VT18242
 | VT18240
 | VT18898
 | VT18949
 | VT19115
 | VT19397
 | VT19583
 | VT19598
Spreadsheet: 109171d1306117080-pivot-table-and-data-validation-pt-for-forum
Sheet: Sheet1

Region | Site Name | Month | Post Code | Number of Nights |  | Region | Site Name | Month | Post Code | Number of Nights
South | [NAME] | Jan | Liverpool | 12 |  |  |  |  |  |  |  | <<This is the advanced Filter Criteria
South | Fred | Feb | London | 1
North | [NAME] | March | [NAME] | 2 |  | Region | Site Name | Month | Post Code | Number of Nights |  | <<This is the data from the advanced filter
North | [NAME] | Mar | Nhants | 3 |  | East | [NAME] | Jul | Spot | 9 |  | <<Base the PT on this data
North | [NAME] | Apr | Bucks | 4 |  | East | [NAME] | June | London | 11
North | Mark | April | Stains | 5 |  | East | Able | Oct | Liverpool | 13
North | [NAME] | May | Middle | 6
South | [NAME] | Jun | Top | 7
South | [NAME] | May | Botteom | 8
East | [NAME] | Jul | Spot | 9
West | [NAME] | Aug | Stains | 10
East | [NAME] | June | London | 11
West | Caine | Sep | Bucks | 12
East | Able | Oct | Liverpool | 13
West | Lamb | July | Liverpool | 14
Spreadsheet: 712797d1610406260-sum-column-by-the-last-x-number-of-workdays-sum-by-weekday
Sheet: Sheet1

 | Sales
2020-12-01 00:00:00 | 1828
2020-12-02 00:00:00 | 1960
2020-12-03 00:00:00 | 1571 |  |  |  |  |  | Today: | 2021-01-11 00:00:00
2020-12-04 00:00:00 | 1999
2020-12-07 00:00:00 | 1296 |  |  |  |  |  | 4 Day Sales:
2020-12-08 00:00:00 | 1450
2020-12-09 00:00:00 | 1122
2020-12-10 00:00:00 | 1378
2020-12-11 00:00:00 | 1803
2020-12-14 00:00:00 | 1994
2020-12-15 00:00:00 | 1140
2020-12-16 00:00:00 | 1244
2020-12-17 00:00:00 | 1840
2020-12-18 00:00:00 | 1863
2020-12-21 00:00:00 | 1221
2020-12-22 00:00:00 | 1987
2020-12-23 00:00:00 | 1268
2020-12-24 00:00:00 | 1982
2020-12-25 00:00:00 | 1576
2020-12-28 00:00:00 | 1325
2020-12-29 00:00:00 | 1848
2020-12-30 00:00:00 | 1896
2020-12-31 00:00:00 | 1251
2021-01-01 00:00:00 | 1027
2021-01-04 00:00:00 | 1193
2021-01-05 00:00:00 | 1184
2021-01-06 00:00:00 | 1272
2021-01-07 00:00:00 | 1161
2021-01-08 00:00:00 | 1766
2021-01-11 00:00:00 | 1318
Spreadsheet: d5268c5a-d39b-493e-ae3d-0bdf87b10476
Sheet: GU8

Date | Day | Start Time | Field | Home | Visitor |  | Date | Day | Start Time | Field | Home | Visitor
2013-02-10 00:00:00 | Sunday | 11:00AM | PVF 7 | 859 | 851 |  | 2013-03-10 00:00:00 | Sunday | 11:00AM | PVF 7 | 854 | 855
2013-02-10 00:00:00 | Sunday | 12:00PM | PVF 7 | 858 | 852 |  | 2013-03-10 00:00:00 | Sunday | 12:00PM | PVF 7 | 853 | 856
2013-02-10 00:00:00 | Sunday | 1:00PM | PVF 7 | 856 | 854 |  | 2013-03-10 00:00:00 | Sunday | 1:00PM | PVF 7 | 851 | 858
2013-02-10 00:00:00 | Sunday | 2:00PM | PVF 7 | 855 | 860 |  | 2013-03-10 00:00:00 | Sunday | 2:00PM | PVF 7 | 859 | 860
2013-02-10 00:00:00 | Sunday | 3:00PM | PVF 7 | 857 | 853 |  | 2013-03-10 00:00:00 | Sunday | 3:00PM | PVF 7 | 852 | 857
2013-02-17 00:00:00 | Sunday | 11:00AM | PVF 7 | 851 | 852 |  | 2013-03-17 00:00:00 | Sunday | 11:00AM | PVF 7 | 855 | 856
2013-02-17 00:00:00 | Sunday | 12:00PM | PVF 7 | 859 | 853 |  | 2013-03-17 00:00:00 | Sunday | 12:00PM | PVF 7 | 854 | 857
2013-02-17 00:00:00 | Sunday | 1:00PM | PVF 7 | 857 | 855 |  | 2013-03-17 00:00:00 | Sunday | 1:00PM | PVF 7 | 852 | 859
2013-02-17 00:00:00 | Sunday | 2:00PM | PVF 7 | 856 | 860 |  | 2013-03-17 00:00:00 | Sunday | 2:00PM | PVF 7 | 851 | 860
2013-02-17 00:00:00 | Sunday | 3:00PM | PVF 7 | 858 | 854 |  | 2013-03-17 00:00:00 | Sunday | 3:00PM | PVF 7 | 853 | 858
2013-02-24 00:00:00 | Sunday | 11:00AM | PVF 7 | 852 | 853 |  | 2013-04-07 00:00:00 | Sunday | 11:00AM | PVF 7 | 856 | 857
2013-02-24 00:00:00 | Sunday | 12:00PM | PVF 7 | 851 | 854 |  | 2013-04-07 00:00:00 | Sunday | 12:00PM | PVF 7 | 855 | 858
2013-02-24 00:00:00 | Sunday | 1:00PM | PVF 7 | 858 | 856 |  | 2013-04-07 00:00:00 | Sunday | 1:00PM | PVF 7 | 853 | 851
2013-02-24 00:00:00 | Sunday | 2:00PM | PVF 7 | 857 | 860 |  | 2013-04-07 00:00:00 | Sunday | 2:00PM | PVF 7 | 852 | 860
2013-02-24 00:00:00 | Sunday | 3:00PM | PVF 7 | 859 | 855 |  | 2013-04-07 00:00:00 | Sunday | 3:00PM | PVF 7 | 854 | 859
2013-03-03 00:00:00 | Sunday | 11:00AM | PVF 7 | 853 | 854 |  | 2013-04-14 00:00:00 | Sunday | 11:00AM | PVF 7 | 857 | 858
2013-03-03 00:00:00 | Sunday | 12:00PM | PVF 7 | 852 | 855 |  | 2013-04-14 00:00:00 | Sunday | 12:00PM | PVF 7 | 856 | 859
2013-03-03 00:00:00 | Sunday | 1:00PM | PVF 7 | 859 | 857 |  | 2013-04-14 00:00:00 | Sunday | 1:00PM | PVF 7 | 854 | 852
2013-03-03 00:00:00 | Sunday | 2:00PM | PVF 7 | 858 | 860 |  | 2013-04-14 00:00:00 | Sunday | 2:00PM | PVF 7 | 853 | 860
2013-03-03 00:00:00 | Sunday | 3:00PM | PVF 7 | 851 | 856 |  | 2013-04-14 00:00:00 | Sunday | 3:00PM | PVF 7 | 855 | 851
Spreadsheet: 0bd7731e-d3a4-49dc-bda1-f9a3bf35d124
Sheet: Sheet1

2004-11-02 00:00:00 | State Senate - District No. 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Gallus, r | Sorlucco, d | [NAME] |  | Votes | Cast | Difference
Albany | 171 | 183 | 2 |  | 356 | 397 | -41
Atkinson and [NAME]. Gt. | -- | -- | -- |  | -- | -- | --
[NAME] | 941 | 810 | 1 |  | 1752 | 1947 | -195
Bean's Grant | -- | -- | -- |  | -- | -- | --
Bean's Purchase | -- | -- | -- |  | -- | -- | --
[NAME] | 685 | 453 |  |  | 1138 | 1185 | -47
[NAME] | 773 | 434 |  |  | 1207 | 1249 | -42
[NAME] 3 | 924 | 450 |  |  | 1374 | 1411 | -37
[NAME] 4 | 609 | 444 |  |  | 1053 | 1112 | -59
Bethlehem | 607 | 718 | 0 |  | 1325 | 1417 | -92
Cambridge | 1 | 1 |  |  | 2 | 2 | --
Carroll | 233 | 192 |  |  | 425 | 505 | -80
[NAME]'s Purchase | -- | -- | -- |  | -- | -- | --
[NAME] | 99 | 33 |  |  | 132 | 151 | -19
Colebrook | 655 | 290 | 1 |  | 946 | 1031 | -85
Columbia | 254 | 75 |  |  | 329 | 360 | -31
Crawford's Purchase | -- | -- | -- |  | -- | -- | --
Cutt's Grant | -- | -- | -- |  | -- | -- | --
[NAME] | 311 | 169 | 1 |  | 481 | 511 | -30
Dix's Grant | -- | -- | -- |  |  | -
Dixville | 19 | 7 |  |  | -- | -- | --
Dummer | 139 | 50 |  |  | -- | -- | --
Errol | 140 | 43 |  |  | 183 | 201 | -18
Erving's Location | -- | -- | -- |  | -- | -- | --
Franconia | 336 | 374 |  |  | 710 | 751 | -41
[NAME] | 988 | 636 |  |  | 1624 | 1702 | -78
Green's Grant | 3 | 0 | -- |  | -- | -- | --
Hadley's Purchase | -- | -- | -- |  | -- | -- | --
Hale's Location | 81 | 15 |  |  | -- | -- | --
Hart's Location | 17 | 12 |  |  | 29 | 31 | -2
[NAME] | 319 | 342 | 1 |  | 662 | 730 | -68
[NAME] | 409 | 164 |  |  | 573 | 604 | -31
Kilkenny | -- | -- | -- |  |  | -
Lancaster | 1033 | 786 | 2 |  | 1821 | 1728 | 93
Lincoln | 457 | 307 |  |  | 764 | 845 | -81
Lisbon | 443 | 288 | 1 |  | 732 | 728 | 4
Littleton | 1725 | 1183 | 5 |  | 2913 | 3082 | -169
Livermore | -- | -- | -- |  |  | 0
Low and Burbank's Grant | -- | -- | -- |  | -- | -- | --
[NAME] | 174 | 118 |  |  | 292 | 311 | -19
Martin's Location | -- | -- | -- |  | -- | -- | --
Milan | 475 | 252 |  |  | 727 | 741 | -14
[NAME] | 15 | 0 |  |  | 15 | 15 | 0
Northumberland | 571 | 442 |  |  | 1013 | 1066 | -53
[NAME] | -- | -- | -- |  | -- | -- | --
[NAME]'s Grant | 1 | 15 | -- |  |  | 23
Pittsburg | 373 | 122 |  |  | 495 | 528 | -33
Randolph | 136 | 118 |  |  | 254 | 275 | -21
Sargent's Purchase | -- | -- | -- |  | -- | -- | --
Second College Grant | -- | -- | -- |  | -- | -- | --
Shelburne | 190 | 91 |  |  | -- | -- | --
[NAME] | 173 | 110 |  |  | 283 | 287 | -4
 |  |  |  |  | 0 | 299 | -299
 | Sorlucco, r | Gallus, d | [NAME]
Stewartstown | 264 | 128 |  |  | 392 | 429 | -37
[NAME] | 160 | 125 |  |  | 285 | 305 | -20
Success | -- | -- | -- |  |  | -
[NAME] | 160 | 218 |  |  | 378 | 407 | -29
Thompson & Meserve's Purchase | -- | -- | -- |  | -- | -- | --
Waterville Valley | 98 | 76 |  |  | 174 | 196 | -22
Wentworth's Location | 21 | 5 |  |  | 26 | 27 | -1
[NAME] | 639 | 469 | 2 |  | 1110 | 1166 | -56
Totals | 15822 | 10748 | 16 |  | 26586 |  | 26586
Spreadsheet: 779967d1652213421-dynamic-named-ranges-and-indirect-workaround-dynamicindirect_example
Sheet: Sheet1

Customer | Item |  |  |  | Customer | Item
Name1 | Item P |  |  |  | Name3 | [NAME]
[NAME] | Item P
Name3 | Item P
Name3 | Item S
Name3 | [NAME]
Name4 | Item P
Name5 | Item P
Name6 | Item P
Name7 | Item P
Name8 | Item P
Name9 | Item P
Name10 | Item P
Name10 | Item S
Name11 | Item P
Name12 | Item P
Name13 | Item P
Name14 | Item P
Name15 | Item P
[NAME] | Item P
[NAME] | Item S
Spreadsheet: 734360d1622124672-formula-to-calculate-days-overdue-depending-on-the-status-dates-overdue_jenbug15
Sheet: Task Log

 |  |  |  | This coloumn indicates when status were changed to [NAME], Opened and Completed
 | Todays date for conditional formatting --->
Status | Date Created | Target Date | Type | Status Closed Date | Past Target Date
Signed Off | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-04-16 00:00:00
Signed Off | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-04-16 00:00:00
Signed Off | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-04-16 00:00:00
Signed Off | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-04-16 00:00:00
Signed Off | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-04-23 00:00:00
Opened | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Signed Off | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-04-19 00:00:00
Signed Off | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-04-13 00:00:00
Opened | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Opened | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Opened | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Completed | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Completed | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Opened | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Opened | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Signed Off | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-04-19 00:00:00
Opened | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Opened | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Completed | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Opened | 2021-03-25 00:00:00 | 2021-03-31 00:00:00 | Snag | 2021-03-25 00:00:00
Spreadsheet: 265678d1379363674-how-to-track-hours-with-a-12-month-revolving-clock-revolvingclock
Sheet: Sheet1

SUPERVISOR | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Employee X | Employee Y | Employee Name | Employee Name | Employee Name | Employee Name | GRAND TOTALS
 | 624 | 999 | 999 | 999 | 100 | 999
6/26/13 - 7/9/13 | 24 | 78 | 72 | 64 | 0 | 56
7/10/13 - 7/23/13 | 24 | 76 | 80 | 80 | 9 | 80
7/24/13 - 8/6/13 | 24 | 80 | 68 | 64 | 16 | 80
8/7/13 - 8/20/13 | 24 | 56 | 64 | 43.5 | 29.3 | 48
8/21/13 - 9/3/13 | 32 | 40 | 8 | 24 | 12 | 8
9/4/13 - 9/17/13 | 24 | 28 | 16 | 26.5 | 10 | 28
9/18/13 - 10/1/13 | 24 | 40 | 32 | 40 | 10 | 32
10/2/13 - 10/15/13 | 24 | 32 | 32 | 24 | 10 | 32
10/16/13 - 10/29/13 | 24 | 32 | 16 | 24 | 10 | 32
10/30/13 - 11/12/13 | 24 | 32 | 16 | 24 | 10 | 32
11/13/13 - 11/26/13 | 24 | 0 | 16 | 24 | 0 | 32
11/27/13 - 12/10/13 | 24 | 0 | 0 | 16 | 0 | 16
12/11/13 - 12/24/13 | 24 | 0 | 0 | 11 | 0 | 7
12/24/13 - 1/7/14 | 24 | 0 | 0 | 0 | 0 | 0
1/8/14 - 1/21/14 | 24 | 0 | 18 | 0 | 0 | 0
1/22/14 -  2/4/14 | 24 | 0 | 18 | 8 | 0 | 0
2/5/14 - 2/18/14 | 24 | 0 | 32 | 16 | 0 | 16
2/19/14 - 3/4/14 | 24 | 32 | 32 | 24 | 0 | 16
3/5/14 - 3/18/14 | 24 | 32 | 32 | 48 | 0 | 32
3/19/14 - 4/1/14 | 24 | 40 | 43 | 48 | 0 | 32
4/2/14 - 4/15/14 | 24 | 50 | 48 | 48 | 0 | 32
4/16/14 - 4/29/14 | 24 | 52 | 48 | 44 | 0 | 48
4/30/14 - 5/13/14 | 24 | 60 | 48 | 56 | 0 | 56
5/14/14 - 5/27/14 | 24 | 54 | 64 | 56 |  | 60
5/28/14 - 6/10/14 | 24 | 64 | 64 | 64 |  | 64
6/11/14 - 6/24/14 | 24 | 80 | 80 | 80 |  | 80
Used to Date - FY14
Available - FY14
Spreadsheet: 674696d1587991489-formulas-with-conditions-fruitorders
Sheet: Feuil1

Fruit | Quantity | Country |  |  |  |  |  | Fruit | Country
Apple | 20 | USA |  | USA | Quantity | # of orders (excluding 0) |  | [NAME] | USA
[NAME] | 40 | USA |  | [NAME] |  |  |  | Pear | Argentina
[NAME] | 15 | USA |  | Pear |  |  |  | Apple | Canada
Orange | 25 | USA |  | Apple |  |  |  | Orange | Mexico
Orange | 5 | USA |  | Orange |  |  |  | Lemon | Brazil
Pear | 5 | USA |  | Lemon
Orange | 15 | Mexico
Pear | 10 | Mexico
Pear | 10 | Mexico |  | Argentina | Quantity | # of orders (excluding 0)
Pear | 5 | Canada |  | [NAME]
Apple | 20 | Canada |  | Pear
[NAME] | 5 | Canada |  | Apple
Lemon | 5 | Canada |  | Orange
Pear | 0 | Canada |  | Lemon
Apple | 15 | Brazil
[NAME] | 10 | Brazil
Lemon | 10 | Brazil |  | Canada | Quantity | # of orders (excluding 0)
Orange | 0 | Brazil |  | [NAME]
Pear | 5 | Brazil |  | Pear
Apple | 5 | Argentina |  | Apple
Apple | 10 | Argentina |  | Orange
[NAME] | 20 | Argentina |  | Lemon
[NAME] | 10 | Argentina
Pear | 10 | Argentina
 |  |  |  | Mexico | Quantity | # of orders (excluding 0)
 |  |  |  | [NAME]
 |  |  |  | Pear
 |  |  |  | Apple
 |  |  |  | Orange
 |  |  |  | Lemon
 |  |  |  | Brazil | Quantity | # of orders (excluding 0)
 |  |  |  | [NAME]
 |  |  |  | Pear
 |  |  |  | Apple
 |  |  |  | Orange
 |  |  |  | Lemon