{
  "id": "357ef137-7eeb-4c80-a3bb-0951f26a8aff",
  "snapshot": "libreoffice_calc",
  "instruction": "I have calculated the total work hours from the everday hours. And I have an hourly rate. Now I want to multiply the total hours with the hourly rate to get a total earned amount. However, I can't get a correct answer by directly multiply the two cells. Here the \"total hours\" is of time and \"hourly rate\" is just a number. How can I get the correct product of them? Help me fill in the cell the correct answer. Don't touch irrelevant blank regions.",
  "source": "https://www.reddit.com/r/excel/comments/17zny8u/calculating_total_amount_earned_from_total_hours/",
  "config": [
    {
      "type": "download",
      "parameters": {
        "files": [
          {
            "url": "https://huggingface.co/datasets/xlangai/ubuntu_osworld_file_cache/resolve/main/libreoffice_calc/357ef137-7eeb-4c80-a3bb-0951f26a8aff/Multiply_Time_Number.xlsx",
            "path": "/home/user/Multiply_Time_Number.xlsx"
          }
        ]
      }
    },
    {
      "type": "open",
      "parameters": {
        "path": "/home/user/Multiply_Time_Number.xlsx"
      }
    }
  ],
  "trajectory": "trajectories/357ef137-7eeb-4c80-a3bb-0951f26a8aff",
  "related_apps": [
    "libreoffice calc"
  ],
  "evaluator": {
    "postconfig": [
      {
        "type": "activate_window",
        "parameters": {
          "window_name": "Multiply_Time_Number.xlsx - LibreOffice Calc",
          "strict": true
        }
      },
      {
        "type": "sleep",
        "parameters": {
          "seconds": 0.5
        }
      },
      {
        "type": "execute",
        "parameters": {
          "command": [
            "python",
            "-c",
            "import pyautogui; pyautogui.hotkey(\"ctrl\", \"s\");"
          ]
        }
      },
      {
        "type": "sleep",
        "parameters": {
          "seconds": 0.5
        }
      }
    ],
    "func": "compare_table",
    "result": {
      "type": "vm_file",
      "path": "/home/user/Multiply_Time_Number.xlsx",
      "dest": "Multiply_Time_Number.xlsx"
    },
    "options": {
      "rules": [
        {
          "type": "check_cell",
          "sheet_idx": 0,
          "coordinate": "E3",
          "props": {
            "value": {
              "method": "approx:0.001",
              "ref": 191.6667
            }
          }
        }
      ]
    }
  },
  "proxy": false,
  "fixed_ip": false,
  "possibility_of_env_change": "low"
}
