tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862009d1709814413-in-need-of-formulas-for-my-document-register-please-help-documents-register-aligw
Sheet: Sheet1

No. | Doc. No. | Document Title | CURRENT STATUS |  |  |  | 1st Submittal |  |  |  |  | 2nd Submittal |  |  |  |  | 3rd Submittal
 |  |  | Revision No. | Submitted Date | Review Status | COMPANY Reviewed Date | Revision No. | Submitted Date | Review Status | COMPANY Reviewed Date | Revision Status | Revision No. | Submitted Date | Review Status | COMPANY Reviewed Date | Revision Status | Revision No. | Submitted Date | Review Status | COMPANY Reviewed Date | Revision Status
1 | PM-PD-6002 | Internal Audit Schedule |  |  |  |  | A1 | 2024-01-02 00:00:00 | Accepted | 2024-01-05 00:00:00 | Latest
2 | PM-PD-6171 | Welding Procedure Specification |  |  |  |  | A1 | 2024-02-02 00:00:00 | Rejected | 2024-02-04 00:00:00 | Superseded | A2 | 2024-02-06 00:00:00 | Rejected | 2024-02-08 00:00:00 | Latest
3 | PI-PD-7005 | Procedure for Hydrostatic Test UG Piping |  |  |  |  | A3 | 2024-03-03 00:00:00 | Rejected | 2024-03-05 00:00:00 | Superseded | 00 | 2024-03-06 00:00:00 | Rejected | 2024-03-07 00:00:00 | Superseded | 01 | 2024-03-10 00:00:00 | Accepted | 2024-03-11 00:00:00 | Latest
4 | EL-PD-8001 | Electrical Heat Tracing System |  |  |  |  | 00 | 2024-04-11 00:00:00 | Pending |  | Latest
EXPECTED RESULTS
No. | Doc. No. | Document Title | CURRENT STATUS
 |  |  | Revision No. | Submitted Date | Review Status | COMPANY Reviewed Date
1 | PM-PD-6002 | Internal Audit Schedule | A1 | 2024-01-02 00:00:00 | Accepted | 2024-01-05 00:00:00
2 | PM-PD-6171 | Welding Procedure Specification | A2 | 2024-02-06 00:00:00 | Rejected | 2024-02-08 00:00:00
3 | PI-PD-7005 | Procedure for Hydrostatic Test UG Piping | 01 | 2024-03-10 00:00:00 | Accepted | 2024-03-11 00:00:00
4 | EL-PD-8001 | Electrical Heat Tracing System | 00 | 2024-04-11 00:00:00 | Pending
 | 1. All the "Latest" Revision Status should be reflected in the "CURRENT STATUS" information.
Spreadsheet: 861555d1709445593-to-show-months-without-data-as-well-all-months-to-show
Sheet: Sheet2

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15
2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
90 | 100 |  | 1039 |  | 12
Spreadsheet: 99903d1298439910-look-up-todays-date-and-return-cell-value-sample
Sheet: DATASHEET

OHS PERFORMANCE REPORT
PROJECT / SITE :
REPORT TO
 | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-25 00:00:00 | 2011-02-26 00:00:00 | 2011-02-27 00:00:00
