Find Jobs
Hire Freelancers

Analysis Tool

$30-5000 USD

已完成
已发布大约 16 年前

$30-5000 USD

货到付款
Analysis Tool I have attached a worksheet with 2 columns. This is a subset of data that represents a monthly invoice. My sample contains a few records, but the invoice typically contains approximately 325-400 entries. I am seeking a the creation a tool, ideally something in Excel that provides an allocation mechanism. We are still refining the logic but are seeking someone to get us started and assist in generating something functional that can easily be used by non-tech users to get the job done. It involves an automated analysis of data returning certain statistics and results. The initial idea is to provide some VBA form or macro to provides an easy mechanism for selecting the range for the data, then providing the results and recalcs. Here are the core things that need to solved - some easy, some will need further explanation: 1) [Input] User selects range of data. 1a) [input] User enters a baseline amount. This is an arbitrary amount. It is effectively the cumulative average of previous periods. This amount will be compared against the current average amount. The difference will be displayed. The user will decide later if they wish to base their final results based on the baseline amount. 2) [output] Need to provide a single value representing the average cost of the range of items. 3) [output] Need to identify a list of items which items are over the average cost. 4) [Output] Need to further refine the list of over-the-average items to display items that are (n)percent over the average. 5) Need to provide a recalcualted list that reveals the average amount for each ID, but for IDs above (N) average a prorated amount which represents additional amounts (effectively as a penalty for being above the average). When all items are summed results in new allocation the same sum of the invoice total. This may require further discussion. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Excel ?
项目 ID: 3642669

关于此项目

4提案
远程项目
活跃16 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$85 USD 在7天之内
4.9 (408条评论)
7.1
7.1
4 freelancers are bidding on average $108 USD for this job
用户头像
See private message.
$255 USD 在7天之内
4.3 (6条评论)
3.5
3.5
用户头像
See private message.
$42.50 USD 在7天之内
4.9 (15条评论)
3.3
3.3
用户头像
See private message.
$51 USD 在7天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
5.0
316
会员自4月 2, 2003起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。