tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 789065d1658875346-automatic-next-in-sequence-row-derived-by-specifying-a-fixed-number-of-separating-rows-carrier-tracking-download-clean-up-katiemkao-
Sheet: OnTrac

Tracking Results Overview |  |  |  |  |  | Tracking # | Status | ETA | Delivery Date | SHIP DATE |  | Tracking # | Status | ETA | Delivery Date | SHIP DATE
D10013155803339See Details » |  |  |  |  |  |  |  |  |  |  |  | D10013155803339 | Delivered | 05/25/22 at 08:00AM | 05/25/22 | 2022-05-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | D10013155803347 | Delivered | 05/25/22 at 08:00AM | 05/25/22 | 2022-05-24 00:00:00
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
D10013155803347See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
D10013155803363See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
D10013155803397See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
D10013155803404See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
D10013155803412See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-25 00:00:00
TO
FONTANA, CA
DELIVERED
06/01/22 at 09:00AM
D10013155803438See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-25 00:00:00
TO
FONTANA, CA
DELIVERED
06/01/22 at 09:00AM
D10013155803454See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
D10013155803462See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-25 00:00:00
TO
FONTANA, CA
DELIVERED
06/01/22 at 09:00AM
D10013155803488See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
D10013155803496See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-25 00:00:00
TO
FONTANA, CA
DELIVERED
06/01/22 at 09:00AM
D10013155803503See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
D10013155803529See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
[NAME] »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
D10013155803553See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
D10013155803561See Details »
Delivered
Delivery Signature: AMAZON
FROM
NEWARK, CA
LABEL CREATED
2022-05-24 00:00:00
TO
FONTANA, CA
DELIVERED
05/25/22 at 08:00AM
Spreadsheet: 46858d1245784469-creating-league-tables-rank-tiebreaking
Sheet: Positional

Player | Score | Rank | Rank |  | Winners | Rank | Player | Low is Best
Player # 1 | 10 | 1 | 1 |  |  | 1 | Player # 1
Player # 2 | 20 | 3 | 3 |  |  | 2 | Player # 8
Player # 3 | 30 | 5 | 5 |  |  | 3 | Player # 2
Player # 4 | 40 | 7 | 7 |  |  | 4 | Player # 9
Player # 5 | 50 | 9 | 9 |  |  | 5 | Player # 3 |  | This technique breaks a tie by giving precedence
Player # 6 | 60 | 11 | 11 |  |  | 6 | Player # 10 |  | to the player higher in the actual list.  If your lists
Player # 7 | 70 | 13 | 13 |  |  | 7 | Player # 4 |  | are sorted by some inherent "seniority" process, then
Player # 8 | 10 | 1 | 2 |  |  | 8 | Player # 11 |  | the person highest on the list gets the higher ranking.
Player # 9 | 20 | 3 | 4 |  |  | 9 | Player # 5
Player # 10 | 30 | 5 | 6 |  |  | 10 | Player # 12
Player # 11 | 40 | 7 | 8 |  |  | 11 | Player # 6
Player # 12 | 50 | 9 | 10 |  |  | 12 | Player # 13
Player # 13 | 60 | 11 | 12 |  |  | 13 | Player # 7
Player # 14 | 70 | 13 | 14 |  |  | 14 | Player # 14
 |  | WRONG | RIGHT
Spreadsheet: 272735d1382476072-how-to-use-a-v-lookup-function-or-something-else-return-the-values-in-a-range-of-cells-v-lookup-for-a-range-of-cells
Sheet: Sheet1

Code | Name | Age | Status | Type
94515 | [NAME] | 28 | x | New
93781 | Mark | 34 | x | New
97723 | [NAME] | 33 | x | Returning
44852 | [NAME] | 44 | x | Old
88597 | Jared | 30 | x | Returning
Spreadsheet: 837322d1690042788-how-do-you-provide-points-based-on-a-defined-lookup-targets-table-points-based-on-value
Sheet: Test

 | Test | Pts | Points Want |  | Test2 | Pts | Points want
