tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 706317d1606622980-return-the-next-value-in-a-list-after-a-specific-value-is-found-help-find-the-next-value-in-a-list-after-sa_3
Sheet: Help Needed (2)

 | Goal:
 | I'm in need of a formula that can sum values within a defined region (while omitting any rows that have values in column "B" and column "D"). The formula should first find/identify the next value in column "B" where the values indicate the end of the summing region (while also indicating the start of the next summing region). For example letters are used are ("T", "h", "S", "SG", or "SA".)
 | Summing Category Logic
 | ITEM |  |  | LETTER USED | STOP SUMMING AT | Values Omitted Column "B" | Values Omitted Column "D"
 | Category Title |  |  | "T" | T | h, S, SG, SA | V or X
 | Section Header |  |  | "h" | T or h | S, SG, SA | V or X
 | Sub-Category |  |  | "S" | any value:  T, h, S, SG, SA | none | V or X
 | Grouped Sub-Category Header |  |  | "SG" | T or h or S or SG | SA | V or X
 | Grouped Sub-Category |  |  | "SA" | any value: T, h, S, SG, SA | none | V or X
 | [NAME] | Helper Row For Category L:abels | Helper Row For "SG" groupings | Variables to omit | Titles and Line Items |  | Manually calculated results |  | My [NAME] (So far…) I plan to put it into the yellow cells in column J
 | T |  |  |  | Company Supplies -
 | h |  |  |  | Marketing Supplies:
 | s |  |  |  | Event Supplies:
 |  |  |  |  |  | Computers | 200
 |  |  |  | V |  | [NAME] | 100
 |  |  |  |  |  | Software | 200
 | SG |  |  |  | Event Supplies for Online Events:
 | SA |  |  |  | Online Event AAA:
 |  |  |  |  |  | Line item for Event AAA | 200
 |  |  |  |  |  | Line item for Event AAA | 200
 |  |  |  | X |  | Line item for Event AAA | 200
 | SA |  |  |  | Online Event BBB:
 |  |  |  |  |  | Line item for Event BBB | 200
 |  |  |  | X |  | Line item for Event BBB | 200
 |  |  |  |  |  | Line item for Event BBB | 200
 | h |  |  |  | Operation Supplies:
 | S |  |  |  | Office Supplies:
 |  |  |  |  |  | Tables | 100
 |  |  |  |  |  | Chairs | 100
 |  |  |  | V |  | Pens | 100
 | SG |  |  |  | USA Offices:
 | SA |  |  |  | NYC Office:
 |  |  |  |  |  | Line item for NYC Office | 200
 |  |  |  | V |  | Line item for NYC Office | 200
 |  |  |  |  |  | Line item for NYC Office | 200
 | SA |  |  |  | Boston Office:
 |  |  |  |  |  | Line item for Boston Office | 200
 |  |  |  | X |  | Line item for Boston Office | 200
 |  |  |  |  |  | Line item for Boston Office | 200
 | H |  |  |  | End of Sheet |  | 0
 | T |  |  |  | End of Sheet |  | 0
