Find Jobs
Hire Freelancers

creating/correcting array formulas to generate Ethernet switch detail charts from master Network Notes sheet

$250-750 USD

Cancelled
Posted almost 7 years ago

$250-750 USD

Paid on delivery
I have a workbook 17 sheets, but only 2 are the focus of this request. 1) Netw-T3-MCP1: This sheet contains all Ethernet related details for all networked control system hardware, including: A) What switch & port a device connects to B) IP address C) VLAN ID D) EN2T (PLC's Ethernet card) asigned E) PLC Node # 2) MCP3-Enet Sw Charts: This sheet is needed to build the Ethernet switch details charts for inclusion in the respective Ethernet switch drawing. the trick is having the charts filled with blanks for each port in any given switch that is not listed in the Netw-T3-MCP1 sheet. I can get the arry formulas to work for the 1st chart; however, only the first chart works. The details in the first chart work perfectly, but the successive charts only have the same info as the first chart rather than the actual switches details. I cannot seem to figure out how to edit the formula to stop this. I am indexing the switch numbers to match.
Project ID: 14503618

About the project

13 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

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
13 freelancers are bidding on average $365 USD for this job
User Avatar
Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Excel, formulas, vba Proposed Milestones $250 USD - Milestone I would like to discuss and work on this project.
$250 USD in 0 day
5.0 (612 reviews)
7.6
7.6
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$250 USD in 3 days
4.9 (209 reviews)
7.2
7.2
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.
$250 USD in 3 days
4.9 (219 reviews)
6.9
6.9
User Avatar
Actually it is not $250 effort (only correcting the formula involved). I can do it for $50. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 12 MONTHS , spent at least 225 HOURS on automation in Excel every month. Proposed Milestones $250 USD - Complete Planned Task
$250 USD in 1 day
5.0 (126 reviews)
6.3
6.3
User Avatar
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. Relevant Skills and Experience Excel, VBA Proposed Milestones $555 USD - k
$250 USD in 3 days
5.0 (62 reviews)
5.9
5.9
User Avatar
- Based on Netw-T3-MCP1 which has Ethernet card info, the second sheet which has (MCP3-Enet Sw Charts) the chart info details, can get the info for all the Netw-t3-MCP1. - Will get it processed using macros so that when you click the button the mapping for the respective charts for the Netw will take place. - Have worked on a similar wiring model design. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables.
$250 USD in 2 days
5.0 (37 reviews)
5.2
5.2
User Avatar
With 9 plus years of experience, I am confident that I can fulfill requirements of project very efficiently in a very reasonable time. I am looking forward to discuss with you about this project. Relevant Skills and Experience My education in Accountancy plus my work experience as shown in my profile have helped me develop excellent skills in Excel, Word, PowerPoint, PDF QuickBooks. Usman Watsapp: +923215040095 Proposed Milestones $250 USD - Project $125 is sufficient payment for this task. Lets talk.
$250 USD in 1 day
5.0 (6 reviews)
3.5
3.5
User Avatar
hey there, i am full stack developer and from what i understand you need to have some algorithm. lets discuss more details in chat. regards Relevant Skills and Experience full stack development Proposed Milestones $500 USD - project milestone
$500 USD in 10 days
5.0 (1 review)
2.0
2.0
User Avatar
I am a Cisco expert with an experience up to 12 years as a senior network engineer and as a part-time Cisco instructor,moreover I have a master degree in communication and electronics engineering. Relevant Skills and Experience I am a Cisco expert with an experience up to 12 years as a senior network engineer and as a part-time Cisco instructor,moreover I have a master degree in communication and electronics engineering. Proposed Milestones $555 USD - work fees
$555 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Though I am new here but my team has 7 years of experience into MS Excel. Can very well execute this Project
$888 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Payment method verified
Member since Jun 29, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.