Month: October 2024
皇家国际开户-17300435119
Web 数据库的概念：Web 数据库是指通过互联网或内联网可以访问的数据库系统。它将传统的数据库技术与 Web 技术相结合，使得用户可以通过浏览器等 Web 客户端访问数据库中的数据，并进行查询、插入、更新和删除等操作。 Read More
Problem installing 365 Family apps.
Hallo,
I have added someone to my new office365 family account.
After uninstalling the apps from the family members Office365 personal account I restarted the computer and accepted the invite to the family group. I also canceled the recurring billing on said family members 365 personal account.
When trying to install the apps, the install screen keeps defaulting to the personal 365 plan encouraging the family member to renew the cancelled subscription.
How can I get around this? We purchased a family subscriptions for all the benefits that it offers but are not able to use it. We do not want to extend personal subscriptions and I want to install the apps that family members have access to through the family subscription.
Thank you in advance.
Hallo, I have added someone to my new office365 family account. After uninstalling the apps from the family members Office365 personal account I restarted the computer and accepted the invite to the family group. I also canceled the recurring billing on said family members 365 personal account. When trying to install the apps, the install screen keeps defaulting to the personal 365 plan encouraging the family member to renew the cancelled subscription. How can I get around this? We purchased a family subscriptions for all the benefits that it offers but are not able to use it. We do not want to extend personal subscriptions and I want to install the apps that family members have access to through the family subscription. Thank you in advance. Read More
Confused by Contact lists vs folders vs groups
Hi
1) what is the difference between contact folders and contact lists
2) what is the difference between contact lists and groups
3) MOST IMPORTANT: how to access contact lists via Graph API (I do not see that topic in the documentation).
Thanks in advance.
Hi1) what is the difference between contact folders and contact lists2) what is the difference between contact lists and groups3) MOST IMPORTANT: how to access contact lists via Graph API (I do not see that topic in the documentation).Thanks in advance. Read More
Overlaping of worktimes
ABCDEFStart of overtimeEnd of overtimeTotal overtimeStart of Stand-byEnd of Stand-byTotal Standby0:001:3027:0019:00127:0020:00137:0019:00020:0023:50419:000:0015:008:3047:0019:0010 7:0019:0012
Hello,
above is example sheet that I use for workers. This is part with standby and overtime, and I need to decrease time of Total Standby with hours of Total overtime only if times overlap, like in table above (if worker is on overtime for 30 and more minutes it is counted as full hour). Overtime can be any hour between 0 – 24h because worker can be called at any time for work in case of emergency (firefighters), but standby is entered only in this way (each row represent new day):
DEFStart of Stand-byEnd of Stand-byTotal Standby19:000:0050:007:0077:0019:0012
ABCDEFStart of overtimeEnd of overtimeTotal overtimeStart of Stand-byEnd of Stand-byTotal Standby0:001:3027:0019:00127:0020:00137:0019:00020:0023:50419:000:0015:008:3047:0019:0010 7:0019:0012 Hello,above is example sheet that I use for workers. This is part with standby and overtime, and I need to decrease time of Total Standby with hours of Total overtime only if times overlap, like in table above (if worker is on overtime for 30 and more minutes it is counted as full hour). Overtime can be any hour between 0 – 24h because worker can be called at any time for work in case of emergency (firefighters), but standby is entered only in this way (each row represent new day):DEFStart of Stand-byEnd of Stand-byTotal Standby19:000:0050:007:0077:0019:0012 Read More
Vulnerability Management – Baselines assessment
We are currently evaluating Vulnerability Management to report on our CIS 2.0 compliance.
In a Domain Controller profile the Password Policy checks appear to be incorrect.
For example: 1.1.5 – (L1) Ensure ‘Password must meet complexity requirements’ is set to ‘Enabled’
says “Not compliant”, although we have it enabled in the “Default Domain Policy”, which is the one controlling domain users password policy.
What policy does it check?
It is as if it checks the RSOP that affects the DCs. But DCs do not have local users. 🤔
We are currently evaluating Vulnerability Management to report on our CIS 2.0 compliance. In a Domain Controller profile the Password Policy checks appear to be incorrect. For example: 1.1.5 – (L1) Ensure ‘Password must meet complexity requirements’ is set to ‘Enabled’says “Not compliant”, although we have it enabled in the “Default Domain Policy”, which is the one controlling domain users password policy. What policy does it check?It is as if it checks the RSOP that affects the DCs. But DCs do not have local users. 🤔 Read More
Using Compliance Search Purge Actions to Remove Mailbox Items
Compliance search purge actions are Microsoft’s search and purge tool. Today, a purge action is limited to removing 10 items per mailbox. Microsoft is increasing the limit to 100 as part of its eDiscovery modernization project. This article reviews the state of the art for using PowerShell to purge mailbox items and contemplates how purges might work after modernization finishes.
https://practical365.com/compliance-search-purge/
Compliance search purge actions are Microsoft’s search and purge tool. Today, a purge action is limited to removing 10 items per mailbox. Microsoft is increasing the limit to 100 as part of its eDiscovery modernization project. This article reviews the state of the art for using PowerShell to purge mailbox items and contemplates how purges might work after modernization finishes.
https://practical365.com/compliance-search-purge/ Read More
How to use the new SharePoint start experience
The new SharePoint start experience makes easier the creation of pages.
Now you can have a central place where you can draft your pages, collaborate and publish where you want.
During the drafting experience the page will be stored on OneDrive.
The new SharePoint start experience makes easier the creation of pages.
Now you can have a central place where you can draft your pages, collaborate and publish where you want.
During the drafting experience the page will be stored on OneDrive. Read More
Choosing Tasks by Type
Relatively new to MS Project. I am working on a construction schedule and I want to differentiate the tasks within each section by color, as per the image (orange for one section, blue for the other). Rather than simply recoloring the blue tasks orange (which I am currently doing), is there a way in which I can create a new task and different the orange and blue not by just recoloring but by actual task type?
Relatively new to MS Project. I am working on a construction schedule and I want to differentiate the tasks within each section by color, as per the image (orange for one section, blue for the other). Rather than simply recoloring the blue tasks orange (which I am currently doing), is there a way in which I can create a new task and different the orange and blue not by just recoloring but by actual task type? Read More
Best method to transfer large file from android phone to computer?
Hi,
I’m looking for advice on how to transfer large files from my Android phone to my Windows PC. I’ve tried a few basic methods, but they seem either too slow or unsuitable for larger files (over 4 GB). I’d like to know what the best options are that can handle bigger file sizes efficiently.
So far, I’ve tried using bluetooth to transfer large file from android phone to computer, but I’ve encountered issues when the files are too large. I’m also curious about using wireless methods like AirDrop or Wi-Fi, but I’m unsure if they are suitable for such large files. Some cloud storage options have worked for smaller files, but they seem slow for transferring very large ones.
I would appreciate any recommendations for software, apps, or alternative methods that can make this process easier and faster. Your help will be greatly appreciated as I’m planning to transfer some important work files.
Hi, I’m looking for advice on how to transfer large files from my Android phone to my Windows PC. I’ve tried a few basic methods, but they seem either too slow or unsuitable for larger files (over 4 GB). I’d like to know what the best options are that can handle bigger file sizes efficiently. So far, I’ve tried using bluetooth to transfer large file from android phone to computer, but I’ve encountered issues when the files are too large. I’m also curious about using wireless methods like AirDrop or Wi-Fi, but I’m unsure if they are suitable for such large files. Some cloud storage options have worked for smaller files, but they seem slow for transferring very large ones. I would appreciate any recommendations for software, apps, or alternative methods that can make this process easier and faster. Your help will be greatly appreciated as I’m planning to transfer some important work files. Read More
Export Images from MS-List to Excel (Macros)
Until about 1-2 months ago, I could easily export images from MS lists to an Excel spreadsheet with macros. I downloaded the list of images as a CSV and imported it into Excel. The images were stored in a SiteAssets folder in SharePoint, which I could easily extract the imges from the folder using the image names in the CSV and VBA code and import them into Excel. Now the images in the new entries have completely different names and they no longer appear in the folder. Is there another or new way to import the images using VBA code? Inserting everything manually takes far too long and is not worth the effort.
Until about 1-2 months ago, I could easily export images from MS lists to an Excel spreadsheet with macros. I downloaded the list of images as a CSV and imported it into Excel. The images were stored in a SiteAssets folder in SharePoint, which I could easily extract the imges from the folder using the image names in the CSV and VBA code and import them into Excel. Now the images in the new entries have completely different names and they no longer appear in the folder. Is there another or new way to import the images using VBA code? Inserting everything manually takes far too long and is not worth the effort. Read More
Converting Periodic Data to Quarterly Data
hi,
As seen in the attached example file, I obtain quarterly data in the range “C179:T214” by manually processing the periodic data in the range “AA179:AV214”.
Quarterly data is obtained as follows: “IF(RIGHT(Quarter date; 1) = “3”; write as is; otherwise subtract from previous)”
Quarterly Data:
1- array formula to do the entire row at once.
2- Using an array formula for the entire block.
2024/62024/32023/122023/92023/62023/32022/122022/92022/62022/32021/122021/92021/62021/32020/122020/92020/62020/32019/12 USD 32,83 32,29 29,44 27,38 25,82 19,15 18,70 18,52 16,66 14,64 13,33 8,88 8,68 8,33 7,42 7,75 6,84 6,57 5,94 6 6 1000 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Dönemlik Finansal TabloitemDescEng2024/62024/32023/122023/92023/62023/32022/122022/92022/62022/32021/122021/92021/62021/32020/122020/92020/62020/32019/122019/92019/62019/63BSürdürülen Faaliyetler – – – – – – – – – – – – – – – – – – 3B Sürdürülen Faaliyetler Continuing Operations – – – – – – – – – – – – – – – – – – – – – – 3CSatış Gelirleri 3.328.221 3.484.238 4.919.580- 509.910 3.930.608 5.016.264 9.446.445 2.223.218 2.048.771 1.866.076 1.543.730 1.966.237 1.977.264 1.861.881 2.063.393 1.749.195 2.049.991 1.917.562 3C Satış Gelirleri Net Sales 221.742.860.000 112.490.019.000 328.441.924.000 183.618.341.000 197.577.993.000 96.077.514.000 279.252.910.000 102.620.448.000 61.449.339.000 27.313.940.000 70.698.507.000 50.122.131.000 32.664.892.000 15.501.646.000 55.495.364.000 40.186.226.000 26.626.115.000 12.597.616.000 40.211.942.000 29.683.016.000 19.270.728.000 9.025.282.0003CASatışların Maliyeti (-)- 2.770.361- 2.884.688- 4.369.355 690.205- 3.314.184- 4.252.363- 8.185.675- 1.830.365- 1.679.443- 1.519.856- 1.235.962- 1.596.628- 1.605.969- 1.519.180- 1.677.107- 1.425.250- 1.673.784- 1.587.612 3CA Satışların Maliyeti (-) Cost Of Sales – 184.073.751.000- 93.133.311.000- 276.759.269.000- 148.133.330.000- 167.028.867.000- 81.446.368.000- 237.182.345.000- 84.124.131.000- 50.228.152.000- 22.246.287.000- 57.238.477.000- 40.764.341.000- 26.588.682.000- 12.648.389.000- 45.375.969.000- 32.932.838.000- 21.884.018.000- 10.429.978.000- 33.226.484.000- 24.493.133.000- 15.928.955.000- 7.488.411.0003CAATicari Faaliyetlerden Diğer Kar (Zarar) – – – – – – – – – – – – – – – – – – 3CAA Ticari Faaliyetlerden Diğer Kar (Zarar) Other Profit (Loss) from Trade Operations – – – – – – – – – – – – – – – – – – – – – – 3CABTicari Faaliyetlerden Brüt Kar (Zarar) 557.859 599.550 550.225 180.295 616.424 763.901 1.260.770 392.853 369.329 346.220 307.768 369.610 371.295 342.701 386.286 323.946 376.207 329.950 3CAB Ticari Faaliyetlerden Brüt Kar (Zarar) Gross Profit (Loss) from Trade Operations 37.669.109.000 19.356.708.000 51.682.655.000 35.485.011.000 30.549.126.000 14.631.146.000 42.070.565.000 18.496.317.000 11.221.187.000 5.067.653.000 13.460.030.000 9.357.790.000 6.076.210.000 2.853.257.000 10.119.395.000 7.253.388.000 4.742.097.000 2.167.638.000 6.985.458.000 5.189.883.000 3.341.773.000 1.536.871.0003CACFaiz, Ücret, Prim, Komisyon ve Diğer Gelirler – – – – – – – – – – – – – – – – – – 3CAC Faiz, Ücret, Prim, Komisyon ve Diğer Gelirler Proceeds from Interest, Fee, Premium, Commission and Other – – – – – – – – – – – – – – – – – – – – – – 3CADFaiz, Ücret, Prim, Komisyon ve Diğer Giderler (-) – – – – – – – – – – – – – – – – – – 3CAD Faiz, Ücret, Prim, Komisyon ve Diğer Giderler (-) Expenses from Interest, Fee, Premium, Commission and Other – – – – – – – – – – – – – – – – – – – – – – 3CAEFinans Sektörü Faaliyetlerinden Diğer Kar (Zarar) – – – – – – – – – – – – – – – – – – 3CAE Finans Sektörü Faaliyetlerinden Diğer Kar (Zarar) Other Profit (Loss) from Financial Operations – – – – – – – – – – – – – – – – – – – – – – 3CAFFinans Sektörü Faaliyetlerinden Brüt Kar (Zarar) – – – – – – – – – – – – – – – – – – 3CAF Finans Sektörü Faaliyetlerinden Brüt Kar (Zarar) Gross Profit (Loss) from Financial Operations – – – – – – – – – – – – – – – – – – – – – – 3CBDiğer Gelir ve Giderler – – – – – – – – – – – – – – – – – – 3CB Diğer Gelir ve Giderler Other Income (Expenses) – – – – – – – – – – – – – – – – – – – – – – 3DBRÜT KAR (ZARAR) 557.859 599.550 550.225 180.295 616.424 763.901 1.260.770 392.853 369.329 346.220 307.768 369.610 371.295 342.701 386.286 323.946 376.207 329.950 3D BRÜT KAR (ZARAR) GROSS PROFIT (LOSS) 37.669.109.000 19.356.708.000 51.682.655.000 35.485.011.000 30.549.126.000 14.631.146.000 42.070.565.000 18.496.317.000 11.221.187.000 5.067.653.000 13.460.030.000 9.357.790.000 6.076.210.000 2.853.257.000 10.119.395.000 7.253.388.000 4.742.097.000 2.167.638.000 6.985.458.000 5.189.883.000 3.341.773.000 1.536.871.0003DAPazarlama, Satış ve Dağıtım Giderleri (-)- 487.773- 483.917- 704.942 154.453- 505.536- 659.724- 1.163.325- 242.820- 210.246- 199.556- 161.434- 219.372- 218.755- 203.668- 197.798- 188.778- 202.236- 196.890 3DA Pazarlama, Satış ve Dağıtım Giderleri (-) Marketing Selling & Distrib. Expenses (-) – 31.635.210.000- 15.623.469.000- 42.214.147.000- 21.461.916.000- 25.690.330.000- 12.635.826.000- 32.672.797.000- 10.920.605.000- 6.423.903.000- 2.920.915.000- 7.694.012.000- 5.542.256.000- 3.594.560.000- 1.695.699.000- 5.608.409.000- 4.140.870.000- 2.677.427.000- 1.293.486.000- 4.278.730.000- 3.171.389.000- 2.049.581.000- 977.311.0003DBGenel Yönetim Giderleri (-)- 70.410- 76.151- 99.853 24.003- 77.440- 95.420- 134.132- 29.317- 26.277- 27.226- 16.775- 30.566- 29.549- 28.951- 30.703- 24.458- 27.481- 31.754 3DB Genel Yönetim Giderleri (-) General Administrative Expenses (-) – 4.769.889.000- 2.458.581.000- 6.109.712.000- 3.170.224.000- 3.827.341.000- 1.827.600.000- 3.887.274.000- 1.379.235.000- 836.329.000- 398.514.000- 992.509.000- 768.912.000- 497.533.000- 241.041.000- 814.075.000- 586.276.000- 396.669.000- 208.609.000- 640.439.000- 471.751.000- 314.712.000- 157.070.0003DCAraştırma ve Geliştirme Giderleri (-) – – – – – – – – – – – – – – – – – – 3DC Araştırma ve Geliştirme Giderleri (-) Research & Development Expenses (-) – – – – – – – – – – – – – – – – – – – – – – 3DDDiğer Faaliyet Gelirleri 7.108 8.144 23.754- 3.008 28.760 7.698 21.336 4.902 5.575 4.755 2.768 4.418 3.995 4.246 4.592 4.847 2.737 2.848 3DD Diğer Faaliyet Gelirleri Income from Other Operations 496.274.000 262.930.000 1.507.063.000 807.775.000 890.114.000 147.439.000 652.216.000 253.263.000 162.492.000 69.601.000 146.143.000 109.250.000 70.023.000 35.349.000 109.085.000 75.013.000 37.437.000 18.707.000 73.808.000 44.729.000 28.648.000 12.818.0003DEDiğer Faaliyet Giderleri (-)- 2.479- 7.305- 19.293 2.946- 4.427- 15.880- 15.184- 1.279- 2.310- 1.031- 58.695- 719- 476- 421- 1.064- 999- 242- 479 3DE Diğer Faaliyet Giderleri (-) Expenses from Other Operations (-) – 317.226.000- 235.856.000- 905.780.000- 337.823.000- 418.488.000- 304.157.000- 361.172.000- 77.266.000- 53.572.000- 15.088.000- 796.370.000- 14.022.000- 7.639.000- 3.508.000- 20.440.000- 12.543.000- 4.798.000- 3.144.000- 18.034.000- 12.062.000- 8.755.000- 3.743.0003DEAFaaliyet Karı Öncesi Diğer Gelir ve Giderler – – – – – – – – – – – – – – – – – – 3DEA Faaliyet Karı Öncesi Diğer Gelir ve Giderler Other Income (Expenses) Before Operating Profits – – – – – – – – – – – – – – – – – – – – – – 3DFFAALİYET KARI (ZARARI) 4.305 40.320- 250.108 358.690 57.781 574- 30.534 124.339 136.071 123.162 73.631 123.371 126.510 113.906 161.313 114.557 148.985 103.675 3DF FAALİYET KARI (ZARARI) OPERATING PROFITS 1.443.058.000 1.301.732.000 3.960.079.000 11.322.823.000 1.503.081.000 11.002.000 5.801.538.000 6.372.474.000 4.069.875.000 1.802.737.000 4.123.282.000 3.141.850.000 2.046.501.000 948.358.000 3.785.556.000 2.588.712.000 1.700.640.000 681.106.000 2.122.063.000 1.579.410.000 997.373.000 411.565.0003HNet Faaliyet Kar/Zararı- 324 39.481- 254.570 358.751 33.448 8.757- 36.687 120.717 132.806 119.438 129.559 119.672 122.991 110.082 157.785 110.709 146.490 101.306 3H Net Faaliyet Kar/Zararı Net Operating Profits 1.264.010.000 1.274.658.000 3.358.796.000 10.852.871.000 1.031.455.000 167.720.000 5.510.494.000 6.196.477.000 3.960.955.000 1.748.224.000 4.773.509.000 3.046.622.000 1.984.117.000 916.517.000 3.696.911.000 2.526.242.000 1.668.001.000 665.543.000 2.066.289.000 1.546.743.000 977.480.000 402.490.0003HA Yatırım Faaliyetlerinden Gelirler 24.093 15.764 25.275 4.923 5.958 6.534 22.834 6.031 8.902 2.961 6.688 8.237 10.856 9.300 11.356 3.585 2.056 1.971 3HA Yatırım Faaliyetlerinden Gelirler – 1.299.814.000 508.942.000 1.157.821.000 413.772.000 278.988.000 125.146.000 730.315.000 303.353.000 191.669.000 43.347.000 333.931.000 244.791.000 171.660.000 77.430.000 139.056.000 54.804.000 27.014.000 12.947.000 115.150.000 73.049.000 44.323.000 20.272.0003HAA Yatırım Faaliyetlerinden Giderler (-) – – 936- 9.458 124 86- 1.913 – – 241- 274 46 184- 42- 226- 235- 153- 163- 185 3HAA Yatırım Faaliyetlerinden Giderler (-) – – 30.233.000- 30.233.000- 309.458.000- 31.027.000- 34.424.000- 36.643.000 – – – – 4.013.000 – – 608.000- 2.242.000- 1.878.000- 5.266.000- 3.519.000- 2.331.000- 1.215.000- 3.423.000- 2.675.000- 99.000- 99.0003HAB Diğer Gelir ve Giderler – – – – – – – – – – – – – – – – – – 3HAB Diğer Gelir ve Giderler – – – – – – – – – – – – – – – – – – – – – – – 3HACÖzkaynak Yöntemiyle Değerlenen Yatırımların Kar/Zararlarındaki Paylar – – – – – – – – – – – – – – – – – – 3HAC Özkaynak Yöntemiyle Değerlenen Yatırımların Kar/Zararlarındaki Paylar Profit (Loss) from Subsidiaries – – – – – – – – – – – – – – – – – – – – – – 3HACAFinansman Gideri Öncesi Faaliyet Karı/Zararı 28.398 55.147- 234.292 363.737 63.824 5.195- 7.700 130.370 145.214 125.849 80.365 131.792 137.323 122.980 172.433 117.989 150.878 105.461 3HACA Finansman Gideri Öncesi Faaliyet Karı/Zararı – 2.712.639.000 1.780.441.000 4.808.442.000 11.705.568.000 1.747.645.000 99.505.000 6.531.853.000 6.675.827.000 4.261.544.000 1.842.071.000 4.457.213.000 3.386.033.000 2.215.919.000 1.023.910.000 3.919.346.000 2.639.997.000 1.725.323.000 692.838.000 2.233.790.000 1.649.784.000 1.041.597.000 431.738.0003HB(Esas Faaliyet Dışı) Finansal Gelirler 1.351 804 7.408- 2.756 8.358 1.906 13.591 3.300 2.089 5.738 21.704 8.659 6.720 3.410 5.802 14.247 9.870 6.040 3HB (Esas Faaliyet Dışı) Finansal Gelirler Financial Income (from Other Operations) 70.305.000 25.966.000 394.967.000 176.890.000 252.346.000 36.512.000 434.042.000 179.911.000 118.794.000 83.981.000 452.892.000 163.600.000 86.718.000 28.389.000 260.721.000 217.670.000 107.222.000 39.680.000 20.623.000 13.237.000 5.901.000 1.864.0003HC(Esas Faaliyet Dışı) Finansal Giderler (-) 101.396 159.772 624.886- 330.755 127.421 219.821 709.020- 17.821- 18.115- 20.392- 24.160- 28.670- 25.021- 24.828- 35.046- 23.963- 29.858- 27.140 3HC (Esas Faaliyet Dışı) Finansal Giderler (-) Financial Expenses (from Other Operations) (-) 8.486.749.000 5.158.310.000 16.841.203.000- 1.554.305.000 7.500.678.000 4.210.280.000 12.327.137.000- 930.333.000- 600.305.000- 298.479.000- 1.000.480.000- 678.447.000- 423.899.000- 206.709.000- 828.409.000- 568.387.000- 382.623.000- 178.301.000- 663.539.000- 484.643.000- 316.899.000- 154.144.0003HCAVergi Öncesi Diğer Gelir ve Giderler 24.093 14.827 15.817 5.047 6.043 4.621 22.834 6.031 9.143 2.687 6.733 8.421 10.814 9.074 11.120 3.432 1.893 1.786 3HCA Vergi Öncesi Diğer Gelir ve Giderler Other Income (Expenses) Before Tax 1.269.581.000 478.709.000 848.363.000 382.745.000 244.564.000 88.503.000 730.315.000 303.353.000 191.669.000 39.334.000 333.931.000 244.183.000 169.418.000 75.552.000 133.790.000 51.285.000 24.683.000 11.732.000 111.727.000 70.374.000 44.224.000 20.173.0003ISÜRDÜRÜLEN FAALİYETLER VERGİ ÖNCESİ KARI (ZARARI) 131.145 215.723 398.002 30.226 199.603 226.923 714.911 115.849 129.188 111.195 77.908 111.781 119.022 101.563 143.189 108.274 130.890 84.361 3I SÜRDÜRÜLEN FAALİYETLER VERGİ ÖNCESİ KARI (ZARARI) PROFIT BEFORE TAX FROM CONTINUING OPERATIONS 11.269.693.000 6.964.717.000 22.044.612.000 10.328.153.000 9.500.669.000 4.346.297.000 19.293.032.000 5.925.405.000 3.780.033.000 1.627.573.000 3.909.625.000 2.871.186.000 1.878.738.000 845.590.000 3.351.658.000 2.289.280.000 1.449.922.000 554.217.000 1.590.874.000 1.178.378.000 730.599.000 279.458.0003IASürdürülen Faaliyetler Vergi Geliri (Gideri) 6.667- 85.502- 146.550 72.431- 45.398- 161.630- 84.150- 19.859- 28.150- 19.359- 29.734- 11.274- 34.731- 19.340- 31.965- 23.940- 28.977- 18.845 3IA Sürdürülen Faaliyetler Vergi Geliri (Gideri) Taxation on Continuing Operations – 2.541.616.000- 2.760.459.000- 6.599.323.000- 2.285.145.000- 4.268.055.000- 3.095.739.000- 2.693.600.000- 1.120.139.000- 752.381.000- 283.362.000- 958.915.000- 562.594.000- 462.495.000- 161.023.000- 744.843.000- 507.684.000- 322.100.000- 123.806.000- 365.997.000- 272.163.000- 168.303.000- 64.074.0003IB Dönem Vergi Geliri (Gideri)- 27.393- 37.348- 68.060- 23.097- 32.016- 34.413- 92.341- 18.616- 26.767- 21.377- 33.069- 25.886- 38.113- 23.759- 31.716- 24.648- 31.621- 24.119 3IB Dönem Vergi Geliri (Gideri) Taxation on Income (Expenses) – 2.104.975.000- 1.205.782.000- 4.121.772.000- 2.118.201.000- 1.485.870.000- 659.119.000- 2.830.225.000- 1.103.606.000- 758.865.000- 312.897.000- 1.199.244.000- 758.470.000- 528.644.000- 197.810.000- 801.238.000- 565.926.000- 374.847.000- 158.455.000- 424.831.000- 331.485.000- 197.742.000- 78.711.0003IC Ertelenmiş Vergi Geliri (Gideri) 34.059- 48.154- 78.490 95.528- 13.382- 127.217 8.191- 1.243- 1.383 2.018 3.335 14.611 3.383 4.418- 249 709 2.645 5.274 3IC Ertelenmiş Vergi Geliri (Gideri) Income (Expenses) of Deferred Tax – 436.641.000- 1.554.677.000- 2.477.551.000- 166.944.000- 2.782.185.000- 2.436.620.000 136.625.000- 16.533.000 6.484.000 29.535.000 240.329.000 195.876.000 66.149.000 36.787.000 56.395.000 58.242.000 52.747.000 34.649.000 58.834.000 59.322.000 29.439.000 14.637.0003ID Diğer Vergi Geliri (Gideri) – – – – – – – – – – – – – – – – – – 3ID Diğer Vergi Geliri (Gideri) Other Taxation Income (Expenses) – – – – – – – – – – – – – – – – – – – – – – 3JSÜRDÜRÜLEN FAALİYETLER DÖNEM KARI/ZARARI 137.811 130.222 251.452 102.656 154.205 65.292 630.761 95.990 101.038 91.836 48.175 100.507 84.292 82.222 111.224 84.334 101.913 65.516 3J SÜRDÜRÜLEN FAALİYETLER DÖNEM KARI/ZARARI PROFIT FROM CONTINUING OPERATIONS 8.728.077.000 4.204.258.000 15.445.289.000 8.043.008.000 5.232.614.000 1.250.558.000 16.599.432.000 4.805.266.000 3.027.652.000 1.344.211.000 2.950.710.000 2.308.592.000 1.416.243.000 684.567.000 2.606.815.000 1.781.596.000 1.127.822.000 430.411.000 1.224.877.000 906.215.000 562.296.000 215.384.0003KDURDURULAN FAALİYETLER – – – – – – – – – – – – – – – – – – 3K DURDURULAN FAALİYETLER DISCONTINUED OPERATIONS – – – – – – – – – – – – – – – – – – – – – – 3KADurdurulan Faaliyetler Vergi Sonrası Dönem Karı (Zararı) – – – – – – – – – – – – – – – – – – 3KA Durdurulan Faaliyetler Vergi Sonrası Dönem Karı (Zararı) Profit After Taxes from Discontinued Operations – – – – – – – – – – – – – – – – – – – – – – 3LDÖNEM KARI (ZARARI) 137.811 130.222 251.452 102.656 154.205 65.292 630.761 95.990 101.038 91.836 48.175 100.507 84.292 82.222 111.224 84.334 101.913 65.516 3L DÖNEM KARI (ZARARI) NET PROFIT AFTER TAXES 8.728.077.000 4.204.258.000 15.445.289.000 8.043.008.000 5.232.614.000 1.250.558.000 16.599.432.000 4.805.266.000 3.027.652.000 1.344.211.000 2.950.710.000 2.308.592.000 1.416.243.000 684.567.000 2.606.815.000 1.781.596.000 1.127.822.000 430.411.000 1.224.877.000 906.215.000 562.296.000 215.384.000
hi,As seen in the attached example file, I obtain quarterly data in the range “C179:T214” by manually processing the periodic data in the range “AA179:AV214”.Quarterly data is obtained as follows: “IF(RIGHT(Quarter date; 1) = “3”; write as is; otherwise subtract from previous)”Quarterly Data:1- array formula to do the entire row at once.2- Using an array formula for the entire block. 2024/62024/32023/122023/92023/62023/32022/122022/92022/62022/32021/122021/92021/62021/32020/122020/92020/62020/32019/12 USD 32,83 32,29 29,44 27,38 25,82 19,15 18,70 18,52 16,66 14,64 13,33 8,88 8,68 8,33 7,42 7,75 6,84 6,57 5,94 6 6 1000 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Dönemlik Finansal TabloitemDescEng2024/62024/32023/122023/92023/62023/32022/122022/92022/62022/32021/122021/92021/62021/32020/122020/92020/62020/32019/122019/92019/62019/63BSürdürülen Faaliyetler – – – – – – – – – – – – – – – – – – 3B Sürdürülen Faaliyetler Continuing Operations – – – – – – – – – – – – – – – – – – – – – – 3CSatış Gelirleri 3.328.221 3.484.238 4.919.580- 509.910 3.930.608 5.016.264 9.446.445 2.223.218 2.048.771 1.866.076 1.543.730 1.966.237 1.977.264 1.861.881 2.063.393 1.749.195 2.049.991 1.917.562 3C Satış Gelirleri Net Sales 221.742.860.000 112.490.019.000 328.441.924.000 183.618.341.000 197.577.993.000 96.077.514.000 279.252.910.000 102.620.448.000 61.449.339.000 27.313.940.000 70.698.507.000 50.122.131.000 32.664.892.000 15.501.646.000 55.495.364.000 40.186.226.000 26.626.115.000 12.597.616.000 40.211.942.000 29.683.016.000 19.270.728.000 9.025.282.0003CASatışların Maliyeti (-)- 2.770.361- 2.884.688- 4.369.355 690.205- 3.314.184- 4.252.363- 8.185.675- 1.830.365- 1.679.443- 1.519.856- 1.235.962- 1.596.628- 1.605.969- 1.519.180- 1.677.107- 1.425.250- 1.673.784- 1.587.612 3CA Satışların Maliyeti (-) Cost Of Sales – 184.073.751.000- 93.133.311.000- 276.759.269.000- 148.133.330.000- 167.028.867.000- 81.446.368.000- 237.182.345.000- 84.124.131.000- 50.228.152.000- 22.246.287.000- 57.238.477.000- 40.764.341.000- 26.588.682.000- 12.648.389.000- 45.375.969.000- 32.932.838.000- 21.884.018.000- 10.429.978.000- 33.226.484.000- 24.493.133.000- 15.928.955.000- 7.488.411.0003CAATicari Faaliyetlerden Diğer Kar (Zarar) – – – – – – – – – – – – – – – – – – 3CAA Ticari Faaliyetlerden Diğer Kar (Zarar) Other Profit (Loss) from Trade Operations – – – – – – – – – – – – – – – – – – – – – – 3CABTicari Faaliyetlerden Brüt Kar (Zarar) 557.859 599.550 550.225 180.295 616.424 763.901 1.260.770 392.853 369.329 346.220 307.768 369.610 371.295 342.701 386.286 323.946 376.207 329.950 3CAB Ticari Faaliyetlerden Brüt Kar (Zarar) Gross Profit (Loss) from Trade Operations 37.669.109.000 19.356.708.000 51.682.655.000 35.485.011.000 30.549.126.000 14.631.146.000 42.070.565.000 18.496.317.000 11.221.187.000 5.067.653.000 13.460.030.000 9.357.790.000 6.076.210.000 2.853.257.000 10.119.395.000 7.253.388.000 4.742.097.000 2.167.638.000 6.985.458.000 5.189.883.000 3.341.773.000 1.536.871.0003CACFaiz, Ücret, Prim, Komisyon ve Diğer Gelirler – – – – – – – – – – – – – – – – – – 3CAC Faiz, Ücret, Prim, Komisyon ve Diğer Gelirler Proceeds from Interest, Fee, Premium, Commission and Other – – – – – – – – – – – – – – – – – – – – – – 3CADFaiz, Ücret, Prim, Komisyon ve Diğer Giderler (-) – – – – – – – – – – – – – – – – – – 3CAD Faiz, Ücret, Prim, Komisyon ve Diğer Giderler (-) Expenses from Interest, Fee, Premium, Commission and Other – – – – – – – – – – – – – – – – – – – – – – 3CAEFinans Sektörü Faaliyetlerinden Diğer Kar (Zarar) – – – – – – – – – – – – – – – – – – 3CAE Finans Sektörü Faaliyetlerinden Diğer Kar (Zarar) Other Profit (Loss) from Financial Operations – – – – – – – – – – – – – – – – – – – – – – 3CAFFinans Sektörü Faaliyetlerinden Brüt Kar (Zarar) – – – – – – – – – – – – – – – – – – 3CAF Finans Sektörü Faaliyetlerinden Brüt Kar (Zarar) Gross Profit (Loss) from Financial Operations – – – – – – – – – – – – – – – – – – – – – – 3CBDiğer Gelir ve Giderler – – – – – – – – – – – – – – – – – – 3CB Diğer Gelir ve Giderler Other Income (Expenses) – – – – – – – – – – – – – – – – – – – – – – 3DBRÜT KAR (ZARAR) 557.859 599.550 550.225 180.295 616.424 763.901 1.260.770 392.853 369.329 346.220 307.768 369.610 371.295 342.701 386.286 323.946 376.207 329.950 3D BRÜT KAR (ZARAR) GROSS PROFIT (LOSS) 37.669.109.000 19.356.708.000 51.682.655.000 35.485.011.000 30.549.126.000 14.631.146.000 42.070.565.000 18.496.317.000 11.221.187.000 5.067.653.000 13.460.030.000 9.357.790.000 6.076.210.000 2.853.257.000 10.119.395.000 7.253.388.000 4.742.097.000 2.167.638.000 6.985.458.000 5.189.883.000 3.341.773.000 1.536.871.0003DAPazarlama, Satış ve Dağıtım Giderleri (-)- 487.773- 483.917- 704.942 154.453- 505.536- 659.724- 1.163.325- 242.820- 210.246- 199.556- 161.434- 219.372- 218.755- 203.668- 197.798- 188.778- 202.236- 196.890 3DA Pazarlama, Satış ve Dağıtım Giderleri (-) Marketing Selling & Distrib. Expenses (-) – 31.635.210.000- 15.623.469.000- 42.214.147.000- 21.461.916.000- 25.690.330.000- 12.635.826.000- 32.672.797.000- 10.920.605.000- 6.423.903.000- 2.920.915.000- 7.694.012.000- 5.542.256.000- 3.594.560.000- 1.695.699.000- 5.608.409.000- 4.140.870.000- 2.677.427.000- 1.293.486.000- 4.278.730.000- 3.171.389.000- 2.049.581.000- 977.311.0003DBGenel Yönetim Giderleri (-)- 70.410- 76.151- 99.853 24.003- 77.440- 95.420- 134.132- 29.317- 26.277- 27.226- 16.775- 30.566- 29.549- 28.951- 30.703- 24.458- 27.481- 31.754 3DB Genel Yönetim Giderleri (-) General Administrative Expenses (-) – 4.769.889.000- 2.458.581.000- 6.109.712.000- 3.170.224.000- 3.827.341.000- 1.827.600.000- 3.887.274.000- 1.379.235.000- 836.329.000- 398.514.000- 992.509.000- 768.912.000- 497.533.000- 241.041.000- 814.075.000- 586.276.000- 396.669.000- 208.609.000- 640.439.000- 471.751.000- 314.712.000- 157.070.0003DCAraştırma ve Geliştirme Giderleri (-) – – – – – – – – – – – – – – – – – – 3DC Araştırma ve Geliştirme Giderleri (-) Research & Development Expenses (-) – – – – – – – – – – – – – – – – – – – – – – 3DDDiğer Faaliyet Gelirleri 7.108 8.144 23.754- 3.008 28.760 7.698 21.336 4.902 5.575 4.755 2.768 4.418 3.995 4.246 4.592 4.847 2.737 2.848 3DD Diğer Faaliyet Gelirleri Income from Other Operations 496.274.000 262.930.000 1.507.063.000 807.775.000 890.114.000 147.439.000 652.216.000 253.263.000 162.492.000 69.601.000 146.143.000 109.250.000 70.023.000 35.349.000 109.085.000 75.013.000 37.437.000 18.707.000 73.808.000 44.729.000 28.648.000 12.818.0003DEDiğer Faaliyet Giderleri (-)- 2.479- 7.305- 19.293 2.946- 4.427- 15.880- 15.184- 1.279- 2.310- 1.031- 58.695- 719- 476- 421- 1.064- 999- 242- 479 3DE Diğer Faaliyet Giderleri (-) Expenses from Other Operations (-) – 317.226.000- 235.856.000- 905.780.000- 337.823.000- 418.488.000- 304.157.000- 361.172.000- 77.266.000- 53.572.000- 15.088.000- 796.370.000- 14.022.000- 7.639.000- 3.508.000- 20.440.000- 12.543.000- 4.798.000- 3.144.000- 18.034.000- 12.062.000- 8.755.000- 3.743.0003DEAFaaliyet Karı Öncesi Diğer Gelir ve Giderler – – – – – – – – – – – – – – – – – – 3DEA Faaliyet Karı Öncesi Diğer Gelir ve Giderler Other Income (Expenses) Before Operating Profits – – – – – – – – – – – – – – – – – – – – – – 3DFFAALİYET KARI (ZARARI) 4.305 40.320- 250.108 358.690 57.781 574- 30.534 124.339 136.071 123.162 73.631 123.371 126.510 113.906 161.313 114.557 148.985 103.675 3DF FAALİYET KARI (ZARARI) OPERATING PROFITS 1.443.058.000 1.301.732.000 3.960.079.000 11.322.823.000 1.503.081.000 11.002.000 5.801.538.000 6.372.474.000 4.069.875.000 1.802.737.000 4.123.282.000 3.141.850.000 2.046.501.000 948.358.000 3.785.556.000 2.588.712.000 1.700.640.000 681.106.000 2.122.063.000 1.579.410.000 997.373.000 411.565.0003HNet Faaliyet Kar/Zararı- 324 39.481- 254.570 358.751 33.448 8.757- 36.687 120.717 132.806 119.438 129.559 119.672 122.991 110.082 157.785 110.709 146.490 101.306 3H Net Faaliyet Kar/Zararı Net Operating Profits 1.264.010.000 1.274.658.000 3.358.796.000 10.852.871.000 1.031.455.000 167.720.000 5.510.494.000 6.196.477.000 3.960.955.000 1.748.224.000 4.773.509.000 3.046.622.000 1.984.117.000 916.517.000 3.696.911.000 2.526.242.000 1.668.001.000 665.543.000 2.066.289.000 1.546.743.000 977.480.000 402.490.0003HA Yatırım Faaliyetlerinden Gelirler 24.093 15.764 25.275 4.923 5.958 6.534 22.834 6.031 8.902 2.961 6.688 8.237 10.856 9.300 11.356 3.585 2.056 1.971 3HA Yatırım Faaliyetlerinden Gelirler – 1.299.814.000 508.942.000 1.157.821.000 413.772.000 278.988.000 125.146.000 730.315.000 303.353.000 191.669.000 43.347.000 333.931.000 244.791.000 171.660.000 77.430.000 139.056.000 54.804.000 27.014.000 12.947.000 115.150.000 73.049.000 44.323.000 20.272.0003HAA Yatırım Faaliyetlerinden Giderler (-) – – 936- 9.458 124 86- 1.913 – – 241- 274 46 184- 42- 226- 235- 153- 163- 185 3HAA Yatırım Faaliyetlerinden Giderler (-) – – 30.233.000- 30.233.000- 309.458.000- 31.027.000- 34.424.000- 36.643.000 – – – – 4.013.000 – – 608.000- 2.242.000- 1.878.000- 5.266.000- 3.519.000- 2.331.000- 1.215.000- 3.423.000- 2.675.000- 99.000- 99.0003HAB Diğer Gelir ve Giderler – – – – – – – – – – – – – – – – – – 3HAB Diğer Gelir ve Giderler – – – – – – – – – – – – – – – – – – – – – – – 3HACÖzkaynak Yöntemiyle Değerlenen Yatırımların Kar/Zararlarındaki Paylar – – – – – – – – – – – – – – – – – – 3HAC Özkaynak Yöntemiyle Değerlenen Yatırımların Kar/Zararlarındaki Paylar Profit (Loss) from Subsidiaries – – – – – – – – – – – – – – – – – – – – – – 3HACAFinansman Gideri Öncesi Faaliyet Karı/Zararı 28.398 55.147- 234.292 363.737 63.824 5.195- 7.700 130.370 145.214 125.849 80.365 131.792 137.323 122.980 172.433 117.989 150.878 105.461 3HACA Finansman Gideri Öncesi Faaliyet Karı/Zararı – 2.712.639.000 1.780.441.000 4.808.442.000 11.705.568.000 1.747.645.000 99.505.000 6.531.853.000 6.675.827.000 4.261.544.000 1.842.071.000 4.457.213.000 3.386.033.000 2.215.919.000 1.023.910.000 3.919.346.000 2.639.997.000 1.725.323.000 692.838.000 2.233.790.000 1.649.784.000 1.041.597.000 431.738.0003HB(Esas Faaliyet Dışı) Finansal Gelirler 1.351 804 7.408- 2.756 8.358 1.906 13.591 3.300 2.089 5.738 21.704 8.659 6.720 3.410 5.802 14.247 9.870 6.040 3HB (Esas Faaliyet Dışı) Finansal Gelirler Financial Income (from Other Operations) 70.305.000 25.966.000 394.967.000 176.890.000 252.346.000 36.512.000 434.042.000 179.911.000 118.794.000 83.981.000 452.892.000 163.600.000 86.718.000 28.389.000 260.721.000 217.670.000 107.222.000 39.680.000 20.623.000 13.237.000 5.901.000 1.864.0003HC(Esas Faaliyet Dışı) Finansal Giderler (-) 101.396 159.772 624.886- 330.755 127.421 219.821 709.020- 17.821- 18.115- 20.392- 24.160- 28.670- 25.021- 24.828- 35.046- 23.963- 29.858- 27.140 3HC (Esas Faaliyet Dışı) Finansal Giderler (-) Financial Expenses (from Other Operations) (-) 8.486.749.000 5.158.310.000 16.841.203.000- 1.554.305.000 7.500.678.000 4.210.280.000 12.327.137.000- 930.333.000- 600.305.000- 298.479.000- 1.000.480.000- 678.447.000- 423.899.000- 206.709.000- 828.409.000- 568.387.000- 382.623.000- 178.301.000- 663.539.000- 484.643.000- 316.899.000- 154.144.0003HCAVergi Öncesi Diğer Gelir ve Giderler 24.093 14.827 15.817 5.047 6.043 4.621 22.834 6.031 9.143 2.687 6.733 8.421 10.814 9.074 11.120 3.432 1.893 1.786 3HCA Vergi Öncesi Diğer Gelir ve Giderler Other Income (Expenses) Before Tax 1.269.581.000 478.709.000 848.363.000 382.745.000 244.564.000 88.503.000 730.315.000 303.353.000 191.669.000 39.334.000 333.931.000 244.183.000 169.418.000 75.552.000 133.790.000 51.285.000 24.683.000 11.732.000 111.727.000 70.374.000 44.224.000 20.173.0003ISÜRDÜRÜLEN FAALİYETLER VERGİ ÖNCESİ KARI (ZARARI) 131.145 215.723 398.002 30.226 199.603 226.923 714.911 115.849 129.188 111.195 77.908 111.781 119.022 101.563 143.189 108.274 130.890 84.361 3I SÜRDÜRÜLEN FAALİYETLER VERGİ ÖNCESİ KARI (ZARARI) PROFIT BEFORE TAX FROM CONTINUING OPERATIONS 11.269.693.000 6.964.717.000 22.044.612.000 10.328.153.000 9.500.669.000 4.346.297.000 19.293.032.000 5.925.405.000 3.780.033.000 1.627.573.000 3.909.625.000 2.871.186.000 1.878.738.000 845.590.000 3.351.658.000 2.289.280.000 1.449.922.000 554.217.000 1.590.874.000 1.178.378.000 730.599.000 279.458.0003IASürdürülen Faaliyetler Vergi Geliri (Gideri) 6.667- 85.502- 146.550 72.431- 45.398- 161.630- 84.150- 19.859- 28.150- 19.359- 29.734- 11.274- 34.731- 19.340- 31.965- 23.940- 28.977- 18.845 3IA Sürdürülen Faaliyetler Vergi Geliri (Gideri) Taxation on Continuing Operations – 2.541.616.000- 2.760.459.000- 6.599.323.000- 2.285.145.000- 4.268.055.000- 3.095.739.000- 2.693.600.000- 1.120.139.000- 752.381.000- 283.362.000- 958.915.000- 562.594.000- 462.495.000- 161.023.000- 744.843.000- 507.684.000- 322.100.000- 123.806.000- 365.997.000- 272.163.000- 168.303.000- 64.074.0003IB Dönem Vergi Geliri (Gideri)- 27.393- 37.348- 68.060- 23.097- 32.016- 34.413- 92.341- 18.616- 26.767- 21.377- 33.069- 25.886- 38.113- 23.759- 31.716- 24.648- 31.621- 24.119 3IB Dönem Vergi Geliri (Gideri) Taxation on Income (Expenses) – 2.104.975.000- 1.205.782.000- 4.121.772.000- 2.118.201.000- 1.485.870.000- 659.119.000- 2.830.225.000- 1.103.606.000- 758.865.000- 312.897.000- 1.199.244.000- 758.470.000- 528.644.000- 197.810.000- 801.238.000- 565.926.000- 374.847.000- 158.455.000- 424.831.000- 331.485.000- 197.742.000- 78.711.0003IC Ertelenmiş Vergi Geliri (Gideri) 34.059- 48.154- 78.490 95.528- 13.382- 127.217 8.191- 1.243- 1.383 2.018 3.335 14.611 3.383 4.418- 249 709 2.645 5.274 3IC Ertelenmiş Vergi Geliri (Gideri) Income (Expenses) of Deferred Tax – 436.641.000- 1.554.677.000- 2.477.551.000- 166.944.000- 2.782.185.000- 2.436.620.000 136.625.000- 16.533.000 6.484.000 29.535.000 240.329.000 195.876.000 66.149.000 36.787.000 56.395.000 58.242.000 52.747.000 34.649.000 58.834.000 59.322.000 29.439.000 14.637.0003ID Diğer Vergi Geliri (Gideri) – – – – – – – – – – – – – – – – – – 3ID Diğer Vergi Geliri (Gideri) Other Taxation Income (Expenses) – – – – – – – – – – – – – – – – – – – – – – 3JSÜRDÜRÜLEN FAALİYETLER DÖNEM KARI/ZARARI 137.811 130.222 251.452 102.656 154.205 65.292 630.761 95.990 101.038 91.836 48.175 100.507 84.292 82.222 111.224 84.334 101.913 65.516 3J SÜRDÜRÜLEN FAALİYETLER DÖNEM KARI/ZARARI PROFIT FROM CONTINUING OPERATIONS 8.728.077.000 4.204.258.000 15.445.289.000 8.043.008.000 5.232.614.000 1.250.558.000 16.599.432.000 4.805.266.000 3.027.652.000 1.344.211.000 2.950.710.000 2.308.592.000 1.416.243.000 684.567.000 2.606.815.000 1.781.596.000 1.127.822.000 430.411.000 1.224.877.000 906.215.000 562.296.000 215.384.0003KDURDURULAN FAALİYETLER – – – – – – – – – – – – – – – – – – 3K DURDURULAN FAALİYETLER DISCONTINUED OPERATIONS – – – – – – – – – – – – – – – – – – – – – – 3KADurdurulan Faaliyetler Vergi Sonrası Dönem Karı (Zararı) – – – – – – – – – – – – – – – – – – 3KA Durdurulan Faaliyetler Vergi Sonrası Dönem Karı (Zararı) Profit After Taxes from Discontinued Operations – – – – – – – – – – – – – – – – – – – – – – 3LDÖNEM KARI (ZARARI) 137.811 130.222 251.452 102.656 154.205 65.292 630.761 95.990 101.038 91.836 48.175 100.507 84.292 82.222 111.224 84.334 101.913 65.516 3L DÖNEM KARI (ZARARI) NET PROFIT AFTER TAXES 8.728.077.000 4.204.258.000 15.445.289.000 8.043.008.000 5.232.614.000 1.250.558.000 16.599.432.000 4.805.266.000 3.027.652.000 1.344.211.000 2.950.710.000 2.308.592.000 1.416.243.000 684.567.000 2.606.815.000 1.781.596.000 1.127.822.000 430.411.000 1.224.877.000 906.215.000 562.296.000 215.384.000 Read More
Ownership of Appsource application
I am writing to request ownership of the AppSource page for 3DPrinterOS (link). The original creator is no longer with our company, and I would like to manage this listing.
Please let me know what information you need to process this request. Thank you for your assistance!
You can reach me via my work email, email address removed for privacy reasons
I am writing to request ownership of the AppSource page for 3DPrinterOS (link). The original creator is no longer with our company, and I would like to manage this listing.Please let me know what information you need to process this request. Thank you for your assistance!You can reach me via my work email, email address removed for privacy reasons Read More
New autonomous agents scale your team like never before
Already, 60 percent of the Fortune 500 are using Microsoft 365 Copilot to accelerate business results and empower their teams. With Copilot supporting sales associates, Lumen Technologies projects $50 million dollars in savings annually. Honeywell(1) equates productivity gains to adding 187 full-time employees and Finastra is reducing creative production time from seven months to seven weeks.
Today, we’re announcing new agentic capabilities that will accelerate these gains and bring AI-first business process to every organization.
First, the ability to create autonomous agents with Copilot Studio will be in public preview next month.
Second, we’re introducing ten new autonomous agents in Dynamics 365 to build capacity for every sales, service, finance and supply chain team.
Copilot is your AI assistant — it works for you — and Copilot Studio enables you to easily create, manage and connect agents to Copilot. Think of agents as the new apps for an AI-powered world. Every organization will have a constellation of agents — ranging from simple prompt-and-response to fully autonomous. They will work on behalf of an individual, team or function to execute and orchestrate businesses process. Copilot is how you’ll interact with these agents, and they’ll do everything from accelerating lead generation and processing sales orders to automating your supply chain.
Empowering more customers to build autonomous agents in Copilot Studio
Earlier this year, we announced a host of powerful new capabilities in Copilot Studio, including the ability to create autonomous agents. Next month, these capabilities are shifting from private to public preview, allowing more customers to reimagine critical business processes with AI. Agents draw on the context of your work data in Microsoft 365 Graph, systems of record, Dataverse and Fabric, and can support everything from your IT help desk to employee onboarding and act as a personal concierge for sales and service.
Organizations like Clifford Chance, McKinsey & Company, Pets at Home and Thomson Reuters are already creating autonomous agents to increase revenue, reduce costs and scale impact. Pets at Home, the U.K.’s leading pet care business, created an agent for its profit protection team to more efficiently compile cases for skilled human review, which could have the potential to drive a seven-figure annual savings. McKinsey & Company is creating an agent that will speed up the client onboarding process. The pilot showed lead time could be reduced by 90% and administrative work reduced by 30%. Thomson Reuters built a professional-grade agent to speed up the legal due diligence workflow, with initial testing showing some tasks could be done in half the time. This agent can help Thomson Reuters increase the efficiency of work for clients and boost its new business pipeline.
Scaling your teams with 10 new autonomous agents in Dynamics 365
New autonomous agents enable customers to move from legacy lines of business applications to AI-first business process. AI is today’s ROI and tomorrow’s competitive edge. These new agents are designed to help every sales, service, finance and supply chain team drive business value — and are just the start. We will create many more agents in the coming year that will give customers the competitive advantage they need to future-proof their organization. Today, we’re introducing ten of these autonomous agents. Here are a few examples:
Sales Qualification Agent: In a profession where time literally equals money, this agent enables sellers to focus their time on the highest priority sales opportunities while the agent researches leads, helps prioritize opportunities and guides customer outreach with personalized emails and responses.
Supplier Communications Agent: This agent enables customers to optimize their supply chain and minimize costly disruptions by autonomously tracking supplier performance, detecting delays and responding accordingly — freeing procurement teams from time consuming manual monitoring and firefighting.
Customer Intent and Customer Knowledge Management Agents: A business gets one chance to make a first impression, and these two agents are game changers for customer care teams facing high call volumes, talent shortages and heightened customer expectations. These agents work hand in hand with a customer service representative by learning how to resolve customer issues and autonomously adding knowledge-based articles to scale best practices across the care team.
As agents become more prevalent in the enterprise, customers want to be confident that they have robust data governance and security. The agents coming to Dynamics 365 follow our core security, privacy and responsible AI commitments. Agents built in Copilot Studio include guardrails and controls established by maker-defined instructions, knowledge and actions. The data sources linked to the agent adhere to stringent security measures and controls — all managed in Copilot Studio. These include data loss prevention, robust authentication protocols and more. Once these agents are created, IT administrators can apply a comprehensive set of features to govern their use.
Microsoft’s own transformation
At Microsoft, we’re using Copilot and agents to reimagine business process across every function while empowering employees to scale their impact. Using Copilot, one sales team has achieved 9.4% higher revenue per seller and closed 20% more deals(2). And thanks to Copilot, one team is resolving customer cases nearly 12% faster(3). Our Marketing team is seeing a 21.5% increase in conversion rate on Azure.com with a custom agent designed to assist buyers(4). And in Human Resources, our employee self-service agent is helping answer questions with 42% greater accuracy(5).
With Copilot and agents, the possibilities are endless — we can’t wait to see what you create. Start building agents in Copilot Studio today. Read more about autonomous agent capabilities on the Copilot Studio and Dynamics 365 blogs. Head to WorkLab for more insights on Microsoft’s own AI transformation.
NOTES
Statistics are from an internal Honeywell survey of 5,000 employees where 611 employees responded.
Internal Microsoft Sales Team data based on 687 sellers of Microsoft 365 Copilot, Jan. – June 2024, as compared with sellers with low usage of Copilot. Regular usage of Copilot means sellers who use Copilot daily at least 50% of the time during the testing period.
Internal Finance analysis of costs, comparing actuals for FY ’24 and projections for FY ’25.
Internal CSS experiment conducted by Microsoft, 600 participants using Copilot Q&A function, Azure Core team, Nov. – Dec. 2023. These results are statistically significant at the 95th% confidence interval.
Internal Microsoft Marketing Team data, June – Sept. 2024. Conversion means initiating the free account sign-up process on Azure.com.
The post New autonomous agents scale your team like never before appeared first on The Official Microsoft Blog.
Already, 60 percent of the Fortune 500 are using Microsoft 365 Copilot to accelerate business results and empower their teams. With Copilot supporting sales associates, Lumen Technologies projects $50 million dollars in savings annually. Honeywell(1) equates productivity gains to adding 187 full-time employees and Finastra is reducing creative production time from seven months to seven…
The post New autonomous agents scale your team like never before appeared first on The Official Microsoft Blog.Read More
Probleme displaying Intune policies based on Settings Catalog.
I can no longer modify my Windows Hello configuration policies based on the settings catalog. When I click on it, it sends me the error below. It is really discouraging at the time when I have just done my first successful Windows Hello configuration test.
I can no longer modify my Windows Hello configuration policies based on the settings catalog. When I click on it, it sends me the error below. It is really discouraging at the time when I have just done my first successful Windows Hello configuration test. Read More
Best Practices for Resizing (Reducing) a SharePoint Farm and Decommissioning Servers
~~~~ Resizing a SharePoint Farm: Strategies and Considerations ~~~~
I’ve noticed that while there are numerous blogs and technical articles available on how to set up a SharePoint farm SP2016, there’s a noticeable lack of guidance on resizing an existing farm—especially when it comes to decommissioning servers and reducing the overall infrastructure.
When dealing with a farm configured with MinRoles, there are several critical considerations:
1. **Planning for Server Decommissioning**: What is the best approach to identify which servers can be decommissioned without impacting performance?
2. **Capacity Assessment**: How do we assess the current and projected workload to ensure that the remaining servers can handle the load?
3. **Service Application Reconfiguration**: After reducing the number of servers, what steps should be taken to reconfigure service applications? Are there specific tools or best practices for managing this?
4. **New Farm Topology**: How do we effectively design the new farm topology post-decommissioning? What factors should guide this restructuring?
I believe sharing insights and experiences on these topics can significantly benefit anyone facing the challenge of resizing their SharePoint environment. I’m looking forward to hearing your thoughts!
#spfarm #sp2016 #spadmin
~~~~ Resizing a SharePoint Farm: Strategies and Considerations ~~~~ I’ve noticed that while there are numerous blogs and technical articles available on how to set up a SharePoint farm SP2016, there’s a noticeable lack of guidance on resizing an existing farm—especially when it comes to decommissioning servers and reducing the overall infrastructure.When dealing with a farm configured with MinRoles, there are several critical considerations: 1. **Planning for Server Decommissioning**: What is the best approach to identify which servers can be decommissioned without impacting performance? 2. **Capacity Assessment**: How do we assess the current and projected workload to ensure that the remaining servers can handle the load? 3. **Service Application Reconfiguration**: After reducing the number of servers, what steps should be taken to reconfigure service applications? Are there specific tools or best practices for managing this? 4. **New Farm Topology**: How do we effectively design the new farm topology post-decommissioning? What factors should guide this restructuring? I believe sharing insights and experiences on these topics can significantly benefit anyone facing the challenge of resizing their SharePoint environment. I’m looking forward to hearing your thoughts!#spfarm #sp2016 #spadmin Read More
How can I clone hard drive to ssd on Window 11?
Hi everyone,
I’m looking for a reliable method to clone my current hard drive to a new SSD on my Windows PC. I want to transfer all the data, including the operating system, files, and programs, without reinstalling everything. Could anyone guide me through the steps to clone hard drive to SSD on Windows 11? I would also appreciate any advice on potential issues to watch out for during the process. Here’s what I’m working with:
Current drive: 500GB HDDNew drive: 1TB SSD (I know I’ll need to make sure the used space on the HDD is less than 500GB)Operating system: Windows 11Backup plan: I have a backup of all my important files, but I’d like to avoid any surprises!
Looking forward to your recommendations! Thanks!
Hi everyone, I’m looking for a reliable method to clone my current hard drive to a new SSD on my Windows PC. I want to transfer all the data, including the operating system, files, and programs, without reinstalling everything. Could anyone guide me through the steps to clone hard drive to SSD on Windows 11? I would also appreciate any advice on potential issues to watch out for during the process. Here’s what I’m working with: Current drive: 500GB HDDNew drive: 1TB SSD (I know I’ll need to make sure the used space on the HDD is less than 500GB)Operating system: Windows 11Backup plan: I have a backup of all my important files, but I’d like to avoid any surprises!Looking forward to your recommendations! Thanks! Read More
Can Microsoft 365 Copilot learn directly from my actions? (e.g corrective or change response?)
I am trying to comprehend the scope in which Microsoft 365 Copilot might be able to learn and change it’s response on a user-level. I have identified 4 scopes (this might be incorrect) and I am looking for answers about scope 2. Does anybody have some concrete information about this?
Scope 1: In the scope of a single chat.
– The response can be directly change by the user. e.g. tell Copilot that 2+2=5. then ask what is 2+2.
Scope 2: In the scope of all interactions with of a single user.
– I cannot find concrete information if Copilot will, or will not, give different responses based on histories of all interactions with me.
Scope 3: In the scope of the tenant.
– I cannot find concrete information if Copilot will, or will not, give different responses based on histories of all interactions with other users in the tenant.
Scope 4: In the scope of the foundation of Copilot service.
Data, Privacy, and Security for Microsoft 365 Copilot | Microsoft Learn “Prompts, responses, and data accessed through Microsoft Graph aren’t used to train foundation LLMs, including those used by Microsoft 365 Copilot.”
Apologies if this is confirmed / unconfirmed in any official source. I spent a few hours looking but was unable to find any concrete answer.
I am trying to comprehend the scope in which Microsoft 365 Copilot might be able to learn and change it’s response on a user-level. I have identified 4 scopes (this might be incorrect) and I am looking for answers about scope 2. Does anybody have some concrete information about this?Scope 1: In the scope of a single chat.- The response can be directly change by the user. e.g. tell Copilot that 2+2=5. then ask what is 2+2. Scope 2: In the scope of all interactions with of a single user.- I cannot find concrete information if Copilot will, or will not, give different responses based on histories of all interactions with me. Scope 3: In the scope of the tenant.- I cannot find concrete information if Copilot will, or will not, give different responses based on histories of all interactions with other users in the tenant. Scope 4: In the scope of the foundation of Copilot service.Data, Privacy, and Security for Microsoft 365 Copilot | Microsoft Learn “Prompts, responses, and data accessed through Microsoft Graph aren’t used to train foundation LLMs, including those used by Microsoft 365 Copilot.” Apologies if this is confirmed / unconfirmed in any official source. I spent a few hours looking but was unable to find any concrete answer. Read More
Action ‘Get_file_content’ failed suddenly
Morning,
I have had my flow fail suddenly with no changes to the form or the flow.
I use the following to get the file contents from the MS form response
I have also re-run one that has previously worked and that now does not work.
All I can assume is that an update/change has been made to this action?
Any help would be appreciated.
Morning,I have had my flow fail suddenly with no changes to the form or the flow.I use the following to get the file contents from the MS form response json(outputs(‘Get_responses_from_TSE_form’)?[‘body/rb415b42e1eb44a34b1ee76469acebe18’]) The ‘Get responses.. is from the dynamic content for where the attachments are uploaded within the form – therefore all of the text from “json” is entered for me. This worked fine up until last week now I get the error: I have also re-run one that has previously worked and that now does not work. All I can assume is that an update/change has been made to this action?Any help would be appreciated. Read More
SharePoint news post author changed after copying site page
Hi,
I have a Microsoft Power Automate flow in place that allows me to automatically copy a site page to another site in SharePoint, and then promote it as news.
Since a couple of weeks our users report an issue wherein they mention that the author in the page headers are changed.
I use the default ‘Copy file’ action in Power Automate to copy the initial site page. Then I promote the site page as a news post using the SharePoint REST API by the _api/sitepages/pages(x)/PromoteToNews endpoint. At last, I use _api/sitepages/pages(x)/Publish endpoint to publish the newly copied news post.
Previously, the author was kept correctly. But since a couple of weeks the author in the page title header is replaced with a seemingly random user.
Does anyone else have this issue? And how can I prevent this from happening?
Many thanks for all help provided!
Hi, I have a Microsoft Power Automate flow in place that allows me to automatically copy a site page to another site in SharePoint, and then promote it as news.Since a couple of weeks our users report an issue wherein they mention that the author in the page headers are changed. I use the default ‘Copy file’ action in Power Automate to copy the initial site page. Then I promote the site page as a news post using the SharePoint REST API by the _api/sitepages/pages(x)/PromoteToNews endpoint. At last, I use _api/sitepages/pages(x)/Publish endpoint to publish the newly copied news post. Previously, the author was kept correctly. But since a couple of weeks the author in the page title header is replaced with a seemingly random user. Does anyone else have this issue? And how can I prevent this from happening? Many thanks for all help provided! Read More
Another spilled array that I can’t solve – Aggregating monthly into time periods
This I thought would be quite easy but hit a brick wall at each attempt.
In summary, I am trying to use a spilled array to sum up expenses into time periods.
So I have a 5 year projection and say 5 different expense lines, each with a different start and end date (end could be the end of the forecast or before) The expenses are accrued monthly but I want the flexibility to aggregate them into Applied Periods ie when they will be paid. Let’s say rent. Say $100 per month but paid every three months so $300 every 3 months. I already have the monthly amounts all worked out – its is much more complex than this simple scenario and integrates, manual overrides, and fixed expenses and ones driven off factors etc but the results of these all fall into a nice Spilled Array of 10 rows by a dynamic number of columns depending of length of forecast and intervals etc.
So here will will only focus on the bit I need to resolve. I want the monthly rent to be summed into intervals of say 3 months. One row may have a 6 month interval and another a 1 month interval. As they start and (may end) in different periods, the applied period must start from x months after the first expense accrual. So if the first rent starts in month 2 and is paid 3 monthly then the first payment would total the first 3 months from period 2, paid in period 5. Each row could be different but the applied periods will be fixed for each line throughout.
I tried to create flags using Makearray which worked and my intention was to use scan and reset it at each flag. But I cannot see how to integrate 2 arrays into the scan function. The one with the expenses and the one with the flags. I tried using Map and then using scan inside the map lambda but it wouldn’t aggregate. It nearly worked other than that. I tried using indexing to get the column and row of the flags to rest the scan function but referencing another array that was not part of the scan function just gave me calc errors. There are a few times I would like to use 2 arrays in a scan or a scan inside a map. Just couldn’t find a way to get the row and column of the flag array (both arrays – the data to aggregate and the flags are the same size) but how do I get the row and column count inside scan to use in an index function. Every road seems to lead to a failure.
Sample attached showing my crude attempt – I only got as far as generating flags but couldn’t apply them
Shows original flags to get start date – can’t always rely on a zero value as a contract may start on 1st Jan and include 2 free months. So payment would then be due on third which would be one past the zero. So flags overcome this.
Needs to start at right time with offset from start by No of Applied periods. But can run to end of array as if a n expense ends then it will return a zero so the result will be correct – ie sum of zeros
This I thought would be quite easy but hit a brick wall at each attempt. In summary, I am trying to use a spilled array to sum up expenses into time periods. So I have a 5 year projection and say 5 different expense lines, each with a different start and end date (end could be the end of the forecast or before) The expenses are accrued monthly but I want the flexibility to aggregate them into Applied Periods ie when they will be paid. Let’s say rent. Say $100 per month but paid every three months so $300 every 3 months. I already have the monthly amounts all worked out – its is much more complex than this simple scenario and integrates, manual overrides, and fixed expenses and ones driven off factors etc but the results of these all fall into a nice Spilled Array of 10 rows by a dynamic number of columns depending of length of forecast and intervals etc. So here will will only focus on the bit I need to resolve. I want the monthly rent to be summed into intervals of say 3 months. One row may have a 6 month interval and another a 1 month interval. As they start and (may end) in different periods, the applied period must start from x months after the first expense accrual. So if the first rent starts in month 2 and is paid 3 monthly then the first payment would total the first 3 months from period 2, paid in period 5. Each row could be different but the applied periods will be fixed for each line throughout. I tried to create flags using Makearray which worked and my intention was to use scan and reset it at each flag. But I cannot see how to integrate 2 arrays into the scan function. The one with the expenses and the one with the flags. I tried using Map and then using scan inside the map lambda but it wouldn’t aggregate. It nearly worked other than that. I tried using indexing to get the column and row of the flags to rest the scan function but referencing another array that was not part of the scan function just gave me calc errors. There are a few times I would like to use 2 arrays in a scan or a scan inside a map. Just couldn’t find a way to get the row and column of the flag array (both arrays – the data to aggregate and the flags are the same size) but how do I get the row and column count inside scan to use in an index function. Every road seems to lead to a failure. Sample attached showing my crude attempt – I only got as far as generating flags but couldn’t apply themShows original flags to get start date – can’t always rely on a zero value as a contract may start on 1st Jan and include 2 free months. So payment would then be due on third which would be one past the zero. So flags overcome this. Needs to start at right time with offset from start by No of Applied periods. But can run to end of array as if a n expense ends then it will return a zero so the result will be correct – ie sum of zeros Read More
