From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on ip-172-31-74-118.ec2.internal X-Spam-Level: X-Spam-Status: No, score=0.8 required=3.0 tests=BAYES_50,FREEMAIL_FROM autolearn=ham autolearn_force=no version=3.4.6 X-Received: by 2002:ac8:4a0e:: with SMTP id x14mr17649753qtq.345.1640671369779; Mon, 27 Dec 2021 22:02:49 -0800 (PST) X-Received: by 2002:a05:6902:703:: with SMTP id k3mr24744633ybt.31.1640671369506; Mon, 27 Dec 2021 22:02:49 -0800 (PST) Path: eternal-september.org!reader02.eternal-september.org!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail Newsgroups: comp.lang.ada Date: Mon, 27 Dec 2021 22:02:49 -0800 (PST) In-Reply-To: Injection-Info: google-groups.googlegroups.com; posting-host=213.166.55.173; posting-account=sDyr7QoAAAA7hiaifqt-gaKY2K7OZ8RQ NNTP-Posting-Host: 213.166.55.173 References: <7bede061-4b0f-4029-beb1-1056637e57d6n@googlegroups.com> <49538254-21ed-4fd0-8316-1bccc7d3c635n@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: Some advice required [OT] From: Laurent Injection-Date: Tue, 28 Dec 2021 06:02:49 +0000 Content-Type: text/plain; charset="UTF-8" Xref: reader02.eternal-september.org comp.lang.ada:63291 List-Id: On Tuesday, 28 December 2021 at 03:10:54 UTC+1, Randy Brukardt wrote: > "Laurent" wrote in message > news:49538254-21ed-4fd0...@googlegroups.com... > On Monday, 27 December 2021 at 12:16:27 UTC+1, Niklas Holsti wrote: > ... > >> Also, if you do not intend to implement the solution in Ada, this is not > >> the right group to discuss it. > > >I would very much prefer to solve it in Ada but at work I am stuck with > >Excel > >and VBA which is better than doing it manually. After a few hours starring > >at > >a screen with thousand of rows of results... If I get an Ada solution I can > >adapt it. Just limited to no access/pointers in VBA which shouldn't be > >required? > Hybrid Ada-spreadsheet solutions are possible. It's quite easy to read/write > .csv files in Ada, and those can be easily imported/exported from any > spreadsheet program (I've been using Libreoffice Calc, but Excel is > similar). > > For an example, the ACATS grading tools essentially work by expecting the > vendor (or a third party) to provide a tool that converts compilation > results into a .csv file. The .csv file(s) are then read by the grading tool > and compared to required results to provide a grade. But it also can be read > into a spreadsheet for sanity checking as well as additional analysis. > > Similarly (and probably more useful to you), I've used spreadsheet data for > various traffic in AdaIC (retrieved from Google) as input to Ada programs > that analyze the data to provide information that Google is unable to (in > particular, usage of the various Ada standards, which are split up into > usage of several hundred separate files). I then take the results of the Ada > program (which is also a .csv file), open that, and paste the results into a > previously created spreadsheet that generates charts for showing to > management. (Even highly skilled programmers don't like looking through > columns of numbers for trends. :-) > > But you do have to be able to describe the results that you are looking for. > Having read the entire thread, I'm more confused than I started. :-) I > suspect when you can describe your problem algorithmically, the solution > will be obvious. Good luck finding a solution. > > Randy. The problem is not that I don't want to use Ada. We are using Citrix so I am stuck with the programs the IT departments allows me to use. Was already a chore to get MS Access made available. I could send all the data home but then I have to be very careful to not have some patient information somewhere floating around. Otherwise finding a solution to automate this will be the least of my problems. Thanks for the motivation