Find Jobs
Hire Freelancers

GOOGLE SHEETS EXPERT NEEDED FOR FORECASTING -- 4

$30-250 AUD

Dibatalkan
Disiarkan hampir 4 tahun yang lalu

$30-250 AUD

Dibayar semasa penghantaran
GOOGLE SHEETS EXPERT NEEDED - this is the sheet that you will be working on[login to view URL] - this is the sheet format i prefer to have, similar design.. where the main page shows all the figures entered from the other pages [login to view URL] 1. Input of daily sales, dynamic and static income needs a better way of inputting and displaying back to me in google sheets. 2. Use forecasting / projections on google sheets to forecast future sales. - You can use my historical data of our sales from past 36 months.. - forecast via your model with our weekly sales from past 36 months - Put the data onto a new google sheet in a easy to read format showing predicted sales vs actual Using the methods below for forecasting: How to forecast - [login to view URL] - [login to view URL] 3. These are the 7 sheets from the spreadsheet above 1. Sales 2. Sales charts 3. Sales target 4. Sales projections 5. Monthly profit 6. Expense input 7. Drop down Let me explain what each sheets does 1. Sales: this is where I enter daily sales each day we process orders which is usually Sunday to Thursday each week, I enter the daily sales in column L. Column M, O, S, U, R are this shipping costs. You can see the formulas when you click the cells to further clarify. 2. Sales charts: This is all the information entered into ‘Sales’ sheet which shows on graphs with some drop boxes from column Z > BM. There is drop boxes to shows differences between each period selected ie 2019 vs 2020 1. Sales target: sales needed today, this week or this month to be the same as last period last year. Theres a drop box here to get specific days 3. Sales projections: shows sales till todays date, same period last year and then the % difference between both periods. The projection chart using the same growth rate to predict into the future. Its meant to show the projection which it does but the actual and % doesnt seem to work correctly anymore. 4. Montly profit: Shows expenses entered in sheet called ‘Expense input’ minus off the sales calculation in sheet called ‘sales’ from column AG(sales profit). It has a option to manually adjust or use the info from the sheet entered exactly. Its give some small stats like total expenses each month, profit, avg $ order (calculates incorrectly) 5. Expenses input: These are the other expenses we pay from our bank account each month, week or year. Theres a drop down box to adjust for mth, week or yearly. As mentioned in point 4, this is the totals showing in Monthly profit sheet. 6. Drop down: I dont know how this works, I think its a lookup sheet that a previous freelancer did Improvements to be made Overall way data is entered. I have preset data on ‘sales’ sheets and other data on ‘expense input’ sheet There should one one sheet for input of expenses, another sheet for sales (could be a dashboard type), projection sheets, and sales chart sheet (could be another dashboard showing all charts we currently use, average order, average items per order. The charts page is ok but its messy because all the data is showing on the left side. Expenses sheet, I need to get the google financial working On the sales sheet I need to get 2 extra columns included On chart sheet, the charts need to display easier, better with more details from the sales charts page Projections needs to project forecasts - Before we begin its important to note my financial year is 1st July to 30th June each year for correct calculations
ID Projek: 25089867

Tentang projek

13 cadangan
Projek jarak jauh
Aktif 4 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Hi, I have expertise in this domain. Client's satisfaction is my first priority and believe in long term service. Please communicate to discuss in details.
$100 AUD dalam 7 hari
5.0 (47 ulasan)
6.4
6.4
13 pekerja bebas membida secara purata $156 AUD untuk pekerjaan ini
Avatar Pengguna
Hello, Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thank you, Asad
$250 AUD dalam 7 hari
5.0 (379 ulasan)
7.4
7.4
Avatar Pengguna
Hi there, I would like to accept your project. I'm Samol. I have acquired specialized skills including data entry admin, social media marketing, data scraping, lead generation, and virtual assistants. I have been working for five years in this sector. I always try to give good benefits to all of mine clients with unlimited revision. ✅Data Entry. ◾ Excel, Word, google sheet, Access, Powerpoint & Excel VBA. ◾ Trending Product List, import & upload on your Shopify/woo-commerce website. ◾ Quickbook Accounting. ◾ Data PDF/Scanned/Web/Audio/Video /Image to Excel/ Word/PDF conversation. ◾ Fillable Pdf & Pdf editing. ✅Social Media ◾ All Social Media platfrm like,retweet, follow, comment, shere, subcriber etc. ✅Data scrapping. ◾ Website, Linkedin, Twitter, Instagram, Google, Maps ✅Lead generation. ◾ Google Search, Contact Number, Email, Profile link & Address Collecting. ✅Virtual Assistant. ◾ Job search, Application fill out & Lead generation. ◾ Social media manager. ◾ Email sending & reply. Mostly, I'm Available as your requirements time.
$100 AUD dalam 5 hari
4.6 (8 ulasan)
3.6
3.6
Avatar Pengguna
I would like to help in your project, I have strong expertise in Excel, Google Sheet and other technologies tools, I will be waiting for your comments. Regards, Cristian
$200 AUD dalam 7 hari
5.0 (1 ulasan)
2.1
2.1
Avatar Pengguna
Hi I am interested in doing this job. I have ability and experience to complete this job in time and with accuracy. Hope you will consider my proposal
$50 AUD dalam 2 hari
5.0 (2 ulasan)
0.9
0.9
Avatar Pengguna
Hi sir/mam I am interested to help you for you project. i'm good in data entry and have good knowledge excel. I am good in typing having 50 wpm approx of speed.
$140 AUD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi there, I have read your job description and as a highly skilled data entry expert with excel skills, I am interested in this role, as my experience aligns well with the qualifications & experience you are seeking. On the behalf of my experience, I am certain that I would make a valuable addition to your project. I am adept in empathizing and Communicating with Customers. In addition to my experience and personal qualities, I have a solid educational foundation. I am available up to 40 hours a week and also available in weekends if required. I am extremely enthusiastic and passionate about my work and always keen to make perfections in my work until and beyond the customer satisfaction. If you think my skills and experience are a good fit for your project, please let me know and I’ll be available to discuss it with you! Regards, Awais
$100 AUD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi there! I have read the project requirements and understand them very well. I am a full time freelancer specializing in all types of MS Excel and MS Word tasks. Fast,reliable and cost effective service. I am dedicated, self motivated, extremely organized and detail oriented.
$30 AUD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am an expert in MS-Excel. Can give you desired work with perfection and within timeline. Suggestions welcome at any stage.
$220 AUD dalam 4 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hello, Thank you for your job posting. I am an expert in google sheets using google apps script. I have rich experience in google apps script. So I can do your project. I wanna discuss about your project correctly. If you are interested in, kindly let me know. I will wait for your reply. Thank you, best regards.
$500 AUD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hello dear client . I have read your praposal. I have 3 year experience on Google sheets. I provide you good acuressy work with timely. kindly discuss me on the project details.
$167 AUD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hello Sir, I read your job details carefully and I understand that you need google sheet and Microsoft excel expert I’m very much confident to reach your expectations and give you 100% satisfaction and quality work. I'm a professional data entry expert who has well experience in this field of 2+ years. I have expertise in data extraction, data mining, lead generation, web scraping. There will be no delay in my work; I can do it for you as per your requirement. and would be happy to set up a convenient time to discuss this project. I am deeply interested in your project and also I'm ready to start.
$30 AUD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hello, I am Camilo, a graduate of Industrial Engineering, and well experienced in data processing. I've studied in an intensive english school so i have no problem speaking or writting in english. When you give me this project I assure you, I will give you 10 / 10 of your work. I have read and understood what you need, so I am ready for your project. I have being working with excel since college so dealing with excel work is not a problem for me.
$140 AUD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera THAILAND
Bangkok, Thailand
5.0
14
Kaedah pembayaran disahkan
Ahli sejak Sep 12, 2018

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.