tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 733964d1621932610-copy-and-transpose-formula-auto
Sheet: Payables

I kindly asking for a formula which can automatically transpose data from Auto sheet to Payables  sheet as shown in the desired outcome.
DESIRED OUTCOME
 | ST 002 | Net Salaries | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
2021-01-01 00:00:00 | 7 | 2 | 0 | 0 | 0
2021-01-25 00:00:00 | 0 | January |  | 185503.5 | -185503.5
2021-01-26 00:00:00 | 16 | 5 | 6581 |  | -178922.5
2021-01-26 00:00:00 | 17 | 5 | 5793 |  | -173129.5
2021-01-26 00:00:00 | 18 | 5 | 4461 |  | -168668.5
2021-01-26 00:00:00 | 19 | 5 | 7913 |  | -160755.5
2021-01-26 00:00:00 | 20 | 5 | 4953 |  | -155802.5
2021-01-26 00:00:00 | 21 | 5 | 4043 |  | -151759.5
2021-01-26 00:00:00 | 22 | 5 | 4584 |  | -147175.5
2021-01-26 00:00:00 | 23 | 5 | 11043 |  | -136132.5
2021-01-26 00:00:00 | 24 | 5 | 3399 |  | -132733.5
2021-01-26 00:00:00 | 25 | 5 | 4580 |  | -128153.5
2021-01-26 00:00:00 | 26 | 5 | 11134 |  | -117019.5
2021-01-26 00:00:00 | 27 | 5 | 4107 |  | -112912.5
2021-01-26 00:00:00 | 28 | 5 | 4359 |  | -108553.5
2021-01-26 00:00:00 | 29 | 5 | 7929 |  | -100624.5
2021-01-26 00:00:00 | 30 | 5 | 10480 |  | -90144.5
2021-01-26 00:00:00 | 31 | 5 | 9370 |  | -80774.5
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | ST 003 | NSSA | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
2021-01-01 00:00:00 | 2 | 2 | 0 | 0 | -1983.41
 | 0 | January
2021-02-25 00:00:00 | 0 | february |  |  | 0
2021-03-25 00:00:00 | 0 | march |  |  | 0
2021-03-31 00:00:00 | 136 | 136 |  |  | 0
2021-04-25 00:00:00 | 0 | April |  |  | 0
0 | ST 004 | NEC | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
2021-01-01 00:00:00 | 1 | 1 | 0 | 0 | -4054.46
 | 0 | January
2021-02-25 00:00:00 | 0 | february |  |  | 0
2021-03-25 00:00:00 | 0 | March |  |  | 0
2021-03-31 00:00:00 | 140 | 140 |  |  | 0
Spreadsheet: 864436d1711605486-merging-multiple-tables-based-on-unique-id-query
Sheet: x5

Sr. No. | Description | X5
1 | AAA | 1
2 | BBB | 2
3 | CCC | 1
4 | DDD | 3
5 | EEE | 0
6 | FFF | 1
7 | GGG | 2
8 | HHH | 4
9 | III | 2
10 | JJJ | 1
11 | KKK | 0
12 | LLL | 1
Spreadsheet: 848053d1698858584-remove-duplicates-from-one-column-and-concat-data-from-another-column-forum-query-example
Sheet: Sheet1

column 1 | column 2 | column 3 | Column 4 |  | column 1 | column 2 | Custom | Column 4
abc1 | abc2 | 1234 | a |  | abc1 | abc2 | 1234-5678 | a
abc1 | abc2 | 5678 | g |  | bce2 | bce3 | 4556 | h
bce2 | bce3 | 4556 | h |  | def3 | def4 | 5678 | j
def3 | def4 | 5678 | j
Spreadsheet: 715730d1611845102-help-reducing-the-amount-of-formulas-to-show-the-sum-attendance-sample-for-excel-help
Sheet: Team Dashboard

Enter the year | à | YEAR |  | See Data Table More than 1 Time Entry |  |  |  |  | Holiday |  |  |  | Weekends |  |  |  |  | NA / Not Employed
 |  | 2021
