tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 53806d1253731381-removing-an-added-space-leading-space
Sheet: Sheet1

This is what is printed out, with leading space |  |  | [NAME] doesn't work |  | With leading space manually removed |  |  | [NAME] works |  | .
Date | IN | OUT |  |  | Date | IN | OUT
2009-07-20 00:00:00 | 05:44:30 | 14:25:13 | #N/A |  | 2009-07-20 00:00:00 | 05:44:30 | 14:25:13 | 8.67861111111111
2009-07-21 00:00:00 | [NAME] | 14:23:18 |  |  | 2009-07-21 00:00:00 | 05:42:07 | 14:23:18 | 8.686388888888889
2009-07-22 00:00:00 | 05:44:01 | 14:26:19 |  |  | 2009-07-22 00:00:00 | 05:44:01 | 14:26:19 | 8.704999999999998
2009-07-23 00:00:00 | 05:49:22 | 14:20:53 |  |  | 2009-07-23 00:00:00 | 05:49:22 | 14:20:53 | 8.525277777777777
2009-07-24 00:00:00 | 05:43:53 | 14:24:58 |  |  | 2009-07-24 00:00:00 | 05:43:53 | 14:24:58 | 8.684722222222222
2009-07-25 00:00:00 | 06:43:08 | 11:42:56 |  |  | 2009-07-25 00:00:00 | 06:43:08 | 11:42:56 | 4.996666666666667
2009-07-26 00:00:00
2009-07-27 00:00:00 | 05:41:52 | 14:18:47
2009-07-28 00:00:00 | 05:42:03 | 14:22:38
2009-07-29 00:00:00 | 05:42:38 | 14:36:37
2009-07-30 00:00:00 | [NAME] | 14:25:55
2009-07-31 00:00:00 | 05:39:58 | 14:00:04
2009-08-01 00:00:00
2009-08-02 00:00:00
2009-08-03 00:00:00 | 05:45:44 | 14:18:29
2009-08-04 00:00:00 | [NAME] | 14:21:12
2009-08-05 00:00:00 | 05:43:30 | 14:23:49
2009-08-06 00:00:00 | 05:44:14 | 14:21:27
2009-08-07 00:00:00 | 05:44:45 | 14:22:10
2009-08-08 00:00:00 | 06:41:27 | 10:38:35
2009-08-09 00:00:00 | 08:44:09 | 11:44:28
2009-08-10 00:00:00 | [NAME] | 14:27:49
2009-08-11 00:00:00 | 05:43:44 | 14:20:13
2009-08-12 00:00:00 | 05:42:09 | 14:21:19
2009-08-13 00:00:00 | 05:44:22 | 14:26:09
2009-08-14 00:00:00 | 05:44:17 | [NAME]
2009-08-15 00:00:00
2009-08-16 00:00:00
2009-08-17 00:00:00 | 04:53:40 | 11:10:17
2009-08-18 00:00:00 | [NAME] | 14:25:26
2009-08-19 00:00:00 | [NAME] | 14:21:48
2009-08-20 00:00:00 | 05:45:16 | 14:27:45
2009-08-21 00:00:00 | 05:45:49 | [NAME]
2009-08-22 00:00:00
2009-08-23 00:00:00
2009-08-24 00:00:00 | 05:38:45 | 14:20:54
2009-08-25 00:00:00 | 05:40:22 | 14:30:08
2009-08-26 00:00:00 | 05:43:40 | 15:02:59
2009-08-27 00:00:00 | [NAME] | 14:59:38
2009-08-28 00:00:00 | 05:41:41 | 14:19:52
2009-08-29 00:00:00 | [NAME] | 14:19:38
2009-08-30 00:00:00
2009-08-31 00:00:00 | 05:43:25 | 14:28:30
2009-09-01 00:00:00 | 05:42:02 | 14:16:23
2009-09-02 00:00:00 | 05:43:40 | 06:07:35
2009-09-03 00:00:00 | 05:52:26 | 14:25:50
2009-09-04 00:00:00 | 05:47:00 | [NAME]
2009-09-05 00:00:00
2009-09-06 00:00:00
2009-09-07 00:00:00
2009-09-08 00:00:00 | 05:39:12 | 14:17:49
2009-09-09 00:00:00 | [NAME] | 16:07:16
2009-09-10 00:00:00 | 05:47:22 | 14:19:23
2009-09-11 00:00:00 | 05:45:39 | 14:05:58
2009-09-12 00:00:00
2009-09-13 00:00:00
2009-09-14 00:00:00 | 05:44:14 | 14:18:36
2009-09-15 00:00:00 | [NAME] | 14:23:38
2009-09-16 00:00:00 | 05:47:00 | [NAME]
2009-09-17 00:00:00 | [NAME] | 14:17:20
2009-09-18 00:00:00 | 05:44:21 | 14:18:46
Spreadsheet: 888143d1738587022-extract-multiple-employee-id-based-on-project-name-from-one-sheet-to-another-using-formula-sample_repivot_data
Sheet: Step-by-Step

