tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: fff9babe-0874-4bb6-913c-4930690f8a00
Sheet: Model

 |  |  |  |  |  |  |  | 2010-04-11 00:00:00
 |  |  | Chapter 11 Mini Case
Situation
Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by [NAME], a recently graduated MBA.  The production line would be set up in unused space in [NAME]' main plant.  The machinery’s invoice price would be approximately $200,000, another $10,000 in shipping charges would be required, and it would cost an additional $30,000 to install the equipment.  The machinery has an economic life of 4 years, and [NAME] has obtained a special tax ruling that places the equipment in the MACRS 3-year class.  The machinery is expected to have a salvage value of $25,000 after 4 years of use.
The new line would generate incremental sales of 1,250 units per year for 4 years at an incremental cost of $100 per unit in the first year, excluding depreciation.  Each unit can be sold for $200 in the first year.  The sales price and cost are expected to increase by 3% per year due to inflation.  Further, to handle the new line, the firm’s net working capital would have to increase by an amount equal to 12% of sales revenues.  The firm’s tax rate is 40%, and its overall weighted average cost of capital is 10%.
Analysis of New Expansion Project
Part I:  Input Data
Equipment cost |  |  | 200000 |  | Key Output:  NPV  =
Shipping charge |  |  | 10000
Installation charge |  |  | 30000
Economic Life |  |  | 4
Salvage Value |  |  | 25000
Tax Rate |  |  | 0.4
Cost of Capital |  |  | 0.1
Units Sold |  |  | 1250
Sales Price Per Unit |  |  | 200
Incremental Cost Per Unit |  |  | 100
NWC/Sales |  |  | 0.12
Inflation rate |  |  | 0.03
Depreciable Basis = Equipment + Freight + Installation
Depreciable Basis =
 | Year | % | x | Basis | = | Depr. | Remaining Book Value
 | 1 | 0.33
 | 2 | 0.45
 | 3 | 0.15
 | 4 | 0.07
Annual Operating Cash Flows
 |  |  |  | Year 1 | Year 2 | Year 3 | Year 4
Units
Unit price
Unit cost
Sales
Costs
Depreciation
Operating income before taxes (EBIT)
Taxes (40%)
EBIT (1 – T)
Depreciation
Net operating CF
e.  Estimate the required net working capital for each year, and the cash flow due to investments in net working       capital.
Annual Cash Flows due to Investments in Net Working Capital
 |  |  | Year 0 | Year 1 | Year 2 | Year 3 | Year 4
Sales
NWC (% of sales)
CF due to investment in NOWC)
After-tax Salvage Value |  |  |  |  | Hypothetical: If sold after 3 years for
 |  |  | Based on facts in case: |  | 25000 | 10000
Salvage value
Book value
Gain or loss
Tax on salvage value
Net terminal cash flow
Projected Net Cash Flows
 |  |  |  | Year 0 | Year 1 | Year 2 | Year 3 | Year 4
Investment Outlay:  Long Term Assets
Operating Cash Flows
CF due to investment in NWC
Salvage Cash Flows
Net Cash Flows
NPV
IRR |  |  |  | PV of Inflows | TV of Inflows
 |  |  |  | Years
Find MIRR |  |  |  | 0 | 1 | 2 | 3 | 4
Net Cash Flows
 |  |  | PV= |  |  |  | TV =