Enter the month | à | MONTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTHLY SUMMARY
 |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1> |  |  |  |  |  |  |  | Total Negative | Work Days
Spreadsheet: 110409d1307074666-using-list-of-values-data2
Sheet: Data

Department | Position / Title
Human Resources | HR Business Partner
Human Resources | HR Manager
Human Resources | HR Manager Commercial
Human Resources | HR Systems and Projects Manager
Human Resources | International Human Resources Advisor
Human Resources | Learning and Development Manager
Human Resources | OHS Manager
Human Resources | Payroll Operations Manager
Human Resources | Recruitment Manager
Information Technology | Business Services Manager
Information Technology | Customer Services Manager
Information Technology | Enterprise Architecture & Planning Manager
Information Technology | Project Management Office Manager
Information Technology | Technical Services Manager
Marketing, Fundraising & Communications | Business & Philianthropic Partnerships Manager
Marketing, Fundraising & Communications | Digital Media Manager
Marketing, Fundraising & Communications | Digital Services Manager
Marketing, Fundraising & Communications | Direct Marketing Manager
Marketing, Fundraising & Communications | Donor Relations Manager
Marketing, Fundraising & Communications | Events & Ambassador Manager
Marketing, Fundraising & Communications | Fundraising National Manager
Marketing, Fundraising & Communications | Head of Communications & Brand
Marketing, Fundraising & Communications | Head of Fundraising
Marketing, Fundraising & Communications | Head of Marketing
Marketing, Fundraising & Communications | Head of Media
Marketing, Fundraising & Communications | Head of Projects, Business Improvements & Benchmarking
Marketing, Fundraising & Communications | Member & Community Fundraising Manager
Marketing, Fundraising & Communications | National Brand Manager
Marketing, Fundraising & Communications | Supporter Services Manager
Marketing, Fundraising & Communications | Trusts & Foundation Manager
National Management Team | Chief Executive Officer
National Management Team | Chief Financial Officer
National Management Team | Director Commercial Operations
National Management Team | Director Human Resources
National Management Team | Director Information Technology
National Management Team | Director of Marketing, Fundraising & Communications
National Management Team | Director Strategy, Planning & Research
National Management Team | Directory Services & International Operations
National Management Team | Executive Director
National Management Team | Head of Australian Services
National Management Team | Head of International Programs
Services - QLD | Group Manager Community Services (QLD)
Services - QLD | Group manager Strateigc Development & Coordination (QLD)
Services - QLD | Manager Emergency Services (QLD)
Services - QLD | Program Manager (QLD)
Services - QLD | Property Manager (QLD)
Services - QLD | Regional Manager (QLD)
Services - QLD | Regional Manager Training Services (QLD)
Services - QLD | Regional Office Manager (QLD)
Services - QLD | Service Delivery Manager (QLD)
Services - QLD | State Manager, A&TSI Partnerships (QLD)
Spreadsheet: 578b4e7f-de65-4826-8131-ad412f28bc28
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | PENGOLAHAN SKOR INSTRUMEN EVALUASI DIRI
 |  | PENILAIAN KINERJA GURU
 |  | NAMA
 |  | UNIT
 |  | NO | DIMENSI | BOBOT | SKOR | KREDIT
 |  | 1 | Pendidikan
 |  | 2 | Pengalaman [NAME]
 |  | 3 | Pelatihan/Kursus/Workhop
 |  | 4 | Seminar/Lokakarya
 |  | 5 | Menghasilkan setiap karya inovatif
 |  | 6 | Mendapat Penghargaan sebagai guru [NAME]
 |  | 7 | Perencanaan Belajar
 |  | 8 | [NAME] ([NAME])
 |  | 9 | [NAME]
 |  | 10 | [NAME] Prestasi Peserta didik
 |  | 11 | Menghasilkan karya inovatif
 |  | 12 | Mendapat Tugas sebagai
 |  | 13 | [NAME]
 |  |  | TOTAL ANGKA KREDIT
