tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b90a527e-b58b-4c5e-8b4f-96c75d7674bd
Sheet: Other Assessments

Instrument Name:
Vendor:
Purpose:
Content Area and Student Population:
Frequency:
Alignment:
BEGIN ENTERING DATA BELOW
Number of Students in October Count:
Number of Students Tested:
Note: Below is a SAMPLE template for an "other" assessment. Modify the form as to what best suits your assessment keeping in mind [NAME] and Growth must be reported.
 | READING
 | FALL Scores |  |  | Spring  Scores |  |  | Score Growth (Fall to Spring)
Grade | # of Students | Mean Score (Starting Score) | 50th Percentile Score (Min. Goal) | # of Students | Mean  Score (Final  Score) | 50th Percentile Score (Min. Goal) | Fall  Score | Spring  Score | Score Gain | 50th Percentile Gain (Min. Gain)
K
1
2
3
4
5
6
7
8
9
10
11
12
 | WRITING
 | FALL  Scores |  |  | Spring  Scores |  |  | Score Growth (Fall to Spring)
 | # of Students | Mean  Score (Starting  Score) | 50th Percentile Score (Min. Goal) | # of Students | Mean  Score (Final  Score) | 50th Percentile Score (Min. Goal) | Fall  Score | Spring  Score | Score Gain | 50th Percentile Gain (Min. Gain)
 | MATHEMATICS
 | FALL  Scores |  |  | Spring  Scores |  |  | Score Growth (Fall to Spring)
 | # of Students | Mean  Score (Starting  Score) | 50th Percentile Score (Min. Goal) | # of Students | Mean  Score (Final  Score) | 50th Percentile Score (Min. Goal) | Fall  Score | Spring  Score | Score Gain | 50th Percentile Gain (Min. Gain)
 | SCIENCE
 | FALL  Scores |  |  | Spring  Scores |  |  | Score Growth (Fall to Spring)
 | # of Students | Mean  Score (Starting  Score) | 50th Percentile Score (Min. Goal) | # of Students | Mean  Score (Final  Score) | 50th Percentile Score (Min. Goal) | Fall  Score | Spring  Score | Score Gain | 50th Percentile Gain (Min. Gain)
 | SOCIAL STUDIES
 | FALL  Scores |  |  | Spring  Scores |  |  | Score Growth (Fall to Spring)
 | # of Students | Mean  Score (Starting  Score) | 50th Percentile Score (Min. Goal) | # of Students | Mean  Score (Final  Score) | 50th Percentile Score (Min. Goal) | Fall  Score | Spring  Score | Score Gain | 50th Percentile Gain (Min. Gain)
Spreadsheet: 62320d1263297234-if-with-vlookup-customer_management_list1
Sheet: Customers

Bank Account | 2352034 | Sort Code | 80 63 09 | [NAME] | 17.5%
Company Name | Address Line 1 | [NAME] | Country | Town | Postcode | [NAME] out | Apprentice Charge out | Material Mark up | Plant mark up | Payment TERMS | Mileage Charge | Contact Title | Fax Number | E-Mail Address | Notes
J & E shepherd | 13 [NAME] | Dundee | a | a | DD1 | 30 | 16 | 25 | 10 | 30 | 0.3 | [NAME]
Graham & Sibbald | market | gsdfgd | green | rich | ph10 6ux | 31 | 17 | 26 | 11 | 2 | 0.3 | [NAME]
EP Engineering | tannadice | adgf | tanna | [NAME] | gdagas | 32 | 18 | 27 | 12 | 3 | 0.3 | [NAME]
Spreadsheet: debra_perlingiere__8462__Sandia- WMBE through ENA
Sheet: AMASTPSA 