Pivot by Instance Number and Sort by Project-ID:
ID | Project | Names |  |  |  |  | 6
 | Project-1 | Name-1 | Name-3 | Name-6 |  |  |  |  | =LET(
2 | Project-2 | Name-1 | [NAME] | Name-5 |  |  | Step |  | fnλ, LAMBDA(n,TOCOL(IFS(Data!C2:AIN142<>"",IF(n,Data!B2:B142,Data!C2:AIN142)),2)),
3 | Project-3 | Name-1 | Name-3 |  |  |  |  | → | arr, SORT(HSTACK(fnλ(0),fnλ(1))),
4 | Project-4 | Name-4 |  |  |  |  | 2 | → | key, TAKE(arr,,1),
5 | Project-5 | [NAME] | Name-4 | Name-5 |  |  | 3 | → | rId, VALUE(TEXTAFTER(key,"-")),
6 | Project-6 | Name-4 | Name-6 |  |  |  | 4 | → | cId, SCAN(0,key=VSTACK("",DROP(key,-1)),LAMBDA(a,[NAME])),
8 | Project-8 | Name-6 |  |  |  |  | 5 | → | val, DROP(arr,,1),
9 | Project-9 | Name-3 | Name-6 |  |  |  | 6 | → | DROP(PIVOTBY(HSTACK(rId,key),cId,val,SINGLE,0,0,,0),1)
10 | Project-10 | [NAME] | Name-3 | Name-4 | Name-5 |  |  |  | )
11 | Project-11 | [NAME] | Name-5
12 | Project-12 | Name-7 | Name-8
13 | Project-13 | Name-8
Spreadsheet: 885950d1735888469-create-multiple-vertical-lines-programmatically-from-single-cell-mcmxd-sample-workbook-error-spill-365-aligw
Sheet: Roster

Start Date | 2024-02-03 00:00:00
 | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5
Staff Name | Days (Wed off) | Days ([NAME] off) | RLEAVE | RLEAVE | RLEAVE | WEEKDAY EVENING | WEEKEND DAYS 10 | DAYS (Tue Off) | WEEKEND DAYS 10 | DAYS (Tue Off)
 | Days (Wed off) | Days ([NAME] off) |  |  |  | WDE1 | WED10 | Days (Tue off) | WED10 | Days (Tue off)
Spreadsheet: 734592d1622258046-standard-deviation-question-std-dev
Sheet: Sheet1

data | z-score
1 |  |  | mean
2 |  |  | std dev
3
4
5
6
7
8
9
10
Spreadsheet: 857229d1706255006-countif-with-tabular-data-sjpeters75-sumproduct-aligw
Sheet: Sheet1

DATA
Student | TA | Test 1 | Test 2 | Test 3
[NAME] | [NAME] | A | A | B
[NAME] | [NAME] | B | C | B
[NAME] | [NAME] | C | C | B
Ellen | [NAME] | B | A | C
[NAME] | [NAME] | A | B | B
RESULT 1
Student | A | B | C
[NAME]
[NAME]
[NAME]
[NAME]
Ellen
RESULT 2
TA | A | B | C
[NAME]
[NAME]
Spreadsheet: 134561d1325452919-paying-daily-bonus-book1
Sheet: Weekly Paid

Monday 2nd January, 2012
Name | Start | Finish | Hours | Rate | Wage | Bonus | Total
j [NAME] | 9 | 5 | 7.5 | 8
P Bell | 9 | 5 | 7.5 | 8
D bury | 9 | 5 | 7.5 | 8
H Hill | 9 | 5 | 7.5 | 8
S Lime | 9 | 5 | 7.5 | 8
Monday 2nd January, 2012
 | Start | Finish | Hours | Rate | Wage