Spreadsheet: darrell_schoolcraft__7532__Eott Summary UAF Reports 2002
Sheet: Score Card

EOTT SUMMARY SCORECARD - January 2002
 | Target % |  | Target % |  | Target % |  | Target % |  | Target % |  | Target %
 | 0.0004 |  | 0.0002 |  | 0.0002 |  | 0.0002 |  | 0.0002 |  | 0.0001
System | Current Month |  | 1st Quarter |  | 2nd Quarter |  | 3rd Quarter |  | 4th Quarter |  | Year to Date
 | Volume | % | Volume | % | Volume | % | Volume | % | Volume | % | Volume | %
[NAME] | -322 | -0.06
Miss/Ala | -2175 | -0.16
Pearsall | 740 | 1.14
SW LA | 434 | 0.15
SE/OLP | 1990 | 0.18
[NAME] | 587 | 0.16
TNM Texas | 8605 | 0.47
TNM NMx | 958 | 0.07
North Texas | -406 | -0.37
WTX | 3584 | 0.35
Red River | 1388 | 0.79
Buffalo | -3365 | -0.43
Cherokee | -484 | -0.1
Osage | -260 | -0.08
Odessa | -30 | -0.03
KS | 3478 | 0.36
Hobbs | 4475 | 0.32
SW/OLP | -4440 | -0.59
N Dakota | -15 | 0
Totals |  | -0.05993268813352431
Note: Bold indicates time periods targets are achieved
Spreadsheet: 837980d1690567559-lists-excel-list-example
Sheet: Sheet1

HAVE
Student ID | student name | course | Code | current score | final score | unposted current score | unposted final score
2208171411 | Student A | Foundations Clinical | PN102 |  | 0 |  | 0
2208171411 | Student A | Foundations of Practical Nursing | PN104 | 79.04 | 13.09 | 79.04 | 13.09
2208171411 | Student A | IV Therapy | IV202 | 86.67 | 13 | 86.67 | 13
1607120895 | Student B | Career Readiness | CD101 | 73.28 | 7.46 | 73.28 | 7.46
1607120895 | Student B | Nursing III | PN301 | 88 | 66.03 | 88 | 66.03
1607120895 | Student B | [NAME] -Akhere | CLINICAL | 100 | 63.16 | 100 | 63.16
NEED
Student ID | student name | course | Code | current score | final score | unposted current score | unposted final score | course | Code | current score | final score | unposted current score | unposted final score | course | Code | current score | final score | unposted current score | unposted final score
2208171411 | Student A | Foundations Clinical | PN102 |  | 0 |  | 0 | Foundations of Practical Nursing | PN104 | 79.04 | 13.09 | 79.04 | 13.09 | IV Therapy | IV202 | 86.67 | 13 | 86.67 | 13
1607120895 | Student B | Career Readiness | CD101 | 73.28 | 7.46 | 73.28 | 7.46 | Nursing III | PN301 | 88 | 66.03 | 88 | 66.03 | [NAME] -Akhere | CLINICAL | 100 | 63.16 | 100 | 63.16
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 46

कार्यक्रम PROGRAM |  |  | एनपीए एर्िं र्सूली प्रबिंधन NPA & RECOVERY MANAGEMENT | PROG CODE
 |  |  |  | IT 1704
तर्षर् समूह/JOB FAMILY |  |  | CREDIT MONITORING, LEGAL AND RECOVERY
उद्देश्य/OBJECTIVE |  |  | LEGAL AND RECOVERY ASPECTS
लतक्षि समूह/TARGET GROUP |  |  | [NAME]
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Inauguration & Pre- Test, SMA Concept   & identification of   early warning  signals,  effective    Follow  up  of  accounts,  Prevention  of Slippage  to  NPA  due  to   Technical  &  Non-technical  reasons,  NPA classification, Delinquency norms for various types of Advances
 | II | Restructuring  Policy  of  the  Bank  and  various  [NAME]  under Restructuring
 | III | Legal  Methods  of  Recovery  -  Suit  filing,  Obtention  of  decree,  EP filing, DRT/ LOKADALAT /IBC; LIQUIDATION OF COMPANIES; NCLT and its importance, Procedural Guidelines.
 | IV | Case  studies  on  various  OTS  Schemes,  Recovery  In  written  off Accounts, Granting Fresh Facility to OTS Beneficiaries, Valuation of Assets, Matters regarding Staff Lapses, Right of Recompense
