tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 20bddffa-38c8-4ab4-a472-e6722e57ee79
Sheet: Appraiser and Surveyor Info

Farm and Ranch Land Protection Program (FRPP)
Appraiser and Surveyor Summary Information
1 | Entity or Entities Associated with the Parcel:
2 | Name(s) of the landowners of the parcel as stated in the deed: (All names on the deed must become [NAME])
3 | If a partnership or corporation, names of all partners or shareholders.  Power of attorney or authorized agent if needed. (please attach)
4 | Physical Address of the parcel: (required for Phase I) |  |  |  |  | Mailing Address of landowner(s):
5 | Legal Description of the parcel.  (Attach copy of deed, deeds or will) |  |  |  |  | Deed Book(s)
 |  |  |  |  |  | Page Number(s)
 |  |  |  |  |  | Tax Map
 |  |  |  |  |  | Parcel Number
6 | [NAME] of the parcel in acres offered for easement. |  |  |  |  |  |  | Notes
 |  | Easement (Including Exhibit B & D) |  |  |  |  | Acres
 |  | Residential Dwelling (Exhibit B) |  |  |  |  | Acres | 2 ac max per & subject to easement
 |  | Retained Development (Exhibit D) |  |  |  |  | Acres | 2 ac max per & subject to easement
 |  | Locally Funded Only Area |  |  |  |  | Acres | Not funded by NRCS contribution
 |  | Donated Area |  |  |  |  | Acres | Not funded by NRCS contribution
 |  | Exception Area |  |  |  |  | Acres | Will be subdivided prior to closing - not funded.
 |  | Area offered to NRCS |  |  |  |  | Acres | NRCS Easement
 |  | Total Area of Easement |  |  |  |  | Acres
 |  | Total Farm Size |  |  |  |  | Acres
Spreadsheet: 56750d1256847130-lookup-with-repeating-values-budget_model
Sheet: Summary

 | Actual | Actual | Actual | Actual | Actual | Actual
 | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6
 | 2009/10 | 2009/10 | 2009/10 | 2009/10 | 2009/10 | 2009/10
444588  Prime Wages/salaries
444584  Prime Oth Emp. Costs
444588  Prime Overtime Costs
444548  Prime Social Charges
444588  Prime Health care
444558  [NAME] pens
444568  Prime Bonuses
444578  Prme Temporary Staff
444598  Prime Company Cars
448506  Prod Labour-Contract
*        Production Prime Labour | 0 | 0 | 0 | 0 | 0 | 0
444588  Prime Wages/salaries
444584  Prime Oth Emp. Costs
444588  Prime Overtime Costs
444548  Prime Social Charges
444548  [NAME] pension
444558  [NAME] pens
444568  Prime Bonuses
444578  Prme Temporary Staff
*        Distribution Labour | 0 | 0 | 0 | 0 | 0 | 0
**       Total Distribution Costs | 0 | 0 | 0 | 0 | 0 | 0
444586  Ohd Wages & salaries
444587  Ohd Other Emp. Costs
444588  O'hd Overtime Costs
444546  Ovrhd Social Charges
444586  Overhead Health Care
444556  [NAME] pens
444566  Overhead Bonuses
444576  Ovhd Temporary Staff
444599  Ovrhd Other benefits
446686  Pension Administration
*        Production Overhead Labour
***      Total Production Overhead | 0 | 0 | 0 | 0 | 0 | 0
444586  Ohd Wages & salaries
*        Site Overhead Labour | 0
***      Total Site Overheads | 0 | 0 | 0 | 0 | 0 | 0
444586  Ohd Wages & salaries
444587  Ohd Other Emp. Costs
444588  O'hd Overtime Costs
444546  Ovrhd Social Charges
444586  Overhead Health Care
444546  Ohd Def Cnt pension
444556  [NAME] pens
444566  Overhead Bonuses
444576  Ovhd Temporary Staff
446686  Pension Administration
*        Sales Overhead Labour | 0 | 0 | 0 | 0 | 0 | 0
***      Total Sales Overhead | 0 | 0 | 0 | 0 | 0 | 0
444586  Ohd Wages & salaries
444587  Ohd Other Emp. Costs
444588  O'hd Overtime Costs
444546  Ovrhd Social Charges
444586  Overhead Health Care
444556  [NAME] pens
444557  DB Ovhd Exec Pension
444566  Overhead Bonuses
444576  Ovhd Temporary Staff
444599  Ovrhd Other benefits
446686  Pension Administration
*        Administration Overhead Labour | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 275822d1383657505-sumproduct-indirect-array-containing-both-ors-and-ands-example3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Cost break down by individual code per year
 | This is a named array |  |  |  |  |  |  |  |  | 11111
 | Sheet Names |  |  |  |  |  |  |  |  | Year | cost1 | cost2 | cost3 | Total
 | Sheet2 |  |  |  |  |  |  |  |  | 2012
 | Sheet3 |  |  |  |  |  |  |  |  | 2013
 | Sheet4 |  |  |  |  |  |  |  |  | 2014
 |  |  |  |  |  |  |  |  |  | 2015
 |  |  |  |  |  |  |  |  |  | 2016
 |  |  |  |  |  |  |  |  |  | 2017
 |  |  |  |  |  |  |  |  |  | 2018
 |  |  |  |  |  |  |  |  |  | 2019
 |  |  |  |  |  |  |  |  |  | 2020
 |  |  |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  |  |  | 2022
 |  |  |  |  |  |  |  |  |  | 2023
 |  |  |  |  |  |  |  |  |  | 2024
 |  |  |  |  |  |  |  |  |  | 2025
 |  |  |  |  |  |  |  |  |  | 9999
