Fix/Recreate Excel Macros

Guru 技术与编程 海外
708天前

详细信息

We have an Excel setup from 2003 with macros. This was set up to pull information from master logs of data for our schedule system. We have functioned this way ever since, and when you try to use the …

免责声明

该外包需求信息来源于站外平台，本站仅提供公开信息部分字段展示与订阅服务，更多请查看免责声明。

立即前往
关注公众号,不定期副业成功案例分享
关注公众号

不定期副业成功案例分享

想领先一步获取最新的外包任务吗？

立即订阅

类似推荐

I am a small business involved in physical commodity trading internationally. This involves buying products, mostly FOB ( free on board, which is an incoterm ) from 1 geography, at a defined price, and selling it to cutomers globally on a CFR ( cost and freight ) to port basis using the global container freight market. The inputs for the FOB price would be made by me by port of origin. The inputs for the freight costs would need to be made either by me or by third party companies so may need to be restricted in some way. ( I guess this is to be done via Google Sheets ) Both of these inputs need to be able to be edited frequently ( daily ). The CRM should be able to send bespoke/customised offers to individual customers, in certain regions in the world, based on information in the CRM ( name of buyer, company name, payment term, currency, product expected margin, finance and insurance cost ). The bespoke offer must include a price which is calculated from combining the inputs of FOB price, the freight , the expected margin and costs including a currency exchange rate drawn from the daily xe.com rate. There could also be a second element of 'freight insurance' but that will come at a later stage as a secondary part of the offer. Each individual offers should have the option to include multiple products which would be customer dependent. It should be possible to send these bespoke offers both via Email ( a formal offer ) and a much shorter more informal offer via Whatsapp to the customers. The CRM should also be able to easily issue invoices to customers once a deal is agreed and provide a summary of the deals done each week on a Friday to me so that the payment deadlines can be tracked. It should also automatically send out a reminder to customers of the due date 2 days prior to that date. The CRM should also be able to track purchases from suppliers, with their FOB or CFR costs and be allocated to sales orders. This allocation would be done either manually or automatically. I currently run something basic from a spreadsheet but this now needs more integration and to become easier to use. I've shared an example of this spreadsheet. 1. CRM set up and customisation for international trading business. This will include customisation of: - contact management module ( to include all fields required ) - product and pricing module ( allow bespoke offers, similar functionality to the current excel spreadsheet ) - deals module ( to track response to offers made on a weekly basis to customers and track history and sales record ) 2. Invoicing integration with the CRM - set up of invoicing functionality to enable instant invoice generation upon deal closure and connection with a purchase order to track margin from purchase order to sales order. ( this should feed into the customer tracking and performance ) 3. Dashboard and reporting - reports of deals closed weekly - Contains customer information/ overviews including market share, where they are buying from, which products they purchase and which products they produce. - A dashboard to scrape key metrics and display them, including ( Oil price, currencies ( USD/EURO/GBP ) ethylene price, energy prices, showing daily and monthly movements ) 4. Automation and workflows - automated sending of customised offers via email and WhatsApp - payment reminder workflows triggered 2 days before due dates 5. Custom development - for pricing calculation that combines FOB pricing, Freight costs, expected margin and cost - inputs should not be restricted and allow changes to be made - daily currency exchange rate e.g xe.com - Freight Insurance (to come later) This will feed into the automated, bespoke offers to customers. 6. WhatsApp integration 7. LinkedIn integration to gather specific leads and co-ordinate Linekdin outreach
1000.0 GBP 技术与编程 peopleperhour 海外
1天前

HuntsBot(狩猎机器人)，一站式外包任务、远程工作、产品创意分享与订阅平台，支持钉钉、飞书、企业微信、邮箱、Telegram机器人订阅。平台会以及时、稳定、可靠的技术把外包任务需求、远程工作机会、产品创意等推送给每一位订阅的用户。

简体中文 English

平台

支持

友情链接

联系我们

在使用过程中有任何问题或建议，可以通过以下方式联系我们：

微信公众号: 火星来客

Email: huntsbot@xinbeitime.com

Copyright© 2022-2023 www.huntsbot.com 浙ICP备2022000860号-4 All Rights Reserved.