MANHOURS | M | T | W | T | F | S | S | WTD
No.of Employees |  |  |  |  |  |  |  | 0
Total hours worked |  |  |  |  |  |  |  | 0
No of Labour Hire Employees |  |  |  |  |  |  |  | 0
Total hours worked-Labour hire |  |  |  |  |  |  |  | 0
No. Indigenous employee |  |  |  |  |  |  |  | 0
Total hours worked - Indigenous |  |  |  |  |  |  |  | 0
Total Number of Employees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total hours worked | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-25 00:00:00 | 2011-02-26 00:00:00 | 2011-02-27 00:00:00
RISK MANAGEMENT | M | T | W | T | F | S | S | WTD
Daily Inspection Checklist | 2 | 4 | 3 |  |  |  |  | 9
SAO's | 4 | 2 | 1 |  |  |  |  | 7
Hazard ID's |  | 2 |  |  |  |  |  | 2
Take Times's |  |  |  |  |  |  |  | 0
JSA's Written |  |  | 1 |  |  |  |  | 1
DRUG AND ALCOHOL TESTING | M | T | W | T | F | S | S | WTD
Number of Employees Tested - PASSED |  |  | 17 |  |  |  |  | 17
Number of Employees Tested - FAILED |  |  |  |  |  |  |  | 0
Total Number of Employees Tested | 0 | 0 | 17 | 0 | 0 | 0 | 0 | 17
INVOLVEMENT | M | T | W | T | F | S | S | WTD
Project HSE meetings [target 1 per week] |  | 1 |  |  |  |  |  | 1
Safety Committee Meeting conducted |  |  |  |  |  |  |  | 0
Toolbox meetings conducted | 1 |  |  |  |  |  |  | 1
Pre-start meetings conducted | 1 | 1 | 1 |  |  |  |  | 3
Environmental Inspections conducted  [target 1per week] |  |  |  |  |  |  |  | 0
Work Place Inspections conducted  [target 1 per Day] |  |  |  |  |  |  |  | 0
Training Courses Conducted (Give Details Below) |  |  |  |  |  |  |  | 0
Internal/External  Audits |  |  |  |  |  |  |  | 0
 | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-25 00:00:00 | 2011-02-26 00:00:00 | 2011-02-27 00:00:00
INCIDENT/INJURY | M | T | W | T | F | S | S | WTD
Number of Incidents Reported |  |  | 1 |  |  |  |  | 1
Number of Incidents Near Misses Reported |  |  |  |  |  |  |  | 0
Number of Environmental Incidents Reported |  |  |  |  |  |  |  | 0
Equipment/Plant Damage |  |  |  |  |  |  |  | 0
First Aid Injuries (FAI) |  |  |  |  |  |  |  | 0
Medically Treated Injuries (MTI) |  |  |  |  |  |  |  | 0
Lost Time Injuries (LTI) |  |  |  |  |  |  |  | 0
Restricted Work Injuries (RWI) |  |  |  |  |  |  |  | 0
Spreadsheet: 24464d1214887278-simple-problem-sum-of-certain-fields-accross-several-books-online-connect-reg
Sheet: Totals

 |  | Optus | Virgin | Vodafone | Three | Totals | Commission
 | [NAME] | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0
 | Billy | 0 | 0 | 0 | 0 | 0
 | Suzie | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 | TOTAL | 0 | 0 | 0 | 0 | 0
 |  |  |  | add the total amount in 'j' where tom is listed as staff
 |  |  |  | Remember, Column J is your comms column on each page
 |  |  |  |  |  | Created by [NAME]  2008
Spreadsheet: richard_shapiro__32133__MAE'sPriceHistory
Sheet: Sheet1

 | Sub-market | Peak | Shoulder | Off-Peak
2001-06-01 00:00:00 | SE/CO | 684,00 | 684,00 | 684,00
 | S | 379,05 | 292,92 | 292,92
 | NE | 684,00 | 684,00 | 684,00
 | N | 379,05 | 379,05 | 379,05
2001-05-01 00:00:00 | SE/CO | 459,89 | 459,89 | 459,89
 | S | 459,89 | 415,57 | 415,57
 | NE | 440,99 | 440,99 | 440,99
 | N | 440,99 | 440,99 | 440,99
2001-04-01 00:00:00 | SE/CO | 252,18 | 252,18 | 252,18
 | S | 252,18 | 241,65 | 241,65
 | NE | 247,35 | 247,35 | 247,35
 | N | 247,35 | 247,35 | 247,35
2001-03-01 00:00:00 | SE/CO | 165,97 | 165,97 | 165,97
 | S | 165,97 | 149,84 | 149,84
 | NE | 154,21 | 154,21 | 154,21
 | N | 154,21 | 154,21 | 154,21
2001-02-01 00:00:00 | SE/CO | 160,29 | 160,29 | 160,29
 | S | 160,29 | 153,47 | 153,47
 | NE | 121,47 | 121,47 | 121,47
 | N | 121,47 | 121,47 | 121,47