[NAME] | 0.2285714285714286 |  | 0 |  | 28 |  | 10
[NAME] | 0.1568627450980392 |  | 2 | 2 | 30 |  | 10 | 10
[NAME] | 0.0967741935483871 |  | 10 | 10 | 35 |  | 5 | 5
[NAME] | 0.2051282051282051 |  | 0 | 0 | 20 |  | 10 | 10
[NAME] | 0.0652100391304347 |  | 10 | 10 | 10 |  | 10 | 10
[NAME] |  |  | 0 | 0 | 5 |  | 10 | 10
Area2 | 0.09302325581395349 |  | 10 | 10 | 20 |  | 10 | 10
Area2 | 0.09090909090909091 |  | 10 | 10 | 30 |  | 7 | 7
Area2 | 0.15 |  | 7 | 7 | 15 |  | 10 | 10
Area2 | 0.19 |  | 4 | 4 | 35 |  | 4 | 4
Spreadsheet: 707990d1607576252-count-if-above-or-below-set-time-count-total-time
Sheet: Sheet1

 |  | Count trucks below
 |  | Under 59 mins | over 60 mins |  |  |  | Truck size | Time |  | Truck size | Time |  | Truck size | Time
 | Semi 24 |  |  |  |  |  | Semi 22 | 01:00:00 |  | Semi 24 | 00:15:00 |  | B-Double | 00:54:00
 |  | Under 119 mins | over 120 mins |  |  |  | Semi 22 | 02:00:00 |  | Semi 24 | 00:42:00 |  | B-Double | 01:34:00
 | B-double |  |  |  |  |  | Semi 22 | 00:56:00 |  | Semi 24 | 00:30:00 |  | B-Double | 01:10:00
 |  |  |  |  |  |  | Semi 22 | 02:20:00 |  | Semi 24 | 02:02:00 |  | B-Double | 03:40:00
 |  |  |  |  |  |  | Semi 22 | 00:48:00 |  | Semi 24 | 01:30:00 |  | B-Double | 02:20:00
 |  |  |  |  |  |  | Semi 22 | 01:35:00 |  | Semi 24 | 01:31:00 |  | B-Double | 02:00:00
 | Sample
 |  | Count trucks below
 |  | Under 59 mins | over 60 mins
 | Semi 22 | 5 | 7
 |  | Under 119 mins | over 120 mins
 | B-double | 2 | 4
Spreadsheet: 857741d1706671275-solve-for-multiple-objective-cells-in-solver-sff-2024-solver-copy
Sheet: 2023 15Yr CF Tracking

 |  |  |  |  | 2023 PROJECTIONS
15 Year Cash Flow Tracking - Adjusted Exp - Modified Levies
Year | Year To | Opening Balance | Total Levy Contributions | Interest | Anticipated Expenses | Closing Balance | % Variance in Annual Levy
 |  |  | ([NAME]. GST) | (After Tax) | ([NAME]. GST)
