{"id":"https://openalex.org/W4401590957","doi":"https://doi.org/10.30741/jid.v2i2.1299","title":"Statistical Application Using Visual Basic For Application (VBA) Excel","display_name":"Statistical Application Using Visual Basic For Application (VBA) Excel","alternate_titles":[],"publication_year":2024,"publication_date":"2024-04-30","ids":{"openalex":"https://openalex.org/W4401590957","doi":"https://doi.org/10.30741/jid.v2i2.1299"},"language":"en","primary_location":{"id":"doi:10.30741/jid.v2i2.1299","doi":"https://doi.org/10.30741/jid.v2i2.1299","is_oa":true,"landing_page_url":"http://dx.doi.org/10.30741/jid.v2i2.1299","pdf_url":"https://ejournal.itbwigalumajang.ac.id/index.php/jid/article/download/1299/696","source":{"id":"https://openalex.org/S4389157802","display_name":"Journal of Informatics Development","issn_l":"2963-055X","issn":["2963-055X","2963-0568"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":["sinta-s5"],"host_organization":"https://openalex.org/I4405274619","host_organization_name":"Institut Teknologi dan Bisnis Widya Gama Lumajang","host_organization_lineage":["https://openalex.org/I4405274619"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Informatics Development","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W4401590957"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://ejournal.itbwigalumajang.ac.id/index.php/jid/article/download/1299/696","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5069380810","display_name":"Subandi Subandi","orcid":"https://orcid.org/0009-0002-1540-6014","observed_orcids":["https://orcid.org/0009-0002-1540-6014"]},"institutions":[{"id":"https://openalex.org/I4405275329","display_name":"Akademi Manajemen Administrasi Yogyakarta","ror":"https://ror.org/03d68yq35","country_code":"ID","type":"education","lineage":["https://openalex.org/I4405275329"]}],"countries":["ID"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Subandi Subandi","raw_affiliation_strings":["Akademi Manajemen Administrasi Yogyakarta"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Akademi Manajemen Administrasi Yogyakarta","institution_ids":["https://openalex.org/I4405275329"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5069380810"],"corresponding_institution_ids":["https://openalex.org/I4405275329"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"2","issue":"2","first_page":"1","last_page":"17"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.8198000192642212,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.8198000192642212,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.13179999589920044,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11734","display_name":"Decision Support System Applications","score":0.026200000196695328,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/statistical-software","display_name":"statistical software","score":0.7360000014305115},{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft Excel","score":0.8209999799728394},{"id":"https://openalex.org/keywords/visual-basic-for-applications","display_name":"Visual Basic for Applications","score":0.9850000143051147},{"id":"https://openalex.org/keywords/statistical-analysis","display_name":"statistical analysis","score":0.515999972820282},{"id":"https://openalex.org/keywords/user-friendly-interface","display_name":"user-friendly interface","score":0.675000011920929},{"id":"https://openalex.org/keywords/non-technical-users","display_name":"non-technical users","score":0.8479999899864197}],"concepts":[{"id":"https://openalex.org/C115199736","wikidata":"https://www.wikidata.org/wiki/Q667566","display_name":"Visual Basic for Applications","level":2,"score":0.9687285423278809},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6519625186920166},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.5607551336288452},{"id":"https://openalex.org/C3018901056","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Ms excel","level":2,"score":0.521143913269043},{"id":"https://openalex.org/C2986587452","wikidata":"https://www.wikidata.org/wiki/Q938438","display_name":"Statistical analysis","level":2,"score":0.5155634880065918},{"id":"https://openalex.org/C2777315864","wikidata":"https://www.wikidata.org/wiki/Q15853013","display_name":"Visual Basic","level":3,"score":0.49884653091430664},{"id":"https://openalex.org/C3019730874","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Microsoft excel","level":2,"score":0.4948689341545105},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.29862022399902344},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.29146671295166016},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2199890911579132},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.18253549933433533},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.17050474882125854},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.14444264769554138}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.30741/jid.v2i2.1299","doi":"https://doi.org/10.30741/jid.v2i2.1299","is_oa":true,"landing_page_url":"http://dx.doi.org/10.30741/jid.v2i2.1299","pdf_url":"https://ejournal.itbwigalumajang.ac.id/index.php/jid/article/download/1299/696","source":{"id":"https://openalex.org/S4389157802","display_name":"Journal of Informatics Development","issn_l":"2963-055X","issn":["2963-055X","2963-0568"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":["sinta-s5"],"host_organization":"https://openalex.org/I4405274619","host_organization_name":"Institut Teknologi dan Bisnis Widya Gama Lumajang","host_organization_lineage":["https://openalex.org/I4405274619"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Informatics Development","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.30741/jid.v2i2.1299","doi":"https://doi.org/10.30741/jid.v2i2.1299","is_oa":true,"landing_page_url":"http://dx.doi.org/10.30741/jid.v2i2.1299","pdf_url":"https://ejournal.itbwigalumajang.ac.id/index.php/jid/article/download/1299/696","source":{"id":"https://openalex.org/S4389157802","display_name":"Journal of Informatics Development","issn_l":"2963-055X","issn":["2963-055X","2963-0568"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":["sinta-s5"],"host_organization":"https://openalex.org/I4405274619","host_organization_name":"Institut Teknologi dan Bisnis Widya Gama Lumajang","host_organization_lineage":["https://openalex.org/I4405274619"],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Informatics Development","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4401590957.pdf","grobid_xml":"https://content.openalex.org/works/W4401590957.grobid-xml"},"referenced_works_count":8,"referenced_works":["https://openalex.org/W2892785855","https://openalex.org/W3020662430","https://openalex.org/W3090857130","https://openalex.org/W3197698830","https://openalex.org/W4205198288","https://openalex.org/W4384566045","https://openalex.org/W4389794534","https://openalex.org/W4413063240"],"related_works":["https://openalex.org/W2370002027","https://openalex.org/W7048917817","https://openalex.org/W2503455793","https://openalex.org/W216703259","https://openalex.org/W2382429792","https://openalex.org/W7216797401","https://openalex.org/W2222104245","https://openalex.org/W2945674813","https://openalex.org/W4402461960","https://openalex.org/W7053307767"],"abstract_inverted_index":{"BandiStats,":[0],"a":[1,11,25,72],"statistical":[2,15,62,79,111],"application,":[3],"was":[4],"developed":[5],"with":[6],"the":[7,32,45],"aim":[8],"of":[9,47,91],"being":[10],"simple":[12],"and":[13,100,107],"easy-to-use":[14,98],"analysis":[16,80],"tool":[17,74],"thanks":[18],"to":[19,87],"its":[20,97],"base":[21],"on":[22],"Microsoft":[23],"Excel,":[24],"well-known":[26],"platform.":[27],"The":[28,40],"development":[29],"method":[30],"used":[31],"Visual":[33],"Basic":[34],"for":[35,75,110],"Application":[36],"(VBA)":[37],"programming":[38],"language.":[39],"application":[41,55,69],"test":[42],"results":[43],"showed":[44],"success":[46],"all":[48],"implemented":[49],"menus.":[50],"This":[51],"research":[52],"produced":[53],"an":[54,105],"that":[56,67],"can":[57,70],"facilitate":[58],"users":[59],"in":[60,81],"analyzing":[61],"data.":[63],"It":[64],"is":[65],"hoped":[66],"this":[68],"be":[71],"useful":[73],"those":[76],"who":[77],"need":[78],"their":[82],"daily":[83],"work":[84],"without":[85],"having":[86],"have":[88],"in-depth":[89],"knowledge":[90],"statistics":[92],"or":[93],"computer":[94],"programming.":[95],"With":[96],"interface":[99],"comprehensive":[101],"features,":[102],"BandiStats":[103],"provides":[104],"efficient":[106],"effective":[108],"solution":[109],"data":[112],"analysis.":[113]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4401590957","counts_by_year":[],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2024-08-15T00:00:00"}
