tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: c01ceac2-a1d1-44d4-b724-d6640987f605
Sheet: Sheet1

JANUARY | Units are no longer allowed to bring their own firewood to camp | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
CHARTS ARE UPDATED DAILY. FOR UP TO THE MINUTE AVAILABILITY CALL (716) 891-4073 OR E-MAIL [EMAIL] |  |  |  |  |  |  | 2013-12-11 00:00:00
SCHOELLKOPF |  |  |  | 2014 | 2014 | 2014 | 2014
 | Capacity | Code | FEE | JAN 3 - 5 | JAN 10 - 12 | JAN 17 - 19 | JAN 24 - 26
District/Council Events
**Phillip (Lower) | 8 | S,W,E | 48 |  | T513 1/4W
**Schoellkopf (Upper) | 12 | S,W,E | 72 |  | T513 1/4W | T523
Schwartz | 14 | S,W | 70
Score | 18 | S,W,E | 108 | [NAME] | T864 W | T510 W | [NAME]
**Self | 12 | S,W,E | 72 |  | T401 OC W | [NAME]
Sikes | 16 | S,W,E,C | 96 | [NAME] | T507 W | T890 W | [NAME]
**Toulmin | 18 | S,W,E | 108 | T599 W | T58 W | [NAME]
Lean-To's
**Art Wood (Flats) | 12 | W | 48
**[NAME] (Northwoods) | 12 | W | 48
**Seibel (Northwoods) | 12 | W | 48
**Faso (Meyer Village) | 12 | W | 48 |  |  | T352 W
**[NAME] (Meyer Village) | 12 | W | 48 |  |  | T352
**[NAME] (Meyer Village) | 12 | W | 48
Troop 7 Shelter | 20 | S,W,E | 96 |  | T593 W | T4 OC W
**Szymkowiak lean-to | 12 | W, E | 72
Tenting $2 per person, per night
Tenting $2 per person, per night
Tenting $2 per person, per night
Day Hike $2 per person
**SEASONAL [NAME] MAY BE CLOSED FOR VEHICLE TRAFFIC, PLEASE CONTACT THE RANGER AT [PHONE]
SCOUTHAVEN |  |  |  | 2014 | 2014 | 2014 | 2014
 | Capacity | CODE | FEE | JAN 3 - 5 | JAN 10 - 12 | JAN 17 - 19 | JAN 24 - 26
District/Council Events |  |  |  |  |  |  | OKPIK
[NAME] | 20 | S,W,E | 120 |  |  | T506 1/4W
Loegler 1 | 20 | C,S,W,E | 120 | P416 | [NAME] | T411 W | OKPIK (F)
Loegler 2 | 20 | C,S,W,E | 120 | P416 | T735 W | T411 W | OKPIK (F)
[NAME] | 30 | C,S,W,E | 180 | P416 | T85 W | T286 W | P620 W
Lean-To's
#1 Eagle | 12 | W | 48 |  | T184 W | T539 W
#2 Whitetail | 12 | W | 48
#3 Dziedzic | 12 | W | 48
Moose | 10 | W | 40
Boss | 12 | W | 48 | T416 |  | T528
Lakeside |  |  |  |  |  |  | OKPIK
Tenting $2 per person, per night
Tenting $2 per person, per night
Day Hike $2 per person
 |  |  |  | 2014 | 2014 | 2014 | 2014
[NAME] | Capacity | CODE | FEE | JAN 3 - 5 | JAN 10 - 12 | JAN 17 - 19 | JAN 24 - 26
District/Council Events
Cabin #1  (Porch) | 24 | S,W,E | 144 |  | P3044 1/4W
Cabin #2 | 24 | S,W,E | 144 |  | P3044 1/4W | T559 W
Leader's Lodge | 28 | S,W,E | 168 | [NAME] | T618 W | [NAME]
[NAME] | 30 | C,S,W,E | 180 |  | T92 W | T483 W | P539 W
Stone Lean-To | 6 | [NAME] | 24
Troop 107 Lean-To | 8 | W | 30 |  | T931 W
*New  Ganosote Lean-To | 12 | W | 48 |  |  | T431 W
*New Tuscarora Lean-To | 12 | W | 48 |  |  | T431
Tenting $2 per person, per night
Tenting $2 per person, per night
Tenting $2 per person, per night
Day Hike $2 per person
Code: S=Cooking Stove; W=Wood Heating Stove; E=Electricity; C=Co-Ed Ready
Firewood is $50.00 per 1/2 face cord.
Spreadsheet: 57361d1257454606-count-data-705705-count-data2
Sheet: Report

 | Report created |  | 2009-11-06 00:00:00
 | Bristol | Bristol | Bristol | London | London | London | [NAME] | [NAME] | [NAME] | Paisley | Paisley | Paisley
