Find Jobs
Hire Freelancers

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

$10-30 AUD

완료함
게시됨 4년 이상 전

$10-30 AUD

제출할때 지불됩니다
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
프로젝트 ID: 21106975

프로젝트 정보

18 제안서
원격근무 프로젝트
활동 중 5년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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 1일에
4.9 (439 건의 리뷰)
7.5
7.5
18 이 프로젝트에 프리랜서들의 평균 입찰은 $32 AUD입니다.
사용자 아바타
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 1일에
4.9 (384 건의 리뷰)
7.0
7.0
사용자 아바타
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 1일에
5.0 (60 건의 리뷰)
5.3
5.3
사용자 아바타
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 2일에
4.8 (32 건의 리뷰)
5.0
5.0
사용자 아바타
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 3일에
5.0 (30 건의 리뷰)
4.4
4.4
사용자 아바타
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 1일에
5.0 (9 건의 리뷰)
3.6
3.6
사용자 아바타
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 1일에
5.0 (3 건의 리뷰)
2.2
2.2
사용자 아바타
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 3일에
5.0 (4 건의 리뷰)
2.0
2.0
사용자 아바타
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 1일에
5.0 (1 건의 리뷰)
0.6
0.6
사용자 아바타
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 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 7일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 2일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (AUSTRALIA)
Sydney, Australia
5.0
2
결제 수단 확인
2월 4, 2019부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.