Programación > VBA
I need an application that will parse data from e-mails within Outlook and update data in an Excel spreadsheet. There are three different e-mail types that must be processed. 1. Purchases2. Sales3. PaymentsStep 1: PurchasesI receive email receipts for items I purchase to resell. The data from these receipts includes a description of the item, location, quantity, cost, date, and so on. The application must parse these e-mails and write the data to an Excel spreadsheet. Purchase e-mails may come from 3 different sources with similar formatting in plain text. Step 2: SalesI receive email receipts for sales. I will manually add an order number to the rows for items sold in step 1. The application must parse data such as quantity, sales price, sales date, order number and so on. from the sales receipt, match on the order number and write the sales information to the item created in step 1. Sales e-mails come from 1 source in two slightly different formats in HTML. Step 3. PaymentsI also receive email receipts for payments. The payment date, amount, and order number must be parsed from the payment receipts. The data must again be joined by order number and the payment data must be added to the original item records. Payment e-mails come from 1 source in plain text. Additional Requirements: ~Platform: Windows 7 Home Premium, Outlook 2010, Excel 2010~E-mails will be moved manually to a folder for processing, then removed manually once processing is complete~There must be some type of error catching for e-mails that fail to process. This can be done by flagging successfully processed/not processed e-mails or generating an error log listing e-mails that could not be processed~I must be able to select what spreadsheet to update when the processing tool is launched~See attachment for spreadsheet columns and descriptionsOther: This is starter project and I would like to build a relationship with a reliable contractor for future projects. I expect future projects to include accepting and processing e-mails from new vendors and/or new e-mail formats.
Publicado el samedi 19º de mayo a las 3:43am
Hello, I am a financial analyst at a PE firm, and lately I have had the need to automate a lot of reports, simply to make my job easier. Which has caused me to begin coding (VBA/SQL). However, I am still learning and am running into a lot of issues. My first issue isn't very complex, but if I can contact a person whom I can work with on a frequent basis, there is a lot of work here in the future. I wrote a short code to pull information and put it into a pivot table format. However, I now need to include either parameters in my code which tells for example which dates to pull the information for. There is a lot of data, and we can't fit thousands of days of data in one pivot table. It won't make sense to the user. So if we had a parameter for dates, then the user could specify, " I want to see data for weeks 4 through 9 "... and so on. That is one parameter, I would like to add two to three. The other option is, if parameters are too hard, then I could also add Slicers. This is a feature with excel 2010. It works just like report filter, and I am starting to prefer the use of slicers the more I use them. And the final thing I would like to do is to print out report filters. All of this will make a lot more sense, once you see the file I am working with. As mentioned, I have already done a majority of the work, I just need help with the parameters. I don't know where to insert them; in the pivot cache or the destination. Please be an expert level VBA/SQL coder. I think of myself as advanced and if I am having trouble, then you need to really know your stuff. If we can develop a relationship, as mentioned I have a lot more reports and procedures which need to be automated through VBA and SQL. Thanks. P. S. We can speak on Skype.
Publicado el martes 15º de mayo a las 6:25pm
We are in need of a person who is skilled in programming Excel, including the following areas: 1) Visual basic (VBA) programming of Excel. 2) Sending emails automatically from Excel, using Outlook. 3) V look-up. 4) User forms. 5) andldquo; Smartandrdquo; drop-downs, which provide options based on specific criteria, and are filled dynamically. You must be able to understand the project needs, and respond in a creative way, helping us to get the best use out of Excel, to create a system that is reliable, easy to use, and simple to produce. Great communication skills are a must! Complete project specifications will be sent after initial interview and discussion of prices. Flat rate pricing is preferred for the whole project. But please provide a preliminary project fee based on 25 hours of work. Please also include your availabilityandmdash; when you can begin, and how long you expect it would take you to complete.
Publicado el lunes 14º de mayo a las 8:57pm
I am looking to build an Excel spreadsheet to track marketing spend and monetization of my web-application. andnbsp; andnbsp; andnbsp; andnbsp; I should be able to visualize conversion funnels by any segmentandnbsp; andnbsp; andnbsp; andnbsp; I should be able to see virality (R-factor) by any segmentandnbsp; andnbsp; andnbsp; andnbsp; I should be able to see LTV by any segment, with the ability to include implicit R-factor in LTV or notandnbsp; andnbsp; andnbsp; andnbsp; I should be able to see immediate revenue per user, on a 1-day, 7-day, 30-day, 45-day, 90-day, and lifetime value... by any segmentandnbsp; andnbsp; andnbsp; andnbsp; The marketing channels I use are: andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Searchandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Paid google - segment per keywordandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Paid Bing - segment per keywordandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Organic Bingandnbsp; andnbsp; - segment per keywordandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Organic Google - segment per keywordandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; StumbleUponandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Freeandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Low Cost - segment by demoandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Normal Cost - segment by demoandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; High Cost - segment by demoandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Facebookandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Segment by demoandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Redditandnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; segment by demoandnbsp; andnbsp; andnbsp; andnbsp; The monetization channel I use: andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; Right now I only use AdSense. andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; andnbsp; I am happy to create custom AdSense channels if appropriate, to help spreadsheet tracking With respect to segments - " segment " includes ALL traffic from a specific source, as well as checkbox-style mix and match. I should be able to see Cost of Home Page View, Cost of Checkout Page Conversion, and Cost of Acquiring a Customer - by any segment. I should also see retention rates by any marketing segment. I am happy to add in separate google anlaytics or mixpanel code to help achieve these tracking goals.
Publicado el sábado 13º de mayo a las 10:49pm
PRODUCTION PLANNER PHASE I. If done well will lead to you doing phase II and IIIOpen attached Access Database: PROJECT SCOPE: FRONT PAGE: EMPLOYEE LOGIN SECTIONForms: 1. EmployeeActivityFunctionality: Employees come to work. Employee Login screen opens (they will not need to see all other options like inventory, and so on) ---- scan an Activity barcode, it chooses the Activity, then they scan their badge barcode and it logs them in for the day. Your tasks: -andnbsp; andnbsp; After successful log in the employee needs to get a message showing their total hours for the week, day, month by Activity. It needs to be easy to read quickly and refresh after a few seconds so other employees can login. - This can be a Graph showing the Planned hours Vs Actual or a quick view of hours- Management Reports showing Hours by week, month, year (Graphs and well presentable) - I need an area to enter employee details and classifications. Employees can be fulltime, Volunteer, Part Time, Casual, or Seasonal. Each employee will have planned hours per week. Example 40hrs for fulltimeandnbsp; andnbsp; - Entry of Employee Notes from management this should pop up when the employee scans for an activity to notify them that they have a message from management, they read and acknowledge reading, comment and update. The system saves time read. - A place for us to put when an employee will be out on vacation. We need to be able to record it in the system so when planning production we donandrsquo; t have to plan for that employee- They can request time off with the Application- Employees need to show planned Hours Vs Actual/Day and Per Week. We have 5 working days standard so if employee is 40hours then thatandrsquo; s 8hours a day. - Management can view all logs and know how long each employee has been working, on break or out for lunch, and so on- Time and date need to be stored for calculations-andnbsp; andnbsp; current forms has errors please resolve errors to let employees know if they have signed in successfully or if they need to scan again
Publicado el jueves 10º de mayo a las 10:42pm