months | 255 | 52479 | 65280 | 255 | 52479 | 65280 | 255 | 52479 | 65280 | 255 | 52479 | 65280
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0
9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0
30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
32 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 0 | 0
33 | 0 | 0 | 3 | 0 | 0 | 0 | 3 | 2 | 1 | 0 | 0 | 0
34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Spreadsheet: monika_causholli__28284__DT 2002
Sheet: 2002 Forecast

NA Production (assume 97.5% OR)
 | HISTORICAL AVERAGES
 | Months |  |  | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL
 | Seasonal Monthly Factors
 |  | Production
 |  | Consumption
 |  | Net Exports
 | 2002 FORECAST
 | Months |  |  | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL
 | 2002 Potential Production |  | 15668
 | Temporary Downtimes |  |  | 12
 |  | [NAME] ([NAME]) |  | 11 | 11 | 11
 |  | Port Alberni, [NAME] ([NAME]) |  | 11
 |  | Sheldon, TX (Abitibi) |  | 13 | 13 | 13 | 13 | 13 | 13
 | Total Temporary Downtimes
 | Permanent Downtimes
 | Total Permanent Downtimes
 | TOTAL DOWNTIMES
 | PRODUCTION
 | PPPC 2002 Forecasted Consumption |  | 12135
 | CONSUMPTION
 | PPPC 2002 Forecasted Net Exports |  | 2745
 | NET EXPORTS
 | SURPLUS PAPER (INVENTORIES)
 | ACTUALS vs, HISTORICALS
 | Months |  |  | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL
 | 2002 Forecasted Production (monthly %)
 | Difference From Historical Average
 | TRANSLATED INTO TONNES (000s)
 | 2001 Forecasted Consumption (monthly %)
 | Difference From Historical Average
 | TRANSLATED INTO TONNES (000s)
 | 2002 Forecasted Net Exports (monthly %)
 | Difference From Historical Average
 | TRANSLATED INTO TONNES (000s)
Spreadsheet: 157897d1337911692-trouble-with-tabulating-final-score-selection-done-by-radio-buttons-test
Sheet: Scoresheet

Criteria/Subcriteria | Weight | Unsatisfactory | Marginal | Satisfactory | Very Good | Exceptional | Total
 |  | 0 | 1 | 2 | 3 | 4
Quality | 0.2 |  |  |  |  |  |  |  |  | Total Percentage based on H4,H5,H6,H7
Product Quality | 0.25
Corrective Action Management | 0.25
Quality Management Policies / Practices / Processes | 0.25 |  |  |  |  |  |  |  |  | If user selects Exceptional, than he would have scored 25%, if very good, 20%, satisfactory, 15%, marginal 10% and Unsatisfactory 5%.
Document Management Quality | 0.25
 | Weight |  |  |  |  |  | Total
Price/Cost | 0.1
CPI | 0.5
Cost Reduction Efforts | 0.25 |  |  |  |  |  |  |  | [NAME] is 100% of H9 which is 10% weightage for overall rating. [NAME] is subcategories of H9.
Payment Term Flexibility | 0.25
 | Weight |  |  |  |  |  | Total
Management | 0.2
Communication | 0.5
Representation | 0.25
Sub-Tier Supplier Management | 0.25
 | Weight |  |  |  |  |  | Total
Technical | 0.2
Technical Compliance | 0.5
Manpower | 0.25
Technical Project Management | 0.25
 | Weight |  |  |  |  |  | Total
Responsiveness | 0.2
Timeliness | 0.5
[NAME] | 0.25
Effective Communication | 0.25
 | Weight |  |  |  |  |  | Total
