tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e9aa5e2d-59eb-4dad-aafb-9b85265fadd5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
CONSULTA
Nome*:
Empresa*:
[NAME]*:
Telefone/Telemóvel*:
Tipo de evento:
 |  | Outros:
Número de participantes:
Qual a data do evento:
início | fim
 |  | (dd/mm/aa)
Mais informações:
Sujeito a Confirmação
*Campos de preenchimento obrigatório.
Enviar para | [EMAIL]
Recepção |  | até 15 pax
Apresentação |  | até 40 pax
Reunião |  | até 60 pax
Congresso |  | até 100 pax
[NAME] |  | até 160 pax
Simpósio |  | até 300 pax
Cocktail |  | até 1000 pax
Porto de Honra
Coffee-break
Almoço Negócios
Jantar Negócios
Concerto privado
Outros
Spreadsheet: 2c06cd12-4dba-45ba-a6f9-f0c942f253f5
Sheet: Page 6

Permit No.: |  |  | WQ0024320 |  |  | Facility Name: |  | Rockbridge Subdivision |  |  |  |  |  | County: | Wake |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 12A |  | Field Name: |  | 12B |  | Field Name: |  | 12C |  | Field Name: |  | 13
 |  |  |  |  |  | Area (acres): |  | 2.48 |  | Area (acres): |  | 0.18 |  | Area (acres): |  | 0.28 |  | Area (acres): |  | 1.22
 |  |  |  |  |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3
 |  |  |  |  |  | Annual Rate (in): |  | 23.9 |  | Annual Rate (in): |  | 23.9 |  | Annual Rate (in): |  | 23.9 |  | Annual Rate (in): |  | 23.9
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 713126d1610561973-database-information-to-dashboard-training-matrix-2-
Sheet: Master

Record ID | Name | Surname | SCN | Department | State | MI |  |  | BE
 |  |  |  |  |  | Pre Test | Post Test | Date | Pre Test | Post Test | Date
EMP001 | Pam | Anders | 123 | IT | CA | 12 | 12 | 2020-01-12 00:00:00 | 12 | 81 | 2020-11-12 00:00:00
EMP002 | [NAME] | Cross | 456 | Eng | AR | 0 | 12 | 2020-12-09 00:00:00 | 41 | 64 | 2020-02-14 00:00:00
EMP003 | George | Ballot | 789 | Science | [NAME] | 10 | 50 | 2021-01-12 00:00:00 | 32 | 55 | 2020-08-01 00:00:00
EMP004 | [NAME] | Pan | 101 | [NAME] | HE | 25 | 66 | 2020-03-12 00:00:00 | 5 | 57 | 2020-01-25 00:00:00
EMP005 | Collin | Crest | 111 | Security | DL | 55 | 84 | 2020-05-17 00:00:00 | 25 | 93 | 2020-04-04 00:00:00
Spreadsheet: benjamin_rogers__1169__Base
Sheet: Calvert

INCOME STATEMENT - CALVERT
('000 $) |  |  |  | 1999
Revenue
PPA Period:
Demand Payment |  |  |  |  |  |  |  | 0
Energy Payment |  |  |  | 0 |  |  |  | 0
Block Payment |  |  |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Market Period:
Demand Payment |  |  |  | 0 | 0 | 0 | 0
Variable Revenue |  |  |  | 0 | 0 | 0 | 0
Energy Margin |  |  |  | 0 | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fuel |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed O&M |  |  |  | 0
Variable O&M |  |  |  | 0
Major Maintenance & Ongoing Capex |  |  |  | 0
Insurance |  |  |  | 0
SG&A |  |  |  | 0
Utility Start Up Power |  |  |  | 0
Property, Other Taxes |  |  |  | 0 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 235.677207 | 280.0988591798535
Debt Service L/C Fee |  |  |  | 0
Marketing Fee |  |  |  | 0 | 0 | 0 | 0
Administrative Fee |  |  |  | 0
O&M Fees |  |  |  | 0
Total Expense
EBITDA
Depreciation & Amortization |  |  |  | 0
EBIT
Interest Expense |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense) |  |  |  | 0
[NAME]
CASH FLOW CALVERT
Investor Interest
('000 $) |  |  |  | 1999
EBITDA
Capital Expenditures |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service |  |  |  | 0
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense) |  |  |  | 0
Federal Cash Taxes Benefit (Expense) |  |  |  | 0
After Tax Cash Flow
Investor Net Income
Investor [NAME]
Spreadsheet: 828079d1683211495-in-need-of-a-sum-formula-in-the-first-row-of-every-instance-of-a-date-within-a-table-test1
Sheet: Sheet1

 | Starting qty |  | 2000
