I could use some help with this task. I have also attached the information that needs to go into the txt. file mentioned.

1 0.821332802

1 1.663239412

1 3.118099764

1 3.638988312

1 3.72830943

1 4.642240339

1 4.78922577

1 5.546816437

1 6.668883886

1 6.765541212

1 6.860869599

1 6.952844383

1 7.576607692

1 7.882120054

1 8.510559861

2 0.728147487

2 1.457583231

2 1.702628685

2 1.925106006

2 2.024665364

2 2.066154502

2 2.158897505

2 2.496044377

2 4.598151212

2 8.74574779

2 8.764647892

2 8.911880109

2 9.55905625

2 9.574899119

2 9.625124963

3 0.258730055

3 0.968202661

3 1.050349077

3 1.368963142

3 1.51652307

3 1.710423493

3 2.084744965

3 2.228607476

3 4.453327609

3 5.498133474

3 5.573841675

3 6.636203379

3 7.082580441

3 8.224929812

3 9.802175791

4 0.283286604

4 0.492962138

4 1.389875978

4 1.936858999

4 3.533237987

4 3.548358149

4 4.020233477

4 4.400301984

4 5.254960852

4 5.999109291

4 7.251798968

4 7.404451151

4 7.410515746

4 8.033826203

4 9.720391693

5 0.388995255

5 0.767960842

5 0.867153703

5 1.428633644

5 1.591905565

5 1.952135943

5 2.628217397

5 3.023064217

5 3.193297077

5 3.436587424

5 3.48602242

5 4.092726907

5 4.588124248

5 7.040136708

5 9.967440572

6 0.52972374

6 0.661017694

6 0.775089288

6 1.727934255

6 1.951794624

6 3.762902349

6 4.050216416

6 6.852783644

6 7.11921108

6 7.237125696

6 7.746381914

6 8.116293217

6 9.178661277

6 9.25240565

6 9.76638059

7 1.977657266

7 1.995693436

7 3.970366334

7 4.289474616

7 4.308861519

7 5.397253827

7 5.8752072

7 5.960247462

7 6.396294064

7 6.537990048

7 6.850328901

7 6.88469002

7 7.039506839

7 7.703813336

7 9.328623114

8 0.393291937

8 1.259508932

8 1.473348213

8 1.630398968

8 1.793186446

8 2.138148655

8 2.733489698

8 4.268719076

8 4.370937501

8 4.704086675

8 6.421606269

8 6.731141428

8 6.883553878

8 7.56173307

8 9.099675726

9 0.305906377

9 0.831961703

9 1.437893232

9 2.425983218

9 4.035330219

9 4.19361224

9 6.022782313

9 6.382480309

9 7.147167114

9 8.027227937

9 8.083902395

9 8.319033337

9 8.469284459

9 8.828033608

9 9.090120238

10 0.610660298

10 0.945006304

10 1.054483475

10 2.085753973

10 3.583424203

10 3.645008663

10 4.720548137

10 5.395835931

10 5.516138919

10 5.76480875

10 6.473778787

10 6.626789565

10 8.78067105

10 9.576515864

10 9.63467529

11 0.442023069

11 2.043276573

11 2.138791891

11 2.854836939

11 3.196162024

11 4.098441851

11 5.027034367

11 6.169007237

11 6.248496045

11 6.322368292

11 6.787470238

11 7.053473669

11 7.218936678

11 7.639483995

11 8.569106441

12 0.313861958

12 0.888072633

12 2.870969221

12 2.980417956

12 4.303297221

12 4.358956867

12 5.014416331

12 5.703833718

12 6.645097841

12 7.148639562

12 7.389112227

12 7.468758892

12 8.740165272

12 9.667408566

12 9.718468351

13 0.557391741

13 1.768789683

13 2.262076229

13 3.733676482

13 6.485510038

13 6.612017718

13 7.078327078

13 7.185422506

13 7.882166712

13 8.118565582

