Find Jobs
Hire Freelancers

Read the "How to file"

$30-250 AUD

Geschlossen
Veröffentlicht vor fast 2 Jahren

$30-250 AUD

Bezahlt bei Lieferung
Read the How to file: How to: A loop diagram is a type of schematic that shows the wiring all the way from terminals on one device through various cables and junction boxes to the terminals of another device. Typically this is some kind of field sensor/instrument to a PLC or IO card. However, it can be for anything as this is a common representation. They usually look something like this with terminal numbers in the boxes, lines between the terminals showing the wiring/cabling. Basically I’d like you to make something that takes a spreadsheet listing of lots of cabling/wiring as input and outputs a sort of end to end connection diagram (or spreadsheet) of the connections between a given pair of devices as output. I think the easiest way is probably to make this in excel using macros, but you can do it in something else if you can figure out how. I have a specific list of fibre optic connections from another project that you can use to develop this. Attached is a spreadsheet ‘fibre list’ tab of thousands of connections (filtered by ‘service’ to just show one) This list particular list is actually a list of each end (FOBOT/Port) of the fibre optic cables. Each cable has 2 ends. Then the other ‘end’ or direction of the same cable - On the right side are some linking patches (like panel wiring) that connects these ports/terminals to ports/terminals of another cable or device. The result is that with these 8 rows, the connection all the way from one device to another is represented. However, due to the repeated rows per cable, this is clearly kind of difficult to read, particularly for technicians in the field. This information can be shown as a loop diagram, which is much clearer and easier to understand and trace through. I have manually made an example in the “example” tab of how such a loop diagram of that service could look like. Here you can see how it starts at the device ASP21101A port G2, follows a patch to a port at ‘node 1’, cable to ‘node 2’, patch to ‘node 3’ etc. all the way to the Finish device ASP21103A. This full link has 4 intermediate nodes. However, some links may only have 1 or 8+. To start with I think you can assume the maximum is 8. A simplification of the above diagram format would be to keep the FOBOT & Port number together in one cell. My approach would be: 1. Create a helper sheet with lookups to trace the link through first as the rows in the full listing likely will not be in order of the link direction. (I can show you an example of this I have made something before) 2. Then use a ‘loop drawing’ template sheet with the format and formulas or macro to copy the information in. 3. Macro to export the ‘drawing’ to pdf Attached is a list of the link nodes in order. (Fibre Linked List) You can instead use this as the input and it should be much much easier. Basically you will just need a macro to step through this list, copying relevant cells to the loop drawing template, printing it as pdf, then going to the next service. You can write this to do a single one first, then to do multiple.
Projekt-ID: 34170761

Über das Projekt

12 Vorschläge
Remote Projekt
Aktiv vor 2 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
12 Freelancer bieten im Durchschnitt $124 AUD für diesen Auftrag
Avatar des Nutzers
Read the "How to file" I have read and understood all your project details and I feel my self the best candidate to complete this project with 100% accuracy. I have vast amount of experience in this industry since I am working from 2009 as a professional writer. I have huge number of client base in these 12 years. I can write Articles, Blogs, Website Content, CV, Business Plans, Books & eBooks and Product Descriptions. I provide Supreme Quality Work against very low prices even in short deadlines. You may contact me anytime so we can discuss your project in detail. Thank You.
$30 AUD in 1 Tag
4,6 (12 Bewertungen)
4,0
4,0
Avatar des Nutzers
Hello, We have been working on excel, vba, macros, finance for more than 9 years. We have more than 8 years of experience doing data based projects. I believe this is something I can for sure :) You may check the projects I have already completed here: https://www.freelancer.com/projects/excel/Excel-VBA-Data-Entry-Analysis-32285292/reviews https://www.freelancer.com/projects/excel/Data-Analytics-Project-30073140/details https://www.freelancer.com/projects/data-mining/DATA-MINING-ANALYSIS-USING-NEURAL/reviews https://www.freelancer.com/projects/excel/Hire-Excel-Expert-15193739 I would love to discuss the project further :). Best, Hem
$175 AUD in 2 Tagen
5,0 (2 Bewertungen)
3,2
3,2
Avatar des Nutzers
Respected Sir/Madam Hello, I hope you are doing well. I have gone through the description of your project and I want to help in completing your work. I have completed my PhD, Masters and Bachelors degree programs and received gold medals in them. I have completed my A & O Levels from Cambridge. TURNITIN Plagiarism Report, Perfect work as per your requirements and properly referenced work will be shared. Consider your work done as you assign me your order because I have a 100% completion ratio which is visible on my profile. I have completed more than 600 projects with 5 Stars and excellent reviews from all my awesome clients. I have been working as a freelancer for the last 8 years having great experience of working on various projects like Business plans, Financial analysis, Rewriting tasks and Technical Reports. I have used SPSS, R and Stata that are all data analysis software for research purposes. I can follow Harvard, MLA, IEEE & APA referencing styles along with Endnote according to your requirements. Hopefully, I get this opportunity to work with you as I am sure it will be a good working experience.
$30 AUD in 2 Tagen
5,0 (3 Bewertungen)
2,3
2,3
Avatar des Nutzers
Hello i am automation engineer i know siemens plc,allen bradley plc,mitsubishi and others as well i have done many projects and o know how to read file just let me discuss
$90 AUD in 7 Tagen
5,0 (2 Bewertungen)
1,0
1,0
Avatar des Nutzers
HELLO I AM AUTOMATION ENGINEER I KNOW PLC PROGRAMMING,HMI,SCADA,ROBOTIC PROGRAMING I HAVE DONE MANY PROJECTS I CAN DO YOURS TOO
$140 AUD in 7 Tagen
5,0 (1 Bewertung)
0,5
0,5
Avatar des Nutzers
Hello, this is is ABDERRAHIM and an engineer. I hev donse several plans and I understand that you need a plan to be done and calculations of the bearing done. I will deliver Calculation on the the maximum bending moment for the wooden beams. Please get in touch
$140 AUD in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi I've read the project description carefully. I'm an expert in Excel VBA. Hope you contact me to discuss project more detail. Best regards!
$100 AUD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I've read your description carefully!! I am happy to have the opportunity to help you. Perfection and punctuality are my iron rules. If you want the best result, select me! Results, not words, will prove everything!
$140 AUD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Read the "How to file" I am an academic expert who can help you with your solutions like; Case Studies, Summaries, Reports, Thesis & Dissertations, and Online Exams and Courses in almost every language. I am new to this website but I assure you that I will provide you with 100% quality work without plagiarism within your given deadline and budget. I am new here but I am familiar with this industry as I am working here since 2013. Please give me a chance and feel free :) Thank You
$30 AUD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von AUSTRALIA
Cooma, Australia
5,0
4
Zahlungsmethode verifiziert
Mitglied seit Juni 6, 2022

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.