Spreadsheet: 108987d1305901072-excel-2007-multiple-frequencies-example
Sheet: Sheet1

1 | 7 | 6 | 12 |  | 1-2 | 4-5 | 3-8 | 9-11
2 | 4 | 8 | 2
5 | 4 | 12 | 8
2 | 6 | 4 | 10
1 | 6 | 5 | 10
Spreadsheet: 83388d1283367301-excel-2007-adding-multiple-data-labels-chart
Sheet: Sheet1

 | A | B | C
1 | 15 | 15 | 5
2 | 16 | 13 | 32
3 | 17 | 24 | 15
4 | 19 | 5 | 22
5 | 8 | 28 | 19
Spreadsheet: 167939d1342163187-sumproduct-with-date-restrictions-my-test
Sheet: Trips Totals

 | 2009 |  |  |  | 2010 |  |  |  |  |  |  | West | Midwest | Notheast | South | Pacific
Region | 1st QTR | 2nd QTR | 3rd QTR | 4th QTR | 1st QTR | 2nd QTR | 3rd QTR | 4th QTR |  |  |  | WA | ND | ME | TX | HI
West |  |  |  |  |  |  |  |  |  |  |  | OR | SD | NH | OK | AL | These will be hidden and used as helpers
Midwest |  |  |  |  |  |  |  |  |  |  |  | ID | NE | VT | AR
South |  |  |  |  |  |  |  |  |  |  |  | MT | KS | MA | LA
Northeast |  |  |  |  |  |  |  |  |  |  |  | WY | MN | CT | MS
Pacific |  |  |  |  |  |  |  |  |  |  |  | CA | IA | RI | AL
 | 2011 |  |  |  | 2012 |  |  |  |  |  |  | NV | MO | NY | GA
Region | 1st QTR | 2nd QTR | 3rd QTR | 4th QTR | 1st QTR | 2nd QTR | 3rd QTR | 4th QTR |  |  |  | UT | WI | PA | FL
West |  |  |  |  |  |  |  |  |  |  |  | CO | IL | NJ | SC
Midwest |  |  |  |  |  |  |  |  |  |  |  | AZ | IN |  | TN
South |  |  |  |  |  |  |  |  |  |  |  | NM | OH |  | KY
Northeast |  |  |  |  |  |  |  |  |  |  |  |  | MI |  | NC
Pacific |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VA
 | 2009 |  |  |  |  |  |  |  |  |  |  |  |  |  | MD
 | 1st QTR | 2nd QTR | 3rd QTR | 4th QTR |  |  | CA & OR Total |  |  |  |  |  |  |  | DE