Spreadsheet: 643406d1569855172-help-with-a-string-of-if-statements-cashflow-template-online-example-updated-expected-outcome
Sheet: Base Case Cashflow

 |  |  |  |  |  |  |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  |  |  |  |  |  |  |  |  | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-12-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Property Address | Tenant | Lease Start | Lease Break Exercised? | Lease Break Date | Lease Expiry | Rent | Rent Post Void | Post Void Lease Expiry | VOID (# [NAME]) | Q3 2019 | Q4 2019 | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q1 2021 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 |  | 2019-01-01 00:00:00 |  | 2020-03-01 00:00:00 | 2023-09-30 00:00:00 | 42000
 |  | 2018-09-30 00:00:00 |  | 2020-07-01 00:00:00 | 2023-09-30 00:00:00 | 68000
 |  |  |  | 2023-06-30 00:00:00 | 2020-06-30 00:00:00 | 56000
 |  | 2018-01-01 00:00:00 |  | 2020-06-15 00:00:00 | 2021-07-01 00:00:00 | 105000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Void | Void
Initial Loan Requirement |  |  |  |  | Opening Bal
Property Value |  |  |  |  | [NAME]
Annuity Loan Profile on |  |  |  |  | [NAME]
Term |  |  |  |  | Closing LTV
Gross Rent
Interest p.a.
Service Charges & Costs - lessee
Profit before tax
Tax Payable (estimated) @
Total Interest, Expenses & Tax
Cashflow available pre Principal Repayments p.a.
Net Cashflow Available per above
Add back interest
Cashflow available for Debt Servicing
Cashflow after Debt Servicing
Gross Interest Cover
DSCR Pre Tax
DSCR Post Tax
Surplus Cashflow Available p.a. - pre tax
Surplus Cashflow Available p.a. - post tax
Tax Calculation
Rent
Expenses
Interest
Interest Dissalowed |  |  |  | 0
Capital Allowance |  |  |  | 0
Taxable Surplus
Tax Payable @
Rent Reserve
Opening reserve |  |  |  |  |  |  |  |  |  | 0
Surplus Cashflow Available p.a. - post tax
Cumulative reserve
Spreadsheet: 0fbe575d-3f90-436c-84c5-e8f62422ca77
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
ISV Updates:
2008-10-01 00:00:00 | 1) Residential ISV for cis-1,3-Dichloropropene increased from 3 to 20 µg/m3
 | 2) Residential ISV for trans-1,3-Dichloropropene increased from 3 to 20 µg/m3
 | 3) Residential ISV for 1,1,1-Trichloroethane (Methyl chloroform) increased from 1,000 to 5,000 µg/m3
 | 4) Resdiential ISV for Chloromethane (Methyl chloride) increased from 6 to 90 µg/m3
 | 5) Changed acute ISVs referenced from ATSDR to one significant digit (when appropriate)
2009-02-02 00:00:00 | 1) Added Commercial/Industrial ISVs
 | 2) Added Risk Estimation Tabs for assessing risk from multiple contaminants
 | 3) Residential ISV for Benzyl Chloride increased from 0.2 to 1 µg/m3 (new PPRTV)
 | 4) Residential ISV for Acetone increased from 400 to 31,000 µg/m3  (EPA no longer supporting values in their 2002 Vapor Intrusion
 | Guidance document, use of ATSDR value)
 | 5) Residential ISV for Bromodichloromethane is withdrawn (EPA no longer supporting values in their 2002 VI Guidance document)
 | 6) Residential ISV for [NAME] is withdrawn  (EPA no longer supporting values in their 2002 VI Guidance document)
 | 7) Residential ISV for 1,3 [NAME] is withdrawn (EPA no longer supporting values in their 2002 VI Guidance document)
 | 8) Residential ISV for cis-1,2-Dichloroethene is withdrawn (EPA no longer supporting values in their 2002 VI Guidance document)
 | 9) Residential ISV for 2-Methynaphthalene is withdrawn (EPA no longer supporting values in their 2002 VI Guidance document)
Spreadsheet: 106869d1304014698-if-statement-sampleworkbookexcelforum
Sheet: Effects and Instructions

Effect if on 1 drug
BP Drug | *ace | *alpha | *arb | *b | *ccbd | *ccbn | *pd | *ld | *td | *b+td | *ace+td | *pd+td | *ara+td | *aag+td | *a+b | *ace+ccbd | *cag | *ara | *aa
Systolic | 14.3 | 18.6 | 15.7 | 14.6 | 17.1 | 13.9 | 15 | 12.3 | 15 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7
Diastolic | 10.4 | 12.5 | 10.5 | 12.1 | 10.4 | 14.6 | 9.5 | 6.1 | 9.5 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5
What is the effect if on 2 drugs?
e.g. A person (ID 19002) is on 2 drugs: *ace and *td
1) Compare which has a greater effect for systolic (above table)
 | e.g. td = 15.0, ace = 14.3
 | Therefore, td has a greater effect