WMBE MASTER FIRM PURCHASE/SALE AGREEMENT WORKSHEET
ECT Entity: | ENA | ATTORNEY:
DATE: | 2000-08-28 00:00:00 | ECT CONTACT:
COUNTERPARTY: | Sandia Resources Corporation | CONTACT: | [NAME]
ADDRESS: | 4600 [NAME]. 700 | TITLE:
 | Denver, CO 80237 | PHONE: | [PHONE]
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING: | N/A
STRUCTURE | COUNTERPARTY | ENA
COLLATERAL
THRESHOLD  in $ | 0 | N/A
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES | N/A | N/A
OTHER
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | N/A | N/A
GUARANTOR (RATING)
LIMIT in $[NAME] | N/A | N/A
Incorporation State:
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor
Debt Ratings Change |  | X | Tied to Enron Corp.
-Below = S&P |  | BBB- | S&P
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral | X
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty
-Guarantor ($[NAME])
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:  X
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:   X | NO:
OTHER COMMENTS:  Standard WMBE Contract.  Third party documentation required for all
trades.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x-57749
Spreadsheet: 53362d1253241210-excel-filtering-reva-template12
Sheet: Summary

 | SCHOOL OF CHEMICAL & LIFE SCIENCES (LIFE SCIENCES)
 |  |  | Make a new submission click here! | Go back to Instructions!
 | Final Year Project Proposal Submission for 2009/10 Sem 2
 | Project | Title | Supervisor | Category
 | Project 1 | Sample Project # 1 | [NAME] | FS
 | Project 2 | Sample Project # 2 | [NAME] | MB
 | Project 3 | Sample Project # 3 | [NAME] | PS
 | Project 4 | Sample Project # 4 | [NAME] | PS
 | Project 5 | Sample Project # 5 | [NAME] | FS
 | Project 6 | Sample Project # 6 | [NAME] | MB
 | Project 7 | Sample Project # 7 | [NAME] | FS
 | Approval :
 |  | ______________________________________________________________
 |  | D(LS)/SCL. Date
Spreadsheet: 32031d1228152513-how-do-i-write-formula-to-show-a-profit-margin-profitmargins
Sheet: Sheet1

Item Description | Net cost | Pack size | Net cost | vat 15% | gross | Sales Price | Profit | 2Pk | 2Pk Profit | 3Pk | 3Pk Profit | 4Pk | 4Pk Profit | 6Pk | 6Pk Profit | 8Pk | 8Pk Profit
[NAME] | 14.94 | 6 | 2.49 | 0.3734999999999999 | 2.86 | 4.5 | 1.64 | 8.99 | 3.27 | 12.99 | 4.41 | 16.99 | 5.549999999999999 | 24.99 | 7.829999999999998 | 32.99 | 10.11
Spreadsheet: 39484d1237687042-pasting-formulas-sheets-ranges-sums
Sheet: Sheet1

1 | 5 | <-- check this column, then check NAME MANAGER on the formula tab up top.
 | 8
2 | 12
 | 16
3 | 20
 | 24
4 | 28
 | 32
5 | 36
 | 40
6
7
8
9
10
Spreadsheet: 4150e7fe-f556-42a6-90a9-8c772d959fc5
Sheet: Table 5.1

Monthly Statistical Bulletin
5.1 Business interest rates
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Large business interest rate (a) (b) – per cent
September | 5.45 | 6.4 | 6.45 | 5.65 | 4.75
December | 6 | 6.65 | 6.25 | 5.3 | 4.600000000000001
March | 6.2 | 6.600000000000001 | 6.2 | 5.15 | 4.6
June | 6.4 | 6.550000000000001 | 5.7 | 4.95
Annual average | 6.012499999999999 | 6.550000000000001 | 6.149999999999999 | 5.2625
Small business interest rate (a) (c) – per cent
September | 7.100000000000001 | 8.25 | 8.5 | 7.7 | 6.800000000000001
December | 7.7 | 8.6 | 8.15 | 7.2 | 6.75
March | 8.05 | 8.55 | 8.2 | 7.15 | 6.7
June | 8.25 | 8.55 | 7.75 | 7.050000000000001
Annual average | 7.775 | 8.4875 | 8.149999999999999 | 7.275
(a) The data are weighted average rates, which are calculated from outstanding credit
facilities held by businesses at different interest rates with different maturities.
(b) A large business loan is defined as being $2 million or more.
(c) A small business loan is defined as being less than $2 million.
Source: RBA website statistical table F5 | http://www.rba.gov.au/PublicationsAndResearch/Bulletin/2008/index.html
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-10-03 00:00:00
Spreadsheet: 690623d1597204614-get-the-max-sum-of-2-or-more-consecutive-values-book2
Sheet: Example 3

 | Days | Value | Results | Consecutive
 | 1 | 1000 | Bad Day
 | 2 | 100 | Bad Day | 2
 | 3 | 500 | Good Day |  |  | Expected results
 | 4 | 1000 | Bad Day
 | 5 | 1000 | Bad Day |  |  | Consecutive  Max - Sum Values
 | 6 | 1000 | Bad Day |  |  | Bad Day | Good Day
 | 7 | 1000 | Bad Day |  |  | 7000 | 800
 | 8 | 1000 | Bad Day
 | 9 | 1000 | Bad Day
 | 10 | 1000 | Bad Day | 7
 | 11 | 500 | Good Day
 | 12 | 300 | Good Day | 2
 | 500 | 300 | Bad Day
 | 501 | 300 | Bad Day | 2
