Cancelled

GOOGLE SPREADSHEET (S) Commission Auto Calculator - Auto Update to Master Sheet

So as of right now we have a basic Excel spreadsheet with all of our agents having separate sheets to track their hours worked, how many sales they made, and any bonus given. We are growing from 50 to 150+ sales reps.

We need an Excel spreadsheet to subtract the 30% from the 100% $2.00 commission per sale in a column that regularly updates. The 30% is paid at the end of the contracted period and needs to auto-calculate and update a sum total per person, weekly.

We need hours auto-calculate $10.00 per hour for a sum total per week. We need the sum total of hours and 70% commission to be summarized per weekly pay period.

We have Sale's Leaders that on their sheets they need a bonus amount paid after x amount of sales are made. We need that bonus auto-calculate and auto-update to the master sheet.

Then we need all bonus money auto-calculate and update at a sum per person.

We need the Excel file to auto-calculate the splits and totals and summarize and update each individual's information into a master sheet.

The master sheet needs a column per agent total for spiffs and what the organization is spending on spiffs, then auto-calculate the sum total on the master sheet.

This way we can keep the sheets confidential when sharing with the agent, and have an master sheet for management to work with.

Upon review this will likely require Active X programming which is beyond our scope of knowledge.

Total of 150+ agents and 17 possible columns on the master sheet that need to be programmed to automatically transfer to from the individual agent sheets.

We plan to be using Google Spreadsheets - the version online for Excel - and we will give employee's access to their one sheet to update. This will auto-calculate and auto-update to the master sheet.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, PHP, Visual Basic

Näytä lisää: embedded google spreadsheet calculator, google spreadsheet sheet, php update google spreadsheet, google sheets refresh script, google sheets auto refresh, import web data into google spreadsheet, auto update google spreadsheet, google spreadsheet refresh data, google spreadsheet chart auto update, google sheets refresh formulas, auto update google spreadsheet from excel, update google spreadsheet asp, google spreadsheet ebay calculator, google spreadsheet online calculator, using google spreadsheet calculator, import sheet google spreadsheet, google spreadsheet import sheet, update google spreadsheet php, google finance google spreadsheet, google spreadsheet data entry

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #16290671

21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

whitehorsetechn

Greeting, I have understood your GOOGLE SPREADSHEET (S) Commission Auto Calculator - Auto Update to Master Sheet task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more th Lisää

$250 USD 3 päivässä
(16 arvostelua)
4.8
kirstarg

Hello! How are you? We have a few works like this. You can see my profile or see the links I have wrote above this, first if from my company. I can show you my works and talk about everything. My priority is get good Lisää

$250 USD 5 päivässä
(16 arvostelua)
4.9
$150 USD 2 päivässä
(21 arvostelua)
4.7
swajantalukdar

Yeah, I already automate lots of excel. I've checked your descriptions that you have 150+ sales rep. No worry about that. I can make an excel sheet for you to automate the whole process you want. Let's discuss Lisää

$150 USD 1 päivässä
(21 arvostelua)
4.2
abhilashrana01

Hello dear, I hope this proposal find you well, I saw your job posting online, I would like to request you please have a look into my previous works. I am a full-time freelancer with over 5 years of vast experience i Lisää

$30 USD 3 päivässä
(16 arvostelua)
3.4
$100 USD 3 päivässä
(12 arvostelua)
3.2
Denishpatel96

Hey there, Greetings! I can make Google sheet that can be auto populated whenever employees enter their hours and bonus also gets calculated. All these data will be recorded in master sheet as well. Basically, I am a Lisää

$300 USD 2 päivässä
(4 arvostelua)
2.9
hanlan

Hey, I'm interested in your project. Please send me a message so that we can discuss more about the project. Best Regards.

$250 USD 4 päivässä
(2 arvostelua)
2.3
alfacoderr

Hi, I have studied the materials you supplied and know I have a better understanding what needs to be done to accomplish your goals. I have already completed a lot of similar projects in the past. I would be deligh Lisää

$31 USD 3 päivässä
(0 arvostelua)
0.0
kishu0079

Please let me know whether you have given this project to anyone or not? If not , Then I can do this for you. I have strong knowledge in Google spreadsheet and I have powerful API knowledge . If you want your proj Lisää

$100 USD 3 päivässä
(0 arvostelua)
0.0
$155 USD 3 päivässä
(0 arvostelua)
0.0
lherreraz

I have a large experience working with advanced excel and Macros using VB, the most important thing is that I can do the job, quickly and well done

$111 USD 10 päivässä
(0 arvostelua)
0.0
$100 USD 3 päivässä
(0 arvostelua)
0.0
ranjanKm

I'm currently working at e-commerce Relevant Skills and Experience I have 2 years experience in this field

$155 USD 3 päivässä
(0 arvostelua)
0.0
tausy

A proposal has not yet been provided

$200 USD 8 päivässä
(0 arvostelua)
0.0
dullindia101

A proposal has not yet been provided

$155 USD 3 päivässä
(0 arvostelua)
0.0
shwetha02d

We are a team of two, who provide various online services such as analysis/interpretation of data, data entry services, Word/Excel/Adobe (PDF) related jobs, online operations etc.. Our foremost priority being Clien Lisää

$155 USD 3 päivässä
(0 arvostelua)
0.0
$250 USD 10 päivässä
(0 arvostelua)
0.0
Bihat

Work 3 Relevant Skills and Experience I can do for you bestt

$155 USD 3 päivässä
(0 arvostelua)
0.0
kk1909

• A competent professional with 10 + years of experience in: ~ Product Management ~ Business Analysis ~ MIS Reporting ~ Request Fulfilment Management ~ Customer Relationship Management ~Vendor Manageme Lisää

$264 USD 3 päivässä
(0 arvostelua)
0.0