tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40260__C0366-112458
Sheet: Dept_100182

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
BUILDING SERVICES - Dept. 100182
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-06-21 00:00:00 | BSV100182-2001-06-0366-112458 |  | Building Services | Sq. Ft. Occupied | 165 | 0.03 | /EACH | 4.95
 |  |  |  |  |  |  | Ticket Total |  | 4.95
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 4.95
 |  |  |  |  |  |  | Total for Dept_100182 |  | 4.95
Spreadsheet: 2b886bcf-210a-40f3-b8cf-00009cf64a15
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 83. Value of Building Approved, Chain Volume Measures, Original - Western Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total houses ;  New ; |  |  | Original | A590517J | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total other residential building ;  New ; |  |  | Original | A590518K | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total residential building ;  New ; |  |  | Original | A590519L | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590520W | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590521X | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590522A | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590523C | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 768752d1645108535-lookup-results-are-coming-up-offset-samplelookup
Sheet: Class Key

Class | Class Description
A01 | Square Sponge Gaskets
A02 | [NAME]
A03 | Multiseal Gaskets
B01 | Tubular Pail Gaskets
B02 | Drum Dollies
B03 | Drum Racks
B04 | Drum Stands
C01 | Drum Grabber Fork Lift
C02 | Steel Pails
C03 | Steel Reconditioned Drums
C05 | Steel Drums
C06 | Plastic Drums
C07 | [NAME]
C08 | Composite Drums
C09 | Mil-Spec Drums
C10 | Plastic Reconditioned Drums
C12 | Stainless Steel Drums
C15 | Metal Cans
C16 | Plastic Cans
C17 | Slip Cover Cans
C18 | 4G Combination Packaging
C19 | Decorated Cans
C20 | Cubitainers
C22 | Hedpaks
C25 | Winpaks
C26 | Plastic Bottles
C27 | [NAME]
C28 | Small Pack Dispensers
Spreadsheet: 687131d1594983326-sum-up-series-of-years-months-based-on-name-test-sum-up-series-of-years
Sheet: Sheet1

Benchmarking at date : |  |  | 2020-12-31 00:00:00
Name | Previous Years of Experience prior joining | Hire Date | Length of Service | Total Years of Experience
Apark | 14 years 9 months | 2020-01-02 00:00:00
Batist | 9 years 11 months | 2009-09-01 00:00:00
Saya | 7 years 1 months | 2020-05-11 00:00:00
[NAME] | 4 years 4 months | 2019-10-01 00:00:00
[NAME] | 7 years 8 months | 2018-09-03 00:00:00
 |  |  |  | How to sum column B and D keeping the same year, month format?
Spreadsheet: 268753d1380771763-match-2-criteria-2-criteria-match
Sheet: Sheet1

 | Company | Code |  |  |  | Name | Sector |  |  | Company | Code | Name | Sector
1 | A | 1001 | Chairman | 2010 | 10248 | [NAME] | Finance |  |  | A | 1001 | [NAME] | Finance
2 | A | 1001 | D Chairman | 2010 | 10437 | Bernard | Finance |  |  | A | 1001 | Bernard | Finance
3 | A | 1002 | Member | 2010 | 11680 | Jong | Finance |  |  | A | 1002 | Jong | Finance
4 | B | 1003 | Chairman | 2010 | 13287 | [NAME] | Property |  |  | B | 1003 | [NAME] | Property
5 | C | 1003 | Chairman | 2010 | 13553 | [NAME] | Industries |  |  | C | 1003 | [NAME] | Industries
Spreadsheet: 23184d1212592576-inventory-tracking-copy-of-xl0000001
Sheet: Donations Quick Sheet