2)
If one of the 2 drugs are a diuretic (td, pd, ld, b+td, ace+td, pd+td, ara+td, aag+td), multiply the drug with the lower effect by 53%
If neither of the drugs are a diuretic (not td, pd, etc.), multiply the drug with the lower effect by 50%
 | e.g. td = diuretic
 | ace = 14.3 --> lower effect than td (see previous)
 | Therefore, ace= 14.3 x 53% = 7.579
If both of the drugs are diuretics, do nothing
3)
Add the effects of the 2 drugs
 | e.g. td = 15.0; ace(now) = 7.579 (look above)
 | The effect on systolic = *td + *ace(now) = 15.0 +7.579 = 22.6
4)
Add this number to the systolic blood pressure
5)
Do the same thing for diastolic blood pressure
6) Diastolic
e.g. A person is on 2 drugs: *ace and *td
 | *ace (diastolic) = 10.4
 | *td (diastolic) = 9.5
 | *ace has a greater effect than diastolic
7)
If one of the 2 drugs are a diuretic (td, pd, ld, b+td, ace+td, pd+td, ara+td, aag+td), multiply the drug with the lower effect by 44%
If neither of the drugs are a diuretic (not td, pd, etc.), multiply the drug with the lower effect by 58%
 | td = diuretic
 | td = 9.5 = lower effect
 | effect of td = 9.5 x44% = 4.18
If both of the drugs are diuretics, do nothing
8)
Add the effects of the 2 drugs
 | *ace = 10.4
 | *td (now) = 4.18
 | The effect on diastolic = 10.4 +4.18 = 14.6
9)
Add this number to the diastolic blood pressure
Spreadsheet: 220451d1363171708-separate-night-from-day-hours-sample-separate-night-day-hours
Sheet: SAMPLE

WORK PLAN SEPARATE DAY OF NIGHT PAYMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GUARDS
DATE |  | 2013-04-01 00:00:00 |  | 2013-04-02 00:00:00 |  | 2013-04-03 00:00:00 |  | 2013-04-04 00:00:00 |  | 2013-04-05 00:00:00 |  | 2013-04-06 00:00:00 |  | 2013-04-07 00:00:00 |  |  |  | NAME |  |  | CODE | NAME |  |  | CODE
 | GUARD | 101 |  | 103 |  | 104 |  | 105 |  | 105 |  | 105 |  | 105 |  |  |  | TEST 1 |  |  | 101 | TEST 8 |  |  | 107
IN/OUT |  | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT |  |  | TEST 2 |  |  | 102 | TEST 9 |  |  | 108
SHIFT |  | 10:00:00 | 23:00:00 | 16:00:00 | 1900-01-01 00:00:00 | 18:00:00 | 02:00:00 | 05:00:00 | 13:00:00 | 04:00:00 | 12:00:00 | 22:00:00 | 04:00:00 | OFF | OFF |  |  | TEST 3 |  |  | 103 | TEST 10 |  |  | 109
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST 4 |  |  | 104 | TEST 11 |  |  | 110
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST 5 |  |  | 105 | TEST 12 |  |  | 111
DAY HOURS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST 6 |  |  | 106 | TEST 13 |  |  | 112
NIGHT HOURS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST 7 |  |  | 107 | TEST 14 |  |  | 113
TOTAL HOURS |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 6 |  | 0
 | FROM 6:00 TO 22:00 = 16 DAY HOURS
 | FROM 22:00 TO 6:00 = 8 DAY HOURS