Date | Job | fill qty | Remaining qty | Plus purchase |  |  | Purchase order | Qty | Date
2023-05-03 00:00:00 | 12345 | 25 |  |  |  |  | PO-000123 | 19200 | 2023-05-04 00:00:00
2023-05-03 00:00:00 | 12346 | 20 |  |  |  |  | PO-000124 | 18600 | 2023-05-05 00:00:00
2023-05-03 00:00:00 | 12347 | 35 |  |  |  |  | PO-000125 | 17500 | 2023-05-05 00:00:00
2023-05-03 00:00:00 | 12348 | 15 |  |  |  |  | PO-000126 | 20100 | 2023-05-10 00:00:00
2023-05-03 00:00:00 | 12349 | 65 |  |  |  |  | PO-000127 | 18000 | 2023-05-10 00:00:00
2023-05-04 00:00:00 | 12350 | 45 |  | 19200
2023-05-04 00:00:00 | 12351 | 22
2023-05-04 00:00:00 | 12352 | 12 |  |  |  |  | Need a formula, to show result in column E
2023-05-04 00:00:00 | 12353 | 36 |  |  |  |  | the first instance of the date in column A
2023-05-05 00:00:00 | 12354 | 25 |  | 36100 |  |  | to sum second table's quantities that are recorded on that date
2023-05-05 00:00:00 | 12355 | 33
2023-05-05 00:00:00 | 12356 | 14 |  |  |  |  | leaving remaining cells empty in column E
2023-05-05 00:00:00 | 12357 | 24
2023-05-05 00:00:00 | 12358 | 24
2023-05-05 00:00:00 | 12359 | 25
2023-05-05 00:00:00 | 12360 | 65
2023-05-05 00:00:00 | 12361 | 45
2023-05-05 00:00:00 | 12362 | 22
2023-05-09 00:00:00 | 12363 | 12
2023-05-09 00:00:00 | 12364 | 36
2023-05-09 00:00:00 | 12365 | 20
2023-05-09 00:00:00 | 12366 | 35
2023-05-09 00:00:00 | 12367 | 24
2023-05-09 00:00:00 | 12368 | 36
2023-05-10 00:00:00 | 12369 | 45 |  | 38100
2023-05-10 00:00:00 | 12370 | 22
2023-05-10 00:00:00 | 12371 | 12
2023-05-10 00:00:00 | 12372 | 36
2023-05-11 00:00:00 | 12373 | 20
2023-05-11 00:00:00 | 12374 | 35
2023-05-11 00:00:00 | 12375 | 24
2023-05-11 00:00:00 | 12376 | 24
Spreadsheet: 138224d1327577497-help-with-extracting-data-from-table-sample
Sheet: report

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  | 2 | data 1 | data 2 | data 3 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
Spreadsheet: 017b5546-0a7d-4db4-9355-b8644e71da1e
Sheet: Executive Summary