Item | # Per Package | Total Items | Packages Purchased | Packages Used | Packages on Hand
Toys
Suave Detangler | 1 | #N/A | #N/A | #N/A | #N/A
Play-Doh (4 Pack) | 4 | 4 | 1 | 0 | 1
[NAME] (4 Pack of 4) | 16 | 160 | 10 | 0 | 10
[NAME] Animals | 1 | 3 | 3 | 0 | 3
Dinosaurs | 1 | 21 | 21 | 0 | 21
Flute | 1 | 20 | 20 | 0 | 20
Baton | 1 | 12 | 12 | 0 | 12
Bracelet (Pack of 12) | 12 | 72 | 6 | 0 | 6
Lite-Up Ball | 1 | 2 | 2 | 0 | 2
 |  | 0 | 0 | 0 | 0
Snacks
Mac & Cheese (Pack of 9) | 9 | #N/A | #N/A | #N/A | #N/A
[NAME] | 45 | #N/A | #N/A | #N/A | #N/A
[NAME] | 45 | #N/A | #N/A | #N/A | #N/A
Boyardee | 8 | #N/A | #N/A | #N/A | #N/A
Otter Pops | 200 | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 163811d1340469780-help-matching-data-in-sheet1-based-on-data-on-sheet2-sample2
Sheet: Sheet1

MEMBERSHIP_CARD_NO | MEMBERSHIP_LEVEL | RESORT | COUNTRY | DEPARTURE_DATE | NUMBER_NIGHTS | MONTH | YEAR
8815879251 | GOLD | PPBKK | MY | 2010-08-08 00:00:00 | 14 |  |  |  | Count of NUMBER_NIGHTS | Column Labels
8005707061 | GOLD | PPBKK | JP | 2010-02-01 00:00:00 | 4 |  |  |  | Row Labels | 2010 | 2011 | 2012 | Grand Total
8910102045 | GOLD | PPBKK | MY | 2010-09-01 00:00:00 | 4 |  |  |  | 8005707061 | 3 | 1 | 1 | 5
8567232761 | GOLD | PPBKK | JP | 2010-08-02 00:00:00 | 4 |  |  |  | 8182449820 |  | 1 |  | 1
8448577501 | PLATINUM | [NAME] | US | 2012-03-29 00:00:00 | 2 |  |  |  | 8206496735 |  | 1 |  | 1
8503518596 | GOLD | [NAME] | US | 2012-05-29 00:00:00 | 2 |  |  |  | 8219114250 |  | 1 |  | 1
8796533379 | GOLD | [NAME] | US | 2012-04-28 00:00:00 | 1 |  |  |  | 8448577501 |  |  | 1 | 1
8811307853 | GOLD | PPXMN | NL | 2011-04-03 00:00:00 | 1 |  |  |  | 8503518596 |  |  | 1 | 1
8811307853 | BLACK | PPXMN | DE | 2011-01-05 00:00:00 | 3 |  |  |  | 8567232761 | 1 |  |  | 1
8219114250 | GOLD | PPXMN | AU | 2011-12-04 00:00:00 | 2 |  |  |  | 8796533379 |  |  | 1 | 1
8182449820 | GOLD | PPXMN | TW | 2011-04-07 00:00:00 | 3 |  |  |  | 8811307853 |  | 2 |  | 2
8206496735 | GOLD | PPXMN | CN | 2011-09-05 00:00:00 | 1 |  |  |  | 8815879251 | 5 | 1 | 1 | 7
8815879251 | GOLD | PPBKK | MY | 2011-08-08 00:00:00 | 14 |  |  |  | 8910102045 | 1 | 2 | 1 | 4
8815879251 | GOLD | PPBKK | MY | 2012-08-08 00:00:00 | 14 |  |  |  | Grand Total | 10 | 9 | 6 | 25
8005707061 | GOLD | PPBKK | JP | 2011-02-01 00:00:00 | 4
8005707061 | GOLD | PPBKK | JP | 2012-02-01 00:00:00 | 4
8910102045 | GOLD | PPBKK | MY | 2011-09-01 00:00:00 | 4
8910102045 | GOLD | PPBKK | MY | 2011-09-01 00:00:00 | 4
8815879251 | GOLD | PPBKK | MY | 2010-08-07 00:00:00 | 14
8910102045 | GOLD | PPBKK | MY | 2012-06-01 00:00:00 | 4
8815879251 | GOLD | PPBKK | MY | 2010-08-08 00:00:00 | 14
8815879251 | GOLD | PPBKK | MY | 2010-08-06 00:00:00 | 14
8815879251 | GOLD | PPBKK | MY | 2010-08-15 00:00:00 | 14
8005707061 | GOLD | PPBKK | JP | 2010-03-01 00:00:00 | 4
8005707061 | GOLD | PPBKK | JP | 2010-04-01 00:00:00 | 4
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 8c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | - | 4 | 11 | 32 | 61 | 66 | 71 | 12 | 257
Cap/Floor | 5 | 16 | 17 | 22 | 54 | 31 | 16 | - | 161
Debt Option | - | - | - | - | - | - | - | - | -
Exotic | - | - | - | - | - | - | - | - | -
Fixed-Fixed | - | 2 | - | 1 | 3 | 1 | - | - | 7
Fixed-Float | 97 | 110 | 477 | 1175 | 4905 | 5418 | 3365 | 1203 | 16750
FRA | 83 | 390 | 644 | 388 | 2 | - | - | - | 1507
Inflation | 16 | 5 | 29 | 58 | 141 | 148 | 133 | 55 | 585
OIS | 99 | 57 | 100 | 136 | 147 | 31 | 15 | 3 | 588
Swaption | - | - | 2 | 71 | 305 | 300 | 539 | 188 | 1405
TOTAL | 300 | 584 | 1280 | 1883 | 5618 | 5995 | 4139 | 1461 | 21260
Spreadsheet: 783412d1654788095-retrieving-results-based-on-multiple-criteria-from-drop-down-menu-brochure
Sheet: Updates

 | Requester's Country | Country changes | Product Category | Billable Item Description (Product Name) | Type of fee | Product Owner | Currency | current prices
 | Romania | Romania |  | Current Account Maintenance
