I have a fairly detailed Excel Spreadsheet that tracks daily sales statistics for sales people then builds reports based upon those numbers that are input. It is based upon a Quarterly system and I am looking to expand it and make it more functional ... and more stable. I am looking for stability and simplicity. I created this as I learned Excel
...old games for new ones. I was hoping i could use the service of pay pal for transactions. I would also like to be able to have a data link from MYOB to the website, alternative i would like to upload bulk data via spreadsheet or the like. Similar sites i was looking at are [login to view URL], combined with retrogames.com.au. If you see retrogames
...divide and move the data to three different related tables named something like tblProducts, tblCustomers, tblOrders, and a reference stand-alone table for words to be ignored in a search. The tblOrders table should have a one to many relationship with both other tables where the many is on the tblOrders table in both cases. This data will be mostly
...using a sales network where i am recieving lots of sales which also contain lots of fraudulent sales. I need an efficient way to keep track of these suspcious sales. I am alerted to fraud sales in a number of ways, each time i am alerted I would like to create a Fraud Report. I then want the ability to generate reports so I can send them to the sales...
...is available upon request, I couldn't list all functionality required here. ## Deliverables I am looking for a custom solution for list management for a telemarketing and sales environment. This solution will have a very simple interface.? I am going to elaborate on all my ideas with as much detail as possible so there isn’t any confusion on processes
Need three spreadsheet reports from data in two access tables: sales orders and corresponding items. Access/Excel 2003. Can be written in any language but the final result needs to be .xls. Well run your program/code over the tables a couple of times a year to? evaluate ourt performance. OS: Windows 2000/XP. ## Deliverables Create ms excel
...route should have possibility of manual override. Payment choices PayPal, Credit card Debit Card (PayPal Pro) radio button. Integrate PayPal Pro into website Add a sales function for Welcome packs, vouchers, special offers, ski passes etc & to include text field editable. …..purchase options…as in HHB website, see link above. In addition
...researched data on jewelry sales in Scotland presented in Excel data and graphs, from 2004-2007. Specifically: = Total sales values of jewelry (all forms)in Scotland, in Great Britain Pounds (GBP) = Total sales values of fancy jewelry in Scotland, in GBP, 2004-2007 = Total sales values of fancy jewelry in Glasgow, in GBP, 2004-2007 = Total sales<...
...create a monthly commission report into a real database and program. We have two separate accounting systems so we need to do each step twice. The process is as follows: 1. run monthly sales report A into Excel 2. run monthly payments report B into Excel 3. run monthly sales report B into Excel 4. run monthly payments report B into Excel ...
I have a complicated excel spreadsheet that tracks Profit and loss and goals for small business. I need it to be taken out of excel and converted into some form of database and have a? website built that will be set up to accept charge cards for monthly users. ## Deliverables ProfitXcelerator: Functionality specifications: This Goal and profit tracking
...link and search by keyword “SID.?? Besides the customary links offered by advertisers, Commission Junction provides a method for publishers to track where their leads and sales originate so that they can target and/or reward those consumers who used their links. This method is made available through the use of what is known as a Shopper ID number or
...program (UPS) 8. System for sending shipping notification to clients 9. System to rate their purchase & write a review. 10. Set up an affiliate program, generate affiliate sales reports & commission statements 11. Username & PW login for wholesale accounts 12. SEO Optimize the site along with appropriate metatags 13. Site works on all browsers
...perform the following tasks to the Data Tape spreadsheet to arrive at the Copy of the investment analysis that will be provided in excel format. Could be VB, XML, Add-Ins, Macros or a combination. ? ? ? 1. Sort and Filter by asset type, and location. 1. Delete or Hide columns per Investment analysis spreadsheet. 2. Calculate totals and subtotals
...and setup to be automated. 2) The ultimate goal with the Touchstar reports would be a Crystal Reports / Xcelcius dashboard that would provide a realtime view into the report data 3) Within the Touchstar, we hold over 1.5million records and have need to hold these in a separate database. We would need a script that would pull the records contacted
...the admin can create additional subcategories and then subcats under them. When a spreadsheet is uploaded, it'll give us the ability to specify which category it's to go to. There is the possibility that a spreadsheet will have many categories in a single spreadsheet. So what I propose is when the admin creates the category or subcat, the admin is given
...SKU's Their estimated annual sales is over $125 million. Stated Goal Due to the limited amount of time a Buyer/Customer may spend with a Representative during Market it is very important for our Company to capture as much potential data in the limited amount of time available. It is very important for the Sales Request Process appears professional
Our non-profit foundation, The Soulcial® SOLUTIONS Foundation ([login to view URL]), has opened up a new online sales site called Soulcial® WEAR at http://www.soulcialwear.com. On this site, we currently sell T-shirts, but expect our product inventory to grow to include different types of outerwear in the coming year. While
...administration Complete storefront system Sell virtually unlimited products Toll-free 24x7 tech support Graphic design skills not required Other Templates availability Custom design and data entry services. PRODUCT INFORMATION One click featured products Inventory control Set quantity pricing Set wholesale pricing Automatic image sizing Show video / audio demonstrations
...list N. Upload model spreadsheet O. Upload model instructions P. Upload program handouts Q. Download faculty confirmation letters R. Automatically send weekly Status Report e-blast to the Product Manager and Sales Force S. Upload, email program handouts to Meeting Services Department T. Automatically send CS daily activity report Meeting Services
This is a pretty straightforward data entry task. We will provide an excel spreadsheet with company names and specific urls for the datasources, and need certain numerical information pulled from the text reports listed at the urls and entered into the spreadsheets. To give you an idea of the scope of the work, for each of approximately 300 companies
...excel to store data, but want to now use access i made a start by creating 3 tables and relationships in the db (see attached file) and need the following: (please let me know if you think the fields in the tables need modifying) a table (new table? or add to one of existing tables?) to create a sales ledger with a form to add data recording customer
...of e-mail address. o Add Sales Report Option § Allow me to pick timeframe, then show sales (revenue), less cost (expenses)…to show overall profit o Add Export Feature § Allow all fields in the table to be exported to an excel spreadsheet - Fields: (Data can be pulled from [login to view UR...
I would like to have a secure web accessable data base application written that can take help keep track of upcoming installation and service work for my company. I currently use an Excel spreadsheet (example attached) that does not have all of the fields of information (i.e. full address information, payment status, material due dates, etc.) that might
I have an access database that calculates data from several tables, based on criteria selected in FORM (parameters) which allows you to select from 2 different reports (classnbr) and (twp report)... What I am wanting to find out is if there is a way I can save the data from certain reports of my choosing (not all are good) I am looking at the
...(actually I'd favor a proprietary database!), or works in Java. There are three main parts: the design part (see Requirement 1), the data-collecting part which lives on a Web site as a php or perl script, and the reporting/data exporting part. The reasons for the requirements below are to have the flexibility and ease of use required by a professional piece
...need 2 account Profit/Loss summaries for end of month sales on Amazon.com. I want to be able to run a PERL program and have it generate the Amazon sold items report, then pull the costs from the Mysql database then calculate the P/L for each item and put the information back into the spreadsheet in the profit column. Then I want a summary of items (see
...study below: Company Description: House of Magic and Games Pty Ltd (HMG) manufactures and retails a comprehensive range of games for both adults and children. HMG has an annual sales revenue of AUS$500 million. It restricts its operations to the eastern seaboard and South Australia. HMG want to set up a computer network linking up their sites. Scenario:
...review all designs for search engine compatibility and will be a determining factor for releasing final payment. This project is on a critical time frame due to upcoming sales events the project would require completion in about 1 month from bidder accepting job. Do not bid if you cannot finish in that time frame. Below are the individual sites
...the hard copies. I use a company logo that I created in Powerpoint in my company header and need this logo in the order entry program. I use the following fields in my form. Data fields: Date Order Received Purchase Order Number Requested Ship by Date Bill To Information Ship To Information Telephone/Fax/Contact person for both Bill To and Ship To Special
...panel, I should be able to send a web-based mailing to all members, remove members, view sales earned and commissions owed / paid, etc. (e) Any changes that I make to the webpage should automatically be reflected on all members pages. (f) Should automatically backup data for restore in the even something should go wrong and crash the system. (g) If a member