Calculating set prices - Revision history

https://en.wiki.insitu.education/index.php?action=history&feed=atom&title=Calculating_set_prices Calculating set prices - Revision history 2026-04-19T21:12:28Z Revision history for this page on the wiki MediaWiki 1.38.4 https://en.wiki.insitu.education/index.php?title=Calculating_set_prices&diff=407&oldid=prev Julien at 14:24, 3 July 2023 2023-07-03T14:24:07Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:24, 3 July 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l10">Line 10:</td> <td colspan="2" class="diff-lineno">Line 10:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br>Voir le tutoriel vidéo</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br>Voir le tutoriel vidéo</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></p></div></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></p></div></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>''<big>Préambule</big>'''</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'</ins>''<big>Préambule</big>'''</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>You have just installed the set calculation plugin. To use this feature, your supplier must be set up in InSitu. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>You have just installed the set calculation plugin. To use this feature, your supplier must be set up in InSitu. </div></td></tr> </table>

Julien https://en.wiki.insitu.education/index.php?title=Calculating_set_prices&diff=406&oldid=prev Julien at 14:23, 3 July 2023 2023-07-03T14:23:53Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:23, 3 July 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l19">Line 19:</td> <td colspan="2" class="diff-lineno">Line 19:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>''<big>Set up</big>'''</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'</ins>''<big>Set up</big>'''</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>You need to set up the coefficient and the various Set values by going to the menu <b>Setup | Pricing | Sets</b> </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>You need to set up the coefficient and the various Set values by going to the menu <b>Setup | Pricing | Sets</b> </div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l44">Line 44:</td> <td colspan="2" class="diff-lineno">Line 44:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>''<big>Usage</big>'''</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'</ins>''<big>Usage</big>'''</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The feature is accessible through the following drop down menu: <b>Scene | Calculation of set prices</b>. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The feature is accessible through the following drop down menu: <b>Scene | Calculation of set prices</b>. </div></td></tr> </table>

Julien https://en.wiki.insitu.education/index.php?title=Calculating_set_prices&diff=405&oldid=prev Julien: Created page with "<table width="100%"> <tr> <td width="80%" valign="top">  <div align="center"> <p class="cadrevideo"> <youtube width="500" height="300"> https://www.youtube.com/watch?v=1eH6aNwwR4A </youtube> <br>Voir le tutoriel vidéo </p></div> ''<big>Préambule</big>''' You have just installed the set calculation plugin. To use this feature, your supplier must be set up in InSitu. <br/>If it hasn't been done already, add your supplier in the following drop down menu:..." 2023-07-03T14:21:42Z

<p>Created page with "<table width="100%"> <tr> <td width="80%" valign="top">  <div align="center"> <p class="cadrevideo"> <youtube width="500" height="300"> https://www.youtube.com/watch?v=1eH6aNwwR4A </youtube> <br>Voir le tutoriel vidéo </p></div> ''<big>Préambule</big>''' You have just installed the set calculation plugin. To use this feature, your supplier must be set up in InSitu. <br/>If it hasn't been done already, add your supplier in the following drop down menu:..."</p> <p><b>New page</b></p><div><table width="100%"><br /> <tr><br /> <td width="80%" valign="top"><br /> <br /> <div align="center"><br /> <p class="cadrevideo"><br /> <youtube width="500" height="300"><br /> https://www.youtube.com/watch?v=1eH6aNwwR4A<br /> </youtube><br /> <br>Voir le tutoriel vidéo<br /> </p></div><br /> ''<big>Préambule</big>'''<br /> <br /> You have just installed the set calculation plugin. To use this feature, your supplier must be set up in InSitu. <br /> <br/>If it hasn't been done already, add your supplier in the following drop down menu: <b>Setup | Pricing | Suppliers…</b><br /> <br /> Then, add all your supplier's catalogues. <br /> <br /> <br /> <br /> ''<big>Set up</big>'''<br /> <br /> You need to set up the coefficient and the various Set values by going to the menu <b>Setup | Pricing | Sets</b> <br /> <br /> <br /> <div align="center"><br /> <p class="cadreimg"><br /> [[image:Fig.9.0.vendre.set1.jpg|link=]]<br /> </p></div><br /> <br /> The window below will open up. <br /> <br /> <div align="center"><br /> <p class="cadreimg"><br /> [[image:Fig.9.0.vendre.set2.jpg|link=]]<br /> </p></div><br /> <br /> Enter your point values (these are the multiplier coefficients). <br /> Enter the discount value for the set (Net) as a percentage, given by the manufacturer. <br /> Enter the set's sale coefficient. <br /> Choose the default type of set (the smallest gap corresponds to the point difference between the set and the placed articles, which doesn't necessarily correspond to the cheapest but rather the one with the smaller number of unused and additional points). <br /> <br /> Please note that all the values given here are examples. <br /> <br /> <br /> ''<big>Usage</big>'''<br /> <br /> The feature is accessible through the following drop down menu: <b>Scene | Calculation of set prices</b>. <br /> <br /> <div align="center"><br /> <p class="cadreimg"><br /> [[image:Fig.9.0.vendre.set3.jpg|link=]]<br /> </p></div><br /> <br /> <br /> During the first activation of the feature, InSitu will ask you to select the file with the necessary information for calculating the set. <br /> <br /> <br /> <div align="center"><br /> <p class="cadreimg"><br /> [[Image:FichierData.jpg|link=]]<br /> </p></div><br /> <br /> <br /> Click on <b>OK</b>, then select your supplier's CSV in the InSitu installation folder. (By default: c:\InSitu\BlockSets). <br /> <br /> The following window will appear: <br /> <br /> <div align="center"><br /> <p class="cadreimg"><br /> [[Image:Fig.9.0.vendre.set4.jpg|link=]]<br /> </p></div><br /> <br /> <br /> [[Image:1orange.png]] This button allows you to update the values with the new settings of the set. <br /> <br /> <br /> [[Image:2orange.png]] Here, make your <b>Choice of rate</b> for your manufacturer network, thanks to the <b>Add</b> button [[Image:3orange.png]] or <b>Delete</b> [[Image:4orange.png]] .<br /> <br /> <br /> [[Image:5orange.png]] In the <b>Set Selection</b> list, you will find all the sets corresponding to the price and model group placed in your scene, with the best <b>"offered"</b> in relation to the minimum gap between points of the set values and the InSitu quote values.<br /> <br /> To delete the placed set, tick the "Selection" box of the Deactivate the set... line, this will re-update the price as well as all the coefficients. <br /> <br /> <br /> [[Image:6orange.png]] You will find all the <b>Details of the selected set</b> with discounted values or not, per section (furniture, workplan, electric appliances and accessories), of the set and of the InSitu quote. The unused values will appear in red. <br /> <br /> <br /> [[Image:7orange.png]] <b>Applying the discount</b> will show you: <br /> <br /> -that the sale coefficient is equal to 2<br /> <br /> -the <b>maximum discount</b>, which is the difference between the selected set's total and the set's sale price. <br /> <br /> -the value of the <b>applied discount</b> which is the difference between the maximum discount and the unused discount. <br /> <br /> All of this gives us a <b>sale price</b>, which is the difference between the total of the InSitu quote and the applied discount. This sale price can be applied <b>prorata</b> or as a <b>percent discount</b>. <br /> <br /> <br /> [[Image:8orange.png]] By clicking on <b>Advanced</b>, the window will expand to display the details of the calculation in [[Image:9orange.png]] and [[Image:10orange.png]].<br /> <br /> <br /> [[Image:11orange.png]] By clicking on <b>Purchase price</b>, a box will open up to show you the purchase price of the selected set. <br /> <br /> <br /> [[Image:12orange.png]] By clicking on<b>Euro (€)/Points</b>, the<b>Details of selected set</b> table [[Image:6orange.png]] will be displayed in euros or in points. <br /> <br /> <br /> [[Image:13orange.png]] Le bouton The <b>Check</b> button displays a table summarising all the values. <br /> <br /> <div align="center"><br /> <p class="cadreimg"><br /> [[Image:Fig.9.0.vendre.set5.jpg|link=]]<br /> </p></div><br /> <br /> [[Image:14orange.png]] Le bouton The <b>Check Article</b> button displays a table that will allow you to check the whole scene after receiving your acknowledgement of receipt from your supplier. <br /> <br /> <div align="center"><br /> <p class="cadreimg"><br /> [[Image:Fig.9.0.vendre.set6.jpg|link=]]<br /> </p></div><br /> <br /> To do so, you will need to enter the references and the prices of your supplier's offer in the left side. Once you have entered the information, save and check the values. <br /> <br /> Green: same reference and price difference under 1€. <br /> <br /> Blue: same reference and price difference between 1€ and 3€. <br /> <br /> Orange: same reference and price difference over 3€. <br /> <br /> Red: reference not found. <br /> <br /> Selecting the cell of an article in teh scene allows you to directly interact with InSitu in order to replace, modify or delete articles (accessible through a right mouse click on the cell). <br /> <br /> <br /> [[Image:15orange.png]] Le bouton The <b>OK</b> button places the set with the right sale price. The <b>Cancel</b> button closes the window, without changing the previous choices. <br /> <br /> <br /> <br /> <br /> </td><br /> <br /> <td valign="top" width="20%"><br /> <br /> {{:En_Vendre}}<br /> <br /> </td><br /> </tr><br /> </table><br /> <br /> <br /> <span class="btnretour">[[#top|Retour haut de page]]</span>&nbsp; <span class="btnhome">[[Ne pas facturer un article|Etape suivante]]</span></div>

Julien