Fermé

VBA Macro Bug find

Hi all,

We want to find a bug in a VBA macro which use Kryon export files and xlms templates.

We have isolated a case study happened on April 1st, so I've prepared a full data folder which contains:

- Kryon extraction folders, which are used as input from VBA macros (Attivita, CBK, CPSI, MNT, SickUnits)

- Output folder, where the macro generates an output file for each region template xlsm.

- LOGS folder, with the log recorded

- "Report Operativo [login to view URL]" file, which is the configuration file used by VBA macro

- "Report Operativo [login to view URL]" file, which contains the macro "start_Import_Unattended" called remotely

- 17 files "SCHMIL_OPERATIVO [login to view URL]", which are template for every region and are used to generate the file in Output folder.

I forward you the email from our Product Owner who reports to us in detail all missing values generated by the macro "start_Import_Unattended" called remotely after generating all the Kryon files.

-----------------------------------

Like every week, some "random" data on the 17 reports are missing.

Some are common for many of the 17 reports, others only manifest themselves in some.

This has happened since the beginning of the year and often with the publication of the new week they settle down, only to reappear in a "random" way.

Below, what we found this week:

1) Common for all 17 reports

Sick units (both in % and in number) : the value of column H must be the same as that of column V

2) Report specific:

2603

#Visite S Scadute : column U should remain zero as visits not performed in the month must be charged every 4 weeks, i.e. at the change of the month.

2604

#Visite S scadute : The same, with the addition of the T column which instead should be zero

Media Tempi e NC : column H is not powered on the Mauro Opini sector

2605

#Visite S scadute : as for 2604 (columns T -U should be zero)

Sick Units : the values of the last three weeks are missing (columns s-t-u-v) both in % and numerical value

2608

Media Tempi e NC : column H is not powered on the Roberto Cesarano sector

2613

% ore amministrative (column H) total times are missing (#DIV/0!)

NC (always column H) part of the data is missing (#DIV/0!)

2614

#Visite S scadute : as for 2605 (columns S-T-U should be zero)

% ore amministrative (column H) total times are missing

2616

% ore amministrative (column H) total times are missing

2620

% ore amministrative (column H) total times are missing

#Visite S scadute : as for 2605 (columns S-T-U should be zero)

%FR totale: column H sector Andrea Zecchillo, incongruent value

-----------------------------------

I can send a zip file for whom interested.

Thanks

Compétences : Excel, Visual Basic, Visual Basic pour les apps , Traitement de Données, Excel Macros

En voir plus : vba macro excel unicode, excel vba macro paste adjacent column, next empty cell vba macro paste, vba macro trial, vba macro generate report excel word, paste excel vba macro, row column increment vba macro, vba macro click button webpage, excel vba macro databases, calling oracle procedure vba macro, vba macro perl, excel vba macro programming bids, deploy vba macro, excel 2003 paste clipboard vba macro excel, export word access vba macro, outlook 2007 vba macro export calendar pst, vba macro txt export access, export pst outlook 2003 vba macro, use information data gathered healthtalkonline case study, Hi! Small bug

Concernant l'employeur :
( 0 commentaires ) Naples, Italy

Nº du projet : #30954535

27 freelances font une offre moyenne de 468 € pour ce travail

(842 Commentaires)
8.9
(255 Commentaires)
8.2
(1056 Commentaires)
8.2
(459 Commentaires)
8.3
(166 Commentaires)
7.8
(67 Commentaires)
6.9
ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the Workbook along with all other files- the bug report in the conte Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(230 Commentaires)
7.1
(208 Commentaires)
6.7
AwaisChaudhry

Hi there, I have read the brief details on the job listing. You can check my experience, customer feed backs and my portfolio here: https://www.freelancer.com/u/AwaisChaudhry?w=f I believe its a doable job I have grea Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(4 Commentaires)
6.0
sajibdigital

"Hi, If you give me this project, I will try my best for your satisfaction. Hope you will consider me for this job. Lets discuss more details about this project."

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(76 Commentaires)
5.8
(41 Commentaires)
6.1
(14 Commentaires)
5.7
nfnTV

Hi, dear client. I'd really like to work with you on this one if possible! I have carefully read your project post VBA Macro Bug find, and want to make you an offer and some background so you can check my work out. I a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 6 jours
(1 Évaluation)
4.1
(6 Commentaires)
4.2
geomago

Rispondo in italiano visto che siete italiani: sono interessato al lavoro. Sono software engineer da più di 40 anni, vivo e lavoro a Roma. Come valore della mia offerta ho lasciato il default (500 euro), ma se mi invia Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(5 Commentaires)
4.2
LordVilagi

Hi there, if you send me the zip files and check it out. If it's a lot of minor bugs (will require less than 4-5 hour of my time), then I will do this for free, if not then I will consult with you. Best Regards Franti Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(2 Commentaires)
4.2
osamawebjuggler

Hi I am expert in excel having experiance in excel and work with 100% accuracy and quality.,,,,,,,,,,,,,,,,,,,,,,,,,,

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(10 Commentaires)
3.9
arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(11 Commentaires)
3.5
Crayon1365

[login to view URL] [login to view URL] [login to view URL] [login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(8 Commentaires)
3.6
metlickijv

Good day Glovanni R. I am a top talent Excel macro and VBA developer with extensive experience. I have powerful background in Excel VBA and macro. As an exeprt I am confident I can deliver high quality result. I can wo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(1 Évaluation)
2.6