Compliance of Schedule | 0.1
SPI | 0.5
Schedule/Delivery Improvement Efforts | 0.5
Note: The %'s are defaults and can be altered
Spreadsheet: 844083d1695895975-formula-to-calculate-age-difference-test-107-aligw
Sheet: Sheet1

 |  |  |  | Target | Score | Difference | AliGW
 |  |  |  | 6/9 | 7/10 | 1/1
 |  |  |  | 6/4 | 6/4 | 0/0
 |  |  |  | 6/8 | 7/1 | 0/5
 |  |  |  | 6/11 | 5/5 | -1/6
 |  |  |  | 6/10 | 6/10 | 0/0
 |  |  |  | 6/6 | 7/2 | 0/8
 |  |  |  | 6/3 | 9/5 | 3/2
 |  |  |  | 6/2 | 7/9 | 1/7
 |  |  |  | 6/10 | 7/9 | 0/11
 |  |  |  | 6/5 | 7/9 | 1/4
 |  |  |  | 6/10 | 7/1 | 0/3
 |  |  |  | 6/5 | 6/6 | 0/1
 |  |  |  | 6/10 | 6/6 | -0/4
Spreadsheet: 839753d1692197392-summarising-data-from-many-spreadsheets-into-one-spreadsheet-example
Sheet: Sheet1

Name | % of Total Time that Client Facing | Available Hours | Total Chargeable Time (Cells M + N) | No days holiday this year | Wellbeing Time | Client Chargeable Time | Client Chargeable time | Client PD Time | Resource Management | Team Management | Personal Development (incl [NAME]) | Business Development Support Activities | Business Development Responsibilities | Management Responsibilities | Leadership Responsibilities | Commercial Responsibilities | Other Responsibilities: | Total Hours
First Person |  | Cell [NAME] |  | Cell D11 | Cell D13 | Cell D18 |  | Cell [NAME] | Cell F20 | Cell F22 | Cell F27 |  | Cell F31 | CellF34 |  |  | Cell F37
Second Person
[NAME]
[NAME]
Fifth Person
[NAME] denote where data needs to be stored and pulled in from other workbooks
Spreadsheet: 593798d1539335216-sumifs-formula-variation-help-vat-1-
Sheet: VAT summary

 |  |  | Month | Quarter | Year
 |  | [NAME]
 |  | Sales |  |  | Net | VAT | Gross
 |  |  |  |  | € | € | €
 |  | VATable | BURC | 2018-10-01 00:00:00 |  |  | 0
 |  | NonVATable | 0-VAT | 2018-10-01 00:00:00 |  |  | 0
 |  | Purchases |  |  | Net | VAT | Gross
 |  |  |  |  | € | € | €
 |  | VATable | Standard rated | 2018-10-01 00:00:00 | 0 | 0 | 0
 |  | Reverse Charge |  | 2018-10-01 00:00:00 | 0 | 0 | 0
Spreadsheet: 7ccc0e2c-877c-4d0f-821a-88d39b14b31a
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
43183625 | 2014-09-16 13:59:50 | AXIS | 0 | 3 | 5 | 1142502 | Soldat d'Automne | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
43183762 | 2014-09-16 14:24:11 | ALLIES | 0 | 3 | 5 | 1142502 | Soldat d'Automne | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
Spreadsheet: benjamin_rogers__1069__Consolidated 2000 Peaker
Sheet: Assumptions

ASSUMPTIONS
TECHNICAL ASSUMPTIONS: |  | 2000 PROJECTS
 |  | [NAME] | Wheatland | [NAME] |  | Total
