tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 36470d1234358493-moving-rows-to-anoter-worksheet-based-on-certain-criteria-anz-maximizer-monthly-kpi
Sheet: Data Drop Sheet

Opportunity Leader | Address Book Entry | Close Date | Number of Analyzers required | Total Capital | Annual Number of Cartridges | Annual Cartridge Revenue | Status | Confidence Rating | Revenue
[NAME] | Waikato Hospital | 2009-11-10 00:00:00 | 3 | 29160 | 1500 | 10800 | New | 4 Confident | 39960
[NAME] | Wellington Hospital | 2009-10-10 00:00:00 | 1 | 9720 | 2200 | 27000 | New | 4 Confident | 36720
[NAME] | Caboolture Hospital | 2009-06-30 00:00:00 | 1 | 6800 | 1000 | 6000 | Updated | 4 Confident | 12800
[NAME] | Cairns Base Hospital | 2009-06-30 00:00:00 | 1 | 0 | 500 | 5000 | Updated | 4 Confident | 13300
[NAME] | Cairns Hospital | 2009-02-28 00:00:00 | 0 | 0 | 1000 | 6000 | New | 5 Very Confident | 6000
[NAME] | Chemtronics | 2009-06-30 00:00:00 | 1 | 0 | 500 | 2500 | Updated | 3 Uncertain | 9800
[NAME] | Hervey Bay Hospital | 2009-02-28 00:00:00 | 0 | 0 | 1000 | 6000 | New | 5 Very Confident | 6000
[NAME] | Mackay Hospital | 2009-02-28 00:00:00 | 0 | 0 | 1500 | 11250 | New | 5 Very Confident | 0
[NAME] | QHPS POC | 2009-03-30 00:00:00 | 0 | 0 | 0 | 60000 | New | 4 Confident | 60000
[NAME] | QHPS POC | 2009-03-30 00:00:00 | 0 | 0 | 7300 | 110000 | New | 5 Very Confident | 110000
[NAME] | QHPS POC | 2009-11-30 00:00:00 | 0 | 0 | 5000 | 60000 | New | 3 Uncertain | 60000
[NAME] | Royal Brisbane Hospital | 2009-04-30 00:00:00 | 1 | 6800 | 5000 | 50000 | Updated | 3 Uncertain | 7300
[NAME] | Royal Brisbane Hospital | 2009-06-30 00:00:00 | 1 | 6800 | 1000 | 5000 | Updated | 2 Doubtful | 13800
[NAME] | Townsville General Hospital | 2009-03-30 00:00:00 | 1 | 6800 | 6000 | 50000 | Updated | 4 Confident | 56800
[NAME] | Townsville General Hospital | 2009-06-30 00:00:00 | 1 | 6800 | 1000 | 5000 | Updated | 3 Uncertain, 4 Confident | 13800
[NAME] | Townsville General Hospital | 2009-06-30 00:00:00 | 1 | 6800 | 1500 | 9000 | Updated | 4 Confident | 15800
Thor Cembala | Royal Adelaide Hospital | 2009-11-30 00:00:00 | 1 | 6750 | 10000 | 25000 | New | 2 Doubtful | 31750
Thor Cembala | Women's and Children's Hospital | 2009-11-30 00:00:00 | 1 | 5000 | 500 | 3000 | Updated | 3 Uncertain | 8000
 | These rows are cut & pasted in on a monthly basis
Spreadsheet: 837400d1690137462-conditional-formatting-to-change-the-color-of-row-if-any-cell-match-is-false-conditional-formatting1
Sheet: query (5)

