tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 791933d1660662829-change-many-column-in-one-row-i-have-to-use-something-else-than-transpose-tablenew
Sheet: Sheet1

Day | Time | 01-05-2022 | 02-05-2022 |  |  |  | Day | Time | Staff
 | Time 1 | 0 | 0 |  |  |  |  |  |  | Day 1, 1st of May
 | Time 2 | 0 | 0 |  |  |  | 01-05-2022 | Time 2 | 0
 | Time 3 | 0 | 0 |  |  |  | 01-05-2022 | Time 3 | 0
 | Time 4 | 0 | 0 |  |  |  | 01-05-2022 | Time 4 | 0
 | Time 5 | 0 | 0 |  |  |  | 01-05-2022 | Time 5 | 0
 | Time 6 | 3 | 6 |  |  |  | 01-05-2022 | Time 6 | 3
 | Time 7 | 5 | 11 |  |  |  | 01-05-2022 | Time 7 | 5
 | Time 8 | 2 | 17 |  |  |  | 01-05-2022 | Time 8 | 2
 | Time 9 | 2 | 2 |  |  |  | 01-05-2022 | Time 9 | 2
 | Time 10 | 0 | 3 |  |  |  | 01-05-2022 | Time 10 | 0
 | Time 11 | 2 | 0 |  |  |  | 01-05-2022 | Time 11 | 2
 | Time 12 | 0 | 0 |  |  |  | 01-05-2022 | Time 12 | 0
 | Time 13 | 0 | 1 |  |  |  | 01-05-2022 | Time 13 | 0
 | Time 14 | 3 | 2 |  |  |  | 01-05-2022 | Time 14 | 3
 | Time 15 | 2 | 3 |  |  |  | 01-05-2022 | Time 15 | 2
 | Time 16 | 2 | 2 |  |  |  | 01-05-2022 | Time 16 | 2
 | Time 17 | 2 | 0 |  |  |  | 01-05-2022 | Time 17 | 2
 | Time 18 | 0 | 0 |  |  |  | 01-05-2022 | Time 18 | 0
 | Time 19 | 0 | 0 |  |  |  | 01-05-2022 | Time 19 | 0
 | Time 20 | 6 | 0 |  |  |  | 01-05-2022 | Time 20 | 6
 | Time 21 | 0 | 0 |  |  |  | 01-05-2022 | Time 21 | 0
 | Time 22 | 3 | 3 |  |  |  | 01-05-2022 | Time 22 | 3
 | Time 23 | 0 | 0 |  |  |  | 01-05-2022 | Time 23 | 0
 | Time 24 | 2 | 7 |  |  |  | 01-05-2022 | Time 24 | 2
 |  |  |  |  |  |  | 02-05-2022 | Time 1 | 0 | Day 2, 2nd of May
 |  |  |  |  |  |  | 02-05-2022 | Time 2 | 0
I have this tabe, day 1 in column C, day 2 in column D etc., coloured blue |  |  |  |  |  |  | 02-05-2022 | Time 3 | 0
I want to change it like yellow column and rows. |  |  |  |  |  |  | 02-05-2022 | Time 4 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 5 | 0
My task is change blue table to the yellow one. |  |  |  |  |  |  | 02-05-2022 | Time 6 | 6
 |  |  |  |  |  |  | 02-05-2022 | Time 7 | 11
My table has many days |  |  |  |  |  |  | 02-05-2022 | Time 8 | 17
 |  |  |  |  |  |  | 02-05-2022 | Time 9 | 2
 |  |  |  |  |  |  | 02-05-2022 | Time 10 | 3
 |  |  |  |  |  |  | 02-05-2022 | Time 11 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 12 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 13 | 1
 |  |  |  |  |  |  | 02-05-2022 | Time 14 | 2
 |  |  |  |  |  |  | 02-05-2022 | Time 15 | 3
 |  |  |  |  |  |  | 02-05-2022 | Time 16 | 2
 |  |  |  |  |  |  | 02-05-2022 | Time 17 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 18 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 19 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 20 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 21 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 22 | 3
 |  |  |  |  |  |  | 02-05-2022 | Time 23 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 24 | 7
Spreadsheet: 752235d1634659752-vlookup-stops-working-after-several-rows-po-workbook
Sheet: ODP LISTING

