tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167514d1342015595-nest-vlookup-help-nest-lookup-2
Sheet: Sheet1

EEID | Rate | Effective Date
1 | 10 | 2011-01-01 00:00:00
1 | 11 | 2012-02-05 00:00:00
2 | 12 | 2012-04-01 00:00:00
3 | 15 | 2012-01-01 00:00:00
3 | 16.5 | 2012-05-01 00:00:00
 | EEID | check Date | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-30 00:00:00
 | 1 | Regular | 10 | 11 | 11 | 11 | 11
 | 1 | OT | 10 | 11 | 11 | 11 | 11
 | 2 | Regular | 12 | 12 | 12 | 12 | 12 | It should first look at the exact EEID, then it should look at the check date in yellow and pull back the results in green
 | 2 | OT | 12 | 12 | 12 | 12 | 12
 | 3 | Regular | 15 | 15 | 15 | 15 | 16.5
 | 3 | OT | 15 | 15 | 15 | 15 | 16.5
Spreadsheet: 862724d1710365345-need-help-totaling-based-on-selections-mix-id-calculator-bdh-dj_addtier
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This section is where I manipulate the lists and price.  Can be done on another tab.
This section is where the results are displayed. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1420774-need-help-totaling-based-on-selections.html#post5929782
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tier | Price |  | Mix ID | Price |  | Add On | Price |  | Distance | Price
Tier | Mix ID | Add On |  |  |  |  |  |  |  |  |  | Distance | Total |  | T1 | 121 |  | COM301510 | 0 |  | Air | 3 |  | 1-10 | 0
 |  | Air | HRWR | 3/8 Agg | [NAME] | 1%Retard | 2%Retard | 3%Retard | Fiber | SRA | SS |  |  |  | T2 | 126 |  | COM351510 | 5 |  | HRWR | 5 |  | 11-20 | 5
T1, T2, T3 dropdown | COM301510 | False | False | False |  |  | False |  | False | False | False | 1-10 |  |  | T3 | 131 |  | COM401510 | 10 |  | 3/8 Agg | 7 |  | 21-30 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COM451510 | 15 |  | [NAME] | 13 |  | 31-40 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COM501510 | 20 |  | 1%Retard | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COM601510 | 30 |  | 2%Retard | 1
So if I select T1 from this dropdown, $121 will appear in A7.  T2 would populate with $126 and T3 would populate with $131. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COM701510 | 40 |  | 3%Retard | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COM801510 | 50 |  | Fiber | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500S | 7 |  | SRA | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 550S | 12 |  | SS | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 600S | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 650S | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700S | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 800S | 32
Spreadsheet: 718309d1613078516-index-and-array-excel
Sheet: Sheet1

 | Staff | Resident | Ratio | learner 1 | learner 2 | learner 3 | learner 4 | learner 5 | learner 6 | learner 7 | learner 8 | learner 9 | learner 10 | learner 11 | learner 12 | learner 13 | learner 14 | learner 15 | learner 16 | learner 17 | learner 18 | learner 19 | learner 20 | learner 21 | learner 22 | learner 23 | learner 24 | learner 25 | learner 26 | learner 27 | learner 28 | learner 29 | learner 30 | learner 31 | learner 32 | learner 33 | learner 34 | learner 35 | learner 36 | learner 37 | learner 38 | learner 39 | learner 40 | learner 41 | learner 42
