tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 738848d1625282273-predict-future-re-orders-of-a-product-product-repurchase-model-template
Sheet: josephteh

Product Repurchase Estimates |  |  |  | https://www.excelforum.com/newreply.php?do=postreply&t=1344108
 |  |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24
 | REPURCHASE ASSUMPTIONS
PRODUCT 1 -  UNIT SALES |  |  | Time Lag
- First Orders (Units) | Reorder | % | (Months) | 10000
- Repeat Orders | 1 | 0.2 | 2
 | 2 | 0.35 | 2
 | 3 | 0.5 | 2
 | 4 | 0.5 | 2
 | 5 | 0.5 | 2
 | 6 | 0.5 | 2
PRODUCT 2 -  UNIT SALES |  |  | Time Lag
- First Orders (Units) | Reorder | % | (Months) | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106
- Repeat Orders | 1 | 0.2 | 2
 | 2 | 0.35 | 2
 | 3 | 0.5 | 2
 | 4 | 0.5 | 2
 | 5 | 0.5 | 2
 | 6 | 0.5 | 2
PRODUCT 3 -  UNIT SALES |  |  | Time Lag
- First Orders (Units) | Reorder | % | (Months) | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106
- Repeat Orders | 1 | 0.2 | 2
 | 2 | 0.35 | 2
 | 3 | 0.5 | 2
 | 4 | 0.5 | 2
 | 5 | 0.5 | 2
 | 6 | 0.5 | 2
Spreadsheet: 605346d1547042971-alphabetize-column-while-moving-associated-data-alphabetize-help-please
Sheet: BrandB

PartnerName
 | 561.7683218689615 | 840.9569084418662 | 895.8280128623488 | 141.058027968298 | 737.9076737540595 | 969.4922989748226 | 84.49100822085754
 | 361.9269439773046 | 986.9214242968475 | 697.1894877925855 | 275.8044569464321 | 11.59192301058964 | 144.0681566126926 | 587.5104859806559
 | 855.4299768899725 | 805.1013890943659 | 759.8847067101848 | 992.8147364993347 | 426.4650086172645 | 309.21602388995 | 914.7461414648468
 | 546.8640602586315 | 875.1091208691229 | 981.9691773116718 | 222.3667479219544 | 34.20282237856398 | 871.0056892709138 | 180.2793686761182
 | 229.13287993346 | 425.4799878179641 | 404.1564052144648 | 214.9325150333856 | 811.0990905304415 | 848.4318501106515 | 190.4122992408175
Spreadsheet: 129730d1321852265-diagonal-updation-required-diagonal-v3
Sheet: Before

 |  | 0 | 1 | 2 | 3 | 4
 | 2011-10-01 00:00:00 | 1 | 5 | 8 | 10
 | 2011-10-02 00:00:00 | 2 | 6 | 9
 | 2011-10-03 00:00:00 | 3 | 7
 | 2011-10-04 00:00:00 | 4
 | 2011-10-05 00:00:00
 | 2011-10-06 00:00:00
 | 2011-10-07 00:00:00 |  |  |  |  |  | Key
 | 2011-10-08 00:00:00 |  |  |  |  |  |  | Need to update these values by copying from another diagonal in Generated 1 Sheet
 |  |  |  |  |  |  |  | Some time in the future I would need to update this by copying from another diagonal (Generated-2)and so on….
Spreadsheet: 169181d1342717101-count-a-column-based-on-values-in-another-column-0a5
Sheet: Sheet1

Row Labels | Units | Total Units | Instock
1000172A--- | 2 | 2 | 1 |  |  | 1st solution
101534--- | 2 | 2 | 1
 | 2 | 2 | 1