REV | PO# | VENDOR | PO AMOUNT | INVOICED AMT | NONTAXABLE | TAX SAVINGS | SUBTOTAL | PO BALANCE | SUBCONTRACTOR
1 | 3413 | Ceco Building Systems | 442121.6
 | 3506 | Oldcastle | 13647
 | 3507 | Slone Doors | 29055
 | 3547 | Overhead Door Company | 74873
 | 3531 | Bell Steel | 2600
 | 3532 | Foley Products | 17109.41
 |  | PROJECT TOTALS
 |  |  |  |  |  | ODP to Date
 |  |  |  |  |  | ODP CO #1 | -1316884.4 |  | Need too update formula(s)
 |  |  |  |  |  | ODP CO #2 | -10725.1
 |  |  |  |  |  | ODP CO #3 | -986.52
 |  |  |  |  |  | ODP CO #4 | -10972.06
 |  |  |  |  |  | CO Due
Spreadsheet: kate_symes__18362__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-23 00:00:00 |  | 264.42 | 12000 | 218.16 | 5120
 | 2001-04-22 00:00:00 |  | 237.5 | 1600 | 200 | 0 | 322.48 | 802 | 225.3 | 410 |  | 214.01 | 14736
 | 2001-04-21 00:00:00 |  | 231.51 | 18784 | 177.42 | 4648 | 216.3 | 1109 | 224.25 | 335
 | 2001-04-20 00:00:00 |  | 231.51 | 18784 | 177.42 | 4648 | 282.59 | 29 | 175 | 0
 | 2001-04-19 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832 | 261.94 | 766 | 218.69 | 1280
 | 2001-04-18 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832 | 311.3 | 1840 | 232.11 | 1075
 | 2001-04-17 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832 | 337.92 | 120 | 157.38 | 965
 | 2001-04-16 00:00:00 |  | 379.99 | 21296 | 356.66 | 8480 | 359.26 | 135 | 202.5 | 100
 | 2001-04-15 00:00:00 |  | 368.33 | 1200 | 350 | 0 | 400 | 50 | 325 | 25 |  | 357.42 | 27864
 | 2001-04-14 00:00:00 |  | 369.89 | 22096 | 344.35 | 6848 | 365.25 | 505 | 346 | 0
 | 2001-04-13 00:00:00 |  | 369.89 | 22096 | 343.87 | 6048 | 392.86 | 420 | 421.33 | 60
 | 2001-04-12 00:00:00 |  | 411.66 | 16160 | 376.19 | 5352 | 431.44 | 1740 | 339.62 | 419
 | 2001-04-11 00:00:00 |  | 386.02 | 10560 | 337.56 | 7552 | 391.16 | 540 | 372.42 | 291
 | 2001-04-10 00:00:00 |  | 379.15 | 19760 | 331.04 | 9192 | 398 | 621 | 337.4 | 615
 | 2001-04-09 00:00:00 |  | 311.43 | 19600 | 264.75 | 6584 | 334.15 | 437 | 337.5 | 100
 | 2001-04-08 00:00:00 |  | 273.75 | 1600 | 255 | 0 | 349.76 | 1330 | 342.22 | 135 |  | 264.68 | 20136
 | 2001-04-07 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 293.05 | 1559 | 279.89 | 435
 | 2001-04-06 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 290.88 | 400 | 227.31 | 325
 | 2001-04-05 00:00:00 |  | 348.81 | 22560 | 266.94 | 2480 | 259.38 | 200 | 158.94 | 610
 | 2001-04-04 00:00:00 |  | 314.36 | 18160 | 238.83 | 8040 | 307.45 | 455 | 246.52 | 460
 | 2001-04-03 00:00:00 |  | 305.4 | 18160 | 224.33 | 7200 | 300.45 | 350 | 288.25 | 1310
 | 2001-04-02 00:00:00 |  | 284.36 | 24400 | 227.63 | 9504 | 294.16 | 942 | 216.95 | 351
 | 2001-04-01 00:00:00 |  | 236.99 | 2336 | 225 | 0 | 243.67 | 158 | 219.78 | 273 |  | 229.73 | 26352
 | 2001-03-31 00:00:00 |  | 179.66 | 24400 | 125.17 | 9640 | 220.77 | 698 | 100 | 4
 | 2001-03-30 00:00:00 |  | 179.99 | 23600 | 125.18 | 9040 | 203.23 | 798 | 173.41 | 504
 | 2001-03-29 00:00:00 |  | 187.27 | 26400 | 130.98 | 10880 | 181.96 | 553 | 151.95 | 154
 | 2001-03-28 00:00:00 |  | 161.91 | 27600 | 100.36 | 9480 | 170.67 | 208 | 110.85 | 544
 | 2001-03-27 00:00:00 |  | 155.95 | 22800 | 89.58 | 6200 | 152.08 | 1038 | 121.24 | 169
 | 2001-03-26 00:00:00 |  | 334.36 | 15600 | 230.55 | 6600 | 102.59 | 243 | 60.96 | 287
 | 2001-03-25 00:00:00 |  | 260 | 0 | 230 | 0 | 70 | 200 | 41.32 | 456 |  | 229.94 | 19200
 | 2001-03-24 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 113.77 | 1687 | 139.44 | 832
 |  |  |  |  |  | ..