Day 2 | I | Other methods of Recovery: (a) Auction of Gold Jewelry, (b) Sale of Assets by mutual consent (c) Recovery through  Authorized Agencies, Policy on Recovery/Seizure  Agents
 | II & III | Contours of SARFAESI Act
 | IV | Group discussion on NPA management.
Day 3 | I | Customer Relationship Management & Motivational Session
 | II | Asset and Liability Products of the Bank
 | III | Negotiation Skill & Conflict Management
 | IV | Business Ethics and Value System & Valediction
Spreadsheet: 836033d1689061427-i-want-to-format-452365214-as-452-365-214-example
Sheet: Sheet1

[NAME]: General |  | [NAME]: Custom |  | [NAME]: unknown conditional format [wanted]
235265758 |  |  |  | 235, 265, 758
32001200 |  |  |  | 32, 001, 200
36000000 |  |  |  | 36, 000, 000
3200 |  |  |  | 3, 200
300250 |  |  |  | 300, 250
35026014702 |  |  |  | 35, 026, 014, 702
Spreadsheet: 212666f5-7c3a-4c64-885e-fe574dac1f5d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | [NAME] vs. [NAME] |  |  | Brain vs. [NAME] |  |  | Brain vs. [NAME]
 |  | R | P |  | R | P |  | R | P
Metastable Epialleles | BOLA3 | 0.92 | 0.001 |  | 0.89 | 0.003 |  | 0.94 | 0.001
 | FLJ20433 | 0.77 | 0.025 |  | 0.77 | 0.025 |  | 0.79 | 0.02
 | PAX8 | 0.84 | 0.009 |  | 0.64 | 0.086 |  | 0.81 | 0.015
 | SLITRK1 | 0.78 | 0.02 |  | -0.16 | 0.696 |  | -0.26 | 0.538
 | ZFYE28 | 0.82 | 0.013 |  | 0.77 | 0.025 |  | 0.93 | 0.001
Control Genes | IGF2 DMR | 0.06 | 0.88 |  | 0.02 | 0.96 |  | -0.61 | 0.11
 | GNASAS | -0.23 | 0.59 |  | 0.47 | 0.24 |  | 0.51 | 0.2
 | IL10 | 0.39 | 0.34 |  | 0.11 | 0.79 |  | 0.38 | 0.34
* R = Pearson correlation coefficient. P = P value. N=8 individuals (Asian samples).
Spreadsheet: 848078d1698875002-formula-to-rearrange-data-as-pasted-from-external-source-workbook-example
Sheet: AutoFill and Computation

 | Question 1
 | Question 2
 | Question 3
 | Question 4
 | Question 5
 | Question 6
 | Question 7
 | Question 8
 | Question 9
 | Question 10
 | Question 11
 | Question 12
Spreadsheet: 882869d1731347978-copying-creating-a-zipcode-postcode-distance-checker-assistance-postcode-distance-checker
Sheet: Multiple US

Multiple UK Postcode distances
PostCode_1 | PostCode_2 | Lat_1 | Long_1 | Lat_2 | Long_2 | Distance (miles)
10002 | 10003
10003
10004
10005
10006
10007
10008
10009
1001
10002
10003
10004
10005
10006
10007
10008
Spreadsheet: 263434d1378474747-ifvlookup-issue-ifvlookup-problem
Sheet: Info