Spreadsheet: kimberly_watson__20576__Index to Index Hedge Strategy Cal 02 and 03
Sheet: Yr. 2002

Revenue Year | Shipper | Term | Volume MMBtu/d | Inception Swaps Spread | Today's Unwind Spread (as of 8/15/01) | Margin Rate Unwind | Target UNHedge Price -      Bearish Market            EP SJ to [NAME] | Target REHedge Price -      Bullish Market            EP SJ to [NAME] | Defensive Strategy If ReHedge Target is Not Met | Comments
2002 | Reliant | Cal 02 | 27500 | 1.32 | 0.61 | 0.71 |  |  |  | Wait until EP SJ to SoCal Needles spread closes inside of [NAME] rate before considering unwinding any/all of the hedge.
 |  | unwind | 5000 |  |  |  | 0.32 |  |  | When target spread of $0.32 is reached, unwind 5,000/d.  Begin to look for rehedge targets (set for $.35).
 |  | unwind | 10000 |  |  |  | 0.26 |  |  | When target spread of $.26 is reached, unwind 10,000/d.  Begin to look for rehedge targets (set for $.35/$.40).
 |  | unwind | 12500 |  |  |  | 0.18 |  |  | When target spread of $.26 is reached, unwind 10,000/d.  Our analysis tells us that If the spread closes inside of the fuel variable, it will not stay this tight for very long.  Begin to look for rehedge targets (set for $.35/$.40).
 |  | rehedge | up to 10,000 |  |  |  |  | 0.35 | $.28/$.37 | Take advantage of upward movement in prices and achieve another $.03/$.09 in price value above the $0.32/$.26 when unhedged.
 |  | rehedge | up to 10,000 |  |  |  |  | 0.4 | $.22/$.35 | Take advantage of upward movement in prices and achieve another $.14/$.22 in price value above the $.32/$.26 when unhedged.
 |  | rehedge | 7500 |  |  |  |  | 0.65 | > $.22 | Keep last 7,500/d open to capture full potiental of upward movement in market.
Spreadsheet: 835509d1688635953-text-split-then-create-spilling-table-textsplit
Sheet: Feuil1

 |  |  |  |  |  |  | EXPECTED RESULT (SPILLING ARRAY)