Number of Turbines |  | 3 | 4 | 8
Summer Capacity (MW)(1) |  | 510 | 470 | 608
[NAME] (HHV, Btu/kWh) |  | 10592 | 11734 | 11973
Numbers of Starts |  | 75 | 75 | 75
PRICING ASSUMPTIONS:
Fixed Price Demand Charge ($/kW-month) |  | 4
Energy Charge ($/MWh)
Start Charge ($/Start/Turbine)
Annual Generation (MWh) |  | 532991.6197855896 | 461312.7218562186 | 2002000
OPERATING COSTS ASSUMPTIONS:
Variable O&M ($/MWh) |  | 1.5 | 3 | 2
Major [NAME] ($/Start/Turbine) |  | 1500 | 1500 | 1000
Annual Escalator |  | 0.03
Annual Cost (000$ in Year 2000)
Fixed O&M |  | 1242.481714285714 | 1515.790285714286 | 1448.540571428571
Variable O&M
Major [NAME]
Owner's Expense |  | 322.2511428571429 | 306.2677142857142 | 400.6471428571429
Property Tax Liability
TAX ASSUMPTIONS:
Federal Income Tax Rate |  | 0.35 | 0.35 | 0.35 |  | 0.35
State Income Tax Rate |  | 0.06 | 0.045 | 0.0718
Adjusted Gross Income Tax |  | N/A | 0.034 | N/A
Gross Receipts Tax Rate |  | N/A | 0.012 | N/A
Franchise Tax Rate (Year 1) |  | 0.0025 | N/A | 0.0015
Franchise Tax Rate (Year 2-20) |  | 0.0025 | N/A | 0.001
Spreadsheet: 790883d1660047762-dividing-substrings-with-xml-filter-split-strings-into-substrings
Sheet: Before

String
event_type="BUSINESS" gebr_id_srt="BSN" gebr_id="2xx78" gebr_naam="R R JAE" reg_moment="2017-04-19-22:02:27.00639" meetpunt="BS06E" soort="Einde" app_comp="VT" ip_adres="92.6" actie="Authenticeren (DigiD)" result="Succes" kanaal="Internet"
event_type="BUSINESS" gebr_id_srt="BSN" gebr_id="2xx78" gebr_naam="R R JAE" reg_moment="2017-04-19-22:02:27.00639" meetpunt="BS06E" soort="Einde" app_comp="VT" ip_adres="92.6" actie="Authenticeren (DigiD)" result="Succes" kanaal="Internet"
event_type="BUSINESS" gebr_id_srt="BSN" gebr_id="2xx78" gebr_naam="R R JAE" reg_moment="2017-04-19-22:02:27.00639" meetpunt="BS06E" soort="Einde" app_comp="VT" ip_adres="92.6" actie="Authenticeren (DigiD)" result="Succes" kanaal="Internet"
event_type="BUSINESS" gebr_id_srt="BSN" gebr_id="2xx78" gebr_naam="R R JAE" reg_moment="2017-04-19-22:02:27.00639" meetpunt="BS06E" soort="Einde" app_comp="VT" ip_adres="92.6" actie="Authenticeren (DigiD)" result="Succes" kanaal="Internet"
event_type="BUSINESS" gebr_id_srt="BSN" gebr_id="2xx78" gebr_naam="R R JAE" reg_moment="2017-04-19-22:02:27.00639" meetpunt="BS06E" soort="Einde" app_comp="VT" ip_adres="92.6" actie="Authenticeren (DigiD)" result="Succes" kanaal="Internet"
event_type="BUSINESS" gebr_id_srt="BSN" gebr_id="2xx78" gebr_naam="R R JAE" reg_moment="2017-04-19-22:02:27.00639" meetpunt="BS06E" soort="Einde" app_comp="VT" ip_adres="92.6" actie="Authenticeren (DigiD)" result="Succes" kanaal="Internet"
event_type="BUSINESS" gebr_id_srt="BSN" gebr_id="2xx78" gebr_naam="R R JAE" reg_moment="2017-04-19-22:02:27.00639" meetpunt="BS06E" soort="Einde" app_comp="VT" ip_adres="92.6" actie="Authenticeren (DigiD)" result="Succes" kanaal="Internet"
event_type="BUSINESS" gebr_id_srt="BSN" gebr_id="2xx78" gebr_naam="R R JAE" reg_moment="2017-04-19-22:02:27.00639" meetpunt="BS06E" soort="Einde" app_comp="VT" ip_adres="92.6" actie="Authenticeren (DigiD)" result="Succes" kanaal="Internet"
event_type="BUSINESS" gebr_id_srt="BSN" gebr_id="2xx78" gebr_naam="R R JAE" reg_moment="2017-04-19-22:02:27.00639" meetpunt="BS06E" soort="Einde" app_comp="VT" ip_adres="92.6" actie="Authenticeren (DigiD)" result="Succes" kanaal="Internet"
Spreadsheet: susan_pereira__39436__LAGASMAR
Sheet: ENRON

 | VARIBUS CORPORATION |  |  |  |  |  |  |  | JANUARY 31, 1999 |  |  |  |  |  |  | {SERVICES}PSNU~QAGQ
 | P.O. BOX 61000
 | NEW ORLEANS, LA 70161 |  |  |  |  |  | INVOICE NUMBER |  |  |  |  | 99-01-04
 | PH# (504)576-4152
 | IN ACCOUNT WITH
 | LOUISIANA GAS  MARKETING |  |  |  |  |  |  |  | AMOUNT
 | Attn: [NAME]
 | 1400 SMITH ST  Suite 3722A
 | Houston, Texas 7777002
 |  |  |  |  |  | PER