13 8.366449838

13 8.950261854

13 9.080971586

13 9.11606814

13 9.383259013

14 1.295679213

14 1.64162875

14 2.88273557

14 3.431922365

14 4.058427693

14 4.381596491

14 4.736501973

14 6.104707829

14 6.313085867

14 7.53831191

14 8.453527283

14 8.963363183

14 9.026579248

14 9.203396147

14 9.487353447

15 1.507392594

15 3.010532346

15 3.482859956

15 3.65391806

15 4.393493581

15 4.684973188

15 4.878309983

15 5.296468578

15 5.870466638

15 6.607830146

15 6.652529307

15 8.254911974

15 8.493807746

15 8.80907848

15 8.823881821

16 1.6792849

16 1.774986633

16 2.164801348

16 2.627008324

16 2.976537737

16 3.37001034

16 3.57993779

16 4.646467057

16 5.01910587

16 5.792729899

16 6.187364089

16 9.073879357

16 9.115536958

16 9.23468257

16 9.937126268

17 0.791926077

17 1.024096644

17 1.057036288

17 1.379140587

17 1.650523964

17 2.128447168

17 2.149687277

17 2.567134326

17 3.503264988

17 4.497800096

17 4.710523797

17 4.827117449

17 5.099252665

17 5.767815333

17 6.088179359

18 0.216449481

18 0.353318

18 0.451917126

18 1.164070582

18 2.258831835

18 3.221939087

18 3.66013965

18 4.255275387

18 5.652096231

18 6.139091299

18 6.212540002

18 6.283505781

18 6.527721164

18 8.314608854

18 9.379885074

19 0.412611242

19 0.460308972

19 0.868004972

19 1.17804951

19 1.293157859

19 1.736974167

19 3.650333377

19 4.403056136

19 5.247610315

19 5.931314264

19 6.000479104

19 7.256570459

19 9.273843335

19 9.62142097

19 9.622162424

20 0.523875008

20 1.2598147

20 1.831564303

20 2.463589722

20 3.553622335

20 3.58590926

20 3.773532078

20 4.188904761

20 4.665543401

20 5.459226454

20 5.959916168

20 6.929686198

20 7.60855456

20 8.398893562

20 8.771922826

21 0.690147054

21 1.439454367

21 2.501138203

21 2.973457635

21 3.881662222

21 4.104804636

21 4.140633205

21 4.979179184

21 4.997506862

21 6.01839295

21 6.193297905

21 6.588048899

21 7.565897956

21 9.388171305

21 9.842288286

22 0.145178206

22 1.991135768

22 2.380844893

22 2.473360825

22 3.076339393

22 3.735188361

22 4.256225789

22 4.976842259

22 5.087136373

22 5.324129275

22 5.83191748

22 8.963982558

22 9.635455321

22 9.834523733

22 9.905655617

23 0.015247478

23 1.79439615

23 1.896465229

23 3.291332126

23 4.791607935

23 4.832690805

23 4.84131543

23 5.711092928

23 7.291555817

23 7.66090505

23 7.858140693

23 8.91214413

23 9.31702734

23 9.435205948

23 9.47137663

24 0.064777965

24 1.144038991

24 2.320820166

24 4.411218586

24 5.643396083

24 5.880279404

24 5.961705872

24 6.178449591

24 6.546966284

24 6.793884842

24 7.597804862

24 8.209532923

24 9.325521759

24 9.393539828

24 9.422267116

25 0.134494719

25 0.18288153

25 0.686179955

25 0.795220898

25 5.318413426

25 5.838374044

25 5.929192493

25 6.251429438

25 7.780858039

25 7.843881545

25 7.913508683

25 8.119094616

25 8.615374071

25 9.695758486

25 9.886025872

26 1.21908345

26 1.913867347

26 2.052930703

26 2.694224565

26 4.052856736

26 4.480651144

26 4.576161958

26 6.989839256

26 7.252614996

26 7.861403479

26 8.376221657

26 8.432614421

26 9.390450564

26 9.486509482

26 9.592390437

27 1.047263719

27 1.350531406

27 2.504861785

27 2.895400569

27 4.501047754

27 4.95236875

27 5.081146438

27 6.700888952

27 7.439891723

27 8.586077243

27 8.640912932

27 8.857610006

27 9.314431145

27 9.707709048

27 9.944490011

28 1.176440919

28 1.492714975

28 2.881771994

28 3.320641579

28 3.726072739

28 4.113093201

28 4.510782488

28 4.68049751

28 6.288134351

28 6.439425147

28 6.668343887

28 6.712722344

28 6.753706292

28 7.853603586

28 8.598886572

29 1.424735477

29 2.393087506

29 3.782539566

29 3.859222618

29 4.129728865

29 4.862125582

29 6.156777574

29 6.221825261

29 8.062452042

29 8.069855833

29 8.650693246

29 8.689871492

29 8.93857492

29 9.013437451

29 9.15850435

30 0.071956677

30 0.965038282

30 1.143383213

30 1.322258125

30 2.234039813

30 2.407495313

30 2.457236063

30 2.701723965

30 2.829463175

30 3.418879788

30 3.618520645

30 4.264701738

30 6.565844231

30 7.880952268

30 8.12673527

31 0.083449625

31 0.126373544

31 1.182114293

31 1.972631985

31 2.684844435

31 2.988995804

31 3.780245765

31 4.267219484

31 4.664829853

31 5.572515697

31 6.470305536

31 6.961875308

31 7.261447377

31 8.580116365

31 8.764981024

32 0.312557799

32 0.544505985

32 1.255587511

32 1.641330908

32 3.043874539

32 3.277145516

32 3.465489174

32 4.729573652

32 5.197963695

32 6.038249774

32 6.06164081

32 8.148120118

32 8.153808367

32 9.168956936

32 9.617237115

33 1.077005706

33 1.59956715

33 2.369403133

33 3.120217719

33 3.412282954

33 3.417744541

33 4.027462986

33 4.309488375

33 4.639547564

33 6.193395021

33 7.223618825

33 9.067960318

33 9.276764504

33 9.502930323

33 9.664778751

34 0.514255486

34 1.414352816

34 1.624628972

34 1.962440507

34 2.685168692

34 2.764236807

34 4.028933087

34 4.29551594

34 5.152029822

34 5.503077333

34 6.302811772

34 7.119710377

34 7.727676617

34 8.693822617

34 9.739592927

35 0.921040311

35 2.420982897

35 4.452871222

35 5.047343234

35 6.333695451

35 7.339421739

35 7.691421547

35 7.702217205

35 7.731490554

35 8.243649587

35 8.605294365

35 8.728120793

35 9.106989873

35 9.1492054

35 9.243759684

36 0.06784624

36 0.624623986

36 1.541383628

36 1.829900905

36 2.400385486

36 3.011446751

36 3.640916217

36 3.95669367

36 4.42496725

36 4.837156474

36 5.20939193

36 7.776846755

36 7.999567136

36 8.024962019

36 9.570295938

37 1.215494013

37 1.303286636

37 1.775360544

37 2.928355437

37 3.199604075

37 3.421900251

37 3.946127662

37 5.667671861

37 5.699826471

37 6.061279292

37 6.290237593

37 6.626201632

37 7.552914086

37 8.446162156

37 9.384648883

38 0.303266941

38 0.640790929

38 2.152031318

38 2.970535671

38 3.586475836

38 4.66790129

38 4.717195746

38 4.828193403

38 4.870132727

38 5.846129591

38 5.965471929

38 6.044808824

38 7.478085242

38 7.699602076

38 8.313994873

39 0.763909927

39 1.15846922

39 2.27264734

39 2.322610404

39 2.694748384

39 2.865194429

39 3.897448799

39 3.931086732

39 4.128172726