1 | 2023-12-31 00:00:00 | 242275 | 75000 | 2160.68 |  | 97491.81 | 0
2 | 2024-12-31 00:00:00 | 97491.81 |  | 1422.73 |  | 126232.66 | 2
3 | 2025-12-31 00:00:00 | 126232.66 |  | 1507.19 |  | 110772.2 | 2
4 | 2026-12-31 00:00:00 | 110772.2 |  | 3092.2 |  | 167182.59 | 2
5 | 2027-12-31 00:00:00 | 167182.59 |  | 3244.08 |  | 124424.47 | 2
6 | 2028-12-31 00:00:00 | 124424.47 |  | 2669.1 |  | 115497.85 | 2
7 | 2029-12-31 00:00:00 | 115497.85 |  | 2042.47 | 141680.91 | 68097.51 | 2
8 | 2030-12-31 00:00:00 | 68097.51 |  | 2420.01 | 16088.18 | 149434.58 | 2
9 | 2031-12-31 00:00:00 | 149434.58 |  | 3774.28 |  | 189831.53 | 2
10 | 2032-12-31 00:00:00 | 189831.53 |  | 4728.42 |  | 235200.63 | 2
11 | 2033-12-31 00:00:00 | 235200.63 |  | 4597.57 |  | 178070.14 | 2
12 | 2034-12-31 00:00:00 | 178070.14 |  | 4701.05 |  | 244502.12 | 2
13 | 2035-12-31 00:00:00 | 244502.12 |  | 5778.35 |  | 274907.51 | 2
14 | 2036-12-31 00:00:00 | 274907.51 |  | 6813.95 |  | 337591.16 | 2
15 | 2037-12-31 00:00:00 | 337591.16 |  | 6772.99 |  | 271225.32 | 2
Spreadsheet: 703277d1604926847-sales-reoport-sums-raw-data-teh-looks-at-start-price-and-expire-price-sales-test
Sheet: RAW

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price
13015201 | 405 LHL SHADOW ATLAS | 13015201 | 2020-05-15 00:00:00 | 14:01:41 | ISS-SO | -3200 | 5600 |  | 3582 | 1 | 20001101 |  | May |  | 20
13015401 | 405 RHL SHADOW ATLAS | 13015401 | 2020-05-15 00:00:00 | 14:01:42 | ISS-SO | -1000 | 1000 |  | 3582 | 1 | 20001101 |  | May |  | 20
14258501 | 405 LHL BRIGHT CHROME | 14258501 | 2020-05-15 00:00:00 | 14:01:42 | ISS-SO | -500 | 500 |  | 3582 | 1 | 20001101 |  | May |  | 20
14469401 | 405 COV SHADOW ATLAS | 14469401 | 2020-05-27 00:00:00 | 06:12:14 | ISS-SO | -250 | 250 |  | 3565 | 3 | 20001101 |  | May |  | 22
14258101 | 405 LHL SANTORINI BLACK | 14258101 | 2020-05-27 00:00:00 | 06:12:15 | ISS-SO | -260 | 260 |  | 3565 | 3 | 20001101 |  | May |  | 22
14258301 | 405 RHL SANTORINI BLACK | 14258301 | 2020-05-27 00:00:00 | 06:12:15 | ISS-SO | -250 | 250 |  | 3565 | 3 | 20001101 |  | May |  | 22
14469501 | 405 N/L SANTORINI BLACK | 14469501 | 2020-05-27 00:00:00 | 06:12:39 | ISS-SO | -20 | 20 |  | AFIN | 5 | 20001101 |  | May |  | 22
14538301 | 405 COV SANTORINI BLACK | 14538301 | 2020-05-27 00:00:00 | 06:12:48 | ISS-SO | -66 | 180 |  | AFIN3223 | 4 | 20001101 |  | May |  | 22
14538401 | 405 COV BRIGHT CHROME | 14538401 | 2020-05-27 00:00:00 | 06:13:19 | ISS-SO | -2400 | 2400 |  | 3582 | 6 | 20001101 |  | May |  | 22
14258401 | 405 RHL NOBLE CHROME | 14258401 | 2020-05-27 00:00:00 | 12:20:16 | ISS-SO | -600 | 1829 |  | 3223 | 7 | 20001001 |  | May |  | 23
13015201 | 405 LHL SHADOW ATLAS | 13015201 | 2020-06-15 00:00:00 | 14:01:41 | ISS-SO | -3200 | 5600 |  | 3582 | 1 | 20001101 |  | Jun |  | 20
13015401 | 405 RHL SHADOW ATLAS | 13015401 | 2020-06-15 00:00:00 | 14:01:42 | ISS-SO | -1000 | 1000 |  | 3582 | 1 | 20001101 |  | Jun |  | 20
14258501 | 405 LHL BRIGHT CHROME | 14258501 | 2020-06-15 00:00:00 | 14:01:42 | ISS-SO | -500 | 500 |  | 3582 | 1 | 20001101 |  | Jun |  | 20
14469401 | 405 COV SHADOW ATLAS | 14469401 | 2020-06-27 00:00:00 | 06:12:14 | ISS-SO | -250 | 250 |  | 3565 | 3 | 20001101 |  | Jun |  | 22
14258101 | 405 LHL SANTORINI BLACK | 14258101 | 2020-06-27 00:00:00 | 06:12:15 | ISS-SO | -260 | 260 |  | 3565 | 3 | 20001101 |  | Jun |  | 22
14258301 | 405 RHL SANTORINI BLACK | 14258301 | 2020-06-27 00:00:00 | 06:12:15 | ISS-SO | -250 | 250 |  | 3565 | 3 | 20001101 |  | Jun |  | 22
14469501 | 405 N/L SANTORINI BLACK | 14469501 | 2020-06-27 00:00:00 | 06:12:39 | ISS-SO | -20 | 20 |  | AFIN | 5 | 20001101 |  | Jun |  | 22
14538301 | 405 COV SANTORINI BLACK | 14538301 | 2020-06-27 00:00:00 | 06:12:48 | ISS-SO | -66 | 180 |  | AFIN3223 | 4 | 20001101 |  | Jun |  | 22
14538401 | 405 COV BRIGHT CHROME | 14538401 | 2020-06-27 00:00:00 | 06:13:19 | ISS-SO | -2400 | 2400 |  | 3582 | 6 | 20001101 |  | Jun |  | 22
14258401 | 405 RHL NOBLE CHROME | 14258401 | 2020-06-27 00:00:00 | 12:20:16 | ISS-SO | -600 | 1829 |  | 3223 | 7 | 20001001 |  | Jun |  | 23
Spreadsheet: 814398d1674342848-incorporating-cash-receipts-in-a-sales-spreadsheet-s666-pq-sumifs-question_revised-v2
Sheet: Sheet1

