tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 039d11b7-c945-4fa0-b3f2-214a2a121416
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 |  | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34
Office of School Finance
SF-6
JVS Attachment Form
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FY-20
A.
 |  | Joint Vocational School |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | County |  |  |  |  |  |  |  | IRN
B.
 |  | Resident District - City, Exempted Village, Local or Community School |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | County |  |  |  |  |  |  |  | IRN
 | SSID |  |  |  |  |  |  |  |  |  |  |  |  |  | Disability |  |  |  |  | EMIS |  |  | Dates of |  |  |  |  |  | Total |  |  | FTE |  | *Billing
 | Number |  |  |  |  |  |  |  |  |  |  |  |  |  | Condition |  |  |  |  | Status |  |  | Enrollment |  |  |  |  |  | Days |  |  | at |  | FTE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From Section |  |  |  |  | Code |  |  | From |  |  | To |  |  | Enrolled |  |  | JVS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 C
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 | *Billing FTE = Total days enrolled x FTE at JVS ÷ 180 days.
EMIS Student Status Codes
10  - |  | Resident |  |  |  |  |  |  |  |  |  |  | 1C  - |  | Court placed (foster) |  |  |  |  |  |  |  |  |  |  | 1S  - |  | Non-resident (superintendent)
17  - |  | Non-resident (grandparent) |  |  |  |  |  |  |  |  |  |  | 1P  - |  | Court placed (institutional) |  |  |  |  |  |  |  |  |  |  | 19  - |  | Open enrolled (jointure)
18  - |  | Non-resident (senior) |  |  |  |  |  |  |  |  |  |  | 1T  - |  | Parental (institutional placed) |  |  |  |  |  |  |  |  |  |  | 49  - |  | Open enrolled (non-jointure
1A  - |  | Non-resident (employee) |  |  |  |  |  |  |  |  |  |  | 1D  - |  | Direct pay tuition
Spreadsheet: 804406d1668067721-compare-two-tables-and-find-average-s666-pq-compare-two-tables-and-find-average
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2 |  |  |  |  | Desired Result Table
Last Name | First Name | Dept | Rank |  | Last Name | First Name | Dept | Rank |  | Last Name | First Name | Dept | Rank
[NAME] | [NAME] | Tax | 10 |  | [NAME] | [NAME] | Tax | 9 |  | [NAME] | [NAME] | Tax | 9.5
Blair | Felix | Legal | 9 |  | Blair | Felix | Legal | 8 |  | Blair | Felix | Legal | 8.5
We | Jing | Tax | 5 |  | Wun | [NAME] | Tax | 3 |  | We | Jing | Tax | 5
Wick | [NAME] | IT | 10 |  | Wick | [NAME] | IT | 10 |  | Wick | [NAME] | IT | 10
 |  |  |  |  | Val | Vikrish | IT | 8 |  | Wun | [NAME] | Tax | 3
 |  |  |  |  |  |  |  |  |  | Val | Vikrish | IT | 8
 |  |  |  |  |  |  |  |  |  | Last Name | First Name | Dept | Average
 |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Tax | 9.5
 |  |  |  |  |  |  |  |  |  | Blair | Felix | Legal | 8.5
 |  |  |  |  |  |  |  |  |  | We | Jing | Tax | 5
 |  |  |  |  |  |  |  |  |  | Wick | [NAME] | IT | 10
 |  |  |  |  |  |  |  |  |  | Wun | [NAME] | Tax | 3
 |  |  |  |  |  |  |  |  |  | Val | Vikrish | IT | 8
Spreadsheet: 0baba1e5-4af3-49b2-9946-897004d7ad99
Sheet: Sheet1

Unnamed: 0 | PARA COMPLEMENTAR EL CUADRO DE INVENTARIO, SE DEBE DESCOMPONER LA INFORMACIÓN DEL MEDICAMENTOS EN LO SIGUIENTE: PRODUCTO, PRESENTACION, LABORATORIO QUE [NAME], PRINCIPIO ACTIVO, CONCENTRACION, FORMA FARMACEUTICA SEGÚN CODIGO EN LA PESTAÑA FORMA FARMACEUTICA CONTEMPLADA EN ESTE DOCUMENTO. LA CONCENTRACION ES DESCOMPUESTA EN DOS DATOS, EL VALOR NUMERICO Y LA UNIDAD DE MEDIDA, EJ. 100 MG, VALOR ES 100 Y LA UNIDAD DE MEDIDA MG. A CONTINUACION UN EJEMPLO DEMOSTRATIVO. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | [NAME] 70 Mg X 5
PRODUCTO | Presentación | [NAME] | PRINCIPIO ACTIVO | CONCENTRACOIN |  | FORMA FARMACEUTICA | CANTIDAD DE Presentación | PRECIO DE Presentación | EXISTENCIAS [NUMERO DE CAJAS, TUBOS, BLISTER,ETC]
 |  |  |  | VALOR | UNIDAD |  | [CAMPO NUMERICO] | [CAMPO NUMERICO] | [CAMPO NUMERICO]
Osteomax | [NAME] 70 Mg X 5 | LABORATORIO QUE LO PRODUCE | ALENDRONIC ACID | 70 | MG | AAA | 5 | $##.## | 20
PRODUCTO2 | Presentación EN POLVO PARA DILUIR | LABORATORIO QUE LO PRODUCE | PRINCIPIO ACTIVO | 10 | MG | DEK | 10ML | $##.## | 30
 |  | CANTIDAD DE Presentación |  | NUMERO DE TABLETAS, GRAMOS, MILILITROS, ETC.
 |  |  |  | Las presentacion liquidas [NAME], las presentacion en polvo que son [NAME] en agua u otro liquido en [NAME] debe mencionar en cuanto ML se diluye
 |  | PRECIO DE Presentación |  | [NAME] total de la presentacion incluyendo IVA y [NAME]
Spreadsheet: richard_ring__31555__EES-CECAuditedAnnual-2000
Sheet: Attestation

 | Annual Report to the California Energy Commission
 | for the year ended December 31, 2000
 | ATTESTATION FORM
 | Applicable to:  All participants in the Power Source Disclosure Program and Customer Credit Program
 |  | CONTACT INFORMATION
 |  | Name | Heather Mathis
 |  | Title | Contract Legal Specialist
 |  | Company Name | Enron Energy Services, Inc.
 |  | Address | 1400 Smith Street
 |  | City, State, Zip | Houston, TX 77002
 |  | Phone | [PHONE]
 |  | Fax | [PHONE]
 |  | E-mail | [EMAIL]
Spreadsheet: 693753d1599133593-lookup-multiple-solutions-values-and-list-them-excel-help
Sheet: Colli - short

Delivery Address
[NAME] | 1 |  | [NAME] |  |  | [NAME]
Pos. nr.: | Qty. |  | Pos.nr. |  |  | Pos.nr.
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos.nr. |  |  | Pos.nr. |  |  | Pos.nr.
 |  |  | P02 | 15 |  | P02 | 15
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos.nr. |  |  | Pos.nr. |  |  | Pos.nr.
P02 | 15 |  | P02 | 15 |  | P02 | 15
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos. nr.: |  |  | Pos.nr. |  |  | Pos.nr.
P02 | 15 |  | P02 | 15 |  | P02 | 15
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos.nr. |  |  | Pos.nr. |  |  | Pos.nr.
P02 | 30 |  | P02 | 30 |  | P02 | 30
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos.nr. |  |  | Pos.nr. |  |  | Pos.nr.
P02 | 30 |  | P02 | 30 |  | P02 | 30
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos. nr.: |  |  | Pos.nr. |  |  | Pos.nr.
P02 | 30 |  | P02 | 30 |  | P02 | 30
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos.nr. |  |  | Pos.nr. |  |  | Pos.nr.
P02 | 30 |  | P02 | 30 |  | P02 | 30
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos.nr. |  |  | Pos.nr. |  |  | Pos.nr.
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos. nr.: |  |  | Pos.nr. |  |  | Pos.nr.
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos.nr. |  |  | Pos.nr. |  |  | Pos.nr.
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos.nr. |  |  | Pos.nr. |  |  | Pos.nr.
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos. nr.: |  |  | Pos.nr. |  |  | Pos.nr.
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos.nr. |  |  | Pos.nr. |  |  | Pos.nr.
[NAME] |  |  | [NAME] |  |  | [NAME]
Pos.nr. |  |  | Pos.nr. |  |  | Pos.nr.
Spreadsheet: 00a2ba0c-d47d-489b-b0ac-cbf43c8f9e30
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-06-11 09:34:47
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.297 | 101.172 | 101.047 | 100.672
3.75 | 100.609 | 100.484 | 100.359 | 99.984 |  | Note: | Refer To Price [NAME]
3.625 | 100.165 | 100.04 | 99.915 | 99.54 |  |  | For all Price Adjs
3.5 | 99.557 | 99.432 | 99.307 | 98.682
3.375 | 98.597 | 98.472 | 98.347 | 97.722
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.399 | 101.274 | 101.149 | 100.774
3.25 | 100.918 | 100.793 | 100.668 | 100.293
3.125 | 100.583 | 100.458 | 100.333 | 99.958
3 | 100.256 | 100.131 | 100.006 | 99.631
2.875 | 99.65 | 99.525 | 99.4 | 98.775
2.75 | 98.935 | 98.81 | 98.685 | 98.06
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-06-25 09:34:47
30 DAY | 2012-07-10 09:34:47
45 DAY | 2012-07-25 09:34:47
60 DAY | 2012-08-09 09:34:47
90 DAY | 2012-09-08 09:34:47
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: chris_stokley__3925__Expense Report Listing
Sheet: Sheet2

 |  |  | [NAME]
2001-06-13 00:00:00 | Calgary | Travel | Westin
Milage
Cab from Airport
Dinner
2001-06-14 00:00:00 | Calgary | Travel | Westin
Breakfast
Lunch
Dinner
2001-06-15 00:00:00 | Portland | Travel | Marryott
Breakfast
Lunch
Dinner
2001-06-16 00:00:00 | Portland | Travel | Marryott
Car Rental
Breakfast
Lunch
Dinner
2001-06-17 00:00:00 | Portland | Travel | Marryott
Breakfast
Lunch
Dinner
2001-06-18 00:00:00 | Portland | Travel | Marryott
Breakfast
Lunch
Parking
Milage
2001-06-19 00:00:00 | Toronto |  | 1528
2001-06-20 00:00:00 | Toronto |  | 1528
2001-06-21 00:00:00 | Toronto |  | 1528
2001-06-22 00:00:00 | Toronto |  | 1528
2001-06-23 00:00:00 | Toronto |  | 1528
2001-06-24 00:00:00 | Toronto |  | 1528
2001-06-25 00:00:00 | Toronto |  | 1528
2001-06-26 00:00:00 | Toronto |  | 1528
2001-06-27 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
Subway
2001-06-28 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
2001-06-29 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
Subway
2001-06-30 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
Subway
2001-07-01 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
Subway
2001-07-02 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
2001-07-03 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
2001-07-04 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
2001-07-05 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
CAB to Airport
2001-07-06 00:00:00 | Birmingham
Cab from Airport
Breakfast
Lunch
Dinner
2001-07-07 00:00:00 | Vacation
2001-07-08 00:00:00 | Vacation
2001-07-09 00:00:00 | Vacation
2001-07-10 00:00:00 | Vacation
2001-07-11 00:00:00 | Vacation
2001-07-12 00:00:00 | Vacation
2001-07-13 00:00:00 | Vacation
2001-07-14 00:00:00 | Vacation
2001-07-15 00:00:00 | Birmingham
CAB to Airport
2001-07-16 00:00:00 | Portland
Rental Car
Breakfast
Lunch
Dinner
2001-07-17 00:00:00 | Portland
2001-07-18 00:00:00 | Portland
2001-07-19 00:00:00 | Portland
2001-07-20 00:00:00 | Portland
2001-07-21 00:00:00 | Portland
2001-07-22 00:00:00 | Toronto |  | Royal York
Transport from Airport
Dinner
2001-07-23 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
Subway
2001-07-24 00:00:00 | Toronto |  | Royal York
Breakfast
Lunch
Dinner
CAB to Airport
2001-07-25 00:00:00 | Houston |  | Royal York
Breakfast
Lunch
Dinner
2001-07-26 00:00:00 | Houston |  | Double Tree
Breakfast
Lunch
Dinner
2001-07-27 00:00:00 | Houston |  | Double Tree
Breakfast
Lunch
Dinner
CAB
2001-07-28 00:00:00 | Portland
Spreadsheet: 3c5cbb54-0d0a-4fc1-94b0-fd120c2fe852
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 14998416224 | [NAME] | Instrument Of Praise | 2007-09-11 | Compact Disc | Ac | 17.99 | Y | Available
Spreadsheet: 793879d1661783250-finding-and-listing-cells-that-correspond-to-other-data-found-in-an-array-column-1977-workbook
Sheet: Collation

 | HOME WIN | HOME LOSS | AWAY WIN | AWAY LOSS | Total Wins | Total Losses | 1R HOME WIN | 1R HOME LOSS | 1R AWAY WIN | 1R AWAY LOSS | Total 1 Run Win | Total 1 Run Loss | ATL | BAL | BOS | CAL | CHN | CHW | CIN | CLE | DET | HOU | KCR | LAD | MIL | MIN | MON | NYM | NYA | OAK | PHI | PIT | SDP | SEA | SFG | STL | TEX | TOR
ATL
BAL
BOS
CAL
CHN
CHA
CIN
CLE
DET
HOU
KCA
LAN
MIL
MIN
MON
NYN
NYA
OAK
PHI
PIT
SDN
SEA
SFN
SLN
TEX
TOR
https://www.baseball-reference.com/teams/BAL/1977.shtml
https://www.baseball-reference.com/teams/BOS/1977.shtml
https://www.baseball-reference.com/teams/DET/1977.shtml
https://www.baseball-reference.com/teams/TOR/1977.shtml
https://www.baseball-reference.com/teams/NYY/1977.shtml
https://www.baseball-reference.com/teams/MIL/1977.shtml
https://www.baseball-reference.com/teams/CLE/1977.shtml
AL WEST
 | W | L | Pct. | GB
https://www.baseball-reference.com/teams/CAL/1977.shtml
https://www.baseball-reference.com/teams/CHW/1977.shtml
https://www.baseball-reference.com/teams/MIN/1977.shtml
https://www.baseball-reference.com/teams/KCR/1977.shtml
https://www.baseball-reference.com/teams/OAK/1977.shtml
https://www.baseball-reference.com/teams/TEX/1977.shtml
https://www.baseball-reference.com/teams/SEA/1977.shtml
NL EAST | W | L | Pct. | GB
https://www.baseball-reference.com/teams/CHC/1977.shtml
https://www.baseball-reference.com/teams/NYM/1977.shtml
https://www.baseball-reference.com/teams/MON/1977.shtml
[NAME]
https://www.baseball-reference.com/teams/PIT/1977.shtml
https://www.baseball-reference.com/teams/STL/1977.shtml
NL WEST | W | L | Pct. | GB
https://www.baseball-reference.com/teams/SDP/1977.shtml
https://www.baseball-reference.com/teams/ATL/1977.shtml
https://www.baseball-reference.com/teams/LAD/1977.shtml
https://www.baseball-reference.com/teams/SFG/1977.shtml
https://www.baseball-reference.com/teams/HOU/1977.shtml
https://www.baseball-reference.com/teams/CIN/1977.shtml
Spreadsheet: 823125d1679725539-how-to-calculate-only-visible-cells-example
Sheet: Sheet2

 | ID | Debt Date | Due Date | Days between Due | Due Days Late | Vendor | Cost | Paid Date
 | 1140 | 2022-11-22 00:00:00 | 2023-02-20 00:00:00 |  | 33 | sm | 3361
 | 1143 | 2022-11-22 00:00:00 | 2023-02-20 00:00:00 |  | 33 | a | 845
 | 1144 | 2022-11-23 00:00:00 | 2023-02-21 00:00:00 |  | 32 | c | 1240
 | 1202 | 2022-12-13 00:00:00 | 2022-12-27 00:00:00 |  |  | s | 1170 | 2023-01-14 00:00:00
 | 1203 | 2022-12-13 00:00:00 | 2022-12-27 00:00:00 |  |  | s | 600 | 2023-01-14 00:00:00
 | 1154 | 2022-11-26 00:00:00 | 2023-02-24 00:00:00 |  | 29 | sm | 815
 | 1308 | 2023-01-25 00:00:00 | 2023-02-24 00:00:00 |  | 29 | SBP | 291.06
 | 1206 | 2022-12-15 00:00:00 | 2023-01-14 00:00:00 |  |  | c | 7444.366 | 2023-01-17 00:00:00
 | 1242 | 2022-12-28 00:00:00 | 2023-02-26 00:00:00 |  | 27 | cb | 1720
 | 1243 | 2022-12-28 00:00:00 | 2023-02-26 00:00:00 |  | 27 | cb | 1287.5
 | 1244 | 2022-12-28 00:00:00 | 2023-02-26 00:00:00 |  | 27 | in | 2775
 | 1153 | 2022-11-29 00:00:00 | 2023-02-27 00:00:00 |  | 26 | sm | 2815
 | 1155 | 2022-11-30 00:00:00 | 2023-02-28 00:00:00 |  | 25 | vi | 1915
 | 1160 | 2022-12-02 00:00:00 | 2023-03-02 00:00:00 |  | 23 | bt | 149.85
 |  | The target is to know how many days between due
 | 1 | Column I (Paid Date) > Filter (small triangle icon) > UNcheck 2023 |  |  |  | current problem is
 | 2 | 3 rows will be hidden |  |  |  | existing formula calculate exact 1 row before,
 | 3 | Cell E8 (black frame) should be 3 |  |  |  | eventhough that row already hidden because filtered out
 |  | because 32 - 29 = 3
 | 4 | Cell E11 (black frame) should be 2
 |  | because 29-27 = 2
Spreadsheet: darrell_schoolcraft__7477__imball0202
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 128480 | 128394
2 | 149328 | 149088
3 | 142965 | 142375
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  |  |  |  | 20
2002-01-31 00:00:00 |  |  | -61307 |  |  |  | 530
2002-02-03 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | -29617
Spreadsheet: 166924d1341847164-need-to-sum-rows-from-multiple-tables-with-varying-layouts-example-table
Sheet: Sheet1

 | CATEGORY 1 | AMOUNT
 | Product A | 5
 | Product B | 8
 | Product G | 11
 | Product H | 3
 | CATEGORY 2 | AMOUNT
 | Product B | 14
 | Product C | 5
 | Product E | 6
 | Product H | 12
 | CATEGORY 3 | AMOUNT
 | Product A | 20
 | Product C | 14
 | Product D | 3
 | Product G | 5
Spreadsheet: 878746d1726027516-help-with-textjoin-function-book3
Sheet: Sheet1

Service Order No. | PART Number
[NAME] | [NAME]
ASPH24082800000083 | C015520016700
ASPH24082800000083 | C015550060700
ASPH24082800000083 | C015550060800
ASPH24082900000078 | 1611602000045A
ASPH24082900000080 | 55050000UT4J
ASPH24082900000090 | 1611601000010A
ASPH24082900000090 | 1611602000013A
ASPH24083000000073 | 581C3UADCG00
[NAME] | C041900001000
ASPH24083000000100 | 460200007R1G
ASPH24090200000039 | C002460002000
ASPH24090200000046 | 1420103000213A
ASPH24090300000038 | D79H910179068
ASPH24090400000014 | 56000400L200
ASPH24090400000019 | C039290001400
ASPH24090400000023 | 48320000J46Q
ASPH24090400000023 | 560003L12A00
ASPH24090400000030 | C002550052400
[NAME] | 560020M11A00
ASPH24090400000035 | 560001N16P00
ASPH24090400000046 | 560003L12A00
ASPH24090400000093 | 560003L12A00
ASPH24090400000108 | 58647
ASPH24090500000030 | 1330101000107A
ASPH24090500000030 | 5810L83DCG00
ASPH24090500000082 | 460200001J1G
ASPH24090500000084 | 5600020N1600
ASPH24090500000099 | 32020000MR4Q
ASPH24090500000099 | 32140000116A
ASPH24090500000099 | 560003K10A00
ASPH24090500000100 | 55050000F54J
ASPH24090500000101 | 5600020M1200
ASPH24090500000101 | 5600030M1200
ASPH24090500000101 | 5600070M1200
ASPH24090500000102 | 5600020K7A00
ASPH24090500000106 | 490100007A5F
ASPH24090500000106 | 56000AK16U00
ASPH24090600000012 | 32020000MR4Q
ASPH24090600000012 | 32140000116A
ASPH24090600000012 | 560003K10A00
ASPH24090600000013 | 5600160N1100
ASPH24090600000073 | 48320000F67D
ASPH24090600000077 | 1330101000132B
ASPH24090600000077 | 5600040M1900
ASPH24090600000094 | 39884
ASPH24090700000001 | 48200000CV3W
ASPH24090700000001 | 560001K11R00
ASPH24090700000001 | 560003K11R00
Spreadsheet: 789717d1659322540-let-and-unique-function-for-older-excel-version-daf-summary-data-aligw
Sheet: Sheet2

U | A |  | U | C
1-1 | X |  |  |  |  | Count
1-1 | X
1-1 | X
1-2 | X
1-2 | X
1-3 | X
2-1 | X
2-2
2-3
Spreadsheet: 105998d1303237137-using-vlookup-and-data-filter-together-copy-of-outstandingbills
Sheet: Balance

Expected List to be generated using excel formulas / functions etc
Party Name | [NAME]
Spreadsheet: 68236d1268767626-excel-2007-way-to-make-section-of-document-only-print-once-invoice
Sheet: Customer Report

 | 0
 | 500 [NAME] #10
 | Mesquite, TX 751149
 | (972)329-1104
 | Date:
 | From
 | To
 | Customer ID | Date | Name | Invoice # | Cost | Sales Tax | GST | Shipping Cost | Paid | Balance Due | Subtotal | Total | Due Date | P.O. # | Sales Rep. | Payment Term
Spreadsheet: 196854d1354125745-rank-errors-and-automatic-sorting-timer-score-sheets
Sheet: Day 1 PRINTOUT

 | [NAME] SCORESHEET (DAY 1)
 | Date:
Day 1 Post | Bib | Musher's Name | Day 1 Finish Time
1 | 44 | [NAME] | 01:08:11
2 | 43 | [NAME] | 01:08:26
3 | 41 | [NAME] | 01:11:56
4 | 40 | [NAME] | 01:14:34
5 | 42 | [NAME] | 01:14:40
6 | 71 | Lester | 01:15:56
7 | 45 | [NAME] | 01:15:56
7 | 45 | [NAME] | 01:15:56
7 | 45 | [NAME] | 01:15:56
10 | 75 | Brent | 01:15:56
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
* | 47 | 0 | *
Spreadsheet: 119fc283-eb09-4e5d-b8da-14d1844ae3e1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | PART 1.  MITIGATION FEE WITHIN                                                                                   THE e-OVERLAY ZONE |  | AREA (SF) | UNIT COST | MULTIPLIER | COST
 | A.  NEW CLEARING, GRADING, PAVING & STRUCTURES                                                                   LANDWARD OF TOP OF BANK | WITHIN THE FLOODPLAIN                               OR A WETLAND | 0 | 3 | 1 | 0
 |  | OUTSIDE THE FLOODPLAIN                                 OR A WETLAND | 0 | 1 | 1 | 0
 |  |  | PART 1 A. SUBTOTAL |  |  | 0
 | B.  NEW BANK TREATMENT                                              BELOW TOP OF BANK | NRI RANK       PROPOSAL | [NAME]          (bank=[NAME]) (dock=sf) | UNIT COST | MULTIPLIER | COST
 |  | H                 Bioengineered | 0 | 1500 | 0.25 | 0
 |  | H                 Riprap/ seawall | 0 | 1500 | 1 | 0
 |  | M                 Riprap/ seawall | 0 | 1500 | 0.75 | 0
 |  | H              Docks (over-water) | 0 | 30 | 1 | 0
 |  |  | PART 1 B.  SUB TOTAL |  |  | 0
 |  |  | PART 1   AMOUNT APPLIED ON-SITE |  |  | 0
 |  |  | PART 1  AMOUNT APPLIED OFF-SITE |  |  | 0
 | Long-term management, maintenance and monitoring at City restoration sites is supported by a 20% assessment of Part 1 "Amount Applied Off-site".
 |  |  | 20% OFF-SITE CHARGE |  |  | 0
 |  |  | PART 1                                                                                                                       OFF-SITE MITIGATION TOTAL |  |  | 0
 | PART 2.  BALANCE CUT & FILL |  | VOLUME (CY) | UNIT COST |  | COST
 | Applies if an applicant chooses to fulfill balance cut and fill requirements at a City restoration site. |  | 0 | 29 |  | 0
 |  |  | PART 2 TOTAL |  |  | 0
 | PART 3.  1% RESTORATION FEE WITHIN                                                                                                   ALL RIVER OVERLAY ZONES |  | PROJECT COST |  |  | COST
 |  |  | 0 |  |  | 0
 |  |  | PART 3 TOTAL |  |  | 0
 | SUMMARY
 |  |  | PART 1                                                                                                                      ON-SITE MITIGATION TOTAL |  |  | 0
 |  |  | PART 1                                                              OFF-SITE MITIGATION FEE TOTAL |  |  | 0
 |  |  | PART 2                                                             BALANCE CUT AND FILL TOTAL |  |  | 0
 |  |  | PART 3                                                                  1% RESTORATION  FEE TOTAL |  |  | 0
 |  |  | TOTAL FEE |  |  | 0