2001-01-01 00:00:00 | SE/CO | 56,92 | 56,92 | 56,92
 | S | 56,92 | 56,92 | 56,92
 | NE | 33,87 | 33,87 | 33,87
 | N | 33,87 | 33,87 | 33,87
2000-12-01 00:00:00 | SE/CO | 103,54 | 103,54 | 103,54
 | S | 103,54 | 103,54 | 101,77
 | NE | 72,16 | 72,16 | 72,16
 | N | 103,54 | 103,54 | 103,54
2000-11-01 00:00:00 | SE/CO | 149,70 | 149,70 | 149,70
 | S | 149,70 | 149,70 | 147,15
 | NE | 127,30 | 127,30 | 127,30
 | N | 149,70 | 127,30 | 127,30
2000-10-01 00:00:00 | SE/CO | 93,02 | 93,02 | 93,02
 | S | 93,02 | 93,02 | 27,45
 | NE | 76,07 | 76,07 | 76,07
 | N | 76,07 | 76,07 | 76,07
2000-09-01 00:00:00 | SE/CO | 156,11 | 156,11 | 156,11
 | S | 175,99 | 175,99 | 156,11
 | NE | 101,49 | 101,49 | 101,49
 | N | 101,49 | 101,49 | 66,06
Spreadsheet: 541724d1507526803-grouping-transactions-from-bank-account-grouping-transactions-from-bank-account-v2-expenses
Sheet: Sheet2

Expenses | 2017-09-25 00:00:00 | 2017-10-07 00:00:00
Details | Code | Totals:
Spreadsheet: 169698d1343030889-index-match-find-nearest-value-index-match-example
Sheet: Sheet3

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
1 | Example 1 | Example 2 | Example 3 | Example 4 | Example 5 | Example 6 | Example 7 | Example 8 | Example 9 | Example 10 | Example 11 | Example 12 | Example 13 | Example 14
2 | Text 1 | Text 2 | Text 3 | Text 4 | Text 5 | Text 6 | Text 7 | Text 8 | Text 9 | Text 10 | Text 11 | Text 12 | Text 13 | Text 14
3 | Test 1 | Test 2 | Test 3 | Test 4 | Test 5 | Test 6 | Test 7 | Test 8 | Test 9 | Test 10 | Test 11 | Test 12 | Test 13 | Test 14
 | Row | 1 | <------- | This will always be a 1,2 or 3
 | Column | 3 | <------- | This will sometimes contain a decimal value. |  |  |  | ---- | So 2.3 would return a value in column C & 5.7 would return a value in column G
 | Value | Example 3
Spreadsheet: 161859d1339662949-excel-2007-formula-counting-double-data-entries-as-one-copy-of-count
Sheet: Countif

 |  |  |  | Data | Counting |  | Expected Result
 |  |  |  | 1 |  |  | 1
 |  |  |  | 1 |  |  | 1
 |  |  |  | 2 |  |  | 2
 |  |  |  | 2 |  |  | 2
 |  |  |  | 3 |  |  | 3
 |  |  |  | 4 |  |  | 4
 |  |  |  | 5 |  |  | 5
 |  |  |  | 5 |  |  | 5
 |  |  |  | 6 |  |  | 6
 |  |  |  | 7 |  |  | 7
 |  |  |  | 8 |  |  | 8
 |  |  |  | 9 |  |  | 9
 |  |  |  | 10 |  |  | 10
 |  |  |  | 11 |  |  | 11
 |  |  |  | 11 |  |  | 11
 |  |  |  | 12 |  |  | 12
 |  |  |  | 12 |  |  | 12
 |  |  |  | 13 |  |  | 13
 |  |  |  | 14 |  |  | 14
 |  |  |  | 14 |  |  | 14
Spreadsheet: 759896d1639786732-2-criteria-vlookup-from-messy-less-messy-payroll-file-uploadtest
Sheet: SL

Printed 17/12/2021 06:53:31 AM |  |  |  |  |  |  |  |  |  | Transactions By Paycode |  |  |  |  |  |  |  |  | Page 1 of 7
Day |  |  | Date | Start |  | Finish | Position |  |  |  | Comment |  |  |  |  | Job |  |  |  |  | Quantity
=[NAME]:A,1,false)
[NAME] (SL)
Person1 |  |  | 2021-08-04 00:00:00 |  |  |  | PACK |  |  |  |  |  |  |  |  | Unallocated |  |  |  |  | 8.5
Person2 |  |  | 2021-08-02 00:00:00 |  |  |  | pick |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5
Spreadsheet: 4cb3cb5d-951d-462d-8f7c-75a669854a6c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 | Math, 2012
 | Performance Category | Number of Assessments
 | [NAME]: | ?
 | Exceeds Standard: | ?
 | Meets Standard: | ?
 | Approaches Standard: | ?
 | Academic Warning: | ?
 | Reading, 2012
 | Performance Category | Number of Assessments
 | [NAME]: | ?
 | Exceeds Standard: | ?
 | Meets Standard: | ?
 | Approaches Standard: | ?
 | Academic Warning: | ?
 | Math, 2011
 | Performance Category | Number of Assessments
 | [NAME]: | ?
 | Exceeds Standard: | ?
 | Meets Standard: | ?
 | Approaches Standard: | ?
 | Academic Warning: | ?
 | Reading, 2011
 | Performance Category | Number of Assessments
 | [NAME]: | ?
 | Exceeds Standard: | ?
 | Meets Standard: | ?
 | Approaches Standard: | ?
 | Academic Warning: | ?
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 6

 | November 15 | November 22 | November 29 | December 6 | December 13
Total Interest Rate* | 3014536 | 2933201 | 1359657 | 3511254 | 5833246
SDs and MSPs** | 1387659 | 1302927 | 528338 | 1794494 | 3084027
Other | 1626877 | 1630274 | 831319 | 1716760 | 2749219
Total Cross-Currency | 100879 | 168190 | 42084 | 120031 | 203212
SDs and MSPs | 71592 | 91901 | 27842 | 84457 | 147154
Other | 29287 | 76289 | 14242 | 35574 | 56058
Total Credit | 608408 | 893038 | 456078 | 971509 | 557836
SDs and MSPs | 382740 | 583786 | 304640 | 556629 | 378198
Other | 225668 | 309252 | 151439 | 414881 | 179638
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 3723823 | 3994429 | 1857819 | 4602794 | 6594294
Weekly total, swap dollar volumes by asset class and participant type (value of all trades in millions of USD), all products and tenors, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. The notional values of all price-forming trade events, including new trades, terminations, amendments, and novations, are included in dollar volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Dollar Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 749965d1633116646-replacing-nested-if-stetements-example
Sheet: Sheet1

 | Item | Plant | [NAME]. | Request |  | 1026 | 1002 | 1023 | 1040
 | C111 | 1002 | 10 | Can I allocate in 1002? |  | 0 | 10 | 0 | 0
 | E444 | 1002 | 10 | Can I move to 1026? |  | 30 | 5 | 20 | 5
 | C112 | 1002 | 10 | Can I move to 1040? |  | 0 | 0 | 10 | 20
 | C113 | 1002 | 10 | Can I move to 1023? |  |  | 0 | 20 | 0
 | E445 | 1002 | 10 | Out of stock |  | 0 | 0 | 0 | 0
 | D333 | 1023 | 10 | Can I move to 1002? |  | 0 | 10 | 0 | 0
 | D334 | 1023 | 10 | Can I allocate in 1023? |  | 30 | 5 | 20 | 5
 | F555 | 1026 | 10 | Can I move to 1040? |  | 0 | 0 | 10 | 20
 | F556 | 1026 | 10 | Out of stock |  | 0 | 0 | 0 | 0
 | B222 | 1040 | 10 | Can I move to 1002? |  | 0 | 10 | 0 | 0
 | B223 | 1040 | 10 | Can I move to 1026? |  | 30 | 5 | 20 | 5
 | B224 | 1040 | 10 | Can I allocate in 1040? |  | 0 | 0 | 10 | 20