Sales and Receipts
Date | Invoice # | Project | Customer | Amt Inv | Payor | Ch # | Check amount | Amt Rec to date | Balance
2022-01-24 00:00:00 | 12345 | Garden | BA | 1500 | ABC | 8766000 | 200
2022-01-25 00:00:00 | 12346 | Driveway | CD | 250 | DEF | 73886 | 150
2022-01-26 00:00:00 | 12347 | Porch | EF | 550 | KLM | [NAME] | 550
2022-01-28 00:00:00 | 12348 | Backyard | BA | 263 | ABC | 626262 | 35
2022-02-03 00:00:00 | 12346 | Driveway | CD | 250 | QCD | 23232 | 100
2022-03-04 00:00:00 | 12348 | Backyard | BA | 263 | STL | 987 | 228
2022-03-04 00:00:00 | 12345 | Garden | BA | 1500 | NYU | 2323 | 350
2022-03-08 00:00:00 | 12354 | Lawn | EF | 750 | ABC | 9876 | 25
2022-04-10 00:00:00 | 12354 | Lawn | EF | 750 | NYU | 72727 | 150
2022-05-15 00:00:00 | 12851 | Sidewalk | CD | 2000
2022-06-06 00:00:00 | 12345 | Garden | BA | 1500 | CQR | 12121 | 900
Account Receivable List
Customer | Project | Invoice # | Amt Inv | Check amount | Balance |  | The amount of invoice 12345 is $1500.00
BA | Garden | 12345 | 4500 | 1450 | 1950 |  | When  the formula deducts and cumulates the amount received from this invoice, the inv amt is added in the AR list and the balance is erroneous.
 | Garden Total |  | 4500 | 1450 | 1950
 | Backyard | 12348 | 526 | 263 | 228
 | Backyard Total |  | 526 | 263 | 228
BA Total |  |  | 5026 | 1713 | 2178 |  | Should the formula in column I above be modified?
CD | Driveway | 12346 | 500 | 250 | 100
 | Driveway Total |  | 500 | 250 | 100
 | Sidewalk | 12851 | 2000 |  | 2000
 | Sidewalk Total |  | 2000 |  | 2000
CD Total |  |  | 2500 | 250 | 2100
EF | Porch | 12347 | 550 | 550 | 0
 | Porch Total |  | 550 | 550 | 0
 | Lawn | 12354 | 1500 | 175 | 1300
 | Lawn Total |  | 1500 | 175 | 1300
EF Total |  |  | 2050 | 725 | 1300
Grand Total |  |  | 9576 | 2688 | 5578
Spreadsheet: 7986c65d-0c31-48b8-bb41-6a2e6b1f5f18
Sheet: Sheet1