WORK PLAN SEPARATE DAY OF NIGHT PAYMENT
DATE |  | 2013-04-01 00:00:00 |  | 2013-04-02 00:00:00 |  | 2013-04-03 00:00:00 |  | 2013-04-04 00:00:00 |  | 2013-04-05 00:00:00 |  | 2013-04-06 00:00:00 |  | 2013-04-07 00:00:00
 | GUARD | 101 |  | 103 |  | 104 |  | 105 |  | 105 |  | 105 |  | 105
IN/OUT |  | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT
SHIFT |  | 10:00:00 | 18:00:00 | 16:00:00 | 1900-01-01 00:00:00 | 18:00:00 | 02:00:00 | 05:00:00 | 13:00:00 | 04:00:00 | 12:00:00 | 22:00:00 | 04:00:00 | OFF | OFF
DAY HOURS |  | 8 |  | 6 |  | 4 |  | 7 |  | 6 |  | 0 |  | 0
NIGHT HOURS |  | 0 |  | 2 |  | 4 |  | 1 |  | 2 |  | 6 |  | 0
TOTAL HOURS |  | 8 |  | 8 |  | 8 |  | 8 |  | 8 |  | 6 |  | 0
Spreadsheet: 859782d1708029098-count-populated-cells-until-next-criteria-met-book1
Sheet: Sheet1

332 | 20 | 1 | 20 | 32
 | 20 | 3 | 19
 | 20 | 19 | 57
 | 20 | 15 | 60
 | 60 | 20 | 60
 | 20 | 20 | 20
 | 20 | 20 | 7
 | 1 | 60 | 5
 | 20 | 1 | 60
 | 11 | 22
 | 1 | 60 | 60
333 | 1 | 60 | 5
Spreadsheet: 771274d1646572295-cannot-use-sortby-when-cells-hidden-book3-1-
Sheet: Sheet1

 |  | Col A | REVKEY
 |  | Unit 1 | 100
 |  | Unit 2 | 34
 |  | Unit 3 | 45
 |  | Unit 4 | 65
 |  | Unit 5 | 34
 |  | Unit 6 | 23
 |  | Unit 7 | 22
 |  | Unit 8 | 25
 |  | Unit 9 | 66
 |  | Unit 10 | 78
 |  | Unit 11 | 44
 |  | Unit 12 | 0
 |  | Unit 13 | 0
 |  | Unit 14 | 0
 |  | Unit 15 | 0
 |  | Unit 16 | 0
 |  | Unit 17 | 0
 |  | Unit 18 | 0
 |  | Unit 19 | 0
 |  | Unit 20 | 0
 |  | Unit 21 | 0
 |  | Unit 22 | 0
 |  | Unit 23 | 0
 |  | Unit 24 | 0
 |  | Unit 25 | 0
 |  | Unit 26 | 76
 |  | Unit 27 | 12
 |  | Unit 28 | 14
 |  | Unit 29 | 0
 |  | Unit 30 | 0
 |  | Unit 31 | 0
 |  | Unit 32 | 0
 |  | Unit 33 | 56
 |  | Unit 34 | 99
 |  | Unit 35 | 120
 |  | Unit 36 | 130
 |  | Unit 37 | 140
 |  | Unit 38 | 45
 |  | Unit 39 | 67
 |  | Unit 40 | 0
 |  | Unit 41 | 0
 |  | Unit 42 | 0
 |  | Unit 43 | 0
 |  | Unit 44 | 0
 |  | Unit 45 | 0
 |  | Unit 46 | 98
 |  | Unit 47 | 66
 |  | Unit 48 | 73
 |  | Unit 49 | 42
 |  | Unit 50 | 41
 |  | Unit 51 | 17
 |  | Unit 52 | 26
 |  | Unit 53 | 59
 |  | Unit 54 | 0
 |  | Unit 55 | 0
 |  | Unit 56 | 0
 |  | Unit 57 | 0
 |  | Unit 58 | 0
 |  | Unit 59 | 0
 |  | Unit 60 | 0
 |  | Unit 61 | 0
 |  | Unit 62 | 45
 |  | Unit 63 | 34