To find [NAME], we could now find the discount rate that equates the PV and TV.  But it is easier to use the MIRR function.
MIRR =
Spreadsheet: 485159d1476736862-sumproduct-with-other-sheets-and-criteria-sumproduct-with-criteria-bvj-v4
Sheet: Sheet1

 |  |  |  | Example 1
 |  |  |  |  | date chosen
 |  |  |  |  |  | Summary | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12
 |  |  |  |  |  |  |  | 3
 |  |  |  |  | A1 |  | 10 |  | 456 |  | 65423 |  |  | 45
 |  |  |  |  | A2 |  | 5 | 24 |  |  | 54564 | 56 |  | 5956 |  |  | 8
 |  |  |  |  | A3 |  | 2 |  |  |  |  | 3 |  | 6 | 2
 |  |  |  |  | A4 |  | 20 | 234 | 34234 | 4 | 5 |  | 5 |  |  |  | 56
 |  |  |  |  | A5 |  | 304 |  |  |  |  | 4 |  | 4 | 5
 |  |  |  |  | A6 |  | 405 |  |  | 53 |  | 4 |  | 5
 |  |  |  |  | A7 |  | 435 | 3243 |  |  |  | 678 |  |  | 867
 |  |  |  |  | A8 |  | 45 |  |  | 768 | 67 | 7
 |  |  |  |  | A9 |  |  |  |  |  | 234 |  |  | 7756454
 |  |  |  |  | A10 |  | 78 | 67 |  |  |  |  | 234 |  | 234
 |  |  |  |  | A11 |  | 67 |  |  | 34 |  |  |  | 234 |  | 435
 |  |  |  |  | A12 |  |  | 173 | 45 | 5856 |  | 738 |  | 358 | 56
 |  |  |  |  |  | choose last column
 |  |  |  |  | Areas | 2016-10-01 00:00:00
 |  |  |  |  | A1
 |  |  |  |  | A10
 |  |  |  |  | A8
 |  |  |  |  | A3
 |  |  |  |  | A6
 |  |  |  |  | A12
 |  |  |  |  | A5
 |  |  |  |  | A9
 |  |  |  |  | A7
 |  |  |  |  | A11
 |  |  |  |  | A4
 |  |  |  |  | A2
Spreadsheet: sally_beck__33963__London_Changes
Sheet: Sheet1

Changes to Format of London Summary and Executive Viewer
(USD '000s) |  |  |  |  |  |  |  | (USD '000s)
NEW LONDON SUMMARY AND EXECUTIVE VIEWER FORMAT
 | Total
TOTAL TRADING |  | [NAME]
UK GAS  & CONTINENTAL GAS
UK POWER
CONTINENTAL POWER
NORWEGIAN POWER
AUSTRALIAN POWER
JAPAN POWER
J BLOCK
STRUCTURED COMMODITY [NAME] (includes Power & Gas accruals)
ENRON  METALS (Includes Metals Accruals)
CREDIT & DEBT TRADING
TOTAL FINANCIAL INSTRUMENTS |  | [NAME]
COST OF CAPITAL
INFLATION
UK DRIFT
EQUITY INVESTMENTS
TOTAL RETAIL |  | [NAME]
ENRON DIRECT POWER
ENRON DIRECT GAS
EES
Spreadsheet: 1783e531-f31e-4ca0-8c4a-bf494c071793
Sheet: Sheet1

CONTACT:
[NAME]
PA Department of Education
Division of Data Services
333 Market Street
Harrisburg, PA  17126-0333
[NAME]:  [EMAIL]
Phone:  (717) 787-2644
Fax:  (717) 787-3148
Text Telephone TTY:  (717) 783-8445
This workbook contains 2008-09 enrollments for all publicly funded schools in Pennsylvania as reported by school districts, area vocational-technical schools, charter schools, special program jointures, and state-operated educational facilities.  Local education agencies were asked to report those students who were enrolled and attending as of October 1, 2008.
County and Statewide Totals Notes:
Statewide and county totals include counts of students attending education classes on a full-time basis outside their parents' district of residence.  This data was obtained from the Bureau of Special Education (PENNDATA 2008).
CTC Part-day enrollments are excluded from county and state totals.
Statewide and county totals are unique counts of students being educated by public Local Education Agencies.  LEA and School level reports may not sum to the County and Statewide totals.
DEFINITIONS:
[NAME] (EUG) - Full-time elementary nongraded programs including ungraded special education.
PRE-KINDERGARTEN (PK) - A program enrolling students who are up to two years younger than the entrance age for the local education agency's kindergarten program.  PKA represents a PreK Half Day morning (AM) program and PKP represents a PreK Half Day afternoon (PM) program.  PKF is used to indicate a PreK Full Day program.
K4 - The first year of a 2-year kindergarten program.  Students are generally 4 years old at the beginning of the school year.  K4A represents a K4 Half Day morning (AM) program and K4P represents a K4 Half Day afternoon (PM) program.  K4F is used to indicate a K4 Full Day program.
K5 - The second year of a 2-year kindergarten program or the single year of a traditional 1-year kindergarten program.  Students are generally 5 years old at the beginning of the school year.  K5A represents a K5 Half Day morning (AM) program and K5P represents a K5 Half Day afternoon (PM) program.  K5F is used to indicate a K5 Full Day program.
SECONDARY UNGRADED (SUG) - Full-time secondary nongraded programs including ungraded special education.
LEA Type codes are:
COMCTC - Comprehensive CTC
CS - Charter School
OCCCTC - Occupational CTC
SD - School District
SJCI - State Juvenile Correctional Institute
SPJ - Special Program Jointure
STATE - State-Owned School
2009-09-09 00:00:00
Source: Pennsylvania Information Management System (PIMS)
Spreadsheet: larry_campbell__21009__PCB Graphs
Sheet: TOP B6

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Laboratory
PGE B6 |  |  | 1998-12-09 00:00:00 |  |  | 5 |  | Sherwood
Line 300 B Scrubber |  |  | 1999-02-05 00:00:00 |  |  | 17 |  | Sherwood
that [NAME] |  |  | 1999-02-18 00:00:00 |  |  | 10 |  | Sherwood
flows through. |  |  | 1999-04-16 00:00:00 |  |  | 1 |  | Sherwood
 |  |  | 1999-05-27 00:00:00 |  |  | 25 |  | Sherwood
 |  |  | 1999-07-03 00:00:00 |  |  | 101 |  | Sherwood
 |  |  | 1999-07-04 00:00:00 |  |  | 69 |  | Sherwood
 |  |  | 1999-08-31 00:00:00 |  |  | 59 |  | Sherwood
 |  |  | 1999-09-02 00:00:00 |  |  | 71 |  | Sherwood
 |  |  | 1999-09-06 00:00:00 |  |  | 77 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 546730d1510169453-capturing-3-inputs-for-a-glide-path-graph-glide-path