MMBTU'S |  |  | [NAME] |  |  | MMBTU |  |  |  |  |  | AMOUNT
7406 |  |  | Natural Gas Transported to |  |  | 0.03 |  |  |  |  |  | 222.18
 |  |  | GSU at [NAME] in
 |  |  | Dec 1998
 |  |  | (Via  LRC )
 |  |  | Contact Person
 |  |  | Accounting Question
 |  |  | [NAME]Ph# (504)576-4152
 |  |  | Operational Questions
 |  |  | [NAME] Ph# (281)297-3553
 |  |  |  | TOTAL AMOUNT DUE
 | PLEASE REMIT TO:
 | VARIBUS
 | P.O. BOX 61000
 | NEW  ORLEANS, LA.   70161
 | Attn: [NAME]
Spreadsheet: 862366d1710124339-data-validation-from-multiple-sheets-w-in-workbook-indirect-data-val-bvj-
Sheet: Main

 | As of: | 2023-09-30 00:00:00 | Manpower | Auth | Req | On Hand | Vacancies | % Vacancies |  |  | Project A
 | Program/Project: |  |  | 5 | 5 | 4
 | Sponsor/Customer: | Multiple |  | 3 | 3 | 0
 | Directorate: |  |  | 0 | 0 | 0
 | Program Mgr: |  |  | 0 | 0 | 0
 | PE: |  |  | 10 | 10 | 10
 | Overall Status: | On track | Total
 | Description:
 | Milestones, Deliverables, Risks, and Accomplishments
 | Project | Objectives | MS # | Milestones | Planned Completion | Actual Completion | [NAME] | [NAME] | Due | Delivered | Risk | Type | Corrective Action Plan (CAP) | Significant Accomplishments
 | Project A | Something |  | Proj A Task 5 |  |  |  | Proj A Del 1 |  |  |  | Financial | Resolve FAR regulation issue
 | Project B | Something |  | Proj B Task 2 |  |  |  | Proj B Del 5 |  |  |  | Schedule | Fix HVAC- Bring SPARTAN up and continue certification process
 | Project B | Something |  | Proj B Task 3 |  |  |  | Proj B Del 6 |  |  |  | Performance
 | Project C | Something |  | Proj C Task 20 |  |  |  | Proj C Del 3 |  |  |  | Technical
 | Project C | Something |  | Proj C Task 6 |  |  |  | Proj C Del 4 |  |  |  | Multiple
Spreadsheet: 708027d1607591411-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: FRANCE

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 220056d1363041718-counting-of-rows-in-a-range-with-2-conditions-counting-bb-
Sheet: Sheet1

 |  | Dropped | Processed
 | 1 | X | X |  | X |  | Count of X in F5:F17 = |  | 4
 | 2 | X | X |  | X
 | 3 | X
 | 4
 | 5 |  | X
 | 6 | X | X |  | X
 | 7
 | 8
 | 9 | X | X |  | X
 | 10
 | 11 |  | X
 | 12 | X
 | 13
 |  | How Can I count rows in range c5:d17 for which X is present in row 5 , column C and D
 |  | the result should be for this range: |  |  | 4
Spreadsheet: 288814d1389306783-merging-rows-based-on-column-contents-orders-demo-spreadsheet
Sheet: Sheet1