Spreadsheet: 008c527f-cca2-4f6e-8278-dd29f03bbbd5
Sheet: Sheet1

Unnamed: 0 | Version 12.04 | Unnamed: 2 | Unnamed: 3
 | 2006-08-16 00:00:00
Outdoor Bridge Range Calculation Utility
For  Cisco Aironet Systems
[NAME]: | 2.4Ghz Cisco Aironet BR1300, BR350, WGB350, and PCI350
 | 5Ghz Cisco Aironet 1410 (it does NOT support the AP1200)
Directions for use.
 | 1. Select proper sheet (at the bottom) for 2.4GHz or 5Ghz systems
 | 2. Select the proper [NAME] based upon your approvals for installation locations. (see Power Regulatory Domain Worksheet)
 | 3. Select Product Being used for both sides of the link.
 | 4.Select Datarate being used.
 | 5. Select antenna used on each site . If using something other than Cisco/Aironet antennas, enter the gain factor in dBi.
 | 6.  Select Power level for both sides of the link
 | 7. Select cables being used on each side. If using something other than Aironet cable, select other, then enter the loss/100 ft and length of cable
 | 8. Select typical environmental conditions
 | 9. REMEMBER These are THEORETICAL calculations.
 | 10. LINE OF SITE IS REQUIRED!
Note: | This calculation utility has been edited to stay within limitations for TX power, and EIRP under the listed regulatory domains. There may be cases where it exceeds the limitations, and it is the responsibility of the installing parties to verify the installation is within the laws of the location in which it is being installed. The older 2.4Ghz calculation utility has been retained and can be found at the last page of this spreadsheet.
 | When using this utility, available power levels will changed based upon the regulatory domain, the  antenna (or [NAME] gain) selected, the modulation mode, which is based on the datarate selected (OFDM requires a lower power level in some domains). Verify all parameters after making any parameter changes.
 | Regulations in Japan do not  permit use of antennas other than Cisco antennas.
Revisions | Description | Rev | Author
2004-05-06 00:00:00 | Correct calculation for 'other' antennas in 2.4ghz worksheet | 12.01 | BEA
 | Changed text to indicate 5dBi instead of 10 for 2.4 worksheet | 12.02 | BEA
2005-04-22 00:00:00 | corrected 'other cable' effect on EIRP for 5Ghz sheet | 12.03 | BEA
Spreadsheet: 25741d1217273640-problems-using-array-with-2007-book1
Sheet: Sheet1

Company | Sub-Company | Element | Breakdown | Input |  |  | Input Values:
 |  |  |  |  |  |  | 1
A | 1 | A1 | AY | 1 |  |  | 2
B | 2 | A1 | AY | 3 |  |  | 3
B | 1 | B2 | AX | 3 |  |  | 4
A | 2 | B1 | AX | 4 |  |  | 5
Spreadsheet: sara_shackleton__36839__MLAlleghenydealschedulesfinal
Sheet: Power Swap Final