CODE | CASE | HEADER LABEL | BASE LABEL | BSTO
425034 | [NAME] | pkg printed | pkg printed | NA
6241052 | BCD016401 | Print Case Label on > | BCD425301
6241054 | BCD015901 | BLL007801 | N/A | BST194601
15024503 | BCD009207 | [NAME] | NA | NA
15109927 | BDD213404 | BLL008801 | BLB151562 | NA
15109935 | BCD213404 | BLL008801 | BLB151562 | [NAME]
15109937 | BCD213404 | BLL008801 | BLB151562 | BST188101
15109938 | BCD213404 | BLB196801 | BLB151562 | BST190101
15109939 | BCD213404 | BLL008801 | BLB151562 | [NAME]
15109940 | BCD213404 | BLL008801 | BLB151562 | BST193001
15109941 | BCD213404 | BLL008801 | BLB151562 | BST111501
15110524 | BCD213404 | BLB196701 | [NAME] | [NAME]
15110527 | BCD213404 | BLB196701 | [NAME] | BST188101
15110528 | BCD213404 | BLB196701 | [NAME] | [NAME]
15110530 | BCD213404 | BLB196701 | [NAME] | NA
15110531 | BCD213404 | BLB196701 | [NAME] | BST111501
15113619 | BCD213404 | BLB196301 | BLB151461 | NA
15113626 | BCD213404 | BLB196301 | BLB151461 | [NAME]
15113627 | BCD213404 | BLB196301 | BLB151461 | BST111501
15577600 | BCD016501 | BLL014201 | BLL014601 | NA
15579000 | BCD016501 | BLL014301 | BLL014701 | NA
05301018 | BCD214403 | BLB194501 | NA | NA
05726100 | [NAME] | [NAME] | BLB120261 | NA
05726105 | [NAME] | [NAME] | BLB120261 | [NAME]
05726111 | [NAME] | [NAME] | BLB120261 | BST189301
Spreadsheet: 802939d1667159713-replace-the-missing-value-questions
Sheet: Sheet1

 | ABU DHABI ISLAMIC BANK | ABU DHABI ISLAMIC BANK
var1 | 5267334.16943912 | 5200070.00119889
var2 | 5222603.47053703 | 5156696.2105157
var3
var4 | 5518071.4277029 | 5393371.0466423
var5 | 4965185.34379643 | 4866951.0791325
var6 | 4979683.29587089 | 4905091.43442005
var7
var8 | 4505347.85319235 | 4432721.76727485
[NAME] | 4057063.8283173 | 3998197.48356179
var10 | 4009945.52919095 | 3971333.7787906
var11
var12 | 3493839.97016001 | 3465455.19861606
var13 | 3269021.88343113 | 3246863.14711019
var14 | 3032077.81331489 | 3007647.44936697
var15
[NAME] | 2744094.99339558 | 2730300.90118043
var17 | 2550174.1575624 | 2537616.48208387
var18 | 2468419.42331124 | 2455924.11192662
var19
var20 | 2073152.4331315 | 2061980.31459919
var21 | 1981100.91696253 | 1973237.28069966
var22 | 1891524.05421613 | 1892383.12323889
var23
var24 | 3086595.26098818
var25 | 3095199.03866988
var26 | 3027078.3716995
var27
var28 | 2955650.56028929
var29 | 2769525.10541856
var30
var31 | 2861079.78858956 | 2878850.40059636
var32 | 2727818.23561023 | 2770113.08838511
var33
[NAME] | 2908590.3729136 | 2950475.11040103
var35 | 3028283.82272333 | 3068945.89786047
var36 | 2814553.4620294 | 2857265.19428644
var37
var38 | 2656099.08351421 | 2972827.15117421
var39 | 2419841.55179062 | 2464042.11256285
var40 | 2537634.58264194 | 2583112.29189842
var41
var42 | 2184974.88114906 | 2232203.30228062
var43 | 2011095.33421826 | 2058689.55315037
var44 | 1833691.38606632 | 1875673.81036229
var45
var46 | 1578997.01516261 | 1621333.34473372
var47 | 1482323.90829831 | 1521842.8255035
var48 | 1349112.72586756 | 1385864.75833211
var49
var50 | 1156521.49997256 | 1193781.54760325
var51 | 1106537.34723879 | 1126389.50884692
var52 | 1089449.15978929 | 1126297.55272441
var53
var54 | 1739977.81374175
var55 | 1550054.78125155
var56 | 1436720.32502981
var57
var58 | 1515082.47774276
var59 | 1486615.99882245
var60
[NAME] | 2749144.00327493 | 2762726.82454763
var62 | 2628134.66984615 | 2643352.96333272
var63
var64 | 2799914.57651532 | 2810235.13828433
var65 | 2918861.69073999 | 2927821.04427087
var66 | 2703399.41495486 | 2714455.86199461
[NAME]
var68 | 2541158.35016914 | 2825775.23648519
var69 | 2315071.89433169 | 2327491.06771533
var70 | 2437498.96666369 | 2450233.74443521
var71
var72 | 2102925.43700992 | 2118305.21487608
[NAME] | 1941502.2920147 | 1957910.64395035
var74 | 1768078.8502457 | 1781124.24417624
var75
var76 | 1528058.69757079 | 1551245.64999478
var77 | 1428347.76555561 | 1448693.04678693
var78 | 1296221.79002567 | 1313564.16031789
var79
var80 | 1117236.04968933 | 1137069.13734784
var81 | 1072190.45189181 | 1076235.90638542
var82 | 1053301.90210617 | 1083365.88936852
var83
var84 | 1687067.92880688
var85 | 1504273.20421207
var86 | 1399430.09709972
[NAME]
var88 | 1479008.58212033
var89 | 1447336.60483038
Spreadsheet: 54730d1254793154-book-recommendation-to-learn-excel-want-a-macro-to-extract-tickers-pivot-table-temp
Sheet: Sheet1

