Programming (Excel, database management, analysis, SQL)

En curso Publicado hace 5 años Pagado a la entrega
En curso Pagado a la entrega

I'm running a bid/rfp and I need assistance getting information processed and analyzed efficiently. I will have approximately 100 suppliers providing pricing on approximately 2000 unique items. I want to be able to rank, sort and analyze this data efficiently. I've written some Excel formulas that can get me part of the way there, but they are very cumbersome and often crash my computer. I need a better way to do this.

An example of the data I will be receiving is in the spreadsheet named "All Carrier Bids". The columns might move or be renamed and be slightly different, but it gives you a very good sense of the information I will have. This will be the source of the analysis. I think the only adjustment I would have to make to this is that I would rank a rank of low cost to high cost (column W) for each lane ID (column D).

The other spreadsheet I have is what I would like the analysis output to look like. It would have each unique lane ID from the previous spreadsheet and the detail for that lane ID (blue column headings) from the "All Carrier Bids" file. The information I would like to automate has the gray column headings. A definition of each is:

Number of bids: unique bidders (column C, SCAC) for each lane

Number of outliers: TBD

Lowest bid: the lowest Linehaul Cost per Shipment (column X) for each lane ID

First quartile bid: average Linehaul Cost per Shipment (column X) for the lowest 25% of bids in that lane ID

Median bid: median Linehaul Cost per Shipment (column X) for each lane ID

Average bid: average Linehaul Cost per Shipment (column X) for each lane ID

Carrier with lowest bid: Carrier (column A) with the lowest bid on each lane ID

Carrier with second lowest, third lowest: Same as above

Lowest bid: lowest Linehaul Cost per Shipment (column X) for each lane ID

Rank 2, 3, etc: Same as above

And then all of the Carriers (column A) that bid on that particular lane in a column across the spreadsheet.

Let me know if this makes sense or if you have any questions. If you are following what I'm asking for, please let me know if it is something you could help make more efficient and what it would cost and lead time.

Thanks

Scott

All Carrier Bids [login to view URL]

Analysis Output [login to view URL]

Procesamiento de datos Administración de bases de datos Excel Microsoft Access SQL

Nº del proyecto: #16692901

Sobre el proyecto

28 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

hamlinl

I can do ANYTHING in Access and Excel. I have created many much more complicated databases and spreadsheets including forms with SQL and macros. I test all functionality as I work and again when I finish. I am a per Más

$30 USD en 2 días
(0 comentarios)
0.0

28 freelancers están ofertando un promedio de $167 por este trabajo

schoudhary1553

Hello, I have the good knowledge of Programming (Excel, database management, analysis, SQL) . I have more than 5 years of experience in Data Processing, Database Administration, Excel, Microsoft Access, SQL. We ha Más

$200 USD en 3 días
(386 comentarios)
8.1
axiomswb

I have expertise in Excel VBA. I have gone through your requirements. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..

$60 USD en 3 días
(62 comentarios)
6.4
zu02

Hi I can build your database from stretch using MS Access. Can you answer for all my questions I'll ask during coding(as usually I'm doing) ? Do you have more detaiils for this project? I'm Ms Access/VB/SQL/Acc Más

$250 USD en 7 días
(55 comentarios)
6.1
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Más

$250 USD en 7 días
(34 comentarios)
5.8
vaidyag

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. Now looking at you Más

$200 USD en 3 días
(20 comentarios)
5.4
pkcyber

I can develop an automated application for you. it will be user friendly. It will be windows form application. Keenly looking forward your response.

$200 USD en 5 días
(34 comentarios)
5.7
langlangFan

Hello, Nice to meet you, I hope you are well Here is a senior excel developer, langlang from China. I have read your job description with exciting mood :) In one word, I can say <I can do your project> proudly Más

$155 USD en 3 días
(5 comentarios)
5.3
softcarve

Hi, We can import the excel in database and creating a web report to render the desired output. Available to start now. please get in touch to discuss more. Regards, Manish

$277 USD en 10 días
(65 comentarios)
5.4
jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Más

$200 USD en 5 días
(29 comentarios)
4.9
shihan033010

A proposal has not yet been provided

$166 USD en 3 días
(21 comentarios)
5.0
point5nyble

Hello, I have been working as an IT BI DWH Professional since last ~ 7 years and have very vast experience around all its 3 layers (ETL, DWH & Reporting) including ER Dimensional Modelling. Below are some key are Más

$111 USD en 5 días
(44 comentarios)
5.0
cyash61

Hello, I am an data analytics and business strategy consultant with more than 6 years of expertise working top management of client firms to help with data driven decision making. I have perfectly understood wh Más

$300 USD en 7 días
(7 comentarios)
4.3
GustafStefansson

Hi there, With great interest I read about the project. Being a double M.Sc. in Mathematics / Computer Science professionally specialised in Excel I am excited to apply my skills. I possess vast experience implem Más

$155 USD en 3 días
(2 comentarios)
3.3
aloha21

A proposal has not yet been provided

$77 USD en 3 días
(1 comentario)
2.1
uzthegeek

Hi, i can do it kindly get in touch via chat, thanks

$111 USD en 7 días
(1 comentario)
0.6
piyushchove40

A proposal has not yet been provided

$55 USD en 1 día
(0 comentarios)
0.0
asphodelsoftware

Hello, We have more than 10 years experience in this task. I can easily accomplish your requirements. I can show you my previous & current works. Lets discuss more over chat. Thank you.

$222 USD en 15 días
(0 comentarios)
0.0
diptitripathy884

A proposal has not yet been provided

$111 USD en 3 días
(0 comentarios)
0.0
Moradcharai

Tres efficace

$50 USD en 1 día
(0 comentarios)
0.0
rihamfikry

A proposal has not yet been provided

$222 USD en 5 días
(0 comentarios)
1.4