Spreadsheet: 267984d1380331196-need-to-pull-data-from-multiple-columns-only-if-value-in-column-a-solved
Sheet: Sheet1

GL | Description |  |  |  |  |  |  |  | total
12 | info1 | unused | unused | unused | unused | unused | unused | unused | 5
15 | info2 | unused | unused | unused | unused | unused | unused | unused | 1
 | [NAME] | unused | unused | unused | unused | unused | unused | unused | 58
13 | [NAME] | unused | unused | unused | unused | unused | unused | unused | 65
15 | info5 | unused | unused | unused | unused | unused | unused | unused | 12
16 | info6 | unused | unused | unused | unused | unused | unused | unused | 32
 | [NAME] | unused | unused | unused | unused | unused | unused | unused | 456
 | info8 | unused | unused | unused | unused | unused | unused | unused | 54
15 | info9 | unused | unused | unused | unused | unused | unused | unused | 321
12 | info10 | unused | unused | unused | unused | unused | unused | unused | 321
Spreadsheet: 688655d1595892135-referencing-a-closed-workbook-collate-numbers
Sheet: Sheet1

Name | Scores |  |  | Total
[NAME] | 57 |  | [NAME]
[NAME] | 57 |  | [NAME]
[NAME] | 86 |  | [NAME]
[NAME] | 45
[NAME] | 63
[NAME] | 74
[NAME] | 37
[NAME] | 23
[NAME] | 67
[NAME] | 23
[NAME] | 24
[NAME] | 89
[NAME] | 90
Spreadsheet: 732671d1621142774-pull-from-row-from-one-sheet-to-another-array-formula-test
Sheet: Sheet Info

 | [NAME] |  | Task to be Completed |  |  | Loan Officier Assistant |  | Status
 |  |  | Dup | Dupe a File |  |  |  | Complete
 |  |  | P&P | Pipe & Polish |  |  |  | Working
 |  |  | 911 | Urgent |  |  |  | Sent Back to L/O
 |  |  | [NAME] | Appraisal |  |  |  | On Hold
 |  |  | 4506T
 |  |  | WVOE
 |  |  | ICW
 |  |  | Stips
 |  |  | PO | Pay Off
 |  |  | PR | Pipe Review
 |  |  | Cond | Condition(s)
 |  |  | O/M | Other/Misc.
 |  |  | Discos
 |  |  | EOI | Evidence of insurance
 |  |  | CS | Credit Supp (VOM)
 |  |  | LOE | Letter of Explanation
 |  |  | Polish
Spreadsheet: 98863d1297701625-excel-2007-format-data-series-marker-option-toandy
Sheet: Data1

1959.011 | 2049.062 | 2125.776 | 2219.457 | 2314.337 | 2387.137 | 2430.114 | 2496.739 | 2552.886 | 2556.949 | 2542.939 | 2520.726 | 2491.043 | 2377.792 | 2209.306 | 2079.89 | 1904.236 | 1793.183 | 1883.863 | 2037.478
1057 | 1121.35 | 1176.17 | 1243.12 | 1310.92 | 1362.94 | 1393.65 | 1441.26 | 1481.39 | 1484.29 | 1474.28 | 1458.4 | 1437.19 | 1356.26 | 1235.86 | 1143.38 | 1017.86 | 938.5 | 1003.3 | 1113.07
Spreadsheet: 157500d1337768634-productivity-calculation-example
Sheet: Section

 | A | B | C | D | E | F | G | H | i | j | Totals
08:00:00
08:15:00
08:30:00
08:45:00
09:00:00
09:15:00
09:30:00
09:45:00
10:00:00
10:15:00
10:30:00
10:45:00
11:00:00
11:15:00
11:30:00
11:45:00
12:00:00
12:15:00
12:30:00
12:45:00
13:00:00
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
Spreadsheet: 555107d1515439415-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 1

 |  |  |  |  |  | Tournament
 |  |  | Player | Score |  | Opponent | Score | Sub Total | Winner | Points | [NAME] Up | Points
 |  |  | [NAME] | 28 |  | [NAME] | 37 |  |  | 2 |  | 1
 |  |  | Anne Other | 60 |  | Ima Belle | 32 |  |  | 2 |  | 1
 |  |  | [NAME] | 55 |  | Ima Dunce | 44 |  |  | 2 |  | 1
 |  |  | [NAME] | 61 |  | [NAME] | 35 |  |  | 2 |  | 1
 |  |  | [NAME] | 44 |  | [NAME] | 38 |  |  | 2 |  | 1
 |  |  | Brandy D. Cantor | 37 |  | [NAME] | 42 |  |  | 2 |  | 1
 |  |  | Brighton Early | 56 |  | [NAME] | 61 |  |  | 2 |  | 1
 |  |  | [NAME] | 33 |  | [NAME] | 45 |  |  | 2 |  | 1
 |  |  | [NAME] | 35 |  | [NAME] | 51 |  |  | 2 |  | 1
 |  |  | [NAME] | 31 |  | [NAME] | 34 |  |  | 2 |  | 1
 |  |  | [NAME] | 32 |  | [NAME] | 48 |  |  | 2 |  | 1
 |  |  | [NAME] | 33 |  | [NAME] | 34 |  |  | 2 |  | 1
 |  |  | [NAME] | 39 |  | [NAME] | 45 |  |  | 2 |  | 1
 |  |  | Edna May | 56 |  | [NAME] | 34 |  |  | 2 |  | 1
 |  |  | [NAME] | 49 |  | [NAME] | 32 |  |  | 2 |  | 1
 |  |  | [NAME] | 62 |  | P, [NAME] | 37 |  |  | 2 |  | 1
 |  |  | [NAME] | 48 |  | [NAME] | 36 |  |  | 2 |  | 1
 |  |  | [NAME] | 63 |  | [NAME] | 37 |  |  | 2 |  | 1
 |  |  | Hazle Nutt | 54 |  | [NAME] | 40 |  |  | 2 |  | 1
 |  |  | [NAME] | 40 |  | Raynor Schein | 41 |  |  | 2 |  | 1
 |  |  | [NAME] | 63 |  | [NAME] | 32 |  |  | 2 |  | 1
 |  |  | Hugh Jass | 56 |  | [NAME] Still | 42 |  |  | 2 |  | 1
 |  |  | Hy Price | 63 |  | [NAME] | 35 |  |  | 2 |  | 1
 |  |  | [NAME] | 61 |  | [NAME] | 32 |  |  | 2 |  | 1
 |  |  | I.D. Clair | 34 |  | [NAME] | 61 |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 1
 |  | x | x | x |  | x | x | x | x | x | x | x
 |  |  |  |  |  |  |  |  | Round Score | Points (A) | Points (B) | Round Points
 |  |  | x | x | x | x | x | x | x | x | x | x
Spreadsheet: 115637d1311186126-query-functions-selection-worksheet-dummy-2
Sheet:  select

 | parts needed to assemble
 | Pieces | range [NAME] | range Zoll | Genau | part style | variation | used | item number | Price (euro) | Min. Total
 | size | 18,00 - 19,99 | inch equivelant |  |  |  | 1
 | part a |  |  |  | a | 2333.4da | 2 | 102330 | 15
 | part a-1 |  |  |  | a-1 | 7745.4da | 0 | 102654 | 20
 | part a-2 |  |  |  | part a sub 1 | 0027.4da | 0 | 109234 | 15
 | part a sub 1 |  |  |  |  |  | 1
 | part a accessory b |  |  |  |  |  | 1
Spreadsheet: 761386d1640869185-find-adjacent-value-based-on-partial-string-match-excel-example-sheet
Sheet: Hex pull formula (2)

 |  |  |  | Cell reference | 89
 |  |  |  | Animal | dog
No. | Breed | Colour
1 | [NAME] | Brown dog |  |  | Search |  |  | Colour | Breed | No.
2 | Labrador | Black dog |  |  |  |  | 1
3 | Golden Retriever | Golden dog |  |  |  |  | 2
4 | Huskey | White dog |  |  | Count |  | 3
5 | Persian | White Cat |  |  | 100 |  | 4
6 | Siamese | Black Cat
84
85
86
87
88
89
90
91
92
93
Spreadsheet: michelle_lokay__26569__imbalsumm0012
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 8697 | 6399 | 114 | 179 | 1543 | 1323 | 322 | 298
2 | 8008 | 6399 | 120 | 179 | 1630 | 1323 | 176 | 298
3 | 7274 | 6399 | 177 | 179 | 1555 | 1323 | 41 | 298
4 | 6935 | 6399 | 213 | 179 | 1427 | 1323 | 0 | 298
5 | 6927 | 6399 | 188 | 179 | 1521 | 1323 | 5 | 298
6 | 2953 | 6399 | 167 | 179 | 1484 | 1323 | 318 | 298
7 | 6098 | 6399 | 170 | 179 | 442 | 1323 | 408 | 298
8 | 8005 | 6399 | 97 | 179 | 276 | 1323 | 308 | 298
9 | 7359 | 6878 | 112 | 179 | 346 | 1323 | 242 | 298
10 | 6248 | 6857 | 192 | 179 | 604 | 1323 | 201 | 298
11 | 6822 | 6848 | 90 | 179 | 1135 | 1323 | 82 | 298
12 | 3692 | 6899 | 16 | 179 | 1161 | 1406 | 143 | 298
13 | 6044 | 6872 | 99 | 179 | 759 | 1323 | 144 | 298
14 | 7706 | 6899 | 157 | 179 | 653 | 1423 | 38 | 298
15 | 6236 | 6899 | 131 | 179 | 1179 | 1323 | 92 | 298
16 | 6459 | 6899 | 187 | 179 | 890 | 1423 |  | 298
17 | 6567 | 6899 | 202 | 179 | 1063 | 1423 |  | 298
18 | 6214 | 6899 | 162 | 179 | 1759 | 1423 | 1038 | 298
19 | 6380 | 6899 | 137 | 179 | 1806 | 1423 | 917 | 298
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  |  |  |  |  | 509472.93
2000-12-19 00:00:00
Spreadsheet: 42083d1240614592-checking-against-a-list-forumexample
Sheet: Postcodes

Postcode
BB1 0AA
BB1 1AA
BB1 2AA
BB1 3AA
BB1 4AA
BB1 5AA
BB1 6AA
BB1 7AA
BB1 8AA
BB1 9AA
BB10 0AA
BB10 1AA
BB10 2AA
BB10 3AA
BB10 4AA
BB10 5AA
BB10 6AA
BB10 7AA
BB10 8AA
BB10 9AA
BB11 0AA
BB11 1AA
BB11 2AA
BB11 3AA
BB11 4AA
BB11 5AA
BB11 6AA
BB11 7AA
BB11 8AA
BB11 9AA
BB12 0AA
BB12 1AA
BB12 2AA
BB12 3AA
BB12 4AA
BB12 5AA
BB12 6AA
BB12 7AA
BB12 8AA
BB12 9AA
BB18 0AA
BB18 1AA
BB18 2AA
BB18 3AA
BB18 4AA
BB18 5AA
BB18 6AA
BB18 7AA
BB18 8AA
BB18 9AA
BB2 0AA
BB2 1AA
BB2 2AA
Spreadsheet: 537401d1505050633-forumal-assistance-2017-to-2018-emails-one-on-one
Sheet: Live Chat Performance Tracking