Spreadsheet: 272613d1382446066-help-need-a-monthly-formula-example
Sheet: Quality

Quality - Section 2
 |  | 2nd | 3rd | 4th |  | Total
2013-04-26 00:00:00 | Ordered | 1 | 2 | 3 |  | 6
 | Completed | 4 | 2 | 4 |  | 10
2013-05-06 00:00:00 | Ordered | 0 | 5 | 2 |  | 7
 | Completed | 0 | 5 | 2 |  | 7
2013-05-13 00:00:00 | Ordered | 0 | 0 | 0 |  | 0
 | Completed | 0 | 0 | 0 |  | 0
2013-05-20 00:00:00 | Ordered | 1 | 4 | 1 |  | 6
 | Completed | 1 | 4 | 1 |  | 6
2013-05-27 00:00:00 | Ordered | 1 | 2 | 1 |  | 4
 | Completed | 6 | 8 | 11 |  | 25
2013-06-03 00:00:00 | Ordered | 8 | 4 | 0 |  | 12
 | Completed | 5 | 6 | 2 |  | 13
2013-06-10 00:00:00 | Ordered | 1 | 5 | 2 |  | 8
 | Completed | 4 | 1 | 7 |  | 12
2013-06-17 00:00:00 | Ordered | 7 | 5 | 2 |  | 14
 | Completed | 4 | 1 | 4 |  | 9
2013-06-24 00:00:00 | Ordered | 3 | 4 | 6 |  | 13
 | Completed | 2 | 5 | 1 |  | 8
2013-07-01 00:00:00 | Ordered | 3 | 5 | 1 |  | 9
 | Completed | 4 | 2 | 5 |  | 11
2013-07-08 00:00:00 | Ordered | 0 | 0 | 0 |  | 0
 | Completed | 0 | 0 | 0 |  | 0
2013-07-15 00:00:00 | Ordered | 0 | 0 | 0 |  | 0
 | Completed | 0 | 0 | 0 |  | 0
2013-07-22 00:00:00 | Ordered | 0 | 0 | 0 |  | 0
 | Completed | 0 | 0 | 0 |  | 0
2013-07-29 00:00:00 | Ordered | 0 | 0 | 0 |  | 0
 | Completed | 0 | 0 | 0 |  | 0
2013-08-05 00:00:00 | Ordered | 1 | 4 | 0 |  | 5
 | Completed | 1 | 3 | 0 |  | 4
2013-08-12 00:00:00 | Ordered | 0 | 8 | 2 |  | 10
 | Completed | 0 | 7 | 2 |  | 9
2013-08-19 00:00:00 | Ordered | 0 | 2 | 3 |  | 5
 | Completed | 0 | 2 | 1 |  | 3
2013-08-26 00:00:00 | Ordered | 0 | 3 | 2 |  | 5
 | Completed | 0 | 2 | 1 |  | 3
2013-09-02 00:00:00 | Ordered
 | Completed
2013-09-09 00:00:00 | Ordered
 | Completed
2013-09-16 00:00:00 | Ordered
 | Completed
2013-09-23 00:00:00 | Ordered
 | Completed
2013-09-30 00:00:00 | Ordered
 | Completed
2013-10-07 00:00:00 | Ordered
 | Completed
2013-10-14 00:00:00 | Ordered
 | Completed
2013-10-21 00:00:00 | Ordered
 | Completed
2013-10-28 00:00:00 | Ordered
 | Completed
2013-11-04 00:00:00 | Ordered
 | Completed
2013-11-11 00:00:00 | Ordered
 | Completed
2013-11-18 00:00:00 | Ordered
 | Completed
2013-11-25 00:00:00 | Ordered
 | Completed
2013-12-02 00:00:00 | Ordered
 | Completed