Sheet: Sheet1

Deliverable Name | Baseline Submission Date | Deliverable Total
Deliverable ZY1 | 2017-10-08 00:00:00
Deliverable ZY2 | 2017-10-13 00:00:00
Deliverable ZY3 | 2017-10-13 00:00:00
Deliverable ZY4 | 2017-10-22 00:00:00
Deliverable ZY5 | 2017-10-24 00:00:00
Deliverable ZY6 | 2017-11-19 00:00:00
Deliverable ZY8 | 2017-11-19 00:00:00
Deliverable ZY9 | 2017-11-19 00:00:00
Deliverable ZY10 | 2017-11-19 00:00:00
Deliverable ZY11 | 2017-12-12 00:00:00
Deliverable ZY12 | 2017-12-12 00:00:00
Deliverable ZY13 | 2017-12-12 00:00:00
Deliverable ZY14 | 2017-12-12 00:00:00
Deliverable ZY15 | 2017-12-12 00:00:00
Deliverable ZY16 | 2018-01-08 00:00:00
Deliverable ZY17 | 2018-01-08 00:00:00
Deliverable ZY18 | 2018-01-08 00:00:00
Deliverable ZY19 | 2018-01-08 00:00:00
Deliverable ZY20 | 2018-01-08 00:00:00
Deliverable ZY7 | 2018-01-19 00:00:00
Deliverable ZY21 | 2018-01-20 00:00:00
Spreadsheet: 762389d1641538994-sumif-for-multiple-columns-sumif-bmd4-
Sheet: Sheet4

