offline
Last seen: Jul 25, 2014 12:39 AM EDT
Hire Me!
Rate: $10.00 USD/hour
Follow Invite to Project
 

dpune

Top 1% Worker from at Freelancer

Username: dpune

  • Has not made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has not verified their secure phone number.
  • Verified
  • Payment is not verified.

Location: Pune, India

Member since: February 2010

Reputation:

5.0/5

(213 reviews)

6.6
[see more]

4 users have recommended this freelancer.

My projects:

  • $110.00 USD
    5.0
    Profile image for Seller cbsoria

    cbsoria

    26 days ago

    Excellent work!

    Project Description:The project consists in inputting commodities end of day data (daily settlements - Final) into a Google Documents spreadsheet. Data entry must be done EVERY DAY from Monday to Friday for a list of 46 commodities futures traded at the CME Group website cmegroup.com...
    [more]
  • $110.00 USD
    5.0
    Profile image for Seller cbsoria

    cbsoria

    May 27, 2014

    Excellent work as always!

    Project Description:The project consists in inputting commodities end of day data (daily settlements - Final) into a Google Documents spreadsheet. Data entry must be done EVERY DAY from Monday to Friday for a list of 46 commodities...
    [more]
  • $250.00 USD
    5.0
    Profile image for Seller Berdemli

    Berdemli

    Apr 29, 2014

    Great freelancer.

    Project Description:It's a VBA/Excel project. The details are on the file.
    [more]
  • $110.00 USD
    5.0
    Profile image for Seller cbsoria

    cbsoria

    Apr 28, 2014

    Excellent work, once again!

    Project Description:The project consists in inputting commodities end of day data (daily settlements - Final) into a Google Documents spreadsheet. Data entry must be done EVERY DAY from Monday to Friday for a list of 46 commodities...
    [more]
  • $5.52 USD
    5.0
    Profile image for Seller rjcnz7

    rjcnz7

    Apr 22, 2014

    Good Fast Work.<br/>

    Project Description:We are looking for a flexible skilled virtual assistant to help us with our new eCommerce store and inventory setup. We are creating 2 new Shopify stores and will be managing products in stitchlabs...
    [more]
  • $150.00 USD
    3.4
    Profile image for Seller malaikamkuu

    malaikamkuu

    Apr 12, 2014

    delivered the project

    Project Description:I want an application that: 1. Will restart itself when windows restarts (so a windows service application) 2. It should have a dashboard where I can add URLs 3. I should be able to set a time interval that this URL should run 4...
    [more]
  • £75.00 GBP
    5.0
    Profile image for Seller celinedion

    celinedion

    Mar 29, 2014

    Thanks very much...looking forward to using the sheet....to get my money back...all the best..

    Project Description:I have a Master excel sheet of racing results with 83 different sets of ratings.....what I would like is a results sheet linked to the Master sheet....to show me profit/loss for each rating.....being able...
    [more]
  • $110.00 USD
    5.0
    Profile image for Seller cbsoria

    cbsoria

    Mar 27, 2014

    Excellent work. Will hire dpune again!

    Project Description:The project consists in inputting commodities end of day data (daily settlements - Final) into a Google Documents spreadsheet. Data entry must be done EVERY DAY from Monday to Friday for a list of 46 commodities...
    [more]
  • $50.00 USD
    5.0
    Profile image for Seller victorcab

    victorcab

    Mar 19, 2014

    Worked hard to deliver project with some changes along the way in the project dpune worked to complete.

    Project Description:Update existing timesheet report processing Excel code that uses data from csv file and create reports for each name in the report. Source includes 15-20 columns of data, not all columns will be used...
    [more]
  • $25.00 USD
    1.8
    Profile image for Seller CS01

    CS01

    Mar 16, 2014

    Freelancer didn&rsquo;t read the project description properly, can only solve examples, no generalization of results by generic approaches. Intense communication, but no usable results. Waste of time+money.<br/>Freelancer didn’t read the project description properly, can only solve examples, no generalization of results by generic approaches. Intense communication, but no usable results. Waste of time+money

    Project Description:The table is as follows: There are various classes of drugs (see the numbers: 2, 3, 4, 5, ...). Inside each class, there are drug names (e.g. Priftin, Xifaxan, ... each in bold letters). And there are companies selling these drugs (e.g...
    [more]
    dpune has not completed any projects.
  • $110 USD In Progress

    The project consists in inputting commodities end of day data (daily settlements - Final) into a Google Documents spreadsheet. Data entry must be done EVERY DAY from Monday to Friday for a list of 46 commodities futures traded at the CME Group website cmegroup.com. Data should be entered by the end of each trading day: Monday-Friday after commodities markets close for all commodities. File containing data should be sent thru freelancer every evening by 2:00 AM (midnight) EST with the new data Trading hours vary for different exchanges within CME. However, the settlement page is LAST updated every day according to the following schedule: CBOT, CME: 6:PM EDT NYMEX, COMEX: 10:30 EDTnnDifferent commodities are traded in different exchanges: Agriculture: Grains &amp; Oilseeds, Ethanol trade at CBOT Livestock, Dairy, Forest trade at CME Softs (sugar, cocoa, etc. ) trade at NYMEX Energy (crude oil, natural gas, etc.) trades at NYMEX. One type of ethanol trades also at NYMEX Metals trade at NYMEX and COMEX Data entry must be done after those hours: 6:00 PM and 10:30 PM and should be ready before 12:00 AM (midnight) EST. NOTE: Due to CME Group regulations and the license they gave us, data is not to be scraped by means of scripts or programs. It MUST be manually entered. See attached Word document file for complete details.

    [more]
  • $750 USD In Progress

    We need a new dashboard created from raw excel data. The dashboard will be a combination of charts, pivot tables, graphs. We need someone who can come up with interesting ways to break out the information, and have it intuitive enough to know if things are trending up or down within seconds of viewing it. They also need to be able to organize it efficiently and intuitively. The source of this information is a text or csv file on our server. In production, the file will always be less than 5 minutes old. We want to utilize the excel data connection to automatically query our server, pull in the latest information, and update the graphs, pivot tables and charts that you create. Background. We are a software provider for &quot;3rd party logistics&quot; companies. These companies buy and sell space on trucks, planes, trains. they charge the customer and pay the carrier. They employ salespeople who get commissions, they have multiple offices and like to know what offices are profitable. The average customer might have 20,000 transactions a month. Some much smaller, some much bigger. The most important thing we want to do is we want to track revenue from invoices to customers, we want to track the expense and profit on those invoices. This is the key to the project, people want to know if they are making or losing money. We will want this broken down by customer, carrier, salesrep, dispatcher, office, revenue type, mode, and equipment type. All of these are existing columns in the spreadsheet. The information that we want to display is all contained in the spreadsheet.Here are the ways we would like to be able to see the data:Pick a customer – show their sales in a graphTop customers to a graphCompare trends from Top customers - top accounts trending across the screen on a month by month basisRevenue comparison by month/year - # of shipments (transactions)$ per shipment graphsProfit % per shipment graphsMost profitable customersBest lanes (example: between NJ & CA)Profit margin graphs – watch the margin going up or down over timeRevenue by shipment type - Revenue by officeRevenue by salesrepProjected revenue vs expenseHere is a link to the text. I will add a guide to have which columns have the key information.http://www.aljex.com/links/3240ak2349akksadlf59n9234234nz329234923ZZ4.txt

    [more]
  • $8 USD/hr In Progress

    I learned that because my product contain variations (size and type) the Ebay Prostores that runs my regular website cannot automatically feed my products to Google merchant, so it has to be uploaded manually, so I need someone to take the CSV file of products from my Prostores and convert it to the acceptable Google merchant format. Can you do this for me?Thank You, Brenda

    [more]
  • $7 USD/hr In Progress

    We are looking for a flexible skilled virtual assistant to help us with our new eCommerce store and inventory setup.We are creating 2 new Shopify stores and will be managing products in stitchlabs. We need someone to help us set up our products in stitchlabs and then load these in shopify.This initial trial job is for 10 hours work, but if successful there will be much more work and likely full time. Please bid an hourly rate for 10 hours and this will also be the rate we would pay for future work. The initial task will be to export all the current products out of the current website and import these into stitchlabs and then export these into the shopify store. You must be skilled at working with data and working out how to export and import the data into different systems.We also want someone who can help modify shopify templates and help manage the shopify stores.This is a great opportunity to work with a grwoing Australian Company.

    [more]
  • $55 USD In Progress

    I need an excel macro script written to automatically change the format of one .csv to what it should look like in the other .csvI have a daily product list sent with over 55,000 lines of items. It needs to be converted to the correct Shopify format.You should bid if you are: - Familiar with Shopify - Familiar with Macros - Can complete this in one day.You must look at the file that says &quot;Products Incorrect.csv&quot; and match the Column&quot;s from &quot;Products Incorrect.csv&quot; to the Columns stated in &quot;Products Correct.csv&quot;Only bid if you understand what I am talking about.Thank you very much!

    [more]
  • $10 USD/hr In Progress

    I have ongoing work related to our previous project &quot;search data from google scholar&quot;

  • [Sealed] In Progress

    I need a spreadsheet cleaned up and developed to allow daily listing of transactions with relevant costing; weekly and monthly summaries of all relevant data entered, and the ability to provide an annual data analysis. The daily entries are (Australian) air cargo agency acceptance based - not extensive (20 -50 only at this time, maximum perhaps 100 in near future - with lookup tables for each client and their relevant rates; weight x cost calculations; plus fees and associated charges.The basic spreadsheet has been drafted and is in test mode, but i need refinement to ensure it is error free and able to be expanded upon as required.It also needs macros to sort data when new clients, markets, and rates are added; and changes in surcharges and/or tax levels.This spreadsheet is the basis for tracking their agency revenue streams; and the basis for one (major) part of their overall income stream.The final part of the project, is for a separate file be provided as an Access data base application with all the features of the spreadsheet.The draft file will be provided for 3 bidders for their thoughts and final bids.A work period of about 4-5 hours has been calculated for this project.

    [more]
  • $150 CAD Yesterday

    My drop ship distributors provide me with an excel price list, need to convert it into eBay Excel file for turbo Lister 2, and ability to update the QTY ie QTY is 0, end the item on eBay, if QTY is higher than specified amount re list or post it on eBay.As well ability to update the price list for all listings in excel file prior being imported into Turbo Lister 2, which would include eBay Fee, Paypal Fee etc.Looking for someone who is familiar with eBay Turbo Lister 2To sum it up, Excel File from Distributor with information, convert it into eBay Turbo Lister 2 Excel, and than ready to be uploaded into eBay.Please post question concerns as well any additional features you might think off.I have included Sample File from the Distrubtor

    [more]
  • $100 USD 3 days ago

    I have designed a spreadsheet to predict odds in soccer game. However, I need help on the programming code to automate and build in flexibility and in particular:1) Can gather data from different leagues result from the web2) Can build in flexibility to use either &quot;home&quot; &quot;away&quot; &quot;all&quot; data to perform calculation (the current spreadsheet build in to use all data)3) Can backtest profitability using the historical odds 4) Can download the odds from a specific bookie and prompt for value bet.

    [more]
  • $250 USD 6 days ago

    This is the project. Please read carefully.I will supply a website in prestashop. I will upload 3460 products with descriptions, prices, and reference codes. I will create 7 main categories and 80 Subcategories in Prestashop. The products are already sorted by main category.You need to add image to each product and also choose a SUB category from a list. You will know the subcategory from a pdf catalog, where are products are featured with category and image.Half the images can be recovered from websites on the internet. The other half needs to be cut from pdf catalog.

    [more]
  • kr8000 SEK 6 days ago

    Hi,I have customer data that is updated every month with both new data of existing customers and new customer data. I would like to have these data structured in 5 different reports with two different version of each (corporate customers and consumer customers), so in total 10 reports. I will use the reports my self when you have built these and add new data each new month and possible to edit the formulas. Attached you will find my data and the reports that I wish to have created in excel.If you are interested or not, please answer me and give both a time estimate and price.Don&quot;t hesitate to ask if anything is unclear. I have had to freelancers who haven&quot;t succeed so now I&quot;m raising the price and hope you can give me an time deadline that you can promise to hold.RegardsMagnus

    [more]
  • $30 USD 6 days ago

    Hi,I want to create an excel sheet that has project management features (I have the template) but also want dashboard and also few other sorting feature including Vlookup formula to extract data.This is not that complex work and anyone with intermediate excel skills along with the VBA skills should be able to do this task.Please do not send bids without attaching your sample work from the past projects.

    [more]
  • $55 USD 6 days ago

    Hello,I have a project. I have 2 excel files. One has a column that says pictures the other one does not. I want to move or copy the data that&quot;s in the picture field to the one with out by matching the product number field. If you can do this let me know.

    [more]
  • £250 GBP 10 days ago

    hi.I am looking for someone to upload data for our products to a b2b website.you will be given all the data , product name, titles, images, prices sku codes. You need o upload them to a b2b website, but due to the nature of the project the work has be to done manually and cannot be done by CSV upload methodyou need to match the products from the excel file we provide to the categories and specifications of the B2B website.some samples of the field required to be configured for each product are shown in the pictures attached. Please note some product types will have different individual parameters to enter, but the layout and type of data to be entered will remain the same.Work is urgent so emphasis will be made to bids with competitive pricing and good completion time only.thank you

    [more]
  • $30 USD 10 days ago

    I have an excel workbook that I use to process payroll. I need to be able to enter information on the first page that will determine what will show up on corresponding pages. Such as different pay frequency and different state taxes. I have attached an example.

    [more]
  • $500 USD 10 days ago

    Hello, I have lots of images that need to be converted to excel. I will provide you a sample, and you must ready to start soon, new freelancers are welcomed

  • £600 GBP 10 days ago

    A code written into Excel to automatically match nearest events to people. The spreadsheet needs to be set up such that as more people and event info comes in, it could be copied and pasted onto this spreadsheet for immediate matching.

    [more]
  • $20 USD/hr 10 days ago

    I have an excel workbook that I will add information in daily. The workbook contains 5 sheets, 3 of which are data input, the last two are what I want to be created. I need one to be a report format, where it provides me a list of names from sheets 1-3, and will generate data based on what name is selected. The second report page is just each one of the columns presented as a graph over time.

    [more]
  • $750 USD 10 days ago

    I have an excel file with 3000 product that need to be updated on a Prestashop store. Also I have psd files that need to be converted to jpg of those products.Please post your bid and time.

  • $8 AUD/hr 10 days ago

    Dear, we have the need for data entry into a number of software including excel to maintain product list and pricing list. This will include converting invoiced of suppliers into excel or enter them into a simple accounting software. We also need to enter products on ebay. We will have work weekly

    [more]
  • $30 USD 10 days ago

    I have 2-3 Excel files with contacts, email addresses, and names. Some email adresses are bunched into one column. I need them to be cleaned up and put into their own cell.

  • $100 USD 12 days ago

    I have a spreadsheet program that needs a little macro work (attached). It would be pretty easy to look it over and then read the rest of this. The purpose of the spreadsheet is that a user will be limited to selecting only 4 fruits or vegetables out of a total of about 20 in the list and they must stay under the amount of money they have available (say $100.00). The purpose is for them to maximize their point totals. Here is what I need accomplished with this spreadsheet: 1. There are columns off to the right with different currency data in them (columns S, T, U). Depending on which currency the user selects in a drop-down box (Dollars, Euro, GBP), I would like those currency figures to appear in column C. 2. The formulas in cells C5 and C7 currently work off of 1&quot;s or 0&quot;s in column F. I would like these to work off of check-boxes in column F instead. 3. Most importantly, I would like the user to select which ranking method they would like applied, (either Rank A, Rank B, Rank C or manual). Ranks A, B and C are located off to the right in columns P,Q and R. If they select either Rank A, Rank B, or Rank C I would like this data supplied to column A and have Colums A, B and C sorted in ascending order on Column A. I realize that the columns off to the right (O through U) would need to sort as well to keep the data from getting all jumbled. 4. If they select manual, I would like a pop-up listbox to appear (I&quot;m open to other methods)and allow them to manually rank the fruits and vegetables. Here again, when they are finished I would like their ranking to appear in Column A and have all the right descriptions and currency figures appear in columns B and C as well. This data set would also be sorted in ascending order on column A. This is all that I need accomplished on this spreadsheet. ## Deliverables1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## PlatformWindows (excel spreadsheet)

    [more]
  • $500 USD 12 days ago

    I request an excel spreadsheet template for real estate investment scenarios. I want the spreadsheet to work the following for me PER PROPERTY PURCHASED:Amortization of loans up to 80 years length, with monthly breakdown of principal and interest components (user will set purchase price and interest rate on borrowed finance)LVR - This is the Loan to Value Ration. For example, if a property is purchased for $100,000 and the loan is $70,000 then the LVR is 70%. I would like the spreadsheet to identify principal and interest repayments on the loan amount only, not the full purchase price of the propertyPayback period for capital improvements (spreadsheet user will provide amounts paid for capital improvements at any given time during the 50 year investment period)Outgoings and multiple cost fluctuations and Rental income fluctuations ie allowance for increase or decrease in (set by user)Land tax rates (usually set for the life of the investment - set by user)Calculation of purchase costs (user will provide percentage, please make allowance for up to 10 different purchase costs which user will enter)Comparison of investment against market yield. Example: typically residential real estate returns 4% per annum, but one investment scenario set by the user only returns 3.8%. (user sets market yield. Market yield should be set to change on a yearly basis set by the user throughout the 80 year period)A final net figure per annum and also at the end of the 80 years (or earlier as set by the user), be it a loss or income. This final figure should end at 80 years or prior to that as set by the user and should calculate NPV should the user choose to run a scenario where the investment is sold in any given month in any year prior or up until the 80th year.THE SPREADSHEET MUST THEN REPLICATE THIS FOR UP TO 100 PURCHASED PROPERTIES. The purpose is to identify how well scenario would run with the user inputting a scenario where an investor buys more investments at any month in any year up until the 80th year.Additionally, the spreadsheet should take into account the development of each of the 100 properties, individually. For example, property number 27 is developed in year 18 and 6 months to now have 20 units built on the land instead of 3 houses. Development costs set by the user can be input as well as additional funding expenses such as interest. This should take into account capital income, ie sale of each newly built unit, or rental income, and how it performs against the development&quot;s ongoing costs and pre existing funding as well as typical market yield. (user sets upfront costs and expected interest rate over the life of the development project for that property. FOR THIS PARTICULAR ISSUE TO BE RESOLVED I CAN PROVIDE YOU WITH A SPREADSHEET OF AN INDIVIDUAL SCENARIO AND HOW IT WORKS. REMEMBER, THIS PARTICULAR FEATURE OF THE SPREADSHEET MUST RUN IN ACCORDANCE WITH MY REQUIREMENTS AS LISTED. Finally, I would like the spreadsheet to provide a summary in easy to understand figures as well as via graphs. All the information that the scenario produces should be provided graphically as well. The spreadsheet must do this per property, as well as a summary for all properties purchased. THE SUCCESSFUL CANDIDATE FOR THIS JOBYou should have excellent English skills and a thorough understanding of finance and real estate investment and development. I will provide you with further details on how I expect the end result, but for the most part, you will need to complete this project with little input from me.THE DESIRED OUTCOME OF THIS PROJECTA complete tool which provides me with a way to develop analysis on scenarios for real estate investment opportunities. I should be able to determine, when, and how much to invest at any time and when to sell and in the case of developed properties, how much to sell before the break even point is reached.

    [more]
  • $500 USD 13 days ago

    I need content from a online store placed into a csv file and an image folder

  • $100 USD 13 days ago

    Hello,I am looking for someone to create a macro for me.I have a source file with raw data and a template file that serves as the destination file. The source file is filled with data while the destination template file only has column headers.The source file has column headers which are similar but not exact to the template file. The headers vary in their order and in their existence for both source and template files. That is to say some files have a few columns while others are more comprehensive. As of now, there is a manual copy and pasting of the source file into the template file as such: If a column header in the source matches a column header in the destination template, the data from the rows in that source column are pasted into the destination template.If a column header in the source does not exist in the destination template, a new column is created.Matches are not exact, so Date of Birth could appear as Birth Date or D.o.b, for instance, in the source file but still need to be placed into the Date of Birth column of the destination template file.I would like the macro to scale so that it works on any new source and template combination.If any clarification is needed please ask.

    [more]
  • $10 USD/hr 13 days ago

    Hi,job details:1. go to ebay.com2. click on the ADVANCE button, right next to the Blue SEARCH button on the top right.3. choose &quot;business and industrial&quot; category4. mark BUY IT NOW5. mark condition: NEW6. mark &quot;Multiple item listings from&quot;: 5 to (blank)7. mark &quot;Only show items:&quot; Available to&quot; IRELAND8. click the SEARCH button9. in search results click on the &quot;Construction&quot; (sub-category on the left side)I need 100 Good products links.definition for a GOOD product link:1. the seller must be a TOP RATED seller (have a yellow top rated seller icon)2. inside the product page clicked on the number of sold items (right next to the product Quantity) then you will see all the sold items of this product.if the product has 2 sales or more in the last 2 weeks it is a good product.then all you need to do is to copy 2 things to an excel file:a. the product linkb. ebay item number (you can find it on the right side at the beginning of the DESCRIPTION tab, which is the defulte tab, right under the main image section).thats it, 100 links it is an easy job, supposed to take 1-2 hours.if all be good it might be an every day job, I need it on every category and sub category in ebay.if you have any questions please dont hesitate to askbest regards

    [more]
  • $35 USD 13 days ago

    I need to manipulate Excel data from Sheet-A to Sheet-B as per attached 2 sheets. There are two types of fields: (1) Fixed &quot;as is&quot; data and (2) data to be manipulated from Sheet-A to Sheet-B. You will use Sheet-A to create Sheet-B.I need a simple and short Windows application program to manipulate this data within 2 days.

    [more]
    dpune does not have any open projects.
    dpune does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Freelancer

Jan 2006 - Present (8 years)

NA

Freelancer : Excel, VBA, Data Entry, Application Programming

Education

Master of English

University of Lucknow

1994-1997

Certifications

NA

NA

NA

Publications

NA

NA

NA