Hi, I need your help. I am planning a consultatio...card payment and account transfer available) - Anonymous Concerns Consultation Chat/Phone Features - Ability to enable users to convert to counselors and generate revenue Specific functional description: 1. Create and Log In User Accounts: Users must be able to create and log in to a private account. 2. Online Payment System: Users must be able to make payments within the app. 3. Anonymous Concerns Consultation Chat/Phone Features: Users and counselors should be able to consult anonymously through the chat room, and a 1:1 telephone connection function should also be available. 4. Ability for users to convert to counselors and generate revenue: Users want to convert to counselors to sell their own counseling servi...
새 프로젝트의 번역가를 찾고 있습니다! 요구사항: - 영어 - 한국어 번역가; - 한국어 모국어 - ...
...점 양해바랍니다. 현재 디비접속은 이런 형식으로 하고 있습니다. -> ,1000 (사이트주소,포트번호) , 계정 : Testaccount , 암호 : Test 입니다. 금액 쿼리 : Select replace(convert(varchar, cast(Isnull(Sum(Ori_price*qty),0) as money),1),'.00','') as Orderamt from Orderdetail where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' 금액은 붉은 색 글씨로 표시되었으면 합니다. 주문 건수 : Select count(Order_id) from Orders where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' 미배송 건수 : Select count(Order_id) from Orders where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' and TransYN='N' 주문상세 : Select productid, P_name, ori_price, Qty from Orderdetail where Convert(Varchar(8), Order_...
I'm looking for a professional who can convert my Amibroker AFL script into a TradingView Pine Script. The converted script should be able to generate buy/sell signals and provide backtesting capability. The ideal candidate should have experience in: - Amibroker AFL and TradingView Pine Script languages - Developing buy/sell signals - Implementing backtesting functionality Moreover, my trading strategy is based on breakout patterns. The converted script should reflect this strategy and incorporate the following indicators: - Moving Averages - Relative Strength Index (RSI) - Supertrend I'm looking for a freelancer who can deliver a polished and fully functional script that mirrors the performance of the original AFL script in TradingView. Feel free to ask any additional...
We are seeking an experienced developer to convert the SPM12 GUI interface, currently built on the MATLAB compiler, into a Python application. The source code for SPM12 is available at SPM12 GitHub repository Objectives: • Translate the entire SPM12 codebase from MATLAB to Python while maintaining functionality. • Develop a Python-based GUI that replicates the current MATLAB interface. • Ensure the converted application integrates well with Python scientific computing stacks. Key Deliverables: • A fully functional Python version of SPM12. • Source code with comments and documentation. • A user guide for the Python-based GUI. Skills Required: • Proficiency in MATLAB and Python programming languages. • Experience with GUI develo...
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integrity. - Attention to detail: Given t...
I am looking for a skilled UI/UX designer to create a visually appealing, user-friendly website design. We don’t need you to develop the website just the layout and the designs. Key requirements: - Create a modern, attractive design - Prior experience in designing websites - Ability to work independently and bring creative ideas to the table - Proficient in using design tools like Adobe XD, Sketch, Figma, etc. Here are the website references - - Looking forward to seeing your portfolio and discussing further.
I have written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file...
I need a freelancer to convert my PDF file to a Word file using Word 2016. I'm looking for someone who can efficiently convert my PDF file into a Word document. The successful freelancer should: - Use Word 2016 (or newer) for the conversion - Ensure the document is accurately converted without any alterations to the original information - Possess strong attention to detail to ensure no information is lost or altered during the conversion Please include a detailed project proposal with your application.
I have a PDF file that's a contract written in Arabic. I'm looking for someone who can convert it into a Microsoft Word document ( 12 PAGES ). Key Requirements: - Fluent in Arabic: The contract is written in Arabic so a good understanding of the language is necessary for accurate conversion. - Exact Formatting Match: It's important that the converted document looks exactly like the original PDF in terms of formatting. - Text and Layout Adjustments: The final Word document may need some text and layout adjustments to ensure it's professional and easy to read. Ideal Skills and Experience: - Proficiency in Arabic and English. - Experience in PDF to Word conversion. - Attention to detail for maintaining formatting. - Proficient in Microsoft Word. - Graphic design o...
I am seeking a designer who can create an elementary school-themed design for printing on a bag. The concept should reflect 'School-based' and should embody a balance of student activities and educational symbols, creating a comprehensive representation of the elementary school ex...creating a comprehensive representation of the elementary school experience. I value originality and creativity. Ideal Skills: - Extensive experience in graphic design - Proven track record with educational or children's themes. - Strong understanding of colors, fonts and symbolism relevant to children and education. - Attention to detail and consistency. The perfect freelancer for this job will convert the essence of elementary school life into a visual representation for an engaging an...
I am seeking a marketer proficient in both social media and email marketing, with a distinct flair for creating campaigns that appeal to both adults and children. Key Responsibilities: - Generate engaging content that captivates both target audienc...creating campaigns that appeal to both adults and children. Key Responsibilities: - Generate engaging content that captivates both target audiences. - Seamlessly blend elements that appeal to adults, such as elegance and sophistication, with aspects that resonate with children, like fun, and excitement. - Implement and manage the campaign. The end goal is to generate high-quality leads that convert into bookings for my birthday party business. Applicants with a track record of creating successful lead generation campaigns are highl...
I'm looking for someone to convert a PDF document into a Word document. The main purpose of this conversion is to extract text from the PDF content which has complex formatting, including elements such as tables and footnotes. Key Requirements: - Accurate Extraction: The primary goal here is to ensure that all text is accurately extracted from the PDF file and transferred to the Word document without any loss or distortion. - Formatting Preservation: While the layout may be complex, I'm looking for the freelancer to maintain the font styles and sizes as they appear in the original document. The ideal candidate for this job would have: - Proficiency in PDF and Word processing tools - Experience with maintaining formatting during content transfer - Attention to detail to ...
I need an experienced freelancer to convert 35 PDFs of workplace policies to Word. Key Tasks: - Conversion: These PDFs are under an old company name; I need these PDFs converted to Word documents, maintaining the standard business formatting. - Editing: I then need the old company name to be replaced with the new company name throughout the text and in the footer. This includes ensuring that all references to the old company name are replaced in the text. Requirements: - Proficiency in PDF to Word conversion and editing. - Strong attention to detail to ensure all instances of the old company name are replaced with the new company name. - Knowledge of standard business formatting in Word. - Experience in updating large numbers of documents would be beneficial.
...template/ Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface. Skills Required: - Proficiency in HTML, CSS, JavaScript, and responsive web design - Experience with web form development and validation PHP Integration (optional): - Form Data Processing: Develop a PHP script to receive the form submission and convert the data in...
I'm looking for a Kickstarter expert based in Bangkok who understands the ins and outs of successfully creating a captivating campaign to raise funds for a new technology product. Your role is crucial and will involve the following: - Designing an impactful Kickstarter page that perfectly encapsulates the vision and value of the product - Cr...campaign The ideal candidate must have deep knowledge and successful experience in Kickstarter campaigns, preferably within the technology sector. Strong skills in content creation, marketing strategy, and promotion are also necessary. Be ready to share examples of past work and successes. A keen understanding of the local market will be highly beneficial. Your ability to bring creative ideas to the table and problem-solving skills will...
I'm looking for a Kickstarter expert based in Bangkok who understands the ins and outs of successfully creating a captivating campaign to raise funds for a new technology product. Your role is crucial and will involve the following: - Designing an impactful Kickstarter page that perfectly encapsulates the vision and value of the product - Cr...campaign The ideal candidate must have deep knowledge and successful experience in Kickstarter campaigns, preferably within the technology sector. Strong skills in content creation, marketing strategy, and promotion are also necessary. Be ready to share examples of past work and successes. A keen understanding of the local market will be highly beneficial. Your ability to bring creative ideas to the table and problem-solving skills will...
I'm in need of an experienced translator who can convert a personal document written in Kurdish into English. The document is less than 5 pages long. Key Requirements: - Proficiency in both Kurdish and English - Experience with translating personal documents - Attention to detail Your translation must be accurate, preserving the original meaning and tone of the document. A background in a related field, such as legal or personal documents, would be a plus. Please provide samples of your previous Kurdish to English translation work.
I require an expert in Shopify to build a modern, minimalist store to increase my sales. The ideal candidate will create a user-centered design to drive traffic and convert visitors into customers. Key Skills and Experience Required: - Extensive experience in Shopify Store creation and eCommerce - Proven track record of high-converting store designs - Expertise in modern and minimalist design aesthetics - Adept in SEO boost techniques and marketing - Logo and branding creation capabilities would be a plus as I don't have these assets yet. Your role will include creating a design that aligns with current market trends, while unique enough to stand out. Your main goal is to help increase my sales via your design strategy. Therefore, your portfolio containing similar successfu...
I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple f...help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free...
I'm looking for a graphic designer with substantial experience in PNG to vector conversions, to take a PNG logo and convert it into a high-quality vector file. Specifications: • Logo Format: The initial logo format is in PNG. • Vector Resolution: The preferred resolution for the vector conversion is 600 DPI. • Color Scheme: The logo should maintain its original color scheme after conversion. Ideal Skills: The successful candidate should have demonstrable skills in graphic design, with specific expertise in PNG to vector conversions. A keen eye for detail and creativity is highly desired. Previous work in logo conversions and a broad understanding of different color schemes will be advantageous. Applications without a portfolio will not be considered.
I'm looking for a skilled programmer to help me convert my invention into an app for iOS and Android devices. It is preferred that you're located here in SAN DIEGO, CA...however it's not absolute. Key requirements: - I'm open to the programming language, so your expertise in Python, Java, or C and C ++ would be beneficial in guiding the decision. - The main functions the app should possess are user authentication and data storage. I will require a Non Disclosure Agreement [NDA] to proceed with details of the invention. If you've got experience in app development [Coding] and can help me bring my invention to life on mobile devices, please reach out. Looking forward to working with you! Thanks, Mike
I need a wizard in Microsoft Word for a particular job. The task requires fixing issues related to page numbering and the table of contents in my document. Here's what you need to do: - The documents appear to have page numbering inconsistencies which require correction. - The table of contents needs to be arranged with numerical page numbers. It is worth noting that the document does not follow any specific style guide or template. So, a general understanding of Microsoft Word formatting rules is necessary. Ideal candidates should have: - Mastery in Microsoft Word - Experience in troubleshooting and fixing Word formatting issues - Understanding of different formatting styles (although the work does not require adherence to a specific style guide) This is a quick fix...
Hi, We’re looking for a skilled female app developer to build a quick MVP and convert a physical card game into a mobile app game for both iOS and Android platforms. Quick note: I appreciate those who feel the need to start a chat and not so much those who have not bothered to read the brief before wanting to chat. I'll only start a chat if you have at least 2 to 4 links to card games you have published. Skills and experience required for this project: Experience converting physical card deck games into digital game experiences would be the ideal provider. The game brief overview: "Ello" is a two-player game played with a standard 52-card deck, where each player starts with 26 cards. The game assigns values to only four cards in the deck. In each turn...
I’m looking for a skilled developer who can convert my existing HTML5 Casino Game to an online Flask Backend. The backend should integrate with a PostgreSQL database. Key Functionalities: - User Registration and Login: Implement a secure user registration and login system that allows players to create accounts and access the game. - Game Settings Management: Develop a platform that can manage the game settings, with a particular focus on the Slot Machine settings. These include Win Occurrence, Free Spin, Balance, and other relevant parameters. - Database Integration: Connect the Flask backend to the PostgreSQL database so that it can store and retrieve the necessary game and user data. Ideal Skills and Experience: - Proficiency in Flask and PostgreSQL. - Previous experience ...
I have initiated the drafting of my business plan and investor deck, however, I am looking for a seasoned freelance professional to take my existing work to the next level. Pa...Particularly, I am in need of assistance in the creation of compelling visual branding elements. The suitable freelancer for this task should possess: - Proficiency in creating visually appealing branding elements - Impressive portfolio in graphic design with focus on branding - An understanding of business plans and investor decks - Ability to preserve my initial concept, yet bring fresh ideas to the table Your main responsibility will be to revamp the visual aspect of my business plan while maintaining the original essence. I am open to new ideas and novel thinking. I look forward to our potential coll...
I have a draft form that I would like to convert into a professional, polished fillable PDF using Adobe Acrobat. The form is between 1-5 pages long. Key Requirements: - Incorporate text fields and checkboxes from the draft - Ensure the form is user-friendly and easy to navigate - Integrate my company's logo into the design Ideal Skills: - Proficiency in Adobe Acrobat with experience creating fillable PDF forms - Attention to detail and the ability to ensure the form is aesthetically pleasing and consistent with my brand - Ability to implement logical tabbing order and form fields for smooth navigation. Note: If you have a strong graphic design background and can suggest enhancements to the form's design, feel free to share your insights.
I have 11 simple digital imags that I need converted to an .STL file so I can have it 3D printed. The design contains basic geometric shapes and lacks complex curves or textures. Key Requirements: - Convert a simple digital image into an .STL file for 3D printing - Ensure the file is optimized for 3D printing to avoid any issues during the printing process. Ideal Skills and Experience: - Proficiency in CAD software - Experience in 3D modeling, particularly converting images into .STL files - Understanding of 3D printing requirements and how to optimize files for this purpose.
Objective of the project The goal of the project is to develop an automated system that generates high-quality content related to beauty, cosmetics, skin and hair products, and makeup. This system must: Collect content from various sources (URL, RSS, XML) configurable by a Super User. Filter and process such content using artificial intelligence (AI) to improve it. Automatically publish enhanced content to a WordPress blog and various social networks. Provide an intuitive administration panel for managing system sources and configurations. Technologies and Tools Used Backend: Django Frontend: React Database: MySQL or PostgreSQL Monitoring: Prometheus and Grafana Containers and Orchestration: Docker and Kubernetes This project is already validated by AI tools to correct errors in ...
I am in need of a social media content creator who can help me boost my brand across Facebook, Instagram, TikTok and LinkedIn. You need to create 2 pieces of content using the below brand guidelines, the topic can be of your choice. I am looking for repeat work, and I will require a quotation from you based upon 10, 20, 30 pieces of social m...efficiently and deliver on time. Ideal Skills: - Proven experience in social media content creation and management. - Strong understanding of the different social platforms. - Ability to create appealing visual and written content. - Experience in brand awareness campaigns on Facebook and Instagram. If you're a creative social media professional who can bring fresh ideas and effective strategies to the table, I'm looking forward ...
I'm seeking a Front-End Developer to convert our design into a responsive web page using Bootstrap. Key Responsibilities: - Conversion of our design into a responsive web page - Proficiency in HTML, CSS, and JavaScript - Utilizing Bootstrap framework for development - Implementing specific functionalities like image sliders and interactive forms - Ensuring the final design is minimalistic and clean Ideal skills and experience: - Proficient in HTML, CSS, and JavaScript - Experience in responsive design - Knowledge of Bootstrap framework - Ability to develop image sliders and interactive forms in JavaScript - Capability to design a minimalistic and clean page Please share your previous work for review, along with your approach for this project.
CAFE NAME: BIgmug Cafe Color black and white I'm looking for a creative logo design for my chain of cafes that can compete in the western market. Like Starbucks, Java House, Mugg & Bean I don't have any specific ideas for the logo yet, so I'm counting on your expertise to bring something unique to the table. Key Points: - The logo must convey a modern and innovative vibe, capturing the essence of my franchise cafe's vision. It should be memorable it’s extremely important it’s unique and memorable like starbucks - I'm specifically looking for a design in black and white or grayscale, so please ensure this is incorporated effectively.
I am seeking a skilled professional to convert my VB.NET WinForm into a functional, interactive webpage. The purpose of the webpage is to allow user interaction, specifically enabling users to interact with database. Key Project Details: - This webpage is intended to serve as a platform for users to submit and retrieve data. - Currently, the existing design is in VB.NET WinForm and I need it to be converted into an engaging, robust webpage. - While the conversion of the form is a core need, I also require that the user interface be designed effectively to enhance the overall user experience. Key Skills Needed: - Proficiency in VB.NET and modern web development languages. - Experience in Database Management. - Knowledge in user-input forms design and implementation. - Previous expe...
Please ONLY apply if you can do the following tasks. I need an experienced freelancer to convert my PDF into Amazon KDP format. The content of the PDF is a mix of text and images. I only have a pdf file already designed into an ebook, so when directly converted into EPUB format, it yields lots or errors, words glued together, transitions between lines kept together (e.g. transfor-mation). All this has to be corrected, and accounted for in your quote. Key requirements: - Convert PDF to Amazon KDP format - Edit and format the text as necessary Ideal skills: - Amazon Kindle Direct Publishing (KDP) expertise - Excellent attention to detail for text formatting - Experience working with mixed text and image content - text editing within the EPUB format
...Ensure the site content is primarily in Arabic, with some pages in English. advice for students on studying abroad. any unnecessary content. a minimalist design. 5. Set up menus, categories, and subcategories. Content Upload: images and articles in Arabic. all content is well-organized and properly formatted. SEO and Analytics: up a Google XML sitemap. Google Analytics. the site for SEO. Performance Optimization: caching solutions to improve site performance. other performance optimizations (e.g., image compression, minifying CSS/JS). Security and Maintenance: and configure security plugins to protect the site. up regular backups. the WordPress core, themes, and plugins
Please convert the attached finished display boxes onto the smaller individaul boxes for you entry. The sides and bottom of the box can just be the background color and design but the front and back of the display box should be identical on the individual box. Need to be able to I've to fix the design also have to clear the diecut area I need a skilled designer to transform our finished display box design into smaller individual glossy cardboard boxes. The individual boxes need to perfectly mirror the display box design for just the front and back. Key Responsibilities: - Convert finished display box design onto small cardboard boxes - Ensure the design is glossy and visually appealing - Ensure the dimensions are accurate and suitable for small items Ideal Skills ...
... SPECIFICATIONS (REFERENCE IMAGES PROVIDED): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in t...
I am in need of a skilled iOS app designer to help develop a start-up program aimed at addressi...- Proficient in iOS platform app design - Prior experience in start-up or related app development - Solid understanding of user experience and interface design - Excellent problem-solving skills and creativity - Ability to work within deadlines and multi-task effectively. This project requires someone who can intuitively understand the needs of a start-up and bring creative solutions to the table. I look forward to hearing from you. I have searched the app store and have not found anything like this but it is very much needed. I will need to get a confidentiality agreement signed before anything starts. It should be fairly simple but I am not versed in app production. Thank you for ...
...to learn Salesforce and gain practical experience in this area. I am seeking a mentor or a client who is willing to guide me through a Salesforce project, providing me with the opportunity to learn and grow while contributing to their project's success. While I may have limited experience with Salesforce at the moment, I am dedicated, motivated, and quick to learn. Here's what I bring to the table: Extensive experience in Pick Basic programming and software development. Strong problem-solving skills and attention to detail. A proactive and enthusiastic attitude towards learning new technologies. The ability to adapt quickly and work effectively in a team environment. If you are willing to provide guidance and mentorship on a Salesforce project, I am eager to collabor...
Hello, I need convert a PDF invoice to Excel to import to our invoices software
Hi Mohamed A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I have an idea centered on love and relationships, submitted in the form of a drama and comedy hybrid, which I'd now like transformed into a compreh...comprehensive screenplay. The final product should be prepared to appeal to a broad, general audience. Ideal Candidate Skills and Experience: - Previous experience in writing screenplays, specifically in the drama and comedy genres - A good understanding of the subtleties and nuances unique to the theme of love and relationships - Ability to target content towards a general audience Responsibilities: - Convert the provided idea into a compelling, engaging screenplay - Ensure the theme of love and relationships is comprehensively conveyed - Align the final product with the requirements and standards of a general audience-orien...
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I'm in need of converting a short story of roughly 180 words into Universal Networking Language (UNL). This conversion is for linguistic research purposes. You'd ideally also provide a recommendation on how to use UNLarium, or any other websits, to verify the accuracy of the UNL rendition. Suitable freelancers would have: - Intermediate fluency in UNL - Familiarity with UNLarium and UNL system - Proven accuracy in their work Please note the quality of the conversion is important for my project. I'm looking forward to fruitful collaborations!
I require a skilled translator to convert the Paine script to Arabic. This translation serves a dual purpose: making the script accessible to the Arabic-speaking audience and preserving its original meaning. It's intended for use within a TradingView indicator. Key Requirements: - Proficiency in both English and Arabic. - Familiarity with the Paine script. - Understanding of TradingView's indicator system. - Ability to maintain the script's tone and meaning during translation. Please include samples of your past work or relevant certifications in your bid.
I'm looking for an experienced data entry specialist who can efficiently and accurately convert English handwritten documents into digital text format. Key Requirements: - Data Entry Skills: Proficient in entering handwritten English text with a high level of accuracy. - Language Proficiency: Fluent in English for understanding and translating handwritten content. - Patience and Attention to Detail: Meticulous and careful when transcribing the text to prevent errors. It's important that the freelancer has a good quality keyboard, as well as a quiet work space to avoid any errors in transcription.
I'm looking for someone to convert a PDF document into a Word document. The main purpose of this conversion is to extract text from the PDF content which has complex formatting, including elements such as tables and footnotes. Key Requirements: - Accurate Extraction: The primary goal here is to ensure that all text is accurately extracted from the PDF file and transferred to the Word document without any loss or distortion. - Formatting Preservation: While the layout may be complex, I'm looking for the freelancer to maintain the font styles and sizes as they appear in the original document. The ideal candidate for this job would have: - Proficiency in PDF and Word processing tools - Experience with maintaining formatting during content transfer - Attention to detail to ...
...changing (both up and down ) for 20 times per year **T1 transactions Product id Date time Store id **T2 prices New price permanent Data Store is **T3 promotions Product id Store id Promotion price Date promotion start How many days promotion lasts **T4 store lookup table Store id Store state Store city **T5 competitors lookup table Competitor ID Competitor state Competitor city **T6 holidays lookup table USA holiday name USA state holyday Holiday date 1 Holiday date 2 Holiday date 3 ***** Main table to calculate ***** Product id Year Month Day How many sold Price usual Promotion y or n Price promotion Price promotion % to usual Promotion number of days Promotion 1 day before y or n Promotion 2 days before y or n Promotion 3 days b...