Order Number | Item Ordered
1889 | Ruler
2001 | Stapler
2001 | Pencil
2001 | Eraser
2456 | Flashlight
2555 | Ruler
3890 | Stapler
3890 | Staple Remover
4455 | Pencil
GOAL SPREASHEET
Order Number | Item Ordered
1889 | Ruler
2001 | Stapler, Pencil, Eraser
2456 | Flashlight
2555 | Ruler
3890 | Stapler, Staple Remover
4455 | Pencil
Spreadsheet: 269019d1380915235-project-task-tracking-payroll-formula-help-etco-calculated-timecard-testformulas
Sheet: Detail

ETCO Calculated Timesheet for pay date range:
Project:
[NAME] | 25
 | Su | M | T | W | Th | F | Sa | Totals
Mobilize
Site Util
Under-SS
Under-BC/F
Ext Rough
Int Rough
BC wiring
BC trim/[NAME]
Feeders
Feeder trm/tst
SvcPanels
Light install
Light trm/ctrl
OFE equip
[NAME] inst/Lt ctrl
CO/T&M track
Testing
Final, As-Blts |  | 8
Holiday |  | 2 | 10 |  | 10
[NAME] |  |  |  | 10 | 2
Other
TOTAL HRS
 |  |  | Labor Cost this period=>
Spreadsheet: andy_zipper__738__10_29_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] |  | 0 | 0 | 48.6 | 82.3 | 2.63 | 2001-10-25 14:55:00
 | HO Z1 | 64 | 670 | 770 | 46.7 | 53.7 | 2.02 | 2001-10-29 10:18:00
 | HO F2 | 65 | 1000 | 1100 | 48.7 | 53.6 | 2.09 | 2001-10-29 10:18:00
 | HO G2 | 65 | 1225 | 1325 | 47.9 | 51.8 | 2.04 | 2001-10-29 10:18:00
 | [NAME] | 63 | 1300 | 1400 | 46 | 49.6 | 1.89 | 2001-10-29 10:18:00
 | HO J2 | 62 | 1300 | 1400 | 42.2 | 45.5 | 1.71 | 2001-10-29 10:18:00
 | HO K2 | 61 | 1275 | 1400 | 38.4 | 42.2 | 1.55 | 2001-10-29 10:18:00
 | HO M2 | 60 | 1275 | 1400 | 36 | 39.6 | 1.43 | 2001-10-29 10:18:00
 | HO N2 | 61 | 1300 | 1450 | 34 | 38 | 1.38 | 2001-10-29 10:18:00
 | HO Q2 |  |  |  | 31.2 | 36.8 | 1.3 | 2001-10-23 14:44:00
 | HO U2 |  |  |  | 30.2 | 34.9 | 1.25 | 2001-10-23 14:44:00
 | [NAME] |  |  |  | 28.5 | 33 | 1.2 | 2001-10-23 14:44:00
 | HO X2
 | [NAME]
 | HO F3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 117714d1312980153-sum-ifs-help-pulling-from-table-of-info-book2
Sheet: Sheet1