COXCOBB | 2 | 2 | 1
000NORK | 2 | 2 | 1
Grand Total | 10 | 10
Spreadsheet: 787179d1657657007-trying-to-filter-out-information-into-a-new-sheet-tasks-and-projects2
Sheet: Customization

 | TO-DO LIST
 |  |  | Priorities |  |  | Status |  |  | In Progress
 |  |  | 1 | Level One |  | 1 | Pre-Planning |  | 1
 |  |  | 2 | Level Two |  | 2 | Paused |  | 2
 |  |  | 3 | Level Three |  | 3 | In Progress |  | 3
 |  |  | 4 | Level Four |  | 4 | 50% done |  | 4
 |  |  | 5 | Level Five |  | 5 | Needs Attention |  | 5
 |  |  | 6 | Level Six |  | 6 | Complete |  | 6
 |  |  | 7 |  |  | 7 |  |  | 7
 |  |  | 8 |  |  | 8 |  |  | 8
 |  |  | 9 |  |  | 9 |  |  | 9
 |  |  | 10 |  |  | 10 |  |  | 10
Spreadsheet: 739924d1626088788-combing-indirect-with-a-hlookup-and-with-a-calculation-combine
Sheet: Overview

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROP DOWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | forumla | ([NAME]) |  |  |  |  |  | Results should be
 | Ealing |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January |  |  |  |  |  |  | [NAME] | 0.9
 | Fulham |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February |  |  |  |  |  |  | Ealing | 0.5
 | Harlesden |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March |  |  |  |  |  |  | Fulham | 0.4090909090909091
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April |  |  |  |  |  |  | Harlesden | 0.2631578947368421
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  |  |  |  |  | [NAME] | 0.3888888888888889
 | Hounslow |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0
 | Kingston |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hounslow | 1
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kingston | 0.75
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0
 | Uxbridge |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.6538461538461539
 | WANDSWORTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Uxbridge | 0.8333333333333334
 | Wembley |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WANDSWORTH | 0.6086956521739131
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wembley | 0.8709677419354839
January
February
March
April
May
June
July
August
September
October
November
December
Spreadsheet: 67432d1268073287-sum-sumif-or-sumproduct-projections
Sheet: Sheet1

Project # | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | 2010-01-02 00:00:00 | 2010-01-29 00:00:00 | 2010-01-30 00:00:00 | 2010-02-26 00:00:00 | 2010-02-27 00:00:00 | 2010-04-02 00:00:00 | 2010-04-03 00:00:00 | 2010-04-30 00:00:00 | 2010-05-01 00:00:00 | 2010-05-28 00:00:00 | 2010-05-29 00:00:00 | 2010-07-02 00:00:00 | 2010-07-03 00:00:00 | 2010-07-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-27 00:00:00 | 2010-08-28 00:00:00 | 2010-10-01 00:00:00 | 2010-10-02 00:00:00 | 2010-10-29 00:00:00 | 2010-10-30 00:00:00 | 2010-11-26 00:00:00 | 2010-11-27 00:00:00 | 2010-12-31 00:00:00
161 | 800 |  | 800 |  | 800 |  | 816 |  | 816 |  | 816 |  | 816 |  | 816 |  | 816 |  | 816 |  | 816 |  | 816
164 | 0 |  | 400 |  | 400 |  | 408 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
174 | 0 |  | 400 |  | 400 |  | 408 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Name | Project Number | Start Date | End Date | Living Expense Allowance | Living Expense | Work Hours Per Week
 | Black, [NAME] | 161 | 2010-01-01 00:00:00 | 2010-12-31 00:00:00 | Yes | 58 | 40
 | Doe, [NAME] | 174 | 2010-01-15 00:00:00 | 2010-04-30 00:00:00 | Yes | 58 | 40
 | Doe, [NAME] | 164 | 2010-01-15 00:00:00 | 2010-04-30 00:00:00 | Yes | 58 | 40
 | Little, [NAME] | 161 | 2010-01-01 00:00:00 | 2010-12-31 00:00:00 | Yes | 58 | 40
 | Salary
 | Effective Date |  | 2009-04-01 00:00:00 |  | 2010-04-01 00:00:00
 |  |  | Per Hour | O.T. | Per Hour | O.T.
 |  | Black, [NAME] | 10 | 15 | 10.2 | 15.3
 |  | Doe, [NAME] | 10.5 | 15.75 | 10.71 | 16.065
 |  | Smith, [NAME] | 10.35 | 15.525 | 10.557 | 15.8355
 |  | Green, [NAME] | 11.25 | 16.875 | 11.5875 | 17.38125
 |  | Little, [NAME] | 13.45 | 13.45 | 13.988 | 13.45