2013-12-09 00:00:00 | Ordered
 | Completed
2013-12-16 00:00:00 | Ordered
 | Completed
2013-12-23 00:00:00 | Ordered
 | Completed
2013-12-30 00:00:00 | Ordered
 | Completed
Spreadsheet: 273363d1382692101-help-with-vlookup-formula-from-the-option-menue-training-cost
Sheet: Course Booking Form

 |  | Course Title
 |  | Start Date
 |  | Duration
 |  | Training Provider
 |  | Location
 |  | Cost
[NAME] | Area | Shift | To be replaced By
Employee 1 |  |  | Attending on Day Off
 |  |  | Attending on Day Off
 |  |  | Attending on Day Off
 |  |  | Attending on Day Off
 |  |  | Agency Hygiene days
Spreadsheet: 4d352d0e-35e9-4f5b-996f-7c890b092b36
Sheet: Sheet1

Hourly Employee Biweekly Timesheet
Name |  |  |  |  |  |  |  |  |  |  | PAY PERIOD
 |  |  |  |  |  |  |  |  |  |  | Begin:
Phone |  |  |  | SUNY ID |  |  |  |  |  |  | End:
Date |  | Record DAILY Times in & Out |  |  |  | Total Hours Worked | Enter Time Used Hours |  |  |  |  |  | DRL
 |  |  |  |  |  |  | Vac | Sick |  | Pers | Holiday
 |  | In | Out | In | Out |  |  | Reg | Family |  | Reg | Float
THU
FRI
SAT
SUN
MON
TUE
WED
THU
FRI
SAT
SUN
MON
TUE
WED
 |  |  |  | TOTALS:
Signatures signify that this time record represents a correct accounting of time for the specified period.
 | Employee Signature:
 | Supervisor Signature:
Timesheets must be received in the Payroll Office, Doty 318, by close of business on Friday of pay week.
 | Payroll Use Only: |  | Pay Period |  |  |  |  | Gross:
 |  |  | Posted By: |  |  |  |  | DRP Factor:
 |  |  | Date: |  |  |  |  | DRP Deduction:
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: MINABS

MINABS
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 Price | Price per session
MINABS
Sessions | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 0 | 0 |  | 555.48
Spreadsheet: 118901d1314091226-total-time-calculation-idle-time
Sheet: Data

Today's [NAME] | summer03
Date Received | Name | No. Of Locations/Premises | Status | Assigned Date | Assigned Time | Date Completed | Time Completed | Total Time Taken Without Break | Type of Referral | Description of Referral
2011-07-28 00:00:00 | Supriya | 0 | Completed | 2011-08-01 00:00:00 | 13:52:00 | 2011-08-01 00:00:00 | 14:34:00 | 29
2011-07-29 00:00:00 | Manish | 20 | Completed | 2011-08-01 00:00:00 | 04:45:00 | 2011-08-01 00:00:00 | 07:30:00 | 165
2011-07-29 00:00:00 | Avinash | 1 | Completed | 2011-08-01 00:00:00 | 05:05:00 | 2011-08-01 00:00:00 | 06:02:00 | 57
2011-07-29 00:00:00 | Manish | 1 | Completed | 2011-08-01 00:00:00 | 07:51:00 | 2011-08-01 00:00:00 | 08:15:00 | 44
2011-07-29 00:00:00 | Avinash | 1 | Completed | 2011-08-02 00:00:00 | 04:45:00 | 2011-08-02 00:00:00 | 05:04:00 | 39
2011-07-29 00:00:00 | Manish | 0 | Completed | 2011-08-02 00:00:00 | 07:31:00 | 2011-08-02 00:00:00 | 07:50:00 | 39
2011-07-29 00:00:00 | Avinash | 4 | Completed | 2011-08-02 00:00:00 | 06:31:00 | 2011-08-02 00:00:00 | 07:27:00 | 56
2011-07-29 00:00:00 | Avinash | 1 | Completed | 2011-08-03 00:00:00 | 07:28:00 | 2011-08-03 00:00:00 | 08:00:00 | 32
2011-07-29 00:00:00 | Avinash | 1 | Completed | 2011-08-03 00:00:00 | 08:01:00 | 2011-08-03 00:00:00 | 08:32:00 | 31
2011-07-29 00:00:00 | Avinash | 1 | Completed | 2011-08-03 00:00:00 | 08:16:00 | 2011-08-03 00:00:00 | 08:47:00 | 56
Spreadsheet: 220988d1363344006-generate-part-list-assembly-list
Sheet: Assmebly

 | Assembly A | Assembly B | Assembly C | Assembly D