2021-07-01 00:00:00 | 5 | 20 | 1:4  (0) | x | x | x |  |  |  | x | x | x |  |  |  |  |  |  |  |  |  | x | x | x | x |  |  |  |  |  |  |  |  | x | x | x | x | x |  | x | x |  | x | x | x
2021-07-02 00:00:00 | 6 | 0 | 1:0  (0) |  |  | x |  |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x |  |  | x | x | x | x |  |  | x | x | x |  | x | x |  |  |  | x | x | x |  |  | x
2021-07-03 00:00:00 | 0 | 0
2021-07-04 00:00:00 | 0 | 0
2021-07-05 00:00:00 | 6 | 0 | 1:0  (0) |  |  | x |  |  |  | x |  |  |  | x | x | x | x | x | x | x | x | x |  |  | x | x |  |  |  |  | x | x | x |  | x | x |  |  |  |  |  |  |  |  | x
2021-07-06 00:00:00 | 7 | 0 | 1:0  (0) |  |  |  | x | x | x |  |  |  |  |  |  | x |  |  | x |  |  |  |  |  |  | x |  |  | x | x | x | x | x |  |  |  |  |  | x | x | x
2021-07-07 00:00:00 | 0 | 0
2021-07-08 00:00:00 | 5 | 0 | 1:0  (0) | x | x | x |  |  |  | x | x | x |  |  |  |  |  |  |  |  |  | x | x | x | x |  |  |  |  |  |  |  |  | x | x | x | x | x |  | x | x |  | x | x | x
WHAT I WANT
Date: | July 1 2021
 |  | learner1
 |  | learner2
 |  | [NAME]
 |  | learner7
 |  | learner8
 |  | learner9
 |  | learner19
 |  | learner20
 |  | [NAME]
 |  | learner22
 |  | learner31
 |  | learner32
 |  | learner33
 |  | learner34
 |  | learner35
 |  | learner37
 |  | learner38
 |  | learner40
 |  | learner41
 |  | [NAME]
Spreadsheet: 456462d1460882039-calculations-using-a-matrix-correlations-use-tables_2
Sheet: Corr_OUT

 | 111CA | 113FF | 211 | 212 | 213 | 22 | 23 | 321 | 327 | 331 | 332 | 333 | 334 | 335 | 3361MV | 3364OT | 337 | 339 | 311FT | 313TT | 315AL | 322 | 323 | 324 | 325 | 326 | 42 | 441 | 445 | 452 | 4A0 | 481 | 482 | 483 | 484 | 485 | 486 | 487OS | 493 | 511 | 512 | 513 | 514 | 521CI | 523 | 524 | 525 | HS | ORE | 532RL | 5411 | 5415 | 5412OP | 55 | 561 | 562 | 61 | 621 | 622 | 623 | 624 | 711AS | 713 | 721 | 722 | 81 | GFGD | GFGN | GFE | GSLG | GSLE
111CA
113FF
211
212
213
22
23
321
327
331
332
333
334
335
3361MV
3364OT
337
339
311FT
313TT
315AL
322
323
324
325
326
42
441
445
452
4A0
481
482
483
484
485
486
487OS
493
511
512
513
514
521CI
523
524
525
HS
ORE
532RL
5411
5415
5412OP
55
561
562
61
621
622
623
624
711AS
713
721
722
81
GFGD
GFGN
GFE
GSLG
GSLE
Used
Other
V001
V002
V003
Spreadsheet: 171424d1343728475-how-to-link-4-list-boxes-listingout
Sheet: Sorting

 |  |  |  |  |  |  |  |  |  |  |  |  | Party | Product | Month | Year
Party | India |  |  |  |  |  |  |  |  |  |  |  | India | AM | Jan | 11
 |  |  |  |  |  |  |  |  |  |  |  |  | Srilanka | BO | Feb | 12
Product | AM |  |  |  |  |  |  |  |  |  |  |  | England |  | Mar | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
Year | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
Month | Aug |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
Inv Date | Weight |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
2012-08-02 00:00:00 | 6256 |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
2012-08-20 00:00:00 | 16910 |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
2012-08-23 00:00:00 | 17030 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
Spreadsheet: 799293d1665033981-find-duplicate-value-in-cell-b-if-cell-a-does-not-match-book1
Sheet: Sheet1