ID | Inspection Category | Finding Type | Finding Category | Finding Sub-Category | Risk Rating | Has a [NAME] been broken? | [NAME] | Promises
4 | Environment | Positive | Environement | Health_Safety-Excavation | Positive Observation | Yes | Breaking Ground & Excavations | Breaking Ground & Excavations - I will only break ground if a permit is in place and I am aware of the precautions within the permit
5 | Health_Safety | Negative | Environement | Health_Safety-Welfare | Positive Observation | No |  | Mobile Plant & Equipment - I will only operate mobile plant and equipment if I am trained and authorised
6 | Health_Safety | Positive | Health_Safety | Health_Safety-Excavation | Positive Observation | No |  | Breaking Ground & Excavations - I will only enter an excavation if protection is in place to prevent people or vehicles falling in
7 | Health_Safety | Positive | Health_Safety | Health_Safety-Excavation | Positive Observation | No |  | Fire Safety - I will immediately raise the alarm if i see a fire
8 | Health_Safety | Positive | Environement | Health_Safety-Excavation | Positive Observation | No |  | Mobile Plant & Equipment - I will only operate plant and equipment if I have 360-degree visibility
9 | Health_Safety | Negative | Health_Safety | Health_Safety-Access & Egress | Medium (Close in 1week) | Yes | Lifting | Lifting - I will only use lifting equipment and accessories if they have valid test certificates
10 | Health_Safety | Negative | Health_Safety | Health_Safety-PPE | Low | No |  | Working at Height - I will not work at height unless I am protected by edge protection or by a harness fixed to a suitable anchor point
11 | Environment | Negative | Health_Safety | Health_Safety-Hazard Identification | Medium (Close in 1week) | Yes
12 | Environment | Positive | Health_Safety | Health_Safety-Training & Induction | Positive Observation | No
 | Final Result like to be
 | Health_Safety | Positive | Health_Safety | Health_Safety-Access & Egress | Positive Observation | No | Breaking Ground & Excavations | Breaking Ground & Excavations - I will only break ground if a permit is in place and I am aware of the precautions within the permit
 | Errors we find in this report are
 | Health_Safety | Positive | Environment | Health_Safety-Access & Egress | Medium (Close in 1week) | Yes | Breaking Ground & Excavations | Fire Safety - I will immediately raise the alarm if i see a fire
 | Environment | Negative | Health_Safety | Health_Safety-Access & Egress | Positive Observation | No | Value is Missing - Not Selected Hazards | Lifting - I will only use lifting equipment and accessories if they have valid test certificates
 | Breaking Ground & Excavations
 | Mobile Plant & Equipment
 | Fire Safety
 | Lifting
 | Working at Height
 | Positive Observation
 | Medium (Close in 1week)
 | Low
Spreadsheet: 870232d1716789059-grabbing-data-from-a-data-table-between-2-dates-excel-2010-ben-solution-ans
Sheet: Sheet1

Occurrences | Date | Start Time | End Time | Track | Counties | Length | [NAME] | Deaths | Injuries | Rating |  |  | Begin Date | 2024-05-01 00:00:00 | End Date | 2024-05-31 00:00:00 | occurences
 |  |  |  |  |  |  |  |  |  |  | Headings in both the sheets should exactly match.
 |  |  |  |  |  |  |  |  |  |  | Rating
Spreadsheet: 269499d1381174421-formatting-a-table-to-pull-data-array-formula-sampletable_student1990-2-pt-oeldere-
Sheet: Returns

Approach | Size Group | Style Group | 3-Year | 5-Year | 7-Year | 10-Year
Fundamental | A | 1 | 18.90175 | 12.23905 | 7.9872 | 11.8018
Fundamental | A | 2 | 18.5154 | 10.455 | 7.663 | 11.6263
Fundamental | A | 3 | 18.6113 | 10.63335 | 7.7311 | 11.6924
Fundamental | A | 4 | 21.25335 | 10.3921 | 7.4827 | 10.83215
Fundamental | A | 5 | 19.1644 | 10.1331 | 7.7625 | 11.55375
Fundamental | B | 1 | 17.9256 | 10.93085 | 7.8427 | 11.9159
Fundamental | B | 2 | 18.96405 | 9.496 | 7.3349 | 11.8461
Fundamental | B | 3 | 18.92075 | 9.68975 | 7.4597 | 11.8461
Fundamental | B | 4 | 20.3333 | 9.0752 | 8.27125 | 11.52885
Fundamental | B | 5 | 18.41695 | 10.1495 | 8.29 | 11.0013
Fundamental | C | 1 | 18.8 | 11.61 | 7.76 | 11.73
Fundamental | C | 2 | 19.33 | 9.72 | 7.5 | 11.27
Fundamental | C | 3 | 19.28 | 10.1 | 7.5 | 11.38
Fundamental | C | 4 | 18.44 | 7.64 | 7.8 | 10.4
Fundamental | C | 5 | 18 | 8.27 | 7.55 | 10.29
Fundamental | D | 1 | 17.98 | 7.41 | 5 | 8.14
Fundamental | D | 2 | 17.87 | 7.23 | 5.92 | 8.43
Fundamental | D | 3 | 17.89 | 7.24 | 5.83 | 8.39
Fundamental | D | 4 | 17.42 | 6.62 | 6.7 | 7.86
Fundamental | D | 5 | 17.24 | 7.06 | 6.28 | 8.14
Quantitative | A | 1 | 20.4263 | 10.3254 | 4.5492 | 10.2025
Quantitative | A | 2 | 19.97285 | 9.4279 | 5.8862 | 10.7941
Quantitative | A | 3 | 20.2478 | 9.72265 | 5.88035 | 10.7362
Quantitative | A | 4 | 21.8099 | 9.0582 | 5.7229 | 9.3709
Quantitative | A | 5 | 21.0211 | 9.4342 | 5.3714 | 9.85245
Quantitative | B | 1 | 18.99385 | 11.9815 | 6.61005 | 11.221
Quantitative | B | 2 | 21.9318 | 9.991 | 5.2617 | 9.0521
Quantitative | B | 3 | 21.1401 | 9.991 | 5.4307 | 10.13655
Quantitative | B | 4 | 18.1143 | -1.2061 | 2.0133 | 8.9885
Quantitative | B | 5 | 21.3699 | 9.33405 | 6.5921 | 10.7658
Quantitative | C | 1 | 21.72 | 10.76 | 7.73 | 12.11
Quantitative | C | 2 | 19.67 | 8.77 | 6.39 | 10.14
Quantitative | C | 3 | 19.81 | 9.15 | 6.83 | 10.85
Quantitative | C | 4 | 18.05 | 5.18 | 5.92 | 8.46
Quantitative | C | 5 | 20.98 | 8.58 | 7.1 | 10.55
Quantitative | D | 1 | 20.05 | 7.77 | 5.36 | 9.02
Quantitative | D | 2 | 19.02 | 7.61 | 5.38 | 8.19
Quantitative | D | 3 | 19.51 | 7.68 | 5.37 | 8.66
Quantitative | D | 4 | 19.07 | 7.13 | 6.41 | 7.8
Quantitative | D | 5 | 19.33 | 7.36 | 6 | 8.15
Spreadsheet: 90926d1290614632-excel-base-stock-balance-sheet-stock-balance-record
Sheet: GOOG

 | Stock Balance Record
 |  |  |  | ITEM | GOOG
 |  |  |  | UNITS
 |  |  |  | [NAME] |  | SECTION
 |  |  |  | EXPEDITE |  | REORDER
 |  |  |  |  |  | CURRENT BALANCE | 650
 |  |  |  |  |  | USED
 | DATE | REFERENCE | ISSUED | REC'D | ON ORDER | TO DATE | BALANCE
 |  |  |  |  |  | OPENING BALANCE | 500
 |  |  |  |  |  |  | 600
 |  |  |  |  |  |  | 650
Spreadsheet: 177079d1346180669-excel-2010-array-problem-excel-problem-edited
Sheet: Sheet1

 | User Name | Department | Promoted | Department
 | 1234567 | ACE | 12345678 |  |  |  | A standard user list that I want to paste into the worksheet
 | 1234567 | ACME | 87654321 |  |  |  | User names that will come from another process to identify them
 | 12345678 | FXTX | 53214567 |  |  |  | When the user name (red) column I want this to populate with the department from the (blue) column
 | 87654321 | SUBS | 53214567
 | 11223344 | BGM | 53214567
 | 55667788 | PRES
 | 98765432 | PULP
 | 23456789 | POOP
 | 53214567 | SLME
 | 53214567 | FXTX
 | 53214567 | ACE
Spreadsheet: b04b74b3-2379-486d-b86c-269a09c92887
Sheet: Sheet1

Table S4.  Chromosome 7 encoded proteins found in mouse saliva proteomes ([NAME] and Laukaitis 2011) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  |  | Chromosome 7 |  | Region differs
IPI number | Description |  |  |  | coordinates |  | between strains | Notes
IPI00170392 | Androgen binding protein beta-gamma 26 |  |  |  | 34728027-34730000 |  | Yes | ESTs in submandibular and sub-
 |  |  |  |  |  |  |  | lingual glands ([NAME]. 2005)
IPI00153363 | Androgen-binding protein beta-gamma 27 |  |  |  | 34796945-34798961 |  | Yes | ESTs in all three salivary
 |  |  |  |  |  |  |  | glands ([NAME]. 2005)
[NAME] | Androgen binding protein alpha 27 |  |  |  | 34806586-34807898 |  | Yes | ESTs in all three salivary
 |  |  |  |  |  |  |  | glands ([NAME]. 2005)
IPI00112184 | Putative uncharacterized protein (KLK1B8) |  |  |  | 51200382-51201297 |  | No | Beyond transferred segment
IPI00130801 | [NAME] peptidase b8 |  |  |  | 51206042-51210308 |  | No | Beyond transferred segment
IPI00134580 | [NAME]related peptidase b1 |  |  |  | 51222121-51226688 |  | No | Beyond transferred segment
IPI00136040 | [NAME] peptidase b9 |  |  |  | 51231467-51235746 |  | No | Beyond transferred segment
IPI00136034 | [NAME]related peptidase b11 |  |  |  | 51251249-51255244 |  | No | Beyond transferred segment
IPI00121818 | Epidermal growth factor- |  |  |  | 51260009-51272287 |  | No
 | binding protein tyoe B |  |  |  |  |  |  | Beyond transferred segment
IPI00121821 | [NAME]related peptidase b26 |  |  |  | 51268048-51272331 |  | No | Beyond transferred segment
IPI00124824 | [NAME] peptidase b27 |  |  |  | 51307660-51312075 |  | No | Beyond transferred segment
IPI00124822 | [NAME]related peptidase b21 |  |  |  | 51357662-51361944 |  | No | Beyond transferred segment
IPI00136038 | [NAME]related peptidase b22 |  |  |  | 51368049-51372289 |  | No | Beyond transferred segment
IPI00113575 | [NAME]related peptidase b16 |  |  |  | 51392137-51396974 |  | No | Beyond transferred segment
IPI00124804 | [NAME]related peptidase b24 |  |  |  | 51443643-51447816 |  | No | Beyond transferred segment
IPI00134582 | [NAME]related peptidase b3 |  |  |  | 51453561-51457721 |  | No | Beyond transferred segment
IPI00316234 | [NAME]related peptidase-like b4 |  |  |  | 51462782-51467075 |  | No | Beyond transferred segment
IPI00136033 | [NAME]related peptidase b5 |  |  |  | 51471829-51476082 |  | No | Beyond transferred segment
IPI00323869 | Kallikrein-1 |  |  |  | 51480820-51484987 |  | No | Beyond transferred segment
IPI00309704 | Nucleobindin 2 |  |  |  | 123,647,888-123,683,592 |  | No | Beyond transferred segment
Spreadsheet: 831404d1685615461-offset-not-returning-answer-im-looking-for-runout-test
Sheet: Run Out

FG Code | Description | Case Qty | Infor FG Stock | Packaging SKU Short | Sage Packaging On Hand (cases) | WIP Stock @ Supplier (units) | FG Stock @ Supplier (units) | Stock & [NAME] (cases) | Total No Cases & FG Stock |  | Run Out Date Against Forecast
ASBAKED101 | [NAME] |  | 2000 | [NAME] | 0 | 0 | 0 |  | 2500
Spreadsheet: 113041d1308968863-attempting-to-create-a-formula-code-to-have-excel-automatically-move-a-column-over-scratchers-20form_after-1-
Sheet: Sales

LOTTERY SALES
BOX | PREVIOUS DAY | TODAY | # [NAME] | $ [NAME]
1 |  |  |  |  | 1
2 |  |  |  |  | 1
3 |  |  |  |  | 1
4 |  |  |  |  | 1
5 |  |  |  |  | 2
6 |  |  |  |  | 2
7 |  |  |  |  | 2
8 |  |  |  |  | 2
9 |  |  |  |  | 3
10 |  |  |  |  | 3
11 |  |  |  |  | 3
12 |  |  |  |  | 3
13 |  |  |  |  | 5
14 |  |  |  |  | 5
15 |  |  |  |  | 5
16 |  |  |  |  | 5
 |  | Scratcher Sales = |  | 0
 |  | Lottery Sales = |  | 340
 |  | Actual Sales = |  | 340
 |  | Report Sales = |  | 450
 |  | Over/Short = |  | 110
Closing Date | 2011-06-24 00:00:00
 | 2011-06-24 00:00:00
 | 2011-06-25 00:00:00
 | 2011-06-26 00:00:00
 | 2011-06-27 00:00:00
 | 2011-06-28 00:00:00
 | 2011-06-29 00:00:00
Spreadsheet: 88268d1288129215-using-autofill-to-complete-a-correlation-matrix-10-stock-optimizer-iii-index
Sheet: Correlations

Steps for (e.g.) cell F18
 | Where does Funamentals appear in Sheet 1 row 17?
 | Use OFFSET function, starting at Sheet 1 A63 - move no rows, 13 cols to the right,
 | select 1 col wide, 252 rows high
 | =OFFSET(Sheet1!$A$63,0,MATCH(Correlations!F$12,Sheet1!$17:$17)-1,252,1)
 | Where does BOUNCE appear in Sheet 1 row 17?
 | Use OFFSET function, starting at Sheet 1 A63 - move no rows, 16 cols to the right,
 | select 1 col wide, 252 rows high
 | =OFFSET(Sheet1!$A$63,0,MATCH(Correlations!$A18,Sheet1!17:17),252,1)
 | Now use your PEARSON function on these 2.  The formula in F18 should be copyable...
 | WARNING - the titles in row 12 and column A must exactly match the titles in Sheet 1 row 17!
 | YEY | YEY2 | LowPEZLTD | H52EarnPS | Fundamentals | BOUNCE | HICCUP | PIH_CSO | PIH_MCP | SomeMoS | HI_INC_CSH | T_VALUE | RS2020 | Screamers | PEG-Min | Value_EG | Smooth | BlueCheaps | SmallMo | SmallMoEY | Pharstad