CA & OR |  |  |  |  |  |  |  |  | but I want to be able to find it based on year and quarter as well. [NAME] I used is below
NV |  |  |  |  |  |  | *(=SUMPRODUCT(--(ISNUMBER(SEARCH("CA",Trips!A:A))+ISNUMBER(SEARCH("OR",Trips!A:A))>0))
OK, TX
NE, CO
Spreadsheet: 51247d1250779351-function-to-group-like-rows-sample
Sheet: Sheet1

 | Origin | Destination
 | #01EI207 | AEI193
 | ASM33 | BSM33
 | #01SS38 | PPSS26
 | AWD35 | CWD32
 | ASS219 | FSS208
 | ASM50 | ASM49
 | #01EI193 | AEI193
 | AEI193 | BEI215
 | BEI215 | AEI188
 | BWD35 | AWD35
 | BSS219 | ASS219
 | DWD75 | AWD90
 | AWD90 | DWD75
 | DWD75 | FWD75
 | FWD75 | DWD75
 | CWD89 | BWD90
 | #04SM33 | BSM33
 | BSS219 | ASS219
 | CSS219 | ASS219
 | C PlatformST161 | A PlatformST161
Spreadsheet: 41250d1239739584-updating-dates-on-separate-tabs-based-on-date-in-first-tab-form-booking-sheets-all-1
Sheet: T17

Boeing Tour - AM |  |  |  |  | 2009-05-24 00:00:00
 | Driver: |  |  |  | Vehicle: |  |  |  |  |  | Prepaid
P/U Time | Booked by |  | Hotel |  | Party | A | C | CT | MF | Amt | CC | Ck | Collect | [NAME]
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
Daily Total:
Pricing
Retail: | Adult | 55 | Child | 45 | Reseller: | Adult |  | 44 | Child |  | 36
Resellers: Alcatraz Media, [NAME], Look Tours, Sightseeing World, TourCorp
Driver Pickup Summary
Spreadsheet: 802676d1666967203-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: Table 17

 |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  |  | Invoice #
 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-20 00:00:00 |  |  |  |  | 80031
 | [NAME] |  |  |  |  |  |  |  |  | Ship To
 | BW Papersystems Company P.O. Box 4717 [EMAIL] Timonium, MD 21094-4717 |  |  |  |  |  |  |  |  | BW Papersystems Co. 10615 Beaver Dam Road Hunt Valley, MD 21030-2204
P.O. Number |  |  | Terms |  | Rep |  | Ship |  | Via |  | F.O.B. |  |  |  | Project
PN45440 |  |  | 2%10NET45 |  | HOUSE |  | 2022-10-20 00:00:00 |  | UPS |  | Richmond, VA
Quantity |  | Item Code |  | Description |  |  |  |  |  |  |  | Price |  | Each |  |  | Amount
2 |  | 220129 |  | ROD, FINE ADJUST, ANILOX, 39'' |  |  |  |  |  |  |  | 19.15 |  |  |  |  | 38.3
2 |  | 20MATERIAL |  | Material Surcharge |  |  |  |  |  |  |  | 20 |  |  |  |  | 40
1 |  | 274730 |  | RET, BRG, LOCATOR SFT ENT, ALX FL |  |  |  |  |  |  |  | 121 |  |  |  |  | 121
1 |  | 30MATERIAL |  | Material Surcharge |  |  |  |  |  |  |  | 30 |  |  |  |  | 30
4 |  | 300855 |  | SPACER SET, BEARING IDLER GEAR SPPT N/C REG, 66 |  |  |  |  |  |  |  | 66 |  |  |  |  | 264
 |  |  |  | IN
4 |  | 30MATERIAL |  | Material Surcharge |  |  |  |  |  |  |  | 30 |  |  |  |  | 120
3 |  | 300859 |  | SPACER IDLER SUPPORT N/C REG AFTERMARKET |  |  |  |  |  |  |  | 37 |  |  |  |  | 111
3 |  | 20MATERIAL |  | Material Surcharge |  |  |  |  |  |  |  | 20 |  |  |  |  | 60
2 |  | 41522 |  | EXTENSION, AIR CYL FLEXO MODEL 15 |  |  |  |  |  |  |  | 9.5 |  |  |  |  | 19
2 |  | 8MATERIAL |  | Material Surcharge |  |  |  |  |  |  |  | 8 |  |  |  |  | 16
1 |  | 438519 |  | STOP, OSC MECH 66 OLD RETRO |  |  |  |  |  |  |  | 36.25 |  |  |  |  | 36.25
1 |  | 10MATERIAL |  | Material Surcharge |  |  |  |  |  |  |  | 10 |  |  |  |  | 10
1 |  | 441067 |  | SPACER, OS DC REG 66AM |  |  |  |  |  |  |  | 71.5 |  |  |  |  | 71.5
1 |  | 50MATERIAL |  | Material Surcharge |  |  |  |  |  |  |  | 50 |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  | 987.05
Payments/Credits |  |  |  | 0 |  |  |  | Balance Due |  |  |  |  |  |  |  | 987.05
Spreadsheet: 879745d1727292596-fomula-to-create-secondary-list-remaining-fixures-jt-
Sheet: Sheet1

 | UNPLAYED FIXTURES |  | SEARCH RESULTS |  |  | NAME SEARCH |  | CARACALLA |  |  | NAMES
 | [NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | Callum Beddow
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | [NAME] [NAME] |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] Mandry
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] Mandry
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] Mandry
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] Marshall
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
 | 0 - 0
