Suoritettu

Need an Excel VBA application to process monitoring data.

I work for a small Land Surveying firm and we have lots of monitoring projects which generate a lot of data. As of right now we manually insert the data into an excel spreadsheet This is a time-consuming process. We would line an Excel application (written in VBA) that will import our data as a text file and fill in the proper values. I am including a blank report as well as a report that has already been filled out for reference.

When we start a monitoring project we will go to the site and place targets on soldier beams (1 to 300+ targets). We then measure these targets with an X, Y, and Z coordinate. These beams are typically located around the perimeter of a new building, are sequentially numbered, and are drilled deep into the ground While the basement of the building is excavated we monitor the beams each week for horizontal (in and out) and vertical (up and down) movement. We use an AutoCAD application to insert the coordinate points and generate a station report. The station report is a text file that contains a station number (length from pile#1), left or right offset, and cut or fill. This data is then inserted into excel.

What we need is to have the text file imported into excel with a file open dialog. There should be a checkbox to indicate this is an initial monitoring in which case the file will need to be processed differently. The stations must be matched to the correct pile numbers (the stations will be ± 1 foot). The data must be inserted into the correct columns. Any piles that do not have Data will be correctly labeled as “N/A”. Any stations that are repeated more than once will be “NEW BASE”. If the checkbox was checked that indicated an initial monitoring then all piles will be “BASE” and the correlation between station numbers and pile numbers will need to be established. Measurements will also need to be averaged from week to week. Any numbers that are outside of a specified tolerance will need to be flagged (preferably with a differing cell color). When don the document will need to be saved as a PDF file.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: process model in excel, excel macro commands, vba guide, system simulation in excel, chemical process simulation excel, simquick process simulation with excel solutions, hysys customization guide, manufacturing process excel, data tracking excel vba application, excel vba code download historical data yahoo, excel vba create process message, excel vba macro copy columns data, excel vba download yahoo financial data, excel vba application, convert excel vba application

Tietoa työnantajasta:
( 1 arvostelu ) United States

Projektin tunnus: #16920708

Myönnetty käyttäjälle:

chriskerpini

Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. The prog Lisää

$250 USD 5 päivässä
(83 Arvostelua)
6.7

44 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

jaylancer43

Hello Sir, Thank you for this opportunity. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/article Lisää

$277 USD 3 päivässä
(578 arvostelua)
8.2
schoudhary1553

Hello, I can help with you in your project Need an Excel VBA application to process monitoring data. . I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Ap Lisää

$250 USD 5 päivässä
(248 arvostelua)
7.5
SBITServices

Hello , Importing data from text file into excel is not a complex task.I have checked attached files and read your project description and understood your requirement. I have 5 years experience in Excel Lisää

$80 USD 2 päivässä
(347 arvostelua)
7.3
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Lisää

$188 USD 10 päivässä
(64 arvostelua)
7.1
P0L

Hello, I’m an Excel expert and I have worked on many similar projects. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.

$200 USD 2 päivässä
(260 arvostelua)
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$200 USD 3 päivässä
(199 arvostelua)
6.8
dgled

Hi, I’ve read your proposal regarding Data Entry and VBA. I am highly qualified for this project and can show you a sample of a similar project in Microsoft Excel which enables you to manage databases in spreadsheets. Lisää

$300 USD 10 päivässä
(50 arvostelua)
6.3
SShtv

I have a large and successful hands-on experience in processing and analyzing data in Excel. I have a successful experience in doing such work. As an example, I bring screenshots of one of the programs. https://drive Lisää

$150 USD 3 päivässä
(55 arvostelua)
5.5
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Lisää

$194 USD 5 päivässä
(58 arvostelua)
5.6
salih0vicx

Hello, I am surprised you are typing these values manually. It is easy to have typos...plus time consuming as you said. I have done numerous automation involving VBA (mainly Excel, Outlook and Access but also Po Lisää

$220 USD 7 päivässä
(14 arvostelua)
5.0
nwss1986

Hello there, Can I know the format of the text file to be imported? If you can attach a copy of the text file format, it will be helpful. I am well versed in VBA and can do your job with perfection and in time. Please Lisää

$130 USD 1 päivässä
(69 arvostelua)
5.1
archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair, pinnacle and tenni Lisää

$200 USD 10 päivässä
(36 arvostelua)
5.2
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can dev Lisää

$100 USD 3 päivässä
(34 arvostelua)
4.6
Madaky01

Hello, i build before similar apps. My product will be an exe file that manipulate both your txt and Excel accordingly. I can develop a demo version for testing and if you like we call close the deal and award the proj Lisää

$150 USD 3 päivässä
(20 arvostelua)
4.3
NewlyEDU

One of my previous projects is similar to this project I use AUTOCAD's VBA to extract AUTOCAD graphics point information directly into excel I have retained one of its videos: [login to view URL] Lisää

$150 USD 15 päivässä
(2 arvostelua)
4.4
Developer000

I am here freelancer first to discuss the details of Excel VBA application to process monitoring data then i can sure about my price and the deadline. My way of working is not only to complete but also to provide e Lisää

$150 USD 10 päivässä
(12 arvostelua)
4.5
$111 USD 10 päivässä
(33 arvostelua)
4.5
supergana

Hi - I am an IT professional with 2 decades of experience. I have 2 patents in US. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can handle simple e Lisää

$167 USD 10 päivässä
(16 arvostelua)
4.0
sloker18

I have reviewed your attached workbook carefully, I think what you are asking seems really achievable, while I would love to take a look at the original text data file as well for some more context. If you are interest Lisää

$180 USD 3 päivässä
(22 arvostelua)
4.0
imteyazkhan85

Hi there, You project sounds interesting to me. And i really wanna try this out. I will give my full effort at minimum cost. I have understood your requirement. Lets have chat for more details.

$55 USD 10 päivässä
(22 arvostelua)
4.0