Profit Spreadsheet 2
Required skills: Programming, MS Access, mSQL, SQL
I need a spreadsheet that I cannot alter except for defined fields for input actions only.
1) I will begin by inputting the revenue from a job, then the spreadsheet needs to subtract the "job expenses" of that job which will produce result 1A. The revenue will begin with labor, which will be a gross amount, so I will input the gross amount, then the program needs to calculate the government sales tax (GST) from that gross amount which will be preset to 5% but must be easy to change if necessary. Then the next revenue I input will be materials, and the calculator will calculate the 2 taxes, which is 5% again, and an additional 7% for Provincial Sales Tax (PST). This net amount will be result 1B.
2) Then, a number of "business expenses" will be subtracted from result 1B, which will produce result 2, the "bonus fund"
Some of these expenses are fixed and some fluctuate and I need the ability to add or delete expenses.
3) Then I need another sheet that tracks employees including myself, our rate, how many hours each of us worked in a calendar month, and the gross amount we were paid. Hours for all employees will then be totaled & then a result will be produced to provide a percentage of hours worked by each employee. So if I have 3 employees, and we worked 1000 hours in total for January, and I worked 413 hours, then I need the spreadsheet to provide the percentage, which in this case would be 41.3%... and then to provide the percentages for the other employees as well.
I need the ability to easily add or delete employees.
There are some expenses related to certain employees earnings, for example, employment insurance is $ 4.10/$ 100 of earnings for each registered employee... so I need the program to calculate this number for me and make it optional for each employee.
4) Then the spreadsheet will take result 2 "bonus fund" and multiply that by each employees percentage and produce the amount of money they would receive as a "bonus."
A simple and easy user interface is important with summary pages.
5) Then I need another sheet... this one will take all the income I was paid (results from #3), then add the bonus on top to provide the gross income. Then it will subtract my personal expenses, taxes, debt payments, etc. and provide me with a result.
The bonuses are paid monthly, so it would be nice if the program knew that it was the start or end of the month and would automatically begin calculating everything for the next month and not add it onto the previous month.
I need to be able to create pdf format.
There is more I would like to do with the last sheet, but lets start with this... unless you have some ideas as far as the program keeping track of debt balances as I make regular payments and make extra payments.
Thanks,
Davyn
Additional Info (Added 1/29/2010 at 11:31 EST)...This doesn't have to be a spreadsheet... if you feel there is a better way of doing it through a database or something then I am open to suggestions
Additional Info (Added 2/28/2010 at 5:40 EST)...System Message: This is a reposting of project Profit Spreadsheet (1264758939).
1) I will begin by inputting the revenue from a job, then the spreadsheet needs to subtract the "job expenses" of that job which will produce result 1A. The revenue will begin with labor, which will be a gross amount, so I will input the gross amount, then the program needs to calculate the government sales tax (GST) from that gross amount which will be preset to 5% but must be easy to change if necessary. Then the next revenue I input will be materials, and the calculator will calculate the 2 taxes, which is 5% again, and an additional 7% for Provincial Sales Tax (PST). This net amount will be result 1B.
2) Then, a number of "business expenses" will be subtracted from result 1B, which will produce result 2, the "bonus fund"
Some of these expenses are fixed and some fluctuate and I need the ability to add or delete expenses.
3) Then I need another sheet that tracks employees including myself, our rate, how many hours each of us worked in a calendar month, and the gross amount we were paid. Hours for all employees will then be totaled & then a result will be produced to provide a percentage of hours worked by each employee. So if I have 3 employees, and we worked 1000 hours in total for January, and I worked 413 hours, then I need the spreadsheet to provide the percentage, which in this case would be 41.3%... and then to provide the percentages for the other employees as well.
I need the ability to easily add or delete employees.
There are some expenses related to certain employees earnings, for example, employment insurance is $ 4.10/$ 100 of earnings for each registered employee... so I need the program to calculate this number for me and make it optional for each employee.
4) Then the spreadsheet will take result 2 "bonus fund" and multiply that by each employees percentage and produce the amount of money they would receive as a "bonus."
A simple and easy user interface is important with summary pages.
5) Then I need another sheet... this one will take all the income I was paid (results from #3), then add the bonus on top to provide the gross income. Then it will subtract my personal expenses, taxes, debt payments, etc. and provide me with a result.
The bonuses are paid monthly, so it would be nice if the program knew that it was the start or end of the month and would automatically begin calculating everything for the next month and not add it onto the previous month.
I need to be able to create pdf format.
There is more I would like to do with the last sheet, but lets start with this... unless you have some ideas as far as the program keeping track of debt balances as I make regular payments and make extra payments.
Thanks,
Davyn
Additional Info (Added 1/29/2010 at 11:31 EST)...This doesn't have to be a spreadsheet... if you feel there is a better way of doing it through a database or something then I am open to suggestions
Additional Info (Added 2/28/2010 at 5:40 EST)...System Message: This is a reposting of project Profit Spreadsheet (1264758939).
Posted In:ProgrammingMS AccessmSQLSQL |
Related projects:
Google Spreadsheet 2
e Doc to update Sheet 2.
This tutorial may help, http://www.google.com/google-d-s/scripts/writing_spreadsheet_data.html
Please bid if you are available as soon as possible and can complete this today. Thanks.
This tutorial may help, http://www.google.com/google-d-s/scripts/writing_spreadsheet_data.html
Please bid if you are available as soon as possible and can complete this today. Thanks.
Link Building 2 parts
inks from article directories, link farms or classifieds.
This job should be done over a three week time span!
A weekly report of your progress will be required in an excel file, including the following information:
1. URL link was submitted to
2. Date the link was submitted
3. Date link was accepted
4. Page rank of the which the link is on
5. Anchor text used
This job should be done over a three week time span!
This job should be done over a three week time span!
A weekly report of your progress will be required in an excel file, including the following information:
1. URL link was submitted to
2. Date the link was submitted
3. Date link was accepted
4. Page rank of the which the link is on
5. Anchor text used
This job should be done over a three week time span!
Excel Ref Table 2
Info (Added 12/15/2009 at 15:08 EST)...Attached file: reference_table_2.xls
Additional Info (Added 12/22/2009 at 1:30 EST)...Attached file: excel reference table details.ppt
File info: illustration of what I want on user sheet 3
Additional Info (Added 12/30/2009 at 15:54 EST)...System Message: This is a reposting of project Excel Ref Table (1260839865).
Additional Info (Added 12/22/2009 at 1:30 EST)...Attached file: excel reference table details.ppt
File info: illustration of what I want on user sheet 3
Additional Info (Added 12/30/2009 at 15:54 EST)...System Message: This is a reposting of project Excel Ref Table (1260839865).
Join 200 Adult Yahoo Groups 2
instantly, for all other groups, the membership is pending.
6) This yahoo account will already be a member of some yahoo groups, so the selected bidder will have to search for 200 groups that have not already been joined.
7) This project has an adult subject matter and is only intended for bidders who are OK with working on adult projects.
The deliverables for this project are:
1) A completely filled out spreadsheet
2) 200 joined groups
6) This yahoo account will already be a member of some yahoo groups, so the selected bidder will have to search for 200 groups that have not already been joined.
7) This project has an adult subject matter and is only intended for bidders who are OK with working on adult projects.
The deliverables for this project are:
1) A completely filled out spreadsheet
2) 200 joined groups
Extract text and pictures from PDFs into jpgs + spreadsheet
r page, whichever you prefer. Tell me if you have any questions.
Thank you
Additional files submitted:
samplework.zip
Thank you
Additional files submitted:
samplework.zip
Simple Excel Spreadsheet
sites to show new system selections in real-time as and when they are found.
Nothing too complicated at all.
This is a simple project for someone who knows what they're doing and, after this, I also have a very similar project. If you are chosen for this project and do a good job, you will have the opportunity of more work from me in the near future.
Feel free to ask away if you have any questions.
Thanks and happy bidding,
- Josh.
Nothing too complicated at all.
This is a simple project for someone who knows what they're doing and, after this, I also have a very similar project. If you are chosen for this project and do a good job, you will have the opportunity of more work from me in the near future.
Feel free to ask away if you have any questions.
Thanks and happy bidding,
- Josh.
Simple, reliable excel spreadsheet wanted...
new system selections in real-time as and when they are found.
Nothing too complicated at all.
This is a simple project for someone who knows what they're doing and, after this, I also have a very similar project. If you are chosen for this project and do a good job, you will have the opportunity of more work from me in the near future.
Feel free to ask away if you have any questions.
Thanks and happy bidding,
- Josh.
Nothing too complicated at all.
This is a simple project for someone who knows what they're doing and, after this, I also have a very similar project. If you are chosen for this project and do a good job, you will have the opportunity of more work from me in the near future.
Feel free to ask away if you have any questions.
Thanks and happy bidding,
- Josh.
CMF database to Excell Spreadsheet 2
I have a website that has information in a cold fusion database. I need some one to grab the database from its location and convert it to an excel spreadsheet or csv format.
convert MS Word-generated html into excel spreadsheet
eone write a vba code, to parse a MS Word-generated html into excel spreadsheet fields.
1. The MS word file has serveral fields for each data item, need to parse the html file and extract the data into a spreadsheet
2. Need to preserve formatting information for three of the fields, such as the hyper link and table, italic and bold fonts.
Need you to have strong vba experience and html knowledge, I already some codes that you may use as reference.
1. The MS word file has serveral fields for each data item, need to parse the html file and extract the data into a spreadsheet
2. Need to preserve formatting information for three of the fields, such as the hyper link and table, italic and bold fonts.
Need you to have strong vba experience and html knowledge, I already some codes that you may use as reference.
Multiple Suppliers Module
ttings based on the wholesale cost of the item. The cost tiers to use and the percentage markup you want to associate with each tier. For example, from $ 0-20 add 50%, from $ 21-50 add 45%, and so on.
5.MSRP Pricing: Base the pricing relative to the MSRP of each product. You can specify a dollar amount or percentage to discount from the MSRP, or you can have your pricing set to the actual MSRP. Include any discount below that price if you want one.
5.MSRP Pricing: Base the pricing relative to the MSRP of each product. You can specify a dollar amount or percentage to discount from the MSRP, or you can have your pricing set to the actual MSRP. Include any discount below that price if you want one.
Flash Website Fine-tuning
the same as in "Small Business".
4.2 Can you change the color from dark/light green to dark/light
red to match the two reds on the home page?
Residential
5.1 When the "more testimonials" link is clicked a window pops up. I want this window to be a new one and not the same as in "Small Business" or "Non-Profit".
5.2 Can you change the color from dark/light green to dark/light
red to match the two reds on the home page?
4.2 Can you change the color from dark/light green to dark/light
red to match the two reds on the home page?
Residential
5.1 When the "more testimonials" link is clicked a window pops up. I want this window to be a new one and not the same as in "Small Business" or "Non-Profit".
5.2 Can you change the color from dark/light green to dark/light
red to match the two reds on the home page?
Manual data collection from Internet
Y 13H00 CET ON 11 FEBRUARY 2010.
Additional files submitted:
U+S+_Law_Firm_Addresses-09022010.xlsm
Additional files submitted:
U+S+_Law_Firm_Addresses-09022010.xlsm
Research Project - Verfify Business Data
com
No partial verifications, the business must have an active website/phone/mailing address
RANDOM CHECK: I will randomly check the websites / mailing addresses / telephone numbers for (50) of the businesses that you submit. If the information is found to be inaccurate or fraudulent, no payment will be made.
I PAY ON TIME FOR REAL WORK…CHECK MY FEEDBACK HISTORY!
SERIOUS BIDDERS!
EST PROJECT BUDGET: $ 30
No partial verifications, the business must have an active website/phone/mailing address
RANDOM CHECK: I will randomly check the websites / mailing addresses / telephone numbers for (50) of the businesses that you submit. If the information is found to be inaccurate or fraudulent, no payment will be made.
I PAY ON TIME FOR REAL WORK…CHECK MY FEEDBACK HISTORY!
SERIOUS BIDDERS!
EST PROJECT BUDGET: $ 30
Weekly Paid Salary Facebook Affiliate Network Marketers
r>CONTACT US:
In order to prompt a quick response from one of our managers please do the following:
1. Write in your OWN WORDS what your abilities are in the English language.
2. Do not send a pre-written paragraph you send to everyone else as this wont impress me.
3. Be a leader and let’s make money.
We will reply back with a link of our product and a contact us link. You can contact us through the website and we’ll chat.
In order to prompt a quick response from one of our managers please do the following:
1. Write in your OWN WORDS what your abilities are in the English language.
2. Do not send a pre-written paragraph you send to everyone else as this wont impress me.
3. Be a leader and let’s make money.
We will reply back with a link of our product and a contact us link. You can contact us through the website and we’ll chat.
Salary Weekly Facebook Affiliate Network Marketers
r>CONTACT US:
In order to prompt a quick response from one of our managers please do the following:
1. Write in your OWN WORDS what your abilities are in the English language.
2. Do not send a pre-written paragraph you send to everyone else as this wont impress me.
3. Be a leader and let’s make money.
We will reply back with a link of our product and a contact us link. You can contact us through the website and we’ll chat.
In order to prompt a quick response from one of our managers please do the following:
1. Write in your OWN WORDS what your abilities are in the English language.
2. Do not send a pre-written paragraph you send to everyone else as this wont impress me.
3. Be a leader and let’s make money.
We will reply back with a link of our product and a contact us link. You can contact us through the website and we’ll chat.
BOILER ROOM: Week-Salary Facebook Affiliate NetworkMarketers
r>CONTACT US:
In order to prompt a quick response from one of our managers please do the following:
1. Write in your OWN WORDS what your abilities are in the English language.
2. Do not send a pre-written paragraph you send to everyone else as this wont impress me.
3. Be a leader and let’s make money.
We will reply back with a link of our product and a contact us link. You can contact us through the website and we’ll chat.
In order to prompt a quick response from one of our managers please do the following:
1. Write in your OWN WORDS what your abilities are in the English language.
2. Do not send a pre-written paragraph you send to everyone else as this wont impress me.
3. Be a leader and let’s make money.
We will reply back with a link of our product and a contact us link. You can contact us through the website and we’ll chat.
Multiple Suppliers Extensin
ttings based on the wholesale cost of the item. The cost tiers to use and the percentage markup you want to associate with each tier. For example, from $ 0-20 add 50%, from $ 21-50 add 45%, and so on.
5.MSRP Pricing: Base the pricing relative to the MSRP of each product. You can specify a dollar amount or percentage to discount from the MSRP, or you can have your pricing set to the actual MSRP. Include any discount below that price if you want one.
5.MSRP Pricing: Base the pricing relative to the MSRP of each product. You can specify a dollar amount or percentage to discount from the MSRP, or you can have your pricing set to the actual MSRP. Include any discount below that price if you want one.
Excel Ref Table
file to that does the following
*read the data from spreadsheet 1
*Allows me to update or add to the data from spreadsheet 1
On spreadsheet 2, I should be able to:
*select 1 or more item types (from dropdown list)
*select 1 or more item levels (from dropdown list)
*see the matching list of item numbers
The results from sprea
I would like to get started right away. Payment will be released from escrow only after I have a working file.
*read the data from spreadsheet 1
*Allows me to update or add to the data from spreadsheet 1
On spreadsheet 2, I should be able to:
*select 1 or more item types (from dropdown list)
*select 1 or more item levels (from dropdown list)
*see the matching list of item numbers
The results from sprea
I would like to get started right away. Payment will be released from escrow only after I have a working file.
Price Action Ea
ps to 10 pips, we will advice a buy order. However, i am afraid if the price move around 10 pips. Will the EA open continuous buy order. I only require 1 open trade when the price first hit the trigger level.
Please view the image of the detail calculation and table layout ( table layout must be appear on the platform for viewing). please PM me your suggestion for the above concern.
Project price bid must include the .ex4 and .mq4 file. Please quote accordingly.
Please view the image of the detail calculation and table layout ( table layout must be appear on the platform for viewing). please PM me your suggestion for the above concern.
Project price bid must include the .ex4 and .mq4 file. Please quote accordingly.
Copy & Paste Project
know if you have any questions.
Good luck with your bids,
Dave.
Additional files submitted:
Digg+Articles.xls
Good luck with your bids,
Dave.
Additional files submitted:
Digg+Articles.xls