Spreadsheet: 438304d1451920925-find-and-report-the-first-value-over-6000-in-a-row-excell-example
Sheet: Sheet1

Acc Name | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | Amount when sales target reached | Month sales target reached
C I S INDUSTRIAL LTD |  |  |  |  |  |  | 7690 | 10940 | 14399 | 16425 | 23242 | 22524 | 26158 | 26190 | 32949 | 29816 | 30870 | 31094
ITV PLC T/A ITV YORKSHIRE
JMS OF DONCASTER LTD
POTTER LOGISTICS LTD |  |  |  |  | 2449 | 7967 | 8241 | 5556 | 6716 | 4346 | 2906 | 1651 | 2488 | 4483 | 4236 | 4096
SIMON WIDDOWSON LTD | 3285 | 2449 | 2078
WILFREDA BEEHIVE | 737
#A HINGLEY TRANSPORT (BRIERLEY | 592
#B & M RETAIL |  |  |  |  | 132 | 1711 | 2808 | 554 | 159 | 705 | 303 | 728 | 738 | 681 | 940 | 0
#FLIGHTS HALLMARK LTD (ROTOLA | 120 | 62 | 0 | 26 | 22
#HUGHES BROS (LLANRWST & | 40
A F BLAKEMORE & SON LTD
AIR PRODUCTS PLC |  |  |  |  |  |  |  |  |  | 80 | 0 | 19 | 142 | 239 | 525 | 1864 | 1147 | 840 | 0 | 0 | 0
ATS REF PJH GROUP |  |  |  |  |  |  |  |  | 66 | 239 | 434 | 0 | 0 | 1934 | 728 | 226 | 544 | 2334 | 0 | 0
ATS REF VPS (UK) LTD |  |  |  |  | 2143 | 0 | 520 | 0 | 620 | 0 | 0 | 2568 | 0 | 248 | 0 | 0
BENTONS HAULAGE LTD | -334 | 0 | 0 | 0 | 0 | 0 | 0
CAR & COMMERCIAL/STVA LTD | 2155 | 2578 | 2792
CARLTON HIRE LTD T/A CARLTON | 456
D J B HAULAGE LTD | 7124
DIGNITY FUNERALS LTD |  |  |  |  |  |  | 5857 | 2895 | 7980 | 7296 | 4438 | 4594 | 6761 | 4237 | 4571 | 3212 | 5695 | 5582
ENGLISH LANDSCAPES LTD |  |  |  |  |  |  | 506 | 403 | 299 | 592 | 154 | 301 | 287 | 324 | 126 | 105 | 183 | 132
EURO CAR PARTS LTD (SMR)
FLIGHTS HALLMARK LTD |  |  |  |  | 197 | 2213 | 4100 | 3920 | 5249 | 5088 | 3434 | 1599 | 6808 | 4281 | 2873 | 4652
GILDERS TRANSPORT LTD |  |  | 284 | 517 | 697 | 667 | 1011 | 931 | 884 | 725 | 613 | 490 | 207 | 185
GMG ASSET MANAGEMENT UK LTD
 |  |  |  |  | 921 | 1652 | 1006 | 4281 | 4443 | 3812 | 1310 | 5555 | 2094 | 773 | 310 | -1323
 | 0 | 766 | 393 | 2547 | 591 | 0 | 0 | 0 | 334 | 1495 | 0
 |  |  |  |  |  |  | 73 | 67 | 165 | 62 | 67 | 0 | 175 | 215 | 88 | 132 | 134 | 73
 |  |  |  |  |  |  |  |  |  |  |  | 132 | 0 | -14 | 0 | 0 | 0 | 0 | 97 | 0 | -208 | 0 | 0
 | 35 | 702 | 853 | 735 | 773 | 841 | 882
 | 0 | 0 | 0 | 0 | 0 | 0
 | 251 | 349