Agent Name | License Number | County | Expires | Agent Address | Agent City | Agent State | Agent Zip | Salvage Dealer Name | Region
ADAMS,OLUYIWA | 101A51458 | HARRIS | 2014-03-12 00:00:00 | 815 ROCK SPRING DR | RICHMOND | TX | 77459 | AMIGOS MULTIPURPOSE CENTER | HOUSTON
ALMANSORI,AHMED | 057A45822 | DALLAS | 2014-10-21 00:00:00 | 2440 W IRVING BLVD #190 | IRVING | TX | 75061 | TEXAS AUTO SERVICE | DALLAS
CARTER,[NAME] | 057E00465 | DALLAS | 2015-02-02 00:00:00 | 7321 ASHCREST | DALLAS | TX | 75249 | PICK N PULL AUTO DISMANTLERS | DALLAS
[NAME],[NAME] | 160A52246 | MCCULLOCH | 2014-08-15 00:00:00 | 506 PINE | SANTA ANNA | TX | 76878 | VERN'S AUTO SALVAGE | AUSTIN
COX,STEVEN | 015A50571 | BEXAR | 2014-10-19 00:00:00 | 7439 OBBLIGATO LN | SAN ANTONIO | TX | 78266 | CAR QUICK | SAN ANTONIO
CRUZ,JORGE OSVALDO | 108A48874 | HIDALGO | 2014-07-05 00:00:00 | 6707 VALDIVIA ST | PHARR | TX | 78577 | CRUZ AUTO SALES | PHARR
GONZALEZ,ERNEST | 015C01408 | BEXAR | 2014-07-31 00:00:00 | 206 MEDFORD | SAN ANTONIO | TX | 78209 | SAN ANTONIO AUTO & TRUCK SALVAGE | SAN ANTONIO
GONZALEZ,JACINTO | 101A51563 | HARRIS | 2014-03-22 00:00:00 | 17822 ALPINE BROOK LN | HUMBLE | TX | 77346 | THE PHOENIX AUTO SALES | HOUSTON
HAIDER JAFFAR | 084A51578 | GALVESTON | 2014-04-01 00:00:00 | 2216 HILTON HEAD DR | MISSOURI CITY | TX | 77459 | UNLIMITED MOTOR WERKS | HOUSTON
HARLEY,DON WARD | 116B03088 | [NAME] | 2014-04-20 00:00:00 | 2244 HWY 69 S | GREENVILLE | TX | 75402 | WARDS AUTO PARTS & SALVAGE | DALLAS
JUAN MONTOYA | 123A51391 | JEFFERSON | 2014-03-15 00:00:00 | 3148 25TH ST | PORT ARTHUR | TX | 77642 | PORT ARTHUR AUTO MOTIVE | BEAUMONT
MAKANGUILE,BAKARY NIBIRI | 101A38042 | HARRIS | 2014-08-14 00:00:00 | 6440 DELLFERN DRIVE | HOUSTON | TX | 77035 | MOH SALVAGE | HOUSTON
MCCRARY,LEE | 037B31910 | CHEROKEE | 2014-04-27 00:00:00 | 506 FRANKSTON ST | JACKSONVILLE | TX | 75766 | DAVES AUTOMOTIVE | LONGVIEW
MELIA,WALLACE G | 101A43502 | HARRIS | 2014-12-21 00:00:00 | 10011 NORTH LOOP EAST | HOUSTON | TX | 77029 | HOUSTON FREIGHTLINER,STERLING &WESTERN STAR | HOUSTON
MIRANDA,[NAME] | 101A48010 | HARRIS | 2014-09-19 00:00:00 | 1478 MUNGER | HOUSTON | TX | 77023 | JAM'S AUTO SALES | HOUSTON
PEREZ,[NAME] | 101B41487 | HARRIS | 2014-09-30 00:00:00 | 13502 ROBBINS RD | CYPRESS | TX | 77429 | [NAME]'S CENTRO #2 | HOUSTON
PEREZ,MANUEL | 101A41487 | HARRIS | 2014-09-27 00:00:00 | 1411 GESSNER STE H | HOUSTON | TX | 77080 | [NAME]'S CENTRO #2 | HOUSTON
RAMIREZ,ALMA M | 015B01408 | BEXAR | 2014-07-31 00:00:00 | 206 MEDFORD | SAN ANTONIO | TX | 78209 | SAN ANTONIO AUTO & TRUCK SALVAGE | SAN ANTONIO
SEGOVIA,JESUS | 057B42330 | DALLAS | 2014-05-12 00:00:00 | 9810 BRIERHILL DR | DALLAS | TX | 75217 | FAMA AUTO SALES | DALLAS
TARCO,RICHARD VIRGILIO | 101A02536 | HARRIS | 2014-05-31 00:00:00 | 2635 ANNISTON DR | HOUSTON | TX | 77080 | V & R AUTO SALES | HOUSTON
[NAME],ADA LEYDA | 101A41942 | HARRIS | 2015-02-10 00:00:00 | 6310 SPRUCE FOREST | HOUSTON | TX | 77092 | MOLINA | HOUSTON
Spreadsheet: chris_germany__1997__Gas Phone Card
Sheet: Sheet1

