Kontent qismiga oʻtish

AppSheet: Versiyalar orasidagi farq

Vikipediya, ochiq ensiklopediya
Tarixni interaktiv tarzda koʻrib chiqish
← Avvalgi tahrirKeyingi tahrir →
Kontent oʻchirildi Kontent qoʻshildi
VizualVikimatn
Tahrir izohi yoʻq
Tahrir izohi yoʻq
Teglar: Qoʻlda qaytarildi Koʻrib tahrirlagich
Qator 1: Qator 1:
{{Infobox company
'''Moliyaviy modellashtirish''' - bu real dunyo moliyaviy holatining mavhum tasvirini (modelini) yaratish vazifasidir<ref name="iop">{{Cite web |author = Investopedia Staff| url=http://www.investopedia.com/terms/f/financialmodeling.asp | title=Financial Modeling|date = 2020}}</ref>. Bu moliyaviy aktiv yoki [[biznes]], [[loyiha]] yoki boshqa har qanday investitsiya portfelining (soddalashtirilgan versiyasi) ishlashini aks ettiruvchi matematik modeldir.
| name = AppSheet
| logo =
| native_name_lang =
| image =
| type = Sho'ba korxona
| industry = {{ubl|[[Xizmat ko'rsatish platformasi]] | | [[Dasturiy ta'minot kompaniyasi]]}}
| products = {{unbulleted list|AppSheet platformasi}}
| num_employees = 35 (2019)
| parent = [[Google LLC]]
| homepage = {{URL|https://www.appsheet.com}}
| founded = {{Start date and age|2014}}
| location = [[Seattle, Vashington]], AQSh
}}


'''AppSheet''' – bu mobil, planshet va veb ilovalarni yaratishga imkon beruvchi kodsiz dasturiy taʼminot ishlab chiqish platformasini taqdim etadigan dastur. Ushbu platforma [[Google Drive]], [[Dropbox|DropBox]], [[Office 365]] va boshqa bulutga asoslangan elektron jadvallar va maʼlumotlar bazasi platformalari kabi maʼlumot manbalaridan foydalanadi. Platformani loyihalarni boshqarish, mijozlar bilan munosabatlarni boshqarish, joyida tekshiruvlar oʻtkazish va shaxsiy hisobotlarni tuzish kabi biznes uchun keng qamrovli foydalanish holatlari uchun ishlatish mumkin<ref>{{Cite web|title = Startup Spotlight: AppSheet lets non-developers build custom mobile apps |url=https://www.geekwire.com/2015/appsheet/ | website=geekwire.com|access-date=2018-06-22|language=en-US}}</ref>.
Odatda, moliyaviy modellashtirish aktivni narxlash yoki korporativ moliya bo‘yicha, miqdoriy xususiyatga ega bo‘lgan mashq sifatida tushuniladi. Bu bozorlardagi yoki agentlarning xatti-harakatlari to‘g‘risidagi taxminlarni sonli bashoratlarga tarjima qilish haqida<ref name="[sciencedirect.com](http://sciencedirect.com/)">{{cite journal|last1=Low|first1=R.K.Y.|last2=Tan|first2=E. |title=The Role of Analysts' Forecasts in the Momentum Effect|journal=International Review of Financial Analysis|volume=48|pages=67–84|date=2016|doi=10.1016/j.irfa.2016.09.007|url=https://espace.library.uq.edu.au/view/UQ:406166/UQ406166_OA.pdf}}</ref>. Shu bilan birga, "moliyaviy modellashtirish" umumiy atama bo‘lib, u turli foydalanuvchilar uchun turli narsalarni anglatadi; odatda bu atama buxgalteriya va korporativ moliya qo‘llanmalariga yoki miqdoriy moliya qo‘llanmalariga tegishli.


AppSheet 2020-yilning yanvar oyida [[Google]] tomonidan sotib olindi<ref>Ron Miller, „Google acquires AppSheet to bring no-code development to Google Cloud“, ''TechCrunch'', [https://techcrunch.com/2020/01/14/google-acquires-appsheet-to-bring-no-code-development-to-google-cloud/ January 14, 2020]</ref><ref>{{Cite web |date=2020-01-14 |title=Google acquires no-code app development platform AppSheet |url=https://venturebeat.com/2020/01/14/google-acquires-no-code-app-development-platform-appsheet/ |access-date=2020-06-23 |website=VentureBeat |language=en-US}}</ref><ref>{{Cite web |last=Bridgwater |first=Adrian |title=Google Says Yes To No-Code, Acquires AppSheet |url=https://www.forbes.com/sites/adrianbridgwater/2020/01/17/google-says-yes-to-no-code-acquires-appsheet/ |access-date=2020-06-23 |website=Forbes |language=en}}</ref>.
==Buxgalteriya==
[[File:Cash Flow Projection.png|thumb|Buxgalteriya hisobi Elektron jadval asosida tuzilgan pul oqimini bashorat qilish]]
Korporativ moliya va buxgalteriya kasbida ''moliyaviy modellashtirish'' odatda moliyaviy hisobotlarni prognozlashni o‘z ichiga oladi; odatda, qaror qabul qilish uchun<ref name=iop/> va moliyaviy tahlil uchun foydalaniladigan batafsil kompaniyaga xos modellarni tayyorlashni anglatadi.


== Platforma ==
Qo‘llanilish doirasi quyidagilarni o‘z ichiga oladi:
AppSheet platformasi foydalanuvchilarga bulutga asoslangan elektron jadvallar va [[Maʼlumotlar bazasi|maʼlumotlar bazalaridan]] mobil ilovalarni yaratish imkonini beradi<ref>{{Cite web |title=An Ode to the Underappreciated Spreadsheet |url=https://hbr.org/2016/10/an-ode-to-the-underappreciated-spreadsheet |website=hbr.com |access-date=2018-06-22 |language=en-US}}</ref>. Ilovalarni toʻgʻridan-toʻgʻri Google Sheets kabi elektron jadval platformalaridan qoʻshimcha sifatida yaratish ham mumkin<ref>{{Cite web |title=4 Essential Android Add-Ons for Google Docs and Sheets |url=https://www.pcworld.com/article/3102185/software-productivity/4-essential-android-add-ons-for-google-docs-and-sheets.html |website=pcworld.com |access-date=2018-06-22 |language=en-US}}</ref>. Platforma oʻz-oʻziga xizmat koʻrsatish modeli va yirik tashkilotlar uchun koʻproq boshqaruv, maʼlumotlar tahlili va ishlash imkoniyatlarini taklif qiluvchi korporativ litsenziya modeli sifatida mavjud<ref>{{Cite web |title=Pricing |url=https://www.appsheet.com/pricing |website=appsheet.com |access-date=2019-02-20 |language=en-US}}</ref>. Ilovalarni tezroq takrorlash sikllari bilan ishlab chiqishga imkon beruvchi kam kodli rivojlanish platformalariga nisbatan, AppSheet kodsiz platformadir, bu esa elektron jadvallar va maʼlumotlar bazalari bilan tanish biznes foydalanuvchilarga ilovalarni yaratish imkonini beradi<ref>{{Cite web |title=What No-Code Software Really Looks Like |url=https://www.forbes.com/sites/adrianbridgwater/2019/03/18/what-no-code-software-really-looks-like/#393a8b7f96ce |website=forbes.com |access-date=2019-03-21 |language=en-US}}</ref>.


AppSheet bilan mos keluvchi maʼlumot manbalari quyidagilarni oʻz ichiga oladi:
- Biznes qiymatini va aksiyalarni baholash - ayniqsa, diskontlangan pul oqimi orqali, lekin boshqa baholash yo'lllarini ham o‘z ichiga oladi
- Senariy rejalashtirish va boshqaruv qarorlarini qabul qilish ("nima mavjud"; "agar nima bo‘lsa"; "nima qilish kerak"<ref name="SiegelShim1997">{{cite book|author1=Joel G. Siegel|author2=Jae K. Shim|author3=Stephen Hartman|title=Schaum's quick guide to business formulas: 201 decision-making tools for business, finance, and accounting students|url=https://books.google.com/books?id=4JpojQPk8YsC|access-date=12 November 2011|date=1 November 1997|publisher=McGraw-Hill Professional|isbn=978-0-07-058031-2}} §39 "Corporate Planning Models". See also, §294 "Simulation Model".</ref>)
- Byudjetlashtirish: daromadlarni prognozlash va tahlil qilish; ishlab chiqarishni byudjetlashtirish; operatsiyalarni byudjetlashtirish
- Kapitalni byudjetlashtirish, shu jumladan kapitalning qiymati (ya'ni WACC) hisob-kitoblari
- Pul oqimini prognozlash; aylanma kapital va xazina boshqaruvi; aktiv va majburiyatlarni boshqarish
- Moliyaviy hisobot tahlili / nisbiy tahlil (shu jumladan, operatsion va moliyaviy ijara shartlari hamda ilmiy-tadqiqot ishlari)
- Tranzaksiya tahlili: M&A, PE, VC, LBO, IPO, Loyihani moliyalashtirish,<ref>See for example: {{Cite web |title=Renewable Energy Financial Model |url=https://courses.renewablesvaluationinstitute.com/pages/academy/financial-model-user-guide |access-date=2023-03-19 |website=Renewables Valuation Institute |language=en}}</ref> P3
- Kredit qarorlari: Kredit tahlili, Iste'molchilar kredit xavfi; kredit yo‘qotish va ta'minot modellashtirish
- Boshqaruv buxgalteriyasi: Faoliyat asosida xarajatlarni hisoblash, Rentabellik tahlili, Xarajatlar tahlili, Umr bo‘yi xarajatlar, Menejerlik xavf buxgalteriyasi
- Davlat sektori xarid qilishi<ref>[[Confidentiality|Confidential]] disclosure of a financial model is often requested by purchasing organizations undertaking [[Government procurement|public sector procurement]] in order that the government department can understand and if necessary challenge the pricing principles which underlie a bidder's costs. E.g. [[First-tier Tribunal]], [https://www.bailii.org/uk/cases/UKFTT/GRC/2010/2010_0073.html Department for Works and Pensions v. Information Commissioner], UKFTT EA_2010_0073, paragraph 58, decided 20 September 2010, accessed 11 January 2024</ref>


– Google Sheets
Ushbu modellar haqida umumiylashtirish uchun: birinchidan, ular moliyaviy hisobotlar atrofida qurilganligi sababli, hisob-kitoblar va natijalar oylik, choraklik yoki yillik bo‘ladi; ikkinchidan, kirish ma'lumotlari "farazlar" shaklida bo‘ladi, bu yerda tahlilchi har bir davrda qo‘llaniladigan tashqi / global o‘zgaruvchilar (valyuta kurslari, soliq foizi va boshqalar) uchun qiymatlarni belgilaydi (madel parametrlari sifatida qaralishi mumkin) va ichki / kompaniyaga xos o‘zgaruvchilar (ish haqi, tannarx va boshqalar) uchun. Shunga mos ravishda, ikkala xususiyat ham ushbu modellar matematik shaklida (kamida, bilvosita) aks ettiriladi: birinchidan, modellarda diskret vaqt o‘lchovi qo‘llaniladi; ikkinchidan, ular deterministikdir.


– Google Forms
Bu kasb egalari ko‘pincha "moliyaviy tahlilchi" deb ataladi (va ba'zida hazil tariqasida "raqam maydalovchilar" deb ham ataladi). Odatda<ref name="Fairhurst">{{Cite book |last=Fairhurst |first=Danielle Stein |url=https://books.google.com/books?id=X_9REAAAQBAJ |title=Financial Modeling in Excel for Dummies |publisher=John Wiley & Sons |year=2022 <!-- publication date in the future, but available on google books somehow --> |isbn=978-1-119-84451-8 |location= |oclc=1264716849}}</ref>, modelchi MBA yoki MSF ni "moliyaviy modellashtirish" bo‘yicha (ixtiyoriy) kurs bilan tugatgan bo‘ladi<ref>Example course: [https://study.unisa.edu.au/courses/013613/2022 Financial Modelling], [[University of South Australia]]</ref>. Buxgalteriya malakalari va moliya sertifikatlari, masalan, CIIA va CFA odatda modellashtirish bo‘yicha bevosita yoki aniq o‘qitishni ta'minlamaydi<ref name="ft">[http://www.ft.com/cms/s/2/db7a4838-1352-11e5-ad26-00144feabdc0.html#ft-article-comments ''The MiF can offer an edge over the CFA''] [[Financial Times]], June 21, 2015.</ref>. Shu bilan birga, ko‘plab tijorat trening kurslari ham universitetlar orqali, ham xususiy tarzda taklif etiladi.


– Microsoft Excel (Office 365)
Garchi maqsadli biznes dasturi mavjud bo‘lsa-da, bozorning katta qismi elektron jadval asosida tuziladi; bu asosan, modellar deyarli har doim kompaniyaga xos bo‘lgani uchun. Shuningdek, tahlilchilar moliyaviy modellashtirish uchun o‘zlarining mezonlari va usullariga ega bo‘ladi<ref>See for example, [https://ssrn.com/abstract=256987 Valuing Companies by Cash Flow Discounting: Ten Methods and Nine Theories], Pablo Fernandez: University of Navarra - IESE Business School</ref>. [[Microsoft Excel]] hozirda Lotus 1-2-3 ni 1990-yillarda ortda qoldirib, ancha kuchli o‘ringa ega. Elektron jadval asosida modellashtirishning o‘z muammolari bo‘lishi mumkin<ref>Danielle Stein Fairhurst (2009). [http://www.fimodo.com/2009/11/six-reasons-your-spreadsheet-is-not-a-financial-model/ Six reasons your spreadsheet is NOT a financial model] {{webarchive|url=https://web.archive.org/web/20100407003951/http://www.fimodo.com/2009/11/six-reasons-your-spreadsheet-is-not-a-financial-model/ |date=2010-04-07 }}, fimodo.com</ref> va bir necha standartlashtirish va "eng yaxshi amaliyotlar" taklif qilingan<ref name="EuSpRIG">[http://www.eusprig.org/best-practice.htm Best Practice] {{Webarchive|url=https://web.archive.org/web/20180329184059/http://www.eusprig.org/best-practice.htm |date=2018-03-29 }}, European Spreadsheet Risks Interest Group</ref>. "Elektron jadval xavfi" tobora ko‘proq o‘rganilmoqda va boshqarilmoqda<ref name="EuSpRIG" />.


– Microsoft Excel (Dropbox)
One critique here, is that model ''outputs'', i.e. [[Chart of accounts|line items]], often inhere "unrealistic implicit assumptions" and "internal inconsistencies". (For example, a forecast for growth in revenue but without corresponding increases in [[working capital]], [[fixed assets]] and the associated financing, may imbed unrealistic assumptions about [[asset turnover]], [[Debt ratio|debt level]] and/or [[Equity (finance)|equity financing]]. See {{section link|Sustainable growth rate|From a financial perspective}}.) What is required, but often lacking, is that all key elements are explicitly and consistently forecasted.
Related to this, is that modellers often additionally "fail to identify crucial assumptions" relating to ''inputs'', "and to explore what can go wrong". Here, in general, modellers "use point values and simple arithmetic instead of probability distributions and statistical measures"<ref>[[Peter Coffee]] (2004). [http://www.eweek.com/c/a/Database/Spreadsheets-25-Years-in-a-Cell/ ''Spreadsheets: 25 Years in a Cell''], [[eWeek]].</ref>


– Microsoft Excel (Box kompaniyasi)
Asosiy o'ylantiradigan narsa, model natijalari, ya'ni chiziqli elementlar ko‘pincha "haqiqiy bo‘lmagan noaniq farazlar" va "ichki nomuvofiqliklar" ni o‘z ichiga oladi<ref name="PalepuHealy2007">{{cite book|author1=Krishna G. Palepu|author2=Paul M. Healy|author3=Erik Peek|author4=Victor Lewis Bernard|title=Business analysis and valuation: text and cases|url=https://books.google.com/books?id=DPK43Sku2PsC&pg=261|access-date=12 November 2011|year=2007|publisher=Cengage Learning EMEA|isbn=978-1-84480-492-4|pages=261–}}</ref>. (Masalan, daromadlarning o‘sishi prognozi, lekin aylanma kapital, asosiy aktivlar va tegishli moliyalashtirish bo‘yicha tegishli o‘sishlarsiz, aktivlar aylanishi, qarz miqdori va/yoki kapitalni moliyalashtirish bo‘yicha haqiqatga to‘g‘ri kelmaydigan taxminlarni o‘z ichiga olishi mumkin) Bu yerda kerak bo‘lgan narsa, lekin ko‘pincha etishmaydigan narsa shundaki, barcha asosiy elementlar aniq va izchil prognoz qilinishi kerak. Bunga tegishli ravishda, modellashtiruvchilar ko‘pincha kiritishlar bilan bog‘liq bo‘lgan "muhim farazlarni aniqlay olmaydi" va "nima noto‘g‘ri bo‘lishi mumkinligini o‘rganmaydi"<ref name="BrealeyMyers2003">{{cite book|author1=Richard A. Brealey|author2=Stewart C. Myers|author3=Brattle Group|title=Capital investment and valuation|url=https://books.google.com/books?id=eKF8IBCwfy4C&pg=PA223|access-date=12 November 2011|year=2003|publisher=McGraw-Hill Professional|isbn=978-0-07-138377-6|pages=223–}}</ref>. Bu yerda, odatda, modellashtiruvchilar "aniq qiymatlar va oddiy arifmetika" dan foydalanadilar, ya'ni muammolar deterministik tabiatda ko‘rib chiqiladi va shuning uchun aktiv yoki loyiha uchun bitta qiymat hisoblanadi, lekin natijalar diapazoni, dispersiyasi va sezgirligi bo‘yicha ma'lumot bermaydi<ref>Prof. [[Aswath Damodaran]]. [http://pages.stern.nyu.edu/~adamodar/pdfiles/papers/probabilistic.pdf ''Probabilistic Approaches: Scenario Analysis, Decision Trees and Simulations''], NYU Stern Working Paper</ref>. Bundan tashqari, umumiy tanqid, modellashtiruvchilar orasida asosiy kompyuter dasturlash tushunchalarining etishmasligi bilan bog‘liq bo‘lib<ref>Blayney, P. (2009). [https://www.learntechlib.org/p/31495/ Knowledge Gap? Accounting Practitioners Lacking Computer Programming Concepts as Essential Knowledge]. In G. Siemens & C. Fulford (Eds.), Proceedings of World Conference on Educational Multimedia, Hypermedia and Telecommunications 2009 (pp. 151-159). Chesapeake, VA: AACE.</ref>, natijada ularning modellarining tuzilishi yaxshi emas va saqlash qiyin. Jiddiy tanqid byudjetlashtirishning mohiyati va uning tashkilotga ta'siriga ham qaratilgan<ref>Loren Gary (2003). [http://hbswk.hbs.edu/item/3623.html ''Why Budgeting Kills Your Company''], Harvard Management Update, May 2003.</ref><ref>[[Michael C. Jensen|Michael Jensen]] (2001).
[https://ssrn.com/abstract=321520 ''Corporate Budgeting Is Broken, Let's Fix It''], [[Harvard Business Review]], pp. 94-101, November 2001.</ref>.


– Smartsheet
==Miqdoriy moliya==
[[File:OAS valuation tree (es).png|thumb|Foiz stavkasini "daraxt" shaklida tasvirlash - odatda tijorat derivativ dasturlari tomonidan qaytariladi]]


– Salesforce
Miqdoriy moliyada, moliyaviy modellashtirish murakkab matematik modelni ishlab chiqishni o‘z ichiga oladi<ref name="SIAM">See discussion here: {{cite web |url=https://www.siam.org/Portals/0/Student%20Programs/Thinking%20of%20a%20Career/brochure.pdf |archive-url=https://web.archive.org/web/20190305095047/[https://www.siam.org/Portals/0/Student Programs/Thinking of a Career/brochure.pdf](https://www.siam.org/Portals/0/Student%20Programs/Thinking%20of%20a%20Career/brochure.pdf) |archive-date=2019-03-05 |url-status=live |title=Careers in Applied Mathematics|publisher=[[Society for Industrial and Applied Mathematics]]}}</ref>. Bu yerda modellar aktiv narxlari, bozor harakatlari, portfel daromadlari va shunga o‘xshashlarni o‘z ichiga oladi. Umuman olganda, quyidagi yo‘nalishlar farqlanadi:


– DreamFactory
(i) "Miqdoriy aktiv baholash", turli aksiyalarning daromadlarini modellashtirish;


– Microsoft SQL Server
(ii) "Moliyaviy muhandislik", derivativ qimmatli qog‘ozlarining narxi yoki daromadlarini modellashtirish;


– MySQL
(iii) "Miqdoriy portfelni boshqarish", avtomatlashtirilgan savdo, yuqori chastotali savdo, algoritmik savdo va dasturiy savdoni asoslovchi modellar


– PostgreSQL
Shu bilan bog‘liq ravishda qo‘llanish sohalari quyidagilardan iborat:


– Amazon DynamoDB<ref>{{Cite web |title=How to make an app |url=https://www.appsheet.com/how_to_make_an_app |website=appsheet.com |access-date=2019-02-20 |language=en-US}}</ref>
* Optsion narxlash va ularning "Greeks" ni hisoblash (uchuvchi sirtlarini qabul qiluvchi - mahalliy/stoxastik uchuvchi modellar va ko‘p egri chiziqlar orqali)
* Boshqa derivativlar, ayniqsa foiz stavkalari derivativlari, kredit derivativlari va ekzotik derivativlar
* Foiz stavkalarining muddatiy tuzilmasini modellashtirish (bootstrapping/ko‘p egri chiziqlar, qisqa stavkali modellar, HJM framework) va shunga bog‘liq kredit spreadlari
* Kredit baholash sozlamasi, CVA, shuningdek, turli xil XVA
* Kredit xavfi, qarz oluvchi kredit xavfi va tartibga soluvchi kapital: EAD, PD, LGD, PFE, EE; Jarrow-Turnbull modeli, Merton modeli, KMV modeli
* Strukturaviy mahsulotlarni loyihalash va ishlab chiqarish
* Portfel optimallashtirish<ref>See for example: {{cite journal|last1=Low|first1=R.K.Y.|last2=Faff|first2=R.|last3=Aas|first3=K.|title=Enhancing mean–variance portfolio selection by modeling distributional asymmetries|journal=Journal of Economics and Business|volume=85|pages=49–72|date=2016|doi=10.1016/j.jeconbus.2016.01.003|url=https://espace.library.uq.edu.au/view/UQ:377912/UQ377912_OA.pdf}}; {{cite journal|last1=Low|first1=R.K.Y.|last2=Alcock|first2=J.|last3=Faff|first3=R.|last4=Brailsford|first4=T.|title=Canonical vine copulas in the context of modern portfolio management: Are they worth it?|journal=Journal of Banking & Finance|date=2013|volume=37|issue=8|pages=3085–3099|doi= 10.1016/j.jbankfin.2013.02.036|s2cid=154138333 |url=https://espace.library.uq.edu.au/view/UQ:297895/EC15UQ297895.pdf}}</ref> va miqdoriy investitsiya qilishning umumiy yondashuvi; bu yerda qo‘llaniladigan optimallashtirish usullari haqida ko‘proq ma'lumot
* Moliyaviy xavf modellashtirish: risk qiymati (parametrik va/yoki tarixiy, CVaR, EVT), stress sinovi, "sezgirliklar" tahlili (Greeks, duration, convexity, DV01, KRD, CS01, JTD)
* Korporativ moliya qo‘llanishi:<ref name="Shimko">See David Shimko (2009). [https://web.archive.org/web/20100717072252/http://www.qfinance.com/financial-risk-management-best-practice/quantifying-corporate-financial-risk?full Quantifying Corporate Financial Risk]. archived 2010-07-17.</ref> pul oqimi tahlillari<ref>See for example [https://brainly.in/question/7072253 this problem] (from [[John C. Hull (economist)|John Hull's]] ''Options, Futures, and Other Derivatives''), discussing cash position modeled stochastically.</ref>, korporativ moliyalash faoliyatini prognoz qilish muammolari va kapital investitsiyasidagi xavf tahlillari
* Real optsionlar
* Aktuar qo‘llanilishi: Dinamik moliyaviy tahlil (DFA), UIBFM, investitsion modellashtirish


== Xususiyatlari ==
Bu muammolar, odatda, stoxastik va uzluksiz xarakterga ega bo‘lib, bu modellar [[Murakkab algoritmlar|murakkab algoritmlarni]] talab qiladi, bu esa kompyuter simulyatsiyasini, ilg‘or raqamli usullarni (masalan, raqamli differensial tenglamalar, raqamli chiziqli algebra, dinamik dasturlash) va/yoki optimallashtirish modellarini ishlab chiqishni o‘z ichiga oladi.
=== '''Maʼlumotlarni yigʻish''' ===
AppSheet ilovalari maʼlumotlarni rasmlar, imzolar, geolokatsiya, shtrix kodlar va NFC shaklida yigʻadi. Maʼlumotlar avtomatik ravishda bulutga sinxronlanadi yoki foydalanuvchilar maʼlumotlarni istalgan vaqtda qoʻlda sinxronlashni tanlashi mumkin. Maʼlumotlarni yigʻishning keng tarqalgan ishlatilishlari orasida joy yoki uskunalarni tekshirish, xavfsizlik tekshiruvlari, hisobot berish va inventarni boshqarish kiradi<ref>{{Cite web |title=How to make an app |url=https://www.appsheet.com/how_to_make_an_app |website=appsheet.com |access-date=2019-02-20 |language=en-US}}</ref>.


=== '''Maʼlumotlarni hamkorlik qilish''' ===
Modellovchilar odatda "kvantlar", ya'ni miqdoriy tahlilchilar deb ataladi va odatda statistik, fizika, muhandislik, kompyuter fanlari, matematika yoki operatsion tadqiqotlar kabi kvantitativ fanlar bo‘yicha ilg‘or (Ph.D. darajasidagi) bilimga ega bo‘ladilar.
Sinxronlangan va umumiy maʼlumotlar foydalanuvchilarga mobil yoki ish stoli qurilmalari orqali hamkorlik qilish imkonini beradi. Ish jarayonlari qoidalari mos keladigan joylarda bildirishnomalar yoki ishga asoslangan topshiriqlarni ishga tushirish uchun ishlatilishi mumkin. Maʼlumotlar qurilmada saqlanadi va internetga ulanish tiklangandan keyin sinxronlanadi, bu esa oflayn rejimda kirishni ham taʼminlaydi<ref>{{Cite web |title=Teams and Collaboration |url=https://help.appsheet.com/teams-and-collaboration |website=appsheet.com |access-date=2019-02-20 |language=en-US}}</ref>.


=== '''Maʼlumotlarni koʻrsatish''' ===
Alternatively, or in addition to their quantitative background, they complete a [[Master of Finance|finance masters]] with a quantitative orientation, such as the [[Master of Quantitative Finance]], or the more specialized [[Master of Computational Finance]] or [[Master of Financial Engineering]]; the [[Certificate in Quantitative Finance|CQF]] certificate is increasingly common.
AppSheet maʼlumotlari grafik va interaktiv formatlarda koʻrsatilishi mumkin. Keng tarqalgan maʼlumot koʻrinishlari orasida jadvallar, shakllar, xaritalar, diagrammalar, taqvimlar va boshqaruv panellari mavjud. Har bir ilova turli manbalardan olingan maʼlumotlardan iborat bir nechta koʻrinishni oʻz ichiga olishi mumkin<ref>{{Cite web |title=Views |url=https://help.appsheet.com/ux/views/views-the-essentials |website=appsheet.com |access-date=2019-02-20 |language=en-US}}</ref>.


=== '''Deklarativ dasturlash modeli''' ===
Yoki, ularning kvantitativ bilimiga qo‘shimcha ravishda, ular kvantitativ yo‘nalishga ega moliyaviy magistratura dasturlarini tugatadilar<ref name="Joshi">[[Mark S. Joshi]], [http://www.markjoshi.com/downloads/advice.pdf ''On Becoming a Quant''] {{Webarchive|url=https://web.archive.org/web/20120114045604/[http://www.markjoshi.com/downloads/advice.pdf|date=2012-01-14](http://www.markjoshi.com/downloads/advice.pdf%7Cdate=2012-01-14)}}.</ref>, masalan, Miqdoriy moliya magistri, yoki ko‘proq ixtisoslashgan Hisoblash moliyasi magistri yoki Moliyaviy muhandislik magistri; CQF sertifikati tobora keng tarqalmoqda.
AppSheet platformasi foydalanuvchilarga anʼanaviy koddan foydalanmasdan ilovaning foydalanuvchi tajribasini sozlash uchun ilovaning faoliyati mantiqini eʼlon qilish imkonini beradi. Ushbu mavhumlik darajasi anʼanaviy kod orqali mavjud boʻlgan batafsil sozlash darajasini samaradorlik, masshtablash va xavfsizlikni oshirish uchun deklarativ model orqali mavjud boʻlgan afzalliklarga almashtiradi<ref>{{Cite web|title = What No-Code Software Really Looks Like |url=https://www.forbes.com/sites/adrianbridgwater/2019/03/18/what-no-code-software-really-looks-like/#393a8b7f96ce | website=forbes.com|access-date=2019-03-21|language=en-US}}</ref>.


== Xavfsizlik ==
Bu yerda ham elektron jadvallar keng qo‘llanilsa-da (deyarli har doim keng qamrovli VBA talab qiladi); maxsus [[C++]], [[Fortran]] yoki Python, yoki [[MATLAB]] kabi raqamli tahlil dasturlari tez-tez afzal ko‘riladi<ref name="Joshi" />, ayniqsa, barqarorlik yoki tezlik muammosi bo‘lgan hollarda. MATLAB ko‘pincha tadqiqot yoki prototiplash bosqichida qo‘llaniladi, chunki uning dasturlash, grafik va debugging vositalari intuitiv hisoblanadi, lekin C++/Fortran MATLAB juda sekin bo‘lgan hollarda kontseptual jihatdan sodda, ammo yuqori hisoblash xarajatli qo‘llanilishlar uchun afzal ko‘riladi; Python esa uning soddaligi va katta standart kutubxonasi / mavjud dasturlari, shu jumladan QuantLib tufayli tobora ko‘proq qo‘llanilmoqda.
Maʼlumotlar foydalanuvchining qurilmasida va foydalanuvchining mavjud bulutga asoslangan saqlash tizimida saqlanadi. Foydalanuvchilar ilovalarini sinxronlashtirganda, ular kiritgan oʻzgarishlar shriflangan protokol (HTTPS) orqali AppSheet veb-xizmatiga yuboriladi. Keyin AppSheet ushbu oʻzgarishlarni orqa fondagi elektron jadvallar (Google Drive, Dropbox va boshqalar) bilan qoʻllaydi. Elektron jadval yoki maʼlumotlar bazasining soʻnggi versiyasi (Google Drive, Dropbox va boshqalardan) oʻqiladi va mobil ilovaga qaytariladi<ref>{{Cite web|title = Understanding the Secure Flow of Data|url=https://help.appsheet.com/security/understanding-the-secure-flow-of-data| website=appsheet.com|access-date=2019-02-20|language=en-US}}</ref>.


AppSheet platformasi, shuningdek, SOC2 ga muvofiq ekanligi tasdiqlangan<ref>{{Cite web|title = AppSheet Information Security|url=https://solutions.appsheet.com/hubfs/AppSheet_Information_Security.pdf| website=appsheet.com|access-date=2019-02-20|language=en-US}}</ref>.
Bundan tashqari, ko‘plab (standart) derivativ va portfel qo‘llanishlari uchun tijorat dasturlari mavjud va modelning uyda ishlab chiqilishi yoki mavjud mahsulotlarning joriy etilishi muammoga bog‘liq bo‘ladi<ref name="Joshi" />.


== Tarix ==
Ushbu modellar murakkabligi noto‘g‘ri narxlash yoki hedging yoki ikkalasiga olib kelishi mumkin. Bu Model xavfi moliya olimlari tomonidan davom etayotgan tadqiqot mavzusidir va risk boshqaruvi sohasida katta va ortib borayotgan qiziqish mavzusidir<ref>[[Riccardo Rebonato]] (N.D.). [http://www.quarchome.org/ModelRisk.pdf ''Theory and Practice of Model Risk Management''].</ref>.
AppSheet dastlab Praveen Seshadri tomonidan 2014 yil mart oyida, [[Seattle]], Vashingtondagi uyida bir necha oy davomida mahsulotni ishlab chiqqandan soʻng tashkil etilgan<ref>{{Cite web|title = AppSheet |url=https://www.geekwire.com/2015/appsheet/ | website=geekwire.com|access-date=2018-06-22|language=en-US}}</ref>.


2015 yilda AppSheet New Enterprise Associates’dan birinchi mablagʻini oldi<ref>{{Cite web|title = Startup Spotlight: AppSheet lets non-developers build custom mobile apps |url=http://www.nea.com/portfolio/appsheet | website=nea.com|access-date=2018-06-22|language=en-US}}</ref>.
== Moliyaviy modellashtirish falsafasi ==
Moliyaviy modellashtirish falsafasi — bu modellashtirish fanining asoslari, usullari va oqibatlari bilan shug'ullanadigan falsafa tarmog'idir.


2018 yilda AppSheet TiE tomonidan innovatsion texnologik startaplarni tan oluvchi Tie50 mukofotiga sazovor boʻldi<ref>{{Cite web|title = TiE Inflect 2018 announces AppSheet as a 2018 TiE50 Winner |url=http://markets.businessinsider.com/news/stocks/tie-inflect-2018-announces-appsheet-as-a-2018-tie50-winner-1023244889 | website=Business Insider|access-date=2018-06-21|language=en-US}}</ref>.
Moliyaviy modellashtirish falsafasida, olimlar yaqinda moliyaviy modellovchilar har qanday "haqiqiy dunyo" yoki amalda davom etayotgan investitsiya holatini aks ettirishga intilishadi degan umumiy qabul qilingan farazni shubha ostiga qo'ya boshladilar. Buning o'rniga, moliyaviy modellovchining vazifasi dastlab modelda taxmin qilingan cheklangan imkoniyatlar bazasidan kelib chiqib, investitsiya ssenariysida tranzaksiya imkoniyatini namoyish etishdan iborat ekanligi taklif qilinmoqda<ref name="Mebius">{{cite journal |last= Mebius |first= A. |year= 2023 |title= On the epistemic contribution of financial models |journal= Journal of Economic Methodology |volume = 30 | issue = 1 |pages= 49–62 |doi= 10.1080/1350178X.2023.2172447|s2cid= 256438018 |doi-access= free }}</ref>.


2018 yilda AppSheet SPEC’ni ishga tushirdi, bu dasturchi boʻlmaganlarga oddiy ingliz tilida nima qurishni xohlayotganliklarini soʻrab, ilovalarni yaratishga imkon beruvchi tabiiy til dasturlash vositasi<ref>{{Cite web | title= AppSheet's new 'Spec' feature aims to make apps easier to build using natural language, without code | url= https://www.geekwire.com/2018/appsheets-new-spec-feature-aims-make-apps-easier-build-using-natural-language-without-code/ | website= Geek Wire |access-date= 2018-06-21|language=en-US}}</ref>.
==Havolalar ==
{{Reflist}}


2018 va 2019 yillarda AppSheet Forrester Research tomonidan biznes ishlab chiquvchilari uchun mobil kam kodli platformalar uchun yetakchi deb eʼlon qilindi<ref>{{Cite web | title= The Forrester Wave™: Mobile Low-Code Platforms For Business Developers, Q3 2018 | url= https://www.forrester.com/report/The+Forrester+Wave+Mobile+LowCode+Platforms+For+Business+Developers+Q3+2018/-/E-RES142469# | website= Forrester | access-date= 2019-02-19 | language= en-US | archive-url= https://web.archive.org/web/20180815201231/https://www.forrester.com/report/The+Forrester+Wave+Mobile+LowCode+Platforms+For+Business+Developers+Q3+2018/-/E-RES142469 | archive-date= 2018-08-15 | url-status= dead }}</ref><ref>{{Cite web |title=The Forrester Wave™: Mobile Low-Code Platforms For Business Developers, Q2 2019 |url=https://www.forrester.com/report/The+Forrester+Wave+LowCode+Platforms+For+Business+Developers+Q2+2019/-/E-RES144411 |website=Forrester |access-date=2019-07-17 |language=en-US}}</ref>.
==Bibliography==
{{refbegin|30em}}
'''General'''
*{{cite book | author=Avon, Jack | title=The Financial Modellers VBA Compendium | publisher=[[Begawans Veranda Publishing|Begawans Veranda]] | location=London | year=2017| isbn=978-0-9956-7254-3}}
*{{cite book | author=Benninga, Simon | title=Financial Modeling | url=https://archive.org/details/financialmodelin00benn | url-access=registration | publisher=[[MIT Press]] | location=Cambridge, MA | year=1997| isbn=0-585-13223-2}}
*{{cite book | author=Benninga, Simon | title=Principles of Finance with Excel | publisher=[[Oxford University Press]] | location=New York | year=2006 | isbn=0-19-530150-1}}
*{{cite book | last=Fabozzi | author-link=Frank Fabozzi | first=Frank J. | title=Encyclopedia of Financial Models| publisher=[[John Wiley & Sons|Wiley]] | location=Hoboken, NJ | year=2012| isbn=978-1-118-00673-3}}
*{{cite book | last=Ho | author-link=Thomas Ho (finance) | first=Thomas|author2=Sang Bin Lee | title=The Oxford Guide to Financial Modeling| publisher=[[Oxford University Press]] | location=New York| year=2004 | isbn=978-0-19-516962-1 | author2-link=Sang Bin Lee}}
*{{cite book | author=Sengupta, Chandan| title=Financial Analysis and Modeling Using Excel and VBA, 2nd Edition | publisher=John Wiley & Sons | location=Hoboken, NJ | year=2009| isbn=9780470275603}}
*{{cite book | author=Winston, Wayne | title=Microsoft Excel 2013 Data Analysis and Business Modeling | publisher=[[Microsoft Press]] | year=2014| isbn=978-0735669130}}
*{{Cite book
| last = Yip
| first = Henry
| title = Spreadsheet Applications to securities valuation and investment theories
| publisher = John Wiley and Sons Australia Ltd.
| isbn = 0470807962
| date = 2005
}}


2020 yil 14 yanvarda AppSheet [[Google]] tomonidan sotib olinganini va [[Google Cloud Platform|Google Cloud]] jamoasiga qoʻshilishini eʼlon qildi<ref>{{Cite web|url=https://techcrunch.com/2020/01/14/google-acquires-appsheet-to-bring-no-code-development-to-google-cloud/|title=Google acquires AppSheet to bring no-code development to Google Cloud|last=Miller|first=Ron|date=2020-01-15|website=TechCrunch|url-status=live|archive-url=https://web.archive.org/web/20200116000134/https://techcrunch.com/2020/01/14/google-acquires-appsheet-to-bring-no-code-development-to-google-cloud/?_guc_consent_skip=1579132924|archive-date=2020-01-16|access-date=2020-01-16}}</ref><ref>{{Cite web|url=https://blog.appsheet.com/appsheet-acquired-by-google-cloud|title=AppSheet Acquired by Google Cloud|last=Seshadri|first=Praveen|date=2020-01-16|website=AppSheet|url-status=live|archive-url=https://web.archive.org/web/20200116001312/https://blog.appsheet.com/appsheet-acquired-by-google-cloud|archive-date=2020-01-16|access-date=2020-01-16}}</ref>.
'''Corporate finance'''
*{{cite book | author=Avon, Jack. | title=The Handbook of Financial Modeling |edition= 2nd | url=https://link.springer.com/book/10.1007/978-1-4842-6540-6| publisher=[[Springer Publishing|Springer]] | location=New York | year=2021 | doi=10.1007/978-1-4842-6540-6 | isbn=978-1-4842-6540-6 | s2cid=227164870 }}
*{{cite book | last=Bastick | first=Liam | title=Introduction to Financial Modeling| publisher=[[John Wiley & Sons|Wiley]] | year=2020| isbn=978-1615470662}}
*{{cite book | author=Beech, G. and Thayser, D. | title=Valuations, Mergers and Acquisitions | url=https://global.oup.com/academic/product/valuations-mergers-and-acquisitions-9780199052776| publisher=[[Oxford University Press]] | location=Oxford | year=2015| isbn=978-0-585-13223-5}}
*{{cite book | author=Day, Alastair | title=Mastering Financial Modelling in Microsoft Excel | publisher=[[Pearson Education]] | location=London | year=2007 | isbn=978-0-273-70806-3}}
*{{Cite book|author=Fairhurst, Danielle|url=https://books.google.com/books?id=X_9REAAAQBAJ&pg=PA120|title=Financial Modeling in Excel for Dummies|publisher=John Wiley & Sons|year=2022 <!-- publication date in the future, but available on google books somehow -->|isbn=978-1-119-84451-8|location=|page=120|oclc=1264716849}}
*{{cite book | author=Lynch, Penelope | title=Financial Modelling for Project Finance, 2nd Edition| publisher=Euromoney Trading | year=1997| isbn=9781843745488}}
*{{cite book | author1= Mayes, Timothy R. |author2=Shank, Todd M. | title=Financial Analysis with Microsoft Excel| publisher=[[Cengage Learning]] | location=Boston| year=2014 | isbn= 978-1-285-43227-4|edition=7th}}
*{{cite book | author=Peter K Nevitt |author2=Frank J. Fabozzi | title=Project Financing| publisher=Euromoney Institutional Investor PLC | year=2000 | isbn=978-1-85564-791-6 }}
*{{cite book | author=Ongkrutaraksa, Worapot | title=Financial Modeling and Analysis: A Spreadsheet Technique for Financial, Investment, and Risk Management, 2nd Edition | publisher=[[Pearson Education Australia]] | location=Frenchs Forest | year=2006 | isbn=0-7339-8474-6}}
*{{cite book | author= Palepu, Krishna G. |author2=Paul M. Healy | title= Business Analysis and Valuation Using Financial Statements, 5th Edition | publisher=South-Western College Publishing | location=Boston| year=2012| isbn= 978-1111972288}}
*{{cite book | author=Pignataro, Paul | title=Financial Modeling and Valuation: A Practical Guide to Investment Banking and Private Equity | publisher=Wiley | location=Hoboken, NJ| year=2003 | isbn=978-1118558768}}
*{{cite book | author=Proctor, Scott | title=Building Financial Models with Microsoft Excel: A Guide for Business Professionals, 2nd Edition | publisher=[[John Wiley & Sons|Wiley]] | location=Hoboken, NJ | year=2009 | isbn=978-0-470-48174-5}}
*{{cite book | author= Rees, Michael | title= Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level| publisher=[[John Wiley & Sons|Wiley]] | location=Hoboken, NJ | year=2008| isbn=978-0-470-99744-4}}
*{{cite book | author= Rees, Michael | title= The Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods| publisher=[[John Wiley & Sons|Wiley]] | location=Hoboken, NJ | year=2023| isbn=978-1394157785}}
*{{cite book | author=Soubeiga, Eric | title=Mastering Financial Modeling: A Professional's Guide to Building Financial Models in Excel | publisher=[[McGraw-Hill]] | location=New York | year=2013| isbn=978-0071808507}}
*{{cite book | author=Swan, Jonathan | title=Financial Modelling Special Report | publisher=[[Institute of Chartered Accountants in England & Wales]] | location=London | year=2007 }}
*{{cite book | author=Swan, Jonathan | title=Practical Financial Modelling, 2nd Edition | publisher=[[CIMA Publishing]] | location=London | year=2008 | isbn=978-0-7506-8647-1}}
*{{cite book | author= Tham, Joseph|author2=Ignacio Velez-Pareja| title= Principles of Cash Flow Valuation: An Integrated Market-Based Approach | publisher=[[Elsevier]] | location=Amsterdam | year=2004 | isbn= 0-12-686040-8 }}
*{{cite book | author=Tjia, John | title=Building Financial Models | publisher=[[McGraw-Hill]] | location=New York | year=2003 | isbn=0-07-140210-1}}


== Manbalar ==
'''Quantitative finance'''
<!-- Inline citations added to your article will automatically display here. See https://en.wikipedia.org/wiki/WP:REFB for instructions on how to add citations. -->
*{{cite book | author= Hirsa, Ali| title=Computational Methods in Finance| publisher=[[CRC Press]] | location= [[Boca Raton]]| year=2013| isbn=9781439829578}}
{{reflist}}
*{{cite book | author=Brooks, Robert | title=Building Financial Derivatives Applications with C++| publisher=[[Praeger Publishers|Praeger]] | location=[[Westport, Connecticut|Westport]] | year=2000 | isbn=978-1567202878 }}
*{{cite book | last=Brigo | author-link=Damiano Brigo | first=Damiano |author2=Fabio Mercurio | title=Interest Rate Models - Theory and Practice with Smile, Inflation and Credit| edition= 2nd | publisher= [[Springer Science+Business Media|Springer Finance]] | location=London | year=2006| isbn=978-3-540-22149-4| author2-link=Fabio Mercurio }}
*{{cite book | last=Clewlow| first=Les|author2=Chris Strickland | title=Implementing Derivative Models| publisher=[[John Wiley & Sons|Wiley]] | location=New Jersey| year=1998| isbn=0-471-96651-7}}
*{{cite book | author=Duffy, Daniel | title=Financial Instrument Pricing Using C++ | publisher=Wiley | location=New Jersey| year=2004 | isbn=978-0470855096}}
*{{cite book | last=Fabozzi | author-link=Frank Fabozzi | first=Frank J. | title=Valuation of fixed income securities and derivatives, 3rd Edition | publisher=[[John Wiley & Sons|Wiley]] | location=Hoboken, NJ | year=1998| isbn=978-1-883249-25-0}}
*{{cite book | last=Fabozzi | first=Frank J. |author2=Sergio M. Focardi |author3=Petter N. Kolm | title=Financial Modeling of the Equity Market: From CAPM to Cointegration | publisher=[[John Wiley & Sons|Wiley]] | location=Hoboken, NJ | year=2004 | isbn=0-471-69900-4}}
*{{Cite book
| author = Shayne Fletcher
| author2 = Christopher Gardner
| title = Financial Modelling in Python
| publisher = John Wiley and Sons
| isbn = 978-0-470-74789-6
| date = 2010
}}
*{{cite book | last=Fusai| first=Gianluca |author2=Andrea Roncoroni | title=Implementing Models in Quantitative Finance: Methods and Cases| publisher=[[Springer Science+Business Media|Springer Finance]] | location=London | year=2008| isbn=978-3-540-22348-1}}
*{{cite book | author= Haug, Espen Gaarder| title=The Complete Guide to Option Pricing Formulas, 2nd edition | publisher=[[McGraw-Hill]] | year=2007 | isbn=978-0071389976}}
*{{cite book | title = Interest Rate Modelling in the Multi-Curve Framework | author =M. Henrard | year = 2014 | isbn =978-1137374653 | publisher = Springer}}
*{{cite book | author=Hilpisch, Yves| title=Derivatives Analytics with Python: Data Analysis, Models, Simulation, Calibration and Hedging| publisher=Wiley | location=New Jersey | year=2015 | isbn=978-1-119-03799-6 }}
*{{cite book | last=Jackson | first=Mary |author2=Mike Staunton| title=Advanced modelling in finance using Excel and VBA| publisher=[[John Wiley & Sons|Wiley]] | location=New Jersey| year=2001 | isbn=0-471-49922-6}}
*{{cite book | last=Jondeau | first=Eric |author2=Ser-Huang Poon |author3=Michael Rockinger | title=Financial Modeling Under Non-Gaussian Distributions | publisher=[[Springer Science+Business Media|Springer]] | location=London | year=2007 | isbn=978-1849965996 }}
*{{cite book | author1=Joerg Kienitz|author2=Daniel Wetterau| title= Financial Modelling: Theory, Implementation and Practice with MATLAB Source| publisher=[[John Wiley & Sons|Wiley]] | location=Hoboken, NJ | year=2012 | isbn=978-0470744895}}
*{{cite book | last= Kwok | first= Yue-Kuen | title= Mathematical Models of Financial Derivatives, 2nd edition | publisher= Springer Finance | location= London | year=2008| isbn= 978-3540422884}}
*{{cite book | author=Levy, George | title=Computational Finance: Numerical Methods for Pricing Financial Instruments| publisher=[[Butterworth-Heinemann]] | year=2004 | isbn=978-0750657228 }}
*{{cite book | author=London, Justin | title=Modeling Derivatives in C++ | publisher=Wiley | location=New Jersey| year=2004 | isbn=978-0471654643}}
*{{cite book |author1=Löeffler, G |author2=Posch, P. | title= Credit Risk Modeling using Excel and VBA| publisher=Wiley | location= Hoboken, NJ | year=2011 | isbn= 978-0470660928 }}
*{{cite book | last= Rouah | first= Fabrice Douglas |author2=Gregory Vainberg | title= Option Pricing Models and Volatility Using Excel-VBA | publisher=[[John Wiley & Sons|Wiley]] | location=New Jersey| year=2007| isbn= 978-0471794646 }}
*{{cite book | author= Antoine Savine and Jesper Andreasen | title=Modern Computational Finance: Scripting for Derivatives and xVA| publisher=Wiley| year=2018| isbn=978-1119540786}}
*{{cite book | author= Alexander Sokol | title=Long-Term Portfolio Simulation - For XVA, Limits, Liquidity and Regulatory Capital| publisher=[[Risk (magazine)#Risk Books|Risk Books]]| year=2014| isbn=978-1782720959}}


== Tashqi havolalar ==
- {{Cite book |last=Charles Tapiero |title=Risk and Financial Management: Mathematical and Computational Methods |publisher=John Wiley & Son |year=2004 |isbn=0-470-84908-8}}
* {{official website|http://www.appsheet.com}}
*{{cite book | author1= Humphrey Tung |author2= Donny Lai| author3=Michael Wong|author4 = Stephen Ng | title= Professional Financial Computing Using Excel and VBA | publisher= John Wiley & Sons| year=2010| isbn= 9780470824399 }}
<!-- *{{cite journal|last=Vladimirou|first=Hercules | title=Financial Modeling |url=http://www.informatik.uni-trier.de/~ley/db/journals/anor/anor151.html |volume= 151 |journal=Annals of Operations Research | publisher=[[Springer Science+Business Media|Springer]] | location=Norwell, MA | year=2007 }}
*{{Cite journal| last = Mantegna | first = Rosario N. |author2=Kertesz, Janos | year = 2010 | title = Focus on Statistical Physics Modelling in Economics and Finance | journal = [[New Journal of Physics]] | volume = 13| issue = 2| pages = 025011| doi = 10.1088/1367-2630/13/2/025011| bibcode = 2011NJPh...13b5011M | doi-access = free}} -->
{{refend}}
[[Category:Financial models]]
[[Category:Actuarial science]]
[[Category:Mathematical finance]]
[[Category:Corporate finance]]
[[Category:Computational fields of study]]

2024-yil 3-sentyabr, 17:48 dagi koʻrinishi

AppSheet
Turi Sho'ba korxona
Tarmogʻi
Egasi Google LLC
Qachon asos solingan 2014 (10 yil avval) (2014)
Mahsulot(lar)i
  • AppSheet platformasi
Ishchilar soni 35 (2019)
Vebsayti appsheet.com

AppSheet – bu mobil, planshet va veb ilovalarni yaratishga imkon beruvchi kodsiz dasturiy taʼminot ishlab chiqish platformasini taqdim etadigan dastur. Ushbu platforma Google Drive, DropBox, Office 365 va boshqa bulutga asoslangan elektron jadvallar va maʼlumotlar bazasi platformalari kabi maʼlumot manbalaridan foydalanadi. Platformani loyihalarni boshqarish, mijozlar bilan munosabatlarni boshqarish, joyida tekshiruvlar oʻtkazish va shaxsiy hisobotlarni tuzish kabi biznes uchun keng qamrovli foydalanish holatlari uchun ishlatish mumkin[1].

AppSheet 2020-yilning yanvar oyida Google tomonidan sotib olindi[2][3][4].

Platforma

AppSheet platformasi foydalanuvchilarga bulutga asoslangan elektron jadvallar va maʼlumotlar bazalaridan mobil ilovalarni yaratish imkonini beradi[5]. Ilovalarni toʻgʻridan-toʻgʻri Google Sheets kabi elektron jadval platformalaridan qoʻshimcha sifatida yaratish ham mumkin[6]. Platforma oʻz-oʻziga xizmat koʻrsatish modeli va yirik tashkilotlar uchun koʻproq boshqaruv, maʼlumotlar tahlili va ishlash imkoniyatlarini taklif qiluvchi korporativ litsenziya modeli sifatida mavjud[7]. Ilovalarni tezroq takrorlash sikllari bilan ishlab chiqishga imkon beruvchi kam kodli rivojlanish platformalariga nisbatan, AppSheet kodsiz platformadir, bu esa elektron jadvallar va maʼlumotlar bazalari bilan tanish biznes foydalanuvchilarga ilovalarni yaratish imkonini beradi[8].

AppSheet bilan mos keluvchi maʼlumot manbalari quyidagilarni oʻz ichiga oladi:

– Google Sheets

– Google Forms

– Microsoft Excel (Office 365)

– Microsoft Excel (Dropbox)

– Microsoft Excel (Box kompaniyasi)

– Smartsheet

– Salesforce

– DreamFactory

– Microsoft SQL Server

– MySQL

– PostgreSQL

– Amazon DynamoDB[9]

Xususiyatlari

Maʼlumotlarni yigʻish

AppSheet ilovalari maʼlumotlarni rasmlar, imzolar, geolokatsiya, shtrix kodlar va NFC shaklida yigʻadi. Maʼlumotlar avtomatik ravishda bulutga sinxronlanadi yoki foydalanuvchilar maʼlumotlarni istalgan vaqtda qoʻlda sinxronlashni tanlashi mumkin. Maʼlumotlarni yigʻishning keng tarqalgan ishlatilishlari orasida joy yoki uskunalarni tekshirish, xavfsizlik tekshiruvlari, hisobot berish va inventarni boshqarish kiradi[10].

Maʼlumotlarni hamkorlik qilish

Sinxronlangan va umumiy maʼlumotlar foydalanuvchilarga mobil yoki ish stoli qurilmalari orqali hamkorlik qilish imkonini beradi. Ish jarayonlari qoidalari mos keladigan joylarda bildirishnomalar yoki ishga asoslangan topshiriqlarni ishga tushirish uchun ishlatilishi mumkin. Maʼlumotlar qurilmada saqlanadi va internetga ulanish tiklangandan keyin sinxronlanadi, bu esa oflayn rejimda kirishni ham taʼminlaydi[11].

Maʼlumotlarni koʻrsatish

AppSheet maʼlumotlari grafik va interaktiv formatlarda koʻrsatilishi mumkin. Keng tarqalgan maʼlumot koʻrinishlari orasida jadvallar, shakllar, xaritalar, diagrammalar, taqvimlar va boshqaruv panellari mavjud. Har bir ilova turli manbalardan olingan maʼlumotlardan iborat bir nechta koʻrinishni oʻz ichiga olishi mumkin[12].

Deklarativ dasturlash modeli

AppSheet platformasi foydalanuvchilarga anʼanaviy koddan foydalanmasdan ilovaning foydalanuvchi tajribasini sozlash uchun ilovaning faoliyati mantiqini eʼlon qilish imkonini beradi. Ushbu mavhumlik darajasi anʼanaviy kod orqali mavjud boʻlgan batafsil sozlash darajasini samaradorlik, masshtablash va xavfsizlikni oshirish uchun deklarativ model orqali mavjud boʻlgan afzalliklarga almashtiradi[13].

Xavfsizlik

Maʼlumotlar foydalanuvchining qurilmasida va foydalanuvchining mavjud bulutga asoslangan saqlash tizimida saqlanadi. Foydalanuvchilar ilovalarini sinxronlashtirganda, ular kiritgan oʻzgarishlar shriflangan protokol (HTTPS) orqali AppSheet veb-xizmatiga yuboriladi. Keyin AppSheet ushbu oʻzgarishlarni orqa fondagi elektron jadvallar (Google Drive, Dropbox va boshqalar) bilan qoʻllaydi. Elektron jadval yoki maʼlumotlar bazasining soʻnggi versiyasi (Google Drive, Dropbox va boshqalardan) oʻqiladi va mobil ilovaga qaytariladi[14].

AppSheet platformasi, shuningdek, SOC2 ga muvofiq ekanligi tasdiqlangan[15].

Tarix

AppSheet dastlab Praveen Seshadri tomonidan 2014 yil mart oyida, Seattle, Vashingtondagi uyida bir necha oy davomida mahsulotni ishlab chiqqandan soʻng tashkil etilgan[16].

2015 yilda AppSheet New Enterprise Associates’dan birinchi mablagʻini oldi[17].

2018 yilda AppSheet TiE tomonidan innovatsion texnologik startaplarni tan oluvchi Tie50 mukofotiga sazovor boʻldi[18].

2018 yilda AppSheet SPEC’ni ishga tushirdi, bu dasturchi boʻlmaganlarga oddiy ingliz tilida nima qurishni xohlayotganliklarini soʻrab, ilovalarni yaratishga imkon beruvchi tabiiy til dasturlash vositasi[19].

2018 va 2019 yillarda AppSheet Forrester Research tomonidan biznes ishlab chiquvchilari uchun mobil kam kodli platformalar uchun yetakchi deb eʼlon qilindi[20][21].

2020 yil 14 yanvarda AppSheet Google tomonidan sotib olinganini va Google Cloud jamoasiga qoʻshilishini eʼlon qildi[22][23].

Manbalar

  1. ↑ „Startup Spotlight: AppSheet lets non-developers build custom mobile apps“ (en-US). geekwire.com. Qaraldi: 2018-yil 22-iyun.
  2. ↑ Ron Miller, „Google acquires AppSheet to bring no-code development to Google Cloud“, TechCrunch, January 14, 2020
  3. ↑ „Google acquires no-code app development platform AppSheet“ (en-US). VentureBeat (2020-yil 14-yanvar). Qaraldi: 2020-yil 23-iyun.
  4. ↑ Bridgwater, Adrian „Google Says Yes To No-Code, Acquires AppSheet“ (en). Forbes. Qaraldi: 2020-yil 23-iyun.
  5. ↑ „An Ode to the Underappreciated Spreadsheet“ (en-US). hbr.com. Qaraldi: 2018-yil 22-iyun.
  6. ↑ „4 Essential Android Add-Ons for Google Docs and Sheets“ (en-US). pcworld.com. Qaraldi: 2018-yil 22-iyun.
  7. ↑ „Pricing“ (en-US). appsheet.com. Qaraldi: 2019-yil 20-fevral.
  8. ↑ „What No-Code Software Really Looks Like“ (en-US). forbes.com. Qaraldi: 2019-yil 21-mart.
  9. ↑ „How to make an app“ (en-US). appsheet.com. Qaraldi: 2019-yil 20-fevral.
  10. ↑ „How to make an app“ (en-US). appsheet.com. Qaraldi: 2019-yil 20-fevral.
  11. ↑ „Teams and Collaboration“ (en-US). appsheet.com. Qaraldi: 2019-yil 20-fevral.
  12. ↑ „Views“ (en-US). appsheet.com. Qaraldi: 2019-yil 20-fevral.
  13. ↑ „What No-Code Software Really Looks Like“ (en-US). forbes.com. Qaraldi: 2019-yil 21-mart.
  14. ↑ „Understanding the Secure Flow of Data“ (en-US). appsheet.com. Qaraldi: 2019-yil 20-fevral.
  15. ↑ „AppSheet Information Security“ (en-US). appsheet.com. Qaraldi: 2019-yil 20-fevral.
  16. ↑ „AppSheet“ (en-US). geekwire.com. Qaraldi: 2018-yil 22-iyun.
  17. ↑ „Startup Spotlight: AppSheet lets non-developers build custom mobile apps“ (en-US). nea.com. Qaraldi: 2018-yil 22-iyun.
  18. ↑ „TiE Inflect 2018 announces AppSheet as a 2018 TiE50 Winner“ (en-US). Business Insider. Qaraldi: 2018-yil 21-iyun.
  19. ↑ „AppSheet's new 'Spec' feature aims to make apps easier to build using natural language, without code“ (en-US). Geek Wire. Qaraldi: 2018-yil 21-iyun.
  20. ↑ „The Forrester Wave™: Mobile Low-Code Platforms For Business Developers, Q3 2018“ (en-US). Forrester. 2018-yil 15-avgustda asl nusxadan arxivlangan. Qaraldi: 2019-yil 19-fevral.
  21. ↑ „The Forrester Wave™: Mobile Low-Code Platforms For Business Developers, Q2 2019“ (en-US). Forrester. Qaraldi: 2019-yil 17-iyul.
  22. ↑ Miller, Ron „Google acquires AppSheet to bring no-code development to Google Cloud“. TechCrunch (2020-yil 15-yanvar). 2020-yil 16-yanvarda asl nusxadan arxivlangan. Qaraldi: 2020-yil 16-yanvar.
  23. ↑ Seshadri, Praveen „AppSheet Acquired by Google Cloud“. AppSheet (2020-yil 16-yanvar). 2020-yil 16-yanvarda asl nusxadan arxivlangan. Qaraldi: 2020-yil 16-yanvar.

Tashqi havolalar

"https://uz.wikipedia.org/w/index.php?title=AppSheet&oldid=4934560" dan olindi