j [NAME] | 9 | 5 | 7.5 | 8
P Bell | 9 | 5 | 7.5 | 8
D bury | 9 | 5 | 7.5 | 8
H Hill | 9 | 5 | 7.5 | 8
S Lime | 9 | 5 | 7.5 | 8
Monday 2nd January, 2012
 | Start | Finish | Hours | Rate | Wage
j [NAME] | 9 | 5 | 7.5 | 8
P Bell | 9 | 5 | 7.5 | 8
D bury | 9 | 5 | 7.5 | 8
H Hill | 9 | 5 | 7.5 | 8
S Lime | 9 | 5 | 7.5 | 8
Monday 2nd January, 2012
 | Start | Finish | Hours | Rate | Wage
j [NAME] | 9 | 5 | 7.5 | 8
P Bell | 9 | 5 | 7.5 | 8
D bury | 9 | 5 | 7.5 | 8
H Hill | 9 | 5 | 7.5 | 8
S Lime | 9 | 5 | 7.5 | 8
Monday 2nd January, 2012
 | Start | Finish | Hours | Rate | Wage
j [NAME] | 9 | 5 | 7.5 | 8
P Bell | 9 | 5 | 7.5 | 8
D bury | 9 | 5 | 7.5 | 8
H Hill | 9 | 5 | 7.5 | 8
S Lime | 9 | 5 | 7.5 | 8
Spreadsheet: 0958776b-c1fa-49b6-9d31-9a04e522803f
Sheet: econ with fed grant

 | Appendix 1
 | Year | 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
 | [NAME] (Kw) DC: | 148 |  | Loan Duration (years): | 10 |  | Loan interest rate: | 0.05 |  |  |  |  | Basis - Fed. Dep (95% of cost):
 | [NAME] (Kw) AC: | 127.428 | Fed [NAME] | 0.25 |  |  | Rebate rate: | 0 |  | 4.954914067313133 | CEC hrs of sun
 | Total System Cost: |  | Federal Grant: |  |  |  | PBI rate: | 0.09 |  |  |  |  | Yr. 1 Fed Dep. %: | 0.2 |  | Yr. 4 Fed Dep. %: | 0.1152
 | Rebate amount: |  |  | Fed tax rate: | 0.34 |  | year 1 price per kw: | 0.166 |  | Basis - State Dep: |  |  | Yr. 2 Fed Dep. %: | 0.32 |  | Yr. 5 Fed Dep. %: | 0.1152
 | Net cost post rebate & grant: |  |  | State tax rate: | 0.095 |  | % inc. $ per kw/year: | 0.08 |  |  |  |  | Yr. 3 Fed Dep. %: | 0.192 |  | Yr. 6 Fed Dep. %: | 0.0576
 | loan amount: |  |  | Do you want to finance? | no
 | mo. Cost
1 | year cost
 | yearly loan interest
2 | interst tax savings
3 | Federal Tax Credit
4 | PBI
5 | [NAME] | 0 | 0 | 0 | 0 | 0
6 | Increased Fed Tax
7 | Increased State Tax
8 | FED Dep
9 | State Dep
10 | Increased Fed Tax
 | price per kw
11 | Avoided SDG&E energy
12 | Increased State Tax
13 | Increased Fed Tax
14 | totals
15 | Net
 | Notes:
 | Line 4 | Performance based incentive
 | Line 5 | Possible future sale of carbon credits (not instituted at this time)
 | Line 6 | Increase fed taxes due to sale of carbon credits
 | Line 7 | Increase state taxes due to sale of carbon credits
 | Line 10 | Fed Taxes increase due to state depreciation savings reducing overall state taxes
 | Line 12 | State Taxes increase due to loss of avoided energy cost
 | Line 13 | Fed Taxes increase due to loss of avoided energy cost and decrease by
 |  | state tax increase due to the same.
Spreadsheet: 137380d1327082596-data-dragging-data-1
Sheet: Sheet1