Name | Location | Work# | Home# | Mobile#
Barbe, [NAME] | ECN - 0604d | [PHONE] | [PHONE] | [PHONE]
[NAME], [NAME] | ECN - 0602d | [PHONE] | [PHONE] | [PHONE]
Choate, Heather | ECN - 0601c | [PHONE] | [PHONE] | [PHONE]
Concannon, [NAME] | ECN - 0602e | [PHONE] | [PHONE] | [PHONE]
Denetsosie, Troy | ECN - 0604b | [PHONE] | [PHONE] | [PHONE]
DiCarlo, Louis | ECN - 0602c | [PHONE] | [PHONE] | [PHONE]
[NAME], [NAME] | ECN - 0603a | [PHONE] | [PHONE] | [PHONE]
[NAME], Maria | ECN - 0603c | [PHONE] | [PHONE] | [PHONE]
Germany, [NAME] | ECN - 0604c | [PHONE] | [PHONE] | [PHONE]
[NAME], [NAME] | ECN - 0605d | [PHONE] | [PHONE] | n/a
Gregory, [NAME] | ECN - 0602b | [PHONE] | [PHONE] | [PHONE]
Kelly, [NAME] | ECN - 0604a | [PHONE] | [PHONE] | [PHONE]
[NAME], [NAME] | ECN - 0605c | [PHONE] | [PHONE] | [PHONE]
[NAME], [NAME] | ECN - 0601b | [PHONE] | [PHONE] | [PHONE]
Muench, Gayle | ECN - 0605b | 713 -853-6825 | [PHONE] | [PHONE]
Polsky, [NAME] | ECN - 0603b | [PHONE] | [PHONE] | [PHONE]
Quezada, [NAME] | ECN - 0602a | [PHONE] | [PHONE] | n/a
Scott, [NAME] | ECN - 0604e | [PHONE] | [PHONE] | [PHONE]
Solis, [NAME] | ECN - 0601a | [PHONE] | [PHONE] | [PHONE]
Tian, [NAME] | ECN - 0603e | [PHONE] | [PHONE] | [PHONE]
Versen, [NAME] | ECN - 0603d | [PHONE] | [PHONE] | [PHONE]
Zimmerman, Grant | ECN - 0605a | [PHONE] | [PHONE] | [PHONE]
Spreadsheet: 146632d1332275668-excel-2007-need-help-with-formula-sgtnnis
Sheet: March