39 6.387705083

39 6.749154321

39 6.849897514

39 8.544599917

39 9.746676179

39 9.957630297

40 0.326608023

40 0.582383686

40 1.33185674

40 1.425664408

40 2.484388312

40 2.828601209

40 2.839606457

40 3.947807158

40 4.794792465

40 5.708004244

40 7.0571648

40 7.069954553

40 7.218877013

40 8.111181763

40 9.47390662

41 0.088946383

41 0.164598768

41 0.656153118

41 1.021055836

41 1.192727791

41 2.030238553

41 3.091969013

41 3.305855818

41 3.31611649

41 3.355561591

41 4.438664334

41 4.923753323

41 5.560665571

41 5.896588288

41 6.056887637

42 0.214318796

42 0.535750653

42 3.322683706

42 3.612034337

42 4.424047369

42 5.06990603

42 5.152355365

42 5.796041827

42 5.927842511

42 7.195573314

42 7.264546918

42 8.105846735

42 9.297728321

42 9.448835643

42 9.755066699

43 1.164850894

43 1.689176042

43 2.564435321

43 3.49158548

43 3.974204924

43 4.140548757

43 4.958282176

43 5.247466387

43 5.962069114

43 6.310275281

43 7.457322387

43 8.476448749

43 9.347173041

43 9.395413623

43 9.828459925

44 2.217575641

44 2.39087229

44 2.535322902

44 3.995120183

44 4.452205968

44 5.305860533

44 5.321938795

44 5.396777588

44 5.593448849

44 7.02443829

44 7.637701292

44 7.842557709

44 8.78796822

44 8.843028027

44 9.794427714

45 1.263435893

45 1.61025807

45 1.692817371

45 2.316003253

45 2.316701646

45 3.186913902

45 3.542364483

45 3.702227467

45 4.744865628

45 5.153438531

45 6.759680366

45 7.183844333

45 7.813508442

45 9.564324419

45 9.965297399

46 0.313758892

46 0.752099498

46 2.729796186

46 3.600169394

46 3.600784809

46 3.999108656

46 4.152659028

46 4.554226115

46 5.1566644

46 5.994227298

46 6.377271348

46 6.383846514

46 8.011910005

46 8.058546252

46 9.309960781

47 0.005959679

47 1.130778904

47 1.283313846

47 1.417943373

47 2.308617567

47 2.36672715

47 3.349778371

47 3.571239112

47 3.935837745

47 5.912302727

47 7.250878621

47 8.493438454

47 8.800276712

47 9.409807596

47 9.69611719

48 0.341160432

48 0.542426758

48 0.958988713

48 3.299391184

48 3.69213318

48 3.823024507

48 5.052129706

48 5.465680817

48 5.583174925

48 5.696367635

48 5.949096765

48 6.430321252

48 7.424044428

48 8.475313121

48 9.417094242

49 1.067941773

49 1.686528576

49 2.374989823

49 2.432529934

49 2.497601147

49 4.172964419

49 5.369324793

49 6.441048769

49 6.765962692

49 6.792897717

49 7.411488004

49 7.914012371

49 8.218271788

49 8.554011115

49 8.615672299

50 0.298560468

50 0.355389911

50 0.809004927

50 1.876180682

50 2.056906188

50 2.229586111

50 3.627526971

50 4.099635254

50 6.004617535

50 6.447020628

50 6.579989155

50 6.66191726

50 7.173833076

50 7.243905798

50 7.612326228

Problem Statement: Write a well-commented VBA program to process a set of data in preparation for a subsequent frequency analysis. Raw data will be provided in 50 batches of 15 observations (750 total observations), in a two-column text file (750 rows by 2 columns). The first (left) column represents the batch number or test run, and the second (right) column represents the observation. The program must read the data, convert the 750 x 2 format to a 50 x 15 matrix format, and determine (and record into the spreadsheet) the maximum observed value in each batch. Additional Requirements/Details: Your program should