[NAME] 30 | Focus: energy stocks | [NAME]:
Senior portfolio manager, |  | TALISMAN ENERGY INC. (TLM-T)
Sentry Select |  | PENGROWTH ENERGY TRUST (PGF.UN-T)
 |  | ENERPLUS RESOURCES FUND (ERF.UN-T)
Prakash Hariharan Sep 29 | Focus: fixed income and dividend-paying stocks. [NAME]: [NAME]. Shares; Fairfax Financial Holdings ( 7.35%, 2018 bonds) | [NAME]:
portfolio manager, |  | VERMILION ENERGY TRUST (VET.UN-T)
Front Street Capital
[NAME] 28 | Focus: oil and gas | [NAME]:
Senior Vice-President & Portfolio Manager, |  | ENCANA (ECA-T)
First Asset Management |  | HESS (HES-N)
 |  | CANADIAN NATURAL RESOURCES (CNQ-T)
Brent Cook Sep 25 | Focus: junior mining stocks and commodities | [NAME]:
Editor, |  | SPROTT RESOURCE CORP. (SCP-T)
Exploration Insights |  | MIRASOL RESOURCES (MRZ-X)
 |  | EVOLVING GOLD CORP. (EVG-X)
[NAME] Sep 24 | Focus: technical investing | [NAME]:
associate portfolio manager & technical analyst, |  | TEVA PHARMACEUTICAL (TEVA-Q)
Value Trend Wealth Management |  | ALIMENTATION COUCHE TARD (ATD.B-T)
 |  | SECTOR SPDR CONSUMERS DISCRETIONARY ETF (XLY-N)
[NAME] 23 | Focus: Canadian and U.S. large caps | [NAME]:
President, |  | MANULIFE FINANCIAL (MFC-T)
Baskin Financial Services |  | IGM FINANCIAL (IGM-T)
 |  | ROGERS COMMUNICATIONS (RCI.B-T)
[NAME] 22 | Focus: oil and gas stocks | [NAME]:
executive vice-president, |  | CEQUENCE ENERGY (CQE-T)
Qwest Investment Fund Management |  | GLAMIS RESOURCES (GLM.A-X)
 |  | ENCANA (ECA-T)
[NAME] 21 | Focus: global equities. Top Pick: Sodexo: SW-FP French Exchange | [NAME]:
portfolio manager, |  | SOQUIMICH (SQM-N)
Dynamic Funds |  | FOSTER WHEELER (FWLT-Q)
[NAME] 18 | Focus: technical analysis | [NAME]:
Contributor, |  | ALAMOS GOLD (AGI-T)
na-marketletter.com |  | GERDAU AMERISTEEL (GNA-T)
 |  | CORRIENTE RESOURCES (CTQ-T)
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 8d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 8626 | 2660 | 17164 | 3042
OTHER* | 91 | 2396 | 47 | 1632
TOTAL
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, FRA,  Inflation, OIS, and Swaption.
Spreadsheet: 594780d1539964589-auto-complete-predictive-fill-a-worksheets-cells-across-different-worksheets-different-worksheets-same-workbook-example-copy
Sheet: First Worksheet

 |  | Data
DATE | SUBJECT | CASE NUMBER | REQUESTOR | OPERATOR/USER | Type of Request/Investigation | COMMENTS
2018-10-02 00:00:00 | [NAME] | 983-01-2 | Smith | Smith | example
2018-10-02 00:00:00 | [NAME] | 983-02-0 | Smith | Smith | example
2018-10-19 00:00:00 | [NAME] | TBD | Smith | Smith | example
2018-10-19 00:00:00 | [NAME] | TBD | Smith | Smith | example
Spreadsheet: 0fa806f2-e3d0-4f58-8ce3-e6cf40c8ac72
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 11G. Average Weekly Earnings, Northern Territory (Dollars) - Trend
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Earnings; [NAME]; Full Time; Adult; Ordinary time earnings ;  Northern Territory ; |  |  | Trend | A2811121X | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Full Time; Adult; Total earnings ;  Northern Territory ; |  |  | Trend | A2811124F | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Total earnings ;  Northern Territory ; |  |  | Trend | A2811130A | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Ordinary time earnings ;  Northern Territory ; |  |  | Trend | A2811122A | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Total earnings ;  Northern Territory ; |  |  | Trend | A2811125J | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Total earnings ;  Northern Territory ; |  |  | Trend | A2811131C | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Northern Territory ; |  |  | Trend | A2811123C | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Northern Territory ; |  |  | Trend | A2811126K | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Northern Territory ; |  |  | Trend | A2811132F | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2013
Spreadsheet: 682155d1591930163-help-investment-tracker-with-foreign-currency-excel-spreadsheet-portfolio
Sheet: PORTFOLIO

Portfolio | Invested | Capital Gain/Loss | Currency Gain/Loss | Dividends | Total AUD | Profit/Loss
CORE
CYCLICAL
OPPORTUNISTIC
RISK MANAGEMENT
Inflows/Outflows
Overall Portfolio
Type | Current | Target | Difference |  | Asset Allocation | Current | Target | Difference
EQUITIES |  | 0.5 |  |  | Energy
BONDS |  | 0.15 |  |  | Materials
ALTERNATIVES |  | 0.1 |  |  | Consumer Discretionary
CASH AUD |  | 0.15 |  |  | Consumer Staples
CASH USD |  | 0.1 |  |  | Health Care
 |  |  |  |  | Financials
 |  |  |  |  | Information Technology
Portfolio | Current | Target | Difference |  | Telecommunication Services
CORE |  | 0.38 |  |  | Utilities
CYCLICAL |  | 0.07 |  |  | Real Estate
OPPORTUNISTIC |  | 0.05 |  |  | Industrials
RISK MANAGEMENT |  | 0.5 |  |  | Managed Funds
Country- Equities | Current | Target | Difference |  | Portfolio | Score
Australia |  |  |  |  | [NAME]
United States America |  |  |  |  | Tracking Error
United Kingdom |  |  |  |  | Annualised Tracking Error
Europe |  |  |  |  | [NAME].
Hong Kong |  |  |  |  | Information Ratio
 |  |  |  |  | Annualised Information Ratio
 |  |  |  |  | Risk Free rate | 0.69 | Updated 8 June 2020
 |  |  |  |  | Average Returns
 |  |  |  |  | Standard Deviation
 |  |  |  |  | Beta
 |  |  |  |  | GEOMETRIC RETURN?