Sub Assembly | Sub Assembly X | Sub Assembly Y | Sub Assembly X
Part 1 | 1
Part 2 | 2
Part 3 | 4 | 3
Part 4
Part 5 |  |  | 4
Part 6 |  | 8
Part 7 |  | 1
Part 8 |  |  |  | 2
Part 9 |  |  | 6
Spreadsheet: 142925d1330092221-values-in-text-and-using-that-value-in-other-calcs-bracing-calc-start
Sheet: Sheet1

Bracing Connection Details
Fill Blue Cells then Print Sheet 2
Load | 230
CHS
Size | Thickness
168.3 | 6.3
Fin Plates
Length | [NAME] | Thickness
250 | 170 | 8
Bolts
No | Size
2 | 20
Welds
Size
8
Steel Grade
275
Spreadsheet: 156239d1337238874-index-and-match-2-criteria-1-unique-value-attachment
Sheet: data

 |  |  |  |  |  | Client: 177 |  |  |  |  | Client: 420
Day | Product | Sales | Client |  |  | Product/Day | 1 | 2 | 3 |  | Product/Day | 1 | 2 | 3
1 | 101 | 2 |  |  |  | 101 |  |  | 15 |  | 101 | 2
1 | 102 | 5 |  |  |  | 102 | 5 |  |  |  | 102 | 10
1 | 102 | 10 |  |  |  | 103 |  |  | 7 |  | 103 |  |  | 7
3 | 101 | 15
3 | 103 | 7
3 | 103 | 7 |  | should be 420
Spreadsheet: 92531d1292089648-seperating-information-from-1-sheet-into-a-highlight-sheet-no2
Sheet: Analysis

 |  | Hour | 1900-01-01 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | Totals
Calls by | Type | Type 1 |  |  |  |  |  |  |  |  | 4
 |  | Type 2 |  |  |  |  |  |  |  |  | 5
Calls by | Location | Location 1 |  |  |  |  |  |  |  |  | 1
 |  | Location 2
 |  | Location 3
 |  | Location 4 |  |  |  |  |  |  |  |  | 1
 |  | Location 5 |  |  |  |  |  |  |  |  | 1
 |  | Location 6 |  |  |  |  |  |  |  |  | 6
Spreadsheet: eric_saibi__9691__122101
Sheet: Diablo Canyon 01

Owner Name |  | Pacific Gas & Electric
Station Name |  | Diablo Canyon Nuclear Power Station
Unit Name |  | [NAME]
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Nuclear
Capacity |  | 1,137MW
Start Date |  | 2001-12-20 00:00:00
End Date |  | 2001-12-21 00:00:00
Comments |  | Unit was derated about 20% due to Pacific storm in the area. So they decrease power to prevent seaweed from clogging the intakes, However the storm was not as severe as anticipated. They are now powering back up to 100%.
SIC |  | 4911
Plant ID |  | 1016043
Unit ID |  | 1004942
Outage ID
Spreadsheet: 186599d1350102068-how-to-calculate-rental-cash-flows-with-rent-increasing-at-varying-intervals-lease-20irr-20calculations
Sheet: Sheet1

Leasing IRR
 |  |  | Rent Increase psf | 0
[NAME] | 96 |  | Rent Increase % | 0.025
Rental Rate | 9.35 |  | Rent Increase $
Sq. Ft. | 34104 |  | Increase @ Period | 25 |  |  |  |  | IRR
Lease Date | 2012-12-01 00:00:00 |  | Increase Interval | 12
TI psf | 18.4
Combined LC psf | 1.25
First Pay Date | 2013-06-01 00:00:00
 |  |  | Rent | TI Costs | Lease Commissions | Rent Increase Y/N | Rent Increase |  | Cash Flows
 |  |  | 0 |  | 0