date | name | sg count | tc count
27-12-11 | aaa
27-12-11 | bbb
27-12-11 | [NAME]
27-12-11 | ddd
27-12-11 | eee
27-12-11 | [NAME]
Spreadsheet: 9791f31a-8cf5-4e68-8bd8-ae766b251cae
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSTBG | Test | FSTBG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FSTBG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FSTBG | Result | FSTBG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 109724d1306501121-excel-2007-specific-date-compared-to-date-range-fed-calc-v3
Sheet: Year 4

 | Case Number |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 | YEAR 4:
 |  | Amount Due |  |  |  |  |  | Charging
 |  |  |  |  |  |  |  | Order
Month |  | ORDER 1 | ORDER 2 | ORDER 3 | ORDER 4 | ORDER 5 |  | Amount
37 | January
38 | February
39 | March
40 | April
41 | May
42 | June
43 | July
44 | August
45 | September
46 | October
47 | November
48 | December
 | Support Due
 | Support Paid
 | [NAME]
 | Accrued Arrearage
 | Last Year Carryover
 | Lump/TANF
 | This Year
 | Total
 | Interest Rate
 | Arrears Interest
 | Fees Due
 | Fees Paid
 | Fees Owed
Spreadsheet: 29691d1224771539-sort-w-data-validation-data-validation-does-not-move
Sheet: Sheet1

Type of thing | Supplier | . | Supplier code | Cost - Each | Quantity | Total cost | Department
Thing 3 | Choose a supplier | . |  |  |  |  | Big thingies
Thing 4 | Choose a supplier | . |  |  |  |  | Big thingies
Thing 5 | Choose a supplier | . |  |  |  |  | Big thingies
Thing 1 | Choose a supplier | . |  |  |  |  | Small thingies
Thing 2 | Choose a supplier | . |  |  |  |  | Small thingies
Spreadsheet: 42063d1240596157-conditional-format-what-if-question-2007-target-techs
Sheet: a

target employees |  |  |  |  |  | all employees
ASMO011034 |  |  |  |  |  | ASMO011031
ASMO011019 |  |  |  |  |  | ASMO011524
ASMO011035 |  |  |  |  |  | ASMO011031
ASMO011030 |  |  |  |  |  | ASMO011526
ASMO004063 |  |  |  |  |  | ASMO004060
ASMO011019 |  |  |  |  |  | ASMO004718
ASMO004134 |  |  |  |  |  | ASMO011007 | <-----bad employee cell highlighted
ASMO004039 |  |  |  |  |  | ASMO011517
ASMO004134 |  |  |  |  |  | ASMO004026
ASMO011007 | <-----bad employee found |  |  |  |  | ASMO011007 | <-----bad employee cell highlighted
ASMO011030 |  |  |  |  |  | ASMO011517
ASMO004063 |  |  |  |  |  | ASMO011027
ASMO004039 |  |  |  |  |  | ASMO011027
ASMO011033 |  |  |  |  |  | ASMO011526
ASMO011033 |  |  |  |  |  | ASMO011039
ASMO011035 |  |  |  |  |  | ASMO004026
ASMO004048 |  |  |  |  |  | ASMO011039
 |  |  |  |  |  | ASMO004125
 |  |  |  |  |  | ASMO011029
"bad employees" in column A and need to see if in list |  |  |  |  |  | ASMO004125
in column G.  If the bad employee is in G column - Highlight |  |  |  |  |  | ASMO004721
cell red |  |  |  |  |  | ASMO011007 | <-----bad employee cell highlighted
Spreadsheet: 488590d1478723748-counting-of-dates-mini-macro-tracker
Sheet: Jan Data

January | Task 60 |  | Task 325 | Task 327 | Task 329 |  | Task 398 | Task 500 EC | Task 619 2500 | Task 627 800
 | Candidate selection | RFDS | Permit | CLLI Submitted | CLLI Complete | CIQ Complete | AZP | Construction Estimation | 2500 OA | 800 OA