Spreadsheet: 163997d1340599522-multiple-lookup-with-with-variable-dates-convert-to-fixed-series-of-dates-sampletwoitemlookupwithdates
Sheet: Sheet1

Input |  |  |  |  |  | Output
Date | Item | Price |  | Month | Item | Price
2011-05-15 00:00:00 | A | 5.5 |  | 2011-06-24 00:00:00 | A | 5.5
2011-05-25 00:00:00 | B | 19 |  | 2011-07-24 00:00:00 | A | 5.2
2011-06-30 00:00:00 | A | 5.2 |  | 2011-08-24 00:00:00 | A | 5.2
2011-07-05 00:00:00 | B | 19.5 |  | 2011-09-24 00:00:00 | A | 5
2011-08-05 00:00:00 | B | 20 |  | 2011-10-24 00:00:00 | A | 5
2011-09-20 00:00:00 | A | 5 |  | 2011-11-24 00:00:00 | A | 5.4
2011-11-15 00:00:00 | A | 5.4 |  | 2011-12-24 00:00:00 | A | 5.4 |  | This is what I'm trying to get a formula for:
2011-12-18 00:00:00 | B | 19 |  | 2012-01-24 00:00:00 | A | 5.4 |  | What is the price in any of the past twelve months?
2012-03-20 00:00:00 | A | 5.5 |  | 2012-02-24 00:00:00 | A | 5.4
2012-04-15 00:00:00 | B | 20 |  | 2012-03-24 00:00:00 | A | 5.5
 |  |  |  | 2012-04-24 00:00:00 | A | 5.5
 |  |  |  | 2012-05-24 00:00:00 | A | 5.5
 |  |  |  | 2012-06-24 00:00:00 | A | 5.5
Spreadsheet: 680241d1590872431-how-to-copy-every-10-rows-from-multiple-sheets-to-one-sheet-rezaworksheet
Sheet: sheet5

12
34
657
945
324
44
57
87
54
345
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Spreadsheet: 110381d1307050154-capture-only-rows-where-a-specific-cell-is-populated-example-for-cure4glass1
Sheet: 5-3-11

HeaderA | HeaderB | HeaderC | HeaderD | [NAME] | HeaderF
4 | Populated | 4 | 4 | 4 | 4
5 |  | 5 | 5 | 5 | 5
6 | Populated | 6 | 6 | 6 | 6
7 | Populated | 7 | 7 | 7 | 7
8 |  | 8 | 8 | 8 | 8
9 | Populated | 9 | 9 | 9 | 9
10 |  | 10 | 10 | 10 | 10
11 | Populated | 11 | 11 | 11 | 11
12 |  | 12 | 12 | 12 | 12
13 | Populated | 13 | 13 | 13 | 13
14 | Populated | 14 | 14 | 14 | 14
15 |  | 15 | 15 | 15 | 15
16 | Populated | 16 | 16 | 16 | 16
17 |  | 17 | 17 | 17 | 17
18 | Populated | 18 | 18 | 18 | 18
19 | Populated | 19 | 19 | 19 | 19
20 | Populated | 20 | 20 | 20 | 20
21 | Populated | 21 | 21 | 21 | 21
22 |  | 22 | 22 | 22 | 22
23 | Populated | 23 | 23 | 23 | 23
24 |  | 24 | 24 | 24 | 24
25 |  | 25 | 25 | 25 | 25
Spreadsheet: 219118d1362670672-producing-a-table-of-monthly-values-based-on-a-monthly-growth-rate-and-yearly-total-xlf-example-for-mister-excel
Sheet: Example

Year | Amount |  | Month | Rate | Amount
2000 |  |  | 2000-01-01 00:00:00 |  | 10
 |  |  | 2000-02-01 00:00:00 | 0.02
 |  |  | 2000-03-01 00:00:00 | 0.04
 |  |  | 2000-04-01 00:00:00 | 0.06
 |  |  | 2000-05-01 00:00:00 | 0.07
 |  |  | 2000-06-01 00:00:00 | 0.04
 |  |  | 2000-07-01 00:00:00 | 0.03
 |  |  | 2000-08-01 00:00:00 | 0.06
 |  |  | 2000-09-01 00:00:00 | 0.06
 |  |  | 2000-10-01 00:00:00 | 0.06
 |  |  | 2000-11-01 00:00:00 | 0.09
 |  |  | 2000-12-01 00:00:00 | 0.1
Spreadsheet: 750301d1633374089-lookup-city-names-in-a-string-and-then-return-the-city-code-from-a-table-book1
Sheet: table

A - B | [NAME]
ACME | BE
ALDER FLATS | BR
ALEXANDER | MO
ALEXIS | MT
ALIX | BA
ALLIANCE | KI
ALTARIO | CS
ANDREW | TO
ARDMORE | CE
ASHMONT | SP
ATHABASCA | AT
ATIKAMEG | HP
ATMORE | BY
BALZAC | AI
BAWLF | CA
BEAVER LAKE | LL
BELLIS | SM
BERWYN | PV
BEZANSON | GP
BLUE RIDGE | WH
BLUESKY | FR
BMS | BY
BON ACCORD | MO
BOTHA | ST
BOWDEN | OL
BOYER RIVER | HL
BROWNVALE | PV
Brownvale | PV
BRUCE | VK
BRUDERHEIM | FS
BUCK CREEK | BR
BUFFALO LAKE | BY
BUSBY | WL
BUSHE | HL
LETHBRIDGE | LRPS
STRATHMORE | SE
CROSSFIELD | AI
OLDS | OL
CALLING LAKE | AT
ROCKY MOUNTAIN HOUSE | RO
MORLEY | CO
Spreadsheet: 192086d1352303830-sorting-data-with-a-common-variable-workbook-data-sample-with-pivot
Sheet: Sheet1

Item | Date | Quantity |  | Sum of Quantity | Column Labels
retractable pick up bed covers | 2012-09-10 00:00:00 | 7 |  | Row Labels | 2012-09-10 00:00:00 | 2012-09-17 00:00:00 | 2012-09-24 00:00:00 | 2012-10-01 00:00:00 | 2012-10-08 00:00:00 | 2012-10-15 00:00:00 | 2012-10-22 00:00:00 | Grand Total
retractable pick up bed covers | 2012-09-17 00:00:00 | 7 |  | retractable pick up bed covers | 7 | 7 | 7 | 7 | 6 | 6 | 5 | 45
retractable pick up bed covers | 2012-09-24 00:00:00 | 7 |  | retractable pickup bed cover | 6 | 6 | 6 | 5 | 4 | 4 | 4 | 35
retractable pick up bed covers | 2012-10-01 00:00:00 | 7 |  | retractable pickup bed covers | 6 | 6 | 6 | 6 | 4 | 5 | 4 | 37
retractable pick up bed covers | 2012-10-08 00:00:00 | 6 |  | retractable pickup truck bed cover | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 25
retractable pick up bed covers | 2012-10-15 00:00:00 | 6 |  | retractable pickup truck bed covers | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 26
retractable pick up bed covers | 2012-10-22 00:00:00 | 5 |  | Grand Total | 27 | 27 | 27 | 26 | 21 | 21 | 19 | 168
retractable pickup bed cover | 2012-09-10 00:00:00 | 6
retractable pickup bed cover | 2012-09-17 00:00:00 | 6
retractable pickup bed cover | 2012-09-24 00:00:00 | 6
retractable pickup bed cover | 2012-10-01 00:00:00 | 5
retractable pickup bed cover | 2012-10-08 00:00:00 | 4
retractable pickup bed cover | 2012-10-15 00:00:00 | 4
retractable pickup bed cover | 2012-10-22 00:00:00 | 4
retractable pickup bed covers | 2012-09-10 00:00:00 | 6
retractable pickup bed covers | 2012-09-17 00:00:00 | 6
retractable pickup bed covers | 2012-09-24 00:00:00 | 6
retractable pickup bed covers | 2012-10-01 00:00:00 | 6
retractable pickup bed covers | 2012-10-08 00:00:00 | 4
retractable pickup bed covers | 2012-10-15 00:00:00 | 5
retractable pickup bed covers | 2012-10-22 00:00:00 | 4
retractable pickup truck bed cover | 2012-09-10 00:00:00 | 4
retractable pickup truck bed cover | 2012-09-17 00:00:00 | 4
retractable pickup truck bed cover | 2012-09-24 00:00:00 | 4
retractable pickup truck bed cover | 2012-10-01 00:00:00 | 4
retractable pickup truck bed cover | 2012-10-08 00:00:00 | 3
retractable pickup truck bed cover | 2012-10-15 00:00:00 | 3
retractable pickup truck bed cover | 2012-10-22 00:00:00 | 3
retractable pickup truck bed covers | 2012-09-10 00:00:00 | 4
retractable pickup truck bed covers | 2012-09-17 00:00:00 | 4
retractable pickup truck bed covers | 2012-09-24 00:00:00 | 4
retractable pickup truck bed covers | 2012-10-01 00:00:00 | 4
retractable pickup truck bed covers | 2012-10-08 00:00:00 | 4
retractable pickup truck bed covers | 2012-10-15 00:00:00 | 3
retractable pickup truck bed covers | 2012-10-22 00:00:00 | 3
Spreadsheet: 230700d1366836740-help-to-create-a-mandays-worksheet-mandays1-melmig06-oeldere-
Sheet: Feuil1

 |  |  |  |  |  |  |  |  | begin | start | FSI to LSO | LSO to DBL | end |  | control |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00
Project | Phase | Study | DM | Planned MDs | FSI | LSO | DBL |  | 0.2 | 0.2 | 0.2 | 0.35 | 0.05 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  |  | find | month | month | month | month | month
[NAME] | I | SPRXXXXXX | DM1 |  | 2013-02-12 00:00:00 | 2013-05-01 00:00:00 | 2013-05-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6,6 | 1,6 | 1,6 | 10 | 1.25
 |  |  |  | 25
 |  |  |  |  |  |  |  | this
 |  |  |  |  | Prior FSI | FSI to LSO | LSO to DBL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | After DBL
 |  |  |  |  | 0.4 | 0.2 | 0.35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
 | I'm working in a company as manager and for the moment we do not micro planification and I need to assess my resources and the # mandays planned per month for each individuals.
 | I would like based on the attached spreadsheet to do the following :
 | - Let say I have a project with several phases :
 | Period A is 2 month prior date of FSI
 | Period B is between FSI date and [NAME] date
 | Period C is between LSO date and DBL date
 | Period D is 1 month after DBL date
 | I know wy ressource will spent 25 mandays on this project and I know that 40% is used during period A, 20% during period B, 35% during period C and 5% during period D.
 | I would like to calculate for each month the number of mandays planned for my ressource.
 | Is that possible in Excel ? Or should I do [NAME] code ?
Spreadsheet: 85720d1285768765-customizing-drop-down-list-in-excel-col-in-progress
Sheet: Sheet1

DOCUMENTATION SHEET FOR FILE
(FOR OFFICE USE ONLY)
STUDENT NAME:
STUDENT ID NUMBER:
OTHER LAST NAME:
Admission's Responsibility
Date | Date | Type of Document |  |  | School |  |  |  |  | GPA
Ordered | Received
 |  | OFFICIAL TRANSCRIPT
 |  | OFFICIAL TRANSCRIPT
 |  | OFFICIAL TRANSCRIPT
 |  | OFFICIAL TRANSCRIPT
 |  | OFFICIAL TRANSCRIPT
 |  | OFFICIAL TRANSCRIPT
Applicant's Responsibility
Completed by: |  |  |  |  |  |  | Date:
Recommend:
Signature: |  |  |  |  |  |  | Date:
Comments: