tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kam_keiser__17995__Info Request_Jan 11_02
Sheet: Form C

All suggested threshold levels on the following forms are for placeholder purposes only.  Final buckets to be determined following more in-depth analysis.
Enron and Affiliates
Counterparty Statistics as of:_____________
Counterparty Name:___________ | Date of Preparation:________
Statistic
Termination Status (Yes/No)
Date of Termination, if Applicable
Intercompany Counterparty (Yes/No)1
 | Financial | Physical | Total
Estimated MTM 2 ($)
# of Transactions
Transaction Distribution  by MTM 3 (#)
<$0mm
>=$0mm, <$1mm
>=$1mm, <$5mm
>=$5mm, <$10mm
>=$10mm
Tenor Distribution by Transactions (#)
< 1 year
>=1 year, <3 years
>=3 years, <5 years
>=5year, <10 years
>= 10 years
Tenor Distribution by MTM ($)
< 1 year
>=1 year, <3 years
>=3 years, <5 years
>=5year, <10 years
>= 10 years
Collateral Posted
Trading Accounts Receivable/Accounts Payable
Net Balance 4
Trade Type Distribution by Transactions (#)
Nymex look alike forward
Nymex look alike option
Basis Swap
Others 5
Trade Type Distribution by MTM ($)
Nymex look alike forward
Nymex look alike option
Basis Swap
Others 5
Payment Provision Distribution by Tranctions (#)
One Way
Two Way
Silent
Payment Provision Distribution by MTM ($)
One Way
Two Way
Silent
Enron Continued Performance 6
# of Enron Entities with Trades
Notes
1 Indication of  whether the Counterparty is an Enron entity
2 MTM ([NAME]-to-Market Value) reflects no adjustment for Collateral or Accounts Payable/Receivable
3  < indicates less than, >= indicates greater than/equal to
4  MTM adjusted for Collateral and Accounts Payable/Receivable
5 To be expanded depending on the underlying commodity
6  The number of non-terminated contracts under which is Enron still performing to the counterparty
Spreadsheet: 40588d1238972196-adding-rows-with-control-number-that-only-repeat-3-times-formula-help2
Sheet: Sheet1

[NAME] | Control Number | # of 0:15 | A-J | K | L | M | N | O | P | Q | Admin1 + Admin2 |  |  | Control Number | # of 0:15 | A-J | K | L | M | N | O | P | Q
201 | 4010101 | 8 | 26 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | QQJJPJJJPPJJJJJJJJJJPJJJJJJJQJQJJJ |  |  | 4010101 | 21 | 85 | 0 | 0 | 0 | 0 | 0 | 4 | 17
202 | 4010101 | 6 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | [NAME] |  |  | 4010102 | 30 | 68 | 0 | 0 | 0 | 0 | 0 | 14 | 16
203 | 4010101 | 7 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | DDQJJDDDDDDDDDDDDDJJQJJJJJJJJQQQQQ |  |  | 4010103 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
201 | 4010102 | 4 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | JJJJQJJJQJJJJJJJJJJJJJJJJQJJJJJJQJ |  |  | 4020101 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
202 | 4010102 | 14 | 16 | 0 | 0 | 0 | 0 | 0 | 14 | 0 | JJJJJJJJJ              PPPPPPPPPPPPPPJJJJJJJ
203 | 4010102 | 12 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | DDDDJJDDDDDDDDQQQJJJJJJJQQQQQQQQQD
201 | 4010103 | 16 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | CQQQQJJJJQQQQQQJJQQJJJJJJJQQQQCCCCC
201 | 4020101 | 0 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CCCJJJCCCCCCCCCCCCCCCCCCCCCCCCCCC
202 | 4020101 | 0 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CCCJJJCCCCCCCCCCCCCCCCCCCCCCCCCCC
203 | 4020101 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CCCJJJCCCCCCCCCCCCCCCCCCCCCCCCCCCC
I just need to show the following extra columns in my results
The idea remains the same, I just need the extra columns of D-K to show in my array formula
Results example in column O
Spreadsheet: 797975d1664249175-pick-from-a-list-selects-a-specified-cell-pokemon
Sheet: Types

Type | Normal | Fire | Water | Grass | Electric | Ice | Fighting | Poison | Ground | Flying | Psychic | Bug | Rock | Ghost | Dragon | Dark | Steel | Fairy | Attacker
Normal | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 0 | 1 | 1 | 0.5 | 1
Fire | 1 | 0.5 | 0.5 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 0.5 | 1 | 0.5 | 1 | 2 | 1
Water | 1 | 2 | 0.5 | 0.5 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 0.5 | 1 | 1 | 1 |  |  |  | Type Points
Grass | 1 | 0.5 | 2 | 0.5 | 1 | 1 | 1 | 0.5 | 2 | 0.5 | 1 | 0.5 | 2 | 1 | 0.5 | 1 | 0.5 | 1 |  |  | [NAME] |  | Attacking
Electric | 1 | 1 | 2 | 0.5 | 0.5 | 1 | 1 | 1 | 0 | 2 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 |  |  | Fire |  | Normal
Ice | 1 | 0.5 | 0.5 | 2 | 1 | 0.5 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 0.5 | 1 |  |  | Electric
Fighting | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 0.5 | 1 | 0.5 | 0.5 | 0.5 | 2 | 0 | 1 | 2 | 2 | 0.5 |  |  |  | Results
Poison | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 0.5 | 0.5 | 1 | 1 | 1 | 0.5 | 0.5 | 1 | 1 | 0 | 2 |  |  | Resistance Rating |  | Attack Rating
Ground | 1 | 2 | 1 | 0.5 | 2 | 1 | 1 | 2 | 1 | 0 | 1 | 0.5 | 2 | 1 | 1 | 1 | 2 | 1
Flying | 1 | 1 | 1 | 2 | 0.5 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 0.5 | 1 | 1 | 1 | 0.5 | 1
Psychic | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 0 | 0.5 | 1
Bug | 1 | 0.5 | 1 | 2 | 1 | 1 | 0.5 | 0.5 | 1 | 0.5 | 2 | 1 | 1 | 0.5 | 1 | 2 | 0.5 | 0.5
Rock | 1 | 2 | 1 | 1 | 1 | 2 | 0.5 | 1 | 0.5 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 0.5 | 1
Ghost | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 0.5 | 1 | 1
Dragon | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 0.5 | 0
Dark | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 0.5 | 1 | 0.5
Steel | 1 | 0.5 | 0.5 | 1 | 0.5 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 0.5 | 2
Fairy | 1 | 0.5 | 1 | 1 | 1 | 1 | 2 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 0.5 | 1
[NAME]
Spreadsheet: 361d1777-381a-4e29-8d5c-b2654cee32f2
Sheet: Sheet1

Table 1--U.S. cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  | 2013/14
Item | 2012/13 |  | May |  | June |  | July
 | Million acres
Upland:
Planted | 12.076 |  | 9.82 |  | 9.82 | 12.077 | 10.025
Harvested | 9.135 |  | 8.196 |  | 7.896 | 9.19 | 7.579
 | Pounds
Yield/harvested acre | 869 |  | 786 |  | 785 | 862 | 815
 | Million 480-lb. [NAME]
Beginning stocks | 3.081 |  | 3.771 |  | 3.386 | 3.081 | 3.72
Production | 16.535 |  | 13.42 |  | 12.92 | 16.25 | 12.872
Total supply   1/ | 19.621 |  | 17.196 |  | 16.311 | 19.336 | 16.597
[NAME] use | 3.43 |  | 3.475 |  | 3.475 | 3.38 | 3.475
Exports | 12.45 |  | 10.85 |  | 10.35 | 11.75 | 10.35
Total use | 15.88 |  | 14.325 |  | 13.825 | 15.13 | 13.825
Ending stocks  2/ | 3.72 |  | 2.866 |  | 2.481 | 4.241 | 2.767
 | Percent
Stocks-to-use ratio | 23.4 |  | 20 |  | 17.9 | 28 | 20
 | 1,000 acres
Extra-long staple:
Planted | 238.4 |  | 206 |  | 206 | 238.4 | 226
Harvested | 236.8 |  | 204 |  | 204 | 236.8 | 221
 | Pounds
Yield/harvested acre | 1581 |  | 1365 |  | 1365 |  | 1365
 | 1,000 480-lb. [NAME]
Beginning stocks | 269 |  | 229 |  | 214 |  | 180
Production | 780 |  | 580 |  | 580 |  | 628
Total supply   1/ | 1050 |  | 809 |  | 794 |  | 808
[NAME] use | 20 |  | 25 |  | 25 |  | 25
Exports | 850 |  | 650 |  | 650 |  | 650
Total use | 870 |  | 675 |  | 675 |  | 675
Ending stocks  2/ | 180 |  | 134 |  | 119 |  | 133
 | Percent
Stocks-to-use ratio | 20.7 |  | 19.9 |  | 17.6 |  | 19.7
1/ Includes imports.  2/ Includes unaccounted.
Sources: USDA, World Agricultural Outlook Board; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 07/15/13.
Spreadsheet: 48405d1247623185-help-with-a-formula-mafia-wars-loot-list-001
Sheet: Armour

[NAME] |  | Att | [NAME] | Units | Power
A Pint o' Green Beer |  | 15 | 29
Half Dollar Body Armor |  | 13 | 30
Stab-Proof Vest |  | 2 | 5
Lucky [NAME] |  | 1 | 7
Night Vision Goggles |  | 5 | 16
Bodyguards |  | 8 | 25
Falsified Documents |  | 2 | 30
I <3 Mom Tattoo |  | 15 | 22
Federal Agent |  | 15 | 25
[NAME]'s Vest |  | 14 | 26
Guerrilla Squad |  | 34 | 30
Camouflage Body Armor |  | 18 | 28
[NAME] Member |  | 20 | 14
Red Coat |  | 8 | 32
Tri-Point Hat |  | 8 | 12
Guerrilla Commando |  | 38 | 35
Davy Crockett Hat |  | 21 | 9
Che's Beret |  | 46 | 34
Gas Mask |  | 8 | 20
Spreadsheet: 813900d1674050115-stack-columns-stack_columns
Sheet: HAVE

NAME | OPERATOR | SAMPLE 1 | OPERATOR | SAMPLE 2 |  |  |  | NAME | OPERATOR | VALUE
X | = | 1 | < | 3 |  |  |  | X | = | 1 |  |  | = | 1
Y | = | 2 | = | 1 |  |  |  | Y | = | 2 |  | Y | = | 2
Z | < | 1 | = | 4 |  |  |  | Z | < | 1 |  | Z | < | 1
 |  |  |  |  |  |  |  | X | < | 3 |  | X | < | 3
 |  |  |  |  |  |  |  | Y | = | 1 |  | Y | = | 1
 |  |  |  |  |  |  |  | Z | = | 4 |  | Z | = | 4
Spreadsheet: 859773d1708019057-combine-all-tables-of-the-workbook-into-one-but-column-headers-are-different-option-2
Sheet: Batch A21

 |  | Name of Lecturers-  SSO Name-
 |  | [NAME] result Sheet
 |  | Student ID | First Name | Surname | Result Unit 502 Assessor-Car IV-  [NAME] | Result Unit 503   Assessor-Tab IV- A | 1st Term Progression | Result Unit 417  [NAME] IV- Oku | Result Unit 506 [NAME]  IV- Asa Ok | Result Unit 423 [NAME] sma IV-  [NAME] | 2st Term Progression | Result Unit 426 [NAME] IV- Pame | Result Unit 501 Assessor-Car IV- Pam | 3rd Term Progression | Unit Pass        out of 7 units | Certificate Claimed Yes/No | Claimed by | Date of Certificate Recieving | Received by | Certificate Claim File | Incorrect Name | [NAME] only File | Correct Name As pe Passport | Checked by
 |  | 12345 | [NAME] | [NAME] | Resit-Pass | Resit-Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
 |  | 12346 | FAHYMA | BEGUM | Pass | Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  | 2022-10-25 00:00:00 | Name not in Proper Case but student has received the certificate
 |  | 12347 | [NAME] | [NAME] | Pass | Pass | PP | Pass | Pass | Resit-Pass | PP | Resit-Pass | Pass | PP | 7 | Yes |  |  |  | yes
 |  | 12348 | Nicola [NAME] | [NAME] | Pass | Pass | PP | Pass | Pass | PD-Pass | PP | Pass | Pass | PP | 7 | Yes |  | N/A
 |  | 12349 | Olalade | Olalade | Resit-Pass | Resit-Pass | PP | Pass | Pass | Pass | PP | Resit-Pass | Resit-Pass | PP | 7 | Yes |  |  |  | yes
 |  | 12350 | Kamsiya | Kamsiya | Pass | Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
Withdrawn |  | 12351 | Kamsiya | Ratheesan | Not Submitted | Not Submitted | PT | Not Submitted | Not Submitted | Not Submitted | PT | Not Submitted | Not Submitted | PT | 0 | No
Withdrawn |  | 12352 | CELIA | Olalade | Not Submitted | Not Submitted | PT | Not Submitted | Not Submitted | Not Submitted | PT | Not Submitted | Not Submitted | PT | 0 | No
 | Withdrawn | 12353 | Gemma | Clarke | Resit-Pass | Refer | PT | Pass | Pass | Pass | PT | Withdrawn | Withdrawn | WD | 4 | WD
 | [NAME] | 12354 | REGINA | AMOO | Pass | Pass | WD | Withdrawn | Withdrawn | Withdrawn | WD | Withdrawn | Withdrawn | WD | 2 | WD
 | Withdrawn | 12355 | WALE | Olalade | Not Submitted | Not Submitted | WD | Withdrawn | Withdrawn | Withdrawn | WD | Withdrawn | Withdrawn | WD | 0 | WD
 |  | PP= Pass & Progress
 |  | PT= Progress with Trailing
 |  | Total learner |  |  | 33 | 33 |  | 31 | 31 | 31 |  | 30 | 30 | 30 | 8
 |  | Submission |  |  | 30 | 30 |  | 28 | 25 | 26 |  | 21 | 21
 |  | Submission Rate
 |  | Pass |  |  | 27 | 27 |  | 26 | 20 | 23 |  | 10 | 14
 |  | Refer |  |  | 3 | 3 |  | 2 | 5 | 3 |  | 11 | 7
 |  | Marking Pending |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0
 |  | Not Submitted
 |  | Passing rate |  |  |  |  |  |  |  |  |  |  |  | Overall achievement Rate
Spreadsheet: 90055d1289820357-selecting-last-n-unique-entries-in-range-b5298_test-1-
Sheet: Sheet2

Chicago | 95 | New York | 112
Chicago | 102 | Philadelphia | 90
Boston | 105 | Chicago | 75
Milwaukee | 139 | Chicago | 144
Miami | 96 | Chicago | 108
Chicago | 65 | Orlando | 118
Chicago | 95 | New York | 112
Chicago | 102 | Philadelphia | 90
Boston | 105 | Chicago | 75
Chicago | 94 | Golden State | 113
Chicago | 102 | Philadelphia | 90
Boston | 105 | Chicago | 75
Chicago | 94 | Golden State | 113
Milwaukee | 139 | Chicago | 144
Miami | 96 | Chicago | 108
Chicago | 65 | Orlando | 118
Chicago | 95 | New York | 112
Chicago | 102 | Philadelphia | 90
Boston | 105 | Chicago | 75
Chicago | 94 | Golden State | 113
Spreadsheet: 819520d1677562348-vlookup-specific-description-from-multiple-tabs-under-specific-header-name-in-one-column-s666-pq-prices-samples
Sheet: Price matched 3

Price File Name: Price_eff123123123
Price [NAME]
No_in_loader | No Price | No in sys | Difference
12 | 0 | 4
Matched_Prices
Code | Date | Part Code | Name | Price 1 | Price 2 | Price 3
AAA | 2023-01-26 00:00:00 |  |  | 0.1231
BBB | 2023-01-26 00:00:00 |  |  | 1.312
CCC | 2023-01-26 00:00:00 |  |  | 4.2342
Unmatched_Prices
Code | Date | Part Code | Name | Price 1 | Price 2 | Price 3
ABC | 2023-01-26 00:00:00 |  |  | 69.876 | 68.34 | 67.879
DEF | 2023-01-26 00:00:00 |  |  | 1.989
GHI | 2023-01-26 00:00:00 |  |  | 87.212
JKL | 2023-01-26 00:00:00 |  |  | 3.4234
MNO | 2023-01-26 00:00:00 |  |  | 1.044
PQR | 2023-01-26 00:00:00 |  |  | 1.232
STU | 2023-01-26 00:00:00 |  |  | 2.43
VWX | 2023-01-26 00:00:00 |  |  | 1.876
YZA | 2023-01-26 00:00:00 |  |  | 0.08997
Spreadsheet: 878434d1725517604-unique-text-join-and-transpose-by-formula-as-well-as-by-code-text-join-and-transpose-spill-2024-aligw
Sheet: Expected Result

Date | Particulars |  |  |  |  | Text Join |  |  | AliGW
2024-06-16 00:00:00 | [NAME],Greenland
 | Pistachio Glues
2024-06-16 00:00:00 | Wold Never Goes Wrong |  |  |  |  |  |  |  | [NAME]
 | [NAME]
2024-06-16 00:00:00 | Google Inc |  |  |  |  |  |  |  | Rusted Pure Base
 | Rusted Pure Base
2024-06-17 00:00:00 | Amazon Coporation |  |  |  |  |  |  |  | Pills & Lassi/Pistachio Glues
 | Pills & Lassi
 | Pills & Lassi
 | Pills & Lassi
 | Pistachio Glues
2024-06-17 00:00:00 | [NAME] LLC |  |  |  |  |  |  |  | Fever/Pola Ship
 | Fever
 | Pola Ship
 | Pola Ship
2024-06-18 00:00:00 | Wold Vision Pvt Ltd |  |  |  |  |  |  |  | Pola Ship
 | Pola Ship
 | Pola Ship
2024-06-18 00:00:00 | New Kalakriti |  |  |  |  |  |  |  | Pills & Lassi
 | Pills & Lassi
2024-06-20 00:00:00 | [NAME] |  |  |  |  |  |  |  | Addons/Harder
 | Addons
 | Harder
2024-06-20 00:00:00 | Hindustan Lever Ltd |  |  |  |  |  |  |  | Fever/Pola Ship/Pills & Lassi
 | Fever
 | Pola Ship
2024-06-21 00:00:00 | Overseas Market |  |  |  |  |  |  |  | Pola Ship
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-06-23 00:00:00 | Hindustan Lever Ltd |  |  |  |  |  |  |  | Fever/Pola Ship/Pills & Lassi
 | Pills & Lassi
 | Pills & Lassi
2024-06-30 00:00:00 | Reliance Telecom |  |  |  |  |  |  |  | Pure Base/Pola Ship
 | Pure Base
 | Pola Ship
2024-06-30 00:00:00 | Hindustan Lever Ltd |  |  |  |  |  |  |  | Fever/Pola Ship/Pills & Lassi
 | Pola Ship
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-07-03 00:00:00 | Alzazira Corporation Ltd |  |  |  |  |  |  |  | Pills & Lassi/Rusted Pure Base/Rusted Lock Film/Pure Base
 | Pills & Lassi
 | Rusted Pure Base
2024-07-03 00:00:00 | [NAME] |  |  |  |  |  |  |  | Rusted Pure Base/Rusted Pola Ship
 | Rusted Pure Base
 | Rusted Pure Base
 | Rusted Pola Ship
 | Rusted Pola Ship
 | Rusted Pola Ship
2024-07-03 00:00:00 | Botanical Garden |  |  |  |  |  |  |  | Fever/Pola Ship
 | Fever
 | Pola Ship
 | Pola Ship
2024-07-07 00:00:00 | Plast Product |  |  |  |  |  |  |  | BONE Sheet/Rusted BONE Sheet
 | BONE Sheet
 | Rusted BONE Sheet
2024-07-08 00:00:00 | Alzazira Corporation Ltd |  |  |  |  |  |  |  | Pills & Lassi/Rusted Pure Base/Rusted Lock Film/Pure Base
 | Rusted Lock Film
 | Pills & Lassi
2024-07-10 00:00:00 | Alzazira Corporation Ltd |  |  |  |  |  |  |  | Pills & Lassi/Rusted Pure Base/Rusted Lock Film/Pure Base
 | Pure Base
 | Pills & Lassi
 | Rusted Pure Base
2024-07-12 00:00:00 | Maharaja Pvt. Ltd., Capetown |  |  |  |  |  |  |  | Rusted Pola Ship/Pola Ship
 | Rusted Pola Ship
2024-07-12 00:00:00 | Maharaja Pvt. Ltd., Capetown |  |  |  |  |  |  |  | Rusted Pola Ship/Pola Ship
 | Pola Ship
 | Pola Ship
 | Pola Ship
2024-07-24 00:00:00 | London Nepal Ltd,Losangles |  |  |  |  |  |  |  | Pola Ship
 | Pola Ship
2024-07-24 00:00:00 | London Nepal Ltd,Losangles |  |  |  |  |  |  |  | Pola Ship
 | Pola Ship
2024-07-28 00:00:00 | The Kingdom of Plant of Apes |  |  |  |  |  |  |  | Pills & Lassi
 | Pills & Lassi
 | Pills & Lassi
Spreadsheet: 147479d1332814739-is-averageifs-the-correct-function-to-use-averageifs
Sheet: Sheet1

 |  | Average Score For Lessons 2,3,4 & 5 Combined
 | [NAME]
 | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] No.
 | [NAME] |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | [NAME] |  |  |  |  |  | [NAME] | 5 | 4 | 4.5 | 6 | 7 | 2.5 | 3 | 5 | 6 | 7
 |  |  |  |  |  |  | [NAME] | 1 | 2 | 4 | 5.5 | 3 | 2.5 | 1 | 2 | 4 | 6
 |  |  |  |  |  |  | [NAME] | 2 | 3 | 3.5 | 5 | 5 | 4 | 6 | 3 | 4 | 2.5
 |  |  |  |  |  |  | [NAME] | 6 | 4 | 3 | 4.5 | 3 | 5 | 6 | 3 | 6 | 4.5
 |  |  |  |  |  |  | [NAME] | 3 | 5 | 4 | 6.5 | 5.5 | 4 | 3 | 5 | 4.5 | 5
Spreadsheet: 849696d1700110664-stuck-with-sum-using-index-match-or-vlookup-total-shifts
Sheet: Duty Rota

DEPARTMENT: |  |  |  |  |  |  |  |  | MONTH/YEAR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THR | TWD | OFF
NO | Name of Staff | ERP # | DESIGNATION | WE | TH | FR | SA | SU | MO | TU | WE | TH | FR | SA | SU | MO | TU | WE | TH | FR | SA | SU | MO | TU | WE | TH | FR | SA | SU | MO | TU | WE | TH
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  |  |  | Day | Afternoon | Total Days Worked | Total Hrs
1 |  |  |  | D1 |  |  |  |  |  |  |  |  |  | D2
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Leave Legends
AL | Annual Leave
BL | Birthday Leave
APL | Appreciation Leave
CME | [NAME]
SL | [NAME]
WO | Weekly Leave
PH | Public Holiday
CO | Compensatory Off
EL | Emergency Leave
OL | On [NAME]
ML | Maternity Leave
PL | Parental Leave
LOP | Loss Of Pay
WO/PH | Week Off & Ph Same Day
MI | Mission
Spreadsheet: 811246d1672374095-vlookup-in-multiple-column-vlookup_multiplecolumns
Sheet: Result

Center | Area | Location
0001 | 0001
0001 | 0088
0001 | 0100
2000 | 0003
2000 | 0004
2048 | 0003
2048 | 0004
2048 | 0005
2048 | 0006
2048 | 0008
2048 | 0009
2048 | 0010
2048 | 0011
2048 | 0015
2048 | 0016
Spreadsheet: 106807d1303990542-conditional-formatting-copy-of-conditional-formatting-file
Sheet: Sheet1

Project # | Start Date | Completion Date | Comments | In Progress
1 | 2011-01-15 00:00:00 |  | 04/15/11 - completed 03/15/ - delayed 02/15 - on schedule | No
2 | 2011-02-15 00:00:00 |  | 03/22  - cancelled 02/22/11 - on schedule | No
3 | 2011-03-15 00:00:00 |  | 03/22 - on schedule | Yes
4 | 2011-04-15 00:00:00 |  | 04/22 - on schedule | Yes
Spreadsheet: 684479d1593394100-ongoing-technical-issue-with-workbook-blank-logbook
Sheet:  LTU Case Observation Record

Clinician Observed:
Course:
Year:
Client Initials:
Principal Diagnosis:
Date | Issues Addressed | Therapeutic Procedures Observed, Important Issues Raised In Supervision, Your Own Thoughts etc | Direct Client Contact(hrs) | Group Supervision (hrs)
 | * Reminder: Do not duplicate LTU case observation hours in the LTU placement logbook. Hours counted in the LTU Case Observation Record (i.e., this sheet) will tally to the front page and contribute to the total placement hours. |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | Direct Client Contact(hrs) | Group Supervision (hrs)
TOTALS =
Candidate Name:  ______________________________ Candidate Signature:  ______________________________ Date: ___________
[NAME]:  _____________________________ Supervisor Signature:  _____________________________ Date: ___________
Clinic Director [NAME] : __________________________ Clinic Director Signature : __________________________  Date: ___________
Placement Coordinator Name : __________________ Placement Coordinator Signature : ___________________  Date: ___________
Spreadsheet: 5b3b1a53-96ab-44a3-9f12-897a9b72cb5c
Sheet: Table 1.3

Monthly Statistical Bulletin
1.3 Labour force
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Labour force (a) – '000
July | 11620.6545133 | 11817.5186989 | 12015.989578 | 12158.5310091 | 12348.642398
August | 11600.639055 | 11817.4309382 | 12033.1019382 | 12146.8835702 | 12346.1746877
September | 11627.5048944 | 11854.6392796 | 12051.8078042 | 12212.3525704 | 12335.97349
October | 11634.4838485 | 11910.9336559 | 12049.3258333 | 12204.7158762 | 12347.667473
November | 11655.3740213 | 11954.1599318 | 12064.2894837 | 12208.7250501 | 12366.0723641
December | 11686.7246373 | 11931.7567365 | 12031.2714678 | 12234.279613 | 12351.4595982
January | 11697.7691374 | 11908.3217718 | 12057.4399216 | 12291.5250426
February | 11710.8206541 | 11962.0228648 | 12075.9915798 | 12315.5163525
March | 11732.817787 | 11996.520653 | 12131.1712562 | 12307.2232277
April | 11753.3348839 | 11958.3628059 | 12096.6946597 | 12344.1128167
May | 11717.465191 | 11958.2482826 | 12157.9026224 | 12335.5584391
June | 11773.6974754 | 11991.4570343 | 12133.1340821 | 12366.4865517
Annual average | 11682.48306658333 | 11924.44913458334 | 12073.47079758333 | 12256.82264330833
Participation rate (a) (b) – per cent
July | 65.5167592 | 65.5050332 | 65.5669653 | 65.2250529 | 65.0744718
August | 65.2956483 | 65.4238577 | 65.581463 | 65.0662768 | 64.9698475
September | 65.3386324 | 65.5496943 | 65.6055109 | 65.3207439 | 64.8254068
October | 65.2923107 | 65.7838786 | 65.5050397 | 65.1931229 | 64.7867041
November | 65.3239784 | 65.9443152 | 65.4989779 | 65.1274519 | 64.7826632
December | 65.4142126 | 65.7438649 | 65.2333481 | 65.1772505 | 64.6065434
January | 65.3657326 | 65.5043918 | 65.2633224 | 65.3630338
February | 65.3278136 | 65.6969269 | 65.2518009 | 65.3712763
March | 65.3406378 | 65.7840456 | 65.438134 | 65.2087824
April | 65.3798022 | 65.4933113 | 65.1642999 | 65.316609
May | 65.1045737 | 65.4106436 | 65.4058762 | 65.1838903
June | 65.3421317 | 65.5109819 | 65.1849775 | 65.2600024
Annual average | 65.33685276666665 | 65.61257875 | 65.39164298333333 | 65.23445775833333
(a) Monthly figures are seasonally adjusted.
(b) Labour force as a proportion of the civilian population aged 15 years and over. |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6202.0 |  |  |  |  |  |  |  | 2014-02-13 00:00:00
Spreadsheet: 4b5fa2c0-066b-467d-bbf0-343b865848f3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Employment Module |  |  | Please circle the appropriate answer for the following questions:
 |  |  | Pre |  |  |  | Post
Have you taken an interest/vocational assessment |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar
Have you used school resources to investigate different types of employment |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar
Are you familiar with a one stop career center |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar
Are you familiar with a local employment agency |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar
Are you familiar with job shadowing, internship and volunteer opportunities |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar
Have you filled out employment applications |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar
Have you created a resume and cover letter |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar
Have you participated in mock interviews |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar
Do you know how to obtain a work permit |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar
Do you have work experience (paid or unpaid) |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar
Can you interpret pay stub information |  |  | Not Familiar | Somewhat Familiar | Very Familiar |  | Not Familiar | Somewhat Familiar | Very Familiar