Spreadsheet: 69985d1270649170-formula-to-create-a-single-count-covering-multiple-conditions-forumcounts
Sheet: Sheet1

Application ID | Student | Team Type | District | Status
1 | [NAME] | School | FGR | Successful
1 | [NAME] | School | FGR | Successful
2 | [NAME] | Individual | SDR | Successful
3 | [NAME] | School | NDY | Unsuccessful
3 | [NAME] | School | NDY | Unsuccessful
4 | Meagan | Individual | FGR | Unsuccessful
5 | Michelle | School | NDY | Unsuccessful
5 | [NAME] | School | NDY | Unsuccessful
6 | Mark | School | NDY | Successful
6 | [NAME] | School | NDY | Successful
6 | Vince | School | NDY | Successful
Trying to resolve: For each District what is the breakdown of each Team Type and how many had a status of "Successful"
eg for District "NDY" there are 3 applications (based on Application ID) with "School" as the Team Type, with one being "Successful"
I tried a formula for the Team Type "Individual" that appears to work (not sure if there is an easier method), but formula doesn't work for "School" Team type because it counts individual rows.
 |  |  |  |  |  | Expected Results
District | Individual |  | School |  |  | School
 | Total | Successful | Total | Successful |  | Total | Successful
FGR | 1 | 0 | ? | ? |  | 1 | 1
SDR | 1 | 1 | ? | ? |  | 0 | 0
NDY | 0 | 0 | ? | ? |  | 3 | 1
Total | 2 | 1 | 0 | 0 |  | 4 | 2
Spreadsheet: 699818d1602775778-help-with-extracting-data-from-a-table-example-1
Sheet: Sheet1

 |  |  |  | Main Table
Question |  |  |  | A1 | A2
1 | 1 | Highest common occuring number (Column A1), ignore 0 and spaces. |  | 1 | 0.13
 |  | In this example id want 1 to display not 0. |  | 2 | 0.14 |  | Example 1 |  |  | Example 2
 | 7 | Count of highest common occurring number. (Column A1), ignore 0 and spaces. |  | 1 | 0.2 |  | A1 | A2
2 |  |  |  | 0 | 0.45 |  | 1 | 0.13 |  | Total Count Not inc  0 or spaces) | Count of highest  common occurring number. (Column A1) | Percentage of highest common  occurring number from total count.
 | 0.7 | Percent of the highest common occuring number from the total count of the column of [NAME] (ignore 0 and spaces.) |  | 0 | 0.13 |  | 1 | 0.2 |  | 10 | 7 | 0.7
3 |  | Example 2 |  | 0 | 0.15 |  | 1 | 0.45
 | 0.26375 | Avg score of A2 value, for the highest common occurring number (Column A1) |  | 6 | 0.3 |  | 1 | 0.13
