{"id":"https://openalex.org/W4409393804","doi":"https://doi.org/10.1002/cae.70036","title":"ScienSolar: Development of an Open\u2010Source VBA\u2010Excel Based Package to Model 3D Physics Problems Without Coding","display_name":"ScienSolar: Development of an Open\u2010Source VBA\u2010Excel Based Package to Model 3D Physics Problems Without Coding","publication_year":2025,"publication_date":"2025-04-12","ids":{"openalex":"https://openalex.org/W4409393804","doi":"https://doi.org/10.1002/cae.70036"},"language":"en","primary_location":{"id":"doi:10.1002/cae.70036","is_oa":false,"landing_page_url":"https://doi.org/10.1002/cae.70036","pdf_url":null,"source":{"id":"https://openalex.org/S159433931","display_name":"Computer Applications in Engineering Education","issn_l":"1061-3773","issn":["1061-3773","1099-0542"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer Applications in Engineering Education","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5015080419","display_name":"Ariel Becerra","orcid":"https://orcid.org/0009-0005-2373-9961"},"institutions":[{"id":"https://openalex.org/I86843133","display_name":"University of Pamplona","ror":"https://ror.org/04dfr7a85","country_code":"CO","type":"education","lineage":["https://openalex.org/I86843133"]}],"countries":["CO"],"is_corresponding":true,"raw_author_name":"Ariel R. Becerra Becerra","raw_affiliation_strings":["Grupo Integrar, Departamento de Fisica Universidad de Pamplona Pamplona Norte de Santander Colombia"],"raw_orcid":"https://orcid.org/0009-0005-2373-9961","affiliations":[{"raw_affiliation_string":"Grupo Integrar, Departamento de Fisica Universidad de Pamplona Pamplona Norte de Santander Colombia","institution_ids":["https://openalex.org/I86843133"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5017438871","display_name":"A. Herrera","orcid":"https://orcid.org/0000-0001-6602-6228"},"institutions":[{"id":"https://openalex.org/I35961687","display_name":"Universidad de Antioquia","ror":"https://ror.org/03bp5hc83","country_code":"CO","type":"education","lineage":["https://openalex.org/I35961687"]}],"countries":["CO"],"is_corresponding":false,"raw_author_name":"Alvaro Herrera Carrillo","raw_affiliation_strings":["Facultad de Ciencias Exactas y Naturales Universidad de Antioquia Medellin Antioquia Colombia"],"raw_orcid":"https://orcid.org/0000-0001-6602-6228","affiliations":[{"raw_affiliation_string":"Facultad de Ciencias Exactas y Naturales Universidad de Antioquia Medellin Antioquia Colombia","institution_ids":["https://openalex.org/I35961687"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5015080419"],"corresponding_institution_ids":["https://openalex.org/I86843133"],"apc_list":{"value":4150,"currency":"USD","value_usd":4150},"apc_paid":null,"fwci":1.1165,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.78775113,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"33","issue":"3","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9926000237464905,"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.9926000237464905,"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/T13682","display_name":"Engineering Education and Pedagogy","score":0.9710999727249146,"subfield":{"id":"https://openalex.org/subfields/2216","display_name":"Architecture"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11283","display_name":"Experimental Learning in Engineering","score":0.9610999822616577,"subfield":{"id":"https://openalex.org/subfields/2214","display_name":"Media Technology"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/visual-basic-for-applications","display_name":"Visual Basic for Applications","score":0.8504956960678101},{"id":"https://openalex.org/keywords/open-source","display_name":"Open source","score":0.7933968901634216},{"id":"https://openalex.org/keywords/coding","display_name":"Coding (social sciences)","score":0.6401550769805908},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5568345189094543},{"id":"https://openalex.org/keywords/engineering-drawing","display_name":"Engineering drawing","score":0.4906262457370758},{"id":"https://openalex.org/keywords/computer-graphics","display_name":"Computer graphics (images)","score":0.4901896119117737},{"id":"https://openalex.org/keywords/development","display_name":"Development (topology)","score":0.4310429096221924},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.4276021122932434},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.42601096630096436},{"id":"https://openalex.org/keywords/computational-science","display_name":"Computational science","score":0.39395707845687866},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.1918715536594391},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.14540117979049683},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.1385873556137085},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.07425978779792786}],"concepts":[{"id":"https://openalex.org/C115199736","wikidata":"https://www.wikidata.org/wiki/Q667566","display_name":"Visual Basic for Applications","level":2,"score":0.8504956960678101},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.7933968901634216},{"id":"https://openalex.org/C179518139","wikidata":"https://www.wikidata.org/wiki/Q5140297","display_name":"Coding (social sciences)","level":2,"score":0.6401550769805908},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5568345189094543},{"id":"https://openalex.org/C199639397","wikidata":"https://www.wikidata.org/wiki/Q1788588","display_name":"Engineering drawing","level":1,"score":0.4906262457370758},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.4901896119117737},{"id":"https://openalex.org/C2776542497","wikidata":"https://www.wikidata.org/wiki/Q5266672","display_name":"Development (topology)","level":2,"score":0.4310429096221924},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4276021122932434},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.42601096630096436},{"id":"https://openalex.org/C459310","wikidata":"https://www.wikidata.org/wiki/Q117801","display_name":"Computational science","level":1,"score":0.39395707845687866},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.1918715536594391},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.14540117979049683},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.1385873556137085},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.07425978779792786},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1002/cae.70036","is_oa":false,"landing_page_url":"https://doi.org/10.1002/cae.70036","pdf_url":null,"source":{"id":"https://openalex.org/S159433931","display_name":"Computer Applications in Engineering Education","issn_l":"1061-3773","issn":["1061-3773","1099-0542"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer Applications in Engineering Education","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W810630250","https://openalex.org/W1808011207","https://openalex.org/W2052262577","https://openalex.org/W2071842242","https://openalex.org/W2083449791","https://openalex.org/W2091335951","https://openalex.org/W2135892447","https://openalex.org/W2406937957","https://openalex.org/W2768324558","https://openalex.org/W2785489092","https://openalex.org/W2800128592","https://openalex.org/W2989854491","https://openalex.org/W3017857301","https://openalex.org/W3035682062","https://openalex.org/W3095531424","https://openalex.org/W4304183098","https://openalex.org/W4320162348","https://openalex.org/W4403002139"],"related_works":["https://openalex.org/W103849839","https://openalex.org/W2370484803","https://openalex.org/W4365804487","https://openalex.org/W2811389109","https://openalex.org/W1544874996","https://openalex.org/W1914527116","https://openalex.org/W2268119418","https://openalex.org/W2358121726","https://openalex.org/W2555122102","https://openalex.org/W2523225191"],"abstract_inverted_index":{"ABSTRACT":[0],"This":[1,23,114],"study":[2],"presents":[3],"a":[4,18,26],"novel":[5],"modular":[6],"package":[7,24,55,83],"developed":[8],"in":[9,104],"Visual":[10],"Basic":[11],"for":[12,42,63],"Applications":[13],"(VBA)":[14],"that":[15,87],"integrates":[16],"into":[17,78],"macro\u2010enabled":[19],"MS":[20,48],"Excel":[21,49],"workbook.":[22],"creates":[25],"three\u2010dimensional":[27],"coordinate":[28,72],"system":[29],"within":[30],"the":[31,54,61,71,118],"spreadsheet,":[32],"allowing":[33],"users":[34,43],"to":[35,70,126],"model":[36,58],"various":[37],"physics":[38,52,129],"problems":[39],"efficiently.":[40],"Designed":[41],"with":[44],"basic":[45],"knowledge":[46],"of":[47],"and":[50,99,112,121],"fundamental":[51,102],"knowledge,":[53],"enables":[56],"rapid":[57],"development":[59],"without":[60],"need":[62],"programming":[64],"experience.":[65],"Users":[66],"can":[67,75],"add":[68],"vectors":[69],"system,":[73],"which":[74],"be":[76],"transformed":[77],"other":[79],"mathematical":[80],"objects.":[81],"The":[82],"features":[84],"specialized":[85],"cells":[86],"function":[88],"as":[89,107],"coordinates":[90],"or":[91],"time":[92],"variables.":[93],"It":[94],"has":[95],"been":[96],"rigorously":[97],"tested":[98],"includes":[100],"25":[101],"examples":[103],"disciplines":[105],"such":[106],"electrodynamics,":[108],"mechanics,":[109],"thermodynamics,":[110],"optics,":[111],"mathematics.":[113],"tool":[115],"significantly":[116],"simplifies":[117],"modeling":[119],"process":[120],"provides":[122],"an":[123],"accessible":[124],"approach":[125],"solving":[127],"complex":[128],"problems.":[130]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-08-21T09:56:20.448147","created_date":"2025-10-10T00:00:00"}