Project Title | Sample Project |  |  |  |  |  | Reporting Date
Quality Assurance Executive Summary
Authored by:
Overall Rating | Green/Yellow/Red |  |  |  |  |  | (Contractor subjective assessment for the reporting period)
[NAME] | Green/Yellow/Red |  |  |  |  |  | (Contractor subjective assessment for the reporting period)
Budget Rating | Green/Yellow/Red |  |  |  |  |  | (Contractor subjective assessment for the reporting period)
Scope Stability Rating | Green/Yellow/Red |  |  |  |  |  | (Contractor subjective assessment for the reporting period)
Overall Trend | Improving/Deteriorating/Static |  |  |  |  |  | (Contractor subjective assessment for the reporting period)
Overall Score | Calculated
Risk Management | Carried from worksheet
Project Deliverables | Carried from worksheet
Project Management | Carried from worksheet
Product Deliverables | Carried from worksheet
Reporting Summary | (Contractor assessment for the reporting period)
Changes since last report | (Contractor assessment for the reporting period)
Current Recommendations | (Contractor recommendations for corrective activities or risk considerations)
Status of Prior Recommendations | (Contractor recommendations for corrective activities or risk considerations)
Individuals Interviewed/Dates
Documents Reviewed/Dates
Meetings Attended/Dates
Spreadsheet: 776283d1649674190-advanced-filter-specific-columns-advaced-filter-specific-columns
Sheet: Imported Data

Employee Name | Surname | Branch | Clock No | Code | Amount | Sal Code
[NAME] | [NAME] | BR1 | 98514 | 9050 | 3258 | DRT
[NAME] | Log | BR1 | 98510 | 9050 | 2505 | DRT
[NAME] | Palm | BR1 | 98518 | 9050 | 2679 | DEY
[NAME] | Petzer | BR2 | 98507 | 9050 | 1725 | DEL
[NAME] | Davids | BR3 | 98502 | 9050 | 1508 | DRT
Spreadsheet: 8867e228-9c62-49e6-87bd-8b264294d892
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
263453 | 73131 | Ramón | Arroyo Prieto | ESP | 46 |  |  |  |  |  | 4 | 1:12:24
263453 | 72736 | Miguel | [NAME] | ESP | 47 |  |  |  |  |  | 3 | 1:12:18
263453 | 74768 | [NAME] | Layola [NAME] | ESP | 48 |  |  |  |  |  | 2 | 1:06:41
263453 | 63046 | Diego | Velazquez Rodriguez | ESP | 41 |  |  |  |  |  | 1 | 1:00:53
263453 | 49500 | Raul | [NAME] | ESP | 43 |  |  |  |  |  | 5 | 1:17:49
Spreadsheet: benjamin_rogers__1100__fixed O&M 2000 Peakers rev I
Sheet: 2000 Peakers

2000 Peakers
Lincoln
 |  |  |  |  | electricity | [NAME] | one offs | explanation |  | One off
 |  |  | om |  |  | 11570 | 149600 | total--see one off sheet |  | 2000 Reimbursable  Labor | 50000
 |  |  | monthly |  |  |  |  |  |  | 2000 Electricity | 20000
 |  |  | [NAME] |  |  |  |  |  |  | 2000 [NAME] | 23000
 |  |  |  |  |  |  |  |  |  | 2000 Plant GA | 13000
 |  | Fxd OM Estimate |  |  |  |  |  |  |  | 2000 Plant Consumables | 10000
 |  |  |  |  |  |  |  |  |  | 2000 Fire Protection System | 2600
 |  |  |  |  |  |  |  |  |  | 2000 Tools and [NAME] | 31000
 |  |  |  |  |  |  |  |  |  | Total
 |  | Target Fxd OM |  |  | 1449000
 |  | Difference in Fxd OM estimate
Wheatland |  |  |  |  |  |  |  |  |  | One off
 |  |  |  |  | electricity | [NAME] | one offs | explanation
 |  |  | om |  |  |  | 410000 | total--see one off sheet |  | 2000 [NAME] | 200000
 |  |  | monthly |  |  |  |  |  |  | 2000 Fire Protection | 40000
 |  |  | [NAME] |  |  |  |  |  |  | 2000 Electricity | 170000
 |  |  |  |  |  |  |  |  |  | Total
 |  | Fxd OM Estimate
 |  | Target Fxd OM |  |  | 1500000
 |  | Difference in Fxd OM estimate