Month | 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
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
 | 101
 | 102
 | 103
 | 104
 | 105
 | 106
 | 107
 | 108
 | 109
 | 110
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
Spreadsheet: 513483d1492588806-calculate-price-of-hotel-room-according-to-season-room_bookings
Sheet: Tariffs

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tariff_Table
2017-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-01 00:00:00
2017-02-01 00:00:00
2017-03-01 00:00:00
2017-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | H | H | L | L | L | M | M | L | L | L | L | L
2017-05-01 00:00:00
2017-06-01 00:00:00
2017-07-01 00:00:00
2017-08-01 00:00:00
2017-09-01 00:00:00
2017-10-01 00:00:00
2017-11-01 00:00:00
2017-12-01 00:00:00
Enter "H", "M", "L" for each day. Conditional formatting used to highlight cells.
Spreadsheet: 876072d1722726150-irr-calculation-riddle-excel-in-error-or-bad-theory-irr-test
Sheet: IRR Test 1

IRR Test Comparison |  | 0
IRR TEST 1: No profit share/same IRR <-this is correct
Part Accrued Coupon
[NAME] |  | -10000
Accrued Coupon Pay
Current Coupon | 0.1
Accrued Coupon | 0.05
Profit Share
Balance
CF on Period
IRR
All Current Coupon
[NAME] |  | -10000
Accrued Coupon Pay
Current Coupon | 0.15
Accrued Coupon | 0
Profit Share
Balance
CF on Period
IRR
IRR TEST 2: with Profit Share, results in different IRR??
Part Accrued Coupon
[NAME] |  | -10000
Accrued Coupon Pay
Current Coupon | 0.1
Accrued Coupon | 0.05
Profit Share |  |  |  |  |  |  |  |  |  |  |  | 1000
Balance
CF on Period
IRR
All Current Coupon
[NAME] |  | -10000
Accrued Coupon Pay
Current Coupon | 0.15
Accrued Coupon | 0
Profit Share
Balance
CF on Period
IRR
Spreadsheet: 723943d1615969365-diet-plan-formula-kopia-pliku-weekly-macro-tracker
Sheet: Reference

ID |  | Type | Description | Combination Field | C | P | F | Cals | Size Notes
Required and must be unique |  | Optional | Reqd |  | Reqd | Reqd | Reqd | Calculated | Optional
1 |  | Fruit | Apple |  | 58 | 13 | 6.5 | 363
 |  | Vegetables | Carrot
Spreadsheet: 99bfd14b-03f7-420f-830b-c084455e1ba4
Sheet: Q4

Johnson & Johnson and Subsidiaries
Condensed Consolidated Statement of Earnings
(Unaudited; in Millions Except Per Share Figures) | FOURTH QUARTER
 | 2011 |  |  |  | 2010 |  |  |  | Percent
 |  |  | Percent |  |  |  | Percent |  | Increase
 | Amount |  | to Sales |  | Amount |  | to Sales |  | (Decrease)
Sales to customers | 16255 |  | 100 |  | 15644 |  | 100 |  | 3.905650728713884
Cost of products sold | 5338 |  | 32.83912642263919 |  | 5040 |  | 32.21682434160061 |  | 5.912698412698412
Selling, marketing and administrative expenses | 5458 |  | 33.57736081205783 |  | 5180 |  | 33.1117361288673 |  | 5.366795366795367
Research and development expense | 2155 |  | 13.25745924330975 |  | 1982 |  | 12.66939401687548 |  | 8.728557013118063
Interest (income)expense, net | 148 |  | 0.9104890802829899 |  | 114 |  | 0.7287138839171567
Other (income)expense, net | 2858 |  | 17.6 |  | 1100 |  | 7.131449757095371
Restructuring (income)expense, net | -20 |  | -0.1230390649031067 |  | 0 |  | 0
Earnings before provision for taxes on income | 318 |  | 1.9 |  | 2228 |  | 14.24188187164408 |  | -85.7
Provision for taxes on income | 100 |  | 0.6 |  | 286 |  | 1.828176936844797 |  | -65
Net earnings | 218 |  | 1.3 |  | 1942 |  | 12.41370493479928 |  | -88.8
Net earnings per share  (Diluted) | 0.08 |  |  |  | 0.7 |  |  |  | -88.6
Average shares outstanding  (Diluted) | 2768.9 |  |  |  | 2781.6
Effective tax rate | 31.4 | % |  |  | 12.83662477558348 | %
Adjusted earnings before provision for taxes and net earnings
Earnings before provision for taxes on income | 3657 | (1) | 22.49769301753307 |  | 3451 | (1) | 22.05957555612375 |  | 5.96928426543031
Net earnings | 3129 | (1) | 19.24946170409105 |  | 2864 | (1) | 18.30733827665559 |  | 9.252793296089386
Net earnings per share  (Diluted) | 1.13 | (1) |  |  | 1.03 | (1) |  |  | 9.708737864077657
Effective tax rate | 0.1443806398687449 |  |  |  | 0.1700956244566792
(1)  See Reconciliation of Non-GAAP Financial Measures.
Spreadsheet: 828778d1683729868-sort-date-ascending-if-certain-conditions-met-samplefile
Sheet: sheet2