values |  |  | values |  |  |  | value1 | value2 | value3 | value4 |  |  | value2 | value3 | value4
value1:554,value2:36,value3:987 |  |  |  |  |  |  | 554 | 36 | 987 |  |  | 554 | 36 | 987
value1:54,value2:396,value4:52 |  |  | value1:54,value2:396,value4:52 |  |  |  | 54 | 396 |  | 52 |  | 54 | 396 |  | 52
value3:594,value2:6,value5:5,value6:10 |  |  | value3:594,value2:6,value5:5,value6:10 |  |  |  |  | 6 | 594 |  |  |  | 6 | 594
 |  |  |  |  |  |  |  | value2 | value3 | value4 | value5 | value6
 |  |  |  |  |  |  | 554 | 36 | 987
 |  |  |  |  |  |  | 54 | 396 |  | 52
 |  |  |  |  |  |  |  | 6 | 594 |  | 5 | 10
 |  |  |  |  |  |  |  | value2 | value3 | value4 | value5 | value6
 |  |  |  |  |  |  | 554 | 36 | 987
 |  |  |  |  |  |  | 54 | 396 |  | 52
 |  |  |  |  |  |  |  | 6 | 594 |  | 5 | 10
Spreadsheet: 807235d1669814750-transfer-of-data-from-a-master-sheet-to-other-sheets-quest-2-1-
Sheet: cash in hand

Helper |  | Date | Description | Debit | Credit | Debit | Credit |  | Hand
Spreadsheet: 726984d1617635669-how-to-filter-out-by-group-book1
Sheet: Sheet1

Name | Type | Saying | Rank | Group | Support Needed
Poppy | A | Go get it | 2 | Blue | Doctor, Dentist, Farmer, Vet
Lovely | B | Alright there | 1 | Red | Doctor, [NAME]
Happy | A | Yes and all the way | 4 | Red | Vet, [NAME], Sales
Sad | C | No way not today | 3 | Yellow | Doctor, [NAME], Sales
Gloomy | D | This is the worst | 5 | Yellow | Sales, Attorney, IT
Spreadsheet: 172047d1343967625-calculate-rate-increases-based-on-financial-year-and-start-dates-help-me
Sheet: Sheet1

 |  |  | 01/07/2008 - 30/06/2009 |  | 01/07/2009 - 30/06/2010 |  | 01/07/2010 - 30/06/2011 |  | 01/07/2011 - 30/06/2012 |  | 01/07/2012 - 30/06/2013
Apprentice | Start Date | End Date | Period 1 | Period 2 | Period 1 | Period 2 | Period 1 | Period 2 | Period 1 | Period 2 | Period 1 | Period 2
[NAME] | 2009-02-03 00:00:00 | 2013-02-02 00:00:00 | 0 | ($5 x 38 hours) x weeks between 3/02/09 - 30/06/2009 | ($5 x 38 hours) x weeks between 1/07/09 - 2/02/2010 | ($6 x 38 hours) x weeks between 3/02/10 - 30/06/2010 | ($6 x 38 hours) x weeks between 1/07/10 - 2/02/2011 | ($7 x 38 hours) x weeks between 3/02/11 - 30/06/2011 | ($7 x 38 hours) x weeks between 1/07/11 - 2/02/2012 | ($8 x 38 hours) x weeks between 3/02/12 - 30/06/2012 | ($8 x 38 hours) x weeks between 1/07/12 - 2/02/2013 (End) | 0
 |  |  |  | 3/02/09 - 2/02/10 |  | 3/02/10 - 2/02/11 |  | 3/02/11 - 2/02/12 |  | 3/02/12 - 2/02/13
Rate | [NAME] | Weekly Hours
1st Year | 5 | 38
2nd Year | 6 | 38
3rd Year | 7 | 38 |  |  |  |  | Legend
4th Year | 8 | 38 |  |  |  |  | Would like as a formula
 |  |  |  |  |  |  | Do not want on the page
Spreadsheet: 46818d1245760942-daily-weekly-monthly-data-consolidation-daily-weekly-monthly-data-analysis
Sheet: Weekly Calcs - Lookup Table