Chicago | 14 |  | 14 | 14 |  |  | 2 | 14
Cleveland | 2 |  | 2 | 2 |  |  |  | 2
Indianapolis | 1 |  | 1 | 1 |  |  |  | 1
Kansas | 5 |  | 5 | 5 |  |  |  | 5
Milwaukee | 1 |  | 1 | 1 |  |  |  | 1
Missouri | 5 |  | 5 | 5 |  |  |  | 5
Grand Total
Row Labels | Count of SR_T60_PCAND_APPV_AC | Count of TASK_325_PERMITS_APPROVED_AC | Count of TASK_398_AZP_COMPLETE_AC | Count of TASK_500_3G_CNSTRCTN_CMPLT_EC | Count of TASK_619_2500MHZ_OA_COM_SVC_AC | Count of TASK_627_4G_800_ON_AIR_AC
Chicago | 14 | 14 | 2 | 14
Cleveland | 2 | 2 |  | 2
Indianapolis | 1 | 1 |  | 1
Kansas | 5 | 5 |  | 5
Milwaukee | 1 | 1 |  | 1
Missouri | 5 | 5 |  | 5
Grand Total | 28 | 28 | 2 | 28
Spreadsheet: 119023d1314140579-adding-business-hours-book1-amended
Sheet: Sheet3

Date | Adj Start Date | End Date
2011-08-19 19:30:00 |  |  |  |  | Start | 07:00:00 |  | <---- | Adjust to suit
2011-08-19 06:30:00 |  |  |  |  | End | 19:00:00 |  | <---- | Overnight shifts not allowed
2011-08-19 10:30:00 |  |  |  |  | Hours to add | 26 |  | <----
2011-08-20 05:30:00
2011-08-21 10:30:00 |  |  |  |  | Hours per day
2011-08-21 17:30:00 |  |  |  |  | Whole Days to add
2011-08-22 06:55:00 |  |  |  |  | Time To Add
2011-08-22 18:00:00
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: summary

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES
Positive = due [NAME]
Negative = due operator |  |  |  |  |  |  |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | AVG
NNG |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  |  |  |  | NTXPH
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
[NAME] |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | being reconciled with CIG
Burlington |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
PG&E TX/EPFS |  |  |  | Dollar Valued | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Receivable imbalances
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
SoCal |  |  |  | Volumetric | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 731539d1620395754-highlight-date-range-on-calendar-data
Sheet: 309 Calendar

 | 2020 | NOVEMBER |  | MONDAY |  | 3099 Issue [NAME]
 | CALENDAR YEAR | CALENDAR MONTH |  | FIRST DAY OF WEEK
 |  | 44131 | 44132 | 44133 | 44134 | 44135 | 44136
 |  | 2020-10-27 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-01 00:00:00
 |  | 2020-11-03 00:00:00 | 2020-11-04 00:00:00 | 2020-11-05 00:00:00 | 2020-11-06 00:00:00 | 2020-11-07 00:00:00 | 2020-11-08 00:00:00
 |  | 2020-11-10 00:00:00 | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00 | 2020-11-14 00:00:00 | 2020-11-15 00:00:00
 |  | 2020-11-17 00:00:00 | 2020-11-18 00:00:00 | 2020-11-19 00:00:00 | 2020-11-20 00:00:00 | 2020-11-21 00:00:00 | 2020-11-22 00:00:00
 |  | 2020-11-24 00:00:00 | 2020-11-25 00:00:00 | 2020-11-26 00:00:00 | 2020-11-27 00:00:00 | 2020-11-28 00:00:00 | 2020-11-29 00:00:00
 |  | 2020-12-01 00:00:00 | 2020-12-02 00:00:00 | 2020-12-03 00:00:00 | 2020-12-04 00:00:00 | 2020-12-05 00:00:00 | 2020-12-06 00:00:00
Spreadsheet: jeff_dasovich__14047__timbdcf--question3
Sheet: Income Statement