Performance Discussion
Employee Name:
Employee Number:
Team Leader Name:
Topic of discussion:
Date of Discussion:
Performance Area | Target | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Quality | 0.9 | 0.89
PKA | 0.9
Average Response Time | 1 | 0.3
Repeat Calls | 0.9
FCR | 0.9
Compliance | 0.9
Key Performance Target Ratings
Performance Area |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Quality
PKA
Average Response Time
Repeat Calls
FCR
Compliance
Compliance assessments
Leave management
Compliance
Areas of Strength |  | Comments
Quality
PKA
TAT
VOC
Productivity
Areas of Development
Team Leader Comments:
Agent Comments:
Spreadsheet: vkaminski__40672__RPI-model-3-22
Sheet: Curve frm Quoted SWAP rates

 | SWAP Fixed Rate | RPI Curve frm Q'd rates | 2-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 3-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 4-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 5-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 6-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 7-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 8-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 9-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 10-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 11-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 12-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 13-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 14-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 15-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 16-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 17-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 18-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 19-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum |  | 20-yr | Coupon | [NAME] | DF | Coupon x DF | Sum | Floating/Spot | Coupon | Coupon x DF | Sum
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018 |  |  |  |  |  |  |  |  |  |  | 0.018 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018 |  |  |  |  |  |  |  |  |  |  | 0.018 |  |  |  |  |  |  |  |  |  |  | 0.018 |  |  |  |  |  |  |  |  |  |  | 0.018 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.018 |  |  |  |  |  |  |  |  |  |  | 0.018 |  |  |  |  |  |  |  |  |  |  | 0.018 |  |  |  |  |  |  |  |  |  |  | 0.018
Spreadsheet: 2c322381-d15c-4e7c-a7b3-ac7596a9e761
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
 | 5609.0 Housing Finance, Australia
 | TABLE 9a. HOUSING FINANCE COMMITMENTS (Owner Occupation), By Type of Buyer and Loan: Australia, Original
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
First home buyers - Dwellings financed (no.) ; |  |  | Original | A2412824W | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | Number | FLOW | Month | 1
First home buyers - % of all dwellings financed ; |  |  | Original | A2412836F | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | Percent | DERIVED | Month | 1
First home buyers - Average loan size ($000) ; |  |  | Original | A2412825X | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | $'000 | DERIVED | Month | 1
Non-first home buyers - Dwellings financed (no.) ; |  |  | Original | A2412827C | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | Number | FLOW | Month | 1
Non-first home buyers - % of all dwellings financed ; |  |  | Original | A2416246C | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | Percent | DERIVED | Month | 1
Non-first home buyers - Average loan size ($000) ; |  |  | Original | A2412826A | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | $'000 | DERIVED | Month | 1
Fixed rate - Dwellings financed (no.) ; |  |  | Original | A2412828F | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | Number | FLOW | Month | 1
Fixed loans - % of all dwellings financed ; |  |  | Original | A2412837J | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | Percent | DERIVED | Month | 1
Fixed rate - Average loan size ($000) ; |  |  | Original | A2412829J | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | $'000 | DERIVED | Month | 1
Secured revolving loans - Dwellings financed (no.) ; |  |  | Original | A2412830T | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | Number | FLOW | Month | 1
Secured revolving loans - % of all dwellings financed ; |  |  | Original | A2412838K | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | Percent | DERIVED | Month | 1
Secured revolving loans - Average loan size ($000) ; |  |  | Original | A2412831V | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | $'000 | DERIVED | Month | 1
Other loans -  Dwellings financed (no.) ; |  |  | Original | A2412832W | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | Number | FLOW | Month | 1
Other loans - % of all dwellings financed ; |  |  | Original | A2412839L | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | Percent | DERIVED | Month | 1
Other loans - Average loan size ($000) ; |  |  | Original | A2412833X | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | $'000 | DERIVED | Month | 1
ALL FINANCE - Average loan size ($000) ; |  |  | Original | A2412834A | 1975-10-01 00:00:00 | 2011-07-01 00:00:00 | 430 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 271833d1382076924-conditional-formating-turn-color-based-on-another-cell-value-test-emp-details
Sheet: After Sheet

Name | Employer | Years of experience | Rule
[NAME] | ABC corp | 0
[NAME] | AT&T mobile | 4
[NAME] | T-Mobile |  | Since employed, should enter any number (minimum 0), else highlight Red
Mini |  |  | Not employed, so no need to highlight
[NAME] | Verizion |  | Since employed, should enter any number (minimum 0), else highlight Red
[NAME] | Verizion |  | Since employed, should enter any number (minimum 0), else highlight Red
[NAME] | T-Mobile | 5
Spreadsheet: 88208d1288104762-grab-from-one-table-and-insert-into-another-minus-empty-fields-sorting-data-automatically
Sheet: Sheet1

 | Crew | Msn Number | Key
Location A
Location A | Doe, [NAME] | 123
Location A
Location A
Location A
Location A
Location B
Location B
Location B | [NAME], [NAME] | 456
Location B |  |  |  |  | Key | Crew | Msn Number
Location B |  |  |  |  | 1 |  |  | <--Auto populate from B2:C25
Location B |  |  |  |  | 2
Location C |  |  |  |  | 3
Location C |  |  |  |  | 4
Location C | Jones, [NAME] | 789 |  |  | 5
Location C |  |  |  |  | 6
Location C |  |  |  |  | 7
Location C |  |  |  |  | 8
Location D |  |  |  |  | 9
Location D |  |  |  |  | 10
Location D |  |  |  |  | 11
Location D |  |  |  |  | 12
Location D |  |  |  |  | 13
Location D |  |  |  |  | 14