4 |  | Example 1. |  | 0 | 0.4 |  | 1 | 0.15
 |  |  |  | 0 | 0.13 |  | 1 | 0.3
 |  |  |  | 4 | 0.14 |  | 1 | 0.45
 |  |  |  | 0 | 0.2 |  | 1 | 0.3
 |  |  |  | 1 | 0.45
 |  |  |  | 1 | 0.13 |  | Average:
 |  |  |  | 1 | 0.15
 |  |  |  | 0 | 0.13
 |  |  |  | 0 | 0.13
 |  |  |  | 0 | 0.14
 |  |  |  | 0 | 0.2
 |  |  |  | 1 | 0.45
 |  |  |  | 0 | 0.13
 |  |  |  | 0 | 0.15
 |  |  |  | 1 | 0.3
 |  |  |  | 0 | 0.4
Spreadsheet: 780250d1652360762-return-blank-when-the-dates-from-to-are-not-within-those-dates-range-formula
Sheet: Payroll Week

Payroll Week
TASKS LIST | 2022-05-09 00:00:00
Missing Comp Plan (HX_TL_EMP_MISSING_COMPPLAN_ENR)
Spreadsheet: 375930d1423412407-need-help-cleaning-up-pasted-text-and-comparing-two-lists-packingnotecomparison-2-
Sheet: Paste Packing Note

Open packing-slip-template.pdf mark everything by pressing ctrl-a and paste in the yellow field below with ctrl-v |  |  |  |  |  |  |  |  |  |  |  |  |  | Quantity | Article | Name
Page 1 Date: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Data |  |  | Helper fot Total
Quantity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Article | Name | Quantity
100
4
1
8
113
Packed By:
Signature
My Company name [NAME]
My company slogan
Ship To: Shipping Address: (If [NAME]) februari 8, 2015
[Name] [Name] Customer ID: [ABC12345]
[Company Name] [Company Name] Order Date
[Street Address] [Street Address] Purchase Order # [100001]
[City, ST ZIP Code] [City, ST ZIP Code] Salesperson [NAME]
[Phone] [Phone] Packing Date
Description
84455661
Lollipop
jklj888787
665466477
Snickers
hkjsdhjfkhsdf
1546464321
Fatboy sugarbomb
hkjsdhjfkhsdf
54878454888
High sugar no vitamins drink
1234545
Special Notes Total Quantity of Goods/Boxes
[Name]
Checked By: [Managers Name]
[Managers Signature]
Page 2 Date:
Quantity
2
4
1
20
27
Packed By:
Signature
Ship To: Shipping Address: (If [NAME]) februari 8, 2015
[Name] [Name] Customer ID: [ABC12345]
[Company Name] [Company Name] Order Date
[Street Address] [Street Address] Purchase Order # [100001]
[City, ST ZIP Code] [City, ST ZIP Code] Salesperson [NAME]
[Phone] [Phone] Packing Date
Description
394948271
[NAME]
123jkhgjh
1546464321
Fatboy sugarbomb
hkjsdhjfkhsdf
1546464321
Fatboy sugarbomb
hkjsdhjfkhsdf
84455661
Lollipop
jklj888787
Special Notes Total Quantity of Goods/Boxes
[Name]
Checked By: [Managers Name]
[Managers Signature]
Page 3 Date:
Quantity
2
4
1
8
15
Packed By:
Signature
Ship To: Shipping Address: (If [NAME]) februari 8, 2015
[Name] [Name] Customer ID: [ABC12345]
[Company Name] [Company Name] Order Date
[Street Address] [Street Address] Purchase Order # [100001]
[City, ST ZIP Code] [City, ST ZIP Code] Salesperson [NAME]
[Phone] [Phone] Packing Date
Description
394948271
[NAME]
123jkhgjh
1546464321
Fatboy sugarbomb
hkjsdhjfkhsdf
1546464321
Fatboy sugarbomb
hkjsdhjfkhsdf
54878454888
High sugar no vitamins drink
1234545
Special Notes Total Quantity of Goods/Boxes
[Name]
Checked By: [Managers Name]
Thank you for your business! [Managers Signature]
Should you have any enquiries concerning this packing slip or your goods, please contact [NAME] on [PHONE]
111 Street, Town/City, County, ST, 00000
Tel: [PHONE] Fax: [PHONE] E-mail: [EMAIL] Web: www.yourcompanysite.com