Code | Key | Amt |  |  | Existing formula (SUM IF only on Col B which gives DR - 300 CR - 300 total) |  |  | Amounts | Key
CO_1234 | DR | 50 |  |  |  |  |  | Code | CR | DR | Grand Total
CO_1234 | CR | 80 |  |  |  |  |  | CO_1234 | 80 | 50 | 130
CO_ABCD | DR | 250 |  |  |  |  |  | CO_ABCD | 220 | 250 | 470
CO_ABCD | CR | 220 |  |  |  |  |  | Grand Total | 300 | 300 | 600
 |  |  |  |  | Expected Result( SUM on Col A for each company code (DR +CR)
 |  |  |  |  | CO_1234 - Total CR-DR = 130
 |  |  |  |  | CO_ABCD - Total CR-DR = 470
Spreadsheet: 76373d1276876433-matching-sheets-matching
Sheet: Customer sales

Customer Name | Start Date | Total Orders | Total Sales Amt | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | First Name | E-Mail | Web URL
2119 Traders, Inc. | 2009-12-11 00:00:00 | 44 | 2632.71 | 156.8 | 942.47 | 429.24 | 297.01 | 516.78 | 290.41 | 0 | 0 | Sandra | [EMAIL]
A Handy Man | 2008-10-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 2009-11-16 00:00:00 | 2 | 703.02 | 465.27 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AAA Electric Motor Sales & Service | 2009-10-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Advanced Sales Technologies | 2008-09-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 2010-01-22 00:00:00 | 92 | 11838.96 | 0 | 0 | 2029.22 | 5407.4 | 2099.46 | 892.27 | 1410.61 | 0
[NAME] | 2010-03-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AlphaSmith | 2009-03-19 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Anton's Home & Hearth Inc | 2009-10-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
arg supply | 2009-12-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Aspen Reflections INC | 2009-01-16 00:00:00 | 15 | 745.8 | 24.98 | 0 | 0 | 0 | 0 | 155.19 | 0 | 0
B & B Inc | 2009-04-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
B&B Inc | 2009-03-12 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME], LLC | 2009-12-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Basic Enterprises LLC | 2009-04-22 00:00:00 | 1 | 109.36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 2009-11-19 00:00:00 | 1 | 410.77 | 410.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BDS Global LLC | 2007-12-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Beaches Fireplace Service Ltd. | 2010-01-11 00:00:00 | 1 | 301.43 | 0 | 0 | 301.43 | 0 | 0 | 0 | 0 | 0
I Need to match all the customer information on sheet 2 starting in Column B over to D to match customer name on customer sales sheet,,,,,see example in M1
Spreadsheet: joe_parks__14595__2-05-02 Gas Cash
Sheet: Log

5 Day Rolling Cash Forecast:  Payment Log
Payment Date | Amount | Deal Name | Counterparty | Commercial Contact | Transaction Description | Cash Request Submitted? | Cash Request Approved? | [NAME]/Funds Receipt Confirmed?
2002-02-05 00:00:00 | -22500 | Other: [NAME] | Reliant? | [NAME]/[NAME] | Prepay for February swing gas of 2,000/d (Wed 2/6 through Sunday 2/10).  Working on GISB related issues with [NAME].  Note: This is revised downward from yesterday's forecast of $25,000.
2002-02-05 00:00:00 | -244.2 | Tennessee IT Transport | Tennessee Gas Pipeline (EPNG) | [NAME] | Payment for IT Transport out of Bear Creek Storage for Tallahassee supply deal.
2002-02-07 00:00:00 | -20000 | Other: [NAME] | Reliant? | [NAME]/[NAME] | Prepay for February swing gas of 2,000/d (Monday 2/11 through Thursday 2/14).  Working on GISB related issues with [NAME].
2002-02-08 00:00:00 | -98000 | [NAME] | Centana | [NAME] | Possible pmt of demand charge.  Still unsure if pmt will be necessary.
Spreadsheet: 847008d1698126348-convert-column-of-dates-to-day-number-of-year-etc-2024datesexample-1-
Sheet: Birthdays-2024

Birthday | Age in 2024 | Day Number of 2024 | Day of Week in 2024
1968-04-10 00:00:00
2007-05-03 00:00:00
2011-04-16 00:00:00
2003-10-25 00:00:00
1984-08-30 00:00:00
1971-10-04 00:00:00
2004-11-11 00:00:00
1950-04-15 00:00:00
1938-01-17 00:00:00
2007-05-03 00:00:00
2011-04-16 00:00:00
1997-03-29 00:00:00
1941-03-04 00:00:00
2006-09-09 00:00:00
2005-09-13 00:00:00
2024-02-14 00:00:00
1971-07-23 00:00:00
1974-09-17 00:00:00
2005-09-13 00:00:00
1954-06-01 00:00:00
[NAME] for columns B, C & D to avoid tedious manual entry?
Spreadsheet: 36268d1234137667-multiple-vlookup-small-if-array-example
Sheet: Sheet1

 |  |  | Helper cell |  |  | 2 | Results
1 | aa | ee | 1 |  | Lookup Value | 1 | ee | this is an array formula, enter by pressing CTRL-SHIFT-ENTER
1 | bb | ff | 1 |  |  |  | ff | Change the value in G2 and it will change the list in H.
2 | aa | gg | 0
2 | bb | hh | 0
Spreadsheet: 750726d1633607887-tracking-product-storage-with-multiple-criteria-edited-storing-products-excel-help-v2
Sheet: Sheet1

