Expected duration: 1 - 2 weeks Je suis responsable d'une compagnie de spectacle, et nous devons mettre à jour notre document de travail s'apparentant à un document comptable, et nous permet de vendre nos spectacles. Ce document actuel permet : de saisir les différents employées en fonction du spectacle, le nombre de jours travaillé, et la somme global du cout. de calculer la marge de la compagnie. Marge fixe selon le spectacle, et dégressive selon le nombre de jours. de calculer le pourcentage de vente du chargé de production. de rentrer les frais d'activités liés au spectacle : frais de route selon barème fiscal , repas, artifices etc. de calculer le coût de la boîte de production qui nous génère les fiches de paies. et une dernière section résumant tout ça, de façon comptable.
le nouveau document que je voudrais créer doit automatiser ces mêmes tâches selon de nouvèles règles pour simplifier l'utilisation de ce document. par exemple, ayant plusieurs spectacles à vendre je veux, qu'en cliquant sur un menu déroulant, choisir un de mes spectacles et que les artistes se préremplisse automatiquement. un autre menu déroulant pour le nombre de jours. que chaque action impacte bien évidemment le tableur de base.
un autre menu déroulant pour augmenter la marge de la Cie.
je voudrais ensuite que soit généré automatiquement en parallèle de ce document un devis, joli, que je n'ai plus qu'à exporter en pdf. et je voudrais également que soit généré la facture de ce document.
voilà la trame du projet, je peux montrer mon document de travail actuel pour une base de départ. je voudrais qu'il reste personnalisable. format google sheets avec export en pdf. Merci, au plaisir de travailler ensemble.
I am responsible for a performance company, and we need to update our working document, which resembles an accounting document, that allows us to sell our shows. This current document allows: Entering the different employees based on the show, the number of days worked, and the total cost. Calculating the company's margin, which is fixed based on the show and decreases according to the number of days. Calculating the sales percentage for the production manager. Recording the expenses related to the show: travel expenses according to tax guidelines, meals, pyrotechnics, etc. Calculating the cost of the production company that generates the pay slips. A final section summarizing everything in an accounting format. The new document I would like to create should automate these same tasks according to new rules to simplify the use of this document. For example, with several shows to sell, I want a dropdown menu to select one of my shows, and the artists should automatically populate. Another dropdown for the number of days. Each action should obviously impact the main spreadsheet. I also want a dropdown menu to increase the company’s margin. Then, I would like an aesthetically pleasing quote to be automatically generated alongside this document, which I can simply export as a PDF. I would also like the invoice to be generated from this document. This is the outline of the project; I can show my current working document as a starting point. I want it to remain customizable, in Google Sheets format with PDF export. If you need further assistance or specific guidance on how to set up this document in Google Sheets, feel free to ask! Thanks !
On page and off page seo Category: Content Marketing, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, SEO Auditing, SEO Writing Budget: €30 - €250 EUR
05-Apr-2026 21:53 GMT
SketchUp to SolidWorks Parts Conversion Category: 3D CAD, 3D Design, 3D Modelling, CAD / CAM, Manufacturing Design, Mechanical Engineering, SketchUp, Solidworks Budget: $3 - $10 NZD
05-Apr-2026 21:52 GMT
Night sky painting Category: Art Consulting, Art Installation, Creative Design, Graphic Art, Illustration, Oil Painting, Painting, Sketching, Visual Arts, Watercolor Painting Budget: $30 - $250 CAD
05-Apr-2026 21:51 GMT
Job Placement Agency Website Development Category: Content Writing, CSS, HTML, Laravel, PHP, React.js, SEO, UX / User Experience, Web Development, Web Design Budget: ₹1500 - ₹2000 INR
05-Apr-2026 21:50 GMT
Instagram Content Creation & Management Category: Content Creation, Content Writing, Copywriting, Ghostwriting, Graphic Design, Instagram Marketing, Social Media Management, Social Media Marketing Budget: ₹750 - ₹1250 INR
05-Apr-2026 21:49 GMT
Full Stack Developer Needed Category: AngularJS, API Integration, Backend Development, Frontend Development, Full Stack Development, JavaScript, Node.js, NoSQL Couch & Mongo Budget: min $50 AUD
05-Apr-2026 21:49 GMT
H ve Matematik Logo Tasarımı Category: Adobe Illustrator, Photoshop, Graphic Design, Illustration, Logo Design, Vector Design Budget: $10 - $15 USD
05-Apr-2026 21:46 GMT
Boundary Staking for Forms Category: AutoCAD, Building Architecture, Building Regulations, Civil Engineering, Construction Management, Environmental Consulting, Project Management, Structural Engineering Budget: $30 - $250 USD
05-Apr-2026 21:46 GMT
High-Poly Modern Rifle Modeling(blender ) Category: 3D Animation, 3D Art, 3D Design, 3D Graphic Design, 3D Modelling, 3D Printing, 3D Rendering, 3D Visualization, 3ds Max, Blender Budget: $10 - $30 USD
Mixed Data Entry From Online Sources -- 2 Category: Data Analysis, Data Entry, Data Processing, Database Management, Database Programming, Microsoft Access, MySQL, SQL Budget: ₹750 - ₹1250 INR