2022-10-01 00:00:00 | a |  |  |  |  |  |  |  | e
2022-10-01 00:00:00 | b |  |  |  | g |  |  | 2022-10-02 00:00:00 | e
2022-10-01 00:00:00 | c |  |  |  |  |  |  | 2022-10-01 00:00:00 | g
2022-10-01 00:00:00 | d |  |  |  |  |  |  | 2022-10-02 00:00:00 | g
2022-10-01 00:00:00 | e
2022-10-02 00:00:00 | e
2022-10-02 00:00:00 | e
2022-10-01 00:00:00 | k
2022-10-01 00:00:00 | f
2022-10-01 00:00:00 | g
2022-10-02 00:00:00 | g
2022-10-01 00:00:00 | j
2022-10-01 00:00:00 | j
Spreadsheet: 188098d1350675883-comparing-two-documents-in-one-excel-please-help
Sheet: Sheet3

This is another that will be paisted  to give info for sheet 1
 |  | Part Name |  |  |  |  |  |  |  |  | QTY
 |  | P1 |  |  |  |  |  |  |  |  | 9
 |  | P2 |  |  |  |  |  |  |  |  | 3
 |  | uneeded space usually filled with other information
 |  | P3 |  |  |  |  |  |  |  |  | 2
 |  | uneeded space usually filled with other information
 |  | uneeded space usually filled with other information
 |  | uneeded space usually filled with other information
 |  | P5 |  |  |  |  |  |  |  |  | 5
 |  | uneeded space usually filled with other information
 |  | uneeded space usually filled with other information
 |  | uneeded space usually filled with other information
 |  | uneeded space usually filled with other information
 |  | uneeded space usually filled with other information
 |  | P1 |  |  |  |  |  |  |  |  | 10
 |  | uneeded space usually filled with other information
 |  | uneeded space usually filled with other information
 |  | uneeded space usually filled with other information
 |  | uneeded space usually filled with other information
 |  | P4 |  |  |  |  |  |  |  |  | 15
Spreadsheet: 737547d1624462420-need-some-help-with-counting-words-excel-issue
Sheet: Location 3

Honorific | Last Name | First Name | Middle Name | Certification | Affiliate | Secondary Affiliate | Tertiary Affiliate | PIBC [NAME] Categories | District | Membership Category | Membership Status
Mr.
Ms.
Ms.
Miss
Mr.
Mrs.
Mrs.
Mr.
Mrs.
Mr.
Mr.
Mr.
Mr.
Dr.
Ms.
Mr.
Miss
Spreadsheet: 058c6734-8745-4bca-b747-4e382ee4775d
Sheet: Sheet1

1923 - 12th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Solbosch, Bruxelles, Belgium |  |  |  |  | 1923-09-23 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | Balloon Name | Landing Place | Distance km | Time
1 | BEL | Demuyter | Ernest | [NAME] | [NAME] | Belgica | Sköllersta Sweden | 1155 | [NAME]
2 | BEL | [NAME] | [NAME] | [NAME] | [NAME] |  |  | 1005
3 | SUI | [NAME] | Capt. [NAME] | Bachmann | Dr. O. | Helvetia | [NAME] | 546 | 10:05:00
4 | SPA | [NAME] |  | Sierra |  | Jesu [NAME] |  | 328
5 | FRA | Bienaime | [NAME] | Ravaine | Georges | La Picardie |  | 282
6 | USA | [NAME] |  | [NAME] | . | US Navy |  | 178
7 | GBR | Dunville | [NAME] | Dunville | [NAME] |  |  | 139
8 | SPA | Magdalena | E. | [NAME] |  | Espheria | Woldendorp Netherlands | 134
9 | USA | Olmstead |  | Choptaw |  | US Army S6 | [NAME] | 130
10 | SUI | Piccard | Prof. Auguste | [NAME] | E. | Zürich | Happert Netherlands | 85 | 01:35:00
11 | SUI | Grüningen | Ch. von | Wehren | F. | [NAME] | Moll/Belgium | 67 | 01:10:00
12 | FRA | Dubois | Jules | [NAME] |  |  |  | 64
13 | FRA | [NAME] | [NAME] | [NAME] | E. |  |  | 57
14 | SPA | [NAME] | [NAME]. | Penaranda |  | Polar | Heijst op den Berg/Belgium | 54
15 | GBR | [NAME] | Capt. Percival | Berry | [NAME] | [NAME] | North Sea | no res.
16 | BEL | Labrousse | Capt. M. |  |  | Ville de Bruxelles |  | no start
17 | USA | Honeywell | [NAME] |  |  | [NAME] |  | no start
Spreadsheet: 40981d1239379583-formula-similar-to-vlookup-needed-copy-of-program
Sheet: Shoulders & Traps

 | Shoulders |  |  | Traps
 | Front Delts
 | Two Arm Dumbbell Raises Over Head |  | 1 | Barbell Shrugs
 | One Arm Front Cable Raises |  | 2 | Barbells Shrugs Behind The Back
 | One Arm Front [NAME] Raises |  |  | Cable Shrugs
 | Incline Two Arm Deltoid Dumbbell Raises |  | 3 | Dumbbell Shrugs
 | Front Deltoid Plate Raises |  |  | Low Cable Rows To Neck
1 | Two Arm Front [NAME] Raises |  |  | Smith Machine Shrugs
 | Smith Machine Front Deltoid Presses |  |  | Smith Machine Upright Rows
 | Front Barbell Deltoid Raises |  |  | Dumbbell Upright Rows
 |  |  | 4 | Barbell Upright Rows
 | Middle Delts |  |  | Cable Upright Rows
 | Twisting Dumbbell Presses
 | Machine Deltoid Military Presses
 | Incline One Arm Deltoid Lateral Raises
 | One Arm Side Deltoid Laterals
 | Seated Barbell Deltoid Military Presses
4 | Seated Dumbbell Deltoid Presses
 | Seated Side Lateral [NAME]
 | [NAME] Deltoid Presses
2 | Dumbbell Deltoid Lateral Raises
 | Two Arm Dumbbell Deltoid Upright Rows
 | Standing Low Cable Deltoid Raises
 | Standing Deltoid Military Presses
 | Standing One Arm Dumbbell Presses
 | Standing Two Arm Dumbbell Presses
 | Upright Barbell Deltoid Rows
 | FreeMotion Overhead Cable Presses
 | Rear Delts
 | Bent Over Cable Rear [NAME]
 | One Arm Lying Rear Deltoid Raises
 | Lying External Rotations
 | Seated Cable Rear Lateral Raises
 | Lying Rear Deltoid Raises
3 | Reverse Incline Dumbbell Flyes
 | Bent Over Rear Deltoid Raises
 | Smith Machine Behind The Head Deltoid Presses
 | Standing Barbell Deltoid Presses Behind Head
Spreadsheet: 878155d1725176304-sorting-data-numerically-inside-the-cell-2vbr-example-236-365-spill-aligw
Sheet: Sheet1

Data (some jumbled, some not) |  |  |  |  |  | Data (sorted)
D-55-0-0, D-4-8-2, D-4-6-2, D-4-4-1, D-3-7-3 |  |  |  |  |  | D-3-7-3, D-4-4-1, D-4-6-2, D-4-8-2, D-55-0-0
D-2-16-1, D-2-13-3, D-2-13-2, D-2-12-3 |  | D-2-12-3, D-2-13-2, D-2-13-3, D-2-16-1 |  | D-2-12-3, D-2-13-2, D-2-13-3, D-2-16-1 |  | D-2-12-3, D-2-13-2, D-2-13-3, D-2-16-1
D-4-5-2, D-4-15-1, D-3-10-2, D-1-3-1 |  | D-1-3-1, D-3-10-2, D-4-15-1, D-4-5-2 |  | D-1-3-1, D-3-1-2, D-4-5-2, D-4-15-1 |  | D-1-3-1, D-3-10-2, D-4-5-2, D-4-15-1
D-4-6-6, D-4-5-6, D-4-14-1, D-3-13-1 |  | D-3-13-1, D-4-14-1, D-4-5-6, D-4-6-6 |  | D-3-13-1, D-4-5-6, D-4-6-6, D-4-14-1 |  | D-3-13-1, D-4-5-6, D-4-6-6, D-4-14-1
D-3-5-2, D-3-16-2, D-3-12-5 |  | D-3-12-5, D-3-16-2, D-3-5-2 |  | D-3-5-2, D-3-12-5, D-3-16-2 |  | D-3-5-2, D-3-12-5, D-3-16-2
D-4-8-2, D-3-15-2, D-1-15-1 |  | D-1-15-1, D-3-15-2, D-4-8-2 |  | D-1-15-1, D-3-15-2, D-4-8-2 |  | D-1-15-1, D-3-15-2, D-4-8-2,
D-15-12-5, D-15-12-1 |  | D-15-12-1, D-15-12-5 |  | D-15-12-1, D-15-12-5 |  | D-15-12-1, D-15-12-5
D-2-10-2, D-15-14-1 |  | D-15-14-1, D-2-10-2 |  | D-2-1-2, D-15-14-1 |  | D-2-10-2, D-15-14-1
D-15-16-1, D-1-2-2 |  | D-1-2-2, D-15-16-1 |  | D-1-2-2, D-15-16-1 |  | D-1-2-2, D-15-16-1
D-4-12-2, D-3-15-1 |  | D-3-15-1, D-4-12-2 |  | D-3-15-1, D-4-12-2 |  | D-3-15-1, D-4-12-2
D-4-13-7, D-3-11-7 |  | D-3-11-7, D-4-13-7 |  | D-3-11-7, D-4-13-7 |  | D-3-11-7, D-4-13-7
D-3-14-6, D-3-14-1 |  | D-3-14-1, D-3-14-6 |  | D-3-14-1, D-3-14-6 |  | D-3-14-1, D-3-14-6
D-2-5-1, D-2-15-2 |  | D-2-15-2, D-2-5-1 |  | D-2-5-1, D-2-15-2 |  | D-2-5-1, D-2-15-2
D-2-5-2, D-1-11-1 |  | D-1-11-1, D-2-5-2 |  | D-1-11-1, D-2-5-2 |  | D-1-11-1, D-2-5-2
D-4-6-5, D-3-14-1 |  | D-3-14-1, D-4-6-5 |  | D-3-14-1, D-4-6-5 |  | D-3-14-1, D-4-6-5
D-2-8-1, D-2-1-1 |  | D-2-1-1, D-2-8-1 |  | D-2-1-1, D-2-8-1 |  | D-2-1-1, D-2-8-1
D-4-2-2, D-3-3-2 |  | D-3-3-2, D-4-2-2 |  | D-3-3-2, D-4-2-2 |  | D-3-3-2, D-4-2-2
D-4-4-2, D-3-6-1 |  | D-3-6-1, D-4-4-2 |  | D-3-6-1, D-4-4-2 |  | D-3-6-1, D-4-4-2
D-4-8-2, D-3-8-2 |  | D-3-8-2, D-4-8-2 |  | D-3-8-2, D-4-8-2 |  | D-3-8-2, D-4-8-2
D-3-8-2, D-3-8-1 |  | D-3-8-1, D-3-8-2 |  | D-3-8-1, D-3-8-2 |  | D-3-8-1, D-3-8-2
Spreadsheet: 620246ab-753e-4f2f-b7c3-9df9df358559
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-09-09 09:37:12.010000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.71 | 101.585 | 101.46 | 101.085 |  | and are added to price quote
4.75 | 101.209 | 101.084 | 100.959 | 100.584
4.625 | 100.472 | 100.347 | 100.222 | 99.847 |  | Note: | Refer To Price [NAME]
4.5 | 99.562 | 99.437 | 99.312 | 98.937 |  |  | For all Price Adjs
4.375 | 98.611 | 98.486 | 98.361 | 97.736
4.25 | 97.825 | 97.7 | 97.575 | 96.95
4.125 | 97.017 | 96.892 | 96.767 | 96.142
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 101.991 | 101.866 | 101.741 | 101.366
3.875 | 101.276 | 101.151 | 101.026 | 100.651
3.75 | 100.578 | 100.453 | 100.328 | 99.953
3.625 | 100.085 | 99.96 | 99.835 | 99.46
3.5 | 99.539 | 99.414 | 99.289 | 98.664
3.375 | 98.818 | 98.693 | 98.568 | 97.943
3.25 | 98.045 | 97.92 | 97.795 | 97.17 |  | Minimum loan amount:
3.125 | 97.035 | 96.91 | 96.785 | 96.16 |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-09-23 09:37:12.010000
30 DAY | 2013-10-08 09:37:12.010000
45 DAY | 2013-10-23 09:37:12.010000
60 DAY | 2013-11-07 09:37:12.010000
90 DAY | 2013-12-07 09:37:12.010000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 674831ca-44c7-482e-9c22-e68756c2e428
Sheet: Table 2.4