Spreadsheet: 873105d1719518504-formula-referencing-2-different-sheets-book1
Sheet: Flights

2024-05-22 00:00:00 | 0 | 34.3042287494086 | -77.9225104097051 | 0 | P-GPS | 11 | 100 | 8.624 | 4.312 | 4.312 | [NAME] | Flight mode changed to P-GPS. | Aircraft in Warning Zone (Class E Airspace). Fly with caution (Code: 190002).
2024-05-22 00:00:00 | 0.1 | 34.3042287571714 | -77.9225103611378 | 0 | Starting Motors | 11 | 100 | 8.624 | 4.312 | 4.312 | [NAME] | Flight mode changed to Starting Motors.
2024-05-22 00:00:00 | 0.2 | 34.3042287789111 | -77.9225102716727 | 0 | Starting Motors | 11 | 100 | 8.626 | 4.313 | 4.313 | [NAME]
2024-05-22 00:00:00 | 0.3 | 34.3042287427775 | -77.9225102164395 | 0 | Starting Motors | 11 | 100 | 8.626 | 4.313 | 4.313 | [NAME]
2024-05-22 00:00:00 | 0.4 | 34.3042286937565 | -77.9225102076761 | 0 | Starting Motors | 11 | 100 | 8.626 | 4.313 | 4.313 | [NAME] | Data Recorder File Index is 49.; [NAME] to Home (RTH) altitude to 30 m (98 ft).
2024-05-22 00:00:00 | 0.5 | 34.3042286385848 | -77.9225102055034 | 0 | Starting Motors | 11 | 100 | 8.626 | 4.313 | 4.313 | [NAME]
2024-05-22 00:00:00 | 0.6 | 34.3042286230576 | -77.9225102195068 | 0 | Starting Motors | 11 | 100 | 8.626 | 4.313 | 4.313 | [NAME]
2024-05-22 00:00:00 | 0.7 | 34.304228601129 | -77.9225103699272 | 0 | Starting Motors | 11 | 100 | 8.626 | 4.313 | 4.313 | [NAME]
2024-05-22 00:00:00 | 0.8 | 34.3042285601182 | -77.9225104349661 | 0 | Starting Motors | 11 | 100 | 8.626 | 4.313 | 4.313 | [NAME]
2024-05-22 00:00:00 | 0.9 | 34.3042285142759 | -77.9225105049883 | 0 | Starting Motors | 11 | 100 | 8.626 | 4.313 | 4.313 | [NAME]
2024-05-22 00:00:00 | 1 | 34.3042284578862 | -77.9225104907075 | 0 | Starting Motors | 11 | 100 | 8.626 | 4.313 | 4.313 | [NAME]
2024-05-22 00:00:00 | 1.1 | 34.3042283504919 | -77.9225105100934 | 0 | Starting Motors | 11 | 100 | 8.626 | 4.313 | 4.313 | [NAME]
2024-05-22 00:00:00 | 1.2 | 34.3042282920975 | -77.9225104491484 | 0 | Manual Takeoff | 11 | 100 | 8.534 | 4.313 | 4.313 | [NAME] | Flight mode changed to [NAME].
2024-05-22 00:00:00 | 1.3 | 34.3042282307882 | -77.9225103849936 | 0 | Manual Takeoff | 11 | 100 | 8.509 | 4.255 | 4.254 | [NAME]
2024-05-22 00:00:00 | 1.4 | 34.3042281741526 | -77.9225103624446 | 0 | Manual Takeoff | 11 | 100 | 8.509 | 4.255 | 4.254 | [NAME]
2024-05-22 00:00:00 | 1.5 | 34.3042280812906 | -77.9225102552866 | 0 | Manual Takeoff | 11 | 100 | 8.509 | 4.255 | 4.254 | [NAME]
2024-05-22 00:00:00 | 1.6 | 34.3042280742703 | -77.9225102564663 | 0 | Manual Takeoff | 11 | 100 | 8.509 | 4.255 | 4.254 | [NAME]
2024-05-22 00:00:00 | 1.7 | 34.3042280696635 | -77.9225102588775 | 0 | Manual Takeoff | 11 | 100 | 8.509 | 4.255 | 4.254 | [NAME]
2024-05-22 00:00:00 | 1.8 | 34.3042280830965 | -77.9225102218921 | 0 | Manual Takeoff | 11 | 100 | 8.509 | 4.255 | 4.254 | [NAME]
Spreadsheet: 636604d1565375671-help-calendar-correction-employee-absence-schedule-current-6-5-19
Sheet: Employee Names

 | Employee Names
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 31
 | Employee Names |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | January
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February | March
 | Lynda |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March | May
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April | July
 | Heather |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May | August
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June | October
 | Emili |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July | December
 | Amber |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
 | Meredith |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
 | Julie |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 | Elli |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 531792d1501874712-index-match-by-worksheet-name-test
