I have a google sheet that I would like to generate a price based on different information on different tabs. I have uploaded an excel version of the sheet but the code needs to work in Google Sheets as this is the format of the live version.
There are sizes (column AJ and AK) to work out a square meter size. The minimum chargeable size is 0.3sqm so anything under this size needs to be charged at 0.3 minimum. Column H contains a product code of either "DGU" or "Single".
If DGU is selected then the input information is in columns AL:AQ using the corresponding prices on tab "sealed unit pricing".
If "Single" is selected then the input information is in Columns AR:AT using the corresponding prices on tab "Single sheet pricing".
Finally the line item total calculated from the above would be multiplied by the quantity in column J with the final price input into the column K.
Vizzion Chemicals - Dynamic Web Ordering App Category: CSS, Django, Full Stack Development, HTML, Inventory Management, Invoicing, JavaScript, Mobile App Development, Node.js, SQLite Budget: $10 - $30 USD
12-Sep-2025 04:04 GMT
Biology Literature Review Expert Needed Category: Academic Writing, Biology, Data Analysis, Medical Writing, Research, Research Writing, Scientific Research, Scientific Writing Budget: ₹400 - ₹750 INR
12-Sep-2025 04:04 GMT
Company Sourcing in Morbach, Germany Category: Data Entry, Internet Research, Local Job, Physical Site Survey, Research, Web Search Budget: $30 - $45 USD
12-Sep-2025 04:02 GMT
The Conspiracy of Man Category: 2D Animation, Adobe Premiere Pro, AI Animation, Animation, Caricature & Cartoons, Illustration, Motion Graphics, Video Editing, Video Production Budget: $250 - $750 USD
Custom Resin Bobble Head Category: 3D Animation, 3D CAD, 3D Design, 3D Drafting, 3D Modelling, 3D Printing, 3D Rendering, 3ds Max Budget: $250 - $750 USD
12-Sep-2025 03:58 GMT
OpenAI Voice-to-Voice Integration Category: AI Development, AI Model Integration, API Integration, Audio Services, OpenAI, Python, Software Architecture, Speech Synthesis, Voice Synthesis, Voice Talent Budget: ₹600 - ₹1500 INR
SEO Setup for Traffic Growth Category: Content Strategy, Google Analytics, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, Website Optimization Budget: $8 - $15 USD
12-Sep-2025 03:55 GMT
Brain MRI Volumetry Research Category: Data Analysis, Data Processing, Excel, Image Processing, Machine Learning (ML), Medical Research, SPSS Statistics, Statistics Budget: $2 - $8 USD
........... Category: Business Intelligence, Data Analysis, Data Analytics, Data Management, Data Modeling, Data Processing, Data Visualization, Power BI Budget: $30 - $250 USD
12-Sep-2025 03:53 GMT
Live-Action Brand Showcase Video Category: After Effects, Animation, Color Grading, Commercials, Logo Animation, Sound Design, Video Editing, Video Production, Video Services, Visual Effects Budget: ₹1500 - ₹12500 INR
12-Sep-2025 03:52 GMT
TikTok Short Video Editing Needed Category: Adobe Premiere Pro, After Effects, DaVinci Resolve, TikTok, Video Editing, Video Post Editing, Video Production, Video Services Budget: ₹12500 - ₹37500 INR