Lookup Tables & Settings
-5 weekday [NAME] | +1 weekday string | concatenated   -5+1 weekday string | # Days in Week | Last Weekday of Week | Explanation
34563 | any |  | 0 | 0
45634 | any |  | 0 | 0
56345 | any |  | 0 | 0
34562 | any |  | 0 | 0 | normal 5-day workweek (but not last weekday)
45623 | any |  | 0 | 0
56234 | any, other than 2,3, |  | 0 | 0
62345 | any, other than 2,3, |  | 0 | 0
23456 | any |  | 5 |  | normal 5-day workweek (no holidays)
56456 | any |  | 3 | 6 | Mon/Tues (1/2) = public holiday
63456 | any |  | 4 | 6 | Mon (2) = public holiday
62456 | any |  | 4 | 6 | [NAME] (3) = public holiday
62356 | any |  | 4 | 6 | Wed (4) = public holiday
62346 | any |  | 4 | 6 | Thurs (5) = public holiday
56234 | 2 |  | 3 | 4 | Thurs/Fri (5/6) = public holidays, since next trading day is Monday
56234 | 3 |  | 3 | 4 | Thurs/Fri /Monday (5/6/2) = public holidays, since next trading day is Tuesday
45645 | 2 |  | 2 | 5 | Mon/Tues/Fri (2/3/6)= public holidays
45645 | 3 |  | 2 | 5
42345 | 2 |  | 4 | 5 | Previous Thurs/Fri+ Current Friday Holiday
42346 | 2 |  | 4 | 6 | Previous Thurs/Fri+ Current Thurs Holiday
52345 | 2 |  | 4 | 5 | Previous Fri+ Current Friday Holiday
52345 | 3 |  | 4 | 5 | Previous Fri+ Current Friday Holiday, Next Mon Holiday
53456 | 2 |  | 4 | 5 | Previous Fri+Current Mon Holiday
56236 | 2 |  | 3 | 6 | Wed/Thurs = Public Holidays
56256 | 2 |  | 3 | 6 | Tues/Wed = Public Holidays
62345 | 2 |  | 4 | 5 | Fri (6) = public holiday
62345 | 3 |  | 4 | 5
62346 | 2 |  | 4 | 6
62346 | 3 |  | 4 | 6
62456 | 2 |  | 4 | 6
 | Need to Test Next Day IF Right Hand character (=current day) is not=6 (Friday) to see if end of week or not
Spreadsheet: 791503d1660398594-formula-to-merge-duplicate-and-textjoin-sample-3-
Sheet: Before

