+ Reply to Thread
Results 1 to 18 of 18

Where can I find an Excell spreadsheet that will work out price per square meter in mm?

  1. #1
    Registered User
    Join Date
    03-25-2021
    Location
    Gozo, Malta
    MS-Off Ver
    Excel 16.47.1 for Mac
    Posts
    10

    Where can I find an Excell spreadsheet that will work out price per square meter in mm?

    Hi, I need to be able to produce a table showing the price per square meter showing in 50mm increments.

    I need to be able to enter minimum and maximum width and height in millimetres and a price per square meter and have it populate the table with the prices and sizes.

    I am useless at Excel but im told it can easily do it.
    Doesn't anyone have such a spreadsheet or know where I can download one please?

    Joseph
    p.s. Im using a Mac

  2. #2
    Registered User
    Join Date
    03-25-2021
    Location
    Gozo, Malta
    MS-Off Ver
    Excel 16.47.1 for Mac
    Posts
    10

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    So this is an example of a table output calculated on the basis of
    £450 per square meter with the width and height sizes in millimetres.

    I need to be able to output something like this by entering the minimum and maximum heights and widths in millimetres in to the spreadsheet and having it create a table that goes up in 50 millimetres increments and gives the price in the format shown in the example table below:



    400 450 500 550 600 650 700 750 800 850 900 950 1000 1050 1100 1150 1200 1250 1300 1350 1400 1450 1500 1550 1600 1650 1700 1750 1800 1850 1900 1950 2000 2050 2100 2150 2200 2250 2300 2350 2400 2450 2500
    700 126 141,75 157,5 173,25 189 204,75 220,5 236,25 252 267,75 283,5 299,25 315 330,75 346,5 362,25 378 393,75 409,5 425,25 441 456,75 472,5 488,25 504 519,75 535,5 551,25 567 582,75 598,5 614,25 630 645,75 661,5 677,25 693 708,75 724,5 740,25 756 771,75 787,5
    750 135 151,875 168,75 185,625 202,5 219,375 236,25 253,125 270 286,875 303,75 320,625 337,5 354,375 371,25 388,125 405 421,875 438,75 455,625 472,5 489,375 506,25 523,125 540 556,875 573,75 590,625 607,5 624,375 641,25 658,125 675 691,875 708,75 725,625 742,5 759,375 776,25 793,125 810 826,875 843,75
    800 144 162 180 198 216 234 252 270 288 306 324 342 360 378 396 414 432 450 468 486 504 522 540 558 576 594 612 630 648 666 684 702 720 738 756 774 792 810 828 846 864 882 900
    850 153 172,125 191,25 210,375 229,5 248,625 267,75 286,875 306 325,125 344,25 363,375 382,5 401,625 420,75 439,875 459 478,125 497,25 516,375 535,5 554,625 573,75 592,875 612 631,125 650,25 669,375 688,5 707,625 726,75 745,875 765 784,125 803,25 822,375 841,5 860,625 879,75 898,875 918 937,125 956,25
    900 162 182,25 202,5 222,75 243 263,25 283,5 303,75 324 344,25 364,5 384,75 405 425,25 445,5 465,75 486 506,25 526,5 546,75 567 587,25 607,5 627,75 648 668,25 688,5 708,75 729 749,25 769,5 789,75 810 830,25 850,5 870,75 891 911,25 931,5 951,75 972 992,25 1012,5
    950 171 192,375 213,75 235,125 256,5 277,875 299,25 320,625 342 363,375 384,75 406,125 427,5 448,875 470,25 491,625 513 534,375 555,75 577,125 598,5 619,875 641,25 662,625 684 705,375 726,75 748,125 769,5 790,875 812,25 833,625 855 876,375 897,75 919,125 940,5 961,875 983,25 1004,625 1026 1047,375 1068,75
    1000 180 202,5 225 247,5 270 292,5 315 337,5 360 382,5 405 427,5 450 472,5 495 517,5 540 562,5 585 607,5 630 652,5 675 697,5 720 742,5 765 787,5 810 832,5 855 877,5 900 922,5 945 967,5 990 1012,5 1035 1057,5 1080 1102,5 1125
    1050 189 212,625 236,25 259,875 283,5 307,125 330,75 354,375 378 401,625 425,25 448,875 472,5 496,125 519,75 543,375 567 590,625 614,25 637,875 661,5 685,125 708,75 732,375 756 779,625 803,25 826,875 850,5 874,125 897,75 921,375 945 968,625 992,25 1015,875 1039,5 1063,125 1086,75 1110,375 1134 1157,625 1181,25
    1100 198 222,75 247,5 272,25 297 321,75 346,5 371,25 396 420,75 445,5 470,25 495 519,75 544,5 569,25 594 618,75 643,5 668,25 693 717,75 742,5 767,25 792 816,75 841,5 866,25 891 915,75 940,5 965,25 990 1014,75 1039,5 1064,25 1089 1113,75 1138,5 1163,25 1188 1212,75 1237,5
    1150 207 232,875 258,75 284,625 310,5 336,375 362,25 388,125 414 439,875 465,75 491,625 517,5 543,375 569,25 595,125 621 646,875 672,75 698,625 724,5 750,375 776,25 802,125 828 853,875 879,75 905,625 931,5 957,375 983,25 1009,125 1035 1060,875 1086,75 1112,625 1138,5 1164,375 1190,25 1216,125 1242 1267,875 1293,75
    1200 216 243 270 297 324 351 378 405 432 459 486 513 540 567 594 621 648 675 702 729 756 783 810 837 864 891 918 945 972 999 1026 1053 1080 1107 1134 1161 1188 1215 1242 1269 1296 1323 1350
    1250 225 253,125 281,25 309,375 337,5 365,625 393,75 421,875 450 478,125 506,25 534,375 562,5 590,625 618,75 646,875 675 703,125 731,25 759,375 787,5 815,625 843,75 871,875 900 928,125 956,25 984,375 1012,5 1040,625 1068,75 1096,875 1125 1153,125 1181,25 1209,375 1237,5 1265,625 1293,75 1321,875 1350 1378,125 1406,25
    1300 234 263,25 292,5 321,75 351 380,25 409,5 438,75 468 497,25 526,5 555,75 585 614,25 643,5 672,75 702 731,25 760,5 789,75 819 848,25 877,5 906,75 936 965,25 994,5 1023,75 1053 1082,25 1111,5 1140,75 1170 1199,25 1228,5 1257,75 1287 1316,25 1345,5 1374,75 1404 1433,25 1462,5
    1350 243 273,375 303,75 334,125 364,5 394,875 425,25 455,625 486 516,375 546,75 577,125 607,5 637,875 668,25 698,625 729 759,375 789,75 820,125 850,5 880,875 911,25 941,625 972 1002,375 1032,75 1063,125 1093,5 1123,875 1154,25 1184,625 1215 1245,375 1275,75 1306,125 1336,5 1366,875 1397,25 1427,625 1458 1488,375 1518,75
    1400 252 283,5 315 346,5 378 409,5 441 472,5 504 535,5 567 598,5 630 661,5 693 724,5 756 787,5 819 850,5 882 913,5 945 976,5 1008 1039,5 1071 1102,5 1134 1165,5 1197 1228,5 1260 1291,5 1323 1354,5 1386 1417,5 1449 1480,5 1512 1543,5 1575
    1450 261 293,625 326,25 358,875 391,5 424,125 456,75 489,375 522 554,625 587,25 619,875 652,5 685,125 717,75 750,375 783 815,625 848,25 880,875 913,5 946,125 978,75 1011,375 1044 1076,625 1109,25 1141,875 1174,5 1207,125 1239,75 1272,375 1305 1337,625 1370,25 1402,875 1435,5 1468,125 1500,75 1533,375 1566 1598,625 1631,25
    1500 270 303,75 337,5 371,25 405 438,75 472,5 506,25 540 573,75 607,5 641,25 675 708,75 742,5 776,25 810 843,75 877,5 911,25 945 978,75 1012,5 1046,25 1080 1113,75 1147,5 1181,25 1215 1248,75 1282,5 1316,25 1350 1383,75 1417,5 1451,25 1485 1518,75 1552,5 1586,25 1620 1653,75 1687,5
    1550 279 313,875 348,75 383,625 418,5 453,375 488,25 523,125 558 592,875 627,75 662,625 697,5 732,375 767,25 802,125 837 871,875 906,75 941,625 976,5 1011,375 1046,25 1081,125 1116 1150,875 1185,75 1220,625 1255,5 1290,375 1325,25 1360,125 1395 1429,875 1464,75 1499,625 1534,5 1569,375 1604,25 1639,125 1674 1708,875 1743,75
    1600 288 324 360 396 432 468 504 540 576 612 648 684 720 756 792 828 864 900 936 972 1008 1044 1080 1116 1152 1188 1224 1260 1296 1332 1368 1404 1440 1476 1512 1548 1584 1620 1656 1692 1728 1764 1800
    1650 297 334,125 371,25 408,375 445,5 482,625 519,75 556,875 594 631,125 668,25 705,375 742,5 779,625 816,75 853,875 891 928,125 965,25 1002,375 1039,5 1076,625 1113,75 1150,875 1188 1225,125 1262,25 1299,375 1336,5 1373,625 1410,75 1447,875 1485 1522,125 1559,25 1596,375 1633,5 1670,625 1707,75 1744,875 1782 1819,125 1856,25
    1700 306 344,25 382,5 420,75 459 497,25 535,5 573,75 612 650,25 688,5 726,75 765 803,25 841,5 879,75 918 956,25 994,5 1032,75 1071 1109,25 1147,5 1185,75 1224 1262,25 1300,5 1338,75 1377 1415,25 1453,5 1491,75 1530 1568,25 1606,5 1644,75 1683 1721,25 1759,5 1797,75 1836 1874,25 1912,5
    1750 315 354,375 393,75 433,125 472,5 511,875 551,25 590,625 630 669,375 708,75 748,125 787,5 826,875 866,25 905,625 945 984,375 1023,75 1063,125 1102,5 1141,875 1181,25 1220,625 1260 1299,375 1338,75 1378,125 1417,5 1456,875 1496,25 1535,625 1575 1614,375 1653,75 1693,125 1732,5 1771,875 1811,25 1850,625 1890 1929,375 1968,75
    1800 324 364,5 405 445,5 486 526,5 567 607,5 648 688,5 729 769,5 810 850,5 891 931,5 972 1012,5 1053 1093,5 1134 1174,5 1215 1255,5 1296 1336,5 1377 1417,5 1458 1498,5 1539 1579,5 1620 1660,5 1701 1741,5 1782 1822,5 1863 1903,5 1944 1984,5 2025
    Attached Files Attached Files

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    With the price per sq m in A1, B2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copied across and down
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    03-25-2021
    Location
    Gozo, Malta
    MS-Off Ver
    Excel 16.47.1 for Mac
    Posts
    10

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    I tried to Google how to do this but im lost.
    I have manually made an Excel worksheet (is that the right word?) with the sizes written in going across and down,
    I clicked on the area in the header whee you enter values and pasted your formula (I didn't understand it, I don't see where the £450 value is in the equation or ho I would change that for another clculation, but one step at a time...)
    I then did a CTRL A to select everything and pressed enter.
    But it didn't do anything...?

    Here is the worksheet with the sizes manually entered...
    Attached Files Attached Files
    Last edited by GozoDirectory; 03-26-2021 at 06:39 AM.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    I have completed your sheet using Trevor's formula so that you can see exactly what he meant. You can change the rate in A1 (highlighted in yellow) and see how the prices in your matrix change.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  6. #6
    Registered User
    Join Date
    03-25-2021
    Location
    Gozo, Malta
    MS-Off Ver
    Excel 16.47.1 for Mac
    Posts
    10

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    Well that has done something, thank you.
    I will work it all out, the example I had in the original table used commas, so I guess to achieve this I would just put 450,00 in the first box?

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    It is regional settings that you will need to adjust. In the US, we use decimal points. That is why it defaulted that way. Check your regional settings. Can't help any further as I am in the US and running a Windows machine. Have no knowledge of how a MAC reacts or sets up.

  8. #8
    Registered User
    Join Date
    03-25-2021
    Location
    Gozo, Malta
    MS-Off Ver
    Excel 16.47.1 for Mac
    Posts
    10

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    Im really sorry but you seem to have made a table using the original example rather than the 2nd table I uploaded (Called sizes-table) that I need to calculate?

    Is there a version where I can enter the minimum and maximum sizes in millimetres for width and height and the price per square meter and have it create the populated table with the sizes going up in 50mm increments like the example?

    I can't seem to get it to work on the one I made with the correct sizes ( and I need to work out about about 9 of these...)
    Last edited by GozoDirectory; 03-26-2021 at 07:06 AM.

  9. #9
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    Works the same as in my example. Put 450 in A1. Then place Trevor's formula in B2. Then copy B2 down to B26 and across to the last column. Change the value in A1 and see how the pricing changes in your matrix.

  10. #10
    Registered User
    Join Date
    03-25-2021
    Location
    Gozo, Malta
    MS-Off Ver
    Excel 16.47.1 for Mac
    Posts
    10

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    Im trying to get a version that I can change the min and max width and height and the price per square meter so that I can calculate the following:






    calculation 1 - £570 per m2.
    Width: 1000 mm - 3000 mm (in 50mm increments)
    Height: 800 mm - 2000 mm (in 50mm increments)

    calculation 2 - £798 per m2.
    Width: 1100 mm - 2500 mm (in 50mm increments)
    Height: 700 mm - 1900 mm (in 50mm increments)

    calculation 3 - £1,037.40 per m2.
    Width: 900 mm - 2200 mm (in 50mm increments)
    Height: 700 mm - 1900 mm (in 50mm increments)

    calculation 4 - £1,296.75 per m2.
    Width: 1100 mm - 2200 mm (in 50mm increments)
    Height: 1400 mm - 2600 mm (in 50mm increments)

    calculation 5 - £390 per m2.
    Width: 800 mm - 1100 mm (in 50mm increments)
    Height: 1900 mm - 2400 mm (in 50mm increments)

    calculation 6 - £350 per m2.
    Width: 1100 mm - 1800 mm (in 50mm increments)
    Height: 2000 mm - 2400 mm (in 50mm increments)


    calculation 7 - £450 per m2.
    Width: 1500 mm - 2800 mm (in 50mm increments)
    Height: 1800 mm - 2400 mm (in 50mm increments)





    I will later have another 3 that I may need to calculate - this is why I was looking for something that would work them out for me if possible.

  11. #11
    Registered User
    Join Date
    03-25-2021
    Location
    Gozo, Malta
    MS-Off Ver
    Excel 16.47.1 for Mac
    Posts
    10

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    Ah ok, now im getting somewhere, that worked thank you.

    So I can at least manually make a table for each one now if I can't get a template that will generate the table for me from the min and max sizes and the price...

    I tried to give you another reputation to thank you for your continued help, but it wouldn't let me sorry...

  12. #12
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    This has a calculator AND a Table

    The row and column headings have formulae to calculate the values (see the Notes)
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    03-25-2021
    Location
    Gozo, Malta
    MS-Off Ver
    Excel 16.47.1 for Mac
    Posts
    10

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    agh... that is so tantalisingly close to what I have been looking for.
    I need to be able to enter a minimum width and a maximum width in millimetres and and a minimum height and a maximum height in millimetres, and a price per square meter and have it create and populate the table in 50mm increments automatically.

    Then I can simply enter the min and max sizes and price per square meter and have it generate a new table with the correct prices and sizes in and copy the whole table each time...

    Can the one you made be edited to do that?

  14. #14
    Registered User
    Join Date
    03-25-2021
    Location
    Gozo, Malta
    MS-Off Ver
    Excel 16.47.1 for Mac
    Posts
    10

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    Thank you to everyone who helped me to achieve the ability to manually create tables that calculate prices per square meter.

  15. #15
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    Please see the attached updated example. Hopefully this is what you are looking for. Experiment with all the parameters and see how the table changes.
    Attached Files Attached Files

  16. #16
    Registered User
    Join Date
    03-25-2021
    Location
    Gozo, Malta
    MS-Off Ver
    Excel 16.47.1 for Mac
    Posts
    10

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    Thank you that is perfect

  17. #17
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    You're welcome.

  18. #18
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Where can I find an Excell spreadsheet that will work out price per square meter in mm

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cubic square meter & Square meters total from meter lengths
    By wavikerz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2017, 10:20 AM
  2. HELP! on a price grid with using square footage
    By sweetlou26 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-30-2016, 04:30 PM
  3. How to automatically add square meter m2
    By TwistedEndz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-15-2016, 10:16 PM
  4. Replies: 1
    Last Post: 08-12-2010, 05:00 PM
  5. [SOLVED] GAS meter spreadsheet
    By Chris in forum Excel General
    Replies: 5
    Last Post: 11-27-2005, 10:00 AM
  6. Can I use excell to draw a rectangle and come up with square feet
    By Paul in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-12-2005, 10:07 PM
  7. how do I display "meter square" symbol in a formula cell ?
    By lau in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-28-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1