[NAME] |  |  |  |  |  |  |  |  |  | One off
 |  |  |  |  | electricity | [NAME] | one offs | explanation |  | 2000 Plant GA | 80000
 |  |  | om |  |  |  | 80000 | total--see one off sheet |  | Total
 |  |  | monthly
 |  |  | [NAME]
 |  | Fxd OM Estimate
 |  | Target Fxd OM |  |  | 1242000
 |  | Difference in Fxd OM estimate
 |  | [NAME]
Data Sources:
1)  Actual/CE page of Expense Analysis Summary (as per Theresa Vos)
Methodology
1)  Imputs came for CE inputs through end of 2000.
2)  Variances based upon the CE was used for one off analysis
3)  Full variance amounts were used for one off calculations
4)  For 2000 Peakers, variance was multiplied by 2 in order to annualize
5)  Fxd OM estimate was calculated based on subtotal OM less OM and [NAME]
Spreadsheet: 279b6268-897e-4543-b27e-035683649931
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 77. Value of Building Approved, Chain Volume Measures, Original - Queensland
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total houses ;  New ; |  |  | Original | A590497K | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total other residential building ;  New ; |  |  | Original | A590498L | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  New ; |  |  | Original | A590499R | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590500L | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590501R | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590502T | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590503V | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: 50986d29-2095-4383-8e84-c2070a0f8da7
Sheet: Sheet1

Unnamed: 0 | COACH: | Unnamed: 2 | ___ U____ | Unnamed: 4 | Manager: | Unnamed: 6
 | [NAME]: |  | NADO SELECT |  | [NAME]:
 | Home: |  | 2007-2008 |  | Home:
 | Cell: |  |  |  | Cell:
# | PLAYERS | PARENTS | PHONE | CELL PHONE | [NAME] | ADDRESS
1
 | DOB:
2
 | DOB:
3
 | DOB:
4
 | DOB:
5
 | DOB:
6
 | DOB:
7
 | DOB:
8
 | DOB:
9
 | DOB:
10
 | DOB:
11
 | DOB
12
 | DOB:
13
 | DOB:
14
 | DOB:
DEV
 | DOB:
DEV
 | DOB:
DEV
 | DOB:
DEV
 | DOB:
Spreadsheet: 1dc39454-70f6-426b-bf7c-ea90d87730c6
Sheet: Statute

M.S. 126C.17
BEFORE AMENDMENT | Subd. 7a.    Referendum tax base replacement aid.  For each school district that had a referendum
 | allowance for fiscal year 2002 exceeding $415, for each separately authorized referendum levy, the
 | commissioner of revenue, in consultation with the commissioner of children, families, and
 | learning, shall certify the amount of the referendum levy in taxes payable year 2001 attributable to
 | the portion of the referendum allowance exceeding $415 levied against property classified as
 | class 2 4c(1), or 4c(4), under section 273.13, excluding the portion of the tax paid by the portion of
 | class 2a property consisting of the house, garage, and surrounding one acre of land.  The
 | resulting amount must be used to reduce the district's referendum levy amount otherwise
 | determined, and must be paid to the district each year that the referendum authority remains in
 | effect.  The aid payable under this subdivision must be subtracted from the district's referendum
 | equalization aid under subdivision 7.  The referendum equalization aid after the subtraction must
 | not be less than zero.
 | For the purposes of this subdivision, the referendum levy with the latest year of expiration is
 | assumed to be at the highest level of equalization, and the referendum levy with the earliest year of
 | expiration is assumed to be at the lowest level of equalization.
AFTER AMENDMENT | Subd. 7a.    Referendum tax base replacement aid.  For each school district that had a referendum
 | allowance for fiscal year 2002 exceeding $415, for each separately authorized referendum levy, the
 | commissioner of revenue, in consultation with the commissioner of education, shall certify the
 | amount of the referendum levy in taxes payable year 2001 attributable to the portion of the
 | referendum allowance exceeding $415 levied against property classified as class 2,
 | noncommercial 4c(1), or 4c(4), under section 273.13, excluding the portion of the tax paid by the
 | portion of class 2a property consisting of the house, garage, and surrounding one acre of land.  The
 | resulting amount must be used to reduce the district's referendum levy amount otherwise
 | determined, and must be paid to the district each year that the referendum authority remains in
 | effect, is renewed, or new referendum authority is approved.  The aid payable under this subdivision
 | must be subtracted from the district's referendum equalization aid under subdivision 7.  The
 | referendum equalization aid after the subtraction must not be less than zero.
Spreadsheet: 106264d1303417308-count-unique-values-in-one-column-depending-on-multiple-values-in-multiple-columns-example1
Sheet: Sheet1

Manager | Type | Employee
Manager1 | A | Employee1
Manager2 | C | Employee1
Manager3 | E | Employee1
Manager1 | F | Employee1
Manager2 | G | Employee1
Manager3 | H | Employee1
Manager1 | J | Employee1
Manager2 | D | Employee2
Manager3 | E | Employee2
Manager1 | G | Employee2
Manager2 | G | Employee3
Manager3 | A | Employee4
Manager1 | D | Employee4
Manager2 | E | Employee4
Manager3 | A | Employee5
Manager1 | C | Employee5
Manager2 | D | Employee5
Manager3 | F | Employee5
Manager1 | H | Employee5
Manager2 | A | Employee6
Manager3 | I | Employee6
Manager1 | J | Employee6
Manager2 | A | Employee7
Manager3 | E | Employee7
Manager1 | F | Employee7
Manager2 | H | Employee7
Manager3 | I | Employee7
Manager1 | J | Employee7
Manager2 | A | Employee8
Manager3 | C | Employee8
Manager1 | E | Employee8
Manager2 | H | Employee8
Spreadsheet: 51070d1250637390-find-unique-cell-then-copy-to-other-sheets-missing
Sheet: RESULTS

Match and Found |  | Missing Not Found
 | *221027617* | *221027617*
 | *221028165* | *221028165*
 | *221028235* | *221028235*
 | *00460147402025* | *00460147402025*
 | *[PHONE]* | *[PHONE]*
 | *[PHONE]* | *[PHONE]*
 | *00730836502902* | *00730836502902*
 | *00730839605199* | *00730839605199*
 | *00874738205926* | *00874738205926*
 | *00874803205168* | *00874803205168*
 | *00938841703755* | *00938841703755*
 | *00938902500339* | *00938902500339*
 | *00938902500353* | *00938902500353*
 | *05ZVN39CGL71* | *05ZVN39CGL71*
 | *06J9H6BRRT66* | *06J9H6BRRT66*
*I1523TCO93* | *I1523TCO93*
M90705FXXV87 | M90705FXXV87
1821691v003e1 | 1821691v003e1
 | martin1234 | martin1234
 |  | 0
Spreadsheet: 023cda2c-2f0a-443d-8eee-eda41041b218
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44038189 | 2014-11-15 21:58:22 | AXIS | 1 | 7 | 2 | 1589254 | Dieudonné de Laubier | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44038502 | 2014-11-15 22:15:16 | ALLIES | 0 | 4 | 7 | 1589254 | Dieudonné de Laubier | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44055919 | 2014-11-16 23:00:49 | AXIS | 1 | 5 | 4 | 940478 | Junior72 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44056247 | 2014-11-16 23:15:45 | ALLIES | 1 | 5 | 4 | 940478 | Junior72 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44096503 | 2014-11-19 21:30:25 | AXIS | 0 | 5 | 7 | 13513 | Dreexxer | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44096892 | 2014-11-19 21:51:49 | ALLIES | 0 | 3 | 7 | 13513 | Dreexxer | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44110897 | 2014-11-20 23:06:22 | AXIS | 0 | 5 | 6 | 20796 | Titanos | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
44111118 | 2014-11-20 23:32:35 | ALLIES | 0 | 4 | 6 | 20796 | Titanos | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
44137561 | 2014-11-22 21:58:41 | AXIS | 0 | 4 | 6 | 632845 | [NAME] du Sud | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44138000 | 2014-11-22 22:23:19 | ALLIES | 1 | 6 | 1 | 632845 | [NAME] du Sud | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44153717 | 2014-11-23 22:12:58 | ALLIES | 1 | 5 | 1 | 1601877 | [NAME] | 9580 | western | 1944-06-11 | 1944-06-12 | Carentan Causeway | [NAME]
44153870 | 2014-11-23 22:27:18 | AXIS | 0 | 3 | 5 | 1601877 | [NAME] | 9580 | western | 1944-06-11 | 1944-06-12 | Carentan Causeway | [NAME]
Spreadsheet: 806513d1669358823-match-partial-or-complete-text-and-match-in-another-column-to-extract-index-value-help-4-ans
Sheet: INDEX-MATCH1 (2)

 |  |  | need to match partial title and chn and bring value from index column
 | Employee |  |  | =INDEX(F$7:F$11,MATCH(TRUE,ISNUMBER(SEARCH(B$6:[NAME]))
 | title | chn | expected result | current formula I have | lookup data
 | [NAME] | AAA | Kaisi |  | index value | chn
 | Siyan | GGG | siyani |  | Kaisi | AAA
 | Farq E | AAA | farq |  | siyani | GGG
 | Habs Ep | AAA | habs |  | farq | AAA
 | magar | HHH |  |  | habs | AAA
 | [NAME] | GGG | agar |  | agar | GGG
 | [NAME] | AAA | Kaisi
 | [NAME] | GGG
Spreadsheet: 771912d1646916169-count-data-only-from-filtered-cells-test
Sheet: List1

 |  |  | Count old:
 |  |  | Count new: |  |  | I would like to get counts only for filtered datas
 |  |  | Count all:
 |  |  |  |  |  | (If I now filter D collumn, formula still count me all datas)
 |  | Name: | In use | New / old
 |  | A | x | New
 |  | B | x | Old
 |  | C |  | Old
 |  | D | x | Old
 |  | E |  | New
 |  | F | x | Old
 |  | G | x | New
 |  |  | I would like to filter cells in D collumn
Spreadsheet: 1c2fd869-27c9-4309-8254-652dd2a68e69
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
(condensed consolidated financial statements -
dollars in millions, except per share data)
Statement of Earnings
(unaudited)
 |  |  | Three Months ended |  |  |  |  |  | Six Months ended
 |  |  | June 30 |  |  |  |  |  | June 30
 |  |  | 2008 |  |  | 2007 |  |  | 2008 |  |  | 2007
Net sales |  | $ | 622.2 |  | $ | 611.5 |  | $ | 1193.6 |  | $ | 1188.7
Cost of products sold |  |  | 480.6 |  |  | 476.7 |  |  | 919.4 |  |  | 931.1
Gross profit |  |  | 141.6 |  |  | 134.8 |  |  | 274.2 |  |  | 257.6
Selling, general and administrative |  |  | 94.2 |  |  | 90.4 |  |  | 188 |  |  | 178.7
Restructuring and other charges |  |  | 0.3 |  |  | 1.6 |  |  | 4.1 |  |  | 2.8
Interest expense |  |  | 5.1 |  |  | 7 |  |  | 10.5 |  |  | 13.8
Other income |  |  | 0 |  |  | -0.5 |  |  | -0.1 |  |  | -0.3
 |  |  | 42 |  |  | 36.3 |  |  | 71.69999999999993 |  |  | 62.6
Tax provision |  |  | 10 |  |  | 9.3 |  |  | 17.7 |  |  | 16.1
Earnings before equity in loss of joint venture |  |  | 32 |  |  | 27 |  |  | 53.99999999999993 |  |  | 46.5
Equity loss in joint venture |  |  | -0.1 |  |  | 0 |  |  | -0.2 |  |  | 0
Net Earnings |  | $ | 31.9 |  | $ | 27 |  | $ | 53.79999999999993 |  | $ | 46.5
Diluted Earnings Per Share of Common Stock |  | $ | 1.064540539166414 |  | $ | 0.8709869036473644 |  | $ | 1.779348013814353 |  | $ | 1.499888185754927
 | Average Common Shares Outstanding  (000's omitted) |  | 30250.141 |  |  | 30999.318 |  |  | 30235.794 |  |  | 31002.311