Date /Receiver # | Grower | Breaburn | Corthlan  NY | Golden   USDA | Empire | Granny's | [NAME] | Ida Red    NY | Jonagold | Jonagold NY | [NAME] | [NAME] | Rome | Loaded From | Loaded To | Forklift Driver Initial | Totals
2012-03-08 00:00:00
A01177 | 924 |  |  |  |  |  |  |  |  |  |  |  | 1 | 20 | FP | EP
106276 | 64 |  |  |  |  |  |  |  |  |  |  |  | 14 | 20 | FP | EP
106247 | 64 |  |  |  |  |  |  |  |  |  |  |  | 30 | 20 | FP | EP
106338 | 930 |  |  |  |  |  |  |  |  |  |  |  | 15 | 20 | FP | EP
106339 | 930 |  |  |  |  |  |  |  |  |  |  |  | 3 | 20 | FP | EP
106328 | 1 |  |  |  |  |  |  |  |  |  |  |  | 28 | 20 | FP | EP
106247 | 64 |  |  |  |  |  |  |  |  |  |  |  | 2 | 20 | FP | EP
106207 | 167 |  |  |  |  |  |  |  |  |  |  |  | 96 | 20 | FP | EP
106362 | 1077 |  |  |  |  |  |  |  |  |  |  |  | 33 | 20 | FP | EP
106174 | 936 |  |  |  |  |  |  |  |  |  |  |  | 17 | 20 | FP | EP
96868 | 1034 |  |  |  |  |  |  |  |  |  |  |  | 1 | 20 | FP | EP
96871 | 1034 |  |  |  | 15 |  |  |  |  |  |  |  |  | 20 | FP | EP
106350 | 830 |  |  |  | 31 |  |  |  |  |  |  |  |  | 20 | FP | EP
106232 | 852 |  |  |  | 2 |  |  |  |  |  |  |  |  | 20 | FP | EP
103904 | 962 |  |  |  | 4 |  |  |  |  |  |  |  |  | 20 | FP | EP
106276 | 64 |  |  |  | 18 |  |  |  |  |  |  |  |  | 20 | FP | EP
96874 | 1034 |  |  |  | 1 |  |  |  |  |  |  |  |  | 20 | FP | EP
96869 | 1034 |  |  |  | 1 |  |  |  |  |  |  |  |  | 20 | FP | EP
106212 | 1159 |  |  |  | 5 |  |  |  |  |  |  |  |  | 20 | FP | EP
2012-03-09 00:00:00
106313 | 201 |  |  |  | 24 |  |  |  |  |  |  |  |  | 21 | FP | EP
106362 | 1077 |  |  |  | 39 |  |  |  |  |  |  |  |  | 21 | FP | EP
106225 | 1092 |  |  |  | 28 |  |  |  |  |  |  |  |  | 21 | FP | EP
106316 | 120 |  |  |  | 24 |  |  |  |  |  |  |  |  | 21 | FP | EP
106172 | 120 |  |  |  | 24 |  |  |  |  |  |  |  |  | 21 | FP | EP
106291 | 888302 |  |  |  | 45 |  |  |  |  |  |  |  |  | 21 | FP | EP |  | 184
1 |  |  |  |  | 25 |  |  |  |  |  |  |  |  | 21
Spreadsheet: 770818d1646291171-how-to-get-sumproduct-to-ignore-a-criteria-if-it-is-blank-league-workbook
Sheet: Dummy

Rank | Team | Ranking System |  |  |  | All Games |  |  |  |  |  |  |  | Home Games |  |  |  |  |  |  |  | Away Games
 |  | Pts | [NAME] | F | A | P | W | D | L | F | A | [NAME] | Pts | P | W | D | L | F | A | [NAME] | Pts | P | W | D | L | F | A | [NAME] | Pts
 | Camels
 | Celts
 | Challengers
 | Classics
 | Incredibowls
 | Peacocks
 | Thornes
 | Wasps
Spreadsheet: 867458d1714315617-extract-polynomial-coeffients-on-filtered-hidden-data-polynomial
Sheet: Sheet1

 |  |  |  |  |  | x | y | Helper
 |  |  |  |  |  | 1 | 1
 |  |  |  |  |  | 2 | 2
 |  |  |  |  |  | 3 | 4
 |  |  |  |  |  | 4 | 5
 |  |  |  |  |  | 5 | 7
 |  |  |  |  |  | 6 | 8
 |  |  |  |  |  | 7 | 9
 |  |  |  |  |  | 8 | 10
 |  |  |  |  |  | 9 | 10
 |  |  |  |  |  | 10 | 11
 |  |  |  |  |  | b4 | b3 | b2 | b1 | a
 |  |  |  |  | OK
 |  |  |  |  | Not OK
Spreadsheet: 701705d1603893942-summing-values-in-one-column-using-vlookup-dummy-dataset-1-
Sheet: shcedule