YEY
YEY2
LowPEZLTD
H52EarnPS
[NAME]
SAFETY_BOUNCE
HICCUP
PIH_CSO
PIH_MCP
SomeMoS
HI_INC_CSH
T_VALUE
RS2020
Screamers
PEG-Min
Value_EG
Smooth
BlueCheaps
SmallMo
SmallMoEY
Pharstad
Spreadsheet: kenneth_lay__19487__WPO Forum List 2001
Sheet: Sheet1

 | WPO Forum-March 2000
 | Last Name | First Name | Company | Address | City/State/Zip | Phone & E-mail | Assistant | Fax
 | Braniff, III | [NAME] | Gallagher Braniff, Inc. | 1330 Post Oak Blvd., Ste. 2200 | Houston, TX  77056 | (713)968-1400, ext. 203/ E-mail: [EMAIL] | Belinda Breen/ E-mail: [EMAIL] | (713)968-1405
 | Canion | Rod | Insource Technology Corp. | 5 Post Oak Park, Ste. 1655 | Houston, TX  77027 | (713)871-8400/ E-mail: [EMAIL] | Pam Weisinger/ E-mail: [EMAIL] | (713) 871-8889
 | [NAME] | [NAME] | CRC-Evans Pipeline Int'l. | 11601 [NAME] | Houston, TX  77086 | (281)999-8920/ E-mail:  [EMAIL] | [NAME] Brandt/ E-mail:                          [EMAIL] | (281)405-2741
 | Cockrell | Ernie | Cockrell Interests | 1600 Smith, Ste. 3900 | Houston, TX  77002 | (713)209-7505/ E-mail: [EMAIL] | [NAME] E-mail: [EMAIL] | (713)209-7599
 | Curran | [NAME] | Willbros USA | 4400 Post Oak Pkwy, Ste. 1000 | Houston, TX  77027 | (713)784-5757/ E-mail:                  [EMAIL] | [NAME]:                          [EMAIL] | (713)403-8074
 | Dannenbaum | [NAME] | Dannenbaum Engineering | 3100 West Alabama | Houston, TX  77098 | (713)527-6482/ E-mail: [EMAIL] | [NAME]: [EMAIL] | (713)527-6338
 | Doyle | [NAME] | [NAME] of Texas | 3000 Richmond Avenue, Ste. 200 | Houston, TX  77098 | (713)834-1350/ E-mail: [EMAIL] | [NAME]/E-mail: [EMAIL] | (713)834-1373
 | Dussler | [NAME] | Palmetto Partners, Ltd. | 711 Louisiana, Ste. 3300 | Houston, TX  77002 | (713)336-7822/ E-mail: [EMAIL] | [NAME]:                                [EMAIL] | (713)336-7828
 | [NAME] | [NAME] | Century Development | 1980 Post Oak Blvd., Ste. 1200 | Houston, TX  77056 | (713)871-5119/ E-mail:   [EMAIL] | [NAME]: [EMAIL] | (713)871-5199
 | Hollingsworth, Jr. | [NAME] | Group 1 Automotive | 950 Echo Lane, Ste. 110 | Houston, TX  77024 | (713)647-5700/ E-mail: [EMAIL] | [NAME] Baker/ E-mail: [EMAIL] | (713)467-1513
 | [NAME] | Ned | Parkway Investments/ TX | 55 Waugh Drive, Ste. 1111 | Houston, TX  77007 | (713)621-1880/ E-mail: not applicable | [NAME]: [EMAIL] | (713)864-8878
 | Klein | [NAME] | GKH Partners, L.P. | 615 N. Upper Broadway, Ste. 1940 | Corpus Christi, TX  78477 | (361)883-7205/ E-mail: [EMAIL] | [NAME]: [EMAIL] | (361)883-6858
 | Lay | [NAME] | Enron Corp. | [NAME] 1188 | Houston, TX  77251 | (713)853-6773/ E-mail: [EMAIL] | [NAME] Fleming/ E-mail: [EMAIL] | (713)853-9479
 | Lorenzo | [NAME] | Savoy Capital, Inc. | 333 Clay Street, Ste. 4040 | Houston, TX  77002 | (713)658-9594/ E-mail: [EMAIL] | Millie Jones/ E-mail: [EMAIL] | (713)658-1782
 | Pappas | [NAME] | Pappas Restaurants, Inc. | 642 Yale | Houston, TX  77007 | (713)869-0151/ E-mail: [EMAIL] | Tish Hoover/ E-mail: [EMAIL] | (713)869-1773
 | Pye, Jr. | Walter | [NAME] | [NAME], Ste. 416 | Houston, TX  77057 | (713)688-5855/ E-mail: [EMAIL] |  | (713)688-5955
 | Way | [NAME] | Way Companies | 5308 Ashbrook | Houston, TX  77081 | (713)666-3541/ E-mail: [EMAIL] | [NAME] E-mail: [EMAIL] | (713)512-9845
Spreadsheet: 783233d1654684172-small-formula-doesnt-work-small
Sheet: Small

Score | Lowest 8 | Average |  | Manual Calc | Average
21.7 |  |  |  | 10.5
10.5 |  |  |  | 14
14.0 |  |  |  | 13.3
13.3 |  |  |  | 13.3
16.1 |  |  |  | 12.1
18.9 |  |  |  | 10.2
16.1 |  |  |  | 11.1
23.5 |  |  |  | 13
13.3
12.1
18.9
10.2
15.1
17
11.1
15.9
22.5
19.7
15.9
13.0
Spreadsheet: 685550d1594065134-need-help-with-revenue-recognition-schedule-schedule
Sheet: Sheet1

 | Cumulative % |  | 0.05 | 0.15 | 0.25 | 0.29 | 0.35 | 0.65 | 0.85 | 1
 | Product 1 |  | 13000
 | Product 2 |  |  | 15000
 | Product 3
 | Product 4 |  |  | 8000
 | Product 5
 | Product 6
 | Product 7
 | Product 8 |  |  |  | 8000
 | Product 9
 | Product 10
 | Schedule
 | Product 1
 | Product 2
 | Product 3
 | Product 4
 | Product 5
 | Product 6
 | Product 7
 | Product 8
 | Product 9
 | Product 10