STORING
Date | Method | Product | Quantity |  | Location |  | Out of Date
2021-10-05 00:00:00
Insert lines above this line to ensure formula carries through
Spreadsheet: 842024d1694108813-please-help-with-formula-sample
Sheet: Sheet1

IF A7="" THEN E7=0; IF A7="ELIX" THEN E7=0; ELSE E7=1
IF B7="" THEN F7=0; IF B7="ELIX" THEN F7=0; ELSE F7=1
IF C7="" THEN G7=0; IF C7="ELIX" THEN G7=0; ELSE G7=1
IF D7="" THEN H7=0; IF D7="ELIX" THEN H7=0; ELSE H7=1
F-02 | ELIX | F-01 | F-03
 |  |  |  | HD | T
F-02 | ELIX | F-01 | F-03
F-02 | ELIX |  | F-03
Spreadsheet: 721847d1614891859-finding-averages-between-a-date-range-find-avg-between-date-range
Sheet: Sheet1

Period Avg (From newest date, back) |  | 3
Dry Matter |  | 0.918
DM Cost p/t |  | 95.01
Crude Protein |  | 0.191
ADF |  | 0.12
Ash |  | 0.099
TDN |  | 0.746
NE Gain (Mcal/id) |  | 0.56
Starch |  | 0.37
Fat |  | 0.053
Return Feed
 | Date | Price | Dry Matter | DM Cost p/t | Crude Protein | ADF | Ash | TDN | NE Gain (Mcal/id) | Starch | Fat
 | 2019-07-09 00:00:00 | 85 | 0.88 | 96.5909090909091 | 0.195 | 0.122 | 0.1157 | 0.746 | 0.51 | 0.357 | 0.0579
 | 2019-07-23 00:00:00 | 85 | 0.883 | 96.26274065685165 | 0.201 | 0.143 | 0.1211 | 0.715 | 0.47 | 0.357 | 0.049
 | 2019-10-28 00:00:00 | 85 | 0.887 | 95.82863585118376 | 0.199 | 0.125 | 0.1079 | 0.738 | 0.51 | 0.327 | 0.0609
 | 2019-11-07 00:00:00 | 85 | 0.8618 | 98.63077280111395 | 0.196 | 0.133 | 0.099 | 0.747 | 0.52 | 0.352 | 0.0494
 | 2020-08-20 00:00:00 | 85 | 0.906 | 93.81898454746137 | 0.182 | 0.121 | 0.1126 | 0.714 | 0.53 | 0.364 | 0.0495
 | 2020-10-01 00:00:00 | 85 | 0.918 | 92.5925925925926 | 0.196 | 0.106 | 0.0851 | 0.777 | 0.63 | 0.394 | 0.0607
Spreadsheet: 56780d1256864537-replacing-references-in-two-columns-705298-replacing-references-in-two-columns
Sheet: Sheet1

another word | βλ. "some word" | [NAME]
aword | μετάφραση | μετάφραση
bword | βλ. "aword" | μετάφραση
some word | [NAME] | [NAME]
aerodrome traffic circuit | κύκλος (εναέριας) κυκλοφορίας αεροδρομίου | κύκλος (εναέριας) κυκλοφορίας αεροδρομίου
aerodrome traffic pattern | βλ. "aerodrome traffic circuit" | #N/A
air cleaner | βλ. "air filter" | #N/A
air field | αεροδρόμιο | αεροδρόμιο
air filter | φίλτρο αέρος | φίλτρο αέρος
 |  | 0
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 9b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Fixed-Float | 642975 | 290894 | 104795 | 41544 | 5460 | 48119 | 47832 | 1181619
OTHER* | 299210 | 649098 | 39420 | 8492 | 52824 | 13890 | 33275 | 1096209
TOTAL
*OTHER variable includes the following products: Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, Basis, OIS, and FRA.
Spreadsheet: 782823d1654290242-formula-macro-help-needed-please-testing-umbrella-for-publication
Sheet: position 27Jan

 | UMBRELLA POSITIONS 31 Jan 2022
 |  | Top 12  scores | Lowest counting  score
 | Mee,  [NAME] | 206 | 15
 | Shepherd, [NAME] | 202 | 13
 | Singleton,  [NAME] | 202 | 13
 | Peerless,  [NAME] | 201 | 13
 | Sadd,  [NAME] | 184 | 12
 | Singleton,  [NAME] | 185 | 11
 | Gibb,  [NAME] | 172 | 12
 | Peerless,  [NAME] | 170 | 9
 | Shepherd,  [NAME] | 167 | 10
 | Charman,  [NAME] | 164 | 9
 | Mee,  [NAME] | 154 | 4
 | [NAME],  Trevor | 133 | 6
 | Charman,  [NAME]
 | Childs,  [NAME]
 | Hickmott,  [NAME]
 | Scales,  [NAME]
 | Scales,  Nicky
 | Short,  [NAME]
 | [NAME],  Vera
 | Wilmore,  [NAME]
 | Scores only shown for those who have  completed 12 qualifying roll-ups
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  | 18
2 |  |  | 7
3 |  |  | 20
4 |  |  | 27
5 |  |  | 27
6 |  |  | 26
7 |  |  | 25
8 |  |  | 26
9 |  |  | 29
10 |  |  | 32
11 |  |  | 31
12 |  |  | 27
13
14 |  |  | 8
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  |  |  | -13969.77
2001-07-28 00:00:00
Spreadsheet: 106426d1303683117-excel-2007-total-values-in-hierarchy-order-waterfall_results
Sheet: Current_Template

Acct | MISSING A | MISSING B | MISSING C | MISSING C | MISSING C | MISSING C | MISSING D | MISSING E | MISSING F | MISSING F | <===These are my exclusions
1234 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0
3516 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0
89749 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0
96451 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0
9879874 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
561651 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1
9898 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0
9874984 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0
651651 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1
989 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1
Spreadsheet: 165701d1341323159-index-match-two-different-criteria-on-two-worksheets-match-query-example
Sheet: Sheet1

Spreadsheet 1
Product Code | Budget Week | Budget Sales
513TEW06 | 2012-01-07 00:00:00
034TEW06 | 2012-01-14 00:00:00
983WRW06 | 2012-01-28 00:00:00
824JSW04 | 2012-01-07 00:00:00
740WRW06 | 2012-01-14 00:00:00
619CWW04 | 2012-01-28 00:00:00
Spreadsheet 2
Product Code | 2012-01-07 00:00:00 | 2012-01-14 00:00:00 | 2012-01-21 00:00:00 | 2012-01-28 00:00:00 | 2012-02-04 00:00:00 | 2012-02-11 00:00:00 | 2012-02-18 00:00:00 | 2012-02-25 00:00:00
513TEW06 | 100 | 101 | 105 | 201 | 250 | 3500 | 3500 | 200
034TEW06 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 98
983WRW06 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80
824JSW04 | 15 | 20 | 25 | 30 | 25 | 30 | 25 | 30
740WRW06
619CWW04
Spreadsheet: 819906d1677761059-count-range-with-dates-not-working-copy
Sheet: SUMMARY

 | SUMMARY
 | Any date range | From | 2023-02-28 00:00:00 | To | 2023-02-28 00:00:00
 | Name | TOTAL ID COUNT | Date AET to do dropped
 | ACTON
 | EALING
 | FULHAM
 | HARLESDEN
 | HARROW
 | HAYES
 | HOUNSLOW
 | KINGSTON
 | SHEPHERDSBUSH
 | TWICKENHAM
 | UXBRIDGE
 | WANDSWORTH
 | WEMBLEY
 | TOTAL
Spreadsheet: 833376d1686924878-formulas-to-calculate-min-max-average-and-position-1st-4th-daily-scores-v2
Sheet: Scores

 |  | Date | 01/01/2023 | 02/01/2023 | 03/01/2023 | 04/01/2023 | 05/01/2023 | 06/01/2023 | 07/01/2023
 |  | [NAME] | 20 | 20 | 20 | 30
 |  | [NAME] | 30 | 20 | 20 | 30
 |  | Maria | 40 | 30 | 20 | 30
 |  | [NAME] | 50 | 40 | 30 | 30
 |  | Position
 |  | [NAME]
 |  | [NAME]
 |  | Maria
 |  | [NAME]
 |  | Average
 |  | [NAME]
 |  | [NAME]
 |  | Maria
 |  | [NAME]
 |  | Min/Max | Minimum | Maximum
 |  | [NAME]
 |  | [NAME]
 |  | Maria
 |  | [NAME]
 |  | Positions | 1st | 2nd | 3rd | 4th
 |  | [NAME]
 |  | [NAME]
 |  | Maria
 |  | [NAME]
Spreadsheet: 123853d1317903560-linking-pages-sample
Sheet: offre

OFFRE
Numéro d'offre :
Redigee par
Demandeur
Objet:
Specification CERN
Item | Code | Désignation | U | PUF | PUP | PU HT | Qté | PT HT
- Identification tableau:
- Création départ:
- Marque identifié dans le tableau:
-disponibilité dans l'armoire
- Autre:
 |  | Total général devis
 |  | Total
 |  | TOTAL DEVIS HT
Spreadsheet: 807888d1670134853-calling-data-from-main-sheet-g6-ver-256
Sheet: 5 BEST AND WEK STUDENTS

E. FIVE BEST STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On the basis of total marks
F. FIVE WEAK STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: 184309d1349206348-grouping-in-weeks-groupings
Sheet: Sheet1

REF NO | Date Completed | Comments
5011 | 2012-09-05 00:00:00 | periodic data
5012 | 2012-09-06 00:00:00
5013 | 2012-09-06 00:00:00
5014 | 2012-09-06 00:00:00
5015 | 2012-09-07 00:00:00
5016 | 2012-09-09 00:00:00 | periodic data
5017 | 2012-09-15 00:00:00 | periodic data
5018 | 2012-09-15 00:00:00 | periodic data
5019 | 2012-09-16 00:00:00 | periodic data
5020 | 2012-09-18 00:00:00
5021 | 2012-09-18 00:00:00
5022 | 2012-09-18 00:00:00 | weekly data
5023 | 2012-09-18 00:00:00
5024 | 2012-09-19 00:00:00
5025 | 2012-09-19 00:00:00 | monthly data
5026 | 2012-09-19 00:00:00
5027 | 2012-09-20 00:00:00
5028 | 2012-09-22 00:00:00
5029 | 2012-09-22 00:00:00
5030 | 2012-09-23 00:00:00 | monthly data
5031 | 2012-09-23 00:00:00 | monthly data
5032 | 2012-09-24 00:00:00 | monthly data
5033 | 2012-09-24 00:00:00 | monthly data
5034 | 2012-09-25 00:00:00 | monthly data
5035 | 2012-09-30 00:00:00
5036 | 2012-10-02 00:00:00 | inconsistant data
5037 | 2012-10-02 00:00:00 | changing data
5038 | 2012-10-05 00:00:00 | incorrect data
5039 | 2012-10-05 00:00:00 | data values
5040 | 2012-10-15 00:00:00 | please delete data
5041 | 2010-12-15 00:00:00
Spreadsheet: 827509d1682763668-similar-to-filter-command-on-excel-2019-pq-similar-to-filter-command-1-aligw
Sheet: Φύλλο1

 |  |  |  |  |  |  | Column1 | Column2 | DESCRIPTIONS | AMOUNT |  |  | DESCRIPTIONS | AMOUNT
 |  |  |  |  |  |  | 1 | True | FLOOR | 2500 |  |  | FLOOR | 2500
 |  |  |  |  |  |  | 2 | False | S1 |  |  |  | SS1 | 15
 |  |  |  |  |  |  | 3 | True | SS1 | 15 |  |  | FOS | 1200
 |  |  |  |  |  |  | 4 | True | FOS | 1200 |  |  | YF2 | 800
 |  |  |  |  |  |  | 5 | False | YF1 |  |  |  | INK | 1500
 |  |  |  |  |  |  | 6 | True | YF2 | 800 |  |  | NITO | 300
 |  |  |  |  |  |  | 7 |  | YF3 |  |  |  | PET | 2000
 |  |  |  |  |  |  | 8 | True | INK | 1500 |  |  | ROLLAN | 500
 |  |  |  |  |  |  | 9 | True | NITO | 300 |  |  | SKAF | 300
 |  |  |  |  |  |  | 10 | False | MAPSM |  |  |  | PROTE | 200
 |  |  |  |  |  |  | 11 | True | PET | 2000
 |  |  |  |  |  |  | 12 | False | FOSPET
 |  |  |  |  |  |  | 13 | False | REP
 |  |  |  |  |  |  | 14 | False | A
 |  |  |  |  |  |  | 15 | True | ROLLAN | 500
 |  |  |  |  |  |  | 16 | True | SKAF | 300
 |  |  |  |  |  |  | 17 | True | PROTE | 200