STATUS | SHATRIANGLE | WEIGHT | COLOR | SELL INV | SELL DATE | CLIENT
SOLD | RECTANGLE | 1.5 | YELLOW | - | - | WINDOW
SOLD | RECTANGLE | 1 | WHITE | - | 2020-05-10 00:00:00 | HARRY
SOLD | RECTANGLE | 3.5 | WHITE | - | 2020-06-10 00:00:00 | HARRY
SOLD | SQUARE | 1.5 | BLACK | - | 2020-06-11 00:00:00 | WINDOW
Spreadsheet: 825171d1681156328-sum-formula-for-specific-text-sum
Sheet: Sheet1

Result |  | SUM "Win" in A:A and ignore Hided Rows
Win
Loss
Win
Win
Win
Loss
Win
Loss
Loss
Loss
Loss
Loss
Win
Loss
Loss
Win
Win
Loss
Loss
Win
Loss
Spreadsheet: 809277d1671004045-calculation-of-a-cumulative-penalty-with-2-different-penalty-rates-penalty-calculations
Sheet: Sheet2

Period | Principal Due | Amount Paid | [NAME] | Months late as at (1st March 2023) | Penalty was 20% in December 2022 backwards and 10% in January 2023 forward | 0.2 | 0.1 | Months late | Cumulative % | Penalty due
2022/10 | 100 |  |  |  |  | 40%(2 months late) | 30%(3months late) | 5 months | 0.7
2022/11 | 100 |  |  |  |  | 20%(1 month late) | 30%(3months late) | 4 months | 0.5
2022/12 | 100 |  |  |  |  | 0%(0 months late) | 30%(3months late) | 3 months | 0.3
2023/01 | 100 |  |  |  |  | 0%(0 months late) | 20%(2months late) | 2 months | 0.2
2023/02 | 100 |  |  |  |  | 0%(0 months late) | 10%(1month late) | 1 month | 0.1
2023/03 | 100 |  |  |  |  | 0%(0 months late) | 0%(0months late) | 0 months | 0 | 0
penalties are charged on the 1st of the subsequent month.
Spreadsheet: 329131d1404211298-calculate-up-to-a-value-calculate-up-to-a-value-hours
Sheet: DISPLAY SHEET

 | Week |  | Week | Total | Total | Total | Total |  |  |  | TAKEN | REMAINING
 | Commencing |  | No | Hours | None Wk | Holidays | [NAME] |  |  |  | HOLIDAYS | HOLIDAYS
 | 00:00:00 |  | 1 | 1 day, 21:00:00 | 6:00:00
 |  |  | 2 |  |  | 5
 |  |  | 3 | 2 days, 4:00:00 | 7:00:00
 |  |  | 4 |  |  | 5
 |  |  | 5 | 1 day, 23:00:00 | 6:00:00
 |  |  | 6 |  |  | 5
 |  |  | 7 | 1 day, 23:00:00 | 6:00:00
 |  |  | 8 |  |  | 5
 |  |  | 9 | 1 day, 23:00:00 | 6:00:00
 |  |  | 10 |  |  | 3
 |  |  | 11 | 1 day, 23:00:00 | 6:00:00
 |  |  | 12 |  |  | 3
 |  |  | 13 | 1 day, 23:00:00 | 6:00:00
 |  |  | 14 |  |  | 3
 |  |  | 15 | 1 day, 23:00:00 | 6:00:00
 |  |  | 16 | 1 day, 23:00:00 | 6:00:00
 |  |  | 17 | 1 day, 23:00:00 | 6:00:00
 |  |  | 18 | 1 day, 0:00:00 | 6:00:00 | 3
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26