Merrill's Transact | Trade Date | Merrill's B/S | Beg Date | End Date | Vol | Location | Block | Price
107394 | Aug 28 2000 12:00AM | SELL | 2003-01-01 00:00:00 | 2003-12-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 56.5
107831 | Sep  6 2000 12:00AM | SELL | 2003-01-01 00:00:00 | 2005-12-31 00:00:00 | 100 | NYIS/ZONE J | 5x16 | 58.25
113089 | Dec  4 2000 12:00AM | BUY | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE A | 5x16 | 81
114324 | Jan  5 2001 12:00AM | BUY | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 60
115036 | Jan 22 2001  4:20PM | BUY | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 62.5
116032 | Feb  5 2001  3:57PM | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 131.5
116207 | Feb  6 2001  4:53PM | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 132.25
116429 | Feb  8 2001  5:11PM | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE A | 5x16 | 74.75
116431 | Feb  8 2001 12:00AM | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 133.5
117292 | Feb 26 2001  6:10PM | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE A | 5x16 | 74.5
117293 | Feb 26 2001 12:00AM | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE A | 5x16 | 73
117296 | Feb 27 2001 12:00AM | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 132.5
117795 | Mar  6 2001  6:21PM | BUY | 2001-06-01 00:00:00 | 2001-06-30 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 86.25
117944 | 2001-03-09 00:00:00 | SELL | 2001-03-09 00:00:00 | 2001-03-09 00:00:00 | 100 | PJM-Western Hub | HOURLY | 41.5
Spreadsheet: 10556ed4-2a71-4f17-97c0-9c5b942db8de
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Law, Public Safety, Corrections and Security: Correction Services
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Correction Services Pathway of the Law, Public Safety, Corrections and Security [NAME]) can serve as a guide, along with other career planning materials,
as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study,
used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        Correction Services Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Case Manager ►Community Correction Practitioner ►Corrections Educator ►Corrections Officer ►Corrections Trainer ►Detention Deputy ►Facility Maintenance Worker ►Jail Administrator ►[NAME] ►Mid-level Manager ►Probation/Parole Officer ►Program Coordinator and Counselor ►Public Information Officer ►Transport Officer ►Warden ►Youth Services Worker
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 326727d1403249569-functions-use-for-various-conditioning-book1
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  |  | Peak Season
 | Fruits | Occurrence | Time taken to sell (by hour) | Date Sold | Good sales (Yes/No) | Normal Sales (Yes/No) | Count number of good sales | Count number of normal sales | % of good sales | % of normal sales |  |  | Public Holidays | 2/3 days prior
 | Apple |  | 26 | 2014-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
 | Apple |  | 1 | 2014-01-07 00:00:00 |  |  |  |  |  |  |  |  | 2014-01-18 00:00:00
 | Apple |  | 0.5 | 2014-01-14 00:00:00 |  |  |  |  |  |  |  |  | 2014-05-01 00:00:00
 | [NAME] |  | 2.5 | 2014-01-21 00:00:00 |  |  |  |  |  |  |  |  | 2015-01-01 00:00:00
 | [NAME] |  | 2 | 2014-01-28 00:00:00 |  |  |  |  |  |  |  |  | 2015-01-18 00:00:00
 | Blueberry |  | 1 | 2014-02-04 00:00:00 |  |  |  |  |  |  |  |  | 2015-05-01 00:00:00
 | Durian |  | 29 | 2014-02-12 00:00:00 |  |  |  |  |  |  |  |  | 2014-05-31 00:00:00
 | Durian |  | 5 | 2014-02-18 00:00:00 |  |  |  |  |  |  |  |  | 2015-05-31 00:00:00
 | Grapefruit |  | 6 | 2014-02-23 00:00:00
 | Kiwi |  | 3 | 2014-02-28 00:00:00
 | Kiwi |  | 28 | 2014-03-03 00:00:00 |  |  |  |  |  |  | Definition of Good Sales:
 | Mango |  | 2 | 2014-03-07 00:00:00 |  |  |  |  |  |  | 1) Sell within 4 hours or less
 | Mango |  | 5 | 2014-03-15 00:00:00 |  |  |  |  |  |  | 2) < 2 same type of fruits sold off
 | Mango |  | 25 | 2014-03-22 00:00:00 |  |  |  |  |  |  | 3) Sold of during peak season
 | Mango |  | 4 | 2014-03-27 00:00:00 |  |  |  |  |  |  | (Peak season: 2 calendar days before or on public holiday, or 3 days before 31st May)
 | Mangosteen |  | 30 | 2014-04-04 00:00:00 |  |  |  |  |  |  | Public holiday date for example: 1 Jan 14, 18 Apr 14, 1 May 14
 | Orange |  | 4 | 2014-04-16 00:00:00
 | Orange |  | 1 | 2014-04-20 00:00:00 |  |  |  |  |  |  | Definition of Normal Sales:
 | Papaya |  | 8 | 2014-04-26 00:00:00 |  |  |  |  |  |  | 1) Sold off the next day
 | Papaya |  | 13 | 2014-05-01 00:00:00 |  |  |  |  |  |  | 2) >2 same type of fruits sold off
 | Papaya |  | 25 | 2014-05-08 00:00:00 |  |  |  |  |  |  | 3) Sold off during non-peak season
 | Starfruit |  | 3.5 | 2014-05-13 00:00:00
 | [NAME] |  | 3 | 2014-05-20 00:00:00
 | Watermelon |  | 2 | 2014-05-24 00:00:00
 | Watermelon |  | 2 | 2014-05-27 00:00:00
 | Wintermelon |  | 0.5 | 2015-05-31 00:00:00