Timberland Co.
Income Statements ($000's)
 | Actual | Actual | Assumptions | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
FISCAL YEAR ENDING | 1991 | 1992
Net Sales | 226082 | 291368 | year-to-year growth
yr.-to-yr. growth rate |  |  |  | 0.45 | 0.5 | 0.4 | 0.3 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2
Cost of Goods Sold | 146290 | 183510 | % of Sales
% of Sales |  |  |  | 0.62 | 0.62 | 0.62 | 0.62 | 0.62 | 0.62 | 0.62 | 0.62 | 0.62 | 0.62
Gross Income
Selling, Gen & Admin Exp. | 61713 | 81339 | % of Sales
% of Sales |  |  |  | 0.26 | 0.26 | 0.26 | 0.26 | 0.26 | 0.26 | 0.26 | 0.26 | 0.26 | 0.26
Operating Income
Non-Operating Income (Expense) | -540 | -1992 | -0.003
EBIT
Interest Expense | 5822 | 5528 | 0.094
Pretax Income
Income Tax | 3632 | 6080 | 0.32
NET INCOME
Shares Outstanding |  |  |  | 11241 | 11241
Earnings Per Share (EPS)
Spreadsheet: 128588d1321070102-pivot-table-compare-and-display-value-that-is-repeated-example
Sheet: Sheet1

 | TABLE 'A'
 | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 | 2011-11-06 00:00:00 | 2011-11-07 00:00:00
 | 10001 | 10001 | 10001 | 10004 | 10002 | 10004 | 10001
 | 10002 | 10002 | 10002 | 10006 | 10003 |  | 10002
 | 10003 | 10003 | 10003 |  | 10004 |  | 10003
 | 10004 | 10004 | 10004 |  | 10006 |  | 10004
 | 10005 | 10006 |  |  |  |  | 10006
 | 10006
 | 10007
 | 10008
 | TABLE 'B'
 | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 | 2011-11-06 00:00:00 | 2011-11-07 00:00:00 | Total
10001 | 1 | 1 | 1 |  |  |  | 1 | 4
10002 | 1 | 1 | 1 |  | 1 |  | 1 | 5
10003 | 1 | 1 | 1 |  | 1 |  | 1 | 5
10004 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7
10006 | 1 | 1 |  | 1 | 1 |  | 1 | 5
Spreadsheet: 19141124-9a18-48d3-b75c-91a2febddc3d
Sheet: Index 3 Closing the Gap

Warning!  Type only in the white cells!
Reports for Economically Disadvantaged English results: | Use Pinnacle.   For English results only:  Special Pops Tab -->Selection Master:  Special population=Choose all then unclick LEP; Not LEP will appear in Current Selections -->STAAR tab --> Standard Selections: Enrollment Status =Active and [NAME]=Active -->Selection Master-Test Language= English-->Select Analysis=Summary by Special Pop
Reports for Lowest Performing Ethnicities: | Use Pinnacle.   STAAR tab --> Standard Selections: Enrollment Status =Active and [NAME]=Active and Ethnicity=Hispanic for campuses -->Select Analysis=Summary by Assessment
5th and 8th grade when retest results are available-  Use selections above with the exception in Select Analysis: Choose HIGHEST Test Result
Excluded Results: | o ONLY LEP students tested on English Assessments  o Asylees/refugees in US Schools Years 1, 2, 3, 4, 5
Minimum size: | 25 students.  For 2013 the only ethnicity to meet the minimum size requirement is Hispanic; however, the district meet the Hispanic and African American Ethnicity/Race minimum size requirements.
 | Economically Disadvantaged |  |  | Lowest Performing Ethnicity Group 1
 | # of Tests | # Met Level II | [NAME] | # of Tests | # Met Level II | [NAME]
6th Grade Reading
7th Grade Reading
8th [NAME]
6th Grade Math
7th Grade Math
8th [NAME]
7th [NAME]
8th Grade Science
8th Grade Social Studies
 | Economically Disadvantaged |  |  | Lowest Performing Ethnicity Group 1 |  |  | Total Points | Maximum Points 200  each for  two sub pops OR 300 for three sub pops
 | # of Tests | # Met Level II | [NAME] | # of Tests | # Met Level II | [NAME]
Reading |  |  |  |  |  |  |  | 200
Math |  |  |  |  |  |  |  | 200
Writing |  |  |  |  |  |  |  | 200
Social Studies |  |  |  |  |  |  |  | 200
Science |  |  |  |  |  |  |  | 200
Total
Index Score
Spreadsheet: e9fa9f1a-73e6-4f0d-a712-a4dac04575bf
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Technical Services | 1 | Objective 1 | None | -- Pick One --
Technical Services | 1 | Objective 1 | None | -- Pick One -- | 2.1.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 2 | Objective 2 | None | -- Pick One -- | 2.2.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 3 | Objective 3 | None | -- Pick One -- | 2.3.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 5 | Objective 4 | None | -- Pick One -- | 2.4.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 1 | Objective 1 | None | -- Pick One -- | 3.1.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technical Services | 2 | Objective 2 | None | -- Pick One --
Technical Services | 3 | Objective 3 | None | -- Pick One -- | 3.3.r1 | Resource Request | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0