{"id":"W4229447676","doi":"10.33423/jabe.v24i2.5142","title":"Building Decision Support Systems in Excel for Production and Distribution Planning: A Case Study","year":2022,"lang":"en","type":"article","venue":"Journal of Applied Business and Economics","topic":"Spreadsheets and End-User Computing","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"","keywords":"Microsoft excel; Production (economics); Computer science; Decision support system; Plan (archaeology); Linear programming; Distribution (mathematics); Operations research; Production planning; Industrial engineering; Software engineering; Engineering; Operating system; Data mining; Algorithm; Economics; Mathematics","routes":{"ca_aff":false,"ca_fund":false,"ca_venue":true,"about_ca":false,"invisible_to_affiliation_only":true},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0009138932,0.0000783197,0.0002008962,0.0001259847,0.0002244878,0.0001735497,0.0001278777,0.00001810605,3.922915e-7],"category_scores_gemma":[0.00001641498,0.00007416278,0.00001581748,0.0001381721,0.00001039123,0.0002696622,0.0001891455,0.00009774221,3.393505e-8],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00008957809,"about_ca_system_score_gemma":0.00004541617,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00004381653,"about_ca_topic_score_gemma":0.000005330595,"domain_scores_codex":[0.9992386,0.000009266567,0.0003788051,0.0001942827,0.00005831485,0.0001207056],"domain_scores_gemma":[0.9994737,0.00006012001,0.0002741169,0.0001001038,0.00005220709,0.00003973746],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"simulation_or_modeling","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.0004735291,0.0004698662,0.02240939,0.000113406,0.00006090159,0.0005898056,0.006303529,0.7778994,0.0002091038,0.00857472,0.0003652416,0.1825311],"study_design_scores_gemma":[0.007179706,0.00125052,0.08244865,0.0001700865,0.00009644424,0.03371695,0.0312819,0.8250264,0.00008031899,0.006445962,0.01139562,0.0009074321],"study_design_candidate":"simulation_or_modeling","study_design_consensus":"simulation_or_modeling","genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.8920498,0.00008354276,0.1068908,0.00007239601,0.0006794123,0.0002098476,0.000001859766,0.000005861036,0.000006441647],"genre_scores_gemma":[0.9951674,0.00001399741,0.004637147,0.00001175218,0.0001472217,0.00001482904,8.277502e-7,0.000005622819,0.000001138707],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.1816236,"threshold_uncertainty_score":0.302427,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02762079940403908,"score_gpt":0.2577027448683702,"score_spread":0.2300819454643311,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}