offline
Last seen: Apr 20, 2014 8:49 PM EDT
Hire Me!
Rate: $30.00 USD/hour
Follow Invite to Project
 

Tomislav Malis

Excel and VBA Expert - MS Project Expert-Primavera P6 Expert - Civil engineer

Username: tomislav1975

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has verified their secure phone number.
  • Verified
  • Payment is verified.

Location: Zagreb, Croatia

Member since: August 2013

Reputation:

5.0/5

(5 reviews)

3.7
[see more]

2 users have recommended this freelancer.

My projects:

  • $200 USD
    5.0
    Profile image for Seller en6210

    en6210

    12 days ago

    For me Tomsilav is No. 1 Professional, quick, patient, and full of ideas. Again at any time!!!

    Project Description:Existing tool change as described .....................................
    [more]
  • $113 AUD
    5.0
    Profile image for Seller steve045

    steve045

    Oct 25, 2013

    Great customer service, He knows what his doing and does what he say. would definitely hire again.

    Project Description:Using a windows 8 table (acer iconia) I want to be able to click on a button in excel and the camera will open, take a photo and the picture will be imbedded to a cell. Put pop ups command in my workbook, Hide, show sheets automatically with button based on value...
    [more]
  • $40 USD
    5.0
    Profile image for Seller en6210

    en6210

    Sep 18, 2013

    I've seen a lot in Excel. But this is madness!Excel guru through and through. Perfect!

    Project Description:Hallo, können Sie in Deutsch kommunizieren? Das würde für mich die Kommunikation mehr als vereinfachen. Ich benötige eine ganz spezielle Grafik die Temperaturdaten aus einem Excel Sheet einliest, als Grafik ablaufen lässt...
    [more]
  • $155 USD
    5.0
    Profile image for Seller masterstructural

    masterstructural

    Sep 11, 2013

    Tom is the best VBA expert that I have ever known. Completed another complicated program in Excel VBA.

    Project Description:Excel VBA Expert needed to create a sketch with polilines and other shapes by entering lengths/properties from tables. Please email me and I will send you the marked up file. Thanks.
    [more]
  • $141 USD
    5.0
    Profile image for Seller masterstructural

    masterstructural

    Aug 28, 2013

    This guy is really a VBA-excel master. I had posted before the same project to be done in C++ but both attempts failed. Tomislav completed it in VBA. It took about 1600 lines of code and I learned a lot during the experience. Will use him again in the future!

    Project Description:See attached spreadsheet. I want to enter the information in tables and the graph is created and updated automatically.Need it done using Excel VBA. The right person will train me how to do this myself...
    [more]
    Tomislav Malis has not completed any projects.
  • $100 USD In Progress

    .......................................................................................................:-)

  • $20 USD/hr In Progress

    Ich habe laufende Arbeiten im Zusammenhang mit unserem letzten Projekt "Excel VBA animierte Grafiken und Report"

  • £65 GBP Today

    Develop a high level Gantt Chart using Microsoft Project ...See Attached files for all the information and some support documents. In the progress report part are the previous task done to be use as a guide. thank you

    [more]
  • £67 GBP Today

    I would like you to produce a high level Gantt Chart for me from a given scenario using MS Project software, and a good explanation of all the steps involved. The Project Management methodology we will be using is Prince2. I will give you the scenario upon a bid.

    [more]
  • $77 USD Today

    This is a repost since the person couldn"t finish. I am looking for a programmer, or someone VERY strong in Microsoft Excel, to develop a program/algorithm. This would be based on a list of words that need to be filtered and shown based on many variables. You should be confident in excel formulas. Further details will be given to potential hires. I need this done ASAP.

    [more]
  • $400 AUD Yesterday

    Hi,Please read this carefully and understand the exact requirements.I think this may need some VB expert if you’re doing this in excel?Looking for someone that has the following skill set based on the following requirements.Attached is the data and the warehouse layout in the project.I don’t mind if you do it in excel or you create software that can deliver the following requirements. 1. I would like the layout to look much better than it currently looks but needs to stay the same. 2. How many bins in total are there in the warehouse layout 3. Can you then tell me how many single bins there are. 4. Can you tell me how many 2 deep bins there are. 5. Can you tell me how many 3 deep bins there are. 6. Can you tell me how many 4 deep bins there are. 7. From the (SOH by location) tab can you tell me how many bins are being occupied by inventory? Bin location is in column (E). 8. Can you then tell me the number of bins that aren’t being occupied by inventory and which ones. 9. From the (Sku’s List volumes) tab can you show me on the warehouse layout, where by bin location the Sku’s are located as well as conditional formatting the colour of the bins based on the following volume break points below.10. Can you show many how many bins are being occupied by Business Group Name from (Inventory) Tab column H is the Business Group Name column.Please note one (1) bin location can occupy more than one Sku or one (1) sku can occupy more than 1 bin location. (There is no one sku to bin relationship).Please note the volume to stores figures in column B (Sku List volumes) tab are just made up for this exercise but when I do receive the actual numbers I want to be able to just cut and paste so the warehouse layout bins turn a certain colour based on the volume breaks. So the volumes may be less so I may need to change my range when I know the true volumes so can you make the ranges dynamic for this to happen?If you can think of better volume breaks as in less breaks please create your own range.Here is the volume break range 34,310 – 39,300 (Colour Green bins) 24,310 – 34,300 (Colour Orange Bins) 19,310 - 24,300 (Colour Yellow Bins) 14,310 - 19,300 (Colour Blue Bins) 9,310 – 14,300 (Colour Pink Bins) 4,310 - 9,300 (Colour light Purple bins) 5 - 4,300 (Colour Red Bins)All data tabs will be static for cut and paste for (SOH By location) tab and (Sku’s List Volumes) tab for when I need to update so all of this needs to be dynamic.Will also require a stunning dynamic dashboard for points 2-8 and point 10.Please note I have also provided an example of the bin types in the (Example of bin sizes) tab.If you have the skill set please applyFuture work will be available for the right candidate.In your bid please let me know what software or application you will do this in.I will then know you have read the entire brief.Thanks

    [more]
  • $16 USD/hr Yesterday

    Hello, we have few macros to develop around 25, in this month, and we are looking for a freelancer or few freelancers who can develop macros, we now have 5 macros to start with, even you are new freelancer with macro skills you can bid, thanksNote : place bids per hourly as at the moment we can give exact work to handle, thanks

    [more]
  • [Sealed] 2 days ago

    I need two program to be written in VB for maths problem attached. Please contact ASAP. Please apply you you can quickly provide it.

  • $155 USD 2 days ago

    hello!Need some help filling out the attached spread sheet. I am looking to understand which companies (column A) deliver to which countries (column B-more), and just need a simple "yes" or "no" depending on which countries each company ships to.As you can see from the example, most companies ship to all countries, but for the ones that dont, it can be a little tricky to figure out where exactly they ship (check out a few that have "no" for yourself to understand the complexity). There are 800 rows total, and I"ve done 200 of them (but left a few tricky ones for you to learn from)When looking for the destinations these companies ship to, most of the info can be found at the bottom of the page in "shipping" or "faq" links. Occasionally you may have to google "where does company x ship" and it will bring to you the page on their site w/ shipping info.Looking for affordable bids and a potential long term partner! If this project goes well, I have MANY more, and two that you may start this week!

    [more]
  • $45 USD 2 days ago

    Hello,I have an Excel sheet which is generating automaticaly serial Letters.I just want to add 2 new functions.Please see add excell file - the yellow marked line does not input adress correctly in word.All other funcions work alredy.Letter for Company and a sort Function.detailed description via ChatAttached is foulder with Manual and need Datas.In excel the yellow row does not work correctly.Please see word letter in folder "Files" how it should look likethxAfter this you have to input a sort function.If I add more adress I want to have a colum which sorting the selectionSelectionAll - so for all is generating lettersXYXX Street - so only this selection is shown on excel and is generating the lettersHutson street - only hutson street is shown on excel and is generating only for Hutson street the serial letters

    [more]
  • $250 USD 2 days ago

    I have a few .tif files containing spreadsheets that we need transposed into excel format. They are around 135 pages long. We need this done in a timely manner and accurately.

  • $100 USD 2 days ago

    I need a VBA for Excel program written to enable me to type in questionswith multiple-choice answers (perhaps with radio buttons). A hidden (from the user) worksheet should contain the answers.When the user presses a "Completed" button, his/her answers should be checked against the answers on the hidden sheet. Correct answers should be shown in green and incorrect onesin red.A percentage score should also be displayed.If possible, the spreadsheet should be saved and emailed to a specified (perhaps hard-coded) email address.

    [more]
  • $30 USD 2 days ago

    In Excel sheet, there is a dynamic table (Please see the attached image). I need to find what the value is for the last “Sell” in column N. Also, I need to find what the value is for the last “Buy” in column N. For example, in the attached image, the value for the last “Sell” is (-0.8). And the value for the last “Buy” is (-0.9). I need the method to be simple and use only formula or function. No VBA and No Macro. Please note that the table can reach up to 60 rows, and sometimes only one row only, and sometimes no data (empty table).

    [more]
  • $130 USD 2 days ago

    I have this vba code inside excel , its working fine in excel 2003,but in excel 2013 its hanged after 2 days only,no error messages , it supposed to work continuously few weeks.This excel file collecting data by DDE link.I need experienced coder in excel 2013.Here enclosed vba code in word file, concentrate in the last portion of calculate subroutine , from there we move to all other subroutine.This vba code is simple , its just collect data and store them and plot them for me in 54 pages.

    [more]
  • $200 CAD 2 days ago

    need a drawing to show drainage in backyard with pool and interlocking

  • $50 USD 3 days ago

    I have an small existing Excel based program that was created entirely within Excel VBA. It accepts system time/date input upon pressing a “start” button and again for a “stop” button and then calculates the interval period and records it along with other data into an Access database file. Occasionally the system time freezes within the program for some reason and while the start time is always accurate, the stop time will always be the same as the start time and the elapsed time will show zero minutes because of the freeze. There is no consistency to the problem and I cannot reproduce the failure upon demand.I have, however, discovered a work-around that I would like to incorporate into the program to effectively fix this bug. The existing “stop” button stops and records the elapsed time and proceeds to a different page to allow additional input. Upon an instance when the time freezes, if I hit “stop”, go to that page, but then hit “back” the system time immediately adjusts itself and unfreezes. I can then immediately hit the “stop” button again and now my final entries will all be with the correct times.This seems to work even if I make this stop-back-stop sequence very quickly. I want someone to change the function of the “stop” button to incorporate this sequence into its function, if possible. The new “stop” button would function as it does now, except that within ½ second or so it would go “back” and within another ½ second or so return to the “stop” page to wait for the additional input as normal.Another consideration is that the existing code is password protected and the original programmer has forgotten what the password is. The included copyright material and license agreement clearly shows ownership in my name. It would be nice if the password were removed, but not absolutely necessary.

    [more]
  • $94 USD 3 days ago

    I want an excel sheet for my personal office work... What i need?I want to have an Excel Dashboard in which several sheet are inserted, and at the end i need reconciliation statement in which i need to get Debit & Credit Balance, along with how many transactions are DEBIT, & Credit and deduct amount in consecutive preceding balance method and at the end i get the ending balance in month wise, date wise, and even quarter wiseIf any one can make it contact me... sample sheet for data is attached with the project,,, and also sample screenshot is attached what similar i want to see a dashboard

    [more]
  • $77 AUD 3 days ago

    Adapted existing excel from another costing spreadsheet.All existing formulas don"t work anymore. All details have imputed and set up, need someone to put the formulas in so each section adds up at the right place.

    [more]
  • $88 USD 3 days ago

    -Optimization of import of data - the running of the macro/vba should not be visible to the user-Update of the data reference used as the source for pivot tables-Refresh of pivot tables and data layout when importing csv-User friendly error message if cvs import is not in the expected format- automatic renaming of headers on imported data- combination of pivot filters (from 2 data sources)

    [more]
  • $111 USD 6 days ago

    I have a Excel 2013 workbook that has several sheets.I need to have the data that gets entered on 1 page transfer to another page that I use to print receipts. The reciept template has to be able to print 50+ pages with one click of a print button. Data then is transferred to a master sheet that is like a report that I want saved as pdf and emailed on a daily basis. I have outlook and a server if needed for emailing. Don"t bid if you are not able to start this today. https://www.dropbox.com/s/a38j5qj0p0zzius/Screenshot%202014-04-10%2018.02.25.pngI can explain more once hired over chat on team viewer.

    [more]
  • $155 USD 8 days ago

    Simple requirement is to have an excel with three columns one, Contact Name, second Contact Email address, third Contact TechnologiesTool should be able to do:1. Read the master sheet which has the data for all the contacts2. prepare an email addressed to individual Contact names (separate emails for each Contact), with pre-defined common template.3. Send the email from outlook, with an attachment (preferentially excel) having the information Contact name, Email address and technologies. (ONLY related to that contact where the email is being sent.4. This process needs to happen for all different contacts on the sheet (Approx 200)

    [more]
  • $30 AUD/hr 8 days ago

    I require someone who can perform linear multiple regression in excel and interpret the results. Approximately 2 hours of work.

    Tomislav Malis does not have any open projects.
    Tomislav Malis does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Project manager

Apr 2013 - Present (1 year)

Zagrebacki holding d.o.o.

Technical director

Jan 2011 - Apr 2013 (2 years)

Zagrebacki holding d.o.o. - Zagreb roads

Firm dealing roads of City of Zagreb (750+ workers)

Head of road signalling for Zagreb roads

Feb 2008 - Jan 2011 (2 years)

Zagrebacki holding d.o.o. - Zagreb roads

Firm with 130+ employees dealing with road signalling (400+ crossroads with traffic lights and vertical / horizontal static signalisation) for City of Zagreb.

maintenance engineer

May 2007 - Feb 2008 (9 months)

Zagrebacki holding d.o.o. - Zagreb roads

Head of road maintance for part of City Zagreb

Dec 2005 - May 2007 (1 year)

Zagrebacki holding d.o.o. - Zagreb roads

Project engineer for maintenance and development

Apr 2002 - Dec 2005 (3 years)

Zagrebacki holding d.o.o.

Education

mag. ing. aedif.

Sveuèilište u Zagrebu

1994-2002

Certifications

Licensed Professional Engineer certified no. 4354

Croatian Chamber of Civil Engineers