Cost Code |  |  |  |  | 76115750 | Budget |  | Actual
A.01.01 |  |  |  | 63026 | CON - Clearing / Grading |  |  | Plan
A.01.01 |  |  |  |  |  |  |  | Forecast
A.01.01 |  |  |  |  |  |  |  | Actual
A.01.02 |  |  |  | 63081 | CON - Ditching | 8490003.999999998 |  | Plan
A.01.02 |  |  |  |  |  | 8490004 |  | Forecast
A.01.02 |  |  |  |  |  |  |  | Actual
A.01.03 |  |  |  | 63080 | CON - Stringing | 4245502 |  | Plan
A.01.03 |  |  |  |  |  | 4245502 |  | Forecast
A.01.03 |  |  |  |  |  |  |  | Actual
[NAME] |  |  |  | 63092 | CON - Welding | 25471014 |  | Plan
[NAME] |  |  |  |  |  | 25471014 |  | Forecast
[NAME] |  |  |  |  |  |  |  | Actual
A.01.05 |  |  |  | 63098 | CON - Coating | 4245502 |  | Plan
A.01.05 |  |  |  |  |  | 4245502 |  | Forecast
A.01.05 |  |  |  |  |  |  |  | Actual
A.01.06 |  |  |  | 63095 | CON - Lower-in / Tie-in | 8490004 |  | Plan
A.01.06 |  |  |  |  |  | 8490004 |  | Forecast
A.01.06 |  |  |  |  |  |  |  | Actual
A.01.07 |  |  |  | 63096 | CON - Backfill/ Padding | 8490004 |  | Plan
A.01.07 |  |  |  |  |  | 8490004 |  | Forecast
A.01.07 |  |  |  |  |  |  |  | Actual
A.01.08 |  |  |  | 63090 | CON - Clean-Up | 16981010 |  | Plan
A.01.08 |  |  |  |  |  | 16981010 |  | Forecast
A.01.08 |  |  |  |  |  |  |  | Actual
 |  |  |  |  |  | In Cell G2 of sheet one I am trying to pull the value for the work order number (Cell F1 Sheet 1) for the cost code in cell A2/Sheet 1.
 |  |  |  |  |  | I need retrieve the information from sheet two where the work order numbers are listed in row 2 and change from column to column by work order number.
 |  |  |  |  |  | Cell F1 of sheet one is a drop down list and the work order numbers can change depending on the selection.
 |  |  |  |  |  | G2 of sheet 1 needs to retrieve the amount by Cost Code from sheet two for that particular work order.
Spreadsheet: 708651d1607962648-how-to-highlight-rows-in-tab-1-with-matching-keywords-from-tab-2-book1
Sheet: TAB 1

Date 1 | Date 2 | Provider | Other 1 | Other 2 | Other 3 | Total
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | AMAZON PAYMENT EUROPE | 0 | 0 | 0 | 20.99 |  | TOTAL AMOUNT OF HIGHLIGHTED ROWS | ?
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | AMAZON PAYMENT EUROPE | 0 | 0 | 0 | 45.98
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | AUDIBLE GMBH | 0 | 0 | 0 | 92.91
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | CHATFUEL | 0 | 0 | 0 | 26.08
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | ITUNES.COM/BILL | 0 | 0 | 0 | 10.99
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | AUDIBLE GMBH | 0 | 0 | 0 | 9.95
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | HIVEAGE.COM | 0 | 0 | 0 | 20.99
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | PAYPAL | 0 | 0 | 0 | 45.98
2020-12-21 00:00:00 | 2020-12-21 00:00:00 | PAYPAL | 0 | 0 | 0 | 92.91
2020-12-28 00:00:00 | 2020-12-28 00:00:00 | [NAME] | 0 | 0 | 0 | 26.08
2020-12-25 00:00:00 | 2020-12-25 00:00:00 | CARREFOUR | 0 | 0 | 0 | 10.99
2020-12-26 00:00:00 | 2020-12-27 00:00:00 | AMAZON PAYMENT EUROPE | 0 | 0 | 0 | 9.95
2020-12-28 00:00:00 | 2020-12-28 00:00:00 | [NAME] | 0 | 0 | 0 | 20.99
2020-12-28 00:00:00 | 2020-12-28 00:00:00 | ITUNES.COM/BILL | 0 | 0 | 0 | 45.98
2020-12-28 00:00:00 | 2020-12-28 00:00:00 | CARREFOUR | 0 | 0 | 0 | 92.91
2020-12-28 00:00:00 | 2020-12-28 00:00:00 | CHATFUEL | 0 | 0 | 0 | 26.08
2020-12-28 00:00:00 | 2020-12-28 00:00:00 | [NAME] | 0 | 0 | 0 | 10.99
Spreadsheet: 525944d1499030065-countif-to-work-out-percentages-example
Sheet: Sheet1

STATUS | Networkdays to Verbal offer accept
Open | 36
Open | 125
Open | 30
Open | 95
Open | 55
Open | 207
Open | 94
Open | 44
Open | 157
Open | 40
Open | 78
Open | 77
Open | 74
Filled | 36
Filled | 43
Filled | 56
Filled | 39
Filled | 59
Filled | 202
Filled | 156
Filled | 53
Filled | 53
Filled | 192
Filled | 31
Filled | 38
Filled | 153
Filled | 118
Filled | 53
Filled | 57
Filled | 69
Filled | 40