Spreadsheet: 166633d1341672816-using-mod-row-to-display-in-every-nth-cell-with-some-cells-skipped-example-3
Sheet: Daily

Item # |  |  |  |  |  |  |  |  |  |  | < Example does not manage to repeat properly over gaps
1 |  |  |  |  |  |  |  |  |  |  | Repeat frequencys come from setup sheet
Total mg's
Friday |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  | < Attempt using count of 3 in blocks of 7 with 4 row gaps
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Item #
2
Total mg's
Friday
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < this number should b 1 ro lower as per the repeat of 1 value 2 blank rows
Sunday
Monday
Tuesday
Wednesday
Thursday
Item #
Total mg's
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Spreadsheet: 848784d1699427831-how-to-change-cell-value-based-on-date-excel-help-2-aligw
Sheet: Sheet2

 | Name | NRIC (xxxA) | Unit | Date of Class | Personal Email Address | Registered | Remarks | Course Completed | Progress | expected progress
1 | THAQIF | [NAME] | S17 Rota 2 | 2023-11-13 00:00:00 | [EMAIL] | True | 2023-10-23 00:00:00 | Not Completed | 174 / 272
2 | Nazrul | [NAME] | [NAME] 3 | 2023-11-13 00:00:00 | [EMAIL] | True | 2023-10-23 00:00:00 | Not Completed | 0 / 272
3 | EFFENDY | xxxJ | [NAME] 3 | 2023-11-13 00:00:00 | [EMAIL] | True | 2023-10-23 00:00:00 | Not Completed | 4 / 272
4 | HAZIQ | [NAME] | [NAME] 3 | 2023-11-13 00:00:00 | [EMAIL] | True | 2023-10-23 00:00:00 | Not Completed | 0 / 272
5 | Lynelle | xxxS | [NAME] 3 | 2023-11-13 00:00:00 | [EMAIL] | True | 2023-10-23 00:00:00 | Not Completed | 21 / 272
6 | HARIZ | xxxG | [NAME] 3 | 2023-11-13 00:00:00 | [EMAIL] | True | 2023-10-23 00:00:00 | Not Completed | 0 / 272
7 | MAX | [NAME] | [NAME] 3 | 2023-11-13 00:00:00 | [EMAIL] | True | 2023-10-23 00:00:00 | Not Completed | 0 / 272
8 | IMRAN | [NAME] | [NAME] 2 | 2023-11-13 00:00:00 | [EMAIL] | True | 2023-10-23 00:00:00 | ✓ | 272 / 272
9 | SYARIF | xxxP | [NAME] 2 | 2023-11-13 00:00:00 | [EMAIL] | True | 2023-10-23 00:00:00 | ✓ | 272 / 272
10 | ARFAN | [NAME] | [NAME] 3 | 2023-11-13 00:00:00 | [EMAIL] | True | 2023-10-23 00:00:00 | Not Completed | 0 / 272
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -38190
3531 | -695422 | -276683
60667 | -18 | -782731
60749 | 74665 | -111900
61206
61334 | -513675
62960
INDEX
2002-01-31 00:00:00 |  |  | 10496.07
2002-02-23 00:00:00
CBS Volume
2001-12-31 00:00:00 |  |  | 4346
Spreadsheet: 749149d1632532054-return-the-week-number-based-on-when-jan-1-started-return-the-week-number-based-on-when-jan-1-started
Sheet: ISOWEEKNUM