Sheet: TH

[NAME] |  | 2017-08-01 00:00:00 |  |  | 2017-08-02 00:00:00 |  |  | 2017-08-03 00:00:00 |  |  | 2017-08-04 00:00:00 |  |  | 2017-08-07 00:00:00 |  |  | 2017-08-08 00:00:00 |  |  | 2017-08-09 00:00:00 |  |  | 2017-08-10 00:00:00 |  |  | 2017-08-11 00:00:00 |  |  | 2017-08-14 00:00:00 |  |  | 2017-08-15 00:00:00 |  |  | 2017-08-16 00:00:00
 |  | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per | Widgets | Time | Time per
Task Group ID | Task Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avaerage
Off Premise Settlements- Volume | Emails to/ from Vendors | 1 | 5 |  | 1 | 5 |  | 1 | 6 |  | 1 | 6 |  | 5 | 6 |  | 5 | 6 |  | 5 | 6 |  | 5 | 6 |  | 5 | 6 |  | 5 | 6 |  | 5 | 6 |  | 5 | 6
Off Premise Settlements- Volume | Off Premise Incoming/ Outgoing Telephone Calls Under 0-5min | 2 | 5 |  | 2 | 5 |  | 2 | 6 |  | 2 | 6 |  | 6 | 6 |  | 6 | 6 |  | 6 | 6 |  | 6 | 6 |  | 6 | 6 |  | 6 | 6 |  | 6 | 6 |  | 6 | 6
Off Premise Settlements- Volume | ATM Replenishment Order Creation | 3 | 5 |  | 3 | 5 |  | 3 | 6 |  | 3 | 6 |  | 7 | 6 |  | 7 | 6 |  | 7 | 6 |  | 7 | 6 |  | 7 | 6 |  | 7 | 6 |  | 7 | 6 |  | 7 | 6
Off Premise Settlements- Volume | E-cash Ordering | 4 | 5 |  | 4 | 5 |  | 4 | 6 |  | 4 | 6 |  | 8 | 6 |  | 8 | 6 |  | 8 | 6 |  | 8 | 6 |  | 8 | 6 |  | 8 | 6 |  | 8 | 6 |  | 8 | 6
Off Premise Settlements- Volume | Vault Cash Ordering | 5 | 5 |  | 5 | 5 |  | 5 | 6 |  | 5 | 6 |  | 9 | 6 |  | 9 | 6 |  | 9 | 6 |  | 9 | 6 |  | 9 | 6 |  | 9 | 6 |  | 9 | 6 |  | 9 | 6
Off Premise Settlements- Volume | Number of settlement errors (monitoring) | 6 | 5 |  | 6 | 5 |  | 6 | 6 |  | 6 | 6 |  | 1 | 6 |  | 1 | 6 |  | 1 | 6 |  | 1 | 6 |  | 1 | 6 |  | 1 | 6 |  | 1 | 6 |  | 1 | 6
Off Premise Settlements- Volume | Replenishment Monitoring | 7 | 5 |  | 7 | 5 |  | 7 | 6 |  | 7 | 6 |  | 2 | 6 |  | 2 | 6 |  | 2 | 6 |  | 2 | 6 |  | 2 | 6 |  | 2 | 6 |  | 2 | 6 |  | 2 | 6
Spreadsheet: 704912d1605803632-excel-lookup-with-multiple-date-criteria-sample_prob
Sheet: Sheet1

 | RFP_TrackerName | [NAME] | RFP_SubmittedDate | RFP_StartDate | RFP_EndDate | RFP_ID
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2019-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-09-30 00:00:00 | 1008
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2020-08-28 00:00:00 | 2020-08-28 00:00:00 | 2021-08-28 00:00:00 | 1124
 | LMNOP Inc. | San Diego, CA -- Chicago, IL | 2020-06-01 00:00:00 | 2020-06-01 00:00:00 | 2021-05-30 00:00:00 | 1181
 | Executed_TrackerName | [NAME] | ExecutedDate | Desired Result | Column1
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2019-09-30 00:00:00 | Executed before RFP Start
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2021-08-29 00:00:00 | Executed after RFP End
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2020-08-27 00:00:00 | 1008
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2020-09-01 00:00:00 | 1124 | When ExecutedDate has overlap with Start/End Date for multiple RFP_IDs, use the SubmittedDate to determine the RFP_ID
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2020-10-01 00:00:00 | 1124
 | LMNOP Inc. | San Diego, CA -- Seattle, WA | 2020-09-15 00:00:00 | Not in RFP