Order ID | Task Type | Description
SGAAW000955282 | Delivery | Order - SGAAW000955282\nITEM ID: 2861446\nDESCRIPTION: ADULT KICKSTAND 300 .\n(QTY: 1.0)\n(WEIGHT: 0.356)\n(TOTAL WEIGHT: 0.86)\n
SGAAW000955282 | Delivery | Order - SGAAW000955282\nITEM ID: 2249132\nDESCRIPTION: TREKKING RIVERSIDE 500 CN FR 1 M : 1M65-1M75\n(QTY: 1.0)\n(WEIGHT: 14.1)\n(TOTAL WEIGHT: 14.1)\n
SGAAW000955078 | Delivery | Order - SGAAW000955078\nITEM ID: 4480949\nDESCRIPTION: RIVERSIDE 500 6-9 BLACK CN FR SEA USA 20"\n(QTY: 1.0)\n(WEIGHT: 13.5)\n(TOTAL WEIGHT: 13.5)\n
SGAAW000955644 | Delivery | Order - SGAAW000955644\nITEM ID: 1319918\nDESCRIPTION: BIKE LOCK 300 COMBINAISON .\n(QTY: 1.0)\n(WEIGHT: 0.484)\n(TOTAL WEIGHT: 0.49)\n
SGAAW000955644 | Delivery | Order - SGAAW000955644\nITEM ID: 2249132\nDESCRIPTION: TREKKING RIVERSIDE 500 CN FR 1 M : 1M65-1M75\n(QTY: 1.0)\n(WEIGHT: 14.1)\n(TOTAL WEIGHT: 14.1)\n
Order ID | Task Type | Desc
SGAAW000955078 | Delivery | Order - SGAAW000955078\nITEM ID: 4480949\nDESCRIPTION: RIVERSIDE 500 6-9 BLACK CN FR SEA USA 20"\n(QTY: 1.0)\n(WEIGHT: 13.5)\n(TOTAL WEIGHT: 13.5)\n
SGAAW000955282 | Delivery | Order - SGAAW000955282\nITEM ID: 2861446\nDESCRIPTION: ADULT KICKSTAND 300 .\n(QTY: 1.0)\n(WEIGHT: 0.356)\n(TOTAL WEIGHT: 0.86)\n Order - SGAAW000955282\nITEM ID: 2249132\nDESCRIPTION: TREKKING RIVERSIDE 500 CN FR 1 M : 1M65-1M75\n(QTY: 1.0)\n(WEIGHT: 14.1)\n(TOTAL WEIGHT: 14.1)\n
SGAAW000955644 | Delivery | Order - SGAAW000955644\nITEM ID: 1319918\nDESCRIPTION: BIKE LOCK 300 COMBINAISON .\n(QTY: 1.0)\n(WEIGHT: 0.484)\n(TOTAL WEIGHT: 0.49)\n Order - SGAAW000955644\nITEM ID: 2249132\nDESCRIPTION: TREKKING RIVERSIDE 500 CN FR 1 M : 1M65-1M75\n(QTY: 1.0)\n(WEIGHT: 14.1)\n(TOTAL WEIGHT: 14.1)\n
Spreadsheet: 89017d1288802483-counting-number-of-events-after-a-specific-hour-book1
Sheet: Sheet1

Time | Event
08:00:00 | 1 |  | Total | 22
09:00:00 | 1 |  | Start Time | 13:00:00
10:00:00 | 2 |  | End Time | 17:00:00
11:00:00 | 3 |  | Total | 9
12:00:00 | 2
13:00:00 | 2
14:00:00 | 2
15:00:00 | 2
16:00:00 | 2
17:00:00 | 1
18:00:00 | 1
19:00:00 | 1
20:00:00 | 1
21:00:00 | 1
Spreadsheet: 733223d1621444288-populating-certain-rows-using-2-data-validation-lists-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Reference Project
* I have a dropdown list in cell [NAME], I'd like that dropdown to be the main "driver" when populating Column L (which it currently is). |  |  |  |  |  |  |  |  |  |  |  | Las Vegas - 9/11/2020
*If I change Las Vegas to other cities such as Dallas in L6 and Thailand in [NAME] (using a dropdown as well), this issue I'm having is when I go back and change M4, I obviously lose the changes I've made in L6 and [NAME]. |  |  |  |  |  |  |  |  |  |  |  | $/SF
*I'd like a formula or Macro to say, M4 populates column L but if I change any cells in column L to other cities (using a dropdown list) leave those cities "as is" even if I go back and change M4 again. |  |  |  |  |  |  |  |  |  |  | Dallas - 8/4/2020
 |  |  |  |  |  |  |  |  |  |  | Thailand - 6/11/2021
Spreadsheet: 835260d1688462652-allocate-values-off-year-and-frequency-of-activity-over-years-maintanance-allocation
Sheet: Input

 | Description | Frequency (Months) | Frequency (Years) | First Repair Date | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035
 | Repair A | 12 | 1 | 2024
 | Repair B | 24 | 2 | 2026
 | Repair C | 36 | 3 | 2023
 | Repair D | 48 | 4 | 2025
 | Repair E | 60 | 5 | 2027
Desired Outcome
 | Repair A occurs every 12 months,
 |  | Formula - Allocate "1" to all years from First Repair Date 2024
 | Repair B occurs every 24 months,
 |  | Formula - Allocate "1" every 2 years from First Repair Date 2026
 | Repair C occurs every 36 months,
 |  | Formula - Allocate "1" every 3 years from First Repair Date 2023
 | Repair D occurs every 48 months,
 |  | Formula - Allocate "1" every 4 years from First Repair Date 2025
 | Repair E occurs every 48 months,
 |  | Formula - Allocate "1" every 5 years from First Repair Date 2027
