offline
Last seen: Apr 22, 2014 8:43 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

(208 reviews)

6.5
[see more]

4 users have recommended this freelancer.

My projects:

  • $150 USD
    3.4
    Profile image for Seller malaikamkuu

    malaikamkuu

    11 days ago

    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 GBP
    5.0
    Profile image for Seller celinedion

    celinedion

    25 days ago

    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 USD
    5.0
    Profile image for Seller cbsoria

    cbsoria

    27 days ago

    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 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 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]
  • $75 USD
    5.0
    Profile image for Seller pickleparker1978

    pickleparker1978

    Mar 13, 2014

    Excellent as usual

    Project Description:As discussed
    [more]
  • $166 USD
    5.0
    Profile image for Seller aobp

    aobp

    Mar 11, 2014

    Great freelancer! Was quick to help and very knowledgeable. Will hire again for FoxPro projects!

    Project Description:We have a FoxPro 5.0 installation where we have at least three tables that gave &quot;Error 15: Not a Table&quot; errors following an unexpected power loss. i.e., the tables were open when the power failed. ...
    [more]
  • $261 USD
    5.0
    Profile image for Seller tomwarden

    tomwarden

    Mar 9, 2014

    thanks dpune, we got there in the end, thanks for all your hard work

    Project Description:basically i have uploaded all the images to my products folder in open cart, but they need assigning to the correct product, there are roughly 4000 products.
    [more]
  • $100 USD
    5.0
    Profile image for Seller mariadev

    mariadev

    Mar 3, 2014

    Great working with Dpune, thank you!

    Project Description:Hello, For this website: superblumenzwiebeln.de we need a Freelancer to create a good working Google Base feed for &#039;Google Shopping&#039;. This is preferably done in Excel but if you prefer in XML, let us know why and how...
    [more]
  • $110 USD
    5.0
    Profile image for Seller cbsoria

    cbsoria

    Feb 28, 2014

    Excellent work by dpune. Will hire again! Thank you.

    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]
    dpune has not completed any projects.
  • $250 USD In Progress

    It&quot;s a VBA/Excel project. The details are on the file.

  • $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]
  • $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.nnData 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 VWorker every evening by 2:00 AM (midnight) EST with the new data.nnTrading hours vary for different exchanges within CME. However, the settlement page is LAST updated every day according to the following schedule:nnCBOT, CME: 6:PM EDTnNYMEX, COMEX: 10:30 EDTnnDifferent commodities are traded in different exchanges:nnAgriculture:nGrains &amp; Oilseeds, Ethanol trade at CBOTnLivestock, Dairy, Forest trade at CMEnSofts (sugar, cocoa, etc. ) trade at NYMEXnnEnergy (crude oil, natural gas, etc.) trades at NYMEX. One type of ethanol trades also at NYMEX.nnMetals trade at NYMEX and COMEX.nnData entry must be done after those hours: 6:00 PM and 10:30 PM and should be ready before 12:00 AM (midnight) EST.nnnNOTE: 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.nnSee attached Word document file for complete details.

    [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]
  • $200 USD 2 days ago

    I need a spreadsheet based Betfair Webbot. It needs two main elements:1. sheet where I get a dump of all the available races and runners for a given day (Australia and New Zealand)2. sheet where I can specify which of the runners I want to bet on, how much I want to bet, back\/lay, time before race when bet must be placed, whether bet is placed irrespective of whether volume is available in the market, etc.I need this to be done with the Betfair API. It needs to be run out of Excel and I want it to be coded in VBA.

    [more]
  • $150 USD 2 days ago

    I will provide and excel with a model number. You need to find the picture by entering the ID number into a website we provide and save the image according to our specification in a folder.You will also need to enter data in excel according to the image like price and compatibility into another excel. You need to know which is brand and model number for the smart phones.So a little bit of smartphone model and brands knowledge is preferred and will make your job easier when creating excel.500-2000 product per month. This is continuous work and would like someone that can do this long term for us.

    [more]
  • £500 GBP 2 days ago

    I require an Excel Universal API Template, or a Relational Database, to use the following controls:- Connect API using HTML Get Command- Import XML and importantly JSON - using Jscript- Use of Login Credential and Token- Such as Google Analytics, You Tube, and other non Google like Shipping APII need working examples for the above, and with Template Login HTTP Command with a Login Credentials. I will be using this template to incorporate other API at a later stage.In the bidding process, can you also email me an example demonstrating your technical knowledge in Excel Programming for Data Extraction for APIs.

    [more]
  • $150 CAD 2 days ago

    We have a budgeting template that requires a macro be built so that we can capture category costs and quarterly reports run easily.

  • R1888 ZAR 2 days ago

    The P-STEM Foundation is a South African Not for Profit Organisation that promotes Science, Technology, Engineering and Mathematics in historically disadvantaged communities. On initial entry into a community and through out our engagement with the community, we survey attitudes towards maths and science. We require a data capturer to collate the data collected from all the communities over the last two years and capture into excel for upload into the Survey Database. We have about 600 survey responses with up to 15 questions each completed.

    [more]
  • $30 USD 3 days ago

    Own Interspire Shopping Cart 6.1 - Admin doesn&quot;t show the discount amount .1) When creating an new order, need the option to apply a fixed value as discount.Please see attachedEasy fix, will not take much of your time

    [more]
  • $200 USD 3 days ago

    This is a repost since the person couldn&quot;t finish. I am looking for a programmer, or someone VERY strong in Microsoft Excel, to develop a program/algorithm. This would be based on a list of words that need to be filtered and shown based on many variables. You should be confident in excel formulas. Further details will be given to potential hires. I need this done ASAP.

    [more]
  • $100 USD 3 days ago

    I have ready made excel file that extract values from website . The website just make some changes so I need to amend this file based on there changes .thank you

  • $500 AUD 3 days ago

    Hi,Please read this carefully and understand the exact requirements.I think this may need some VB expert if you’re doing this in excel?Looking for someone that has the following skill set based on the following requirements.Attached is the data and the warehouse layout in the project.I don’t mind if you do it in excel or you create software that can deliver the following requirements. 1. I would like the layout to look much better than it currently looks but needs to stay the same. 2. How many bins in total are there in the warehouse layout 3. Can you then tell me how many single bins there are. 4. Can you tell me how many 2 deep bins there are. 5. Can you tell me how many 3 deep bins there are. 6. Can you tell me how many 4 deep bins there are. 7. From the (SOH by location) tab can you tell me how many bins are being occupied by inventory? Bin location is in column (E). 8. Can you then tell me the number of bins that aren’t being occupied by inventory and which ones. 9. From the (Sku’s List volumes) tab can you show me on the warehouse layout, where by bin location the Sku’s are located as well as conditional formatting the colour of the bins based on the following volume break points below.10. Can you show many how many bins are being occupied by Business Group Name from (Inventory) Tab column H is the Business Group Name column.Please note one (1) bin location can occupy more than one Sku or one (1) sku can occupy more than 1 bin location. (There is no one sku to bin relationship).Please note the volume to stores figures in column B (Sku List volumes) tab are just made up for this exercise but when I do receive the actual numbers I want to be able to just cut and paste so the warehouse layout bins turn a certain colour based on the volume breaks. So the volumes may be less so I may need to change my range when I know the true volumes so can you make the ranges dynamic for this to happen?If you can think of better volume breaks as in less breaks please create your own range.Here is the volume break range 34,310 – 39,300 (Colour Green bins) 24,310 – 34,300 (Colour Orange Bins) 19,310 - 24,300 (Colour Yellow Bins) 14,310 - 19,300 (Colour Blue Bins) 9,310 – 14,300 (Colour Pink Bins) 4,310 - 9,300 (Colour light Purple bins) 5 - 4,300 (Colour Red Bins)All data tabs will be static for cut and paste for (SOH By location) tab and (Sku’s List Volumes) tab for when I need to update so all of this needs to be dynamic.Will also require a stunning dynamic dashboard for points 2-8 and point 10.Please note I have also provided an example of the bin types in the (Example of bin sizes) tab.If you have the skill set please applyFuture work will be available for the right candidate.In your bid please let me know what software or application you will do this in.I will then know you have read the entire brief.Thanks

    [more]
  • $500 USD 3 days ago

    This program is for pulling data from Amazon utilizing Amazon’s MWS API. The details of each part are missing from this basic description. Based on qualifications and bid price the rest of the data will be sent over upon request. Main Functionality-Import an excel, csv, or tab-delimitated file with a list of ASIN’s or UPC’s-Access Amazon’s MWS API to pull relevant data as quickly as possible. Amazon throttles request so the data needs to be uploaded to utilize the maximum speed but not be limited by Amazon’s throttle limits. The throttle limits can be found in MWS Reference Guide page 8. From looking at the requests that we will use, the amount that should be able to be processed is 36,000 UPC’s / ASIN per hour. -The outputted data needs to be able to be easily manipulated.-Part 1 of the program needs to be able to run continuously even if part 2 is being used. -Focus is to monitor Amazon’s sales rank, pricing and seller to predict future sales-Some MWS API calls give the option to specific NEW. The ONLY data wanted is for NEW products. Even if NEW/USED can not be selected on some MWS calls, if USED is returned ALWAYS ignore the data.Below is a basic of what is needed. I think the API calls are correct however if something is wrong then please let me know so that it can be corrected. If there is a better solution also please let me know.Part 1Part one of the program needs to get price, rank, quantity and who is selling. The main objective is to retrieve whom has the buy box from Amazon, what price they had it for, and what was the sales rank at when they had it. Part 2Second program needs to be able to get all data related to ASIN’s / UPCThe program needs to be able to run when wanted. When the program runs it will use the Amazon MWS API to retrieve all information on an ASIN.

    [more]
  • £400 GBP 3 days ago

    I want to build an advanced custom trading system in Excel that will keep a record of all my trading activity, calculate my gains and profits, display the information through a variety of advanced summaries and compile my tax return reports.Due to the complex nature of trading products and Australian tax law, you will essentially need to recreate an entire trading platform (excluding order placement) and all its functionality in Excel.This will require extremely advanced knowledge of VBA.YOU MUST READ THE ATTACHED SPECIFICATION DOCUMENT BEFORE BIDDINGWe’ll need to spend about a week full-time creating the specifications. Project will take about 6 weeks full-time.The key modules are:Multiple Funds and Strategies Support-Everything below cater for as many trading funds as I choose to open – so trades, dividends and capital must be allocated to trading funds and summaries must report performance by fund-Same applies for classifying trades and dividends by strategyTrading Log-Allow for entry of all trades I carry out via userforms. The trading log must support stock trades, forex trades, option contracts and futures contracts-Most complex part of system, requiring advanced calculations and VBA-It must calculate approximately 80 performance metrics-Trade Realisation Engine will allow me to graphically select trades to realise other trades against and calculate realised gains-Option Execution Engine must fully execute options and acquire the physical underlying stock-Option Offsetting Engine: when option contracts are bought or sold, if existing opposite option contracts are held with the same multiplier, strike price and expiry date these contracts should offset each other as the liability/privilege bought has been sold.-Futures Offsetting Engine: Similar to the Options Offsetting Engine, the futures offsetting engine must offset buy future contracts against sell future contracts whenever a future is added and the opposite position already exists-Futures Expiry Engine must scan daily for expiring futures. If a future expires then unrealised gains must be translated into realised gains.Dividend Manager-This will keep a record of all dividend payments received.-It must automatically calculate my franking credit, US withholding tax and Australian Foreign Tax credit as applicableMonthly Data-This must allow me to specify monthly costs/income that can’t be associated with trades or dividends.Capital Manager-This must provide a record of all capital transferred into and out of each trading fund, and allow this capital to be exchanged between currencies, tracking my total capital holdings in each currency-It must track the value of all trades, dividends, option premium bought/sold and monthly costs/income in order to update my capital position as appropriate-It must track family loans to each fund, and how much capital each fund owes to the familySymbol Summary-This will show my total position, gains and profitablility for each symbol (e.g. 1 symbol per row)-It must be able to show data for specific funds or all funds, specific strategies or all strategies and specific dates-As new symbols are traded they must be automatically added to this table-It must calculate approximately 110 performance metricsFund Summary-Similar to the above this shows the same data but each row is a currency, showing aggregated performance metrics for all symbols in that currencyTax Summary -This will produce tax reports including full quarterly P&L over 70 years for accounting purposes.Notional Conversion to AUD for Tax Purposes-The tax summary must take into account Australian tax rules. -If realised gains for that financial year have been left in foreign currencies, then at June 30 they must be notionally converted back to AUD for tax purposes.-System must produce a tax P&L according to this notional conversion.-This will be very complex.

    [more]
  • $200 USD 4 days ago

    I need a VBA for Excel program written to enable me to type in questionswith multiple-choice answers (perhaps with radio buttons). A hidden (from the user) worksheet should contain the answers.When the user presses a &quot;Completed&quot; button, his/her answers should be checked against the answers on the hidden sheet. Correct answers should be shown in green and incorrect onesin red.A percentage score should also be displayed.If possible, the spreadsheet should be saved and emailed to a specified (perhaps hard-coded) email address.

    [more]
  • $250 USD 4 days ago

    Re-Format and Convert database into various datafeed format which will be ready to for upload

  • €100 EUR 4 days ago

    Actually i have a CSV file with 7000 items. I need to put them on ebay through Turbo Lister 2. So you have just to format that CSV for to be used in Turbo Lister 2In attach the file that i haveI will give you the template to be used for every itemsVery simple. Need to be familiar with turbo lister 2 and with ebay.Thanks.

    [more]
  • $200 USD 4 days ago

    PLEASE READ DESCRIPTION BEFORE APPLYING OR YOU WILL BE IGNORED AND REPORTED!I have a wordpress site, and excel sheet with 22,000 products.. Some columns are in the wrong space, some data is in the wrong field etc.. I need a VIRTUAL ASSISTANT to organize the excel sheet the right way, upload the spread sheet piece by piece to WOOCOMMERCE via WOOCOMMERCE CSV IMPORT SUITE .. Have everything come out the right way on the website and fill by store with the 22,000 products.

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

    Hello, we have few macros to develop around 25, in this month, and we are looking for a freelancer or few freelancers who can develop macros, we now have 5 macros to start with, even you are new freelancer with macro skills you can bid, thanksNote : place bids per hourly as at the moment we can give exact work to handle, thanks

    [more]
  • $30 USD 5 days ago

    Hello,I have an Excel sheet which is generating automaticaly serial Letters.I just want to add 2 new functions.Please see add excell file - the yellow marked line does not input adress correctly in word.All other funcions work alredy.Letter for Company and a sort Function.detailed description via ChatAttached is foulder with Manual and need Datas.In excel the yellow row does not work correctly.Please see word letter in folder &quot;Files&quot; how it should look likethxAfter this you have to input a sort function.If I add more adress I want to have a colum which sorting the selectionSelectionAll - so for all is generating lettersXYXX Street - so only this selection is shown on excel and is generating the lettersHutson street - only hutson street is shown on excel and is generating only for Hutson street the serial letters

    [more]
  • $600 USD 5 days ago

    I have a few .tif files containing spreadsheets that we need transposed into excel format. They are around 135 pages long. We need this done in a timely manner and accurately.

  • $600 USD 5 days ago

    We have a current ecommerce store in Drupal using UberCart, which is located here ( http://www.luxewinecellars.com/ ) we need all the content in the ecommerce store moved to a Shopify or BigCommerce store. You need to move over all the products in the the shopping cart and all the text/images.We also need the design moved over to the Shopify or BigCommerce store, the design doesn&quot;t need to be 100% the same but the template needs to be a nice high-end design open to your ideas.Please Post/PM With Past Shopify or BigCommerce Websites You&quot;ve Developed!

    [more]
  • $700 AUD 5 days ago

    We intend to scrape product data from a printer toner/ink website. For every product on the website we will create one SKU in our Magento Ecommerce store and import the associated data that has been scraped. The scraped data needs to be cleaned and modified to ensure it meets our Magento Ecommerce store data standards. We will use four CSV files to import the data.This tasks require that you scrape the data, clean and modify the data to meet our data standards, create four CSV files for import and import the data to our non-production Magento store.Navigation Structure:The website we want scrape is organised into this navigation structure:Brand > Category > Models > ProductsBrand Page:There are 16 brand categories currently for the following brands:BrandCanonDellEpsonHPKonica MinoltaKyoceraLanierLexmarkOKIPanasonicRicohSamsungSharpToshibaXeroxWithin each brand are one or more of the following categories:Ink CartridgesToner CartridgesThermal RollsCategory Page:Within each category page is a list of printer models.Models Page:Within each model page is a list of products that are for use with that printer model broken into product segments such as below:Compatible Brand Toner Value PackGenuine Brand Toner Value PackCompatible Brand TonerGenuine Brand TonerCompatible Brand Image DrumsGenuine Brand Image DrumsProduct Page:The final product page has the data that we intend to scrape. Each product page has a unique URL. The same product page will be linked from multiple printer model pages as one product is normally compatible with multiple printers.We need four CSV files created with the data that is scraped. The four CSV files we need created are:1) models.csv2) parts.csv3) product_type.csv4) products.csvFor each unique product URL we will create one product SKU in our Magento Ecommerce store. This is products.csv and product_type.csv.For each printer part/model we will cross reference the product SKU(s) that are compatible. For example, these parts/models:SKU1: PartY, ModelZSKU2: PartYSKU3: ModelZ… we will cross reference in our database like:PartY: SKU1, SKU2ModelZ: SKU1, SKU3This is parts.csv and models.csv*** Images need to be downloaded and will be referenced in the products.csv import file for import to our Magento Ecommerce store ***The scraped data needs to be cleaned and modified to ensure it meets our Magento Ecommerce store data standards.Once complete each CSV file is to be imported to our non-production Magento Ecommerce store.Existing ProductsOur Magento Ecommerce store currently has products from the website we intend to scrape. We will provide a list of product URLs (The unique product URLs from the website that is being scraped) that you do not need to import. After scraping the data from the website you can remove the product URLs that we provide so the same data is not imported twice.Data Cleaning and ModificationAn example of data cleaning and modification is:“HP LaserJet 1000” would be imported to our Magento Ecommerce store as “HP”,”LaserJet”,”1000”:The brand and series are both placed into their own separate column. Again, by looking at our existing store data you can clearly see that Laserjet is a series of HP and should be placed into a separate column.The product attribute “3,500 pages at 5% coverage” would be imported to our Magento Ecommerce store as “Approx. 3,500 pages at 5% coverage”:By looking at our existing attributes you can see that we use “Approx.” in our data.Important:It is your responsibility to test each file using our non-production Magento Ecommerce store to ensure all data is able to import successfully.

    [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