Spreadsheet: 801621d1666274839-need-help-creating-a-dynamic-list-that-sorts-with-count-frequencies-sorted-list-example
Sheet: Sheet1

City - Sorted by Name | Store Count | Sort |  | Sort # | Sorted City | Store Count |  | Sorted List - Use for Analysis
Atlanta | 0 |  |  | 1 |  |  |  | Austin-1
[NAME] | 2 |  |  |  |  |  |  | Austin-2 | Austin-2
Boston | 3 |  |  |  |  |  |  | Charlotte-1 | Boston-1
Charlotte | 1 |  |  |  |  |  |  | Los Angeles-1 | Boston-2
Denver | 0 |  |  |  |  |  |  | Los Angeles-2 | Boston-3
Los Angeles | 4 |  |  |  |  |  |  | Los Angeles-3 | Charlotte-1
Miami | 0 |  |  |  |  |  |  | Los Angeles-4 | Los Angeles-1
Minneapolis | 6 |  |  |  |  |  |  | Minneapolis-1 | Los Angeles-2
New York | 2 |  |  |  |  |  |  | Minneapolis-2 | Los Angeles-3
Philadelphia | 1 |  |  |  |  |  |  | Minneapolis-3 | Los Angeles-4
St. Louis | 0 |  |  |  |  |  |  | Minneapolis-4 | Minneapolis-1
 |  |  |  |  |  |  |  | Minneapolis-5 | Minneapolis-2
 |  |  |  |  |  |  |  | Minneapolis-6 | Minneapolis-3
 |  |  |  |  |  |  |  | New York-1 | Minneapolis-4
 |  |  |  |  |  |  |  | New York-2 | Minneapolis-5
 |  |  |  |  |  |  |  | Philadelphia-1 | Minneapolis-6
 |  |  |  |  |  |  |  | and so on | New York-1
 |  |  |  |  |  |  |  |  | New York-2
 |  |  |  |  |  |  |  |  | Philadelphia-1
Spreadsheet: 156295d1337256599-how-to-copy-data-from-master-list-sheet-to-another-sheet-based-on-category-ifjsss-round-2-data
Sheet: ProAmOpen

THE LANGKAWI INTERNATIONAL
FORMULA JET SKI SUPER SERIES 2012
ROUND 2, PUTRAJAYA
 | Pro Am Open
 | MOTO :
 | CATEGORY   :  4 Stroke Pro Am Open
 | LAPS :  15
 | RACE TIME :
No | RIDER | TEAM | CRAFT | CRAFT TYPE | POINT FROM PREVIOUS ROUND | ROUND 2 |  |  |  | OVERALL POINTS | RANK
 |  |  |  |  |  | MOTO 1 | MOTO 2 | MOTO 3 | MOTO 4
Spreadsheet: 71151d1271862553-how-can-i-show-my-subtotal-in-the-table-but-not-in-the-chart-book1
Sheet: Sheet2

Item | A | B | C | D | E | Total
2101-04-08 00:00:00 | 2 | 3 | 4 | 5 | 67
2101-04-09 00:00:00 | 3 | 5 | 6 | 76 | 12
Subtotal
Spreadsheet: 866261d1713221445-countifs-mutiple-columns-and-criteria-times-heatmap-question-2-
Sheet: Sheet1

DATA |  |  |  |  |  |  |  |  | RESULTING HEATMAP
 |  |  | First Visit |  | Second Visit |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri
2024-04-15 00:00:00 |  | Person 1 | 07:00:00 | 07:45:00 |  |  |  |  | 06:45:00 | 0 | 0 | ETC…
2024-04-15 00:00:00 |  | Person 2 | 07:15:00 | 08:00:00 | 10:15:00 | 11:00:00 |  |  | 07:00:00 | 1 | 0
2024-04-15 00:00:00 |  | Person 3 | 07:30:00 | 09:00:00 |  |  |  |  | 07:15:00 | 2 | 0
2024-04-15 00:00:00 |  | Person 4 | 08:00:00 | 08:30:00 | 10:45:00 | 12:00:00 |  |  | 07:30:00 | 3 | 0
2024-04-16 00:00:00 |  | Person 5 | 09:00:00 | 09:30:00 |  |  |  |  | 07:45:00 | 3 | 0
2024-04-16 00:00:00 |  | Person 6 | 09:30:00 | 10:00:00 |  |  |  |  | 08:00:00 | 3 | 0
2024-04-16 00:00:00 |  | Person 7 | 10:30:00 | 11:00:00 | 12:45:00 | 13:15:00 |  |  | 08:15:00 | 2 | 0
2024-04-16 00:00:00 |  | Person 8 | 11:00:00 | 12:00:00 |  |  |  |  | 08:30:00 | 2 | 0
2024-04-17 00:00:00 |  | ETC... |  |  |  |  |  |  | 08:45:00 | 1 | 0
2024-04-17 00:00:00 |  |  |  |  |  |  |  |  | 09:00:00 | 1 | 1
2024-04-17 00:00:00 |  |  |  |  |  |  |  |  | 09:15:00 | 0 | 1
2024-04-17 00:00:00 |  |  |  |  |  |  |  |  | 09:30:00 | 0 | 2
2024-04-18 00:00:00 |  |  |  |  |  |  |  |  | 09:45:00 | 0 | 1
2024-04-18 00:00:00 |  |  |  |  |  |  |  |  | 10:00:00 | 0 | 1
2024-04-18 00:00:00 |  |  |  |  |  |  |  |  | 10:15:00 | 1 | 0
2024-04-18 00:00:00 |  |  |  |  |  |  |  |  | 10:30:00 | 1 | 1
2024-04-19 00:00:00 |  |  |  |  |  |  |  |  | 10:45:00 | 2 | 1
2024-04-19 00:00:00 |  |  |  |  |  |  |  |  | 11:00:00 | 2 | 2
2024-04-19 00:00:00 |  |  |  |  |  |  |  |  | 11:15:00 | 1 | 1
2024-04-19 00:00:00 |  |  |  |  |  |  |  |  | 11:30:00 | 1 | 1
 |  |  |  |  |  |  |  |  | 11:45:00 | 1 | 1
 |  |  |  |  |  |  |  |  | 12:00:00 | 1 | 1
 |  |  |  |  |  |  |  |  | 12:15:00 | 0 | 0
 |  |  |  |  |  |  |  |  | 12:30:00 | 0 | 0
 |  |  |  |  |  |  |  |  | 12:45:00 | 0 | 1
 |  |  |  |  |  |  |  |  | 13:00:00 | 0 | 1
 |  |  |  |  |  |  |  |  | 13:15:00 | 0 | 1
 |  |  |  |  |  |  |  |  | 13:30:00 | 0 | 0
 |  |  |  |  |  |  |  |  | 13:45:00 | 0 | 0
 |  |  |  |  |  |  |  |  | 14:00:00 | 0 | 0
Spreadsheet: 39890d1238146326-vlookup-query-amended-pricing-sheet
Sheet: Front Sheet

JOB CONTROL SHEET
PROJECT TITLE: |  |  | CLOSING DATE:
CONSULT/CLIENT: |  |  | CONST. PERIOD:
Quote Number: | Q
MATERIALS | (C/F from Pricing Sheet) |  |  |  | 0
GENERAL MATERIALS
CABLES
LIGHT FITTINGS | (C/F from Light fitting sheet) |  |  |  | 0
SWITCHGEAR
SUB TOTAL: |  |  |  |  | 0
FREIGHT
FIXED PRICE ALLOWANCE MATERIAL
MATERIAL TOTAL: |  |  |  |  | 0
LABOUR (Hour working week) [NAME]
A/  Tradesman | 0 | Hours @ |  | P/hour = | 0
[NAME] assistant | 0 | Hours @ |  | P/hour = | 0
C/ |  |  | Total A+B: | 0
D/  Allow for Stat O/H at: |  | 32 | % of C |  | 0
E/  Site Allowance: | 0 | Hours @ |  | P/hour = | 0
F/  Travel Allowance: |  | weeks @ |  | Per week | 0
G/  Boot & Tool: |  | weeks @ | 0 | Per week | 0
H/ Other:
I/  Total Allowances: | 0 | Stats |  | % | 0
J/  Accomodation: |  | weeks @ | 0 | per week | 0
K/  Airfares, Excess & Travel: |  | trips @ | 0 | per trip | 0
L/  Direct Labour:
M/  Staff supervision (as over sheet 2 A): |  |  |  |  | 0
N/   Allow for Stat O/H @ |  |  | % of | 0 | 0
O/  Total Supervision:
 |  |  | Labour total: | 0
PLANT & VEHICLES (As over): | C/F from sheet 2 B) |  |  |  | 0
TOTAL COST OF PRODUCTION: |  |  |  |  | 0
Plus: |  |  | Percent of production = |  | 0
SUB CONTRACTORS P.C./CONT./P.S. AMOUNTS: (C/F from pricing sheet) |  |  |  |  | 0
Plus: |  |  | Percent of PC amounts = |  | 0
SALES TAX
TOTAL SELLING PRICE: |  |  |  |  | 0
FINAL PRICE APPROVED:
Spreadsheet: andy_zipper__264__Broker detail 5-11-01
Sheet: FAILED DEALS SUMMARY

EnronOnline
[NAME] for 5/11/2001
Failed Transactions:
LIFE TO DATE
FAILED TRANSACTION COUNT |  | Commodity
Broker | Failed Reason | Natural Gas | Power | Grand Total
APB Energy, Inc. | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no bid access to product | 1 | 6 | 7
 | [NAME]: counterparty has no offer access to product |  | 1 | 1
 | FAILURE: Limit price violated |  | 8 | 8
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 5 |  | 5
 | FAILURE: Volume not available for base product of hedge | 1 |  | 1
 | FAILURE: Order pended due to limit price violation | 1 | 2 | 3
APB Energy, Inc. Total |  | 9 | 17 | 26
Natsource LLC | FAILURE: counterparty exceeded credit limit |  | 5 | 5
 | [NAME]: counterparty has no bid access to product | 1 | 3 | 4
 | [NAME]: counterparty has no offer access to product |  | 5 | 5
 | FAILURE: Limit price violated | 1 | 6 | 7
 | [NAME]: product violates counterparty term limit |  | 2 | 2
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 | 7 | 8
 | FAILURE: Base product not active for hedge | 1 |  | 1
Natsource LLC Total |  | 4 | 28 | 32
Power Merchants Group, LLC | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no offer access to product | 1 |  | 1
 | FAILURE: Limit price violated | 10 |  | 10
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 2 |  | 2
 | FAILURE: Order pended due to limit price violation | 2 |  | 2
Power Merchants Group, LLC Total |  | 16 |  | 16
Grand Total |  | 29 | 45 | 74
Spreadsheet: 8dc9b8e5-c4d7-4b53-80f5-33d86af1da7a
Sheet: Table 7.1

Monthly Statistical Bulletin
7.1 Population
Quarter | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012–13
Estimated resident population (a) – '000
September | 21617.6 | 22051 | 22128.6 | 22403 | 22823.9
December | 21730.6 | 22131.2 | 22182.8 | 22485.3 | 22918
March | 21859.3 | 22234 | 22265.2 | 22635.4 | 23032.7
June | 21951.7 | 22065.3 | 22323.9 | 22722
Annual change – '000
September | 447.8 | 433.3 | 265.4 | 274.4 | 391.8
December | 467.3 | 400.6 | 254.1 | 302.6 | 397.7
March | 462 | 374.6 | 250.6 | 366.6 | 397.4
June | 453.2 | 286.5 | 258.6 | 382
Annual change – per cent
September | 1.85 | 1.74 | 1.21 | 1.24 | 1.75
December | 1.93 | 1.58 | 1.16 | 1.36 | 1.77
March | 1.89 | 1.44 | 1.14 | 1.65 | 1.76
June | 1.84 | 1.32 | 1.17 | 1.71
(a) At the end of the quarter.
Source: ABS, Australian demographic statistics, Cat. no. 3101.0 | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3101.0&viewtitle=Australian%20Demographic%20Statistics~Sep%202007~Latest~19/03/2008&&tabname=Past%20Future%20Issues&prodno=3101.0&issue=Sep%202007&num=&view=&
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2013-12-17 00:00:00
Spreadsheet: 116604d1311944686-freezing-and-unfreezing-formulas-capex-and-opex-stock-distribution-spreadsheet-test
Sheet: Sheet1

 |  | Stock Out | Prod ID No. | Opex Stock in | Capex Stock In |  | ID No. | opex open stock | opex stock in | opex stock out | Opex Running Stock |  | capex open stock | capex stock in | capex stock out | Capex Running Stock |  | Total Running Stock
 |  | 1 | 001 |  |  |  | 001 | 1 | 0 | 1 | 0 |  | 1 | 0 | 1 | 0 |  | 0
 |  | 1 | 001
 |  |  | 001
 |  |  |  |  |  |  | The figure in C1 is reduces the capex stock to zero, then when another figure is placed in C2 it starts taking stock off the opex stock holding - however if stock is then added to F7 as capex stock comes in it alters the figure in K5 - I need this figure to remain static until capex stock is then exhausted again and opex stock starts being taken.