...will be able to assist me with creating a VBA excel add in that I am able to push data from an excel to a google spreadsheet and vice versa pull data from an google spreadsheet back to excel. I want to have my colleagues be able to update through excel and if I am on the go make changes through google sheets and sync. I know that macros won'...
1. Convert Project to a theme/child theme. Need to have proper WP theme-ing skills. Developers need to have a portfolio to showcase. There will be other pages in the future e.g. user registration pages, a detail view for charts. 2. Integrate charting from excel sheets, replicate the chart in the design as a add-on with data from integrated database
Looking for a quick and efficient data entry specialist to carry data from a Facebook profile to Google Sheet. Data includes date, content, interactions (like &comments), engagement ranking, post type, topic.
...our warehouse on a google sheet with item information and quantity on hand. Just under 400 different items total at the moment. I want to create 'incoming' and 'outgoing' sheets to fill out that will add or subtract to the master list and save as a separate file as a record. For example. IN001 on 5/23/2018 shows the 10 different items that were added
We have a inventory google sheet that we manually put in and subtract inventory from. We need an automated way to subtract inventory when it is taken out. A script or form would be ideal. Perhaps a separate tab where additions and subtractions are made and then they reflect the change on the inventory tab.
I have numerous API extractions that need to be implemented within Google sheets, I'd like to work object oriented by setting up small targets and working in sprints. I need the work to be organised neatly and explained in detail. I am looking for a fair rate and flexibility to add new tasks and milestones along the way. My intention is to issue the
I need you to fill in a spreadsheet with data. we have 100 to 120 pages.
...records. Currently we are tracking records on multiple excel sheets (~8), very inconvenient, would like to consolidate all these excels into a single Access database. The database must be able to enter/update records and generate necessary reports (basically to reproduce reports similar to our excel sheets). We have already started on creating the database
Aim of the project is to convert raw data files to a special taxonmy so that the excel file can be used to update and extend a product database. There is no knowledge needed about the products in detail. Some information is already available in the provided raw data sheets, other information needs to be extracted from the manufacturer websites.
I need a automatically updated Excel spreadsheet. I want it to take the days ASX (Australian Stock Exchange) top Gainers Losers Data from [login to view URL] or reliable website for each day from now onwards. I need the current price at close of market and % change, then I need the next day % change and the day after that % change. Essentially I want
I'm a social scientist in need of some help with making my data look good. It concerns qualitative data which lends itself for visualization: networks, lists, categories, hierarchies. I will provide the data in Excel sheets, but the maps and charts have to look better than those I can make with the program. I'm looking for someone who can do sunburst
Hello I want to be able to put an address in google sheets, then I press a button and the link for google earth or google maps shows up, but the sattelite view please. not the regular view.
Are you a google sheets whiz? Great at creating awesome graphs & charts? Well I need your help! I have a number of 29 past cryptocurrency ICO projects that I need the ROI data over time. I have projects in a list with links to their project page. I need someone to look up the each projects initial ICO price in USD & ETH (Ethereum) and compare that
Hello, I have a Google Sheet Spreadsheet that i use to quote some sales. I have two sales people i need it to share it with, but I dont want to share all the details. I want you to create a new document based on the original document that the sales person can open in their phone , drop in 3-4 values, obtain the quote results and they cant see how my formulas work. I need the formulas to stay on ...
I have some 20 PDFs (pieces of music - typically 3 pages each / typically 2-3 staves) that I need to be converted into Sib files. I have currently huge problems with my Photoscore Ultimate and no chance to get it solved quickly. That"s why I can't do it by myself and need somebody to help me with that step. Should not be more work than 1 max. hour
...to gather all kind of data available on the internet about the Future in every topic it involves(health, demography, economics, blockchain, smart cities, new technologies, etc.) : numbers, articles, open source data, projections, reports... We would need you to organize all that information by themes and topics in Excel sheets, in order to access it
I am working on Indian Stock market Portfolio. Attached an excel sheet which is the portfolio. sheets BHAVCOPY, BLOOMBERGDATA and BHAVCOPY NSA are downloaded from websites to update daily basis. I am pulling those data to MASTER DATA sheet. I want to do the entire project using POWER BI Reports needed as follows 1. Report to show, latest price close
I need someone that can make google sheets gather information from 4 other websites and return it back to me. It would be like how excel can gather information via VBA but with google sheets. I also need some forms made that will trigger other actions from other people in my team
I have a excel sheet to calculate bank interest based on amount of loan and repayment information. Please check the attached file for more details. File description: The file has 4 sheets: Loan VCB, Loan info, Repay info, Interest info. 1. Loan VCB: is overall information of Loan status 2. Loan info: basically get data from Loan VCB sheet 3
...am looking for a expert who knows how to integrate with google sheet to mysql, so any updates are made on google sheet needs to post on mysql and from mysql we need to read data on a user interface dashboard which is this - [login to view URL] its a free php and mysql dashboard, so the main thing is if we have 100 rows and
I need a simple CRM for customer followup. Right now I have a Google Sheets Document with customer name, customer phone number, customer email, notes on what motorcycle the customer is interested in and what day to followup with that customer. I'd like the customer email as a link integrated with my Gmail, the customer followup date appear in my Google
We are looking for a research assistant to create custom spreadsheets in Google Sheets. Our goal is to find businesses across the United States that are in need of new websites. We are looking for serious website leads only, so this research assistant must be able to identify warm leads and organize them in a provided google spreadsheet. We primarily
Project 1 - monthly scrape Scape#1 public database (no login required) with set search fields to store in google sheet rows. Prefer to use Google docs if you can. Extract Customer Data #1 into a separate worksheet - Scrape only 4 fields from each customer record - (1) owner name, (2) their address, (3) representative name, & (4) brand (word or logo
I have data that I pull from our website each month and need help making this into a report. I want to take that data in this Google doc linked below and have that in a report that lets me pull in Year over Year data by month. See Attached Image. [login to view URL]
...doing project proposal of EE to be financed Funcionalities: -Register the previous users -REgister equipment from providers -Register projects of EE that can involve the previous projects: this means inputs such as investment, energy prices, other data that would help to calculate the energy savings and the economics behind. -Register data from
...Task and Project Manager but easy to use. Like [login to view URL] but easier and that can integrate with various online apps, like calendars. --An email concentration on a Web Platform so can there can be the historial of the email conversation. --Modules like: Bank Accounts, Check Notes, Complex and simple Reports with graphs, Property Data Base , Client
Hi Folks, i need script which will read data from XLS Google Sheet file, crawl web data and save results to another file.
I need user data which is dynamic to move from backend of website to google sheets in Team Drive of Gsuite. You will probably need to use Google Sheets Api for this or service account. You will use the best approach you can think of. The data will move from Zapier (integration app) to an email marketing software. Using Zapier doesn't require coding
Need to import urls from a series of webpages. All the webpages are structured in the same way. I'm having trouble writing the xpath for the importXML. You need to view the page source and determine what the xpath is. Please begin proposals with the word "green" to demonstrate that you've read this brief. Thanks.
Our current script needs to be corrected real quick. Most of the code has been written and need a quick fix. Overview: We have a script that will connect to Twitter API (authentication provided by client) but need corrections, and retrieve tweets for a user via URL defined in spreadsheet. Scope: - Create a trigger with a button, menu item or cell change that will execute the remote API call to...
...sample: [login to view URL] I would like a custom sidebar to add to this and similar sheets, with two core functions: 1) I enter a part number into a text field, and a newvalue into another text field, and push enter. The sidebar populates the leftmost-unfilled-column
Using web scraping, data mining, and genre-based research, as well as lists of Hype Machine indexed blogs; we need to construct a list of the contact information of writers & contributors for music & visual arts blogs related to our niche. We need names of blogs that have proximity to similar audiences. We'd like to use this list to secure blog coverage
...that wants to transition to 3D instead of doing photography. So, we need to create many 3D models of furniture pieces. Sofas, chairs, etc.. We can provide the product spec sheets and a snapshot of the product. 3D models should be realistic, so natural imperfections and organic shapes are preferred. In terms of volume, we are looking at 600 to
I require an API to be built between Dear Systems and Google Sheets. I will only need to get information from Dear. There will be no pasting of data back into Dear. At this stage the I only need to sales data, for example quote dates and amounts. Please send me a quote and outline how you will achieve the integration and how I can use it.
Based on a sample set of data (provided later,) I'd like a pivot table or query form that pulls out information like Average Order Value by sales channel and time period, Lifetime Order Value ranked by customer (unique email address = unique customer,) sales channel and time period and Average Lifetime Order Value by sales channel and time period.
In 2008 I found what seemed an unreported bug in excel 2007 In those days I was still using office 2003, I switched to excel 2007 and I found that when I opened a file created in excel 2003 I lost 2 worksheets (default 2 and 3 sheets) and in the file just remained the worksheet numbered as sheet 1; first I panic searched in google but couldn’t find
Project Objectives: – Review specifications of a 2 pumps and specification sheets of individual components and write one specification sheet for each design. In total, 2 specification sheets. Expertise Required: – Technical Writing – Materials Engineering – Proper English (US) Grammer Updated Inputs: – CAD files (web viewable) &ndash...