Vendor number | Paid (USD)
4030
6231
6336
4778
4467
4136
4140
5823
6314
4817
4858
4141
6275
4997
6417
6368
4546
5902
This vendor number has paid twice
Spreadsheet: 753865d1635791647-automatic-cell-population-from-another-tab-resource-overview
Sheet: Data Sheet

 |  | Project Type | Start Date | Skill Type | wk 1 | wk 2 | wk 3 | wk 4 | wk 5 | wk 6 | wk 7 | wk 8 | wk 9 | wk 10 | wk 11 | wk 12
 |  | Project X | 2021-11-15 00:00:00 | Skill 1 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project X |  | Skill 2 |  |  | 15 | 15 | 15 | 15
 |  | Project X |  | Skill 3 |  |  | 15 | 30 | 30
 |  | Project X |  | Skill 4 |  |  |  | 7.5 | 7.5
 |  | Project Y | 2021-12-16 00:00:00 | Skill 1 | 7.5 | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Y |  | Skill 2 |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5
 |  | Project Y |  | Skill 3 |  |  |  | 7.5 | 15 | 15 | 15 | 15
 |  | Project Y |  | Skill 4 |  |  |  | 7.5 | 15 | 15
 |  | Project Z | 2022-01-03 00:00:00 | Skill 1 | 7.5 | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15 | 7.5 | 7.5
 |  | Project Z |  | Skill 2 |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Z |  | Skill 3 |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Z |  | Skill 4 |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
Spreadsheet: 741557d1627134234-how-to-count-cells-only-when-they-have-content-aligw
Sheet: Teams

Barnsley | 2.4e-06
Birmingham City
[NAME]
Blackpool
Bournemouth
Bristol City
Cardiff City
Coventry City
Derby County
Fulham
Huddersfield Town
Hull City
[NAME]
Middlesbrough
Millwall
[NAME]
Peterborough United
[NAME]
Queens Park Rangers
Reading
Sheffield United
Stoke City
Swansea City
West Bromwich Albion
Spreadsheet: 775723d1649269569-vali-unit-prices-as-per-date-range-prices
Sheet: Sheet1 (2)

 |  | Data: | Valid <= 26.01.2022 | Valid >= this date | Valid >= this date | Valid >= this date
 |  | Description | Contract Price | 2022-01-26 00:00:00 | 2022-02-24 00:00:00 | 2022-03-02 00:00:00 |  |  |  |  | Description | Date | U.Price
 |  | C-100 | 163 | 159 |  |  |  |  |  |  | C-103 | 2021-12-12 00:00:00 | 177
 |  | [NAME] | 171 | 167 |  |  |  |  |  |  | C-111 | 2022-01-26 00:00:00 | 213
 |  | C-102 | 170 | 165 |  |  |  |  |  |  | C-104 | 2022-02-26 00:00:00 | 173
 |  | C-103 | 177 | 172 |  |  |  |  |  |  | C-119 | 2022-03-01 00:00:00 | 236
 |  | C-104 | 175 | 170
 |  | C-105 | 183 | 178
 |  | C-106 | 190 | 184
 |  | C-107 | 200 | 194
 |  | C-108 | 195 | 188
 |  | C-109 | 205 | 198
 |  | C-110 | 210 | 203
 |  | C-111 | 220 | 213
 |  | C-112 | 219 | 213
 |  | C-113 | 225 | 219
 |  | C-114 | 219 | 213
 |  | [NAME] | 225 | 219
 |  | C-116 | 225 | 219
 |  | [NAME] | 234 | 228
 |  | C-118 | 230 | 223
 |  | C-119 | 240 | 233
Spreadsheet: 138448d1327666305-calculate-minutes-into-hours-in-number-format-mins-on-task
Sheet: Sheet1

EXAMPLE ONLY
Name of Case Worker:
Location:
Fortnight Beginning: |  | 2012-01-16 00:00:00
Fortnight Ending:
WEEK 1 - OFFICE CO-ORDINATION HOURS, CASE WORKER AND RELIEF HOURS ONLY
Date | Start Task | Finish Task | Mins on task | Type | Comments |  | Kms
 | 09:00:00 |  | 00:30:00 | ONI Reviews, Clients notes, Reports, Budget
 |  |  | 00:30:00 | Lunch break
 |  |  | 00:45:00 | Other (please state) | Pick up brochures
 |  |  | 00:30:00 | Clients: Care Coord, Planning, Monitoring, Visiting
 |  |  | 00:15:00
 |  |  | 00:45:00
 |  |  | 00:15:00
 |  |  | 00:15:00
TOTAL DAILY | hh:[NAME]
 | Whole Number