Monthly Statistical Bulletin
2.4 Consumer price index
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Consumer price index (a)
September | 93.8 | 96.5 | 99.8 | 101.8 | 104
December | 94.3 | 96.9 | 99.8 | 102 | 104.8
March | 95.2 | 98.3 | 99.9 | 102.4
June | 95.8 | 99.2 | 100.4 | 102.8
Annual average | 94.8 | 97.7 | 100 | 102.3
Consumer price index quarterly change – per cent
September | 0.9687836383207582 | 0.7306889352818313 | 0.6048387096774244 | 1.394422310756971 | 1.167315175097272
December | 0.5330490405117239 | 0.4145077720207224 | 0 | 0.1964636542239662 | 0.7692307692307665
March | 0.9544008483563182 | 1.444788441692468 | 0.1002004008016089 | 0.3921568627450966
June | 0.6302521008403339 | 0.9155645981688831 | 0.5005005005005003 | 0.390625
Consumer price index annual change (b) – per cent
September | 1.186623516720609 | 2.878464818763327 | 3.419689119170988 | 2.004008016032066 | 2.16110019646365
December | 2.056277056277045 | 2.757158006362692 | 2.992776057791535 | 2.204408817635284 | 2.745098039215677
March | 2.918918918918911 | 3.256302521008392 | 1.627670396744674 | 2.502502502502502
June | 3.121636167922492 | 3.549060542797511 | 1.209677419354849 | 2.39043824701195
Annual average | 2.348178137651824 | 3.059071729957807 | 2.354145342886382 | 2.299999999999991
Underlying inflation annual change (c) – per cent
September | 3.5 | 2.65 | 2.7 | 2.4 | 2.35
December | 3.45 | 2.35 | 2.75 | 2.35 | 2.6
March | 3.3 | 2.35 | 2.25 | 2.45
June | 3 | 2.8 | 1.95 | 2.5
Annual average | 3.3125 | 2.5375 | 2.4125 | 2.425
(a) All groups, eight capital cities index.  Base: 2011-12 = 100.0.
(b) Referred to as the 'headline' inflation rate.
(c) The average of the Reserve Bank of Australia weighted median and trimmed
mean price inflation measures. Referred to as the 'underlying' inflation rate.
Source: ABS, Consumer price index, Cat. no. 6401.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6401.0&viewtitle=Consumer%20Price%20Index,%20Australia~Dec%202007~Latest~23/01/2008&&tabname=Past%20Future%20Issues&prodno=6401.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6401.0&viewtitle=Consumer%20Price%20Index,%20Australia~Dec%202007~Latest~23/01/2008&&tabname=Past%20Future%20Issues&prodno=6401.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6401.0&viewtitle=Consumer%20Price%20Index,%20Australia~Dec%202007~Latest~23/01/2008&&tabname=Past%20Future%20Issues&prodno=6401.0&issue=Dec%202007&num=&view=&
RBA, Statistical Tables, Prices and Inflation |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-04-23 00:00:00
Spreadsheet: 830798d1685119508-combining-order-data-from-multiple-rows-into-single-row-multiplerows
Sheet: Sheet1