Spreadsheet: 411749d1438718649-mandays-calculation-mandays2
Sheet: Sheet1

 |  |  | 2015-08-01 00:00:00 | 2015-08-02 00:00:00 | 2015-08-03 00:00:00 | 2015-08-04 00:00:00 | 2015-08-05 00:00:00 | 2015-08-06 00:00:00 | 2015-08-07 00:00:00 | 2015-08-08 00:00:00 | 2015-08-09 00:00:00 | 2015-08-10 00:00:00 |  |  | ABC |  |  | DEF |  |  | SAME FOR ALL PROJECTS
Name | Department | Project |  |  |  |  |  |  |  |  |  |  |  | ABC-P | ABC-A | ABC-0.5 | DEF-P | DEF-A | DEF-0.5
sachin | animation | ABC | ABC-P |  | ABC-A |  | ABC-0.5 |  |  |  |  |  |  |  |  |  | COUNTIF AGAIN | COUNTIF AGAIN | COUNTIF AGAIN
rahul | comp | DEF |  | DEF-P |  |  | DEF-A |  | DEF-0.5
virat | light | XYZ | XYZ-P |  | XYZ-A
sachin | comp
rahul | light
virat | animation
 | project | dept
 | ABC | Animation | need total mandays counts in this cell as per the project department will be same for all the projects
 |  | comp | need total mandays counts in this cell as per the project department will be same for all the projects
 |  | lighting | need total mandays counts in this cell as per the project department will be same for all the projects
Spreadsheet: 229726d1366540082-how-to-get-the-content-of-the-row-as-the-content-of-a-column-how-to-get-thecontent
Sheet: Sheet1

subject
MATHS
subject
BIOLOGY
subject
PHYSICS
subject
CHEMISTRY
subject
ENGLISH
Spreadsheet: 196898d1354138995-rank-errors-and-automatic-sorting-timer-score-sheets-2-
Sheet: Day 1 PRINTOUT

 | [NAME] SCORESHEET (DAY 1)
 | Date:
Day 1 Post | Bib | Musher's Name | Day 1 Finish Time
1 | 44 | [NAME] | 01:08:11
2 | 43 | [NAME] | 01:08:26
3 | 41 | [NAME] | 01:11:56
4 | 40 | [NAME] | 01:14:34
5 | 42 | [NAME] | 01:14:40
6 | 75 | Brent | 01:15:56
6 | 71 | Lester | 01:15:56
6 | 49 | [NAME] | 01:15:56
6 | 46 | [NAME] | 01:15:56
6 | 45 | [NAME] | 01:15:56
Spreadsheet: 706450d1606716331-need-help-calculating-sliding-scale-commission-sliding-scale-commission-calculator
Sheet: Summary

$45k / 15% climbing scale / $12.5k target |  |  |  |  |  |  |  |  |  |  |  | Estimated Annual Income (Photos / floor plan only)
 | Target   ([NAME]) | Actual Revenue (Gross) | Actual Revenue (Net) | Net revenue over target | $12501-$27500 @ 15% | $27501-$37500 @ 22.5% | $37501- @ 30% | Bonus (Gross) | SGC on Bonus | Total Bonus |  | Salary: | 45000
Q1: JUL-SEP | 12500 |  |  |  | 2249.85 | 2249.77 | 301.95 |  |  |  |  | Profit Share to Date:
Q2: OCT-DEC | 12500 |  |  |  | 2249.85 | 2249.77 | 301.95 |  |  |  |  | Superannuation to Date:
Q3: JAN-MAR | 12500 |  |  |  | 2249.85 | 2249.77 | 301.95 |  |  |  |  | Running Total:
Q4: APR-JUN | 12500 |  |  |  | 2249.85 | 2249.77 | 301.95 |  |  |  |  | Percentage revenue
YTD Actual: