a macro or formula(s) in XLS to output based upon interrogating whether in IP address comes a list of subnets

$10-30 AUD

Completed

Posted

over 4 years ago

$10-30 AUD

Paid on delivery

We have an excel data file that logs data from internet traffic connections. For each log item we record the source IP, the destination IP and how much traffic was sent & received. Our output log is excel format. We need to sum total the external traffic (sent plus received) We define external traffic as where both source and destination IP's do not belong to internal subnets. We have a list of 5 subnets that comprise internal traffic. Our internal subnets are in the format xxx.xxx.xxx.0/8 Attached is a small file of test data. To show what it looks like. The actual file is large (millions of log entries). The internal subnets (test examples) are on a separate worksheet. we need a forumla or macro that will easily integrate each log entry (line) and sum the total traffic of all lines if both the source and destination IP's are not on internal subnets

Excel

Project ID: 21106975

About the project

18 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@SBITServices

Dear Employer , I have checked the attached file and read your project description. I can write Macro to generate the External traffic report. I have 5 years experience in Excel VBA programming and completed 400+ [login to view URL] my reviews to confirm my work quality With Regards, Sai

$50 AUD in 1 day

4.9

(439 reviews)

7.5

18 freelancers are bidding on average $32 AUD for this job

@TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$60 AUD in 1 day

4.9

(384 reviews)

7.0

@indrapandu

Hi, VBA is the most suitable way to summarize the external traffic since you have millions of data. I have extensive knowldedge and skills in VBA, and will deliver this project completed on time and with the best quality. Let's have a chat for more detailed discussion. I can give you the sample the work for your convenient before awarding. Looking forward to hearing from you.

$29 AUD in 1 day

5.0

(60 reviews)

5.3

@writingapp

Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

$20 AUD in 2 days

4.8

(32 reviews)

5.0

@jsb1156

Experienced project professional, MBA, EXCEL and MS Project expert; strong estimating background, experienced with complex formulas, MACROS, LOOKUPS, PIVOTS, and charts towards the delivery financial analytics. I currently work remotely and provide part-time support EXCEL GOT-IT PRO, an on-line service to assist students and small business owners with advanced EXCEL challenges. I am sure I can provide you with a quality EXCEL solution for your external traffic requirements.

$25 AUD in 3 days

5.0

(30 reviews)

4.4

@gpnr2017

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using my expertise in excel macro and vba code writting. I have Over 12 years of experience in software development and support. On technical front I have good experience .net technologies, c#, Winforms, WPF, ASP .net MVC, MS SQL Server, MS Access, Excel VBA. I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards, Naveen Upadhyay

$20 AUD in 1 day

5.0

(9 reviews)

3.6

@zszabo

Dear Customer, Already done the vba which do the sum for you. Please message me to be able to send you the excel file. All the best ! Zoltan

$20 AUD in 1 day

5.0

(3 reviews)

2.2

@Prompty

Hi, i had a look at your sample data and your project description. A macro can be written and that can be run on your log file. Ple revert

$30 AUD in 3 days

5.0

(4 reviews)

2.0

@amerfpv

Hi, I've worked more than 10 year with different excel challenges including similar projects and can do what you require here in short time. Amer

$20 AUD in 1 day

5.0

(1 review)

0.6

@jpatelsoft

Hi, I have experience on similar projects in excel or programming the same for fast processing depending on what you need/have as far as infrastructure is concerned. We can discuss further on chat to determine the modalities. Let me know. Regards, Jiger

$25 AUD in 7 days

0.0

(0 reviews)

0.0

@hamidshafqat

Respected Sir, I have read your project description and I am Interested in doing your Project. I have 6 years of experience working in MS Excel, MS word, Web search and Typing Jobs. Please give me a chance I'll never disappointing you. Hope we can work on this project. Thank you so much

$20 AUD in 7 days

0.0

(0 reviews)

0.0

@dpdmerlynt3

I can provide you best of the quality work in the desired time. I have the knowledge to use the technology, software and tools to complete this work.

$20 AUD in 7 days

0.0

(0 reviews)

0.0

@anarasimulu

I have extensive experience in programming and writing macros in excel. Worked in the financial industry for years automating logs and updating of data files. Always Striving for quality and meeting tight timelines.

$25 AUD in 2 days