Day ------------> | 1
2010-01-01 00:00:00
https://www.excelforum.com/excel-formulas-and-functions/1360006-return-the-week-number-based-on-when-jan-1-started.html
Spreadsheet: 0633a02a-86e6-49e2-adf6-78ae2a7ea888
Sheet: Roads Special Assessment Notes

ROAD COMMISSION |  | SPECIAL ASSESSMENT  SCHEDULE |  |  |  |  |  | DECEMBER 31, 2013
 | new 2009 |  | new 2009 |  | new 2010 |  | new 2011 |  | new 2012
ISSUE: | [NAME] |  | Varsity Indust Park |  | Scio Hills |  | Uplands [NAME] |  | Polo Fields Bonds |  |  |  |  |  | Annual totals
YEAR | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest
 | ----------- | ------- | ----------- | ------- | ----------- | ------- | ----------- | ------- | ----------- | ------- | ----------- | ---------- | ----------- | ---------- | ----------- | -----------
2014 | 5000 | 553 | 29000 | 4278 | 36000 | 7921 | 36000 | 5266 | 75000 | 13070 |  |  |  |  |  |  | 2014
2015 | 5000 | 446 | 29000 | 3661 | 36000 | 6557 | 36000 | 4861 | 75000 | 12226.25 |  |  |  |  |  |  | 2015
2016 | 4000 | 340 | 29000 | 2973 | 36000 | 5192 | 36000 | 4366 | 75000 | 11195 |  |  |  |  |  |  | 2016
2017 | 5000 | 221 | 29000 | 2211 | 36000 | 3828 | 36000 | 3772 | 75000 | 9976.22 |  |  |  |  |  |  | 2017
2018 | 4000 | 93 | 29000 | 1378 | 36000 | 2464 | 35000 | 3054 | 75000 | 8570 |  |  |  |  |  |  | 2018
2019 | 1000 | 16 | 29000 | 471 | 36000 | 1099 | 35000 | 2179 | 75000 | 6976.25 |  |  |  |  |  |  | 2019
2020 |  |  |  |  | 11000 | 208 | 35000 | 1129 | 75000 | 5101.25 |  |  |  |  |  |  | 2020
2021 |  |  |  |  |  |  | 16000 | 280 | 75000 | 2945 |  |  |  |  |  |  | 2021
2022 |  |  |  |  |  |  |  |  | 56000 | 910 |  |  |  |  |  |  | 2022
 | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | ----------
Issuance Date | 2009-10-01 00:00:00 |  | 2009-10-01 00:00:00 |  | 2010-08-12 00:00:00 |  | 2011-08-04 00:00:00 |  | 2012-09-10 00:00:00
Issuance Amount | 43000 |  | 277000 |  | 349000 |  | 349000 |  | 738000
[NAME]): | Property Owners |  | Property Owners |  | Property Owners |  | Property Owners |  | Property Owners
Spreadsheet: 178094d1346654971-two-dimensional-vlook-up-find-team-reporting-to-shift-sample_workbook
Sheet: Sample

ID | Description | Registered | Deadline | Reporting Shift | Reporting Team
Task ID 1 | Task Description 1 | 2012-09-01 15:06:00 | 2012-09-02 15:06:00 | Based on Registered time Reporting Shift should be populated from Shift roaster i.e., (A, B, C); refer shift roaster | Based on Registered date Reporting Team should be populated from shift roaster i.e., (Team 1, Team 2, Team 3, Team 4, Team 5); refer shift roaster
Task ID 2 | Task Description 2 | 2012-09-02 15:06:00 | 2012-09-03 15:06:00
Task ID 3 | Task Description 3 | 2012-09-03 12:40:00 | 2012-09-04 12:40:00
Task ID 4 | Task Description 4 | 2012-09-03 23:40:00 | 2012-09-04 23:40:00
Task ID 5 | Task Description 5 | 2012-09-06 20:33:00 | 2012-09-07 20:33:00
Task ID 6 | Task Description 6 | 2012-09-05 05:41:00 | 2012-09-06 05:41:00
Task ID 7 | Task Description 7 | 2012-09-04 17:30:00 | 2012-09-05 17:30:00
Task ID 8 | Task Description 8 | 2012-09-01 04:36:00 | 2012-09-02 04:36:00