Current |  |  | Desired
Order | Item |  | Order | Item
ABC124 | milk |  | ABC124 | milk; bread
ABC124 | bread |  | ABC125 | cheese; meat; crackers; juice; cookies; bread; candy; pizza; milk
ABC125 | cheese |  | ABC126 | donuts
ABC125 | meat |  | ABC127 | apples; oranges
ABC125 | crackers
ABC125 | juice
ABC125 | cookies
ABC125 | bread
ABC125 | candy
ABC125 | pizza
ABC125 | milk
ABC126 | donuts
ABC127 | apples
ABC127 | oranges
Spreadsheet: 55825983-100f-47e7-8691-287c69fd1661
Sheet: Quarterly- Unit Sales Levels 

Quarterly Question: By roughly what percent are your firm's unit sales levels above/below “normal,” if at all?
 | Average percent above/below normal  (number of responses)
 | Small firms (1-99 employees) | Mid size firms (100-499 employees) | Large firms (500+ employees)
2012-09-14 00:00:00 | -0.096 | -0.096 | -0.049
2012-12-14 00:00:00 | -0.103 | -0.111 | -0.021
2013-03-15 00:00:00 | -0.122 | -0.068 | -0.033
2013-06-14 00:00:00 | -0.073 | -0.015 | -0.022
2013-09-13 00:00:00 | -0.074 | -0.066 | -0.025
Spreadsheet: 542163d1507735435-tie-cells-to-other-cells-sample-workbook
Sheet: BOM

 |  | Build Quantity | 4
 |  |  |  |  |  |  |  |  | On-Hand
Part Number | Description | QTY Per Build | All Build QTY | Attrition/Spares | QTY to Order | Part Type | Inventory | Delivered Qty | Inventory Notes | Outstanding Parts | Supplier | Lead Time | PR # | PO # | Due Date
Spreadsheet: 49138d1248386800-updating-shared-excel-file-on-a-network-2nd-ave-bin-inventory
Sheet: Sheet1

2nd Ave [NAME]
[NAME]
Bin # | Product | Grade | Amount | In/out | Who Updated Information | Time Updated | Comments
D-1 | [NAME] | 1 | 0.75 | Cleaning Out of | [NAME] | 2009-07-23 13:14:00
D-2 |  |  | Empty |  | [NAME] | 2009-07-22 21:49:00
D-3 |  |  | Empty |  | [NAME] | 2009-07-22 08:45:00
D-4 |  |  | Empty |  | [NAME] | 2009-07-22 21:48:00
D-5 |  |  | Empty |  | [NAME] | 2009-07-22 21:49:00
D-6 |  |  | Empty |  | [NAME] | 2009-07-22 21:47:00
[NAME] |  |  | Empty |  | [NAME] | 2009-07-22 21:50:00
D-8 |  |  | Empty |  | [NAME] | 2009-07-22 21:50:00
D-9 |  |  | Empty |  | [NAME] | 2009-07-22 21:50:00
Clean Bins
Bin # | Product | Grade | Amount | In/out | Who Updated Information | Time Updated | Comments
C-1
C-2 | Richlea Lentils | 1 | Full |  | [NAME] | 2009-07-22 21:51:00
C-3 | Richlea Lentils | 1 | Full |  | [NAME] | 2009-07-22 21:51:00
[NAME] | Richlea Lentils | 1 | 0.5 |  | [NAME] | 2009-07-22 21:52:00
C-5 | [NAME] | 1 | 0.25 | Cleaning In To | [NAME] | 2009-07-22 21:54:00
C-6 | [NAME] | 2 | 0.75 |  | [NAME] | 2009-07-23 13:14:00
Bag Tank | [NAME] | 1 | Full |  | [NAME] | 2009-07-23 13:17:00
S Bins
Bin # | Product | Grade | Amount | In/out | Who Updated Information | Time Updated | Comments
S-1 | Screenings | 3 | 0.5 | Cleaning In To | [NAME] | 2009-07-22 08:49:00
S-2 | Screenings | 3 | Full |  | [NAME] | 2009-07-22 08:49:00
S-3
S-4 | Refuse |  | Cone | Cleaning In To | [NAME] | 2009-07-22 08:49:00