Lukket

Excel vba, macro function for Excel to turn csv to svg graphs -- 2

Hi, I've got a monthly report we do on our servers for the client.

Currently, we will capture the live feed graphs from the server for the period.

What I hope to achieve is to generate a svg graph for the year and one for each month based on the csv files saved for the year, with macros and functions so that other tables can be automated. This graphs should be placed in a Word form as a report.

You need to deliver your work in an Excel file with the functions included, then to be integrated in the Word report. You may need to explain how to use it too.

If possible, I will give you the server access to access the graphs it generates and the values. But before proposing, please check the attached files and if possible, show the sample outputs from the csv file.

my budget: usd 20

here's example code

Do Until [login to view URL] = True

[login to view URL] "SELECT * FROM m_vals WHERE deviceIndex=" & [login to view URL]("deviceIndex"), cn, , , adCmdText

Do Until [login to view URL] = True

' srchDvcIdx = "=" & [login to view URL]("deviceIndex").Value

' mtchField = [login to view URL]("deviceIndex", [login to view URL](1), 0)

'

' [login to view URL] _

' Field:=mtchField, _

' Criteria1:=srchDvcIdx, _

' Operator:=xlAnd

' Set dvcRange = [login to view URL](CLng([login to view URL]("deviceIndex").Value), LookIn:=xlValues)

' Set cht = [login to view URL]

' [login to view URL] Source:=dvcRange

' [login to view URL] = xlXYScatterLines

[login to view URL]

Loop

[login to view URL]

[login to view URL]

Loop

Evner: Dataindførsel, Databehandling, Excel, PHP, Visual Basic

Se mere: vba macro excel unicode, excel vba macro paste adjacent column, next empty cell vba macro paste, freelance jobs from home, freelance excel trainer, freelancer projects online, pay for excel help, freelance excel work hourly rate, freelance jobs, www freelancer com jobs, excel jobs from home, 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, excel vba input function, vba search function access, calling oracle procedure vba macro

Om arbejdsgiveren:
( 7 bedømmelser ) Goyang Ilsan-gu Gyeonggi-do, Korea, Republic of

Projekt ID: #24044197

9 freelancere byder i gennemsnit $23 på dette job

ravinderkumar248

Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o Flere

$20 USD in 2 dage
(25 bedømmelser)
4.6
Ladiginvladislav

Greetings! I am a Specialist in excel, business and related analysis. i can help you faithfully. I am keen to help you with the requirements. Look forward to hear from you. Thanks,

$20 USD på 1 dag
(14 bedømmelser)
4.3
mofajjelbd

Hi Mr/Ms, I am absolutely sure that I can do the project very well. I am working as worker and over past 5 years of experience. I have worked on several similar projects and can deliver quality notes to tight deadlines Flere

$14 USD in 7 dage
(14 bedømmelser)
3.2
samara1602

"""""""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I underst Flere

$60 USD in 7 dage
(2 bedømmelser)
2.6
dolapradhan0

hi. I dola pradhan. your project is completed read. i understand your project. I completed in this time.

$19 USD in 5 dage
(0 bedømmelser)
0.0
vishalpraj97232

I am not sure if you have any questions or concerns please visit the lockouts page and the other day and time for you to know if you want to do it for a couple of years sorry want wrong latter

$25 USD in 2 dage
(0 bedømmelser)
0.0
Yusuffali

I have seen your project description. After that I am able to understand that I have enough skills to do the project.

$10 USD på 1 dag
(0 bedømmelser)
0.0
sameeronee

I will write and provide many high-quality SEO BLOG, WEB CONTENT or ARTICLE WRITING for any niche, for either your BLOG POST or website with 24hrs delivery and with free revisions if needed!

$15 USD in 5 dage
(0 bedømmelser)
0.0
knupdh

Hello For svg graph it is difficult to convert in excel but i can use some tricks and tools to do that. Some online tools are there or have yo use java. Need some time to start with. Will attch sampl Relevant Skills Flere

$20 USD på 1 dag
(0 bedømmelser)
0.0