Find Jobs
Hire Freelancers

FDOT Analysis Excel

$30-250 USD

完了済み
投稿日: 5年以上前

$30-250 USD

完了時にお支払い
I am pursuing the development of an Excel Spreadsheet that allows for the analysis of a bid scoring matrix and uses two major scoring criteria. The first criteria are the scoring of the technical response (see Attached document) where a numeric value is used to grade the quality of the technical response. The second criteria of the scoring matrix is the pricing proposal score. The pricing proposal scoring formula is provided below. Price analysis is conducted through the comparison of price quotations submitted. Price Score = 100 x (Lowest Bid / Proposer's Bid) x 30% (for the lowest price use $750,000 up to 1,250.00)/(for the proposer price use $900,000 up to $1,500,000) both can be in increments of $50,000) By plugging in different criteria into the excel spreadsheet, I am attempting to determine the balance between the two major criteria. In short, at what point can I win the work with one score high and another score low and where is the tipping point Total Proposal Score = Technical Score + Price Score If all other criteria are met, the Contract will be awarded to the Proposer with the highest Total Proposal Score.
プロジェクト ID: 17841027

プロジェクトについて

11個の提案
リモートプロジェクト
アクティブ 6年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hello, my name is Andrés. I'm the leader of Trascender Global. I have reviewed your project and I can help you creating this Excel file. Best regards
$150 USD 3日以内
5.0 (89 レビュー)
6.6
6.6
この仕事に11人のフリーランサーが、平均$181 USDで入札しています
ユーザーアバター
Hello, i have read your project details and i can help you with 100% quality and your satisfaction. I have delivered more than 400 project with client satisfaction. Please see my profile . I have more than 5 years of experience in Excel, Excel Macros, Statistical Analysis, Statistics. Please ping me for discussion. Thanks.
$250 USD 4日以内
4.9 (290 レビュー)
7.7
7.7
ユーザーアバター
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$211 USD 5日以内
4.9 (106 レビュー)
6.6
6.6
ユーザーアバター
Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$250 USD 3日以内
4.8 (90 レビュー)
6.9
6.9
ユーザーアバター
- Went through the Bid Scoring documents (Points and subpoints) Based on the Technical Response (Scoring) & ( various sections and subsections) Totalling to 100 Pricing Proposal scoring Based on the formula (Lowestbid to Highest biid) Grade points can be calculated for each of the proposal. - Could compare the weightage points and the totals for each proposal and be able to identify the best score. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl
$160 USD 3日以内
4.6 (47 レビュー)
6.0
6.0
ユーザーアバター
I am a professional Statistics Expert, Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform Financial Modeling, Financial Analysis, Financial Forecasting, Cash Flow Projections, Budgeting and various other customized and tailored analysis and computations. I will be happy to discuss in detail regarding my qualification, experience and how I am highly suitable for this project.
$100 USD 1日以内
4.7 (44 レビュー)
5.3
5.3
ユーザーアバター
Hi! I am very interested on your project. I am bidding with this amount cause I can create/design for you with a quality and accurate output. I always make sure that my clients gets the best, 100% satisfied if not exceeds expectation. Hope you will consider me. thanks P.S. Bid amount is still negotiable...
$250 USD 5日以内
5.0 (19 レビュー)
4.2
4.2
ユーザーアバター
Dear sir. Your project attracted my attention at first glance, because I've extensive experience in Excel Programming. I'm really confident about your project, and very eager to join your project. If we have a chance to cooperate, I'll do my best to provide wonderful result. Looking forward to your response. Best Regards.
$200 USD 3日以内
5.0 (8 レビュー)
3.9
3.9
ユーザーアバター
Hello. I am Edgar Díaz. I am Urban Planner With a MBA and Specialist in Project Management (PMI) I can handle many Financial, administrative, Econometric and Mathematical softwares (MSProject, Primavera, Simul8, Excel, etc) ; and Management Methodologies (ITIL v3, Agile, Fiance2, PMI). I have experience in TOC,PERT-CPM, Chain Supply and Customer relationship Management. From the business point of view, thanks to the MBA, I have been able to develop myself in the economic and financial analysis of the projects in particular and of the companies in general, allowing me to carry out business analysis, as well as business plans, production projection And sales; In addition to the respective market studies. I have experience in business plan, PESTEL, SWOT and financial analysis. I think I have enough skill to do this task
$100 USD 4日以内
4.8 (9 レビュー)
4.0
4.0

クライアントについて

UNITED STATESのフラグ
Irvine, United States
5.0
7
お支払い方法確認済み
メンバー登録日:9月 13, 2018

クライアント確認

このクライアントからの他の仕事

Where is Waldo?
$100 USD
ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。