Spreadsheet: 819995d1677807991-how-to-tweak-formula-to-change-calendar-to-include-date-range-book_251717
Sheet: Calendar (2)

Month: | Year: |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY
October | 2023
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
January | 2022
February | 2023
March | 2024
April | 2025
May | 2026
June | 2027
July | 2028
August | 2029
September | 2030
October | 2031
November | 2032
December | 2033
Spreadsheet: 798502d1664521767-to-summarize-data-by-label-name-copy-of-examples
Sheet: Expected sheet data

Forecast by Branch by SKU
Branch | Product | SKU | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
A | AB | ABB |  |  |  | so on
A | AB | ABC
A | AB | ABD
A | AB | ABE
A | AB | ABF
A | AB | ABG
A | AC | ABB
A | AC | ABC
A | AC | ABD
A | AC | ABE
A | AC | ABF
A | AC | ABG
B | AB | ABB
B | AB | ABC
B | AB | ABD
B | AB | ABE
B | AB | ABF
B | AB | ABG
B | AC | ABB
B | AC | ABC
B | AC | ABD
B | AC | ABE
B | AC | ABF
B | AC | ABG
C | AB | ABB
C | AB | ABC
C | AB | ABD
C | AB | ABE
C | AB | ABF
C | AB | ABG
C | AC | ABB
C | AC | ABC
C | AC | ABD
C | AC | ABE
C | AC | ABF
C | AC | ABG
D | AB | ABB
D | AB | ABC
D | AB | ABD
D | AB | ABE
D | AB | ABF
D | AB | ABG
D | AC | ABB
D | AC | ABC
D | AC | ABD
D | AC | ABE
D | AC | ABF
D | AC | ABG
E | AB | ABB
E | AB | ABC
E | AB | ABD
E | AB | ABE
E | AB | ABF
E | AB | ABG
E | AC | ABB
E | AC | ABC
E | AC | ABD
E | AC | ABE
E | AC | ABF
E | AC | ABG
Spreadsheet: 75878d1276502736-auto-copy-record-to-different-spreadsheets-sanfos-example
Sheet: programe 1

Surname | Name | code | Sallary | Shift | Company | Τype | [NAME]
 |  |  |  |  |  |  |  |  |  |  | surname4 | name 4 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 1
 |  |  |  |  |  |  |  |  |  |  | surname8 | name 8 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 1
 |  |  |  |  |  |  |  |  |  |  | surname12 | name 12 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 1
 |  |  |  |  |  |  |  |  |  |  | surname16 | name 16 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 1
 |  |  |  |  |  |  |  |  |  |  | surname20 | name 20 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 1
 |  |  |  |  |  |  |  |  |  |  | surname24 | name 24 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 1
 |  |  |  |  |  |  |  |  |  |  | surname27 | name 27 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 1
 |  |  |  |  |  |  |  |  |  |  | surname30 | name 30 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 1
 |  |  |  |  |  |  |  |  |  |  | surname33 | name 33 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 1
 |  |  |  |  |  |  |  |  |  |  | surname36 | name 36 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 1
 |  |  |  |  |  |  |  |  |  |  | surname39 | name 39 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 1